latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
1,276 rows where "date" is on date 2021-01-07 sorted by confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Los Angeles 353
- San Diego 110
- Riverside 64
- San Bernardino 64
- Alameda 53
- Marin 53
- Kern 50
- Orange 41
- Fresno 32
- Placer 32
- Sonoma 32
- Contra Costa 30
- San Mateo 30
- Tulare 28
- Monterey 27
- San Francisco 26
- Ventura 25
- San Luis Obispo 22
- Napa 18
- Imperial 17
- Nevada 17
- Lake 15
- Santa Clara 15
- Calaveras 12
- Santa Barbara 11
- Merced 10
- Stanislaus 10
- Kings 9
- El Dorado 8
- Sacramento 8
- …
Link | rowid | id | name | date | county | fips | confirmed_cases ▼ | note | population |
---|---|---|---|---|---|---|---|---|---|
913110 | 913110 | 94505 | 94505: Discovery Bay | 2021-01-07 | Alameda | 1 | 0 | 16382 | |
913111 | 913111 | 94514 | 94514: Byron | 2021-01-07 | Alameda | 1 | 0 | 1461 | |
913184 | 913184 | Other | Other | 2021-01-07 | Calaveras | 9 | 0 | ||
913200 | 913200 | Knightsen | Knightsen | 2021-01-07 | Contra Costa | 13 | 0 | 1500 | |
913230 | 913230 | Dinuba | Dinuba | 2021-01-07 | Fresno | 19 | 0 | 0 | |
913231 | 913231 | Dos Palos | Dos Palos | 2021-01-07 | Fresno | 19 | 0 | ||
913246 | 913246 | Raisin | Raisin | 2021-01-07 | Fresno | 19 | 0 | 380 | |
913259 | 913259 | 92243 | 92243: El Centro | 2021-01-07 | Imperial | 25 | 0 | 50484 | |
913304 | 913304 | 93519 | 93519: Cantil | 2021-01-07 | Kern | 29 | 0 | 28 | |
913602 | 913602 | Unincorporated - Charter Oak | Charter Oak | 2021-01-07 | Los Angeles | 37 | 0 | 9046 | |
913636 | 913636 | Unincorporated - Lakewood | Unincorporated - Lakewood | 2021-01-07 | Los Angeles | 37 | 0 | 1 | |
913654 | 913654 | Unincorporated - Placerita Canyon | Placerita Canyon | 2021-01-07 | Los Angeles | 37 | 0 | 460 | |
913775 | 913775 | 93426 | 93426: Bradley | 2021-01-07 | Monterey | 53 | 0 | 1604 | |
913784 | 913784 | 93922 | 93922: Carmel | 2021-01-07 | Monterey | 53 | 0 | 0 | |
914005 | 914005 | Havasu Lake | Havasu Lake | 2021-01-07 | San Bernardino | 71 | 0 | 0 | |
914286 | 914286 | 95412 | 95412: Annapolis | 2021-01-07 | Sonoma | 97 | 0 | 402 | |
913145 | 913145 | 94613 | 94613: Oakland | 2021-01-07 | Alameda | 1 | 1 | 212 | |
913159 | 913159 | 95377 | 95377: Tracy | 2021-01-07 | Alameda | 1 | 1 | 32091 | |
913160 | 913160 | 95391 | 95391: Mountain House | 2021-01-07 | Alameda | 1 | 1 | 20131 | |
913260 | 913260 | 92244 | 92244: El Centro | 2021-01-07 | Imperial | 25 | 1 | 0 | |
913345 | 913345 | 95493 | 95493 | 2021-01-07 | Lake | 33 | 1 | 241 | |
913621 | 913621 | Unincorporated - Franklin Canyon | Franklin Canyon | 2021-01-07 | Los Angeles | 37 | 1 | 12 | |
913624 | 913624 | Unincorporated - Harbor Gateway | Unincorporated - Harbor Gateway | 2021-01-07 | Los Angeles | 37 | 1 | 1 | |
913687 | 913687 | Unincorporated - West Chatsworth | West Chatsworth | 2021-01-07 | Los Angeles | 37 | 1 | 0 | |
914019 | 914019 | Mt Baldy | Mt Baldy | 2021-01-07 | San Bernardino | 71 | 1 | 537 | |
913316 | 913316 | 93528 | 93528: Johannesburg | 2021-01-07 | Kern | 29 | 2 | 124 | |
913336 | 913336 | 95443 | 95443 | 2021-01-07 | Lake | 33 | 2 | 270 | |
913985 | 913985 | Arrowbear | Arrowbear | 2021-01-07 | San Bernardino | 71 | 2 | 723 | |
913999 | 913999 | Devore | Devore | 2021-01-07 | San Bernardino | 71 | 2 | 2283 | |
913306 | 913306 | 93524 | 93524: Edwards | 2021-01-07 | Kern | 29 | 3 | 168 | |
914149 | 914149 | 92536 | 92536: Aguanga | 2021-01-07 | San Diego | 73 | 3 | 0 | |
914318 | 914318 | North County | North County | 2021-01-07 | Trinity | 105 | 4 | 699 | |
913255 | 913255 | 92222 | 92222: Bard | 2021-01-07 | Imperial | 25 | 5 | 0 | |
913265 | 913265 | 92259 | 92259: Ocotillo | 2021-01-07 | Imperial | 25 | 5 | 94 | |
913333 | 913333 | 95424 | 95424 | 2021-01-07 | Lake | 33 | 5 | 0 | |
913893 | 913893 | 95714 | 95714: Dutch Flat | 2021-01-07 | Placer | 61 | 5 | 5 or fewer | 701 |
913894 | 913894 | 95715 | 95715: Emigrant Gap | 2021-01-07 | Placer | 61 | 5 | 5 or fewer | 0 |
913895 | 913895 | 95717 | 95717: Gold Run | 2021-01-07 | Placer | 61 | 5 | 5 or fewer | 0 |
913897 | 913897 | 95724 | 95724: Norden | 2021-01-07 | Placer | 61 | 5 | 5 or fewer | 0 |
913903 | 913903 | 96142 | 96142: Tahoma | 2021-01-07 | Placer | 61 | 5 | 5 or fewer | 0 |
913909 | 913909 | 96162 | 96162: Truckee | 2021-01-07 | Placer | 61 | 5 | 5 or fewer | 0 |
913990 | 913990 | Big River | Big River | 2021-01-07 | San Bernardino | 71 | 5 | 1264 | |
914109 | 914109 | 92096 | 92096: San Marcos | 2021-01-07 | San Diego | 73 | 5 | 0 | |
913232 | 913232 | Dunlap | Dunlap | 2021-01-07 | Fresno | 19 | 6 | ||
913266 | 913266 | 92266 | 92266: Palo Verde | 2021-01-07 | Imperial | 25 | 6 | 108 | |
913288 | 913288 | 93287 | 93287: Woody | 2021-01-07 | Kern | 29 | 6 | 74 | |
913318 | 913318 | 93554 | 93554: Randsburg | 2021-01-07 | Kern | 29 | 6 | 143 | |
913367 | 913367 | City of Avalon | Avalon | 2021-01-07 | Los Angeles | 37 | 6 | 3869 | |
913649 | 913649 | Unincorporated - Padua Hills | Padua Hills | 2021-01-07 | Los Angeles | 37 | 6 | 0 | |
913807 | 913807 | Chiles Valley Area | Chiles Valley Area | 2021-01-07 | Napa | 55 | 6 | 776 | |
913902 | 913902 | 96141 | 96141: Homewood | 2021-01-07 | Placer | 61 | 6 | 933 | |
914029 | 914029 | Pioneertown | Pioneertown | 2021-01-07 | San Bernardino | 71 | 6 | 365 | |
913281 | 913281 | 93255 | 93255: Onyx | 2021-01-07 | Kern | 29 | 7 | 707 | |
913813 | 913813 | Northeast American Canyon Area | Northeast American Canyon Area | 2021-01-07 | Napa | 55 | 7 | 212 | |
913993 | 913993 | Cedar Glen | Cedar Glen | 2021-01-07 | San Bernardino | 71 | 7 | 739 | |
914004 | 914004 | Green Valley Lake | Green Valley Lake | 2021-01-07 | San Bernardino | 71 | 7 | 412 | |
914052 | 914052 | 91931 | 91931: Guatay | 2021-01-07 | San Diego | 73 | 7 | 0 | |
914091 | 914091 | 92060 | 92060: Palomar Mountain | 2021-01-07 | San Diego | 73 | 7 | 0 | |
914349 | 914349 | 91307 | 91307: Bell Canyon | 2021-01-07 | Ventura | 111 | 7 | 2391 | |
913696 | 913696 | Unincorporated - Whittier Narrows | Whittier Narrows | 2021-01-07 | Los Angeles | 37 | 8 | 12 | |
914023 | 914023 | Oak Glen | Oak Glen | 2021-01-07 | San Bernardino | 71 | 8 | 625 | |
913663 | 913663 | Unincorporated - San Francisquito Canyon/Bouquet Canyon | San Francisquito Canyon/Bouquet Canyon | 2021-01-07 | Los Angeles | 37 | 9 | 858 | |
913821 | 913821 | 95712 | 95712: Chicago Park | 2021-01-07 | Nevada | 57 | 9 | 9 or fewer | 0 |
913822 | 913822 | 95724 | 95724: Norden | 2021-01-07 | Nevada | 57 | 9 | 9 or fewer | 20 |
913832 | 913832 | 95986 | 95986: Washington | 2021-01-07 | Nevada | 57 | 9 | 9 or fewer | 53 |
913833 | 913833 | 96111 | 96111: Floriston | 2021-01-07 | Nevada | 57 | 9 | 9 or fewer | 94 |
914000 | 914000 | Fawnskin | Fawnskin | 2021-01-07 | San Bernardino | 71 | 9 | 528 | |
914200 | 914200 | San Simeon | San Simeon | 2021-01-07 | San Luis Obispo | 79 | 9 | 583 | |
914216 | 914216 | La Honda | La Honda | 2021-01-07 | San Mateo | 81 | 9 | 9 or fewer | 960 |
914218 | 914218 | Loma Mar | Loma Mar | 2021-01-07 | San Mateo | 81 | 9 | 9 or fewer | 172 |
914226 | 914226 | Princeton | Princeton | 2021-01-07 | San Mateo | 81 | 9 | 9 or fewer | 382 |
914322 | 914322 | 93212 | Corcoran, Angiola: 93212 | 2021-01-07 | Tulare | 107 | 9 | 0 | |
913284 | 913284 | 93276 | 93276: Tupman | 2021-01-07 | Kern | 29 | 10 | 159 | |
913613 | 913613 | Unincorporated - East Lancaster | East Lancaster | 2021-01-07 | Los Angeles | 37 | 10 | 114 | |
913666 | 913666 | Unincorporated - Sand Canyon | Sand Canyon | 2021-01-07 | Los Angeles | 37 | 10 | 308 | |
914095 | 914095 | 92066 | 92066: Ranchita | 2021-01-07 | San Diego | 73 | 10 | 0 | |
914272 | 914272 | 94515 | 94515: Calistoga | 2021-01-07 | Sonoma | 97 | 10 | 10 or fewer | 7436 |
914273 | 914273 | 94922 | 94922: Bodega | 2021-01-07 | Sonoma | 97 | 10 | 10 or fewer | 603 |
914296 | 914296 | 95450 | 95450: Jenner | 2021-01-07 | Sonoma | 97 | 10 | 10 or fewer | 298 |
914299 | 914299 | 95465 | 95465: Occidental | 2021-01-07 | Sonoma | 97 | 10 | 10 or fewer | 2104 |
914303 | 914303 | 95497 | 95497: The Sea Ranch | 2021-01-07 | Sonoma | 97 | 10 | 10 or fewer | 1161 |
913272 | 913272 | 93226 | 93226: Glennville | 2021-01-07 | Kern | 29 | 11 | 195 | |
913629 | 913629 | Unincorporated - La Habra Heights | Unincorporated - La Habra Heights | 2021-01-07 | Los Angeles | 37 | 11 | 676 | |
913812 | 913812 | North Calistoga | North Calistoga | 2021-01-07 | Napa | 55 | 11 | 980 | |
913829 | 913829 | 95960 | 95960: North San Juan | 2021-01-07 | Nevada | 57 | 11 | 825 | |
913998 | 913998 | Daggett | Daggett | 2021-01-07 | San Bernardino | 71 | 12 | 549 | |
914144 | 914144 | 92145 | 92145: San Diego | 2021-01-07 | San Diego | 73 | 12 | 0 | |
914287 | 914287 | 95421 | 95421: Cazadero | 2021-01-07 | Sonoma | 97 | 12 | 1681 | |
913810 | 913810 | Lake Berryessa | Lake Berryessa | 2021-01-07 | Napa | 55 | 13 | 1624 | |
914146 | 914146 | 92155 | 92155: Coronado | 2021-01-07 | San Diego | 73 | 13 | 0 | |
914346 | 914346 | 93646 | Traver: 93646 | 2021-01-07 | Tulare | 107 | 13 | 0 | |
913175 | 913175 | 95225 | 95225 | 2021-01-07 | Calaveras | 9 | 14 | 378 | |
913313 | 913313 | 93224 | 93224: Fellows | 2021-01-07 | Kern | 29 | 14 | 402 | |
913823 | 913823 | 95728 | 95728: Soda Springs | 2021-01-07 | Nevada | 57 | 14 | 229 | |
913303 | 913303 | 93518 | 93518: Caliente | 2021-01-07 | Kern | 29 | 15 | 995 | |
913880 | 913880 | 95626 | 95626: Elverta | 2021-01-07 | Placer | 61 | 15 | 6371 | |
914150 | 914150 | 92672 | 92672: San Clemente | 2021-01-07 | San Diego | 73 | 15 | 0 | |
914297 | 914297 | 95452 | 95452: Kenwood | 2021-01-07 | Sonoma | 97 | 15 | 970 | |
913245 | 913245 | Prather | Prather | 2021-01-07 | Fresno | 19 | 16 | 0 | |
913279 | 913279 | 93251 | 93251: Mc Kittrick | 2021-01-07 | Kern | 29 | 16 | 243 |
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 );