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 43
- 37 281,341
- 73 86,130
- 65 50,304
- 71 50,112
- 1 43,089
- 29 37,250
- 59 32,226
- 41 26,659
- 61 26,048
- 97 25,984
- 19 24,571
- 13 23,250
- 81 22,320
- 107 21,896
- 75 20,722
- 53 19,386
- 111 19,000
- 79 17,468
- 55 13,716
- 25 12,869
- 57 11,866
- 85 11,595
- 33 8,700
- 83 8,657
- 47 7,910
- 99 7,760
- 31 6,822
- 9 6,348
- 67 6,232
- 95 6,152
- 17 5,144
- 5 4,396
- 113 3,895
- 45 3,775
- 7 3,380
- 39 3,360
- 115 3,360
- 105 2,500
- 51 2,376
- 93 2,320
- 101 1,818
- 87 1,424
- 23 72
county 43
- Los Angeles 281,341
- San Diego 86,130
- Riverside 50,304
- San Bernardino 50,112
- Alameda 43,089
- Kern 37,250
- Orange 32,226
- Marin 26,659
- Placer 26,048
- Sonoma 25,984
- Fresno 24,571
- Contra Costa 23,250
- San Mateo 22,320
- Tulare 21,896
- San Francisco 20,722
- Monterey 19,386
- Ventura 19,000
- San Luis Obispo 17,468
- Napa 13,716
- Imperial 12,869
- Nevada 11,866
- Santa Clara 11,595
- Lake 8,700
- Santa Barbara 8,657
- Merced 7,910
- Stanislaus 7,760
- Kings 6,822
- Calaveras 6,348
- Sacramento 6,232
- Solano 6,152
- El Dorado 5,144
- Amador 4,396
- Yolo 3,895
- Mendocino 3,775
- Butte 3,380
- Madera 3,360
- Yuba 3,360
- Trinity 2,500
- Mono 2,376
- Siskiyou 2,320
- Sutter 1,818
- Santa Cruz 1,424
- Humboldt 72
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
277594 | 277594 | Coalinga | Coalinga | 2022-05-21 | Fresno | 19 | 5023 | 19345 | |
277595 | 277595 | Del Rey | Del Rey | 2022-05-21 | Fresno | 19 | 482 | 2759 | |
277596 | 277596 | Dinuba | Dinuba | 2022-05-21 | Fresno | 19 | 77 | 0 | |
277597 | 277597 | Dos Palos | Dos Palos | 2022-05-21 | Fresno | 19 | 0 | ||
277598 | 277598 | Dunlap | Dunlap | 2022-05-21 | Fresno | 19 | 6 | ||
277599 | 277599 | Firebaugh | Firebaugh | 2022-05-21 | Fresno | 19 | 1640 | 9965 | |
277600 | 277600 | Five Points | Five Points | 2022-05-21 | Fresno | 19 | 82 | 0 | |
277601 | 277601 | Fowler | Fowler | 2022-05-21 | Fresno | 19 | 1651 | 7917 | |
277602 | 277602 | Fresno | Fresno | 2022-05-21 | Fresno | 19 | 101523 | 608579 | |
277603 | 277603 | Friant | Friant | 2022-05-21 | Fresno | 19 | 170 | 1930 | |
277604 | 277604 | Huron | Huron | 2022-05-21 | Fresno | 19 | 1145 | 7579 | |
277605 | 277605 | Kerman | Kerman | 2022-05-21 | Fresno | 19 | 3818 | 21009 | |
277606 | 277606 | Kingsburg | Kingsburg | 2022-05-21 | Fresno | 19 | 2277 | 17086 | |
277607 | 277607 | Laton | Laton | 2022-05-21 | Fresno | 19 | 594 | 3513 | |
277608 | 277608 | Mendota | Mendota | 2022-05-21 | Fresno | 19 | 2355 | 13576 | |
277609 | 277609 | Orange Cove | Orange Cove | 2022-05-21 | Fresno | 19 | 2348 | 11320 | |
277610 | 277610 | Parlier | Parlier | 2022-05-21 | Fresno | 19 | 3781 | 17097 | |
277611 | 277611 | Prather | Prather | 2022-05-21 | Fresno | 19 | 128 | 0 | |
277612 | 277612 | Raisin | Raisin | 2022-05-21 | Fresno | 19 | 95 | 380 | |
277613 | 277613 | Reedley | Reedley | 2022-05-21 | Fresno | 19 | 5553 | 31129 | |
277614 | 277614 | Riverdale | Riverdale | 2022-05-21 | Fresno | 19 | 1186 | 6459 | |
277615 | 277615 | San Joaquin | San Joaquin | 2022-05-21 | Fresno | 19 | 780 | 4633 | |
277616 | 277616 | Sanger | Sanger | 2022-05-21 | Fresno | 19 | 7504 | 38252 | |
277617 | 277617 | Selma | Selma | 2022-05-21 | Fresno | 19 | 6741 | 31726 | |
277618 | 277618 | Squaw Valley | Squaw Valley | 2022-05-21 | Fresno | 19 | 250 | 3908 | |
277619 | 277619 | Tollhouse | Tollhouse | 2022-05-21 | Fresno | 19 | 173 | 2712 | |
277620 | 277620 | Tranquillity | Tranquillity | 2022-05-21 | Fresno | 19 | 175 | 1132 | |
277621 | 277621 | Greater Fortuna Area | Greater Fortuna Area | 2022-05-21 | Humboldt | 23 | 2475 | 20858 | |
277622 | 277622 | Greater Humboldt Bay | Greater Humboldt Bay | 2022-05-21 | Humboldt | 23 | 7906 | 78013 | |
277623 | 277623 | North | North | 2022-05-21 | Humboldt | 23 | 2985 | 30236 | |
277624 | 277624 | South | South | 2022-05-21 | Humboldt | 23 | 756 | 7601 | |
277625 | 277625 | 92222 | 92222: Bard | 2022-05-21 | Imperial | 25 | 13 | 0 | |
277626 | 277626 | 92227 | 92227: Brawley | 2022-05-21 | Imperial | 25 | 9207 | 27255 | |
277627 | 277627 | 92231 | 92231: Calexico | 2022-05-21 | Imperial | 25 | 13571 | 40019 | |
277628 | 277628 | 92233 | 92233: Calipatria | 2022-05-21 | Imperial | 25 | 1090 | 7618 | |
277629 | 277629 | 92243 | 92243: El Centro | 2022-05-21 | Imperial | 25 | 14004 | 50484 | |
277630 | 277630 | 92244 | 92244: El Centro | 2022-05-21 | Imperial | 25 | 225 | 0 | |
277631 | 277631 | 92249 | 92249: Heber | 2022-05-21 | Imperial | 25 | 2127 | 7898 | |
277632 | 277632 | 92250 | 92250: Holtville | 2022-05-21 | Imperial | 25 | 2038 | 8979 | |
277633 | 277633 | 92251 | 92251: Imperial | 2022-05-21 | Imperial | 25 | 6493 | 23388 | |
277634 | 277634 | 92257 | 92257: Niland | 2022-05-21 | Imperial | 25 | 319 | 1332 | |
277635 | 277635 | 92259 | 92259: Ocotillo | 2022-05-21 | Imperial | 25 | 28 | 94 | |
277636 | 277636 | 92266 | 92266: Palo Verde | 2022-05-21 | Imperial | 25 | 15 | 108 | |
277637 | 277637 | 92273 | 92273: Seeley | 2022-05-21 | Imperial | 25 | 412 | 1704 | |
277638 | 277638 | 92274 | 92274: Thermal | 2022-05-21 | Imperial | 25 | 1062 | 15118 | |
277639 | 277639 | 92275 | 92275: Salton City | 2022-05-21 | Imperial | 25 | 67 | 2456 | |
277640 | 277640 | 92281 | 92281: Westmorland | 2022-05-21 | Imperial | 25 | 590 | 2859 | |
277641 | 277641 | 92283 | 92283: Winterhaven | 2022-05-21 | Imperial | 25 | 807 | 1694 | |
277642 | 277642 | 93226 | 93226: Glennville | 2022-05-21 | Kern | 29 | 37 | 195 | |
277643 | 277643 | 93238 | 93238: Kernville | 2022-05-21 | Kern | 29 | 210 | 1408 | |
277644 | 277644 | 93240 | 93240: Lake Isabella | 2022-05-21 | Kern | 29 | 1031 | 6960 | |
277645 | 277645 | 93241 | 93241: Lamont | 2022-05-21 | Kern | 29 | 4600 | 16969 | |
277646 | 277646 | 93243 | 93243: Lebec | 2022-05-21 | Kern | 29 | 236 | 1709 | |
277647 | 277647 | 93249 | 93249: Lost Hills | 2022-05-21 | Kern | 29 | 566 | 2264 | |
277648 | 277648 | 93250 | 93250: Mc Farland | 2022-05-21 | Kern | 29 | 4550 | 15523 | |
277649 | 277649 | 93251 | 93251: Mc Kittrick | 2022-05-21 | Kern | 29 | 53 | 243 | |
277650 | 277650 | 93252 | 93252: Maricopa | 2022-05-21 | Kern | 29 | 284 | 3188 | |
277651 | 277651 | 93255 | 93255: Onyx | 2022-05-21 | Kern | 29 | 46 | 707 | |
277652 | 277652 | 93263 | 93263: Shafter | 2022-05-21 | Kern | 29 | 6920 | 20710 | |
277653 | 277653 | 93268 | 93268: Taft | 2022-05-21 | Kern | 29 | 4285 | 17620 | |
277654 | 277654 | 93276 | 93276: Tupman | 2022-05-21 | Kern | 29 | 61 | 159 | |
277655 | 277655 | 93280 | 93280: Wasco | 2022-05-21 | Kern | 29 | 11132 | 27552 | |
277656 | 277656 | 93283 | 93283: Weldon | 2022-05-21 | Kern | 29 | 232 | 2086 | |
277657 | 277657 | 93285 | 93285: Wofford Heights | 2022-05-21 | Kern | 29 | 302 | 1723 | |
277658 | 277658 | 93287 | 93287: Woody | 2022-05-21 | Kern | 29 | 24 | 74 | |
277659 | 277659 | 93301 | 93301: Bakersfield | 2022-05-21 | Kern | 29 | 4282 | 12345 | |
277660 | 277660 | 93304 | 93304: Bakersfield | 2022-05-21 | Kern | 29 | 14352 | 50787 | |
277661 | 277661 | 93305 | 93305: Bakersfield | 2022-05-21 | Kern | 29 | 10362 | 39114 | |
277662 | 277662 | 93306 | 93306: Bakersfield | 2022-05-21 | Kern | 29 | 20782 | 70208 | |
277663 | 277663 | 93307 | 93307: Bakersfield | 2022-05-21 | Kern | 29 | 25091 | 84948 | |
277664 | 277664 | 93308 | 93308: Bakersfield | 2022-05-21 | Kern | 29 | 12763 | 54042 | |
277665 | 277665 | 93309 | 93309: Bakersfield | 2022-05-21 | Kern | 29 | 15943 | 60893 | |
277666 | 277666 | 93311 | 93311: Bakersfield | 2022-05-21 | Kern | 29 | 12554 | 44862 | |
277667 | 277667 | 93312 | 93312: Bakersfield | 2022-05-21 | Kern | 29 | 15069 | 59359 | |
277668 | 277668 | 93313 | 93313: Bakersfield | 2022-05-21 | Kern | 29 | 16528 | 51245 | |
277669 | 277669 | 93314 | 93314: Bakersfield | 2022-05-21 | Kern | 29 | 8538 | 26992 | |
277670 | 277670 | 93501 | 93501: Mojave | 2022-05-21 | Kern | 29 | 1056 | 5063 | |
277671 | 277671 | 93505 | 93505: California City | 2022-05-21 | Kern | 29 | 3206 | 13445 | |
277672 | 277672 | 93516 | 93516: Boron | 2022-05-21 | Kern | 29 | 459 | 2425 | |
277673 | 277673 | 93518 | 93518: Caliente | 2022-05-21 | Kern | 29 | 94 | 995 | |
277674 | 277674 | 93519 | 93519: Cantil | 2022-05-21 | Kern | 29 | 3 | 28 | |
277675 | 277675 | 93523 | 93523: Edwards | 2022-05-21 | Kern | 29 | 394 | 3312 | |
277676 | 277676 | 93524 | 93524: Edwards | 2022-05-21 | Kern | 29 | 50 | 168 | |
277677 | 277677 | 93203 | 93203: Arvin | 2022-05-21 | Kern | 29 | 5929 | 22471 | |
277678 | 277678 | 93205 | 93205: Bodfish | 2022-05-21 | Kern | 29 | 313 | 1593 | |
277679 | 277679 | 93206 | 93206: Buttonwillow | 2022-05-21 | Kern | 29 | 516 | 2044 | |
277680 | 277680 | 93215 | 93215: Delano | 2022-05-21 | Kern | 29 | 17898 | 55845 | |
277681 | 277681 | 93220 | 93220: Edison | 2022-05-21 | Kern | 29 | 32 | 313 | |
277682 | 277682 | 93222 | 93222: Pine Mountain Club | 2022-05-21 | Kern | 29 | 158 | 1420 | |
277683 | 277683 | 93224 | 93224: Fellows | 2022-05-21 | Kern | 29 | 96 | 402 | |
277684 | 277684 | 93225 | 93225: Frazier Park | 2022-05-21 | Kern | 29 | 758 | 5319 | |
277685 | 277685 | 93527 | 93527: Inyokern | 2022-05-21 | Kern | 29 | 306 | 1852 | |
277686 | 277686 | 93528 | 93528: Johannesburg | 2022-05-21 | Kern | 29 | 14 | 124 | |
277687 | 277687 | 93531 | 93531: Keene | 2022-05-21 | Kern | 29 | 72 | 422 | |
277688 | 277688 | 93554 | 93554: Randsburg | 2022-05-21 | Kern | 29 | 10 | 143 | |
277689 | 277689 | 93555 | 93555: Ridgecrest | 2022-05-21 | Kern | 29 | 6202 | 34075 | |
277690 | 277690 | 93560 | 93560: Rosamond | 2022-05-21 | Kern | 29 | 5200 | 20797 | |
277691 | 277691 | 93561 | 93561: Tehachapi | 2022-05-21 | Kern | 29 | 8937 | 34271 | |
277692 | 277692 | Armona | Armona | 2022-05-21 | Kings | 31 | 1493 | 3795 | |
277693 | 277693 | Avenal | Avenal | 2022-05-21 | Kings | 31 | 7047 | 12923 |
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 );