ARCHIVED_NYPD Shooting Incident Data (Historic)
NOTE: This NYPD Shooting Incident dataset was replaced with three related datasets – for shootings, shooting victims, and shooting offenders. The new structure should be clearer and easier to use, especially for shootings with multiple victims or multiple offenders. Please follow this link for the most current available information. 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.
Open in the graph · Relate this dataset · What these columns mean
Freshness
The publisher's promise
How the agency that publishes this data says it keeps the data current.
Dormant
- Says it updates
- Historical data
- Actually updates about every
- —
- Publisher last updated the data
- Apr 15, 2025
Our mirror
Whether our copy of this data is current with the source.
In sync
- We last synced
- Apr 15, 2025, 2:16 PM
- Rows in our copy
- 29,744
- Rows at the source
- 29,744
- Our copy trails the source by
- under a minute
Columns
Each source column, with the name and type we use to store it.
2 of 26 columns carry a concept; 19 carry a description from the publisher. Read the concept column before you join. A column with no concept carries no claim from us, and a name that looks like a key is not one.
| Source field | Display name | What the publisher says it is | Concept | Source type | Stored as | Stored type | Row identifier | Unit |
|---|---|---|---|---|---|---|---|---|
loc_classfctn_desc | LOC_CLASSFCTN_DESC | The publisher describes this column nowhere. | Not bound | Text | loc_classfctn_desc | text | — | |
:@computed_region_efsh_h5xi | Zip Codes | The publisher describes this column nowhere. | Not bound | Number | :@computed_region_efsh_h5xi | numeric | — | |
:@computed_region_f5dn_yrer | Community Districts | The publisher describes this column nowhere. | Not bound | Number | :@computed_region_f5dn_yrer | numeric | — | |
vic_race | VIC_RACE | Victim’s race description | Not bound | Text | vic_race | text | — | |
loc_of_occur_desc | LOC_OF_OCCUR_DESC | The publisher describes this column nowhere. |
Download
This file was produced on Aug 20, 2026, 9:17 AM.
Refresh this dataset
Source and attribution
Where this data comes from, which version we hold, and what we changed.
- Source
- https://data.cityofnewyork.us/d/833y-fsy8
- Version
- Content hash:
8b1f655929d6b2994f83d88cff7d55f2f3074384a7c6961b47e47b1964304277 - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- Apr 15, 2025, 2:16 PM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Aug 6, 2026, 3:25 AM | full_replace | success | 29,744 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.47 |