hospitals_state

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

31 rows where previous_day_admission_pediatric_covid_confirmed_5_11_coverage = 584 sorted by total_pediatric_patients_hospitalized_confirmed_covid_coverage

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: critical_staffing_shortage_today_no, critical_staffing_shortage_today_not_reported, inpatient_beds_used_coverage, previous_day_admission_adult_covid_confirmed, previous_day_admission_adult_covid_suspected_coverage, staffed_adult_icu_bed_occupancy_coverage, staffed_icu_adult_patients_confirmed_and_suspected_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, adult_icu_bed_covid_utilization_numerator, previous_day_admission_adult_covid_confirmed_40-49, previous_day_admission_adult_covid_confirmed_50-59_coverage, previous_day_admission_adult_covid_confirmed_70-79, previous_day_admission_adult_covid_suspected_20-29, previous_day_admission_adult_covid_suspected_30-39_coverage, previous_day_admission_adult_covid_suspected_80+_coverage, deaths_covid, previous_day_admission_influenza_confirmed_coverage, previous_day_deaths_covid_and_influenza_coverage, previous_day_admission_pediatric_covid_confirmed_12_17_coverage, previous_day_admission_pediatric_covid_confirmed_unknown_coverage, 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

previous_day_admission_pediatric_covid_confirmed_5_11 ✖

