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-24 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8923 | 8923 | 2021-03-24 | Almond Avenue Residence Club | Sacramento | 1 | 20 | 0 | 1 | 67 | <11 | <11 | ||
8924 | 8924 | 2021-03-24 | Almond Heights | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
8925 | 8925 | 2021-03-24 | Apple Ridge Assisted Living | Sacramento | 1 | 16 | 0 | 0 | 67 | <11 | |||
8926 | 8926 | 2021-03-24 | Atria Carmichael Oaks | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
8927 | 8927 | 2021-03-24 | Atria El Camino Gardens | Sacramento | 27 | 32 | 0 | 1 | 67 | <11 | |||
8928 | 8928 | 2021-03-24 | Brookdale Citrus Heights | Sacramento | 1 | 1 | 0 | 0 | 67 | <11 | <11 | ||
8929 | 8929 | 2021-03-24 | Carlton Crown Plaza | Sacramento | 1 | 16 | 0 | 1 | 67 | <11 | <11 | ||
8930 | 8930 | 2021-03-24 | Carlton Plaza Of Elk Grove | Sacramento | 32 | 21 | 0 | 1 | 67 | <11 | |||
8931 | 8931 | 2021-03-24 | Carlton Plaza Of Sacramento | Sacramento | 36 | 34 | 0 | 1 | 67 | <11 | |||
8932 | 8932 | 2021-03-24 | Carlton Senior Living Orangevale | Sacramento | 28 | 18 | 0 | 0 | 67 | ||||
8933 | 8933 | 2021-03-24 | Chalet, The | Sacramento | 1 | 17 | 1 | 1 | 67 | <11 | <11 | <11 | |
8934 | 8934 | 2021-03-24 | Chateau At River's Edge, The | Sacramento | 12 | 19 | 0 | 1 | 67 | <11 | |||
8935 | 8935 | 2021-03-24 | Citrus Heights Terrace | Sacramento | 12 | 30 | 0 | 1 | 67 | <11 | |||
8936 | 8936 | 2021-03-24 | City Creek Assisted Living | Sacramento | 15 | 43 | 0 | 1 | 67 | <11 | |||
8937 | 8937 | 2021-03-24 | Country Club Manor | Sacramento | 23 | 33 | 0 | 0 | 67 | ||||
8938 | 8938 | 2021-03-24 | Courte At Citrus Heights, The | Sacramento | 1 | 27 | 0 | 1 | 67 | <11 | <11 | ||
8939 | 8939 | 2021-03-24 | Ehimas Residential Care | Sacramento | 1 | 15 | 0 | 0 | 67 | <11 | |||
8940 | 8940 | 2021-03-24 | Elk Gove Park Asst. Lvg And Memory Care Community | Sacramento | 18 | 22 | 0 | 1 | 67 | <11 | |||
8941 | 8941 | 2021-03-24 | Empire Ranch Alzheimer's Special Care Center | Sacramento | 1 | 11 | 0 | 0 | 67 | <11 | |||
8942 | 8942 | 2021-03-24 | Eskaton Gold River Lodge | Sacramento | 18 | 25 | 0 | 1 | 67 | <11 | |||
8943 | 8943 | 2021-03-24 | Eskaton Village | Sacramento | 31 | 19 | 1 | 1 | 67 | <11 | <11 | ||
8944 | 8944 | 2021-03-24 | Fair Oaks Community At Sunset | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
8945 | 8945 | 2021-03-24 | Fair Oaks Estates Inc | Sacramento | 1 | 27 | 0 | 0 | 67 | <11 | |||
8946 | 8946 | 2021-03-24 | Fruitridge Villa | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
8947 | 8947 | 2021-03-24 | Greenhaven Estates | Sacramento | 15 | 1 | 0 | 1 | 67 | <11 | <11 | ||
8948 | 8948 | 2021-03-24 | Greenhaven Place Independent Lvg And Assisted Lvg | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
8949 | 8949 | 2021-03-24 | Lakewood Villa | Sacramento | 1 | 14 | 0 | 1 | 67 | <11 | <11 | ||
8950 | 8950 | 2021-03-24 | Meadows At Country Place, The | Sacramento | 17 | 24 | 0 | 11 | 67 | ||||
8951 | 8951 | 2021-03-24 | Meadows Senior Living, The | Sacramento | 12 | 20 | 0 | 1 | 67 | <11 | |||
8952 | 8952 | 2021-03-24 | Mercy Mcmahon Terrace | Sacramento | 1 | 1 | 0 | 0 | 67 | <11 | <11 | ||
8953 | 8953 | 2021-03-24 | Oakmont Of Carmichael | Sacramento | 22 | 40 | 0 | 1 | 67 | <11 | |||
8954 | 8954 | 2021-03-24 | Oakmont Of Fair Oaks | Sacramento | 26 | 53 | 0 | 1 | 67 | <11 | |||
8955 | 8955 | 2021-03-24 | Oakmont Of Folsom | Sacramento | 13 | 34 | 0 | 1 | 67 | <11 | |||
8956 | 8956 | 2021-03-24 | Oars At Greenback Lane, The | Sacramento | 16 | 1 | 0 | 0 | 67 | <11 | |||
8957 | 8957 | 2021-03-24 | Prairie City Landing | Sacramento | 1 | 12 | 0 | 1 | 67 | <11 | <11 | ||
8958 | 8958 | 2021-03-24 | Revere Court | Sacramento | 27 | 42 | 0 | 1 | 67 | <11 | |||
8959 | 8959 | 2021-03-24 | Sky Park Gardens | Sacramento | 34 | 30 | 0 | 1 | 67 | <11 | |||
8960 | 8960 | 2021-03-24 | Spiva Acres | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
8961 | 8961 | 2021-03-24 | Summerset Assisted Living | Sacramento | 1 | 24 | 0 | 1 | 67 | <11 | <11 | ||
8962 | 8962 | 2021-03-24 | Sun Oak Assisted Living | Sacramento | 17 | 22 | 0 | 1 | 67 | <11 | |||
8963 | 8963 | 2021-03-24 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
8964 | 8964 | 2021-03-24 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
8965 | 8965 | 2021-03-24 | Sunrise Assisted Living Of Sacramento | Sacramento | 25 | 25 | 0 | 1 | 67 | <11 | |||
8966 | 8966 | 2021-03-24 | Walnut House | Sacramento | 1 | 38 | 0 | 1 | 67 | <11 | <11 | ||
8967 | 8967 | 2021-03-24 | 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 );