⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

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

115,559 rows sorted by date descending

View and edit SQL

Link rowid date ▲ slug 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
101 2021-05-11 westmont-of-fresno WESTMONT OF FRESNO Fresno 12 1 0 0 19   <11    
102 2021-05-11 windham-the WINDHAM, THE Fresno 1 14 0 1 19 <11     <11
103 2021-05-11 westhaven-assisted-living WESTHAVEN ASSISTED LIVING Glenn 17 33 0 1 21       <11
104 2021-05-11 alder-bay-assisted-living ALDER BAY ASSISTED LIVING Humboldt 1 1 0 1 23 <11 <11   <11
105 2021-05-11 a-a-cottage-view-assisted-living-inc A&A COTTAGE VIEW ASSISTED LIVING,INC. Imperial 1 1 0 1 25 <11 <11   <11
106 2021-05-11 blossom-valley-inn BLOSSOM VALLEY INN Imperial 12 58 0 1 25       <11
107 2021-05-11 heart-hand-inc HEART & HAND, INC. Imperial 1 1 0 0 25 <11 <11    
108 2021-05-11 brookdale-riverwalk BROOKDALE RIVERWALK Kern 1 18 0 0 29 <11      
109 2021-05-11 carrington-of-shafter CARRINGTON OF SHAFTER Kern 1 1 0 0 29 <11 <11    
110 2021-05-11 golden-castle-assisted-living GOLDEN CASTLE ASSISTED LIVING Kern 0 15 0 0 29        
111 2021-05-11 hallmark-of-bakersfield HALLMARK OF BAKERSFIELD Kern 1 13 0 0 29 <11      
112 2021-05-11 jasmin-terrace-at-bakersfield JASMIN TERRACE AT BAKERSFIELD Kern 1 1 0 1 29 <11 <11   <11
113 2021-05-11 palms-at-san-lauren-the PALMS AT SAN LAUREN, THE Kern 1 1 0 1 29 <11 <11   <11
114 2021-05-11 pointe-at-summit-hills-the POINTE AT SUMMIT HILLS, THE Kern 22 1 0 1 29   <11   <11
115 2021-05-11 rosewood-retirement-community ROSEWOOD RETIREMENT COMMUNITY Kern 18 1 0 1 29   <11   <11
116 2021-05-11 westchester-gardens WESTCHESTER GARDENS Kern 1 17 0 1 29 <11     <11
117 2021-05-11 diamond-terraces DIAMOND TERRACES Kings 1 14 0 0 31 <11      
118 2021-05-11 orchard-park-senior-living-community ORCHARD PARK SENIOR LIVING COMMUNITY Lake 18 16 0 0 33        
119 2021-05-11 eagle-lake-village EAGLE LAKE VILLAGE Lassen 1 1 0 1 35 <11 <11   <11
120 2021-05-11 abbey-road-villa ABBEY ROAD VILLA Los Angeles 1 36 0 0 37 <11      
121 2021-05-11 aegis-of-granada-hills AEGIS OF GRANADA HILLS Los Angeles 22 29 0 1 37       <11
122 2021-05-11 alta-vista-gardens ALTA VISTA GARDENS Los Angeles 1 16 0 0 37 <11      
123 2021-05-11 ambassador-garden AMBASSADOR GARDEN Los Angeles 1 12 0 0 37 <11      
124 2021-05-11 ararat-home-of-los-angeles ARARAT HOME OF LOS ANGELES Los Angeles 1 1 0 1 37 <11 <11   <11
125 2021-05-11 arbor-vista ARBOR VISTA Los Angeles 13 20 0 1 37       <11
126 2021-05-11 arcadia-gardens-retirement-hotel ARCADIA GARDENS RETIREMENT HOTEL Los Angeles 21 1 0 0 37   <11    
127 2021-05-11 arcadia-living-llc ARCADIA LIVING LLC Los Angeles 13 26 0 1 37       <11
128 2021-05-11 arcadia-retirement-village ARCADIA RETIREMENT VILLAGE Los Angeles 13 19 0 1 37       <11
129 2021-05-11 arcadian-the ARCADIAN, THE Los Angeles 26 93 1 25 37     <11  
130 2021-05-11 artesia-christian-home ARTESIA CHRISTIAN HOME Los Angeles 14 1 0 0 37   <11    
131 2021-05-11 atherton-baptist-homes ATHERTON BAPTIST HOMES Los Angeles 24 1 0 1 37   <11   <11
132 2021-05-11 atria-covina ATRIA COVINA Los Angeles 18 37 0 1 37       <11
133 2021-05-11 atria-park-of-pacific-palisades ATRIA PARK OF PACIFIC PALISADES Los Angeles 24 20 0 1 37       <11
134 2021-05-11 atria-rancho-park ATRIA RANCHO PARK Los Angeles 21 46 1 1 37     <11 <11
135 2021-05-11 atria-santa-clarita ATRIA SANTA CLARITA Los Angeles 25 34 0 1 37       <11
136 2021-05-11 atria-tarzana ATRIA TARZANA Los Angeles 15 21 0 1 37       <11
137 2021-05-11 avantgarde-senior-living-of-tarzana AVANTGARDE SENIOR LIVING OF TARZANA Los Angeles 26 25 0 1 37       <11
138 2021-05-11 bella-vista BELLA VISTA Los Angeles 11 15 0 0 37        
139 2021-05-11 belmont-village-burbank BELMONT VILLAGE BURBANK Los Angeles 35 44 0 1 37       <11
140 2021-05-11 belmont-village-calabasas BELMONT VILLAGE CALABASAS Los Angeles 55 50 1 1 37     <11 <11
141 2021-05-11 belmont-village-encino BELMONT VILLAGE ENCINO Los Angeles 54 43 1 1 37     <11 <11
142 2021-05-11 belmont-village-hollywood BELMONT VILLAGE HOLLYWOOD Los Angeles 29 23 0 1 37       <11
143 2021-05-11 belmont-village-rancho-palos-verdes BELMONT VILLAGE RANCHO PALOS VERDES Los Angeles 27 24 0 1 37       <11
144 2021-05-11 belmont-village-westwood BELMONT VILLAGE WESTWOOD Los Angeles 75 36 1 1 37     <11 <11
145 2021-05-11 beverly-hills-carmel-retirement-hotel BEVERLY HILLS CARMEL RETIREMENT HOTEL Los Angeles 27 22 1 1 37     <11 <11
146 2021-05-11 beverly-hills-carmel-retirement-hotel-north BEVERLY HILLS CARMEL RETIREMENT HOTEL NORTH Los Angeles 15 1 1 0 37   <11 <11  
147 2021-05-11 beverly-hills-gardens-care-center BEVERLY HILLS GARDENS CARE CENTER Los Angeles 1 12 1 1 37 <11   <11 <11
148 2021-05-11 beverly-hills-loving-care BEVERLY HILLS LOVING CARE Los Angeles 11 14 0 0 37        
149 2021-05-11 beverly-hills-senior-care BEVERLY HILLS SENIOR CARE Los Angeles 1 40 0 1 37 <11     <11
150 2021-05-11 bixby-knolls-tower BIXBY KNOLLS TOWER Los Angeles 1 18 0 0 37 <11      
151 2021-05-11 brethren-hillcrest-homes BRETHREN HILLCREST HOMES Los Angeles 11 19 0 1 37       <11
152 2021-05-11 brittany-house BRITTANY HOUSE Los Angeles 18 47 0 1 37       <11
153 2021-05-11 broadview-residential-care-center BROADVIEW RESIDENTIAL CARE CENTER Los Angeles 1 1 0 1 37 <11 <11   <11
154 2021-05-11 brookdale-alhambra BROOKDALE ALHAMBRA Los Angeles 15 1 1 0 37   <11 <11  
155 2021-05-11 brookdale-central-whittier BROOKDALE CENTRAL WHITTIER Los Angeles 15 35 0 1 37       <11
156 2021-05-11 brookdale-chatsworth BROOKDALE CHATSWORTH Los Angeles 22 50 0 1 37       <11
157 2021-05-11 brookdale-gardens-of-tarzana BROOKDALE GARDENS OF TARZANA Los Angeles 1 11 0 1 37 <11     <11
158 2021-05-11 brookdale-monrovia BROOKDALE MONROVIA Los Angeles 1 1 0 1 37 <11 <11   <11
159 2021-05-11 brookdale-northridge BROOKDALE NORTHRIDGE Los Angeles 22 25 0 13 37        
160 2021-05-11 brookdale-ocean-house BROOKDALE OCEAN HOUSE Los Angeles 22 15 0 0 37        
161 2021-05-11 brookdale-san-dimas BROOKDALE SAN DIMAS Los Angeles 27 26 0 1 37       <11
162 2021-05-11 brookdale-santa-monica-gardens BROOKDALE SANTA MONICA GARDENS Los Angeles 1 1 0 0 37 <11 <11    
163 2021-05-11 brookdale-uptown-whittier BROOKDALE UPTOWN WHITTIER Los Angeles 1 20 0 1 37 <11     <11
164 2021-05-11 brookdale-walnut BROOKDALE WALNUT Los Angeles 17 38 0 1 37       <11
165 2021-05-11 california-mission-inn CALIFORNIA MISSION INN Los Angeles 12 19 0 1 37       <11
166 2021-05-11 california-mission-inn-rose-manor CALIFORNIA MISSION INN - ROSE MANOR Los Angeles 0 1 0 1 37   <11   <11
167 2021-05-11 canyon-trails-at-topanga-senior-living CANYON TRAILS AT TOPANGA SENIOR LIVING Los Angeles 34 74 0 12 37        
168 2021-05-11 cardinal-yu-pin-manor CARDINAL YU-PIN MANOR Los Angeles 1 1 0 1 37 <11 <11   <11
169 2021-05-11 carroll-manor CARROLL MANOR Los Angeles 1 1 0 1 37 <11 <11   <11
170 2021-05-11 carson-senior-assisted-living CARSON SENIOR ASSISTED LIVING Los Angeles 26 50 0 1 37       <11
171 2021-05-11 cedars-assisted-living-the CEDARS ASSISTED LIVING, THE Los Angeles 18 57 0 1 37       <11
172 2021-05-11 centinela-assisted-living-centre CENTINELA ASSISTED LIVING CENTRE Los Angeles 1 31 0 1 37 <11     <11
173 2021-05-11 charlie-s-residential-care CHARLIE'S RESIDENTIAL CARE Los Angeles 1 1 0 1 37 <11 <11   <11
174 2021-05-11 chateau-long-beach CHATEAU LONG BEACH Los Angeles 17 55 0 1 37       <11
175 2021-05-11 city-view-la-llc CITY VIEW LA, LLC Los Angeles 22 21 0 1 37       <11
176 2021-05-11 claremont-manor CLAREMONT MANOR Los Angeles 29 1 0 1 37   <11   <11
177 2021-05-11 claremont-place CLAREMONT PLACE Los Angeles 24 23 1 1 37     <11 <11
178 2021-05-11 clearwater-at-south-bay CLEARWATER AT SOUTH BAY Los Angeles 27 22 0 1 37       <11
179 2021-05-11 commons-at-woodland-hills-the COMMONS AT WOODLAND HILLS, THE Los Angeles 50 68 1 1 37     <11 <11
180 2021-05-11 commonwealth-royale-guest-home COMMONWEALTH ROYALE GUEST HOME Los Angeles 1 17 0 0 37 <11      
181 2021-05-11 coral-oaks-care-living CORAL OAKS CARE LIVING Los Angeles 1 14 0 1 37 <11     <11
182 2021-05-11 country-inn-of-downey COUNTRY INN OF DOWNEY Los Angeles 1 14 0 1 37 <11     <11
183 2021-05-11 country-view-assisted-living COUNTRY VIEW ASSISTED LIVING Los Angeles 22 51 0 1 37       <11
184 2021-05-11 country-villa-terrace-assisted-living-center COUNTRY VILLA TERRACE ASSISTED LIVING CENTER Los Angeles 1 32 0 1 37 <11     <11
185 2021-05-11 courtyard-plaza COURTYARD PLAZA Los Angeles 23 31 0 13 37        
186 2021-05-11 crofton-manor-inn CROFTON MANOR INN Los Angeles 39 59 0 1 37       <11
187 2021-05-11 del-mar-park DEL MAR PARK Los Angeles 19 28 0 1 37       <11
188 2021-05-11 downey-retirement-center DOWNEY RETIREMENT CENTER Los Angeles 35 39 0 1 37       <11
189 2021-05-11 eisenberg-vlg-of-the-la-jewish-home-for-the-aging EISENBERG VLG OF THE LA JEWISH HOME FOR THE AGING Los Angeles 31 50 0 1 37       <11
190 2021-05-11 eldorado-oaks-inc ELDORADO OAKS, INC Los Angeles 1 24 0 1 37 <11     <11
191 2021-05-11 elim-healthcare-inc ELIM HEALTHCARE, INC. Los Angeles 14 69 1 11 37     <11  
192 2021-05-11 encino-terrace-senior-living ENCINO TERRACE SENIOR LIVING Los Angeles 1 19 0 1 37 <11     <11
193 2021-05-11 evergreen-retirement EVERGREEN RETIREMENT Los Angeles 1 36 0 1 37 <11     <11
194 2021-05-11 evergreen-senior-care EVERGREEN SENIOR CARE Los Angeles 1 1 0 1 37 <11 <11   <11
195 2021-05-11 fairwinds-west-hills FAIRWINDS - WEST HILLS Los Angeles 15 13 0 0 37        
196 2021-05-11 fallbrook-glen-of-west-hills FALLBROOK GLEN OF WEST HILLS Los Angeles 18 25 0 1 37       <11
197 2021-05-11 fine-gold-manor-retirement FINE GOLD MANOR RETIREMENT Los Angeles 11 1 0 0 37   <11    
198 2021-05-11 fountainview-at-eisenberg-village FOUNTAINVIEW AT EISENBERG VILLAGE Los Angeles 26 1 0 1 37   <11   <11
199 2021-05-11 fountainview-at-gonda-westside FOUNTAINVIEW AT GONDA WESTSIDE Los Angeles 55 18 0 1 37       <11
200 2021-05-11 garden-of-palms GARDEN OF PALMS Los Angeles 11 21 0 1 37       <11

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [la_times_cdph_adult_and_senior_care_facilities] (
   [date] TEXT,
   [slug] 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
);