Icon for Socrata external plugin
Open repository in Console
Updated 2 years ago
Indexed 6 hours ago

COVID-19 testing trend by healthcare system

The dataset summarizes the average rate of COVID-19 tests completed by date among Santa Clara County residents by major healthcare systems in the county. 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. 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 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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"sccgov/covid19-testing-trend-by-healthcare-system-brci-d4hg\".\"covid19_testing_trend_by_healthcare_system\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • covid19_testing_trend_by_healthcare_system