Planned intervention: On Thursday March 28th 07:00 UTC Zenodo will be unavailable for up to 5 minutes to perform a database upgrade.
Published November 22, 2020 | Version v3.0.1-generated.with.20210605
Dataset Open

California Traffic Collision Data from SWITRS

Description

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

There are three main tables:

- `collisions`: Contains information about the collision, where it happened, what vehicles were involved.
- `parties`: Contains information about the groups people involved in the collision including age, sex, and sobriety.
- `victims`: Contains information about the injuries of specific people involved in the collision.

There 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.

Files

Files (1.3 GB)

Name Size Download all
md5:a6b09011ec0e83042df2ede0f57c8675
1.3 GB Download