New York City Car Crashes
The New York City dataset is from the New York City Police department crash reports for vehicles.
| column name | column description | data type |
|---|---|---|
| vehicle_record_id | Primary Key for the vehicle 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 |
| vehicle_id | Vehicle identification code assigned by system | text |
| vehicle_state_registration | State where driver license was issued | text |
| vehicle_type | Type of vehicle based on the selected vehicle category (ATV, bicycle, car/suv, ebike, escooter, truck/bus, motorcycle, other) | text |
| vehicle_make | Vehicle make | text |
| vehicle_model | Vehicle model | text |
| vehicle_year | Year the vehicle was manufactured | integer |
| vehicle_travel_direction | Direction vehicle was traveling | text |
| vehicle_occupants_total | Number of vehicle occupants | integer |
| vehicle_driver_sex | Gender of driver | text |
| person_driver_license_status | License, permit, unlicensed | text |
| person_driver_license_jurisdiction | NYPD, Port Authority, TBTA, MTA, etc. | text |
| vehicle_pre_crash_action | Going straight, making right turn, passing, backing, etc. | text |
| vehicle_point_of_impact | Location on the vehicle of the initial point of impact (i.e. driver side, passenger side rear, etc.) | text |
| vehicle_damage_main_area | Location on the vehicle where most of the damage occurred | text |
| vehicle_damage_additional_area_1 | Additional damage locations on the vehicle | text |
| vehicle_damage_additional_area_2 | Additional damage locations on the vehicle | text |
| vehicle_damage_additional_area_3 | Additional damage locations on the vehicle | text |
| property_public_damage_yn | Public property damaged (Yes or No) | text |
| property_public_damage_type | Type of public property damaged (ex. Sign, fence, light post, 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 |