hhs-hospital-patient-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.
- adult_covid_patients_total
- The daily average of adult COVID-19 patients at the hospital over the past seven days.
- pediatric_covid_patients_total
- The daily average of pediatric COVID-19 patients at the hospital over the past seven days.
- covid_patients_total
- The daily average of total COVID-19 patients at the hospital over the past seven days.
- occupied_beds_percent
- The daily average of occupied beds over the past seven days, measured as a percentage of the hospital's total.
- patients_with_covid_percent
- The daily average of beds occupied by COVID-19 patients over the past seven days, measured as a percentage of the hospital's total.
48,633 rows sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | hospital | ccn | week | county | fips ▼ | region | adult_covid_patients_total | pediatric_covid_patients_total | covid_patients_total | occupied_beds_total | occupied_beds_percent | patients_with_covid_percent |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2465 | 2465 | St. Rose Hospital | 50002.0 | 2022-11-04 | Alameda | 1 | Bay Area | 0.5714285714285714 | 0.0 | 0.5714285714285714 | 53.285714285714285 | 0.5874015748031496 | 0.0107238605898123 |
2467 | 2467 | Stanford Health Care - Valleycare | 50283.0 | 2022-11-04 | Alameda | 1 | Bay Area | 6.285714285714286 | 0.0 | 6.285714285714286 | 129.57142857142858 | 0.5041689827682047 | 0.0485115766262403 |
2488 | 2488 | UCSF Benioff Children's Hospital Oakland | 053301 | 2022-11-04 | Alameda | 1 | Bay Area | 0.0 | 1.0 | 1.0 | 97.42857142857144 | 0.6538830297219559 | 0.0102639296187683 |
2502 | 2502 | Washington Hospital | 050195 | 2022-11-04 | Alameda | 1 | Bay Area | 8.428571428571429 | 0.7142857142857143 | 9.142857142857142 | 170.0 | 0.7896483078964831 | 0.053781512605042 |
2528 | 2528 | Alameda Hospital | 50211.0 | 2022-10-28 | Alameda | 1 | Bay Area | 0.0 | 0.0 | 0.0 | 34.857142857142854 | 0.3873015873015872 | 0.0 |
2530 | 2530 | Alta Bates Summit Medical Center | 50043.0 | 2022-10-28 | Alameda | 1 | Bay Area | 7.285714285714286 | 0.0 | 7.285714285714286 | 188.14285714285717 | 0.6334776334776334 | 0.0387243735763098 |
2531 | 2531 | Alta Bates Summit Medical Center - Alta Bates Camp | 050305 | 2022-10-28 | Alameda | 1 | Bay Area | 5.0 | 0.0 | 5.0 | 127.42857142857144 | 0.3130923130923131 | 0.0392376681614349 |
2580 | 2580 | Eden Medical Center | 050488 | 2022-10-28 | Alameda | 1 | Bay Area | 7.714285714285714 | 0.0 | 7.714285714285714 | 130.28571428571428 | 0.7965065502183405 | 0.0592105263157894 |
2608 | 2608 | Highland Hospital | 050320 | 2022-10-28 | Alameda | 1 | Bay Area | 3.2857142857142856 | 0.0 | 3.2857142857142856 | 178.85714285714286 | 0.414021164021164 | 0.0183706070287539 |
2623 | 2623 | Kaiser Foundation Hospital - Fremont | 50512.0 | 2022-10-28 | Alameda | 1 | Bay Area | 9.0 | 0.0 | 9.0 | 70.71428571428571 | 0.9099264705882352 | 0.1272727272727273 |
2626 | 2626 | Kaiser Foundation Hospital - Oakland/richmond | 50075.0 | 2022-10-28 | Alameda | 1 | Bay Area | 20.571428571428573 | 3.142857142857143 | 23.714285714285715 | 245.57142857142856 | 0.9095238095238096 | 0.0965677719604421 |
2633 | 2633 | Kaiser Foundation Hospital - San Leandro | 50777.0 | 2022-10-28 | Alameda | 1 | Bay Area | 30.428571428571427 | 0.0 | 30.428571428571427 | 162.85714285714286 | 0.908366533864542 | 0.1868421052631579 |
2657 | 2657 | Kindred Hospital - San Francisco Bay Area | 052034 | 2022-10-28 | Alameda | 1 | Bay Area | 0.0 | 0.0 | 0.0 | 59.71428571428572 | 0.6031746031746031 | 0.0 |
2802 | 2802 | St. Rose Hospital | 050002 | 2022-10-28 | Alameda | 1 | Bay Area | 0.0 | 0.0 | 0.0 | 49.71428571428572 | 0.5480314960629922 | 0.0 |
2804 | 2804 | Stanford Health Care - Valleycare | 50283.0 | 2022-10-28 | Alameda | 1 | Bay Area | 2.571428571428572 | 0.0 | 2.571428571428572 | 113.14285714285714 | 0.4402445803224013 | 0.0227272727272727 |
2825 | 2825 | UCSF Benioff Children's Hospital Oakland | 053301 | 2022-10-28 | Alameda | 1 | Bay Area | 0.0 | 0.5714285714285714 | 0.5714285714285714 | 93.0 | 0.6241610738255033 | 0.0061443932411674 |
2839 | 2839 | Washington Hospital | 050195 | 2022-10-28 | Alameda | 1 | Bay Area | 8.142857142857142 | 0.0 | 8.142857142857142 | 155.42857142857142 | 0.722923588039867 | 0.0523897058823529 |
2865 | 2865 | Alameda Hospital | 50211.0 | 2022-10-21 | Alameda | 1 | Bay Area | 0.0 | 0.0 | 0.0 | 37.71428571428572 | 0.419047619047619 | 0.0 |
2867 | 2867 | Alta Bates Summit Medical Center | 050043 | 2022-10-21 | Alameda | 1 | Bay Area | 7.0 | 0.0 | 7.0 | 174.85714285714286 | 0.5887445887445888 | 0.040032679738562 |
2868 | 2868 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305.0 | 2022-10-21 | Alameda | 1 | Bay Area | 4.428571428571429 | 0.0 | 4.428571428571429 | 118.71428571428572 | 0.2916812916812916 | 0.0373044524669073 |
2916 | 2916 | Eden Medical Center | 050488 | 2022-10-21 | Alameda | 1 | Bay Area | 3.857142857142857 | 0.0 | 3.857142857142857 | 117.28571428571428 | 0.7182852143482066 | 0.0328867235079171 |
2944 | 2944 | Highland Hospital | 050320 | 2022-10-21 | Alameda | 1 | Bay Area | 2.2857142857142856 | 0.0 | 2.2857142857142856 | 181.14285714285717 | 0.4193121693121693 | 0.0126182965299684 |
2959 | 2959 | Kaiser Foundation Hospital - Fremont | 050512 | 2022-10-21 | Alameda | 1 | Bay Area | 8.714285714285714 | 0.0 | 8.714285714285714 | 65.71428571428571 | 0.9108910891089108 | 0.1326086956521739 |
2962 | 2962 | Kaiser Foundation Hospital - Oakland/richmond | 050075 | 2022-10-21 | Alameda | 1 | Bay Area | 19.714285714285715 | 1.7142857142857142 | 21.42857142857143 | 237.57142857142856 | 0.9082468596395412 | 0.0901984365604329 |
2969 | 2969 | Kaiser Foundation Hospital - San Leandro | 50777.0 | 2022-10-21 | Alameda | 1 | Bay Area | 28.428571428571427 | 0.0 | 28.428571428571427 | 162.57142857142858 | 0.909672262190248 | 0.1748681898066783 |
2991 | 2991 | Kindred Hospital - San Francisco Bay Area | 052034 | 2022-10-21 | Alameda | 1 | Bay Area | 0.0 | 0.0 | 0.0 | 59.285714285714285 | 0.5988455988455988 | 0.0 |
3135 | 3135 | St. Rose Hospital | 50002.0 | 2022-10-21 | Alameda | 1 | Bay Area | 0.5714285714285714 | 0.0 | 0.5714285714285714 | 45.285714285714285 | 0.4992125984251969 | 0.0126182965299684 |
3137 | 3137 | Stanford Health Care - Valleycare | 050283 | 2022-10-21 | Alameda | 1 | Bay Area | 2.4285714285714284 | 0.0 | 2.4285714285714284 | 120.14285714285714 | 0.4674819344080044 | 0.0202140309155766 |
3158 | 3158 | UCSF Benioff Children's Hospital Oakland | 053301 | 2022-10-21 | Alameda | 1 | Bay Area | 0.0 | 1.1428571428571428 | 1.1428571428571428 | 94.71428571428572 | 0.635666347075743 | 0.0120663650075414 |
3172 | 3172 | Washington Hospital | 050195 | 2022-10-21 | Alameda | 1 | Bay Area | 5.428571428571429 | 0.0 | 5.428571428571429 | 165.28571428571428 | 0.7687707641196013 | 0.0328435609334485 |
3198 | 3198 | Alameda Hospital | 050211 | 2022-10-14 | Alameda | 1 | Bay Area | 0.0 | 0.0 | 0.0 | 40.42857142857143 | 0.4492063492063492 | 0.0 |
3200 | 3200 | Alta Bates Summit Medical Center | 50043.0 | 2022-10-14 | Alameda | 1 | Bay Area | 8.285714285714286 | 0.0 | 8.285714285714286 | 183.7142857142857 | 0.6185666185666185 | 0.0451010886469673 |
3201 | 3201 | Alta Bates Summit Medical Center - Alta Bates Camp | 050305 | 2022-10-14 | Alameda | 1 | Bay Area | 7.285714285714286 | 0.0 | 7.285714285714286 | 124.71428571428572 | 0.3064233064233064 | 0.0584192439862542 |
3247 | 3247 | Eden Medical Center | 050488 | 2022-10-14 | Alameda | 1 | Bay Area | 8.571428571428571 | 0.0 | 8.571428571428571 | 126.71428571428572 | 0.7767075306479859 | 0.0676437429537767 |
3274 | 3274 | Highland Hospital | 050320 | 2022-10-14 | Alameda | 1 | Bay Area | 3.571428571428572 | 0.0 | 3.571428571428572 | 173.0 | 0.4004629629629629 | 0.0206440957886044 |
3289 | 3289 | Kaiser Foundation Hospital - Fremont | 50512.0 | 2022-10-14 | Alameda | 1 | Bay Area | 11.428571428571429 | 0.0 | 11.428571428571429 | 66.28571428571429 | 0.9115913555992144 | 0.1724137931034482 |
3292 | 3292 | Kaiser Foundation Hospital - Oakland/richmond | 050075 | 2022-10-14 | Alameda | 1 | Bay Area | 19.714285714285715 | 2.142857142857143 | 21.857142857142858 | 232.57142857142856 | 0.9079754601226994 | 0.0939803439803439 |
3299 | 3299 | Kaiser Foundation Hospital - San Leandro | 050777 | 2022-10-14 | Alameda | 1 | Bay Area | 26.285714285714285 | 0.0 | 26.285714285714285 | 160.0 | 0.908353609083536 | 0.1642857142857142 |
3323 | 3323 | Kindred Hospital - San Francisco Bay Area | 52034.0 | 2022-10-14 | Alameda | 1 | Bay Area | 0.0 | 0.0 | 0.0 | 54.85714285714285 | 0.5541125541125541 | 0.0 |
3467 | 3467 | St. Rose Hospital | 050002 | 2022-10-14 | Alameda | 1 | Bay Area | 1.0 | 0.0 | 1.0 | 52.85714285714285 | 0.5826771653543307 | 0.0189189189189189 |
3469 | 3469 | Stanford Health Care - Valleycare | 050283 | 2022-10-14 | Alameda | 1 | Bay Area | 1.5714285714285714 | 0.0 | 1.5714285714285714 | 117.57142857142856 | 0.5337224383916991 | 0.0133657351154313 |
3490 | 3490 | UCSF Benioff Children's Hospital Oakland | 053301 | 2022-10-14 | Alameda | 1 | Bay Area | 0.0 | 0.7142857142857143 | 0.7142857142857143 | 96.0 | 0.6442953020134228 | 0.0074404761904761 |
3504 | 3504 | Washington Hospital | 050195 | 2022-10-14 | Alameda | 1 | Bay Area | 6.857142857142857 | 0.0 | 6.857142857142857 | 164.57142857142858 | 0.7654485049833888 | 0.0416666666666666 |
3530 | 3530 | Alameda Hospital | 50211.0 | 2022-10-07 | Alameda | 1 | Bay Area | 0.0 | 0.0 | 0.0 | 34.0 | 0.3777777777777777 | 0.0 |
3532 | 3532 | Alta Bates Summit Medical Center | 50043.0 | 2022-10-07 | Alameda | 1 | Bay Area | 6.285714285714286 | 0.0 | 6.285714285714286 | 174.28571428571428 | 0.5868205868205868 | 0.0360655737704918 |
3533 | 3533 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305.0 | 2022-10-07 | Alameda | 1 | Bay Area | 4.0 | 0.0 | 4.0 | 111.0 | 0.2727272727272727 | 0.036036036036036 |
3580 | 3580 | Eden Medical Center | 50488.0 | 2022-10-07 | Alameda | 1 | Bay Area | 9.571428571428571 | 0.0 | 9.571428571428571 | 129.0 | 0.787958115183246 | 0.0741971207087486 |
3608 | 3608 | Highland Hospital | 50320.0 | 2022-10-07 | Alameda | 1 | Bay Area | 1.2857142857142858 | 0.0 | 1.2857142857142858 | 182.8571428571429 | 0.4232804232804233 | 0.00703125 |
3623 | 3623 | Kaiser Foundation Hospital - Fremont | 50512.0 | 2022-10-07 | Alameda | 1 | Bay Area | 8.857142857142858 | 0.0 | 8.857142857142858 | 58.85714285714285 | 0.9074889867841408 | 0.1504854368932039 |
3626 | 3626 | Kaiser Foundation Hospital - Oakland/richmond | 050075 | 2022-10-07 | Alameda | 1 | Bay Area | 16.428571428571427 | 3.2857142857142856 | 19.71428571428571 | 222.57142857142856 | 0.9089848308051344 | 0.0885750962772785 |
3633 | 3633 | Kaiser Foundation Hospital - San Leandro | 50777.0 | 2022-10-07 | Alameda | 1 | Bay Area | 22.714285714285715 | 0.0 | 22.714285714285715 | 162.28571428571428 | 0.9073482428115016 | 0.1399647887323943 |
3656 | 3656 | Kindred Hospital - San Francisco Bay Area | 052034 | 2022-10-07 | Alameda | 1 | Bay Area | 0.5714285714285714 | 0.0 | 0.5714285714285714 | 52.85714285714285 | 0.5339105339105339 | 0.0108108108108108 |
3800 | 3800 | St. Rose Hospital | 050002 | 2022-10-07 | Alameda | 1 | Bay Area | 1.7142857142857142 | 0.0 | 1.7142857142857142 | 51.142857142857146 | 0.5637795275590551 | 0.0335195530726257 |
3802 | 3802 | Stanford Health Care - Valleycare | 050283 | 2022-10-07 | Alameda | 1 | Bay Area | 1.4285714285714286 | 0.0 | 1.4285714285714286 | 115.71428571428572 | 0.5252918287937743 | 0.0123456790123456 |
3823 | 3823 | UCSF Benioff Children's Hospital Oakland | 053301 | 2022-10-07 | Alameda | 1 | Bay Area | 0.0 | 1.5714285714285714 | 1.5714285714285714 | 93.42857142857144 | 0.6270373921380633 | 0.0168195718654434 |
3837 | 3837 | Washington Hospital | 50195.0 | 2022-10-07 | Alameda | 1 | Bay Area | 6.285714285714286 | 0.0 | 6.285714285714286 | 164.57142857142858 | 0.7644326476443266 | 0.0381944444444444 |
3863 | 3863 | Alameda Hospital | 050211 | 2022-09-30 | Alameda | 1 | Bay Area | 1.0 | 0.0 | 1.0 | 38.0 | 0.4222222222222222 | 0.0263157894736842 |
3865 | 3865 | Alta Bates Summit Medical Center | 50043.0 | 2022-09-30 | Alameda | 1 | Bay Area | 8.285714285714286 | 0.0 | 8.285714285714286 | 164.57142857142858 | 0.5541125541125541 | 0.0503472222222222 |
3866 | 3866 | Alta Bates Summit Medical Center - Alta Bates Camp | 050305 | 2022-09-30 | Alameda | 1 | Bay Area | 4.571428571428571 | 0.0 | 4.571428571428571 | 116.57142857142856 | 0.2864162864162864 | 0.0392156862745098 |
3913 | 3913 | Eden Medical Center | 50488.0 | 2022-09-30 | Alameda | 1 | Bay Area | 6.142857142857143 | 0.0 | 6.142857142857143 | 124.71428571428572 | 0.7644483362521891 | 0.0492554410080183 |
3940 | 3940 | Highland Hospital | 050320 | 2022-09-30 | Alameda | 1 | Bay Area | 1.8571428571428568 | 0.0 | 1.8571428571428568 | 181.7142857142857 | 0.4206349206349206 | 0.0102201257861635 |
3955 | 3955 | Kaiser Foundation Hospital - Fremont | 50512.0 | 2022-09-30 | Alameda | 1 | Bay Area | 8.571428571428571 | 0.0 | 8.571428571428571 | 57.142857142857146 | 0.9090909090909092 | 0.15 |
3958 | 3958 | Kaiser Foundation Hospital - Oakland/richmond | 50075.0 | 2022-09-30 | Alameda | 1 | Bay Area | 18.142857142857142 | 1.2857142857142858 | 19.428571428571427 | 222.57142857142856 | 0.9084548104956268 | 0.0872913992297817 |
3965 | 3965 | Kaiser Foundation Hospital - San Leandro | 50777.0 | 2022-09-30 | Alameda | 1 | Bay Area | 26.0 | 0.0 | 26.0 | 167.71428571428572 | 0.9093725793958172 | 0.1550255536626916 |
3987 | 3987 | Kindred Hospital - San Francisco Bay Area | 52034.0 | 2022-09-30 | Alameda | 1 | Bay Area | 1.0 | 0.0 | 1.0 | 52.57142857142857 | 0.531024531024531 | 0.0190217391304347 |
4130 | 4130 | St. Rose Hospital | 050002 | 2022-09-30 | Alameda | 1 | Bay Area | 0.5714285714285714 | 0.0 | 0.5714285714285714 | 55.71428571428572 | 0.6141732283464567 | 0.0102564102564102 |
4132 | 4132 | Stanford Health Care - Valleycare | 050283 | 2022-09-30 | Alameda | 1 | Bay Area | 2.2857142857142856 | 0.0 | 2.2857142857142856 | 111.71428571428572 | 0.5071335927367056 | 0.0204603580562659 |
4153 | 4153 | UCSF Benioff Children's Hospital Oakland | 53301.0 | 2022-09-30 | Alameda | 1 | Bay Area | 0.0 | 1.1428571428571428 | 1.1428571428571428 | 96.0 | 0.6442953020134228 | 0.0119047619047619 |
4167 | 4167 | Washington Hospital | 50195.0 | 2022-09-30 | Alameda | 1 | Bay Area | 4.857142857142857 | 0.0 | 4.857142857142857 | 164.14285714285714 | 0.7634551495016612 | 0.0295909486510008 |
4193 | 4193 | Alameda Hospital | 50211.0 | 2022-09-23 | Alameda | 1 | Bay Area | 0.0 | 0.0 | 0.0 | 41.142857142857146 | 0.4571428571428572 | 0.0 |
4195 | 4195 | Alta Bates Summit Medical Center | 050043 | 2022-09-23 | Alameda | 1 | Bay Area | 10.142857142857142 | 0.0 | 10.142857142857142 | 183.57142857142856 | 0.6180856180856181 | 0.0552529182879377 |
4196 | 4196 | Alta Bates Summit Medical Center - Alta Bates Camp | 050305 | 2022-09-23 | Alameda | 1 | Bay Area | 6.0 | 0.0 | 6.0 | 122.71428571428572 | 0.3015093015093015 | 0.0488940628637951 |
4244 | 4244 | Eden Medical Center | 50488.0 | 2022-09-23 | Alameda | 1 | Bay Area | 8.571428571428571 | 0.0 | 8.571428571428571 | 134.71428571428572 | 0.8264680105170903 | 0.0636267232237539 |
4270 | 4270 | Highland Hospital | 050320 | 2022-09-23 | Alameda | 1 | Bay Area | 1.4285714285714286 | 0.0 | 1.4285714285714286 | 188.8571428571429 | 0.4371693121693121 | 0.0075642965204236 |
4285 | 4285 | Kaiser Foundation Hospital - Fremont | 50512.0 | 2022-09-23 | Alameda | 1 | Bay Area | 14.142857142857142 | 0.0 | 14.142857142857142 | 65.57142857142857 | 0.9089108910891088 | 0.2156862745098039 |
4288 | 4288 | Kaiser Foundation Hospital - Oakland/richmond | 50075.0 | 2022-09-23 | Alameda | 1 | Bay Area | 21.571428571428573 | 3.0 | 24.571428571428573 | 235.7142857142857 | 0.908590308370044 | 0.1042424242424242 |
4295 | 4295 | Kaiser Foundation Hospital - San Leandro | 050777 | 2022-09-23 | Alameda | 1 | Bay Area | 33.142857142857146 | 0.0 | 33.142857142857146 | 174.85714285714286 | 0.9134328358208956 | 0.1895424836601307 |
4318 | 4318 | Kindred Hospital - San Francisco Bay Area | 52034.0 | 2022-09-23 | Alameda | 1 | Bay Area | 0.0 | 0.0 | 0.0 | 52.71428571428572 | 0.5324675324675324 | 0.0 |
4462 | 4462 | St. Rose Hospital | 50002.0 | 2022-09-23 | Alameda | 1 | Bay Area | 0.5714285714285714 | 0.0 | 0.5714285714285714 | 52.71428571428572 | 0.5811023622047244 | 0.010840108401084 |
4464 | 4464 | Stanford Health Care - Valleycare | 50283.0 | 2022-09-23 | Alameda | 1 | Bay Area | 2.142857142857143 | 0.0 | 2.142857142857143 | 112.85714285714286 | 0.5123216601815824 | 0.0189873417721518 |
4485 | 4485 | UCSF Benioff Children's Hospital Oakland | 053301 | 2022-09-23 | Alameda | 1 | Bay Area | 0.0 | 2.571428571428572 | 2.571428571428572 | 92.85714285714286 | 0.62320230105465 | 0.0276923076923076 |
4499 | 4499 | Washington Hospital | 50195.0 | 2022-09-23 | Alameda | 1 | Bay Area | 6.571428571428571 | 0.0 | 6.571428571428571 | 164.42857142857142 | 0.7592348284960421 | 0.0399652476107732 |
4525 | 4525 | Alameda Hospital | 050211 | 2022-09-16 | Alameda | 1 | Bay Area | 0.7142857142857143 | 0.0 | 0.7142857142857143 | 41.42857142857143 | 0.4603174603174603 | 0.0172413793103448 |
4527 | 4527 | Alta Bates Summit Medical Center | 50043.0 | 2022-09-16 | Alameda | 1 | Bay Area | 14.571428571428571 | 0.0 | 14.571428571428571 | 190.8571428571429 | 0.6426166426166426 | 0.0763473053892215 |
4528 | 4528 | Alta Bates Summit Medical Center - Alta Bates Camp | 050305 | 2022-09-16 | Alameda | 1 | Bay Area | 6.571428571428571 | 0.0 | 6.571428571428571 | 125.57142857142856 | 0.3085293085293085 | 0.0523321956769055 |
4575 | 4575 | Eden Medical Center | 50488.0 | 2022-09-16 | Alameda | 1 | Bay Area | 10.571428571428571 | 0.0 | 10.571428571428571 | 139.85714285714286 | 0.8557692307692308 | 0.0755873340143003 |
4602 | 4602 | Highland Hospital | 50320.0 | 2022-09-16 | Alameda | 1 | Bay Area | 4.714285714285714 | 0.0 | 4.714285714285714 | 178.71428571428572 | 0.4136904761904762 | 0.026378896882494 |
4617 | 4617 | Kaiser Foundation Hospital - Fremont | 050512 | 2022-09-16 | Alameda | 1 | Bay Area | 15.142857142857142 | 0.0 | 15.142857142857142 | 64.71428571428571 | 0.9096385542168676 | 0.2339955849889624 |
4620 | 4620 | Kaiser Foundation Hospital - Oakland/richmond | 50075.0 | 2022-09-16 | Alameda | 1 | Bay Area | 19.428571428571427 | 4.571428571428571 | 24.0 | 225.42857142857144 | 0.9089861751152072 | 0.1064638783269962 |
4627 | 4627 | Kaiser Foundation Hospital - San Leandro | 050777 | 2022-09-16 | Alameda | 1 | Bay Area | 34.142857142857146 | 0.0 | 34.142857142857146 | 171.42857142857142 | 0.911854103343465 | 0.1991666666666667 |
4651 | 4651 | Kindred Hospital - San Francisco Bay Area | 052034 | 2022-09-16 | Alameda | 1 | Bay Area | 0.0 | 0.0 | 0.0 | 53.57142857142857 | 0.5411255411255411 | 0.0 |
4794 | 4794 | St. Rose Hospital | 050002 | 2022-09-16 | Alameda | 1 | Bay Area | 1.0 | 0.0 | 1.0 | 56.142857142857146 | 0.6188976377952756 | 0.0178117048346055 |
4796 | 4796 | Stanford Health Care - Valleycare | 50283.0 | 2022-09-16 | Alameda | 1 | Bay Area | 2.7142857142857144 | 0.0 | 2.7142857142857144 | 108.14285714285714 | 0.4909208819714656 | 0.0250990752972258 |
4817 | 4817 | UCSF Benioff Children's Hospital Oakland | 053301 | 2022-09-16 | Alameda | 1 | Bay Area | 0.0 | 2.2857142857142856 | 2.2857142857142856 | 87.14285714285714 | 0.5848513902205177 | 0.0262295081967213 |
4830 | 4830 | Washington Hospital | 50195.0 | 2022-09-16 | Alameda | 1 | Bay Area | 6.285714285714286 | 0.0 | 6.285714285714286 | 173.71428571428572 | 0.8063660477453581 | 0.0361842105263157 |
4856 | 4856 | Alameda Hospital | 050211 | 2022-09-09 | Alameda | 1 | Bay Area | 1.4285714285714286 | 0.0 | 1.4285714285714286 | 40.285714285714285 | 0.4476190476190476 | 0.0354609929078014 |
4858 | 4858 | Alta Bates Summit Medical Center | 50043.0 | 2022-09-09 | Alameda | 1 | Bay Area | 14.857142857142858 | 0.0 | 14.857142857142858 | 192.57142857142856 | 0.6483886483886484 | 0.0771513353115727 |
4859 | 4859 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305.0 | 2022-09-09 | Alameda | 1 | Bay Area | 9.857142857142858 | 0.0 | 9.857142857142858 | 122.28571428571428 | 0.3004563004563004 | 0.080607476635514 |
4905 | 4905 | Eden Medical Center | 050488 | 2022-09-09 | Alameda | 1 | Bay Area | 14.0 | 0.0 | 14.0 | 139.14285714285714 | 0.8528896672504378 | 0.1006160164271047 |
4933 | 4933 | Highland Hospital | 50320.0 | 2022-09-09 | Alameda | 1 | Bay Area | 5.714285714285714 | 0.0 | 5.714285714285714 | 184.42857142857144 | 0.4269179894179893 | 0.0309837335398915 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "hhs-hospital-patient-totals" ( [hospital] TEXT, [ccn] TEXT, [week] TEXT, [county] TEXT, [fips] INTEGER, [region] TEXT, [adult_covid_patients_total] FLOAT, [pediatric_covid_patients_total] FLOAT, [covid_patients_total] FLOAT, [occupied_beds_total] FLOAT, [occupied_beds_percent] FLOAT, [patients_with_covid_percent] FLOAT );