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.

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.

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.

Percentage of county residents with completed COVID-19 vaccination by census tract of residence. Source: California Immunization Registry. Note: Number of people with completed vaccination is the number of county residents who either received a vaccine requiring a single dose or received the final dose of a vaccine requiring multiple doses. Percent of residents vaccinated and population age 12 years and older is based in part on estimates of the number of people residing in the census tract from a population-based survey sample, which is subject to error. As a result, percent vaccinated may be over- or under-estimated. For this reason, the displayed percent of residents vaccinated in a census tract is capped at 95%.

COVID-19 vaccination among county residents by census tract is updated every Tuesday.

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

This dataset provides the cumulative number and percent of people who have received a COVID-19 vaccine by vaccine product, number of doses, and report week. Variables include: - Report week number - Report week - Cumulative number vaccinated with at least 1 dose - Cumulative number vaccinated with only 1 dose - Cumulative number vaccinated with 2 doses - Cumulative proportion vaccinated with at least 1 dose - Cumulative proportion vaccinated with only 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).

Data for CDC’s COVID Data Tracker site on Rates of COVID-19 Cases and Deaths by Vaccination Status. Click 'More' for important dataset description and footnotes

Dataset and data visualization details: These data were posted on October 21, 2022, archived on November 18, 2022, and revised on February 22, 2023. These data reflect cases among persons with a positive specimen collection date through September 24, 2022, and deaths among persons with a positive specimen collection date through September 3, 2022.

Vaccination status: A person vaccinated with a primary series had SARS-CoV-2 RNA or antigen detected on a respiratory specimen collected ≥14 days after verifiably completing the primary series of an FDA-authorized or approved COVID-19 vaccine. An unvaccinated person had SARS-CoV-2 RNA or antigen detected on a respiratory specimen and has not been verified to have received COVID-19 vaccine. Excluded were partially vaccinated people who received at least one FDA-authorized vaccine dose but did not complete a primary series ≥14 days before collection of a specimen where SARS-CoV-2 RNA or antigen was detected. Additional or booster dose: A person vaccinated with a primary series and an additional or booster dose had SARS-CoV-2 RNA or antigen detected on a respiratory specimen collected ≥14 days after receipt of an additional or booster dose of any COVID-19 vaccine on or after August 13, 2021. For people ages 18 years and older, data are graphed starting the week including September 24, 2021, when a COVID-19 booster dose was first recommended by CDC for adults 65+ years old and people in certain populations and high risk occupational and institutional settings. For people ages 12-17 years, data are graphed starting the week of December 26, 2021, 2 weeks after the first recommendation for a booster dose for adolescents ages 16-17 years. For people ages 5-11 years, data are included starting the week of June 5, 2022, 2 weeks after the first recommendation for a booster dose for children aged 5-11 years. For people ages 50 years and older, data on second booster doses are graphed starting the week including March 29, 2022, when the recommendation was made for second boosters. Vertical lines represent dates when changes occurred in U.S. policy for COVID-19 vaccination (details provided above). Reporting is by primary series vaccine type rather than additional or booster dose vaccine type. The booster dose vaccine type may be different than the primary series vaccine type. ** Because data on the immune status of cases and associated deaths are unavailable, an additional dose in an immunocompromised person cannot be distinguished from a booster dose. This is a relevant consideration because vaccines can be less effective in this group. Deaths: A COVID-19–associated death occurred in a person with a documented COVID-19 diagnosis who died; health department staff reviewed to make a determination using vital records, public health investigation, or other data sources. Rates of COVID-19 deaths by vaccination status are reported based on when the patient was tested for COVID-19, not the date they died. Deaths usually occur up to 30 days after COVID-19 diagnosis. Participating jurisdictions: Currently, these 31 health departments that regularly link their case surveillance to immunization information system data are included in these incidence rate estimates: Alabama, Arizona, Arkansas, California, Colorado, Connecticut, District of Columbia, Florida, Georgia, Idaho, Indiana, Kansas, Kentucky, Louisiana, Massachusetts, Michigan, Minnesota, Nebraska, New Jersey, New Mexico, New York, New York City (New York), North Carolina, Philadelphia (Pennsylvania), Rhode Island, South Dakota, Tennessee, Texas, Utah, Washington, and West Virginia; 30 jurisdictions also report deaths among vaccinated and unvaccinated people. These jurisdictions represent 72% of the total U.S. population and all ten of the Health and Human Services Regions. Data on cases

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

