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 patients_with_covid_percent
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
35461 | 35461 | Adventist Health Reedley | 50192.0 | 2020-12-25 | Fresno | 19 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 20.714285714285715 | 0.8479532163742691 | 0.0 |
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 |
35492 | 35492 | Catalina Island Medical Center | 51307.0 | 2020-12-25 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 0.0 | 5.0 | 0.4166666666666667 | 0.0 |
35499 | 35499 | Children's Hospital at Mission | 53306.0 | 2020-12-25 | Orange | 59 | Southern California | 0.0 | 0.0 | 0.0 | 13.285714285714286 | 0.2330827067669173 | 0.0 |
35520 | 35520 | Docs Surgical Hospital | 050785 | 2020-12-25 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 0.0 | 1.5714285714285714 | 0.2244897959183673 | 0.0 |
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 |
35541 | 35541 | Fresno Surgical Hospital | 50708.0 | 2020-12-25 | Fresno | 19 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 8.142857142857142 | 0.6477272727272727 | 0.0 |
35548 | 35548 | Goleta Valley Cottage Hospital | 050357 | 2020-12-25 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.0 | 9.285714285714286 | 0.4642857142857143 | 0.0 |
35555 | 35555 | Healthbridge Children's Hospital - Orange | 053308 | 2020-12-25 | Orange | 59 | Southern California | 0.0 | 0.0 | 0.0 | 25.0 | 0.925925925925926 | 0.0 |
35561 | 35561 | Hoag Orthopedic Institute | 050769 | 2020-12-25 | Orange | 59 | Southern California | 0.0 | 0.0 | 0.0 | 16.0 | 0.4571428571428571 | 0.0 |
35565 | 35565 | Jerold Phelps Community Hospital | 051309 | 2020-12-25 | Humboldt | 23 | Northern California | 0.0 | 0.0 | 0.0 | 4.714285714285714 | 0.5892857142857143 | 0.0 |
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 |
35607 | 35607 | Kindred Hospital - Los Angeles | 52032.0 | 2020-12-25 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 0.0 | 75.71428571428571 | 0.8803986710963454 | 0.0 |
35608 | 35608 | Kindred Hospital - San Diego | 052036 | 2020-12-25 | San Diego | 73 | Southern California | 0.0 | 0.0 | 0.0 | 56.71428571428572 | 0.8102040816326531 | 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 |
35612 | 35612 | Kindred Hospital Brea | 052039 | 2020-12-25 | Orange | 59 | Southern California | 0.0 | 0.0 | 0.0 | 40.142857142857146 | 0.8363095238095238 | 0.0 |
35613 | 35613 | Kindred Hospital Ontario | 52037.0 | 2020-12-25 | San Bernardino | 71 | Southern California | 0.0 | 0.0 | 0.0 | 71.0 | 0.7802197802197802 | 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 |
35637 | 35637 | Mammoth Hospital | 051303 | 2020-12-25 | Mono | 51 | Southern California | 0.0 | 0.0 | 0.0 | 7.428571428571429 | 0.4369747899159664 | 0.0 |
35639 | 35639 | Marian Regional Medical Center, Arroyo Grande | 050016 | 2020-12-25 | San Luis Obispo | 79 | Southern California | 0.0 | 0.0 | 0.0 | 16.571428571428573 | 0.1972789115646258 | 0.0 |
35674 | 35674 | Ojai Valley Community Hospital | 051334 | 2020-12-25 | Ventura | 111 | Southern California | 0.0 | 0.0 | 0.0 | 11.285714285714286 | 0.5939849624060151 | 0.0 |
35681 | 35681 | Palo Verde Hospital | 050423 | 2020-12-25 | Riverside | 65 | Southern California | 0.0 | 0.0 | 0.0 | 3.142857142857143 | 0.1083743842364532 | 0.0 |
35685 | 35685 | Patients' Hospital of Redding | 50697.0 | 2020-12-25 | Shasta | 89 | Northern California | 0.0 | 0.0 | 0.0 | 1.1428571428571428 | 0.1142857142857142 | 0.0 |
35701 | 35701 | Providence Redwood Memorial Hospital | 051318 | 2020-12-25 | Humboldt | 23 | Northern California | 0.0 | 0.0 | 0.0 | 15.714285714285714 | 0.3741496598639455 | 0.0 |
35730 | 35730 | Santa Ynez Valley Cottage Hospital | 051331 | 2020-12-25 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.0 | 2.857142857142857 | 0.2597402597402597 | 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 |
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 |
35783 | 35783 | Trinity Hospital | 051315 | 2020-12-25 | Trinity | 105 | Northern California | 0.0 | 0.0 | 0.0 | 8.571428571428571 | 0.3428571428571428 | 0.0 |
35787 | 35787 | USC Kenneth Norris Jr Cancer Hospital | 50660.0 | 2020-12-25 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 0.0 | 28.285714285714285 | 0.4714285714285714 | 0.0 |
35795 | 35795 | Vibra Hospital of Northern California | 052047 | 2020-12-25 | Shasta | 89 | Northern California | 0.0 | 0.0 | 0.0 | 38.142857142857146 | 0.8870431893687708 | 0.0 |
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 |
35801 | 35801 | West Covina Medical Center, Inc | 50096.0 | 2020-12-25 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 0.0 | 1.5714285714285714 | 0.1208791208791208 | 0.0 |
35735 | 35735 | Select Specialty Hospital - San Diego | 52044.0 | 2020-12-25 | San Diego | 73 | Southern California | 0.5714285714285714 | 0.0 | 0.5714285714285714 | 86.28571428571429 | 0.9014925373134328 | 0.0066225165562913 |
35618 | 35618 | Kindred Hospital Westminster | 052035 | 2020-12-25 | Orange | 59 | Southern California | 1.7142857142857142 | 0.0 | 1.7142857142857142 | 92.28571428571428 | 0.8466579292267367 | 0.0185758513931888 |
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 |
35540 | 35540 | Fresno Heart and Surgical Hospital | 50732.0 | 2020-12-25 | Fresno | 19 | San Joaquin Valley | 0.7142857142857143 | 0.0 | 0.7142857142857143 | 35.285714285714285 | 0.6190476190476191 | 0.020242914979757 |
35491 | 35491 | Casa Colina Hospital | 50782.0 | 2020-12-25 | Los Angeles | 37 | Southern California | 1.8571428571428568 | 0.0 | 1.8571428571428568 | 81.14285714285714 | 0.8196248196248196 | 0.0228873239436619 |
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 |
35506 | 35506 | College Hospital Costa Mesa | 050543 | 2020-12-25 | Orange | 59 | Southern California | 3.7142857142857135 | 0.0 | 3.7142857142857135 | 108.0 | 0.7769784172661871 | 0.0343915343915343 |
35611 | 35611 | Kindred Hospital Baldwin Park | 52045.0 | 2020-12-25 | Los Angeles | 37 | Southern California | 3.0 | 0.0 | 3.0 | 86.0 | 0.945054945054945 | 0.0348837209302325 |
35704 | 35704 | Providence St. Joseph Hospital | 050006 | 2020-12-25 | Humboldt | 23 | Northern California | 5.0 | 0.0 | 5.0 | 117.71428571428572 | 0.6467817896389325 | 0.0424757281553398 |
35792 | 35792 | Valley Children's Hospital | 53300.0 | 2020-12-25 | Fresno | 19 | San Joaquin Valley | 0.0 | 7.714285714285714 | 7.714285714285714 | 170.14285714285714 | 0.8179945054945055 | 0.0453400503778337 |
35707 | 35707 | Rady Children's Hospital - San Diego | 053303 | 2020-12-25 | San Diego | 73 | Southern California | 0.0 | 12.714285714285714 | 12.714285714285714 | 221.57142857142856 | 0.4848390121913098 | 0.0573823339780786 |
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 |
35558 | 35558 | Hi-desert Medical Center | 50279.0 | 2020-12-25 | San Bernardino | 71 | Southern California | 7.285714285714286 | 0.0 | 7.285714285714286 | 120.42857142857144 | 0.9623287671232876 | 0.0604982206405693 |
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 |
35503 | 35503 | City of Hope Helford Clinical Research Hospital | 50146.0 | 2020-12-25 | Los Angeles | 37 | Southern California | 11.285714285714286 | 0.0 | 11.285714285714286 | 177.85714285714286 | 0.9284116331096196 | 0.0634538152610441 |
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 |
35496 | 35496 | Central Valley Specialty Hospital | 52055.0 | 2020-12-25 | Stanislaus | 99 | San Joaquin Valley | 6.2 | 0.0 | 6.2 | 90.0 | 0.75 | 0.0688888888888888 |
35614 | 35614 | Kindred Hospital Paramount | 052046 | 2020-12-25 | Los Angeles | 37 | Southern California | 6.142857142857143 | 0.0 | 6.142857142857143 | 89.0 | 0.89 | 0.0690208667736757 |
35664 | 35664 | Monrovia Memorial Hospital | 052054 | 2020-12-25 | Los Angeles | 37 | Southern California | 1.4285714285714286 | 0.0 | 1.4285714285714286 | 20.5 | 0.4183673469387755 | 0.0696864111498257 |
35615 | 35615 | Kindred Hospital Rancho | 052049 | 2020-12-25 | San Bernardino | 71 | Southern California | 4.0 | 0.0 | 4.0 | 54.0 | 0.9818181818181818 | 0.074074074074074 |
35566 | 35566 | John C Fremont Healthcare District | 051304 | 2020-12-25 | Mariposa | 43 | San Joaquin Valley | 0.8571428571428571 | 0.0 | 0.8571428571428571 | 9.571428571428571 | 0.5 | 0.0895522388059701 |
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 |
35498 | 35498 | Children's Hosp of Los Angeles | 053302 | 2020-12-25 | Los Angeles | 37 | Southern California | 0.0 | 23.857142857142858 | 23.857142857142858 | 262.85714285714283 | 0.6705539358600583 | 0.0907608695652174 |
35741 | 35741 | Shasta Regional Medical Center | 050764 | 2020-12-25 | Shasta | 89 | Northern California | 8.857142857142858 | 0.0 | 8.857142857142858 | 90.42857142857144 | 0.8428761651131824 | 0.0979462875197472 |
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 |
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 |
35610 | 35610 | Kindred Hospital -- La Mirada | 52038.0 | 2020-12-25 | Los Angeles | 37 | Southern California | 17.142857142857142 | 0.0 | 17.142857142857142 | 148.42857142857142 | 0.753444525018129 | 0.1154956689124157 |
35627 | 35627 | Loma Linda University Children's Hospital | 50778.0 | 2020-12-25 | San Bernardino | 71 | Southern California | 8.142857142857142 | 15.571428571428571 | 23.714285714285715 | 202.14285714285717 | 0.5568673750491933 | 0.1173144876325088 |
35616 | 35616 | Kindred Hospital Riverside | 52052.0 | 2020-12-25 | Riverside | 65 | Southern California | 5.0 | 0.0 | 5.0 | 39.285714285714285 | 0.9821428571428572 | 0.1272727272727273 |
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 |
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 |
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 |
35766 | 35766 | Sutter Coast Hospital | 050417 | 2020-12-25 | Del Norte | 15 | Northern California | 3.142857142857143 | 0.0 | 3.142857142857143 | 22.857142857142858 | 0.4481792717086835 | 0.1374999999999999 |
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 |
35500 | 35500 | Children's Hospital of Orange County | 053304 | 2020-12-25 | Orange | 59 | Southern California | 0.0 | 20.857142857142858 | 20.857142857142858 | 149.57142857142858 | 0.4478186484174508 | 0.1394460362941738 |
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 |
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 |
35663 | 35663 | Modoc Medical Center | 051330 | 2020-12-25 | Modoc | 49 | Northern California | 1.0 | 0.0 | 1.0 | 6.571428571428571 | 0.8214285714285714 | 0.1521739130434782 |
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 |
35645 | 35645 | Memorial Care Miller Children's & Women's Hosp Lb | 053309 | 2020-12-25 | Los Angeles | 37 | Southern California | 11.142857142857142 | 6.0 | 17.142857142857142 | 112.14285714285714 | 0.4329840044125758 | 0.1528662420382165 |
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 |
35658 | 35658 | Mercy Medical Center Redding | 50280.0 | 2020-12-25 | Shasta | 89 | Northern California | 31.428571428571427 | 0.0 | 31.428571428571427 | 195.8571428571429 | 0.5568643379366369 | 0.1604668125455871 |
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 |
35623 | 35623 | LAC/Rancho Los Amigos National Rehabilitation Center | 50717.0 | 2020-12-25 | Los Angeles | 37 | Southern California | 23.428571428571427 | 0.0 | 23.428571428571427 | 137.14285714285714 | 0.8664259927797834 | 0.1708333333333333 |
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 |
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 |
35536 | 35536 | Fairchild Medical Center | 051316 | 2020-12-25 | Siskiyou | 93 | Northern California | 3.2857142857142856 | 0.0 | 3.2857142857142856 | 18.0 | 0.72 | 0.1825396825396825 |
35605 | 35605 | Kern Medical Center | 050315 | 2020-12-25 | Kern | 29 | San Joaquin Valley | 26.428571428571427 | 0.0 | 26.428571428571427 | 144.71428571428572 | 0.6957417582417583 | 0.1826258637709772 |
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 |
35463 | 35463 | Adventist Health Sonora | 050335 | 2020-12-25 | Tuolumne | 109 | San Joaquin Valley | 8.428571428571429 | 0.0 | 8.428571428571429 | 45.0 | 0.5357142857142857 | 0.1873015873015873 |
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 |
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 |
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 |
35635 | 35635 | Mad River Community Hospital | 50028.0 | 2020-12-25 | Humboldt | 23 | Northern California | 3.857142857142857 | 0.0 | 3.857142857142857 | 19.857142857142858 | 0.4843205574912892 | 0.1942446043165467 |
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 |
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 |
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 |
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 |
35657 | 35657 | Mercy Medical Center Mt Shasta | 051319 | 2020-12-25 | Siskiyou | 93 | Northern California | 1.5714285714285714 | 0.0 | 1.5714285714285714 | 7.666666666666667 | 0.2473118279569892 | 0.2049689440993788 |
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 |
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 |
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 |
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 |
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 |
35789 | 35789 | Uc San Diego Health Hillcrest - Hillcrest Medical Center | 50025.0 | 2020-12-25 | San Diego | 73 | Southern California | 123.14285714285714 | 0.0 | 123.14285714285714 | 523.5714285714286 | 0.6262816131237183 | 0.2351978171896316 |
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 |
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 |
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 );