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 week
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 | ||||
48631 | 48631 | Mountains Community Hospital | 051312 | 2020-02-28 | San Bernardino | 71 | Southern California | 2.4 | 0.1043478260869565 | ||||
48632 | 48632 | Plumas District Hospital | 051326 | 2020-02-28 | Plumas | 63 | Greater Sacramento | 7.0 | 0.4375 | ||||
48628 | 48628 | Mountains Community Hospital | 51312.0 | 2020-03-06 | San Bernardino | 71 | Southern California | 2.571428571428572 | 0.1118012422360248 | ||||
48629 | 48629 | Plumas District Hospital | 51326.0 | 2020-03-06 | Plumas | 63 | Greater Sacramento | 3.857142857142857 | 0.2410714285714285 | ||||
48630 | 48630 | Ventura County Medical Center | 50159.0 | 2020-03-06 | Ventura | 111 | Southern California | 128.5 | 0.7932098765432098 | ||||
48623 | 48623 | Coast Plaza Hospital | 050771 | 2020-03-13 | Los Angeles | 37 | Southern California | 28.166666666666668 | 0.2407407407407407 | ||||
48624 | 48624 | Mountains Community Hospital | 51312.0 | 2020-03-13 | San Bernardino | 71 | Southern California | 1.4285714285714286 | 0.062111801242236 | ||||
48625 | 48625 | Plumas District Hospital | 051326 | 2020-03-13 | Plumas | 63 | Greater Sacramento | 4.571428571428571 | 0.2857142857142857 | ||||
48626 | 48626 | Riverside University Health System-medical Center | 050292 | 2020-03-13 | Riverside | 65 | Southern California | 253.0 | 0.4154351395730706 | ||||
48627 | 48627 | Ventura County Medical Center | 050159 | 2020-03-13 | Ventura | 111 | Southern California | 133.28571428571428 | 0.685022026431718 | ||||
48611 | 48611 | Alhambra Hospital Medical Center | 50281.0 | 2020-03-20 | Los Angeles | 37 | Southern California | 36.0 | 0.3564356435643564 | ||||
48612 | 48612 | Coast Plaza Hospital | 50771.0 | 2020-03-20 | Los Angeles | 37 | Southern California | 24.285714285714285 | 0.2075702075702075 | ||||
48613 | 48613 | George L Mee Memorial Hospital | 050189 | 2020-03-20 | Monterey | 53 | Bay Area | 40.5 | 0.5472972972972973 | ||||
48614 | 48614 | Mark Twain Medical Center | 051332 | 2020-03-20 | Calaveras | 9 | San Joaquin Valley | 11.0 | 0.2619047619047619 | ||||
48615 | 48615 | Mountains Community Hospital | 051312 | 2020-03-20 | San Bernardino | 71 | Southern California | 1.4285714285714286 | 0.054054054054054 | ||||
48616 | 48616 | Plumas District Hospital | 51326.0 | 2020-03-20 | Plumas | 63 | Greater Sacramento | 4.285714285714286 | 0.2678571428571428 | ||||
48617 | 48617 | Riverside University Health System-medical Center | 050292 | 2020-03-20 | Riverside | 65 | Southern California | 254.28571428571428 | 0.4175463288763781 | ||||
48618 | 48618 | St. Johns Hospital Camarillo | 50616.0 | 2020-03-20 | Ventura | 111 | Southern California | 32.0 | 0.4102564102564102 | ||||
48619 | 48619 | St. Johns Regional Medical Center | 50082.0 | 2020-03-20 | Ventura | 111 | Southern California | 54.0 | 0.3233532934131736 | ||||
48620 | 48620 | Tenet Health Central Twin Cities Community Hosp | 050633 | 2020-03-20 | San Luis Obispo | 79 | Southern California | 42.0 | 0.3442622950819672 | ||||
48621 | 48621 | University of California Irvine Medical Center | 50348.0 | 2020-03-20 | Orange | 59 | Southern California | 263.0 | 0.6291866028708134 | ||||
48622 | 48622 | Ventura County Medical Center | 50159.0 | 2020-03-20 | Ventura | 111 | Southern California | 119.85714285714286 | 0.5472928897586432 | ||||
48498 | 48498 | Alhambra Hospital Medical Center | 050281 | 2020-03-27 | Los Angeles | 37 | Southern California | 35.57142857142857 | 0.3521923620933522 | ||||
48499 | 48499 | Anaheim Global Medical Center | 50744.0 | 2020-03-27 | Orange | 59 | Southern California | 120.14285714285714 | 0.6366389099167297 | ||||
48500 | 48500 | Arrowhead Regional Medical Center | 50245.0 | 2020-03-27 | San Bernardino | 71 | Southern California | 274.0 | 0.7486338797814208 | ||||
48501 | 48501 | Bakersfield Heart Hospital | 50724.0 | 2020-03-27 | Kern | 29 | San Joaquin Valley | 25.33333333333333 | 0.3518518518518518 | ||||
48502 | 48502 | Bakersfield Memorial Hospital | 050036 | 2020-03-27 | Kern | 29 | San Joaquin Valley | 141.0 | 0.5423076923076923 | ||||
48503 | 48503 | Banner Lassen Medical Center | 051320 | 2020-03-27 | Lassen | 35 | Northern California | 12.0 | 0.6 | ||||
48504 | 48504 | Bear Valley Community Hospital | 51335.0 | 2020-03-27 | San Bernardino | 71 | Southern California | 0.0 | 0.0 | ||||
48505 | 48505 | California Hospital Medical Center LA | 050149 | 2020-03-27 | Los Angeles | 37 | Southern California | 173.0 | 0.5440251572327044 | ||||
48506 | 48506 | California Pacific Medical Center - Mission Bernal | 50055.0 | 2020-03-27 | San Francisco | 75 | Bay Area | 41.0 | 0.3203125 | ||||
48507 | 48507 | California Pacific Medical Center- Van Ness Campus | 50047.0 | 2020-03-27 | San Francisco | 75 | Bay Area | 191.0 | 0.6262295081967213 | ||||
48508 | 48508 | California Pacific Medical Ctr-davies Campus Hosp | 50008.0 | 2020-03-27 | San Francisco | 75 | Bay Area | 95.33333333333331 | 0.4496855345911949 | ||||
48509 | 48509 | Casa Colina Hosp For Rehab Medicine | 05T782 | 2020-03-27 | Los Angeles | 37 | Southern California | 70.0 | 1.0 | ||||
48510 | 48510 | Casa Colina Hospital | 050782 | 2020-03-27 | Los Angeles | 37 | Southern California | 64.5 | 0.6142857142857143 | ||||
48511 | 48511 | Centinela Hospital Medical Center | 050739 | 2020-03-27 | Los Angeles | 37 | Southern California | 153.0 | 0.4226519337016574 | ||||
48512 | 48512 | Chapman Global Medical Center | 50745.0 | 2020-03-27 | Orange | 59 | Southern California | 54.5 | 0.4780701754385965 | ||||
48513 | 48513 | Coast Plaza Hospital | 50771.0 | 2020-03-27 | Los Angeles | 37 | Southern California | 25.714285714285715 | 0.2197802197802197 | ||||
48514 | 48514 | Colusa Medical Center | 50783.0 | 2020-03-27 | Colusa | 11 | Greater Sacramento | 10.0 | 0.1333333333333333 | ||||
48515 | 48515 | Community Hospital of San Bernardino | 50089.0 | 2020-03-27 | San Bernardino | 71 | Southern California | 102.0 | 0.34 | ||||
48516 | 48516 | Contra Costa Regional Medical Center | 050276 | 2020-03-27 | Contra Costa | 13 | Bay Area | 146.0 | 1.0 | ||||
48517 | 48517 | Desert Valley Hospital | 050709 | 2020-03-27 | San Bernardino | 71 | Southern California | 60.5 | 0.5238095238095238 | ||||
48518 | 48518 | Doctors Hospital of Riverside, LLC | 50102.0 | 2020-03-27 | Riverside | 65 | Southern California | 80.0 | 0.4145077720207253 | ||||
48519 | 48519 | Dominican Hospital | 50242.0 | 2020-03-27 | Santa Cruz | 87 | Bay Area | 109.0 | 0.439516129032258 | ||||
48520 | 48520 | El Camino Hospital | 50308.0 | 2020-03-27 | Santa Clara | 85 | Bay Area | 160.0 | 0.3053435114503817 | ||||
48521 | 48521 | Emanuel Medical Center | 050179 | 2020-03-27 | Stanislaus | 99 | San Joaquin Valley | 90.0 | 0.3846153846153846 | ||||
48522 | 48522 | Encino Hospital Medical Center | 050158 | 2020-03-27 | Los Angeles | 37 | Southern California | 50.0 | 0.7692307692307693 | ||||
48523 | 48523 | Garden Grove Hospital & Medical Center | 50230.0 | 2020-03-27 | Orange | 59 | Southern California | 39.0 | 0.217877094972067 | ||||
48524 | 48524 | Garfield Medical Center | 50737.0 | 2020-03-27 | Los Angeles | 37 | Southern California | 72.75 | 0.3464285714285714 | ||||
48525 | 48525 | George L Mee Memorial Hospital | 50189.0 | 2020-03-27 | Monterey | 53 | Bay Area | 40.42857142857143 | 0.5463320463320464 | ||||
48526 | 48526 | Glendale Mem Hospital & Health Center | 50058.0 | 2020-03-27 | Los Angeles | 37 | Southern California | 112.5 | 0.3368263473053892 | ||||
48527 | 48527 | Glenn Medical Center | 051306 | 2020-03-27 | Glenn | 21 | Northern California | 22.0 | 0.4680851063829787 | ||||
48528 | 48528 | Good Samaritan Hospital | 50257.0 | 2020-03-27 | Kern | 29 | San Joaquin Valley | 28.25 | 0.353125 | ||||
48529 | 48529 | Hemet Global Medical Center | 50390.0 | 2020-03-27 | Riverside | 65 | Southern California | 87.5 | 0.4605263157894737 | ||||
48530 | 48530 | Henry Mayo Newhall Hospital | 50624.0 | 2020-03-27 | Los Angeles | 37 | Southern California | 115.75 | 0.3900589721988206 | ||||
48531 | 48531 | Hoag Memorial Hospital Presbyterian | 50224.0 | 2020-03-27 | Orange | 59 | Southern California | 282.25 | 0.3748339973439575 | ||||
48532 | 48532 | Hoag Orthopedic Institute | 050769 | 2020-03-27 | Orange | 59 | Southern California | 16.0 | 0.4705882352941176 | ||||
48533 | 48533 | Hollywood Presbyterian Medical Center | 050063 | 2020-03-27 | Los Angeles | 37 | Southern California | 184.0 | 0.6237288135593221 | ||||
48534 | 48534 | Kaweah Health Medical Center | 50057.0 | 2020-03-27 | Tulare | 107 | San Joaquin Valley | 197.0 | 0.6700680272108843 | ||||
48535 | 48535 | Keck Hospital of USC | 050696 | 2020-03-27 | Los Angeles | 37 | Southern California | 135.0 | 0.2227722772277227 | ||||
48536 | 48536 | Kern Medical Center | 050315 | 2020-03-27 | Kern | 29 | San Joaquin Valley | 92.0 | 0.3205574912891986 | ||||
48537 | 48537 | LAC+USC Medical Center | 50373.0 | 2020-03-27 | Los Angeles | 37 | Southern California | 408.0 | 0.707105719237435 | ||||
48538 | 48538 | LAC/Harbor-UCLA Medical Center | 50376.0 | 2020-03-27 | Los Angeles | 37 | Southern California | 219.42857142857144 | 0.5210312075983717 | ||||
48539 | 48539 | LAC/Olive View-UCLA Medical Center | 050040 | 2020-03-27 | Los Angeles | 37 | Southern California | 149.57142857142858 | 0.5865546218487395 | ||||
48540 | 48540 | Lompoc Valley Medical Center | 050110 | 2020-03-27 | Santa Barbara | 83 | Southern California | 17.25 | 0.1658653846153846 | ||||
48541 | 48541 | Los Alamitos Medical Center | 50551.0 | 2020-03-27 | Orange | 59 | Southern California | 71.0 | 0.4152046783625731 | ||||
48542 | 48542 | Mad River Community Hospital | 050028 | 2020-03-27 | Humboldt | 23 | Northern California | 8.75 | 0.1057401812688821 | ||||
48543 | 48543 | Marinhealth Medical Center | 050360 | 2020-03-27 | Marin | 41 | Bay Area | 83.0 | 0.3531914893617021 | ||||
48544 | 48544 | Mark Twain Medical Center | 51332.0 | 2020-03-27 | Calaveras | 9 | San Joaquin Valley | 11.285714285714286 | 0.2687074829931973 | ||||
48545 | 48545 | Martin Luther King, Jr. Community Hospital | 050779 | 2020-03-27 | Los Angeles | 37 | Southern California | 101.85714285714286 | 0.777535441657579 | ||||
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 | ||||
48547 | 48547 | Memorialcare Long Beach Medical Center | 50485.0 | 2020-03-27 | Los Angeles | 37 | Southern California | 209.5 | 0.3040638606676342 | ||||
48548 | 48548 | Memorialcare Orange Coast Medical Center | 50678.0 | 2020-03-27 | Orange | 59 | Southern California | 90.0 | 0.4054054054054054 | ||||
48549 | 48549 | Memorialcare Saddleback Medical Center | 050603 | 2020-03-27 | Orange | 59 | Southern California | 100.0 | 0.4032258064516129 | ||||
48550 | 48550 | Menifee Global Medical Center | 050684 | 2020-03-27 | Riverside | 65 | Southern California | 28.0 | 0.345679012345679 | ||||
48551 | 48551 | Mercy General Hospital | 50017.0 | 2020-03-27 | Sacramento | 67 | Greater Sacramento | 110.0 | 0.2546296296296296 | ||||
48552 | 48552 | Mercy Hospital of Folsom | 050414 | 2020-03-27 | Sacramento | 67 | Greater Sacramento | 70.0 | 0.5343511450381679 | ||||
48553 | 48553 | Mercy Medical Center | 050444 | 2020-03-27 | Merced | 47 | San Joaquin Valley | 88.0 | 0.4271844660194174 | ||||
48554 | 48554 | Mercy Medical Center Mt Shasta | 051319 | 2020-03-27 | Siskiyou | 93 | Northern California | 12.0 | 0.3333333333333333 | ||||
48555 | 48555 | Mercy Medical Center Redding | 050280 | 2020-03-27 | Shasta | 89 | Northern California | 140.0 | 0.5243445692883895 | ||||
48556 | 48556 | Mercy San Juan Medical Center | 50516.0 | 2020-03-27 | Sacramento | 67 | Greater Sacramento | 155.0 | 0.4189189189189189 | ||||
48557 | 48557 | Methodist Hospital of Sacramento | 050590 | 2020-03-27 | Sacramento | 67 | Greater Sacramento | 69.0 | 0.3349514563106796 | ||||
48558 | 48558 | Montclair Hospital Medical Center | 50758.0 | 2020-03-27 | San Bernardino | 71 | Southern California | 19.0 | 0.1461538461538461 | ||||
48559 | 48559 | Monterey Park Hospital | 050736 | 2020-03-27 | Los Angeles | 37 | Southern California | 30.33333333333333 | 0.3003300330033003 | ||||
48560 | 48560 | Mountains Community Hospital | 051312 | 2020-03-27 | San Bernardino | 71 | Southern California | 2.857142857142857 | 0.1058201058201058 | ||||
48561 | 48561 | Natividad Medical Center | 50248.0 | 2020-03-27 | Monterey | 53 | Bay Area | 105.66666666666669 | 0.5283333333333333 | ||||
48562 | 48562 | Northern Inyo Hospital | 51324.0 | 2020-03-27 | Inyo | 27 | Southern California | 4.5 | 0.0849056603773584 | ||||
48563 | 48563 | Northridge Hospital Medical Center | 050116 | 2020-03-27 | Los Angeles | 37 | Southern California | 143.0 | 0.322072072072072 | ||||
48564 | 48564 | Olympia Medical Center | 50742.0 | 2020-03-27 | Los Angeles | 37 | Southern California | 70.5 | 0.7833333333333333 | ||||
48565 | 48565 | Orange County Global Medical Center | 050746 | 2020-03-27 | Orange | 59 | Southern California | 107.71428571428572 | 0.4240719910011248 | ||||
48566 | 48566 | Orchard Hospital | 51311.0 | 2020-03-27 | Butte | 7 | Greater Sacramento | 5.333333333333333 | 0.1300813008130081 | ||||
48567 | 48567 | Pacifica Hospital of the Valley | 50378.0 | 2020-03-27 | Los Angeles | 37 | Southern California | 17.25 | 0.1875 | ||||
48568 | 48568 | Palo Verde Hospital | 50423.0 | 2020-03-27 | Riverside | 65 | Southern California | 4.25 | 0.0833333333333333 | ||||
48569 | 48569 | Pih Health Downey Hospital | 50393.0 | 2020-03-27 | Los Angeles | 37 | Southern California | 96.33333333333331 | 0.4134477825464949 | ||||
48570 | 48570 | Pioneers Memorial Healthcare District | 50342.0 | 2020-03-27 | Imperial | 25 | Southern California | 37.5 | 0.2568493150684932 | ||||
48571 | 48571 | Placentia Linda Hospital | 050589 | 2020-03-27 | Orange | 59 | Southern California | 33.0 | 0.2462686567164179 | ||||
48572 | 48572 | Plumas District Hospital | 51326.0 | 2020-03-27 | Plumas | 63 | Greater Sacramento | 4.285714285714286 | 0.2678571428571428 | ||||
48573 | 48573 | Rady Children's Hospital - San Diego | 053303 | 2020-03-27 | San Diego | 73 | Southern California | 245.0 | 0.5361050328227571 | ||||
48574 | 48574 | Riverside University Health System-medical Center | 50292.0 | 2020-03-27 | Riverside | 65 | Southern California | 237.7142857142857 | 0.3903354445226366 |
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 );