Civilian Complaint Review Board (CCRB) - Complaints Closed
data.cityofnewyork.us | Last Updated 9 May 2022The New York City Civilian Complaint Review Board (CCRB) is an independent agency. It is empowered to receive, investigate, mediate, hear, make findings, and recommend action on complaints against New York City police officers alleging the use of excessive or unnecessary force, abuse of authority, discourtesy, or the use of offensive language. The Board’s investigative staff, composed entirely of civilian employees, conducts investigations in an impartial fashion. The Board forwards its findings to the police commissioner.
This dataset has the following 12 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Extract Run Date | extract_run_date | calendar_date | Run-date Information to verify recent data | 2018-05-25T00:00:00.000 view top 100 |
| Randomized Id | randomized_id | text | A randomly assigned number used to uniquely identify complaints. Rows that contain the same UniqueRandomComplaintId are allegations in the same complaint. | 36146 53623 30543 15967 40442 view top 100 |
| Closed Year | closed_year | text | Year CCRB closed the complaint. | 2009 2007 2006 2013 2010 view top 100 |
| Case Type | case_type | text | Jurisdiction of complaint description. CCRB cases only. | CCRB view top 100 |
| Days From Received Date To Case Closing | days_from_received_date_to | number | Days difference between CCRB receiving the complaint to the date CCRB closed the complaint. | 84 98 77 91 70 view top 100 |
| Re-opened | re_opened | checkbox | Was the complaint re-opened. | false true view top 100 |
| Ever On DA Hold | ever_on_da_hold | checkbox | Has the District Attorney ever placed the CCRB complaint on hold. Incidents forwarded to the District Attorney take priority and CCRB will resume its investigation when those matters are resolved. | false true view top 100 |
| Outcome Path | outcome_path | text | Outcome type of CCRB complaint. | Truncated Full Investigation Mediation Attempted Mediated Other view top 100 |
| Case Disposition | case_disposition | text | Administratively Closed: CCRB closes complaint due to administrative purposes. Alleged Victim Unavailable: complaint is closed as complainant/victim/witness unavailable when the complainant, victim and/or witness cannot be located after multiple and varied attempts. Alleged Victim Uncooperative: complaint is closed as complainant/victim/witness uncooperative when the participation of the complainant, victim and/or witness is insufficient to enable the board to conduct a full investigation. Closed - Pending Litigation: complaint is closed due to pending litigation of the incident. Complainant Unavailable: complaint is closed as complainant/victim/witness unavailable when the complainant, victim and/or witness cannot be located after multiple and varied attempts. Complainant Uncooperative: complaint is closed as complainant/victim/witness uncooperative when the participation of the complainant, victim and/or witness is insufficient to enable the board to conduct a full investigation. Complaint Withdrawn: complaint is closed as complainant withdrawn when the when the complainant confirms they want to voluntarily withdraw the complaint. Conciliated: process prior to the medation process where the officer was spoken to about their conduct outside the presence of the complainant or victim/alleged victim. Duplicate - CCRB: complaint is closed as a duplicate if a complaint with the same incident is already being investigated. Exonerated: if any allegation within complaint is exonerated and there are no substantiated, unsubstantiated, or unfounded allegations. IAB - Referral: complaint is referred to the jurisdiction of the Internal Affairs Bureau NYPD. IAB - Staff Referral: complaint is referred to the jurisdiction of the Internal Affairs Bureau NYPD. Mediated: a complaint may be resolved by mediation, provided the complainant and subject officer agree, and the CCRB Board determines the complaint is appropriate for mediation. Both the complainant and the subject officer must agree to mediate the complaint within Mediation Attempted: a situation in which an officer agrees to mediate but the complainant becomes unavailable for the mediation (after the complainant first agreed to mediation). Miscellaneous: complaint is closed for other reasons. Miscellaneous - Subject Resigned: complaint is closed when the subject officer resigns from the NYPD. Miscellaneous - Subject Retired: complaint is closed when the subject officer retires from the NYPD. Miscellaneous - Subject Terminated: complaint is closed when the subject officer is terminated by the NYPD. OCD - Staff Referral: complaint is referred to the jurisdiction of the Officer of the Chief of Department NYPD. Officer(s) Unidentified: if CCRB was not able to identify any MOS in the complaint and there are no substantiated, unsubstantiated, unfounded, or exonerated allegations. Referral: complaint is referrel to agency with jursidiction. Substantiated (Charges): if any allegation within complaint is substantiated with Charges. Substantiated (Command Discipline A): if any allegation within complaint is substantiated with Command Discipline A. Substantiated (Command Discipline B): if any allegation within complaint is substantiated with Command Discipline B. Substantiated (Command Discipline): if any allegation within complaint is substantiated with Command Discipline. Substantiated (Command Lvl Instructions): if any allegation within complaint is substantiated with Command Level Instructions. Substantiated (Formalized Training): if any allegation within complaint is substantiated with Formalized Training. Substantiated (Instructions): if any allegation within complaint is substantiated with Instructions. Substantiated (No Recommendations): if any allegation within complaint is substantiated with No Recommendations. Unfounded: if any allegation within complaint is unfounded and there are no substantiated, or unsubstantiated allegations. Unsubstantiated: if any allegation within complaint is unsubstantiated and there are no substantiated allegations. Victim Unidentified: complaint is closed as victim unidentified when the victim/alleged victim cannot be identified. Witness Unavailable: complaint is closed as complainant/victim/witness unavailable when the complainant, victim and/or witness cannot be located after multiple and varied attempts. Witness Uncooperative: complaint is closed as complainant/victim/witness uncooperative when the participation of the complainant, victim and/or witness is insufficient to enable the board to conduct a full investigation. | Complainant Uncooperative Unsubstantiated Complaint Withdrawn Complainant Unavailable Exonerated view top 100 |
| Borough Of Incident | borough_of_incident | text | Borough location of incident. | Brooklyn Manhattan Bronx Queens Staten Island view top 100 |
| Patrol Borough Of Incident | patrol_borough_of_incident | text | Patrol Borough location of incident. | Bronx Brooklyn North Brooklyn South Manhattan North Manhattan South view top 100 |
| Stop, Question, Frisk Complaint | stop_question_frisk_complaint | checkbox | The complaint contains at least one stop, question, frisk, or search of person allegation. | false true view top 100 |