COVID-19 testing by healthcare system

The data set summarizes the number of COVID-19 tests completed among Santa Clara County residents by major healthcare systems in the county. Each ‘test’ or ‘testing incident’ represents at least one specimen tested per person, per day. This does not represent the number of individuals tested, as some people are tested multiple times over time because of the risk of frequent exposure. Source: California Reportable Disease Information Exchange. Data notes: The daily average rate of tests is the daily average number of tests completed over the past 7 days per 100,000 people served by the individual healthcare system. The State of California has defined an initial goal of at least 150 tests per day per 100,000 people. Bay Area County Health Officers set a goal of 200 tests per day per 100,000 people.

This table was updated for the last time on May 20, 2021.

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/covid19-testing-by-healthcare-system-vzxr-ymut\".\"covid19_testing_by_healthcare_system\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.