Baselight
Sign In

Weekly Hospital Respiratory Data And Metrics

Tracking Hospital Capacity, Occupancy, and Respiratory Illness Admissions

@kaggle.noeyislearning_weekly_hospital_respiratory_data_and_metrics

Loading...
Loading...

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.72 MB
  • 12,768 rows
  • 157 columns
Loading... 
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, 0-4 Years,
  "number_of_pediatric_covid_19_admissions_5_17_years" DOUBLE  -- Number Of Pediatric COVID-19 Admissions, 5-17 Years,
  "total_pediatric_covid_19_admissions" DOUBLE,
  "number_of_adult_covid_19_admissions_18_49_years" DOUBLE  -- Number Of Adult COVID-19 Admissions, 18-49 Years,
  "number_of_adult_covid_19_admissions_50_64_years" DOUBLE  -- Number Of Adult COVID-19 Admissions, 50-64 Years,
  "number_of_adult_covid_19_admissions_65_74_years" DOUBLE  -- Number Of Adult COVID-19 Admissions, 65-74 Years,
  "number_of_adult_covid_19_admissions_75_plus" DOUBLE  -- Number Of Adult COVID-19 Admissions, 75 Plus,
  "total_adult_covid_19_admissions" DOUBLE,
  "number_of_covid_19_admissions_unknown_age" DOUBLE  -- Number Of COVID-19 Admissions, Unknown Age,
  "total_covid_19_admissions" DOUBLE,
  "number_of_pediatric_influenza_admissions_0_4_years" DOUBLE  -- Number Of Pediatric Influenza Admissions, 0-4 Years,
  "number_of_pediatric_influenza_admissions_5_17_years" DOUBLE  -- Number Of Pediatric Influenza Admissions, 5-17 Years,
  "total_pediatric_influenza_admissions" DOUBLE,
  "number_of_adult_influenza_admissions_18_49_years" DOUBLE  -- Number Of Adult Influenza Admissions, 18-49 Years,
  "number_of_adult_influenza_admissions_50_64_years" DOUBLE  -- Number Of Adult Influenza Admissions, 50-64 Years,
  "number_of_adult_influenza_admissions_65_74_years" DOUBLE  -- Number Of Adult Influenza Admissions, 65-74 Years,
  "number_of_adult_influenza_admissions_75_plus_years" DOUBLE  -- Number Of Adult Influenza Admissions, 75 Plus Years,
  "total_adult_influenza_admissions" DOUBLE,
  "number_of_influenza_admissions_unknown_age" DOUBLE  -- Number Of Influenza Admissions, Unknown Age,
  "total_influenza_admissions" DOUBLE,
  "number_of_pediatric_rsv_admissions_0_4_years" DOUBLE  -- Number Of Pediatric RSV Admissions, 0-4 Years,
  "number_of_pediatric_rsv_admissions_5_17_years" DOUBLE  -- Number Of Pediatric RSV Admissions, 5-17 Years,
  "total_pediatric_rsv_admissions" DOUBLE,
  "number_of_adult_rsv_admissions_18_49_years" DOUBLE  -- Number Of Adult RSV Admissions, 18-49 Years,
  "number_of_adult_rsv_admissions_50_64_years" DOUBLE  -- Number Of Adult RSV Admissions, 50-64 Years,
  "number_of_adult_rsv_admissions_65_74_years" DOUBLE  -- Number Of Adult RSV Admissions, 65-74 Years,
  "number_of_adult_rsv_admissions_75_plus_years" DOUBLE  -- Number Of Adult RSV Admissions, 75 Plus Years,
  "total_adult_rsv_admissions" DOUBLE,
  "number_of_rsv_admissions_unknown_age" DOUBLE  -- Number Of RSV Admissions, Unknown Age,
  "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 Total Patients Hospitalized With COVID-19,
  "number_hospitals_reporting_totalpatients_hospitalized__4726992b" DOUBLE  -- Number Hospitals Reporting TotalPatients Hospitalized With Influenza,
  "number_hospitals_reporting_total_patients_hospitalized_with_rsv" DOUBLE,
  "number_hospitals_reporting_icu_patients_hospitalized_w_ce48dfd3" DOUBLE  -- Number Hospitals Reporting ICU Patients Hospitalized With COVID-19,
  "number_hospitals_reporting_icu_patients_hospitalized_w_50f441d2" DOUBLE  -- Number Hospitals Reporting ICU Patients Hospitalized With Influenza,
  "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 Occupied By COVID-19 Patients,
  "number_hospitals_reporting_percent_inpatient_beds_occu_0d930be3" DOUBLE  -- Number Hospitals Reporting Percent Inpatient Beds Occupied By Influenza Patients,
  "number_hospitals_reporting_percent_inpatient_beds_occu_35b5352e" DOUBLE  -- Number Hospitals Reporting Percent Inpatient Beds Occupied By RSV Patients
);

Share link

Anyone who has the link will be able to view this.