+---------+----------------------------------------------------+-------+------------+-----------------+--------+---------------------+----------------------------+----------------------------------+---------------------------------+--------------------------------+-----------------------------------+-----------------------------------+ | 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 | |---------+----------------------------------------------------+-------+------------+-----------------+--------+---------------------+----------------------------+----------------------------------+---------------------------------+--------------------------------+-----------------------------------+-----------------------------------| | 1 | Adventist Health Bakersfield | 50455 | 2022-12-23 | Kern | 29 | San Joaquin Valley | 0 | 0 | 14 | 14 | 1 | 0.0 | | 2 | Adventist Health Clearlake | 51317 | 2022-12-23 | Lake | 33 | Northern California | 0 | 0 | 4 | 4 | 1 | 0.0 | | 3 | Adventist Health Hanford | 50121 | 2022-12-23 | Kings | 31 | San Joaquin Valley | 0 | 2 | 13 | 15 | 0.866667 | 0.0 | | 4 | Adventist Health Howard Memorial | 51310 | 2022-12-23 | Mendocino | 45 | Northern California | 0 | 1.5 | 2.5 | 4 | 0.625 | 0.0 | | 5 | Adventist Health Lodi Memorial | 50336 | 2022-12-23 | San Joaquin | 77 | San Joaquin Valley | 4 | 0 | 10 | 10 | 1 | 0.4 | | 6 | Adventist Health Mendocino Coast | 51325 | 2022-12-23 | Mendocino | 45 | Northern California | 0 | 0 | 4 | 4 | 1 | 0.0 | | 7 | Adventist Health Simi Valley | 50236 | 2022-12-23 | Ventura | 111 | Southern California | 0 | 4 | 6 | 10 | 0.6 | 0.0 | | 8 | Adventist Health Sonora | 50335 | 2022-12-23 | Tuolumne | 109 | San Joaquin Valley | 0 | 1 | 5 | 6 | 0.833333 | 0.0 | | 9 | Adventist Health St. Helena | 50013 | 2022-12-23 | Napa | 55 | Bay Area | 0 | 0 | 7 | 7 | 1 | 0.0 | | 10 | Adventist Health Tehachapi Valley | 51301 | 2022-12-23 | Kern | 29 | San Joaquin Valley | 0 | 0 | 4 | 4 | 1 | 0.0 | | 11 | Adventist Health Tulare | 50784 | 2022-12-23 | Tulare | 107 | San Joaquin Valley | 0 | 4 | 0 | 4 | 0 | | | 12 | Adventist Health Ukiah Valley | 50301 | 2022-12-23 | Mendocino | 45 | Northern California | 0 | 0 | 8 | 8 | 1 | 0.0 | | 13 | Adventist Health and Rideout | 50133 | 2022-12-23 | Yuba | 115 | Greater Sacramento | 0 | 6 | 18 | 24 | 0.75 | 0.0 | | 14 | Ahmc Anaheim Regional Medical Center | 50226 | 2022-12-23 | Orange | 59 | Southern California | 0 | 0 | 10 | 10 | 1 | 0.0 | | 15 | Ahmc Seton Medical Center | 50289 | 2022-12-23 | San Mateo | 81 | Bay Area | 0 | 0 | 11 | 11 | 1 | 0.0 | | 16 | Alameda Hospital | 50211 | 2022-12-23 | Alameda | 1 | Bay Area | 1 | 0 | 8 | 8 | 1 | 0.125 | | 17 | Alhambra Hospital Medical Center | 50281 | 2022-12-23 | Los Angeles | 37 | Southern California | 0 | 3 | 9 | 12 | 0.75 | 0.0 | | 18 | Alta Bates Summit Medical Center | 50043 | 2022-12-23 | Alameda | 1 | Bay Area | 0 | 17 | 19 | 36 | 0.527778 | 0.0 | | 19 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305 | 2022-12-23 | Alameda | 1 | Bay Area | 0 | 17 | 13 | 30 | 0.433333 | 0.0 | | 20 | Alvarado Hospital Medical Center | 50757 | 2022-12-23 | San Diego | 73 | Southern California | 0 | 0 | 11 | 11 | 1 | 0.0 | | 21 | Anaheim Global Medical Center | 50744 | 2022-12-23 | Orange | 59 | Southern California | 0 | 18 | 4 | 22 | 0.181818 | 0.0 | | 22 | Antelope Valley Hospital | 50056 | 2022-12-23 | Los Angeles | 37 | Southern California | 7 | 0 | 28 | 28 | 1 | 0.25 | | 23 | Arrowhead Regional Medical Center | 50245 | 2022-12-23 | San Bernardino | 71 | Southern California | 6.5 | 13.5 | 34.5 | 48 | 0.71875 | 0.1884057971014492 | | 24 | Bakersfield Memorial Hospital | 50036 | 2022-12-23 | Kern | 29 | San Joaquin Valley | 5 | 0 | 26 | 26 | 1 | 0.1923076923076923 | | 25 | Barlow Respiratory Hospital | 52031 | 2022-12-23 | Los Angeles | 37 | Southern California | 0 | 2 | 4 | 6 | 0.666667 | 0.0 | | 26 | Beverly Hospital | 50350 | 2022-12-23 | Los Angeles | 37 | Southern California | 0 | 15 | 10 | 25 | 0.4 | 0.0 | | 27 | California Hospital Medical Center LA | 50149 | 2022-12-23 | Los Angeles | 37 | Southern California | 0 | 9 | 21 | 30 | 0.7 | 0.0 | | 28 | California Pacific Medical Center - Mission Bernal | 50055 | 2022-12-23 | San Francisco | 75 | Bay Area | 0 | 4 | 6 | 10 | 0.6 | 0.0 | | 29 | California Pacific Medical Center- Van Ness Campus | 50047 | 2022-12-23 | San Francisco | 75 | Bay Area | 6 | 2 | 34 | 36 | 0.944444 | 0.1764705882352941 | | 30 | California Pacific Medical Ctr-davies Campus Hosp | 50008 | 2022-12-23 | San Francisco | 75 | Bay Area | 0 | 0 | 8 | 8 | 1 | 0.0 | | 31 | Casa Colina Hospital | 50782 | 2022-12-23 | Los Angeles | 37 | Southern California | 0 | 2 | 4 | 6 | 0.666667 | 0.0 | | 32 | Cedars-Sinai Marina Del Rey Hospital | 50740 | 2022-12-23 | Los Angeles | 37 | Southern California | 0 | 4 | 8 | 12 | 0.666667 | 0.0 | | 33 | Cedars-Sinai Medical Center | 50625 | 2022-12-23 | Los Angeles | 37 | Southern California | 12 | 0 | 108 | 108 | 1 | 0.1111111111111111 | | 34 | Centinela Hospital Medical Center | 50739 | 2022-12-23 | Los Angeles | 37 | Southern California | 0 | 0 | 23 | 23 | 1 | 0.0 | | 35 | Chinese Hospital | 50407 | 2022-12-23 | San Francisco | 75 | Bay Area | 0 | 6 | 0 | 6 | 0 | | | 36 | Chino Valley Medical Center | 50586 | 2022-12-23 | San Bernardino | 71 | Southern California | 0 | 0 | 6 | 6 | 1 | 0.0 | | 37 | City of Hope Helford Clinical Research Hospital | 50146 | 2022-12-23 | Los Angeles | 37 | Southern California | 0 | 3 | 15 | 18 | 0.833333 | 0.0 | | 38 | Clovis Community Medical Center | 50492 | 2022-12-23 | Fresno | 19 | San Joaquin Valley | 0 | 11 | 13 | 24 | 0.541667 | 0.0 | | 39 | Coast Plaza Hospital | 50771 | 2022-12-23 | Los Angeles | 37 | Southern California | 0 | 1 | 6 | 7 | 0.857143 | 0.0 | | 40 | College Medical Center | 50776 | 2022-12-23 | Los Angeles | 37 | Southern California | 0 | 3 | 5 | 8 | 0.625 | 0.0 | | 41 | Community Hospital of Huntington Park | 50091 | 2022-12-23 | Los Angeles | 37 | Southern California | 0 | 0 | 4 | 4 | 1 | 0.0 | | 42 | Community Hospital of San Bernardino | 50089 | 2022-12-23 | San Bernardino | 71 | Southern California | 0 | 15 | 6 | 21 | 0.285714 | 0.0 | | 43 | Community Hospital of the Monterey Peninsula | 50145 | 2022-12-23 | Monterey | 53 | Bay Area | 0 | 9 | 17 | 26 | 0.653846 | 0.0 | | 44 | Community Memorial Hospital San Buenaventura | 50394 | 2022-12-23 | Ventura | 111 | Southern California | 4 | 1 | 16 | 17 | 0.941176 | 0.25 | | 45 | Community Regional Medical Center | 50060 | 2022-12-23 | Fresno | 19 | San Joaquin Valley | 11 | 7 | 84 | 91 | 0.923077 | 0.1309523809523809 | | 46 | Contra Costa Regional Medical Center | 50276 | 2022-12-23 | Contra Costa | 13 | Bay Area | 0 | 4 | 14 | 18 | 0.777778 | 0.0 | | 47 | Dameron Hospital | 50122 | 2022-12-23 | San Joaquin | 77 | San Joaquin Valley | 0 | 0 | 11 | 11 | 1 | 0.0 | | 48 | Desert Valley Hospital | 50709 | 2022-12-23 | San Bernardino | 71 | Southern California | 0 | 0 | 18 | 18 | 1 | 0.0 | | 49 | Doctors Hospital of Riverside, LLC | 50102 | 2022-12-23 | Riverside | 65 | Southern California | 0 | 8 | 4 | 12 | 0.333333 | 0.0 | | 50 | Dominican Hospital | 50242 | 2022-12-23 | Santa Cruz | 87 | Bay Area | 0 | 1 | 12 | 13 | 0.923077 | 0.0 | | 51 | East Los Angeles Doctors Hospital | 50641 | 2022-12-23 | Los Angeles | 37 | Southern California | 0 | 1.75 | 5.25 | 7 | 0.75 | 0.0 | | 52 | Eden Medical Center | 50488 | 2022-12-23 | Alameda | 1 | Bay Area | 0 | 0 | 24 | 24 | 1 | 0.0 | | 53 | Eisenhower Medical Center | 50573 | 2022-12-23 | Riverside | 65 | Southern California | 0 | 5 | 22 | 27 | 0.814815 | 0.0 | | 54 | El Camino Hospital | 50308 | 2022-12-23 | Santa Clara | 85 | Bay Area | 5 | 6 | 26 | 32 | 0.8125 | 0.1923076923076923 | | 55 | El Centro Regional Medical Center | 50045 | 2022-12-23 | Imperial | 25 | Southern California | 0 | 12 | 0 | 12 | 0 | | | 56 | Emanate Health Foothill Presbyterian Hospital | 50597 | 2022-12-23 | Los Angeles | 37 | Southern California | 0 | 3 | 15 | 18 | 0.833333 | 0.0 | | 57 | Emanate Health Inter-community Hospital | 50382 | 2022-12-23 | Los Angeles | 37 | Southern California | 6 | 7 | 34 | 41 | 0.829268 | 0.1764705882352941 | | 58 | Encino Hospital Medical Center | 50158 | 2022-12-23 | Los Angeles | 37 | Southern California | 0 | 2 | 5 | 7 | 0.714286 | 0.0 | | 59 | Enloe Medical Center | 50039 | 2022-12-23 | Butte | 7 | Greater Sacramento | 0 | 8 | 16 | 24 | 0.666667 | 0.0 | | 60 | Foothill Regional Medical Center | 50780 | 2022-12-23 | Orange | 59 | Southern California | 0 | 6 | 7 | 13 | 0.538462 | 0.0 | | 61 | French Hospital Medical Center | 50232 | 2022-12-23 | San Luis Obispo | 79 | Southern California | 0 | 0 | 7 | 7 | 1 | 0.0 | | 62 | Garfield Medical Center | 50737 | 2022-12-23 | Los Angeles | 37 | Southern California | 0 | 11 | 11 | 22 | 0.5 | 0.0 | | 63 | Glendale Adventist Medical Center | 50239 | 2022-12-23 | Los Angeles | 37 | Southern California | 0 | 0 | 21 | 21 | 1 | 0.0 | | 64 | Glendale Mem Hospital & Health Center | 50058 | 2022-12-23 | Los Angeles | 37 | Southern California | 0 | 3 | 13 | 16 | 0.8125 | 0.0 | | 65 | Good Samaritan Hospital | 50380 | 2022-12-23 | Santa Clara | 85 | Bay Area | 4.6 | 11 | 33.4 | 44.4 | 0.752252 | 0.1377245508982036 | | 66 | Greater El Monte Community Hospital | 50738 | 2022-12-23 | Los Angeles | 37 | Southern California | 0 | 18 | 6 | 24 | 0.25 | 0.0 | | 67 | Grossmont Hospital | 50026 | 2022-12-23 | San Diego | 73 | Southern California | 7 | 13 | 62 | 75 | 0.826667 | 0.1129032258064516 | | 68 | Hazel Hawkins Memorial Hospital | 51337 | 2022-12-23 | San Benito | 69 | San Joaquin Valley | 0 | 0 | 4 | 4 | 1 | 0.0 | | 69 | Healdsburg Hospital | 51321 | 2022-12-23 | Sonoma | 97 | Bay Area | 0 | 5 | 0 | 5 | 0 | | | 70 | Hemet Global Medical Center | 50390 | 2022-12-23 | Riverside | 65 | Southern California | 0 | 12 | 14 | 26 | 0.538462 | 0.0 | | 71 | Henry Mayo Newhall Hospital | 50624 | 2022-12-23 | Los Angeles | 37 | Southern California | 0 | 1 | 17 | 18 | 0.944444 | 0.0 | | 72 | Highland Hospital | 50320 | 2022-12-23 | Alameda | 1 | Bay Area | 2 | 8.5 | 24.5 | 33 | 0.742424 | 0.0816326530612244 | | 73 | Hoag Memorial Hospital Presbyterian | 50224 | 2022-12-23 | Orange | 59 | Southern California | 0 | 21 | 27 | 48 | 0.5625 | 0.0 | | 74 | Hollywood Presbyterian Medical Center | 50063 | 2022-12-23 | Los Angeles | 37 | Southern California | 0 | 8 | 16 | 24 | 0.666667 | 0.0 | | 75 | Huntington Beach Hospital | 50526 | 2022-12-23 | Orange | 59 | Southern California | 0 | 1 | 5 | 6 | 0.833333 | 0.0 | | 76 | Huntington Hospital | 50438 | 2022-12-23 | Los Angeles | 37 | Southern California | 0 | 6 | 16 | 22 | 0.727273 | 0.0 | | 77 | John Muir Medical Center - Concord Campus | 50496 | 2022-12-23 | Contra Costa | 13 | Bay Area | 0 | 8 | 28 | 36 | 0.777778 | 0.0 | | 78 | John Muir Medical Center - Walnut Creek Campus | 50180 | 2022-12-23 | Contra Costa | 13 | Bay Area | 0 | 6 | 42 | 48 | 0.875 | 0.0 | | 79 | Kaiser Foundation Hosp So Sacramento | 50674 | 2022-12-23 | Sacramento | 67 | Greater Sacramento | 8 | 2 | 22 | 24 | 0.916667 | 0.3636363636363636 | | 80 | Kaiser Foundation Hospital - Antioch | 50760 | 2022-12-23 | Contra Costa | 13 | Bay Area | 5 | 1 | 8 | 9 | 0.888889 | 0.625 | | 81 | Kaiser Foundation Hospital - Baldwin Park | 50723 | 2022-12-23 | Los Angeles | 37 | Southern California | 0 | 4 | 8 | 12 | 0.666667 | 0.0 | | 82 | Kaiser Foundation Hospital - Downey | 50139 | 2022-12-23 | Los Angeles | 37 | Southern California | 0 | 10 | 18 | 28 | 0.642857 | 0.0 | | 83 | Kaiser Foundation Hospital - Fremont | 50512 | 2022-12-23 | Alameda | 1 | Bay Area | 0 | 0 | 4 | 4 | 1 | 0.0 | | 84 | Kaiser Foundation Hospital - Fresno | 50710 | 2022-12-23 | Fresno | 19 | San Joaquin Valley | 5 | 0 | 14 | 14 | 1 | 0.3571428571428571 | | 85 | Kaiser Foundation Hospital - Los Angeles | 50138 | 2022-12-23 | Los Angeles | 37 | Southern California | 5 | 46 | 43 | 89 | 0.483146 | 0.1162790697674418 | | 86 | Kaiser Foundation Hospital - Oakland/richmond | 50075 | 2022-12-23 | Alameda | 1 | Bay Area | 10 | 2 | 20 | 22 | 0.909091 | 0.5 | | 87 | Kaiser Foundation Hospital - Orange County - Anahe | 50609 | 2022-12-23 | Orange | 59 | Southern California | 0 | 9 | 32 | 41 | 0.780488 | 0.0 | | 88 | Kaiser Foundation Hospital - Panorama City | 50137 | 2022-12-23 | Los Angeles | 37 | Southern California | 0 | 12 | 10 | 22 | 0.454545 | 0.0 | | 89 | Kaiser Foundation Hospital - Redwood City | 50541 | 2022-12-23 | San Mateo | 81 | Bay Area | 0 | 1 | 10 | 11 | 0.909091 | 0.0 | | 90 | Kaiser Foundation Hospital - Roseville | 50772 | 2022-12-23 | Placer | 61 | Greater Sacramento | 6 | 2 | 17 | 19 | 0.894737 | 0.3529411764705882 | | 91 | Kaiser Foundation Hospital - Sacramento | 50425 | 2022-12-23 | Sacramento | 67 | Greater Sacramento | 9 | 2 | 23 | 25 | 0.92 | 0.391304347826087 | | 92 | Kaiser Foundation Hospital - San Francisco | 50076 | 2022-12-23 | San Francisco | 75 | Bay Area | 0 | 2 | 20 | 22 | 0.909091 | 0.0 | | 93 | Kaiser Foundation Hospital - San Leandro | 50777 | 2022-12-23 | Alameda | 1 | Bay Area | 7 | 2 | 15 | 17 | 0.882353 | 0.4666666666666667 | | 94 | Kaiser Foundation Hospital - South Bay | 50411 | 2022-12-23 | Los Angeles | 37 | Southern California | 0 | 20 | 0 | 20 | 0 | | | 95 | Kaiser Foundation Hospital - South San Francisco | 50070 | 2022-12-23 | San Mateo | 81 | Bay Area | 0 | 1 | 9 | 10 | 0.9 | 0.0 | | 96 | Kaiser Foundation Hospital - Vacaville | 50767 | 2022-12-23 | Solano | 95 | Bay Area | 0 | 1 | 7 | 8 | 0.875 | 0.0 | | 97 | Kaiser Foundation Hospital - Walnut Creek | 50072 | 2022-12-23 | Contra Costa | 13 | Bay Area | 4 | 2 | 15 | 17 | 0.882353 | 0.2666666666666666 | | 98 | Kaiser Foundation Hospital - West LA | 50561 | 2022-12-23 | Los Angeles | 37 | Southern California | 0 | 17 | 13 | 30 | 0.433333 | 0.0 | | 99 | Kaiser Foundation Hospital - Woodland Hills | 50677 | 2022-12-23 | Los Angeles | 37 | Southern California | 0 | 10 | 7 | 17 | 0.411765 | 0.0 | | 100 | Kaiser Foundation Hospital - Zion | 50515 | 2022-12-23 | San Diego | 73 | Southern California | 4 | 26 | 16 | 42 | 0.380952 | 0.25 | +---------+----------------------------------------------------+-------+------------+-----------------+--------+---------------------+----------------------------+----------------------------------+---------------------------------+--------------------------------+-----------------------------------+-----------------------------------+