colorado-gov/annual-arrests-in-colorado-by-offense-19702022-xi5f-mkzt
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 3 months ago
Indexed 1 hour ago

Annual Arrests in Colorado by Offense 1970-2022

This datasets provides annual counts of arrests made by offense for 243 Police Agencies in Colorado. Thirty one different offenses are tracked in this dataset, spanning 1970 to 2022.

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 \"colorado-gov/annual-arrests-in-colorado-by-offense-19702022-xi5f-mkzt\".\"annual_arrests_in_colorado_by_offense_19702022\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • annual_arrests_in_colorado_by_offense_19702022
     
     
     
     
     
Upstream Metadata