Civilian Complaint Review Board: Complaints Against Police Officers

2mby-ccnwPublic Safety14 columns

The primary table for all public data on complaints, including dates, locations and the outcomes of closed complaints received since the year 2000. The dataset is part of a database of all public police misconduct records the Civilian Complaint Review Board (CCRB) maintains on complaints against New York Police Department uniformed members of service received in CCRB's jurisdiction since the year 2000, when CCRB's database was first built. This data is published as four tables: Civilian Complaint Review Board: Police Officers Civilian Complaint Review Board: Complaints Against Police Officers Civilian Complaint Review Board: Allegations Against Police Officers Civilian Complaint Review Board: Penalties A single complaint can include multiple allegations, and those allegations may include multiple subject officers and multiple complainants. Public records exclude complaints and allegations that were closed as Mediated, Mediation Attempted, Administrative Closure, Conciliated (for some complaints prior to the year 2000), or closed as Other Possible Misconduct Noted. This database is inclusive of prior datasets held on Open Data (previously maintained as "Civilian Complaint Review Board (CCRB) - Complaints Received," "Civilian Complaint Review Board (CCRB) - Complaints Closed," and "Civilian Complaint Review Board (CCRB) - Allegations Closed") but includes information and records made public by the June 2020 repeal of New York Civil Rights law 50-a, which precipitated a full revision of what CCRB data could be considered public.

View on NYC Open Data

Quality

A94.7 / 100

From a 500-row sample across 14 columns.

completeness99/ 25% weight

consistency75/ 20% weight

accuracy100/ 20% weight

timeliness100/ 15% weight

usability100/ 20% weight

· Has geographic keys — joinable to other NYC datasets

Related datasets

Civilian Complaint Review Board: Police Officers0.79
joins onas_of_date
Civilian Complaint Review Board: Allegations Against Police Officers0.77
joins onas_of_datecomplaint_id
Civilian Complaint Review Board: Penalties0.73
joins onas_of_datecomplaint_id
NYPD Officer Profile - Members of Service0.42
NYPD Calls for Service (Year to Date)0.37
joins onincident_date
NYPD Use of Force Incidents

Sample rows

as_of_date	complaint_id	incident_date	incident_hour	ccrb_received_date	close_date	borough_of_incident_occurrence	precinct_of_incident_occurrence	location_type_of_incident	reason_for_police_contact	outcome_of_police_encounter	ccrb_complaint_disposition
20261014	200910870	2009-07-14	9	2009-07-14T14:36:47.000	2010-07-08T15:41:14.000	Bronx	46	Street/highway	Other	Arrest - other violation/crime

Columns

14 queryable · 14 profiled

The machine field names SoQL needs, with the publisher's own description of each.

Field	Type	Description	Null	Values
`as_of_date`	text	The date this data was generated.	0%	`20260909`of 1
`complaint_id`	integer	CCRB's complaint ID.	0%	`200105426200714926201016751`
`incident_date`	date	The complaint incident date.	1%	`2020-05-302020-06-042003-02-15`
`incident_hour`	integer	The hour of day in which the incident occurred.	4%	`201921`
`ccrb_received_date`

Query this from your own app

GET /api/datasets/2mby-ccnw
GET /api/datasets/2mby-ccnw/quality
GET /api/datasets/2mby-ccnw/related
GET /api/columns?dataset=2mby-ccnw