hhs-hospital-patient-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.
- adult_covid_patients_total
- The daily average of adult COVID-19 patients at the hospital over the past seven days.
- pediatric_covid_patients_total
- The daily average of pediatric COVID-19 patients at the hospital over the past seven days.
- covid_patients_total
- The daily average of total COVID-19 patients at the hospital over the past seven days.
- occupied_beds_percent
- The daily average of occupied beds over the past seven days, measured as a percentage of the hospital's total.
- patients_with_covid_percent
- The daily average of beds occupied by COVID-19 patients over the past seven days, measured as a percentage of the hospital's total.
48,633 rows sorted by patients_with_covid_percent
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: week (date)
Link | rowid | hospital | ccn | week | county | fips | region | adult_covid_patients_total | pediatric_covid_patients_total | covid_patients_total | occupied_beds_total | occupied_beds_percent | patients_with_covid_percent ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | 2 | Adventist Health Clearlake | 051317 | 2022-12-23 | Lake | 33 | Northern California | 0.0 | 0.0 | 0.0 | 18.0 | 0.4864864864864865 | 0.0 |
3 | 3 | Adventist Health Delano | 050608 | 2022-12-23 | Kern | 29 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 14.0 | 1.0 | 0.0 |
6 | 6 | Adventist Health Mendocino Coast | 51325.0 | 2022-12-23 | Mendocino | 45 | Northern California | 0.0 | 0.0 | 0.0 | 19.0 | 1.0 | 0.0 |
7 | 7 | Adventist Health Reedley | 050192 | 2022-12-23 | Fresno | 19 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 23.0 | 0.7666666666666667 | 0.0 |
9 | 9 | Adventist Health Sonora | 050335 | 2022-12-23 | Tuolumne | 109 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 51.0 | 0.7083333333333334 | 0.0 |
10 | 10 | Adventist Health St. Helena | 050013 | 2022-12-23 | Napa | 55 | Bay Area | 0.0 | 0.0 | 0.0 | 40.0 | 0.8888888888888888 | 0.0 |
12 | 12 | Adventist Health Tulare | 50784.0 | 2022-12-23 | Tulare | 107 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 22.0 | 0.7586206896551724 | 0.0 |
21 | 21 | Anaheim Global Medical Center | 50744.0 | 2022-12-23 | Orange | 59 | Southern California | 0.0 | 0.0 | 0.0 | 94.0 | 0.4973544973544973 | 0.0 |
24 | 24 | Bear Valley Community Hospital | 051335 | 2022-12-23 | San Bernardino | 71 | Southern California | 0.0 | 0.0 | 0.0 | 5.0 | 0.5555555555555556 | 0.0 |
29 | 29 | Casa Colina Hospital | 050782 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 0.0 | 74.0 | 0.7474747474747475 | 0.0 |
34 | 34 | Children's Hospital at Mission | 053306 | 2022-12-23 | Orange | 59 | Southern California | 0.0 | 0.0 | 0.0 | 28.0 | 0.4827586206896552 | 0.0 |
37 | 37 | Coalinga Regional Medical Center | 50397.0 | 2022-12-23 | Fresno | 19 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 24.0 | 1.0 | 0.0 |
39 | 39 | College Hospital Costa Mesa | 050543 | 2022-12-23 | Orange | 59 | Southern California | 0.0 | 0.0 | 0.0 | 107.0 | 0.8359375 | 0.0 |
52 | 52 | Eastern Plumas Hospital - Portola Campus | 051300 | 2022-12-23 | Plumas | 63 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 4.0 | 0.4444444444444444 | 0.0 |
57 | 57 | Emanate Health Foothill Presbyterian Hospital | 50597.0 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 0.0 | 83.0 | 0.8058252427184466 | 0.0 |
59 | 59 | Encino Hospital Medical Center | 50158.0 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 0.0 | 69.0 | 0.8214285714285714 | 0.0 |
61 | 61 | Fairchild Medical Center | 51316.0 | 2022-12-23 | Siskiyou | 93 | Northern California | 0.0 | 0.0 | 0.0 | 15.0 | 0.6 | 0.0 |
63 | 63 | Fresno Surgical Hospital | 050708 | 2022-12-23 | Fresno | 19 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 4.0 | 0.1290322580645161 | 0.0 |
66 | 66 | Glenn Medical Center | 51306.0 | 2022-12-23 | Glenn | 21 | Northern California | 0.0 | 0.0 | 0.0 | 21.0 | 0.7 | 0.0 |
67 | 67 | Goleta Valley Cottage Hospital | 50357.0 | 2022-12-23 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.0 | 10.0 | 0.5 | 0.0 |
68 | 68 | Good Samaritan Hospital | 050257 | 2022-12-23 | Kern | 29 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 24.0 | 0.6153846153846154 | 0.0 |
72 | 72 | Hazel Hawkins Memorial Hospital | 051337 | 2022-12-23 | San Benito | 69 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 21.0 | 0.84 | 0.0 |
73 | 73 | Healdsburg Hospital | 51321.0 | 2022-12-23 | Sonoma | 97 | Bay Area | 0.0 | 0.0 | 0.0 | 12.0 | 0.7058823529411765 | 0.0 |
78 | 78 | Hoag Orthopedic Institute | 50769.0 | 2022-12-23 | Orange | 59 | Southern California | 0.0 | 0.0 | 0.0 | 26.0 | 0.7428571428571429 | 0.0 |
82 | 82 | Jerold Phelps Community Hospital | 051309 | 2022-12-23 | Humboldt | 23 | Northern California | 0.0 | 0.0 | 0.0 | 4.0 | 0.5 | 0.0 |
83 | 83 | John C Fremont Healthcare District | 51304.0 | 2022-12-23 | Mariposa | 43 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 9.0 | 0.6428571428571429 | 0.0 |
118 | 118 | Kern Medical Center | 050315 | 2022-12-23 | Kern | 29 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 171.0 | 0.8221153846153846 | 0.0 |
119 | 119 | Kern Valley Healthcare District | 51314.0 | 2022-12-23 | Kern | 29 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 5.0 | 0.5 | 0.0 |
120 | 120 | Kindred Hospital - Los Angeles | 52032.0 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 0.0 | 62.0 | 0.7654320987654321 | 0.0 |
121 | 121 | Kindred Hospital - San Diego | 052036 | 2022-12-23 | San Diego | 73 | Southern California | 0.0 | 0.0 | 0.0 | 47.0 | 0.6714285714285714 | 0.0 |
122 | 122 | Kindred Hospital - San Francisco Bay Area | 52034.0 | 2022-12-23 | Alameda | 1 | Bay Area | 0.0 | 0.0 | 0.0 | 57.0 | 0.5757575757575758 | 0.0 |
123 | 123 | Kindred Hospital -- La Mirada | 052038 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 0.0 | 138.0 | 0.5564516129032258 | 0.0 |
124 | 124 | Kindred Hospital Baldwin Park | 52045.0 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 0.0 | 70.0 | 0.7692307692307693 | 0.0 |
125 | 125 | Kindred Hospital Brea | 52039.0 | 2022-12-23 | Orange | 59 | Southern California | 0.0 | 0.0 | 0.0 | 42.0 | 0.4883720930232558 | 0.0 |
126 | 126 | Kindred Hospital Ontario | 052037 | 2022-12-23 | San Bernardino | 71 | Southern California | 0.0 | 0.0 | 0.0 | 71.0 | 0.7802197802197802 | 0.0 |
128 | 128 | Kindred Hospital Rancho | 52049.0 | 2022-12-23 | San Bernardino | 71 | Southern California | 0.0 | 0.0 | 0.0 | 22.0 | 0.4 | 0.0 |
129 | 129 | Kindred Hospital Riverside | 52052.0 | 2022-12-23 | Riverside | 65 | Southern California | 0.0 | 0.0 | 0.0 | 37.0 | 0.925 | 0.0 |
131 | 131 | Kindred Hospital Westminster | 52035.0 | 2022-12-23 | Orange | 59 | Southern California | 0.0 | 0.0 | 0.0 | 87.0 | 0.7981651376146789 | 0.0 |
142 | 142 | Lompoc Valley Medical Center | 050110 | 2022-12-23 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.0 | 43.0 | 0.3583333333333333 | 0.0 |
147 | 147 | Mad River Community Hospital | 050028 | 2022-12-23 | Humboldt | 23 | Northern California | 0.0 | 0.0 | 0.0 | 18.0 | 0.4864864864864865 | 0.0 |
149 | 149 | Mammoth Hospital | 051303 | 2022-12-23 | Mono | 51 | Southern California | 0.0 | 0.0 | 0.0 | 5.0 | 0.2941176470588235 | 0.0 |
153 | 153 | Mayers Memorial Hospital | 051305 | 2022-12-23 | Shasta | 89 | Northern California | 0.0 | 0.0 | 0.0 | 6.0 | 0.375 | 0.0 |
155 | 155 | Memorial Hospital Los Banos | 50528.0 | 2022-12-23 | Merced | 47 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 23.0 | 0.5609756097560976 | 0.0 |
160 | 160 | Menifee Global Medical Center | 050684 | 2022-12-23 | Riverside | 65 | Southern California | 0.0 | 0.0 | 0.0 | 37.0 | 0.8604651162790697 | 0.0 |
162 | 162 | Montclair Hospital Medical Center | 50758.0 | 2022-12-23 | San Bernardino | 71 | Southern California | 0.0 | 0.0 | 0.0 | 29.0 | 0.2735849056603773 | 0.0 |
167 | 167 | Novato Community Hospital | 050131 | 2022-12-23 | Marin | 41 | Bay Area | 0.0 | 0.0 | 0.0 | 30.0 | 0.7894736842105263 | 0.0 |
169 | 169 | Ojai Valley Community Hospital | 51334.0 | 2022-12-23 | Ventura | 111 | Southern California | 0.0 | 0.0 | 0.0 | 8.0 | 0.4705882352941176 | 0.0 |
177 | 177 | Petaluma Valley Hospital | 50136.0 | 2022-12-23 | Sonoma | 97 | Bay Area | 0.0 | 0.0 | 0.0 | 46.0 | 0.7540983606557377 | 0.0 |
181 | 181 | Placentia Linda Hospital | 050589 | 2022-12-23 | Orange | 59 | Southern California | 0.0 | 0.0 | 0.0 | 47.0 | 0.3821138211382114 | 0.0 |
182 | 182 | Plumas District Hospital | 051326 | 2022-12-23 | Plumas | 63 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 8.0 | 0.4210526315789473 | 0.0 |
191 | 191 | Providence Redwood Memorial Hospital | 51318.0 | 2022-12-23 | Humboldt | 23 | Northern California | 0.0 | 0.0 | 0.0 | 15.0 | 0.3571428571428571 | 0.0 |
199 | 199 | Ridgecrest Regional Hospital | 51333.0 | 2022-12-23 | Kern | 29 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 27.0 | 1.0 | 0.0 |
209 | 209 | San Mateo Medical Center | 50113.0 | 2022-12-23 | San Mateo | 81 | Bay Area | 0.0 | 0.0 | 0.0 | 31.0 | 0.62 | 0.0 |
223 | 223 | Shriners Hospitals For Children Northern Calif | 053311 | 2022-12-23 | Sacramento | 67 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 19.0 | 0.7307692307692307 | 0.0 |
225 | 225 | Sonoma Valley Hospital | 050090 | 2022-12-23 | Sonoma | 97 | Bay Area | 0.0 | 0.0 | 0.0 | 9.0 | 0.375 | 0.0 |
230 | 230 | St. Rose Hospital | 50002.0 | 2022-12-23 | Alameda | 1 | Bay Area | 0.0 | 0.0 | 0.0 | 51.0 | 0.6375 | 0.0 |
233 | 233 | Stanislaus Surgical Hospital | 50726.0 | 2022-12-23 | Stanislaus | 99 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 4.0 | 0.1739130434782608 | 0.0 |
237 | 237 | Sutter Coast Hospital | 50417.0 | 2022-12-23 | Del Norte | 15 | Northern California | 0.0 | 0.0 | 0.0 | 24.0 | 0.4285714285714285 | 0.0 |
240 | 240 | Sutter Lakeside Hospital | 051329 | 2022-12-23 | Lake | 33 | Northern California | 0.0 | 0.0 | 0.0 | 20.0 | 0.7142857142857143 | 0.0 |
241 | 241 | Sutter Maternity & Surgery Center of Santa Cruz | 050714 | 2022-12-23 | Santa Cruz | 87 | Bay Area | 0.0 | 0.0 | 0.0 | 16.0 | 0.5517241379310345 | 0.0 |
248 | 248 | Tahoe Forest Hospital | 051328 | 2022-12-23 | Nevada | 57 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 13.0 | 0.52 | 0.0 |
252 | 252 | Trinity Hospital | 51315.0 | 2022-12-23 | Trinity | 105 | Northern California | 0.0 | 0.0 | 0.0 | 9.0 | 0.9 | 0.0 |
254 | 254 | UCSF Medical Center | 50454.0 | 2022-12-23 | San Francisco | 75 | Bay Area | 0.0 | 0.0 | 0.0 | 212.0 | 0.6883116883116883 | 0.0 |
262 | 262 | Vibra Hospital of Northern California | 52047.0 | 2022-12-23 | Shasta | 89 | Northern California | 0.0 | 0.0 | 0.0 | 42.0 | 0.84 | 0.0 |
263 | 263 | Victor Valley Global Medical Center | 50517.0 | 2022-12-23 | San Bernardino | 71 | Southern California | 0.0 | 0.0 | 0.0 | 69.0 | 0.6831683168316832 | 0.0 |
278 | 278 | Adventist Health Reedley | 50192.0 | 2022-12-16 | Fresno | 19 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 21.285714285714285 | 0.6394849785407726 | 0.0 |
283 | 283 | Adventist Health Tulare | 050784 | 2022-12-16 | Tulare | 107 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 21.285714285714285 | 0.8816568047337278 | 0.0 |
297 | 297 | Barton Memorial Hospital | 50352.0 | 2022-12-16 | El Dorado | 17 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 18.0 | 0.2857142857142857 | 0.0 |
304 | 304 | Catalina Island Medical Center | 051307 | 2022-12-16 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 0.0 | 4.285714285714286 | 0.3571428571428571 | 0.0 |
309 | 309 | Children's Hospital at Mission | 53306.0 | 2022-12-16 | Orange | 59 | Southern California | 0.0 | 0.0 | 0.0 | 29.571428571428573 | 0.5098522167487685 | 0.0 |
312 | 312 | Coalinga Regional Medical Center | 50397.0 | 2022-12-16 | Fresno | 19 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 25.857142857142858 | 1.2569444444444444 | 0.0 |
314 | 314 | College Hospital Costa Mesa | 50543.0 | 2022-12-16 | Orange | 59 | Southern California | 0.0 | 0.0 | 0.0 | 113.71428571428572 | 0.8883928571428571 | 0.0 |
316 | 316 | Colorado River Medical Center | 051323 | 2022-12-16 | San Bernardino | 71 | Southern California | 0.0 | 0.0 | 0.0 | 1.3333333333333333 | 0.0533333333333333 | 0.0 |
327 | 327 | Eastern Plumas Hospital - Portola Campus | 51300.0 | 2022-12-16 | Plumas | 63 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 3.857142857142857 | 0.4285714285714286 | 0.0 |
334 | 334 | Encino Hospital Medical Center | 050158 | 2022-12-16 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 0.0 | 63.71428571428572 | 0.8123861566484517 | 0.0 |
336 | 336 | Fairchild Medical Center | 051316 | 2022-12-16 | Siskiyou | 93 | Northern California | 0.0 | 0.0 | 0.0 | 16.0 | 0.64 | 0.0 |
338 | 338 | Fresno Surgical Hospital | 050708 | 2022-12-16 | Fresno | 19 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 11.285714285714286 | 0.3640552995391705 | 0.0 |
343 | 343 | Goleta Valley Cottage Hospital | 050357 | 2022-12-16 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.0 | 9.857142857142858 | 0.4928571428571429 | 0.0 |
349 | 349 | Healdsburg Hospital | 051321 | 2022-12-16 | Sonoma | 97 | Bay Area | 0.0 | 0.0 | 0.0 | 12.25 | 0.7205882352941176 | 0.0 |
353 | 353 | Hoag Orthopedic Institute | 050769 | 2022-12-16 | Orange | 59 | Southern California | 0.0 | 0.0 | 0.0 | 25.714285714285715 | 0.7346938775510204 | 0.0 |
357 | 357 | Jerold Phelps Community Hospital | 051309 | 2022-12-16 | Humboldt | 23 | Northern California | 0.0 | 0.0 | 0.0 | 3.0 | 0.375 | 0.0 |
358 | 358 | John C Fremont Healthcare District | 51304.0 | 2022-12-16 | Mariposa | 43 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 6.428571428571429 | 0.4591836734693877 | 0.0 |
395 | 395 | Kern Valley Healthcare District | 051314 | 2022-12-16 | Kern | 29 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 5.571428571428571 | 0.5571428571428572 | 0.0 |
398 | 398 | Kindred Hospital - San Francisco Bay Area | 52034.0 | 2022-12-16 | Alameda | 1 | Bay Area | 0.0 | 0.0 | 0.0 | 54.57142857142857 | 0.5512265512265512 | 0.0 |
401 | 401 | Kindred Hospital Brea | 052039 | 2022-12-16 | Orange | 59 | Southern California | 0.0 | 0.0 | 0.0 | 43.85714285714285 | 0.5099667774086378 | 0.0 |
402 | 402 | Kindred Hospital Ontario | 052037 | 2022-12-16 | San Bernardino | 71 | Southern California | 0.0 | 0.0 | 0.0 | 66.85714285714286 | 0.7346938775510204 | 0.0 |
404 | 404 | Kindred Hospital Rancho | 052049 | 2022-12-16 | San Bernardino | 71 | Southern California | 0.0 | 0.0 | 0.0 | 21.0 | 0.3818181818181818 | 0.0 |
407 | 407 | Kindred Hospital Westminster | 52035.0 | 2022-12-16 | Orange | 59 | Southern California | 0.0 | 0.0 | 0.0 | 87.0 | 0.7981651376146789 | 0.0 |
423 | 423 | Mad River Community Hospital | 050028 | 2022-12-16 | Humboldt | 23 | Northern California | 0.0 | 0.0 | 0.0 | 17.714285714285715 | 0.4217687074829932 | 0.0 |
429 | 429 | Mayers Memorial Hospital | 51305.0 | 2022-12-16 | Shasta | 89 | Northern California | 0.0 | 0.0 | 0.0 | 3.4285714285714284 | 0.2142857142857142 | 0.0 |
438 | 438 | Montclair Hospital Medical Center | 50758.0 | 2022-12-16 | San Bernardino | 71 | Southern California | 0.0 | 0.0 | 0.0 | 36.57142857142857 | 0.3450134770889487 | 0.0 |
446 | 446 | Ojai Valley Community Hospital | 051334 | 2022-12-16 | Ventura | 111 | Southern California | 0.0 | 0.0 | 0.0 | 10.0 | 0.5882352941176471 | 0.0 |
452 | 452 | Palo Verde Hospital | 50423.0 | 2022-12-16 | Riverside | 65 | Southern California | 0.0 | 0.0 | 0.0 | 2.0 | 0.0828402366863905 | 0.0 |
463 | 463 | Plumas District Hospital | 051326 | 2022-12-16 | Plumas | 63 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 6.428571428571429 | 0.3358208955223881 | 0.0 |
497 | 497 | Santa Ynez Valley Cottage Hospital | 51331.0 | 2022-12-16 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.0 | 0.8571428571428571 | 0.0779220779220779 | 0.0 |
503 | 503 | Seneca District Hospital | 51327.0 | 2022-12-16 | Plumas | 63 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 1.5714285714285714 | 0.1571428571428571 | 0.0 |
509 | 509 | Shriners Hospitals For Children Northern Calif | 53311.0 | 2022-12-16 | Sacramento | 67 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 18.33333333333333 | 0.7051282051282051 | 0.0 |
511 | 511 | Sonoma Specialty Hospital | 052057 | 2022-12-16 | Sonoma | 97 | Bay Area | 0.0 | 0.0 | 0.0 | 30.4 | 0.8216216216216216 | 0.0 |
512 | 512 | Sonoma Valley Hospital | 050090 | 2022-12-16 | Sonoma | 97 | Bay Area | 0.0 | 0.0 | 0.0 | 8.428571428571429 | 0.3511904761904762 | 0.0 |
521 | 521 | Stanislaus Surgical Hospital | 050726 | 2022-12-16 | Stanislaus | 99 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 1.8571428571428568 | 0.0807453416149068 | 0.0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "hhs-hospital-patient-totals" ( [hospital] TEXT, [ccn] TEXT, [week] TEXT, [county] TEXT, [fips] INTEGER, [region] TEXT, [adult_covid_patients_total] FLOAT, [pediatric_covid_patients_total] FLOAT, [covid_patients_total] FLOAT, [occupied_beds_total] FLOAT, [occupied_beds_percent] FLOAT, [patients_with_covid_percent] FLOAT );