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.
38,919 rows
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
101 | 101 | Kaiser Foundation Hospital Fontana | 50140 | 2022-12-23 | San Bernardino | 71 | Southern California | 0.0 | 50.0 | 34.0 | 84.0 | 0.4047619047619047 | 0.0 |
102 | 102 | Kaiser Foundation Hospital Manteca | 50748 | 2022-12-23 | San Joaquin | 77 | San Joaquin Valley | 6.0 | 1.0 | 15.0 | 16.0 | 0.9375 | 0.4 |
103 | 103 | Kaiser Foundation Hospital and Rehab Center | 50073 | 2022-12-23 | Solano | 95 | Bay Area | 5.0 | 2.0 | 17.0 | 19.0 | 0.8947368421052632 | 0.2941176470588235 |
104 | 104 | Kaiser Foundation Hospital, Riverside | 50686 | 2022-12-23 | Riverside | 65 | Southern California | 0.0 | 9.0 | 13.0 | 22.0 | 0.5909090909090909 | 0.0 |
105 | 105 | Kaiser Foundation Hospital-moreno Valley | 50765 | 2022-12-23 | Riverside | 65 | Southern California | 0.0 | 19.0 | 4.0 | 23.0 | 0.1739130434782608 | 0.0 |
106 | 106 | Kaiser Foundation Hospital-san Jose | 50604 | 2022-12-23 | Santa Clara | 85 | Bay Area | 0.0 | 1.0 | 9.0 | 10.0 | 0.9 | 0.0 |
107 | 107 | Kaiser Foundation Hospital-santa Clara | 50071 | 2022-12-23 | Santa Clara | 85 | Bay Area | 4.0 | 1.0 | 29.0 | 30.0 | 0.9666666666666668 | 0.1379310344827586 |
108 | 108 | Kaiser Foundation Hospital-santa Rosa | 50690 | 2022-12-23 | Sonoma | 97 | Bay Area | 0.0 | 1.0 | 6.0 | 7.0 | 0.8571428571428571 | 0.0 |
109 | 109 | Kaweah Health Medical Center | 50057 | 2022-12-23 | Tulare | 107 | San Joaquin Valley | 2.5 | 18.75 | 22.25 | 41.0 | 0.5426829268292683 | 0.1123595505617977 |
110 | 110 | Keck Hospital of USC | 50696 | 2022-12-23 | Los Angeles | 37 | Southern California | 5.0 | 7.0 | 71.0 | 78.0 | 0.9102564102564102 | 0.0704225352112676 |
111 | 111 | Kern Medical Center | 50315 | 2022-12-23 | Kern | 29 | San Joaquin Valley | 0.0 | 0.0 | 20.0 | 20.0 | 1.0 | 0.0 |
112 | 112 | Kindred Hospital - Los Angeles | 52032 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 1.0 | 4.0 | 5.0 | 0.8 | 0.0 |
113 | 113 | Kindred Hospital - San Diego | 52036 | 2022-12-23 | San Diego | 73 | Southern California | 0.0 | 4.0 | 4.0 | 8.0 | 0.5 | 0.0 |
114 | 114 | Kindred Hospital - San Francisco Bay Area | 52034 | 2022-12-23 | Alameda | 1 | Bay Area | 0.0 | 4.0 | 6.0 | 10.0 | 0.6 | 0.0 |
115 | 115 | Kindred Hospital -- La Mirada | 52038 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 4.0 | 15.0 | 19.0 | 0.7894736842105263 | 0.0 |
116 | 116 | Kindred Hospital Baldwin Park | 52045 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 2.0 | 6.0 | 8.0 | 0.75 | 0.0 |
117 | 117 | Kindred Hospital Brea | 52039 | 2022-12-23 | Orange | 59 | Southern California | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
118 | 118 | Kindred Hospital Ontario | 52037 | 2022-12-23 | San Bernardino | 71 | Southern California | 0.0 | 4.0 | 6.0 | 10.0 | 0.6 | 0.0 |
119 | 119 | Kindred Hospital Paramount | 52046 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 12.0 | 12.0 | 1.0 | 0.0 |
120 | 120 | Kindred Hospital Rancho | 52049 | 2022-12-23 | San Bernardino | 71 | Southern California | 0.0 | 8.0 | 0.0 | 8.0 | 0.0 | |
121 | 121 | Kindred Hospital Riverside | 52052 | 2022-12-23 | Riverside | 65 | Southern California | 0.0 | 2.0 | 6.0 | 8.0 | 0.75 | 0.0 |
122 | 122 | Kindred Hospital South Bay | 52050 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 1.0 | 8.0 | 9.0 | 0.8888888888888888 | 0.0 |
123 | 123 | Kindred Hospital Westminster | 52035 | 2022-12-23 | Orange | 59 | Southern California | 0.0 | 1.0 | 13.0 | 14.0 | 0.9285714285714286 | 0.0 |
124 | 124 | LAC+USC Medical Center | 50373 | 2022-12-23 | Los Angeles | 37 | Southern California | 4.0 | 12.0 | 63.0 | 75.0 | 0.84 | 0.0634920634920634 |
125 | 125 | LAC/Harbor-UCLA Medical Center | 50376 | 2022-12-23 | Los Angeles | 37 | Southern California | 5.0 | 7.0 | 35.0 | 42.0 | 0.8333333333333334 | 0.1428571428571428 |
126 | 126 | LAC/Olive View-UCLA Medical Center | 50040 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 4.0 | 8.0 | 12.0 | 0.6666666666666666 | 0.0 |
127 | 127 | LAC/Rancho Los Amigos National Rehabilitation Center | 50717 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 5.0 | 5.0 | 1.0 | 0.0 |
128 | 128 | La Palma Intercommunity Hospital | 50580 | 2022-12-23 | Orange | 59 | Southern California | 0.0 | 0.0 | 8.0 | 8.0 | 1.0 | 0.0 |
129 | 129 | Loma Linda University Medical Center | 50327 | 2022-12-23 | San Bernardino | 71 | Southern California | 7.75 | 18.0 | 86.25 | 104.25 | 0.8273381294964028 | 0.0898550724637681 |
130 | 130 | Loma Linda University Medical Center-murrieta | 50770 | 2022-12-23 | Riverside | 65 | Southern California | 4.5 | 0.5 | 12.0 | 12.5 | 0.96 | 0.375 |
131 | 131 | Lompoc Valley Medical Center | 50110 | 2022-12-23 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 6.0 | 6.0 | 1.0 | 0.0 |
132 | 132 | Los Alamitos Medical Center | 50551 | 2022-12-23 | Orange | 59 | Southern California | 0.0 | 2.0 | 15.0 | 17.0 | 0.8823529411764706 | 0.0 |
133 | 133 | Los Angeles Community Hospital | 50663 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 5.0 | 10.0 | 15.0 | 0.6666666666666666 | 0.0 |
134 | 134 | Los Robles Hospital & Medical Center | 50549 | 2022-12-23 | Ventura | 111 | Southern California | 4.2 | 8.8 | 27.2 | 36.0 | 0.7555555555555555 | 0.1544117647058823 |
135 | 135 | Mad River Community Hospital | 50028 | 2022-12-23 | Humboldt | 23 | Northern California | 0.0 | 4.0 | 0.0 | 4.0 | 0.0 | |
136 | 136 | Madera Community Hospital | 50568 | 2022-12-23 | Madera | 39 | San Joaquin Valley | 0.0 | 2.0 | 8.0 | 10.0 | 0.8 | 0.0 |
137 | 137 | Marian Regional Medical Center | 50107 | 2022-12-23 | Santa Barbara | 83 | Southern California | 0.0 | 5.0 | 15.0 | 20.0 | 0.75 | 0.0 |
138 | 138 | Marinhealth Medical Center | 50360 | 2022-12-23 | Marin | 41 | Bay Area | 0.0 | 6.0 | 13.0 | 19.0 | 0.6842105263157895 | 0.0 |
139 | 139 | Mark Twain Medical Center | 51332 | 2022-12-23 | Calaveras | 9 | San Joaquin Valley | 0.0 | 4.0 | 0.0 | 4.0 | 0.0 | |
140 | 140 | Marshall Medical Center | 50254 | 2022-12-23 | El Dorado | 17 | Greater Sacramento | 0.0 | 0.0 | 10.0 | 10.0 | 1.0 | 0.0 |
141 | 141 | Martin Luther King, Jr. Community Hospital | 50779 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 3.0 | 17.0 | 20.0 | 0.85 | 0.0 |
142 | 142 | Memorial Hospital Los Banos | 50528 | 2022-12-23 | Merced | 47 | San Joaquin Valley | 0.0 | 4.0 | 0.0 | 4.0 | 0.0 | |
143 | 143 | Memorial Medical Center | 50557 | 2022-12-23 | Stanislaus | 99 | San Joaquin Valley | 0.0 | 7.0 | 34.0 | 41.0 | 0.8292682926829268 | 0.0 |
144 | 144 | Memorialcare Long Beach Medical Center | 50485 | 2022-12-23 | Los Angeles | 37 | Southern California | 9.0 | 7.0 | 48.0 | 55.0 | 0.8727272727272727 | 0.1875 |
145 | 145 | Memorialcare Orange Coast Medical Center | 50678 | 2022-12-23 | Orange | 59 | Southern California | 0.0 | 2.0 | 23.0 | 25.0 | 0.92 | 0.0 |
146 | 146 | Memorialcare Saddleback Medical Center | 50603 | 2022-12-23 | Orange | 59 | Southern California | 4.0 | 3.0 | 19.0 | 22.0 | 0.8636363636363636 | 0.2105263157894736 |
147 | 147 | Menifee Global Medical Center | 50684 | 2022-12-23 | Riverside | 65 | Southern California | 0.0 | 10.0 | 0.0 | 10.0 | 0.0 | |
148 | 148 | Mercy General Hospital | 50017 | 2022-12-23 | Sacramento | 67 | Greater Sacramento | 0.0 | 3.0 | 20.0 | 23.0 | 0.8695652173913043 | 0.0 |
149 | 149 | Mercy Hospital | 50295 | 2022-12-23 | Kern | 29 | San Joaquin Valley | 0.0 | 14.0 | 14.0 | 28.0 | 0.5 | 0.0 |
150 | 150 | Mercy Hospital of Folsom | 50414 | 2022-12-23 | Sacramento | 67 | Greater Sacramento | 0.0 | 2.0 | 6.0 | 8.0 | 0.75 | 0.0 |
151 | 151 | Mercy Medical Center | 50444 | 2022-12-23 | Merced | 47 | San Joaquin Valley | 0.0 | 1.0 | 19.0 | 20.0 | 0.95 | 0.0 |
152 | 152 | Mercy Medical Center Mt Shasta | 51319 | 2022-12-23 | Siskiyou | 93 | Northern California | 0.0 | 4.0 | 0.0 | 4.0 | 0.0 | |
153 | 153 | Mercy Medical Center Redding | 50280 | 2022-12-23 | Shasta | 89 | Northern California | 0.0 | 8.0 | 25.0 | 33.0 | 0.7575757575757576 | 0.0 |
154 | 154 | Mercy San Juan Medical Center | 50516 | 2022-12-23 | Sacramento | 67 | Greater Sacramento | 4.0 | 3.0 | 36.0 | 39.0 | 0.9230769230769232 | 0.1111111111111111 |
155 | 155 | Methodist Hospital of Sacramento | 50590 | 2022-12-23 | Sacramento | 67 | Greater Sacramento | 0.0 | 0.0 | 11.0 | 11.0 | 1.0 | 0.0 |
156 | 156 | Mills-peninsula Medical Center | 50007 | 2022-12-23 | San Mateo | 81 | Bay Area | 0.0 | 7.0 | 17.0 | 24.0 | 0.7083333333333334 | 0.0 |
157 | 157 | Mission Community Hospital | 50704 | 2022-12-23 | Los Angeles | 37 | Southern California | 5.75 | -1.0 | 11.0 | 10.0 | 1.1 | 0.5227272727272727 |
158 | 158 | Monrovia Memorial Hospital | 52054 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
159 | 159 | Montclair Hospital Medical Center | 50758 | 2022-12-23 | San Bernardino | 71 | Southern California | 0.0 | 2.0 | 4.0 | 6.0 | 0.6666666666666666 | 0.0 |
160 | 160 | Monterey Park Hospital | 50736 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
161 | 161 | Natividad Medical Center | 50248 | 2022-12-23 | Monterey | 53 | Bay Area | 0.0 | 2.0 | 8.0 | 10.0 | 0.8 | 0.0 |
162 | 162 | Northbay Medical Center | 50367 | 2022-12-23 | Solano | 95 | Bay Area | 0.0 | 6.0 | 18.0 | 24.0 | 0.75 | 0.0 |
163 | 163 | Northern Inyo Hospital | 51324 | 2022-12-23 | Inyo | 27 | Southern California | 0.0 | 4.0 | 0.0 | 4.0 | 0.0 | |
164 | 164 | Northridge Hospital Medical Center | 50116 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 26.0 | 26.0 | 1.0 | 0.0 |
165 | 165 | Novato Community Hospital | 50131 | 2022-12-23 | Marin | 41 | Bay Area | 0.0 | 1.0 | 5.0 | 6.0 | 0.8333333333333334 | 0.0 |
166 | 166 | Oak Valley Hospital District | 50067 | 2022-12-23 | Stanislaus | 99 | San Joaquin Valley | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
167 | 167 | Orange County Global Medical Center | 50746 | 2022-12-23 | Orange | 59 | Southern California | 0.0 | 12.0 | 22.0 | 34.0 | 0.6470588235294118 | 0.0 |
168 | 168 | Orchard Hospital | 51311 | 2022-12-23 | Butte | 7 | Greater Sacramento | 0.0 | 4.0 | 0.0 | 4.0 | 0.0 | |
169 | 169 | Oroville Hospital | 50030 | 2022-12-23 | Butte | 7 | Greater Sacramento | 0.0 | 1.0 | 9.0 | 10.0 | 0.9 | 0.0 |
170 | 170 | Palmdale Regional Medical Center | 50204 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 10.0 | 14.0 | 24.0 | 0.5833333333333334 | 0.0 |
171 | 171 | Palomar Health Downtown Campus | 50115 | 2022-12-23 | San Diego | 73 | Southern California | 5.0 | 1.0 | 35.0 | 36.0 | 0.9722222222222222 | 0.1428571428571428 |
172 | 172 | Palomar Medical Center Poway | 50636 | 2022-12-23 | San Diego | 73 | Southern California | 0.0 | 0.0 | 10.0 | 10.0 | 1.0 | 0.0 |
173 | 173 | Paradise Valley Hospital | 50024 | 2022-12-23 | San Diego | 73 | Southern California | 0.0 | 7.0 | 8.0 | 15.0 | 0.5333333333333333 | 0.0 |
174 | 174 | Petaluma Valley Hospital | 50136 | 2022-12-23 | Sonoma | 97 | Bay Area | 0.0 | 1.0 | 5.0 | 6.0 | 0.8333333333333334 | 0.0 |
175 | 175 | Pih Health Downey Hospital | 50393 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 11.0 | 7.0 | 18.0 | 0.3888888888888889 | 0.0 |
176 | 176 | Pih Health Good Samaritan Hospital | 50471 | 2022-12-23 | Los Angeles | 37 | Southern California | 4.0 | 34.0 | 25.0 | 59.0 | 0.423728813559322 | 0.16 |
177 | 177 | Pih Health Hospital-Whittier | 50169 | 2022-12-23 | Los Angeles | 37 | Southern California | 4.0 | 25.0 | 23.0 | 48.0 | 0.4791666666666667 | 0.1739130434782608 |
178 | 178 | Placentia Linda Hospital | 50589 | 2022-12-23 | Orange | 59 | Southern California | 0.0 | 2.0 | 6.0 | 8.0 | 0.75 | 0.0 |
179 | 179 | Pomona Valley Hospital Medical Center | 50231 | 2022-12-23 | Los Angeles | 37 | Southern California | 5.0 | 6.0 | 44.0 | 50.0 | 0.88 | 0.1136363636363636 |
180 | 180 | Providence Cedars Sinai Tarzana Medical Center | 50761 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 10.0 | 10.0 | 1.0 | 0.0 |
181 | 181 | Providence Holy Cross Medical Center | 50278 | 2022-12-23 | Los Angeles | 37 | Southern California | 4.0 | 1.0 | 15.0 | 16.0 | 0.9375 | 0.2666666666666666 |
182 | 182 | Providence Little Company of Mary Medical Center San Pedro | 50078 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 6.0 | 6.0 | 1.0 | 0.0 |
183 | 183 | Providence Little Company of Mary Medical Center Torrance | 50353 | 2022-12-23 | Los Angeles | 37 | Southern California | 5.0 | 1.0 | 25.0 | 26.0 | 0.9615384615384616 | 0.2 |
184 | 184 | Providence Mission Hospital | 50567 | 2022-12-23 | Orange | 59 | Southern California | 0.0 | 4.0 | 51.0 | 55.0 | 0.9272727272727272 | 0.0 |
185 | 185 | Providence Queen of the Valley Medical Center | 50009 | 2022-12-23 | Napa | 55 | Bay Area | 0.0 | 0.0 | 12.0 | 12.0 | 1.0 | 0.0 |
186 | 186 | Providence Redwood Memorial Hospital | 51318 | 2022-12-23 | Humboldt | 23 | Northern California | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
187 | 187 | Providence Saint Joseph Medical Center | 50235 | 2022-12-23 | Los Angeles | 37 | Southern California | 5.0 | 3.0 | 19.0 | 22.0 | 0.8636363636363636 | 0.2631578947368421 |
188 | 188 | Providence Santa Rosa Memorial Hospital | 50174 | 2022-12-23 | Sonoma | 97 | Bay Area | 0.0 | 6.0 | 20.0 | 26.0 | 0.7692307692307693 | 0.0 |
189 | 189 | Providence St. Joseph Hospital | 50006 | 2022-12-23 | Humboldt | 23 | Northern California | 0.0 | 0.0 | 12.0 | 12.0 | 1.0 | 0.0 |
190 | 190 | Providence St. Joseph Hospital | 50069 | 2022-12-23 | Orange | 59 | Southern California | 0.0 | 2.0 | 17.0 | 19.0 | 0.8947368421052632 | 0.0 |
191 | 191 | Providence St. Jude Medical Center | 50168 | 2022-12-23 | Orange | 59 | Southern California | 0.0 | 1.0 | 41.0 | 42.0 | 0.9761904761904762 | 0.0 |
192 | 192 | Regional Medical Center of San Jose | 50125 | 2022-12-23 | Santa Clara | 85 | Bay Area | 5.0 | 3.8000000000000007 | 30.2 | 34.0 | 0.888235294117647 | 0.1655629139072847 |
193 | 193 | Ridgecrest Regional Hospital | 51333 | 2022-12-23 | Kern | 29 | San Joaquin Valley | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
194 | 194 | Riverside Community Hospital | 50022 | 2022-12-23 | Riverside | 65 | Southern California | 5.4 | 14.4 | 54.6 | 69.0 | 0.7913043478260869 | 0.0989010989010989 |
195 | 195 | Riverside University Health System-medical Center | 50292 | 2022-12-23 | Riverside | 65 | Southern California | 5.0 | 0.0 | 41.0 | 41.0 | 1.0 | 0.1219512195121951 |
196 | 196 | Saint Agnes Medical Center | 50093 | 2022-12-23 | Fresno | 19 | San Joaquin Valley | 4.0 | 1.0 | 32.0 | 33.0 | 0.9696969696969696 | 0.125 |
197 | 197 | Saint Francis Medical Center | 50104 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 1.0 | 34.0 | 35.0 | 0.9714285714285714 | 0.0 |
198 | 198 | Saint Francis Memorial Hospital | 50152 | 2022-12-23 | San Francisco | 75 | Bay Area | 4.0 | 12.0 | 8.0 | 20.0 | 0.4 | 0.5 |
199 | 199 | Saint John's Health Center | 50290 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 2.0 | 19.0 | 21.0 | 0.9047619047619048 | 0.0 |
200 | 200 | Salinas Valley Memorial Hospital | 50334 | 2022-12-23 | Monterey | 53 | Bay Area | 0.0 | 4.0 | 9.0 | 13.0 | 0.6923076923076923 | 0.0 |
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 );