NYC Open Data

Close
Author
NYC OpenData
Description
This dataset includes all valid felony, misdemeanor, and violation crimes reported to the New York City Police Department (NYPD) from 2006 to the end of last year (2015).Offenses occurring at intersections are represented at the X Coordinate and Y Coordinate of the intersection. Crimes occurring anywhere other than an intersection are geo-located to the middle of the block. For additional details, please see the attached data dictionary in the ‘About’ section.
Category
Public Safety
Tags
nypd, incident, crime, complaint, historic, police
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:

CMPLNT_NUM
cmplnt_num
CMPLNT_FR_DT
cmplnt_fr_dt
CMPLNT_FR_TM
cmplnt_fr_tm
CMPLNT_TO_DT
cmplnt_to_dt
CMPLNT_TO_TM
cmplnt_to_tm
ADDR_PCT_CD
addr_pct_cd
RPT_DT
rpt_dt
KY_CD
ky_cd
OFNS_DESC
ofns_desc
PD_CD
pd_cd
PD_DESC
pd_desc
CRM_ATPT_CPTD_CD
crm_atpt_cptd_cd
LAW_CAT_CD
law_cat_cd
BORO_NM
boro_nm
LOC_OF_OCCUR_DESC
loc_of_occur_desc
PREM_TYP_DESC
prem_typ_desc
JURIS_DESC
juris_desc
PARKS_NM
parks_nm
HADEVELOPT
hadevelopt
X_COORD_CD
x_coord_cd
Y_COORD_CD
y_coord_cd
Latitude
latitude
Longitude
longitude
Lat_Lon
lat_lon
Zip Codes
:@computed_region_efsh_h5xi
Community Districts
:@computed_region_f5dn_yrer
Borough Boundaries
:@computed_region_yeji_bk3q
City Council Districts
:@computed_region_92fq_4b7q
Police Precincts
:@computed_region_sbqj_enih

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:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.