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 (show)

rowiddateidnamecountyfipsstaff_confirmed_casespatients_confirmed_casesstaff_confirmed_cases_notepatients_confirmed_cases_notestaff_deathspatients_deathsstaff_deaths_notepatients_deaths_note
1 2020-10-25 140000321 ALAMEDA COUNTY MEDICAL CENTER D/P SNF Alameda 1 1 1 <11 <11 0 0    
2 2020-10-25 20000043 ALAMEDA HEALTHCARE & WELLNESS CENTER Alameda 1 12 17     0 1   <11
3 2020-10-25 630011864 ALAMEDA HOSPITAL - SOUTHSHORE CONVALESCENT Alameda 1 1 1 <11 <11 0 0    
4 2020-10-25 140000686 ALAMEDA HOSPITAL D/P SNF Alameda 1 1 0 <11   0 0    
5 2020-10-25 630013891 ALL SAINT'S MAUBERT Alameda 1 1 0 <11   0 0    
6 2020-10-25 20000070 ALL SAINTS SUBACUTE & TRANSITIONAL CARE Alameda 1 1 0 <11   0 0    
7 2020-10-25 20000010 ASHBY CARE CENTER Alameda 1 0 0     0 0    
8 2020-10-25 140001291 AVONDALE VILLA POST-ACUTE Alameda 1 1 0 <11   0 0    
9 2020-10-25 20000015 BANCROFT HEALTHCARE CENTER Alameda 1 1 0 <11   0 0    
10 2020-10-25 20000135 BAY AREA HEALTHCARE CENTER Alameda 1 1 1 <11 <11 0 0    
11 2020-10-25 20000026 BAY VIEW REHABILITATION HOSPITAL, LLC Alameda 1 1 1 <11 <11 0 0    
12 2020-10-25 20000060 BAYPOINT HEALTHCARE CENTER Alameda 1 1 0 <11   0 0    
13 2020-10-25 630011713 BAYWOOD COURT HEALTH CENTER Alameda 1 1 0 <11   0 0    
14 2020-10-25 20001250 BELLAKEN SKILLED NURSING CENTER Alameda 1 0 0     0 0    
15 2020-10-25 20000028 BERKELEY PINES SKILLED NURSING CENTER Alameda 1 1 18 <11   0 1   <11
16 2020-10-25 20000029 BETHESDA HOME Alameda 1 0 0     0 0    
17 2020-10-25 20000048 CHAPARRAL HOUSE Alameda 1 1 1 <11 <11 0 0    
18 2020-10-25 630015174 CREEKVIEW SKILLED NURSING Alameda 1 1 1 <11 <11 0 0    
19 2020-10-25 20000053 CRESTWOOD MANOR - FREMONT Alameda 1 21 53     1 1 <11 <11
20 2020-10-25 20000129 CRESTWOOD TREATMENT CENTER Alameda 1 1 25 <11   0 0    
21 2020-10-25 20000087 CROWN BAY NURSING & REHABILITATION CENTER Alameda 1 1 0 <11   0 0    
22 2020-10-25 20000133 DRIFTWOOD HEALTHCARE CENTER - HAYWARD Alameda 1 18 32     0 1   <11
23 2020-10-25 20000116 EAST BAY POST-ACUTE Alameda 1 31 33     0 1   <11
24 2020-10-25 20000128 ELMWOOD CARE CENTER Alameda 1 1 1 <11 <11 0 1   <11
25 2020-10-25 20000093 EXCELL HEALTH CARE CENTER Alameda 1 23 44     0 1   <11
26 2020-10-25 20000132 FREMONT HEALTHCARE CENTER Alameda 1 1 38 <11   0 1   <11
27 2020-10-25 20000124 FRUITVALE HEALTHCARE CENTER Alameda 1 15 11     0 0    
28 2020-10-25 20000125 GARFIELD NEUROBEHAVIORAL CENTER Alameda 1 46 45     0 1   <11
29 2020-10-25 20000037 GATEWAY CARE & REHABILITATION CENTER Alameda 1 31 49     0 19    
30 2020-10-25 20000123 HAYWARD CONVALESCENT HOSPITAL Alameda 1 0 0     0 0    
31 2020-10-25 20000039 HAYWARD HEALTHCARE & WELLNESS CENTER Alameda 1 1 1 <11 <11 1 0 <11  
32 2020-10-25 20000047 HAYWARD HILLS HEALTH CARE CENTER Alameda 1 1 0 <11   0 0    
33 2020-10-25 20000111 JONES CONVALESCENT HOSPITAL Alameda 1 0 0     0 0    
34 2020-10-25 20000042 KAISER PERMANENTE POST-ACUTE CARE CENTER Alameda 1 21 18     0 1   <11
35 2020-10-25 20000112 KYAKAMEENA CARE CENTER Alameda 1 1 0 <11   0 0    
36 2020-10-25 20000110 LAKE MERRITT HEALTHCARE CENTER LLC Alameda 1 1 0 <11   0 0    
37 2020-10-25 20000114 LAKE PARK RETIREMENT RESIDENCE Alameda 1 1 0 <11   0 0    
38 2020-10-25 20000104 MARINA GARDEN NURSING CENTER Alameda 1 1 1 <11 <11 0 0    
39 2020-10-25 20000040 MASONIC HOME Alameda 1 1 0 <11   0 0    
40 2020-10-25 20000099 MCCLURE POST ACUTE Alameda 1 0 0     0 0    
41 2020-10-25 20000079 MEDICAL HILL HEALTHCARE CENTER Alameda 1 31 50     0 0    
42 2020-10-25 20000100 MERCY RETIREMENT & CARE CENTER Alameda 1 20 20     0 12    
43 2020-10-25 20000808 MORTON BAKAR CENTER Alameda 1 23 52     0 1   <11
44 2020-10-25 20000101 NILES CANYON POST ACUTE Alameda 1 1 1 <11 <11 0 1   <11
45 2020-10-25 20000115 OAKLAND HEALTHCARE & WELLNESS CENTER Alameda 1 1 1 <11 <11 0 0    
46 2020-10-25 20000880 OAKLAND HEIGHTS NURSING AND REHABILITATION Alameda 1 1 0 <11   0 0    
47 2020-10-25 630014635 PARK BRIDGE REHABILITATION AND WELLNESS CENTER Alameda 1 1 1 <11 <11 0 0    
48 2020-10-25 20000094 PARK CENTRAL CARE AND REHABILITATION CENTER Alameda 1 1 0 <11   0 0    
49 2020-10-25 20000090 PARKVIEW HEALTHCARE CENTER Alameda 1 20 101     1 12 <11  
50 2020-10-25 20000091 PIEDMONT GARDENS HEALTH FACILITY Alameda 1 1 0 <11   0 0    
51 2020-10-25 140000086 PLEASANTON NURSING AND REHABILITATION CENTER Alameda 1 42 49     1 12 <11  
52 2020-10-25 20000054 PRINCETON MANOR HEALTHCARE CENTER, LLC Alameda 1 16 25     0 1   <11
53 2020-10-25 20000276 REDWOOD CONVALESCENT HOSPITAL, INC. Alameda 1 1 21 <11   0 1   <11
54 2020-10-25 20000119 REDWOOD HEALTHCARE CENTER LLC Alameda 1 17 29     0 1   <11
55 2020-10-25 20000077 SAN LEANDRO HEALTHCARE CENTER Alameda 1 1 11 <11   0 1   <11
56 2020-10-25 20000074 SERENETHOS CARE CENTER, LLC Alameda 1 12 24     0 1   <11
57 2020-10-25 20000005 ST ANTHONY CARE CENTER Alameda 1 1 0 <11   0 0    
58 2020-10-25 20000076 ST FRANCIS HEALTHCARE CENTER Alameda 1 1 0 <11   0 0    
59 2020-10-25 20000068 ST JOHN KRONSTADT CONVALESCENT CENTER Alameda 1 0 0     0 0    
60 2020-10-25 20000064 ST PAULS TOWERS Alameda 1 0 0     0 0    
61 2020-10-25 630014957 STRATFORD VILLA POST-ACUTE Alameda 1 1 1 <11 <11 0 0    
62 2020-10-25 20000274 THE REHABILITATION CENTER OF OAKLAND Alameda 1 1 24 <11   0 1   <11
63 2020-10-25 140000122 THE VINEYARDS HEALTHCARE CENTER Alameda 1 1 1 <11 <11 0 0    
64 2020-10-25 140000626 VALLEY MEMORIAL HOSPITAL D/P SNF Alameda 1 0 0     0 0    
65 2020-10-25 20000066 VALLEY POINTE NURSING & REHABILITATION CENTER Alameda 1 1 1 <11 <11 0 0    
66 2020-10-25 20000019 VISTA POST ACUTE Alameda 1 27 48     0 1   <11
67 2020-10-25 20000275 WASHINGTON CENTER Alameda 1 1 0 <11   0 0    
68 2020-10-25 20000065 WE CARE SKILLED NURSING FACILITY Alameda 1 1 0 <11   0 0    
69 2020-10-25 20000020 WINDSOR COUNTRY DRIVE CARE CENTER Alameda 1 21 23     0 0    
70 2020-10-25 20000103 WINDSOR GARDENS CARE CENTER OF HAYWARD Alameda 1 1 1 <11 <11 0 0    
71 2020-10-25 20000277 WINDSOR HEALTHCARE CENTER OF OAKLAND Alameda 1 34 59     0 1   <11
72 2020-10-25 20000036 WINDSOR PARK CARE CENTER OF FREMONT Alameda 1 20 37     0 1   <11
73 2020-10-25 20000071 WINDSOR POST-ACUTE CARE CENTER OF HAYWARD Alameda 1 35 30     0 1   <11
74 2020-10-25 30000074 KIT CARSON NURSING & REHABILITATION CENTER Amador 5 22 51     0 16    
75 2020-10-25 230000255 ARBOR POST ACUTE Butte 7 29 36     0 1   <11
76 2020-10-25 230000546 CALIFORNIA PARK REHABILITATION HOSPITAL Butte 7 15 1   <11 0 1   <11
77 2020-10-25 230000802 COUNTRY CREST POST ACUTE Butte 7 1 1 <11 <11 0 0    
78 2020-10-25 230000327 ORCHARD HOSPITAL D/P SNF Butte 7 1 0 <11   0 0    
79 2020-10-25 230000221 OROVILLE HOSPITAL POST-ACUTE CENTER Butte 7 1 0 <11   0 0    
80 2020-10-25 230000036 RIVERSIDE CONVALESCENT HOSPITAL Butte 7 27 48     0 1   <11
81 2020-10-25 230000037 SHADOWBROOK POST ACUTE Butte 7 1 0 <11   0 0    
82 2020-10-25 230000025 WINDSOR CHICO CARE CENTER Butte 7 1 11 <11   0 1   <11
83 2020-10-25 230000029 WINDSOR CHICO CREEK CARE AND REHABILITATION CENTER Butte 7 29 42     0 1   <11
84 2020-10-25 30000012 AVALON HEALTH CARE - SAN ANDREAS Calaveras 9 18 51     0 1   <11
85 2020-10-25 230000424 COLUSA MEDICAL CENTER - SNF Colusa 11 1 1 <11 <11 0 1   <11
86 2020-10-25 230000283 VALLEY WEST POST ACUTE Colusa 11 42 30     0 1   <11
87 2020-10-25 140000574 ALHAMBRA CONVALESCENT HOSPITAL Contra Costa 13 1 0 <11   0 0    
88 2020-10-25 140000003 ANTIOCH CONVALESCENT HOSPITAL Contra Costa 13 1 0 <11   0 0    
89 2020-10-25 140000023 BAYBERRY SKILLED NURSING & HEALTHCARE CENTER Contra Costa 13 29 56     0 1   <11
90 2020-10-25 140000138 CREEKSIDE HEALTHCARE CENTER Contra Costa 13 1 1 <11 <11 0 0    
91 2020-10-25 140000130 DANVILLE POST-ACUTE REHAB Contra Costa 13 1 0 <11   0 0    
92 2020-10-25 140000564 DIAMOND RIDGE HEALTHCARE CENTER Contra Costa 13 17 22     0 1   <11
93 2020-10-25 140000038 GREENRIDGE POST ACUTE Contra Costa 13 1 0 <11   0 0    
94 2020-10-25 140000051 LA CASA VIA TRANSITIONAL CARE CENTER Contra Costa 13 1 0 <11   0 0    
95 2020-10-25 140000102 LEGACY NURSING AND REHABILITATION CENTER Contra Costa 13 13 13     0 1   <11
96 2020-10-25 140000105 LONE TREE CONVALESCENT HOSPITAL Contra Costa 13 1 0 <11   0 0    
97 2020-10-25 140000745 MANORCARE HEALTH SERVICES - ROSSMOOR Contra Costa 13 1 1 <11 <11 0 0    
98 2020-10-25 140001126 MANORCARE HEALTH SERVICES - TICE VALLEY Contra Costa 13 39 93     0 17    
99 2020-10-25 140000106 MARTINEZ CONVALESCENT HOSPITAL Contra Costa 13 1 1 <11 <11 1 1 <11 <11
100 2020-10-25 140000081 MORAGA POST ACUTE Contra Costa 13 1 11 <11   0 0    
101 2020-10-25 140000092 ORINDA CARE CENTER, LLC Contra Costa 13 36 40     0 1   <11
Powered by Datasette · Query took 62.376ms · About: simonw/covid-19-datasette