COVID-19 Estimated Patient Impact And Hospital Capacity By State by US Government | Healthcare

About this Dataset

COVID-19 Estimated Patient Impact And Hospital Capacity By State

Deprecated report. This report was created early in the response to the COVID-19 pandemic. Increased reporting and quality in hospital data have rendered the estimated datasets obsolete.

The following dataset provides state-aggregated data for estimated patient impact and hospital utilization.

The source data for estimation is derived from reports with facility-level granularity across two main sources: (1) HHS TeleTracking, and (2) reporting provided directly to HHS Protect by state/territorial health departments on behalf of their healthcare facilities.

Estimates Basis: These files are representative estimates for each state and are updated weekly. These projections are based on the information we have from those who reported. As more hospitals report more frequently our projections become more accurate. The actual data for these data points are updated every day, once a day on healthdata.gov and these are the downloadable data sets.
Organization: U.S. Department of Health & Human Services
Last updated: 2021-04-13T19:59:21.458239
Tags: covid, covid-19, covid19, hhs-covid-19

Tables

Table 1

@usgov.hhs_gov_covid_19_estimated_patient_impact_and_hospital_4324688f.table_1

224.01 KB
1612 rows
30 columns


CREATE TABLE table_1 (
  "state" VARCHAR,
  "collection_date" TIMESTAMP,
  "inpatient_beds_occupied_estimated_all_inpatient" BIGINT,
  "count_ll_all_inpatient" BIGINT,
  "count_ul_all_inpatient" BIGINT,
  "percentage_of_inpatient_beds_occupied_estimated_all_inpatient" DOUBLE,
  "percentage_ll_all_inpatient" DOUBLE,
  "percentage_ul_all_inpatient" DOUBLE,
  "total_inpatient_beds_all_inpatient" BIGINT,
  "total_ll_all_inpatient" BIGINT,
  "total_ul_all_inpatient" BIGINT,
  "inpatient_beds_occupied_by_covid_19_patients_estimated_c37062c4" BIGINT,
  "count_ll_covid_19_inpatient" BIGINT,
  "count_ul_covid_19_inpatient" BIGINT,
  "percentage_of_inpatient_beds_occupied_by_covid_19_pati_30737e71" DOUBLE,
  "percentage_ll_covid_19_inpatient" DOUBLE,
  "percentage_ul_covid_19_inpatient" DOUBLE,
  "total_inpatient_beds_covid_19_inpatient" BIGINT,
  "total_ll_covid_19_inpatient" BIGINT,
  "total_ul_covid_19_inpatient" BIGINT,
  "staffed_adult_icu_beds_occupied_estimated_icu" BIGINT,
  "count_ll_icu" BIGINT,
  "count_ul_icu" BIGINT,
  "percentage_of_staffed_adult_icu_beds_occupied_estimated_icu" DOUBLE,
  "percentage_ll_icu" DOUBLE,
  "percentage_ul_icu" DOUBLE,
  "total_staffed_adult_icu_beds_icu" BIGINT,
  "total_ll_icu" BIGINT,
  "total_ul_icu" BIGINT,
  "geocoded_state" VARCHAR
);