latimes-place-totals

Table actions

Most counties break out the location of cases within their service area. The Times is gathering and consolidating these lists. Each row contains cumulative case totals reported in that area as of that date. Some counties currently do not report cases by locality.

Different counties provide different geography types. Some provide data by region, some by Census designation, some by ZIP Code. The locations provided by Los Angeles County correspond to the public health department's official "Countywide Statistical Areas". Locations can be mapped after being joined to the shapes in latimes-places-polygons.geojson using the id column.

Be aware that some counties have shifted the place names used over time.

In some circumstances the true total of cases is obscured. Los Angeles and Orange counties decline to provide the precise number of cases in areas with low populations and instead provide a potential range. The lowest number in the range is entered into the record in the confirmed_cases field and an accompanying note includes the set of possible values.

Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README

id
The unique identifier of the city, neighborhood or other area.
name
The name of the city, neighborhood or other area.
date
The date when the data were retrieved in ISO 8601 format.
county
The name of the county where the city is located.
fips
The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
confirmed_cases
The cumulative number of confirmed coronavirus case at that time.
note
In cases where the confirmed_cases are obscured, this explains the range of possible values.
population
The number of residents in the area. Not available for all places.

777,981 rows

✎ View and edit SQL

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

date (date) ✖

Link rowid ▼ id name date county fips confirmed_cases note population
1 1 94501 94501: Alameda 2021-11-30 Alameda 1 3270   62826
2 2 94502 94502: Alameda 2021-11-30 Alameda 1 405   14117
3 3 94505 94505: Discovery Bay 2021-11-30 Alameda 1 2   16382
4 4 94514 94514: Byron 2021-11-30 Alameda 1 1   1461
5 5 94536 94536: Fremont 2021-11-30 Alameda 1 3831   72976
6 6 94538 94538: Fremont 2021-11-30 Alameda 1 4094   63911
7 7 94539 94539: Fremont 2021-11-30 Alameda 1 1664   52960
8 8 94541 94541: Hayward 2021-11-30 Alameda 1 7924   65132
9 9 94542 94542: Hayward 2021-11-30 Alameda 1 1024   13973
10 10 94544 94544: Hayward 2021-11-30 Alameda 1 9524   77121
11 11 94545 94545: Hayward 2021-11-30 Alameda 1 3063   31657
12 12 94546 94546: Castro Valley 2021-11-30 Alameda 1 2845   45536
13 13 94550 94550: Livermore 2021-11-30 Alameda 1 3485   50138
14 14 94551 94551: Livermore 2021-11-30 Alameda 1 3383   38986
15 15 94552 94552: Castro Valley 2021-11-30 Alameda 1 605   15204
16 16 94555 94555: Fremont 2021-11-30 Alameda 1 1400   36037
17 17 94560 94560: Newark 2021-11-30 Alameda 1 3618   44245
18 18 94566 94566: Pleasanton 2021-11-30 Alameda 1 2106   45046
19 19 94568 94568: Dublin 2021-11-30 Alameda 1 3555   58399
20 20 94577 94577: San Leandro 2021-11-30 Alameda 1 4021   48666
21 21 94578 94578: San Leandro 2021-11-30 Alameda 1 4135   40150
22 22 94579 94579: San Leandro 2021-11-30 Alameda 1 1631   20237
23 23 94580 94580: San Lorenzo 2021-11-30 Alameda 1 2707   28970
24 24 94586 94586: Sunol 2021-11-30 Alameda 1 52   797
25 25 94587 94587: Union City 2021-11-30 Alameda 1 5178   72446
26 26 94588 94588: Pleasanton 2021-11-30 Alameda 1 1450   31895
27 27 94601 94601: Oakland 2021-11-30 Alameda 1 7349   53261
28 28 94602 94602: Oakland 2021-11-30 Alameda 1 1773   29770
29 29 94603 94603: Oakland 2021-11-30 Alameda 1 5593   33241
30 30 94605 94605: Oakland 2021-11-30 Alameda 1 4170   42375
31 31 94606 94606: Oakland 2021-11-30 Alameda 1 3066   37076
32 32 94607 94607: Oakland 2021-11-30 Alameda 1 2293   26646
33 33 94608 94608: Emeryville 2021-11-30 Alameda 1 1932   31000
34 34 94609 94609: Oakland 2021-11-30 Alameda 1 1549   22293
35 35 94610 94610: Oakland 2021-11-30 Alameda 1 1274   30862
36 36 94611 94611: Oakland 2021-11-30 Alameda 1 1421   37826
37 37 94612 94612: Oakland 2021-11-30 Alameda 1 1156   17279
38 38 94613 94613: Oakland 2021-11-30 Alameda 1 4   212
39 39 94618 94618: Oakland 2021-11-30 Alameda 1 444   15545
40 40 94619 94619: Oakland 2021-11-30 Alameda 1 1725   24080
41 41 94621 94621: Oakland 2021-11-30 Alameda 1 5373   32915
42 42 94702 94702: Berkeley 2021-11-30 Alameda 1 862   16520
43 43 94703 94703: Berkeley 2021-11-30 Alameda 1 931   19805
44 44 94704 94704: Berkeley 2021-11-30 Alameda 1 1290   29129
45 45 94705 94705: Berkeley 2021-11-30 Alameda 1 451   13152
46 46 94706 94706: Albany 2021-11-30 Alameda 1 565   19921
47 47 94707 94707: Berkeley 2021-11-30 Alameda 1 218   12862
48 48 94708 94708: Berkeley 2021-11-30 Alameda 1 179   11725
49 49 94709 94709: Berkeley 2021-11-30 Alameda 1 270   11796
50 50 94710 94710: Berkeley 2021-11-30 Alameda 1 767   8059
51 51 94720 94720: Berkeley 2021-11-30 Alameda 1 267   1336
52 52 95377 95377: Tracy 2021-11-30 Alameda 1 1   32091
53 53 95391 95391: Mountain House 2021-11-30 Alameda 1 1   20131
54 54 Ione & surrounding unincorporated areas Ione & surrounding unincorporated areas 2021-11-30 Amador 5 1110   7439
55 55 Jackson Jackson 2021-11-30 Amador 5 971   4694
56 56 Pine Grove Pine Grove 2021-11-30 Amador 5 383   1730
57 57 Pioneer Pioneer 2021-11-30 Amador 5 384   1443
58 58 Plymouth & surrounding unincorporated areas Plymouth & surrounding unincorporated areas 2021-11-30 Amador 5 382   894
59 59 Sutter Creek & Amador City Sutter Creek & Amador City 2021-11-30 Amador 5 485   2705
60 60 Volcano Volcano 2021-11-30 Amador 5 64   44
61 61 Biggs/Gridley Biggs/Gridley 2021-11-30 Butte 7 2179   8908
62 62 Chico Chico 2021-11-30 Butte 7 10806   91998
63 63 Durham Durham 2021-11-30 Butte 7 272   5863
64 64 Oroville Oroville 2021-11-30 Butte 7 6595   19040
65 65 Other Other 2021-11-30 Butte 7 953   33084
66 66 Ridge Communities Ridge Communities 2021-11-30 Butte 7 1067   39707
67 67 95221, 95222 95221, 95222 2021-11-30 Calaveras 9 593   5029
68 68 95223 95223 2021-11-30 Calaveras 9 207   2666
69 69 95224, 95247, 95251, 95229 95224, 95247, 95251, 95229 2021-11-30 Calaveras 9 440   4816
70 70 95225 95225 2021-11-30 Calaveras 9 65   378
71 71 95226, 95252 95226, 95252 2021-11-30 Calaveras 9 1548   16262
72 72 95228 95228 2021-11-30 Calaveras 9 501   4541
73 73 95232, 95245 95232, 95245 2021-11-30 Calaveras 9 164   161
74 74 95246, 95250 95246, 95250 2021-11-30 Calaveras 9 93   1159
75 75 95249 95249 2021-11-30 Calaveras 9 446   5444
76 76 95254 95254 2021-11-30 Calaveras 9 53   1035
77 77 95255, 95257, 95248 95255, 95257, 95248 2021-11-30 Calaveras 9 179   1802
78 78 Other Other 2021-11-30 Calaveras 9 65    
79 79 Alamo Alamo 2021-11-30 Contra Costa 13 785   14750
80 80 Antioch Antioch 2021-11-30 Contra Costa 13 14796   112520
81 81 Bay Point Bay Point 2021-11-30 Contra Costa 13 3859   22639
82 82 Bethel Island Bethel Island 2021-11-30 Contra Costa 13 165   2137
83 83 Brentwood Brentwood 2021-11-30 Contra Costa 13 6474   65118
84 84 Byron Byron 2021-11-30 Contra Costa 13 184   1325
85 85 Clayton Clayton 2021-11-30 Contra Costa 13 711   11337
86 86 Concord Concord 2021-11-30 Contra Costa 13 11435   130143
87 87 Crockett Crockett 2021-11-30 Contra Costa 13 226   3044
88 88 Danville Danville 2021-11-30 Contra Costa 13 2608   43876
89 89 Diablo Diablo 2021-11-30 Contra Costa 13 51   818
90 90 Discovery Bay Discovery Bay 2021-11-30 Contra Costa 13 1493   13352
91 91 El Cerrito El Cerrito 2021-11-30 Contra Costa 13 1058   24953
92 92 Hercules Hercules 2021-11-30 Contra Costa 13 1908   25530
93 93 Kensington Kensington 2021-11-30 Contra Costa 13 108   5077
94 94 Knightsen Knightsen 2021-11-30 Contra Costa 13 38   1500
95 95 Lafayette Lafayette 2021-11-30 Contra Costa 13 1040   25604
96 96 Martinez Martinez 2021-11-30 Contra Costa 13 3298   37106
97 97 Moraga Moraga 2021-11-30 Contra Costa 13 492   16946
98 98 Oakley Oakley 2021-11-30 Contra Costa 13 5427   42461
99 99 Orinda Orinda 2021-11-30 Contra Costa 13 624   19009
100 100 Pacheco Pacheco 2021-11-30 Contra Costa 13 333   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] INTEGER
);