hospitals_state

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

9 rows where previous_day_admission_adult_covid_confirmed_30-39 = 189 sorted by icu_patients_confirmed_influenza_coverage

View and edit SQL

previous_day_admission_pediatric_covid_confirmed_unknown_coverage

previous_day_admission_pediatric_covid_confirmed_5_11

previous_day_admission_adult_covid_confirmed_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
52575 TX 2021/08/23 21 76 410 16 81 410 86 502 61475 507 49217 507 14386 502 1658 507 536 502 40 502 123 502 6837 507 3687 502 3671 507 14095 502 13583 507 291 502 235 502 7296 507 0.800601870679138 507 49217 61475 0.296270362666557 502 14386 48557 0.237064135521719 502 14386 60684 0.519734987313222 502 3687 7094 0.937088815789474 507 6837 7296   8 507 109 506 189 506 264 506 283 506 306 506 242 506 149 506 108 507 9 502 42 501 72 501 63 501 79 501 82 501 77 501 46 501 66 502 184 502 473 1760 233 161 0 1 5 132 2 132 0 132 0 132 56 11 132 132 3612 502 4266 502   0   0   0   0   0 932 502 1034 502
54977 TX 2021/08/05 24 107 465 21 110 465 79 591 67228 596 53864 596 9227 591 1371 596 608 591 36 591 88 591 6076 596 2288 591 2276 596 8988 591 8521 596 239 591 172 591 6809 596 0.80121377997263 596 53864 67228 0.173381186816491 591 9227 53218 0.138827034183919 591 9227 66464 0.345150098054005 591 2288 6629 0.892348362461448 596 6076 6809   11 596 107 596 189 596 203 596 268 596 190 596 174 596 124 596 101 596 9 591 61 591 46 591 75 591 103 591 97 591 94 591 61 591 62 591 72 591 514 1785 283 82 11 22 4 167 6 167 0 167 0 167 61 20 167 167 4526 591 4931 591   0   0   0   0   0 1115 591 1250 591
43980 TX 2022/01/19 22 117 454 28 111 454 342 588 67711 593 53163 593 13936 588 2168 593 528 588 156 587 213 587 6414 593 2664 588 2678 593 13316 588 12929 593 588 588 498 588 6734 593 0.785145692723487 593 53163 67711 0.265569022029118 588 13936 52476 0.208233096750093 588 13936 66925 0.406966086159487 588 2664 6546 0.952479952479952 593 6414 6734   15 591 172 589 189 588 154 588 316 588 394 589 441 590 329 588 158 593 4 586 41 584 49 583 55 583 80 583 103 583 90 584 66 583 40 588 170 581 4815 737 3179 314 0 42 8 172 16 172 0 138 0 138 125 28 138 172 375 82 385 78 0 82 11 77 0 78 155 137 4 80 61 80 21 80
49805 TX 2021/09/09 26 117 453 21 122 453 154 591 69673 596 55630 596 14354 591 1611 596 659 591 53 591 168 591 7371 596 3945 591 3895 596 13940 591 13375 596 386 591 305 591 7913 596 0.798444160578703 596 55630 69673 0.261072006693221 591 14354 54981 0.20843679663109 591 14354 68865 0.512271133619011 591 3945 7701 0.93150511815999 596 7371 7913   15 596 97 595 189 595 227 595 294 595 302 595 245 595 136 595 106 596 13 591 48 590 65 590 90 590 84 590 115 590 89 590 72 590 83 591 233 591 1988 1735 414 559 0 0 4 179 8 179 0 179 0 179 49 10 179 179 4177 591 4681 591   0   0   0   0   0 994 591 1071 591
54475 TX 2021/08/15 25 119 452 23 121 452 67 591 66338 596 51308 596 12381 591 1505 596 562 591 27 591 102 591 6487 596 3162 591 3153 596 12132 591 11702 596 249 591 182 591 7005 596 0.773433024812325 596 51308 66338 0.244172287303278 591 12381 50706 0.188829746671344 591 12381 65567 0.464590067587423 591 3162 6806 0.926052819414704 596 6487 7005   9 596 110 595 189 595 243 595 282 595 252 595 199 595 120 595 101 596 4 591 53 590 56 590 77 590 98 590 90 590 72 590 52 590 58 591 149 591 1280 1776 401 216 13 51 4 180 3 180 1 180 1 180 63 13 180 180 3798 591 4442 591   0   0   0   0   0 945 591 1068 591
49514 FL 2021/08/01 33 175 59 33 175 59 112 261 59180 267 48200 267 11261 261 1675 267 225 261 50 261 27 261 5706 267 2285 261 2288 267 11117 261 10850 267 144 261 135 261 6654 267 0.814464346062859 267 48200 59180 0.23715356751748 261 11261 47484 0.193375004293025 261 11261 58234 0.355034182722188 261 2285 6436 0.857529305680794 267 5706 6654   15 267 110 266 189 265 245 265 319 265 266 265 239 265 206 264 86 267 2 261 10 259 23 259 26 259 42 259 41 259 38 259 37 259 6 261 104 261 7139 3717 3613 1463 0 0 4 258 7 258 0 258 0 258 50 15 258 258 2692 260 3842 260   0   0   0   0   0 1157 260 1569 260
38560 CA 2022/01/24 34 103 240 159 181 37 190 369 64510 377 51664 377 15920 369 1732 377 338 369 71 359 19 369 6048 377 2561 369 2591 377 15436 369 15171 377 433 369 394 368 7349 377 0.800868082467834 377 51664 64510 0.312175225993686 369 15920 50997 0.249831301100074 369 15920 63723 0.357033319392165 369 2561 7173 0.822969111443734 377 6048 7349   25 376 158 373 189 372 140 372 215 372 328 373 330 372 342 372 5 367 3 369 17 365 35 364 33 364 49 364 81 364 61 364 59 364 0 369 56 128 8841 887 4162 640 0 120 5 365 1 365 1 352 1 351 49 7 351 365 571 49 2781 276 27 267 21 264 13 266 10 279 78 272 497 276 752 275
38795 CA 2022/01/05 142 241 32 148 235 32 97 407 65868 415 52580 415 9198 407 1593 415 492 407 80 406 17 406 5801 415 1431 407 1434 415 8871 407 8465 415 327 407 285 406 7005 415 0.798263193052772 415 52580 65868 0.177010565209861 407 9198 51963 0.141251266930803 407 9198 65118 0.209547517938205 407 1431 6829 0.828122769450392 415 5801 7005   16 413 162 412 189 412 161 412 247 412 276 413 240 412 297 412 5 415 3 406 30 404 41 404 43 404 71 404 93 404 111 404 90 404 10 407 92 406 29961 7909 3917 6749 12 855 4 402 16 402 0 399 0 399 85 9 401 401 3667 405 6232 405   0   0   0   0 0 1 2238 405 3868 405
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

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