Icon for Socrata external plugin
Open repository in Console
Updated 1 year ago
Indexed 4 hours ago

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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"sccgov/covid19-case-counts-by-date-6cnm-gchg\".\"covid19_case_counts_by_date\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • covid19_case_counts_by_date