latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
1,276 rows where "date" is on date 2021-01-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
- Lake 15
- Santa Clara 15
- Santa Barbara 11
- Merced 10
- Stanislaus 10
- Kings 9
- El Dorado 8
- Sacramento 8
- Solano 8
- Contra Costa 7
- Madera 5
- …
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
890240 | 890240 | Pittsburg | Pittsburg | 2021-01-25 | Contra Costa | 13 | 5484 | 74321 | |
890241 | 890241 | Pleasant Hill | Pleasant Hill | 2021-01-25 | Contra Costa | 13 | 955 | 34267 | |
890242 | 890242 | Richmond | Richmond | 2021-01-25 | Contra Costa | 13 | 8579 | 111217 | |
890243 | 890243 | Rodeo | Rodeo | 2021-01-25 | Contra Costa | 13 | 446 | 8679 | |
890244 | 890244 | San Pablo | San Pablo | 2021-01-25 | Contra Costa | 13 | 4389 | 31413 | |
890245 | 890245 | San Ramon | San Ramon | 2021-01-25 | Contra Costa | 13 | 1676 | 83118 | |
890246 | 890246 | Walnut Creek | Walnut Creek | 2021-01-25 | Contra Costa | 13 | 2292 | 70860 | |
890247 | 890247 | Camino, Pollock Pines, Kyburz | Camino, Pollock Pines, Kyburz | 2021-01-25 | El Dorado | 17 | 447 | 13548 | |
890248 | 890248 | El Dorado Hills | El Dorado Hills | 2021-01-25 | El Dorado | 17 | 1728 | 42439 | |
890249 | 890249 | El Dorado, Diamond Springs | El Dorado, Diamond Springs | 2021-01-25 | El Dorado | 17 | 386 | 9396 | |
890250 | 890250 | Greater Placerville Area | Greater Placerville Area | 2021-01-25 | El Dorado | 17 | 1481 | 36508 | |
890251 | 890251 | North County | North County | 2021-01-25 | El Dorado | 17 | 360 | 14433 | |
890252 | 890252 | Shingle Springs, Cameron Park, Rescue | Shingle Springs, Cameron Park, Rescue | 2021-01-25 | El Dorado | 17 | 1384 | 35294 | |
890253 | 890253 | South County | South County | 2021-01-25 | El Dorado | 17 | 96 | 10345 | |
890254 | 890254 | Tahoe Region | Tahoe Region | 2021-01-25 | El Dorado | 17 | 2188 | 30275 | |
890255 | 890255 | Auberry | Auberry | 2021-01-25 | Fresno | 19 | 47 | 3994 | |
890256 | 890256 | Biola | Biola | 2021-01-25 | Fresno | 19 | 88 | 949 | |
890257 | 890257 | Cantua Creek | Cantua Creek | 2021-01-25 | Fresno | 19 | 55 | 1125 | |
890258 | 890258 | Caruthers | Caruthers | 2021-01-25 | Fresno | 19 | 367 | 5887 | |
890259 | 890259 | Clovis | Clovis | 2021-01-25 | Fresno | 19 | 3615 | 122949 | |
890260 | 890260 | Coalinga | Coalinga | 2021-01-25 | Fresno | 19 | 2078 | 19345 | |
890261 | 890261 | Del Rey | Del Rey | 2021-01-25 | Fresno | 19 | 166 | 2759 | |
890262 | 890262 | Dinuba | Dinuba | 2021-01-25 | Fresno | 19 | 0 | 0 | |
890263 | 890263 | Dos Palos | Dos Palos | 2021-01-25 | Fresno | 19 | 0 | ||
890264 | 890264 | Dunlap | Dunlap | 2021-01-25 | Fresno | 19 | 6 | ||
890265 | 890265 | Firebaugh | Firebaugh | 2021-01-25 | Fresno | 19 | 505 | 9965 | |
890266 | 890266 | Five Points | Five Points | 2021-01-25 | Fresno | 19 | 23 | 0 | |
890267 | 890267 | Fowler | Fowler | 2021-01-25 | Fresno | 19 | 474 | 7917 | |
890268 | 890268 | Fresno | Fresno | 2021-01-25 | Fresno | 19 | 26967 | 608579 | |
890269 | 890269 | Friant | Friant | 2021-01-25 | Fresno | 19 | 36 | 1930 | |
890270 | 890270 | Huron | Huron | 2021-01-25 | Fresno | 19 | 498 | 7579 | |
890271 | 890271 | Kerman | Kerman | 2021-01-25 | Fresno | 19 | 1429 | 21009 | |
890272 | 890272 | Kingsburg | Kingsburg | 2021-01-25 | Fresno | 19 | 658 | 17086 | |
890273 | 890273 | Laton | Laton | 2021-01-25 | Fresno | 19 | 168 | 3513 | |
890274 | 890274 | Mendota | Mendota | 2021-01-25 | Fresno | 19 | 1213 | 13576 | |
890275 | 890275 | Orange Cove | Orange Cove | 2021-01-25 | Fresno | 19 | 885 | 11320 | |
890276 | 890276 | Parlier | Parlier | 2021-01-25 | Fresno | 19 | 1606 | 17097 | |
890277 | 890277 | Prather | Prather | 2021-01-25 | Fresno | 19 | 16 | 0 | |
890278 | 890278 | Raisin | Raisin | 2021-01-25 | Fresno | 19 | 0 | 380 | |
890279 | 890279 | Reedley | Reedley | 2021-01-25 | Fresno | 19 | 1961 | 31129 | |
890280 | 890280 | Riverdale | Riverdale | 2021-01-25 | Fresno | 19 | 337 | 6459 | |
890281 | 890281 | San Joaquin | San Joaquin | 2021-01-25 | Fresno | 19 | 249 | 4633 | |
890282 | 890282 | Sanger | Sanger | 2021-01-25 | Fresno | 19 | 2275 | 38252 | |
890283 | 890283 | Selma | Selma | 2021-01-25 | Fresno | 19 | 2309 | 31726 | |
890284 | 890284 | Squaw Valley | Squaw Valley | 2021-01-25 | Fresno | 19 | 46 | 3908 | |
890285 | 890285 | Tollhouse | Tollhouse | 2021-01-25 | Fresno | 19 | 39 | 2712 | |
890286 | 890286 | Tranquillity | Tranquillity | 2021-01-25 | Fresno | 19 | 50 | 1132 | |
890287 | 890287 | 92222 | 92222: Bard | 2021-01-25 | Imperial | 25 | 5 | 0 | |
890288 | 890288 | 92227 | 92227: Brawley | 2021-01-25 | Imperial | 25 | 3919 | 27255 | |
890289 | 890289 | 92231 | 92231: Calexico | 2021-01-25 | Imperial | 25 | 6939 | 40019 | |
890290 | 890290 | 92233 | 92233: Calipatria | 2021-01-25 | Imperial | 25 | 1391 | 7618 | |
890291 | 890291 | 92243 | 92243: El Centro | 2021-01-25 | Imperial | 25 | 6647 | 50484 | |
890292 | 890292 | 92244 | 92244: El Centro | 2021-01-25 | Imperial | 25 | 87 | 0 | |
890293 | 890293 | 92249 | 92249: Heber | 2021-01-25 | Imperial | 25 | 1072 | 7898 | |
890294 | 890294 | 92250 | 92250: Holtville | 2021-01-25 | Imperial | 25 | 990 | 8979 | |
890295 | 890295 | 92251 | 92251: Imperial | 2021-01-25 | Imperial | 25 | 3392 | 23388 | |
890296 | 890296 | 92257 | 92257: Niland | 2021-01-25 | Imperial | 25 | 90 | 1332 | |
890297 | 890297 | 92259 | 92259: Ocotillo | 2021-01-25 | Imperial | 25 | 7 | 94 | |
890298 | 890298 | 92266 | 92266: Palo Verde | 2021-01-25 | Imperial | 25 | 8 | 108 | |
890299 | 890299 | 92273 | 92273: Seeley | 2021-01-25 | Imperial | 25 | 185 | 1704 | |
890300 | 890300 | 92274 | 92274: Thermal | 2021-01-25 | Imperial | 25 | 447 | 15118 | |
890301 | 890301 | 92275 | 92275: Salton City | 2021-01-25 | Imperial | 25 | 43 | 2456 | |
890302 | 890302 | 92281 | 92281: Westmorland | 2021-01-25 | Imperial | 25 | 239 | 2859 | |
890303 | 890303 | 92283 | 92283: Winterhaven | 2021-01-25 | Imperial | 25 | 262 | 1694 | |
890304 | 890304 | 93226 | 93226: Glennville | 2021-01-25 | Kern | 29 | 14 | 195 | |
890305 | 890305 | 93238 | 93238: Kernville | 2021-01-25 | Kern | 29 | 53 | 1408 | |
890306 | 890306 | 93240 | 93240: Lake Isabella | 2021-01-25 | Kern | 29 | 227 | 6960 | |
890307 | 890307 | 93241 | 93241: Lamont | 2021-01-25 | Kern | 29 | 2016 | 16969 | |
890308 | 890308 | 93243 | 93243: Lebec | 2021-01-25 | Kern | 29 | 84 | 1709 | |
890309 | 890309 | 93249 | 93249: Lost Hills | 2021-01-25 | Kern | 29 | 252 | 2264 | |
890310 | 890310 | 93250 | 93250: Mc Farland | 2021-01-25 | Kern | 29 | 2066 | 15523 | |
890311 | 890311 | 93251 | 93251: Mc Kittrick | 2021-01-25 | Kern | 29 | 18 | 243 | |
890312 | 890312 | 93252 | 93252: Maricopa | 2021-01-25 | Kern | 29 | 83 | 3188 | |
890313 | 890313 | 93255 | 93255: Onyx | 2021-01-25 | Kern | 29 | 8 | 707 | |
890314 | 890314 | 93263 | 93263: Shafter | 2021-01-25 | Kern | 29 | 3018 | 20710 | |
890315 | 890315 | 93268 | 93268: Taft | 2021-01-25 | Kern | 29 | 1412 | 17620 | |
890316 | 890316 | 93276 | 93276: Tupman | 2021-01-25 | Kern | 29 | 12 | 159 | |
890317 | 890317 | 93280 | 93280: Wasco | 2021-01-25 | Kern | 29 | 4569 | 27552 | |
890318 | 890318 | 93283 | 93283: Weldon | 2021-01-25 | Kern | 29 | 42 | 2086 | |
890319 | 890319 | 93285 | 93285: Wofford Heights | 2021-01-25 | Kern | 29 | 53 | 1723 | |
890320 | 890320 | 93287 | 93287: Woody | 2021-01-25 | Kern | 29 | 9 | 74 | |
890321 | 890321 | 93301 | 93301: Bakersfield | 2021-01-25 | Kern | 29 | 1492 | 12345 | |
890322 | 890322 | 93304 | 93304: Bakersfield | 2021-01-25 | Kern | 29 | 5317 | 50787 | |
890323 | 890323 | 93305 | 93305: Bakersfield | 2021-01-25 | Kern | 29 | 3677 | 39114 | |
890324 | 890324 | 93306 | 93306: Bakersfield | 2021-01-25 | Kern | 29 | 7788 | 70208 | |
890325 | 890325 | 93307 | 93307: Bakersfield | 2021-01-25 | Kern | 29 | 10273 | 84948 | |
890326 | 890326 | 93308 | 93308: Bakersfield | 2021-01-25 | Kern | 29 | 3786 | 54042 | |
890327 | 890327 | 93309 | 93309: Bakersfield | 2021-01-25 | Kern | 29 | 5746 | 60893 | |
890328 | 890328 | 93311 | 93311: Bakersfield | 2021-01-25 | Kern | 29 | 4261 | 44862 | |
890329 | 890329 | 93312 | 93312: Bakersfield | 2021-01-25 | Kern | 29 | 4774 | 59359 | |
890330 | 890330 | 93313 | 93313: Bakersfield | 2021-01-25 | Kern | 29 | 6523 | 51245 | |
890331 | 890331 | 93314 | 93314: Bakersfield | 2021-01-25 | Kern | 29 | 2695 | 26992 | |
890332 | 890332 | 93501 | 93501: Mojave | 2021-01-25 | Kern | 29 | 360 | 5063 | |
890333 | 890333 | 93505 | 93505: California City | 2021-01-25 | Kern | 29 | 1503 | 13445 | |
890334 | 890334 | 93516 | 93516: Boron | 2021-01-25 | Kern | 29 | 91 | 2425 | |
890335 | 890335 | 93518 | 93518: Caliente | 2021-01-25 | Kern | 29 | 22 | 995 | |
890336 | 890336 | 93519 | 93519: Cantil | 2021-01-25 | Kern | 29 | 0 | 28 | |
890337 | 890337 | 93523 | 93523: Edwards | 2021-01-25 | Kern | 29 | 58 | 3312 | |
890338 | 890338 | 93524 | 93524: Edwards | 2021-01-25 | Kern | 29 | 3 | 168 | |
890339 | 890339 | 93203 | 93203: Arvin | 2021-01-25 | Kern | 29 | 2712 | 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 );