COVID-19 testing by pop-up testing sites

The dataset summarizes the number of COVID-19 tests completed by pop-up testing sites 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

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-popup-testing-sites-5hkv-ampu\".\"covid19_testing_by_popup_testing_sites\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.