Note: In these datasets, a person is defined as up to date if they have received at least one dose of an updated COVID-19 vaccine. The Centers for Disease Control and Prevention (CDC) recommends that certain groups, including adults ages 65 years and older, receive additional doses.

Starting on July 13, 2022, the denominator for calculating vaccine coverage has been changed from age 5+ to all ages to reflect new vaccine eligibility criteria. Previously the denominator was changed from age 16+ to age 12+ on May 18, 2021, then changed from age 12+ to age 5+ on November 10, 2021, to reflect previous changes in vaccine eligibility criteria. The previous datasets based on age 12+ and age 5+ denominators have been uploaded as archived tables.

Starting June 30, 2021, the dataset has been reconfigured so that all updates are appended to one dataset to make it easier for API and other interfaces. In addition, historical data has been extended back to January 5, 2021.

This dataset shows full, partial, and at least 1 dose coverage rates by zip code tabulation area (ZCTA) for the state of California. Data sources include the California Immunization Registry and the American Community Survey’s 2015-2019 5-Year data.

This is the data table for the LHJ Vaccine Equity Performance dashboard. However, this data table also includes ZTCAs that do not have a VEM score.

This dataset also includes Vaccine Equity Metric score quartiles (when applicable), which combine the Public Health Alliance of Southern California’s Healthy Places Index (HPI) measure with CDPH-derived scores to estimate factors that impact health, like income, education, and access to health care. ZTCAs range from less healthy community conditions in Quartile 1 to more healthy community conditions in Quartile 4.

The Vaccine Equity Metric is for weekly vaccination allocation and reporting purposes only. CDPH-derived quartiles should not be considered as indicative of the HPI score for these zip codes. CDPH-derived quartiles were assigned to zip codes excluded from the HPI score produced by the Public Health Alliance of Southern California due to concerns with statistical reliability and validity in populations smaller than 1,500 or where more than 50% of the population resides in a group setting.

These data do not include doses administered by the following federal agencies who received vaccine allocated directly from CDC: Indian Health Service, Veterans Health Administration, Department of Defense, and the Federal Bureau of Prisons.

For some ZTCAs, vaccination coverage may exceed 100%. This may be a result of many people from outside the county coming to that ZTCA to get their vaccine and providers reporting the county of administration as the county of residence, and/or the DOF estimates of the population in that ZTCA are too low. Please note that population numbers provided by DOF are projections and so may not be accurate, especially given unprecedented shifts in population as a result of the pandemic.

Note: This dataset is no longer being updated due to the end of the COVID-19 Public Health Emergency. The California Department of Public Health (CDPH) is identifying vaccination status of COVID-19 cases, hospitalizations, and deaths by analyzing the state immunization registry and registry of confirmed COVID-19 cases. Post-vaccination cases are individuals who have a positive SARS-Cov-2 molecular test (e.g. PCR) at least 14 days after they have completed their primary vaccination series. Tracking cases of COVID-19 that occur after vaccination is important for monitoring the impact of immunization campaigns. While COVID-19 vaccines are safe and effective, some cases are still expected in persons who have been vaccinated, as no vaccine is 100% effective. For more information, please see https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/Post-Vaccine-COVID19-Cases.aspx Post-vaccination infection data is updated monthly and includes data on cases, hospitalizations, and deaths among the unvaccinated and the vaccinated. Partially vaccinated individuals are excluded. To account for reporting and processing delays, there is at least a one-month lag in provided data (for example data published on 9/9/22 will include data through 7/31/22). Notes: On September 9, 2022, the post-vaccination data has been changed to compare unvaccinated with those with at least a primary series completed for persons age 5+. These data will be updated monthly (first Thursday of the month) and include at least a one month lag. On February 2, 2022, the post-vaccination data has been changed to distinguish between vaccination with a primary series only versus vaccinated and boosted. The previous dataset has been uploaded as an archived table. Additionally, the lag on this data has been extended to 14 days. On November 29, 2021, the denominator for calculating vaccine coverage has been changed from age 16+ to age 12+ to reflect new vaccine eligibility criteria. The previous dataset based on age 16+ denominators has been uploaded as an archived table.

