State of California: California COVID-19 Datasets
COVID-19 confirmed counts and county information
Description:
California is monitoring COVID-19 closely in each local community and keeping the public informed. We’re teaming up with counties to fight it with every tool we have: current local data, testing, contact tracing, infection control, emergency supplies, containment measures, and more. For more information see https://covid19.ca.gov/data-and-tools/
These datasets drive the https://covid19.ca.gov/ and associated dashboards which are provided for resident consumption.
EXAMPLE USE CASES
As California reopens, Californians must follow best practices and make informed decisions to save lives in the state. By understanding trends and geographic spread of the coronavirus, local governments can take actions to protect their residents.
TABLES INCLUDED
•Statewide confirmed COVID-19 cases across the state as verified by the California Department of Public Health (CDPH)
•Statewide Hospital metrics reported by facilities as confirmed by the California Department of Public Health
•Cumulative number of individuals tested for COVID-19 reported to CDPH plus the number of tests reported as pending from large laboratories.
•Personal Protection Equipment requested and fulfilled by county as curated by Office of Emergency Services
•Case Demographics of confirmed cases by race/ethnicity, sex, and age
•Homelessness Impact
•Bed Surge Capacity
FIELDS INCLUDED:
STATEWIDE CASES
County
Total Positive Confirmed Cases
Total Confirmed Covid Deaths
New Cases
New Deaths
HOSPITALS BY COUNTY
County
Today’s Date
Previous Day’s COVID Confirmed Patients
Previous Day’s Suspected COVID Patients
Previous Day’s Conversions to COVID Confirmed
Hospitalized COVID Confirmed Patients
Hospitalized Suspected COVID Patients
Hospitalized COVID Patients
LOGISTICS PPE
PPE Product Family
PPE Quantity Filled
Shipping Zip/Postal Code
STATEWIDE TESTING
Date
Testing
Tested
DEMOGRAPHICS
Relative demographic attribute
Case Counts
Relative Percentage
Ratio compared to California population
HOMELESSNESS IMPACT
Rooms acquired
Rooms occupied
Trailers delivered
Donated trailers
BED SURGE
Status
County
Beds ready
Beds occupied
Date
About the Provider:
California’s values aren’t just a point of pride; they are the very fabric of our state’s history and our future. California has been on the leading edge of change, enacting bold reforms that reflect those values. It is that entrepreneurial and innovative spirit that has allowed California’s diversity to flourish and economy to grow and become one of the largest in the world.
Get access to State of California: California COVID-19 Dataset in Snowflake
Already a Snowflake customer?
Access this dataset directly from your Snowflake account