+-------+------------+---------------------------------------------------+-------------+-----------------------+--------------------------+--------------+-----------------+------+----------------------------+-------------------------------+-------------------+----------------------+ | rowid | date | 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-06-27 | Veterans Home Of California- Fresno | Fresno | 32 | 14 | 0 | 0 | 19 | | | | | | 102 | 2021-06-27 | Westmont Of Fresno | Fresno | 12 | 1 | 0 | 0 | 19 | | <11 | | | | 103 | 2021-06-27 | Windham, The | Fresno | 1 | 14 | 0 | 1 | 19 | <11 | | | <11 | | 104 | 2021-06-27 | Westhaven Assisted Living | Glenn | 17 | 33 | 0 | 1 | 21 | | | | <11 | | 105 | 2021-06-27 | Alder Bay Assisted Living | Humboldt | 1 | 1 | 0 | 1 | 23 | <11 | <11 | | <11 | | 106 | 2021-06-27 | A&a Cottage View Assisted Living,inc. | Imperial | 1 | 1 | 0 | 1 | 25 | <11 | <11 | | <11 | | 107 | 2021-06-27 | Blossom Valley Inn | Imperial | 12 | 58 | 0 | 1 | 25 | | | | <11 | | 108 | 2021-06-27 | Heart & Hand, Inc. | Imperial | 1 | 1 | 0 | 0 | 25 | <11 | <11 | | | | 109 | 2021-06-27 | Brookdale Riverwalk | Kern | 1 | 18 | 0 | 0 | 29 | <11 | | | | | 110 | 2021-06-27 | Carrington Of Shafter | Kern | 1 | 1 | 0 | 0 | 29 | <11 | <11 | | | | 111 | 2021-06-27 | Centre Village | Kern | 39 | 1 | 0 | 0 | 29 | | <11 | | | | 112 | 2021-06-27 | Golden Castle Assisted Living | Kern | 0 | 15 | 0 | 0 | 29 | | | | | | 113 | 2021-06-27 | Hallmark Of Bakersfield | Kern | 1 | 13 | 0 | 0 | 29 | <11 | | | | | 114 | 2021-06-27 | Jasmin Terrace At Bakersfield | Kern | 1 | 1 | 0 | 1 | 29 | <11 | <11 | | <11 | | 115 | 2021-06-27 | Pacifica Senior Living Bakersfield | Kern | 1 | 1 | 0 | 1 | 29 | <11 | <11 | | <11 | | 116 | 2021-06-27 | Palms At San Lauren, The | Kern | 1 | 1 | 0 | 1 | 29 | <11 | <11 | | <11 | | 117 | 2021-06-27 | Pointe At Summit Hills, The | Kern | 22 | 1 | 0 | 1 | 29 | | <11 | | <11 | | 118 | 2021-06-27 | Riverside Ranch, Asc Treatment Group | Kern | 1 | 1 | 0 | 0 | 29 | <11 | <11 | | | | 119 | 2021-06-27 | Rosewood Retirement Community | Kern | 18 | 1 | 0 | 1 | 29 | | <11 | | <11 | | 120 | 2021-06-27 | Westchester Gardens | Kern | 1 | 17 | 0 | 1 | 29 | <11 | | | <11 | | 121 | 2021-06-27 | Diamond Terraces | Kings | 1 | 14 | 0 | 0 | 31 | <11 | | | | | 122 | 2021-06-27 | Orchard Park Senior Living Community | Lake | 18 | 16 | 0 | 0 | 33 | | | | | | 123 | 2021-06-27 | Eagle Lake Village | Lassen | 1 | 1 | 0 | 1 | 35 | <11 | <11 | | <11 | | 124 | 2021-06-27 | Abbey Road Villa | Los Angeles | 1 | 36 | 0 | 0 | 37 | <11 | | | | | 125 | 2021-06-27 | Aegis Of Granada Hills | Los Angeles | 22 | 29 | 0 | 1 | 37 | | | | <11 | | 126 | 2021-06-27 | Alta Vista Gardens | Los Angeles | 1 | 16 | 0 | 0 | 37 | <11 | | | | | 127 | 2021-06-27 | Alvarado Care Home | Los Angeles | 1 | 11 | 0 | 0 | 37 | <11 | | | | | 128 | 2021-06-27 | Ambassador Garden | Los Angeles | 1 | 12 | 0 | 0 | 37 | <11 | | | | | 129 | 2021-06-27 | Angelica Guest Home | Los Angeles | 1 | 23 | 0 | 1 | 37 | <11 | | | <11 | | 130 | 2021-06-27 | Ararat Home Of Los Angeles | Los Angeles | 1 | 1 | 0 | 1 | 37 | <11 | <11 | | <11 | | 131 | 2021-06-27 | Arbor Vista | Los Angeles | 13 | 20 | 0 | 1 | 37 | | | | <11 | | 132 | 2021-06-27 | Arcadia Gardens Retirement Hotel | Los Angeles | 21 | 1 | 0 | 0 | 37 | | <11 | | | | 133 | 2021-06-27 | Arcadia Living Llc | Los Angeles | 13 | 26 | 0 | 1 | 37 | | | | <11 | | 134 | 2021-06-27 | Arcadia Retirement Village | Los Angeles | 13 | 19 | 0 | 1 | 37 | | | | <11 | | 135 | 2021-06-27 | Arcadian, The | Los Angeles | 26 | 93 | 1 | 25 | 37 | | | <11 | | | 136 | 2021-06-27 | Artesia Christian Home | Los Angeles | 14 | 1 | 0 | 0 | 37 | | <11 | | | | 137 | 2021-06-27 | Atherton Baptist Homes | Los Angeles | 24 | 1 | 0 | 1 | 37 | | <11 | | <11 | | 138 | 2021-06-27 | Atria Covina | Los Angeles | 18 | 37 | 0 | 1 | 37 | | | | <11 | | 139 | 2021-06-27 | Atria Park Of Pacific Palisades | Los Angeles | 24 | 20 | 0 | 1 | 37 | | | | <11 | | 140 | 2021-06-27 | Atria Rancho Park | Los Angeles | 21 | 46 | 1 | 1 | 37 | | | <11 | <11 | | 141 | 2021-06-27 | Atria Santa Clarita | Los Angeles | 25 | 34 | 0 | 1 | 37 | | | | <11 | | 142 | 2021-06-27 | Atria Tarzana | Los Angeles | 15 | 21 | 0 | 1 | 37 | | | | <11 | | 143 | 2021-06-27 | Avantgarde Senior Living Of Tarzana | Los Angeles | 26 | 25 | 0 | 1 | 37 | | | | <11 | | 144 | 2021-06-27 | Bell Gardens Manor | Los Angeles | 1 | 1 | 0 | 0 | 37 | <11 | <11 | | | | 145 | 2021-06-27 | Bella Vista | Los Angeles | 11 | 15 | 0 | 0 | 37 | | | | | | 146 | 2021-06-27 | Belmont Village Burbank | Los Angeles | 35 | 44 | 0 | 1 | 37 | | | | <11 | | 147 | 2021-06-27 | Belmont Village Calabasas | Los Angeles | 55 | 50 | 1 | 1 | 37 | | | <11 | <11 | | 148 | 2021-06-27 | Belmont Village Encino | Los Angeles | 54 | 43 | 1 | 1 | 37 | | | <11 | <11 | | 149 | 2021-06-27 | Belmont Village Hollywood | Los Angeles | 29 | 23 | 0 | 1 | 37 | | | | <11 | | 150 | 2021-06-27 | Belmont Village Rancho Palos Verdes | Los Angeles | 27 | 24 | 0 | 1 | 37 | | | | <11 | | 151 | 2021-06-27 | Belmont Village Westwood | Los Angeles | 75 | 36 | 1 | 1 | 37 | | | <11 | <11 | | 152 | 2021-06-27 | Beverly Hills Carmel Retirement Hotel | Los Angeles | 27 | 22 | 1 | 1 | 37 | | | <11 | <11 | | 153 | 2021-06-27 | Beverly Hills Carmel Retirement Hotel North | Los Angeles | 15 | 1 | 1 | 0 | 37 | | <11 | <11 | | | 154 | 2021-06-27 | Beverly Hills Gardens Care Center | Los Angeles | 1 | 12 | 1 | 1 | 37 | <11 | | <11 | <11 | | 155 | 2021-06-27 | Beverly Hills Loving Care | Los Angeles | 11 | 14 | 0 | 0 | 37 | | | | | | 156 | 2021-06-27 | Beverly Hills Senior Care | Los Angeles | 1 | 40 | 0 | 1 | 37 | <11 | | | <11 | | 157 | 2021-06-27 | Bixby Knolls Tower | Los Angeles | 1 | 18 | 0 | 0 | 37 | <11 | | | | | 158 | 2021-06-27 | Brethren Hillcrest Homes | Los Angeles | 11 | 19 | 0 | 1 | 37 | | | | <11 | | 159 | 2021-06-27 | Brittany House | Los Angeles | 18 | 47 | 0 | 1 | 37 | | | | <11 | | 160 | 2021-06-27 | Broadview Residential Care Center | Los Angeles | 1 | 1 | 0 | 1 | 37 | <11 | <11 | | <11 | | 161 | 2021-06-27 | Brookdale Alhambra | Los Angeles | 15 | 1 | 1 | 0 | 37 | | <11 | <11 | | | 162 | 2021-06-27 | Brookdale Central Whittier | Los Angeles | 15 | 35 | 0 | 1 | 37 | | | | <11 | | 163 | 2021-06-27 | Brookdale Chatsworth | Los Angeles | 22 | 50 | 0 | 1 | 37 | | | | <11 | | 164 | 2021-06-27 | Brookdale Gardens Of Tarzana | Los Angeles | 1 | 11 | 0 | 1 | 37 | <11 | | | <11 | | 165 | 2021-06-27 | Brookdale Monrovia | Los Angeles | 1 | 1 | 0 | 1 | 37 | <11 | <11 | | <11 | | 166 | 2021-06-27 | Brookdale Northridge | Los Angeles | 22 | 25 | 0 | 13 | 37 | | | | | | 167 | 2021-06-27 | Brookdale Ocean House | Los Angeles | 22 | 15 | 0 | 0 | 37 | | | | | | 168 | 2021-06-27 | Brookdale San Dimas | Los Angeles | 27 | 26 | 0 | 1 | 37 | | | | <11 | | 169 | 2021-06-27 | Brookdale Santa Monica Gardens | Los Angeles | 1 | 1 | 0 | 0 | 37 | <11 | <11 | | | | 170 | 2021-06-27 | Brookdale Uptown Whittier | Los Angeles | 1 | 20 | 0 | 1 | 37 | <11 | | | <11 | | 171 | 2021-06-27 | Brookdale Walnut | Los Angeles | 17 | 38 | 0 | 1 | 37 | | | | <11 | | 172 | 2021-06-27 | C.M.A. | Los Angeles | 1 | 24 | 0 | 0 | 37 | <11 | | | | | 173 | 2021-06-27 | California Mission Inn | Los Angeles | 12 | 19 | 0 | 1 | 37 | | | | <11 | | 174 | 2021-06-27 | California Mission Inn - Rose Manor | Los Angeles | 0 | 1 | 0 | 1 | 37 | | <11 | | <11 | | 175 | 2021-06-27 | Canyon Trails At Topanga Senior Living | Los Angeles | 34 | 74 | 0 | 12 | 37 | | | | | | 176 | 2021-06-27 | Cardinal Yu-Pin Manor | Los Angeles | 1 | 1 | 0 | 1 | 37 | <11 | <11 | | <11 | | 177 | 2021-06-27 | Carroll Manor | Los Angeles | 1 | 1 | 0 | 1 | 37 | <11 | <11 | | <11 | | 178 | 2021-06-27 | Carson Senior Assisted Living | Los Angeles | 26 | 50 | 0 | 1 | 37 | | | | <11 | | 179 | 2021-06-27 | Casa Colina Transitional Living Center | Los Angeles | 25 | 20 | 0 | 0 | 37 | | | | | | 180 | 2021-06-27 | Cedars Assisted Living, The | Los Angeles | 18 | 57 | 0 | 1 | 37 | | | | <11 | | 181 | 2021-06-27 | Centinela Assisted Living Centre | Los Angeles | 1 | 31 | 0 | 1 | 37 | <11 | | | <11 | | 182 | 2021-06-27 | Charlie's Residential Care | Los Angeles | 1 | 1 | 0 | 1 | 37 | <11 | <11 | | <11 | | 183 | 2021-06-27 | Chateau Long Beach | Los Angeles | 17 | 55 | 0 | 1 | 37 | | | | <11 | | 184 | 2021-06-27 | City View La, LLC | Los Angeles | 22 | 21 | 0 | 1 | 37 | | | | <11 | | 185 | 2021-06-27 | Claremont Manor | Los Angeles | 29 | 1 | 0 | 1 | 37 | | <11 | | <11 | | 186 | 2021-06-27 | Claremont Place | Los Angeles | 24 | 23 | 1 | 1 | 37 | | | <11 | <11 | | 187 | 2021-06-27 | Clearwater At South Bay | Los Angeles | 27 | 22 | 0 | 1 | 37 | | | | <11 | | 188 | 2021-06-27 | Climb, Inc. | Los Angeles | 19 | 35 | 0 | 1 | 37 | | | | <11 | | 189 | 2021-06-27 | Commons At Woodland Hills, The | Los Angeles | 50 | 68 | 1 | 1 | 37 | | | <11 | <11 | | 190 | 2021-06-27 | Commonwealth Royale Guest Home | Los Angeles | 1 | 17 | 0 | 0 | 37 | <11 | | | | | 191 | 2021-06-27 | Coral Oaks Care Living | Los Angeles | 1 | 14 | 0 | 1 | 37 | <11 | | | <11 | | 192 | 2021-06-27 | Country Inn Of Downey | Los Angeles | 1 | 14 | 0 | 1 | 37 | <11 | | | <11 | | 193 | 2021-06-27 | Country View Assisted Living | Los Angeles | 22 | 51 | 0 | 1 | 37 | | | | <11 | | 194 | 2021-06-27 | Country Villa Terrace Assisted Living Center | Los Angeles | 1 | 32 | 0 | 1 | 37 | <11 | | | <11 | | 195 | 2021-06-27 | Courtyard Plaza | Los Angeles | 23 | 31 | 0 | 13 | 37 | | | | | | 196 | 2021-06-27 | Crofton Manor Inn | Los Angeles | 39 | 59 | 0 | 1 | 37 | | | | <11 | | 197 | 2021-06-27 | D4, Inc. | Los Angeles | 1 | 22 | 0 | 1 | 37 | <11 | | | <11 | | 198 | 2021-06-27 | Del Mar Park | Los Angeles | 19 | 28 | 0 | 1 | 37 | | | | <11 | | 199 | 2021-06-27 | Downey Retirement Center | Los Angeles | 35 | 39 | 0 | 1 | 37 | | | | <11 | | 200 | 2021-06-27 | Eisenberg Vlg of the LA Jewish Home for the Aging | Los Angeles | 31 | 50 | 0 | 1 | 37 | | | | <11 | +-------+------------+---------------------------------------------------+-------------+-----------------------+--------------------------+--------------+-----------------+------+----------------------------+-------------------------------+-------------------+----------------------+