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 rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
48633 | 48633 | Temecula Valley Hospital | 050775 | 2020-01-31 | Riverside | 65 | Southern California | 77.0 | 0.3793103448275862 | ||||
48632 | 48632 | Plumas District Hospital | 051326 | 2020-02-28 | Plumas | 63 | Greater Sacramento | 7.0 | 0.4375 | ||||
48631 | 48631 | Mountains Community Hospital | 051312 | 2020-02-28 | San Bernardino | 71 | Southern California | 2.4 | 0.1043478260869565 | ||||
48630 | 48630 | Ventura County Medical Center | 50159.0 | 2020-03-06 | Ventura | 111 | Southern California | 128.5 | 0.7932098765432098 | ||||
48629 | 48629 | Plumas District Hospital | 51326.0 | 2020-03-06 | Plumas | 63 | Greater Sacramento | 3.857142857142857 | 0.2410714285714285 | ||||
48628 | 48628 | Mountains Community Hospital | 51312.0 | 2020-03-06 | San Bernardino | 71 | Southern California | 2.571428571428572 | 0.1118012422360248 | ||||
48627 | 48627 | Ventura County Medical Center | 050159 | 2020-03-13 | Ventura | 111 | Southern California | 133.28571428571428 | 0.685022026431718 | ||||
48626 | 48626 | Riverside University Health System-medical Center | 050292 | 2020-03-13 | Riverside | 65 | Southern California | 253.0 | 0.4154351395730706 | ||||
48625 | 48625 | Plumas District Hospital | 051326 | 2020-03-13 | Plumas | 63 | Greater Sacramento | 4.571428571428571 | 0.2857142857142857 | ||||
48624 | 48624 | Mountains Community Hospital | 51312.0 | 2020-03-13 | San Bernardino | 71 | Southern California | 1.4285714285714286 | 0.062111801242236 | ||||
48623 | 48623 | Coast Plaza Hospital | 050771 | 2020-03-13 | Los Angeles | 37 | Southern California | 28.166666666666668 | 0.2407407407407407 | ||||
48622 | 48622 | Ventura County Medical Center | 50159.0 | 2020-03-20 | Ventura | 111 | Southern California | 119.85714285714286 | 0.5472928897586432 | ||||
48621 | 48621 | University of California Irvine Medical Center | 50348.0 | 2020-03-20 | Orange | 59 | Southern California | 263.0 | 0.6291866028708134 | ||||
48620 | 48620 | Tenet Health Central Twin Cities Community Hosp | 050633 | 2020-03-20 | San Luis Obispo | 79 | Southern California | 42.0 | 0.3442622950819672 | ||||
48619 | 48619 | St. Johns Regional Medical Center | 50082.0 | 2020-03-20 | Ventura | 111 | Southern California | 54.0 | 0.3233532934131736 | ||||
48618 | 48618 | St. Johns Hospital Camarillo | 50616.0 | 2020-03-20 | Ventura | 111 | Southern California | 32.0 | 0.4102564102564102 | ||||
48617 | 48617 | Riverside University Health System-medical Center | 050292 | 2020-03-20 | Riverside | 65 | Southern California | 254.28571428571428 | 0.4175463288763781 | ||||
48616 | 48616 | Plumas District Hospital | 51326.0 | 2020-03-20 | Plumas | 63 | Greater Sacramento | 4.285714285714286 | 0.2678571428571428 | ||||
48615 | 48615 | Mountains Community Hospital | 051312 | 2020-03-20 | San Bernardino | 71 | Southern California | 1.4285714285714286 | 0.054054054054054 | ||||
48614 | 48614 | Mark Twain Medical Center | 051332 | 2020-03-20 | Calaveras | 9 | San Joaquin Valley | 11.0 | 0.2619047619047619 | ||||
48613 | 48613 | George L Mee Memorial Hospital | 050189 | 2020-03-20 | Monterey | 53 | Bay Area | 40.5 | 0.5472972972972973 | ||||
48612 | 48612 | Coast Plaza Hospital | 50771.0 | 2020-03-20 | Los Angeles | 37 | Southern California | 24.285714285714285 | 0.2075702075702075 | ||||
48611 | 48611 | Alhambra Hospital Medical Center | 50281.0 | 2020-03-20 | Los Angeles | 37 | Southern California | 36.0 | 0.3564356435643564 | ||||
48610 | 48610 | Woodland Memorial Hospital | 050127 | 2020-03-27 | Yolo | 113 | Greater Sacramento | 55.0 | 0.4621848739495798 | ||||
48609 | 48609 | West Anaheim Medical Center | 050426 | 2020-03-27 | Orange | 59 | Southern California | 86.66666666666667 | 0.4693140794223827 | ||||
48608 | 48608 | Victor Valley Global Medical Center | 50517.0 | 2020-03-27 | San Bernardino | 71 | Southern California | 37.333333333333336 | 0.3137254901960784 | ||||
48607 | 48607 | Vibra Hospital of Sacramento | 52033.0 | 2020-03-27 | Sacramento | 67 | Greater Sacramento | 48.0 | 0.8275862068965517 | ||||
48606 | 48606 | Ventura County Medical Center | 50159.0 | 2020-03-27 | Ventura | 111 | Southern California | 116.57142857142856 | 0.5322896281800391 | ||||
48605 | 48605 | University of California Irvine Medical Center | 50348.0 | 2020-03-27 | Orange | 59 | Southern California | 239.14285714285717 | 0.5721120984278879 | ||||
48604 | 48604 | USC Verdugo Hills Hospital | 50124.0 | 2020-03-27 | Los Angeles | 37 | Southern California | 55.333333333333336 | 0.2712418300653595 | ||||
48603 | 48603 | USC Kenneth Norris Jr Cancer Hospital | 050660 | 2020-03-27 | Los Angeles | 37 | Southern California | 29.75 | 0.2479166666666666 | ||||
48602 | 48602 | USC Arcadia Hospital | 50238.0 | 2020-03-27 | Los Angeles | 37 | Southern California | 163.25 | 0.4691091954022988 | ||||
48601 | 48601 | UCSF Medical Center | 50454.0 | 2020-03-27 | San Francisco | 75 | Bay Area | 459.0 | 0.575187969924812 | ||||
48600 | 48600 | UCSF Benioff Children's Hospital Oakland | 053301 | 2020-03-27 | Alameda | 1 | Bay Area | 105.0 | 0.4268292682926829 | ||||
48599 | 48599 | Tenet Health Central Twin Cities Community Hosp | 50633.0 | 2020-03-27 | San Luis Obispo | 79 | Southern California | 43.5 | 0.3337595907928388 | ||||
48598 | 48598 | Temecula Valley Hospital | 050775 | 2020-03-27 | Riverside | 65 | Southern California | 84.0 | 0.4137931034482758 | ||||
48597 | 48597 | Stanislaus Surgical Hospital | 50726.0 | 2020-03-27 | Stanislaus | 99 | San Joaquin Valley | 1.8571428571428568 | 0.0351351351351351 | ||||
48596 | 48596 | Stanford Health Care - Valleycare | 050283 | 2020-03-27 | Alameda | 1 | Bay Area | 53.5 | 0.1897163120567375 | ||||
48595 | 48595 | St. Mary's Medical Center | 50457.0 | 2020-03-27 | San Francisco | 75 | Bay Area | 29.0 | 0.1054545454545454 | ||||
48594 | 48594 | St. Joseph's Medical Center of Stockton | 050084 | 2020-03-27 | San Joaquin | 77 | San Joaquin Valley | 206.25 | 0.4969879518072289 | ||||
48593 | 48593 | St. Johns Regional Medical Center | 050082 | 2020-03-27 | Ventura | 111 | Southern California | 73.71428571428571 | 0.4414029084687767 | ||||
48592 | 48592 | St. Johns Hospital Camarillo | 050616 | 2020-03-27 | Ventura | 111 | Southern California | 40.85714285714285 | 0.5238095238095237 | ||||
48591 | 48591 | St. Elizabeth Community Hospital | 050042 | 2020-03-27 | Tehama | 103 | Northern California | 16.0 | 0.2105263157894736 | ||||
48590 | 48590 | Southwest Healthcare System | 50701.0 | 2020-03-27 | Riverside | 65 | Southern California | 147.5 | 0.6120331950207469 | ||||
48589 | 48589 | South Coast Global Medical Center | 50747.0 | 2020-03-27 | Orange | 59 | Southern California | 24.0 | 0.2526315789473684 | ||||
48588 | 48588 | Sierra View Medical Center | 50261.0 | 2020-03-27 | Tulare | 107 | San Joaquin Valley | 54.5 | 0.2883597883597883 | ||||
48587 | 48587 | Shasta Regional Medical Center | 050764 | 2020-03-27 | Shasta | 89 | Northern California | 80.8 | 0.3575221238938053 | ||||
48586 | 48586 | Sequoia Hospital | 050197 | 2020-03-27 | San Mateo | 81 | Bay Area | 31.0 | 0.3076923076923077 | ||||
48585 | 48585 | Scripps Mercy Hospital | 50077.0 | 2020-03-27 | San Diego | 73 | Southern California | 317.0 | 0.4058898847631242 | ||||
48584 | 48584 | Scripps Memorial Hospital La Jolla | 50324.0 | 2020-03-27 | San Diego | 73 | Southern California | 189.0 | 0.3727810650887574 | ||||
48583 | 48583 | Scripps Memorial Hospital - Encinitas | 50503.0 | 2020-03-27 | San Diego | 73 | Southern California | 105.0 | 0.4069767441860465 | ||||
48582 | 48582 | Scripps Green Hospital | 50424.0 | 2020-03-27 | San Diego | 73 | Southern California | 58.75 | 0.3766025641025641 | ||||
48581 | 48581 | Santa Clara Valley Medical Center | 050038 | 2020-03-27 | Santa Clara | 85 | Bay Area | 163.5 | 0.3879003558718861 | ||||
48580 | 48580 | Santa Barbara Cottage Hospital | 050396 | 2020-03-27 | Santa Barbara | 83 | Southern California | 136.5 | 0.3659517426273458 | ||||
48579 | 48579 | San Mateo Medical Center | 50113.0 | 2020-03-27 | San Mateo | 81 | Bay Area | 26.666666666666668 | 0.3065134099616858 | ||||
48578 | 48578 | San Gorgonio Memorial Hospital | 50054.0 | 2020-03-27 | Riverside | 65 | Southern California | 21.5 | 0.199074074074074 | ||||
48577 | 48577 | Saint Francis Memorial Hospital | 50152.0 | 2020-03-27 | San Francisco | 75 | Bay Area | 83.5 | 0.5880281690140845 | ||||
48576 | 48576 | Saint Francis Medical Center | 050104 | 2020-03-27 | Los Angeles | 37 | Southern California | 224.0 | 0.5833333333333334 | ||||
48575 | 48575 | Saint Agnes Medical Center | 050093 | 2020-03-27 | Fresno | 19 | San Joaquin Valley | 208.5 | 0.5265151515151515 | ||||
48574 | 48574 | Riverside University Health System-medical Center | 50292.0 | 2020-03-27 | Riverside | 65 | Southern California | 237.7142857142857 | 0.3903354445226366 | ||||
48573 | 48573 | Rady Children's Hospital - San Diego | 053303 | 2020-03-27 | San Diego | 73 | Southern California | 245.0 | 0.5361050328227571 | ||||
48572 | 48572 | Plumas District Hospital | 51326.0 | 2020-03-27 | Plumas | 63 | Greater Sacramento | 4.285714285714286 | 0.2678571428571428 | ||||
48571 | 48571 | Placentia Linda Hospital | 050589 | 2020-03-27 | Orange | 59 | Southern California | 33.0 | 0.2462686567164179 | ||||
48570 | 48570 | Pioneers Memorial Healthcare District | 50342.0 | 2020-03-27 | Imperial | 25 | Southern California | 37.5 | 0.2568493150684932 | ||||
48569 | 48569 | Pih Health Downey Hospital | 50393.0 | 2020-03-27 | Los Angeles | 37 | Southern California | 96.33333333333331 | 0.4134477825464949 | ||||
48568 | 48568 | Palo Verde Hospital | 50423.0 | 2020-03-27 | Riverside | 65 | Southern California | 4.25 | 0.0833333333333333 | ||||
48567 | 48567 | Pacifica Hospital of the Valley | 50378.0 | 2020-03-27 | Los Angeles | 37 | Southern California | 17.25 | 0.1875 | ||||
48566 | 48566 | Orchard Hospital | 51311.0 | 2020-03-27 | Butte | 7 | Greater Sacramento | 5.333333333333333 | 0.1300813008130081 | ||||
48565 | 48565 | Orange County Global Medical Center | 050746 | 2020-03-27 | Orange | 59 | Southern California | 107.71428571428572 | 0.4240719910011248 | ||||
48564 | 48564 | Olympia Medical Center | 50742.0 | 2020-03-27 | Los Angeles | 37 | Southern California | 70.5 | 0.7833333333333333 | ||||
48563 | 48563 | Northridge Hospital Medical Center | 050116 | 2020-03-27 | Los Angeles | 37 | Southern California | 143.0 | 0.322072072072072 | ||||
48562 | 48562 | Northern Inyo Hospital | 51324.0 | 2020-03-27 | Inyo | 27 | Southern California | 4.5 | 0.0849056603773584 | ||||
48561 | 48561 | Natividad Medical Center | 50248.0 | 2020-03-27 | Monterey | 53 | Bay Area | 105.66666666666669 | 0.5283333333333333 | ||||
48560 | 48560 | Mountains Community Hospital | 051312 | 2020-03-27 | San Bernardino | 71 | Southern California | 2.857142857142857 | 0.1058201058201058 | ||||
48559 | 48559 | Monterey Park Hospital | 050736 | 2020-03-27 | Los Angeles | 37 | Southern California | 30.33333333333333 | 0.3003300330033003 | ||||
48558 | 48558 | Montclair Hospital Medical Center | 50758.0 | 2020-03-27 | San Bernardino | 71 | Southern California | 19.0 | 0.1461538461538461 | ||||
48557 | 48557 | Methodist Hospital of Sacramento | 050590 | 2020-03-27 | Sacramento | 67 | Greater Sacramento | 69.0 | 0.3349514563106796 | ||||
48556 | 48556 | Mercy San Juan Medical Center | 50516.0 | 2020-03-27 | Sacramento | 67 | Greater Sacramento | 155.0 | 0.4189189189189189 | ||||
48555 | 48555 | Mercy Medical Center Redding | 050280 | 2020-03-27 | Shasta | 89 | Northern California | 140.0 | 0.5243445692883895 | ||||
48554 | 48554 | Mercy Medical Center Mt Shasta | 051319 | 2020-03-27 | Siskiyou | 93 | Northern California | 12.0 | 0.3333333333333333 | ||||
48553 | 48553 | Mercy Medical Center | 050444 | 2020-03-27 | Merced | 47 | San Joaquin Valley | 88.0 | 0.4271844660194174 | ||||
48552 | 48552 | Mercy Hospital of Folsom | 050414 | 2020-03-27 | Sacramento | 67 | Greater Sacramento | 70.0 | 0.5343511450381679 | ||||
48551 | 48551 | Mercy General Hospital | 50017.0 | 2020-03-27 | Sacramento | 67 | Greater Sacramento | 110.0 | 0.2546296296296296 | ||||
48550 | 48550 | Menifee Global Medical Center | 050684 | 2020-03-27 | Riverside | 65 | Southern California | 28.0 | 0.345679012345679 | ||||
48549 | 48549 | Memorialcare Saddleback Medical Center | 050603 | 2020-03-27 | Orange | 59 | Southern California | 100.0 | 0.4032258064516129 | ||||
48548 | 48548 | Memorialcare Orange Coast Medical Center | 50678.0 | 2020-03-27 | Orange | 59 | Southern California | 90.0 | 0.4054054054054054 | ||||
48547 | 48547 | Memorialcare Long Beach Medical Center | 50485.0 | 2020-03-27 | Los Angeles | 37 | Southern California | 209.5 | 0.3040638606676342 | ||||
48546 | 48546 | Memorial Care Miller Children's & Women's Hosp Lb | 53309.0 | 2020-03-27 | Los Angeles | 37 | Southern California | 172.0 | 0.4661246612466124 | ||||
48545 | 48545 | Martin Luther King, Jr. Community Hospital | 050779 | 2020-03-27 | Los Angeles | 37 | Southern California | 101.85714285714286 | 0.777535441657579 | ||||
48544 | 48544 | Mark Twain Medical Center | 51332.0 | 2020-03-27 | Calaveras | 9 | San Joaquin Valley | 11.285714285714286 | 0.2687074829931973 | ||||
48543 | 48543 | Marinhealth Medical Center | 050360 | 2020-03-27 | Marin | 41 | Bay Area | 83.0 | 0.3531914893617021 | ||||
48542 | 48542 | Mad River Community Hospital | 050028 | 2020-03-27 | Humboldt | 23 | Northern California | 8.75 | 0.1057401812688821 | ||||
48541 | 48541 | Los Alamitos Medical Center | 50551.0 | 2020-03-27 | Orange | 59 | Southern California | 71.0 | 0.4152046783625731 | ||||
48540 | 48540 | Lompoc Valley Medical Center | 050110 | 2020-03-27 | Santa Barbara | 83 | Southern California | 17.25 | 0.1658653846153846 | ||||
48539 | 48539 | LAC/Olive View-UCLA Medical Center | 050040 | 2020-03-27 | Los Angeles | 37 | Southern California | 149.57142857142858 | 0.5865546218487395 | ||||
48538 | 48538 | LAC/Harbor-UCLA Medical Center | 50376.0 | 2020-03-27 | Los Angeles | 37 | Southern California | 219.42857142857144 | 0.5210312075983717 | ||||
48537 | 48537 | LAC+USC Medical Center | 50373.0 | 2020-03-27 | Los Angeles | 37 | Southern California | 408.0 | 0.707105719237435 | ||||
48536 | 48536 | Kern Medical Center | 050315 | 2020-03-27 | Kern | 29 | San Joaquin Valley | 92.0 | 0.3205574912891986 | ||||
48535 | 48535 | Keck Hospital of USC | 050696 | 2020-03-27 | Los Angeles | 37 | Southern California | 135.0 | 0.2227722772277227 | ||||
48534 | 48534 | Kaweah Health Medical Center | 50057.0 | 2020-03-27 | Tulare | 107 | San Joaquin Valley | 197.0 | 0.6700680272108843 |
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 );