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-01-29 sorted by fips
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29999 | 29999 | Alameda Hospital | 50211 | 2021-01-29 | Alameda | 1 | Bay Area | 1.7142857142857142 | 2.7142857142857144 | 5.285714285714286 | 8.0 | 0.6607142857142857 | 0.3243243243243243 |
30001 | 30001 | Alta Bates Summit Medical Center | 50043 | 2021-01-29 | Alameda | 1 | Bay Area | 7.428571428571429 | 13.428571428571429 | 22.571428571428573 | 36.0 | 0.626984126984127 | 0.3291139240506329 |
30002 | 30002 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305 | 2021-01-29 | Alameda | 1 | Bay Area | 11.0 | 12.857142857142858 | 17.142857142857142 | 30.0 | 0.5714285714285714 | 0.6416666666666667 |
30043 | 30043 | Eden Medical Center | 50488 | 2021-01-29 | Alameda | 1 | Bay Area | 4.571428571428571 | 4.142857142857142 | 19.857142857142858 | 24.0 | 0.8273809523809524 | 0.2302158273381294 |
30071 | 30071 | Highland Hospital | 50320 | 2021-01-29 | Alameda | 1 | Bay Area | 10.285714285714286 | 7.714285714285715 | 25.285714285714285 | 33.0 | 0.7662337662337662 | 0.4067796610169492 |
30084 | 30084 | Kaiser Foundation Hospital - Fremont | 50512 | 2021-01-29 | Alameda | 1 | Bay Area | 7.857142857142857 | 0.1428571428571423 | 11.428571428571429 | 11.571428571428571 | 0.9876543209876544 | 0.6875 |
30087 | 30087 | Kaiser Foundation Hospital - Oakland/richmond | 50075 | 2021-01-29 | Alameda | 1 | Bay Area | 22.142857142857142 | 1.1428571428571423 | 29.714285714285715 | 30.857142857142858 | 0.962962962962963 | 0.7451923076923076 |
30094 | 30094 | Kaiser Foundation Hospital - San Leandro | 50777 | 2021-01-29 | Alameda | 1 | Bay Area | 10.571428571428571 | 1.2857142857142847 | 18.142857142857142 | 19.428571428571427 | 0.9338235294117648 | 0.5826771653543307 |
30116 | 30116 | Kindred Hospital - San Francisco Bay Area | 52034 | 2021-01-29 | Alameda | 1 | Bay Area | 0.0 | 0.2857142857142865 | 9.714285714285714 | 10.0 | 0.9714285714285712 | 0.0 |
30250 | 30250 | St. Rose Hospital | 50002 | 2021-01-29 | Alameda | 1 | Bay Area | 6.285714285714286 | 2.428571428571429 | 11.571428571428571 | 14.0 | 0.826530612244898 | 0.5432098765432098 |
30252 | 30252 | Stanford Health Care - Valleycare | 50283 | 2021-01-29 | Alameda | 1 | Bay Area | 5.142857142857143 | 7.428571428571429 | 14.571428571428571 | 22.0 | 0.6623376623376623 | 0.3529411764705882 |
30282 | 30282 | Washington Hospital | 50195 | 2021-01-29 | Alameda | 1 | Bay Area | 15.285714285714286 | 0.0 | 29.428571428571427 | 29.428571428571427 | 1.0 | 0.5194174757281554 |
30253 | 30253 | Sutter Amador Hospital | 50014 | 2021-01-29 | Amador | 5 | Greater Sacramento | 4.285714285714286 | 1.0 | 5.0 | 6.0 | 0.8333333333333334 | 0.8571428571428571 |
30051 | 30051 | Enloe Medical Center | 50039 | 2021-01-29 | Butte | 7 | Greater Sacramento | 7.571428571428571 | 2.4285714285714306 | 23.142857142857142 | 25.571428571428573 | 0.9050279329608938 | 0.3271604938271605 |
30177 | 30177 | Orchard Hospital | 51311 | 2021-01-29 | Butte | 7 | Greater Sacramento | 0.0 | 1.7142857142857144 | 2.2857142857142856 | 4.0 | 0.5714285714285714 | 0.0 |
30178 | 30178 | Oroville Hospital | 50030 | 2021-01-29 | Butte | 7 | Greater Sacramento | 0.5714285714285714 | 3.1428571428571432 | 6.857142857142857 | 10.0 | 0.6857142857142857 | 0.0833333333333333 |
30145 | 30145 | Mark Twain Medical Center | 51332 | 2021-01-29 | Calaveras | 9 | San Joaquin Valley | 1.4285714285714286 | 9.0 | 3.0 | 12.0 | 0.25 | 0.4761904761904762 |
30027 | 30027 | Colusa Medical Center | 50783 | 2021-01-29 | Colusa | 11 | Greater Sacramento | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
30033 | 30033 | Contra Costa Regional Medical Center | 50276 | 2021-01-29 | Contra Costa | 13 | Bay Area | 4.142857142857143 | 5.571428571428571 | 12.428571428571429 | 18.0 | 0.6904761904761905 | 0.3333333333333333 |
30077 | 30077 | John Muir Medical Center - Concord Campus | 50496 | 2021-01-29 | Contra Costa | 13 | Bay Area | 10.0 | 7.857142857142858 | 28.142857142857142 | 36.0 | 0.7817460317460317 | 0.3553299492385787 |
30078 | 30078 | John Muir Medical Center - Walnut Creek Campus | 50180 | 2021-01-29 | Contra Costa | 13 | Bay Area | 7.857142857142857 | 8.714285714285715 | 49.71428571428572 | 58.42857142857143 | 0.8508557457212714 | 0.1580459770114942 |
30081 | 30081 | Kaiser Foundation Hospital - Antioch | 50760 | 2021-01-29 | Contra Costa | 13 | Bay Area | 7.142857142857143 | 1.0 | 9.571428571428571 | 10.571428571428571 | 0.9054054054054054 | 0.746268656716418 |
30098 | 30098 | Kaiser Foundation Hospital - Walnut Creek | 50072 | 2021-01-29 | Contra Costa | 13 | Bay Area | 5.857142857142857 | 1.5714285714285712 | 14.714285714285714 | 16.285714285714285 | 0.9035087719298246 | 0.3980582524271844 |
30220 | 30220 | San Ramon Regional Medical Center | 50689 | 2021-01-29 | Contra Costa | 13 | Bay Area | 4.0 | 4.0 | 8.0 | 12.0 | 0.6666666666666666 | 0.5 |
30257 | 30257 | Sutter Delta Medical Center | 50523 | 2021-01-29 | Contra Costa | 13 | Bay Area | 5.142857142857143 | 1.1428571428571423 | 10.857142857142858 | 12.0 | 0.9047619047619048 | 0.4736842105263158 |
30255 | 30255 | Sutter Coast Hospital | 50417 | 2021-01-29 | Del Norte | 15 | Northern California | 0.0 | 1.4285714285714288 | 4.571428571428571 | 6.0 | 0.7619047619047619 | 0.0 |
30011 | 30011 | Barton Memorial Hospital | 50352 | 2021-01-29 | El Dorado | 17 | Greater Sacramento | 1.0 | 3.571428571428571 | 4.428571428571429 | 8.0 | 0.5535714285714286 | 0.2258064516129032 |
30146 | 30146 | Marshall Medical Center | 50254 | 2021-01-29 | El Dorado | 17 | Greater Sacramento | 1.5714285714285714 | 3.999999999999999 | 6.714285714285714 | 10.714285714285714 | 0.6266666666666667 | 0.2340425531914893 |
30024 | 30024 | Clovis Community Medical Center | 50492 | 2021-01-29 | Fresno | 19 | San Joaquin Valley | 12.571428571428571 | 2.5714285714285694 | 33.0 | 35.57142857142857 | 0.927710843373494 | 0.3809523809523809 |
30032 | 30032 | Community Regional Medical Center | 50060 | 2021-01-29 | Fresno | 19 | San Joaquin Valley | 20.571428571428573 | 4.0 | 82.57142857142857 | 86.57142857142857 | 0.9537953795379538 | 0.2491349480968858 |
30056 | 30056 | Fresno Heart and Surgical Hospital | 50732 | 2021-01-29 | Fresno | 19 | San Joaquin Valley | 0.0 | 0.7142857142857135 | 8.285714285714286 | 9.0 | 0.9206349206349208 | 0.0 |
30085 | 30085 | Kaiser Foundation Hospital - Fresno | 50710 | 2021-01-29 | Fresno | 19 | San Joaquin Valley | 11.714285714285714 | 0.0 | 16.571428571428573 | 16.571428571428573 | 1.0 | 0.7068965517241378 |
30209 | 30209 | Saint Agnes Medical Center | 50093 | 2021-01-29 | Fresno | 19 | San Joaquin Valley | 32.285714285714285 | 0.2857142857142847 | 48.285714285714285 | 48.57142857142857 | 0.9941176470588236 | 0.6686390532544378 |
30277 | 30277 | Valley Children's Hospital | 53300 | 2021-01-29 | Fresno | 19 | San Joaquin Valley | 2.7142857142857144 | 0.0 | 5.5 | 5.5 | 1.0 | 0.4935064935064935 |
30140 | 30140 | Mad River Community Hospital | 50028 | 2021-01-29 | Humboldt | 23 | Northern California | 1.7142857142857142 | 2.2857142857142856 | 3.7142857142857135 | 6.0 | 0.6190476190476191 | 0.4615384615384615 |
30197 | 30197 | Providence Redwood Memorial Hospital | 51318 | 2021-01-29 | Humboldt | 23 | Northern California | 0.0 | 0.2857142857142856 | 3.7142857142857135 | 4.0 | 0.9285714285714286 | 0.0 |
30200 | 30200 | Providence St. Joseph Hospital | 50006 | 2021-01-29 | Humboldt | 23 | Northern California | 1.7142857142857142 | 4.857142857142858 | 13.142857142857142 | 18.0 | 0.7301587301587301 | 0.1304347826086956 |
30046 | 30046 | El Centro Regional Medical Center | 50045 | 2021-01-29 | Imperial | 25 | Southern California | 16.571428571428573 | 1.7142857142857153 | 21.428571428571427 | 23.142857142857142 | 0.925925925925926 | 0.7733333333333334 |
30188 | 30188 | Pioneers Memorial Healthcare District | 50342 | 2021-01-29 | Imperial | 25 | Southern California | 12.714285714285714 | 0.0 | 14.857142857142858 | 14.857142857142858 | 1.0 | 0.8557692307692307 |
30170 | 30170 | Northern Inyo Hospital | 51324 | 2021-01-29 | Inyo | 27 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
29983 | 29983 | Adventist Health Bakersfield | 50455 | 2021-01-29 | Kern | 29 | San Joaquin Valley | 17.714285714285715 | 7.714285714285715 | 36.285714285714285 | 44.0 | 0.8246753246753247 | 0.4881889763779528 |
29985 | 29985 | Adventist Health Delano | 50608 | 2021-01-29 | Kern | 29 | San Joaquin Valley | 0.0 | 1.0000000000000009 | 7.857142857142857 | 8.857142857142858 | 0.8870967741935483 | 0.0 |
29993 | 29993 | Adventist Health Tehachapi Valley | 51301 | 2021-01-29 | Kern | 29 | San Joaquin Valley | 0.0 | 5.857142857142858 | 2.142857142857143 | 8.0 | 0.2678571428571428 | 0.0 |
30007 | 30007 | Bakersfield Heart Hospital | 50724 | 2021-01-29 | Kern | 29 | San Joaquin Valley | 3.0 | 1.2857142857142865 | 8.714285714285714 | 10.0 | 0.8714285714285713 | 0.3442622950819672 |
30008 | 30008 | Bakersfield Memorial Hospital | 50036 | 2021-01-29 | Kern | 29 | San Joaquin Valley | 14.142857142857142 | 3.571428571428573 | 27.142857142857142 | 30.714285714285715 | 0.883720930232558 | 0.5210526315789473 |
30062 | 30062 | Good Samaritan Hospital | 50257 | 2021-01-29 | Kern | 29 | San Joaquin Valley | 0.0 | 4.0 | 0.0 | 4.0 | 0.0 | |
30113 | 30113 | Kern Medical Center | 50315 | 2021-01-29 | Kern | 29 | San Joaquin Valley | 8.428571428571429 | 0.0 | 25.571428571428573 | 25.571428571428573 | 1.0 | 0.329608938547486 |
30156 | 30156 | Mercy Hospital | 50295 | 2021-01-29 | Kern | 29 | San Joaquin Valley | 25.714285714285715 | 0.5 | 27.5 | 28.0 | 0.9821428571428572 | 0.9350649350649352 |
30205 | 30205 | Ridgecrest Regional Hospital | 51333 | 2021-01-29 | Kern | 29 | San Joaquin Valley | 2.142857142857143 | 1.4285714285714284 | 2.571428571428572 | 4.0 | 0.6428571428571429 | 0.8333333333333333 |
29986 | 29986 | Adventist Health Hanford | 50121 | 2021-01-29 | Kings | 31 | San Joaquin Valley | 10.285714285714286 | 4.142857142857142 | 19.285714285714285 | 23.428571428571427 | 0.8231707317073171 | 0.5333333333333334 |
29984 | 29984 | Adventist Health Clearlake | 51317 | 2021-01-29 | Lake | 33 | Northern California | 0.8571428571428571 | 0.4285714285714284 | 3.571428571428572 | 4.0 | 0.8928571428571429 | 0.2399999999999999 |
30258 | 30258 | Sutter Lakeside Hospital | 51329 | 2021-01-29 | Lake | 33 | Northern California | 0.7142857142857143 | 1.4285714285714284 | 2.571428571428572 | 4.0 | 0.6428571428571429 | 0.2777777777777778 |
30000 | 30000 | Alhambra Hospital Medical Center | 50281 | 2021-01-29 | Los Angeles | 37 | Southern California | 7.142857142857143 | 0.7142857142857135 | 11.0 | 11.714285714285714 | 0.9390243902439024 | 0.6493506493506493 |
30005 | 30005 | Antelope Valley Hospital | 50056 | 2021-01-29 | Los Angeles | 37 | Southern California | 16.857142857142858 | 1.2857142857142847 | 29.571428571428573 | 30.857142857142858 | 0.9583333333333334 | 0.5700483091787439 |
30009 | 30009 | Barlow Respiratory Hospital | 52031 | 2021-01-29 | Los Angeles | 37 | Southern California | 0.0 | 5.142857142857143 | 0.8571428571428571 | 6.0 | 0.1428571428571428 | 0.0 |
30012 | 30012 | Beverly Hospital | 50350 | 2021-01-29 | Los Angeles | 37 | Southern California | 14.285714285714286 | 2.428571428571427 | 22.571428571428573 | 25.0 | 0.9028571428571428 | 0.6329113924050633 |
30013 | 30013 | California Hospital Medical Center LA | 50149 | 2021-01-29 | Los Angeles | 37 | Southern California | 25.285714285714285 | 10.714285714285715 | 36.42857142857143 | 47.142857142857146 | 0.7727272727272727 | 0.6941176470588235 |
30017 | 30017 | Casa Colina Hospital | 50782 | 2021-01-29 | Los Angeles | 37 | Southern California | 0.0 | 3.0 | 3.0 | 6.0 | 0.5 | 0.0 |
30018 | 30018 | Cedars-Sinai Marina Del Rey Hospital | 50740 | 2021-01-29 | Los Angeles | 37 | Southern California | 6.571428571428571 | 4.142857142857142 | 11.857142857142858 | 16.0 | 0.7410714285714286 | 0.5542168674698795 |
30019 | 30019 | Centinela Hospital Medical Center | 50739 | 2021-01-29 | Los Angeles | 37 | Southern California | 34.714285714285715 | 0.1428571428571388 | 66.57142857142857 | 66.71428571428571 | 0.9978586723768738 | 0.5214592274678111 |
30023 | 30023 | City of Hope Helford Clinical Research Hospital | 50146 | 2021-01-29 | Los Angeles | 37 | Southern California | 2.7142857142857144 | 2.0 | 16.0 | 18.0 | 0.8888888888888888 | 0.1696428571428571 |
30025 | 30025 | Coast Plaza Hospital | 50771 | 2021-01-29 | Los Angeles | 37 | Southern California | 7.0 | 0.0 | 7.571428571428571 | 7.571428571428571 | 1.0 | 0.9245283018867924 |
30026 | 30026 | College Medical Center | 50776 | 2021-01-29 | Los Angeles | 37 | Southern California | 3.0 | 0.8571428571428568 | 7.142857142857143 | 8.0 | 0.8928571428571429 | 0.42 |
30028 | 30028 | Community Hospital of Huntington Park | 50091 | 2021-01-29 | Los Angeles | 37 | Southern California | 9.142857142857142 | 0.0 | 9.857142857142858 | 9.857142857142858 | 1.0 | 0.927536231884058 |
30042 | 30042 | East Los Angeles Doctors Hospital | 50641 | 2021-01-29 | Los Angeles | 37 | Southern California | 7.285714285714286 | 2.0 | 8.0 | 10.0 | 0.8 | 0.9107142857142856 |
30047 | 30047 | Emanate Health Foothill Presbyterian Hospital | 50597 | 2021-01-29 | Los Angeles | 37 | Southern California | 13.285714285714286 | 0.1428571428571423 | 22.857142857142858 | 23.0 | 0.9937888198757764 | 0.58125 |
30048 | 30048 | Emanate Health Inter-community Hospital | 50382 | 2021-01-29 | Los Angeles | 37 | Southern California | 24.0 | 3.2857142857142776 | 92.42857142857144 | 95.71428571428572 | 0.9656716417910448 | 0.2596599690880989 |
30050 | 30050 | Encino Hospital Medical Center | 50158 | 2021-01-29 | Los Angeles | 37 | Southern California | 3.7142857142857135 | 0.0 | 5.0 | 5.0 | 1.0 | 0.7428571428571429 |
30058 | 30058 | Garfield Medical Center | 50737 | 2021-01-29 | Los Angeles | 37 | Southern California | 11.571428571428571 | 3.0 | 19.0 | 22.0 | 0.8636363636363636 | 0.6090225563909775 |
30059 | 30059 | Glendale Adventist Medical Center | 50239 | 2021-01-29 | Los Angeles | 37 | Southern California | 43.57142857142857 | 0.2857142857142847 | 54.57142857142857 | 54.85714285714285 | 0.9947916666666666 | 0.7984293193717278 |
30060 | 30060 | Glendale Mem Hospital & Health Center | 50058 | 2021-01-29 | Los Angeles | 37 | Southern California | 15.571428571428571 | 0.2857142857142847 | 17.857142857142858 | 18.142857142857142 | 0.984251968503937 | 0.872 |
30064 | 30064 | Greater El Monte Community Hospital | 50738 | 2021-01-29 | Los Angeles | 37 | Southern California | 10.428571428571429 | 0.0 | 15.142857142857142 | 15.142857142857142 | 1.0 | 0.6886792452830189 |
30069 | 30069 | Henry Mayo Newhall Hospital | 50624 | 2021-01-29 | Los Angeles | 37 | Southern California | 22.142857142857142 | 6.714285714285715 | 33.42857142857143 | 40.142857142857146 | 0.8327402135231317 | 0.6623931623931624 |
30073 | 30073 | Hollywood Presbyterian Medical Center | 50063 | 2021-01-29 | Los Angeles | 37 | Southern California | 13.285714285714286 | 3.571428571428573 | 26.0 | 29.571428571428573 | 0.8792270531400965 | 0.5109890109890111 |
30075 | 30075 | Huntington Hospital | 50438 | 2021-01-29 | Los Angeles | 37 | Southern California | 23.714285714285715 | 36.85714285714286 | 36.57142857142857 | 73.42857142857143 | 0.4980544747081711 | 0.6484375000000001 |
30082 | 30082 | Kaiser Foundation Hospital - Baldwin Park | 50723 | 2021-01-29 | Los Angeles | 37 | Southern California | 15.285714285714286 | 0.0 | 21.0 | 21.0 | 1.0 | 0.7278911564625851 |
30083 | 30083 | Kaiser Foundation Hospital - Downey | 50139 | 2021-01-29 | Los Angeles | 37 | Southern California | 35.57142857142857 | 0.0 | 40.833333333333336 | 40.833333333333336 | 1.0 | 0.871137026239067 |
30086 | 30086 | Kaiser Foundation Hospital - Los Angeles | 50138 | 2021-01-29 | Los Angeles | 37 | Southern California | 35.142857142857146 | 29.57142857142857 | 59.42857142857143 | 89.0 | 0.6677367576243981 | 0.5913461538461539 |
30089 | 30089 | Kaiser Foundation Hospital - Panorama City | 50137 | 2021-01-29 | Los Angeles | 37 | Southern California | 23.857142857142858 | 0.0 | 30.666666666666668 | 30.666666666666668 | 1.0 | 0.7779503105590062 |
30095 | 30095 | Kaiser Foundation Hospital - South Bay | 50411 | 2021-01-29 | Los Angeles | 37 | Southern California | 13.285714285714286 | 0.0 | 23.0 | 23.0 | 1.0 | 0.577639751552795 |
30099 | 30099 | Kaiser Foundation Hospital - West LA | 50561 | 2021-01-29 | Los Angeles | 37 | Southern California | 23.714285714285715 | 0.2857142857142847 | 32.714285714285715 | 33.0 | 0.9913419913419914 | 0.7248908296943232 |
30100 | 30100 | Kaiser Foundation Hospital - Woodland Hills | 50677 | 2021-01-29 | Los Angeles | 37 | Southern California | 13.428571428571429 | 0.0 | 19.857142857142858 | 19.857142857142858 | 1.0 | 0.6762589928057554 |
30112 | 30112 | Keck Hospital of USC | 50696 | 2021-01-29 | Los Angeles | 37 | Southern California | 27.0 | 5.857142857142861 | 71.0 | 76.85714285714286 | 0.9237918215613382 | 0.380281690140845 |
30114 | 30114 | Kindred Hospital - Los Angeles | 52032 | 2021-01-29 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 5.0 | 5.0 | 1.0 | 0.0 |
30117 | 30117 | Kindred Hospital -- La Mirada | 52038 | 2021-01-29 | Los Angeles | 37 | Southern California | 2.857142857142857 | 1.571428571428573 | 17.428571428571427 | 19.0 | 0.9172932330827068 | 0.1639344262295082 |
30118 | 30118 | Kindred Hospital Baldwin Park | 52045 | 2021-01-29 | Los Angeles | 37 | Southern California | 0.0 | 1.2857142857142856 | 6.714285714285714 | 8.0 | 0.8392857142857143 | 0.0 |
30121 | 30121 | Kindred Hospital Paramount | 52046 | 2021-01-29 | Los Angeles | 37 | Southern California | 1.0 | 0.8571428571428577 | 11.142857142857142 | 12.0 | 0.9285714285714284 | 0.0897435897435897 |
30124 | 30124 | Kindred Hospital South Bay | 52050 | 2021-01-29 | Los Angeles | 37 | Southern California | 6.571428571428571 | 0.0 | 9.0 | 9.0 | 1.0 | 0.7301587301587301 |
30126 | 30126 | LA Downtown Medical Center, LLC | 50763 | 2021-01-29 | Los Angeles | 37 | Southern California | 2.7142857142857144 | 0.0 | 12.0 | 12.0 | 1.0 | 0.2261904761904762 |
30127 | 30127 | LAC+USC Medical Center | 50373 | 2021-01-29 | Los Angeles | 37 | Southern California | 50.285714285714285 | 16.285714285714292 | 98.71428571428572 | 115.0 | 0.8583850931677018 | 0.5094066570188134 |
30128 | 30128 | LAC/Harbor-UCLA Medical Center | 50376 | 2021-01-29 | Los Angeles | 37 | Southern California | 25.0 | 4.714285714285715 | 47.0 | 51.71428571428572 | 0.9088397790055248 | 0.5319148936170213 |
30129 | 30129 | LAC/Olive View-UCLA Medical Center | 50040 | 2021-01-29 | Los Angeles | 37 | Southern California | 14.142857142857142 | 1.8571428571428577 | 27.428571428571427 | 29.285714285714285 | 0.9365853658536584 | 0.515625 |
30130 | 30130 | LAC/Rancho Los Amigos National Rehabilitation Center | 50717 | 2021-01-29 | Los Angeles | 37 | Southern California | 4.0 | 0.5714285714285712 | 7.571428571428571 | 8.142857142857142 | 0.9298245614035088 | 0.5283018867924528 |
30132 | 30132 | Lakewood Regional Medical Center | 50581 | 2021-01-29 | Los Angeles | 37 | Southern California | 32.142857142857146 | 6.571428571428569 | 44.71428571428572 | 51.285714285714285 | 0.871866295264624 | 0.7188498402555911 |
30138 | 30138 | Los Angeles Community Hospital | 50663 | 2021-01-29 | Los Angeles | 37 | Southern California | 11.428571428571429 | 7.857142857142856 | 14.285714285714286 | 22.142857142857142 | 0.6451612903225807 | 0.7999999999999999 |
30147 | 30147 | Martin Luther King, Jr. Community Hospital | 50779 | 2021-01-29 | Los Angeles | 37 | Southern California | 27.571428571428573 | 0.0 | 42.42857142857143 | 42.42857142857143 | 1.0 | 0.6498316498316499 |
30149 | 30149 | Memorial Hospital of Gardena | 50468 | 2021-01-29 | Los Angeles | 37 | Southern California | 19.285714285714285 | 0.0 | 42.285714285714285 | 42.285714285714285 | 1.0 | 0.4560810810810811 |
30151 | 30151 | Memorialcare Long Beach Medical Center | 50485 | 2021-01-29 | Los Angeles | 37 | Southern California | 65.28571428571429 | 6.285714285714292 | 102.57142857142856 | 108.85714285714286 | 0.942257217847769 | 0.6364902506963789 |
30164 | 30164 | Mission Community Hospital | 50704 | 2021-01-29 | Los Angeles | 37 | Southern California | 22.0 | 4.714285714285715 | 21.285714285714285 | 26.0 | 0.8186813186813187 | 1.0335570469798658 |
30165 | 30165 | Monrovia Memorial Hospital | 52054 | 2021-01-29 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 4.0 | 4.0 | 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 );