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
44 rows where "date" is on date 2021-02-12 and fips = 67 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34864 | 34864 | 2021-02-12 | Almond Avenue Residence Club | Sacramento | 1 | 20 | 0 | 1 | 67 | <11 | <11 | ||
34865 | 34865 | 2021-02-12 | Almond Heights | Sacramento | 1 | 1 | 0 | 0 | 67 | <11 | <11 | ||
34866 | 34866 | 2021-02-12 | Apple Ridge Assisted Living | Sacramento | 1 | 16 | 0 | 0 | 67 | <11 | |||
34867 | 34867 | 2021-02-12 | Atria Carmichael Oaks | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
34868 | 34868 | 2021-02-12 | Atria El Camino Gardens | Sacramento | 27 | 32 | 0 | 1 | 67 | <11 | |||
34869 | 34869 | 2021-02-12 | Brookdale Citrus Heights | Sacramento | 1 | 1 | 0 | 0 | 67 | <11 | <11 | ||
34870 | 34870 | 2021-02-12 | Brookdale Elk Grove | Sacramento | 18 | 22 | 0 | 1 | 67 | <11 | |||
34871 | 34871 | 2021-02-12 | Carlton Crown Plaza | Sacramento | 1 | 15 | 0 | 0 | 67 | <11 | |||
34872 | 34872 | 2021-02-12 | Carlton Plaza Of Elk Grove | Sacramento | 32 | 21 | 0 | 1 | 67 | <11 | |||
34873 | 34873 | 2021-02-12 | Carlton Plaza Of Sacramento | Sacramento | 35 | 34 | 0 | 1 | 67 | <11 | |||
34874 | 34874 | 2021-02-12 | Carlton Senior Living Orangevale | Sacramento | 27 | 18 | 0 | 0 | 67 | ||||
34875 | 34875 | 2021-02-12 | Chalet, The | Sacramento | 1 | 17 | 1 | 1 | 67 | <11 | <11 | <11 | |
34876 | 34876 | 2021-02-12 | Chateau At River's Edge, The | Sacramento | 12 | 19 | 0 | 1 | 67 | <11 | |||
34877 | 34877 | 2021-02-12 | Citrus Heights Terrace | Sacramento | 12 | 30 | 0 | 1 | 67 | <11 | |||
34878 | 34878 | 2021-02-12 | City Creek Assisted Living | Sacramento | 15 | 43 | 0 | 1 | 67 | <11 | |||
34879 | 34879 | 2021-02-12 | Country Club Manor | Sacramento | 23 | 33 | 0 | 0 | 67 | ||||
34880 | 34880 | 2021-02-12 | Courte At Citrus Heights, The | Sacramento | 1 | 27 | 0 | 1 | 67 | <11 | <11 | ||
34881 | 34881 | 2021-02-12 | Ehimas Residential Care | Sacramento | 1 | 15 | 0 | 0 | 67 | <11 | |||
34882 | 34882 | 2021-02-12 | Empire Ranch Alzheimer's Special Care Center | Sacramento | 1 | 11 | 0 | 0 | 67 | <11 | |||
34883 | 34883 | 2021-02-12 | Eskaton Gold River Lodge | Sacramento | 18 | 25 | 0 | 1 | 67 | <11 | |||
34884 | 34884 | 2021-02-12 | Eskaton Village | Sacramento | 30 | 19 | 1 | 1 | 67 | <11 | <11 | ||
34885 | 34885 | 2021-02-12 | Fair Oaks Community At Sunset | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
34886 | 34886 | 2021-02-12 | Fair Oaks Estates Inc | Sacramento | 1 | 27 | 0 | 0 | 67 | <11 | |||
34887 | 34887 | 2021-02-12 | Fruitridge Villa | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
34888 | 34888 | 2021-02-12 | Greenhaven Estates | Sacramento | 14 | 1 | 0 | 1 | 67 | <11 | <11 | ||
34889 | 34889 | 2021-02-12 | Greenhaven Place Independent Lvg And Assisted Lvg | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
34890 | 34890 | 2021-02-12 | Lakewood Villa | Sacramento | 1 | 14 | 0 | 1 | 67 | <11 | <11 | ||
34891 | 34891 | 2021-02-12 | Meadows At Country Place, The | Sacramento | 17 | 24 | 0 | 11 | 67 | ||||
34892 | 34892 | 2021-02-12 | Meadows Senior Living, The | Sacramento | 12 | 19 | 0 | 1 | 67 | <11 | |||
34893 | 34893 | 2021-02-12 | Mercy Mcmahon Terrace | Sacramento | 1 | 1 | 0 | 0 | 67 | <11 | <11 | ||
34894 | 34894 | 2021-02-12 | Oakmont Of Carmichael | Sacramento | 22 | 40 | 0 | 1 | 67 | <11 | |||
34895 | 34895 | 2021-02-12 | Oakmont Of Fair Oaks | Sacramento | 26 | 53 | 0 | 1 | 67 | <11 | |||
34896 | 34896 | 2021-02-12 | Oakmont Of Folsom | Sacramento | 13 | 34 | 0 | 1 | 67 | <11 | |||
34897 | 34897 | 2021-02-12 | Prairie City Landing | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
34898 | 34898 | 2021-02-12 | Revere Court | Sacramento | 27 | 42 | 0 | 1 | 67 | <11 | |||
34899 | 34899 | 2021-02-12 | Sky Park Gardens | Sacramento | 34 | 30 | 0 | 1 | 67 | <11 | |||
34900 | 34900 | 2021-02-12 | Spiva Acres | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
34901 | 34901 | 2021-02-12 | Summerset Assisted Living | Sacramento | 1 | 24 | 0 | 1 | 67 | <11 | <11 | ||
34902 | 34902 | 2021-02-12 | Sun Oak Assisted Living | Sacramento | 16 | 22 | 0 | 1 | 67 | <11 | |||
34903 | 34903 | 2021-02-12 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
34904 | 34904 | 2021-02-12 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
34905 | 34905 | 2021-02-12 | Sunrise Assisted Living Of Sacramento | Sacramento | 25 | 25 | 0 | 1 | 67 | <11 | |||
34906 | 34906 | 2021-02-12 | Walnut House | Sacramento | 1 | 38 | 0 | 1 | 67 | <11 | <11 | ||
34907 | 34907 | 2021-02-12 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 |
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 );