NYPD Complaint Data Historic
This dataset includes all valid felony, misdemeanor, and violation crimes reported to the New York City Police Department (NYPD) from 2006 to the end of last year (2019). For additional details, please see the attached data dictionary in the ‘About’ section.
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.
FreshNo automatic refresh
- Automatic refresh
No scheduled refresh runs for this dataset. A refresh you ask for on this page runs anyway.
This dataset is large enough that an operator must review it before the automatic queue copies it, and that review has not happened yet.
- Says it updates
- Annually
- Actually updates about every
- —
- Publisher last updated the data
- Apr 28, 2026
Our mirror
Whether our copy of this data is current with the source.
Not mirrored
- We last synced
- —
- Rows in our copy
- —
- Rows at the source
- —
- Our copy trails the source by
- —
Columns
Each source column, with the name and type we use to store it.
2 of 40 columns carry a concept; 35 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 |
|---|---|---|---|---|---|---|---|---|
x_coord_cd | X_COORD_CD | X-coordinate for New York State Plane Coordinate System, Long Island Zone, NAD 83, units feet (FIPS 3104) | Not bound | Number | x_coord_cd | numeric | — | |
lat_lon | Lat_Lon | Geospatial Location Point (latitude and Longitude combined) | Not bound | Point | lat_lon | text | — | |
juris_desc | JURIS_DESC | Description of the jurisdiction code | Not bound | Text | juris_desc | text | — | |
jurisdiction_code | JURISDICTION_CODE | Jurisdiction responsible for incident. Either internal, like Police(0), Transit(1), and Housing(2); or external(3), like Correction, Port Authority, etc. | Not bound | Number | jurisdiction_code | numeric | — | |
parks_nm | PARKS_NM | Name of NYC park, playground or greenspace of occurrence, if applicable (state parks are not included) | Not bound | Text | parks_nm | text | — | |
vic_sex | VIC_SEX | Victim’s Sex Description | Not bound | Text | vic_sex | text | — | |
transit_district | TRANSIT_DISTRICT | Transit district in which the offense occurred. |
Download
A full Parquet copy of this dataset has not been produced yet. The CSV sample is available now, and the rows API returns the whole mirror.
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/qgea-i56i
- Version
- Snapshot taken:
Apr 28, 2026, 12:10 PM - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- —
Update history
We have not recorded an update run for this dataset yet.