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-19 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 |
---|---|---|---|---|---|---|---|---|---|
897799 | 897799 | 94514 | 94514: Byron | 2021-01-19 | Alameda | 1 | 0 | 1461 | |
897872 | 897872 | Other | Other | 2021-01-19 | Calaveras | 9 | 0 | ||
897888 | 897888 | Knightsen | Knightsen | 2021-01-19 | Contra Costa | 13 | 0 | 1500 | |
897918 | 897918 | Dinuba | Dinuba | 2021-01-19 | Fresno | 19 | 0 | 0 | |
897919 | 897919 | Dos Palos | Dos Palos | 2021-01-19 | Fresno | 19 | 0 | ||
897934 | 897934 | Raisin | Raisin | 2021-01-19 | Fresno | 19 | 0 | 380 | |
897992 | 897992 | 93519 | 93519: Cantil | 2021-01-19 | Kern | 29 | 0 | 28 | |
898290 | 898290 | Unincorporated - Charter Oak | Charter Oak | 2021-01-19 | Los Angeles | 37 | 0 | 9046 | |
898324 | 898324 | Unincorporated - Lakewood | Unincorporated - Lakewood | 2021-01-19 | Los Angeles | 37 | 0 | 1 | |
898342 | 898342 | Unincorporated - Placerita Canyon | Placerita Canyon | 2021-01-19 | Los Angeles | 37 | 0 | 460 | |
898463 | 898463 | 93426 | 93426: Bradley | 2021-01-19 | Monterey | 53 | 0 | 1604 | |
898472 | 898472 | 93922 | 93922: Carmel | 2021-01-19 | Monterey | 53 | 0 | 0 | |
898693 | 898693 | Havasu Lake | Havasu Lake | 2021-01-19 | San Bernardino | 71 | 0 | 0 | |
897798 | 897798 | 94505 | 94505: Discovery Bay | 2021-01-19 | Alameda | 1 | 1 | 16382 | |
897847 | 897847 | 95377 | 95377: Tracy | 2021-01-19 | Alameda | 1 | 1 | 32091 | |
897848 | 897848 | 95391 | 95391: Mountain House | 2021-01-19 | Alameda | 1 | 1 | 20131 | |
898033 | 898033 | 95493 | 95493 | 2021-01-19 | Lake | 33 | 1 | 241 | |
898309 | 898309 | Unincorporated - Franklin Canyon | Franklin Canyon | 2021-01-19 | Los Angeles | 37 | 1 | 12 | |
898312 | 898312 | Unincorporated - Harbor Gateway | Unincorporated - Harbor Gateway | 2021-01-19 | Los Angeles | 37 | 1 | 1 | |
898375 | 898375 | Unincorporated - West Chatsworth | West Chatsworth | 2021-01-19 | Los Angeles | 37 | 1 | 0 | |
897833 | 897833 | 94613 | 94613: Oakland | 2021-01-19 | Alameda | 1 | 2 | 212 | |
898004 | 898004 | 93528 | 93528: Johannesburg | 2021-01-19 | Kern | 29 | 2 | 124 | |
898024 | 898024 | 95443 | 95443 | 2021-01-19 | Lake | 33 | 2 | 270 | |
898687 | 898687 | Devore | Devore | 2021-01-19 | San Bernardino | 71 | 2 | 2283 | |
898707 | 898707 | Mt Baldy | Mt Baldy | 2021-01-19 | San Bernardino | 71 | 2 | 537 | |
897994 | 897994 | 93524 | 93524: Edwards | 2021-01-19 | Kern | 29 | 3 | 168 | |
898581 | 898581 | 95714 | 95714: Dutch Flat | 2021-01-19 | Placer | 61 | 5 | 5 or fewer | 701 |
898582 | 898582 | 95715 | 95715: Emigrant Gap | 2021-01-19 | Placer | 61 | 5 | 5 or fewer | 0 |
898583 | 898583 | 95717 | 95717: Gold Run | 2021-01-19 | Placer | 61 | 5 | 5 or fewer | 0 |
898585 | 898585 | 95724 | 95724: Norden | 2021-01-19 | Placer | 61 | 5 | 5 or fewer | 0 |
898591 | 898591 | 96142 | 96142: Tahoma | 2021-01-19 | Placer | 61 | 5 | 5 or fewer | 0 |
898597 | 898597 | 96162 | 96162: Truckee | 2021-01-19 | Placer | 61 | 5 | 5 or fewer | 0 |
898673 | 898673 | Arrowbear | Arrowbear | 2021-01-19 | San Bernardino | 71 | 5 | 723 | |
898797 | 898797 | 92096 | 92096: San Marcos | 2021-01-19 | San Diego | 73 | 5 | 0 | |
898837 | 898837 | 92536 | 92536: Aguanga | 2021-01-19 | San Diego | 73 | 5 | 0 | |
899006 | 899006 | North County | North County | 2021-01-19 | Trinity | 105 | 5 | 699 | |
897920 | 897920 | Dunlap | Dunlap | 2021-01-19 | Fresno | 19 | 6 | ||
897943 | 897943 | 92222 | 92222: Bard | 2021-01-19 | Imperial | 25 | 6 | 0 | |
897953 | 897953 | 92259 | 92259: Ocotillo | 2021-01-19 | Imperial | 25 | 6 | 94 | |
898006 | 898006 | 93554 | 93554: Randsburg | 2021-01-19 | Kern | 29 | 6 | 143 | |
898495 | 898495 | Chiles Valley Area | Chiles Valley Area | 2021-01-19 | Napa | 55 | 6 | 776 | |
898590 | 898590 | 96141 | 96141: Homewood | 2021-01-19 | Placer | 61 | 6 | 933 | |
897954 | 897954 | 92266 | 92266: Palo Verde | 2021-01-19 | Imperial | 25 | 7 | 108 | |
898021 | 898021 | 95424 | 95424 | 2021-01-19 | Lake | 33 | 7 | 0 | |
898337 | 898337 | Unincorporated - Padua Hills | Padua Hills | 2021-01-19 | Los Angeles | 37 | 7 | 0 | |
898681 | 898681 | Cedar Glen | Cedar Glen | 2021-01-19 | San Bernardino | 71 | 7 | 739 | |
899037 | 899037 | 91307 | 91307: Bell Canyon | 2021-01-19 | Ventura | 111 | 7 | 2391 | |
897969 | 897969 | 93255 | 93255: Onyx | 2021-01-19 | Kern | 29 | 8 | 707 | |
898384 | 898384 | Unincorporated - Whittier Narrows | Whittier Narrows | 2021-01-19 | Los Angeles | 37 | 8 | 12 | |
898501 | 898501 | Northeast American Canyon Area | Northeast American Canyon Area | 2021-01-19 | Napa | 55 | 8 | 212 | |
897976 | 897976 | 93287 | 93287: Woody | 2021-01-19 | Kern | 29 | 9 | 74 | |
898055 | 898055 | City of Avalon | Avalon | 2021-01-19 | Los Angeles | 37 | 9 | 3869 | |
898510 | 898510 | 95724 | 95724: Norden | 2021-01-19 | Nevada | 57 | 9 | 9 or fewer | 20 |
898520 | 898520 | 95986 | 95986: Washington | 2021-01-19 | Nevada | 57 | 9 | 9 or fewer | 53 |
898521 | 898521 | 96111 | 96111: Floriston | 2021-01-19 | Nevada | 57 | 9 | 9 or fewer | 94 |
898711 | 898711 | Oak Glen | Oak Glen | 2021-01-19 | San Bernardino | 71 | 9 | 625 | |
898717 | 898717 | Pioneertown | Pioneertown | 2021-01-19 | San Bernardino | 71 | 9 | 365 | |
898904 | 898904 | La Honda | La Honda | 2021-01-19 | San Mateo | 81 | 9 | 9 or fewer | 960 |
898906 | 898906 | Loma Mar | Loma Mar | 2021-01-19 | San Mateo | 81 | 9 | 9 or fewer | 172 |
898914 | 898914 | Princeton | Princeton | 2021-01-19 | San Mateo | 81 | 9 | 9 or fewer | 382 |
899010 | 899010 | 93212 | Corcoran, Angiola: 93212 | 2021-01-19 | Tulare | 107 | 9 | 0 | |
898692 | 898692 | Green Valley Lake | Green Valley Lake | 2021-01-19 | San Bernardino | 71 | 10 | 412 | |
898740 | 898740 | 91931 | 91931: Guatay | 2021-01-19 | San Diego | 73 | 10 | 0 | |
898960 | 898960 | 94515 | 94515: Calistoga | 2021-01-19 | Sonoma | 97 | 10 | 10 or fewer | 7436 |
898974 | 898974 | 95412 | 95412: Annapolis | 2021-01-19 | Sonoma | 97 | 10 | 10 or fewer | 402 |
898984 | 898984 | 95450 | 95450: Jenner | 2021-01-19 | Sonoma | 97 | 10 | 10 or fewer | 298 |
898991 | 898991 | 95497 | 95497: The Sea Ranch | 2021-01-19 | Sonoma | 97 | 10 | 10 or fewer | 1161 |
898509 | 898509 | 95712 | 95712: Chicago Park | 2021-01-19 | Nevada | 57 | 11 | 0 | |
898517 | 898517 | 95960 | 95960: North San Juan | 2021-01-19 | Nevada | 57 | 11 | 825 | |
897972 | 897972 | 93276 | 93276: Tupman | 2021-01-19 | Kern | 29 | 12 | 159 | |
898317 | 898317 | Unincorporated - La Habra Heights | Unincorporated - La Habra Heights | 2021-01-19 | Los Angeles | 37 | 12 | 676 | |
898351 | 898351 | Unincorporated - San Francisquito Canyon/Bouquet Canyon | San Francisquito Canyon/Bouquet Canyon | 2021-01-19 | Los Angeles | 37 | 12 | 858 | |
898688 | 898688 | Fawnskin | Fawnskin | 2021-01-19 | San Bernardino | 71 | 12 | 528 | |
898783 | 898783 | 92066 | 92066: Ranchita | 2021-01-19 | San Diego | 73 | 12 | 0 | |
898832 | 898832 | 92145 | 92145: San Diego | 2021-01-19 | San Diego | 73 | 12 | 0 | |
898354 | 898354 | Unincorporated - Sand Canyon | Sand Canyon | 2021-01-19 | Los Angeles | 37 | 13 | 308 | |
898888 | 898888 | San Simeon | San Simeon | 2021-01-19 | San Luis Obispo | 79 | 13 | 583 | |
898961 | 898961 | 94922 | 94922: Bodega | 2021-01-19 | Sonoma | 97 | 13 | 603 | |
897960 | 897960 | 93226 | 93226: Glennville | 2021-01-19 | Kern | 29 | 14 | 195 | |
898678 | 898678 | Big River | Big River | 2021-01-19 | San Bernardino | 71 | 14 | 1264 | |
898779 | 898779 | 92060 | 92060: Palomar Mountain | 2021-01-19 | San Diego | 73 | 14 | 0 | |
898987 | 898987 | 95465 | 95465: Occidental | 2021-01-19 | Sonoma | 97 | 14 | 2104 | |
898301 | 898301 | Unincorporated - East Lancaster | East Lancaster | 2021-01-19 | Los Angeles | 37 | 15 | 114 | |
898834 | 898834 | 92155 | 92155: Coronado | 2021-01-19 | San Diego | 73 | 15 | 0 | |
898975 | 898975 | 95421 | 95421: Cazadero | 2021-01-19 | Sonoma | 97 | 15 | 1681 | |
897933 | 897933 | Prather | Prather | 2021-01-19 | Fresno | 19 | 16 | 0 | |
898511 | 898511 | 95728 | 95728: Soda Springs | 2021-01-19 | Nevada | 57 | 16 | 229 | |
898686 | 898686 | Daggett | Daggett | 2021-01-19 | San Bernardino | 71 | 16 | 549 | |
898985 | 898985 | 95452 | 95452: Kenwood | 2021-01-19 | Sonoma | 97 | 16 | 970 | |
898498 | 898498 | Lake Berryessa | Lake Berryessa | 2021-01-19 | Napa | 55 | 17 | 1624 | |
899034 | 899034 | 93646 | Traver: 93646 | 2021-01-19 | Tulare | 107 | 17 | 0 | |
897863 | 897863 | 95225 | 95225 | 2021-01-19 | Calaveras | 9 | 18 | 378 | |
897967 | 897967 | 93251 | 93251: Mc Kittrick | 2021-01-19 | Kern | 29 | 18 | 243 | |
897999 | 897999 | 93220 | 93220: Edison | 2021-01-19 | Kern | 29 | 18 | 313 | |
898339 | 898339 | Unincorporated - Palos Verdes Peninsula | Palos Verdes Peninsula | 2021-01-19 | Los Angeles | 37 | 18 | 621 | |
898519 | 898519 | 95977 | 95977: Smartville | 2021-01-19 | Nevada | 57 | 18 | 0 | |
898986 | 898986 | 95462 | 95462: Monte Rio | 2021-01-19 | Sonoma | 97 | 18 | 1265 | |
898022 | 898022 | 95426 | 95426 | 2021-01-19 | Lake | 33 | 19 | 1404 | |
898500 | 898500 | North Calistoga | North Calistoga | 2021-01-19 | Napa | 55 | 19 | 980 | |
897991 | 897991 | 93518 | 93518: Caliente | 2021-01-19 | Kern | 29 | 20 | 995 |
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 );