Iowa Prison Admissions

This dataset provides de-identified individual admission data for offenders admitted to Iowa Penitentiaries and Correctional Facilities during the past 10 Fiscal Years. Dataset includes information regarding age, gender, race, years served, and offense committed.

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 \"mydata-iowa-gov/iowa-prison-admissions-w4ib-vabz\".\"iowa_prison_admissions\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.