home / la-times

Menu
  • GraphQL API

hhs-hospital-icu-totals

Table actions
  • GraphQL API for hhs-hospital-icu-totals

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.

38,919 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 2022-12-23 Kern 29 San Joaquin Valley 0.0 0.0 14.0 14.0 1.0 0.0
2 2 Adventist Health Clearlake 51317 2022-12-23 Lake 33 Northern California 0.0 0.0 4.0 4.0 1.0 0.0
3 3 Adventist Health Hanford 50121 2022-12-23 Kings 31 San Joaquin Valley 0.0 2.0 13.0 15.0 0.8666666666666667 0.0
4 4 Adventist Health Howard Memorial 51310 2022-12-23 Mendocino 45 Northern California 0.0 1.5 2.5 4.0 0.625 0.0
5 5 Adventist Health Lodi Memorial 50336 2022-12-23 San Joaquin 77 San Joaquin Valley 4.0 0.0 10.0 10.0 1.0 0.4
6 6 Adventist Health Mendocino Coast 51325 2022-12-23 Mendocino 45 Northern California 0.0 0.0 4.0 4.0 1.0 0.0
7 7 Adventist Health Simi Valley 50236 2022-12-23 Ventura 111 Southern California 0.0 4.0 6.0 10.0 0.6 0.0
8 8 Adventist Health Sonora 50335 2022-12-23 Tuolumne 109 San Joaquin Valley 0.0 1.0 5.0 6.0 0.8333333333333334 0.0
9 9 Adventist Health St. Helena 50013 2022-12-23 Napa 55 Bay Area 0.0 0.0 7.0 7.0 1.0 0.0
10 10 Adventist Health Tehachapi Valley 51301 2022-12-23 Kern 29 San Joaquin Valley 0.0 0.0 4.0 4.0 1.0 0.0
11 11 Adventist Health Tulare 50784 2022-12-23 Tulare 107 San Joaquin Valley 0.0 4.0 0.0 4.0 0.0  
12 12 Adventist Health Ukiah Valley 50301 2022-12-23 Mendocino 45 Northern California 0.0 0.0 8.0 8.0 1.0 0.0
13 13 Adventist Health and Rideout 50133 2022-12-23 Yuba 115 Greater Sacramento 0.0 6.0 18.0 24.0 0.75 0.0
14 14 Ahmc Anaheim Regional Medical Center 50226 2022-12-23 Orange 59 Southern California 0.0 0.0 10.0 10.0 1.0 0.0
15 15 Ahmc Seton Medical Center 50289 2022-12-23 San Mateo 81 Bay Area 0.0 0.0 11.0 11.0 1.0 0.0
16 16 Alameda Hospital 50211 2022-12-23 Alameda 1 Bay Area 1.0 0.0 8.0 8.0 1.0 0.125
17 17 Alhambra Hospital Medical Center 50281 2022-12-23 Los Angeles 37 Southern California 0.0 3.0 9.0 12.0 0.75 0.0
18 18 Alta Bates Summit Medical Center 50043 2022-12-23 Alameda 1 Bay Area 0.0 17.0 19.0 36.0 0.5277777777777778 0.0
19 19 Alta Bates Summit Medical Center - Alta Bates Camp 50305 2022-12-23 Alameda 1 Bay Area 0.0 17.0 13.0 30.0 0.4333333333333333 0.0
20 20 Alvarado Hospital Medical Center 50757 2022-12-23 San Diego 73 Southern California 0.0 0.0 11.0 11.0 1.0 0.0
21 21 Anaheim Global Medical Center 50744 2022-12-23 Orange 59 Southern California 0.0 18.0 4.0 22.0 0.1818181818181818 0.0
22 22 Antelope Valley Hospital 50056 2022-12-23 Los Angeles 37 Southern California 7.0 0.0 28.0 28.0 1.0 0.25
23 23 Arrowhead Regional Medical Center 50245 2022-12-23 San Bernardino 71 Southern California 6.5 13.5 34.5 48.0 0.71875 0.1884057971014492
24 24 Bakersfield Memorial Hospital 50036 2022-12-23 Kern 29 San Joaquin Valley 5.0 0.0 26.0 26.0 1.0 0.1923076923076923
25 25 Barlow Respiratory Hospital 52031 2022-12-23 Los Angeles 37 Southern California 0.0 2.0 4.0 6.0 0.6666666666666666 0.0
26 26 Beverly Hospital 50350 2022-12-23 Los Angeles 37 Southern California 0.0 15.0 10.0 25.0 0.4 0.0
27 27 California Hospital Medical Center LA 50149 2022-12-23 Los Angeles 37 Southern California 0.0 9.0 21.0 30.0 0.7 0.0
28 28 California Pacific Medical Center - Mission Bernal 50055 2022-12-23 San Francisco 75 Bay Area 0.0 4.0 6.0 10.0 0.6 0.0
29 29 California Pacific Medical Center- Van Ness Campus 50047 2022-12-23 San Francisco 75 Bay Area 6.0 2.0 34.0 36.0 0.9444444444444444 0.1764705882352941
30 30 California Pacific Medical Ctr-davies Campus Hosp 50008 2022-12-23 San Francisco 75 Bay Area 0.0 0.0 8.0 8.0 1.0 0.0
31 31 Casa Colina Hospital 50782 2022-12-23 Los Angeles 37 Southern California 0.0 2.0 4.0 6.0 0.6666666666666666 0.0
32 32 Cedars-Sinai Marina Del Rey Hospital 50740 2022-12-23 Los Angeles 37 Southern California 0.0 4.0 8.0 12.0 0.6666666666666666 0.0
33 33 Cedars-Sinai Medical Center 50625 2022-12-23 Los Angeles 37 Southern California 12.0 0.0 108.0 108.0 1.0 0.1111111111111111
34 34 Centinela Hospital Medical Center 50739 2022-12-23 Los Angeles 37 Southern California 0.0 0.0 23.0 23.0 1.0 0.0
35 35 Chinese Hospital 50407 2022-12-23 San Francisco 75 Bay Area 0.0 6.0 0.0 6.0 0.0  
36 36 Chino Valley Medical Center 50586 2022-12-23 San Bernardino 71 Southern California 0.0 0.0 6.0 6.0 1.0 0.0
37 37 City of Hope Helford Clinical Research Hospital 50146 2022-12-23 Los Angeles 37 Southern California 0.0 3.0 15.0 18.0 0.8333333333333334 0.0
38 38 Clovis Community Medical Center 50492 2022-12-23 Fresno 19 San Joaquin Valley 0.0 11.0 13.0 24.0 0.5416666666666666 0.0
39 39 Coast Plaza Hospital 50771 2022-12-23 Los Angeles 37 Southern California 0.0 1.0 6.0 7.0 0.8571428571428571 0.0
40 40 College Medical Center 50776 2022-12-23 Los Angeles 37 Southern California 0.0 3.0 5.0 8.0 0.625 0.0
41 41 Community Hospital of Huntington Park 50091 2022-12-23 Los Angeles 37 Southern California 0.0 0.0 4.0 4.0 1.0 0.0
42 42 Community Hospital of San Bernardino 50089 2022-12-23 San Bernardino 71 Southern California 0.0 15.0 6.0 21.0 0.2857142857142857 0.0
43 43 Community Hospital of the Monterey Peninsula 50145 2022-12-23 Monterey 53 Bay Area 0.0 9.0 17.0 26.0 0.6538461538461539 0.0
44 44 Community Memorial Hospital San Buenaventura 50394 2022-12-23 Ventura 111 Southern California 4.0 1.0 16.0 17.0 0.9411764705882352 0.25
45 45 Community Regional Medical Center 50060 2022-12-23 Fresno 19 San Joaquin Valley 11.0 7.0 84.0 91.0 0.9230769230769232 0.1309523809523809
46 46 Contra Costa Regional Medical Center 50276 2022-12-23 Contra Costa 13 Bay Area 0.0 4.0 14.0 18.0 0.7777777777777778 0.0
47 47 Dameron Hospital 50122 2022-12-23 San Joaquin 77 San Joaquin Valley 0.0 0.0 11.0 11.0 1.0 0.0
48 48 Desert Valley Hospital 50709 2022-12-23 San Bernardino 71 Southern California 0.0 0.0 18.0 18.0 1.0 0.0
49 49 Doctors Hospital of Riverside, LLC 50102 2022-12-23 Riverside 65 Southern California 0.0 8.0 4.0 12.0 0.3333333333333333 0.0
50 50 Dominican Hospital 50242 2022-12-23 Santa Cruz 87 Bay Area 0.0 1.0 12.0 13.0 0.9230769230769232 0.0
51 51 East Los Angeles Doctors Hospital 50641 2022-12-23 Los Angeles 37 Southern California 0.0 1.75 5.25 7.0 0.75 0.0
52 52 Eden Medical Center 50488 2022-12-23 Alameda 1 Bay Area 0.0 0.0 24.0 24.0 1.0 0.0
53 53 Eisenhower Medical Center 50573 2022-12-23 Riverside 65 Southern California 0.0 5.0 22.0 27.0 0.8148148148148148 0.0
54 54 El Camino Hospital 50308 2022-12-23 Santa Clara 85 Bay Area 5.0 6.0 26.0 32.0 0.8125 0.1923076923076923
55 55 El Centro Regional Medical Center 50045 2022-12-23 Imperial 25 Southern California 0.0 12.0 0.0 12.0 0.0  
56 56 Emanate Health Foothill Presbyterian Hospital 50597 2022-12-23 Los Angeles 37 Southern California 0.0 3.0 15.0 18.0 0.8333333333333334 0.0
57 57 Emanate Health Inter-community Hospital 50382 2022-12-23 Los Angeles 37 Southern California 6.0 7.0 34.0 41.0 0.8292682926829268 0.1764705882352941
58 58 Encino Hospital Medical Center 50158 2022-12-23 Los Angeles 37 Southern California 0.0 2.0 5.0 7.0 0.7142857142857143 0.0
59 59 Enloe Medical Center 50039 2022-12-23 Butte 7 Greater Sacramento 0.0 8.0 16.0 24.0 0.6666666666666666 0.0
60 60 Foothill Regional Medical Center 50780 2022-12-23 Orange 59 Southern California 0.0 6.0 7.0 13.0 0.5384615384615384 0.0
61 61 French Hospital Medical Center 50232 2022-12-23 San Luis Obispo 79 Southern California 0.0 0.0 7.0 7.0 1.0 0.0
62 62 Garfield Medical Center 50737 2022-12-23 Los Angeles 37 Southern California 0.0 11.0 11.0 22.0 0.5 0.0
63 63 Glendale Adventist Medical Center 50239 2022-12-23 Los Angeles 37 Southern California 0.0 0.0 21.0 21.0 1.0 0.0
64 64 Glendale Mem Hospital & Health Center 50058 2022-12-23 Los Angeles 37 Southern California 0.0 3.0 13.0 16.0 0.8125 0.0
65 65 Good Samaritan Hospital 50380 2022-12-23 Santa Clara 85 Bay Area 4.6 11.0 33.4 44.4 0.7522522522522522 0.1377245508982036
66 66 Greater El Monte Community Hospital 50738 2022-12-23 Los Angeles 37 Southern California 0.0 18.0 6.0 24.0 0.25 0.0
67 67 Grossmont Hospital 50026 2022-12-23 San Diego 73 Southern California 7.0 13.0 62.0 75.0 0.8266666666666667 0.1129032258064516
68 68 Hazel Hawkins Memorial Hospital 51337 2022-12-23 San Benito 69 San Joaquin Valley 0.0 0.0 4.0 4.0 1.0 0.0
69 69 Healdsburg Hospital 51321 2022-12-23 Sonoma 97 Bay Area 0.0 5.0 0.0 5.0 0.0  
70 70 Hemet Global Medical Center 50390 2022-12-23 Riverside 65 Southern California 0.0 12.0 14.0 26.0 0.5384615384615384 0.0
71 71 Henry Mayo Newhall Hospital 50624 2022-12-23 Los Angeles 37 Southern California 0.0 1.0 17.0 18.0 0.9444444444444444 0.0
72 72 Highland Hospital 50320 2022-12-23 Alameda 1 Bay Area 2.0 8.5 24.5 33.0 0.7424242424242424 0.0816326530612244
73 73 Hoag Memorial Hospital Presbyterian 50224 2022-12-23 Orange 59 Southern California 0.0 21.0 27.0 48.0 0.5625 0.0
74 74 Hollywood Presbyterian Medical Center 50063 2022-12-23 Los Angeles 37 Southern California 0.0 8.0 16.0 24.0 0.6666666666666666 0.0
75 75 Huntington Beach Hospital 50526 2022-12-23 Orange 59 Southern California 0.0 1.0 5.0 6.0 0.8333333333333334 0.0
76 76 Huntington Hospital 50438 2022-12-23 Los Angeles 37 Southern California 0.0 6.0 16.0 22.0 0.7272727272727273 0.0
77 77 John Muir Medical Center - Concord Campus 50496 2022-12-23 Contra Costa 13 Bay Area 0.0 8.0 28.0 36.0 0.7777777777777778 0.0
78 78 John Muir Medical Center - Walnut Creek Campus 50180 2022-12-23 Contra Costa 13 Bay Area 0.0 6.0 42.0 48.0 0.875 0.0
79 79 Kaiser Foundation Hosp So Sacramento 50674 2022-12-23 Sacramento 67 Greater Sacramento 8.0 2.0 22.0 24.0 0.9166666666666666 0.3636363636363636
80 80 Kaiser Foundation Hospital - Antioch 50760 2022-12-23 Contra Costa 13 Bay Area 5.0 1.0 8.0 9.0 0.8888888888888888 0.625
81 81 Kaiser Foundation Hospital - Baldwin Park 50723 2022-12-23 Los Angeles 37 Southern California 0.0 4.0 8.0 12.0 0.6666666666666666 0.0
82 82 Kaiser Foundation Hospital - Downey 50139 2022-12-23 Los Angeles 37 Southern California 0.0 10.0 18.0 28.0 0.6428571428571429 0.0
83 83 Kaiser Foundation Hospital - Fremont 50512 2022-12-23 Alameda 1 Bay Area 0.0 0.0 4.0 4.0 1.0 0.0
84 84 Kaiser Foundation Hospital - Fresno 50710 2022-12-23 Fresno 19 San Joaquin Valley 5.0 0.0 14.0 14.0 1.0 0.3571428571428571
85 85 Kaiser Foundation Hospital - Los Angeles 50138 2022-12-23 Los Angeles 37 Southern California 5.0 46.0 43.0 89.0 0.4831460674157303 0.1162790697674418
86 86 Kaiser Foundation Hospital - Oakland/richmond 50075 2022-12-23 Alameda 1 Bay Area 10.0 2.0 20.0 22.0 0.9090909090909092 0.5
87 87 Kaiser Foundation Hospital - Orange County - Anahe 50609 2022-12-23 Orange 59 Southern California 0.0 9.0 32.0 41.0 0.7804878048780488 0.0
88 88 Kaiser Foundation Hospital - Panorama City 50137 2022-12-23 Los Angeles 37 Southern California 0.0 12.0 10.0 22.0 0.4545454545454545 0.0
89 89 Kaiser Foundation Hospital - Redwood City 50541 2022-12-23 San Mateo 81 Bay Area 0.0 1.0 10.0 11.0 0.9090909090909092 0.0
90 90 Kaiser Foundation Hospital - Roseville 50772 2022-12-23 Placer 61 Greater Sacramento 6.0 2.0 17.0 19.0 0.8947368421052632 0.3529411764705882
91 91 Kaiser Foundation Hospital - Sacramento 50425 2022-12-23 Sacramento 67 Greater Sacramento 9.0 2.0 23.0 25.0 0.92 0.391304347826087
92 92 Kaiser Foundation Hospital - San Francisco 50076 2022-12-23 San Francisco 75 Bay Area 0.0 2.0 20.0 22.0 0.9090909090909092 0.0
93 93 Kaiser Foundation Hospital - San Leandro 50777 2022-12-23 Alameda 1 Bay Area 7.0 2.0 15.0 17.0 0.8823529411764706 0.4666666666666667
94 94 Kaiser Foundation Hospital - South Bay 50411 2022-12-23 Los Angeles 37 Southern California 0.0 20.0 0.0 20.0 0.0  
95 95 Kaiser Foundation Hospital - South San Francisco 50070 2022-12-23 San Mateo 81 Bay Area 0.0 1.0 9.0 10.0 0.9 0.0
96 96 Kaiser Foundation Hospital - Vacaville 50767 2022-12-23 Solano 95 Bay Area 0.0 1.0 7.0 8.0 0.875 0.0
97 97 Kaiser Foundation Hospital - Walnut Creek 50072 2022-12-23 Contra Costa 13 Bay Area 4.0 2.0 15.0 17.0 0.8823529411764706 0.2666666666666666
98 98 Kaiser Foundation Hospital - West LA 50561 2022-12-23 Los Angeles 37 Southern California 0.0 17.0 13.0 30.0 0.4333333333333333 0.0
99 99 Kaiser Foundation Hospital - Woodland Hills 50677 2022-12-23 Los Angeles 37 Southern California 0.0 10.0 7.0 17.0 0.4117647058823529 0.0
100 100 Kaiser Foundation Hospital - Zion 50515 2022-12-23 San Diego 73 Southern California 4.0 26.0 16.0 42.0 0.3809523809523809 0.25

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
);
Powered by Datasette · Queries took 784.027ms · Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README