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

736,553 rows sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips

county

Link rowid id name date ▲ county fips confirmed_cases note population
1 1 Davis Davis 2021-10-20 Yolo 113 3023   67988
2 2 Unincorporated Other 2021-10-20 Yolo 113 2211    
3 3 West Sacramento West Sacramento 2021-10-20 Yolo 113 5757   52826
4 4 Winters Winters 2021-10-20 Yolo 113 712   7132
5 5 Woodland Woodland 2021-10-20 Yolo 113 7353   59044
6 6 Davis Davis 2021-10-19 Yolo 113 2992   67988
7 7 Unincorporated Other 2021-10-19 Yolo 113 2294    
8 8 West Sacramento West Sacramento 2021-10-19 Yolo 113 5691   52826
9 9 Winters Winters 2021-10-19 Yolo 113 709   7132
10 10 Woodland Woodland 2021-10-19 Yolo 113 7268   59044
11 11 Davis Davis 2021-10-18 Yolo 113 2992   67988
12 12 Unincorporated Other 2021-10-18 Yolo 113 2294    
13 13 West Sacramento West Sacramento 2021-10-18 Yolo 113 5691   52826
14 14 Winters Winters 2021-10-18 Yolo 113 709   7132
15 15 Woodland Woodland 2021-10-18 Yolo 113 7268   59044
16 16 Davis Davis 2021-10-17 Yolo 113 2992   67988
17 17 Unincorporated Other 2021-10-17 Yolo 113 2294    
18 18 West Sacramento West Sacramento 2021-10-17 Yolo 113 5691   52826
19 19 Winters Winters 2021-10-17 Yolo 113 709   7132
20 20 Woodland Woodland 2021-10-17 Yolo 113 7268   59044
21 21 East County East County 2021-10-16 Trinity 105 573   6738
22 22 North County North County 2021-10-16 Trinity 105 33   699
23 23 South County South County 2021-10-16 Trinity 105 224   4010
24 24 West County West County 2021-10-16 Trinity 105 85   2254
25 25 Davis Davis 2021-10-16 Yolo 113 2992   67988
26 26 Unincorporated Other 2021-10-16 Yolo 113 2294    
27 27 West Sacramento West Sacramento 2021-10-16 Yolo 113 5691   52826
28 28 Winters Winters 2021-10-16 Yolo 113 709   7132
29 29 Woodland Woodland 2021-10-16 Yolo 113 7268   59044
30 30 East County East County 2021-10-15 Trinity 105 472   6738
31 31 North County North County 2021-10-15 Trinity 105 27   699
32 32 South County South County 2021-10-15 Trinity 105 189   4010
33 33 West County West County 2021-10-15 Trinity 105 67   2254
34 34 Davis Davis 2021-10-15 Yolo 113 2992   67988
35 35 Unincorporated Other 2021-10-15 Yolo 113 2294    
36 36 West Sacramento West Sacramento 2021-10-15 Yolo 113 5691   52826
37 37 Winters Winters 2021-10-15 Yolo 113 709   7132
38 38 Woodland Woodland 2021-10-15 Yolo 113 7268   59044
39 39 94501 94501: Alameda 2021-10-14 Alameda 1 3095   62826
40 40 94502 94502: Alameda 2021-10-14 Alameda 1 370   14117
41 41 94505 94505: Discovery Bay 2021-10-14 Alameda 1 2   16382
42 42 94514 94514: Byron 2021-10-14 Alameda 1 1   1461
43 43 94536 94536: Fremont 2021-10-14 Alameda 1 3604   72976
44 44 94538 94538: Fremont 2021-10-14 Alameda 1 3833   63911
45 45 94539 94539: Fremont 2021-10-14 Alameda 1 1535   52960
46 46 94541 94541: Hayward 2021-10-14 Alameda 1 7652   65132
47 47 94542 94542: Hayward 2021-10-14 Alameda 1 965   13973
48 48 94544 94544: Hayward 2021-10-14 Alameda 1 9247   77121
49 49 94545 94545: Hayward 2021-10-14 Alameda 1 2975   31657
50 50 94546 94546: Castro Valley 2021-10-14 Alameda 1 2664   45536
51 51 94550 94550: Livermore 2021-10-14 Alameda 1 3265   50138
52 52 94551 94551: Livermore 2021-10-14 Alameda 1 3203   38986
53 53 94552 94552: Castro Valley 2021-10-14 Alameda 1 560   15204
54 54 94555 94555: Fremont 2021-10-14 Alameda 1 1285   36037
55 55 94560 94560: Newark 2021-10-14 Alameda 1 3444   44245
56 56 94566 94566: Pleasanton 2021-10-14 Alameda 1 1963   45046
57 57 94568 94568: Dublin 2021-10-14 Alameda 1 3436   58399
58 58 94577 94577: San Leandro 2021-10-14 Alameda 1 3880   48666
59 59 94578 94578: San Leandro 2021-10-14 Alameda 1 3995   40150
60 60 94579 94579: San Leandro 2021-10-14 Alameda 1 1575   20237
61 61 94580 94580: San Lorenzo 2021-10-14 Alameda 1 2610   28970
62 62 94586 94586: Sunol 2021-10-14 Alameda 1 47   797
63 63 94587 94587: Union City 2021-10-14 Alameda 1 4976   72446
64 64 94588 94588: Pleasanton 2021-10-14 Alameda 1 1367   31895
65 65 94601 94601: Oakland 2021-10-14 Alameda 1 7243   53261
66 66 94602 94602: Oakland 2021-10-14 Alameda 1 1700   29770
67 67 94603 94603: Oakland 2021-10-14 Alameda 1 5480   33241
68 68 94605 94605: Oakland 2021-10-14 Alameda 1 4044   42375
69 69 94606 94606: Oakland 2021-10-14 Alameda 1 2973   37076
70 70 94607 94607: Oakland 2021-10-14 Alameda 1 2202   26646
71 71 94608 94608: Emeryville 2021-10-14 Alameda 1 1847   31000
72 72 94609 94609: Oakland 2021-10-14 Alameda 1 1472   22293
73 73 94610 94610: Oakland 2021-10-14 Alameda 1 1198   30862
74 74 94611 94611: Oakland 2021-10-14 Alameda 1 1335   37826
75 75 94612 94612: Oakland 2021-10-14 Alameda 1 1095   17279
76 76 94613 94613: Oakland 2021-10-14 Alameda 1 4   212
77 77 94618 94618: Oakland 2021-10-14 Alameda 1 415   15545
78 78 94619 94619: Oakland 2021-10-14 Alameda 1 1657   24080
79 79 94621 94621: Oakland 2021-10-14 Alameda 1 5300   32915
80 80 94702 94702: Berkeley 2021-10-14 Alameda 1 802   16520
81 81 94703 94703: Berkeley 2021-10-14 Alameda 1 885   19805
82 82 94704 94704: Berkeley 2021-10-14 Alameda 1 1202   29129
83 83 94705 94705: Berkeley 2021-10-14 Alameda 1 427   13152
84 84 94706 94706: Albany 2021-10-14 Alameda 1 514   19921
85 85 94707 94707: Berkeley 2021-10-14 Alameda 1 209   12862
86 86 94708 94708: Berkeley 2021-10-14 Alameda 1 163   11725
87 87 94709 94709: Berkeley 2021-10-14 Alameda 1 254   11796
88 88 94710 94710: Berkeley 2021-10-14 Alameda 1 720   8059
89 89 94720 94720: Berkeley 2021-10-14 Alameda 1 232   1336
90 90 95377 95377: Tracy 2021-10-14 Alameda 1 1   32091
91 91 95391 95391: Mountain House 2021-10-14 Alameda 1 1   20131
92 92 Ione & surrounding unincorporated areas Ione & surrounding unincorporated areas 2021-10-14 Amador 5 1010   7439
93 93 Jackson Jackson 2021-10-14 Amador 5 878   4694
94 94 Pine Grove Pine Grove 2021-10-14 Amador 5 348   1730
95 95 Pioneer Pioneer 2021-10-14 Amador 5 327   1443
96 96 Plymouth & surrounding unincorporated areas Plymouth & surrounding unincorporated areas 2021-10-14 Amador 5 305   894
97 97 Sutter Creek & Amador City Sutter Creek & Amador City 2021-10-14 Amador 5 441   2705
98 98 Volcano Volcano 2021-10-14 Amador 5 57   44
99 99 Biggs/Gridley Biggs/Gridley 2021-10-14 Butte 7 2046   8908
100 100 Chico Chico 2021-10-14 Butte 7 9957   91998

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