hospitals_state

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

7 rows where previous_day_deaths_influenza = 7 sorted by on_hand_supply_therapeutic_b_bamlanivimab_courses

View and edit SQL

Suggested facets: critical_staffing_shortage_anticipated_within_week_yes, previous_day_admission_adult_covid_suspected_coverage, previous_day_admission_pediatric_covid_confirmed_coverage, inpatient_beds_utilization_coverage, inpatient_bed_covid_utilization_coverage, 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_coverage, 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+_coverage, previous_day_admission_adult_covid_confirmed_unknown, previous_day_admission_adult_covid_suspected_60-69_coverage, previous_day_admission_adult_covid_suspected_80+_coverage, previous_day_deaths_covid_and_influenza, previous_day_deaths_covid_and_influenza_coverage, previous_day_deaths_influenza_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_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
28072 CA 2022/11/26 8 102 261 87 219 65 48 363 61207 371 47570 371 3760 363 605 371 328 363 19 362 20 360 4797 371 403 363 356 371 3638 363 3140 371 122 363 82 363 6577 371 0.777198686424755 371 47570 61207 0.08 363 3760 47000 0.062165200714238 363 3760 60484 0.062782364854339 363 403 6419 0.729359890527596 371 4797 6577   4 366 38 364 53 361 35 361 51 360 99 360 147 360 201 361 2 369 4 360 20 353 22 353 34 353 44 353 67 353 67 353 70 353 0 362 7 106 1114 165 96 0 0 0 160 362 510 362 0 80 7 321 1493 101 322 362 2660 362 3756 362 15 360 2 136 2 350 0 360 23 362 813 362 1044 362
25706 CA 2022/12/01 9 100 265 91 227 56 65 366 63952 374 53214 374 4563 366 710 374 381 366 35 365 26 364 5449 374 490 366 438 374 4414 366 3922 374 149 366 121 366 6896 374 0.832092819614711 374 53214 63952 0.086861341658418 366 4563 52532 0.072199367088608 366 4563 63200 0.072851620576866 366 490 6726 0.790168213457077 374 5449 6896   4 370 38 364 57 361 38 361 80 361 119 361 131 361 244 362 2 373 5 363 30 354 36 353 34 353 41 353 70 354 85 353 79 351 1 351 11 110 1182 185 106 0 0 0 235 365 480 365 1 81 7 323 2077 106 324 365 2853 365 3818 365 21 365 8 140 6 355 0 364 29 365 815 365 1055 365
23776 MD 2022/11/27 12 18 20 14 18 18 13 49 10358 50 8175 50 835 49 56 50 167 49 0 49 16 49 888 50 71 49 37 50 775 49 489 50 35 49 9 49 1269 50 0.789245027997683 50 8175 10358 0.103010115963484 49 835 8106 0.081336450418858 49 835 10266 0.05748987854251 49 71 1235 0.699763593380615 50 888 1269   0 50 2 49 6 49 2 49 7 49 13 49 15 49 11 49 0 50 2 49 8 48 18 48 12 48 30 48 33 48 37 48 27 48 0 49 3 28 534 365 646 0 0 0 29 49 56 49 0 20 7 21 182 0 21 49 331 49 538 49 0 49 0 47 0 47 0 42 1 49 20 49 20 49
28497 MD 2022/11/19 12 22 17 14 21 16 16 50 10484 51 8488 51 665 50 57 51 165 50 6 50 13 50 896 51 61 50 36 51 621 50 383 51 44 50 13 50 1302 51 0.809614650896604 51 8488 10484 0.078978622327791 50 665 8420 0.064028499903717 50 665 10386 0.048297703879652 50 61 1263 0.688172043010753 51 896 1302   0 51 4 50 2 50 2 50 3 50 12 50 15 50 19 50 0 51 2 50 17 49 19 49 12 49 23 49 24 49 30 49 38 49 0 50 3 27 462 365 646 0 0 0 11 50 31 50 0 20 7 20 112 0 20 50 377 50 548 50 3 50 1 48 2 48 0 43 0 50 20 50 21 50
29865 MD 2022/11/30 12 23 15 14 22 14 12 49 10495 50 8949 50 783 49 91 50 228 49 3 49 23 49 980 50 71 49 45 50 736 49 490 50 47 49 11 49 1317 50 0.85269175797999 50 8949 10495 0.088205474822575 49 783 8877 0.075288461538462 49 783 10400 0.05546875 49 71 1280 0.744115413819286 50 980 1317   0 50 4 49 6 49 8 49 3 49 14 49 23 49 33 49 0 50 4 49 18 48 24 48 24 48 32 48 48 48 47 48 31 48 0 49 2 28 536 365 646 0 0 0 41 49 60 49 0 20 7 21 233 3 21 49 379 49 544 49 2 48 1 48 0 47 0 42 1 49 20 49 20 49
24848 CA 2022/12/03 9 116 250 90 219 66 68 367 64687 375 51641 375 4618 367 663 375 343 367 23 366 24 364 5302 375 501 367 459 375 4470 367 3943 375 148 367 116 367 6812 375 0.798321146443644 375 51641 64687 0.090584542958023 367 4618 50980 0.072223959962465 367 4618 63940 0.07541773295198 367 501 6643 0.778332354668233 375 5302 6812   3 372 40 368 54 366 34 366 74 366 97 366 117 366 230 366 4 373 1 363 26 357 33 357 33 356 45 357 66 357 67 357 68 356 4 365 11 128 2398 1177 506 0 0 0 259 363 405 363 0 99 7 325 2056 125 325 363 2973 366 3868 366 13 364 5 154 5 357 0 364 30 366 809 366 1039 366
25551 OK 2021/09/27 51 84 3 52 83 3 10 136 9499 138 6718 138 1166 136 181 138 75 136 1 136 7 136 865 138 335 136 346 138 1128 136 1085 138 38 136 36 136 1019 138 0.707232340246342 138 6718 9499 0.177042210750076 136 1166 6586 0.125161013310434 136 1166 9316 0.344295991778006 136 335 973 0.848871442590775 138 865 1019   0 138 10 135 10 135 35 135 30 135 47 135 28 135 14 135 7 138 1 136 26 133 7 133 5 133 10 133 6 133 12 133 8 133 0 136 19 136 5110 2619 1534 1683 3 125 3 124 2 124 0 124 7 124 7 2 124 124 510 71 732 71   0   0   0   0   0 307 71 383 71

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