COVID-19 Vaccine Doses Given to San Franciscans by Demographics

data.sfgov.org | Last Updated 10 Aug 2022

<strong>A. SUMMARY</strong> This dataset represents doses of COVID-19 vaccine administered in California to residents of San Francisco. 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. <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: vaccination

This dataset has the following 19 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
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.
ADMINISTERING_PROVIDER_TYPEadministering_provider_typetextProviders included in a given OVERALL_SEGMENT. Two possible values: 'All' (including SF DPH) or 'DPH Only'
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)
TOTAL_1ST_DOSEStotal_1st_dosesnumberTotal number of first doses administered
TOTAL_2ND_DOSEStotal_2nd_dosesnumberTotal number of second doses administered
TOTAL_SINGLE_DOSEStotal_single_dosesnumberTotal number of single dose vaccines administered
TOTAL_RECIPIENTStotal_recipientsnumberTotal number of unique vaccine recipients
TOTAL_SERIES_COMPLETEDtotal_series_completednumberTotal number of individuals that have completed their primary vaccine series
SUBGROUP_POPULATIONsubgroup_populationnumber2019 5-year American Community Survey population estimates for given DEMOGRAPHIC_SUBGROUP
AGE_GROUP_POPULATIONage_group_populationnumber2019 5-year American 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.
TOTAL_BOOSTER_DOSEStotal_booster_dosesnumberTotal number of booster doses administered
TOTAL_BOOSTER_RECIPIENTStotal_booster_recipientsnumberTotal number of unique booster recipients
MAX_DATE_ADMINISTEREDmax_date_administeredcalendar_dateData includes vaccine doses administered through this date
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)