hospitals_state

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

34 rows where previous_day_admission_pediatric_covid_confirmed_5_11 = 11 sorted by adult_icu_bed_utilization

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: critical_staffing_shortage_today_yes, critical_staffing_shortage_anticipated_within_week_yes, hospital_onset_covid_coverage, previous_day_admission_adult_covid_confirmed_coverage, staffed_icu_adult_patients_confirmed_and_suspected_covid_coverage, total_adult_patients_hospitalized_confirmed_covid_coverage, previous_day_admission_adult_covid_confirmed_18-19_coverage, previous_day_admission_adult_covid_confirmed_20-29, previous_day_admission_adult_covid_confirmed_30-39_coverage, previous_day_admission_adult_covid_confirmed_40-49, previous_day_admission_adult_covid_confirmed_50-59_coverage, previous_day_admission_adult_covid_confirmed_70-79, previous_day_admission_adult_covid_confirmed_unknown, previous_day_admission_adult_covid_suspected_30-39, previous_day_admission_adult_covid_suspected_40-49_coverage, previous_day_admission_adult_covid_suspected_60-69, previous_day_admission_adult_covid_suspected_70-79_coverage, previous_day_admission_adult_covid_suspected_unknown_coverage, deaths_covid, on_hand_supply_therapeutic_a_casirivimab_imdevimab_courses, icu_patients_confirmed_influenza, previous_day_deaths_covid_and_influenza, previous_day_deaths_influenza_coverage, all_pediatric_inpatient_beds_coverage, previous_day_admission_pediatric_covid_confirmed_0_4_coverage, previous_day_admission_pediatric_covid_confirmed_5_11_coverage, previous_day_admission_pediatric_covid_confirmed_unknown_coverage, 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
26811 26811 CA 2022/08/02 6 94 276 111 227 38 108 368 61731 376 47911 376 4991 368 646 376 306 368 30 368 9 368 4728 376 522 368 518 376 4844 368 4524 376 147 368 139 367 6630 376 0.776125447506115 376 47911 61731 0.105419905373437 368 4991 47344 0.081837112827324 368 4991 60987 0.080592867068087 368 522 6477 0.713122171945701 376 4728 6630   4 374 36 371 64 371 43 371 61 372 119 372 147 371 172 372 1 374 4 368 24 364 29 364 32 364 37 364 64 364 50 364 65 364 1 368 13 107 8022 1100 3144 305 0 0 6 368 5 368 0 339 0 339 41 2 339 368 2128 368 3571 368 11 368 8 364 11 361 0 365 39 367 626 368 947 368
29418 29418 FL 2022/08/30 8 161 73 34 149 59 107 236 55310 242 43217 242 3205 236 495 242 220 236 35 236 25 236 4626 242 340 236 322 242 3092 236 2836 242 113 236 87 236 6484 242 0.781359609473874 242 43217 55310 0.075201201342124 236 3205 42619 0.058686735516004 236 3205 54612 0.05346752634062 236 340 6359 0.713448488587292 242 4626 6484   6 237 19 230 41 229 48 230 51 232 71 230 96 231 136 233 28 242 3 234 14 223 14 223 21 224 31 223 42 223 55 223 39 224 1 236 14 132 4016 0 1084 1058 0 95 4 236 10 236 0 131 0 131 64 7 134 236 1931 236 2668 236 12 236 19 223 11 223 2 234 17 236 670 236 896 236
30460 30460 CA 2022/08/09 8 97 275 114 226 40 96 372 61762 380 47930 380 4469 371 612 380 277 372 37 372 12 371 4762 379 495 371 479 379 4298 371 4025 379 171 371 152 370 6671 379 0.776043521906674 380 47930 61762 0.094430122976799 371 4469 47326 0.073264697203187 371 4469 60998 0.076013513513514 371 495 6512 0.713836006595713 379 4762 6671   2 376 45 373 59 373 43 372 76 373 108 373 115 374 165 374 4 376 2 371 16 365 26 364 27 365 40 365 61 365 50 365 54 365 1 371 10 109 8037 959 3131 305 0 1 4 370 3 370 0 338 0 338 29 4 338 370 2258 372 3591 372 22 369 4 367 11 361 0 367 30 370 606 371 952 371
27124 27124 CA 2022/07/22 8 127 277 118 256 38 126 404 64308 412 50443 412 5045 404 726 412 316 404 36 403 14 403 4796 412 521 404 506 412 4843 404 4584 412 202 404 187 403 6603 412 0.784396964607825 412 50443 64308 0.101225947551115 404 5045 49839 0.079373820012587 404 5045 63560 0.080850403476102 404 521 6444 0.726336513705891 412 4796 6603   6 410 50 400 79 400 58 400 94 399 113 400 146 398 179 399 3 410 3 403 13 392 39 392 34 392 43 392 73 392 66 390 45 391 0 404 14 122 8035 1100 3134 364 0 0 15 404 4 404 1 351 1 351 55 10 351 404 2395 403 3775 403 19 402 5 392 11 389 1 400 31 402 636 403 965 403
25510 25510 CA 2022/07/28 7 127 276 118 254 38 376 402 64620 410 50993 410 5086 402 679 410 322 402 31 400 9 401 4927 410 555 402 529 410 4924 402 4648 410 162 402 151 401 6723 410 0.789121015165583 410 50993 64620 0.100968792186135 402 5086 50372 0.079639227721842 402 5086 63863 0.084655277608298 402 555 6556 0.732857355347315 410 4927 6723   3 409 55 398 65 398 59 398 77 398 122 398 135 397 162 398 3 409 0 401 32 390 40 390 26 390 49 390 46 390 68 389 57 389 4 402 13 124 7975 1100 3035 305 0 0 12 402 6 402 3 351 3 351 44 6 351 402 2411 401 3768 401 13 400 7 389 11 386 0 398 39 400 654 401 974 401
33345 33345 FL 2022/07/15 8 186 75 37 171 61 147 263 60067 269 46909 269 4373 263 756 269 233 263 61 263 49 263 4790 269 442 263 422 269 4266 263 3994 269 107 263 96 263 6516 269 0.780944611850101 269 46909 60067 0.09439419776804 263 4373 46327 0.073625726071218 263 4373 59395 0.069008587041374 263 442 6405 0.735113566605279 269 4790 6516   5 264 31 252 53 252 49 253 86 252 131 249 163 253 203 255 35 269 1 263 12 245 12 245 26 245 30 245 61 244 43 245 36 245 12 263 31 150 4580 0 2669 1184 0 143 5 263 25 263 0 142 0 142 112 8 145 263 1909 263 2828 263 15 263 8 244 11 244 33 261 27 263 688 263 904 263
31801 31801 FL 2022/06/14 7 157 75 35 143 61 124 233 55654 239 43839 239 3475 233 597 239 237 233 34 233 16 233 4815 239 348 233 344 239 3391 233 3133 239 84 233 72 233 6527 239 0.787706184640816 239 43839 55654 0.080577841673237 233 3475 43126 0.063425140082863 233 3475 54789 0.054639660857277 233 348 6369 0.737704918032787 239 4815 6527   1 235 21 230 45 230 34 229 76 229 99 230 133 230 177 232 14 239 4 231 19 223 23 222 27 224 34 223 50 223 38 223 33 224 9 233 17 134 4065 0 2696 1219 0 353 25 233 81 233 0 126 0 126 304 13 129 233 1744 233 2604 233 12 233 10 221 11 224 1 231 18 233 666 233 920 233
26820 26820 FL 2022/06/24 10 184 75 36 172 61 118 263 60276 269 46880 269 3635 263 614 269 187 263 61 263 47 263 4865 269 349 263 335 269 3549 263 3272 269 86 263 68 263 6552 269 0.777755657309709 269 46880 60276 0.078674544942969 263 3635 46203 0.0611571916483 263 3635 59437 0.05453125 263 349 6400 0.742521367521368 269 4865 6552   4 260 35 258 34 256 48 258 64 259 109 261 115 258 183 262 21 269 2 259 8 251 17 250 16 252 34 250 37 250 28 252 34 251 11 263 22 151 4125 0 2650 1184 0 193 30 263 53 263 0 140 0 140 213 18 143 263 1956 263 2886 263 11 263 7 250 11 250 32 261 15 263 703 263 908 263
42539 42539 FL 2022/02/14 8 162 72 39 142 61 184 236 56899 242 45301 242 5374 236 555 242 200 236 48 236 30 236 5108 242 898 236 880 242 5234 236 4922 242 140 236 117 236 6625 242 0.796165134712385 242 45301 56899 0.120501379016526 236 5374 44597 0.096014007253756 236 5374 55971 0.139009287925697 236 898 6460 0.771018867924528 242 5108 6625   4 237 31 232 23 232 31 231 78 231 98 233 131 233 130 232 29 242 2 236 15 225 24 224 16 224 37 224 26 224 36 224 34 223 10 236 48 132 4133 69 3637 1448 237 318 7 236 10 236 0 124 0 124 70 9 124 236 1628 236 2610 236 14 235 17 225 11 224 6 236 18 236 577 236 848 236
36269 36269 CA 2022/02/19 9 140 266 128 252 35 123 407 66324 415 51643 415 6606 407 614 415 376 407 34 399 13 404 5484 415 1214 407 1195 415 6396 407 5995 415 194 407 180 406 7057 415 0.778647246848803 415 51643 66324 0.129392408038547 407 6606 51054 0.10078418210112 407 6606 65546 0.176120702161613 407 1214 6893 0.777100751027349 415 5484 7057   7 411 46 402 66 401 59 401 68 401 112 399 122 399 132 398 2 412 4 404 31 394 42 393 23 393 50 393 78 393 66 393 82 392 0 406 34 129 8615 782 3338 311 0 17 3 407 1 407 0 346 0 346 43 1 346 407 2437 404 3738 404 14 397 9 389 11 388 0 398 41 403 651 404 931 404
45730 45730 FL 2022/02/12 9 190 72 40 170 61 190 265 60568 271 47543 271 5588 265 762 271 259 265 80 265 19 265 5266 271 916 265 911 271 5441 265 5112 271 147 265 128 265 6616 271 0.784952450138687 271 47543 60568 0.119320122992825 265 5588 46832 0.093697077415785 265 5588 59639 0.141993489381491 265 916 6451 0.795949214026602 271 5266 6616   2 265 47 259 36 259 47 261 108 262 131 263 172 259 188 259 31 271 3 265 9 253 26 253 19 252 35 252 46 251 55 252 58 251 8 265 38 147 3819 53 3167 1448 237 318 7 265 10 265 0 138 0 138 70 9 138 265 1832 265 2829 265 19 264 20 255 11 253 30 265 26 265 594 265 865 265
35720 35720 FL 2022/02/06 9 190 72 40 170 61 248 265 60412 271 46901 271 7299 265 868 271 269 265 51 265 21 265 5241 271 1145 265 1143 271 7133 265 6770 271 166 265 146 265 6574 271 0.77635238032179 271 46901 60412 0.158123916811092 265 7299 46160 0.12268257836793 265 7299 59495 0.178655016383211 265 1145 6409 0.797231518101612 271 5241 6574   8 262 36 256 59 257 56 259 90 257 173 260 184 260 216 260 46 271 2 260 13 249 24 250 35 250 34 250 52 251 52 251 50 251 7 265 46 153 3993 69 3281 1582 237 318 7 265 10 265 1 135 1 135 78 7 135 265 1764 265 2841 265 18 264 20 251 11 251 2 265 61 264 578 265 871 265
37998 37998 FL 2022/02/17 10 191 70 41 171 59 171 265 60842 271 49149 271 4598 265 527 271 228 265 68 265 50 265 5286 271 760 265 741 271 4482 265 4105 271 116 265 98 265 6614 271 0.807813681338549 271 49149 60842 0.095001962850472 265 4598 48399 0.076712603023124 265 4598 59938 0.117847728329974 265 760 6449 0.799213788932567 271 5286 6614   1 265 25 255 30 255 36 256 64 257 102 258 125 256 111 257 33 271 3 264 16 250 22 249 22 249 25 249 44 249 47 249 39 248 10 265 27 150 4033 69 3325 1447 237 318 7 265 8 265 1 139 1 139 60 6 139 265 2001 265 2855 265 9 264 15 251 11 251 33 265 32 265 634 265 906 265
45383 45383 CA 2022/02/09 15 125 273 154 226 33 125 405 67303 413 54694 413 10261 405 1190 413 455 405 58 398 18 402 5974 413 1897 405 1889 413 9929 405 9592 413 316 405 293 404 7380 413 0.812653224967683 413 54694 67303 0.189839225916264 405 10261 54051 0.154263635816946 405 10261 66516 0.26314329310584 405 1897 7209 0.809485094850948 413 5974 7380   11 410 90 402 107 402 86 402 154 401 237 401 240 399 262 401 5 409 1 402 25 394 35 394 28 394 77 394 104 394 109 393 76 393 0 405 54 131 10901 1575 4524 352 0 50 3 405 7 405 0 356 1 356 49 4 356 405 2374 402 3671 402 27 396 20 391 11 390 0 397 57 401 674 402 948 402
39008 39008 FL 2022/02/10 9 190 72 39 171 61 219 265 61174 271 49656 271 6288 265 822 271 249 265 85 265 20 265 5404 271 999 265 992 271 6123 265 5797 271 165 265 150 265 6636 271 0.811717396279465 271 49656 61174 0.128607367107766 265 6288 48893 0.104363413055385 265 6288 60251 0.154381084840056 265 999 6471 0.814345991561182 271 5404 6636   5 264 39 258 49 257 62 258 84 258 173 261 207 260 162 257 41 271 1 263 12 252 27 251 26 250 45 250 45 250 44 251 42 250 7 265 41 150 3787 69 3141 1448 237 318 6 265 9 265 0 138 0 138 74 9 139 265 2011 265 2860 265 20 263 18 253 11 251 36 265 33 265 726 265 1032 265
44574 44574 NV 2022/02/22 0 2 56 0 2 56 60 56 8353 58 6708 58 649 56 58 58 99 56 4 56 17 56 670 58 133 56 116 58 611 56 531 58 38 56 8 56 818 58 0.803064767149527 58 6708 8353 0.098692214111922 56 649 6576 0.079165650158575 56 649 8198 0.169859514687101 56 133 783 0.819070904645477 58 670 818   0 58 1 58 3 58 5 58 13 58 15 58 12 58 9 58 0 58 0 56 6 56 6 56 9 56 16 56 20 56 17 56 25 56 0 56 0 2 330 0 705 0 0 0 0 56 0 56 0 2 0 2 5 1 2 56 401 56 537 56 10 56 0 56 11 56 0 56 7 56 85 56 115 56
42370 42370 CA 2022/01/30 17 130 269 152 227 37 234 408 66995 416 52785 416 14070 408 1415 416 418 408 58 399 20 407 6012 416 2495 408 2495 416 13677 408 13346 416 393 408 358 407 7280 416 0.787894619001418 416 52785 66995 0.269504089489915 408 14070 52207 0.212518502854726 408 14070 66206 0.351260030972828 408 2495 7103 0.825824175824176 416 6012 7280   23 410 123 401 145 399 119 400 180 398 275 397 263 397 282 398 5 407 6 404 29 394 31 392 39 391 65 390 78 390 86 389 84 390 0 408 49 150 8839 891 3490 394 0 16 5 402 6 402 6 364 6 364 44 9 363 402 829 119 3400 343 18 330 26 330 11 330 3 355 78 340 564 342 848 342
45587 45587 FL 2022/02/01 11 160 71 39 143 60 270 236 56689 242 46671 242 8636 236 1277 242 258 236 66 236 21 236 5504 242 1326 236 1331 242 8448 236 8181 242 188 236 174 236 6632 242 0.823281412619732 242 46671 56689 0.188221960681749 236 8636 45882 0.154847501389611 236 8636 55771 0.205009276437848 236 1326 6468 0.829915560916767 242 5504 6632   11 233 63 231 79 231 104 230 158 232 211 233 313 235 268 234 70 242 2 230 8 223 23 222 26 222 31 223 45 223 49 224 58 224 16 236 59 137 3988 146 3022 1930 237 461 12 228 9 228 1 125 1 125 80 13 125 233 1355 193 1857 192 15 192 22 187 11 187 18 220 31 190 445 190 655 192
43420 43420 CA 2022/01/20 34 152 230 162 215 39 180 408 67609 416 55207 416 16147 407 2172 416 495 408 82 390 27 404 6271 415 2490 407 2481 415 15655 407 15320 415 492 407 452 406 7486 415 0.816562883639752 416 55207 67609 0.296019946101527 407 16147 54547 0.241623894533647 407 16147 66827 0.341002465078061 407 2490 7302 0.837697034464333 415 6271 7486   14 411 169 402 216 404 193 402 296 402 435 402 405 401 434 402 8 402 8 403 39 393 50 394 58 394 67 393 90 393 92 393 91 393 0 406 46 145 8951 897 4081 713 0 130 9 400 10 400 1 364 1 365 60 9 365 400 671 75 2996 272 34 268 25 269 11 268 12 307 74 292 554 296 755 296
44896 44896 CA 2022/01/21 35 146 235 165 213 38 241 408 67653 416 55191 416 16182 407 2207 416 475 408 85 390 33 404 6202 415 2492 407 2526 415 15661 407 15333 415 521 407 469 406 7396 415 0.815795308412044 416 55191 67653 0.296917431192661 407 16182 54500 0.242017259171739 407 16182 66863 0.345247991133278 407 2492 7218 0.83856138453218 415 6202 7396   19 411 190 400 274 403 210 401 302 401 396 400 410 400 397 401 7 401 3 403 23 393 53 394 52 393 74 393 76 393 93 393 100 392 1 407 65 154 8874 809 4100 714 0 132 7 401 10 401 0 367 0 368 64 10 368 401 812 83 3146 299 33 285 23 286 11 285 20 308 83 296 565 299 768 299
22283 22283 TX 2022/07/05 5 82 416 9 78 416 100 498 57633 503 43078 503 3187 498 490 503 181 498 36 498 72 498 4900 503 431 498 394 503 3009 498 2732 503 178 498 112 498 5803 503 0.747453715753128 503 43078 57633 0.074963541421649 498 3187 42514 0.056016451646922 498 3187 56894 0.0761349584879 498 431 5661 0.844390832328106 503 4900 5803   3 501 39 499 21 498 37 498 59 498 90 498 114 498 113 498 20 503 2 496 10 493 22 493 30 494 29 493 34 493 30 493 22 493 2 498 19 491 328 0 85 0 0 0 3 498 12 498 0 90 0 90 76 10 90 498 3242 498 3875 498 17 496 8 493 11 493 0 498 23 498 894 498 1081 498
30194 30194 TX 2022/07/02 5 105 485 9 101 485 135 590 64461 595 48229 595 2974 590 462 595 235 590 54 590 62 590 5037 595 397 590 352 595 2758 590 2420 595 216 590 146 590 5877 595 0.748188827352973 595 48229 64461 0.062367620845129 590 2974 47685 0.046673676611372 590 2974 63719 0.069211994421199 590 397 5736 0.857069933639612 595 5037 5877   1 593 32 590 27 590 35 590 54 590 81 590 119 590 90 590 30 595 4 588 21 585 15 585 21 585 25 585 46 585 54 585 44 585 5 590 16 581 356 0 114 0 0 0 6 590 11 590 0 101 0 101 101 8 101 590 3785 590 4336 590 31 588 12 584 11 584 0 590 30 590 918 590 1075 590
33324 33324 TX 2022/07/24 6 105 483 10 101 483 131 589 63171 594 47834 594 4002 589 531 594 291 589 37 589 59 589 5070 594 599 589 553 594 3767 589 3443 594 235 589 171 589 5874 594 0.757214544648652 594 47834 63171 0.084658994753765 589 4002 47272 0.064088397790055 589 4002 62445 0.104464597139867 589 599 5734 0.863125638406537 594 5070 5874   3 592 37 589 43 589 42 588 56 588 94 588 122 588 128 589 32 594 3 587 19 583 23 583 24 583 27 583 37 583 59 583 50 583 49 589 17 581 346 0 35 0 0 0 2 589 8 589 0 104 0 104 83 10 104 589 3630 589 4241 589 33 587 4 582 11 582 0 589 32 589 939 589 1110 589
27893 27893 TX 2022/07/16 6 107 482 11 102 482 150 590 64396 595 49210 595 3726 590 595 595 262 590 46 590 72 590 5229 595 539 590 491 595 3456 590 3149 595 254 590 174 590 6006 595 0.7641778992484 595 49210 64396 0.076663511789638 590 3726 48602 0.058521415445507 590 3726 63669 0.091869780126129 590 539 5867 0.870629370629371 595 5229 6006   3 593 35 589 42 589 54 589 76 589 124 589 118 589 132 589 26 595 0 588 22 584 25 584 18 585 31 584 57 584 63 584 42 584 4 590 28 580 353 0 114 0 0 0 5 590 24 590 0 105 0 105 103 9 105 590 3732 590 4320 590 34 588 9 583 11 584 0 590 24 590 918 590 1065 590
29367 29367 TX 2022/07/07 6 106 482 9 103 482 142 589 65537 594 50099 594 3440 589 669 594 301 589 51 589 89 589 5250 594 452 589 413 594 3211 589 2903 594 229 589 146 589 6002 594 0.764438408837756 594 50099 65537 0.069539904584782 589 3440 49468 0.053092974441289 589 3440 64792 0.077119945401809 589 452 5861 0.874708430523159 594 5250 6002   7 592 50 588 49 588 54 587 89 588 112 587 128 588 124 588 68 594 4 587 12 583 33 584 30 584 34 583 49 583 57 581 39 582 43 589 11 582 356 1 114 0 0 0 3 589 13 589 0 105 0 105 80 8 105 589 3829 589 4417 589 23 587 17 582 11 582 0 589 33 589 922 589 1086 589
25877 25877 TX 2022/08/19 6 95 485 10 91 485 129 581 64758 586 50101 586 3389 581 411 586 284 581 31 581 87 581 5273 586 495 581 465 586 3148 581 2848 586 241 581 153 581 6007 586 0.773665029803268 586 50101 64758 0.068467412824761 581 3389 49498 0.05292748824788 581 3389 64031 0.084398976982097 581 495 5865 0.877809222573664 586 5273 6007   6 584 35 581 45 580 23 580 66 580 73 580 104 580 86 580 13 586 3 579 23 576 23 576 29 576 41 575 65 575 51 575 46 575 3 581 18 574 349 0 114 0 0 0 9 581 16 581 0 98 0 98 86 9 98 581 3756 581 4340 581 21 579 8 574 11 575 0 581 29 581 899 581 1066 581
32150 32150 TX 2022/08/30 6 77 415 8 75 415 102 493 59074 498 46656 498 3068 493 427 498 286 493 46 493 95 493 5325 498 404 493 361 498 2817 493 2532 498 251 493 165 493 6057 498 0.789789078105427 498 46656 59074 0.06665797592665 493 3068 46026 0.052581065332145 493 3068 58348 0.068266306184522 493 404 5918 0.879148093115404 498 5325 6057   4 497 39 494 25 493 37 493 58 493 69 493 94 493 99 493 13 498 3 492 23 489 34 488 31 488 39 488 61 488 54 488 39 488 2 493 16 490 321 0 85 0 0 0 9 493 14 493 0 92 1 92 101 7 92 493 3773 493 4225 493 30 492 14 488 11 489 0 493 31 493 954 493 1070 493
33426 33426 TX 2022/06/23 6 106 482 8 104 482 119 589 65488 594 50591 594 2425 589 401 594 280 589 32 589 72 589 5319 594 320 589 284 594 2223 589 1934 594 202 589 116 589 6049 594 0.77252321035915 594 50591 65488 0.048525233121223 589 2425 49974 0.037454051215519 589 2425 64746 0.054191363251482 589 320 5905 0.879318895685237 594 5319 6049   1 592 30 589 37 589 41 589 40 589 58 589 101 589 70 589 30 594 5 587 20 584 33 584 30 585 39 585 54 584 50 584 44 584 5 589 12 582 346 0 35 0 0 0 12 589 22 589 0 105 0 105 119 11 105 589 3850 589 4393 589 17 587 4 582 11 583 0 589 23 589 964 589 1092 589
26100 26100 TX 2022/06/28 7 79 416 9 77 416 109 497 59068 502 45871 502 2756 497 419 502 283 497 49 497 69 497 5220 502 398 497 354 502 2547 497 2261 502 209 497 131 497 5930 502 0.776579535450667 502 45871 59068 0.06093166191329 497 2756 45231 0.047242744741759 497 2756 58337 0.068762957843815 497 398 5788 0.88026981450253 502 5220 5930   5 500 43 497 32 497 31 497 48 497 76 497 80 497 96 497 19 502 4 495 22 492 27 492 24 492 45 492 56 492 63 492 37 492 5 497 14 491 328 0 85 0 0 0 9 497 12 497 0 91 0 91 97 12 91 497 3438 497 3943 497 23 495 15 492 11 492 0 497 27 497 879 497 1018 497
29050 29050 TX 2022/08/09 7 78 416 9 76 416 110 496 58641 501 45903 501 3724 496 551 501 246 496 45 496 88 496 5205 501 514 496 477 501 3458 496 3172 501 266 496 182 496 5894 501 0.782779966235228 501 45903 58641 0.082243816254417 496 3724 45280 0.06430668278363 496 3724 57910 0.089313640312772 496 514 5755 0.88310145911096 501 5205 5894   2 499 36 495 38 495 40 495 64 495 110 495 141 495 128 495 24 501 1 494 20 490 15 490 19 491 37 490 52 490 49 490 43 490 10 496 21 492 321 0 85 0 0 0 9 496 10 496 0 90 0 91 80 7 91 496 3347 496 4008 496 28 494 16 490 11 490 0 496 36 496 886 496 1077 496
22523 22523 TX 2022/06/29 7 107 481 9 105 481 139 590 64887 595 49919 595 2839 590 486 595 263 590 57 590 80 590 5328 595 394 590 360 595 2617 590 2330 595 212 590 136 590 6020 595 0.769322052183026 595 49919 64887 0.057597890038547 590 2839 49290 0.04425220169901 590 2839 64155 0.067018200374213 590 394 5879 0.885049833887043 595 5328 6020   2 595 39 593 39 593 30 593 63 593 68 593 111 593 114 593 31 595 2 590 20 588 23 588 26 588 39 588 49 588 51 588 44 588 9 590 18 583 2449 660 733 0 0 0 6 590 14 590 0 103 1 103 39 12 103 590 3752 590 4267 590 28 589 18 587 11 588 0 590 31 590 886 590 1017 590
23922 23922 TX 2022/08/11 7 106 479 9 104 479 123 587 65078 592 50112 592 3615 587 530 592 325 587 33 587 78 587 5329 592 513 587 466 592 3377 587 3058 592 238 587 177 587 5980 592 0.770029810381388 592 50112 65078 0.073048011639185 587 3615 49488 0.056174537317608 587 3615 64353 0.087782340862423 587 513 5844 0.891137123745819 592 5329 5980   4 589 35 586 39 585 33 585 57 585 108 585 118 586 98 585 64 592 4 584 17 581 24 580 28 581 42 580 61 580 61 581 37 580 51 587 20 579 425 0 148 0 0 0 8 587 15 587 0 103 1 103 77 8 103 587 3686 587 4294 587 23 585 9 580 11 581 0 587 30 587 906 587 1085 587
24515 24515 TX 2022/08/17 7 95 484 9 93 484 126 581 64381 586 50286 586 3500 581 462 586 265 581 33 581 75 581 5407 586 535 581 477 586 3285 581 2955 586 215 581 152 581 5998 586 0.781068948913499 586 50286 64381 0.070484936362172 581 3500 49656 0.054987352908831 581 3500 63651 0.091343691309544 581 535 5857 0.901467155718573 586 5407 5998   2 586 47 583 30 583 28 583 50 583 83 583 111 583 119 583 19 586 2 581 20 578 21 578 25 578 35 578 56 578 62 578 39 578 5 581 29 578 1942 660 711 0 0 0 7 581 15 581 0 100 0 100 50 9 100 581 3706 581 4279 581 23 581 12 577 11 577 0 581 22 581 873 581 1045 581
46438 46438 TX 2022/02/25 10 109 475 11 108 475 105 589 66954 594 52028 594 4559 589 364 594 271 589 33 589 97 589 5907 594 1050 589 1021 594 4341 589 3897 594 218 589 166 589 6527 594 0.777070824745348 594 52028 66954 0.088618913402663 589 4559 51445 0.068864988973143 589 4559 66202 0.164938737040528 589 1050 6366 0.905009958633369 594 5907 6527   5 590 19 587 31 588 34 588 47 588 75 588 74 588 61 588 18 594 5 586 23 582 25 583 34 584 33 584 50 583 49 582 50 583 2 589 51 582 314 0 114 12 0 6 26 589 38 589 0 110 0 110 182 5 110 589 3843 589 4373 589 11 586 11 582 11 581 0 589 29 588 972 589 1108 589

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