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-08 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38965 | 38965 | 2021-02-08 | Almond Avenue Residence Club | Sacramento | 1 | 20 | 0 | 1 | 67 | <11 | <11 | ||
38966 | 38966 | 2021-02-08 | Almond Heights | Sacramento | 1 | 1 | 0 | 0 | 67 | <11 | <11 | ||
38967 | 38967 | 2021-02-08 | Apple Ridge Assisted Living | Sacramento | 1 | 16 | 0 | 0 | 67 | <11 | |||
38968 | 38968 | 2021-02-08 | Atria Carmichael Oaks | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
38969 | 38969 | 2021-02-08 | Atria El Camino Gardens | Sacramento | 23 | 32 | 0 | 1 | 67 | <11 | |||
38970 | 38970 | 2021-02-08 | Brookdale Citrus Heights | Sacramento | 1 | 1 | 0 | 0 | 67 | <11 | <11 | ||
38971 | 38971 | 2021-02-08 | Brookdale Elk Grove | Sacramento | 18 | 22 | 0 | 1 | 67 | <11 | |||
38972 | 38972 | 2021-02-08 | Carlton Crown Plaza | Sacramento | 1 | 15 | 0 | 0 | 67 | <11 | |||
38973 | 38973 | 2021-02-08 | Carlton Plaza Of Elk Grove | Sacramento | 32 | 21 | 0 | 1 | 67 | <11 | |||
38974 | 38974 | 2021-02-08 | Carlton Plaza Of Sacramento | Sacramento | 35 | 33 | 0 | 1 | 67 | <11 | |||
38975 | 38975 | 2021-02-08 | Carlton Senior Living Orangevale | Sacramento | 26 | 18 | 0 | 0 | 67 | ||||
38976 | 38976 | 2021-02-08 | Chalet, The | Sacramento | 1 | 17 | 1 | 1 | 67 | <11 | <11 | <11 | |
38977 | 38977 | 2021-02-08 | Chateau At River's Edge, The | Sacramento | 11 | 19 | 0 | 1 | 67 | <11 | |||
38978 | 38978 | 2021-02-08 | Citrus Heights Terrace | Sacramento | 12 | 30 | 0 | 1 | 67 | <11 | |||
38979 | 38979 | 2021-02-08 | City Creek Assisted Living | Sacramento | 15 | 43 | 0 | 1 | 67 | <11 | |||
38980 | 38980 | 2021-02-08 | Country Club Manor | Sacramento | 23 | 33 | 0 | 0 | 67 | ||||
38981 | 38981 | 2021-02-08 | Courte At Citrus Heights, The | Sacramento | 1 | 27 | 0 | 1 | 67 | <11 | <11 | ||
38982 | 38982 | 2021-02-08 | Ehimas Residential Care | Sacramento | 1 | 15 | 0 | 0 | 67 | <11 | |||
38983 | 38983 | 2021-02-08 | Empire Ranch Alzheimer's Special Care Center | Sacramento | 1 | 11 | 0 | 0 | 67 | <11 | |||
38984 | 38984 | 2021-02-08 | Eskaton Gold River Lodge | Sacramento | 18 | 25 | 0 | 1 | 67 | <11 | |||
38985 | 38985 | 2021-02-08 | Eskaton Village | Sacramento | 30 | 19 | 1 | 1 | 67 | <11 | <11 | ||
38986 | 38986 | 2021-02-08 | Fair Oaks Community At Sunset | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
38987 | 38987 | 2021-02-08 | Fair Oaks Estates Inc | Sacramento | 1 | 27 | 0 | 0 | 67 | <11 | |||
38988 | 38988 | 2021-02-08 | Fruitridge Villa | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
38989 | 38989 | 2021-02-08 | Greenhaven Estates | Sacramento | 14 | 1 | 0 | 1 | 67 | <11 | <11 | ||
38990 | 38990 | 2021-02-08 | Greenhaven Place Independent Lvg And Assisted Lvg | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
38991 | 38991 | 2021-02-08 | Lakewood Villa | Sacramento | 1 | 14 | 0 | 1 | 67 | <11 | <11 | ||
38992 | 38992 | 2021-02-08 | Meadows At Country Place, The | Sacramento | 17 | 24 | 0 | 11 | 67 | ||||
38993 | 38993 | 2021-02-08 | Meadows Senior Living, The | Sacramento | 12 | 19 | 0 | 1 | 67 | <11 | |||
38994 | 38994 | 2021-02-08 | Mercy Mcmahon Terrace | Sacramento | 1 | 1 | 0 | 0 | 67 | <11 | <11 | ||
38995 | 38995 | 2021-02-08 | Oakmont Of Carmichael | Sacramento | 22 | 40 | 0 | 1 | 67 | <11 | |||
38996 | 38996 | 2021-02-08 | Oakmont Of Fair Oaks | Sacramento | 26 | 53 | 0 | 1 | 67 | <11 | |||
38997 | 38997 | 2021-02-08 | Oakmont Of Folsom | Sacramento | 13 | 34 | 0 | 1 | 67 | <11 | |||
38998 | 38998 | 2021-02-08 | Prairie City Landing | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
38999 | 38999 | 2021-02-08 | Revere Court | Sacramento | 27 | 41 | 0 | 1 | 67 | <11 | |||
39000 | 39000 | 2021-02-08 | Sky Park Gardens | Sacramento | 34 | 30 | 0 | 1 | 67 | <11 | |||
39001 | 39001 | 2021-02-08 | Spiva Acres | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
39002 | 39002 | 2021-02-08 | Summerset Assisted Living | Sacramento | 1 | 24 | 0 | 1 | 67 | <11 | <11 | ||
39003 | 39003 | 2021-02-08 | Sun Oak Assisted Living | Sacramento | 16 | 22 | 0 | 1 | 67 | <11 | |||
39004 | 39004 | 2021-02-08 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
39005 | 39005 | 2021-02-08 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
39006 | 39006 | 2021-02-08 | Sunrise Assisted Living Of Sacramento | Sacramento | 25 | 25 | 0 | 1 | 67 | <11 | |||
39007 | 39007 | 2021-02-08 | Walnut House | Sacramento | 1 | 38 | 0 | 1 | 67 | <11 | <11 | ||
39008 | 39008 | 2021-02-08 | 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 );