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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
2649 | 2649 | 2021-04-27 | Chalet, The | Sacramento | 1 | 17 | 1 | 1 | 67 | <11 | <11 | <11 | |
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 | ||||
2654 | 2654 | 2021-04-27 | Courte At Citrus Heights, The | Sacramento | 1 | 27 | 0 | 1 | 67 | <11 | <11 | ||
2655 | 2655 | 2021-04-27 | Ehimas Residential Care | Sacramento | 1 | 15 | 0 | 0 | 67 | <11 | |||
2656 | 2656 | 2021-04-27 | Elk Gove Park Asst. Lvg And Memory Care Community | Sacramento | 18 | 22 | 0 | 1 | 67 | <11 | |||
2657 | 2657 | 2021-04-27 | Empire Ranch Alzheimer's Special Care Center | Sacramento | 1 | 11 | 0 | 0 | 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 | ||
2660 | 2660 | 2021-04-27 | Fair Oaks Community At Sunset | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
2661 | 2661 | 2021-04-27 | Fair Oaks Estates Inc | Sacramento | 1 | 27 | 0 | 0 | 67 | <11 | |||
2662 | 2662 | 2021-04-27 | Fruitridge Villa | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
2663 | 2663 | 2021-04-27 | Greenhaven Estates | Sacramento | 15 | 1 | 0 | 1 | 67 | <11 | <11 | ||
2664 | 2664 | 2021-04-27 | Greenhaven Place Independent Lvg And Assisted Lvg | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
2665 | 2665 | 2021-04-27 | Lakewood Villa | Sacramento | 1 | 14 | 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 | |||
2668 | 2668 | 2021-04-27 | Mercy Mcmahon Terrace | Sacramento | 1 | 1 | 0 | 0 | 67 | <11 | <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 | ||||
2673 | 2673 | 2021-04-27 | Prairie City Landing | Sacramento | 1 | 14 | 0 | 1 | 67 | <11 | <11 | ||
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 | |||
2676 | 2676 | 2021-04-27 | Spiva Acres | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
2677 | 2677 | 2021-04-27 | Summerset Assisted Living | Sacramento | 1 | 24 | 0 | 1 | 67 | <11 | <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 | |||
2682 | 2682 | 2021-04-27 | Walnut House | Sacramento | 1 | 38 | 0 | 1 | 67 | <11 | <11 | ||
2683 | 2683 | 2021-04-27 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
3687 | 3687 | 2021-04-21 | Acc Maple Tree Village | Sacramento | 1 | 1 | 0 | 0 | 67 | <11 | <11 | ||
3688 | 3688 | 2021-04-21 | Almond Avenue Residence Club | Sacramento | 1 | 20 | 0 | 1 | 67 | <11 | <11 | ||
3689 | 3689 | 2021-04-21 | Almond Heights | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
3690 | 3690 | 2021-04-21 | Apple Ridge Assisted Living | Sacramento | 1 | 16 | 0 | 0 | 67 | <11 | |||
3691 | 3691 | 2021-04-21 | Atria Carmichael Oaks | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
3692 | 3692 | 2021-04-21 | Atria El Camino Gardens | Sacramento | 27 | 32 | 0 | 1 | 67 | <11 | |||
3693 | 3693 | 2021-04-21 | Brookdale Citrus Heights | Sacramento | 1 | 1 | 0 | 0 | 67 | <11 | <11 | ||
3694 | 3694 | 2021-04-21 | Carlton Crown Plaza | Sacramento | 1 | 16 | 0 | 1 | 67 | <11 | <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 | ||||
3698 | 3698 | 2021-04-21 | Chalet, The | Sacramento | 1 | 17 | 1 | 1 | 67 | <11 | <11 | <11 | |
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 | ||||
3703 | 3703 | 2021-04-21 | Courte At Citrus Heights, The | Sacramento | 1 | 27 | 0 | 1 | 67 | <11 | <11 | ||
3704 | 3704 | 2021-04-21 | Ehimas Residential Care | Sacramento | 1 | 15 | 0 | 0 | 67 | <11 | |||
3705 | 3705 | 2021-04-21 | Elk Gove Park Asst. Lvg And Memory Care Community | Sacramento | 18 | 22 | 0 | 1 | 67 | <11 | |||
3706 | 3706 | 2021-04-21 | Empire Ranch Alzheimer's Special Care Center | Sacramento | 1 | 11 | 0 | 0 | 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 | ||
3709 | 3709 | 2021-04-21 | Fair Oaks Community At Sunset | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
3710 | 3710 | 2021-04-21 | Fair Oaks Estates Inc | Sacramento | 1 | 27 | 0 | 0 | 67 | <11 | |||
3711 | 3711 | 2021-04-21 | Fruitridge Villa | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
3712 | 3712 | 2021-04-21 | Greenhaven Estates | Sacramento | 15 | 1 | 0 | 1 | 67 | <11 | <11 | ||
3713 | 3713 | 2021-04-21 | Greenhaven Place Independent Lvg And Assisted Lvg | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
3714 | 3714 | 2021-04-21 | Lakewood Villa | Sacramento | 1 | 14 | 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 | |||
3717 | 3717 | 2021-04-21 | Mercy Mcmahon Terrace | Sacramento | 1 | 1 | 0 | 0 | 67 | <11 | <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 | ||||
3722 | 3722 | 2021-04-21 | Prairie City Landing | Sacramento | 1 | 14 | 0 | 1 | 67 | <11 | <11 | ||
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 | |||
3725 | 3725 | 2021-04-21 | Spiva Acres | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
3726 | 3726 | 2021-04-21 | Summerset Assisted Living | Sacramento | 1 | 24 | 0 | 1 | 67 | <11 | <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 | |||
3731 | 3731 | 2021-04-21 | Walnut House | Sacramento | 1 | 38 | 0 | 1 | 67 | <11 | <11 | ||
3732 | 3732 | 2021-04-21 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 | ||||
4735 | 4735 | 2021-04-06 | Almond Avenue Residence Club | Sacramento | 1 | 20 | 0 | 1 | 67 | <11 | <11 | ||
4736 | 4736 | 2021-04-06 | Almond Heights | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
4737 | 4737 | 2021-04-06 | Apple Ridge Assisted Living | Sacramento | 1 | 16 | 0 | 0 | 67 | <11 | |||
4738 | 4738 | 2021-04-06 | Atria Carmichael Oaks | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
4739 | 4739 | 2021-04-06 | Atria El Camino Gardens | Sacramento | 27 | 32 | 0 | 1 | 67 | <11 | |||
4740 | 4740 | 2021-04-06 | Brookdale Citrus Heights | Sacramento | 1 | 1 | 0 | 0 | 67 | <11 | <11 | ||
4741 | 4741 | 2021-04-06 | Carlton Crown Plaza | Sacramento | 1 | 16 | 0 | 1 | 67 | <11 | <11 | ||
4742 | 4742 | 2021-04-06 | Carlton Plaza Of Elk Grove | Sacramento | 32 | 21 | 0 | 1 | 67 | <11 | |||
4743 | 4743 | 2021-04-06 | Carlton Plaza Of Sacramento | Sacramento | 36 | 34 | 0 | 1 | 67 | <11 | |||
4744 | 4744 | 2021-04-06 | Carlton Senior Living Orangevale | Sacramento | 28 | 18 | 0 | 0 | 67 | ||||
4745 | 4745 | 2021-04-06 | Chalet, The | Sacramento | 1 | 17 | 1 | 1 | 67 | <11 | <11 | <11 | |
4746 | 4746 | 2021-04-06 | Chateau At River's Edge, The | Sacramento | 12 | 19 | 0 | 1 | 67 | <11 | |||
4747 | 4747 | 2021-04-06 | Citrus Heights Terrace | Sacramento | 12 | 30 | 0 | 1 | 67 | <11 | |||
4748 | 4748 | 2021-04-06 | City Creek Assisted Living | Sacramento | 15 | 43 | 0 | 1 | 67 | <11 | |||
4749 | 4749 | 2021-04-06 | Country Club Manor | Sacramento | 23 | 33 | 0 | 0 | 67 | ||||
4750 | 4750 | 2021-04-06 | Courte At Citrus Heights, The | Sacramento | 1 | 27 | 0 | 1 | 67 | <11 | <11 |
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 );