**Effective November 14, 2024 this page will no longer be updated. Information about COVID-19 and other respiratory viruses is available on Public Health Ontario’s interactive respiratory virus tool: https://www.publichealthontario.ca/en/Data-and-Analysis/Infectious-Disease/Respiratory-Virus-Tool ** As of January 26, 2023, the population counts are based on Statistics Canada’s 2021 estimates. The coverage methodology has been revised to calculate age based on the current date and deceased individuals are no longer included. The method used to count daily dose administrations has changed is now based on the date delivered versus the day entered into the data system. Historical data has been updated. Please note that Cases by Vaccination Status data will no longer be published as of June 30, 2022. Please note that case rates by vaccination status and age group data will no longer be published as of July 13, 2022. Please note that Hospitalization by Vaccination Status data will no longer be published as of June 30, 2022. Learn more about COVID-19 vaccines. ##Data includes: * daily and total doses administered * individuals with at least one dose * individuals fully vaccinated * total doses given to fully vaccinated individuals * vaccinations by age * percentage of age group * individuals with at least one dose, by PHU, by age group * individuals fully vaccinated, by PHU, by age group * COVID-19 cases by status: not fully vaccinated, fully vaccinated, vaccinated with booster * individuals in hospital due to COVID-19 (excluding ICU) by status: unvaccinated, partially vaccinated, fully vaccinated * individuals in ICU due to COVID-19 by status: unvaccinated, partially vaccinated, fully vaccinated, unknown * rate of COVID-19 cases per 100,000 by status and age group * rate per 100,000 (7-day average) by status and age group All data reflects totals from 8 p.m. the previous day. This dataset is subject to change. Additional notes * Data entry of vaccination records is still in progress, therefore the dosage data may not be a full representation of all vaccination doses administered in Ontario. * The data does not include dosage data where consent was not provided for vaccination records to be entered into the provincial CoVax system. This includes individual records as well as records from some Indigenous communities where those communities have not consented to including vaccination information into CoVax. ##Hospitalizations and cases by vaccination status Hospitalizations * This is a new data collection and the data quality will continue to improve as hospitals continue to submit data. * In order to understand the vaccination status of patients currently hospitalized, a new data collection process was developed and this may cause discrepancies between other hospitalization numbers being collected using a different data collection process. * Data on patients in ICU are being collected from two different data sources with different extraction times and public reporting cycles. The existing data source (Critical Care Information System, CCIS) does not have vaccination status. * Historical data for hospitalizations by region may change over time as hospitals update previously entered data. * Due to incomplete weekend and holiday reporting, vaccination status data for hospital and ICU admissions is not updated on Sundays, Mondays and the day after holidays * Unvaccinated is defined as not having any dose, or between 0-13 days after administration of the first dose of a COVID-19 vaccine. * Partially vaccinated is defined as 14 days or more after the first dose of a 2-dose series COVID-19 vaccine, or between 0-13 days after administration of the second dose * Fully vaccinated is defined as 14 days or more after receipt of the second dose of a 2-dose series COVID-19 vaccine Cases * The cases by vaccination status may not match the daily COVID-19 case count because records with a missing or invalid health card number cannot be linked.

As of 10/27/2022, this dataset will no longer update. To continue to access updated vaccination metrics given to SF residents, including newly added bivalent boosters, please navigate to the following page: COVID-19 Vaccinations Given to SF Residents by Demographics.

A. SUMMARY 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.

B. HOW THE DATASET IS CREATED Information on doses administered to those who live in San Francisco is from the California Immunization Registry (CAIR), 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 the same 2019 five-year American Community Survey population estimates that are used in our public dashboards.

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 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).

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). The data are broken down by multiple demographic stratifications. 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). 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 the 2016-2020 American Community Survey (ACS) population estimates for each demographic group.

