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 105,900
- San Diego 31,460
- Riverside 18,496
- San Bernardino 18,304
- Alameda 16,748
- Kern 12,400
- Orange 11,849
- Placer 10,144
- Sonoma 10,080
- Fresno 8,672
- Contra Costa 8,347
- Tulare 7,980
- San Francisco 7,800
- San Mateo 7,410
- Ventura 6,575
- San Luis Obispo 6,534
- Monterey 5,967
- Napa 4,770
- Imperial 4,420
- Santa Clara 4,140
- Nevada 3,417
- Santa Barbara 3,190
- Merced 2,940
- Stanislaus 2,790
- Kings 2,349
- El Dorado 2,256
- Sacramento 2,256
- Solano 2,176
- Amador 1,820
- Yolo 1,410
- …
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
910656 | 910656 | Pittsburg | Pittsburg | 2021-01-09 | Contra Costa | 13 | 4565 | 74321 | |
910657 | 910657 | Pleasant Hill | Pleasant Hill | 2021-01-09 | Contra Costa | 13 | 816 | 34267 | |
910658 | 910658 | Richmond | Richmond | 2021-01-09 | Contra Costa | 13 | 7524 | 111217 | |
910659 | 910659 | Rodeo | Rodeo | 2021-01-09 | Contra Costa | 13 | 355 | 8679 | |
910660 | 910660 | San Pablo | San Pablo | 2021-01-09 | Contra Costa | 13 | 3716 | 31413 | |
910661 | 910661 | San Ramon | San Ramon | 2021-01-09 | Contra Costa | 13 | 1420 | 83118 | |
910662 | 910662 | Walnut Creek | Walnut Creek | 2021-01-09 | Contra Costa | 13 | 1903 | 70860 | |
910663 | 910663 | Camino, Pollock Pines, Kyburz | Camino, Pollock Pines, Kyburz | 2021-01-09 | El Dorado | 17 | 352 | 13548 | |
910664 | 910664 | El Dorado Hills | El Dorado Hills | 2021-01-09 | El Dorado | 17 | 1448 | 42439 | |
910665 | 910665 | El Dorado, Diamond Springs | El Dorado, Diamond Springs | 2021-01-09 | El Dorado | 17 | 285 | 9396 | |
910666 | 910666 | Greater Placerville Area | Greater Placerville Area | 2021-01-09 | El Dorado | 17 | 1233 | 36508 | |
910667 | 910667 | North County | North County | 2021-01-09 | El Dorado | 17 | 292 | 14433 | |
910668 | 910668 | Shingle Springs, Cameron Park, Rescue | Shingle Springs, Cameron Park, Rescue | 2021-01-09 | El Dorado | 17 | 1102 | 35294 | |
910669 | 910669 | South County | South County | 2021-01-09 | El Dorado | 17 | 79 | 10345 | |
910670 | 910670 | Tahoe Region | Tahoe Region | 2021-01-09 | El Dorado | 17 | 1777 | 30275 | |
910671 | 910671 | Auberry | Auberry | 2021-01-09 | Fresno | 19 | 47 | 3994 | |
910672 | 910672 | Biola | Biola | 2021-01-09 | Fresno | 19 | 88 | 949 | |
910673 | 910673 | Cantua Creek | Cantua Creek | 2021-01-09 | Fresno | 19 | 55 | 1125 | |
910674 | 910674 | Caruthers | Caruthers | 2021-01-09 | Fresno | 19 | 367 | 5887 | |
910675 | 910675 | Clovis | Clovis | 2021-01-09 | Fresno | 19 | 3615 | 122949 | |
910676 | 910676 | Coalinga | Coalinga | 2021-01-09 | Fresno | 19 | 2078 | 19345 | |
910677 | 910677 | Del Rey | Del Rey | 2021-01-09 | Fresno | 19 | 166 | 2759 | |
910678 | 910678 | Dinuba | Dinuba | 2021-01-09 | Fresno | 19 | 0 | 0 | |
910679 | 910679 | Dos Palos | Dos Palos | 2021-01-09 | Fresno | 19 | 0 | ||
910680 | 910680 | Dunlap | Dunlap | 2021-01-09 | Fresno | 19 | 6 | ||
910681 | 910681 | Firebaugh | Firebaugh | 2021-01-09 | Fresno | 19 | 505 | 9965 | |
910682 | 910682 | Five Points | Five Points | 2021-01-09 | Fresno | 19 | 23 | 0 | |
910683 | 910683 | Fowler | Fowler | 2021-01-09 | Fresno | 19 | 474 | 7917 | |
910684 | 910684 | Fresno | Fresno | 2021-01-09 | Fresno | 19 | 26967 | 608579 | |
910685 | 910685 | Friant | Friant | 2021-01-09 | Fresno | 19 | 36 | 1930 | |
910686 | 910686 | Huron | Huron | 2021-01-09 | Fresno | 19 | 498 | 7579 | |
910687 | 910687 | Kerman | Kerman | 2021-01-09 | Fresno | 19 | 1429 | 21009 | |
910688 | 910688 | Kingsburg | Kingsburg | 2021-01-09 | Fresno | 19 | 658 | 17086 | |
910689 | 910689 | Laton | Laton | 2021-01-09 | Fresno | 19 | 168 | 3513 | |
910690 | 910690 | Mendota | Mendota | 2021-01-09 | Fresno | 19 | 1213 | 13576 | |
910691 | 910691 | Orange Cove | Orange Cove | 2021-01-09 | Fresno | 19 | 885 | 11320 | |
910692 | 910692 | Parlier | Parlier | 2021-01-09 | Fresno | 19 | 1606 | 17097 | |
910693 | 910693 | Prather | Prather | 2021-01-09 | Fresno | 19 | 16 | 0 | |
910694 | 910694 | Raisin | Raisin | 2021-01-09 | Fresno | 19 | 0 | 380 | |
910695 | 910695 | Reedley | Reedley | 2021-01-09 | Fresno | 19 | 1961 | 31129 | |
910696 | 910696 | Riverdale | Riverdale | 2021-01-09 | Fresno | 19 | 337 | 6459 | |
910697 | 910697 | San Joaquin | San Joaquin | 2021-01-09 | Fresno | 19 | 249 | 4633 | |
910698 | 910698 | Sanger | Sanger | 2021-01-09 | Fresno | 19 | 2275 | 38252 | |
910699 | 910699 | Selma | Selma | 2021-01-09 | Fresno | 19 | 2309 | 31726 | |
910700 | 910700 | Squaw Valley | Squaw Valley | 2021-01-09 | Fresno | 19 | 46 | 3908 | |
910701 | 910701 | Tollhouse | Tollhouse | 2021-01-09 | Fresno | 19 | 39 | 2712 | |
910702 | 910702 | Tranquillity | Tranquillity | 2021-01-09 | Fresno | 19 | 50 | 1132 | |
910703 | 910703 | 92222 | 92222: Bard | 2021-01-09 | Imperial | 25 | 5 | 0 | |
910704 | 910704 | 92227 | 92227: Brawley | 2021-01-09 | Imperial | 25 | 3580 | 27255 | |
910705 | 910705 | 92231 | 92231: Calexico | 2021-01-09 | Imperial | 25 | 6586 | 40019 | |
910706 | 910706 | 92233 | 92233: Calipatria | 2021-01-09 | Imperial | 25 | 1144 | 7618 | |
910707 | 910707 | 92243 | 92243: El Centro | 2021-01-09 | Imperial | 25 | 0 | 50484 | |
910708 | 910708 | 92244 | 92244: El Centro | 2021-01-09 | Imperial | 25 | 1 | 0 | |
910709 | 910709 | 92249 | 92249: Heber | 2021-01-09 | Imperial | 25 | 1006 | 7898 | |
910710 | 910710 | 92250 | 92250: Holtville | 2021-01-09 | Imperial | 25 | 898 | 8979 | |
910711 | 910711 | 92251 | 92251: Imperial | 2021-01-09 | Imperial | 25 | 3091 | 23388 | |
910712 | 910712 | 92257 | 92257: Niland | 2021-01-09 | Imperial | 25 | 84 | 1332 | |
910713 | 910713 | 92259 | 92259: Ocotillo | 2021-01-09 | Imperial | 25 | 6 | 94 | |
910714 | 910714 | 92266 | 92266: Palo Verde | 2021-01-09 | Imperial | 25 | 6 | 108 | |
910715 | 910715 | 92273 | 92273: Seeley | 2021-01-09 | Imperial | 25 | 165 | 1704 | |
910716 | 910716 | 92274 | 92274: Thermal | 2021-01-09 | Imperial | 25 | 350 | 15118 | |
910717 | 910717 | 92275 | 92275: Salton City | 2021-01-09 | Imperial | 25 | 39 | 2456 | |
910718 | 910718 | 92281 | 92281: Westmorland | 2021-01-09 | Imperial | 25 | 219 | 2859 | |
910719 | 910719 | 92283 | 92283: Winterhaven | 2021-01-09 | Imperial | 25 | 221 | 1694 | |
910720 | 910720 | 93226 | 93226: Glennville | 2021-01-09 | Kern | 29 | 11 | 195 | |
910721 | 910721 | 93238 | 93238: Kernville | 2021-01-09 | Kern | 29 | 43 | 1408 | |
910722 | 910722 | 93240 | 93240: Lake Isabella | 2021-01-09 | Kern | 29 | 183 | 6960 | |
910723 | 910723 | 93241 | 93241: Lamont | 2021-01-09 | Kern | 29 | 1796 | 16969 | |
910724 | 910724 | 93243 | 93243: Lebec | 2021-01-09 | Kern | 29 | 53 | 1709 | |
910725 | 910725 | 93249 | 93249: Lost Hills | 2021-01-09 | Kern | 29 | 215 | 2264 | |
910726 | 910726 | 93250 | 93250: Mc Farland | 2021-01-09 | Kern | 29 | 1857 | 15523 | |
910727 | 910727 | 93251 | 93251: Mc Kittrick | 2021-01-09 | Kern | 29 | 17 | 243 | |
910728 | 910728 | 93252 | 93252: Maricopa | 2021-01-09 | Kern | 29 | 66 | 3188 | |
910729 | 910729 | 93255 | 93255: Onyx | 2021-01-09 | Kern | 29 | 7 | 707 | |
910730 | 910730 | 93263 | 93263: Shafter | 2021-01-09 | Kern | 29 | 2612 | 20710 | |
910731 | 910731 | 93268 | 93268: Taft | 2021-01-09 | Kern | 29 | 1190 | 17620 | |
910732 | 910732 | 93276 | 93276: Tupman | 2021-01-09 | Kern | 29 | 10 | 159 | |
910733 | 910733 | 93280 | 93280: Wasco | 2021-01-09 | Kern | 29 | 4006 | 27552 | |
910734 | 910734 | 93283 | 93283: Weldon | 2021-01-09 | Kern | 29 | 29 | 2086 | |
910735 | 910735 | 93285 | 93285: Wofford Heights | 2021-01-09 | Kern | 29 | 49 | 1723 | |
910736 | 910736 | 93287 | 93287: Woody | 2021-01-09 | Kern | 29 | 6 | 74 | |
910737 | 910737 | 93301 | 93301: Bakersfield | 2021-01-09 | Kern | 29 | 1245 | 12345 | |
910738 | 910738 | 93304 | 93304: Bakersfield | 2021-01-09 | Kern | 29 | 4573 | 50787 | |
910739 | 910739 | 93305 | 93305: Bakersfield | 2021-01-09 | Kern | 29 | 3142 | 39114 | |
910740 | 910740 | 93306 | 93306: Bakersfield | 2021-01-09 | Kern | 29 | 6739 | 70208 | |
910741 | 910741 | 93307 | 93307: Bakersfield | 2021-01-09 | Kern | 29 | 9041 | 84948 | |
910742 | 910742 | 93308 | 93308: Bakersfield | 2021-01-09 | Kern | 29 | 3186 | 54042 | |
910743 | 910743 | 93309 | 93309: Bakersfield | 2021-01-09 | Kern | 29 | 4920 | 60893 | |
910744 | 910744 | 93311 | 93311: Bakersfield | 2021-01-09 | Kern | 29 | 3609 | 44862 | |
910745 | 910745 | 93312 | 93312: Bakersfield | 2021-01-09 | Kern | 29 | 4012 | 59359 | |
910746 | 910746 | 93313 | 93313: Bakersfield | 2021-01-09 | Kern | 29 | 5671 | 51245 | |
910747 | 910747 | 93314 | 93314: Bakersfield | 2021-01-09 | Kern | 29 | 2269 | 26992 | |
910748 | 910748 | 93501 | 93501: Mojave | 2021-01-09 | Kern | 29 | 264 | 5063 | |
910749 | 910749 | 93505 | 93505: California City | 2021-01-09 | Kern | 29 | 1331 | 13445 | |
910750 | 910750 | 93516 | 93516: Boron | 2021-01-09 | Kern | 29 | 73 | 2425 | |
910751 | 910751 | 93518 | 93518: Caliente | 2021-01-09 | Kern | 29 | 16 | 995 | |
910752 | 910752 | 93519 | 93519: Cantil | 2021-01-09 | Kern | 29 | 0 | 28 | |
910753 | 910753 | 93523 | 93523: Edwards | 2021-01-09 | Kern | 29 | 49 | 3312 | |
910754 | 910754 | 93524 | 93524: Edwards | 2021-01-09 | Kern | 29 | 3 | 168 | |
910755 | 910755 | 93203 | 93203: Arvin | 2021-01-09 | Kern | 29 | 2360 | 22471 |
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 );