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

239,504 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-04 Alameda 1 94501: Alameda 597   -122.274583 37.774606 62826
2 2020-12-04 Alameda 1 94502: Alameda 89   -122.241149 37.736988 14117
3 2020-12-04 Alameda 1 94536: Fremont 887   -121.987951 37.570977 72976
4 2020-12-04 Alameda 1 94538: Fremont 907   -121.977924 37.499148 63911
5 2020-12-04 Alameda 1 94539: Fremont 322   -121.912764 37.526588 52960
6 2020-12-04 Alameda 1 94541: Hayward 2182   -122.084564 37.674639 65132
7 2020-12-04 Alameda 1 94542: Hayward 238   -122.028059 37.65567 13973
8 2020-12-04 Alameda 1 94544: Hayward 2737   -122.05668 37.633236 77121
9 2020-12-04 Alameda 1 94545: Hayward 759   -122.118372 37.632165 31657
10 2020-12-04 Alameda 1 94546: Castro Valley 649   -122.096829 37.753258 45536
11 2020-12-04 Alameda 1 94550: Livermore 730   -121.62493 37.51205 50138
12 2020-12-04 Alameda 1 94551: Livermore 731   -121.76451 37.748866 38986
13 2020-12-04 Alameda 1 94552: Castro Valley 143   -122.008969 37.706498 15204
14 2020-12-04 Alameda 1 94555: Fremont 285   -122.081325 37.547587 36037
15 2020-12-04 Alameda 1 94560: Newark 860   -122.037397 37.518474 44245
16 2020-12-04 Alameda 1 94566: Pleasanton 471   -121.855191 37.651123 45046
17 2020-12-04 Alameda 1 94568: Dublin 736   -121.915511 37.71354 58399
18 2020-12-04 Alameda 1 94577: San Leandro 1010   -122.164576 37.716583 48666
19 2020-12-04 Alameda 1 94578: San Leandro 1021   -122.125289 37.706453 40150
20 2020-12-04 Alameda 1 94579: San Leandro 302   -122.157702 37.68652 20237
21 2020-12-04 Alameda 1 94580: San Lorenzo 646   -122.135476 37.67589 28970
22 2020-12-04 Alameda 1 94586: Sunol 13   -121.869826 37.569565 797
23 2020-12-04 Alameda 1 94587: Union City 1278   -122.045491 37.599605 72446
24 2020-12-04 Alameda 1 94588: Pleasanton 325   -121.88085 37.718878 31895
25 2020-12-04 Alameda 1 94601: Oakland 2688   -122.217961 37.776931 53261
26 2020-12-04 Alameda 1 94602: Oakland 485   -122.207066 37.804071 29770
27 2020-12-04 Alameda 1 94603: Oakland 1810   -122.176302 37.738989 33241
28 2020-12-04 Alameda 1 94605: Oakland 1035   -122.148748 37.760229 42375
29 2020-12-04 Alameda 1 94606: Oakland 886   -122.244658 37.792494 37076
30 2020-12-04 Alameda 1 94607: Oakland 495   -122.298298 37.808141 26646
31 2020-12-04 Alameda 1 94608: Emeryville 433   -122.284671 37.835737 31000
32 2020-12-04 Alameda 1 94609: Oakland 334   -122.264066 37.834706 22293
33 2020-12-04 Alameda 1 94610: Oakland 268   -122.240634 37.812036 30862
34 2020-12-04 Alameda 1 94611: Oakland 319   -122.216308 37.831401 37826
35 2020-12-04 Alameda 1 94612: Oakland 191   -122.267177 37.808639 17279
36 2020-12-04 Alameda 1 94618: Oakland 75   -122.238063 37.844508 15545
37 2020-12-04 Alameda 1 94619: Oakland 503   -122.173998 37.7918 24080
38 2020-12-04 Alameda 1 94621: Oakland 1799   -122.207204 37.736444 32915
39 2020-12-04 Alameda 1 94702: Berkeley 162   -122.28609 37.866037 16520
40 2020-12-04 Alameda 1 94703: Berkeley 231   -122.275565 37.864148 19805
41 2020-12-04 Alameda 1 94704: Berkeley 264   -122.253359 37.866491 29129
42 2020-12-04 Alameda 1 94705: Berkeley 94   -122.240914 37.859326 13152
43 2020-12-04 Alameda 1 94706: Albany 102   -122.295165 37.889943 19921
44 2020-12-04 Alameda 1 94707: Berkeley 52   -122.279237 37.898243 12862
45 2020-12-04 Alameda 1 94708: Berkeley 37   -122.259682 37.900305 11725
46 2020-12-04 Alameda 1 94709: Berkeley 53   -122.266717 37.879134 11796
47 2020-12-04 Alameda 1 94710: Berkeley 287   -122.303487 37.870693 8059
48 2020-12-04 Alameda 1 94720: Berkeley 25   -122.243147 37.87522 1336
49 2020-12-04 Amador 5 Ione & surrounding unincorporated areas 143   -120.932778 38.352778  
50 2020-12-04 Amador 5 Jackson 178   -120.774167 38.348889  
51 2020-12-04 Amador 5 Pine Grove 41   -120.658889 38.413056  
52 2020-12-04 Amador 5 Pioneer 47   -120.571944 38.431944  
53 2020-12-04 Amador 5 Plymouth & surrounding unincorporated areas 38   -120.844722 38.481944  
54 2020-12-04 Amador 5 Sutter Creek & Amador City 85   -120.8025 38.393056  
55 2020-12-04 Amador 5 Volcano 13   -120.562377 38.409966  
56 2020-12-04 Butte 7 Biggs/Gridley 428   -121.705559 39.385866 8908
57 2020-12-04 Butte 7 Chico 2733   -121.837651 39.728494 91998
58 2020-12-04 Butte 7 Durham 44   -121.795876 39.664949 5863
59 2020-12-04 Butte 7 Oroville 1006   -121.556649 39.51384 19040
60 2020-12-04 Butte 7 Other 86       33084
61 2020-12-04 Butte 7 Ridge Communities 120   -121.580872 39.799577 39707
62 2020-12-04 Calaveras 9 District 1 223   -120.829167 38.191667 9394
63 2020-12-04 Calaveras 9 District 2 45   -120.540833 38.228333 8245
64 2020-12-04 Calaveras 9 District 3 67   -120.076111 38.438889 9729
65 2020-12-04 Calaveras 9 District 4 105   -120.641944 37.981111 9605
66 2020-12-04 Calaveras 9 District 5 115   -120.866667 38.1 8605
67 2020-12-04 Contra Costa 13 Alamo 210   -122.032222 37.850278 14750
68 2020-12-04 Contra Costa 13 Antioch 3293   -121.805833 38.005 112520
69 2020-12-04 Contra Costa 13 Bay Point 1162   -121.961667 38.029167 22639
70 2020-12-04 Contra Costa 13 Bethel Island 18   -121.640556 38.015 2137
71 2020-12-04 Contra Costa 13 Brentwood 1135   -121.695833 37.931944 65118
72 2020-12-04 Contra Costa 13 Byron 36   -121.638056 37.867222 1325
73 2020-12-04 Contra Costa 13 Clayton 122   -121.935833 37.941111 11337
74 2020-12-04 Contra Costa 13 Concord 3212   -122.031111 37.978056 130143
75 2020-12-04 Contra Costa 13 Crockett 34   -122.213056 38.0525 3044
76 2020-12-04 Contra Costa 13 Danville 634   -122.0 37.821667 43876
77 2020-12-04 Contra Costa 13 Discovery Bay 246   -121.600278 37.908611 13352
78 2020-12-04 Contra Costa 13 El Cerrito 220   -122.311667 37.915833 24953
79 2020-12-04 Contra Costa 13 El Sobrante 445   -122.295278 37.977222 12669
80 2020-12-04 Contra Costa 13 Hercules 416   -122.288611 38.017222 25530
81 2020-12-04 Contra Costa 13 Kensington 19   -122.280278 37.910556  
82 2020-12-04 Contra Costa 13 Lafayette 265   -122.118056 37.885833 25604
83 2020-12-04 Contra Costa 13 Martinez 604   -122.134167 38.019444 37106
84 2020-12-04 Contra Costa 13 Moraga 118   -122.129722 37.835 16946
85 2020-12-04 Contra Costa 13 Oakley 874   -121.7125 37.9975 42461
86 2020-12-04 Contra Costa 13 Orinda 203   -122.179722 37.882778 19009
87 2020-12-04 Contra Costa 13 Other 246        
88 2020-12-04 Contra Costa 13 Pacheco 85   -122.075278 37.983611 3685
89 2020-12-04 Contra Costa 13 Pinole 381   -122.291111 38.004444 19505
90 2020-12-04 Contra Costa 13 Pittsburg 2683   -121.884722 38.028056 74321
91 2020-12-04 Contra Costa 13 Pleasant Hill 448   -122.0525 37.948056 34267
92 2020-12-04 Contra Costa 13 Richmond 4589   -122.347778 37.935833 111217
93 2020-12-04 Contra Costa 13 Rodeo 194   -122.266944 38.033056 8679
94 2020-12-04 Contra Costa 13 San Pablo 2163   -122.345556 37.962222 31413
95 2020-12-04 Contra Costa 13 San Ramon 731   -121.978056 37.78 83118
96 2020-12-04 Contra Costa 13 Walnut Creek 982   -122.065 37.906389 70860
97 2020-12-04 Del Norte 15 Crescent City 210   -124.2 41.75 8723
98 2020-12-04 Del Norte 15 Fort Dick-Smith River 82   -124.148889 41.867778 1462
99 2020-12-04 Del Norte 15 Hiouchi-Gasquet-Big Flat 18   -124.071944 41.7925 1053
100 2020-12-04 Del Norte 15 Klamath 3   -124.038333 41.526389 617

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
);