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:

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

A. SUMMARY
This dataset represents the COVID-19 vaccinations given to residents of San Francisco. 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). The data are broken down by multiple demographic stratifications. This dataset also includes COVID-19 vaccinations given to SF residents by the San Francisco Department of Public Health (SFDPH).

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’ 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 2016-2020 American Community Survey (ACS) population estimates for each demographic group.

C. UPDATE PROCESS
Updated daily via automated process

D. HOW TO USE THIS DATASET
San Francisco population estimates for race/ethnicity and age groups 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).

Before analysis, you must filter the dataset to the desired stratification of data using the "overall_segment" column.

For example, filtering "overall_segment" to "All SF Residents by Age Bracket, Administered by All Providers" will filter the data to residents whose vaccinations were administered by any provider. You can then further segment the data and calculate percentages by Age Brackets.

If you filter "overall_segment" to "All SF Residents by Race/Ethnicity, Administered by DPH Only", you will see the race/ethnicity breakdown for residents who received vaccinations from the San Francisco Department of Public Health (SFDPH).

If you filter "overall_segment" to "All SF Residents by Age Group, Administered by All Providers" you will see vaccination counts of various age eligibility groups that were administered by any provider.

To count the number of individuals vaccinated (with any primary series dose), use the "total_recipients" column. To count the number of individuals who have completed their primary vaccine series, use the "total_series_completed" column. To count the number of primary series doses administered (1st, 2nd, 3rd, or single doses), use the "total_primary_series_doses" column.

To count the number of individuals who received one or two monovalent (not bivalent) booster doses, use the "total_booster_recipients" and "total_2nd_booster_recipients" columns. To count the number of individuals who received their first bivalent booster dose, use the "total_bivalent_booster_recipients" column. To count the number of monovalent (not including bivalent) or bivalent booster doses administered, use the "total_booster_doses" or "total_bivalent_booster_doses" 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:

Update Jan 26, 2023: This dataset is no longer being updated. Please visit https://sf.gov/get-vaccinated-against-covid-19 for information on vaccine locations.

A. SUMMARY
Dataset contains Vaccine Access points in City and County of San Francisco as listed on https://sf.gov/vaccine-sites.
This site list is not inclusive of all City Sites, as some mobile sites and other providers may not be included.

B. HOW THE DATASET IS CREATED
Maintained by City staff.

C. UPDATE PROCESS
Updated daily via automated process

A. SUMMARY
This dataset represents the COVID-19 vaccinations given to residents of San Francisco over time. 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). This dataset also includes COVID-19 vaccinations given to SF residents by the San Francisco Department of Public Health (SFDPH) over time.

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).

C. UPDATE PROCESS
Updated daily via automated process

D. HOW TO USE THIS DATASET
Before analysis, you must filter the dataset to the desired stratification of data using the "administering_provider_type" column. To get vaccination counts of all SF residents regardless of provider, filter to "administering_provider_type" = ‘All Providers’. To get vaccination counts administered by SFDPH to SF residents, filter to "administering_provider_type" = ‘DPH Only’.

To count the number of individuals vaccinated (with any primary series dose) for the first time on a given day, use the "new_recipients" column. To count the number of individuals who have completed their primary vaccine series on a given day, use the "new_series_completed" column. To count the number of primary series doses administered on a day (1st, 2nd, 3rd, or single doses), use the "new_primary_series_doses" column.

To count the number of individuals who received their first or second monovalent (not bivalent) booster dose on a given day, use the "new_booster_recipients" and "new_2nd_booster_recipients" columns. To count the number of individuals who received their first bivalent booster dose on a given day, use the "new_bivalent_booster_recipients" column. To count the number of monovalent (not including bivalent) or bivalent booster doses administered on a given day, use the "new_booster_doses" or "new_bivalent_booster_doses" columns.

To count the number of individuals who have received a vaccine up to a certain date, use the columns beginning with "cumulative_..."

