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 235,451
- San Diego 71,830
- Riverside 41,984
- San Bernardino 41,792
- Alameda 36,199
- Kern 30,750
- Orange 26,896
- Placer 21,888
- Sonoma 21,824
- Fresno 20,416
- Marin 19,769
- Contra Costa 19,370
- San Mateo 18,420
- Tulare 18,256
- San Francisco 17,342
- Monterey 15,876
- Ventura 15,750
- San Luis Obispo 14,608
- Napa 11,376
- Imperial 10,659
- Nevada 9,656
- Santa Clara 9,645
- Santa Barbara 7,227
- Lake 6,750
- Merced 6,610
- Stanislaus 6,460
- Kings 5,652
- Sacramento 5,192
- El Dorado 5,144
- Solano 5,112
- …
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
442399 | 442399 | Diablo | Diablo | 2022-01-11 | Contra Costa | 13 | 68 | 818 | |
442400 | 442400 | Discovery Bay | Discovery Bay | 2022-01-11 | Contra Costa | 13 | 1842 | 13352 | |
442401 | 442401 | El Cerrito | El Cerrito | 2022-01-11 | Contra Costa | 13 | 1655 | 24953 | |
442402 | 442402 | Hercules | Hercules | 2022-01-11 | Contra Costa | 13 | 2871 | 25530 | |
442403 | 442403 | Kensington | Kensington | 2022-01-11 | Contra Costa | 13 | 198 | 5077 | |
442404 | 442404 | Knightsen | Knightsen | 2022-01-11 | Contra Costa | 13 | 47 | 1500 | |
442405 | 442405 | Lafayette | Lafayette | 2022-01-11 | Contra Costa | 13 | 1574 | 25604 | |
442406 | 442406 | Martinez | Martinez | 2022-01-11 | Contra Costa | 13 | 4401 | 37106 | |
442407 | 442407 | Moraga | Moraga | 2022-01-11 | Contra Costa | 13 | 802 | 16946 | |
442408 | 442408 | Oakley | Oakley | 2022-01-11 | Contra Costa | 13 | 6800 | 42461 | |
442409 | 442409 | Orinda | Orinda | 2022-01-11 | Contra Costa | 13 | 1111 | 19009 | |
442410 | 442410 | Pacheco | Pacheco | 2022-01-11 | Contra Costa | 13 | 437 | 3685 | |
442411 | 442411 | Pinole | Pinole | 2022-01-11 | Contra Costa | 13 | 2231 | 19505 | |
442412 | 442412 | Pittsburg | Pittsburg | 2022-01-11 | Contra Costa | 13 | 11760 | 74321 | |
442413 | 442413 | Pleasant Hill | Pleasant Hill | 2022-01-11 | Contra Costa | 13 | 2716 | 34267 | |
442414 | 442414 | Richmond | Richmond | 2022-01-11 | Contra Costa | 13 | 19537 | 111217 | |
442415 | 442415 | Rodeo | Rodeo | 2022-01-11 | Contra Costa | 13 | 1207 | 8679 | |
442416 | 442416 | San Pablo | San Pablo | 2022-01-11 | Contra Costa | 13 | 8262 | 31413 | |
442417 | 442417 | San Ramon | San Ramon | 2022-01-11 | Contra Costa | 13 | 5333 | 83118 | |
442418 | 442418 | Walnut Creek | Walnut Creek | 2022-01-11 | Contra Costa | 13 | 6398 | 70860 | |
442419 | 442419 | Auberry | Auberry | 2022-01-11 | Fresno | 19 | 234 | 3994 | |
442420 | 442420 | Biola | Biola | 2022-01-11 | Fresno | 19 | 262 | 949 | |
442421 | 442421 | Cantua Creek | Cantua Creek | 2022-01-11 | Fresno | 19 | 179 | 1125 | |
442422 | 442422 | Caruthers | Caruthers | 2022-01-11 | Fresno | 19 | 1007 | 5887 | |
442423 | 442423 | Clovis | Clovis | 2022-01-11 | Fresno | 19 | 13334 | 122949 | |
442424 | 442424 | Coalinga | Coalinga | 2022-01-11 | Fresno | 19 | 4536 | 19345 | |
442425 | 442425 | Del Rey | Del Rey | 2022-01-11 | Fresno | 19 | 426 | 2759 | |
442426 | 442426 | Dinuba | Dinuba | 2022-01-11 | Fresno | 19 | 0 | 0 | |
442427 | 442427 | Dos Palos | Dos Palos | 2022-01-11 | Fresno | 19 | 0 | ||
442428 | 442428 | Dunlap | Dunlap | 2022-01-11 | Fresno | 19 | 6 | ||
442429 | 442429 | Firebaugh | Firebaugh | 2022-01-11 | Fresno | 19 | 1490 | 9965 | |
442430 | 442430 | Five Points | Five Points | 2022-01-11 | Fresno | 19 | 23 | 0 | |
442431 | 442431 | Fowler | Fowler | 2022-01-11 | Fresno | 19 | 1492 | 7917 | |
442432 | 442432 | Fresno | Fresno | 2022-01-11 | Fresno | 19 | 61638 | 608579 | |
442433 | 442433 | Friant | Friant | 2022-01-11 | Fresno | 19 | 130 | 1930 | |
442434 | 442434 | Huron | Huron | 2022-01-11 | Fresno | 19 | 1064 | 7579 | |
442435 | 442435 | Kerman | Kerman | 2022-01-11 | Fresno | 19 | 3509 | 21009 | |
442436 | 442436 | Kingsburg | Kingsburg | 2022-01-11 | Fresno | 19 | 2000 | 17086 | |
442437 | 442437 | Laton | Laton | 2022-01-11 | Fresno | 19 | 537 | 3513 | |
442438 | 442438 | Mendota | Mendota | 2022-01-11 | Fresno | 19 | 2189 | 13576 | |
442439 | 442439 | Orange Cove | Orange Cove | 2022-01-11 | Fresno | 19 | 2187 | 11320 | |
442440 | 442440 | Parlier | Parlier | 2022-01-11 | Fresno | 19 | 3479 | 17097 | |
442441 | 442441 | Prather | Prather | 2022-01-11 | Fresno | 19 | 111 | 0 | |
442442 | 442442 | Raisin | Raisin | 2022-01-11 | Fresno | 19 | 90 | 380 | |
442443 | 442443 | Reedley | Reedley | 2022-01-11 | Fresno | 19 | 4987 | 31129 | |
442444 | 442444 | Riverdale | Riverdale | 2022-01-11 | Fresno | 19 | 1095 | 6459 | |
442445 | 442445 | San Joaquin | San Joaquin | 2022-01-11 | Fresno | 19 | 729 | 4633 | |
442446 | 442446 | Sanger | Sanger | 2022-01-11 | Fresno | 19 | 6444 | 38252 | |
442447 | 442447 | Selma | Selma | 2022-01-11 | Fresno | 19 | 6052 | 31726 | |
442448 | 442448 | Squaw Valley | Squaw Valley | 2022-01-11 | Fresno | 19 | 218 | 3908 | |
442449 | 442449 | Tollhouse | Tollhouse | 2022-01-11 | Fresno | 19 | 159 | 2712 | |
442450 | 442450 | Tranquillity | Tranquillity | 2022-01-11 | Fresno | 19 | 162 | 1132 | |
442451 | 442451 | 92222 | 92222: Bard | 2022-01-11 | Imperial | 25 | 11 | 0 | |
442452 | 442452 | 92227 | 92227: Brawley | 2022-01-11 | Imperial | 25 | 6542 | 27255 | |
442453 | 442453 | 92231 | 92231: Calexico | 2022-01-11 | Imperial | 25 | 10098 | 40019 | |
442454 | 442454 | 92233 | 92233: Calipatria | 2022-01-11 | Imperial | 25 | 770 | 7618 | |
442455 | 442455 | 92243 | 92243: El Centro | 2022-01-11 | Imperial | 25 | 10201 | 50484 | |
442456 | 442456 | 92244 | 92244: El Centro | 2022-01-11 | Imperial | 25 | 142 | 0 | |
442457 | 442457 | 92249 | 92249: Heber | 2022-01-11 | Imperial | 25 | 1551 | 7898 | |
442458 | 442458 | 92250 | 92250: Holtville | 2022-01-11 | Imperial | 25 | 1488 | 8979 | |
442459 | 442459 | 92251 | 92251: Imperial | 2022-01-11 | Imperial | 25 | 4525 | 23388 | |
442460 | 442460 | 92257 | 92257: Niland | 2022-01-11 | Imperial | 25 | 223 | 1332 | |
442461 | 442461 | 92259 | 92259: Ocotillo | 2022-01-11 | Imperial | 25 | 21 | 94 | |
442462 | 442462 | 92266 | 92266: Palo Verde | 2022-01-11 | Imperial | 25 | 10 | 108 | |
442463 | 442463 | 92273 | 92273: Seeley | 2022-01-11 | Imperial | 25 | 301 | 1704 | |
442464 | 442464 | 92274 | 92274: Thermal | 2022-01-11 | Imperial | 25 | 756 | 15118 | |
442465 | 442465 | 92275 | 92275: Salton City | 2022-01-11 | Imperial | 25 | 43 | 2456 | |
442466 | 442466 | 92281 | 92281: Westmorland | 2022-01-11 | Imperial | 25 | 419 | 2859 | |
442467 | 442467 | 92283 | 92283: Winterhaven | 2022-01-11 | Imperial | 25 | 547 | 1694 | |
442468 | 442468 | 93226 | 93226: Glennville | 2022-01-11 | Kern | 29 | 30 | 195 | |
442469 | 442469 | 93238 | 93238: Kernville | 2022-01-11 | Kern | 29 | 151 | 1408 | |
442470 | 442470 | 93240 | 93240: Lake Isabella | 2022-01-11 | Kern | 29 | 759 | 6960 | |
442471 | 442471 | 93241 | 93241: Lamont | 2022-01-11 | Kern | 29 | 3245 | 16969 | |
442472 | 442472 | 93243 | 93243: Lebec | 2022-01-11 | Kern | 29 | 175 | 1709 | |
442473 | 442473 | 93249 | 93249: Lost Hills | 2022-01-11 | Kern | 29 | 386 | 2264 | |
442474 | 442474 | 93250 | 93250: Mc Farland | 2022-01-11 | Kern | 29 | 3288 | 15523 | |
442475 | 442475 | 93251 | 93251: Mc Kittrick | 2022-01-11 | Kern | 29 | 30 | 243 | |
442476 | 442476 | 93252 | 93252: Maricopa | 2022-01-11 | Kern | 29 | 188 | 3188 | |
442477 | 442477 | 93255 | 93255: Onyx | 2022-01-11 | Kern | 29 | 33 | 707 | |
442478 | 442478 | 93263 | 93263: Shafter | 2022-01-11 | Kern | 29 | 5087 | 20710 | |
442479 | 442479 | 93268 | 93268: Taft | 2022-01-11 | Kern | 29 | 3158 | 17620 | |
442480 | 442480 | 93276 | 93276: Tupman | 2022-01-11 | Kern | 29 | 41 | 159 | |
442481 | 442481 | 93280 | 93280: Wasco | 2022-01-11 | Kern | 29 | 7654 | 27552 | |
442482 | 442482 | 93283 | 93283: Weldon | 2022-01-11 | Kern | 29 | 183 | 2086 | |
442483 | 442483 | 93285 | 93285: Wofford Heights | 2022-01-11 | Kern | 29 | 214 | 1723 | |
442484 | 442484 | 93287 | 93287: Woody | 2022-01-11 | Kern | 29 | 22 | 74 | |
442485 | 442485 | 93301 | 93301: Bakersfield | 2022-01-11 | Kern | 29 | 3089 | 12345 | |
442486 | 442486 | 93304 | 93304: Bakersfield | 2022-01-11 | Kern | 29 | 10293 | 50787 | |
442487 | 442487 | 93305 | 93305: Bakersfield | 2022-01-11 | Kern | 29 | 7254 | 39114 | |
442488 | 442488 | 93306 | 93306: Bakersfield | 2022-01-11 | Kern | 29 | 14819 | 70208 | |
442489 | 442489 | 93307 | 93307: Bakersfield | 2022-01-11 | Kern | 29 | 18345 | 84948 | |
442490 | 442490 | 93308 | 93308: Bakersfield | 2022-01-11 | Kern | 29 | 9227 | 54042 | |
442491 | 442491 | 93309 | 93309: Bakersfield | 2022-01-11 | Kern | 29 | 11459 | 60893 | |
442492 | 442492 | 93311 | 93311: Bakersfield | 2022-01-11 | Kern | 29 | 8909 | 44862 | |
442493 | 442493 | 93312 | 93312: Bakersfield | 2022-01-11 | Kern | 29 | 10715 | 59359 | |
442494 | 442494 | 93313 | 93313: Bakersfield | 2022-01-11 | Kern | 29 | 12062 | 51245 | |
442495 | 442495 | 93314 | 93314: Bakersfield | 2022-01-11 | Kern | 29 | 6094 | 26992 | |
442496 | 442496 | 93501 | 93501: Mojave | 2022-01-11 | Kern | 29 | 780 | 5063 | |
442497 | 442497 | 93505 | 93505: California City | 2022-01-11 | Kern | 29 | 2613 | 13445 | |
442498 | 442498 | 93516 | 93516: Boron | 2022-01-11 | Kern | 29 | 293 | 2425 |
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 );