California has collected a wide range of data to inform its response to COVID-19, and developed tools to help process and analyze that data. These are made available to everyone for transparency.

On this page:


Data models

The California COVID-19 Assessment Tool (CalCat) is a model to inform state and local response. You can find nowcasts, forecasts, and scenarios:

https://calcat.covid19.ca.gov


Data dashboards

Statewide case statistics and demographics 

This includes positive cases, deaths, and testing results.

View statewide dashboard

View confirmed case and death data on Open Data Portal

View testing data on Open Data Portal

View probable case data on Open Data Portal

View post-infection data on Open Data Portal

Statewide vaccination statistics and demographics 

This includes an overview of COVID-19 vaccines administered and vaccination progress by group.

View vaccine progress data on Open Data Portal

View vaccine progress data by zip code on Open Data Portal

Equity data

This includes:

  • Cases, deaths, and tests by race and ethnicity
  • Health equity metric test positivity
  • Demographic data completeness
  • Community case rates by income, crowded housing levels, and access to health insurance

View equity data on Open Data Portal

The impact on hospitals in the state of California

This includes suspected and positive hospitalized patients by county, including ICU patients.

View hospital dashboard

View hospital data on Open Data Portal

COVID-19 outbreaks 

This dataset contains statewide numbers of COVID-19 outbreaks and associated cases, categorized by setting, reported to the California Department of Public Health (CDPH) since January 1, 2021.

View COVID-19 data on Open Data Portal

Personal Protection Equipment (PPE) distribution

Personal Protection Equipment (PPE) distributed by California Governor’s Logistics Task Force. PPE products include N-95 respirators, procedure masks, gowns, face shields and gloves.

View PPE distribution dashboard

The impact on our homeless population

The impact of Project Roomkey and other measures to help homeless Californians. This includes room acquisition, room occupancy, and trailer distribution.

View homeless dashboard


Databases

The COVID-19 database is available for you in two ways:

  1. Access the database directly in ready-to-query SQL format at

    Snowflake Data Marketplace

    If you are not a Snowflake customer

    sign up for a free trial account today

  2. Access the data through the

    California Open Data Portal


Data dictionaries

The COVID-19 datasets contain the following information. Some of these data dictionaries map back to the data dashboards above.

COVID-19 vaccine data

Verified by the California Department of Public Health.

