Civilian Complaint Review Board: Penalties

keep-pkmhPublic Safety13 columns

A table listing recommended and final penalties for each officer with a substantiated complaint of misconduct since the year 2000. Non-charges cases go through the Department Advocate's Office (DAO) and are recorded as non-APU where relevant in the table, while charges cases are prosecuted by the Administrative Prosecution Unit (APU) and are marked as APU penalties and recommendations. In all cases the NYPD Commissioner will issue a final penalty, labeled as "NYPD Officer Penalty" in the dataset. 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

B86.5 / 100

From a 500-row sample across 10 columns.

completeness73/ 25% weight

consistency75/ 20% weight

accuracy97/ 20% weight

timeliness100/ 15% weight

usability95/ 20% weight

Related datasets

Civilian Complaint Review Board: Complaints Against Police Officers0.73
joins onas_of_datecomplaint_id
Civilian Complaint Review Board: Police Officers0.72
joins onas_of_datetax_id
Civilian Complaint Review Board: Allegations Against Police Officers0.70
joins onas_of_datetax_idcomplaint_id
NYPD Officer Profile - Members of Service0.40
NYPD Vehicle Stop Reports0.37
Shootings (2006-Present)0.35

Sample rows

as_of_date	complaint_id	tax_id	ccrb_substantiated_officer_disposition	board_discipline_recommendation	non_apu_nypd_penalty_report_date	officer_is_apu	nypd_officer_penalty	apu_case_status
2026-10-13T00:00:00.000	202602754	961895	Substantiated (Formalized Training)	Substantiated (Formalized Training)	2026-06-22T09:04:39.000	No	Formalized Training	—
2026-10-13T00:00:00.000	202602754	969914	Substantiated (Formalized Training)

Columns

13 queryable · 13 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-09T00:00:00.000`of 1
`complaint_id`	integer	CCRB's complaint ID.	0%	`202303046202405211202310526`
`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%	`943025971511933762`
`ccrb_substantiated_officer_disposition`	categorical	CCRB's board disposition for the allegation.	0%

Query this from your own app

GET /api/datasets/keep-pkmh
GET /api/datasets/keep-pkmh/quality
GET /api/datasets/keep-pkmh/related
GET /api/columns?dataset=keep-pkmh