chicago_traffic_crashes
An SQL analysis of traffic accidents within the City of Chicago limits and under the jurisdiction of Chicago Police Department (CPD).
Last updated Apr 21, 2026
20
Stars
5
Forks
0
Issues
0
Stars/day
Attention Score
8
Language breakdown
No language data available.
▸ Files
click to expand
README
Chicago Traffic Crashes
Introduction
An SQL analysis of traffic crash reports on city streets within the City of Chicago limits and under the jurisdiction of Chicago Police Department (CPD). Data shown as is from the electronic crash reporting system (E-Crash) at CPD, excluding any personally identifiable information.Datasets used
Due to the file size restriction on Github, the following dataset for this case study has been split into three (3) individual CSV files.- chicagotrafficcrashespart1.csv: Record Id: 1 - 250,000
- chicagotrafficcrashespart2.csv: Record Id: 251,000 - 500,000
- chicagotrafficcrashespart3.csv: Record Id: 500,001 - 686,277
