Go to an accessible version of this page

Chicago
Close
Author
Jonathan Levy
Description
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 <a href="https://idot.illinois.gov/Assets/uploads/files/Transportation-System/Manuals-Guides-&-Handbooks/Safety/Illinois Traffic Crash Report SR 1050 Instruction Manual 2019.pdf">here</a>. Change 11/21/2023: We have removed the RD_NO (Chicago Police Department report number) for privacy reasons.
Category
Transportation
Tags
transportation, public safety, vision zero, traffic crashes, link to article present
Rating
Current value: 0 out of 5
Data Provided By
City of Chicago
Source Link
http://www.chicago.gov
License
See Terms of Use
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size

  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

PERSON_ID
person_id
PERSON_TYPE
person_type
CRASH_RECORD_ID
crash_record_id
VEHICLE_ID
vehicle_id
CRASH_DATE
crash_date
SEAT_NO
seat_no
CITY
city
STATE
state
ZIPCODE
zipcode
SEX
sex
AGE
age
DRIVERS_LICENSE_STATE
drivers_license_state
DRIVERS_LICENSE_CLASS
drivers_license_class
SAFETY_EQUIPMENT
safety_equipment
AIRBAG_DEPLOYED
airbag_deployed
EJECTION
ejection
INJURY_CLASSIFICATION
injury_classification
HOSPITAL
hospital
EMS_AGENCY
ems_agency
EMS_RUN_NO
ems_run_no
DRIVER_ACTION
driver_action
DRIVER_VISION
driver_vision
PHYSICAL_CONDITION
physical_condition
PEDPEDAL_ACTION
pedpedal_action
PEDPEDAL_VISIBILITY
pedpedal_visibility
PEDPEDAL_LOCATION
pedpedal_location
BAC_RESULT
bac_result
BAC_RESULT VALUE
bac_result_value
CELL_PHONE_USE
cell_phone_use

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.