Data and tools

Last updated January 27, 2022 at 5:24 PM

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
Data dashboards
Databases
Source data and data dictionaries
Contact for questions
Explore more data

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.

Statewide dashboard on Tableau

Case, death, and test source data and data dictionary on Open Data Portal

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

Hospital dashboard on Tableau

Hospital source data and data dictionary 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.

COVID-19 outbreak source data and data dictionary 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.

PPE distribution dashboard on Tableau

PPE distribution source data on Open Data Portal

PPE distribution data dictionary

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

The impact on people experiencing homelessness

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

Homeless dashboard on Tableau

Homelessness source data on Open Data Portal

Homeless impact data dictionary

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

Databases

You can access the COVID-19 database in two ways:

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
Access the data through the
California Open Data Portal

Source data and dictionaries

The California Open Data Portal hosts the source data and dictionaries used for all the charts on this website. This includes:

Contact for questions

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