NYPD Motor Vehicle Collisions

By NYC OpenData

New York Police Department motor vehicle collisions from 2012

Product type

Dataset

Update frequency

Daily

Updated

Jun 7, 2023

Delivery method

Download

Metadata is available for each file version of the dataset. A JSON file can be downloaded once you subscribe to the dataset. The information below is an example of the metadata included in each JSON file.

Dataset file name: Motor_Vehicle_Collisions_-_Crashes.csv

Key Statistics

Total records

1,802,739

Missing values

0.992%

Duplicate rows

Columns

Categorical

Numeric

Date/time

Column name	Type	Unique values	Min value	Max value
LONGITUDE	numeric	52,011	-201.35999	0
LATITUDE	numeric	77,711	0	43.344444
NUMBER OF PERSONS INJURED	numeric	27	0	43
NUMBER OF PERSONS KILLED	numeric	7	0	8
NUMBER OF PEDESTRIANS INJURED	numeric	13	0	27
NUMBER OF PEDESTRIANS KILLED	numeric	4	0	6
NUMBER OF CYCLIST INJURED	numeric	5	0	4
NUMBER OF CYCLIST KILLED	numeric	3	0	2
NUMBER OF MOTORIST KILLED	numeric	6	0	5
NUMBER OF MOTORIST INJURED	numeric	27	0	43
COLLISION_ID	numeric	1,802,739	22	4439591
BOROUGH	categorical	6	3	13
ZIP CODE	categorical	233	0	5
CROSS STREET NAME	categorical	12,674	0	32
OFF STREET NAME	categorical	166,061	0	40
CONTRIBUTING FACTOR VEHICLE 3	categorical	51	1	53
CONTRIBUTING FACTOR VEHICLE 4	categorical	40	3	43
CONTRIBUTING FACTOR VEHICLE 5	categorical	30	3	43
VEHICLE TYPE CODE 3	categorical	191	2	35
VEHICLE TYPE CODE 4	categorical	81	2	35
VEHICLE TYPE CODE 5	categorical	56	2	35
LOCATION	text	233,835	3	25
ON STREET NAME	text	12,220	0	32
CONTRIBUTING FACTOR VEHICLE 1	text	62	1	53
CONTRIBUTING FACTOR VEHICLE 2	text	62	1	53
VEHICLE TYPE CODE 1	text	1,262	1	38
VEHICLE TYPE CODE 2	text	1,383	1	38
CRASH DATE	date	3,307	07/01/2012	07/20/2021
CRASH TIME	date	1,440	00:00	23:59