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.