hhs-hospital-patient-totals

Table actions

The Department of Health and Human Services releases a weekly update on the number of COVID-19 patients in hospitals. This file contains the key metrics for facilities in California.

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.

38,375 rows

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: region, 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
1 1 Adventist Health Bakersfield 50455.0 2022-09-09 Kern 29 San Joaquin Valley 23.285714285714285 0.0 23.285714285714285 191.8571428571429 0.9511331444759208 0.1213700670141474
2 2 Adventist Health Clearlake 51317.0 2022-09-09 Lake 33 Northern California 1.5714285714285714 0.0 1.5714285714285714 18.285714285714285 0.4942084942084941 0.0859375
3 3 Adventist Health Delano 50608.0 2022-09-09 Kern 29 San Joaquin Valley 1.4285714285714286 0.0 1.4285714285714286 18.142857142857142 1.0 0.0787401574803149
4 4 Adventist Health Hanford 50121.0 2022-09-09 Kings 31 San Joaquin Valley 6.285714285714286 0.0 6.285714285714286 114.28571428571428 0.9174311926605504 0.0549999999999999
5 5 Adventist Health Howard Memorial 51310.0 2022-09-09 Mendocino 45 Northern California 0.0 0.0 0.0 21.857142857142858 0.8742857142857143 0.0
6 6 Adventist Health Lodi Memorial 50336.0 2022-09-09 San Joaquin 77 San Joaquin Valley 9.0 0.0 9.0 103.14285714285714 0.8783454987834549 0.0872576177285318
7 7 Adventist Health Mendocino Coast 51325.0 2022-09-09 Mendocino 45 Northern California 0.7142857142857143 0.0 0.7142857142857143 12.0 0.8571428571428571 0.0595238095238095
8 8 Adventist Health Reedley 50192.0 2022-09-09 Fresno 19 San Joaquin Valley 0.0 0.0 0.0 22.714285714285715 0.6943231441048036 0.0
9 9 Adventist Health Simi Valley 50236.0 2022-09-09 Ventura 111 Southern California 12.714285714285714 0.0 12.714285714285714 110.28571428571428 0.7352380952380952 0.1152849740932642
10 10 Adventist Health Sonora 50335.0 2022-09-09 Tuolumne 109 San Joaquin Valley 1.8571428571428568 0.0 1.8571428571428568 45.0 0.625 0.0412698412698412
11 11 Adventist Health St. Helena 50013.0 2022-09-09 Napa 55 Bay Area 2.142857142857143 0.0 2.142857142857143 49.42857142857143 0.8543209876543211 0.0433526011560693
12 12 Adventist Health Tehachapi Valley 51301.0 2022-09-09 Kern 29 San Joaquin Valley 1.1428571428571428 0.0 1.1428571428571428 8.714285714285714 0.8970588235294118 0.1311475409836065
13 13 Adventist Health Tulare 50784.0 2022-09-09 Tulare 107 San Joaquin Valley 1.0 0.0 1.0 17.714285714285715 0.7167630057803468 0.0564516129032258
14 14 Adventist Health Ukiah Valley 50301.0 2022-09-09 Mendocino 45 Northern California 2.571428571428572 0.0 2.571428571428572 41.0 0.841642228739003 0.0627177700348432
15 15 Adventist Health and Rideout 50133.0 2022-09-09 Yuba 115 Greater Sacramento 5.0 0.0 5.0 173.0 0.6479400749063671 0.0289017341040462
16 16 Ahmc Anaheim Regional Medical Center 50226.0 2022-09-09 Orange 59 Southern California 7.428571428571429 0.0 7.428571428571429 89.57142857142857 0.346102892470744 0.0829346092503987
17 17 Ahmc Seton Medical Center 50289.0 2022-09-09 San Mateo 81 Bay Area 2.0 0.0 2.0 44.42857142857143 0.7300469483568076 0.045016077170418
18 18 Alameda Hospital 50211.0 2022-09-09 Alameda 1 Bay Area 1.4285714285714286 0.0 1.4285714285714286 40.285714285714285 0.4476190476190476 0.0354609929078014
19 19 Alhambra Hospital Medical Center 50281.0 2022-09-09 Los Angeles 37 Southern California 5.714285714285714 0.0 5.714285714285714 63.285714285714285 0.6265912305516266 0.0902934537246049
20 20 Alta Bates Summit Medical Center 50043.0 2022-09-09 Alameda 1 Bay Area 14.857142857142858 0.0 14.857142857142858 192.57142857142856 0.6483886483886484 0.0771513353115727
21 21 Alta Bates Summit Medical Center - Alta Bates Camp 50305.0 2022-09-09 Alameda 1 Bay Area 9.857142857142858 0.0 9.857142857142858 122.28571428571428 0.3004563004563004 0.080607476635514
22 22 Alvarado Hospital Medical Center 50757.0 2022-09-09 San Diego 73 Southern California 4.428571428571429 0.0 4.428571428571429 85.0 0.6223849372384936 0.0521008403361344
23 23 Anaheim Global Medical Center 50744.0 2022-09-09 Orange 59 Southern California 0.5714285714285714 0.0 0.5714285714285714 108.57142857142856 0.5744520030234316 0.0052631578947368
24 24 Antelope Valley Hospital 50056.0 2022-09-09 Los Angeles 37 Southern California 15.571428571428571 0.0 15.571428571428571 201.28571428571428 1.0 0.0773598296664301
25 25 Arrowhead Regional Medical Center 50245.0 2022-09-09 San Bernardino 71 Southern California 12.285714285714286 0.0 12.285714285714286 283.85714285714283 0.844812925170068 0.0432813286361348
26 26 Bakersfield Heart Hospital 50724.0 2022-09-09 Kern 29 San Joaquin Valley 2.2857142857142856 0.0 2.2857142857142856 20.142857142857142 0.5241635687732341 0.1134751773049645
27 27 Bakersfield Memorial Hospital 50036.0 2022-09-09 Kern 29 San Joaquin Valley 16.714285714285715 1.5714285714285714 18.28571428571429 215.7142857142857 0.6823316764572978 0.0847682119205298
28 28 Barlow Respiratory Hospital 52031.0 2022-09-09 Los Angeles 37 Southern California 9.857142857142858 0.0 9.857142857142858 61.142857142857146 0.740484429065744 0.161214953271028
29 29 Barstow Community Hospital 50298.0 2022-09-09 San Bernardino 71 Southern California 1.1428571428571428 0.0 1.1428571428571428 16.571428571428573 3.3142857142857145 0.0689655172413793
30 30 Barton Memorial Hospital 50352.0 2022-09-09 El Dorado 17 Greater Sacramento 0.8571428571428571 0.0 0.8571428571428571 26.285714285714285 0.3890063424947146 0.0326086956521739
31 31 Bear Valley Community Hospital 51335.0 2022-09-09 San Bernardino 71 Southern California 0.0 0.0 0.0 3.857142857142857 0.1956521739130434 0.0
32 32 Beverly Hospital 50350.0 2022-09-09 Los Angeles 37 Southern California 3.2857142857142856 0.0 3.2857142857142856 113.28571428571428 0.6436688311688312 0.0290037831021437
33 33 California Hospital Medical Center LA 50149.0 2022-09-09 Los Angeles 37 Southern California 15.571428571428571 0.0 15.571428571428571 209.14285714285717 0.6097459391920034 0.0744535519125683
34 34 California Pacific Medical Center - Mission Bernal 50055.0 2022-09-09 San Francisco 75 Bay Area 11.428571428571429 0.0 11.428571428571429 69.57142857142857 0.7099125364431487 0.1642710472279261
35 35 California Pacific Medical Center- Van Ness Campus 50047.0 2022-09-09 San Francisco 75 Bay Area 12.857142857142858 0.5714285714285714 13.428571428571429 226.8571428571429 0.7462406015037594 0.0591939546599496
36 36 California Pacific Medical Ctr-davies Campus Hosp 50008.0 2022-09-09 San Francisco 75 Bay Area 4.142857142857143 0.0 4.142857142857143 71.71428571428571 0.7470238095238094 0.0577689243027888
37 37 Casa Colina Hospital 50782.0 2022-09-09 Los Angeles 37 Southern California 3.142857142857143 0.0 3.142857142857143 72.14285714285714 0.7043235704323569 0.0435643564356435
38 38 Catalina Island Medical Center 51307.0 2022-09-09 Los Angeles 37 Southern California 0.0 0.0 0.0 5.428571428571429 0.4523809523809524 0.0
39 39 Cedars-Sinai Marina Del Rey Hospital 50740.0 2022-09-09 Los Angeles 37 Southern California 7.571428571428571 0.0 7.571428571428571 62.0 0.6813186813186813 0.1221198156682027
40 40 Cedars-Sinai Medical Center 50625.0 2022-09-09 Los Angeles 37 Southern California 28.571428571428573 0.0 28.571428571428573 822.5714285714286 0.9478189300411524 0.0347342827370614
41 41 Centinela Hospital Medical Center 50739.0 2022-09-09 Los Angeles 37 Southern California 6.857142857142857 0.0 6.857142857142857 191.28571428571428 0.6602564102564102 0.0358476474981329
42 42 Chapman Global Medical Center 50745.0 2022-09-09 Orange 59 Southern California 1.1428571428571428 0.0 1.1428571428571428 57.285714285714285 0.5025062656641603 0.0199501246882793
43 43 Children's Hosp of Los Angeles 53302.0 2022-09-09 Los Angeles 37 Southern California 0.0 17.142857142857142 17.142857142857142 328.1428571428572 0.8262589928057554 0.0522420548541575
44 44 Children's Hospital at Mission 53306.0 2022-09-09 Orange 59 Southern California 0.0 0.7142857142857143 0.7142857142857143 34.714285714285715 0.5883777239709443 0.0205761316872428
45 45 Children's Hospital of Orange County 53304.0 2022-09-09 Orange 59 Southern California 0.0 8.428571428571429 8.428571428571429 256.2857142857143 0.7239709443099274 0.0328874024526198
46 46 Chinese Hospital 50407.0 2022-09-09 San Francisco 75 Bay Area 2.4285714285714284 0.0 2.4285714285714284 40.142857142857146 0.4363354037267081 0.0604982206405693
47 47 Chino Valley Medical Center 50586.0 2022-09-09 San Bernardino 71 Southern California 0.7142857142857143 0.0 0.7142857142857143 48.0 0.9572649572649572 0.0148809523809523
48 48 Clovis Community Medical Center 50492.0 2022-09-09 Fresno 19 San Joaquin Valley 43.85714285714285 0.0 43.85714285714285 269.42857142857144 0.9989406779661018 0.1627783669141039
49 49 Coast Plaza Hospital 50771.0 2022-09-09 Los Angeles 37 Southern California 2.4285714285714284 0.0 2.4285714285714284 30.714285714285715 0.6825396825396826 0.0790697674418604
50 50 College Hospital Costa Mesa 50543.0 2022-09-09 Orange 59 Southern California 1.1428571428571428 0.0 1.1428571428571428 103.42857142857144 0.8080357142857143 0.011049723756906
51 51 College Medical Center 50776.0 2022-09-09 Los Angeles 37 Southern California 1.8571428571428568 0.0 1.8571428571428568 174.85714285714286 0.7669172932330828 0.0106209150326797
52 52 Colorado River Medical Center 51323.0 2022-09-09 San Bernardino 71 Southern California 0.0 0.0 0.0 1.5714285714285714 0.0628571428571428 0.0
53 53 Colusa Medical Center 50783.0 2022-09-09 Colusa 11 Greater Sacramento 1.4285714285714286 0.0 1.4285714285714286 20.285714285714285 0.4226190476190476 0.0704225352112676
54 54 Community Hospital of Huntington Park 50091.0 2022-09-09 Los Angeles 37 Southern California 1.1428571428571428 0.0 1.1428571428571428 39.142857142857146 0.4832451499118166 0.0291970802919708
55 55 Community Hospital of San Bernardino 50089.0 2022-09-09 San Bernardino 71 Southern California 10.571428571428571 0.0 10.571428571428571 132.14285714285714 0.4949170679507758 0.08
56 56 Community Hospital of the Monterey Peninsula 50145.0 2022-09-09 Monterey 53 Bay Area 9.0 0.0 9.0 181.0 0.6284722222222222 0.0497237569060773
57 57 Community Memorial Hospital San Buenaventura 50394.0 2022-09-09 Ventura 111 Southern California 7.571428571428571 0.0 7.571428571428571 142.14285714285714 0.7797805642633229 0.0532663316582914
58 58 Community Regional Medical Center 50060.0 2022-09-09 Fresno 19 San Joaquin Valley 65.71428571428571 1.1428571428571428 66.85714285714285 663.8571428571429 0.9247761194029852 0.1007101355713363
59 59 Contra Costa Regional Medical Center 50276.0 2022-09-09 Contra Costa 13 Bay Area 5.0 0.0 5.0 122.0 0.7305389221556886 0.040983606557377
60 60 Corona Regional Medical Center 50329.0 2022-09-09 Riverside 65 Southern California 5.428571428571429 0.0 5.428571428571429 123.0 0.6488319517709118 0.0441347270615563
61 61 Dameron Hospital 50122.0 2022-09-09 San Joaquin 77 San Joaquin Valley 1.4285714285714286 0.0 1.4285714285714286 39.142857142857146 0.4120300751879699 0.0364963503649635
62 62 Desert Valley Hospital 50709.0 2022-09-09 San Bernardino 71 Southern California 5.857142857142857 0.0 5.857142857142857 101.57142857142856 0.7131394182547643 0.0576652601969057
63 63 Docs Surgical Hospital 50785.0 2022-09-09 Los Angeles 37 Southern California 0.0 0.0 0.0 3.2857142857142856 0.4693877551020408 0.0
64 64 Doctors Hospital of Riverside, LLC 50102.0 2022-09-09 Riverside 65 Southern California 1.5714285714285714 0.0 1.5714285714285714 93.42857142857144 0.4837278106508876 0.0168195718654434
65 65 Dominican Hospital 50242.0 2022-09-09 Santa Cruz 87 Bay Area 9.857142857142858 0.0 9.857142857142858 159.42857142857142 0.8617760617760617 0.0618279569892473
66 66 East Los Angeles Doctors Hospital 50641.0 2022-09-09 Los Angeles 37 Southern California 0.7142857142857143 0.0 0.7142857142857143 29.428571428571427 0.3872180451127819 0.0242718446601941
67 67 Eastern Plumas Hospital - Portola Campus 51300.0 2022-09-09 Plumas 63 Greater Sacramento 0.0 0.0 0.0 1.1428571428571428 0.1269841269841269 0.0
68 68 Eden Medical Center 50488.0 2022-09-09 Alameda 1 Bay Area 14.0 0.0 14.0 139.14285714285714 0.8528896672504378 0.1006160164271047
69 69 Eisenhower Medical Center 50573.0 2022-09-09 Riverside 65 Southern California 8.428571428571429 0.0 8.428571428571429 209.7142857142857 0.6879100281162137 0.0401907356948228
70 70 El Camino Hospital 50308.0 2022-09-09 Santa Clara 85 Bay Area 27.285714285714285 0.0 27.285714285714285 256.85714285714283 0.5720649061406299 0.1062291434927697
71 71 El Centro Regional Medical Center 50045.0 2022-09-09 Imperial 25 Southern California 9.142857142857142 0.0 9.142857142857142 64.42857142857143 0.7417763157894737 0.1419068736141907
72 72 Emanate Health Foothill Presbyterian Hospital 50597.0 2022-09-09 Los Angeles 37 Southern California 7.571428571428571 0.0 7.571428571428571 75.28571428571429 0.7309292649098474 0.1005692599620493
73 73 Emanate Health Inter-community Hospital 50382.0 2022-09-09 Los Angeles 37 Southern California 13.857142857142858 0.0 13.857142857142858 277.1428571428572 0.5544441268933982 0.0499999999999999
74 74 Encino Hospital Medical Center 50158.0 2022-09-09 Los Angeles 37 Southern California 0.0 0.0 0.0 64.14285714285714 0.9393305439330544 0.0
75 75 Enloe Medical Center 50039.0 2022-09-09 Butte 7 Greater Sacramento 7.0 0.0 7.0 240.42857142857144 0.8697674418604651 0.0291146761734997
76 76 Fairchild Medical Center 51316.0 2022-09-09 Siskiyou 93 Northern California 1.5714285714285714 0.0 1.5714285714285714 15.142857142857142 0.6057142857142856 0.1037735849056603
77 77 Foothill Regional Medical Center 50780.0 2022-09-09 Orange 59 Southern California 2.2857142857142856 0.0 2.2857142857142856 41.142857142857146 0.3164835164835165 0.0555555555555555
78 78 French Hospital Medical Center 50232.0 2022-09-09 San Luis Obispo 79 Southern California 3.857142857142857 0.0 3.857142857142857 50.142857142857146 0.6416819012797076 0.0769230769230769
79 79 Fresno Heart and Surgical Hospital 50732.0 2022-09-09 Fresno 19 San Joaquin Valley 2.857142857142857 0.0 2.857142857142857 32.857142857142854 0.5764411027568922 0.0869565217391304
80 80 Fresno Surgical Hospital 50708.0 2022-09-09 Fresno 19 San Joaquin Valley 0.0 0.0 0.0 10.142857142857142 0.3532338308457711 0.0
81 81 Garden Grove Hospital & Medical Center 50230.0 2022-09-09 Orange 59 Southern California 5.0 0.0 5.0 42.0 0.7101449275362318 0.119047619047619
82 82 Garfield Medical Center 50737.0 2022-09-09 Los Angeles 37 Southern California 8.571428571428571 0.0 8.571428571428571 131.57142857142858 0.626530612244898 0.0651465798045602
83 83 George L Mee Memorial Hospital 51336.0 2022-09-09 Monterey 53 Bay Area 1.0 0.0 1.0 8.857142857142858 0.7380952380952381 0.1129032258064516
84 84 Glendale Adventist Medical Center 50239.0 2022-09-09 Los Angeles 37 Southern California 14.0 0.0 14.0 224.57142857142856 0.9214536928487692 0.0623409669211195
85 85 Glendale Mem Hospital & Health Center 50058.0 2022-09-09 Los Angeles 37 Southern California 8.857142857142858 0.0 8.857142857142858 158.42857142857142 0.5719443011861784 0.0559062218214607
86 86 Glenn Medical Center 51306.0 2022-09-09 Glenn 21 Northern California 1.1428571428571428 0.0 1.1428571428571428 20.142857142857142 0.8294117647058824 0.0567375886524822
87 87 Goleta Valley Cottage Hospital 50357.0 2022-09-09 Santa Barbara 83 Southern California 0.0 0.0 0.0 10.857142857142858 0.5428571428571429 0.0
88 88 Good Samaritan Hospital 50257.0 2022-09-09 Kern 29 San Joaquin Valley 0.0 0.0 0.0 19.428571428571427 0.4981684981684981 0.0
89 89 Good Samaritan Hospital 50380.0 2022-09-09 Santa Clara 85 Bay Area 12.142857142857142 0.0 12.142857142857142 217.8571428571429 0.4951298701298701 0.0557377049180327
90 90 Greater El Monte Community Hospital 50738.0 2022-09-09 Los Angeles 37 Southern California 3.4285714285714284 0.0 3.4285714285714284 41.85714285714285 0.3891102257636122 0.0819112627986348
91 91 Grossmont Hospital 50026.0 2022-09-09 San Diego 73 Southern California 30.0 0.0 30.0 393.57142857142856 0.7717086834733893 0.0762250453720508
92 92 Healdsburg Hospital 51321.0 2022-09-09 Sonoma 97 Bay Area 0.0 3.142857142857143 3.142857142857143 12.0 0.7058823529411765 0.2619047619047619
93 93 Healthbridge Children's Hospital - Orange 53308.0 2022-09-09 Orange 59 Southern California 0.0 0.0 0.0 22.0 5.703703703703703 0.0
94 94 Hemet Global Medical Center 50390.0 2022-09-09 Riverside 65 Southern California 4.571428571428571   4.571428571428571 82.28571428571429 0.8807339449541285 0.0555555555555555
95 95 Henry Mayo Newhall Hospital 50624.0 2022-09-09 Los Angeles 37 Southern California 2.4285714285714284 0.0 2.4285714285714284 172.42857142857142 0.4924520603835168 0.0140845070422535
96 96 Highland Hospital 50320.0 2022-09-09 Alameda 1 Bay Area 5.714285714285714 0.0 5.714285714285714 184.42857142857144 0.4269179894179893 0.0309837335398915
97 97 Hoag Memorial Hospital Presbyterian 50224.0 2022-09-09 Orange 59 Southern California 16.285714285714285 0.0 16.285714285714285 409.57142857142856 0.9390763183753684 0.0397628182769445
98 98 Hoag Orthopedic Institute 50769.0 2022-09-09 Orange 59 Southern California 0.0 0.0 0.0 17.285714285714285 0.4938775510204081 0.0
99 99 Hollywood Presbyterian Medical Center 50063.0 2022-09-09 Los Angeles 37 Southern California 7.571428571428571 0.0 7.571428571428571 195.42857142857144 0.8211284513805521 0.0387426900584795
100 100 Huntington Beach Hospital 50526.0 2022-09-09 Orange 59 Southern California 1.0 0.0 1.0 51.285714285714285 0.7386831275720164 0.0194986072423398

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "hhs-hospital-patient-totals" (
   [hospital] TEXT,
   [ccn] FLOAT,
   [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
);