hospitals_state

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

30 rows where previous_day_deaths_influenza = 9 sorted by all_pediatric_inpatient_bed_occupied_coverage

View and edit SQL

Suggested facets: critical_staffing_shortage_today_yes, critical_staffing_shortage_today_not_reported, critical_staffing_shortage_anticipated_within_week_not_reported, hospital_onset_covid_coverage, inpatient_beds_coverage, inpatient_beds_used_coverage, inpatient_beds_used_covid_coverage, previous_day_admission_pediatric_covid_suspected_coverage, staffed_adult_icu_bed_occupancy_coverage, staffed_icu_adult_patients_confirmed_and_suspected_covid_coverage, staffed_icu_adult_patients_confirmed_covid_coverage, total_adult_patients_hospitalized_confirmed_and_suspected_covid_coverage, total_adult_patients_hospitalized_confirmed_covid_coverage, total_staffed_adult_icu_beds_coverage, inpatient_beds_utilization_coverage, adult_icu_bed_utilization_coverage, previous_day_admission_adult_covid_confirmed_20-29_coverage, previous_day_admission_adult_covid_confirmed_50-59_coverage, previous_day_admission_adult_covid_confirmed_60-69_coverage, previous_day_admission_adult_covid_confirmed_unknown, previous_day_admission_adult_covid_suspected_18-19, previous_day_admission_adult_covid_suspected_20-29, previous_day_admission_adult_covid_suspected_30-39, previous_day_admission_adult_covid_suspected_40-49_coverage, previous_day_admission_adult_covid_suspected_50-59_coverage, previous_day_admission_adult_covid_suspected_70-79, previous_day_admission_adult_covid_suspected_80+, previous_day_admission_adult_covid_suspected_unknown_coverage, previous_week_therapeutic_a_casirivimab_imdevimab_courses_used, previous_day_admission_influenza_confirmed, previous_day_deaths_influenza_coverage, total_patients_hospitalized_confirmed_influenza_coverage, all_pediatric_inpatient_bed_occupied_coverage, previous_day_admission_pediatric_covid_confirmed_0_4_coverage, previous_day_admission_pediatric_covid_confirmed_12_17_coverage, previous_day_admission_pediatric_covid_confirmed_5_11_coverage, previous_day_admission_pediatric_covid_confirmed_unknown_coverage, staffed_icu_pediatric_patients_confirmed_covid_coverage, staffed_pediatric_icu_bed_occupancy_coverage, total_staffed_pediatric_icu_beds_coverage

