New York City Car Crashes
The New York City dataset is from the New York City Police department crash reports for persons, injuries, and deaths.
| column name | column description | data type |
|---|---|---|
| person_record_id | Primary Key for the person table - Unique record code generated by system | integer |
| crash_record_id | Foreign Key to the crash table - Unique crash identification code | integer |
| crash_date_yyyymmdd | Occurrence date of collision | timestamp without time zone |
| crash_time_24h | Occurrence time of collision | text |
| crash_timestamp_yyyymmdd_24h | Occurrence date and time of crash | timestamp without time zone |
| person_id | Victim identification code assigned by system | text |
| person_type | Bicyclist, Occupant, Pedestrian, etc. | text |
| person_injury_type | Injured, killed, unspecified | text |
| vehicle_record_id | Foreign Key to the vehicle table - Unique vehicle record associated with victim | integer |
| person_age | Automatically calculated based on date of birth | integer |
| person_was_ejected | Not ejected, partially ejected, or ejected from the vehicle | text |
| person_mental_status | Death, unconscious, semiconscious, etc. | text |
| person_bodily_injury | Injured body area (i.e. head, face, neck, etc.) | text |
| person_position_in_vehicle | Seating position #1-#8 (i.e. driver, front passenger, etc.) | text |
| person_safety_equipment | Safety equipment being used (i.e. lap belt, harness, child restraint, air bag, etc.) | text |
| person_pedestrian_location | Location of the pedestrian (i.e. at intersection, not at intersection) | text |
| person_pedestrian_action | What the pedestrian was doing at time of crash (i.e., walking with the signal, against the signal, etc.) | text |
| person_injury_complaint | Type of physical complaint (ex. Concussion, severe burn, severe bleeding, etc.) | text |
| person_role_in_crash | Driver, passenger, pedestrian, etc. | text |
| crash_cause_primary | Factors contributing to the collision for designated vehicle (note, this can be any vehicle number [1-5] from the crash dataset) | text |
| crash_cause_secondary | Factors contributing to the collision for designated vehicle (not often used) | text |
| person_sex | Gender of victim | text |