Accused Pre-Trial Inmates in Correctional Facilities

A listing, updated nightly, of individuals being held in Department of Correction facilities while awaiting trial. This data is appended on nightly basis reflecting the individual inmates being held in correctional facilities each day beginning July 1, 2016.

Field Descriptions:

DOWNLOAD DATE: Date in which the data were extracted and reflecting the population for that day.

IDENITIFIER: Individual Inmate Identifier

LATEST ADMISSION DATE: Most recent date in which the inmate has been admitted. In some instances, this may reflect an original date of admission to a correctional facility. Generally, if a date is more than one year old, an inmate should not be considered to have been held for the entire duration of that time.

RACE: Race of inmate

AGE: Age of inmate

BOND AMOUNT: Amount of bond for which the inmate is being held. In some instances, for particularly low (less than $100), this bond amount may be considered a place holder value

OFFENSE: Controlling offense for which the bond amount has been set.

FACILITY: Department of Correction facility where the inmate is currently held.

DETAINER: Denotes whether inmate is being held at the request of another criminal justice agency, or if another agency is to be notified upon release.

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 \"ct-gov/accused-pretrial-inmates-in-correctional-b674-jy6w\".\"accused_pretrial_inmates_in_correctional\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.