hospitals_state

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

26 rows where previous_day_deaths_influenza = 9 sorted by staffed_icu_pediatric_patients_confirmed_covid

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: critical_staffing_shortage_today_yes, critical_staffing_shortage_today_no, critical_staffing_shortage_anticipated_within_week_no, previous_day_admission_adult_covid_suspected, previous_day_admission_pediatric_covid_confirmed_coverage, previous_day_admission_pediatric_covid_suspected, total_adult_patients_hospitalized_confirmed_covid_coverage, percent_of_inpatients_with_covid_coverage, adult_icu_bed_utilization_coverage, adult_icu_bed_utilization_numerator, previous_day_admission_adult_covid_suspected_18-19, previous_day_admission_adult_covid_suspected_18-19_coverage, previous_day_admission_adult_covid_suspected_40-49, previous_day_admission_adult_covid_suspected_50-59_coverage, previous_day_admission_adult_covid_suspected_70-79_coverage, previous_day_admission_adult_covid_suspected_unknown, deaths_covid, 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_influenza_coverage, total_patients_hospitalized_confirmed_influenza_and_covid, 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, previous_day_admission_pediatric_covid_confirmed_unknown, staffed_icu_pediatric_patients_confirmed_covid, total_staffed_pediatric_icu_beds, total_staffed_pediatric_icu_beds_coverage

