Service Request Statistics By Cateogry

Requests submitted through the online service request system on the City's website (www.ci.janesville.wi.us). Data is collected through the website content management system.

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 \"janesville-data-socrata/service-request-statistics-by-cateogry-7mgc-zb5r\".\"service_request_statistics_by_cateogry\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.