previous_day_admission_pediatric_covid_confirmed_5_11_coverage ✖

  • 584 · 31 ✖
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
30202 30202 TX 2022/08/03 6 108 479 9 105 479 152 588 64501 593 49989 593 3843 588 599 593 308 588 50 588 76 588 5240 593 554 588 524 593 3582 588 3303 593 261 588 186 588 5950 593 0.775011240135812 593 49989 64501 0.077843947496354 588 3843 49368 0.060260611857683 588 3843 63773 0.09532002752925 588 554 5812 0.880672268907563 593 5240 5950   3 593 51 590 46 590 43 590 69 590 98 590 136 590 135 590 75 593 3 588 16 585 28 585 26 585 39 585 62 585 42 585 41 585 51 588 20 584 1754 660 626 0 0 0 8 588 8 588 0 105 0 105 41 9 105 588 3739 588 4321 588 37 588 7 584 20 584 0 588 42 588 899 588 1078 588
22418 22418 TX 2022/06/25 4 106 484 8 102 484 122 589 63969 594 48820 594 2576 589 413 594 284 589 42 589 68 589 5154 594 339 589 303 594 2406 589 2087 594 170 589 111 589 5881 594 0.763182166361832 594 48820 63969 0.0534262485482 589 2576 48216 0.040738866396761 589 2576 63232 0.059059233449477 589 339 5740 0.876381567760585 594 5154 5881   5 592 32 589 36 589 37 589 47 589 59 589 83 589 96 589 29 594 3 587 15 584 21 584 26 585 37 584 50 584 44 584 45 584 43 589 8 581 351 0 114 0 0 0 8 589 18 589 0 105 0 105 104 10 105 589 3813 589 4416 589 24 587 9 583 9 584 0 589 20 589 945 589 1095 589
23228 23228 TX 2022/05/22 6 104 484 10 100 484 73 589 63638 594 46707 594 1234 589 151 594 200 589 13 589 42 589 4897 594 203 589 170 594 1115 589 778 594 119 589 53 589 5769 594 0.733948269901631 594 46707 63638 0.026712847710791 589 1234 46195 0.019620313543422 589 1234 62894 0.036133855464578 589 203 5618 0.848847287224822 594 4897 5769   2 592 7 590 10 590 26 590 17 590 32 590 26 590 26 590 5 594 1 587 18 585 11 585 24 585 27 585 45 585 37 585 36 585 1 589 5 580 351 0 114 0 0 0 12 589 16 589 0 102 0 102 103 0 102 589 3721 589 4234 589 4 587 4 584 5 584 0 589 14 589 887 589 1019 589
24074 24074 TX 2022/07/27 7 105 482 10 102 482 155 589 64773 594 50499 594 3970 589 596 594 271 589 50 589 61 589 5411 594 615 589 573 594 3722 589 3490 594 234 589 176 589 6069 594 0.779630401556204 594 50499 64773 0.079595805681978 589 3970 49877 0.061986697061487 589 3970 64046 0.103744939271255 589 615 5928 0.891580161476355 594 5411 6069   7 593 48 591 41 590 40 591 63 590 124 590 127 590 137 591 24 594 3 588 9 586 26 585 28 586 32 585 57 585 52 585 58 586 6 589 30 583 1987 660 692 0 0 0 5 589 11 589 0 105 0 105 35 11 105 589 3779 589 4324 589 40 589 7 584 13 584 0 589 33 589 921 589 1069 589
25550 25550 TX 2022/05/29 6 105 483 8 103 483 74 589 63074 594 46419 594 1414 589 184 594 220 589 21 589 60 589 4833 594 199 589 152 594 1267 589 913 594 147 589 54 589 5750 594 0.735945080381774 594 46419 63074 0.030827592221156 589 1414 45868 0.022680247012591 589 1414 62345 0.035485021398003 589 199 5608 0.840521739130435 594 4833 5750   0 592 15 590 19 590 20 590 19 590 28 590 42 590 40 590 2 594 1 587 17 585 26 584 20 586 26 586 39 585 33 585 25 585 33 589 7 583 279 0 35 0 0 0 8 589 14 589 0 106 0 106 96 2 106 589 3690 589 4239 589 11 587 4 584 6 584 0 589 10 589 901 589 1050 589
26429 26429 TX 2022/05/27 6 107 481 9 104 481 76 589 64566 594 49003 594 1351 589 190 594 228 589 16 589 83 589 5082 594 201 589 165 594 1212 589 857 594 139 589 52 589 5906 594 0.758959824056005 594 49003 64566 0.027921299549456 589 1351 48386 0.021163938278374 589 1351 63835 0.034883720930233 589 201 5762 0.860480866915002 594 5082 5906   0 592 18 590 17 590 20 590 19 590 39 590 32 590 43 590 2 594 4 587 16 585 28 584 23 586 28 585 53 585 43 585 33 585 0 589 8 583 289 1 114 0 0 0 10 589 21 589 0 107 0 107 104 1 107 589 3924 589 4388 589 3 587 7 584 6 584 0 589 7 589 945 589 1068 589
29166 29166 TX 2022/05/26 6 106 482 8 104 482 76 589 65200 594 49635 594 1362 589 156 594 225 589 17 589 67 589 5138 594 217 589 160 594 1262 589 839 594 120 589 49 589 5943 594 0.761273006134969 594 49635 65200 0.02777607831141 589 1362 49035 0.021128071481757 589 1362 64464 0.037459002244088 589 217 5793 0.86454652532391 594 5138 5943   1 592 14 590 15 590 17 590 16 590 30 590 25 590 35 590 3 594 2 587 14 585 18 584 23 586 42 585 39 585 52 585 34 585 1 589 6 583 351 0 124 0 0 0 10 589 23 589 0 106 0 106 99 0 106 589 3862 589 4350 589 9 587 4 584 4 584 0 589 8 589 904 589 1027 589
30890 30890 TX 2022/05/21 6 104 484 10 100 484 77 589 64852 594 48420 594 1229 589 147 594 194 589 18 589 51 589 5107 594 195 589 157 594 1100 589 761 594 129 589 56 589 5935 594 0.746623080244248 594 48420 64852 0.025669409749781 589 1229 47878 0.019171073361723 589 1229 64107 0.033713692946058 589 195 5784 0.860488626790227 594 5107 5935   2 592 8 590 10 590 23 590 22 590 22 590 32 590 23 590 5 594 2 587 9 585 16 585 20 585 29 585 43 585 48 585 26 585 1 589 6 580 351 0 114 0 0 0 11 589 20 589 0 102 1 102 105 0 102 589 3828 589 4404 589 6 587 4 584 8 584 0 589 12 589 883 589 1017 589
31675 31675 TX 2022/05/20 6 106 482 16 111 467 79 589 65727 594 49779 594 1235 589 139 594 216 589 11 589 52 589 5177 594 188 589 148 594 1080 589 753 594 155 589 57 589 5995 594 0.757359989045598 594 49779 65727 0.02510162601626 589 1235 49200 0.01900555547006 589 1235 64981 0.032169746748802 589 188 5844 0.863552960800667 594 5177 5995   1 592 9 590 6 590 17 590 15 590 12 590 40 590 32 590 7 594 4 587 18 585 17 585 29 585 33 585 38 585 49 585 27 585 1 589 3 580 1030 28 129 0 0 0 10 589 22 589 0 118 0 118 113 1 118 589 3945 589 4481 589 5 587 3 584 3 584 0 589 13 589 899 589 1054 589
31767 31767 TX 2022/05/28 6 105 483 8 103 483 74 589 64373 594 47923 594 1377 589 191 594 262 589 15 589 82 589 5041 594 203 589 154 594 1229 589 867 594 148 589 48 589 5886 594 0.744458080251037 594 47923 64373 0.029081923588671 589 1377 47349 0.02163631507 589 1377 63643 0.035341225626741 589 203 5744 0.856439007815155 594 5041 5886   1 591 19 590 23 590 13 590 27 590 33 590 35 590 39 590 2 594 0 587 17 585 23 584 25 585 38 585 43 585 39 585 37 585 40 589 7 583 279 0 35 0 0 0 9 589 20 589 0 106 0 106 96 2 106 589 3863 589 4371 589 4 587 6 584 5 584 0 589 9 588 920 589 1069 589
32268 32268 TX 2022/06/26 5 105 484 9 101 484 119 589 62890 594 47048 594 2621 589 389 594 254 589 42 589 74 589 4921 594 367 589 321 594 2435 589 2144 594 186 589 106 589 5787 594 0.748099856892988 594 47048 62890 0.056399552418661 589 2621 46472 0.042168771619339 589 2621 62155 0.065013286093888 589 367 5645 0.85035424226715 594 4921 5787   2 592 29 589 24 589 31 589 48 589 61 589 80 589 100 589 25 594 2 587 15 584 22 584 29 585 45 585 46 584 46 584 26 584 23 589 13 581 351 0 114 0 0 0 11 589 12 589 0 104 0 104 101 10 104 589 3633 589 4218 589 26 587 8 583 8 584 0 589 23 589 916 589 1070 589
34096 34096 TX 2022/06/24 5 107 482 8 104 482 120 589 65225 594 50375 594 2505 589 447 594 282 589 32 589 78 589 5304 594 342 589 298 594 2314 589 2028 594 191 589 114 589 6033 594 0.772326561901112 594 50375 65225 0.050349734684033 589 2505 49752 0.038846243312398 589 2505 64485 0.058054659650314 589 342 5891 0.879164594728991 594 5304 6033   2 592 38 589 38 589 38 589 46 589 71 589 98 589 95 589 30 594 5 587 23 584 25 584 30 584 36 584 67 584 59 584 36 584 1 589 7 581 341 0 35 0 0 0 11 589 20 589 0 105 0 105 114 11 105 589 3858 589 4380 589 18 587 4 583 10 584 0 589 21 589 938 589 1084 589
35819 35819 TX 2022/02/23 11 108 475 12 107 475 112 589 66868 594 52578 594 4944 589 544 594 383 589 49 589 94 589 6024 594 1208 589 1159 594 4683 589 4343 594 261 589 179 589 6562 594 0.786295387928456 594 52578 66868 0.095150115473441 589 4944 51960 0.074793500953073 589 4944 66102 0.189104571070758 589 1208 6388 0.918012800975312 594 6024 6562   4 593 38 590 43 591 42 591 72 591 112 591 114 591 86 591 33 594 3 588 29 585 34 586 29 586 59 586 88 586 73 586 66 586 2 589 73 585 3864 702 1807 3 0 0 31 589 59 589 0 112 0 112 135 7 112 589 3878 589 4385 589 23 588 16 585 10 584 0 589 46 589 970 589 1110 589
41244 41244 TX 2022/03/24 10 105 479 12 103 479 78 589 66162 594 50135 594 1685 589 201 594 382 589 21 589 52 589 5316 594 346 589 301 594 1609 589 1229 594 92 589 60 589 6084 594 0.757761252682809 594 50135 66162 0.034019099150027 589 1685 49531 0.025753500030568 589 1685 65428 0.058347386172007 589 346 5930 0.873767258382643 594 5316 6084   1 592 9 590 17 590 17 590 27 590 31 590 29 590 22 590 48 594 3 587 25 585 45 585 32 586 46 585 81 585 63 585 43 585 44 589 19 581 355 0 114 0 0 0 29 589 103 589 0 110 1 110 328 4 110 589 3667 589 4213 589 7 587 4 584 6 584 4 589 13 589 882 589 1023 589
22101 22101 TX 2022/07/03 5 105 485 9 101 485 134 590 63432 595 46780 595 3025 590 413 595 232 590 48 590 67 590 4867 595 404 590 364 595 2819 590 2456 595 206 590 133 590 5729 595 0.737482658595031 595 46780 63432 0.065403991265054 590 3025 46251 0.048253309937789 590 3025 62690 0.072297780959198 590 404 5588 0.849537441089195 595 4867 5729   5 593 24 591 27 590 34 590 48 590 68 590 98 590 91 590 25 595 4 588 10 585 16 585 21 586 37 585 50 585 43 585 46 585 5 590 12 581 356 0 114 0 0 0 5 590 10 590 0 101 0 101 82 8 101 590 3598 590 4171 590 29 588 9 584 10 584 0 590 28 590 883 590 1048 590
22477 22477 TX 2022/07/14 5 108 482 11 102 482 154 590 65067 595 50707 595 3811 590 589 595 241 590 56 590 73 590 5285 595 508 590 472 595 3555 590 3233 595 256 590 170 590 5944 595 0.779304409301182 595 50707 65067 0.076099762375447 590 3811 50079 0.059238648904917 590 3811 64333 0.087525844245348 590 508 5804 0.889131897711978 595 5285 5944   8 593 34 589 53 589 52 589 55 589 116 589 113 589 136 589 34 595 3 588 10 584 32 584 26 584 28 584 45 584 48 584 44 584 5 590 15 581 358 0 114 0 0 0 5 590 15 590 0 104 0 104 104 8 104 590 3942 590 4490 590 34 588 14 583 19 584 0 590 28 590 930 590 1080 590
25723 25723 TX 2022/06/30 7 105 483 9 103 483 142 590 65299 595 50252 595 2937 590 508 595 263 590 51 590 78 590 5306 595 405 590 364 595 2737 590 2445 595 200 590 136 590 5986 595 0.769567680975206 595 50252 65299 0.059175531914894 590 2937 49632 0.045492565055762 590 2937 64560 0.06928999144568 590 405 5845 0.886401603742065 595 5306 5986   3 593 39 590 37 590 40 590 59 590 87 590 105 590 116 590 28 595 2 588 19 585 22 585 30 586 42 585 54 585 52 585 36 585 6 590 13 581 356 1 114 0 0 0 7 590 19 590 0 103 0 103 90 13 103 590 3848 590 4386 590 21 588 16 584 14 584 0 590 31 590 922 590 1061 590
27342 27342 TX 2022/07/01 6 106 483 9 103 483 139 590 65573 595 50251 595 2999 590 442 595 237 590 57 590 69 590 5211 595 393 590 354 595 2796 590 2487 595 203 590 139 590 6034 595 0.766336754456865 595 50251 65573 0.060378498087377 590 2999 49670 0.046255166882596 590 2999 64836 0.066689292380791 590 393 5893 0.863606231355651 595 5211 6034   3 593 24 590 48 590 34 590 45 590 71 590 104 590 96 590 29 595 2 588 26 585 27 585 30 586 27 586 38 585 45 585 37 585 5 590 8 580 356 0 114 5 0 0 7 590 13 590 0 102 0 102 104 12 102 590 3815 590 4331 590 27 588 18 584 12 584 0 590 33 590 914 590 1063 590
27351 27351 TX 2022/07/17 6 107 482 11 102 482 136 590 63659 595 48171 595 3743 590 490 595 234 590 43 590 80 590 5091 595 532 590 495 595 3480 590 3203 595 247 590 177 590 5867 595 0.756703686831398 595 48171 63659 0.078672467789058 590 3743 47577 0.059476895696943 590 3743 62932 0.092909535452323 590 532 5726 0.867734787796148 595 5091 5867   4 593 35 589 32 589 38 589 66 589 91 589 101 589 114 589 24 595 1 588 11 584 21 584 28 585 37 584 52 584 46 584 34 584 4 590 22 580 358 0 114 0 0 0 4 590 14 590 0 105 0 105 104 9 105 590 3578 590 4222 590 32 588 9 583 12 584 0 590 33 590 899 590 1085 590
27893 27893 TX 2022/07/16 6 107 482 11 102 482 150 590 64396 595 49210 595 3726 590 595 595 262 590 46 590 72 590 5229 595 539 590 491 595 3456 590 3149 595 254 590 174 590 6006 595 0.7641778992484 595 49210 64396 0.076663511789638 590 3726 48602 0.058521415445507 590 3726 63669 0.091869780126129 590 539 5867 0.870629370629371 595 5229 6006   3 593 35 589 42 589 54 589 76 589 124 589 118 589 132 589 26 595 0 588 22 584 25 584 18 585 31 584 57 584 63 584 42 584 4 590 28 580 353 0 114 0 0 0 5 590 24 590 0 105 0 105 103 9 105 590 3732 590 4320 590 34 588 9 583 11 584 0 590 24 590 918 590 1065 590
30194 30194 TX 2022/07/02 5 105 485 9 101 485 135 590 64461 595 48229 595 2974 590 462 595 235 590 54 590 62 590 5037 595 397 590 352 595 2758 590 2420 595 216 590 146 590 5877 595 0.748188827352973 595 48229 64461 0.062367620845129 590 2974 47685 0.046673676611372 590 2974 63719 0.069211994421199 590 397 5736 0.857069933639612 595 5037 5877   1 593 32 590 27 590 35 590 54 590 81 590 119 590 90 590 30 595 4 588 21 585 15 585 21 585 25 585 46 585 54 585 44 585 5 590 16 581 356 0 114 0 0 0 6 590 11 590 0 101 0 101 101 8 101 590 3785 590 4336 590 31 588 12 584 11 584 0 590 30 590 918 590 1075 590
31021 31021 TX 2022/07/15 6 108 481 11 103 481 169 590 64989 595 50349 595 3836 590 532 595 260 590 51 590 64 590 5080 595 510 590 469 595 3552 590 3200 595 246 590 169 590 5822 595 0.774731108341412 595 50349 64989 0.077153603250266 590 3836 49719 0.059696847085188 590 3836 64258 0.089741333802569 590 510 5683 0.872552387495706 595 5080 5822   1 593 34 589 38 589 47 589 57 589 81 589 111 589 147 589 30 595 3 588 13 583 26 584 26 584 44 584 49 584 51 584 44 584 4 590 17 581 353 0 114 0 0 0 4 590 22 590 0 105 0 105 105 8 105 590 3881 590 4455 590 38 588 9 583 16 584 0 590 30 590 913 590 1066 590
42855 42855 TX 2022/02/12 11 109 475 14 106 475 142 590 67220 595 52290 595 8359 590 832 595 336 590 68 590 111 590 6272 595 1891 590 1905 595 8057 590 7603 595 302 590 255 590 6718 595 0.777893484082118 595 52290 67220 0.161745356037152 590 8359 51680 0.125769224982321 590 8359 66463 0.289232181095136 590 1891 6538 0.933611193807681 595 6272 6718   3 592 48 589 59 589 67 589 83 590 149 589 186 589 163 589 74 595 5 587 26 584 37 584 33 585 52 586 69 584 59 584 49 584 6 590 134 582 303 0 114 0 0 0 17 590 30 590 0 109 0 109 163 16 109 590 3908 590 4431 590 30 588 17 584 21 584 0 590 53 590 972 590 1114 590
44036 44036 TX 2022/02/13 10 109 476 15 104 476 141 590 66112 595 50806 595 8184 590 749 595 308 590 55 590 92 590 6180 595 1866 590 1851 595 7913 590 7401 595 271 590 223 590 6694 595 0.768483785091965 595 50806 66112 0.16297269848856 590 8184 50217 0.12522569391315 590 8184 65354 0.28650391524643 590 1866 6513 0.923214819241112 595 6180 6694   5 592 46 589 40 589 54 589 86 590 153 589 148 589 147 589 70 595 10 587 31 584 28 584 29 585 38 586 59 584 49 584 55 584 9 590 116 582 303 0 114 0 0 0 18 590 28 590 0 109 0 109 172 14 109 590 3684 590 4249 590 23 588 19 584 13 584 0 590 42 589 949 590 1114 590
45430 45430 TX 2022/02/06 12 109 474 17 104 474 202 590 65002 595 49313 595 10591 590 1111 595 371 590 80 589 109 589 6186 595 2360 590 2350 595 10177 590 9658 595 368 590 295 590 6655 595 0.758638195747823 595 49313 65002 0.217393981690546 590 10591 48718 0.164855862026026 590 10591 64244 0.364591379576703 590 2360 6473 0.929526671675432 595 6186 6655   9 592 70 590 74 590 78 590 128 590 228 591 227 590 218 590 79 595 7 588 18 585 23 585 39 585 43 585 56 585 73 585 55 585 57 590 152 579 314 1 114 0 0 0 17 590 19 590 0 182 0 182 146 16 182 590 3434 590 3997 590 32 588 33 584 15 584 0 589 58 589 941 590 1103 590
35353 35353 TX 2022/03/12 10 110 476 12 108 476 114 591 66077 596 49440 596 2396 591 229 596 314 591 19 591 61 591 5459 596 520 591 485 596 2273 591 1860 596 123 591 80 591 6250 596 0.748217988104787 596 49440 66077 0.049036060742499 591 2396 48862 0.036673656498247 591 2396 65333 0.085287846481876 591 520 6097 0.87344 596 5459 6250   1 594 13 590 19 590 25 590 33 590 40 589 52 589 37 589 9 596 4 589 27 585 34 585 39 586 46 586 57 585 58 585 37 585 12 591 23 584 314 0 114 0 0 0 30 591 67 591 0 116 0 116 252 3 116 591 3738 591 4351 591 5 589 5 584 9 584 0 591 15 591 894 591 1058 591
36795 36795 TX 2022/03/10 12 109 475 13 108 475 109 591 66737 596 51211 596 2583 591 252 596 352 591 23 591 73 591 5630 596 572 591 526 596 2455 591 2065 596 128 591 90 591 6267 596 0.767355440010789 596 51211 66737 0.051032302677072 591 2583 50615 0.039137549622716 591 2583 65998 0.093555773634282 591 572 6114 0.898356470400511 596 5630 6267   2 594 13 590 23 590 26 590 39 590 46 589 48 589 40 589 15 596 9 589 27 585 32 586 37 586 46 586 72 585 62 585 64 585 3 591 27 584 376 1 114 0 0 0 26 591 69 591 0 113 0 113 254 2 113 591 3858 591 4416 591 8 589 7 584 8 584 0 591 22 591 903 591 1071 591
37964 37964 TX 2022/03/11 11 110 475 12 109 475 108 591 66845 596 50873 596 2491 591 246 596 312 591 21 591 72 591 5589 596 562 591 518 596 2370 591 1960 596 121 591 84 591 6277 596 0.761059166729 596 50873 66845 0.049561290065856 591 2491 50261 0.037682474850616 591 2491 66105 0.091770084911822 591 562 6124 0.890393500079656 596 5589 6277   3 594 13 590 15 590 28 590 44 590 47 589 44 589 40 589 12 596 1 589 23 585 28 585 30 586 52 585 68 585 59 585 39 585 12 591 22 584 314 0 114 0 0 0 30 591 63 591 0 116 0 116 254 2 116 591 3769 591 4380 591 10 589 6 584 5 584 0 591 18 591 894 591 1060 591
41691 41691 TX 2022/03/13 10 109 477 12 107 477 109 591 65562 596 47776 596 2228 591 172 596 248 591 19 591 53 591 5248 596 480 591 464 596 2050 591 1759 596 106 591 71 591 6146 596 0.728714804307373 596 47776 65562 0.047186394730711 591 2228 47217 0.034374228585534 591 2228 64816 0.080093442349408 591 480 5993 0.853888708102831 596 5248 6146   2 594 13 590 17 590 19 590 29 590 34 589 25 589 28 589 5 596 0 589 19 585 28 585 29 586 34 585 61 585 35 585 30 585 12 591 19 584 302 0 108 0 0 0 27 591 69 591 0 114 0 114 252 2 114 591 3586 591 4257 591 7 589 6 584 6 584 0 591 16 591 858 591 1030 591
43824 43824 TX 2022/02/18 12 108 476 13 107 476 115 591 68042 596 53394 596 6475 591 621 596 386 591 58 591 115 591 6185 596 1518 591 1473 596 6216 591 5667 596 259 591 212 591 6749 596 0.78472120161077 596 53394 68042 0.12267439657459 591 6475 52782 0.09624531779535 591 6475 67276 0.230804318078151 591 1518 6577 0.916432064009483 596 6185 6749   3 594 38 590 44 590 48 590 67 590 120 590 123 590 121 590 57 596 3 589 35 585 32 585 38 586 54 586 48 585 86 585 69 585 21 591 77 582 300 1 74 1 0 0 25 591 50 591 0 108 0 108 191 8 108 591 3981 591 4557 591 17 589 23 584 18 584 0 591 43 591 944 591 1108 591
44866 44866 TX 2022/02/17 11 108 477 14 105 477 131 591 68461 596 53988 596 6859 591 716 596 415 591 55 591 99 591 6256 596 1587 591 1556 596 6591 591 6035 596 268 591 214 591 6736 596 0.788594966477264 596 53988 68461 0.128590176227972 591 6859 53340 0.101322106507128 591 6859 67695 0.241736481340442 591 1587 6565 0.92874109263658 596 6256 6736   2 594 52 590 59 590 59 590 78 590 136 590 156 590 121 590 53 596 5 589 37 585 42 585 56 586 57 586 63 585 68 585 70 585 17 591 97 582 300 0 35 0 0 0 20 591 47 591 0 107 0 107 178 7 107 591 3995 591 4591 591 20 589 16 584 19 584 0 591 47 591 941 591 1099 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 9921.536ms · Data source: U.S. Department of Health & Human Services