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

310,823 rows sorted by date descending

View and edit SQL

fips

county

Link rowid date ▲ county fips place confirmed_cases note x y population
1 2021-01-26 Alameda 1 94501: Alameda 1728   -122.274583 37.774606 62826
2 2021-01-26 Alameda 1 94502: Alameda 198   -122.241149 37.736988 14117
3 2021-01-26 Alameda 1 94505: Discovery Bay 1   -121.593154 37.882787  
4 2021-01-26 Alameda 1 94536: Fremont 2257   -121.987951 37.570977 72976
5 2021-01-26 Alameda 1 94538: Fremont 2312   -121.977924 37.499148 63911
6 2021-01-26 Alameda 1 94539: Fremont 807   -121.912764 37.526588 52960
7 2021-01-26 Alameda 1 94541: Hayward 5019   -122.084564 37.674639 65132
8 2021-01-26 Alameda 1 94542: Hayward 566   -122.028059 37.65567 13973
9 2021-01-26 Alameda 1 94544: Hayward 6222   -122.05668 37.633236 77121
10 2021-01-26 Alameda 1 94545: Hayward 1928   -122.118372 37.632165 31657
11 2021-01-26 Alameda 1 94546: Castro Valley 1472   -122.096829 37.753258 45536
12 2021-01-26 Alameda 1 94550: Livermore 1833   -121.62493 37.51205 50138
13 2021-01-26 Alameda 1 94551: Livermore 1855   -121.76451 37.748866 38986
14 2021-01-26 Alameda 1 94552: Castro Valley 311   -122.008969 37.706498 15204
15 2021-01-26 Alameda 1 94555: Fremont 796   -122.081325 37.547587 36037
16 2021-01-26 Alameda 1 94560: Newark 2305   -122.037397 37.518474 44245
17 2021-01-26 Alameda 1 94566: Pleasanton 1167   -121.855191 37.651123 45046
18 2021-01-26 Alameda 1 94568: Dublin 1971   -121.915511 37.71354 58399
19 2021-01-26 Alameda 1 94577: San Leandro 2291   -122.164576 37.716583 48666
20 2021-01-26 Alameda 1 94578: San Leandro 2473   -122.125289 37.706453 40150
21 2021-01-26 Alameda 1 94579: San Leandro 927   -122.157702 37.68652 20237
22 2021-01-26 Alameda 1 94580: San Lorenzo 1713   -122.135476 37.67589 28970
23 2021-01-26 Alameda 1 94586: Sunol 30   -121.869826 37.569565 797
24 2021-01-26 Alameda 1 94587: Union City 3263   -122.045491 37.599605 72446
25 2021-01-26 Alameda 1 94588: Pleasanton 715   -121.88085 37.718878 31895
26 2021-01-26 Alameda 1 94601: Oakland 4843   -122.217961 37.776931 53261
27 2021-01-26 Alameda 1 94602: Oakland 1006   -122.207066 37.804071 29770
28 2021-01-26 Alameda 1 94603: Oakland 3656   -122.176302 37.738989 33241
29 2021-01-26 Alameda 1 94605: Oakland 2150   -122.148748 37.760229 42375
30 2021-01-26 Alameda 1 94606: Oakland 1754   -122.244658 37.792494 37076
31 2021-01-26 Alameda 1 94607: Oakland 1027   -122.298298 37.808141 26646
32 2021-01-26 Alameda 1 94608: Emeryville 879   -122.284671 37.835737 31000
33 2021-01-26 Alameda 1 94609: Oakland 805   -122.264066 37.834706 22293
34 2021-01-26 Alameda 1 94610: Oakland 582   -122.240634 37.812036 30862
35 2021-01-26 Alameda 1 94611: Oakland 691   -122.216308 37.831401 37826
36 2021-01-26 Alameda 1 94612: Oakland 422   -122.267177 37.808639 17279
37 2021-01-26 Alameda 1 94613: Oakland 2   -122.182997 37.780731 212
38 2021-01-26 Alameda 1 94618: Oakland 195   -122.238063 37.844508 15545
39 2021-01-26 Alameda 1 94619: Oakland 924   -122.173998 37.7918 24080
40 2021-01-26 Alameda 1 94621: Oakland 3447   -122.207204 37.736444 32915
41 2021-01-26 Alameda 1 94702: Berkeley 432   -122.28609 37.866037 16520
42 2021-01-26 Alameda 1 94703: Berkeley 451   -122.275565 37.864148 19805
43 2021-01-26 Alameda 1 94704: Berkeley 528   -122.253359 37.866491 29129
44 2021-01-26 Alameda 1 94705: Berkeley 253   -122.240914 37.859326 13152
45 2021-01-26 Alameda 1 94706: Albany 273   -122.295165 37.889943 19921
46 2021-01-26 Alameda 1 94707: Berkeley 119   -122.279237 37.898243 12862
47 2021-01-26 Alameda 1 94708: Berkeley 74   -122.259682 37.900305 11725
48 2021-01-26 Alameda 1 94709: Berkeley 116   -122.266717 37.879134 11796
49 2021-01-26 Alameda 1 94710: Berkeley 481   -122.303487 37.870693 8059
50 2021-01-26 Alameda 1 94720: Berkeley 58   -122.243147 37.87522 1336
51 2021-01-26 Alameda 1 95377: Tracy 1   -121.4537 37.7212  
52 2021-01-26 Alameda 1 95391: Mountain House 1   -121.59902 37.75941  
53 2021-01-26 Amador 5 Ione & surrounding unincorporated areas 408   -120.932778 38.352778 7439
54 2021-01-26 Amador 5 Jackson 441   -120.774167 38.348889 4694
55 2021-01-26 Amador 5 Pine Grove 120   -120.658889 38.413056 1730
56 2021-01-26 Amador 5 Pioneer 124   -120.571944 38.431944 1443
57 2021-01-26 Amador 5 Plymouth & surrounding unincorporated areas 111   -120.844722 38.481944 894
58 2021-01-26 Amador 5 Sutter Creek & Amador City 190   -120.8025 38.393056 2705
59 2021-01-26 Amador 5 Volcano 23   -120.562377 38.409966 44
60 2021-01-26 Butte 7 Biggs/Gridley 1196   -121.705559 39.385866 8908
61 2021-01-26 Butte 7 Chico 5220   -121.837651 39.728494 91998
62 2021-01-26 Butte 7 Durham 115   -121.795876 39.664949 5863
63 2021-01-26 Butte 7 Oroville 2441   -121.556649 39.51384 19040
64 2021-01-26 Butte 7 Other 374       33084
65 2021-01-26 Butte 7 Ridge Communities 310   -121.580872 39.799577 39707
66 2021-01-26 Contra Costa 13 Alamo 387   -122.032222 37.850278 14750
67 2021-01-26 Contra Costa 13 Antioch 7469   -121.805833 38.005 112520
68 2021-01-26 Contra Costa 13 Bay Point 2270   -121.961667 38.029167 22639
69 2021-01-26 Contra Costa 13 Bethel Island 60   -121.640556 38.015 2137
70 2021-01-26 Contra Costa 13 Brentwood 2881   -121.695833 37.931944 65118
71 2021-01-26 Contra Costa 13 Byron 90   -121.638056 37.867222 1325
72 2021-01-26 Contra Costa 13 Clayton 331   -121.935833 37.941111 11337
73 2021-01-26 Contra Costa 13 Concord 6651   -122.031111 37.978056 130143
74 2021-01-26 Contra Costa 13 Crockett 89   -122.213056 38.0525 3044
75 2021-01-26 Contra Costa 13 Danville 1326   -122.0 37.821667 43876
76 2021-01-26 Contra Costa 13 Diablo 31   -121.958056 37.835 818
77 2021-01-26 Contra Costa 13 Discovery Bay 675   -121.600278 37.908611 13352
78 2021-01-26 Contra Costa 13 El Cerrito 528   -122.311667 37.915833 24953
79 2021-01-26 Contra Costa 13 El Sobrante 956   -122.295278 37.977222 12669
80 2021-01-26 Contra Costa 13 Hercules 1020   -122.288611 38.017222 25530
81 2021-01-26 Contra Costa 13 Kensington 36   -122.280278 37.910556  
82 2021-01-26 Contra Costa 13 Lafayette 501   -122.118056 37.885833 25604
83 2021-01-26 Contra Costa 13 Martinez 1573   -122.134167 38.019444 37106
84 2021-01-26 Contra Costa 13 Moraga 254   -122.129722 37.835 16946
85 2021-01-26 Contra Costa 13 Oakley 2412   -121.7125 37.9975 42461
86 2021-01-26 Contra Costa 13 Orinda 343   -122.179722 37.882778 19009
87 2021-01-26 Contra Costa 13 Other 484        
88 2021-01-26 Contra Costa 13 Pacheco 177   -122.075278 37.983611 3685
89 2021-01-26 Contra Costa 13 Pinole 880   -122.291111 38.004444 19505
90 2021-01-26 Contra Costa 13 Pittsburg 5484   -121.884722 38.028056 74321
91 2021-01-26 Contra Costa 13 Pleasant Hill 955   -122.0525 37.948056 34267
92 2021-01-26 Contra Costa 13 Richmond 8579   -122.347778 37.935833 111217
93 2021-01-26 Contra Costa 13 Rodeo 446   -122.266944 38.033056 8679
94 2021-01-26 Contra Costa 13 San Pablo 4389   -122.345556 37.962222 31413
95 2021-01-26 Contra Costa 13 San Ramon 1676   -121.978056 37.78 83118
96 2021-01-26 Contra Costa 13 Walnut Creek 2292   -122.065 37.906389 70860
97 2021-01-26 El Dorado 17 Camino, Pollock Pines, Kyburz 447   -120.586594 38.761292 13548
98 2021-01-26 El Dorado 17 El Dorado Hills 1728   -121.082222 38.685833 42439
99 2021-01-26 El Dorado 17 El Dorado, Diamond Springs 386   -120.815 38.694722 9396
100 2021-01-26 El Dorado 17 Greater Placerville Area 1481   -120.798611 38.729722 36508

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