latimes_place_totals

⚠️ 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: The Los Angeles Times · About: Data dictionary for latimes_place_totals

169,208 rows sorted by date descending

✎ View and edit SQL

This data as json, yaml, copyable, CSV (advanced)

place

fips

county

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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [latimes_place_totals] (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [place] TEXT,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [x] TEXT,
   [y] TEXT
);
Powered by Datasette · Query took 2300.919ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals