About this Dataset

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.
Organization: City of New York
Last updated: 2020-11-10T17:01:16.873911
Tags: crime, law-enforcement, nypd, public-safety, shooting

Tables

Table 1

@usgov.city_of_new_york_nypd_shooting_incident_data_historic.table_1

1.36 MB
29744 rows
21 columns


CREATE TABLE table_1 (
  "incident_key" BIGINT,
  "occur_date" TIMESTAMP,
  "occur_time" VARCHAR,
  "boro" VARCHAR,
  "loc_of_occur_desc" VARCHAR,
  "precinct" BIGINT,
  "jurisdiction_code" DOUBLE,
  "loc_classfctn_desc" VARCHAR,
  "location_desc" VARCHAR,
  "statistical_murder_flag" BOOLEAN,
  "perp_age_group" VARCHAR,
  "perp_sex" VARCHAR,
  "perp_race" VARCHAR,
  "vic_age_group" VARCHAR,
  "vic_sex" VARCHAR,
  "vic_race" VARCHAR,
  "x_coord_cd" DOUBLE,
  "y_coord_cd" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "lon_lat" VARCHAR
);