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-07 sorted by rowid descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▲ | id | name | date | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
914383 | 914383 | Wheatland | Wheatland | 2021-01-07 | Yuba | 115 | 244 | 3747 | |
914382 | 914382 | Plumas Lake | Plumas Lake | 2021-01-07 | Yuba | 115 | 415 | 7367 | |
914381 | 914381 | Other | Other | 2021-01-07 | Yuba | 115 | 239 | ||
914380 | 914380 | Olivehurst Linda | Olivehurst Linda | 2021-01-07 | Yuba | 115 | 1178 | 32623 | |
914379 | 914379 | Marysville | Marysville | 2021-01-07 | Yuba | 115 | 1822 | 12282 | |
914378 | 914378 | Woodland | Woodland | 2021-01-07 | Yolo | 113 | 3752 | 59044 | |
914377 | 914377 | Winters | Winters | 2021-01-07 | Yolo | 113 | 405 | 7132 | |
914376 | 914376 | West Sacramento | West Sacramento | 2021-01-07 | Yolo | 113 | 2614 | 52826 | |
914375 | 914375 | Unincorporated | Other | 2021-01-07 | Yolo | 113 | 904 | ||
914374 | 914374 | Davis | Davis | 2021-01-07 | Yolo | 113 | 1295 | 67988 | |
914373 | 914373 | 93066 | 93066: Somis | 2021-01-07 | Ventura | 111 | 151 | 3481 | |
914372 | 914372 | 93065 | 93065: Simi Valley | 2021-01-07 | Ventura | 111 | 3898 | 74780 | |
914371 | 914371 | 93063 | 93063: Simi Valley (Santa Susana) | 2021-01-07 | Ventura | 111 | 2770 | 56563 | |
914370 | 914370 | 93060 | 93060: Santa Paula | 2021-01-07 | Ventura | 111 | 3135 | 34229 | |
914369 | 914369 | 93041 | 93041: Port Hueneme | 2021-01-07 | Ventura | 111 | 1384 | 24129 | |
914368 | 914368 | 93040 | 93040: Piru | 2021-01-07 | Ventura | 111 | 222 | 1831 | |
914367 | 914367 | 93036 | 93036: Oxnard | 2021-01-07 | Ventura | 111 | 3489 | 48022 | |
914366 | 914366 | 93035 | 93035: Oxnard | 2021-01-07 | Ventura | 111 | 1408 | 28321 | |
914365 | 914365 | 93033 | 93033: Oxnard | 2021-01-07 | Ventura | 111 | 7811 | 83319 | |
914364 | 914364 | 93030 | 93030: Oxnard | 2021-01-07 | Ventura | 111 | 5854 | 62016 | |
914363 | 914363 | 93023 | 93023: Ojai | 2021-01-07 | Ventura | 111 | 546 | 20656 | |
914362 | 914362 | 93022 | 93022: Oak View | 2021-01-07 | Ventura | 111 | 183 | 5550 | |
914361 | 914361 | 93021 | 93021: Moorpark | 2021-01-07 | Ventura | 111 | 1657 | 38325 | |
914360 | 914360 | 93015 | 93015: Fillmore | 2021-01-07 | Ventura | 111 | 1546 | 18832 | |
914359 | 914359 | 93012 | 93012: Camarillo/Santa Rosa Valley | 2021-01-07 | Ventura | 111 | 982 | 37622 | |
914358 | 914358 | 93010 | 93010: Camarillo | 2021-01-07 | Ventura | 111 | 1791 | 44240 | |
914357 | 914357 | 93004 | 93004: Ventura | 2021-01-07 | Ventura | 111 | 1265 | 30473 | |
914356 | 914356 | 93003 | 93003: Ventura | 2021-01-07 | Ventura | 111 | 2363 | 51304 | |
914355 | 914355 | 93001 | 93001: Ventura | 2021-01-07 | Ventura | 111 | 1508 | 33139 | |
914354 | 914354 | 91377 | 91377: Oak Park | 2021-01-07 | Ventura | 111 | 240 | 14226 | |
914353 | 914353 | 91362 | 91362: Thousand Oaks/Westlake | 2021-01-07 | Ventura | 111 | 1014 | 36980 | |
914352 | 914352 | 91361 | 91361: Thousand Oaks/Lake Sherwood/Westlake | 2021-01-07 | Ventura | 111 | 394 | 20487 | |
914351 | 914351 | 91360 | 91360: Thousand Oaks | 2021-01-07 | Ventura | 111 | 1581 | 42104 | |
914350 | 914350 | 91320 | 91320: Thousand Oaks/Newbury Park | 2021-01-07 | Ventura | 111 | 1745 | 46191 | |
914349 | 914349 | 91307 | 91307: Bell Canyon | 2021-01-07 | Ventura | 111 | 7 | 2391 | |
914348 | 914348 | 93654 | Orosi: 93654 | 2021-01-07 | Tulare | 107 | 23 | 0 | |
914347 | 914347 | 93647 | Orosi: 93647 | 2021-01-07 | Tulare | 107 | 1054 | 10896 | |
914346 | 914346 | 93646 | Traver: 93646 | 2021-01-07 | Tulare | 107 | 13 | 0 | |
914345 | 914345 | 93631 | Traver: 93631 | 2021-01-07 | Tulare | 107 | 180 | 16349 | |
914344 | 914344 | 93618 | Dinuba: 93618 | 2021-01-07 | Tulare | 107 | 3241 | 31230 | |
914343 | 914343 | 93615 | Cutler: 93615 | 2021-01-07 | Tulare | 107 | 570 | 6513 | |
914342 | 914342 | 93292 | Visalia: 93292 | 2021-01-07 | Tulare | 107 | 2600 | 41031 | |
914341 | 914341 | 93291 | Visalia: 93291 | 2021-01-07 | Tulare | 107 | 4027 | 57968 | |
914340 | 914340 | 93286 | Woodlake: 93286 | 2021-01-07 | Tulare | 107 | 630 | 9755 | |
914339 | 914339 | 93277 | Visalia: 93277 | 2021-01-07 | Tulare | 107 | 3161 | 53015 | |
914338 | 914338 | 93274 | Tulare: 93274 | 2021-01-07 | Tulare | 107 | 6434 | 73778 | |
914337 | 914337 | 93272 | Tipton: 93272 | 2021-01-07 | Tulare | 107 | 255 | 4454 | |
914336 | 914336 | 93271 | Three Rivers: 93271 | 2021-01-07 | Tulare | 107 | 38 | 2432 | |
914335 | 914335 | 93270 | Terra Bella: 93270 | 2021-01-07 | Tulare | 107 | 494 | 5542 | |
914334 | 914334 | 93267 | Strathmore: 93267 | 2021-01-07 | Tulare | 107 | 477 | 5542 | |
914333 | 914333 | 93265 | Springville: 93265 | 2021-01-07 | Tulare | 107 | 83 | 6347 | |
914332 | 914332 | 93262 | Mountain: 93262 | 2021-01-07 | Tulare | 107 | 34 | 3271 | |
914331 | 914331 | 93257 | Porterville: 93257 | 2021-01-07 | Tulare | 107 | 7038 | 76923 | |
914330 | 914330 | 93256 | Pixley: 93256 | 2021-01-07 | Tulare | 107 | 596 | 5939 | |
914329 | 914329 | 93247 | Lindsay: 93247 | 2021-01-07 | Tulare | 107 | 1353 | 18522 | |
914328 | 914328 | 93235 | Ivanhoe: 93235 | 2021-01-07 | Tulare | 107 | 384 | 4198 | |
914327 | 914327 | 93227 | Goshen: 93227 | 2021-01-07 | Tulare | 107 | 52 | 3425 | |
914326 | 914326 | 93223 | Farmersville: 93223 | 2021-01-07 | Tulare | 107 | 895 | 10742 | |
914325 | 914325 | 93221 | Exeter: 93221 | 2021-01-07 | Tulare | 107 | 799 | 14328 | |
914324 | 914324 | 93219 | Earlimart: 93219 | 2021-01-07 | Tulare | 107 | 1126 | 10167 | |
914323 | 914323 | 93215 | Richgrove: 93215 | 2021-01-07 | Tulare | 107 | 225 | 55269 | |
914322 | 914322 | 93212 | Corcoran, Angiola: 93212 | 2021-01-07 | Tulare | 107 | 9 | 0 | |
914321 | 914321 | 93201 | Alpaugh: 93201 | 2021-01-07 | Tulare | 107 | 60 | 1431 | |
914320 | 914320 | West County | West County | 2021-01-07 | Trinity | 105 | 22 | 2254 | |
914319 | 914319 | South County | South County | 2021-01-07 | Trinity | 105 | 60 | 4010 | |
914318 | 914318 | North County | North County | 2021-01-07 | Trinity | 105 | 4 | 699 | |
914317 | 914317 | East County | East County | 2021-01-07 | Trinity | 105 | 199 | 6738 | |
914316 | 914316 | Yuba City | Yuba City | 2021-01-07 | Sutter | 101 | 5414 | 66388 | |
914315 | 914315 | Other | Other | 2021-01-07 | Sutter | 101 | 364 | ||
914314 | 914314 | Live Oak | Live Oak | 2021-01-07 | Sutter | 101 | 727 | 8622 | |
914313 | 914313 | Waterford | Waterford | 2021-01-07 | Stanislaus | 99 | 441 | 8823 | |
914312 | 914312 | Unincorporated districts | Other | 2021-01-07 | Stanislaus | 99 | 6340 | ||
914311 | 914311 | Turlock | Turlock | 2021-01-07 | Stanislaus | 99 | 5039 | 72335 | |
914310 | 914310 | Riverbank | Riverbank | 2021-01-07 | Stanislaus | 99 | 1645 | 24237 | |
914309 | 914309 | Patterson | Patterson | 2021-01-07 | Stanislaus | 99 | 1797 | 21783 | |
914308 | 914308 | Oakdale | Oakdale | 2021-01-07 | Stanislaus | 99 | 1140 | 22599 | |
914307 | 914307 | Newman | Newman | 2021-01-07 | Stanislaus | 99 | 810 | 11119 | |
914306 | 914306 | Modesto | Modesto | 2021-01-07 | Stanislaus | 99 | 13337 | 211336 | |
914305 | 914305 | Hughson | Hughson | 2021-01-07 | Stanislaus | 99 | 373 | 7370 | |
914304 | 914304 | Ceres | Ceres | 2021-01-07 | Stanislaus | 99 | 3956 | 47975 | |
914303 | 914303 | 95497 | 95497: The Sea Ranch | 2021-01-07 | Sonoma | 97 | 10 | 10 or fewer | 1161 |
914302 | 914302 | 95492 | 95492: Windsor | 2021-01-07 | Sonoma | 97 | 1102 | 29920 | |
914301 | 914301 | 95476 | 95476: Sonoma | 2021-01-07 | Sonoma | 97 | 1498 | 36792 | |
914300 | 914300 | 95472 | 95472: Sebastopol | 2021-01-07 | Sonoma | 97 | 389 | 30762 | |
914299 | 914299 | 95465 | 95465: Occidental | 2021-01-07 | Sonoma | 97 | 10 | 10 or fewer | 2104 |
914298 | 914298 | 95462 | 95462: Monte Rio | 2021-01-07 | Sonoma | 97 | 17 | 1265 | |
914297 | 914297 | 95452 | 95452: Kenwood | 2021-01-07 | Sonoma | 97 | 15 | 970 | |
914296 | 914296 | 95450 | 95450: Jenner | 2021-01-07 | Sonoma | 97 | 10 | 10 or fewer | 298 |
914295 | 914295 | 95448 | 95448: Healdsburg | 2021-01-07 | Sonoma | 97 | 654 | 17482 | |
914294 | 914294 | 95446 | 95446: Guerneville | 2021-01-07 | Sonoma | 97 | 92 | 5100 | |
914293 | 914293 | 95444 | 95444: Graton | 2021-01-07 | Sonoma | 97 | 20 | 715 | |
914292 | 914292 | 95442 | 95442: Glen Ellen | 2021-01-07 | Sonoma | 97 | 103 | 3136 | |
914291 | 914291 | 95441 | 95441: Geyserville | 2021-01-07 | Sonoma | 97 | 61 | 2053 | |
914290 | 914290 | 95439 | 95439: Fulton | 2021-01-07 | Sonoma | 97 | 35 | 774 | |
914289 | 914289 | 95436 | 95436: Forestville | 2021-01-07 | Sonoma | 97 | 107 | 6352 | |
914288 | 914288 | 95425 | 95425: Cloverdale | 2021-01-07 | Sonoma | 97 | 514 | 10586 | |
914287 | 914287 | 95421 | 95421: Cazadero | 2021-01-07 | Sonoma | 97 | 12 | 1681 | |
914286 | 914286 | 95412 | 95412: Annapolis | 2021-01-07 | Sonoma | 97 | 0 | 402 | |
914285 | 914285 | 95409 | 95409: Santa Rosa | 2021-01-07 | Sonoma | 97 | 632 | 27312 | |
914284 | 914284 | 95407 | 95407: Santa Rosa | 2021-01-07 | Sonoma | 97 | 3345 | 42483 |
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 );