hospitals_state

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

37 rows where previous_day_admission_pediatric_covid_confirmed_5_11 = 9 sorted by critical_staffing_shortage_today_yes

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: critical_staffing_shortage_today_not_reported, critical_staffing_shortage_anticipated_within_week_no, hospital_onset_covid_coverage, inpatient_beds_used_coverage, inpatient_beds_used_covid_coverage, previous_day_admission_adult_covid_confirmed_coverage, previous_day_admission_adult_covid_suspected_coverage, previous_day_admission_pediatric_covid_confirmed_coverage, staffed_icu_adult_patients_confirmed_and_suspected_covid_coverage, total_adult_patients_hospitalized_confirmed_covid_coverage, adult_icu_bed_covid_utilization_coverage, adult_icu_bed_utilization_coverage, previous_day_admission_adult_covid_confirmed_18-19_coverage, previous_day_admission_adult_covid_suspected_30-39, previous_day_admission_adult_covid_suspected_70-79, previous_day_admission_adult_covid_suspected_unknown, on_hand_supply_therapeutic_c_bamlanivimab_etesevimab_courses, previous_week_therapeutic_b_bamlanivimab_courses_used, icu_patients_confirmed_influenza, previous_day_admission_influenza_confirmed, previous_day_deaths_covid_and_influenza, previous_day_deaths_influenza, total_patients_hospitalized_confirmed_influenza_coverage, previous_day_admission_pediatric_covid_confirmed_0_4, previous_day_admission_pediatric_covid_confirmed_12_17, previous_day_admission_pediatric_covid_confirmed_unknown, staffed_icu_pediatric_patients_confirmed_covid, 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
46920 46920 NV 2022/03/02 0 4 56 0 4 56 54 58 8505 60 6727 60 380 58 31 60 80 58 7 58 17 58 663 60 89 58 79 60 347 58 286 60 33 58 6 58 804 60 0.790946502057613 60 6727 8505 0.057523463518014 58 380 6606 0.045405663759111 58 380 8369 0.114690721649485 58 89 776 0.824626865671642 60 663 804   0 60 3 60 2 60 2 60 4 60 5 60 7 60 8 60 0 60 2 58 15 58 5 58 6 58 10 58 13 58 14 58 15 58 0 58 0 4 282 0 536 15 0 0 1 58 4 58 0 2 0 2 9 2 2 58 478 58 642 58 7 58 0 58 9 58 0 58 2 58 81 58 111 58
29911 29911 NY 2022/06/28 2 163 14 6 159 14 304 170 44775 179 35799 179 2384 170 309 179 211 170 20 170 18 170 3262 179 220 170 177 179 2297 170 2005 179 87 170 60 170 4520 179 0.799530988274707 179 35799 44775 0.067119006728793 170 2384 35519 0.053846501332611 170 2384 44274 0.049728752260398 170 220 4424 0.721681415929204 179 3262 4520   2 174 19 159 28 160 23 160 37 160 51 160 49 161 92 161 8 178 0 168 22 150 29 150 14 150 32 150 41 152 30 149 25 149 18 169 2 51 8203 274 6864 8 0 0 3 170 7 170 0 34 0 34 35 1 34 170 1661 170 2418 170 9 170 0 150 9 150 2 170 14 170 372 170 509 170
32525 32525 OH 2022/09/09 2 65 133 8 74 118 42 196 26405 200 21273 200 1458 196 196 200 40 196 20 196 40 196 2678 200 177 196 156 200 1309 196 1164 200 149 196 53 196 3662 200 0.805642870668434 200 21273 26405 0.069194627687343 196 1458 21071 0.055868490631107 196 1458 26097 0.049303621169916 196 177 3590 0.731294374658656 200 2678 3662   2 198 12 197 17 197 9 197 14 198 42 197 47 198 51 197 0 200 1 196 0 193 7 193 2 193 4 193 9 193 8 193 7 193 0 196 1 46 1513 0 1820 0 0 0 62 196 4 196 0 46 0 46 468 0 46 196 1326 196 1919 195 9 196 2 192 9 193 0 196 7 196 379 196 531 196
22418 22418 TX 2022/06/25 4 106 484 8 102 484 122 589 63969 594 48820 594 2576 589 413 594 284 589 42 589 68 589 5154 594 339 589 303 594 2406 589 2087 594 170 589 111 589 5881 594 0.763182166361832 594 48820 63969 0.0534262485482 589 2576 48216 0.040738866396761 589 2576 63232 0.059059233449477 589 339 5740 0.876381567760585 594 5154 5881   5 592 32 589 36 589 37 589 47 589 59 589 83 589 96 589 29 594 3 587 15 584 21 584 26 585 37 584 50 584 44 584 45 584 43 589 8 581 351 0 114 0 0 0 8 589 18 589 0 105 0 105 104 10 105 589 3813 589 4416 589 24 587 9 583 9 584 0 589 20 589 945 589 1095 589
22142 22142 FL 2022/08/17 5 187 74 16 190 60 130 260 59593 266 46486 266 3865 260 600 266 191 260 59 260 49 260 4651 266 453 260 445 266 3759 260 3523 266 82 260 70 260 6519 266 0.780058060510463 266 46486 59593 0.084158954817637 260 3865 45925 0.065609669150724 260 3865 58909 0.070748086834296 260 453 6403 0.71345298358644 266 4651 6519   5 262 20 250 41 252 43 250 71 249 89 251 121 250 177 252 32 266 1 257 6 242 15 243 25 244 34 243 43 242 26 242 39 242 2 260 29 153 6898 1291 3870 842 0 62 9 260 13 260 0 140 0 140 66 8 143 260 1851 260 2786 260 10 259 9 243 9 244 37 259 13 260 601 260 902 260
24213 24213 TX 2022/08/31 6 83 494 9 80 494 110 578 64295 583 50291 583 3020 578 399 583 249 578 46 578 104 578 5228 583 424 578 376 583 2750 578 2419 583 255 578 168 578 5886 583 0.782191461233377 583 50291 64295 0.060798840392978 578 3020 49672 0.047502949272513 578 3020 63575 0.073790462930734 578 424 5746 0.888209310227659 583 5228 5886   10 583 30 580 30 580 37 580 50 580 64 580 75 580 89 580 16 583 3 578 20 575 30 575 24 575 35 575 48 575 54 575 27 575 8 578 15 575 1873 660 686 0 0 0 5 578 7 578 0 96 0 96 52 6 96 578 3949 578 4331 578 23 578 14 575 9 575 0 578 34 578 954 578 1034 578
27688 27688 TX 2022/06/20 6 79 417 9 76 417 91 497 57608 502 43465 502 2341 497 306 502 231 497 32 497 56 497 5010 502 340 497 271 502 2204 497 1820 502 155 497 91 497 5854 502 0.754495903346757 502 43465 57608 0.054517931998137 497 2341 42940 0.041163334564189 497 2341 56871 0.05952380952381 497 340 5712 0.855825076870516 502 5010 5854   1 500 21 499 24 499 28 499 35 499 51 499 66 499 70 499 11 502 3 495 20 494 23 494 22 495 39 495 49 494 36 494 34 494 5 497 15 492 328 0 85 0 0 0 8 497 17 497 0 91 0 91 118 11 91 497 3307 496 3885 496 18 495 5 494 9 494 0 497 21 497 909 497 1064 496
27842 27842 CA 2022/07/26 6 94 272 114 219 39 127 363 61561 372 48057 372 5181 364 708 372 434 364 32 364 10 364 4846 372 530 364 521 372 5008 364 4756 372 173 364 165 363 6705 372 0.780640340475301 372 48057 61561 0.10920242812579 364 5181 47444 0.085185794146662 364 5181 60820 0.0809902200489 364 530 6544 0.722744220730798 372 4846 6705   6 372 46 370 77 370 51 370 83 370 122 369 139 370 183 370 1 371 2 364 25 362 40 362 28 361 56 362 67 362 62 362 153 362 1 364 17 108 7993 1106 3117 364 0 0 15 364 5 364 2 336 2 336 51 9 336 364 2191 364 3590 364 18 364 5 362 9 360 0 362 34 363 620 364 955 364
30442 30442 TX 2022/06/17 6 106 482 8 104 482 103 589 65471 594 50115 594 2193 589 310 594 257 589 29 589 66 589 5302 594 327 589 282 594 2020 589 1662 594 173 589 89 589 6028 594 0.765453406851889 594 50115 65471 0.0442690459849 589 2193 49538 0.033876573723643 589 2193 64735 0.055555555555556 589 327 5886 0.87956204379562 594 5302 6028   2 592 28 592 22 592 23 592 38 592 56 592 73 592 64 592 8 594 3 587 24 587 17 587 28 587 40 587 52 587 49 587 43 587 1 589 7 581 337 0 114 0 0 0 11 589 29 589 0 107 0 107 131 9 107 589 3875 588 4351 588 14 587 6 586 9 586 0 589 20 589 968 589 1092 588
23372 23372 CA 2022/06/14 7 106 259 103 230 39 71 364 61268 372 47130 372 3111 364 495 372 403 364 28 364 15 364 4693 372 310 364 286 372 2978 364 2722 372 133 364 113 363 6634 372 0.769243324410785 372 47130 61268 0.066862964236589 364 3111 46528 0.051399398605558 364 3111 60526 0.04783950617284 364 310 6480 0.707416340066325 372 4693 6634   2 371 51 369 47 368 48 368 50 367 69 368 99 368 129 369 1 371 4 364 35 360 43 360 47 360 46 359 77 360 81 360 70 360 0 364 4 107 8149 1085 3338 308 0 0 13 364 60 364 1 320 2 320 227 21 320 364 2285 364 3589 364 14 364 5 359 9 358 0 362 22 363 590 364 917 364
26483 26483 CA 2022/08/19 7 116 280 108 256 39 64 395 63902 403 50058 403 3932 395 528 403 313 395 23 395 13 395 4795 403 425 395 399 403 3784 395 3493 403 148 395 140 394 6709 403 0.783355763512879 403 50058 63902 0.07953074433657 395 3932 49440 0.062289108910891 395 3932 63125 0.064826113483832 395 425 6556 0.714711581457743 403 4795 6709   3 401 30 393 58 393 36 393 61 393 95 393 120 394 126 393 0 399 2 393 33 386 24 386 20 386 52 386 64 386 65 387 53 386 0 395 6 118 8268 926 3114 305 0 1 5 394 8 394 0 347 41 347 28 4 347 394 2434 395 3799 395 10 391 4 387 9 381 0 391 41 394 640 395 968 395
30257 30257 CA 2022/08/24 7 229 153 91 239 59 76 381 62853 389 49484 389 3618 357 521 389 326 381 34 380 14 349 4776 362 401 355 357 363 3462 357 3183 365 156 354 148 354 6541 363 0.787297344597712 389 49484 62853 0.07648401826484 357 3618 47304 0.060507743251831 357 3618 59794 0.062941453460995 354 401 6371 0.732290708371665 362 4776 6522   5 352 43 386 63 349 47 350 59 351 91 350 103 350 119 351 1 359 1 346 24 340 37 340 34 340 58 341 71 341 69 341 43 340 1 350 11 144 8644 2298 3685 403 0 1 8 353 9 353 0 117 0 303 29 9 304 353 2452 379 4504 379 12 342 13 378 9 338 0 351 60 352 694 351 993 351
32913 32913 TX 2022/08/16 7 78 416 10 75 416 120 496 58754 501 46093 501 3587 496 510 501 261 496 26 496 81 496 5329 501 532 496 503 501 3362 496 3039 501 225 496 149 496 6009 501 0.784508288797358 501 46093 58754 0.078906267185816 496 3587 45459 0.061828837369646 496 3587 58015 0.090614886731392 496 532 5871 0.886836412048594 501 5329 6009   4 499 33 495 35 495 56 495 57 495 97 495 97 495 145 494 14 501 2 494 15 490 28 491 22 491 48 490 49 490 65 490 27 490 5 496 20 491 321 0 86 0 0 0 7 496 17 496 0 91 0 91 77 10 91 496 3413 496 4051 496 16 494 11 490 9 490 0 496 31 496 866 496 1050 496
34718 34718 CA 2022/07/25 7 95 272 112 224 38 112 366 60991 374 46583 374 5149 366 626 374 283 366 33 366 5 366 4652 374 514 366 509 374 4969 366 4732 374 180 366 171 365 6673 374 0.763768424849568 374 46583 60991 0.111922617106836 366 5149 46005 0.085459162503527 366 5149 60251 0.07894332667793 366 514 6511 0.697137719166792 374 4652 6673   3 374 45 372 60 372 45 371 77 372 98 370 143 372 152 372 5 373 5 366 19 363 33 363 21 363 40 363 54 364 47 363 64 363 0 366 6 108 8000 1100 3144 305 0 0 13 366 9 366 3 336 3 336 50 6 336 366 2035 366 3592 366 17 365 7 364 9 359 0 364 35 365 592 366 949 366
45169 45169 TX 2022/02/26 7 110 477 10 107 477 107 589 65851 594 49637 594 4353 589 394 594 309 589 30 589 102 589 5832 594 991 589 948 594 4156 589 3673 594 197 589 154 589 6520 594 0.753777467312569 594 49637 65851 0.088691931540342 589 4353 49080 0.066860197216846 589 4353 65106 0.155842113539865 589 991 6359 0.894478527607362 594 5832 6520   4 590 20 587 27 588 32 588 46 588 91 588 103 589 55 588 16 594 4 586 25 582 32 583 37 584 43 584 53 583 48 583 44 583 23 589 47 582 314 0 114 12 0 6 26 589 51 589 0 110 0 110 176 4 110 589 3692 589 4239 589 11 586 10 582 9 581 0 589 28 588 964 589 1099 589
26434 26434 FL 2022/05/28 8 191 72 34 176 61 93 265 60094 271 44907 271 2458 265 425 271 242 265 54 265 58 265 4602 271 219 265 194 271 2382 265 2073 271 76 265 58 265 6509 271 0.747279262488768 271 44907 60094 0.055511642087671 265 2458 44279 0.041504145348935 265 2458 59223 0.03448275862069 265 219 6351 0.707021047779997 271 4602 6509   2 265 29 257 29 257 40 260 37 259 80 260 84 261 119 261 5 271 0 262 12 251 24 251 24 251 28 250 46 252 54 251 43 251 11 265 14 153 4167 0 2787 1219 10 208 24 265 86 265 0 141 1 141 278 9 141 265 1885 265 2867 265 7 265 6 251 9 252 32 263 8 265 623 265 912 265
31191 31191 FL 2022/06/12 8 186 75 35 173 61 110 263 60084 269 44480 269 3219 263 498 269 232 263 59 263 53 263 4479 269 323 263 314 269 3131 263 2846 269 88 263 72 263 6520 269 0.740296917648625 269 44480 60084 0.073422745312714 263 3219 43842 0.054349294252718 263 3219 59228 0.050770198050927 263 323 6362 0.686963190184049 269 4479 6520   2 264 26 258 40 258 35 258 47 259 88 260 122 259 127 262 17 269 1 261 9 251 17 251 23 250 33 251 39 250 56 250 48 251 5 263 18 151 4065 0 2691 1219 0 338 24 263 59 263 0 141 1 141 297 11 144 263 1827 263 2829 263 13 263 7 252 9 252 30 261 12 263 644 263 908 263
31424 31424 CA 2022/08/18 8 114 281 113 251 39 64 395 63960 403 50297 403 3993 395 510 403 361 395 31 395 14 395 4820 403 435 395 405 403 3846 395 3516 403 147 395 141 394 6706 403 0.786382113821138 403 50297 63960 0.080377631949756 395 3993 49678 0.06321538826882 395 3993 63165 0.066442645486482 395 435 6547 0.71875932001193 403 4820 6706   8 402 30 394 50 394 34 394 66 393 86 394 114 394 121 394 3 399 2 395 30 387 25 387 29 387 45 386 72 387 80 387 78 387 0 395 5 120 8258 926 3114 305 0 1 5 394 7 394 1 350 1 350 26 5 350 394 2433 395 3761 395 15 393 7 387 9 382 0 391 33 394 657 395 977 395
33782 33782 CA 2022/07/13 8 141 263 104 274 34 80 404 65015 412 50672 412 4812 404 762 412 377 404 34 403 10 403 4856 412 476 404 475 412 4614 404 4333 412 198 404 178 403 6545 412 0.779389371683458 412 50672 65015 0.096166913146009 404 4812 50038 0.074872800261401 404 4812 64269 0.074526381712854 404 476 6387 0.741940412528648 412 4856 6545   8 409 56 400 89 398 64 398 67 398 140 399 139 399 203 398 1 410 9 402 27 392 43 391 34 391 61 391 68 391 79 391 56 390 0 404 10 137 10249 1788 3898 305 0 0 13 404 17 404 0 352 0 352 80 7 352 404 2416 403 3597 403 18 402 7 384 9 384 0 400 36 402 637 403 916 403
35748 35748 FL 2022/02/15 8 163 72 38 144 61 183 237 57219 243 46779 243 5123 237 640 243 217 237 39 237 24 237 5269 243 844 237 834 243 5005 237 4683 243 118 237 101 237 6632 243 0.817543123787553 243 46779 57219 0.111251058654911 237 5123 46049 0.090984974958264 237 5123 56306 0.130508736663059 237 844 6467 0.794481302774427 243 5269 6632   7 237 27 231 33 230 35 233 75 234 136 234 157 233 137 233 33 243 2 233 9 224 12 224 19 224 28 225 41 225 47 224 48 225 11 237 32 130 3966 69 3167 1448 237 318 5 237 8 237 0 123 1 123 63 7 123 237 1785 237 2615 237 12 236 14 225 9 225 4 237 19 237 588 237 870 237
31243 31243 CA 2022/08/12 9 126 275 114 257 39 85 402 64273 410 50514 410 4346 402 542 410 321 402 30 401 10 400 4858 410 458 402 436 410 4185 402 3874 410 161 402 147 401 6685 410 0.785928772579466 410 50514 64273 0.087099424815119 402 4346 49897 0.068433401042405 402 4346 63507 0.07015931372549 402 458 6528 0.726701570680628 410 4858 6685   2 405 32 392 65 394 36 394 75 394 98 395 86 393 146 395 2 408 2 400 19 386 38 386 25 387 61 387 61 387 54 387 61 387 0 401 8 122 8361 961 3191 305 0 1 5 402 9 402 0 346 0 346 36 8 347 402 2433 401 3771 401 15 399 4 388 9 383 2 398 31 399 658 401 973 401
35674 35674 FL 2022/01/29 9 190 72 38 172 61 310 265 60588 271 48097 271 9195 265 1349 271 234 265 99 265 51 265 5485 271 1428 265 1424 271 8971 265 8642 271 224 265 200 265 6639 271 0.793837063444907 271 48097 60588 0.194065131592833 265 9195 47381 0.154128532636025 265 9195 59658 0.220574606116775 265 1428 6474 0.826178641361651 271 5485 6639   6 262 68 257 102 259 86 256 173 257 246 258 286 261 332 259 56 271 2 258 9 248 28 250 17 248 30 248 46 248 46 249 46 251 10 265 61 157 3880 134 3082 2005 237 472 11 248 5 248 0 143 0 143 77 19 143 253 1390 164 1756 163 22 167 26 162 9 163 42 203 30 162 408 161 582 163
35902 35902 TX 2022/03/20 9 109 478 11 107 478 98 591 64077 596 46511 596 1863 591 149 596 324 591 16 591 48 591 5108 596 407 591 364 596 1765 591 1393 596 98 591 70 591 5963 596 0.72586107339607 596 46511 64077 0.040546716869437 591 1863 45947 0.029413622154157 591 1863 63338 0.070051635111876 591 407 5810 0.856615797417407 596 5108 5963   0 594 9 591 10 591 18 590 25 590 29 590 33 590 21 590 4 596 6 589 15 586 28 586 33 586 42 586 65 586 55 586 41 585 39 591 17 584 293 1 114 0 0 0 31 591 93 591 0 112 0 112 313 3 112 591 3360 591 3983 591 4 589 3 585 9 585 0 591 16 591 831 591 1000 591
36525 36525 TX 2022/03/07 9 82 413 10 81 413 89 499 59780 504 45425 504 3057 499 247 504 323 499 27 499 78 499 5456 504 725 499 686 504 2912 499 2473 504 145 499 109 499 6252 504 0.759869521579124 504 45425 59780 0.068209201660047 499 3057 44818 0.05177319378112 499 3057 59046 0.118930446194226 499 725 6096 0.872680742162508 504 5456 6252   1 502 17 499 23 499 25 499 34 499 45 499 39 499 50 499 13 504 5 497 25 494 36 494 36 495 46 494 52 494 64 494 54 494 5 499 27 494 265 0 85 0 0 3 21 499 61 499 0 96 0 96 208 2 96 499 3346 499 3997 499 13 497 5 494 9 494 0 499 16 499 796 499 981 499
37263 37263 FL 2022/02/13 9 190 72 40 170 61 181 265 60149 271 46433 271 5436 265 641 271 239 265 71 265 13 265 5071 271 896 265 892 271 5306 265 4979 271 130 265 117 265 6587 271 0.77196628372874 271 46433 60149 0.118814478055604 265 5436 45752 0.091788663188288 265 5436 59223 0.13952039862971 265 896 6422 0.76984970396235 271 5071 6587   3 262 36 259 36 259 36 261 72 263 126 263 160 262 157 259 23 271 2 263 16 254 27 255 16 253 35 254 56 252 48 253 35 252 4 265 47 151 3884 95 3147 1448 237 318 6 265 6 265 0 138 1 138 73 11 138 265 1745 265 2840 265 14 263 16 256 9 254 32 265 19 265 577 265 866 265
37348 37348 TX 2022/03/19 9 109 478 11 107 478 98 591 64735 596 47578 596 1936 591 176 596 398 591 20 591 47 591 5113 596 431 591 387 596 1836 591 1439 596 100 591 73 591 6021 596 0.734965629103267 596 47578 64735 0.041195871901266 591 1936 46995 0.030251890743171 591 1936 63996 0.073449216087253 591 431 5868 0.849194485965786 596 5113 6021   3 594 12 591 10 591 18 590 30 590 42 590 33 590 24 590 4 596 4 589 26 586 30 586 33 587 54 586 81 586 64 586 59 585 47 591 20 584 293 1 114 0 0 0 33 591 116 591 0 112 0 112 322 3 112 591 3506 591 4094 591 9 589 2 585 9 585 0 591 13 591 844 591 999 591
40649 40649 CA 2022/02/20 9 140 266 128 251 36 86 407 65669 415 50188 415 6341 407 521 415 368 407 25 398 13 403 5277 415 1154 407 1139 415 6139 407 5759 415 186 407 174 406 6938 415 0.764257107615465 415 50188 65669 0.127773187982348 407 6341 49627 0.097704160246533 407 6341 64900 0.170281835620481 407 1154 6777 0.760593831075238 415 5277 6938   7 408 60 400 48 398 46 398 73 397 82 397 88 397 116 397 1 412 5 403 28 391 38 390 39 390 57 390 64 390 70 389 67 390 0 406 37 130 8615 782 3337 311 0 6 4 406 4 406 0 346 0 346 39 2 347 406 2313 404 3723 404 14 397 2 387 9 387 0 396 38 403 649 404 917 404
46061 46061 TX 2022/03/03 9 110 476 11 108 476 172 590 68415 595 53252 595 3637 590 351 595 347 590 28 590 89 590 5748 595 795 590 751 595 3474 590 3004 595 163 590 117 590 6428 595 0.778367317108821 595 53252 68415 0.069120833174959 590 3637 52618 0.053738179669031 590 3637 67680 0.126733620277379 590 795 6273 0.894212818917237 595 5748 6428   3 593 27 588 24 588 34 588 46 588 75 588 75 588 55 588 12 595 3 588 32 583 41 583 35 584 62 583 52 583 65 583 52 583 5 590 47 585 315 0 176 1976 0 0 23 590 50 590 0 110 1 110 183 5 110 590 3921 590 4450 590 13 588 6 582 9 582 0 590 22 590 955 590 1101 590
35353 35353 TX 2022/03/12 10 110 476 12 108 476 114 591 66077 596 49440 596 2396 591 229 596 314 591 19 591 61 591 5459 596 520 591 485 596 2273 591 1860 596 123 591 80 591 6250 596 0.748217988104787 596 49440 66077 0.049036060742499 591 2396 48862 0.036673656498247 591 2396 65333 0.085287846481876 591 520 6097 0.87344 596 5459 6250   1 594 13 590 19 590 25 590 33 590 40 589 52 589 37 589 9 596 4 589 27 585 34 585 39 586 46 586 57 585 58 585 37 585 12 591 23 584 314 0 114 0 0 0 30 591 67 591 0 116 0 116 252 3 116 591 3738 591 4351 591 5 589 5 584 9 584 0 591 15 591 894 591 1058 591
37803 37803 TX 2022/03/02 10 110 475 11 109 475 101 590 66577 595 51416 595 3596 590 359 595 343 590 29 590 63 590 5891 595 852 590 815 595 3425 590 3079 595 171 590 128 590 6552 595 0.772278714871502 595 51416 66577 0.07080970384373 590 3596 50784 0.054623061382589 590 3596 65833 0.133291614518148 590 852 6392 0.899114774114774 595 5891 6552   4 595 25 591 33 591 29 591 47 591 77 591 73 591 57 591 14 595 2 590 37 586 35 586 35 586 54 586 71 586 57 586 46 586 6 590 47 587 2756 701 1453 0 0 0 23 590 34 590 0 112 1 112 139 6 112 590 3822 590 4359 590 13 590 7 585 9 585 0 590 25 590 933 590 1091 590
41570 41570 TX 2022/03/04 10 109 476 11 108 476 104 590 67158 595 51698 595 3350 590 315 595 327 590 25 590 77 590 5604 595 733 590 703 595 3188 590 2797 595 162 590 111 590 6445 595 0.769796599064892 595 51698 67158 0.065588534732555 590 3350 51076 0.050434337503576 590 3350 66423 0.116534181240064 590 733 6290 0.869511249030256 595 5604 6445   1 592 18 588 33 588 25 588 48 588 70 588 56 588 51 589 13 595 6 588 28 583 25 583 33 584 42 583 54 583 68 583 63 582 8 590 36 584 315 1 176 1976 0 0 23 590 62 590 0 109 0 109 199 2 109 590 3973 590 4524 590 10 588 6 582 9 582 0 590 18 590 956 590 1107 590
42889 42889 TX 2022/03/23 10 106 478 12 104 478 76 589 66101 594 50406 594 1683 589 198 594 359 589 20 589 55 589 5419 594 344 589 303 594 1583 589 1242 594 100 589 59 589 6104 594 0.762560324352128 594 50406 66101 0.033811475409836 589 1683 49776 0.025748118230218 589 1683 65364 0.05781512605042 589 344 5950 0.887778505897772 594 5419 6104   1 594 7 593 14 593 26 593 31 593 23 593 24 593 27 593 45 594 4 589 27 588 35 588 40 588 45 588 70 588 50 588 47 588 41 589 17 585 2775 670 1289 0 0 0 28 589 76 589 0 112 0 112 254 6 112 589 3674 589 4227 589 6 589 5 587 9 587 0 589 13 589 870 589 1021 589
40598 40598 CA 2022/02/12 11 142 262 130 250 35 159 407 66878 415 53112 415 8975 407 960 415 514 407 33 399 21 404 5813 415 1700 407 1653 415 8700 407 8343 415 259 407 237 406 7218 415 0.794162504859595 415 53112 66878 0.170962150218108 407 8975 52497 0.135770906450442 407 8975 66104 0.240963855421687 407 1700 7055 0.805347741756719 415 5813 7218   7 411 76 402 111 402 82 402 111 402 191 401 171 400 209 402 2 411 8 403 21 394 49 393 50 393 75 393 114 394 112 392 85 392 0 407 46 135 8402 617 3493 310 0 16 4 407 3 407 1 347 1 348 42 3 348 407 2430 404 3712 404 14 396 10 389 9 389 0 398 54 403 663 404 943 404
38671 38671 TX 2022/02/20 12 106 477 14 104 477 116 590 65610 595 49691 595 5830 590 456 595 282 590 39 590 92 590 5793 595 1373 590 1329 595 5572 590 5135 595 246 590 185 590 6452 595 0.757369303459838 595 49691 65610 0.118667182315944 590 5830 49129 0.089898382445914 590 5830 64851 0.218700223000956 590 1373 6278 0.8978611283323 595 5793 6452   1 593 25 589 48 589 47 589 45 589 89 589 84 589 87 589 30 595 3 588 23 584 27 584 36 585 44 585 49 584 51 584 45 584 4 590 73 581 362 1 35 2 0 0 19 590 46 590 0 108 1 108 176 8 108 590 3759 590 4306 590 12 588 18 583 9 583 0 590 43 590 965 590 1130 590
40805 40805 TX 2022/02/24 12 108 474 13 107 474 107 589 66971 594 52539 594 4902 589 470 594 353 589 38 588 93 589 6042 594 1148 589 1112 594 4682 589 4193 594 220 589 168 589 6596 594 0.78450374042496 594 52539 66971 0.094392667334206 589 4902 51932 0.074024856163453 589 4902 66221 0.178399378399378 589 1148 6435 0.916009702850212 594 6042 6596   3 591 26 587 47 588 44 588 63 588 103 588 80 588 79 588 25 594 3 586 40 582 25 583 42 584 54 583 64 583 74 583 51 583 0 589 59 582 375 1 147 12 0 6 25 589 46 589 0 111 0 111 185 6 111 589 3911 589 4388 589 17 586 12 582 9 581 0 588 35 588 966 589 1105 589
20012 20012 GA 2023/01/24 20 54 72 25 79 42 61 143 20202 146 16188 146 1385 143 120 146 128 146 8 143 17 143 2011 146 199 143 147 146 1359 143 997 146 42 143 29 143 2533 146 0.801306801306801 146 16188 20202 0.086719679418947 143 1385 15971 0.069458375125376 143 1385 19940 0.080209592906086 143 199 2481 0.793920252664824 146 2011 2533   0 146 8 143 6 143 7 143 11 143 22 143 29 143 28 143 25 146 2 146 5 143 14 143 14 143 24 143 30 143 21 143 17 143 1 146 6 81 1827 833 1521 1 0 2 83 146 10 146 0 94 1 95 150 6 94 146 895 143 1363 143 15 143 5 140 9 140 2 142 8 143 254 142 351 143
33463 33463 GA 2022/08/14 26 104 36 31 100 35 51 163 22184 166 17493 166 1726 163 176 166 73 163 19 163 69 163 2014 166 219 163 181 166 1624 163 1318 166 102 162 51 162 2602 166 0.788541291020555 166 17493 22184 0.09971691027789 163 1726 17309 0.078704970360237 163 1726 21930 0.085848686789494 163 219 2551 0.77401998462721 166 2014 2602   0 164 15 158 13 159 13 158 8 158 30 158 32 158 31 88 38 166 1 162 6 155 7 155 4 155 8 154 13 155 12 155 2 85 20 163 3 103 2957 1669 3461 17 0 13 33 163 3 163 0 119 0 119 20 2 119 163 1085 163 1643 163 8 163 2 154 9 154 0 162 15 162 304 151 393 163

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