Name: BIA Cases - By Involved Officer
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

BIA Cases - By Involved Officer

Complaints received by the Chicago Police Department Bureau of Internal Affairs (BIA). BIA investigates complaints of police misconduct that do not fall under the jurisdiction of the Civilian Office of Police Accountability (COPA). Types of misconduct investigated by BIA include the following (not a complete list):

Criminal misconduct
Operational violations
Theft of money or property
Planting of drugs
Substance abuse
Residency violations
Medical roll abuse 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. To file a complaint with either BIA or COPA, please see https://www.chicagocopa.org/complaints.
Organization: City of Chicago
Last updated: 2024-05-17T23:23:45.071593
Tags: complaint, internal-affairs, police

Tables

Table 1

@usgov.city_of_chicago_bia_cases_by_involved_officer.table_1

4.04 MB
177026 rows
15 columns


CREATE TABLE table_1 (
  "log_no" VARCHAR,
  "complaint_date" VARCHAR,
  "case_type" VARCHAR,
  "current_status" VARCHAR,
  "administrative_summary_report" VARCHAR,
  "final_category" VARCHAR,
  "finding_code" VARCHAR,
  "beat" VARCHAR,
  "race_of_involved_officer" VARCHAR,
  "sex_of_involved_officer" VARCHAR,
  "age_of_involved_officer" DOUBLE,
  "years_on_force_of_involved_officer" DOUBLE,
  "complaint_hour" BIGINT,
  "complaint_day" BIGINT,
  "complaint_month" BIGINT
);