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-10 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19368 | 19368 | 2021-03-10 | Almond Avenue Residence Club | Sacramento | 1 | 20 | 0 | 1 | 67 | <11 | <11 | ||
19369 | 19369 | 2021-03-10 | Almond Heights | Sacramento | 1 | 1 | 0 | 0 | 67 | <11 | <11 | ||
19370 | 19370 | 2021-03-10 | Apple Ridge Assisted Living | Sacramento | 1 | 16 | 0 | 0 | 67 | <11 | |||
19371 | 19371 | 2021-03-10 | Atria Carmichael Oaks | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
19372 | 19372 | 2021-03-10 | Atria El Camino Gardens | Sacramento | 27 | 32 | 0 | 1 | 67 | <11 | |||
19373 | 19373 | 2021-03-10 | Brookdale Citrus Heights | Sacramento | 1 | 1 | 0 | 0 | 67 | <11 | <11 | ||
19374 | 19374 | 2021-03-10 | Carlton Crown Plaza | Sacramento | 1 | 15 | 0 | 0 | 67 | <11 | |||
19375 | 19375 | 2021-03-10 | Carlton Plaza Of Elk Grove | Sacramento | 32 | 21 | 0 | 1 | 67 | <11 | |||
19376 | 19376 | 2021-03-10 | Carlton Plaza Of Sacramento | Sacramento | 36 | 34 | 0 | 1 | 67 | <11 | |||
19377 | 19377 | 2021-03-10 | Carlton Senior Living Orangevale | Sacramento | 28 | 18 | 0 | 0 | 67 | ||||
19378 | 19378 | 2021-03-10 | Chalet, The | Sacramento | 1 | 17 | 1 | 1 | 67 | <11 | <11 | <11 | |
19379 | 19379 | 2021-03-10 | Chateau At River's Edge, The | Sacramento | 12 | 19 | 0 | 1 | 67 | <11 | |||
19380 | 19380 | 2021-03-10 | Citrus Heights Terrace | Sacramento | 12 | 30 | 0 | 1 | 67 | <11 | |||
19381 | 19381 | 2021-03-10 | City Creek Assisted Living | Sacramento | 15 | 43 | 0 | 1 | 67 | <11 | |||
19382 | 19382 | 2021-03-10 | Country Club Manor | Sacramento | 23 | 33 | 0 | 0 | 67 | ||||
19383 | 19383 | 2021-03-10 | Courte At Citrus Heights, The | Sacramento | 1 | 27 | 0 | 1 | 67 | <11 | <11 | ||
19384 | 19384 | 2021-03-10 | Ehimas Residential Care | Sacramento | 1 | 15 | 0 | 0 | 67 | <11 | |||
19385 | 19385 | 2021-03-10 | Elk Gove Park Asst. Lvg And Memory Care Community | Sacramento | 18 | 22 | 0 | 1 | 67 | <11 | |||
19386 | 19386 | 2021-03-10 | Empire Ranch Alzheimer's Special Care Center | Sacramento | 1 | 11 | 0 | 0 | 67 | <11 | |||
19387 | 19387 | 2021-03-10 | Eskaton Gold River Lodge | Sacramento | 18 | 25 | 0 | 1 | 67 | <11 | |||
19388 | 19388 | 2021-03-10 | Eskaton Village | Sacramento | 30 | 19 | 1 | 1 | 67 | <11 | <11 | ||
19389 | 19389 | 2021-03-10 | Fair Oaks Community At Sunset | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
19390 | 19390 | 2021-03-10 | Fair Oaks Estates Inc | Sacramento | 1 | 27 | 0 | 0 | 67 | <11 | |||
19391 | 19391 | 2021-03-10 | Fruitridge Villa | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
19392 | 19392 | 2021-03-10 | Greenhaven Estates | Sacramento | 14 | 1 | 0 | 1 | 67 | <11 | <11 | ||
19393 | 19393 | 2021-03-10 | Greenhaven Place Independent Lvg And Assisted Lvg | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
19394 | 19394 | 2021-03-10 | Lakewood Villa | Sacramento | 1 | 14 | 0 | 1 | 67 | <11 | <11 | ||
19395 | 19395 | 2021-03-10 | Meadows At Country Place, The | Sacramento | 17 | 24 | 0 | 11 | 67 | ||||
19396 | 19396 | 2021-03-10 | Meadows Senior Living, The | Sacramento | 12 | 20 | 0 | 1 | 67 | <11 | |||
19397 | 19397 | 2021-03-10 | Mercy Mcmahon Terrace | Sacramento | 1 | 1 | 0 | 0 | 67 | <11 | <11 | ||
19398 | 19398 | 2021-03-10 | Oakmont Of Carmichael | Sacramento | 22 | 40 | 0 | 1 | 67 | <11 | |||
19399 | 19399 | 2021-03-10 | Oakmont Of Fair Oaks | Sacramento | 26 | 53 | 0 | 1 | 67 | <11 | |||
19400 | 19400 | 2021-03-10 | Oakmont Of Folsom | Sacramento | 13 | 34 | 0 | 1 | 67 | <11 | |||
19401 | 19401 | 2021-03-10 | Oars At Greenback Lane, The | Sacramento | 1 | 1 | 0 | 0 | 67 | <11 | <11 | ||
19402 | 19402 | 2021-03-10 | Prairie City Landing | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
19403 | 19403 | 2021-03-10 | Revere Court | Sacramento | 27 | 42 | 0 | 1 | 67 | <11 | |||
19404 | 19404 | 2021-03-10 | Sky Park Gardens | Sacramento | 34 | 30 | 0 | 1 | 67 | <11 | |||
19405 | 19405 | 2021-03-10 | Spiva Acres | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
19406 | 19406 | 2021-03-10 | Summerset Assisted Living | Sacramento | 1 | 24 | 0 | 1 | 67 | <11 | <11 | ||
19407 | 19407 | 2021-03-10 | Sun Oak Assisted Living | Sacramento | 17 | 22 | 0 | 1 | 67 | <11 | |||
19408 | 19408 | 2021-03-10 | Sunrise Assisted Living Of Carmichael | Sacramento | 14 | 14 | 0 | 0 | 67 | ||||
19409 | 19409 | 2021-03-10 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
19410 | 19410 | 2021-03-10 | Sunrise Assisted Living Of Sacramento | Sacramento | 25 | 25 | 0 | 1 | 67 | <11 | |||
19411 | 19411 | 2021-03-10 | Walnut House | Sacramento | 1 | 38 | 0 | 1 | 67 | <11 | <11 | ||
19412 | 19412 | 2021-03-10 | 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 );