Dataset Open Access

California Traffic Collision Data from SWITRS

Gude, Alexander

Citation Style Language JSON Export

  "DOI": "10.34740/kaggle/dsv/1671261", 
  "author": [
      "family": "Gude, Alexander"
  "issued": {
    "date-parts": [
  "abstract": "<p>This data comes from the California Highway Patrol and covers collisions from January 1st, 2001 until mid-October, 2020. I have requested full database dumps from the CHP four times, once in 2016, 2017, 2018, and 2020. I have combined these datasets into the one presented here. For additional details, see my post: <a href=\"\"><strong>Introducing the SWITRS SQLite Hosted Dataset</strong></a></p>\n\n<p>There are three main tables:</p>\n\n<p>- `<strong>collisions</strong>`: Contains information about the collision, where it happened, what vehicles were involved.<br>\n- `<strong>parties</strong>`: Contains information about the groups people involved in the collision including age, sex, and sobriety.<br>\n- `<strong>victims</strong>`: Contains information about the injuries of specific people involved in the collision.</p>\n\n<p>There is also a table called `<em>case_ids</em>` which I used to build the other tables. It tells you which of the four original datasets each row came from.</p>", 
  "title": "California Traffic Collision Data from SWITRS", 
  "version": "v3.0.0-generated.with.20201024", 
  "type": "dataset", 
  "id": "4284843"
Views 174
Downloads 49
Data volume 62.5 GB
Unique views 160
Unique downloads 39


Cite as