A. SUMMARY
This dataset represents the COVID-19 vaccinations given to residents of San Francisco summarized by the geographic region of their residential address. All vaccines given to SF residents are included, no matter where the vaccination took place (the vaccine may have been administered in San Francisco or outside of San Francisco).
Data provides counts for residents who have received at least one dose, residents who have completed a primary vaccine series, residents who have received one or two monovalent (not bivalent) booster doses, and residents who have received a bivalent booster dose. A primary vaccine series is complete after an individual has received all intended doses of the initial series. There are one, two, and three dose primary vaccine series.
B. HOW THE DATASET IS CREATED
Information on doses administered to those who live in San Francisco is from the California Immunization Registry (CAIR2), run by the California Department of Public Health (CDPH). The information on individuals’ residential addresses is recorded in CAIR and are self-reported at the time of vaccine administration. San Francisco Department of Public Health (SFDPH) then runs additional processes to spatially match each address to a geographical region.
In order to estimate the percent of San Francisco residents vaccinated, we provide the 2016-2020 5-year American Community Survey (ACS) population estimates for each analysis neighborhood.
C. UPDATE PROCESS
Updated daily via automated process
D. HOW TO USE THIS DATASET
San Francisco population estimates for geographic regions can be found in a view based on the San Francisco Population and Demographic Census dataset. These population estimates are from the 2016-2020 5-year American Community Survey (ACS).
This data is grouped by SF residents’ analysis neighborhoods of residence. To query counts of individuals vaccinated by analysis neighborhood, filter to "area_type" = ‘Analysis Neighborhood’, and "id" will contain the analysis neighborhood name. To query summarized counts of all vaccinated individuals in San Francisco and whether the San Francisco Department of Public Health (SFDPH) was able to match their residential address to a ___location, filter to "area_type" = ‘Summary’.
To count the number of individuals vaccinated (with any primary series dose), use the "count_vaccinated" column. To count the number of individuals vaccinated (with any primary series dose) by the San Francisco Department of Public Health (SFDPH), use the "count_vaccinated_by_dph" column. To count the number of individuals who have completed their primary vaccine series, use the "count_series_completed" column. To count the number of individuals who received one or two monovalent (not bivalent) boosters, use the "count_received_booster" and "count_received_2nd_booster" columns. To count the number of individuals who received at least one bivalent booster, use the "count_received_bivalent_booster" columns.
E. ARCHIVED DATA
A previous version of this dataset was archived on 10/27/2022. For historical purposes, you can access the archived dataset at the following link:
ARCHIVED: COVID-19 Vaccines Given to San Franciscans by Geography
F. CHANGE LOG
11/1/2023 - data on COVID-19 vaccinations given to SF residents by geography are no longer being updated. This data is currently through 10/31/2023 and will not include any new data after this date.
1/31/2023 - updated “acs_population” column to reflect the 2020 Census Bureau American Community Survey (ACS) San Francisco Population estimates.
1/31/2023 - implemented system updates to streamline and improve our geo-coded data, resulting in small shifts in our vaccination data by geography.
10/2