Skip to content

New York City Car Crashes

The New York City dataset is from the New York City Police department crash reports.

Source website

Source disclaimer


column namecolumn descriptiondata type
crash_date_yyyymmddOccurrence date of collisiontimestamp without time zone
crash_time_24hOccurrence time of collisiontext
crash_timestamp_yyyymmdd_24hOccurrence date and time of crashtimestamp without time zone
crash_boroughBorough where collision occurredtext
crash_zip_codePostal code of incident occurrencetext
crash_latLatitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326)numeric
crash_longLongitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326)numeric
crash_locationLatitude , Longitude pairtext
crash_on_streetStreet on which the collision occurredtext
crash_cross_streetNearest cross street to the collisiontext
crash_off_streetStreet address if knowntext
number_of_persons_injuredNumber of persons injuredinteger
number_of_persons_killedNumber of persons killedinteger
number_of_pedestrians_injuredNumber of pedestrians injuredinteger
number_of_pedestrians_killedNumber of pedestrians killedinteger
number_of_cyclist_injuredNumber of cyclists injuredinteger
number_of_cyclist_killedNumber of cyclists killedinteger
number_of_motorist_injuredNumber of vehicle occupants injuredinteger
number_of_motorist_killedNumber of vehicle occupants killedinteger
crash_cause_primary_vehicle_1Factors contributing to the collision for designated vehicletext
crash_cause_primary_vehicle_2Factors contributing to the collision for designated vehicletext
crash_cause_primary_vehicle_3Factors contributing to the collision for designated vehicletext
crash_cause_primary_vehicle_4Factors contributing to the collision for designated vehicletext
crash_cause_primary_vehicle_5Factors contributing to the collision for designated vehicletext
crash_record_idPrimary Key for the crash table - Unique record code generated by systeminteger
vehicle_type_1Type of vehicle based on the selected vehicle category (ATV, bicycle, car/suv, ebike, escooter, truck/bus, motorcycle, other)text
vehicle_type_2Type of vehicle based on the selected vehicle category (ATV, bicycle, car/suv, ebike, escooter, truck/bus, motorcycle, other)text
vehicle_type_3Type of vehicle based on the selected vehicle category (ATV, bicycle, car/suv, ebike, escooter, truck/bus, motorcycle, other)text
vehicle_type_4Type of vehicle based on the selected vehicle category (ATV, bicycle, car/suv, ebike, escooter, truck/bus, motorcycle, other)text
vehicle_type_5Type of vehicle based on the selected vehicle category (ATV, bicycle, car/suv, ebike, escooter, truck/bus, motorcycle, other)text