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 193,444
- San Diego 58,740
- Riverside 34,368
- San Bernardino 34,176
- Alameda 29,892
- Kern 24,750
- Orange 22,017
- Placer 18,080
- Sonoma 18,016
- Fresno 16,576
- Contra Costa 15,780
- Tulare 14,924
- San Mateo 14,850
- San Francisco 14,248
- Marin 13,462
- Ventura 12,775
- Monterey 12,663
- San Luis Obispo 11,990
- Napa 9,234
- Imperial 8,619
- Santa Clara 7,860
- Nevada 7,633
- Santa Barbara 5,918
- Merced 5,420
- Stanislaus 5,270
- Lake 4,965
- Kings 4,581
- Sacramento 4,240
- El Dorado 4,232
- Solano 4,160
- …
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
594322 | 594322 | Armona | Armona | 2021-09-14 | Kings | 31 | 766 | 3795 | |
594323 | 594323 | Avenal | Avenal | 2021-09-14 | Kings | 31 | 1446 | 12923 | |
594324 | 594324 | Corcoran | Corcoran | 2021-09-14 | Kings | 31 | 2431 | 22301 | |
594325 | 594325 | Correctional facilities | Prisons | 2021-09-14 | Kings | 31 | 7226 | ||
594326 | 594326 | Hanford | Hanford | 2021-09-14 | Kings | 31 | 10493 | 55893 | |
594327 | 594327 | Kettleman City | Kettleman City | 2021-09-14 | Kings | 31 | 193 | 1395 | |
594328 | 594328 | Lemoore | Lemoore | 2021-09-14 | Kings | 31 | 4968 | 25791 | |
594329 | 594329 | Other Area | Other | 2021-09-14 | Kings | 31 | 281 | ||
594330 | 594330 | Stratford | Stratford | 2021-09-14 | Kings | 31 | 236 | 878 | |
594331 | 594331 | 95422 | 95422 | 2021-09-14 | Lake | 33 | 1353 | 15550 | |
594332 | 594332 | 95423 | 95423 | 2021-09-14 | Lake | 33 | 212 | 3757 | |
594333 | 594333 | 95424 | 95424 | 2021-09-14 | Lake | 33 | 16 | 0 | |
594334 | 594334 | 95426 | 95426 | 2021-09-14 | Lake | 33 | 51 | 1404 | |
594335 | 594335 | 95435 | 95435 | 2021-09-14 | Lake | 33 | 48 | 14 | |
594336 | 594336 | 95443 | 95443 | 2021-09-14 | Lake | 33 | 2 | 270 | |
594337 | 594337 | 95451 | 95451 | 2021-09-14 | Lake | 33 | 991 | 11627 | |
594338 | 594338 | 95453 | 95453 | 2021-09-14 | Lake | 33 | 1260 | 11092 | |
594339 | 594339 | 95457 | 95457 | 2021-09-14 | Lake | 33 | 229 | 3330 | |
594340 | 594340 | 95458 | 95458 | 2021-09-14 | Lake | 33 | 215 | 3019 | |
594341 | 594341 | 95461 | 95461 | 2021-09-14 | Lake | 33 | 149 | 2440 | |
594342 | 594342 | 95464 | 95464 | 2021-09-14 | Lake | 33 | 230 | 2538 | |
594343 | 594343 | 95467 | 95467 | 2021-09-14 | Lake | 33 | 299 | 6044 | |
594344 | 594344 | 95485 | 95485 | 2021-09-14 | Lake | 33 | 215 | 2688 | |
594345 | 594345 | 95493 | 95493 | 2021-09-14 | Lake | 33 | 10 | 241 | |
594346 | 594346 | 90802 | 90802: Long Beach | 2021-09-14 | Los Angeles | 37 | 4757 | 39453 | |
594347 | 594347 | 90803 | 90803: Long Beach | 2021-09-14 | Los Angeles | 37 | 2405 | 32389 | |
594348 | 594348 | 90804 | 90804: Long Beach | 2021-09-14 | Los Angeles | 37 | 5388 | 39344 | |
594349 | 594349 | 90805 | 90805: Long Beach | 2021-09-14 | Los Angeles | 37 | 15659 | 96708 | |
594350 | 594350 | 90806 | 90806: Long Beach | 2021-09-14 | Los Angeles | 37 | 7147 | 42817 | |
594351 | 594351 | 90807 | 90807: Long Beach | 2021-09-14 | Los Angeles | 37 | 3583 | 32067 | |
594352 | 594352 | 90808 | 90808: Long Beach | 2021-09-14 | Los Angeles | 37 | 3379 | 38860 | |
594353 | 594353 | 90810 | 90810: Long Beach | 2021-09-14 | Los Angeles | 37 | 5095 | 38579 | |
594354 | 594354 | 90813 | 90813: Long Beach | 2021-09-14 | Los Angeles | 37 | 9101 | 59000 | |
594355 | 594355 | 90814 | 90814: Long Beach | 2021-09-14 | Los Angeles | 37 | 1701 | 18587 | |
594356 | 594356 | 90815 | 90815: Long Beach | 2021-09-14 | Los Angeles | 37 | 3608 | 41026 | |
594357 | 594357 | 91101 | 91101: Pasadena | 2021-09-14 | Los Angeles | 37 | 1649 | 20719 | |
594358 | 594358 | 91103 | 91103: Pasadena | 2021-09-14 | Los Angeles | 37 | 4008 | 28435 | |
594359 | 594359 | 91104 | 91104: Pasadena | 2021-09-14 | Los Angeles | 37 | 2951 | 39178 | |
594360 | 594360 | 91105 | 91105: Pasadena | 2021-09-14 | Los Angeles | 37 | 840 | 11907 | |
594361 | 594361 | 91106 | 91106: Pasadena | 2021-09-14 | Los Angeles | 37 | 1874 | 25479 | |
594362 | 594362 | 91107 | 91107: Pasadena | 2021-09-14 | Los Angeles | 37 | 1583 | 321 | |
594363 | 594363 | City of Agoura Hills | Agoura Hills | 2021-09-14 | Los Angeles | 37 | 1364 | 20883 | |
594364 | 594364 | City of Alhambra | Alhambra | 2021-09-14 | Los Angeles | 37 | 7942 | 86724 | |
594365 | 594365 | City of Arcadia | Arcadia | 2021-09-14 | Los Angeles | 37 | 3255 | 57754 | |
594366 | 594366 | City of Artesia | Artesia | 2021-09-14 | Los Angeles | 37 | 2403 | 16795 | |
594367 | 594367 | City of Avalon | Avalon | 2021-09-14 | Los Angeles | 37 | 28 | 3869 | |
594368 | 594368 | City of Azusa | Azusa | 2021-09-14 | Los Angeles | 37 | 7192 | 50040 | |
594369 | 594369 | City of Baldwin Park | Baldwin Park | 2021-09-14 | Los Angeles | 37 | 14328 | 76769 | |
594370 | 594370 | City of Bell | Bell | 2021-09-14 | Los Angeles | 37 | 7384 | 36332 | |
594371 | 594371 | City of Bell Gardens | Bell Gardens | 2021-09-14 | Los Angeles | 37 | 8953 | 43071 | |
594372 | 594372 | City of Bellflower | Bellflower | 2021-09-14 | Los Angeles | 37 | 12606 | 77735 | |
594373 | 594373 | City of Beverly Hills | Beverly Hills | 2021-09-14 | Los Angeles | 37 | 3510 | 34520 | |
594374 | 594374 | City of Bradbury | Bradbury | 2021-09-14 | Los Angeles | 37 | 42 | 1069 | |
594375 | 594375 | City of Burbank | Burbank | 2021-09-14 | Los Angeles | 37 | 10781 | 107180 | |
594376 | 594376 | City of Calabasas | Calabasas | 2021-09-14 | Los Angeles | 37 | 1691 | 24323 | |
594377 | 594377 | City of Carson | Carson | 2021-09-14 | Los Angeles | 37 | 11694 | 93846 | |
594378 | 594378 | City of Cerritos | Cerritos | 2021-09-14 | Los Angeles | 37 | 3621 | 50067 | |
594379 | 594379 | City of Claremont | Claremont | 2021-09-14 | Los Angeles | 37 | 2703 | 36484 | |
594380 | 594380 | City of Commerce | Commerce | 2021-09-14 | Los Angeles | 37 | 2666 | 13069 | |
594381 | 594381 | City of Compton | Compton | 2021-09-14 | Los Angeles | 37 | 19172 | 99904 | |
594382 | 594382 | City of Covina | Covina | 2021-09-14 | Los Angeles | 37 | 7437 | 49032 | |
594383 | 594383 | City of Cudahy | Cudahy | 2021-09-14 | Los Angeles | 37 | 5294 | 24347 | |
594384 | 594384 | City of Culver City | Culver City | 2021-09-14 | Los Angeles | 37 | 2806 | 39865 | |
594385 | 594385 | City of Diamond Bar | Diamond Bar | 2021-09-14 | Los Angeles | 37 | 3876 | 57515 | |
594386 | 594386 | City of Downey | Downey | 2021-09-14 | Los Angeles | 37 | 19911 | 114263 | |
594387 | 594387 | City of Duarte | Duarte | 2021-09-14 | Los Angeles | 37 | 2685 | 22016 | |
594388 | 594388 | City of El Monte | El Monte | 2021-09-14 | Los Angeles | 37 | 18677 | 117269 | |
594389 | 594389 | City of El Segundo | El Segundo | 2021-09-14 | Los Angeles | 37 | 1013 | 16786 | |
594390 | 594390 | City of Gardena | Gardena | 2021-09-14 | Los Angeles | 37 | 7553 | 61310 | |
594391 | 594391 | City of Glendale | Glendale | 2021-09-14 | Los Angeles | 37 | 23937 | 206493 | |
594392 | 594392 | City of Glendora | Glendora | 2021-09-14 | Los Angeles | 37 | 5739 | 52764 | |
594393 | 594393 | City of Hawaiian Gardens | Hawaiian Gardens | 2021-09-14 | Los Angeles | 37 | 2518 | 14676 | |
594394 | 594394 | City of Hawthorne | Hawthorne | 2021-09-14 | Los Angeles | 37 | 12304 | 88787 | |
594395 | 594395 | City of Hermosa Beach | Hermosa Beach | 2021-09-14 | Los Angeles | 37 | 1461 | 19670 | |
594396 | 594396 | City of Hidden Hills | Hidden Hills | 2021-09-14 | Los Angeles | 37 | 125 | 1890 | |
594397 | 594397 | City of Huntington Park | Huntington Park | 2021-09-14 | Los Angeles | 37 | 12120 | 59484 | |
594398 | 594398 | City of Industry | Industry | 2021-09-14 | Los Angeles | 37 | 188 | 437 | |
594399 | 594399 | City of Inglewood | Inglewood | 2021-09-14 | Los Angeles | 37 | 16393 | 113582 | |
594400 | 594400 | City of Irwindale | Irwindale | 2021-09-14 | Los Angeles | 37 | 297 | 1459 | |
594401 | 594401 | City of La Canada Flintridge | La Canada Flintridge | 2021-09-14 | Los Angeles | 37 | 1007 | 20693 | |
594402 | 594402 | City of La Habra Heights | La Habra Heights | 2021-09-14 | Los Angeles | 37 | 126 | 5455 | |
594403 | 594403 | City of La Mirada | La Mirada | 2021-09-14 | Los Angeles | 37 | 5101 | 49599 | |
594404 | 594404 | City of La Puente | La Puente | 2021-09-14 | Los Angeles | 37 | 7380 | 40697 | |
594405 | 594405 | City of La Verne | La Verne | 2021-09-14 | Los Angeles | 37 | 3409 | 33282 | |
594406 | 594406 | City of Lakewood | Lakewood | 2021-09-14 | Los Angeles | 37 | 9019 | 80362 | |
594407 | 594407 | City of Lancaster | Lancaster | 2021-09-14 | Los Angeles | 37 | 26889 | 161570 | |
594408 | 594408 | City of Lawndale | Lawndale | 2021-09-14 | Los Angeles | 37 | 4173 | 33614 | |
594409 | 594409 | City of Lomita | Lomita | 2021-09-14 | Los Angeles | 37 | 1848 | 20729 | |
594410 | 594410 | City of Lynwood | Lynwood | 2021-09-14 | Los Angeles | 37 | 14625 | 72047 | |
594411 | 594411 | City of Malibu | Malibu | 2021-09-14 | Los Angeles | 37 | 630 | 12961 | |
594412 | 594412 | City of Manhattan Beach | Manhattan Beach | 2021-09-14 | Los Angeles | 37 | 1953 | 35999 | |
594413 | 594413 | City of Maywood | Maywood | 2021-09-14 | Los Angeles | 37 | 5690 | 28049 | |
594414 | 594414 | City of Monrovia | Monrovia | 2021-09-14 | Los Angeles | 37 | 3808 | 38800 | |
594415 | 594415 | City of Montebello | Montebello | 2021-09-14 | Los Angeles | 37 | 11301 | 64375 | |
594416 | 594416 | City of Monterey Park | Monterey Park | 2021-09-14 | Los Angeles | 37 | 5447 | 62262 | |
594417 | 594417 | City of Norwalk | Norwalk | 2021-09-14 | Los Angeles | 37 | 18156 | 107622 | |
594418 | 594418 | City of Palmdale | Palmdale | 2021-09-14 | Los Angeles | 37 | 28535 | 158968 | |
594419 | 594419 | City of Palos Verdes Estates | Palos Verdes Estates | 2021-09-14 | Los Angeles | 37 | 636 | 13522 | |
594420 | 594420 | City of Paramount | Paramount | 2021-09-14 | Los Angeles | 37 | 11133 | 56023 | |
594421 | 594421 | City of Pico Rivera | Pico Rivera | 2021-09-14 | Los Angeles | 37 | 12317 | 64284 |
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 );