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 sorted by covid_icu_patients_total
This data as json, yaml, Notebook, copyable, CSV (advanced)
week (date) >30 ✖
- 2020-07-24 330
- 2020-12-11 309
- 2021-01-01 309
- 2021-04-30 308
- 2020-09-25 307
- 2020-12-18 307
- 2021-01-29 307
- 2021-02-12 307
- 2021-04-09 307
- 2021-05-21 307
- 2021-06-04 307
- 2021-06-18 307
- 2021-06-25 307
- 2021-07-09 307
- 2021-07-30 307
- 2021-09-10 307
- 2021-09-24 307
- 2021-10-01 307
- 2020-08-14 306
- 2020-10-16 306
- 2020-10-23 306
- 2020-10-30 306
- 2020-11-06 306
- 2020-11-13 306
- 2020-12-04 306
- 2020-12-25 306
- 2021-01-08 306
- 2021-01-22 306
- 2021-02-05 306
- 2021-02-19 306
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
201 | 201 | San Antonio Regional Hospital | 50099 | 2022-12-23 | San Bernardino | 71 | Southern California | 0.0 | 0.0 | 27.0 | 27.0 | 1.0 | 0.0 |
202 | 202 | San Dimas Community Hospital | 50588 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 10.0 | 10.0 | 1.0 | 0.0 |
203 | 203 | San Gabriel Valley Medical Center | 50132 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 8.0 | 11.0 | 19.0 | 0.5789473684210527 | 0.0 |
204 | 204 | San Gorgonio Memorial Hospital | 50054 | 2022-12-23 | Riverside | 65 | Southern California | 0.0 | 7.75 | 8.25 | 16.0 | 0.515625 | 0.0 |
206 | 206 | San Mateo Medical Center | 50113 | 2022-12-23 | San Mateo | 81 | Bay Area | 0.0 | 2.0 | 4.0 | 6.0 | 0.6666666666666666 | 0.0 |
209 | 209 | Scripps Green Hospital | 50424 | 2022-12-23 | San Diego | 73 | Southern California | 0.0 | 18.0 | 6.0 | 24.0 | 0.25 | 0.0 |
210 | 210 | Scripps Memorial Hospital - Encinitas | 50503 | 2022-12-23 | San Diego | 73 | Southern California | 0.0 | 3.0 | 9.0 | 12.0 | 0.75 | 0.0 |
212 | 212 | Scripps Mercy Hospital | 50077 | 2022-12-23 | San Diego | 73 | Southern California | 0.0 | 27.0 | 29.0 | 56.0 | 0.5178571428571429 | 0.0 |
213 | 213 | Sequoia Hospital | 50197 | 2022-12-23 | San Mateo | 81 | Bay Area | 0.0 | 8.0 | 5.0 | 13.0 | 0.3846153846153846 | 0.0 |
214 | 214 | Sharp Chula Vista Medical Center | 50222 | 2022-12-23 | San Diego | 73 | Southern California | 0.0 | 6.0 | 29.0 | 35.0 | 0.8285714285714286 | 0.0 |
215 | 215 | Sharp Coronado Hospital and Hlthcr Center | 50234 | 2022-12-23 | San Diego | 73 | Southern California | 0.0 | 1.0 | 5.0 | 6.0 | 0.8333333333333334 | 0.0 |
217 | 217 | Sherman Oaks Hospital | 50755 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 2.0 | 6.0 | 8.0 | 0.75 | 0.0 |
218 | 218 | Sierra Nevada Memorial Hospital | 50150 | 2022-12-23 | Nevada | 57 | Greater Sacramento | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
219 | 219 | Sierra View Medical Center | 50261 | 2022-12-23 | Tulare | 107 | San Joaquin Valley | 0.0 | 4.0 | 6.0 | 10.0 | 0.6 | 0.0 |
220 | 220 | Sonoma Valley Hospital | 50090 | 2022-12-23 | Sonoma | 97 | Bay Area | 0.0 | 6.0 | 0.0 | 6.0 | 0.0 | |
221 | 221 | South Coast Global Medical Center | 50747 | 2022-12-23 | Orange | 59 | Southern California | 0.0 | 5.0 | 4.0 | 9.0 | 0.4444444444444444 | 0.0 |
222 | 222 | Southern California Hospital at Hollywood | 50135 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 21.0 | 13.0 | 34.0 | 0.3823529411764705 | 0.0 |
225 | 225 | St. Elizabeth Community Hospital | 50042 | 2022-12-23 | Tehama | 103 | Northern California | 0.0 | 0.0 | 8.0 | 8.0 | 1.0 | 0.0 |
226 | 226 | St. Johns Hospital Camarillo | 50616 | 2022-12-23 | Ventura | 111 | Southern California | 0.0 | 1.0 | 7.0 | 8.0 | 0.875 | 0.0 |
230 | 230 | St. Mary Medical Center | 50191 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 21.0 | 19.0 | 40.0 | 0.475 | 0.0 |
231 | 231 | St. Mary's Medical Center | 50457 | 2022-12-23 | San Francisco | 75 | Bay Area | 0.0 | 7.0 | 9.0 | 16.0 | 0.5625 | 0.0 |
232 | 232 | St. Rose Hospital | 50002 | 2022-12-23 | Alameda | 1 | Bay Area | 0.0 | 5.0 | 7.0 | 12.0 | 0.5833333333333334 | 0.0 |
234 | 234 | Stanford Health Care - Valleycare | 50283 | 2022-12-23 | Alameda | 1 | Bay Area | 0.0 | 6.0 | 16.0 | 22.0 | 0.7272727272727273 | 0.0 |
235 | 235 | Sutter Amador Hospital | 50014 | 2022-12-23 | Amador | 5 | Greater Sacramento | 0.0 | 0.0 | 6.0 | 6.0 | 1.0 | 0.0 |
236 | 236 | Sutter Auburn Faith Hospital | 50498 | 2022-12-23 | Placer | 61 | Greater Sacramento | 0.0 | 3.0 | 5.0 | 8.0 | 0.625 | 0.0 |
237 | 237 | Sutter Coast Hospital | 50417 | 2022-12-23 | Del Norte | 15 | Northern California | 0.0 | 6.0 | 0.0 | 6.0 | 0.0 | |
238 | 238 | Sutter Davis Hospital | 50537 | 2022-12-23 | Yolo | 113 | Greater Sacramento | 0.0 | 1.0 | 5.0 | 6.0 | 0.8333333333333334 | 0.0 |
239 | 239 | Sutter Delta Medical Center | 50523 | 2022-12-23 | Contra Costa | 13 | Bay Area | 0.0 | 2.0 | 10.0 | 12.0 | 0.8333333333333334 | 0.0 |
240 | 240 | Sutter Lakeside Hospital | 51329 | 2022-12-23 | Lake | 33 | Northern California | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
243 | 243 | Sutter Santa Rosa Regional Hospital | 50291 | 2022-12-23 | Sonoma | 97 | Bay Area | 0.0 | 1.0 | 11.0 | 12.0 | 0.9166666666666666 | 0.0 |
244 | 244 | Sutter Solano Medical Center | 50101 | 2022-12-23 | Solano | 95 | Bay Area | 0.0 | 6.0 | 6.0 | 12.0 | 0.5 | 0.0 |
245 | 245 | Sutter Tracy Community Hospital | 50313 | 2022-12-23 | San Joaquin | 77 | San Joaquin Valley | 0.0 | 1.0 | 7.0 | 8.0 | 0.875 | 0.0 |
246 | 246 | Tahoe Forest Hospital | 51328 | 2022-12-23 | Nevada | 57 | Greater Sacramento | 0.0 | 2.0 | 4.0 | 6.0 | 0.6666666666666666 | 0.0 |
247 | 247 | Temecula Valley Hospital | 50775 | 2022-12-23 | Riverside | 65 | Southern California | 0.0 | 0.0 | 11.0 | 11.0 | 1.0 | 0.0 |
248 | 248 | Torrance Memorial Medical Center | 50351 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 15.0 | 33.0 | 48.0 | 0.6875 | 0.0 |
249 | 249 | Tri-city Medical Center | 50128 | 2022-12-23 | San Diego | 73 | Southern California | 0.0 | 21.0 | 16.0 | 37.0 | 0.4324324324324324 | 0.0 |
250 | 250 | UCSF Medical Center | 50454 | 2022-12-23 | San Francisco | 75 | Bay Area | 0.0 | 2.0 | 6.0 | 8.0 | 0.75 | 0.0 |
251 | 251 | USC Arcadia Hospital | 50238 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 4.0 | 19.0 | 23.0 | 0.8260869565217391 | 0.0 |
252 | 252 | USC Verdugo Hills Hospital | 50124 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 7.0 | 7.0 | 14.0 | 0.5 | 0.0 |
255 | 255 | Valley Presbyterian Hospital | 50126 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 3.0 | 17.0 | 20.0 | 0.85 | 0.0 |
256 | 256 | Ventura County Medical Center | 50159 | 2022-12-23 | Ventura | 111 | Southern California | 0.0 | 12.0 | 10.0 | 22.0 | 0.4545454545454545 | 0.0 |
257 | 257 | Vibra Hospital of Sacramento | 52033 | 2022-12-23 | Sacramento | 67 | Greater Sacramento | 0.0 | 0.0 | 6.0 | 6.0 | 1.0 | 0.0 |
258 | 258 | Victor Valley Global Medical Center | 50517 | 2022-12-23 | San Bernardino | 71 | Southern California | 0.0 | 4.0 | 6.0 | 10.0 | 0.6 | 0.0 |
259 | 259 | Washington Hospital | 50195 | 2022-12-23 | Alameda | 1 | Bay Area | 0.0 | 5.0 | 23.0 | 28.0 | 0.8214285714285714 | 0.0 |
260 | 260 | West Anaheim Medical Center | 50426 | 2022-12-23 | Orange | 59 | Southern California | 0.0 | 0.0 | 15.0 | 15.0 | 1.0 | 0.0 |
262 | 262 | White Memorial Medical Center | 50103 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 1.0 | 16.0 | 17.0 | 0.9411764705882352 | 0.0 |
263 | 263 | Whittier Hospital Medical Center | 50735 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 6.0 | 10.0 | 16.0 | 0.625 | 0.0 |
264 | 264 | Woodland Memorial Hospital | 50127 | 2022-12-23 | Yolo | 113 | Greater Sacramento | 0.0 | 2.0 | 6.0 | 8.0 | 0.75 | 0.0 |
265 | 265 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-12-23 | San Francisco | 75 | Bay Area | 0.0 | 0.0 | 38.0 | 38.0 | 1.0 | 0.0 |
267 | 267 | Adventist Health Clearlake | 51317 | 2022-12-16 | Lake | 33 | Northern California | 0.0 | 0.1428571428571428 | 3.857142857142857 | 4.0 | 0.9642857142857144 | 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 );