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-06-25
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23563 | 23563 | Adventist Health Bakersfield | 50455 | 2021-06-25 | Kern | 29 | San Joaquin Valley | 1.0 | 16.714285714285715 | 17.285714285714285 | 34.0 | 0.5084033613445378 | 0.0578512396694214 |
23564 | 23564 | Adventist Health Clearlake | 51317 | 2021-06-25 | Lake | 33 | Northern California | 0.5714285714285714 | 0.1428571428571428 | 3.857142857142857 | 4.0 | 0.9642857142857144 | 0.1481481481481481 |
23565 | 23565 | Adventist Health Delano | 50608 | 2021-06-25 | Kern | 29 | San Joaquin Valley | 0.0 | 1.142857142857143 | 1.4285714285714286 | 2.571428571428572 | 0.5555555555555556 | 0.0 |
23566 | 23566 | Adventist Health Hanford | 50121 | 2021-06-25 | Kings | 31 | San Joaquin Valley | 1.2857142857142858 | 4.285714285714287 | 10.714285714285714 | 15.0 | 0.7142857142857142 | 0.12 |
23567 | 23567 | Adventist Health Howard Memorial | 51310 | 2021-06-25 | Mendocino | 45 | Northern California | 0.0 | 1.0 | 3.0 | 4.0 | 0.75 | 0.0 |
23568 | 23568 | Adventist Health Lodi Memorial | 50336 | 2021-06-25 | San Joaquin | 77 | San Joaquin Valley | 2.0 | 0.4285714285714288 | 7.571428571428571 | 8.0 | 0.9464285714285714 | 0.2641509433962264 |
23569 | 23569 | Adventist Health Mendocino Coast | 51325 | 2021-06-25 | Mendocino | 45 | Northern California | 0.0 | 4.0 | 0.0 | 4.0 | 0.0 | |
23570 | 23570 | Adventist Health Simi Valley | 50236 | 2021-06-25 | Ventura | 111 | Southern California | 0.0 | 16.142857142857142 | 7.857142857142857 | 24.0 | 0.3273809523809524 | 0.0 |
23571 | 23571 | Adventist Health Sonora | 50335 | 2021-06-25 | Tuolumne | 109 | San Joaquin Valley | 1.2857142857142858 | 1.4285714285714288 | 4.571428571428571 | 6.0 | 0.7619047619047619 | 0.28125 |
23572 | 23572 | Adventist Health St. Helena | 50013 | 2021-06-25 | Napa | 55 | Bay Area | 1.0 | 1.7142857142857144 | 6.0 | 7.714285714285714 | 0.7777777777777778 | 0.1666666666666666 |
23573 | 23573 | Adventist Health Tehachapi Valley | 51301 | 2021-06-25 | Kern | 29 | San Joaquin Valley | 0.0 | 7.428571428571429 | 0.5714285714285714 | 8.0 | 0.0714285714285714 | 0.0 |
23574 | 23574 | Adventist Health Tulare | 50784 | 2021-06-25 | Tulare | 107 | San Joaquin Valley | 0.0 | 0.5714285714285712 | 2.571428571428572 | 3.142857142857143 | 0.8181818181818182 | 0.0 |
23575 | 23575 | Adventist Health Ukiah Valley | 50301 | 2021-06-25 | Mendocino | 45 | Northern California | 3.0 | 0.4285714285714279 | 6.428571428571429 | 6.857142857142857 | 0.9375 | 0.4666666666666667 |
23576 | 23576 | Adventist Health and Rideout | 50133 | 2021-06-25 | Yuba | 115 | Greater Sacramento | 4.0 | 5.714285714285715 | 18.285714285714285 | 24.0 | 0.7619047619047619 | 0.21875 |
23577 | 23577 | Ahmc Anaheim Regional Medical Center | 50226 | 2021-06-25 | Orange | 59 | Southern California | 0.0 | 0.0 | 5.857142857142857 | 5.857142857142857 | 1.0 | 0.0 |
23578 | 23578 | Ahmc Seton Medical Center | 50289 | 2021-06-25 | San Mateo | 81 | Bay Area | 0.0 | 0.5714285714285712 | 6.428571428571429 | 7.0 | 0.9183673469387756 | 0.0 |
23579 | 23579 | Alameda Hospital | 50211 | 2021-06-25 | Alameda | 1 | Bay Area | 0.0 | 3.7142857142857135 | 4.285714285714286 | 8.0 | 0.5357142857142857 | 0.0 |
23580 | 23580 | Alhambra Hospital Medical Center | 50281 | 2021-06-25 | Los Angeles | 37 | Southern California | 0.0 | 1.428571428571428 | 5.428571428571429 | 6.857142857142857 | 0.7916666666666667 | 0.0 |
23581 | 23581 | Alta Bates Summit Medical Center | 50043 | 2021-06-25 | Alameda | 1 | Bay Area | 3.571428571428572 | 21.857142857142858 | 14.142857142857142 | 36.0 | 0.3928571428571428 | 0.2525252525252525 |
23582 | 23582 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305 | 2021-06-25 | Alameda | 1 | Bay Area | 1.4285714285714286 | 19.42857142857143 | 10.571428571428571 | 30.0 | 0.3523809523809523 | 0.1351351351351351 |
23583 | 23583 | Alvarado Hospital Medical Center | 50757 | 2021-06-25 | San Diego | 73 | Southern California | 0.0 | 4.7142857142857135 | 7.428571428571429 | 12.142857142857142 | 0.611764705882353 | 0.0 |
23584 | 23584 | Anaheim Global Medical Center | 50744 | 2021-06-25 | Orange | 59 | Southern California | 0.0 | 15.285714285714285 | 6.714285714285714 | 22.0 | 0.3051948051948052 | 0.0 |
23585 | 23585 | Antelope Valley Hospital | 50056 | 2021-06-25 | Los Angeles | 37 | Southern California | 2.2857142857142856 | 1.0 | 29.0 | 30.0 | 0.9666666666666668 | 0.0788177339901477 |
23586 | 23586 | Arrowhead Regional Medical Center | 50245 | 2021-06-25 | San Bernardino | 71 | Southern California | 2.2857142857142856 | 18.142857142857142 | 29.857142857142858 | 48.0 | 0.6220238095238095 | 0.0765550239234449 |
23587 | 23587 | Bakersfield Heart Hospital | 50724 | 2021-06-25 | Kern | 29 | San Joaquin Valley | 1.4285714285714286 | 3.428571428571429 | 6.571428571428571 | 10.0 | 0.6571428571428571 | 0.2173913043478261 |
23588 | 23588 | Bakersfield Memorial Hospital | 50036 | 2021-06-25 | Kern | 29 | San Joaquin Valley | 3.0 | 1.2857142857142847 | 20.857142857142858 | 22.142857142857142 | 0.9419354838709678 | 0.1438356164383561 |
23589 | 23589 | Barlow Respiratory Hospital | 52031 | 2021-06-25 | Los Angeles | 37 | Southern California | 0.0 | 4.0 | 2.0 | 6.0 | 0.3333333333333333 | 0.0 |
23590 | 23590 | Barstow Community Hospital | 50298 | 2021-06-25 | San Bernardino | 71 | Southern California | 1.1428571428571428 | 1.8571428571428568 | 2.142857142857143 | 4.0 | 0.5357142857142857 | 0.5333333333333333 |
23591 | 23591 | Barton Memorial Hospital | 50352 | 2021-06-25 | El Dorado | 17 | Greater Sacramento | 0.0 | 3.142857142857143 | 2.857142857142857 | 6.0 | 0.4761904761904762 | 0.0 |
23592 | 23592 | Beverly Hospital | 50350 | 2021-06-25 | Los Angeles | 37 | Southern California | 0.0 | 15.285714285714286 | 9.714285714285714 | 25.0 | 0.3885714285714285 | 0.0 |
23593 | 23593 | California Hospital Medical Center LA | 50149 | 2021-06-25 | Los Angeles | 37 | Southern California | 1.0 | 15.0 | 15.0 | 30.0 | 0.5 | 0.0666666666666666 |
23594 | 23594 | California Pacific Medical Center - Mission Bernal | 50055 | 2021-06-25 | San Francisco | 75 | Bay Area | 1.0 | 6.0 | 4.0 | 10.0 | 0.4 | 0.25 |
23595 | 23595 | California Pacific Medical Center- Van Ness Campus | 50047 | 2021-06-25 | San Francisco | 75 | Bay Area | 0.5714285714285714 | 11.714285714285715 | 24.285714285714285 | 36.0 | 0.6746031746031745 | 0.0235294117647058 |
23596 | 23596 | California Pacific Medical Ctr-davies Campus Hosp | 50008 | 2021-06-25 | San Francisco | 75 | Bay Area | 0.0 | 2.1428571428571432 | 5.857142857142857 | 8.0 | 0.7321428571428571 | 0.0 |
23597 | 23597 | Casa Colina Hospital | 50782 | 2021-06-25 | Los Angeles | 37 | Southern California | 0.0 | 2.857142857142857 | 3.142857142857143 | 6.0 | 0.5238095238095238 | 0.0 |
23598 | 23598 | Cedars-Sinai Marina Del Rey Hospital | 50740 | 2021-06-25 | Los Angeles | 37 | Southern California | 0.0 | 2.0 | 10.571428571428571 | 12.571428571428571 | 0.8409090909090909 | 0.0 |
23599 | 23599 | Cedars-Sinai Medical Center | 50625 | 2021-06-25 | Los Angeles | 37 | Southern California | 2.4285714285714284 | 22.714285714285708 | 85.28571428571429 | 108.0 | 0.7896825396825398 | 0.0284757118927973 |
23600 | 23600 | Centinela Hospital Medical Center | 50739 | 2021-06-25 | Los Angeles | 37 | Southern California | 1.2857142857142858 | 10.0 | 19.428571428571427 | 29.428571428571427 | 0.6601941747572815 | 0.0661764705882353 |
23601 | 23601 | Chapman Global Medical Center | 50745 | 2021-06-25 | Orange | 59 | Southern California | 0.0 | 2.2857142857142856 | 1.1428571428571428 | 3.4285714285714284 | 0.3333333333333333 | 0.0 |
23602 | 23602 | Chinese Hospital | 50407 | 2021-06-25 | San Francisco | 75 | Bay Area | 0.0 | 2.571428571428572 | 3.4285714285714284 | 6.0 | 0.5714285714285714 | 0.0 |
23603 | 23603 | Chino Valley Medical Center | 50586 | 2021-06-25 | San Bernardino | 71 | Southern California | 0.0 | 0.4285714285714279 | 6.142857142857143 | 6.571428571428571 | 0.9347826086956522 | 0.0 |
23604 | 23604 | City of Hope Helford Clinical Research Hospital | 50146 | 2021-06-25 | Los Angeles | 37 | Southern California | 0.0 | 5.428571428571429 | 12.571428571428571 | 18.0 | 0.6984126984126984 | 0.0 |
23605 | 23605 | Clovis Community Medical Center | 50492 | 2021-06-25 | Fresno | 19 | San Joaquin Valley | 0.0 | 7.571428571428569 | 17.857142857142858 | 25.428571428571427 | 0.702247191011236 | 0.0 |
23606 | 23606 | Coast Plaza Hospital | 50771 | 2021-06-25 | Los Angeles | 37 | Southern California | 0.0 | 3.857142857142857 | 3.142857142857143 | 7.0 | 0.4489795918367347 | 0.0 |
23607 | 23607 | College Medical Center | 50776 | 2021-06-25 | Los Angeles | 37 | Southern California | 0.0 | 5.166666666666666 | 8.833333333333334 | 14.0 | 0.630952380952381 | 0.0 |
23608 | 23608 | Colusa Medical Center | 50783 | 2021-06-25 | Colusa | 11 | Greater Sacramento | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
23609 | 23609 | Community Hospital of Huntington Park | 50091 | 2021-06-25 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 5.285714285714286 | 5.285714285714286 | 1.0 | 0.0 |
23610 | 23610 | Community Hospital of San Bernardino | 50089 | 2021-06-25 | San Bernardino | 71 | Southern California | 0.0 | 20.57142857142857 | 3.857142857142857 | 24.428571428571427 | 0.1578947368421052 | 0.0 |
23611 | 23611 | Community Hospital of the Monterey Peninsula | 50145 | 2021-06-25 | Monterey | 53 | Bay Area | 0.0 | 13.714285714285714 | 12.285714285714286 | 26.0 | 0.4725274725274725 | 0.0 |
23612 | 23612 | Community Memorial Hospital San Buenaventura | 50394 | 2021-06-25 | Ventura | 111 | Southern California | 0.0 | 2.2857142857142847 | 14.857142857142858 | 17.142857142857142 | 0.8666666666666667 | 0.0 |
23613 | 23613 | Community Regional Medical Center | 50060 | 2021-06-25 | Fresno | 19 | San Joaquin Valley | 4.285714285714286 | 7.714285714285722 | 67.14285714285714 | 74.85714285714286 | 0.8969465648854961 | 0.0638297872340425 |
23614 | 23614 | Contra Costa Regional Medical Center | 50276 | 2021-06-25 | Contra Costa | 13 | Bay Area | 3.142857142857143 | 3.0 | 15.0 | 18.0 | 0.8333333333333334 | 0.2095238095238095 |
23615 | 23615 | Corona Regional Medical Center | 50329 | 2021-06-25 | Riverside | 65 | Southern California | 1.2857142857142858 | 7.7142857142857135 | 14.285714285714286 | 22.0 | 0.6493506493506493 | 0.09 |
23616 | 23616 | Dameron Hospital | 50122 | 2021-06-25 | San Joaquin | 77 | San Joaquin Valley | 0.0 | 1.142857142857144 | 9.714285714285714 | 10.857142857142858 | 0.894736842105263 | 0.0 |
23617 | 23617 | Desert Regional Medical Center | 50243 | 2021-06-25 | Riverside | 65 | Southern California | 1.8571428571428568 | 1.428571428571427 | 29.857142857142858 | 31.285714285714285 | 0.954337899543379 | 0.062200956937799 |
23618 | 23618 | Desert Valley Hospital | 50709 | 2021-06-25 | San Bernardino | 71 | Southern California | 6.857142857142857 | 1.2857142857142847 | 16.714285714285715 | 18.0 | 0.9285714285714286 | 0.4102564102564102 |
23619 | 23619 | Doctors Hospital of Manteca | 50118 | 2021-06-25 | San Joaquin | 77 | San Joaquin Valley | 1.0 | 5.428571428571429 | 2.571428571428572 | 8.0 | 0.3214285714285714 | 0.3888888888888888 |
23620 | 23620 | Doctors Hospital of Riverside, LLC | 50102 | 2021-06-25 | Riverside | 65 | Southern California | 0.0 | 5.142857142857143 | 6.857142857142857 | 12.0 | 0.5714285714285714 | 0.0 |
23621 | 23621 | Doctors Medical Center | 50464 | 2021-06-25 | Stanislaus | 99 | San Joaquin Valley | 4.428571428571429 | 9.42857142857143 | 34.57142857142857 | 44.0 | 0.7857142857142857 | 0.128099173553719 |
23622 | 23622 | Dominican Hospital | 50242 | 2021-06-25 | Santa Cruz | 87 | Bay Area | 0.0 | 4.142857142857142 | 11.857142857142858 | 16.0 | 0.7410714285714286 | 0.0 |
23623 | 23623 | East Los Angeles Doctors Hospital | 50641 | 2021-06-25 | Los Angeles | 37 | Southern California | 0.0 | 5.0 | 5.0 | 10.0 | 0.5 | 0.0 |
23624 | 23624 | Eden Medical Center | 50488 | 2021-06-25 | Alameda | 1 | Bay Area | 0.0 | 9.428571428571429 | 14.571428571428571 | 24.0 | 0.6071428571428571 | 0.0 |
23625 | 23625 | Eisenhower Medical Center | 50573 | 2021-06-25 | Riverside | 65 | Southern California | 1.0 | 3.0000000000000018 | 14.714285714285714 | 17.714285714285715 | 0.8306451612903225 | 0.0679611650485436 |
23626 | 23626 | El Camino Hospital | 50308 | 2021-06-25 | Santa Clara | 85 | Bay Area | 0.0 | 13.571428571428571 | 18.428571428571427 | 32.0 | 0.5758928571428571 | 0.0 |
23627 | 23627 | El Centro Regional Medical Center | 50045 | 2021-06-25 | Imperial | 25 | Southern California | 0.0 | 7.0 | 5.0 | 12.0 | 0.4166666666666667 | 0.0 |
23628 | 23628 | Emanate Health Foothill Presbyterian Hospital | 50597 | 2021-06-25 | Los Angeles | 37 | Southern California | 0.5714285714285714 | 10.428571428571429 | 7.571428571428571 | 18.0 | 0.4206349206349206 | 0.0754716981132075 |
23629 | 23629 | Emanate Health Inter-community Hospital | 50382 | 2021-06-25 | Los Angeles | 37 | Southern California | 1.1428571428571428 | 10.0 | 30.0 | 40.0 | 0.75 | 0.038095238095238 |
23630 | 23630 | Emanuel Medical Center | 50179 | 2021-06-25 | Stanislaus | 99 | San Joaquin Valley | 0.0 | 8.857142857142858 | 3.142857142857143 | 12.0 | 0.2619047619047619 | 0.0 |
23631 | 23631 | Encino Hospital Medical Center | 50158 | 2021-06-25 | Los Angeles | 37 | Southern California | 0.0 | 0.1428571428571428 | 3.2857142857142856 | 3.4285714285714284 | 0.9583333333333334 | 0.0 |
23632 | 23632 | Enloe Medical Center | 50039 | 2021-06-25 | Butte | 7 | Greater Sacramento | 0.0 | 10.571428571428571 | 13.428571428571429 | 24.0 | 0.5595238095238095 | 0.0 |
23633 | 23633 | Fairchild Medical Center | 51316 | 2021-06-25 | Siskiyou | 93 | Northern California | 0.0 | 0.4285714285714288 | 3.2857142857142856 | 3.7142857142857135 | 0.8846153846153846 | 0.0 |
23634 | 23634 | Foothill Regional Medical Center | 50780 | 2021-06-25 | Orange | 59 | Southern California | 0.0 | 7.0 | 6.0 | 13.0 | 0.4615384615384615 | 0.0 |
23635 | 23635 | Fountain Valley Regional Hospital & Medical Center | 50570 | 2021-06-25 | Orange | 59 | Southern California | 0.5714285714285714 | 3.8571428571428577 | 21.142857142857142 | 25.0 | 0.8457142857142856 | 0.027027027027027 |
23636 | 23636 | French Hospital Medical Center | 50232 | 2021-06-25 | San Luis Obispo | 79 | Southern California | 0.0 | 1.5714285714285712 | 7.0 | 8.571428571428571 | 0.8166666666666667 | 0.0 |
23637 | 23637 | Fresno Heart and Surgical Hospital | 50732 | 2021-06-25 | Fresno | 19 | San Joaquin Valley | 0.0 | 2.5714285714285703 | 7.142857142857143 | 9.714285714285714 | 0.7352941176470589 | 0.0 |
23638 | 23638 | Garden Grove Hospital & Medical Center | 50230 | 2021-06-25 | Orange | 59 | Southern California | 0.0 | 0.7142857142857144 | 6.714285714285714 | 7.428571428571429 | 0.903846153846154 | 0.0 |
23639 | 23639 | Garfield Medical Center | 50737 | 2021-06-25 | Los Angeles | 37 | Southern California | 0.0 | 13.571428571428571 | 8.428571428571429 | 22.0 | 0.3831168831168831 | 0.0 |
23640 | 23640 | Glendale Adventist Medical Center | 50239 | 2021-06-25 | Los Angeles | 37 | Southern California | 0.0 | 1.2857142857142847 | 20.142857142857142 | 21.428571428571427 | 0.94 | 0.0 |
23641 | 23641 | Glendale Mem Hospital & Health Center | 50058 | 2021-06-25 | Los Angeles | 37 | Southern California | 0.5714285714285714 | 0.0 | 7.285714285714286 | 7.285714285714286 | 1.0 | 0.0784313725490196 |
23642 | 23642 | Goleta Valley Cottage Hospital | 50357 | 2021-06-25 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.8571428571428571 | 0.8571428571428571 | 1.0 | 0.0 |
23643 | 23643 | Good Samaritan Hospital | 50257 | 2021-06-25 | Kern | 29 | San Joaquin Valley | 0.0 | 4.0 | 0.0 | 4.0 | 0.0 | |
23644 | 23644 | Good Samaritan Hospital | 50380 | 2021-06-25 | Santa Clara | 85 | Bay Area | 0.0 | 15.285714285714285 | 21.714285714285715 | 37.0 | 0.5868725868725869 | 0.0 |
23645 | 23645 | Greater El Monte Community Hospital | 50738 | 2021-06-25 | Los Angeles | 37 | Southern California | 0.0 | 4.75 | 5.25 | 10.0 | 0.525 | 0.0 |
23646 | 23646 | Grossmont Hospital | 50026 | 2021-06-25 | San Diego | 73 | Southern California | 0.8571428571428571 | 13.714285714285715 | 61.285714285714285 | 75.0 | 0.8171428571428572 | 0.0139860139860139 |
23647 | 23647 | Hazel Hawkins Memorial Hospital | 51337 | 2021-06-25 | San Benito | 69 | San Joaquin Valley | 0.8571428571428571 | 1.0 | 3.0 | 4.0 | 0.75 | 0.2857142857142857 |
23648 | 23648 | Healdsburg Hospital | 51321 | 2021-06-25 | Sonoma | 97 | Bay Area | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
23649 | 23649 | Hemet Global Medical Center | 50390 | 2021-06-25 | Riverside | 65 | Southern California | 0.0 | 13.285714285714286 | 12.714285714285714 | 26.0 | 0.489010989010989 | 0.0 |
23650 | 23650 | Henry Mayo Newhall Hospital | 50624 | 2021-06-25 | Los Angeles | 37 | Southern California | 4.285714285714286 | 3.7142857142857153 | 18.857142857142858 | 22.571428571428573 | 0.8354430379746836 | 0.2272727272727272 |
23651 | 23651 | Hi-desert Medical Center | 50279 | 2021-06-25 | San Bernardino | 71 | Southern California | 1.1428571428571428 | 0.7142857142857144 | 3.2857142857142856 | 4.0 | 0.8214285714285714 | 0.3478260869565217 |
23652 | 23652 | Highland Hospital | 50320 | 2021-06-25 | Alameda | 1 | Bay Area | 0.0 | 11.285714285714285 | 21.714285714285715 | 33.0 | 0.658008658008658 | 0.0 |
23653 | 23653 | Hoag Memorial Hospital Presbyterian | 50224 | 2021-06-25 | Orange | 59 | Southern California | 0.0 | 18.428571428571427 | 24.571428571428573 | 43.0 | 0.5714285714285715 | 0.0 |
23654 | 23654 | Hollywood Presbyterian Medical Center | 50063 | 2021-06-25 | Los Angeles | 37 | Southern California | 0.0 | 7.857142857142858 | 16.142857142857142 | 24.0 | 0.6726190476190476 | 0.0 |
23655 | 23655 | Huntington Beach Hospital | 50526 | 2021-06-25 | Orange | 59 | Southern California | 0.0 | 1.0000000000000002 | 1.5714285714285714 | 2.571428571428572 | 0.611111111111111 | 0.0 |
23656 | 23656 | Huntington Hospital | 50438 | 2021-06-25 | Los Angeles | 37 | Southern California | 1.1428571428571428 | 51.0 | 17.0 | 68.0 | 0.25 | 0.0672268907563025 |
23657 | 23657 | John F Kennedy Memorial Hospital | 50534 | 2021-06-25 | Riverside | 65 | Southern California | 0.0 | 18.285714285714285 | 5.714285714285714 | 24.0 | 0.2380952380952381 | 0.0 |
23658 | 23658 | John Muir Medical Center - Concord Campus | 50496 | 2021-06-25 | Contra Costa | 13 | Bay Area | 1.8333333333333333 | 16.833333333333332 | 19.166666666666668 | 36.0 | 0.5324074074074074 | 0.0956521739130434 |
23659 | 23659 | John Muir Medical Center - Walnut Creek Campus | 50180 | 2021-06-25 | Contra Costa | 13 | Bay Area | 0.0 | 5.5 | 42.5 | 48.0 | 0.8854166666666666 | 0.0 |
23660 | 23660 | Kaiser Foundation Hosp So Sacramento | 50674 | 2021-06-25 | Sacramento | 67 | Greater Sacramento | 3.8333333333333335 | 1.833333333333336 | 27.83333333333333 | 29.666666666666668 | 0.9382022471910112 | 0.1377245508982036 |
23661 | 23661 | Kaiser Foundation Hospital | 50510 | 2021-06-25 | Marin | 41 | Bay Area | 0.0 | 0.5 | 5.166666666666667 | 5.666666666666667 | 0.9117647058823528 | 0.0 |
23662 | 23662 | Kaiser Foundation Hospital - Antioch | 50760 | 2021-06-25 | Contra Costa | 13 | Bay Area | 0.0 | 0.6666666666666661 | 4.666666666666667 | 5.333333333333333 | 0.8750000000000001 | 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 );