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
2,790 rows where county = "San Joaquin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: patients_deaths, patients_confirmed_cases_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
796 | 796 | 2021-06-27 | Astoria Gardens | San Joaquin | 1 | 1 | 0 | 1 | 77 | <11 | <11 | <11 | |
797 | 797 | 2021-06-27 | Balance Assisted Living And Memory Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
798 | 798 | 2021-06-27 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
799 | 799 | 2021-06-27 | Brookdale Kettleman Lane | San Joaquin | 1 | 35 | 0 | 1 | 77 | <11 | <11 | ||
800 | 800 | 2021-06-27 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
801 | 801 | 2021-06-27 | Camlu Assisted Living | San Joaquin | 1 | 36 | 0 | 1 | 77 | <11 | <11 | ||
802 | 802 | 2021-06-27 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
803 | 803 | 2021-06-27 | Commons At Union Ranch, The | San Joaquin | 16 | 30 | 0 | 1 | 77 | <11 | |||
804 | 804 | 2021-06-27 | Commons On Thornton, The | San Joaquin | 24 | 24 | 0 | 1 | 77 | <11 | |||
805 | 805 | 2021-06-27 | Courtyard At Rio Las Palmas, The | San Joaquin | 18 | 1 | 0 | 1 | 77 | <11 | <11 | ||
806 | 806 | 2021-06-27 | Diamond Care Inc. | San Joaquin | 1 | 1 | 0 | 1 | 77 | <11 | <11 | <11 | |
807 | 807 | 2021-06-27 | Golden Haven | San Joaquin | 15 | 51 | 0 | 1 | 77 | <11 | |||
808 | 808 | 2021-06-27 | Haynes Board And Care | San Joaquin | 1 | 19 | 0 | 1 | 77 | <11 | <11 | ||
809 | 809 | 2021-06-27 | Manteca Rtrmt Com-Happy Lvng By Cogir/Cogir Mantec | San Joaquin | 18 | 24 | 0 | 1 | 77 | <11 | |||
810 | 810 | 2021-06-27 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
811 | 811 | 2021-06-27 | Oakmont Of Brookside | San Joaquin | 1 | 1 | 0 | 1 | 77 | <11 | <11 | <11 | |
812 | 812 | 2021-06-27 | Plymouth Square | San Joaquin | 1 | 1 | 0 | 1 | 77 | <11 | <11 | <11 | |
813 | 813 | 2021-06-27 | Prestige Assisted Living At Manteca | San Joaquin | 1 | 1 | 0 | 1 | 77 | <11 | <11 | <11 | |
814 | 814 | 2021-06-27 | River Fountains Of Lodi | San Joaquin | 16 | 46 | 0 | 1 | 77 | <11 | |||
815 | 815 | 2021-06-27 | Rose Place Memory Care | San Joaquin | 16 | 34 | 0 | 1 | 77 | <11 | |||
816 | 816 | 2021-06-27 | Somerford Place - Stockton | San Joaquin | 13 | 22 | 0 | 1 | 77 | <11 | |||
817 | 817 | 2021-06-27 | Stacie's Chalet Stockton | San Joaquin | 11 | 42 | 0 | 1 | 77 | <11 | |||
818 | 818 | 2021-06-27 | Tender Loving Care Guest Home | San Joaquin | 0 | 1 | 0 | 1 | 77 | <11 | <11 | ||
819 | 819 | 2021-06-27 | Wagner Heights Residential | San Joaquin | 14 | 39 | 0 | 1 | 77 | <11 | |||
1801 | 1801 | 2021-05-11 | Astoria Gardens | San Joaquin | 1 | 1 | 0 | 1 | 77 | <11 | <11 | <11 | |
1802 | 1802 | 2021-05-11 | Balance Assisted Living And Memory Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
1803 | 1803 | 2021-05-11 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
1804 | 1804 | 2021-05-11 | Brookdale Kettleman Lane | San Joaquin | 1 | 35 | 0 | 1 | 77 | <11 | <11 | ||
1805 | 1805 | 2021-05-11 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
1806 | 1806 | 2021-05-11 | Camlu Assisted Living | San Joaquin | 1 | 36 | 0 | 1 | 77 | <11 | <11 | ||
1807 | 1807 | 2021-05-11 | Commons At Union Ranch, The | San Joaquin | 16 | 30 | 0 | 1 | 77 | <11 | |||
1808 | 1808 | 2021-05-11 | Commons On Thornton, The | San Joaquin | 24 | 24 | 0 | 1 | 77 | <11 | |||
1809 | 1809 | 2021-05-11 | Courtyard At Rio Las Palmas, The | San Joaquin | 18 | 1 | 0 | 1 | 77 | <11 | <11 | ||
1810 | 1810 | 2021-05-11 | Diamond Care Inc. | San Joaquin | 1 | 1 | 0 | 1 | 77 | <11 | <11 | <11 | |
1811 | 1811 | 2021-05-11 | Golden Haven | San Joaquin | 15 | 51 | 0 | 1 | 77 | <11 | |||
1812 | 1812 | 2021-05-11 | Manteca Rtrmt Com-Happy Lvng By Cogir/Cogir Mantec | San Joaquin | 18 | 24 | 0 | 1 | 77 | <11 | |||
1813 | 1813 | 2021-05-11 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
1814 | 1814 | 2021-05-11 | Oakmont Of Brookside | San Joaquin | 1 | 1 | 0 | 1 | 77 | <11 | <11 | <11 | |
1815 | 1815 | 2021-05-11 | Plymouth Square | San Joaquin | 1 | 1 | 0 | 1 | 77 | <11 | <11 | <11 | |
1816 | 1816 | 2021-05-11 | Prestige Assisted Living At Manteca | San Joaquin | 1 | 1 | 0 | 1 | 77 | <11 | <11 | <11 | |
1817 | 1817 | 2021-05-11 | River Fountains Of Lodi | San Joaquin | 16 | 46 | 0 | 1 | 77 | <11 | |||
1818 | 1818 | 2021-05-11 | Rose Place Memory Care | San Joaquin | 16 | 34 | 0 | 1 | 77 | <11 | |||
1819 | 1819 | 2021-05-11 | Somerford Place - Stockton | San Joaquin | 13 | 22 | 0 | 1 | 77 | <11 | |||
1820 | 1820 | 2021-05-11 | Stacie's Chalet Stockton | San Joaquin | 11 | 42 | 0 | 1 | 77 | <11 | |||
1821 | 1821 | 2021-05-11 | Tender Loving Care Guest Home | San Joaquin | 0 | 1 | 0 | 1 | 77 | <11 | <11 | ||
1822 | 1822 | 2021-05-11 | Wagner Heights Residential | San Joaquin | 14 | 39 | 0 | 1 | 77 | <11 | |||
2843 | 2843 | 2021-04-27 | Astoria Gardens | San Joaquin | 1 | 1 | 0 | 1 | 77 | <11 | <11 | <11 | |
2844 | 2844 | 2021-04-27 | Balance Assisted Living And Memory Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
2845 | 2845 | 2021-04-27 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
2846 | 2846 | 2021-04-27 | Brookdale Kettleman Lane | San Joaquin | 1 | 35 | 0 | 1 | 77 | <11 | <11 | ||
2847 | 2847 | 2021-04-27 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
2848 | 2848 | 2021-04-27 | Camlu Assisted Living | San Joaquin | 1 | 36 | 0 | 1 | 77 | <11 | <11 | ||
2849 | 2849 | 2021-04-27 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
2850 | 2850 | 2021-04-27 | Commons At Union Ranch, The | San Joaquin | 16 | 30 | 0 | 1 | 77 | <11 | |||
2851 | 2851 | 2021-04-27 | Commons On Thornton, The | San Joaquin | 24 | 24 | 0 | 1 | 77 | <11 | |||
2852 | 2852 | 2021-04-27 | Courtyard At Rio Las Palmas, The | San Joaquin | 18 | 1 | 0 | 1 | 77 | <11 | <11 | ||
2853 | 2853 | 2021-04-27 | Diamond Care Inc. | San Joaquin | 1 | 1 | 0 | 1 | 77 | <11 | <11 | <11 | |
2854 | 2854 | 2021-04-27 | Golden Haven | San Joaquin | 15 | 51 | 0 | 1 | 77 | <11 | |||
2855 | 2855 | 2021-04-27 | Haynes Board And Care | San Joaquin | 1 | 19 | 0 | 1 | 77 | <11 | <11 | ||
2856 | 2856 | 2021-04-27 | Manteca Rtrmt Com-Happy Lvng By Cogir/Cogir Mantec | San Joaquin | 18 | 24 | 0 | 1 | 77 | <11 | |||
2857 | 2857 | 2021-04-27 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
2858 | 2858 | 2021-04-27 | Oakmont Of Brookside | San Joaquin | 1 | 1 | 0 | 1 | 77 | <11 | <11 | <11 | |
2859 | 2859 | 2021-04-27 | Plymouth Square | San Joaquin | 1 | 1 | 0 | 1 | 77 | <11 | <11 | <11 | |
2860 | 2860 | 2021-04-27 | Prestige Assisted Living At Manteca | San Joaquin | 1 | 1 | 0 | 1 | 77 | <11 | <11 | <11 | |
2861 | 2861 | 2021-04-27 | River Fountains Of Lodi | San Joaquin | 16 | 46 | 0 | 1 | 77 | <11 | |||
2862 | 2862 | 2021-04-27 | Rose Place Memory Care | San Joaquin | 16 | 34 | 0 | 1 | 77 | <11 | |||
2863 | 2863 | 2021-04-27 | Somerford Place - Stockton | San Joaquin | 13 | 22 | 0 | 1 | 77 | <11 | |||
2864 | 2864 | 2021-04-27 | Stacie's Chalet Stockton | San Joaquin | 11 | 42 | 0 | 1 | 77 | <11 | |||
2865 | 2865 | 2021-04-27 | Tender Loving Care Guest Home | San Joaquin | 0 | 1 | 0 | 1 | 77 | <11 | <11 | ||
2866 | 2866 | 2021-04-27 | Wagner Heights Residential | San Joaquin | 14 | 39 | 0 | 1 | 77 | <11 | |||
3892 | 3892 | 2021-04-21 | Astoria Gardens | San Joaquin | 1 | 1 | 0 | 1 | 77 | <11 | <11 | <11 | |
3893 | 3893 | 2021-04-21 | Balance Assisted Living And Memory Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
3894 | 3894 | 2021-04-21 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
3895 | 3895 | 2021-04-21 | Brookdale Kettleman Lane | San Joaquin | 1 | 35 | 0 | 1 | 77 | <11 | <11 | ||
3896 | 3896 | 2021-04-21 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
3897 | 3897 | 2021-04-21 | Camlu Assisted Living | San Joaquin | 1 | 36 | 0 | 1 | 77 | <11 | <11 | ||
3898 | 3898 | 2021-04-21 | Chesney Professional Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
3899 | 3899 | 2021-04-21 | Commons At Union Ranch, The | San Joaquin | 16 | 30 | 0 | 1 | 77 | <11 | |||
3900 | 3900 | 2021-04-21 | Commons On Thornton, The | San Joaquin | 24 | 24 | 0 | 1 | 77 | <11 | |||
3901 | 3901 | 2021-04-21 | Courtyard At Rio Las Palmas, The | San Joaquin | 18 | 1 | 0 | 1 | 77 | <11 | <11 | ||
3902 | 3902 | 2021-04-21 | Diamond Care Inc. | San Joaquin | 1 | 1 | 0 | 1 | 77 | <11 | <11 | <11 | |
3903 | 3903 | 2021-04-21 | Golden Haven | San Joaquin | 15 | 51 | 0 | 1 | 77 | <11 | |||
3904 | 3904 | 2021-04-21 | Haynes Board And Care | San Joaquin | 1 | 19 | 0 | 1 | 77 | <11 | <11 | ||
3905 | 3905 | 2021-04-21 | Manteca Rtrmt Com-Happy Lvng By Cogir/Cogir Mantec | San Joaquin | 18 | 24 | 0 | 1 | 77 | <11 | |||
3906 | 3906 | 2021-04-21 | O'connor Woods Assisted Living | San Joaquin | 31 | 14 | 0 | 1 | 77 | <11 | |||
3907 | 3907 | 2021-04-21 | Oakmont Of Brookside | San Joaquin | 1 | 1 | 0 | 1 | 77 | <11 | <11 | <11 | |
3908 | 3908 | 2021-04-21 | Plymouth Square | San Joaquin | 1 | 1 | 0 | 1 | 77 | <11 | <11 | <11 | |
3909 | 3909 | 2021-04-21 | Prestige Assisted Living At Manteca | San Joaquin | 1 | 1 | 0 | 1 | 77 | <11 | <11 | <11 | |
3910 | 3910 | 2021-04-21 | River Fountains Of Lodi | San Joaquin | 16 | 46 | 0 | 1 | 77 | <11 | |||
3911 | 3911 | 2021-04-21 | Rose Place Memory Care | San Joaquin | 16 | 34 | 0 | 1 | 77 | <11 | |||
3912 | 3912 | 2021-04-21 | Somerford Place - Stockton | San Joaquin | 13 | 22 | 0 | 1 | 77 | <11 | |||
3913 | 3913 | 2021-04-21 | Stacie's Chalet Stockton | San Joaquin | 11 | 42 | 0 | 1 | 77 | <11 | |||
3914 | 3914 | 2021-04-21 | Tender Loving Care Guest Home | San Joaquin | 0 | 1 | 0 | 1 | 77 | <11 | <11 | ||
3915 | 3915 | 2021-04-21 | Wagner Heights Residential | San Joaquin | 14 | 39 | 0 | 1 | 77 | <11 | |||
4939 | 4939 | 2021-04-06 | Astoria Gardens | San Joaquin | 1 | 1 | 0 | 1 | 77 | <11 | <11 | <11 | |
4940 | 4940 | 2021-04-06 | Balance Assisted Living And Memory Care | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
4941 | 4941 | 2021-04-06 | Beth Haven | San Joaquin | 1 | 1 | 0 | 0 | 77 | <11 | <11 | ||
4942 | 4942 | 2021-04-06 | Brookdale Kettleman Lane | San Joaquin | 1 | 35 | 0 | 1 | 77 | <11 | <11 | ||
4943 | 4943 | 2021-04-06 | Brookdale Tracy | San Joaquin | 22 | 43 | 0 | 1 | 77 | <11 | |||
4944 | 4944 | 2021-04-06 | Camlu Assisted Living | San Joaquin | 1 | 36 | 0 | 1 | 77 | <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 );