latimes_place_totals

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

491,962 rows sorted by date descending

✎ View and edit SQL

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

fips

county

Link rowid id name date ▲ county fips confirmed_cases note population
1 1 94501 94501: Alameda 2021-04-15 Alameda 1 2054   62826
2 2 94502 94502: Alameda 2021-04-15 Alameda 1 235   14117
3 3 94505 94505: Discovery Bay 2021-04-15 Alameda 1 1   16382
4 4 94536 94536: Fremont 2021-04-15 Alameda 1 2716   72976
5 5 94538 94538: Fremont 2021-04-15 Alameda 1 2778   63911
6 6 94539 94539: Fremont 2021-04-15 Alameda 1 1069   52960
7 7 94541 94541: Hayward 2021-04-15 Alameda 1 5917   65132
8 8 94542 94542: Hayward 2021-04-15 Alameda 1 692   13973
9 9 94544 94544: Hayward 2021-04-15 Alameda 1 7269   77121
10 10 94545 94545: Hayward 2021-04-15 Alameda 1 2274   31657
11 11 94546 94546: Castro Valley 2021-04-15 Alameda 1 1775   45536
12 12 94550 94550: Livermore 2021-04-15 Alameda 1 2082   50138
13 13 94551 94551: Livermore 2021-04-15 Alameda 1 2134   38986
14 14 94552 94552: Castro Valley 2021-04-15 Alameda 1 390   15204
15 15 94555 94555: Fremont 2021-04-15 Alameda 1 936   36037
16 16 94560 94560: Newark 2021-04-15 Alameda 1 2662   44245
17 17 94566 94566: Pleasanton 2021-04-15 Alameda 1 1318   45046
18 18 94568 94568: Dublin 2021-04-15 Alameda 1 2299   58399
19 19 94577 94577: San Leandro 2021-04-15 Alameda 1 2846   48666
20 20 94578 94578: San Leandro 2021-04-15 Alameda 1 2913   40150
21 21 94579 94579: San Leandro 2021-04-15 Alameda 1 1087   20237
22 22 94580 94580: San Lorenzo 2021-04-15 Alameda 1 1952   28970
23 23 94586 94586: Sunol 2021-04-15 Alameda 1 33   797
24 24 94587 94587: Union City 2021-04-15 Alameda 1 3851   72446
25 25 94588 94588: Pleasanton 2021-04-15 Alameda 1 884   31895
26 26 94601 94601: Oakland 2021-04-15 Alameda 1 5641   53261
27 27 94602 94602: Oakland 2021-04-15 Alameda 1 1194   29770
28 28 94603 94603: Oakland 2021-04-15 Alameda 1 4232   33241
29 29 94605 94605: Oakland 2021-04-15 Alameda 1 2560   42375
30 30 94606 94606: Oakland 2021-04-15 Alameda 1 2112   37076
31 31 94607 94607: Oakland 2021-04-15 Alameda 1 1284   26646
32 32 94608 94608: Emeryville 2021-04-15 Alameda 1 1081   31000
33 33 94609 94609: Oakland 2021-04-15 Alameda 1 952   22293
34 34 94610 94610: Oakland 2021-04-15 Alameda 1 710   30862
35 35 94611 94611: Oakland 2021-04-15 Alameda 1 860   37826
36 36 94612 94612: Oakland 2021-04-15 Alameda 1 609   17279
37 37 94613 94613: Oakland 2021-04-15 Alameda 1 2   212
38 38 94618 94618: Oakland 2021-04-15 Alameda 1 249   15545
39 39 94619 94619: Oakland 2021-04-15 Alameda 1 1086   24080
40 40 94621 94621: Oakland 2021-04-15 Alameda 1 4015   32915
41 41 94702 94702: Berkeley 2021-04-15 Alameda 1 520   16520
42 42 94703 94703: Berkeley 2021-04-15 Alameda 1 566   19805
43 43 94704 94704: Berkeley 2021-04-15 Alameda 1 917   29129
44 44 94705 94705: Berkeley 2021-04-15 Alameda 1 306   13152
45 45 94706 94706: Albany 2021-04-15 Alameda 1 345   19921
46 46 94707 94707: Berkeley 2021-04-15 Alameda 1 137   12862
47 47 94708 94708: Berkeley 2021-04-15 Alameda 1 90   11725
48 48 94709 94709: Berkeley 2021-04-15 Alameda 1 155   11796
49 49 94710 94710: Berkeley 2021-04-15 Alameda 1 553   8059
50 50 94720 94720: Berkeley 2021-04-15 Alameda 1 194   1336
51 51 95377 95377: Tracy 2021-04-15 Alameda 1 1   32091
52 52 95391 95391: Mountain House 2021-04-15 Alameda 1 1   20131
53 53 Ione & surrounding unincorporated areas Ione & surrounding unincorporated areas 2021-04-15 Amador 5 492   7439
54 54 Jackson Jackson 2021-04-15 Amador 5 509   4694
55 55 Pine Grove Pine Grove 2021-04-15 Amador 5 165   1730
56 56 Pioneer Pioneer 2021-04-15 Amador 5 168   1443
57 57 Plymouth & surrounding unincorporated areas Plymouth & surrounding unincorporated areas 2021-04-15 Amador 5 152   894
58 58 Sutter Creek & Amador City Sutter Creek & Amador City 2021-04-15 Amador 5 227   2705
59 59 Volcano Volcano 2021-04-15 Amador 5 27   44
60 60 Biggs/Gridley Biggs/Gridley 2021-04-15 Butte 7 1404   8908
61 61 Chico Chico 2021-04-15 Butte 7 6170   91998
62 62 Durham Durham 2021-04-15 Butte 7 146   5863
63 63 Oroville Oroville 2021-04-15 Butte 7 2902   19040
64 64 Other Other 2021-04-15 Butte 7 309   33084
65 65 Ridge Communities Ridge Communities 2021-04-15 Butte 7 389   39707
66 66 95221, 95222 95221, 95222 2021-04-15 Calaveras 9 256   5029
67 67 95223 95223 2021-04-15 Calaveras 9 85   2666
68 68 95224, 95247, 95251, 95229 95224, 95247, 95251, 95229 2021-04-15 Calaveras 9 221   4816
69 69 95225 95225 2021-04-15 Calaveras 9 28   378
70 70 95226, 95252 95226, 95252 2021-04-15 Calaveras 9 767   16262
71 71 95228 95228 2021-04-15 Calaveras 9 221   4541
72 72 95232, 95245 95232, 95245 2021-04-15 Calaveras 9 54   161
73 73 95246, 95250 95246, 95250 2021-04-15 Calaveras 9 42   1159
74 74 95249 95249 2021-04-15 Calaveras 9 241   5444
75 75 95254 95254 2021-04-15 Calaveras 9 33   1035
76 76 95255, 95257, 95248 95255, 95257, 95248 2021-04-15 Calaveras 9 52   1802
77 77 Other Other 2021-04-15 Calaveras 9 47    
78 78 Alamo Alamo 2021-04-15 Contra Costa 13 472   14750
79 79 Antioch Antioch 2021-04-15 Contra Costa 13 9247   112520
80 80 Bay Point Bay Point 2021-04-15 Contra Costa 13 2696   22639
81 81 Bethel Island Bethel Island 2021-04-15 Contra Costa 13 66   2137
82 82 Brentwood Brentwood 2021-04-15 Contra Costa 13 3673   65118
83 83 Byron Byron 2021-04-15 Contra Costa 13 100   1325
84 84 Clayton Clayton 2021-04-15 Contra Costa 13 398   11337
85 85 Concord Concord 2021-04-15 Contra Costa 13 7822   130143
86 86 Crockett Crockett 2021-04-15 Contra Costa 13 124   3044
87 87 Danville Danville 2021-04-15 Contra Costa 13 1586   43876
88 88 Diablo Diablo 2021-04-15 Contra Costa 13 36   818
89 89 Discovery Bay Discovery Bay 2021-04-15 Contra Costa 13 819   13352
90 90 El Cerrito El Cerrito 2021-04-15 Contra Costa 13 686   24953
91 91 El Sobrante El Sobrante 2021-04-15 Contra Costa 13 1191   12669
92 92 Hercules Hercules 2021-04-15 Contra Costa 13 1234   25530
93 93 Kensington Kensington 2021-04-15 Contra Costa 13 45   5077
94 94 Knightsen Knightsen 2021-04-15 Contra Costa 13 23   1500
95 95 Lafayette Lafayette 2021-04-15 Contra Costa 13 607   25604
96 96 Martinez Martinez 2021-04-15 Contra Costa 13 1909   37106
97 97 Moraga Moraga 2021-04-15 Contra Costa 13 314   16946
98 98 Oakley Oakley 2021-04-15 Contra Costa 13 3056   42461
99 99 Orinda Orinda 2021-04-15 Contra Costa 13 404   19009
100 100 Pacheco Pacheco 2021-04-15 Contra Costa 13 230   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
);