previous_day_admission_adult_covid_confirmed_40-49_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
3929 3929 AR 2021/01/30 16 94 2 20 90 2 17 110 9360 112 6317 112 1015 110 106 112 208 110 2 110 17 110 788 112 265 110 239 112 997 110 851 112 18 110 6 110 1065 112 0.674893162393162 112 6317 9360 0.161034428050135 110 1015 6303 0.108917265801052 110 1015 9319 0.252862595419847 110 265 1048 0.739906103286385 112 788 1065   0 112 2 112 10 112 5 112 11 112 29 112 27 112 20 112 2 112 2 110 7 110 18 110 16 110 23 110 48 110 55 110 39 110 0 110 12 110 768 2611   96 762   10 110 12 110 0 110 9 110 28 13 110 110 817 110 1623 110   0   0   0   0   0 237 110 407 110
42069 42069 KS 2021/08/25 18 125 7 24 119 7 4 147 8940 150 5832 150 802 147 118 150 65 147 1 147 4 147 671 150 239 147 233 150 794 147 737 150 8 147 1 147 852 150 0.652348993288591 150 5832 8940 0.138754325259516 147 802 5780 0.090457929167607 147 802 8866 0.287259615384615 147 239 832 0.787558685446009 150 671 852   0 150 7 148 15 148 17 148 17 148 21 148 22 148 16 147 2 150 0 147 3 145 2 145 12 144 11 145 13 145 14 145 9 145 1 147 22 147 2433 1533 1161 456 0 14 0 140 0 140 9 140 9 140 3 1 140 140 353 146 674 146   0   0   0   0   0 102 146 266 146
46972 46972 WI 2021/09/30 35 91 24 45 81 24 8 147 13385 150 9950 150 1249 147 204 150 60 147 7 147 77 147 1089 150 339 147 348 150 1224 147 1184 150 25 147 10 147 1561 150 0.743369443406799 150 9950 13385 0.128168291431503 147 1249 9745 0.095161904761905 147 1249 13125 0.225099601593626 147 339 1506 0.697629724535554 150 1089 1561   1 150 6 149 18 148 18 148 23 148 29 148 35 148 26 148 48 150 1 147 2 145 5 145 6 145 8 145 8 145 8 145 10 145 12 147 31 147 3486 2813 1803 958 11 64 1 129 0 129 9 129 9 129 1 0 129 129 300 49 380 49   0   0   0   0   0 88 49 140 49
54199 54199 TN 2021/06/06 8 103 32 28 83 32 16 111 20063 143 12758 132 435 111 22 114 48 111 1 111 9 111 1657 142 158 111 136 114 424 111 355 114 11 111 7 111 2405 143 0.654558514186035 132 12758 19491 0.036225849433711 111 435 12008 0.023727704140075 111 435 18333 0.06786941580756 111 158 2328 0.690129112869638 142 1657 2401   0 114 2 114 4 114 2 114 1 114 3 114 3 114 3 114 4 114 1 111 6 111 6 111 5 111 10 111 5 111 5 111 5 111 5 111 17 111 0 0 18 0 0 16 1 110 0 110 0 111 9 111 6 2 110 110 30 15 112 15   0   0   0   0   0 0 15 0 15
38329 38329 WY 2022/01/19 3 23 5 9 20 2 26 29 1743 31 843 31 132 29 18 31 6 29 2 29 0 29 47 31 18 29 18 31 113 29 114 31 19 29 4 29 137 31 0.483648881239243 31 843 1743 0.159420289855072 29 132 828 0.077373974208675 29 132 1706 0.137404580152672 29 18 131 0.343065693430657 31 47 137   1 31 1 31 1 31 2 31 4 31 4 31 5 31 0 31 0 31 0 29 0 29 0 29 0 29 3 29 0 29 1 29 2 29 0 29 0 27 754 0 897 50 0 23 1 26 2 26 0 23 9 23 6 10 23 26 4 6 0 6 0 8 0 7 0 7 2 22 0 6 0 5 0 6
41572 41572 KS 2022/01/06 32 111 7 37 106 7 13 147 8550 150 5740 150 1069 147 176 150 75 147 1 146 6 146 696 150 253 147 240 150 1056 147 990 150 13 147 10 147 831 150 0.671345029239766 150 5740 8550 0.187972569017056 147 1069 5687 0.126195254397356 147 1069 8471 0.311576354679803 147 253 812 0.837545126353791 150 696 831   1 147 8 144 14 145 19 145 17 144 52 145 37 145 21 146 7 150 0 146 10 141 9 142 8 141 13 141 12 141 17 141 6 141 0 147 20 143 1796 1323 2165 986 80 780 2 141 7 140 0 136 9 136 24 11 135 140 313 145 678 145   0   0   0   0 0 5 96 145 213 145
20250 20250 LA 2022/12/20 1 33 114 9 123 16 14 145 12663 148 8761 148 317 145 64 148 0 147 1 146 0 146 1077 148 57 145 56 148 311 145 306 148 6 145 6 145 1454 148 0.69185816947011 148 8761 12663 0.036638927415626 145 317 8652 0.025345806348445 145 317 12507 0.039202200825309 145 57 1454 0.740715268225585 148 1077 1454   0 148 1 144 3 145 2 145 8 145 14 145 14 145 23 145 0 147 0 148 0 145 0 145 1 145 0 145 2 143 1 145 2 145 6 148 0 42 1730 10 455 0 0 0 23 148 17 148 9 36 9 36 116 9 36 148 422 146 770 146 1 144 0 141 0 141 0 145 1 145 159 146 254 146
27224 27224 AR 2022/09/22 1 78 13 17 73 2 7 90 7601 92 5589 92 276 90 29 92 59 90 3 90 10 90 658 92 47 90 34 92 265 90 212 92 11 90 9 90 891 92 0.73529798710696 92 5589 7601 0.04951560818084 90 276 5574 0.036532097948379 90 276 7555 0.053775743707094 90 47 874 0.738496071829405 92 658 891   0 91 1 82 1 83 2 82 2 82 4 82 10 82 10 82 1 92 2 90 5 79 4 79 7 79 6 79 14 79 10 79 11 79 0 90 0 35 246 82 434 5 0 0 1 90 0 90 0 32 9 32 4 12 32 90 332 90 469 90 2 89 0 80 1 79 0 90 1 90 54 90 87 90
36446 36446 SC 2022/02/08 21 50 5 23 48 5 22 74 10933 76 8798 76 1787 74 208 76 30 74 4 74 1 74 1065 76 361 74 358 76 1762 74 1713 76 25 74 22 74 1342 76 0.804719656087076 76 8798 10933 0.205473151661492 74 1787 8697 0.165939270127217 74 1787 10769 0.277478862413528 74 361 1301 0.793591654247392 76 1065 1342   0 73 14 72 9 72 10 72 30 72 39 75 50 73 42 74 2 71 0 74 1 70 1 70 2 70 7 70 5 70 10 70 4 70 0 69 36 55 1436 1595 1585 4 0 4 1 74 2 74 0 49 9 49 31 9 49 74 303 74 449 74 1 74 1 70 0 70 2 69 6 74 56 74 97 74
33274 33274 NY 2022/12/10 2 161 15 4 160 14 676 169 44971 178 36365 178 3772 169 427 178 173 169 12 169 31 169 3412 178 350 169 306 178 3670 169 3332 178 102 169 72 169 4466 178 0.808632229659114 178 36365 44971 0.104519382637369 169 3772 36089 0.084745001123343 169 3772 44510 0.080091533180778 169 350 4370 0.763994626063592 178 3412 4466   2 170 19 158 34 157 23 156 42 155 80 156 95 159 125 158 9 178 1 169 13 146 19 146 7 146 19 146 34 146 37 145 25 145 18 168 18 54 1689 234 911 0 0 91 127 169 239 169 0 32 9 32 922 44 32 169 1815 169 2500 169 3 169 0 146 3 146 6 169 13 169 331 169 490 169
14228 14228 CA 2023/01/21 7 69 286 92 202 68 153 354 61895 362 49212 362 3250 354 377 362 0 361 21 354 7 353 5008 362 377 354 339 362 3149 354 2716 362 101 354 83 354 6668 362 0.795088456256564 362 49212 61895 0.066916488222698 354 3250 48568 0.053155820153416 354 3250 61141 0.058062528877252 354 377 6493 0.751049790041992 362 5008 6668   1 361 22 361 27 360 25 360 41 360 74 360 85 360 104 359 9 360 3 361 15 360 28 360 30 360 36 360 66 360 67 360 53 360 298 362 3 72 770 175 28 0 0 0 42 360 20 360 0 47 9 292 344 15 292 360 2480 354 3470 354 11 352 4 353 5 352 2 353 18 354 719 354 1018 354
18726 18726 CA 2023/01/19 8 68 287 94 211 58 163 355 62310 363 50361 363 3618 355 432 363 3 350 13 355 13 354 5025 363 401 355 357 363 3522 355 3078 363 96 355 81 355 6665 363 0.808233028406355 363 50361 62310 0.072773352643012 355 3618 49716 0.058776703760864 355 3618 61555 0.061787365177196 355 401 6490 0.753938484621155 363 5025 6665   4 360 27 359 47 360 32 360 48 359 77 360 77 357 118 359 8 362 4 361 21 360 39 359 24 359 46 359 83 359 69 359 65 359 351 363 4 74 770 175 28 0 0 0 55 362 30 362 0 48 9 295 304 20 298 362 2421 331 3380 331 7 330 2 328 2 329 2 331 18 331 707 331 995 331
17125 17125 CA 2023/01/22 7 69 283 91 200 68 74 351 61157 359 48118 359 3203 351 322 359 4 346 14 351 13 350 4867 358 384 351 348 359 3097 351 2648 359 106 351 89 351 6583 358 0.786794643295126 359 48118 61157 0.067411710232774 351 3203 47514 0.05302014533777 351 3203 60411 0.059850374064838 350 384 6416 0.739328573598663 358 4867 6583   0 358 28 359 24 357 19 357 40 357 57 357 60 357 93 357 8 358 5 358 19 358 23 357 20 357 32 357 53 357 48 357 60 357 264 359 2 72 770 175 28 0 0 0 38 357 23 357 0 47 9 290 349 16 289 356 2422 351 3460 351 5 350 4 350 4 349 1 350 19 351 708 350 1016 350
14840 14840 CA 2022/12/24 7 72 282 91 202 68 80 353 60652 361 47283 361 4822 353 719 361 2 360 18 352 13 352 4938 361 583 353 541 361 4686 353 4208 361 136 353 115 353 6631 361 0.779578579436787 361 47283 60652 0.103245974648852 353 4822 46704 0.080469936418404 353 4822 59923 0.090108191653787 353 583 6470 0.744684059719499 361 4938 6631   5 360 38 358 55 358 41 358 57 358 123 358 141 358 224 358 3 359 3 360 16 358 27 358 24 358 47 358 69 358 87 358 82 358 356 361 8 76 855 175 38 0 0 0 167 359 207 359 0 50 9 288 1165 78 288 359 2383 353 3362 353 12 352 2 350 4 350 0 352 24 353 756 353 1009 353
15490 15490 CA 2023/01/18 7 72 284 101 217 45 172 355 62345 363 50450 363 3779 354 461 363 12 351 18 355 6 355 5031 363 416 355 361 363 3679 354 3259 362 100 354 88 354 6672 363 0.809206832945705 363 50450 62345 0.076011746721377 354 3779 49716 0.061466144011971 354 3779 61481 0.064 355 416 6500 0.754046762589928 363 5031 6672   3 362 27 360 40 359 25 359 48 359 76 359 90 359 150 358 4 363 4 362 18 359 37 359 26 359 61 358 47 358 62 359 72 359 327 363 5 77 950 175 18 0 0 0 54 363 34 363 0 51 9 300 322 23 301 363 2421 355 3453 355 12 354 1 351 4 351 1 355 25 355 708 355 1022 355
40750 40750 CA 2022/03/02 10 125 274 125 247 37 60 401 65893 409 51972 409 4190 401 435 409 437 401 25 396 16 400 5378 409 696 401 677 409 4049 401 3780 409 141 401 122 400 7066 409 0.788733249358809 409 51972 65893 0.081588939733229 401 4190 51355 0.064343739922296 401 4190 65119 0.100869565217391 401 696 6900 0.76110953863572 409 5378 7066   5 407 34 401 39 401 37 401 52 401 72 401 94 400 102 402 0 406 2 399 32 393 46 393 41 393 58 393 97 393 67 392 94 394 0 401 24 126 11251 1547 4331 345 0 6 0 401 3 401 9 355 9 355 34 13 355 401 2433 400 3757 400 15 394 7 390 3 389 0 395 25 399 630 400 969 400
14256 14256 CA 2023/01/16 6 68 287 91 203 67 85 353 61123 361 48052 361 3959 352 459 361 0 349 6 353 8 352 4922 361 453 352 409 360 3850 352 3425 360 109 353 83 352 6858 361 0.786152512147637 361 48052 61123 0.083412342245539 352 3959 47463 0.065571326829753 352 3959 60377 0.067713004484305 352 453 6690 0.717701953922426 361 4922 6858   1 360 34 359 39 359 42 359 60 359 70 359 82 359 143 358 8 361 4 361 19 360 29 359 23 359 47 359 51 359 52 359 65 358 290 361 3 72 743 175 28 0 0 0 55 357 36 357 0 46 9 286 366 28 287 357 2250 353 3368 353 5 352 1 350 0 350 0 353 26 352 705 353 1014 353
16144 16144 CA 2023/01/14 7 70 289 97 201 68 76 358 61444 366 48782 366 3980 357 535 366 0 364 9 358 10 357 5025 366 443 357 407 365 3865 357 3435 365 115 358 99 357 6813 366 0.793926176681206 366 48782 61444 0.08265320956119 357 3980 48153 0.065575931326512 357 3980 60693 0.066666666666667 357 443 6645 0.737560546014971 366 5025 6813   3 365 27 364 53 363 36 363 60 363 84 362 103 363 168 363 6 364 5 365 20 363 25 363 29 363 57 362 72 363 73 363 67 362 348 366 7 74 770 175 28 0 0 0 62 364 32 364 0 48 9 292 408 28 293 364 2301 358 3356 358 5 357 2 356 2 355 0 357 28 357 695 358 1018 358
16222 16222 CA 2023/01/13 7 68 291 99 209 58 157 358 62724 366 50811 366 4128 358 585 366 15 353 12 358 15 357 5200 366 459 358 422 366 4006 358 3566 365 122 358 105 358 6762 366 0.810072699445188 366 50811 62724 0.082308137100473 358 4128 50153 0.066604278937688 358 4128 61978 0.069598180439727 358 459 6595 0.769003253475303 366 5200 6762   4 364 16 364 44 363 38 363 65 363 97 364 140 364 181 364 3 365 3 365 24 363 28 363 32 363 42 363 64 363 90 363 78 364 361 366 7 72 743 175 28 0 0 0 70 365 48 364 0 47 9 300 459 25 302 365 2404 358 3476 358 7 357 2 356 3 355 1 357 30 357 712 358 1031 358
19241 19241 CA 2023/01/09 7 71 283 97 197 67 90 353 62267 361 49607 361 4770 353 525 361 14 348 19 353 15 352 5098 361 522 353 480 361 4640 353 4086 361 130 353 111 353 6758 361 0.796682030610115 361 49607 62267 0.097402597402597 353 4770 48972 0.07754332347108 353 4770 61514 0.07922294733647 353 522 6589 0.754365196803788 361 5098 6758   3 361 31 357 44 358 35 358 51 358 95 358 107 358 155 359 12 361 3 361 21 358 26 358 18 358 32 358 71 358 74 358 76 357 321 361 5 74 770 175 28 0 0 0 97 359 74 359 0 49 9 295 713 46 297 359 2289 353 3390 353 16 353 1 350 2 351 0 353 30 353 726 353 1013 353
20065 20065 CA 2022/12/14 7 114 253 110 226 38 109 366 63537 374 52513 374 5193 366 757 374 436 366 18 365 13 365 5408 374 586 366 519 374 5039 366 4477 374 128 366 108 366 6845 374 0.826494798306498 374 52513 63537 0.10017747598287 366 5193 51838 0.08270425226947 366 5193 62790 0.087737685282228 366 586 6679 0.790065741417093 374 5408 6845   5 371 38 364 65 362 51 362 74 361 120 362 172 363 230 361 2 373 4 364 25 355 39 354 44 354 54 353 87 354 104 354 76 353 3 366 11 90 1907 165 8 0 0 0 209 366 236 366 0 62 9 298 1520 108 298 366 2781 365 3755 366 9 365 3 146 6 354 0 365 31 365 780 365 1026 365
13181 13181 CA 2022/12/20 9 72 279 90 199 71 169 352 62219 360 50775 360 5112 352 713 360 0 345 29 352 20 352 5247 360 558 352 511 360 4957 352 4443 360 155 352 127 352 6660 360 0.816069046432762 360 50775 62219 0.101972831182302 352 5112 50131 0.083158459811625 352 5112 61473 0.084571082146105 352 558 6598 0.787837837837838 360 5247 6660   7 358 37 357 69 356 49 356 67 356 128 357 129 357 225 356 7 359 4 359 30 356 27 356 40 355 48 356 81 356 86 355 79 355 395 360 7 87 770 175 18 0 0 0 189 359 219 359 0 60 9 291 1282 81 291 358 2668 352 3706 352 22 352 1 348 4 349 2 352 33 352 800 352 1054 352
20427 20427 CA 2022/12/13 7 101 262 98 214 58 107 362 63145 370 51613 370 5172 362 744 370 433 362 20 362 17 362 5328 370 580 362 543 370 5037 362 4490 370 135 362 116 362 6829 370 0.817372713595692 370 51613 63145 0.101477426570134 362 5172 50967 0.082889928841592 362 5172 62396 0.087008700870087 362 580 6666 0.780202079367404 370 5328 6829   5 368 41 360 66 359 41 359 74 358 131 359 163 360 217 357 7 368 6 361 38 350 45 350 29 350 51 350 85 350 99 350 79 348 1 345 10 75 729 165 18 0 0 0 220 362 236 362 0 49 9 295 1587 92 296 362 2694 362 3724 362 14 362 3 136 3 352 0 362 34 362 766 362 1024 362
14156 14156 CA 2023/01/01 7 71 280 86 205 67 93 350 61304 358 47543 358 5086 350 674 358 0 345 25 350 17 349 4886 357 534 350 506 358 4896 350 4451 358 174 350 150 350 6684 357 0.775528513636957 358 47543 61304 0.108351086493396 350 5086 46940 0.083974507149226 350 5086 60566 0.081788941644969 349 534 6529 0.730999401555955 357 4886 6684   4 357 43 356 55 355 32 355 51 355 126 355 153 355 210 355 8 357 2 357 14 355 27 355 22 355 34 354 61 354 68 354 73 354 301 358 8 74 770 175 28 0 0 0 145 345 152 345 0 50 9 276 1020 46 275 344 2307 350 3388 350 14 349 7 348 3 347 1 349 58 350 740 349 1022 349
15422 15422 CA 2022/12/30 7 70 277 98 202 54 274 350 61343 354 49346 354 5134 350 791 354 18 341 32 349 20 349 4961 354 537 350 501 354 4942 350 4424 354 192 350 141 350 6601 354 0.804427563047128 354 49346 61343 0.1048311348879 350 5134 48974 0.084293829836141 350 5134 60906 0.082793709528215 350 537 6486 0.751552795031056 354 4961 6601   11 353 42 351 71 351 41 350 76 351 129 352 173 352 245 351 13 353 6 353 19 351 29 351 24 351 44 351 87 351 72 351 91 351 372 354 11 74 757 175 28 0 0 0 175 353 212 352 0 47 9 291 1179 80 292 353 2479 350 3432 350 21 349 6 347 5 346 1 349 60 350 738 350 1015 350
20907 20907 CA 2023/01/02 7 71 279 92 200 65 95 349 61088 357 47737 357 5130 349 644 357 1 344 34 349 18 347 4966 357 544 349 515 357 4960 349 4471 357 170 349 153 349 6700 357 0.781446437925616 357 47737 61088 0.108854796613406 349 5130 47127 0.085014003281242 349 5130 60343 0.083167711359119 349 544 6541 0.741194029850746 357 4966 6700   4 356 41 355 43 354 50 354 58 354 104 353 141 353 201 354 12 357 4 356 18 354 29 354 25 353 43 353 55 353 68 353 61 353 303 357 6 74 770 175 28 0 0 0 146 355 141 355 0 49 9 285 1086 54 285 355 2308 349 3393 349 18 348 10 346 6 345 0 348 68 349 737 349 1014 349

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