Inmate Cases of COVID-19
<p>This dataset aggregates inmate <a href="https://ndc.services.cdc.gov/conditions/coronavirus-disease-2019-covid-19/">cases of COVID-19</a>; it includes cases confirmed by nucleic acid amplification tests (<i>e.g.</i>, PCR tests) collected internally (at Elmwood and Main Jail by Santa Clara County Custody Health Services) and externally (outside Elmwood and Main Jail).</p><p>The Office of the Sheriff updates this dataset weekdays, typically between 10:00 and 12:00 PM, after receiving a snapshot report from Custody Health Services at 06:00 AM, investigating custody statuses of inmates, and incorporating updates around the clock.</p><p>Because the case count includes cases confirmed by tests collected internally and externally, the case count may be greater than the positive test result count, which is based on tests collected by Custody Health Services only.</p>
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 \"sccgov/inmate-cases-of-covid19-3jyw-ib76\".\"inmate_cases_of_covid19\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.