VariableFormatDescriptionUpdate frequency
DOSES ADMINISTEREDNumericNumber of COVID-19 vaccine doses administered and reported to the California Immunization Registry (CAIR2), the Healthy Futures Registry, and the San Diego Immunization Registry.Daily
PERCENT DOSES
ADMINISTERED
NumericPercent of total doses administered.Daily
AVERAGE DOSES PER DAY NumericRepresents the average number of vaccine doses reported per day. 7-day rolling average of doses administered 3-10 days prior.Daily
BOOSTER RECIPIENTSNumericNumber of individuals who received a dose at least 24 days after series completion (2 Pfizer or Moderna doses or 1 Janssen dose) since August 13, 2021. This includes individuals who received both additional doses and individuals who received booster doses.Daily
BOOSTER RATENumericCalculated as Booster Recipients/Eligible Booster Recipients.Daily
ELIGIBLE BOOSTER RECIPIENTSNumericRecipients have received a third dose of any vaccine 6 months or more after completion of at least two mRNA vaccines, or a third dose 2 months or more after a J&J, among those 18 years of age or older.Daily
PEOPLE PARTIALLY VACCINATEDNumericNumber of individuals who have received one dose of the Pfizer or Moderna vaccine.Daily
PERCENT PEOPLE PARTIALLY
VACCINATED
NumericPercent of population ≥ 5 years of age.Daily
PEOPLE FULLY VACCINATEDNumericNumber of individuals who have received two doses of the Pfizer or Moderna vaccine, or one dose of the Janssen vaccine.Daily
PERCENT PEOPLE FULLY
VACCINATED
NumericPercent of population ≥ 5 years of age.Daily
DOSES ON HANDNumericNumber of Doses on
hand.
Daily
DAYS OF
INVENTORY
NumericDays of inventory = Number of Doses on
hand / 7 day Rolling average administered
Daily
DOSES DELIVEREDNumericNumber of COVID-19 vaccine doses delivered. Includes direct federal allocations and federal pharmacy partnership programs but does not include doses delivered to the following federal entities: Indian Health Service, Department of Defense, U.S. Federal Bureau of Prisons, and Veterans Affairs. Daily
CDC
PHARMACY DOSES
DELIVERED
NumericNumber of COVID-19 vaccine doses delivered to the CDC Pharmacy Partnership for Long-Term Care Facility (LTCF) Program and the Federal Retail Pharmacy Program.Daily
DOSES ADMINISTERED
BY COUNTY OF RESIDENCE
NumericNumber of COVID-19 vaccine doses administered by the county of vaccine recipient’s residence. If the county of residence is not reported, the county where the individual was vaccinated is used.Daily
HPI QUARTILEStringScore based on Healthy Places Index that measures levels of community health, ranging from least healthy community conditions (Quartile 1) to most health community conditions (Quartile 4).Infrequently
VACCINATED RACE ETHNICITYStringRace and ethnicity categories of persons vaccinated.  Daily
VACCINATED RACE ETHNICITY PERCENTAGEFloatPercentage of persons vaccinated within a defined race and ethnicity category. Daily
VACCINATED AGE GROUPStringAge categories of persons vaccinated. Daily
VACCINATED AGE PERCENTAGEFloatPercentage of persons vaccinated within a defined age group.Daily
VACCINATED GENDERStringGender of persons vaccinated. Daily
VACCINATED GENDER PERCENTAGEFloatPercentage of persons vaccinated within a defined gender.Daily
MCE/LHJ/LTCFStringJurisdiction of the vaccine providerDaily
TYPEStringType of provider, either Multi-County Entity (MCE), Local Health Jurisdiction (LHJ), Long Term Care Facility Pharmacy Partnership (LTCF)Daily
ORG NAMEStringName of vaccine providerDaily
DOSES ON HANDNumericThis is self-reported daily inventory data into VaccineFinder managed at the federal level by CDC. The data are pulled every day at 6am from Operation Warp Speed TiberiusDaily
LAST REPORT DATENumericDaily

COVID-19 cases data

Verified by the California Department of Public Health.

VariableFormatDescriptionUpdate frequency
COUNTYStringCounty for which case and death statistics were reported.Daily
TOTAL CONFIRMED CASESNumericCumulative number of laboratory-confirmed positive COVID-19 cases reported by local health departments, since the start of the pandemic.Daily
TOTAL COVID-19 ASSOCIATED DEATHSNumericCumulative number of COVID-19-associated deaths reported by local health departments, since the start of the pandemic. Local health departments use multiple sources to confirm that a death is COVID-associated, including speaking with physicians, reviewing medical records, and consulting with medical examiners. COVID-associated deaths are also counted in “Total Confirmed Cases”.Daily
NEW CASES NumericNumber of new lab-confirmed positive COVID-19 cases reported by local health departments each day.Daily
NEW DEATHS NumericNumber of new COVID-19 associated deaths reported by local health departments each day.Daily
EPISODE DATE NumericThe earliest of the following dates (if the dates exist): date received, date of diagnosis, date of symptom onset, specimen collection date, or date of death.Daily
REPORTED DATE NumericThe date the COVID-19 related event was reported to the California Department of Public Health.Daily
DEATH DATENumericThe date a COVID-19 associated death occurred.Daily

COVID-19 post-vaccination infection data

VariableFormatDescriptionUpdate frequency
DATEDateReporting time periodWeekly
UNVACCINATED CASES PER 100KNumericRate of cases among the unvaccinated per 100,000 persons (limited to persons age 16+). Rates are calculated by dividing the prior 7-day averages of case counts for a given day by the estimated unvaccinated population for that given day, multiplied by 100,000.Weekly
VACCINATED CASES PER 100KNumericRate of cases among the vaccinated per 100,000 persons (limited to persons age 16+). Rates are calculated by dividing prior 7-day averages of case counts for a given day by the estimated vaccinated population for that given day, multiplied by 100,000.Weekly
UNVACCINATED DEATHS PER 1MILNumericRate of deaths among the unvaccinated per 1,000,000 persons (limited to persons age 16+). Rates are calculated by dividing the prior 7-day averages of number of deaths on a given day by the estimated unvaccinated population for that given day, multiplied by 1,000,000.Weekly
VACCINATED DEATHS PER 1MILNumericRate of deaths among the vaccinated per 1,000,000 persons (limited to persons age 16+). Rates are calculated by dividing prior 7-day averages of number of deaths on a given day by the estimated vaccinated population for that given day, multiplied by 1,000,000.Weekly
UNVACCINATED HOSP PER 1MILNumericRate of hospitalization among the unvaccinated per 1,000,000 persons (limited to persons age 16+). Rates are calculated by dividing the prior 7-day averages of number of hospitalized persons on a given day by the estimated unvaccinated population for that given day, multiplied by 1,000,000.Weekly
VACCINATED HOSP PER 1MILNumericRate of hospitalization among the vaccinated per 1,000,000 persons (limited to persons age 16+). Rates are calculated by dividing prior 7-day averages of number of hospitalized persons on a given day by the estimated vaccinated population for that given day, multiplied by 1,000,000.Weekly

