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.
29 rows where region = "Greater Sacramento" and "week" is on date 2021-03-26
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: county, pediatric_covid_patients_total, covid_patients_total, occupied_beds_percent, patients_with_covid_percent
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30869 | 30869 | Adventist Health and Rideout | 50133.0 | 2021-03-26 | Yuba | 115 | Greater Sacramento | 4.857142857142857 | 0.0 | 4.857142857142857 | 186.57142857142856 | 0.6932059447983014 | 0.0260336906584992 |
30885 | 30885 | Barton Memorial Hospital | 050352 | 2021-03-26 | El Dorado | 17 | Greater Sacramento | 1.4285714285714286 | 0.0 | 1.4285714285714286 | 21.714285714285715 | 0.2783882783882784 | 0.0657894736842105 |
30910 | 30910 | Colusa Medical Center | 50783.0 | 2021-03-26 | Colusa | 11 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 20.428571428571427 | 0.3513513513513513 | 0.0 |
30927 | 30927 | Eastern Plumas Hospital - Portola Campus | 51300.0 | 2021-03-26 | Plumas | 63 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 4.142857142857143 | 0.4603174603174603 | 0.0 |
30936 | 30936 | Enloe Medical Center | 050039 | 2021-03-26 | Butte | 7 | Greater Sacramento | 6.714285714285714 | 0.0 | 6.714285714285714 | 231.28571428571428 | 0.9054809843400448 | 0.0290302655960469 |
30971 | 30971 | Kaiser Foundation Hosp So Sacramento | 50674.0 | 2021-03-26 | Sacramento | 67 | Greater Sacramento | 28.285714285714285 | 0.0 | 28.285714285714285 | 198.57142857142856 | 0.912672357189757 | 0.1424460431654676 |
30983 | 30983 | Kaiser Foundation Hospital - Roseville | 050772 | 2021-03-26 | Placer | 61 | Greater Sacramento | 30.285714285714285 | 2.571428571428572 | 32.857142857142854 | 317.85714285714283 | 0.976305397103993 | 0.1033707865168539 |
30984 | 30984 | Kaiser Foundation Hospital - Sacramento | 50425.0 | 2021-03-26 | Sacramento | 67 | Greater Sacramento | 15.142857142857142 | 0.0 | 15.142857142857142 | 165.57142857142858 | 0.908307210031348 | 0.0914581535806729 |
31043 | 31043 | Marshall Medical Center | 050254 | 2021-03-26 | El Dorado | 17 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 58.85714285714285 | 0.5302445302445302 | 0.0 |
31054 | 31054 | Mercy General Hospital | 050017 | 2021-03-26 | Sacramento | 67 | Greater Sacramento | 4.571428571428571 | 0.0 | 4.571428571428571 | 189.57142857142856 | 0.8495518565941101 | 0.0241145440844009 |
31056 | 31056 | Mercy Hospital of Folsom | 050414 | 2021-03-26 | Sacramento | 67 | Greater Sacramento | 1.2857142857142858 | 0.0 | 1.2857142857142858 | 75.57142857142857 | 0.7129380053908355 | 0.0170132325141776 |
31060 | 31060 | Mercy San Juan Medical Center | 050516 | 2021-03-26 | Sacramento | 67 | Greater Sacramento | 7.571428571428571 | 0.0 | 7.571428571428571 | 233.0 | 0.8525875588081547 | 0.032495401594114 |
31061 | 31061 | Methodist Hospital of Sacramento | 050590 | 2021-03-26 | Sacramento | 67 | Greater Sacramento | 5.857142857142857 | 0.0 | 5.857142857142857 | 98.57142857142856 | 0.478502080443828 | 0.0594202898550724 |
31078 | 31078 | Orchard Hospital | 051311 | 2021-03-26 | Butte | 7 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 8.714285714285714 | 0.3630952380952381 | 0.0 |
31079 | 31079 | Oroville Hospital | 50030.0 | 2021-03-26 | Butte | 7 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 113.28571428571428 | 0.6586378737541528 | 0.0 |
31093 | 31093 | Plumas District Hospital | 51326.0 | 2021-03-26 | Plumas | 63 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 7.571428571428571 | 0.4732142857142857 | 0.0 |
31137 | 31137 | Seneca District Hospital | 51327.0 | 2021-03-26 | Plumas | 63 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
31144 | 31144 | Shriners Hospitals For Children Northern Calif | 53311.0 | 2021-03-26 | Sacramento | 67 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 20.285714285714285 | 0.4507936507936507 | 0.0 |
31145 | 31145 | Sierra Nevada Memorial Hospital | 50150.0 | 2021-03-26 | Nevada | 57 | Greater Sacramento | 3.2857142857142856 | 0.0 | 3.2857142857142856 | 53.71428571428572 | 0.5157750342935529 | 0.0611702127659574 |
31166 | 31166 | Sutter Amador Hospital | 50014.0 | 2021-03-26 | Amador | 5 | Greater Sacramento | 3.142857142857143 | 0.0 | 3.142857142857143 | 24.0 | 0.4615384615384615 | 0.1309523809523809 |
31167 | 31167 | Sutter Auburn Faith Hospital | 050498 | 2021-03-26 | Placer | 61 | Greater Sacramento | 0.8571428571428571 | 0.0 | 0.8571428571428571 | 39.0 | 0.6080178173719377 | 0.0219780219780219 |
31169 | 31169 | Sutter Davis Hospital | 50537.0 | 2021-03-26 | Yolo | 113 | Greater Sacramento | 1.7142857142857142 | 0.0 | 1.7142857142857142 | 31.857142857142858 | 0.5688775510204082 | 0.0538116591928251 |
31173 | 31173 | Sutter Medical Center, Sacramento | 50108.0 | 2021-03-26 | Sacramento | 67 | Greater Sacramento | 16.714285714285715 | 0.0 | 16.714285714285715 | 351.0 | 0.6416819012797075 | 0.0476190476190476 |
31174 | 31174 | Sutter Roseville Medical Center | 50309.0 | 2021-03-26 | Placer | 61 | Greater Sacramento | 5.428571428571429 | 0.0 | 5.428571428571429 | 330.2857142857143 | 0.8184070796460177 | 0.0164359861591695 |
31177 | 31177 | Sutter Surgical Hospital - North Valley | 50766.0 | 2021-03-26 | Sutter | 101 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
31179 | 31179 | Tahoe Forest Hospital | 51328.0 | 2021-03-26 | Nevada | 57 | Greater Sacramento | 0.8571428571428571 | 0.0 | 0.8571428571428571 | 16.714285714285715 | 0.6685714285714286 | 0.0512820512820512 |
31192 | 31192 | University of California Davis Medical Center | 050599 | 2021-03-26 | Sacramento | 67 | Greater Sacramento | 17.857142857142858 | 2.2857142857142856 | 20.142857142857142 | 571.0 | 0.9273781902552204 | 0.0352764573430072 |
31198 | 31198 | Vibra Hospital of Sacramento | 052033 | 2021-03-26 | Sacramento | 67 | Greater Sacramento | 0.0 | 0.0 | 0.0 | 50.85714285714285 | 0.876847290640394 | 0.0 |
31207 | 31207 | Woodland Memorial Hospital | 50127.0 | 2021-03-26 | Yolo | 113 | Greater Sacramento | 2.2857142857142856 | 0.0 | 2.2857142857142856 | 62.66666666666666 | 0.9423558897243108 | 0.0364741641337386 |
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 );