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.

• Data Analysis Question & Answers

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.

• chicago_traffic_crashes_part_1.csv: Record Id: 1 - 250,000
• chicago_traffic_crashes_part_2.csv: Record Id: 251,000 - 500,000
• chicago_traffic_crashes_part_3.csv: Record Id: 500,001 - 686,277