colorado-gov/annual-arrests-in-colorado-by-offense-19742021-xi5f-mkzt
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 7 months ago
Indexed 6 days ago

Annual Arrests in Colorado by Offense 1974-2021

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 1974 to 2021.

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-19742021-xi5f-mkzt\".\"annual_arrests_in_colorado_by_offense_19742021\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • annual_arrests_in_colorado_by_offense_19742021
     
     
     
     
     
Upstream Metadata