Since the beginning of the COVID-19 crisis, California has had to face facts and make hard decisions. Defeating COVID-19 will require collaboration between state government, local governments, research universities, technologists, citizen scientists, and other members of the public.
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 data and tools are available for researchers, scientists, and technologists.
They’re available as a downloadable set, and in new models and dashboards.
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.
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.
Note: Due to issues with the state’s electronic laboratory reporting system, these data represent an underreporting of actual positive cases in one single day.
VARIABLE
FORMAT
DESCRIPTION
UPDATE FREQUENCY
COUNTY
String
County for which case statistics were reported.
Daily
TOTAL POSITIVE
Numeric
Cumulative number of laboratory-confirmed positive COVID-19 cases as reported by local health departments , beginning March 19, 2020.
Daily
NUMBER_DIED
Numeric
Cumulative number of COVID-related deaths as reported by local health department, beginning March 19, 2020. This determination is made by local health departments based on the cause of death reported on death certificates. It is expected that, to be counted, COVID is the cause of death or at least a contributing factor to the death. COVID-related deaths are also counted in “Positive 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 related deaths reported by local health departments to each day.
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 Conversions 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 facility is located that is receiving the shipped product.
Never
Current state of test results reported.
VARIABLE
FORMAT
DESCRIPTION
UPDATE FREQUENCY
TESTING
Numeric
Cumulative number of individuals tested for COVID-19 reported to CDPH
Daily
DATE
Date
Date reported
Daily
TESTED
Numeric
Cumulative number of tests reported as pending from large laboratories
Daily
VARIABLE
FORMAT
DESCRIPTION
UPDATE FREQUENCY
race_ethnicity
String
Cumulative number of COVID confirmed cases as reported by local health departments
Daily
case_percentage
Float
Cumulative number of COVID-related deaths as reported by local health departments
Daily
death_percentage
Float
Ratio of deaths in relation to all deaths
Daily
percent_ca_population
Float
Ratio of State population
Daily
VARIABLE
FORMAT
DESCRIPTION
UPDATE FREQUENCY
sex
String
Reported sex of individual
Daily
totalpositive2
Number
Cumulative number of COVID confirmed cases as reported by local health departments
Daily
date
Date
Reported date
Daily
case_percent
Float
Percent of total cases
Daily
deaths
Number
Cumulative number of COVID-related deaths as reported by local health departments
Daily
deaths_percent
Float
Percent of total deaths
Daily
ca_percent
Float
Percent of sex in relation to overall population
Daily
VARIABLE
FORMAT
DESCRIPTION
UPDATE FREQUENCY
age_group
String
Reported age group of individual
Daily
totalpositive
Number
Cumulative number of COVID confirmed cases as reported by local health departments
Daily
date
Date
Reported date
Daily
case_percent
Float
Percent of total cases
Daily
deaths
Number
Cumulative number of COVID-related deaths as reported by local health departments
Daily
deaths_percent
Float
Percent of total deaths
Daily
ca_percent
Float
Percent of age_group in relation to overall population
Daily
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
trailers_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