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-29 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6829 | 6829 | 2021-03-29 | Almond Avenue Residence Club | Sacramento | 1 | 20 | 0 | 1 | 67 | <11 | <11 | ||
6830 | 6830 | 2021-03-29 | Almond Heights | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
6831 | 6831 | 2021-03-29 | Apple Ridge Assisted Living | Sacramento | 1 | 16 | 0 | 0 | 67 | <11 | |||
6832 | 6832 | 2021-03-29 | Atria Carmichael Oaks | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
6833 | 6833 | 2021-03-29 | Atria El Camino Gardens | Sacramento | 27 | 32 | 0 | 1 | 67 | <11 | |||
6834 | 6834 | 2021-03-29 | Brookdale Citrus Heights | Sacramento | 1 | 1 | 0 | 0 | 67 | <11 | <11 | ||
6835 | 6835 | 2021-03-29 | Carlton Crown Plaza | Sacramento | 1 | 16 | 0 | 1 | 67 | <11 | <11 | ||
6836 | 6836 | 2021-03-29 | Carlton Plaza Of Elk Grove | Sacramento | 32 | 21 | 0 | 1 | 67 | <11 | |||
6837 | 6837 | 2021-03-29 | Carlton Plaza Of Sacramento | Sacramento | 36 | 34 | 0 | 1 | 67 | <11 | |||
6838 | 6838 | 2021-03-29 | Carlton Senior Living Orangevale | Sacramento | 28 | 18 | 0 | 0 | 67 | ||||
6839 | 6839 | 2021-03-29 | Chalet, The | Sacramento | 1 | 17 | 1 | 1 | 67 | <11 | <11 | <11 | |
6840 | 6840 | 2021-03-29 | Chateau At River's Edge, The | Sacramento | 12 | 19 | 0 | 1 | 67 | <11 | |||
6841 | 6841 | 2021-03-29 | Citrus Heights Terrace | Sacramento | 12 | 30 | 0 | 1 | 67 | <11 | |||
6842 | 6842 | 2021-03-29 | City Creek Assisted Living | Sacramento | 15 | 43 | 0 | 1 | 67 | <11 | |||
6843 | 6843 | 2021-03-29 | Country Club Manor | Sacramento | 23 | 33 | 0 | 0 | 67 | ||||
6844 | 6844 | 2021-03-29 | Courte At Citrus Heights, The | Sacramento | 1 | 27 | 0 | 1 | 67 | <11 | <11 | ||
6845 | 6845 | 2021-03-29 | Ehimas Residential Care | Sacramento | 1 | 15 | 0 | 0 | 67 | <11 | |||
6846 | 6846 | 2021-03-29 | Elk Gove Park Asst. Lvg And Memory Care Community | Sacramento | 18 | 22 | 0 | 1 | 67 | <11 | |||
6847 | 6847 | 2021-03-29 | Empire Ranch Alzheimer's Special Care Center | Sacramento | 1 | 11 | 0 | 0 | 67 | <11 | |||
6848 | 6848 | 2021-03-29 | Eskaton Gold River Lodge | Sacramento | 18 | 25 | 0 | 1 | 67 | <11 | |||
6849 | 6849 | 2021-03-29 | Eskaton Village | Sacramento | 31 | 19 | 1 | 1 | 67 | <11 | <11 | ||
6850 | 6850 | 2021-03-29 | Fair Oaks Community At Sunset | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
6851 | 6851 | 2021-03-29 | Fair Oaks Estates Inc | Sacramento | 1 | 27 | 0 | 0 | 67 | <11 | |||
6852 | 6852 | 2021-03-29 | Fruitridge Villa | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
6853 | 6853 | 2021-03-29 | Greenhaven Estates | Sacramento | 15 | 1 | 0 | 1 | 67 | <11 | <11 | ||
6854 | 6854 | 2021-03-29 | Greenhaven Place Independent Lvg And Assisted Lvg | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
6855 | 6855 | 2021-03-29 | Lakewood Villa | Sacramento | 1 | 14 | 0 | 1 | 67 | <11 | <11 | ||
6856 | 6856 | 2021-03-29 | Meadows At Country Place, The | Sacramento | 17 | 24 | 0 | 11 | 67 | ||||
6857 | 6857 | 2021-03-29 | Meadows Senior Living, The | Sacramento | 12 | 20 | 0 | 1 | 67 | <11 | |||
6858 | 6858 | 2021-03-29 | Mercy Mcmahon Terrace | Sacramento | 1 | 1 | 0 | 0 | 67 | <11 | <11 | ||
6859 | 6859 | 2021-03-29 | Oakmont Of Carmichael | Sacramento | 22 | 41 | 0 | 1 | 67 | <11 | |||
6860 | 6860 | 2021-03-29 | Oakmont Of Fair Oaks | Sacramento | 26 | 53 | 0 | 1 | 67 | <11 | |||
6861 | 6861 | 2021-03-29 | Oakmont Of Folsom | Sacramento | 13 | 34 | 0 | 1 | 67 | <11 | |||
6862 | 6862 | 2021-03-29 | Oars At Greenback Lane, The | Sacramento | 16 | 1 | 0 | 0 | 67 | <11 | |||
6863 | 6863 | 2021-03-29 | Prairie City Landing | Sacramento | 1 | 12 | 0 | 1 | 67 | <11 | <11 | ||
6864 | 6864 | 2021-03-29 | Revere Court | Sacramento | 27 | 42 | 0 | 1 | 67 | <11 | |||
6865 | 6865 | 2021-03-29 | Sky Park Gardens | Sacramento | 34 | 30 | 0 | 1 | 67 | <11 | |||
6866 | 6866 | 2021-03-29 | Spiva Acres | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
6867 | 6867 | 2021-03-29 | Summerset Assisted Living | Sacramento | 1 | 24 | 0 | 1 | 67 | <11 | <11 | ||
6868 | 6868 | 2021-03-29 | Sun Oak Assisted Living | Sacramento | 17 | 22 | 0 | 1 | 67 | <11 | |||
6869 | 6869 | 2021-03-29 | Sunrise Assisted Living Of Carmichael | Sacramento | 15 | 14 | 0 | 0 | 67 | ||||
6870 | 6870 | 2021-03-29 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
6871 | 6871 | 2021-03-29 | Sunrise Assisted Living Of Sacramento | Sacramento | 25 | 25 | 0 | 1 | 67 | <11 | |||
6872 | 6872 | 2021-03-29 | Walnut House | Sacramento | 1 | 38 | 0 | 1 | 67 | <11 | <11 | ||
6873 | 6873 | 2021-03-29 | 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 );