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-10-30 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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38277 | 38277 | Adventist Health Clearlake | 051317 | 2020-10-30 | Lake | 33 | Northern California | 0.0 | 0.0 | 0.0 | 18.142857142857142 | 0.6791443850267379 | 0.0 |
38280 | 38280 | Adventist Health Howard Memorial | 51310.0 | 2020-10-30 | Mendocino | 45 | Northern California | 0.0 | 0.0 | 0.0 | 22.428571428571427 | 0.7849999999999999 | 0.0 |
38282 | 38282 | Adventist Health Mendocino Coast | 051325 | 2020-10-30 | Mendocino | 45 | Northern California | 0.0 | 0.0 | 0.0 | 14.714285714285714 | 0.5885714285714285 | 0.0 |
38283 | 38283 | Adventist Health Reedley | 050192 | 2020-10-30 | Fresno | 19 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 23.285714285714285 | 0.4752186588921283 | 0.0 |
38287 | 38287 | Adventist Health Tehachapi Valley | 051301 | 2020-10-30 | Kern | 29 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 10.571428571428571 | 0.3957219251336898 | 0.0 |
38288 | 38288 | Adventist Health Tulare | 050784 | 2020-10-30 | Tulare | 107 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 23.428571428571427 | 0.2892416225749559 | 0.0 |
38303 | 38303 | Banner Lassen Medical Center | 51320.0 | 2020-10-30 | Lassen | 35 | Northern California | 0.0 | 0.0 | 0.0 | 6.0 | 0.1875 | 0.0 |
38304 | 38304 | Barlow Respiratory Hospital | 052031 | 2020-10-30 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 0.0 | 67.14285714285714 | 0.8392857142857142 | 0.0 |
38307 | 38307 | Bear Valley Community Hospital | 51335.0 | 2020-10-30 | San Bernardino | 71 | Southern California | 0.0 | 0.0 | 0.0 | 2.571428571428572 | 0.1285714285714286 | 0.0 |
38312 | 38312 | California Pacific Medical Ctr-davies Campus Hosp | 050008 | 2020-10-30 | San Francisco | 75 | Bay Area | 0.0 | 0.0 | 0.0 | 67.0 | 0.7052631578947368 | 0.0 |
38314 | 38314 | Catalina Island Medical Center | 51307.0 | 2020-10-30 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 0.0 | 5.0 | 0.3977272727272727 | 0.0 |
38321 | 38321 | Children's Hospital at Mission | 053306 | 2020-10-30 | Orange | 59 | Southern California | 0.0 | 0.0 | 0.0 | 22.714285714285715 | 0.3785714285714286 | 0.0 |
38323 | 38323 | Chinese Hospital | 50407.0 | 2020-10-30 | San Francisco | 75 | Bay Area | 0.0 | 0.0 | 0.0 | 34.333333333333336 | 0.3731884057971015 | 0.0 |
38328 | 38328 | College Hospital Costa Mesa | 050543 | 2020-10-30 | Orange | 59 | Southern California | 0.0 | 0.0 | 0.0 | 118.14285714285714 | 0.8499486125385406 | 0.0 |
38330 | 38330 | Colorado River Medical Center | 051323 | 2020-10-30 | San Bernardino | 71 | Southern California | 0.0 | 0.0 | 0.0 | 3.142857142857143 | 0.1257142857142857 | 0.0 |
38342 | 38342 | Docs Surgical Hospital | 050785 | 2020-10-30 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 0.0 | 1.8571428571428568 | 0.2653061224489796 | 0.0 |
38348 | 38348 | Eastern Plumas Hospital - Portola Campus | 051300 | 2020-10-30 | Plumas | 63 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 2.857142857142857 | 0.3174603174603174 | 0.0 |
38362 | 38362 | Fresno Heart and Surgical Hospital | 050732 | 2020-10-30 | Fresno | 19 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 41.85714285714285 | 0.7343358395989974 | 0.0 |
38363 | 38363 | Fresno Surgical Hospital | 50708.0 | 2020-10-30 | Fresno | 19 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 9.285714285714286 | 0.2995391705069125 | 0.0 |
38366 | 38366 | George L Mee Memorial Hospital | 051336 | 2020-10-30 | Monterey | 53 | Bay Area | 0.0 | 0.0 | 0.0 | 5.428571428571429 | 0.319327731092437 | 0.0 |
38369 | 38369 | Glenn Medical Center | 51306.0 | 2020-10-30 | Glenn | 21 | Northern California | 0.0 | 0.0 | 0.0 | 23.0 | 0.4893617021276595 | 0.0 |
38370 | 38370 | Goleta Valley Cottage Hospital | 050357 | 2020-10-30 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.0 | 12.285714285714286 | 0.4387755102040817 | 0.0 |
38377 | 38377 | Healthbridge Children's Hospital - Orange | 053308 | 2020-10-30 | Orange | 59 | Southern California | 0.0 | 0.0 | 0.0 | 22.142857142857142 | 0.8201058201058201 | 0.0 |
38383 | 38383 | Hoag Orthopedic Institute | 050769 | 2020-10-30 | Orange | 59 | Southern California | 0.0 | 0.0 | 0.0 | 14.142857142857142 | 0.4040816326530612 | 0.0 |
38387 | 38387 | Jerold Phelps Community Hospital | 51309.0 | 2020-10-30 | Humboldt | 23 | Northern California | 0.0 | 0.0 | 0.0 | 3.4285714285714284 | 0.4285714285714285 | 0.0 |
38388 | 38388 | John C Fremont Healthcare District | 051304 | 2020-10-30 | Mariposa | 43 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 5.142857142857143 | 0.2706766917293233 | 0.0 |
38426 | 38426 | Kentfield Hospital | 52043.0 | 2020-10-30 | Marin | 41 | Bay Area | 0.0 | 0.0 | 0.0 | 46.142857142857146 | 0.7690476190476191 | 0.0 |
38428 | 38428 | Kern Valley Healthcare District | 051314 | 2020-10-30 | Kern | 29 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 7.571428571428571 | 0.7571428571428571 | 0.0 |
38429 | 38429 | Kindred Hospital - Los Angeles | 52032.0 | 2020-10-30 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 0.0 | 73.42857142857143 | 0.8538205980066446 | 0.0 |
38431 | 38431 | Kindred Hospital - San Francisco Bay Area | 52034.0 | 2020-10-30 | Alameda | 1 | Bay Area | 0.0 | 0.0 | 0.0 | 66.28571428571429 | 0.6081258191349935 | 0.0 |
38434 | 38434 | Kindred Hospital Brea | 52039.0 | 2020-10-30 | Orange | 59 | Southern California | 0.0 | 0.0 | 0.0 | 36.285714285714285 | 0.7559523809523809 | 0.0 |
38435 | 38435 | Kindred Hospital Ontario | 052037 | 2020-10-30 | San Bernardino | 71 | Southern California | 0.0 | 0.0 | 0.0 | 70.57142857142857 | 0.6851595006934813 | 0.0 |
38436 | 38436 | Kindred Hospital Paramount | 52046.0 | 2020-10-30 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 0.0 | 94.71428571428572 | 0.4305194805194804 | 0.0 |
38437 | 38437 | Kindred Hospital Rancho | 52049.0 | 2020-10-30 | San Bernardino | 71 | Southern California | 0.0 | 0.0 | 0.0 | 51.0 | 0.9272727272727272 | 0.0 |
38438 | 38438 | Kindred Hospital Riverside | 052052 | 2020-10-30 | Riverside | 65 | Southern California | 0.0 | 0.0 | 0.0 | 32.0 | 0.8 | 0.0 |
38440 | 38440 | Kindred Hospital Westminster | 52035.0 | 2020-10-30 | Orange | 59 | Southern California | 0.0 | 0.0 | 0.0 | 74.57142857142857 | 0.6841415465268676 | 0.0 |
38447 | 38447 | Laguna Honda Hospital & Rehabilitation Center | 50668.0 | 2020-10-30 | San Francisco | 75 | Bay Area | 0.0 | 0.0 | 0.0 | 2.333333333333333 | 0.2121212121212121 | 0.0 |
38457 | 38457 | Mad River Community Hospital | 050028 | 2020-10-30 | Humboldt | 23 | Northern California | 0.0 | 0.0 | 0.0 | 17.571428571428573 | 0.5278969957081545 | 0.0 |
38459 | 38459 | Mammoth Hospital | 051303 | 2020-10-30 | Mono | 51 | Southern California | 0.0 | 0.0 | 0.0 | 7.142857142857143 | 0.4201680672268907 | 0.0 |
38461 | 38461 | Marian Regional Medical Center, Arroyo Grande | 050016 | 2020-10-30 | San Luis Obispo | 79 | Southern California | 0.0 | 0.0 | 0.0 | 23.428571428571427 | 0.2789115646258503 | 0.0 |
38463 | 38463 | Mark Twain Medical Center | 51332.0 | 2020-10-30 | Calaveras | 9 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 7.714285714285714 | 0.1542857142857142 | 0.0 |
38466 | 38466 | Mayers Memorial Hospital | 51305.0 | 2020-10-30 | Shasta | 89 | Northern California | 0.0 | 0.0 | 0.0 | 7.714285714285714 | 0.4821428571428571 | 0.0 |
38479 | 38479 | Mercy Medical Center Mt Shasta | 51319.0 | 2020-10-30 | Siskiyou | 93 | Northern California | 0.0 | 0.0 | 0.0 | 9.285714285714286 | 0.2995391705069125 | 0.0 |
38486 | 38486 | Monrovia Memorial Hospital | 52054.0 | 2020-10-30 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 0.0 | 11.0 | 0.2244897959183673 | 0.0 |
38489 | 38489 | Mountains Community Hospital | 051312 | 2020-10-30 | San Bernardino | 71 | Southern California | 0.0 | 0.0 | 0.0 | 2.142857142857143 | 0.1339285714285714 | 0.0 |
38492 | 38492 | Northern Inyo Hospital | 051324 | 2020-10-30 | Inyo | 27 | Southern California | 0.0 | 0.0 | 0.0 | 7.142857142857143 | 0.2857142857142857 | 0.0 |
38495 | 38495 | Oak Valley Hospital District | 050067 | 2020-10-30 | Stanislaus | 99 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 7.857142857142857 | 0.3741496598639455 | 0.0 |
38496 | 38496 | Ojai Valley Community Hospital | 51334.0 | 2020-10-30 | Ventura | 111 | Southern California | 0.0 | 0.0 | 0.0 | 8.571428571428571 | 0.5357142857142857 | 0.0 |
38499 | 38499 | Orchard Hospital | 51311.0 | 2020-10-30 | Butte | 7 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 7.285714285714286 | 0.2833333333333333 | 0.0 |
38500 | 38500 | Oroville Hospital | 50030.0 | 2020-10-30 | Butte | 7 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 120.85714285714286 | 0.7026578073089701 | 0.0 |
38503 | 38503 | Palo Verde Hospital | 50423.0 | 2020-10-30 | Riverside | 65 | Southern California | 0.0 | 0.0 | 0.0 | 3.4285714285714284 | 0.0781758957654723 | 0.0 |
38507 | 38507 | Patients' Hospital of Redding | 50697.0 | 2020-10-30 | Shasta | 89 | Northern California | 0.0 | 0.0 | 0.0 | 4.0 | 0.4 | 0.0 |
38514 | 38514 | Plumas District Hospital | 051326 | 2020-10-30 | Plumas | 63 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 4.0 | 0.25 | 0.0 |
38519 | 38519 | Providence Little Company of Mary Medical Center San Pedro | 050078 | 2020-10-30 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 0.0 | 64.28571428571429 | 0.6987577639751553 | 0.0 |
38523 | 38523 | Providence Redwood Memorial Hospital | 051318 | 2020-10-30 | Humboldt | 23 | Northern California | 0.0 | 0.0 | 0.0 | 17.142857142857142 | 0.4081632653061224 | 0.0 |
38538 | 38538 | Saint Francis Memorial Hospital | 050152 | 2020-10-30 | San Francisco | 75 | Bay Area | 0.0 | 0.0 | 0.0 | 57.57142857142857 | 0.3198412698412698 | 0.0 |
38563 | 38563 | Shasta Regional Medical Center | 050764 | 2020-10-30 | Shasta | 89 | Northern California | 0.0 | 0.0 | 0.0 | 95.14285714285714 | 0.8763157894736842 | 0.0 |
38565 | 38565 | Shriners Hospitals For Children Northern Calif | 53311.0 | 2020-10-30 | Sacramento | 67 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 17.428571428571427 | 0.5622119815668202 | 0.0 |
38584 | 38584 | Stanislaus Surgical Hospital | 050726 | 2020-10-30 | Stanislaus | 99 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 2.2857142857142856 | 0.0993788819875776 | 0.0 |
38588 | 38588 | Sutter Coast Hospital | 50417.0 | 2020-10-30 | Del Norte | 15 | Northern California | 0.0 | 0.0 | 0.0 | 20.714285714285715 | 0.403899721448468 | 0.0 |
38592 | 38592 | Sutter Maternity & Surgery Center of Santa Cruz | 50714.0 | 2020-10-30 | Santa Cruz | 87 | Bay Area | 0.0 | 0.0 | 0.0 | 9.571428571428571 | 0.3418367346938775 | 0.0 |
38605 | 38605 | Trinity Hospital | 051315 | 2020-10-30 | Trinity | 105 | Northern California | 0.0 | 0.0 | 0.0 | 7.857142857142857 | 0.3142857142857143 | 0.0 |
38606 | 38606 | UCSF Benioff Children's Hospital Oakland | 53301.0 | 2020-10-30 | Alameda | 1 | Bay Area | 0.0 | 0.0 | 0.0 | 72.71428571428571 | 0.4880153403643336 | 0.0 |
38617 | 38617 | Vibra Hospital of Northern California | 052047 | 2020-10-30 | Shasta | 89 | Northern California | 0.0 | 0.0 | 0.0 | 36.285714285714285 | 0.8438538205980066 | 0.0 |
38618 | 38618 | Vibra Hospital of Sacramento | 052033 | 2020-10-30 | Sacramento | 67 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 49.57142857142857 | 0.854679802955665 | 0.0 |
38623 | 38623 | West Covina Medical Center, Inc | 050096 | 2020-10-30 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 0.0 | 4.428571428571429 | 0.3406593406593406 | 0.0 |
38467 | 38467 | Memorial Care Miller Children's & Women's Hosp Lb | 053309 | 2020-10-30 | Los Angeles | 37 | Southern California | 0.8571428571428571 | 0.0 | 0.8571428571428571 | 149.71428571428572 | 0.5714285714285715 | 0.0057251908396946 |
38529 | 38529 | Rady Children's Hospital - San Diego | 53303.0 | 2020-10-30 | San Diego | 73 | Southern California | 0.0 | 1.5714285714285714 | 1.5714285714285714 | 232.14285714285717 | 0.4371805219262846 | 0.0067692307692307 |
38432 | 38432 | Kindred Hospital -- La Mirada | 52038.0 | 2020-10-30 | Los Angeles | 37 | Southern California | 1.0 | 0.0 | 1.0 | 130.0 | 0.6598984771573604 | 0.0076923076923076 |
38456 | 38456 | Lucile Salter Packard Children's Hsp at Stanford | 53305.0 | 2020-10-30 | Santa Clara | 85 | Bay Area | 0.5714285714285714 | 1.7142857142857142 | 2.2857142857142856 | 261.42857142857144 | 0.7898144151920587 | 0.0087431693989071 |
38311 | 38311 | California Pacific Medical Center- Van Ness Campus | 50047.0 | 2020-10-30 | San Francisco | 75 | Bay Area | 2.142857142857143 | 0.0 | 2.142857142857143 | 201.0 | 0.716760061130922 | 0.0106609808102345 |
38380 | 38380 | Hi-desert Medical Center | 50279.0 | 2020-10-30 | San Bernardino | 71 | Southern California | 1.4285714285714286 | 0.0 | 1.4285714285714286 | 113.57142857142856 | 0.965978128797084 | 0.0125786163522012 |
38559 | 38559 | Sequoia Hospital | 50197.0 | 2020-10-30 | San Mateo | 81 | Bay Area | 0.5714285714285714 | 0.0 | 0.5714285714285714 | 44.0 | 0.360655737704918 | 0.0129870129870129 |
38579 | 38579 | St. Mary Medical Center | 50191.0 | 2020-10-30 | Los Angeles | 37 | Southern California | 2.4285714285714284 | 0.0 | 2.4285714285714284 | 161.42857142857142 | 0.3966303966303966 | 0.0150442477876106 |
38548 | 38548 | Santa Barbara Cottage Hospital | 050396 | 2020-10-30 | Santa Barbara | 83 | Southern California | 3.0 | 0.0 | 3.0 | 198.7142857142857 | 0.56938190749079 | 0.01509705248023 |
38449 | 38449 | Loma Linda University Children's Hospital | 50778.0 | 2020-10-30 | San Bernardino | 71 | Southern California | 1.5714285714285714 | 2.0 | 3.571428571428571 | 227.57142857142856 | 0.6269185360094451 | 0.0156936597614563 |
38464 | 38464 | Marshall Medical Center | 050254 | 2020-10-30 | El Dorado | 17 | Greater Sacramento | 1.0 | 0.0 | 1.0 | 63.57142857142857 | 0.5727155727155727 | 0.0157303370786516 |
38320 | 38320 | Children's Hosp of Los Angeles | 53302.0 | 2020-10-30 | Los Angeles | 37 | Southern California | 0.0 | 5.571428571428571 | 5.571428571428571 | 297.0 | 0.7576530612244898 | 0.0187590187590187 |
38614 | 38614 | Valley Children's Hospital | 053300 | 2020-10-30 | Fresno | 19 | San Joaquin Valley | 1.0 | 2.4285714285714284 | 3.4285714285714284 | 178.57142857142858 | 0.733568075117371 | 0.0192 |
38526 | 38526 | Providence St. Joseph Hospital | 050006 | 2020-10-30 | Humboldt | 23 | Northern California | 2.2857142857142856 | 0.0 | 2.2857142857142856 | 113.0 | 0.6208791208791209 | 0.0202275600505689 |
38329 | 38329 | College Medical Center | 050776 | 2020-10-30 | Los Angeles | 37 | Southern California | 3.2857142857142856 | 0.0 | 3.2857142857142856 | 161.57142857142858 | 0.6968576709796673 | 0.0203359858532272 |
38322 | 38322 | Children's Hospital of Orange County | 053304 | 2020-10-30 | Orange | 59 | Southern California | 0.0 | 4.142857142857143 | 4.142857142857143 | 189.7142857142857 | 0.5680068434559453 | 0.0218373493975903 |
38582 | 38582 | Stanford Health Care | 50441.0 | 2020-10-30 | Santa Clara | 85 | Bay Area | 11.857142857142858 | 0.0 | 11.857142857142858 | 538.0 | 0.8466726618705036 | 0.0220392989909718 |
38290 | 38290 | Adventist Health and Rideout | 50133.0 | 2020-10-30 | Yuba | 115 | Greater Sacramento | 4.142857142857143 | 0.0 | 4.142857142857143 | 186.7142857142857 | 0.701556629092861 | 0.0221882172915072 |
38391 | 38391 | John Muir Medical Center - Walnut Creek Campus | 050180 | 2020-10-30 | Contra Costa | 13 | Bay Area | 6.142857142857143 | 0.7142857142857143 | 6.857142857142858 | 298.1428571428572 | 0.6853858784893269 | 0.0229995208433157 |
38425 | 38425 | Keck Hospital of USC | 050696 | 2020-10-30 | Los Angeles | 37 | Southern California | 5.571428571428571 | 0.0 | 5.571428571428571 | 232.57142857142856 | 0.5799786248664054 | 0.0239557739557739 |
38289 | 38289 | Adventist Health Ukiah Valley | 50301.0 | 2020-10-30 | Mendocino | 45 | Northern California | 1.0 | 0.0 | 1.0 | 41.0 | 0.4076704545454545 | 0.024390243902439 |
38580 | 38580 | St. Mary's Medical Center | 50457.0 | 2020-10-30 | San Francisco | 75 | Bay Area | 1.7142857142857142 | 0.0 | 1.7142857142857142 | 69.85714285714286 | 0.41830624465355 | 0.0245398773006134 |
38607 | 38607 | UCSF Medical Center | 050454 | 2020-10-30 | San Francisco | 75 | Bay Area | 14.571428571428571 | 1.0 | 15.571428571428571 | 634.1428571428571 | 0.9408647732089868 | 0.0245550799729668 |
38462 | 38462 | Marinhealth Medical Center | 050360 | 2020-10-30 | Marin | 41 | Bay Area | 2.857142857142857 | 0.0 | 2.857142857142857 | 114.42857142857144 | 0.5991024682124159 | 0.0249687890137328 |
38385 | 38385 | Huntington Beach Hospital | 050526 | 2020-10-30 | Orange | 59 | Southern California | 1.4285714285714286 | 0.0 | 1.4285714285714286 | 57.142857142857146 | 0.7407407407407408 | 0.0249999999999999 |
38469 | 38469 | Memorial Hospital of Gardena | 50468.0 | 2020-10-30 | Los Angeles | 37 | Southern California | 3.0 | 0.0 | 3.0 | 114.66666666666669 | 0.6666666666666667 | 0.0261627906976744 |
38586 | 38586 | Sutter Amador Hospital | 50014.0 | 2020-10-30 | Amador | 5 | Greater Sacramento | 0.5714285714285714 | 0.0 | 0.5714285714285714 | 21.714285714285715 | 0.4257703081232493 | 0.0263157894736842 |
38483 | 38483 | Mills-peninsula Medical Center | 050007 | 2020-10-30 | San Mateo | 81 | Bay Area | 3.4285714285714284 | 0.0 | 3.4285714285714284 | 129.85714285714286 | 0.5147225368063421 | 0.0264026402640264 |
38403 | 38403 | Kaiser Foundation Hospital - Redwood City | 050541 | 2020-10-30 | San Mateo | 81 | Bay Area | 1.8571428571428568 | 0.0 | 1.8571428571428568 | 70.14285714285714 | 0.9059040590405903 | 0.0264765784114053 |
38612 | 38612 | University of California Davis Medical Center | 50599.0 | 2020-10-30 | Sacramento | 67 | Greater Sacramento | 12.857142857142858 | 1.7142857142857142 | 14.571428571428571 | 543.1428571428571 | 0.9364532019704432 | 0.02682798527091 |
38406 | 38406 | Kaiser Foundation Hospital - San Francisco | 050076 | 2020-10-30 | San Francisco | 75 | Bay Area | 4.714285714285714 | 0.0 | 4.714285714285714 | 170.28571428571428 | 0.9078446306169078 | 0.0276845637583892 |
38568 | 38568 | Sonoma Valley Hospital | 050090 | 2020-10-30 | Sonoma | 97 | Bay Area | 1.1666666666666667 | 0.0 | 1.1666666666666667 | 42.0 | 0.711864406779661 | 0.0277777777777777 |
38508 | 38508 | Petaluma Valley Hospital | 050136 | 2020-10-30 | Sonoma | 97 | Bay Area | 1.0 | 0.0 | 1.0 | 35.0 | 0.5606407322654462 | 0.0285714285714285 |
38455 | 38455 | Los Robles Hospital & Medical Center | 50549.0 | 2020-10-30 | Ventura | 111 | Southern California | 6.285714285714286 | 0.0 | 6.285714285714286 | 212.0 | 0.5760869565217391 | 0.0296495956873315 |
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 );