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.
353 rows where "week" is on date 2020-12-25 sorted by region
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
35464 | 35464 | Adventist Health St. Helena | 050013 | 2020-12-25 | Napa | 55 | Bay Area | 5.857142857142857 | 0.0 | 5.857142857142857 | 42.0 | 0.8121546961325967 | 0.1394557823129251 |
35470 | 35470 | Ahmc Seton Medical Center | 50289.0 | 2020-12-25 | San Mateo | 81 | Bay Area | 28.285714285714285 | 0.0 | 28.285714285714285 | 79.42857142857143 | 0.9982046678635548 | 0.356115107913669 |
35471 | 35471 | Alameda Hospital | 50211.0 | 2020-12-25 | Alameda | 1 | Bay Area | 18.571428571428573 | 0.0 | 18.571428571428573 | 39.71428571428572 | 0.4412698412698412 | 0.4676258992805756 |
35473 | 35473 | Alta Bates Summit Medical Center | 50043.0 | 2020-12-25 | Alameda | 1 | Bay Area | 23.714285714285715 | 0.0 | 23.714285714285715 | 171.0 | 0.5777027027027027 | 0.1386800334168755 |
35474 | 35474 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305.0 | 2020-12-25 | Alameda | 1 | Bay Area | 26.0 | 0.0 | 26.0 | 128.57142857142858 | 0.3190358029067707 | 0.2022222222222222 |
35488 | 35488 | California Pacific Medical Center - Mission Bernal | 050055 | 2020-12-25 | San Francisco | 75 | Bay Area | 21.857142857142858 | 0.0 | 21.857142857142858 | 71.42857142857143 | 0.728862973760933 | 0.306 |
35489 | 35489 | California Pacific Medical Center- Van Ness Campus | 050047 | 2020-12-25 | San Francisco | 75 | Bay Area | 22.857142857142858 | 0.0 | 22.857142857142858 | 171.57142857142858 | 0.5700047460844804 | 0.1332223147377185 |
35490 | 35490 | California Pacific Medical Ctr-davies Campus Hosp | 50008.0 | 2020-12-25 | San Francisco | 75 | Bay Area | 0.0 | 0.0 | 0.0 | 57.57142857142857 | 0.6060150375939849 | 0.0 |
35501 | 35501 | Chinese Hospital | 050407 | 2020-12-25 | San Francisco | 75 | Bay Area | 5.714285714285714 | 0.0 | 5.714285714285714 | 41.71428571428572 | 0.453416149068323 | 0.136986301369863 |
35512 | 35512 | Community Hospital of the Monterey Peninsula | 50145.0 | 2020-12-25 | Monterey | 53 | Bay Area | 46.57142857142857 | 0.0 | 46.57142857142857 | 181.0 | 0.6284722222222222 | 0.2573007103393843 |
35515 | 35515 | Contra Costa Regional Medical Center | 050276 | 2020-12-25 | Contra Costa | 13 | Bay Area | 19.0 | 0.5714285714285714 | 19.571428571428573 | 113.57142857142856 | 0.6800684345594525 | 0.1723270440251572 |
35524 | 35524 | Dominican Hospital | 50242.0 | 2020-12-25 | Santa Cruz | 87 | Bay Area | 46.285714285714285 | 0.0 | 46.285714285714285 | 162.14285714285714 | 0.6405191873589164 | 0.2854625550660793 |
35527 | 35527 | Eden Medical Center | 050488 | 2020-12-25 | Alameda | 1 | Bay Area | 44.285714285714285 | 0.0 | 44.285714285714285 | 130.57142857142858 | 0.8704761904761905 | 0.3391684901531728 |
35529 | 35529 | El Camino Hospital | 050308 | 2020-12-25 | Santa Clara | 85 | Bay Area | 70.14285714285714 | 0.0 | 70.14285714285714 | 236.7142857142857 | 0.5283801020408163 | 0.296318648159324 |
35544 | 35544 | George L Mee Memorial Hospital | 051336 | 2020-12-25 | Monterey | 53 | Bay Area | 8.428571428571429 | 0.0 | 8.428571428571429 | 9.666666666666666 | 0.5686274509803921 | 0.8719211822660099 |
35550 | 35550 | Good Samaritan Hospital | 050380 | 2020-12-25 | Santa Clara | 85 | Bay Area | 59.0 | 0.0 | 59.0 | 253.28571428571428 | 0.5691813804173355 | 0.2329385222786238 |
35554 | 35554 | Healdsburg Hospital | 51321.0 | 2020-12-25 | Sonoma | 97 | Bay Area | 6.0 | 0.0 | 6.0 | 14.0 | 0.5 | 0.4285714285714285 |
35559 | 35559 | Highland Hospital | 50320.0 | 2020-12-25 | Alameda | 1 | Bay Area | 45.42857142857143 | 0.0 | 45.42857142857143 | 160.85714285714286 | 0.3723544973544974 | 0.2824156305506217 |
35568 | 35568 | John Muir Medical Center - Concord Campus | 050496 | 2020-12-25 | Contra Costa | 13 | Bay Area | 32.57142857142857 | 0.0 | 32.57142857142857 | 163.28571428571428 | 0.5831632653061224 | 0.1994750656167979 |
35569 | 35569 | John Muir Medical Center - Walnut Creek Campus | 050180 | 2020-12-25 | Contra Costa | 13 | Bay Area | 65.28571428571429 | 0.0 | 65.28571428571429 | 310.2857142857143 | 0.6768463695855407 | 0.2104051565377532 |
35571 | 35571 | Kaiser Foundation Hospital | 050510 | 2020-12-25 | Marin | 41 | Bay Area | 12.0 | 0.0 | 12.0 | 59.71428571428572 | 0.9106753812636166 | 0.200956937799043 |
35572 | 35572 | Kaiser Foundation Hospital - Antioch | 050760 | 2020-12-25 | Contra Costa | 13 | Bay Area | 36.71428571428572 | 0.0 | 36.71428571428572 | 116.14285714285714 | 0.9093959731543624 | 0.3161131611316113 |
35575 | 35575 | Kaiser Foundation Hospital - Fremont | 50512.0 | 2020-12-25 | Alameda | 1 | Bay Area | 37.57142857142857 | 0.0 | 37.57142857142857 | 85.57142857142857 | 0.9201228878648232 | 0.4390651085141903 |
35578 | 35578 | Kaiser Foundation Hospital - Oakland/richmond | 050075 | 2020-12-25 | Alameda | 1 | Bay Area | 75.14285714285714 | 1.8571428571428568 | 77.0 | 230.57142857142856 | 0.9149659863945578 | 0.3339529120198265 |
35581 | 35581 | Kaiser Foundation Hospital - Redwood City | 50541.0 | 2020-12-25 | San Mateo | 81 | Bay Area | 26.428571428571427 | 0.0 | 26.428571428571427 | 81.57142857142857 | 0.909235668789809 | 0.3239929947460595 |
35584 | 35584 | Kaiser Foundation Hospital - San Francisco | 50076.0 | 2020-12-25 | San Francisco | 75 | Bay Area | 30.285714285714285 | 0.0 | 30.285714285714285 | 158.85714285714286 | 0.9084967320261438 | 0.1906474820143884 |
35585 | 35585 | Kaiser Foundation Hospital - San Leandro | 50777.0 | 2020-12-25 | Alameda | 1 | Bay Area | 68.28571428571429 | 0.0 | 68.28571428571429 | 169.42857142857142 | 0.9102072141212586 | 0.4030354131534571 |
35587 | 35587 | Kaiser Foundation Hospital - South San Francisco | 50070.0 | 2020-12-25 | San Mateo | 81 | Bay Area | 43.285714285714285 | 0.0 | 43.285714285714285 | 84.57142857142857 | 0.9079754601226994 | 0.5118243243243243 |
35588 | 35588 | Kaiser Foundation Hospital - Vacaville | 050767 | 2020-12-25 | Solano | 95 | Bay Area | 36.85714285714285 | 0.0 | 36.85714285714285 | 103.85714285714286 | 0.9076154806491884 | 0.3548830811554332 |
35589 | 35589 | Kaiser Foundation Hospital - Walnut Creek | 050072 | 2020-12-25 | Contra Costa | 13 | Bay Area | 43.0 | 1.1428571428571428 | 44.142857142857146 | 177.71428571428572 | 0.9073668854850474 | 0.2483922829581993 |
35595 | 35595 | Kaiser Foundation Hospital and Rehab Center | 50073.0 | 2020-12-25 | Solano | 95 | Bay Area | 52.57142857142857 | 0.0 | 52.57142857142857 | 154.14285714285714 | 0.8976705490848585 | 0.3410565338276181 |
35598 | 35598 | Kaiser Foundation Hospital-san Jose | 50604.0 | 2020-12-25 | Santa Clara | 85 | Bay Area | 88.0 | 0.0 | 88.0 | 157.71428571428572 | 0.9093904448105438 | 0.5579710144927535 |
35599 | 35599 | Kaiser Foundation Hospital-santa Clara | 050071 | 2020-12-25 | Santa Clara | 85 | Bay Area | 77.85714285714286 | 2.4285714285714284 | 80.28571428571429 | 239.0 | 0.9082519001085776 | 0.3359234907352062 |
35600 | 35600 | Kaiser Foundation Hospital-santa Rosa | 050690 | 2020-12-25 | Sonoma | 97 | Bay Area | 26.571428571428573 | 0.0 | 26.571428571428573 | 116.57142857142856 | 0.9096989966555185 | 0.2279411764705882 |
35604 | 35604 | Kentfield Hospital | 52043.0 | 2020-12-25 | Marin | 41 | Bay Area | 0.0 | 0.0 | 0.0 | 49.71428571428572 | 0.7648351648351649 | 0.0 |
35609 | 35609 | Kindred Hospital - San Francisco Bay Area | 52034.0 | 2020-12-25 | Alameda | 1 | Bay Area | 0.0 | 0.0 | 0.0 | 73.42857142857143 | 0.7417027417027418 | 0.0 |
35625 | 35625 | Laguna Honda Hospital & Rehabilitation Center | 050668 | 2020-12-25 | San Francisco | 75 | Bay Area | 0.0 | 0.0 | 0.0 | 4.285714285714286 | 0.3896103896103896 | 0.0 |
35634 | 35634 | Lucile Salter Packard Children's Hsp at Stanford | 053305 | 2020-12-25 | Santa Clara | 85 | Bay Area | 0.5714285714285714 | 6.714285714285714 | 7.285714285714286 | 250.57142857142856 | 0.7348135735232509 | 0.0290763968072976 |
35640 | 35640 | Marinhealth Medical Center | 050360 | 2020-12-25 | Marin | 41 | Bay Area | 18.0 | 0.0 | 18.0 | 125.14285714285714 | 0.7233691164327002 | 0.1438356164383561 |
35661 | 35661 | Mills-peninsula Medical Center | 50007.0 | 2020-12-25 | San Mateo | 81 | Bay Area | 36.0 | 0.0 | 36.0 | 144.71428571428572 | 0.5587424158852731 | 0.2487660414610069 |
35668 | 35668 | Natividad Medical Center | 050248 | 2020-12-25 | Monterey | 53 | Bay Area | 59.0 | 0.0 | 59.0 | 148.28571428571428 | 0.8635607321131447 | 0.3978805394990366 |
35669 | 35669 | Northbay Medical Center | 50367.0 | 2020-12-25 | Solano | 95 | Bay Area | 46.42857142857143 | 0.0 | 46.42857142857143 | 190.28571428571428 | 0.9098360655737704 | 0.243993993993994 |
35672 | 35672 | Novato Community Hospital | 050131 | 2020-12-25 | Marin | 41 | Bay Area | 3.7142857142857135 | 0.0 | 3.7142857142857135 | 21.571428571428573 | 0.5531135531135531 | 0.1721854304635761 |
35686 | 35686 | Petaluma Valley Hospital | 50136.0 | 2020-12-25 | Sonoma | 97 | Bay Area | 4.142857142857143 | 0.0 | 4.142857142857143 | 25.0 | 0.4834254143646408 | 0.1657142857142857 |
35700 | 35700 | Providence Queen of the Valley Medical Center | 050009 | 2020-12-25 | Napa | 55 | Bay Area | 20.428571428571427 | 0.0 | 20.428571428571427 | 72.71428571428571 | 0.3635714285714285 | 0.280943025540275 |
35703 | 35703 | Providence Santa Rosa Memorial Hospital | 050174 | 2020-12-25 | Sonoma | 97 | Bay Area | 32.142857142857146 | 0.0 | 32.142857142857146 | 234.57142857142856 | 0.8481404958677687 | 0.1370280146163215 |
35709 | 35709 | Regional Medical Center of San Jose | 050125 | 2020-12-25 | Santa Clara | 85 | Bay Area | 105.28571428571428 | 0.0 | 105.28571428571428 | 236.14285714285717 | 0.8433673469387755 | 0.4458560193587417 |
35716 | 35716 | Saint Francis Memorial Hospital | 050152 | 2020-12-25 | San Francisco | 75 | Bay Area | 14.714285714285714 | 0.0 | 14.714285714285714 | 60.16666666666666 | 0.621342512908778 | 0.2445587653343886 |
35718 | 35718 | Salinas Valley Memorial Hospital | 50334.0 | 2020-12-25 | Monterey | 53 | Bay Area | 73.42857142857143 | 0.0 | 73.42857142857143 | 140.14285714285714 | 0.5561224489795918 | 0.5239551478083588 |
35724 | 35724 | San Mateo Medical Center | 50113.0 | 2020-12-25 | San Mateo | 81 | Bay Area | 15.142857142857142 | 0.0 | 15.142857142857142 | 37.85714285714285 | 0.728021978021978 | 0.4 |
35725 | 35725 | San Ramon Regional Medical Center | 050689 | 2020-12-25 | Contra Costa | 13 | Bay Area | 19.142857142857142 | 0.0 | 19.142857142857142 | 53.42857142857143 | 0.935 | 0.3582887700534759 |
35727 | 35727 | Santa Clara Valley Medical Center | 50038.0 | 2020-12-25 | Santa Clara | 85 | Bay Area | 76.0 | 2.7142857142857144 | 78.71428571428571 | 265.57142857142856 | 0.7992261392949269 | 0.2963959117805271 |
35737 | 35737 | Sequoia Hospital | 50197.0 | 2020-12-25 | San Mateo | 81 | Bay Area | 13.857142857142858 | 0.0 | 13.857142857142858 | 44.42857142857143 | 0.3641686182669789 | 0.3118971061093247 |
35746 | 35746 | Sonoma Specialty Hospital | 52057.0 | 2020-12-25 | Sonoma | 97 | Bay Area | 2.142857142857143 | 0.0 | 2.142857142857143 | 37.0 | 0.74 | 0.0579150579150579 |
35747 | 35747 | Sonoma Valley Hospital | 050090 | 2020-12-25 | Sonoma | 97 | Bay Area | 3.142857142857143 | 0.0 | 3.142857142857143 | 47.142857142857146 | 0.7990314769975787 | 0.0666666666666666 |
35758 | 35758 | St. Mary's Medical Center | 50457.0 | 2020-12-25 | San Francisco | 75 | Bay Area | 6.0 | 0.0 | 6.0 | 66.14285714285714 | 0.401213171577123 | 0.0907127429805615 |
35759 | 35759 | St. Rose Hospital | 050002 | 2020-12-25 | Alameda | 1 | Bay Area | 26.285714285714285 | 0.0 | 26.285714285714285 | 59.142857142857146 | 0.4786127167630058 | 0.4444444444444444 |
35760 | 35760 | Stanford Health Care | 50441.0 | 2020-12-25 | Santa Clara | 85 | Bay Area | 110.57142857142856 | 0.0 | 110.57142857142856 | 539.4285714285714 | 0.8521778379598285 | 0.204978813559322 |
35761 | 35761 | Stanford Health Care - Valleycare | 050283 | 2020-12-25 | Alameda | 1 | Bay Area | 34.714285714285715 | 0.0 | 34.714285714285715 | 100.57142857142856 | 0.3913285158421345 | 0.3451704545454546 |
35768 | 35768 | Sutter Delta Medical Center | 050523 | 2020-12-25 | Contra Costa | 13 | Bay Area | 34.857142857142854 | 0.0 | 34.857142857142854 | 90.0 | 0.6081081081081081 | 0.3873015873015872 |
35770 | 35770 | Sutter Maternity & Surgery Center of Santa Cruz | 50714.0 | 2020-12-25 | Santa Cruz | 87 | Bay Area | 0.0 | 0.0 | 0.0 | 8.285714285714286 | 0.2944162436548224 | 0.0 |
35773 | 35773 | Sutter Santa Rosa Regional Hospital | 050291 | 2020-12-25 | Sonoma | 97 | Bay Area | 14.0 | 0.0 | 14.0 | 76.57142857142857 | 0.8072289156626505 | 0.1828358208955224 |
35774 | 35774 | Sutter Solano Medical Center | 50101.0 | 2020-12-25 | Solano | 95 | Bay Area | 14.142857142857142 | 0.0 | 14.142857142857142 | 49.142857142857146 | 0.5014577259475219 | 0.2877906976744185 |
35784 | 35784 | UCSF Benioff Children's Hospital Oakland | 53301.0 | 2020-12-25 | Alameda | 1 | Bay Area | 0.0 | 1.1428571428571428 | 1.1428571428571428 | 59.57142857142857 | 0.3998082454458293 | 0.0191846522781774 |
35785 | 35785 | UCSF Medical Center | 050454 | 2020-12-25 | San Francisco | 75 | Bay Area | 59.71428571428572 | 1.1428571428571428 | 60.85714285714286 | 528.2857142857143 | 0.6969468526196759 | 0.1151974040021633 |
35798 | 35798 | Washington Hospital | 050195 | 2020-12-25 | Alameda | 1 | Bay Area | 65.0 | 0.0 | 65.0 | 198.28571428571428 | 0.862111801242236 | 0.3278097982708934 |
35799 | 35799 | Watsonville Community Hospital | 050194 | 2020-12-25 | Santa Cruz | 87 | Bay Area | 25.571428571428573 | 0.0 | 25.571428571428573 | 34.57142857142857 | 0.3601190476190476 | 0.7396694214876034 |
35806 | 35806 | Zuckerberg San Francisco General Hosp & Trauma Center | 050228 | 2020-12-25 | San Francisco | 75 | Bay Area | 32.0 | 0.0 | 32.0 | 210.0 | 0.9483870967741936 | 0.1523809523809524 |
35468 | 35468 | Adventist Health and Rideout | 050133 | 2020-12-25 | Yuba | 115 | Greater Sacramento | 75.28571428571429 | 0.0 | 75.28571428571429 | 212.57142857142856 | 0.7758081334723671 | 0.3541666666666667 |
35484 | 35484 | Barton Memorial Hospital | 050352 | 2020-12-25 | El Dorado | 17 | Greater Sacramento | 8.0 | 0.0 | 8.0 | 24.285714285714285 | 0.3074141048824593 | 0.3294117647058823 |
35509 | 35509 | Colusa Medical Center | 050783 | 2020-12-25 | Colusa | 11 | Greater Sacramento | 9.285714285714286 | 0.0 | 9.285714285714286 | 39.42857142857143 | 0.5508982035928144 | 0.2355072463768116 |
35526 | 35526 | Eastern Plumas Hospital - Portola Campus | 051300 | 2020-12-25 | Plumas | 63 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 1.2857142857142858 | 0.1428571428571428 | 0.0 |
35535 | 35535 | Enloe Medical Center | 50039.0 | 2020-12-25 | Butte | 7 | Greater Sacramento | 47.85714285714285 | 0.0 | 47.85714285714285 | 248.28571428571428 | 0.9623477297895904 | 0.1927502876869965 |
35570 | 35570 | Kaiser Foundation Hosp So Sacramento | 050674 | 2020-12-25 | Sacramento | 67 | Greater Sacramento | 105.14285714285714 | 0.0 | 105.14285714285714 | 238.0 | 0.9641203703703703 | 0.4417767106842737 |
35582 | 35582 | Kaiser Foundation Hospital - Roseville | 50772.0 | 2020-12-25 | Placer | 61 | Greater Sacramento | 109.14285714285714 | 3.2857142857142856 | 112.42857142857144 | 332.57142857142856 | 0.9822784810126582 | 0.3380584192439863 |
35583 | 35583 | Kaiser Foundation Hospital - Sacramento | 50425.0 | 2020-12-25 | Sacramento | 67 | Greater Sacramento | 72.57142857142857 | 0.0 | 72.57142857142857 | 178.57142857142858 | 0.9084302325581396 | 0.4064 |
35642 | 35642 | Marshall Medical Center | 050254 | 2020-12-25 | El Dorado | 17 | Greater Sacramento | 20.0 | 0.0 | 20.0 | 57.42857142857143 | 0.5173745173745173 | 0.3482587064676616 |
35653 | 35653 | Mercy General Hospital | 50017.0 | 2020-12-25 | Sacramento | 67 | Greater Sacramento | 36.142857142857146 | 0.0 | 36.142857142857146 | 185.0 | 0.592948717948718 | 0.1953667953667953 |
35655 | 35655 | Mercy Hospital of Folsom | 50414.0 | 2020-12-25 | Sacramento | 67 | Greater Sacramento | 30.428571428571427 | 0.0 | 30.428571428571427 | 79.85714285714286 | 0.7533692722371969 | 0.3810375670840786 |
35659 | 35659 | Mercy San Juan Medical Center | 50516.0 | 2020-12-25 | Sacramento | 67 | Greater Sacramento | 69.71428571428571 | 0.0 | 69.71428571428571 | 266.85714285714283 | 0.8305913739439751 | 0.2612419700214132 |
35660 | 35660 | Methodist Hospital of Sacramento | 050590 | 2020-12-25 | Sacramento | 67 | Greater Sacramento | 31.142857142857142 | 0.0 | 31.142857142857142 | 104.14285714285714 | 0.5055478502080444 | 0.299039780521262 |
35677 | 35677 | Orchard Hospital | 51311.0 | 2020-12-25 | Butte | 7 | Greater Sacramento | 3.2857142857142856 | 0.0 | 3.2857142857142856 | 10.428571428571429 | 0.316017316017316 | 0.3150684931506849 |
35678 | 35678 | Oroville Hospital | 50030.0 | 2020-12-25 | Butte | 7 | Greater Sacramento | 32.142857142857146 | 0.0 | 32.142857142857146 | 113.0 | 0.6569767441860465 | 0.2844500632111252 |
35692 | 35692 | Plumas District Hospital | 051326 | 2020-12-25 | Plumas | 63 | Greater Sacramento | 2.2857142857142856 | 0.0 | 2.2857142857142856 | 6.428571428571429 | 0.4017857142857143 | 0.3555555555555555 |
35736 | 35736 | Seneca District Hospital | 051327 | 2020-12-25 | Plumas | 63 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
35743 | 35743 | Shriners Hospitals For Children Northern Calif | 53311.0 | 2020-12-25 | Sacramento | 67 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 21.0 | 0.6774193548387096 | 0.0 |
35744 | 35744 | Sierra Nevada Memorial Hospital | 050150 | 2020-12-25 | Nevada | 57 | Greater Sacramento | 12.142857142857142 | 0.0 | 12.142857142857142 | 63.57142857142857 | 0.6079234972677595 | 0.1910112359550561 |
35764 | 35764 | Sutter Amador Hospital | 050014 | 2020-12-25 | Amador | 5 | Greater Sacramento | 9.285714285714286 | 0.0 | 9.285714285714286 | 36.142857142857146 | 0.6931506849315069 | 0.2569169960474308 |
35765 | 35765 | Sutter Auburn Faith Hospital | 050498 | 2020-12-25 | Placer | 61 | Greater Sacramento | 17.285714285714285 | 0.0 | 17.285714285714285 | 35.714285714285715 | 0.5580357142857143 | 0.4839999999999999 |
35767 | 35767 | Sutter Davis Hospital | 50537.0 | 2020-12-25 | Yolo | 113 | Greater Sacramento | 6.857142857142857 | 0.0 | 6.857142857142857 | 29.142857142857142 | 0.5204081632653061 | 0.2352941176470588 |
35771 | 35771 | Sutter Medical Center, Sacramento | 50108.0 | 2020-12-25 | Sacramento | 67 | Greater Sacramento | 66.42857142857143 | 1.0 | 67.42857142857143 | 322.0 | 0.5897435897435898 | 0.2094055013309671 |
35772 | 35772 | Sutter Roseville Medical Center | 50309.0 | 2020-12-25 | Placer | 61 | Greater Sacramento | 83.28571428571429 | 0.0 | 83.28571428571429 | 302.7142857142857 | 0.7842339008142117 | 0.2751297781972628 |
35775 | 35775 | Sutter Surgical Hospital - North Valley | 050766 | 2020-12-25 | Sutter | 101 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
35777 | 35777 | Tahoe Forest Hospital | 051328 | 2020-12-25 | Nevada | 57 | Greater Sacramento | 4.857142857142857 | 0.0 | 4.857142857142857 | 20.0 | 0.8 | 0.2428571428571428 |
35790 | 35790 | University of California Davis Medical Center | 050599 | 2020-12-25 | Sacramento | 67 | Greater Sacramento | 79.57142857142857 | 3.571428571428572 | 83.14285714285714 | 524.8571428571429 | 0.8891577928363988 | 0.1584104518236254 |
35796 | 35796 | Vibra Hospital of Sacramento | 052033 | 2020-12-25 | Sacramento | 67 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 49.71428571428572 | 0.8571428571428572 | 0.0 |
35805 | 35805 | Woodland Memorial Hospital | 050127 | 2020-12-25 | Yolo | 113 | Greater Sacramento | 25.428571428571427 | 0.0 | 25.428571428571427 | 56.285714285714285 | 0.4981036662452591 | 0.4517766497461928 |
35455 | 35455 | Adventist Health Clearlake | 51317.0 | 2020-12-25 | Lake | 33 | Northern California | 2.0 | 0.0 | 2.0 | 17.857142857142858 | 0.4826254826254826 | 0.112 |
35458 | 35458 | Adventist Health Howard Memorial | 051310 | 2020-12-25 | Mendocino | 45 | Northern California | 1.1428571428571428 | 0.0 | 1.1428571428571428 | 18.857142857142858 | 0.7457627118644068 | 0.0606060606060606 |
35460 | 35460 | Adventist Health Mendocino Coast | 51325.0 | 2020-12-25 | Mendocino | 45 | Northern California | 0.0 | 0.0 | 0.0 | 11.714285714285714 | 0.6119402985074627 | 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 );