SOCRATAPublic Safetyofficial
COPA Cases - Summary
Attribution: City of Chicago · source
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.
copaiprapolicecomplaintlink to article present
Dataset Profile
189.4K
Total records
19
Columns
table
Type
ID: mft5-nfa8
Popularity
82.3K
Views
6.3K
Downloads
~189.4K rows · 19 columns
Freshness & Tracking
Rows updated5 months ago · 4/7/2026
View modified5 months ago
Created on source9/7/2017
Published4/6/2020
Discovered5/13/2026, 11:38:18 PM
Last checked5/13/2026, 11:38:18 PM
Last changed5/13/2026, 11:38:18 PM
Reads0
Search hits7
View raw source ↗📁
No files attached
Upload a file to get started
Owner & Attribution
Ownercocadmin
Authorcocadmin
PublisherCity of Chicago
Metadata
Data OwnerCivilian Office of Police Accountability
Time Period2007-Present
Changes and Other Historical Information Useful to Understanding This Datasethttp://dev.cityofchicago.org/open%20data/data%20portal/2020/04/06/copa-changes.html
Schema (19 columns)
Column metadata from the source provider's own profiling
| Column | Type | Cardinality | Nulls | Top Values | Range |
|---|---|---|---|---|---|
LOG_NO A unique identifier for the case record. The log number can be used to link records in other datasets that contain a log number column. | text | 189.4K | 0 | 2010-10376752014-10714562000-0266940 | 2000-0258959 … 2026-0001718 |
COMPLAINT_DATE The date that the complaint or notification was made to IPRA/COPA and the record was created. | calendar_date | 189.4K | 0 | 2000-05-01T00:00:00.2000-05-31T00:00:00.2001-07-16T00:00:00. | 2000-01-01T0 … 2026-04-06T2 |
ASSIGNMENT The jurisdictional assignment for the complaint case. | text | 189.4K | 0 | BIACOPA | BIA … COPA |
CASE_TYPE Whether a case is a complaint, a notification, or miscellaneous. | text | 189.4K | 138.1K | ComplaintNotificationMiscellaneous | Complaint … Notification |
CURRENT_STATUS The current status of the case investigation, as of the date the data were last published. | text | 189.4K | 138.1K | ClosedPending InvestigatioPending CPD Review | Closed … Pending Inve |
CURRENT_CATEGORY The category of the primary allegation against the involved CPD member. | text | 189.4K | 138.1K | Excessive ForceClosed-No AllegationExcessive Force | Ex | Alcohol/Drug … Weapon Disch |
FINDING_CODE The 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. | text | 189.4K | 138.7K | No FindingNo AffidavitSustained | Administrati … Within Polic |
POLICE_SHOOTING Whether or not the case is a police shooting. | text | 189.4K | 138.1K | NoYes | No … Yes |
BEAT The CPD beat in which the incident occurred. If more than one beat was involved, the values are separated by the pipe (|) character. | text | 189.4K | 138.1K | Unknown03100 | 0 … Unknown |
RACE_OF_COMPLAINANTS The 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. | text | 189.4K | 138.1K | Black or African AmeBlack or African AmeHispanic, Latino, or | American Ind … White | Whit |
SEX_OF_COMPLAINANTS The 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. | text | 189.4K | 138.1K | MaleFemaleUnknown | Female … Unknown | Un |
AGE_OF_COMPLAINANTS The 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. | text | 189.4K | 138.1K | 20-2930-39Unknown | 0-19 … Unknown | Un |
RACE_OF_INVOLVED_OFFICERS The 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. | text | 189.4K | 138.1K | UnknownWhiteBlack or African Ame | American Ind … White | Whit |
SEX_OF_INVOLVED_OFFICERS The 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 | text | 189.4K | 138.1K | MaleUnknownMale | Male | Female … Unknown | Un |
AGE_OF_INVOLVED_OFFICERS The 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 | text | 189.4K | 138.1K | Unknown30-3940-49 | 20-29 … Unknown | Un |
YEARS_ON_FORCE_OF_INVOLVED_OFFICERS The 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 | text | 189.4K | 138.1K | 30+5-90-4 | 0-4 … 5-9 | 5-9 | |
COMPLAINT_HOUR The hour of the day component of COMPLAINT_DATE. | number | 189.4K | 0 | 01112 | 0 … 23 |
COMPLAINT_DAY The day of the week component of COMPLAINT_DATE. Sunday=1 | number | 189.4K | 0 | 324 | 1 … 7 |
COMPLAINT_MONTH The month component of COMPLAINT_DATE. | number | 189.4K | 0 | 786 | 1 … 12 |
Resources
Direct links to downloads, APIs, and related pages.