C. UPDATE PROCESS Updated daily via automated process

D. HOW TO USE THIS DATASET San Francisco population estimates for race/ethnicity and age groups can be found in a view based on the San Francisco Population and Demographic Census dataset. These population estimates are from the 2016-2020 5-year American Community Survey (ACS).

Before analysis, you must filter the dataset to the desired stratification of data using the "overall_segment" column.

For example, filtering "overall_segment" to "All SF Residents by Age Bracket, Administered by All Providers" will filter the data to residents 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 "All SF Residents by Race/Ethnicity, Administered by DPH Only", you will see the race/ethnicity breakdown for residents who received vaccinations from the San Francisco Department of Public Health (SFDPH).

If you filter "overall_segment" to "All SF Residents by Age Group, Administered by All Providers" you will see vaccination counts of various age eligibility groups that were administered by any provider.

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 A previous version of this dataset

On 6/28/2023, data on cases by vaccination status will be archived and will no longer update. A. SUMMARY This dataset represents San Francisco COVID-19 positive confirmed cases by vaccination status over time, starting January 1, 2021. Cases are included on the date the positive test was collected (the specimen collection date). Cases are counted in three categories: (1) all cases; (2) unvaccinated cases; and (3) completed primary series cases. All cases: Includes cases among all San Francisco residents regardless of vaccination status. Unvaccinated cases: Cases are considered unvaccinated if their positive COVID-19 test was before receiving any vaccine. Cases that are not matched to a COVID-19 vaccination record are considered unvaccinated. Completed primary series cases: Cases are considered completed primary series if their positive COVID-19 test was 14 days or more after they received their 2nd dose in a 2-dose COVID-19 series or the single dose of a 1-dose vaccine. These are also called “breakthrough cases.” On September 12, 2021, a new case definition of COVID-19 was introduced that includes criteria for enumerating new infections after previous probable or confirmed infections (also known as reinfections). A reinfection is defined as a confirmed positive PCR lab test more than 90 days after a positive PCR or antigen test. The first reinfection case was identified on December 7, 2021. Data is lagged by eight days, meaning the most recent specimen collection date included is eight days prior to today. All data updates daily as more information becomes available. B. HOW THE DATASET IS CREATED Case information is based on confirmed positive laboratory tests reported to the City. The City then completes quality assurance and other data verification processes. Vaccination data comes from the California Immunization Registry (CAIR2). The California Department of Public Health runs CAIR2. Individual-level case and vaccination data are matched to identify cases by vaccination status in this dataset. Case records are matched to vaccine records using first name, last name, date of birth, phone number, and email address. We include vaccination records from all nine Bay Area counties in order to improve matching rates. This allows us to identify breakthrough cases among people who moved to the City from other Bay Area counties after completing their vaccine series. Only cases among San Francisco residents are included. C. UPDATE PROCESS Updates automatically at 08:00 AM Pacific Time each day. D. HOW TO USE THIS DATASET Total San Francisco population estimates can be found in a view based on the San Francisco Population and Demographic Census dataset. These population estimates are from the 2016-2020 5-year American Community Survey (ACS). To identify total San Francisco population estimates, filter the view on “demographic_category_label” = “all ages”. Population estimates by vaccination status are derived from our publicly reported vaccination counts, which can be found at COVID-19 Vaccinations Given to SF Residents Over Time. The dataset includes new cases, 7-day average new cases, new case rates, 7-day average new case rates, percent of total cases, and 7-day average percent of total cases for each vaccination category. New cases are the count of cases where the positive tests were collected on that specific specimen collection date. The 7-day rolling average shows the trend in new cases. The rolling average is calculated by averaging the new cases for a particular day with the prior 6 days. New case rates are the count of new cases per 100,000 residents in each vaccination status group. The 7-day rolling average shows the trend in case rates. The rolling average is calculated by averaging the case rate for a part

