NYPD Hate Crimes
Dataset containing confirmed hate crime incidents in NYC
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:18 AM
- Rows in our copy
- 4,408
- Rows at the source
- 4,408
- Our copy trails the source by
- under a minute
Columns
Each source column, with the name and type we use to store it.
1 of 14 columns carry a concept; 14 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 |
|---|---|---|---|---|---|---|---|---|
offense_description | Offense Description | A description of the offense | Not bound | Text | offense_description | text | — | |
arrest_id | Arrest Id | Identifier for arrest (if made) | Not bound | Text | arrest_id | text | — | |
offense_category | Offense Category | General categorization of hate crime type | Not bound | Text | offense_category | text | — | |
bias_motive_description | Bias Motive Description | NYPD category of hate crime or bias type | Not bound | Text | bias_motive_description | text | — | |
month_number | Month Number | Month in which incident occurred | Not bound | Number | month_number | numeric | — | |
patrol_borough_name | Patrol Borough Name | NYPD Patrol Borough in which incident occurred | Not bound | Text | patrol_borough_name | text | — | |
pd_code_description | PD Code Description | The NYPD description of the offense | Not bound | Text | pd_code_description | text | — | |
complaint_precinct_code | Complaint Precinct Code | NYPD Precinct in which incident occurred | precinctinvestigated | Text | complaint_precinct_code | text |
Download
This file was produced on Aug 20, 2026, 9:22 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/bqiq-cu78
- Version
- Content hash:
8505d04a336a8b76beb838de453354d0a26b13c46ac2f8e9bbe44a793cb557be - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- Jul 27, 2026, 11:18 AM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Aug 9, 2026, 3:35 PM | full_replace | success | 4,408 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.55 |