hhs-hospital-icu-totals
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- hospital
- The name of the hospital
- ccn
- The unique indentifier of the hospital.
- week
- The week for which hospital data were reported in ISO 8601 format.
- county
- The county where the hospitals is located.
- fips
- The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
- region
- The region of the state where the hospital is located.
- covid_icu_patients_total
- The daily average of COVID-19 patients in the adult ICU at the hospital over the past seven days.
- available_adult_icu_beds_total
- The daily average of available adult ICU beds at the hospital over the past seven days.
- occupied_adult_icu_beds_total
- The daily average of occupied adult ICU beds at the hospital over the past seven days.
- staffed_adult_icu_beds_total
- The daily average of staffed adult ICU beds at the hospital over the past seven days.
- occupied_adult_icu_beds_percent
- The daily average of occupied adult ICU beds over the past seven days, measured as a percentage of the hospital's total.
- icu_patients_with_covid_percent
- The daily average of of adult ICU patients with COVID-19 over the past seven days, measured as a percentage of the hospital's total.
307 rows where "week" is on date 2021-09-10 sorted by rowid descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region
Link | rowid ▲ | hospital | ccn | week | county | fips | region | covid_icu_patients_total | available_adult_icu_beds_total | occupied_adult_icu_beds_total | staffed_adult_icu_beds_total | occupied_adult_icu_beds_percent | icu_patients_with_covid_percent |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20504 | 20504 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-09-10 | San Francisco | 75 | Bay Area | 4.714285714285714 | 10.0 | 28.0 | 38.0 | 0.7368421052631579 | 0.1683673469387755 |
20503 | 20503 | Woodland Memorial Hospital | 50127 | 2021-09-10 | Yolo | 113 | Greater Sacramento | 4.285714285714286 | 0.1428571428571441 | 8.714285714285714 | 8.857142857142858 | 0.9838709677419354 | 0.4918032786885246 |
20502 | 20502 | Whittier Hospital Medical Center | 50735 | 2021-09-10 | Los Angeles | 37 | Southern California | 5.428571428571429 | 5.285714285714287 | 10.714285714285714 | 16.0 | 0.6696428571428571 | 0.5066666666666667 |
20501 | 20501 | White Memorial Medical Center | 50103 | 2021-09-10 | Los Angeles | 37 | Southern California | 4.142857142857143 | 1.7142857142857135 | 14.285714285714286 | 16.0 | 0.8928571428571429 | 0.29 |
20500 | 20500 | West Hills Hospital & Medical Center | 50481 | 2021-09-10 | Los Angeles | 37 | Southern California | 4.142857142857143 | 15.0 | 18.0 | 33.0 | 0.5454545454545454 | 0.2301587301587301 |
20499 | 20499 | West Anaheim Medical Center | 50426 | 2021-09-10 | Orange | 59 | Southern California | 3.7142857142857135 | 0.0 | 15.0 | 15.0 | 1.0 | 0.2476190476190476 |
20498 | 20498 | Watsonville Community Hospital | 50194 | 2021-09-10 | Santa Cruz | 87 | Bay Area | 0.0 | 3.0 | 3.0 | 6.0 | 0.5 | 0.0 |
20497 | 20497 | Washington Hospital | 50195 | 2021-09-10 | Alameda | 1 | Bay Area | 8.0 | 8.428571428571427 | 19.571428571428573 | 28.0 | 0.6989795918367347 | 0.4087591240875912 |
20496 | 20496 | Victor Valley Global Medical Center | 50517 | 2021-09-10 | San Bernardino | 71 | Southern California | 3.142857142857143 | 1.0 | 9.0 | 10.0 | 0.9 | 0.3492063492063492 |
20495 | 20495 | Vibra Hospital of Sacramento | 52033 | 2021-09-10 | Sacramento | 67 | Greater Sacramento | 0.0 | 1.0 | 5.0 | 6.0 | 0.8333333333333334 | 0.0 |
20494 | 20494 | Ventura County Medical Center | 50159 | 2021-09-10 | Ventura | 111 | Southern California | 1.4285714285714286 | 9.571428571428571 | 6.428571428571429 | 16.0 | 0.4017857142857143 | 0.2222222222222222 |
20493 | 20493 | Valley Presbyterian Hospital | 50126 | 2021-09-10 | Los Angeles | 37 | Southern California | 4.0 | 11.571428571428571 | 8.428571428571429 | 20.0 | 0.4214285714285714 | 0.4745762711864407 |
20492 | 20492 | Valley Children's Hospital | 53300 | 2021-09-10 | Fresno | 19 | San Joaquin Valley | 1.4285714285714286 | 0.0 | 6.142857142857143 | 6.142857142857143 | 1.0 | 0.2325581395348837 |
20491 | 20491 | University of California Irvine Medical Center | 50348 | 2021-09-10 | Orange | 59 | Southern California | 11.285714285714286 | 5.857142857142854 | 62.142857142857146 | 68.0 | 0.9138655462184876 | 0.1816091954022988 |
20490 | 20490 | University of California Davis Medical Center | 50599 | 2021-09-10 | Sacramento | 67 | Greater Sacramento | 13.857142857142858 | 4.428571428571431 | 79.57142857142857 | 84.0 | 0.9472789115646258 | 0.1741472172351885 |
20489 | 20489 | Uc San Diego Health Hillcrest - Hillcrest Medical Center | 50025 | 2021-09-10 | San Diego | 73 | Southern California | 24.285714285714285 | 10.14285714285714 | 91.0 | 101.14285714285714 | 0.8997175141242938 | 0.2668759811616954 |
20488 | 20488 | USC Verdugo Hills Hospital | 50124 | 2021-09-10 | Los Angeles | 37 | Southern California | 0.0 | 7.142857142857143 | 6.857142857142857 | 14.0 | 0.4897959183673469 | 0.0 |
20487 | 20487 | USC Kenneth Norris Jr Cancer Hospital | 50660 | 2021-09-10 | Los Angeles | 37 | Southern California | 0.0 | 0.7142857142857142 | 1.2857142857142858 | 2.0 | 0.6428571428571429 | 0.0 |
20486 | 20486 | USC Arcadia Hospital | 50238 | 2021-09-10 | Los Angeles | 37 | Southern California | 0.0 | 1.0 | 12.571428571428571 | 13.571428571428571 | 0.9263157894736842 | 0.0 |
20485 | 20485 | UCSF Medical Center | 50454 | 2021-09-10 | San Francisco | 75 | Bay Area | 8.714285714285714 | 22.28571428571429 | 79.71428571428571 | 102.0 | 0.7815126050420167 | 0.1093189964157706 |
20484 | 20484 | Tri-city Medical Center | 50128 | 2021-09-10 | San Diego | 73 | Southern California | 6.857142857142857 | 9.142857142857142 | 15.857142857142858 | 25.0 | 0.6342857142857143 | 0.4324324324324324 |
20483 | 20483 | Torrance Memorial Medical Center | 50351 | 2021-09-10 | Los Angeles | 37 | Southern California | 9.428571428571429 | 10.42857142857143 | 37.57142857142857 | 48.0 | 0.7827380952380952 | 0.2509505703422053 |
20482 | 20482 | Tenet Health Central Twin Cities Community Hosp | 50633 | 2021-09-10 | San Luis Obispo | 79 | Southern California | 4.428571428571429 | 4.571428571428571 | 5.428571428571429 | 10.0 | 0.5428571428571429 | 0.8157894736842105 |
20481 | 20481 | Tenet Health Central Coast Sierra Vista Rmc | 50506 | 2021-09-10 | San Luis Obispo | 79 | Southern California | 2.142857142857143 | 5.142857142857142 | 11.857142857142858 | 17.0 | 0.6974789915966387 | 0.180722891566265 |
20480 | 20480 | Temecula Valley Hospital | 50775 | 2021-09-10 | Riverside | 65 | Southern California | 7.285714285714286 | 1.0 | 17.857142857142858 | 18.857142857142858 | 0.946969696969697 | 0.408 |
20479 | 20479 | Tahoe Forest Hospital | 51328 | 2021-09-10 | Nevada | 57 | Greater Sacramento | 2.0 | 0.2857142857142856 | 5.714285714285714 | 6.0 | 0.9523809523809524 | 0.35 |
20478 | 20478 | Sutter Tracy Community Hospital | 50313 | 2021-09-10 | San Joaquin | 77 | San Joaquin Valley | 2.7142857142857144 | 2.1428571428571432 | 5.857142857142857 | 8.0 | 0.7321428571428571 | 0.4634146341463415 |
20477 | 20477 | Sutter Solano Medical Center | 50101 | 2021-09-10 | Solano | 95 | Bay Area | 8.0 | 0.2857142857142865 | 11.714285714285714 | 12.0 | 0.9761904761904762 | 0.6829268292682927 |
20476 | 20476 | Sutter Santa Rosa Regional Hospital | 50291 | 2021-09-10 | Sonoma | 97 | Bay Area | 3.571428571428572 | 1.2857142857142865 | 10.714285714285714 | 12.0 | 0.8928571428571428 | 0.3333333333333333 |
20475 | 20475 | Sutter Roseville Medical Center | 50309 | 2021-09-10 | Placer | 61 | Greater Sacramento | 20.428571428571427 | 8.285714285714285 | 47.71428571428572 | 56.0 | 0.8520408163265306 | 0.4281437125748502 |
20474 | 20474 | Sutter Medical Center, Sacramento | 50108 | 2021-09-10 | Sacramento | 67 | Greater Sacramento | 13.142857142857142 | 6.428571428571431 | 53.57142857142857 | 60.0 | 0.8928571428571428 | 0.2453333333333333 |
20473 | 20473 | Sutter Lakeside Hospital | 51329 | 2021-09-10 | Lake | 33 | Northern California | 2.0 | 0.1428571428571428 | 3.857142857142857 | 4.0 | 0.9642857142857144 | 0.5185185185185185 |
20472 | 20472 | Sutter Delta Medical Center | 50523 | 2021-09-10 | Contra Costa | 13 | Bay Area | 6.714285714285714 | 0.2857142857142865 | 11.714285714285714 | 12.0 | 0.9761904761904762 | 0.5731707317073171 |
20471 | 20471 | Sutter Davis Hospital | 50537 | 2021-09-10 | Yolo | 113 | Greater Sacramento | 3.571428571428572 | 0.5714285714285712 | 5.428571428571429 | 6.0 | 0.9047619047619048 | 0.6578947368421053 |
20470 | 20470 | Sutter Coast Hospital | 50417 | 2021-09-10 | Del Norte | 15 | Northern California | 3.142857142857143 | 0.5714285714285712 | 5.428571428571429 | 6.0 | 0.9047619047619048 | 0.5789473684210525 |
20469 | 20469 | Sutter Auburn Faith Hospital | 50498 | 2021-09-10 | Placer | 61 | Greater Sacramento | 3.7142857142857135 | 2.428571428571429 | 5.571428571428571 | 8.0 | 0.6964285714285714 | 0.6666666666666667 |
20468 | 20468 | Sutter Amador Hospital | 50014 | 2021-09-10 | Amador | 5 | Greater Sacramento | 5.142857142857143 | -0.5 | 8.0 | 7.5 | 1.0666666666666669 | 0.6428571428571429 |
20467 | 20467 | Stanford Health Care - Valleycare | 50283 | 2021-09-10 | Alameda | 1 | Bay Area | 4.0 | 2.7142857142857157 | 19.285714285714285 | 22.0 | 0.8766233766233765 | 0.2074074074074074 |
20466 | 20466 | Stanford Health Care | 50441 | 2021-09-10 | Santa Clara | 85 | Bay Area | 17.0 | 9.285714285714292 | 94.71428571428572 | 104.0 | 0.9107142857142856 | 0.1794871794871795 |
20465 | 20465 | St. Rose Hospital | 50002 | 2021-09-10 | Alameda | 1 | Bay Area | 4.857142857142857 | 2.0 | 11.0 | 13.0 | 0.8461538461538461 | 0.4415584415584415 |
20464 | 20464 | St. Mary's Medical Center | 50457 | 2021-09-10 | San Francisco | 75 | Bay Area | 0.8571428571428571 | 12.285714285714285 | 3.7142857142857135 | 16.0 | 0.2321428571428571 | 0.2307692307692307 |
20463 | 20463 | St. Mary Medical Center | 50191 | 2021-09-10 | Los Angeles | 37 | Southern California | 6.0 | 35.142857142857146 | 22.0 | 57.142857142857146 | 0.3849999999999999 | 0.2727272727272727 |
20462 | 20462 | St. Mary Medical Center | 50300 | 2021-09-10 | San Bernardino | 71 | Southern California | 15.285714285714286 | 0.0 | 21.714285714285715 | 21.714285714285715 | 1.0 | 0.7039473684210527 |
20461 | 20461 | St. Joseph's Medical Center of Stockton | 50084 | 2021-09-10 | San Joaquin | 77 | San Joaquin Valley | 35.714285714285715 | 6.833333333333329 | 37.333333333333336 | 44.16666666666666 | 0.8452830188679247 | 0.9566326530612244 |
20460 | 20460 | St. Johns Regional Medical Center | 50082 | 2021-09-10 | Ventura | 111 | Southern California | 6.428571428571429 | 0.571428571428573 | 21.428571428571427 | 22.0 | 0.974025974025974 | 0.3 |
20459 | 20459 | St. Johns Hospital Camarillo | 50616 | 2021-09-10 | Ventura | 111 | Southern California | 5.0 | 0.1428571428571432 | 6.571428571428571 | 6.714285714285714 | 0.9787234042553192 | 0.7608695652173914 |
20458 | 20458 | St. Elizabeth Community Hospital | 50042 | 2021-09-10 | Tehama | 103 | Northern California | 7.0 | 0.2857142857142856 | 7.714285714285714 | 8.0 | 0.9642857142857144 | 0.9074074074074074 |
20457 | 20457 | St. Bernardine Medical Center | 50129 | 2021-09-10 | San Bernardino | 71 | Southern California | 7.857142857142857 | 43.42857142857143 | 21.571428571428573 | 65.0 | 0.3318681318681319 | 0.3642384105960264 |
20456 | 20456 | Southwest Healthcare System | 50701 | 2021-09-10 | Riverside | 65 | Southern California | 15.285714285714286 | 0.571428571428573 | 25.285714285714285 | 25.857142857142858 | 0.9779005524861878 | 0.6045197740112995 |
20455 | 20455 | Southern California Hospital at Hollywood | 50135 | 2021-09-10 | Los Angeles | 37 | Southern California | 2.7142857142857144 | 29.857142857142858 | 4.142857142857143 | 34.0 | 0.1218487394957983 | 0.6551724137931034 |
20454 | 20454 | South Coast Global Medical Center | 50747 | 2021-09-10 | Orange | 59 | Southern California | 1.5 | 4.666666666666667 | 4.333333333333333 | 9.0 | 0.4814814814814814 | 0.3461538461538462 |
20453 | 20453 | Sonoma Valley Hospital | 50090 | 2021-09-10 | Sonoma | 97 | Bay Area | 0.0 | 4.142857142857142 | 1.8571428571428568 | 6.0 | 0.3095238095238095 | 0.0 |
20452 | 20452 | Sonoma Specialty Hospital | 52057 | 2021-09-10 | Sonoma | 97 | Bay Area | 0.0 | 1.0 | 4.0 | 5.0 | 0.8 | 0.0 |
20451 | 20451 | Sierra View Medical Center | 50261 | 2021-09-10 | Tulare | 107 | San Joaquin Valley | 6.428571428571429 | 0.7142857142857135 | 9.428571428571429 | 10.142857142857142 | 0.9295774647887324 | 0.6818181818181819 |
20450 | 20450 | Sierra Nevada Memorial Hospital | 50150 | 2021-09-10 | Nevada | 57 | Greater Sacramento | 4.0 | 0.0 | 4.666666666666667 | 4.666666666666667 | 1.0 | 0.8571428571428571 |
20449 | 20449 | Sherman Oaks Hospital | 50755 | 2021-09-10 | Los Angeles | 37 | Southern California | 1.1428571428571428 | 2.2857142857142856 | 3.7142857142857135 | 6.0 | 0.6190476190476191 | 0.3076923076923076 |
20448 | 20448 | Shasta Regional Medical Center | 50764 | 2021-09-10 | Shasta | 89 | Northern California | 8.857142857142858 | 6.571428571428571 | 15.428571428571429 | 22.0 | 0.7012987012987013 | 0.5740740740740741 |
20447 | 20447 | Sharp Memorial Hospital | 50100 | 2021-09-10 | San Diego | 73 | Southern California | 16.857142857142858 | 15.42857142857143 | 42.57142857142857 | 58.0 | 0.7339901477832512 | 0.3959731543624161 |
20446 | 20446 | Sharp Coronado Hospital and Hlthcr Center | 50234 | 2021-09-10 | San Diego | 73 | Southern California | 2.0 | 0.8571428571428577 | 5.285714285714286 | 6.142857142857143 | 0.8604651162790697 | 0.3783783783783784 |
20445 | 20445 | Sharp Chula Vista Medical Center | 50222 | 2021-09-10 | San Diego | 73 | Southern California | 15.857142857142858 | 0.7142857142857153 | 32.285714285714285 | 33.0 | 0.9783549783549784 | 0.4911504424778761 |
20444 | 20444 | Sequoia Hospital | 50197 | 2021-09-10 | San Mateo | 81 | Bay Area | 1.5714285714285714 | 6.285714285714287 | 6.0 | 12.285714285714286 | 0.4883720930232558 | 0.2619047619047619 |
20443 | 20443 | Select Specialty Hospital - San Diego | 52044 | 2021-09-10 | San Diego | 73 | Southern California | 0.0 | 0.2857142857142857 | 0.5714285714285714 | 0.8571428571428571 | 0.6666666666666666 | 0.0 |
20442 | 20442 | Scripps Mercy Hospital | 50077 | 2021-09-10 | San Diego | 73 | Southern California | 20.571428571428573 | 11.999999999999991 | 55.142857142857146 | 67.14285714285714 | 0.8212765957446809 | 0.3730569948186528 |
20441 | 20441 | Scripps Memorial Hospital La Jolla | 50324 | 2021-09-10 | San Diego | 73 | Southern California | 14.0 | 8.285714285714285 | 50.71428571428572 | 59.0 | 0.8595641646489104 | 0.276056338028169 |
20440 | 20440 | Scripps Memorial Hospital - Encinitas | 50503 | 2021-09-10 | San Diego | 73 | Southern California | 7.857142857142857 | 2.1428571428571423 | 20.571428571428573 | 22.714285714285715 | 0.9056603773584906 | 0.3819444444444444 |
20439 | 20439 | Scripps Green Hospital | 50424 | 2021-09-10 | San Diego | 73 | Southern California | 4.285714285714286 | 11.285714285714286 | 12.714285714285714 | 24.0 | 0.5297619047619048 | 0.3370786516853932 |
20438 | 20438 | Santa Paula Hospital | 2021-09-10 | Ventura | 111 | Southern California | 0.0 | 1.2857142857142856 | 4.714285714285714 | 6.0 | 0.7857142857142857 | 0.0 | |
20437 | 20437 | Santa Monica - UCLA Medical Center & Orthopaedic Hospital | 50112 | 2021-09-10 | Los Angeles | 37 | Southern California | 1.2857142857142858 | 7.0 | 15.0 | 22.0 | 0.6818181818181818 | 0.0857142857142857 |
20436 | 20436 | Santa Clara Valley Medical Center | 50038 | 2021-09-10 | Santa Clara | 85 | Bay Area | 10.571428571428571 | 4.714285714285708 | 65.28571428571429 | 70.0 | 0.93265306122449 | 0.161925601750547 |
20435 | 20435 | Santa Barbara Cottage Hospital | 50396 | 2021-09-10 | Santa Barbara | 83 | Southern California | 4.857142857142857 | 16.714285714285715 | 33.285714285714285 | 50.0 | 0.6657142857142857 | 0.1459227467811159 |
20434 | 20434 | San Ramon Regional Medical Center | 50689 | 2021-09-10 | Contra Costa | 13 | Bay Area | 1.5714285714285714 | 6.714285714285714 | 5.285714285714286 | 12.0 | 0.4404761904761904 | 0.2972972972972973 |
20433 | 20433 | San Mateo Medical Center | 50113 | 2021-09-10 | San Mateo | 81 | Bay Area | 2.142857142857143 | 0.8571428571428568 | 5.0 | 5.857142857142857 | 0.853658536585366 | 0.4285714285714285 |
20432 | 20432 | San Joaquin General Hospital | 50167 | 2021-09-10 | San Joaquin | 77 | San Joaquin Valley | 13.428571428571429 | 0.0 | 32.857142857142854 | 32.857142857142854 | 1.0 | 0.408695652173913 |
20431 | 20431 | San Gorgonio Memorial Hospital | 50054 | 2021-09-10 | Riverside | 65 | Southern California | 1.2857142857142858 | 8.285714285714285 | 7.714285714285714 | 16.0 | 0.4821428571428571 | 0.1666666666666666 |
20430 | 20430 | San Gabriel Valley Medical Center | 50132 | 2021-09-10 | Los Angeles | 37 | Southern California | 1.0 | 2.666666666666666 | 11.5 | 14.166666666666666 | 0.8117647058823529 | 0.0869565217391304 |
20429 | 20429 | San Dimas Community Hospital | 50588 | 2021-09-10 | Los Angeles | 37 | Southern California | 2.0 | 1.0 | 7.0 | 8.0 | 0.875 | 0.2857142857142857 |
20428 | 20428 | San Antonio Regional Hospital | 50099 | 2021-09-10 | San Bernardino | 71 | Southern California | 17.714285714285715 | 0.0 | 34.142857142857146 | 34.142857142857146 | 1.0 | 0.5188284518828452 |
20427 | 20427 | Salinas Valley Memorial Hospital | 50334 | 2021-09-10 | Monterey | 53 | Bay Area | 2.4285714285714284 | 4.857142857142858 | 9.428571428571429 | 14.285714285714286 | 0.66 | 0.2575757575757575 |
20426 | 20426 | Saint John's Health Center | 50290 | 2021-09-10 | Los Angeles | 37 | Southern California | 6.142857142857143 | 1.7142857142857135 | 14.714285714285714 | 16.428571428571427 | 0.8956521739130435 | 0.4174757281553398 |
20425 | 20425 | Saint Francis Memorial Hospital | 50152 | 2021-09-10 | San Francisco | 75 | Bay Area | 0.0 | 13.714285714285715 | 6.285714285714286 | 20.0 | 0.3142857142857143 | 0.0 |
20424 | 20424 | Saint Francis Medical Center | 50104 | 2021-09-10 | Los Angeles | 37 | Southern California | 9.0 | 0.9999999999999964 | 31.857142857142858 | 32.857142857142854 | 0.9695652173913044 | 0.2825112107623318 |
20423 | 20423 | Saint Agnes Medical Center | 50093 | 2021-09-10 | Fresno | 19 | San Joaquin Valley | 17.142857142857142 | 0.7142857142857082 | 34.142857142857146 | 34.857142857142854 | 0.9795081967213116 | 0.502092050209205 |
20422 | 20422 | Ronald Reagan UCLA Medical Center | 50262 | 2021-09-10 | Los Angeles | 37 | Southern California | 13.142857142857142 | 8.0 | 101.0 | 109.0 | 0.926605504587156 | 0.1301272984441301 |
20421 | 20421 | Riverside University Health System-medical Center | 50292 | 2021-09-10 | Riverside | 65 | Southern California | 18.142857142857142 | 1.7142857142857153 | 42.85714285714285 | 44.57142857142857 | 0.9615384615384616 | 0.4233333333333333 |
20420 | 20420 | Riverside Community Hospital | 50022 | 2021-09-10 | Riverside | 65 | Southern California | 16.285714285714285 | 4.142857142857139 | 71.28571428571429 | 75.42857142857143 | 0.9450757575757576 | 0.2284569138276553 |
20419 | 20419 | Ridgecrest Regional Hospital | 51333 | 2021-09-10 | Kern | 29 | San Joaquin Valley | 1.1428571428571428 | 0.4285714285714284 | 3.571428571428572 | 4.0 | 0.8928571428571429 | 0.3199999999999999 |
20418 | 20418 | Regional Medical Center of San Jose | 50125 | 2021-09-10 | Santa Clara | 85 | Bay Area | 5.142857142857143 | 0.0 | 28.571428571428573 | 28.571428571428573 | 1.0 | 0.18 |
20417 | 20417 | Redlands Community Hospital | 50272 | 2021-09-10 | San Bernardino | 71 | Southern California | 10.285714285714286 | 1.0 | 13.0 | 14.0 | 0.9285714285714286 | 0.7912087912087913 |
20416 | 20416 | Providence St. Jude Medical Center | 50168 | 2021-09-10 | Orange | 59 | Southern California | 4.428571428571429 | 4.428571428571431 | 32.714285714285715 | 37.142857142857146 | 0.8807692307692307 | 0.1353711790393013 |
20415 | 20415 | Providence St. Joseph Hospital | 50069 | 2021-09-10 | Orange | 59 | Southern California | 5.0 | 1.2857142857142847 | 23.142857142857142 | 24.428571428571427 | 0.9473684210526316 | 0.2160493827160494 |
20414 | 20414 | Providence St. Joseph Hospital | 50006 | 2021-09-10 | Humboldt | 23 | Northern California | 0.8571428571428571 | 3.1428571428571423 | 8.857142857142858 | 12.0 | 0.7380952380952381 | 0.096774193548387 |
20413 | 20413 | Providence Santa Rosa Memorial Hospital | 50174 | 2021-09-10 | Sonoma | 97 | Bay Area | 7.857142857142857 | 2.2857142857142847 | 23.714285714285715 | 26.0 | 0.9120879120879122 | 0.3313253012048192 |
20412 | 20412 | Providence Saint Joseph Medical Center | 50235 | 2021-09-10 | Los Angeles | 37 | Southern California | 13.142857142857142 | 3.0 | 37.85714285714285 | 40.85714285714285 | 0.9265734265734266 | 0.3471698113207547 |
20411 | 20411 | Providence Redwood Memorial Hospital | 51318 | 2021-09-10 | Humboldt | 23 | Northern California | 0.0 | 1.0 | 3.0 | 4.0 | 0.75 | 0.0 |
20410 | 20410 | Providence Queen of the Valley Medical Center | 50009 | 2021-09-10 | Napa | 55 | Bay Area | 3.0 | 0.7142857142857153 | 10.571428571428571 | 11.285714285714286 | 0.9367088607594936 | 0.2837837837837837 |
20409 | 20409 | Providence Mission Hospital | 50567 | 2021-09-10 | Orange | 59 | Southern California | 4.0 | 3.5714285714285694 | 43.42857142857143 | 47.0 | 0.9240121580547112 | 0.0921052631578947 |
20408 | 20408 | Providence Little Company of Mary Medical Center Torrance | 50353 | 2021-09-10 | Los Angeles | 37 | Southern California | 6.285714285714286 | 2.0 | 19.285714285714285 | 21.285714285714285 | 0.906040268456376 | 0.3259259259259259 |
20407 | 20407 | Providence Little Company of Mary Medical Center San Pedro | 50078 | 2021-09-10 | Los Angeles | 37 | Southern California | 5.714285714285714 | 0.1428571428571423 | 6.142857142857143 | 6.285714285714286 | 0.9772727272727274 | 0.9302325581395348 |
20406 | 20406 | Providence Holy Cross Medical Center | 50278 | 2021-09-10 | Los Angeles | 37 | Southern California | 0.0 | 1.0 | 34.42857142857143 | 35.42857142857143 | 0.9717741935483872 | 0.0 |
20405 | 20405 | Providence Cedars Sinai Tarzana Medical Center | 50761 | 2021-09-10 | Los Angeles | 37 | Southern California | 1.4285714285714286 | 0.571428571428573 | 11.714285714285714 | 12.285714285714286 | 0.9534883720930232 | 0.1219512195121951 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "hhs-hospital-icu-totals" ( [hospital] TEXT, [ccn] INTEGER, [week] TEXT, [county] TEXT, [fips] INTEGER, [region] TEXT, [covid_icu_patients_total] FLOAT, [available_adult_icu_beds_total] FLOAT, [occupied_adult_icu_beds_total] FLOAT, [staffed_adult_icu_beds_total] FLOAT, [occupied_adult_icu_beds_percent] FLOAT, [icu_patients_with_covid_percent] FLOAT );