hospitals_state

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

25 rows where previous_day_deaths_influenza = 10 sorted by critical_staffing_shortage_today_not_reported

✎ 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, critical_staffing_shortage_anticipated_within_week_not_reported, hospital_onset_covid, inpatient_beds_used_coverage, inpatient_beds_used_covid_coverage, previous_day_admission_adult_covid_suspected, previous_day_admission_adult_covid_suspected_coverage, previous_day_admission_pediatric_covid_confirmed_coverage, staffed_adult_icu_bed_occupancy_coverage, staffed_icu_adult_patients_confirmed_and_suspected_covid, staffed_icu_adult_patients_confirmed_and_suspected_covid_coverage, total_adult_patients_hospitalized_confirmed_and_suspected_covid_coverage, total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_coverage, total_staffed_adult_icu_beds, percent_of_inpatients_with_covid_numerator, adult_icu_bed_covid_utilization_denominator, adult_icu_bed_utilization_coverage, previous_day_admission_adult_covid_confirmed_30-39, previous_day_admission_adult_covid_confirmed_50-59, previous_day_admission_adult_covid_confirmed_60-69_coverage, previous_day_admission_adult_covid_confirmed_80+, 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_50-59, previous_day_admission_adult_covid_suspected_50-59_coverage, previous_day_admission_adult_covid_suspected_80+, previous_day_admission_adult_covid_suspected_unknown_coverage, on_hand_supply_therapeutic_a_casirivimab_imdevimab_courses, previous_week_therapeutic_c_bamlanivimab_etesevimab_courses_used, previous_day_admission_influenza_confirmed, previous_day_deaths_covid_and_influenza, previous_day_deaths_covid_and_influenza_coverage, total_patients_hospitalized_confirmed_influenza_and_covid, all_pediatric_inpatient_bed_occupied, all_pediatric_inpatient_beds, previous_day_admission_pediatric_covid_confirmed_0_4, 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_coverage, staffed_icu_pediatric_patients_confirmed_covid_coverage, staffed_pediatric_icu_bed_occupancy_coverage, total_staffed_pediatric_icu_beds, total_staffed_pediatric_icu_beds_coverage

previous_day_deaths_influenza ✖

