hospitals_state

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

5 rows where previous_day_admission_pediatric_covid_confirmed_5_11 = 16 sorted by staffed_pediatric_icu_bed_occupancy

View and edit SQL

Suggested facets: critical_staffing_shortage_today_no, critical_staffing_shortage_anticipated_within_week_yes, hospital_onset_covid_coverage, previous_day_admission_adult_covid_confirmed_coverage, previous_day_admission_pediatric_covid_suspected_coverage, staffed_adult_icu_bed_occupancy_coverage, staffed_icu_adult_patients_confirmed_and_suspected_covid_coverage, total_adult_patients_hospitalized_confirmed_covid_coverage, total_staffed_adult_icu_beds_coverage, adult_icu_bed_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_40-49_coverage, previous_day_admission_adult_covid_confirmed_80+_coverage, previous_day_admission_adult_covid_confirmed_unknown_coverage, previous_day_admission_adult_covid_suspected_20-29_coverage, previous_day_admission_adult_covid_suspected_40-49_coverage, previous_day_admission_adult_covid_suspected_80+, previous_day_admission_adult_covid_suspected_unknown, previous_day_admission_adult_covid_suspected_unknown_coverage, on_hand_supply_therapeutic_b_bamlanivimab_courses, on_hand_supply_therapeutic_c_bamlanivimab_etesevimab_courses, icu_patients_confirmed_influenza_coverage, previous_day_admission_influenza_confirmed_coverage, previous_day_deaths_influenza_coverage, total_patients_hospitalized_confirmed_influenza_and_covid, all_pediatric_inpatient_bed_occupied_coverage, previous_day_admission_pediatric_covid_confirmed_12_17, previous_day_admission_pediatric_covid_confirmed_5_11_coverage, staffed_icu_pediatric_patients_confirmed_covid, staffed_pediatric_icu_bed_occupancy_coverage, total_staffed_pediatric_icu_beds_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
12637 TX 2022/07/31 6 104 484 9 101 484 144 589 63993 594 48292 594 3899 589 519 594 225 589 41 589 65 589 5015 594 573 589 532 594 3646 589 3335 594 253 589 187 589 5851 594 0.754645039301174 594 48292 63993 0.081714345593629 589 3899 47715 0.061633549896461 589 3899 63261 0.10031512605042 589 573 5712 0.857118441292087 594 5015 5851   6 591 33 589 31 587 39 588 63 587 101 587 131 587 120 588 26 594 5 586 16 584 18 582 24 583 29 582 45 582 41 582 44 583 3 589 22 580 349 0 114 0 0 0 8 589 11 589 0 104 0 104 74 10 104 589 3619 589 4241 589 33 587 8 581 16 582 0 589 44 589 893 589 1079 589
25642 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
26331 TX 2022/07/09 7 104 483 9 102 483 144 589 64618 594 49195 594 3358 589 643 594 360 589 47 589 74 589 5180 594 460 589 402 594 3150 589 2873 594 208 589 131 589 5983 594 0.761320375127673 594 49195 64618 0.06908185726923 589 3358 48609 0.05256155399377 589 3358 63887 0.078740157480315 589 460 5842 0.865786394785225 594 5180 5983   5 592 43 589 41 588 45 588 55 588 96 588 141 588 148 588 86 594 2 587 17 583 16 583 28 583 37 583 53 583 55 582 48 583 104 589 15 583 356 0 114 0 0 0 3 589 10 589 0 105 0 105 97 8 105 589 3790 589 4408 589 22 587 9 582 16 582 0 589 40 589 916 589 1056 589
13546 TX 2022/08/29 6 78 416 8 76 416 102 495 57944 500 44669 500 3074 495 367 500 198 495 54 495 92 495 5064 500 400 495 360 500 2791 495 2530 500 283 495 173 495 5885 500 0.77089948916195 500 44669 57944 0.069763747361732 495 3074 44063 0.053724352476493 495 3074 57218 0.069601531233687 495 400 5747 0.860492778249788 500 5064 5885   5 499 19 496 23 495 40 495 32 495 69 494 87 494 92 494 17 500 3 494 18 491 23 490 23 490 23 490 42 489 33 489 29 489 4 495 16 492 259 0 85 0 0 0 10 495 20 495 0 91 0 91 108 7 91 495 3637 495 4157 495 31 494 15 490 16 491 0 495 30 495 930 495 1080 495
27538 TX 2022/02/16 12 108 476 14 106 476 139 591 67514 596 53121 596 7001 591 773 596 387 591 61 591 88 591 6203 596 1644 591 1606 596 6738 591 6296 596 263 591 215 591 6742 596 0.78681458660426 596 53121 67514 0.133446428911804 591 7001 52463 0.104899610428529 591 7001 66740 0.250647964628754 591 1644 6559 0.920053396618214 596 6203 6742   5 596 43 593 56 593 74 593 113 593 139 593 157 593 124 593 62 596 5 591 29 588 34 588 40 588 52 588 83 588 68 588 56 588 20 591 84 586 3319 701 1990 0 0 0 19 591 32 591 0 111 0 111 107 12 111 591 3837 591 4402 591 34 591 11 587 16 587 0 591 45 591 953 591 1111 591

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE hospitals_state (
  "state" TEXT,
  "date" TEXT,
  "critical_staffing_shortage_today_yes" INTEGER,
  "critical_staffing_shortage_today_no" INTEGER,
  "critical_staffing_shortage_today_not_reported" INTEGER,
  "critical_staffing_shortage_anticipated_within_week_yes" INTEGER,
  "critical_staffing_shortage_anticipated_within_week_no" INTEGER,
  "critical_staffing_shortage_anticipated_within_week_not_reported" INTEGER,
  "hospital_onset_covid" INTEGER,
  "hospital_onset_covid_coverage" INTEGER,
  "inpatient_beds" INTEGER,
  "inpatient_beds_coverage" INTEGER,
  "inpatient_beds_used" INTEGER,
  "inpatient_beds_used_coverage" INTEGER,
  "inpatient_beds_used_covid" INTEGER,
  "inpatient_beds_used_covid_coverage" INTEGER,
  "previous_day_admission_adult_covid_confirmed" INTEGER,
  "previous_day_admission_adult_covid_confirmed_coverage" INTEGER,
  "previous_day_admission_adult_covid_suspected" INTEGER,
  "previous_day_admission_adult_covid_suspected_coverage" INTEGER,
  "previous_day_admission_pediatric_covid_confirmed" INTEGER,
  "previous_day_admission_pediatric_covid_confirmed_coverage" INTEGER,
  "previous_day_admission_pediatric_covid_suspected" INTEGER,
  "previous_day_admission_pediatric_covid_suspected_coverage" INTEGER,
  "staffed_adult_icu_bed_occupancy" INTEGER,
  "staffed_adult_icu_bed_occupancy_coverage" INTEGER,
  "staffed_icu_adult_patients_confirmed_and_suspected_covid" INTEGER,
  "staffed_icu_adult_patients_confirmed_and_suspected_covid_coverage" INTEGER,
  "staffed_icu_adult_patients_confirmed_covid" INTEGER,
  "staffed_icu_adult_patients_confirmed_covid_coverage" INTEGER,
  "total_adult_patients_hospitalized_confirmed_and_suspected_covid" INTEGER,
  "total_adult_patients_hospitalized_confirmed_and_suspected_covid_coverage" INTEGER,
  "total_adult_patients_hospitalized_confirmed_covid" INTEGER,
  "total_adult_patients_hospitalized_confirmed_covid_coverage" INTEGER,
  "total_pediatric_patients_hospitalized_confirmed_and_suspected_covid" INTEGER,
  "total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_coverage" INTEGER,
  "total_pediatric_patients_hospitalized_confirmed_covid" INTEGER,
  "total_pediatric_patients_hospitalized_confirmed_covid_coverage" INTEGER,
  "total_staffed_adult_icu_beds" INTEGER,
  "total_staffed_adult_icu_beds_coverage" INTEGER,
  "inpatient_beds_utilization" INTEGER,
  "inpatient_beds_utilization_coverage" INTEGER,
  "inpatient_beds_utilization_numerator" INTEGER,
  "inpatient_beds_utilization_denominator" INTEGER,
  "percent_of_inpatients_with_covid" INTEGER,
  "percent_of_inpatients_with_covid_coverage" INTEGER,
  "percent_of_inpatients_with_covid_numerator" INTEGER,
  "percent_of_inpatients_with_covid_denominator" INTEGER,
  "inpatient_bed_covid_utilization" INTEGER,
  "inpatient_bed_covid_utilization_coverage" INTEGER,
  "inpatient_bed_covid_utilization_numerator" INTEGER,
  "inpatient_bed_covid_utilization_denominator" INTEGER,
  "adult_icu_bed_covid_utilization" INTEGER,
  "adult_icu_bed_covid_utilization_coverage" INTEGER,
  "adult_icu_bed_covid_utilization_numerator" INTEGER,
  "adult_icu_bed_covid_utilization_denominator" INTEGER,
  "adult_icu_bed_utilization" INTEGER,
  "adult_icu_bed_utilization_coverage" INTEGER,
  "adult_icu_bed_utilization_numerator" INTEGER,
  "adult_icu_bed_utilization_denominator" INTEGER,
  "geocoded_state" INTEGER,
  "previous_day_admission_adult_covid_confirmed_18-19" INTEGER,
  "previous_day_admission_adult_covid_confirmed_18-19_coverage" INTEGER,
  "previous_day_admission_adult_covid_confirmed_20-29" INTEGER,
  "previous_day_admission_adult_covid_confirmed_20-29_coverage" INTEGER,
  "previous_day_admission_adult_covid_confirmed_30-39" INTEGER,
  "previous_day_admission_adult_covid_confirmed_30-39_coverage" INTEGER,
  "previous_day_admission_adult_covid_confirmed_40-49" INTEGER,
  "previous_day_admission_adult_covid_confirmed_40-49_coverage" INTEGER,
  "previous_day_admission_adult_covid_confirmed_50-59" INTEGER,
  "previous_day_admission_adult_covid_confirmed_50-59_coverage" INTEGER,
  "previous_day_admission_adult_covid_confirmed_60-69" INTEGER,
  "previous_day_admission_adult_covid_confirmed_60-69_coverage" INTEGER,
  "previous_day_admission_adult_covid_confirmed_70-79" INTEGER,
  "previous_day_admission_adult_covid_confirmed_70-79_coverage" INTEGER,
  "previous_day_admission_adult_covid_confirmed_80+" INTEGER,
  "previous_day_admission_adult_covid_confirmed_80+_coverage" INTEGER,
  "previous_day_admission_adult_covid_confirmed_unknown" INTEGER,
  "previous_day_admission_adult_covid_confirmed_unknown_coverage" INTEGER,
  "previous_day_admission_adult_covid_suspected_18-19" INTEGER,
  "previous_day_admission_adult_covid_suspected_18-19_coverage" INTEGER,
  "previous_day_admission_adult_covid_suspected_20-29" INTEGER,
  "previous_day_admission_adult_covid_suspected_20-29_coverage" INTEGER,
  "previous_day_admission_adult_covid_suspected_30-39" INTEGER,
  "previous_day_admission_adult_covid_suspected_30-39_coverage" INTEGER,
  "previous_day_admission_adult_covid_suspected_40-49" INTEGER,
  "previous_day_admission_adult_covid_suspected_40-49_coverage" INTEGER,
  "previous_day_admission_adult_covid_suspected_50-59" INTEGER,
  "previous_day_admission_adult_covid_suspected_50-59_coverage" INTEGER,
  "previous_day_admission_adult_covid_suspected_60-69" INTEGER,
  "previous_day_admission_adult_covid_suspected_60-69_coverage" INTEGER,
  "previous_day_admission_adult_covid_suspected_70-79" INTEGER,
  "previous_day_admission_adult_covid_suspected_70-79_coverage" INTEGER,
  "previous_day_admission_adult_covid_suspected_80+" INTEGER,
  "previous_day_admission_adult_covid_suspected_80+_coverage" INTEGER,
  "previous_day_admission_adult_covid_suspected_unknown" INTEGER,
  "previous_day_admission_adult_covid_suspected_unknown_coverage" INTEGER,
  "deaths_covid" INTEGER,
  "deaths_covid_coverage" INTEGER,
  "on_hand_supply_therapeutic_a_casirivimab_imdevimab_courses" INTEGER,
  "on_hand_supply_therapeutic_b_bamlanivimab_courses" INTEGER,
  "on_hand_supply_therapeutic_c_bamlanivimab_etesevimab_courses" INTEGER,
  "previous_week_therapeutic_a_casirivimab_imdevimab_courses_used" INTEGER,
  "previous_week_therapeutic_b_bamlanivimab_courses_used" INTEGER,
  "previous_week_therapeutic_c_bamlanivimab_etesevimab_courses_used" INTEGER,
  "icu_patients_confirmed_influenza" INTEGER,
  "icu_patients_confirmed_influenza_coverage" INTEGER,
  "previous_day_admission_influenza_confirmed" INTEGER,
  "previous_day_admission_influenza_confirmed_coverage" INTEGER,
  "previous_day_deaths_covid_and_influenza" INTEGER,
  "previous_day_deaths_covid_and_influenza_coverage" INTEGER,
  "previous_day_deaths_influenza" INTEGER,
  "previous_day_deaths_influenza_coverage" INTEGER,
  "total_patients_hospitalized_confirmed_influenza" INTEGER,
  "total_patients_hospitalized_confirmed_influenza_and_covid" INTEGER,
  "total_patients_hospitalized_confirmed_influenza_and_covid_coverage" INTEGER,
  "total_patients_hospitalized_confirmed_influenza_coverage" INTEGER,
  "all_pediatric_inpatient_bed_occupied" INTEGER,
  "all_pediatric_inpatient_bed_occupied_coverage" INTEGER,
  "all_pediatric_inpatient_beds" INTEGER,
  "all_pediatric_inpatient_beds_coverage" INTEGER,
  "previous_day_admission_pediatric_covid_confirmed_0_4" INTEGER,
  "previous_day_admission_pediatric_covid_confirmed_0_4_coverage" INTEGER,
  "previous_day_admission_pediatric_covid_confirmed_12_17" INTEGER,
  "previous_day_admission_pediatric_covid_confirmed_12_17_coverage" INTEGER,
  "previous_day_admission_pediatric_covid_confirmed_5_11" INTEGER,
  "previous_day_admission_pediatric_covid_confirmed_5_11_coverage" INTEGER,
  "previous_day_admission_pediatric_covid_confirmed_unknown" INTEGER,
  "previous_day_admission_pediatric_covid_confirmed_unknown_coverage" INTEGER,
  "staffed_icu_pediatric_patients_confirmed_covid" INTEGER,
  "staffed_icu_pediatric_patients_confirmed_covid_coverage" INTEGER,
  "staffed_pediatric_icu_bed_occupancy" INTEGER,
  "staffed_pediatric_icu_bed_occupancy_coverage" INTEGER,
  "total_staffed_pediatric_icu_beds" INTEGER,
  "total_staffed_pediatric_icu_beds_coverage" INTEGER
);
Powered by Datasette · Queries took 8544.916ms · Data source: U.S. Department of Health & Human Services