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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 508 | 400127 | 2020/11/20 | PR | 400127 | ADMIN DE SERVICIOS MEDICOS PUERTO RIC | BO MONACILLO CARR NUM 22 | SAN JUAN | 935 | Short Term | 72127 | 1 | 92.0 | 84.9 | 84.9 | 60.1 | 60.1 | 84.9 | 20.0 | 20.0 | 19.3 | 19.3 | 0.0 | 0.0 | 0.0 | 644 | 594 | 594 | 421 | 421 | 594 | 140 | 140 | 135 | 135 | 0 | 0 | 0 | 7 | 7 | 7 | 7 | 7 | 0 | 0 | 0 | 0 | 0 | 7 | 7 | 7 | 7 | 7 | 0 | 0 | 6 | 6 | 6 | 470 | 0 | [C400127-A] | 0 | 0 | 0 | 0 | 0 |