Link rowid state date critical_staffing_shortage_today_yes critical_staffing_shortage_today_no critical_staffing_shortage_today_not_reported ▼ critical_staffing_shortage_anticipated_within_week_yes critical_staffing_shortage_anticipated_within_week_no critical_staffing_shortage_anticipated_within_week_not_reported hospital_onset_covid hospital_onset_covid_coverage inpatient_beds inpatient_beds_coverage inpatient_beds_used inpatient_beds_used_coverage inpatient_beds_used_covid inpatient_beds_used_covid_coverage previous_day_admission_adult_covid_confirmed previous_day_admission_adult_covid_confirmed_coverage previous_day_admission_adult_covid_suspected previous_day_admission_adult_covid_suspected_coverage previous_day_admission_pediatric_covid_confirmed previous_day_admission_pediatric_covid_confirmed_coverage previous_day_admission_pediatric_covid_suspected previous_day_admission_pediatric_covid_suspected_coverage staffed_adult_icu_bed_occupancy staffed_adult_icu_bed_occupancy_coverage staffed_icu_adult_patients_confirmed_and_suspected_covid staffed_icu_adult_patients_confirmed_and_suspected_covid_coverage staffed_icu_adult_patients_confirmed_covid staffed_icu_adult_patients_confirmed_covid_coverage total_adult_patients_hospitalized_confirmed_and_suspected_covid total_adult_patients_hospitalized_confirmed_and_suspected_covid_coverage total_adult_patients_hospitalized_confirmed_covid total_adult_patients_hospitalized_confirmed_covid_coverage total_pediatric_patients_hospitalized_confirmed_and_suspected_covid total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_coverage total_pediatric_patients_hospitalized_confirmed_covid total_pediatric_patients_hospitalized_confirmed_covid_coverage total_staffed_adult_icu_beds total_staffed_adult_icu_beds_coverage inpatient_beds_utilization inpatient_beds_utilization_coverage inpatient_beds_utilization_numerator inpatient_beds_utilization_denominator percent_of_inpatients_with_covid percent_of_inpatients_with_covid_coverage percent_of_inpatients_with_covid_numerator percent_of_inpatients_with_covid_denominator inpatient_bed_covid_utilization inpatient_bed_covid_utilization_coverage inpatient_bed_covid_utilization_numerator inpatient_bed_covid_utilization_denominator adult_icu_bed_covid_utilization adult_icu_bed_covid_utilization_coverage adult_icu_bed_covid_utilization_numerator adult_icu_bed_covid_utilization_denominator adult_icu_bed_utilization adult_icu_bed_utilization_coverage adult_icu_bed_utilization_numerator adult_icu_bed_utilization_denominator geocoded_state previous_day_admission_adult_covid_confirmed_18-19 previous_day_admission_adult_covid_confirmed_18-19_coverage previous_day_admission_adult_covid_confirmed_20-29 previous_day_admission_adult_covid_confirmed_20-29_coverage previous_day_admission_adult_covid_confirmed_30-39 previous_day_admission_adult_covid_confirmed_30-39_coverage previous_day_admission_adult_covid_confirmed_40-49 previous_day_admission_adult_covid_confirmed_40-49_coverage previous_day_admission_adult_covid_confirmed_50-59 previous_day_admission_adult_covid_confirmed_50-59_coverage previous_day_admission_adult_covid_confirmed_60-69 previous_day_admission_adult_covid_confirmed_60-69_coverage previous_day_admission_adult_covid_confirmed_70-79 previous_day_admission_adult_covid_confirmed_70-79_coverage previous_day_admission_adult_covid_confirmed_80+ previous_day_admission_adult_covid_confirmed_80+_coverage previous_day_admission_adult_covid_confirmed_unknown previous_day_admission_adult_covid_confirmed_unknown_coverage previous_day_admission_adult_covid_suspected_18-19 previous_day_admission_adult_covid_suspected_18-19_coverage previous_day_admission_adult_covid_suspected_20-29 previous_day_admission_adult_covid_suspected_20-29_coverage previous_day_admission_adult_covid_suspected_30-39 previous_day_admission_adult_covid_suspected_30-39_coverage previous_day_admission_adult_covid_suspected_40-49 previous_day_admission_adult_covid_suspected_40-49_coverage previous_day_admission_adult_covid_suspected_50-59 previous_day_admission_adult_covid_suspected_50-59_coverage previous_day_admission_adult_covid_suspected_60-69 previous_day_admission_adult_covid_suspected_60-69_coverage previous_day_admission_adult_covid_suspected_70-79 previous_day_admission_adult_covid_suspected_70-79_coverage previous_day_admission_adult_covid_suspected_80+ previous_day_admission_adult_covid_suspected_80+_coverage previous_day_admission_adult_covid_suspected_unknown previous_day_admission_adult_covid_suspected_unknown_coverage deaths_covid deaths_covid_coverage on_hand_supply_therapeutic_a_casirivimab_imdevimab_courses on_hand_supply_therapeutic_b_bamlanivimab_courses on_hand_supply_therapeutic_c_bamlanivimab_etesevimab_courses previous_week_therapeutic_a_casirivimab_imdevimab_courses_used previous_week_therapeutic_b_bamlanivimab_courses_used previous_week_therapeutic_c_bamlanivimab_etesevimab_courses_used icu_patients_confirmed_influenza icu_patients_confirmed_influenza_coverage previous_day_admission_influenza_confirmed previous_day_admission_influenza_confirmed_coverage previous_day_deaths_covid_and_influenza previous_day_deaths_covid_and_influenza_coverage previous_day_deaths_influenza previous_day_deaths_influenza_coverage total_patients_hospitalized_confirmed_influenza total_patients_hospitalized_confirmed_influenza_and_covid total_patients_hospitalized_confirmed_influenza_and_covid_coverage total_patients_hospitalized_confirmed_influenza_coverage all_pediatric_inpatient_bed_occupied all_pediatric_inpatient_bed_occupied_coverage all_pediatric_inpatient_beds all_pediatric_inpatient_beds_coverage previous_day_admission_pediatric_covid_confirmed_0_4 previous_day_admission_pediatric_covid_confirmed_0_4_coverage previous_day_admission_pediatric_covid_confirmed_12_17 previous_day_admission_pediatric_covid_confirmed_12_17_coverage previous_day_admission_pediatric_covid_confirmed_5_11 previous_day_admission_pediatric_covid_confirmed_5_11_coverage previous_day_admission_pediatric_covid_confirmed_unknown previous_day_admission_pediatric_covid_confirmed_unknown_coverage staffed_icu_pediatric_patients_confirmed_covid staffed_icu_pediatric_patients_confirmed_covid_coverage staffed_pediatric_icu_bed_occupancy staffed_pediatric_icu_bed_occupancy_coverage total_staffed_pediatric_icu_beds total_staffed_pediatric_icu_beds_coverage
6479 6479 WA 2021/01/16 10 93 2 11 92 2 27 103 13594 105 9740 105 962 103 71 105 66 103 0 103 16 103 966 105 212 103 200 105 948 103 865 105 14 103 9 103 1346 105 0.716492570251582 105 9740 13594 0.09957561329055 103 962 9661 0.071508213781313 103 962 13453 0.16012084592145 103 212 1324 0.717682020802377 105 966 1346   1 105 1 104 5 104 9 104 10 104 21 104 6 104 18 104 0 105 0 103 2 102 6 102 3 102 5 102 14 102 12 101 3 102 21 103 10 103 255 476   0 22   1 103 0 103 0 103 10 103 2 2 103 103 853 102 2429 102   0   0   0   0   0 217 102 392 102
8081 8081 SD 2021/01/03 1 61 3 1 61 3 46 62 2836 65 1546 65 273 62 23 65 16 62 0 62 2 62 147 65 55 62 50 65 273 62 247 65 0 62 0 62 245 65 0.545133991537377 65 1546 2836 0.179133858267717 62 273 1524 0.099272727272727 62 273 2750 0.235042735042735 62 55 234 0.6 65 147 245   0 65 0 65 2 65 0 65 5 65 5 65 5 65 5 65 1 65 0 62 1 62 0 62 2 62 2 62 3 62 6 62 2 62 0 62 4 62 237 672   52 98   0 62 0 62 0 62 10 62 2 0 62 62 257 62 379 62   0   0   0   0   0 32 62 83 62
42966 42966 NE 2022/04/08 17 69 13 24 73 2 3 98 4569 99 3297 99 73 98 3 99 13 98 0 98 2 98 347 99 4 98 4 99 71 98 51 99 2 98 0 98 479 99 0.721602101116218 99 3297 4569 0.022351500306185 98 73 3266 0.016168327796235 98 73 4515 0.008565310492505 98 4 467 0.724425887265136 99 347 479   0 99 0 91 0 91 0 91 0 91 1 91 1 91 3 91 0 99 0 98 3 90 0 90 1 90 1 90 3 90 3 90 2 90 0 98 0 80 756 20 737 0 0 0 0 98 8 98 0 80 10 80 19 0 80 98 307 98 373 98 0 98 0 90 0 90 0 98 0 98 125 98 153 98
30241 30241 CA 2022/12/04 7 130 238 89 223 63 73 367 64425 375 50702 375 4729 367 658 375 313 367 20 366 14 365 5144 374 513 367 468 375 4590 367 4097 375 139 367 108 367 6765 374 0.786992627085759 375 50702 64425 0.094436456585989 367 4729 50076 0.074250274768409 367 4729 63690 0.077750833585935 366 513 6598 0.760384331116038 374 5144 6765   4 371 37 364 52 362 25 362 65 362 86 362 154 363 231 362 5 374 0 365 21 352 17 352 24 352 40 352 61 352 67 352 79 351 4 352 10 126 2398 1177 506 0 0 0 256 364 398 364 0 99 10 317 2103 128 316 363 2982 366 3998 366 10 365 3 161 7 352 0 365 26 366 817 365 1070 365
45279 45279 CA 2022/02/02 14 142 259 160 225 30 181 407 67660 415 54708 415 13322 407 1533 415 472 407 62 398 25 405 6187 415 2318 407 2319 415 12859 407 12598 415 402 407 375 406 7399 415 0.808572273130358 415 54708 67660 0.246329647572205 407 13322 54082 0.199207476635514 407 13322 66875 0.320874861572536 407 2318 7224 0.836194080281119 415 6187 7399   14 413 129 408 179 406 118 405 208 404 276 403 289 404 315 404 5 408 1 404 27 398 51 396 41 396 74 396 90 396 86 396 102 397 0 407 54 130 11094 1499 4597 335 0 43 6 407 3 407 10 360 10 359 46 5 358 407 2295 403 3650 405 26 394 19 392 17 392 0 397 88 404 596 405 916 405
12930 12930 CA 2023/01/26 6 89 269 91 215 58 72 355 64101 363 51350 363 3023 355 415 364 353 364 13 356 13 356 5169 363 355 355 325 363 2956 355 2496 363 93 355 78 355 6774 363 0.801079546340931 363 51350 64101 0.05965113066814 355 3023 50678 0.04772203454046 355 3023 63346 0.053755299818292 355 355 6604 0.763064658990257 363 5169 6774   2 364 20 361 33 361 31 361 33 361 75 361 89 360 111 361 6 364 5 364 22 361 30 361 27 361 34 361 70 361 80 361 75 361 30 352 7 92 2125 1187 516 0 0 0 30 361 14 361 0 66 10 298 180 11 299 361 2615 355 3575 355 6 356 2 353 4 353 1 356 20 355 730 355 1014 355
13371 13371 CA 2023/02/01 6 90 269 95 225 45 178 357 63991 365 51256 365 2926 357 414 365 315 365 11 357 15 357 5248 365 315 357 274 365 2822 357 2395 365 104 357 76 357 6805 365 0.800987638886718 365 51256 63991 0.05782722978715 357 2926 50599 0.046266721482559 357 2926 63242 0.047446904654315 357 315 6639 0.771197648787656 365 5248 6805   1 365 22 363 39 362 25 362 51 362 70 362 85 362 113 362 5 365 5 365 19 363 17 362 24 362 44 362 75 362 65 361 64 362 25 353 6 92 2302 1187 516 0 0 0 29 364 15 364 0 68 10 300 249 11 300 364 2652 357 3598 357 6 357 1 354 3 354 2 357 14 357 725 357 1024 357
24925 24925 CA 2023/01/05 7 73 282 96 209 57 113 353 62530 361 50810 361 5022 353 672 362 342 362 24 354 18 353 5157 361 527 353 504 361 4835 353 4350 361 155 353 132 353 6717 361 0.81256996641612 361 50810 62530 0.100159553250897 353 5022 50140 0.081295022258195 353 5022 61775 0.080544092923735 353 527 6543 0.767753461366682 361 5157 6717   8 359 50 356 51 358 51 358 83 359 117 358 151 358 173 359 3 361 2 361 27 358 26 358 34 358 49 358 61 358 75 357 68 358 1 349 11 76 770 175 18 0 0 0 127 360 123 360 0 52 10 298 936 58 299 360 2533 353 3461 353 15 354 6 351 3 351 0 353 26 353 765 353 1034 353
28522 28522 CA 2022/12/28 7 69 282 105 211 42 86 350 61719 358 49057 358 5095 350 832 358 371 358 21 350 23 350 4987 358 565 350 530 358 4955 350 4441 358 140 350 123 350 6662 358 0.794844375313923 358 49057 61719 0.105006079841718 350 5095 48521 0.083536915282583 350 5095 60991 0.086923076923077 350 565 6500 0.748574001801261 358 4987 6662   7 357 63 356 83 357 37 355 69 357 151 356 165 356 248 357 7 358 4 358 19 356 36 356 25 356 46 355 79 356 77 356 84 356 17 345 8 77 950 175 28 0 0 0 170 357 230 357 0 49 10 287 1186 96 287 357 2439 350 3437 350 13 349 4 348 3 348 1 350 28 350 728 350 1022 350
31856 31856 CA 2022/12/21 7 73 282 104 213 45 174 354 62436 362 51179 362 5125 354 691 362 368 362 31 354 17 354 5255 362 545 354 516 362 4959 354 4466 362 166 354 136 354 6701 362 0.819703376257288 362 51179 62436 0.101444972288203 354 5125 50520 0.083072633848249 354 5125 61693 0.083358825328847 354 545 6538 0.784211311744516 362 5255 6701   1 361 29 359 58 359 44 359 72 359 98 359 149 360 226 359 19 362 2 362 21 358 32 359 22 358 54 359 88 359 63 359 86 359 0 350 10 77 950 175 18 0 0 0 206 361 233 361 1 51 10 291 1271 89 291 361 2698 354 3620 354 16 354 8 351 7 350 0 354 34 354 781 354 1028 354
22095 22095 CA 2023/01/08 7 72 284 93 199 71 100 354 62571 362 50107 362 4742 354 605 363 273 363 20 354 8 354 5228 361 528 354 495 362 4612 354 4077 362 130 354 108 354 6826 361 0.80080228860015 362 50107 62571 0.095861887723129 354 4742 49467 0.076702845219417 354 4742 61823 0.079303094022229 353 528 6658 0.765895106944038 361 5228 6826   2 361 31 357 48 358 36 359 57 357 100 359 139 358 188 358 7 362 1 361 16 359 12 358 27 359 30 359 53 359 66 359 68 358 0 349 9 75 770 175 28 0 0 0 95 361 91 361 0 50 10 298 743 45 297 360 2350 354 3386 354 13 354 3 351 3 351 1 354 28 354 741 353 1019 353
29559 29559 CA 2023/01/07 7 72 284 95 200 68 98 355 62807 363 50653 363 4713 355 557 363 411 363 15 354 24 354 5301 363 512 355 482 363 4442 355 4000 363 134 355 109 355 6859 363 0.806486538124731 363 50653 62807 0.094248690157181 355 4713 50006 0.075945083631442 355 4713 62058 0.076520699447018 355 512 6691 0.772853185595568 363 5301 6859   1 360 29 358 35 359 47 359 53 358 112 359 116 358 149 360 10 361 2 361 21 360 35 358 36 359 66 358 98 359 77 358 76 358 1 361 10 75 641 175 28 0 0 0 101 362 102 362 0 50 10 295 803 55 295 362 2518 355 3442 355 13 354 1 350 0 350 1 354 24 355 784 355 1025 355
13875 13875 CA 2023/01/24 6 70 287 90 211 62 73 354 62283 362 50135 362 3126 354 423 363 345 363 15 355 12 355 5048 362 415 354 365 362 3067 354 2606 362 86 354 70 354 6666 362 0.804954803076281 362 50135 62283 0.063185980231642 354 3126 49473 0.050805311316615 354 3126 61529 0.063914985368859 354 415 6493 0.757275727572757 362 5048 6666   5 363 32 360 30 360 28 360 38 360 79 360 80 360 126 359 5 363 4 362 21 361 31 360 47 360 46 360 69 360 68 360 55 360 20 348 6 73 743 175 28 0 0 0 37 362 19 362 0 47 10 298 217 19 298 362 2443 354 3381 354 6 355 5 351 3 352 1 355 19 354 719 354 1014 354
14589 14589 CA 2023/01/20 6 72 287 96 210 59 78 356 62513 364 50525 364 3457 356 434 365 345 365 17 356 11 356 5079 364 398 356 351 364 3355 356 2906 364 102 356 81 356 6700 364 0.808231887767344 364 50525 62513 0.069304945770935 356 3457 49881 0.055975647274082 356 3457 61759 0.060996168582375 356 398 6525 0.758059701492537 364 5079 6700   1 364 22 362 45 361 41 361 34 361 76 361 79 361 127 361 16 364 1 364 21 362 36 361 26 361 50 361 66 361 67 361 78 360 19 352 7 73 770 175 28 0 0 0 49 362 25 361 0 47 10 296 253 15 297 362 2562 356 3539 356 8 356 3 353 5 353 1 356 20 356 719 356 1017 356
18061 18061 CA 2023/01/28 6 71 287 83 214 67 75 355 62765 363 49949 363 2870 355 399 364 314 364 10 356 12 355 5162 363 330 355 290 363 2768 355 2356 363 91 355 73 355 6826 363 0.79580976658966 363 49949 62765 0.058196122962122 355 2870 49316 0.046281364897117 355 2870 62012 0.049601683451075 355 330 6653 0.756226193964254 363 5162 6826   4 363 20 360 31 359 24 359 50 359 66 359 91 359 110 359 8 363 0 363 15 359 25 359 20 359 38 359 74 359 76 359 64 359 2 363 5 75 740 175 28 0 0 0 24 362 19 362 0 49 10 295 261 12 295 362 2500 355 3443 355 5 355 3 352 2 351 0 355 18 355 724 355 1003 355
18420 18420 CA 2023/01/31 6 70 287 90 209 64 180 354 63053 362 50864 362 2994 354 402 363 352 363 24 355 14 355 5139 362 314 354 277 362 2906 354 2476 362 88 354 74 354 6772 362 0.806686438393098 362 50864 63053 0.059633118887804 354 2994 50207 0.048060870681906 354 2994 62296 0.047539742619228 354 314 6605 0.758860011813349 362 5139 6772   3 363 25 360 37 359 24 360 40 360 73 360 90 361 102 359 17 363 0 363 28 361 31 360 26 360 38 360 93 360 72 360 61 359 21 348 4 74 767 202 28 0 0 0 24 362 18 362 0 47 10 299 251 14 299 362 2498 354 3452 354 13 355 6 352 4 352 1 355 15 354 712 354 1007 354
14603 14603 CA 2023/02/08 8 68 288 95 226 43 159 356 63035 364 51298 364 2952 356 440 364 345 364 20 356 13 356 5237 364 311 356 259 364 2857 356 2411 364 95 356 79 356 6849 364 0.813801856111684 364 51298 63035 0.058285781981164 356 2952 50647 0.047402649538338 356 2952 62275 0.046570829589698 356 311 6678 0.764637173309972 364 5237 6849   2 364 32 362 35 362 22 362 60 362 76 362 80 363 125 361 3 364 9 364 21 363 30 363 23 362 51 362 74 362 63 361 71 362 25 352 4 75 947 175 18 0 0 0 23 363 18 363 0 48 10 297 129 9 297 363 2589 356 3491 356 12 356 3 354 4 354 2 356 19 356 763 356 1044 356
21247 21247 CA 2023/02/12 6 70 288 85 207 72 173 356 61974 364 49270 364 2908 356 382 364 271 364 10 356 12 355 5075 363 316 356 248 364 2792 356 2356 364 116 356 88 356 6726 363 0.795010810985252 364 49270 61974 0.059792330626092 356 2908 48635 0.047517892741593 356 2908 61198 0.048170731707317 355 316 6560 0.754534641688968 363 5075 6726   6 363 21 362 19 361 31 361 29 361 69 361 89 361 118 361 6 363 2 363 9 361 16 361 24 361 36 361 54 360 67 361 60 361 23 351 3 73 767 175 18 0 0 0 18 363 11 363 0 47 10 300 112 5 299 363 2407 356 3484 356 9 355 1 354 0 352 0 355 14 356 725 355 1019 355
13446 13446 CA 2023/02/13 7 67 289 88 208 67 175 355 61710 363 49051 363 2965 355 355 363 243 363 16 355 14 354 4972 363 333 355 268 363 2850 355 2431 363 115 355 98 355 6683 363 0.79486306919462 363 49051 61710 0.061223646988375 355 2965 48429 0.048631271629845 355 2965 60969 0.051081454210769 355 333 6519 0.743977255723478 363 4972 6683   2 363 19 362 27 361 23 361 38 360 53 361 79 361 111 361 7 363 5 363 18 362 11 362 21 361 32 361 46 361 53 361 54 361 22 351 4 72 767 175 18 0 0 0 20 360 16 360 0 46 10 295 127 6 296 360 2366 355 3491 355 7 355 6 353 3 353 0 355 18 355 706 355 1023 355
17379 17379 CA 2023/02/15 7 70 289 100 222 44 197 358 62947 366 51279 366 2994 358 476 366 304 366 14 358 8 358 5257 366 318 358 277 366 2898 358 2469 366 96 358 87 358 6806 366 0.814637711090282 366 51279 62947 0.059127893198515 358 2994 50636 0.04814898202052 358 2994 62182 0.047934880916491 358 318 6634 0.772406699970614 366 5257 6806   1 365 30 363 27 363 40 363 43 363 90 363 98 364 144 363 13 366 5 366 19 362 24 363 22 363 49 363 61 363 72 363 50 363 20 353 1 75 933 175 18 0 0 0 16 365 8 365 0 48 10 298 122 8 298 365 2522 358 3570 358 9 358 1 355 3 354 1 358 22 358 736 358 1043 358
20504 20504 CA 2023/02/11 7 68 289 85 208 71 169 356 62390 364 50249 364 2927 356 405 364 335 364 14 356 12 355 5204 364 288 356 224 364 2828 356 2369 364 99 356 82 356 6667 364 0.805401506651707 364 50249 62390 0.058984744977128 356 2927 49623 0.047492333403644 356 2927 61631 0.043603330809992 356 288 6605 0.780560971951402 364 5204 6667   2 362 21 362 34 361 31 361 45 361 71 362 76 362 124 361 4 363 3 363 27 361 23 361 37 361 52 361 67 361 55 361 70 361 20 363 3 73 767 175 18 0 0 0 23 363 12 363 0 45 10 296 119 5 296 363 2498 356 3511 356 6 355 5 354 3 353 0 355 15 356 739 356 1026 356
16858 16858 CA 2023/02/14 8 66 290 94 207 63 182 356 62316 364 50468 364 2999 356 402 364 337 364 25 356 12 356 5227 364 299 356 253 364 2883 356 2439 364 116 356 100 356 6757 364 0.809872263945054 364 50468 62316 0.060197916457576 356 2999 49819 0.048716699155296 356 2999 61560 0.045378661405373 356 299 6589 0.773568151546544 364 5227 6757   4 362 28 361 27 361 29 361 51 361 71 361 81 362 109 360 8 363 2 363 17 361 28 361 31 361 47 361 72 361 76 360 62 361 24 348 8 83 767 175 18 0 0 0 17 363 10 363 0 58 10 300 119 6 300 363 2586 356 3700 356 10 356 14 354 1 354 0 356 35 356 701 356 988 356
19270 19270 CA 2023/02/17 7 69 290 95 209 62 195 358 62538 366 51020 366 2916 358 406 366 295 366 17 358 20 357 5287 366 318 358 266 366 2844 358 2394 366 100 358 84 358 6841 366 0.815823979020755 366 51020 62538 0.057889303581355 358 2916 50372 0.047204325444362 358 2916 61774 0.047654728008392 358 318 6673 0.772840228036837 366 5287 6841   4 365 20 362 35 362 36 361 37 362 65 361 95 362 113 363 7 365 6 365 17 362 26 362 26 362 47 362 48 362 63 362 60 362 23 353 3 75 767 175 28 0 0 0 16 366 12 365 0 48 10 302 100 7 302 366 2571 358 3468 358 8 358 5 354 4 355 0 357 19 358 714 358 1023 358
25846 25846 CA 2023/01/12 7 69 291 101 212 54 172 358 62816 366 51048 366 4285 358 561 367 338 367 16 359 12 358 5283 366 503 358 465 366 4169 358 3706 366 116 358 95 358 6822 366 0.812659195109526 366 51048 62816 0.085058657720785 358 4285 50377 0.069042746886229 358 4285 62063 0.075627725154112 358 503 6651 0.774406332453826 366 5283 6822   4 365 33 364 54 362 43 363 53 363 97 363 110 362 165 362 12 366 3 366 18 363 31 363 26 363 42 363 62 363 74 363 82 363 23 354 5 74 770 175 28 0 0 0 80 365 48 365 0 49 10 301 511 30 302 365 2426 358 3436 358 8 359 4 356 2 356 3 358 30 358 696 358 1022 358
32306 32306 CA 2023/01/11 7 69 291 104 220 43 163 359 62911 367 51265 367 4479 359 597 367 344 367 18 359 6 359 5247 367 499 359 473 367 4368 359 3904 367 111 359 95 359 6794 367 0.814881340306147 367 51265 62911 0.088500296384114 359 4479 50610 0.072058303034203 359 4479 62158 0.0753093872623 359 499 6626 0.772299087430085 367 5247 6794   4 366 35 365 47 365 45 366 56 365 105 365 123 366 180 365 9 367 3 366 25 365 40 365 25 365 44 365 69 365 75 365 62 365 14 355 4 74 950 175 28 0 0 0 84 366 59 366 0 48 10 303 582 33 303 366 2449 359 3451 359 12 359 1 357 3 357 3 359 30 359 739 359 1039 359

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