Data for CDC’s COVID Data Tracker site on Rates of COVID-19 Cases and Deaths by Vaccination Status. Click 'More' for important dataset description and footnotes

Dataset and data visualization details: These data were posted on October 21, 2022, archived on November 18, 2022, and revised on February 22, 2023. These data reflect cases among persons with a positive specimen collection date through September 24, 2022, and deaths among persons with a positive specimen collection date through September 3, 2022.

Vaccination status: A person vaccinated with a primary series had SARS-CoV-2 RNA or antigen detected on a respiratory specimen collected ≥14 days after verifiably completing the primary series of an FDA-authorized or approved COVID-19 vaccine. An unvaccinated person had SARS-CoV-2 RNA or antigen detected on a respiratory specimen and has not been verified to have received COVID-19 vaccine. Excluded were partially vaccinated people who received at least one FDA-authorized vaccine dose but did not complete a primary series ≥14 days before collection of a specimen where SARS-CoV-2 RNA or antigen was detected. Additional or booster dose: A person vaccinated with a primary series and an additional or booster dose had SARS-CoV-2 RNA or antigen detected on a respiratory specimen collected ≥14 days after receipt of an additional or booster dose of any COVID-19 vaccine on or after August 13, 2021. For people ages 18 years and older, data are graphed starting the week including September 24, 2021, when a COVID-19 booster dose was first recommended by CDC for adults 65+ years old and people in certain populations and high risk occupational and institutional settings. For people ages 12-17 years, data are graphed starting the week of December 26, 2021, 2 weeks after the first recommendation for a booster dose for adolescents ages 16-17 years. For people ages 5-11 years, data are included starting the week of June 5, 2022, 2 weeks after the first recommendation for a booster dose for children aged 5-11 years. For people ages 50 years and older, data on second booster doses are graphed starting the week including March 29, 2022, when the recommendation was made for second boosters. Vertical lines represent dates when changes occurred in U.S. policy for COVID-19 vaccination (details provided above). Reporting is by primary series vaccine type rather than additional or booster dose vaccine type. The booster dose vaccine type may be different than the primary series vaccine type. ** Because data on the immune status of cases and associated deaths are unavailable, an additional dose in an immunocompromised person cannot be distinguished from a booster dose. This is a relevant consideration because vaccines can be less effective in this group. Deaths: A COVID-19–associated death occurred in a person with a documented COVID-19 diagnosis who died; health department staff reviewed to make a determination using vital records, public health investigation, or other data sources. Rates of COVID-19 deaths by vaccination status are reported based on when the patient was tested for COVID-19, not the date they died. Deaths usually occur up to 30 days after COVID-19 diagnosis. Participating jurisdictions: Currently, these 31 health departments that regularly link their case surveillance to immunization information system data are included in these incidence rate estimates: Alabama, Arizona, Arkansas, California, Colorado, Connecticut, District of Columbia, Florida, Georgia, Idaho, Indiana, Kansas, Kentucky, Louisiana, Massachusetts, Michigan, Minnesota, Nebraska, New Jersey, New Mexico, New York, New York City (New York), North Carolina, Philadelphia (Pennsylvania), Rhode Island, South Dakota, Tennessee, Texas, Utah, Washington, and West Virginia; 30 jurisdictions also report deaths among vaccinated and unvaccinated people. These jurisdictions represent 72% of the total U.S. population and all ten of the Health and Human Services Regions. Data on 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 ***

Percentage of county residents with completed COVID-19 vaccination by census tract of residence. Source: California Immunization Registry. Note: Number of people with completed vaccination is the number of county residents who either received a vaccine requiring a single dose or received the final dose of a vaccine requiring multiple doses. Percent of residents vaccinated and population age 5 years and older is based in part on estimates of the number of people residing in the census tract from a population-based survey sample, which is subject to error. As a result, percent vaccinated may be over- or under-estimated. For this reason, the displayed percent of residents vaccinated in a census tract is capped at 95%.

COVID-19 vaccination among county residents by census tract is updated every Tuesday. This table was updated for the last time on January 24, 2023.

