Crimes in Colorado 1997 to 2015

Crime stats for the State of Colorado from 1997 to 2015. Data provided by the CDPS and the FBI's Crime Data Explorer (CDE).

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/crimes-in-colorado-1997-to-2015-6vnq-az4b\".\"crimes_in_colorado_1997_to_2015\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.