hosp_capacity: 552

This data as json

rowid hospital_pk collection_week state ccn hospital_name address city zip hospital_subtype fips_code is_metro_micro total_beds_7_day_avg all_adult_hospital_beds_7_day_avg all_adult_hospital_inpatient_beds_7_day_avg inpatient_beds_used_7_day_avg all_adult_hospital_inpatient_bed_occupied_7_day_avg inpatient_beds_used_covid_7_day_avg total_adult_patients_hospitalized_confirmed_and_suspected_covid_7_day_avg total_adult_patients_hospitalized_confirmed_covid_7_day_avg total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_7_day_avg total_pediatric_patients_hospitalized_confirmed_covid_7_day_avg inpatient_beds_7_day_avg total_icu_beds_7_day_avg total_staffed_adult_icu_beds_7_day_avg icu_beds_used_7_day_avg staffed_adult_icu_bed_occupancy_7_day_avg staffed_icu_adult_patients_confirmed_and_suspected_covid_7_day_avg staffed_icu_adult_patients_confirmed_covid_7_day_avg total_patients_hospitalized_confirmed_influenza_7_day_avg icu_patients_confirmed_influenza_7_day_avg total_patients_hospitalized_confirmed_influenza_and_covid_7_day_avg total_beds_7_day_sum all_adult_hospital_beds_7_day_sum all_adult_hospital_inpatient_beds_7_day_sum inpatient_beds_used_7_day_sum all_adult_hospital_inpatient_bed_occupied_7_day_sum inpatient_beds_used_covid_7_day_sum total_adult_patients_hospitalized_confirmed_and_suspected_covid_7_day_sum total_adult_patients_hospitalized_confirmed_covid_7_day_sum total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_7_day_sum total_pediatric_patients_hospitalized_confirmed_covid_7_day_sum inpatient_beds_7_day_sum total_icu_beds_7_day_sum total_staffed_adult_icu_beds_7_day_sum icu_beds_used_7_day_sum staffed_adult_icu_bed_occupancy_7_day_sum staffed_icu_adult_patients_confirmed_and_suspected_covid_7_day_sum staffed_icu_adult_patients_confirmed_covid_7_day_sum total_patients_hospitalized_confirmed_influenza_7_day_sum icu_patients_confirmed_influenza_7_day_sum total_patients_hospitalized_confirmed_influenza_and_covid_7_day_sum total_beds_7_day_coverage all_adult_hospital_beds_7_day_coverage all_adult_hospital_inpatient_beds_7_day_coverage inpatient_beds_used_7_day_coverage all_adult_hospital_inpatient_bed_occupied_7_day_coverage inpatient_beds_used_covid_7_day_coverage total_adult_patients_hospitalized_confirmed_and_suspected_covid_7_day_coverage total_adult_patients_hospitalized_confirmed_covid_7_day_coverage total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_7_day_coverage total_pediatric_patients_hospitalized_confirmed_covid_7_day_coverage inpatient_beds_7_day_coverage total_icu_beds_7_day_coverage total_staffed_adult_icu_beds_7_day_coverage icu_beds_used_7_day_coverage staffed_adult_icu_bed_occupancy_7_day_coverage staffed_icu_adult_patients_confirmed_and_suspected_covid_7_day_coverage staffed_icu_adult_patients_confirmed_covid_7_day_coverage total_patients_hospitalized_confirmed_influenza_7_day_coverage icu_patients_confirmed_influenza_7_day_coverage total_patients_hospitalized_confirmed_influenza_and_covid_7_day_coverage previous_day_admission_adult_covid_confirmed_7_day_sum previous_day_admission_adult_covid_confirmed_18-19_7_day_sum previous_day_admission_adult_covid_confirmed_20-29_7_day_sum previous_day_admission_adult_covid_confirmed_30-39_7_day_sum previous_day_admission_adult_covid_confirmed_40-49_7_day_sum previous_day_admission_adult_covid_confirmed_50-59_7_day_sum previous_day_admission_adult_covid_confirmed_60-69_7_day_sum previous_day_admission_adult_covid_confirmed_70-79_7_day_sum previous_day_admission_adult_covid_confirmed_80+_7_day_sum previous_day_admission_adult_covid_confirmed_unknown_7_day_sum previous_day_admission_pediatric_covid_confirmed_7_day_sum previous_day_covid_ED_visits_7_day_sum previous_day_admission_adult_covid_suspected_7_day_sum previous_day_admission_adult_covid_suspected_18-19_7_day_sum previous_day_admission_adult_covid_suspected_20-29_7_day_sum previous_day_admission_adult_covid_suspected_30-39_7_day_sum previous_day_admission_adult_covid_suspected_40-49_7_day_sum previous_day_admission_adult_covid_suspected_50-59_7_day_sum previous_day_admission_adult_covid_suspected_60-69_7_day_sum previous_day_admission_adult_covid_suspected_70-79_7_day_sum previous_day_admission_adult_covid_suspected_80+_7_day_sum previous_day_admission_adult_covid_suspected_unknown_7_day_sum previous_day_admission_pediatric_covid_suspected_7_day_sum previous_day_total_ED_visits_7_day_sum previous_day_admission_influenza_confirmed_7_day_sum geocoded_hospital_address hhs_ids previous_day_admission_adult_covid_confirmed_7_day_coverage previous_day_admission_pediatric_covid_confirmed_7_day_coverage previous_day_admission_adult_covid_suspected_7_day_coverage previous_day_admission_pediatric_covid_suspected_7_day_coverage previous_week_personnel_covid_vaccinated_doses_administered_7_day total_personnel_covid_vaccinated_doses_none_7_day total_personnel_covid_vaccinated_doses_one_7_day total_personnel_covid_vaccinated_doses_all_7_day previous_week_patients_covid_vaccinated_doses_one_7_day previous_week_patients_covid_vaccinated_doses_all_7_day is_corrected
552 390028 2020/10/02 PA 390028 UPMC MERCY 1400 LOCUST STREET PITTSBURGH 15219 Short Term 42003 1       388.9   5.6 5.6 4.6 0.0 0.0 406.0 69.0 69.0 59.6 59.6 0.0 0.0             2722   39 39 32 0 0 2842 483 483 417 417 0 0       0 0 0 7 0 7 7 7 7 7 7 7 7 7 7 7 7 0 0 0 5                       8                         POINT (-79.985623 40.436831) [C390028-A] 7 0 7 0             0
Powered by Datasette · Queries took 1.57ms