Dataset Open Access
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: 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.
Name | Size | |
---|---|---|
switrs.sqlite.gz
md5:aae412990926fe70320600b2f2dee8a4 |
1.3 GB | Download |
Views | 126 |
Downloads | 36 |
Data volume | 45.9 GB |
Unique views | 115 |
Unique downloads | 28 |