From a 500-row sample across 12 columns.
| full_complaint_id | complaint_year_number | month_number | record_create_date | complaint_precinct_code | patrol_borough_name | county | law_code_category_description | offense_description | pd_code_description | bias_motive_description | offense_category |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 201906012119317 | 2019 | 1 | 2019-01-23T00:00:00.000 | 60 | PATROL BORO BKLYN SOUTH | KINGS | FELONY | MISCELLANEOUS PENAL LAW | AGGRAVATED HARASSMENT 1 | ANTI-JEWISH |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
full_complaint_id | text | Identifier for each hate crimes incident | 0% | 202310912703117202101812337217202502612430717 |
complaint_year_number | categorical | Year in which incident occurred | 0% | 202320242022of 8 |
month_number | categorical | Month in which incident occurred | 0% | 536of 12 |
record_create_date | datetime | Date report was filed | 0% | 2026-05-04T00:00:00.000 |
GET /api/datasets/bqiq-cu78 GET /api/datasets/bqiq-cu78/quality GET /api/datasets/bqiq-cu78/related GET /api/columns?dataset=bqiq-cu78
| Religion/Religious Practice |
| 201906012175717 | 2019 | 2 | 2019-02-25T00:00:00.000 | 60 | PATROL BORO BKLYN SOUTH | KINGS | FELONY | MISCELLANEOUS PENAL LAW | AGGRAVATED HARASSMENT 1 | ANTI-JEWISH | Religion/Religious Practice |
| 201906012180117 | 2019 | 2 | 2019-02-27T00:00:00.000 | 60 | PATROL BORO BKLYN SOUTH | KINGS | FELONY | MISCELLANEOUS PENAL LAW | AGGRAVATED HARASSMENT 1 | ANTI-JEWISH | Religion/Religious Practice |
| 201906012273417 | 2019 | 4 | 2019-04-16T00:00:00.000 | 60 | PATROL BORO BKLYN SOUTH | KINGS | FELONY | MISCELLANEOUS PENAL LAW | AGGRAVATED HARASSMENT 1 | ANTI-JEWISH | Religion/Religious Practice |
| 201906012413717 | 2019 | 6 | 2019-06-20T00:00:00.000 | 60 | PATROL BORO BKLYN SOUTH | KINGS | FELONY | MISCELLANEOUS PENAL LAW | AGGRAVATED HARASSMENT 1 | ANTI-JEWISH | Religion/Religious Practice |
| 201906012523617 | 2019 | 7 | 2019-07-31T00:00:00.000 | 60 | PATROL BORO BKLYN SOUTH | KINGS | FELONY | MISCELLANEOUS PENAL LAW | AGGRAVATED HARASSMENT 1 | ANTI-JEWISH | Religion/Religious Practice |
| 201906012616917 | 2019 | 9 | 2019-09-11T00:00:00.000 | 60 | PATROL BORO BKLYN SOUTH | KINGS | FELONY | MISCELLANEOUS PENAL LAW | AGGRAVATED HARASSMENT 1 | ANTI-JEWISH | Religion/Religious Practice |
| 201906012762517 | 2019 | 11 | 2019-11-21T00:00:00.000 | 60 | PATROL BORO BKLYN SOUTH | KINGS | FELONY | MISCELLANEOUS PENAL LAW | AGGRAVATED HARASSMENT 1 | ANTI-JEWISH | Religion/Religious Practice |
| 201906112336617 | 2019 | 5 | 2019-05-18T00:00:00.000 | 61 | PATROL BORO BKLYN SOUTH | KINGS | FELONY | MISCELLANEOUS PENAL LAW | AGGRAVATED HARASSMENT 1 | ANTI-JEWISH | Religion/Religious Practice |
| 201906112366917 | 2019 | 6 | 2019-06-02T00:00:00.000 | 61 | PATROL BORO BKLYN SOUTH | KINGS | FELONY | MISCELLANEOUS PENAL LAW | AGGRAVATED HARASSMENT 1 | ANTI-JEWISH | Religion/Religious Practice |
2024-06-12T00:00:00.0002022-07-29T00:00:00.000complaint_precinct_code | text | NYPD Precinct in which incident occurred | 0% | 901419 |
patrol_borough_name | categorical | NYPD Patrol Borough in which incident occurred | 0% | PATROL BORO MAN SOUTHPATROL BORO BKLYN SOUTHPATROL BORO BKLYN NORTHof 9 |
county | categorical | County in which incident occurred | 0% | NEW YORKKINGSQUEENSof 5 |
law_code_category_description | categorical | Category of offense | 0% | FELONYMISDEMEANORVIOLATIONof 4 |
offense_description | text | A description of the offense | 0% | MISCELLANEOUS PENAL LAWASSAULT 3 & RELATED OFFE…CRIMINAL MISCHIEF & RELA… |
pd_code_description | text | The NYPD description of the offense | 0% | AGGRAVATED HARASSMENT 1ASSAULT 3AGGRAVATED HARASSMENT 2 |
bias_motive_description | text | NYPD category of hate crime or bias type | 0% | ANTI-JEWISHANTI-MALE HOMOSEXUAL (GA…ANTI-ASIAN |
offense_category | categorical | General categorization of hate crime type | 0% | Religion/Religious Pract…Race/ColorSexual Orientationof 7 |
arrest_date | datetime | Date arrest was made (if arrest happened) | 100% | — |
arrest_id | text | Identifier for arrest (if made) | 57% | K36718172K36718150K36702957 |