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.
306 rows where "week" is on date 2021-01-22 sorted by covid_icu_patients_total
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30294 | 30294 | Adventist Health Howard Memorial | 51310 | 2021-01-22 | Mendocino | 45 | Northern California | 0.0 | 3.142857142857143 | 3.857142857142857 | 7.0 | 0.5510204081632654 | 0.0 |
30296 | 30296 | Adventist Health Mendocino Coast | 51325 | 2021-01-22 | Mendocino | 45 | Northern California | 0.0 | 2.2857142857142856 | 1.7142857142857142 | 4.0 | 0.4285714285714285 | 0.0 |
30299 | 30299 | Adventist Health St. Helena | 50013 | 2021-01-22 | Napa | 55 | Bay Area | 0.0 | 1.7142857142857144 | 7.285714285714286 | 9.0 | 0.8095238095238095 | 0.0 |
30301 | 30301 | Adventist Health Tulare | 50784 | 2021-01-22 | Tulare | 107 | San Joaquin Valley | 0.0 | 0.5714285714285716 | 3.571428571428572 | 4.142857142857143 | 0.8620689655172413 | 0.0 |
30316 | 30316 | Barlow Respiratory Hospital | 52031 | 2021-01-22 | Los Angeles | 37 | Southern California | 0.0 | 4.0 | 2.0 | 6.0 | 0.3333333333333333 | 0.0 |
30323 | 30323 | California Pacific Medical Ctr-davies Campus Hosp | 50008 | 2021-01-22 | San Francisco | 75 | Bay Area | 0.0 | 1.7142857142857144 | 6.285714285714286 | 8.0 | 0.7857142857142857 | 0.0 |
30334 | 30334 | Colusa Medical Center | 50783 | 2021-01-22 | Colusa | 11 | Greater Sacramento | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
30359 | 30359 | Fairchild Medical Center | 51316 | 2021-01-22 | Siskiyou | 93 | Northern California | 0.0 | 1.1428571428571428 | 2.857142857142857 | 4.0 | 0.7142857142857143 | 0.0 |
30363 | 30363 | Fresno Heart and Surgical Hospital | 50732 | 2021-01-22 | Fresno | 19 | San Joaquin Valley | 0.0 | 0.7142857142857135 | 8.285714285714286 | 9.0 | 0.9206349206349208 | 0.0 |
30368 | 30368 | Goleta Valley Cottage Hospital | 50357 | 2021-01-22 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.5714285714285714 | 0.5714285714285714 | 1.0 | 0.0 |
30369 | 30369 | Good Samaritan Hospital | 50257 | 2021-01-22 | Kern | 29 | San Joaquin Valley | 0.0 | 4.0 | 0.0 | 4.0 | 0.0 | |
30421 | 30421 | Kindred Hospital - Los Angeles | 52032 | 2021-01-22 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 5.0 | 5.0 | 1.0 | 0.0 |
30422 | 30422 | Kindred Hospital - San Diego | 52036 | 2021-01-22 | San Diego | 73 | Southern California | 0.0 | 2.0 | 6.0 | 8.0 | 0.75 | 0.0 |
30423 | 30423 | Kindred Hospital - San Francisco Bay Area | 52034 | 2021-01-22 | Alameda | 1 | Bay Area | 0.0 | 0.8571428571428577 | 9.142857142857142 | 10.0 | 0.9142857142857144 | 0.0 |
30425 | 30425 | Kindred Hospital Baldwin Park | 52045 | 2021-01-22 | Los Angeles | 37 | Southern California | 0.0 | 0.2857142857142856 | 7.714285714285714 | 8.0 | 0.9642857142857144 | 0.0 |
30426 | 30426 | Kindred Hospital Brea | 52039 | 2021-01-22 | Orange | 59 | Southern California | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
30427 | 30427 | Kindred Hospital Ontario | 52037 | 2021-01-22 | San Bernardino | 71 | Southern California | 0.0 | 3.7142857142857135 | 7.285714285714286 | 11.0 | 0.6623376623376623 | 0.0 |
30429 | 30429 | Kindred Hospital Rancho | 52049 | 2021-01-22 | San Bernardino | 71 | Southern California | 0.0 | 0.0 | 8.0 | 8.0 | 1.0 | 0.0 |
30430 | 30430 | Kindred Hospital Riverside | 52052 | 2021-01-22 | Riverside | 65 | Southern California | 0.0 | 0.0 | 8.0 | 8.0 | 1.0 | 0.0 |
30449 | 30449 | Mammoth Hospital | 51303 | 2021-01-22 | Mono | 51 | Southern California | 0.0 | 1.4285714285714286 | 0.5714285714285714 | 2.0 | 0.2857142857142857 | 0.0 |
30466 | 30466 | Mercy Medical Center Mt Shasta | 51319 | 2021-01-22 | Siskiyou | 93 | Northern California | 0.0 | 3.428571428571429 | 0.5714285714285714 | 4.0 | 0.1428571428571428 | 0.0 |
30472 | 30472 | Monrovia Memorial Hospital | 52054 | 2021-01-22 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
30477 | 30477 | Northern Inyo Hospital | 51324 | 2021-01-22 | Inyo | 27 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
30481 | 30481 | Ojai Valley Community Hospital | 51334 | 2021-01-22 | Ventura | 111 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
30484 | 30484 | Orchard Hospital | 51311 | 2021-01-22 | Butte | 7 | Greater Sacramento | 0.0 | 3.0 | 1.0 | 4.0 | 0.25 | 0.0 |
30504 | 30504 | Providence Redwood Memorial Hospital | 51318 | 2021-01-22 | Humboldt | 23 | Northern California | 0.0 | 1.0 | 3.0 | 4.0 | 0.75 | 0.0 |
30544 | 30544 | Sonoma Specialty Hospital | 52057 | 2021-01-22 | Sonoma | 97 | Bay Area | 0.0 | 0.0 | 5.0 | 5.0 | 1.0 | 0.0 |
30545 | 30545 | Sonoma Valley Hospital | 50090 | 2021-01-22 | Sonoma | 97 | Bay Area | 0.0 | 5.285714285714286 | 0.7142857142857143 | 6.0 | 0.119047619047619 | 0.0 |
30562 | 30562 | Sutter Coast Hospital | 50417 | 2021-01-22 | Del Norte | 15 | Northern California | 0.0 | 2.2857142857142856 | 3.7142857142857135 | 6.0 | 0.6190476190476191 | 0.0 |
30571 | 30571 | Tahoe Forest Hospital | 51328 | 2021-01-22 | Nevada | 57 | Greater Sacramento | 0.0 | 2.7142857142857144 | 3.2857142857142856 | 6.0 | 0.5476190476190476 | 0.0 |
30579 | 30579 | USC Kenneth Norris Jr Cancer Hospital | 50660 | 2021-01-22 | Los Angeles | 37 | Southern California | 0.0 | 0.5714285714285712 | 2.857142857142857 | 3.4285714285714284 | 0.8333333333333334 | 0.0 |
30586 | 30586 | Vibra Hospital of Sacramento | 52033 | 2021-01-22 | Sacramento | 67 | Greater Sacramento | 0.0 | 0.1428571428571432 | 5.857142857142857 | 6.0 | 0.9761904761904762 | 0.0 |
30584 | 30584 | Valley Children's Hospital | 53300 | 2021-01-22 | Fresno | 19 | San Joaquin Valley | 0.5714285714285714 | 0.0 | 14.428571428571429 | 14.428571428571429 | 1.0 | 0.0396039603960396 |
30447 | 30447 | Mad River Community Hospital | 50028 | 2021-01-22 | Humboldt | 23 | Northern California | 0.8571428571428571 | 5.0 | 1.0 | 6.0 | 0.1666666666666666 | 0.8571428571428571 |
30324 | 30324 | Casa Colina Hospital | 50782 | 2021-01-22 | Los Angeles | 37 | Southern California | 1.0 | 2.0 | 4.0 | 6.0 | 0.6666666666666666 | 0.25 |
30374 | 30374 | Healdsburg Hospital | 51321 | 2021-01-22 | Sonoma | 97 | Bay Area | 1.0 | 4.0 | 1.0 | 5.0 | 0.2 | 1.0 |
30550 | 30550 | St. Elizabeth Community Hospital | 50042 | 2021-01-22 | Tehama | 103 | Northern California | 1.1428571428571428 | 1.0 | 7.0 | 8.0 | 0.875 | 0.1632653061224489 |
30540 | 30540 | Shasta Regional Medical Center | 50764 | 2021-01-22 | Shasta | 89 | Northern California | 1.2857142857142858 | 8.571428571428571 | 13.428571428571429 | 22.0 | 0.6103896103896104 | 0.0957446808510638 |
30452 | 30452 | Mark Twain Medical Center | 51332 | 2021-01-22 | Calaveras | 9 | San Joaquin Valley | 1.4285714285714286 | 9.333333333333334 | 2.6666666666666665 | 12.0 | 0.2222222222222222 | 0.5357142857142858 |
30480 | 30480 | Oak Valley Hospital District | 50067 | 2021-01-22 | Stanislaus | 99 | San Joaquin Valley | 1.5714285714285714 | 1.8571428571428568 | 3.142857142857143 | 5.0 | 0.6285714285714286 | 0.5 |
30531 | 30531 | Santa Paula Hospital | 2021-01-22 | Ventura | 111 | Southern California | 1.5714285714285714 | 0.1428571428571432 | 5.857142857142857 | 6.0 | 0.9761904761904762 | 0.2682926829268293 | |
30467 | 30467 | Mercy Medical Center Redding | 50280 | 2021-01-22 | Shasta | 89 | Northern California | 1.7142857142857142 | 5.0 | 28.0 | 33.0 | 0.8484848484848485 | 0.0612244897959183 |
30565 | 30565 | Sutter Lakeside Hospital | 51329 | 2021-01-22 | Lake | 33 | Northern California | 1.7142857142857142 | 1.5714285714285716 | 2.4285714285714284 | 4.0 | 0.6071428571428571 | 0.7058823529411765 |
30298 | 30298 | Adventist Health Sonora | 50335 | 2021-01-22 | Tuolumne | 109 | San Joaquin Valley | 1.8571428571428568 | 2.142857142857143 | 3.857142857142857 | 6.0 | 0.6428571428571429 | 0.4814814814814815 |
30328 | 30328 | Chinese Hospital | 50407 | 2021-01-22 | San Francisco | 75 | Bay Area | 1.8571428571428568 | 1.8571428571428568 | 4.142857142857143 | 6.0 | 0.6904761904761906 | 0.4482758620689654 |
30561 | 30561 | Sutter Auburn Faith Hospital | 50498 | 2021-01-22 | Placer | 61 | Greater Sacramento | 1.8571428571428568 | 3.1428571428571432 | 4.857142857142857 | 8.0 | 0.6071428571428571 | 0.3823529411764706 |
30451 | 30451 | Marinhealth Medical Center | 50360 | 2021-01-22 | Marin | 41 | Bay Area | 2.0 | 5.285714285714287 | 13.714285714285714 | 19.0 | 0.7218045112781954 | 0.1458333333333333 |
30479 | 30479 | Novato Community Hospital | 50131 | 2021-01-22 | Marin | 41 | Bay Area | 2.0 | 3.0 | 3.0 | 6.0 | 0.5 | 0.6666666666666666 |
30291 | 30291 | Adventist Health Clearlake | 51317 | 2021-01-22 | Lake | 33 | Northern California | 2.142857142857143 | 0.1428571428571428 | 3.857142857142857 | 4.0 | 0.9642857142857144 | 0.5555555555555556 |
30556 | 30556 | St. Mary's Medical Center | 50457 | 2021-01-22 | San Francisco | 75 | Bay Area | 2.142857142857143 | 17.571428571428573 | 8.0 | 25.571428571428573 | 0.3128491620111732 | 0.2678571428571428 |
30486 | 30486 | Pacifica Hospital of the Valley | 50378 | 2021-01-22 | Los Angeles | 37 | Southern California | 2.2 | 1.6000000000000014 | 17.4 | 19.0 | 0.9157894736842104 | 0.1264367816091954 |
30302 | 30302 | Adventist Health Ukiah Valley | 50301 | 2021-01-22 | Mendocino | 45 | Northern California | 2.2857142857142856 | 6.857142857142857 | 5.714285714285714 | 12.571428571428571 | 0.4545454545454546 | 0.3999999999999999 |
30564 | 30564 | Sutter Delta Medical Center | 50523 | 2021-01-22 | Contra Costa | 13 | Bay Area | 2.2857142857142856 | 1.1428571428571423 | 10.857142857142858 | 12.0 | 0.9047619047619048 | 0.2105263157894736 |
30589 | 30589 | Watsonville Community Hospital | 50194 | 2021-01-22 | Santa Cruz | 87 | Bay Area | 2.2857142857142856 | 1.1428571428571432 | 4.857142857142857 | 6.0 | 0.8095238095238094 | 0.4705882352941176 |
30542 | 30542 | Sierra Nevada Memorial Hospital | 50150 | 2021-01-22 | Nevada | 57 | Greater Sacramento | 2.5 | 1.666666666666667 | 6.333333333333333 | 8.0 | 0.7916666666666666 | 0.3947368421052631 |
30292 | 30292 | Adventist Health Delano | 50608 | 2021-01-22 | Kern | 29 | San Joaquin Valley | 2.571428571428572 | 2.428571428571429 | 9.0 | 11.428571428571429 | 0.7875 | 0.2857142857142857 |
30512 | 30512 | Ridgecrest Regional Hospital | 51333 | 2021-01-22 | Kern | 29 | San Joaquin Valley | 2.571428571428572 | 0.2857142857142856 | 3.7142857142857135 | 4.0 | 0.9285714285714286 | 0.6923076923076923 |
30518 | 30518 | Saint Francis Memorial Hospital | 50152 | 2021-01-22 | San Francisco | 75 | Bay Area | 2.571428571428572 | 12.0 | 8.0 | 20.0 | 0.4 | 0.3214285714285714 |
30440 | 30440 | Loma Linda University Children's Hospital | 50778 | 2021-01-22 | San Bernardino | 71 | Southern California | 2.7142857142857144 | 0.2857142857142856 | 3.142857142857143 | 3.4285714285714284 | 0.9166666666666669 | 0.8636363636363636 |
30428 | 30428 | Kindred Hospital Paramount | 52046 | 2021-01-22 | Los Angeles | 37 | Southern California | 2.857142857142857 | 0.7142857142857135 | 11.285714285714286 | 12.0 | 0.9404761904761906 | 0.2531645569620253 |
30300 | 30300 | Adventist Health Tehachapi Valley | 51301 | 2021-01-22 | Kern | 29 | San Joaquin Valley | 3.0 | 4.428571428571429 | 4.571428571428571 | 9.0 | 0.5079365079365079 | 0.65625 |
30424 | 30424 | Kindred Hospital -- La Mirada | 52038 | 2021-01-22 | Los Angeles | 37 | Southern California | 3.0 | 1.428571428571427 | 17.571428571428573 | 19.0 | 0.924812030075188 | 0.1707317073170731 |
30491 | 30491 | Petaluma Valley Hospital | 50136 | 2021-01-22 | Sonoma | 97 | Bay Area | 3.0 | 0.4285714285714279 | 4.142857142857143 | 4.571428571428571 | 0.90625 | 0.7241379310344827 |
30318 | 30318 | Barton Memorial Hospital | 50352 | 2021-01-22 | El Dorado | 17 | Greater Sacramento | 3.142857142857143 | 3.0 | 5.0 | 8.0 | 0.625 | 0.6285714285714286 |
30387 | 30387 | Kaiser Foundation Hospital | 50510 | 2021-01-22 | Marin | 41 | Bay Area | 3.142857142857143 | 0.4285714285714288 | 4.714285714285714 | 5.142857142857143 | 0.9166666666666666 | 0.6666666666666666 |
30437 | 30437 | LAC/Rancho Los Amigos National Rehabilitation Center | 50717 | 2021-01-22 | Los Angeles | 37 | Southern California | 3.4285714285714284 | 1.7142857142857144 | 6.285714285714286 | 8.0 | 0.7857142857142857 | 0.5454545454545454 |
30455 | 30455 | Memorial Hospital Los Banos | 50528 | 2021-01-22 | Merced | 47 | San Joaquin Valley | 3.4285714285714284 | 0.2857142857142865 | 4.857142857142857 | 5.142857142857143 | 0.9444444444444444 | 0.7058823529411765 |
30397 | 30397 | Kaiser Foundation Hospital - Redwood City | 50541 | 2021-01-22 | San Mateo | 81 | Bay Area | 3.571428571428572 | 1.2857142857142865 | 13.714285714285714 | 15.0 | 0.9142857142857144 | 0.2604166666666667 |
30485 | 30485 | Oroville Hospital | 50030 | 2021-01-22 | Butte | 7 | Greater Sacramento | 3.571428571428572 | 2.428571428571429 | 7.571428571428571 | 10.0 | 0.7571428571428571 | 0.4716981132075472 |
30507 | 30507 | Providence St. Joseph Hospital | 50006 | 2021-01-22 | Humboldt | 23 | Northern California | 3.571428571428572 | 6.285714285714287 | 11.714285714285714 | 18.0 | 0.6507936507936507 | 0.3048780487804878 |
30333 | 30333 | College Medical Center | 50776 | 2021-01-22 | Los Angeles | 37 | Southern California | 3.7142857142857135 | 1.5714285714285712 | 6.428571428571429 | 8.0 | 0.8035714285714286 | 0.5777777777777777 |
30348 | 30348 | Dominican Hospital | 50242 | 2021-01-22 | Santa Cruz | 87 | Bay Area | 3.7142857142857135 | 0.5714285714285712 | 15.428571428571429 | 16.0 | 0.9642857142857144 | 0.2407407407407407 |
30377 | 30377 | Hi-desert Medical Center | 50279 | 2021-01-22 | San Bernardino | 71 | Southern California | 3.7142857142857135 | 0.1428571428571428 | 3.857142857142857 | 4.0 | 0.9642857142857144 | 0.962962962962963 |
30453 | 30453 | Marshall Medical Center | 50254 | 2021-01-22 | El Dorado | 17 | Greater Sacramento | 3.7142857142857135 | 1.5714285714285712 | 10.142857142857142 | 11.714285714285714 | 0.8658536585365854 | 0.3661971830985915 |
30330 | 30330 | City of Hope Helford Clinical Research Hospital | 50146 | 2021-01-22 | Los Angeles | 37 | Southern California | 3.857142857142857 | 2.1428571428571423 | 15.857142857142858 | 18.0 | 0.8809523809523809 | 0.2432432432432432 |
30305 | 30305 | Ahmc Seton Medical Center | 50289 | 2021-01-22 | San Mateo | 81 | Bay Area | 4.0 | 3.428571428571428 | 6.714285714285714 | 10.142857142857142 | 0.6619718309859155 | 0.5957446808510638 |
30438 | 30438 | La Palma Intercommunity Hospital | 50580 | 2021-01-22 | Orange | 59 | Southern California | 4.0 | 0.0 | 4.428571428571429 | 4.428571428571429 | 1.0 | 0.9032258064516128 |
30362 | 30362 | French Hospital Medical Center | 50232 | 2021-01-22 | San Luis Obispo | 79 | Southern California | 4.142857142857143 | 0.5714285714285712 | 9.857142857142858 | 10.428571428571429 | 0.9452054794520548 | 0.4202898550724638 |
30489 | 30489 | Palomar Medical Center Poway | 50636 | 2021-01-22 | San Diego | 73 | Southern California | 4.142857142857143 | 0.0 | 12.0 | 12.0 | 1.0 | 0.3452380952380953 |
30551 | 30551 | St. Johns Hospital Camarillo | 50616 | 2021-01-22 | Ventura | 111 | Southern California | 4.142857142857143 | 0.5714285714285721 | 6.571428571428571 | 7.142857142857143 | 0.92 | 0.6304347826086958 |
30322 | 30322 | California Pacific Medical Center- Van Ness Campus | 50047 | 2021-01-22 | San Francisco | 75 | Bay Area | 4.285714285714286 | 3.5714285714285694 | 32.42857142857143 | 36.0 | 0.9007936507936508 | 0.13215859030837 |
30357 | 30357 | Encino Hospital Medical Center | 50158 | 2021-01-22 | Los Angeles | 37 | Southern California | 4.285714285714286 | 0.0 | 5.285714285714286 | 5.285714285714286 | 1.0 | 0.8108108108108109 |
30358 | 30358 | Enloe Medical Center | 50039 | 2021-01-22 | Butte | 7 | Greater Sacramento | 4.428571428571429 | 5.428571428571427 | 18.571428571428573 | 24.0 | 0.7738095238095238 | 0.2384615384615384 |
30433 | 30433 | LA Downtown Medical Center, LLC | 50763 | 2021-01-22 | Los Angeles | 37 | Southern California | 4.428571428571429 | 0.0 | 12.0 | 12.0 | 1.0 | 0.369047619047619 |
30568 | 30568 | Sutter Santa Rosa Regional Hospital | 50291 | 2021-01-22 | Sonoma | 97 | Bay Area | 4.428571428571429 | 0.1428571428571423 | 11.857142857142858 | 12.0 | 0.988095238095238 | 0.3734939759036144 |
30321 | 30321 | California Pacific Medical Center - Mission Bernal | 50055 | 2021-01-22 | San Francisco | 75 | Bay Area | 4.571428571428571 | 2.2857142857142856 | 7.714285714285714 | 10.0 | 0.7714285714285715 | 0.5925925925925926 |
30574 | 30574 | Tenet Health Central Twin Cities Community Hosp | 50633 | 2021-01-22 | San Luis Obispo | 79 | Southern California | 4.571428571428571 | 4.142857142857143 | 5.857142857142857 | 10.0 | 0.5857142857142856 | 0.7804878048780488 |
30563 | 30563 | Sutter Davis Hospital | 50537 | 2021-01-22 | Yolo | 113 | Greater Sacramento | 4.857142857142857 | 0.0 | 6.0 | 6.0 | 1.0 | 0.8095238095238094 |
30573 | 30573 | Tenet Health Central Coast Sierra Vista Rmc | 50506 | 2021-01-22 | San Luis Obispo | 79 | Southern California | 4.857142857142857 | 7.571428571428571 | 9.428571428571429 | 17.0 | 0.5546218487394958 | 0.5151515151515151 |
30443 | 30443 | Lompoc Valley Medical Center | 50110 | 2021-01-22 | Santa Barbara | 83 | Southern California | 5.0 | 0.0 | 6.0 | 6.0 | 1.0 | 0.8333333333333334 |
30295 | 30295 | Adventist Health Lodi Memorial | 50336 | 2021-01-22 | San Joaquin | 77 | San Joaquin Valley | 5.142857142857143 | 1.428571428571427 | 16.714285714285715 | 18.142857142857142 | 0.9212598425196852 | 0.3076923076923077 |
30431 | 30431 | Kindred Hospital South Bay | 52050 | 2021-01-22 | Los Angeles | 37 | Southern California | 5.142857142857143 | 0.1428571428571423 | 8.857142857142858 | 9.0 | 0.9841269841269842 | 0.5806451612903226 |
30373 | 30373 | Hazel Hawkins Memorial Hospital | 51337 | 2021-01-22 | San Benito | 69 | San Joaquin Valley | 5.285714285714286 | 0.4285714285714288 | 6.571428571428571 | 7.0 | 0.9387755102040816 | 0.8043478260869565 |
30570 | 30570 | Sutter Tracy Community Hospital | 50313 | 2021-01-22 | San Joaquin | 77 | San Joaquin Valley | 5.285714285714286 | 0.4285714285714288 | 8.0 | 8.428571428571429 | 0.9491525423728814 | 0.6607142857142857 |
30356 | 30356 | Emanuel Medical Center | 50179 | 2021-01-22 | Stanislaus | 99 | San Joaquin Valley | 5.428571428571429 | 2.1428571428571423 | 9.857142857142858 | 12.0 | 0.8214285714285715 | 0.5507246376811594 |
30474 | 30474 | Monterey Park Hospital | 50736 | 2021-01-22 | Los Angeles | 37 | Southern California | 5.428571428571429 | 0.0 | 8.142857142857142 | 8.142857142857142 | 1.0 | 0.6666666666666667 |
30526 | 30526 | San Mateo Medical Center | 50113 | 2021-01-22 | San Mateo | 81 | Bay Area | 5.571428571428571 | 0.5714285714285712 | 6.428571428571429 | 7.0 | 0.9183673469387756 | 0.8666666666666666 |
30306 | 30306 | Alameda Hospital | 50211 | 2021-01-22 | Alameda | 1 | Bay Area | 5.714285714285714 | 1.5714285714285712 | 6.428571428571429 | 8.0 | 0.8035714285714286 | 0.8888888888888888 |
30360 | 30360 | Foothill Regional Medical Center | 50780 | 2021-01-22 | Orange | 59 | Southern California | 5.714285714285714 | 5.285714285714286 | 7.714285714285714 | 13.0 | 0.5934065934065934 | 0.7407407407407407 |
30470 | 30470 | Mills-peninsula Medical Center | 50007 | 2021-01-22 | San Mateo | 81 | Bay Area | 5.714285714285714 | 4.571428571428573 | 19.428571428571427 | 24.0 | 0.8095238095238094 | 0.2941176470588235 |
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 );