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,276 rows where "date" is on date 2021-07-05 sorted by confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date | county | fips | confirmed_cases ▼ | note | population |
---|---|---|---|---|---|---|---|---|---|
684826 | 684826 | Dinuba | Dinuba | 2021-07-05 | Fresno | 19 | 0 | 0 | |
684827 | 684827 | Dos Palos | Dos Palos | 2021-07-05 | Fresno | 19 | 0 | ||
684842 | 684842 | Raisin | Raisin | 2021-07-05 | Fresno | 19 | 0 | 380 | |
685198 | 685198 | Unincorporated - Charter Oak | Charter Oak | 2021-07-05 | Los Angeles | 37 | 0 | 9046 | |
685232 | 685232 | Unincorporated - Lakewood | Unincorporated - Lakewood | 2021-07-05 | Los Angeles | 37 | 0 | 1 | |
685601 | 685601 | Havasu Lake | Havasu Lake | 2021-07-05 | San Bernardino | 71 | 0 | 0 | |
684706 | 684706 | 94505 | 94505: Discovery Bay | 2021-07-05 | Alameda | 1 | 1 | 16382 | |
684707 | 684707 | 94514 | 94514: Byron | 2021-07-05 | Alameda | 1 | 1 | 1461 | |
684755 | 684755 | 95377 | 95377: Tracy | 2021-07-05 | Alameda | 1 | 1 | 32091 | |
684756 | 684756 | 95391 | 95391: Mountain House | 2021-07-05 | Alameda | 1 | 1 | 20131 | |
684900 | 684900 | 93519 | 93519: Cantil | 2021-07-05 | Kern | 29 | 1 | 28 | |
685217 | 685217 | Unincorporated - Franklin Canyon | Franklin Canyon | 2021-07-05 | Los Angeles | 37 | 1 | 12 | |
685220 | 685220 | Unincorporated - Harbor Gateway | Unincorporated - Harbor Gateway | 2021-07-05 | Los Angeles | 37 | 1 | 1 | |
684741 | 684741 | 94613 | 94613: Oakland | 2021-07-05 | Alameda | 1 | 2 | 212 | |
684932 | 684932 | 95443 | 95443 | 2021-07-05 | Lake | 33 | 2 | 270 | |
685283 | 685283 | Unincorporated - West Chatsworth | West Chatsworth | 2021-07-05 | Los Angeles | 37 | 2 | 0 | |
685595 | 685595 | Devore | Devore | 2021-07-05 | San Bernardino | 71 | 2 | 2283 | |
685615 | 685615 | Mt Baldy | Mt Baldy | 2021-07-05 | San Bernardino | 71 | 2 | 537 | |
685250 | 685250 | Unincorporated - Placerita Canyon | Placerita Canyon | 2021-07-05 | Los Angeles | 37 | 3 | 460 | |
684912 | 684912 | 93528 | 93528: Johannesburg | 2021-07-05 | Kern | 29 | 4 | 124 | |
685491 | 685491 | 95717 | 95717: Gold Run | 2021-07-05 | Placer | 61 | 5 | 5 or fewer | 0 |
685493 | 685493 | 95724 | 95724: Norden | 2021-07-05 | Placer | 61 | 5 | 5 or fewer | 0 |
685499 | 685499 | 96142 | 96142: Tahoma | 2021-07-05 | Placer | 61 | 5 | 5 or fewer | 0 |
685505 | 685505 | 96162 | 96162: Truckee | 2021-07-05 | Placer | 61 | 5 | 5 or fewer | 0 |
685581 | 685581 | Arrowbear | Arrowbear | 2021-07-05 | San Bernardino | 71 | 5 | 723 | |
685705 | 685705 | 92096 | 92096: San Marcos | 2021-07-05 | San Diego | 73 | 5 | 0 | |
684828 | 684828 | Dunlap | Dunlap | 2021-07-05 | Fresno | 19 | 6 | ||
685403 | 685403 | Chiles Valley Area | Chiles Valley Area | 2021-07-05 | Napa | 55 | 6 | 776 | |
684941 | 684941 | 95493 | 95493 | 2021-07-05 | Lake | 33 | 7 | 241 | |
685589 | 685589 | Cedar Glen | Cedar Glen | 2021-07-05 | San Bernardino | 71 | 7 | 739 | |
685745 | 685745 | 92536 | 92536: Aguanga | 2021-07-05 | San Diego | 73 | 7 | 0 | |
684862 | 684862 | 92266 | 92266: Palo Verde | 2021-07-05 | Imperial | 25 | 8 | 108 | |
685625 | 685625 | Pioneertown | Pioneertown | 2021-07-05 | San Bernardino | 71 | 8 | 365 | |
684851 | 684851 | 92222 | 92222: Bard | 2021-07-05 | Imperial | 25 | 9 | 0 | |
684902 | 684902 | 93524 | 93524: Edwards | 2021-07-05 | Kern | 29 | 9 | 168 | |
684914 | 684914 | 93554 | 93554: Randsburg | 2021-07-05 | Kern | 29 | 9 | 143 | |
685428 | 685428 | 95986 | 95986: Washington | 2021-07-05 | Nevada | 57 | 9 | 9 or fewer | 53 |
685429 | 685429 | 96111 | 96111: Floriston | 2021-07-05 | Nevada | 57 | 9 | 9 or fewer | 94 |
685490 | 685490 | 95715 | 95715: Emigrant Gap | 2021-07-05 | Placer | 61 | 9 | 0 | |
685814 | 685814 | Loma Mar | Loma Mar | 2021-07-05 | San Mateo | 81 | 9 | 9 or fewer | 172 |
685822 | 685822 | Princeton | Princeton | 2021-07-05 | San Mateo | 81 | 9 | 9 or fewer | 382 |
685245 | 685245 | Unincorporated - Padua Hills | Padua Hills | 2021-07-05 | Los Angeles | 37 | 10 | 0 | |
685882 | 685882 | 95412 | 95412: Annapolis | 2021-07-05 | Sonoma | 97 | 10 | 10 or fewer | 402 |
685892 | 685892 | 95450 | 95450: Jenner | 2021-07-05 | Sonoma | 97 | 10 | 10 or fewer | 298 |
685899 | 685899 | 95497 | 95497: The Sea Ranch | 2021-07-05 | Sonoma | 97 | 10 | 10 or fewer | 1161 |
685918 | 685918 | 93212 | Corcoran, Angiola: 93212 | 2021-07-05 | Tulare | 107 | 10 | 0 | |
685409 | 685409 | Northeast American Canyon Area | Northeast American Canyon Area | 2021-07-05 | Napa | 55 | 11 | 212 | |
685489 | 685489 | 95714 | 95714: Dutch Flat | 2021-07-05 | Placer | 61 | 11 | 701 | |
685417 | 685417 | 95712 | 95712: Chicago Park | 2021-07-05 | Nevada | 57 | 12 | 0 | |
685648 | 685648 | 91931 | 91931: Guatay | 2021-07-05 | San Diego | 73 | 12 | 0 | |
685600 | 685600 | Green Valley Lake | Green Valley Lake | 2021-07-05 | San Bernardino | 71 | 13 | 412 | |
685691 | 685691 | 92066 | 92066: Ranchita | 2021-07-05 | San Diego | 73 | 13 | 0 | |
685740 | 685740 | 92145 | 92145: San Diego | 2021-07-05 | San Diego | 73 | 13 | 0 | |
685812 | 685812 | La Honda | La Honda | 2021-07-05 | San Mateo | 81 | 13 | 960 | |
685868 | 685868 | 94515 | 94515: Calistoga | 2021-07-05 | Sonoma | 97 | 13 | 7436 | |
684880 | 684880 | 93276 | 93276: Tupman | 2021-07-05 | Kern | 29 | 14 | 159 | |
684929 | 684929 | 95424 | 95424 | 2021-07-05 | Lake | 33 | 14 | 0 | |
685746 | 685746 | 92672 | 92672: San Clemente | 2021-07-05 | San Diego | 73 | 14 | 0 | |
684861 | 684861 | 92259 | 92259: Ocotillo | 2021-07-05 | Imperial | 25 | 15 | 94 | |
684884 | 684884 | 93287 | 93287: Woody | 2021-07-05 | Kern | 29 | 15 | 74 | |
685259 | 685259 | Unincorporated - San Francisquito Canyon/Bouquet Canyon | San Francisquito Canyon/Bouquet Canyon | 2021-07-05 | Los Angeles | 37 | 15 | 858 | |
685619 | 685619 | Oak Glen | Oak Glen | 2021-07-05 | San Bernardino | 71 | 15 | 625 | |
684841 | 684841 | Prather | Prather | 2021-07-05 | Fresno | 19 | 16 | 0 | |
684877 | 684877 | 93255 | 93255: Onyx | 2021-07-05 | Kern | 29 | 16 | 707 | |
684963 | 684963 | City of Avalon | Avalon | 2021-07-05 | Los Angeles | 37 | 16 | 3869 | |
685225 | 685225 | Unincorporated - La Habra Heights | Unincorporated - La Habra Heights | 2021-07-05 | Los Angeles | 37 | 16 | 676 | |
685292 | 685292 | Unincorporated - Whittier Narrows | Whittier Narrows | 2021-07-05 | Los Angeles | 37 | 16 | 12 | |
685498 | 685498 | 96141 | 96141: Homewood | 2021-07-05 | Placer | 61 | 16 | 933 | |
685209 | 685209 | Unincorporated - East Lancaster | East Lancaster | 2021-07-05 | Los Angeles | 37 | 17 | 114 | |
684868 | 684868 | 93226 | 93226: Glennville | 2021-07-05 | Kern | 29 | 18 | 195 | |
684907 | 684907 | 93220 | 93220: Edison | 2021-07-05 | Kern | 29 | 18 | 313 | |
685262 | 685262 | Unincorporated - Sand Canyon | Sand Canyon | 2021-07-05 | Los Angeles | 37 | 18 | 308 | |
685893 | 685893 | 95452 | 95452: Kenwood | 2021-07-05 | Sonoma | 97 | 18 | 970 | |
685914 | 685914 | North County | North County | 2021-07-05 | Trinity | 105 | 18 | 699 | |
685869 | 685869 | 94922 | 94922: Bodega | 2021-07-05 | Sonoma | 97 | 19 | 603 | |
685586 | 685586 | Big River | Big River | 2021-07-05 | San Bernardino | 71 | 20 | 1264 | |
685594 | 685594 | Daggett | Daggett | 2021-07-05 | San Bernardino | 71 | 20 | 549 | |
685796 | 685796 | San Simeon | San Simeon | 2021-07-05 | San Luis Obispo | 79 | 20 | 583 | |
685380 | 685380 | 93922 | 93922: Carmel | 2021-07-05 | Monterey | 53 | 21 | 0 | |
685596 | 685596 | Fawnskin | Fawnskin | 2021-07-05 | San Bernardino | 71 | 21 | 528 | |
685687 | 685687 | 92060 | 92060: Palomar Mountain | 2021-07-05 | San Diego | 73 | 21 | 0 | |
685742 | 685742 | 92155 | 92155: Coronado | 2021-07-05 | San Diego | 73 | 21 | 0 | |
684830 | 684830 | Five Points | Five Points | 2021-07-05 | Fresno | 19 | 23 | 0 | |
685247 | 685247 | Unincorporated - Palos Verdes Peninsula | Palos Verdes Peninsula | 2021-07-05 | Los Angeles | 37 | 23 | 621 | |
685894 | 685894 | 95462 | 95462: Monte Rio | 2021-07-05 | Sonoma | 97 | 23 | 1265 | |
684875 | 684875 | 93251 | 93251: Mc Kittrick | 2021-07-05 | Kern | 29 | 24 | 243 | |
685476 | 685476 | 95626 | 95626: Elverta | 2021-07-05 | Placer | 61 | 24 | 6371 | |
685942 | 685942 | 93646 | Traver: 93646 | 2021-07-05 | Tulare | 107 | 24 | 0 | |
684899 | 684899 | 93518 | 93518: Caliente | 2021-07-05 | Kern | 29 | 25 | 995 | |
685425 | 685425 | 95960 | 95960: North San Juan | 2021-07-05 | Nevada | 57 | 25 | 825 | |
685427 | 685427 | 95977 | 95977: Smartville | 2021-07-05 | Nevada | 57 | 25 | 0 | |
684796 | 684796 | Knightsen | Knightsen | 2021-07-05 | Contra Costa | 13 | 26 | 1500 | |
685419 | 685419 | 95728 | 95728: Soda Springs | 2021-07-05 | Nevada | 57 | 26 | 229 | |
685895 | 685895 | 95465 | 95465: Occidental | 2021-07-05 | Sonoma | 97 | 26 | 2104 | |
684913 | 684913 | 93531 | 93531: Keene | 2021-07-05 | Kern | 29 | 28 | 422 | |
685267 | 685267 | Unincorporated - South Antelope Valley | South Antelope Valley | 2021-07-05 | Los Angeles | 37 | 28 | 455 | |
684771 | 684771 | 95225 | 95225 | 2021-07-05 | Calaveras | 9 | 29 | 378 | |
685147 | 685147 | Los Angeles - Sycamore Square | Sycamore Square | 2021-07-05 | Los Angeles | 37 | 29 | 647 | |
685371 | 685371 | 93426 | 93426: Bradley | 2021-07-05 | Monterey | 53 | 29 | 1604 | |
685389 | 685389 | 93942 | 93942: Monterey | 2021-07-05 | Monterey | 53 | 29 | 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 );