Chicago Car Crashes
This table is for all the non-weather columns in the City of Chicago dataset.
This sample crash data comes from the City of Chicago and has all personal data removed.
The City of Chicago requires this disclaimer when using their data:
"This site provides applications using data that has been modified for use from its original source, www.cityofchicago.org, the official website of the City of Chicago. The City of Chicago makes no claims as to the content, accuracy, timeliness, or completeness of any of the data provided at this site. The data provided at this site is subject to change at any time. It is understood that the data provided at this site is being used at one's own risk."
| Column name | Description | Data Type |
|---|---|---|
| ls_id | unique identifier within the life star dataset | integer |
| source | where the data comes from | text |
| source_id | this number also serves as a unique id in this city of chicago crash and people datasets | text |
| crash_date | date of crash as entered by the reporting officer | date |
| crash_time | time of crash as entered by the reporting officer | text |
| location_tz_id | timezone where the crash happened | text |
| lat | latitude of the crash location. | numeric |
| long | longitude of the crash location. | numeric |
| town | town | text |
| city | city | text |
| state | state | text |
| country | country | text |
| total_injured | total persons sustaining fatal, incapacitating, non-incapacitating, and possible injuries as determined by the reporting officer | integer |
| total_killed | total persons sustaining fatal injuries in the crash | integer |
| injury_incapacitated | total persons sustaining incapacitating/serious injuries in the crash as determined by the reporting officer. any injury other than fatal injury, which prevents the injured person from walking, driving, or normally continuing the activities they were capable of performing before the injury occurred. includes severe lacerations, broken limbs, skull or chest injuries, and abdominal injuries. | integer |
| injury_non_incapacitated | total persons sustaining non-incapacitating injuries in the crash as determined by the reporting officer. any injury, other than fatal or incapacitating injury, which is evident to observers at the scene of the crash. includes lump on head, abrasions, bruises, and minor lacerations. | integer |
| most_severe_injury | most severe injury sustained by any person involved in the crash | text |
| crash_type | a general severity classification for the crash. can be either injury and/or tow due to crash or no injury / drive away | text |
| contributory_cause | the factor which was most significant in causing the crash, as determined by officer judgment | text |
| sec_contributory_cause | the factor which was second most significant in causing the crash, as determined by officer judgment | text |
| num_vehicles_in_crash | number of units involved in the crash. a unit can be a motor vehicle, a pedestrian, a bicyclist, or another non-passenger roadway user. each unit represents a mode of traffic with an independent trajectory. | integer |
| crash_hit_and_run | crash did/did not involve a driver who caused the crash and fled the scene without exchanging information and/or rendering aid | text |
| crash_severity | text | |
| traffic_control_device | traffic control device present at crash location, as determined by reporting officer | text |
| traffic_control_device_condition | condition of traffic control device, as determined by reporting officer | text |
| road_defect | road defects, as determined by reporting officer | text |
| crash_timestamp | timestamp of the crash | timestamp without time zone |