Inmate Population

The Delaware Department of Correction (DOC) operates four prison facilities (Level V), eight quasi-incarceration community corrections facilities that serve as violation of probation centers or work release centers (Level IV), and five Probation & Parole locations (Levels III, II, and I). Offenders may also be supervised while on home confinement, or the offender may be supervised on an administrative basis only while restitution is paid. Some offenders are physically housed at the Delaware Psychiatric Center while in the custody of the DOC. This dataset provides a snapshot of the offender population in custody or under supervision at these various locations on the last day of each calendar month. A count of how many offenders by the year, month (snapshot of last day of month), county, type of institution, institution name, sentence type, gender, race, and ethnicity can be produced by selecting the desired variable in each category. Questions about offender data can be directed to the DOC’s Planning & Research Unit. Instructions for submitting a data request can be found here: http://www.doc.delaware.gov/datarequests.shtml. The DOC’s annual reports (http://www.doc.delaware.gov/annualReport.shtml) also contain a variety of information and data.

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 \"delaware-gov/inmate-population-vnau-c4rn\".\"inmate_population\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.