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 325,113
- San Diego 99,770
- Riverside 58,240
- San Bernardino 58,048
- Alameda 49,661
- Kern 43,450
- Orange 37,310
- Marin 33,231
- Placer 30,016
- Sonoma 29,952
- Fresno 28,539
- Contra Costa 26,970
- San Mateo 26,040
- Tulare 25,368
- San Francisco 23,946
- Monterey 22,734
- Ventura 22,100
- San Luis Obispo 20,196
- Napa 15,948
- Imperial 14,977
- Nevada 13,974
- Santa Clara 13,455
- Lake 10,560
- Santa Barbara 10,021
- Merced 9,150
- Kings 7,938
- Calaveras 7,836
- Stanislaus 7,780
- Sacramento 7,224
- Solano 7,144
- …
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
120962 | 120962 | Coalinga | Coalinga | 2022-09-22 | Fresno | 19 | 7454 | 19345 | |
120963 | 120963 | Del Rey | Del Rey | 2022-09-22 | Fresno | 19 | 749 | 2759 | |
120964 | 120964 | Dinuba | Dinuba | 2022-09-22 | Fresno | 19 | 120 | 0 | |
120965 | 120965 | Dos Palos | Dos Palos | 2022-09-22 | Fresno | 19 | 98 | ||
120966 | 120966 | Dunlap | Dunlap | 2022-09-22 | Fresno | 19 | 83 | ||
120967 | 120967 | Firebaugh | Firebaugh | 2022-09-22 | Fresno | 19 | 2582 | 9965 | |
120968 | 120968 | Five Points | Five Points | 2022-09-22 | Fresno | 19 | 150 | 0 | |
120969 | 120969 | Fowler | Fowler | 2022-09-22 | Fresno | 19 | 2628 | 7917 | |
120970 | 120970 | Fresno | Fresno | 2022-09-22 | Fresno | 19 | 166044 | 608579 | |
120971 | 120971 | Friant | Friant | 2022-09-22 | Fresno | 19 | 296 | 1930 | |
120972 | 120972 | Huron | Huron | 2022-09-22 | Fresno | 19 | 1807 | 7579 | |
120973 | 120973 | Kerman | Kerman | 2022-09-22 | Fresno | 19 | 5957 | 21009 | |
120974 | 120974 | Kingsburg | Kingsburg | 2022-09-22 | Fresno | 19 | 3483 | 17086 | |
120975 | 120975 | Laton | Laton | 2022-09-22 | Fresno | 19 | 851 | 3513 | |
120976 | 120976 | Mendota | Mendota | 2022-09-22 | Fresno | 19 | 3570 | 13576 | |
120977 | 120977 | Orange Cove | Orange Cove | 2022-09-22 | Fresno | 19 | 3489 | 11320 | |
120978 | 120978 | Parlier | Parlier | 2022-09-22 | Fresno | 19 | 5742 | 17097 | |
120979 | 120979 | Prather | Prather | 2022-09-22 | Fresno | 19 | 188 | 0 | |
120980 | 120980 | Raisin | Raisin | 2022-09-22 | Fresno | 19 | 148 | 380 | |
120981 | 120981 | Reedley | Reedley | 2022-09-22 | Fresno | 19 | 8671 | 31129 | |
120982 | 120982 | Riverdale | Riverdale | 2022-09-22 | Fresno | 19 | 1839 | 6459 | |
120983 | 120983 | San Joaquin | San Joaquin | 2022-09-22 | Fresno | 19 | 1188 | 4633 | |
120984 | 120984 | Sanger | Sanger | 2022-09-22 | Fresno | 19 | 11800 | 38252 | |
120985 | 120985 | Selma | Selma | 2022-09-22 | Fresno | 19 | 10425 | 31726 | |
120986 | 120986 | Squaw Valley | Squaw Valley | 2022-09-22 | Fresno | 19 | 412 | 3908 | |
120987 | 120987 | Tollhouse | Tollhouse | 2022-09-22 | Fresno | 19 | 289 | 2712 | |
120988 | 120988 | Tranquillity | Tranquillity | 2022-09-22 | Fresno | 19 | 270 | 1132 | |
120989 | 120989 | Greater Fortuna Area | Greater Fortuna Area | 2022-09-22 | Humboldt | 23 | 2838 | 20858 | |
120990 | 120990 | Greater Humboldt Bay | Greater Humboldt Bay | 2022-09-22 | Humboldt | 23 | 9751 | 78013 | |
120991 | 120991 | North | North | 2022-09-22 | Humboldt | 23 | 3690 | 30236 | |
120992 | 120992 | South | South | 2022-09-22 | Humboldt | 23 | 884 | 7601 | |
120993 | 120993 | 92222 | 92222: Bard | 2022-09-22 | Imperial | 25 | 13 | 0 | |
120994 | 120994 | 92227 | 92227: Brawley | 2022-09-22 | Imperial | 25 | 10307 | 27255 | |
120995 | 120995 | 92231 | 92231: Calexico | 2022-09-22 | Imperial | 25 | 14979 | 40019 | |
120996 | 120996 | 92233 | 92233: Calipatria | 2022-09-22 | Imperial | 25 | 1242 | 7618 | |
120997 | 120997 | 92243 | 92243: El Centro | 2022-09-22 | Imperial | 25 | 16174 | 50484 | |
120998 | 120998 | 92244 | 92244: El Centro | 2022-09-22 | Imperial | 25 | 262 | 0 | |
120999 | 120999 | 92249 | 92249: Heber | 2022-09-22 | Imperial | 25 | 2391 | 7898 | |
121000 | 121000 | 92250 | 92250: Holtville | 2022-09-22 | Imperial | 25 | 2356 | 8979 | |
121001 | 121001 | 92251 | 92251: Imperial | 2022-09-22 | Imperial | 25 | 7688 | 23388 | |
121002 | 121002 | 92257 | 92257: Niland | 2022-09-22 | Imperial | 25 | 362 | 1332 | |
121003 | 121003 | 92259 | 92259: Ocotillo | 2022-09-22 | Imperial | 25 | 38 | 94 | |
121004 | 121004 | 92266 | 92266: Palo Verde | 2022-09-22 | Imperial | 25 | 19 | 108 | |
121005 | 121005 | 92273 | 92273: Seeley | 2022-09-22 | Imperial | 25 | 475 | 1704 | |
121006 | 121006 | 92274 | 92274: Thermal | 2022-09-22 | Imperial | 25 | 1157 | 15118 | |
121007 | 121007 | 92275 | 92275: Salton City | 2022-09-22 | Imperial | 25 | 71 | 2456 | |
121008 | 121008 | 92281 | 92281: Westmorland | 2022-09-22 | Imperial | 25 | 666 | 2859 | |
121009 | 121009 | 92283 | 92283: Winterhaven | 2022-09-22 | Imperial | 25 | 928 | 1694 | |
121010 | 121010 | 93226 | 93226: Glennville | 2022-09-22 | Kern | 29 | 47 | 195 | |
121011 | 121011 | 93238 | 93238: Kernville | 2022-09-22 | Kern | 29 | 225 | 1408 | |
121012 | 121012 | 93240 | 93240: Lake Isabella | 2022-09-22 | Kern | 29 | 1198 | 6960 | |
121013 | 121013 | 93241 | 93241: Lamont | 2022-09-22 | Kern | 29 | 5357 | 16969 | |
121014 | 121014 | 93243 | 93243: Lebec | 2022-09-22 | Kern | 29 | 270 | 1709 | |
121015 | 121015 | 93249 | 93249: Lost Hills | 2022-09-22 | Kern | 29 | 639 | 2264 | |
121016 | 121016 | 93250 | 93250: Mc Farland | 2022-09-22 | Kern | 29 | 5167 | 15523 | |
121017 | 121017 | 93251 | 93251: Mc Kittrick | 2022-09-22 | Kern | 29 | 68 | 243 | |
121018 | 121018 | 93252 | 93252: Maricopa | 2022-09-22 | Kern | 29 | 316 | 3188 | |
121019 | 121019 | 93255 | 93255: Onyx | 2022-09-22 | Kern | 29 | 56 | 707 | |
121020 | 121020 | 93263 | 93263: Shafter | 2022-09-22 | Kern | 29 | 7704 | 20710 | |
121021 | 121021 | 93268 | 93268: Taft | 2022-09-22 | Kern | 29 | 4749 | 17620 | |
121022 | 121022 | 93276 | 93276: Tupman | 2022-09-22 | Kern | 29 | 65 | 159 | |
121023 | 121023 | 93280 | 93280: Wasco | 2022-09-22 | Kern | 29 | 12671 | 27552 | |
121024 | 121024 | 93283 | 93283: Weldon | 2022-09-22 | Kern | 29 | 266 | 2086 | |
121025 | 121025 | 93285 | 93285: Wofford Heights | 2022-09-22 | Kern | 29 | 344 | 1723 | |
121026 | 121026 | 93287 | 93287: Woody | 2022-09-22 | Kern | 29 | 29 | 74 | |
121027 | 121027 | 93301 | 93301: Bakersfield | 2022-09-22 | Kern | 29 | 5042 | 12345 | |
121028 | 121028 | 93304 | 93304: Bakersfield | 2022-09-22 | Kern | 29 | 16572 | 50787 | |
121029 | 121029 | 93305 | 93305: Bakersfield | 2022-09-22 | Kern | 29 | 12070 | 39114 | |
121030 | 121030 | 93306 | 93306: Bakersfield | 2022-09-22 | Kern | 29 | 24349 | 70208 | |
121031 | 121031 | 93307 | 93307: Bakersfield | 2022-09-22 | Kern | 29 | 28907 | 84948 | |
121032 | 121032 | 93308 | 93308: Bakersfield | 2022-09-22 | Kern | 29 | 15071 | 54042 | |
121033 | 121033 | 93309 | 93309: Bakersfield | 2022-09-22 | Kern | 29 | 18850 | 60893 | |
121034 | 121034 | 93311 | 93311: Bakersfield | 2022-09-22 | Kern | 29 | 15014 | 44862 | |
121035 | 121035 | 93312 | 93312: Bakersfield | 2022-09-22 | Kern | 29 | 17773 | 59359 | |
121036 | 121036 | 93313 | 93313: Bakersfield | 2022-09-22 | Kern | 29 | 19224 | 51245 | |
121037 | 121037 | 93314 | 93314: Bakersfield | 2022-09-22 | Kern | 29 | 9962 | 26992 | |
121038 | 121038 | 93501 | 93501: Mojave | 2022-09-22 | Kern | 29 | 1191 | 5063 | |
121039 | 121039 | 93505 | 93505: California City | 2022-09-22 | Kern | 29 | 4124 | 13445 | |
121040 | 121040 | 93516 | 93516: Boron | 2022-09-22 | Kern | 29 | 491 | 2425 | |
121041 | 121041 | 93518 | 93518: Caliente | 2022-09-22 | Kern | 29 | 106 | 995 | |
121042 | 121042 | 93519 | 93519: Cantil | 2022-09-22 | Kern | 29 | 3 | 28 | |
121043 | 121043 | 93523 | 93523: Edwards | 2022-09-22 | Kern | 29 | 433 | 3312 | |
121044 | 121044 | 93524 | 93524: Edwards | 2022-09-22 | Kern | 29 | 54 | 168 | |
121045 | 121045 | 93203 | 93203: Arvin | 2022-09-22 | Kern | 29 | 7000 | 22471 | |
121046 | 121046 | 93205 | 93205: Bodfish | 2022-09-22 | Kern | 29 | 375 | 1593 | |
121047 | 121047 | 93206 | 93206: Buttonwillow | 2022-09-22 | Kern | 29 | 575 | 2044 | |
121048 | 121048 | 93215 | 93215: Delano | 2022-09-22 | Kern | 29 | 22060 | 55845 | |
121049 | 121049 | 93220 | 93220: Edison | 2022-09-22 | Kern | 29 | 37 | 313 | |
121050 | 121050 | 93222 | 93222: Pine Mountain Club | 2022-09-22 | Kern | 29 | 188 | 1420 | |
121051 | 121051 | 93224 | 93224: Fellows | 2022-09-22 | Kern | 29 | 108 | 402 | |
121052 | 121052 | 93225 | 93225: Frazier Park | 2022-09-22 | Kern | 29 | 894 | 5319 | |
121053 | 121053 | 93527 | 93527: Inyokern | 2022-09-22 | Kern | 29 | 361 | 1852 | |
121054 | 121054 | 93528 | 93528: Johannesburg | 2022-09-22 | Kern | 29 | 15 | 124 | |
121055 | 121055 | 93531 | 93531: Keene | 2022-09-22 | Kern | 29 | 86 | 422 | |
121056 | 121056 | 93554 | 93554: Randsburg | 2022-09-22 | Kern | 29 | 11 | 143 | |
121057 | 121057 | 93555 | 93555: Ridgecrest | 2022-09-22 | Kern | 29 | 7217 | 34075 | |
121058 | 121058 | 93560 | 93560: Rosamond | 2022-09-22 | Kern | 29 | 5881 | 20797 | |
121059 | 121059 | 93561 | 93561: Tehachapi | 2022-09-22 | Kern | 29 | 10014 | 34271 | |
121060 | 121060 | Armona | Armona | 2022-09-22 | Kings | 31 | 1701 | 3795 | |
121061 | 121061 | Avenal | Avenal | 2022-09-22 | Kings | 31 | 7533 | 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 );