NYPD Motor Vehicle Collisions
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
0%
Columns
Columns
29
Categorical
10
Numeric
11
Date/time
2
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 |