hospitals_state

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

24 rows where previous_day_admission_pediatric_covid_confirmed_5_11 = 10 sorted by total_pediatric_patients_hospitalized_confirmed_covid_coverage

View and edit SQL

Suggested facets: critical_staffing_shortage_today_yes, critical_staffing_shortage_anticipated_within_week_yes, critical_staffing_shortage_anticipated_within_week_not_reported, inpatient_beds_used_coverage, previous_day_admission_adult_covid_confirmed_coverage, previous_day_admission_adult_covid_suspected_coverage, previous_day_admission_pediatric_covid_suspected, staffed_icu_adult_patients_confirmed_covid_coverage, total_adult_patients_hospitalized_confirmed_and_suspected_covid_coverage, total_adult_patients_hospitalized_confirmed_covid_coverage, total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_coverage, total_pediatric_patients_hospitalized_confirmed_covid_coverage, adult_icu_bed_covid_utilization_coverage, adult_icu_bed_covid_utilization_denominator, adult_icu_bed_utilization_coverage, adult_icu_bed_utilization_denominator, previous_day_admission_adult_covid_confirmed_18-19, previous_day_admission_adult_covid_confirmed_20-29_coverage, previous_day_admission_adult_covid_confirmed_50-59, previous_day_admission_adult_covid_confirmed_70-79, previous_day_admission_adult_covid_confirmed_70-79_coverage, previous_day_admission_adult_covid_confirmed_unknown, previous_day_admission_adult_covid_suspected_18-19_coverage, previous_day_admission_adult_covid_suspected_30-39, previous_day_admission_adult_covid_suspected_50-59, previous_day_admission_adult_covid_suspected_60-69, previous_day_admission_adult_covid_suspected_80+_coverage, on_hand_supply_therapeutic_c_bamlanivimab_etesevimab_courses, previous_week_therapeutic_c_bamlanivimab_etesevimab_courses_used, icu_patients_confirmed_influenza_coverage, previous_day_deaths_covid_and_influenza, previous_day_deaths_influenza, total_patients_hospitalized_confirmed_influenza, total_patients_hospitalized_confirmed_influenza_and_covid, total_patients_hospitalized_confirmed_influenza_coverage, all_pediatric_inpatient_beds_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

