sfgov/covid19-vaccine-doses-given-to-san-franciscans-by-xjh5-h442

  • covid
  • covid-19
  • vaccination
  • vaccines

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

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

<strong>A. SUMMARY</strong>

This dataset represents doses of COVID-19 vaccine administered in California to San Francisco residents over time. The data is broken down by multiple demographic slices. The three dose types are counted separately, i.e. (1) first doses administered as a part of a two-dose vaccination, (2) second doses administered as part of a two-dose vaccination, and (3) single-dose vaccines administered.

<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 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 slice of data using the OVERALL_SEGMENT column.

For example, filtering OVERALL_SEGMENT to "Ages 16+ by Age Bracket, Administered by All Providers" will filter the data to residents 16 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).

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
NEW_SERIES_COMPLETEDnew_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)
OVERALL_SEGMENToverall_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.
DATE_ADMINISTEREDdate_administereddate_administeredCalendar dateDate vaccination administered
CUMULATIVE_SERIES_COMPLETEDcumulative_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)
DATA_LOADED_ATdata_loaded_atdata_loaded_atCalendar dateTimestamp when the record (row) was most recently updated here in the Open Data Portal
NEW_1ST_DOSESnew_1st_dosesnew_1st_dosesNumberCount of 1st doses administered for vaccines that take two doses to complete
CUMULATIVE_2ND_DOSEScumulative_2nd_dosescumulative_2nd_dosesNumberCumulative total of 2nd doses administered for vaccines that take two doses to complete
AGE_GROUPage_groupage_groupTextAge range included in a given OVERALL_SEGMENT
CUMULATIVE_1ST_DOSEScumulative_1st_dosescumulative_1st_dosesNumberCumulative total of 1st doses administered for vaccines that take two doses to complete
ADMINISTERING_PROVIDER_TYPEadministering_provider_typeadministering_provider_typeTextProviders included in a given OVERALL_SEGMENT. Two possible values: 'All' (including SF DPH) or 'DPH Only'
NEW_RECIPIENTSnew_recipientsnew_recipientsNumberCount of individuals vaccinated (with any dose) for the first time according to CA's records
DEMOGRAPHIC_GROUPdemographic_groupdemographic_groupTextType of demographic group included in a given OVERALL_SEGMENT (e.g. Age, Race/Ethnicity)
DEMOGRAPHIC_SUBGROUPdemographic_subgroupdemographic_subgroupTextSpecific demographic group counted in a given record (e.g. 16-24, Asian)
NEW_2ND_DOSESnew_2nd_dosesnew_2nd_dosesNumberCount of 2nd doses administered for vaccines that take two doses to complete
NEW_SINGLE_DOSESnew_single_dosesnew_single_dosesNumberCount of doses administered for vaccines that take one dose to complete
DEMOGRAPHIC_SUBGROUP_SORT_ORDERdemographic_subgroup_sort_orderdemographic_subgroup_sort_orderNumberNumeric sort order for all DEMOGRAPHIC_SUBGROUPs. Convenient for maintaining consistent ordering across multiple data visualizations.
CUMULATIVE_SINGLE_DOSEScumulative_single_dosescumulative_single_dosesNumberCumulative total of doses administered for vaccines that take one dose to complete
DATA_AS_OFdata_as_ofdata_as_ofCalendar dateTimestamp for last update date in source system
SUBGROUP_POPULATIONsubgroup_populationsubgroup_populationNumberAmerican Community Survey population estimates for given DEMOGRAPHIC_SUBGROUP
AGE_GROUP_POPULATIONage_group_populationage_group_populationNumberAmerican Community Survey population estimates for overall AGE_GROUP
CUMULATIVE_RECIPIENTScumulative_recipientscumulative_recipientsNumberCumulative total individuals vaccinated (with any dose) according to CA's records

Upstream Metadata