hhs-hospital-icu-totals

Table actions

The Department of Health and Human Services releases a weekly update on the number of COVID-19 patients in intensive-care units. This file contains the key metrics for facilities in California.

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.

21,422 rows

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: region, week (date)

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
1 1 Adventist Health Bakersfield 50455 2021-11-26 Kern 29 San Joaquin Valley 7.0 0.2857142857142847 24.0 24.285714285714285 0.9882352941176472 0.2916666666666667
2 2 Adventist Health Clearlake 51317 2021-11-26 Lake 33 Northern California 0.0 0.1428571428571428 3.857142857142857 4.0 0.9642857142857144 0.0
3 3 Adventist Health Delano 50608 2021-11-26 Kern 29 San Joaquin Valley 2.571428571428572 0.0 9.0 9.0 1.0 0.2857142857142857
4 4 Adventist Health Hanford 50121 2021-11-26 Kings 31 San Joaquin Valley 5.428571428571429 3.0 17.0 20.0 0.85 0.319327731092437
5 5 Adventist Health Howard Memorial 51310 2021-11-26 Mendocino 45 Northern California 0.0 0.2857142857142856 3.571428571428572 3.857142857142857 0.925925925925926 0.0
6 6 Adventist Health Lodi Memorial 50336 2021-11-26 San Joaquin 77 San Joaquin Valley 3.142857142857143 0.4285714285714288 9.571428571428571 10.0 0.9571428571428572 0.3283582089552239
7 7 Adventist Health Mendocino Coast 51325 2021-11-26 Mendocino 45 Northern California 0.0 1.285714285714286 2.4285714285714284 3.7142857142857135 0.6538461538461537 0.0
8 8 Adventist Health Simi Valley 50236 2021-11-26 Ventura 111 Southern California 1.0 1.2857142857142856 5.0 6.285714285714286 0.7954545454545455 0.2
9 9 Adventist Health Sonora 50335 2021-11-26 Tuolumne 109 San Joaquin Valley 0.0 2.7142857142857144 3.2857142857142856 6.0 0.5476190476190476 0.0
10 10 Adventist Health St. Helena 50013 2021-11-26 Napa 55 Bay Area 1.2857142857142858 1.1428571428571423 7.0 8.142857142857142 0.8596491228070176 0.1836734693877551
11 11 Adventist Health Tehachapi Valley 51301 2021-11-26 Kern 29 San Joaquin Valley 2.4285714285714284 0.0 3.4285714285714284 3.4285714285714284 1.0 0.7083333333333334
12 12 Adventist Health Tulare 50784 2021-11-26 Tulare 107 San Joaquin Valley 4.285714285714286 2.2857142857142856 5.428571428571429 7.714285714285714 0.7037037037037037 0.7894736842105262
13 13 Adventist Health Ukiah Valley 50301 2021-11-26 Mendocino 45 Northern California 2.857142857142857 0.8571428571428568 6.428571428571429 7.285714285714286 0.8823529411764707 0.4444444444444444
14 14 Adventist Health and Rideout 50133 2021-11-26 Yuba 115 Greater Sacramento 10.857142857142858 0.0 26.857142857142858 26.857142857142858 1.0 0.4042553191489362
15 15 Ahmc Anaheim Regional Medical Center 50226 2021-11-26 Orange 59 Southern California 2.142857142857143 3.0 8.0 11.0 0.7272727272727273 0.2678571428571428
16 16 Ahmc Seton Medical Center 50289 2021-11-26 San Mateo 81 Bay Area 0.0 0.2857142857142847 10.285714285714286 10.571428571428571 0.972972972972973 0.0
17 17 Alameda Hospital 50211 2021-11-26 Alameda 1 Bay Area 0.0 4.857142857142858 3.142857142857143 8.0 0.3928571428571428 0.0
18 18 Alhambra Hospital Medical Center 50281 2021-11-26 Los Angeles 37 Southern California 0.5714285714285714 1.4285714285714288 4.857142857142857 6.285714285714286 0.7727272727272727 0.1176470588235294
19 19 Alta Bates Summit Medical Center 50043 2021-11-26 Alameda 1 Bay Area 0.0 25.285714285714285 10.714285714285714 36.0 0.2976190476190476 0.0
20 20 Alta Bates Summit Medical Center - Alta Bates Camp 50305 2021-11-26 Alameda 1 Bay Area 0.0 18.42857142857143 11.571428571428571 30.0 0.3857142857142857 0.0
21 21 Alvarado Hospital Medical Center 50757 2021-11-26 San Diego 73 Southern California 0.0 4.7142857142857135 9.285714285714286 14.0 0.663265306122449 0.0
22 22 Anaheim Global Medical Center 50744 2021-11-26 Orange 59 Southern California 1.2857142857142858 17.285714285714285 4.714285714285714 22.0 0.2142857142857143 0.2727272727272727
23 23 Antelope Valley Hospital 50056 2021-11-26 Los Angeles 37 Southern California 5.0 0.7142857142857153 24.428571428571427 25.142857142857142 0.9715909090909092 0.2046783625730994
24 24 Arrowhead Regional Medical Center 50245 2021-11-26 San Bernardino 71 Southern California 6.285714285714286 14.57142857142857 33.42857142857143 48.0 0.6964285714285715 0.188034188034188
25 25 Bakersfield Heart Hospital 50724 2021-11-26 Kern 29 San Joaquin Valley 1.0 2.1428571428571432 7.857142857142857 10.0 0.7857142857142857 0.1272727272727273
26 26 Bakersfield Memorial Hospital 50036 2021-11-26 Kern 29 San Joaquin Valley 6.0 3.0 27.285714285714285 30.285714285714285 0.9009433962264152 0.2198952879581152
27 27 Barlow Respiratory Hospital 52031 2021-11-26 Los Angeles 37 Southern California 0.0 4.0 2.0 6.0 0.3333333333333333 0.0
28 28 Barstow Community Hospital 50298 2021-11-26 San Bernardino 71 Southern California 0.0 3.0 4.0 7.0 0.5714285714285714 0.0
29 29 Barton Memorial Hospital 50352 2021-11-26 El Dorado 17 Greater Sacramento 1.8571428571428568 0.8571428571428577 4.285714285714286 5.142857142857143 0.8333333333333333 0.4333333333333333
30 30 Beverly Hospital 50350 2021-11-26 Los Angeles 37 Southern California 0.7142857142857143 15.0 10.0 25.0 0.4 0.0714285714285714
31 31 California Hospital Medical Center LA 50149 2021-11-26 Los Angeles 37 Southern California 0.0 13.142857142857142 16.857142857142858 30.0 0.5619047619047619 0.0
32 32 California Pacific Medical Center - Mission Bernal 50055 2021-11-26 San Francisco 75 Bay Area 1.2857142857142858 5.285714285714286 4.714285714285714 10.0 0.4714285714285714 0.2727272727272727
33 33 California Pacific Medical Center- Van Ness Campus 50047 2021-11-26 San Francisco 75 Bay Area 0.0 7.428571428571427 28.571428571428573 36.0 0.7936507936507937 0.0
34 34 California Pacific Medical Ctr-davies Campus Hosp 50008 2021-11-26 San Francisco 75 Bay Area 0.0 2.1428571428571432 5.857142857142857 8.0 0.7321428571428571 0.0
35 35 Casa Colina Hospital 50782 2021-11-26 Los Angeles 37 Southern California 0.0 3.4285714285714284 2.571428571428572 6.0 0.4285714285714286 0.0
36 36 Cedars-Sinai Marina Del Rey Hospital 50740 2021-11-26 Los Angeles 37 Southern California 0.8571428571428571 5.428571428571429 6.571428571428571 12.0 0.5476190476190476 0.1304347826086956
37 37 Cedars-Sinai Medical Center 50625 2021-11-26 Los Angeles 37 Southern California 3.571428571428572 3.4285714285714306 104.57142857142856 108.0 0.9682539682539684 0.0341530054644808
38 38 Centinela Hospital Medical Center 50739 2021-11-26 Los Angeles 37 Southern California 1.7142857142857142 7.428571428571427 27.142857142857142 34.57142857142857 0.7851239669421488 0.0631578947368421
39 39 Chapman Global Medical Center 50745 2021-11-26 Orange 59 Southern California 2.0 5.2 6.8 12.0 0.5666666666666667 0.2941176470588235
40 40 Chinese Hospital 50407 2021-11-26 San Francisco 75 Bay Area 0.0 2.2857142857142856 3.7142857142857135 6.0 0.6190476190476191 0.0
41 41 Chino Valley Medical Center 50586 2021-11-26 San Bernardino 71 Southern California 1.4285714285714286 0.5714285714285712 6.285714285714286 6.857142857142857 0.9166666666666669 0.2272727272727273
42 42 City of Hope Helford Clinical Research Hospital 50146 2021-11-26 Los Angeles 37 Southern California 0.0 1.1428571428571423 16.857142857142858 18.0 0.9365079365079364 0.0
43 43 Clovis Community Medical Center 50492 2021-11-26 Fresno 19 San Joaquin Valley 6.142857142857143 4.000000000000004 31.142857142857142 35.142857142857146 0.8861788617886178 0.1972477064220183
44 44 Coast Plaza Hospital 50771 2021-11-26 Los Angeles 37 Southern California 0.0 3.7142857142857135 3.2857142857142856 7.0 0.4693877551020408 0.0
45 45 College Medical Center 50776 2021-11-26 Los Angeles 37 Southern California 0.0 7.428571428571429 7.571428571428571 15.0 0.5047619047619047 0.0
46 46 Community Hospital of Huntington Park 50091 2021-11-26 Los Angeles 37 Southern California 1.0 6.0 0.0 6.0 0.0 inf
47 47 Community Hospital of San Bernardino 50089 2021-11-26 San Bernardino 71 Southern California 3.571428571428572 14.999999999999998 9.428571428571429 24.428571428571427 0.3859649122807018 0.3787878787878788
48 48 Community Hospital of the Monterey Peninsula 50145 2021-11-26 Monterey 53 Bay Area 0.0 13.142857142857142 12.857142857142858 26.0 0.4945054945054945 0.0
49 49 Community Memorial Hospital San Buenaventura 50394 2021-11-26 Ventura 111 Southern California 0.6666666666666666 2.5 13.5 16.0 0.84375 0.0493827160493827
50 50 Community Regional Medical Center 50060 2021-11-26 Fresno 19 San Joaquin Valley 20.142857142857142 7.857142857142861 74.14285714285714 82.0 0.9041811846689894 0.2716763005780347
51 51 Contra Costa Regional Medical Center 50276 2021-11-26 Contra Costa 13 Bay Area 2.7142857142857144 4.428571428571429 13.571428571428571 18.0 0.753968253968254 0.2
52 52 Corona Regional Medical Center 50329 2021-11-26 Riverside 65 Southern California 9.142857142857142 5.571428571428573 16.428571428571427 22.0 0.7467532467532467 0.5565217391304348
53 53 Dameron Hospital 50122 2021-11-26 San Joaquin 77 San Joaquin Valley 5.714285714285714 0.8571428571428577 10.428571428571429 11.285714285714286 0.9240506329113924 0.547945205479452
54 54 Desert Regional Medical Center 50243 2021-11-26 Riverside 65 Southern California 5.0 0.5714285714285694 33.42857142857143 34.0 0.9831932773109244 0.1495726495726495
55 55 Desert Valley Hospital 50709 2021-11-26 San Bernardino 71 Southern California 12.285714285714286 0.0 19.428571428571427 19.428571428571427 1.0 0.6323529411764707
56 56 Doctors Hospital of Manteca 50118 2021-11-26 San Joaquin 77 San Joaquin Valley 2.571428571428572 1.1428571428571432 6.857142857142857 8.0 0.8571428571428571 0.375
57 57 Doctors Hospital of Riverside, LLC 50102 2021-11-26 Riverside 65 Southern California 1.5714285714285714 2.2857142857142865 8.571428571428571 10.857142857142858 0.7894736842105262 0.1833333333333333
58 58 Doctors Medical Center 50464 2021-11-26 Stanislaus 99 San Joaquin Valley 6.714285714285714 7.857142857142854 36.142857142857146 44.0 0.8214285714285715 0.1857707509881422
59 59 Dominican Hospital 50242 2021-11-26 Santa Cruz 87 Bay Area 2.142857142857143 0.4285714285714288 12.142857142857142 12.571428571428571 0.9659090909090908 0.1764705882352941
60 60 East Los Angeles Doctors Hospital 50641 2021-11-26 Los Angeles 37 Southern California 0.0 6.857142857142857 2.2857142857142856 9.142857142857142 0.25 0.0
61 61 Eden Medical Center 50488 2021-11-26 Alameda 1 Bay Area 2.0 9.571428571428571 14.428571428571429 24.0 0.6011904761904762 0.1386138613861386
62 62 Eisenhower Medical Center 50573 2021-11-26 Riverside 65 Southern California 3.0 4.571428571428573 21.0 25.571428571428573 0.8212290502793296 0.1428571428571428
63 63 El Camino Hospital 50308 2021-11-26 Santa Clara 85 Bay Area 1.0 14.428571428571429 17.571428571428573 32.0 0.5491071428571429 0.056910569105691
64 64 El Centro Regional Medical Center 50045 2021-11-26 Imperial 25 Southern California 10.428571428571429 0.0 18.285714285714285 18.285714285714285 1.0 0.5703125
65 65 Emanate Health Foothill Presbyterian Hospital 50597 2021-11-26 Los Angeles 37 Southern California 1.5714285714285714 11.857142857142858 6.142857142857143 18.0 0.3412698412698413 0.255813953488372
66 66 Emanate Health Inter-community Hospital 50382 2021-11-26 Los Angeles 37 Southern California 6.285714285714286 6.142857142857146 33.857142857142854 40.0 0.8464285714285713 0.1856540084388185
67 67 Emanuel Medical Center 50179 2021-11-26 Stanislaus 99 San Joaquin Valley 4.0 6.285714285714286 5.714285714285714 12.0 0.4761904761904762 0.7
68 68 Encino Hospital Medical Center 50158 2021-11-26 Los Angeles 37 Southern California 1.0 1.0 3.0 4.0 0.75 0.3333333333333333
69 69 Enloe Medical Center 50039 2021-11-26 Butte 7 Greater Sacramento 4.142857142857143 6.428571428571427 17.571428571428573 24.0 0.7321428571428572 0.2357723577235772
70 70 Fairchild Medical Center 51316 2021-11-26 Siskiyou 93 Northern California 1.1428571428571428 1.4285714285714288 3.2857142857142856 4.714285714285714 0.6969696969696969 0.3478260869565217
71 71 Foothill Regional Medical Center 50780 2021-11-26 Orange 59 Southern California 2.2857142857142856 4.571428571428571 8.428571428571429 13.0 0.6483516483516484 0.2711864406779661
72 72 Fountain Valley Regional Hospital & Medical Center 50570 2021-11-26 Orange 59 Southern California 1.1428571428571428 3.1428571428571423 21.857142857142858 25.0 0.8742857142857143 0.0522875816993464
73 73 French Hospital Medical Center 50232 2021-11-26 San Luis Obispo 79 Southern California 2.142857142857143 1.1428571428571423 6.142857142857143 7.285714285714286 0.8431372549019609 0.3488372093023255
74 74 Fresno Heart and Surgical Hospital 50732 2021-11-26 Fresno 19 San Joaquin Valley 0.0 3.428571428571429 5.571428571428571 9.0 0.6190476190476191 0.0
75 75 Garden Grove Hospital & Medical Center 50230 2021-11-26 Orange 59 Southern California 1.0 1.0 6.142857142857143 7.142857142857143 0.86 0.1627906976744186
76 76 Garfield Medical Center 50737 2021-11-26 Los Angeles 37 Southern California 0.7142857142857143 6.428571428571429 15.571428571428571 22.0 0.7077922077922078 0.0458715596330275
77 77 Glendale Adventist Medical Center 50239 2021-11-26 Los Angeles 37 Southern California 6.142857142857143 0.4285714285714306 23.285714285714285 23.714285714285715 0.9819277108433734 0.2638036809815951
78 78 Glendale Mem Hospital & Health Center 50058 2021-11-26 Los Angeles 37 Southern California 0.0 0.0 10.857142857142858 10.857142857142858 1.0 0.0
79 79 Goleta Valley Cottage Hospital 50357 2021-11-26 Santa Barbara 83 Southern California 0.0 0.0 0.8571428571428571 0.8571428571428571 1.0 0.0
80 80 Good Samaritan Hospital 50257 2021-11-26 Kern 29 San Joaquin Valley 0.0 4.0 0.0 4.0 0.0  
81 81 Good Samaritan Hospital 50380 2021-11-26 Santa Clara 85 Bay Area 3.2857142857142856 9.714285714285715 27.285714285714285 37.0 0.7374517374517374 0.1204188481675392
82 82 Good Samaritan Hospital 50471 2021-11-26 Los Angeles 37 Southern California 3.2857142857142856 27.428571428571427 31.571428571428573 59.0 0.5351089588377724 0.1040723981900452
83 83 Greater El Monte Community Hospital 50738 2021-11-26 Los Angeles 37 Southern California 0.6666666666666666 6.0 4.0 10.0 0.4 0.1666666666666666
84 84 Grossmont Hospital 50026 2021-11-26 San Diego 73 Southern California 10.571428571428571 7.0 68.0 75.0 0.9066666666666666 0.1554621848739495
85 85 Hazel Hawkins Memorial Hospital 51337 2021-11-26 San Benito 69 San Joaquin Valley 1.0 1.2857142857142856 2.7142857142857144 4.0 0.6785714285714286 0.3684210526315789
86 86 Healdsburg Hospital 51321 2021-11-26 Sonoma 97 Bay Area 0.0 3.7142857142857135 1.2857142857142858 5.0 0.2571428571428572 0.0
87 87 Hemet Global Medical Center 50390 2021-11-26 Riverside 65 Southern California 4.857142857142857 6.571428571428573 19.428571428571427 26.0 0.7472527472527472 0.25
88 88 Henry Mayo Newhall Hospital 50624 2021-11-26 Los Angeles 37 Southern California 7.5 2.5 23.166666666666668 25.666666666666668 0.9025974025974026 0.3237410071942446
89 89 Hi-desert Medical Center 50279 2021-11-26 San Bernardino 71 Southern California 1.5714285714285714 0.1428571428571428 3.857142857142857 4.0 0.9642857142857144 0.4074074074074074
90 90 Highland Hospital 50320 2021-11-26 Alameda 1 Bay Area 1.0 7.0 26.0 33.0 0.7878787878787878 0.0384615384615384
91 91 Hoag Memorial Hospital Presbyterian 50224 2021-11-26 Orange 59 Southern California 8.857142857142858 22.71428571428571 26.571428571428573 49.285714285714285 0.5391304347826087 0.3333333333333333
92 92 Hollywood Presbyterian Medical Center 50063 2021-11-26 Los Angeles 37 Southern California 0.8571428571428571 6.571428571428573 17.428571428571427 24.0 0.7261904761904762 0.0491803278688524
93 93 Huntington Beach Hospital 50526 2021-11-26 Orange 59 Southern California 0.8571428571428571 0.4285714285714288 7.571428571428571 8.0 0.9464285714285714 0.1132075471698113
94 94 Huntington Hospital 50438 2021-11-26 Los Angeles 37 Southern California 2.4285714285714284 7.428571428571431 23.285714285714285 30.714285714285715 0.7581395348837209 0.1042944785276073
95 95 John F Kennedy Memorial Hospital 50534 2021-11-26 Riverside 65 Southern California 2.142857142857143 14.0 10.0 24.0 0.4166666666666667 0.2142857142857142
96 96 John Muir Medical Center - Concord Campus 50496 2021-11-26 Contra Costa 13 Bay Area 3.142857142857143 12.0 24.0 36.0 0.6666666666666666 0.1309523809523809
97 97 John Muir Medical Center - Walnut Creek Campus 50180 2021-11-26 Contra Costa 13 Bay Area 2.857142857142857 4.857142857142854 43.142857142857146 48.0 0.8988095238095238 0.0662251655629139
98 98 Kaiser Foundation Hosp So Sacramento 50674 2021-11-26 Sacramento 67 Greater Sacramento 7.285714285714286 0.428571428571427 30.714285714285715 31.142857142857142 0.9862385321100918 0.2372093023255813
99 99 Kaiser Foundation Hospital 50510 2021-11-26 Marin 41 Bay Area 1.0 0.7142857142857144 5.285714285714286 6.0 0.8809523809523809 0.1891891891891892
100 100 Kaiser Foundation Hospital - Antioch 50760 2021-11-26 Contra Costa 13 Bay Area 1.2857142857142858 0.7142857142857144 7.714285714285714 8.428571428571429 0.9152542372881356 0.1666666666666666

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);