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,200
- 59 18,245
- 61 15,136
- 97 15,072
- 19 13,664
- 13 13,027
- 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,072
- 85 6,480
- 57 6,069
- 83 4,906
- 47 4,500
- 99 4,350
- 31 3,753
- 33 3,585
- 17 3,504
- 67 3,504
- 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,200
- Orange 18,245
- Placer 15,136
- Sonoma 15,072
- Fresno 13,664
- Contra Costa 13,027
- 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,072
- Santa Clara 6,480
- Nevada 6,069
- Santa Barbara 4,906
- Merced 4,500
- Stanislaus 4,350
- Kings 3,753
- Lake 3,585
- El Dorado 3,504
- Sacramento 3,504
- 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 |
---|---|---|---|---|---|---|---|---|---|
711600 | 711600 | Pittsburg | Pittsburg | 2021-06-14 | Contra Costa | 13 | 6986 | 74321 | |
711601 | 711601 | Pleasant Hill | Pleasant Hill | 2021-06-14 | Contra Costa | 13 | 1237 | 34267 | |
711602 | 711602 | Richmond | Richmond | 2021-06-14 | Contra Costa | 13 | 11782 | 111217 | |
711603 | 711603 | Rodeo | Rodeo | 2021-06-14 | Contra Costa | 13 | 607 | 8679 | |
711604 | 711604 | San Pablo | San Pablo | 2021-06-14 | Contra Costa | 13 | 5345 | 31413 | |
711605 | 711605 | San Ramon | San Ramon | 2021-06-14 | Contra Costa | 13 | 2148 | 83118 | |
711606 | 711606 | Walnut Creek | Walnut Creek | 2021-06-14 | Contra Costa | 13 | 2911 | 70860 | |
711607 | 711607 | Camino, Pollock Pines, Kyburz | Camino, Pollock Pines, Kyburz | 2021-06-14 | El Dorado | 17 | 528 | 13548 | |
711608 | 711608 | El Dorado Hills | El Dorado Hills | 2021-06-14 | El Dorado | 17 | 2269 | 42439 | |
711609 | 711609 | El Dorado, Diamond Springs | El Dorado, Diamond Springs | 2021-06-14 | El Dorado | 17 | 469 | 9396 | |
711610 | 711610 | Greater Placerville Area | Greater Placerville Area | 2021-06-14 | El Dorado | 17 | 1854 | 36508 | |
711611 | 711611 | North County | North County | 2021-06-14 | El Dorado | 17 | 504 | 14433 | |
711612 | 711612 | Shingle Springs, Cameron Park, Rescue | Shingle Springs, Cameron Park, Rescue | 2021-06-14 | El Dorado | 17 | 1790 | 35294 | |
711613 | 711613 | South County | South County | 2021-06-14 | El Dorado | 17 | 134 | 10345 | |
711614 | 711614 | Tahoe Region | Tahoe Region | 2021-06-14 | El Dorado | 17 | 2712 | 30275 | |
711615 | 711615 | Auberry | Auberry | 2021-06-14 | Fresno | 19 | 114 | 3994 | |
711616 | 711616 | Biola | Biola | 2021-06-14 | Fresno | 19 | 173 | 949 | |
711617 | 711617 | Cantua Creek | Cantua Creek | 2021-06-14 | Fresno | 19 | 122 | 1125 | |
711618 | 711618 | Caruthers | Caruthers | 2021-06-14 | Fresno | 19 | 667 | 5887 | |
711619 | 711619 | Clovis | Clovis | 2021-06-14 | Fresno | 19 | 8248 | 122949 | |
711620 | 711620 | Coalinga | Coalinga | 2021-06-14 | Fresno | 19 | 3925 | 19345 | |
711621 | 711621 | Del Rey | Del Rey | 2021-06-14 | Fresno | 19 | 310 | 2759 | |
711622 | 711622 | Dinuba | Dinuba | 2021-06-14 | Fresno | 19 | 0 | 0 | |
711623 | 711623 | Dos Palos | Dos Palos | 2021-06-14 | Fresno | 19 | 0 | ||
711624 | 711624 | Dunlap | Dunlap | 2021-06-14 | Fresno | 19 | 6 | ||
711625 | 711625 | Firebaugh | Firebaugh | 2021-06-14 | Fresno | 19 | 1080 | 9965 | |
711626 | 711626 | Five Points | Five Points | 2021-06-14 | Fresno | 19 | 23 | 0 | |
711627 | 711627 | Fowler | Fowler | 2021-06-14 | Fresno | 19 | 1025 | 7917 | |
711628 | 711628 | Fresno | Fresno | 2021-06-14 | Fresno | 19 | 59489 | 608579 | |
711629 | 711629 | Friant | Friant | 2021-06-14 | Fresno | 19 | 36 | 1930 | |
711630 | 711630 | Huron | Huron | 2021-06-14 | Fresno | 19 | 884 | 7579 | |
711631 | 711631 | Kerman | Kerman | 2021-06-14 | Fresno | 19 | 2604 | 21009 | |
711632 | 711632 | Kingsburg | Kingsburg | 2021-06-14 | Fresno | 19 | 1330 | 17086 | |
711633 | 711633 | Laton | Laton | 2021-06-14 | Fresno | 19 | 326 | 3513 | |
711634 | 711634 | Mendota | Mendota | 2021-06-14 | Fresno | 19 | 1815 | 13576 | |
711635 | 711635 | Orange Cove | Orange Cove | 2021-06-14 | Fresno | 19 | 1557 | 11320 | |
711636 | 711636 | Parlier | Parlier | 2021-06-14 | Fresno | 19 | 2551 | 17097 | |
711637 | 711637 | Prather | Prather | 2021-06-14 | Fresno | 19 | 16 | 0 | |
711638 | 711638 | Raisin | Raisin | 2021-06-14 | Fresno | 19 | 0 | 380 | |
711639 | 711639 | Reedley | Reedley | 2021-06-14 | Fresno | 19 | 3554 | 31129 | |
711640 | 711640 | Riverdale | Riverdale | 2021-06-14 | Fresno | 19 | 711 | 6459 | |
711641 | 711641 | San Joaquin | San Joaquin | 2021-06-14 | Fresno | 19 | 500 | 4633 | |
711642 | 711642 | Sanger | Sanger | 2021-06-14 | Fresno | 19 | 4618 | 38252 | |
711643 | 711643 | Selma | Selma | 2021-06-14 | Fresno | 19 | 4326 | 31726 | |
711644 | 711644 | Squaw Valley | Squaw Valley | 2021-06-14 | Fresno | 19 | 104 | 3908 | |
711645 | 711645 | Tollhouse | Tollhouse | 2021-06-14 | Fresno | 19 | 88 | 2712 | |
711646 | 711646 | Tranquillity | Tranquillity | 2021-06-14 | Fresno | 19 | 102 | 1132 | |
711647 | 711647 | 92222 | 92222: Bard | 2021-06-14 | Imperial | 25 | 9 | 0 | |
711648 | 711648 | 92227 | 92227: Brawley | 2021-06-14 | Imperial | 25 | 4280 | 27255 | |
711649 | 711649 | 92231 | 92231: Calexico | 2021-06-14 | Imperial | 25 | 7248 | 40019 | |
711650 | 711650 | 92233 | 92233: Calipatria | 2021-06-14 | Imperial | 25 | 550 | 7618 | |
711651 | 711651 | 92243 | 92243: El Centro | 2021-06-14 | Imperial | 25 | 7142 | 50484 | |
711652 | 711652 | 92244 | 92244: El Centro | 2021-06-14 | Imperial | 25 | 95 | 0 | |
711653 | 711653 | 92249 | 92249: Heber | 2021-06-14 | Imperial | 25 | 1140 | 7898 | |
711654 | 711654 | 92250 | 92250: Holtville | 2021-06-14 | Imperial | 25 | 1059 | 8979 | |
711655 | 711655 | 92251 | 92251: Imperial | 2021-06-14 | Imperial | 25 | 2974 | 23388 | |
711656 | 711656 | 92257 | 92257: Niland | 2021-06-14 | Imperial | 25 | 108 | 1332 | |
711657 | 711657 | 92259 | 92259: Ocotillo | 2021-06-14 | Imperial | 25 | 15 | 94 | |
711658 | 711658 | 92266 | 92266: Palo Verde | 2021-06-14 | Imperial | 25 | 8 | 108 | |
711659 | 711659 | 92273 | 92273: Seeley | 2021-06-14 | Imperial | 25 | 204 | 1704 | |
711660 | 711660 | 92274 | 92274: Thermal | 2021-06-14 | Imperial | 25 | 520 | 15118 | |
711661 | 711661 | 92275 | 92275: Salton City | 2021-06-14 | Imperial | 25 | 39 | 2456 | |
711662 | 711662 | 92281 | 92281: Westmorland | 2021-06-14 | Imperial | 25 | 250 | 2859 | |
711663 | 711663 | 92283 | 92283: Winterhaven | 2021-06-14 | Imperial | 25 | 326 | 1694 | |
711664 | 711664 | 93226 | 93226: Glennville | 2021-06-14 | Kern | 29 | 18 | 195 | |
711665 | 711665 | 93238 | 93238: Kernville | 2021-06-14 | Kern | 29 | 74 | 1408 | |
711666 | 711666 | 93240 | 93240: Lake Isabella | 2021-06-14 | Kern | 29 | 288 | 6960 | |
711667 | 711667 | 93241 | 93241: Lamont | 2021-06-14 | Kern | 29 | 2298 | 16969 | |
711668 | 711668 | 93243 | 93243: Lebec | 2021-06-14 | Kern | 29 | 99 | 1709 | |
711669 | 711669 | 93249 | 93249: Lost Hills | 2021-06-14 | Kern | 29 | 290 | 2264 | |
711670 | 711670 | 93250 | 93250: Mc Farland | 2021-06-14 | Kern | 29 | 2294 | 15523 | |
711671 | 711671 | 93251 | 93251: Mc Kittrick | 2021-06-14 | Kern | 29 | 24 | 243 | |
711672 | 711672 | 93252 | 93252: Maricopa | 2021-06-14 | Kern | 29 | 117 | 3188 | |
711673 | 711673 | 93255 | 93255: Onyx | 2021-06-14 | Kern | 29 | 15 | 707 | |
711674 | 711674 | 93263 | 93263: Shafter | 2021-06-14 | Kern | 29 | 3601 | 20710 | |
711675 | 711675 | 93268 | 93268: Taft | 2021-06-14 | Kern | 29 | 1771 | 17620 | |
711676 | 711676 | 93276 | 93276: Tupman | 2021-06-14 | Kern | 29 | 14 | 159 | |
711677 | 711677 | 93280 | 93280: Wasco | 2021-06-14 | Kern | 29 | 5448 | 27552 | |
711678 | 711678 | 93283 | 93283: Weldon | 2021-06-14 | Kern | 29 | 60 | 2086 | |
711679 | 711679 | 93285 | 93285: Wofford Heights | 2021-06-14 | Kern | 29 | 80 | 1723 | |
711680 | 711680 | 93287 | 93287: Woody | 2021-06-14 | Kern | 29 | 15 | 74 | |
711681 | 711681 | 93301 | 93301: Bakersfield | 2021-06-14 | Kern | 29 | 1821 | 12345 | |
711682 | 711682 | 93304 | 93304: Bakersfield | 2021-06-14 | Kern | 29 | 6435 | 50787 | |
711683 | 711683 | 93305 | 93305: Bakersfield | 2021-06-14 | Kern | 29 | 4515 | 39114 | |
711684 | 711684 | 93306 | 93306: Bakersfield | 2021-06-14 | Kern | 29 | 9653 | 70208 | |
711685 | 711685 | 93307 | 93307: Bakersfield | 2021-06-14 | Kern | 29 | 12276 | 84948 | |
711686 | 711686 | 93308 | 93308: Bakersfield | 2021-06-14 | Kern | 29 | 4962 | 54042 | |
711687 | 711687 | 93309 | 93309: Bakersfield | 2021-06-14 | Kern | 29 | 7180 | 60893 | |
711688 | 711688 | 93311 | 93311: Bakersfield | 2021-06-14 | Kern | 29 | 5283 | 44862 | |
711689 | 711689 | 93312 | 93312: Bakersfield | 2021-06-14 | Kern | 29 | 6197 | 59359 | |
711690 | 711690 | 93313 | 93313: Bakersfield | 2021-06-14 | Kern | 29 | 8008 | 51245 | |
711691 | 711691 | 93314 | 93314: Bakersfield | 2021-06-14 | Kern | 29 | 3525 | 26992 | |
711692 | 711692 | 93501 | 93501: Mojave | 2021-06-14 | Kern | 29 | 456 | 5063 | |
711693 | 711693 | 93505 | 93505: California City | 2021-06-14 | Kern | 29 | 1740 | 13445 | |
711694 | 711694 | 93516 | 93516: Boron | 2021-06-14 | Kern | 29 | 117 | 2425 | |
711695 | 711695 | 93518 | 93518: Caliente | 2021-06-14 | Kern | 29 | 25 | 995 | |
711696 | 711696 | 93519 | 93519: Cantil | 2021-06-14 | Kern | 29 | 1 | 28 | |
711697 | 711697 | 93523 | 93523: Edwards | 2021-06-14 | Kern | 29 | 109 | 3312 | |
711698 | 711698 | 93524 | 93524: Edwards | 2021-06-14 | Kern | 29 | 9 | 168 | |
711699 | 711699 | 93203 | 93203: Arvin | 2021-06-14 | Kern | 29 | 3134 | 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 );