Icon for Socrata external plugin
Open repository in Console
Updated 3 days ago
Indexed 1 hour ago

Covid-19 Case Rates by Vaccination Status

This table contains the daily 7-day average case rates for Santa Clara County residents by age and vaccination status as well as the 7-day average case counts and population estimates to calculate these rates. Residents are considered fully vaccinated two weeks after the final dose of the vaccine, and residents are considered unvaccinated if they have not received any doses of a COVID-19 vaccine. People who are partially vaccinated are not included in either category.

Counties are experiencing temporary fluctuations in vaccination data received from the State of California due to a data reconciliation process involving integration of vaccination data systems by the State. The data reconciliation process and associated fluctuations in county vaccination are expected to be resolved by mid-April 2022

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-rates-by-vaccination-status-vad9-q7m4\".\"covid19_case_rates_by_vaccination_status\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • covid19_case_rates_by_vaccination_status