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 347,352
- San Diego 106,700
- Riverside 62,272
- San Bernardino 62,080
- Alameda 53,000
- Kern 46,600
- Orange 39,893
- Marin 36,570
- Sonoma 31,968
- Placer 31,264
- Fresno 30,555
- Contra Costa 28,860
- San Mateo 27,930
- Tulare 27,132
- San Francisco 25,584
- Monterey 24,435
- Ventura 23,675
- San Luis Obispo 21,582
- Napa 17,082
- Imperial 16,048
- Nevada 15,045
- Santa Clara 14,400
- Lake 11,505
- Santa Barbara 10,714
- Merced 9,780
- Calaveras 8,592
- Kings 8,505
- Stanislaus 7,780
- Sacramento 7,728
- Solano 7,648
- …
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
42161 | 42161 | Coalinga | Coalinga | 2022-11-24 | Fresno | 19 | 7605 | 19345 | |
42162 | 42162 | Del Rey | Del Rey | 2022-11-24 | Fresno | 19 | 756 | 2759 | |
42163 | 42163 | Dinuba | Dinuba | 2022-11-24 | Fresno | 19 | 125 | 0 | |
42164 | 42164 | Dos Palos | Dos Palos | 2022-11-24 | Fresno | 19 | 103 | ||
42165 | 42165 | Dunlap | Dunlap | 2022-11-24 | Fresno | 19 | 88 | ||
42166 | 42166 | Firebaugh | Firebaugh | 2022-11-24 | Fresno | 19 | 2608 | 9965 | |
42167 | 42167 | Five Points | Five Points | 2022-11-24 | Fresno | 19 | 153 | 0 | |
42168 | 42168 | Fowler | Fowler | 2022-11-24 | Fresno | 19 | 2685 | 7917 | |
42169 | 42169 | Fresno | Fresno | 2022-11-24 | Fresno | 19 | 169494 | 608579 | |
42170 | 42170 | Friant | Friant | 2022-11-24 | Fresno | 19 | 311 | 1930 | |
42171 | 42171 | Huron | Huron | 2022-11-24 | Fresno | 19 | 1828 | 7579 | |
42172 | 42172 | Kerman | Kerman | 2022-11-24 | Fresno | 19 | 6028 | 21009 | |
42173 | 42173 | Kingsburg | Kingsburg | 2022-11-24 | Fresno | 19 | 3548 | 17086 | |
42174 | 42174 | Laton | Laton | 2022-11-24 | Fresno | 19 | 877 | 3513 | |
42175 | 42175 | Mendota | Mendota | 2022-11-24 | Fresno | 19 | 3598 | 13576 | |
42176 | 42176 | Orange Cove | Orange Cove | 2022-11-24 | Fresno | 19 | 3531 | 11320 | |
42177 | 42177 | Parlier | Parlier | 2022-11-24 | Fresno | 19 | 5795 | 17097 | |
42178 | 42178 | Prather | Prather | 2022-11-24 | Fresno | 19 | 196 | 0 | |
42179 | 42179 | Raisin | Raisin | 2022-11-24 | Fresno | 19 | 149 | 380 | |
42180 | 42180 | Reedley | Reedley | 2022-11-24 | Fresno | 19 | 8822 | 31129 | |
42181 | 42181 | Riverdale | Riverdale | 2022-11-24 | Fresno | 19 | 1884 | 6459 | |
42182 | 42182 | San Joaquin | San Joaquin | 2022-11-24 | Fresno | 19 | 1197 | 4633 | |
42183 | 42183 | Sanger | Sanger | 2022-11-24 | Fresno | 19 | 11953 | 38252 | |
42184 | 42184 | Selma | Selma | 2022-11-24 | Fresno | 19 | 10572 | 31726 | |
42185 | 42185 | Squaw Valley | Squaw Valley | 2022-11-24 | Fresno | 19 | 418 | 3908 | |
42186 | 42186 | Tollhouse | Tollhouse | 2022-11-24 | Fresno | 19 | 297 | 2712 | |
42187 | 42187 | Tranquillity | Tranquillity | 2022-11-24 | Fresno | 19 | 273 | 1132 | |
42188 | 42188 | Greater Fortuna Area | Greater Fortuna Area | 2022-11-24 | Humboldt | 23 | 2867 | 20858 | |
42189 | 42189 | Greater Humboldt Bay | Greater Humboldt Bay | 2022-11-24 | Humboldt | 23 | 9964 | 78013 | |
42190 | 42190 | North | North | 2022-11-24 | Humboldt | 23 | 3794 | 30236 | |
42191 | 42191 | South | South | 2022-11-24 | Humboldt | 23 | 899 | 7601 | |
42192 | 42192 | 92222 | 92222: Bard | 2022-11-24 | Imperial | 25 | 13 | 0 | |
42193 | 42193 | 92227 | 92227: Brawley | 2022-11-24 | Imperial | 25 | 10307 | 27255 | |
42194 | 42194 | 92231 | 92231: Calexico | 2022-11-24 | Imperial | 25 | 14979 | 40019 | |
42195 | 42195 | 92233 | 92233: Calipatria | 2022-11-24 | Imperial | 25 | 1242 | 7618 | |
42196 | 42196 | 92243 | 92243: El Centro | 2022-11-24 | Imperial | 25 | 16174 | 50484 | |
42197 | 42197 | 92244 | 92244: El Centro | 2022-11-24 | Imperial | 25 | 262 | 0 | |
42198 | 42198 | 92249 | 92249: Heber | 2022-11-24 | Imperial | 25 | 2391 | 7898 | |
42199 | 42199 | 92250 | 92250: Holtville | 2022-11-24 | Imperial | 25 | 2356 | 8979 | |
42200 | 42200 | 92251 | 92251: Imperial | 2022-11-24 | Imperial | 25 | 7688 | 23388 | |
42201 | 42201 | 92257 | 92257: Niland | 2022-11-24 | Imperial | 25 | 362 | 1332 | |
42202 | 42202 | 92259 | 92259: Ocotillo | 2022-11-24 | Imperial | 25 | 38 | 94 | |
42203 | 42203 | 92266 | 92266: Palo Verde | 2022-11-24 | Imperial | 25 | 19 | 108 | |
42204 | 42204 | 92273 | 92273: Seeley | 2022-11-24 | Imperial | 25 | 475 | 1704 | |
42205 | 42205 | 92274 | 92274: Thermal | 2022-11-24 | Imperial | 25 | 1157 | 15118 | |
42206 | 42206 | 92275 | 92275: Salton City | 2022-11-24 | Imperial | 25 | 71 | 2456 | |
42207 | 42207 | 92281 | 92281: Westmorland | 2022-11-24 | Imperial | 25 | 666 | 2859 | |
42208 | 42208 | 92283 | 92283: Winterhaven | 2022-11-24 | Imperial | 25 | 928 | 1694 | |
42209 | 42209 | 93226 | 93226: Glennville | 2022-11-24 | Kern | 29 | 49 | 195 | |
42210 | 42210 | 93238 | 93238: Kernville | 2022-11-24 | Kern | 29 | 232 | 1408 | |
42211 | 42211 | 93240 | 93240: Lake Isabella | 2022-11-24 | Kern | 29 | 1227 | 6960 | |
42212 | 42212 | 93241 | 93241: Lamont | 2022-11-24 | Kern | 29 | 5487 | 16969 | |
42213 | 42213 | 93243 | 93243: Lebec | 2022-11-24 | Kern | 29 | 274 | 1709 | |
42214 | 42214 | 93249 | 93249: Lost Hills | 2022-11-24 | Kern | 29 | 653 | 2264 | |
42215 | 42215 | 93250 | 93250: Mc Farland | 2022-11-24 | Kern | 29 | 5242 | 15523 | |
42216 | 42216 | 93251 | 93251: Mc Kittrick | 2022-11-24 | Kern | 29 | 69 | 243 | |
42217 | 42217 | 93252 | 93252: Maricopa | 2022-11-24 | Kern | 29 | 329 | 3188 | |
42218 | 42218 | 93255 | 93255: Onyx | 2022-11-24 | Kern | 29 | 58 | 707 | |
42219 | 42219 | 93263 | 93263: Shafter | 2022-11-24 | Kern | 29 | 7849 | 20710 | |
42220 | 42220 | 93268 | 93268: Taft | 2022-11-24 | Kern | 29 | 4875 | 17620 | |
42221 | 42221 | 93276 | 93276: Tupman | 2022-11-24 | Kern | 29 | 66 | 159 | |
42222 | 42222 | 93280 | 93280: Wasco | 2022-11-24 | Kern | 29 | 12817 | 27552 | |
42223 | 42223 | 93283 | 93283: Weldon | 2022-11-24 | Kern | 29 | 273 | 2086 | |
42224 | 42224 | 93285 | 93285: Wofford Heights | 2022-11-24 | Kern | 29 | 359 | 1723 | |
42225 | 42225 | 93287 | 93287: Woody | 2022-11-24 | Kern | 29 | 29 | 74 | |
42226 | 42226 | 93301 | 93301: Bakersfield | 2022-11-24 | Kern | 29 | 5243 | 12345 | |
42227 | 42227 | 93304 | 93304: Bakersfield | 2022-11-24 | Kern | 29 | 16980 | 50787 | |
42228 | 42228 | 93305 | 93305: Bakersfield | 2022-11-24 | Kern | 29 | 12409 | 39114 | |
42229 | 42229 | 93306 | 93306: Bakersfield | 2022-11-24 | Kern | 29 | 25062 | 70208 | |
42230 | 42230 | 93307 | 93307: Bakersfield | 2022-11-24 | Kern | 29 | 29575 | 84948 | |
42231 | 42231 | 93308 | 93308: Bakersfield | 2022-11-24 | Kern | 29 | 15619 | 54042 | |
42232 | 42232 | 93309 | 93309: Bakersfield | 2022-11-24 | Kern | 29 | 19512 | 60893 | |
42233 | 42233 | 93311 | 93311: Bakersfield | 2022-11-24 | Kern | 29 | 15507 | 44862 | |
42234 | 42234 | 93312 | 93312: Bakersfield | 2022-11-24 | Kern | 29 | 18413 | 59359 | |
42235 | 42235 | 93313 | 93313: Bakersfield | 2022-11-24 | Kern | 29 | 19701 | 51245 | |
42236 | 42236 | 93314 | 93314: Bakersfield | 2022-11-24 | Kern | 29 | 10285 | 26992 | |
42237 | 42237 | 93501 | 93501: Mojave | 2022-11-24 | Kern | 29 | 1210 | 5063 | |
42238 | 42238 | 93505 | 93505: California City | 2022-11-24 | Kern | 29 | 4236 | 13445 | |
42239 | 42239 | 93516 | 93516: Boron | 2022-11-24 | Kern | 29 | 501 | 2425 | |
42240 | 42240 | 93518 | 93518: Caliente | 2022-11-24 | Kern | 29 | 111 | 995 | |
42241 | 42241 | 93519 | 93519: Cantil | 2022-11-24 | Kern | 29 | 3 | 28 | |
42242 | 42242 | 93523 | 93523: Edwards | 2022-11-24 | Kern | 29 | 443 | 3312 | |
42243 | 42243 | 93524 | 93524: Edwards | 2022-11-24 | Kern | 29 | 54 | 168 | |
42244 | 42244 | 93203 | 93203: Arvin | 2022-11-24 | Kern | 29 | 7141 | 22471 | |
42245 | 42245 | 93205 | 93205: Bodfish | 2022-11-24 | Kern | 29 | 384 | 1593 | |
42246 | 42246 | 93206 | 93206: Buttonwillow | 2022-11-24 | Kern | 29 | 585 | 2044 | |
42247 | 42247 | 93215 | 93215: Delano | 2022-11-24 | Kern | 29 | 22439 | 55845 | |
42248 | 42248 | 93220 | 93220: Edison | 2022-11-24 | Kern | 29 | 37 | 313 | |
42249 | 42249 | 93222 | 93222: Pine Mountain Club | 2022-11-24 | Kern | 29 | 198 | 1420 | |
42250 | 42250 | 93224 | 93224: Fellows | 2022-11-24 | Kern | 29 | 110 | 402 | |
42251 | 42251 | 93225 | 93225: Frazier Park | 2022-11-24 | Kern | 29 | 909 | 5319 | |
42252 | 42252 | 93527 | 93527: Inyokern | 2022-11-24 | Kern | 29 | 379 | 1852 | |
42253 | 42253 | 93528 | 93528: Johannesburg | 2022-11-24 | Kern | 29 | 17 | 124 | |
42254 | 42254 | 93531 | 93531: Keene | 2022-11-24 | Kern | 29 | 94 | 422 | |
42255 | 42255 | 93554 | 93554: Randsburg | 2022-11-24 | Kern | 29 | 11 | 143 | |
42256 | 42256 | 93555 | 93555: Ridgecrest | 2022-11-24 | Kern | 29 | 7502 | 34075 | |
42257 | 42257 | 93560 | 93560: Rosamond | 2022-11-24 | Kern | 29 | 5982 | 20797 | |
42258 | 42258 | 93561 | 93561: Tehachapi | 2022-11-24 | Kern | 29 | 10193 | 34271 | |
42259 | 42259 | Armona | Armona | 2022-11-24 | Kings | 31 | 1718 | 3795 | |
42260 | 42260 | Avenal | Avenal | 2022-11-24 | Kings | 31 | 7678 | 12923 |
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 );