This dataset reports the daily reported number of the 7-day moving average rates of Deaths involving COVID-19 by vaccination status and by age group. Learn how the Government of Ontario is helping to keep Ontarians safe during the 2019 Novel Coronavirus outbreak. Effective November 14, 2024 this page will no longer be updated. Information about COVID-19 and other respiratory viruses is available on Public Health Ontario’s interactive respiratory virus tool: https://www.publichealthontario.ca/en/Data-and-Analysis/Infectious-Disease/Respiratory-Virus-Tool Data includes: * Date on which the death occurred * Age group * 7-day moving average of the last seven days of the death rate per 100,000 for those not fully vaccinated * 7-day moving average of the last seven days of the death rate per 100,000 for those fully vaccinated * 7-day moving average of the last seven days of the death rate per 100,000 for those vaccinated with at least one booster ##Additional notes As of June 16, all COVID-19 datasets will be updated weekly on Thursdays by 2pm. As of January 12, 2024, data from the date of January 1, 2024 onwards reflect updated population estimates. This update specifically impacts data for the 'not fully vaccinated' category. On November 30, 2023 the count of COVID-19 deaths was updated to include missing historical deaths from January 15, 2020 to March 31, 2023. CCM is a dynamic disease reporting system which allows ongoing update to data previously entered. As a result, data extracted from CCM represents a snapshot at the time of extraction and may differ from previous or subsequent results. Public Health Units continually clean up COVID-19 data, correcting for missing or overcounted cases and deaths. These corrections can result in data spikes and current totals being different from previously reported cases and deaths. Observed trends over time should be interpreted with caution for the most recent period due to reporting and/or data entry lags. The data does not include vaccination data for people who did not provide consent for vaccination records to be entered into the provincial COVaxON system. This includes individual records as well as records from some Indigenous communities where those communities have not consented to including vaccination information in COVaxON. “Not fully vaccinated” category includes people with no vaccine and one dose of double-dose vaccine. “People with one dose of double-dose vaccine” category has a small and constantly changing number. The combination will stabilize the results. Spikes, negative numbers and other data anomalies: Due to ongoing data entry and data quality assurance activities in Case and Contact Management system (CCM) file, Public Health Units continually clean up COVID-19, correcting for missing or overcounted cases and deaths. These corrections can result in data spikes, negative numbers and current totals being different from previously reported case and death counts. Public Health Units report cause of death in the CCM based on information available to them at the time of reporting and in accordance with definitions provided by Public Health Ontario. The medical certificate of death is the official record and the cause of death could be different. Deaths are defined per the outcome field in CCM marked as “Fatal”. Deaths in COVID-19 cases identified as unrelated to COVID-19 are not included in the Deaths involving COVID-19 reported. Rates for the most recent days are subject to reporting lags All data reflects totals from 8 p.m. the previous day. This dataset is subject to change.

Context

Vaccinations provide people the ability to develop immunity to particular diseases. When the majority of a population is vaccinated, “herd immunity” protects those who have not been vaccinated by blocking the spread of these diseases. A medical research paper published by The Lancet in 1998 suggested an association between the Measles/Mumps/Rubella (MMR) vaccine and Autism spectrum disorders. The paper was later fully-retracted due controversy surrounding the lead author, who had financial conflicts of interest and allegedly manipulated the study data. However, it generated worldwide concern over the safety of MMR and other types of vaccines, including Diphtheria/Tetanus/Pertussis (DTP).

In California by 2010, the growing trend for parents to opt out of having their children receive vaccines over the following decade coincided with the largest Pertussis outbreak in more than 60 years. Reduced vaccination frequency was also linked to a high-profile measles outbreak in 2014 that began at Disneyland. The resulting California state legislation (Senate Bill 277), signed June 2015, made it much more difficult for parents to opt out of vaccinations for their children. The data set will allow you to explore individual public and private school vaccination rates of incoming Kindergarten students for the 2000 to 2014 school years.

Content

