Dataset: COVID-19 Patient Impact & Hospital Capacity Data

About this Dataset

COVID-19 Patient Impact & Hospital Capacity Data

Source: https://healthdata.gov/dataset/covid-19-reported-patient-impact-and-hospital-capacity-facility

The following dataset provides facility-level data for hospital utilization aggregated on a weekly basis (Friday to Thursday). These are 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.

The hospital population includes all hospitals registered with Centers for Medicare & Medicaid Services (CMS) as of June 1, 2020. It includes non-CMS hospitals that have reported since July 15, 2020. It does not include psychiatric, rehabilitation, Indian Health Service (IHS) facilities, U.S. Department of Veterans Affairs (VA) facilities, Defense Health Agency (DHA) facilities, and religious non-medical facilities.

For a given entry, the term “collection_week” signifies the start of the period that is aggregated. For example, a “collection_week” of 2020-11-20 means the average/sum/coverage of the elements captured from that given facility starting and including Friday, November 20, 2020, and ending and including reports for Thursday, November 26, 2020.

Reported elements include an append of either “_coverage”, “_sum”, or “_avg”.

A “_coverage” append denotes how many times the facility reported that element during that collection week.
A “_sum” append denotes the sum of the reports provided for that facility for that element during that collection week.
A “_avg” append is the average of the reports provided for that facility for that element during that collection week.

The file will be updated weekly. No statistical analysis is applied to impute non-response. For averages, calculations are based on the number of values collected for a given hospital in that collection week. Suppression is applied to the file for sums and averages less than four (4). In these cases, the field will be replaced with “-999,999”.

This data is preliminary and subject to change as more data become available. Data is available starting on July 31, 2020.

Sometimes, reports for a given facility will be provided to both HHS TeleTracking and HHS Protect. When this occurs, to ensure that there are not duplicate reports, deduplication is applied according to prioritization rules within HHS Protect.

For influenza fields listed in the file, the current HHS guidance marks these fields as optional. As a result, coverage of these elements are varied.

Tables

Reported Hospital Capacity Admissions Facility Level W 439cabd6

@kaggle.aditirajagopal_covid19_patient_impact_hospital_capacity_data.reported_hospital_capacity_admissions_facility_level_w_439cabd6

5.76 MB
87369 rows
93 columns


