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,319 rows where county = "Santa Clara" and patients_deaths = 1 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: staff_deaths, patients_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
886 | 886 | 2021-06-27 | Atria Willow Glen | Santa Clara | 12 | 26 | 0 | 1 | 85 | <11 | |||
888 | 888 | 2021-06-27 | Belmont Village Sunnyvale | Santa Clara | 1 | 1 | 0 | 1 | 85 | <11 | <11 | <11 | |
890 | 890 | 2021-06-27 | Brookdale San Jose | Santa Clara | 50 | 37 | 0 | 1 | 85 | <11 | |||
891 | 891 | 2021-06-27 | Campbell Village | Santa Clara | 13 | 22 | 0 | 1 | 85 | <11 | |||
893 | 893 | 2021-06-27 | Cedar Creek Alzheimer's & Dementia Care Center | Santa Clara | 20 | 28 | 0 | 1 | 85 | <11 | |||
894 | 894 | 2021-06-27 | Channing House | Santa Clara | 39 | 13 | 0 | 1 | 85 | <11 | |||
896 | 896 | 2021-06-27 | Crescent Oaks | Santa Clara | 12 | 15 | 0 | 1 | 85 | <11 | |||
900 | 900 | 2021-06-27 | Loma Clara Senior Living | Santa Clara | 1 | 1 | 0 | 1 | 85 | <11 | <11 | <11 | |
901 | 901 | 2021-06-27 | Lytton Gardens Community Care | Santa Clara | 1 | 1 | 0 | 1 | 85 | <11 | <11 | <11 | |
902 | 902 | 2021-06-27 | Merrill Gardens At Campbell | Santa Clara | 34 | 24 | 1 | 1 | 85 | <11 | <11 | ||
903 | 903 | 2021-06-27 | Merrill Gardens At Gilroy | Santa Clara | 1 | 13 | 0 | 1 | 85 | <11 | <11 | ||
906 | 906 | 2021-06-27 | Oakmont Of San Jose | Santa Clara | 1 | 1 | 0 | 1 | 85 | <11 | <11 | <11 | |
907 | 907 | 2021-06-27 | Pacific Gardens | Santa Clara | 24 | 13 | 1 | 1 | 85 | <11 | <11 | ||
911 | 911 | 2021-06-27 | Rose Garden Court | Santa Clara | 1 | 15 | 0 | 1 | 85 | <11 | <11 | ||
912 | 912 | 2021-06-27 | Saratoga Retirement Community | Santa Clara | 18 | 1 | 1 | 1 | 85 | <11 | <11 | <11 | |
913 | 913 | 2021-06-27 | Somerset Senior Living | Santa Clara | 1 | 19 | 0 | 1 | 85 | <11 | <11 | ||
914 | 914 | 2021-06-27 | Sunny View Retirement Community | Santa Clara | 21 | 1 | 0 | 1 | 85 | <11 | <11 | ||
916 | 916 | 2021-06-27 | Sunrise Assisted Living Of Palo Alto | Santa Clara | 21 | 20 | 1 | 1 | 85 | <11 | <11 | ||
917 | 917 | 2021-06-27 | Sunrise Of Sunnyvale | Santa Clara | 12 | 1 | 0 | 1 | 85 | <11 | <11 | ||
918 | 918 | 2021-06-27 | Sunrise Villa San Jose | Santa Clara | 1 | 28 | 0 | 1 | 85 | <11 | <11 | ||
920 | 920 | 2021-06-27 | Terraces Of Los Gatos, The | Santa Clara | 21 | 1 | 0 | 1 | 85 | <11 | <11 | ||
921 | 921 | 2021-06-27 | Vi At Palo Alto | Santa Clara | 48 | 26 | 0 | 1 | 85 | <11 | |||
924 | 924 | 2021-06-27 | Villa Serena Of Morgan Hill | Santa Clara | 1 | 1 | 0 | 1 | 85 | <11 | <11 | <11 | |
1889 | 1889 | 2021-05-11 | Atria Willow Glen | Santa Clara | 12 | 26 | 0 | 1 | 85 | <11 | |||
1891 | 1891 | 2021-05-11 | Belmont Village Sunnyvale | Santa Clara | 1 | 1 | 0 | 1 | 85 | <11 | <11 | <11 | |
1893 | 1893 | 2021-05-11 | Brookdale San Jose | Santa Clara | 50 | 37 | 0 | 1 | 85 | <11 | |||
1894 | 1894 | 2021-05-11 | Campbell Village | Santa Clara | 13 | 22 | 0 | 1 | 85 | <11 | |||
1896 | 1896 | 2021-05-11 | Cedar Creek Alzheimer's & Dementia Care Center | Santa Clara | 20 | 28 | 0 | 1 | 85 | <11 | |||
1897 | 1897 | 2021-05-11 | Channing House | Santa Clara | 39 | 13 | 0 | 1 | 85 | <11 | |||
1898 | 1898 | 2021-05-11 | Crescent Oaks | Santa Clara | 12 | 15 | 0 | 1 | 85 | <11 | |||
1901 | 1901 | 2021-05-11 | Loma Clara Senior Living | Santa Clara | 1 | 1 | 0 | 1 | 85 | <11 | <11 | <11 | |
1902 | 1902 | 2021-05-11 | Lytton Gardens Community Care | Santa Clara | 1 | 1 | 0 | 1 | 85 | <11 | <11 | <11 | |
1903 | 1903 | 2021-05-11 | Merrill Gardens At Campbell | Santa Clara | 34 | 24 | 1 | 1 | 85 | <11 | <11 | ||
1904 | 1904 | 2021-05-11 | Merrill Gardens At Gilroy | Santa Clara | 1 | 13 | 0 | 1 | 85 | <11 | <11 | ||
1907 | 1907 | 2021-05-11 | Oakmont Of San Jose | Santa Clara | 1 | 1 | 0 | 1 | 85 | <11 | <11 | <11 | |
1908 | 1908 | 2021-05-11 | Pacific Gardens | Santa Clara | 24 | 13 | 1 | 1 | 85 | <11 | <11 | ||
1912 | 1912 | 2021-05-11 | Rose Garden Court | Santa Clara | 1 | 15 | 0 | 1 | 85 | <11 | <11 | ||
1913 | 1913 | 2021-05-11 | Saratoga Retirement Community | Santa Clara | 18 | 1 | 1 | 1 | 85 | <11 | <11 | <11 | |
1914 | 1914 | 2021-05-11 | Somerset Senior Living | Santa Clara | 1 | 19 | 0 | 1 | 85 | <11 | <11 | ||
1915 | 1915 | 2021-05-11 | Sunny View Retirement Community | Santa Clara | 21 | 1 | 0 | 1 | 85 | <11 | <11 | ||
1917 | 1917 | 2021-05-11 | Sunrise Assisted Living Of Palo Alto | Santa Clara | 21 | 20 | 1 | 1 | 85 | <11 | <11 | ||
1918 | 1918 | 2021-05-11 | Sunrise Of Sunnyvale | Santa Clara | 12 | 1 | 0 | 1 | 85 | <11 | <11 | ||
1919 | 1919 | 2021-05-11 | Sunrise Villa San Jose | Santa Clara | 1 | 27 | 0 | 1 | 85 | <11 | <11 | ||
1921 | 1921 | 2021-05-11 | Terraces Of Los Gatos, The | Santa Clara | 21 | 1 | 0 | 1 | 85 | <11 | <11 | ||
1922 | 1922 | 2021-05-11 | Vi At Palo Alto | Santa Clara | 48 | 26 | 0 | 1 | 85 | <11 | |||
1925 | 1925 | 2021-05-11 | Villa Serena Of Morgan Hill | Santa Clara | 1 | 1 | 0 | 1 | 85 | <11 | <11 | <11 | |
2933 | 2933 | 2021-04-27 | Atria Willow Glen | Santa Clara | 12 | 26 | 0 | 1 | 85 | <11 | |||
2935 | 2935 | 2021-04-27 | Belmont Village Sunnyvale | Santa Clara | 1 | 1 | 0 | 1 | 85 | <11 | <11 | <11 | |
2937 | 2937 | 2021-04-27 | Brookdale San Jose | Santa Clara | 50 | 37 | 0 | 1 | 85 | <11 | |||
2938 | 2938 | 2021-04-27 | Campbell Village | Santa Clara | 13 | 22 | 0 | 1 | 85 | <11 | |||
2940 | 2940 | 2021-04-27 | Cedar Creek Alzheimer's & Dementia Care Center | Santa Clara | 20 | 28 | 0 | 1 | 85 | <11 | |||
2941 | 2941 | 2021-04-27 | Channing House | Santa Clara | 39 | 13 | 0 | 1 | 85 | <11 | |||
2943 | 2943 | 2021-04-27 | Crescent Oaks | Santa Clara | 12 | 15 | 0 | 1 | 85 | <11 | |||
2947 | 2947 | 2021-04-27 | Loma Clara Senior Living | Santa Clara | 1 | 1 | 0 | 1 | 85 | <11 | <11 | <11 | |
2948 | 2948 | 2021-04-27 | Lytton Gardens Community Care | Santa Clara | 1 | 1 | 0 | 1 | 85 | <11 | <11 | <11 | |
2949 | 2949 | 2021-04-27 | Merrill Gardens At Campbell | Santa Clara | 34 | 24 | 1 | 1 | 85 | <11 | <11 | ||
2950 | 2950 | 2021-04-27 | Merrill Gardens At Gilroy | Santa Clara | 1 | 13 | 0 | 1 | 85 | <11 | <11 | ||
2953 | 2953 | 2021-04-27 | Oakmont Of San Jose | Santa Clara | 1 | 1 | 0 | 1 | 85 | <11 | <11 | <11 | |
2954 | 2954 | 2021-04-27 | Pacific Gardens | Santa Clara | 24 | 13 | 1 | 1 | 85 | <11 | <11 | ||
2958 | 2958 | 2021-04-27 | Rose Garden Court | Santa Clara | 1 | 15 | 0 | 1 | 85 | <11 | <11 | ||
2959 | 2959 | 2021-04-27 | Saratoga Retirement Community | Santa Clara | 18 | 1 | 1 | 1 | 85 | <11 | <11 | <11 | |
2960 | 2960 | 2021-04-27 | Somerset Senior Living | Santa Clara | 1 | 19 | 0 | 1 | 85 | <11 | <11 | ||
2961 | 2961 | 2021-04-27 | Sunny View Retirement Community | Santa Clara | 21 | 1 | 0 | 1 | 85 | <11 | <11 | ||
2963 | 2963 | 2021-04-27 | Sunrise Assisted Living Of Palo Alto | Santa Clara | 21 | 20 | 1 | 1 | 85 | <11 | <11 | ||
2964 | 2964 | 2021-04-27 | Sunrise Of Sunnyvale | Santa Clara | 12 | 1 | 0 | 1 | 85 | <11 | <11 | ||
2965 | 2965 | 2021-04-27 | Sunrise Villa San Jose | Santa Clara | 1 | 25 | 0 | 1 | 85 | <11 | <11 | ||
2967 | 2967 | 2021-04-27 | Terraces Of Los Gatos, The | Santa Clara | 21 | 1 | 0 | 1 | 85 | <11 | <11 | ||
2968 | 2968 | 2021-04-27 | Vi At Palo Alto | Santa Clara | 48 | 26 | 0 | 1 | 85 | <11 | |||
2971 | 2971 | 2021-04-27 | Villa Serena Of Morgan Hill | Santa Clara | 1 | 1 | 0 | 1 | 85 | <11 | <11 | <11 | |
3982 | 3982 | 2021-04-21 | Atria Willow Glen | Santa Clara | 12 | 26 | 0 | 1 | 85 | <11 | |||
3984 | 3984 | 2021-04-21 | Belmont Village Sunnyvale | Santa Clara | 1 | 1 | 0 | 1 | 85 | <11 | <11 | <11 | |
3986 | 3986 | 2021-04-21 | Brookdale San Jose | Santa Clara | 50 | 37 | 0 | 1 | 85 | <11 | |||
3987 | 3987 | 2021-04-21 | Campbell Village | Santa Clara | 13 | 22 | 0 | 1 | 85 | <11 | |||
3989 | 3989 | 2021-04-21 | Cedar Creek Alzheimer's & Dementia Care Center | Santa Clara | 20 | 28 | 0 | 1 | 85 | <11 | |||
3990 | 3990 | 2021-04-21 | Channing House | Santa Clara | 39 | 13 | 0 | 1 | 85 | <11 | |||
3992 | 3992 | 2021-04-21 | Crescent Oaks | Santa Clara | 12 | 15 | 0 | 1 | 85 | <11 | |||
3996 | 3996 | 2021-04-21 | Loma Clara Senior Living | Santa Clara | 1 | 1 | 0 | 1 | 85 | <11 | <11 | <11 | |
3997 | 3997 | 2021-04-21 | Lytton Gardens Community Care | Santa Clara | 1 | 1 | 0 | 1 | 85 | <11 | <11 | <11 | |
3998 | 3998 | 2021-04-21 | Merrill Gardens At Campbell | Santa Clara | 34 | 24 | 1 | 1 | 85 | <11 | <11 | ||
3999 | 3999 | 2021-04-21 | Merrill Gardens At Gilroy | Santa Clara | 1 | 13 | 0 | 1 | 85 | <11 | <11 | ||
4002 | 4002 | 2021-04-21 | Oakmont Of San Jose | Santa Clara | 1 | 1 | 0 | 1 | 85 | <11 | <11 | <11 | |
4003 | 4003 | 2021-04-21 | Pacific Gardens | Santa Clara | 24 | 13 | 1 | 1 | 85 | <11 | <11 | ||
4007 | 4007 | 2021-04-21 | Rose Garden Court | Santa Clara | 1 | 15 | 0 | 1 | 85 | <11 | <11 | ||
4008 | 4008 | 2021-04-21 | Saratoga Retirement Community | Santa Clara | 18 | 1 | 1 | 1 | 85 | <11 | <11 | <11 | |
4009 | 4009 | 2021-04-21 | Somerset Senior Living | Santa Clara | 1 | 19 | 0 | 1 | 85 | <11 | <11 | ||
4010 | 4010 | 2021-04-21 | Sunny View Retirement Community | Santa Clara | 21 | 1 | 0 | 1 | 85 | <11 | <11 | ||
4012 | 4012 | 2021-04-21 | Sunrise Assisted Living Of Palo Alto | Santa Clara | 21 | 20 | 1 | 1 | 85 | <11 | <11 | ||
4013 | 4013 | 2021-04-21 | Sunrise Of Sunnyvale | Santa Clara | 12 | 1 | 0 | 1 | 85 | <11 | <11 | ||
4014 | 4014 | 2021-04-21 | Sunrise Villa San Jose | Santa Clara | 1 | 25 | 0 | 1 | 85 | <11 | <11 | ||
4016 | 4016 | 2021-04-21 | Terraces Of Los Gatos, The | Santa Clara | 21 | 1 | 0 | 1 | 85 | <11 | <11 | ||
4017 | 4017 | 2021-04-21 | Vi At Palo Alto | Santa Clara | 48 | 26 | 0 | 1 | 85 | <11 | |||
4020 | 4020 | 2021-04-21 | Villa Serena Of Morgan Hill | Santa Clara | 1 | 1 | 0 | 1 | 85 | <11 | <11 | <11 | |
5029 | 5029 | 2021-04-06 | Atria Willow Glen | Santa Clara | 12 | 26 | 0 | 1 | 85 | <11 | |||
5031 | 5031 | 2021-04-06 | Belmont Village Sunnyvale | Santa Clara | 1 | 1 | 0 | 1 | 85 | <11 | <11 | <11 | |
5033 | 5033 | 2021-04-06 | Brookdale San Jose | Santa Clara | 49 | 37 | 0 | 1 | 85 | <11 | |||
5034 | 5034 | 2021-04-06 | Campbell Village | Santa Clara | 12 | 22 | 0 | 1 | 85 | <11 | |||
5036 | 5036 | 2021-04-06 | Cedar Creek Alzheimer's & Dementia Care Center | Santa Clara | 20 | 28 | 0 | 1 | 85 | <11 | |||
5037 | 5037 | 2021-04-06 | Channing House | Santa Clara | 39 | 13 | 0 | 1 | 85 | <11 | |||
5039 | 5039 | 2021-04-06 | Crescent Oaks | Santa Clara | 12 | 15 | 0 | 1 | 85 | <11 | |||
5043 | 5043 | 2021-04-06 | Loma Clara Senior Living | Santa Clara | 1 | 1 | 0 | 1 | 85 | <11 | <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 );