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)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2442 | 2442 | Highland Hospital | 50320 | 2022-10-28 | Alameda | 1 | Bay Area | 0.0 | 10.428571428571429 | 22.571428571428573 | 33.0 | 0.683982683982684 | 0.0 |
2455 | 2455 | Kaiser Foundation Hospital - Fremont | 50512 | 2022-10-28 | Alameda | 1 | Bay Area | 1.1428571428571428 | 0.8571428571428568 | 5.714285714285714 | 6.571428571428571 | 0.8695652173913044 | 0.1999999999999999 |
2458 | 2458 | Kaiser Foundation Hospital - Oakland/richmond | 50075 | 2022-10-28 | Alameda | 1 | Bay Area | 1.1428571428571428 | 1.5714285714285694 | 15.857142857142858 | 17.428571428571427 | 0.9098360655737706 | 0.072072072072072 |
2465 | 2465 | Kaiser Foundation Hospital - San Leandro | 50777 | 2022-10-28 | Alameda | 1 | Bay Area | 1.1428571428571428 | 1.0 | 8.428571428571429 | 9.428571428571429 | 0.8939393939393939 | 0.135593220338983 |
2487 | 2487 | Kindred Hospital - San Francisco Bay Area | 52034 | 2022-10-28 | Alameda | 1 | Bay Area | 0.0 | 6.142857142857142 | 3.857142857142857 | 10.0 | 0.3857142857142857 | 0.0 |
2618 | 2618 | St. Rose Hospital | 50002 | 2022-10-28 | Alameda | 1 | Bay Area | 0.0 | 5.0 | 7.0 | 12.0 | 0.5833333333333334 | 0.0 |
2620 | 2620 | Stanford Health Care - Valleycare | 50283 | 2022-10-28 | Alameda | 1 | Bay Area | 0.5714285714285714 | 4.0 | 18.0 | 22.0 | 0.8181818181818182 | 0.0317460317460317 |
2649 | 2649 | Washington Hospital | 50195 | 2022-10-28 | Alameda | 1 | Bay Area | 0.7142857142857143 | 16.857142857142858 | 11.142857142857142 | 28.0 | 0.3979591836734694 | 0.0641025641025641 |
2672 | 2672 | Alameda Hospital | 50211 | 2022-10-21 | Alameda | 1 | Bay Area | 0.0 | 3.428571428571429 | 4.571428571428571 | 8.0 | 0.5714285714285714 | 0.0 |
2674 | 2674 | Alta Bates Summit Medical Center | 50043 | 2022-10-21 | Alameda | 1 | Bay Area | 1.5714285714285714 | 22.57142857142857 | 13.428571428571429 | 36.0 | 0.373015873015873 | 0.1170212765957446 |
2675 | 2675 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305 | 2022-10-21 | Alameda | 1 | Bay Area | 0.0 | 21.857142857142858 | 8.142857142857142 | 30.0 | 0.2714285714285714 | 0.0 |
2716 | 2716 | Eden Medical Center | 50488 | 2022-10-21 | Alameda | 1 | Bay Area | 1.0 | 6.857142857142858 | 17.142857142857142 | 24.0 | 0.7142857142857143 | 0.0583333333333333 |
2742 | 2742 | Highland Hospital | 50320 | 2022-10-21 | Alameda | 1 | Bay Area | 0.0 | 9.428571428571429 | 23.571428571428573 | 33.0 | 0.7142857142857143 | 0.0 |
2755 | 2755 | Kaiser Foundation Hospital - Fremont | 50512 | 2022-10-21 | Alameda | 1 | Bay Area | 1.1428571428571428 | 0.4285714285714279 | 6.142857142857143 | 6.571428571428571 | 0.9347826086956522 | 0.1860465116279069 |
2758 | 2758 | Kaiser Foundation Hospital - Oakland/richmond | 50075 | 2022-10-21 | Alameda | 1 | Bay Area | 2.7142857142857144 | 1.5714285714285712 | 14.571428571428571 | 16.142857142857142 | 0.9026548672566372 | 0.1862745098039215 |
2765 | 2765 | Kaiser Foundation Hospital - San Leandro | 50777 | 2022-10-21 | Alameda | 1 | Bay Area | 2.571428571428572 | 1.0 | 10.571428571428571 | 11.571428571428571 | 0.9135802469135802 | 0.2432432432432432 |
2787 | 2787 | Kindred Hospital - San Francisco Bay Area | 52034 | 2022-10-21 | Alameda | 1 | Bay Area | 0.0 | 4.571428571428571 | 5.428571428571429 | 10.0 | 0.5428571428571429 | 0.0 |
2918 | 2918 | St. Rose Hospital | 50002 | 2022-10-21 | Alameda | 1 | Bay Area | 0.5714285714285714 | 7.285714285714286 | 4.714285714285714 | 12.0 | 0.3928571428571428 | 0.1212121212121212 |
2920 | 2920 | Stanford Health Care - Valleycare | 50283 | 2022-10-21 | Alameda | 1 | Bay Area | 0.7142857142857143 | 2.571428571428573 | 19.428571428571427 | 22.0 | 0.8831168831168831 | 0.0367647058823529 |
2949 | 2949 | Washington Hospital | 50195 | 2022-10-21 | Alameda | 1 | Bay Area | 0.8571428571428571 | 16.0 | 12.0 | 28.0 | 0.4285714285714285 | 0.0714285714285714 |
2972 | 2972 | Alameda Hospital | 50211 | 2022-10-14 | Alameda | 1 | Bay Area | 0.0 | 4.142857142857142 | 3.857142857142857 | 8.0 | 0.4821428571428571 | 0.0 |
2974 | 2974 | Alta Bates Summit Medical Center | 50043 | 2022-10-14 | Alameda | 1 | Bay Area | 0.5714285714285714 | 26.285714285714285 | 9.714285714285714 | 36.0 | 0.2698412698412698 | 0.0588235294117647 |
2975 | 2975 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305 | 2022-10-14 | Alameda | 1 | Bay Area | 1.0 | 18.57142857142857 | 11.428571428571429 | 30.0 | 0.380952380952381 | 0.0875 |
3016 | 3016 | Eden Medical Center | 50488 | 2022-10-14 | Alameda | 1 | Bay Area | 3.0 | 6.142857142857142 | 17.857142857142858 | 24.0 | 0.7440476190476191 | 0.1679999999999999 |
3042 | 3042 | Highland Hospital | 50320 | 2022-10-14 | Alameda | 1 | Bay Area | 0.0 | 12.0 | 21.0 | 33.0 | 0.6363636363636364 | 0.0 |
3055 | 3055 | Kaiser Foundation Hospital - Fremont | 50512 | 2022-10-14 | Alameda | 1 | Bay Area | 1.0 | 0.7142857142857135 | 5.142857142857143 | 5.857142857142857 | 0.878048780487805 | 0.1944444444444444 |
3058 | 3058 | Kaiser Foundation Hospital - Oakland/richmond | 50075 | 2022-10-14 | Alameda | 1 | Bay Area | 2.571428571428572 | 1.7142857142857153 | 15.142857142857142 | 16.857142857142858 | 0.8983050847457626 | 0.169811320754717 |
3065 | 3065 | Kaiser Foundation Hospital - San Leandro | 50777 | 2022-10-14 | Alameda | 1 | Bay Area | 4.142857142857143 | 1.142857142857144 | 13.142857142857142 | 14.285714285714286 | 0.92 | 0.3152173913043479 |
3087 | 3087 | Kindred Hospital - San Francisco Bay Area | 52034 | 2022-10-14 | Alameda | 1 | Bay Area | 0.0 | 3.7142857142857135 | 6.285714285714286 | 10.0 | 0.6285714285714286 | 0.0 |
3218 | 3218 | St. Rose Hospital | 50002 | 2022-10-14 | Alameda | 1 | Bay Area | 0.0 | 5.428571428571429 | 6.571428571428571 | 12.0 | 0.5476190476190476 | 0.0 |
3220 | 3220 | Stanford Health Care - Valleycare | 50283 | 2022-10-14 | Alameda | 1 | Bay Area | 0.5714285714285714 | 3.571428571428573 | 18.428571428571427 | 22.0 | 0.8376623376623376 | 0.0310077519379844 |
3249 | 3249 | Washington Hospital | 50195 | 2022-10-14 | Alameda | 1 | Bay Area | 0.8571428571428571 | 15.142857142857142 | 12.857142857142858 | 28.0 | 0.4591836734693877 | 0.0666666666666666 |
3271 | 3271 | Alameda Hospital | 50211 | 2022-10-07 | Alameda | 1 | Bay Area | 0.0 | 4.0 | 4.0 | 8.0 | 0.5 | 0.0 |
3273 | 3273 | Alta Bates Summit Medical Center | 50043 | 2022-10-07 | Alameda | 1 | Bay Area | 0.0 | 24.57142857142857 | 11.428571428571429 | 36.0 | 0.3174603174603174 | 0.0 |
3274 | 3274 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305 | 2022-10-07 | Alameda | 1 | Bay Area | 0.0 | 21.57142857142857 | 8.428571428571429 | 30.0 | 0.2809523809523809 | 0.0 |
3315 | 3315 | Eden Medical Center | 50488 | 2022-10-07 | Alameda | 1 | Bay Area | 2.2857142857142856 | 7.0 | 17.0 | 24.0 | 0.7083333333333334 | 0.134453781512605 |
3342 | 3342 | Highland Hospital | 50320 | 2022-10-07 | Alameda | 1 | Bay Area | 1.0 | 9.285714285714285 | 23.714285714285715 | 33.0 | 0.7186147186147186 | 0.0421686746987951 |
3355 | 3355 | Kaiser Foundation Hospital - Fremont | 50512 | 2022-10-07 | Alameda | 1 | Bay Area | 1.4285714285714286 | 0.5714285714285721 | 4.857142857142857 | 5.428571428571429 | 0.894736842105263 | 0.2941176470588235 |
3358 | 3358 | Kaiser Foundation Hospital - Oakland/richmond | 50075 | 2022-10-07 | Alameda | 1 | Bay Area | 1.1428571428571428 | 1.7142857142857153 | 16.0 | 17.714285714285715 | 0.9032258064516128 | 0.0714285714285714 |
3365 | 3365 | Kaiser Foundation Hospital - San Leandro | 50777 | 2022-10-07 | Alameda | 1 | Bay Area | 4.0 | 1.0 | 9.714285714285714 | 10.714285714285714 | 0.9066666666666666 | 0.411764705882353 |
3387 | 3387 | Kindred Hospital - San Francisco Bay Area | 52034 | 2022-10-07 | Alameda | 1 | Bay Area | 0.0 | 4.142857142857143 | 5.857142857142857 | 10.0 | 0.5857142857142856 | 0.0 |
3518 | 3518 | St. Rose Hospital | 50002 | 2022-10-07 | Alameda | 1 | Bay Area | 0.5714285714285714 | 3.428571428571429 | 8.571428571428571 | 12.0 | 0.7142857142857143 | 0.0666666666666666 |
3520 | 3520 | Stanford Health Care - Valleycare | 50283 | 2022-10-07 | Alameda | 1 | Bay Area | 0.0 | 6.857142857142858 | 15.142857142857142 | 22.0 | 0.6883116883116883 | 0.0 |
3549 | 3549 | Washington Hospital | 50195 | 2022-10-07 | Alameda | 1 | Bay Area | 0.0 | 15.571428571428571 | 12.428571428571429 | 28.0 | 0.4438775510204081 | 0.0 |
3573 | 3573 | Alameda Hospital | 50211 | 2022-09-30 | Alameda | 1 | Bay Area | 0.0 | 3.571428571428571 | 4.428571428571429 | 8.0 | 0.5535714285714286 | 0.0 |
3575 | 3575 | Alta Bates Summit Medical Center | 50043 | 2022-09-30 | Alameda | 1 | Bay Area | 0.0 | 24.0 | 12.0 | 36.0 | 0.3333333333333333 | 0.0 |
3576 | 3576 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305 | 2022-09-30 | Alameda | 1 | Bay Area | 0.0 | 17.57142857142857 | 12.428571428571429 | 30.0 | 0.4142857142857143 | 0.0 |
3617 | 3617 | Eden Medical Center | 50488 | 2022-09-30 | Alameda | 1 | Bay Area | 1.7142857142857142 | 4.428571428571427 | 19.571428571428573 | 24.0 | 0.8154761904761906 | 0.0875912408759124 |
3644 | 3644 | Highland Hospital | 50320 | 2022-09-30 | Alameda | 1 | Bay Area | 0.5714285714285714 | 8.285714285714285 | 24.714285714285715 | 33.0 | 0.748917748917749 | 0.0231213872832369 |
3657 | 3657 | Kaiser Foundation Hospital - Fremont | 50512 | 2022-09-30 | Alameda | 1 | Bay Area | 1.1428571428571428 | 0.2857142857142856 | 4.142857142857143 | 4.428571428571429 | 0.935483870967742 | 0.2758620689655172 |
3660 | 3660 | Kaiser Foundation Hospital - Oakland/richmond | 50075 | 2022-09-30 | Alameda | 1 | Bay Area | 1.2857142857142858 | 1.7142857142857135 | 15.571428571428571 | 17.285714285714285 | 0.9008264462809916 | 0.0825688073394495 |
3667 | 3667 | Kaiser Foundation Hospital - San Leandro | 50777 | 2022-09-30 | Alameda | 1 | Bay Area | 1.5714285714285714 | 1.0 | 7.571428571428571 | 8.571428571428571 | 0.8833333333333333 | 0.2075471698113207 |
3689 | 3689 | Kindred Hospital - San Francisco Bay Area | 52034 | 2022-09-30 | Alameda | 1 | Bay Area | 0.0 | 4.285714285714286 | 5.714285714285714 | 10.0 | 0.5714285714285714 | 0.0 |
3820 | 3820 | St. Rose Hospital | 50002 | 2022-09-30 | Alameda | 1 | Bay Area | 0.0 | 2.714285714285713 | 9.285714285714286 | 12.0 | 0.7738095238095238 | 0.0 |
3822 | 3822 | Stanford Health Care - Valleycare | 50283 | 2022-09-30 | Alameda | 1 | Bay Area | 0.0 | 7.142857142857142 | 14.857142857142858 | 22.0 | 0.6753246753246753 | 0.0 |
3851 | 3851 | Washington Hospital | 50195 | 2022-09-30 | Alameda | 1 | Bay Area | 0.7142857142857143 | 13.857142857142858 | 14.142857142857142 | 28.0 | 0.5051020408163265 | 0.0505050505050505 |
3875 | 3875 | Alameda Hospital | 50211 | 2022-09-23 | Alameda | 1 | Bay Area | 0.0 | 1.5714285714285712 | 6.428571428571429 | 8.0 | 0.8035714285714286 | 0.0 |
3877 | 3877 | Alta Bates Summit Medical Center | 50043 | 2022-09-23 | Alameda | 1 | Bay Area | 0.5714285714285714 | 22.0 | 14.0 | 36.0 | 0.3888888888888889 | 0.0408163265306122 |
3878 | 3878 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305 | 2022-09-23 | Alameda | 1 | Bay Area | 0.7142857142857143 | 19.857142857142858 | 10.142857142857142 | 30.0 | 0.338095238095238 | 0.0704225352112676 |
3919 | 3919 | Eden Medical Center | 50488 | 2022-09-23 | Alameda | 1 | Bay Area | 0.5714285714285714 | 5.0 | 19.0 | 24.0 | 0.7916666666666666 | 0.0300751879699248 |
3945 | 3945 | Highland Hospital | 50320 | 2022-09-23 | Alameda | 1 | Bay Area | 0.0 | 8.285714285714285 | 24.714285714285715 | 33.0 | 0.748917748917749 | 0.0 |
3958 | 3958 | Kaiser Foundation Hospital - Fremont | 50512 | 2022-09-23 | Alameda | 1 | Bay Area | 2.142857142857143 | 0.7142857142857144 | 5.285714285714286 | 6.0 | 0.8809523809523809 | 0.4054054054054054 |
3961 | 3961 | Kaiser Foundation Hospital - Oakland/richmond | 50075 | 2022-09-23 | Alameda | 1 | Bay Area | 1.8571428571428568 | 1.142857142857144 | 12.714285714285714 | 13.857142857142858 | 0.9175257731958762 | 0.1460674157303371 |
3968 | 3968 | Kaiser Foundation Hospital - San Leandro | 50777 | 2022-09-23 | Alameda | 1 | Bay Area | 3.2857142857142856 | 1.2857142857142865 | 13.142857142857142 | 14.428571428571429 | 0.9108910891089108 | 0.25 |
3990 | 3990 | Kindred Hospital - San Francisco Bay Area | 52034 | 2022-09-23 | Alameda | 1 | Bay Area | 0.0 | 4.285714285714286 | 5.714285714285714 | 10.0 | 0.5714285714285714 | 0.0 |
4121 | 4121 | St. Rose Hospital | 50002 | 2022-09-23 | Alameda | 1 | Bay Area | 0.0 | 4.0 | 8.0 | 12.0 | 0.6666666666666666 | 0.0 |
4123 | 4123 | Stanford Health Care - Valleycare | 50283 | 2022-09-23 | Alameda | 1 | Bay Area | 0.0 | 6.857142857142858 | 15.142857142857142 | 22.0 | 0.6883116883116883 | 0.0 |
4152 | 4152 | Washington Hospital | 50195 | 2022-09-23 | Alameda | 1 | Bay Area | 0.0 | 11.0 | 17.0 | 28.0 | 0.6071428571428571 | 0.0 |
4176 | 4176 | Alameda Hospital | 50211 | 2022-09-16 | Alameda | 1 | Bay Area | 0.0 | 0.5714285714285712 | 7.428571428571429 | 8.0 | 0.9285714285714286 | 0.0 |
4178 | 4178 | Alta Bates Summit Medical Center | 50043 | 2022-09-16 | Alameda | 1 | Bay Area | 0.0 | 24.285714285714285 | 11.714285714285714 | 36.0 | 0.3253968253968253 | 0.0 |
4179 | 4179 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305 | 2022-09-16 | Alameda | 1 | Bay Area | 0.0 | 21.57142857142857 | 8.428571428571429 | 30.0 | 0.2809523809523809 | 0.0 |
4220 | 4220 | Eden Medical Center | 50488 | 2022-09-16 | Alameda | 1 | Bay Area | 0.5714285714285714 | 2.0 | 22.0 | 24.0 | 0.9166666666666666 | 0.0259740259740259 |
4245 | 4245 | Highland Hospital | 50320 | 2022-09-16 | Alameda | 1 | Bay Area | 0.7142857142857143 | 9.142857142857142 | 23.857142857142858 | 33.0 | 0.722943722943723 | 0.029940119760479 |
4258 | 4258 | Kaiser Foundation Hospital - Fremont | 50512 | 2022-09-16 | Alameda | 1 | Bay Area | 2.0 | 0.8571428571428568 | 5.428571428571429 | 6.285714285714286 | 0.8636363636363636 | 0.3684210526315789 |
4261 | 4261 | Kaiser Foundation Hospital - Oakland/richmond | 50075 | 2022-09-16 | Alameda | 1 | Bay Area | 1.1428571428571428 | 1.2857142857142865 | 13.142857142857142 | 14.428571428571429 | 0.9108910891089108 | 0.0869565217391304 |
4268 | 4268 | Kaiser Foundation Hospital - San Leandro | 50777 | 2022-09-16 | Alameda | 1 | Bay Area | 3.571428571428572 | 1.2857142857142865 | 13.571428571428571 | 14.857142857142858 | 0.9134615384615384 | 0.2631578947368421 |
4290 | 4290 | Kindred Hospital - San Francisco Bay Area | 52034 | 2022-09-16 | Alameda | 1 | Bay Area | 0.0 | 5.0 | 5.0 | 10.0 | 0.5 | 0.0 |
4419 | 4419 | St. Rose Hospital | 50002 | 2022-09-16 | Alameda | 1 | Bay Area | 0.0 | 5.142857142857143 | 6.857142857142857 | 12.0 | 0.5714285714285714 | 0.0 |
4421 | 4421 | Stanford Health Care - Valleycare | 50283 | 2022-09-16 | Alameda | 1 | Bay Area | 0.0 | 6.857142857142858 | 15.142857142857142 | 22.0 | 0.6883116883116883 | 0.0 |
4450 | 4450 | Washington Hospital | 50195 | 2022-09-16 | Alameda | 1 | Bay Area | 0.5714285714285714 | 13.0 | 15.0 | 28.0 | 0.5357142857142857 | 0.038095238095238 |
4473 | 4473 | Alameda Hospital | 50211 | 2022-09-09 | Alameda | 1 | Bay Area | 0.0 | 1.4285714285714288 | 6.571428571428571 | 8.0 | 0.8214285714285714 | 0.0 |
4475 | 4475 | Alta Bates Summit Medical Center | 50043 | 2022-09-09 | Alameda | 1 | Bay Area | 1.1428571428571428 | 21.285714285714285 | 14.714285714285714 | 36.0 | 0.4087301587301587 | 0.0776699029126213 |
4476 | 4476 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305 | 2022-09-09 | Alameda | 1 | Bay Area | 1.7142857142857142 | 21.285714285714285 | 8.714285714285714 | 30.0 | 0.2904761904761904 | 0.1967213114754098 |
4517 | 4517 | Eden Medical Center | 50488 | 2022-09-09 | Alameda | 1 | Bay Area | 3.142857142857143 | 1.7142857142857153 | 22.285714285714285 | 24.0 | 0.9285714285714284 | 0.141025641025641 |
4542 | 4542 | Highland Hospital | 50320 | 2022-09-09 | Alameda | 1 | Bay Area | 1.7142857142857142 | 10.142857142857142 | 22.857142857142858 | 33.0 | 0.6926406926406926 | 0.075 |
4555 | 4555 | Kaiser Foundation Hospital - Fremont | 50512 | 2022-09-09 | Alameda | 1 | Bay Area | 2.571428571428572 | 0.7142857142857135 | 8.285714285714286 | 9.0 | 0.9206349206349208 | 0.3103448275862069 |
4558 | 4558 | Kaiser Foundation Hospital - Oakland/richmond | 50075 | 2022-09-09 | Alameda | 1 | Bay Area | 1.8571428571428568 | 1.571428571428573 | 16.0 | 17.571428571428573 | 0.9105691056910568 | 0.1160714285714285 |
4565 | 4565 | Kaiser Foundation Hospital - San Leandro | 50777 | 2022-09-09 | Alameda | 1 | Bay Area | 2.0 | 1.1428571428571423 | 9.285714285714286 | 10.428571428571429 | 0.8904109589041096 | 0.2153846153846153 |
4587 | 4587 | Kindred Hospital - San Francisco Bay Area | 52034 | 2022-09-09 | Alameda | 1 | Bay Area | 0.0 | 6.0 | 4.0 | 10.0 | 0.4 | 0.0 |
4716 | 4716 | St. Rose Hospital | 50002 | 2022-09-09 | Alameda | 1 | Bay Area | 0.7142857142857143 | 3.7142857142857135 | 8.285714285714286 | 12.0 | 0.6904761904761906 | 0.0862068965517241 |
4718 | 4718 | Stanford Health Care - Valleycare | 50283 | 2022-09-09 | Alameda | 1 | Bay Area | 0.8571428571428571 | 5.714285714285715 | 16.285714285714285 | 22.0 | 0.7402597402597402 | 0.0526315789473684 |
4747 | 4747 | Washington Hospital | 50195 | 2022-09-09 | Alameda | 1 | Bay Area | 1.4285714285714286 | 13.0 | 15.0 | 28.0 | 0.5357142857142857 | 0.0952380952380952 |
4770 | 4770 | Alameda Hospital | 50211 | 2022-09-02 | Alameda | 1 | Bay Area | 1.2857142857142858 | 0.7142857142857144 | 7.285714285714286 | 8.0 | 0.9107142857142856 | 0.1764705882352941 |
4772 | 4772 | Alta Bates Summit Medical Center | 50043 | 2022-09-02 | Alameda | 1 | Bay Area | 1.0 | 23.285714285714285 | 12.714285714285714 | 36.0 | 0.3531746031746031 | 0.0786516853932584 |
4773 | 4773 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305 | 2022-09-02 | Alameda | 1 | Bay Area | 1.0 | 22.857142857142858 | 7.142857142857143 | 30.0 | 0.2380952380952381 | 0.1399999999999999 |
4814 | 4814 | Eden Medical Center | 50488 | 2022-09-02 | Alameda | 1 | Bay Area | 4.0 | 3.8571428571428577 | 20.142857142857142 | 24.0 | 0.8392857142857143 | 0.1985815602836879 |
4838 | 4838 | Highland Hospital | 50320 | 2022-09-02 | Alameda | 1 | Bay Area | 1.8571428571428568 | 10.0 | 23.0 | 33.0 | 0.696969696969697 | 0.0807453416149068 |
4851 | 4851 | Kaiser Foundation Hospital - Fremont | 50512 | 2022-09-02 | Alameda | 1 | Bay Area | 2.142857142857143 | 0.8571428571428577 | 5.857142857142857 | 6.714285714285714 | 0.8723404255319148 | 0.3658536585365853 |
4854 | 4854 | Kaiser Foundation Hospital - Oakland/richmond | 50075 | 2022-09-02 | Alameda | 1 | Bay Area | 2.2857142857142856 | 1.4285714285714288 | 14.428571428571429 | 15.857142857142858 | 0.90990990990991 | 0.1584158415841584 |
4861 | 4861 | Kaiser Foundation Hospital - San Leandro | 50777 | 2022-09-02 | Alameda | 1 | Bay Area | 1.8571428571428568 | 1.0 | 8.857142857142858 | 9.857142857142858 | 0.8985507246376812 | 0.2096774193548387 |
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 );