hospitals_state

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

34 rows where previous_day_admission_pediatric_covid_confirmed_5_11 = 11 sorted by critical_staffing_shortage_today_yes

View and edit SQL

Suggested facets: critical_staffing_shortage_today_yes, critical_staffing_shortage_today_no, critical_staffing_shortage_anticipated_within_week_yes, 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_confirmed, previous_day_admission_pediatric_covid_confirmed_coverage, previous_day_admission_pediatric_covid_suspected, staffed_icu_adult_patients_confirmed_and_suspected_covid_coverage, total_pediatric_patients_hospitalized_confirmed_covid, inpatient_beds_utilization_coverage, previous_day_admission_adult_covid_confirmed_18-19_coverage, previous_day_admission_adult_covid_confirmed_40-49_coverage, previous_day_admission_adult_covid_confirmed_60-69, 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_30-39_coverage, previous_day_admission_adult_covid_suspected_40-49_coverage, previous_day_admission_adult_covid_suspected_60-69, previous_day_admission_adult_covid_suspected_70-79, deaths_covid, on_hand_supply_therapeutic_a_casirivimab_imdevimab_courses, on_hand_supply_therapeutic_c_bamlanivimab_etesevimab_courses, previous_week_therapeutic_c_bamlanivimab_etesevimab_courses_used, icu_patients_confirmed_influenza_coverage, previous_day_admission_influenza_confirmed_coverage, previous_day_deaths_covid_and_influenza_coverage, previous_day_deaths_influenza_coverage, total_patients_hospitalized_confirmed_influenza_and_covid_coverage, all_pediatric_inpatient_bed_occupied_coverage, previous_day_admission_pediatric_covid_confirmed_0_4, previous_day_admission_pediatric_covid_confirmed_0_4_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_pediatric_covid_confirmed_5_11

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
17357 NV 2022/02/22 0 2 58 0 2 58 60 58 8547 60 6872 60 655 58 59 60 99 58 4 58 17 58 692 60 135 58 119 60 617 58 537 60 38 58 8 58 850 60 0.804024804024804 60 6872 8547 0.097181008902077 58 655 6740 0.078050524308866 58 655 8392 0.165644171779141 58 135 815 0.814117647058824 60 692 850   0 60 1 60 4 60 5 60 13 60 15 60 12 60 9 60 0 60 0 58 6 58 6 58 9 58 16 58 20 58 17 58 25 58 0 58 0 2 330 0 705 0 0 0 0 58 0 58 0 2 0 2 5 1 2 58 401 58 537 58 10 58 0 58 11 58 0 58 7 58 85 58 115 58
22916 TX 2022/07/05 5 82 416 9 78 416 100 498 57633 503 43078 503 3187 498 490 503 181 498 36 498 72 498 4900 503 431 498 394 503 3009 498 2732 503 178 498 112 498 5803 503 0.747453715753128 503 43078 57633 0.074963541421649 498 3187 42514 0.056016451646922 498 3187 56894 0.0761349584879 498 431 5661 0.844390832328106 503 4900 5803   3 501 39 499 21 498 37 498 59 498 90 498 114 498 113 498 20 503 2 496 10 493 22 493 30 494 29 493 34 493 30 493 22 493 2 498 19 491 328 0 85 0 0 0 3 498 12 498 0 90 0 90 76 10 90 498 3242 498 3875 498 17 496 8 493 11 493 0 498 23 498 894 498 1081 498
33089 TX 2022/07/02 5 105 485 9 101 485 135 590 64461 595 48229 595 2974 590 462 595 235 590 54 590 62 590 5037 595 397 590 352 595 2758 590 2420 595 216 590 146 590 5877 595 0.748188827352973 595 48229 64461 0.062367620845129 590 2974 47685 0.046673676611372 590 2974 63719 0.069211994421199 590 397 5736 0.857069933639612 595 5037 5877   1 593 32 590 27 590 35 590 54 590 81 590 119 590 90 590 30 595 4 588 21 585 15 585 21 585 25 585 46 585 54 585 44 585 5 590 16 581 356 0 114 0 0 0 6 590 11 590 0 101 0 101 101 8 101 590 3785 590 4336 590 31 588 12 584 11 584 0 590 30 590 918 590 1075 590
22625 CA 2022/08/02 6 94 276 111 227 38 108 368 61731 376 47911 376 4991 368 646 376 306 368 30 368 9 368 4728 376 522 368 518 376 4844 368 4524 376 147 368 139 367 6630 376 0.776125447506115 376 47911 61731 0.105419905373437 368 4991 47344 0.081837112827324 368 4991 60987 0.080592867068087 368 522 6477 0.713122171945701 376 4728 6630   4 374 36 371 64 371 43 371 61 372 119 372 147 371 172 372 1 374 4 368 24 364 29 364 32 364 37 364 64 364 50 364 65 364 1 368 13 107 8022 1100 3144 305 0 0 6 368 5 368 0 339 0 339 41 2 339 368 2128 368 3571 368 11 368 8 364 11 361 0 365 39 367 626 368 947 368
23264 TX 2022/07/24 6 105 483 10 101 483 131 589 63171 594 47834 594 4002 589 531 594 291 589 37 589 59 589 5070 594 599 589 553 594 3767 589 3443 594 235 589 171 589 5874 594 0.757214544648652 594 47834 63171 0.084658994753765 589 4002 47272 0.064088397790055 589 4002 62445 0.104464597139867 589 599 5734 0.863125638406537 594 5070 5874   3 592 37 589 43 589 42 588 56 588 94 588 122 588 128 589 32 594 3 587 19 583 23 583 24 583 27 583 37 583 59 583 50 583 49 589 17 581 346 0 35 0 0 0 2 589 8 589 0 104 0 104 83 10 104 589 3630 589 4241 589 33 587 4 582 11 582 0 589 32 589 939 589 1110 589
23567 TX 2022/07/16 6 107 482 11 102 482 150 590 64396 595 49210 595 3726 590 595 595 262 590 46 590 72 590 5229 595 539 590 491 595 3456 590 3149 595 254 590 174 590 6006 595 0.7641778992484 595 49210 64396 0.076663511789638 590 3726 48602 0.058521415445507 590 3726 63669 0.091869780126129 590 539 5867 0.870629370629371 595 5229 6006   3 593 35 589 42 589 54 589 76 589 124 589 118 589 132 589 26 595 0 588 22 584 25 584 18 585 31 584 57 584 63 584 42 584 4 590 28 580 353 0 114 0 0 0 5 590 24 590 0 105 0 105 103 9 105 590 3732 590 4320 590 34 588 9 583 11 584 0 590 24 590 918 590 1065 590
32681 TX 2022/07/07 6 106 482 9 103 482 142 589 65537 594 50099 594 3440 589 669 594 301 589 51 589 89 589 5250 594 452 589 413 594 3211 589 2903 594 229 589 146 589 6002 594 0.764438408837756 594 50099 65537 0.069539904584782 589 3440 49468 0.053092974441289 589 3440 64792 0.077119945401809 589 452 5861 0.874708430523159 594 5250 6002   7 592 50 588 49 588 54 587 89 588 112 587 128 588 124 588 68 594 4 587 12 583 33 584 30 584 34 583 49 583 57 581 39 582 43 589 11 582 356 1 114 0 0 0 3 589 13 589 0 105 0 105 80 8 105 589 3829 589 4417 589 23 587 17 582 11 582 0 589 33 589 922 589 1086 589
32797 TX 2022/06/23 6 106 482 8 104 482 119 589 65488 594 50591 594 2425 589 401 594 280 589 32 589 72 589 5319 594 320 589 284 594 2223 589 1934 594 202 589 116 589 6049 594 0.77252321035915 594 50591 65488 0.048525233121223 589 2425 49974 0.037454051215519 589 2425 64746 0.054191363251482 589 320 5905 0.879318895685237 594 5319 6049   1 592 30 589 37 589 41 589 40 589 58 589 101 589 70 589 30 594 5 587 20 584 33 584 30 585 39 585 54 584 50 584 44 584 5 589 12 582 346 0 35 0 0 0 12 589 22 589 0 105 0 105 119 11 105 589 3850 589 4393 589 17 587 4 582 11 583 0 589 23 589 964 589 1092 589
33120 TX 2022/08/30 6 77 415 8 75 415 102 493 58967 498 46656 498 3068 493 427 498 286 493 46 493 95 493 5325 498 404 493 361 498 2817 493 2532 498 251 493 165 493 6057 498 0.791222209032171 498 46656 58967 0.06665797592665 493 3068 46026 0.052677666935664 493 3068 58241 0.068266306184522 493 404 5918 0.879148093115404 498 5325 6057   4 497 39 494 25 493 37 493 58 493 69 493 94 493 99 493 13 498 3 492 23 489 34 488 31 488 39 488 61 488 54 488 39 488 2 493 16 490 321 0 85 0 0 0 9 493 14 493 0 92 1 92 101 7 92 493 3773 493 4225 493 30 492 14 488 11 489 0 493 31 493 954 493 1070 493
33378 TX 2022/08/19 6 95 485 10 91 485 129 581 64758 586 50101 586 3389 581 411 586 284 581 31 581 87 581 5273 586 495 581 465 586 3148 581 2848 586 241 581 153 581 6007 586 0.773665029803268 586 50101 64758 0.068467412824761 581 3389 49498 0.05292748824788 581 3389 64031 0.084398976982097 581 495 5865 0.877809222573664 586 5273 6007   6 584 35 581 45 580 23 580 66 580 73 580 104 580 86 580 13 586 3 579 23 576 23 576 29 576 41 575 65 575 51 575 46 575 3 581 18 574 349 0 114 0 0 0 9 581 16 581 0 98 0 98 86 9 98 581 3756 581 4340 581 21 579 8 574 11 575 0 581 29 581 899 581 1066 581
22007 CA 2022/07/28 7 127 276 118 254 38 376 402 64620 410 50993 410 5086 402 679 410 322 402 31 400 9 401 4927 410 555 402 529 410 4924 402 4648 410 162 402 151 401 6723 410 0.789121015165583 410 50993 64620 0.100968792186135 402 5086 50372 0.079639227721842 402 5086 63863 0.084655277608298 402 555 6556 0.732857355347315 410 4927 6723   3 409 55 398 65 398 59 398 77 398 122 398 135 397 162 398 3 409 0 401 32 390 40 390 26 390 49 390 46 390 68 389 57 389 4 402 13 124 7975 1100 3035 305 0 0 12 402 6 402 3 351 3 351 44 6 351 402 2411 401 3768 401 13 400 7 389 11 386 0 398 39 400 654 401 974 401
24096 TX 2022/06/28 7 79 416 9 77 416 109 497 59068 502 45871 502 2756 497 419 502 283 497 49 497 69 497 5220 502 398 497 354 502 2547 497 2261 502 209 497 131 497 5930 502 0.776579535450667 502 45871 59068 0.06093166191329 497 2756 45231 0.047242744741759 497 2756 58337 0.068762957843815 497 398 5788 0.88026981450253 502 5220 5930   5 500 43 497 32 497 31 497 48 497 76 497 80 497 96 497 19 502 4 495 22 492 27 492 24 492 45 492 56 492 63 492 37 492 5 497 14 491 328 0 85 0 0 0 9 497 12 497 0 91 0 91 97 12 91 497 3438 497 3943 497 23 495 15 492 11 492 0 497 27 497 879 497 1018 497
25185 TX 2022/08/17 7 95 484 9 93 484 126 581 64381 586 50286 586 3500 581 462 586 265 581 33 581 75 581 5407 586 535 581 477 586 3285 581 2955 586 215 581 152 581 5998 586 0.781068948913499 586 50286 64381 0.070484936362172 581 3500 49656 0.054987352908831 581 3500 63651 0.091343691309544 581 535 5857 0.901467155718573 586 5407 5998   2 586 47 583 30 583 28 583 50 583 83 583 111 583 119 583 19 586 2 581 20 578 21 578 25 578 35 578 56 578 62 578 39 578 5 581 29 578 1942 660 711 0 0 0 7 581 15 581 0 100 0 100 50 9 100 581 3706 581 4279 581 23 581 12 577 11 577 0 581 22 581 873 581 1045 581
29433 FL 2022/06/14 7 158 75 36 143 61 124 234 55654 240 43839 240 3475 234 597 240 237 234 34 234 16 234 4815 240 348 234 344 240 3391 234 3133 240 84 234 72 234 6527 240 0.787706184640816 240 43839 55654 0.080577841673237 234 3475 43126 0.063425140082863 234 3475 54789 0.054639660857277 234 348 6369 0.737704918032787 240 4815 6527   1 236 21 231 45 231 34 230 76 230 99 231 133 231 177 233 14 240 4 232 19 224 23 223 27 225 34 224 50 224 38 224 33 225 9 234 17 134 4065 0 2696 1219 0 353 25 234 81 234 0 126 0 126 304 13 129 234 1744 234 2604 234 12 234 10 222 11 225 1 232 18 234 666 234 920 234
31136 TX 2022/06/29 7 107 481 9 105 481 139 590 64887 595 49919 595 2839 590 486 595 263 590 57 590 80 590 5328 595 394 590 360 595 2617 590 2330 595 212 590 136 590 6020 595 0.769322052183026 595 49919 64887 0.057597890038547 590 2839 49290 0.04425220169901 590 2839 64155 0.067018200374213 590 394 5879 0.885049833887043 595 5328 6020   2 595 39 593 39 593 30 593 63 593 68 593 111 593 114 593 31 595 2 590 20 588 23 588 26 588 39 588 49 588 51 588 44 588 9 590 18 583 2449 660 733 0 0 0 6 590 14 590 0 103 1 103 39 12 103 590 3752 590 4267 590 28 589 18 587 11 588 0 590 31 590 886 590 1017 590
31999 TX 2022/08/11 7 106 479 9 104 479 123 587 65078 592 50112 592 3615 587 530 592 325 587 33 587 78 587 5329 592 513 587 466 592 3377 587 3058 592 238 587 177 587 5980 592 0.770029810381388 592 50112 65078 0.073048011639185 587 3615 49488 0.056174537317608 587 3615 64353 0.087782340862423 587 513 5844 0.891137123745819 592 5329 5980   4 589 35 586 39 585 33 585 57 585 108 585 118 586 98 585 64 592 4 584 17 581 24 580 28 581 42 580 61 580 61 581 37 580 51 587 20 579 425 0 148 0 0 0 8 587 15 587 0 103 1 103 77 8 103 587 3686 587 4294 587 23 585 9 580 11 581 0 587 30 587 906 587 1085 587
32014 TX 2022/08/09 7 78 416 9 76 416 110 496 58641 501 45903 501 3724 496 551 501 246 496 45 496 88 496 5205 501 514 496 477 501 3458 496 3172 501 266 496 182 496 5894 501 0.782779966235228 501 45903 58641 0.082243816254417 496 3724 45280 0.06430668278363 496 3724 57910 0.089313640312772 496 514 5755 0.88310145911096 501 5205 5894   2 499 36 495 38 495 40 495 64 495 110 495 141 495 128 495 24 501 1 494 20 490 15 490 19 491 37 490 52 490 49 490 43 490 10 496 21 492 321 0 85 0 0 0 9 496 10 496 0 90 0 91 80 7 91 496 3347 496 4008 496 28 494 16 490 11 490 0 496 36 496 886 496 1077 496
15809 FL 2022/02/14 8 162 72 39 142 61 184 236 56899 242 45301 242 5374 236 555 242 200 236 48 236 30 236 5108 242 898 236 880 242 5234 236 4922 242 140 236 117 236 6625 242 0.796165134712385 242 45301 56899 0.120501379016526 236 5374 44597 0.096014007253756 236 5374 55971 0.139009287925697 236 898 6460 0.771018867924528 242 5108 6625   4 237 31 232 23 232 31 231 78 231 98 233 131 233 130 232 29 242 2 236 15 225 24 224 16 224 37 224 26 224 36 224 34 223 10 236 48 132 4133 69 3637 1448 237 318 7 236 10 236 0 124 0 124 70 9 124 236 1628 236 2610 236 14 235 17 225 11 224 6 236 18 236 577 236 848 236
23687 CA 2022/07/22 8 127 277 118 256 38 126 404 64308 412 50443 412 5045 404 726 412 316 404 36 403 14 403 4796 412 521 404 506 412 4843 404 4584 412 202 404 187 403 6603 412 0.784396964607825 412 50443 64308 0.101225947551115 404 5045 49839 0.079373820012587 404 5045 63560 0.080850403476102 404 521 6444 0.726336513705891 412 4796 6603   6 410 50 400 79 400 58 400 94 399 113 400 146 398 179 399 3 410 3 403 13 392 39 392 34 392 43 392 73 392 66 390 45 391 0 404 14 122 8035 1100 3134 364 0 0 15 404 4 404 1 351 1 351 55 10 351 404 2395 403 3775 403 19 402 5 392 11 389 1 400 31 402 636 403 965 403
24485 FL 2022/08/30 8 162 73 35 149 59 107 237 55310 243 43217 243 3205 237 495 243 220 237 35 237 25 237 4626 243 340 237 322 243 3092 237 2836 243 113 237 87 237 6484 243 0.781359609473874 243 43217 55310 0.075201201342124 237 3205 42619 0.058686735516004 237 3205 54612 0.05346752634062 237 340 6359 0.713448488587292 243 4626 6484   6 238 19 231 41 230 48 231 51 233 71 231 96 232 136 234 28 243 3 235 14 224 14 224 21 225 31 224 42 224 55 224 39 225 1 237 14 132 4016 0 1084 1058 0 95 4 237 10 237 0 131 0 131 64 7 134 237 1931 237 2668 237 12 237 19 224 11 224 2 235 17 237 670 237 896 237
28421 FL 2022/07/15 8 187 75 38 171 61 147 264 60067 270 46909 270 4373 264 756 270 233 264 61 264 49 264 4790 270 442 264 422 270 4266 264 3994 270 107 264 96 264 6516 270 0.780944611850101 270 46909 60067 0.09439419776804 264 4373 46327 0.073625726071218 264 4373 59395 0.069008587041374 264 442 6405 0.735113566605279 270 4790 6516   5 265 31 253 53 253 49 254 86 253 131 250 163 254 203 256 35 270 1 264 12 246 12 246 26 246 30 246 61 245 43 246 36 246 12 264 31 150 4580 0 2669 1184 0 143 5 264 25 264 0 142 0 142 112 8 145 264 1909 264 2828 264 15 264 8 245 11 245 33 262 27 264 688 264 904 264
30779 CA 2022/08/09 8 97 275 114 226 40 96 372 61762 380 47930 380 4469 371 612 380 277 372 37 372 12 371 4762 379 495 371 479 379 4298 371 4025 379 171 371 152 370 6671 379 0.776043521906674 380 47930 61762 0.094430122976799 371 4469 47326 0.073264697203187 371 4469 60998 0.076013513513514 371 495 6512 0.713836006595713 379 4762 6671   2 376 45 373 59 373 43 372 76 373 108 373 115 374 165 374 4 376 2 371 16 365 26 364 27 365 40 365 61 365 50 365 54 365 1 371 10 109 8037 959 3131 305 0 1 4 370 3 370 0 338 0 338 29 4 338 370 2258 372 3591 372 22 369 4 367 11 361 0 367 30 370 606 371 952 371
13497 CA 2022/02/19 9 140 266 128 252 35 123 407 66324 415 51643 415 6606 407 614 415 376 407 34 399 13 404 5484 415 1214 407 1195 415 6396 407 5995 415 194 407 180 406 7057 415 0.778647246848803 415 51643 66324 0.129392408038547 407 6606 51054 0.10078418210112 407 6606 65546 0.176120702161613 407 1214 6893 0.777100751027349 415 5484 7057   7 411 46 402 66 401 59 401 68 401 112 399 122 399 132 398 2 412 4 404 31 394 42 393 23 393 50 393 78 393 66 393 82 392 0 406 34 129 8615 782 3338 311 0 17 3 407 1 407 0 346 0 346 43 1 346 407 2437 404 3738 404 14 397 9 389 11 388 0 398 41 403 651 404 931 404
14344 FL 2022/02/06 9 190 72 40 170 61 248 265 60412 271 46901 271 7299 265 868 271 269 265 51 265 21 265 5241 271 1145 265 1143 271 7133 265 6770 271 166 265 146 265 6574 271 0.77635238032179 271 46901 60412 0.158123916811092 265 7299 46160 0.12268257836793 265 7299 59495 0.178655016383211 265 1145 6409 0.797231518101612 271 5241 6574   8 262 36 256 59 257 56 259 90 257 173 260 184 260 216 260 46 271 2 260 13 249 24 250 35 250 34 250 52 251 52 251 50 251 7 265 46 153 3993 69 3281 1582 237 318 7 265 10 265 1 135 1 135 78 7 135 265 1764 265 2841 265 18 264 20 251 11 251 2 265 61 264 578 265 871 265
17760 FL 2022/02/10 9 190 72 39 171 61 219 265 61174 271 49656 271 6288 265 822 271 249 265 85 265 20 265 5404 271 999 265 992 271 6123 265 5797 271 165 265 150 265 6636 271 0.811717396279465 271 49656 61174 0.128607367107766 265 6288 48893 0.104363413055385 265 6288 60251 0.154381084840056 265 999 6471 0.814345991561182 271 5404 6636   5 264 39 258 49 257 62 258 84 258 173 261 207 260 162 257 41 271 1 263 12 252 27 251 26 250 45 250 45 250 44 251 42 250 7 265 41 150 3787 69 3141 1448 237 318 6 265 9 265 0 138 0 138 74 9 139 265 2011 265 2860 265 20 263 18 253 11 251 36 265 33 265 726 265 1032 265
18258 FL 2022/02/12 9 190 72 40 170 61 190 265 60568 271 47543 271 5588 265 762 271 259 265 80 265 19 265 5266 271 916 265 911 271 5441 265 5112 271 147 265 128 265 6616 271 0.784952450138687 271 47543 60568 0.119320122992825 265 5588 46832 0.093697077415785 265 5588 59639 0.141993489381491 265 916 6451 0.795949214026602 271 5266 6616   2 265 47 259 36 259 47 261 108 262 131 263 172 259 188 259 31 271 3 265 9 253 26 253 19 252 35 252 46 251 55 252 58 251 8 265 38 147 3819 53 3167 1448 237 318 7 265 10 265 0 138 0 138 70 9 138 265 1832 265 2829 265 19 264 20 255 11 253 30 265 26 265 594 265 865 265
12249 TX 2022/02/25 10 109 475 11 108 475 105 589 66954 594 52028 594 4559 589 364 594 271 589 33 589 97 589 5907 594 1050 589 1021 594 4341 589 3897 594 218 589 166 589 6527 594 0.777070824745348 594 52028 66954 0.088618913402663 589 4559 51445 0.068864988973143 589 4559 66202 0.164938737040528 589 1050 6366 0.905009958633369 594 5907 6527   5 590 19 587 31 588 34 588 47 588 75 588 74 588 61 588 18 594 5 586 23 582 25 583 34 584 33 584 50 583 49 582 50 583 2 589 51 582 314 0 114 12 0 6 26 589 38 589 0 110 0 110 182 5 110 589 3843 589 4373 589 11 586 11 582 11 581 0 589 29 588 972 589 1108 589
12737 FL 2022/02/17 10 191 70 41 171 59 171 265 60842 271 49149 271 4598 265 527 271 228 265 68 265 50 265 5286 271 760 265 741 271 4482 265 4105 271 116 265 98 265 6614 271 0.807813681338549 271 49149 60842 0.095001962850472 265 4598 48399 0.076712603023124 265 4598 59938 0.117847728329974 265 760 6449 0.799213788932567 271 5286 6614   1 265 25 255 30 255 36 256 64 257 102 258 125 256 111 257 33 271 3 264 16 250 22 249 22 249 25 249 44 249 47 249 39 248 10 265 27 150 4033 69 3325 1447 237 318 7 265 8 265 1 139 1 139 60 6 139 265 2001 265 2855 265 9 264 15 251 11 251 33 265 32 265 634 265 906 265
24275 FL 2022/06/24 10 185 75 37 172 61 118 264 60276 270 46880 270 3635 264 614 270 187 264 61 264 47 264 4865 270 349 264 335 270 3549 264 3272 270 86 264 68 264 6552 270 0.777755657309709 270 46880 60276 0.078674544942969 264 3635 46203 0.0611571916483 264 3635 59437 0.05453125 264 349 6400 0.742521367521368 270 4865 6552   4 261 35 259 34 257 48 259 64 260 109 262 115 259 183 263 21 270 2 260 8 252 17 251 16 253 34 251 37 251 28 253 34 252 11 264 22 151 4125 0 2650 1184 0 193 30 264 53 264 0 140 0 140 213 18 143 264 1956 264 2886 264 11 264 7 251 11 251 32 262 15 264 703 264 908 264
17981 FL 2022/02/01 11 160 71 39 143 60 270 236 56689 242 46671 242 8636 236 1277 242 258 236 66 236 21 236 5504 242 1326 236 1331 242 8448 236 8181 242 188 236 174 236 6632 242 0.823281412619732 242 46671 56689 0.188221960681749 236 8636 45882 0.154847501389611 236 8636 55771 0.205009276437848 236 1326 6468 0.829915560916767 242 5504 6632   11 233 63 231 79 231 104 230 158 232 211 233 313 235 268 234 70 242 2 230 8 223 23 222 26 222 31 223 45 223 49 224 58 224 16 236 59 137 3988 146 3022 1930 237 461 12 228 9 228 1 125 1 125 80 13 125 233 1355 193 1857 192 15 192 22 187 11 187 18 220 31 190 445 190 655 192
18626 CA 2022/02/09 15 125 273 154 226 33 125 405 67303 413 54694 413 10261 405 1190 413 455 405 58 398 18 402 5974 413 1897 405 1889 413 9929 405 9592 413 316 405 293 404 7380 413 0.812653224967683 413 54694 67303 0.189839225916264 405 10261 54051 0.154263635816946 405 10261 66516 0.26314329310584 405 1897 7209 0.809485094850948 413 5974 7380   11 410 90 402 107 402 86 402 154 401 237 401 240 399 262 401 5 409 1 402 25 394 35 394 28 394 77 394 104 394 109 393 76 393 0 405 54 131 10901 1575 4524 352 0 50 3 405 7 405 0 356 1 356 49 4 356 405 2374 402 3671 402 27 396 20 391 11 390 0 397 57 401 674 402 948 402
15160 CA 2022/01/30 17 130 269 152 227 37 234 408 66995 416 52785 416 14070 408 1415 416 418 408 58 399 20 407 6012 416 2495 408 2495 416 13677 408 13346 416 393 408 358 407 7280 416 0.787894619001418 416 52785 66995 0.269504089489915 408 14070 52207 0.212518502854726 408 14070 66206 0.351260030972828 408 2495 7103 0.825824175824176 416 6012 7280   23 410 123 401 145 399 119 400 180 398 275 397 263 397 282 398 5 407 6 404 29 394 31 392 39 391 65 390 78 390 86 389 84 390 0 408 49 150 8839 891 3490 394 0 16 5 402 6 402 6 364 6 364 44 9 363 402 829 119 3400 343 18 330 26 330 11 330 3 355 78 340 564 342 848 342
12412 CA 2022/01/20 34 152 230 162 215 39 180 408 67609 416 55207 416 16147 407 2172 416 495 408 82 390 27 404 6216 415 2490 407 2481 415 15655 407 15320 415 492 407 452 406 7431 415 0.816562883639752 416 55207 67609 0.296019946101527 407 16147 54547 0.241623894533647 407 16147 66827 0.343590451221195 407 2490 7247 0.836495761001211 415 6216 7431   14 411 169 402 216 404 193 402 296 402 435 402 405 401 434 402 8 402 8 403 39 393 50 394 58 394 67 393 90 393 92 393 91 393 0 406 46 145 8951 897 4081 713 0 130 9 400 10 400 1 364 1 365 60 9 365 400 671 75 2996 272 34 268 25 269 11 268 12 307 74 292 554 296 755 296
16478 CA 2022/01/21 35 146 235 165 213 38 241 408 67653 416 55191 416 16182 407 2207 416 475 408 85 390 33 404 6202 415 2492 407 2526 415 15661 407 15333 415 521 407 469 406 7396 415 0.815795308412044 416 55191 67653 0.296917431192661 407 16182 54500 0.242017259171739 407 16182 66863 0.345247991133278 407 2492 7218 0.83856138453218 415 6202 7396   19 411 190 400 274 403 210 401 302 401 396 400 410 400 397 401 7 401 3 403 23 393 53 394 52 393 74 393 76 393 93 393 100 392 1 407 65 154 8874 809 4100 714 0 132 7 401 10 401 0 367 0 368 64 10 368 401 812 83 3146 299 33 285 23 286 11 285 20 308 83 296 565 299 768 299

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