COVID-19 data and tools

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. The state is making these data and tools open and available for researchers, scientists, and technologists.

It’s 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. 

See the curve:
https://calcat.covid19.ca.gov

Data dashboards

COVID-19 in the state

Statewide case statistics and demographics. This includes positive cases, deaths, and testing results.

COVID-19 in hospitals

The impact on hospitals in the state of California. This includes positive patients by county, ICU positive patients, and suspected.

COVID-19 bed surges

The ability to respond to patients that need beds in facilities such as hospitals, arenas, and other alternative care facilities.

COVID-19 and homeless Californians

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

Databases

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

1. Access the database directly from Snowflake Data Marketplace in ready-to-query SQL format. 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 CASES DATA

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

HOSPITALS DATA

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

LOGISTICS DATA

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

LAB TESTING DATA

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

CASE DEMOGRAPHICS ETHNICITY

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

CASE DEMOGRAPHICS SEX

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

CASE DEMOGRAPHICS AGE

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

HOMELESS IMPACT

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

BED SURGE

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
DATE	Date	Date reported

Questions about the dataset

Please direct any questions to StateInfo@state.ca.gov.