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

23,231 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
2793 2020-09-15 brookdale-north-fremont BROOKDALE NORTH FREMONT Alameda 21 21 0 1 1       <11
2794 2020-09-15 carlton-plaza-of-san-leandro CARLTON PLAZA OF SAN LEANDRO Alameda 15 1 1 0 1   <11 <11  
2795 2020-09-15 fremont-village FREMONT VILLAGE Alameda 28 48 1 12 1     <11  
2796 2020-09-15 lakeside-park LAKESIDE PARK Alameda 14 1 0 1 1   <11   <11
2797 2020-09-15 lincoln-villa LINCOLN VILLA Alameda 1 1 0 1 1 <11 <11   <11
2798 2020-09-15 marymount-villa-retirement-center MARYMOUNT VILLA RETIREMENT CENTER Alameda 1 1 0 0 1 <11 <11    
2799 2020-09-15 pacifica-senior-living-oakland PACIFICA SENIOR LIVING OAKLAND Alameda 1 1 0 1 1 <11 <11   <11
2800 2020-09-15 point-at-rockridge-the POINT AT ROCKRIDGE, THE Alameda 1 15 0 1 1 <11     <11
2801 2020-09-15 st-regis-retirement-center-inc ST. REGIS RETIREMENT CENTER, INC. Alameda 1 1 0 1 1 <11 <11   <11
2802 2020-09-15 stoneridge-creek-pleasanton STONERIDGE CREEK PLEASANTON Alameda 1 1 0 0 1 <11 <11    
2803 2020-09-15 watermark-by-the-bay-the WATERMARK BY THE BAY, THE Alameda 1 1 0 0 1 <11 <11    
2804 2020-09-15 amador-residential-care-facility AMADOR RESIDENTIAL CARE FACILITY Amador 1 1 0 1 5 <11 <11   <11
2805 2020-09-15 compass-rose COMPASS ROSE Butte 1 1 0 1 7 <11 <11   <11
2806 2020-09-15 windchime-of-chico WINDCHIME OF CHICO Butte 1 15 1 1 7 <11   <11 <11
2807 2020-09-15 atria-valley-view ATRIA VALLEY VIEW Contra Costa 1 1 0 0 13 <11 <11    
2808 2020-09-15 byron-park BYRON PARK Contra Costa 14 14 0 1 13       <11
2809 2020-09-15 chateau-at-poets-corner CHATEAU AT POETS CORNER Contra Costa 21 21 0 1 13       <11
2810 2020-09-15 chateau-iii CHATEAU III Contra Costa 36 39 0 1 13       <11
2811 2020-09-15 greenridge-senior-care GREENRIDGE SENIOR CARE Contra Costa 0 1 0 1 13   <11   <11
2812 2020-09-15 walnut-creek-willows WALNUT CREEK WILLOWS Contra Costa 1 1 0 0 13 <11 <11    
2813 2020-09-15 westmont-of-brentwood WESTMONT OF BRENTWOOD Contra Costa 1 1 0 0 13 <11 <11    
2814 2020-09-15 atria-fresno ATRIA FRESNO Fresno 1 1 0 1 19 <11 <11   <11
2815 2020-09-15 autumn-ridge-assisted-living AUTUMN RIDGE ASSISTED LIVING Fresno 1 1 0 1 19 <11 <11   <11
2816 2020-09-15 belmar-villa BELMAR VILLA Fresno 1 1 0 1 19 <11 <11   <11
2817 2020-09-15 carmel-village-memory-care CARMEL VILLAGE MEMORY CARE Fresno 0 1 0 1 19   <11   <11
2818 2020-09-15 fairwinds-woodward-park FAIRWINDS - WOODWARD PARK Fresno 20 1 0 1 19   <11   <11
2819 2020-09-15 gettysburg-christian-home GETTYSBURG CHRISTIAN HOME Fresno 0 1 0 1 19   <11   <11
2820 2020-09-15 kingston-bay-senior-living KINGSTON BAY SENIOR LIVING Fresno 1 1 0 0 19 <11 <11    
2821 2020-09-15 paintbrush-assisted-living-and-memory-care PAINTBRUSH ASSISTED LIVING AND MEMORY CARE Fresno 1 11 0 0 19 <11      
2822 2020-09-15 palm-village-retirement-community PALM VILLAGE RETIREMENT COMMUNITY Fresno 11 1 0 0 19   <11    
2823 2020-09-15 alder-bay-assisted-living ALDER BAY ASSISTED LIVING Humboldt 1 1 0 1 23 <11 <11   <11
2824 2020-09-15 blossom-valley-inn BLOSSOM VALLEY INN Imperial 12 55 0 1 25       <11
2825 2020-09-15 centre-village CENTRE VILLAGE Kern 20 1 0 0 29   <11    
2826 2020-09-15 hallmark-of-bakersfield HALLMARK OF BAKERSFIELD Kern 1 13 0 0 29 <11      
2827 2020-09-15 jasmin-terrace-at-bakersfield JASMIN TERRACE AT BAKERSFIELD Kern 1 1 0 1 29 <11 <11   <11
2828 2020-09-15 pacifica-of-bakersfield PACIFICA OF BAKERSFIELD Kern 1 1 0 1 29 <11 <11   <11
2829 2020-09-15 rosewood-retirement-community ROSEWOOD RETIREMENT COMMUNITY Kern 1 1 0 1 29 <11 <11   <11
2830 2020-09-15 abbey-road-villa ABBEY ROAD VILLA Los Angeles 1 19 0 0 37 <11      
2831 2020-09-15 aegis-of-granada-hills AEGIS OF GRANADA HILLS Los Angeles 1 1 0 0 37 <11 <11    
2832 2020-09-15 alta-vista-gardens ALTA VISTA GARDENS Los Angeles 1 15 0 0 37 <11      
2833 2020-09-15 ararat-home-of-los-angeles ARARAT HOME OF LOS ANGELES Los Angeles 1 1 0 1 37 <11 <11   <11
2834 2020-09-15 arbor-vista ARBOR VISTA Los Angeles 1 1 0 1 37 <11 <11   <11
2835 2020-09-15 atria-park-of-pacific-palisades ATRIA PARK OF PACIFIC PALISADES Los Angeles 1 1 0 1 37 <11 <11   <11
2836 2020-09-15 atria-rancho-park ATRIA RANCHO PARK Los Angeles 1 1 0 1 37 <11 <11   <11
2837 2020-09-15 avantgarde-senior-living-of-tarzana AVANTGARDE SENIOR LIVING OF TARZANA Los Angeles 22 17 0 1 37       <11
2838 2020-09-15 belmont-village-burbank BELMONT VILLAGE BURBANK Los Angeles 1 1 0 1 37 <11 <11   <11
2839 2020-09-15 belmont-village-encino BELMONT VILLAGE ENCINO Los Angeles 24 26 0 1 37       <11
2840 2020-09-15 belmont-village-hollywood BELMONT VILLAGE HOLLYWOOD Los Angeles 20 18 0 1 37       <11
2841 2020-09-15 belmont-village-rancho-palos-verdes BELMONT VILLAGE RANCHO PALOS VERDES Los Angeles 1 1 0 1 37 <11 <11   <11
2842 2020-09-15 belmont-village-westwood BELMONT VILLAGE WESTWOOD Los Angeles 11 1 0 0 37   <11    
2843 2020-09-15 beverly-hills-carmel-retirement-hotel BEVERLY HILLS CARMEL RETIREMENT HOTEL Los Angeles 1 15 1 1 37 <11   <11 <11
2844 2020-09-15 beverly-hills-gardens-care-center BEVERLY HILLS GARDENS CARE CENTER Los Angeles 1 12 1 1 37 <11   <11 <11
2845 2020-09-15 brittany-house BRITTANY HOUSE Los Angeles 1 19 0 1 37 <11     <11
2846 2020-09-15 brookdale-central-whittier BROOKDALE CENTRAL WHITTIER Los Angeles 1 1 0 0 37 <11 <11    
2847 2020-09-15 brookdale-gardens-of-tarzana BROOKDALE GARDENS OF TARZANA Los Angeles 1 1 0 1 37 <11 <11   <11
2848 2020-09-15 brookdale-monrovia BROOKDALE MONROVIA Los Angeles 1 1 0 1 37 <11 <11   <11
2849 2020-09-15 brookdale-northridge BROOKDALE NORTHRIDGE Los Angeles 11 23 0 13 37        
2850 2020-09-15 canyon-trails-at-topanga-senior-living CANYON TRAILS AT TOPANGA SENIOR LIVING Los Angeles 11 35 0 1 37       <11
2851 2020-09-15 carroll-manor CARROLL MANOR Los Angeles 1 1 0 1 37 <11 <11   <11
2852 2020-09-15 carson-senior-assisted-living CARSON SENIOR ASSISTED LIVING Los Angeles 1 24 0 1 37 <11     <11
2853 2020-09-15 cedars-assisted-living-the CEDARS ASSISTED LIVING, THE Los Angeles 13 39 0 1 37       <11
2854 2020-09-15 charlie-s-residential-care CHARLIE'S RESIDENTIAL CARE Los Angeles 1 1 0 1 37 <11 <11   <11
2855 2020-09-15 city-view-la-llc CITY VIEW LA, LLC Los Angeles 1 1 0 0 37 <11 <11    
2856 2020-09-15 claremont-manor CLAREMONT MANOR Los Angeles 1 1 0 1 37 <11 <11   <11
2857 2020-09-15 commons-at-woodland-hills-the COMMONS AT WOODLAND HILLS, THE Los Angeles 20 29 0 1 37       <11
2858 2020-09-15 crofton-manor-inn CROFTON MANOR INN Los Angeles 22 32 0 1 37       <11
2859 2020-09-15 fallbrook-glen-of-west-hills FALLBROOK GLEN OF WEST HILLS Los Angeles 1 19 0 1 37 <11     <11
2860 2020-09-15 gardena-retirement-center GARDENA RETIREMENT CENTER Los Angeles 0 1 0 1 37   <11   <11
2861 2020-09-15 glen-park-at-glendale-boynton-st GLEN PARK AT GLENDALE - BOYNTON ST Los Angeles 11 21 0 1 37       <11
2862 2020-09-15 glen-park-at-long-beach GLEN PARK AT LONG BEACH Los Angeles 13 23 0 1 37       <11
2863 2020-09-15 golden-assisted-living GOLDEN ASSISTED LIVING Los Angeles 1 12 0 0 37 <11      
2864 2020-09-15 grandview-the GRANDVIEW, THE Los Angeles 1 18 0 1 37 <11     <11
2865 2020-09-15 grove-at-cerritos-the GROVE AT CERRITOS, THE Los Angeles 1 1 0 1 37 <11 <11   <11
2866 2020-09-15 heights-at-burbank-the HEIGHTS AT BURBANK, THE Los Angeles 1 1 0 1 37 <11 <11   <11
2867 2020-09-15 hollenbeck-palms HOLLENBECK PALMS Los Angeles 13 1 0 0 37   <11    
2868 2020-09-15 inn-at-the-park-ventura INN AT THE PARK VENTURA Los Angeles 1 29 0 1 37 <11     <11
2869 2020-09-15 jasmin-terrace-at-el-molino JASMIN TERRACE AT EL MOLINO Los Angeles 29 66 0 19 37        
2870 2020-09-15 kensington-redondo-beach-the KENSINGTON REDONDO BEACH, THE Los Angeles 22 22 1 1 37     <11 <11
2871 2020-09-15 kensington-sierra-madre-the KENSINGTON SIERRA MADRE, THE Los Angeles 18 12 0 1 37       <11
2872 2020-09-15 kingsley-manor KINGSLEY MANOR Los Angeles 1 0 1 0 37 <11   <11  
2873 2020-09-15 lakewood-park-manor LAKEWOOD PARK MANOR Los Angeles 1 1 0 1 37 <11 <11   <11
2874 2020-09-15 lucerne-one-llc LUCERNE ONE LLC Los Angeles 1 1 0 1 37 <11 <11   <11
2875 2020-09-15 meadowbrook-at-agoura-hills MEADOWBROOK AT AGOURA HILLS Los Angeles 1 1 0 1 37 <11 <11   <11
2876 2020-09-15 mgh-corporation-the MGH CORPORATION, THE Los Angeles 1 1 0 1 37 <11 <11   <11
2877 2020-09-15 mountain-view-center MOUNTAIN VIEW CENTER Los Angeles 1 15 0 1 37 <11     <11
2878 2020-09-15 mugungwha-silver-town MUGUNGWHA SILVER TOWN Los Angeles 1 1 0 1 37 <11 <11   <11
2879 2020-09-15 oakmont-of-santa-clarita OAKMONT OF SANTA CLARITA Los Angeles 1 14 0 1 37 <11     <11
2880 2020-09-15 oakmont-of-valencia OAKMONT OF VALENCIA Los Angeles 1 15 0 1 37 <11     <11
2881 2020-09-15 oakview OAKVIEW Los Angeles 13 1 0 1 37   <11   <11
2882 2020-09-15 pacifica-senior-living-northridge PACIFICA SENIOR LIVING NORTHRIDGE Los Angeles 26 42 0 16 37        
2883 2020-09-15 palmcrest-grand-residence PALMCREST GRAND RESIDENCE Los Angeles 1 15 0 1 37 <11     <11
2884 2020-09-15 regency-palms-long-beach REGENCY PALMS LONG BEACH Los Angeles 21 1 0 0 37   <11    
2885 2020-09-15 regency-park-astoria REGENCY PARK ASTORIA Los Angeles 1 1 0 1 37 <11 <11   <11
2886 2020-09-15 rosecrans-villa-residential-care ROSECRANS VILLA RESIDENTIAL CARE Los Angeles 1 14 0 0 37 <11      
2887 2020-09-15 royal-oaks ROYAL OAKS Los Angeles 1 1 0 0 37 <11 <11    
2888 2020-09-15 royal-vista-san-gabriel ROYAL VISTA SAN GABRIEL Los Angeles 13 39 0 1 37       <11
2889 2020-09-15 royalty-assisted-living ROYALTY ASSISTED LIVING Los Angeles 0 1 0 1 37   <11   <11
2890 2020-09-15 san-dimas-retirement-center SAN DIMAS RETIREMENT CENTER Los Angeles 1 1 0 1 37 <11 <11   <11
2891 2020-09-15 silverado-senior-living-calabasas SILVERADO SENIOR LIVING - CALABASAS Los Angeles 17 49 0 13 37        
2892 2020-09-15 silverado-senior-living-beverly-place SILVERADO SENIOR LIVING – BEVERLY PLACE Los Angeles 36 57 1 13 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 13.597ms · 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