Weekly Hospital Respiratory Data And Metrics by Kaggle | Healthcare

About this Dataset

Weekly Hospital Respiratory Data And Metrics

This dataset provides a comprehensive overview of weekly hospital respiratory data and metrics aggregated to national and state/territory levels, reported to the Centers for Disease Control and Prevention’s (CDC) National Health Safety Network (NHSN) from August 2020 through October 2024. The data includes metrics related to hospital capacity, occupancy, hospitalizations, and new admissions for COVID-19, Influenza, and Respiratory Syncytial Virus (RSV). The dataset captures both mandated and voluntary reporting periods, reflecting changes in reporting requirements by the Centers for Medicare and Medicaid Services (CMS).

Key Features

Reporting Periods

August 2020 – April 30, 2024: Data reported during a mandated reporting period.
May 1, 2024 – October 31, 2024: Voluntarily reported data in the absence of a mandate.
November 1, 2024 – October 2024: Data reported during a current mandated reporting period.

Data Coverage

COVID-19, Influenza, and RSV: Metrics capturing hospitalizations and admissions for these respiratory illnesses.
Hospital Capacity and Occupancy: Information on inpatient and ICU beds, including occupancy rates by patient type.
Reporting Coverage: Metrics indicating the number of hospitals reporting data for each week.

Tables

Raw Weekly Hospital Respiratory Data 2020–2024

@kaggle.noeyislearning_weekly_hospital_respiratory_data_and_metrics.raw_weekly_hospital_respiratory_data_2020_2024

1.64 MB
12768 rows
157 columns


