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 county = "Sacramento" and "date" is on date 2021-03-17 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: patients_confirmed_cases_note, patients_deaths_note
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14151 | 14151 | 2021-03-17 | Almond Avenue Residence Club | Sacramento | 1 | 20 | 0 | 1 | 67 | <11 | <11 | ||
14152 | 14152 | 2021-03-17 | Almond Heights | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
14153 | 14153 | 2021-03-17 | Apple Ridge Assisted Living | Sacramento | 1 | 16 | 0 | 0 | 67 | <11 | |||
14154 | 14154 | 2021-03-17 | Atria Carmichael Oaks | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
14155 | 14155 | 2021-03-17 | Atria El Camino Gardens | Sacramento | 27 | 32 | 0 | 1 | 67 | <11 | |||
14156 | 14156 | 2021-03-17 | Brookdale Citrus Heights | Sacramento | 1 | 1 | 0 | 0 | 67 | <11 | <11 | ||
14157 | 14157 | 2021-03-17 | Carlton Crown Plaza | Sacramento | 1 | 15 | 0 | 0 | 67 | <11 | |||
14158 | 14158 | 2021-03-17 | Carlton Plaza Of Elk Grove | Sacramento | 32 | 21 | 0 | 1 | 67 | <11 | |||
14159 | 14159 | 2021-03-17 | Carlton Plaza Of Sacramento | Sacramento | 36 | 34 | 0 | 1 | 67 | <11 | |||
14160 | 14160 | 2021-03-17 | Carlton Senior Living Orangevale | Sacramento | 28 | 18 | 0 | 0 | 67 | ||||
14161 | 14161 | 2021-03-17 | Chalet, The | Sacramento | 1 | 17 | 1 | 1 | 67 | <11 | <11 | <11 | |
14162 | 14162 | 2021-03-17 | Chateau At River's Edge, The | Sacramento | 12 | 19 | 0 | 1 | 67 | <11 | |||
14163 | 14163 | 2021-03-17 | Citrus Heights Terrace | Sacramento | 12 | 30 | 0 | 1 | 67 | <11 | |||
14164 | 14164 | 2021-03-17 | City Creek Assisted Living | Sacramento | 15 | 43 | 0 | 1 | 67 | <11 | |||
14165 | 14165 | 2021-03-17 | Country Club Manor | Sacramento | 23 | 33 | 0 | 0 | 67 | ||||
14166 | 14166 | 2021-03-17 | Courte At Citrus Heights, The | Sacramento | 1 | 27 | 0 | 1 | 67 | <11 | <11 | ||
14167 | 14167 | 2021-03-17 | Ehimas Residential Care | Sacramento | 1 | 15 | 0 | 0 | 67 | <11 | |||
14168 | 14168 | 2021-03-17 | Elk Gove Park Asst. Lvg And Memory Care Community | Sacramento | 18 | 22 | 0 | 1 | 67 | <11 | |||
14169 | 14169 | 2021-03-17 | Empire Ranch Alzheimer's Special Care Center | Sacramento | 1 | 11 | 0 | 0 | 67 | <11 | |||
14170 | 14170 | 2021-03-17 | Eskaton Gold River Lodge | Sacramento | 18 | 25 | 0 | 1 | 67 | <11 | |||
14171 | 14171 | 2021-03-17 | Eskaton Village | Sacramento | 31 | 19 | 1 | 1 | 67 | <11 | <11 | ||
14172 | 14172 | 2021-03-17 | Fair Oaks Community At Sunset | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
14173 | 14173 | 2021-03-17 | Fair Oaks Estates Inc | Sacramento | 1 | 27 | 0 | 0 | 67 | <11 | |||
14174 | 14174 | 2021-03-17 | Fruitridge Villa | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
14175 | 14175 | 2021-03-17 | Greenhaven Estates | Sacramento | 15 | 1 | 0 | 1 | 67 | <11 | <11 | ||
14176 | 14176 | 2021-03-17 | Greenhaven Place Independent Lvg And Assisted Lvg | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
14177 | 14177 | 2021-03-17 | Lakewood Villa | Sacramento | 1 | 14 | 0 | 1 | 67 | <11 | <11 | ||
14178 | 14178 | 2021-03-17 | Meadows At Country Place, The | Sacramento | 17 | 24 | 0 | 11 | 67 | ||||
14179 | 14179 | 2021-03-17 | Meadows Senior Living, The | Sacramento | 12 | 20 | 0 | 1 | 67 | <11 | |||
14180 | 14180 | 2021-03-17 | Mercy Mcmahon Terrace | Sacramento | 1 | 1 | 0 | 0 | 67 | <11 | <11 | ||
14181 | 14181 | 2021-03-17 | Oakmont Of Carmichael | Sacramento | 22 | 40 | 0 | 1 | 67 | <11 | |||
14182 | 14182 | 2021-03-17 | Oakmont Of Fair Oaks | Sacramento | 26 | 53 | 0 | 1 | 67 | <11 | |||
14183 | 14183 | 2021-03-17 | Oakmont Of Folsom | Sacramento | 13 | 34 | 0 | 1 | 67 | <11 | |||
14184 | 14184 | 2021-03-17 | Oars At Greenback Lane, The | Sacramento | 13 | 1 | 0 | 0 | 67 | <11 | |||
14185 | 14185 | 2021-03-17 | Prairie City Landing | Sacramento | 1 | 11 | 0 | 1 | 67 | <11 | <11 | ||
14186 | 14186 | 2021-03-17 | Revere Court | Sacramento | 27 | 42 | 0 | 1 | 67 | <11 | |||
14187 | 14187 | 2021-03-17 | Sky Park Gardens | Sacramento | 34 | 30 | 0 | 1 | 67 | <11 | |||
14188 | 14188 | 2021-03-17 | Spiva Acres | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
14189 | 14189 | 2021-03-17 | Summerset Assisted Living | Sacramento | 1 | 24 | 0 | 1 | 67 | <11 | <11 | ||
14190 | 14190 | 2021-03-17 | Sun Oak Assisted Living | Sacramento | 17 | 22 | 0 | 1 | 67 | <11 | |||
14191 | 14191 | 2021-03-17 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
14192 | 14192 | 2021-03-17 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
14193 | 14193 | 2021-03-17 | Sunrise Assisted Living Of Sacramento | Sacramento | 25 | 25 | 0 | 1 | 67 | <11 | |||
14194 | 14194 | 2021-03-17 | Walnut House | Sacramento | 1 | 38 | 0 | 1 | 67 | <11 | <11 | ||
14195 | 14195 | 2021-03-17 | 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 );