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.

1,251,796 rows

✎ View and edit SQL

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

Suggested facets: date (date)

Link rowid ▼ id name date county fips confirmed_cases note population
1 1 94501 94501: Alameda 2022-12-30 Alameda 1 11911   62826
2 2 94502 94502: Alameda 2022-12-30 Alameda 1 2057   14117
3 3 94505 94505: Discovery Bay 2022-12-30 Alameda 1 4   16382
4 4 94514 94514: Byron 2022-12-30 Alameda 1 3   1461
5 5 94536 94536: Fremont 2022-12-30 Alameda 1 13610   72976
6 6 94538 94538: Fremont 2022-12-30 Alameda 1 14303   63911
7 7 94539 94539: Fremont 2022-12-30 Alameda 1 7755   52960
8 8 94541 94541: Hayward 2022-12-30 Alameda 1 19284   65132
9 9 94542 94542: Hayward 2022-12-30 Alameda 1 3054   13973
10 10 94544 94544: Hayward 2022-12-30 Alameda 1 23527   77121
11 11 94545 94545: Hayward 2022-12-30 Alameda 1 9166   31657
12 12 94546 94546: Castro Valley 2022-12-30 Alameda 1 9576   45536
13 13 94550 94550: Livermore 2022-12-30 Alameda 1 9399   50138
14 14 94551 94551: Livermore 2022-12-30 Alameda 1 8839   38986
15 15 94552 94552: Castro Valley 2022-12-30 Alameda 1 2419   15204
16 16 94555 94555: Fremont 2022-12-30 Alameda 1 6028   36037
17 17 94560 94560: Newark 2022-12-30 Alameda 1 11902   44245
18 18 94566 94566: Pleasanton 2022-12-30 Alameda 1 7054   45046
19 19 94568 94568: Dublin 2022-12-30 Alameda 1 14203   58399
20 20 94577 94577: San Leandro 2022-12-30 Alameda 1 11851   48666
21 21 94578 94578: San Leandro 2022-12-30 Alameda 1 11167   40150
22 22 94579 94579: San Leandro 2022-12-30 Alameda 1 5515   20237
23 23 94580 94580: San Lorenzo 2022-12-30 Alameda 1 8047   28970
24 24 94586 94586: Sunol 2022-12-30 Alameda 1 146   797
25 25 94587 94587: Union City 2022-12-30 Alameda 1 16574   72446
26 26 94588 94588: Pleasanton 2022-12-30 Alameda 1 5863   31895
27 27 94601 94601: Oakland 2022-12-30 Alameda 1 16510   53261
28 28 94602 94602: Oakland 2022-12-30 Alameda 1 6025   29770
29 29 94603 94603: Oakland 2022-12-30 Alameda 1 11584   33241
30 30 94605 94605: Oakland 2022-12-30 Alameda 1 10983   42375
31 31 94606 94606: Oakland 2022-12-30 Alameda 1 8752   37076
32 32 94607 94607: Oakland 2022-12-30 Alameda 1 6784   26646
33 33 94608 94608: Emeryville 2022-12-30 Alameda 1 7113   31000
34 34 94609 94609: Oakland 2022-12-30 Alameda 1 5244   22293
35 35 94610 94610: Oakland 2022-12-30 Alameda 1 5747   30862
36 36 94611 94611: Oakland 2022-12-30 Alameda 1 6604   37826
37 37 94612 94612: Oakland 2022-12-30 Alameda 1 4227   17279
38 38 94613 94613: Oakland 2022-12-30 Alameda 1 8   212
39 39 94618 94618: Oakland 2022-12-30 Alameda 1 2309   15545
40 40 94619 94619: Oakland 2022-12-30 Alameda 1 5343   24080
41 41 94621 94621: Oakland 2022-12-30 Alameda 1 11341   32915
42 42 94702 94702: Berkeley 2022-12-30 Alameda 1 3433   16520
43 43 94703 94703: Berkeley 2022-12-30 Alameda 1 3841   19805
44 44 94704 94704: Berkeley 2022-12-30 Alameda 1 5322   29129
45 45 94705 94705: Berkeley 2022-12-30 Alameda 1 2170   13152
46 46 94706 94706: Albany 2022-12-30 Alameda 1 2913   19921
47 47 94707 94707: Berkeley 2022-12-30 Alameda 1 1202   12862
48 48 94708 94708: Berkeley 2022-12-30 Alameda 1 1114   11725
49 49 94709 94709: Berkeley 2022-12-30 Alameda 1 1743   11796
50 50 94710 94710: Berkeley 2022-12-30 Alameda 1 2086   8059
51 51 94720 94720: Berkeley 2022-12-30 Alameda 1 1132   1336
52 52 95377 95377: Tracy 2022-12-30 Alameda 1 1   32091
53 53 95391 95391: Mountain House 2022-12-30 Alameda 1 2   20131
54 54 95221, 95222 95221, 95222 2022-12-30 Calaveras 9 140   5029
55 55 95223 95223 2022-12-30 Calaveras 9 51   2666
56 56 95225 95225 2022-12-30 Calaveras 9 17   378
57 57 95226, 95252 95226, 95252 2022-12-30 Calaveras 9 435   16262
58 58 95228 95228 2022-12-30 Calaveras 9 119   4541
59 59 95232, 95245 95232, 95245 2022-12-30 Calaveras 9 34   161
60 60 95233, 95224, 95247, 95251, 95229 95233, 95224, 95247, 95251, 95229 2022-12-30 Calaveras 9 135   5364
61 61 95246, 95250 95246, 95250 2022-12-30 Calaveras 9 36   1159
62 62 95249 95249 2022-12-30 Calaveras 9 140   5444
63 63 95254 95254 2022-12-30 Calaveras 9 26   1035
64 64 95255, 95257, 95248 95255, 95257, 95248 2022-12-30 Calaveras 9 35   1802
65 65 Other Other 2022-12-30 Calaveras 9 43    
66 66 Alamo Alamo 2022-12-30 Contra Costa 13 2429   14750
67 67 Antioch Antioch 2022-12-30 Contra Costa 13 36594   112520
68 68 Bay Point Bay Point 2022-12-30 Contra Costa 13 8291   22639
69 69 Bethel Island Bethel Island 2022-12-30 Contra Costa 13 397   2137
70 70 Brentwood Brentwood 2022-12-30 Contra Costa 13 18749   65118
71 71 Byron Byron 2022-12-30 Contra Costa 13 349   1325
72 72 Clayton Clayton 2022-12-30 Contra Costa 13 2132   11337
73 73 Concord Concord 2022-12-30 Contra Costa 13 30127   130143
74 74 Crockett Crockett 2022-12-30 Contra Costa 13 654   3044
75 75 Danville Danville 2022-12-30 Contra Costa 13 9666   43876
76 76 Diablo Diablo 2022-12-30 Contra Costa 13 153   818
77 77 Discovery Bay Discovery Bay 2022-12-30 Contra Costa 13 3417   13352
78 78 El Cerrito El Cerrito 2022-12-30 Contra Costa 13 4540   24953
79 79 Hercules Hercules 2022-12-30 Contra Costa 13 6580   25530
80 80 Kensington Kensington 2022-12-30 Contra Costa 13 592   5077
81 81 Knightsen Knightsen 2022-12-30 Contra Costa 13 105   1500
82 82 Lafayette Lafayette 2022-12-30 Contra Costa 13 4314   25604
83 83 Martinez Martinez 2022-12-30 Contra Costa 13 10486   37106
84 84 Moraga Moraga 2022-12-30 Contra Costa 13 2299   16946
85 85 Oakley Oakley 2022-12-30 Contra Costa 13 13815   42461
86 86 Orinda Orinda 2022-12-30 Contra Costa 13 2799   19009
87 87 Pacheco Pacheco 2022-12-30 Contra Costa 13 1020   3685
88 88 Pinole Pinole 2022-12-30 Contra Costa 13 5010   19505
89 89 Pittsburg Pittsburg 2022-12-30 Contra Costa 13 22663   74321
90 90 Pleasant Hill Pleasant Hill 2022-12-30 Contra Costa 13 7029   34267
91 91 Richmond Richmond 2022-12-30 Contra Costa 13 39779   111217
92 92 Rodeo Rodeo 2022-12-30 Contra Costa 13 2590   8679
93 93 San Pablo San Pablo 2022-12-30 Contra Costa 13 16631   31413
94 94 San Ramon San Ramon 2022-12-30 Contra Costa 13 15025   83118
95 95 Walnut Creek Walnut Creek 2022-12-30 Contra Costa 13 15575   70860
96 96 Auberry Auberry 2022-12-30 Fresno 19 407   3994
97 97 Biola Biola 2022-12-30 Fresno 19 469   949
98 98 Cantua Creek Cantua Creek 2022-12-30 Fresno 19 306   1125
99 99 Caruthers Caruthers 2022-12-30 Fresno 19 1583   5887
100 100 Clovis Clovis 2022-12-30 Fresno 19 28757   122949

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