Officer Involved Shootings

This dataset represents the information the Colorado Springs Police Department (CSPD) was required to report to the State of Colorado Division of Criminal Justice after an officer involved shooting. It is important to note the State of Colorado developed the options for each data field; these multiple choice items were not created by CSPD. Data provided for people categorized as "suspects" in these incidents. CSPD has chosen at this time to continue to update this information even though CSPD no longer has the requirement to report this information in this way. The data collection and reporting was required for the time period 1/1/2010 to 6/30/2020. Law enforcement agencies will have the responsibility to collect and report different use of force information effective 7/1/2023.

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 \"policedata-coloradosprings-gov/officer-involved-shootings-pzyt-rvyq\".\"officer_involved_shootings\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.