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
116,613 rows sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county >30 ✖
- Los Angeles 28,765
- Orange 12,418
- San Diego 10,960
- Riverside 8,310
- Sacramento 5,390
- San Bernardino 4,920
- San Mateo 4,049
- Alameda 4,048
- Santa Clara 3,862
- Ventura 2,934
- Contra Costa 2,801
- San Joaquin 2,790
- Fresno 2,353
- Sonoma 2,213
- Stanislaus 2,128
- Santa Barbara 2,070
- San Francisco 1,697
- Marin 1,676
- Placer 1,460
- Solano 1,326
- Kern 1,308
- San Luis Obispo 1,269
- Santa Cruz 948
- Butte 794
- Monterey 773
- Yolo 672
- Shasta 654
- Napa 506
- Tulare 468
- Imperial 404
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | 2021-06-27 | Acacia Creek - Union City | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
2 | 2 | 2021-06-27 | Aegis Assisted Living Of Fremont | Alameda | 12 | 15 | 0 | 0 | 1 | ||||
3 | 3 | 2021-06-27 | Arcadian Residential Community | Alameda | 15 | 28 | 0 | 1 | 1 | <11 | |||
4 | 4 | 2021-06-27 | Belmont Village Albany | Alameda | 15 | 1 | 0 | 0 | 1 | <11 | |||
5 | 5 | 2021-06-27 | Brookdale North Fremont | Alameda | 22 | 26 | 0 | 1 | 1 | <11 | |||
6 | 6 | 2021-06-27 | Carefield Pleasanton | Alameda | 17 | 24 | 0 | 1 | 1 | <11 | |||
7 | 7 | 2021-06-27 | Carlton Plaza Of Fremont | Alameda | 13 | 1 | 0 | 0 | 1 | <11 | |||
8 | 8 | 2021-06-27 | Carlton Plaza Of San Leandro | Alameda | 36 | 41 | 1 | 1 | 1 | <11 | <11 | ||
9 | 9 | 2021-06-27 | Creekview Assisted Living | Alameda | 28 | 28 | 0 | 1 | 1 | <11 | |||
10 | 10 | 2021-06-27 | Elder Ashram | Alameda | 1 | 18 | 0 | 0 | 1 | <11 | |||
11 | 11 | 2021-06-27 | Fremont Hills | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
12 | 12 | 2021-06-27 | Fremont Rtrmt Com-Happy Lvng By Cogir/Cogir Fremon | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
13 | 13 | 2021-06-27 | Fremont Village | Alameda | 33 | 60 | 1 | 14 | 1 | <11 | |||
14 | 14 | 2021-06-27 | Heritage Haven | Alameda | 1 | 21 | 0 | 1 | 1 | <11 | <11 | ||
15 | 15 | 2021-06-27 | J-Sei Home | Alameda | 1 | 1 | 0 | 1 | 1 | <11 | <11 | <11 | |
16 | 16 | 2021-06-27 | Lakeside Park | Alameda | 21 | 18 | 0 | 1 | 1 | <11 | |||
17 | 17 | 2021-06-27 | Landmark Villa | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
18 | 18 | 2021-06-27 | Lincoln Villa | Alameda | 1 | 18 | 0 | 1 | 1 | <11 | <11 | ||
19 | 19 | 2021-06-27 | Marymount Villa Retirement Center | Alameda | 17 | 49 | 1 | 16 | 1 | <11 | |||
20 | 20 | 2021-06-27 | Masonic Home For Adults | Alameda | 17 | 1 | 0 | 0 | 1 | <11 | |||
21 | 21 | 2021-06-27 | Merrill Gardens At Rockridge | Alameda | 11 | 1 | 1 | 1 | 1 | <11 | <11 | <11 | |
22 | 22 | 2021-06-27 | Mori Manor | Alameda | 1 | 1 | 0 | 1 | 1 | <11 | <11 | <11 | |
23 | 23 | 2021-06-27 | Oakcreek | Alameda | 1 | 15 | 0 | 1 | 1 | <11 | <11 | ||
24 | 24 | 2021-06-27 | Oakmont Of Mariner Point | Alameda | 24 | 26 | 0 | 1 | 1 | <11 | |||
25 | 25 | 2021-06-27 | Pacifica Senior Living Oakland | Alameda | 20 | 22 | 0 | 1 | 1 | <11 | |||
26 | 26 | 2021-06-27 | Pacifica Senior Living San Leandro | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
27 | 27 | 2021-06-27 | Parkview, The | Alameda | 19 | 41 | 0 | 1 | 1 | <11 | |||
28 | 28 | 2021-06-27 | Point At Rockridge, The | Alameda | 13 | 35 | 0 | 1 | 1 | <11 | |||
29 | 29 | 2021-06-27 | Quail Garden | Alameda | 1 | 16 | 0 | 1 | 1 | <11 | <11 | ||
30 | 30 | 2021-06-27 | Rosegate | Alameda | 11 | 19 | 0 | 0 | 1 | ||||
31 | 31 | 2021-06-27 | Scott Villa | Alameda | 1 | 30 | 0 | 1 | 1 | <11 | <11 | ||
32 | 32 | 2021-06-27 | Silverado Senior Living - Berkeley | Alameda | 33 | 58 | 0 | 14 | 1 | ||||
33 | 33 | 2021-06-27 | St. Paul's Towers | Alameda | 20 | 1 | 0 | 0 | 1 | <11 | |||
34 | 34 | 2021-06-27 | St. Regis Retirement Center, Inc. | Alameda | 11 | 19 | 0 | 1 | 1 | <11 | |||
35 | 35 | 2021-06-27 | Stoneridge Creek Pleasanton | Alameda | 38 | 1 | 0 | 0 | 1 | <11 | |||
36 | 36 | 2021-06-27 | Sunrise Of Pleasanton | Alameda | 13 | 16 | 0 | 0 | 1 | ||||
37 | 37 | 2021-06-27 | Watermark At Rosewood Gardens, The | Alameda | 14 | 34 | 0 | 1 | 1 | <11 | |||
38 | 38 | 2021-06-27 | Watermark By The Bay, The | Alameda | 12 | 1 | 0 | 0 | 1 | <11 | |||
39 | 39 | 2021-06-27 | Waters Edge Lodge | Alameda | 1 | 1 | 0 | 1 | 1 | <11 | <11 | <11 | |
40 | 40 | 2021-06-27 | Willow Creek Alzheimer's & Dementia Care Center | Alameda | 1 | 1 | 0 | 1 | 1 | <11 | <11 | <11 | |
41 | 41 | 2021-06-27 | Woodside Residential Care Facility For Elderly | Alameda | 1 | 11 | 0 | 1 | 1 | <11 | <11 | ||
1055 | 1055 | 2021-05-11 | Acacia Creek - Union City | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
1056 | 1056 | 2021-05-11 | Aegis Assisted Living Of Fremont | Alameda | 12 | 15 | 0 | 0 | 1 | ||||
1057 | 1057 | 2021-05-11 | Arcadian Residential Community | Alameda | 15 | 28 | 0 | 1 | 1 | <11 | |||
1058 | 1058 | 2021-05-11 | Belmont Village Albany | Alameda | 15 | 1 | 0 | 0 | 1 | <11 | |||
1059 | 1059 | 2021-05-11 | Brookdale North Fremont | Alameda | 22 | 26 | 0 | 1 | 1 | <11 | |||
1060 | 1060 | 2021-05-11 | Carefield Pleasanton | Alameda | 17 | 24 | 0 | 1 | 1 | <11 | |||
1061 | 1061 | 2021-05-11 | Carlton Plaza Of Fremont | Alameda | 13 | 1 | 0 | 0 | 1 | <11 | |||
1062 | 1062 | 2021-05-11 | Carlton Plaza Of San Leandro | Alameda | 35 | 41 | 1 | 1 | 1 | <11 | <11 | ||
1063 | 1063 | 2021-05-11 | Creekview Assisted Living | Alameda | 28 | 28 | 0 | 1 | 1 | <11 | |||
1064 | 1064 | 2021-05-11 | Fremont Hills | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
1065 | 1065 | 2021-05-11 | Fremont Rtrmt Com-Happy Lvng By Cogir/Cogir Fremon | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
1066 | 1066 | 2021-05-11 | Fremont Village | Alameda | 33 | 60 | 1 | 14 | 1 | <11 | |||
1067 | 1067 | 2021-05-11 | Heritage Haven | Alameda | 1 | 21 | 0 | 1 | 1 | <11 | <11 | ||
1068 | 1068 | 2021-05-11 | J-Sei Home | Alameda | 1 | 1 | 0 | 1 | 1 | <11 | <11 | <11 | |
1069 | 1069 | 2021-05-11 | Lakeside Park | Alameda | 21 | 18 | 0 | 1 | 1 | <11 | |||
1070 | 1070 | 2021-05-11 | Landmark Villa | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
1071 | 1071 | 2021-05-11 | Lincoln Villa | Alameda | 1 | 18 | 0 | 1 | 1 | <11 | <11 | ||
1072 | 1072 | 2021-05-11 | Marymount Villa Retirement Center | Alameda | 17 | 49 | 1 | 16 | 1 | <11 | |||
1073 | 1073 | 2021-05-11 | Masonic Home For Adults | Alameda | 17 | 1 | 0 | 0 | 1 | <11 | |||
1074 | 1074 | 2021-05-11 | Merrill Gardens At Rockridge | Alameda | 11 | 1 | 1 | 1 | 1 | <11 | <11 | <11 | |
1075 | 1075 | 2021-05-11 | Mori Manor | Alameda | 1 | 1 | 0 | 1 | 1 | <11 | <11 | <11 | |
1076 | 1076 | 2021-05-11 | Oakcreek | Alameda | 1 | 15 | 0 | 1 | 1 | <11 | <11 | ||
1077 | 1077 | 2021-05-11 | Oakmont Of Mariner Point | Alameda | 24 | 26 | 0 | 1 | 1 | <11 | |||
1078 | 1078 | 2021-05-11 | Pacifica Senior Living Oakland | Alameda | 18 | 22 | 0 | 1 | 1 | <11 | |||
1079 | 1079 | 2021-05-11 | Pacifica Senior Living San Leandro | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
1080 | 1080 | 2021-05-11 | Parkview, The | Alameda | 19 | 41 | 0 | 1 | 1 | <11 | |||
1081 | 1081 | 2021-05-11 | Point At Rockridge, The | Alameda | 13 | 35 | 0 | 1 | 1 | <11 | |||
1082 | 1082 | 2021-05-11 | Quail Garden | Alameda | 1 | 16 | 0 | 1 | 1 | <11 | <11 | ||
1083 | 1083 | 2021-05-11 | Rosegate | Alameda | 11 | 19 | 0 | 0 | 1 | ||||
1084 | 1084 | 2021-05-11 | Scott Villa | Alameda | 1 | 30 | 0 | 1 | 1 | <11 | <11 | ||
1085 | 1085 | 2021-05-11 | Silverado Senior Living - Berkeley | Alameda | 33 | 58 | 0 | 14 | 1 | ||||
1086 | 1086 | 2021-05-11 | St. Paul's Towers | Alameda | 20 | 1 | 0 | 0 | 1 | <11 | |||
1087 | 1087 | 2021-05-11 | St. Regis Retirement Center, Inc. | Alameda | 11 | 19 | 0 | 1 | 1 | <11 | |||
1088 | 1088 | 2021-05-11 | Stoneridge Creek Pleasanton | Alameda | 38 | 1 | 0 | 0 | 1 | <11 | |||
1089 | 1089 | 2021-05-11 | Sunrise Of Pleasanton | Alameda | 13 | 16 | 0 | 0 | 1 | ||||
1090 | 1090 | 2021-05-11 | Watermark At Rosewood Gardens, The | Alameda | 14 | 34 | 0 | 1 | 1 | <11 | |||
1091 | 1091 | 2021-05-11 | Watermark By The Bay, The | Alameda | 12 | 1 | 0 | 0 | 1 | <11 | |||
1092 | 1092 | 2021-05-11 | Waters Edge Lodge | Alameda | 1 | 1 | 0 | 1 | 1 | <11 | <11 | <11 | |
1093 | 1093 | 2021-05-11 | Willow Creek Alzheimer's & Dementia Care Center | Alameda | 1 | 1 | 0 | 1 | 1 | <11 | <11 | <11 | |
1094 | 1094 | 2021-05-11 | Woodside Residential Care Facility For Elderly | Alameda | 1 | 11 | 0 | 1 | 1 | <11 | <11 | ||
2051 | 2051 | 2021-04-27 | Acacia Creek - Union City | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
2052 | 2052 | 2021-04-27 | Aegis Assisted Living Of Fremont | Alameda | 12 | 15 | 0 | 0 | 1 | ||||
2053 | 2053 | 2021-04-27 | Arcadian Residential Community | Alameda | 15 | 28 | 0 | 1 | 1 | <11 | |||
2054 | 2054 | 2021-04-27 | Belmont Village Albany | Alameda | 15 | 1 | 0 | 0 | 1 | <11 | |||
2055 | 2055 | 2021-04-27 | Brookdale North Fremont | Alameda | 22 | 26 | 0 | 1 | 1 | <11 | |||
2056 | 2056 | 2021-04-27 | Carefield Pleasanton | Alameda | 17 | 24 | 0 | 1 | 1 | <11 | |||
2057 | 2057 | 2021-04-27 | Carlton Plaza Of Fremont | Alameda | 13 | 1 | 0 | 0 | 1 | <11 | |||
2058 | 2058 | 2021-04-27 | Carlton Plaza Of San Leandro | Alameda | 35 | 41 | 1 | 1 | 1 | <11 | <11 | ||
2059 | 2059 | 2021-04-27 | Creekview Assisted Living | Alameda | 28 | 28 | 0 | 1 | 1 | <11 | |||
2060 | 2060 | 2021-04-27 | Diana's Care Home | Alameda | 1 | 29 | 0 | 0 | 1 | <11 | |||
2061 | 2061 | 2021-04-27 | Elder Ashram | Alameda | 1 | 18 | 0 | 0 | 1 | <11 | |||
2062 | 2062 | 2021-04-27 | Fremont Hills | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
2063 | 2063 | 2021-04-27 | Fremont Rtrmt Com-Happy Lvng By Cogir/Cogir Fremon | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
2064 | 2064 | 2021-04-27 | Fremont Village | Alameda | 33 | 60 | 1 | 14 | 1 | <11 | |||
2065 | 2065 | 2021-04-27 | Heritage Haven | Alameda | 1 | 21 | 0 | 1 | 1 | <11 | <11 | ||
2066 | 2066 | 2021-04-27 | J-Sei Home | Alameda | 1 | 1 | 0 | 1 | 1 | <11 | <11 | <11 | |
2067 | 2067 | 2021-04-27 | Lakeside Park | Alameda | 21 | 18 | 0 | 1 | 1 | <11 | |||
2068 | 2068 | 2021-04-27 | Landmark Villa | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
2069 | 2069 | 2021-04-27 | Lincoln Villa | Alameda | 1 | 18 | 0 | 1 | 1 | <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 );