la_times_cdph_adult_and_senior_care_facilities

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

30,833 rows sorted by date descending

View and edit SQL

Suggested facets: date (date)

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-10-23 arcadian-residential-community ARCADIAN RESIDENTIAL COMMUNITY Alameda 15 28 0 1 1       <11
2 2020-10-23 brookdale-north-fremont BROOKDALE NORTH FREMONT Alameda 22 21 0 1 1       <11
3 2020-10-23 carlton-plaza-of-san-leandro CARLTON PLAZA OF SAN LEANDRO Alameda 16 1 1 0 1   <11 <11  
4 2020-10-23 fremont-village FREMONT VILLAGE Alameda 28 48 1 12 1     <11  
5 2020-10-23 lakeside-park LAKESIDE PARK Alameda 14 1 0 1 1   <11   <11
6 2020-10-23 lincoln-villa LINCOLN VILLA Alameda 1 1 0 1 1 <11 <11   <11
7 2020-10-23 marymount-villa-retirement-center MARYMOUNT VILLA RETIREMENT CENTER Alameda 1 20 0 0 1 <11      
8 2020-10-23 pacifica-senior-living-oakland PACIFICA SENIOR LIVING OAKLAND Alameda 1 1 0 1 1 <11 <11   <11
9 2020-10-23 point-at-rockridge-the POINT AT ROCKRIDGE, THE Alameda 1 15 0 1 1 <11     <11
10 2020-10-23 st-regis-retirement-center-inc ST. REGIS RETIREMENT CENTER, INC. Alameda 1 1 0 1 1 <11 <11   <11
11 2020-10-23 stoneridge-creek-pleasanton STONERIDGE CREEK PLEASANTON Alameda 1 1 0 0 1 <11 <11    
12 2020-10-23 watermark-by-the-bay-the WATERMARK BY THE BAY, THE Alameda 1 1 0 0 1 <11 <11    
13 2020-10-23 amador-residential-care-facility AMADOR RESIDENTIAL CARE FACILITY Amador 1 1 0 1 5 <11 <11   <11
14 2020-10-23 compass-rose COMPASS ROSE Butte 1 1 0 1 7 <11 <11   <11
15 2020-10-23 country-crest-assisted-living COUNTRY CREST ASSISTED LIVING Butte 1 1 0 1 7 <11 <11   <11
16 2020-10-23 windchime-of-chico WINDCHIME OF CHICO Butte 1 20 1 1 7 <11   <11 <11
17 2020-10-23 atria-valley-view ATRIA VALLEY VIEW Contra Costa 1 1 0 0 13 <11 <11    
18 2020-10-23 brookdale-diablo-lodge BROOKDALE DIABLO LODGE Contra Costa 1 1 0 1 13 <11 <11   <11
19 2020-10-23 byron-park BYRON PARK Contra Costa 14 14 0 1 13       <11
20 2020-10-23 chateau-at-poets-corner CHATEAU AT POETS CORNER Contra Costa 22 21 0 1 13       <11
21 2020-10-23 chateau-iii CHATEAU III Contra Costa 36 39 0 1 13       <11
22 2020-10-23 concord-royale CONCORD ROYALE Contra Costa 1 1 0 1 13 <11 <11   <11
23 2020-10-23 friendship-care-home FRIENDSHIP CARE HOME Contra Costa 1 16 0 1 13 <11     <11
24 2020-10-23 greenridge-senior-care GREENRIDGE SENIOR CARE Contra Costa 0 1 0 1 13   <11   <11
25 2020-10-23 reutlinger-community-the REUTLINGER COMMUNITY, THE Contra Costa 1 1 0 1 13 <11 <11   <11
26 2020-10-23 trevista-antioch TREVISTA ANTIOCH Contra Costa 1 1 0 1 13 <11 <11   <11
27 2020-10-23 walnut-creek-willows WALNUT CREEK WILLOWS Contra Costa 1 1 0 0 13 <11 <11    
28 2020-10-23 westmont-of-brentwood WESTMONT OF BRENTWOOD Contra Costa 1 1 0 1 13 <11 <11   <11
29 2020-10-23 atria-fresno ATRIA FRESNO Fresno 1 1 0 1 19 <11 <11   <11
30 2020-10-23 autumn-ridge-assisted-living AUTUMN RIDGE ASSISTED LIVING Fresno 1 1 0 1 19 <11 <11   <11
31 2020-10-23 belmar-villa BELMAR VILLA Fresno 1 1 0 1 19 <11 <11   <11
32 2020-10-23 carmel-village-memory-care CARMEL VILLAGE MEMORY CARE Fresno 0 1 0 1 19   <11   <11
33 2020-10-23 fairwinds-woodward-park FAIRWINDS - WOODWARD PARK Fresno 21 1 0 1 19   <11   <11
34 2020-10-23 gettysburg-christian-home GETTYSBURG CHRISTIAN HOME Fresno 0 1 0 1 19   <11   <11
35 2020-10-23 kingston-bay-senior-living KINGSTON BAY SENIOR LIVING Fresno 1 1 0 0 19 <11 <11    
36 2020-10-23 oakmont-of-fresno OAKMONT OF FRESNO Fresno 1 1 0 1 19 <11 <11   <11
37 2020-10-23 paintbrush-assisted-living-and-memory-care PAINTBRUSH ASSISTED LIVING AND MEMORY CARE Fresno 1 13 0 0 19 <11      
38 2020-10-23 palm-village-retirement-community PALM VILLAGE RETIREMENT COMMUNITY Fresno 12 1 0 0 19   <11    
39 2020-10-23 alder-bay-assisted-living ALDER BAY ASSISTED LIVING Humboldt 1 1 0 1 23 <11 <11   <11
40 2020-10-23 blossom-valley-inn BLOSSOM VALLEY INN Imperial 12 57 0 1 25       <11
41 2020-10-23 heart-hand-inc HEART & HAND, INC. Imperial 1 1 0 0 25 <11 <11    
42 2020-10-23 brookdale-riverwalk BROOKDALE RIVERWALK Kern 1 12 0 0 29 <11      
43 2020-10-23 hallmark-of-bakersfield HALLMARK OF BAKERSFIELD Kern 1 13 0 0 29 <11      
44 2020-10-23 jasmin-terrace-at-bakersfield JASMIN TERRACE AT BAKERSFIELD Kern 1 1 0 1 29 <11 <11   <11
45 2020-10-23 pacifica-of-bakersfield PACIFICA OF BAKERSFIELD Kern 1 1 0 1 29 <11 <11   <11
46 2020-10-23 pointe-at-summit-hills-the POINTE AT SUMMIT HILLS, THE Kern 1 1 0 1 29 <11 <11   <11
47 2020-10-23 rosewood-retirement-community ROSEWOOD RETIREMENT COMMUNITY Kern 1 1 0 1 29 <11 <11   <11
48 2020-10-23 abbey-road-villa ABBEY ROAD VILLA Los Angeles 1 19 0 0 37 <11      
49 2020-10-23 aegis-of-granada-hills AEGIS OF GRANADA HILLS Los Angeles 1 1 0 0 37 <11 <11    
50 2020-10-23 alta-vista-gardens ALTA VISTA GARDENS Los Angeles 1 16 0 0 37 <11      
51 2020-10-23 ararat-home-of-los-angeles ARARAT HOME OF LOS ANGELES Los Angeles 1 1 0 1 37 <11 <11   <11
52 2020-10-23 arbor-vista ARBOR VISTA Los Angeles 1 1 0 1 37 <11 <11   <11
53 2020-10-23 arcadia-gardens-retirement-hotel ARCADIA GARDENS RETIREMENT HOTEL Los Angeles 12 12 0 0 37        
54 2020-10-23 atria-park-of-pacific-palisades ATRIA PARK OF PACIFIC PALISADES Los Angeles 1 1 0 1 37 <11 <11   <11
55 2020-10-23 atria-rancho-park ATRIA RANCHO PARK Los Angeles 1 1 0 1 37 <11 <11   <11
56 2020-10-23 avantgarde-senior-living-of-tarzana AVANTGARDE SENIOR LIVING OF TARZANA Los Angeles 22 17 0 1 37       <11
57 2020-10-23 belmont-village-burbank BELMONT VILLAGE BURBANK Los Angeles 1 1 0 1 37 <11 <11   <11
58 2020-10-23 belmont-village-encino BELMONT VILLAGE ENCINO Los Angeles 25 27 0 1 37       <11
59 2020-10-23 belmont-village-hollywood BELMONT VILLAGE HOLLYWOOD Los Angeles 20 20 0 1 37       <11
60 2020-10-23 belmont-village-rancho-palos-verdes BELMONT VILLAGE RANCHO PALOS VERDES Los Angeles 1 1 0 1 37 <11 <11   <11
61 2020-10-23 belmont-village-westwood BELMONT VILLAGE WESTWOOD Los Angeles 11 1 0 0 37   <11    
62 2020-10-23 beverly-hills-carmel-retirement-hotel BEVERLY HILLS CARMEL RETIREMENT HOTEL Los Angeles 1 15 1 1 37 <11   <11 <11
63 2020-10-23 beverly-hills-gardens-care-center BEVERLY HILLS GARDENS CARE CENTER Los Angeles 1 12 1 1 37 <11   <11 <11
64 2020-10-23 brittany-house BRITTANY HOUSE Los Angeles 1 20 0 1 37 <11     <11
65 2020-10-23 brookdale-central-whittier BROOKDALE CENTRAL WHITTIER Los Angeles 1 1 0 0 37 <11 <11    
66 2020-10-23 brookdale-gardens-of-tarzana BROOKDALE GARDENS OF TARZANA Los Angeles 1 1 0 1 37 <11 <11   <11
67 2020-10-23 brookdale-monrovia BROOKDALE MONROVIA Los Angeles 1 1 0 1 37 <11 <11   <11
68 2020-10-23 brookdale-northridge BROOKDALE NORTHRIDGE Los Angeles 12 23 0 13 37        
69 2020-10-23 brookdale-san-dimas BROOKDALE SAN DIMAS Los Angeles 1 1 0 0 37 <11 <11    
70 2020-10-23 canyon-trails-at-topanga-senior-living CANYON TRAILS AT TOPANGA SENIOR LIVING Los Angeles 22 51 0 1 37       <11
71 2020-10-23 carroll-manor CARROLL MANOR Los Angeles 1 1 0 1 37 <11 <11   <11
72 2020-10-23 carson-senior-assisted-living CARSON SENIOR ASSISTED LIVING Los Angeles 1 24 0 1 37 <11     <11
73 2020-10-23 cedars-assisted-living-the CEDARS ASSISTED LIVING, THE Los Angeles 13 39 0 1 37       <11
74 2020-10-23 charlie-s-residential-care CHARLIE'S RESIDENTIAL CARE Los Angeles 1 1 0 1 37 <11 <11   <11
75 2020-10-23 city-view-la-llc CITY VIEW LA, LLC Los Angeles 1 1 0 0 37 <11 <11    
76 2020-10-23 claremont-manor CLAREMONT MANOR Los Angeles 1 1 0 1 37 <11 <11   <11
77 2020-10-23 claremont-place CLAREMONT PLACE Los Angeles 1 1 0 0 37 <11 <11    
78 2020-10-23 commons-at-woodland-hills-the COMMONS AT WOODLAND HILLS, THE Los Angeles 20 29 0 1 37       <11
79 2020-10-23 courtyard-plaza COURTYARD PLAZA Los Angeles 11 20 0 1 37       <11
80 2020-10-23 crofton-manor-inn CROFTON MANOR INN Los Angeles 22 32 0 1 37       <11
81 2020-10-23 eisenberg-vlg-of-the-la-jewish-home-for-the-aging EISENBERG VLG OF THE LA JEWISH HOME FOR THE AGING Los Angeles 1 1 0 1 37 <11 <11   <11
82 2020-10-23 fallbrook-glen-of-west-hills FALLBROOK GLEN OF WEST HILLS Los Angeles 1 19 0 1 37 <11     <11
83 2020-10-23 fountainview-at-gonda-westside FOUNTAINVIEW AT GONDA WESTSIDE Los Angeles 1 1 0 0 37 <11 <11    
84 2020-10-23 gardena-retirement-center GARDENA RETIREMENT CENTER Los Angeles 1 1 0 1 37 <11 <11   <11
85 2020-10-23 glen-park-at-glendale-boynton-st GLEN PARK AT GLENDALE - BOYNTON ST Los Angeles 12 22 0 1 37       <11
86 2020-10-23 glen-park-at-long-beach GLEN PARK AT LONG BEACH Los Angeles 13 23 0 1 37       <11
87 2020-10-23 golden-assisted-living GOLDEN ASSISTED LIVING Los Angeles 1 12 0 0 37 <11      
88 2020-10-23 grandview-the GRANDVIEW, THE Los Angeles 1 18 0 1 37 <11     <11
89 2020-10-23 grove-at-cerritos-the GROVE AT CERRITOS, THE Los Angeles 1 1 0 1 37 <11 <11   <11
90 2020-10-23 havens-at-antelope-valley-assisted-living-the HAVENS AT ANTELOPE VALLEY ASSISTED LIVING, THE Los Angeles 1 1 0 1 37 <11 <11   <11
91 2020-10-23 heights-at-burbank-the HEIGHTS AT BURBANK, THE Los Angeles 1 1 0 1 37 <11 <11   <11
92 2020-10-23 hollenbeck-palms HOLLENBECK PALMS Los Angeles 13 1 0 0 37   <11    
93 2020-10-23 inn-at-the-park-ventura INN AT THE PARK VENTURA Los Angeles 1 29 0 1 37 <11     <11
94 2020-10-23 jasmin-terrace-at-el-molino JASMIN TERRACE AT EL MOLINO Los Angeles 31 68 0 19 37        
95 2020-10-23 kensington-redondo-beach-the KENSINGTON REDONDO BEACH, THE Los Angeles 22 23 0 1 37       <11
96 2020-10-23 kensington-sierra-madre-the KENSINGTON SIERRA MADRE, THE Los Angeles 18 12 0 1 37       <11
97 2020-10-23 kingsley-manor KINGSLEY MANOR Los Angeles 1 0 1 0 37 <11   <11  
98 2020-10-23 lakewood-park-manor LAKEWOOD PARK MANOR Los Angeles 1 1 0 1 37 <11 <11   <11
99 2020-10-23 lucerne-one-llc LUCERNE ONE LLC Los Angeles 1 1 0 1 37 <11 <11   <11
100 2020-10-23 meadowbrook-at-agoura-hills MEADOWBROOK AT AGOURA HILLS Los Angeles 20 30 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
);
Powered by Datasette · Query took 1503.959ms · 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