previous_day_admission_adult_covid_confirmed_unknown_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
28192 PR 2022/06/11 0 12 54 2 16 48 4 65 8932 64 5991 65 411 65 43 66 22 63 20 65 2 63 507 65 38 65 25 66 358 65 328 66 53 65 49 65 677 64 0.652149574563368 64 5825 8932 0.070088676671214 64 411 5864 0.045957349754818 63 403 8769 0.058551617873652 63 38 649 0.748892171344165 64 507 677   1 65 3 64 3 64 6 65 5 64 12 64 4 64 6 65 3 66 3 63 1 61 0 61 1 61 1 61 5 61 1 61 2 61 8 63 2 6 0 10 66 0 0 0 2 65 2 65 0 5 0 5 22 1 5 65 490 65 1285 64 11 65 1 63 10 62 0 65 1 65 22 65 86 64
34620 FL 2022/07/18 7 158 75 33 146 61 137 234 54944 240 42029 240 4520 234 664 240 212 234 30 234 11 234 4560 240 452 234 441 240 4413 234 4194 240 107 234 94 234 6498 240 0.764942486895748 240 42029 54944 0.108944539516498 234 4520 41489 0.083284198113208 234 4520 54272 0.070846394984326 234 452 6380 0.701754385964912 240 4560 6498   3 236 40 228 45 228 37 228 78 226 94 230 148 229 190 231 41 240 4 232 17 222 12 221 24 221 29 221 45 222 40 221 39 223 2 234 25 131 4467 0 3069 1184 0 143 8 234 13 234 0 126 0 126 114 11 129 234 1674 234 2585 234 18 234 7 221 10 222 1 232 26 234 662 234 906 234
24220 FL 2022/01/17 11 161 72 43 140 61 337 238 56550 244 46457 244 11729 238 1709 244 206 238 65 238 18 238 5381 244 1597 238 1616 244 11483 238 11273 244 246 238 220 238 6516 244 0.821520778072502 244 46457 56550 0.256691396931696 238 11729 45693 0.210930475128583 238 11729 55606 0.251416876574307 238 1597 6352 0.825813382443217 244 5381 6516   14 233 86 231 136 232 117 233 206 231 343 235 355 233 379 233 67 244 4 234 13 223 21 224 24 223 27 224 39 223 39 224 34 224 4 238 67 149 5088 450 3711 1596 0 373 13 225 14 225 0 136 1 136 103 25 136 225 673 104 949 104 8 110 5 107 10 106 36 156 24 103 179 104 244 104
25179 FL 2022/07/03 9 185 75 35 173 61 103 263 59690 269 43571 269 3732 263 606 269 175 263 52 263 41 263 4400 269 401 263 393 269 3646 263 3449 269 86 263 74 263 6505 269 0.729954766292511 269 43571 59690 0.086816944657687 263 3732 42987 0.063420851389243 263 3732 58845 0.063129722921914 263 401 6352 0.676402767102229 269 4400 6505   3 265 29 254 39 255 38 255 63 255 114 256 148 254 169 256 22 269 1 260 13 248 10 247 11 248 32 247 39 247 32 248 32 247 5 263 24 150 4053 0 2553 1184 0 228 18 263 22 263 0 138 0 138 139 10 141 263 1708 263 2800 263 7 261 5 247 10 246 30 261 9 263 631 263 894 263
22699 FL 2022/02/02 4 196 71 40 171 60 262 265 60690 271 49506 271 8428 265 1163 271 301 265 73 265 20 265 5525 271 1299 265 1300 271 8237 265 7870 271 191 265 171 265 6648 271 0.815719228868018 271 49506 60690 0.17297075423294 265 8428 48725 0.141021350645874 265 8428 59764 0.200370198981953 265 1299 6483 0.831077015643803 271 5525 6648   6 262 62 256 80 258 60 258 126 259 215 260 253 259 277 262 84 271 1 261 21 248 28 250 21 250 37 250 63 249 68 249 57 250 5 265 70 153 6576 1954 5443 1856 0 889 9 265 14 265 0 138 0 138 80 13 138 265 1839 265 2809 265 26 263 30 251 10 252 7 265 33 264 582 265 874 265
31736 FL 2022/02/03 8 191 72 40 170 61 265 265 60724 271 49733 271 8142 265 1186 271 307 265 64 265 21 265 5491 271 1250 265 1251 271 7963 265 7591 271 179 265 158 265 6643 271 0.819000724589948 271 49733 60724 0.166251480377343 265 8142 48974 0.136131081758903 265 8142 59810 0.192960790367397 265 1250 6478 0.82658437452958 271 5491 6643   1 261 58 254 72 257 89 257 135 258 238 259 260 257 279 260 59 271 1 259 21 248 41 249 27 248 39 250 47 250 64 250 62 250 6 265 55 154 4132 69 3301 1581 237 318 9 265 11 265 0 138 0 138 81 11 138 265 1909 265 2811 265 19 264 26 251 10 251 9 265 27 264 617 265 890 265
34308 FL 2022/01/26 10 189 72 42 168 61 319 265 60643 271 50123 271 10370 265 1505 271 262 265 95 265 47 265 5594 271 1491 265 1489 271 10163 265 9770 271 207 265 185 265 6588 271 0.826525732566001 271 50123 60643 0.210084884828103 265 10370 49361 0.173637855396671 265 10370 59722 0.232134516581037 265 1491 6423 0.849119611414693 271 5594 6588   8 259 82 254 103 257 105 255 178 254 278 258 339 258 342 260 70 271 0 260 9 246 27 250 29 246 39 244 55 247 54 247 48 247 1 265 68 163 7872 1415 5304 668 0 792 8 250 12 250 0 147 0 147 94 20 147 255 888 120 1171 120 7 140 9 135 10 136 69 190 16 126 263 122 324 121
25412 CA 2022/06/07 7 95 271 106 228 39 75 365 61275 373 47122 373 2980 365 493 373 534 365 28 365 19 365 4701 373 301 365 278 373 2849 365 2541 373 131 365 107 364 6673 373 0.769024887800898 373 47122 61275 0.064019936409728 365 2980 46548 0.049214711565457 365 2980 60551 0.046102006432838 365 301 6529 0.704480743293871 373 4701 6673   4 371 37 369 36 369 39 369 63 369 82 370 97 371 134 369 3 372 8 364 28 361 46 361 33 361 62 361 87 361 79 361 191 362 0 365 1 107 8381 1082 3482 308 0 0 22 365 72 365 0 334 0 334 283 18 334 365 2324 365 3556 365 11 364 7 361 10 358 0 363 29 364 645 365 932 365
18162 CA 2022/08/22 8 90 278 109 229 38 79 368 61290 376 46563 376 3872 368 482 376 238 368 24 368 19 368 4577 376 417 368 388 376 3710 368 3427 376 147 368 138 367 6648 376 0.759716103768967 376 46563 61290 0.084252670975042 368 3872 45957 0.063991538308984 368 3872 60508 0.064282410975798 368 417 6487 0.688477737665463 376 4577 6648   2 374 37 373 68 373 31 373 46 373 75 373 87 374 123 373 3 373 4 366 20 366 21 367 23 366 31 365 43 365 44 365 52 365 0 368 4 107 8748 967 3205 305 0 1 3 368 4 368 1 342 1 342 23 9 342 368 2242 368 3618 368 7 365 7 367 10 362 0 365 37 367 641 368 949 368
27638 CA 2022/06/19 8 143 261 108 265 39 66 404 62795 412 47014 412 3130 404 433 412 265 404 26 402 5 403 4505 412 311 404 288 412 3036 404 2727 411 127 404 117 403 6574 412 0.748690182339358 412 47014 62795 0.067320514474986 404 3130 46494 0.050438313781101 404 3130 62056 0.048449914316872 404 311 6419 0.685275327045938 412 4505 6574   4 407 41 393 40 393 26 392 46 393 72 392 95 392 108 394 4 410 5 401 20 385 30 383 27 384 41 384 54 383 35 384 48 384 5 403 4 130 8033 700 3342 308 0 0 17 404 37 404 0 339 1 338 182 13 339 404 2360 403 3762 403 11 402 5 383 10 382 0 399 22 402 589 403 911 403
15995 CA 2022/08/05 9 122 283 114 260 40 119 406 64426 414 50331 414 4774 405 637 414 324 406 35 406 14 404 4860 413 504 405 486 413 4599 405 4308 413 175 405 157 404 6694 413 0.781221866948127 414 50331 64426 0.096021561607466 405 4774 49718 0.074985078377784 405 4774 63666 0.077111383108935 405 504 6536 0.726023304451748 413 4860 6694   5 411 49 402 68 402 38 402 69 402 111 402 134 402 161 402 4 410 2 403 24 395 35 395 20 394 61 395 65 395 53 395 64 395 0 405 8 120 8063 959 3131 305 0 1 5 404 8 404 1 355 1 355 33 3 355 404 2401 405 3711 405 18 402 7 396 10 390 0 401 39 403 627 404 950 404
33767 CA 2022/02/05 14 139 262 146 232 37 152 407 67028 415 53279 415 11519 407 1233 415 516 407 51 397 36 405 6060 415 2090 407 2067 415 11083 407 10759 414 399 407 362 406 7351 415 0.794876767917885 415 53279 67028 0.21871795845517 407 11519 52666 0.173884821495962 407 11519 66245 0.291005291005291 407 2090 7182 0.824377635695824 415 6060 7351   11 413 106 402 129 402 99 401 169 401 227 398 218 400 272 400 2 407 2 403 29 393 38 392 36 391 52 392 83 392 102 392 173 393 1 407 57 134 8548 617 3864 330 0 43 2 406 6 406 0 347 0 346 42 3 346 406 2236 405 3552 405 23 393 18 387 10 387 0 396 77 404 658 405 893 405
24043 CA 2022/01/28 19 123 274 153 225 38 214 408 67880 416 54976 416 15153 408 1847 416 453 408 78 399 29 407 6187 416 2521 408 2549 416 14668 408 14352 416 446 408 405 407 7441 416 0.809899823217443 416 54976 67880 0.278875883392226 408 15153 54336 0.225833854958419 408 15153 67098 0.346910692170084 408 2521 7267 0.8314742642118 416 6187 7441   23 411 153 405 197 403 154 403 232 403 380 401 334 401 370 402 4 407 2 404 38 398 45 395 51 395 65 395 85 394 90 393 75 394 2 408 80 146 8863 897 3518 389 0 16 3 403 4 403 0 369 0 368 48 5 368 403 834 108 3406 339 30 329 36 328 10 329 2 350 76 335 608 336 866 338
25906 CA 2022/01/29 19 138 259 144 235 37 237 408 67997 416 53951 416 14484 408 1639 416 421 408 66 399 24 407 6083 416 2497 408 2513 416 14078 408 13724 416 406 408 372 407 7261 416 0.793432063179258 416 53951 67997 0.271627627852896 408 14484 53323 0.215506851760925 408 14484 67209 0.352384984476432 408 2497 7086 0.837763393471974 416 6083 7261   20 410 140 403 157 401 133 401 217 399 304 400 343 400 320 400 5 407 2 404 44 396 37 394 43 393 48 393 86 392 76 392 84 392 1 408 70 160 8966 850 3557 400 0 16 5 403 6 403 0 366 0 366 44 8 366 403 854 119 3225 332 20 318 31 318 10 319 5 344 70 328 559 330 795 331
15600 TX 2022/09/05 6 74 417 9 71 417 108 492 56922 497 43384 497 2962 492 336 497 223 492 46 492 101 492 4833 497 402 492 364 497 2718 492 2386 497 244 492 151 492 5748 497 0.76216577070377 497 43384 56922 0.069160362379752 492 2962 42828 0.05270462633452 492 2962 56200 0.071708883339279 492 402 5606 0.840814196242171 497 4833 5748   6 496 26 493 29 493 27 493 38 493 53 493 61 493 90 493 18 497 5 491 19 488 19 488 15 488 29 488 43 488 45 488 41 488 7 492 10 490 321 0 85 0 0 0 11 492 13 492 0 90 0 90 84 9 90 492 3483 492 4022 492 29 491 7 488 10 488 0 492 28 492 943 492 1088 492
25494 TX 2022/02/28 10 80 414 11 79 414 95 499 59517 504 45020 504 4122 499 310 504 272 499 23 499 76 499 5544 504 947 499 901 504 3950 499 3486 504 172 499 135 499 6265 504 0.756422534737974 504 45020 59517 0.09269587118827 499 4122 44468 0.070139018870493 499 4122 58769 0.155169588726856 499 947 6103 0.884916201117318 504 5544 6265   5 502 16 500 17 500 29 500 33 500 60 500 74 500 59 500 17 504 6 497 23 495 23 495 29 496 49 495 52 495 52 495 36 495 2 499 35 494 265 1 85 12 0 6 30 499 53 499 0 95 0 95 171 7 95 499 3226 499 3848 499 8 497 5 495 10 495 0 499 26 498 873 499 1048 499
11997 TX 2022/08/18 6 94 486 10 90 486 134 581 65295 586 50858 586 3481 581 441 586 271 581 38 581 78 581 5352 586 537 581 494 586 3248 581 2913 586 233 581 157 581 6012 586 0.778895780687648 586 50858 65295 0.069292937335775 581 3481 50236 0.053912989607694 581 3481 64567 0.09143538225779 581 537 5873 0.890219560878244 586 5352 6012   6 584 38 581 40 581 39 581 57 581 85 581 103 581 97 581 21 586 3 579 24 576 22 577 22 577 35 576 60 576 61 576 41 576 3 581 22 575 349 0 114 0 0 0 7 581 22 581 0 99 0 99 83 9 99 581 3751 581 4354 581 26 579 13 575 10 575 0 581 31 581 887 581 1060 581
12713 TX 2022/08/10 7 107 478 9 105 478 117 587 64374 592 49738 592 3548 587 580 592 340 587 48 587 79 587 5305 592 512 587 473 592 3270 587 3057 592 248 587 184 587 5977 592 0.772641128405878 592 49738 64374 0.0722386236384 587 3548 49115 0.055744092508798 587 3548 63648 0.087686247645145 587 512 5839 0.887569014555797 592 5305 5977   5 591 35 588 36 588 46 588 70 588 108 588 121 589 123 588 63 592 2 586 17 583 19 583 31 583 40 583 65 583 63 584 49 583 54 587 25 581 7312 660 655 0 0 0 9 587 11 587 0 105 1 105 40 8 105 587 3576 587 4180 587 40 587 10 583 10 583 0 587 33 587 911 587 1091 587
23206 TX 2022/06/22 6 107 481 9 104 481 110 589 65177 594 50391 594 2381 589 399 594 236 589 37 589 77 589 5189 594 323 589 286 594 2232 589 1899 594 184 589 114 589 5908 594 0.77314083188855 594 50391 65177 0.047824689671795 589 2381 49786 0.036953687608642 589 2381 64432 0.056018036767256 589 323 5766 0.878300609343263 594 5189 5908   3 594 28 593 35 593 28 593 46 593 54 593 89 593 87 593 32 594 2 589 20 588 25 588 32 588 30 588 44 588 49 588 32 588 2 589 8 584 1936 660 588 1 0 0 11 589 11 589 0 106 0 106 62 13 106 589 3793 589 4272 589 18 589 9 586 10 587 0 589 35 589 961 589 1092 589
27598 TX 2022/02/23 11 108 475 12 107 475 112 589 66933 594 52645 594 4960 589 544 594 383 589 49 589 94 589 6024 594 1208 589 1159 594 4683 589 4359 594 261 589 179 589 6562 594 0.786532801458175 594 52645 66933 0.0953351144598 589 4960 52027 0.074961838983179 589 4960 66167 0.189104571070758 589 1208 6388 0.918012800975312 594 6024 6562   4 593 38 590 43 591 42 591 72 591 112 591 114 591 86 591 33 594 3 588 29 585 34 586 29 586 59 586 88 586 73 586 66 586 2 589 73 585 3864 702 1807 3 0 0 31 589 59 589 0 112 0 112 135 7 112 589 3878 589 4385 589 23 588 16 585 10 584 0 589 46 589 970 589 1110 589
33919 TX 2022/06/24 5 107 482 8 104 482 120 589 65225 594 50375 594 2505 589 447 594 282 589 32 589 78 589 5304 594 342 589 298 594 2314 589 2028 594 191 589 114 589 6033 594 0.772326561901112 594 50375 65225 0.050349734684033 589 2505 49752 0.038846243312398 589 2505 64485 0.058054659650314 589 342 5891 0.879164594728991 594 5304 6033   2 592 38 589 38 589 38 589 46 589 71 589 98 589 95 589 30 594 5 587 23 584 25 584 30 584 36 584 67 584 59 584 36 584 1 589 7 581 341 0 35 0 0 0 11 589 20 589 0 105 0 105 114 11 105 589 3858 589 4380 589 18 587 4 583 10 584 0 589 21 589 938 589 1084 589
32387 TX 2022/07/03 5 105 485 9 101 485 134 590 63432 595 46780 595 3025 590 413 595 232 590 48 590 67 590 4867 595 404 590 364 595 2819 590 2456 595 206 590 133 590 5729 595 0.737482658595031 595 46780 63432 0.065403991265054 590 3025 46251 0.048253309937789 590 3025 62690 0.072297780959198 590 404 5588 0.849537441089195 595 4867 5729   5 593 24 591 27 590 34 590 48 590 68 590 98 590 91 590 25 595 4 588 10 585 16 585 21 586 37 585 50 585 43 585 46 585 5 590 12 581 356 0 114 0 0 0 5 590 10 590 0 101 0 101 82 8 101 590 3598 590 4171 590 29 588 9 584 10 584 0 590 28 590 883 590 1048 590
23022 TX 2022/03/09 13 109 474 13 109 474 101 591 66002 596 50637 596 2662 591 242 596 352 591 30 591 79 591 5662 596 605 591 560 596 2524 591 2209 596 138 591 105 591 6298 596 0.767204024120481 596 50637 66002 0.053199568328071 591 2662 50038 0.040791933556039 591 2662 65258 0.098470052083333 591 605 6144 0.899015560495395 596 5662 6298   2 596 14 593 20 593 30 593 34 593 41 592 56 592 32 592 13 596 6 591 26 588 36 588 40 588 62 588 63 588 70 588 47 588 2 591 34 588 3058 671 1713 0 0 0 26 591 67 591 0 115 0 115 195 3 115 591 3814 591 4366 591 10 591 10 587 10 587 0 591 19 591 867 591 1033 591
25256 TX 2022/02/11 12 111 473 16 107 473 147 591 68145 596 53881 596 8945 591 938 596 375 591 66 591 125 591 6423 596 2045 591 2025 596 8627 591 8064 596 318 591 266 591 6846 596 0.790681634749431 596 53881 68145 0.167981220657277 591 8945 53250 0.132742706200101 591 8945 67386 0.306964875412789 591 2045 6662 0.938212094653812 596 6423 6846   7 593 46 590 74 590 65 590 111 591 187 590 199 590 185 590 64 596 5 588 34 585 36 585 47 585 44 586 78 585 71 585 55 585 5 591 149 581 303 0 114 0 0 0 17 591 31 591 0 110 1 110 160 18 110 591 3914 591 4418 591 37 589 19 585 10 585 0 591 55 591 937 591 1075 591

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