Dataset: Respiratory Virus Response (RVR) United States Hospitalization Metrics By Jurisdiction, Timeseries

About this Dataset

Respiratory Virus Response (RVR) United States Hospitalization Metrics By Jurisdiction, Timeseries

Note: After May 3, 2024, this dataset will no longer be updated because hospitals are no longer required to report data on COVID-19 and influenza hospital admissions, hospital capacity, or occupancy data to HHS through CDC’s National Healthcare Safety Network (NHSN). This dataset represents hospitalization data and metrics aggregated to country, HHS region, and state/territory. Hospitalization data are reported to CDC’s National Healthcare Safety Network, which monitors national and local trends in healthcare system stress, capacity, and community disease levels for approximately 6,000 hospitals in the United States. Data reported by hospitals to NHSN and included in this dataset represent aggregated counts and include metrics capturing information specific to hospital admissions, and inpatient and ICU bed capacity occupancy. Data fields for new admissions of pediatric patients with confirmed COVID-19 for ages 0-4 years, 5-11 years, and 12-17 years were not required for reporting until February 2022; therefore, data for the following fields in this dataset begin on March 1, 2022 to account for delays in initial reporting of these fields: adm_00_04_covid_confirmed avg_adm_00_04_covid_confirmed avg_adm_00_04_covid_confirmed_per_100k adm_05_11_covid_confirmed avg_adm_05_11_covid_confirmed avg_adm_05_11_covid_confirmed_per_100k adm_12_17_covid_confirmed avg_adm_12_17_covid_confirmed avg_adm_12_17_covid_confirmed_per_100k Updated weekly each Friday at noon, ET.
Organization: U.S. Department of Health & Human Services
Last updated: 2023-10-22T01:14:35.018235
Tags: admissions, coronavirus, covid-19, hospital-capacity, hospitalizations, icu-beds, inpatient-beds, ncezid, respiratory-virus-response

Tables

Table 1

@usgov.hhs_gov_respiratory_virus_response_rvr_united_states_h_94904164.table_1

21.79 MB
88091 rows
115 columns