A. SUMMARY This dataset represents the COVID-19 vaccinations given to residents of San Francisco. 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). 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), use the "total_recipients" column. To count the number of individuals who have completed their primary vaccine series, use the "total_series_completed" column. To count the number of primary series doses administered (1st, 2nd, 3rd, or single doses), use the "total_primary_series_doses" column. To count the number of individuals who received one or two monovalent (not bivalent) booster doses, use the "total_booster_recipients" and "total_2nd_booster_recipients" columns. To count the number of individuals who received their first bivalent booster dose, use the "total_bivalent_booster_recipients" column. To count the number of monovalent (not including bivalent) or bivalent booster doses administered, use the "total_booster_doses" or "total_bivalent_booster_doses" columns. E. ARCHIVED DATA A previous version of this dataset was archived on 10/27/2022. For historical purposes, you can access the archived dataset at the following link: ARCHIVED: COVID-19 Vaccine Doses Given to San Franciscans by Demographics F. CHA

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.

Health and Safety Code section 1288.7(a) requires California acute care hospitals to offer influenza vaccine free of charge to all healthcare providers (HCP) or sign a declination form if a HCP chooses not to be vaccinated. Hospitals must report HCP influenza vaccination data to the California Department of Public Health (CDPH), including the percentage of HCP vaccinated. CDPH is required to make this information public on an annual basis [Health and Safety Code section 1288.8 (b)]. California acute care hospitals are required to offer free influenza vaccine to HCP. Hospital HCP must receive an annual vaccine or sign a declination form. Hospitals collect vaccination data for all HCP physically working in the hospital for at least one day during influenza season, regardless of clinical responsibility or patient contact. Hospitals report HCP vaccination rates to the California Department of Public Health (CDPH) and CDPH publishes the hospital results annually. CDPH reports data separately for hospital employees, licensed independent practitioners such as physicians, other contract staff, and trainees and volunteers (Health and Safety Code section 1288.7-1288.8). Detailed information about the variables included in each dataset are described in the accompanying data dictionaries for the year of interest. For general information about NHSN, surveillance definitions, and reporting requirements for HCP influenza vaccination, please visit: https://www.cdc.gov/nhsn/hps/vaccination/index.html To link the CDPH facility IDs with those from other Departments, including OSHPD, please reference the "Licensed Facility Cross-Walk" Open Data table at: https://data.chhs.ca.gov/dataset/licensed-facility-crosswalk. For information about healthcare personnel influenza vaccinations in California hospitals, please visit: https://www.cdph.ca.gov/Programs/CHCQ/HAI/Pages/HealthcarePersonnelInfluenzaVaccinationReportingInCA_Hospitals.aspx

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

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.

"This dataset provides the cumulative number and percent of people in key populations who have received a COVID-19 vaccine in Canada, by number of doses and report week. Key populations are identified by the National Advisory Committee on Immunization and prioritized for early vaccination. Variables include: - Key population - Report week number - Report week - Cumulative number vaccinated with at least 1 dose - Cumulative number vaccinated with only 1 dose - Cumulative number vaccinated with 2 doses - Cumulative proportion vaccinated with at least 1 dose - Cumulative proportion vaccinated with only 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)."

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 dataset provides number of Santa Clara County residents who were administered at least one dose of COVID-19 vaccine by city. Source: California Immunization Registry Note: Percent of residents vaccinated and population age 16 years and older is based in part on estimates of the number of people residing in the census tract from a population-based survey sample, which is subject to error. As a result, percent vaccinated may be over- or under-estimated. For this reason, the displayed percent of residents vaccinated in a census tract is capped at 95%.

Number and percentage of persons who reported having their last influenza immunization in the past 12 months, by age group and sex.

As of March 10, 2023, there have been 1.1 million deaths related to COVID-19 in the United States. There have been 101,159 deaths in the state of California, more than any other state in the country – California is also the state with the highest number of COVID-19 cases.

The vaccine rollout in the U.S. Since the start of the pandemic, the world has eagerly awaited the arrival of a safe and effective COVID-19 vaccine. In the United States, the immunization campaign started in mid-December 2020 following the approval of a vaccine jointly developed by Pfizer and BioNTech. As of March 22, 2023, the number of COVID-19 vaccine doses administered in the U.S. had reached roughly 673 million. The states with the highest number of vaccines administered are California, Texas, and New York.

Vaccines achieved due to work of research groups Chinese authorities initially shared the genetic sequence to the novel coronavirus in January 2020, allowing research groups to start studying how it invades human cells. The surface of the virus is covered with spike proteins, which enable it to bind to human cells. Once attached, the virus can enter the cells and start to make people ill. These spikes were of particular interest to vaccine manufacturers because they hold the key to preventing viral entry.