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 fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16 | 16 | Alameda Hospital | 50211 | 2022-12-23 | Alameda | 1 | Bay Area | 1.0 | 0.0 | 8.0 | 8.0 | 1.0 | 0.125 |
18 | 18 | Alta Bates Summit Medical Center | 50043 | 2022-12-23 | Alameda | 1 | Bay Area | 0.0 | 17.0 | 19.0 | 36.0 | 0.5277777777777778 | 0.0 |
19 | 19 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305 | 2022-12-23 | Alameda | 1 | Bay Area | 0.0 | 17.0 | 13.0 | 30.0 | 0.4333333333333333 | 0.0 |
52 | 52 | Eden Medical Center | 50488 | 2022-12-23 | Alameda | 1 | Bay Area | 0.0 | 0.0 | 24.0 | 24.0 | 1.0 | 0.0 |
72 | 72 | Highland Hospital | 50320 | 2022-12-23 | Alameda | 1 | Bay Area | 2.0 | 8.5 | 24.5 | 33.0 | 0.7424242424242424 | 0.0816326530612244 |
83 | 83 | Kaiser Foundation Hospital - Fremont | 50512 | 2022-12-23 | Alameda | 1 | Bay Area | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
86 | 86 | Kaiser Foundation Hospital - Oakland/richmond | 50075 | 2022-12-23 | Alameda | 1 | Bay Area | 10.0 | 2.0 | 20.0 | 22.0 | 0.9090909090909092 | 0.5 |
93 | 93 | Kaiser Foundation Hospital - San Leandro | 50777 | 2022-12-23 | Alameda | 1 | Bay Area | 7.0 | 2.0 | 15.0 | 17.0 | 0.8823529411764706 | 0.4666666666666667 |
114 | 114 | Kindred Hospital - San Francisco Bay Area | 52034 | 2022-12-23 | Alameda | 1 | Bay Area | 0.0 | 4.0 | 6.0 | 10.0 | 0.6 | 0.0 |
232 | 232 | St. Rose Hospital | 50002 | 2022-12-23 | Alameda | 1 | Bay Area | 0.0 | 5.0 | 7.0 | 12.0 | 0.5833333333333334 | 0.0 |
234 | 234 | Stanford Health Care - Valleycare | 50283 | 2022-12-23 | Alameda | 1 | Bay Area | 0.0 | 6.0 | 16.0 | 22.0 | 0.7272727272727273 | 0.0 |
259 | 259 | Washington Hospital | 50195 | 2022-12-23 | Alameda | 1 | Bay Area | 0.0 | 5.0 | 23.0 | 28.0 | 0.8214285714285714 | 0.0 |
282 | 282 | Alameda Hospital | 50211 | 2022-12-16 | Alameda | 1 | Bay Area | 0.0 | 0.1428571428571432 | 7.857142857142857 | 8.0 | 0.9821428571428572 | 0.0 |
284 | 284 | Alta Bates Summit Medical Center | 50043 | 2022-12-16 | Alameda | 1 | Bay Area | 3.7142857142857135 | 16.714285714285715 | 19.285714285714285 | 36.0 | 0.5357142857142857 | 0.1925925925925926 |
285 | 285 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305 | 2022-12-16 | Alameda | 1 | Bay Area | 1.5714285714285714 | 18.142857142857142 | 11.857142857142858 | 30.0 | 0.3952380952380953 | 0.1325301204819277 |
324 | 324 | Eden Medical Center | 50488 | 2022-12-16 | Alameda | 1 | Bay Area | 2.142857142857143 | 1.428571428571427 | 22.571428571428573 | 24.0 | 0.9404761904761906 | 0.0949367088607594 |
350 | 350 | Highland Hospital | 50320 | 2022-12-16 | Alameda | 1 | Bay Area | 0.8571428571428571 | 8.714285714285715 | 24.285714285714285 | 33.0 | 0.7359307359307359 | 0.0352941176470588 |
363 | 363 | Kaiser Foundation Hospital - Fremont | 50512 | 2022-12-16 | Alameda | 1 | Bay Area | 2.142857142857143 | 1.0000000000000009 | 7.857142857142857 | 8.857142857142858 | 0.8870967741935483 | 0.2727272727272727 |
366 | 366 | Kaiser Foundation Hospital - Oakland/richmond | 50075 | 2022-12-16 | Alameda | 1 | Bay Area | 5.714285714285714 | 2.5714285714285694 | 20.571428571428573 | 23.142857142857142 | 0.888888888888889 | 0.2777777777777778 |
373 | 373 | Kaiser Foundation Hospital - San Leandro | 50777 | 2022-12-16 | Alameda | 1 | Bay Area | 11.428571428571429 | 2.0 | 18.0 | 20.0 | 0.9 | 0.6349206349206349 |
394 | 394 | Kindred Hospital - San Francisco Bay Area | 52034 | 2022-12-16 | Alameda | 1 | Bay Area | 0.0 | 4.857142857142857 | 5.142857142857143 | 10.0 | 0.5142857142857143 | 0.0 |
524 | 524 | St. Rose Hospital | 50002 | 2022-12-16 | Alameda | 1 | Bay Area | 0.0 | 6.857142857142857 | 5.142857142857143 | 12.0 | 0.4285714285714286 | 0.0 |
526 | 526 | Stanford Health Care - Valleycare | 50283 | 2022-12-16 | Alameda | 1 | Bay Area | 0.0 | 4.199999999999999 | 17.8 | 22.0 | 0.8090909090909091 | 0.0 |
555 | 555 | Washington Hospital | 50195 | 2022-12-16 | Alameda | 1 | Bay Area | 4.857142857142857 | 7.285714285714285 | 20.714285714285715 | 28.0 | 0.7397959183673469 | 0.2344827586206896 |
578 | 578 | Alameda Hospital | 50211 | 2022-12-09 | Alameda | 1 | Bay Area | 0.0 | 0.5714285714285712 | 7.428571428571429 | 8.0 | 0.9285714285714286 | 0.0 |
580 | 580 | Alta Bates Summit Medical Center | 50043 | 2022-12-09 | Alameda | 1 | Bay Area | 3.4285714285714284 | 12.857142857142858 | 23.142857142857142 | 36.0 | 0.6428571428571428 | 0.1481481481481481 |
581 | 581 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305 | 2022-12-09 | Alameda | 1 | Bay Area | 2.857142857142857 | 17.42857142857143 | 12.571428571428571 | 30.0 | 0.419047619047619 | 0.2272727272727273 |
622 | 622 | Eden Medical Center | 50488 | 2022-12-09 | Alameda | 1 | Bay Area | 3.0 | 2.7142857142857157 | 21.285714285714285 | 24.0 | 0.8869047619047619 | 0.1409395973154362 |
648 | 648 | Highland Hospital | 50320 | 2022-12-09 | Alameda | 1 | Bay Area | 0.0 | 9.0 | 24.0 | 33.0 | 0.7272727272727273 | 0.0 |
661 | 661 | Kaiser Foundation Hospital - Fremont | 50512 | 2022-12-09 | Alameda | 1 | Bay Area | 2.4285714285714284 | 0.8571428571428577 | 6.571428571428571 | 7.428571428571429 | 0.8846153846153846 | 0.3695652173913043 |
664 | 664 | Kaiser Foundation Hospital - Oakland/richmond | 50075 | 2022-12-09 | Alameda | 1 | Bay Area | 4.428571428571429 | 2.0 | 16.714285714285715 | 18.714285714285715 | 0.8931297709923665 | 0.2649572649572649 |
671 | 671 | Kaiser Foundation Hospital - San Leandro | 50777 | 2022-12-09 | Alameda | 1 | Bay Area | 8.714285714285714 | 1.857142857142854 | 16.571428571428573 | 18.428571428571427 | 0.8992248062015505 | 0.5258620689655171 |
693 | 693 | Kindred Hospital - San Francisco Bay Area | 52034 | 2022-12-09 | Alameda | 1 | Bay Area | 0.0 | 5.0 | 5.0 | 10.0 | 0.5 | 0.0 |
824 | 824 | St. Rose Hospital | 50002 | 2022-12-09 | Alameda | 1 | Bay Area | 0.0 | 8.571428571428571 | 3.4285714285714284 | 12.0 | 0.2857142857142857 | 0.0 |
826 | 826 | Stanford Health Care - Valleycare | 50283 | 2022-12-09 | Alameda | 1 | Bay Area | 0.6666666666666666 | 3.5 | 18.5 | 22.0 | 0.8409090909090909 | 0.036036036036036 |
855 | 855 | Washington Hospital | 50195 | 2022-12-09 | Alameda | 1 | Bay Area | 2.857142857142857 | 8.714285714285715 | 19.285714285714285 | 28.0 | 0.6887755102040816 | 0.1481481481481481 |
878 | 878 | Alameda Hospital | 50211 | 2022-12-02 | Alameda | 1 | Bay Area | 0.0 | 0.7142857142857144 | 7.285714285714286 | 8.0 | 0.9107142857142856 | 0.0 |
880 | 880 | Alta Bates Summit Medical Center | 50043 | 2022-12-02 | Alameda | 1 | Bay Area | 2.571428571428572 | 16.857142857142858 | 19.142857142857142 | 36.0 | 0.5317460317460317 | 0.1343283582089552 |
881 | 881 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305 | 2022-12-02 | Alameda | 1 | Bay Area | 1.2857142857142858 | 19.42857142857143 | 10.571428571428571 | 30.0 | 0.3523809523809523 | 0.1216216216216216 |
922 | 922 | Eden Medical Center | 50488 | 2022-12-02 | Alameda | 1 | Bay Area | 0.8571428571428571 | 2.1428571428571423 | 21.857142857142858 | 24.0 | 0.9107142857142856 | 0.0392156862745098 |
948 | 948 | Highland Hospital | 50320 | 2022-12-02 | Alameda | 1 | Bay Area | 0.7142857142857143 | 6.714285714285715 | 26.285714285714285 | 33.0 | 0.7965367965367965 | 0.0271739130434782 |
961 | 961 | Kaiser Foundation Hospital - Fremont | 50512 | 2022-12-02 | Alameda | 1 | Bay Area | 1.8571428571428568 | 0.5714285714285712 | 7.571428571428571 | 8.142857142857142 | 0.9298245614035088 | 0.2452830188679245 |
964 | 964 | Kaiser Foundation Hospital - Oakland/richmond | 50075 | 2022-12-02 | Alameda | 1 | Bay Area | 4.428571428571429 | 1.8571428571428577 | 17.142857142857142 | 19.0 | 0.9022556390977444 | 0.2583333333333333 |
971 | 971 | Kaiser Foundation Hospital - San Leandro | 50777 | 2022-12-02 | Alameda | 1 | Bay Area | 4.857142857142857 | 1.7142857142857153 | 16.142857142857142 | 17.857142857142858 | 0.904 | 0.3008849557522123 |
993 | 993 | Kindred Hospital - San Francisco Bay Area | 52034 | 2022-12-02 | Alameda | 1 | Bay Area | 0.0 | 4.285714285714286 | 5.714285714285714 | 10.0 | 0.5714285714285714 | 0.0 |
1122 | 1122 | St. Rose Hospital | 50002 | 2022-12-02 | Alameda | 1 | Bay Area | 0.0 | 6.428571428571429 | 5.571428571428571 | 12.0 | 0.4642857142857142 | 0.0 |
1124 | 1124 | Stanford Health Care - Valleycare | 50283 | 2022-12-02 | Alameda | 1 | Bay Area | 1.0 | 4.428571428571427 | 17.571428571428573 | 22.0 | 0.7987012987012988 | 0.056910569105691 |
1153 | 1153 | Washington Hospital | 50195 | 2022-12-02 | Alameda | 1 | Bay Area | 2.0 | 10.0 | 18.0 | 28.0 | 0.6428571428571429 | 0.1111111111111111 |
1176 | 1176 | Alameda Hospital | 50211 | 2022-11-25 | Alameda | 1 | Bay Area | 0.7142857142857143 | 0.8571428571428568 | 7.142857142857143 | 8.0 | 0.8928571428571429 | 0.0999999999999999 |
1178 | 1178 | Alta Bates Summit Medical Center | 50043 | 2022-11-25 | Alameda | 1 | Bay Area | 1.7142857142857142 | 22.857142857142858 | 13.142857142857142 | 36.0 | 0.365079365079365 | 0.1304347826086956 |
1179 | 1179 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305 | 2022-11-25 | Alameda | 1 | Bay Area | 1.1428571428571428 | 20.142857142857142 | 9.857142857142858 | 30.0 | 0.3285714285714285 | 0.1159420289855072 |
1220 | 1220 | Eden Medical Center | 50488 | 2022-11-25 | Alameda | 1 | Bay Area | 0.7142857142857143 | 5.142857142857142 | 18.857142857142858 | 24.0 | 0.7857142857142857 | 0.0378787878787878 |
1247 | 1247 | Highland Hospital | 50320 | 2022-11-25 | Alameda | 1 | Bay Area | 1.2857142857142858 | 5.857142857142858 | 27.142857142857142 | 33.0 | 0.8225108225108225 | 0.0473684210526315 |
1260 | 1260 | Kaiser Foundation Hospital - Fremont | 50512 | 2022-11-25 | Alameda | 1 | Bay Area | 1.4285714285714286 | 0.5714285714285712 | 5.142857142857143 | 5.714285714285714 | 0.9 | 0.2777777777777778 |
1263 | 1263 | Kaiser Foundation Hospital - Oakland/richmond | 50075 | 2022-11-25 | Alameda | 1 | Bay Area | 7.571428571428571 | 1.8571428571428577 | 16.285714285714285 | 18.142857142857142 | 0.8976377952755905 | 0.4649122807017544 |
1270 | 1270 | Kaiser Foundation Hospital - San Leandro | 50777 | 2022-11-25 | Alameda | 1 | Bay Area | 5.142857142857143 | 1.4285714285714288 | 13.571428571428571 | 15.0 | 0.9047619047619048 | 0.3789473684210526 |
1292 | 1292 | Kindred Hospital - San Francisco Bay Area | 52034 | 2022-11-25 | Alameda | 1 | Bay Area | 0.0 | 6.142857142857142 | 3.857142857142857 | 10.0 | 0.3857142857142857 | 0.0 |
1421 | 1421 | St. Rose Hospital | 50002 | 2022-11-25 | Alameda | 1 | Bay Area | 0.0 | 5.285714285714286 | 6.714285714285714 | 12.0 | 0.5595238095238095 | 0.0 |
1423 | 1423 | Stanford Health Care - Valleycare | 50283 | 2022-11-25 | Alameda | 1 | Bay Area | 0.0 | 5.285714285714285 | 16.714285714285715 | 22.0 | 0.7597402597402598 | 0.0 |
1452 | 1452 | Washington Hospital | 50195 | 2022-11-25 | Alameda | 1 | Bay Area | 2.4285714285714284 | 8.571428571428573 | 19.428571428571427 | 28.0 | 0.6938775510204082 | 0.125 |
1475 | 1475 | Alameda Hospital | 50211 | 2022-11-18 | Alameda | 1 | Bay Area | 1.1428571428571428 | 1.4285714285714288 | 6.571428571428571 | 8.0 | 0.8214285714285714 | 0.1739130434782608 |
1477 | 1477 | Alta Bates Summit Medical Center | 50043 | 2022-11-18 | Alameda | 1 | Bay Area | 0.7142857142857143 | 23.714285714285715 | 12.285714285714286 | 36.0 | 0.3412698412698413 | 0.0581395348837209 |
1478 | 1478 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305 | 2022-11-18 | Alameda | 1 | Bay Area | 0.7142857142857143 | 18.42857142857143 | 11.571428571428571 | 30.0 | 0.3857142857142857 | 0.0617283950617284 |
1519 | 1519 | Eden Medical Center | 50488 | 2022-11-18 | Alameda | 1 | Bay Area | 1.8571428571428568 | 7.142857142857142 | 16.857142857142858 | 24.0 | 0.7023809523809524 | 0.1101694915254237 |
1545 | 1545 | Highland Hospital | 50320 | 2022-11-18 | Alameda | 1 | Bay Area | 1.8571428571428568 | 6.714285714285715 | 26.285714285714285 | 33.0 | 0.7965367965367965 | 0.0706521739130434 |
1558 | 1558 | Kaiser Foundation Hospital - Fremont | 50512 | 2022-11-18 | Alameda | 1 | Bay Area | 1.4285714285714286 | 1.0 | 6.0 | 7.0 | 0.8571428571428571 | 0.2380952380952381 |
1561 | 1561 | Kaiser Foundation Hospital - Oakland/richmond | 50075 | 2022-11-18 | Alameda | 1 | Bay Area | 6.857142857142857 | 1.857142857142856 | 15.571428571428571 | 17.428571428571427 | 0.8934426229508198 | 0.4403669724770642 |
1568 | 1568 | Kaiser Foundation Hospital - San Leandro | 50777 | 2022-11-18 | Alameda | 1 | Bay Area | 4.714285714285714 | 1.428571428571427 | 13.285714285714286 | 14.714285714285714 | 0.9029126213592232 | 0.3548387096774193 |
1590 | 1590 | Kindred Hospital - San Francisco Bay Area | 52034 | 2022-11-18 | Alameda | 1 | Bay Area | 0.0 | 4.142857142857143 | 5.857142857142857 | 10.0 | 0.5857142857142856 | 0.0 |
1720 | 1720 | St. Rose Hospital | 50002 | 2022-11-18 | Alameda | 1 | Bay Area | 0.0 | 4.857142857142857 | 7.142857142857143 | 12.0 | 0.5952380952380952 | 0.0 |
1722 | 1722 | Stanford Health Care - Valleycare | 50283 | 2022-11-18 | Alameda | 1 | Bay Area | 1.3333333333333333 | 4.833333333333332 | 17.166666666666668 | 22.0 | 0.7803030303030304 | 0.0776699029126213 |
1750 | 1750 | Washington Hospital | 50195 | 2022-11-18 | Alameda | 1 | Bay Area | 2.0 | 9.428571428571429 | 18.571428571428573 | 28.0 | 0.663265306122449 | 0.1076923076923076 |
1773 | 1773 | Alameda Hospital | 50211 | 2022-11-11 | Alameda | 1 | Bay Area | 0.0 | 3.0 | 5.0 | 8.0 | 0.625 | 0.0 |
1775 | 1775 | Alta Bates Summit Medical Center | 50043 | 2022-11-11 | Alameda | 1 | Bay Area | 0.0 | 24.0 | 12.0 | 36.0 | 0.3333333333333333 | 0.0 |
1776 | 1776 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305 | 2022-11-11 | Alameda | 1 | Bay Area | 0.0 | 17.42857142857143 | 12.571428571428571 | 30.0 | 0.419047619047619 | 0.0 |
1817 | 1817 | Eden Medical Center | 50488 | 2022-11-11 | Alameda | 1 | Bay Area | 1.0 | 4.142857142857142 | 19.857142857142858 | 24.0 | 0.8273809523809524 | 0.0503597122302158 |
1844 | 1844 | Highland Hospital | 50320 | 2022-11-11 | Alameda | 1 | Bay Area | 0.7142857142857143 | 7.714285714285715 | 25.285714285714285 | 33.0 | 0.7662337662337662 | 0.0282485875706214 |
1857 | 1857 | Kaiser Foundation Hospital - Fremont | 50512 | 2022-11-11 | Alameda | 1 | Bay Area | 2.0 | 0.7142857142857144 | 7.857142857142857 | 8.571428571428571 | 0.9166666666666666 | 0.2545454545454546 |
1860 | 1860 | Kaiser Foundation Hospital - Oakland/richmond | 50075 | 2022-11-11 | Alameda | 1 | Bay Area | 4.714285714285714 | 1.7142857142857135 | 15.571428571428571 | 17.285714285714285 | 0.9008264462809916 | 0.3027522935779816 |
1867 | 1867 | Kaiser Foundation Hospital - San Leandro | 50777 | 2022-11-11 | Alameda | 1 | Bay Area | 2.7142857142857144 | 1.0 | 11.428571428571429 | 12.428571428571429 | 0.9195402298850576 | 0.2375 |
1889 | 1889 | Kindred Hospital - San Francisco Bay Area | 52034 | 2022-11-11 | Alameda | 1 | Bay Area | 0.0 | 5.0 | 5.0 | 10.0 | 0.5 | 0.0 |
2019 | 2019 | St. Rose Hospital | 50002 | 2022-11-11 | Alameda | 1 | Bay Area | 0.0 | 1.5714285714285712 | 10.428571428571429 | 12.0 | 0.8690476190476191 | 0.0 |
2021 | 2021 | Stanford Health Care - Valleycare | 50283 | 2022-11-11 | Alameda | 1 | Bay Area | 1.0 | 4.142857142857142 | 16.714285714285715 | 20.857142857142858 | 0.8013698630136986 | 0.0598290598290598 |
2050 | 2050 | Washington Hospital | 50195 | 2022-11-11 | Alameda | 1 | Bay Area | 0.5714285714285714 | 12.428571428571429 | 15.571428571428571 | 28.0 | 0.5561224489795918 | 0.036697247706422 |
2073 | 2073 | Alameda Hospital | 50211 | 2022-11-04 | Alameda | 1 | Bay Area | 0.0 | 4.714285714285714 | 3.2857142857142856 | 8.0 | 0.4107142857142857 | 0.0 |
2075 | 2075 | Alta Bates Summit Medical Center | 50043 | 2022-11-04 | Alameda | 1 | Bay Area | 1.4285714285714286 | 24.57142857142857 | 11.428571428571429 | 36.0 | 0.3174603174603174 | 0.125 |
2076 | 2076 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305 | 2022-11-04 | Alameda | 1 | Bay Area | 0.0 | 20.714285714285715 | 9.285714285714286 | 30.0 | 0.3095238095238095 | 0.0 |
2117 | 2117 | Eden Medical Center | 50488 | 2022-11-04 | Alameda | 1 | Bay Area | 1.1428571428571428 | 5.0 | 19.0 | 24.0 | 0.7916666666666666 | 0.0601503759398496 |
2143 | 2143 | Highland Hospital | 50320 | 2022-11-04 | Alameda | 1 | Bay Area | 0.0 | 9.285714285714285 | 23.714285714285715 | 33.0 | 0.7186147186147186 | 0.0 |
2156 | 2156 | Kaiser Foundation Hospital - Fremont | 50512 | 2022-11-04 | Alameda | 1 | Bay Area | 3.142857142857143 | 0.8571428571428577 | 8.428571428571429 | 9.285714285714286 | 0.9076923076923076 | 0.3728813559322034 |
2159 | 2159 | Kaiser Foundation Hospital - Oakland/richmond | 50075 | 2022-11-04 | Alameda | 1 | Bay Area | 1.1428571428571428 | 1.2857142857142847 | 12.857142857142858 | 14.142857142857142 | 0.9090909090909092 | 0.0888888888888888 |
2166 | 2166 | Kaiser Foundation Hospital - San Leandro | 50777 | 2022-11-04 | Alameda | 1 | Bay Area | 2.2857142857142856 | 1.1428571428571423 | 11.285714285714286 | 12.428571428571429 | 0.9080459770114944 | 0.2025316455696202 |
2188 | 2188 | Kindred Hospital - San Francisco Bay Area | 52034 | 2022-11-04 | Alameda | 1 | Bay Area | 0.0 | 4.714285714285714 | 5.285714285714286 | 10.0 | 0.5285714285714286 | 0.0 |
2318 | 2318 | St. Rose Hospital | 50002 | 2022-11-04 | Alameda | 1 | Bay Area | 0.0 | 3.571428571428571 | 8.428571428571429 | 12.0 | 0.7023809523809524 | 0.0 |
2320 | 2320 | Stanford Health Care - Valleycare | 50283 | 2022-11-04 | Alameda | 1 | Bay Area | 2.0 | 2.7142857142857157 | 18.857142857142858 | 21.571428571428573 | 0.8741721854304635 | 0.106060606060606 |
2349 | 2349 | Washington Hospital | 50195 | 2022-11-04 | Alameda | 1 | Bay Area | 0.5714285714285714 | 19.142857142857142 | 8.857142857142858 | 28.0 | 0.3163265306122449 | 0.064516129032258 |
2372 | 2372 | Alameda Hospital | 50211 | 2022-10-28 | Alameda | 1 | Bay Area | 0.0 | 4.285714285714286 | 3.7142857142857135 | 8.0 | 0.4642857142857143 | 0.0 |
2374 | 2374 | Alta Bates Summit Medical Center | 50043 | 2022-10-28 | Alameda | 1 | Bay Area | 0.7142857142857143 | 28.285714285714285 | 7.714285714285714 | 36.0 | 0.2142857142857143 | 0.0925925925925925 |
2375 | 2375 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305 | 2022-10-28 | Alameda | 1 | Bay Area | 0.0 | 20.57142857142857 | 9.428571428571429 | 30.0 | 0.3142857142857143 | 0.0 |
2416 | 2416 | Eden Medical Center | 50488 | 2022-10-28 | Alameda | 1 | Bay Area | 1.4285714285714286 | 5.285714285714285 | 18.714285714285715 | 24.0 | 0.7797619047619048 | 0.0763358778625954 |
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 );