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.

Visit the provider’s website for more

Get access to State of California: California COVID-19 Dataset in Snowflake

Sign up for a free trial

Already a Snowflake customer?
Access this dataset directly from your Snowflake account