COVID-19 Vaccine Doses Given to San Franciscans by Demographics Over Time

data.sfgov.org | Last Updated 19 May 2022

Note April 2022: We have identified and corrected an issue with our data processing. You will notice an increase in vaccination numbers and percentages as a result of this correction. <strong>A. SUMMARY</strong> This dataset represents doses of COVID-19 vaccine administered in California to San Francisco residents over time. All vaccines given to people who live in San Francisco 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. As of December 21, 2021, four dose types are counted separately, i.e. (1) first doses administered as a part of a two-dose primary vaccination series, (2) second doses administered as part of a two-dose primary vaccination series, and (3) single-dose vaccines administered as part of a one-dose primary series, and (4) booster doses regardless of primary vaccine type. <strong>B. HOW THE DATASET IS CREATED</strong> Information on doses administered to those who live in San Francisco is from the <a href="https://cairweb.org/about-cair/">California Immunization Registry (CAIR)</a>, 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 <a href="https://data.census.gov/cedsci/table?q=popualtion%20age&g=0500000US06075&tid=ACSST5Y2019.S0101&hidePreview=false">the same 2019 five-year American Community Survey population estimates</a> that are used in <a href="https://data.sfgov.org/stories/s/COVID-19-Vaccinations-Progress/7mye-zncy/">our public dashboards</a>. <strong>C. UPDATE PROCESS</strong> Updated daily via automated process <strong>D. HOW TO USE THIS DATASET</strong> Before analysis, you must filter the dataset to the desired stratification of data using the OVERALL_SEGMENT column. For example, filtering OVERALL_SEGMENT to "Ages 5+ by Age Bracket, Administered by All Providers" will filter the data to residents 5 and over 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 "Ages 65+ by Race/Ethnicity, Administered by DPH Only", you will see the race/ethnicity breakdown for residents aged 65+ who received vaccinations from San Francisco’s Department of Public Health (DPH).

Tags: covid, covid-19, vaccination, vaccines

This dataset has the following 26 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
DATE_ADMINISTEREDdate_administeredcalendar_dateDate vaccination administered
ADMINISTERING_PROVIDER_TYPEadministering_provider_typetextProviders included in a given OVERALL_SEGMENT. Two possible values: 'All' (including SF DPH) or 'DPH Only'
NEW_1ST_DOSESnew_1st_dosesnumberCount of 1st doses administered for vaccines that take two doses to complete
NEW_2ND_DOSESnew_2nd_dosesnumberCount of 2nd doses administered for vaccines that take two doses to complete
NEW_SINGLE_DOSESnew_single_dosesnumberCount of doses administered for vaccines that take one dose to complete
NEW_SERIES_COMPLETEDnew_series_completednumberCount of individuals newly fully vaccinated on a given day (given the 2nd dose of a two-dose vaccine or one dose of a single dose vaccine)
NEW_RECIPIENTSnew_recipientsnumberCount of individuals vaccinated (with any dose) for the first time according to CA's records
CUMULATIVE_1ST_DOSEScumulative_1st_dosesnumberCumulative total of 1st doses administered for vaccines that take two doses to complete
CUMULATIVE_2ND_DOSEScumulative_2nd_dosesnumberCumulative total of 2nd doses administered for vaccines that take two doses to complete
CUMULATIVE_SINGLE_DOSEScumulative_single_dosesnumberCumulative total of doses administered for vaccines that take one dose to complete
CUMULATIVE_SERIES_COMPLETEDcumulative_series_completednumberCumulative total individuals fully vaccinated (given the 2nd dose of a two-dose vaccine or one dose of a single dose vaccine)
CUMULATIVE_RECIPIENTScumulative_recipientsnumberCumulative total individuals vaccinated (with any dose) according to CA's records
OVERALL_SEGMENToverall_segmenttextSegment (universe) of analysis. Unique combination of ADMINISTERING_PROVIDER_TYPE, AGE_GROUP, and DEMOGRAPHIC_GROUP. Filter to a single option to derive meaningful totals.
AGE_GROUPage_grouptextAge range included in a given OVERALL_SEGMENT
DEMOGRAPHIC_GROUPdemographic_grouptextType of demographic group included in a given OVERALL_SEGMENT (e.g. Age, Race/Ethnicity)
DEMOGRAPHIC_SUBGROUPdemographic_subgrouptextSpecific demographic group counted in a given record (e.g. 16-24, Asian)
SUBGROUP_POPULATIONsubgroup_populationnumberAmerican Community Survey population estimates for given DEMOGRAPHIC_SUBGROUP
AGE_GROUP_POPULATIONage_group_populationnumberAmerican Community Survey population estimates for overall AGE_GROUP
DEMOGRAPHIC_SUBGROUP_SORT_ORDERdemographic_subgroup_sort_ordernumberNumeric sort order for all DEMOGRAPHIC_SUBGROUPs. Convenient for maintaining consistent ordering across multiple data visualizations.
NEW_BOOSTER_DOSESnew_booster_dosesnumberCount of booster doses administered on a given day
NEW_BOOSTER_RECIPIENTSnew_booster_recipientsnumberCount of individuals who received a booster dose on a given day
CUMULATIVE_BOOSTER_DOSEScumulative_booster_dosesnumberCumulative total booster doses administered to San Francisco residents
CUMULATIVE_BOOSTER_RECIPIENTScumulative_booster_recipientsnumberCumulative total individuals who have received a booster dose
DATA_AS_OFdata_as_ofcalendar_dateTimestamp when the data was last updated in the source system
DATA_UPDATED_ATdata_updated_atcalendar_dateTimestamp when the data was last compiled by scripts
DATA_LOADED_ATdata_loaded_atcalendar_dateTimestamp when the data was last updated here (in the open data portal)