SARS‑CoV‑2 Test Results for Inmates
This dataset aggregates SARS‑CoV‑2 test results for inmates at Elmwood and Main Jail. It includes <a href="https://www.cdc.gov/coronavirus/2019-ncov/lab/naats.html">nucleic acid amplification tests</a> (<i>e.g.</i>, PCR tests) and antigen tests collected by Santa Clara County Custody Health Services since 2020 up to yesterday. It does not include indeterminate results or invalid tests; as of December 2022, fewer than 0.015% of tests collected have reported indeterminate results, and fewer than 0.007% have been reported as invalid.
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/sarscov2-test-results-for-inmates-c4gk-mrki\".\"sarscov2_test_results_for_inmates\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.