latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
1,251,796 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Los Angeles 75,895
- San Diego 22,110
- Riverside 13,056
- San Bernardino 12,864
- Alameda 12,243
- Orange 8,364
- Kern 8,150
- Placer 7,424
- Sonoma 7,360
- Fresno 5,952
- Contra Costa 5,790
- Tulare 5,600
- San Francisco 5,590
- San Mateo 4,860
- San Luis Obispo 4,664
- Ventura 4,450
- Monterey 3,672
- Napa 3,240
- Imperial 2,975
- Santa Clara 2,865
- Santa Barbara 2,255
- Merced 2,090
- Nevada 1,972
- Stanislaus 1,940
- Kings 1,584
- Sacramento 1,576
- El Dorado 1,571
- Solano 1,496
- Amador 1,225
- Yolo 985
- …
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
1014267 | 1014267 | Shingle Springs, Cameron Park, Rescue | Shingle Springs, Cameron Park, Rescue | 2020-10-16 | El Dorado | 17 | 168 | 35294 | |
1014268 | 1014268 | South County | South County | 2020-10-16 | El Dorado | 17 | 14 | 10345 | |
1014269 | 1014269 | Tahoe Region | Tahoe Region | 2020-10-16 | El Dorado | 17 | 506 | 30275 | |
1014270 | 1014270 | Auberry | Auberry | 2020-10-16 | Fresno | 19 | 35 | 3994 | |
1014271 | 1014271 | Biola | Biola | 2020-10-16 | Fresno | 19 | 64 | 949 | |
1014272 | 1014272 | Cantua Creek | Cantua Creek | 2020-10-16 | Fresno | 19 | 37 | 1125 | |
1014273 | 1014273 | Caruthers | Caruthers | 2020-10-16 | Fresno | 19 | 266 | 5887 | |
1014274 | 1014274 | Clovis | Clovis | 2020-10-16 | Fresno | 19 | 1743 | 122949 | |
1014275 | 1014275 | Coalinga | Coalinga | 2020-10-16 | Fresno | 19 | 491 | 19345 | |
1014276 | 1014276 | Del Rey | Del Rey | 2020-10-16 | Fresno | 19 | 120 | 2759 | |
1014277 | 1014277 | Dinuba | Dinuba | 2020-10-16 | Fresno | 19 | 0 | 0 | |
1014278 | 1014278 | Dos Palos | Dos Palos | 2020-10-16 | Fresno | 19 | 0 | ||
1014279 | 1014279 | Dunlap | Dunlap | 2020-10-16 | Fresno | 19 | 6 | ||
1014280 | 1014280 | Firebaugh | Firebaugh | 2020-10-16 | Fresno | 19 | 361 | 9965 | |
1014281 | 1014281 | Five Points | Five Points | 2020-10-16 | Fresno | 19 | 15 | 0 | |
1014282 | 1014282 | Fowler | Fowler | 2020-10-16 | Fresno | 19 | 242 | 7917 | |
1014283 | 1014283 | Fresno | Fresno | 2020-10-16 | Fresno | 19 | 16389 | 608579 | |
1014284 | 1014284 | Friant | Friant | 2020-10-16 | Fresno | 19 | 21 | 1930 | |
1014285 | 1014285 | Huron | Huron | 2020-10-16 | Fresno | 19 | 413 | 7579 | |
1014286 | 1014286 | Kerman | Kerman | 2020-10-16 | Fresno | 19 | 888 | 21009 | |
1014287 | 1014287 | Kingsburg | Kingsburg | 2020-10-16 | Fresno | 19 | 443 | 17086 | |
1014288 | 1014288 | Laton | Laton | 2020-10-16 | Fresno | 19 | 134 | 3513 | |
1014289 | 1014289 | Mendota | Mendota | 2020-10-16 | Fresno | 19 | 991 | 13576 | |
1014290 | 1014290 | Orange Cove | Orange Cove | 2020-10-16 | Fresno | 19 | 673 | 11320 | |
1014291 | 1014291 | Parlier | Parlier | 2020-10-16 | Fresno | 19 | 1109 | 17097 | |
1014292 | 1014292 | Prather | Prather | 2020-10-16 | Fresno | 19 | 10 | 0 | |
1014293 | 1014293 | Raisin | Raisin | 2020-10-16 | Fresno | 19 | 0 | 380 | |
1014294 | 1014294 | Reedley | Reedley | 2020-10-16 | Fresno | 19 | 1427 | 31129 | |
1014295 | 1014295 | Riverdale | Riverdale | 2020-10-16 | Fresno | 19 | 261 | 6459 | |
1014296 | 1014296 | San Joaquin | San Joaquin | 2020-10-16 | Fresno | 19 | 203 | 4633 | |
1014297 | 1014297 | Sanger | Sanger | 2020-10-16 | Fresno | 19 | 1394 | 38252 | |
1014298 | 1014298 | Selma | Selma | 2020-10-16 | Fresno | 19 | 1522 | 31726 | |
1014299 | 1014299 | Squaw Valley | Squaw Valley | 2020-10-16 | Fresno | 19 | 18 | 3908 | |
1014300 | 1014300 | Tollhouse | Tollhouse | 2020-10-16 | Fresno | 19 | 16 | 2712 | |
1014301 | 1014301 | Tranquillity | Tranquillity | 2020-10-16 | Fresno | 19 | 36 | 1132 | |
1014302 | 1014302 | 92222 | 92222: Bard | 2020-10-16 | Imperial | 25 | 2 | 0 | |
1014303 | 1014303 | 92227 | 92227: Brawley | 2020-10-16 | Imperial | 25 | 2129 | 27255 | |
1014304 | 1014304 | 92231 | 92231: Calexico | 2020-10-16 | Imperial | 25 | 3765 | 40019 | |
1014305 | 1014305 | 92233 | 92233: Calipatria | 2020-10-16 | Imperial | 25 | 328 | 7618 | |
1014306 | 1014306 | 92243 | 92243: El Centro | 2020-10-16 | Imperial | 25 | 0 | 50484 | |
1014307 | 1014307 | 92244 | 92244: El Centro | 2020-10-16 | Imperial | 25 | 1 | 0 | |
1014308 | 1014308 | 92249 | 92249: Heber | 2020-10-16 | Imperial | 25 | 539 | 7898 | |
1014309 | 1014309 | 92250 | 92250: Holtville | 2020-10-16 | Imperial | 25 | 504 | 8979 | |
1014310 | 1014310 | 92251 | 92251: Imperial | 2020-10-16 | Imperial | 25 | 1170 | 23388 | |
1014311 | 1014311 | 92257 | 92257: Niland | 2020-10-16 | Imperial | 25 | 46 | 1332 | |
1014312 | 1014312 | 92259 | 92259: Ocotillo | 2020-10-16 | Imperial | 25 | 3 | 94 | |
1014313 | 1014313 | 92266 | 92266: Palo Verde | 2020-10-16 | Imperial | 25 | 6 | 108 | |
1014314 | 1014314 | 92273 | 92273: Seeley | 2020-10-16 | Imperial | 25 | 84 | 1704 | |
1014315 | 1014315 | 92274 | 92274: Thermal | 2020-10-16 | Imperial | 25 | 177 | 15118 | |
1014316 | 1014316 | 92275 | 92275: Salton City | 2020-10-16 | Imperial | 25 | 27 | 2456 | |
1014317 | 1014317 | 92281 | 92281: Westmorland | 2020-10-16 | Imperial | 25 | 160 | 2859 | |
1014318 | 1014318 | 92283 | 92283: Winterhaven | 2020-10-16 | Imperial | 25 | 156 | 1694 | |
1014319 | 1014319 | 93226 | 93226: Glennville | 2020-10-16 | Kern | 29 | 2 | 195 | |
1014320 | 1014320 | 93238 | 93238: Kernville | 2020-10-16 | Kern | 29 | 16 | 1408 | |
1014321 | 1014321 | 93240 | 93240: Lake Isabella | 2020-10-16 | Kern | 29 | 46 | 6960 | |
1014322 | 1014322 | 93241 | 93241: Lamont | 2020-10-16 | Kern | 29 | 992 | 16969 | |
1014323 | 1014323 | 93243 | 93243: Lebec | 2020-10-16 | Kern | 29 | 14 | 1709 | |
1014324 | 1014324 | 93249 | 93249: Lost Hills | 2020-10-16 | Kern | 29 | 92 | 2264 | |
1014325 | 1014325 | 93250 | 93250: Mc Farland | 2020-10-16 | Kern | 29 | 963 | 15523 | |
1014326 | 1014326 | 93251 | 93251: Mc Kittrick | 2020-10-16 | Kern | 29 | 0 | 243 | |
1014327 | 1014327 | 93252 | 93252: Maricopa | 2020-10-16 | Kern | 29 | 23 | 3188 | |
1014328 | 1014328 | 93255 | 93255: Onyx | 2020-10-16 | Kern | 29 | 0 | 707 | |
1014329 | 1014329 | 93263 | 93263: Shafter | 2020-10-16 | Kern | 29 | 1291 | 20710 | |
1014330 | 1014330 | 93268 | 93268: Taft | 2020-10-16 | Kern | 29 | 499 | 17620 | |
1014331 | 1014331 | 93276 | 93276: Tupman | 2020-10-16 | Kern | 29 | 2 | 159 | |
1014332 | 1014332 | 93280 | 93280: Wasco | 2020-10-16 | Kern | 29 | 1625 | 27552 | |
1014333 | 1014333 | 93283 | 93283: Weldon | 2020-10-16 | Kern | 29 | 10 | 2086 | |
1014334 | 1014334 | 93285 | 93285: Wofford Heights | 2020-10-16 | Kern | 29 | 14 | 1723 | |
1014335 | 1014335 | 93287 | 93287: Woody | 2020-10-16 | Kern | 29 | 2 | 74 | |
1014336 | 1014336 | 93301 | 93301: Bakersfield | 2020-10-16 | Kern | 29 | 595 | 12345 | |
1014337 | 1014337 | 93304 | 93304: Bakersfield | 2020-10-16 | Kern | 29 | 2239 | 50787 | |
1014338 | 1014338 | 93305 | 93305: Bakersfield | 2020-10-16 | Kern | 29 | 1554 | 39114 | |
1014339 | 1014339 | 93306 | 93306: Bakersfield | 2020-10-16 | Kern | 29 | 3215 | 70208 | |
1014340 | 1014340 | 93307 | 93307: Bakersfield | 2020-10-16 | Kern | 29 | 4559 | 84948 | |
1014341 | 1014341 | 93308 | 93308: Bakersfield | 2020-10-16 | Kern | 29 | 1413 | 54042 | |
1014342 | 1014342 | 93309 | 93309: Bakersfield | 2020-10-16 | Kern | 29 | 2272 | 60893 | |
1014343 | 1014343 | 93311 | 93311: Bakersfield | 2020-10-16 | Kern | 29 | 1512 | 44862 | |
1014344 | 1014344 | 93312 | 93312: Bakersfield | 2020-10-16 | Kern | 29 | 1531 | 59359 | |
1014345 | 1014345 | 93313 | 93313: Bakersfield | 2020-10-16 | Kern | 29 | 2443 | 51245 | |
1014346 | 1014346 | 93314 | 93314: Bakersfield | 2020-10-16 | Kern | 29 | 779 | 26992 | |
1014347 | 1014347 | 93501 | 93501: Mojave | 2020-10-16 | Kern | 29 | 56 | 5063 | |
1014348 | 1014348 | 93505 | 93505: California City | 2020-10-16 | Kern | 29 | 124 | 13445 | |
1014349 | 1014349 | 93516 | 93516: Boron | 2020-10-16 | Kern | 29 | 8 | 2425 | |
1014350 | 1014350 | 93518 | 93518: Caliente | 2020-10-16 | Kern | 29 | 2 | 995 | |
1014351 | 1014351 | 93519 | 93519: Cantil | 2020-10-16 | Kern | 29 | 0 | 28 | |
1014352 | 1014352 | 93523 | 93523: Edwards | 2020-10-16 | Kern | 29 | 17 | 3312 | |
1014353 | 1014353 | 93524 | 93524: Edwards | 2020-10-16 | Kern | 29 | 1 | 168 | |
1014354 | 1014354 | 93203 | 93203: Arvin | 2020-10-16 | Kern | 29 | 1298 | 22471 | |
1014355 | 1014355 | 93205 | 93205: Bodfish | 2020-10-16 | Kern | 29 | 8 | 1593 | |
1014356 | 1014356 | 93206 | 93206: Buttonwillow | 2020-10-16 | Kern | 29 | 116 | 2044 | |
1014357 | 1014357 | 93215 | 93215: Delano | 2020-10-16 | Kern | 29 | 2231 | 55845 | |
1014358 | 1014358 | 93220 | 93220: Edison | 2020-10-16 | Kern | 29 | 3 | 313 | |
1014359 | 1014359 | 93222 | 93222: Pine Mountain Club | 2020-10-16 | Kern | 29 | 6 | 1420 | |
1014360 | 1014360 | 93224 | 93224: Fellows | 2020-10-16 | Kern | 29 | 3 | 402 | |
1014361 | 1014361 | 93225 | 93225: Frazier Park | 2020-10-16 | Kern | 29 | 35 | 5319 | |
1014362 | 1014362 | 93527 | 93527: Inyokern | 2020-10-16 | Kern | 29 | 9 | 1852 | |
1014363 | 1014363 | 93528 | 93528: Johannesburg | 2020-10-16 | Kern | 29 | 0 | 124 | |
1014364 | 1014364 | 93531 | 93531: Keene | 2020-10-16 | Kern | 29 | 6 | 422 | |
1014365 | 1014365 | 93554 | 93554: Randsburg | 2020-10-16 | Kern | 29 | 0 | 143 | |
1014366 | 1014366 | 93555 | 93555: Ridgecrest | 2020-10-16 | Kern | 29 | 124 | 34075 |
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] TEXT );