hospitals_state

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

36 rows where previous_day_admission_pediatric_covid_confirmed_5_11 = 9 sorted by staffed_adult_icu_bed_occupancy_coverage

View and edit SQL

Suggested facets: state, critical_staffing_shortage_today_yes, critical_staffing_shortage_today_not_reported, critical_staffing_shortage_anticipated_within_week_no, inpatient_beds_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_adult_icu_bed_occupancy_coverage, total_pediatric_patients_hospitalized_confirmed_covid_coverage, total_staffed_adult_icu_beds_coverage, adult_icu_bed_utilization_coverage, 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_coverage, previous_day_admission_adult_covid_confirmed_40-49, previous_day_admission_adult_covid_confirmed_50-59, previous_day_admission_adult_covid_confirmed_60-69_coverage, previous_day_admission_adult_covid_confirmed_70-79_coverage, previous_day_admission_adult_covid_confirmed_80+_coverage, previous_day_admission_adult_covid_confirmed_unknown_coverage, previous_day_admission_adult_covid_suspected_18-19_coverage, previous_day_admission_adult_covid_suspected_30-39, previous_day_admission_adult_covid_suspected_40-49, previous_day_admission_adult_covid_suspected_60-69_coverage, previous_day_admission_adult_covid_suspected_70-79_coverage, previous_day_admission_adult_covid_suspected_80+_coverage, deaths_covid, previous_week_therapeutic_a_casirivimab_imdevimab_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, all_pediatric_inpatient_beds_coverage, previous_day_admission_pediatric_covid_confirmed_0_4_coverage, previous_day_admission_pediatric_covid_confirmed_12_17_coverage, previous_day_admission_pediatric_covid_confirmed_5_11_coverage, previous_day_admission_pediatric_covid_confirmed_unknown_coverage, staffed_icu_pediatric_patients_confirmed_covid, 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
27773 NV 2022/03/02 0 4 58 0 4 58 54 60 8665 62 6891 62 385 60 32 62 80 60 7 60 17 60 685 62 91 60 81 62 352 60 291 62 33 60 6 60 828 62 0.795268320830929 62 6891 8665 0.056868537666174 60 385 6770 0.045140110212217 60 385 8529 0.11375 60 91 800 0.827294685990338 62 685 828   0 62 3 62 2 62 2 62 4 62 5 62 8 62 8 62 0 62 2 60 15 60 5 60 6 60 10 60 13 60 14 60 15 60 0 60 0 4 282 0 536 15 0 0 1 60 4 60 0 2 0 2 9 2 2 60 478 60 642 60 7 60 0 60 9 60 0 60 2 60 81 60 111 60
18507 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
23235 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
21209 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
34022 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
12897 FL 2022/08/17 5 188 74 16 191 60 130 261 59593 267 46486 267 3865 261 600 267 191 261 59 261 49 261 4651 267 453 261 445 267 3759 261 3523 267 82 261 70 261 6519 267 0.780058060510463 267 46486 59593 0.084158954817637 261 3865 45925 0.065609669150724 261 3865 58909 0.070748086834296 261 453 6403 0.71345298358644 267 4651 6519   5 263 20 251 41 253 43 251 71 250 89 252 121 251 177 253 32 267 1 258 6 243 15 244 25 245 34 244 43 243 26 243 39 243 2 261 29 153 6898 1291 3870 842 0 62 9 261 13 261 0 140 0 140 66 8 143 261 1851 261 2786 261 10 260 9 244 9 245 37 260 13 261 601 261 902 261
27706 FL 2022/06/12 8 187 75 36 173 61 110 264 60084 270 44480 270 3219 264 498 270 232 264 59 264 53 264 4479 270 323 264 314 270 3131 264 2846 270 88 264 72 264 6520 270 0.740296917648625 270 44480 60084 0.073422745312714 264 3219 43842 0.054349294252718 264 3219 59228 0.050770198050927 264 323 6362 0.686963190184049 270 4479 6520   2 265 26 259 40 259 35 259 47 260 88 261 122 260 127 263 17 270 1 262 9 252 17 252 23 251 33 252 39 251 56 251 48 252 5 264 18 151 4065 0 2691 1219 0 338 24 264 59 264 0 141 1 141 297 11 144 264 1827 264 2829 264 13 264 7 253 9 253 30 262 12 264 644 264 908 264
22125 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
23223 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
25712 FL 2022/05/28 8 192 72 35 176 61 93 266 60094 272 44907 272 2458 266 425 272 242 266 54 266 58 266 4602 272 219 266 194 272 2382 266 2073 272 76 266 58 266 6509 272 0.747279262488768 272 44907 60094 0.055511642087671 266 2458 44279 0.041504145348935 266 2458 59223 0.03448275862069 266 219 6351 0.707021047779997 272 4602 6509   2 266 29 258 29 258 40 261 37 260 80 261 84 262 119 262 5 272 0 263 12 252 24 252 24 252 28 251 46 253 54 252 43 252 11 266 14 153 4167 0 2787 1219 10 208 24 266 86 266 0 141 1 141 278 9 141 266 1885 266 2867 266 7 266 6 252 9 253 32 264 8 266 623 266 912 266
16617 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
26050 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
28497 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
29086 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
17841 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
18865 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
20558 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
25196 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
22792 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
24066 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
17583 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
27579 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
26039 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
14389 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
24042 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
24948 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
25558 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
27362 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
29584 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
24991 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
28716 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
28768 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
29996 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
23764 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
26342 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
31249 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

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