COVID-19 Vaccine Doses Given to San Franciscans by Demographics Over Time
data.sfgov.org | Last Updated 19 May 2022Note 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).
This dataset has the following 26 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
DATE_ADMINISTERED | date_administered | calendar_date | Date vaccination administered | 2021-12-14T00:00:00.000 2022-04-24T00:00:00.000 2021-12-21T00:00:00.000 2021-12-10T00:00:00.000 2022-02-20T00:00:00.000 view top 100 |
ADMINISTERING_PROVIDER_TYPE | administering_provider_type | text | Providers included in a given OVERALL_SEGMENT. Two possible values: 'All' (including SF DPH) or 'DPH Only' | All Providers DPH Only view top 100 |
NEW_1ST_DOSES | new_1st_doses | number | Count of 1st doses administered for vaccines that take two doses to complete | 0 1 2 3 4 view top 100 |
NEW_2ND_DOSES | new_2nd_doses | number | Count of 2nd doses administered for vaccines that take two doses to complete | 0 1 2 3 4 view top 100 |
NEW_SINGLE_DOSES | new_single_doses | number | Count of doses administered for vaccines that take one dose to complete | 0 1 2 3 4 view top 100 |
NEW_SERIES_COMPLETED | new_series_completed | number | Count 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) | 0 1 2 3 4 view top 100 |
NEW_RECIPIENTS | new_recipients | number | Count of individuals vaccinated (with any dose) for the first time according to CA's records | 0 1 2 3 4 view top 100 |
CUMULATIVE_1ST_DOSES | cumulative_1st_doses | number | Cumulative total of 1st doses administered for vaccines that take two doses to complete | 0 6 35 5 606 view top 100 |
CUMULATIVE_2ND_DOSES | cumulative_2nd_doses | number | Cumulative total of 2nd doses administered for vaccines that take two doses to complete | 0 1 2 5 36 view top 100 |
CUMULATIVE_SINGLE_DOSES | cumulative_single_doses | number | Cumulative total of doses administered for vaccines that take one dose to complete | 0 1 26 182 41 view top 100 |
CUMULATIVE_SERIES_COMPLETED | cumulative_series_completed | number | Cumulative total individuals fully vaccinated (given the 2nd dose of a two-dose vaccine or one dose of a single dose vaccine) | 0 1 2 5 36 view top 100 |
CUMULATIVE_RECIPIENTS | cumulative_recipients | number | Cumulative total individuals vaccinated (with any dose) according to CA's records | 0 5 6 35 643 view top 100 |
OVERALL_SEGMENT | overall_segment | text | Segment (universe) of analysis. Unique combination of ADMINISTERING_PROVIDER_TYPE, AGE_GROUP, and DEMOGRAPHIC_GROUP. Filter to a single option to derive meaningful totals. | All Ages by Age Bracket, Administered by All Providers All Ages by Age Bracket, Administered by DPH Only Ages 5+ by Race/Ethnicity, Administered by All Providers All Ages by Race/Ethnicity, Administered by All Providers Ages 12+ by Race/Ethnicity, Administered by All Providers view top 100 |
AGE_GROUP | age_group | text | Age range included in a given OVERALL_SEGMENT | All 5+ 12+ 65+ view top 100 |
DEMOGRAPHIC_GROUP | demographic_group | text | Type of demographic group included in a given OVERALL_SEGMENT (e.g. Age, Race/Ethnicity) | Race/Ethnicity Age Bracket Age Bracket - Alternate view top 100 |
DEMOGRAPHIC_SUBGROUP | demographic_subgroup | text | Specific demographic group counted in a given record (e.g. 16-24, Asian) | White 65-74 Asian Hispanic or Latino/a, all races Black or African American view top 100 |
SUBGROUP_POPULATION | subgroup_population | number | American Community Survey population estimates for given DEMOGRAPHIC_SUBGROUP | 74120 60907 0 33938 204639 view top 100 |
AGE_GROUP_POPULATION | age_group_population | number | American Community Survey population estimates for overall AGE_GROUP | 835137 791131 874787 135027 874961 view top 100 |
DEMOGRAPHIC_SUBGROUP_SORT_ORDER | demographic_subgroup_sort_order | number | Numeric sort order for all DEMOGRAPHIC_SUBGROUPs. Convenient for maintaining consistent ordering across multiple data visualizations. | 4 9 5 3 6 view top 100 |
NEW_BOOSTER_DOSES | new_booster_doses | number | Count of booster doses administered on a given day | 0 1 2 3 4 view top 100 |
NEW_BOOSTER_RECIPIENTS | new_booster_recipients | number | Count of individuals who received a booster dose on a given day | 0 1 2 3 4 view top 100 |
CUMULATIVE_BOOSTER_DOSES | cumulative_booster_doses | number | Cumulative total booster doses administered to San Francisco residents | 0 1 2 3 8 view top 100 |
CUMULATIVE_BOOSTER_RECIPIENTS | cumulative_booster_recipients | number | Cumulative total individuals who have received a booster dose | 0 1 2 3 8 view top 100 |
DATA_AS_OF | data_as_of | calendar_date | Timestamp when the data was last updated in the source system | 2022-04-26T06:00:11.000 view top 100 |
DATA_UPDATED_AT | data_updated_at | calendar_date | Timestamp when the data was last compiled by scripts | 2022-04-26T07:18:01.917 view top 100 |
DATA_LOADED_AT | data_loaded_at | calendar_date | Timestamp when the data was last updated here (in the open data portal) | 2022-04-26T08:15:32.801 2022-04-26T08:15:30.595 2022-04-26T08:15:26.387 2022-04-26T08:15:30.516 2022-04-26T08:15:18.684 view top 100 |