COVID-19 testing by date

The dataset provides the total daily number of test for COVID-19 among Santa Clara County residents. Source: California Reportable Disease Information Exchange. Data Notes: A test represents at least one specimen tested per person per day. Some people will have multiple specimens collected and tested during the same visit but are only counted once per day. If a person is tested multiple times on different days then he or she will be counted for each day he or she was tested. The positivity rate is the percent of positive tests out of total tests performed.

This table is updated Monday-Friday and will not be updated on holidays.

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-date-dvgc-tzgq\".\"covid19_testing_by_date\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.