COVID-19 impact by race and ethnicity

VariableFormatDescriptionUpdate frequency
COUNTYCategoricalSpecifies county or stateWeekly
DEMOGRAPHIC SETCategoricalSpecifies demographic categoryWeekly
DEMOGRAPHIC SET CATEGORYCategoricalSub-category of specific demographic categoryWeekly
METRICCategoricalSpecifies if related counts are for cases, deaths, or testsWeekly
METRIC VALUENumericNumber of records in the previous 30 days (cases based on episode date, deaths based on date of death, and tests based on specimen collection) for the specified metric. Suppression is applied based on county population or total countsWeekly
METRIC VALUE PER 100KNumeric30-day case, death, or testing rate per 100,000 populationWeekly
APPLIED SUPPRESSIONCategoricalReason for suppression: Population, PopMinusTot, Total, NoneWeekly
POPULATION PERCENTAGENumericPercent of county/state population in specified demographic categoryWeekly
METRIC TOTAL PERCENTAGENumericPercent of county/state case, death, or test total that demographic category accounts for previous 30 daysWeekly
METRIC VALUE 30 DAYS AGONumericNumber of records in the previous 31-60 days (cases based on episode date, deaths based on date of death, and tests based on specimen collection) for the specified metric; suppression is applied based on county population or total countsWeekly
METRIC VALUE PER 100K 30 DAYS AGONumeric30-day case, death, or testing rate for previous 31-60 days per 100,000 population; equivalent to total/population multiplied by 100,000Weekly
METRIC VALUE PER 100K DELTA FROM 30 DAYS AGONumericDifference between most recent 30-day rate and the previous 30 day rateWeekly
METRIC TOTAL PERCENTAGE 30 DAYS AGONumericPercent of county/state case, death, or test total that demographic category accounts for in the previous 31-60 day periodWeekly

Health equity metric data

VariableFormatDescriptionUpdate frequency
COUNTYCategoricalSpecifies county or stateWeekly
DATEDateDate. Includes 30 previous dates after 9 day lag (2 day data processing delay + 7 day to account for reporting delay)Weekly
METRICCategoricalSpecifies metric: county positivity all nopris,  county positivity low hpiWeekly
METRIC VALUENumericValue associated with the metric specified in “name” column. county positivity all nopris: the total number of positive polymerase chain reaction (PCR) tests for COVID-19 over a 7-day period (based on specimen collected date) divided by the total number of PCR tests conducted, excluding tests for persons out of state or with unknown county of residence and tests associated with prison, ICE, US Marshal, or Department of State Hospitals facilities.  This number is multiplied by 100 to get a percentage.  Each date represents the positivity of the previous 7-day period. county positivity low hpi: Test positivity over a 7-day period (based on specimen collected date) for the tracts in Healthy Places Index quartile 1 in a given county, excluding tests associated with prison, ICE, US Marshal, or Department of State Hospitals facilities.Weekly
METRIC VALUE 30 DAYS AGONumericMetric value for the date 30 days prior to the specified dateWeekly
METRIC VALUE DIFFNumericDifference between specified date’s calculation and 30 days priorWeekly

Reporting completeness data

