Colorado Violent Crime Rate vs Incarceration Rate, 1982-2012
Murder and non-negligent manslaughter, forcible rape, robbery, and aggravated assault. National or state offense totals are based on data from all reporting agencies and estimates for unreported areas. Rates are the number of reported offenses per 100,000 population. These figures are based on end of calendar year populations.
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/colorado-violent-crime-rate-vs-incarceration-rate-jnqn-fw7d\".\"colorado_violent_crime_rate_vs_incarceration_rate\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.