Icon for Socrata external plugin
Open repository in Console
Updated 2 months ago
Indexed 5 hours ago

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="">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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"sccgov/sarscov2-test-results-for-inmates-c4gk-mrki\".\"sarscov2_test_results_for_inmates\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • sarscov2_test_results_for_inmates