Shootings (2006-Present)
This dataset is part of a data collection that includes three related datasets covering shootings, shooting victims, and shooting offenders. For the complete data collection, please follow this link. This dataset identifies every shooting incident that occurred in NYC since 2006.
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.
Fresh
- Says it updates
- Quarterly
- Actually updates about every
- —
- Publisher last updated the data
- Jul 27, 2026
Our mirror
Whether our copy of this data is current with the source.
In sync
- We last synced
- Jul 27, 2026, 11:45 AM
- Rows in our copy
- 24,310
- Rows at the source
- 24,310
- Our copy trails the source by
- under a minute
Columns
Each source column, with the name and type we use to store it.
0 of 13 columns carry a concept; 13 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 |
|---|---|---|---|---|---|---|---|---|
latitude | Latitude | Midblock Latitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326) | Not bound | Number | latitude | numeric | — | |
occur_date | OCCUR_DATE | Exact date of the shooting incident | Not bound | Calendar date | occur_date | timestamp | — | |
boro | BORO | Borough where the shooting incident occurred | Not bound | Text | boro | text | — | |
loc_of_occur_desc | LOC_OF_OCCUR_DESC | Flag indicating where incident occurred | Not bound | Text | loc_of_occur_desc | text | — | |
incident_key | INCIDENT_KEY | Randomly generated persistent ID for each incident | Not bound | Text | incident_key | text | Yes | — |
loc_classfctn_desc | LOC_CLASSFCTN_DESC | Category describing type of location | Not bound | Text | loc_classfctn_desc | text | — | |
precinct | PRECINCT | Precinct where the shooting incident occurred | Not bound | Number | precinct | numeric | — | |
jurisdiction_code | JURISDICTION_CODE | "Jurisdiction where the shooting incident occurred. Jurisdiction codes 0(Patrol), 1(Transit) and 2(Housing) represent NYPD Codes 3 and above represent non NYPD jurisdictions" | Not bound | Number | jurisdiction_code | numeric |
Download
This file was produced on Aug 20, 2026, 9:15 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/5ucz-vwe8
- Version
- Content hash:
0e6281a6bb657295c42044e2442a1c1f937e6c882ba064ac3695871b17d01793 - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- Jul 27, 2026, 11:45 AM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Aug 6, 2026, 3:00 AM | full_replace | success | 24,310 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.47 |
| Aug 5, 2026, 2:15 AM | full_replace | aborted | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.42 |