Data and tools
Last updated November 29, 2022 at 9:32 AM
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:
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 source data and data dictionary on Open Data Portal
Wastewater tracking
Select sewersheds track the level of COVID-19 detected in wastewater. This can provide early warning of cases spikes.
Wastewater dashboard at the California Department of Public Health (CDPH)
COVID-19 outbreaks
This dataset contains statewide numbers of COVID-19 outbreaks and associated cases, categorized by setting, reported to 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.
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 If you are not a Snowflake customer
- Access the data through the
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:
- Vaccine progress dashboard data
- Vaccine progress dashboard data by zip code
- Time series metrics by county and state
- Post-vaccination infection data
- Variants data
- Hospital data
- Equity metrics
Contact for questions
Email StateInfo@state.ca.gov with questions about these datasets.
Explore more data
State data
Statewide and county cases, deaths, hospitalizations, and tests, including by vaccination status, gender, and age
Vaccination data
State and county data about vaccination, including by race and ethnicity and age
Variants
Data about which variants are in California, including Delta and Omicron
Health equity data
How COVID-19 has affected different communities across the state