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.