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 134,140
- San Diego 40,370
- Riverside 23,680
- San Bernardino 23,488
- Alameda 21,041
- Kern 16,400
- Orange 15,170
- Placer 12,736
- Sonoma 12,672
- Fresno 11,232
- Contra Costa 10,770
- Tulare 10,248
- San Francisco 9,906
- San Mateo 9,840
- Ventura 8,600
- San Luis Obispo 8,316
- Monterey 8,127
- Napa 6,210
- Imperial 5,780
- Santa Clara 5,355
- Nevada 4,779
- Marin 4,558
- Santa Barbara 4,081
- Merced 3,740
- Stanislaus 3,600
- Kings 3,069
- Sacramento 2,904
- El Dorado 2,896
- Solano 2,824
- Lake 2,445
- …
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
807927 | 807927 | 96161 | 96161: Truckee | 2021-03-31 | Nevada | 57 | 1005 | 18333 | |
807928 | 807928 | 96162 | 96162: Truckee | 2021-03-31 | Nevada | 57 | 65 | 0 | |
807929 | 807929 | Aliso Viejo | Aliso Viejo | 2021-03-31 | Orange | 59 | 2243 | 51372 | |
807930 | 807930 | Anaheim | Anaheim | 2021-03-31 | Orange | 59 | 41489 | 359339 | |
807931 | 807931 | Brea | Brea | 2021-03-31 | Orange | 59 | 2723 | 45606 | |
807932 | 807932 | Buena Park | Buena Park | 2021-03-31 | Orange | 59 | 7703 | 83384 | |
807933 | 807933 | Costa Mesa | Costa Mesa | 2021-03-31 | Orange | 59 | 8849 | 115830 | |
807934 | 807934 | Coto de Caza | Coto de Caza | 2021-03-31 | Orange | 59 | 192 | 14931 | |
807935 | 807935 | Cypress | Cypress | 2021-03-31 | Orange | 59 | 2903 | 49833 | |
807936 | 807936 | Dana Point | Dana Point | 2021-03-31 | Orange | 59 | 1482 | 34249 | |
807937 | 807937 | Fountain Valley | Fountain Valley | 2021-03-31 | Orange | 59 | 3467 | 56652 | |
807938 | 807938 | Fullerton | Fullerton | 2021-03-31 | Orange | 59 | 11224 | 142824 | |
807939 | 807939 | Garden Grove | Garden Grove | 2021-03-31 | Orange | 59 | 16453 | 175155 | |
807940 | 807940 | Huntington Beach | Huntington Beach | 2021-03-31 | Orange | 59 | 10518 | 203761 | |
807941 | 807941 | Irvine | Irvine | 2021-03-31 | Orange | 59 | 10379 | 280202 | |
807942 | 807942 | La Habra | La Habra | 2021-03-31 | Orange | 59 | 6352 | 63542 | |
807943 | 807943 | La Palma | La Palma | 2021-03-31 | Orange | 59 | 851 | 15820 | |
807944 | 807944 | Ladera Ranch | Ladera Ranch | 2021-03-31 | Orange | 59 | 891 | 30288 | |
807945 | 807945 | Laguna Beach | Laguna Beach | 2021-03-31 | Orange | 59 | 822 | 23358 | |
807946 | 807946 | Laguna Hills | Laguna Hills | 2021-03-31 | Orange | 59 | 1696 | 31572 | |
807947 | 807947 | Laguna Niguel | Laguna Niguel | 2021-03-31 | Orange | 59 | 2503 | 66748 | |
807948 | 807948 | Laguna Woods | Laguna Woods | 2021-03-31 | Orange | 59 | 407 | 16518 | |
807949 | 807949 | Lake Forest | Lake Forest | 2021-03-31 | Orange | 59 | 4096 | 86346 | |
807950 | 807950 | Los Alamitos | Los Alamitos | 2021-03-31 | Orange | 59 | 1078 | 11721 | |
807951 | 807951 | Midway City | Midway City | 2021-03-31 | Orange | 59 | 797 | 8374 | |
807952 | 807952 | Mission Viejo | Mission Viejo | 2021-03-31 | Orange | 59 | 4411 | 96434 | |
807953 | 807953 | Newport Beach | Newport Beach | 2021-03-31 | Orange | 59 | 3752 | 87180 | |
807954 | 807954 | Orange | Orange | 2021-03-31 | Orange | 59 | 11754 | 141691 | |
807955 | 807955 | Placentia | Placentia | 2021-03-31 | Orange | 59 | 4210 | 52333 | |
807956 | 807956 | Rancho Mission Viejo | Rancho Mission Viejo | 2021-03-31 | Orange | 59 | 329 | 0 | |
807957 | 807957 | Rancho Santa Margarita | Rancho Santa Margarita | 2021-03-31 | Orange | 59 | 1914 | 48960 | |
807958 | 807958 | Rossmoor | Rossmoor | 2021-03-31 | Orange | 59 | 126 | 11160 | |
807959 | 807959 | San Clemente | San Clemente | 2021-03-31 | Orange | 59 | 2924 | 65405 | |
807960 | 807960 | San Juan Capistrano | San Juan Capistrano | 2021-03-31 | Orange | 59 | 2723 | 36821 | |
807961 | 807961 | Santa Ana | Santa Ana | 2021-03-31 | Orange | 59 | 44557 | 337716 | |
807962 | 807962 | Seal Beach | Seal Beach | 2021-03-31 | Orange | 59 | 1122 | 25073 | |
807963 | 807963 | Silverado | Silverado | 2021-03-31 | Orange | 59 | 87 | 0 | |
807964 | 807964 | Stanton | Stanton | 2021-03-31 | Orange | 59 | 3146 | 39307 | |
807965 | 807965 | Trabuco Canyon | Trabuco Canyon | 2021-03-31 | Orange | 59 | 942 | 0 | |
807966 | 807966 | Tustin | Tustin | 2021-03-31 | Orange | 59 | 6124 | 81369 | |
807967 | 807967 | Villa Park | Villa Park | 2021-03-31 | Orange | 59 | 297 | 5933 | |
807968 | 807968 | Westminster | Westminster | 2021-03-31 | Orange | 59 | 7080 | 92610 | |
807969 | 807969 | Yorba Linda | Yorba Linda | 2021-03-31 | Orange | 59 | 4095 | 68706 | |
807970 | 807970 | 95602 | 95602: Auburn | 2021-03-31 | Placer | 61 | 794 | 17817 | |
807971 | 807971 | 95603 | 95603: Auburn | 2021-03-31 | Placer | 61 | 1436 | 27256 | |
807972 | 807972 | 95626 | 95626: Elverta | 2021-03-31 | Placer | 61 | 23 | 6371 | |
807973 | 807973 | 95631 | 95631: Foresthill | 2021-03-31 | Placer | 61 | 205 | 6387 | |
807974 | 807974 | 95648 | 95648: Lincoln | 2021-03-31 | Placer | 61 | 2763 | 51257 | |
807975 | 807975 | 95650 | 95650: Loomis | 2021-03-31 | Placer | 61 | 646 | 12986 | |
807976 | 807976 | 95658 | 95658: Newcastle | 2021-03-31 | Placer | 61 | 279 | 6751 | |
807977 | 807977 | 95661 | 95661: Roseville | 2021-03-31 | Placer | 61 | 1995 | 30470 | |
807978 | 807978 | 95663 | 95663: Penryn | 2021-03-31 | Placer | 61 | 144 | 2102 | |
807979 | 807979 | 95677 | 95677: Rocklin | 2021-03-31 | Placer | 61 | 1407 | 23121 | |
807980 | 807980 | 95678 | 95678: Roseville | 2021-03-31 | Placer | 61 | 2640 | 41221 | |
807981 | 807981 | 95681 | 95681: Sheridan | 2021-03-31 | Placer | 61 | 69 | 1241 | |
807982 | 807982 | 95701 | 95701: Alta | 2021-03-31 | Placer | 61 | 35 | 842 | |
807983 | 807983 | 95703 | 95703: Applegate | 2021-03-31 | Placer | 61 | 83 | 3023 | |
807984 | 807984 | 95713 | 95713: Colfax | 2021-03-31 | Placer | 61 | 281 | 8927 | |
807985 | 807985 | 95714 | 95714: Dutch Flat | 2021-03-31 | Placer | 61 | 11 | 701 | |
807986 | 807986 | 95715 | 95715: Emigrant Gap | 2021-03-31 | Placer | 61 | 7 | 0 | |
807987 | 807987 | 95717 | 95717: Gold Run | 2021-03-31 | Placer | 61 | 5 | 5 or fewer | 0 |
807988 | 807988 | 95722 | 95722: Meadow Vista | 2021-03-31 | Placer | 61 | 178 | 4933 | |
807989 | 807989 | 95724 | 95724: Norden | 2021-03-31 | Placer | 61 | 5 | 5 or fewer | 0 |
807990 | 807990 | 95746 | 95746: Granite Bay | 2021-03-31 | Placer | 61 | 912 | 21786 | |
807991 | 807991 | 95747 | 95747: Roseville | 2021-03-31 | Placer | 61 | 3746 | 59715 | |
807992 | 807992 | 95765 | 95765: Rocklin | 2021-03-31 | Placer | 61 | 2105 | 37002 | |
807993 | 807993 | 96140 | 96140: Carnelian Bay | 2021-03-31 | Placer | 61 | 51 | 1659 | |
807994 | 807994 | 96141 | 96141: Homewood | 2021-03-31 | Placer | 61 | 10 | 933 | |
807995 | 807995 | 96142 | 96142: Tahoma | 2021-03-31 | Placer | 61 | 5 | 5 or fewer | 0 |
807996 | 807996 | 96143 | 96143: Kings Beach | 2021-03-31 | Placer | 61 | 362 | 3988 | |
807997 | 807997 | 96145 | 96145: Tahoe City | 2021-03-31 | Placer | 61 | 158 | 3033 | |
807998 | 807998 | 96146 | 96146: Olympic Valley | 2021-03-31 | Placer | 61 | 60 | 1326 | |
807999 | 807999 | 96148 | 96148: Tahoe Vista | 2021-03-31 | Placer | 61 | 56 | 1450 | |
808000 | 808000 | 96161 | 96161: Truckee | 2021-03-31 | Placer | 61 | 84 | 18599 | |
808001 | 808001 | 96162 | 96162: Truckee | 2021-03-31 | Placer | 61 | 5 | 5 or fewer | 0 |
808002 | 808002 | Anza | Anza | 2021-03-31 | Riverside | 65 | 147 | 3151 | |
808003 | 808003 | Banning | Banning | 2021-03-31 | Riverside | 65 | 3173 | 30942 | |
808004 | 808004 | Beaumont | Beaumont | 2021-03-31 | Riverside | 65 | 6032 | 45403 | |
808005 | 808005 | Bermuda Dunes | Bermuda Dunes | 2021-03-31 | Riverside | 65 | 640 | 6817 | |
808006 | 808006 | Blythe | Blythe | 2021-03-31 | Riverside | 65 | 1368 | 19581 | |
808007 | 808007 | Cabazon | Cabazon | 2021-03-31 | Riverside | 65 | 309 | 3367 | |
808008 | 808008 | Calimesa | Calimesa | 2021-03-31 | Riverside | 65 | 894 | 8651 | |
808009 | 808009 | Canyon Lake | Canyon Lake | 2021-03-31 | Riverside | 65 | 943 | 11106 | |
808010 | 808010 | Cathedral City | Cathedral City | 2021-03-31 | Riverside | 65 | 7002 | 54037 | |
808011 | 808011 | Cherry Valley | Cherry Valley | 2021-03-31 | Riverside | 65 | 511 | 7755 | |
808012 | 808012 | Coachella | Coachella | 2021-03-31 | Riverside | 65 | 7857 | 44849 | |
808013 | 808013 | Corona | Corona | 2021-03-31 | Riverside | 65 | 17164 | 165355 | |
808014 | 808014 | Coronita | Coronita | 2021-03-31 | Riverside | 65 | 349 | 3138 | |
808015 | 808015 | Desert Edge | Desert Edge | 2021-03-31 | Riverside | 65 | 341 | 3343 | |
808016 | 808016 | Desert Hot Springs | Desert Hot Springs | 2021-03-31 | Riverside | 65 | 4140 | 28430 | |
808017 | 808017 | Desert Palms | Desert Palms | 2021-03-31 | Riverside | 65 | 255 | 6947 | |
808018 | 808018 | East Hemet | East Hemet | 2021-03-31 | Riverside | 65 | 2052 | 20679 | |
808019 | 808019 | Eastvale | Eastvale | 2021-03-31 | Riverside | 65 | 7150 | 61337 | |
808020 | 808020 | El Cerrito | El Cerrito | 2021-03-31 | Riverside | 65 | 672 | 5471 | |
808021 | 808021 | El Sobrante | El Sobrante | 2021-03-31 | Riverside | 65 | 1754 | 13966 | |
808022 | 808022 | French Valley | French Valley | 2021-03-31 | Riverside | 65 | 2299 | 33818 | |
808023 | 808023 | Garnet | Garnet | 2021-03-31 | Riverside | 65 | 886 | 5057 | |
808024 | 808024 | Good Hope | Good Hope | 2021-03-31 | Riverside | 65 | 1481 | 9173 | |
808025 | 808025 | Green Acres | Green Acres | 2021-03-31 | Riverside | 65 | 248 | 2542 | |
808026 | 808026 | Hemet | Hemet | 2021-03-31 | Riverside | 65 | 9216 | 84069 |
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 );