Skip to content

Latest commit

 

History

History
13 lines (9 loc) · 919 Bytes

README.md

File metadata and controls

13 lines (9 loc) · 919 Bytes

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.

  • 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