Dataset: COVID-19 Reported Patient Impact And Hospital Capacity By State Timeseries (RAW)

About this Dataset

COVID-19 Reported Patient Impact And Hospital Capacity By State Timeseries (RAW)

After May 3, 2024, this dataset and webpage will no longer be updated because hospitals are no longer required to report data on COVID-19 hospital admissions, and hospital capacity and occupancy data, to HHS through CDC’s National Healthcare Safety Network. Data voluntarily reported to NHSN after May 1, 2024, will be available starting May 10, 2024, atCOVID Data Tracker Hospitalizations.

The following dataset provides state-aggregated data for hospital utilization in a timeseries format dating back to January 1, 2020. These are derived from reports with facility-level granularity across three main sources: (1) HHS TeleTracking, (2) reporting provided directly to HHS Protect by state/territorial health departments on behalf of their healthcare facilities and (3) National Healthcare Safety Network (before July 15).

The file will be updated regularly and provides the latest values reported by each facility within the last four days for all time. This allows for a more comprehensive picture of the hospital utilization within a state by ensuring a hospital is represented, even if they miss a single day of reporting.

No statistical analysis is applied to account for non-response and/or to account for missing data.

The below table displays one value for each field (i.e., column). Sometimes, reports for a given facility will be provided to more than one reporting source: HHS TeleTracking, NHSN, and HHS Protect. When this occurs, to ensure that there are not duplicate reports, prioritization is applied to the numbers for each facility.

On April 27, 2022 the following pediatric fields were added:

all_pediatric_inpatient_bed_occupied
all_pediatric_inpatient_bed_occupied_coverage
all_pediatric_inpatient_beds
all_pediatric_inpatient_beds_coverage
previous_day_admission_pediatric_covid_confirmed_0_4
previous_day_admission_pediatric_covid_confirmed_0_4_coverage
previous_day_admission_pediatric_covid_confirmed_12_17
previous_day_admission_pediatric_covid_confirmed_12_17_coverage
previous_day_admission_pediatric_covid_confirmed_5_11
previous_day_admission_pediatric_covid_confirmed_5_11_coverage
previous_day_admission_pediatric_covid_confirmed_unknown
previous_day_admission_pediatric_covid_confirmed_unknown_coverage
staffed_icu_pediatric_patients_confirmed_covid
staffed_icu_pediatric_patients_confirmed_covid_coverage
staffed_pediatric_icu_bed_occupancy
staffed_pediatric_icu_bed_occupancy_coverage
total_staffed_pediatric_icu_beds
total_staffed_pediatric_icu_beds_coverage

On January 19, 2022, the following fields have been added to this dataset:

inpatient_beds_used_covid
inpatient_beds_used_covid_coverage

On September 17, 2021, this data set has had the following fields added:

icu_patients_confirmed_influenza,
icu_patients_confirmed_influenza_coverage,
previous_day_admission_influenza_confirmed,
previous_day_admission_influenza_confirmed_coverage,
previous_day_deaths_covid_and_influenza,
previous_day_deaths_covid_and_influenza_coverage,
previous_day_deaths_influenza,
previous_day_deaths_influenza_coverage,
total_patients_hospitalized_confirmed_influenza,
total_patients_hospitalized_confirmed_influenza_and_covid,
total_patients_hospitalized_confirmed_influenza_and_covid_coverage,
total_patients_hospitalized_confirmed_influenza_coverage

On September 13, 2021, this data set has had the following fields added:

on_hand_supply_therapeutic_a_casirivimab_imdevimab_courses,
on_hand_supply_therapeutic_b_bamlanivimab_courses,
on_hand_supply_therapeutic_c_bamlanivimab_etesevimab_courses,
previous_week_therapeutic_a_casirivimab_imdevimab_courses_used,
previous_week_therapeutic_b_bamlanivimab_courses_used,
previous_week_therapeutic_c_bamlanivima
Organization: U.S. Department of Health & Human Services
Last updated: 2021-03-29T23:34:19.141242
Tags: covid-19, hhs-covid-19