CREATE TABLE reported_hospital_capacity_admissions_facility_level_w_439cabd6 (
  "hospital_pk" VARCHAR,
  "collection_week" TIMESTAMP,
  "state" VARCHAR,
  "ccn" VARCHAR,
  "hospital_name" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "zip" DOUBLE,
  "hospital_subtype" VARCHAR,
  "fips_code" DOUBLE,
  "is_metro_micro" BOOLEAN,
  "total_beds_7_day_avg" DOUBLE,
  "all_adult_hospital_beds_7_day_avg" DOUBLE,
  "all_adult_hospital_inpatient_beds_7_day_avg" DOUBLE,
  "inpatient_beds_used_7_day_avg" DOUBLE,
  "all_adult_hospital_inpatient_bed_occupied_7_day_avg" DOUBLE,
  "total_adult_patients_hospitalized_confirmed_and_suspec_1ed5a943" DOUBLE,
  "total_adult_patients_hospitalized_confirmed_covid_7_day_avg" DOUBLE,
  "total_pediatric_patients_hospitalized_confirmed_and_su_216287c4" DOUBLE,
  "total_pediatric_patients_hospitalized_confirmed_covid_7_day_avg" DOUBLE,
  "inpatient_beds_7_day_avg" DOUBLE,
  "total_icu_beds_7_day_avg" DOUBLE,
  "total_staffed_adult_icu_beds_7_day_avg" DOUBLE,
  "icu_beds_used_7_day_avg" DOUBLE,
  "staffed_adult_icu_bed_occupancy_7_day_avg" DOUBLE,
  "staffed_icu_adult_patients_confirmed_and_suspected_cov_b5828d77" DOUBLE,
  "staffed_icu_adult_patients_confirmed_covid_7_day_avg" DOUBLE,
  "total_patients_hospitalized_confirmed_influenza_7_day_avg" DOUBLE,
  "icu_patients_confirmed_influenza_7_day_avg" DOUBLE,
  "total_patients_hospitalized_confirmed_influenza_and_co_1a15b714" DOUBLE,
  "total_beds_7_day_sum" DOUBLE,
  "all_adult_hospital_beds_7_day_sum" DOUBLE,
  "all_adult_hospital_inpatient_beds_7_day_sum" DOUBLE,
  "inpatient_beds_used_7_day_sum" DOUBLE,
  "all_adult_hospital_inpatient_bed_occupied_7_day_sum" DOUBLE,
  "total_adult_patients_hospitalized_confirmed_and_suspec_54297f60" DOUBLE,
  "total_adult_patients_hospitalized_confirmed_covid_7_day_sum" DOUBLE,
  "total_pediatric_patients_hospitalized_confirmed_and_su_0e3e27a2" DOUBLE,
  "total_pediatric_patients_hospitalized_confirmed_covid_7_day_sum" DOUBLE,
  "inpatient_beds_7_day_sum" DOUBLE,
  "total_icu_beds_7_day_sum" DOUBLE,
  "total_staffed_adult_icu_beds_7_day_sum" DOUBLE,
  "icu_beds_used_7_day_sum" DOUBLE,
  "staffed_adult_icu_bed_occupancy_7_day_sum" DOUBLE,
  "staffed_icu_adult_patients_confirmed_and_suspected_cov_a7df3ebd" DOUBLE,
  "staffed_icu_adult_patients_confirmed_covid_7_day_sum" DOUBLE,
  "total_patients_hospitalized_confirmed_influenza_7_day_sum" DOUBLE,
  "icu_patients_confirmed_influenza_7_day_sum" DOUBLE,
  "total_patients_hospitalized_confirmed_influenza_and_co_348e4458" DOUBLE,
  "total_beds_7_day_coverage" BIGINT,
  "all_adult_hospital_beds_7_day_coverage" BIGINT,
  "all_adult_hospital_inpatient_beds_7_day_coverage" BIGINT,
  "inpatient_beds_used_7_day_coverage" BIGINT,
  "all_adult_hospital_inpatient_bed_occupied_7_day_coverage" BIGINT,
  "total_adult_patients_hospitalized_confirmed_and_suspec_59066a6f" BIGINT,
  "total_adult_patients_hospitalized_confirmed_covid_7_da_9b82048b" BIGINT,
  "total_pediatric_patients_hospitalized_confirmed_and_su_962bec75" BIGINT,
  "total_pediatric_patients_hospitalized_confirmed_covid__6fcb8fa8" BIGINT,
  "inpatient_beds_7_day_coverage" BIGINT,
  "total_icu_beds_7_day_coverage" BIGINT,
  "total_staffed_adult_icu_beds_7_day_coverage" BIGINT,
  "icu_beds_used_7_day_coverage" BIGINT,
  "staffed_adult_icu_bed_occupancy_7_day_coverage" BIGINT,
  "staffed_icu_adult_patients_confirmed_and_suspected_cov_8aaa3f84" BIGINT,
  "staffed_icu_adult_patients_confirmed_covid_7_day_coverage" BIGINT,
  "total_patients_hospitalized_confirmed_influenza_7_day_coverage" BIGINT,
  "icu_patients_confirmed_influenza_7_day_coverage" BIGINT,
  "total_patients_hospitalized_confirmed_influenza_and_co_af5a54bb" BIGINT,
  "previous_day_admission_adult_covid_confirmed_7_day_sum" DOUBLE,
  "previous_day_admission_adult_covid_confirmed_18_19_7_day_sum" DOUBLE,
  "previous_day_admission_adult_covid_confirmed_20_29_7_day_sum" DOUBLE,
  "previous_day_admission_adult_covid_confirmed_30_39_7_day_sum" DOUBLE,
  "previous_day_admission_adult_covid_confirmed_40_49_7_day_sum" DOUBLE,
  "previous_day_admission_adult_covid_confirmed_50_59_7_day_sum" DOUBLE,
  "previous_day_admission_adult_covid_confirmed_60_69_7_day_sum" DOUBLE,
  "previous_day_admission_adult_covid_confirmed_70_79_7_day_sum" DOUBLE,
  "previous_day_admission_adult_covid_confirmed_80_7_day_sum" DOUBLE,
  "previous_day_admission_adult_covid_confirmed_unknown_7_day_sum" DOUBLE,
  "previous_day_admission_pediatric_covid_confirmed_7_day_sum" DOUBLE,
  "previous_day_covid_ed_visits_7_day_sum" DOUBLE,
  "previous_day_admission_adult_covid_suspected_7_day_sum" DOUBLE,
  "previous_day_admission_adult_covid_suspected_18_19_7_day_sum" DOUBLE,
  "previous_day_admission_adult_covid_suspected_20_29_7_day_sum" DOUBLE,
  "previous_day_admission_adult_covid_suspected_30_39_7_day_sum" DOUBLE,
  "previous_day_admission_adult_covid_suspected_40_49_7_day_sum" DOUBLE,
  "previous_day_admission_adult_covid_suspected_50_59_7_day_sum" DOUBLE,
  "previous_day_admission_adult_covid_suspected_60_69_7_day_sum" DOUBLE,
  "previous_day_admission_adult_covid_suspected_70_79_7_day_sum" DOUBLE,
  "previous_day_admission_adult_covid_suspected_80_7_day_sum" DOUBLE,
  "previous_day_admission_adult_covid_suspected_unknown_7_day_sum" DOUBLE,
  "previous_day_admission_pediatric_covid_suspected_7_day_sum" DOUBLE,
  "previous_day_total_ed_visits_7_day_sum" DOUBLE,
  "previous_day_admission_influenza_confirmed_7_day_sum" DOUBLE
);