Criminal Justice - Jail Average Daily Population and Pretrial Caseload

Average Daily Population (ADP) in Pierce County Corrections. Data sourced from LINX system. Pretrial data included from the Clerk of the Superior Court.

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 \"internal-open-piercecountywa-gov/criminal-justice-jail-average-daily-population-and-3a37-ahuv\".\"criminal_justice_jail_average_daily_population_and\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.