The dashboard is updated each Friday.

Laboratory surveillance data: California laboratories report SARS-CoV-2 test results to CDPH through electronic laboratory reporting. Los Angeles County SARS-CoV-2 lab data has a 7-day reporting lag. Test positivity is calculated using SARS-CoV-2 lab tests that has a specimen collection date reported during a given week. Specimens for testing are collected from patients in healthcare settings and do not reflect all testing for COVID-19 in California. Test positivity for a given week is calculated by dividing the number of positive COVID-19 results by the total number of specimens tested for that virus. Weekly laboratory surveillance data are defined as Sunday through Saturday.

Hospitalization data: Data on COVID-19 and influenza hospital admissions are from Centers for Disease Control and Prevention’s (CDC) National Healthcare Safety Network (NHSN) Hospitalization dataset. The requirement to report COVID-19-associated hospitalizations was effective November 1, 2024. CDPH pulls NHSN data from the CDC on the Wednesday prior to the publication of the report. Results may differ depending on which day data are pulled. Admission rates are calculated using population estimates from the P-3: Complete State and County Projections Dataset (https://dof.ca.gov/forecasting/demographics/projections/) provided by the State of California Department of Finance. Reported weekly admission rates for the entire season use the population estimates for the year the season started. For more information on NHSN data including the protocol and data collection information, see the CDC NHSN webpage (https://www.cdc.gov/nhsn/index.html). Weekly hospitalization data are defined as Sunday through Saturday.

Death certificate data: CDPH receives weekly year-to-date dynamic data on deaths occurring in California from the CDPH Center for Health Statistics and Informatics. These data are limited to deaths occurring among California residents and are analyzed to identify COVID-19-coded deaths. These deaths are not necessarily laboratory-confirmed and are an underestimate of all COVID-19-associated deaths in California. Weekly death data are defined as Sunday through Saturday.

Data is from the California Department of Public Health (CDPH) Respiratory Virus Weekly Report.

The report is updated each Friday.

Laboratory surveillance data: California laboratories report SARS-CoV-2 test results to CDPH through electronic laboratory reporting. Los Angeles County SARS-CoV-2 lab data has a 7-day reporting lag. Test positivity is calculated using SARS-CoV-2 lab tests that has a specimen collection date reported during a given week.

Laboratory surveillance for influenza, respiratory syncytial virus (RSV), and other respiratory viruses (parainfluenza types 1-4, human metapneumovirus, non-SARS-CoV-2 coronaviruses, adenovirus, enterovirus/rhinovirus) involves the use of data from clinical sentinel laboratories (hospital, academic or private) located throughout California. Specimens for testing are collected from patients in healthcare settings and do not reflect all testing for influenza, respiratory syncytial virus, and other respiratory viruses in California. These laboratories report the number of laboratory-confirmed influenza, respiratory syncytial virus, and other respiratory virus detections and isolations, and the total number of specimens tested by virus type on a weekly basis.

Test positivity for a given week is calculated by dividing the number of positive COVID-19, influenza, RSV, or other respiratory virus results by the total number of specimens tested for that virus. Weekly laboratory surveillance data are defined as Sunday through Saturday.

Hospitalization data: Data on COVID-19 and influenza hospital admissions are from Centers for Disease Control and Prevention’s (CDC) National Healthcare Safety Network (NHSN) Hospitalization dataset. The requirement to report COVID-19 and influenza-associated hospitalizations was effective November 1, 2024. CDPH pulls NHSN data from the CDC on the Wednesday prior to the publication of the report. Results may differ depending on which day data are pulled. Admission rates are calculated using population estimates from the P-3: Complete State and County Projections Dataset provided by the State of California Department of Finance (https://dof.ca.gov/forecasting/demographics/projections/). Reported weekly admission rates for the entire season use the population estimates for the year the season started. For more information on NHSN data including the protocol and data collection information, see the CDC NHSN webpage (https://www.cdc.gov/nhsn/index.html).

CDPH collaborates with Northern California Kaiser Permanente (NCKP) to monitor trends in RSV admissions. The percentage of RSV admissions is calculated by dividing the number of RSV-related admissions by the total number of admissions during the same period. Admissions for pregnancy, labor and delivery, birth, and outpatient procedures are not included in total number of admissions. These admissions serve as a proxy for RSV activity and do not necessarily represent laboratory confirmed hospitalizations for RSV infections; NCKP members are not representative of all Californians.

Weekly hospitalization data are defined as Sunday through Saturday.

Death certificate data: CDPH receives weekly year-to-date dynamic data on deaths occurring in California from the CDPH Center for Health Statistics and Informatics. These data are limited to deaths occurring among California residents and are analyzed to identify influenza, respiratory syncytial virus, and COVID-19-coded deaths. These deaths are not necessarily laboratory-confirmed and are an underestimate of all influenza, respiratory syncytial virus, and COVID-19-associated deaths in California. Weekly death data are defined as Sunday through Saturday.

Wastewater data: This dataset represents statewide weekly SARS-CoV-2 wastewater summary values. SARS-CoV-2 wastewater concentrations from all sites in California are combined into a single, statewide, unit-less summary value for each week, using a method for data transformation and aggregation developed by the CDC National Wastewater Surveillance System (NWSS). Please see the CDC NWSS data methods page for a description of how these summary values are calculated. Weekly wastewater data are defined as Sunday through Saturday.

Note: This COVID-19 data set is no longer being updated as of December 1, 2023. Access current COVID-19 data on the CDPH respiratory virus dashboard (https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/Respiratory-Viruses/RespiratoryDashboard.aspx) or in open data format (https://data.chhs.ca.gov/dataset/respiratory-virus-dashboard-metrics).

As of August 17, 2023, data is being updated each Friday.

For death data after December 31, 2022, California uses Provisional Deaths from the Center for Disease Control and Prevention’s National Center for Health Statistics (NCHS) National Vital Statistics System (NVSS). Prior to January 1, 2023, death data was sourced from the COVID-19 registry. The change in data source occurred in July 2023 and was applied retroactively to all 2023 data to provide a consistent source of death data for the year of 2023.

As of May 11, 2023, data on cases, deaths, and testing is being updated each Thursday. Metrics by report date have been removed, but previous versions of files with report date metrics are archived below.

All metrics include people in state and federal prisons, US Immigration and Customs Enforcement facilities, US Marshal detention facilities, and Department of State Hospitals facilities. Members of California's tribal communities are also included.

The "Total Tests" and "Positive Tests" columns show totals based on the collection date. There is a lag between when a specimen is collected and when it is reported in this dataset. As a result, the most recent dates on the table will temporarily show NONE in the "Total Tests" and "Positive Tests" columns. This should not be interpreted as no tests being conducted on these dates. Instead, these values will be updated with the number of tests conducted as data is received.

The dataset summarizes the number and rate of cases, tests and positivity at zip code level over time. Data are summarized as three-week time period.

This dataset is updated every Thursday.

*** 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 ***

Cumulative COVID-19 positivity rate among county residents per 100 COVID-19 tests performed by census tract. Source: California Department of Public Health, California Reportable Disease Information Exchange (CalREDIE). Note: Data are not presented if the test count is between 1 to 10 and/or population size is less than 1000 in a census tract.

COVID-19 cumulative positivity rate by census tract is updated the first Tuesday of each month. This table was updated for the last time on January 24, 2023.

Learn how the Government of Ontario is helping to keep Ontarians safe during the 2019 Novel Coronavirus outbreak.

Data includes:

• date
• age group
• average testing percent positive

**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 **

This dataset is subject to change. Please review the daily epidemiologic summaries for information on variables, methodology, and technical considerations.

Note: This dataset is on hiatus. CDPH strives to respond equitably to the COVID-19 pandemic and is therefore interested in how different communities are impacted. Collecting and reporting health equity data helps to identify health disparities and improve the state’s response. To that end, CDPH tracks cases, deaths, and testing by race and ethnicity as well as other social determinants of health, such as income, crowded housing, and access to health insurance. During the response, CDPH used a health equity metric, defined as the positivity rate in the most disproportionately-impacted communities according to the Healthy Places Index. The purpose of this metric was to ensure California reopened its economy safely by reducing disease transmission in all communities. This metric is tracked and reported in comparison to statewide positivity rate. More information is available at https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/CaliforniaHealthEquityMetric.aspx. Data completeness is also critical to addressing inequities. CDPH reports data completeness by race and ethnicity, sexual orientation, and gender identity to better understand missingness in the data. Health equity data is updated weekly. Data may be suppressed based on county population or total counts. For more information on California’s commitment to health equity, please see https://covid19.ca.gov/equity/

As of March 10, 2023, the state with the highest rate of COVID-19 cases was Rhode Island followed by Alaska. Around 103.9 million cases have been reported across the United States, with the states of California, Texas, and Florida reporting the highest numbers of infections.

From an epidemic to a pandemic The World Health Organization declared the COVID-19 outbreak as a pandemic on March 11, 2020. The term pandemic refers to multiple outbreaks of an infectious illness threatening multiple parts of the world at the same time; when the transmission is this widespread, it can no longer be traced back to the country where it originated. The number of COVID-19 cases worldwide is roughly 683 million, and it has affected almost every country in the world.

The symptoms and those who are most at risk Most people who contract the virus will suffer only mild symptoms, such as a cough, a cold, or a high temperature. However, in more severe cases, the infection can cause breathing difficulties and even pneumonia. Those at higher risk include older persons and people with pre-existing medical conditions, including diabetes, heart disease, and lung disease. Those aged 85 years and older have accounted for around 27 percent of all COVID deaths in the United States, although this age group makes up just two percent of the total population

As of March 10, 2023, the state with the highest number of COVID-19 cases was California. Almost 104 million cases have been reported across the United States, with the states of California, Texas, and Florida reporting the highest numbers.

From an epidemic to a pandemic The World Health Organization declared the COVID-19 outbreak a pandemic on March 11, 2020. The term pandemic refers to multiple outbreaks of an infectious illness threatening multiple parts of the world at the same time. When the transmission is this widespread, it can no longer be traced back to the country where it originated. The number of COVID-19 cases worldwide has now reached over 669 million.

The symptoms and those who are most at risk Most people who contract the virus will suffer only mild symptoms, such as a cough, a cold, or a high temperature. However, in more severe cases, the infection can cause breathing difficulties and even pneumonia. Those at higher risk include older persons and people with pre-existing medical conditions, including diabetes, heart disease, and lung disease. People aged 85 years and older have accounted for around 27 percent of all COVID-19 deaths in the United States, although this age group makes up just two percent of the U.S. population

Note: This dataset is no longer being updated due to the end of the COVID-19 Public Health Emergency. Note: On 2/16/22, 17,467 cases based on at-home positive test results were excluded from the probable case counts. Per national case classification guidelines, cases based on at-home positive results are now classified as “suspect” cases. The majority of these cases were identified between November 2021 and February 2022. CDPH tracks both probable and confirmed cases of COVID-19 to better understand how the virus is impacting our communities. Probable cases are defined as individuals with a positive antigen test that detects the presence of viral antigens. Antigen testing is useful when rapid results are needed, or in settings where laboratory resources may be limited. Confirmed cases are defined as individuals with a positive molecular test, which tests for viral genetic material, such as a PCR or polymerase chain reaction test. Results from both types of tests are reported to CDPH. Due to the expanded use of antigen testing, surveillance of probable cases is increasingly important. The proportion of probable cases among the total cases in California has increased. To provide a more complete picture of trends in case volume, it is now more important to provide probable case data in addition to confirmed case data. The Centers for Disease Control and Prevention (CDC) has begun publishing probable case data for states. Testing data is updated weekly. Due to small numbers, the percentage of probable cases in the first two weeks of the month may change. Probable case data from San Diego County is not included in the statewide table at this time. For more information, please see https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/Probable-Cases.aspx

Note: Blueprint has been retired as of June 15, 2021. This dataset will be kept up for historical purposes, but will no longer be updated. California has a new blueprint for reducing COVID-19 in the state with revised criteria for loosening and tightening restrictions on activities. Every county in California is assigned to a tier based on its test positivity and adjusted case rate for tier assignment. Additionally, a new health equity metric took effect on October 6, 2020. In order to advance to the next less restrictive tier, each county will need to meet an equity metric or demonstrate targeted investments to eliminate disparities in levels of COVID-19 transmission, depending on its size. The California Health Equity Metric is designed to help guide counties in their continuing efforts to reduce COVID-19 cases in all communities and requires more intensive efforts to prevent and mitigate the spread of COVID-19 among Californians who have been disproportionately impacted by this pandemic. Please see https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/COVID-19/COVID19CountyMonitoringOverview.aspx for more information. Also, in lieu of a Data Dictionary, please refer to the detailed explanation of the data columns in Appendix 1 of the above webpage. Because this data is in machine-readable format, the merged headers at the top of the source spreadsheet have not been included: The first 8 columns are under the header "County Status as of Tier Assignment" The next 3 columns are under the header "Current Data Week Tier and Metric Tiers for Data Week" The next 4 columns are under the header "Case Rate Adjustment Factors" The next column is under the header "Small County Considerations" The last 5 columns are under the header "Health Equity Framework Parameters"

This dataset compiles daily snapshots of publicly reported data on 2019 Novel Coronavirus (COVID-19) testing in Ontario.

Learn how the Government of Ontario is helping to keep Ontarians safe during the 2019 Novel Coronavirus outbreak.

Data includes:

• approximation of onset date
• age group
• patient gender
• case acquisition information
• patient outcome
• reporting Public Health Unit (PHU)
• postal code, website, longitude, and latitude of PHU

This dataset is subject to change. Please review the daily epidemiologic summaries for information on variables, methodology, and technical considerations.

Additional information

This data is no longer available on this page. Information about COVID-19, and other respiratory viruses, is available through Public Health Ontario’s “Ontario Respiratory Virus Tool".

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. This impacts data captured in the column ‘Outcome1’.

Due to changes in data availability, the following variables will be removed from this file, effective Thursday April 13, 2023: ‘Case_AcquisitionInfo’, ‘Outbreak_Related’. Also due to changes in data availability, the variable ‘Outcome1’ will be equal to ‘Fatal’ (deaths due to COVID-19) or blank (all other cases)

The methodology used to count COVID-19 deaths has changed to exclude deaths not caused by COVID. This impacts data captured in the column ‘‘Outcome1’ starting with data posted to the catalogue on March 11, 2022.

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.

Related dataset(s)

• Status of COVID-19 cases in Ontario

Status of COVID-19 cases in Ontario

This dataset compiles daily snapshots of publicly reported data on 2019 Novel Coronavirus (COVID-19) testing in Ontario.

Learn how the Government of Ontario is helping to keep Ontarians safe during the 2019 Novel Coronavirus outbreak.

Effective April 13, 2023, this dataset will be discontinued. The public can continue to access the data within this dataset in the following locations updated weekly on the Ontario Data Catalogue:

• Ontario COVID-19 testing percent positive by age group
• Confirmed positive cases of COVID-19 in Ontario
• Ontario COVID-19 testing metrics by Public Health Unit (PHU)
• Ontario COVID-19 testing percent positive by age group
• COVID-19 cases in hospital and ICU, by Ontario Health (OH) region
• Cumulative deaths (new methodology)
• Deaths Involving COVID-19 by Fatality Type

For information on Long-Term Care Home COVID-19 Data, please visit: Long-Term Care Home COVID-19 Data.

Data includes:

• reporting date
• daily tests completed
• total tests completed
• test outcomes
• total case outcomes (resolutions and deaths)
• current tests under investigation
• current hospitalizations
  • current patients in Intensive Care Units (ICUs) due to COVID-related critical Illness
  • current patients in Intensive Care Units (ICUs) testing positive for COVID-19
  • current patients in Intensive Care Units (ICUs) no longer testing positive for COVID-19
  • current patients in Intensive Care Units (ICUs) on ventilators due to COVID-related critical illness
  • current patients in Intensive Care Units (ICUs) on ventilators testing positive for COVID-19
  • current patients in Intensive Care Units (ICUs) on ventilators no longer testing positive for COVID-19
• Long-Term Care (LTC) resident and worker COVID-19 case and death totals
• Variants of Concern case totals
• number of new deaths reported (occurred in the last month)
• number of historical deaths reported (occurred more than one month ago)
• change in number of cases from previous day by Public Health Unit (PHU).

This dataset is subject to change. Please review the daily epidemiologic summaries for information on variables, methodology, and technical considerations.

Cumulative Deaths

**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 **

The methodology used to count COVID-19 deaths has changed to exclude deaths not caused by COVID. This impacts data captured in the columns “Deaths”, “Deaths_Data_Cleaning” and “newly_reported_deaths” starting with data for March 11, 2022. A new column has been added to the file “Deaths_New_Methodology” which represents the methodological change.

The method used to count COVID-19 deaths has changed, effective December 1, 2022. Prior to December 1, 2022, deaths were counted based on the date the death was updated in the public health unit’s system. Going forward, deaths are counted on the date they occurred.

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. A small number of COVID deaths (less than 20) do not have recorded death date and will be excluded from this file.

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.

Related dataset(s)

• Confirmed positive cases of COVID-19 in Ontario

This dataset details the percentage of COVID-19 positive patients in hospitals and ICUs for COVID-19 related reasons, and for reasons other than COVID-19. Data includes: * reporting date * percentage of COVID-19 positive patients in hospital admitted for COVID-19 * percentage of COVID-19 positive patients in hospital admitted for other reasons * percentage of COVID-19 positive patients in ICU admitted for COVID-19 * percentage of COVID-19 positive patients in ICU admitted for other reasons **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 ** Due to incomplete weekend and holiday reporting, data for hospital and ICU admissions are not updated on Sundays, Mondays and the day after holidays. This dataset is subject to change.

Data is from the California Department of Public Health (CDPH) Respiratory Virus Weekly Report. The report is updated each Friday. Laboratory surveillance data: California laboratories report SARS-CoV-2 test results to CDPH through electronic laboratory reporting. Los Angeles County SARS-CoV-2 lab data has a 7-day reporting lag. Test positivity is calculated using SARS-CoV-2 lab tests that has a specimen collection date reported during a given week. Laboratory surveillance for influenza, respiratory syncytial virus (RSV), and other respiratory viruses (parainfluenza types 1-4, human metapneumovirus, non-SARS-CoV-2 coronaviruses, adenovirus, enterovirus/rhinovirus) involves the use of data from clinical sentinel laboratories (hospital, academic or private) located throughout California. Specimens for testing are collected from patients in healthcare settings and do not reflect all testing for influenza, respiratory syncytial virus, and other respiratory viruses in California. These laboratories report the number of laboratory-confirmed influenza, respiratory syncytial virus, and other respiratory virus detections and isolations, and the total number of specimens tested by virus type on a weekly basis. Test positivity for a given week is calculated by dividing the number of positive COVID-19, influenza, RSV, or other respiratory virus results by the total number of specimens tested for that virus. Weekly laboratory surveillance data are defined as Sunday through Saturday. Hospitalization data: Data on COVID-19 and influenza hospital admissions are from Centers for Disease Control and Prevention’s (CDC) National Healthcare Safety Network (NHSN) Hospitalization dataset. The requirement to report COVID-19 and influenza-associated hospitalizations was effective November 1, 2024. CDPH pulls NHSN data from the CDC on the Wednesday prior to the publication of the report. Results may differ depending on which day data are pulled. Admission rates are calculated using population estimates from the P-3: Complete State and County Projections Dataset provided by the State of California Department of Finance (https://dof.ca.gov/forecasting/demographics/projections/). Reported weekly admission rates for the entire season use the population estimates for the year the season started. For more information on NHSN data including the protocol and data collection information, see the CDC NHSN webpage (https://www.cdc.gov/nhsn/index.html). CDPH collaborates with Northern California Kaiser Permanente (NCKP) to monitor trends in RSV admissions. The percentage of RSV admissions is calculated by dividing the number of RSV-related admissions by the total number of admissions during the same period. Admissions for pregnancy, labor and delivery, birth, and outpatient procedures are not included in total number of admissions. These admissions serve as a proxy for RSV activity and do not necessarily represent laboratory confirmed hospitalizations for RSV infections; NCKP members are not representative of all Californians. Weekly hospitalization data are defined as Sunday through Saturday. Death certificate data: CDPH receives weekly year-to-date dynamic data on deaths occurring in California from the CDPH Center for Health Statistics and Informatics. These data are limited to deaths occurring among California residents and are analyzed to identify influenza, respiratory syncytial virus, and COVID-19-coded deaths. These deaths are not necessarily laboratory-confirmed and are an underestimate of all influenza, respiratory syncytial virus, and COVID-19-associated deaths in California. Weekly death data are defined as Sunday through Saturday. Wastewater data: This dataset represents statewide weekly SARS-CoV-2 wastewater summary values. SARS-CoV-2 wastewater concentrations from all sites in California are combined into a single, statewide, unit-less summary value for each week, using a method for data transformation and aggregation developed by the CDC National Wastewater Surveillance System (NWSS). Please see the CDC NWSS data methods page for a description of how these summary values are calculated. Weekly wastewater data are defined as Sunday through Saturday.

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.

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

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.

This dataset has been retired as of February 17, 2023. This dataset will be kept for historical purposes, but will no longer be updated. Similar data are available on the state’s open data portal: https://data.chhs.ca.gov/dataset/covid-19-time-series-metrics-by-county-and-state.

A. DATASET DESCRIPTION This dataset contains COVID-19 positive confirmed cases aggregated by several different geographic areas and by day. COVID-19 cases are mapped to the residence of the individual and shown on the date the positive test was collected. In addition, 2019 American Community Survey (ACS) 5-year population estimates are included to calculate the cumulative rate per 10,000 residents.

Dataset covers cases going back to March 18th, 2020 when the first person in Marin County tested positive for COVID-19. This data may not be immediately available for recently reported cases and data will change to reflect as information becomes available. Data updated daily.

COVID-19 case data undergo quality assurance and other data verification processes and are continually updated to maximize completeness and accuracy of information. This means data may change for previous days as information is updated.

Geographic areas summarized are: 1. City, Town, or Community Area 2. Census Tracts 3. Census ZIP Code Tabulation Areas (ZCTAs)

B. HOW THE DATASET IS CREATED Addresses from the COVID-19 case data are geocoded by Marin County HHS. Those addresses are spatially joined to the geographic areas. Counts are generated based on the number of address points that match each geographic area for a given date.

The 2019 ACS estimates for population provided by the Census are used to create a cumulative rate which is equal to ([cumulative count up to that date] / [acs_population]) * 10000) representing the number of total cases per 10,000 residents (as of the specified date).

C. UPDATE PROCESS Geographic analysis is scripted by Marin HHS staff and synced to this dataset each day.

D. HOW TO USE THIS DATASET This dataset can be used to track the spread of COVID-19 throughout Marin County in a variety of geographic areas. Note that the new cases column in the data represents the number of new cases confirmed in a certain area on the specified day, while the cumulative cases column is the cumulative total of cases in a certain area as of the specified date.

Privacy rules in effect To protect privacy, certain rules are in effect: 1. Any area with a cumulative case count less than 10 are dropped for all days the cumulative count was less than 10. These will be null values. For example if a zip code did not have 10 cumulative cases until June 1, 2020 that location will not be included in the dataset until June 1. 2. Once an area has a cumulative case count of 10 or greater, that area will have a new row of case data every day following. 3. 3. Cases are dropped altogether for areas where acs_population < 1000. Some adjacent geographic areas may be combined until the ACS population exceeds 1,000 to still provide information for these regions.

Note: 14-day case rate or 30-day case rate where the counts are lower than 20 may be unstable. We advise caution in interpreting rates at these small numbers.

A note on Census ZIP Code Tabulation Areas (ZCTAs) ZIP Code Tabulation Areas are special boundaries created by the U.S. Census based on ZIP Codes developed by the USPS. They are not, however, the same thing. ZCTAs are areal representations of routes.

COVID cases and deaths for LA County and California State. Updated daily.

Data source: Johns Hopkins University (https://coronavirus.jhu.edu/us-map), Johns Hopkins GitHub (https://github.com/CSSEGISandData/COVID-19/blob/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_confirmed_US.csv). Code available: https://github.com/CityOfLosAngeles/covid19-indicators.