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 2020-12-18 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31838 | 31838 | Alameda Hospital | 50211 | 2020-12-18 | Alameda | 1 | Bay Area | 2.857142857142857 | 3.571428571428571 | 4.428571428571429 | 8.0 | 0.5535714285714286 | 0.6451612903225806 |
31840 | 31840 | Alta Bates Summit Medical Center | 50043 | 2020-12-18 | Alameda | 1 | Bay Area | 6.0 | 17.0 | 19.0 | 36.0 | 0.5277777777777778 | 0.3157894736842105 |
31841 | 31841 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305 | 2020-12-18 | Alameda | 1 | Bay Area | 8.142857142857142 | 11.428571428571429 | 18.571428571428573 | 30.0 | 0.6190476190476191 | 0.4384615384615384 |
31882 | 31882 | Eden Medical Center | 50488 | 2020-12-18 | Alameda | 1 | Bay Area | 11.714285714285714 | 3.1428571428571423 | 20.857142857142858 | 24.0 | 0.8690476190476191 | 0.5616438356164383 |
31910 | 31910 | Highland Hospital | 50320 | 2020-12-18 | Alameda | 1 | Bay Area | 12.857142857142858 | 8.714285714285712 | 25.571428571428573 | 34.285714285714285 | 0.7458333333333333 | 0.5027932960893855 |
31923 | 31923 | Kaiser Foundation Hospital - Fremont | 50512 | 2020-12-18 | Alameda | 1 | Bay Area | 7.285714285714286 | 0.5714285714285712 | 9.0 | 9.571428571428571 | 0.9402985074626866 | 0.8095238095238095 |
31926 | 31926 | Kaiser Foundation Hospital - Oakland/richmond | 50075 | 2020-12-18 | Alameda | 1 | Bay Area | 23.285714285714285 | 1.571428571428573 | 28.0 | 29.571428571428573 | 0.9468599033816424 | 0.8316326530612245 |
31933 | 31933 | Kaiser Foundation Hospital - San Leandro | 50777 | 2020-12-18 | Alameda | 1 | Bay Area | 14.285714285714286 | 0.0 | 22.571428571428573 | 22.571428571428573 | 1.0 | 0.6329113924050633 |
31955 | 31955 | Kindred Hospital - San Francisco Bay Area | 52034 | 2020-12-18 | Alameda | 1 | Bay Area | 0.0 | 2.2857142857142856 | 7.714285714285714 | 10.0 | 0.7714285714285715 | 0.0 |
32089 | 32089 | St. Rose Hospital | 50002 | 2020-12-18 | Alameda | 1 | Bay Area | 7.0 | 5.0 | 10.0 | 15.0 | 0.6666666666666666 | 0.7 |
32091 | 32091 | Stanford Health Care - Valleycare | 50283 | 2020-12-18 | Alameda | 1 | Bay Area | 5.714285714285714 | 5.285714285714285 | 16.714285714285715 | 22.0 | 0.7597402597402598 | 0.3418803418803419 |
32121 | 32121 | Washington Hospital | 50195 | 2020-12-18 | Alameda | 1 | Bay Area | 14.571428571428571 | 1.1428571428571423 | 26.857142857142858 | 28.0 | 0.9591836734693878 | 0.5425531914893617 |
32092 | 32092 | Sutter Amador Hospital | 50014 | 2020-12-18 | Amador | 5 | Greater Sacramento | 1.7142857142857142 | 0.2857142857142856 | 5.714285714285714 | 6.0 | 0.9523809523809524 | 0.3 |
31890 | 31890 | Enloe Medical Center | 50039 | 2020-12-18 | Butte | 7 | Greater Sacramento | 6.857142857142857 | 4.428571428571427 | 20.571428571428573 | 25.0 | 0.822857142857143 | 0.3333333333333333 |
32016 | 32016 | Orchard Hospital | 51311 | 2020-12-18 | Butte | 7 | Greater Sacramento | 2.0 | 1.8571428571428568 | 2.142857142857143 | 4.0 | 0.5357142857142857 | 0.9333333333333332 |
32017 | 32017 | Oroville Hospital | 50030 | 2020-12-18 | Butte | 7 | Greater Sacramento | 3.142857142857143 | 1.8571428571428577 | 8.142857142857142 | 10.0 | 0.8142857142857143 | 0.3859649122807018 |
31984 | 31984 | Mark Twain Medical Center | 51332 | 2020-12-18 | Calaveras | 9 | San Joaquin Valley | 3.0 | 8.142857142857142 | 3.857142857142857 | 12.0 | 0.3214285714285714 | 0.7777777777777778 |
31866 | 31866 | Colusa Medical Center | 50783 | 2020-12-18 | Colusa | 11 | Greater Sacramento | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
31872 | 31872 | Contra Costa Regional Medical Center | 50276 | 2020-12-18 | Contra Costa | 13 | Bay Area | 8.285714285714286 | 4.428571428571429 | 13.571428571428571 | 18.0 | 0.753968253968254 | 0.6105263157894738 |
31916 | 31916 | John Muir Medical Center - Concord Campus | 50496 | 2020-12-18 | Contra Costa | 13 | Bay Area | 9.0 | 5.5 | 30.5 | 36.0 | 0.8472222222222222 | 0.2950819672131147 |
31917 | 31917 | John Muir Medical Center - Walnut Creek Campus | 50180 | 2020-12-18 | Contra Costa | 13 | Bay Area | 20.857142857142858 | 8.285714285714285 | 50.71428571428572 | 59.0 | 0.8595641646489104 | 0.4112676056338028 |
31920 | 31920 | Kaiser Foundation Hospital - Antioch | 50760 | 2020-12-18 | Contra Costa | 13 | Bay Area | 4.142857142857143 | 0.8571428571428568 | 6.714285714285714 | 7.571428571428571 | 0.8867924528301887 | 0.6170212765957447 |
31937 | 31937 | Kaiser Foundation Hospital - Walnut Creek | 50072 | 2020-12-18 | Contra Costa | 13 | Bay Area | 6.571428571428571 | 1.7142857142857153 | 14.857142857142858 | 16.571428571428573 | 0.8965517241379309 | 0.4423076923076923 |
32059 | 32059 | San Ramon Regional Medical Center | 50689 | 2020-12-18 | Contra Costa | 13 | Bay Area | 3.7142857142857135 | 5.857142857142857 | 6.142857142857143 | 12.0 | 0.511904761904762 | 0.6046511627906976 |
32096 | 32096 | Sutter Delta Medical Center | 50523 | 2020-12-18 | Contra Costa | 13 | Bay Area | 2.571428571428572 | 1.0 | 11.0 | 12.0 | 0.9166666666666666 | 0.2337662337662338 |
32094 | 32094 | Sutter Coast Hospital | 50417 | 2020-12-18 | Del Norte | 15 | Northern California | 1.4285714285714286 | 2.4285714285714284 | 3.571428571428572 | 6.0 | 0.5952380952380952 | 0.3999999999999999 |
31850 | 31850 | Barton Memorial Hospital | 50352 | 2020-12-18 | El Dorado | 17 | Greater Sacramento | 1.5714285714285714 | 4.571428571428571 | 3.4285714285714284 | 8.0 | 0.4285714285714285 | 0.4583333333333333 |
31985 | 31985 | Marshall Medical Center | 50254 | 2020-12-18 | El Dorado | 17 | Greater Sacramento | 4.714285714285714 | 2.1428571428571423 | 11.285714285714286 | 13.428571428571429 | 0.8404255319148937 | 0.4177215189873418 |
31863 | 31863 | Clovis Community Medical Center | 50492 | 2020-12-18 | Fresno | 19 | San Joaquin Valley | 28.428571428571427 | 2.3999999999999986 | 33.2 | 35.6 | 0.9325842696629214 | 0.8562822719449225 |
31871 | 31871 | Community Regional Medical Center | 50060 | 2020-12-18 | Fresno | 19 | San Joaquin Valley | 47.142857142857146 | 3.0 | 84.0 | 87.0 | 0.9655172413793104 | 0.5612244897959184 |
31895 | 31895 | Fresno Heart and Surgical Hospital | 50732 | 2020-12-18 | Fresno | 19 | San Joaquin Valley | 0.0 | 2.0 | 7.0 | 9.0 | 0.7777777777777778 | 0.0 |
31924 | 31924 | Kaiser Foundation Hospital - Fresno | 50710 | 2020-12-18 | Fresno | 19 | San Joaquin Valley | 13.142857142857142 | 0.0 | 18.285714285714285 | 18.285714285714285 | 1.0 | 0.71875 |
32048 | 32048 | Saint Agnes Medical Center | 50093 | 2020-12-18 | Fresno | 19 | San Joaquin Valley | 25.142857142857142 | 0.7142857142857153 | 42.0 | 42.71428571428572 | 0.9832775919732442 | 0.5986394557823129 |
32116 | 32116 | Valley Children's Hospital | 53300 | 2020-12-18 | Fresno | 19 | San Joaquin Valley | 0.0 | 0.0 | 12.285714285714286 | 12.285714285714286 | 1.0 | 0.0 |
31978 | 31978 | Mad River Community Hospital | 50028 | 2020-12-18 | Humboldt | 23 | Northern California | 0.0 | 5.0 | 1.0 | 6.0 | 0.1666666666666666 | 0.0 |
32036 | 32036 | Providence Redwood Memorial Hospital | 51318 | 2020-12-18 | Humboldt | 23 | Northern California | 0.0 | 0.1428571428571428 | 3.857142857142857 | 4.0 | 0.9642857142857144 | 0.0 |
32039 | 32039 | Providence St. Joseph Hospital | 50006 | 2020-12-18 | Humboldt | 23 | Northern California | 1.7142857142857142 | 7.2857142857142865 | 10.714285714285714 | 18.0 | 0.5952380952380952 | 0.16 |
31885 | 31885 | El Centro Regional Medical Center | 50045 | 2020-12-18 | Imperial | 25 | Southern California | 29.857142857142858 | 1.571428571428573 | 30.0 | 31.571428571428573 | 0.9502262443438914 | 0.9952380952380953 |
32027 | 32027 | Pioneers Memorial Healthcare District | 50342 | 2020-12-18 | Imperial | 25 | Southern California | 11.428571428571429 | 0.0 | 11.833333333333334 | 11.833333333333334 | 1.0 | 0.96579476861167 |
32009 | 32009 | Northern Inyo Hospital | 51324 | 2020-12-18 | Inyo | 27 | Southern California | 0.0 | 4.0 | 0.0 | 4.0 | 0.0 | |
31822 | 31822 | Adventist Health Bakersfield | 50455 | 2020-12-18 | Kern | 29 | San Joaquin Valley | 15.428571428571429 | 3.5714285714285694 | 26.571428571428573 | 30.142857142857142 | 0.8815165876777252 | 0.5806451612903225 |
31824 | 31824 | Adventist Health Delano | 50608 | 2020-12-18 | Kern | 29 | San Joaquin Valley | 9.428571428571429 | 0.7142857142857153 | 14.714285714285714 | 15.428571428571429 | 0.9537037037037036 | 0.6407766990291263 |
31832 | 31832 | Adventist Health Tehachapi Valley | 51301 | 2020-12-18 | Kern | 29 | San Joaquin Valley | 2.857142857142857 | 0.0 | 4.0 | 4.0 | 1.0 | 0.7142857142857143 |
31846 | 31846 | Bakersfield Heart Hospital | 50724 | 2020-12-18 | Kern | 29 | San Joaquin Valley | 1.2857142857142858 | 2.428571428571429 | 7.571428571428571 | 10.0 | 0.7571428571428571 | 0.169811320754717 |
31847 | 31847 | Bakersfield Memorial Hospital | 50036 | 2020-12-18 | Kern | 29 | San Joaquin Valley | 10.714285714285714 | 3.0 | 26.142857142857142 | 29.142857142857142 | 0.8970588235294118 | 0.4098360655737704 |
31901 | 31901 | Good Samaritan Hospital | 50257 | 2020-12-18 | Kern | 29 | San Joaquin Valley | 0.0 | 4.0 | 0.0 | 4.0 | 0.0 | |
31952 | 31952 | Kern Medical Center | 50315 | 2020-12-18 | Kern | 29 | San Joaquin Valley | 9.571428571428571 | 0.0 | 24.0 | 24.0 | 1.0 | 0.3988095238095238 |
31995 | 31995 | Mercy Hospital | 50295 | 2020-12-18 | Kern | 29 | San Joaquin Valley | 17.857142857142858 | 2.0 | 26.714285714285715 | 28.714285714285715 | 0.9303482587064676 | 0.6684491978609626 |
32044 | 32044 | Ridgecrest Regional Hospital | 51333 | 2020-12-18 | Kern | 29 | San Joaquin Valley | 2.4285714285714284 | 0.0 | 4.285714285714286 | 4.285714285714286 | 1.0 | 0.5666666666666667 |
31825 | 31825 | Adventist Health Hanford | 50121 | 2020-12-18 | Kings | 31 | San Joaquin Valley | 9.285714285714286 | 1.5714285714285694 | 17.571428571428573 | 19.142857142857142 | 0.917910447761194 | 0.5284552845528455 |
31823 | 31823 | Adventist Health Clearlake | 51317 | 2020-12-18 | Lake | 33 | Northern California | 0.8571428571428571 | 0.7142857142857144 | 3.2857142857142856 | 4.0 | 0.8214285714285714 | 0.2608695652173913 |
32097 | 32097 | Sutter Lakeside Hospital | 51329 | 2020-12-18 | Lake | 33 | Northern California | 1.7142857142857142 | 1.7142857142857144 | 3.2857142857142856 | 5.0 | 0.6571428571428571 | 0.5217391304347826 |
31839 | 31839 | Alhambra Hospital Medical Center | 50281 | 2020-12-18 | Los Angeles | 37 | Southern California | 7.285714285714286 | 0.1428571428571441 | 12.142857142857142 | 12.285714285714286 | 0.9883720930232556 | 0.6 |
31844 | 31844 | Antelope Valley Hospital | 50056 | 2020-12-18 | Los Angeles | 37 | Southern California | 19.714285714285715 | 1.1428571428571423 | 31.571428571428573 | 32.714285714285715 | 0.965065502183406 | 0.6244343891402715 |
31848 | 31848 | Barlow Respiratory Hospital | 52031 | 2020-12-18 | Los Angeles | 37 | Southern California | 0.0 | 3.142857142857143 | 2.857142857142857 | 6.0 | 0.4761904761904762 | 0.0 |
31851 | 31851 | Beverly Hospital | 50350 | 2020-12-18 | Los Angeles | 37 | Southern California | 17.857142857142858 | 2.428571428571427 | 22.714285714285715 | 25.142857142857142 | 0.9034090909090908 | 0.7861635220125786 |
31852 | 31852 | California Hospital Medical Center LA | 50149 | 2020-12-18 | Los Angeles | 37 | Southern California | 28.0 | 4.428571428571431 | 33.857142857142854 | 38.285714285714285 | 0.8843283582089552 | 0.8270042194092828 |
31856 | 31856 | Casa Colina Hospital | 50782 | 2020-12-18 | Los Angeles | 37 | Southern California | 0.0 | 1.4285714285714288 | 4.571428571428571 | 6.0 | 0.7619047619047619 | 0.0 |
31857 | 31857 | Cedars-Sinai Marina Del Rey Hospital | 50740 | 2020-12-18 | Los Angeles | 37 | Southern California | 9.571428571428571 | 3.0 | 13.0 | 16.0 | 0.8125 | 0.7362637362637362 |
31858 | 31858 | Centinela Hospital Medical Center | 50739 | 2020-12-18 | Los Angeles | 37 | Southern California | 34.57142857142857 | 0.0 | 52.42857142857143 | 52.42857142857143 | 1.0 | 0.659400544959128 |
31862 | 31862 | City of Hope Helford Clinical Research Hospital | 50146 | 2020-12-18 | Los Angeles | 37 | Southern California | 0.0 | 4.7142857142857135 | 13.285714285714286 | 18.0 | 0.7380952380952381 | 0.0 |
31864 | 31864 | Coast Plaza Hospital | 50771 | 2020-12-18 | Los Angeles | 37 | Southern California | 2.2857142857142856 | 0.7142857142857144 | 6.428571428571429 | 7.142857142857143 | 0.9 | 0.3555555555555555 |
31865 | 31865 | College Medical Center | 50776 | 2020-12-18 | Los Angeles | 37 | Southern California | 7.0 | 0.0 | 8.0 | 8.0 | 1.0 | 0.875 |
31867 | 31867 | Community Hospital of Huntington Park | 50091 | 2020-12-18 | Los Angeles | 37 | Southern California | 8.714285714285714 | 0.0 | 10.571428571428571 | 10.571428571428571 | 1.0 | 0.8243243243243242 |
31881 | 31881 | East Los Angeles Doctors Hospital | 50641 | 2020-12-18 | Los Angeles | 37 | Southern California | 7.857142857142857 | 2.1428571428571432 | 7.857142857142857 | 10.0 | 0.7857142857142857 | 1.0 |
31886 | 31886 | Emanate Health Foothill Presbyterian Hospital | 50597 | 2020-12-18 | Los Angeles | 37 | Southern California | 11.714285714285714 | 0.1428571428571423 | 17.857142857142858 | 18.0 | 0.992063492063492 | 0.6559999999999999 |
31887 | 31887 | Emanate Health Inter-community Hospital | 50382 | 2020-12-18 | Los Angeles | 37 | Southern California | 21.714285714285715 | 2.5714285714285694 | 37.42857142857143 | 40.0 | 0.9357142857142856 | 0.5801526717557252 |
31889 | 31889 | Encino Hospital Medical Center | 50158 | 2020-12-18 | Los Angeles | 37 | Southern California | 3.857142857142857 | 0.0 | 6.142857142857143 | 6.142857142857143 | 1.0 | 0.627906976744186 |
31897 | 31897 | Garfield Medical Center | 50737 | 2020-12-18 | Los Angeles | 37 | Southern California | 13.0 | 6.428571428571429 | 15.571428571428571 | 22.0 | 0.7077922077922078 | 0.8348623853211009 |
31898 | 31898 | Glendale Adventist Medical Center | 50239 | 2020-12-18 | Los Angeles | 37 | Southern California | 26.428571428571427 | 0.2857142857142847 | 43.42857142857143 | 43.71428571428572 | 0.9934640522875816 | 0.6085526315789473 |
31899 | 31899 | Glendale Mem Hospital & Health Center | 50058 | 2020-12-18 | Los Angeles | 37 | Southern California | 20.0 | 0.0 | 26.857142857142858 | 26.857142857142858 | 1.0 | 0.7446808510638298 |
31903 | 31903 | Greater El Monte Community Hospital | 50738 | 2020-12-18 | Los Angeles | 37 | Southern California | 7.714285714285714 | 0.8571428571428577 | 10.142857142857142 | 11.0 | 0.922077922077922 | 0.7605633802816902 |
31908 | 31908 | Henry Mayo Newhall Hospital | 50624 | 2020-12-18 | Los Angeles | 37 | Southern California | 12.571428571428571 | 19.857142857142858 | 25.142857142857142 | 45.0 | 0.5587301587301587 | 0.5 |
31912 | 31912 | Hollywood Presbyterian Medical Center | 50063 | 2020-12-18 | Los Angeles | 37 | Southern California | 19.285714285714285 | 11.333333333333332 | 22.666666666666668 | 34.0 | 0.6666666666666667 | 0.8508403361344536 |
31914 | 31914 | Huntington Hospital | 50438 | 2020-12-18 | Los Angeles | 37 | Southern California | 30.428571428571427 | 21.85714285714285 | 46.142857142857146 | 68.0 | 0.6785714285714286 | 0.6594427244582043 |
31921 | 31921 | Kaiser Foundation Hospital - Baldwin Park | 50723 | 2020-12-18 | Los Angeles | 37 | Southern California | 21.0 | 0.1428571428571423 | 24.857142857142858 | 25.0 | 0.9942857142857144 | 0.8448275862068966 |
31922 | 31922 | Kaiser Foundation Hospital - Downey | 50139 | 2020-12-18 | Los Angeles | 37 | Southern California | 31.0 | 0.5714285714285694 | 39.285714285714285 | 39.85714285714285 | 0.985663082437276 | 0.7890909090909091 |
31925 | 31925 | Kaiser Foundation Hospital - Los Angeles | 50138 | 2020-12-18 | Los Angeles | 37 | Southern California | 25.142857142857142 | 21.142857142857157 | 67.14285714285714 | 88.28571428571429 | 0.7605177993527507 | 0.374468085106383 |
31928 | 31928 | Kaiser Foundation Hospital - Panorama City | 50137 | 2020-12-18 | Los Angeles | 37 | Southern California | 21.0 | 1.571428571428573 | 25.0 | 26.571428571428573 | 0.9408602150537634 | 0.84 |
31934 | 31934 | Kaiser Foundation Hospital - South Bay | 50411 | 2020-12-18 | Los Angeles | 37 | Southern California | 19.0 | 9.42857142857143 | 22.285714285714285 | 31.714285714285715 | 0.7027027027027026 | 0.8525641025641026 |
31938 | 31938 | Kaiser Foundation Hospital - West LA | 50561 | 2020-12-18 | Los Angeles | 37 | Southern California | 29.285714285714285 | 26.14285714285714 | 32.142857142857146 | 58.285714285714285 | 0.5514705882352942 | 0.911111111111111 |
31939 | 31939 | Kaiser Foundation Hospital - Woodland Hills | 50677 | 2020-12-18 | Los Angeles | 37 | Southern California | 15.428571428571429 | 2.0 | 20.142857142857142 | 22.142857142857142 | 0.9096774193548388 | 0.7659574468085106 |
31951 | 31951 | Keck Hospital of USC | 50696 | 2020-12-18 | Los Angeles | 37 | Southern California | 20.0 | 1.7142857142857082 | 76.0 | 77.71428571428571 | 0.9779411764705884 | 0.2631578947368421 |
31953 | 31953 | Kindred Hospital - Los Angeles | 52032 | 2020-12-18 | Los Angeles | 37 | Southern California | 0.0 | 0.1428571428571432 | 4.857142857142857 | 5.0 | 0.9714285714285712 | 0.0 |
31956 | 31956 | Kindred Hospital -- La Mirada | 52038 | 2020-12-18 | Los Angeles | 37 | Southern California | 2.7142857142857144 | 1.2857142857142847 | 17.714285714285715 | 19.0 | 0.9323308270676692 | 0.1532258064516129 |
31957 | 31957 | Kindred Hospital Baldwin Park | 52045 | 2020-12-18 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 8.0 | 8.0 | 1.0 | 0.0 |
31960 | 31960 | Kindred Hospital Paramount | 52046 | 2020-12-18 | Los Angeles | 37 | Southern California | 2.4285714285714284 | 0.5714285714285712 | 11.428571428571429 | 12.0 | 0.9523809523809524 | 0.2124999999999999 |
31963 | 31963 | Kindred Hospital South Bay | 52050 | 2020-12-18 | Los Angeles | 37 | Southern California | 3.0 | 0.0 | 6.0 | 6.0 | 1.0 | 0.5 |
31965 | 31965 | LA Downtown Medical Center, LLC | 50763 | 2020-12-18 | Los Angeles | 37 | Southern California | 1.0 | 2.0 | 10.0 | 12.0 | 0.8333333333333334 | 0.1 |
31966 | 31966 | LAC+USC Medical Center | 50373 | 2020-12-18 | Los Angeles | 37 | Southern California | 53.57142857142857 | 17.285714285714278 | 95.85714285714286 | 113.14285714285714 | 0.8472222222222223 | 0.5588673621460506 |
31967 | 31967 | LAC/Harbor-UCLA Medical Center | 50376 | 2020-12-18 | Los Angeles | 37 | Southern California | 25.714285714285715 | 6.25 | 26.25 | 32.5 | 0.8076923076923077 | 0.979591836734694 |
31968 | 31968 | LAC/Olive View-UCLA Medical Center | 50040 | 2020-12-18 | Los Angeles | 37 | Southern California | 16.857142857142858 | 5.0 | 20.0 | 25.0 | 0.8 | 0.8428571428571429 |
31969 | 31969 | LAC/Rancho Los Amigos National Rehabilitation Center | 50717 | 2020-12-18 | Los Angeles | 37 | Southern California | 4.714285714285714 | 1.0000000000000009 | 7.285714285714286 | 8.285714285714286 | 0.8793103448275861 | 0.6470588235294118 |
31971 | 31971 | Lakewood Regional Medical Center | 50581 | 2020-12-18 | Los Angeles | 37 | Southern California | 16.714285714285715 | 5.0 | 29.0 | 34.0 | 0.8529411764705882 | 0.5763546798029557 |
31976 | 31976 | Los Angeles Community Hospital | 50663 | 2020-12-18 | Los Angeles | 37 | Southern California | 9.0 | 3.571428571428571 | 12.142857142857142 | 15.714285714285714 | 0.7727272727272727 | 0.7411764705882353 |
31986 | 31986 | Martin Luther King, Jr. Community Hospital | 50779 | 2020-12-18 | Los Angeles | 37 | Southern California | 12.428571428571429 | 1.2857142857142847 | 26.571428571428573 | 27.857142857142858 | 0.953846153846154 | 0.4677419354838709 |
31988 | 31988 | Memorial Hospital of Gardena | 50468 | 2020-12-18 | Los Angeles | 37 | Southern California | 19.428571428571427 | 0.0 | 21.857142857142858 | 21.857142857142858 | 1.0 | 0.8888888888888888 |
31990 | 31990 | Memorialcare Long Beach Medical Center | 50485 | 2020-12-18 | Los Angeles | 37 | Southern California | 48.57142857142857 | 20.85714285714286 | 66.42857142857143 | 87.28571428571429 | 0.7610474631751227 | 0.7311827956989246 |
32003 | 32003 | Mission Community Hospital | 50704 | 2020-12-18 | Los Angeles | 37 | Southern California | 9.428571428571429 | 1.142857142857144 | 13.714285714285714 | 14.857142857142858 | 0.923076923076923 | 0.6875000000000001 |
32004 | 32004 | Monrovia Memorial Hospital | 52054 | 2020-12-18 | 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 );