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.
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.
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.
The impact of Project Roomkey and other measures to help homeless Californians. This includes room acquisition, room occupancy, and trailer distribution.
The COVID-19 datasets contain the following information. Some of these data dictionaries map back to the data dashboards above.
Verified by the California Department of Public Health.
VARIABLE
FORMAT
DESCRIPTION
UPDATE FREQUENCY
DOSES ADMINISTERED
Numeric
Number 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
Numeric
Percent of total doses administered.
Daily
AVERAGE DOSES PER DAY
Numeric
Represents the average number of vaccine doses reported per day. 7-day rolling average of doses administered 3-10 days prior.
Daily
PEOPLE PARTIALLY VACCINATED
Numeric
Number of individuals who have received one dose of the Pfizer or Moderna vaccine.
Daily
PERCENT PEOPLE PARTIALLY VACCINATED
Numeric
Percent of population ≥ 12 years of age.
Daily
PEOPLE FULLY VACCINATED
Numeric
Number 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
Numeric
Percent of population ≥ 12 years of age.
Daily
DOSES ON HAND
Numeric
Number of Doses on hand.
Daily
DAYS OF INVENTORY
Numeric
Days of inventory = Number of Doses on hand / 7 day Rolling average administered
Daily
DOSES DELIVERED
Numeric
Number 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
Numeric
Number 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
Numeric
Number 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 QUARTILE
String
Score 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
String
Race and ethnicity categories of persons vaccinated.
Daily
VACCINATED_ RACE_ ETHNICITY_ PERCENTAGE
Float
Percentage of persons vaccinated within a defined race and ethnicity category.
Daily
VACCINATED_ AGE_GROUP
String
Age categories of persons vaccinated.
Daily
VACCINATED_ AGE_ PERCENTAGE
Float
Percentage of persons vaccinated within a defined age group.
Daily
VACCINATED_ GENDER
String
Gender of persons vaccinated.
Daily
VACCINATED_ GENDER_ PERCENTAGE
Float
Percentage of persons vaccinated within a defined gender.
Daily
MCE/LHJ/LTCF
String
Jurisdiction of the vaccine provider
Daily
TYPE
String
Type of provider, either Multi-County Entity (MCE), Local Health Jurisdiction (LHJ), Long Term Care Facility Pharmacy Partnership (LTCF)
Daily
ORG NAME
String
Name of vaccine provider
Daily
DOSES ON HAND
Numeric
This 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 Tiberius
Daily
LAST REPORT DATE
Numeric
Daily
Verified by the California Department of Public Health.
VARIABLE
FORMAT
DESCRIPTION
UPDATE FREQUENCY
COUNTY
String
County for which case and death statistics were reported.
Daily
TOTAL CONFIRMED CASES
Numeric
Cumulative number of laboratory-confirmed positive COVID-19 cases reported by local health departments, since the start of the pandemic.
Daily
TOTAL COVID-19 ASSOCIATED DEATHS
Numeric
Cumulative 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
Numeric
Number of new lab-confirmed positive COVID-19 cases reported by local health departments each day.
Daily
NEW DEATHS
Numeric
Number of new COVID-19 associated deaths reported by local health departments each day.
Daily
EPISODE DATE
Numeric
The 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
Numeric
The date the COVID-19 related event was reported to the California Department of Public Health.
Daily
DEATH DATE
Numeric
The date a COVID-19 associated death occurred.
Daily
Verified by the California Department of Public Health, in partnership with the California Hospitals Association.
VARIABLE
FORMAT
DESCRIPTION
UPDATE FREQUENCY
COUNTY
String
The county where the hospital is located. None of the consolidated reporters had hospitals in different counties.
Never
TODAY’S DATE
Numeric
Date for which counts were reported.
Daily.
PREVIOUS DAY’S COVID CONFIRMED PATIENTS
Numeric
The number ofnew patientsadmitted 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 PATIENTS
Numeric
The 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 CONFIRMED
Numeric
The 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 PATIENTS
Numeric
The 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 PATIENTS
Numeric
The 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 PATIENTS
Numeric
The 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 BEDS
Numeric
The 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 PATIENTS
Numeric
The 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 PATIENTS
Numeric
The 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 BEDS
Numeric
The 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.
Personal Protection Equipment (PPE) fulfilled by California Office of Emergency Services.
VARIABLE
FORMAT
DESCRIPTION
UPDATE FREQUENCY
COUNTY
String
County requesting the product
Daily
PRODUCT FAMILY
String
Summary level category of the product
Daily
QUANTITY FILLED
Numeric
Quantity of product sent to a warehouse/agency for fulfillment
Daily
SHIPPING ZIP/ POSTAL CODE
Numeric
Zip where the facility is located that is receiving the shipped product.
Never
Current state of test results reported.
VARIABLE
FORMAT
DESCRIPTION
UPDATE FREQUENCY
COUNTY
String
County for which COVID-19 tests were reported.
Daily
TOTAL COVID-19 MOLECULAR TESTS
Numeric
Cumulative number of COVID-19 molecular tests (polymerase chain reaction [PCR] tests only) performed by laboratories.
Daily
NEW COVID-19 MOLECULAR TESTS
Numeric
Number of new COVID-19 molecular tests (polymerase chain reaction [PCR] tests only) performed by laboratories each day.
Daily
REPORTED DATE
Numeric
The date the COVID-19 test was reported to the California Department of Public Health.
Daily
TESTING DATE
Numeric
The earliest date the specimen was collected for testing.
Daily
TEST POSITIVITY
Numeric
The 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
VARIABLE
FORMAT
DESCRIPTION
UPDATE FREQUENCY
RACE_ETHNICITY
String
Race and ethnicity categories of COVID-19 cases and deaths as reported by local health departments.
Daily
CASE_PERCENTAGE
Float
Percentage of COVID-19 cases within a defined race and ethnicity category.
Daily
DEATH_PERCENTAGE
Float
Percentage of COVID-19-associated deaths within a defined race and ethnicity category.
Daily
PERCENTAGE_CA _POPULATION
Float
Ratio of State population within a defined race and ethnicity category.
Daily
VARIABLE
FORMAT
DESCRIPTION
UPDATE FREQUENCY
GENDER
String
Gender of COVID-19 cases and deaths as reported by local health departments.
Daily
CASE_PERCENTAGE
Float
Percentage of COVID-19 cases within a defined gender.
Daily
DEATH_PERCENTAGE
Float
Percentage of COVID-19 associated deaths within a defined gender.
Daily
PERCENTAGE_CA _POPULATION
Float
Ratio of State population within a defined gender category.
Daily
VARIABLE
FORMAT
DESCRIPTION
UPDATE FREQUENCY
AGE_GROUP
String
Age categories of COVID-19 cases and deaths as reported by local health departments.
Daily
CASE_PERCENTAGE
Float
Percentage of COVID-19 cases within a defined age group.
Daily
DEATH_PERCENTAGE
Float
Percentage of COVID-19-associated deaths within a defined age group.
Daily
PERCENTAGE_CA _POPULATION
Float
Ratio of State population within a defined age group.
Daily
Verified by the California Department of Public Health.
COLUMN NAME
FORMAT
DEFINITION
UPDATE FREQUENCY
JURISDICTION
Plain text
Jurisdiction where the outbreak occurred Values include:California
Biweekly
INDUSTRYSECTOR
Plain text
Industry 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 SETTING
Plain text
Individual industry in which the outbreak occurred.
Total 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_TOTAL
Number
Total number of associated cases in reported outbreaks in the corresponding individual industry Value:Positive numeric
Biweekly
OUTBREAK_NEW
Number
Number 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_NEW
Number
Number of associated cases for outbreaks reported in the past 30 days to CDPH in the corresponding individual industry Value:Positive numeric
Biweekly
VARIABLE
FORMAT
DESCRIPTION
UPDATE FREQUENCY
COUNTY
String
County
Daily
DATE
Date
Reporting date
Daily
ROOMS
Number
The 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 owner
Daily
ROOMS_OCCUPIED
Number
The point in time number of rooms secured in which a Project Roomkey participant has moved into
Daily
TRAILER_REQUESTED
Number
Total number of Project Roomkey trailers the community has formally submitted a request for or has been designated to receive
TRAILERS_DELIVERED
Number
The 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
Number
Total number of donated Project Roomkey trailers delivered statewide
VARIABLE
FORMAT
DESCRIPTION
UPDATE FREQUENCY
STATUS
String
The condition of the facility
Daily
TYPE_OF_FACILITY
String
The type of place that will be utilized to support the medical surge
Daily
COUNTY
String
County the facility resides in
Daily
BEDS_READY_TO_ACCEPT _PATIENTS
Number
Number of beds assembled and ready for patients
Daily
PATIENTS_IN_BEDS
Number
Number of patients at the facility
TOTAL_BEDS
Number
Total number of beds expected to be ready to accept patients