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 41
- 37 160,968
- 73 48,620
- 65 28,480
- 71 28,288
- 1 25,016
- 29 20,164
- 59 18,245
- 61 15,136
- 97 15,072
- 19 13,632
- 13 13,020
- 107 12,348
- 81 12,090
- 75 11,856
- 111 10,475
- 53 10,179
- 79 9,966
- 41 8,586
- 55 7,578
- 25 7,055
- 85 6,480
- 57 6,069
- 83 4,906
- 47 4,500
- 99 4,350
- 31 3,753
- 33 3,585
- 67 3,504
- 17 3,496
- 95 3,424
- 5 2,912
- 9 2,256
- 113 2,190
- 7 2,080
- 45 2,070
- 39 1,655
- 115 1,655
- 51 1,353
- 105 1,136
- 101 993
- 93 956
county 41
- Los Angeles 160,968
- San Diego 48,620
- Riverside 28,480
- San Bernardino 28,288
- Alameda 25,016
- Kern 20,164
- Orange 18,245
- Placer 15,136
- Sonoma 15,072
- Fresno 13,632
- Contra Costa 13,020
- Tulare 12,348
- San Mateo 12,090
- San Francisco 11,856
- Ventura 10,475
- Monterey 10,179
- San Luis Obispo 9,966
- Marin 8,586
- Napa 7,578
- Imperial 7,055
- Santa Clara 6,480
- Nevada 6,069
- Santa Barbara 4,906
- Merced 4,500
- Stanislaus 4,350
- Kings 3,753
- Lake 3,585
- Sacramento 3,504
- El Dorado 3,496
- Solano 3,424
- Amador 2,912
- Calaveras 2,256
- Yolo 2,190
- Butte 2,080
- Mendocino 2,070
- Madera 1,655
- Yuba 1,655
- Mono 1,353
- Trinity 1,136
- Sutter 993
- Siskiyou 956
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
711700 | 711700 | 93205 | 93205: Bodfish | 2021-06-14 | Kern | 29 | 79 | 1593 | |
711701 | 711701 | 93206 | 93206: Buttonwillow | 2021-06-14 | Kern | 29 | 283 | 2044 | |
711702 | 711702 | 93215 | 93215: Delano | 2021-06-14 | Kern | 29 | 8675 | 55845 | |
711703 | 711703 | 93220 | 93220: Edison | 2021-06-14 | Kern | 29 | 18 | 313 | |
711704 | 711704 | 93222 | 93222: Pine Mountain Club | 2021-06-14 | Kern | 29 | 51 | 1420 | |
711705 | 711705 | 93224 | 93224: Fellows | 2021-06-14 | Kern | 29 | 40 | 402 | |
711706 | 711706 | 93225 | 93225: Frazier Park | 2021-06-14 | Kern | 29 | 253 | 5319 | |
711707 | 711707 | 93527 | 93527: Inyokern | 2021-06-14 | Kern | 29 | 91 | 1852 | |
711708 | 711708 | 93528 | 93528: Johannesburg | 2021-06-14 | Kern | 29 | 4 | 124 | |
711709 | 711709 | 93531 | 93531: Keene | 2021-06-14 | Kern | 29 | 28 | 422 | |
711710 | 711710 | 93554 | 93554: Randsburg | 2021-06-14 | Kern | 29 | 9 | 143 | |
711711 | 711711 | 93555 | 93555: Ridgecrest | 2021-06-14 | Kern | 29 | 2244 | 34075 | |
711712 | 711712 | 93560 | 93560: Rosamond | 2021-06-14 | Kern | 29 | 2200 | 20797 | |
711713 | 711713 | 93561 | 93561: Tehachapi | 2021-06-14 | Kern | 29 | 3902 | 34271 | |
711714 | 711714 | Armona | Armona | 2021-06-14 | Kings | 31 | 601 | 3795 | |
711715 | 711715 | Avenal | Avenal | 2021-06-14 | Kings | 31 | 1260 | 12923 | |
711716 | 711716 | Corcoran | Corcoran | 2021-06-14 | Kings | 31 | 2006 | 22301 | |
711717 | 711717 | Correctional facilities | Prisons | 2021-06-14 | Kings | 31 | 7209 | ||
711718 | 711718 | Hanford | Hanford | 2021-06-14 | Kings | 31 | 7935 | 55893 | |
711719 | 711719 | Kettleman City | Kettleman City | 2021-06-14 | Kings | 31 | 167 | 1395 | |
711720 | 711720 | Lemoore | Lemoore | 2021-06-14 | Kings | 31 | 3649 | 25791 | |
711721 | 711721 | Other Area | Other | 2021-06-14 | Kings | 31 | 207 | ||
711722 | 711722 | Stratford | Stratford | 2021-06-14 | Kings | 31 | 136 | 878 | |
711723 | 711723 | 95422 | 95422 | 2021-06-14 | Lake | 33 | 942 | 15550 | |
711724 | 711724 | 95423 | 95423 | 2021-06-14 | Lake | 33 | 140 | 3757 | |
711725 | 711725 | 95424 | 95424 | 2021-06-14 | Lake | 33 | 14 | 0 | |
711726 | 711726 | 95426 | 95426 | 2021-06-14 | Lake | 33 | 35 | 1404 | |
711727 | 711727 | 95435 | 95435 | 2021-06-14 | Lake | 33 | 37 | 14 | |
711728 | 711728 | 95443 | 95443 | 2021-06-14 | Lake | 33 | 2 | 270 | |
711729 | 711729 | 95451 | 95451 | 2021-06-14 | Lake | 33 | 690 | 11627 | |
711730 | 711730 | 95453 | 95453 | 2021-06-14 | Lake | 33 | 789 | 11092 | |
711731 | 711731 | 95457 | 95457 | 2021-06-14 | Lake | 33 | 162 | 3330 | |
711732 | 711732 | 95458 | 95458 | 2021-06-14 | Lake | 33 | 111 | 3019 | |
711733 | 711733 | 95461 | 95461 | 2021-06-14 | Lake | 33 | 107 | 2440 | |
711734 | 711734 | 95464 | 95464 | 2021-06-14 | Lake | 33 | 130 | 2538 | |
711735 | 711735 | 95467 | 95467 | 2021-06-14 | Lake | 33 | 202 | 6044 | |
711736 | 711736 | 95485 | 95485 | 2021-06-14 | Lake | 33 | 109 | 2688 | |
711737 | 711737 | 95493 | 95493 | 2021-06-14 | Lake | 33 | 7 | 241 | |
711738 | 711738 | 90802 | 90802: Long Beach | 2021-06-14 | Los Angeles | 37 | 3895 | 39453 | |
711739 | 711739 | 90803 | 90803: Long Beach | 2021-06-14 | Los Angeles | 37 | 1896 | 32389 | |
711740 | 711740 | 90804 | 90804: Long Beach | 2021-06-14 | Los Angeles | 37 | 4580 | 39344 | |
711741 | 711741 | 90805 | 90805: Long Beach | 2021-06-14 | Los Angeles | 37 | 13594 | 96708 | |
711742 | 711742 | 90806 | 90806: Long Beach | 2021-06-14 | Los Angeles | 37 | 6240 | 42817 | |
711743 | 711743 | 90807 | 90807: Long Beach | 2021-06-14 | Los Angeles | 37 | 3014 | 32067 | |
711744 | 711744 | 90808 | 90808: Long Beach | 2021-06-14 | Los Angeles | 37 | 2648 | 38860 | |
711745 | 711745 | 90810 | 90810: Long Beach | 2021-06-14 | Los Angeles | 37 | 4563 | 38579 | |
711746 | 711746 | 90813 | 90813: Long Beach | 2021-06-14 | Los Angeles | 37 | 8001 | 59000 | |
711747 | 711747 | 90814 | 90814: Long Beach | 2021-06-14 | Los Angeles | 37 | 1322 | 18587 | |
711748 | 711748 | 90815 | 90815: Long Beach | 2021-06-14 | Los Angeles | 37 | 2863 | 41026 | |
711749 | 711749 | 91101 | 91101: Pasadena | 2021-06-14 | Los Angeles | 37 | 1409 | 20719 | |
711750 | 711750 | 91103 | 91103: Pasadena | 2021-06-14 | Los Angeles | 37 | 3641 | 28435 | |
711751 | 711751 | 91104 | 91104: Pasadena | 2021-06-14 | Los Angeles | 37 | 2552 | 39178 | |
711752 | 711752 | 91105 | 91105: Pasadena | 2021-06-14 | Los Angeles | 37 | 718 | 11907 | |
711753 | 711753 | 91106 | 91106: Pasadena | 2021-06-14 | Los Angeles | 37 | 1602 | 25479 | |
711754 | 711754 | 91107 | 91107: Pasadena | 2021-06-14 | Los Angeles | 37 | 1321 | 321 | |
711755 | 711755 | City of Agoura Hills | Agoura Hills | 2021-06-14 | Los Angeles | 37 | 1057 | 20883 | |
711756 | 711756 | City of Alhambra | Alhambra | 2021-06-14 | Los Angeles | 37 | 6897 | 86724 | |
711757 | 711757 | City of Arcadia | Arcadia | 2021-06-14 | Los Angeles | 37 | 2737 | 57754 | |
711758 | 711758 | City of Artesia | Artesia | 2021-06-14 | Los Angeles | 37 | 2077 | 16795 | |
711759 | 711759 | City of Avalon | Avalon | 2021-06-14 | Los Angeles | 37 | 16 | 3869 | |
711760 | 711760 | City of Azusa | Azusa | 2021-06-14 | Los Angeles | 37 | 6330 | 50040 | |
711761 | 711761 | City of Baldwin Park | Baldwin Park | 2021-06-14 | Los Angeles | 37 | 13168 | 76769 | |
711762 | 711762 | City of Bell | Bell | 2021-06-14 | Los Angeles | 37 | 6803 | 36332 | |
711763 | 711763 | City of Bell Gardens | Bell Gardens | 2021-06-14 | Los Angeles | 37 | 8394 | 43071 | |
711764 | 711764 | City of Bellflower | Bellflower | 2021-06-14 | Los Angeles | 37 | 10820 | 77735 | |
711765 | 711765 | City of Beverly Hills | Beverly Hills | 2021-06-14 | Los Angeles | 37 | 2695 | 34520 | |
711766 | 711766 | City of Bradbury | Bradbury | 2021-06-14 | Los Angeles | 37 | 38 | 1069 | |
711767 | 711767 | City of Burbank | Burbank | 2021-06-14 | Los Angeles | 37 | 8979 | 107180 | |
711768 | 711768 | City of Calabasas | Calabasas | 2021-06-14 | Los Angeles | 37 | 1291 | 24323 | |
711769 | 711769 | City of Carson | Carson | 2021-06-14 | Los Angeles | 37 | 9890 | 93846 | |
711770 | 711770 | City of Cerritos | Cerritos | 2021-06-14 | Los Angeles | 37 | 3082 | 50067 | |
711771 | 711771 | City of Claremont | Claremont | 2021-06-14 | Los Angeles | 37 | 2287 | 36484 | |
711772 | 711772 | City of Commerce | Commerce | 2021-06-14 | Los Angeles | 37 | 2401 | 13069 | |
711773 | 711773 | City of Compton | Compton | 2021-06-14 | Los Angeles | 37 | 17161 | 99904 | |
711774 | 711774 | City of Covina | Covina | 2021-06-14 | Los Angeles | 37 | 6403 | 49032 | |
711775 | 711775 | City of Cudahy | Cudahy | 2021-06-14 | Los Angeles | 37 | 4811 | 24347 | |
711776 | 711776 | City of Culver City | Culver City | 2021-06-14 | Los Angeles | 37 | 2235 | 39865 | |
711777 | 711777 | City of Diamond Bar | Diamond Bar | 2021-06-14 | Los Angeles | 37 | 3271 | 57515 | |
711778 | 711778 | City of Downey | Downey | 2021-06-14 | Los Angeles | 37 | 17612 | 114263 | |
711779 | 711779 | City of Duarte | Duarte | 2021-06-14 | Los Angeles | 37 | 2322 | 22016 | |
711780 | 711780 | City of El Monte | El Monte | 2021-06-14 | Los Angeles | 37 | 17229 | 117269 | |
711781 | 711781 | City of El Segundo | El Segundo | 2021-06-14 | Los Angeles | 37 | 741 | 16786 | |
711782 | 711782 | City of Gardena | Gardena | 2021-06-14 | Los Angeles | 37 | 6408 | 61310 | |
711783 | 711783 | City of Glendale | Glendale | 2021-06-14 | Los Angeles | 37 | 20218 | 206493 | |
711784 | 711784 | City of Glendora | Glendora | 2021-06-14 | Los Angeles | 37 | 4851 | 52764 | |
711785 | 711785 | City of Hawaiian Gardens | Hawaiian Gardens | 2021-06-14 | Los Angeles | 37 | 2242 | 14676 | |
711786 | 711786 | City of Hawthorne | Hawthorne | 2021-06-14 | Los Angeles | 37 | 10614 | 88787 | |
711787 | 711787 | City of Hermosa Beach | Hermosa Beach | 2021-06-14 | Los Angeles | 37 | 1019 | 19670 | |
711788 | 711788 | City of Hidden Hills | Hidden Hills | 2021-06-14 | Los Angeles | 37 | 91 | 1890 | |
711789 | 711789 | City of Huntington Park | Huntington Park | 2021-06-14 | Los Angeles | 37 | 11270 | 59484 | |
711790 | 711790 | City of Industry | Industry | 2021-06-14 | Los Angeles | 37 | 173 | 437 | |
711791 | 711791 | City of Inglewood | Inglewood | 2021-06-14 | Los Angeles | 37 | 13718 | 113582 | |
711792 | 711792 | City of Irwindale | Irwindale | 2021-06-14 | Los Angeles | 37 | 253 | 1459 | |
711793 | 711793 | City of La Canada Flintridge | La Canada Flintridge | 2021-06-14 | Los Angeles | 37 | 770 | 20693 | |
711794 | 711794 | City of La Habra Heights | La Habra Heights | 2021-06-14 | Los Angeles | 37 | 116 | 5455 | |
711795 | 711795 | City of La Mirada | La Mirada | 2021-06-14 | Los Angeles | 37 | 4310 | 49599 | |
711796 | 711796 | City of La Puente | La Puente | 2021-06-14 | Los Angeles | 37 | 6710 | 40697 | |
711797 | 711797 | City of La Verne | La Verne | 2021-06-14 | Los Angeles | 37 | 2907 | 33282 | |
711798 | 711798 | City of Lakewood | Lakewood | 2021-06-14 | Los Angeles | 37 | 7348 | 80362 | |
711799 | 711799 | City of Lancaster | Lancaster | 2021-06-14 | Los Angeles | 37 | 22347 | 161570 |
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 );