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.
309 rows where "week" is on date 2021-01-01 sorted by covid_icu_patients_total
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31213 | 31213 | Adventist Health Mendocino Coast | 51325 | 2021-01-01 | Mendocino | 45 | Northern California | 0.0 | 2.571428571428571 | 1.4285714285714286 | 4.0 | 0.3571428571428571 | 0.0 |
31218 | 31218 | Adventist Health Tulare | 50784 | 2021-01-01 | Tulare | 107 | San Joaquin Valley | 0.0 | 2.142857142857143 | 2.142857142857143 | 4.285714285714286 | 0.5 | 0.0 |
31233 | 31233 | Barlow Respiratory Hospital | 52031 | 2021-01-01 | Los Angeles | 37 | Southern California | 0.0 | 4.0 | 2.0 | 6.0 | 0.3333333333333333 | 0.0 |
31240 | 31240 | California Pacific Medical Ctr-davies Campus Hosp | 50008 | 2021-01-01 | San Francisco | 75 | Bay Area | 0.0 | 0.2857142857142856 | 7.714285714285714 | 8.0 | 0.9642857142857144 | 0.0 |
31241 | 31241 | Casa Colina Hospital | 50782 | 2021-01-01 | Los Angeles | 37 | Southern California | 0.0 | 3.0 | 3.0 | 6.0 | 0.5 | 0.0 |
31251 | 31251 | Colusa Medical Center | 50783 | 2021-01-01 | Colusa | 11 | Greater Sacramento | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
31280 | 31280 | Fresno Heart and Surgical Hospital | 50732 | 2021-01-01 | Fresno | 19 | San Joaquin Valley | 0.0 | 1.8571428571428568 | 7.142857142857143 | 9.0 | 0.7936507936507937 | 0.0 |
31285 | 31285 | Goleta Valley Cottage Hospital | 50357 | 2021-01-01 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.5714285714285714 | 0.5714285714285714 | 1.0 | 0.0 |
31286 | 31286 | Good Samaritan Hospital | 50257 | 2021-01-01 | Kern | 29 | San Joaquin Valley | 0.0 | 2.142857142857143 | 1.8571428571428568 | 4.0 | 0.4642857142857143 | 0.0 |
31291 | 31291 | Healdsburg Hospital | 51321 | 2021-01-01 | Sonoma | 97 | Bay Area | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
31338 | 31338 | Kindred Hospital - Los Angeles | 52032 | 2021-01-01 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 5.0 | 5.0 | 1.0 | 0.0 |
31339 | 31339 | Kindred Hospital - San Diego | 52036 | 2021-01-01 | San Diego | 73 | Southern California | 0.0 | 2.0 | 6.0 | 8.0 | 0.75 | 0.0 |
31340 | 31340 | Kindred Hospital - San Francisco Bay Area | 52034 | 2021-01-01 | Alameda | 1 | Bay Area | 0.0 | 1.8571428571428577 | 8.142857142857142 | 10.0 | 0.8142857142857143 | 0.0 |
31342 | 31342 | Kindred Hospital Baldwin Park | 52045 | 2021-01-01 | Los Angeles | 37 | Southern California | 0.0 | 0.2857142857142856 | 7.714285714285714 | 8.0 | 0.9642857142857144 | 0.0 |
31343 | 31343 | Kindred Hospital Brea | 52039 | 2021-01-01 | Orange | 59 | Southern California | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
31344 | 31344 | Kindred Hospital Ontario | 52037 | 2021-01-01 | San Bernardino | 71 | Southern California | 0.0 | 5.0 | 6.0 | 11.0 | 0.5454545454545454 | 0.0 |
31345 | 31345 | Kindred Hospital Paramount | 52046 | 2021-01-01 | Los Angeles | 37 | Southern California | 0.0 | 0.4285714285714288 | 11.571428571428571 | 12.0 | 0.9642857142857144 | 0.0 |
31346 | 31346 | Kindred Hospital Rancho | 52049 | 2021-01-01 | San Bernardino | 71 | Southern California | 0.0 | 0.0 | 8.0 | 8.0 | 1.0 | 0.0 |
31347 | 31347 | Kindred Hospital Riverside | 52052 | 2021-01-01 | Riverside | 65 | Southern California | 0.0 | 0.1428571428571432 | 7.857142857142857 | 8.0 | 0.9821428571428572 | 0.0 |
31366 | 31366 | Mammoth Hospital | 51303 | 2021-01-01 | Mono | 51 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
31368 | 31368 | Marian Regional Medical Center, Arroyo Grande | 50016 | 2021-01-01 | San Luis Obispo | 79 | Southern California | 0.0 | 3.0 | 2.571428571428572 | 5.571428571428571 | 0.4615384615384616 | 0.0 |
31384 | 31384 | Mercy Medical Center Mt Shasta | 51319 | 2021-01-01 | Siskiyou | 93 | Northern California | 0.0 | 4.0 | 0.0 | 4.0 | 0.0 | |
31390 | 31390 | Monrovia Memorial Hospital | 52054 | 2021-01-01 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
31399 | 31399 | Ojai Valley Community Hospital | 51334 | 2021-01-01 | Ventura | 111 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
31422 | 31422 | Providence Redwood Memorial Hospital | 51318 | 2021-01-01 | Humboldt | 23 | Northern California | 0.0 | 1.4285714285714284 | 2.571428571428572 | 4.0 | 0.6428571428571429 | 0.0 |
31454 | 31454 | Select Specialty Hospital - San Diego | 52044 | 2021-01-01 | San Diego | 73 | Southern California | 0.0 | 0.4285714285714288 | 4.714285714285714 | 5.142857142857143 | 0.9166666666666666 | 0.0 |
31463 | 31463 | Sonoma Specialty Hospital | 52057 | 2021-01-01 | Sonoma | 97 | Bay Area | 0.0 | 0.8571428571428577 | 4.285714285714286 | 5.142857142857143 | 0.8333333333333333 | 0.0 |
31475 | 31475 | St. Mary's Medical Center | 50457 | 2021-01-01 | San Francisco | 75 | Bay Area | 0.0 | 7.714285714285714 | 5.714285714285714 | 13.428571428571429 | 0.425531914893617 | 0.0 |
31498 | 31498 | USC Kenneth Norris Jr Cancer Hospital | 50660 | 2021-01-01 | Los Angeles | 37 | Southern California | 0.0 | 0.4285714285714286 | 1.7142857142857142 | 2.142857142857143 | 0.7999999999999999 | 0.0 |
31503 | 31503 | Valley Children's Hospital | 53300 | 2021-01-01 | Fresno | 19 | San Joaquin Valley | 0.0 | 0.0 | 2.2857142857142856 | 2.2857142857142856 | 1.0 | 0.0 |
31506 | 31506 | Vibra Hospital of Sacramento | 52033 | 2021-01-01 | Sacramento | 67 | Greater Sacramento | 0.0 | 0.5714285714285712 | 5.428571428571429 | 6.0 | 0.9047619047619048 | 0.0 |
31219 | 31219 | Adventist Health Ukiah Valley | 50301 | 2021-01-01 | Mendocino | 45 | Northern California | 0.7142857142857143 | 1.571428571428572 | 5.571428571428571 | 7.142857142857143 | 0.7799999999999999 | 0.1282051282051282 |
31357 | 31357 | Loma Linda University Children's Hospital | 50778 | 2021-01-01 | San Bernardino | 71 | Southern California | 0.8571428571428571 | 0.0 | 0.8571428571428571 | 0.8571428571428571 | 1.0 | 1.0 |
31402 | 31402 | Orchard Hospital | 51311 | 2021-01-01 | Butte | 7 | Greater Sacramento | 1.0 | 2.571428571428571 | 1.4285714285714286 | 4.0 | 0.3571428571428571 | 0.7 |
31409 | 31409 | Petaluma Valley Hospital | 50136 | 2021-01-01 | Sonoma | 97 | Bay Area | 1.0 | 1.0000000000000004 | 3.142857142857143 | 4.142857142857143 | 0.7586206896551724 | 0.3181818181818182 |
31464 | 31464 | Sonoma Valley Hospital | 50090 | 2021-01-01 | Sonoma | 97 | Bay Area | 1.0 | 3.571428571428572 | 2.857142857142857 | 6.428571428571429 | 0.4444444444444444 | 0.35 |
31481 | 31481 | Sutter Coast Hospital | 50417 | 2021-01-01 | Del Norte | 15 | Northern California | 1.0 | 0.8571428571428568 | 5.142857142857143 | 6.0 | 0.8571428571428572 | 0.1944444444444444 |
31215 | 31215 | Adventist Health Sonora | 50335 | 2021-01-01 | Tuolumne | 109 | San Joaquin Valley | 1.1428571428571428 | 1.0 | 5.0 | 6.0 | 0.8333333333333334 | 0.2285714285714285 |
31397 | 31397 | Novato Community Hospital | 50131 | 2021-01-01 | Marin | 41 | Bay Area | 1.1428571428571428 | 3.7142857142857135 | 3.2857142857142856 | 7.0 | 0.4693877551020408 | 0.3478260869565217 |
31398 | 31398 | Oak Valley Hospital District | 50067 | 2021-01-01 | Stanislaus | 99 | San Joaquin Valley | 1.1428571428571428 | 2.571428571428572 | 2.4285714285714284 | 5.0 | 0.4857142857142856 | 0.4705882352941176 |
31449 | 31449 | Santa Paula Hospital | 2021-01-01 | Ventura | 111 | Southern California | 1.1428571428571428 | 0.2857142857142856 | 5.714285714285714 | 6.0 | 0.9523809523809524 | 0.1999999999999999 | |
31208 | 31208 | Adventist Health Clearlake | 51317 | 2021-01-01 | Lake | 33 | Northern California | 1.2857142857142858 | 0.2857142857142856 | 3.7142857142857135 | 4.0 | 0.9285714285714286 | 0.3461538461538461 |
31276 | 31276 | Fairchild Medical Center | 51316 | 2021-01-01 | Siskiyou | 93 | Northern California | 1.2857142857142858 | 1.1428571428571432 | 2.4285714285714284 | 3.571428571428572 | 0.6799999999999999 | 0.5294117647058825 |
31364 | 31364 | Mad River Community Hospital | 50028 | 2021-01-01 | Humboldt | 23 | Northern California | 1.2857142857142858 | 4.571428571428571 | 1.7142857142857142 | 6.285714285714286 | 0.2727272727272727 | 0.7500000000000001 |
31370 | 31370 | Mark Twain Medical Center | 51332 | 2021-01-01 | Calaveras | 9 | San Joaquin Valley | 1.2857142857142858 | 7.0 | 3.857142857142857 | 10.857142857142858 | 0.3552631578947368 | 0.3333333333333333 |
31425 | 31425 | Providence St. Joseph Hospital | 50006 | 2021-01-01 | Humboldt | 23 | Northern California | 1.4285714285714286 | 8.0 | 9.142857142857142 | 17.142857142857142 | 0.5333333333333333 | 0.15625 |
31341 | 31341 | Kindred Hospital -- La Mirada | 52038 | 2021-01-01 | Los Angeles | 37 | Southern California | 1.5714285714285714 | 3.8571428571428577 | 15.142857142857142 | 19.0 | 0.7969924812030075 | 0.1037735849056603 |
31490 | 31490 | Tahoe Forest Hospital | 51328 | 2021-01-01 | Nevada | 57 | Greater Sacramento | 1.5714285714285714 | 1.8571428571428568 | 4.142857142857143 | 6.0 | 0.6904761904761906 | 0.3793103448275862 |
31395 | 31395 | Northern Inyo Hospital | 51324 | 2021-01-01 | Inyo | 27 | Southern California | 2.0 | 2.0 | 2.0 | 4.0 | 0.5 | 1.0 |
31294 | 31294 | Hi-desert Medical Center | 50279 | 2021-01-01 | San Bernardino | 71 | Southern California | 2.2857142857142856 | 0.0 | 4.0 | 4.0 | 1.0 | 0.5714285714285714 |
31461 | 31461 | Sierra Nevada Memorial Hospital | 50150 | 2021-01-01 | Nevada | 57 | Greater Sacramento | 2.4285714285714284 | 0.0 | 4.571428571428571 | 4.571428571428571 | 1.0 | 0.53125 |
31369 | 31369 | Marinhealth Medical Center | 50360 | 2021-01-01 | Marin | 41 | Bay Area | 2.5 | 6.333333333333334 | 12.666666666666666 | 19.0 | 0.6666666666666666 | 0.1973684210526315 |
31245 | 31245 | Chinese Hospital | 50407 | 2021-01-01 | San Francisco | 75 | Bay Area | 2.571428571428572 | 2.142857142857143 | 3.857142857142857 | 6.0 | 0.6428571428571429 | 0.6666666666666667 |
31403 | 31403 | Oroville Hospital | 50030 | 2021-01-01 | Butte | 7 | Greater Sacramento | 2.571428571428572 | 1.5714285714285712 | 8.428571428571429 | 10.0 | 0.8428571428571429 | 0.3050847457627119 |
31484 | 31484 | Sutter Lakeside Hospital | 51329 | 2021-01-01 | Lake | 33 | Northern California | 2.571428571428572 | 1.4285714285714284 | 3.571428571428572 | 5.0 | 0.7142857142857143 | 0.72 |
31493 | 31493 | Tenet Health Central Twin Cities Community Hosp | 50633 | 2021-01-01 | San Luis Obispo | 79 | Southern California | 2.571428571428572 | 4.0 | 6.0 | 10.0 | 0.6 | 0.4285714285714286 |
31235 | 31235 | Barton Memorial Hospital | 50352 | 2021-01-01 | El Dorado | 17 | Greater Sacramento | 2.7142857142857144 | 2.571428571428571 | 5.428571428571429 | 8.0 | 0.6785714285714286 | 0.5 |
31333 | 31333 | Kaiser Foundation Hospital-santa Rosa | 50690 | 2021-01-01 | Sonoma | 97 | Bay Area | 2.7142857142857144 | 1.0 | 8.857142857142858 | 9.857142857142858 | 0.8985507246376812 | 0.3064516129032258 |
31349 | 31349 | Kindred Hospital Westminster | 52035 | 2021-01-01 | Orange | 59 | Southern California | 2.7142857142857144 | 0.2857142857142865 | 15.714285714285714 | 16.0 | 0.9821428571428572 | 0.1727272727272727 |
31469 | 31469 | St. Elizabeth Community Hospital | 50042 | 2021-01-01 | Tehama | 103 | Northern California | 2.857142857142857 | 0.5714285714285712 | 7.428571428571429 | 8.0 | 0.9285714285714286 | 0.3846153846153846 |
31247 | 31247 | City of Hope Helford Clinical Research Hospital | 50146 | 2021-01-01 | Los Angeles | 37 | Southern California | 3.0 | 3.7142857142857135 | 14.285714285714286 | 18.0 | 0.7936507936507937 | 0.21 |
31211 | 31211 | Adventist Health Howard Memorial | 51310 | 2021-01-01 | Mendocino | 45 | Northern California | 3.142857142857143 | 0.0 | 4.0 | 4.0 | 1.0 | 0.7857142857142857 |
31231 | 31231 | Bakersfield Heart Hospital | 50724 | 2021-01-01 | Kern | 29 | San Joaquin Valley | 3.142857142857143 | 1.7142857142857135 | 8.285714285714286 | 10.0 | 0.8285714285714286 | 0.3793103448275862 |
31274 | 31274 | Encino Hospital Medical Center | 50158 | 2021-01-01 | Los Angeles | 37 | Southern California | 3.142857142857143 | 0.0 | 5.857142857142857 | 5.857142857142857 | 1.0 | 0.5365853658536586 |
31348 | 31348 | Kindred Hospital South Bay | 52050 | 2021-01-01 | Los Angeles | 37 | Southern California | 3.142857142857143 | 2.2857142857142856 | 6.714285714285714 | 9.0 | 0.746031746031746 | 0.4680851063829787 |
31350 | 31350 | LA Downtown Medical Center, LLC | 50763 | 2021-01-01 | Los Angeles | 37 | Southern California | 3.142857142857143 | 2.0 | 10.0 | 12.0 | 0.8333333333333334 | 0.3142857142857143 |
31459 | 31459 | Shasta Regional Medical Center | 50764 | 2021-01-01 | Shasta | 89 | Northern California | 3.142857142857143 | 3.2857142857142865 | 12.571428571428571 | 15.857142857142858 | 0.7927927927927928 | 0.25 |
31430 | 31430 | Ridgecrest Regional Hospital | 51333 | 2021-01-01 | Kern | 29 | San Joaquin Valley | 3.2857142857142856 | 0.0 | 4.285714285714286 | 4.285714285714286 | 1.0 | 0.7666666666666666 |
31304 | 31304 | Kaiser Foundation Hospital | 50510 | 2021-01-01 | Marin | 41 | Bay Area | 3.4285714285714284 | 1.0 | 6.142857142857143 | 7.142857142857143 | 0.86 | 0.5581395348837208 |
31482 | 31482 | Sutter Davis Hospital | 50537 | 2021-01-01 | Yolo | 113 | Greater Sacramento | 3.4285714285714284 | 1.1428571428571432 | 4.857142857142857 | 6.0 | 0.8095238095238094 | 0.7058823529411765 |
31489 | 31489 | Sutter Tracy Community Hospital | 50313 | 2021-01-01 | San Joaquin | 77 | San Joaquin Valley | 3.4285714285714284 | 2.1428571428571432 | 5.857142857142857 | 8.0 | 0.7321428571428571 | 0.5853658536585366 |
31354 | 31354 | LAC/Rancho Los Amigos National Rehabilitation Center | 50717 | 2021-01-01 | Los Angeles | 37 | Southern California | 3.571428571428572 | 2.2857142857142847 | 6.428571428571429 | 8.714285714285714 | 0.7377049180327869 | 0.5555555555555556 |
31479 | 31479 | Sutter Amador Hospital | 50014 | 2021-01-01 | Amador | 5 | Greater Sacramento | 3.857142857142857 | 0.2857142857142865 | 5.857142857142857 | 6.142857142857143 | 0.9534883720930232 | 0.6585365853658537 |
31509 | 31509 | Watsonville Community Hospital | 50194 | 2021-01-01 | Santa Cruz | 87 | Bay Area | 3.857142857142857 | 0.5714285714285712 | 5.428571428571429 | 6.0 | 0.9047619047619048 | 0.7105263157894737 |
31290 | 31290 | Hazel Hawkins Memorial Hospital | 51337 | 2021-01-01 | San Benito | 69 | San Joaquin Valley | 4.0 | 0.0 | 4.571428571428571 | 4.571428571428571 | 1.0 | 0.875 |
31404 | 31404 | Pacifica Hospital of the Valley | 50378 | 2021-01-01 | Los Angeles | 37 | Southern California | 4.0 | 0.1666666666666678 | 12.666666666666666 | 12.833333333333334 | 0.9870129870129868 | 0.3157894736842105 |
31223 | 31223 | Alameda Hospital | 50211 | 2021-01-01 | Alameda | 1 | Bay Area | 4.142857142857143 | 1.0 | 7.0 | 8.0 | 0.875 | 0.5918367346938777 |
31262 | 31262 | Doctors Hospital of Manteca | 50118 | 2021-01-01 | San Joaquin | 77 | San Joaquin Valley | 4.142857142857143 | 1.0 | 7.0 | 8.0 | 0.875 | 0.5918367346938777 |
31360 | 31360 | Lompoc Valley Medical Center | 50110 | 2021-01-01 | Santa Barbara | 83 | Southern California | 4.285714285714286 | 1.7142857142857144 | 4.857142857142857 | 6.571428571428571 | 0.7391304347826086 | 0.8823529411764707 |
31470 | 31470 | St. Johns Hospital Camarillo | 50616 | 2021-01-01 | Ventura | 111 | Southern California | 4.285714285714286 | 0.4285714285714288 | 7.285714285714286 | 7.714285714285714 | 0.9444444444444444 | 0.5882352941176471 |
31239 | 31239 | California Pacific Medical Center- Van Ness Campus | 50047 | 2021-01-01 | San Francisco | 75 | Bay Area | 4.428571428571429 | 5.857142857142858 | 30.142857142857142 | 36.0 | 0.8373015873015873 | 0.1469194312796208 |
31380 | 31380 | Mercy General Hospital | 50017 | 2021-01-01 | Sacramento | 67 | Greater Sacramento | 4.428571428571429 | 25.285714285714285 | 20.714285714285715 | 46.0 | 0.4503105590062112 | 0.2137931034482758 |
31216 | 31216 | Adventist Health St. Helena | 50013 | 2021-01-01 | Napa | 55 | Bay Area | 4.571428571428571 | 7.142857142857142 | 9.142857142857142 | 16.285714285714285 | 0.5614035087719298 | 0.5 |
31373 | 31373 | Memorial Hospital Los Banos | 50528 | 2021-01-01 | Merced | 47 | San Joaquin Valley | 4.571428571428571 | 0.0 | 5.428571428571429 | 5.428571428571429 | 1.0 | 0.8421052631578947 |
31480 | 31480 | Sutter Auburn Faith Hospital | 50498 | 2021-01-01 | Placer | 61 | Greater Sacramento | 4.571428571428571 | 0.8571428571428568 | 7.142857142857143 | 8.0 | 0.8928571428571429 | 0.6399999999999999 |
31483 | 31483 | Sutter Delta Medical Center | 50523 | 2021-01-01 | Contra Costa | 13 | Bay Area | 4.857142857142857 | 0.4285714285714288 | 11.571428571428571 | 12.0 | 0.9642857142857144 | 0.419753086419753 |
31505 | 31505 | Ventura County Medical Center | 50159 | 2021-01-01 | Ventura | 111 | Southern California | 4.857142857142857 | 6.571428571428571 | 9.428571428571429 | 16.0 | 0.5892857142857143 | 0.5151515151515151 |
31492 | 31492 | Tenet Health Central Coast Sierra Vista Rmc | 50506 | 2021-01-01 | San Luis Obispo | 79 | Southern California | 5.0 | 7.857142857142858 | 9.142857142857142 | 17.0 | 0.5378151260504201 | 0.546875 |
31217 | 31217 | Adventist Health Tehachapi Valley | 51301 | 2021-01-01 | Kern | 29 | San Joaquin Valley | 5.142857142857143 | 1.2857142857142856 | 6.714285714285714 | 8.0 | 0.8392857142857143 | 0.7659574468085106 |
31385 | 31385 | Mercy Medical Center Redding | 50280 | 2021-01-01 | Shasta | 89 | Northern California | 5.142857142857143 | 7.0 | 26.0 | 33.0 | 0.7878787878787878 | 0.1978021978021978 |
31444 | 31444 | San Mateo Medical Center | 50113 | 2021-01-01 | San Mateo | 81 | Bay Area | 5.285714285714286 | 0.4285714285714288 | 6.571428571428571 | 7.0 | 0.9387755102040816 | 0.8043478260869565 |
31238 | 31238 | California Pacific Medical Center - Mission Bernal | 50055 | 2021-01-01 | San Francisco | 75 | Bay Area | 5.428571428571429 | 2.428571428571429 | 7.571428571428571 | 10.0 | 0.7571428571428571 | 0.7169811320754718 |
31414 | 31414 | Placentia Linda Hospital | 50589 | 2021-01-01 | Orange | 59 | Southern California | 5.428571428571429 | 4.714285714285714 | 7.285714285714286 | 12.0 | 0.6071428571428571 | 0.7450980392156863 |
31359 | 31359 | Loma Linda University Medical Center-murrieta | 50770 | 2021-01-01 | Riverside | 65 | Southern California | 5.571428571428571 | 1.4285714285714288 | 10.714285714285714 | 12.142857142857142 | 0.8823529411764706 | 0.52 |
31487 | 31487 | Sutter Santa Rosa Regional Hospital | 50291 | 2021-01-01 | Sonoma | 97 | Bay Area | 5.571428571428571 | 0.2857142857142865 | 11.714285714285714 | 12.0 | 0.9761904761904762 | 0.475609756097561 |
31320 | 31320 | Kaiser Foundation Hospital - South San Francisco | 50070 | 2021-01-01 | San Mateo | 81 | Bay Area | 5.714285714285714 | 1.0 | 11.714285714285714 | 12.714285714285714 | 0.9213483146067416 | 0.4878048780487805 |
31382 | 31382 | Mercy Hospital of Folsom | 50414 | 2021-01-01 | Sacramento | 67 | Greater Sacramento | 5.857142857142857 | 0.7142857142857135 | 7.428571428571429 | 8.142857142857142 | 0.912280701754386 | 0.7884615384615384 |
31445 | 31445 | San Ramon Regional Medical Center | 50689 | 2021-01-01 | Contra Costa | 13 | Bay Area | 5.857142857142857 | 5.285714285714286 | 6.714285714285714 | 12.0 | 0.5595238095238095 | 0.8723404255319148 |
31226 | 31226 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305 | 2021-01-01 | Alameda | 1 | Bay Area | 6.0 | 14.857142857142858 | 15.142857142857142 | 30.0 | 0.5047619047619047 | 0.3962264150943396 |
31222 | 31222 | Ahmc Seton Medical Center | 50289 | 2021-01-01 | San Mateo | 81 | Bay Area | 6.142857142857143 | 6.571428571428573 | 10.0 | 16.571428571428573 | 0.603448275862069 | 0.6142857142857143 |
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 );