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.

33,821 rows

✎ View and edit SQL

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

Suggested facets: 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 2022-09-09 Kern 29 San Joaquin Valley 2.7142857142857144 0.0 17.714285714285715 17.714285714285715 1.0 0.1532258064516129
2 2 Adventist Health Clearlake 51317 2022-09-09 Lake 33 Northern California 0.0 0.7142857142857144 3.2857142857142856 4.0 0.8214285714285714 0.0
3 3 Adventist Health Delano 50608 2022-09-09 Kern 29 San Joaquin Valley 0.7142857142857143 0.0 4.428571428571429 4.428571428571429 1.0 0.1612903225806451
4 4 Adventist Health Hanford 50121 2022-09-09 Kings 31 San Joaquin Valley 0.0 3.7142857142857135 10.428571428571429 14.142857142857142 0.7373737373737375 0.0
5 5 Adventist Health Howard Memorial 51310 2022-09-09 Mendocino 45 Northern California 0.0 0.8571428571428572 3.142857142857143 4.0 0.7857142857142857 0.0
6 6 Adventist Health Lodi Memorial 50336 2022-09-09 San Joaquin 77 San Joaquin Valley 0.0 1.8571428571428577 4.857142857142857 6.714285714285714 0.7234042553191489 0.0
7 7 Adventist Health Mendocino Coast 51325 2022-09-09 Mendocino 45 Northern California 0.0 1.0 3.0 4.0 0.75 0.0
8 8 Adventist Health Simi Valley 50236 2022-09-09 Ventura 111 Southern California 1.0 2.0 10.714285714285714 12.714285714285714 0.8426966292134831 0.0933333333333333
9 9 Adventist Health Sonora 50335 2022-09-09 Tuolumne 109 San Joaquin Valley 0.5714285714285714 3.0 3.0 6.0 0.5 0.1904761904761904
10 10 Adventist Health St. Helena 50013 2022-09-09 Napa 55 Bay Area 0.0 0.7142857142857153 8.142857142857142 8.857142857142858 0.9193548387096772 0.0
11 11 Adventist Health Tehachapi Valley 51301 2022-09-09 Kern 29 San Joaquin Valley 0.7142857142857143 0.0 2.0 2.0 1.0 0.3571428571428571
12 12 Adventist Health Tulare 50784 2022-09-09 Tulare 107 San Joaquin Valley 0.0 2.0 2.0 4.0 0.5 0.0
13 13 Adventist Health Ukiah Valley 50301 2022-09-09 Mendocino 45 Northern California 0.0 0.4285714285714288 7.571428571428571 8.0 0.9464285714285714 0.0
14 14 Adventist Health and Rideout 50133 2022-09-09 Yuba 115 Greater Sacramento 0.0 10.714285714285714 13.285714285714286 24.0 0.5535714285714286 0.0
15 15 Ahmc Anaheim Regional Medical Center 50226 2022-09-09 Orange 59 Southern California 0.0 0.8571428571428577 11.428571428571429 12.285714285714286 0.9302325581395348 0.0
16 16 Ahmc Seton Medical Center 50289 2022-09-09 San Mateo 81 Bay Area 0.0 0.4285714285714288 6.285714285714286 6.714285714285714 0.9361702127659576 0.0
17 17 Alameda Hospital 50211 2022-09-09 Alameda 1 Bay Area 0.0 1.4285714285714288 6.571428571428571 8.0 0.8214285714285714 0.0
18 18 Alhambra Hospital Medical Center 50281 2022-09-09 Los Angeles 37 Southern California 1.0 1.8571428571428568 6.714285714285714 8.571428571428571 0.7833333333333333 0.1489361702127659
19 19 Alta Bates Summit Medical Center 50043 2022-09-09 Alameda 1 Bay Area 1.1428571428571428 21.285714285714285 14.714285714285714 36.0 0.4087301587301587 0.0776699029126213
20 20 Alta Bates Summit Medical Center - Alta Bates Camp 50305 2022-09-09 Alameda 1 Bay Area 1.7142857142857142 21.285714285714285 8.714285714285714 30.0 0.2904761904761904 0.1967213114754098
21 21 Alvarado Hospital Medical Center 50757 2022-09-09 San Diego 73 Southern California 1.0 2.428571428571429 9.428571428571429 11.857142857142858 0.7951807228915663 0.106060606060606
22 22 Anaheim Global Medical Center 50744 2022-09-09 Orange 59 Southern California 0.0 12.142857142857142 6.714285714285714 18.857142857142858 0.3560606060606061 0.0
23 23 Antelope Valley Hospital 50056 2022-09-09 Los Angeles 37 Southern California 1.1428571428571428 1.7142857142857153 27.285714285714285 29.0 0.9408866995073892 0.0418848167539267
24 24 Arrowhead Regional Medical Center 50245 2022-09-09 San Bernardino 71 Southern California 3.857142857142857 8.57142857142857 38.285714285714285 46.85714285714285 0.8170731707317074 0.1007462686567164
25 25 Bakersfield Heart Hospital 50724 2022-09-09 Kern 29 San Joaquin Valley 0.0 9.142857142857142 3.2857142857142856 12.428571428571429 0.264367816091954 0.0
26 26 Bakersfield Memorial Hospital 50036 2022-09-09 Kern 29 San Joaquin Valley 4.0 1.1428571428571423 21.714285714285715 22.857142857142858 0.95 0.1842105263157894
27 27 Barlow Respiratory Hospital 52031 2022-09-09 Los Angeles 37 Southern California 0.0 4.142857142857142 1.8571428571428568 6.0 0.3095238095238095 0.0
28 28 Barstow Community Hospital 50298 2022-09-09 San Bernardino 71 Southern California 1.2857142857142858 0.1428571428571428 3.2857142857142856 3.4285714285714284 0.9583333333333334 0.391304347826087
29 29 Barton Memorial Hospital 50352 2022-09-09 El Dorado 17 Greater Sacramento 0.7142857142857143 2.1428571428571423 2.7142857142857144 4.857142857142857 0.5588235294117648 0.2631578947368421
30 30 Beverly Hospital 50350 2022-09-09 Los Angeles 37 Southern California 0.0 15.857142857142858 9.142857142857142 25.0 0.3657142857142857 0.0
31 31 California Hospital Medical Center LA 50149 2022-09-09 Los Angeles 37 Southern California 3.0 7.142857142857142 22.857142857142858 30.0 0.761904761904762 0.13125
32 32 California Pacific Medical Center - Mission Bernal 50055 2022-09-09 San Francisco 75 Bay Area 2.0 4.571428571428571 5.428571428571429 10.0 0.5428571428571429 0.3684210526315789
33 33 California Pacific Medical Center- Van Ness Campus 50047 2022-09-09 San Francisco 75 Bay Area 1.0 2.857142857142854 33.142857142857146 36.0 0.9206349206349208 0.0301724137931034
34 34 California Pacific Medical Ctr-davies Campus Hosp 50008 2022-09-09 San Francisco 75 Bay Area 0.0 0.7142857142857144 7.285714285714286 8.0 0.9107142857142856 0.0
35 35 Casa Colina Hospital 50782 2022-09-09 Los Angeles 37 Southern California 0.0 3.0 1.5714285714285714 4.571428571428571 0.34375 0.0
36 36 Cedars-Sinai Marina Del Rey Hospital 50740 2022-09-09 Los Angeles 37 Southern California 1.4285714285714286 5.285714285714286 6.714285714285714 12.0 0.5595238095238095 0.2127659574468085
37 37 Cedars-Sinai Medical Center 50625 2022-09-09 Los Angeles 37 Southern California 1.2857142857142858 6.0 102.0 108.0 0.9444444444444444 0.0126050420168067
38 38 Centinela Hospital Medical Center 50739 2022-09-09 Los Angeles 37 Southern California 1.1428571428571428 9.0 21.571428571428573 30.571428571428573 0.705607476635514 0.0529801324503311
39 39 Chapman Global Medical Center 50745 2022-09-09 Orange 59 Southern California 0.0 8.0 4.0 12.0 0.3333333333333333 0.0
40 40 Chinese Hospital 50407 2022-09-09 San Francisco 75 Bay Area 1.1428571428571428 1.4285714285714288 3.7142857142857135 5.142857142857143 0.7222222222222222 0.3076923076923076
41 41 Chino Valley Medical Center 50586 2022-09-09 San Bernardino 71 Southern California 0.0 0.7142857142857144 5.285714285714286 6.0 0.8809523809523809 0.0
42 42 City of Hope Helford Clinical Research Hospital 50146 2022-09-09 Los Angeles 37 Southern California 1.0 2.428571428571429 15.285714285714286 17.714285714285715 0.8629032258064516 0.0654205607476635
43 43 Clovis Community Medical Center 50492 2022-09-09 Fresno 19 San Joaquin Valley 2.4285714285714284 6.428571428571427 17.571428571428573 24.0 0.7321428571428572 0.1382113821138211
44 44 Coast Plaza Hospital 50771 2022-09-09 Los Angeles 37 Southern California 0.0 1.0 6.0 7.0 0.8571428571428571 0.0
45 45 College Medical Center 50776 2022-09-09 Los Angeles 37 Southern California 0.0 1.8571428571428568 4.0 5.857142857142857 0.6829268292682927 0.0
46 46 Community Hospital of Huntington Park 50091 2022-09-09 Los Angeles 37 Southern California 0.0 0.4285714285714284 3.571428571428572 4.0 0.8928571428571429 0.0
47 47 Community Hospital of San Bernardino 50089 2022-09-09 San Bernardino 71 Southern California 0.8571428571428571 15.142857142857142 5.857142857142857 21.0 0.2789115646258503 0.1463414634146341
48 48 Community Hospital of the Monterey Peninsula 50145 2022-09-09 Monterey 53 Bay Area 0.0 14.571428571428571 11.428571428571429 26.0 0.4395604395604395 0.0
49 49 Community Memorial Hospital San Buenaventura 50394 2022-09-09 Ventura 111 Southern California 0.0 1.7142857142857135 14.571428571428571 16.285714285714285 0.8947368421052632 0.0
50 50 Community Regional Medical Center 50060 2022-09-09 Fresno 19 San Joaquin Valley 7.571428571428571 11.857142857142849 71.85714285714286 83.71428571428571 0.8583617747440274 0.1053677932405566
51 51 Contra Costa Regional Medical Center 50276 2022-09-09 Contra Costa 13 Bay Area 0.0 4.7142857142857135 13.285714285714286 18.0 0.7380952380952381 0.0
52 52 Corona Regional Medical Center 50329 2022-09-09 Riverside 65 Southern California 1.1428571428571428 7.714285714285715 15.142857142857142 22.857142857142858 0.6625 0.0754716981132075
53 53 Dameron Hospital 50122 2022-09-09 San Joaquin 77 San Joaquin Valley 0.7142857142857143 1.8571428571428577 5.285714285714286 7.142857142857143 0.74 0.1351351351351351
54 54 Desert Regional Medical Center 50243 2022-09-09 Riverside 65 Southern California 0.0 1.8571428571428577 29.714285714285715 31.571428571428573 0.9411764705882352 0.0
55 55 Desert Valley Hospital 50709 2022-09-09 San Bernardino 71 Southern California 2.571428571428572 2.142857142857141 15.285714285714286 17.428571428571427 0.8770491803278689 0.1682242990654205
56 56 Doctors Hospital of Manteca 50118 2022-09-09 San Joaquin 77 San Joaquin Valley 0.0 3.0 5.0 8.0 0.625 0.0
57 57 Doctors Hospital of Riverside, LLC 50102 2022-09-09 Riverside 65 Southern California 0.0 0.1428571428571441 10.142857142857142 10.285714285714286 0.9861111111111108 0.0
58 58 Doctors Medical Center 50464 2022-09-09 Stanislaus 99 San Joaquin Valley 2.4285714285714284 10.142857142857146 33.857142857142854 44.0 0.7694805194805194 0.0717299578059071
59 59 Dominican Hospital 50242 2022-09-09 Santa Cruz 87 Bay Area 0.7142857142857143 0.5714285714285712 14.142857142857142 14.714285714285714 0.9611650485436892 0.0505050505050505
60 60 East Los Angeles Doctors Hospital 50641 2022-09-09 Los Angeles 37 Southern California 0.0 1.0 6.428571428571429 7.428571428571429 0.8653846153846154 0.0
61 61 Eden Medical Center 50488 2022-09-09 Alameda 1 Bay Area 3.142857142857143 1.7142857142857153 22.285714285714285 24.0 0.9285714285714284 0.141025641025641
62 62 Eisenhower Medical Center 50573 2022-09-09 Riverside 65 Southern California 1.0 4.428571428571427 23.857142857142858 28.285714285714285 0.8434343434343435 0.0419161676646706
63 63 El Camino Hospital 50308 2022-09-09 Santa Clara 85 Bay Area 4.571428571428571 7.571428571428573 24.428571428571427 32.0 0.7633928571428571 0.1871345029239766
64 64 El Centro Regional Medical Center 50045 2022-09-09 Imperial 25 Southern California 2.4285714285714284 4.142857142857143 4.142857142857143 8.285714285714286 0.5 0.5862068965517241
65 65 Emanate Health Foothill Presbyterian Hospital 50597 2022-09-09 Los Angeles 37 Southern California 0.8571428571428571 6.142857142857142 11.857142857142858 18.0 0.6587301587301587 0.072289156626506
66 66 Emanate Health Inter-community Hospital 50382 2022-09-09 Los Angeles 37 Southern California 0.5714285714285714 8.857142857142858 31.142857142857142 40.0 0.7785714285714286 0.018348623853211
67 67 Emanuel Medical Center 50179 2022-09-09 Stanislaus 99 San Joaquin Valley 0.0 7.142857142857143 4.857142857142857 12.0 0.4047619047619047 0.0
68 68 Encino Hospital Medical Center 50158 2022-09-09 Los Angeles 37 Southern California 0.0 0.0 2.2857142857142856 2.2857142857142856 1.0 0.0
69 69 Enloe Medical Center 50039 2022-09-09 Butte 7 Greater Sacramento 0.0 9.142857142857142 14.857142857142858 24.0 0.6190476190476191 0.0
70 70 Fairchild Medical Center 51316 2022-09-09 Siskiyou 93 Northern California 0.5714285714285714 0.4285714285714284 3.0 3.4285714285714284 0.875 0.1904761904761904
71 71 Foothill Regional Medical Center 50780 2022-09-09 Orange 59 Southern California 2.2857142857142856 6.571428571428571 6.428571428571429 13.0 0.4945054945054945 0.3555555555555555
72 72 Fountain Valley Regional Hospital & Medical Center 50570 2022-09-09 Orange 59 Southern California 0.0 5.571428571428573 19.428571428571427 25.0 0.7771428571428571 0.0
73 73 French Hospital Medical Center 50232 2022-09-09 San Luis Obispo 79 Southern California 1.0 0.7142857142857144 6.0 6.714285714285714 0.8936170212765957 0.1666666666666666
74 74 Fresno Heart and Surgical Hospital 50732 2022-09-09 Fresno 19 San Joaquin Valley 0.0 2.7142857142857144 6.285714285714286 9.0 0.6984126984126984 0.0
75 75 Garden Grove Hospital & Medical Center 50230 2022-09-09 Orange 59 Southern California 1.4285714285714286 1.0 6.428571428571429 7.428571428571429 0.8653846153846154 0.2222222222222222
76 76 Garfield Medical Center 50737 2022-09-09 Los Angeles 37 Southern California 0.0 10.428571428571429 11.571428571428571 22.0 0.525974025974026 0.0
77 77 Glendale Adventist Medical Center 50239 2022-09-09 Los Angeles 37 Southern California 2.0 1.2857142857142885 16.428571428571427 17.714285714285715 0.9274193548387096 0.1217391304347826
78 78 Glendale Mem Hospital & Health Center 50058 2022-09-09 Los Angeles 37 Southern California 0.0 0.0 10.142857142857142 10.142857142857142 1.0 0.0
79 79 Good Samaritan Hospital 50380 2022-09-09 Santa Clara 85 Bay Area 0.8571428571428571 10.0 27.0 37.0 0.7297297297297297 0.0317460317460317
80 80 Greater El Monte Community Hospital 50738 2022-09-09 Los Angeles 37 Southern California 1.1428571428571428 6.7142857142857135 1.8571428571428568 8.571428571428571 0.2166666666666666 0.6153846153846153
81 81 Grossmont Hospital 50026 2022-09-09 San Diego 73 Southern California 3.2857142857142856 15.42857142857143 59.57142857142857 75.0 0.7942857142857143 0.0551558752997601
82 82 Hazel Hawkins Memorial Hospital 51337 2022-09-09 San Benito 69 San Joaquin Valley 0.5714285714285714 1.2857142857142856 2.7142857142857144 4.0 0.6785714285714286 0.2105263157894736
83 83 Healdsburg Hospital 51321 2022-09-09 Sonoma 97 Bay Area 0.0 4.285714285714286 0.0 4.285714285714286 0.0  
84 84 Hemet Global Medical Center 50390 2022-09-09 Riverside 65 Southern California   11.333333333333334 14.666666666666666 26.0 0.5641025641025641  
85 85 Henry Mayo Newhall Hospital 50624 2022-09-09 Los Angeles 37 Southern California 0.0 3.1428571428571423 14.857142857142858 18.0 0.8253968253968255 0.0
86 86 Hi-desert Medical Center 50279 2022-09-09 San Bernardino 71 Southern California 0.0 0.2857142857142856 3.7142857142857135 4.0 0.9285714285714286 0.0
87 87 Highland Hospital 50320 2022-09-09 Alameda 1 Bay Area 1.7142857142857142 10.142857142857142 22.857142857142858 33.0 0.6926406926406926 0.075
88 88 Hoag Memorial Hospital Presbyterian 50224 2022-09-09 Orange 59 Southern California 0.7142857142857143 22.142857142857142 25.857142857142858 48.0 0.5386904761904762 0.0276243093922651
89 89 Hollywood Presbyterian Medical Center 50063 2022-09-09 Los Angeles 37 Southern California 0.0 6.928571428571427 12.5 19.428571428571427 0.6433823529411765 0.0
90 90 Huntington Beach Hospital 50526 2022-09-09 Orange 59 Southern California 0.0 0.4285714285714288 6.571428571428571 7.0 0.9387755102040816 0.0
91 91 Huntington Hospital 50438 2022-09-09 Los Angeles 37 Southern California 4.428571428571429 10.999999999999996 25.571428571428573 36.57142857142857 0.6992187500000001 0.1731843575418994
92 92 John F Kennedy Memorial Hospital 50534 2022-09-09 Riverside 65 Southern California 0.0 12.142857142857142 3.857142857142857 16.0 0.2410714285714285 0.0
93 93 John Muir Medical Center - Concord Campus 50496 2022-09-09 Contra Costa 13 Bay Area 2.2857142857142856 11.000000000000004 26.428571428571427 37.42857142857143 0.7061068702290075 0.0864864864864864
94 94 John Muir Medical Center - Walnut Creek Campus 50180 2022-09-09 Contra Costa 13 Bay Area 1.7142857142857142 7.0 41.0 48.0 0.8541666666666666 0.0418118466898954
95 95 Kaiser Foundation Hosp So Sacramento 50674 2022-09-09 Sacramento 67 Greater Sacramento 3.857142857142857 1.5714285714285694 19.714285714285715 21.285714285714285 0.9261744966442954 0.1956521739130434
96 96 Kaiser Foundation Hospital 50510 2022-09-09 Marin 41 Bay Area 0.7142857142857143 0.0 2.571428571428572 2.571428571428572 1.0 0.2777777777777778
97 97 Kaiser Foundation Hospital - Antioch 50760 2022-09-09 Contra Costa 13 Bay Area 1.2857142857142858 0.8571428571428577 8.571428571428571 9.428571428571429 0.9090909090909092 0.15
98 98 Kaiser Foundation Hospital - Baldwin Park 50723 2022-09-09 Los Angeles 37 Southern California 0.0 6.0 6.0 12.0 0.5 0.0
99 99 Kaiser Foundation Hospital - Downey 50139 2022-09-09 Los Angeles 37 Southern California 0.8571428571428571 15.0 13.0 28.0 0.4642857142857143 0.0659340659340659
100 100 Kaiser Foundation Hospital - Fremont 50512 2022-09-09 Alameda 1 Bay Area 2.571428571428572 0.7142857142857135 8.285714285714286 9.0 0.9206349206349208 0.3103448275862069

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