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-01-04 sorted by confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date | county | fips | confirmed_cases ▼ | note | population |
---|---|---|---|---|---|---|---|---|---|
916938 | 916938 | 94505 | 94505: Discovery Bay | 2021-01-04 | Alameda | 1 | 0 | 16382 | |
916939 | 916939 | 94514 | 94514: Byron | 2021-01-04 | Alameda | 1 | 0 | 1461 | |
917012 | 917012 | Other | Other | 2021-01-04 | Calaveras | 9 | 0 | ||
917028 | 917028 | Knightsen | Knightsen | 2021-01-04 | Contra Costa | 13 | 0 | 1500 | |
917058 | 917058 | Dinuba | Dinuba | 2021-01-04 | Fresno | 19 | 0 | 0 | |
917059 | 917059 | Dos Palos | Dos Palos | 2021-01-04 | Fresno | 19 | 0 | ||
917074 | 917074 | Raisin | Raisin | 2021-01-04 | Fresno | 19 | 0 | 380 | |
917087 | 917087 | 92243 | 92243: El Centro | 2021-01-04 | Imperial | 25 | 0 | 50484 | |
917132 | 917132 | 93519 | 93519: Cantil | 2021-01-04 | Kern | 29 | 0 | 28 | |
917430 | 917430 | Unincorporated - Charter Oak | Charter Oak | 2021-01-04 | Los Angeles | 37 | 0 | 9046 | |
917464 | 917464 | Unincorporated - Lakewood | Unincorporated - Lakewood | 2021-01-04 | Los Angeles | 37 | 0 | 1 | |
917482 | 917482 | Unincorporated - Placerita Canyon | Placerita Canyon | 2021-01-04 | Los Angeles | 37 | 0 | 460 | |
917603 | 917603 | 93426 | 93426: Bradley | 2021-01-04 | Monterey | 53 | 0 | 1604 | |
917612 | 917612 | 93922 | 93922: Carmel | 2021-01-04 | Monterey | 53 | 0 | 0 | |
917833 | 917833 | Havasu Lake | Havasu Lake | 2021-01-04 | San Bernardino | 71 | 0 | 0 | |
918114 | 918114 | 95412 | 95412: Annapolis | 2021-01-04 | Sonoma | 97 | 0 | 402 | |
916973 | 916973 | 94613 | 94613: Oakland | 2021-01-04 | Alameda | 1 | 1 | 212 | |
916987 | 916987 | 95377 | 95377: Tracy | 2021-01-04 | Alameda | 1 | 1 | 32091 | |
916988 | 916988 | 95391 | 95391: Mountain House | 2021-01-04 | Alameda | 1 | 1 | 20131 | |
917088 | 917088 | 92244 | 92244: El Centro | 2021-01-04 | Imperial | 25 | 1 | 0 | |
917173 | 917173 | 95493 | 95493 | 2021-01-04 | Lake | 33 | 1 | 241 | |
917449 | 917449 | Unincorporated - Franklin Canyon | Franklin Canyon | 2021-01-04 | Los Angeles | 37 | 1 | 12 | |
917452 | 917452 | Unincorporated - Harbor Gateway | Unincorporated - Harbor Gateway | 2021-01-04 | Los Angeles | 37 | 1 | 1 | |
917515 | 917515 | Unincorporated - West Chatsworth | West Chatsworth | 2021-01-04 | Los Angeles | 37 | 1 | 0 | |
917847 | 917847 | Mt Baldy | Mt Baldy | 2021-01-04 | San Bernardino | 71 | 1 | 537 | |
917144 | 917144 | 93528 | 93528: Johannesburg | 2021-01-04 | Kern | 29 | 2 | 124 | |
917164 | 917164 | 95443 | 95443 | 2021-01-04 | Lake | 33 | 2 | 270 | |
917813 | 917813 | Arrowbear | Arrowbear | 2021-01-04 | San Bernardino | 71 | 2 | 723 | |
917827 | 917827 | Devore | Devore | 2021-01-04 | San Bernardino | 71 | 2 | 2283 | |
917116 | 917116 | 93287 | 93287: Woody | 2021-01-04 | Kern | 29 | 3 | 74 | |
917134 | 917134 | 93524 | 93524: Edwards | 2021-01-04 | Kern | 29 | 3 | 168 | |
917977 | 917977 | 92536 | 92536: Aguanga | 2021-01-04 | San Diego | 73 | 3 | 0 | |
918146 | 918146 | North County | North County | 2021-01-04 | Trinity | 105 | 4 | 699 | |
917083 | 917083 | 92222 | 92222: Bard | 2021-01-04 | Imperial | 25 | 5 | 0 | |
917093 | 917093 | 92259 | 92259: Ocotillo | 2021-01-04 | Imperial | 25 | 5 | 94 | |
917161 | 917161 | 95424 | 95424 | 2021-01-04 | Lake | 33 | 5 | 0 | |
917721 | 917721 | 95714 | 95714: Dutch Flat | 2021-01-04 | Placer | 61 | 5 | 5 or fewer | 701 |
917722 | 917722 | 95715 | 95715: Emigrant Gap | 2021-01-04 | Placer | 61 | 5 | 5 or fewer | 0 |
917723 | 917723 | 95717 | 95717: Gold Run | 2021-01-04 | Placer | 61 | 5 | 5 or fewer | 0 |
917725 | 917725 | 95724 | 95724: Norden | 2021-01-04 | Placer | 61 | 5 | 5 or fewer | 0 |
917731 | 917731 | 96142 | 96142: Tahoma | 2021-01-04 | Placer | 61 | 5 | 5 or fewer | 0 |
917737 | 917737 | 96162 | 96162: Truckee | 2021-01-04 | Placer | 61 | 5 | 5 or fewer | 0 |
917818 | 917818 | Big River | Big River | 2021-01-04 | San Bernardino | 71 | 5 | 1264 | |
917832 | 917832 | Green Valley Lake | Green Valley Lake | 2021-01-04 | San Bernardino | 71 | 5 | 412 | |
917851 | 917851 | Oak Glen | Oak Glen | 2021-01-04 | San Bernardino | 71 | 5 | 625 | |
917937 | 917937 | 92096 | 92096: San Marcos | 2021-01-04 | San Diego | 73 | 5 | 0 | |
917060 | 917060 | Dunlap | Dunlap | 2021-01-04 | Fresno | 19 | 6 | ||
917094 | 917094 | 92266 | 92266: Palo Verde | 2021-01-04 | Imperial | 25 | 6 | 108 | |
917146 | 917146 | 93554 | 93554: Randsburg | 2021-01-04 | Kern | 29 | 6 | 143 | |
917195 | 917195 | City of Avalon | Avalon | 2021-01-04 | Los Angeles | 37 | 6 | 3869 | |
917477 | 917477 | Unincorporated - Padua Hills | Padua Hills | 2021-01-04 | Los Angeles | 37 | 6 | 0 | |
917635 | 917635 | Chiles Valley Area | Chiles Valley Area | 2021-01-04 | Napa | 55 | 6 | 776 | |
917641 | 917641 | Northeast American Canyon Area | Northeast American Canyon Area | 2021-01-04 | Napa | 55 | 6 | 212 | |
917730 | 917730 | 96141 | 96141: Homewood | 2021-01-04 | Placer | 61 | 6 | 933 | |
917857 | 917857 | Pioneertown | Pioneertown | 2021-01-04 | San Bernardino | 71 | 6 | 365 | |
917880 | 917880 | 91931 | 91931: Guatay | 2021-01-04 | San Diego | 73 | 6 | 0 | |
917109 | 917109 | 93255 | 93255: Onyx | 2021-01-04 | Kern | 29 | 7 | 707 | |
917821 | 917821 | Cedar Glen | Cedar Glen | 2021-01-04 | San Bernardino | 71 | 7 | 739 | |
917919 | 917919 | 92060 | 92060: Palomar Mountain | 2021-01-04 | San Diego | 73 | 7 | 0 | |
918177 | 918177 | 91307 | 91307: Bell Canyon | 2021-01-04 | Ventura | 111 | 7 | 2391 | |
917491 | 917491 | Unincorporated - San Francisquito Canyon/Bouquet Canyon | San Francisquito Canyon/Bouquet Canyon | 2021-01-04 | Los Angeles | 37 | 8 | 858 | |
917524 | 917524 | Unincorporated - Whittier Narrows | Whittier Narrows | 2021-01-04 | Los Angeles | 37 | 8 | 12 | |
917640 | 917640 | North Calistoga | North Calistoga | 2021-01-04 | Napa | 55 | 8 | 980 | |
917828 | 917828 | Fawnskin | Fawnskin | 2021-01-04 | San Bernardino | 71 | 8 | 528 | |
918028 | 918028 | San Simeon | San Simeon | 2021-01-04 | San Luis Obispo | 79 | 8 | 583 | |
917649 | 917649 | 95712 | 95712: Chicago Park | 2021-01-04 | Nevada | 57 | 9 | 9 or fewer | 0 |
917650 | 917650 | 95724 | 95724: Norden | 2021-01-04 | Nevada | 57 | 9 | 9 or fewer | 20 |
917660 | 917660 | 95986 | 95986: Washington | 2021-01-04 | Nevada | 57 | 9 | 9 or fewer | 53 |
917661 | 917661 | 96111 | 96111: Floriston | 2021-01-04 | Nevada | 57 | 9 | 9 or fewer | 94 |
917923 | 917923 | 92066 | 92066: Ranchita | 2021-01-04 | San Diego | 73 | 9 | 0 | |
918044 | 918044 | La Honda | La Honda | 2021-01-04 | San Mateo | 81 | 9 | 9 or fewer | 960 |
918046 | 918046 | Loma Mar | Loma Mar | 2021-01-04 | San Mateo | 81 | 9 | 9 or fewer | 172 |
918054 | 918054 | Princeton | Princeton | 2021-01-04 | San Mateo | 81 | 9 | 9 or fewer | 382 |
918150 | 918150 | 93212 | Corcoran, Angiola: 93212 | 2021-01-04 | Tulare | 107 | 9 | 0 | |
917100 | 917100 | 93226 | 93226: Glennville | 2021-01-04 | Kern | 29 | 10 | 195 | |
917112 | 917112 | 93276 | 93276: Tupman | 2021-01-04 | Kern | 29 | 10 | 159 | |
917441 | 917441 | Unincorporated - East Lancaster | East Lancaster | 2021-01-04 | Los Angeles | 37 | 10 | 114 | |
917494 | 917494 | Unincorporated - Sand Canyon | Sand Canyon | 2021-01-04 | Los Angeles | 37 | 10 | 308 | |
917826 | 917826 | Daggett | Daggett | 2021-01-04 | San Bernardino | 71 | 10 | 549 | |
918100 | 918100 | 94515 | 94515: Calistoga | 2021-01-04 | Sonoma | 97 | 10 | 10 or fewer | 7436 |
918101 | 918101 | 94922 | 94922: Bodega | 2021-01-04 | Sonoma | 97 | 10 | 10 or fewer | 603 |
918124 | 918124 | 95450 | 95450: Jenner | 2021-01-04 | Sonoma | 97 | 10 | 10 or fewer | 298 |
918127 | 918127 | 95465 | 95465: Occidental | 2021-01-04 | Sonoma | 97 | 10 | 10 or fewer | 2104 |
918131 | 918131 | 95497 | 95497: The Sea Ranch | 2021-01-04 | Sonoma | 97 | 10 | 10 or fewer | 1161 |
917457 | 917457 | Unincorporated - La Habra Heights | Unincorporated - La Habra Heights | 2021-01-04 | Los Angeles | 37 | 11 | 676 | |
917657 | 917657 | 95960 | 95960: North San Juan | 2021-01-04 | Nevada | 57 | 11 | 825 | |
918115 | 918115 | 95421 | 95421: Cazadero | 2021-01-04 | Sonoma | 97 | 11 | 1681 | |
917972 | 917972 | 92145 | 92145: San Diego | 2021-01-04 | San Diego | 73 | 12 | 0 | |
918174 | 918174 | 93646 | Traver: 93646 | 2021-01-04 | Tulare | 107 | 12 | 0 | |
917621 | 917621 | 93942 | 93942: Monterey | 2021-01-04 | Monterey | 53 | 13 | 0 | |
917638 | 917638 | Lake Berryessa | Lake Berryessa | 2021-01-04 | Napa | 55 | 13 | 1624 | |
917651 | 917651 | 95728 | 95728: Soda Springs | 2021-01-04 | Nevada | 57 | 13 | 229 | |
917974 | 917974 | 92155 | 92155: Coronado | 2021-01-04 | San Diego | 73 | 13 | 0 | |
917003 | 917003 | 95225 | 95225 | 2021-01-04 | Calaveras | 9 | 14 | 378 | |
917131 | 917131 | 93518 | 93518: Caliente | 2021-01-04 | Kern | 29 | 14 | 995 | |
917141 | 917141 | 93224 | 93224: Fellows | 2021-01-04 | Kern | 29 | 14 | 402 | |
917426 | 917426 | Unincorporated - Bradbury | Unincorporated - Bradbury | 2021-01-04 | Los Angeles | 37 | 14 | 108 | |
917499 | 917499 | Unincorporated - South Antelope Valley | South Antelope Valley | 2021-01-04 | Los Angeles | 37 | 14 | 455 | |
917642 | 917642 | Pope Valley Area | Pope Valley Area | 2021-01-04 | Napa | 55 | 14 | 1275 | |
917708 | 917708 | 95626 | 95626: Elverta | 2021-01-04 | Placer | 61 | 14 | 6371 |
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 );