covid

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

Custom SQL query returning 101 rows (hide)

rowiddateslugnamecountystaff_confirmed_casespatients_confirmed_casesstaff_deathspatients_deathsfipsstaff_confirmed_cases_notepatients_confirmed_cases_notestaff_deaths_notepatients_deaths_note
1 2021-04-21 acacia-creek-union-city ACACIA CREEK - UNION CITY Alameda 1 1 0 0 1 <11 <11    
2 2021-04-21 aegis-assisted-living-of-fremont AEGIS ASSISTED LIVING OF FREMONT Alameda 12 15 0 0 1        
3 2021-04-21 arcadian-residential-community ARCADIAN RESIDENTIAL COMMUNITY Alameda 15 28 0 1 1       <11
4 2021-04-21 belmont-village-albany BELMONT VILLAGE ALBANY Alameda 15 1 0 0 1   <11    
5 2021-04-21 brookdale-north-fremont BROOKDALE NORTH FREMONT Alameda 22 26 0 1 1       <11
6 2021-04-21 carefield-pleasanton CAREFIELD PLEASANTON Alameda 17 24 0 1 1       <11
7 2021-04-21 carlton-plaza-of-fremont CARLTON PLAZA OF FREMONT Alameda 13 1 0 0 1   <11    
8 2021-04-21 carlton-plaza-of-san-leandro CARLTON PLAZA OF SAN LEANDRO Alameda 35 41 1 1 1     <11 <11
9 2021-04-21 creekview-assisted-living CREEKVIEW ASSISTED LIVING Alameda 28 28 0 1 1       <11
10 2021-04-21 diana-s-care-home DIANA'S CARE HOME Alameda 1 29 0 0 1 <11      
11 2021-04-21 elder-ashram ELDER ASHRAM Alameda 1 18 0 0 1 <11      
12 2021-04-21 fremont-hills FREMONT HILLS Alameda 1 1 0 0 1 <11 <11    
13 2021-04-21 fremont-rtrmt-com-happy-lvng-by-cogir-cogir-fremon FREMONT RTRMT COM-HAPPY LVNG BY COGIR/COGIR FREMON Alameda 1 1 0 0 1 <11 <11    
14 2021-04-21 fremont-village FREMONT VILLAGE Alameda 33 60 1 14 1     <11  
15 2021-04-21 heritage-haven HERITAGE HAVEN Alameda 1 21 0 1 1 <11     <11
16 2021-04-21 j-sei-home J-SEI HOME Alameda 1 1 0 1 1 <11 <11   <11
17 2021-04-21 lakeside-park LAKESIDE PARK Alameda 21 18 0 1 1       <11
18 2021-04-21 landmark-villa LANDMARK VILLA Alameda 1 1 0 0 1 <11 <11    
19 2021-04-21 lincoln-villa LINCOLN VILLA Alameda 1 18 0 1 1 <11     <11
20 2021-04-21 marymount-villa-retirement-center MARYMOUNT VILLA RETIREMENT CENTER Alameda 17 49 1 16 1     <11  
21 2021-04-21 masonic-home-for-adults MASONIC HOME FOR ADULTS Alameda 17 1 0 0 1   <11    
22 2021-04-21 merrill-gardens-at-rockridge MERRILL GARDENS AT ROCKRIDGE Alameda 11 1 1 1 1   <11 <11 <11
23 2021-04-21 mori-manor MORI MANOR Alameda 1 1 0 1 1 <11 <11   <11
24 2021-04-21 oakcreek OAKCREEK Alameda 1 15 0 1 1 <11     <11
25 2021-04-21 oakmont-of-mariner-point OAKMONT OF MARINER POINT Alameda 24 26 0 1 1       <11
26 2021-04-21 pacifica-senior-living-oakland PACIFICA SENIOR LIVING OAKLAND Alameda 18 22 0 1 1       <11
27 2021-04-21 pacifica-senior-living-san-leandro PACIFICA SENIOR LIVING SAN LEANDRO Alameda 1 1 0 0 1 <11 <11    
28 2021-04-21 parkview-the PARKVIEW, THE Alameda 19 41 0 1 1       <11
29 2021-04-21 point-at-rockridge-the POINT AT ROCKRIDGE, THE Alameda 13 35 0 1 1       <11
30 2021-04-21 quail-garden QUAIL GARDEN Alameda 1 16 0 1 1 <11     <11
31 2021-04-21 rosegate ROSEGATE Alameda 11 19 0 0 1        
32 2021-04-21 scott-villa SCOTT VILLA Alameda 1 30 0 1 1 <11     <11
33 2021-04-21 silverado-senior-living-berkeley SILVERADO SENIOR LIVING - BERKELEY Alameda 33 58 0 14 1        
34 2021-04-21 st-paul-s-towers ST. PAUL'S TOWERS Alameda 20 1 0 0 1   <11    
35 2021-04-21 st-regis-retirement-center-inc ST. REGIS RETIREMENT CENTER, INC. Alameda 11 19 0 1 1       <11
36 2021-04-21 stoneridge-creek-pleasanton STONERIDGE CREEK PLEASANTON Alameda 38 1 0 0 1   <11    
37 2021-04-21 sunrise-of-pleasanton SUNRISE OF PLEASANTON Alameda 13 16 0 0 1        
38 2021-04-21 watermark-at-rosewood-gardens-the WATERMARK AT ROSEWOOD GARDENS, THE Alameda 14 34 0 1 1       <11
39 2021-04-21 watermark-by-the-bay-the WATERMARK BY THE BAY, THE Alameda 12 1 0 0 1   <11    
40 2021-04-21 waters-edge-lodge WATERS EDGE LODGE Alameda 1 1 0 1 1 <11 <11   <11
41 2021-04-21 willow-creek-alzheimer-s-dementia-care-center WILLOW CREEK ALZHEIMER'S & DEMENTIA CARE CENTER Alameda 1 1 0 1 1 <11 <11   <11
42 2021-04-21 woodside-residential-care-facility-for-elderly WOODSIDE RESIDENTIAL CARE FACILITY FOR ELDERLY Alameda 1 11 0 1 1 <11     <11
43 2021-04-21 amador-residential-care-facility AMADOR RESIDENTIAL CARE FACILITY Amador 1 1 0 1 5 <11 <11   <11
44 2021-04-21 amber-grove-place AMBER GROVE PLACE Butte 13 21 0 1 7       <11
45 2021-04-21 compass-rose COMPASS ROSE Butte 11 20 0 1 7       <11
46 2021-04-21 country-crest-assisted-living COUNTRY CREST ASSISTED LIVING Butte 1 1 0 1 7 <11 <11   <11
47 2021-04-21 country-house COUNTRY HOUSE Butte 1 15 0 0 7 <11      
48 2021-04-21 courtyard-at-little-chico-creek-the COURTYARD AT LITTLE CHICO CREEK, THE Butte 18 22 0 0 7        
49 2021-04-21 prestige-assisted-living-at-chico PRESTIGE ASSISTED LIVING AT CHICO Butte 14 0 1 0 7     <11  
50 2021-04-21 roseleaf-gardens ROSELEAF GARDENS Butte 13 26 1 1 7     <11 <11
51 2021-04-21 townsend-house TOWNSEND HOUSE Butte 1 17 0 0 7 <11      
52 2021-04-21 windchime-of-chico WINDCHIME OF CHICO Butte 1 20 1 1 7 <11   <11 <11
53 2021-04-21 aegis-assisted-living-of-moraga AEGIS ASSISTED LIVING OF MORAGA Contra Costa 11 1 0 0 13   <11    
54 2021-04-21 aegis-assisted-living-of-pleasant-hill AEGIS ASSISTED LIVING OF PLEASANT HILL Contra Costa 19 28 0 1 13       <11
55 2021-04-21 atria-valley-view ATRIA VALLEY VIEW Contra Costa 12 1 0 0 13   <11    
56 2021-04-21 atria-walnut-creek ATRIA WALNUT CREEK Contra Costa 1 1 0 0 13 <11 <11    
57 2021-04-21 brookdale-diablo-lodge BROOKDALE DIABLO LODGE Contra Costa 1 12 0 1 13 <11     <11
58 2021-04-21 brookdale-san-ramon BROOKDALE SAN RAMON Contra Costa 1 1 0 1 13 <11 <11   <11
59 2021-04-21 byron-park BYRON PARK Contra Costa 17 14 0 1 13       <11
60 2021-04-21 carnelian-i CARNELIAN I Contra Costa 1 1 0 1 13 <11 <11   <11
61 2021-04-21 chateau-at-poets-corner CHATEAU AT POETS CORNER Contra Costa 27 28 0 1 13       <11
62 2021-04-21 chateau-iii CHATEAU III Contra Costa 38 39 0 1 13       <11
63 2021-04-21 commons-at-dallas-ranch-the COMMONS AT DALLAS RANCH, THE Contra Costa 13 16 0 1 13       <11
64 2021-04-21 concord-royale CONCORD ROYALE Contra Costa 1 1 0 1 13 <11 <11   <11
65 2021-04-21 friendship-care-home FRIENDSHIP CARE HOME Contra Costa 1 16 0 1 13 <11     <11
66 2021-04-21 greenridge-senior-care GREENRIDGE SENIOR CARE Contra Costa 1 1 0 1 13 <11 <11   <11
67 2021-04-21 heatherwood-memory-care HEATHERWOOD MEMORY CARE Contra Costa 1 1 0 0 13 <11 <11    
68 2021-04-21 kensington-the KENSINGTON, THE Contra Costa 1 1 0 0 13 <11 <11    
69 2021-04-21 montecito-oakmont-senior-living MONTECITO OAKMONT SENIOR LIVING Contra Costa 1 1 0 0 13 <11 <11    
70 2021-04-21 pleasant-hill-oasis PLEASANT HILL OASIS Contra Costa 14 16 0 0 13        
71 2021-04-21 reutlinger-community-the REUTLINGER COMMUNITY, THE Contra Costa 14 1 0 1 13   <11   <11
72 2021-04-21 sunrise-assisted-living-of-danville SUNRISE ASSISTED LIVING OF DANVILLE Contra Costa 33 25 0 1 13       <11
73 2021-04-21 sunrise-assisted-living-of-walnut-creek SUNRISE ASSISTED LIVING OF WALNUT CREEK Contra Costa 17 25 0 1 13       <11
74 2021-04-21 sunrise-villa-san-ramon SUNRISE VILLA SAN RAMON Contra Costa 1 1 0 1 13 <11 <11   <11
75 2021-04-21 trevista-antioch TREVISTA ANTIOCH Contra Costa 28 45 0 1 13       <11
76 2021-04-21 trevista-concord TREVISTA CONCORD Contra Costa 12 22 0 1 13       <11
77 2021-04-21 walnut-creek-willows WALNUT CREEK WILLOWS Contra Costa 1 1 0 1 13 <11 <11   <11
78 2021-04-21 westmont-of-brentwood WESTMONT OF BRENTWOOD Contra Costa 25 34 0 1 13       <11
79 2021-04-21 westmont-of-pinole WESTMONT OF PINOLE Contra Costa 1 1 0 0 13 <11 <11    
80 2021-04-21 eskaton-village-placerville ESKATON VILLAGE PLACERVILLE El Dorado 18 26 0 1 17       <11
81 2021-04-21 new-west-haven-ii NEW WEST HAVEN II El Dorado 1 15 0 1 17 <11     <11
82 2021-04-21 oakmont-of-el-dorado-hills OAKMONT OF EL DORADO HILLS El Dorado 1 1 0 0 17 <11 <11    
83 2021-04-21 ponte-palmero PONTE PALMERO El Dorado 1 1 0 1 17 <11 <11   <11
84 2021-04-21 autumn-ridge-assisted-living AUTUMN RIDGE ASSISTED LIVING Fresno 1 1 0 1 19 <11 <11   <11
85 2021-04-21 belmar-villa BELMAR VILLA Fresno 1 14 0 1 19 <11     <11
86 2021-04-21 carmel-village-at-clovis CARMEL VILLAGE AT CLOVIS Fresno 23 1 0 0 19   <11    
87 2021-04-21 carmel-village-memory-care CARMEL VILLAGE MEMORY CARE Fresno 23 28 0 1 19       <11
88 2021-04-21 compass-pointe-memory-care COMPASS POINTE MEMORY CARE Fresno 1 26 0 1 19 <11     <11
89 2021-04-21 fairwinds-woodward-park FAIRWINDS - WOODWARD PARK Fresno 25 15 0 1 19       <11
90 2021-04-21 gettysburg-christian-home GETTYSBURG CHRISTIAN HOME Fresno 0 1 0 1 19   <11   <11
91 2021-04-21 harvest-at-fowler-the HARVEST AT FOWLER, THE Fresno 1 1 0 1 19 <11 <11   <11
92 2021-04-21 kingston-bay-senior-living KINGSTON BAY SENIOR LIVING Fresno 19 12 0 1 19       <11
93 2021-04-21 oakmont-of-fresno OAKMONT OF FRESNO Fresno 19 36 0 1 19       <11
94 2021-04-21 pacifica-senior-living-fresno PACIFICA SENIOR LIVING FRESNO Fresno 16 15 1 1 19     <11 <11
95 2021-04-21 paintbrush-assisted-living-and-memory-care PAINTBRUSH ASSISTED LIVING AND MEMORY CARE Fresno 18 32 0 0 19        
96 2021-04-21 palm-village-retirement-community PALM VILLAGE RETIREMENT COMMUNITY Fresno 29 18 0 0 19        
97 2021-04-21 rehabilitation-centre-of-fresno REHABILITATION CENTRE OF FRESNO Fresno 1 27 0 1 19 <11     <11
98 2021-04-21 sierra-view-homes-residential-care SIERRA VIEW HOMES RESIDENTIAL CARE Fresno 13 1 0 0 19   <11    
99 2021-04-21 terraces-at-san-joaquin-gardens-the TERRACES AT SAN JOAQUIN GARDENS, THE Fresno 42 32 0 1 19       <11
100 2021-04-21 twilight-haven TWILIGHT HAVEN Fresno 12 11 0 0 19        
101 2021-04-21 veterans-home-of-california-fresno VETERANS HOME OF CALIFORNIA-FRESNO Fresno 30 14 0 0 19