About this Dataset

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.
Organization: City of Chicago
Last updated: 2020-11-10T16:55:29.309919
Tags: complaint, copa, ipra, link-to-article-present, police

Tables

Table 1

@usgov.city_of_chicago_copa_cases_by_involved_officer.table_1

5.2 MB
208,562 rows
16 columns

CREATE TABLE table_1 (
  "log_no" VARCHAR,
  "complaint_date" VARCHAR,
  "assignment" VARCHAR,
  "case_type" VARCHAR,
  "current_status" VARCHAR,
  "current_category" VARCHAR,
  "finding_code" VARCHAR,
  "police_shooting" VARCHAR,
  "beat" VARCHAR,
  "race_of_involved_officer" VARCHAR,
  "sex_of_involved_officer" VARCHAR,
  "age_of_involved_officer" VARCHAR,
  "years_on_force_of_involved_officer" VARCHAR,
  "complaint_hour" BIGINT,
  "complaint_day" BIGINT,
  "complaint_month" BIGINT
);