hospitals_state

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

37 rows where previous_day_admission_adult_covid_confirmed_20-29 = 43 sorted by previous_day_admission_influenza_confirmed_coverage

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: previous_day_admission_pediatric_covid_suspected, previous_day_admission_adult_covid_confirmed_18-19, previous_day_admission_adult_covid_confirmed_30-39, previous_day_admission_adult_covid_suspected_18-19_coverage, previous_week_therapeutic_a_casirivimab_imdevimab_courses_used, previous_day_admission_influenza_confirmed, previous_day_admission_pediatric_covid_confirmed_12_17_coverage, staffed_icu_pediatric_patients_confirmed_covid

staffed_adult_icu_bed_occupancy_coverage ✖

previous_day_admission_pediatric_covid_confirmed_5_11 ✖

previous_day_admission_adult_covid_confirmed_20-29 ✖

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
5253 5253 CA 2020/07/31 89 237 64 108 218 64 59 376 62895 378 45515 380 8007 390 827 342 721 343 19 305 19 303 5526 359 2098 360 1941 359 7889 381 6518 380 115 372 89 371 7262 355 0.721583591700453 378 45384 62895 0.171437987476656 380 7803 45515 0.12406391605056 378 7803 62895 0.287033209315144 352 2083 7257 0.759570366290278 355 5516 7262   6 301 43 301 67 301 99 329 154 305 160 305 146 303 136 306 16 342 4 300 37 300 48 302 99 327 111 309 136 306 125 306 156 304 5 343 105 344               0   0   0   0     0 0 2764 369 5439 368   0   0   0   0 23 359 850 359 1735 355
35854 35854 NJ 2022/01/01 14 70 12 19 66 11 191 95 24488 96 16269 96 4539 95 759 96 135 95 14 95 3 95 1371 96 543 95 542 96 4454 95 4273 96 69 95 10 95 3028 96 0.66436622018948 96 16269 24488 0.278996865203762 95 4539 16269 0.185356092780137 95 4539 24488 0.179326287978864 95 543 3028 0.452774108322325 96 1371 3028   3 96 43 96 52 96 81 96 105 96 120 96 148 96 175 96 32 96 1 95 5 95 6 95 18 95 20 95 14 95 17 95 17 95 37 95 41 95 776 233 826 202 0 722 13 77 6 77 0 77 1 77 119 9 77 77 349 30 367 29   0   0   0   0   0 40 29 107 29
41034 41034 NJ 2022/01/07 15 70 11 19 66 11 295 95 24437 96 17813 96 6161 95 935 96 103 95 20 95 6 95 1532 96 744 95 739 96 6047 95 5822 96 114 95 20 95 3002 96 0.72893563039653 96 17813 24437 0.345870993094931 95 6161 17813 0.252117690387527 95 6161 24437 0.247834776815456 95 744 3002 0.510326449033977 96 1532 3002   11 96 43 96 61 96 69 96 115 96 169 96 192 96 226 96 49 96 1 95 7 95 3 95 12 95 11 95 11 95 18 95 14 95 26 95 83 95 687 161 711 9 0 228 19 77 5 77 0 77 0 77 112 16 77 77 377 29 371 29   0   0   0   0   0 46 29 107 29
38783 38783 AZ 2022/01/27 13 81 27 33 79 9 77 117 17754 121 14480 121 3744 118 526 121 148 118 25 118 8 118 1470 121 562 118 571 121 3590 118 3436 121 154 118 129 118 1867 121 0.815590852765574 121 14480 17754 0.263217097862767 118 3744 14224 0.214518993869249 118 3744 17453 0.310840707964602 118 562 1808 0.787359400107124 121 1470 1867   0 118 43 115 49 116 41 116 79 118 100 115 99 115 109 117 6 121 1 117 12 111 11 112 19 113 19 112 37 110 23 110 26 111 0 118 20 51 2286 663 1712 56 0 76 7 99 3 99 0 69 0 69 40 6 69 99 621 53 696 52 7 54 5 53 1 53 7 70 4 52 117 51 132 51
35731 35731 NC 2022/01/18 10 98 13 13 95 13 126 117 21846 121 17298 121 5171 117 580 121 230 117 16 117 18 117 1950 121 831 117 819 121 5013 117 4529 121 158 117 118 117 2303 121 0.791815435319967 121 17298 21846 0.302521500029252 117 5171 17093 0.239597812992308 117 5171 21582 0.371147833854399 117 831 2239 0.84672166739036 121 1950 2303   2 121 43 120 41 120 49 120 91 120 134 120 115 120 105 120 0 121 0 117 24 115 21 115 18 115 28 115 43 115 55 115 41 115 0 117 44 110 141 0 140 3 0 0 2 117 7 117 0 106 0 106 23 6 106 117 0 15 8 15 0 18 0 17 0 17 0 20 0 17 0 15 0 15
42378 42378 NC 2022/01/27 8 112 12 11 62 59 122 128 23699 132 19346 132 5504 128 559 132 244 128 19 127 23 128 2016 132 857 128 849 132 5339 128 4931 132 165 128 116 128 2307 132 0.816321363770623 132 19346 23699 0.288077043860567 128 5504 19106 0.234972677595628 128 5504 23424 0.383102369244524 128 857 2237 0.873862158647594 132 2016 2307   8 131 43 129 43 129 41 130 75 130 124 129 123 130 97 130 5 132 3 126 19 125 31 124 17 125 29 125 44 125 59 125 42 125 0 128 58 110 201 0 182 1 0 0 2 128 3 128 0 110 0 110 18 3 110 128 166 26 245 26 0 26 2 25 0 26 0 30 0 28 0 26 0 26
46072 46072 MO 2022/01/21 18 85 38 48 68 25 81 137 17444 141 14535 141 3917 137 421 141 173 137 25 137 27 137 1661 141 735 137 730 141 3763 137 3605 141 154 137 128 137 1884 141 0.833237789497822 141 14535 17444 0.273514419384121 137 3917 14321 0.228383184653956 137 3917 17151 0.407202216066482 137 735 1805 0.881634819532909 141 1661 1884   6 128 43 123 36 127 34 123 69 127 87 122 80 124 63 122 3 141 2 133 17 119 15 118 17 119 28 117 35 114 30 116 29 115 0 137 27 80 2696 408 1079 553 7 228 7 129 11 129 0 77 0 77 44 7 77 129 563 77 696 86 7 77 5 70 1 71 12 103 7 76 112 77 132 85
37044 37044 GA 2022/01/25 35 88 34 43 79 35 89 154 20959 157 18057 157 5700 154 730 157 107 154 35 154 26 154 2373 157 995 154 945 157 5531 154 5218 157 169 154 131 154 2655 157 0.861539195572308 157 18057 20959 0.319202553620429 154 5700 17857 0.275721956174721 154 5700 20673 0.3821044546851 154 995 2604 0.893785310734463 157 2373 2655   7 157 43 155 58 155 57 155 97 155 146 155 148 155 110 155 14 157 1 154 4 152 4 152 9 152 18 152 23 152 23 151 15 151 12 154 32 105 3125 1455 3104 820 17 218 16 130 7 130 0 104 0 104 26 35 104 130 74 68 130 68 3 73 0 72 1 72 5 77 0 68 18 69 22 68
38804 38804 OK 2022/01/26 12 123 16 59 90 2 46 149 10282 151 8097 151 2396 149 432 151 102 149 8 149 11 149 942 151 424 149 442 151 2287 149 2288 151 109 149 104 149 1018 151 0.78749270569928 151 8097 10282 0.301915322580645 149 2396 7936 0.237086879081734 149 2396 10106 0.434426229508197 149 424 976 0.925343811394892 151 942 1018   3 150 43 144 35 145 19 145 65 145 82 146 93 146 81 145 11 151 0 149 12 142 6 142 3 142 17 141 23 142 26 142 14 142 1 149 9 46 2735 493 2647 755 0 386 11 140 10 140 0 38 0 38 45 1 38 140 107 48 168 48 1 52 0 47 0 47 7 131 17 49 44 48 84 48
48947 48947 GA 2021/09/01 43 103 23 44 102 23 22 166 23241 169 19883 169 6494 166 775 169 172 166 18 166 72 166 2701 169 1507 166 1491 169 6319 166 5971 169 175 166 105 166 2827 169 0.855513962394045 169 19883 23241 0.330533923754263 166 6494 19647 0.283135681897454 166 6494 22936 0.544830079537238 166 1507 2766 0.955429784223558 169 2701 2827   8 168 43 168 80 168 106 169 148 168 132 168 104 168 54 168 33 169 0 166 10 165 17 165 15 165 24 165 24 165 26 165 16 165 37 166 113 166 12664 4133 1438 6405 0 158 3 147 4 147 1 147 1 147 14 6 147 147 625 88 839 88   0   0   0   0   0 147 88 256 88
45285 45285 OK 2022/02/11 8 54 88 46 96 8 24 148 10314 150 7979 150 1497 148 305 150 96 148 6 148 3 148 892 150 284 148 287 150 1423 148 1382 150 74 148 67 148 1004 150 0.773608687221253 150 7979 10314 0.191481197237145 148 1497 7818 0.147735122865884 148 1497 10133 0.295218295218295 148 284 962 0.888446215139442 150 892 1004   0 149 43 143 25 143 16 143 33 143 71 144 62 144 47 144 8 150 1 147 8 141 9 141 4 142 16 141 22 141 23 141 13 141 0 148 12 42 2363 178 2351 123 0 27 3 148 16 148 0 37 0 37 46 1 37 148 458 148 571 148 2 148 0 140 0 140 4 139 4 148 110 148 144 148
52540 52540 GA 2021/08/27 42 105 23 43 104 23 23 167 23481 170 19830 170 6279 167 807 170 144 167 22 167 71 167 2662 170 1468 167 1451 170 6128 167 5779 170 151 167 102 167 2844 170 0.844512584642903 170 19830 23481 0.32006320725864 167 6279 19618 0.270845015744295 167 6279 23183 0.527488321954725 167 1468 2783 0.936005625879044 170 2662 2844   2 170 43 170 79 170 92 170 156 170 149 170 114 170 53 170 51 170 0 167 10 167 8 167 12 167 16 167 17 167 20 167 7 167 50 167 101 167 7667 3019 1185 4383 0 138 3 148 3 148 1 148 0 148 19 8 148 148 687 88 839 88   0   0   0   0   0 152 88 267 88
57389 57389 GA 2021/09/08 46 101 23 47 99 24 20 167 23477 170 19597 170 6401 167 695 169 168 167 31 166 46 167 2720 170 1614 167 1597 170 6285 167 5899 170 116 167 90 167 2855 170 0.834731865229799 170 19597 23477 0.330391245999794 167 6401 19374 0.27621472339691 167 6401 23174 0.577666428060129 167 1614 2794 0.952714535901926 170 2720 2855   3 169 43 169 69 170 102 169 102 169 115 169 99 169 47 170 51 170 0 167 8 166 6 166 10 166 22 166 32 166 30 166 13 166 50 167 100 167 11347 4242 1680 6742 0 55 2 148 5 148 1 148 0 148 19 8 148 148 617 86 829 86   0   0   0   0   0 159 86 267 86
43013 43013 MI 2022/01/01 40 120 4 43 117 4 45 160 21892 164 17302 164 4117 160 494 164 62 160 23 160 8 160 2031 164 835 160 821 164 4012 160 3832 164 105 160 90 160 2516 164 0.790334368719167 164 17302 21892 0.239416143289137 160 4117 17196 0.189548802946593 160 4117 21720 0.336965294592413 160 835 2478 0.807233704292528 164 2031 2516   1 163 43 161 45 161 47 162 83 161 109 162 91 162 57 161 18 164 1 160 2 157 5 157 5 157 10 157 18 157 13 157 8 157 0 160 70 160 5058 2287 7751 1568 63 1606 8 156 14 156 0 156 0 156 63 7 156 156 354 59 483 59   0   0   0   0   0 180 59 248 59
47445 47445 MI 2021/12/31 33 127 4 36 124 4 42 160 22244 164 18153 164 4066 160 537 164 62 160 24 160 13 160 2111 164 819 160 807 164 3964 160 3761 164 102 160 89 160 2547 164 0.816085236468261 164 18153 22244 0.225363041791376 160 4066 18042 0.184181917013952 160 4066 22076 0.326424870466321 160 819 2509 0.828818217510797 164 2111 2547   2 164 43 163 50 163 48 163 92 163 99 163 95 163 90 163 18 164 0 160 4 159 8 159 5 159 10 159 13 159 13 159 9 159 0 160 61 160 5096 2263 8002 1644 63 1701 5 159 13 159 0 159 0 159 60 6 159 159 404 56 530 56   0   0   0   0   0 175 56 261 56
50264 50264 MI 2021/03/28 2 158 4 3 157 4 6 160 23116 164 17376 164 2122 160 368 164 70 160 2 160 6 160 1916 164 428 160 408 164 2096 160 1960 164 26 160 14 160 2563 164 0.751687143104343 164 17376 23116 0.122900498088729 160 2122 17266 0.092623308598865 160 2122 22910 0.169639318271899 160 428 2523 0.747561451424112 164 1916 2563   0 164 43 163 36 163 39 163 65 163 64 163 74 163 26 163 21 164 2 160 8 159 5 159 6 159 11 159 16 159 13 159 7 159 2 160 20 160 2808 9590 215 29 369 56 0 160 1 160 0 160 0 160 3 0 160 160 480 64 599 64   0   0   0   0   0 187 64 266 64
37933 37933 OH 2021/12/27 37 147 15 46 138 15 56 195 27903 199 20484 199 5457 195 657 199 239 195 21 195 66 195 3078 199 1240 195 1216 199 5247 195 5046 199 210 195 98 195 3909 199 0.734114611332115 199 20484 27903 0.268897210998325 195 5457 20294 0.197767549740876 195 5457 27593 0.322664584959667 195 1240 3843 0.787413660782809 199 3078 3909   9 199 43 199 59 199 65 199 129 199 146 199 121 199 84 199 1 199 5 195 21 195 17 195 13 195 36 195 47 195 40 195 31 195 4 195 83 195 948 1783 1370 148 0 496 11 194 18 194 0 183 1 185 119 9 183 194 336 76 1055 76   0   0   0   0   0 166 76 400 76
35587 35587 FL 2021/09/22 42 172 55 43 171 55 115 263 59707 269 48435 269 7875 263 801 269 229 263 32 263 27 263 5777 269 2027 263 2035 269 7726 263 7379 269 149 263 128 263 6717 269 0.811211415746897 269 48435 59707 0.164997485752598 263 7875 47728 0.134015179878153 263 7875 58762 0.310223446587083 263 2027 6534 0.860056572874795 269 5777 6717   4 269 43 268 79 268 87 268 133 268 163 268 139 267 126 268 27 269 3 263 17 262 21 262 23 262 49 262 37 262 38 262 40 262 1 263 168 263 18811 3189 3644 2881 0 5 4 254 2 254 0 255 0 254 28 9 255 254 3228 263 4038 263   0   0   0   0   0 1316 263 1718 263
27100 27100 FL 2022/08/18 6 189 71 15 191 60 118 260 59533 266 46469 266 3790 260 593 266 169 260 61 260 53 260 4688 266 447 260 429 266 3704 260 3461 266 86 260 74 260 6483 266 0.78055868173954 266 46469 59533 0.082569007211172 260 3790 45901 0.064386796459576 260 3790 58863 0.070205748390137 260 447 6367 0.723122011414469 266 4688 6483   0 260 43 252 32 254 43 252 68 252 73 253 141 253 162 255 32 266 2 256 7 246 16 247 11 246 22 244 34 246 41 246 34 247 2 260 13 151 4456 0 1551 842 0 62 7 260 10 260 0 142 0 142 68 10 145 260 1927 260 2791 260 20 260 12 246 1 246 35 258 18 260 632 260 909 260
58168 58168 FL 2021/04/24 9 243 15 24 228 15 103 261 58561 267 45004 267 3766 261 512 267 252 261 13 261 17 261 4956 267 838 261 767 267 3726 261 3369 267 40 261 30 261 6415 267 0.76849780570687 267 45004 58561 0.084896302975654 261 3766 44360 0.065375134534597 261 3766 57606 0.13505237711523 261 838 6205 0.772564302416212 267 4956 6415   0 267 43 267 53 267 61 267 105 266 109 267 67 267 61 266 13 267 4 261 22 261 36 261 31 261 33 261 49 261 46 261 31 260 0 261 25 261 5528 6075 2573 177 199 438 11 261 5 261 0 261 0 261 62 6 261 261 2638 260 3821 260   0   0   0   0   0 1135 260 1599 260
32202 32202 CA 2023/01/01 7 71 281 86 206 67 92 350 60938 358 47183 358 5072 350 674 359 301 359 25 351 17 350 4831 357 533 350 505 358 4882 350 4437 358 174 350 150 350 6606 357 0.774278775148512 358 47183 60938 0.108887934735938 350 5072 46580 0.084252491694352 350 5072 60200 0.082622849170671 349 533 6451 0.731304874356646 357 4831 6606   4 358 43 357 55 356 32 356 51 356 125 356 153 356 211 356 7 358 2 358 14 356 27 356 22 356 34 355 61 355 68 355 73 355 0 346 8 74 770 175 28 0 0 0 145 345 152 345 0 50 9 277 1003 46 276 344 2307 350 3388 350 14 350 7 349 3 348 1 350 58 350 740 349 1022 349
30257 30257 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
27047 27047 CA 2022/09/08 6 101 281 85 232 71 44 380 61872 388 49456 388 3218 366 493 388 294 380 27 379 22 355 4896 371 379 363 358 371 3080 366 2777 374 138 362 125 362 6642 371 0.799327644168606 388 49456 61872 0.065912908115194 366 3218 48822 0.052672068090678 366 3218 61095 0.058406534134689 363 379 6489 0.737127371273713 371 4896 6642   4 362 43 384 49 359 35 359 59 360 87 360 72 358 142 361 2 364 5 355 23 350 28 350 32 351 35 350 69 351 50 350 51 351 1 345 4 108 6204 295 2387 300 0 0 2 356 3 355 0 87 0 325 57 3 326 357 2496 378 3653 378 15 353 7 375 5 349 0 356 48 359 720 358 983 358
34213 34213 CA 2022/08/01 6 98 272 114 224 38 111 368 61078 376 46416 376 5002 368 598 376 217 368 18 368 4 368 4603 376 521 368 509 376 4861 368 4588 376 141 368 129 367 6596 376 0.759946298176103 376 46416 61078 0.109078221427481 368 5002 45857 0.082899665219265 368 5002 60338 0.080850403476102 368 521 6444 0.697847180109157 376 4603 6596   6 375 43 371 73 371 33 371 72 371 100 371 101 371 169 372 1 375 2 368 25 363 25 363 20 363 27 363 30 362 43 363 45 363 0 368 19 107 7990 1100 3144 305 0 0 5 368 7 368 0 336 0 336 36 0 336 368 2008 368 3502 368 7 368 9 363 2 361 0 366 36 367 590 368 955 368
41611 41611 CA 2021/09/17 108 275 34 132 250 35 53 409 65129 417 52140 417 6654 409 590 417 398 409 12 409 18 409 5787 417 1800 409 1777 417 6541 409 6260 417 113 409 96 409 7207 417 0.800565032474013 417 52140 65129 0.129168769654851 409 6654 51514 0.103430587723252 409 6654 64333 0.255936300298592 409 1800 7033 0.802969335368392 417 5787 7207   6 417 43 416 76 415 90 416 90 416 112 416 97 416 74 416 2 417 4 409 41 408 42 408 46 408 61 408 75 408 70 408 57 408 2 409 97 409 9428 8632 3423 2326 0 175 0 368 1 368 0 368 0 368 8 5 367 368 3978 407 6208 407   0   0   0   0   0 2410 407 3700 407
58203 58203 CA 2021/02/23 115 253 14 135 234 13 33 374 62050 382 46562 382 6757 373 628 382 563 374 16 373 14 373 6003 381 1824 373 1779 381 6648 373 6123 381 109 373 94 373 7679 381 0.750394842868654 382 46562 62050 0.147144008187975 373 6757 45921 0.110578339279285 373 6757 61106 0.245392170052469 373 1824 7433 0.781742414376872 381 6003 7679   5 381 43 381 60 381 62 381 100 381 124 381 128 381 103 381 3 381 3 373 34 373 49 373 55 373 91 373 115 373 119 373 93 373 4 373 134 373 10153 20572   104 366   6 370 3 371 0 371 0 371 25 15 371 371 3102 372 5478 372   0   0   0   0   0 2029 372 3557 372
5692 5692 CA 2020/11/18 65 334 11 82 317 11 56 402 67278 410 49926 410 5326 400 710 410 556 402 5 400 13 399 5676 408 1252 400 1181 407 5275 400 4571 408 51 398 37 398 7555 408 0.742085079818068 410 49926 67278 0.108065334280207 400 5326 49285 0.080251936232408 400 5326 66366 0.171108377750444 400 1252 7317 0.751290536068829 408 5676 7555   5 403 43 403 50 403 89 403 140 403 148 403 124 403 110 403 1 407 2 395 28 395 42 395 49 395 99 394 96 395 125 395 107 395 8 398 76 400             8 382 10 378 0 380 0 380 54 36 378 378 3558 400 6250 400   0   0   0   0   0 2001 400 3551 400
27894 27894 CA 2022/08/20 8 134 261 100 264 39 72 395 63462 403 48821 403 3753 395 570 403 291 395 20 395 15 395 4749 403 433 395 408 403 3602 395 3330 403 151 395 141 394 6706 403 0.769295011187797 403 48821 63462 0.077808185097649 395 3753 48234 0.059866962305987 395 3753 62689 0.066086691086691 395 433 6552 0.708171786459887 403 4749 6706   3 398 43 385 53 384 37 384 84 385 89 385 116 387 142 385 4 399 3 392 15 377 34 377 24 376 44 377 64 376 52 377 55 377 0 394 4 120 7959 926 3071 305 0 1 4 394 9 394 0 330 0 330 22 3 330 394 2387 395 3750 395 13 391 3 377 4 372 0 391 41 394 643 395 964 395
41583 41583 CA 2022/02/13 10 143 262 132 248 35 161 407 66237 415 52063 415 8725 407 792 415 308 407 25 399 15 404 5664 415 1605 407 1604 415 8457 407 8125 415 252 407 232 406 7184 415 0.786010839862916 415 52063 66237 0.169493171707753 407 8725 51477 0.133293612600639 407 8725 65457 0.228730226592561 407 1605 7017 0.788418708240534 415 5664 7184   3 411 43 401 72 401 75 401 99 400 171 400 153 399 171 401 5 411 5 404 17 395 28 395 24 395 47 395 61 395 59 394 67 394 0 407 25 134 8335 611 3431 310 0 8 3 407 1 407 0 346 0 347 41 3 347 407 2333 404 3681 404 11 397 6 390 8 389 0 398 49 403 653 404 945 404
50308 50308 CA 2021/03/12 97 308 13 110 296 12 37 410 64133 418 47762 418 3725 410 409 418 467 410 11 410 9 410 5403 418 976 410 937 418 3649 410 3244 417 76 410 61 410 7401 418 0.744733600486489 418 47762 64133 0.079006532620684 410 3725 47148 0.058902593295383 410 3725 63240 0.135952082462739 410 976 7179 0.730036481556546 418 5403 7401   2 417 43 417 52 417 62 417 56 417 72 417 62 416 60 417 0 418 5 409 35 409 43 409 46 409 69 409 94 409 87 409 86 409 2 410 84 410 10189 20217   37 149   4 410 3 409 0 410 0 410 18 2 410 410 3598 408 6090 408   0   0   0   0   0 2113 408 3591 408
26100 26100 TX 2022/06/28 7 79 416 9 77 416 109 497 59068 502 45871 502 2756 497 419 502 283 497 49 497 69 497 5220 502 398 497 354 502 2547 497 2261 502 209 497 131 497 5930 502 0.776579535450667 502 45871 59068 0.06093166191329 497 2756 45231 0.047242744741759 497 2756 58337 0.068762957843815 497 398 5788 0.88026981450253 502 5220 5930   5 500 43 497 32 497 31 497 48 497 76 497 80 497 96 497 19 502 4 495 22 492 27 492 24 492 45 492 56 492 63 492 37 492 5 497 14 491 328 0 85 0 0 0 9 497 12 497 0 91 0 91 97 12 91 497 3438 497 3943 497 23 495 15 492 11 492 0 497 27 497 879 497 1018 497
7996 7996 TX 2020/11/19 148 432 5 171 409 5 137 580 73026 584 55368 585 8934 580 1241 585 819 580 21 580 63 580 6568 585 2307 580 2239 585 8812 580 8176 585 122 580 88 580 7619 585 0.747843233916687 584 54612 73026 0.163109561280193 580 8934 54773 0.12222637487369 579 8830 72243 0.310289172831204 580 2307 7435 0.862055387846174 585 6568 7619   6 584 43 584 85 584 121 584 203 584 229 584 267 584 175 584 112 585 8 579 50 579 45 579 86 579 130 578 146 580 148 578 112 579 94 580 101 580             11 580 21 578 1 578 0 578 139 218 578 578 391 40 1024 40   0   0   0   0   0 277 40 203 40
5279 5279 TX 2021/02/12 128 458 5 163 423 5 109 586 71142 591 51539 591 9060 586 858 591 496 586 14 586 68 586 6689 591 2656 586 2573 591 8931 586 8396 591 129 586 101 586 7721 591 0.724452503443817 591 51539 71142 0.177852810113661 586 9060 50941 0.128813944891518 586 9060 70334 0.352816153028693 586 2656 7528 0.866338557181712 591 6689 7721   4 591 43 591 54 591 85 591 146 591 196 591 162 591 119 591 49 591 4 586 35 586 48 586 61 586 73 586 96 586 84 586 67 586 28 586 150 586 69 432 0 0 44 0 13 586 6 586 1 586 0 586 66 258 586 586 362 39 1012 39   0   0   0   0   0 268 39 345 39
28801 28801 TX 2022/08/04 5 107 481 8 104 481 156 588 65026 593 50539 593 3926 588 583 593 318 588 55 588 92 588 5318 593 543 588 516 593 3656 588 3365 593 270 588 193 588 6030 593 0.777212192046258 593 50539 65026 0.078664743127354 588 3926 49908 0.061067039975113 588 3926 64290 0.092205807437596 588 543 5889 0.881923714759536 593 5318 6030   8 591 43 588 32 588 44 588 60 588 99 588 149 587 142 587 69 593 3 586 15 583 20 582 26 582 34 582 55 582 59 582 60 582 46 588 18 581 333 0 85 0 0 0 6 588 14 588 0 104 0 104 80 8 104 588 3821 587 4397 587 39 586 13 581 18 582 0 588 36 588 912 588 1085 587
24570 24570 TX 2022/07/23 6 106 482 10 102 482 149 589 63512 594 48742 594 3957 589 620 594 337 589 49 589 85 589 5154 594 595 589 546 594 3705 589 3415 594 252 589 172 589 5920 594 0.767445522106059 594 48742 63512 0.082187512981348 589 3957 48146 0.063024607788485 589 3957 62785 0.102941176470588 589 595 5780 0.870608108108108 594 5154 5920   4 592 43 589 39 589 43 588 76 588 104 588 142 588 157 589 29 594 3 587 15 583 28 583 23 583 40 583 37 583 68 583 52 583 71 589 24 581 346 0 35 0 0 0 2 589 18 589 0 104 0 104 90 9 104 589 3704 589 4239 589 36 587 10 582 12 582 0 589 34 589 957 589 1110 589
25594 25594 TX 2022/07/09 7 104 483 9 102 483 144 589 64618 594 49195 594 3358 589 643 594 360 589 47 589 74 589 5180 594 460 589 402 594 3150 589 2873 594 208 589 131 589 5983 594 0.761320375127673 594 49195 64618 0.06908185726923 589 3358 48609 0.05256155399377 589 3358 63887 0.078740157480315 589 460 5842 0.865786394785225 594 5180 5983   5 592 43 589 41 588 45 588 55 588 96 588 141 588 148 588 86 594 2 587 17 583 16 583 28 583 37 583 53 583 55 582 48 583 104 589 15 583 356 0 114 0 0 0 3 589 10 589 0 105 0 105 97 8 105 589 3790 589 4408 589 22 587 9 582 16 582 0 589 40 589 916 589 1056 589
45444 45444 TX 2022/02/16 12 108 476 14 106 476 139 591 67514 596 53121 596 7001 591 773 596 387 591 61 591 88 591 6203 596 1644 591 1606 596 6738 591 6296 596 263 591 215 591 6742 596 0.78681458660426 596 53121 67514 0.133446428911804 591 7001 52463 0.104899610428529 591 7001 66740 0.250647964628754 591 1644 6559 0.920053396618214 596 6203 6742   5 596 43 593 56 593 74 593 113 593 139 593 157 593 124 593 62 596 5 591 29 588 34 588 40 588 52 588 83 588 68 588 56 588 20 591 84 586 3319 701 1990 0 0 0 19 591 32 591 0 111 0 111 107 12 111 591 3837 591 4402 591 34 591 11 587 16 587 0 591 45 591 953 591 1111 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 8274.436ms · Data source: U.S. Department of Health & Human Services