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

43,615 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
1 2020-12-04 arcadian-residential-community ARCADIAN RESIDENTIAL COMMUNITY Alameda 15 28 0 1 1       <11
2 2020-12-04 brookdale-north-fremont BROOKDALE NORTH FREMONT Alameda 22 21 0 1 1       <11
3 2020-12-04 carlton-plaza-of-san-leandro CARLTON PLAZA OF SAN LEANDRO Alameda 28 37 1 1 1     <11 <11
4 2020-12-04 fremont-village FREMONT VILLAGE Alameda 28 49 1 12 1     <11  
5 2020-12-04 lakeside-park LAKESIDE PARK Alameda 15 11 0 1 1       <11
6 2020-12-04 lincoln-villa LINCOLN VILLA Alameda 1 1 0 1 1 <11 <11   <11
7 2020-12-04 marymount-villa-retirement-center MARYMOUNT VILLA RETIREMENT CENTER Alameda 17 49 1 16 1     <11  
8 2020-12-04 pacifica-senior-living-oakland PACIFICA SENIOR LIVING OAKLAND Alameda 1 1 0 1 1 <11 <11   <11
9 2020-12-04 point-at-rockridge-the POINT AT ROCKRIDGE, THE Alameda 1 16 0 1 1 <11     <11
10 2020-12-04 quail-garden QUAIL GARDEN Alameda 1 15 0 1 1 <11     <11
11 2020-12-04 rosegate ROSEGATE Alameda 1 12 0 0 1 <11      
12 2020-12-04 scott-villa SCOTT VILLA Alameda 1 30 0 1 1 <11     <11
13 2020-12-04 st-regis-retirement-center-inc ST. REGIS RETIREMENT CENTER, INC. Alameda 1 19 0 1 1 <11     <11
14 2020-12-04 stoneridge-creek-pleasanton STONERIDGE CREEK PLEASANTON Alameda 11 1 0 0 1   <11    
15 2020-12-04 watermark-at-rosewood-gardens-the WATERMARK AT ROSEWOOD GARDENS, THE Alameda 1 24 0 0 1 <11      
16 2020-12-04 watermark-by-the-bay-the WATERMARK BY THE BAY, THE Alameda 1 1 0 0 1 <11 <11    
17 2020-12-04 waters-edge-lodge WATERS EDGE LODGE Alameda 1 1 0 1 1 <11 <11   <11
18 2020-12-04 willow-creek-alzheimer-s-dementia-care-center WILLOW CREEK ALZHEIMER'S & DEMENTIA CARE CENTER Alameda 1 1 0 1 1 <11 <11   <11
19 2020-12-04 amador-residential-care-facility AMADOR RESIDENTIAL CARE FACILITY Amador 1 1 0 1 5 <11 <11   <11
20 2020-12-04 compass-rose COMPASS ROSE Butte 1 1 0 1 7 <11 <11   <11
21 2020-12-04 country-crest-assisted-living COUNTRY CREST ASSISTED LIVING Butte 1 1 0 1 7 <11 <11   <11
22 2020-12-04 windchime-of-chico WINDCHIME OF CHICO Butte 1 20 1 1 7 <11   <11 <11
23 2020-12-04 atria-valley-view ATRIA VALLEY VIEW Contra Costa 12 1 0 0 13   <11    
24 2020-12-04 brookdale-diablo-lodge BROOKDALE DIABLO LODGE Contra Costa 1 1 0 1 13 <11 <11   <11
25 2020-12-04 brookdale-san-ramon BROOKDALE SAN RAMON Contra Costa 1 1 0 0 13 <11 <11    
26 2020-12-04 byron-park BYRON PARK Contra Costa 14 14 0 1 13       <11
27 2020-12-04 chateau-at-poets-corner CHATEAU AT POETS CORNER Contra Costa 22 21 0 1 13       <11
28 2020-12-04 chateau-iii CHATEAU III Contra Costa 37 39 0 1 13       <11
29 2020-12-04 concord-royale CONCORD ROYALE Contra Costa 1 1 0 1 13 <11 <11   <11
30 2020-12-04 friendship-care-home FRIENDSHIP CARE HOME Contra Costa 1 16 0 1 13 <11     <11
31 2020-12-04 greenridge-senior-care GREENRIDGE SENIOR CARE Contra Costa 0 1 0 1 13   <11   <11
32 2020-12-04 reutlinger-community-the REUTLINGER COMMUNITY, THE Contra Costa 1 1 0 1 13 <11 <11   <11
33 2020-12-04 trevista-antioch TREVISTA ANTIOCH Contra Costa 1 1 0 1 13 <11 <11   <11
34 2020-12-04 trevista-concord TREVISTA CONCORD Contra Costa 11 22 0 1 13       <11
35 2020-12-04 walnut-creek-willows WALNUT CREEK WILLOWS Contra Costa 1 1 0 1 13 <11 <11   <11
36 2020-12-04 westmont-of-brentwood WESTMONT OF BRENTWOOD Contra Costa 1 1 0 1 13 <11 <11   <11
37 2020-12-04 westmont-of-pinole WESTMONT OF PINOLE Contra Costa 1 1 0 0 13 <11 <11    
38 2020-12-04 atria-fresno ATRIA FRESNO Fresno 1 1 0 1 19 <11 <11   <11
39 2020-12-04 autumn-ridge-assisted-living AUTUMN RIDGE ASSISTED LIVING Fresno 1 1 0 1 19 <11 <11   <11
40 2020-12-04 belmar-villa BELMAR VILLA Fresno 1 11 0 1 19 <11     <11
41 2020-12-04 carmel-village-memory-care CARMEL VILLAGE MEMORY CARE Fresno 0 1 0 1 19   <11   <11
42 2020-12-04 fairwinds-woodward-park FAIRWINDS - WOODWARD PARK Fresno 21 1 0 1 19   <11   <11
43 2020-12-04 gettysburg-christian-home GETTYSBURG CHRISTIAN HOME Fresno 0 1 0 1 19   <11   <11
44 2020-12-04 kingston-bay-senior-living KINGSTON BAY SENIOR LIVING Fresno 13 1 0 1 19   <11   <11
45 2020-12-04 oakmont-of-fresno OAKMONT OF FRESNO Fresno 1 1 0 1 19 <11 <11   <11
46 2020-12-04 paintbrush-assisted-living-and-memory-care PAINTBRUSH ASSISTED LIVING AND MEMORY CARE Fresno 1 13 0 0 19 <11      
47 2020-12-04 palm-village-retirement-community PALM VILLAGE RETIREMENT COMMUNITY Fresno 13 11 0 0 19        
48 2020-12-04 veterans-home-of-california-fresno VETERANS HOME OF CALIFORNIA-FRESNO Fresno 1 1 0 0 19 <11 <11    
49 2020-12-04 westhaven-assisted-living WESTHAVEN ASSISTED LIVING Glenn 1 17 0 1 21 <11     <11
50 2020-12-04 alder-bay-assisted-living ALDER BAY ASSISTED LIVING Humboldt 1 1 0 1 23 <11 <11   <11
51 2020-12-04 blossom-valley-inn BLOSSOM VALLEY INN Imperial 12 57 0 1 25       <11
52 2020-12-04 heart-hand-inc HEART & HAND, INC. Imperial 1 1 0 0 25 <11 <11    
53 2020-12-04 brookdale-riverwalk BROOKDALE RIVERWALK Kern 1 12 0 0 29 <11      
54 2020-12-04 centre-village CENTRE VILLAGE Kern 23 1 0 0 29   <11    
55 2020-12-04 hallmark-of-bakersfield HALLMARK OF BAKERSFIELD Kern 1 13 0 0 29 <11      
56 2020-12-04 jasmin-terrace-at-bakersfield JASMIN TERRACE AT BAKERSFIELD Kern 1 1 0 1 29 <11 <11   <11
57 2020-12-04 pacifica-of-bakersfield PACIFICA OF BAKERSFIELD Kern 1 1 0 1 29 <11 <11   <11
58 2020-12-04 pointe-at-summit-hills-the POINTE AT SUMMIT HILLS, THE Kern 16 1 0 1 29   <11   <11
59 2020-12-04 rosewood-retirement-community ROSEWOOD RETIREMENT COMMUNITY Kern 1 1 0 1 29 <11 <11   <11
60 2020-12-04 diamond-terraces DIAMOND TERRACES Kings 0 11 0 0 31        
61 2020-12-04 abbey-road-villa ABBEY ROAD VILLA Los Angeles 1 19 0 0 37 <11      
62 2020-12-04 aegis-of-granada-hills AEGIS OF GRANADA HILLS Los Angeles 1 1 0 0 37 <11 <11    
63 2020-12-04 alta-vista-gardens ALTA VISTA GARDENS Los Angeles 1 16 0 0 37 <11      
64 2020-12-04 ararat-home-of-los-angeles ARARAT HOME OF LOS ANGELES Los Angeles 1 1 0 1 37 <11 <11   <11
65 2020-12-04 arbor-vista ARBOR VISTA Los Angeles 1 1 0 1 37 <11 <11   <11
66 2020-12-04 arcadia-gardens-retirement-hotel ARCADIA GARDENS RETIREMENT HOTEL Los Angeles 1 1 0 0 37 <11 <11    
67 2020-12-04 arcadia-retirement-village ARCADIA RETIREMENT VILLAGE Los Angeles 1 13 0 1 37 <11     <11
68 2020-12-04 atherton-baptist-homes ATHERTON BAPTIST HOMES Los Angeles 1 1 0 0 37 <11 <11    
69 2020-12-04 atria-park-of-pacific-palisades ATRIA PARK OF PACIFIC PALISADES Los Angeles 1 1 0 1 37 <11 <11   <11
70 2020-12-04 atria-rancho-park ATRIA RANCHO PARK Los Angeles 1 1 0 1 37 <11 <11   <11
71 2020-12-04 avantgarde-senior-living-of-tarzana AVANTGARDE SENIOR LIVING OF TARZANA Los Angeles 23 17 0 1 37       <11
72 2020-12-04 belmont-village-burbank BELMONT VILLAGE BURBANK Los Angeles 1 1 0 1 37 <11 <11   <11
73 2020-12-04 belmont-village-encino BELMONT VILLAGE ENCINO Los Angeles 32 29 0 1 37       <11
74 2020-12-04 belmont-village-hollywood BELMONT VILLAGE HOLLYWOOD Los Angeles 22 20 0 1 37       <11
75 2020-12-04 belmont-village-rancho-palos-verdes BELMONT VILLAGE RANCHO PALOS VERDES Los Angeles 1 1 0 1 37 <11 <11   <11
76 2020-12-04 belmont-village-westwood BELMONT VILLAGE WESTWOOD Los Angeles 13 1 0 0 37   <11    
77 2020-12-04 beverly-hills-carmel-retirement-hotel BEVERLY HILLS CARMEL RETIREMENT HOTEL Los Angeles 11 16 1 1 37     <11 <11
78 2020-12-04 beverly-hills-gardens-care-center BEVERLY HILLS GARDENS CARE CENTER Los Angeles 1 12 1 1 37 <11   <11 <11
79 2020-12-04 brittany-house BRITTANY HOUSE Los Angeles 1 23 0 1 37 <11     <11
80 2020-12-04 brookdale-central-whittier BROOKDALE CENTRAL WHITTIER Los Angeles 1 1 0 0 37 <11 <11    
81 2020-12-04 brookdale-chatsworth BROOKDALE CHATSWORTH Los Angeles 1 38 0 0 37 <11      
82 2020-12-04 brookdale-gardens-of-tarzana BROOKDALE GARDENS OF TARZANA Los Angeles 1 1 0 1 37 <11 <11   <11
83 2020-12-04 brookdale-monrovia BROOKDALE MONROVIA Los Angeles 1 1 0 1 37 <11 <11   <11
84 2020-12-04 brookdale-northridge BROOKDALE NORTHRIDGE Los Angeles 13 24 0 13 37        
85 2020-12-04 brookdale-san-dimas BROOKDALE SAN DIMAS Los Angeles 1 1 0 0 37 <11 <11    
86 2020-12-04 california-mission-inn CALIFORNIA MISSION INN Los Angeles 1 14 0 1 37 <11     <11
87 2020-12-04 canyon-trails-at-topanga-senior-living CANYON TRAILS AT TOPANGA SENIOR LIVING Los Angeles 25 71 0 11 37        
88 2020-12-04 carroll-manor CARROLL MANOR Los Angeles 1 1 0 1 37 <11 <11   <11
89 2020-12-04 carson-senior-assisted-living CARSON SENIOR ASSISTED LIVING Los Angeles 1 27 0 1 37 <11     <11
90 2020-12-04 casa-colina-transitional-living-center CASA COLINA TRANSITIONAL LIVING CENTER Los Angeles 21 16 0 0 37        
91 2020-12-04 cedars-assisted-living-the CEDARS ASSISTED LIVING, THE Los Angeles 14 51 0 1 37       <11
92 2020-12-04 charlie-s-residential-care CHARLIE'S RESIDENTIAL CARE Los Angeles 1 1 0 1 37 <11 <11   <11
93 2020-12-04 city-view-la-llc CITY VIEW LA, LLC Los Angeles 1 1 0 0 37 <11 <11    
94 2020-12-04 claremont-manor CLAREMONT MANOR Los Angeles 12 1 0 1 37   <11   <11
95 2020-12-04 claremont-place CLAREMONT PLACE Los Angeles 1 11 0 1 37 <11     <11
96 2020-12-04 commons-at-woodland-hills-the COMMONS AT WOODLAND HILLS, THE Los Angeles 24 30 0 1 37       <11
97 2020-12-04 courtyard-plaza COURTYARD PLAZA Los Angeles 17 26 0 11 37        
98 2020-12-04 crofton-manor-inn CROFTON MANOR INN Los Angeles 22 32 0 1 37       <11
99 2020-12-04 downey-retirement-center DOWNEY RETIREMENT CENTER Los Angeles 26 30 0 1 37       <11
100 2020-12-04 eisenberg-vlg-of-the-la-jewish-home-for-the-aging EISENBERG VLG OF THE LA JEWISH HOME FOR THE AGING Los Angeles 18 32 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
);