SC All Judges, Defendants in Jail per Month, by Case Status and Availability for Trial

This dataset contains a monthly record of how many defendants were in jail, for all Superior Court judges who handle criminal cases. For the current month, there is one data point representative of the number of defendants in jail as of today. For previous months, the data point is the last day of the month, and shows how many defendants were in jail on that day.

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 \"sharefulton-fultoncountyga-gov/sc-all-judges-defendants-in-jail-per-month-by-case-rwke-8znx\".\"sc_all_judges_defendants_in_jail_per_month_by_case\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.