Name: COVID-19 Patient Impact & Hospital Capacity Data
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

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

6.04 MB
87,369 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 And Suspected Covid 7 Day Avg,
  "total_adult_patients_hospitalized_confirmed_covid_7_day_avg" DOUBLE,
  "total_pediatric_patients_hospitalized_confirmed_and_su_216287c4" DOUBLE  -- Total Pediatric Patients Hospitalized Confirmed And Suspected Covid 7 Day Avg,
  "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 And Suspected Covid 7 Day Avg,
  "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 Patients Hospitalized Confirmed Influenza And Covid 7 Day Avg,
  "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 And Suspected Covid 7 Day Sum,
  "total_adult_patients_hospitalized_confirmed_covid_7_day_sum" DOUBLE,
  "total_pediatric_patients_hospitalized_confirmed_and_su_0e3e27a2" DOUBLE  -- Total Pediatric Patients Hospitalized Confirmed And Suspected Covid 7 Day Sum,
  "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 And Suspected Covid 7 Day Sum,
  "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 Patients Hospitalized Confirmed Influenza And Covid 7 Day Sum,
  "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 And Suspected Covid 7 Day Coverage,
  "total_adult_patients_hospitalized_confirmed_covid_7_da_9b82048b" BIGINT  -- Total Adult Patients Hospitalized Confirmed Covid 7 Day Coverage,
  "total_pediatric_patients_hospitalized_confirmed_and_su_962bec75" BIGINT  -- Total Pediatric Patients Hospitalized Confirmed And Suspected Covid 7 Day Coverage,
  "total_pediatric_patients_hospitalized_confirmed_covid__6fcb8fa8" BIGINT  -- Total Pediatric Patients Hospitalized Confirmed Covid 7 Day Coverage,
  "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 And Suspected Covid 7 Day Coverage,
  "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  -- Total Patients Hospitalized Confirmed Influenza And Covid 7 Day Coverage,
  "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 80+ 7 Day Sum,
  "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 80+ 7 Day Sum,
  "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
);