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-02-05 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29678 | 29678 | Adventist Health Clearlake | 51317 | 2021-02-05 | Lake | 33 | Northern California | 0.0 | 0.8571428571428572 | 2.857142857142857 | 3.7142857142857135 | 0.7692307692307693 | 0.0 |
29679 | 29679 | Adventist Health Delano | 50608 | 2021-02-05 | Kern | 29 | San Joaquin Valley | 0.0 | 0.4285714285714288 | 6.285714285714286 | 6.714285714285714 | 0.9361702127659576 | 0.0 |
29683 | 29683 | Adventist Health Mendocino Coast | 51325 | 2021-02-05 | Mendocino | 45 | Northern California | 0.0 | 2.571428571428571 | 1.4285714285714286 | 4.0 | 0.3571428571428571 | 0.0 |
29688 | 29688 | Adventist Health Tulare | 50784 | 2021-02-05 | Tulare | 107 | San Joaquin Valley | 0.0 | 1.4285714285714284 | 2.571428571428572 | 4.0 | 0.6428571428571429 | 0.0 |
29703 | 29703 | Barlow Respiratory Hospital | 52031 | 2021-02-05 | Los Angeles | 37 | Southern California | 0.0 | 4.714285714285714 | 1.2857142857142858 | 6.0 | 0.2142857142857143 | 0.0 |
29705 | 29705 | Barton Memorial Hospital | 50352 | 2021-02-05 | El Dorado | 17 | Greater Sacramento | 0.0 | 5.571428571428571 | 2.4285714285714284 | 8.0 | 0.3035714285714285 | 0.0 |
29710 | 29710 | California Pacific Medical Ctr-davies Campus Hosp | 50008 | 2021-02-05 | San Francisco | 75 | Bay Area | 0.0 | 1.5714285714285712 | 6.428571428571429 | 8.0 | 0.8035714285714286 | 0.0 |
29711 | 29711 | Casa Colina Hospital | 50782 | 2021-02-05 | Los Angeles | 37 | Southern California | 0.0 | 3.7142857142857135 | 2.2857142857142856 | 6.0 | 0.3809523809523809 | 0.0 |
29722 | 29722 | Colusa Medical Center | 50783 | 2021-02-05 | Colusa | 11 | Greater Sacramento | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
29751 | 29751 | Fresno Heart and Surgical Hospital | 50732 | 2021-02-05 | Fresno | 19 | San Joaquin Valley | 0.0 | 0.7142857142857135 | 8.285714285714286 | 9.0 | 0.9206349206349208 | 0.0 |
29756 | 29756 | Good Samaritan Hospital | 50257 | 2021-02-05 | Kern | 29 | San Joaquin Valley | 0.0 | 4.0 | 0.0 | 4.0 | 0.0 | |
29761 | 29761 | Healdsburg Hospital | 51321 | 2021-02-05 | Sonoma | 97 | Bay Area | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
29808 | 29808 | Kindred Hospital - Los Angeles | 52032 | 2021-02-05 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 5.0 | 5.0 | 1.0 | 0.0 |
29809 | 29809 | Kindred Hospital - San Diego | 52036 | 2021-02-05 | San Diego | 73 | Southern California | 0.0 | 2.0 | 6.0 | 8.0 | 0.75 | 0.0 |
29810 | 29810 | Kindred Hospital - San Francisco Bay Area | 52034 | 2021-02-05 | Alameda | 1 | Bay Area | 0.0 | 0.0 | 10.0 | 10.0 | 1.0 | 0.0 |
29812 | 29812 | Kindred Hospital Baldwin Park | 52045 | 2021-02-05 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 8.0 | 8.0 | 1.0 | 0.0 |
29813 | 29813 | Kindred Hospital Brea | 52039 | 2021-02-05 | Orange | 59 | Southern California | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
29814 | 29814 | Kindred Hospital Ontario | 52037 | 2021-02-05 | San Bernardino | 71 | Southern California | 0.0 | 4.142857142857143 | 6.857142857142857 | 11.0 | 0.6233766233766234 | 0.0 |
29816 | 29816 | Kindred Hospital Rancho | 52049 | 2021-02-05 | San Bernardino | 71 | Southern California | 0.0 | 0.4285714285714288 | 7.571428571428571 | 8.0 | 0.9464285714285714 | 0.0 |
29817 | 29817 | Kindred Hospital Riverside | 52052 | 2021-02-05 | Riverside | 65 | Southern California | 0.0 | 0.0 | 8.0 | 8.0 | 1.0 | 0.0 |
29819 | 29819 | Kindred Hospital Westminster | 52035 | 2021-02-05 | Orange | 59 | Southern California | 0.0 | 0.0 | 16.0 | 16.0 | 1.0 | 0.0 |
29835 | 29835 | Mammoth Hospital | 51303 | 2021-02-05 | Mono | 51 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
29839 | 29839 | Marshall Medical Center | 50254 | 2021-02-05 | El Dorado | 17 | Greater Sacramento | 0.0 | 3.571428571428572 | 5.285714285714286 | 8.857142857142858 | 0.596774193548387 | 0.0 |
29852 | 29852 | Mercy Medical Center Mt Shasta | 51319 | 2021-02-05 | Siskiyou | 93 | Northern California | 0.0 | 3.142857142857143 | 0.8571428571428571 | 4.0 | 0.2142857142857142 | 0.0 |
29858 | 29858 | Monrovia Memorial Hospital | 52054 | 2021-02-05 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
29867 | 29867 | Ojai Valley Community Hospital | 51334 | 2021-02-05 | Ventura | 111 | Southern California | 0.0 | 3.4285714285714284 | 0.0 | 3.4285714285714284 | 0.0 | |
29870 | 29870 | Orchard Hospital | 51311 | 2021-02-05 | Butte | 7 | Greater Sacramento | 0.0 | 2.428571428571429 | 1.5714285714285714 | 4.0 | 0.3928571428571428 | 0.0 |
29926 | 29926 | Shasta Regional Medical Center | 50764 | 2021-02-05 | Shasta | 89 | Northern California | 0.0 | 14.142857142857142 | 7.857142857142857 | 22.0 | 0.3571428571428571 | 0.0 |
29947 | 29947 | Sutter Auburn Faith Hospital | 50498 | 2021-02-05 | Placer | 61 | Greater Sacramento | 0.0 | 4.857142857142858 | 3.142857142857143 | 8.0 | 0.3928571428571428 | 0.0 |
29948 | 29948 | Sutter Coast Hospital | 50417 | 2021-02-05 | Del Norte | 15 | Northern California | 0.0 | 2.2857142857142856 | 3.7142857142857135 | 6.0 | 0.6190476190476191 | 0.0 |
29951 | 29951 | Sutter Lakeside Hospital | 51329 | 2021-02-05 | Lake | 33 | Northern California | 0.0 | 1.1428571428571428 | 2.857142857142857 | 4.0 | 0.7142857142857143 | 0.0 |
29957 | 29957 | Tahoe Forest Hospital | 51328 | 2021-02-05 | Nevada | 57 | Greater Sacramento | 0.0 | 3.4285714285714284 | 2.571428571428572 | 6.0 | 0.4285714285714286 | 0.0 |
29965 | 29965 | USC Kenneth Norris Jr Cancer Hospital | 50660 | 2021-02-05 | Los Angeles | 37 | Southern California | 0.0 | 0.4285714285714284 | 1.8571428571428568 | 2.2857142857142856 | 0.8125000000000001 | 0.0 |
29973 | 29973 | Vibra Hospital of Sacramento | 52033 | 2021-02-05 | Sacramento | 67 | Greater Sacramento | 0.0 | 0.1428571428571432 | 5.857142857142857 | 6.0 | 0.9761904761904762 | 0.0 |
29890 | 29890 | Providence Redwood Memorial Hospital | 51318 | 2021-02-05 | Humboldt | 23 | Northern California | 0.5714285714285714 | 1.1428571428571428 | 2.857142857142857 | 4.0 | 0.7142857142857143 | 0.1999999999999999 |
29833 | 29833 | Mad River Community Hospital | 50028 | 2021-02-05 | Humboldt | 23 | Northern California | 0.7142857142857143 | 3.857142857142857 | 2.142857142857143 | 6.0 | 0.3571428571428571 | 0.3333333333333333 |
29930 | 29930 | Sonoma Specialty Hospital | 52057 | 2021-02-05 | Sonoma | 97 | Bay Area | 0.7142857142857143 | 2.142857142857143 | 2.857142857142857 | 5.0 | 0.5714285714285714 | 0.25 |
29686 | 29686 | Adventist Health St. Helena | 50013 | 2021-02-05 | Napa | 55 | Bay Area | 0.8571428571428571 | 0.2857142857142865 | 11.714285714285714 | 12.0 | 0.9761904761904762 | 0.073170731707317 |
29687 | 29687 | Adventist Health Tehachapi Valley | 51301 | 2021-02-05 | Kern | 29 | San Joaquin Valley | 0.8571428571428571 | 6.428571428571429 | 1.5714285714285714 | 8.0 | 0.1964285714285714 | 0.5454545454545454 |
29838 | 29838 | Mark Twain Medical Center | 51332 | 2021-02-05 | Calaveras | 9 | San Joaquin Valley | 1.0 | 9.285714285714286 | 2.142857142857143 | 11.428571428571429 | 0.1875 | 0.4666666666666667 |
29863 | 29863 | Northern Inyo Hospital | 51324 | 2021-02-05 | Inyo | 27 | Southern California | 1.0 | 1.0 | 1.0 | 2.0 | 0.5 | 1.0 |
29871 | 29871 | Oroville Hospital | 50030 | 2021-02-05 | Butte | 7 | Greater Sacramento | 1.0 | 3.2857142857142856 | 6.714285714285714 | 10.0 | 0.6714285714285715 | 0.1489361702127659 |
29928 | 29928 | Sierra Nevada Memorial Hospital | 50150 | 2021-02-05 | Nevada | 57 | Greater Sacramento | 1.0 | 1.5714285714285712 | 6.428571428571429 | 8.0 | 0.8035714285714286 | 0.1555555555555555 |
29685 | 29685 | Adventist Health Sonora | 50335 | 2021-02-05 | Tuolumne | 109 | San Joaquin Valley | 1.1428571428571428 | 0.7142857142857144 | 5.285714285714286 | 6.0 | 0.8809523809523809 | 0.2162162162162162 |
29708 | 29708 | California Pacific Medical Center - Mission Bernal | 50055 | 2021-02-05 | San Francisco | 75 | Bay Area | 1.1428571428571428 | 5.142857142857143 | 4.857142857142857 | 10.0 | 0.4857142857142856 | 0.2352941176470588 |
29681 | 29681 | Adventist Health Howard Memorial | 51310 | 2021-02-05 | Mendocino | 45 | Northern California | 1.2857142857142858 | 0.5714285714285716 | 3.4285714285714284 | 4.0 | 0.8571428571428571 | 0.375 |
29747 | 29747 | Fairchild Medical Center | 51316 | 2021-02-05 | Siskiyou | 93 | Northern California | 1.4285714285714286 | 0.2857142857142856 | 3.7142857142857135 | 4.0 | 0.9285714285714286 | 0.3846153846153846 |
29815 | 29815 | Kindred Hospital Paramount | 52046 | 2021-02-05 | Los Angeles | 37 | Southern California | 1.4285714285714286 | 0.1428571428571423 | 11.857142857142858 | 12.0 | 0.988095238095238 | 0.1204819277108433 |
29904 | 29904 | Saint Francis Memorial Hospital | 50152 | 2021-02-05 | San Francisco | 75 | Bay Area | 1.4285714285714286 | 11.571428571428571 | 8.428571428571429 | 20.0 | 0.4214285714285714 | 0.1694915254237288 |
29693 | 29693 | Alameda Hospital | 50211 | 2021-02-05 | Alameda | 1 | Bay Area | 1.5714285714285714 | 4.142857142857142 | 3.857142857142857 | 8.0 | 0.4821428571428571 | 0.4074074074074074 |
29750 | 29750 | French Hospital Medical Center | 50232 | 2021-02-05 | San Luis Obispo | 79 | Southern California | 1.5714285714285714 | 0.8571428571428559 | 8.857142857142858 | 9.714285714285714 | 0.911764705882353 | 0.1774193548387096 |
29764 | 29764 | Hi-desert Medical Center | 50279 | 2021-02-05 | San Bernardino | 71 | Southern California | 1.5714285714285714 | 1.1428571428571428 | 2.857142857142857 | 4.0 | 0.7142857142857143 | 0.5499999999999999 |
29848 | 29848 | Mercy General Hospital | 50017 | 2021-02-05 | Sacramento | 67 | Greater Sacramento | 1.5714285714285714 | 3.4285714285714306 | 26.142857142857142 | 29.571428571428573 | 0.8840579710144927 | 0.0601092896174863 |
29865 | 29865 | Novato Community Hospital | 50131 | 2021-02-05 | Marin | 41 | Bay Area | 1.5714285714285714 | 2.571428571428572 | 3.4285714285714284 | 6.0 | 0.5714285714285714 | 0.4583333333333333 |
29889 | 29889 | Providence Queen of the Valley Medical Center | 50009 | 2021-02-05 | Napa | 55 | Bay Area | 1.5714285714285714 | 3.571428571428571 | 7.0 | 10.571428571428571 | 0.6621621621621622 | 0.2244897959183673 |
29912 | 29912 | San Mateo Medical Center | 50113 | 2021-02-05 | San Mateo | 81 | Bay Area | 1.5714285714285714 | 0.3333333333333339 | 4.833333333333333 | 5.166666666666667 | 0.9354838709677418 | 0.3251231527093596 |
29931 | 29931 | Sonoma Valley Hospital | 50090 | 2021-02-05 | Sonoma | 97 | Bay Area | 1.6666666666666667 | 3.0 | 3.0 | 6.0 | 0.5 | 0.5555555555555556 |
29689 | 29689 | Adventist Health Ukiah Valley | 50301 | 2021-02-05 | Mendocino | 45 | Northern California | 1.7142857142857142 | 1.2857142857142856 | 5.714285714285714 | 7.0 | 0.8163265306122449 | 0.3 |
29877 | 29877 | Petaluma Valley Hospital | 50136 | 2021-02-05 | Sonoma | 97 | Bay Area | 1.7142857142857142 | 0.5714285714285716 | 3.2857142857142856 | 3.857142857142857 | 0.8518518518518519 | 0.5217391304347826 |
29946 | 29946 | Sutter Amador Hospital | 50014 | 2021-02-05 | Amador | 5 | Greater Sacramento | 1.7142857142857142 | 2.142857142857143 | 3.857142857142857 | 6.0 | 0.6428571428571429 | 0.4444444444444444 |
29716 | 29716 | Chinese Hospital | 50407 | 2021-02-05 | San Francisco | 75 | Bay Area | 1.8571428571428568 | 2.142857142857143 | 3.857142857142857 | 6.0 | 0.6428571428571429 | 0.4814814814814815 |
29866 | 29866 | Oak Valley Hospital District | 50067 | 2021-02-05 | Stanislaus | 99 | San Joaquin Valley | 2.0 | 3.0 | 2.0 | 5.0 | 0.4 | 1.0 |
29837 | 29837 | Marinhealth Medical Center | 50360 | 2021-02-05 | Marin | 41 | Bay Area | 2.142857142857143 | 9.714285714285714 | 9.285714285714286 | 19.0 | 0.4887218045112782 | 0.2307692307692307 |
29850 | 29850 | Mercy Hospital of Folsom | 50414 | 2021-02-05 | Sacramento | 67 | Greater Sacramento | 2.142857142857143 | 1.1428571428571432 | 6.857142857142857 | 8.0 | 0.8571428571428571 | 0.3125 |
29898 | 29898 | Ridgecrest Regional Hospital | 51333 | 2021-02-05 | Kern | 29 | San Joaquin Valley | 2.142857142857143 | 0.2857142857142856 | 3.7142857142857135 | 4.0 | 0.9285714285714286 | 0.5769230769230769 |
29917 | 29917 | Santa Paula Hospital | 2021-02-05 | Ventura | 111 | Southern California | 2.142857142857143 | 1.0 | 5.0 | 6.0 | 0.8333333333333334 | 0.4285714285714285 | |
29959 | 29959 | Tenet Health Central Coast Sierra Vista Rmc | 50506 | 2021-02-05 | San Luis Obispo | 79 | Southern California | 2.142857142857143 | 10.285714285714285 | 6.714285714285714 | 17.0 | 0.3949579831932773 | 0.3191489361702127 |
29682 | 29682 | Adventist Health Lodi Memorial | 50336 | 2021-02-05 | San Joaquin | 77 | San Joaquin Valley | 2.2857142857142856 | 2.571428571428572 | 7.714285714285714 | 10.285714285714286 | 0.75 | 0.2962962962962963 |
29949 | 29949 | Sutter Davis Hospital | 50537 | 2021-02-05 | Yolo | 113 | Greater Sacramento | 2.2857142857142856 | 1.7142857142857144 | 4.285714285714286 | 6.0 | 0.7142857142857143 | 0.5333333333333333 |
29954 | 29954 | Sutter Santa Rosa Regional Hospital | 50291 | 2021-02-05 | Sonoma | 97 | Bay Area | 2.2857142857142856 | 0.5714285714285712 | 11.428571428571429 | 12.0 | 0.9523809523809524 | 0.1999999999999999 |
29728 | 29728 | Contra Costa Regional Medical Center | 50276 | 2021-02-05 | Contra Costa | 13 | Bay Area | 2.4285714285714284 | 7.428571428571429 | 10.571428571428571 | 18.0 | 0.5873015873015873 | 0.2297297297297297 |
29936 | 29936 | St. Elizabeth Community Hospital | 50042 | 2021-02-05 | Tehama | 103 | Northern California | 2.4285714285714284 | 1.2857142857142856 | 6.714285714285714 | 8.0 | 0.8392857142857143 | 0.3617021276595744 |
29745 | 29745 | Encino Hospital Medical Center | 50158 | 2021-02-05 | Los Angeles | 37 | Southern California | 2.571428571428572 | 0.5714285714285716 | 3.4285714285714284 | 4.0 | 0.8571428571428571 | 0.7500000000000001 |
29774 | 29774 | Kaiser Foundation Hospital | 50510 | 2021-02-05 | Marin | 41 | Bay Area | 2.571428571428572 | 0.7142857142857144 | 5.571428571428571 | 6.285714285714286 | 0.8863636363636364 | 0.4615384615384616 |
29811 | 29811 | Kindred Hospital -- La Mirada | 52038 | 2021-02-05 | Los Angeles | 37 | Southern California | 2.571428571428572 | 1.7142857142857153 | 17.285714285714285 | 19.0 | 0.9097744360902256 | 0.1487603305785124 |
29820 | 29820 | LA Downtown Medical Center, LLC | 50763 | 2021-02-05 | Los Angeles | 37 | Southern California | 2.571428571428572 | 0.0 | 12.0 | 12.0 | 1.0 | 0.2142857142857143 |
29856 | 29856 | Mills-peninsula Medical Center | 50007 | 2021-02-05 | San Mateo | 81 | Bay Area | 2.571428571428572 | 7.0 | 17.0 | 24.0 | 0.7083333333333334 | 0.1512605042016807 |
29875 | 29875 | Palomar Medical Center Poway | 50636 | 2021-02-05 | San Diego | 73 | Southern California | 2.7142857142857144 | 3.571428571428571 | 8.428571428571429 | 12.0 | 0.7023809523809524 | 0.3220338983050848 |
29913 | 29913 | San Ramon Regional Medical Center | 50689 | 2021-02-05 | Contra Costa | 13 | Bay Area | 2.7142857142857144 | 5.0 | 7.0 | 12.0 | 0.5833333333333334 | 0.3877551020408163 |
29970 | 29970 | Valley Children's Hospital | 53300 | 2021-02-05 | Fresno | 19 | San Joaquin Valley | 2.857142857142857 | 0.0 | 3.571428571428572 | 3.571428571428572 | 1.0 | 0.7999999999999999 |
29872 | 29872 | Pacifica Hospital of the Valley | 50378 | 2021-02-05 | Los Angeles | 37 | Southern California | 3.0 | 0.7142857142857153 | 12.714285714285714 | 13.428571428571429 | 0.946808510638298 | 0.2359550561797753 |
29942 | 29942 | St. Mary's Medical Center | 50457 | 2021-02-05 | San Francisco | 75 | Bay Area | 3.0 | 9.571428571428571 | 6.428571428571429 | 16.0 | 0.4017857142857143 | 0.4666666666666667 |
29955 | 29955 | Sutter Solano Medical Center | 50101 | 2021-02-05 | Solano | 95 | Bay Area | 3.0 | 3.7142857142857135 | 8.285714285714286 | 12.0 | 0.6904761904761906 | 0.3620689655172413 |
29981 | 29981 | Woodland Memorial Hospital | 50127 | 2021-02-05 | Yolo | 113 | Greater Sacramento | 3.0 | 1.0 | 7.0 | 8.0 | 0.875 | 0.4285714285714285 |
29701 | 29701 | Bakersfield Heart Hospital | 50724 | 2021-02-05 | Kern | 29 | San Joaquin Valley | 3.142857142857143 | 0.4285714285714288 | 9.857142857142858 | 10.285714285714286 | 0.9583333333333331 | 0.3188405797101449 |
29882 | 29882 | Placentia Linda Hospital | 50589 | 2021-02-05 | Orange | 59 | Southern California | 3.142857142857143 | 5.428571428571429 | 6.571428571428571 | 12.0 | 0.5476190476190476 | 0.4782608695652174 |
29932 | 29932 | South Coast Global Medical Center | 50747 | 2021-02-05 | Orange | 59 | Southern California | 3.142857142857143 | 3.428571428571429 | 5.571428571428571 | 9.0 | 0.6190476190476191 | 0.5641025641025641 |
29718 | 29718 | City of Hope Helford Clinical Research Hospital | 50146 | 2021-02-05 | Los Angeles | 37 | Southern California | 3.2857142857142856 | 2.428571428571429 | 15.571428571428571 | 18.0 | 0.8650793650793651 | 0.2110091743119266 |
29853 | 29853 | Mercy Medical Center Redding | 50280 | 2021-02-05 | Shasta | 89 | Northern California | 3.2857142857142856 | 8.571428571428573 | 24.428571428571427 | 33.0 | 0.7402597402597402 | 0.1345029239766081 |
29893 | 29893 | Providence St. Joseph Hospital | 50006 | 2021-02-05 | Humboldt | 23 | Northern California | 3.2857142857142856 | 1.8571428571428577 | 16.142857142857142 | 18.0 | 0.8968253968253967 | 0.2035398230088495 |
29960 | 29960 | Tenet Health Central Twin Cities Community Hosp | 50633 | 2021-02-05 | San Luis Obispo | 79 | Southern California | 3.2857142857142856 | 4.571428571428571 | 5.428571428571429 | 10.0 | 0.5428571428571429 | 0.6052631578947368 |
29937 | 29937 | St. Johns Hospital Camarillo | 50616 | 2021-02-05 | Ventura | 111 | Southern California | 3.4285714285714284 | 1.0 | 4.714285714285714 | 5.714285714285714 | 0.825 | 0.7272727272727272 |
29760 | 29760 | Hazel Hawkins Memorial Hospital | 51337 | 2021-02-05 | San Benito | 69 | San Joaquin Valley | 3.571428571428572 | 1.0 | 6.0 | 7.0 | 0.8571428571428571 | 0.5952380952380952 |
29824 | 29824 | LAC/Rancho Los Amigos National Rehabilitation Center | 50717 | 2021-02-05 | Los Angeles | 37 | Southern California | 3.7142857142857135 | 0.4285714285714288 | 7.571428571428571 | 8.0 | 0.9464285714285714 | 0.4905660377358491 |
29829 | 29829 | Lompoc Valley Medical Center | 50110 | 2021-02-05 | Santa Barbara | 83 | Southern California | 3.7142857142857135 | 0.2857142857142856 | 5.714285714285714 | 6.0 | 0.9523809523809524 | 0.65 |
29841 | 29841 | Memorial Hospital Los Banos | 50528 | 2021-02-05 | Merced | 47 | San Joaquin Valley | 3.7142857142857135 | -0.7142857142857144 | 5.0 | 4.285714285714286 | 1.1666666666666667 | 0.7428571428571429 |
29860 | 29860 | Monterey Park Hospital | 50736 | 2021-02-05 | Los Angeles | 37 | Southern California | 3.7142857142857135 | 0.2857142857142856 | 4.428571428571429 | 4.714285714285714 | 0.9393939393939394 | 0.8387096774193549 |
29927 | 29927 | Sherman Oaks Hospital | 50755 | 2021-02-05 | Los Angeles | 37 | Southern California | 3.857142857142857 | 2.0 | 12.285714285714286 | 14.285714285714286 | 0.86 | 0.313953488372093 |
29709 | 29709 | California Pacific Medical Center- Van Ness Campus | 50047 | 2021-02-05 | San Francisco | 75 | Bay Area | 4.0 | 10.285714285714285 | 25.714285714285715 | 36.0 | 0.7142857142857143 | 0.1555555555555555 |
29712 | 29712 | Cedars-Sinai Marina Del Rey Hospital | 50740 | 2021-02-05 | Los Angeles | 37 | Southern California | 4.142857142857143 | 5.285714285714287 | 10.714285714285714 | 16.0 | 0.6696428571428571 | 0.3866666666666667 |
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 );