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

235,963 rows sorted by date descending

View and edit SQL

fips

county

Link rowid date ▲ county fips place confirmed_cases note x y population
1 2020-12-01 Alameda 1 94501: Alameda 568   -122.274583 37.774606 62826
2 2020-12-01 Alameda 1 94502: Alameda 84   -122.241149 37.736988 14117
3 2020-12-01 Alameda 1 94536: Fremont 839   -121.987951 37.570977 72976
4 2020-12-01 Alameda 1 94538: Fremont 841   -121.977924 37.499148 63911
5 2020-12-01 Alameda 1 94539: Fremont 286   -121.912764 37.526588 52960
6 2020-12-01 Alameda 1 94541: Hayward 2062   -122.084564 37.674639 65132
7 2020-12-01 Alameda 1 94542: Hayward 219   -122.028059 37.65567 13973
8 2020-12-01 Alameda 1 94544: Hayward 2590   -122.05668 37.633236 77121
9 2020-12-01 Alameda 1 94545: Hayward 724   -122.118372 37.632165 31657
10 2020-12-01 Alameda 1 94546: Castro Valley 600   -122.096829 37.753258 45536
11 2020-12-01 Alameda 1 94550: Livermore 671   -121.62493 37.51205 50138
12 2020-12-01 Alameda 1 94551: Livermore 705   -121.76451 37.748866 38986
13 2020-12-01 Alameda 1 94552: Castro Valley 121   -122.008969 37.706498 15204
14 2020-12-01 Alameda 1 94555: Fremont 259   -122.081325 37.547587 36037
15 2020-12-01 Alameda 1 94560: Newark 814   -122.037397 37.518474 44245
16 2020-12-01 Alameda 1 94566: Pleasanton 427   -121.855191 37.651123 45046
17 2020-12-01 Alameda 1 94568: Dublin 686   -121.915511 37.71354 58399
18 2020-12-01 Alameda 1 94577: San Leandro 970   -122.164576 37.716583 48666
19 2020-12-01 Alameda 1 94578: San Leandro 968   -122.125289 37.706453 40150
20 2020-12-01 Alameda 1 94579: San Leandro 290   -122.157702 37.68652 20237
21 2020-12-01 Alameda 1 94580: San Lorenzo 614   -122.135476 37.67589 28970
22 2020-12-01 Alameda 1 94586: Sunol 13   -121.869826 37.569565 797
23 2020-12-01 Alameda 1 94587: Union City 1206   -122.045491 37.599605 72446
24 2020-12-01 Alameda 1 94588: Pleasanton 305   -121.88085 37.718878 31895
25 2020-12-01 Alameda 1 94601: Oakland 2605   -122.217961 37.776931 53261
26 2020-12-01 Alameda 1 94602: Oakland 469   -122.207066 37.804071 29770
27 2020-12-01 Alameda 1 94603: Oakland 1751   -122.176302 37.738989 33241
28 2020-12-01 Alameda 1 94605: Oakland 998   -122.148748 37.760229 42375
29 2020-12-01 Alameda 1 94606: Oakland 849   -122.244658 37.792494 37076
30 2020-12-01 Alameda 1 94607: Oakland 473   -122.298298 37.808141 26646
31 2020-12-01 Alameda 1 94608: Emeryville 418   -122.284671 37.835737 31000
32 2020-12-01 Alameda 1 94609: Oakland 323   -122.264066 37.834706 22293
33 2020-12-01 Alameda 1 94610: Oakland 252   -122.240634 37.812036 30862
34 2020-12-01 Alameda 1 94611: Oakland 307   -122.216308 37.831401 37826
35 2020-12-01 Alameda 1 94612: Oakland 179   -122.267177 37.808639 17279
36 2020-12-01 Alameda 1 94618: Oakland 68   -122.238063 37.844508 15545
37 2020-12-01 Alameda 1 94619: Oakland 488   -122.173998 37.7918 24080
38 2020-12-01 Alameda 1 94621: Oakland 1764   -122.207204 37.736444 32915
39 2020-12-01 Alameda 1 94702: Berkeley 156   -122.28609 37.866037 16520
40 2020-12-01 Alameda 1 94703: Berkeley 220   -122.275565 37.864148 19805
41 2020-12-01 Alameda 1 94704: Berkeley 262   -122.253359 37.866491 29129
42 2020-12-01 Alameda 1 94705: Berkeley 91   -122.240914 37.859326 13152
43 2020-12-01 Alameda 1 94706: Albany 90   -122.295165 37.889943 19921
44 2020-12-01 Alameda 1 94707: Berkeley 40   -122.279237 37.898243 12862
45 2020-12-01 Alameda 1 94708: Berkeley 35   -122.259682 37.900305 11725
46 2020-12-01 Alameda 1 94709: Berkeley 51   -122.266717 37.879134 11796
47 2020-12-01 Alameda 1 94710: Berkeley 269   -122.303487 37.870693 8059
48 2020-12-01 Alameda 1 94720: Berkeley 25   -122.243147 37.87522 1336
49 2020-12-01 Amador 5 Ione & surrounding unincorporated areas 126   -120.932778 38.352778  
50 2020-12-01 Amador 5 Jackson 164   -120.774167 38.348889  
51 2020-12-01 Amador 5 Pine Grove 39   -120.658889 38.413056  
52 2020-12-01 Amador 5 Pioneer 44   -120.571944 38.431944  
53 2020-12-01 Amador 5 Plymouth & surrounding unincorporated areas 36   -120.844722 38.481944  
54 2020-12-01 Amador 5 Sutter Creek & Amador City 74   -120.8025 38.393056  
55 2020-12-01 Amador 5 Volcano 11   -120.562377 38.409966  
56 2020-12-01 Butte 7 Biggs/Gridley 396   -121.705559 39.385866 8908
57 2020-12-01 Butte 7 Chico 2651   -121.837651 39.728494 91998
58 2020-12-01 Butte 7 Durham 42   -121.795876 39.664949 5863
59 2020-12-01 Butte 7 Oroville 925   -121.556649 39.51384 19040
60 2020-12-01 Butte 7 Other 68       33084
61 2020-12-01 Butte 7 Ridge Communities 113   -121.580872 39.799577 39707
62 2020-12-01 Calaveras 9 District 1 212   -120.829167 38.191667 9394
63 2020-12-01 Calaveras 9 District 2 40   -120.540833 38.228333 8245
64 2020-12-01 Calaveras 9 District 3 57   -120.076111 38.438889 9729
65 2020-12-01 Calaveras 9 District 4 82   -120.641944 37.981111 9605
66 2020-12-01 Calaveras 9 District 5 107   -120.866667 38.1 8605
67 2020-12-01 Contra Costa 13 Alamo 201   -122.032222 37.850278 14750
68 2020-12-01 Contra Costa 13 Antioch 3227   -121.805833 38.005 112520
69 2020-12-01 Contra Costa 13 Bay Point 1143   -121.961667 38.029167 22639
70 2020-12-01 Contra Costa 13 Bethel Island 17   -121.640556 38.015 2137
71 2020-12-01 Contra Costa 13 Brentwood 1087   -121.695833 37.931944 65118
72 2020-12-01 Contra Costa 13 Byron 35   -121.638056 37.867222 1325
73 2020-12-01 Contra Costa 13 Clayton 118   -121.935833 37.941111 11337
74 2020-12-01 Contra Costa 13 Concord 3131   -122.031111 37.978056 130143
75 2020-12-01 Contra Costa 13 Crockett 33   -122.213056 38.0525 3044
76 2020-12-01 Contra Costa 13 Danville 616   -122.0 37.821667 43876
77 2020-12-01 Contra Costa 13 Discovery Bay 232   -121.600278 37.908611 13352
78 2020-12-01 Contra Costa 13 El Cerrito 207   -122.311667 37.915833 24953
79 2020-12-01 Contra Costa 13 El Sobrante 424   -122.295278 37.977222 12669
80 2020-12-01 Contra Costa 13 Hercules 392   -122.288611 38.017222 25530
81 2020-12-01 Contra Costa 13 Kensington 18   -122.280278 37.910556  
82 2020-12-01 Contra Costa 13 Lafayette 256   -122.118056 37.885833 25604
83 2020-12-01 Contra Costa 13 Martinez 567   -122.134167 38.019444 37106
84 2020-12-01 Contra Costa 13 Moraga 115   -122.129722 37.835 16946
85 2020-12-01 Contra Costa 13 Oakley 823   -121.7125 37.9975 42461
86 2020-12-01 Contra Costa 13 Orinda 199   -122.179722 37.882778 19009
87 2020-12-01 Contra Costa 13 Other 234        
88 2020-12-01 Contra Costa 13 Pacheco 83   -122.075278 37.983611 3685
89 2020-12-01 Contra Costa 13 Pinole 363   -122.291111 38.004444 19505
90 2020-12-01 Contra Costa 13 Pittsburg 2607   -121.884722 38.028056 74321
91 2020-12-01 Contra Costa 13 Pleasant Hill 439   -122.0525 37.948056 34267
92 2020-12-01 Contra Costa 13 Richmond 4445   -122.347778 37.935833 111217
93 2020-12-01 Contra Costa 13 Rodeo 186   -122.266944 38.033056 8679
94 2020-12-01 Contra Costa 13 San Pablo 2078   -122.345556 37.962222 31413
95 2020-12-01 Contra Costa 13 San Ramon 688   -121.978056 37.78 83118
96 2020-12-01 Contra Costa 13 Walnut Creek 950   -122.065 37.906389 70860
97 2020-12-01 El Dorado 17 Camino, Pollock Pines, Kyburz 107   -120.586594 38.761292  
98 2020-12-01 El Dorado 17 El Dorado Hills 685   -121.082222 38.685833  
99 2020-12-01 El Dorado 17 El Dorado, Diamond Springs 79   -120.815 38.694722  
100 2020-12-01 El Dorado 17 Greater Placerville Area 271   -120.798611 38.729722  

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,
   [population] TEXT
);
Powered by Datasette · Query took 2883.769ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals