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 occupied_beds_percent
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: week (date)
region 6 ✖
- Southern California 26,252
- Bay Area 9,408
- San Joaquin Valley 5,788
- Greater Sacramento 4,054
- Northern California 3,130
- - 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41 | 41 | Colorado River Medical Center | 051323 | 2022-12-23 | San Bernardino | 71 | Southern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
138 | 138 | Laguna Honda Hospital & Rehabilitation Center | 050668 | 2022-12-23 | San Francisco | 75 | Bay Area | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
166 | 166 | Northern Inyo Hospital | 051324 | 2022-12-23 | Inyo | 27 | Southern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
174 | 174 | Palo Verde Hospital | 50423.0 | 2022-12-23 | Riverside | 65 | Southern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
176 | 176 | Patients' Hospital of Redding | 50697.0 | 2022-12-23 | Shasta | 89 | Northern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
184 | 184 | Porterville Developmental Center | 050546 | 2022-12-23 | Tulare | 107 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
212 | 212 | Santa Ynez Valley Cottage Hospital | 051331 | 2022-12-23 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
218 | 218 | Seneca District Hospital | 51327.0 | 2022-12-23 | Plumas | 63 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
234 | 234 | Surprise Valley Community Hospital | 051308 | 2022-12-23 | Modoc | 49 | Northern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
246 | 246 | Sutter Surgical Hospital - North Valley | 050766 | 2022-12-23 | Sutter | 101 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
267 | 267 | West Covina Medical Center, Inc | 50096.0 | 2022-12-23 | Los Angeles | 37 | Southern California | 7.0 | 0.0 | 7.0 | 0.0 | 0.0 | inf |
456 | 456 | Patients' Hospital of Redding | 050697 | 2022-12-16 | Shasta | 89 | Northern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
465 | 465 | Porterville Developmental Center | 50546.0 | 2022-12-16 | Tulare | 107 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
515 | 515 | Southern Inyo Hospital | 51302.0 | 2022-12-16 | Inyo | 27 | Southern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
522 | 522 | Surprise Valley Community Hospital | 051308 | 2022-12-16 | Modoc | 49 | Northern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
534 | 534 | Sutter Surgical Hospital - North Valley | 50766.0 | 2022-12-16 | Sutter | 101 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
758 | 758 | Patients' Hospital of Redding | 50697.0 | 2022-12-09 | Shasta | 89 | Northern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
767 | 767 | Porterville Developmental Center | 50546.0 | 2022-12-09 | Tulare | 107 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
817 | 817 | Southern Inyo Hospital | 51302.0 | 2022-12-09 | Inyo | 27 | Southern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
824 | 824 | Surprise Valley Community Hospital | 51308.0 | 2022-12-09 | Modoc | 49 | Northern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
836 | 836 | Sutter Surgical Hospital - North Valley | 50766.0 | 2022-12-09 | Sutter | 101 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
931 | 931 | Eastern Plumas Hospital - Portola Campus | 51300.0 | 2022-12-02 | Plumas | 63 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
1074 | 1074 | Palo Verde Hospital | 50423.0 | 2022-12-02 | Riverside | 65 | Southern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
1078 | 1078 | Patients' Hospital of Redding | 50697.0 | 2022-12-02 | Shasta | 89 | Northern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
1087 | 1087 | Porterville Developmental Center | 50546.0 | 2022-12-02 | Tulare | 107 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
1140 | 1140 | Southern Inyo Hospital | 051302 | 2022-12-02 | Inyo | 27 | Southern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
1165 | 1165 | Sutter Surgical Hospital - North Valley | 050766 | 2022-12-02 | Sutter | 101 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
1405 | 1405 | Patients' Hospital of Redding | 050697 | 2022-11-25 | Shasta | 89 | Northern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
1414 | 1414 | Porterville Developmental Center | 50546.0 | 2022-11-25 | Tulare | 107 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
1466 | 1466 | Southern Inyo Hospital | 051302 | 2022-11-25 | Inyo | 27 | Southern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
1491 | 1491 | Sutter Surgical Hospital - North Valley | 50766.0 | 2022-11-25 | Sutter | 101 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
1733 | 1733 | Patients' Hospital of Redding | 50697.0 | 2022-11-18 | Shasta | 89 | Northern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
1742 | 1742 | Porterville Developmental Center | 050546 | 2022-11-18 | Tulare | 107 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
1796 | 1796 | Southern Inyo Hospital | 051302 | 2022-11-18 | Inyo | 27 | Southern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
1821 | 1821 | Sutter Surgical Hospital - North Valley | 050766 | 2022-11-18 | Sutter | 101 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
2061 | 2061 | Patients' Hospital of Redding | 50697.0 | 2022-11-11 | Shasta | 89 | Northern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
2070 | 2070 | Porterville Developmental Center | 050546 | 2022-11-11 | Tulare | 107 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
2104 | 2104 | Santa Ynez Valley Cottage Hospital | 51331.0 | 2022-11-11 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
2124 | 2124 | Southern Inyo Hospital | 051302 | 2022-11-11 | Inyo | 27 | Southern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
2149 | 2149 | Sutter Surgical Hospital - North Valley | 050766 | 2022-11-11 | Sutter | 101 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
2393 | 2393 | Patients' Hospital of Redding | 50697.0 | 2022-11-04 | Shasta | 89 | Northern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
2401 | 2401 | Porterville Developmental Center | 50546.0 | 2022-11-04 | Tulare | 107 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
2455 | 2455 | Southern Inyo Hospital | 51302.0 | 2022-11-04 | Inyo | 27 | Southern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
2481 | 2481 | Sutter Surgical Hospital - North Valley | 050766 | 2022-11-04 | Sutter | 101 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
2730 | 2730 | Patients' Hospital of Redding | 50697.0 | 2022-10-28 | Shasta | 89 | Northern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
2738 | 2738 | Porterville Developmental Center | 50546.0 | 2022-10-28 | Tulare | 107 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
2772 | 2772 | Santa Ynez Valley Cottage Hospital | 51331.0 | 2022-10-28 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
2792 | 2792 | Southern Inyo Hospital | 51302.0 | 2022-10-28 | Inyo | 27 | Southern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
2818 | 2818 | Sutter Surgical Hospital - North Valley | 050766 | 2022-10-28 | Sutter | 101 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
3063 | 3063 | Patients' Hospital of Redding | 50697.0 | 2022-10-21 | Shasta | 89 | Northern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
3071 | 3071 | Porterville Developmental Center | 050546 | 2022-10-21 | Tulare | 107 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
3105 | 3105 | Santa Ynez Valley Cottage Hospital | 51331.0 | 2022-10-21 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
3125 | 3125 | Southern Inyo Hospital | 051302 | 2022-10-21 | Inyo | 27 | Southern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
3151 | 3151 | Sutter Surgical Hospital - North Valley | 050766 | 2022-10-21 | Sutter | 101 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
3395 | 3395 | Patients' Hospital of Redding | 50697.0 | 2022-10-14 | Shasta | 89 | Northern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
3403 | 3403 | Porterville Developmental Center | 050546 | 2022-10-14 | Tulare | 107 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
3457 | 3457 | Southern Inyo Hospital | 51302.0 | 2022-10-14 | Inyo | 27 | Southern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
3483 | 3483 | Sutter Surgical Hospital - North Valley | 050766 | 2022-10-14 | Sutter | 101 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
3728 | 3728 | Patients' Hospital of Redding | 50697.0 | 2022-10-07 | Shasta | 89 | Northern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
3736 | 3736 | Porterville Developmental Center | 050546 | 2022-10-07 | Tulare | 107 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
3790 | 3790 | Southern Inyo Hospital | 051302 | 2022-10-07 | Inyo | 27 | Southern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
3816 | 3816 | Sutter Surgical Hospital - North Valley | 50766.0 | 2022-10-07 | Sutter | 101 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
4058 | 4058 | Patients' Hospital of Redding | 050697 | 2022-09-30 | Shasta | 89 | Northern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
4066 | 4066 | Porterville Developmental Center | 50546.0 | 2022-09-30 | Tulare | 107 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
4120 | 4120 | Southern Inyo Hospital | 051302 | 2022-09-30 | Inyo | 27 | Southern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
4146 | 4146 | Sutter Surgical Hospital - North Valley | 050766 | 2022-09-30 | Sutter | 101 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
4390 | 4390 | Patients' Hospital of Redding | 050697 | 2022-09-23 | Shasta | 89 | Northern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
4398 | 4398 | Porterville Developmental Center | 050546 | 2022-09-23 | Tulare | 107 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
4452 | 4452 | Southern Inyo Hospital | 51302.0 | 2022-09-23 | Inyo | 27 | Southern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
4478 | 4478 | Sutter Surgical Hospital - North Valley | 050766 | 2022-09-23 | Sutter | 101 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
4722 | 4722 | Patients' Hospital of Redding | 050697 | 2022-09-16 | Shasta | 89 | Northern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
4730 | 4730 | Porterville Developmental Center | 50546.0 | 2022-09-16 | Tulare | 107 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
4784 | 4784 | Southern Inyo Hospital | 51302.0 | 2022-09-16 | Inyo | 27 | Southern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
4810 | 4810 | Sutter Surgical Hospital - North Valley | 50766.0 | 2022-09-16 | Sutter | 101 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
5052 | 5052 | Patients' Hospital of Redding | 50697.0 | 2022-09-09 | Shasta | 89 | Northern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
5060 | 5060 | Porterville Developmental Center | 050546 | 2022-09-09 | Tulare | 107 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
5094 | 5094 | Santa Ynez Valley Cottage Hospital | 51331.0 | 2022-09-09 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
5114 | 5114 | Southern Inyo Hospital | 051302 | 2022-09-09 | Inyo | 27 | Southern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
5140 | 5140 | Sutter Surgical Hospital - North Valley | 50766.0 | 2022-09-09 | Sutter | 101 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
5380 | 5380 | Patients' Hospital of Redding | 050697 | 2022-09-02 | Shasta | 89 | Northern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
5388 | 5388 | Porterville Developmental Center | 50546.0 | 2022-09-02 | Tulare | 107 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
5442 | 5442 | Southern Inyo Hospital | 51302.0 | 2022-09-02 | Inyo | 27 | Southern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
5468 | 5468 | Sutter Surgical Hospital - North Valley | 050766 | 2022-09-02 | Sutter | 101 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
5708 | 5708 | Patients' Hospital of Redding | 050697 | 2022-08-26 | Shasta | 89 | Northern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
5716 | 5716 | Porterville Developmental Center | 050546 | 2022-08-26 | Tulare | 107 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
5750 | 5750 | Santa Ynez Valley Cottage Hospital | 051331 | 2022-08-26 | Santa Barbara | 83 | Southern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
5770 | 5770 | Southern Inyo Hospital | 051302 | 2022-08-26 | Inyo | 27 | Southern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
5796 | 5796 | Sutter Surgical Hospital - North Valley | 50766.0 | 2022-08-26 | Sutter | 101 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
6036 | 6036 | Patients' Hospital of Redding | 50697.0 | 2022-08-19 | Shasta | 89 | Northern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
6044 | 6044 | Porterville Developmental Center | 50546.0 | 2022-08-19 | Tulare | 107 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
6098 | 6098 | Southern Inyo Hospital | 51302.0 | 2022-08-19 | Inyo | 27 | Southern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
6124 | 6124 | Sutter Surgical Hospital - North Valley | 50766.0 | 2022-08-19 | Sutter | 101 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
6357 | 6357 | Olympia Medical Center | 050742 | 2022-08-12 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
6367 | 6367 | Patients' Hospital of Redding | 50697.0 | 2022-08-12 | Shasta | 89 | Northern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
6375 | 6375 | Porterville Developmental Center | 050546 | 2022-08-12 | Tulare | 107 | San Joaquin Valley | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
6428 | 6428 | Southern Inyo Hospital | 051302 | 2022-08-12 | Inyo | 27 | Southern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
6454 | 6454 | Sutter Surgical Hospital - North Valley | 050766 | 2022-08-12 | Sutter | 101 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
6585 | 6585 | Jerold Phelps Community Hospital | 51309.0 | 2022-08-05 | Humboldt | 23 | Northern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
6688 | 6688 | Olympia Medical Center | 50742.0 | 2022-08-05 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
6698 | 6698 | Patients' Hospital of Redding | 50697.0 | 2022-08-05 | Shasta | 89 | Northern California | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
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 );