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 214,977
- San Diego 65,450
- Riverside 38,272
- San Bernardino 38,080
- Alameda 33,125
- Kern 27,800
- Orange 24,518
- Placer 20,032
- Sonoma 19,968
- Fresno 18,528
- Contra Costa 17,610
- Marin 16,695
- San Mateo 16,680
- Tulare 16,632
- San Francisco 15,834
- Monterey 14,310
- Ventura 14,300
- San Luis Obispo 13,332
- Napa 10,332
- Imperial 9,656
- Santa Clara 8,775
- Nevada 8,670
- Santa Barbara 6,589
- Merced 6,030
- Lake 5,880
- Stanislaus 5,880
- Kings 5,129
- Sacramento 4,728
- El Dorado 4,720
- Solano 4,648
- …
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
516487 | 516487 | Avenal | Avenal | 2021-11-14 | Kings | 31 | 1691 | 12923 | |
516488 | 516488 | Corcoran | Corcoran | 2021-11-14 | Kings | 31 | 2831 | 22301 | |
516489 | 516489 | Correctional facilities | Prisons | 2021-11-14 | Kings | 31 | 7432 | ||
516490 | 516490 | Hanford | Hanford | 2021-11-14 | Kings | 31 | 12573 | 55893 | |
516491 | 516491 | Kettleman City | Kettleman City | 2021-11-14 | Kings | 31 | 234 | 1395 | |
516492 | 516492 | Lemoore | Lemoore | 2021-11-14 | Kings | 31 | 5841 | 25791 | |
516493 | 516493 | Other Area | Other | 2021-11-14 | Kings | 31 | 342 | ||
516494 | 516494 | Stratford | Stratford | 2021-11-14 | Kings | 31 | 277 | 878 | |
516495 | 516495 | 95422 | 95422 | 2021-11-14 | Lake | 33 | 1627 | 15550 | |
516496 | 516496 | 95423 | 95423 | 2021-11-14 | Lake | 33 | 256 | 3757 | |
516497 | 516497 | 95424 | 95424 | 2021-11-14 | Lake | 33 | 20 | 0 | |
516498 | 516498 | 95426 | 95426 | 2021-11-14 | Lake | 33 | 62 | 1404 | |
516499 | 516499 | 95435 | 95435 | 2021-11-14 | Lake | 33 | 46 | 14 | |
516500 | 516500 | 95443 | 95443 | 2021-11-14 | Lake | 33 | 10 | 270 | |
516501 | 516501 | 95451 | 95451 | 2021-11-14 | Lake | 33 | 1088 | 11627 | |
516502 | 516502 | 95453 | 95453 | 2021-11-14 | Lake | 33 | 1388 | 11092 | |
516503 | 516503 | 95457 | 95457 | 2021-11-14 | Lake | 33 | 261 | 3330 | |
516504 | 516504 | 95458 | 95458 | 2021-11-14 | Lake | 33 | 271 | 3019 | |
516505 | 516505 | 95461 | 95461 | 2021-11-14 | Lake | 33 | 166 | 2440 | |
516506 | 516506 | 95464 | 95464 | 2021-11-14 | Lake | 33 | 261 | 2538 | |
516507 | 516507 | 95467 | 95467 | 2021-11-14 | Lake | 33 | 344 | 6044 | |
516508 | 516508 | 95485 | 95485 | 2021-11-14 | Lake | 33 | 291 | 2688 | |
516509 | 516509 | 95493 | 95493 | 2021-11-14 | Lake | 33 | 11 | 241 | |
516510 | 516510 | 90802 | 90802: Long Beach | 2021-11-14 | Los Angeles | 37 | 5004 | 39453 | |
516511 | 516511 | 90803 | 90803: Long Beach | 2021-11-14 | Los Angeles | 37 | 2608 | 32389 | |
516512 | 516512 | 90804 | 90804: Long Beach | 2021-11-14 | Los Angeles | 37 | 5685 | 39344 | |
516513 | 516513 | 90805 | 90805: Long Beach | 2021-11-14 | Los Angeles | 37 | 16443 | 96708 | |
516514 | 516514 | 90806 | 90806: Long Beach | 2021-11-14 | Los Angeles | 37 | 7506 | 42817 | |
516515 | 516515 | 90807 | 90807: Long Beach | 2021-11-14 | Los Angeles | 37 | 3767 | 32067 | |
516516 | 516516 | 90808 | 90808: Long Beach | 2021-11-14 | Los Angeles | 37 | 3698 | 38860 | |
516517 | 516517 | 90810 | 90810: Long Beach | 2021-11-14 | Los Angeles | 37 | 5385 | 38579 | |
516518 | 516518 | 90813 | 90813: Long Beach | 2021-11-14 | Los Angeles | 37 | 9445 | 59000 | |
516519 | 516519 | 90814 | 90814: Long Beach | 2021-11-14 | Los Angeles | 37 | 1822 | 18587 | |
516520 | 516520 | 90815 | 90815: Long Beach | 2021-11-14 | Los Angeles | 37 | 3898 | 41026 | |
516521 | 516521 | 91101 | 91101: Pasadena | 2021-11-14 | Los Angeles | 37 | 1740 | 20719 | |
516522 | 516522 | 91103 | 91103: Pasadena | 2021-11-14 | Los Angeles | 37 | 4157 | 28435 | |
516523 | 516523 | 91104 | 91104: Pasadena | 2021-11-14 | Los Angeles | 37 | 3111 | 39178 | |
516524 | 516524 | 91105 | 91105: Pasadena | 2021-11-14 | Los Angeles | 37 | 910 | 11907 | |
516525 | 516525 | 91106 | 91106: Pasadena | 2021-11-14 | Los Angeles | 37 | 1982 | 25479 | |
516526 | 516526 | 91107 | 91107: Pasadena | 2021-11-14 | Los Angeles | 37 | 1722 | 321 | |
516527 | 516527 | City of Agoura Hills | Agoura Hills | 2021-11-14 | Los Angeles | 37 | 1500 | 20883 | |
516528 | 516528 | City of Alhambra | Alhambra | 2021-11-14 | Los Angeles | 37 | 8379 | 86724 | |
516529 | 516529 | City of Arcadia | Arcadia | 2021-11-14 | Los Angeles | 37 | 3471 | 57754 | |
516530 | 516530 | City of Artesia | Artesia | 2021-11-14 | Los Angeles | 37 | 2467 | 16795 | |
516531 | 516531 | City of Avalon | Avalon | 2021-11-14 | Los Angeles | 37 | 32 | 3869 | |
516532 | 516532 | City of Azusa | Azusa | 2021-11-14 | Los Angeles | 37 | 7567 | 50040 | |
516533 | 516533 | City of Baldwin Park | Baldwin Park | 2021-11-14 | Los Angeles | 37 | 14837 | 76769 | |
516534 | 516534 | City of Bell | Bell | 2021-11-14 | Los Angeles | 37 | 7658 | 36332 | |
516535 | 516535 | City of Bell Gardens | Bell Gardens | 2021-11-14 | Los Angeles | 37 | 9161 | 43071 | |
516536 | 516536 | City of Bellflower | Bellflower | 2021-11-14 | Los Angeles | 37 | 13200 | 77735 | |
516537 | 516537 | City of Beverly Hills | Beverly Hills | 2021-11-14 | Los Angeles | 37 | 3706 | 34520 | |
516538 | 516538 | City of Bradbury | Bradbury | 2021-11-14 | Los Angeles | 37 | 42 | 1069 | |
516539 | 516539 | City of Burbank | Burbank | 2021-11-14 | Los Angeles | 37 | 11532 | 107180 | |
516540 | 516540 | City of Calabasas | Calabasas | 2021-11-14 | Los Angeles | 37 | 1857 | 24323 | |
516541 | 516541 | City of Carson | Carson | 2021-11-14 | Los Angeles | 37 | 12355 | 93846 | |
516542 | 516542 | City of Cerritos | Cerritos | 2021-11-14 | Los Angeles | 37 | 3877 | 50067 | |
516543 | 516543 | City of Claremont | Claremont | 2021-11-14 | Los Angeles | 37 | 2944 | 36484 | |
516544 | 516544 | City of Commerce | Commerce | 2021-11-14 | Los Angeles | 37 | 2729 | 13069 | |
516545 | 516545 | City of Compton | Compton | 2021-11-14 | Los Angeles | 37 | 19891 | 99904 | |
516546 | 516546 | City of Covina | Covina | 2021-11-14 | Los Angeles | 37 | 7862 | 49032 | |
516547 | 516547 | City of Cudahy | Cudahy | 2021-11-14 | Los Angeles | 37 | 5431 | 24347 | |
516548 | 516548 | City of Culver City | Culver City | 2021-11-14 | Los Angeles | 37 | 3026 | 39865 | |
516549 | 516549 | City of Diamond Bar | Diamond Bar | 2021-11-14 | Los Angeles | 37 | 4105 | 57515 | |
516550 | 516550 | City of Downey | Downey | 2021-11-14 | Los Angeles | 37 | 20880 | 114263 | |
516551 | 516551 | City of Duarte | Duarte | 2021-11-14 | Los Angeles | 37 | 2818 | 22016 | |
516552 | 516552 | City of El Monte | El Monte | 2021-11-14 | Los Angeles | 37 | 19332 | 117269 | |
516553 | 516553 | City of El Segundo | El Segundo | 2021-11-14 | Los Angeles | 37 | 1117 | 16786 | |
516554 | 516554 | City of Gardena | Gardena | 2021-11-14 | Los Angeles | 37 | 8019 | 61310 | |
516555 | 516555 | City of Glendale | Glendale | 2021-11-14 | Los Angeles | 37 | 25402 | 206493 | |
516556 | 516556 | City of Glendora | Glendora | 2021-11-14 | Los Angeles | 37 | 6115 | 52764 | |
516557 | 516557 | City of Hawaiian Gardens | Hawaiian Gardens | 2021-11-14 | Los Angeles | 37 | 2613 | 14676 | |
516558 | 516558 | City of Hawthorne | Hawthorne | 2021-11-14 | Los Angeles | 37 | 12844 | 88787 | |
516559 | 516559 | City of Hermosa Beach | Hermosa Beach | 2021-11-14 | Los Angeles | 37 | 1633 | 19670 | |
516560 | 516560 | City of Hidden Hills | Hidden Hills | 2021-11-14 | Los Angeles | 37 | 136 | 1890 | |
516561 | 516561 | City of Huntington Park | Huntington Park | 2021-11-14 | Los Angeles | 37 | 12540 | 59484 | |
516562 | 516562 | City of Industry | Industry | 2021-11-14 | Los Angeles | 37 | 196 | 437 | |
516563 | 516563 | City of Inglewood | Inglewood | 2021-11-14 | Los Angeles | 37 | 17029 | 113582 | |
516564 | 516564 | City of Irwindale | Irwindale | 2021-11-14 | Los Angeles | 37 | 311 | 1459 | |
516565 | 516565 | City of La Canada Flintridge | La Canada Flintridge | 2021-11-14 | Los Angeles | 37 | 1144 | 20693 | |
516566 | 516566 | City of La Habra Heights | La Habra Heights | 2021-11-14 | Los Angeles | 37 | 130 | 5455 | |
516567 | 516567 | City of La Mirada | La Mirada | 2021-11-14 | Los Angeles | 37 | 5501 | 49599 | |
516568 | 516568 | City of La Puente | La Puente | 2021-11-14 | Los Angeles | 37 | 7599 | 40697 | |
516569 | 516569 | City of La Verne | La Verne | 2021-11-14 | Los Angeles | 37 | 3650 | 33282 | |
516570 | 516570 | City of Lakewood | Lakewood | 2021-11-14 | Los Angeles | 37 | 9616 | 80362 | |
516571 | 516571 | City of Lancaster | Lancaster | 2021-11-14 | Los Angeles | 37 | 29488 | 161570 | |
516572 | 516572 | City of Lawndale | Lawndale | 2021-11-14 | Los Angeles | 37 | 4358 | 33614 | |
516573 | 516573 | City of Lomita | Lomita | 2021-11-14 | Los Angeles | 37 | 1987 | 20729 | |
516574 | 516574 | City of Lynwood | Lynwood | 2021-11-14 | Los Angeles | 37 | 15167 | 72047 | |
516575 | 516575 | City of Malibu | Malibu | 2021-11-14 | Los Angeles | 37 | 701 | 12961 | |
516576 | 516576 | City of Manhattan Beach | Manhattan Beach | 2021-11-14 | Los Angeles | 37 | 2165 | 35999 | |
516577 | 516577 | City of Maywood | Maywood | 2021-11-14 | Los Angeles | 37 | 5848 | 28049 | |
516578 | 516578 | City of Monrovia | Monrovia | 2021-11-14 | Los Angeles | 37 | 4123 | 38800 | |
516579 | 516579 | City of Montebello | Montebello | 2021-11-14 | Los Angeles | 37 | 11699 | 64375 | |
516580 | 516580 | City of Monterey Park | Monterey Park | 2021-11-14 | Los Angeles | 37 | 5694 | 62262 | |
516581 | 516581 | City of Norwalk | Norwalk | 2021-11-14 | Los Angeles | 37 | 18823 | 107622 | |
516582 | 516582 | City of Palmdale | Palmdale | 2021-11-14 | Los Angeles | 37 | 30659 | 158968 | |
516583 | 516583 | City of Palos Verdes Estates | Palos Verdes Estates | 2021-11-14 | Los Angeles | 37 | 696 | 13522 | |
516584 | 516584 | City of Paramount | Paramount | 2021-11-14 | Los Angeles | 37 | 11539 | 56023 | |
516585 | 516585 | City of Pico Rivera | Pico Rivera | 2021-11-14 | Los Angeles | 37 | 12769 | 64284 | |
516586 | 516586 | City of Pomona | Pomona | 2021-11-14 | Los Angeles | 37 | 29875 | 155931 |
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 );