cityofchicago/bia-cases-by-involved-officer-t7km-zpxd
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 1 day ago
Indexed 4 hours ago

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):

<li>Criminal misconduct<li>Operational violations<li>Theft of money or property<li>Planting of drugs<li>Substance abuse<li>Residency violations<li>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.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cityofchicago/bia-cases-by-involved-officer-t7km-zpxd\".\"bia_cases_by_involved_officer\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • bia_cases_by_involved_officer
     
     
     
     
     
Upstream Metadata