Crime Rate Data

The “Crime Rate” is the number of Part I Index Crimes per 100,000 population. The crime rate for Janesville decreased 12% in 2019 from the previous year. The following chart shows the crime rate for the City of Janesville for a ten year period and the average crime rate during the same period.

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 \"performance-ci-janesville-wi-us/crime-rate-data-psxu-hnqa\".\"crime_rate_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.