About this Dataset

Traffic Crashes - People

This data contains information about people involved in a crash and if any injuries were sustained. This dataset should be used in combination with the traffic Crash and Vehicle dataset. Each record corresponds to an occupant in a vehicle listed in the Crash dataset. Some people involved in a crash may not have been an occupant in a motor vehicle, but may have been a pedestrian, bicyclist, or using another non-motor vehicle mode of transportation. Injuries reported are reported by the responding police officer. Fatalities that occur after the initial reports are typically updated in these records up to 30 days after the date of the crash. Person data can be linked with the Crash and Vehicle dataset using the “CRASH_RECORD_ID” field. A vehicle can have multiple occupants and hence have a one to many relationship between Vehicle and Person dataset. However, a pedestrian is a “unit” by itself and have a one to one relationship between the Vehicle and Person table. The Chicago Police Department reports crashes on IL Traffic Crash Reporting form SR1050. The crash data published on the Chicago data portal mostly follows the data elements in SR1050 form. The current version of the SR1050 instructions manual with detailed information on each data elements is available [here](https://idot.illinois.gov/Assets/uploads/files/Transportation-System/Manuals-Guides-&-Handbooks/Safety/Illinois Traffic Crash Report SR 1050 Instruction Manual 2019.pdf). Change 11/21/2023: We have removed the RD_NO (Chicago Police Department report number) for privacy reasons.
Organization: City of Chicago
Last updated: 2020-11-10T16:55:28.497094
Tags: link-to-article-present, public-safety, traffic-crashes, transportation, vision-zero

Tables

Table 1

@usgov.city_of_chicago_traffic_crashes_people.table_1

218.45 MB
2,084,150 rows
29 columns

CREATE TABLE table_1 (
  "person_id" VARCHAR,
  "person_type" VARCHAR,
  "crash_record_id" VARCHAR,
  "vehicle_id" DOUBLE,
  "crash_date" VARCHAR,
  "seat_no" DOUBLE,
  "city" VARCHAR,
  "state" VARCHAR,
  "zipcode" VARCHAR,
  "sex" VARCHAR,
  "age" DOUBLE,
  "drivers_license_state" VARCHAR,
  "drivers_license_class" VARCHAR,
  "safety_equipment" VARCHAR,
  "airbag_deployed" VARCHAR,
  "ejection" VARCHAR,
  "injury_classification" VARCHAR,
  "hospital" VARCHAR,
  "ems_agency" VARCHAR,
  "ems_run_no" VARCHAR,
  "driver_action" VARCHAR,
  "driver_vision" VARCHAR,
  "physical_condition" VARCHAR,
  "pedpedal_action" VARCHAR,
  "pedpedal_visibility" VARCHAR,
  "pedpedal_location" VARCHAR,
  "bac_result" VARCHAR,
  "bac_result_value" DOUBLE,
  "cell_phone_use" VARCHAR
);