Tables

Table 1

@usgov.hhs_gov_covid_19_reported_patient_impact_and_hospital__1e4d1397.table_1

10.98 MB
81713 rows
135 columns


CREATE TABLE table_1 (
  "state" VARCHAR,
  "date" TIMESTAMP,
  "critical_staffing_shortage_today_yes" BIGINT,
  "critical_staffing_shortage_today_no" BIGINT,
  "critical_staffing_shortage_today_not_reported" BIGINT,
  "critical_staffing_shortage_anticipated_within_week_yes" BIGINT,
  "critical_staffing_shortage_anticipated_within_week_no" BIGINT,
  "critical_staffing_shortage_anticipated_within_week_not_reported" BIGINT,
  "hospital_onset_covid" DOUBLE,
  "hospital_onset_covid_coverage" BIGINT,
  "inpatient_beds" DOUBLE,
  "inpatient_beds_coverage" BIGINT,
  "inpatient_beds_used" DOUBLE,
  "inpatient_beds_used_coverage" BIGINT,
  "inpatient_beds_used_covid" DOUBLE,
  "inpatient_beds_used_covid_coverage" BIGINT,
  "previous_day_admission_adult_covid_confirmed" DOUBLE,
  "previous_day_admission_adult_covid_confirmed_coverage" BIGINT,
  "previous_day_admission_adult_covid_suspected" DOUBLE,
  "previous_day_admission_adult_covid_suspected_coverage" BIGINT,
  "previous_day_admission_pediatric_covid_confirmed" DOUBLE,
  "previous_day_admission_pediatric_covid_confirmed_coverage" BIGINT,
  "previous_day_admission_pediatric_covid_suspected" DOUBLE,
  "previous_day_admission_pediatric_covid_suspected_coverage" BIGINT,
  "staffed_adult_icu_bed_occupancy" DOUBLE,
  "staffed_adult_icu_bed_occupancy_coverage" BIGINT,
  "staffed_icu_adult_patients_confirmed_and_suspected_covid" DOUBLE,
  "staffed_icu_adult_patients_confirmed_and_suspected_cov_bc262469" BIGINT,
  "staffed_icu_adult_patients_confirmed_covid" DOUBLE,
  "staffed_icu_adult_patients_confirmed_covid_coverage" BIGINT,
  "total_adult_patients_hospitalized_confirmed_and_suspected_covid" DOUBLE,
  "total_adult_patients_hospitalized_confirmed_and_suspec_a714a5b1" BIGINT,
  "total_adult_patients_hospitalized_confirmed_covid" DOUBLE,
  "total_adult_patients_hospitalized_confirmed_covid_coverage" BIGINT,
  "total_pediatric_patients_hospitalized_confirmed_and_su_7b73e128" DOUBLE,
  "total_pediatric_patients_hospitalized_confirmed_and_su_3d7c85af" BIGINT,
  "total_pediatric_patients_hospitalized_confirmed_covid" DOUBLE,
  "total_pediatric_patients_hospitalized_confirmed_covid_coverage" BIGINT,
  "total_staffed_adult_icu_beds" DOUBLE,
  "total_staffed_adult_icu_beds_coverage" BIGINT,
  "inpatient_beds_utilization" DOUBLE,
  "inpatient_beds_utilization_coverage" DOUBLE,
  "inpatient_beds_utilization_numerator" DOUBLE,
  "inpatient_beds_utilization_denominator" DOUBLE,
  "percent_of_inpatients_with_covid" DOUBLE,
  "percent_of_inpatients_with_covid_coverage" DOUBLE,
  "percent_of_inpatients_with_covid_numerator" DOUBLE,
  "percent_of_inpatients_with_covid_denominator" DOUBLE,
  "inpatient_bed_covid_utilization" DOUBLE,
  "inpatient_bed_covid_utilization_coverage" DOUBLE,
  "inpatient_bed_covid_utilization_numerator" DOUBLE,
  "inpatient_bed_covid_utilization_denominator" DOUBLE,
  "adult_icu_bed_covid_utilization" DOUBLE,
  "adult_icu_bed_covid_utilization_coverage" DOUBLE,
  "adult_icu_bed_covid_utilization_numerator" DOUBLE,
  "adult_icu_bed_covid_utilization_denominator" DOUBLE,
  "adult_icu_bed_utilization" DOUBLE,
  "adult_icu_bed_utilization_coverage" DOUBLE,
  "adult_icu_bed_utilization_numerator" DOUBLE,
  "adult_icu_bed_utilization_denominator" DOUBLE,
  "geocoded_state" VARCHAR,
  "previous_day_admission_adult_covid_confirmed_18_19" DOUBLE,
  "previous_day_admission_adult_covid_confirmed_18_19_coverage" BIGINT,
  "previous_day_admission_adult_covid_confirmed_20_29" DOUBLE,
  "previous_day_admission_adult_covid_confirmed_20_29_coverage" BIGINT,
  "previous_day_admission_adult_covid_confirmed_30_39" DOUBLE,
  "previous_day_admission_adult_covid_confirmed_30_39_coverage" BIGINT,
  "previous_day_admission_adult_covid_confirmed_40_49" DOUBLE,
  "previous_day_admission_adult_covid_confirmed_40_49_coverage" BIGINT,
  "previous_day_admission_adult_covid_confirmed_50_59" DOUBLE,
  "previous_day_admission_adult_covid_confirmed_50_59_coverage" BIGINT,
  "previous_day_admission_adult_covid_confirmed_60_69" DOUBLE,
  "previous_day_admission_adult_covid_confirmed_60_69_coverage" BIGINT,
  "previous_day_admission_adult_covid_confirmed_70_79" DOUBLE,
  "previous_day_admission_adult_covid_confirmed_70_79_coverage" BIGINT,
  "previous_day_admission_adult_covid_confirmed_80" DOUBLE,
  "previous_day_admission_adult_covid_confirmed_80_coverage" BIGINT,
  "previous_day_admission_adult_covid_confirmed_unknown" DOUBLE,
  "previous_day_admission_adult_covid_confirmed_unknown_coverage" BIGINT,
  "previous_day_admission_adult_covid_suspected_18_19" DOUBLE,
  "previous_day_admission_adult_covid_suspected_18_19_coverage" BIGINT,
  "previous_day_admission_adult_covid_suspected_20_29" DOUBLE,
  "previous_day_admission_adult_covid_suspected_20_29_coverage" BIGINT,
  "previous_day_admission_adult_covid_suspected_30_39" DOUBLE,
  "previous_day_admission_adult_covid_suspected_30_39_coverage" BIGINT,
  "previous_day_admission_adult_covid_suspected_40_49" DOUBLE,
  "previous_day_admission_adult_covid_suspected_40_49_coverage" BIGINT,
  "previous_day_admission_adult_covid_suspected_50_59" DOUBLE,
  "previous_day_admission_adult_covid_suspected_50_59_coverage" BIGINT,
  "previous_day_admission_adult_covid_suspected_60_69" DOUBLE,
  "previous_day_admission_adult_covid_suspected_60_69_coverage" BIGINT,
  "previous_day_admission_adult_covid_suspected_70_79" DOUBLE,
  "previous_day_admission_adult_covid_suspected_70_79_coverage" BIGINT,
  "previous_day_admission_adult_covid_suspected_80" DOUBLE,
  "previous_day_admission_adult_covid_suspected_80_coverage" BIGINT,
  "previous_day_admission_adult_covid_suspected_unknown" DOUBLE,
  "previous_day_admission_adult_covid_suspected_unknown_coverage" BIGINT,
  "deaths_covid" DOUBLE,
  "deaths_covid_coverage" BIGINT,
  "on_hand_supply_therapeutic_a_casirivimab_imdevimab_courses" DOUBLE
);