latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
1,277 rows where "date" is on date 2022-02-25 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Los Angeles 353
- San Diego 110
- Riverside 64
- San Bernardino 64
- Marin 53
- Kern 50
- Orange 41
- Fresno 32
- Placer 32
- Sonoma 32
- San Mateo 30
- Tulare 28
- Monterey 27
- San Francisco 26
- Ventura 25
- San Luis Obispo 22
- Napa 18
- Imperial 17
- Nevada 17
- Santa Cruz 16
- Lake 15
- Santa Clara 15
- Santa Barbara 11
- Merced 10
- Stanislaus 10
- Kings 9
- Sacramento 8
- Solano 8
- Madera 5
- Mendocino 5
- …
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
385603 | 385603 | Auberry | Auberry | 2022-02-25 | Fresno | 19 | 262 | 3994 | |
385604 | 385604 | Biola | Biola | 2022-02-25 | Fresno | 19 | 300 | 949 | |
385605 | 385605 | Cantua Creek | Cantua Creek | 2022-02-25 | Fresno | 19 | 202 | 1125 | |
385606 | 385606 | Caruthers | Caruthers | 2022-02-25 | Fresno | 19 | 1092 | 5887 | |
385607 | 385607 | Clovis | Clovis | 2022-02-25 | Fresno | 19 | 16159 | 122949 | |
385608 | 385608 | Coalinga | Coalinga | 2022-02-25 | Fresno | 19 | 5023 | 19345 | |
385609 | 385609 | Del Rey | Del Rey | 2022-02-25 | Fresno | 19 | 482 | 2759 | |
385610 | 385610 | Dinuba | Dinuba | 2022-02-25 | Fresno | 19 | 77 | 0 | |
385611 | 385611 | Dos Palos | Dos Palos | 2022-02-25 | Fresno | 19 | 0 | ||
385612 | 385612 | Dunlap | Dunlap | 2022-02-25 | Fresno | 19 | 6 | ||
385613 | 385613 | Firebaugh | Firebaugh | 2022-02-25 | Fresno | 19 | 1640 | 9965 | |
385614 | 385614 | Five Points | Five Points | 2022-02-25 | Fresno | 19 | 82 | 0 | |
385615 | 385615 | Fowler | Fowler | 2022-02-25 | Fresno | 19 | 1651 | 7917 | |
385616 | 385616 | Fresno | Fresno | 2022-02-25 | Fresno | 19 | 101523 | 608579 | |
385617 | 385617 | Friant | Friant | 2022-02-25 | Fresno | 19 | 170 | 1930 | |
385618 | 385618 | Huron | Huron | 2022-02-25 | Fresno | 19 | 1145 | 7579 | |
385619 | 385619 | Kerman | Kerman | 2022-02-25 | Fresno | 19 | 3818 | 21009 | |
385620 | 385620 | Kingsburg | Kingsburg | 2022-02-25 | Fresno | 19 | 2277 | 17086 | |
385621 | 385621 | Laton | Laton | 2022-02-25 | Fresno | 19 | 594 | 3513 | |
385622 | 385622 | Mendota | Mendota | 2022-02-25 | Fresno | 19 | 2355 | 13576 | |
385623 | 385623 | Orange Cove | Orange Cove | 2022-02-25 | Fresno | 19 | 2348 | 11320 | |
385624 | 385624 | Parlier | Parlier | 2022-02-25 | Fresno | 19 | 3781 | 17097 | |
385625 | 385625 | Prather | Prather | 2022-02-25 | Fresno | 19 | 128 | 0 | |
385626 | 385626 | Raisin | Raisin | 2022-02-25 | Fresno | 19 | 95 | 380 | |
385627 | 385627 | Reedley | Reedley | 2022-02-25 | Fresno | 19 | 5553 | 31129 | |
385628 | 385628 | Riverdale | Riverdale | 2022-02-25 | Fresno | 19 | 1186 | 6459 | |
385629 | 385629 | San Joaquin | San Joaquin | 2022-02-25 | Fresno | 19 | 780 | 4633 | |
385630 | 385630 | Sanger | Sanger | 2022-02-25 | Fresno | 19 | 7504 | 38252 | |
385631 | 385631 | Selma | Selma | 2022-02-25 | Fresno | 19 | 6741 | 31726 | |
385632 | 385632 | Squaw Valley | Squaw Valley | 2022-02-25 | Fresno | 19 | 250 | 3908 | |
385633 | 385633 | Tollhouse | Tollhouse | 2022-02-25 | Fresno | 19 | 173 | 2712 | |
385634 | 385634 | Tranquillity | Tranquillity | 2022-02-25 | Fresno | 19 | 175 | 1132 | |
385635 | 385635 | 92222 | 92222: Bard | 2022-02-25 | Imperial | 25 | 12 | 0 | |
385636 | 385636 | 92227 | 92227: Brawley | 2022-02-25 | Imperial | 25 | 8954 | 27255 | |
385637 | 385637 | 92231 | 92231: Calexico | 2022-02-25 | Imperial | 25 | 13503 | 40019 | |
385638 | 385638 | 92233 | 92233: Calipatria | 2022-02-25 | Imperial | 25 | 1044 | 7618 | |
385639 | 385639 | 92243 | 92243: El Centro | 2022-02-25 | Imperial | 25 | 13655 | 50484 | |
385640 | 385640 | 92244 | 92244: El Centro | 2022-02-25 | Imperial | 25 | 214 | 0 | |
385641 | 385641 | 92249 | 92249: Heber | 2022-02-25 | Imperial | 25 | 2073 | 7898 | |
385642 | 385642 | 92250 | 92250: Holtville | 2022-02-25 | Imperial | 25 | 1962 | 8979 | |
385643 | 385643 | 92251 | 92251: Imperial | 2022-02-25 | Imperial | 25 | 6248 | 23388 | |
385644 | 385644 | 92257 | 92257: Niland | 2022-02-25 | Imperial | 25 | 305 | 1332 | |
385645 | 385645 | 92259 | 92259: Ocotillo | 2022-02-25 | Imperial | 25 | 27 | 94 | |
385646 | 385646 | 92266 | 92266: Palo Verde | 2022-02-25 | Imperial | 25 | 15 | 108 | |
385647 | 385647 | 92273 | 92273: Seeley | 2022-02-25 | Imperial | 25 | 402 | 1704 | |
385648 | 385648 | 92274 | 92274: Thermal | 2022-02-25 | Imperial | 25 | 1040 | 15118 | |
385649 | 385649 | 92275 | 92275: Salton City | 2022-02-25 | Imperial | 25 | 62 | 2456 | |
385650 | 385650 | 92281 | 92281: Westmorland | 2022-02-25 | Imperial | 25 | 556 | 2859 | |
385651 | 385651 | 92283 | 92283: Winterhaven | 2022-02-25 | Imperial | 25 | 781 | 1694 | |
385652 | 385652 | 93226 | 93226: Glennville | 2022-02-25 | Kern | 29 | 35 | 195 | |
385653 | 385653 | 93238 | 93238: Kernville | 2022-02-25 | Kern | 29 | 205 | 1408 | |
385654 | 385654 | 93240 | 93240: Lake Isabella | 2022-02-25 | Kern | 29 | 1003 | 6960 | |
385655 | 385655 | 93241 | 93241: Lamont | 2022-02-25 | Kern | 29 | 4439 | 16969 | |
385656 | 385656 | 93243 | 93243: Lebec | 2022-02-25 | Kern | 29 | 226 | 1709 | |
385657 | 385657 | 93249 | 93249: Lost Hills | 2022-02-25 | Kern | 29 | 555 | 2264 | |
385658 | 385658 | 93250 | 93250: Mc Farland | 2022-02-25 | Kern | 29 | 4451 | 15523 | |
385659 | 385659 | 93251 | 93251: Mc Kittrick | 2022-02-25 | Kern | 29 | 52 | 243 | |
385660 | 385660 | 93252 | 93252: Maricopa | 2022-02-25 | Kern | 29 | 274 | 3188 | |
385661 | 385661 | 93255 | 93255: Onyx | 2022-02-25 | Kern | 29 | 44 | 707 | |
385662 | 385662 | 93263 | 93263: Shafter | 2022-02-25 | Kern | 29 | 6660 | 20710 | |
385663 | 385663 | 93268 | 93268: Taft | 2022-02-25 | Kern | 29 | 4135 | 17620 | |
385664 | 385664 | 93276 | 93276: Tupman | 2022-02-25 | Kern | 29 | 55 | 159 | |
385665 | 385665 | 93280 | 93280: Wasco | 2022-02-25 | Kern | 29 | 10661 | 27552 | |
385666 | 385666 | 93283 | 93283: Weldon | 2022-02-25 | Kern | 29 | 223 | 2086 | |
385667 | 385667 | 93285 | 93285: Wofford Heights | 2022-02-25 | Kern | 29 | 291 | 1723 | |
385668 | 385668 | 93287 | 93287: Woody | 2022-02-25 | Kern | 29 | 24 | 74 | |
385669 | 385669 | 93301 | 93301: Bakersfield | 2022-02-25 | Kern | 29 | 4072 | 12345 | |
385670 | 385670 | 93304 | 93304: Bakersfield | 2022-02-25 | Kern | 29 | 13811 | 50787 | |
385671 | 385671 | 93305 | 93305: Bakersfield | 2022-02-25 | Kern | 29 | 10004 | 39114 | |
385672 | 385672 | 93306 | 93306: Bakersfield | 2022-02-25 | Kern | 29 | 19895 | 70208 | |
385673 | 385673 | 93307 | 93307: Bakersfield | 2022-02-25 | Kern | 29 | 24198 | 84948 | |
385674 | 385674 | 93308 | 93308: Bakersfield | 2022-02-25 | Kern | 29 | 12193 | 54042 | |
385675 | 385675 | 93309 | 93309: Bakersfield | 2022-02-25 | Kern | 29 | 15285 | 60893 | |
385676 | 385676 | 93311 | 93311: Bakersfield | 2022-02-25 | Kern | 29 | 12016 | 44862 | |
385677 | 385677 | 93312 | 93312: Bakersfield | 2022-02-25 | Kern | 29 | 14262 | 59359 | |
385678 | 385678 | 93313 | 93313: Bakersfield | 2022-02-25 | Kern | 29 | 15907 | 51245 | |
385679 | 385679 | 93314 | 93314: Bakersfield | 2022-02-25 | Kern | 29 | 8087 | 26992 | |
385680 | 385680 | 93501 | 93501: Mojave | 2022-02-25 | Kern | 29 | 1033 | 5063 | |
385681 | 385681 | 93505 | 93505: California City | 2022-02-25 | Kern | 29 | 3130 | 13445 | |
385682 | 385682 | 93516 | 93516: Boron | 2022-02-25 | Kern | 29 | 439 | 2425 | |
385683 | 385683 | 93518 | 93518: Caliente | 2022-02-25 | Kern | 29 | 85 | 995 | |
385684 | 385684 | 93519 | 93519: Cantil | 2022-02-25 | Kern | 29 | 3 | 28 | |
385685 | 385685 | 93523 | 93523: Edwards | 2022-02-25 | Kern | 29 | 370 | 3312 | |
385686 | 385686 | 93524 | 93524: Edwards | 2022-02-25 | Kern | 29 | 49 | 168 | |
385687 | 385687 | 93203 | 93203: Arvin | 2022-02-25 | Kern | 29 | 5658 | 22471 | |
385688 | 385688 | 93205 | 93205: Bodfish | 2022-02-25 | Kern | 29 | 296 | 1593 | |
385689 | 385689 | 93206 | 93206: Buttonwillow | 2022-02-25 | Kern | 29 | 509 | 2044 | |
385690 | 385690 | 93215 | 93215: Delano | 2022-02-25 | Kern | 29 | 17260 | 55845 | |
385691 | 385691 | 93220 | 93220: Edison | 2022-02-25 | Kern | 29 | 31 | 313 | |
385692 | 385692 | 93222 | 93222: Pine Mountain Club | 2022-02-25 | Kern | 29 | 147 | 1420 | |
385693 | 385693 | 93224 | 93224: Fellows | 2022-02-25 | Kern | 29 | 95 | 402 | |
385694 | 385694 | 93225 | 93225: Frazier Park | 2022-02-25 | Kern | 29 | 711 | 5319 | |
385695 | 385695 | 93527 | 93527: Inyokern | 2022-02-25 | Kern | 29 | 294 | 1852 | |
385696 | 385696 | 93528 | 93528: Johannesburg | 2022-02-25 | Kern | 29 | 13 | 124 | |
385697 | 385697 | 93531 | 93531: Keene | 2022-02-25 | Kern | 29 | 70 | 422 | |
385698 | 385698 | 93554 | 93554: Randsburg | 2022-02-25 | Kern | 29 | 10 | 143 | |
385699 | 385699 | 93555 | 93555: Ridgecrest | 2022-02-25 | Kern | 29 | 5962 | 34075 | |
385700 | 385700 | 93560 | 93560: Rosamond | 2022-02-25 | Kern | 29 | 5051 | 20797 | |
385701 | 385701 | 93561 | 93561: Tehachapi | 2022-02-25 | Kern | 29 | 8714 | 34271 | |
385702 | 385702 | Armona | Armona | 2022-02-25 | Kings | 31 | 1464 | 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 );