Name: COVID-19–20200729 FAQ Template V3
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

COVID-19–20200729 FAQ Template V3

Prior template for requested daily data reports on testing, capacity and utilization, and patient flows to facilitate the public health response to the 2019 Novel Coronavirus (COVID-19).
Organization: U.S. Department of Health & Human Services
Last updated: 2021-06-03T22:18:11.252221
Tags: covid-19, hospital

Tables

Table 1

@usgov.hhs_gov_covid_0729_faq_template_v3_yyyymmdd.table_1

93.11 kB
1 row
104 columns

CREATE TABLE table_1 (
  "reporting_for_date" VARCHAR,
  "hospital_name" VARCHAR,
  "ccn" VARCHAR,
  "org_id" VARCHAR,
  "state" VARCHAR,
  "county" VARCHAR,
  "zip" VARCHAR,
  "teletracking_id" VARCHAR,
  "all_hospital_beds" BIGINT,
  "all_adult_hospital_beds" BIGINT,
  "all_hospital_inpatient_beds" BIGINT,
  "all_adult_hospital_inpatient_beds" BIGINT,
  "all_hospital_inpatient_bed_occupied" BIGINT,
  "all_adult_hospital_inpatient_bed_occupied" BIGINT,
  "total_staffed_icu_beds" BIGINT,
  "total_staffed_adult_icu_beds" BIGINT,
  "staffed_icu_bed_occupancy" BIGINT,
  "staffed_adult_icu_bed_occupancy" BIGINT,
  "mechanical_ventilators" BIGINT,
  "mechanical_ventilators_in_use" BIGINT,
  "total_adult_patients_hospitalized_confirmed_and_suspected_covid" BIGINT,
  "total_adult_patients_hospitalized_confirmed_covid" BIGINT,
  "total_pediatric_patients_hospitalized_confirmed_and_su_7b73e128" BIGINT  -- Total Pediatric Patients Hospitalized Confirmed And Suspected Covid,
  "total_pediatric_patients_hospitalized_confirmed_covid" BIGINT,
  "hospitalized_and_ventilated_covid_patients" BIGINT,
  "staffed_icu_adult_patients_confirmed_and_suspected_covid" BIGINT,
  "staffed_icu_adult_patients_confirmed_covid" BIGINT,
  "hospital_onset" BIGINT,
  "ed_or_overflow" BIGINT,
  "ed_or_overflow_and_ventilated" BIGINT,
  "previous_day_deaths_covid" BIGINT,
  "previous_day_admission_adult_covid_confirmed" BIGINT,
  "previous_day_admission_adult_covid_confirmed_18_19" BIGINT,
  "previous_day_admission_adult_covid_confirmed_20_29" BIGINT,
  "previous_day_admission_adult_covid_confirmed_30_39" BIGINT,
  "previous_day_admission_adult_covid_confirmed_40_49" BIGINT,
  "previous_day_admission_adult_covid_confirmed_50_59" BIGINT,
  "previous_day_admission_adult_covid_confirmed_60_69" BIGINT,
  "previous_day_admission_adult_covid_confirmed_70_79" BIGINT,
  "previous_day_admission_adult_covid_confirmed_80_plus" BIGINT,
  "previous_day_admission_adult_covid_confirmed_unknown_age" BIGINT,
  "previous_day_admission_adult_covid_suspected" BIGINT,
  "previous_day_admission_adult_covid_suspected_18_19" BIGINT,
  "previous_day_admission_adult_covid_suspected_20_29" BIGINT,
  "previous_day_admission_adult_covid_suspected_30_39" BIGINT,
  "previous_day_admission_adult_covid_suspected_40_49" BIGINT,
  "previous_day_admission_adult_covid_suspected_50_59" BIGINT,
  "previous_day_admission_adult_covid_suspected_60_69" BIGINT,
  "previous_day_admission_adult_covid_suspected_70_79" BIGINT,
  "previous_day_admission_adult_covid_suspected_80_plus" BIGINT,
  "previous_day_admission_adult_covid_suspected_unknown_age" BIGINT,
  "previous_day_admission_pediatric_covid_confirmed" BIGINT,
  "previous_day_admission_pediatric_covid_suspected" BIGINT,
  "previous_day_total_ed_visits" BIGINT,
  "previous_day_covid_ed_visits" BIGINT,
  "previous_day_remdesivir_used" BIGINT,
  "on_hand_supply_remdesivir_vials" BIGINT,
  "critical_staffing_shortage_today" VARCHAR,
  "critical_staffing_shortage_anticipated_within_week" VARCHAR,
  "staffing_shortage_details" VARCHAR,
  "ppe_supply_management_source" VARCHAR,
  "on_hand_ventilator_supplies_in_days" VARCHAR,
  "on_hand_supply_of_n95_respirators_in_days" VARCHAR,
  "on_hand_supply_of_surgical_masks_in_days" VARCHAR,
  "on_hand_supply_of_eye_protection_in_days" VARCHAR,
  "on_hand_supply_of_single_use_surgical_gowns_in_days" VARCHAR,
  "on_hand_supply_of_gloves_in_days" VARCHAR,
  "on_hand_supply_of_n95_respirators_in_units" BIGINT,
  "on_hand_supply_of_papr_in_units" BIGINT,
  "on_hand_supply_of_surgical_masks_in_units" BIGINT,
  "on_hand_supply_of_eye_protection_in_units" BIGINT,
  "on_hand_supply_of_single_use_surgical_gowns_in_units" BIGINT,
  "on_hand_supply_of_launderable_surgical_gowns_in_units" BIGINT,
  "on_hand_supply_of_gloves_in_units" BIGINT,
  "able_to_obtain_ventilator_supplies" VARCHAR,
  "able_to_obtain_ventilator_medications" VARCHAR,
  "able_to_obtain_n95_masks" VARCHAR,
  "able_to_obtain_paprs" VARCHAR,
  "able_to_obtain_surgical_masks" VARCHAR,
  "able_to_obtain_eye_protection" VARCHAR,
  "able_to_obtain_single_use_gowns" VARCHAR,
  "able_to_obtain_gloves" VARCHAR,
  "able_to_obtain_launderable_gowns" VARCHAR,
  "able_to_maintain_ventilator_3day_supplies" VARCHAR,
  "able_to_maintain_ventilator_3day_medications" VARCHAR,
  "able_to_maintain_n95_masks" VARCHAR,
  "able_to_maintain_3day_paprs" VARCHAR,
  "able_to_maintain_3day_surgical_masks" VARCHAR,
  "able_to_maintain_3day_eye_protection" VARCHAR,
  "able_to_maintain_3day_single_use_gowns" VARCHAR,
  "able_to_maintain_3day_gloves" VARCHAR,
  "able_to_maintain_3day_lab_nasal_pharyngeal_swabs" VARCHAR,
  "able_to_maintain_lab_nasal_swabs" VARCHAR,
  "able_to_maintain_3day_lab_viral_transport_media" VARCHAR,
  "reusable_isolation_gowns_used" VARCHAR,
  "reusable_paprs_or_elastomerics_used" VARCHAR,
  "reusuable_n95_masks_used" VARCHAR,
  "anticipated_medical_supply_medication_shortages" VARCHAR,
  "total_patients_hospitalized_confirmed_influenza" BIGINT,
  "previous_day_admission_influenza_confirmed" BIGINT
);