latimes-place-totals
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- id
- The unique identifier of the city, neighborhood or other area.
- name
- The name of the city, neighborhood or other area.
- date
- The date when the data were retrieved in ISO 8601 format.
- county
- The name of the county where the city is located.
- fips
- The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
- confirmed_cases
- The cumulative number of confirmed coronavirus case at that time.
- note
- In cases where the confirmed_cases are obscured, this explains the range of possible values.
- population
- The number of residents in the area. Not available for all places.
1,277 rows where "date" is on date 2022-02-27 sorted by confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date | county | fips | confirmed_cases ▼ | note | population |
---|---|---|---|---|---|---|---|---|---|
383057 | 383057 | Dos Palos | Dos Palos | 2022-02-27 | Fresno | 19 | 0 | ||
383831 | 383831 | Havasu Lake | Havasu Lake | 2022-02-27 | San Bernardino | 71 | 0 | 0 | |
383000 | 383000 | 95377 | 95377: Tracy | 2022-02-27 | Alameda | 1 | 1 | 32091 | |
383447 | 383447 | Unincorporated - Franklin Canyon | Franklin Canyon | 2022-02-27 | Los Angeles | 37 | 1 | 12 | |
383462 | 383462 | Unincorporated - Lakewood | Unincorporated - Lakewood | 2022-02-27 | Los Angeles | 37 | 1 | 1 | |
382952 | 382952 | 94514 | 94514: Byron | 2022-02-27 | Alameda | 1 | 2 | 1461 | |
383001 | 383001 | 95391 | 95391: Mountain House | 2022-02-27 | Alameda | 1 | 2 | 20131 | |
383428 | 383428 | Unincorporated - Charter Oak | Charter Oak | 2022-02-27 | Los Angeles | 37 | 2 | 9046 | |
383825 | 383825 | Devore | Devore | 2022-02-27 | San Bernardino | 71 | 2 | 2283 | |
383130 | 383130 | 93519 | 93519: Cantil | 2022-02-27 | Kern | 29 | 3 | 28 | |
382951 | 382951 | 94505 | 94505: Discovery Bay | 2022-02-27 | Alameda | 1 | 4 | 16382 | |
383450 | 383450 | Unincorporated - Harbor Gateway | Unincorporated - Harbor Gateway | 2022-02-27 | Los Angeles | 37 | 4 | 1 | |
383513 | 383513 | Unincorporated - West Chatsworth | West Chatsworth | 2022-02-27 | Los Angeles | 37 | 4 | 0 | |
383845 | 383845 | Mt Baldy | Mt Baldy | 2022-02-27 | San Bernardino | 71 | 4 | 537 | |
383729 | 383729 | 96142 | 96142: Tahoma | 2022-02-27 | Placer | 61 | 5 | 5 or fewer | 0 |
383735 | 383735 | 96162 | 96162: Truckee | 2022-02-27 | Placer | 61 | 5 | 5 or fewer | 0 |
383058 | 383058 | Dunlap | Dunlap | 2022-02-27 | Fresno | 19 | 6 | ||
383723 | 383723 | 95724 | 95724: Norden | 2022-02-27 | Placer | 61 | 6 | 0 | |
383819 | 383819 | Cedar Glen | Cedar Glen | 2022-02-27 | San Bernardino | 71 | 7 | 739 | |
383811 | 383811 | Arrowbear | Arrowbear | 2022-02-27 | San Bernardino | 71 | 9 | 723 | |
383144 | 383144 | 93554 | 93554: Randsburg | 2022-02-27 | Kern | 29 | 10 | 143 | |
383648 | 383648 | 95724 | 95724: Norden | 2022-02-27 | Nevada | 57 | 10 | 20 | |
383658 | 383658 | 95986 | 95986: Washington | 2022-02-27 | Nevada | 57 | 10 | 53 | |
384052 | 384052 | Princeton | Princeton | 2022-02-27 | San Mateo | 81 | 11 | 382 | |
383081 | 383081 | 92222 | 92222: Bard | 2022-02-27 | Imperial | 25 | 12 | 0 | |
383721 | 383721 | 95717 | 95717: Gold Run | 2022-02-27 | Placer | 61 | 12 | 0 | |
384044 | 384044 | Loma Mar | Loma Mar | 2022-02-27 | San Mateo | 81 | 12 | 172 | |
383142 | 383142 | 93528 | 93528: Johannesburg | 2022-02-27 | Kern | 29 | 13 | 124 | |
382986 | 382986 | 94613 | 94613: Oakland | 2022-02-27 | Alameda | 1 | 14 | 212 | |
383659 | 383659 | 96111 | 96111: Floriston | 2022-02-27 | Nevada | 57 | 14 | 94 | |
383975 | 383975 | 92536 | 92536: Aguanga | 2022-02-27 | San Diego | 73 | 14 | 0 | |
383092 | 383092 | 92266 | 92266: Palo Verde | 2022-02-27 | Imperial | 25 | 15 | 108 | |
383480 | 383480 | Unincorporated - Placerita Canyon | Placerita Canyon | 2022-02-27 | Los Angeles | 37 | 15 | 460 | |
384138 | 384138 | 95450 | 95450: Jenner | 2022-02-27 | Sonoma | 97 | 15 | 298 | |
383720 | 383720 | 95715 | 95715: Emigrant Gap | 2022-02-27 | Placer | 61 | 16 | 0 | |
383455 | 383455 | Unincorporated - La Habra Heights | Unincorporated - La Habra Heights | 2022-02-27 | Los Angeles | 37 | 17 | 676 | |
383171 | 383171 | 95493 | 95493 | 2022-02-27 | Lake | 33 | 18 | 241 | |
384128 | 384128 | 95412 | 95412: Annapolis | 2022-02-27 | Sonoma | 97 | 18 | 402 | |
383970 | 383970 | 92145 | 92145: San Diego | 2022-02-27 | San Diego | 73 | 19 | 0 | |
383162 | 383162 | 95443 | 95443 | 2022-02-27 | Lake | 33 | 20 | 270 | |
383935 | 383935 | 92096 | 92096: San Marcos | 2022-02-27 | San Diego | 73 | 20 | 0 | |
383114 | 383114 | 93287 | 93287: Woody | 2022-02-27 | Kern | 29 | 24 | 74 | |
383475 | 383475 | Unincorporated - Padua Hills | Padua Hills | 2022-02-27 | Los Angeles | 37 | 25 | 0 | |
384164 | 384164 | 93212 | Corcoran, Angiola: 93212 | 2022-02-27 | Tulare | 107 | 25 | 0 | |
383091 | 383091 | 92259 | 92259: Ocotillo | 2022-02-27 | Imperial | 25 | 27 | 94 | |
383639 | 383639 | Northeast American Canyon Area | Northeast American Canyon Area | 2022-02-27 | Napa | 55 | 28 | 212 | |
384145 | 384145 | 95497 | 95497: The Sea Ranch | 2022-02-27 | Sonoma | 97 | 30 | 1161 | |
383137 | 383137 | 93220 | 93220: Edison | 2022-02-27 | Kern | 29 | 31 | 313 | |
383849 | 383849 | Oak Glen | Oak Glen | 2022-02-27 | San Bernardino | 71 | 32 | 625 | |
383489 | 383489 | Unincorporated - San Francisquito Canyon/Bouquet Canyon | San Francisquito Canyon/Bouquet Canyon | 2022-02-27 | Los Angeles | 37 | 34 | 858 | |
383633 | 383633 | Chiles Valley Area | Chiles Valley Area | 2022-02-27 | Napa | 55 | 34 | 776 | |
383098 | 383098 | 93226 | 93226: Glennville | 2022-02-27 | Kern | 29 | 35 | 195 | |
383921 | 383921 | 92066 | 92066: Ranchita | 2022-02-27 | San Diego | 73 | 35 | 0 | |
383439 | 383439 | Unincorporated - East Lancaster | East Lancaster | 2022-02-27 | Los Angeles | 37 | 36 | 114 | |
384191 | 384191 | 91307 | 91307: Bell Canyon | 2022-02-27 | Ventura | 111 | 37 | 2391 | |
383830 | 383830 | Green Valley Lake | Green Valley Lake | 2022-02-27 | San Bernardino | 71 | 38 | 412 | |
383855 | 383855 | Pioneertown | Pioneertown | 2022-02-27 | San Bernardino | 71 | 39 | 365 | |
383719 | 383719 | 95714 | 95714: Dutch Flat | 2022-02-27 | Placer | 61 | 40 | 701 | |
383878 | 383878 | 91931 | 91931: Guatay | 2022-02-27 | San Diego | 73 | 40 | 0 | |
384160 | 384160 | North County | North County | 2022-02-27 | Trinity | 105 | 42 | 699 | |
383107 | 383107 | 93255 | 93255: Onyx | 2022-02-27 | Kern | 29 | 44 | 707 | |
383159 | 383159 | 95424 | 95424 | 2022-02-27 | Lake | 33 | 47 | 0 | |
383816 | 383816 | Big River | Big River | 2022-02-27 | San Bernardino | 71 | 47 | 1264 | |
383492 | 383492 | Unincorporated - Sand Canyon | Sand Canyon | 2022-02-27 | Los Angeles | 37 | 48 | 308 | |
383132 | 383132 | 93524 | 93524: Edwards | 2022-02-27 | Kern | 29 | 49 | 168 | |
383647 | 383647 | 95712 | 95712: Chicago Park | 2022-02-27 | Nevada | 57 | 51 | 0 | |
383105 | 383105 | 93251 | 93251: Mc Kittrick | 2022-02-27 | Kern | 29 | 52 | 243 | |
383018 | 383018 | Other | Other | 2022-02-27 | Calaveras | 9 | 53 | ||
383610 | 383610 | 93922 | 93922: Carmel | 2022-02-27 | Monterey | 53 | 53 | 0 | |
383824 | 383824 | Daggett | Daggett | 2022-02-27 | San Bernardino | 71 | 53 | 549 | |
383110 | 383110 | 93276 | 93276: Tupman | 2022-02-27 | Kern | 29 | 55 | 159 | |
383826 | 383826 | Fawnskin | Fawnskin | 2022-02-27 | San Bernardino | 71 | 55 | 528 | |
384114 | 384114 | 94515 | 94515: Calistoga | 2022-02-27 | Sonoma | 97 | 55 | 7436 | |
383619 | 383619 | 93942 | 93942: Monterey | 2022-02-27 | Monterey | 53 | 56 | 0 | |
384115 | 384115 | 94922 | 94922: Bodega | 2022-02-27 | Sonoma | 97 | 57 | 603 | |
384188 | 384188 | 93646 | Traver: 93646 | 2022-02-27 | Tulare | 107 | 57 | 0 | |
383972 | 383972 | 92155 | 92155: Coronado | 2022-02-27 | San Diego | 73 | 58 | 0 | |
383095 | 383095 | 92275 | 92275: Salton City | 2022-02-27 | Imperial | 25 | 62 | 2456 | |
383193 | 383193 | City of Avalon | Avalon | 2022-02-27 | Los Angeles | 37 | 62 | 3869 | |
383491 | 383491 | Unincorporated - San Pasqual | San Pasqual | 2022-02-27 | Los Angeles | 37 | 62 | 2035 | |
384042 | 384042 | La Honda | La Honda | 2022-02-27 | San Mateo | 81 | 62 | 960 | |
383200 | 383200 | City of Bradbury | Bradbury | 2022-02-27 | Los Angeles | 37 | 63 | 1069 | |
383161 | 383161 | 95435 | 95435 | 2022-02-27 | Lake | 33 | 64 | 14 | |
383522 | 383522 | Unincorporated - Whittier Narrows | Whittier Narrows | 2022-02-27 | Los Angeles | 37 | 64 | 12 | |
383728 | 383728 | 96141 | 96141: Homewood | 2022-02-27 | Placer | 61 | 64 | 933 | |
383424 | 383424 | Unincorporated - Bradbury | Unincorporated - Bradbury | 2022-02-27 | Los Angeles | 37 | 66 | 108 | |
383477 | 383477 | Unincorporated - Palos Verdes Peninsula | Palos Verdes Peninsula | 2022-02-27 | Los Angeles | 37 | 66 | 621 | |
383649 | 383649 | 95728 | 95728: Soda Springs | 2022-02-27 | Nevada | 57 | 68 | 229 | |
383143 | 383143 | 93531 | 93531: Keene | 2022-02-27 | Kern | 29 | 70 | 422 | |
383416 | 383416 | Unincorporated - Angeles National Forest | Unincorporated - Angeles National Forest | 2022-02-27 | Los Angeles | 37 | 72 | 1245 | |
383034 | 383034 | Knightsen | Knightsen | 2022-02-27 | Contra Costa | 13 | 73 | 1500 | |
384026 | 384026 | San Simeon | San Simeon | 2022-02-27 | San Luis Obispo | 79 | 74 | 583 | |
383437 | 383437 | Unincorporated - East Covina | East Covina | 2022-02-27 | Los Angeles | 37 | 76 | 329 | |
383056 | 383056 | Dinuba | Dinuba | 2022-02-27 | Fresno | 19 | 77 | 0 | |
384091 | 384091 | 95017 | 95017 | 2022-02-27 | Santa Cruz | 87 | 77 | 603 | |
383917 | 383917 | 92060 | 92060: Palomar Mountain | 2022-02-27 | San Diego | 73 | 79 | 0 | |
383601 | 383601 | 93426 | 93426: Bradley | 2022-02-27 | Monterey | 53 | 81 | 1604 | |
383976 | 383976 | 92672 | 92672: San Clemente | 2022-02-27 | San Diego | 73 | 81 | 0 | |
383016 | 383016 | 95254 | 95254 | 2022-02-27 | Calaveras | 9 | 82 | 1035 | |
383060 | 383060 | Five Points | Five Points | 2022-02-27 | Fresno | 19 | 82 | 0 |
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] INTEGER );