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-02-12 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29386 | 29386 | Alameda Hospital | 50211 | 2021-02-12 | Alameda | 1 | Bay Area | 2.0 | 2.0 | 6.0 | 8.0 | 0.75 | 0.3333333333333333 |
29388 | 29388 | Alta Bates Summit Medical Center | 50043 | 2021-02-12 | Alameda | 1 | Bay Area | 2.4285714285714284 | 18.571428571428573 | 17.428571428571427 | 36.0 | 0.4841269841269841 | 0.1393442622950819 |
29389 | 29389 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305 | 2021-02-12 | Alameda | 1 | Bay Area | 5.571428571428571 | 15.714285714285714 | 14.285714285714286 | 30.0 | 0.4761904761904762 | 0.3899999999999999 |
29431 | 29431 | Eden Medical Center | 50488 | 2021-02-12 | Alameda | 1 | Bay Area | 3.0 | 3.7142857142857153 | 20.285714285714285 | 24.0 | 0.8452380952380952 | 0.1478873239436619 |
29458 | 29458 | Highland Hospital | 50320 | 2021-02-12 | Alameda | 1 | Bay Area | 5.142857142857143 | 6.428571428571427 | 26.571428571428573 | 33.0 | 0.8051948051948052 | 0.1935483870967742 |
29471 | 29471 | Kaiser Foundation Hospital - Fremont | 50512 | 2021-02-12 | Alameda | 1 | Bay Area | 6.428571428571429 | 0.2857142857142865 | 10.714285714285714 | 11.0 | 0.974025974025974 | 0.6000000000000001 |
29474 | 29474 | Kaiser Foundation Hospital - Oakland/richmond | 50075 | 2021-02-12 | Alameda | 1 | Bay Area | 16.0 | 2.1428571428571423 | 27.571428571428573 | 29.714285714285715 | 0.9278846153846154 | 0.5803108808290155 |
29481 | 29481 | Kaiser Foundation Hospital - San Leandro | 50777 | 2021-02-12 | Alameda | 1 | Bay Area | 7.0 | 1.571428571428573 | 15.142857142857142 | 16.714285714285715 | 0.905982905982906 | 0.4622641509433962 |
29503 | 29503 | Kindred Hospital - San Francisco Bay Area | 52034 | 2021-02-12 | Alameda | 1 | Bay Area | 0.0 | 0.1428571428571423 | 9.857142857142858 | 10.0 | 0.9857142857142858 | 0.0 |
29637 | 29637 | St. Rose Hospital | 50002 | 2021-02-12 | Alameda | 1 | Bay Area | 6.0 | 5.7142857142857135 | 8.285714285714286 | 14.0 | 0.5918367346938777 | 0.7241379310344827 |
29639 | 29639 | Stanford Health Care - Valleycare | 50283 | 2021-02-12 | Alameda | 1 | Bay Area | 2.857142857142857 | 4.714285714285715 | 17.285714285714285 | 22.0 | 0.7857142857142857 | 0.1652892561983471 |
29669 | 29669 | Washington Hospital | 50195 | 2021-02-12 | Alameda | 1 | Bay Area | 9.142857142857142 | 4.428571428571427 | 23.571428571428573 | 28.0 | 0.8418367346938777 | 0.3878787878787878 |
29640 | 29640 | Sutter Amador Hospital | 50014 | 2021-02-12 | Amador | 5 | Greater Sacramento | 1.7142857142857142 | 1.0 | 5.0 | 6.0 | 0.8333333333333334 | 0.3428571428571428 |
29439 | 29439 | Enloe Medical Center | 50039 | 2021-02-12 | Butte | 7 | Greater Sacramento | 1.4285714285714286 | 8.142857142857142 | 15.857142857142858 | 24.0 | 0.6607142857142857 | 0.09009009009009 |
29563 | 29563 | Orchard Hospital | 51311 | 2021-02-12 | Butte | 7 | Greater Sacramento | 0.0 | 1.8571428571428568 | 2.142857142857143 | 4.0 | 0.5357142857142857 | 0.0 |
29564 | 29564 | Oroville Hospital | 50030 | 2021-02-12 | Butte | 7 | Greater Sacramento | 0.0 | 1.2857142857142865 | 8.714285714285714 | 10.0 | 0.8714285714285713 | 0.0 |
29531 | 29531 | Mark Twain Medical Center | 51332 | 2021-02-12 | Calaveras | 9 | San Joaquin Valley | 1.0 | 9.428571428571429 | 2.571428571428572 | 12.0 | 0.2142857142857143 | 0.3888888888888888 |
29415 | 29415 | Colusa Medical Center | 50783 | 2021-02-12 | Colusa | 11 | Greater Sacramento | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
29421 | 29421 | Contra Costa Regional Medical Center | 50276 | 2021-02-12 | Contra Costa | 13 | Bay Area | 3.0 | 5.166666666666666 | 12.833333333333334 | 18.0 | 0.712962962962963 | 0.2337662337662337 |
29464 | 29464 | John Muir Medical Center - Concord Campus | 50496 | 2021-02-12 | Contra Costa | 13 | Bay Area | 6.857142857142857 | 6.857142857142858 | 29.142857142857142 | 36.0 | 0.8095238095238095 | 0.2352941176470588 |
29465 | 29465 | John Muir Medical Center - Walnut Creek Campus | 50180 | 2021-02-12 | Contra Costa | 13 | Bay Area | 5.285714285714286 | 16.85714285714286 | 40.285714285714285 | 57.142857142857146 | 0.705 | 0.1312056737588652 |
29468 | 29468 | Kaiser Foundation Hospital - Antioch | 50760 | 2021-02-12 | Contra Costa | 13 | Bay Area | 5.142857142857143 | 1.0 | 8.571428571428571 | 9.571428571428571 | 0.8955223880597015 | 0.6000000000000001 |
29485 | 29485 | Kaiser Foundation Hospital - Walnut Creek | 50072 | 2021-02-12 | Contra Costa | 13 | Bay Area | 7.428571428571429 | 1.2857142857142847 | 23.142857142857142 | 24.428571428571427 | 0.9473684210526316 | 0.3209876543209877 |
29606 | 29606 | San Ramon Regional Medical Center | 50689 | 2021-02-12 | Contra Costa | 13 | Bay Area | 2.571428571428572 | 5.428571428571429 | 6.571428571428571 | 12.0 | 0.5476190476190476 | 0.391304347826087 |
29644 | 29644 | Sutter Delta Medical Center | 50523 | 2021-02-12 | Contra Costa | 13 | Bay Area | 4.857142857142857 | 0.8571428571428577 | 11.142857142857142 | 12.0 | 0.9285714285714284 | 0.4358974358974359 |
29642 | 29642 | Sutter Coast Hospital | 50417 | 2021-02-12 | Del Norte | 15 | Northern California | 0.0 | 1.4285714285714288 | 4.571428571428571 | 6.0 | 0.7619047619047619 | 0.0 |
29398 | 29398 | Barton Memorial Hospital | 50352 | 2021-02-12 | El Dorado | 17 | Greater Sacramento | 0.8571428571428571 | 5.0 | 3.0 | 8.0 | 0.375 | 0.2857142857142857 |
29532 | 29532 | Marshall Medical Center | 50254 | 2021-02-12 | El Dorado | 17 | Greater Sacramento | 1.1666666666666667 | 3.000000000000001 | 5.333333333333333 | 8.333333333333334 | 0.6399999999999999 | 0.21875 |
29412 | 29412 | Clovis Community Medical Center | 50492 | 2021-02-12 | Fresno | 19 | San Joaquin Valley | 14.857142857142858 | 4.0 | 24.285714285714285 | 28.285714285714285 | 0.8585858585858586 | 0.611764705882353 |
29420 | 29420 | Community Regional Medical Center | 50060 | 2021-02-12 | Fresno | 19 | San Joaquin Valley | 31.142857142857142 | 9.0 | 77.0 | 86.0 | 0.8953488372093024 | 0.4044526901669759 |
29444 | 29444 | Fresno Heart and Surgical Hospital | 50732 | 2021-02-12 | Fresno | 19 | San Joaquin Valley | 0.0 | 1.4285714285714288 | 7.571428571428571 | 9.0 | 0.8412698412698413 | 0.0 |
29472 | 29472 | Kaiser Foundation Hospital - Fresno | 50710 | 2021-02-12 | Fresno | 19 | San Joaquin Valley | 10.285714285714286 | 0.0 | 14.571428571428571 | 14.571428571428571 | 1.0 | 0.7058823529411765 |
29595 | 29595 | Saint Agnes Medical Center | 50093 | 2021-02-12 | Fresno | 19 | San Joaquin Valley | 25.428571428571427 | 0.7142857142857082 | 40.142857142857146 | 40.85714285714285 | 0.9825174825174826 | 0.6334519572953736 |
29664 | 29664 | Valley Children's Hospital | 53300 | 2021-02-12 | Fresno | 19 | San Joaquin Valley | 1.2857142857142858 | 0.0 | 2.571428571428572 | 2.571428571428572 | 1.0 | 0.5 |
29526 | 29526 | Mad River Community Hospital | 50028 | 2021-02-12 | Humboldt | 23 | Northern California | 0.8571428571428571 | 2.2857142857142856 | 3.7142857142857135 | 6.0 | 0.6190476190476191 | 0.2307692307692307 |
29583 | 29583 | Providence Redwood Memorial Hospital | 51318 | 2021-02-12 | Humboldt | 23 | Northern California | 0.5714285714285714 | 0.7142857142857144 | 3.2857142857142856 | 4.0 | 0.8214285714285714 | 0.1739130434782608 |
29586 | 29586 | Providence St. Joseph Hospital | 50006 | 2021-02-12 | Humboldt | 23 | Northern California | 2.4285714285714284 | 3.428571428571429 | 14.571428571428571 | 18.0 | 0.8095238095238095 | 0.1666666666666666 |
29434 | 29434 | El Centro Regional Medical Center | 50045 | 2021-02-12 | Imperial | 25 | Southern California | 9.428571428571429 | 1.666666666666666 | 13.0 | 14.666666666666666 | 0.8863636363636364 | 0.7252747252747253 |
29574 | 29574 | Pioneers Memorial Healthcare District | 50342 | 2021-02-12 | Imperial | 25 | Southern California | 7.857142857142857 | 0.1428571428571423 | 10.0 | 10.142857142857142 | 0.9859154929577464 | 0.7857142857142857 |
29556 | 29556 | Northern Inyo Hospital | 51324 | 2021-02-12 | Inyo | 27 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
29370 | 29370 | Adventist Health Bakersfield | 50455 | 2021-02-12 | Kern | 29 | San Joaquin Valley | 13.571428571428571 | 9.0 | 35.0 | 44.0 | 0.7954545454545454 | 0.3877551020408163 |
29372 | 29372 | Adventist Health Delano | 50608 | 2021-02-12 | Kern | 29 | San Joaquin Valley | 0.0 | 0.8571428571428568 | 6.0 | 6.857142857142857 | 0.875 | 0.0 |
29380 | 29380 | Adventist Health Tehachapi Valley | 51301 | 2021-02-12 | Kern | 29 | San Joaquin Valley | 0.0 | 6.142857142857142 | 1.8571428571428568 | 8.0 | 0.2321428571428571 | 0.0 |
29394 | 29394 | Bakersfield Heart Hospital | 50724 | 2021-02-12 | Kern | 29 | San Joaquin Valley | 3.142857142857143 | 1.0 | 8.857142857142858 | 9.857142857142858 | 0.8985507246376812 | 0.3548387096774193 |
29395 | 29395 | Bakersfield Memorial Hospital | 50036 | 2021-02-12 | Kern | 29 | San Joaquin Valley | 12.0 | 3.666666666666668 | 30.666666666666668 | 34.333333333333336 | 0.8932038834951456 | 0.3913043478260869 |
29449 | 29449 | Good Samaritan Hospital | 50257 | 2021-02-12 | Kern | 29 | San Joaquin Valley | 0.0 | 4.0 | 0.0 | 4.0 | 0.0 | |
29500 | 29500 | Kern Medical Center | 50315 | 2021-02-12 | Kern | 29 | San Joaquin Valley | 4.142857142857143 | 0.0 | 25.285714285714285 | 25.285714285714285 | 1.0 | 0.1638418079096045 |
29542 | 29542 | Mercy Hospital | 50295 | 2021-02-12 | Kern | 29 | San Joaquin Valley | 18.571428571428573 | 3.7142857142857153 | 24.285714285714285 | 28.0 | 0.8673469387755102 | 0.7647058823529412 |
29591 | 29591 | Ridgecrest Regional Hospital | 51333 | 2021-02-12 | Kern | 29 | San Joaquin Valley | 1.0 | 0.1428571428571428 | 3.857142857142857 | 4.0 | 0.9642857142857144 | 0.2592592592592592 |
29373 | 29373 | Adventist Health Hanford | 50121 | 2021-02-12 | Kings | 31 | San Joaquin Valley | 9.857142857142858 | 6.428571428571427 | 17.0 | 23.428571428571427 | 0.7256097560975611 | 0.5798319327731093 |
29371 | 29371 | Adventist Health Clearlake | 51317 | 2021-02-12 | Lake | 33 | Northern California | 0.0 | 0.1428571428571428 | 3.857142857142857 | 4.0 | 0.9642857142857144 | 0.0 |
29645 | 29645 | Sutter Lakeside Hospital | 51329 | 2021-02-12 | Lake | 33 | Northern California | 0.8571428571428571 | 0.8571428571428572 | 3.142857142857143 | 4.0 | 0.7857142857142857 | 0.2727272727272727 |
29387 | 29387 | Alhambra Hospital Medical Center | 50281 | 2021-02-12 | Los Angeles | 37 | Southern California | 2.571428571428572 | 1.0 | 9.0 | 10.0 | 0.9 | 0.2857142857142857 |
29392 | 29392 | Antelope Valley Hospital | 50056 | 2021-02-12 | Los Angeles | 37 | Southern California | 6.428571428571429 | 1.0 | 29.571428571428573 | 30.571428571428573 | 0.9672897196261684 | 0.217391304347826 |
29396 | 29396 | Barlow Respiratory Hospital | 52031 | 2021-02-12 | Los Angeles | 37 | Southern California | 0.0 | 2.571428571428572 | 3.4285714285714284 | 6.0 | 0.5714285714285714 | 0.0 |
29399 | 29399 | Beverly Hospital | 50350 | 2021-02-12 | Los Angeles | 37 | Southern California | 15.285714285714286 | 1.7142857142857153 | 23.285714285714285 | 25.0 | 0.9314285714285714 | 0.6564417177914111 |
29400 | 29400 | California Hospital Medical Center LA | 50149 | 2021-02-12 | Los Angeles | 37 | Southern California | 14.285714285714286 | 7.857142857142858 | 23.0 | 30.857142857142858 | 0.7453703703703703 | 0.6211180124223603 |
29404 | 29404 | Casa Colina Hospital | 50782 | 2021-02-12 | Los Angeles | 37 | Southern California | 0.0 | 3.0 | 3.0 | 6.0 | 0.5 | 0.0 |
29405 | 29405 | Cedars-Sinai Marina Del Rey Hospital | 50740 | 2021-02-12 | Los Angeles | 37 | Southern California | 5.571428571428571 | 5.428571428571429 | 12.571428571428571 | 18.0 | 0.6984126984126984 | 0.4431818181818182 |
29406 | 29406 | Cedars-Sinai Medical Center | 50625 | 2021-02-12 | Los Angeles | 37 | Southern California | 20.142857142857142 | 15.0 | 125.5 | 140.5 | 0.8932384341637011 | 0.1605008537279453 |
29407 | 29407 | Centinela Hospital Medical Center | 50739 | 2021-02-12 | Los Angeles | 37 | Southern California | 20.857142857142858 | 0.0 | 50.285714285714285 | 50.285714285714285 | 1.0 | 0.4147727272727273 |
29411 | 29411 | City of Hope Helford Clinical Research Hospital | 50146 | 2021-02-12 | Los Angeles | 37 | Southern California | 2.7142857142857144 | 6.0 | 12.0 | 18.0 | 0.6666666666666666 | 0.2261904761904762 |
29413 | 29413 | Coast Plaza Hospital | 50771 | 2021-02-12 | Los Angeles | 37 | Southern California | 7.428571428571429 | 0.0 | 7.428571428571429 | 7.428571428571429 | 1.0 | 1.0 |
29414 | 29414 | College Medical Center | 50776 | 2021-02-12 | Los Angeles | 37 | Southern California | 3.5 | 0.666666666666667 | 7.333333333333333 | 8.0 | 0.9166666666666666 | 0.4772727272727273 |
29416 | 29416 | Community Hospital of Huntington Park | 50091 | 2021-02-12 | Los Angeles | 37 | Southern California | 6.5 | -0.166666666666666 | 10.666666666666666 | 10.5 | 1.0158730158730158 | 0.609375 |
29430 | 29430 | East Los Angeles Doctors Hospital | 50641 | 2021-02-12 | Los Angeles | 37 | Southern California | 6.142857142857143 | 1.4285714285714288 | 8.571428571428571 | 10.0 | 0.8571428571428571 | 0.7166666666666668 |
29435 | 29435 | Emanate Health Foothill Presbyterian Hospital | 50597 | 2021-02-12 | Los Angeles | 37 | Southern California | 11.857142857142858 | 0.428571428571427 | 19.857142857142858 | 20.285714285714285 | 0.9788732394366196 | 0.5971223021582734 |
29436 | 29436 | Emanate Health Inter-community Hospital | 50382 | 2021-02-12 | Los Angeles | 37 | Southern California | 16.428571428571427 | 5.285714285714292 | 69.57142857142857 | 74.85714285714286 | 0.9293893129770991 | 0.2361396303901437 |
29438 | 29438 | Encino Hospital Medical Center | 50158 | 2021-02-12 | Los Angeles | 37 | Southern California | 2.571428571428572 | 1.4285714285714284 | 2.571428571428572 | 4.0 | 0.6428571428571429 | 1.0 |
29446 | 29446 | Garfield Medical Center | 50737 | 2021-02-12 | Los Angeles | 37 | Southern California | 12.714285714285714 | 1.1428571428571423 | 20.857142857142858 | 22.0 | 0.948051948051948 | 0.6095890410958904 |
29447 | 29447 | Glendale Adventist Medical Center | 50239 | 2021-02-12 | Los Angeles | 37 | Southern California | 32.857142857142854 | 0.8571428571428541 | 47.71428571428572 | 48.57142857142857 | 0.9823529411764708 | 0.6886227544910178 |
29448 | 29448 | Glendale Mem Hospital & Health Center | 50058 | 2021-02-12 | Los Angeles | 37 | Southern California | 15.285714285714286 | 1.142857142857146 | 19.428571428571427 | 20.571428571428573 | 0.9444444444444444 | 0.786764705882353 |
29451 | 29451 | Greater El Monte Community Hospital | 50738 | 2021-02-12 | Los Angeles | 37 | Southern California | 6.571428571428571 | 0.4285714285714288 | 12.428571428571429 | 12.857142857142858 | 0.9666666666666668 | 0.5287356321839081 |
29456 | 29456 | Henry Mayo Newhall Hospital | 50624 | 2021-02-12 | Los Angeles | 37 | Southern California | 8.857142857142858 | 1.571428571428573 | 26.142857142857142 | 27.714285714285715 | 0.9432989690721648 | 0.3387978142076503 |
29460 | 29460 | Hollywood Presbyterian Medical Center | 50063 | 2021-02-12 | Los Angeles | 37 | Southern California | 8.571428571428571 | 5.714285714285715 | 18.285714285714285 | 24.0 | 0.7619047619047619 | 0.46875 |
29462 | 29462 | Huntington Hospital | 50438 | 2021-02-12 | Los Angeles | 37 | Southern California | 17.285714285714285 | 47.85714285714286 | 25.142857142857142 | 73.0 | 0.3444227005870841 | 0.6875 |
29469 | 29469 | Kaiser Foundation Hospital - Baldwin Park | 50723 | 2021-02-12 | Los Angeles | 37 | Southern California | 5.285714285714286 | 1.0 | 12.0 | 13.0 | 0.9230769230769232 | 0.4404761904761904 |
29470 | 29470 | Kaiser Foundation Hospital - Downey | 50139 | 2021-02-12 | Los Angeles | 37 | Southern California | 27.857142857142858 | 0.0 | 37.57142857142857 | 37.57142857142857 | 1.0 | 0.7414448669201521 |
29473 | 29473 | Kaiser Foundation Hospital - Los Angeles | 50138 | 2021-02-12 | Los Angeles | 37 | Southern California | 18.571428571428573 | 34.285714285714285 | 54.71428571428572 | 89.0 | 0.6147672552166934 | 0.3394255874673629 |
29476 | 29476 | Kaiser Foundation Hospital - Panorama City | 50137 | 2021-02-12 | Los Angeles | 37 | Southern California | 14.428571428571429 | 2.1428571428571423 | 20.0 | 22.142857142857142 | 0.9032258064516128 | 0.7214285714285714 |
29482 | 29482 | Kaiser Foundation Hospital - South Bay | 50411 | 2021-02-12 | Los Angeles | 37 | Southern California | 11.428571428571429 | 1.2857142857142885 | 19.285714285714285 | 20.571428571428573 | 0.9375 | 0.5925925925925927 |
29486 | 29486 | Kaiser Foundation Hospital - West LA | 50561 | 2021-02-12 | Los Angeles | 37 | Southern California | 14.285714285714286 | 2.857142857142854 | 27.571428571428573 | 30.428571428571427 | 0.9061032863849766 | 0.5181347150259067 |
29487 | 29487 | Kaiser Foundation Hospital - Woodland Hills | 50677 | 2021-02-12 | Los Angeles | 37 | Southern California | 9.571428571428571 | 4.0 | 13.0 | 17.0 | 0.7647058823529411 | 0.7362637362637362 |
29499 | 29499 | Keck Hospital of USC | 50696 | 2021-02-12 | Los Angeles | 37 | Southern California | 17.857142857142858 | 5.428571428571431 | 73.14285714285714 | 78.57142857142857 | 0.9309090909090908 | 0.244140625 |
29501 | 29501 | Kindred Hospital - Los Angeles | 52032 | 2021-02-12 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 5.0 | 5.0 | 1.0 | 0.0 |
29504 | 29504 | Kindred Hospital -- La Mirada | 52038 | 2021-02-12 | Los Angeles | 37 | Southern California | 1.4285714285714286 | 1.2857142857142847 | 17.714285714285715 | 19.0 | 0.9323308270676692 | 0.0806451612903225 |
29505 | 29505 | Kindred Hospital Baldwin Park | 52045 | 2021-02-12 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 8.0 | 8.0 | 1.0 | 0.0 |
29508 | 29508 | Kindred Hospital Paramount | 52046 | 2021-02-12 | Los Angeles | 37 | Southern California | 1.7142857142857142 | 0.1428571428571423 | 11.857142857142858 | 12.0 | 0.988095238095238 | 0.144578313253012 |
29511 | 29511 | Kindred Hospital South Bay | 52050 | 2021-02-12 | Los Angeles | 37 | Southern California | 5.142857142857143 | 0.0 | 9.0 | 9.0 | 1.0 | 0.5714285714285715 |
29513 | 29513 | LA Downtown Medical Center, LLC | 50763 | 2021-02-12 | Los Angeles | 37 | Southern California | 1.1428571428571428 | 0.0 | 12.0 | 12.0 | 1.0 | 0.0952380952380952 |
29514 | 29514 | LAC+USC Medical Center | 50373 | 2021-02-12 | Los Angeles | 37 | Southern California | 37.71428571428572 | 16.285714285714292 | 92.57142857142856 | 108.85714285714286 | 0.8503937007874015 | 0.4074074074074074 |
29515 | 29515 | LAC/Harbor-UCLA Medical Center | 50376 | 2021-02-12 | Los Angeles | 37 | Southern California | 17.714285714285715 | 2.7142857142857157 | 38.285714285714285 | 41.0 | 0.9337979094076656 | 0.4626865671641791 |
29516 | 29516 | LAC/Olive View-UCLA Medical Center | 50040 | 2021-02-12 | Los Angeles | 37 | Southern California | 8.0 | 5.142857142857142 | 27.428571428571427 | 32.57142857142857 | 0.8421052631578947 | 0.2916666666666667 |
29517 | 29517 | LAC/Rancho Los Amigos National Rehabilitation Center | 50717 | 2021-02-12 | Los Angeles | 37 | Southern California | 4.571428571428571 | 0.5714285714285712 | 7.428571428571429 | 8.0 | 0.9285714285714286 | 0.6153846153846153 |
29519 | 29519 | Lakewood Regional Medical Center | 50581 | 2021-02-12 | Los Angeles | 37 | Southern California | 19.571428571428573 | 16.57142857142857 | 36.285714285714285 | 52.85714285714285 | 0.6864864864864865 | 0.5393700787401575 |
29524 | 29524 | Los Angeles Community Hospital | 50663 | 2021-02-12 | Los Angeles | 37 | Southern California | 5.857142857142857 | 6.571428571428571 | 10.571428571428571 | 17.142857142857142 | 0.6166666666666667 | 0.5540540540540541 |
29533 | 29533 | Martin Luther King, Jr. Community Hospital | 50779 | 2021-02-12 | Los Angeles | 37 | Southern California | 19.142857142857142 | 0.0 | 23.571428571428573 | 23.571428571428573 | 1.0 | 0.812121212121212 |
29535 | 29535 | Memorial Hospital of Gardena | 50468 | 2021-02-12 | Los Angeles | 37 | Southern California | 14.714285714285714 | 0.0 | 15.285714285714286 | 15.285714285714286 | 1.0 | 0.9626168224299064 |
29537 | 29537 | Memorialcare Long Beach Medical Center | 50485 | 2021-02-12 | Los Angeles | 37 | Southern California | 50.57142857142857 | 10.142857142857151 | 88.14285714285714 | 98.28571428571428 | 0.8968023255813953 | 0.573743922204214 |
29550 | 29550 | Mission Community Hospital | 50704 | 2021-02-12 | Los Angeles | 37 | Southern California | 10.571428571428571 | 15.428571428571429 | 10.571428571428571 | 26.0 | 0.4065934065934066 | 1.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 );