New York City Car Crashes
The New York City dataset is from the New York City Police department crash reports.
| column name | column description | data type |
|---|---|---|
| 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 |
| crash_borough | Borough where collision occurred | text |
| crash_zip_code | Postal code of incident occurrence | text |
| crash_lat | Latitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326) | numeric |
| crash_long | Longitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326) | numeric |
| crash_location | Latitude , Longitude pair | text |
| crash_on_street | Street on which the collision occurred | text |
| crash_cross_street | Nearest cross street to the collision | text |
| crash_off_street | Street address if known | text |
| number_of_persons_injured | Number of persons injured | integer |
| number_of_persons_killed | Number of persons killed | integer |
| number_of_pedestrians_injured | Number of pedestrians injured | integer |
| number_of_pedestrians_killed | Number of pedestrians killed | integer |
| number_of_cyclist_injured | Number of cyclists injured | integer |
| number_of_cyclist_killed | Number of cyclists killed | integer |
| number_of_motorist_injured | Number of vehicle occupants injured | integer |
| number_of_motorist_killed | Number of vehicle occupants killed | integer |
| crash_cause_primary_vehicle_1 | Factors contributing to the collision for designated vehicle | text |
| crash_cause_primary_vehicle_2 | Factors contributing to the collision for designated vehicle | text |
| crash_cause_primary_vehicle_3 | Factors contributing to the collision for designated vehicle | text |
| crash_cause_primary_vehicle_4 | Factors contributing to the collision for designated vehicle | text |
| crash_cause_primary_vehicle_5 | Factors contributing to the collision for designated vehicle | text |
| crash_record_id | Primary Key for the crash table - Unique record code generated by system | integer |
| vehicle_type_1 | Type of vehicle based on the selected vehicle category (ATV, bicycle, car/suv, ebike, escooter, truck/bus, motorcycle, other) | text |
| vehicle_type_2 | Type of vehicle based on the selected vehicle category (ATV, bicycle, car/suv, ebike, escooter, truck/bus, motorcycle, other) | text |
| vehicle_type_3 | Type of vehicle based on the selected vehicle category (ATV, bicycle, car/suv, ebike, escooter, truck/bus, motorcycle, other) | text |
| vehicle_type_4 | Type of vehicle based on the selected vehicle category (ATV, bicycle, car/suv, ebike, escooter, truck/bus, motorcycle, other) | text |
| vehicle_type_5 | Type of vehicle based on the selected vehicle category (ATV, bicycle, car/suv, ebike, escooter, truck/bus, motorcycle, other) | text |