COVID-19 cases by method of transmission

The dataset provides information about the source of transmission in the COVID-19 cases among Santa Clara County residents. Source: California Reportable Disease Information Exchange Data notes: All cases without a known source of transmission are included in the Unknown/Presumed Community Transmission category, and may be changed as ongoing investigations yield additional information.

This table is updated every Thursday.

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-cases-by-method-of-transmission-xar3-th86\".\"covid19_cases_by_method_of_transmission\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.