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 191,679
- San Diego 58,300
- Riverside 34,112
- San Bernardino 33,920
- Alameda 29,680
- Kern 24,550
- Orange 21,853
- Placer 17,952
- Sonoma 17,888
- Fresno 16,448
- Contra Costa 15,660
- Tulare 14,812
- San Mateo 14,730
- San Francisco 14,144
- Marin 13,197
- Ventura 12,675
- Monterey 12,528
- San Luis Obispo 11,902
- Napa 9,152
- Imperial 8,551
- Santa Clara 7,800
- Nevada 7,565
- Santa Barbara 5,874
- Merced 5,370
- Stanislaus 5,230
- Lake 4,890
- Kings 4,536
- Sacramento 4,208
- El Dorado 4,200
- Solano 4,128
- …
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
599916 | 599916 | North Calistoga | North Calistoga | 2021-09-10 | Napa | 55 | 53 | 980 | |
599917 | 599917 | Northeast American Canyon Area | Northeast American Canyon Area | 2021-09-10 | Napa | 55 | 15 | 212 | |
599918 | 599918 | Pope Valley Area | Pope Valley Area | 2021-09-10 | Napa | 55 | 38 | 1275 | |
599919 | 599919 | South Napa Area | South Napa Area | 2021-09-10 | Napa | 55 | 304 | 1961 | |
599920 | 599920 | St. Helena | St. Helena | 2021-09-10 | Napa | 55 | 327 | 6543 | |
599921 | 599921 | West Napa Area | West Napa Area | 2021-09-10 | Napa | 55 | 40 | 951 | |
599922 | 599922 | West Napa and Yountville Area | West Napa and Yountville Area | 2021-09-10 | Napa | 55 | 59 | 1699 | |
599923 | 599923 | Yountville | Yountville | 2021-09-10 | Napa | 55 | 175 | 3032 | |
599924 | 599924 | 95602 | 95602: Auburn | 2021-09-10 | Nevada | 57 | 379 | 0 | |
599925 | 599925 | 95712 | 95712: Chicago Park | 2021-09-10 | Nevada | 57 | 19 | 0 | |
599926 | 599926 | 95724 | 95724: Norden | 2021-09-10 | Nevada | 57 | 34 | 20 | |
599927 | 599927 | 95728 | 95728: Soda Springs | 2021-09-10 | Nevada | 57 | 31 | 229 | |
599928 | 599928 | 95924 | 95924: Cedar Ridge | 2021-09-10 | Nevada | 57 | 62 | 0 | |
599929 | 599929 | 95945 | 95945: Grass Valley | 2021-09-10 | Nevada | 57 | 2274 | 25519 | |
599930 | 599930 | 95946 | 95946: Penn Valley | 2021-09-10 | Nevada | 57 | 665 | 9370 | |
599931 | 599931 | 95949 | 95949: Grass Valley | 2021-09-10 | Nevada | 57 | 1402 | 20519 | |
599932 | 599932 | 95959 | 95959: Nevada City | 2021-09-10 | Nevada | 57 | 1168 | 17910 | |
599933 | 599933 | 95960 | 95960: North San Juan | 2021-09-10 | Nevada | 57 | 62 | 825 | |
599934 | 599934 | 95975 | 95975: Rough And Ready | 2021-09-10 | Nevada | 57 | 112 | 1584 | |
599935 | 599935 | 95977 | 95977: Smartville | 2021-09-10 | Nevada | 57 | 61 | 0 | |
599936 | 599936 | 95986 | 95986: Washington | 2021-09-10 | Nevada | 57 | 9 | 9 or fewer | 53 |
599937 | 599937 | 96111 | 96111: Floriston | 2021-09-10 | Nevada | 57 | 9 | 9 or fewer | 94 |
599938 | 599938 | 96160 | 96160: Truckee | 2021-09-10 | Nevada | 57 | 133 | 0 | |
599939 | 599939 | 96161 | 96161: Truckee | 2021-09-10 | Nevada | 57 | 1382 | 18333 | |
599940 | 599940 | 96162 | 96162: Truckee | 2021-09-10 | Nevada | 57 | 86 | 0 | |
599941 | 599941 | Aliso Viejo | Aliso Viejo | 2021-09-10 | Orange | 59 | 2878 | 51372 | |
599942 | 599942 | Anaheim | Anaheim | 2021-09-10 | Orange | 59 | 46112 | 359339 | |
599943 | 599943 | Brea | Brea | 2021-09-10 | Orange | 59 | 3372 | 45606 | |
599944 | 599944 | Buena Park | Buena Park | 2021-09-10 | Orange | 59 | 8848 | 83384 | |
599945 | 599945 | Costa Mesa | Costa Mesa | 2021-09-10 | Orange | 59 | 10463 | 115830 | |
599946 | 599946 | Coto de Caza | Coto de Caza | 2021-09-10 | Orange | 59 | 266 | 14931 | |
599947 | 599947 | Cypress | Cypress | 2021-09-10 | Orange | 59 | 3561 | 49833 | |
599948 | 599948 | Dana Point | Dana Point | 2021-09-10 | Orange | 59 | 1938 | 34249 | |
599949 | 599949 | Fountain Valley | Fountain Valley | 2021-09-10 | Orange | 59 | 4205 | 56652 | |
599950 | 599950 | Fullerton | Fullerton | 2021-09-10 | Orange | 59 | 13140 | 142824 | |
599951 | 599951 | Garden Grove | Garden Grove | 2021-09-10 | Orange | 59 | 18316 | 175155 | |
599952 | 599952 | Huntington Beach | Huntington Beach | 2021-09-10 | Orange | 59 | 13253 | 203761 | |
599953 | 599953 | Irvine | Irvine | 2021-09-10 | Orange | 59 | 13162 | 280202 | |
599954 | 599954 | La Habra | La Habra | 2021-09-10 | Orange | 59 | 7341 | 63542 | |
599955 | 599955 | La Palma | La Palma | 2021-09-10 | Orange | 59 | 1002 | 15820 | |
599956 | 599956 | Ladera Ranch | Ladera Ranch | 2021-09-10 | Orange | 59 | 1221 | 30288 | |
599957 | 599957 | Laguna Beach | Laguna Beach | 2021-09-10 | Orange | 59 | 1106 | 23358 | |
599958 | 599958 | Laguna Hills | Laguna Hills | 2021-09-10 | Orange | 59 | 2068 | 31572 | |
599959 | 599959 | Laguna Niguel | Laguna Niguel | 2021-09-10 | Orange | 59 | 3336 | 66748 | |
599960 | 599960 | Laguna Woods | Laguna Woods | 2021-09-10 | Orange | 59 | 507 | 16518 | |
599961 | 599961 | Lake Forest | Lake Forest | 2021-09-10 | Orange | 59 | 4970 | 86346 | |
599962 | 599962 | Los Alamitos | Los Alamitos | 2021-09-10 | Orange | 59 | 1369 | 11721 | |
599963 | 599963 | Midway City | Midway City | 2021-09-10 | Orange | 59 | 865 | 8374 | |
599964 | 599964 | Mission Viejo | Mission Viejo | 2021-09-10 | Orange | 59 | 5604 | 96434 | |
599965 | 599965 | Newport Beach | Newport Beach | 2021-09-10 | Orange | 59 | 4790 | 87180 | |
599966 | 599966 | Orange | Orange | 2021-09-10 | Orange | 59 | 13591 | 141691 | |
599967 | 599967 | Placentia | Placentia | 2021-09-10 | Orange | 59 | 4982 | 52333 | |
599968 | 599968 | Rancho Mission Viejo | Rancho Mission Viejo | 2021-09-10 | Orange | 59 | 452 | 0 | |
599969 | 599969 | Rancho Santa Margarita | Rancho Santa Margarita | 2021-09-10 | Orange | 59 | 2540 | 48960 | |
599970 | 599970 | Rossmoor | Rossmoor | 2021-09-10 | Orange | 59 | 169 | 11160 | |
599971 | 599971 | San Clemente | San Clemente | 2021-09-10 | Orange | 59 | 3826 | 65405 | |
599972 | 599972 | San Juan Capistrano | San Juan Capistrano | 2021-09-10 | Orange | 59 | 3245 | 36821 | |
599973 | 599973 | Santa Ana | Santa Ana | 2021-09-10 | Orange | 59 | 48144 | 337716 | |
599974 | 599974 | Seal Beach | Seal Beach | 2021-09-10 | Orange | 59 | 1469 | 25073 | |
599975 | 599975 | Silverado | Silverado | 2021-09-10 | Orange | 59 | 125 | 0 | |
599976 | 599976 | Stanton | Stanton | 2021-09-10 | Orange | 59 | 3469 | 39307 | |
599977 | 599977 | Trabuco Canyon | Trabuco Canyon | 2021-09-10 | Orange | 59 | 1233 | 0 | |
599978 | 599978 | Tustin | Tustin | 2021-09-10 | Orange | 59 | 7183 | 81369 | |
599979 | 599979 | Villa Park | Villa Park | 2021-09-10 | Orange | 59 | 364 | 5933 | |
599980 | 599980 | Westminster | Westminster | 2021-09-10 | Orange | 59 | 8063 | 92610 | |
599981 | 599981 | Yorba Linda | Yorba Linda | 2021-09-10 | Orange | 59 | 5259 | 68706 | |
599982 | 599982 | 95602 | 95602: Auburn | 2021-09-10 | Placer | 61 | 1117 | 17817 | |
599983 | 599983 | 95603 | 95603: Auburn | 2021-09-10 | Placer | 61 | 2245 | 27256 | |
599984 | 599984 | 95626 | 95626: Elverta | 2021-09-10 | Placer | 61 | 46 | 6371 | |
599985 | 599985 | 95631 | 95631: Foresthill | 2021-09-10 | Placer | 61 | 347 | 6387 | |
599986 | 599986 | 95648 | 95648: Lincoln | 2021-09-10 | Placer | 61 | 3936 | 51257 | |
599987 | 599987 | 95650 | 95650: Loomis | 2021-09-10 | Placer | 61 | 1025 | 12986 | |
599988 | 599988 | 95658 | 95658: Newcastle | 2021-09-10 | Placer | 61 | 428 | 6751 | |
599989 | 599989 | 95661 | 95661: Roseville | 2021-09-10 | Placer | 61 | 2981 | 30470 | |
599990 | 599990 | 95663 | 95663: Penryn | 2021-09-10 | Placer | 61 | 216 | 2102 | |
599991 | 599991 | 95677 | 95677: Rocklin | 2021-09-10 | Placer | 61 | 2331 | 23121 | |
599992 | 599992 | 95678 | 95678: Roseville | 2021-09-10 | Placer | 61 | 4072 | 41221 | |
599993 | 599993 | 95681 | 95681: Sheridan | 2021-09-10 | Placer | 61 | 114 | 1241 | |
599994 | 599994 | 95701 | 95701: Alta | 2021-09-10 | Placer | 61 | 59 | 842 | |
599995 | 599995 | 95703 | 95703: Applegate | 2021-09-10 | Placer | 61 | 136 | 3023 | |
599996 | 599996 | 95713 | 95713: Colfax | 2021-09-10 | Placer | 61 | 508 | 8927 | |
599997 | 599997 | 95714 | 95714: Dutch Flat | 2021-09-10 | Placer | 61 | 18 | 701 | |
599998 | 599998 | 95715 | 95715: Emigrant Gap | 2021-09-10 | Placer | 61 | 11 | 0 | |
599999 | 599999 | 95717 | 95717: Gold Run | 2021-09-10 | Placer | 61 | 6 | 0 | |
600000 | 600000 | 95722 | 95722: Meadow Vista | 2021-09-10 | Placer | 61 | 314 | 4933 | |
600001 | 600001 | 95724 | 95724: Norden | 2021-09-10 | Placer | 61 | 5 | 5 or fewer | 0 |
600002 | 600002 | 95746 | 95746: Granite Bay | 2021-09-10 | Placer | 61 | 1436 | 21786 | |
600003 | 600003 | 95747 | 95747: Roseville | 2021-09-10 | Placer | 61 | 5891 | 59715 | |
600004 | 600004 | 95765 | 95765: Rocklin | 2021-09-10 | Placer | 61 | 3219 | 37002 | |
600005 | 600005 | 96140 | 96140: Carnelian Bay | 2021-09-10 | Placer | 61 | 86 | 1659 | |
600006 | 600006 | 96141 | 96141: Homewood | 2021-09-10 | Placer | 61 | 26 | 933 | |
600007 | 600007 | 96142 | 96142: Tahoma | 2021-09-10 | Placer | 61 | 5 | 5 or fewer | 0 |
600008 | 600008 | 96143 | 96143: Kings Beach | 2021-09-10 | Placer | 61 | 506 | 3988 | |
600009 | 600009 | 96145 | 96145: Tahoe City | 2021-09-10 | Placer | 61 | 238 | 3033 | |
600010 | 600010 | 96146 | 96146: Olympic Valley | 2021-09-10 | Placer | 61 | 101 | 1326 | |
600011 | 600011 | 96148 | 96148: Tahoe Vista | 2021-09-10 | Placer | 61 | 87 | 1450 | |
600012 | 600012 | 96161 | 96161: Truckee | 2021-09-10 | Placer | 61 | 118 | 18599 | |
600013 | 600013 | 96162 | 96162: Truckee | 2021-09-10 | Placer | 61 | 5 | 5 or fewer | 0 |
600014 | 600014 | Anza | Anza | 2021-09-10 | Riverside | 65 | 177 | 3151 | |
600015 | 600015 | Banning | Banning | 2021-09-10 | Riverside | 65 | 3645 | 30942 |
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 );