From a 500-row sample across 18 columns.
as_of_datecomplaint_idas_of_datetax_idas_of_datecomplaint_idtax_id| as_of_date | complaint_id | complaint_officer_number | allegation_record_identity | fado_type | allegation | victim_allegedvictim_age_range_at_incident | victim_allegedvictim_gender | victim_allegedvictim_race_legacy | investigator_recommendation | ccrb_allegation_disposition | officer_days_on_force_at_incident |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-10-13T00:00:00.000 | 200506179 | 6 | 421050 | Force | Physical force | 24 < Age <= 29 | Male/Man | Black | Officer(s) Unidentified |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
as_of_date | datetime | The date this data was generated. | 0% | 2026-09-10T00:00:00.000of 1 |
complaint_id | integer | CCRB's complaint ID. | 0% | 202006855202500318202309490 |
complaint_officer_number | integer | Unique ID for each officer per complaint. | 0% | 123 |
tax_id | integer | This is a unique identifier that differentiates members of service. NYPD Tax IDs are nine digit numbers unique to each officer. While some officers while change shield numbers over the course of their time in the NYPD, Tax IDs are meant to be unique identifiers for each NYPD officer. | 39% |
GET /api/datasets/6xgr-kwjq GET /api/datasets/6xgr-kwjq/quality GET /api/datasets/6xgr-kwjq/related GET /api/columns?dataset=6xgr-kwjq
| Officer(s) Unidentified |
| — |
| 2026-10-13T00:00:00.000 | 200717729 | 1 | 550969 | Discourtesy | Word | — | NA | — | Complainant Uncooperative | Complainant Uncooperative | 0 |
| 2026-10-13T00:00:00.000 | 202407959 | 2 | 1295603 | Abuse of Authority | Frisk | 29 < Age <= 34 | Male/Man | — | Unable to Determine | Unable to Determine | 2405 |
| 2026-10-13T00:00:00.000 | 200501710 | 1 | 398927 | Abuse of Authority | Question and/or stop | 14 < Age <= 17 | Male/Man | Hispanic | Exonerated | Exonerated | 2360 |
| 2026-10-13T00:00:00.000 | 200712830 | 1 | 524281 | Discourtesy | Word | 34 < Age <= 39 | Male/Man | Black | Unsubstantiated | Unsubstantiated | 602 |
| 2026-10-13T00:00:00.000 | 202411688 | 1 | 1300954 | Abuse of Authority | Stop | 44 < Age <= 49 | Male/Man | — | Within NYPD Guidelines | Within NYPD Guidelines | 408 |
| 2026-10-13T00:00:00.000 | 200008809 | 3 | 269500 | Force | Physical force | 20 < Age <= 24 | Male/Man | Hispanic | Exonerated | Exonerated | 5192 |
| 2026-10-13T00:00:00.000 | 201700063 | 1 | 973723 | Abuse of Authority | Threat to notify ACS | — | NA | — | Exonerated | Exonerated | 4193 |
| 2026-10-13T00:00:00.000 | 201709177 | 2 | 1014599 | Abuse of Authority | Other | 44 < Age <= 49 | Female/Woman | Hispanic | Officer(s) Unidentified | Officer(s) Unidentified | — |
| 2026-10-13T00:00:00.000 | 202504851 | 2 | 1319180 | Force | Chokehold | 24 < Age <= 29 | Female/Woman | — | Unfounded | Unfounded | 4321 |
Showing 12 of 17 columns. All of them are listed below.
943025922716933211officer_rank_abbreviation_at_incident | text | MOS rank held at the time of the incident, abbreviated. | 39% | POMPOSGT |
officer_rank_at_incident | categorical | MOS rank held at the time of the incident. | 39% | Police OfficerSergeantDetectiveof 10 |
officer_command_at_incident | text | MOS command at the time of the incident. | 32% | 075 PCT044 PCTUnknown |
officer_days_on_force_at_incident | integer | Total calendar days MOS had been active with NYPD at the time of incident. | 5% | 01400797 |
allegation_record_identity | integer | This is a unique identifier to differentiate allegations. | 0% | 1216523282804857477 |
fado_type | categorical | Force, Abuse of Authority, Discourtesy or Offensive Language--category of allegation. | 0% | Abuse of AuthorityForceDiscourtesyof 5 |
allegation | text | Allegation description. | 0% | Physical forceWordThreat of arrest |
victim_allegedvictim_age_range_at_incident | categorical | The Victim's/Alleged Victim's age, in a range, at the time of the incident. | 20% | 24 < Age <= 2929 < Age <= 3420 < Age <= 24of 17 |
victim_allegedvictim_gender | categorical | The Victim's/Alleged Victim's gender, if known. | 0% | Male/ManFemale/WomanNAof 4 |
victim_allegedvictim_race_legacy | categorical | In October 2022 CCRB redesigned its data collection categories for race. This column maintains previous race data from our former collection categories. | 29% | BlackHispanicUnknownof 8 |
victim_alleged_victim_race_ethnicity | text | The Victim / Alleged Victim's race, if known. This data is collected directly from Victim / Alleged Victims wherever possible. In some cases this data may be collected elsewhere, such as from the Internal Affairs Bureau or from a complainant rather than the Victim / Alleged Victim themselves, and confirmed with a complainant when possible. | 87% | Black and/or African Ame…Decline to Answer (NA)Other Hispanic/Latino (E… |
investigator_recommendation | text | The CCRB Investigations Division's recommended disposition for the allegation. | 0% | Complainant Uncooperativ…ExoneratedUnsubstantiated |
ccrb_allegation_disposition | text | CCRB's board disposition for the allegation. | 0% | Complainant Uncooperativ…UnsubstantiatedExonerated |
nypd_allegation_disposition | text | NYPD's final disposition on the allegation. | 94% | No Disciplinary Action-D…Command Discipline - AInstructions |