VariableFormatDescriptionUpdate frequency
COUNTYCategoricalSpecifies county or stateWeekly
SOGI CATEGORYCategoricalSpecifies which type of data is being assessed (gender identity, race ethnicity, or sexual orientation)Weekly
METRICCategoricalSpecifies if related counts are for cases, deaths, or testsWeekly
MISSINGNumericNumber of records with date (cases based on episode date, deaths based on date of death, and tests based on specimen collection) in the previous 30 days that have unknown or missing information for specified categoryWeekly
NOT MISSINGNumericNumber of records with date (cases based on episode date, deaths based on date of death, and tests based on specimen collection) in the previous 30 days that are not missing information for specified categoryWeekly
TOTALNumericTotal number of records with date (cases based on episode date, deaths based on date of death, and tests based on specimen collection) in the previous 30 days. Equivalent to Missing + Not MissingWeekly
PERCENT COMPLETENumericPercent of records in the previous 30 days that are not missing information. Equivalent to Not Missing/Total*100Weekly
PERCENT COMPLETE 30 DAYS PRIORNumericPercent of records in the previous 31-60 days that are not missing informationWeekly
PERCENT COMPLETE 30 DAYS DIFFNumericDifference in completeness between records from the previous 30 days versus previous 31-60 days. Equivalent to Perc Complete – Perc Complete 30 PriorWeekly
REPORT DATEDateDate on which the data was calculatedWeekly

Risk factors data

VariableFormatDescriptionUpdate frequency
DATEDateDate on which the data was calculatedWeekly
SOCIAL DETCategoricalSpecifies social determinant of health variable: income, income cumulative, crowding, insuranceWeekly
SOCIAL TIERCategoricalSpecifies sub-category of Social Det category. Example for income: above $120K, $80-100K, $60-80K, $40-60K, etc.Weekly
SORTNumericNumeric rank for social tierWeekly
CASES 7DAYAVG 7DAYSAGONumericAverage number of cases per day for previous 7 days (except for income cumulative which represents whole pandemic)Weekly
POPULATIONNumericTotal population using 2017 population dataWeekly
CASE RATE PER 100KNumericCase rate per 100,000 populationWeekly
CASE RATE PER 100K 30 DAYS AGONumericCase rate for the date 30 days priorWeekly
RATE DIFF 30 DAYSNumericDifference between current case rate and 30 days priorWeekly

Hospitals data

Verified by the California Department of Public Health, in partnership with the California Hospitals Association.