The data are records for every school with ten or more students reporting the number of incoming Kindergarteners who provided either proof of immunization, personal beliefs exemption (PBE), or permanent medical exemption (PME). Annual records for the 2000-2001 through 2014-2015 school years have been formatted and combined. Common variables in these annual data sets included in the merged file are the number of students, school name, school county, the number of PBEs, PMEs, and number of students vaccinated for:

• Diphtheria/Tetanus/Pertussis (DTP)
• Polio
• Measles/Mumps/Rubella (MMR)

One additional file contains 5 years of county-level Pertussis case numbers and rates. Another additional data file contains the number of infant Pertussis cases for infants under three months old for each county in California between 2014-2015.

Geographic data are available in a file based on scripted geocode calls using the ggmap R package to find latitude and longitude data using the school names and county names. Not all calls returned a valid coordinate, so additional indicator variables in this file indicate the quality of the match. The isSchool indicator variable is 1 if the geocode search meta data included "school" and the countyMatch indicator is 1 if the latitude and longitude coordinates are contained within the appropriate county in CA.

References:

1. Retracted Lancet Research Article
2. Report on 2010 Pertussis Outbreak

Acknowledgements

Individual data files and detailed annual reports for every school year in this data set are provided by the California Department of Public Health (CDPH). Individual schools and licensed child care facilities are required to report immunization information to CDPH every year to maintain compliance with the California Health and Safety Code. Additional details as well as child care and 7th grade data files can be found on the CDPH website: https://www.cdph.ca.gov/programs/immunize/Pages/ImmunizationLevels.aspx

County level case data were pulled from the following report: https://archive.cdph.ca.gov/programs/immunize/Documents/Pertussis_Report_1-7-2015.pdf

Infant Pertussis data were reported to CDPH as of 2/10/2016. Additional Pertussis reports can be found here: https://www.cdph.ca.gov/programs/immunize/Pages/PertussisSummaryReports.aspx

Inspiration

While the Disneyland measles outbreak received much media attention, Pertussis outbreaks in California present great health risks to infants and the elderly. Can you predict which counties and schools are at greatest risk for outbreaks and/or quantify the association between vaccination rates and the number infant Pertussis cases?

*** The County of Santa Clara Public Health Department discontinued updates to the COVID-19 data tables effective June 30, 2025. The COVID-19 data tables will be removed from the Open Data Portal on December 30, 2025. For current information on COVID-19 in Santa Clara County, please visit the Respiratory Virus Dashboard [sccphd.org/respiratoryvirusdata]. For any questions, please contact phinternet@phd.sccgov.org ***

The dataset provides number of county residents who are booster vaccinated by age group. Number of people vaccinated (completed primary series) is the number of county residents who either received a vaccine requiring a single dose (Janssen/Johnson & Johnson) or received the second dose of a vaccine requiring two doses (Pfizer or Moderna). Source: California Immunization Registry. This table is updated Monday-Friday and will not be updated on holidays.

Counties are experiencing temporary fluctuations in vaccination data received from the State of California due to a data reconciliation process involving integration of vaccination data systems by the State. The data reconciliation process and associated fluctuations in county vaccination are expected to be resolved by May 2022

This dataset provides the cumulative number and percent of people who have received a COVID-19 vaccine by vaccine product, number of doses, jurisdiction, and report week. Variables include:

• Jurisdiction ID number

• Jurisdiction

• Report week

• Vaccine product

• Cumulative number vaccinated with at least 1 dose

• Cumulative number vaccinated with 2 doses

• Cumulative proportion vaccinated with at least 1 dose

• Cumulative proportion vaccinated with 2 doses

