hospitals_state

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

37 rows where previous_day_deaths_influenza = 9 sorted by hospital_onset_covid_coverage

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: critical_staffing_shortage_anticipated_within_week_not_reported, hospital_onset_covid_coverage, previous_day_admission_adult_covid_confirmed_coverage, previous_day_admission_adult_covid_suspected_coverage, total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_coverage, previous_day_admission_adult_covid_confirmed_18-19_coverage, previous_day_admission_adult_covid_suspected_18-19, previous_day_admission_adult_covid_suspected_20-29, previous_day_admission_adult_covid_suspected_40-49, previous_day_admission_adult_covid_suspected_50-59_coverage, previous_day_admission_adult_covid_suspected_70-79, previous_day_admission_adult_covid_suspected_80+, deaths_covid_coverage, on_hand_supply_therapeutic_c_bamlanivimab_etesevimab_courses, icu_patients_confirmed_influenza_coverage, previous_day_deaths_covid_and_influenza, all_pediatric_inpatient_bed_occupied_coverage, 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_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
39065 39065 WY 2022/01/19 3 23 5 9 20 2 26 29 1743 31 843 31 132 29 18 31 6 29 2 29 0 29 47 31 18 29 18 31 113 29 114 31 19 29 4 29 137 31 0.483648881239243 31 843 1743 0.159420289855072 29 132 828 0.077373974208675 29 132 1706 0.137404580152672 29 18 131 0.343065693430657 31 47 137   1 31 1 31 1 31 2 31 4 31 4 31 5 31 0 31 0 31 0 29 0 29 0 29 0 29 3 29 0 29 1 29 2 29 0 29 0 27 754 0 897 50 0 23 1 26 2 26 0 23 9 23 6 10 23 26 4 6 0 6 0 8 0 7 0 7 2 22 0 6 0 5 0 6
42663 42663 SC 2022/02/08 21 50 5 23 48 5 22 74 10933 76 8798 76 1787 74 208 76 30 74 4 74 1 74 1065 76 361 74 358 76 1762 74 1713 76 25 74 22 74 1342 76 0.804719656087076 76 8798 10933 0.205473151661492 74 1787 8697 0.165939270127217 74 1787 10769 0.277478862413528 74 361 1301 0.793591654247392 76 1065 1342   0 73 14 72 9 72 10 72 30 72 39 75 50 73 42 74 2 71 0 74 1 70 1 70 2 70 7 70 5 70 10 70 4 70 0 69 36 55 1436 1595 1585 4 0 4 1 74 2 74 0 49 9 49 31 9 49 74 303 74 449 74 1 74 1 70 0 70 2 69 6 74 56 74 97 74
22944 22944 AR 2022/09/22 1 78 13 17 73 2 7 90 7601 92 5589 92 276 90 29 92 59 90 3 90 10 90 658 92 47 90 34 92 265 90 212 92 11 90 9 90 891 92 0.73529798710696 92 5589 7601 0.04951560818084 90 276 5574 0.036532097948379 90 276 7555 0.053775743707094 90 47 874 0.738496071829405 92 658 891   0 91 1 82 1 83 2 82 2 82 4 82 10 82 10 82 1 92 2 90 5 79 4 79 7 79 6 79 14 79 10 79 11 79 0 90 0 35 246 82 434 5 0 0 1 90 0 90 0 32 9 32 4 12 32 90 332 90 469 90 2 89 0 80 1 79 0 90 1 90 54 90 87 90
6803 6803 AR 2021/01/30 16 94 2 20 90 2 17 110 9360 112 6317 112 1015 110 106 112 208 110 2 110 17 110 788 112 265 110 239 112 997 110 851 112 18 110 6 110 1065 112 0.674893162393162 112 6317 9360 0.161034428050135 110 1015 6303 0.108917265801052 110 1015 9319 0.252862595419847 110 265 1048 0.739906103286385 112 788 1065   0 112 2 112 10 112 5 112 11 112 29 112 27 112 20 112 2 112 2 110 7 110 18 110 16 110 23 110 48 110 55 110 39 110 0 110 12 110 768 2611   96 762   10 110 12 110 0 110 9 110 28 13 110 110 817 110 1623 110   0   0   0   0   0 237 110 407 110
53881 53881 TN 2021/06/06 8 103 32 28 83 32 16 111 20063 143 12758 132 435 111 22 114 48 111 1 111 9 111 1657 142 158 111 136 114 424 111 355 114 11 111 7 111 2405 143 0.654558514186035 132 12758 19491 0.036225849433711 111 435 12008 0.023727704140075 111 435 18333 0.06786941580756 111 158 2328 0.690129112869638 142 1657 2401   0 114 2 114 4 114 2 114 1 114 3 114 3 114 3 114 4 114 1 111 6 111 6 111 5 111 10 111 5 111 5 111 5 111 5 111 17 111 0 0 18 0 0 16 1 110 0 110 0 111 9 111 6 2 110 110 30 15 112 15   0   0   0   0   0 0 15 0 15
32480 32480 LA 2022/12/20 1 34 114 9 124 16 14 146 12691 149 8774 149 317 146 63 149 5 149 1 147 0 147 1077 149 57 146 56 149 311 146 306 149 6 146 6 146 1454 149 0.691356079111181 149 8774 12691 0.036583958453549 146 317 8665 0.025289190267252 146 317 12535 0.039202200825309 146 57 1454 0.740715268225585 149 1077 1454   0 149 1 145 3 146 2 146 8 146 14 146 14 146 22 146 0 148 0 149 0 146 0 146 1 146 0 146 2 144 1 146 1 146 0 148 0 43 1730 10 455 0 0 0 23 149 17 149 9 37 9 37 116 9 37 149 422 147 770 147 1 145 0 142 0 142 0 146 1 146 159 147 254 147
39036 39036 WI 2021/09/30 35 91 24 45 81 24 8 147 13385 150 9950 150 1249 147 204 150 60 147 7 147 77 147 1089 150 339 147 348 150 1224 147 1184 150 25 147 10 147 1561 150 0.743369443406799 150 9950 13385 0.128168291431503 147 1249 9745 0.095161904761905 147 1249 13125 0.225099601593626 147 339 1506 0.697629724535554 150 1089 1561   1 150 6 149 18 148 18 148 23 148 29 148 35 148 26 148 48 150 1 147 2 145 5 145 6 145 8 145 8 145 8 145 10 145 12 147 31 147 3486 2813 1803 958 11 64 1 129 0 129 9 129 9 129 1 0 129 129 300 49 380 49   0   0   0   0   0 88 49 140 49
46833 46833 KS 2022/01/06 32 111 7 37 106 7 13 147 8550 150 5740 150 1069 147 176 150 75 147 1 146 6 146 696 150 253 147 240 150 1056 147 990 150 13 147 10 147 831 150 0.671345029239766 150 5740 8550 0.187972569017056 147 1069 5687 0.126195254397356 147 1069 8471 0.311576354679803 147 253 812 0.837545126353791 150 696 831   1 147 8 144 14 145 19 145 17 144 52 145 37 145 21 146 7 150 0 146 10 141 9 142 8 141 13 141 12 141 17 141 6 141 0 147 20 143 1796 1323 2165 986 80 780 2 141 7 140 0 136 9 136 24 11 135 140 313 145 678 145   0   0   0   0 0 5 96 145 213 145
52591 52591 KS 2021/08/25 18 125 7 24 119 7 4 147 8940 150 5832 150 802 147 118 150 65 147 1 147 4 147 671 150 239 147 233 150 794 147 737 150 8 147 1 147 852 150 0.652348993288591 150 5832 8940 0.138754325259516 147 802 5780 0.090457929167607 147 802 8866 0.287259615384615 147 239 832 0.787558685446009 150 671 852   0 150 7 148 15 148 17 148 17 148 21 148 22 148 16 147 2 150 0 147 3 145 2 145 12 144 11 145 13 145 14 145 9 145 1 147 22 147 2433 1533 1161 456 0 14 0 140 0 140 9 140 9 140 3 1 140 140 353 146 674 146   0   0   0   0   0 102 146 266 146
30921 30921 NY 2022/12/10 2 161 15 4 160 14 676 169 44971 178 36365 178 3772 169 427 178 173 169 12 169 31 169 3412 178 350 169 306 178 3670 169 3332 178 102 169 72 169 4466 178 0.808632229659114 178 36365 44971 0.104519382637369 169 3772 36089 0.084745001123343 169 3772 44510 0.080091533180778 169 350 4370 0.763994626063592 178 3412 4466   2 170 19 158 34 157 23 156 42 155 80 156 95 159 125 158 9 178 1 169 13 146 19 146 7 146 19 146 34 146 37 145 25 145 18 168 18 54 1689 234 911 0 0 91 127 169 239 169 0 32 9 32 922 44 32 169 1815 169 2500 169 3 169 0 146 3 146 6 169 13 169 331 169 490 169
28292 28292 CA 2023/01/02 7 71 281 92 202 65 100 350 60689 358 47350 358 5133 350 641 359 303 359 34 351 18 349 4889 358 546 350 514 358 4957 350 4468 358 176 350 153 350 6631 358 0.780207286328659 358 47350 60689 0.10982028241335 350 5133 46740 0.085629921259843 350 5133 59944 0.084363411619283 350 546 6472 0.737294525712562 358 4889 6631   4 358 41 357 43 356 50 356 58 356 102 355 140 355 201 356 12 359 4 358 18 356 29 356 25 355 43 355 55 355 68 355 61 355 1 346 6 74 770 175 28 0 0 0 146 356 140 356 0 49 9 284 1067 54 284 356 2308 350 3393 350 18 350 10 348 6 347 0 350 68 350 737 350 1014 350
32202 32202 CA 2023/01/01 7 71 281 86 206 67 92 350 60938 358 47183 358 5072 350 674 359 301 359 25 351 17 350 4831 357 533 350 505 358 4882 350 4437 358 174 350 150 350 6606 357 0.774278775148512 358 47183 60938 0.108887934735938 350 5072 46580 0.084252491694352 350 5072 60200 0.082622849170671 349 533 6451 0.731304874356646 357 4831 6606   4 358 43 357 55 356 32 356 51 356 125 356 153 356 211 356 7 358 2 358 14 356 27 356 22 356 34 355 61 355 68 355 73 355 0 346 8 74 770 175 28 0 0 0 145 345 152 345 0 50 9 277 1003 46 276 344 2307 350 3388 350 14 350 7 349 3 348 1 350 58 350 740 349 1022 349
33701 33701 CA 2022/12/30 7 70 278 98 203 54 274 350 61412 354 49397 354 5133 350 791 355 372 355 32 350 20 350 4961 354 536 350 500 354 4941 350 4423 354 192 350 141 350 6603 354 0.804354197876636 354 49397 61412 0.10470168281489 350 5133 49025 0.084182041820418 350 5133 60975 0.082614056720099 350 536 6488 0.75132515523247 354 4961 6603   11 354 42 352 71 352 41 351 76 352 129 353 173 353 245 352 13 354 6 354 19 352 29 352 24 352 44 352 87 352 72 352 91 352 18 342 11 74 757 175 28 0 0 0 175 353 212 352 0 47 9 292 1179 80 293 353 2479 350 3432 350 21 350 6 348 5 347 1 350 60 350 738 350 1015 350
22895 22895 CA 2022/12/20 9 73 280 89 202 71 169 353 62318 361 50850 361 5113 353 713 362 395 362 29 354 20 354 5249 361 558 353 511 361 4958 353 4444 361 155 353 127 353 6666 361 0.815976122468629 361 50850 62318 0.101840417479982 353 5113 50206 0.083040992659001 353 5113 61572 0.084494245911569 353 558 6604 0.787428742874287 361 5249 6666   7 361 37 359 69 359 49 359 67 359 128 360 129 360 225 359 7 362 4 362 30 359 27 359 40 358 48 359 81 359 86 358 79 358 0 348 7 88 770 175 18 0 0 0 190 360 220 360 0 61 9 292 1285 81 292 359 2668 353 3706 353 22 354 1 350 4 351 2 354 33 353 800 353 1054 353
23818 23818 CA 2022/12/24 7 71 284 91 203 68 80 353 60682 361 47261 361 4831 353 719 362 356 362 18 353 13 353 4935 361 579 353 537 361 4695 353 4217 361 136 353 115 353 6627 361 0.778830625226591 361 47261 60682 0.103487425560173 353 4831 46682 0.080579787500208 353 4831 59953 0.089545313949892 353 579 6466 0.74468085106383 361 4935 6627   5 361 38 359 55 359 41 359 57 359 123 359 141 359 224 359 3 360 3 361 16 359 27 359 24 359 47 359 69 359 87 359 82 359 2 361 8 75 855 175 38 0 0 0 167 359 207 359 0 50 9 289 1164 78 289 359 2383 353 3362 353 12 353 2 351 4 351 0 353 24 353 756 353 1009 353
13088 13088 CA 2023/01/16 6 69 288 91 205 67 90 354 60787 362 47693 362 3943 353 458 363 290 363 6 355 8 354 4862 362 449 353 405 361 3834 353 3410 361 109 354 83 353 6782 362 0.7845921002846 362 47693 60787 0.083708389945652 353 3943 47104 0.065671790942856 353 3943 60041 0.067886301784094 353 449 6614 0.716897670303745 362 4862 6782   1 362 34 361 38 361 34 361 60 361 70 361 82 361 143 360 8 363 4 363 19 362 29 361 23 361 47 361 51 361 52 361 65 360 0 351 3 73 743 175 28 0 0 0 55 358 36 358 0 47 9 287 363 28 288 358 2250 354 3368 354 5 354 1 352 0 352 0 355 26 353 705 354 1014 354
13162 13162 CA 2023/01/22 6 71 286 90 206 67 75 354 61361 362 48304 362 3202 354 320 363 265 363 14 355 13 354 4873 361 383 354 346 362 3097 354 2647 362 105 354 88 354 6591 361 0.787210117175405 362 48304 61361 0.067127882599581 354 3202 47700 0.052825208281778 354 3202 60615 0.059620174346202 353 383 6424 0.739341526323775 361 4873 6591   0 362 28 361 25 359 19 359 40 359 55 359 59 359 93 359 8 362 5 362 19 360 23 359 20 359 32 359 53 359 48 359 61 359 4 350 2 73 770 175 28 0 0 0 38 360 23 360 0 48 9 290 349 16 289 359 2421 354 3460 354 5 354 4 352 4 351 1 354 19 354 708 353 1016 353
14346 14346 CA 2023/01/30 6 72 285 85 211 67 80 354 62268 362 48892 362 2932 354 335 363 290 363 10 355 44 354 4878 362 302 354 257 362 2834 354 2406 362 98 354 86 354 6720 362 0.785186612706366 362 48892 62268 0.06073662841281 354 2932 48274 0.047654650066638 354 2932 61526 0.046050625190607 354 302 6558 0.725892857142857 362 4878 6720   16 363 21 360 23 360 27 359 39 359 49 359 68 359 91 359 4 363 2 363 23 360 19 359 27 359 32 359 59 359 64 359 61 359 3 351 2 75 767 175 28 0 0 0 28 360 17 360 0 51 9 294 255 14 295 360 2398 354 3409 354 7 355 1 351 2 351 0 355 18 354 703 354 996 354
17521 17521 CA 2023/02/06 9 65 289 88 206 69 88 354 61678 362 49103 362 2999 354 382 363 287 363 13 355 12 354 4943 362 317 354 267 362 3148 354 2457 362 89 354 67 354 6701 362 0.796118551185188 362 49103 61678 0.061824853632391 354 2999 48508 0.049227688317657 354 2999 60921 0.048522883820603 354 317 6533 0.737651096851216 362 4943 6701   3 363 23 361 28 360 19 360 43 360 69 360 82 360 111 360 8 363 1 363 26 361 32 360 22 360 33 360 53 360 52 360 66 359 18 350 7 86 767 175 28 0 0 0 21 360 9 360 0 58 9 293 231 8 294 360 2471 354 3571 354 5 355 4 352 4 353 0 355 13 354 697 354 975 354
19818 19818 CA 2023/01/29 6 72 285 82 212 69 79 354 62148 362 48919 362 2912 354 341 363 290 363 12 355 10 354 5028 361 331 354 288 362 2823 354 2400 362 89 354 76 354 6796 361 0.787137156465212 362 48919 62148 0.060286110593545 354 2912 48303 0.04742439294497 354 2912 61403 0.049932116457988 353 331 6629 0.73984696880518 361 5028 6796   4 362 21 360 27 358 18 358 38 358 62 358 84 358 87 358 3 362 3 362 20 359 26 358 23 358 41 358 60 358 57 358 59 358 1 350 2 75 740 175 28 0 0 0 23 361 12 361 0 50 9 295 253 13 294 360 2397 354 3388 354 9 354 2 350 1 349 0 354 20 354 719 353 998 353
33856 33856 CA 2023/01/09 7 71 285 97 199 67 95 354 62242 362 49549 362 4760 354 525 363 321 363 19 355 15 354 5033 362 519 354 477 362 4630 354 4076 362 130 354 111 354 6740 362 0.796070177693519 362 49549 62242 0.097313652533017 354 4760 48914 0.077412220071883 354 4760 61489 0.07898341196165 354 519 6571 0.74673590504451 362 5033 6740   3 363 31 359 44 360 35 360 51 360 95 360 107 360 155 361 12 363 3 363 21 360 26 360 18 360 32 360 71 360 74 360 76 359 14 350 5 75 770 175 28 0 0 0 97 360 73 360 0 50 9 296 699 46 298 360 2289 354 3390 354 16 355 1 352 2 353 0 355 30 354 726 354 1013 354
16979 16979 CA 2023/02/07 8 66 289 92 208 63 167 355 62672 363 50549 363 2958 355 420 363 338 363 19 355 24 355 5100 363 305 355 261 363 2865 355 2412 363 93 355 72 355 6756 363 0.806564334950217 363 50549 62672 0.059286873910168 355 2958 49893 0.047765917935634 355 2958 61927 0.046289269995447 355 305 6589 0.754884547069272 363 5100 6756   5 362 26 361 47 360 32 360 41 360 69 360 87 360 109 359 7 362 6 362 18 361 25 361 24 361 47 360 63 360 72 360 76 360 19 347 7 72 767 175 18 0 0 0 18 363 13 363 0 46 9 300 227 9 301 363 2511 355 3478 355 12 355 4 353 3 353 1 355 16 355 736 355 1025 355
18821 18821 CA 2023/01/27 6 71 287 93 213 58 74 355 63342 363 50547 363 2987 355 396 364 330 364 18 355 11 355 5136 363 363 355 321 363 2892 355 2461 363 95 355 83 355 6822 363 0.798001326134318 363 50547 63342 0.059886122138017 355 2987 49878 0.047733192706585 355 2987 62577 0.054594675891111 355 363 6649 0.752858399296394 363 5136 6822   1 363 19 360 27 360 30 359 41 359 64 359 71 359 124 359 6 363 3 363 18 359 27 360 34 359 40 359 60 359 78 359 67 359 18 351 4 74 740 175 28 0 0 0 27 363 13 362 0 48 9 298 175 9 298 363 2555 355 3518 355 11 355 2 351 5 351 0 355 18 355 727 355 1008 355
13492 13492 CA 2023/02/05 6 70 289 87 207 71 158 356 62112 364 48908 364 2944 356 371 365 295 365 14 357 12 356 4994 363 306 356 256 364 2857 356 2395 364 87 356 72 356 6768 363 0.787416280267903 364 48908 62112 0.060918327229085 356 2944 48327 0.047980703412758 356 2944 61358 0.04633555420957 355 306 6604 0.737884160756501 363 4994 6768   2 363 24 362 27 361 20 361 35 361 61 362 93 362 108 361 6 364 0 364 15 362 20 361 28 361 44 361 64 361 61 361 62 360 17 351 3 76 716 175 28 0 0 0 20 363 13 363 0 47 9 293 242 10 292 362 2348 356 3345 356 9 355 2 355 3 353 0 356 27 356 713 355 1000 355
13844 13844 CA 2023/02/04 7 71 287 88 210 67 129 356 62590 364 49920 364 2814 356 410 365 292 365 11 357 14 356 5127 364 307 356 262 364 2727 356 2306 364 87 356 71 356 6803 364 0.797571497044256 364 49920 62590 0.056999331564342 356 2814 49369 0.045508207325948 356 2814 61835 0.046248870141609 356 307 6638 0.753638100837866 364 5127 6803   2 364 26 363 35 362 30 361 30 361 74 361 79 361 125 361 6 364 3 364 12 362 27 361 15 361 50 361 67 360 56 361 62 360 16 363 4 77 743 175 28 0 0 0 22 363 18 363 0 49 9 292 239 8 292 363 2449 356 3395 356 5 356 4 354 2 354 0 356 28 356 734 356 1006 356
14501 14501 CA 2023/02/03 6 69 290 93 213 59 182 356 63221 364 51242 364 2856 356 377 365 340 365 16 356 9 356 5297 364 317 356 263 364 2779 356 2325 363 85 356 70 356 6903 364 0.810521820281236 364 51242 63221 0.056451612903226 356 2856 50592 0.045717944613414 356 2856 62470 0.04704660136539 356 317 6738 0.767347530059394 364 5297 6903   0 364 22 362 46 361 21 361 46 361 78 361 83 361 98 361 4 364 0 364 27 362 26 362 30 361 48 361 73 361 71 361 64 361 17 352 4 75 740 175 28 0 0 0 26 364 19 363 0 47 9 298 246 12 298 364 2511 356 3419 356 11 356 4 353 1 354 0 356 12 356 710 356 1014 356
14754 14754 CA 2023/02/10 6 69 289 92 212 60 166 356 62934 364 51469 364 2988 356 472 364 285 364 19 355 19 355 5247 364 320 356 264 364 2883 356 2418 364 105 356 83 356 6816 364 0.81782502304001 364 51469 62934 0.058825845572312 356 2988 50794 0.048076458946759 356 2988 62151 0.048163756773028 356 320 6644 0.769806338028169 364 5247 6816   2 363 33 361 37 361 37 360 42 361 77 361 99 361 142 361 14 363 1 363 24 362 21 362 26 361 33 361 58 361 63 361 57 360 21 351 5 77 767 175 18 0 0 0 21 364 14 363 0 49 9 298 123 6 299 364 2575 356 3577 356 7 355 4 353 8 354 0 355 15 356 735 356 1027 356
14901 14901 CA 2023/01/19 8 70 287 94 213 58 168 356 62843 364 50872 364 3636 356 433 365 351 365 13 357 13 356 5101 364 407 356 363 364 3540 356 3096 364 96 356 81 356 6749 364 0.80950941234505 364 50872 62843 0.072391343301412 356 3636 50227 0.058562040974101 356 3636 62088 0.061910556738667 356 407 6574 0.755815676396503 364 5101 6749   4 363 27 361 47 362 32 362 48 361 78 362 77 359 118 361 8 364 4 364 21 362 39 361 24 361 46 361 83 361 69 361 65 361 3 352 4 75 770 175 28 0 0 0 55 363 30 363 0 49 9 295 295 20 296 363 2475 356 3478 356 9 357 2 354 2 355 0 356 19 356 719 356 1023 356
15369 15369 CA 2023/01/21 6 71 288 91 209 65 74 356 62109 364 49377 364 3247 356 374 365 298 365 21 357 7 356 5006 364 377 356 339 364 3147 356 2714 364 100 356 82 356 6677 364 0.795005554750519 364 49377 62109 0.066628362711099 356 3247 48733 0.052921522288322 356 3247 61355 0.057982159335589 356 377 6502 0.74973790624532 364 5006 6677   1 364 22 362 27 361 26 361 41 361 71 361 84 361 104 360 9 363 3 364 15 361 28 361 30 361 36 361 66 361 67 361 53 361 0 364 3 74 770 175 28 0 0 0 41 362 20 362 0 47 9 289 343 15 289 362 2479 356 3470 356 11 355 4 353 5 352 2 356 18 356 719 356 1018 356
19741 19741 CA 2023/02/09 7 70 287 93 214 57 168 356 63095 364 51683 364 2936 356 467 364 305 364 11 356 15 355 5260 364 337 356 292 364 2842 356 2411 364 94 356 77 356 6823 364 0.819129883508994 364 51683 63095 0.057556213365745 356 2936 51011 0.047104878948804 356 2936 62329 0.050676691729323 356 337 6650 0.770921881870145 364 5260 6823   2 363 26 362 50 360 22 360 48 360 74 360 119 359 122 360 7 363 3 363 22 361 26 360 23 360 44 359 59 360 79 360 49 361 21 351 3 74 767 175 18 0 0 0 21 363 15 363 0 47 9 298 130 7 299 363 2589 356 3547 356 9 356 1 353 1 353 1 355 15 356 751 356 1031 356
20317 20317 CA 2023/01/25 6 71 287 98 222 44 75 356 63226 364 51321 364 3072 356 432 364 344 364 9 356 11 356 5183 364 392 356 356 364 2984 356 2537 364 88 356 78 356 6773 364 0.811707209059564 364 51321 63226 0.0606455433817 356 3072 50655 0.049168520622929 356 3072 62479 0.059339993944899 356 392 6606 0.765244352576406 364 5183 6773   3 364 25 361 44 360 29 360 48 360 67 360 90 359 126 360 1 364 2 364 22 360 38 359 24 358 51 359 65 359 68 359 69 359 21 352 5 76 923 175 28 0 0 0 36 363 21 363 0 49 9 296 214 15 297 363 2536 356 3448 356 6 356 2 352 1 353 1 356 19 356 735 356 1025 356
18131 18131 CA 2023/01/18 7 73 285 100 220 45 175 357 62482 365 50537 365 3784 356 462 365 328 365 18 357 6 357 5057 365 417 357 362 365 3684 356 3264 364 100 356 88 356 6706 365 0.808824941583176 365 50537 62482 0.075979358673172 356 3784 49803 0.061410626764906 356 3784 61618 0.063820018365473 357 417 6534 0.754100805249031 365 5057 6706   3 365 27 362 41 361 25 361 48 361 76 361 90 361 150 360 4 365 4 365 18 361 38 361 26 361 61 360 47 360 62 361 72 361 12 353 5 78 950 175 18 0 0 0 55 365 34 365 0 52 9 299 317 23 299 365 2421 357 3453 357 12 357 1 353 4 353 1 357 25 357 708 357 1022 357
16877 16877 CA 2023/01/13 7 68 292 98 211 58 160 358 62837 366 50912 366 4142 358 588 367 361 367 12 359 15 358 5218 366 459 358 422 366 4020 358 3580 365 122 358 105 358 6792 366 0.810223276095294 366 50912 62837 0.082421299797031 358 4142 50254 0.066708540690277 358 4142 62091 0.069283018867925 358 459 6625 0.768256772673734 366 5218 6792   4 365 16 365 44 364 38 364 65 364 97 365 141 365 183 365 3 366 3 366 24 364 28 364 32 364 42 364 64 364 90 364 78 365 15 354 7 73 743 175 28 0 0 0 71 365 49 364 0 48 9 301 460 25 303 365 2404 358 3476 358 7 358 2 357 3 356 1 358 30 357 712 358 1031 358
18003 18003 CA 2023/01/14 7 71 289 97 202 68 81 358 61513 366 48835 366 3984 357 535 367 348 367 8 359 11 358 5023 366 442 357 406 365 3869 357 3439 365 115 358 98 357 6811 366 0.793897224976834 366 48835 61513 0.082645313861345 357 3984 48206 0.065567295349067 357 3984 60762 0.066536203522505 357 442 6643 0.737483482601674 366 5023 6811   3 366 27 365 53 364 36 364 60 364 84 363 103 364 168 364 6 365 5 366 20 364 25 364 29 364 57 363 72 364 73 364 67 363 0 365 7 75 770 175 28 0 0 0 62 364 32 364 0 49 9 293 408 28 294 364 2301 358 3356 358 4 358 2 357 2 356 0 358 28 357 695 358 1018 358
34631 34631 CA 2022/12/13 7 101 262 98 214 58 107 362 63145 370 51613 370 5172 362 744 370 433 362 20 362 17 362 5328 370 580 362 543 370 5037 362 4490 370 135 362 116 362 6829 370 0.817372713595692 370 51613 63145 0.101477426570134 362 5172 50967 0.082889928841592 362 5172 62396 0.087008700870087 362 580 6666 0.780202079367404 370 5328 6829   5 368 41 360 66 359 41 359 74 358 131 359 163 360 217 357 7 368 6 361 38 350 45 350 29 350 51 350 85 350 99 350 79 348 1 345 10 75 729 165 18 0 0 0 220 362 236 362 0 49 9 295 1587 92 296 362 2694 362 3724 362 14 362 3 136 3 352 0 362 34 362 766 362 1024 362
27496 27496 CA 2022/12/14 7 114 253 110 226 38 109 366 63537 374 52513 374 5193 366 757 374 436 366 18 365 13 365 5408 374 586 366 519 374 5039 366 4477 374 128 366 108 366 6845 374 0.826494798306498 374 52513 63537 0.10017747598287 366 5193 51838 0.08270425226947 366 5193 62790 0.087737685282228 366 586 6679 0.790065741417093 374 5408 6845   5 371 38 364 65 362 51 362 74 361 120 362 172 363 230 361 2 373 4 364 25 355 39 354 44 354 54 353 87 354 104 354 76 353 3 366 11 90 1907 165 8 0 0 0 209 366 236 366 0 62 9 298 1520 108 298 366 2781 365 3755 366 9 365 3 146 6 354 0 365 31 365 780 365 1026 365
43502 43502 CA 2022/03/02 10 125 274 125 247 37 60 401 65893 409 51972 409 4190 401 435 409 437 401 25 396 16 400 5378 409 696 401 677 409 4049 401 3780 409 141 401 122 400 7066 409 0.788733249358809 409 51972 65893 0.081588939733229 401 4190 51355 0.064343739922296 401 4190 65119 0.100869565217391 401 696 6900 0.76110953863572 409 5378 7066   5 407 34 401 39 401 37 401 52 401 72 401 94 400 102 402 0 406 2 399 32 393 46 393 41 393 58 393 97 393 67 392 94 394 0 401 24 126 11251 1547 4331 345 0 6 0 401 3 401 9 355 9 355 34 13 355 401 2433 400 3757 400 15 394 7 390 3 389 0 395 25 399 630 400 969 400

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 8322.465ms · Data source: U.S. Department of Health & Human Services