VariableFormatDescriptionUpdate frequency
COUNTYStringThe county where the hospital is located. None of the consolidated reporters had hospitals in different counties.Never
TODAY’S DATE NumericDate for which counts were reported.Daily. 
PREVIOUS DAY’S COVID CONFIRMED  PATIENTSNumericThe number of new patients admitted the previous calendar day to an inpatient bed who have laboratory-confirmed COVID. This field should not include all patients in the hospital the previous day but instead detail COVID counts among new admissions only. This includes all inpatients, and does not include patients in affiliated clinics, outpatient departments, emergency departments and overflow locations awaiting an inpatient bed. Additional clarification added on June 16, 2020.Daily
PREVIOUS DAY’s SUSPECTED COVID PATIENTSNumericThe number of symptomatic patients, with tests for COVID pending laboratory confirmation, admitted the previous calendar day to an inpatient bed. This field should not include all patients in the hospital the previous day but instead detail COVID counts among new admissions only. This includes all inpatients, and does not include patients in affiliated clinics, outpatient departments, emergency departments and overflow locations awaiting an inpatient bed. Patients should be included in this field if they are suspected COVID positive at the time of admission regardless of how their status may have changed by the time data are entered the following day. Additional clarification added on June 16, 2020.Daily
PREVIOUS DAY’S CONVERSION TO COVID CONFIRMEDNumericThe number of total patients in the facility (irrespective of when they were admitted) whose status changed to COVID confirmed positive on the previous calendar day. This will include any individual who, on the previous day, had laboratory results return to confirm a COVID diagnosis where previously their diagnosis was unconfirmed. Added to SmartSheet June 16, 2020.Daily
HOSPITALIZED COVID CONFIRMED PATIENTSNumericThe number of patients hospitalized in an inpatient bed who have laboratory-confirmed COVID. This is not a cumulative number. This includes all inpatients (including those in ICUs and Medical/Surgical units), and does not include patients in affiliated clinics, outpatient departments, emergency departments and overflow locations awaiting an inpatient bed. As of April 21, 2020, COVID ED patients were removed from the Hospitalized COVID count and counted separately, see “ED/Overflow COVID Patients.”Daily
HOSPITALIZED SUSPECTED COVID PATIENTSNumericThe number of patients hospitalized in an inpatient bed without a laboratory-confirmed COVID diagnosis who, in accordance with CDC’s Interim Public Health Guidance for Evaluating Persons Under Investigation (PUIs), have signs and symptoms compatible with COVID (most patients with confirmed COVID have developed fever and/or symptoms of acute respiratory illness, such as cough, shortness of breath or myalgia/fatigue). This includes all inpatients (including those in ICUs and Medical/Surgical units), and does not include patients in affiliated clinics, outpatient departments, emergency departments and overflow locations awaiting an inpatient bed. As of April 21, 2020, Suspected COVID ED patients were removed from the Hospitalized Suspected COVID count and counted separately, see “ED/Overflow COVID Patients.”Daily
HOSPITALIZED COVID PATIENTSNumericThe number of patients currently hospitalized in an inpatient bed who have suspected or confirmed COVID. Added to SmartSheet April 21, 2020.Never – This is a calculated field.
ALL HOSPITAL BEDSNumericThe total number of beds in the facility, including all surge beds, inpatient and outpatient post-surgical beds, labor and delivery unit beds, and observation beds. This includes the total number of beds for which the hospital could provide staff and equipment and is not necessarily reflective of the beds that are staffed at the time the facility reports. This field does not include emergency department (ED) bays. Added to SmartSheet April 21, 2020.Infrequently
ICU COVID CONFIRMED PATIENTSNumericThe number of laboratory-confirmed positive COVID patients that are in the ICU at the hospital. This includes all ICU beds (NICU, PICU, and adult). Additional clarification added on June 16, 2020.Daily
ICU SUSPECTED COVID PATIENTSNumericThe number of symptomatic patients, with tests for COVID pending laboratory confirmation, that are in the ICU at the hospital. This includes all ICU beds (NICU, PICU, and adult). Additional clarification added on June 16, 2020.Daily
ICU AVAILABLE BEDSNumericThe number of ICU beds available at the hospital. This includes all ICU beds (NICU, PICU, and adult). Additional clarification added on June 16, 2020.Never. This is a calculated field.

Logistics data

Personal Protection Equipment (PPE) fulfilled by California Office of Emergency Services.

VariableFormatDescriptionUpdate frequency
COUNTYStringCounty requesting the productDaily
PRODUCT FAMILYStringSummary level category of the productDaily
QUANTITY FILLEDNumericQuantity of product sent to a warehouse/agency for fulfillmentDaily
SHIPPING ZIP/
POSTAL CODE
NumericZip where the facility is located that is receiving the shipped product.Never

Lab testing data

Current state of test results reported.

VariableFormatDescriptionUpdate frequency
COUNTYStringCounty for which COVID-19 tests were reported.Daily 
TOTAL COVID-19 MOLECULAR TESTSNumericCumulative number of COVID-19 molecular tests (polymerase chain reaction [PCR] tests only) performed by laboratories.Daily
NEW COVID-19 MOLECULAR TESTSNumericNumber of new COVID-19 molecular tests (polymerase chain reaction [PCR] tests only) performed by laboratories each day. Daily
REPORTED DATENumericThe date the COVID-19 test was reported to the California Department of Public Health. Daily
TESTING DATENumericThe earliest date the specimen was collected for testing. Daily
TEST POSITIVITYNumericThe number of positive molecular tests divided by the total number of molecular tests done. Calculation is (7-day sum positive tests) / (7-day sum total tests), by testing date. Prior to March 12, 2021, test positivity was previously reported and calculated as the number of confirmed cases divided by the total number of molecular tests done averaged over a 7 or 14 day period. Daily

Case demographics race and ethnicity

VariableFormatDescriptionUpdate frequency
RACE ETHNICITYStringRace and ethnicity categories of COVID-19 cases and deaths as reported by local health departments.  Daily
CASE PERCENTAGEFloatPercentage of COVID-19 cases within a defined race and ethnicity category. Daily
DEATH PERCENTAGEFloatPercentage of COVID-19-associated deaths within a defined race and ethnicity category.Daily
PERCENTAGE CA POPULATIONFloatRatio of State population within a defined race and ethnicity category. Daily

