cityofchicago/copa-cases-summary-mft5-nfa8
Icon for Socrata external plugin
 
Readme
Updated 1 month ago
Indexed 32 minutes ago

COPA Cases - Summary

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

Each complaint is represented by a single line. When multiple people are involved, values for each of them are separated by the | character. In all such columns, the people are presented in the same order. For example, the first value in one column corresponds to the same person as the first value in another column.

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.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
COMPLAINT_MONTHcomplaint_monthcomplaint_monthNumberThe month component of COMPLAINT_DATE.
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.
RACE_OF_COMPLAINANTSrace_of_complainantsrace_of_complainantsTextThe race or ethnicity of the complainant(s) or subject(s). If more than one person was involved, the values are separated by the pipe () character and in the same order for all columns.
COMPLAINT_HOURcomplaint_hourcomplaint_hourNumberThe hour of the day component of COMPLAINT_DATE.
AGE_OF_COMPLAINANTSage_of_complainantsage_of_complainantsTextThe age of the complainant(s) or subject(s). If more than one person was involved, the values are separated by the pipe () character and in the same order for all columns.
SEX_OF_INVOLVED_OFFICERSsex_of_involved_officerssex_of_involved_officersTextThe sex of the officer alleged to have been involved. If more than one officer allegedly was involved, the values are separated by the pipe () character and in the same order for all officer columns
ASSIGNMENTassignmentassignmentTextThe jurisdictional assignment for the complaint case.
CASE_TYPEcase_typecase_typeTextWhether a case is a complaint, a notification, or miscellaneous.
YEARS_ON_FORCE_OF_INVOLVED_OFFICERSyears_on_force_of_officersyears_on_force_of_officersTextThe number of years on the force of the officer alleged to have been involved at the time of the complaint or notification. If more than one officer allegedly was involved, the values are separated by the pipe () character and in the same order for all officer columns
SEX_OF_COMPLAINANTSsex_of_complainantssex_of_complainantsTextThe sex of the complainant(s) or subject(s). If more than one person was involved, the values are separated by the pipe () character and in the same order for all columns.
AGE_OF_INVOLVED_OFFICERSage_of_involved_officersage_of_involved_officersTextThe age of the officer alleged to have been involved at the time of the complaint or notification. If more than one officer allegedly was involved, the values are separated by the pipe () character and in the same order for all officer columns
COMPLAINT_DAYcomplaint_daycomplaint_dayNumberThe day of the week component of COMPLAINT_DATE. Sunday=1
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.
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.
RACE_OF_INVOLVED_OFFICERSrace_of_involved_officersrace_of_involved_officersTextThe race or ethnicity of the officer alleged to have been involved. If more than one officer allegedly was involved, the values are separated by the pipe () character and in the same order for all officer columns.
CURRENT_STATUScurrent_statuscurrent_statusTextThe current status of the case investigation, as of the date the data were last published.
POLICE_SHOOTINGpolice_shootingpolice_shootingTextWhether or not the case is a police shooting.
CURRENT_CATEGORYcurrent_categorycurrent_categoryTextThe category of the primary allegation against the involved CPD member.
 
Preview
  • copa_cases_summary
     
Upstream Metadata