hospitals_state

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

20 rows where previous_day_deaths_influenza = 5 sorted by previous_day_admission_pediatric_covid_confirmed_unknown_coverage

View and edit SQL

Suggested facets: critical_staffing_shortage_anticipated_within_week_no, hospital_onset_covid_coverage, inpatient_beds_coverage, inpatient_beds_used_coverage, 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_coverage, staffed_icu_adult_patients_confirmed_and_suspected_covid_coverage, staffed_icu_adult_patients_confirmed_covid_coverage, total_adult_patients_hospitalized_confirmed_and_suspected_covid_coverage, total_adult_patients_hospitalized_confirmed_covid_coverage, total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_coverage, total_pediatric_patients_hospitalized_confirmed_covid_coverage, inpatient_beds_utilization, inpatient_beds_utilization_numerator, percent_of_inpatients_with_covid, percent_of_inpatients_with_covid_coverage, percent_of_inpatients_with_covid_denominator, inpatient_bed_covid_utilization_coverage, inpatient_bed_covid_utilization_denominator, adult_icu_bed_covid_utilization_numerator, adult_icu_bed_utilization, adult_icu_bed_utilization_numerator, previous_day_admission_adult_covid_confirmed_18-19_coverage, previous_day_admission_adult_covid_confirmed_20-29_coverage, previous_day_admission_adult_covid_confirmed_30-39_coverage, previous_day_admission_adult_covid_confirmed_40-49_coverage, previous_day_admission_adult_covid_suspected_20-29, previous_day_admission_adult_covid_suspected_50-59, previous_day_admission_adult_covid_suspected_70-79_coverage, previous_day_admission_adult_covid_suspected_80+_coverage, previous_day_admission_adult_covid_suspected_unknown_coverage, previous_week_therapeutic_c_bamlanivimab_etesevimab_courses_used, icu_patients_confirmed_influenza_coverage, total_patients_hospitalized_confirmed_influenza_and_covid, all_pediatric_inpatient_bed_occupied, 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_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
25850 IN 2021/12/09 25 139 4 23 142 3 2 166 19179 168 13740 168 2790 166 376 168 133 166 6 166 5 166 1819 168 696 166 667 168 2747 166 2559 168 43 166 26 166 2274 168 0.716408571875489 168 13740 19179 0.204710543693595 166 2790 13629 0.146572104018913 166 2790 19035 0.31266846361186 166 696 2226 0.799912049252419 168 1819 2274   1 167 20 168 26 168 39 168 78 168 80 168 85 168 44 168 3 168 1 166 8 166 7 166 7 166 24 166 30 166 21 166 16 166 19 166 29 166 2860 1076 3846 1797 99 1509 3 164 6 164 0 164 5 164 24 3 165 164 365 48 576 48   0   0   0   0   0 12 48 19 48
35086 OK 2021/07/06 31 93 11 32 92 11 7 133 9491 135 6149 135 277 133 50 135 51 133 0 133 7 133 713 135 73 133 64 135 251 133 209 135 26 133 24 133 994 135 0.647876936044674 135 6149 9491 0.04592175066313 133 277 6032 0.02970827970828 133 277 9324 0.076680672268908 133 73 952 0.717303822937626 135 713 994   0 135 2 132 5 132 8 132 12 132 8 132 11 132 3 132 1 135 0 133 8 130 6 130 3 130 6 130 11 130 10 130 7 130 0 133 1 133 1977 2806 1432 24 11 22 1 123 1 123 0 123 5 123 6 28 123 123 534 71 770 71   0   0   0   0   0 290 71 379 71
51026 OR 2021/05/30 3 54 7 3 54 7 13 62 7076 64 4938 64 306 62 20 64 38 62 0 62 4 62 506 64 73 62 59 64 296 62 252 64 10 62 4 62 907 64 0.697851893725269 64 4938 7076 0.063053781166289 62 306 4853 0.044322132097335 62 306 6904 0.082672706681767 62 73 883 0.557883131201764 64 506 907   0 64 2 63 1 63 0 63 4 63 5 63 6 62 2 62 0 64 0 62 2 60 3 60 2 60 5 60 9 60 9 60 8 60 0 62 4 62 105 120 89 7 273 281 0 62 0 62 0 62 5 62 0 0 62 62 301 50 462 50   0   0   0   0   0 75 50 123 50
23195 MD 2022/12/01 12 19 19 14 18 18 12 49 10524 50 9031 50 796 49 85 50 236 49 0 49 15 49 981 50 72 49 45 50 756 49 511 50 40 49 8 49 1317 50 0.858133789433675 50 9031 10524 0.088859120339361 49 796 8958 0.076332949750671 49 796 10428 0.056293979671618 49 72 1279 0.744874715261959 50 981 1317   0 49 8 49 7 49 2 49 8 49 16 50 23 49 21 49 0 50 2 49 18 48 18 48 13 48 31 48 55 48 53 48 46 48 0 49 3 28 534 365 646 0 0 0 35 49 58 49 0 20 5 21 219 5 21 49 375 49 544 49 0 49 0 47 0 47 0 42 1 49 20 49 21 49
26404 MD 2022/11/17 12 20 19 14 19 18 17 50 10538 51 8806 51 651 50 57 51 184 50 0 50 13 50 938 51 68 50 40 51 614 50 386 51 37 50 9 50 1293 51 0.835642436895046 51 8806 10538 0.074519230769231 50 651 8736 0.062332439678284 50 651 10444 0.054097056483691 50 68 1257 0.725444702242846 51 938 1293   0 51 3 50 2 50 1 50 6 50 11 50 16 50 18 49 0 51 0 50 12 49 20 49 14 49 21 49 45 49 34 49 38 48 0 50 2 27 462 365 646 0 0 0 17 50 37 50 0 20 5 20 119 2 20 50 388 50 546 50 0 50 0 48 0 48 0 43 1 50 20 50 20 50
31442 MD 2022/11/15 12 19 20 14 19 18 17 50 10529 51 8736 51 679 50 67 51 140 50 2 50 14 50 918 51 65 50 39 51 603 50 426 51 45 50 15 50 1278 51 0.82970842435179 51 8736 10529 0.078316032295271 50 679 8670 0.065069477719214 50 679 10435 0.052334943639291 50 65 1242 0.71830985915493 51 918 1278   0 51 3 50 4 50 8 50 9 50 13 50 15 50 15 50 0 51 0 50 15 49 18 49 15 49 15 49 29 49 27 49 21 49 0 50 6 28 534 365 646 0 0 0 15 50 29 50 0 20 5 21 122 0 21 50 403 50 557 50 0 50 1 48 1 48 0 43 0 50 22 50 23 50
34349 MD 2022/11/05 12 19 20 14 19 18 13 50 10418 51 8483 51 687 50 66 51 159 50 1 50 16 50 883 51 54 50 28 51 644 50 423 51 43 50 12 50 1276 51 0.814263774236898 51 8483 10418 0.081649631566437 50 687 8414 0.066537530266344 50 687 10325 0.043513295729251 50 54 1241 0.692006269592476 51 883 1276   0 51 8 50 4 50 4 50 11 50 16 50 9 50 14 50 0 51 1 50 10 49 22 49 10 49 24 49 26 49 32 49 34 49 0 50 1 28 534 365 613 0 0 0 14 50 23 50 0 20 5 21 103 1 21 50 409 50 544 50 0 50 1 48 0 48 0 43 2 50 21 50 22 50
37015 MD 2022/08/16 8 27 18 10 26 17 27 52 10435 53 8529 53 800 52 75 53 153 52 3 52 7 52 845 53 76 52 58 53 769 52 602 53 31 52 20 52 1268 53 0.817345471969334 53 8529 10435 0.094551471457275 52 800 8461 0.07735447689035 52 800 10342 0.061788617886179 52 76 1230 0.666403785488959 53 845 1268   2 51 4 49 14 50 5 49 3 50 11 49 23 50 12 49 1 53 4 51 16 48 22 48 9 48 23 49 25 49 24 48 30 48 0 52 2 27 1495 365 971 0 0 0 1 52 1 52 0 18 5 19 6 0 19 52 324 52 527 52 2 52 0 48 1 48 0 45 4 52 18 52 19 52
23581 MD 2022/10/29 12 22 20 15 21 18 25 53 10969 54 9017 54 685 53 57 54 136 53 0 53 18 53 858 54 75 53 48 54 636 53 418 54 49 53 11 53 1268 54 0.822043942018416 54 9017 10969 0.076476498827732 53 685 8957 0.062982714233174 53 685 10876 0.060827250608273 53 75 1233 0.676656151419558 54 858 1268   0 54 3 53 8 53 3 53 4 53 8 53 17 53 14 53 0 54 0 53 17 52 17 52 6 52 21 52 21 52 21 52 33 52 0 53 2 29 1574 365 1651 3 0 0 3 53 13 53 0 21 5 22 48 0 22 53 515 53 652 53 0 53 0 51 0 51 0 46 3 53 23 53 23 53
28354 MD 2022/10/30 12 22 20 15 21 18 24 53 10954 54 8821 54 681 53 44 54 116 53 0 53 16 53 842 54 76 53 53 54 635 53 430 54 46 53 9 53 1254 54 0.805276611283549 54 8821 10954 0.07774860143852 53 681 8759 0.062689864678266 53 681 10863 0.062295081967213 53 76 1220 0.671451355661882 54 842 1254   0 54 0 53 1 53 4 53 3 53 9 53 13 53 14 53 0 54 0 53 8 52 14 52 6 52 15 52 23 52 28 52 22 52 0 53 1 29 1574 365 1651 3 0 0 2 53 13 53 1 21 5 22 56 0 22 53 504 53 642 53 0 53 0 51 0 51 0 46 2 53 22 53 21 53
40125 MD 2022/09/02 6 30 18 10 27 17 23 53 11066 54 9257 54 690 53 79 54 160 53 2 53 9 52 866 54 77 53 51 54 662 53 502 54 28 53 11 53 1258 54 0.836526296764865 54 9257 11066 0.074894171279713 53 690 9213 0.062875888463641 53 690 10974 0.062908496732026 53 77 1224 0.688394276629571 54 866 1258   0 53 5 49 4 48 8 48 10 48 10 48 21 48 21 48 0 54 2 50 16 47 21 46 10 47 26 46 30 47 26 47 29 47 0 53 4 25 1551 365 1060 0 0 0 2 53 0 53 0 17 5 18 5 0 18 53 403 53 638 53 2 52 0 46 0 47 0 46 2 52 17 53 19 53
32620 NJ 2022/11/28 7 59 10 7 59 10 14 75 21224 76 14743 76 1164 75 173 76 72 75 9 75 8 75 1202 76 118 75 110 76 1130 75 1085 76 34 75 11 75 2828 76 0.694638145495665 76 14743 21224 0.078952723326324 75 1164 14743 0.05484357331323 75 1164 21224 0.041725601131542 75 118 2828 0.425035360678925 76 1202 2828   1 76 10 76 15 76 9 76 10 76 32 76 33 76 61 76 2 76 1 75 5 75 5 75 5 75 15 75 14 75 16 75 11 75 0 75 8 74 1376 256 1257 1 0 0 69 75 128 75 1 68 5 74 506 18 74 75 550 75 792 75 2 75 0 75 1 75 6 75 5 75 114 75 130 75
24939 NJ 2022/12/09 7 68 11 8 69 9 20 85 23537 86 16914 86 1351 85 179 86 74 85 11 85 7 85 1297 86 111 85 107 86 1315 85 1259 86 36 85 8 85 2825 86 0.718613247227769 86 16914 23537 0.079874660044933 85 1351 16914 0.057398988826104 85 1351 23537 0.03929203539823 85 111 2825 0.459115044247788 86 1297 2825   3 86 5 86 12 86 8 86 24 86 39 86 34 86 53 86 2 86 0 85 5 85 4 85 4 85 15 85 13 85 20 85 12 85 1 85 10 83 1141 209 994 0 0 0 83 85 108 85 1 77 5 83 580 27 83 85 542 85 803 85 5 85 0 85 1 85 5 85 4 85 107 85 137 85
32341 NJ 2022/12/08 7 68 11 8 69 9 20 85 23537 86 16914 86 1351 85 179 86 74 85 11 85 7 85 1297 86 111 85 107 86 1315 85 1259 86 36 85 8 85 2825 86 0.718613247227769 86 16914 23537 0.079874660044933 85 1351 16914 0.057398988826104 85 1351 23537 0.03929203539823 85 111 2825 0.459115044247788 86 1297 2825   3 86 5 86 12 86 8 86 24 86 39 86 34 86 53 86 2 86 0 85 5 85 4 85 4 85 15 85 13 85 20 85 12 85 1 85 10 83 1141 209 994 0 0 0 83 85 108 85 1 77 5 83 580 27 83 85 542 85 803 85 5 85 0 85 1 85 5 85 4 85 107 85 137 85
26307 NJ 2022/12/04 5 77 10 8 75 9 10 91 23867 92 16714 92 1305 91 171 92 69 91 10 91 6 91 1252 92 124 91 112 92 1263 91 1190 92 42 91 15 91 2826 92 0.700297481878745 92 16714 23867 0.078078257747996 91 1305 16714 0.054678007290401 91 1305 23867 0.043878273177636 91 124 2826 0.443029016277424 92 1252 2826   2 91 3 91 11 91 10 92 17 91 26 91 35 91 65 91 2 92 2 90 0 90 9 91 5 90 13 90 11 90 18 90 11 90 0 91 17 89 1165 209 1166 0 0 0 98 91 117 91 0 83 5 89 552 25 89 91 589 91 865 91 5 91 1 90 2 90 2 91 5 91 113 91 136 91
27015 KY 2022/01/23 34 79 4 50 63 4 91 115 11519 117 8960 117 2594 115 264 117 102 115 6 115 10 114 1242 117 452 115 454 117 2515 115 2335 117 79 115 44 115 1421 117 0.7778452990711 117 8960 11519 0.294037633189753 115 2594 8822 0.228767968956698 115 2594 11339 0.329206117989803 115 452 1373 0.874032371569317 117 1242 1421   2 115 20 115 27 115 30 114 63 114 77 114 79 114 68 114 211 117 3 113 11 113 11 113 13 112 18 112 21 112 22 112 17 112 2 115 29 108 44 0 0 0 0 0 5 115 3 115 2 108 5 64 28 4 108 115 354 110 627 109 2 109 1 109 3 109 0 112 4 108 31 109 63 109
40410 FL 2022/06/21 6 158 75 33 145 61 125 233 55469 239 43513 239 3646 233 633 239 231 233 29 233 16 233 4728 239 382 233 365 239 3563 233 3307 239 83 233 69 233 6533 239 0.784456182732698 239 43513 55469 0.085133210357952 233 3646 42827 0.066763106333889 233 3646 54611 0.059921568627451 233 382 6375 0.723710393387418 239 4728 6533   1 232 25 228 52 229 31 229 77 231 111 231 145 229 158 232 33 239 0 231 19 222 17 222 23 222 35 224 49 223 36 222 44 223 8 233 26 128 4127 0 2767 1184 0 233 27 233 44 233 0 122 5 122 224 17 125 233 1750 233 2618 233 13 233 7 223 7 223 2 231 17 233 672 233 918 233
23350 CA 2022/12/07 6 91 274 110 220 41 86 363 63220 371 52790 371 5000 363 742 371 402 363 23 363 22 363 5346 371 510 363 477 371 4857 363 4333 371 143 363 118 363 6776 371 0.835020563112939 371 52790 63220 0.095866247411611 363 5000 52156 0.080030731801012 363 5000 62476 0.077167498865184 363 510 6609 0.788961038961039 371 5346 6776   5 369 37 367 61 366 52 366 70 365 125 366 165 367 226 367 1 371 6 363 29 358 33 358 25 358 55 357 79 358 86 358 89 358 0 352 2 73 992 165 8 0 0 0 254 363 378 363 0 46 5 300 2085 114 300 363 2750 363 3730 363 17 363 2 128 4 358 0 363 35 363 782 363 1016 363
25736 CA 2022/12/09 6 89 277 99 216 57 81 364 71283 372 54493 372 5033 364 708 372 363 364 20 364 16 363 5113 372 537 364 494 372 4894 364 4288 372 139 364 120 364 6708 372 0.764459969417673 372 54493 71283 0.093447706047272 364 5033 53859 0.071350600377096 364 5033 70539 0.08209753860266 364 537 6541 0.762224209898628 372 5113 6708   4 369 27 366 54 366 45 366 58 366 140 367 152 366 226 368 2 371 5 363 25 358 25 358 25 358 41 358 71 358 79 357 92 358 0 350 5 74 814 165 13 0 0 0 237 363 241 362 0 47 5 301 1670 107 302 363 2936 364 3954 364 9 364 6 131 5 359 0 363 30 364 992 364 1261 364
33475 CA 2022/12/08 6 89 277 99 216 57 81 364 71283 372 54493 372 5033 364 708 372 363 364 20 364 16 363 5113 372 537 364 494 372 4894 364 4288 372 139 364 120 364 6708 372 0.764459969417673 372 54493 71283 0.093447706047272 364 5033 53859 0.071350600377096 364 5033 70539 0.08209753860266 364 537 6541 0.762224209898628 372 5113 6708   4 369 27 366 54 366 45 366 58 366 140 367 152 366 226 368 2 371 5 363 25 358 25 358 25 358 41 358 71 358 79 357 92 358 0 350 5 74 814 165 13 0 0 0 237 363 241 362 0 47 5 301 1670 107 302 363 2936 364 3954 364 9 364 6 131 5 359 0 363 30 364 992 364 1261 364

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