ARCHIVED: COVID-19 Vaccinations Given To SF Residents Over Time
City of San Francisco
@usgov.city_of_san_francisco_covid_19_vaccinations_given_to_s_097b48a6
City of San Francisco
@usgov.city_of_san_francisco_covid_19_vaccinations_given_to_s_097b48a6
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
CREATE TABLE table_1 (
"date_administered" TIMESTAMP,
"administering_provider_type" VARCHAR,
"new_primary_series_doses" BIGINT,
"new_recipients" BIGINT,
"new_series_completed" BIGINT,
"new_booster_doses" BIGINT,
"new_booster_recipients" BIGINT,
"new_2nd_booster_recipients" BIGINT,
"new_bivalent_booster_doses" BIGINT,
"new_bivalent_booster_recipients" BIGINT,
"cumulative_primary_series_doses" BIGINT,
"cumulative_recipients" BIGINT,
"cumulative_series_completed" BIGINT,
"cumulative_booster_doses" BIGINT,
"cumulative_booster_recipients" BIGINT,
"cumulative_2nd_booster_recipients" BIGINT,
"cumulative_bivalent_booster_doses" BIGINT,
"cumulative_bivalent_booster_recipients" BIGINT,
"data_as_of" VARCHAR,
"data_updated_at" VARCHAR,
"data_loaded_at" VARCHAR
);Anyone who has the link will be able to view this.