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
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, week (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
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 |
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 |
29987 | 29987 | Adventist Health Howard Memorial | 51310 | 2021-01-29 | Mendocino | 45 | Northern California | 0.0 | 3.2857142857142856 | 3.7142857142857135 | 7.0 | 0.5306122448979592 | 0.0 |
29988 | 29988 | Adventist Health Lodi Memorial | 50336 | 2021-01-29 | San Joaquin | 77 | San Joaquin Valley | 3.142857142857143 | 1.5714285714285712 | 13.857142857142858 | 15.428571428571429 | 0.8981481481481481 | 0.2268041237113402 |
29989 | 29989 | Adventist Health Mendocino Coast | 51325 | 2021-01-29 | Mendocino | 45 | Northern California | 0.0 | 3.142857142857143 | 0.8571428571428571 | 4.0 | 0.2142857142857142 | 0.0 |
29990 | 29990 | Adventist Health Simi Valley | 50236 | 2021-01-29 | Ventura | 111 | Southern California | 13.142857142857142 | 5.857142857142858 | 18.428571428571427 | 24.285714285714285 | 0.7588235294117647 | 0.7131782945736435 |
29991 | 29991 | Adventist Health Sonora | 50335 | 2021-01-29 | Tuolumne | 109 | San Joaquin Valley | 1.0 | 0.8571428571428568 | 5.142857142857143 | 6.0 | 0.8571428571428572 | 0.1944444444444444 |
29992 | 29992 | Adventist Health St. Helena | 50013 | 2021-01-29 | Napa | 55 | Bay Area | 0.5714285714285714 | 0.8571428571428577 | 11.428571428571429 | 12.285714285714286 | 0.9302325581395348 | 0.0499999999999999 |
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 |
29994 | 29994 | Adventist Health Tulare | 50784 | 2021-01-29 | Tulare | 107 | San Joaquin Valley | 0.7142857142857143 | 1.4285714285714284 | 2.571428571428572 | 4.0 | 0.6428571428571429 | 0.2777777777777778 |
29995 | 29995 | Adventist Health Ukiah Valley | 50301 | 2021-01-29 | Mendocino | 45 | Northern California | 1.5714285714285714 | 0.8571428571428568 | 5.142857142857143 | 6.0 | 0.8571428571428572 | 0.3055555555555555 |
29996 | 29996 | Adventist Health and Rideout | 50133 | 2021-01-29 | Yuba | 115 | Greater Sacramento | 11.571428571428571 | 2.2857142857142847 | 24.857142857142858 | 27.142857142857142 | 0.9157894736842106 | 0.4655172413793103 |
29997 | 29997 | Ahmc Anaheim Regional Medical Center | 50226 | 2021-01-29 | Orange | 59 | Southern California | 19.142857142857142 | 0.2857142857142847 | 24.571428571428573 | 24.857142857142858 | 0.9885057471264368 | 0.7790697674418604 |
29998 | 29998 | Ahmc Seton Medical Center | 50289 | 2021-01-29 | San Mateo | 81 | Bay Area | 4.142857142857143 | 1.1428571428571423 | 7.428571428571429 | 8.571428571428571 | 0.8666666666666667 | 0.5576923076923077 |
29999 | 29999 | Alameda Hospital | 50211 | 2021-01-29 | Alameda | 1 | Bay Area | 1.7142857142857142 | 2.7142857142857144 | 5.285714285714286 | 8.0 | 0.6607142857142857 | 0.3243243243243243 |
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 |
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 |
30003 | 30003 | Alvarado Hospital Medical Center | 50757 | 2021-01-29 | San Diego | 73 | Southern California | 7.571428571428571 | 4.428571428571429 | 14.714285714285714 | 19.142857142857142 | 0.7686567164179104 | 0.5145631067961165 |
30004 | 30004 | Anaheim Global Medical Center | 50744 | 2021-01-29 | Orange | 59 | Southern California | 7.142857142857143 | 12.571428571428571 | 9.428571428571429 | 22.0 | 0.4285714285714286 | 0.7575757575757576 |
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 |
30006 | 30006 | Arrowhead Regional Medical Center | 50245 | 2021-01-29 | San Bernardino | 71 | Southern California | 11.571428571428571 | 2.857142857142854 | 46.0 | 48.85714285714285 | 0.9415204678362572 | 0.2515527950310559 |
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 |
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 |
30010 | 30010 | Barstow Community Hospital | 50298 | 2021-01-29 | San Bernardino | 71 | Southern California | 11.857142857142858 | 0.0 | 13.714285714285714 | 13.714285714285714 | 1.0 | 0.8645833333333334 |
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 |
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 |
30014 | 30014 | California Pacific Medical Center - Mission Bernal | 50055 | 2021-01-29 | San Francisco | 75 | Bay Area | 2.857142857142857 | 3.571428571428571 | 6.428571428571429 | 10.0 | 0.6428571428571429 | 0.4444444444444444 |
30015 | 30015 | California Pacific Medical Center- Van Ness Campus | 50047 | 2021-01-29 | San Francisco | 75 | Bay Area | 4.571428571428571 | 6.428571428571427 | 29.571428571428573 | 36.0 | 0.8214285714285715 | 0.1545893719806763 |
30016 | 30016 | California Pacific Medical Ctr-davies Campus Hosp | 50008 | 2021-01-29 | San Francisco | 75 | Bay Area | 0.0 | 2.428571428571429 | 5.571428571428571 | 8.0 | 0.6964285714285714 | 0.0 |
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 |
30020 | 30020 | Chapman Global Medical Center | 50745 | 2021-01-29 | Orange | 59 | Southern California | 7.0 | 5.0 | 7.0 | 12.0 | 0.5833333333333334 | 1.0 |
30021 | 30021 | Chinese Hospital | 50407 | 2021-01-29 | San Francisco | 75 | Bay Area | 1.8571428571428568 | 1.7142857142857144 | 4.285714285714286 | 6.0 | 0.7142857142857143 | 0.4333333333333333 |
30022 | 30022 | Chino Valley Medical Center | 50586 | 2021-01-29 | San Bernardino | 71 | Southern California | 15.428571428571429 | 0.8571428571428577 | 16.285714285714285 | 17.142857142857142 | 0.95 | 0.9473684210526316 |
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 |
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 |
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 |
30027 | 30027 | Colusa Medical Center | 50783 | 2021-01-29 | Colusa | 11 | Greater Sacramento | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
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 |
30029 | 30029 | Community Hospital of San Bernardino | 50089 | 2021-01-29 | San Bernardino | 71 | Southern California | 12.571428571428571 | 4.142857142857142 | 16.857142857142858 | 21.0 | 0.8027210884353742 | 0.7457627118644068 |
30030 | 30030 | Community Hospital of the Monterey Peninsula | 50145 | 2021-01-29 | Monterey | 53 | Bay Area | 7.714285714285714 | 8.857142857142858 | 17.142857142857142 | 26.0 | 0.6593406593406593 | 0.45 |
30031 | 30031 | Community Memorial Hospital San Buenaventura | 50394 | 2021-01-29 | Ventura | 111 | Southern California | 18.142857142857142 | 2.0 | 24.428571428571427 | 26.428571428571427 | 0.9243243243243244 | 0.7426900584795322 |
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 |
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 |
30034 | 30034 | Corona Regional Medical Center | 50329 | 2021-01-29 | Riverside | 65 | Southern California | 23.714285714285715 | 3.714285714285712 | 28.571428571428573 | 32.285714285714285 | 0.8849557522123894 | 0.83 |
30035 | 30035 | Dameron Hospital | 50122 | 2021-01-29 | San Joaquin | 77 | San Joaquin Valley | 5.714285714285714 | 1.2857142857142865 | 10.714285714285714 | 12.0 | 0.8928571428571428 | 0.5333333333333334 |
30036 | 30036 | Desert Regional Medical Center | 50243 | 2021-01-29 | Riverside | 65 | Southern California | 20.714285714285715 | 0.4285714285714306 | 47.285714285714285 | 47.71428571428572 | 0.9910179640718564 | 0.4380664652567976 |
30037 | 30037 | Desert Valley Hospital | 50709 | 2021-01-29 | San Bernardino | 71 | Southern California | 20.571428571428573 | 0.1428571428571423 | 24.857142857142858 | 25.0 | 0.9942857142857144 | 0.8275862068965518 |
30038 | 30038 | Doctors Hospital of Manteca | 50118 | 2021-01-29 | San Joaquin | 77 | San Joaquin Valley | 5.571428571428571 | 1.5714285714285712 | 6.428571428571429 | 8.0 | 0.8035714285714286 | 0.8666666666666666 |
30039 | 30039 | Doctors Hospital of Riverside, LLC | 50102 | 2021-01-29 | Riverside | 65 | Southern California | 12.142857142857142 | 0.0 | 16.857142857142858 | 16.857142857142858 | 1.0 | 0.7203389830508474 |
30040 | 30040 | Doctors Medical Center | 50464 | 2021-01-29 | Stanislaus | 99 | San Joaquin Valley | 18.571428571428573 | 4.0 | 40.0 | 44.0 | 0.9090909090909092 | 0.4642857142857143 |
30041 | 30041 | Dominican Hospital | 50242 | 2021-01-29 | Santa Cruz | 87 | Bay Area | 7.142857142857143 | 0.3333333333333357 | 16.833333333333332 | 17.166666666666668 | 0.9805825242718446 | 0.4243281471004244 |
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 |
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 |
30044 | 30044 | Eisenhower Medical Center | 50573 | 2021-01-29 | Riverside | 65 | Southern California | 17.857142857142858 | 5.142857142857142 | 29.142857142857142 | 34.285714285714285 | 0.85 | 0.6127450980392157 |
30045 | 30045 | El Camino Hospital | 50308 | 2021-01-29 | Santa Clara | 85 | Bay Area | 7.714285714285714 | 11.285714285714285 | 20.714285714285715 | 32.0 | 0.6473214285714286 | 0.3724137931034482 |
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 |
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 |
30049 | 30049 | Emanuel Medical Center | 50179 | 2021-01-29 | Stanislaus | 99 | San Joaquin Valley | 5.0 | 2.0 | 10.0 | 12.0 | 0.8333333333333334 | 0.5 |
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 |
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 |
30052 | 30052 | Fairchild Medical Center | 51316 | 2021-01-29 | Siskiyou | 93 | Northern California | 0.0 | 0.8571428571428572 | 3.142857142857143 | 4.0 | 0.7857142857142857 | 0.0 |
30053 | 30053 | Foothill Regional Medical Center | 50780 | 2021-01-29 | Orange | 59 | Southern California | 5.857142857142857 | 4.428571428571429 | 8.571428571428571 | 13.0 | 0.6593406593406593 | 0.6833333333333333 |
30054 | 30054 | Fountain Valley Regional Hospital & Medical Center | 50570 | 2021-01-29 | Orange | 59 | Southern California | 26.0 | 0.0 | 39.142857142857146 | 39.142857142857146 | 1.0 | 0.6642335766423357 |
30055 | 30055 | French Hospital Medical Center | 50232 | 2021-01-29 | San Luis Obispo | 79 | Southern California | 3.142857142857143 | 0.7142857142857153 | 8.571428571428571 | 9.285714285714286 | 0.923076923076923 | 0.3666666666666667 |
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 |
30057 | 30057 | Garden Grove Hospital & Medical Center | 50230 | 2021-01-29 | Orange | 59 | Southern California | 12.285714285714286 | 0.5714285714285712 | 13.0 | 13.571428571428571 | 0.9578947368421052 | 0.9450549450549453 |
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 |
30061 | 30061 | Goleta Valley Cottage Hospital | 50357 | 2021-01-29 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.5714285714285714 | 0.5714285714285714 | 1.0 | 0.0 |
30062 | 30062 | Good Samaritan Hospital | 50257 | 2021-01-29 | Kern | 29 | San Joaquin Valley | 0.0 | 4.0 | 0.0 | 4.0 | 0.0 | |
30063 | 30063 | Good Samaritan Hospital | 50380 | 2021-01-29 | Santa Clara | 85 | Bay Area | 12.428571428571429 | 5.142857142857142 | 31.857142857142858 | 37.0 | 0.8610038610038611 | 0.3901345291479821 |
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 |
30065 | 30065 | Grossmont Hospital | 50026 | 2021-01-29 | San Diego | 73 | Southern California | 41.285714285714285 | 2.142857142857139 | 78.42857142857143 | 80.57142857142857 | 0.973404255319149 | 0.5264116575591985 |
30066 | 30066 | Hazel Hawkins Memorial Hospital | 51337 | 2021-01-29 | San Benito | 69 | San Joaquin Valley | 3.571428571428572 | 2.0 | 5.0 | 7.0 | 0.7142857142857143 | 0.7142857142857143 |
30067 | 30067 | Healdsburg Hospital | 51321 | 2021-01-29 | Sonoma | 97 | Bay Area | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
30068 | 30068 | Hemet Global Medical Center | 50390 | 2021-01-29 | Riverside | 65 | Southern California | 14.285714285714286 | 11.857142857142858 | 14.142857142857142 | 26.0 | 0.5439560439560439 | 1.0101010101010102 |
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 |
30070 | 30070 | Hi-desert Medical Center | 50279 | 2021-01-29 | San Bernardino | 71 | Southern California | 2.2857142857142856 | 1.4285714285714284 | 2.571428571428572 | 4.0 | 0.6428571428571429 | 0.8888888888888887 |
30071 | 30071 | Highland Hospital | 50320 | 2021-01-29 | Alameda | 1 | Bay Area | 10.285714285714286 | 7.714285714285715 | 25.285714285714285 | 33.0 | 0.7662337662337662 | 0.4067796610169492 |
30072 | 30072 | Hoag Memorial Hospital Presbyterian | 50224 | 2021-01-29 | Orange | 59 | Southern California | 35.57142857142857 | 11.714285714285715 | 53.142857142857146 | 64.85714285714286 | 0.8193832599118943 | 0.6693548387096774 |
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 |
30074 | 30074 | Huntington Beach Hospital | 50526 | 2021-01-29 | Orange | 59 | Southern California | 11.0 | 1.7142857142857153 | 15.0 | 16.714285714285715 | 0.8974358974358974 | 0.7333333333333333 |
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 |
30076 | 30076 | John F Kennedy Memorial Hospital | 50534 | 2021-01-29 | Riverside | 65 | Southern California | 9.285714285714286 | 7.285714285714285 | 16.714285714285715 | 24.0 | 0.6964285714285715 | 0.5555555555555556 |
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 |
30079 | 30079 | Kaiser Foundation Hosp So Sacramento | 50674 | 2021-01-29 | Sacramento | 67 | Greater Sacramento | 24.714285714285715 | 0.0 | 40.0 | 40.0 | 1.0 | 0.6178571428571429 |
30080 | 30080 | Kaiser Foundation Hospital | 50510 | 2021-01-29 | Marin | 41 | Bay Area | 3.142857142857143 | 1.0 | 6.0 | 7.0 | 0.8571428571428571 | 0.5238095238095238 |
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 |
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 |
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 );