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,084,414 rows

✎ View and edit SQL

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

date (date) >30 ✖

Link rowid ▼ id name date county fips confirmed_cases note population
1 1 94501 94501: Alameda 2022-08-11 Alameda 1 10547   62826
2 2 94502 94502: Alameda 2022-08-11 Alameda 1 1760   14117
3 3 94505 94505: Discovery Bay 2022-08-11 Alameda 1 4   16382
4 4 94514 94514: Byron 2022-08-11 Alameda 1 3   1461
5 5 94536 94536: Fremont 2022-08-11 Alameda 1 12087   72976
6 6 94538 94538: Fremont 2022-08-11 Alameda 1 12657   63911
7 7 94539 94539: Fremont 2022-08-11 Alameda 1 6730   52960
8 8 94541 94541: Hayward 2022-08-11 Alameda 1 17715   65132
9 9 94542 94542: Hayward 2022-08-11 Alameda 1 2749   13973
10 10 94544 94544: Hayward 2022-08-11 Alameda 1 21555   77121
11 11 94545 94545: Hayward 2022-08-11 Alameda 1 8296   31657
12 12 94546 94546: Castro Valley 2022-08-11 Alameda 1 8611   45536
13 13 94550 94550: Livermore 2022-08-11 Alameda 1 8606   50138
14 14 94551 94551: Livermore 2022-08-11 Alameda 1 8066   38986
15 15 94552 94552: Castro Valley 2022-08-11 Alameda 1 2163   15204
16 16 94555 94555: Fremont 2022-08-11 Alameda 1 5317   36037
17 17 94560 94560: Newark 2022-08-11 Alameda 1 10542   44245
18 18 94566 94566: Pleasanton 2022-08-11 Alameda 1 6262   45046
19 19 94568 94568: Dublin 2022-08-11 Alameda 1 12524   58399
20 20 94577 94577: San Leandro 2022-08-11 Alameda 1 10665   48666
21 21 94578 94578: San Leandro 2022-08-11 Alameda 1 10149   40150
22 22 94579 94579: San Leandro 2022-08-11 Alameda 1 4870   20237
23 23 94580 94580: San Lorenzo 2022-08-11 Alameda 1 7210   28970
24 24 94586 94586: Sunol 2022-08-11 Alameda 1 129   797
25 25 94587 94587: Union City 2022-08-11 Alameda 1 14651   72446
26 26 94588 94588: Pleasanton 2022-08-11 Alameda 1 5174   31895
27 27 94601 94601: Oakland 2022-08-11 Alameda 1 15584   53261
28 28 94602 94602: Oakland 2022-08-11 Alameda 1 5364   29770
29 29 94603 94603: Oakland 2022-08-11 Alameda 1 10872   33241
30 30 94605 94605: Oakland 2022-08-11 Alameda 1 10015   42375
31 31 94606 94606: Oakland 2022-08-11 Alameda 1 7956   37076
32 32 94607 94607: Oakland 2022-08-11 Alameda 1 6314   26646
33 33 94608 94608: Emeryville 2022-08-11 Alameda 1 6439   31000
34 34 94609 94609: Oakland 2022-08-11 Alameda 1 4667   22293
35 35 94610 94610: Oakland 2022-08-11 Alameda 1 5046   30862
36 36 94611 94611: Oakland 2022-08-11 Alameda 1 5733   37826
37 37 94612 94612: Oakland 2022-08-11 Alameda 1 3809   17279
38 38 94613 94613: Oakland 2022-08-11 Alameda 1 5   212
39 39 94618 94618: Oakland 2022-08-11 Alameda 1 2049   15545
40 40 94619 94619: Oakland 2022-08-11 Alameda 1 4811   24080
41 41 94621 94621: Oakland 2022-08-11 Alameda 1 10626   32915
42 42 94702 94702: Berkeley 2022-08-11 Alameda 1 3010   16520
43 43 94703 94703: Berkeley 2022-08-11 Alameda 1 3319   19805
44 44 94704 94704: Berkeley 2022-08-11 Alameda 1 4837   29129
45 45 94705 94705: Berkeley 2022-08-11 Alameda 1 1852   13152
46 46 94706 94706: Albany 2022-08-11 Alameda 1 2478   19921
47 47 94707 94707: Berkeley 2022-08-11 Alameda 1 998   12862
48 48 94708 94708: Berkeley 2022-08-11 Alameda 1 958   11725
49 49 94709 94709: Berkeley 2022-08-11 Alameda 1 1520   11796
50 50 94710 94710: Berkeley 2022-08-11 Alameda 1 1888   8059
51 51 94720 94720: Berkeley 2022-08-11 Alameda 1 1001   1336
52 52 95377 95377: Tracy 2022-08-11 Alameda 1 1   32091
53 53 95391 95391: Mountain House 2022-08-11 Alameda 1 4   20131
54 54 95221, 95222 95221, 95222 2022-08-11 Calaveras 9 1135   5029
55 55 95223 95223 2022-08-11 Calaveras 9 419   2666
56 56 95225 95225 2022-08-11 Calaveras 9 121   378
57 57 95226, 95252 95226, 95252 2022-08-11 Calaveras 9 2759   16262
58 58 95228 95228 2022-08-11 Calaveras 9 927   4541
59 59 95232, 95245 95232, 95245 2022-08-11 Calaveras 9 340   161
60 60 95233, 95224, 95247, 95251, 95229 95233, 95224, 95247, 95251, 95229 2022-08-11 Calaveras 9 968   5364
61 61 95246, 95250 95246, 95250 2022-08-11 Calaveras 9 185   1159
62 62 95249 95249 2022-08-11 Calaveras 9 867   5444
63 63 95254 95254 2022-08-11 Calaveras 9 98   1035
64 64 95255, 95257, 95248 95255, 95257, 95248 2022-08-11 Calaveras 9 369   1802
65 65 Other Other 2022-08-11 Calaveras 9 58    
66 66 Alamo Alamo 2022-08-11 Contra Costa 13 2022   14750
67 67 Antioch Antioch 2022-08-11 Contra Costa 13 31101   112520
68 68 Bay Point Bay Point 2022-08-11 Contra Costa 13 7347   22639
69 69 Bethel Island Bethel Island 2022-08-11 Contra Costa 13 319   2137
70 70 Brentwood Brentwood 2022-08-11 Contra Costa 13 14474   65118
71 71 Byron Byron 2022-08-11 Contra Costa 13 297   1325
72 72 Clayton Clayton 2022-08-11 Contra Costa 13 1850   11337
73 73 Concord Concord 2022-08-11 Contra Costa 13 26236   130143
74 74 Crockett Crockett 2022-08-11 Contra Costa 13 564   3044
75 75 Danville Danville 2022-08-11 Contra Costa 13 7837   43876
76 76 Diablo Diablo 2022-08-11 Contra Costa 13 130   818
77 77 Discovery Bay Discovery Bay 2022-08-11 Contra Costa 13 2911   13352
78 78 El Cerrito El Cerrito 2022-08-11 Contra Costa 13 3619   24953
79 79 Hercules Hercules 2022-08-11 Contra Costa 13 5555   25530
80 80 Kensington Kensington 2022-08-11 Contra Costa 13 472   5077
81 81 Knightsen Knightsen 2022-08-11 Contra Costa 13 92   1500
82 82 Lafayette Lafayette 2022-08-11 Contra Costa 13 3343   25604
83 83 Martinez Martinez 2022-08-11 Contra Costa 13 8453   37106
84 84 Moraga Moraga 2022-08-11 Contra Costa 13 1794   16946
85 85 Oakley Oakley 2022-08-11 Contra Costa 13 11749   42461
86 86 Orinda Orinda 2022-08-11 Contra Costa 13 2273   19009
87 87 Pacheco Pacheco 2022-08-11 Contra Costa 13 836   3685
88 88 Pinole Pinole 2022-08-11 Contra Costa 13 4207   19505
89 89 Pittsburg Pittsburg 2022-08-11 Contra Costa 13 19912   74321
90 90 Pleasant Hill Pleasant Hill 2022-08-11 Contra Costa 13 5922   34267
91 91 Richmond Richmond 2022-08-11 Contra Costa 13 33802   111217
92 92 Rodeo Rodeo 2022-08-11 Contra Costa 13 2266   8679
93 93 San Pablo San Pablo 2022-08-11 Contra Costa 13 14280   31413
94 94 San Ramon San Ramon 2022-08-11 Contra Costa 13 12265   83118
95 95 Walnut Creek Walnut Creek 2022-08-11 Contra Costa 13 13167   70860
96 96 Auberry Auberry 2022-08-11 Fresno 19 365   3994
97 97 Biola Biola 2022-08-11 Fresno 19 443   949
98 98 Cantua Creek Cantua Creek 2022-08-11 Fresno 19 299   1125
99 99 Caruthers Caruthers 2022-08-11 Fresno 19 1483   5887
100 100 Clovis Clovis 2022-08-11 Fresno 19 26304   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
);