cityofnewyork-us/nypd-shooting-incident-data-historic-833y-fsy8

  • crime
  • law enforcement
  • nypd
  • public safety
  • shooting

NYPD Shooting Incident Data (Historic)

NYPD Shooting Incident Data (Historic)

List of every shooting incident that occurred in NYC going back to 2006 through the end of the previous calendar year.

This is a breakdown of every shooting incident that occurred in NYC going back to 2006 through the end of the previous calendar year. This data is manually extracted every quarter and reviewed by the Office of Management Analysis and Planning before being posted on the NYPD website. Each record represents a shooting incident in NYC and includes information about the event, the location and time of occurrence. In addition, information related to suspect and victim demographics is also included. This data can be used by the public to explore the nature of shooting/criminal activity. Please refer to the attached data footnotes for additional information about this dataset.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Police Precincts:@computed_region_sbqj_enih:@computed_region_sbqj_enihNumber
PERP_AGE_GROUPperp_age_groupperp_age_groupTextPerpetrator’s age within a category
Y_COORD_CDy_coord_cdy_coord_cdTextMidblock Y-coordinate for New York State Plane Coordinate System, Long Island Zone, NAD 83, units feet (FIPS 3104)
LatitudelatitudelatitudeNumberLatitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326)
Lon_Latgeocoded_columngeocoded_columnPointLongitude and Latitude Coordinates for mapping
LongitudelongitudelongitudeNumberLongitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326)
VIC_SEXvic_sexvic_sexTextVictim’s sex description
VIC_AGE_GROUPvic_age_groupvic_age_groupTextVictim’s age within a category
STATISTICAL_MURDER_FLAGstatistical_murder_flagstatistical_murder_flagCheckboxShooting resulted in the victim’s death which would be counted as a murder
PERP_SEXperp_sexperp_sexTextPerpetrator’s sex description
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
VIC_RACEvic_racevic_raceTextVictim’s race description
OCCUR_DATEoccur_dateoccur_dateCalendar dateExact date of the shooting incident
JURISDICTION_CODEjurisdiction_codejurisdiction_codeNumberJurisdiction where the shooting incident occurred. Jurisdiction codes 0(Patrol), 1(Transit) and 2(Housing) represent NYPD whilst codes 3 and more represent non NYPD jurisdictions
OCCUR_TIMEoccur_timeoccur_timeTextExact time of the shooting incident
PERP_RACEperp_raceperp_raceTextPerpetrator’s race description
X_COORD_CDx_coord_cdx_coord_cdTextMidblock X-coordinate for New York State Plane Coordinate System, Long Island Zone, NAD 83, units feet (FIPS 3104)
INCIDENT_KEYincident_keyincident_keyTextRandomly generated persistent ID for each arrest
BOROboroboroTextBorough where the shooting incident occurred
PRECINCTprecinctprecinctNumberPrecinct where the shooting incident occurred
LOCATION_DESClocation_desclocation_descTextLocation of the shooting incident

Upstream Metadata