NYPD Misconduct Complaint Database – 08.20.20
A previous version of the raw CCRB database file contained formatting errors that resulted in missing information. In the columns labeled “NYPD Disposition” and “Penalty Desc,” there were about 120 cells where data should have appeared yet the spreadsheet showed a blank value. If you downloaded the raw data before 12:00pm EST August 21, 2020, please download the corrected file that appears on the GitHub page now.
ccrb_database_raw.xlsx is a record of the
complaints made by the public to the Civilian Complaint Review
Board (CCRB). These complaints span two distinct periods: the time
since the CCRB started operating as an independent city agency
outside the NYPD in 1994 and the prior period when the CCRB
operated within the NYPD. The data includes 323,911 unique
complaint records involving 81,550 active or former NYPD officers.
The data does not include complaints for which the CCRB has not
completed an investigation as of July 2020. For more information,
please visit nyclu.org/nypdrecords
ccrb_database_raw.csv is a .csv version of
ccrb_filespecs.xlsx is a spreadsheet containing
- information about each variable in
- information clarifying some of the abbreviations used in the database
- all differences between the raw data file and the version that is accessible through the interactive tool.
In the coming weeks we will update this file with additional details. For more information, please visit nyclu.org/nypdrecords