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-10-01 sorted by week
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19278 | 19278 | Adventist Health Bakersfield | 50455 | 2021-10-01 | Kern | 29 | San Joaquin Valley | 20.0 | 1.428571428571427 | 28.571428571428573 | 30.0 | 0.9523809523809524 | 0.7 |
19279 | 19279 | Adventist Health Clearlake | 51317 | 2021-10-01 | Lake | 33 | Northern California | 0.7142857142857143 | 0.0 | 4.0 | 4.0 | 1.0 | 0.1785714285714285 |
19280 | 19280 | Adventist Health Delano | 50608 | 2021-10-01 | Kern | 29 | San Joaquin Valley | 3.7142857142857135 | 0.0 | 8.142857142857142 | 8.142857142857142 | 1.0 | 0.456140350877193 |
19281 | 19281 | Adventist Health Hanford | 50121 | 2021-10-01 | Kings | 31 | San Joaquin Valley | 15.428571428571429 | 3.0 | 20.0 | 23.0 | 0.8695652173913043 | 0.7714285714285715 |
19282 | 19282 | Adventist Health Howard Memorial | 51310 | 2021-10-01 | Mendocino | 45 | Northern California | 0.8571428571428571 | 0.0 | 4.0 | 4.0 | 1.0 | 0.2142857142857142 |
19283 | 19283 | Adventist Health Lodi Memorial | 50336 | 2021-10-01 | San Joaquin | 77 | San Joaquin Valley | 6.857142857142857 | 0.4285714285714288 | 14.142857142857142 | 14.571428571428571 | 0.9705882352941176 | 0.4848484848484848 |
19284 | 19284 | Adventist Health Mendocino Coast | 51325 | 2021-10-01 | Mendocino | 45 | Northern California | 0.0 | 0.8571428571428572 | 3.0 | 3.857142857142857 | 0.7777777777777778 | 0.0 |
19285 | 19285 | Adventist Health Simi Valley | 50236 | 2021-10-01 | Ventura | 111 | Southern California | 1.7142857142857142 | 0.5714285714285721 | 7.714285714285714 | 8.285714285714286 | 0.9310344827586208 | 0.2222222222222222 |
19286 | 19286 | Adventist Health Sonora | 50335 | 2021-10-01 | Tuolumne | 109 | San Joaquin Valley | 2.0 | 2.0 | 4.0 | 6.0 | 0.6666666666666666 | 0.5 |
19287 | 19287 | Adventist Health St. Helena | 50013 | 2021-10-01 | Napa | 55 | Bay Area | 3.4285714285714284 | 2.999999999999999 | 7.142857142857143 | 10.142857142857142 | 0.7042253521126761 | 0.4799999999999999 |
19288 | 19288 | Adventist Health Tehachapi Valley | 51301 | 2021-10-01 | Kern | 29 | San Joaquin Valley | 2.571428571428572 | 0.1428571428571428 | 3.857142857142857 | 4.0 | 0.9642857142857144 | 0.6666666666666667 |
19289 | 19289 | Adventist Health Tulare | 50784 | 2021-10-01 | Tulare | 107 | San Joaquin Valley | 3.2857142857142856 | 1.1428571428571423 | 4.714285714285714 | 5.857142857142857 | 0.8048780487804879 | 0.6969696969696969 |
19290 | 19290 | Adventist Health Ukiah Valley | 50301 | 2021-10-01 | Mendocino | 45 | Northern California | 2.2857142857142856 | 1.8571428571428577 | 5.857142857142857 | 7.714285714285714 | 0.7592592592592592 | 0.3902439024390244 |
19291 | 19291 | Adventist Health and Rideout | 50133 | 2021-10-01 | Yuba | 115 | Greater Sacramento | 9.285714285714286 | 2.7142857142857157 | 21.285714285714285 | 24.0 | 0.8869047619047619 | 0.436241610738255 |
19292 | 19292 | Ahmc Anaheim Regional Medical Center | 50226 | 2021-10-01 | Orange | 59 | Southern California | 3.571428571428572 | 1.8571428571428577 | 10.571428571428571 | 12.428571428571429 | 0.8505747126436781 | 0.3378378378378379 |
19293 | 19293 | Ahmc Seton Medical Center | 50289 | 2021-10-01 | San Mateo | 81 | Bay Area | 1.1428571428571428 | 0.2857142857142865 | 11.142857142857142 | 11.428571428571429 | 0.975 | 0.1025641025641025 |
19294 | 19294 | Alameda Hospital | 50211 | 2021-10-01 | Alameda | 1 | Bay Area | 0.0 | 4.571428571428571 | 3.4285714285714284 | 8.0 | 0.4285714285714285 | 0.0 |
19295 | 19295 | Alhambra Hospital Medical Center | 50281 | 2021-10-01 | Los Angeles | 37 | Southern California | 0.0 | 2.0 | 5.571428571428571 | 7.571428571428571 | 0.7358490566037735 | 0.0 |
19296 | 19296 | Alta Bates Summit Medical Center | 50043 | 2021-10-01 | Alameda | 1 | Bay Area | 2.142857142857143 | 22.285714285714285 | 13.714285714285714 | 36.0 | 0.3809523809523809 | 0.15625 |
19297 | 19297 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305 | 2021-10-01 | Alameda | 1 | Bay Area | 3.4285714285714284 | 18.142857142857142 | 11.857142857142858 | 30.0 | 0.3952380952380953 | 0.2891566265060241 |
19298 | 19298 | Alvarado Hospital Medical Center | 50757 | 2021-10-01 | San Diego | 73 | Southern California | 4.142857142857143 | 3.7142857142857135 | 10.285714285714286 | 14.0 | 0.7346938775510204 | 0.4027777777777778 |
19299 | 19299 | Anaheim Global Medical Center | 50744 | 2021-10-01 | Orange | 59 | Southern California | 1.4285714285714286 | 19.428571428571427 | 2.571428571428572 | 22.0 | 0.1168831168831169 | 0.5555555555555556 |
19300 | 19300 | Antelope Valley Hospital | 50056 | 2021-10-01 | Los Angeles | 37 | Southern California | 5.428571428571429 | 1.7142857142857153 | 27.857142857142858 | 29.571428571428573 | 0.9420289855072465 | 0.1948717948717948 |
19301 | 19301 | Arrowhead Regional Medical Center | 50245 | 2021-10-01 | San Bernardino | 71 | Southern California | 6.428571428571429 | 19.0 | 29.0 | 48.0 | 0.6041666666666666 | 0.2216748768472906 |
19302 | 19302 | Bakersfield Heart Hospital | 50724 | 2021-10-01 | Kern | 29 | San Joaquin Valley | 8.833333333333334 | 0.0 | 13.333333333333334 | 13.333333333333334 | 1.0 | 0.6625 |
19303 | 19303 | Bakersfield Memorial Hospital | 50036 | 2021-10-01 | Kern | 29 | San Joaquin Valley | 13.0 | 2.0 | 27.714285714285715 | 29.714285714285715 | 0.9326923076923076 | 0.4690721649484536 |
19304 | 19304 | Barlow Respiratory Hospital | 52031 | 2021-10-01 | Los Angeles | 37 | Southern California | 0.0 | 4.0 | 2.0 | 6.0 | 0.3333333333333333 | 0.0 |
19305 | 19305 | Barstow Community Hospital | 50298 | 2021-10-01 | San Bernardino | 71 | Southern California | 2.333333333333333 | 1.0 | 5.0 | 6.0 | 0.8333333333333334 | 0.4666666666666667 |
19306 | 19306 | Barton Memorial Hospital | 50352 | 2021-10-01 | El Dorado | 17 | Greater Sacramento | 2.2857142857142856 | 1.5714285714285716 | 3.571428571428572 | 5.142857142857143 | 0.6944444444444444 | 0.6399999999999999 |
19307 | 19307 | Beverly Hospital | 50350 | 2021-10-01 | Los Angeles | 37 | Southern California | 0.0 | 14.142857142857142 | 10.857142857142858 | 25.0 | 0.4342857142857143 | 0.0 |
19308 | 19308 | California Hospital Medical Center LA | 50149 | 2021-10-01 | Los Angeles | 37 | Southern California | 1.7142857142857142 | 10.857142857142858 | 19.142857142857142 | 30.0 | 0.638095238095238 | 0.0895522388059701 |
19309 | 19309 | California Pacific Medical Center - Mission Bernal | 50055 | 2021-10-01 | San Francisco | 75 | Bay Area | 1.2857142857142858 | 3.428571428571429 | 6.571428571428571 | 10.0 | 0.6571428571428571 | 0.1956521739130435 |
19310 | 19310 | California Pacific Medical Center- Van Ness Campus | 50047 | 2021-10-01 | San Francisco | 75 | Bay Area | 1.7142857142857142 | 6.428571428571427 | 29.571428571428573 | 36.0 | 0.8214285714285715 | 0.0579710144927536 |
19311 | 19311 | California Pacific Medical Ctr-davies Campus Hosp | 50008 | 2021-10-01 | San Francisco | 75 | Bay Area | 0.0 | 4.285714285714286 | 3.7142857142857135 | 8.0 | 0.4642857142857143 | 0.0 |
19312 | 19312 | Casa Colina Hospital | 50782 | 2021-10-01 | Los Angeles | 37 | Southern California | 0.0 | 6.0 | 0.0 | 6.0 | 0.0 | |
19313 | 19313 | Cedars-Sinai Marina Del Rey Hospital | 50740 | 2021-10-01 | Los Angeles | 37 | Southern California | 3.0 | 3.8571428571428577 | 8.142857142857142 | 12.0 | 0.6785714285714285 | 0.368421052631579 |
19314 | 19314 | Cedars-Sinai Medical Center | 50625 | 2021-10-01 | Los Angeles | 37 | Southern California | 2.142857142857143 | 6.857142857142861 | 101.14285714285714 | 108.0 | 0.9365079365079364 | 0.0211864406779661 |
19315 | 19315 | Centinela Hospital Medical Center | 50739 | 2021-10-01 | Los Angeles | 37 | Southern California | 3.0 | 6.857142857142854 | 26.0 | 32.857142857142854 | 0.791304347826087 | 0.1153846153846153 |
19316 | 19316 | Chapman Global Medical Center | 50745 | 2021-10-01 | Orange | 59 | Southern California | 0.0 | 8.428571428571429 | 3.571428571428572 | 12.0 | 0.2976190476190476 | 0.0 |
19317 | 19317 | Chinese Hospital | 50407 | 2021-10-01 | San Francisco | 75 | Bay Area | 0.8 | 2.4 | 3.6 | 6.0 | 0.6 | 0.2222222222222222 |
19318 | 19318 | Chino Valley Medical Center | 50586 | 2021-10-01 | San Bernardino | 71 | Southern California | 0.8571428571428571 | 0.5714285714285721 | 6.571428571428571 | 7.142857142857143 | 0.92 | 0.1304347826086956 |
19319 | 19319 | City of Hope Helford Clinical Research Hospital | 50146 | 2021-10-01 | Los Angeles | 37 | Southern California | 0.0 | 3.7142857142857135 | 14.285714285714286 | 18.0 | 0.7936507936507937 | 0.0 |
19320 | 19320 | Clovis Community Medical Center | 50492 | 2021-10-01 | Fresno | 19 | San Joaquin Valley | 7.857142857142857 | 4.428571428571427 | 22.571428571428573 | 27.0 | 0.835978835978836 | 0.3481012658227848 |
19321 | 19321 | Coast Plaza Hospital | 50771 | 2021-10-01 | Los Angeles | 37 | Southern California | 0.0 | 1.333333333333333 | 5.666666666666667 | 7.0 | 0.8095238095238095 | 0.0 |
19322 | 19322 | College Medical Center | 50776 | 2021-10-01 | Los Angeles | 37 | Southern California | 0.0 | 8.0 | 7.0 | 15.0 | 0.4666666666666667 | 0.0 |
19323 | 19323 | Community Hospital of Huntington Park | 50091 | 2021-10-01 | Los Angeles | 37 | Southern California | 1.8571428571428568 | 0.0 | 4.0 | 4.0 | 1.0 | 0.4642857142857143 |
19324 | 19324 | Community Hospital of San Bernardino | 50089 | 2021-10-01 | San Bernardino | 71 | Southern California | 6.285714285714286 | 14.857142857142858 | 10.142857142857142 | 25.0 | 0.4057142857142857 | 0.619718309859155 |
19325 | 19325 | Community Hospital of the Monterey Peninsula | 50145 | 2021-10-01 | Monterey | 53 | Bay Area | 1.4285714285714286 | 11.857142857142858 | 14.142857142857142 | 26.0 | 0.5439560439560439 | 0.101010101010101 |
19326 | 19326 | Community Memorial Hospital San Buenaventura | 50394 | 2021-10-01 | Ventura | 111 | Southern California | 1.8571428571428568 | 2.7142857142857157 | 16.428571428571427 | 19.142857142857142 | 0.8582089552238805 | 0.1130434782608695 |
19327 | 19327 | Community Regional Medical Center | 50060 | 2021-10-01 | Fresno | 19 | San Joaquin Valley | 23.571428571428573 | 8.857142857142861 | 78.14285714285714 | 87.0 | 0.8981937602627257 | 0.3016453382084095 |
19328 | 19328 | Contra Costa Regional Medical Center | 50276 | 2021-10-01 | Contra Costa | 13 | Bay Area | 3.857142857142857 | 4.142857142857142 | 13.857142857142858 | 18.0 | 0.7698412698412699 | 0.2783505154639175 |
19329 | 19329 | Corona Regional Medical Center | 50329 | 2021-10-01 | Riverside | 65 | Southern California | 5.857142857142857 | 4.285714285714285 | 18.0 | 22.285714285714285 | 0.8076923076923077 | 0.3253968253968253 |
19330 | 19330 | Dameron Hospital | 50122 | 2021-10-01 | San Joaquin | 77 | San Joaquin Valley | 6.142857142857143 | 0.8571428571428559 | 11.285714285714286 | 12.142857142857142 | 0.9294117647058824 | 0.5443037974683544 |
19331 | 19331 | Desert Regional Medical Center | 50243 | 2021-10-01 | Riverside | 65 | Southern California | 6.714285714285714 | 0.2857142857142847 | 33.57142857142857 | 33.857142857142854 | 0.9915611814345991 | 0.2 |
19332 | 19332 | Desert Valley Hospital | 50709 | 2021-10-01 | San Bernardino | 71 | Southern California | 8.428571428571429 | 0.1428571428571459 | 18.428571428571427 | 18.571428571428573 | 0.992307692307692 | 0.4573643410852713 |
19333 | 19333 | Doctors Hospital of Manteca | 50118 | 2021-10-01 | San Joaquin | 77 | San Joaquin Valley | 2.142857142857143 | 3.428571428571429 | 4.285714285714286 | 7.714285714285714 | 0.5555555555555556 | 0.5 |
19334 | 19334 | Doctors Hospital of Riverside, LLC | 50102 | 2021-10-01 | Riverside | 65 | Southern California | 1.5714285714285714 | 4.428571428571429 | 7.571428571428571 | 12.0 | 0.6309523809523809 | 0.2075471698113207 |
19335 | 19335 | Doctors Medical Center | 50464 | 2021-10-01 | Stanislaus | 99 | San Joaquin Valley | 11.571428571428571 | 8.142857142857146 | 35.857142857142854 | 44.0 | 0.8149350649350648 | 0.3227091633466136 |
19336 | 19336 | Dominican Hospital | 50242 | 2021-10-01 | Santa Cruz | 87 | Bay Area | 1.8571428571428568 | 0.7142857142857135 | 11.285714285714286 | 12.0 | 0.9404761904761906 | 0.1645569620253164 |
19337 | 19337 | East Los Angeles Doctors Hospital | 50641 | 2021-10-01 | Los Angeles | 37 | Southern California | 0.8571428571428571 | 4.571428571428571 | 3.142857142857143 | 7.714285714285714 | 0.4074074074074074 | 0.2727272727272727 |
19338 | 19338 | Eden Medical Center | 50488 | 2021-10-01 | Alameda | 1 | Bay Area | 1.0 | 6.0 | 18.0 | 24.0 | 0.75 | 0.0555555555555555 |
19339 | 19339 | Eisenhower Medical Center | 50573 | 2021-10-01 | Riverside | 65 | Southern California | 2.571428571428572 | 4.428571428571427 | 20.0 | 24.428571428571427 | 0.8187134502923977 | 0.1285714285714286 |
19340 | 19340 | El Camino Hospital | 50308 | 2021-10-01 | Santa Clara | 85 | Bay Area | 0.0 | 13.857142857142858 | 18.142857142857142 | 32.0 | 0.5669642857142857 | 0.0 |
19341 | 19341 | El Centro Regional Medical Center | 50045 | 2021-10-01 | Imperial | 25 | Southern California | 4.857142857142857 | 4.285714285714286 | 7.714285714285714 | 12.0 | 0.6428571428571429 | 0.6296296296296295 |
19342 | 19342 | Emanate Health Foothill Presbyterian Hospital | 50597 | 2021-10-01 | Los Angeles | 37 | Southern California | 4.714285714285714 | 4.571428571428571 | 13.428571428571429 | 18.0 | 0.746031746031746 | 0.351063829787234 |
19343 | 19343 | Emanate Health Inter-community Hospital | 50382 | 2021-10-01 | Los Angeles | 37 | Southern California | 7.571428571428571 | 8.428571428571427 | 31.571428571428573 | 40.0 | 0.7892857142857144 | 0.2398190045248868 |
19344 | 19344 | Emanuel Medical Center | 50179 | 2021-10-01 | Stanislaus | 99 | San Joaquin Valley | 5.142857142857143 | 4.285714285714286 | 7.714285714285714 | 12.0 | 0.6428571428571429 | 0.6666666666666667 |
19345 | 19345 | Encino Hospital Medical Center | 50158 | 2021-10-01 | Los Angeles | 37 | Southern California | 0.0 | 1.7142857142857144 | 2.2857142857142856 | 4.0 | 0.5714285714285714 | 0.0 |
19346 | 19346 | Enloe Medical Center | 50039 | 2021-10-01 | Butte | 7 | Greater Sacramento | 12.857142857142858 | 2.142857142857146 | 24.428571428571427 | 26.571428571428573 | 0.9193548387096772 | 0.5263157894736843 |
19347 | 19347 | Fairchild Medical Center | 51316 | 2021-10-01 | Siskiyou | 93 | Northern California | 7.142857142857143 | 0.1428571428571423 | 8.0 | 8.142857142857142 | 0.9824561403508772 | 0.8928571428571429 |
19348 | 19348 | Foothill Regional Medical Center | 50780 | 2021-10-01 | Orange | 59 | Southern California | 4.0 | 4.142857142857142 | 8.857142857142858 | 13.0 | 0.6813186813186813 | 0.4516129032258064 |
19349 | 19349 | Fountain Valley Regional Hospital & Medical Center | 50570 | 2021-10-01 | Orange | 59 | Southern California | 1.7142857142857142 | 2.2857142857142847 | 22.714285714285715 | 25.0 | 0.9085714285714286 | 0.0754716981132075 |
19350 | 19350 | French Hospital Medical Center | 50232 | 2021-10-01 | San Luis Obispo | 79 | Southern California | 0.0 | 0.4285714285714288 | 6.857142857142857 | 7.285714285714286 | 0.9411764705882352 | 0.0 |
19351 | 19351 | Fresno Heart and Surgical Hospital | 50732 | 2021-10-01 | Fresno | 19 | San Joaquin Valley | 0.0 | 2.0 | 7.0 | 9.0 | 0.7777777777777778 | 0.0 |
19352 | 19352 | Garden Grove Hospital & Medical Center | 50230 | 2021-10-01 | Orange | 59 | Southern California | 2.7142857142857144 | 0.5714285714285712 | 6.285714285714286 | 6.857142857142857 | 0.9166666666666669 | 0.4318181818181818 |
19353 | 19353 | Garfield Medical Center | 50737 | 2021-10-01 | Los Angeles | 37 | Southern California | 0.0 | 7.142857142857142 | 14.857142857142858 | 22.0 | 0.6753246753246753 | 0.0 |
19354 | 19354 | Glendale Adventist Medical Center | 50239 | 2021-10-01 | Los Angeles | 37 | Southern California | 2.0 | 1.0 | 25.0 | 26.0 | 0.9615384615384616 | 0.08 |
19355 | 19355 | Glendale Mem Hospital & Health Center | 50058 | 2021-10-01 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 9.714285714285714 | 9.714285714285714 | 1.0 | 0.0 |
19356 | 19356 | Goleta Valley Cottage Hospital | 50357 | 2021-10-01 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.7142857142857143 | 0.7142857142857143 | 1.0 | 0.0 |
19357 | 19357 | Good Samaritan Hospital | 50257 | 2021-10-01 | Kern | 29 | San Joaquin Valley | 0.0 | 4.0 | 0.0 | 4.0 | 0.0 | |
19358 | 19358 | Good Samaritan Hospital | 50380 | 2021-10-01 | Santa Clara | 85 | Bay Area | 0.7142857142857143 | 10.285714285714285 | 26.714285714285715 | 37.0 | 0.722007722007722 | 0.0267379679144385 |
19359 | 19359 | Greater El Monte Community Hospital | 50738 | 2021-10-01 | Los Angeles | 37 | Southern California | 2.857142857142857 | 1.2857142857142865 | 8.714285714285714 | 10.0 | 0.8714285714285713 | 0.3278688524590164 |
19360 | 19360 | Grossmont Hospital | 50026 | 2021-10-01 | San Diego | 73 | Southern California | 9.571428571428571 | 8.714285714285708 | 66.28571428571429 | 75.0 | 0.8838095238095239 | 0.1443965517241379 |
19361 | 19361 | Hazel Hawkins Memorial Hospital | 51337 | 2021-10-01 | San Benito | 69 | San Joaquin Valley | 2.0 | 0.2857142857142856 | 3.7142857142857135 | 4.0 | 0.9285714285714286 | 0.5384615384615384 |
19362 | 19362 | Healdsburg Hospital | 51321 | 2021-10-01 | Sonoma | 97 | Bay Area | 0.0 | 4.142857142857143 | 0.8571428571428571 | 5.0 | 0.1714285714285714 | 0.0 |
19363 | 19363 | Hemet Global Medical Center | 50390 | 2021-10-01 | Riverside | 65 | Southern California | 5.142857142857143 | 5.714285714285715 | 20.285714285714285 | 26.0 | 0.7802197802197802 | 0.2535211267605634 |
19364 | 19364 | Henry Mayo Newhall Hospital | 50624 | 2021-10-01 | Los Angeles | 37 | Southern California | 4.428571428571429 | 1.0 | 20.857142857142858 | 21.857142857142858 | 0.954248366013072 | 0.2123287671232877 |
19365 | 19365 | Hi-desert Medical Center | 50279 | 2021-10-01 | San Bernardino | 71 | Southern California | 2.2857142857142856 | 0.5714285714285716 | 3.4285714285714284 | 4.0 | 0.8571428571428571 | 0.6666666666666666 |
19366 | 19366 | Highland Hospital | 50320 | 2021-10-01 | Alameda | 1 | Bay Area | 2.4285714285714284 | 9.142857142857142 | 23.857142857142858 | 33.0 | 0.722943722943723 | 0.1017964071856287 |
19367 | 19367 | Hoag Memorial Hospital Presbyterian | 50224 | 2021-10-01 | Orange | 59 | Southern California | 12.285714285714286 | 18.28571428571428 | 31.571428571428573 | 49.85714285714285 | 0.6332378223495703 | 0.3891402714932127 |
19368 | 19368 | Hollywood Presbyterian Medical Center | 50063 | 2021-10-01 | Los Angeles | 37 | Southern California | 1.1428571428571428 | 12.0 | 12.0 | 24.0 | 0.5 | 0.0952380952380952 |
19369 | 19369 | Huntington Beach Hospital | 50526 | 2021-10-01 | Orange | 59 | Southern California | 1.0 | 0.5714285714285712 | 7.428571428571429 | 8.0 | 0.9285714285714286 | 0.1346153846153846 |
19370 | 19370 | Huntington Hospital | 50438 | 2021-10-01 | Los Angeles | 37 | Southern California | 2.0 | 9.857142857142858 | 24.142857142857142 | 34.0 | 0.7100840336134454 | 0.0828402366863905 |
19371 | 19371 | John F Kennedy Memorial Hospital | 50534 | 2021-10-01 | Riverside | 65 | Southern California | 1.2857142857142858 | 14.142857142857142 | 9.857142857142858 | 24.0 | 0.4107142857142857 | 0.1304347826086956 |
19372 | 19372 | John Muir Medical Center - Concord Campus | 50496 | 2021-10-01 | Contra Costa | 13 | Bay Area | 7.142857142857143 | 7.857142857142858 | 28.142857142857142 | 36.0 | 0.7817460317460317 | 0.2538071065989848 |
19373 | 19373 | John Muir Medical Center - Walnut Creek Campus | 50180 | 2021-10-01 | Contra Costa | 13 | Bay Area | 9.142857142857142 | 7.428571428571431 | 40.57142857142857 | 48.0 | 0.8452380952380952 | 0.2253521126760563 |
19374 | 19374 | Kaiser Foundation Hosp So Sacramento | 50674 | 2021-10-01 | Sacramento | 67 | Greater Sacramento | 13.285714285714286 | 0.5714285714285694 | 29.857142857142858 | 30.428571428571427 | 0.9812206572769954 | 0.4449760765550239 |
19375 | 19375 | Kaiser Foundation Hospital | 50510 | 2021-10-01 | Marin | 41 | Bay Area | 2.142857142857143 | 0.8571428571428568 | 6.142857142857143 | 7.0 | 0.8775510204081634 | 0.3488372093023255 |
19376 | 19376 | Kaiser Foundation Hospital - Antioch | 50760 | 2021-10-01 | Contra Costa | 13 | Bay Area | 2.857142857142857 | 1.0 | 9.428571428571429 | 10.428571428571429 | 0.9041095890410958 | 0.303030303030303 |
19377 | 19377 | Kaiser Foundation Hospital - Baldwin Park | 50723 | 2021-10-01 | Los Angeles | 37 | Southern California | 2.2857142857142856 | 3.571428571428571 | 8.428571428571429 | 12.0 | 0.7023809523809524 | 0.2711864406779661 |
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 );