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_database_raw.xlsx.
ccrb_filespecs.xlsx is a spreadsheet containing
- information about each variable in
ccrb_database_raw.xlsx - 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