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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
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 |
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 |
31826 | 31826 | Adventist Health Howard Memorial | 51310 | 2020-12-18 | Mendocino | 45 | Northern California | 1.1428571428571428 | 0.714285714285714 | 3.571428571428572 | 4.285714285714286 | 0.8333333333333334 | 0.3199999999999999 |
31827 | 31827 | Adventist Health Lodi Memorial | 50336 | 2020-12-18 | San Joaquin | 77 | San Joaquin Valley | 9.142857142857142 | 0.1428571428571441 | 15.714285714285714 | 15.857142857142858 | 0.9909909909909907 | 0.5818181818181818 |
31828 | 31828 | Adventist Health Mendocino Coast | 51325 | 2020-12-18 | Mendocino | 45 | Northern California | 0.5714285714285714 | 3.0 | 1.0 | 4.0 | 0.25 | 0.5714285714285714 |
31829 | 31829 | Adventist Health Simi Valley | 50236 | 2020-12-18 | Ventura | 111 | Southern California | 14.0 | 5.714285714285715 | 18.285714285714285 | 24.0 | 0.7619047619047619 | 0.765625 |
31830 | 31830 | Adventist Health Sonora | 50335 | 2020-12-18 | Tuolumne | 109 | San Joaquin Valley | 0.8571428571428571 | 3.0 | 3.0 | 6.0 | 0.5 | 0.2857142857142857 |
31831 | 31831 | Adventist Health St. Helena | 50013 | 2020-12-18 | Napa | 55 | Bay Area | 2.142857142857143 | 1.1428571428571423 | 8.0 | 9.142857142857142 | 0.875 | 0.2678571428571428 |
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 |
31833 | 31833 | Adventist Health Tulare | 50784 | 2020-12-18 | Tulare | 107 | San Joaquin Valley | 0.0 | 1.1428571428571428 | 2.857142857142857 | 4.0 | 0.7142857142857143 | 0.0 |
31834 | 31834 | Adventist Health Ukiah Valley | 50301 | 2020-12-18 | Mendocino | 45 | Northern California | 2.4285714285714284 | 0.8571428571428577 | 6.285714285714286 | 7.142857142857143 | 0.8799999999999999 | 0.3863636363636363 |
31835 | 31835 | Adventist Health and Rideout | 50133 | 2020-12-18 | Yuba | 115 | Greater Sacramento | 9.714285714285714 | 3.428571428571427 | 21.857142857142858 | 25.285714285714285 | 0.864406779661017 | 0.4444444444444444 |
31836 | 31836 | Ahmc Anaheim Regional Medical Center | 50226 | 2020-12-18 | Orange | 59 | Southern California | 13.714285714285714 | 0.0 | 20.285714285714285 | 20.285714285714285 | 1.0 | 0.676056338028169 |
31837 | 31837 | Ahmc Seton Medical Center | 50289 | 2020-12-18 | San Mateo | 81 | Bay Area | 3.7142857142857135 | 0.0 | 10.857142857142858 | 10.857142857142858 | 1.0 | 0.3421052631578947 |
31838 | 31838 | Alameda Hospital | 50211 | 2020-12-18 | Alameda | 1 | Bay Area | 2.857142857142857 | 3.571428571428571 | 4.428571428571429 | 8.0 | 0.5535714285714286 | 0.6451612903225806 |
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 |
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 |
31842 | 31842 | Alvarado Hospital Medical Center | 50757 | 2020-12-18 | San Diego | 73 | Southern California | 9.142857142857142 | 1.4285714285714288 | 12.857142857142858 | 14.285714285714286 | 0.9 | 0.711111111111111 |
31843 | 31843 | Anaheim Global Medical Center | 50744 | 2020-12-18 | Orange | 59 | Southern California | 13.285714285714286 | 6.428571428571429 | 15.571428571428571 | 22.0 | 0.7077922077922078 | 0.853211009174312 |
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 |
31845 | 31845 | Arrowhead Regional Medical Center | 50245 | 2020-12-18 | San Bernardino | 71 | Southern California | 32.0 | 0.0 | 48.0 | 48.0 | 1.0 | 0.6666666666666666 |
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 |
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 |
31849 | 31849 | Barstow Community Hospital | 50298 | 2020-12-18 | San Bernardino | 71 | Southern California | 12.428571428571429 | 0.0 | 12.0 | 12.0 | 1.0 | 1.0357142857142858 |
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 |
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 |
31853 | 31853 | California Pacific Medical Center - Mission Bernal | 50055 | 2020-12-18 | San Francisco | 75 | Bay Area | 7.571428571428571 | 0.7142857142857135 | 9.285714285714286 | 10.0 | 0.9285714285714286 | 0.8153846153846153 |
31854 | 31854 | California Pacific Medical Center- Van Ness Campus | 50047 | 2020-12-18 | San Francisco | 75 | Bay Area | 1.7142857142857142 | 10.0 | 26.0 | 36.0 | 0.7222222222222222 | 0.0659340659340659 |
31855 | 31855 | California Pacific Medical Ctr-davies Campus Hosp | 50008 | 2020-12-18 | San Francisco | 75 | Bay Area | 0.0 | 1.1428571428571432 | 6.857142857142857 | 8.0 | 0.8571428571428571 | 0.0 |
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 |
31859 | 31859 | Chapman Global Medical Center | 50745 | 2020-12-18 | Orange | 59 | Southern California | 4.857142857142857 | 5.0 | 7.0 | 12.0 | 0.5833333333333334 | 0.6938775510204082 |
31860 | 31860 | Chinese Hospital | 50407 | 2020-12-18 | San Francisco | 75 | Bay Area | 2.571428571428572 | 2.0 | 4.0 | 6.0 | 0.6666666666666666 | 0.6428571428571429 |
31861 | 31861 | Chino Valley Medical Center | 50586 | 2020-12-18 | San Bernardino | 71 | Southern California | 12.428571428571429 | 0.1428571428571423 | 13.571428571428571 | 13.714285714285714 | 0.9895833333333334 | 0.9157894736842106 |
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 |
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 |
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 |
31866 | 31866 | Colusa Medical Center | 50783 | 2020-12-18 | Colusa | 11 | Greater Sacramento | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
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 |
31868 | 31868 | Community Hospital of San Bernardino | 50089 | 2020-12-18 | San Bernardino | 71 | Southern California | 16.714285714285715 | 1.571428571428573 | 19.428571428571427 | 21.0 | 0.9251700680272108 | 0.860294117647059 |
31869 | 31869 | Community Hospital of the Monterey Peninsula | 50145 | 2020-12-18 | Monterey | 53 | Bay Area | 10.285714285714286 | 3.428571428571427 | 16.571428571428573 | 20.0 | 0.8285714285714286 | 0.6206896551724138 |
31870 | 31870 | Community Memorial Hospital San Buenaventura | 50394 | 2020-12-18 | Ventura | 111 | Southern California | 13.428571428571429 | 1.8571428571428577 | 24.142857142857142 | 26.0 | 0.9285714285714286 | 0.5562130177514794 |
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 |
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 |
31873 | 31873 | Corona Regional Medical Center | 50329 | 2020-12-18 | Riverside | 65 | Southern California | 26.0 | 1.7142857142857153 | 34.57142857142857 | 36.285714285714285 | 0.952755905511811 | 0.7520661157024794 |
31874 | 31874 | Dameron Hospital | 50122 | 2020-12-18 | San Joaquin | 77 | San Joaquin Valley | 10.142857142857142 | 0.5714285714285694 | 19.857142857142858 | 20.428571428571427 | 0.972027972027972 | 0.5107913669064748 |
31875 | 31875 | Desert Regional Medical Center | 50243 | 2020-12-18 | Riverside | 65 | Southern California | 16.0 | 2.0 | 32.714285714285715 | 34.714285714285715 | 0.9423868312757202 | 0.4890829694323144 |
31876 | 31876 | Desert Valley Hospital | 50709 | 2020-12-18 | San Bernardino | 71 | Southern California | 21.142857142857142 | 0.0 | 24.571428571428573 | 24.571428571428573 | 1.0 | 0.8604651162790697 |
31877 | 31877 | Doctors Hospital of Manteca | 50118 | 2020-12-18 | San Joaquin | 77 | San Joaquin Valley | 5.0 | 0.5714285714285712 | 7.428571428571429 | 8.0 | 0.9285714285714286 | 0.673076923076923 |
31878 | 31878 | Doctors Hospital of Riverside, LLC | 50102 | 2020-12-18 | Riverside | 65 | Southern California | 1.4285714285714286 | 7.7142857142857135 | 14.571428571428571 | 22.285714285714285 | 0.6538461538461539 | 0.0980392156862745 |
31879 | 31879 | Doctors Medical Center | 50464 | 2020-12-18 | Stanislaus | 99 | San Joaquin Valley | 16.428571428571427 | 4.857142857142854 | 39.142857142857146 | 44.0 | 0.8896103896103896 | 0.4197080291970802 |
31880 | 31880 | Dominican Hospital | 50242 | 2020-12-18 | Santa Cruz | 87 | Bay Area | 11.714285714285714 | 1.0 | 16.428571428571427 | 17.428571428571427 | 0.9426229508196722 | 0.7130434782608696 |
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 |
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 |
31883 | 31883 | Eisenhower Medical Center | 50573 | 2020-12-18 | Riverside | 65 | Southern California | 16.142857142857142 | 2.7142857142857157 | 27.428571428571427 | 30.142857142857142 | 0.909952606635071 | 0.5885416666666666 |
31884 | 31884 | El Camino Hospital | 50308 | 2020-12-18 | Santa Clara | 85 | Bay Area | 14.0 | 10.428571428571429 | 21.571428571428573 | 32.0 | 0.6741071428571429 | 0.6490066225165563 |
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 |
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 |
31888 | 31888 | Emanuel Medical Center | 50179 | 2020-12-18 | Stanislaus | 99 | San Joaquin Valley | 8.857142857142858 | 0.4285714285714288 | 11.571428571428571 | 12.0 | 0.9642857142857144 | 0.7654320987654322 |
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 |
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 |
31891 | 31891 | Fairchild Medical Center | 51316 | 2020-12-18 | Siskiyou | 93 | Northern California | 2.142857142857143 | 0.2857142857142856 | 3.7142857142857135 | 4.0 | 0.9285714285714286 | 0.5769230769230769 |
31892 | 31892 | Foothill Regional Medical Center | 50780 | 2020-12-18 | Orange | 59 | Southern California | 5.285714285714286 | 19.42857142857143 | 9.571428571428571 | 29.0 | 0.3300492610837438 | 0.5522388059701493 |
31893 | 31893 | Fountain Valley Regional Hospital & Medical Center | 50570 | 2020-12-18 | Orange | 59 | Southern California | 25.428571428571427 | 0.0 | 37.285714285714285 | 37.285714285714285 | 1.0 | 0.6819923371647509 |
31894 | 31894 | French Hospital Medical Center | 50232 | 2020-12-18 | San Luis Obispo | 79 | Southern California | 5.285714285714286 | 2.714285714285713 | 8.285714285714286 | 11.0 | 0.7532467532467533 | 0.6379310344827586 |
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 |
31896 | 31896 | Garden Grove Hospital & Medical Center | 50230 | 2020-12-18 | Orange | 59 | Southern California | 10.428571428571429 | 0.0 | 12.0 | 12.0 | 1.0 | 0.8690476190476191 |
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 |
31900 | 31900 | Goleta Valley Cottage Hospital | 50357 | 2020-12-18 | Santa Barbara | 83 | Southern California | 0.0 | 4.857142857142857 | 1.7142857142857142 | 6.571428571428571 | 0.2608695652173913 | 0.0 |
31901 | 31901 | Good Samaritan Hospital | 50257 | 2020-12-18 | Kern | 29 | San Joaquin Valley | 0.0 | 4.0 | 0.0 | 4.0 | 0.0 | |
31902 | 31902 | Good Samaritan Hospital | 50380 | 2020-12-18 | Santa Clara | 85 | Bay Area | 14.857142857142858 | 6.857142857142858 | 30.142857142857142 | 37.0 | 0.8146718146718147 | 0.4928909952606635 |
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 |
31904 | 31904 | Grossmont Hospital | 50026 | 2020-12-18 | San Diego | 73 | Southern California | 40.285714285714285 | 11.57142857142857 | 63.42857142857143 | 75.0 | 0.8457142857142858 | 0.6351351351351351 |
31905 | 31905 | Hazel Hawkins Memorial Hospital | 51337 | 2020-12-18 | San Benito | 69 | San Joaquin Valley | 3.2857142857142856 | 0.0 | 4.0 | 4.0 | 1.0 | 0.8214285714285714 |
31906 | 31906 | Healdsburg Hospital | 51321 | 2020-12-18 | Sonoma | 97 | Bay Area | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
31907 | 31907 | Hemet Global Medical Center | 50390 | 2020-12-18 | Riverside | 65 | Southern California | 13.142857142857142 | 3.833333333333336 | 23.83333333333333 | 27.666666666666668 | 0.8614457831325301 | 0.5514485514485514 |
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 |
31909 | 31909 | Hi-desert Medical Center | 50279 | 2020-12-18 | San Bernardino | 71 | Southern California | 2.571428571428572 | 0.1428571428571428 | 3.857142857142857 | 4.0 | 0.9642857142857144 | 0.6666666666666667 |
31910 | 31910 | Highland Hospital | 50320 | 2020-12-18 | Alameda | 1 | Bay Area | 12.857142857142858 | 8.714285714285712 | 25.571428571428573 | 34.285714285714285 | 0.7458333333333333 | 0.5027932960893855 |
31911 | 31911 | Hoag Memorial Hospital Presbyterian | 50224 | 2020-12-18 | Orange | 59 | Southern California | 55.0 | 13.42857142857143 | 72.0 | 85.42857142857143 | 0.842809364548495 | 0.7638888888888888 |
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 |
31913 | 31913 | Huntington Beach Hospital | 50526 | 2020-12-18 | Orange | 59 | Southern California | 9.714285714285714 | 1.7142857142857135 | 13.285714285714286 | 15.0 | 0.8857142857142858 | 0.7311827956989246 |
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 |
31915 | 31915 | John F Kennedy Memorial Hospital | 50534 | 2020-12-18 | Riverside | 65 | Southern California | 9.857142857142858 | 6.428571428571427 | 17.571428571428573 | 24.0 | 0.7321428571428572 | 0.5609756097560975 |
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 |
31918 | 31918 | Kaiser Foundation Hosp So Sacramento | 50674 | 2020-12-18 | Sacramento | 67 | Greater Sacramento | 23.285714285714285 | 0.0 | 35.0 | 35.0 | 1.0 | 0.6653061224489796 |
31919 | 31919 | Kaiser Foundation Hospital | 50510 | 2020-12-18 | Marin | 41 | Bay Area | 3.4285714285714284 | 0.8571428571428568 | 6.428571428571429 | 7.285714285714286 | 0.8823529411764707 | 0.5333333333333333 |
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 |
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 |
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 );