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

573,746 rows sorted by date descending

View and edit SQL

fips

county

Link rowid id name date ▲ county fips confirmed_cases note population
1 94501 94501: Alameda 2021-06-14 Alameda 1 2206   62826
2 94502 94502: Alameda 2021-06-14 Alameda 1 251   14117
3 94505 94505: Discovery Bay 2021-06-14 Alameda 1 1   16382
4 94514 94514: Byron 2021-06-14 Alameda 1 1   1461
5 94536 94536: Fremont 2021-06-14 Alameda 1 2895   72976
6 94538 94538: Fremont 2021-06-14 Alameda 1 3048   63911
7 94539 94539: Fremont 2021-06-14 Alameda 1 1181   52960
8 94541 94541: Hayward 2021-06-14 Alameda 1 6220   65132
9 94542 94542: Hayward 2021-06-14 Alameda 1 721   13973
10 94544 94544: Hayward 2021-06-14 Alameda 1 7637   77121
11 94545 94545: Hayward 2021-06-14 Alameda 1 2430   31657
12 94546 94546: Castro Valley 2021-06-14 Alameda 1 1891   45536
13 94550 94550: Livermore 2021-06-14 Alameda 1 2201   50138
14 94551 94551: Livermore 2021-06-14 Alameda 1 2226   38986
15 94552 94552: Castro Valley 2021-06-14 Alameda 1 414   15204
16 94555 94555: Fremont 2021-06-14 Alameda 1 1006   36037
17 94560 94560: Newark 2021-06-14 Alameda 1 2817   44245
18 94566 94566: Pleasanton 2021-06-14 Alameda 1 1435   45046
19 94568 94568: Dublin 2021-06-14 Alameda 1 2521   58399
20 94577 94577: San Leandro 2021-06-14 Alameda 1 3041   48666
21 94578 94578: San Leandro 2021-06-14 Alameda 1 3106   40150
22 94579 94579: San Leandro 2021-06-14 Alameda 1 1154   20237
23 94580 94580: San Lorenzo 2021-06-14 Alameda 1 2073   28970
24 94586 94586: Sunol 2021-06-14 Alameda 1 32   797
25 94587 94587: Union City 2021-06-14 Alameda 1 4058   72446
26 94588 94588: Pleasanton 2021-06-14 Alameda 1 963   31895
27 94601 94601: Oakland 2021-06-14 Alameda 1 5929   53261
28 94602 94602: Oakland 2021-06-14 Alameda 1 1277   29770
29 94603 94603: Oakland 2021-06-14 Alameda 1 4504   33241
30 94605 94605: Oakland 2021-06-14 Alameda 1 2826   42375
31 94606 94606: Oakland 2021-06-14 Alameda 1 2275   37076
32 94607 94607: Oakland 2021-06-14 Alameda 1 1429   26646
33 94608 94608: Emeryville 2021-06-14 Alameda 1 1178   31000
34 94609 94609: Oakland 2021-06-14 Alameda 1 1044   22293
35 94610 94610: Oakland 2021-06-14 Alameda 1 770   30862
36 94611 94611: Oakland 2021-06-14 Alameda 1 915   37826
37 94612 94612: Oakland 2021-06-14 Alameda 1 675   17279
38 94613 94613: Oakland 2021-06-14 Alameda 1 2   212
39 94618 94618: Oakland 2021-06-14 Alameda 1 270   15545
40 94619 94619: Oakland 2021-06-14 Alameda 1 1183   24080
41 94621 94621: Oakland 2021-06-14 Alameda 1 4231   32915
42 94702 94702: Berkeley 2021-06-14 Alameda 1 559   16520
43 94703 94703: Berkeley 2021-06-14 Alameda 1 591   19805
44 94704 94704: Berkeley 2021-06-14 Alameda 1 963   29129
45 94705 94705: Berkeley 2021-06-14 Alameda 1 321   13152
46 94706 94706: Albany 2021-06-14 Alameda 1 366   19921
47 94707 94707: Berkeley 2021-06-14 Alameda 1 144   12862
48 94708 94708: Berkeley 2021-06-14 Alameda 1 98   11725
49 94709 94709: Berkeley 2021-06-14 Alameda 1 162   11796
50 94710 94710: Berkeley 2021-06-14 Alameda 1 571   8059
51 94720 94720: Berkeley 2021-06-14 Alameda 1 197   1336
52 95377 95377: Tracy 2021-06-14 Alameda 1 1   32091
53 95391 95391: Mountain House 2021-06-14 Alameda 1 1   20131
54 Ione & surrounding unincorporated areas Ione & surrounding unincorporated areas 2021-06-14 Amador 5 518   7439
55 Jackson Jackson 2021-06-14 Amador 5 524   4694
56 Pine Grove Pine Grove 2021-06-14 Amador 5 168   1730
57 Pioneer Pioneer 2021-06-14 Amador 5 175   1443
58 Plymouth & surrounding unincorporated areas Plymouth & surrounding unincorporated areas 2021-06-14 Amador 5 167   894
59 Sutter Creek & Amador City Sutter Creek & Amador City 2021-06-14 Amador 5 236   2705
60 Volcano Volcano 2021-06-14 Amador 5 28   44
61 Biggs/Gridley Biggs/Gridley 2021-06-14 Butte 7 1449   8908
62 Chico Chico 2021-06-14 Butte 7 6615   91998
63 Durham Durham 2021-06-14 Butte 7 152   5863
64 Oroville Oroville 2021-06-14 Butte 7 3182   19040
65 Other Other 2021-06-14 Butte 7 324   33084
66 Ridge Communities Ridge Communities 2021-06-14 Butte 7 430   39707
67 95221, 95222 95221, 95222 2021-06-14 Calaveras 9 304   5029
68 95223 95223 2021-06-14 Calaveras 9 89   2666
69 95224, 95247, 95251, 95229 95224, 95247, 95251, 95229 2021-06-14 Calaveras 9 237   4816
70 95225 95225 2021-06-14 Calaveras 9 29   378
71 95226, 95252 95226, 95252 2021-06-14 Calaveras 9 804   16262
72 95228 95228 2021-06-14 Calaveras 9 238   4541
73 95232, 95245 95232, 95245 2021-06-14 Calaveras 9 59   161
74 95246, 95250 95246, 95250 2021-06-14 Calaveras 9 43   1159
75 95249 95249 2021-06-14 Calaveras 9 248   5444
76 95254 95254 2021-06-14 Calaveras 9 34   1035
77 95255, 95257, 95248 95255, 95257, 95248 2021-06-14 Calaveras 9 64   1802
78 Other Other 2021-06-14 Calaveras 9 48    
79 Alamo Alamo 2021-06-14 Contra Costa 13 496   14750
80 Antioch Antioch 2021-06-14 Contra Costa 13 9860   112520
81 Bay Point Bay Point 2021-06-14 Contra Costa 13 2818   22639
82 Bethel Island Bethel Island 2021-06-14 Contra Costa 13 75   2137
83 Brentwood Brentwood 2021-06-14 Contra Costa 13 3915   65118
84 Byron Byron 2021-06-14 Contra Costa 13 105   1325
85 Clayton Clayton 2021-06-14 Contra Costa 13 434   11337
86 Concord Concord 2021-06-14 Contra Costa 13 8162   130143
87 Crockett Crockett 2021-06-14 Contra Costa 13 132   3044
88 Danville Danville 2021-06-14 Contra Costa 13 1669   43876
89 Diablo Diablo 2021-06-14 Contra Costa 13 37   818
90 Discovery Bay Discovery Bay 2021-06-14 Contra Costa 13 888   13352
91 El Cerrito El Cerrito 2021-06-14 Contra Costa 13 718   24953
92 Hercules Hercules 2021-06-14 Contra Costa 13 1286   25530
93 Kensington Kensington 2021-06-14 Contra Costa 13 47   5077
94 Knightsen Knightsen 2021-06-14 Contra Costa 13 26   1500
95 Lafayette Lafayette 2021-06-14 Contra Costa 13 635   25604
96 Martinez Martinez 2021-06-14 Contra Costa 13 1992   37106
97 Moraga Moraga 2021-06-14 Contra Costa 13 343   16946
98 Oakley Oakley 2021-06-14 Contra Costa 13 3310   42461
99 Orinda Orinda 2021-06-14 Contra Costa 13 414   19009
100 Pacheco Pacheco 2021-06-14 Contra Costa 13 250   3685

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [latimes_place_totals] (
   [id] TEXT,
   [name] TEXT,
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [population] TEXT
);