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,263 rows where "date" is on date 2022-09-17 sorted by population
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date | county | fips | confirmed_cases | note | population ▼ |
---|---|---|---|---|---|---|---|---|---|
127279 | 127279 | Dinuba | Dinuba | 2022-09-17 | Fresno | 19 | 120 | 0 | |
127283 | 127283 | Five Points | Five Points | 2022-09-17 | Fresno | 19 | 150 | 0 | |
127294 | 127294 | Prather | Prather | 2022-09-17 | Fresno | 19 | 188 | 0 | |
127308 | 127308 | 92222 | 92222: Bard | 2022-09-17 | Imperial | 25 | 13 | 0 | |
127313 | 127313 | 92244 | 92244: El Centro | 2022-09-17 | Imperial | 25 | 225 | 0 | |
127386 | 127386 | 95424 | 95424 | 2022-09-17 | Lake | 33 | 49 | 0 | |
127702 | 127702 | Unincorporated - Padua Hills | Padua Hills | 2022-09-17 | Los Angeles | 37 | 34 | 0 | |
127740 | 127740 | Unincorporated - West Chatsworth | West Chatsworth | 2022-09-17 | Los Angeles | 37 | 4 | 0 | |
127834 | 127834 | 93912 | 93912: Boronda | 2022-09-17 | Monterey | 53 | 287 | 0 | |
127837 | 127837 | 93922 | 93922: Carmel | 2022-09-17 | Monterey | 53 | 95 | 0 | |
127846 | 127846 | 93942 | 93942: Monterey | 2022-09-17 | Monterey | 53 | 89 | 0 | |
127873 | 127873 | 95602 | 95602: Auburn | 2022-09-17 | Nevada | 57 | 747 | 0 | |
127874 | 127874 | 95712 | 95712: Chicago Park | 2022-09-17 | Nevada | 57 | 60 | 0 | |
127877 | 127877 | 95924 | 95924: Cedar Ridge | 2022-09-17 | Nevada | 57 | 113 | 0 | |
127884 | 127884 | 95977 | 95977: Smartville | 2022-09-17 | Nevada | 57 | 128 | 0 | |
127887 | 127887 | 96160 | 96160: Truckee | 2022-09-17 | Nevada | 57 | 348 | 0 | |
127889 | 127889 | 96162 | 96162: Truckee | 2022-09-17 | Nevada | 57 | 227 | 0 | |
127917 | 127917 | Rancho Mission Viejo | Rancho Mission Viejo | 2022-09-17 | Orange | 59 | 1457 | 0 | |
127924 | 127924 | Silverado | Silverado | 2022-09-17 | Orange | 59 | 284 | 0 | |
127926 | 127926 | Trabuco Canyon | Trabuco Canyon | 2022-09-17 | Orange | 59 | 3374 | 0 | |
127947 | 127947 | 95715 | 95715: Emigrant Gap | 2022-09-17 | Placer | 61 | 18 | 0 | |
127948 | 127948 | 95717 | 95717: Gold Run | 2022-09-17 | Placer | 61 | 25 | 0 | |
127950 | 127950 | 95724 | 95724: Norden | 2022-09-17 | Placer | 61 | 6 | 0 | |
127956 | 127956 | 96142 | 96142: Tahoma | 2022-09-17 | Placer | 61 | 8 | 0 | |
127962 | 127962 | 96162 | 96162: Truckee | 2022-09-17 | Placer | 61 | 5 | 5 or fewer | 0 |
128058 | 128058 | Havasu Lake | Havasu Lake | 2022-09-17 | San Bernardino | 71 | 106 | 0 | |
128104 | 128104 | 91916 | 91916: Descanso | 2022-09-17 | San Diego | 73 | 353 | 0 | |
128105 | 128105 | 91917 | 91917: Dulzura | 2022-09-17 | San Diego | 73 | 318 | 0 | |
128106 | 128106 | 91931 | 91931: Guatay | 2022-09-17 | San Diego | 73 | 47 | 0 | |
128108 | 128108 | 91934 | 91934: Jacumba | 2022-09-17 | San Diego | 73 | 112 | 0 | |
128109 | 128109 | 91935 | 91935: Jamul | 2022-09-17 | San Diego | 73 | 2027 | 0 | |
128114 | 128114 | 91962 | 91962: Pine Valley | 2022-09-17 | San Diego | 73 | 353 | 0 | |
128115 | 128115 | 91963 | 91963: Potrero | 2022-09-17 | San Diego | 73 | 382 | 0 | |
128117 | 128117 | 91978 | 91978: Spring Valley | 2022-09-17 | San Diego | 73 | 2658 | 0 | |
128118 | 128118 | 91980 | 91980: Tecate | 2022-09-17 | San Diego | 73 | 283 | 0 | |
128119 | 128119 | 92003 | 92003: Bonsall | 2022-09-17 | San Diego | 73 | 1013 | 0 | |
128120 | 128120 | 92004 | 92004: Borrego Springs | 2022-09-17 | San Diego | 73 | 357 | 0 | |
128136 | 128136 | 92036 | 92036: Julian | 2022-09-17 | San Diego | 73 | 470 | 0 | |
128144 | 128144 | 92059 | 92059: Pala | 2022-09-17 | San Diego | 73 | 594 | 0 | |
128145 | 128145 | 92060 | 92060: Palomar Mountain | 2022-09-17 | San Diego | 73 | 101 | 0 | |
128146 | 128146 | 92061 | 92061: Pauma Valley | 2022-09-17 | San Diego | 73 | 699 | 0 | |
128149 | 128149 | 92066 | 92066: Ranchita | 2022-09-17 | San Diego | 73 | 46 | 0 | |
128150 | 128150 | 92067 | 92067: Rancho Santa Fe | 2022-09-17 | San Diego | 73 | 1753 | 0 | |
128152 | 128152 | 92070 | 92070: Santa Ysabel | 2022-09-17 | San Diego | 73 | 352 | 0 | |
128160 | 128160 | 92086 | 92086: Warner Springs | 2022-09-17 | San Diego | 73 | 163 | 0 | |
128161 | 128161 | 92091 | 92091: Rancho Santa Fe | 2022-09-17 | San Diego | 73 | 162 | 0 | |
128163 | 128163 | 92096 | 92096: San Marcos | 2022-09-17 | San Diego | 73 | 36 | 0 | |
128183 | 128183 | 92121 | 92121: San Diego | 2022-09-17 | San Diego | 73 | 1020 | 0 | |
128193 | 128193 | 92134 | 92134: San Diego | 2022-09-17 | San Diego | 73 | 125 | 0 | |
128194 | 128194 | 92135 | 92135: Coronado | 2022-09-17 | San Diego | 73 | 164 | 0 | |
128197 | 128197 | 92140 | 92140: San Diego | 2022-09-17 | San Diego | 73 | 203 | 0 | |
128198 | 128198 | 92145 | 92145: San Diego | 2022-09-17 | San Diego | 73 | 40 | 0 | |
128200 | 128200 | 92155 | 92155: Coronado | 2022-09-17 | San Diego | 73 | 92 | 0 | |
128202 | 128202 | 92182 | 92182: San Diego | 2022-09-17 | San Diego | 73 | 177 | 0 | |
128203 | 128203 | 92536 | 92536: Aguanga | 2022-09-17 | San Diego | 73 | 23 | 0 | |
128204 | 128204 | 92672 | 92672: San Clemente | 2022-09-17 | San Diego | 73 | 11 | 0 | |
128207 | 128207 | 91905 | 91905: Boulevard | 2022-09-17 | San Diego | 73 | 278 | 0 | |
128208 | 128208 | 91906 | 91906: Campo | 2022-09-17 | San Diego | 73 | 975 | 0 | |
128235 | 128235 | ASH (patients) | ASH (patients) | 2022-09-17 | San Luis Obispo | 79 | 502 | 0 | |
128239 | 128239 | CMC (Inmates) | CMC (Inmates) | 2022-09-17 | San Luis Obispo | 79 | 3426 | 0 | |
128240 | 128240 | Cal Poly (campus residents) | Cal Poly (campus residents) | 2022-09-17 | San Luis Obispo | 79 | 1006 | 0 | |
128291 | 128291 | Lompoc Federal Prison | Lompoc Federal Prison | 2022-09-17 | Santa Barbara | 83 | 1161 | 0 | |
128378 | 128378 | 93212 | Corcoran, Angiola: 93212 | 2022-09-17 | Tulare | 107 | 24 | 0 | |
128402 | 128402 | 93646 | Traver: 93646 | 2022-09-17 | Tulare | 107 | 61 | 0 | |
128404 | 128404 | 93654 | Orosi: 93654 | 2022-09-17 | Tulare | 107 | 216 | 0 | |
127677 | 127677 | Unincorporated - Harbor Gateway | Unincorporated - Harbor Gateway | 2022-09-17 | Los Angeles | 37 | 5 | 1 | |
127689 | 127689 | Unincorporated - Lakewood | Unincorporated - Lakewood | 2022-09-17 | Los Angeles | 37 | 1 | 1 | |
127674 | 127674 | Unincorporated - Franklin Canyon | Franklin Canyon | 2022-09-17 | Los Angeles | 37 | 1 | 12 | |
127749 | 127749 | Unincorporated - Whittier Narrows | Whittier Narrows | 2022-09-17 | Los Angeles | 37 | 69 | 12 | |
127388 | 127388 | 95435 | 95435 | 2022-09-17 | Lake | 33 | 69 | 14 | |
127875 | 127875 | 95724 | 95724: Norden | 2022-09-17 | Nevada | 57 | 10 | 20 | |
127357 | 127357 | 93519 | 93519: Cantil | 2022-09-17 | Kern | 29 | 3 | 28 | |
128243 | 128243 | Creston | Creston | 2022-09-17 | San Luis Obispo | 79 | 248 | 30 | |
127885 | 127885 | 95986 | 95986: Washington | 2022-09-17 | Nevada | 57 | 11 | 53 | |
127341 | 127341 | 93287 | 93287: Woody | 2022-09-17 | Kern | 29 | 29 | 74 | |
127318 | 127318 | 92259 | 92259: Ocotillo | 2022-09-17 | Imperial | 25 | 28 | 94 | |
127886 | 127886 | 96111 | 96111: Floriston | 2022-09-17 | Nevada | 57 | 16 | 94 | |
127319 | 127319 | 92266 | 92266: Palo Verde | 2022-09-17 | Imperial | 25 | 15 | 108 | |
127651 | 127651 | Unincorporated - Bradbury | Unincorporated - Bradbury | 2022-09-17 | Los Angeles | 37 | 96 | 108 | |
127666 | 127666 | Unincorporated - East Lancaster | East Lancaster | 2022-09-17 | Los Angeles | 37 | 48 | 114 | |
127369 | 127369 | 93528 | 93528: Johannesburg | 2022-09-17 | Kern | 29 | 15 | 124 | |
127371 | 127371 | 93554 | 93554: Randsburg | 2022-09-17 | Kern | 29 | 11 | 143 | |
127722 | 127722 | Unincorporated - Saugus | Saugus | 2022-09-17 | Los Angeles | 37 | 402 | 155 | |
127337 | 127337 | 93276 | 93276: Tupman | 2022-09-17 | Kern | 29 | 64 | 159 | |
127235 | 127235 | 95232, 95245 | 95232, 95245 | 2022-09-17 | Calaveras | 9 | 348 | 161 | |
127359 | 127359 | 93524 | 93524: Edwards | 2022-09-17 | Kern | 29 | 54 | 168 | |
128271 | 128271 | Loma Mar | Loma Mar | 2022-09-17 | San Mateo | 81 | 14 | 172 | |
127325 | 127325 | 93226 | 93226: Glennville | 2022-09-17 | Kern | 29 | 47 | 195 | |
127495 | 127495 | City of Vernon | Vernon | 2022-09-17 | Los Angeles | 37 | 343 | 209 | |
127214 | 127214 | 94613 | 94613: Oakland | 2022-09-17 | Alameda | 1 | 6 | 212 | |
127866 | 127866 | Northeast American Canyon Area | Northeast American Canyon Area | 2022-09-17 | Napa | 55 | 30 | 212 | |
128277 | 128277 | Pescadero | Pescadero | 2022-09-17 | San Mateo | 81 | 44 | 219 | |
127698 | 127698 | Unincorporated - Newhall | Newhall | 2022-09-17 | Los Angeles | 37 | 100 | 220 | |
127876 | 127876 | 95728 | 95728: Soda Springs | 2022-09-17 | Nevada | 57 | 77 | 229 | |
127398 | 127398 | 95493 | 95493 | 2022-09-17 | Lake | 33 | 19 | 241 | |
127332 | 127332 | 93251 | 93251: Mc Kittrick | 2022-09-17 | Kern | 29 | 68 | 243 | |
127720 | 127720 | Unincorporated - Santa Catalina Island | Santa Catalina Island | 2022-09-17 | Los Angeles | 37 | 753 | 267 | |
127389 | 127389 | 95443 | 95443 | 2022-09-17 | Lake | 33 | 24 | 270 | |
128365 | 128365 | 95450 | 95450: Jenner | 2022-09-17 | Sonoma | 97 | 28 | 298 | |
127719 | 127719 | Unincorporated - Sand Canyon | Sand Canyon | 2022-09-17 | Los Angeles | 37 | 57 | 308 |
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 );