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

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

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
PEOPLE PARTIALLY VACCINATEDNumericNumber of individuals who have received one dose of the Pfizer or Moderna vaccine.Daily
PERCENT PEOPLE PARTIALLY
VACCINATED
NumericPercent of population ≥ 12 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 ≥ 12 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_
ETHNICITY
StringRace and ethnicity categories of persons vaccinated.  Daily
VACCINATED_
RACE_ ETHNICITY_
PERCENTAGE
FloatPercentage of persons vaccinated within a defined race and ethnicity category. Daily
VACCINATED_
AGE_GROUP
StringAge categories of persons vaccinated. Daily
VACCINATED_
AGE_
PERCENTAGE
FloatPercentage of persons vaccinated within a defined age group.Daily
VACCINATED_
GENDER
StringGender of persons vaccinated. Daily
VACCINATED_
GENDER_
PERCENTAGE
FloatPercentage 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
DATE
NumericDaily

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

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
_POPULATION
FloatRatio 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
_POPULATION
FloatRatio 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
_POPULATION
FloatRatio of State population within a defined age group.Daily

COVID-19 OUTBREAKS

Verified by the California Department of Public Health.

COLUMN NAMEFORMATDEFINITIONUPDATE 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
_DELIVERED
NumberTotal 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
_PATIENTS
NumberNumber 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 info

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


Questions and answers

Is there a dashboard that shows California’s progress in administering COVID-19 vaccine?

Yes. You can find it on our Vaccination progress data page.