la_times_cdph_adult_and_senior_care_facilities
Data license: Reusing the data · Data source: California Department of Public Health via The Los Angeles Times · About: Data dictionary for la_times_cdph_adult_and_senior_care_facilities
5,390 rows where county = "Sacramento" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: staff_deaths, patients_confirmed_cases_note, date (date)
Link | rowid | date ▼ | name | county | staff_confirmed_cases | patients_confirmed_cases | staff_deaths | patients_deaths | fips | staff_confirmed_cases_note | patients_confirmed_cases_note | staff_deaths_note | patients_deaths_note |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
116605 | 116605 | 2020-04-19 | SUNRISE ASSISTED LIVING OF FAIR OAKS | Sacramento | 16 | 1 | 67 | <11 | |||||
116606 | 116606 | 2020-04-19 | SUNRISE ASSISTED LIVING OF SACRAMENTO | Sacramento | 25 | 23 | 67 | ||||||
116580 | 116580 | 2020-04-26 | Oakmont of Folsom | Sacramento | 1 | 17 | 67 | <11 | |||||
116581 | 116581 | 2020-04-26 | Sunrise Assisted Living of Fair Oaks | Sacramento | 1 | 17 | 67 | <11 | |||||
116582 | 116582 | 2020-04-26 | Sunrise Assisted Living of Sacramento | Sacramento | 23 | 25 | 67 | ||||||
116548 | 116548 | 2020-04-27 | Oakmont of Folsom | Sacramento | 1 | 17 | 67 | <11 | |||||
116549 | 116549 | 2020-04-27 | Sunrise Assisted Living of Fair Oaks | Sacramento | 1 | 17 | 67 | <11 | |||||
116550 | 116550 | 2020-04-27 | Sunrise Assisted Living of Sacramento | Sacramento | 23 | 25 | 67 | ||||||
116516 | 116516 | 2020-04-28 | Oakmont of Folsom | Sacramento | 1 | 18 | 67 | <11 | |||||
116517 | 116517 | 2020-04-28 | Sunrise Assisted Living of Fair Oaks | Sacramento | 1 | 17 | 67 | <11 | |||||
116518 | 116518 | 2020-04-28 | Sunrise Assisted Living of Sacramento | Sacramento | 23 | 25 | 67 | ||||||
116483 | 116483 | 2020-04-30 | Oakmont of Folsom | Sacramento | 1 | 18 | 67 | <11 | |||||
116484 | 116484 | 2020-04-30 | Sunrise Assisted Living of Fair Oaks | Sacramento | 1 | 17 | 67 | <11 | |||||
116485 | 116485 | 2020-04-30 | Sunrise Assisted Living of Sacramento | Sacramento | 23 | 25 | 67 | ||||||
116450 | 116450 | 2020-05-01 | Oakmont of Folsom | Sacramento | 1 | 18 | 67 | <11 | |||||
116451 | 116451 | 2020-05-01 | Sunrise Assisted Living of Fair Oaks | Sacramento | 1 | 17 | 67 | <11 | |||||
116452 | 116452 | 2020-05-01 | Sunrise Assisted Living of Sacramento | Sacramento | 23 | 25 | 67 | ||||||
116414 | 116414 | 2020-05-02 | Oakmont of Folsom | Sacramento | 1 | 18 | 67 | <11 | |||||
116415 | 116415 | 2020-05-02 | Sunrise Assisted Living of Fair Oaks | Sacramento | 1 | 17 | 67 | <11 | |||||
116416 | 116416 | 2020-05-02 | Sunrise Assisted Living of Sacramento | Sacramento | 23 | 25 | 67 | ||||||
116377 | 116377 | 2020-05-04 | Oakmont of Folsom | Sacramento | 1 | 18 | 67 | <11 | |||||
116378 | 116378 | 2020-05-04 | Sunrise Assisted Living of Fair Oaks | Sacramento | 1 | 17 | 67 | <11 | |||||
116379 | 116379 | 2020-05-04 | Sunrise Assisted Living of Sacramento | Sacramento | 23 | 25 | 67 | ||||||
116340 | 116340 | 2020-05-05 | Oakmont of Folsom | Sacramento | 1 | 19 | 67 | <11 | |||||
116341 | 116341 | 2020-05-05 | Sunrise Assisted Living of Fair Oaks | Sacramento | 1 | 17 | 67 | <11 | |||||
116342 | 116342 | 2020-05-05 | Sunrise Assisted Living of Sacramento | Sacramento | 23 | 25 | 67 | ||||||
116301 | 116301 | 2020-05-06 | Oakmont of Folsom | Sacramento | 1 | 19 | 67 | <11 | |||||
116302 | 116302 | 2020-05-06 | Sunrise Assisted Living of Fair Oaks | Sacramento | 1 | 17 | 67 | <11 | |||||
116303 | 116303 | 2020-05-06 | Sunrise Assisted Living of Sacramento | Sacramento | 23 | 25 | 67 | ||||||
116249 | 116249 | 2020-05-07 | Carlton Plaza of Elk Grove | Sacramento | 0 | 1 | 67 | <11 | |||||
116250 | 116250 | 2020-05-07 | Eskaton Gold River | Sacramento | 0 | 1 | 67 | <11 | |||||
116251 | 116251 | 2020-05-07 | Oakmont of Folsom | Sacramento | 1 | 19 | 67 | <11 | |||||
116252 | 116252 | 2020-05-07 | Summerset Senior Living | Sacramento | 0 | 1 | 67 | <11 | |||||
116253 | 116253 | 2020-05-07 | Sunrise Assisted Living of Fair Oaks | Sacramento | 1 | 17 | 67 | <11 | |||||
116254 | 116254 | 2020-05-07 | Sunrise Assisted Living of Sacramento | Sacramento | 23 | 25 | 67 | ||||||
116184 | 116184 | 2020-05-08 | Carlton Plaza of Elk Grove | Sacramento | 0 | 1 | 0 | 1 | 67 | <11 | <11 | ||
116185 | 116185 | 2020-05-08 | Eskaton Gold River | Sacramento | 0 | 1 | 0 | 1 | 67 | <11 | <11 | ||
116186 | 116186 | 2020-05-08 | Oakmont of Folsom | Sacramento | 1 | 19 | 0 | 1 | 67 | <11 | <11 | ||
116187 | 116187 | 2020-05-08 | Summerset Senior Living | Sacramento | 0 | 1 | 0 | 1 | 67 | <11 | <11 | ||
116188 | 116188 | 2020-05-08 | Sunrise Assisted Living of Fair Oaks | Sacramento | 1 | 17 | 0 | 1 | 67 | <11 | <11 | ||
116189 | 116189 | 2020-05-08 | Sunrise Assisted Living of Sacramento | Sacramento | 23 | 25 | 0 | 1 | 67 | <11 | |||
116119 | 116119 | 2020-05-09 | Carlton Plaza of Elk Grove | Sacramento | 0 | 1 | 0 | 1 | 67 | <11 | <11 | ||
116120 | 116120 | 2020-05-09 | Eskaton Gold River | Sacramento | 0 | 1 | 0 | 1 | 67 | <11 | <11 | ||
116121 | 116121 | 2020-05-09 | Oakmont of Folsom | Sacramento | 1 | 20 | 0 | 1 | 67 | <11 | <11 | ||
116122 | 116122 | 2020-05-09 | Summerset Senior Living | Sacramento | 0 | 1 | 0 | 1 | 67 | <11 | <11 | ||
116123 | 116123 | 2020-05-09 | Sunrise Assisted Living of Fair Oaks | Sacramento | 1 | 17 | 0 | 1 | 67 | <11 | <11 | ||
116124 | 116124 | 2020-05-09 | Sunrise Assisted Living of Sacramento | Sacramento | 25 | 25 | 0 | 1 | 67 | <11 | |||
116054 | 116054 | 2020-05-10 | Carlton Plaza of Elk Grove | Sacramento | 0 | 1 | 0 | 1 | 67 | <11 | <11 | ||
116055 | 116055 | 2020-05-10 | Eskaton Gold River | Sacramento | 0 | 1 | 0 | 1 | 67 | <11 | <11 | ||
116056 | 116056 | 2020-05-10 | Oakmont of Folsom | Sacramento | 1 | 20 | 0 | 1 | 67 | <11 | <11 | ||
116057 | 116057 | 2020-05-10 | Summerset Senior Living | Sacramento | 0 | 1 | 0 | 1 | 67 | <11 | <11 | ||
116058 | 116058 | 2020-05-10 | Sunrise Assisted Living of Fair Oaks | Sacramento | 1 | 17 | 0 | 1 | 67 | <11 | <11 | ||
116059 | 116059 | 2020-05-10 | Sunrise Assisted Living of Sacramento | Sacramento | 25 | 25 | 0 | 1 | 67 | <11 | |||
115989 | 115989 | 2020-05-11 | Carlton Plaza of Elk Grove | Sacramento | 0 | 1 | 0 | 1 | 67 | <11 | <11 | ||
115990 | 115990 | 2020-05-11 | Eskaton Gold River | Sacramento | 0 | 1 | 0 | 1 | 67 | <11 | <11 | ||
115991 | 115991 | 2020-05-11 | Oakmont of Folsom | Sacramento | 1 | 20 | 0 | 1 | 67 | <11 | <11 | ||
115992 | 115992 | 2020-05-11 | Summerset Senior Living | Sacramento | 0 | 1 | 0 | 1 | 67 | <11 | <11 | ||
115993 | 115993 | 2020-05-11 | Sunrise Assisted Living of Fair Oaks | Sacramento | 1 | 17 | 0 | 1 | 67 | <11 | <11 | ||
115994 | 115994 | 2020-05-11 | Sunrise Assisted Living of Sacramento | Sacramento | 25 | 25 | 0 | 1 | 67 | <11 | |||
115924 | 115924 | 2020-05-12 | Carlton Plaza of Elk Grove | Sacramento | 0 | 1 | 0 | 1 | 67 | <11 | <11 | ||
115925 | 115925 | 2020-05-12 | Eskaton Gold River | Sacramento | 0 | 1 | 0 | 1 | 67 | <11 | <11 | ||
115926 | 115926 | 2020-05-12 | Oakmont of Folsom | Sacramento | 1 | 20 | 0 | 1 | 67 | <11 | <11 | ||
115927 | 115927 | 2020-05-12 | Summerset Senior Living | Sacramento | 0 | 1 | 0 | 1 | 67 | <11 | <11 | ||
115928 | 115928 | 2020-05-12 | Sunrise Assisted Living of Fair Oaks | Sacramento | 1 | 17 | 0 | 1 | 67 | <11 | <11 | ||
115929 | 115929 | 2020-05-12 | Sunrise Assisted Living of Sacramento | Sacramento | 25 | 25 | 0 | 1 | 67 | <11 | |||
115857 | 115857 | 2020-05-13 | Carlton Plaza of Elk Grove | Sacramento | 0 | 1 | 0 | 1 | 67 | <11 | <11 | ||
115858 | 115858 | 2020-05-13 | Eskaton Gold River | Sacramento | 0 | 1 | 0 | 1 | 67 | <11 | <11 | ||
115859 | 115859 | 2020-05-13 | Oakmont of Folsom | Sacramento | 1 | 20 | 0 | 1 | 67 | <11 | <11 | ||
115860 | 115860 | 2020-05-13 | Summerset Senior Living | Sacramento | 0 | 1 | 0 | 1 | 67 | <11 | <11 | ||
115861 | 115861 | 2020-05-13 | Sunrise Assisted Living of Fair Oaks | Sacramento | 1 | 17 | 0 | 1 | 67 | <11 | <11 | ||
115862 | 115862 | 2020-05-13 | Sunrise Assisted Living of Sacramento | Sacramento | 25 | 25 | 0 | 1 | 67 | <11 | |||
115789 | 115789 | 2020-05-14 | Carlton Plaza of Elk Grove | Sacramento | 0 | 1 | 0 | 1 | 67 | <11 | <11 | ||
115790 | 115790 | 2020-05-14 | Eskaton Gold River | Sacramento | 0 | 1 | 0 | 1 | 67 | <11 | <11 | ||
115791 | 115791 | 2020-05-14 | Oakmont of Folsom | Sacramento | 1 | 21 | 0 | 1 | 67 | <11 | <11 | ||
115792 | 115792 | 2020-05-14 | Summerset Senior Living | Sacramento | 0 | 1 | 0 | 1 | 67 | <11 | <11 | ||
115793 | 115793 | 2020-05-14 | Sunrise Assisted Living of Fair Oaks | Sacramento | 1 | 17 | 0 | 1 | 67 | <11 | <11 | ||
115794 | 115794 | 2020-05-14 | Sunrise Assisted Living of Sacramento | Sacramento | 25 | 25 | 0 | 1 | 67 | <11 | |||
115718 | 115718 | 2020-05-15 | Carlton Plaza of Elk Grove | Sacramento | 0 | 1 | 0 | 1 | 67 | <11 | <11 | ||
115719 | 115719 | 2020-05-15 | Eskaton Gold River | Sacramento | 0 | 1 | 0 | 1 | 67 | <11 | <11 | ||
115720 | 115720 | 2020-05-15 | Oakmont of Folsom | Sacramento | 1 | 21 | 0 | 1 | 67 | <11 | <11 | ||
115721 | 115721 | 2020-05-15 | Summerset Senior Living | Sacramento | 0 | 14 | 0 | 1 | 67 | <11 | |||
115722 | 115722 | 2020-05-15 | Sunrise Assisted Living of Fair Oaks | Sacramento | 1 | 17 | 0 | 1 | 67 | <11 | <11 | ||
115723 | 115723 | 2020-05-15 | Sunrise Assisted Living of Sacramento | Sacramento | 25 | 25 | 0 | 1 | 67 | <11 | |||
115644 | 115644 | 2020-05-16 | Carlton Plaza of Elk Grove | Sacramento | 0 | 1 | 0 | 1 | 67 | <11 | <11 | ||
115645 | 115645 | 2020-05-16 | Eskaton Gold River | Sacramento | 0 | 1 | 0 | 1 | 67 | <11 | <11 | ||
115646 | 115646 | 2020-05-16 | Oakmont of Folsom | Sacramento | 1 | 21 | 0 | 1 | 67 | <11 | <11 | ||
115647 | 115647 | 2020-05-16 | Summerset Senior Living | Sacramento | 1 | 17 | 0 | 1 | 67 | <11 | <11 | ||
115648 | 115648 | 2020-05-16 | Sunrise Assisted Living of Fair Oaks | Sacramento | 1 | 17 | 0 | 1 | 67 | <11 | <11 | ||
115649 | 115649 | 2020-05-16 | Sunrise Assisted Living of Sacramento | Sacramento | 25 | 25 | 0 | 1 | 67 | <11 | |||
115571 | 115571 | 2020-05-17 | Carlton Plaza of Elk Grove | Sacramento | 0 | 1 | 0 | 1 | 67 | <11 | <11 | ||
115572 | 115572 | 2020-05-17 | Eskaton Gold River | Sacramento | 0 | 1 | 0 | 1 | 67 | <11 | <11 | ||
115573 | 115573 | 2020-05-17 | Oakmont of Folsom | Sacramento | 1 | 21 | 0 | 1 | 67 | <11 | <11 | ||
115574 | 115574 | 2020-05-17 | Summerset Senior Living | Sacramento | 1 | 17 | 0 | 1 | 67 | <11 | <11 | ||
115575 | 115575 | 2020-05-17 | Sunrise Assisted Living of Fair Oaks | Sacramento | 1 | 17 | 0 | 1 | 67 | <11 | <11 | ||
115576 | 115576 | 2020-05-17 | Sunrise Assisted Living of Sacramento | Sacramento | 25 | 25 | 0 | 1 | 67 | <11 | |||
115497 | 115497 | 2020-05-18 | Carlton Plaza of Elk Grove | Sacramento | 0 | 1 | 0 | 1 | 67 | <11 | <11 | ||
115498 | 115498 | 2020-05-18 | Eskaton Gold River | Sacramento | 0 | 1 | 0 | 1 | 67 | <11 | <11 | ||
115499 | 115499 | 2020-05-18 | Oakmont of Folsom | Sacramento | 1 | 21 | 0 | 1 | 67 | <11 | <11 | ||
115500 | 115500 | 2020-05-18 | Summerset Senior Living | Sacramento | 1 | 17 | 0 | 1 | 67 | <11 | <11 | ||
115501 | 115501 | 2020-05-18 | Sunrise Assisted Living of Fair Oaks | Sacramento | 1 | 17 | 0 | 1 | 67 | <11 | <11 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [la_times_cdph_adult_and_senior_care_facilities] ( [date] TEXT, [name] TEXT, [county] TEXT, [staff_confirmed_cases] INTEGER, [patients_confirmed_cases] INTEGER, [staff_deaths] INTEGER, [patients_deaths] INTEGER, [fips] INTEGER, [staff_confirmed_cases_note] TEXT, [patients_confirmed_cases_note] TEXT, [staff_deaths_note] TEXT, [patients_deaths_note] TEXT );