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 93,192
- San Diego 27,500
- Riverside 16,192
- San Bernardino 16,000
- Alameda 14,840
- Kern 10,600
- Orange 10,373
- Placer 8,992
- Sonoma 8,928
- Fresno 7,520
- Contra Costa 7,260
- Tulare 6,972
- San Francisco 6,864
- San Mateo 6,330
- San Luis Obispo 5,742
- Ventura 5,675
- Monterey 4,995
- Napa 4,122
- Imperial 3,808
- Santa Clara 3,600
- Nevada 2,805
- Santa Barbara 2,794
- Merced 2,580
- Stanislaus 2,430
- Kings 2,025
- Sacramento 1,968
- El Dorado 1,963
- Solano 1,888
- Amador 1,568
- Yolo 1,230
- …
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
954966 | 954966 | Shingle Springs, Cameron Park, Rescue | Shingle Springs, Cameron Park, Rescue | 2020-12-04 | El Dorado | 17 | 411 | 35294 | |
954967 | 954967 | South County | South County | 2020-12-04 | El Dorado | 17 | 30 | 10345 | |
954968 | 954968 | Tahoe Region | Tahoe Region | 2020-12-04 | El Dorado | 17 | 1006 | 30275 | |
954969 | 954969 | Auberry | Auberry | 2020-12-04 | Fresno | 19 | 37 | 3994 | |
954970 | 954970 | Biola | Biola | 2020-12-04 | Fresno | 19 | 72 | 949 | |
954971 | 954971 | Cantua Creek | Cantua Creek | 2020-12-04 | Fresno | 19 | 47 | 1125 | |
954972 | 954972 | Caruthers | Caruthers | 2020-12-04 | Fresno | 19 | 318 | 5887 | |
954973 | 954973 | Clovis | Clovis | 2020-12-04 | Fresno | 19 | 2884 | 122949 | |
954974 | 954974 | Coalinga | Coalinga | 2020-12-04 | Fresno | 19 | 1061 | 19345 | |
954975 | 954975 | Del Rey | Del Rey | 2020-12-04 | Fresno | 19 | 150 | 2759 | |
954976 | 954976 | Dinuba | Dinuba | 2020-12-04 | Fresno | 19 | 0 | 0 | |
954977 | 954977 | Dos Palos | Dos Palos | 2020-12-04 | Fresno | 19 | 0 | ||
954978 | 954978 | Dunlap | Dunlap | 2020-12-04 | Fresno | 19 | 6 | ||
954979 | 954979 | Firebaugh | Firebaugh | 2020-12-04 | Fresno | 19 | 433 | 9965 | |
954980 | 954980 | Five Points | Five Points | 2020-12-04 | Fresno | 19 | 16 | 0 | |
954981 | 954981 | Fowler | Fowler | 2020-12-04 | Fresno | 19 | 351 | 7917 | |
954982 | 954982 | Fresno | Fresno | 2020-12-04 | Fresno | 19 | 22436 | 608579 | |
954983 | 954983 | Friant | Friant | 2020-12-04 | Fresno | 19 | 30 | 1930 | |
954984 | 954984 | Huron | Huron | 2020-12-04 | Fresno | 19 | 455 | 7579 | |
954985 | 954985 | Kerman | Kerman | 2020-12-04 | Fresno | 19 | 1135 | 21009 | |
954986 | 954986 | Kingsburg | Kingsburg | 2020-12-04 | Fresno | 19 | 547 | 17086 | |
954987 | 954987 | Laton | Laton | 2020-12-04 | Fresno | 19 | 161 | 3513 | |
954988 | 954988 | Mendota | Mendota | 2020-12-04 | Fresno | 19 | 1082 | 13576 | |
954989 | 954989 | Orange Cove | Orange Cove | 2020-12-04 | Fresno | 19 | 783 | 11320 | |
954990 | 954990 | Parlier | Parlier | 2020-12-04 | Fresno | 19 | 1385 | 17097 | |
954991 | 954991 | Prather | Prather | 2020-12-04 | Fresno | 19 | 14 | 0 | |
954992 | 954992 | Raisin | Raisin | 2020-12-04 | Fresno | 19 | 0 | 380 | |
954993 | 954993 | Reedley | Reedley | 2020-12-04 | Fresno | 19 | 1686 | 31129 | |
954994 | 954994 | Riverdale | Riverdale | 2020-12-04 | Fresno | 19 | 288 | 6459 | |
954995 | 954995 | San Joaquin | San Joaquin | 2020-12-04 | Fresno | 19 | 225 | 4633 | |
954996 | 954996 | Sanger | Sanger | 2020-12-04 | Fresno | 19 | 1786 | 38252 | |
954997 | 954997 | Selma | Selma | 2020-12-04 | Fresno | 19 | 1949 | 31726 | |
954998 | 954998 | Squaw Valley | Squaw Valley | 2020-12-04 | Fresno | 19 | 31 | 3908 | |
954999 | 954999 | Tollhouse | Tollhouse | 2020-12-04 | Fresno | 19 | 34 | 2712 | |
955000 | 955000 | Tranquillity | Tranquillity | 2020-12-04 | Fresno | 19 | 41 | 1132 | |
955001 | 955001 | 92222 | 92222: Bard | 2020-12-04 | Imperial | 25 | 2 | 0 | |
955002 | 955002 | 92227 | 92227: Brawley | 2020-12-04 | Imperial | 25 | 2589 | 27255 | |
955003 | 955003 | 92231 | 92231: Calexico | 2020-12-04 | Imperial | 25 | 5054 | 40019 | |
955004 | 955004 | 92233 | 92233: Calipatria | 2020-12-04 | Imperial | 25 | 610 | 7618 | |
955005 | 955005 | 92243 | 92243: El Centro | 2020-12-04 | Imperial | 25 | 0 | 50484 | |
955006 | 955006 | 92244 | 92244: El Centro | 2020-12-04 | Imperial | 25 | 1 | 0 | |
955007 | 955007 | 92249 | 92249: Heber | 2020-12-04 | Imperial | 25 | 735 | 7898 | |
955008 | 955008 | 92250 | 92250: Holtville | 2020-12-04 | Imperial | 25 | 685 | 8979 | |
955009 | 955009 | 92251 | 92251: Imperial | 2020-12-04 | Imperial | 25 | 1703 | 23388 | |
955010 | 955010 | 92257 | 92257: Niland | 2020-12-04 | Imperial | 25 | 58 | 1332 | |
955011 | 955011 | 92259 | 92259: Ocotillo | 2020-12-04 | Imperial | 25 | 4 | 94 | |
955012 | 955012 | 92266 | 92266: Palo Verde | 2020-12-04 | Imperial | 25 | 6 | 108 | |
955013 | 955013 | 92273 | 92273: Seeley | 2020-12-04 | Imperial | 25 | 113 | 1704 | |
955014 | 955014 | 92274 | 92274: Thermal | 2020-12-04 | Imperial | 25 | 237 | 15118 | |
955015 | 955015 | 92275 | 92275: Salton City | 2020-12-04 | Imperial | 25 | 29 | 2456 | |
955016 | 955016 | 92281 | 92281: Westmorland | 2020-12-04 | Imperial | 25 | 177 | 2859 | |
955017 | 955017 | 92283 | 92283: Winterhaven | 2020-12-04 | Imperial | 25 | 180 | 1694 | |
955018 | 955018 | 93226 | 93226: Glennville | 2020-12-04 | Kern | 29 | 4 | 195 | |
955019 | 955019 | 93238 | 93238: Kernville | 2020-12-04 | Kern | 29 | 24 | 1408 | |
955020 | 955020 | 93240 | 93240: Lake Isabella | 2020-12-04 | Kern | 29 | 77 | 6960 | |
955021 | 955021 | 93241 | 93241: Lamont | 2020-12-04 | Kern | 29 | 1167 | 16969 | |
955022 | 955022 | 93243 | 93243: Lebec | 2020-12-04 | Kern | 29 | 19 | 1709 | |
955023 | 955023 | 93249 | 93249: Lost Hills | 2020-12-04 | Kern | 29 | 120 | 2264 | |
955024 | 955024 | 93250 | 93250: Mc Farland | 2020-12-04 | Kern | 29 | 1225 | 15523 | |
955025 | 955025 | 93251 | 93251: Mc Kittrick | 2020-12-04 | Kern | 29 | 7 | 243 | |
955026 | 955026 | 93252 | 93252: Maricopa | 2020-12-04 | Kern | 29 | 35 | 3188 | |
955027 | 955027 | 93255 | 93255: Onyx | 2020-12-04 | Kern | 29 | 2 | 707 | |
955028 | 955028 | 93263 | 93263: Shafter | 2020-12-04 | Kern | 29 | 1705 | 20710 | |
955029 | 955029 | 93268 | 93268: Taft | 2020-12-04 | Kern | 29 | 686 | 17620 | |
955030 | 955030 | 93276 | 93276: Tupman | 2020-12-04 | Kern | 29 | 6 | 159 | |
955031 | 955031 | 93280 | 93280: Wasco | 2020-12-04 | Kern | 29 | 2072 | 27552 | |
955032 | 955032 | 93283 | 93283: Weldon | 2020-12-04 | Kern | 29 | 12 | 2086 | |
955033 | 955033 | 93285 | 93285: Wofford Heights | 2020-12-04 | Kern | 29 | 22 | 1723 | |
955034 | 955034 | 93287 | 93287: Woody | 2020-12-04 | Kern | 29 | 2 | 74 | |
955035 | 955035 | 93301 | 93301: Bakersfield | 2020-12-04 | Kern | 29 | 752 | 12345 | |
955036 | 955036 | 93304 | 93304: Bakersfield | 2020-12-04 | Kern | 29 | 2745 | 50787 | |
955037 | 955037 | 93305 | 93305: Bakersfield | 2020-12-04 | Kern | 29 | 1913 | 39114 | |
955038 | 955038 | 93306 | 93306: Bakersfield | 2020-12-04 | Kern | 29 | 4086 | 70208 | |
955039 | 955039 | 93307 | 93307: Bakersfield | 2020-12-04 | Kern | 29 | 5616 | 84948 | |
955040 | 955040 | 93308 | 93308: Bakersfield | 2020-12-04 | Kern | 29 | 1866 | 54042 | |
955041 | 955041 | 93309 | 93309: Bakersfield | 2020-12-04 | Kern | 29 | 2919 | 60893 | |
955042 | 955042 | 93311 | 93311: Bakersfield | 2020-12-04 | Kern | 29 | 2091 | 44862 | |
955043 | 955043 | 93312 | 93312: Bakersfield | 2020-12-04 | Kern | 29 | 2254 | 59359 | |
955044 | 955044 | 93313 | 93313: Bakersfield | 2020-12-04 | Kern | 29 | 3306 | 51245 | |
955045 | 955045 | 93314 | 93314: Bakersfield | 2020-12-04 | Kern | 29 | 1265 | 26992 | |
955046 | 955046 | 93501 | 93501: Mojave | 2020-12-04 | Kern | 29 | 82 | 5063 | |
955047 | 955047 | 93505 | 93505: California City | 2020-12-04 | Kern | 29 | 299 | 13445 | |
955048 | 955048 | 93516 | 93516: Boron | 2020-12-04 | Kern | 29 | 20 | 2425 | |
955049 | 955049 | 93518 | 93518: Caliente | 2020-12-04 | Kern | 29 | 7 | 995 | |
955050 | 955050 | 93519 | 93519: Cantil | 2020-12-04 | Kern | 29 | 0 | 28 | |
955051 | 955051 | 93523 | 93523: Edwards | 2020-12-04 | Kern | 29 | 21 | 3312 | |
955052 | 955052 | 93524 | 93524: Edwards | 2020-12-04 | Kern | 29 | 1 | 168 | |
955053 | 955053 | 93203 | 93203: Arvin | 2020-12-04 | Kern | 29 | 1531 | 22471 | |
955054 | 955054 | 93205 | 93205: Bodfish | 2020-12-04 | Kern | 29 | 15 | 1593 | |
955055 | 955055 | 93206 | 93206: Buttonwillow | 2020-12-04 | Kern | 29 | 135 | 2044 | |
955056 | 955056 | 93215 | 93215: Delano | 2020-12-04 | Kern | 29 | 3141 | 55845 | |
955057 | 955057 | 93220 | 93220: Edison | 2020-12-04 | Kern | 29 | 4 | 313 | |
955058 | 955058 | 93222 | 93222: Pine Mountain Club | 2020-12-04 | Kern | 29 | 10 | 1420 | |
955059 | 955059 | 93224 | 93224: Fellows | 2020-12-04 | Kern | 29 | 5 | 402 | |
955060 | 955060 | 93225 | 93225: Frazier Park | 2020-12-04 | Kern | 29 | 77 | 5319 | |
955061 | 955061 | 93527 | 93527: Inyokern | 2020-12-04 | Kern | 29 | 16 | 1852 | |
955062 | 955062 | 93528 | 93528: Johannesburg | 2020-12-04 | Kern | 29 | 0 | 124 | |
955063 | 955063 | 93531 | 93531: Keene | 2020-12-04 | Kern | 29 | 9 | 422 | |
955064 | 955064 | 93554 | 93554: Randsburg | 2020-12-04 | Kern | 29 | 0 | 143 | |
955065 | 955065 | 93555 | 93555: Ridgecrest | 2020-12-04 | Kern | 29 | 259 | 34075 |
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 );