CREATE TABLE raw_weekly_hospital_respiratory_data_2020_2024 (
  "week_ending_date" TIMESTAMP,
  "geographic_aggregation" VARCHAR,
  "number_of_inpatient_beds" DOUBLE,
  "number_of_adult_inpatient_beds" DOUBLE,
  "number_of_pediatric_inpatient_beds" DOUBLE,
  "number_of_inpatient_beds_occupied" DOUBLE,
  "number_of_adult_inpatient_beds_occupied" DOUBLE,
  "number_of_pediatric_inpatient_beds_occupied" DOUBLE,
  "number_of_icu_beds" DOUBLE,
  "number_of_adult_icu_beds" DOUBLE,
  "number_of_pediatric_icu_beds" DOUBLE,
  "number_of_icu_beds_occupied" DOUBLE,
  "number_of_adult_icu_beds_occupied" DOUBLE,
  "number_of_pediatric_icu_beds_occupied" DOUBLE,
  "number_of_adult_patients_hospitalized_with_covid_19" DOUBLE,
  "number_of_pediatric_patients_hospitalized_with_covid_19" DOUBLE,
  "total_patients_hospitalized_with_covid_19" DOUBLE,
  "number_of_adult_patients_hospitalized_with_influenza" DOUBLE,
  "number_of_pedatric_patients_hospitalized_with_influenza" DOUBLE,
  "total_patients_hospitalized_with_influenza" DOUBLE,
  "number_of_adult_patients_hospitalized_with_rsv" DOUBLE,
  "number_of_pediatric_patients_hospitalized_with_rsv" DOUBLE,
  "total_patients_hospitalized_with_rsv" DOUBLE,
  "number_of_adult_icu_patients_hospitalized_with_covid_19" DOUBLE,
  "number_of_pediatric_icu_patients_hospitalized_with_covid_19" DOUBLE,
  "total_icu_patients_hospitalized_with_covid_19" DOUBLE,
  "number_of_adult_icu_patients_hospitalized_with_influenza" DOUBLE,
  "number_of_pediatric_icu_patients_hospitalized_with_influenza" DOUBLE,
  "total_icu_patients_hospitalized_with_influenza" DOUBLE,
  "number_of_adult_icu_patients_hospitalized_with_rsv" DOUBLE,
  "number_of_pediatric_icu_patients_hospitalized_with_rsv" DOUBLE,
  "total_icu_patients_hospitalized_with_rsv" DOUBLE,
  "number_of_pediatric_covid_19_admissions_0_4_years" DOUBLE,
  "number_of_pediatric_covid_19_admissions_5_17_years" DOUBLE,
  "total_pediatric_covid_19_admissions" DOUBLE,
  "number_of_adult_covid_19_admissions_18_49_years" DOUBLE,
  "number_of_adult_covid_19_admissions_50_64_years" DOUBLE,
  "number_of_adult_covid_19_admissions_65_74_years" DOUBLE,
  "number_of_adult_covid_19_admissions_75_plus" DOUBLE,
  "total_adult_covid_19_admissions" DOUBLE,
  "number_of_covid_19_admissions_unknown_age" DOUBLE,
  "total_covid_19_admissions" DOUBLE,
  "number_of_pediatric_influenza_admissions_0_4_years" DOUBLE,
  "number_of_pediatric_influenza_admissions_5_17_years" DOUBLE,
  "total_pediatric_influenza_admissions" DOUBLE,
  "number_of_adult_influenza_admissions_18_49_years" DOUBLE,
  "number_of_adult_influenza_admissions_50_64_years" DOUBLE,
  "number_of_adult_influenza_admissions_65_74_years" DOUBLE,
  "number_of_adult_influenza_admissions_75_plus_years" DOUBLE,
  "total_adult_influenza_admissions" DOUBLE,
  "number_of_influenza_admissions_unknown_age" DOUBLE,
  "total_influenza_admissions" DOUBLE,
  "number_of_pediatric_rsv_admissions_0_4_years" DOUBLE,
  "number_of_pediatric_rsv_admissions_5_17_years" DOUBLE,
  "total_pediatric_rsv_admissions" DOUBLE,
  "number_of_adult_rsv_admissions_18_49_years" DOUBLE,
  "number_of_adult_rsv_admissions_50_64_years" DOUBLE,
  "number_of_adult_rsv_admissions_65_74_years" DOUBLE,
  "number_of_adult_rsv_admissions_75_plus_years" DOUBLE,
  "total_adult_rsv_admissions" DOUBLE,
  "number_of_rsv_admissions_unknown_age" DOUBLE,
  "total_rsv_admissions" DOUBLE,
  "percent_inpatient_beds_occupied" DOUBLE,
  "percent_inpatient_beds_occupied_by_covid_19_patients" DOUBLE,
  "percent_inpatient_beds_occupied_by_influenza_patients" DOUBLE,
  "percent_inpatient_beds_occupied_by_rsv_patients" DOUBLE,
  "percent_icu_beds_occupied" DOUBLE,
  "percent_icu_beds_occupied_by_covid_19_patients" DOUBLE,
  "percent_icu_beds_occupied_by_influenza_patients" DOUBLE,
  "percent_icu_beds_occupied_by_rsv_patients" DOUBLE,
  "percent_adult_covid_19_admissions" DOUBLE,
  "percent_pediatric_covid_19_admissions" DOUBLE,
  "percent_adult_influenza_admissions" DOUBLE,
  "percent_pediatric_influenza_admissions" DOUBLE,
  "percent_adult_rsv_admissions" DOUBLE,
  "percent_pediatric_rsv_admissions" DOUBLE,
  "number_hospitals_reporting_number_of_inpatient_beds" DOUBLE,
  "number_hospitals_reporting_number_of_inpatient_beds_occupied" DOUBLE,
  "number_hospitals_reporting_number_of_icu_beds" DOUBLE,
  "number_hospitals_reporting_number_of_icu_beds_occupied" DOUBLE,
  "number_hospitals_reporting_total_patients_hospitalized_f4f04eeb" DOUBLE,
  "number_hospitals_reporting_totalpatients_hospitalized__4726992b" DOUBLE,
  "number_hospitals_reporting_total_patients_hospitalized_with_rsv" DOUBLE,
  "number_hospitals_reporting_icu_patients_hospitalized_w_ce48dfd3" DOUBLE,
  "number_hospitals_reporting_icu_patients_hospitalized_w_50f441d2" DOUBLE,
  "number_hospitals_reporting_icu_patients_hospitalized_with_rsv" DOUBLE,
  "number_hospitals_reporting_pediatric_covid_19_admissions" DOUBLE,
  "number_hospitals_reporting_adult_covid_19_admissions" DOUBLE,
  "number_hospitals_reporting_covid_19_admissions" DOUBLE,
  "number_hospitals_reporting_pediatric_influenza_admissions" DOUBLE,
  "number_hospitals_reporting_adult_influenza_admissions" DOUBLE,
  "number_hospitals_reporting_influenza_admissions" DOUBLE,
  "number_hospitals_reporting_pediatric_rsv_admissions" DOUBLE,
  "number_hospitals_reporting_adult_rsv_admissions" DOUBLE,
  "number_hospitals_reporting_rsv_admissions" DOUBLE,
  "number_hospitals_reporting_percent_inpatient_beds_occupied" DOUBLE,
  "number_hospitals_reporting_percent_icu_beds_occupied" DOUBLE,
  "number_hospitals_reporting_percent_inpatient_beds_occu_508abe62" DOUBLE,
  "number_hospitals_reporting_percent_inpatient_beds_occu_0d930be3" DOUBLE,
  "number_hospitals_reporting_percent_inpatient_beds_occu_35b5352e" DOUBLE
);