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

10,308 rows sorted by date descending

View and edit SQL

Link rowid date ▲ id name county fips staff_confirmed_cases patients_confirmed_cases staff_confirmed_cases_note patients_confirmed_cases_note staff_deaths patients_deaths staff_deaths_note patients_deaths_note
694 2020-07-31 None Brookdale North Fremont Alameda 1 17 21     0 1   10 or fewer
695 2020-07-31 None Carlton Plaza Of San Leandro Alameda 1 1 1 10 or fewer 10 or fewer 0 0    
696 2020-07-31 None Fremont Village Alameda 1 27 47     0 1   10 or fewer
697 2020-07-31 None Lincoln Villa Alameda 1 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
698 2020-07-31 None Point At Rockridge, The Alameda 1 1 14 10 or fewer   0 1   10 or fewer
699 2020-07-31 None St. Regis Retirement Center, Inc. Alameda 1 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
700 2020-07-31 None Chateau At Poets Corner Contra Costa 13 1 18 10 or fewer   0 1   10 or fewer
701 2020-07-31 None Chateau III Contra Costa 13 36 39     0 1   10 or fewer
702 2020-07-31 None Greenridge Senior Care Contra Costa 13 0 1   10 or fewer 0 1   10 or fewer
703 2020-07-31 None Carmel Village Memory Care Fresno 19 0 1   10 or fewer 0 1   10 or fewer
704 2020-07-31 None Fairwinds - Woodward Park Fresno 19 20 1   10 or fewer 0 1   10 or fewer
705 2020-07-31 None Gettysburg Christian Home Fresno 19 0 1   10 or fewer 0 1   10 or fewer
706 2020-07-31 None Alder Bay Assisted Living Humboldt 23 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
707 2020-07-31 None Blossom Valley Inn Imperial 25 1 37 10 or fewer   0 0    
708 2020-07-31 None Hallmark Of Bakersfield Kern 29 1 13 10 or fewer   0 0    
709 2020-07-31 None Pacifica Of Bakersfield Kern 29 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
710 2020-07-31 None Alta Vista Gardens Los Angeles 37 1 14 10 or fewer   0 0    
711 2020-07-31 None Ararat Home Of Los Angeles Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
712 2020-07-31 None Arbor Vista Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
713 2020-07-31 None Atria Park Of Pacific Palisades Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
714 2020-07-31 None Avantgarde Senior Living Of Tarzana Los Angeles 37 22 17     0 1   10 or fewer
715 2020-07-31 None Belmont Village Encino Los Angeles 37 24 26     0 1   10 or fewer
716 2020-07-31 None Belmont Village Hollywood Los Angeles 37 20 18     0 1   10 or fewer
717 2020-07-31 None Belmont Village Rancho Palos Verdes Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
718 2020-07-31 None Belmont Village Westwood Los Angeles 37 11 1   10 or fewer 0 0    
719 2020-07-31 None Beverly Hills Carmel Retirement Hotel Los Angeles 37 1 15 10 or fewer   1 1 10 or fewer 10 or fewer
720 2020-07-31 None Beverly Hills Gardens Care Center Los Angeles 37 1 12 10 or fewer   1 1 10 or fewer 10 or fewer
721 2020-07-31 None Brookdale Central Whittier Los Angeles 37 1 1 10 or fewer 10 or fewer 0 0    
722 2020-07-31 None Brookdale Gardens Of Tarzana Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
723 2020-07-31 None Brookdale Monrovia Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
724 2020-07-31 None Brookdale Northridge Los Angeles 37 11 23     0 13    
725 2020-07-31 None Canyon Trails At Topanga Senior Living Los Angeles 37 12 35     0 1   10 or fewer
726 2020-07-31 None Carson Senior Assisted Living Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
727 2020-07-31 None Cedars Assisted Living, The Los Angeles 37 14 39     0 1   10 or fewer
728 2020-07-31 None Charlie's Residential Care Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
729 2020-07-31 None City View La, LLC Los Angeles 37 1 1 10 or fewer 10 or fewer 0 0    
730 2020-07-31 None Commons At Woodland Hills, The Los Angeles 37 19 29     0 1   10 or fewer
731 2020-07-31 None Crofton Manor Inn Los Angeles 37 22 32     0 1   10 or fewer
732 2020-07-31 None Fallbrook Glen Of West Hills Los Angeles 37 1 19 10 or fewer   0 1   10 or fewer
733 2020-07-31 None Glen Park At Glendale - Boynton St Los Angeles 37 11 21     0 1   10 or fewer
734 2020-07-31 None Golden Assisted Living Los Angeles 37 1 12 10 or fewer   0 0    
735 2020-07-31 None Grandview, The Los Angeles 37 1 18 10 or fewer   0 1   10 or fewer
736 2020-07-31 None Grove At Cerritos, The Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
737 2020-07-31 None Heights At Burbank, The Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
738 2020-07-31 None Hollenbeck Palms Los Angeles 37 1 1 10 or fewer 10 or fewer 0 0    
739 2020-07-31 None Inn At The Park Ventura Los Angeles 37 1 29 10 or fewer   0 1   10 or fewer
740 2020-07-31 None Jasmin Terrace At El Molino Los Angeles 37 26 66     0 18    
741 2020-07-31 None Kensington Redondo Beach, The Los Angeles 37 22 22     1 1 10 or fewer 10 or fewer
742 2020-07-31 None Kensington Sierra Madre, The Los Angeles 37 17 12     0 1   10 or fewer
743 2020-07-31 None Kingsley Manor Los Angeles 37 1 0 10 or fewer   1 0 10 or fewer  
744 2020-07-31 None Lakewood Park Manor Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
745 2020-07-31 None Lucerne One Llc Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
746 2020-07-31 None Meadowbrook At Agoura Hills Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
747 2020-07-31 None Mugungwha Silver Town Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
748 2020-07-31 None Oakmont Of Santa Clarita Los Angeles 37 1 14 10 or fewer   0 1   10 or fewer
749 2020-07-31 None Oakmont Of Valencia Los Angeles 37 1 15 10 or fewer   0 1   10 or fewer
750 2020-07-31 None Pacifica Senior Living Northridge Los Angeles 37 26 42     0 16    
751 2020-07-31 None Palmcrest Grand Residence Los Angeles 37 1 15 10 or fewer   0 1   10 or fewer
752 2020-07-31 None Regency Palms Long Beach Los Angeles 37 12 1   10 or fewer 0 0    
753 2020-07-31 None Rosecrans Villa Residential Care Los Angeles 37 1 14 10 or fewer   0 0    
754 2020-07-31 None Royalty Assisted Living Los Angeles 37 0 1   10 or fewer 0 1   10 or fewer
755 2020-07-31 None Silverado Senior Living - Calabasas Los Angeles 37 17 49     0 13    
756 2020-07-31 None Silverado Senior Living – Beverly Place Los Angeles 37 33 57     1 13 10 or fewer  
757 2020-07-31 None Solheim Senior Community Los Angeles 37 11 1   10 or fewer 0 1   10 or fewer
758 2020-07-31 None Sunrise Assisted Living Of Studio City Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
759 2020-07-31 None Sunrise At Sterling Canyon Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
760 2020-07-31 None Sunrise Of Beverly Hills Los Angeles 37 1 1 10 or fewer 10 or fewer 0 0    
761 2020-07-31 None Sunrise Of Westlake Village Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
762 2020-07-31 None Sunrise Villa Culver City Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
763 2020-07-31 None Veterans Home Of California – West Los Angeles Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
764 2020-07-31 None Villa Gardens Los Angeles 37 38 17     0 1   10 or fewer
765 2020-07-31 None Village At Sherman Oaks, The Los Angeles 37 1 1 10 or fewer 10 or fewer 0 0    
766 2020-07-31 None Vista Del Mar Senior Living Los Angeles 37 11 28     0 1   10 or fewer
767 2020-07-31 None Watermark At Beverly Hills, The Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
768 2020-07-31 None West Valley Assisted Living Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
769 2020-07-31 None Western Assemblies Home Los Angeles 37 11 1   10 or fewer 0 1   10 or fewer
770 2020-07-31 None Whittier Place Senior Living Los Angeles 37 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
771 2020-07-31 None Cedar Creek Senior Living Madera 39 1 21 10 or fewer   0 1   10 or fewer
772 2020-07-31 None Atria Tamalpais Creek Marin 41 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
773 2020-07-31 None Drake Terrace Marin 41 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
774 2020-07-31 None Golden Home Extended Care, Inc. Marin 41 1 13 10 or fewer   0 0    
775 2020-07-31 None Nazareth House Of San Rafael, Inc. Marin 41 1 16 10 or fewer   0 1   10 or fewer
776 2020-07-31 None Windchime Of Marin Marin 41 1 11 10 or fewer   0 1   10 or fewer
777 2020-07-31 None Acacia Villas Orange 59 1 14 10 or fewer   0 1   10 or fewer
778 2020-07-31 None Activcare At Yorba Linda Orange 59 11 16     0 1   10 or fewer
779 2020-07-31 None Anaheim Crown Plaza Orange 59 1 1 10 or fewer 10 or fewer 0 0    
780 2020-07-31 None Atria San Juan Orange 59 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
781 2020-07-31 None Brookdale Anaheim Orange 59 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
782 2020-07-31 None Brookdale Nohl Ranch Orange 59 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
783 2020-07-31 None Brookdale Yorba Linda Orange 59 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
784 2020-07-31 None Carmel Village Retirement Community Orange 59 12 1   10 or fewer 0 1   10 or fewer
785 2020-07-31 None Harbor Heights Assisted Living & Memory Care Orange 59 1 1 10 or fewer 10 or fewer 0 0    
786 2020-07-31 None Heathers - Wintergreen, The Orange 59 1 1 10 or fewer 10 or fewer 0 0    
787 2020-07-31 None Heritage Pointe Orange 59 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
788 2020-07-31 None Huntington Terrace Orange 59 1 22 10 or fewer   0 1   10 or fewer
789 2020-07-31 None Karlton Residential Care Center Orange 59 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
790 2020-07-31 None Merrill Gardens At Huntington Beach Orange 59 11 1   10 or fewer 0 0    
791 2020-07-31 None Park Regency Retirement Center Orange 59 1 23 10 or fewer   0 0    
792 2020-07-31 None Park Terrace Orange 59 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
793 2020-07-31 None Regency, The Orange 59 1 1 10 or fewer 10 or fewer 0 1   10 or fewer

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [la_times_cdph_adult_and_senior_care_facilities] (
   [date] TEXT,
   [id] TEXT,
   [name] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [staff_confirmed_cases] INTEGER,
   [patients_confirmed_cases] INTEGER,
   [staff_confirmed_cases_note] TEXT,
   [patients_confirmed_cases_note] TEXT,
   [staff_deaths] INTEGER,
   [patients_deaths] INTEGER,
   [staff_deaths_note] TEXT,
   [patients_deaths_note] TEXT
);
Powered by Datasette · Query took 9.459ms · 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