About this Dataset

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

Tables

Table 1

@usgov.city_of_chicago_copa_cases_summary.table_1

5.21 MB
183,716 rows
19 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_complainants" VARCHAR,
  "sex_of_complainants" VARCHAR,
  "age_of_complainants" VARCHAR,
  "race_of_involved_officers" VARCHAR,
  "sex_of_involved_officers" VARCHAR,
  "age_of_involved_officers" VARCHAR,
  "years_on_force_of_involved_officers" VARCHAR,
  "complaint_hour" BIGINT,
  "complaint_day" BIGINT,
  "complaint_month" BIGINT
);