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
5,390 rows where county = "Sacramento" sorted by patients_deaths descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: staff_confirmed_cases_note, staff_deaths_note, date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
116249 | 116249 | 2020-05-07 | Carlton Plaza of Elk Grove | Sacramento | 0 | 1 | 67 | <11 | |||||
116250 | 116250 | 2020-05-07 | Eskaton Gold River | Sacramento | 0 | 1 | 67 | <11 | |||||
116251 | 116251 | 2020-05-07 | Oakmont of Folsom | Sacramento | 1 | 19 | 67 | <11 | |||||
116252 | 116252 | 2020-05-07 | Summerset Senior Living | Sacramento | 0 | 1 | 67 | <11 | |||||
116253 | 116253 | 2020-05-07 | Sunrise Assisted Living of Fair Oaks | Sacramento | 1 | 17 | 67 | <11 | |||||
116254 | 116254 | 2020-05-07 | Sunrise Assisted Living of Sacramento | Sacramento | 23 | 25 | 67 | ||||||
116301 | 116301 | 2020-05-06 | Oakmont of Folsom | Sacramento | 1 | 19 | 67 | <11 | |||||
116302 | 116302 | 2020-05-06 | Sunrise Assisted Living of Fair Oaks | Sacramento | 1 | 17 | 67 | <11 | |||||
116303 | 116303 | 2020-05-06 | Sunrise Assisted Living of Sacramento | Sacramento | 23 | 25 | 67 | ||||||
116340 | 116340 | 2020-05-05 | Oakmont of Folsom | Sacramento | 1 | 19 | 67 | <11 | |||||
116341 | 116341 | 2020-05-05 | Sunrise Assisted Living of Fair Oaks | Sacramento | 1 | 17 | 67 | <11 | |||||
116342 | 116342 | 2020-05-05 | Sunrise Assisted Living of Sacramento | Sacramento | 23 | 25 | 67 | ||||||
116377 | 116377 | 2020-05-04 | Oakmont of Folsom | Sacramento | 1 | 18 | 67 | <11 | |||||
116378 | 116378 | 2020-05-04 | Sunrise Assisted Living of Fair Oaks | Sacramento | 1 | 17 | 67 | <11 | |||||
116379 | 116379 | 2020-05-04 | Sunrise Assisted Living of Sacramento | Sacramento | 23 | 25 | 67 | ||||||
116414 | 116414 | 2020-05-02 | Oakmont of Folsom | Sacramento | 1 | 18 | 67 | <11 | |||||
116415 | 116415 | 2020-05-02 | Sunrise Assisted Living of Fair Oaks | Sacramento | 1 | 17 | 67 | <11 | |||||
116416 | 116416 | 2020-05-02 | Sunrise Assisted Living of Sacramento | Sacramento | 23 | 25 | 67 | ||||||
116450 | 116450 | 2020-05-01 | Oakmont of Folsom | Sacramento | 1 | 18 | 67 | <11 | |||||
116451 | 116451 | 2020-05-01 | Sunrise Assisted Living of Fair Oaks | Sacramento | 1 | 17 | 67 | <11 | |||||
116452 | 116452 | 2020-05-01 | Sunrise Assisted Living of Sacramento | Sacramento | 23 | 25 | 67 | ||||||
116483 | 116483 | 2020-04-30 | Oakmont of Folsom | Sacramento | 1 | 18 | 67 | <11 | |||||
116484 | 116484 | 2020-04-30 | Sunrise Assisted Living of Fair Oaks | Sacramento | 1 | 17 | 67 | <11 | |||||
116485 | 116485 | 2020-04-30 | Sunrise Assisted Living of Sacramento | Sacramento | 23 | 25 | 67 | ||||||
116516 | 116516 | 2020-04-28 | Oakmont of Folsom | Sacramento | 1 | 18 | 67 | <11 | |||||
116517 | 116517 | 2020-04-28 | Sunrise Assisted Living of Fair Oaks | Sacramento | 1 | 17 | 67 | <11 | |||||
116518 | 116518 | 2020-04-28 | Sunrise Assisted Living of Sacramento | Sacramento | 23 | 25 | 67 | ||||||
116548 | 116548 | 2020-04-27 | Oakmont of Folsom | Sacramento | 1 | 17 | 67 | <11 | |||||
116549 | 116549 | 2020-04-27 | Sunrise Assisted Living of Fair Oaks | Sacramento | 1 | 17 | 67 | <11 | |||||
116550 | 116550 | 2020-04-27 | Sunrise Assisted Living of Sacramento | Sacramento | 23 | 25 | 67 | ||||||
116580 | 116580 | 2020-04-26 | Oakmont of Folsom | Sacramento | 1 | 17 | 67 | <11 | |||||
116581 | 116581 | 2020-04-26 | Sunrise Assisted Living of Fair Oaks | Sacramento | 1 | 17 | 67 | <11 | |||||
116582 | 116582 | 2020-04-26 | Sunrise Assisted Living of Sacramento | Sacramento | 23 | 25 | 67 | ||||||
116605 | 116605 | 2020-04-19 | SUNRISE ASSISTED LIVING OF FAIR OAKS | Sacramento | 16 | 1 | 67 | <11 | |||||
116606 | 116606 | 2020-04-19 | SUNRISE ASSISTED LIVING OF SACRAMENTO | Sacramento | 25 | 23 | 67 | ||||||
634 | 634 | 2021-06-27 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
1648 | 1648 | 2021-05-11 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
2683 | 2683 | 2021-04-27 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
3732 | 3732 | 2021-04-21 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
4779 | 4779 | 2021-04-06 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
5826 | 5826 | 2021-03-30 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
6873 | 6873 | 2021-03-29 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
7920 | 7920 | 2021-03-25 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
8967 | 8967 | 2021-03-24 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
10014 | 10014 | 2021-03-23 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
11060 | 11060 | 2021-03-22 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
12106 | 12106 | 2021-03-19 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
13151 | 13151 | 2021-03-18 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
14195 | 14195 | 2021-03-17 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
15239 | 15239 | 2021-03-16 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
16283 | 16283 | 2021-03-15 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
17327 | 17327 | 2021-03-12 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
18370 | 18370 | 2021-03-11 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
19412 | 19412 | 2021-03-10 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
20454 | 20454 | 2021-03-09 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
21460 | 21460 | 2021-03-08 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
22483 | 22483 | 2021-03-04 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
23523 | 23523 | 2021-03-03 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
24563 | 24563 | 2021-03-02 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
25602 | 25602 | 2021-03-01 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
26639 | 26639 | 2021-02-26 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
27676 | 27676 | 2021-02-25 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
28712 | 28712 | 2021-02-24 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
29746 | 29746 | 2021-02-22 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
30780 | 30780 | 2021-02-19 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
31814 | 31814 | 2021-02-18 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
32847 | 32847 | 2021-02-17 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
33878 | 33878 | 2021-02-16 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
34907 | 34907 | 2021-02-12 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
35934 | 35934 | 2021-02-11 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
36959 | 36959 | 2021-02-10 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
37984 | 37984 | 2021-02-09 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
39008 | 39008 | 2021-02-08 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
40028 | 40028 | 2021-02-05 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
41043 | 41043 | 2021-02-04 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
42054 | 42054 | 2021-02-03 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
43062 | 43062 | 2021-02-02 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
44068 | 44068 | 2021-02-01 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
45071 | 45071 | 2021-01-29 | Waterleaf At Land Park, The | Sacramento | 20 | 44 | 0 | 18 | 67 | ||||
46066 | 46066 | 2021-01-28 | Waterleaf At Land Park, The | Sacramento | 20 | 44 | 0 | 18 | 67 | ||||
47065 | 47065 | 2021-01-27 | Waterleaf At Land Park, The | Sacramento | 20 | 44 | 0 | 18 | 67 | ||||
48027 | 48027 | 2021-01-26 | Waterleaf At Land Park, The | Sacramento | 20 | 44 | 0 | 18 | 67 | ||||
49001 | 49001 | 2021-01-25 | Waterleaf At Land Park, The | Sacramento | 20 | 44 | 0 | 18 | 67 | ||||
49950 | 49950 | 2021-01-21 | Waterleaf At Land Park, The | Sacramento | 20 | 43 | 0 | 15 | 67 | ||||
50900 | 50900 | 2021-01-20 | Waterleaf At Land Park, The | Sacramento | 20 | 43 | 0 | 15 | 67 | ||||
51860 | 51860 | 2021-01-19 | Waterleaf At Land Park, The | Sacramento | 20 | 43 | 0 | 15 | 67 | ||||
52804 | 52804 | 2021-01-15 | Waterleaf At Land Park, The | Sacramento | 20 | 43 | 0 | 15 | 67 | ||||
53718 | 53718 | 2021-01-14 | Waterleaf At Land Park, The | Sacramento | 20 | 43 | 0 | 15 | 67 | ||||
54640 | 54640 | 2021-01-13 | Waterleaf At Land Park, The | Sacramento | 20 | 43 | 0 | 15 | 67 | ||||
55554 | 55554 | 2021-01-12 | Waterleaf At Land Park, The | Sacramento | 20 | 43 | 0 | 15 | 67 | ||||
56463 | 56463 | 2021-01-11 | Waterleaf At Land Park, The | Sacramento | 20 | 43 | 0 | 15 | 67 | ||||
57355 | 57355 | 2021-01-08 | Waterleaf At Land Park, The | Sacramento | 20 | 43 | 0 | 15 | 67 | ||||
58232 | 58232 | 2021-01-07 | Waterleaf At Land Park, The | Sacramento | 20 | 43 | 0 | 15 | 67 | ||||
59097 | 59097 | 2021-01-06 | Waterleaf At Land Park, The | Sacramento | 20 | 43 | 0 | 15 | 67 | ||||
59951 | 59951 | 2021-01-05 | Waterleaf At Land Park, The | Sacramento | 20 | 43 | 0 | 15 | 67 | ||||
60793 | 60793 | 2021-01-04 | Waterleaf At Land Park, The | Sacramento | 20 | 43 | 0 | 15 | 67 | ||||
61606 | 61606 | 2020-12-31 | Waterleaf At Land Park, The | Sacramento | 20 | 43 | 0 | 15 | 67 | ||||
617 | 617 | 2021-06-27 | Meadows At Country Place, The | Sacramento | 17 | 24 | 0 | 11 | 67 | ||||
1631 | 1631 | 2021-05-11 | Meadows At Country Place, The | Sacramento | 17 | 24 | 0 | 11 | 67 | ||||
2666 | 2666 | 2021-04-27 | Meadows At Country Place, The | Sacramento | 17 | 24 | 0 | 11 | 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 );