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.
307 rows where "week" is on date 2021-07-09 sorted by covid_icu_patients_total
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22951 | 22951 | Adventist Health Bakersfield | 50455 | 2021-07-09 | Kern | 29 | San Joaquin Valley | 0.0 | 9.285714285714285 | 24.714285714285715 | 34.0 | 0.7268907563025211 | 0.0 |
22953 | 22953 | Adventist Health Delano | 50608 | 2021-07-09 | Kern | 29 | San Joaquin Valley | 0.0 | 0.4285714285714286 | 1.4285714285714286 | 1.8571428571428568 | 0.7692307692307693 | 0.0 |
22954 | 22954 | Adventist Health Hanford | 50121 | 2021-07-09 | Kings | 31 | San Joaquin Valley | 0.0 | 3.428571428571429 | 10.714285714285714 | 14.142857142857142 | 0.7575757575757576 | 0.0 |
22957 | 22957 | Adventist Health Mendocino Coast | 51325 | 2021-07-09 | Mendocino | 45 | Northern California | 0.0 | 3.0 | 1.0 | 4.0 | 0.25 | 0.0 |
22958 | 22958 | Adventist Health Simi Valley | 50236 | 2021-07-09 | Ventura | 111 | Southern California | 0.0 | 16.57142857142857 | 7.428571428571429 | 24.0 | 0.3095238095238095 | 0.0 |
22960 | 22960 | Adventist Health St. Helena | 50013 | 2021-07-09 | Napa | 55 | Bay Area | 0.0 | 0.7142857142857135 | 8.0 | 8.714285714285714 | 0.918032786885246 | 0.0 |
22961 | 22961 | Adventist Health Tehachapi Valley | 51301 | 2021-07-09 | Kern | 29 | San Joaquin Valley | 0.0 | 8.0 | 0.0 | 8.0 | 0.0 | |
22962 | 22962 | Adventist Health Tulare | 50784 | 2021-07-09 | Tulare | 107 | San Joaquin Valley | 0.0 | 1.7142857142857144 | 2.2857142857142856 | 4.0 | 0.5714285714285714 | 0.0 |
22965 | 22965 | Ahmc Anaheim Regional Medical Center | 50226 | 2021-07-09 | Orange | 59 | Southern California | 0.0 | 0.571428571428573 | 9.714285714285714 | 10.285714285714286 | 0.9444444444444444 | 0.0 |
22966 | 22966 | Ahmc Seton Medical Center | 50289 | 2021-07-09 | San Mateo | 81 | Bay Area | 0.0 | 1.1428571428571432 | 5.857142857142857 | 7.0 | 0.836734693877551 | 0.0 |
22967 | 22967 | Alameda Hospital | 50211 | 2021-07-09 | Alameda | 1 | Bay Area | 0.0 | 4.571428571428571 | 3.4285714285714284 | 8.0 | 0.4285714285714285 | 0.0 |
22971 | 22971 | Alvarado Hospital Medical Center | 50757 | 2021-07-09 | San Diego | 73 | Southern California | 0.0 | 2.1428571428571423 | 9.428571428571429 | 11.571428571428571 | 0.8148148148148149 | 0.0 |
22972 | 22972 | Anaheim Global Medical Center | 50744 | 2021-07-09 | Orange | 59 | Southern California | 0.0 | 18.285714285714285 | 3.7142857142857135 | 22.0 | 0.1688311688311688 | 0.0 |
22977 | 22977 | Barlow Respiratory Hospital | 52031 | 2021-07-09 | Los Angeles | 37 | Southern California | 0.0 | 5.0 | 1.0 | 6.0 | 0.1666666666666666 | 0.0 |
22978 | 22978 | Barstow Community Hospital | 50298 | 2021-07-09 | San Bernardino | 71 | Southern California | 0.0 | 1.2857142857142856 | 2.7142857142857144 | 4.0 | 0.6785714285714286 | 0.0 |
22982 | 22982 | California Pacific Medical Center - Mission Bernal | 50055 | 2021-07-09 | San Francisco | 75 | Bay Area | 0.0 | 7.857142857142858 | 2.142857142857143 | 10.0 | 0.2142857142857142 | 0.0 |
22984 | 22984 | California Pacific Medical Ctr-davies Campus Hosp | 50008 | 2021-07-09 | San Francisco | 75 | Bay Area | 0.0 | 2.571428571428571 | 5.428571428571429 | 8.0 | 0.6785714285714286 | 0.0 |
22985 | 22985 | Casa Colina Hospital | 50782 | 2021-07-09 | Los Angeles | 37 | Southern California | 0.0 | 2.142857142857143 | 3.857142857142857 | 6.0 | 0.6428571428571429 | 0.0 |
22986 | 22986 | Cedars-Sinai Marina Del Rey Hospital | 50740 | 2021-07-09 | Los Angeles | 37 | Southern California | 0.0 | 3.571428571428571 | 8.428571428571429 | 12.0 | 0.7023809523809524 | 0.0 |
22989 | 22989 | Chapman Global Medical Center | 50745 | 2021-07-09 | Orange | 59 | Southern California | 0.0 | 7.6 | 4.4 | 12.0 | 0.3666666666666667 | 0.0 |
22990 | 22990 | Chinese Hospital | 50407 | 2021-07-09 | San Francisco | 75 | Bay Area | 0.0 | 3.0 | 3.0 | 6.0 | 0.5 | 0.0 |
22991 | 22991 | Chino Valley Medical Center | 50586 | 2021-07-09 | San Bernardino | 71 | Southern California | 0.0 | 0.1428571428571432 | 2.4285714285714284 | 2.571428571428572 | 0.9444444444444444 | 0.0 |
22992 | 22992 | City of Hope Helford Clinical Research Hospital | 50146 | 2021-07-09 | Los Angeles | 37 | Southern California | 0.0 | 2.1428571428571423 | 15.857142857142858 | 18.0 | 0.8809523809523809 | 0.0 |
22994 | 22994 | Coast Plaza Hospital | 50771 | 2021-07-09 | Los Angeles | 37 | Southern California | 0.0 | 7.0 | 0.0 | 7.0 | 0.0 | |
22995 | 22995 | College Medical Center | 50776 | 2021-07-09 | Los Angeles | 37 | Southern California | 0.0 | 3.8000000000000007 | 10.2 | 14.0 | 0.7285714285714285 | 0.0 |
22996 | 22996 | Colusa Medical Center | 50783 | 2021-07-09 | Colusa | 11 | Greater Sacramento | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
22997 | 22997 | Community Hospital of Huntington Park | 50091 | 2021-07-09 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 3.2857142857142856 | 3.2857142857142856 | 1.0 | 0.0 |
23004 | 23004 | Dameron Hospital | 50122 | 2021-07-09 | San Joaquin | 77 | San Joaquin Valley | 0.0 | 0.1428571428571423 | 8.0 | 8.142857142857142 | 0.9824561403508772 | 0.0 |
23007 | 23007 | Doctors Hospital of Manteca | 50118 | 2021-07-09 | San Joaquin | 77 | San Joaquin Valley | 0.0 | 3.428571428571429 | 4.571428571428571 | 8.0 | 0.5714285714285714 | 0.0 |
23008 | 23008 | Doctors Hospital of Riverside, LLC | 50102 | 2021-07-09 | Riverside | 65 | Southern California | 0.0 | 7.142857142857143 | 4.857142857142857 | 12.0 | 0.4047619047619047 | 0.0 |
23010 | 23010 | Dominican Hospital | 50242 | 2021-07-09 | Santa Cruz | 87 | Bay Area | 0.0 | 2.428571428571429 | 13.571428571428571 | 16.0 | 0.8482142857142857 | 0.0 |
23011 | 23011 | East Los Angeles Doctors Hospital | 50641 | 2021-07-09 | Los Angeles | 37 | Southern California | 0.0 | 2.2857142857142856 | 2.2857142857142856 | 4.571428571428571 | 0.5 | 0.0 |
23015 | 23015 | El Centro Regional Medical Center | 50045 | 2021-07-09 | Imperial | 25 | Southern California | 0.0 | 3.7142857142857135 | 8.285714285714286 | 12.0 | 0.6904761904761906 | 0.0 |
23018 | 23018 | Emanuel Medical Center | 50179 | 2021-07-09 | Stanislaus | 99 | San Joaquin Valley | 0.0 | 8.142857142857142 | 4.714285714285714 | 12.857142857142858 | 0.3666666666666666 | 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 | |
23021 | 23021 | Fairchild Medical Center | 51316 | 2021-07-09 | Siskiyou | 93 | Northern California | 0.0 | 0.1666666666666665 | 3.8333333333333335 | 4.0 | 0.9583333333333334 | 0.0 |
23024 | 23024 | French Hospital Medical Center | 50232 | 2021-07-09 | San Luis Obispo | 79 | Southern California | 0.0 | 2.1428571428571423 | 5.428571428571429 | 7.571428571428571 | 0.7169811320754718 | 0.0 |
23025 | 23025 | Fresno Heart and Surgical Hospital | 50732 | 2021-07-09 | Fresno | 19 | San Joaquin Valley | 0.0 | 1.4285714285714295 | 7.857142857142857 | 9.285714285714286 | 0.846153846153846 | 0.0 |
23027 | 23027 | Garfield Medical Center | 50737 | 2021-07-09 | Los Angeles | 37 | Southern California | 0.0 | 11.142857142857142 | 10.857142857142858 | 22.0 | 0.4935064935064935 | 0.0 |
23029 | 23029 | Glendale Mem Hospital & Health Center | 50058 | 2021-07-09 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 3.142857142857143 | 3.142857142857143 | 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 |
23031 | 23031 | Good Samaritan Hospital | 50257 | 2021-07-09 | Kern | 29 | San Joaquin Valley | 0.0 | 4.0 | 0.0 | 4.0 | 0.0 | |
23034 | 23034 | Grossmont Hospital | 50026 | 2021-07-09 | San Diego | 73 | Southern California | 0.0 | 10.57142857142857 | 64.42857142857143 | 75.0 | 0.8590476190476191 | 0.0 |
23035 | 23035 | Hazel Hawkins Memorial Hospital | 51337 | 2021-07-09 | San Benito | 69 | San Joaquin Valley | 0.0 | 1.0 | 3.0 | 4.0 | 0.75 | 0.0 |
23036 | 23036 | Healdsburg Hospital | 51321 | 2021-07-09 | Sonoma | 97 | Bay Area | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
23037 | 23037 | Hemet Global Medical Center | 50390 | 2021-07-09 | Riverside | 65 | Southern California | 0.0 | 13.0 | 13.0 | 26.0 | 0.5 | 0.0 |
23043 | 23043 | Huntington Beach Hospital | 50526 | 2021-07-09 | Orange | 59 | Southern California | 0.0 | 0.714285714285714 | 3.571428571428572 | 4.285714285714286 | 0.8333333333333334 | 0.0 |
23045 | 23045 | John F Kennedy Memorial Hospital | 50534 | 2021-07-09 | Riverside | 65 | Southern California | 0.0 | 18.42857142857143 | 5.571428571428571 | 24.0 | 0.2321428571428571 | 0.0 |
23057 | 23057 | Kaiser Foundation Hospital - Orange County - Anahe | 50609 | 2021-07-09 | Orange | 59 | Southern California | 0.0 | 21.857142857142858 | 18.142857142857142 | 40.0 | 0.4535714285714285 | 0.0 |
23062 | 23062 | Kaiser Foundation Hospital - San Francisco | 50076 | 2021-07-09 | San Francisco | 75 | Bay Area | 0.0 | 1.8571428571428596 | 15.714285714285714 | 17.571428571428573 | 0.8943089430894308 | 0.0 |
23065 | 23065 | Kaiser Foundation Hospital - South San Francisco | 50070 | 2021-07-09 | San Mateo | 81 | Bay Area | 0.0 | 0.4285714285714279 | 4.142857142857143 | 4.571428571428571 | 0.90625 | 0.0 |
23069 | 23069 | Kaiser Foundation Hospital - Woodland Hills | 50677 | 2021-07-09 | Los Angeles | 37 | Southern California | 0.0 | 14.0 | 3.0 | 17.0 | 0.1764705882352941 | 0.0 |
23079 | 23079 | Kaiser Permanente - San Diego Medical Center | 50515 | 2021-07-09 | San Diego | 73 | Southern California | 0.0 | 13.0 | 7.0 | 20.0 | 0.35 | 0.0 |
23083 | 23083 | Kindred Hospital - Los Angeles | 52032 | 2021-07-09 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 5.0 | 5.0 | 1.0 | 0.0 |
23084 | 23084 | Kindred Hospital - San Diego | 52036 | 2021-07-09 | San Diego | 73 | Southern California | 0.0 | 4.285714285714286 | 3.7142857142857135 | 8.0 | 0.4642857142857143 | 0.0 |
23085 | 23085 | Kindred Hospital - San Francisco Bay Area | 52034 | 2021-07-09 | Alameda | 1 | Bay Area | 0.0 | 2.571428571428571 | 7.428571428571429 | 10.0 | 0.7428571428571429 | 0.0 |
23086 | 23086 | Kindred Hospital -- La Mirada | 52038 | 2021-07-09 | Los Angeles | 37 | Southern California | 0.0 | 4.571428571428571 | 14.428571428571429 | 19.0 | 0.7593984962406015 | 0.0 |
23087 | 23087 | Kindred Hospital Baldwin Park | 52045 | 2021-07-09 | Los Angeles | 37 | Southern California | 0.0 | 1.4285714285714288 | 6.571428571428571 | 8.0 | 0.8214285714285714 | 0.0 |
23088 | 23088 | Kindred Hospital Brea | 52039 | 2021-07-09 | Orange | 59 | Southern California | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
23089 | 23089 | Kindred Hospital Ontario | 52037 | 2021-07-09 | San Bernardino | 71 | Southern California | 0.0 | 1.8571428571428568 | 5.142857142857143 | 7.0 | 0.7346938775510204 | 0.0 |
23090 | 23090 | Kindred Hospital Paramount | 52046 | 2021-07-09 | Los Angeles | 37 | Southern California | 0.0 | 0.8571428571428577 | 11.142857142857142 | 12.0 | 0.9285714285714284 | 0.0 |
23091 | 23091 | Kindred Hospital Rancho | 52049 | 2021-07-09 | San Bernardino | 71 | Southern California | 0.0 | 0.1428571428571432 | 7.857142857142857 | 8.0 | 0.9821428571428572 | 0.0 |
23092 | 23092 | Kindred Hospital Riverside | 52052 | 2021-07-09 | Riverside | 65 | Southern California | 0.0 | 1.5714285714285712 | 6.428571428571429 | 8.0 | 0.8035714285714286 | 0.0 |
23093 | 23093 | Kindred Hospital South Bay | 52050 | 2021-07-09 | Los Angeles | 37 | Southern California | 0.0 | 5.0 | 4.0 | 9.0 | 0.4444444444444444 | 0.0 |
23094 | 23094 | Kindred Hospital Westminster | 52035 | 2021-07-09 | Orange | 59 | Southern California | 0.0 | 0.5714285714285712 | 15.428571428571429 | 16.0 | 0.9642857142857144 | 0.0 |
23095 | 23095 | LA Downtown Medical Center, LLC | 50763 | 2021-07-09 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 12.0 | 12.0 | 1.0 | 0.0 |
23097 | 23097 | LAC/Harbor-UCLA Medical Center | 50376 | 2021-07-09 | Los Angeles | 37 | Southern California | 0.0 | 6.285714285714288 | 29.857142857142858 | 36.142857142857146 | 0.826086956521739 | 0.0 |
23099 | 23099 | LAC/Rancho Los Amigos National Rehabilitation Center | 50717 | 2021-07-09 | Los Angeles | 37 | Southern California | 0.0 | 3.857142857142857 | 3.142857142857143 | 7.0 | 0.4489795918367347 | 0.0 |
23104 | 23104 | Lompoc Valley Medical Center | 50110 | 2021-07-09 | Santa Barbara | 83 | Southern California | 0.0 | 2.571428571428572 | 3.4285714285714284 | 6.0 | 0.5714285714285714 | 0.0 |
23107 | 23107 | Los Robles Hospital & Medical Center | 50549 | 2021-07-09 | Ventura | 111 | Southern California | 0.0 | 1.2857142857142847 | 28.714285714285715 | 30.0 | 0.9571428571428572 | 0.0 |
23108 | 23108 | Mad River Community Hospital | 50028 | 2021-07-09 | Humboldt | 23 | Northern California | 0.0 | 3.0 | 3.0 | 6.0 | 0.5 | 0.0 |
23110 | 23110 | Mammoth Hospital | 51303 | 2021-07-09 | Mono | 51 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
23112 | 23112 | Marinhealth Medical Center | 50360 | 2021-07-09 | Marin | 41 | Bay Area | 0.0 | 11.0 | 8.0 | 19.0 | 0.4210526315789473 | 0.0 |
23113 | 23113 | Mark Twain Medical Center | 51332 | 2021-07-09 | Calaveras | 9 | San Joaquin Valley | 0.0 | 7.428571428571429 | 3.4285714285714284 | 10.857142857142858 | 0.3157894736842105 | 0.0 |
23116 | 23116 | Memorial Hospital Los Banos | 50528 | 2021-07-09 | Merced | 47 | San Joaquin Valley | 0.0 | 3.0 | 1.0 | 4.0 | 0.25 | 0.0 |
23117 | 23117 | Memorial Hospital of Gardena | 50468 | 2021-07-09 | Los Angeles | 37 | Southern California | 0.0 | 5.0 | 2.857142857142857 | 7.857142857142857 | 0.3636363636363636 | 0.0 |
23120 | 23120 | Memorialcare Orange Coast Medical Center | 50678 | 2021-07-09 | Orange | 59 | Southern California | 0.0 | 2.571428571428573 | 23.0 | 25.571428571428573 | 0.8994413407821229 | 0.0 |
23121 | 23121 | Memorialcare Saddleback Medical Center | 50603 | 2021-07-09 | Orange | 59 | Southern California | 0.0 | 5.285714285714285 | 16.714285714285715 | 22.0 | 0.7597402597402598 | 0.0 |
23122 | 23122 | Menifee Global Medical Center | 50684 | 2021-07-09 | Riverside | 65 | Southern California | 0.0 | 5.8 | 4.2 | 10.0 | 0.42 | 0.0 |
23123 | 23123 | Mercy General Hospital | 50017 | 2021-07-09 | Sacramento | 67 | Greater Sacramento | 0.0 | 9.428571428571429 | 21.0 | 30.428571428571427 | 0.6901408450704226 | 0.0 |
23127 | 23127 | Mercy Medical Center Mt Shasta | 51319 | 2021-07-09 | Siskiyou | 93 | Northern California | 0.0 | 3.142857142857143 | 0.8571428571428571 | 4.0 | 0.2142857142857142 | 0.0 |
23128 | 23128 | Mercy Medical Center Redding | 50280 | 2021-07-09 | Shasta | 89 | Northern California | 0.0 | 15.142857142857142 | 17.857142857142858 | 33.0 | 0.5411255411255411 | 0.0 |
23132 | 23132 | Mission Community Hospital | 50704 | 2021-07-09 | Los Angeles | 37 | Southern California | 0.0 | 6.166666666666667 | 6.333333333333333 | 12.5 | 0.5066666666666666 | 0.0 |
23133 | 23133 | Monrovia Memorial Hospital | 52054 | 2021-07-09 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
23134 | 23134 | Montclair Hospital Medical Center | 50758 | 2021-07-09 | San Bernardino | 71 | Southern California | 0.0 | 2.2857142857142856 | 1.7142857142857142 | 4.0 | 0.4285714285714285 | 0.0 |
23135 | 23135 | Monterey Park Hospital | 50736 | 2021-07-09 | Los Angeles | 37 | Southern California | 0.0 | 1.0 | 3.0 | 4.0 | 0.75 | 0.0 |
23136 | 23136 | Natividad Medical Center | 50248 | 2021-07-09 | Monterey | 53 | Bay Area | 0.0 | 1.4285714285714288 | 8.714285714285714 | 10.142857142857142 | 0.8591549295774648 | 0.0 |
23138 | 23138 | Northern Inyo Hospital | 51324 | 2021-07-09 | Inyo | 27 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
23139 | 23139 | Northridge Hospital Medical Center | 50116 | 2021-07-09 | Los Angeles | 37 | Southern California | 0.0 | 2.1428571428571423 | 21.0 | 23.142857142857142 | 0.9074074074074074 | 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 |
23142 | 23142 | Olympia Medical Center | 50742 | 2021-07-09 | Los Angeles | 37 | Southern California | 0.0 | 12.0 | 0.0 | 12.0 | 0.0 | |
23143 | 23143 | Orange County Global Medical Center | 50746 | 2021-07-09 | Orange | 59 | Southern California | 0.0 | 0.0 | 46.0 | 46.0 | 1.0 | 0.0 |
23144 | 23144 | Orchard Hospital | 51311 | 2021-07-09 | Butte | 7 | Greater Sacramento | 0.0 | 2.857142857142857 | 1.1428571428571428 | 4.0 | 0.2857142857142857 | 0.0 |
23145 | 23145 | Oroville Hospital | 50030 | 2021-07-09 | Butte | 7 | Greater Sacramento | 0.0 | 1.8571428571428577 | 8.142857142857142 | 10.0 | 0.8142857142857143 | 0.0 |
23146 | 23146 | Pacifica Hospital of the Valley | 50378 | 2021-07-09 | Los Angeles | 37 | Southern California | 0.0 | 3.571428571428572 | 3.4285714285714284 | 7.0 | 0.4897959183673469 | 0.0 |
23149 | 23149 | Palomar Medical Center Poway | 50636 | 2021-07-09 | San Diego | 73 | Southern California | 0.0 | 3.0 | 9.0 | 12.0 | 0.75 | 0.0 |
23150 | 23150 | Paradise Valley Hospital | 50024 | 2021-07-09 | San Diego | 73 | Southern California | 0.0 | 8.857142857142858 | 6.142857142857143 | 15.0 | 0.4095238095238095 | 0.0 |
23152 | 23152 | Pih Health Downey Hospital | 50393 | 2021-07-09 | Los Angeles | 37 | Southern California | 0.0 | 7.2857142857142865 | 10.714285714285714 | 18.0 | 0.5952380952380952 | 0.0 |
23155 | 23155 | Pioneers Memorial Healthcare District | 50342 | 2021-07-09 | Imperial | 25 | Southern California | 0.0 | 2.1428571428571432 | 5.857142857142857 | 8.0 | 0.7321428571428571 | 0.0 |
23156 | 23156 | Placentia Linda Hospital | 50589 | 2021-07-09 | Orange | 59 | Southern California | 0.0 | 10.0 | 2.0 | 12.0 | 0.1666666666666666 | 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 );