NYC Open Data

Close
Author
NYC OpenData
Description
This is a breakdown of every collision in NYC by location and injury. This data is collected because the NYC Council passed Local Law #11 in 2011. This data is manually run every month and reviewed by the TrafficStat Unit before being posted on the NYPD website. Each record represents a collision in NYC by city, borough, precinct and cross street. This data can be used by the public to see how dangerous/safe intersections are in NYC. The information is presented in pdf and excel format to allow the casual user to just view the information in the easy to read pdf format or use the excel files to do a more in-depth analysis.
Category
Public Safety
Tags
nypd, collisions, bigapps, big apps, visionzero, vision, zero, nycopendata, traffic data
Rating
Current value: 0 out of 5
Data Provided By
Police Department (NYPD)
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

DATE
date
TIME
time
BOROUGH
borough
ZIP CODE
zip_code
LATITUDE
latitude
LONGITUDE
longitude
LOCATION
location
ON STREET NAME
on_street_name
CROSS STREET NAME
off_street_name
OFF STREET NAME
cross_street_name
NUMBER OF PERSONS INJURED
number_of_persons_injured
NUMBER OF PERSONS KILLED
number_of_persons_killed
NUMBER OF PEDESTRIANS INJURED
number_of_pedestrians_injured
NUMBER OF PEDESTRIANS KILLED
number_of_pedestrians_killed
NUMBER OF CYCLIST INJURED
number_of_cyclist_injured
NUMBER OF CYCLIST KILLED
number_of_cyclist_killed
NUMBER OF MOTORIST INJURED
number_of_motorist_injured
NUMBER OF MOTORIST KILLED
number_of_motorist_killed
CONTRIBUTING FACTOR VEHICLE 1
contributing_factor_vehicle_1
CONTRIBUTING FACTOR VEHICLE 2
contributing_factor_vehicle_2
CONTRIBUTING FACTOR VEHICLE 3
contributing_factor_vehicle_3
CONTRIBUTING FACTOR VEHICLE 4
contributing_factor_vehicle_4
CONTRIBUTING FACTOR VEHICLE 5
contributing_factor_vehicle_5
UNIQUE KEY
unique_key
VEHICLE TYPE CODE 1
vehicle_type_code1
VEHICLE TYPE CODE 2
vehicle_type_code2
VEHICLE TYPE CODE 3
vehicle_type_code_3
VEHICLE TYPE CODE 4
vehicle_type_code_4
VEHICLE TYPE CODE 5
vehicle_type_code_5

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

Margins (inches):
Orientation:
Options:
You are viewing a mobile version of this dataset. To access the full dataset, tap here.