ScholarLens Back to search
2020•Zenodo (CERN European Organization for Nuclear Research)Open access

California Traffic Collision Data from SWITRS

Alexander Gude, California Highway Patrol

Open full text 1 citations

Abstract

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, 2020, and 2021. I have combined these datasets into the one presented here. For additional details, see my post: Introducing the SWITRS SQLite Hosted Dataset\n\nThere are three main tables:\n\n- `collisions`: Contains information about the collision, where it happened, what vehicles were involved.\n- `parties`: Contains information about the groups people involved in the collision including age, sex, and sobriety.\n- `victims`: Contains information about the injuries of specific people involved in the collision.\n\nThere is also a table called `case_ids` which I used to build the other tables. It tells you which of the four original datasets each row came from.

About this research paper

What this paper is about

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, 2020, and 2021. I have combined these datasets into the one presented here. For additional details, see my post: Introducing the SWITRS SQLite Hosted Dataset\n\nThere are three main tables:\n\n- `collisions`: Contains information about the collision, where it happened, what vehicles were involved.\n- `parties`: Contains information about the groups people involved in the collision including age, sex, and sobriety.\n- `victims`: Contains information about the injuries of specific people involved in the collision.\n\nThere is also a table called `case_ids` which I used to build the other tables. It tells you which of the four original datasets each row came from.

Why it matters

OpenAlex reports 1 citations for this work. Citation counts describe recorded attention and do not establish research quality.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

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, 2020, and 2021. I have combined these datasets into the one presented here. For additional details, see my post: Introducing the SWITRS SQLite Hosted Dataset\n\nThere are three main tables:\n\n- `collisions`: Contains information about the collision, where it happened, what vehicles were involved.\n- `parties`: Contains information about the groups people involved in the collision including age, sex, and sobriety.\n- `victims`: Contains information about the injuries of specific people involved in the collision.\n\nThere is also a table called `case_ids` which I used to build the other tables. It tells you which of the four original datasets each row came from.

Key concepts: Collision, Computer science, Geography, Computer security

Related papers

Related paper 1Related paper 2Related paper 3
Back to paper searchBrowse research topicsOriginal source
California Traffic Collision Data from SWITRS — Research Paper | ScholarLens