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 2021-01-08 sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31206 | 31206 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-01-08 | San Francisco | 75 | Bay Area | 11.857142857142858 | 2.4285714285714235 | 40.142857142857146 | 42.57142857142857 | 0.9429530201342284 | 0.295373665480427 |
31205 | 31205 | Woodland Memorial Hospital | 50127 | 2021-01-08 | Yolo | 113 | Greater Sacramento | 6.428571428571429 | 14.333333333333332 | 9.5 | 23.83333333333333 | 0.3986013986013986 | 0.6766917293233083 |
31204 | 31204 | Whittier Hospital Medical Center | 50735 | 2021-01-08 | Los Angeles | 37 | Southern California | 15.285714285714286 | 0.0 | 20.142857142857142 | 20.142857142857142 | 1.0 | 0.7588652482269505 |
31203 | 31203 | White Memorial Medical Center | 50103 | 2021-01-08 | Los Angeles | 37 | Southern California | 15.428571428571429 | 1.7142857142857115 | 31.142857142857142 | 32.857142857142854 | 0.9478260869565218 | 0.4954128440366973 |
31202 | 31202 | West Hills Hospital & Medical Center | 50481 | 2021-01-08 | Los Angeles | 37 | Southern California | 16.714285714285715 | 7.0 | 26.285714285714285 | 33.285714285714285 | 0.7896995708154506 | 0.6358695652173914 |
31201 | 31201 | West Anaheim Medical Center | 50426 | 2021-01-08 | Orange | 59 | Southern California | 17.285714285714285 | 0.7142857142857153 | 17.285714285714285 | 18.0 | 0.9603174603174602 | 1.0 |
31200 | 31200 | Watsonville Community Hospital | 50194 | 2021-01-08 | Santa Cruz | 87 | Bay Area | 3.857142857142857 | 0.2857142857142856 | 5.714285714285714 | 6.0 | 0.9523809523809524 | 0.675 |
31199 | 31199 | Washington Hospital | 50195 | 2021-01-08 | Alameda | 1 | Bay Area | 13.714285714285714 | 0.0 | 28.714285714285715 | 28.714285714285715 | 1.0 | 0.4776119402985074 |
31198 | 31198 | Victor Valley Global Medical Center | 50517 | 2021-01-08 | San Bernardino | 71 | Southern California | 11.571428571428571 | 0.1428571428571441 | 10.714285714285714 | 10.857142857142858 | 0.9868421052631576 | 1.08 |
31197 | 31197 | Vibra Hospital of Sacramento | 52033 | 2021-01-08 | Sacramento | 67 | Greater Sacramento | 0.0 | 0.0 | 6.0 | 6.0 | 1.0 | 0.0 |
31196 | 31196 | Ventura County Medical Center | 50159 | 2021-01-08 | Ventura | 111 | Southern California | 5.285714285714286 | 5.285714285714287 | 10.714285714285714 | 16.0 | 0.6696428571428571 | 0.4933333333333333 |
31195 | 31195 | Valley Children's Hospital | 53300 | 2021-01-08 | Fresno | 19 | San Joaquin Valley | 0.5714285714285714 | 0.0 | 9.142857142857142 | 9.142857142857142 | 1.0 | 0.0625 |
31194 | 31194 | University of California Irvine Medical Center | 50348 | 2021-01-08 | Orange | 59 | Southern California | 56.85714285714285 | 2.4285714285714306 | 65.57142857142857 | 68.0 | 0.9642857142857144 | 0.8671023965141612 |
31193 | 31193 | University of California Davis Medical Center | 50599 | 2021-01-08 | Sacramento | 67 | Greater Sacramento | 20.714285714285715 | 2.714285714285708 | 81.28571428571429 | 84.0 | 0.967687074829932 | 0.2548330404217926 |
31192 | 31192 | Uc San Diego Health Hillcrest - Hillcrest Medical Center | 50025 | 2021-01-08 | San Diego | 73 | Southern California | 44.0 | 6.142857142857139 | 95.0 | 101.14285714285714 | 0.939265536723164 | 0.4631578947368421 |
31191 | 31191 | USC Verdugo Hills Hospital | 50124 | 2021-01-08 | Los Angeles | 37 | Southern California | 7.714285714285714 | 0.1428571428571441 | 14.714285714285714 | 14.857142857142858 | 0.9903846153846152 | 0.5242718446601942 |
31190 | 31190 | USC Kenneth Norris Jr Cancer Hospital | 50660 | 2021-01-08 | Los Angeles | 37 | Southern California | 0.0 | 0.5714285714285716 | 2.0 | 2.571428571428572 | 0.7777777777777777 | 0.0 |
31189 | 31189 | USC Arcadia Hospital | 50238 | 2021-01-08 | Los Angeles | 37 | Southern California | 25.571428571428573 | 3.142857142857139 | 29.714285714285715 | 32.857142857142854 | 0.9043478260869566 | 0.8605769230769231 |
31188 | 31188 | UCSF Medical Center | 50454 | 2021-01-08 | San Francisco | 75 | Bay Area | 24.714285714285715 | 15.57142857142857 | 86.42857142857143 | 102.0 | 0.8473389355742297 | 0.2859504132231405 |
31187 | 31187 | Tri-city Medical Center | 50128 | 2021-01-08 | San Diego | 73 | Southern California | 14.285714285714286 | 5.857142857142858 | 19.142857142857142 | 25.0 | 0.7657142857142857 | 0.746268656716418 |
31186 | 31186 | Torrance Memorial Medical Center | 50351 | 2021-01-08 | Los Angeles | 37 | Southern California | 25.0 | 4.0 | 44.42857142857143 | 48.42857142857143 | 0.9174041297935104 | 0.562700964630225 |
31185 | 31185 | Tenet Health Central Twin Cities Community Hosp | 50633 | 2021-01-08 | San Luis Obispo | 79 | Southern California | 2.142857142857143 | 5.714285714285714 | 4.285714285714286 | 10.0 | 0.4285714285714285 | 0.5 |
31184 | 31184 | Tenet Health Central Coast Sierra Vista Rmc | 50506 | 2021-01-08 | San Luis Obispo | 79 | Southern California | 2.857142857142857 | 8.571428571428571 | 8.428571428571429 | 17.0 | 0.4957983193277311 | 0.3389830508474576 |
31183 | 31183 | Temecula Valley Hospital | 50775 | 2021-01-08 | Riverside | 65 | Southern California | 16.857142857142858 | 0.8571428571428541 | 27.571428571428573 | 28.428571428571427 | 0.969849246231156 | 0.6113989637305699 |
31182 | 31182 | Tahoe Forest Hospital | 51328 | 2021-01-08 | Nevada | 57 | Greater Sacramento | 1.0 | 1.2857142857142856 | 4.714285714285714 | 6.0 | 0.7857142857142857 | 0.2121212121212121 |
31181 | 31181 | Sutter Tracy Community Hospital | 50313 | 2021-01-08 | San Joaquin | 77 | San Joaquin Valley | 6.571428571428571 | 0.1428571428571423 | 8.285714285714286 | 8.428571428571429 | 0.9830508474576272 | 0.793103448275862 |
31180 | 31180 | Sutter Solano Medical Center | 50101 | 2021-01-08 | Solano | 95 | Bay Area | 7.285714285714286 | 0.5714285714285712 | 11.428571428571429 | 12.0 | 0.9523809523809524 | 0.6375 |
31179 | 31179 | Sutter Santa Rosa Regional Hospital | 50291 | 2021-01-08 | Sonoma | 97 | Bay Area | 2.571428571428572 | 0.0 | 12.0 | 12.0 | 1.0 | 0.2142857142857143 |
31178 | 31178 | Sutter Roseville Medical Center | 50309 | 2021-01-08 | Placer | 61 | Greater Sacramento | 9.285714285714286 | 5.285714285714285 | 50.71428571428572 | 56.0 | 0.9056122448979592 | 0.1830985915492957 |
31177 | 31177 | Sutter Medical Center, Sacramento | 50108 | 2021-01-08 | Sacramento | 67 | Greater Sacramento | 19.142857142857142 | 10.285714285714285 | 49.71428571428572 | 60.0 | 0.8285714285714286 | 0.3850574712643678 |
31176 | 31176 | Sutter Lakeside Hospital | 51329 | 2021-01-08 | Lake | 33 | Northern California | 1.7142857142857142 | 2.1428571428571423 | 2.7142857142857144 | 4.857142857142857 | 0.5588235294117648 | 0.631578947368421 |
31175 | 31175 | Sutter Delta Medical Center | 50523 | 2021-01-08 | Contra Costa | 13 | Bay Area | 6.714285714285714 | 1.1428571428571423 | 10.857142857142858 | 12.0 | 0.9047619047619048 | 0.618421052631579 |
31174 | 31174 | Sutter Davis Hospital | 50537 | 2021-01-08 | Yolo | 113 | Greater Sacramento | 4.571428571428571 | 0.2857142857142856 | 5.714285714285714 | 6.0 | 0.9523809523809524 | 0.7999999999999999 |
31173 | 31173 | Sutter Coast Hospital | 50417 | 2021-01-08 | Del Norte | 15 | Northern California | 0.0 | 2.0 | 4.0 | 6.0 | 0.6666666666666666 | 0.0 |
31172 | 31172 | Sutter Auburn Faith Hospital | 50498 | 2021-01-08 | Placer | 61 | Greater Sacramento | 3.7142857142857135 | 1.5714285714285712 | 6.428571428571429 | 8.0 | 0.8035714285714286 | 0.5777777777777777 |
31171 | 31171 | Sutter Amador Hospital | 50014 | 2021-01-08 | Amador | 5 | Greater Sacramento | 3.4285714285714284 | 0.1428571428571432 | 5.857142857142857 | 6.0 | 0.9761904761904762 | 0.5853658536585366 |
31170 | 31170 | Stanford Health Care - Valleycare | 50283 | 2021-01-08 | Alameda | 1 | Bay Area | 4.142857142857143 | 4.857142857142858 | 17.142857142857142 | 22.0 | 0.7792207792207791 | 0.2416666666666667 |
31169 | 31169 | Stanford Health Care | 50441 | 2021-01-08 | Santa Clara | 85 | Bay Area | 37.42857142857143 | 2.5714285714285694 | 96.42857142857144 | 99.0 | 0.974025974025974 | 0.3881481481481482 |
31168 | 31168 | St. Rose Hospital | 50002 | 2021-01-08 | Alameda | 1 | Bay Area | 10.142857142857142 | 2.2857142857142865 | 12.714285714285714 | 15.0 | 0.8476190476190476 | 0.7977528089887641 |
31167 | 31167 | St. Mary's Medical Center | 50457 | 2021-01-08 | San Francisco | 75 | Bay Area | 1.2857142857142858 | 7.714285714285714 | 7.142857142857143 | 14.857142857142858 | 0.4807692307692308 | 0.18 |
31166 | 31166 | St. Mary Medical Center | 50191 | 2021-01-08 | Los Angeles | 37 | Southern California | 30.142857142857142 | 16.857142857142854 | 41.0 | 57.85714285714285 | 0.708641975308642 | 0.735191637630662 |
31165 | 31165 | St. Mary Medical Center | 50300 | 2021-01-08 | San Bernardino | 71 | Southern California | 17.714285714285715 | 0.0 | 38.0 | 38.0 | 1.0 | 0.4661654135338346 |
31164 | 31164 | St. Joseph's Medical Center of Stockton | 50084 | 2021-01-08 | San Joaquin | 77 | San Joaquin Valley | 38.142857142857146 | 0.0 | 51.42857142857143 | 51.42857142857143 | 1.0 | 0.7416666666666667 |
31163 | 31163 | St. Johns Regional Medical Center | 50082 | 2021-01-08 | Ventura | 111 | Southern California | 18.428571428571427 | 1.142857142857146 | 24.428571428571427 | 25.571428571428573 | 0.9553072625698324 | 0.7543859649122807 |
31162 | 31162 | St. Johns Hospital Camarillo | 50616 | 2021-01-08 | Ventura | 111 | Southern California | 4.714285714285714 | 0.2857142857142856 | 7.714285714285714 | 8.0 | 0.9642857142857144 | 0.6111111111111112 |
31161 | 31161 | St. Elizabeth Community Hospital | 50042 | 2021-01-08 | Tehama | 103 | Northern California | 3.571428571428572 | 0.7142857142857144 | 7.285714285714286 | 8.0 | 0.9107142857142856 | 0.4901960784313726 |
31160 | 31160 | St. Bernardine Medical Center | 50129 | 2021-01-08 | San Bernardino | 71 | Southern California | 37.285714285714285 | 4.285714285714285 | 51.0 | 55.285714285714285 | 0.9224806201550388 | 0.7310924369747899 |
31159 | 31159 | Southwest Healthcare System | 50701 | 2021-01-08 | Riverside | 65 | Southern California | 30.142857142857142 | 0.7142857142857153 | 38.57142857142857 | 39.285714285714285 | 0.9818181818181818 | 0.7814814814814816 |
31158 | 31158 | Southern California Hospital at Hollywood | 50135 | 2021-01-08 | Los Angeles | 37 | Southern California | 16.428571428571427 | 23.857142857142858 | 26.142857142857142 | 50.0 | 0.5228571428571428 | 0.628415300546448 |
31157 | 31157 | South Coast Global Medical Center | 50747 | 2021-01-08 | Orange | 59 | Southern California | 7.571428571428571 | 0.1428571428571423 | 9.428571428571429 | 9.571428571428571 | 0.9850746268656716 | 0.803030303030303 |
31156 | 31156 | Sonoma Valley Hospital | 50090 | 2021-01-08 | Sonoma | 97 | Bay Area | 1.1428571428571428 | 3.0000000000000004 | 2.4285714285714284 | 5.428571428571429 | 0.4473684210526315 | 0.4705882352941176 |
31155 | 31155 | Sonoma Specialty Hospital | 52057 | 2021-01-08 | Sonoma | 97 | Bay Area | 0.0 | 0.0 | 5.0 | 5.0 | 1.0 | 0.0 |
31154 | 31154 | Sierra View Medical Center | 50261 | 2021-01-08 | Tulare | 107 | San Joaquin Valley | 7.428571428571429 | 0.8571428571428577 | 9.714285714285714 | 10.571428571428571 | 0.9189189189189187 | 0.7647058823529412 |
31153 | 31153 | Sierra Nevada Memorial Hospital | 50150 | 2021-01-08 | Nevada | 57 | Greater Sacramento | 3.0 | 1.5714285714285712 | 6.428571428571429 | 8.0 | 0.8035714285714286 | 0.4666666666666667 |
31152 | 31152 | Sherman Oaks Hospital | 50755 | 2021-01-08 | Los Angeles | 37 | Southern California | 8.714285714285714 | 1.5714285714285694 | 20.714285714285715 | 22.285714285714285 | 0.9294871794871796 | 0.4206896551724137 |
31151 | 31151 | Shasta Regional Medical Center | 50764 | 2021-01-08 | Shasta | 89 | Northern California | 2.4285714285714284 | 2.8571428571428577 | 11.571428571428571 | 14.428571428571429 | 0.8019801980198019 | 0.2098765432098765 |
31150 | 31150 | Sharp Memorial Hospital | 50100 | 2021-01-08 | San Diego | 73 | Southern California | 47.142857142857146 | 2.2857142857142776 | 64.85714285714286 | 67.14285714285714 | 0.9659574468085108 | 0.7268722466960352 |
31149 | 31149 | Sharp Coronado Hospital and Hlthcr Center | 50234 | 2021-01-08 | San Diego | 73 | Southern California | 13.0 | 0.0 | 14.714285714285714 | 14.714285714285714 | 1.0 | 0.883495145631068 |
31148 | 31148 | Sharp Chula Vista Medical Center | 50222 | 2021-01-08 | San Diego | 73 | Southern California | 40.0 | 1.142857142857146 | 47.0 | 48.142857142857146 | 0.9762611275964392 | 0.851063829787234 |
31147 | 31147 | Sequoia Hospital | 50197 | 2021-01-08 | San Mateo | 81 | Bay Area | 8.714285714285714 | 0.5714285714285712 | 13.142857142857142 | 13.714285714285714 | 0.9583333333333334 | 0.6630434782608695 |
31146 | 31146 | Select Specialty Hospital - San Diego | 52044 | 2021-01-08 | San Diego | 73 | Southern California | 0.0 | 0.0 | 1.7142857142857142 | 1.7142857142857142 | 1.0 | 0.0 |
31145 | 31145 | Scripps Mercy Hospital | 50077 | 2021-01-08 | San Diego | 73 | Southern California | 42.85714285714285 | 7.0 | 56.71428571428572 | 63.71428571428572 | 0.8901345291479821 | 0.7556675062972291 |
31144 | 31144 | Scripps Memorial Hospital La Jolla | 50324 | 2021-01-08 | San Diego | 73 | Southern California | 47.142857142857146 | 2.4285714285714306 | 74.57142857142857 | 77.0 | 0.9684601113172542 | 0.632183908045977 |
31143 | 31143 | Scripps Memorial Hospital - Encinitas | 50503 | 2021-01-08 | San Diego | 73 | Southern California | 14.714285714285714 | -1.0 | 13.0 | 12.0 | 1.0833333333333333 | 1.1318681318681318 |
31142 | 31142 | Scripps Green Hospital | 50424 | 2021-01-08 | San Diego | 73 | Southern California | 12.714285714285714 | 3.8571428571428577 | 20.142857142857142 | 24.0 | 0.8392857142857143 | 0.6312056737588653 |
31141 | 31141 | Santa Paula Hospital | 2021-01-08 | Ventura | 111 | Southern California | 2.857142857142857 | 0.0 | 6.0 | 6.0 | 1.0 | 0.4761904761904762 | |
31140 | 31140 | Santa Monica - UCLA Medical Center & Orthopaedic Hospital | 50112 | 2021-01-08 | Los Angeles | 37 | Southern California | 14.142857142857142 | 3.0 | 22.857142857142858 | 25.857142857142858 | 0.8839779005524862 | 0.6187499999999999 |
31139 | 31139 | Santa Clara Valley Medical Center | 50038 | 2021-01-08 | Santa Clara | 85 | Bay Area | 28.571428571428573 | 44.142857142857146 | 62.285714285714285 | 106.42857142857144 | 0.5852348993288591 | 0.4587155963302752 |
31138 | 31138 | Santa Barbara Cottage Hospital | 50396 | 2021-01-08 | Santa Barbara | 83 | Southern California | 21.857142857142858 | 7.285714285714285 | 37.71428571428572 | 45.0 | 0.8380952380952381 | 0.5795454545454546 |
31137 | 31137 | San Ramon Regional Medical Center | 50689 | 2021-01-08 | Contra Costa | 13 | Bay Area | 6.428571428571429 | 3.2857142857142865 | 8.714285714285714 | 12.0 | 0.7261904761904762 | 0.7377049180327869 |
31136 | 31136 | San Mateo Medical Center | 50113 | 2021-01-08 | San Mateo | 81 | Bay Area | 4.428571428571429 | 1.0 | 5.285714285714286 | 6.285714285714286 | 0.8409090909090909 | 0.8378378378378379 |
31135 | 31135 | San Joaquin General Hospital | 50167 | 2021-01-08 | San Joaquin | 77 | San Joaquin Valley | 13.285714285714286 | 0.0 | 27.0 | 27.0 | 1.0 | 0.4920634920634921 |
31134 | 31134 | San Gorgonio Memorial Hospital | 50054 | 2021-01-08 | Riverside | 65 | Southern California | 19.0 | 0.0 | 21.0 | 21.0 | 1.0 | 0.9047619047619048 |
31133 | 31133 | San Gabriel Valley Medical Center | 50132 | 2021-01-08 | Los Angeles | 37 | Southern California | 15.857142857142858 | 0.2857142857142882 | 18.428571428571427 | 18.714285714285715 | 0.9847328244274808 | 0.8604651162790699 |
31132 | 31132 | San Dimas Community Hospital | 50588 | 2021-01-08 | Los Angeles | 37 | Southern California | 23.428571428571427 | 0.0 | 25.571428571428573 | 25.571428571428573 | 1.0 | 0.9162011173184356 |
31131 | 31131 | San Antonio Regional Hospital | 50099 | 2021-01-08 | San Bernardino | 71 | Southern California | 19.285714285714285 | 1.0 | 61.57142857142857 | 62.57142857142857 | 0.9840182648401826 | 0.3132250580046403 |
31130 | 31130 | Salinas Valley Memorial Hospital | 50334 | 2021-01-08 | Monterey | 53 | Bay Area | 10.0 | 11.714285714285714 | 14.428571428571429 | 26.142857142857142 | 0.551912568306011 | 0.693069306930693 |
31129 | 31129 | Saint John's Health Center | 50290 | 2021-01-08 | Los Angeles | 37 | Southern California | 13.571428571428571 | 2.0 | 25.428571428571427 | 27.428571428571427 | 0.9270833333333334 | 0.5337078651685393 |
31128 | 31128 | Saint Francis Memorial Hospital | 50152 | 2021-01-08 | San Francisco | 75 | Bay Area | 6.285714285714286 | 9.714285714285714 | 8.285714285714286 | 18.0 | 0.4603174603174603 | 0.7586206896551724 |
31127 | 31127 | Saint Francis Medical Center | 50104 | 2021-01-08 | Los Angeles | 37 | Southern California | 27.428571428571427 | 1.0 | 34.0 | 35.0 | 0.9714285714285714 | 0.8067226890756302 |
31126 | 31126 | Saint Agnes Medical Center | 50093 | 2021-01-08 | Fresno | 19 | San Joaquin Valley | 35.285714285714285 | 1.5714285714285765 | 47.85714285714285 | 49.42857142857143 | 0.9682080924855492 | 0.737313432835821 |
31125 | 31125 | Ronald Reagan UCLA Medical Center | 50262 | 2021-01-08 | Los Angeles | 37 | Southern California | 38.285714285714285 | 9.57142857142857 | 99.42857142857144 | 109.0 | 0.9121887287024902 | 0.3850574712643678 |
31124 | 31124 | Riverside University Health System-medical Center | 50292 | 2021-01-08 | Riverside | 65 | Southern California | 29.571428571428573 | 3.7142857142857153 | 54.285714285714285 | 58.0 | 0.9359605911330048 | 0.5447368421052632 |
31123 | 31123 | Riverside Community Hospital | 50022 | 2021-01-08 | Riverside | 65 | Southern California | 47.285714285714285 | 0.1428571428571388 | 81.0 | 81.14285714285714 | 0.9982394366197184 | 0.5837742504409171 |
31122 | 31122 | Ridgecrest Regional Hospital | 51333 | 2021-01-08 | Kern | 29 | San Joaquin Valley | 4.0 | 0.0 | 4.0 | 4.0 | 1.0 | 1.0 |
31121 | 31121 | Regional Medical Center of San Jose | 50125 | 2021-01-08 | Santa Clara | 85 | Bay Area | 29.285714285714285 | 0.0 | 50.57142857142857 | 50.57142857142857 | 1.0 | 0.5790960451977402 |
31120 | 31120 | Redlands Community Hospital | 50272 | 2021-01-08 | San Bernardino | 71 | Southern California | 16.285714285714285 | 1.428571428571427 | 19.0 | 20.428571428571427 | 0.93006993006993 | 0.8571428571428571 |
31119 | 31119 | Providence St. Jude Medical Center | 50168 | 2021-01-08 | Orange | 59 | Southern California | 27.0 | 1.7142857142857082 | 69.85714285714286 | 71.57142857142857 | 0.9760479041916168 | 0.3865030674846625 |
31118 | 31118 | Providence St. Joseph Hospital | 50069 | 2021-01-08 | Orange | 59 | Southern California | 28.571428571428573 | 2.5 | 44.16666666666666 | 46.66666666666666 | 0.9464285714285714 | 0.646900269541779 |
31117 | 31117 | Providence St. Joseph Hospital | 50006 | 2021-01-08 | Humboldt | 23 | Northern California | 2.857142857142857 | 3.0 | 14.142857142857142 | 17.142857142857142 | 0.825 | 0.202020202020202 |
31116 | 31116 | Providence Santa Rosa Memorial Hospital | 50174 | 2021-01-08 | Sonoma | 97 | Bay Area | 7.714285714285714 | 3.2857142857142847 | 22.714285714285715 | 26.0 | 0.8736263736263736 | 0.3396226415094339 |
31115 | 31115 | Providence Saint Joseph Medical Center | 50235 | 2021-01-08 | Los Angeles | 37 | Southern California | 37.42857142857143 | 1.6666666666666643 | 63.16666666666666 | 64.83333333333333 | 0.974293059125964 | 0.5925367508480965 |
31114 | 31114 | Providence Redwood Memorial Hospital | 51318 | 2021-01-08 | Humboldt | 23 | Northern California | 0.0 | 1.7142857142857144 | 2.2857142857142856 | 4.0 | 0.5714285714285714 | 0.0 |
31113 | 31113 | Providence Queen of the Valley Medical Center | 50009 | 2021-01-08 | Napa | 55 | Bay Area | 10.428571428571429 | 0.1428571428571423 | 13.857142857142858 | 14.0 | 0.9897959183673468 | 0.7525773195876289 |
31112 | 31112 | Providence Mission Hospital | 50567 | 2021-01-08 | Orange | 59 | Southern California | 38.42857142857143 | 1.857142857142854 | 62.85714285714285 | 64.71428571428571 | 0.9713024282560708 | 0.6113636363636364 |
31111 | 31111 | Providence Little Company of Mary Medical Center Torrance | 50353 | 2021-01-08 | Los Angeles | 37 | Southern California | 20.571428571428573 | 1.428571428571427 | 29.714285714285715 | 31.142857142857142 | 0.9541284403669724 | 0.6923076923076923 |
31110 | 31110 | Providence Little Company of Mary Medical Center San Pedro | 50078 | 2021-01-08 | Los Angeles | 37 | Southern California | 11.285714285714286 | 0.4285714285714288 | 14.714285714285714 | 15.142857142857142 | 0.9716981132075472 | 0.766990291262136 |
31109 | 31109 | Providence Holy Cross Medical Center | 50278 | 2021-01-08 | Los Angeles | 37 | Southern California | 29.857142857142858 | 0.0 | 44.285714285714285 | 44.285714285714285 | 1.0 | 0.6741935483870968 |
31108 | 31108 | Providence Cedars Sinai Tarzana Medical Center | 50761 | 2021-01-08 | Los Angeles | 37 | Southern California | 7.428571428571429 | 0.428571428571427 | 27.0 | 27.428571428571427 | 0.984375 | 0.2751322751322751 |
31107 | 31107 | Pomona Valley Hospital Medical Center | 50231 | 2021-01-08 | Los Angeles | 37 | Southern California | 51.71428571428572 | 4.142857142857139 | 80.85714285714286 | 85.0 | 0.9512605042016808 | 0.6395759717314488 |
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 );