cityofnewyork-us/nypd-complaint-data-historic-qgea-i56i

  • crime
  • incident
  • nycopendata
  • nypd

NYPD Complaint Data Historic

NYPD Complaint Data Historic

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 (2019). For additional details, please see the attached data dictionary in the ‘About’ section.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Lat_Lonlat_lonlat_lonPointGeospatial Location Point (latitude and Longitude combined)
CMPLNT_TO_TMcmplnt_to_tmcmplnt_to_tmTextEnding time of occurrence for the reported event, if exact time of occurrence is unknown
X_COORD_CDx_coord_cdx_coord_cdNumberX-coordinate for New York State Plane Coordinate System, Long Island Zone, NAD 83, units feet (FIPS 3104)
PARKS_NMparks_nmparks_nmTextName of NYC park, playground or greenspace of occurrence, if applicable (state parks are not included)
JURIS_DESCjuris_descjuris_descTextDescription of the jurisdiction code
LOC_OF_OCCUR_DESCloc_of_occur_descloc_of_occur_descTextSpecific location of occurrence in or around the premises; inside, opposite of, front of, rear of
RPT_DTrpt_dtrpt_dtCalendar dateDate event was reported to police
CMPLNT_TO_DTcmplnt_to_dtcmplnt_to_dtCalendar dateEnding date of occurrence for the reported event, if exact time of occurrence is unknown
City Council Districts:@computed_region_92fq_4b7q:@computed_region_92fq_4b7qNumber
Community Districts:@computed_region_f5dn_yrer:@computed_region_f5dn_yrerNumber
Y_COORD_CDy_coord_cdy_coord_cdNumberY-coordinate for New York State Plane Coordinate System, Long Island Zone, NAD 83, units feet (FIPS 3104)
SUSP_AGE_GROUPsusp_age_groupsusp_age_groupTextSuspect’s Age Group
Lat_Lon (address)lat_lon_addresslat_lon_addressText
VIC_RACEvic_racevic_raceTextVictim’s Race Description
VIC_AGE_GROUPvic_age_groupvic_age_groupTextVictim’s Age Group
STATION_NAMEstation_namestation_nameTextTransit station name
LongitudelongitudelongitudeNumberMidblock Longitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326)
HOUSING_PSAhousing_psahousing_psaTextDevelopment Level Code
HADEVELOPThadevelopthadeveloptTextName of NYCHA housing development of occurrence, if applicable
JURISDICTION_CODEjurisdiction_codejurisdiction_codeNumberJurisdiction responsible for incident. Either internal, like Police(0), Transit(1), and Housing(2); or external(3), like Correction, Port Authority, etc.
PREM_TYP_DESCprem_typ_descprem_typ_descTextSpecific description of premises; grocery store, residence, street, etc.
Borough Boundaries:@computed_region_yeji_bk3q:@computed_region_yeji_bk3qNumber
Zip Codes:@computed_region_efsh_h5xi:@computed_region_efsh_h5xiNumber
Police Precincts:@computed_region_sbqj_enih:@computed_region_sbqj_enihNumber
PD_DESCpd_descpd_descTextDescription of internal classification corresponding with PD code (more granular than Offense Description)
PD_CDpd_cdpd_cdNumberThree digit internal classification code (more granular than Key Code)
OFNS_DESCofns_descofns_descTextDescription of offense corresponding with key code
CMPLNT_FR_TMcmplnt_fr_tmcmplnt_fr_tmTextExact time of occurrence for the reported event (or starting time of occurrence, if CMPLNT_TO_TM exists)
Lat_Lon (city)lat_lon_citylat_lon_cityText
PATROL_BOROpatrol_boropatrol_boroTextThe name of the patrol borough in which the incident occurred
LAW_CAT_CDlaw_cat_cdlaw_cat_cdTextLevel of offense: felony, misdemeanor, violation
KY_CDky_cdky_cdNumberThree digit offense classification code
ADDR_PCT_CDaddr_pct_cdaddr_pct_cdNumberThe precinct in which the incident occurred
CMPLNT_FR_DTcmplnt_fr_dtcmplnt_fr_dtCalendar dateExact date of occurrence for the reported event (or starting date of occurrence, if CMPLNT_TO_DT exists)
LatitudelatitudelatitudeNumberMidblock Latitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326)
TRANSIT_DISTRICTtransit_districttransit_districtNumberTransit district in which the offense occurred.
CMPLNT_NUMcmplnt_numcmplnt_numNumberRandomly generated persistent ID for each complaint
SUSP_SEXsusp_sexsusp_sexTextSuspect’s Sex Description
CRM_ATPT_CPTD_CDcrm_atpt_cptd_cdcrm_atpt_cptd_cdTextIndicator of whether crime was successfully completed or attempted, but failed or was interrupted prematurely
SUSP_RACEsusp_racesusp_raceTextSuspect’s Race Description
BORO_NMboro_nmboro_nmTextThe name of the borough in which the incident occurred
Lat_Lon (zip)lat_lon_ziplat_lon_zipText
Lat_Lon (state)lat_lon_statelat_lon_stateText
VIC_SEXvic_sexvic_sexTextVictim’s Sex Description

Upstream Metadata