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.
38,919 rows sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38819 | 38819 | Sutter Delta Medical Center | 50523 | 2020-07-17 | Contra Costa | 13 | Bay Area | 3.6 | 0.5 | 11.5 | 12.0 | 0.9583333333333334 | 0.3130434782608696 |
38818 | 38818 | Sutter Davis Hospital | 50537 | 2020-07-17 | Yolo | 113 | Greater Sacramento | 1.2 | 0.0 | 6.0 | 6.0 | 1.0 | 0.1999999999999999 |
38817 | 38817 | Sutter Coast Hospital | 50417 | 2020-07-17 | Del Norte | 15 | Northern California | 0.0 | 2.5 | 3.5 | 6.0 | 0.5833333333333334 | 0.0 |
38816 | 38816 | Sutter Auburn Faith Hospital | 50498 | 2020-07-17 | Placer | 61 | Greater Sacramento | 0.0 | 6.0 | 2.0 | 8.0 | 0.25 | 0.0 |
38815 | 38815 | Sutter Amador Hospital | 50014 | 2020-07-17 | Amador | 5 | Greater Sacramento | 0.0 | 1.5 | 4.5 | 6.0 | 0.75 | 0.0 |
38814 | 38814 | Stanislaus Surgical Hospital | 50726 | 2020-07-17 | Stanislaus | 99 | San Joaquin Valley | 0.0 | 14.0 | 0.0 | 14.0 | 0.0 | |
38813 | 38813 | Stanford Health Care - Valleycare | 50283 | 2020-07-17 | Alameda | 1 | Bay Area | 2.833333333333333 | 14.0 | 8.0 | 22.0 | 0.3636363636363636 | 0.3541666666666667 |
38812 | 38812 | Stanford Health Care | 50441 | 2020-07-17 | Santa Clara | 85 | Bay Area | 11.333333333333334 | 11.0 | 86.0 | 97.0 | 0.8865979381443299 | 0.1317829457364341 |
38811 | 38811 | St. Rose Hospital | 50002 | 2020-07-17 | Alameda | 1 | Bay Area | 0.0 | 9.0 | 6.0 | 15.0 | 0.4 | 0.0 |
38810 | 38810 | St. Mary's Medical Center | 50457 | 2020-07-17 | San Francisco | 75 | Bay Area | 1.0 | 11.0 | 5.0 | 16.0 | 0.3125 | 0.2 |
38809 | 38809 | St. Mary Medical Center | 50300 | 2020-07-17 | San Bernardino | 71 | Southern California | 11.142857142857142 | 0.0 | 24.0 | 24.0 | 1.0 | 0.4642857142857142 |
38808 | 38808 | St. Mary Medical Center | 50191 | 2020-07-17 | Los Angeles | 37 | Southern California | 11.0 | 8.0 | 32.0 | 40.0 | 0.8 | 0.34375 |
38807 | 38807 | St. Joseph's Medical Center of Stockton | 50084 | 2020-07-17 | San Joaquin | 77 | San Joaquin Valley | 0.0 | 2.0 | 46.0 | 48.0 | 0.9583333333333334 | 0.0 |
38806 | 38806 | St. Johns Regional Medical Center | 50082 | 2020-07-17 | Ventura | 111 | Southern California | 7.166666666666667 | 0.0 | 19.0 | 19.0 | 1.0 | 0.3771929824561403 |
38805 | 38805 | St. Johns Hospital Camarillo | 50616 | 2020-07-17 | Ventura | 111 | Southern California | 2.6666666666666665 | 0.0 | 8.0 | 8.0 | 1.0 | 0.3333333333333333 |
38804 | 38804 | St. Elizabeth Community Hospital | 50042 | 2020-07-17 | Tehama | 103 | Northern California | 0.0 | 5.0 | 3.0 | 8.0 | 0.375 | 0.0 |
38803 | 38803 | St. Bernardine Medical Center | 50129 | 2020-07-17 | San Bernardino | 71 | Southern California | 5.333333333333333 | 11.0 | 26.0 | 37.0 | 0.7027027027027027 | 0.2051282051282051 |
38802 | 38802 | Southwest Healthcare System | 50701 | 2020-07-17 | Riverside | 65 | Southern California | 11.0 | 27.0 | 22.0 | 49.0 | 0.4489795918367347 | 0.5 |
38801 | 38801 | Southern California Hospital at Hollywood | 50135 | 2020-07-17 | Los Angeles | 37 | Southern California | 11.428571428571429 | 25.28571428571429 | 22.428571428571427 | 47.71428571428572 | 0.4700598802395209 | 0.5095541401273885 |
38800 | 38800 | South Coast Global Medical Center | 50747 | 2020-07-17 | Orange | 59 | Southern California | 4.666666666666667 | 1.4999999999999991 | 6.666666666666667 | 8.166666666666666 | 0.816326530612245 | 0.7000000000000001 |
38799 | 38799 | Sonoma Valley Hospital | 50090 | 2020-07-17 | Sonoma | 97 | Bay Area | 1.4285714285714286 | 3.1428571428571432 | 2.2857142857142856 | 5.428571428571429 | 0.4210526315789473 | 0.625 |
38798 | 38798 | Sierra View Medical Center | 50261 | 2020-07-17 | Tulare | 107 | San Joaquin Valley | 1.3333333333333333 | 2.666666666666667 | 4.333333333333333 | 7.0 | 0.619047619047619 | 0.3076923076923077 |
38797 | 38797 | Sierra Nevada Memorial Hospital | 50150 | 2020-07-17 | Nevada | 57 | Greater Sacramento | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
38796 | 38796 | Sherman Oaks Hospital | 50755 | 2020-07-17 | Los Angeles | 37 | Southern California | 4.428571428571429 | 2.1428571428571423 | 11.857142857142858 | 14.0 | 0.8469387755102041 | 0.3734939759036144 |
38795 | 38795 | Shasta Regional Medical Center | 50764 | 2020-07-17 | Shasta | 89 | Northern California | 0.0 | 1.142857142857144 | 11.142857142857142 | 12.285714285714286 | 0.9069767441860463 | 0.0 |
38794 | 38794 | Sharp Memorial Hospital | 50100 | 2020-07-17 | San Diego | 73 | Southern California | 20.166666666666668 | 7.0 | 37.0 | 44.0 | 0.8409090909090909 | 0.545045045045045 |
38793 | 38793 | Sharp Coronado Hospital and Hlthcr Center | 50234 | 2020-07-17 | San Diego | 73 | Southern California | 1.0 | 1.0 | 5.0 | 6.0 | 0.8333333333333334 | 0.2 |
38792 | 38792 | Sharp Chula Vista Medical Center | 50222 | 2020-07-17 | San Diego | 73 | Southern California | 23.33333333333333 | 0.0 | 36.0 | 36.0 | 1.0 | 0.6481481481481481 |
38791 | 38791 | Sequoia Hospital | 50197 | 2020-07-17 | San Mateo | 81 | Bay Area | 1.0 | 1.0 | 9.0 | 10.0 | 0.9 | 0.1111111111111111 |
38790 | 38790 | Select Specialty Hospital - San Diego | 52044 | 2020-07-17 | San Diego | 73 | Southern California | 0.0 | 0.0 | 6.0 | 6.0 | 1.0 | 0.0 |
38789 | 38789 | Scripps Mercy Hospital | 50077 | 2020-07-17 | San Diego | 73 | Southern California | 14.0 | 7.0 | 49.0 | 56.0 | 0.875 | 0.2857142857142857 |
38788 | 38788 | Scripps Memorial Hospital La Jolla | 50324 | 2020-07-17 | San Diego | 73 | Southern California | 13.0 | 3.0 | 56.0 | 59.0 | 0.9491525423728814 | 0.2321428571428571 |
38787 | 38787 | Scripps Memorial Hospital - Encinitas | 50503 | 2020-07-17 | San Diego | 73 | Southern California | 0.0 | 2.0 | 10.0 | 12.0 | 0.8333333333333334 | 0.0 |
38786 | 38786 | Scripps Green Hospital | 50424 | 2020-07-17 | San Diego | 73 | Southern California | 0.0 | 10.0 | 14.0 | 24.0 | 0.5833333333333334 | 0.0 |
38785 | 38785 | Santa Paula Hospital | 2020-07-17 | Ventura | 111 | Southern California | 2.571428571428572 | 1.5714285714285712 | 4.428571428571429 | 6.0 | 0.7380952380952381 | 0.5806451612903226 | |
38784 | 38784 | Santa Monica - UCLA Medical Center & Orthopaedic Hospital | 50112 | 2020-07-17 | Los Angeles | 37 | Southern California | 2.4285714285714284 | 5.428571428571427 | 15.857142857142858 | 21.285714285714285 | 0.7449664429530202 | 0.1531531531531531 |
38783 | 38783 | Santa Clara Valley Medical Center | 50038 | 2020-07-17 | Santa Clara | 85 | Bay Area | 7.666666666666667 | 2.333333333333332 | 23.0 | 25.33333333333333 | 0.9078947368421052 | 0.3333333333333333 |
38782 | 38782 | Santa Barbara Cottage Hospital | 50396 | 2020-07-17 | Santa Barbara | 83 | Southern California | 8.571428571428571 | 27.0 | 30.0 | 57.0 | 0.5263157894736842 | 0.2857142857142857 |
38781 | 38781 | San Ramon Regional Medical Center | 50689 | 2020-07-17 | Contra Costa | 13 | Bay Area | 0.0 | 12.0 | 0.0 | 12.0 | 0.0 | |
38780 | 38780 | San Mateo Medical Center | 50113 | 2020-07-17 | San Mateo | 81 | Bay Area | 0.7142857142857143 | 3.0 | 4.0 | 7.0 | 0.5714285714285714 | 0.1785714285714285 |
38779 | 38779 | San Joaquin General Hospital | 50167 | 2020-07-17 | San Joaquin | 77 | San Joaquin Valley | 13.714285714285714 | 5.0 | 25.166666666666668 | 30.166666666666668 | 0.8342541436464088 | 0.5449385052034058 |
38778 | 38778 | San Gorgonio Memorial Hospital | 50054 | 2020-07-17 | Riverside | 65 | Southern California | 6.142857142857143 | 6.7142857142857135 | 9.285714285714286 | 16.0 | 0.5803571428571429 | 0.6615384615384615 |
38777 | 38777 | San Gabriel Valley Medical Center | 50132 | 2020-07-17 | Los Angeles | 37 | Southern California | 2.142857142857143 | 9.5 | 9.5 | 19.0 | 0.5 | 0.225563909774436 |
38776 | 38776 | San Dimas Community Hospital | 50588 | 2020-07-17 | Los Angeles | 37 | Southern California | 9.142857142857142 | 0.8571428571428577 | 12.0 | 12.857142857142858 | 0.9333333333333332 | 0.7619047619047619 |
38775 | 38775 | San Antonio Regional Hospital | 50099 | 2020-07-17 | San Bernardino | 71 | Southern California | 23.142857142857142 | 0.0 | 33.42857142857143 | 33.42857142857143 | 1.0 | 0.6923076923076923 |
38774 | 38774 | Saint John's Health Center | 50290 | 2020-07-17 | Los Angeles | 37 | Southern California | 3.1666666666666665 | 2.0 | 12.0 | 14.0 | 0.8571428571428571 | 0.2638888888888889 |
38773 | 38773 | Saint Francis Memorial Hospital | 50152 | 2020-07-17 | San Francisco | 75 | Bay Area | 2.1666666666666665 | 12.0 | 8.0 | 20.0 | 0.4 | 0.2708333333333333 |
38772 | 38772 | Saint Francis Medical Center | 50104 | 2020-07-17 | Los Angeles | 37 | Southern California | 20.714285714285715 | 33.857142857142854 | 35.142857142857146 | 69.0 | 0.5093167701863355 | 0.589430894308943 |
38771 | 38771 | Saint Agnes Medical Center | 50093 | 2020-07-17 | Fresno | 19 | San Joaquin Valley | 7.857142857142857 | 4.0 | 25.0 | 29.0 | 0.8620689655172413 | 0.3142857142857143 |
38770 | 38770 | Ronald Reagan UCLA Medical Center | 50262 | 2020-07-17 | Los Angeles | 37 | Southern California | 10.857142857142858 | 8.57142857142857 | 99.57142857142856 | 108.14285714285714 | 0.9207397622192868 | 0.1090387374461979 |
38769 | 38769 | Riverside University Health System-medical Center | 50292 | 2020-07-17 | Riverside | 65 | Southern California | 15.2 | 0.0 | 19.0 | 19.0 | 1.0 | 0.7999999999999999 |
38768 | 38768 | Riverside Community Hospital | 50022 | 2020-07-17 | Riverside | 65 | Southern California | 24.571428571428573 | 12.285714285714285 | 62.71428571428572 | 75.0 | 0.8361904761904762 | 0.3917995444191344 |
38767 | 38767 | Ridgecrest Regional Hospital | 51333 | 2020-07-17 | Kern | 29 | San Joaquin Valley | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
38766 | 38766 | Regional Medical Center of San Jose | 50125 | 2020-07-17 | Santa Clara | 85 | Bay Area | 7.0 | 0.8571428571428612 | 36.85714285714285 | 37.71428571428572 | 0.9772727272727272 | 0.189922480620155 |
38765 | 38765 | Redlands Community Hospital | 50272 | 2020-07-17 | San Bernardino | 71 | Southern California | 6.142857142857143 | 0.5 | 13.5 | 14.0 | 0.9642857142857144 | 0.455026455026455 |
38764 | 38764 | Providence St. Jude Medical Center | 50168 | 2020-07-17 | Orange | 59 | Southern California | 7.0 | 4.5 | 32.0 | 36.5 | 0.8767123287671232 | 0.21875 |
38763 | 38763 | Providence St. Joseph Hospital | 50069 | 2020-07-17 | Orange | 59 | Southern California | 8.285714285714286 | 2.0 | 28.0 | 30.0 | 0.9333333333333332 | 0.2959183673469388 |
38762 | 38762 | Providence St. Joseph Hospital | 50006 | 2020-07-17 | Humboldt | 23 | Northern California | 0.0 | 0.0 | 12.0 | 12.0 | 1.0 | 0.0 |
38761 | 38761 | Providence Santa Rosa Memorial Hospital | 50174 | 2020-07-17 | Sonoma | 97 | Bay Area | 2.333333333333333 | 4.0 | 21.0 | 25.0 | 0.84 | 0.1111111111111111 |
38760 | 38760 | Providence Saint Joseph Medical Center | 50235 | 2020-07-17 | Los Angeles | 37 | Southern California | 13.428571428571429 | 3.5 | 34.0 | 37.5 | 0.9066666666666666 | 0.3949579831932773 |
38759 | 38759 | Providence Redwood Memorial Hospital | 51318 | 2020-07-17 | Humboldt | 23 | Northern California | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
38758 | 38758 | Providence Queen of the Valley Medical Center | 50009 | 2020-07-17 | Napa | 55 | Bay Area | 1.2857142857142858 | 0.5 | 7.5 | 8.0 | 0.9375 | 0.1714285714285714 |
38757 | 38757 | Providence Mission Hospital | 50567 | 2020-07-17 | Orange | 59 | Southern California | 15.714285714285714 | 3.0 | 48.5 | 51.5 | 0.941747572815534 | 0.3240058910162002 |
38756 | 38756 | Providence Little Company of Mary Medical Center Torrance | 50353 | 2020-07-17 | Los Angeles | 37 | Southern California | 5.428571428571429 | 2.0 | 20.0 | 22.0 | 0.9090909090909092 | 0.2714285714285714 |
38755 | 38755 | Providence Little Company of Mary Medical Center San Pedro | 50078 | 2020-07-17 | Los Angeles | 37 | Southern California | 2.0 | 0.5 | 8.5 | 9.0 | 0.9444444444444444 | 0.2352941176470588 |
38754 | 38754 | Providence Holy Cross Medical Center | 50278 | 2020-07-17 | Los Angeles | 37 | Southern California | 8.285714285714286 | 4.5 | 24.0 | 28.5 | 0.8421052631578947 | 0.3452380952380953 |
38753 | 38753 | Providence Cedars Sinai Tarzana Medical Center | 50761 | 2020-07-17 | Los Angeles | 37 | Southern California | 3.0 | 0.0 | 12.0 | 12.0 | 1.0 | 0.25 |
38752 | 38752 | Pomona Valley Hospital Medical Center | 50231 | 2020-07-17 | Los Angeles | 37 | Southern California | 26.666666666666668 | 5.0 | 45.0 | 50.0 | 0.9 | 0.5925925925925927 |
38751 | 38751 | Placentia Linda Hospital | 50589 | 2020-07-17 | Orange | 59 | Southern California | 5.0 | 1.0 | 7.0 | 8.0 | 0.875 | 0.7142857142857143 |
38750 | 38750 | Pih Health Hospital-Whittier | 50169 | 2020-07-17 | Los Angeles | 37 | Southern California | 12.0 | 20.571428571428573 | 27.428571428571427 | 48.0 | 0.5714285714285714 | 0.4375 |
38749 | 38749 | Pih Health Good Samaritan Hospital | 50471 | 2020-07-17 | Los Angeles | 37 | Southern California | 12.571428571428571 | 25.0 | 31.714285714285715 | 56.71428571428572 | 0.5591939546599496 | 0.3963963963963964 |
38748 | 38748 | Pih Health Downey Hospital | 50393 | 2020-07-17 | Los Angeles | 37 | Southern California | 18.857142857142858 | 19.33333333333333 | 20.666666666666668 | 40.0 | 0.5166666666666667 | 0.912442396313364 |
38747 | 38747 | Paradise Valley Hospital | 50024 | 2020-07-17 | San Diego | 73 | Southern California | 3.857142857142857 | 10.714285714285715 | 4.285714285714286 | 15.0 | 0.2857142857142857 | 0.9 |
38746 | 38746 | Palomar Medical Center Poway | 50636 | 2020-07-17 | San Diego | 73 | Southern California | 2.0 | 5.5 | 6.5 | 12.0 | 0.5416666666666666 | 0.3076923076923077 |
38745 | 38745 | Palomar Health Downtown Campus | 50115 | 2020-07-17 | San Diego | 73 | Southern California | 11.0 | 3.0 | 29.0 | 32.0 | 0.90625 | 0.3793103448275862 |
38744 | 38744 | Palo Verde Hospital | 50423 | 2020-07-17 | Riverside | 65 | Southern California | 0.0 | 4.0 | 0.0 | 4.0 | 0.0 | |
38743 | 38743 | Palmdale Regional Medical Center | 50204 | 2020-07-17 | Los Angeles | 37 | Southern California | 6.166666666666667 | 0.0 | 17.0 | 17.0 | 1.0 | 0.3627450980392157 |
38742 | 38742 | Pacifica Hospital of the Valley | 50378 | 2020-07-17 | Los Angeles | 37 | Southern California | 7.833333333333333 | 1.666666666666668 | 8.666666666666666 | 10.333333333333334 | 0.8387096774193548 | 0.903846153846154 |
38741 | 38741 | Oroville Hospital | 50030 | 2020-07-17 | Butte | 7 | Greater Sacramento | 2.0 | 0.0 | 10.0 | 10.0 | 1.0 | 0.2 |
38740 | 38740 | Orchard Hospital | 51311 | 2020-07-17 | Butte | 7 | Greater Sacramento | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
38739 | 38739 | Orange County Global Medical Center | 50746 | 2020-07-17 | Orange | 59 | Southern California | 13.285714285714286 | 7.285714285714288 | 31.142857142857142 | 38.42857142857143 | 0.8104089219330854 | 0.426605504587156 |
38738 | 38738 | Olympia Medical Center | 50742 | 2020-07-17 | Los Angeles | 37 | Southern California | 2.0 | 4.0 | 6.0 | 10.0 | 0.6 | 0.3333333333333333 |
38737 | 38737 | Ojai Valley Community Hospital | 51334 | 2020-07-17 | Ventura | 111 | Southern California | 0.0 | 3.2857142857142856 | 0.7142857142857143 | 4.0 | 0.1785714285714285 | 0.0 |
38736 | 38736 | Oak Valley Hospital District | 50067 | 2020-07-17 | Stanislaus | 99 | San Joaquin Valley | 0.0 | 4.0 | 0.0 | 4.0 | 0.0 | |
38735 | 38735 | Novato Community Hospital | 50131 | 2020-07-17 | Marin | 41 | Bay Area | 0.0 | 5.5 | 2.5 | 8.0 | 0.3125 | 0.0 |
38734 | 38734 | Northridge Hospital Medical Center | 50116 | 2020-07-17 | Los Angeles | 37 | Southern California | 0.0 | 2.0 | 23.0 | 25.0 | 0.92 | 0.0 |
38733 | 38733 | Northern Inyo Hospital | 51324 | 2020-07-17 | Inyo | 27 | Southern California | 0.0 | 2.0 | 1.3333333333333333 | 3.333333333333333 | 0.3999999999999999 | 0.0 |
38732 | 38732 | Northbay Medical Center | 50367 | 2020-07-17 | Solano | 95 | Bay Area | 6.0 | 4.0 | 20.0 | 24.0 | 0.8333333333333334 | 0.3 |
38731 | 38731 | Natividad Medical Center | 50248 | 2020-07-17 | Monterey | 53 | Bay Area | 4.142857142857143 | 15.428571428571429 | 8.857142857142858 | 24.285714285714285 | 0.3647058823529412 | 0.467741935483871 |
38730 | 38730 | Monterey Park Hospital | 50736 | 2020-07-17 | Los Angeles | 37 | Southern California | 2.857142857142857 | 0.5714285714285712 | 4.0 | 4.571428571428571 | 0.875 | 0.7142857142857143 |
38729 | 38729 | Montclair Hospital Medical Center | 50758 | 2020-07-17 | San Bernardino | 71 | Southern California | 4.285714285714286 | 0.8571428571428568 | 5.428571428571429 | 6.285714285714286 | 0.8636363636363636 | 0.7894736842105262 |
38728 | 38728 | Monrovia Memorial Hospital | 52054 | 2020-07-17 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
38727 | 38727 | Mission Community Hospital | 50704 | 2020-07-17 | Los Angeles | 37 | Southern California | 8.0 | 9.571428571428571 | 11.428571428571429 | 21.0 | 0.54421768707483 | 0.7 |
38726 | 38726 | Mills-peninsula Medical Center | 50007 | 2020-07-17 | San Mateo | 81 | Bay Area | 4.4 | 5.5 | 18.5 | 24.0 | 0.7708333333333334 | 0.2378378378378378 |
38725 | 38725 | Methodist Hospital of Sacramento | 50590 | 2020-07-17 | Sacramento | 67 | Greater Sacramento | 3.6666666666666665 | 12.0 | 8.0 | 20.0 | 0.4 | 0.4583333333333333 |
38724 | 38724 | Mercy San Juan Medical Center | 50516 | 2020-07-17 | Sacramento | 67 | Greater Sacramento | 7.166666666666667 | 3.0 | 48.0 | 51.0 | 0.9411764705882352 | 0.1493055555555555 |
38723 | 38723 | Mercy Medical Center Redding | 50280 | 2020-07-17 | Shasta | 89 | Northern California | 1.1666666666666667 | 1.0 | 32.0 | 33.0 | 0.9696969696969696 | 0.0364583333333333 |
38722 | 38722 | Mercy Medical Center Mt Shasta | 51319 | 2020-07-17 | Siskiyou | 93 | Northern California | 0.0 | 4.0 | 0.0 | 4.0 | 0.0 | |
38721 | 38721 | Mercy Medical Center | 50444 | 2020-07-17 | Merced | 47 | San Joaquin Valley | 7.0 | 2.0 | 16.0 | 18.0 | 0.8888888888888888 | 0.4375 |
38720 | 38720 | Mercy Hospital of Folsom | 50414 | 2020-07-17 | Sacramento | 67 | Greater Sacramento | 1.8333333333333333 | 1.0 | 5.0 | 6.0 | 0.8333333333333334 | 0.3666666666666666 |
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 );