Civilian Complaint Review Board: Police Officers

2fir-qns4Public Safety14 columns

A list of all NYPD officers, as reported to CCRB by NYPD based on NYPD's roster, and a count of any complaints they have 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.0 / 100

From a 500-row sample across 14 columns.

completeness100/ 25% weight

consistency79/ 20% weight

accuracy96/ 20% weight

timeliness100/ 15% weight

usability95/ 20% weight

Related datasets

Civilian Complaint Review Board: Complaints Against Police Officers0.79
joins onas_of_date
Civilian Complaint Review Board: Allegations Against Police Officers0.76
joins onas_of_datetax_id
Civilian Complaint Review Board: Penalties0.72
joins onas_of_datetax_id
NYPD Officer Profile - Members of Service0.42
Shootings (2006-Present)0.36
NYPD Calls for Service (Year to Date)0.36

Sample rows

as_of_date	tax_id	active_per_last_reported_status	last_reported_active_date	officer_first_name	officer_last_name	officer_race	officer_gender	current_rank_abbreviation	current_rank	current_command	shield_no
2026-10-13T00:00:00.000	907085	No	2001-02-08T18:12:23.000	Scott	Politano	White	Male	POM	Police Officer	101 PCT	14117

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`	datetime	The date this data was generated.	0%	`2026-09-10T00:00:00.000`of 1
`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.	0%	`908966896642881753`
`active_per_last_reported_status`	categorical	Whether a member of service (MOS) appears currently active in the CCRB's latest roster.	0%	`NoYes`of 2
`last_reported_active_date`	datetime	The last date, according to CCRB's latest roster, that a Member of Service (MOS) was reported as active.

Query this from your own app

GET /api/datasets/2fir-qns4
GET /api/datasets/2fir-qns4/quality
GET /api/datasets/2fir-qns4/related
GET /api/columns?dataset=2fir-qns4