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 193,797
- San Diego 58,850
- Riverside 34,432
- San Bernardino 34,240
- Alameda 29,945
- Kern 24,850
- Orange 22,058
- Placer 18,112
- Sonoma 18,048
- Fresno 16,640
- Contra Costa 15,817
- Tulare 14,952
- San Mateo 14,880
- San Francisco 14,274
- Marin 13,515
- Ventura 12,800
- Monterey 12,690
- San Luis Obispo 12,012
- Napa 9,252
- Imperial 8,653
- Santa Clara 7,875
- Nevada 7,650
- Santa Barbara 5,929
- Merced 5,430
- Stanislaus 5,280
- Lake 4,980
- Kings 4,590
- El Dorado 4,248
- Sacramento 4,248
- Solano 4,168
- …
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
592932 | 592932 | Pittsburg | Pittsburg | 2021-09-15 | Contra Costa | 13 | 8999 | 74321 | |
592933 | 592933 | Pleasant Hill | Pleasant Hill | 2021-09-15 | Contra Costa | 13 | 1679 | 34267 | |
592934 | 592934 | Richmond | Richmond | 2021-09-15 | Contra Costa | 13 | 14450 | 111217 | |
592935 | 592935 | Rodeo | Rodeo | 2021-09-15 | Contra Costa | 13 | 804 | 8679 | |
592936 | 592936 | San Pablo | San Pablo | 2021-09-15 | Contra Costa | 13 | 6318 | 31413 | |
592937 | 592937 | San Ramon | San Ramon | 2021-09-15 | Contra Costa | 13 | 2969 | 83118 | |
592938 | 592938 | Walnut Creek | Walnut Creek | 2021-09-15 | Contra Costa | 13 | 3986 | 70860 | |
592939 | 592939 | Camino, Pollock Pines, Kyburz | Camino, Pollock Pines, Kyburz | 2021-09-15 | El Dorado | 17 | 777 | 13548 | |
592940 | 592940 | El Dorado Hills | El Dorado Hills | 2021-09-15 | El Dorado | 17 | 3123 | 42439 | |
592941 | 592941 | El Dorado, Diamond Springs | El Dorado, Diamond Springs | 2021-09-15 | El Dorado | 17 | 705 | 9396 | |
592942 | 592942 | Greater Placerville Area | Greater Placerville Area | 2021-09-15 | El Dorado | 17 | 2673 | 36508 | |
592943 | 592943 | North County | North County | 2021-09-15 | El Dorado | 17 | 762 | 14433 | |
592944 | 592944 | Shingle Springs, Cameron Park, Rescue | Shingle Springs, Cameron Park, Rescue | 2021-09-15 | El Dorado | 17 | 2604 | 35294 | |
592945 | 592945 | South County | South County | 2021-09-15 | El Dorado | 17 | 207 | 10345 | |
592946 | 592946 | Tahoe Region | Tahoe Region | 2021-09-15 | El Dorado | 17 | 3368 | 30275 | |
592947 | 592947 | Auberry | Auberry | 2021-09-15 | Fresno | 19 | 142 | 3994 | |
592948 | 592948 | Biola | Biola | 2021-09-15 | Fresno | 19 | 179 | 949 | |
592949 | 592949 | Cantua Creek | Cantua Creek | 2021-09-15 | Fresno | 19 | 123 | 1125 | |
592950 | 592950 | Caruthers | Caruthers | 2021-09-15 | Fresno | 19 | 711 | 5887 | |
592951 | 592951 | Clovis | Clovis | 2021-09-15 | Fresno | 19 | 9078 | 122949 | |
592952 | 592952 | Coalinga | Coalinga | 2021-09-15 | Fresno | 19 | 4051 | 19345 | |
592953 | 592953 | Del Rey | Del Rey | 2021-09-15 | Fresno | 19 | 324 | 2759 | |
592954 | 592954 | Dinuba | Dinuba | 2021-09-15 | Fresno | 19 | 0 | 0 | |
592955 | 592955 | Dos Palos | Dos Palos | 2021-09-15 | Fresno | 19 | 0 | ||
592956 | 592956 | Dunlap | Dunlap | 2021-09-15 | Fresno | 19 | 6 | ||
592957 | 592957 | Firebaugh | Firebaugh | 2021-09-15 | Fresno | 19 | 1111 | 9965 | |
592958 | 592958 | Five Points | Five Points | 2021-09-15 | Fresno | 19 | 23 | 0 | |
592959 | 592959 | Fowler | Fowler | 2021-09-15 | Fresno | 19 | 1108 | 7917 | |
592960 | 592960 | Fresno | Fresno | 2021-09-15 | Fresno | 19 | 61638 | 608579 | |
592961 | 592961 | Friant | Friant | 2021-09-15 | Fresno | 19 | 88 | 1930 | |
592962 | 592962 | Huron | Huron | 2021-09-15 | Fresno | 19 | 919 | 7579 | |
592963 | 592963 | Kerman | Kerman | 2021-09-15 | Fresno | 19 | 2699 | 21009 | |
592964 | 592964 | Kingsburg | Kingsburg | 2021-09-15 | Fresno | 19 | 1442 | 17086 | |
592965 | 592965 | Laton | Laton | 2021-09-15 | Fresno | 19 | 344 | 3513 | |
592966 | 592966 | Mendota | Mendota | 2021-09-15 | Fresno | 19 | 1863 | 13576 | |
592967 | 592967 | Orange Cove | Orange Cove | 2021-09-15 | Fresno | 19 | 1599 | 11320 | |
592968 | 592968 | Parlier | Parlier | 2021-09-15 | Fresno | 19 | 2648 | 17097 | |
592969 | 592969 | Prather | Prather | 2021-09-15 | Fresno | 19 | 78 | 0 | |
592970 | 592970 | Raisin | Raisin | 2021-09-15 | Fresno | 19 | 0 | 380 | |
592971 | 592971 | Reedley | Reedley | 2021-09-15 | Fresno | 19 | 3755 | 31129 | |
592972 | 592972 | Riverdale | Riverdale | 2021-09-15 | Fresno | 19 | 782 | 6459 | |
592973 | 592973 | San Joaquin | San Joaquin | 2021-09-15 | Fresno | 19 | 511 | 4633 | |
592974 | 592974 | Sanger | Sanger | 2021-09-15 | Fresno | 19 | 4900 | 38252 | |
592975 | 592975 | Selma | Selma | 2021-09-15 | Fresno | 19 | 4531 | 31726 | |
592976 | 592976 | Squaw Valley | Squaw Valley | 2021-09-15 | Fresno | 19 | 114 | 3908 | |
592977 | 592977 | Tollhouse | Tollhouse | 2021-09-15 | Fresno | 19 | 106 | 2712 | |
592978 | 592978 | Tranquillity | Tranquillity | 2021-09-15 | Fresno | 19 | 120 | 1132 | |
592979 | 592979 | 92222 | 92222: Bard | 2021-09-15 | Imperial | 25 | 9 | 0 | |
592980 | 592980 | 92227 | 92227: Brawley | 2021-09-15 | Imperial | 25 | 4686 | 27255 | |
592981 | 592981 | 92231 | 92231: Calexico | 2021-09-15 | Imperial | 25 | 7704 | 40019 | |
592982 | 592982 | 92233 | 92233: Calipatria | 2021-09-15 | Imperial | 25 | 571 | 7618 | |
592983 | 592983 | 92243 | 92243: El Centro | 2021-09-15 | Imperial | 25 | 7848 | 50484 | |
592984 | 592984 | 92244 | 92244: El Centro | 2021-09-15 | Imperial | 25 | 103 | 0 | |
592985 | 592985 | 92249 | 92249: Heber | 2021-09-15 | Imperial | 25 | 1226 | 7898 | |
592986 | 592986 | 92250 | 92250: Holtville | 2021-09-15 | Imperial | 25 | 1146 | 8979 | |
592987 | 592987 | 92251 | 92251: Imperial | 2021-09-15 | Imperial | 25 | 3314 | 23388 | |
592988 | 592988 | 92257 | 92257: Niland | 2021-09-15 | Imperial | 25 | 122 | 1332 | |
592989 | 592989 | 92259 | 92259: Ocotillo | 2021-09-15 | Imperial | 25 | 18 | 94 | |
592990 | 592990 | 92266 | 92266: Palo Verde | 2021-09-15 | Imperial | 25 | 8 | 108 | |
592991 | 592991 | 92273 | 92273: Seeley | 2021-09-15 | Imperial | 25 | 231 | 1704 | |
592992 | 592992 | 92274 | 92274: Thermal | 2021-09-15 | Imperial | 25 | 614 | 15118 | |
592993 | 592993 | 92275 | 92275: Salton City | 2021-09-15 | Imperial | 25 | 40 | 2456 | |
592994 | 592994 | 92281 | 92281: Westmorland | 2021-09-15 | Imperial | 25 | 272 | 2859 | |
592995 | 592995 | 92283 | 92283: Winterhaven | 2021-09-15 | Imperial | 25 | 387 | 1694 | |
592996 | 592996 | 93226 | 93226: Glennville | 2021-09-15 | Kern | 29 | 20 | 195 | |
592997 | 592997 | 93238 | 93238: Kernville | 2021-09-15 | Kern | 29 | 96 | 1408 | |
592998 | 592998 | 93240 | 93240: Lake Isabella | 2021-09-15 | Kern | 29 | 396 | 6960 | |
592999 | 592999 | 93241 | 93241: Lamont | 2021-09-15 | Kern | 29 | 2597 | 16969 | |
593000 | 593000 | 93243 | 93243: Lebec | 2021-09-15 | Kern | 29 | 112 | 1709 | |
593001 | 593001 | 93249 | 93249: Lost Hills | 2021-09-15 | Kern | 29 | 319 | 2264 | |
593002 | 593002 | 93250 | 93250: Mc Farland | 2021-09-15 | Kern | 29 | 2602 | 15523 | |
593003 | 593003 | 93251 | 93251: Mc Kittrick | 2021-09-15 | Kern | 29 | 24 | 243 | |
593004 | 593004 | 93252 | 93252: Maricopa | 2021-09-15 | Kern | 29 | 141 | 3188 | |
593005 | 593005 | 93255 | 93255: Onyx | 2021-09-15 | Kern | 29 | 18 | 707 | |
593006 | 593006 | 93263 | 93263: Shafter | 2021-09-15 | Kern | 29 | 4180 | 20710 | |
593007 | 593007 | 93268 | 93268: Taft | 2021-09-15 | Kern | 29 | 2316 | 17620 | |
593008 | 593008 | 93276 | 93276: Tupman | 2021-09-15 | Kern | 29 | 26 | 159 | |
593009 | 593009 | 93280 | 93280: Wasco | 2021-09-15 | Kern | 29 | 6030 | 27552 | |
593010 | 593010 | 93283 | 93283: Weldon | 2021-09-15 | Kern | 29 | 91 | 2086 | |
593011 | 593011 | 93285 | 93285: Wofford Heights | 2021-09-15 | Kern | 29 | 101 | 1723 | |
593012 | 593012 | 93287 | 93287: Woody | 2021-09-15 | Kern | 29 | 18 | 74 | |
593013 | 593013 | 93301 | 93301: Bakersfield | 2021-09-15 | Kern | 29 | 2376 | 12345 | |
593014 | 593014 | 93304 | 93304: Bakersfield | 2021-09-15 | Kern | 29 | 7758 | 50787 | |
593015 | 593015 | 93305 | 93305: Bakersfield | 2021-09-15 | Kern | 29 | 5562 | 39114 | |
593016 | 593016 | 93306 | 93306: Bakersfield | 2021-09-15 | Kern | 29 | 11655 | 70208 | |
593017 | 593017 | 93307 | 93307: Bakersfield | 2021-09-15 | Kern | 29 | 14585 | 84948 | |
593018 | 593018 | 93308 | 93308: Bakersfield | 2021-09-15 | Kern | 29 | 6653 | 54042 | |
593019 | 593019 | 93309 | 93309: Bakersfield | 2021-09-15 | Kern | 29 | 8839 | 60893 | |
593020 | 593020 | 93311 | 93311: Bakersfield | 2021-09-15 | Kern | 29 | 6613 | 44862 | |
593021 | 593021 | 93312 | 93312: Bakersfield | 2021-09-15 | Kern | 29 | 7855 | 59359 | |
593022 | 593022 | 93313 | 93313: Bakersfield | 2021-09-15 | Kern | 29 | 9567 | 51245 | |
593023 | 593023 | 93314 | 93314: Bakersfield | 2021-09-15 | Kern | 29 | 4456 | 26992 | |
593024 | 593024 | 93501 | 93501: Mojave | 2021-09-15 | Kern | 29 | 561 | 5063 | |
593025 | 593025 | 93505 | 93505: California City | 2021-09-15 | Kern | 29 | 2031 | 13445 | |
593026 | 593026 | 93516 | 93516: Boron | 2021-09-15 | Kern | 29 | 161 | 2425 | |
593027 | 593027 | 93518 | 93518: Caliente | 2021-09-15 | Kern | 29 | 28 | 995 | |
593028 | 593028 | 93519 | 93519: Cantil | 2021-09-15 | Kern | 29 | 1 | 28 | |
593029 | 593029 | 93523 | 93523: Edwards | 2021-09-15 | Kern | 29 | 161 | 3312 | |
593030 | 593030 | 93524 | 93524: Edwards | 2021-09-15 | Kern | 29 | 37 | 168 | |
593031 | 593031 | 93203 | 93203: Arvin | 2021-09-15 | Kern | 29 | 3569 | 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 );