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 |