Use of Force Reports
This dataset includes each force report filed by a CSPD officer. In the vast majority of situations, each officer completes a report for each subject of force. One incident may have multiple force reports.
There is an exception to how force is normally reported for incidents involving crowds where the officer cannot identify subjects. This can happen in a crowd situation because subjects often flee the scene before they can be identified and specifically included in the force report. In these situations, the officer completes one report for multiple subjects of force. If the reason for force in a report is listed as "Crowd-Failure to Disperse" or "Failed to Disperse," it may be a report with multiple subjects. To learn more, see our Use of Force Overview.
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/use-of-force-reports-ii9t-cvd6\".\"use_of_force_reports\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.