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)

Link rowid ▼ id name date county fips confirmed_cases note population
101 101 Coalinga Coalinga 2022-12-30 Fresno 19 7754   19345
102 102 Del Rey Del Rey 2022-12-30 Fresno 19 768   2759
103 103 Dinuba Dinuba 2022-12-30 Fresno 19 131   0
104 104 Dos Palos Dos Palos 2022-12-30 Fresno 19 107    
105 105 Dunlap Dunlap 2022-12-30 Fresno 19 89    
106 106 Firebaugh Firebaugh 2022-12-30 Fresno 19 2627   9965
107 107 Five Points Five Points 2022-12-30 Fresno 19 157   0
108 108 Fowler Fowler 2022-12-30 Fresno 19 2712   7917
109 109 Fresno Fresno 2022-12-30 Fresno 19 173123   608579
110 110 Friant Friant 2022-12-30 Fresno 19 317   1930
111 111 Huron Huron 2022-12-30 Fresno 19 1856   7579
112 112 Kerman Kerman 2022-12-30 Fresno 19 6093   21009
113 113 Kingsburg Kingsburg 2022-12-30 Fresno 19 3614   17086
114 114 Laton Laton 2022-12-30 Fresno 19 892   3513
115 115 Mendota Mendota 2022-12-30 Fresno 19 3625   13576
116 116 Orange Cove Orange Cove 2022-12-30 Fresno 19 3571   11320
117 117 Parlier Parlier 2022-12-30 Fresno 19 5854   17097
118 118 Prather Prather 2022-12-30 Fresno 19 205   0
119 119 Raisin Raisin 2022-12-30 Fresno 19 151   380
120 120 Reedley Reedley 2022-12-30 Fresno 19 8958   31129
121 121 Riverdale Riverdale 2022-12-30 Fresno 19 1900   6459
122 122 San Joaquin San Joaquin 2022-12-30 Fresno 19 1212   4633
123 123 Sanger Sanger 2022-12-30 Fresno 19 12129   38252
124 124 Selma Selma 2022-12-30 Fresno 19 10706   31726
125 125 Squaw Valley Squaw Valley 2022-12-30 Fresno 19 423   3908
126 126 Tollhouse Tollhouse 2022-12-30 Fresno 19 302   2712
127 127 Tranquillity Tranquillity 2022-12-30 Fresno 19 275   1132
128 128 Greater Fortuna Area Greater Fortuna Area 2022-12-30 Humboldt 23 2867   20858
129 129 Greater Humboldt Bay Greater Humboldt Bay 2022-12-30 Humboldt 23 9964   78013
130 130 North North 2022-12-30 Humboldt 23 3794   30236
131 131 South South 2022-12-30 Humboldt 23 899   7601
132 132 92222 92222: Bard 2022-12-30 Imperial 25 13   0
133 133 92227 92227: Brawley 2022-12-30 Imperial 25 10591   27255
134 134 92231 92231: Calexico 2022-12-30 Imperial 25 15292   40019
135 135 92233 92233: Calipatria 2022-12-30 Imperial 25 1264   7618
136 136 92243 92243: El Centro 2022-12-30 Imperial 25 16547   50484
137 137 92244 92244: El Centro 2022-12-30 Imperial 25 269   0
138 138 92249 92249: Heber 2022-12-30 Imperial 25 2447   7898
139 139 92250 92250: Holtville 2022-12-30 Imperial 25 2422   8979
140 140 92251 92251: Imperial 2022-12-30 Imperial 25 7854   23388
141 141 92257 92257: Niland 2022-12-30 Imperial 25 370   1332
142 142 92259 92259: Ocotillo 2022-12-30 Imperial 25 39   94
143 143 92266 92266: Palo Verde 2022-12-30 Imperial 25 20   108
144 144 92273 92273: Seeley 2022-12-30 Imperial 25 483   1704
145 145 92274 92274: Thermal 2022-12-30 Imperial 25 1173   15118
146 146 92275 92275: Salton City 2022-12-30 Imperial 25 73   2456
147 147 92281 92281: Westmorland 2022-12-30 Imperial 25 674   2859
148 148 92283 92283: Winterhaven 2022-12-30 Imperial 25 968   1694
149 149 Armona Armona 2022-12-30 Kings 31 1743   3795
150 150 Avenal Avenal 2022-12-30 Kings 31 7743   12923
151 151 Corcoran Corcoran 2022-12-30 Kings 31 11674   22301
152 152 Correctional facilities Prisons 2022-12-30 Kings 31 10587    
153 153 Hanford Hanford 2022-12-30 Kings 31 26001   55893
154 154 Kettleman City Kettleman City 2022-12-30 Kings 31 484   1395
155 155 Lemoore Lemoore 2022-12-30 Kings 31 12067   25791
156 156 Other Area Other 2022-12-30 Kings 31 1430    
157 157 Stratford Stratford 2022-12-30 Kings 31 550   878
158 158 95422 95422 2022-12-30 Lake 33 2851   15550
159 159 95423 95423 2022-12-30 Lake 33 492   3757
160 160 95424 95424 2022-12-30 Lake 33 49   0
161 161 95426 95426 2022-12-30 Lake 33 159   1404
162 162 95435 95435 2022-12-30 Lake 33 69   14
163 163 95443 95443 2022-12-30 Lake 33 24   270
164 164 95451 95451 2022-12-30 Lake 33 1997   11627
165 165 95453 95453 2022-12-30 Lake 33 2575   11092
166 166 95457 95457 2022-12-30 Lake 33 530   3330
167 167 95458 95458 2022-12-30 Lake 33 524   3019
168 168 95461 95461 2022-12-30 Lake 33 389   2440
169 169 95464 95464 2022-12-30 Lake 33 471   2538
170 170 95467 95467 2022-12-30 Lake 33 705   6044
171 171 95485 95485 2022-12-30 Lake 33 495   2688
172 172 95493 95493 2022-12-30 Lake 33 19   241
173 173 Reporting Area A Reporting Area A 2022-12-30 Madera 39 12324   40623
174 174 Reporting Area B Reporting Area B 2022-12-30 Madera 39 8812   25062
175 175 Reporting Area C Reporting Area C 2022-12-30 Madera 39 14281   49068
176 176 Reporting Area D1 Reporting Area D1 2022-12-30 Madera 39 3358   11908
177 177 Reporting Area D2 Reporting Area D2 2022-12-30 Madera 39 4219   28123
178 178 Bolinas-Muir Beach-Stinson Beach Bolinas-Muir Beach-Stinson Beach 2022-12-30 Marin 41 155   2010
179 179 Census Tract 1011.00: Novato: Black Point; North Novato Census Tract 1011.00: Novato: Black Point; North Novato 2022-12-30 Marin 41 359   2677
180 180 Census Tract 1012.00: Novato Census Tract 1012.00: Novato 2022-12-30 Marin 41 522   3015
181 181 Census Tract 1021.00: Novato Census Tract 1021.00: Novato 2022-12-30 Marin 41 350   2421
182 182 Census Tract 1022.02: Novato Census Tract 1022.02: Novato 2022-12-30 Marin 41 1128   6142
183 183 Census Tract 1022.03: Novato Census Tract 1022.03: Novato 2022-12-30 Marin 41 1158   5761
184 184 Census Tract 1031.00: Novato: Indian Valley Census Tract 1031.00: Novato: Indian Valley 2022-12-30 Marin 41 1294   7887
185 185 Census Tract 1032.00: Novato Census Tract 1032.00: Novato 2022-12-30 Marin 41 1551   7290
186 186 Census Tract 1041.01: Novato Census Tract 1041.01: Novato 2022-12-30 Marin 41 1486   8039
187 187 Census Tract 1041.02: Novato Census Tract 1041.02: Novato 2022-12-30 Marin 41 1128   5760
188 188 Census Tract 1042.00: Novato: Loma Verde Census Tract 1042.00: Novato: Loma Verde 2022-12-30 Marin 41 1108   5894
189 189 Census Tract 1043.00: Bel Marin Keys Census Tract 1043.00: Bel Marin Keys 2022-12-30 Marin 41 238   1653
190 190 Census Tract 1050.00: Novato Census Tract 1050.00: Novato 2022-12-30 Marin 41 1382   7077
191 191 Census Tract 1060.01: San Rafael; Unincorporated Marin Census Tract 1060.01: San Rafael; Unincorporated Marin 2022-12-30 Marin 41 1124   4582
192 192 Census Tract 1060.02: San Rafael: Santa Venetia Census Tract 1060.02: San Rafael: Santa Venetia 2022-12-30 Marin 41 1091   5598
193 193 Census Tract 1070.00: Lucas Valley; Lucas Valley Environs; Marinwood Census Tract 1070.00: Lucas Valley; Lucas Valley Environs; Marinwood 2022-12-30 Marin 41 855   6803
194 194 Census Tract 1081.00: San Rafael Census Tract 1081.00: San Rafael 2022-12-30 Marin 41 1084   6543
195 195 Census Tract 1082.00: San Rafael: Los Ranchitos Census Tract 1082.00: San Rafael: Los Ranchitos 2022-12-30 Marin 41 1386   6901
196 196 Census Tract 1090.01: San Rafael: Sun Valley Census Tract 1090.01: San Rafael: Sun Valley 2022-12-30 Marin 41 909   4280
197 197 Census Tract 1090.02: San Rafael: Sun Valley Census Tract 1090.02: San Rafael: Sun Valley 2022-12-30 Marin 41 600   3851
198 198 Census Tract 1101.00: San Rafael: Country Club Census Tract 1101.00: San Rafael: Country Club 2022-12-30 Marin 41 1307   5903
199 199 Census Tract 1102.00: San Rafael: Bayside Acres; Point San Pedro Census Tract 1102.00: San Rafael: Bayside Acres; Point San Pedro 2022-12-30 Marin 41 735   5016
200 200 Census Tract 1110.00: San Rafael Census Tract 1110.00: San Rafael 2022-12-30 Marin 41 1200   5204

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