latimes-place-totals
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
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | id | name | date | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
201 | 201 | Census Tract 1121.00: San Rafael: California Park | Census Tract 1121.00: San Rafael: California Park | 2022-12-30 | Marin | 41 | 956 | 4512 | |
202 | 202 | Census Tract 1122.01: San Rafael: Canal | Census Tract 1122.01: San Rafael: Canal | 2022-12-30 | Marin | 41 | 2331 | 8175 | |
203 | 203 | Census Tract 1122.02: San Rafael: Canal | Census Tract 1122.02: San Rafael: Canal | 2022-12-30 | Marin | 41 | 1081 | 4771 | |
204 | 204 | Census Tract 1141.00: Fairfax; Unincorporated Marin | Census Tract 1141.00: Fairfax; Unincorporated Marin | 2022-12-30 | Marin | 41 | 659 | 5206 | |
205 | 205 | Census Tract 1142.00: Fairfax; Unincorporated Fairfax | Census Tract 1142.00: Fairfax; Unincorporated Fairfax | 2022-12-30 | Marin | 41 | 450 | 3242 | |
206 | 206 | Census Tract 1150.00: San Anselmo; Sleepy Hollow | Census Tract 1150.00: San Anselmo; Sleepy Hollow | 2022-12-30 | Marin | 41 | 905 | 7528 | |
207 | 207 | Census Tract 1160.00: San Anselmo | Census Tract 1160.00: San Anselmo | 2022-12-30 | Marin | 41 | 390 | 3154 | |
208 | 208 | Census Tract 1170.00: San Anselmo | Census Tract 1170.00: San Anselmo | 2022-12-30 | Marin | 41 | 645 | 4212 | |
209 | 209 | Census Tract 1181.00: Ross | Census Tract 1181.00: Ross | 2022-12-30 | Marin | 41 | 314 | 2290 | |
210 | 210 | Census Tract 1191.00: Kentfield | Census Tract 1191.00: Kentfield | 2022-12-30 | Marin | 41 | 751 | 4983 | |
211 | 211 | Census Tract 1192.01: Larkspur; Kentfield | Census Tract 1192.01: Larkspur; Kentfield | 2022-12-30 | Marin | 41 | 666 | 3601 | |
212 | 212 | Census Tract 1192.02: Larkspur; Kentfield | Census Tract 1192.02: Larkspur; Kentfield | 2022-12-30 | Marin | 41 | 489 | 3546 | |
213 | 213 | Census Tract 1200.00: Larkspur | Census Tract 1200.00: Larkspur | 2022-12-30 | Marin | 41 | 907 | 5857 | |
214 | 214 | Census Tract 1211.00: Corte Madera | Census Tract 1211.00: Corte Madera | 2022-12-30 | Marin | 41 | 903 | 5453 | |
215 | 215 | Census Tract 1212.00: Corte Madera | Census Tract 1212.00: Corte Madera | 2022-12-30 | Marin | 41 | 1107 | 6414 | |
216 | 216 | Census Tract 1230.00: Belvedere | Census Tract 1230.00: Belvedere | 2022-12-30 | Marin | 41 | 285 | 2124 | |
217 | 217 | Census Tract 1241.00: Tiburon; Strawberry | Census Tract 1241.00: Tiburon; Strawberry | 2022-12-30 | Marin | 41 | 732 | 5889 | |
218 | 218 | Census Tract 1242.00: Tiburon | Census Tract 1242.00: Tiburon | 2022-12-30 | Marin | 41 | 806 | 5716 | |
219 | 219 | Census Tract 1250.00: Strawberry | Census Tract 1250.00: Strawberry | 2022-12-30 | Marin | 41 | 576 | 4177 | |
220 | 220 | Census Tract 1261.00: Mill Valley | Census Tract 1261.00: Mill Valley | 2022-12-30 | Marin | 41 | 693 | 6195 | |
221 | 221 | Census Tract 1262.00: Mill Valley | Census Tract 1262.00: Mill Valley | 2022-12-30 | Marin | 41 | 702 | 4224 | |
222 | 222 | Census Tract 1270.00: Mill Valley | Census Tract 1270.00: Mill Valley | 2022-12-30 | Marin | 41 | 561 | 4583 | |
223 | 223 | Census Tract 1281.00: Tamalpais Valley; Homestead Valley | Census Tract 1281.00: Tamalpais Valley; Homestead Valley | 2022-12-30 | Marin | 41 | 886 | 6911 | |
224 | 224 | Census Tract 1282.00: Almonte; Homestead; Muir Woods Park | Census Tract 1282.00: Almonte; Homestead; Muir Woods Park | 2022-12-30 | Marin | 41 | 601 | 4957 | |
225 | 225 | Census Tract 1290.00: Marin City | Census Tract 1290.00: Marin City | 2022-12-30 | Marin | 41 | 562 | 2939 | |
226 | 226 | Census Tract 1302.01: Sausalito: Waldo Point | Census Tract 1302.01: Sausalito: Waldo Point | 2022-12-30 | Marin | 41 | 481 | 3232 | |
227 | 227 | Census Tract 1302.02: Sausalito: Waldo Point | Census Tract 1302.02: Sausalito: Waldo Point | 2022-12-30 | Marin | 41 | 676 | 4377 | |
228 | 228 | Dillon Beach-Inverness-Point Reyes Station-Tomales | Dillon Beach-Inverness-Point Reyes Station-Tomales | 2022-12-30 | Marin | 41 | 254 | 1830 | |
229 | 229 | Nicasio-Lagunitas-Forest Knolls | Nicasio-Lagunitas-Forest Knolls | 2022-12-30 | Marin | 41 | 235 | 1842 | |
230 | 230 | San Geronimo-Woodacre | San Geronimo-Woodacre | 2022-12-30 | Marin | 41 | 201 | 1570 | |
231 | 231 | North Coast | North Coast | 2022-12-30 | Mendocino | 45 | 1567 | 16148 | |
232 | 232 | North County | North County | 2022-12-30 | Mendocino | 45 | 3574 | 19040 | |
233 | 233 | South Coast | South Coast | 2022-12-30 | Mendocino | 45 | 566 | 7693 | |
234 | 234 | South County | South County | 2022-12-30 | Mendocino | 45 | 353 | 6904 | |
235 | 235 | Ukiah Area | Ukiah Area | 2022-12-30 | Mendocino | 45 | 10323 | 38134 | |
236 | 236 | Atwater | Atwater | 2022-12-30 | Merced | 47 | 10520 | 33647 | |
237 | 237 | Delhi | Delhi | 2022-12-30 | Merced | 47 | 3647 | 10755 | |
238 | 238 | Dos Palos | Dos Palos | 2022-12-30 | Merced | 47 | 2526 | 5520 | |
239 | 239 | Gustine | Gustine | 2022-12-30 | Merced | 47 | 1916 | 5855 | |
240 | 240 | Hilmar | Hilmar | 2022-12-30 | Merced | 47 | 1586 | 5197 | |
241 | 241 | Le Grand Planada | Le Grand Planada | 2022-12-30 | Merced | 47 | 1646 | 6243 | |
242 | 242 | Livingston | Livingston | 2022-12-30 | Merced | 47 | 4956 | 14426 | |
243 | 243 | Los Banos | Los Banos | 2022-12-30 | Merced | 47 | 13944 | 40075 | |
244 | 244 | Merced | Merced | 2022-12-30 | Merced | 47 | 25831 | 89459 | |
245 | 245 | Winton | Winton | 2022-12-30 | Merced | 47 | 4059 | 10613 | |
246 | 246 | Mammoth Lakes Region | Mammoth Lakes Region | 2022-12-30 | Mono | 51 | 2296 | 8240 | |
247 | 247 | North and Central Region | North and Central Region | 2022-12-30 | Mono | 51 | 360 | 2498 | |
248 | 248 | South County Region | South County Region | 2022-12-30 | Mono | 51 | 311 | 3464 | |
249 | 249 | 93426 | 93426: Bradley | 2022-12-30 | Monterey | 53 | 100 | 1604 | |
250 | 250 | 93901 | 93901: Salinas | 2022-12-30 | Monterey | 53 | 6765 | 27805 | |
251 | 251 | 93905 | 93905: Salinas | 2022-12-30 | Monterey | 53 | 15857 | 60408 | |
252 | 252 | 93906 | 93906: Salinas | 2022-12-30 | Monterey | 53 | 15976 | 65256 | |
253 | 253 | 93907 | 93907: Salinas | 2022-12-30 | Monterey | 53 | 4331 | 22766 | |
254 | 254 | 93908 | 93908: Salinas | 2022-12-30 | Monterey | 53 | 1772 | 12093 | |
255 | 255 | 93912 | 93912: Boronda | 2022-12-30 | Monterey | 53 | 294 | 0 | |
256 | 256 | 93920 | 93920: Big Sur | 2022-12-30 | Monterey | 53 | 120 | 1403 | |
257 | 257 | 93921 | 93921: Carmel | 2022-12-30 | Monterey | 53 | 255 | 3379 | |
258 | 258 | 93922 | 93922: Carmel | 2022-12-30 | Monterey | 53 | 110 | 0 | |
259 | 259 | 93923 | 93923: Carmel | 2022-12-30 | Monterey | 53 | 1084 | 12833 | |
260 | 260 | 93924 | 93924: Carmel Valley | 2022-12-30 | Monterey | 53 | 605 | 6568 | |
261 | 261 | 93925 | 93925: Chualar | 2022-12-30 | Monterey | 53 | 363 | 2155 | |
262 | 262 | 93926 | 93926: Gonzales | 2022-12-30 | Monterey | 53 | 2222 | 9262 | |
263 | 263 | 93927 | 93927: Greenfield | 2022-12-30 | Monterey | 53 | 4840 | 18778 | |
264 | 264 | 93930 | 93930: King City | 2022-12-30 | Monterey | 53 | 4140 | 17142 | |
265 | 265 | 93933 | 93933: Marina | 2022-12-30 | Monterey | 53 | 4909 | 25015 | |
266 | 266 | 93940 | 93940: Monterey | 2022-12-30 | Monterey | 53 | 4401 | 32411 | |
267 | 267 | 93942 | 93942: Monterey | 2022-12-30 | Monterey | 53 | 94 | 0 | |
268 | 268 | 93950 | 93950: Pacific Grove | 2022-12-30 | Monterey | 53 | 1892 | 15595 | |
269 | 269 | 93953 | 93953: Pebble Beach | 2022-12-30 | Monterey | 53 | 442 | 4117 | |
270 | 270 | 93955 | 93955: Seaside | 2022-12-30 | Monterey | 53 | 7268 | 34395 | |
271 | 271 | 93960 | 93960: Soledad | 2022-12-30 | Monterey | 53 | 10411 | 26610 | |
272 | 272 | 95004 | 95004: Aromas | 2022-12-30 | Monterey | 53 | 468 | 3956 | |
273 | 273 | 95012 | 95012: Castroville | 2022-12-30 | Monterey | 53 | 3004 | 10792 | |
274 | 274 | 95039 | 95039: Moss Landing | 2022-12-30 | Monterey | 53 | 310 | 1195 | |
275 | 275 | 95076 | 95076: Watsonville | 2022-12-30 | Monterey | 53 | 3753 | 86703 | |
276 | 276 | American Canyon | American Canyon | 2022-12-30 | Napa | 55 | 6739 | 17167 | |
277 | 277 | Angwin | Angwin | 2022-12-30 | Napa | 55 | 380 | 2046 | |
278 | 278 | Between St Helena and Calistoga | Between St Helena and Calistoga | 2022-12-30 | Napa | 55 | 171 | 1744 | |
279 | 279 | Between Yountville and St Helena | Between Yountville and St Helena | 2022-12-30 | Napa | 55 | 253 | 2753 | |
280 | 280 | Calistoga | Calistoga | 2022-12-30 | Napa | 55 | 1100 | 4759 | |
281 | 281 | Chiles Valley Area | Chiles Valley Area | 2022-12-30 | Napa | 55 | 51 | 776 | |
282 | 282 | Deer Park | Deer Park | 2022-12-30 | Napa | 55 | 130 | 1460 | |
283 | 283 | East Napa Area | East Napa Area | 2022-12-30 | Napa | 55 | 1208 | 10237 | |
284 | 284 | Lake Berryessa | Lake Berryessa | 2022-12-30 | Napa | 55 | 163 | 1624 | |
285 | 285 | Napa | Napa | 2022-12-30 | Napa | 55 | 19892 | 79852 | |
286 | 286 | North Calistoga | North Calistoga | 2022-12-30 | Napa | 55 | 105 | 980 | |
287 | 287 | Northeast American Canyon Area | Northeast American Canyon Area | 2022-12-30 | Napa | 55 | 31 | 212 | |
288 | 288 | Pope Valley Area | Pope Valley Area | 2022-12-30 | Napa | 55 | 106 | 1275 | |
289 | 289 | South Napa Area | South Napa Area | 2022-12-30 | Napa | 55 | 1045 | 1961 | |
290 | 290 | St. Helena | St. Helena | 2022-12-30 | Napa | 55 | 961 | 6543 | |
291 | 291 | West Napa Area | West Napa Area | 2022-12-30 | Napa | 55 | 138 | 951 | |
292 | 292 | West Napa and Yountville Area | West Napa and Yountville Area | 2022-12-30 | Napa | 55 | 190 | 1699 | |
293 | 293 | Yountville | Yountville | 2022-12-30 | Napa | 55 | 528 | 3032 | |
294 | 294 | 95602 | 95602: Auburn | 2022-12-30 | Nevada | 57 | 747 | 0 | |
295 | 295 | 95712 | 95712: Chicago Park | 2022-12-30 | Nevada | 57 | 60 | 0 | |
296 | 296 | 95724 | 95724: Norden | 2022-12-30 | Nevada | 57 | 10 | 20 | |
297 | 297 | 95728 | 95728: Soda Springs | 2022-12-30 | Nevada | 57 | 77 | 229 | |
298 | 298 | 95924 | 95924: Cedar Ridge | 2022-12-30 | Nevada | 57 | 113 | 0 | |
299 | 299 | 95945 | 95945: Grass Valley | 2022-12-30 | Nevada | 57 | 4759 | 25519 | |
300 | 300 | 95946 | 95946: Penn Valley | 2022-12-30 | Nevada | 57 | 1359 | 9370 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "latimes-place-totals" ( [id] TEXT, [name] TEXT, [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [note] TEXT, [population] INTEGER );