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 occupied_adult_icu_beds_total
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5639 | 5639 | Victor Valley Global Medical Center | 50517 | 2022-08-19 | San Bernardino | 71 | Southern California | 0.0 | 10.0 | 0.0 | 10.0 | 0.0 | |
5715 | 5715 | Encino Hospital Medical Center | 50158 | 2022-08-12 | Los Angeles | 37 | Southern California | 0.0 | 0.5714285714285714 | 0.0 | 0.5714285714285714 | 0.0 | |
5731 | 5731 | Healdsburg Hospital | 51321 | 2022-08-12 | Sonoma | 97 | Bay Area | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
5804 | 5804 | Mammoth Hospital | 51303 | 2022-08-12 | Mono | 51 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
5832 | 5832 | Northern Inyo Hospital | 51324 | 2022-08-12 | Inyo | 27 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
5836 | 5836 | Ojai Valley Community Hospital | 51334 | 2022-08-12 | Ventura | 111 | Southern California | 0.0 | 1.4285714285714286 | 0.0 | 1.4285714285714286 | 0.0 | |
5837 | 5837 | Olympia Medical Center | 50742 | 2022-08-12 | Los Angeles | 37 | Southern California | 0.0 | 12.0 | 0.0 | 12.0 | 0.0 | |
6106 | 6106 | Mammoth Hospital | 51303 | 2022-08-05 | Mono | 51 | Southern California | 0.0 | 1.7142857142857142 | 0.0 | 1.7142857142857142 | 0.0 | |
6137 | 6137 | Oak Valley Hospital District | 50067 | 2022-08-05 | Stanislaus | 99 | San Joaquin Valley | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
6138 | 6138 | Ojai Valley Community Hospital | 51334 | 2022-08-05 | Ventura | 111 | Southern California | 0.0 | 1.5714285714285714 | 0.0 | 1.5714285714285714 | 0.0 | |
6139 | 6139 | Olympia Medical Center | 50742 | 2022-08-05 | Los Angeles | 37 | Southern California | 0.0 | 12.0 | 0.0 | 12.0 | 0.0 | |
6247 | 6247 | Watsonville Community Hospital | 50194 | 2022-08-05 | Santa Cruz | 87 | Bay Area | 0.0 | 6.0 | 0.0 | 6.0 | 0.0 | |
6335 | 6335 | Healdsburg Hospital | 51321 | 2022-07-29 | Sonoma | 97 | Bay Area | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
6408 | 6408 | Mammoth Hospital | 51303 | 2022-07-29 | Mono | 51 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
6414 | 6414 | Memorial Hospital Los Banos | 50528 | 2022-07-29 | Merced | 47 | San Joaquin Valley | 0.0 | 4.0 | 0.0 | 4.0 | 0.0 | |
6436 | 6436 | Northern Inyo Hospital | 51324 | 2022-07-29 | Inyo | 27 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
6547 | 6547 | Watsonville Community Hospital | 50194 | 2022-07-29 | Santa Cruz | 87 | Bay Area | 0.0 | 6.0 | 0.0 | 6.0 | 0.0 | |
6634 | 6634 | Healdsburg Hospital | 51321 | 2022-07-22 | Sonoma | 97 | Bay Area | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
6707 | 6707 | Mammoth Hospital | 51303 | 2022-07-22 | Mono | 51 | Southern California | 0.0 | 1.7142857142857142 | 0.0 | 1.7142857142857142 | 0.0 | |
6713 | 6713 | Memorial Hospital Los Banos | 50528 | 2022-07-22 | Merced | 47 | San Joaquin Valley | 0.0 | 4.0 | 0.0 | 4.0 | 0.0 | |
6735 | 6735 | Northern Inyo Hospital | 51324 | 2022-07-22 | Inyo | 27 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
6739 | 6739 | Ojai Valley Community Hospital | 51334 | 2022-07-22 | Ventura | 111 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
6846 | 6846 | Watsonville Community Hospital | 50194 | 2022-07-22 | Santa Cruz | 87 | Bay Area | 0.0 | 6.0 | 0.0 | 6.0 | 0.0 | |
6933 | 6933 | Healdsburg Hospital | 51321 | 2022-07-15 | Sonoma | 97 | Bay Area | 0.0 | 4.285714285714286 | 0.0 | 4.285714285714286 | 0.0 | |
7006 | 7006 | Mammoth Hospital | 51303 | 2022-07-15 | Mono | 51 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
7034 | 7034 | Northern Inyo Hospital | 51324 | 2022-07-15 | Inyo | 27 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
7037 | 7037 | Oak Valley Hospital District | 50067 | 2022-07-15 | Stanislaus | 99 | San Joaquin Valley | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
7060 | 7060 | Providence Redwood Memorial Hospital | 51318 | 2022-07-15 | Humboldt | 23 | Northern California | 0.0 | 4.0 | 0.0 | 4.0 | 0.0 | |
7145 | 7145 | Watsonville Community Hospital | 50194 | 2022-07-15 | Santa Cruz | 87 | Bay Area | 0.0 | 6.0 | 0.0 | 6.0 | 0.0 | |
7178 | 7178 | Barlow Respiratory Hospital | 52031 | 2022-07-08 | Los Angeles | 37 | Southern California | 0.0 | 6.0 | 0.0 | 6.0 | 0.0 | |
7219 | 7219 | Encino Hospital Medical Center | 50158 | 2022-07-08 | Los Angeles | 37 | Southern California | 0.0 | 2.857142857142857 | 0.0 | 2.857142857142857 | 0.0 | |
7235 | 7235 | Healdsburg Hospital | 51321 | 2022-07-08 | Sonoma | 97 | Bay Area | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
7308 | 7308 | Mammoth Hospital | 51303 | 2022-07-08 | Mono | 51 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
7325 | 7325 | Mercy Medical Center Mt Shasta | 51319 | 2022-07-08 | Siskiyou | 93 | Northern California | 0.0 | 4.0 | 0.0 | 4.0 | 0.0 | |
7336 | 7336 | Northern Inyo Hospital | 51324 | 2022-07-08 | Inyo | 27 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
7448 | 7448 | Watsonville Community Hospital | 50194 | 2022-07-08 | Santa Cruz | 87 | Bay Area | 0.0 | 6.0 | 0.0 | 6.0 | 0.0 | |
7521 | 7521 | Encino Hospital Medical Center | 50158 | 2022-07-01 | Los Angeles | 37 | Southern California | 0.0 | 4.0 | 0.0 | 4.0 | 0.0 | |
7536 | 7536 | Healdsburg Hospital | 51321 | 2022-07-01 | Sonoma | 97 | Bay Area | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
7608 | 7608 | Mammoth Hospital | 51303 | 2022-07-01 | Mono | 51 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
7624 | 7624 | Mercy Medical Center Mt Shasta | 51319 | 2022-07-01 | Siskiyou | 93 | Northern California | 0.0 | 4.0 | 0.0 | 4.0 | 0.0 | |
7635 | 7635 | Northern Inyo Hospital | 51324 | 2022-07-01 | Inyo | 27 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
7638 | 7638 | Oak Valley Hospital District | 50067 | 2022-07-01 | Stanislaus | 99 | San Joaquin Valley | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
7746 | 7746 | Watsonville Community Hospital | 50194 | 2022-07-01 | Santa Cruz | 87 | Bay Area | 0.0 | 6.0 | 0.0 | 6.0 | 0.0 | |
7779 | 7779 | Barlow Respiratory Hospital | 52031 | 2022-06-24 | Los Angeles | 37 | Southern California | 0.0 | 6.0 | 0.0 | 6.0 | 0.0 | |
7901 | 7901 | Lompoc Valley Medical Center | 50110 | 2022-06-24 | Santa Barbara | 83 | Southern California | 0.0 | 6.0 | 0.0 | 6.0 | 0.0 | |
7906 | 7906 | Mammoth Hospital | 51303 | 2022-06-24 | Mono | 51 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
7933 | 7933 | Northern Inyo Hospital | 51324 | 2022-06-24 | Inyo | 27 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
8044 | 8044 | Watsonville Community Hospital | 50194 | 2022-06-24 | Santa Cruz | 87 | Bay Area | 0.0 | 6.0 | 0.0 | 6.0 | 0.0 | |
8077 | 8077 | Barlow Respiratory Hospital | 52031 | 2022-06-17 | Los Angeles | 37 | Southern California | 0.0 | 6.0 | 0.0 | 6.0 | 0.0 | |
8133 | 8133 | Healdsburg Hospital | 51321 | 2022-06-17 | Sonoma | 97 | Bay Area | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
8201 | 8201 | Lompoc Valley Medical Center | 50110 | 2022-06-17 | Santa Barbara | 83 | Southern California | 0.0 | 6.0 | 0.0 | 6.0 | 0.0 | |
8218 | 8218 | Menifee Global Medical Center | 50684 | 2022-06-17 | Riverside | 65 | Southern California | 0.0 | 10.0 | 0.0 | 10.0 | 0.0 | |
8223 | 8223 | Mercy Medical Center Mt Shasta | 51319 | 2022-06-17 | Siskiyou | 93 | Northern California | 0.0 | 4.0 | 0.0 | 4.0 | 0.0 | |
8234 | 8234 | Northern Inyo Hospital | 51324 | 2022-06-17 | Inyo | 27 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
8238 | 8238 | Ojai Valley Community Hospital | 51334 | 2022-06-17 | Ventura | 111 | Southern California | 0.0 | 2.333333333333333 | 0.0 | 2.333333333333333 | 0.0 | |
8346 | 8346 | Watsonville Community Hospital | 50194 | 2022-06-17 | Santa Cruz | 87 | Bay Area | 0.0 | 6.0 | 0.0 | 6.0 | 0.0 | |
8379 | 8379 | Barlow Respiratory Hospital | 52031 | 2022-06-10 | Los Angeles | 37 | Southern California | 0.0 | 6.0 | 0.0 | 6.0 | 0.0 | |
8435 | 8435 | Healdsburg Hospital | 51321 | 2022-06-10 | Sonoma | 97 | Bay Area | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
8508 | 8508 | Mammoth Hospital | 51303 | 2022-06-10 | Mono | 51 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
8647 | 8647 | Watsonville Community Hospital | 50194 | 2022-06-10 | Santa Cruz | 87 | Bay Area | 0.0 | 6.0 | 0.0 | 6.0 | 0.0 | |
8735 | 8735 | Healdsburg Hospital | 51321 | 2022-06-03 | Sonoma | 97 | Bay Area | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
8808 | 8808 | Mammoth Hospital | 51303 | 2022-06-03 | Mono | 51 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
8836 | 8836 | Northern Inyo Hospital | 51324 | 2022-06-03 | Inyo | 27 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
8948 | 8948 | Watsonville Community Hospital | 50194 | 2022-06-03 | Santa Cruz | 87 | Bay Area | 0.0 | 6.0 | 0.0 | 6.0 | 0.0 | |
9036 | 9036 | Healdsburg Hospital | 51321 | 2022-05-27 | Sonoma | 97 | Bay Area | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
9109 | 9109 | Mammoth Hospital | 51303 | 2022-05-27 | Mono | 51 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
9137 | 9137 | Northern Inyo Hospital | 51324 | 2022-05-27 | Inyo | 27 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
9249 | 9249 | Watsonville Community Hospital | 50194 | 2022-05-27 | Santa Cruz | 87 | Bay Area | 0.0 | 6.0 | 0.0 | 6.0 | 0.0 | |
9336 | 9336 | Healdsburg Hospital | 51321 | 2022-05-20 | Sonoma | 97 | Bay Area | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
9409 | 9409 | Mammoth Hospital | 51303 | 2022-05-20 | Mono | 51 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
9415 | 9415 | Memorial Hospital Los Banos | 50528 | 2022-05-20 | Merced | 47 | San Joaquin Valley | 0.0 | 4.0 | 0.0 | 4.0 | 0.0 | |
9437 | 9437 | Northern Inyo Hospital | 51324 | 2022-05-20 | Inyo | 27 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
9548 | 9548 | Watsonville Community Hospital | 50194 | 2022-05-20 | Santa Cruz | 87 | Bay Area | 0.0 | 6.0 | 0.0 | 6.0 | 0.0 | |
9636 | 9636 | Healdsburg Hospital | 51321 | 2022-05-13 | Sonoma | 97 | Bay Area | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
9709 | 9709 | Mammoth Hospital | 51303 | 2022-05-13 | Mono | 51 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
9737 | 9737 | Northern Inyo Hospital | 51324 | 2022-05-13 | Inyo | 27 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
10010 | 10010 | Mammoth Hospital | 51303 | 2022-05-06 | Mono | 51 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
10016 | 10016 | Memorial Hospital Los Banos | 50528 | 2022-05-06 | Merced | 47 | San Joaquin Valley | 0.0 | 4.0 | 0.0 | 4.0 | 0.0 | |
10150 | 10150 | Watsonville Community Hospital | 50194 | 2022-05-06 | Santa Cruz | 87 | Bay Area | 0.0 | 6.0 | 0.0 | 6.0 | 0.0 | |
10183 | 10183 | Barlow Respiratory Hospital | 52031 | 2022-04-29 | Los Angeles | 37 | Southern California | 0.0 | 6.0 | 0.0 | 6.0 | 0.0 | |
10223 | 10223 | Encino Hospital Medical Center | 50158 | 2022-04-29 | Los Angeles | 37 | Southern California | 0.0 | 2.2857142857142856 | 0.0 | 2.2857142857142856 | 0.0 | |
10238 | 10238 | Healdsburg Hospital | 51321 | 2022-04-29 | Sonoma | 97 | Bay Area | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
10311 | 10311 | Mammoth Hospital | 51303 | 2022-04-29 | Mono | 51 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
10450 | 10450 | Watsonville Community Hospital | 50194 | 2022-04-29 | Santa Cruz | 87 | Bay Area | 0.0 | 6.0 | 0.0 | 6.0 | 0.0 | |
10483 | 10483 | Barlow Respiratory Hospital | 52031 | 2022-04-22 | Los Angeles | 37 | Southern California | 0.0 | 6.0 | 0.0 | 6.0 | 0.0 | |
10523 | 10523 | Encino Hospital Medical Center | 50158 | 2022-04-22 | Los Angeles | 37 | Southern California | 0.0 | 1.1428571428571428 | 0.0 | 1.1428571428571428 | 0.0 | |
10538 | 10538 | Healdsburg Hospital | 51321 | 2022-04-22 | Sonoma | 97 | Bay Area | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
10612 | 10612 | Mammoth Hospital | 51303 | 2022-04-22 | Mono | 51 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
10751 | 10751 | Watsonville Community Hospital | 50194 | 2022-04-22 | Santa Cruz | 87 | Bay Area | 0.0 | 6.0 | 0.0 | 6.0 | 0.0 | |
10839 | 10839 | Healdsburg Hospital | 51321 | 2022-04-15 | Sonoma | 97 | Bay Area | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
10913 | 10913 | Mammoth Hospital | 51303 | 2022-04-15 | Mono | 51 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
10941 | 10941 | Northern Inyo Hospital | 51324 | 2022-04-15 | Inyo | 27 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
11052 | 11052 | Watsonville Community Hospital | 50194 | 2022-04-15 | Santa Cruz | 87 | Bay Area | 0.0 | 6.0 | 0.0 | 6.0 | 0.0 | |
11140 | 11140 | Healdsburg Hospital | 51321 | 2022-04-08 | Sonoma | 97 | Bay Area | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
11213 | 11213 | Mammoth Hospital | 51303 | 2022-04-08 | Mono | 51 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
11216 | 11216 | Mark Twain Medical Center | 51332 | 2022-04-08 | Calaveras | 9 | San Joaquin Valley | 0.0 | 8.0 | 0.0 | 8.0 | 0.0 | |
11241 | 11241 | Northern Inyo Hospital | 51324 | 2022-04-08 | Inyo | 27 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
11245 | 11245 | Ojai Valley Community Hospital | 51334 | 2022-04-08 | Ventura | 111 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
11354 | 11354 | Watsonville Community Hospital | 50194 | 2022-04-08 | Santa Cruz | 87 | Bay Area | 0.0 | 6.0 | 0.0 | 6.0 | 0.0 | |
11516 | 11516 | Mammoth Hospital | 51303 | 2022-04-01 | Mono | 51 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 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 );