E. ARCHIVED DATA
This dataset is a combination of two previous datasets that were archived on 10/27/2022. For historical purposes, you can access the archived datasets at the following links:

ARCHIVED: COVID Vaccinations Given to SF Residents Over Time
ARCHIVED: COVID Vaccinations Given to SF Residents by SF DPH Over Time

F. CHANGE LOG

• 11/1/2023 - data on COVID-19 vaccinations given to SF residents by over time are no longer being updated. This data is currently through 10/31/2023 and will not include any new data after this date.
  
• 10/27/2022 - the datasets COVID Vaccinations Given to SF Residents Over Time and COVID Vaccinations Given to SF Residents by SF DPH Over Time were merged into a single dataset. The column “administering_provider_type” can be used to filter between the two metrics. These previous datasets can be found in the ARCHIVED DATA section.
  
• 10/27/2022 - the columns “new_1st_doses”, “new_2nd_doses”, and “new_single_doses” were removed and consolidated into the column “new_primary_series_doses” (which also includes 3rd doses for the Pfizer Under 5 series). S

A. SUMMARY
This dataset represents San Francisco COVID-19 positive confirmed cases by vaccination status over time, starting January 1, 2021. Cases are included on the date the positive test was collected (the specimen collection date). Cases are counted in three categories: (1) all cases; (2) unvaccinated cases; and (3) completed primary series cases.

1. All cases: Includes cases among all San Francisco residents regardless of vaccination status.

2. Unvaccinated cases: Cases are considered unvaccinated if their positive COVID-19 test was before receiving any vaccine. Cases that are not matched to a COVID-19 vaccination record are considered unvaccinated.

3. Completed primary series cases: Cases are considered completed primary series if their positive COVID-19 test was 14 days or more after they received their 2nd dose in a 2-dose COVID-19 series or the single dose of a 1-dose vaccine. These are also called “breakthrough cases.”

On September 12, 2021, a new case definition of COVID-19 was introduced that includes criteria for enumerating new infections after previous probable or confirmed infections (also known as reinfections). A reinfection is defined as a confirmed positive PCR lab test more than 90 days after a positive PCR or antigen test. The first reinfection case was identified on December 7, 2021.

Data is lagged by eight days, meaning the most recent specimen collection date included is eight days prior to today. All data updates daily as more information becomes available.

B. HOW THE DATASET IS CREATED
Case information is based on confirmed positive laboratory tests reported to the City. The City then completes quality assurance and other data verification processes. Vaccination data comes from the California Immunization Registry (CAIR2). The California Department of Public Health runs CAIR2. Individual-level case and vaccination data are matched to identify cases by vaccination status in this dataset. Case records are matched to vaccine records using first name, last name, date of birth, phone number, and email address.

We include vaccination records from all nine Bay Area counties in order to improve matching rates. This allows us to identify breakthrough cases among people who moved to the City from other Bay Area counties after completing their vaccine series. Only cases among San Francisco residents are included.

C. UPDATE PROCESS
Updates automatically at 08:00 AM Pacific Time each day.

D. HOW TO USE THIS DATASET
Total San Francisco population estimates 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). To identify total San Francisco population estimates, filter the view on “demographic_category_label” = “all ages”.

Population estimates by vaccination status are derived from our publicly reported vaccination counts, which can be found at COVID-19 Vaccinations Given to SF Residents Over Time.

The dataset includes new cases, 7-day average new cases, new case rates, 7-day average new case rates, percent of total cases, and 7-day average percent of total cases for each vaccination category.

New cases are the count of cases where the positive tests were collected on that specific specimen collection date. The 7-day rolling average shows the trend in new cases. The rolling average is calculated by averaging the new cases for a particular day with the prior 6 days.

New case rates are the count of new cases per 100,000 residents in each vaccination status group. The 7-day rolling average shows the trend in case rates. The rolling average is calculated by averaging the case rate for a part

A. SUMMARY
This dataset represents the COVID-19 vaccinations given to residents of San Francisco over time. 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). The data are broken down by multiple demograp