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