hospitals_state

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

10 rows where previous_day_deaths_influenza = 77 sorted by previous_day_admission_pediatric_covid_confirmed_12_17_coverage

View and edit SQL

Suggested facets: critical_staffing_shortage_anticipated_within_week_yes, hospital_onset_covid, previous_day_admission_adult_covid_suspected_20-29, previous_day_admission_adult_covid_suspected_80+_coverage, staffed_pediatric_icu_bed_occupancy, total_staffed_pediatric_icu_beds

previous_day_admission_adult_covid_suspected_50-59

previous_day_admission_adult_covid_suspected_30-39

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
3531 ID 2021/02/03 5 46 1 5 46 1 1 51 3709 52 2256 52 207 51 20 52 4 51 0 51 0 51 201 52 43 51 41 52 204 51 193 52 3 51 3 51 302 52 0.608250202210838 52 2256 3709 0.093159315931593 51 207 2222 0.056403269754768 51 207 3670 0.14527027027027 51 43 296 0.665562913907285 52 201 302   0 52 1 52 2 52 1 52 4 52 4 52 3 52 5 52 0 52 0 51 0 51 0 51 0 51 0 51 2 51 1 51 1 51 0 51 4 51 719 2319   93 101   0 51 0 51 0 51 77 51 2 1 51 51 279 29 710 29   0   0   0   0   0 83 29 230 29
4325 ID 2021/02/12 5 39 8 5 39 8 1 51 3691 52 2111 52 168 51 18 52 5 51 1 51 0 51 197 52 38 51 36 52 166 51 156 52 2 51 2 51 305 52 0.571931725819561 52 2111 3691 0.080924855491329 51 168 2076 0.046014790468365 51 168 3651 0.127090301003344 51 38 299 0.645901639344262 52 197 305   0 52 1 52 0 52 2 52 3 52 4 52 8 52 0 52 0 52 0 51 0 51 0 51 0 51 0 51 1 51 3 51 1 51 0 51 4 51 387 1294   6 62   0 51 0 51 0 51 77 51 0 0 51 51 241 30 707 30   0   0   0   0   0 64 30 228 30
5019 ID 2021/02/06 5 39 8 5 39 8 1 51 3688 52 2012 52 179 51 22 52 4 51 1 51 0 51 179 52 40 51 39 52 176 51 170 52 3 51 3 51 287 52 0.545553145336226 52 2012 3688 0.090312815338042 51 179 1982 0.049108367626886 51 179 3645 0.142348754448399 51 40 281 0.623693379790941 52 179 287   0 52 1 52 5 52 1 51 4 52 7 52 3 51 1 52 0 52 0 51 0 51 0 51 0 51 0 51 1 50 3 51 0 51 0 51 1 51 321 904   7 61   0 51 0 51 0 51 77 51 2 1 51 51 255 33 745 33   0   0   0   0   0 78 33 229 33
5095 ID 2021/02/10 5 46 1 5 46 1 1 51 3705 52 2222 52 180 51 21 52 3 51 0 51 0 51 210 52 47 51 45 52 176 51 167 52 4 51 3 51 306 52 0.599730094466937 52 2222 3705 0.082379862700229 51 180 2185 0.049113233287858 51 180 3665 0.156666666666667 51 47 300 0.686274509803922 52 210 306   0 52 2 52 1 52 0 52 4 52 4 52 8 52 2 52 0 52 0 51 0 51 0 51 0 51 0 51 0 51 2 51 1 51 0 51 1 51 702 2239   31 96   0 51 0 51 0 51 77 51 0 0 51 51 259 30 709 30   0   0   0   0   0 72 30 227 30
5877 ID 2021/02/04 5 39 8 5 39 8 2 51 3698 52 2210 52 196 51 18 52 6 51 0 51 0 51 194 52 42 51 40 52 193 51 174 52 3 51 3 51 305 52 0.597620335316387 52 2210 3698 0.090197883110907 51 196 2173 0.053610503282276 51 196 3656 0.140468227424749 51 42 299 0.636065573770492 52 194 305   0 52 0 52 0 52 1 52 4 52 3 52 4 52 6 52 0 52 0 51 0 51 0 51 2 51 0 51 2 51 2 51 0 51 0 51 2 51 324 929   7 59   0 51 0 51 0 51 77 51 2 1 51 51 306 29 716 29   0   0   0   0   0 90 29 230 29
6117 ID 2021/02/13 5 39 8 5 39 8 1 51 3649 52 1997 52 178 51 30 52 7 51 1 51 0 51 180 52 41 51 38 52 176 51 165 52 2 51 2 51 284 52 0.547273225541244 52 1997 3649 0.090631364562118 51 178 1964 0.049321141590468 51 178 3609 0.147482014388489 51 41 278 0.633802816901408 52 180 284   1 52 2 52 2 52 1 52 6 52 7 52 7 52 4 52 0 52 0 51 1 51 0 51 3 51 1 51 0 51 1 51 1 51 0 51 2 51 320 900   9 56   0 51 0 51 0 51 77 51 0 0 51 51 237 35 706 35   0   0   0   0   0 62 35 225 35
6798 ID 2021/02/07 4 40 8 4 40 8 1 51 3675 52 1981 52 174 51 24 52 2 51 0 51 0 51 178 52 36 51 36 52 171 51 168 52 3 51 3 51 307 52 0.539047619047619 52 1981 3675 0.088957055214724 51 174 1956 0.047920683007436 51 174 3631 0.12 51 36 300 0.579804560260586 52 178 307   0 52 0 52 0 52 3 52 3 52 2 52 9 52 6 52 1 52 0 51 0 51 0 51 0 51 0 51 0 51 0 51 0 51 2 51 1 51 318 919   5 58   0 51 0 51 0 51 77 51 1 0 51 51 256 34 722 34   0   0   0   0   0 72 34 225 34
6843 ID 2021/02/14 5 39 8 5 39 8 1 51 3680 52 1972 52 177 51 18 52 6 51 0 51 1 51 169 52 41 51 40 52 173 51 162 52 4 51 2 51 305 52 0.535869565217391 52 1972 3680 0.091190108191654 51 177 1941 0.048639736191261 51 177 3639 0.137123745819398 51 41 299 0.554098360655738 52 169 305   0 52 0 51 2 51 4 51 2 51 3 51 4 51 3 51 0 52 0 51 0 50 0 50 0 50 2 50 1 50 3 50 0 50 0 51 0 51 312 884   5 24   0 51 0 51 0 51 77 51 0 0 51 51 247 35 715 35   0   0   0   0   0 67 35 227 35
7448 ID 2021/02/11 5 39 8 5 39 8 1 51 3705 52 2179 52 171 51 25 52 3 51 0 51 0 51 206 52 39 51 39 52 169 51 162 52 2 51 2 51 304 52 0.588124156545209 52 2179 3705 0.079646017699115 51 171 2147 0.046683046683047 51 171 3663 0.130872483221477 51 39 298 0.677631578947368 52 206 304   0 52 2 52 3 52 2 52 1 52 6 52 8 52 2 52 1 52 0 51 0 51 1 51 0 51 0 51 0 51 1 51 1 51 0 51 1 51 321 916   6 46   0 51 0 51 0 51 77 51 0 0 51 51 257 30 710 30   0   0   0   0   0 68 30 228 30
8216 ID 2021/02/05 5 39 8 5 39 8 1 51 3702 52 2119 52 188 51 32 52 4 51 0 51 0 51 192 52 45 51 43 52 185 51 178 52 3 51 3 51 304 52 0.572393300918422 52 2119 3702 0.089952153110048 51 188 2090 0.051366120218579 51 188 3660 0.151006711409396 51 45 298 0.631578947368421 52 192 304   0 52 0 52 0 52 0 52 5 52 2 52 13 52 12 52 0 52 0 51 0 51 1 51 0 51 0 51 1 51 1 51 1 51 0 51 2 51 321 939   7 61   0 51 0 51 0 51 77 51 2 1 51 51 272 30 717 30   0   0   0   0   0 80 30 228 30

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