Because there is no one single validated source for county-level COVID cases and deaths for real-time analysis, we incorporate multiple datasets from multiple projects to allow for comparisons.
COVIDCareMap. Healthcare System Capacity includes Staffed beds, Staffed ICU beds, Licensed Beds by County. The data is from 2018 facility reports with additions/edits allowed in real-time.
American Community Survey. We incorporate population data used to generate rates, and will add more information as needed in future iterations.
County Health Rankings & Roadmaps (CHR&R). The CHR&R is a collaboration between the Robert Wood Johnson Foundation and the University of Wisconsin Population Health Institute. The goal is to improve health outcomes for all and to close the health gaps between those with the most and least opportunities for good health.
Based on our discussion with CHR&R, we include following focus areas and related measures for inclusion in the Atlas: income and economic hardship, children living in poverty, food insecurity, median household income, income inequality, access to health care, uninsured, preventable hospital stays, ratio of population to primary care physicians, housing cost and quality, Black/White residential segregation, percentage of 65 and older, obesity and diabetes prevalance, adult smoking, excessive drinking, drug overdose deaths, life expectancy and self-rated health condition.
Hospital Severity Index. The Yu Group at UC Berkeley Statistics and EECS has compiled, cleaned and continues to update a large corpus of hospital- and county-level data from a variety of public sources to aid data science efforts to combat COVID-19 (see covidseverity.com).
At the hospital level, their data include the location of the hospital, the number of ICU beds, the total number of employees, and the hospital type. At the county level, their data include COVID-19 cases/deaths from USA Facts and NYT, automatically updated every day, along with demographic information, health resource availability, COVID-19 health risk factors, and social mobility information.
An overview of each data set in this corpus is provided here. We will be adding more relevant data sets as they are found. We prepared this data to support healthcare supply distribution efforts through short-term (days) prediction of COVID-19 deaths (and cases) at the county level. We are using the predictions and hospital data to arrive at a covid Pandemic Severity Index (c-PSI) for each hospital. This project is in partnership with Response4Life. A paper on the current approaches can be found at this link. The more detailed information with data source descriptions is provided on the github.
You can download the most updated county level data merged with USAFacts here:
To access raw 1P3A data, you must contact the 1P3A for a token directly. Not all cases from 1P3A data can be assigned to a particular county, see following. The list is being updated as new data comes in everyday.