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 staff_confirmed_cases_note
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: patients_deaths, patients_confirmed_cases_note, staff_deaths_note, patients_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
594 | 594 | 2021-06-27 | Atria El Camino Gardens | Sacramento | 27 | 32 | 0 | 1 | 67 | <11 | |||
597 | 597 | 2021-06-27 | Carlton Plaza Of Elk Grove | Sacramento | 32 | 21 | 0 | 1 | 67 | <11 | |||
598 | 598 | 2021-06-27 | Carlton Plaza Of Sacramento | Sacramento | 39 | 34 | 0 | 1 | 67 | <11 | |||
599 | 599 | 2021-06-27 | Carlton Senior Living Orangevale | Sacramento | 30 | 18 | 0 | 0 | 67 | ||||
601 | 601 | 2021-06-27 | Chateau At River's Edge, The | Sacramento | 13 | 19 | 0 | 1 | 67 | <11 | |||
602 | 602 | 2021-06-27 | Citrus Heights Terrace | Sacramento | 13 | 30 | 0 | 1 | 67 | <11 | |||
603 | 603 | 2021-06-27 | City Creek Assisted Living | Sacramento | 15 | 43 | 0 | 1 | 67 | <11 | |||
604 | 604 | 2021-06-27 | Country Club Manor | Sacramento | 23 | 33 | 0 | 0 | 67 | ||||
607 | 607 | 2021-06-27 | Elk Grove Park Asst. Lvg And Memory Care Community | Sacramento | 18 | 22 | 0 | 1 | 67 | <11 | |||
609 | 609 | 2021-06-27 | Eskaton Gold River Lodge | Sacramento | 18 | 25 | 0 | 1 | 67 | <11 | |||
610 | 610 | 2021-06-27 | Eskaton Village | Sacramento | 33 | 21 | 1 | 1 | 67 | <11 | <11 | ||
614 | 614 | 2021-06-27 | Greenhaven Estates | Sacramento | 15 | 1 | 0 | 1 | 67 | <11 | <11 | ||
617 | 617 | 2021-06-27 | Meadows At Country Place, The | Sacramento | 17 | 24 | 0 | 11 | 67 | ||||
618 | 618 | 2021-06-27 | Meadows Senior Living, The | Sacramento | 12 | 20 | 0 | 1 | 67 | <11 | |||
620 | 620 | 2021-06-27 | Oakmont Of Carmichael | Sacramento | 22 | 41 | 0 | 1 | 67 | <11 | |||
621 | 621 | 2021-06-27 | Oakmont Of Fair Oaks | Sacramento | 26 | 53 | 0 | 1 | 67 | <11 | |||
622 | 622 | 2021-06-27 | Oakmont Of Folsom | Sacramento | 13 | 34 | 0 | 1 | 67 | <11 | |||
623 | 623 | 2021-06-27 | Oars At Greenback Lane, The | Sacramento | 18 | 11 | 0 | 0 | 67 | ||||
625 | 625 | 2021-06-27 | Revere Court | Sacramento | 27 | 42 | 0 | 1 | 67 | <11 | |||
626 | 626 | 2021-06-27 | Sky Park Gardens | Sacramento | 34 | 30 | 0 | 1 | 67 | <11 | |||
629 | 629 | 2021-06-27 | Sun Oak Assisted Living | Sacramento | 17 | 22 | 0 | 1 | 67 | <11 | |||
630 | 630 | 2021-06-27 | Sunrise Assisted Living Of Carmichael | Sacramento | 15 | 14 | 0 | 0 | 67 | ||||
631 | 631 | 2021-06-27 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
632 | 632 | 2021-06-27 | Sunrise Assisted Living Of Sacramento | Sacramento | 25 | 25 | 0 | 1 | 67 | <11 | |||
634 | 634 | 2021-06-27 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
1608 | 1608 | 2021-05-11 | Atria El Camino Gardens | Sacramento | 27 | 32 | 0 | 1 | 67 | <11 | |||
1611 | 1611 | 2021-05-11 | Carlton Plaza Of Elk Grove | Sacramento | 32 | 21 | 0 | 1 | 67 | <11 | |||
1612 | 1612 | 2021-05-11 | Carlton Plaza Of Sacramento | Sacramento | 39 | 34 | 0 | 1 | 67 | <11 | |||
1613 | 1613 | 2021-05-11 | Carlton Senior Living Orangevale | Sacramento | 28 | 18 | 0 | 0 | 67 | ||||
1615 | 1615 | 2021-05-11 | Chateau At River's Edge, The | Sacramento | 13 | 19 | 0 | 1 | 67 | <11 | |||
1616 | 1616 | 2021-05-11 | Citrus Heights Terrace | Sacramento | 13 | 30 | 0 | 1 | 67 | <11 | |||
1617 | 1617 | 2021-05-11 | City Creek Assisted Living | Sacramento | 15 | 43 | 0 | 1 | 67 | <11 | |||
1618 | 1618 | 2021-05-11 | Country Club Manor | Sacramento | 23 | 33 | 0 | 0 | 67 | ||||
1621 | 1621 | 2021-05-11 | Elk Grove Park Asst. Lvg And Memory Care Community | Sacramento | 18 | 22 | 0 | 1 | 67 | <11 | |||
1623 | 1623 | 2021-05-11 | Eskaton Gold River Lodge | Sacramento | 18 | 25 | 0 | 1 | 67 | <11 | |||
1624 | 1624 | 2021-05-11 | Eskaton Village | Sacramento | 31 | 19 | 1 | 1 | 67 | <11 | <11 | ||
1628 | 1628 | 2021-05-11 | Greenhaven Estates | Sacramento | 15 | 1 | 0 | 1 | 67 | <11 | <11 | ||
1631 | 1631 | 2021-05-11 | Meadows At Country Place, The | Sacramento | 17 | 24 | 0 | 11 | 67 | ||||
1632 | 1632 | 2021-05-11 | Meadows Senior Living, The | Sacramento | 12 | 20 | 0 | 1 | 67 | <11 | |||
1634 | 1634 | 2021-05-11 | Oakmont Of Carmichael | Sacramento | 22 | 41 | 0 | 1 | 67 | <11 | |||
1635 | 1635 | 2021-05-11 | Oakmont Of Fair Oaks | Sacramento | 26 | 53 | 0 | 1 | 67 | <11 | |||
1636 | 1636 | 2021-05-11 | Oakmont Of Folsom | Sacramento | 13 | 34 | 0 | 1 | 67 | <11 | |||
1637 | 1637 | 2021-05-11 | Oars At Greenback Lane, The | Sacramento | 18 | 11 | 0 | 0 | 67 | ||||
1639 | 1639 | 2021-05-11 | Revere Court | Sacramento | 27 | 42 | 0 | 1 | 67 | <11 | |||
1640 | 1640 | 2021-05-11 | Sky Park Gardens | Sacramento | 34 | 30 | 0 | 1 | 67 | <11 | |||
1643 | 1643 | 2021-05-11 | Sun Oak Assisted Living | Sacramento | 17 | 22 | 0 | 1 | 67 | <11 | |||
1644 | 1644 | 2021-05-11 | Sunrise Assisted Living Of Carmichael | Sacramento | 15 | 14 | 0 | 0 | 67 | ||||
1645 | 1645 | 2021-05-11 | Sunrise Assisted Living Of Sacramento | Sacramento | 25 | 25 | 0 | 1 | 67 | <11 | |||
1646 | 1646 | 2021-05-11 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
1648 | 1648 | 2021-05-11 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
2643 | 2643 | 2021-04-27 | Atria El Camino Gardens | Sacramento | 27 | 32 | 0 | 1 | 67 | <11 | |||
2646 | 2646 | 2021-04-27 | Carlton Plaza Of Elk Grove | Sacramento | 32 | 21 | 0 | 1 | 67 | <11 | |||
2647 | 2647 | 2021-04-27 | Carlton Plaza Of Sacramento | Sacramento | 37 | 34 | 0 | 1 | 67 | <11 | |||
2648 | 2648 | 2021-04-27 | Carlton Senior Living Orangevale | Sacramento | 28 | 18 | 0 | 0 | 67 | ||||
2650 | 2650 | 2021-04-27 | Chateau At River's Edge, The | Sacramento | 13 | 19 | 0 | 1 | 67 | <11 | |||
2651 | 2651 | 2021-04-27 | Citrus Heights Terrace | Sacramento | 13 | 30 | 0 | 1 | 67 | <11 | |||
2652 | 2652 | 2021-04-27 | City Creek Assisted Living | Sacramento | 15 | 43 | 0 | 1 | 67 | <11 | |||
2653 | 2653 | 2021-04-27 | Country Club Manor | Sacramento | 23 | 33 | 0 | 0 | 67 | ||||
2656 | 2656 | 2021-04-27 | Elk Gove Park Asst. Lvg And Memory Care Community | Sacramento | 18 | 22 | 0 | 1 | 67 | <11 | |||
2658 | 2658 | 2021-04-27 | Eskaton Gold River Lodge | Sacramento | 18 | 25 | 0 | 1 | 67 | <11 | |||
2659 | 2659 | 2021-04-27 | Eskaton Village | Sacramento | 31 | 19 | 1 | 1 | 67 | <11 | <11 | ||
2663 | 2663 | 2021-04-27 | Greenhaven Estates | Sacramento | 15 | 1 | 0 | 1 | 67 | <11 | <11 | ||
2666 | 2666 | 2021-04-27 | Meadows At Country Place, The | Sacramento | 17 | 24 | 0 | 11 | 67 | ||||
2667 | 2667 | 2021-04-27 | Meadows Senior Living, The | Sacramento | 12 | 20 | 0 | 1 | 67 | <11 | |||
2669 | 2669 | 2021-04-27 | Oakmont Of Carmichael | Sacramento | 22 | 41 | 0 | 1 | 67 | <11 | |||
2670 | 2670 | 2021-04-27 | Oakmont Of Fair Oaks | Sacramento | 26 | 53 | 0 | 1 | 67 | <11 | |||
2671 | 2671 | 2021-04-27 | Oakmont Of Folsom | Sacramento | 13 | 34 | 0 | 1 | 67 | <11 | |||
2672 | 2672 | 2021-04-27 | Oars At Greenback Lane, The | Sacramento | 17 | 11 | 0 | 0 | 67 | ||||
2674 | 2674 | 2021-04-27 | Revere Court | Sacramento | 27 | 42 | 0 | 1 | 67 | <11 | |||
2675 | 2675 | 2021-04-27 | Sky Park Gardens | Sacramento | 34 | 30 | 0 | 1 | 67 | <11 | |||
2678 | 2678 | 2021-04-27 | Sun Oak Assisted Living | Sacramento | 17 | 22 | 0 | 1 | 67 | <11 | |||
2679 | 2679 | 2021-04-27 | Sunrise Assisted Living Of Carmichael | Sacramento | 15 | 14 | 0 | 0 | 67 | ||||
2680 | 2680 | 2021-04-27 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
2681 | 2681 | 2021-04-27 | Sunrise Assisted Living Of Sacramento | Sacramento | 25 | 25 | 0 | 1 | 67 | <11 | |||
2683 | 2683 | 2021-04-27 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
3692 | 3692 | 2021-04-21 | Atria El Camino Gardens | Sacramento | 27 | 32 | 0 | 1 | 67 | <11 | |||
3695 | 3695 | 2021-04-21 | Carlton Plaza Of Elk Grove | Sacramento | 32 | 21 | 0 | 1 | 67 | <11 | |||
3696 | 3696 | 2021-04-21 | Carlton Plaza Of Sacramento | Sacramento | 36 | 34 | 0 | 1 | 67 | <11 | |||
3697 | 3697 | 2021-04-21 | Carlton Senior Living Orangevale | Sacramento | 28 | 18 | 0 | 0 | 67 | ||||
3699 | 3699 | 2021-04-21 | Chateau At River's Edge, The | Sacramento | 13 | 19 | 0 | 1 | 67 | <11 | |||
3700 | 3700 | 2021-04-21 | Citrus Heights Terrace | Sacramento | 13 | 30 | 0 | 1 | 67 | <11 | |||
3701 | 3701 | 2021-04-21 | City Creek Assisted Living | Sacramento | 15 | 43 | 0 | 1 | 67 | <11 | |||
3702 | 3702 | 2021-04-21 | Country Club Manor | Sacramento | 23 | 33 | 0 | 0 | 67 | ||||
3705 | 3705 | 2021-04-21 | Elk Gove Park Asst. Lvg And Memory Care Community | Sacramento | 18 | 22 | 0 | 1 | 67 | <11 | |||
3707 | 3707 | 2021-04-21 | Eskaton Gold River Lodge | Sacramento | 18 | 25 | 0 | 1 | 67 | <11 | |||
3708 | 3708 | 2021-04-21 | Eskaton Village | Sacramento | 31 | 19 | 1 | 1 | 67 | <11 | <11 | ||
3712 | 3712 | 2021-04-21 | Greenhaven Estates | Sacramento | 15 | 1 | 0 | 1 | 67 | <11 | <11 | ||
3715 | 3715 | 2021-04-21 | Meadows At Country Place, The | Sacramento | 17 | 24 | 0 | 11 | 67 | ||||
3716 | 3716 | 2021-04-21 | Meadows Senior Living, The | Sacramento | 12 | 20 | 0 | 1 | 67 | <11 | |||
3718 | 3718 | 2021-04-21 | Oakmont Of Carmichael | Sacramento | 22 | 41 | 0 | 1 | 67 | <11 | |||
3719 | 3719 | 2021-04-21 | Oakmont Of Fair Oaks | Sacramento | 26 | 53 | 0 | 1 | 67 | <11 | |||
3720 | 3720 | 2021-04-21 | Oakmont Of Folsom | Sacramento | 13 | 34 | 0 | 1 | 67 | <11 | |||
3721 | 3721 | 2021-04-21 | Oars At Greenback Lane, The | Sacramento | 17 | 11 | 0 | 0 | 67 | ||||
3723 | 3723 | 2021-04-21 | Revere Court | Sacramento | 27 | 42 | 0 | 1 | 67 | <11 | |||
3724 | 3724 | 2021-04-21 | Sky Park Gardens | Sacramento | 34 | 30 | 0 | 1 | 67 | <11 | |||
3727 | 3727 | 2021-04-21 | Sun Oak Assisted Living | Sacramento | 17 | 22 | 0 | 1 | 67 | <11 | |||
3728 | 3728 | 2021-04-21 | Sunrise Assisted Living Of Carmichael | Sacramento | 15 | 14 | 0 | 0 | 67 | ||||
3729 | 3729 | 2021-04-21 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
3730 | 3730 | 2021-04-21 | Sunrise Assisted Living Of Sacramento | Sacramento | 25 | 25 | 0 | 1 | 67 | <11 | |||
3732 | 3732 | 2021-04-21 | 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 );