Sonoma County Sheriff's Office Jail Population Data
Historical population data captured daily. Two figures are shown those in custody and those in outside custody but are still under the responsibility of Sonoma County Sheriff. Examples of outside custody include home confinement, state prison, hospital stays, weekend custody, and supervised by other agencies.
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 \"sonomacounty-ca-gov/sonoma-county-sheriffs-office-jail-population-data-gemb-q4p5\".\"sonoma_county_sheriffs_office_jail_population_data\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.