cityofchicago/copa-cases-by-complainant-or-subject-vnz2-rmie
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 4 days ago
Indexed 17 minutes ago

COPA Cases - By Complainant or Subject

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 complainants or subjects. Each row in this dataset is a complainant or subject 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.

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/copa-cases-by-complainant-or-subject-vnz2-rmie\".\"copa_cases_by_complainant_or_subject\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • copa_cases_by_complainant_or_subject
     
     
     
     
     
Upstream Metadata