hospitals_state

Data source: U.S. Department of Health & Human Services

29 rows where previous_day_deaths_influenza = 5 sorted by previous_day_admission_adult_covid_suspected_20-29_coverage

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: state, date, critical_staffing_shortage_today_no, previous_day_admission_adult_covid_confirmed, previous_day_admission_pediatric_covid_confirmed, previous_day_admission_pediatric_covid_suspected, staffed_icu_adult_patients_confirmed_and_suspected_covid_coverage, total_adult_patients_hospitalized_confirmed_and_suspected_covid_coverage, total_adult_patients_hospitalized_confirmed_covid_coverage, total_staffed_adult_icu_beds, inpatient_beds_utilization_coverage, inpatient_beds_utilization_numerator, percent_of_inpatients_with_covid_coverage, inpatient_bed_covid_utilization_coverage, adult_icu_bed_covid_utilization_denominator, adult_icu_bed_utilization_coverage, previous_day_admission_adult_covid_confirmed_18-19, previous_day_admission_adult_covid_confirmed_60-69_coverage, previous_day_admission_adult_covid_suspected_18-19, previous_day_admission_adult_covid_suspected_20-29_coverage, previous_day_admission_adult_covid_suspected_30-39, previous_day_admission_adult_covid_suspected_70-79_coverage, deaths_covid, on_hand_supply_therapeutic_b_bamlanivimab_courses, previous_week_therapeutic_a_casirivimab_imdevimab_courses_used, previous_week_therapeutic_c_bamlanivimab_etesevimab_courses_used, previous_day_deaths_covid_and_influenza, previous_day_deaths_influenza_coverage, total_patients_hospitalized_confirmed_influenza_and_covid_coverage, all_pediatric_inpatient_bed_occupied, all_pediatric_inpatient_beds, previous_day_admission_pediatric_covid_confirmed_5_11, previous_day_admission_pediatric_covid_confirmed_unknown, staffed_icu_pediatric_patients_confirmed_covid, staffed_icu_pediatric_patients_confirmed_covid_coverage, staffed_pediatric_icu_bed_occupancy, staffed_pediatric_icu_bed_occupancy_coverage, total_staffed_pediatric_icu_beds, total_staffed_pediatric_icu_beds_coverage

previous_day_deaths_influenza ✖