Case demographics sex

VariableFormatDescriptionUpdate frequency
GENDERStringGender of COVID-19 cases and deaths as reported by local health departments.Daily
CASE PERCENTAGEFloatPercentage of COVID-19 cases within a defined gender.Daily
DEATH PERCENTAGEFloatPercentage of COVID-19 associated deaths within a defined gender.Daily
PERCENTAGE CA POPULATIONFloatRatio of State population within a defined gender category.Daily

Case demographics age

VariableFormatDescriptionUpdate frequency
AGE GROUPStringAge categories of COVID-19 cases and deaths as reported by local health departments.Daily
CASE PERCENTAGEFloatPercentage of COVID-19 cases within a defined age group.Daily
DEATH PERCENTAGEFloatPercentage of COVID-19-associated deaths within a defined age group. Daily
PERCENTAGE CA POPULATIONFloatRatio of State population within a defined age group.Daily

COVID-19 outbreaks

Verified by the California Department of Public Health.

VariableFormatDefinitionUpdate frequency
JURISDICTIONPlain textJurisdiction where the outbreak occurred
Values include:California
Biweekly
INDUSTRYSECTORPlain textIndustry sector in which the outbreak occurred.

Values include:
Industry Sectors, as classified in the US Census Bureau 2012 Industry Code List. Each industry sector includes a number of individual industries.
Biweekly
INDIVIDUAL SETTINGPlain textIndividual industry in which the outbreak occurred.

Values include:
Individual industries, as classified in the US Census Bureau 2012 Industry Code List.
Biweekly
INDCODENumberCensus industry code for the individual industry in which the outbreak occurred.

Values include:
4-digit individual industry codes, as classified in the US Census Bureau 2012 Industry Code List.
Biweekly
OUTBREAK TOTALNumberTotal number of confirmed COVID-19 outbreaks reported to the California Department of Public Health (CDPH) in the corresponding individual industry
Value:Positive numeric
Biweekly
CASE TOTALNumberTotal number of associated cases in reported outbreaks in the corresponding individual industry
Value:Positive numeric
Biweekly
OUTBREAK NEWNumberNumber of new confirmed COVID-19 outbreaks reported in the past 30 days to the California Department of Public Health (CDPH) in the corresponding individual industry
Value:Positive numeric
Biweekly
CASE NEWNumberNumber of associated cases for outbreaks reported in the past 30 days to CDPH in the corresponding individual industry
Value:Positive numeric
Biweekly

Homeless impact

VariableFormatDescriptionUpdate frequency
COUNTYStringCountyDaily
DATEDateReporting dateDaily
ROOMSNumberThe point in time number of hotel/motel rooms a community has secured for individuals experiencing homelessness in need of isolation. These rooms are secured through an occupancy agreement or other type of arrangement with a Hotel/Motel ownerDaily
ROOMS OCCUPIEDNumberThe point in time number of rooms secured in which a Project Roomkey participant has moved intoDaily
TRAILER REQUESTEDNumberTotal number of Project Roomkey trailers the community has formally submitted a request for or has been designated to receive
TRAILERS DELIVEREDNumberThe total number of Project Roomkey trailers the community has received from the state (to be delivered and counted the community must also have necessary trailer supports in place)
DONATED TRAILERS DELIVEREDNumberTotal number of donated Project Roomkey trailers delivered statewide

Bed surge

VariableFormatDescriptionUpdate frequency
STATUSStringThe condition of the facilityDaily
TYPE OF FACILITYStringThe type of place that will be utilized to support the medical surgeDaily
COUNTYStringCounty the facility resides inDaily
BEDS READY TO ACCEPT PATIENTSNumberNumber of beds assembled and ready for patientsDaily
PATIENTS IN BEDSNumberNumber of patients at the facility
TOTAL BEDSNumberTotal number of beds expected to be ready to accept patients
DATEDateDate reported

Contact for questions

Email StateInfo@state.ca.gov with any questions about these datasets.


Explore more data

State data

Statewide and county cases, deaths, hospitalizations, and tests, including by vaccination status, gender, and age

Vaccination data

State and county data about vaccination, including by race and ethnicity and age

Health equity data

How COVID-19 has affected different communities across the state