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-10 sorted by population
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date | county | fips | confirmed_cases | note | population ▼ |
---|---|---|---|---|---|---|---|---|---|
909402 | 909402 | Dinuba | Dinuba | 2021-01-10 | Fresno | 19 | 0 | 0 | |
909406 | 909406 | Five Points | Five Points | 2021-01-10 | Fresno | 19 | 23 | 0 | |
909417 | 909417 | Prather | Prather | 2021-01-10 | Fresno | 19 | 16 | 0 | |
909427 | 909427 | 92222 | 92222: Bard | 2021-01-10 | Imperial | 25 | 5 | 0 | |
909432 | 909432 | 92244 | 92244: El Centro | 2021-01-10 | Imperial | 25 | 1 | 0 | |
909505 | 909505 | 95424 | 95424 | 2021-01-10 | Lake | 33 | 5 | 0 | |
909821 | 909821 | Unincorporated - Padua Hills | Padua Hills | 2021-01-10 | Los Angeles | 37 | 6 | 0 | |
909859 | 909859 | Unincorporated - West Chatsworth | West Chatsworth | 2021-01-10 | Los Angeles | 37 | 1 | 0 | |
909953 | 909953 | 93912 | 93912: Boronda | 2021-01-10 | Monterey | 53 | 82 | 0 | |
909956 | 909956 | 93922 | 93922: Carmel | 2021-01-10 | Monterey | 53 | 0 | 0 | |
909965 | 909965 | 93942 | 93942: Monterey | 2021-01-10 | Monterey | 53 | 20 | 0 | |
909992 | 909992 | 95602 | 95602: Auburn | 2021-01-10 | Nevada | 57 | 143 | 0 | |
909993 | 909993 | 95712 | 95712: Chicago Park | 2021-01-10 | Nevada | 57 | 9 | 9 or fewer | 0 |
909996 | 909996 | 95924 | 95924: Cedar Ridge | 2021-01-10 | Nevada | 57 | 26 | 0 | |
910003 | 910003 | 95977 | 95977: Smartville | 2021-01-10 | Nevada | 57 | 16 | 0 | |
910006 | 910006 | 96160 | 96160: Truckee | 2021-01-10 | Nevada | 57 | 76 | 0 | |
910008 | 910008 | 96162 | 96162: Truckee | 2021-01-10 | Nevada | 57 | 56 | 0 | |
910036 | 910036 | Rancho Mission Viejo | Rancho Mission Viejo | 2021-01-10 | Orange | 59 | 226 | 0 | |
910043 | 910043 | Silverado | Silverado | 2021-01-10 | Orange | 59 | 72 | 0 | |
910045 | 910045 | Trabuco Canyon | Trabuco Canyon | 2021-01-10 | Orange | 59 | 660 | 0 | |
910066 | 910066 | 95715 | 95715: Emigrant Gap | 2021-01-10 | Placer | 61 | 5 | 5 or fewer | 0 |
910067 | 910067 | 95717 | 95717: Gold Run | 2021-01-10 | Placer | 61 | 5 | 5 or fewer | 0 |
910069 | 910069 | 95724 | 95724: Norden | 2021-01-10 | Placer | 61 | 5 | 5 or fewer | 0 |
910075 | 910075 | 96142 | 96142: Tahoma | 2021-01-10 | Placer | 61 | 5 | 5 or fewer | 0 |
910081 | 910081 | 96162 | 96162: Truckee | 2021-01-10 | Placer | 61 | 5 | 5 or fewer | 0 |
910177 | 910177 | Havasu Lake | Havasu Lake | 2021-01-10 | San Bernardino | 71 | 0 | 0 | |
910222 | 910222 | 91916 | 91916: Descanso | 2021-01-10 | San Diego | 73 | 63 | 0 | |
910223 | 910223 | 91917 | 91917: Dulzura | 2021-01-10 | San Diego | 73 | 153 | 0 | |
910224 | 910224 | 91931 | 91931: Guatay | 2021-01-10 | San Diego | 73 | 9 | 0 | |
910226 | 910226 | 91934 | 91934: Jacumba | 2021-01-10 | San Diego | 73 | 22 | 0 | |
910227 | 910227 | 91935 | 91935: Jamul | 2021-01-10 | San Diego | 73 | 451 | 0 | |
910232 | 910232 | 91962 | 91962: Pine Valley | 2021-01-10 | San Diego | 73 | 60 | 0 | |
910233 | 910233 | 91963 | 91963: Potrero | 2021-01-10 | San Diego | 73 | 151 | 0 | |
910235 | 910235 | 91978 | 91978: Spring Valley | 2021-01-10 | San Diego | 73 | 580 | 0 | |
910236 | 910236 | 91980 | 91980: Tecate | 2021-01-10 | San Diego | 73 | 159 | 0 | |
910237 | 910237 | 92003 | 92003: Bonsall | 2021-01-10 | San Diego | 73 | 195 | 0 | |
910238 | 910238 | 92004 | 92004: Borrego Springs | 2021-01-10 | San Diego | 73 | 102 | 0 | |
910254 | 910254 | 92036 | 92036: Julian | 2021-01-10 | San Diego | 73 | 55 | 0 | |
910262 | 910262 | 92059 | 92059: Pala | 2021-01-10 | San Diego | 73 | 177 | 0 | |
910263 | 910263 | 92060 | 92060: Palomar Mountain | 2021-01-10 | San Diego | 73 | 8 | 0 | |
910264 | 910264 | 92061 | 92061: Pauma Valley | 2021-01-10 | San Diego | 73 | 126 | 0 | |
910267 | 910267 | 92066 | 92066: Ranchita | 2021-01-10 | San Diego | 73 | 10 | 0 | |
910268 | 910268 | 92067 | 92067: Rancho Santa Fe | 2021-01-10 | San Diego | 73 | 250 | 0 | |
910270 | 910270 | 92070 | 92070: Santa Ysabel | 2021-01-10 | San Diego | 73 | 49 | 0 | |
910278 | 910278 | 92086 | 92086: Warner Springs | 2021-01-10 | San Diego | 73 | 42 | 0 | |
910279 | 910279 | 92091 | 92091: Rancho Santa Fe | 2021-01-10 | San Diego | 73 | 22 | 0 | |
910281 | 910281 | 92096 | 92096: San Marcos | 2021-01-10 | San Diego | 73 | 5 | 0 | |
910301 | 910301 | 92121 | 92121: San Diego | 2021-01-10 | San Diego | 73 | 122 | 0 | |
910311 | 910311 | 92134 | 92134: San Diego | 2021-01-10 | San Diego | 73 | 30 | 0 | |
910312 | 910312 | 92135 | 92135: Coronado | 2021-01-10 | San Diego | 73 | 72 | 0 | |
910315 | 910315 | 92140 | 92140: San Diego | 2021-01-10 | San Diego | 73 | 102 | 0 | |
910316 | 910316 | 92145 | 92145: San Diego | 2021-01-10 | San Diego | 73 | 12 | 0 | |
910318 | 910318 | 92155 | 92155: Coronado | 2021-01-10 | San Diego | 73 | 13 | 0 | |
910320 | 910320 | 92182 | 92182: San Diego | 2021-01-10 | San Diego | 73 | 21 | 0 | |
910321 | 910321 | 92536 | 92536: Aguanga | 2021-01-10 | San Diego | 73 | 3 | 0 | |
910322 | 910322 | 92672 | 92672: San Clemente | 2021-01-10 | San Diego | 73 | 19 | 0 | |
910325 | 910325 | 91905 | 91905: Boulevard | 2021-01-10 | San Diego | 73 | 46 | 0 | |
910326 | 910326 | 91906 | 91906: Campo | 2021-01-10 | San Diego | 73 | 198 | 0 | |
910354 | 910354 | ASH (patients) | ASH (patients) | 2021-01-10 | San Luis Obispo | 79 | 161 | 0 | |
910358 | 910358 | CMC (Inmates) | CMC (Inmates) | 2021-01-10 | San Luis Obispo | 79 | 1515 | 0 | |
910359 | 910359 | Cal Poly (campus residents) | Cal Poly (campus residents) | 2021-01-10 | San Luis Obispo | 79 | 256 | 0 | |
910410 | 910410 | Lompoc Federal Prison | Lompoc Federal Prison | 2021-01-10 | Santa Barbara | 83 | 1057 | 0 | |
910494 | 910494 | 93212 | Corcoran, Angiola: 93212 | 2021-01-10 | Tulare | 107 | 10 | 0 | |
910518 | 910518 | 93646 | Traver: 93646 | 2021-01-10 | Tulare | 107 | 14 | 0 | |
910520 | 910520 | 93654 | Orosi: 93654 | 2021-01-10 | Tulare | 107 | 23 | 0 | |
909796 | 909796 | Unincorporated - Harbor Gateway | Unincorporated - Harbor Gateway | 2021-01-10 | Los Angeles | 37 | 1 | 1 | |
909808 | 909808 | Unincorporated - Lakewood | Unincorporated - Lakewood | 2021-01-10 | Los Angeles | 37 | 0 | 1 | |
909793 | 909793 | Unincorporated - Franklin Canyon | Franklin Canyon | 2021-01-10 | Los Angeles | 37 | 1 | 12 | |
909868 | 909868 | Unincorporated - Whittier Narrows | Whittier Narrows | 2021-01-10 | Los Angeles | 37 | 8 | 12 | |
909507 | 909507 | 95435 | 95435 | 2021-01-10 | Lake | 33 | 21 | 14 | |
909994 | 909994 | 95724 | 95724: Norden | 2021-01-10 | Nevada | 57 | 9 | 9 or fewer | 20 |
909476 | 909476 | 93519 | 93519: Cantil | 2021-01-10 | Kern | 29 | 0 | 28 | |
910362 | 910362 | Creston | Creston | 2021-01-10 | San Luis Obispo | 79 | 60 | 30 | |
909339 | 909339 | Volcano | Volcano | 2021-01-10 | Amador | 5 | 22 | 44 | |
910004 | 910004 | 95986 | 95986: Washington | 2021-01-10 | Nevada | 57 | 9 | 9 or fewer | 53 |
909460 | 909460 | 93287 | 93287: Woody | 2021-01-10 | Kern | 29 | 6 | 74 | |
909437 | 909437 | 92259 | 92259: Ocotillo | 2021-01-10 | Imperial | 25 | 6 | 94 | |
910005 | 910005 | 96111 | 96111: Floriston | 2021-01-10 | Nevada | 57 | 9 | 9 or fewer | 94 |
909438 | 909438 | 92266 | 92266: Palo Verde | 2021-01-10 | Imperial | 25 | 6 | 108 | |
909770 | 909770 | Unincorporated - Bradbury | Unincorporated - Bradbury | 2021-01-10 | Los Angeles | 37 | 25 | 108 | |
909785 | 909785 | Unincorporated - East Lancaster | East Lancaster | 2021-01-10 | Los Angeles | 37 | 12 | 114 | |
909488 | 909488 | 93528 | 93528: Johannesburg | 2021-01-10 | Kern | 29 | 2 | 124 | |
909490 | 909490 | 93554 | 93554: Randsburg | 2021-01-10 | Kern | 29 | 6 | 143 | |
909841 | 909841 | Unincorporated - Saugus | Saugus | 2021-01-10 | Los Angeles | 37 | 100 | 155 | |
909456 | 909456 | 93276 | 93276: Tupman | 2021-01-10 | Kern | 29 | 10 | 159 | |
909350 | 909350 | 95232, 95245 | 95232, 95245 | 2021-01-10 | Calaveras | 9 | 23 | 161 | |
909478 | 909478 | 93524 | 93524: Edwards | 2021-01-10 | Kern | 29 | 3 | 168 | |
910390 | 910390 | Loma Mar | Loma Mar | 2021-01-10 | San Mateo | 81 | 9 | 9 or fewer | 172 |
909444 | 909444 | 93226 | 93226: Glennville | 2021-01-10 | Kern | 29 | 11 | 195 | |
909614 | 909614 | City of Vernon | Vernon | 2021-01-10 | Los Angeles | 37 | 88 | 209 | |
909317 | 909317 | 94613 | 94613: Oakland | 2021-01-10 | Alameda | 1 | 2 | 212 | |
909985 | 909985 | Northeast American Canyon Area | Northeast American Canyon Area | 2021-01-10 | Napa | 55 | 7 | 212 | |
910396 | 910396 | Pescadero | Pescadero | 2021-01-10 | San Mateo | 81 | 38 | 219 | |
909817 | 909817 | Unincorporated - Newhall | Newhall | 2021-01-10 | Los Angeles | 37 | 57 | 220 | |
909995 | 909995 | 95728 | 95728: Soda Springs | 2021-01-10 | Nevada | 57 | 14 | 229 | |
909517 | 909517 | 95493 | 95493 | 2021-01-10 | Lake | 33 | 1 | 241 | |
909451 | 909451 | 93251 | 93251: Mc Kittrick | 2021-01-10 | Kern | 29 | 17 | 243 | |
909839 | 909839 | Unincorporated - Santa Catalina Island | Santa Catalina Island | 2021-01-10 | Los Angeles | 37 | 99 | 267 | |
909508 | 909508 | 95443 | 95443 | 2021-01-10 | Lake | 33 | 2 | 270 | |
910468 | 910468 | 95450 | 95450: Jenner | 2021-01-10 | Sonoma | 97 | 10 | 10 or fewer | 298 |
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 );