Dataset Open Access

California Traffic Collision Data from SWITRS

Gude, Alexander


JSON-LD (schema.org) Export

{
  "description": "<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=\"https://alexgude.com/blog/switrs-sqlite-hosted-dataset/\"><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>", 
  "license": "", 
  "creator": [
    {
      "@id": "https://orcid.org/0000-0002-6935-6094", 
      "@type": "Person", 
      "name": "Gude, Alexander"
    }
  ], 
  "url": "https://zenodo.org/record/4284843", 
  "datePublished": "2020-11-22", 
  "version": "v3.0.0-generated.with.20201024", 
  "keywords": [
    "california", 
    "SWITRS", 
    "California Highway Patrol", 
    "Automobile Crashes", 
    "Traffic Accidents"
  ], 
  "@context": "https://schema.org/", 
  "distribution": [
    {
      "contentUrl": "https://zenodo.org/api/files/a4ed96f8-4cc6-4ba3-a6d4-7c3b97ed7179/switrs.sqlite.gz", 
      "encodingFormat": "gz", 
      "@type": "DataDownload"
    }
  ], 
  "identifier": "https://doi.org/10.34740/kaggle/dsv/1671261", 
  "@id": "https://doi.org/10.34740/kaggle/dsv/1671261", 
  "@type": "Dataset", 
  "name": "California Traffic Collision Data from SWITRS"
}
188
49
views
downloads
Views 188
Downloads 49
Data volume 62.5 GB
Unique views 173
Unique downloads 39

Share

Cite as