Data


CURRENT RELEASE


Confirmed COVID Cases and Deaths

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.

  • USAFacts. This dataset is provided by a non-profit organization. The data are aggregated from CDC, state- and local-level public health agencies. County-level data is confirmed by referencing state and local agencies directly.
  • 1P3A.This was the initial, crowdsourced data project that served as a volunteer project led by 1P3acres.com and Dr. Yu Gao, Head of Machine Learning Platform at Uber. We access this data stream using a token provided by the group.

  • Health System Capacity

    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.

    Population, Demographic, and Socioeconomic Data

    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.

    Forecasting statistics

    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.


    DATA DETAILS


    USAFacts

    You can download the most updated county level data merged with USAFacts here:

  • usafacts_confirmed_date.geojson: the county level data (confirmed cases) using USAFacts, together with population and number of hospital beds.
  • usafacts_deaths_date.geojson: the county level data (death counts) using USAFacts, together with population and number of hospital beds.
  • Landingpage_main_date_.gif: the animation (.gif) showing how the pandemic has been changing over time (using confirmed cases per 100K population), which is also displayed in the Atlas.
  • 1P3A

    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.

  • 1P3A does NOT assign cases in New York to specific counties, which includes New York City, Kings, Bronx, and Richmond.
  • Cases reported for US Virgin Islands, Guam are NOT included.
  • Cases in the following areas can NOT be assigned and hence are NOT included: Southwest Utah; Southeast Utah; Central Utah; Tri County, Utah; Kansas City, MO; Benton and Franklin, WA.
  • Other unassigned cases (or “cases to be assigned”) are NOT included.
  • Cases reported in the Military and some Correctional Centers are NOT included.