What do the abbreviations and acronyms mean?

Many database values may be ambiguous without further context or clarification, such as the entries in the “Command” column, which include hundreds of acronyms for specific units in the NYPD.

For information on abbreviations or acronyms, visit the NYCLU’s GitHub page. This information not yet complete, and the NYCLU will continuously update it.

What does NULL mean?

“NULL” reflects any fields that were blank in the original database the NYCLU obtained from the CCRB.

Why are there complaints from before the CCRB was founded?

The database includes complaints from before the Civilian Complaint Review Board was founded, when the CCRB operated within the NYPD. Over 100 complaints indicate an incident date in the year 1900, which is a clear entry error.

How are the complaints classified?

This database represents each allegation of misconduct as a unique complaint. For example, if a civilian reported two alleged acts by the same officer during one incident, the CCRB classifies these two allegations as separate complaints.

Why are there some duplicate entries?

There are about 19,000 complaints that contain the exact same information and most of them have an incident date before the year 2000. It is unclear whether these duplicates are erroneous or simply reflect two allegations with the exact same information.


The NYCLU will continue to update this page. If you have questions, please email CCRBdata@nyclu.org.