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.
306 rows where "week" is on date 2020-11-13 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
33370 | 33370 | Alameda Hospital | 50211 | 2020-11-13 | Alameda | 1 | Bay Area | 1.0 | 3.8571428571428568 | 4.142857142857143 | 8.0 | 0.5178571428571429 | 0.2413793103448275 |
33372 | 33372 | Alta Bates Summit Medical Center | 50043 | 2020-11-13 | Alameda | 1 | Bay Area | 2.142857142857143 | 15.714285714285715 | 20.285714285714285 | 36.0 | 0.5634920634920635 | 0.1056338028169014 |
33373 | 33373 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305 | 2020-11-13 | Alameda | 1 | Bay Area | 0.8571428571428571 | 20.714285714285715 | 9.285714285714286 | 30.0 | 0.3095238095238095 | 0.0923076923076923 |
33414 | 33414 | Eden Medical Center | 50488 | 2020-11-13 | Alameda | 1 | Bay Area | 2.571428571428572 | 3.2857142857142847 | 20.714285714285715 | 24.0 | 0.8630952380952381 | 0.1241379310344827 |
33442 | 33442 | Highland Hospital | 50320 | 2020-11-13 | Alameda | 1 | Bay Area | 1.5714285714285714 | 14.285714285714285 | 18.714285714285715 | 33.0 | 0.5670995670995671 | 0.0839694656488549 |
33455 | 33455 | Kaiser Foundation Hospital - Fremont | 50512 | 2020-11-13 | Alameda | 1 | Bay Area | 3.857142857142857 | 1.0 | 6.571428571428571 | 7.571428571428571 | 0.8679245283018868 | 0.5869565217391305 |
33458 | 33458 | Kaiser Foundation Hospital - Oakland/richmond | 50075 | 2020-11-13 | Alameda | 1 | Bay Area | 4.0 | 1.5714285714285712 | 15.714285714285714 | 17.285714285714285 | 0.9090909090909092 | 0.2545454545454546 |
33465 | 33465 | Kaiser Foundation Hospital - San Leandro | 50777 | 2020-11-13 | Alameda | 1 | Bay Area | 4.857142857142857 | 1.1428571428571423 | 12.428571428571429 | 13.571428571428571 | 0.9157894736842106 | 0.3908045977011494 |
33488 | 33488 | Kindred Hospital - San Francisco Bay Area | 52034 | 2020-11-13 | Alameda | 1 | Bay Area | 0.0 | 0.2857142857142865 | 8.714285714285714 | 9.0 | 0.968253968253968 | 0.0 |
33621 | 33621 | St. Rose Hospital | 50002 | 2020-11-13 | Alameda | 1 | Bay Area | 2.142857142857143 | 5.857142857142858 | 9.142857142857142 | 15.0 | 0.6095238095238095 | 0.234375 |
33623 | 33623 | Stanford Health Care - Valleycare | 50283 | 2020-11-13 | Alameda | 1 | Bay Area | 0.5714285714285714 | 7.857142857142858 | 14.142857142857142 | 22.0 | 0.6428571428571428 | 0.0404040404040404 |
33652 | 33652 | Washington Hospital | 50195 | 2020-11-13 | Alameda | 1 | Bay Area | 2.857142857142857 | 13.0 | 17.857142857142858 | 30.857142857142858 | 0.5787037037037037 | 0.16 |
33624 | 33624 | Sutter Amador Hospital | 50014 | 2020-11-13 | Amador | 5 | Greater Sacramento | 0.0 | 5.0 | 1.0 | 6.0 | 0.1666666666666666 | 0.0 |
33422 | 33422 | Enloe Medical Center | 50039 | 2020-11-13 | Butte | 7 | Greater Sacramento | 1.1428571428571428 | 10.0 | 14.0 | 24.0 | 0.5833333333333334 | 0.0816326530612244 |
33549 | 33549 | Orchard Hospital | 51311 | 2020-11-13 | Butte | 7 | Greater Sacramento | 0.0 | 1.7142857142857144 | 2.2857142857142856 | 4.0 | 0.5714285714285714 | 0.0 |
33550 | 33550 | Oroville Hospital | 50030 | 2020-11-13 | Butte | 7 | Greater Sacramento | 0.5714285714285714 | 1.1428571428571423 | 8.857142857142858 | 10.0 | 0.8857142857142858 | 0.064516129032258 |
33517 | 33517 | Mark Twain Medical Center | 51332 | 2020-11-13 | Calaveras | 9 | San Joaquin Valley | 1.4285714285714286 | 8.571428571428571 | 3.4285714285714284 | 12.0 | 0.2857142857142857 | 0.4166666666666667 |
33404 | 33404 | Contra Costa Regional Medical Center | 50276 | 2020-11-13 | Contra Costa | 13 | Bay Area | 3.4285714285714284 | 3.7142857142857135 | 14.285714285714286 | 18.0 | 0.7936507936507937 | 0.2399999999999999 |
33448 | 33448 | John Muir Medical Center - Concord Campus | 50496 | 2020-11-13 | Contra Costa | 13 | Bay Area | 4.428571428571429 | 5.571428571428573 | 30.428571428571427 | 36.0 | 0.8452380952380952 | 0.1455399061032864 |
33449 | 33449 | John Muir Medical Center - Walnut Creek Campus | 50180 | 2020-11-13 | Contra Costa | 13 | Bay Area | 6.714285714285714 | 14.285714285714285 | 42.71428571428572 | 57.0 | 0.7493734335839599 | 0.157190635451505 |
33452 | 33452 | Kaiser Foundation Hospital - Antioch | 50760 | 2020-11-13 | Contra Costa | 13 | Bay Area | 2.7142857142857144 | 0.7142857142857144 | 5.285714285714286 | 6.0 | 0.8809523809523809 | 0.5135135135135136 |
33469 | 33469 | Kaiser Foundation Hospital - Walnut Creek | 50072 | 2020-11-13 | Contra Costa | 13 | Bay Area | 2.4285714285714284 | 1.142857142857144 | 12.714285714285714 | 13.857142857142858 | 0.9175257731958762 | 0.1910112359550561 |
33592 | 33592 | San Ramon Regional Medical Center | 50689 | 2020-11-13 | Contra Costa | 13 | Bay Area | 1.2857142857142858 | 3.0 | 9.0 | 12.0 | 0.75 | 0.1428571428571428 |
33628 | 33628 | Sutter Delta Medical Center | 50523 | 2020-11-13 | Contra Costa | 13 | Bay Area | 1.8571428571428568 | 2.0 | 10.0 | 12.0 | 0.8333333333333334 | 0.1857142857142857 |
33626 | 33626 | Sutter Coast Hospital | 50417 | 2020-11-13 | Del Norte | 15 | Northern California | 0.0 | 1.8571428571428568 | 4.142857142857143 | 6.0 | 0.6904761904761906 | 0.0 |
33382 | 33382 | Barton Memorial Hospital | 50352 | 2020-11-13 | El Dorado | 17 | Greater Sacramento | 4.428571428571429 | 2.8571428571428568 | 5.142857142857143 | 8.0 | 0.6428571428571429 | 0.861111111111111 |
33518 | 33518 | Marshall Medical Center | 50254 | 2020-11-13 | El Dorado | 17 | Greater Sacramento | 0.0 | 3.571428571428571 | 7.0 | 10.571428571428571 | 0.6621621621621622 | 0.0 |
33396 | 33396 | Clovis Community Medical Center | 50492 | 2020-11-13 | Fresno | 19 | San Joaquin Valley | 7.285714285714286 | 4.142857142857142 | 22.142857142857142 | 26.285714285714285 | 0.842391304347826 | 0.3290322580645161 |
33403 | 33403 | Community Regional Medical Center | 50060 | 2020-11-13 | Fresno | 19 | San Joaquin Valley | 14.285714285714286 | 3.7142857142857215 | 71.14285714285714 | 74.85714285714286 | 0.9503816793893128 | 0.2008032128514056 |
33427 | 33427 | Fresno Heart and Surgical Hospital | 50732 | 2020-11-13 | Fresno | 19 | San Joaquin Valley | 0.0 | 1.2857142857142856 | 7.714285714285714 | 9.0 | 0.8571428571428572 | 0.0 |
33456 | 33456 | Kaiser Foundation Hospital - Fresno | 50710 | 2020-11-13 | Fresno | 19 | San Joaquin Valley | 2.7142857142857144 | 1.0 | 6.714285714285714 | 7.714285714285714 | 0.8703703703703703 | 0.4042553191489362 |
33581 | 33581 | Saint Agnes Medical Center | 50093 | 2020-11-13 | Fresno | 19 | San Joaquin Valley | 9.142857142857142 | 1.2857142857142885 | 28.428571428571427 | 29.714285714285715 | 0.9567307692307692 | 0.321608040201005 |
33511 | 33511 | Mad River Community Hospital | 50028 | 2020-11-13 | Humboldt | 23 | Northern California | 0.0 | 1.5000000000000004 | 2.6666666666666665 | 4.166666666666667 | 0.6399999999999999 | 0.0 |
33569 | 33569 | Providence Redwood Memorial Hospital | 51318 | 2020-11-13 | Humboldt | 23 | Northern California | 0.0 | 1.0 | 3.0 | 4.0 | 0.75 | 0.0 |
33572 | 33572 | Providence St. Joseph Hospital | 50006 | 2020-11-13 | Humboldt | 23 | Northern California | 1.4285714285714286 | 0.5714285714285712 | 11.428571428571429 | 12.0 | 0.9523809523809524 | 0.125 |
33417 | 33417 | El Centro Regional Medical Center | 50045 | 2020-11-13 | Imperial | 25 | Southern California | 13.857142857142858 | 1.428571428571427 | 16.571428571428573 | 18.0 | 0.9206349206349208 | 0.8362068965517241 |
33560 | 33560 | Pioneers Memorial Healthcare District | 50342 | 2020-11-13 | Imperial | 25 | Southern California | 5.0 | 0.0 | 8.0 | 8.0 | 1.0 | 0.625 |
33542 | 33542 | Northern Inyo Hospital | 51324 | 2020-11-13 | Inyo | 27 | Southern California | 0.0 | 3.142857142857143 | 0.8571428571428571 | 4.0 | 0.2142857142857142 | 0.0 |
33354 | 33354 | Adventist Health Bakersfield | 50455 | 2020-11-13 | Kern | 29 | San Joaquin Valley | 7.0 | 14.0 | 22.0 | 36.0 | 0.6111111111111112 | 0.3181818181818182 |
33356 | 33356 | Adventist Health Delano | 50608 | 2020-11-13 | Kern | 29 | San Joaquin Valley | 1.5714285714285714 | 5.428571428571429 | 3.571428571428572 | 9.0 | 0.3968253968253968 | 0.4399999999999999 |
33364 | 33364 | Adventist Health Tehachapi Valley | 51301 | 2020-11-13 | Kern | 29 | San Joaquin Valley | 0.0 | 3.142857142857143 | 0.8571428571428571 | 4.0 | 0.2142857142857142 | 0.0 |
33378 | 33378 | Bakersfield Heart Hospital | 50724 | 2020-11-13 | Kern | 29 | San Joaquin Valley | 0.0 | 1.8571428571428577 | 8.142857142857142 | 10.0 | 0.8142857142857143 | 0.0 |
33379 | 33379 | Bakersfield Memorial Hospital | 50036 | 2020-11-13 | Kern | 29 | San Joaquin Valley | 3.571428571428572 | 2.0 | 24.571428571428573 | 26.571428571428573 | 0.9247311827956988 | 0.1453488372093023 |
33433 | 33433 | Good Samaritan Hospital | 50257 | 2020-11-13 | Kern | 29 | San Joaquin Valley | 0.0 | 4.0 | 0.0 | 4.0 | 0.0 | |
33484 | 33484 | Kern Medical Center | 50315 | 2020-11-13 | Kern | 29 | San Joaquin Valley | 3.0 | 0.0 | 21.714285714285715 | 21.714285714285715 | 1.0 | 0.1381578947368421 |
33485 | 33485 | Kern Valley Healthcare District | 51314 | 2020-11-13 | Kern | 29 | San Joaquin Valley | 0.0 | 2.142857142857143 | 0.0 | 2.142857142857143 | 0.0 | |
33528 | 33528 | Mercy Hospital | 50295 | 2020-11-13 | Kern | 29 | San Joaquin Valley | 1.8571428571428568 | 13.0 | 15.0 | 28.0 | 0.5357142857142857 | 0.1238095238095238 |
33577 | 33577 | Ridgecrest Regional Hospital | 51333 | 2020-11-13 | Kern | 29 | San Joaquin Valley | 1.0 | 0.4285714285714284 | 3.571428571428572 | 4.0 | 0.8928571428571429 | 0.2799999999999999 |
33357 | 33357 | Adventist Health Hanford | 50121 | 2020-11-13 | Kings | 31 | San Joaquin Valley | 4.285714285714286 | 14.142857142857142 | 13.857142857142858 | 28.0 | 0.4948979591836734 | 0.3092783505154639 |
33355 | 33355 | Adventist Health Clearlake | 51317 | 2020-11-13 | Lake | 33 | Northern California | 0.0 | 0.1428571428571428 | 3.857142857142857 | 4.0 | 0.9642857142857144 | 0.0 |
33629 | 33629 | Sutter Lakeside Hospital | 51329 | 2020-11-13 | Lake | 33 | Northern California | 1.7142857142857142 | 1.5714285714285716 | 3.4285714285714284 | 5.0 | 0.6857142857142857 | 0.5 |
33371 | 33371 | Alhambra Hospital Medical Center | 50281 | 2020-11-13 | Los Angeles | 37 | Southern California | 3.7142857142857135 | 1.7142857142857135 | 7.428571428571429 | 9.142857142857142 | 0.8125000000000001 | 0.5 |
33376 | 33376 | Antelope Valley Hospital | 50056 | 2020-11-13 | Los Angeles | 37 | Southern California | 6.428571428571429 | 1.1428571428571388 | 41.71428571428572 | 42.85714285714285 | 0.9733333333333334 | 0.1541095890410959 |
33380 | 33380 | Barlow Respiratory Hospital | 52031 | 2020-11-13 | Los Angeles | 37 | Southern California | 0.0 | 3.857142857142857 | 2.142857142857143 | 6.0 | 0.3571428571428571 | 0.0 |
33383 | 33383 | Beverly Hospital | 50350 | 2020-11-13 | Los Angeles | 37 | Southern California | 6.428571428571429 | 10.428571428571429 | 14.571428571428571 | 25.0 | 0.5828571428571429 | 0.4411764705882353 |
33384 | 33384 | California Hospital Medical Center LA | 50149 | 2020-11-13 | Los Angeles | 37 | Southern California | 6.285714285714286 | 6.857142857142858 | 23.142857142857142 | 30.0 | 0.7714285714285715 | 0.2716049382716049 |
33388 | 33388 | Casa Colina Hospital | 50782 | 2020-11-13 | Los Angeles | 37 | Southern California | 0.0 | 2.7142857142857144 | 3.2857142857142856 | 6.0 | 0.5476190476190476 | 0.0 |
33389 | 33389 | Cedars-Sinai Marina Del Rey Hospital | 50740 | 2020-11-13 | Los Angeles | 37 | Southern California | 1.1428571428571428 | 9.857142857142858 | 6.142857142857143 | 16.0 | 0.3839285714285714 | 0.1860465116279069 |
33390 | 33390 | Cedars-Sinai Medical Center | 50625 | 2020-11-13 | Los Angeles | 37 | Southern California | 13.428571428571429 | 9.42857142857143 | 98.57142857142856 | 108.0 | 0.9126984126984128 | 0.136231884057971 |
33391 | 33391 | Centinela Hospital Medical Center | 50739 | 2020-11-13 | Los Angeles | 37 | Southern California | 6.857142857142857 | 2.5714285714285694 | 27.857142857142858 | 30.428571428571427 | 0.915492957746479 | 0.2461538461538461 |
33395 | 33395 | City of Hope Helford Clinical Research Hospital | 50146 | 2020-11-13 | Los Angeles | 37 | Southern California | 1.1428571428571428 | 4.142857142857142 | 13.857142857142858 | 18.0 | 0.7698412698412699 | 0.0824742268041237 |
33397 | 33397 | Coast Plaza Hospital | 50771 | 2020-11-13 | Los Angeles | 37 | Southern California | 1.2857142857142858 | 0.0 | 7.0 | 7.0 | 1.0 | 0.1836734693877551 |
33398 | 33398 | College Medical Center | 50776 | 2020-11-13 | Los Angeles | 37 | Southern California | 0.7142857142857143 | 6.142857142857142 | 1.8571428571428568 | 8.0 | 0.2321428571428571 | 0.3846153846153846 |
33399 | 33399 | Community Hospital of Huntington Park | 50091 | 2020-11-13 | Los Angeles | 37 | Southern California | 2.0 | 0.1428571428571423 | 6.428571428571429 | 6.571428571428571 | 0.9782608695652176 | 0.3111111111111111 |
33413 | 33413 | East Los Angeles Doctors Hospital | 50641 | 2020-11-13 | Los Angeles | 37 | Southern California | 2.8 | 3.2 | 6.8 | 10.0 | 0.6799999999999999 | 0.4117647058823529 |
33418 | 33418 | Emanate Health Foothill Presbyterian Hospital | 50597 | 2020-11-13 | Los Angeles | 37 | Southern California | 2.7142857142857144 | 4.571428571428571 | 13.428571428571429 | 18.0 | 0.746031746031746 | 0.2021276595744681 |
33419 | 33419 | Emanate Health Inter-community Hospital | 50382 | 2020-11-13 | Los Angeles | 37 | Southern California | 6.0 | 10.571428571428571 | 29.428571428571427 | 40.0 | 0.7357142857142857 | 0.2038834951456311 |
33421 | 33421 | Encino Hospital Medical Center | 50158 | 2020-11-13 | Los Angeles | 37 | Southern California | 1.1428571428571428 | 1.5714285714285716 | 2.4285714285714284 | 4.0 | 0.6071428571428571 | 0.4705882352941176 |
33429 | 33429 | Garfield Medical Center | 50737 | 2020-11-13 | Los Angeles | 37 | Southern California | 2.2857142857142856 | 2.7142857142857157 | 19.285714285714285 | 22.0 | 0.8766233766233765 | 0.1185185185185185 |
33430 | 33430 | Glendale Adventist Medical Center | 50239 | 2020-11-13 | Los Angeles | 37 | Southern California | 7.571428571428571 | 30.428571428571427 | 21.571428571428573 | 52.0 | 0.4148351648351648 | 0.3509933774834436 |
33431 | 33431 | Glendale Mem Hospital & Health Center | 50058 | 2020-11-13 | Los Angeles | 37 | Southern California | 2.2857142857142856 | 9.142857142857142 | 8.857142857142858 | 18.0 | 0.4920634920634921 | 0.2580645161290322 |
33435 | 33435 | Greater El Monte Community Hospital | 50738 | 2020-11-13 | Los Angeles | 37 | Southern California | 3.142857142857143 | 4.142857142857142 | 6.571428571428571 | 10.714285714285714 | 0.6133333333333334 | 0.4782608695652174 |
33440 | 33440 | Henry Mayo Newhall Hospital | 50624 | 2020-11-13 | Los Angeles | 37 | Southern California | 6.285714285714286 | 28.714285714285715 | 16.285714285714285 | 45.0 | 0.3619047619047619 | 0.3859649122807018 |
33444 | 33444 | Hollywood Presbyterian Medical Center | 50063 | 2020-11-13 | Los Angeles | 37 | Southern California | 4.428571428571429 | 18.142857142857142 | 15.857142857142858 | 34.0 | 0.4663865546218487 | 0.2792792792792793 |
33446 | 33446 | Huntington Hospital | 50438 | 2020-11-13 | Los Angeles | 37 | Southern California | 6.428571428571429 | 11.142857142857142 | 26.857142857142858 | 38.0 | 0.706766917293233 | 0.2393617021276596 |
33453 | 33453 | Kaiser Foundation Hospital - Baldwin Park | 50723 | 2020-11-13 | Los Angeles | 37 | Southern California | 9.714285714285714 | 37.71428571428571 | 23.571428571428573 | 61.285714285714285 | 0.3846153846153846 | 0.412121212121212 |
33454 | 33454 | Kaiser Foundation Hospital - Downey | 50139 | 2020-11-13 | Los Angeles | 37 | Southern California | 13.714285714285714 | 3.8571428571428577 | 25.714285714285715 | 29.571428571428573 | 0.8695652173913043 | 0.5333333333333333 |
33457 | 33457 | Kaiser Foundation Hospital - Los Angeles | 50138 | 2020-11-13 | Los Angeles | 37 | Southern California | 8.714285714285714 | 12.57142857142857 | 75.42857142857143 | 88.0 | 0.8571428571428572 | 0.115530303030303 |
33460 | 33460 | Kaiser Foundation Hospital - Panorama City | 50137 | 2020-11-13 | Los Angeles | 37 | Southern California | 6.714285714285714 | 2.0 | 17.0 | 19.0 | 0.8947368421052632 | 0.3949579831932773 |
33466 | 33466 | Kaiser Foundation Hospital - South Bay | 50411 | 2020-11-13 | Los Angeles | 37 | Southern California | 6.0 | 7.428571428571429 | 12.714285714285714 | 20.142857142857142 | 0.6312056737588653 | 0.4719101123595506 |
33470 | 33470 | Kaiser Foundation Hospital - West LA | 50561 | 2020-11-13 | Los Angeles | 37 | Southern California | 8.428571428571429 | 11.428571428571429 | 19.571428571428573 | 31.0 | 0.631336405529954 | 0.4306569343065693 |
33471 | 33471 | Kaiser Foundation Hospital - Woodland Hills | 50677 | 2020-11-13 | Los Angeles | 37 | Southern California | 3.142857142857143 | 6.857142857142858 | 15.0 | 21.857142857142858 | 0.6862745098039216 | 0.2095238095238095 |
33483 | 33483 | Keck Hospital of USC | 50696 | 2020-11-13 | Los Angeles | 37 | Southern California | 4.142857142857143 | 4.285714285714278 | 72.85714285714286 | 77.14285714285714 | 0.9444444444444444 | 0.0568627450980392 |
33486 | 33486 | Kindred Hospital - Los Angeles | 52032 | 2020-11-13 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 5.0 | 5.0 | 1.0 | 0.0 |
33489 | 33489 | Kindred Hospital -- La Mirada | 52038 | 2020-11-13 | Los Angeles | 37 | Southern California | 0.0 | 2.571428571428573 | 16.428571428571427 | 19.0 | 0.8646616541353382 | 0.0 |
33490 | 33490 | Kindred Hospital Baldwin Park | 52045 | 2020-11-13 | Los Angeles | 37 | Southern California | 0.0 | 0.2857142857142856 | 7.714285714285714 | 8.0 | 0.9642857142857144 | 0.0 |
33493 | 33493 | Kindred Hospital Paramount | 52046 | 2020-11-13 | Los Angeles | 37 | Southern California | 0.0 | 0.2857142857142865 | 11.714285714285714 | 12.0 | 0.9761904761904762 | 0.0 |
33496 | 33496 | Kindred Hospital South Bay | 52050 | 2020-11-13 | Los Angeles | 37 | Southern California | 3.4285714285714284 | 2.7142857142857144 | 6.285714285714286 | 9.0 | 0.6984126984126984 | 0.5454545454545454 |
33498 | 33498 | LA Downtown Medical Center, LLC | 50763 | 2020-11-13 | Los Angeles | 37 | Southern California | 1.8571428571428568 | 2.714285714285713 | 9.285714285714286 | 12.0 | 0.7738095238095238 | 0.1999999999999999 |
33499 | 33499 | LAC+USC Medical Center | 50373 | 2020-11-13 | Los Angeles | 37 | Southern California | 17.714285714285715 | 17.285714285714292 | 87.71428571428571 | 105.0 | 0.8353741496598639 | 0.2019543973941368 |
33500 | 33500 | LAC/Harbor-UCLA Medical Center | 50376 | 2020-11-13 | Los Angeles | 37 | Southern California | 6.571428571428571 | 2.4285714285714306 | 33.0 | 35.42857142857143 | 0.9314516129032258 | 0.1991341991341991 |
33501 | 33501 | LAC/Olive View-UCLA Medical Center | 50040 | 2020-11-13 | Los Angeles | 37 | Southern California | 4.571428571428571 | 7.2857142857142865 | 10.714285714285714 | 18.0 | 0.5952380952380952 | 0.4266666666666667 |
33502 | 33502 | LAC/Rancho Los Amigos National Rehabilitation Center | 50717 | 2020-11-13 | Los Angeles | 37 | Southern California | 1.0 | 3.857142857142857 | 3.142857142857143 | 7.0 | 0.4489795918367347 | 0.3181818181818182 |
33504 | 33504 | Lakewood Regional Medical Center | 50581 | 2020-11-13 | Los Angeles | 37 | Southern California | 4.285714285714286 | 10.0 | 20.285714285714285 | 30.285714285714285 | 0.6698113207547169 | 0.2112676056338028 |
33509 | 33509 | Los Angeles Community Hospital | 50663 | 2020-11-13 | Los Angeles | 37 | Southern California | 3.0 | 10.428571428571429 | 11.571428571428571 | 22.0 | 0.525974025974026 | 0.2592592592592592 |
33519 | 33519 | Martin Luther King, Jr. Community Hospital | 50779 | 2020-11-13 | Los Angeles | 37 | Southern California | 6.857142857142857 | 4.571428571428571 | 15.428571428571429 | 20.0 | 0.7714285714285715 | 0.4444444444444444 |
33521 | 33521 | Memorial Hospital of Gardena | 50468 | 2020-11-13 | Los Angeles | 37 | Southern California | 1.2 | 0.0 | 10.0 | 10.0 | 1.0 | 0.12 |
33523 | 33523 | Memorialcare Long Beach Medical Center | 50485 | 2020-11-13 | Los Angeles | 37 | Southern California | 12.571428571428571 | 32.0 | 54.0 | 86.0 | 0.627906976744186 | 0.2328042328042328 |
33536 | 33536 | Mission Community Hospital | 50704 | 2020-11-13 | Los Angeles | 37 | Southern California | 5.285714285714286 | 1.4285714285714288 | 8.571428571428571 | 10.0 | 0.8571428571428571 | 0.6166666666666667 |
33537 | 33537 | Monrovia Memorial Hospital | 52054 | 2020-11-13 | 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 );