California Traffic Collision Data from SWITRS

<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, 2020, and 2021. 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> <p>There are three main tables:</p> <p>- `<strong>collisions</strong>`: Contains information about the collision, where it happened, what vehicles were involved.<br> - `<strong>parties</strong>`: Contains information about the groups people involved in the collision including age, sex, and sobriety.<br> - `<strong>victims</strong>`: Contains information about the injuries of specific people involved in the collision.</p> <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>