Link rowid state date critical_staffing_shortage_today_yes critical_staffing_shortage_today_no critical_staffing_shortage_today_not_reported critical_staffing_shortage_anticipated_within_week_yes critical_staffing_shortage_anticipated_within_week_no critical_staffing_shortage_anticipated_within_week_not_reported hospital_onset_covid hospital_onset_covid_coverage inpatient_beds inpatient_beds_coverage inpatient_beds_used inpatient_beds_used_coverage inpatient_beds_used_covid inpatient_beds_used_covid_coverage previous_day_admission_adult_covid_confirmed previous_day_admission_adult_covid_confirmed_coverage previous_day_admission_adult_covid_suspected previous_day_admission_adult_covid_suspected_coverage previous_day_admission_pediatric_covid_confirmed previous_day_admission_pediatric_covid_confirmed_coverage previous_day_admission_pediatric_covid_suspected previous_day_admission_pediatric_covid_suspected_coverage staffed_adult_icu_bed_occupancy staffed_adult_icu_bed_occupancy_coverage staffed_icu_adult_patients_confirmed_and_suspected_covid staffed_icu_adult_patients_confirmed_and_suspected_covid_coverage staffed_icu_adult_patients_confirmed_covid staffed_icu_adult_patients_confirmed_covid_coverage total_adult_patients_hospitalized_confirmed_and_suspected_covid total_adult_patients_hospitalized_confirmed_and_suspected_covid_coverage total_adult_patients_hospitalized_confirmed_covid total_adult_patients_hospitalized_confirmed_covid_coverage total_pediatric_patients_hospitalized_confirmed_and_suspected_covid total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_coverage total_pediatric_patients_hospitalized_confirmed_covid total_pediatric_patients_hospitalized_confirmed_covid_coverage total_staffed_adult_icu_beds total_staffed_adult_icu_beds_coverage inpatient_beds_utilization inpatient_beds_utilization_coverage inpatient_beds_utilization_numerator inpatient_beds_utilization_denominator percent_of_inpatients_with_covid percent_of_inpatients_with_covid_coverage percent_of_inpatients_with_covid_numerator percent_of_inpatients_with_covid_denominator inpatient_bed_covid_utilization inpatient_bed_covid_utilization_coverage inpatient_bed_covid_utilization_numerator inpatient_bed_covid_utilization_denominator adult_icu_bed_covid_utilization adult_icu_bed_covid_utilization_coverage adult_icu_bed_covid_utilization_numerator adult_icu_bed_covid_utilization_denominator adult_icu_bed_utilization adult_icu_bed_utilization_coverage adult_icu_bed_utilization_numerator adult_icu_bed_utilization_denominator geocoded_state previous_day_admission_adult_covid_confirmed_18-19 previous_day_admission_adult_covid_confirmed_18-19_coverage previous_day_admission_adult_covid_confirmed_20-29 previous_day_admission_adult_covid_confirmed_20-29_coverage previous_day_admission_adult_covid_confirmed_30-39 previous_day_admission_adult_covid_confirmed_30-39_coverage previous_day_admission_adult_covid_confirmed_40-49 previous_day_admission_adult_covid_confirmed_40-49_coverage previous_day_admission_adult_covid_confirmed_50-59 previous_day_admission_adult_covid_confirmed_50-59_coverage previous_day_admission_adult_covid_confirmed_60-69 previous_day_admission_adult_covid_confirmed_60-69_coverage previous_day_admission_adult_covid_confirmed_70-79 previous_day_admission_adult_covid_confirmed_70-79_coverage previous_day_admission_adult_covid_confirmed_80+ previous_day_admission_adult_covid_confirmed_80+_coverage previous_day_admission_adult_covid_confirmed_unknown previous_day_admission_adult_covid_confirmed_unknown_coverage previous_day_admission_adult_covid_suspected_18-19 previous_day_admission_adult_covid_suspected_18-19_coverage previous_day_admission_adult_covid_suspected_20-29 previous_day_admission_adult_covid_suspected_20-29_coverage ▼ previous_day_admission_adult_covid_suspected_30-39 previous_day_admission_adult_covid_suspected_30-39_coverage previous_day_admission_adult_covid_suspected_40-49 previous_day_admission_adult_covid_suspected_40-49_coverage previous_day_admission_adult_covid_suspected_50-59 previous_day_admission_adult_covid_suspected_50-59_coverage previous_day_admission_adult_covid_suspected_60-69 previous_day_admission_adult_covid_suspected_60-69_coverage previous_day_admission_adult_covid_suspected_70-79 previous_day_admission_adult_covid_suspected_70-79_coverage previous_day_admission_adult_covid_suspected_80+ previous_day_admission_adult_covid_suspected_80+_coverage previous_day_admission_adult_covid_suspected_unknown previous_day_admission_adult_covid_suspected_unknown_coverage deaths_covid deaths_covid_coverage on_hand_supply_therapeutic_a_casirivimab_imdevimab_courses on_hand_supply_therapeutic_b_bamlanivimab_courses on_hand_supply_therapeutic_c_bamlanivimab_etesevimab_courses previous_week_therapeutic_a_casirivimab_imdevimab_courses_used previous_week_therapeutic_b_bamlanivimab_courses_used previous_week_therapeutic_c_bamlanivimab_etesevimab_courses_used icu_patients_confirmed_influenza icu_patients_confirmed_influenza_coverage previous_day_admission_influenza_confirmed previous_day_admission_influenza_confirmed_coverage previous_day_deaths_covid_and_influenza previous_day_deaths_covid_and_influenza_coverage previous_day_deaths_influenza previous_day_deaths_influenza_coverage total_patients_hospitalized_confirmed_influenza total_patients_hospitalized_confirmed_influenza_and_covid total_patients_hospitalized_confirmed_influenza_and_covid_coverage total_patients_hospitalized_confirmed_influenza_coverage all_pediatric_inpatient_bed_occupied all_pediatric_inpatient_bed_occupied_coverage all_pediatric_inpatient_beds all_pediatric_inpatient_beds_coverage previous_day_admission_pediatric_covid_confirmed_0_4 previous_day_admission_pediatric_covid_confirmed_0_4_coverage previous_day_admission_pediatric_covid_confirmed_12_17 previous_day_admission_pediatric_covid_confirmed_12_17_coverage previous_day_admission_pediatric_covid_confirmed_5_11 previous_day_admission_pediatric_covid_confirmed_5_11_coverage previous_day_admission_pediatric_covid_confirmed_unknown previous_day_admission_pediatric_covid_confirmed_unknown_coverage staffed_icu_pediatric_patients_confirmed_covid staffed_icu_pediatric_patients_confirmed_covid_coverage staffed_pediatric_icu_bed_occupancy staffed_pediatric_icu_bed_occupancy_coverage total_staffed_pediatric_icu_beds total_staffed_pediatric_icu_beds_coverage
32283 32283 MD 2022/09/02 6 30 18 10 27 17 23 53 11066 54 9257 54 690 53 79 54 160 53 2 53 9 52 866 54 77 53 51 54 662 53 502 54 28 53 11 53 1258 54 0.836526296764865 54 9257 11066 0.074894171279713 53 690 9213 0.062875888463641 53 690 10974 0.062908496732026 53 77 1224 0.688394276629571 54 866 1258   0 53 5 49 4 48 8 48 10 48 10 48 21 48 21 48 0 54 2 50 16 47 21 46 10 47 26 46 30 47 26 47 29 47 0 53 4 25 1551 365 1060 0 0 0 2 53 0 53 0 17 5 18 5 0 18 53 403 53 638 53 2 52 0 46 0 47 0 46 2 52 17 53 19 53
27130 27130 MD 2022/12/01 12 19 19 14 18 18 12 49 10524 50 9031 50 796 49 85 50 236 49 0 49 15 49 981 50 72 49 45 50 756 49 511 50 40 49 8 49 1317 50 0.858133789433675 50 9031 10524 0.088859120339361 49 796 8958 0.076332949750671 49 796 10428 0.056293979671618 49 72 1279 0.744874715261959 50 981 1317   0 49 8 49 7 49 2 49 8 49 16 50 23 49 21 49 0 50 2 49 18 48 18 48 13 48 31 48 55 48 53 48 46 48 0 49 3 28 534 365 646 0 0 0 35 49 58 49 0 20 5 21 219 5 21 49 375 49 544 49 0 49 0 47 0 47 0 42 1 49 20 49 21 49
28120 28120 MD 2022/08/16 8 27 18 10 26 17 27 52 10435 53 8529 53 800 52 75 53 153 52 3 52 7 52 845 53 76 52 58 53 769 52 602 53 31 52 20 52 1268 53 0.817345471969334 53 8529 10435 0.094551471457275 52 800 8461 0.07735447689035 52 800 10342 0.061788617886179 52 76 1230 0.666403785488959 53 845 1268   2 51 4 49 14 50 5 49 3 50 11 49 23 50 12 49 1 53 4 51 16 48 22 48 9 48 23 49 25 49 24 48 30 48 0 52 2 27 1495 365 971 0 0 0 1 52 1 52 0 18 5 19 6 0 19 52 324 52 527 52 2 52 0 48 1 48 0 45 4 52 18 52 19 52
15156 15156 MD 2023/01/22 12 11 28 14 26 11 15 50 10834 51 8567 51 969 50 66 51 133 51 2 50 11 50 896 51 112 50 78 51 943 50 626 51 26 50 6 50 1237 51 0.790751338379177 51 8567 10834 0.114 50 969 8500 0.090139534883721 50 969 10750 0.093100581878637 50 112 1203 0.724333063864188 51 896 1237   1 51 2 50 2 50 3 50 7 50 12 50 19 50 20 50 0 51 0 51 10 49 7 50 11 50 16 50 32 50 26 50 31 50 0 51 3 27 418 365 585 0 0 0 4 51 6 51 0 27 5 27 26 0 27 51 298 50 543 50 1 50 0 49 1 49 0 50 2 50 14 50 21 50
21039 21039 MD 2023/02/04 12 11 27 14 25 11 14 49 10574 50 8331 50 694 49 53 50 124 50 1 49 11 49 854 50 86 49 56 50 665 49 460 50 29 49 12 49 1212 50 0.787875922073009 50 8331 10574 0.083806303586523 49 694 8281 0.066177171736436 49 694 10487 0.07312925170068 49 86 1176 0.704620462046205 50 854 1212   0 49 3 49 7 49 4 50 5 49 11 50 14 49 9 49 0 50 1 50 8 49 15 49 8 49 6 49 37 49 28 49 21 49 0 50 7 27 418 365 365 0 0 0 0 50 10 50 0 27 5 27 23 0 27 50 318 49 493 49 0 49 1 48 0 48 0 49 2 49 16 49 19 49
29773 29773 MD 2022/11/17 12 20 19 14 19 18 17 50 10538 51 8806 51 651 50 57 51 184 50 0 50 13 50 938 51 68 50 40 51 614 50 386 51 37 50 9 50 1293 51 0.835642436895046 51 8806 10538 0.074519230769231 50 651 8736 0.062332439678284 50 651 10444 0.054097056483691 50 68 1257 0.725444702242846 51 938 1293   0 51 3 50 2 50 1 50 6 50 11 50 16 50 18 49 0 51 0 50 12 49 20 49 14 49 21 49 45 49 34 49 38 48 0 50 2 27 462 365 646 0 0 0 17 50 37 50 0 20 5 20 119 2 20 50 388 50 546 50 0 50 0 48 0 48 0 43 1 50 20 50 20 50
32962 32962 MD 2022/11/15 12 19 20 14 19 18 17 50 10529 51 8736 51 679 50 67 51 140 50 2 50 14 50 918 51 65 50 39 51 603 50 426 51 45 50 15 50 1278 51 0.82970842435179 51 8736 10529 0.078316032295271 50 679 8670 0.065069477719214 50 679 10435 0.052334943639291 50 65 1242 0.71830985915493 51 918 1278   0 51 3 50 4 50 8 50 9 50 13 50 15 50 15 50 0 51 0 50 15 49 18 49 15 49 15 49 29 49 27 49 21 49 0 50 6 28 534 365 646 0 0 0 15 50 29 50 0 20 5 21 122 0 21 50 403 50 557 50 0 50 1 48 1 48 0 43 0 50 22 50 23 50
34904 34904 MD 2022/11/05 12 19 20 14 19 18 13 50 10418 51 8483 51 687 50 66 51 159 50 1 50 16 50 883 51 54 50 28 51 644 50 423 51 43 50 12 50 1276 51 0.814263774236898 51 8483 10418 0.081649631566437 50 687 8414 0.066537530266344 50 687 10325 0.043513295729251 50 54 1241 0.692006269592476 51 883 1276   0 51 8 50 4 50 4 50 11 50 16 50 9 50 14 50 0 51 1 50 10 49 22 49 10 49 24 49 26 49 32 49 34 49 0 50 1 28 534 365 613 0 0 0 14 50 23 50 0 20 5 21 103 1 21 50 409 50 544 50 0 50 1 48 0 48 0 43 2 50 21 50 22 50
15528 15528 MD 2023/02/01 12 11 28 14 26 11 16 50 10290 51 8684 51 760 50 68 51 158 51 2 50 10 50 921 51 87 50 66 51 724 50 502 51 36 50 12 50 1252 51 0.843926141885326 51 8684 10290 0.088218224027858 50 760 8615 0.074480595844767 50 760 10204 0.071487263763352 50 87 1217 0.735623003194888 51 921 1252   1 51 3 50 0 50 3 50 6 50 18 50 17 50 20 50 0 51 3 51 8 50 13 50 11 50 21 50 35 50 32 50 35 50 0 51 3 27 420 365 365 0 0 0 1 51 8 51 0 27 5 27 28 1 27 51 341 50 536 50 1 50 1 49 0 49 0 50 0 50 14 50 22 50
20918 20918 MD 2023/01/31 12 11 28 14 26 11 17 50 10289 51 8640 51 756 50 76 51 169 51 1 50 7 50 904 51 100 50 77 51 725 50 517 51 31 50 11 50 1254 51 0.839731752356886 51 8640 10289 0.088224997082507 50 756 8569 0.074081332680059 50 756 10205 0.081967213114754 50 100 1220 0.720893141945774 51 904 1254   3 51 6 50 3 50 6 50 9 50 13 50 18 50 18 50 0 51 1 51 13 50 18 50 16 50 24 50 27 50 37 50 33 50 0 51 4 27 418 365 585 0 0 0 1 51 6 51 0 27 5 27 24 1 27 51 323 50 532 50 0 50 0 49 1 49 0 50 0 50 13 50 18 50
21442 21442 MD 2023/02/18 12 11 28 14 26 11 6 50 10597 51 8457 51 639 50 57 51 129 51 1 50 5 50 865 51 76 50 42 51 611 50 417 51 28 50 12 50 1217 51 0.798056053600076 51 8457 10597 0.076198425948009 50 639 8386 0.060805024264916 50 639 10509 0.064461407972858 50 76 1179 0.71076417419885 51 865 1217   0 51 1 50 3 50 2 50 5 50 15 50 12 50 19 50 0 51 1 51 6 50 9 50 12 50 19 50 26 50 31 50 25 50 0 51 1 27 418 365 365 0 0 0 2 51 2 51 0 27 5 27 8 0 27 51 334 50 538 50 1 50 0 49 0 49 0 50 3 50 13 50 22 50
22258 22258 MD 2023/01/04 12 11 28 14 26 11 17 50 10526 51 8984 51 1207 50 144 51 236 51 3 50 9 50 957 51 133 50 105 51 1174 50 894 51 33 50 12 50 1280 51 0.853505605168155 51 8984 10526 0.135480974295656 50 1207 8909 0.115701687116564 50 1207 10432 0.106741573033708 50 133 1246 0.74765625 51 957 1280   3 50 11 49 7 49 6 49 12 50 31 49 35 49 39 50 0 51 3 51 20 50 19 50 16 50 35 50 48 49 44 50 51 50 0 51 3 27 420 365 585 0 0 0 17 51 31 51 0 27 5 27 154 1 27 51 302 50 531 50 0 50 2 49 1 48 0 50 0 50 17 50 22 50
23702 23702 MD 2022/12/30 12 11 28 14 26 11 17 50 10621 51 8563 51 1073 50 116 51 202 51 1 50 15 50 909 51 115 50 92 51 1047 50 779 51 26 50 14 50 1232 51 0.806232934751907 51 8563 10621 0.126205598682663 50 1073 8502 0.101870312351657 50 1073 10533 0.09567387687188 50 115 1202 0.737824675324675 51 909 1232   2 51 5 50 9 50 7 50 6 50 19 50 26 50 42 50 0 51 2 51 10 50 20 50 18 50 22 50 33 50 46 50 51 50 0 51 5 27 418 365 585 0 0 0 14 51 39 51 0 27 5 27 141 4 27 51 302 50 530 50 0 50 1 49 0 49 0 50 2 50 16 50 17 50
23841 23841 MD 2023/01/10 12 11 28 14 26 11 21 50 10595 51 8984 51 1083 50 105 51 267 51 1 50 12 50 963 51 124 50 90 51 1050 50 786 51 33 50 13 50 1283 51 0.84794714487966 51 8984 10595 0.121398946306468 50 1083 8921 0.103015314372681 50 1083 10513 0.099279423538831 50 124 1249 0.750584567420109 51 963 1283   1 50 6 50 7 50 9 51 12 50 15 50 27 50 28 50 0 51 4 51 21 50 17 50 13 50 44 50 61 50 59 49 48 50 0 51 3 27 418 365 585 0 0 0 12 51 15 51 1 27 5 27 83 0 27 51 309 50 529 50 0 50 0 49 1 49 0 50 0 50 18 50 21 50
28913 28913 MD 2022/10/29 12 22 20 15 21 18 25 53 10969 54 9017 54 685 53 57 54 136 53 0 53 18 53 858 54 75 53 48 54 636 53 418 54 49 53 11 53 1268 54 0.822043942018416 54 9017 10969 0.076476498827732 53 685 8957 0.062982714233174 53 685 10876 0.060827250608273 53 75 1233 0.676656151419558 54 858 1268   0 54 3 53 8 53 3 53 4 53 8 53 17 53 14 53 0 54 0 53 17 52 17 52 6 52 21 52 21 52 21 52 33 52 0 53 2 29 1574 365 1651 3 0 0 3 53 13 53 0 21 5 22 48 0 22 53 515 53 652 53 0 53 0 51 0 51 0 46 3 53 23 53 23 53
30910 30910 MD 2022/10/30 12 22 20 15 21 18 24 53 10954 54 8821 54 681 53 44 54 116 53 0 53 16 53 842 54 76 53 53 54 635 53 430 54 46 53 9 53 1254 54 0.805276611283549 54 8821 10954 0.07774860143852 53 681 8759 0.062689864678266 53 681 10863 0.062295081967213 53 76 1220 0.671451355661882 54 842 1254   0 54 0 53 1 53 4 53 3 53 9 53 13 53 14 53 0 54 0 53 8 52 14 52 6 52 15 52 23 52 28 52 22 52 0 53 1 29 1574 365 1651 3 0 0 2 53 13 53 1 21 5 22 56 0 22 53 504 53 642 53 0 53 0 51 0 51 0 46 2 53 22 53 21 53
57858 57858 OR 2021/05/30 3 54 7 3 54 7 13 62 7076 64 4938 64 306 62 20 64 38 62 0 62 4 62 506 64 73 62 59 64 296 62 252 64 10 62 4 62 907 64 0.697851893725269 64 4938 7076 0.063053781166289 62 306 4853 0.044322132097335 62 306 6904 0.082672706681767 62 73 883 0.557883131201764 64 506 907   0 64 2 63 1 63 0 63 4 63 5 63 6 62 2 62 0 64 0 62 2 60 3 60 2 60 5 60 9 60 9 60 8 60 0 62 4 62 105 120 89 7 273 281 0 62 0 62 0 62 5 62 0 0 62 62 301 50 462 50   0   0   0   0   0 75 50 123 50
32443 32443 NJ 2022/11/28 7 59 10 7 59 10 14 75 21224 76 14743 76 1164 75 173 76 72 75 9 75 8 75 1202 76 118 75 110 76 1130 75 1085 76 34 75 11 75 2828 76 0.694638145495665 76 14743 21224 0.078952723326324 75 1164 14743 0.05484357331323 75 1164 21224 0.041725601131542 75 118 2828 0.425035360678925 76 1202 2828   1 76 10 76 15 76 9 76 10 76 32 76 33 76 61 76 2 76 1 75 5 75 5 75 5 75 15 75 14 75 16 75 11 75 0 75 8 74 1376 256 1257 1 0 0 69 75 128 75 1 68 5 74 506 18 74 75 550 75 792 75 2 75 0 75 1 75 6 75 5 75 114 75 130 75
22233 22233 NJ 2022/12/08 8 70 11 9 71 9 22 88 23947 89 17044 89 1353 88 178 89 74 88 11 88 7 88 1298 89 112 88 108 89 1317 88 1263 89 36 88 8 88 2825 89 0.711738422349355 89 17044 23947 0.079382773996714 88 1353 17044 0.056499770326137 88 1353 23947 0.039646017699115 88 112 2825 0.459469026548673 89 1298 2825   3 89 5 89 11 89 8 89 23 89 40 89 34 89 53 89 2 89 0 88 5 88 4 88 4 88 15 88 13 88 20 88 12 88 1 88 10 86 1141 209 994 0 0 0 84 88 110 88 1 80 5 86 579 28 86 88 578 88 867 88 5 88 0 88 1 88 5 88 4 88 107 88 137 88
29031 29031 NJ 2022/12/04 6 77 10 9 75 9 10 92 23987 93 16809 93 1305 92 171 93 69 92 10 92 6 92 1252 93 124 92 112 93 1263 92 1190 93 42 92 15 92 2826 93 0.700754575395006 93 16809 23987 0.077636980189184 92 1305 16809 0.054404469087422 92 1305 23987 0.043878273177636 92 124 2826 0.443029016277424 93 1252 2826   2 92 3 92 11 92 10 93 17 92 26 92 35 92 65 92 2 93 2 91 0 91 9 92 5 91 13 91 11 91 18 91 11 91 0 92 17 90 1165 209 1166 0 0 0 98 92 117 92 0 84 5 90 552 25 90 92 603 92 880 92 5 92 1 91 2 91 2 92 5 92 113 92 136 92
28043 28043 MO 2022/12/12 1 76 41 28 62 28 27 114 14605 118 12177 118 997 114 106 118 157 114 0 114 16 114 1402 118 146 114 109 118 958 114 800 118 39 114 23 114 1771 118 0.8337555631633 118 12177 14605 0.083242882190866 114 997 11977 0.069443477049523 114 997 14357 0.085781433607521 114 146 1702 0.791643139469226 118 1402 1771   0 114 2 102 11 101 4 101 12 103 12 101 30 104 35 104 0 118 4 113 9 98 14 98 12 97 20 97 39 98 26 97 33 97 0 114 6 51 438 0 316 0 0 0 123 114 116 114 0 46 5 46 636 12 46 114 760 114 962 114 0 114 0 96 0 97 0 114 8 114 183 114 220 114
40740 40740 KY 2022/01/23 34 79 4 50 63 4 91 115 11519 117 8960 117 2594 115 264 117 102 115 6 115 10 114 1242 117 452 115 454 117 2515 115 2335 117 79 115 44 115 1421 117 0.7778452990711 117 8960 11519 0.294037633189753 115 2594 8822 0.228767968956698 115 2594 11339 0.329206117989803 115 452 1373 0.874032371569317 117 1242 1421   2 115 20 115 27 115 30 114 63 114 77 114 79 114 68 114 211 117 3 113 11 113 11 113 13 112 18 112 21 112 22 112 17 112 2 115 29 108 44 0 0 0 0 0 5 115 3 115 2 108 5 64 28 4 108 115 354 110 627 109 2 109 1 109 3 109 0 112 4 108 31 109 63 109
54641 54641 OK 2021/07/06 31 93 11 32 92 11 7 133 9491 135 6149 135 277 133 50 135 51 133 0 133 7 133 713 135 73 133 64 135 251 133 209 135 26 133 24 133 994 135 0.647876936044674 135 6149 9491 0.04592175066313 133 277 6032 0.02970827970828 133 277 9324 0.076680672268908 133 73 952 0.717303822937626 135 713 994   0 135 2 132 5 132 8 132 12 132 8 132 11 132 3 132 1 135 0 133 8 130 6 130 3 130 6 130 11 130 10 130 7 130 0 133 1 133 1977 2806 1432 24 11 22 1 123 1 123 0 123 5 123 6 28 123 123 534 71 770 71   0   0   0   0   0 290 71 379 71
34439 34439 IN 2022/12/09 11 123 3 11 109 17 1 135 15590 137 11904 137 683 135 121 137 37 135 2 135 12 134 1563 137 106 135 98 137 667 135 605 137 16 135 11 135 2086 137 0.763566388710712 137 11904 15590 0.057856840321898 135 683 11805 0.044184241169621 135 683 15458 0.051732552464617 135 106 2049 0.74928092042186 137 1563 2086   1 135 3 133 5 133 5 133 11 133 24 133 33 133 34 134 7 137 0 133 0 131 2 131 3 131 7 131 9 131 8 131 8 132 0 135 8 120 27 0 0 0 0 0 81 135 124 135 0 118 5 118 550 20 118 135 498 134 841 134 0 134 0 131 1 131 0 135 5 134 108 134 190 134
36375 36375 IN 2021/12/09 25 139 4 23 142 3 2 166 19179 168 13740 168 2790 166 376 168 133 166 6 166 5 166 1819 168 696 166 667 168 2747 166 2559 168 43 166 26 166 2274 168 0.716408571875489 168 13740 19179 0.204710543693595 166 2790 13629 0.146572104018913 166 2790 19035 0.31266846361186 166 696 2226 0.799912049252419 168 1819 2274   1 167 20 168 26 168 39 168 78 168 80 168 85 168 44 168 3 168 1 166 8 166 7 166 7 166 24 166 30 166 21 166 16 166 19 166 29 166 2860 1076 3846 1797 99 1509 3 164 6 164 0 164 5 164 24 3 165 164 365 48 576 48   0   0   0   0   0 12 48 19 48
29462 29462 FL 2023/01/06 5 53 157 33 110 72 100 209 56407 215 46759 215 3182 209 526 215 211 215 12 209 22 209 5332 215 355 209 335 215 3120 209 2859 215 62 209 49 209 6576 215 0.828957398904391 215 46759 56407 0.068896827974451 209 3182 46185 0.057101839389861 209 3182 55725 0.055038759689922 209 355 6450 0.810827250608272 215 5332 6576   0 210 20 209 26 209 19 210 38 210 84 209 136 211 182 212 22 215 2 213 8 209 15 209 23 209 29 209 39 208 49 210 45 210 2 215 16 99 733 0 230 0 40 270 85 215 146 215 1 107 5 107 788 60 107 215 1864 209 2638 209 10 209 0 202 1 203 1 207 9 209 699 209 1009 209
24049 24049 FL 2023/01/05 5 53 157 33 110 72 105 209 55956 215 46293 215 3174 209 506 215 237 215 15 209 31 209 5250 215 344 209 321 215 3900 209 2834 215 75 209 59 209 6545 215 0.827310744156123 215 46293 55956 0.06945295404814 209 3174 45700 0.057416787264834 209 3174 55280 0.053590902009659 209 344 6419 0.802139037433155 215 5250 6545   1 209 26 209 14 209 32 210 48 209 89 211 115 211 158 210 24 215 1 213 10 210 13 209 18 209 25 209 50 207 57 208 61 210 3 215 23 99 813 0 230 0 40 270 79 215 174 215 0 107 5 107 792 28 108 215 1866 209 2625 209 9 208 3 203 2 203 1 207 10 209 679 209 1008 209
32041 32041 FL 2022/06/21 6 158 75 33 145 61 125 233 55469 239 43513 239 3646 233 633 239 231 233 29 233 16 233 4728 239 382 233 365 239 3563 233 3307 239 83 233 69 233 6533 239 0.784456182732698 239 43513 55469 0.085133210357952 233 3646 42827 0.066763106333889 233 3646 54611 0.059921568627451 233 382 6375 0.723710393387418 239 4728 6533   1 232 25 228 52 229 31 229 77 231 111 231 145 229 158 232 33 239 0 231 19 222 17 222 23 222 35 224 49 223 36 222 44 223 8 233 26 128 4127 0 2767 1184 0 233 27 233 44 233 0 122 5 122 224 17 125 233 1750 233 2618 233 13 233 7 223 7 223 2 231 17 233 672 233 918 233
34331 34331 CA 2022/12/08 6 95 272 98 218 57 84 365 63595 373 52316 373 5068 365 704 373 373 365 20 364 13 363 5335 373 540 365 495 373 4899 365 4343 373 145 365 120 365 6817 373 0.82264328956679 373 52316 63595 0.098140975987606 365 5068 51640 0.080630021478005 365 5068 62855 0.081251880830575 365 540 6646 0.782602317735074 373 5335 6817   4 369 27 362 53 362 43 362 59 362 142 363 156 362 191 363 2 372 4 362 24 354 28 354 25 355 41 355 78 355 87 354 86 354 0 351 7 75 729 165 13 0 0 0 237 364 246 363 0 48 5 297 1739 107 298 364 2787 364 3922 365 9 364 6 132 5 355 0 363 30 364 803 364 1217 364

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE hospitals_state (
  "state" TEXT,
  "date" TEXT,
  "critical_staffing_shortage_today_yes" INTEGER,
  "critical_staffing_shortage_today_no" INTEGER,
  "critical_staffing_shortage_today_not_reported" INTEGER,
  "critical_staffing_shortage_anticipated_within_week_yes" INTEGER,
  "critical_staffing_shortage_anticipated_within_week_no" INTEGER,
  "critical_staffing_shortage_anticipated_within_week_not_reported" INTEGER,
  "hospital_onset_covid" INTEGER,
  "hospital_onset_covid_coverage" INTEGER,
  "inpatient_beds" INTEGER,
  "inpatient_beds_coverage" INTEGER,
  "inpatient_beds_used" INTEGER,
  "inpatient_beds_used_coverage" INTEGER,
  "inpatient_beds_used_covid" INTEGER,
  "inpatient_beds_used_covid_coverage" INTEGER,
  "previous_day_admission_adult_covid_confirmed" INTEGER,
  "previous_day_admission_adult_covid_confirmed_coverage" INTEGER,
  "previous_day_admission_adult_covid_suspected" INTEGER,
  "previous_day_admission_adult_covid_suspected_coverage" INTEGER,
  "previous_day_admission_pediatric_covid_confirmed" INTEGER,
  "previous_day_admission_pediatric_covid_confirmed_coverage" INTEGER,
  "previous_day_admission_pediatric_covid_suspected" INTEGER,
  "previous_day_admission_pediatric_covid_suspected_coverage" INTEGER,
  "staffed_adult_icu_bed_occupancy" INTEGER,
  "staffed_adult_icu_bed_occupancy_coverage" INTEGER,
  "staffed_icu_adult_patients_confirmed_and_suspected_covid" INTEGER,
  "staffed_icu_adult_patients_confirmed_and_suspected_covid_coverage" INTEGER,
  "staffed_icu_adult_patients_confirmed_covid" INTEGER,
  "staffed_icu_adult_patients_confirmed_covid_coverage" INTEGER,
  "total_adult_patients_hospitalized_confirmed_and_suspected_covid" INTEGER,
  "total_adult_patients_hospitalized_confirmed_and_suspected_covid_coverage" INTEGER,
  "total_adult_patients_hospitalized_confirmed_covid" INTEGER,
  "total_adult_patients_hospitalized_confirmed_covid_coverage" INTEGER,
  "total_pediatric_patients_hospitalized_confirmed_and_suspected_covid" INTEGER,
  "total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_coverage" INTEGER,
  "total_pediatric_patients_hospitalized_confirmed_covid" INTEGER,
  "total_pediatric_patients_hospitalized_confirmed_covid_coverage" INTEGER,
  "total_staffed_adult_icu_beds" INTEGER,
  "total_staffed_adult_icu_beds_coverage" INTEGER,
  "inpatient_beds_utilization" INTEGER,
  "inpatient_beds_utilization_coverage" INTEGER,
  "inpatient_beds_utilization_numerator" INTEGER,
  "inpatient_beds_utilization_denominator" INTEGER,
  "percent_of_inpatients_with_covid" INTEGER,
  "percent_of_inpatients_with_covid_coverage" INTEGER,
  "percent_of_inpatients_with_covid_numerator" INTEGER,
  "percent_of_inpatients_with_covid_denominator" INTEGER,
  "inpatient_bed_covid_utilization" INTEGER,
  "inpatient_bed_covid_utilization_coverage" INTEGER,
  "inpatient_bed_covid_utilization_numerator" INTEGER,
  "inpatient_bed_covid_utilization_denominator" INTEGER,
  "adult_icu_bed_covid_utilization" INTEGER,
  "adult_icu_bed_covid_utilization_coverage" INTEGER,
  "adult_icu_bed_covid_utilization_numerator" INTEGER,
  "adult_icu_bed_covid_utilization_denominator" INTEGER,
  "adult_icu_bed_utilization" INTEGER,
  "adult_icu_bed_utilization_coverage" INTEGER,
  "adult_icu_bed_utilization_numerator" INTEGER,
  "adult_icu_bed_utilization_denominator" INTEGER,
  "geocoded_state" INTEGER,
  "previous_day_admission_adult_covid_confirmed_18-19" INTEGER,
  "previous_day_admission_adult_covid_confirmed_18-19_coverage" INTEGER,
  "previous_day_admission_adult_covid_confirmed_20-29" INTEGER,
  "previous_day_admission_adult_covid_confirmed_20-29_coverage" INTEGER,
  "previous_day_admission_adult_covid_confirmed_30-39" INTEGER,
  "previous_day_admission_adult_covid_confirmed_30-39_coverage" INTEGER,
  "previous_day_admission_adult_covid_confirmed_40-49" INTEGER,
  "previous_day_admission_adult_covid_confirmed_40-49_coverage" INTEGER,
  "previous_day_admission_adult_covid_confirmed_50-59" INTEGER,
  "previous_day_admission_adult_covid_confirmed_50-59_coverage" INTEGER,
  "previous_day_admission_adult_covid_confirmed_60-69" INTEGER,
  "previous_day_admission_adult_covid_confirmed_60-69_coverage" INTEGER,
  "previous_day_admission_adult_covid_confirmed_70-79" INTEGER,
  "previous_day_admission_adult_covid_confirmed_70-79_coverage" INTEGER,
  "previous_day_admission_adult_covid_confirmed_80+" INTEGER,
  "previous_day_admission_adult_covid_confirmed_80+_coverage" INTEGER,
  "previous_day_admission_adult_covid_confirmed_unknown" INTEGER,
  "previous_day_admission_adult_covid_confirmed_unknown_coverage" INTEGER,
  "previous_day_admission_adult_covid_suspected_18-19" INTEGER,
  "previous_day_admission_adult_covid_suspected_18-19_coverage" INTEGER,
  "previous_day_admission_adult_covid_suspected_20-29" INTEGER,
  "previous_day_admission_adult_covid_suspected_20-29_coverage" INTEGER,
  "previous_day_admission_adult_covid_suspected_30-39" INTEGER,
  "previous_day_admission_adult_covid_suspected_30-39_coverage" INTEGER,
  "previous_day_admission_adult_covid_suspected_40-49" INTEGER,
  "previous_day_admission_adult_covid_suspected_40-49_coverage" INTEGER,
  "previous_day_admission_adult_covid_suspected_50-59" INTEGER,
  "previous_day_admission_adult_covid_suspected_50-59_coverage" INTEGER,
  "previous_day_admission_adult_covid_suspected_60-69" INTEGER,
  "previous_day_admission_adult_covid_suspected_60-69_coverage" INTEGER,
  "previous_day_admission_adult_covid_suspected_70-79" INTEGER,
  "previous_day_admission_adult_covid_suspected_70-79_coverage" INTEGER,
  "previous_day_admission_adult_covid_suspected_80+" INTEGER,
  "previous_day_admission_adult_covid_suspected_80+_coverage" INTEGER,
  "previous_day_admission_adult_covid_suspected_unknown" INTEGER,
  "previous_day_admission_adult_covid_suspected_unknown_coverage" INTEGER,
  "deaths_covid" INTEGER,
  "deaths_covid_coverage" INTEGER,
  "on_hand_supply_therapeutic_a_casirivimab_imdevimab_courses" INTEGER,
  "on_hand_supply_therapeutic_b_bamlanivimab_courses" INTEGER,
  "on_hand_supply_therapeutic_c_bamlanivimab_etesevimab_courses" INTEGER,
  "previous_week_therapeutic_a_casirivimab_imdevimab_courses_used" INTEGER,
  "previous_week_therapeutic_b_bamlanivimab_courses_used" INTEGER,
  "previous_week_therapeutic_c_bamlanivimab_etesevimab_courses_used" INTEGER,
  "icu_patients_confirmed_influenza" INTEGER,
  "icu_patients_confirmed_influenza_coverage" INTEGER,
  "previous_day_admission_influenza_confirmed" INTEGER,
  "previous_day_admission_influenza_confirmed_coverage" INTEGER,
  "previous_day_deaths_covid_and_influenza" INTEGER,
  "previous_day_deaths_covid_and_influenza_coverage" INTEGER,
  "previous_day_deaths_influenza" INTEGER,
  "previous_day_deaths_influenza_coverage" INTEGER,
  "total_patients_hospitalized_confirmed_influenza" INTEGER,
  "total_patients_hospitalized_confirmed_influenza_and_covid" INTEGER,
  "total_patients_hospitalized_confirmed_influenza_and_covid_coverage" INTEGER,
  "total_patients_hospitalized_confirmed_influenza_coverage" INTEGER,
  "all_pediatric_inpatient_bed_occupied" INTEGER,
  "all_pediatric_inpatient_bed_occupied_coverage" INTEGER,
  "all_pediatric_inpatient_beds" INTEGER,
  "all_pediatric_inpatient_beds_coverage" INTEGER,
  "previous_day_admission_pediatric_covid_confirmed_0_4" INTEGER,
  "previous_day_admission_pediatric_covid_confirmed_0_4_coverage" INTEGER,
  "previous_day_admission_pediatric_covid_confirmed_12_17" INTEGER,
  "previous_day_admission_pediatric_covid_confirmed_12_17_coverage" INTEGER,
  "previous_day_admission_pediatric_covid_confirmed_5_11" INTEGER,
  "previous_day_admission_pediatric_covid_confirmed_5_11_coverage" INTEGER,
  "previous_day_admission_pediatric_covid_confirmed_unknown" INTEGER,
  "previous_day_admission_pediatric_covid_confirmed_unknown_coverage" INTEGER,
  "staffed_icu_pediatric_patients_confirmed_covid" INTEGER,
  "staffed_icu_pediatric_patients_confirmed_covid_coverage" INTEGER,
  "staffed_pediatric_icu_bed_occupancy" INTEGER,
  "staffed_pediatric_icu_bed_occupancy_coverage" INTEGER,
  "total_staffed_pediatric_icu_beds" INTEGER,
  "total_staffed_pediatric_icu_beds_coverage" INTEGER
);
Powered by Datasette · Queries took 8581.869ms · Data source: U.S. Department of Health & Human Services