CREATE TABLE table_1 (
  "jurisdiction" VARCHAR,
  "collection_date" TIMESTAMP,
  "number_hospitals_reporting_today" DOUBLE,
  "total_hospitals" DOUBLE,
  "admissions_all_covid_confirmed" DOUBLE,
  "admissions_70_covid_confirmed" DOUBLE,
  "admissions_30_49_covid_confirmed" DOUBLE,
  "admissions_50_69_covid_confirmed" DOUBLE,
  "admissions_50_59_covid_confirmed" DOUBLE,
  "admissions_30_39_covid_confirmed" DOUBLE,
  "admissions_40_49_covid_confirmed" DOUBLE,
  "admissions_18_29_covid_confirmed" DOUBLE,
  "admissions_20_29_covid_confirmed" DOUBLE,
  "admissions_0_17_covid_confirmed" DOUBLE,
  "average_admissions_all_covid_confirmed" DOUBLE,
  "average_admissions_18_29_covid_confirmed" DOUBLE,
  "average_admissions_40_49_covid_confirmed" DOUBLE,
  "average_admissions_60_69_covid_confirmed" DOUBLE,
  "average_admissions_30_39_covid_confirmed" DOUBLE,
  "average_admissions_30_49_covid_confirmed" DOUBLE,
  "average_admissions_50_69_covid_confirmed" DOUBLE,
  "average_admissions_20_29_covid_confirmed" DOUBLE,
  "average_admissions_0_17_covid_confirmed" DOUBLE,
  "average_admissions_70_covid_confirmed" DOUBLE,
  "average_admissions_50_59_covid_confirmed" DOUBLE,
  "admissions_60_69_covid_confirmed" DOUBLE,
  "average_admissions_60_69_covid_confirmed_per_100k" DOUBLE,
  "average_admissions_0_17_covid_confirmed_per_100k" DOUBLE,
  "average_admissions_50_59_covid_confirmed_per_100k" DOUBLE,
  "average_admissions_all_covid_confirmed_per_100k" DOUBLE,
  "average_admissions_30_39_covid_confirmed_per_100k" DOUBLE,
  "average_admissions_40_49_covid_confirmed_per_100k" DOUBLE,
  "average_admissions_70_covid_confirmed_per_100k" DOUBLE,
  "average_admissions_50_69_covid_confirmed_per_100k" DOUBLE,
  "average_admissions_20_29_covid_confirmed_per_100k" DOUBLE,
  "average_admissions_30_49_covid_confirmed_per_100k" DOUBLE,
  "average_admissions_18_29_covid_confirmed_per_100k" DOUBLE,
  "total_admissions_all_covid_confirmed_past_7days_per_100k" DOUBLE,
  "percent_change_total_admissions_all_covid_confirmed_pa_f48b10c2" DOUBLE,
  "total_patients_hospitalized_covid_confirmed" DOUBLE,
  "average_total_patients_hospitalized_covid_confirmed" DOUBLE,
  "total_adult_patients_hospitalized_covid_confirmed" DOUBLE,
  "total_pediatric_patients_hospitalized_covid_confirmed" DOUBLE,
  "inpatient_beds" DOUBLE,
  "average_inpatient_beds" DOUBLE,
  "inpatient_adult_beds" DOUBLE,
  "inpatient_pediatric_beds" DOUBLE,
  "inpatient_beds_used" DOUBLE,
  "average_inpatient_beds_occupied" DOUBLE,
  "inpatient_adult_beds_used" DOUBLE,
  "inpatient_pediatric_beds_used" DOUBLE,
  "total_icu_beds" DOUBLE,
  "total_staffed_adult_icu_beds" DOUBLE,
  "total_staffed_pediatric_icu_beds" DOUBLE,
  "staff_icu_adult_patients_covid_confirmed" DOUBLE,
  "staff_icu_pediatric_patients_covid_confirmed" DOUBLE,
  "icu_beds_used" DOUBLE,
  "staff_adult_icu_beds_occupied" DOUBLE,
  "staff_pediatric_icu_beds_occupied" DOUBLE,
  "staff_icu_patients_covid_confirmed" DOUBLE,
  "percent_inpatient_beds_occupied" DOUBLE,
  "percent_adult_inpatient_beds_occupied" DOUBLE,
  "percent_pediatric_inpatient_beds_occupied" DOUBLE,
  "percent_inpatient_beds_covid" DOUBLE,
  "percent_adult_inpatient_beds_covid" DOUBLE,
  "percent_pediatric_inpatient_beds_covid" DOUBLE,
  "percent_staff_icu_beds_occupied" DOUBLE,
  "percent_staff_adult_icu_beds_occupied" DOUBLE,
  "percent_staff_pediatric_icu_beds_occupied" DOUBLE,
  "percent_staff_icu_beds_covid" DOUBLE,
  "percent_staff_adult_icu_beds_covid" DOUBLE,
  "percent_staff_pediatric_icu_beds_covid" DOUBLE,
  "average_percent_inpatient_beds_occupied" DOUBLE,
  "absolute_change_average_percent_inpatient_beds_occupied" DOUBLE,
  "average_percent_adult_inpatient_beds_occupied" DOUBLE,
  "average_percent_pediatric_inpatient_beds_occupied" DOUBLE,
  "average_percent_inpatient_beds_covid" DOUBLE,
  "average_percent_adult_inpatient_beds_covid" DOUBLE,
  "average_percent_pediatric_inpatient_beds_covid" DOUBLE,
  "average_percent_staff_icu_beds_occupied" DOUBLE,
  "absolute_change_average_percent_staff_icu_beds_occupied" DOUBLE,
  "average_percent_staff_adult_icu_beds_occupied" DOUBLE,
  "average_percent_staff_pediatric_icu_beds_occupied" DOUBLE,
  "average_percent_staff_icu_beds_covid" DOUBLE,
  "average_percent_staff_adult_icu_beds_covid" DOUBLE,
  "average_percent_staff_pediatric_icu_beds_covid" DOUBLE,
  "total_admissions_all_covid_confirmed_past_7days" BIGINT,
  "percent_change_total_admissions_all_covid_confirmed_past_7days" DOUBLE,
  "absolute_change_average_percent_inpatient_beds_covid" DOUBLE,
  "absolute_change_average_percent_staff_icu_beds_covid" DOUBLE,
  "total_admissions_all_influenza_confirmed_past_7days" DOUBLE,
  "percent_change_total_admissions_all_influenza_confirme_71bd3882" DOUBLE,
  "total_admissions_all_influenza_confirmed_past_7days_per_100k" DOUBLE,
  "percent_change_total_admissions_all_influenza_confirme_cef16982" DOUBLE,
  "total_patients_hospitalized_influenza_confirmed" DOUBLE,
  "percent_inpatient_beds_influenza" DOUBLE,
  "average_percent_inpatient_beds_influenza" DOUBLE,
  "absolute_change_average_percent_inpatient_beds_influenza" DOUBLE,
  "icu_patients_influenza_confirmed" DOUBLE,
  "percent_staff_icu_beds_influenza" DOUBLE
);