Icon for Socrata external plugin
Updated 4 days ago
Indexed 6 hours ago

COPA Cases - By Involved Officer

Complaints received by the Civilian Office of Police Accountability and its predecessor agency.

A case will generate multiple rows, sharing the same LOG_NO if there are multiple officers. Each row in this dataset is an officer in a specific case.

Other than identifying the Log Number associated with an investigation being conducted by the Bureau of Internal Affairs section of the Chicago Police Department, information regarding such investigations is not included in this data set.


NameSocrata field nameColumn name in sgr mountData typeDescription
COMPLAINT_MONTHcomplaint_monthcomplaint_monthNumberThe month component of COMPLAINT_DATE.
COMPLAINT_HOURcomplaint_hourcomplaint_hourNumberThe hour of the day component of COMPLAINT_DATE.
BEATbeatbeatTextThe CPD beat in which the incident occurred. If more than one beat was involved, the values are separated by the pipe () character.
COMPLAINT_DATEcomplaint_datecomplaint_dateCalendar dateThe date that the complaint or notification was made to IPRA/COPA and the record was created.
COMPLAINT_DAYcomplaint_daycomplaint_dayNumberThe day of the week component of COMPLAINT_DATE. Sunday=1
CURRENT_STATUScurrent_statuscurrent_statusTextThe current status of the case investigation, as of the date the data were last published.
LOG_NOlog_nolog_noTextA unique identifier for the case record. The log number can be used to link records in other datasets that contain a log number column.
CURRENT_CATEGORYcurrent_categorycurrent_categoryTextThe category of the primary allegation against the involved CPD member.
YEARS_ON_FORCE_OF_INVOLVED_OFFICERyears_on_force_of_involved_officeryears_on_force_of_involved_officerTextThe number of years on the force of the officer alleged to have been involved at the time of the complaint or notification.
RACE_OF_INVOLVED_OFFICERrace_of_involved_officerrace_of_involved_officerTextThe race or ethnicity of the officer alleged to have been involved.
ASSIGNMENTassignmentassignmentTextThe jurisdictional assignment for the complaint case.
FINDING_CODEfinding_codefinding_codeTextThe overall current case finding, ranked by the following hierarchy: Sustained, Not Sustained, Unfounded, Exonerated, No Affidavit, and No Finding. “Current_Finding” means that even after COPA has completed an investigation and made a recommended finding, the finding can change given post-COPA processes, including Police Department review, Police Board adjudication, and grievance and arbitration processes.
CASE_TYPEcase_typecase_typeTextWhether a case is a complaint, a notification, or miscellaneous.
POLICE_SHOOTINGpolice_shootingpolice_shootingTextWhether or not the case is a police shooting.
SEX_OF_INVOLVED_OFFICERsex_of_involved_officersex_of_involved_officerTextThe sex of the officer alleged to have been involved.
AGE_OF_INVOLVED_OFFICERage_of_involved_officerage_of_involved_officerTextThe age of the officer alleged to have been involved at the time of the complaint or notification.
  • copa_cases_by_involved_officer
Upstream Metadata