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)

rowiddatecountyfipsplaceconfirmed_casesnotexy
1 2020-10-27 Alameda 1 Alameda 459   -122.274444 37.756111
2 2020-10-27 Alameda 1 Albany 63   -122.297778 37.886944
3 2020-10-27 Alameda 1 Berkeley 757   -122.272778 37.871667
4 2020-10-27 Alameda 1 Dublin 326   -121.935833 37.702222
5 2020-10-27 Alameda 1 Emeryville 104   -122.285278 37.831389
6 2020-10-27 Alameda 1 Fremont 1633   -121.988611 37.548333
7 2020-10-27 Alameda 1 Hayward 3475   -122.080796 37.66882
8 2020-10-27 Alameda 1 Homeless 152      
9 2020-10-27 Alameda 1 Livermore 1004   -121.768056 37.681944
10 2020-10-27 Alameda 1 Newark 630   -122.033333 37.533333
11 2020-10-27 Alameda 1 Oakland 9064   -122.270833 37.804444
12 2020-10-27 Alameda 1 Other 38      
13 2020-10-27 Alameda 1 Piedmont 43   -122.233333 37.816667
14 2020-10-27 Alameda 1 Pleasanton 513   -121.874722 37.6625
15 2020-10-27 Alameda 1 San Leandro 1291   -122.156111 37.725
16 2020-10-27 Alameda 1 Sunol 12   -121.888611 37.594444
17 2020-10-27 Alameda 1 Union City 905   -122.048333 37.596389
18 2020-10-27 Amador 5 Ione & surrounding unincorporated areas 71   -120.932778 38.352778
19 2020-10-27 Amador 5 Jackson 123   -120.774167 38.348889
20 2020-10-27 Amador 5 Pine Grove 26   -120.658889 38.413056
21 2020-10-27 Amador 5 Pioneer 23   -120.571944 38.431944
22 2020-10-27 Amador 5 Plymouth & surrounding unincorporated areas 18   -120.844722 38.481944
23 2020-10-27 Amador 5 State Prison Inmate 45   -120.9532 38.3703
24 2020-10-27 Amador 5 Sutter Creek & Amador City 34   -120.8025 38.393056
25 2020-10-27 Amador 5 Volcano 6   -120.562377 38.409966
26 2020-10-27 Butte 7 Biggs/Gridley 267   -121.705559 39.385866
27 2020-10-27 Butte 7 Chico 2124   -121.837651 39.728494
28 2020-10-27 Butte 7 Durham 31   -121.795876 39.664949
29 2020-10-27 Butte 7 Oroville 594   -121.556649 39.51384
30 2020-10-27 Butte 7 Other 22      
31 2020-10-27 Butte 7 Ridge Communities 67   -121.580872 39.799577
32 2020-10-27 Calaveras 9 District 1 162   -120.829167 38.191667
33 2020-10-27 Calaveras 9 District 2 32   -120.540833 38.228333
34 2020-10-27 Calaveras 9 District 3 29   -120.076111 38.438889
35 2020-10-27 Calaveras 9 District 4 48   -120.641944 37.981111
36 2020-10-27 Calaveras 9 District 5 76   -120.866667 38.1
37 2020-10-27 Contra Costa 13 Alamo 124   -122.032222 37.850278
38 2020-10-27 Contra Costa 13 Antioch 2479   -121.805833 38.005
39 2020-10-27 Contra Costa 13 Bay Point 978   -121.961667 38.029167
40 2020-10-27 Contra Costa 13 Bethel Island 14   -121.640556 38.015
41 2020-10-27 Contra Costa 13 Brentwood 732   -121.695833 37.931944
42 2020-10-27 Contra Costa 13 Byron 24   -121.638056 37.867222
43 2020-10-27 Contra Costa 13 Clayton 65   -121.935833 37.941111
44 2020-10-27 Contra Costa 13 Concord 2506   -122.031111 37.978056
45 2020-10-27 Contra Costa 13 Crockett 19   -122.213056 38.0525
46 2020-10-27 Contra Costa 13 Danville 384   -122.0 37.821667
47 2020-10-27 Contra Costa 13 Discovery Bay 125   -121.600278 37.908611
48 2020-10-27 Contra Costa 13 El Cerrito 122   -122.311667 37.915833
49 2020-10-27 Contra Costa 13 El Sobrante 313   -122.295278 37.977222
50 2020-10-27 Contra Costa 13 Hercules 279   -122.288611 38.017222
51 2020-10-27 Contra Costa 13 Lafayette 158   -122.118056 37.885833
52 2020-10-27 Contra Costa 13 Martinez 418   -122.134167 38.019444
53 2020-10-27 Contra Costa 13 Moraga 79   -122.129722 37.835
54 2020-10-27 Contra Costa 13 Oakley 583   -121.7125 37.9975
55 2020-10-27 Contra Costa 13 Orinda 130   -122.179722 37.882778
56 2020-10-27 Contra Costa 13 Other 191      
57 2020-10-27 Contra Costa 13 Pacheco 73   -122.075278 37.983611
58 2020-10-27 Contra Costa 13 Pinole 249   -122.291111 38.004444
59 2020-10-27 Contra Costa 13 Pittsburg 2105   -121.884722 38.028056
60 2020-10-27 Contra Costa 13 Pleasant Hill 310   -122.0525 37.948056
61 2020-10-27 Contra Costa 13 Richmond 3551   -122.347778 37.935833
62 2020-10-27 Contra Costa 13 Rodeo 118   -122.266944 38.033056
63 2020-10-27 Contra Costa 13 San Pablo 1609   -122.345556 37.962222
64 2020-10-27 Contra Costa 13 San Ramon 414   -121.978056 37.78
65 2020-10-27 Contra Costa 13 Walnut Creek 665   -122.065 37.906389
66 2020-10-27 El Dorado 17 Camino, Pollock Pines, Kyburz 45   -120.586594 38.761292
67 2020-10-27 El Dorado 17 El Dorado Hills 368   -121.082222 38.685833
68 2020-10-27 El Dorado 17 El Dorado, Diamond Springs 38   -120.815 38.694722
69 2020-10-27 El Dorado 17 Greater Placerville Area 151   -120.798611 38.729722
70 2020-10-27 El Dorado 17 North County 36   -120.306071 38.99614
71 2020-10-27 El Dorado 17 Shingle Springs, Cameron Park, Rescue 176   -120.987222 38.668889
72 2020-10-27 El Dorado 17 South County 14   -120.57326 38.581296
73 2020-10-27 El Dorado 17 Tahoe Region 523   -119.977187 38.939926
74 2020-10-27 Fresno 19 Auberry 35   -119.401944 37.066111
75 2020-10-27 Fresno 19 Biola 68   -120.01717 36.802306
76 2020-10-27 Fresno 19 Cantua Creek 38   -120.316389 36.501389
77 2020-10-27 Fresno 19 Caruthers 281   -119.834562 36.542564
78 2020-10-27 Fresno 19 Clovis 1852   -119.703056 36.825278
79 2020-10-27 Fresno 19 Coalinga 512   -120.360278 36.139722
80 2020-10-27 Fresno 19 Del Rey 125   -119.593694 36.659187
81 2020-10-27 Fresno 19 Dunlap 6   -119.120898 36.737991
82 2020-10-27 Fresno 19 Firebaugh 371   -120.456111 36.858889
83 2020-10-27 Fresno 19 Five Points 15   -120.102441 36.428874
84 2020-10-27 Fresno 19 Fowler 268   -119.683333 36.633333
85 2020-10-27 Fresno 19 Fresno 17408   -119.766667 36.75
86 2020-10-27 Fresno 19 Friant 23   -119.711944 36.987778
87 2020-10-27 Fresno 19 Huron 426   -120.103056 36.202778
88 2020-10-27 Fresno 19 Kerman 925   -120.06 36.723611
89 2020-10-27 Fresno 19 Kingsburg 459   -119.553889 36.513889
90 2020-10-27 Fresno 19 Laton 135   -119.686686 36.433282
91 2020-10-27 Fresno 19 Mendota 998   -120.381667 36.753611
92 2020-10-27 Fresno 19 Orange Cove 691   -119.313611 36.624444
93 2020-10-27 Fresno 19 Other 238      
94 2020-10-27 Fresno 19 Parlier 1131   -119.526944 36.611667
95 2020-10-27 Fresno 19 Pinedale 18   -119.79 36.842778
96 2020-10-27 Fresno 19 Prather 12   -119.513889 37.0375
97 2020-10-27 Fresno 19 Raisin City 34   -119.904167 36.6025
98 2020-10-27 Fresno 19 Reedley 1452   -119.450278 36.596389
99 2020-10-27 Fresno 19 Riverdale 268   -119.859444 36.431111
100 2020-10-27 Fresno 19 San Joaquin 206   -120.189167 36.606667
101 2020-10-27 Fresno 19 Sanger 1441   -119.555833 36.708056
Powered by Datasette · Query took 33.142ms · About: simonw/covid-19-datasette