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 236,510
- 73 72,160
- 65 42,176
- 71 41,984
- 1 36,358
- 29 30,900
- 59 27,019
- 61 21,984
- 97 21,920
- 19 20,512
- 41 19,928
- 13 19,440
- 81 18,510
- 107 18,340
- 75 17,420
- 53 15,957
- 111 15,825
- 79 14,674
- 55 11,430
- 25 10,710
- 57 9,707
- 85 9,690
- 83 7,260
- 33 6,795
- 47 6,640
- 99 6,490
- 31 5,679
- 67 5,216
- 17 5,144
- 95 5,136
- 9 4,824
- 5 4,396
- 113 3,260
- 7 3,150
- 45 3,140
- 39 2,725
- 115 2,725
- 51 1,995
- 105 1,992
- 93 1,812
- 101 1,635
county 41
- Los Angeles 236,510
- San Diego 72,160
- Riverside 42,176
- San Bernardino 41,984
- Alameda 36,358
- Kern 30,900
- Orange 27,019
- Placer 21,984
- Sonoma 21,920
- Fresno 20,512
- Marin 19,928
- Contra Costa 19,440
- San Mateo 18,510
- Tulare 18,340
- San Francisco 17,420
- Monterey 15,957
- Ventura 15,825
- San Luis Obispo 14,674
- Napa 11,430
- Imperial 10,710
- Nevada 9,707
- Santa Clara 9,690
- Santa Barbara 7,260
- Lake 6,795
- Merced 6,640
- Stanislaus 6,490
- Kings 5,679
- Sacramento 5,216
- El Dorado 5,144
- Solano 5,136
- Calaveras 4,824
- Amador 4,396
- Yolo 3,260
- Butte 3,150
- Mendocino 3,140
- Madera 2,725
- Yuba 2,725
- Mono 1,995
- Trinity 1,992
- Siskiyou 1,812
- Sutter 1,635
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
438629 | 438629 | Auberry | Auberry | 2022-01-14 | Fresno | 19 | 242 | 3994 | |
438630 | 438630 | Biola | Biola | 2022-01-14 | Fresno | 19 | 274 | 949 | |
438631 | 438631 | Cantua Creek | Cantua Creek | 2022-01-14 | Fresno | 19 | 189 | 1125 | |
438632 | 438632 | Caruthers | Caruthers | 2022-01-14 | Fresno | 19 | 1042 | 5887 | |
438633 | 438633 | Clovis | Clovis | 2022-01-14 | Fresno | 19 | 14480 | 122949 | |
438634 | 438634 | Coalinga | Coalinga | 2022-01-14 | Fresno | 19 | 4672 | 19345 | |
438635 | 438635 | Del Rey | Del Rey | 2022-01-14 | Fresno | 19 | 449 | 2759 | |
438636 | 438636 | Dinuba | Dinuba | 2022-01-14 | Fresno | 19 | 0 | 0 | |
438637 | 438637 | Dos Palos | Dos Palos | 2022-01-14 | Fresno | 19 | 0 | ||
438638 | 438638 | Dunlap | Dunlap | 2022-01-14 | Fresno | 19 | 6 | ||
438639 | 438639 | Firebaugh | Firebaugh | 2022-01-14 | Fresno | 19 | 1527 | 9965 | |
438640 | 438640 | Five Points | Five Points | 2022-01-14 | Fresno | 19 | 23 | 0 | |
438641 | 438641 | Fowler | Fowler | 2022-01-14 | Fresno | 19 | 1548 | 7917 | |
438642 | 438642 | Fresno | Fresno | 2022-01-14 | Fresno | 19 | 61638 | 608579 | |
438643 | 438643 | Friant | Friant | 2022-01-14 | Fresno | 19 | 148 | 1930 | |
438644 | 438644 | Huron | Huron | 2022-01-14 | Fresno | 19 | 1088 | 7579 | |
438645 | 438645 | Kerman | Kerman | 2022-01-14 | Fresno | 19 | 3617 | 21009 | |
438646 | 438646 | Kingsburg | Kingsburg | 2022-01-14 | Fresno | 19 | 2120 | 17086 | |
438647 | 438647 | Laton | Laton | 2022-01-14 | Fresno | 19 | 554 | 3513 | |
438648 | 438648 | Mendota | Mendota | 2022-01-14 | Fresno | 19 | 2222 | 13576 | |
438649 | 438649 | Orange Cove | Orange Cove | 2022-01-14 | Fresno | 19 | 2238 | 11320 | |
438650 | 438650 | Parlier | Parlier | 2022-01-14 | Fresno | 19 | 3569 | 17097 | |
438651 | 438651 | Prather | Prather | 2022-01-14 | Fresno | 19 | 120 | 0 | |
438652 | 438652 | Raisin | Raisin | 2022-01-14 | Fresno | 19 | 94 | 380 | |
438653 | 438653 | Reedley | Reedley | 2022-01-14 | Fresno | 19 | 5204 | 31129 | |
438654 | 438654 | Riverdale | Riverdale | 2022-01-14 | Fresno | 19 | 1129 | 6459 | |
438655 | 438655 | San Joaquin | San Joaquin | 2022-01-14 | Fresno | 19 | 754 | 4633 | |
438656 | 438656 | Sanger | Sanger | 2022-01-14 | Fresno | 19 | 6894 | 38252 | |
438657 | 438657 | Selma | Selma | 2022-01-14 | Fresno | 19 | 6307 | 31726 | |
438658 | 438658 | Squaw Valley | Squaw Valley | 2022-01-14 | Fresno | 19 | 231 | 3908 | |
438659 | 438659 | Tollhouse | Tollhouse | 2022-01-14 | Fresno | 19 | 164 | 2712 | |
438660 | 438660 | Tranquillity | Tranquillity | 2022-01-14 | Fresno | 19 | 167 | 1132 | |
438661 | 438661 | 92222 | 92222: Bard | 2022-01-14 | Imperial | 25 | 11 | 0 | |
438662 | 438662 | 92227 | 92227: Brawley | 2022-01-14 | Imperial | 25 | 6648 | 27255 | |
438663 | 438663 | 92231 | 92231: Calexico | 2022-01-14 | Imperial | 25 | 10231 | 40019 | |
438664 | 438664 | 92233 | 92233: Calipatria | 2022-01-14 | Imperial | 25 | 782 | 7618 | |
438665 | 438665 | 92243 | 92243: El Centro | 2022-01-14 | Imperial | 25 | 10434 | 50484 | |
438666 | 438666 | 92244 | 92244: El Centro | 2022-01-14 | Imperial | 25 | 145 | 0 | |
438667 | 438667 | 92249 | 92249: Heber | 2022-01-14 | Imperial | 25 | 1570 | 7898 | |
438668 | 438668 | 92250 | 92250: Holtville | 2022-01-14 | Imperial | 25 | 1509 | 8979 | |
438669 | 438669 | 92251 | 92251: Imperial | 2022-01-14 | Imperial | 25 | 4677 | 23388 | |
438670 | 438670 | 92257 | 92257: Niland | 2022-01-14 | Imperial | 25 | 228 | 1332 | |
438671 | 438671 | 92259 | 92259: Ocotillo | 2022-01-14 | Imperial | 25 | 21 | 94 | |
438672 | 438672 | 92266 | 92266: Palo Verde | 2022-01-14 | Imperial | 25 | 10 | 108 | |
438673 | 438673 | 92273 | 92273: Seeley | 2022-01-14 | Imperial | 25 | 305 | 1704 | |
438674 | 438674 | 92274 | 92274: Thermal | 2022-01-14 | Imperial | 25 | 779 | 15118 | |
438675 | 438675 | 92275 | 92275: Salton City | 2022-01-14 | Imperial | 25 | 48 | 2456 | |
438676 | 438676 | 92281 | 92281: Westmorland | 2022-01-14 | Imperial | 25 | 424 | 2859 | |
438677 | 438677 | 92283 | 92283: Winterhaven | 2022-01-14 | Imperial | 25 | 552 | 1694 | |
438678 | 438678 | 93226 | 93226: Glennville | 2022-01-14 | Kern | 29 | 32 | 195 | |
438679 | 438679 | 93238 | 93238: Kernville | 2022-01-14 | Kern | 29 | 160 | 1408 | |
438680 | 438680 | 93240 | 93240: Lake Isabella | 2022-01-14 | Kern | 29 | 771 | 6960 | |
438681 | 438681 | 93241 | 93241: Lamont | 2022-01-14 | Kern | 29 | 3308 | 16969 | |
438682 | 438682 | 93243 | 93243: Lebec | 2022-01-14 | Kern | 29 | 178 | 1709 | |
438683 | 438683 | 93249 | 93249: Lost Hills | 2022-01-14 | Kern | 29 | 401 | 2264 | |
438684 | 438684 | 93250 | 93250: Mc Farland | 2022-01-14 | Kern | 29 | 3376 | 15523 | |
438685 | 438685 | 93251 | 93251: Mc Kittrick | 2022-01-14 | Kern | 29 | 32 | 243 | |
438686 | 438686 | 93252 | 93252: Maricopa | 2022-01-14 | Kern | 29 | 198 | 3188 | |
438687 | 438687 | 93255 | 93255: Onyx | 2022-01-14 | Kern | 29 | 33 | 707 | |
438688 | 438688 | 93263 | 93263: Shafter | 2022-01-14 | Kern | 29 | 5199 | 20710 | |
438689 | 438689 | 93268 | 93268: Taft | 2022-01-14 | Kern | 29 | 3236 | 17620 | |
438690 | 438690 | 93276 | 93276: Tupman | 2022-01-14 | Kern | 29 | 41 | 159 | |
438691 | 438691 | 93280 | 93280: Wasco | 2022-01-14 | Kern | 29 | 7827 | 27552 | |
438692 | 438692 | 93283 | 93283: Weldon | 2022-01-14 | Kern | 29 | 183 | 2086 | |
438693 | 438693 | 93285 | 93285: Wofford Heights | 2022-01-14 | Kern | 29 | 216 | 1723 | |
438694 | 438694 | 93287 | 93287: Woody | 2022-01-14 | Kern | 29 | 22 | 74 | |
438695 | 438695 | 93301 | 93301: Bakersfield | 2022-01-14 | Kern | 29 | 3175 | 12345 | |
438696 | 438696 | 93304 | 93304: Bakersfield | 2022-01-14 | Kern | 29 | 10603 | 50787 | |
438697 | 438697 | 93305 | 93305: Bakersfield | 2022-01-14 | Kern | 29 | 7459 | 39114 | |
438698 | 438698 | 93306 | 93306: Bakersfield | 2022-01-14 | Kern | 29 | 15258 | 70208 | |
438699 | 438699 | 93307 | 93307: Bakersfield | 2022-01-14 | Kern | 29 | 18919 | 84948 | |
438700 | 438700 | 93308 | 93308: Bakersfield | 2022-01-14 | Kern | 29 | 9509 | 54042 | |
438701 | 438701 | 93309 | 93309: Bakersfield | 2022-01-14 | Kern | 29 | 11829 | 60893 | |
438702 | 438702 | 93311 | 93311: Bakersfield | 2022-01-14 | Kern | 29 | 9223 | 44862 | |
438703 | 438703 | 93312 | 93312: Bakersfield | 2022-01-14 | Kern | 29 | 11086 | 59359 | |
438704 | 438704 | 93313 | 93313: Bakersfield | 2022-01-14 | Kern | 29 | 12435 | 51245 | |
438705 | 438705 | 93314 | 93314: Bakersfield | 2022-01-14 | Kern | 29 | 6283 | 26992 | |
438706 | 438706 | 93501 | 93501: Mojave | 2022-01-14 | Kern | 29 | 809 | 5063 | |
438707 | 438707 | 93505 | 93505: California City | 2022-01-14 | Kern | 29 | 2676 | 13445 | |
438708 | 438708 | 93516 | 93516: Boron | 2022-01-14 | Kern | 29 | 326 | 2425 | |
438709 | 438709 | 93518 | 93518: Caliente | 2022-01-14 | Kern | 29 | 67 | 995 | |
438710 | 438710 | 93519 | 93519: Cantil | 2022-01-14 | Kern | 29 | 1 | 28 | |
438711 | 438711 | 93523 | 93523: Edwards | 2022-01-14 | Kern | 29 | 277 | 3312 | |
438712 | 438712 | 93524 | 93524: Edwards | 2022-01-14 | Kern | 29 | 46 | 168 | |
438713 | 438713 | 93203 | 93203: Arvin | 2022-01-14 | Kern | 29 | 4445 | 22471 | |
438714 | 438714 | 93205 | 93205: Bodfish | 2022-01-14 | Kern | 29 | 241 | 1593 | |
438715 | 438715 | 93206 | 93206: Buttonwillow | 2022-01-14 | Kern | 29 | 392 | 2044 | |
438716 | 438716 | 93215 | 93215: Delano | 2022-01-14 | Kern | 29 | 12897 | 55845 | |
438717 | 438717 | 93220 | 93220: Edison | 2022-01-14 | Kern | 29 | 24 | 313 | |
438718 | 438718 | 93222 | 93222: Pine Mountain Club | 2022-01-14 | Kern | 29 | 104 | 1420 | |
438719 | 438719 | 93224 | 93224: Fellows | 2022-01-14 | Kern | 29 | 86 | 402 | |
438720 | 438720 | 93225 | 93225: Frazier Park | 2022-01-14 | Kern | 29 | 526 | 5319 | |
438721 | 438721 | 93527 | 93527: Inyokern | 2022-01-14 | Kern | 29 | 214 | 1852 | |
438722 | 438722 | 93528 | 93528: Johannesburg | 2022-01-14 | Kern | 29 | 10 | 124 | |
438723 | 438723 | 93531 | 93531: Keene | 2022-01-14 | Kern | 29 | 53 | 422 | |
438724 | 438724 | 93554 | 93554: Randsburg | 2022-01-14 | Kern | 29 | 10 | 143 | |
438725 | 438725 | 93555 | 93555: Ridgecrest | 2022-01-14 | Kern | 29 | 4420 | 34075 | |
438726 | 438726 | 93560 | 93560: Rosamond | 2022-01-14 | Kern | 29 | 3909 | 20797 | |
438727 | 438727 | 93561 | 93561: Tehachapi | 2022-01-14 | Kern | 29 | 6745 | 34271 | |
438728 | 438728 | Armona | Armona | 2022-01-14 | Kings | 31 | 1014 | 3795 |
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 );