cityofnewyork-us/nypd-complaint-data-current-year-to-date-5uac-w243
Icon for Socrata external plugin
 
Preview
  • nypd_complaint_data_current_year_to_date
     
 
Readme
Updated 4 months ago
Indexed 5 hours ago

NYPD Complaint Data Current (Year To Date)

This dataset includes all valid felony, misdemeanor, and violation crimes reported to the New York City Police Department (NYPD) for all complete quarters so far this 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_Lon (zip)lat_lon_ziplat_lon_zipText
Y_COORD_CDy_coord_cdy_coord_cdNumberY-coordinate for New York State Plane Coordinate System, Long Island Zone, NAD 83, units feet (FIPS 3104)
X_COORD_CDx_coord_cdx_coord_cdNumberX-coordinate for New York State Plane Coordinate System, Long Island Zone, NAD 83, units feet (FIPS 3104)
VIC_RACEvic_racevic_raceTextVictim’s Race Description
SUSP_SEXsusp_sexsusp_sexTextSuspect’s Sex Description
SUSP_RACEsusp_racesusp_raceTextSuspect’s Race Description
STATION_NAMEstation_namestation_nameTextTransit station name
RPT_DTrpt_dtrpt_dtCalendar dateDate event was reported to police
PREM_TYP_DESCprem_typ_descprem_typ_descTextSpecific description of premises; grocery store, residence, street, etc.
PD_DESCpd_descpd_descTextDescription of internal classification corresponding with PD code (more granular than Offense Description)
PATROL_BOROpatrol_boropatrol_boroTextThe name of the patrol borough in which the incident occurred
PARKS_NMparks_nmparks_nmTextName of NYC park, playground or greenspace of occurrence, if applicable (state parks are not included)
OFNS_DESCofns_descofns_descTextDescription of offense corresponding with key 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
JURIS_DESCjuris_descjuris_descTextDescription of the jurisdiction code
HADEVELOPThadevelopthadeveloptTextName of NYCHA housing development of occurrence, if applicable
CRM_ATPT_CPTD_CDcrm_atpt_cptd_cdcrm_atpt_cptd_cdTextIndicator of whether crime was successfully completed or attempted, but failed or was interrupted prematurely
CMPLNT_FR_TMcmplnt_fr_tmcmplnt_fr_tmTextExact time of occurrence for the reported event (or starting time of occurrence, if CMPLNT_TO_TM exists)
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)
CMPLNT_NUMcmplnt_numcmplnt_numNumberRandomly generated persistent ID for each complaint
LongitudelongitudelongitudeNumberMidblock Longitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326)
LatitudelatitudelatitudeNumberMidblock Latitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326)
VIC_AGE_GROUPvic_age_groupvic_age_groupTextVictim’s Age Group
PD_CDpd_cdpd_cdNumberThree digit internal classification code (more granular than Key Code)
LAW_CAT_CDlaw_cat_cdlaw_cat_cdTextLevel of offense: felony, misdemeanor, violation
KY_CDky_cdky_cdNumberThree digit offense classification code
New Georeferenced Columngeocoded_columngeocoded_columnPoint
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.
CMPLNT_TO_TMcmplnt_to_tmcmplnt_to_tmTextEnding time of occurrence for the reported event, if exact time of occurrence is unknown
ADDR_PCT_CDaddr_pct_cdaddr_pct_cdNumberThe precinct in which the incident occurred
Lat_Lonlat_lonlat_lonPoint
CMPLNT_TO_DTcmplnt_to_dtcmplnt_to_dtCalendar dateEnding date of occurrence for the reported event, if exact time of occurrence is unknown
SUSP_AGE_GROUPsusp_age_groupsusp_age_groupTextSuspect’s Age Group
HOUSING_PSAhousing_psahousing_psaNumberDevelopment Level Code
VIC_SEXvic_sexvic_sexTextVictim’s Sex Description
TRANSIT_DISTRICTtransit_districttransit_districtNumberTransit district in which the offense occurred.
BORO_NMboro_nmboro_nmTextThe name of the borough in which the incident occurred
Police Precincts:@computed_region_sbqj_enih:@computed_region_sbqj_enihNumber
City Council Districts:@computed_region_92fq_4b7q:@computed_region_92fq_4b7qNumber
Borough Boundaries:@computed_region_yeji_bk3q:@computed_region_yeji_bk3qNumber
Community Districts:@computed_region_f5dn_yrer:@computed_region_f5dn_yrerNumber
Zip Codes:@computed_region_efsh_h5xi:@computed_region_efsh_h5xiNumber
Lat_Lon (state)lat_lon_statelat_lon_stateText
Lat_Lon (city)lat_lon_citylat_lon_cityText
Lat_Lon (address)lat_lon_addresslat_lon_addressText
Upstream Metadata