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
45 rows where "date" is on date 2021-03-19 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12062 | 12062 | 2021-03-19 | Almond Avenue Residence Club | Sacramento | 1 | 20 | 0 | 1 | 67 | <11 | <11 | ||
12063 | 12063 | 2021-03-19 | Almond Heights | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
12064 | 12064 | 2021-03-19 | Apple Ridge Assisted Living | Sacramento | 1 | 16 | 0 | 0 | 67 | <11 | |||
12065 | 12065 | 2021-03-19 | Atria Carmichael Oaks | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
12066 | 12066 | 2021-03-19 | Atria El Camino Gardens | Sacramento | 27 | 32 | 0 | 1 | 67 | <11 | |||
12067 | 12067 | 2021-03-19 | Brookdale Citrus Heights | Sacramento | 1 | 1 | 0 | 0 | 67 | <11 | <11 | ||
12068 | 12068 | 2021-03-19 | Carlton Crown Plaza | Sacramento | 1 | 16 | 0 | 1 | 67 | <11 | <11 | ||
12069 | 12069 | 2021-03-19 | Carlton Plaza Of Elk Grove | Sacramento | 32 | 21 | 0 | 1 | 67 | <11 | |||
12070 | 12070 | 2021-03-19 | Carlton Plaza Of Sacramento | Sacramento | 36 | 34 | 0 | 1 | 67 | <11 | |||
12071 | 12071 | 2021-03-19 | Carlton Senior Living Orangevale | Sacramento | 28 | 18 | 0 | 0 | 67 | ||||
12072 | 12072 | 2021-03-19 | Chalet, The | Sacramento | 1 | 17 | 1 | 1 | 67 | <11 | <11 | <11 | |
12073 | 12073 | 2021-03-19 | Chateau At River's Edge, The | Sacramento | 12 | 19 | 0 | 1 | 67 | <11 | |||
12074 | 12074 | 2021-03-19 | Citrus Heights Terrace | Sacramento | 12 | 30 | 0 | 1 | 67 | <11 | |||
12075 | 12075 | 2021-03-19 | City Creek Assisted Living | Sacramento | 15 | 43 | 0 | 1 | 67 | <11 | |||
12076 | 12076 | 2021-03-19 | Country Club Manor | Sacramento | 23 | 33 | 0 | 0 | 67 | ||||
12077 | 12077 | 2021-03-19 | Courte At Citrus Heights, The | Sacramento | 1 | 27 | 0 | 1 | 67 | <11 | <11 | ||
12078 | 12078 | 2021-03-19 | Ehimas Residential Care | Sacramento | 1 | 15 | 0 | 0 | 67 | <11 | |||
12079 | 12079 | 2021-03-19 | Elk Gove Park Asst. Lvg And Memory Care Community | Sacramento | 18 | 22 | 0 | 1 | 67 | <11 | |||
12080 | 12080 | 2021-03-19 | Empire Ranch Alzheimer's Special Care Center | Sacramento | 1 | 11 | 0 | 0 | 67 | <11 | |||
12081 | 12081 | 2021-03-19 | Eskaton Gold River Lodge | Sacramento | 18 | 25 | 0 | 1 | 67 | <11 | |||
12082 | 12082 | 2021-03-19 | Eskaton Village | Sacramento | 31 | 19 | 1 | 1 | 67 | <11 | <11 | ||
12083 | 12083 | 2021-03-19 | Fair Oaks Community At Sunset | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
12084 | 12084 | 2021-03-19 | Fair Oaks Estates Inc | Sacramento | 1 | 27 | 0 | 0 | 67 | <11 | |||
12085 | 12085 | 2021-03-19 | Fruitridge Villa | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
12086 | 12086 | 2021-03-19 | Greenhaven Estates | Sacramento | 15 | 1 | 0 | 1 | 67 | <11 | <11 | ||
12087 | 12087 | 2021-03-19 | Greenhaven Place Independent Lvg And Assisted Lvg | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
12088 | 12088 | 2021-03-19 | Lakewood Villa | Sacramento | 1 | 14 | 0 | 1 | 67 | <11 | <11 | ||
12089 | 12089 | 2021-03-19 | Meadows At Country Place, The | Sacramento | 17 | 24 | 0 | 11 | 67 | ||||
12090 | 12090 | 2021-03-19 | Meadows Senior Living, The | Sacramento | 12 | 20 | 0 | 1 | 67 | <11 | |||
12091 | 12091 | 2021-03-19 | Mercy Mcmahon Terrace | Sacramento | 1 | 1 | 0 | 0 | 67 | <11 | <11 | ||
12092 | 12092 | 2021-03-19 | Oakmont Of Carmichael | Sacramento | 22 | 40 | 0 | 1 | 67 | <11 | |||
12093 | 12093 | 2021-03-19 | Oakmont Of Fair Oaks | Sacramento | 26 | 53 | 0 | 1 | 67 | <11 | |||
12094 | 12094 | 2021-03-19 | Oakmont Of Folsom | Sacramento | 13 | 34 | 0 | 1 | 67 | <11 | |||
12095 | 12095 | 2021-03-19 | Oars At Greenback Lane, The | Sacramento | 13 | 1 | 0 | 0 | 67 | <11 | |||
12096 | 12096 | 2021-03-19 | Prairie City Landing | Sacramento | 1 | 12 | 0 | 1 | 67 | <11 | <11 | ||
12097 | 12097 | 2021-03-19 | Revere Court | Sacramento | 27 | 42 | 0 | 1 | 67 | <11 | |||
12098 | 12098 | 2021-03-19 | Sky Park Gardens | Sacramento | 34 | 30 | 0 | 1 | 67 | <11 | |||
12099 | 12099 | 2021-03-19 | Spiva Acres | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
12100 | 12100 | 2021-03-19 | Summerset Assisted Living | Sacramento | 1 | 24 | 0 | 1 | 67 | <11 | <11 | ||
12101 | 12101 | 2021-03-19 | Sun Oak Assisted Living | Sacramento | 17 | 22 | 0 | 1 | 67 | <11 | |||
12102 | 12102 | 2021-03-19 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
12103 | 12103 | 2021-03-19 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
12104 | 12104 | 2021-03-19 | Sunrise Assisted Living Of Sacramento | Sacramento | 25 | 25 | 0 | 1 | 67 | <11 | |||
12105 | 12105 | 2021-03-19 | Walnut House | Sacramento | 1 | 38 | 0 | 1 | 67 | <11 | <11 | ||
12106 | 12106 | 2021-03-19 | 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 );