COVID-19 case counts by date

The dataset provides number of new and cumulative COVID-19 cases over time among Santa Clara County residents. A case is someone who tests positive for COVID-19 using viral testing performed in a lab. Source: California Reportable Disease Information Exchange. Data Notes: Cases are reported by the date that the specimens were collected for testing. Values for the most recent 5 days are likely to increase as additional results are received.

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-case-counts-by-date-6cnm-gchg\".\"covid19_case_counts_by_date\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.