For variable definitions, see the data dictionary. For details regarding data sources and limitations, see the technical notes section of the Canadian COVID-19 vaccination coverage report (https://health-infobase.canada.ca/covid-19/vaccination-coverage/technical-notes.html).

The dataset provides number of county residents who are vaccinated by gender. Number of people vaccinated (completed primary series) is the number of county residents who either received a vaccine requiring a single dose (Janssen/Johnson & Johnson) or received the second dose of a vaccine requiring two doses (Pfizer or Moderna). Source: California Immunization Registry. This table is updated Monday-Friday and will not be updated on holidays.

Counties are experiencing temporary fluctuations in vaccination data received from the State of California due to a data reconciliation process involving integration of vaccination data systems by the State. The data reconciliation process and associated fluctuations in county vaccination are expected to be resolved by June 2022

*** The County of Santa Clara Public Health Department discontinued updates to the COVID-19 data tables effective June 30, 2025. The COVID-19 data tables will be removed from the Open Data Portal on December 30, 2025. For current information on COVID-19 in Santa Clara County, please visit the Respiratory Virus Dashboard [sccphd.org/respiratoryvirusdata]. For any questions, please contact phinternet@phd.sccgov.org ***

The dataset provides number of county residents who are Booster vaccinated by Race/Ethnicity. Number of people who completed 1st Booster Vaccinations. Source: California Immunization Registry. This table is updated Monday-Friday and will not be updated on holidays.

Counties are experiencing temporary fluctuations in vaccination data received from the State of California due to a data reconciliation process involving integration of vaccination data systems by the State. The data reconciliation process and associated fluctuations in county vaccination are expected to be resolved by May 2022

A. SUMMARY This dataset represents all San Francisco (SF) residents who have received a vaccine for certain respiratory viruses that circulate more heavily in the fall and winter months. All vaccines given to SF residents are included, even if they received their vaccination elsewhere in California. The data are broken down by demographic and geographical stratifications. COVID-19: This dataset represents all SF residents who are considered up to date on their COVID-19 vaccine. A person is up to date if they have received at least one dose of the 2024–2025 COVID-19 vaccine. The specific up-to-date criteria can be found on the California Department of Public Health (CDPH) website. (Note: As of November 2024, this dataset only contains data regarding COVID-19 vaccinations. This documentation will be updated as other seasonal vaccination data is added). B. HOW THE DATASET IS CREATED Information on doses administered to those who live in SF is from the California Immunization Registry (CAIR2), run by 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 the 2018-2022 American Community Survey (ACS) population estimates for each demographic group and analysis neighborhood. C. UPDATE PROCESS Updated daily via automated process. D. HOW TO USE THIS DATASET SF population estimates for race/ethnicity and age groups can be found in a view based on the San Francisco Population and Demographic Census dataset. SF population estimates for analysis neighborhoods can be found in a view based on the San Francisco Population and Geography Census dataset. Both of these views use population estimates from the 2018-2022 5-year ACS. Before analysis, you must filter the dataset to the desired stratification of data using the “vaccine_type” and "demographic_group" columns. For example, filtering “vaccine_type” to “COVID-19” will allow you to only look at rows corresponding to COVID-19 vaccinations. Filtering “demographic_subgroup” to “Analysis Neighborhood” will allow you to only look at rows corresponding to SF neighborhoods. You can then calculate the percentages of those up to date with their COVID-19 vaccinations by neighborhood. The “vaccine_subtype” field provides information about the current vaccine product being tracked in this dataset. E. CHANGE LOG 11/5/2024 - Dataset updated to reflect up to date status for the 2024-2025 monovalent formulation of the COVID-19 vaccine. 7/2/2024 - Population estimates were updated to reflect the most recent ACS data.

The dataset provides number of county residents who are Second Booster vaccinated by Race/Ethnicity. Number of people who completed 1st Booster Vaccinations. Source: California Immunization Registry. This table is updated Monday-Friday and will not be updated on holidays.

Counties are experiencing temporary fluctuations in vaccination data received from the State of California due to a data reconciliation process involving integration of vaccination data systems by the State. The data reconciliation process and associated fluctuations in county vaccination are expected to be resolved by May 2022

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

See the Splitgraph documentation for more information.

The dataset provides number of county residents who are vaccinated by age group. Number of people vaccinated (completed primary series) is the number of county residents who either received a vaccine requiring a single dose (Janssen/Johnson & Johnson) or received the second dose of a vaccine requiring two doses (Pfizer or Moderna). Source: California Immunization Registry. This table is updated Monday-Friday and will not be updated on holidays.

The COVID-19 Vaccination Coverage Survey (CVCS) targets all Canadian adults living in the 10 provinces and the capital cities of the 3 territories, except those who live: in institutions or collective dwellings; on-reserve. The purpose of the survey is to measure COVID-19 vaccination coverage in Canada and the provinces and territories. The survey compares vaccination coverage levels by different socio-demographic subgroups. This survey also helps to: find out why some people choose not to get vaccinated; find out if people who are not yet vaccinated against COVID-19 plan to get vaccinated; learn more about people's knowledge, attitudes and beliefs about COVID-19 vaccines and vaccines in general; learn more about trusted sources of information related to COVID-19 vaccines to inform communication efforts. Our most reliable vaccination coverage estimates are those based on provincial and territorial registries. The CVCS complements this system with additional information. The CVCS has multiple cycles. The first cycle was conducted in the capital cities of the territories. The second cycle was conducted in the 10 provinces. More cycles targeting adults living in the provinces may be carried out in the future. The collection period for a cycle is approximately 4 weeks.

The dataset provides number of county residents who are vaccinated by Race/Ethnicity. Number of people vaccinated (completed primary series) is the number of county residents who either received a vaccine requiring a single dose (Janssen/Johnson & Johnson) or received the second dose of a vaccine requiring two doses (Pfizer or Moderna). Source: California Immunization Registry. This table is updated Monday-Friday and will not be updated on holidays.

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

See the Splitgraph documentation for more information.

In early February 2024, we will be retiring the Mpox Vaccinations Given to SF Residents Over Time dataset. This dataset will be archived and no longer update. A historic record of this data will remain available A. SUMMARY This dataset represents doses of mpox vaccine (JYNNEOS) administered in California to residents of San Francisco ages 18 years or older. This dataset only includes doses of the JYNNEOS vaccine given on or after 5/1/2022. All vaccines given to people who live in San Francisco are included, no matter where the vaccination took place. 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 Each row reflects the number of first, second, and total doses administered on that date and up through that date. E. CHANGE LOG UPDATE 1/3/2023: Due to low case numbers, this page will no longer include vaccinations after 12/31/2022.

This dataset provides the cumulative number and percent of people who have received a COVID-19 vaccine in Canada by report week, number of doses, and jurisdiction. Variables include: * Report week * Jurisdiction ID number * Jurisdiction * Cumulative number vaccinated with at least 1 dose * Cumulative number vaccinated with 2 doses * Cumulative proportion vaccinated with at least 1 dose * Cumulative proportion vaccinated with 2 doses For variable definitions, see the data dictionary. For details regarding data sources and limitations, see the technical notes section of the Canadian COVID-19 vaccination coverage report.

On 6/28/2023, data on cases by vaccination status will be archived and will no longer update.

A. SUMMARY This dataset represents San Francisco COVID-19 positive confirmed cases by vaccination status over time, starting January 1, 2021. Cases are included on the date the positive test was collected (the specimen collection date). Cases are counted in three categories: (1) all cases; (2) unvaccinated cases; and (3) completed primary series cases.

1. All cases: Includes cases among all San Francisco residents regardless of vaccination status.

2. Unvaccinated cases: Cases are considered unvaccinated if their positive COVID-19 test was before receiving any vaccine. Cases that are not matched to a COVID-19 vaccination record are considered unvaccinated.

3. Completed primary series cases: Cases are considered completed primary series if their positive COVID-19 test was 14 days or more after they received their 2nd dose in a 2-dose COVID-19 series or the single dose of a 1-dose vaccine. These are also called “breakthrough cases.”

On September 12, 2021, a new case definition of COVID-19 was introduced that includes criteria for enumerating new infections after previous probable or confirmed infections (also known as reinfections). A reinfection is defined as a confirmed positive PCR lab test more than 90 days after a positive PCR or antigen test. The first reinfection case was identified on December 7, 2021.

Data is lagged by eight days, meaning the most recent specimen collection date included is eight days prior to today. All data updates daily as more information becomes available.

B. HOW THE DATASET IS CREATED Case information is based on confirmed positive laboratory tests reported to the City. The City then completes quality assurance and other data verification processes. Vaccination data comes from the California Immunization Registry (CAIR2). The California Department of Public Health runs CAIR2. Individual-level case and vaccination data are matched to identify cases by vaccination status in this dataset. Case records are matched to vaccine records using first name, last name, date of birth, phone number, and email address.

We include vaccination records from all nine Bay Area counties in order to improve matching rates. This allows us to identify breakthrough cases among people who moved to the City from other Bay Area counties after completing their vaccine series. Only cases among San Francisco residents are included.

C. UPDATE PROCESS Updates automatically at 08:00 AM Pacific Time each day.

D. HOW TO USE THIS DATASET Total San Francisco population estimates can be found in a view based on the San Francisco Population and Demographic Census dataset. These population estimates are from the 2016-2020 5-year American Community Survey (ACS). To identify total San Francisco population estimates, filter the view on “demographic_category_label” = “all ages”.

Population estimates by vaccination status are derived from our publicly reported vaccination counts, which can be found at COVID-19 Vaccinations Given to SF Residents Over Time.

The dataset includes new cases, 7-day average new cases, new case rates, 7-day average new case rates, percent of total cases, and 7-day average percent of total cases for each vaccination category.

New cases are the count of cases where the positive tests were collected on that specific specimen collection date. The 7-day rolling average shows the trend in new cases. The rolling average is calculated by averaging the new cases for a particular day with the prior 6 days.

New case rates are the count of new cases per 100,000 residents in each vaccination status group. The 7-day rolling average shows the trend in case rates. The rolling average is calculated by averaging the case rate for a particular day with the prior six days. Percent of total new cases shows the percent of all cases on each day that were among a particular vaccination status.

Here is more information on how each case rate is calculated:

1. The case rate for all cases is equal to the number of new cases among all residents divided by the estimated total resident population.

2. Unvaccinated case rates are equal to the number of new cases among unvaccinated residents divided by the estimated number of unvaccinated residents. The estimated number of unvaccinated residents is calculated by subtracting the number of residents that have received at least one dose of a vaccine from the total estimated resident population.

3. Completed primary series case rates are equal to the number of new cases among completed primary series residents divided by the estimated number of completed primary series residents. The estimated number of completed primary series residents is calculated by taking the number of residents who have completed their primary series over time and adding a 14-day delay to the “date_administered” column, to align with the definition of “Completed primary series cases” above.

E. CHANGE LOG

• 6/28/2023 - data on cases by vaccination status are no longer being updated. This data is currently through 6/20/2023 (as of 6/28/2023) and will not include any new data after this date.
  
• 4/6/2023 - the State implemented system updates to improve the integrity of historical data.
• 2/21/2023 - system updates to improve reliability and accuracy of cases data were implemented.
• 1/31/2023 - updated “sf_population” column to reflect the 2020 Census Bureau American Community Survey (ACS) San Francisco Population estimates.
• 1/31/2023 - renamed column “last_updated_at” to “data_as_of”.
• 1/22/2022 - system updates to improve timeliness and accuracy of cases and deaths data were implemented.
• 7/15/2022 - reinfections added to cases dataset. See section SUMMARY for more information on how reinfections are identified.
• 7/15/2022 - references to “fully vaccinated” replaced with “completed primary series” in column “vaccination_status".
• 7/15/2022 - rows with “partially vaccinated” in column “vaccination_status” removed from dataset.