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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19 | 140080 | 2020/09/04 | IL | 140080 | PRESENCE SAINT FRANCIS HOSPITAL | 355 RIDGE AVE | EVANSTON | 60202 | Short Term | 17031 | 1 | 190.0 | 190.0 | 155.0 | 70.9 | 70.9 | 10.6 | 10.6 | -999999.0 | 0.0 | 0.0 | 155.0 | 35.0 | 35.0 | 11.6 | 11.6 | 4.1 | -999999.0 | 1330 | 1330 | 1085 | 496 | 496 | 74 | 74 | 26 | 0 | 0 | 1085 | 245 | 245 | 81 | 81 | 29 | 9 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 0 | 0 | 0 | 0 | 53 | 220 | POINT (-87.685223 42.024553) | [C140080-A] | 7 | 0 | 7 | 0 | 0 |