previous_day_admission_adult_covid_confirmed_30-39_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
46933 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
53725 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
39872 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
47026 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
22229 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
9184 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
39586 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
22327 LA 2022/12/20 1 33 114 9 122 17 14 145 12662 148 8753 148 317 145 64 148 0 147 1 146 0 146 1077 148 57 145 56 148 311 145 306 148 6 145 6 145 1454 148 0.691280998262518 148 8753 12662 0.036672836649699 145 317 8644 0.025347833040141 145 317 12506 0.039202200825309 145 57 1454 0.740715268225585 148 1077 1454   0 148 1 144 3 145 2 145 8 145 14 145 14 145 22 145 0 147 0 148 0 145 0 145 1 145 0 145 2 143 1 145 1 145 5 148 0 42 1730 10 455 0 0 0 23 148 17 148 9 36 9 36 116 9 36 148 422 146 770 146 1 144 0 141 0 141 0 145 1 145 159 146 254 146
44193 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
32278 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
16052 CA 2023/01/02 7 71 279 92 200 65 94 349 60590 357 47282 357 5124 349 641 357 1 344 34 349 18 347 4887 357 543 349 514 357 4954 349 4465 357 170 349 153 349 6625 357 0.780359795345767 357 47282 60590 0.10978745286253 349 5124 46672 0.085621188069179 349 5124 59845 0.083977729662852 349 543 6466 0.73766037735849 357 4887 6625   4 356 41 355 43 354 50 354 58 354 102 353 140 353 201 354 12 357 4 356 18 354 29 354 25 353 43 353 55 353 68 353 61 353 303 357 6 74 770 175 28 0 0 0 146 355 140 355 0 49 9 285 1067 54 285 355 2308 349 3393 349 18 348 10 346 6 345 0 348 68 349 737 349 1014 349
14156 CA 2023/01/01 7 71 280 86 205 67 92 350 60869 358 47142 358 5071 350 673 358 0 345 25 350 17 349 4832 357 534 350 506 358 4881 350 4436 358 174 350 150 350 6604 357 0.774482905912698 358 47142 60869 0.108962375641935 350 5071 46539 0.084332540619647 350 5071 60131 0.08280353543185 349 534 6449 0.73167777104785 357 4832 6604   4 357 43 356 55 355 32 355 51 355 125 355 153 355 210 355 7 357 2 357 14 355 27 355 22 355 34 354 61 354 68 354 73 354 301 358 8 74 770 175 28 0 0 0 145 345 152 345 0 50 9 276 1003 46 275 344 2307 350 3388 350 14 349 7 348 3 347 1 349 58 350 740 349 1022 349
14532 CA 2023/01/30 6 69 283 86 205 67 80 350 62010 358 48762 358 2930 350 337 358 3 346 10 350 44 349 4880 358 301 350 256 358 2832 350 2402 358 98 350 86 350 6714 358 0.786357039187228 358 48762 62010 0.060859089398471 350 2930 48144 0.047822680681596 350 2930 61268 0.045940170940171 350 301 6552 0.726839439976169 358 4880 6714   16 358 21 358 23 358 27 357 39 357 49 357 69 357 92 357 4 358 2 358 23 358 19 357 27 357 32 357 59 357 64 357 61 357 290 358 2 71 740 175 28 0 0 0 28 356 17 356 0 48 9 294 253 14 295 356 2398 350 3409 350 7 350 1 349 2 349 0 350 18 350 703 350 996 350
16845 CA 2023/01/29 6 69 283 84 205 69 80 350 61862 358 48765 358 2911 350 341 358 1 345 12 350 10 349 5028 357 331 350 288 358 2822 350 2399 358 89 350 76 350 6790 357 0.788286831980861 358 48765 61862 0.060458161124842 350 2911 48149 0.047629955658818 350 2911 61117 0.049977351653329 349 331 6623 0.740500736377025 357 5028 6790   4 357 21 358 27 356 18 356 38 356 62 356 84 356 87 356 3 357 3 357 20 357 26 356 23 356 41 356 60 356 57 356 59 356 290 358 2 71 740 175 28 0 0 0 23 357 11 357 0 47 9 295 253 13 294 356 2397 350 3388 350 9 349 2 348 1 347 0 349 20 350 719 349 998 349
20173 CA 2022/12/30 7 70 277 98 202 54 274 350 61343 354 49346 354 5134 350 791 354 18 341 32 349 20 349 4961 354 537 350 501 354 4942 350 4424 354 192 350 141 350 6601 354 0.804427563047128 354 49346 61343 0.1048311348879 350 5134 48974 0.084293829836141 350 5134 60906 0.082793709528215 350 537 6486 0.751552795031056 354 4961 6601   11 353 42 351 71 351 41 350 76 351 129 352 173 352 245 351 13 353 6 353 19 351 29 351 24 351 44 351 87 351 72 351 91 351 372 354 11 74 757 175 28 0 0 0 175 353 212 352 0 47 9 291 1179 80 292 353 2479 350 3432 350 21 349 6 347 5 346 1 349 60 350 738 350 1015 350
13945 CA 2023/01/25 6 69 284 98 216 45 74 351 62872 359 51078 359 3071 351 432 359 21 347 9 351 11 351 5173 359 392 351 356 359 2983 351 2536 359 88 351 78 351 6757 359 0.812412520676931 359 51078 62872 0.0609180353884 351 3071 50412 0.049432595573441 351 3071 62125 0.05948406676783 351 392 6590 0.765576439248187 359 5173 6757   3 359 25 358 44 357 29 357 48 357 67 357 90 356 126 357 1 359 2 359 22 357 38 356 24 355 51 356 65 356 68 356 69 356 344 359 5 73 923 175 28 0 0 0 35 358 21 358 0 47 9 295 213 15 296 358 2536 351 3448 351 6 351 2 349 1 350 1 351 19 351 735 351 1025 351
18996 CA 2023/01/27 6 69 284 93 208 58 74 351 63018 359 50326 359 2990 351 396 359 18 346 18 350 11 350 5126 359 363 351 321 359 2895 351 2464 359 95 351 83 351 6809 359 0.798597226189343 359 50326 63018 0.060213061602594 351 2990 49657 0.048029813824233 351 2990 62253 0.054701627486438 351 363 6636 0.752827140549273 359 5126 6809   1 358 19 357 27 357 30 356 41 356 64 356 71 356 124 356 6 358 3 358 18 356 27 357 34 356 40 356 60 356 78 356 67 356 330 359 4 71 740 175 28 0 0 0 27 359 13 358 0 46 9 297 175 9 297 359 2555 351 3518 351 11 350 2 348 5 348 0 350 18 351 727 351 1008 351
13000 CA 2023/01/22 7 69 284 91 202 67 74 352 61179 360 48155 360 3206 352 321 360 4 347 14 352 13 351 4873 359 383 352 346 360 3101 352 2651 360 105 352 88 352 6587 359 0.787116494221874 360 48155 61179 0.067422346533196 352 3206 47551 0.053050485661807 352 3206 60433 0.059657320872274 351 383 6420 0.739790496432367 359 4873 6587   0 359 28 360 26 358 19 358 40 358 55 358 59 358 93 358 8 359 5 359 19 359 24 358 20 358 32 358 53 358 48 358 61 358 266 360 2 72 770 175 28 0 0 0 39 358 23 358 0 47 9 289 350 16 288 357 2421 352 3460 352 5 351 4 351 4 350 1 351 19 352 708 351 1016 351
21974 CA 2022/12/20 9 73 278 88 199 73 169 352 62285 360 50838 360 5119 352 717 360 0 346 29 352 20 352 5246 360 558 352 511 360 4964 352 4450 360 155 352 127 352 6663 360 0.816215782291081 360 50838 62285 0.10198430091246 352 5119 50194 0.083183022148556 352 5119 61539 0.084532646568702 352 558 6601 0.787333033168242 360 5246 6663   7 359 37 357 69 357 49 357 68 357 128 358 130 358 227 357 7 360 4 360 30 357 27 357 40 356 48 357 81 357 86 356 79 356 395 360 7 88 770 175 18 0 0 0 191 359 221 359 0 61 9 291 1288 81 291 358 2673 352 3718 352 22 352 1 348 4 349 2 352 33 352 805 352 1066 352
12738 CA 2023/01/09 7 71 283 96 197 68 90 353 62193 361 49527 361 4761 353 526 361 14 348 19 353 15 352 5041 361 520 353 478 361 4631 353 4077 361 130 353 111 353 6758 361 0.796343639959481 361 49527 62193 0.09737789413401 353 4761 48892 0.077490234375 353 4761 61440 0.078919411139778 353 520 6589 0.745930748742231 361 5041 6758   3 361 31 357 44 358 35 358 51 358 95 358 108 358 155 359 12 361 3 361 21 358 26 358 18 358 32 358 71 358 74 358 76 357 321 361 5 75 770 175 28 0 0 0 97 359 74 359 0 50 9 295 702 46 297 359 2289 353 3390 353 16 353 1 350 2 351 0 353 30 353 726 353 1013 353
14331 CA 2023/01/16 6 68 288 91 204 67 85 353 60688 361 47620 361 3938 352 458 362 0 350 6 354 8 353 4858 361 449 352 405 360 3829 352 3405 360 109 353 83 352 6778 361 0.784669127339836 361 47620 60688 0.083732006548872 352 3938 47031 0.065696840278936 352 3938 59942 0.067927382753404 352 449 6610 0.716730598996754 361 4858 6778   1 361 34 360 38 360 34 360 60 360 70 360 82 360 143 359 8 362 4 362 19 361 29 360 23 360 47 360 51 360 52 360 65 359 290 362 3 72 743 175 28 0 0 0 55 357 36 357 0 46 9 286 363 28 287 357 2250 353 3368 353 5 353 1 351 0 351 0 354 26 352 705 353 1014 353
17283 CA 2022/12/24 7 72 282 91 202 68 80 353 60613 361 47213 361 4831 353 719 361 2 360 18 352 13 352 4936 361 580 353 538 361 4695 353 4217 361 136 353 115 353 6625 361 0.778925313051656 361 47213 60613 0.103593944332461 353 4831 46634 0.0806726337586 353 4831 59884 0.089727722772277 353 580 6464 0.745056603773585 361 4936 6625   5 360 38 358 55 358 41 358 57 358 123 358 141 358 224 358 3 359 3 360 16 358 27 358 24 358 47 358 69 358 87 358 82 358 356 361 8 76 855 175 38 0 0 0 167 359 207 359 0 50 9 288 1164 78 288 359 2383 353 3362 353 12 352 2 350 4 350 0 352 24 353 756 353 1009 353
20342 CA 2023/01/21 7 69 287 92 205 66 153 355 61927 363 49236 363 3250 355 374 363 0 362 21 355 7 354 5006 363 377 355 339 363 3150 355 2717 363 100 355 82 355 6672 363 0.795065157362701 363 49236 61927 0.066883437602898 355 3250 48592 0.053128013993102 355 3250 61173 0.058026781591504 355 377 6497 0.750299760191846 363 5006 6672   1 362 22 362 28 361 25 361 41 361 71 361 84 361 104 360 9 361 3 362 15 361 29 361 30 361 36 361 66 361 67 361 53 361 299 363 3 72 770 175 28 0 0 0 42 361 20 361 0 47 9 290 344 15 290 361 2479 355 3470 355 11 353 4 353 5 352 2 354 18 355 719 355 1018 355
13985 CA 2023/01/18 7 72 285 101 218 45 172 356 62375 364 50466 364 3781 355 462 364 12 352 18 356 6 356 5052 364 416 356 361 364 3681 355 3261 363 100 355 88 355 6703 364 0.809074148296593 364 50466 62375 0.076027507439878 355 3781 49732 0.061468680398628 355 3781 61511 0.063696218037054 356 416 6531 0.753692376547814 364 5052 6703   3 363 27 361 41 360 25 360 48 360 76 360 90 360 150 359 4 364 4 363 18 360 38 360 26 360 61 359 47 359 62 360 72 360 328 364 5 77 950 175 18 0 0 0 55 364 34 364 0 51 9 300 317 23 301 364 2421 356 3453 356 12 355 1 352 4 352 1 356 25 356 708 356 1022 356
18829 CA 2023/01/19 8 68 288 94 212 58 165 356 62775 364 50812 364 3638 356 434 364 3 351 13 356 13 355 5102 364 406 356 362 364 3542 356 3098 364 96 356 81 356 6749 364 0.809430505774592 364 50812 62775 0.072517790579465 356 3638 50167 0.058658497258949 356 3638 62020 0.061758442348646 356 406 6574 0.755963846495777 364 5102 6749   4 361 27 360 48 361 32 361 48 360 78 361 77 358 118 360 8 363 4 362 21 361 40 360 24 360 46 360 83 360 69 360 65 360 352 364 4 74 770 175 28 0 0 0 56 363 30 363 0 48 9 295 296 20 298 363 2475 356 3478 356 9 355 2 353 2 354 0 355 19 356 719 356 1023 356
19400 CA 2023/01/13 7 68 291 99 209 58 157 358 62768 366 50854 366 4140 358 588 366 15 353 12 358 15 357 5218 366 460 358 423 366 4018 358 3578 365 122 358 105 358 6790 366 0.810189905684425 366 50854 62768 0.08247669136983 358 4140 50196 0.066750507884299 358 4140 62022 0.069454929790125 358 460 6623 0.768483063328424 366 5218 6790   4 364 16 364 44 363 38 363 65 363 97 364 141 364 183 364 3 365 3 365 24 363 28 363 32 363 42 363 64 363 90 363 78 364 361 366 7 72 743 175 28 0 0 0 71 365 49 364 0 47 9 300 460 25 302 365 2404 358 3476 358 7 357 2 356 3 355 1 357 30 357 712 358 1031 358
20129 CA 2023/01/14 7 70 289 97 201 68 76 358 61444 366 48782 366 3980 357 535 366 0 364 8 358 11 357 5025 366 443 357 407 365 3865 357 3435 365 115 358 98 357 6813 366 0.793926176681206 366 48782 61444 0.08265320956119 357 3980 48153 0.065575931326512 357 3980 60693 0.066666666666667 357 443 6645 0.737560546014971 366 5025 6813   3 365 27 364 53 363 36 363 60 363 84 362 103 363 168 363 6 364 5 365 20 363 25 363 29 363 57 362 72 363 73 363 67 362 348 366 7 74 770 175 28 0 0 0 62 364 32 364 0 48 9 292 408 28 293 364 2301 358 3356 358 4 357 2 356 2 355 0 357 28 357 695 358 1018 358
22025 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
28042 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
39283 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 8449.554ms · Data source: U.S. Department of Health & Human Services