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 staffed_adult_icu_beds_total
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
341 | 341 | Goleta Valley Cottage Hospital | 50357 | 2022-12-16 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.5714285714285714 | 0.5714285714285714 | 1.0 | 0.0 |
748 | 748 | Ojai Valley Community Hospital | 51334 | 2022-12-09 | Ventura | 111 | Southern California | 0.0 | 0.5714285714285714 | 0.0 | 0.5714285714285714 | 0.0 | |
1238 | 1238 | Goleta Valley Cottage Hospital | 50357 | 2022-11-25 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.5714285714285714 | 0.5714285714285714 | 1.0 | 0.0 |
1767 | 1767 | Adventist Health Tehachapi Valley | 51301 | 2022-11-11 | Kern | 29 | San Joaquin Valley | 0.0 | 0.0 | 0.5714285714285714 | 0.5714285714285714 | 1.0 | 0.0 |
3023 | 3023 | Encino Hospital Medical Center | 50158 | 2022-10-14 | Los Angeles | 37 | Southern California | 0.0 | 0.5714285714285714 | 0.0 | 0.5714285714285714 | 0.0 | |
3333 | 3333 | Goleta Valley Cottage Hospital | 50357 | 2022-10-07 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.5714285714285714 | 0.5714285714285714 | 1.0 | 0.0 |
3635 | 3635 | Goleta Valley Cottage Hospital | 50357 | 2022-09-30 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.5714285714285714 | 0.5714285714285714 | 1.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 | |
6241 | 6241 | Valley Children's Hospital | 53300 | 2022-08-05 | Fresno | 19 | San Joaquin Valley | 0.0 | 0.0 | 0.5714285714285714 | 0.5714285714285714 | 1.0 | 0.0 |
9426 | 9426 | Mercy Medical Center Mt Shasta | 51319 | 2022-05-20 | Siskiyou | 93 | Northern California | 0.0 | -0.1428571428571429 | 0.7142857142857143 | 0.5714285714285714 | 1.25 | 0.0 |
10768 | 10768 | Adventist Health Tehachapi Valley | 51301 | 2022-04-15 | Kern | 29 | San Joaquin Valley | 0.0 | 0.0 | 0.5714285714285714 | 0.5714285714285714 | 1.0 | 0.0 |
11437 | 11437 | Goleta Valley Cottage Hospital | 50357 | 2022-04-01 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.5714285714285714 | 0.5714285714285714 | 1.0 | 0.0 |
12338 | 12338 | Encino Hospital Medical Center | 50158 | 2022-03-11 | Los Angeles | 37 | Southern California | 0.0 | 0.5714285714285714 | 0.0 | 0.5714285714285714 | 0.0 | |
14176 | 14176 | Goleta Valley Cottage Hospital | 50357 | 2022-01-28 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.5714285714285714 | 0.5714285714285714 | 1.0 | 0.0 |
16111 | 16111 | Ojai Valley Community Hospital | 51334 | 2021-12-17 | Ventura | 111 | Southern California | 0.0 | 0.5714285714285714 | 0.0 | 0.5714285714285714 | 0.0 | |
16305 | 16305 | Goleta Valley Cottage Hospital | 50357 | 2021-12-10 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.5714285714285714 | 0.5714285714285714 | 1.0 | 0.0 |
23019 | 23019 | Encino Hospital Medical Center | 50158 | 2021-07-09 | Los Angeles | 37 | Southern California | 0.0 | 0.5714285714285714 | 0.0 | 0.5714285714285714 | 0.0 | |
23141 | 23141 | Ojai Valley Community Hospital | 51334 | 2021-07-09 | Ventura | 111 | Southern California | 0.0 | 0.0 | 0.5714285714285714 | 0.5714285714285714 | 1.0 | 0.0 |
23949 | 23949 | Goleta Valley Cottage Hospital | 50357 | 2021-06-18 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.5714285714285714 | 0.5714285714285714 | 1.0 | 0.0 |
24561 | 24561 | Goleta Valley Cottage Hospital | 50357 | 2021-06-04 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.5714285714285714 | 0.5714285714285714 | 1.0 | 0.0 |
25285 | 25285 | Ojai Valley Community Hospital | 51334 | 2021-05-21 | Ventura | 111 | Southern California | 0.0 | 0.5714285714285714 | 0.0 | 0.5714285714285714 | 0.0 | |
25469 | 25469 | Encino Hospital Medical Center | 50158 | 2021-05-14 | Los Angeles | 37 | Southern California | 0.0 | 0.5714285714285714 | 0.0 | 0.5714285714285714 | 0.0 | |
25774 | 25774 | Encino Hospital Medical Center | 50158 | 2021-05-07 | Los Angeles | 37 | Southern California | 0.0 | 0.5714285714285714 | 0.0 | 0.5714285714285714 | 0.0 | |
27006 | 27006 | Goleta Valley Cottage Hospital | 50357 | 2021-04-09 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.5714285714285714 | 0.5714285714285714 | 1.0 | 0.0 |
30061 | 30061 | Goleta Valley Cottage Hospital | 50357 | 2021-01-29 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.5714285714285714 | 0.5714285714285714 | 1.0 | 0.0 |
30368 | 30368 | Goleta Valley Cottage Hospital | 50357 | 2021-01-22 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.5714285714285714 | 0.5714285714285714 | 1.0 | 0.0 |
30979 | 30979 | Goleta Valley Cottage Hospital | 50357 | 2021-01-08 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.5714285714285714 | 0.5714285714285714 | 1.0 | 0.0 |
31285 | 31285 | Goleta Valley Cottage Hospital | 50357 | 2021-01-01 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.5714285714285714 | 0.5714285714285714 | 1.0 | 0.0 |
32321 | 32321 | Ojai Valley Community Hospital | 51334 | 2020-12-11 | Ventura | 111 | Southern California | 0.0 | 0.5714285714285714 | 0.0 | 0.5714285714285714 | 0.0 | |
32935 | 32935 | Ojai Valley Community Hospital | 51334 | 2020-11-27 | Ventura | 111 | Southern California | 0.0 | 0.0 | 0.5714285714285714 | 0.5714285714285714 | 1.0 | 0.0 |
37055 | 37055 | Children's Hospital of Orange County | 53304 | 2020-08-21 | Orange | 59 | Southern California | 0.0 | 0.0 | 0.5714285714285714 | 0.5714285714285714 | 1.0 | 0.0 |
38412 | 38412 | Mayers Memorial Hospital | 51305 | 2020-07-24 | Shasta | 89 | Northern California | 0.0 | 0.0 | 0.5714285714285714 | 0.5714285714285714 | 1.0 | 0.0 |
38508 | 38508 | Shriners Hospitals For Children Northern Calif | 53311 | 2020-07-24 | Sacramento | 67 | Greater Sacramento | 0.0 | 0.5714285714285714 | 0.0 | 0.5714285714285714 | 0.0 | |
1835 | 1835 | Goleta Valley Cottage Hospital | 50357 | 2022-11-11 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.7142857142857143 | 0.7142857142857143 | 1.0 | 0.0 |
4446 | 4446 | Valley Children's Hospital | 53300 | 2022-09-16 | Fresno | 19 | San Joaquin Valley | 0.0 | 0.0 | 0.7142857142857143 | 0.7142857142857143 | 1.0 | 0.0 |
8942 | 8942 | Valley Children's Hospital | 53300 | 2022-06-03 | Fresno | 19 | San Joaquin Valley | 0.0 | 0.0 | 0.7142857142857143 | 0.7142857142857143 | 1.0 | 0.0 |
9631 | 9631 | Goleta Valley Cottage Hospital | 50357 | 2022-05-13 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.7142857142857143 | 0.7142857142857143 | 1.0 | 0.0 |
9843 | 9843 | Valley Children's Hospital | 53300 | 2022-05-13 | Fresno | 19 | San Joaquin Valley | 0.0 | 0.0 | 0.7142857142857143 | 0.7142857142857143 | 1.0 | 0.0 |
10144 | 10144 | Valley Children's Hospital | 53300 | 2022-05-06 | Fresno | 19 | San Joaquin Valley | 0.0 | 0.0 | 0.7142857142857143 | 0.7142857142857143 | 1.0 | 0.0 |
11069 | 11069 | Adventist Health Tehachapi Valley | 51301 | 2022-04-08 | Kern | 29 | San Joaquin Valley | 0.0 | 0.0 | 0.7142857142857143 | 0.7142857142857143 | 1.0 | 0.0 |
12349 | 12349 | Goleta Valley Cottage Hospital | 50357 | 2022-03-11 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.7142857142857143 | 0.7142857142857143 | 1.0 | 0.0 |
13780 | 13780 | Valley Children's Hospital | 53300 | 2022-02-11 | Fresno | 19 | San Joaquin Valley | 0.0 | 0.0 | 0.7142857142857143 | 0.7142857142857143 | 1.0 | 0.0 |
14784 | 14784 | Goleta Valley Cottage Hospital | 50357 | 2022-01-14 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.7142857142857143 | 0.7142857142857143 | 1.0 | 0.0 |
19356 | 19356 | Goleta Valley Cottage Hospital | 50357 | 2021-10-01 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.7142857142857143 | 0.7142857142857143 | 1.0 | 0.0 |
20550 | 20550 | Colusa Medical Center | 50783 | 2021-09-03 | Colusa | 11 | Greater Sacramento | 0.0 | 0.7142857142857143 | 0.0 | 0.7142857142857143 | 0.0 | |
27922 | 27922 | Goleta Valley Cottage Hospital | 50357 | 2021-03-19 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.7142857142857143 | 0.7142857142857143 | 1.0 | 0.0 |
31594 | 31594 | Goleta Valley Cottage Hospital | 50357 | 2020-12-25 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.7142857142857143 | 0.7142857142857143 | 1.0 | 0.0 |
32483 | 32483 | Colusa Medical Center | 50783 | 2020-12-04 | Colusa | 11 | Greater Sacramento | 0.0 | 0.7142857142857143 | 0.0 | 0.7142857142857143 | 0.0 | |
802 | 802 | Select Specialty Hospital - San Diego | 52044 | 2022-12-09 | San Diego | 73 | Southern California | 0.0 | 0.0 | 0.8571428571428571 | 0.8571428571428571 | 1.0 | 0.0 |
2958 | 2958 | Adventist Health Delano | 50608 | 2022-10-14 | Kern | 29 | San Joaquin Valley | 0.0 | 0.0 | 0.8571428571428571 | 0.8571428571428571 | 1.0 | 0.0 |
5961 | 5961 | Adventist Health Tehachapi Valley | 51301 | 2022-08-05 | Kern | 29 | San Joaquin Valley | 0.0 | 0.0 | 0.8571428571428571 | 0.8571428571428571 | 1.0 | 0.0 |
7230 | 7230 | Goleta Valley Cottage Hospital | 50357 | 2022-07-08 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.8571428571428571 | 0.8571428571428571 | 1.0 | 0.0 |
8664 | 8664 | Adventist Health Tehachapi Valley | 51301 | 2022-06-03 | Kern | 29 | San Joaquin Valley | 0.0 | 0.0 | 0.8571428571428571 | 0.8571428571428571 | 1.0 | 0.0 |
11299 | 11299 | Select Specialty Hospital - San Diego | 52044 | 2022-04-08 | San Diego | 73 | Southern California | 0.0 | 0.0 | 0.8571428571428571 | 0.8571428571428571 | 1.0 | 0.0 |
11602 | 11602 | Select Specialty Hospital - San Diego | 52044 | 2022-04-01 | San Diego | 73 | Southern California | 0.0 | 0.0 | 0.8571428571428571 | 0.8571428571428571 | 1.0 | 0.0 |
11651 | 11651 | Valley Children's Hospital | 53300 | 2022-04-01 | Fresno | 19 | San Joaquin Valley | 0.0 | 0.0 | 0.8571428571428571 | 0.8571428571428571 | 1.0 | 0.0 |
12209 | 12209 | Select Specialty Hospital - San Diego | 52044 | 2022-03-18 | San Diego | 73 | Southern California | 0.0 | 0.0 | 0.8571428571428571 | 0.8571428571428571 | 1.0 | 0.0 |
12818 | 12818 | Select Specialty Hospital - San Diego | 52044 | 2022-03-04 | San Diego | 73 | Southern California | 0.0 | 0.0 | 0.8571428571428571 | 0.8571428571428571 | 1.0 | 0.0 |
13121 | 13121 | Select Specialty Hospital - San Diego | 52044 | 2022-02-25 | San Diego | 73 | Southern California | 0.0 | 0.2857142857142857 | 0.5714285714285714 | 0.8571428571428571 | 0.6666666666666666 | 0.0 |
13170 | 13170 | Valley Children's Hospital | 53300 | 2022-02-25 | Fresno | 19 | San Joaquin Valley | 0.0 | 0.0 | 0.8571428571428571 | 0.8571428571428571 | 1.0 | 0.0 |
13426 | 13426 | Select Specialty Hospital - San Diego | 52044 | 2022-02-18 | San Diego | 73 | Southern California | 0.0 | 0.2857142857142857 | 0.5714285714285714 | 0.8571428571428571 | 0.6666666666666666 | 0.0 |
14036 | 14036 | Select Specialty Hospital - San Diego | 52044 | 2022-02-04 | San Diego | 73 | Southern California | 0.0 | 0.0 | 0.8571428571428571 | 0.8571428571428571 | 1.0 | 0.0 |
15559 | 15559 | Select Specialty Hospital - San Diego | 52044 | 2021-12-31 | San Diego | 73 | Southern California | 0.0 | 0.0 | 0.8571428571428571 | 0.8571428571428571 | 1.0 | 0.0 |
16916 | 16916 | 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 |
17757 | 17757 | Adventist Health Mendocino Coast | 51325 | 2021-11-05 | Mendocino | 45 | Northern California | 0.0 | 0.8571428571428571 | 0.0 | 0.8571428571428571 | 0.0 | |
19216 | 19216 | Select Specialty Hospital - San Diego | 52044 | 2021-10-08 | San Diego | 73 | Southern California | 0.0 | 0.0 | 0.8571428571428571 | 0.8571428571428571 | 1.0 | 0.0 |
20136 | 20136 | Select Specialty Hospital - San Diego | 52044 | 2021-09-17 | San Diego | 73 | Southern California | 0.0 | 0.2857142857142857 | 0.5714285714285714 | 0.8571428571428571 | 0.6666666666666666 | 0.0 |
20443 | 20443 | Select Specialty Hospital - San Diego | 52044 | 2021-09-10 | San Diego | 73 | Southern California | 0.0 | 0.2857142857142857 | 0.5714285714285714 | 0.8571428571428571 | 0.6666666666666666 | 0.0 |
20533 | 20533 | Barton Memorial Hospital | 50352 | 2021-09-03 | El Dorado | 17 | Greater Sacramento | 0.0 | 0.1428571428571428 | 0.7142857142857143 | 0.8571428571428571 | 0.8333333333333334 | 0.0 |
20749 | 20749 | Select Specialty Hospital - San Diego | 52044 | 2021-09-03 | San Diego | 73 | Southern California | 0.0 | 0.2857142857142857 | 0.5714285714285714 | 0.8571428571428571 | 0.6666666666666666 | 0.0 |
21055 | 21055 | Select Specialty Hospital - San Diego | 52044 | 2021-08-27 | San Diego | 73 | Southern California | 0.0 | 0.0 | 0.8571428571428571 | 0.8571428571428571 | 1.0 | 0.0 |
22278 | 22278 | Select Specialty Hospital - San Diego | 52044 | 2021-07-30 | San Diego | 73 | Southern California | 0.0 | 0.2857142857142857 | 0.5714285714285714 | 0.8571428571428571 | 0.6666666666666666 | 0.0 |
22889 | 22889 | Select Specialty Hospital - San Diego | 52044 | 2021-07-16 | San Diego | 73 | Southern California | 0.0 | 0.2857142857142857 | 0.5714285714285714 | 0.8571428571428571 | 0.6666666666666666 | 0.0 |
23642 | 23642 | Goleta Valley Cottage Hospital | 50357 | 2021-06-25 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.8571428571428571 | 0.8571428571428571 | 1.0 | 0.0 |
24115 | 24115 | Select Specialty Hospital - San Diego | 52044 | 2021-06-18 | San Diego | 73 | Southern California | 0.0 | 0.2857142857142857 | 0.5714285714285714 | 0.8571428571428571 | 0.6666666666666666 | 0.0 |
25032 | 25032 | Select Specialty Hospital - San Diego | 52044 | 2021-05-28 | San Diego | 73 | Southern California | 2.571428571428572 | 0.0 | 0.8571428571428571 | 0.8571428571428571 | 1.0 | 3.0000000000000004 |
26086 | 26086 | Goleta Valley Cottage Hospital | 50357 | 2021-04-30 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.8571428571428571 | 0.8571428571428571 | 1.0 | 0.0 |
26253 | 26253 | Select Specialty Hospital - San Diego | 52044 | 2021-04-30 | San Diego | 73 | Southern California | 2.571428571428572 | 0.8571428571428571 | 0.0 | 0.8571428571428571 | 0.0 | inf |
29615 | 29615 | Select Specialty Hospital - San Diego | 52044 | 2021-02-12 | San Diego | 73 | Southern California | 0.0 | 0.0 | 0.8571428571428571 | 0.8571428571428571 | 1.0 | 0.0 |
31357 | 31357 | Loma Linda University Children's Hospital | 50778 | 2021-01-01 | San Bernardino | 71 | Southern California | 0.8571428571428571 | 0.0 | 0.8571428571428571 | 0.8571428571428571 | 1.0 | 1.0 |
32684 | 32684 | Select Specialty Hospital - San Diego | 52044 | 2020-12-04 | San Diego | 73 | Southern California | 0.0 | 0.2857142857142857 | 0.5714285714285714 | 0.8571428571428571 | 0.6666666666666666 | 0.0 |
33240 | 33240 | Ojai Valley Community Hospital | 51334 | 2020-11-20 | Ventura | 111 | Southern California | 0.0 | 0.8571428571428571 | 0.0 | 0.8571428571428571 | 0.0 | |
34824 | 34824 | Select Specialty Hospital - San Diego | 52044 | 2020-10-16 | San Diego | 73 | Southern California | 0.0 | 0.2857142857142857 | 0.5714285714285714 | 0.8571428571428571 | 0.6666666666666666 | 0.0 |
35740 | 35740 | Select Specialty Hospital - San Diego | 52044 | 2020-09-25 | San Diego | 73 | Southern California | 0.0 | 0.0 | 0.8571428571428571 | 0.8571428571428571 | 1.0 | 0.0 |
37263 | 37263 | Select Specialty Hospital - San Diego | 52044 | 2020-08-21 | San Diego | 73 | Southern California | 0.0 | 0.2857142857142857 | 0.5714285714285714 | 0.8571428571428571 | 0.6666666666666666 | 0.0 |
4743 | 4743 | Valley Children's Hospital | 53300 | 2022-09-09 | Fresno | 19 | San Joaquin Valley | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 | 0.0 |
4764 | 4764 | Adventist Health Tehachapi Valley | 51301 | 2022-09-02 | Kern | 29 | San Joaquin Valley | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 | 0.0 |
5658 | 5658 | Adventist Health Tehachapi Valley | 51301 | 2022-08-12 | Kern | 29 | San Joaquin Valley | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 | 0.0 |
12258 | 12258 | Valley Children's Hospital | 53300 | 2022-03-18 | Fresno | 19 | San Joaquin Valley | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 | 0.0 |
13475 | 13475 | Valley Children's Hospital | 53300 | 2022-02-18 | Fresno | 19 | San Joaquin Valley | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 | 0.0 |
14390 | 14390 | Valley Children's Hospital | 53300 | 2022-01-28 | Fresno | 19 | San Joaquin Valley | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 | 0.0 |
18133 | 18133 | Goleta Valley Cottage Hospital | 50357 | 2021-10-29 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 | 0.0 |
22112 | 22112 | Goleta Valley Cottage Hospital | 50357 | 2021-07-30 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 | 0.0 |
23030 | 23030 | Goleta Valley Cottage Hospital | 50357 | 2021-07-09 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 | 0.0 |
24867 | 24867 | Goleta Valley Cottage Hospital | 50357 | 2021-05-28 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 | 0.0 |
24937 | 24937 | La Palma Intercommunity Hospital | 50580 | 2021-05-28 | Orange | 59 | Southern California | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 | 0.0 |
25081 | 25081 | Valley Children's Hospital | 53300 | 2021-05-28 | Fresno | 19 | San Joaquin Valley | 0.0 | 0.0 | 1.0 | 1.0 | 1.0 | 0.0 |
550 | 550 | Valley Children's Hospital | 53300 | 2022-12-16 | Fresno | 19 | San Joaquin Valley | 0.0 | 0.0 | 1.1428571428571428 | 1.1428571428571428 | 1.0 | 0.0 |
2059 | 2059 | Adventist Health Delano | 50608 | 2022-11-04 | Kern | 29 | San Joaquin Valley | 0.0 | 0.0 | 1.1428571428571428 | 1.1428571428571428 | 1.0 | 0.0 |
2067 | 2067 | Adventist Health Tehachapi Valley | 51301 | 2022-11-04 | Kern | 29 | San Joaquin Valley | 0.0 | 0.0 | 1.1428571428571428 | 1.1428571428571428 | 1.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 );