About this Dataset

Current Season Viral Respiratory Vaccinations

A. SUMMARY This dataset represents all San Francisco (SF) residents who have received a vaccine for certain respiratory viruses that circulate more heavily in the fall and winter months. All vaccines given to SF residents are included, even if they received their vaccination elsewhere in California. The data are broken down by demographic and geographical stratifications. COVID-19: This dataset represents all SF residents who are considered up to date on their COVID-19 vaccine. A person is up to date if they have received at least one dose of the 2024–2025 COVID-19 vaccine. The specific up-to-date criteria can be found on the California Department of Public Health (CDPH) website. (Note: As of November 2024, this dataset only contains data regarding COVID-19 vaccinations. This documentation will be updated as other seasonal vaccination data is added). B. HOW THE DATASET IS CREATED Information on doses administered to those who live in SF is from the California Immunization Registry (CAIR2), run by CDPH. The information on individuals’ city of residence, age, race, and ethnicity are also recorded in CAIR and are self-reported at the time of vaccine administration. In order to estimate the percent of San Franciscans vaccinated, we provide the 2018-2022 American Community Survey (ACS) population estimates for each demographic group and analysis neighborhood. C. UPDATE PROCESS Updated daily via automated process. D. HOW TO USE THIS DATASET SF population estimates for race/ethnicity and age groups can be found in a view based on the San Francisco Population and Demographic Census dataset. SF population estimates for analysis neighborhoods can be found in a view based on the San Francisco Population and Geography Census dataset. Both of these views use population estimates from the 2018-2022 5-year ACS. Before analysis, you must filter the dataset to the desired stratification of data using the “vaccine_type” and "demographic_group" columns. For example, filtering “vaccine_type” to “COVID-19” will allow you to only look at rows corresponding to COVID-19 vaccinations. Filtering “demographic_subgroup” to “Analysis Neighborhood” will allow you to only look at rows corresponding to SF neighborhoods. You can then calculate the percentages of those up to date with their COVID-19 vaccinations by neighborhood. The “vaccine_subtype” field provides information about the current vaccine product being tracked in this dataset. E. CHANGE LOG

11/5/2024 - Dataset updated to reflect up to date status for the 2024-2025 monovalent formulation of the COVID-19 vaccine.
7/2/2024 - Population estimates were updated to reflect the most recent ACS data.
Organization: City of San Francisco
Last updated: 2023-11-03T14:48:36.394287

Tables

Table 1

@usgov.city_of_san_francisco_current_season_viral_respiratory_1764760c.table_1

10.7 KB
54 rows
11 columns


CREATE TABLE table_1 (
  "vaccine_type" VARCHAR,
  "vaccine_subtype" VARCHAR,
  "demographic_group" VARCHAR,
  "demographic_subgroup" VARCHAR,
  "demographic_subgroup_sort_order" DOUBLE,
  "total_recipients_current" BIGINT,
  "population_estimate" BIGINT,
  "max_date_administered" TIMESTAMP,
  "data_as_of" VARCHAR,
  "data_updated_at" VARCHAR,
  "data_loaded_at" VARCHAR
);