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)
Suggested facets: week (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16 | 16 | Alameda Hospital | 50211.0 | 2022-12-23 | Alameda | 1 | Bay Area | 1.25 | 0.0 | 1.25 | 42.0 | 0.4666666666666667 | 0.0297619047619047 |
18 | 18 | Alta Bates Summit Medical Center | 050043 | 2022-12-23 | Alameda | 1 | Bay Area | 26.0 | 0.0 | 26.0 | 218.0 | 0.734006734006734 | 0.1192660550458715 |
19 | 19 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305.0 | 2022-12-23 | Alameda | 1 | Bay Area | 16.0 | 0.0 | 16.0 | 160.0 | 0.3931203931203931 | 0.1 |
53 | 53 | Eden Medical Center | 50488.0 | 2022-12-23 | Alameda | 1 | Bay Area | 21.0 | 0.0 | 21.0 | 160.0 | 0.975609756097561 | 0.13125 |
76 | 76 | Highland Hospital | 50320.0 | 2022-12-23 | Alameda | 1 | Bay Area | 6.75 | 0.0 | 6.75 | 173.5 | 0.4016203703703703 | 0.0389048991354466 |
91 | 91 | Kaiser Foundation Hospital - Fremont | 50512.0 | 2022-12-23 | Alameda | 1 | Bay Area | 17.0 | 0.0 | 17.0 | 77.0 | 0.9058823529411764 | 0.2207792207792207 |
94 | 94 | Kaiser Foundation Hospital - Oakland/richmond | 50075.0 | 2022-12-23 | Alameda | 1 | Bay Area | 69.0 | 0.0 | 69.0 | 314.0 | 0.923529411764706 | 0.2197452229299363 |
101 | 101 | Kaiser Foundation Hospital - San Leandro | 50777.0 | 2022-12-23 | Alameda | 1 | Bay Area | 45.0 | 0.0 | 45.0 | 174.0 | 0.9109947643979056 | 0.2586206896551724 |
122 | 122 | Kindred Hospital - San Francisco Bay Area | 52034.0 | 2022-12-23 | Alameda | 1 | Bay Area | 0.0 | 0.0 | 0.0 | 57.0 | 0.5757575757575758 | 0.0 |
230 | 230 | St. Rose Hospital | 50002.0 | 2022-12-23 | Alameda | 1 | Bay Area | 0.0 | 0.0 | 0.0 | 51.0 | 0.6375 | 0.0 |
232 | 232 | Stanford Health Care - Valleycare | 50283.0 | 2022-12-23 | Alameda | 1 | Bay Area | 4.0 | 0.0 | 4.0 | 121.0 | 0.4708171206225681 | 0.0330578512396694 |
253 | 253 | UCSF Benioff Children's Hospital Oakland | 53301.0 | 2022-12-23 | Alameda | 1 | Bay Area | 0.0 | 5.0 | 5.0 | 75.0 | 0.5033557046979866 | 0.0666666666666666 |
264 | 264 | Washington Hospital | 050195 | 2022-12-23 | Alameda | 1 | Bay Area | 24.0 | 0.0 | 24.0 | 210.0 | 0.84 | 0.1142857142857142 |
288 | 288 | Alameda Hospital | 50211.0 | 2022-12-16 | Alameda | 1 | Bay Area | 2.4285714285714284 | 0.0 | 2.4285714285714284 | 50.142857142857146 | 0.5571428571428572 | 0.0484330484330484 |
290 | 290 | Alta Bates Summit Medical Center | 050043 | 2022-12-16 | Alameda | 1 | Bay Area | 26.0 | 0.0 | 26.0 | 217.14285714285717 | 0.7311207311207311 | 0.1197368421052631 |
291 | 291 | Alta Bates Summit Medical Center - Alta Bates Camp | 050305 | 2022-12-16 | Alameda | 1 | Bay Area | 19.0 | 0.0 | 19.0 | 133.14285714285714 | 0.3271323271323271 | 0.1427038626609442 |
328 | 328 | Eden Medical Center | 050488 | 2022-12-16 | Alameda | 1 | Bay Area | 21.571428571428573 | 0.0 | 21.571428571428573 | 153.0 | 0.931304347826087 | 0.1409897292250233 |
351 | 351 | Highland Hospital | 50320.0 | 2022-12-16 | Alameda | 1 | Bay Area | 6.428571428571429 | 0.0 | 6.428571428571429 | 189.28571428571428 | 0.4381613756613756 | 0.0339622641509433 |
366 | 366 | Kaiser Foundation Hospital - Fremont | 50512.0 | 2022-12-16 | Alameda | 1 | Bay Area | 23.857142857142858 | 0.0 | 23.857142857142858 | 77.71428571428571 | 0.7431693989071038 | 0.3069852941176471 |
369 | 369 | Kaiser Foundation Hospital - Oakland/richmond | 050075 | 2022-12-16 | Alameda | 1 | Bay Area | 73.57142857142857 | 4.0 | 77.57142857142857 | 327.1428571428572 | 0.6699824458747806 | 0.237117903930131 |
376 | 376 | Kaiser Foundation Hospital - San Leandro | 50777.0 | 2022-12-16 | Alameda | 1 | Bay Area | 48.42857142857143 | 0.0 | 48.42857142857143 | 179.14285714285714 | 0.7389510901591043 | 0.2703349282296651 |
398 | 398 | Kindred Hospital - San Francisco Bay Area | 52034.0 | 2022-12-16 | Alameda | 1 | Bay Area | 0.0 | 0.0 | 0.0 | 54.57142857142857 | 0.5512265512265512 | 0.0 |
518 | 518 | St. Rose Hospital | 050002 | 2022-12-16 | Alameda | 1 | Bay Area | 3.4285714285714284 | 0.0 | 3.4285714285714284 | 43.71428571428572 | 0.4818897637795276 | 0.0784313725490196 |
520 | 520 | Stanford Health Care - Valleycare | 50283.0 | 2022-12-16 | Alameda | 1 | Bay Area | 8.0 | 0.0 | 8.0 | 119.8 | 0.466147859922179 | 0.0667779632721202 |
541 | 541 | UCSF Benioff Children's Hospital Oakland | 53301.0 | 2022-12-16 | Alameda | 1 | Bay Area | 0.0 | 2.142857142857143 | 2.142857142857143 | 87.28571428571429 | 0.5858101629913711 | 0.0245499181669394 |
552 | 552 | Washington Hospital | 50195.0 | 2022-12-16 | Alameda | 1 | Bay Area | 26.0 | 0.0 | 26.0 | 200.0 | 0.8413461538461539 | 0.13 |
577 | 577 | Alameda Hospital | 50211.0 | 2022-12-09 | Alameda | 1 | Bay Area | 2.142857142857143 | 0.0 | 2.142857142857143 | 53.0 | 0.5888888888888889 | 0.0404312668463611 |
579 | 579 | Alta Bates Summit Medical Center | 050043 | 2022-12-09 | Alameda | 1 | Bay Area | 18.142857142857142 | 0.0 | 18.142857142857142 | 208.28571428571428 | 0.7012987012987013 | 0.0871056241426611 |
580 | 580 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305.0 | 2022-12-09 | Alameda | 1 | Bay Area | 16.571428571428573 | 0.0 | 16.571428571428573 | 147.28571428571428 | 0.3618813618813619 | 0.1125121241513094 |
623 | 623 | Eden Medical Center | 50488.0 | 2022-12-09 | Alameda | 1 | Bay Area | 18.0 | 0.0 | 18.0 | 133.85714285714286 | 0.8197725284339458 | 0.1344717182497332 |
650 | 650 | Highland Hospital | 050320 | 2022-12-09 | Alameda | 1 | Bay Area | 13.0 | 0.0 | 13.0 | 186.8571428571429 | 0.4325396825396825 | 0.069571865443425 |
665 | 665 | Kaiser Foundation Hospital - Fremont | 50512.0 | 2022-12-09 | Alameda | 1 | Bay Area | 25.714285714285715 | 0.0 | 25.714285714285715 | 82.14285714285714 | 0.8493353028064993 | 0.3130434782608696 |
668 | 668 | Kaiser Foundation Hospital - Oakland/richmond | 050075 | 2022-12-09 | Alameda | 1 | Bay Area | 53.42857142857143 | 3.0 | 56.42857142857143 | 270.2857142857143 | 0.8016949152542372 | 0.2087737843551797 |
675 | 675 | Kaiser Foundation Hospital - San Leandro | 50777.0 | 2022-12-09 | Alameda | 1 | Bay Area | 46.42857142857143 | 0.0 | 46.42857142857143 | 176.28571428571428 | 0.8394557823129252 | 0.2633711507293355 |
698 | 698 | Kindred Hospital - San Francisco Bay Area | 52034.0 | 2022-12-09 | Alameda | 1 | Bay Area | 0.0 | 0.0 | 0.0 | 58.285714285714285 | 0.5887445887445887 | 0.0 |
820 | 820 | St. Rose Hospital | 050002 | 2022-12-09 | Alameda | 1 | Bay Area | 3.571428571428572 | 0.0 | 3.571428571428572 | 35.142857142857146 | 0.3874015748031497 | 0.1016260162601626 |
822 | 822 | Stanford Health Care - Valleycare | 050283 | 2022-12-09 | Alameda | 1 | Bay Area | 6.0 | 0.0 | 6.0 | 120.5 | 0.4688715953307393 | 0.0497925311203319 |
843 | 843 | UCSF Benioff Children's Hospital Oakland | 53301.0 | 2022-12-09 | Alameda | 1 | Bay Area | 0.0 | 2.571428571428572 | 2.571428571428572 | 88.85714285714286 | 0.5963566634707574 | 0.0289389067524115 |
857 | 857 | Washington Hospital | 050195 | 2022-12-09 | Alameda | 1 | Bay Area | 32.42857142857143 | 0.0 | 32.42857142857143 | 191.28571428571428 | 0.8245073891625615 | 0.169529499626587 |
882 | 882 | Alameda Hospital | 050211 | 2022-12-02 | Alameda | 1 | Bay Area | 2.857142857142857 | 0.0 | 2.857142857142857 | 54.0 | 0.6 | 0.0529100529100529 |
884 | 884 | Alta Bates Summit Medical Center | 050043 | 2022-12-02 | Alameda | 1 | Bay Area | 14.428571428571429 | 0.0 | 14.428571428571429 | 215.28571428571428 | 0.7248677248677249 | 0.0670205706702057 |
885 | 885 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305.0 | 2022-12-02 | Alameda | 1 | Bay Area | 10.285714285714286 | 0.0 | 10.285714285714286 | 158.14285714285714 | 0.3885573885573885 | 0.065040650406504 |
932 | 932 | Eden Medical Center | 050488 | 2022-12-02 | Alameda | 1 | Bay Area | 16.285714285714285 | 0.0 | 16.285714285714285 | 142.28571428571428 | 0.8729184925503943 | 0.1144578313253012 |
959 | 959 | Highland Hospital | 50320.0 | 2022-12-02 | Alameda | 1 | Bay Area | 12.142857142857142 | 0.0 | 12.142857142857142 | 191.8571428571429 | 0.4441137566137566 | 0.0632911392405063 |
974 | 974 | Kaiser Foundation Hospital - Fremont | 050512 | 2022-12-02 | Alameda | 1 | Bay Area | 27.428571428571427 | 0.0 | 27.428571428571427 | 85.14285714285714 | 0.767052767052767 | 0.3221476510067114 |
977 | 977 | Kaiser Foundation Hospital - Oakland/richmond | 050075 | 2022-12-02 | Alameda | 1 | Bay Area | 40.0 | 4.142857142857143 | 44.142857142857146 | 249.0 | 0.6137323943661972 | 0.1772805507745267 |
984 | 984 | Kaiser Foundation Hospital - San Leandro | 50777.0 | 2022-12-02 | Alameda | 1 | Bay Area | 40.71428571428572 | 0.0 | 40.71428571428572 | 176.14285714285714 | 0.7278630460448642 | 0.2311435523114355 |
1007 | 1007 | Kindred Hospital - San Francisco Bay Area | 52034.0 | 2022-12-02 | Alameda | 1 | Bay Area | 0.0 | 0.0 | 0.0 | 57.0 | 0.5757575757575758 | 0.0 |
1150 | 1150 | St. Rose Hospital | 050002 | 2022-12-02 | Alameda | 1 | Bay Area | 1.4285714285714286 | 0.0 | 1.4285714285714286 | 39.71428571428572 | 0.4377952755905512 | 0.0359712230215827 |
1152 | 1152 | Stanford Health Care - Valleycare | 050283 | 2022-12-02 | Alameda | 1 | Bay Area | 8.857142857142858 | 1.7142857142857142 | 10.571428571428571 | 124.57142857142856 | 0.4847137298499166 | 0.0848623853211009 |
1172 | 1172 | UCSF Benioff Children's Hospital Oakland | 53301.0 | 2022-12-02 | Alameda | 1 | Bay Area | 0.0 | 3.0 | 3.0 | 89.14285714285714 | 0.598274209012464 | 0.0336538461538461 |
1185 | 1185 | Washington Hospital | 050195 | 2022-12-02 | Alameda | 1 | Bay Area | 19.857142857142858 | 0.5714285714285714 | 20.42857142857143 | 187.0 | 0.8269109286165509 | 0.1092436974789916 |
1211 | 1211 | Alameda Hospital | 050211 | 2022-11-25 | Alameda | 1 | Bay Area | 1.8571428571428568 | 0.0 | 1.8571428571428568 | 52.285714285714285 | 0.5809523809523809 | 0.0355191256830601 |
1213 | 1213 | Alta Bates Summit Medical Center | 050043 | 2022-11-25 | Alameda | 1 | Bay Area | 10.142857142857142 | 0.0 | 10.142857142857142 | 204.7142857142857 | 0.6892736892736893 | 0.049546406140963 |
1214 | 1214 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305.0 | 2022-11-25 | Alameda | 1 | Bay Area | 12.285714285714286 | 0.0 | 12.285714285714286 | 151.0 | 0.371007371007371 | 0.0813623462630085 |
1261 | 1261 | Eden Medical Center | 50488.0 | 2022-11-25 | Alameda | 1 | Bay Area | 16.0 | 0.0 | 16.0 | 140.28571428571428 | 0.8606485539000875 | 0.1140529531568228 |
1287 | 1287 | Highland Hospital | 050320 | 2022-11-25 | Alameda | 1 | Bay Area | 10.571428571428571 | 0.0 | 10.571428571428571 | 177.85714285714286 | 0.4117063492063492 | 0.059437751004016 |
1302 | 1302 | Kaiser Foundation Hospital - Fremont | 050512 | 2022-11-25 | Alameda | 1 | Bay Area | 18.428571428571427 | 0.0 | 18.428571428571427 | 91.57142857142856 | 0.9330422125181952 | 0.2012480499219968 |
1305 | 1305 | Kaiser Foundation Hospital - Oakland/richmond | 50075.0 | 2022-11-25 | Alameda | 1 | Bay Area | 37.85714285714285 | 4.571428571428571 | 42.42857142857142 | 236.14285714285717 | 0.908741066520066 | 0.1796733212341197 |
1312 | 1312 | Kaiser Foundation Hospital - San Leandro | 50777.0 | 2022-11-25 | Alameda | 1 | Bay Area | 36.42857142857143 | 0.0 | 36.42857142857143 | 163.71428571428572 | 0.9182692307692308 | 0.2225130890052356 |
1334 | 1334 | Kindred Hospital - San Francisco Bay Area | 052034 | 2022-11-25 | Alameda | 1 | Bay Area | 0.0 | 0.0 | 0.0 | 58.42857142857143 | 0.5901875901875903 | 0.0 |
1476 | 1476 | St. Rose Hospital | 050002 | 2022-11-25 | Alameda | 1 | Bay Area | 1.4285714285714286 | 0.0 | 1.4285714285714286 | 46.42857142857143 | 0.5118110236220473 | 0.0307692307692307 |
1478 | 1478 | Stanford Health Care - Valleycare | 050283 | 2022-11-25 | Alameda | 1 | Bay Area | 8.428571428571429 | 0.0 | 8.428571428571429 | 124.71428571428572 | 0.4852695942190105 | 0.0675830469644902 |
1498 | 1498 | UCSF Benioff Children's Hospital Oakland | 053301 | 2022-11-25 | Alameda | 1 | Bay Area | 0.0 | 3.1666666666666665 | 3.1666666666666665 | 89.66666666666667 | 0.6017897091722595 | 0.0353159851301115 |
1512 | 1512 | Washington Hospital | 50195.0 | 2022-11-25 | Alameda | 1 | Bay Area | 13.857142857142858 | 0.0 | 13.857142857142858 | 182.7142857142857 | 0.823037323037323 | 0.0758405003909304 |
1538 | 1538 | Alameda Hospital | 50211.0 | 2022-11-18 | Alameda | 1 | Bay Area | 3.2857142857142856 | 0.0 | 3.2857142857142856 | 49.71428571428572 | 0.5523809523809524 | 0.0660919540229885 |
1540 | 1540 | Alta Bates Summit Medical Center | 50043.0 | 2022-11-18 | Alameda | 1 | Bay Area | 9.714285714285714 | 0.0 | 9.714285714285714 | 195.28571428571428 | 0.6575276575276575 | 0.049743964886613 |
1541 | 1541 | Alta Bates Summit Medical Center - Alta Bates Camp | 050305 | 2022-11-18 | Alameda | 1 | Bay Area | 7.428571428571429 | 0.0 | 7.428571428571429 | 147.85714285714286 | 0.3632853632853633 | 0.0502415458937198 |
1588 | 1588 | Eden Medical Center | 50488.0 | 2022-11-18 | Alameda | 1 | Bay Area | 9.571428571428571 | 0.0 | 9.571428571428571 | 132.85714285714286 | 0.8150744960560912 | 0.0720430107526881 |
1614 | 1614 | Highland Hospital | 50320.0 | 2022-11-18 | Alameda | 1 | Bay Area | 8.428571428571429 | 0.0 | 8.428571428571429 | 192.57142857142856 | 0.4457671957671958 | 0.0437685459940652 |
1629 | 1629 | Kaiser Foundation Hospital - Fremont | 50512.0 | 2022-11-18 | Alameda | 1 | Bay Area | 18.142857142857142 | 0.0 | 18.142857142857142 | 91.14285714285714 | 0.932748538011696 | 0.1990595611285266 |
1632 | 1632 | Kaiser Foundation Hospital - Oakland/richmond | 50075.0 | 2022-11-18 | Alameda | 1 | Bay Area | 31.142857142857142 | 3.857142857142857 | 35.0 | 243.7142857142857 | 0.9088971763452316 | 0.1436107854630715 |
1639 | 1639 | Kaiser Foundation Hospital - San Leandro | 050777 | 2022-11-18 | Alameda | 1 | Bay Area | 31.857142857142858 | 0.0 | 31.857142857142858 | 164.14285714285714 | 0.909018987341772 | 0.1940818102697998 |
1662 | 1662 | Kindred Hospital - San Francisco Bay Area | 052034 | 2022-11-18 | Alameda | 1 | Bay Area | 0.0 | 0.0 | 0.0 | 59.42857142857143 | 0.6002886002886003 | 0.0 |
1806 | 1806 | St. Rose Hospital | 050002 | 2022-11-18 | Alameda | 1 | Bay Area | 0.7142857142857143 | 0.0 | 0.7142857142857143 | 43.85714285714285 | 0.4834645669291338 | 0.01628664495114 |
1808 | 1808 | Stanford Health Care - Valleycare | 050283 | 2022-11-18 | Alameda | 1 | Bay Area | 4.166666666666667 | 0.0 | 4.166666666666667 | 110.83333333333331 | 0.4312581063553826 | 0.037593984962406 |
1828 | 1828 | UCSF Benioff Children's Hospital Oakland | 053301 | 2022-11-18 | Alameda | 1 | Bay Area | 0.0 | 0.8571428571428571 | 0.8571428571428571 | 94.28571428571428 | 0.6327900287631831 | 0.009090909090909 |
1839 | 1839 | Washington Hospital | 50195.0 | 2022-11-18 | Alameda | 1 | Bay Area | 12.428571428571429 | 0.0 | 12.428571428571429 | 172.57142857142858 | 0.7968337730870713 | 0.0720198675496688 |
1865 | 1865 | Alameda Hospital | 50211.0 | 2022-11-11 | Alameda | 1 | Bay Area | 2.142857142857143 | 0.0 | 2.142857142857143 | 40.142857142857146 | 0.446031746031746 | 0.0533807829181494 |
1867 | 1867 | Alta Bates Summit Medical Center | 050043 | 2022-11-11 | Alameda | 1 | Bay Area | 10.714285714285714 | 0.0 | 10.714285714285714 | 197.8571428571429 | 0.6661856661856662 | 0.0541516245487364 |
1868 | 1868 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305.0 | 2022-11-11 | Alameda | 1 | Bay Area | 9.571428571428571 | 0.0 | 9.571428571428571 | 153.57142857142858 | 0.3773253773253773 | 0.0623255813953488 |
1916 | 1916 | Eden Medical Center | 050488 | 2022-11-11 | Alameda | 1 | Bay Area | 7.857142857142857 | 0.0 | 7.857142857142857 | 136.14285714285714 | 0.8337707786526685 | 0.0577124868835257 |
1943 | 1943 | Highland Hospital | 50320.0 | 2022-11-11 | Alameda | 1 | Bay Area | 5.571428571428571 | 0.0 | 5.571428571428571 | 186.14285714285717 | 0.4308862433862434 | 0.0299309286262471 |
1958 | 1958 | Kaiser Foundation Hospital - Fremont | 050512 | 2022-11-11 | Alameda | 1 | Bay Area | 14.857142857142858 | 0.0 | 14.857142857142858 | 85.14285714285714 | 0.9085365853658536 | 0.174496644295302 |
1961 | 1961 | Kaiser Foundation Hospital - Oakland/richmond | 050075 | 2022-11-11 | Alameda | 1 | Bay Area | 29.428571428571427 | 3.7142857142857135 | 33.14285714285714 | 247.28571428571428 | 0.9086614173228346 | 0.1340265742345465 |
1968 | 1968 | Kaiser Foundation Hospital - San Leandro | 050777 | 2022-11-11 | Alameda | 1 | Bay Area | 31.142857142857142 | 0.0 | 31.142857142857142 | 168.42857142857142 | 0.9097222222222222 | 0.18490245971162 |
1990 | 1990 | Kindred Hospital - San Francisco Bay Area | 052034 | 2022-11-11 | Alameda | 1 | Bay Area | 0.0 | 0.0 | 0.0 | 58.85714285714285 | 0.5945165945165944 | 0.0 |
2134 | 2134 | St. Rose Hospital | 050002 | 2022-11-11 | Alameda | 1 | Bay Area | 0.0 | 0.0 | 0.0 | 53.57142857142857 | 0.5905511811023623 | 0.0 |
2136 | 2136 | Stanford Health Care - Valleycare | 050283 | 2022-11-11 | Alameda | 1 | Bay Area | 7.571428571428571 | 0.0 | 7.571428571428571 | 128.42857142857142 | 0.499722067815453 | 0.0589543937708565 |
2156 | 2156 | UCSF Benioff Children's Hospital Oakland | 53301.0 | 2022-11-11 | Alameda | 1 | Bay Area | 0.0 | 1.4285714285714286 | 1.4285714285714286 | 96.85714285714286 | 0.6500479386385427 | 0.0147492625368731 |
2170 | 2170 | Washington Hospital | 050195 | 2022-11-11 | Alameda | 1 | Bay Area | 8.714285714285714 | 0.0 | 8.714285714285714 | 187.8571428571429 | 0.8505821474773609 | 0.0463878326996197 |
2196 | 2196 | Alameda Hospital | 050211 | 2022-11-04 | Alameda | 1 | Bay Area | 3.0 | 0.0 | 3.0 | 38.142857142857146 | 0.4238095238095238 | 0.0786516853932584 |
2198 | 2198 | Alta Bates Summit Medical Center | 50043.0 | 2022-11-04 | Alameda | 1 | Bay Area | 9.285714285714286 | 0.0 | 9.285714285714286 | 198.57142857142856 | 0.6685906685906686 | 0.0467625899280575 |
2199 | 2199 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305.0 | 2022-11-04 | Alameda | 1 | Bay Area | 4.428571428571429 | 0.0 | 4.428571428571429 | 134.57142857142858 | 0.3306423306423307 | 0.0329087048832271 |
2247 | 2247 | Eden Medical Center | 050488 | 2022-11-04 | Alameda | 1 | Bay Area | 6.857142857142857 | 0.0 | 6.857142857142857 | 131.71428571428572 | 0.8045375218150087 | 0.0520607375271149 |
2274 | 2274 | Highland Hospital | 050320 | 2022-11-04 | Alameda | 1 | Bay Area | 3.571428571428572 | 0.0 | 3.571428571428572 | 162.57142857142858 | 0.3763227513227513 | 0.0219683655536028 |
2289 | 2289 | Kaiser Foundation Hospital - Fremont | 50512.0 | 2022-11-04 | Alameda | 1 | Bay Area | 13.0 | 0.0 | 13.0 | 69.42857142857143 | 0.9067164179104478 | 0.1872427983539094 |
2292 | 2292 | Kaiser Foundation Hospital - Oakland/richmond | 50075.0 | 2022-11-04 | Alameda | 1 | Bay Area | 22.142857142857142 | 3.2857142857142856 | 25.428571428571427 | 222.28571428571428 | 0.9099415204678364 | 0.1143958868894601 |
2299 | 2299 | Kaiser Foundation Hospital - San Leandro | 50777.0 | 2022-11-04 | Alameda | 1 | Bay Area | 25.857142857142858 | 0.0 | 25.857142857142858 | 171.42857142857142 | 0.9097801364670204 | 0.1508333333333333 |
2321 | 2321 | Kindred Hospital - San Francisco Bay Area | 052034 | 2022-11-04 | Alameda | 1 | Bay Area | 0.0 | 0.0 | 0.0 | 60.57142857142857 | 0.6118326118326118 | 0.0 |
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 );