Dataset Open Access

California Traffic Collision Data from SWITRS

Gude, Alexander


JSON Export

{
  "files": [
    {
      "links": {
        "self": "https://zenodo.org/api/files/a4ed96f8-4cc6-4ba3-a6d4-7c3b97ed7179/switrs.sqlite.gz"
      }, 
      "checksum": "md5:aae412990926fe70320600b2f2dee8a4", 
      "bucket": "a4ed96f8-4cc6-4ba3-a6d4-7c3b97ed7179", 
      "key": "switrs.sqlite.gz", 
      "type": "gz", 
      "size": 1275320599
    }
  ], 
  "owners": [
    155994
  ], 
  "doi": "10.34740/kaggle/dsv/1671261", 
  "stats": {
    "version_unique_downloads": 39.0, 
    "unique_views": 173.0, 
    "views": 188.0, 
    "version_views": 188.0, 
    "unique_downloads": 39.0, 
    "version_unique_views": 173.0, 
    "volume": 62490709351.0, 
    "version_downloads": 49.0, 
    "downloads": 49.0, 
    "version_volume": 62490709351.0
  }, 
  "links": {
    "doi": "https://doi.org/10.34740/kaggle/dsv/1671261", 
    "latest_html": "https://zenodo.org/record/4284843", 
    "bucket": "https://zenodo.org/api/files/a4ed96f8-4cc6-4ba3-a6d4-7c3b97ed7179", 
    "badge": "https://zenodo.org/badge/doi/10.34740/kaggle/dsv/1671261.svg", 
    "html": "https://zenodo.org/record/4284843", 
    "latest": "https://zenodo.org/api/records/4284843"
  }, 
  "created": "2020-11-22T23:58:45.652235+00:00", 
  "updated": "2020-11-23T12:27:11.377098+00:00", 
  "conceptrecid": "4284842", 
  "revision": 3, 
  "id": 4284843, 
  "metadata": {
    "access_right_category": "success", 
    "doi": "10.34740/kaggle/dsv/1671261", 
    "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": {
      "id": "other-pd"
    }, 
    "title": "California Traffic Collision Data from SWITRS", 
    "relations": {
      "version": [
        {
          "count": 1, 
          "index": 0, 
          "parent": {
            "pid_type": "recid", 
            "pid_value": "4284842"
          }, 
          "is_last": true, 
          "last_child": {
            "pid_type": "recid", 
            "pid_value": "4284843"
          }
        }
      ]
    }, 
    "version": "v3.0.0-generated.with.20201024", 
    "keywords": [
      "california", 
      "SWITRS", 
      "California Highway Patrol", 
      "Automobile Crashes", 
      "Traffic Accidents"
    ], 
    "publication_date": "2020-11-22", 
    "creators": [
      {
        "orcid": "0000-0002-6935-6094", 
        "name": "Gude, Alexander"
      }
    ], 
    "access_right": "open", 
    "resource_type": {
      "type": "dataset", 
      "title": "Dataset"
    }
  }
}
188
49
views
downloads
Views 188
Downloads 49
Data volume 62.5 GB
Unique views 173
Unique downloads 39

Share

Cite as