⚠️ 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

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

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
);