hospitals_state

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

8 rows where previous_day_admission_pediatric_covid_confirmed_5_11 = 19 sorted by icu_patients_confirmed_influenza

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: inpatient_beds_coverage, inpatient_beds_used_coverage, previous_day_admission_adult_covid_confirmed_coverage, previous_day_admission_pediatric_covid_confirmed_coverage, total_adult_patients_hospitalized_confirmed_covid_coverage, inpatient_bed_covid_utilization_coverage, all_pediatric_inpatient_bed_occupied_coverage, previous_day_admission_pediatric_covid_confirmed_12_17, previous_day_admission_pediatric_covid_confirmed_5_11_coverage, previous_day_admission_pediatric_covid_confirmed_unknown_coverage, staffed_icu_pediatric_patients_confirmed_covid_coverage, total_staffed_pediatric_icu_beds, total_staffed_pediatric_icu_beds_coverage

staffed_adult_icu_bed_occupancy_coverage ✖

previous_day_admission_adult_covid_suspected_30-39_coverage ✖

previous_day_admission_pediatric_covid_confirmed_5_11 ✖

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
24151 24151 TX 2022/07/10 7 104 483 9 102 483 161 589 63728 594 47765 594 3388 589 549 594 334 589 63 589 80 589 4979 594 493 589 431 594 3176 589 2911 594 227 589 146 589 5812 594 0.749513557619884 594 47765 63728 0.071790307884644 589 3388 47193 0.053776924175807 589 3388 63001 0.086933521424793 589 493 5671 0.856675843083276 594 4979 5812   4 592 28 588 35 588 48 588 48 588 93 588 112 588 120 588 79 594 2 587 20 583 22 584 26 583 29 583 41 583 37 582 37 583 120 589 17 583 335 0 114 0 0 0 2 589 10 589 0 105 0 105 95 7 105 589 3668 589 4350 589 32 587 12 582 19 582 0 589 34 589 878 589 1044 589
31035 31035 TX 2022/07/26 7 79 416 10 76 416 118 497 58808 502 46418 502 4157 497 608 502 331 497 61 497 76 497 5386 502 606 497 568 502 3910 497 3583 502 247 497 181 497 6080 502 0.789314378996055 502 46418 58808 0.090772119835794 497 4157 45796 0.071579853637538 497 4157 58075 0.102054563826204 497 606 5938 0.885855263157895 502 5386 6080   7 500 46 497 44 497 43 496 69 496 102 496 136 496 153 496 22 502 8 495 30 492 28 492 26 492 53 492 63 491 56 491 62 491 5 497 31 492 330 0 85 0 0 0 3 497 10 497 0 92 0 92 72 8 92 497 3454 497 4052 497 38 495 14 491 19 492 0 497 32 497 915 497 1080 497
41069 41069 CA 2022/01/27 34 137 245 159 220 37 201 408 68135 416 55219 416 15370 408 1733 416 548 408 78 397 28 407 6212 416 2536 408 2549 416 14913 408 14619 416 457 408 412 407 7427 416 0.810435165480296 416 55219 68135 0.281677234908185 408 15370 54566 0.228231171299596 408 15370 67344 0.349744862777548 408 2536 7251 0.836407701629191 416 6212 7427   21 411 135 404 189 401 152 401 239 402 330 401 315 401 343 401 9 405 4 402 42 397 47 395 41 394 61 393 90 392 88 392 175 393 0 408 68 144 8909 585 3523 392 0 16 3 404 6 404 0 369 0 368 51 7 368 404 722 73 3060 301 37 289 14 289 19 288 8 312 75 300 547 301 758 299
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
35663 35663 TX 2022/02/02 10 114 472 16 108 472 207 591 67351 596 53627 596 12508 591 1595 596 413 591 69 591 158 591 6522 596 2593 591 2622 596 11898 591 11578 596 469 591 385 591 6882 596 0.796231681786462 596 53627 67351 0.236245160071773 591 12508 52945 0.187878332707473 591 12508 66575 0.386957170571556 591 2593 6701 0.94768962510898 596 6522 6882   15 596 88 594 104 594 135 594 217 594 298 594 320 594 304 594 114 596 5 591 29 589 37 589 34 589 49 589 82 589 79 589 65 589 33 591 180 585 3623 701 1976 598 0 0 11 591 16 591 0 586 0 586 89 39 586 591 3649 591 4206 591 34 591 16 588 19 588 0 591 75 591 945 591 1092 591
34094 34094 TX 2022/08/27 6 83 494 9 80 494 107 578 63201 583 48643 583 3057 578 406 583 288 578 56 578 103 578 5220 583 436 578 399 583 2796 578 2504 583 248 578 165 578 5932 583 0.769655543424946 583 48643 63201 0.063617255946559 578 3057 48053 0.048932355860038 578 3057 62474 0.07526324874849 578 436 5793 0.879973027646662 583 5220 5932   6 582 23 579 29 578 36 578 57 578 69 577 84 577 91 577 22 583 3 577 21 574 34 573 37 573 34 573 57 572 53 572 40 572 9 578 11 574 370 0 114 0 0 0 12 578 22 578 0 93 0 93 103 9 93 578 3805 578 4264 578 34 577 11 573 19 574 0 578 28 578 924 578 1053 578
43189 43189 TX 2022/02/07 12 81 413 15 78 413 155 501 59934 506 46686 506 10378 501 1007 506 326 501 69 501 107 501 6174 506 2320 501 2304 506 9989 501 9472 506 342 501 288 501 6628 506 0.778956852537792 506 46686 59934 0.225265899717821 501 10378 46070 0.17536922504985 501 10378 59178 0.359913124418244 501 2320 6446 0.931502715751358 506 6174 6628   5 504 63 502 59 502 77 502 111 502 218 502 193 502 210 502 71 506 2 499 22 497 30 497 28 498 52 497 59 497 60 497 61 497 12 501 142 494 265 0 85 0 0 0 17 501 17 501 0 95 0 95 142 18 95 501 3160 501 3769 501 30 499 20 497 19 497 0 501 60 501 881 501 1056 501
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 10604.203ms · Data source: U.S. Department of Health & Human Services