hospitals_state

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

39 rows where previous_day_deaths_influenza = 4 sorted by total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_coverage

View and edit SQL

Suggested facets: state, critical_staffing_shortage_anticipated_within_week_no, hospital_onset_covid_coverage, inpatient_beds_coverage, inpatient_beds_used_coverage, inpatient_beds_used_covid_coverage, previous_day_admission_adult_covid_confirmed_coverage, previous_day_admission_pediatric_covid_confirmed, previous_day_admission_pediatric_covid_suspected, total_adult_patients_hospitalized_confirmed_and_suspected_covid_coverage, total_adult_patients_hospitalized_confirmed_covid_coverage, adult_icu_bed_covid_utilization_coverage, previous_day_admission_adult_covid_confirmed_18-19, 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_confirmed_50-59_coverage, previous_day_admission_adult_covid_suspected_30-39_coverage, previous_day_admission_adult_covid_suspected_50-59_coverage, previous_day_admission_adult_covid_suspected_unknown, deaths_covid, on_hand_supply_therapeutic_c_bamlanivimab_etesevimab_courses, previous_week_therapeutic_b_bamlanivimab_courses_used, previous_day_deaths_covid_and_influenza_coverage, total_patients_hospitalized_confirmed_influenza, total_patients_hospitalized_confirmed_influenza_and_covid_coverage, all_pediatric_inpatient_beds_coverage, previous_day_admission_pediatric_covid_confirmed_0_4_coverage, previous_day_admission_pediatric_covid_confirmed_5_11, 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_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
22209 MD 2022/12/02 12 21 17 14 20 16 11 49 10517 50 8970 50 774 49 80 50 256 49 1 49 13 49 974 50 85 49 57 50 736 49 493 50 38 49 10 49 1311 50 0.852904820766378 50 8970 10517 0.086966292134831 49 774 8900 0.074280230326296 49 774 10420 0.066823899371069 49 85 1272 0.742944317315027 50 974 1311   0 50 4 49 5 49 3 49 10 49 11 49 23 49 24 49 0 50 1 49 21 48 29 48 13 48 37 48 55 48 45 48 55 48 0 49 3 28 534 365 646 0 0 0 27 49 56 49 1 19 4 21 233 5 21 49 380 49 536 49 1 49 0 47 0 47 0 42 1 49 22 49 21 49
22476 MD 2022/11/14 12 21 18 14 21 16 19 50 10398 51 8431 51 652 50 45 51 115 50 2 50 5 50 862 51 63 50 37 51 601 50 407 51 51 50 11 50 1268 51 0.810829005577996 51 8431 10398 0.07791586998088 50 652 8368 0.06327025715672 50 652 10305 0.051094890510949 50 63 1233 0.67981072555205 51 862 1268   0 50 0 50 5 50 3 50 4 51 9 50 14 50 9 50 1 51 2 50 3 49 14 49 6 49 15 49 36 49 21 49 18 49 0 50 0 28 534 365 646 0 0 0 17 50 28 50 0 20 4 21 111 1 21 50 386 50 550 50 1 50 0 48 0 48 1 43 1 50 21 50 21 50
24187 MD 2022/11/22 12 21 18 14 19 18 14 50 10530 51 8531 51 683 50 56 51 182 50 2 50 21 50 911 51 44 50 29 51 646 50 397 51 37 50 9 50 1295 51 0.810161443494777 51 8531 10530 0.080666115507263 50 683 8467 0.06542772296197 50 683 10439 0.034892942109437 50 44 1261 0.703474903474904 51 911 1295   0 51 3 50 6 50 3 50 5 50 11 50 14 50 14 50 0 51 5 50 14 49 16 49 15 49 19 49 54 49 35 49 24 49 0 50 0 27 462 365 646 0 0 0 15 50 41 50 0 20 4 20 124 1 20 50 354 50 542 50 1 50 1 48 0 48 0 43 0 50 19 50 19 50
27204 MD 2022/11/20 12 22 17 14 21 16 17 50 10436 51 8398 51 732 50 56 51 177 50 1 50 9 50 869 51 69 50 34 51 685 50 391 51 47 50 13 50 1290 51 0.804714449980836 51 8398 10436 0.087832973362131 50 732 8334 0.070799883934616 50 732 10339 0.05515587529976 50 69 1251 0.673643410852713 51 869 1290   0 50 0 50 1 50 3 50 3 50 12 51 8 50 23 50 6 51 1 50 12 49 18 49 8 49 31 49 31 49 40 49 36 49 0 50 5 27 462 365 646 0 0 0 11 50 37 50 2 20 4 20 111 0 20 50 355 50 546 50 1 50 0 48 0 48 0 43 1 50 21 50 21 50
27987 MD 2022/11/01 12 21 18 14 20 17 22 50 10443 51 8476 51 722 50 60 51 157 50 3 50 27 50 881 51 74 50 47 51 667 50 445 51 55 50 9 50 1272 51 0.811644163554534 51 8476 10443 0.085819564958992 50 722 8413 0.069765194704802 50 722 10349 0.059870550161812 50 74 1236 0.692610062893082 51 881 1272   0 51 3 49 5 49 5 49 6 49 8 49 15 49 17 49 1 51 3 50 6 48 16 48 16 48 23 48 33 48 30 48 30 48 0 50 3 28 1300 365 1519 0 0 0 4 50 27 50 0 20 4 21 68 1 21 50 423 50 544 50 0 50 1 47 1 47 1 43 2 50 20 50 21 50
32823 MD 2022/10/18 12 20 19 14 19 18 14 50 10435 51 8612 51 677 50 68 51 160 50 1 50 16 50 911 51 67 50 46 51 631 50 447 51 46 50 9 50 1269 51 0.825299472927647 51 8612 10435 0.079255443690002 50 677 8542 0.065454897031809 50 677 10343 0.054251012145749 50 67 1235 0.717888100866824 51 911 1269   0 51 5 50 5 50 2 50 13 50 7 50 9 50 27 50 0 51 3 50 10 49 18 49 13 49 21 49 29 49 31 49 35 49 0 50 1 28 1574 365 1651 3 0 0 1 50 9 50 0 20 4 21 23 0 21 50 399 50 544 50 1 50 0 48 0 48 0 43 2 50 19 50 20 50
33742 MD 2022/10/17 12 19 20 14 19 18 15 50 10272 51 8356 51 708 50 65 51 136 50 0 50 18 50 864 51 72 50 43 51 641 50 431 51 40 50 10 50 1246 51 0.813473520249221 51 8356 10272 0.085393800506573 50 708 8291 0.069541302426088 50 708 10181 0.059356966199505 50 72 1213 0.693418940609952 51 864 1246   0 51 2 50 3 50 2 50 5 50 12 50 23 50 18 50 0 51 1 50 9 49 15 49 9 49 18 49 30 49 27 49 27 49 0 50 2 28 1574 365 1651 3 0 0 2 50 4 50 0 20 4 21 20 0 21 50 393 50 546 50 0 50 0 48 0 48 0 43 2 50 20 50 22 50
31926 MD 2022/10/01 12 21 19 14 20 18 21 51 10748 52 8519 52 647 51 71 52 139 51 1 51 9 51 817 52 60 51 50 52 614 51 442 52 33 51 10 51 1274 52 0.792612579084481 52 8519 10748 0.076432368576491 51 647 8465 0.060745469908929 51 647 10651 0.048543689320388 51 60 1236 0.641287284144427 52 817 1274   1 52 4 51 3 51 4 51 11 50 16 50 14 50 17 50 1 52 3 51 13 50 22 50 7 50 16 49 30 49 24 49 24 49 0 51 2 28 1541 365 1631 3 0 0 0 51 1 51 0 21 4 21 3 0 21 51 348 51 528 51 1 51 0 49 0 49 0 44 2 51 17 51 17 51
41979 MD 2022/09/15 11 22 19 14 20 18 20 51 10754 52 8947 52 641 51 64 52 137 51 0 51 18 51 865 52 55 51 39 52 585 51 428 52 56 51 14 51 1242 52 0.831969499721034 52 8947 10754 0.072184684684685 51 641 8880 0.060136973449667 51 641 10659 0.045605306799337 51 55 1206 0.69645732689211 52 865 1242   0 52 3 51 10 51 6 51 6 51 14 50 11 50 14 50 0 52 1 51 8 50 21 50 6 50 16 50 29 49 31 49 24 49 1 51 8 29 1536 365 1060 0 0 0 1 51 1 51 0 21 4 22 6 0 22 51 361 51 545 51 0 51 0 49 0 49 0 44 3 51 20 51 20 51
47206 MD 2022/09/18 12 20 20 14 20 18 19 51 10749 52 8543 52 692 51 54 52 139 51 2 51 19 51 809 52 67 51 44 52 638 51 438 52 54 51 17 51 1259 52 0.794771606661085 52 8543 10749 0.081546075889701 51 692 8486 0.064964325948179 51 692 10652 0.054873054873055 51 67 1221 0.642573471008737 52 809 1259   0 51 3 51 6 51 4 52 7 51 9 50 10 50 15 50 0 52 1 51 15 50 18 50 9 50 17 50 23 49 31 49 25 49 0 51 0 29 1480 365 1021 0 0 0 1 51 0 51 0 21 4 22 6 0 22 51 353 51 532 51 0 51 1 49 1 49 0 44 3 51 19 51 20 51
32186 MD 2022/10/09 12 22 19 14 21 18 12 52 10774 53 8581 53 659 52 43 53 153 52 4 52 21 52 826 53 66 52 45 53 606 52 396 53 53 52 11 52 1245 53 0.796454427325042 53 8581 10774 0.077175313268533 52 659 8539 0.061721457338204 52 659 10677 0.054681027340514 52 66 1207 0.663453815261044 53 826 1245   1 53 2 52 1 51 1 51 3 51 6 51 16 51 13 51 0 53 2 52 14 51 20 50 8 50 23 50 33 50 30 50 23 50 0 52 5 28 1564 365 1631 3 0 0 1 52 6 52 0 21 4 21 14 0 21 52 354 52 537 52 3 52 0 49 1 50 0 45 4 52 19 52 21 52
22326 MD 2022/10/16 12 22 20 14 22 18 16 53 11126 54 8997 54 677 53 55 54 98 53 2 53 11 52 845 54 64 53 42 54 628 53 417 54 49 53 12 53 1267 54 0.808646413805501 54 8997 11126 0.075752489649771 53 677 8937 0.061344690105111 53 677 11036 0.051863857374392 53 64 1234 0.666929755327545 54 845 1267   0 53 2 50 7 50 0 50 8 50 6 50 14 50 18 50 0 54 1 52 4 49 10 49 5 49 14 49 26 49 18 49 20 49 0 53 2 29 1574 365 1651 3 0 0 1 53 4 53 0 21 4 22 12 0 22 53 497 53 651 53 2 52 0 48 0 48 0 46 3 52 20 52 20 52
29285 MD 2022/10/19 1 38 15 14 26 14 14 53 11176 54 9450 54 640 53 60 54 159 53 0 53 13 53 913 54 61 53 48 54 591 53 425 54 49 53 11 53 1266 54 0.845561918396564 54 9450 11176 0.068223003944142 53 640 9381 0.057751308428082 53 640 11082 0.049593495934959 53 61 1230 0.721169036334913 54 913 1266   2 54 5 52 3 52 4 52 7 52 7 52 19 52 12 52 1 54 4 53 13 51 20 51 16 51 21 51 25 51 38 51 22 51 0 53 1 31 1630 365 1657 3 0 0 1 53 7 53 0 22 4 23 29 0 23 53 524 53 659 53 0 53 0 50 0 50 0 46 3 53 20 53 21 53
43926 MD 2022/08/18 8 31 18 13 27 17 30 56 11621 57 9573 57 809 56 80 57 132 56 5 56 15 56 844 57 71 56 53 57 741 56 592 57 46 56 23 56 1278 57 0.823767317786765 57 9573 11621 0.085104144750684 56 809 9506 0.070201318986463 56 809 11524 0.057258064516129 56 71 1240 0.660406885758998 57 844 1278   4 55 6 54 11 54 6 53 8 53 20 52 13 53 11 52 1 57 1 56 12 53 15 52 13 51 17 51 25 51 22 51 27 51 0 56 6 28 1551 365 1010 0 0 0 1 56 0 56 1 20 4 21 6 0 21 56 386 56 630 56 2 56 2 51 1 52 0 49 3 56 15 56 19 56
22952 MD 2022/01/26 4 49 7 12 47 1 24 59 11951 60 10332 60 2373 59 228 60 205 59 3 59 5 59 1034 60 405 59 371 60 2343 59 2092 60 30 59 22 59 1328 60 0.864530164839762 60 10332 11951 0.231106349824698 59 2373 10268 0.200050581689428 59 2373 11862 0.314197051978278 59 405 1289 0.778614457831325 60 1034 1328   1 58 12 55 22 55 23 55 31 55 43 55 46 56 50 56 0 60 2 56 17 53 21 54 11 54 25 55 38 54 51 54 39 53 1 59 26 30 2330 428 2242 15 0 80 1 52 2 52 0 20 4 20 6 2 20 51 361 40 466 39 0 43 2 42 1 42 0 51 4 40 128 38 149 38
32116 NJ 2022/11/29 6 59 11 7 58 11 15 75 21200 76 15103 76 1227 75 201 76 86 75 7 75 6 75 1268 76 130 75 118 76 1203 75 1146 76 24 75 4 75 2830 76 0.712405660377358 76 15103 21200 0.081242137323711 75 1227 15103 0.057877358490566 75 1227 21200 0.045936395759717 75 130 2830 0.448056537102474 76 1268 2830   0 76 11 76 13 76 5 76 16 76 35 76 45 76 76 76 0 76 0 75 8 75 5 75 13 75 9 75 18 75 14 75 19 75 0 75 9 74 1376 256 1257 1 0 0 81 75 143 75 0 68 4 74 561 17 74 75 552 75 778 75 1 75 0 75 2 75 4 75 5 75 110 75 132 75
25248 NJ 2022/11/24 5 76 10 7 74 10 14 90 23627 91 15663 91 1020 90 159 91 53 90 7 90 3 90 1163 91 105 90 88 91 996 90 938 91 24 90 9 90 2828 91 0.662928006094722 91 15663 23627 0.065121624209921 90 1020 15663 0.043170948491133 90 1020 23627 0.037128712871287 90 105 2828 0.411244695898161 91 1163 2828   0 91 13 91 7 91 6 91 11 91 30 91 40 91 51 91 1 91 0 90 3 90 4 90 4 90 5 90 10 90 16 90 11 90 0 90 15 89 1376 256 1257 1 0 0 40 90 80 90 0 83 4 89 279 16 89 90 538 90 814 90 3 90 0 90 2 90 2 90 2 90 106 90 129 90
24765 WA 2022/11/29 0 40 56 3 44 49 34 94 11106 95 9827 96 539 94 72 96 16 94 4 94 0 94 956 96 67 94 66 96 531 94 507 96 8 94 8 94 1165 95 0.880875202593193 95 9783 11106 0.055469795204281 94 539 9717 0.049080313239847 93 539 10982 0.058566433566434 93 67 1144 0.820600858369099 95 956 1165   3 95 4 90 5 90 7 90 5 90 12 90 11 90 25 91 0 96 0 94 2 88 5 88 3 88 0 88 3 88 2 88 1 88 0 94 6 32 3 0 0 44 0 0 40 94 101 94 0 26 4 26 461 10 80 94 561 94 818 93 0 94 3 88 1 88 0 94 1 94 118 94 160 93
50900 TN 2021/02/06 22 88 32 43 67 32 27 110 20114 142 12634 130 1363 110 137 113 61 110 3 110 0 110 1679 142 403 110 404 113 1348 110 1291 113 15 110 14 110 2413 142 0.65110286538858 130 12634 19404 0.112719153159113 110 1363 12092 0.074586844697384 110 1363 18274 0.174610051993068 110 403 2308 0.695814338997099 142 1679 2413   0 113 3 113 6 113 4 113 22 113 22 113 21 113 28 113 31 113 0 110 8 110 8 110 2 110 6 110 8 110 11 110 14 110 4 110 31 110 173 198   0 96   4 110 11 110 0 110 4 110 9 3 110 110 35 14 53 14   0   0   0   0   0 0 14 0 14
54206 TN 2021/04/08 13 98 32 30 81 32 16 111 20137 143 13340 132 934 111 106 114 72 111 2 111 4 111 1744 143 257 111 245 114 916 111 811 114 18 111 14 111 2394 143 0.68186464935596 132 13340 19564 0.073997781651085 111 934 12622 0.050749836991958 111 934 18404 0.110871440897325 111 257 2318 0.728487886382623 143 1744 2394   0 114 6 114 8 114 5 114 27 114 18 114 18 114 10 114 14 114 1 111 3 111 2 111 6 111 12 111 11 111 17 111 12 111 8 111 114 111 0 18 38 0 1 66 5 111 2 111 0 111 4 111 15 4 111 111 36 16 55 16   0   0   0   0   0 0 16 0 16
27243 NC 2022/10/17 19 86 12 12 93 12 27 113 21403 117 16774 117 1450 113 76 117 178 113 1 113 22 113 1774 117 202 113 105 117 1414 113 693 117 36 113 10 113 2144 117 0.783721908143718 117 16774 21403 0.087565674255692 113 1450 16559 0.068564403253263 113 1450 21148 0.096743295019157 113 202 2088 0.827425373134328 117 1774 2144   0 117 4 114 3 114 5 114 8 114 16 114 19 114 21 114 0 117 1 113 8 110 11 110 16 110 26 110 38 110 44 110 34 110 0 113 14 102 120 0 130 0 0 0 5 113 15 113 0 101 4 101 34 0 101 113 1197 113 2027 113 0 113 1 110 0 110 0 113 0 113 325 113 425 113
33577 NC 2022/10/18 19 87 12 11 95 12 27 114 21512 118 17084 118 1459 114 95 118 201 114 2 114 14 114 1800 118 207 114 104 118 1429 114 705 118 30 114 10 114 2161 118 0.794161398289327 118 17084 21512 0.086459259259259 114 1459 16875 0.068642672312397 114 1459 21255 0.098430813124108 114 207 2103 0.832947709393799 118 1800 2161   0 118 3 114 6 114 4 114 8 114 23 114 20 114 29 114 2 118 3 114 15 110 14 110 18 110 28 110 45 110 45 110 33 110 0 114 16 102 120 0 130 0 0 0 5 114 6 114 0 101 4 101 38 0 101 114 1247 114 2031 114 0 114 1 110 1 110 0 114 0 114 328 114 425 114
22628 MO 2022/12/05 2 76 41 26 66 27 23 115 14577 119 12229 119 949 115 114 119 164 115 4 115 14 115 1330 119 121 115 97 119 905 115 752 119 44 115 29 115 1738 119 0.838924332853125 119 12229 14577 0.078833693304536 115 949 12038 0.066229325144811 115 949 14329 0.072498502097064 115 121 1669 0.765247410817031 119 1330 1738   0 117 6 103 2 103 8 103 12 103 22 104 28 104 36 103 0 119 1 113 8 99 12 100 7 98 24 99 44 98 32 99 36 98 0 115 7 50 438 0 316 0 0 0 95 115 110 115 0 45 4 45 548 6 45 115 781 115 958 115 4 115 0 97 0 98 0 115 8 115 187 115 220 115
31942 NC 2022/10/14 21 87 12 15 93 12 25 116 21682 120 17057 120 1523 116 81 120 201 116 0 116 13 116 1793 120 221 116 112 120 1489 116 733 120 34 116 16 116 2163 120 0.786689419795222 120 17057 21682 0.09039648622982 116 1523 16848 0.071088498879761 116 1523 21424 0.105038022813688 116 221 2104 0.828941285251965 120 1793 2163   0 119 2 115 3 115 5 115 10 115 12 115 23 115 26 115 0 120 2 115 8 111 14 111 22 111 38 111 47 111 35 111 35 111 0 116 12 103 120 0 130 10 0 0 2 116 8 116 0 101 4 101 26 0 101 116 1291 116 2102 116 0 115 0 111 0 111 0 116 0 116 322 116 425 116
3408 KY 2020/12/19 4 116 3 7 114 2 23 121 14281 123 8738 123 1719 121 382 123 99 121 2 121 4 121 1193 123 402 121 385 123 1703 121 1569 123 16 121 11 121 1721 123 0.611861914431762 123 8738 14281 0.199419953596288 121 1719 8620 0.121914893617021 121 1719 14100 0.24 121 402 1675 0.693201626961069 123 1193 1721   0 122 11 122 11 122 14 122 33 122 64 122 75 122 76 122 95 123 2 120 8 120 10 120 7 120 12 120 28 120 17 120 17 120 2 121 34 121 185 788 0 0 52 0 9 121 10 121 1 121 4 121 34 24 121 121 259 31 415 31   0   0   0   0   0 0 31 0 31
4449 KY 2020/12/18 4 27 92 9 112 2 25 121 14282 123 8903 123 1761 121 383 123 98 121 3 121 3 121 1225 123 359 121 432 123 1748 121 1592 123 13 121 10 121 1721 123 0.623372076739952 123 8903 14282 0.20084397810219 121 1761 8768 0.124884759946103 121 1761 14101 0.214328358208955 121 359 1675 0.711795467751307 123 1225 1721   1 122 6 122 9 122 18 122 44 122 69 122 85 122 69 122 98 123 1 120 7 120 6 120 11 120 18 120 25 120 15 120 18 120 15 121 34 121 222 465 0 0 52 0 9 121 7 121 1 121 4 121 36 25 121 121 259 31 415 31   0   0   0   0   0 0 31 0 31
23937 OK 2021/10/22 43 104 4 43 104 4 12 149 10410 151 7576 151 668 149 103 151 76 149 1 149 3 149 812 151 208 149 204 151 642 149 585 151 26 149 23 149 978 151 0.72776176753122 151 7576 10410 0.089628337582182 149 668 7453 0.065234375 149 668 10240 0.223175965665236 149 208 932 0.830265848670757 151 812 978   1 151 10 151 6 151 14 151 16 151 27 151 14 151 14 151 1 151 0 149 20 149 9 149 9 149 8 149 12 149 10 149 8 149 0 149 4 149 5116 2311 2394 1012 12 124 2 140 1 140 0 140 4 140 10 0 140 140 621 76 890 76   0   0   0   0   0 286 76 376 76
37508 IN 2021/07/29 13 150 3 13 150 3 1 164 18896 166 12902 166 728 164 98 166 65 164 3 164 5 164 1579 166 204 164 193 166 703 164 572 166 25 164 10 164 2233 166 0.6827900084674 166 12902 18896 0.056901672659059 164 728 12794 0.038820455393804 164 728 18753 0.093406593406593 164 204 2184 0.707120465741155 166 1579 2233   0 166 10 165 7 165 18 165 20 165 20 165 7 165 13 165 3 166 0 164 7 163 7 163 7 163 6 163 9 163 15 163 14 163 0 164 7 164 2496 2277 2285 238 0 4 3 163 7 163 0 163 4 163 15 0 163 163 389 52 613 52   0   0   0   0   0 34 52 47 52
42397 IN 2021/07/28 12 151 3 15 148 3 0 164 20061 166 13562 166 776 164 89 166 90 164 5 164 3 164 1800 166 217 164 197 166 743 164 580 166 33 164 14 164 2507 166 0.676038083844275 166 13562 20061 0.0577123308047 164 776 13446 0.038959734913144 164 776 19918 0.088283157038242 164 217 2458 0.717989629038692 166 1800 2507   0 166 9 166 8 166 8 166 15 166 17 166 14 166 18 166 0 166 1 164 8 164 10 164 15 164 7 164 15 164 17 164 16 164 1 164 3 164 2654 2280 2363 252 0 4 1 164 5 164 0 163 4 164 9 0 164 164 387 57 620 57   0   0   0   0   0 35 57 49 57
23427 NY 2022/12/01 2 159 15 5 157 14 636 167 45174 176 37754 176 3733 167 441 176 220 167 18 167 21 167 3501 176 402 167 278 176 3587 167 3212 176 146 167 80 167 4496 176 0.835746225705052 176 37754 45174 0.09968489638966 167 3733 37448 0.083557167159101 167 3733 44676 0.091384405546715 167 402 4399 0.778692170818505 176 3501 4496   2 168 12 157 33 160 23 157 35 158 73 163 108 160 159 158 14 175 1 166 17 146 27 146 20 147 26 147 31 146 33 146 46 146 19 166 10 53 1731 234 911 253 0 91 75 167 199 167 0 33 4 33 797 42 33 167 1928 167 2463 167 13 166 4 147 1 148 0 167 12 167 352 167 424 167
24905 PA 2022/11/25 1 46 149 21 169 6 38 190 31226 196 22636 196 1522 190 121 196 343 190 5 190 28 190 2597 196 165 190 148 196 1465 190 1134 196 57 190 26 190 3506 196 0.724908729904567 196 22636 31226 0.067946428571429 190 1522 22400 0.049255663430421 190 1522 30900 0.048500881834215 190 165 3402 0.740730176839703 196 2597 3506   1 196 3 183 3 183 4 182 5 182 30 182 36 182 34 182 10 196 3 188 15 177 25 178 26 177 41 177 70 178 67 176 80 177 16 190 1 21 14 0 0 0 0 0 53 190 115 190 0 18 4 18 393 0 18 190 1248 190 1572 190 2 190 0 177 0 177 0 190 10 190 378 190 398 190
40968 FL 2021/09/05 42 169 58 42 169 58 124 263 59649 269 48237 269 13619 263 1370 269 214 263 50 263 29 263 6240 269 3119 263 3160 269 13418 263 13114 269 201 263 182 263 6823 269 0.808680782578082 269 48237 59649 0.286275828726378 263 13619 47573 0.232176344232671 263 13619 58658 0.472719005759321 263 3119 6598 0.914553715374469 269 6240 6823   5 268 71 266 144 267 181 267 248 268 253 266 212 266 194 266 62 269 2 263 12 261 26 261 21 261 30 261 34 261 40 261 42 261 7 263 263 263 14489 2486 3309 5688 0 7 4 253 4 253 2 253 4 253 34 16 253 253 3187 263 3986 263   0   0   0   0   0 1266 263 1653 263
25338 CA 2022/11/29 8 99 263 93 213 64 66 362 63258 370 51959 370 4333 362 721 370 449 362 20 362 21 361 5231 370 431 362 376 370 4208 362 3694 370 116 362 94 362 6762 370 0.821382275759588 370 51959 63258 0.084422795908427 362 4333 51325 0.069312474005823 362 4333 62514 0.065352539802881 362 431 6595 0.773587695947944 370 5231 6762   2 368 40 365 63 363 41 363 62 362 116 362 154 363 241 363 2 369 6 361 34 355 41 354 39 353 53 354 95 354 75 354 106 354 0 345 9 106 1108 165 86 0 0 0 211 361 467 361 0 76 4 319 1899 102 319 361 2776 362 3794 362 14 360 5 139 1 356 0 361 24 362 810 362 1050 362
29165 CA 2022/11/21 7 103 274 86 222 76 23 376 62193 384 48847 384 3091 367 434 384 290 376 19 375 13 363 4889 375 352 367 318 375 2994 367 2586 375 97 367 81 367 6736 375 0.785409933593813 384 48847 62193 0.064106020698094 367 3091 48217 0.050297783708139 367 3091 61454 0.053576864535769 367 352 6570 0.725801662707838 375 4889 6736   3 366 25 376 30 365 26 364 51 365 76 366 80 365 139 365 4 373 1 362 24 356 23 356 27 356 43 355 57 356 59 356 53 356 3 352 5 105 1053 165 8 0 0 0 101 363 319 363 0 77 4 320 952 91 320 363 2834 375 3975 375 15 365 2 136 2 352 0 363 20 366 851 366 1098 366
34854 CA 2022/06/25 9 137 264 109 264 37 93 402 63431 410 48626 410 3514 402 612 410 393 402 30 401 16 401 4627 410 317 402 303 410 3361 402 3102 410 153 402 129 401 6611 410 0.766596774447825 410 48626 63431 0.073092603377985 402 3514 48076 0.056060751092818 402 3514 62682 0.049139668268486 402 317 6451 0.699894115867494 410 4627 6611   8 406 51 392 69 392 44 392 58 391 114 393 115 391 142 393 4 409 3 401 27 383 49 383 36 383 57 383 80 383 82 383 59 383 0 401 8 124 8725 1024 3204 305 0 0 16 402 36 402 3 336 4 336 169 16 336 402 2462 401 3831 401 18 400 6 383 6 379 0 399 23 400 607 401 921 401
4372 CA 2020/12/18 148 256 15 161 243 15 146 411 68428 419 53822 419 17488 410 2341 419 646 411 27 410 25 410 6926 418 3589 410 3564 418 17307 410 16585 418 181 410 141 410 8087 418 0.786549365756708 419 53822 68428 0.328932024226009 410 17488 53166 0.259112191074498 410 17488 67492 0.458014293006636 410 3589 7836 0.856436255719055 418 6926 8087   10 414 97 414 161 414 217 414 411 414 538 414 468 414 435 414 4 418 4 406 40 406 59 405 71 406 94 406 130 406 128 406 119 406 1 410 256 410 759 994   15 90   25 407 10 408 4 408 4 408 112 112 408 408 3414 410 6010 410   0   0   0   0   0 2093 410 3699 410
9552 CA 2020/12/19 148 257 14 158 247 14 135 411 67982 419 52973 419 17856 410 2191 419 665 411 24 410 19 410 6917 418 3665 410 3653 418 17675 410 16926 418 181 410 148 410 8168 418 0.779220970256833 419 52973 67982 0.3412061453795 410 17856 52332 0.266340502968289 410 17856 67042 0.46327897863734 410 3665 7911 0.846841332027424 418 6917 8168   11 414 76 414 173 414 216 414 371 414 468 414 450 414 424 414 2 418 7 406 40 406 79 406 62 406 104 406 131 406 114 406 120 406 8 410 301 410 797 1027   26 70   25 407 12 408 4 408 4 408 128 179 408 408 3358 410 5992 410   0   0   0   0   0 2090 410 3729 410
9179 TX 2020/12/04 159 420 5 190 389 5 130 579 74293 584 54143 584 9671 579 1103 584 612 579 19 579 57 579 6644 584 2730 579 2647 584 9565 579 8966 584 106 579 81 579 7563 584 0.728776600756464 584 54143 74293 0.180553740455165 579 9671 53563 0.131653461842141 579 9671 73458 0.370018975332068 579 2730 7378 0.878487372735687 584 6644 7563   6 584 42 584 72 584 89 584 186 584 205 584 233 584 203 584 67 584 9 579 28 579 62 579 60 579 102 578 97 579 123 578 91 579 40 579 136 579             19 579 27 577 1 577 4 577 162 367 577 577 336 38 1009 38   0   0   0   0   0 250 38 213 38
48648 TX 2021/06/01 102 477 11 129 450 11 79 585 66754 590 45728 590 2155 585 230 590 358 585 3 585 58 585 4949 590 647 585 585 590 2100 585 1631 590 55 585 36 585 6320 590 0.685022620367319 590 45728 66754 0.047726618386375 585 2155 45153 0.032655473390714 585 2155 65992 0.105254595737758 585 647 6147 0.783069620253164 590 4949 6320   3 590 31 589 26 589 41 589 41 589 38 589 20 589 15 589 15 590 1 585 27 584 35 584 42 584 55 584 67 584 63 584 46 584 22 585 19 585 51 319 50 3 0 1 7 585 7 585 1 585 4 585 20 65 585 585 333 36 1022 36   0   0   0   0   0 241 36 361 36

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