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-21 sorted by rowid descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▲ | id | name | date | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
896519 | 896519 | Wheatland | Wheatland | 2021-01-21 | Yuba | 115 | 278 | 3747 | |
896518 | 896518 | Plumas Lake | Plumas Lake | 2021-01-21 | Yuba | 115 | 515 | 7367 | |
896517 | 896517 | Other | Other | 2021-01-21 | Yuba | 115 | 288 | ||
896516 | 896516 | Olivehurst Linda | Olivehurst Linda | 2021-01-21 | Yuba | 115 | 1409 | 32623 | |
896515 | 896515 | Marysville | Marysville | 2021-01-21 | Yuba | 115 | 2328 | 12282 | |
896514 | 896514 | Woodland | Woodland | 2021-01-21 | Yolo | 113 | 4510 | 59044 | |
896513 | 896513 | Winters | Winters | 2021-01-21 | Yolo | 113 | 481 | 7132 | |
896512 | 896512 | West Sacramento | West Sacramento | 2021-01-21 | Yolo | 113 | 3056 | 52826 | |
896511 | 896511 | Unincorporated | Other | 2021-01-21 | Yolo | 113 | 1128 | ||
896510 | 896510 | Davis | Davis | 2021-01-21 | Yolo | 113 | 1597 | 67988 | |
896509 | 896509 | 93066 | 93066: Somis | 2021-01-21 | Ventura | 111 | 195 | 3481 | |
896508 | 896508 | 93065 | 93065: Simi Valley | 2021-01-21 | Ventura | 111 | 5088 | 74780 | |
896507 | 896507 | 93063 | 93063: Simi Valley (Santa Susana) | 2021-01-21 | Ventura | 111 | 3561 | 56563 | |
896506 | 896506 | 93060 | 93060: Santa Paula | 2021-01-21 | Ventura | 111 | 4287 | 34229 | |
896505 | 896505 | 93041 | 93041: Port Hueneme | 2021-01-21 | Ventura | 111 | 1875 | 24129 | |
896504 | 896504 | 93040 | 93040: Piru | 2021-01-21 | Ventura | 111 | 280 | 1831 | |
896503 | 896503 | 93036 | 93036: Oxnard | 2021-01-21 | Ventura | 111 | 4951 | 48022 | |
896502 | 896502 | 93035 | 93035: Oxnard | 2021-01-21 | Ventura | 111 | 1860 | 28321 | |
896501 | 896501 | 93033 | 93033: Oxnard | 2021-01-21 | Ventura | 111 | 11034 | 83319 | |
896500 | 896500 | 93030 | 93030: Oxnard | 2021-01-21 | Ventura | 111 | 7852 | 62016 | |
896499 | 896499 | 93023 | 93023: Ojai | 2021-01-21 | Ventura | 111 | 800 | 20656 | |
896498 | 896498 | 93022 | 93022: Oak View | 2021-01-21 | Ventura | 111 | 276 | 5550 | |
896497 | 896497 | 93021 | 93021: Moorpark | 2021-01-21 | Ventura | 111 | 2195 | 38325 | |
896496 | 896496 | 93015 | 93015: Fillmore | 2021-01-21 | Ventura | 111 | 2087 | 18832 | |
896495 | 896495 | 93012 | 93012: Camarillo/Santa Rosa Valley | 2021-01-21 | Ventura | 111 | 1366 | 37622 | |
896494 | 896494 | 93010 | 93010: Camarillo | 2021-01-21 | Ventura | 111 | 2450 | 44240 | |
896493 | 896493 | 93004 | 93004: Ventura | 2021-01-21 | Ventura | 111 | 1794 | 30473 | |
896492 | 896492 | 93003 | 93003: Ventura | 2021-01-21 | Ventura | 111 | 3193 | 51304 | |
896491 | 896491 | 93001 | 93001: Ventura | 2021-01-21 | Ventura | 111 | 2191 | 33139 | |
896490 | 896490 | 91377 | 91377: Oak Park | 2021-01-21 | Ventura | 111 | 323 | 14226 | |
896489 | 896489 | 91362 | 91362: Thousand Oaks/Westlake | 2021-01-21 | Ventura | 111 | 1297 | 36980 | |
896488 | 896488 | 91361 | 91361: Thousand Oaks/Lake Sherwood/Westlake | 2021-01-21 | Ventura | 111 | 483 | 20487 | |
896487 | 896487 | 91360 | 91360: Thousand Oaks | 2021-01-21 | Ventura | 111 | 2046 | 42104 | |
896486 | 896486 | 91320 | 91320: Thousand Oaks/Newbury Park | 2021-01-21 | Ventura | 111 | 2117 | 46191 | |
896485 | 896485 | 91307 | 91307: Bell Canyon | 2021-01-21 | Ventura | 111 | 7 | 2391 | |
896484 | 896484 | 93654 | Orosi: 93654 | 2021-01-21 | Tulare | 107 | 49 | 0 | |
896483 | 896483 | 93647 | Orosi: 93647 | 2021-01-21 | Tulare | 107 | 1261 | 10896 | |
896482 | 896482 | 93646 | Traver: 93646 | 2021-01-21 | Tulare | 107 | 17 | 0 | |
896481 | 896481 | 93631 | Traver: 93631 | 2021-01-21 | Tulare | 107 | 213 | 16349 | |
896480 | 896480 | 93618 | Dinuba: 93618 | 2021-01-21 | Tulare | 107 | 3717 | 31230 | |
896479 | 896479 | 93615 | Cutler: 93615 | 2021-01-21 | Tulare | 107 | 668 | 6513 | |
896478 | 896478 | 93292 | Visalia: 93292 | 2021-01-21 | Tulare | 107 | 3066 | 41031 | |
896477 | 896477 | 93291 | Visalia: 93291 | 2021-01-21 | Tulare | 107 | 4691 | 57968 | |
896476 | 896476 | 93286 | Woodlake: 93286 | 2021-01-21 | Tulare | 107 | 789 | 9755 | |
896475 | 896475 | 93277 | Visalia: 93277 | 2021-01-21 | Tulare | 107 | 3689 | 53015 | |
896474 | 896474 | 93274 | Tulare: 93274 | 2021-01-21 | Tulare | 107 | 7510 | 73778 | |
896473 | 896473 | 93272 | Tipton: 93272 | 2021-01-21 | Tulare | 107 | 307 | 4454 | |
896472 | 896472 | 93271 | Three Rivers: 93271 | 2021-01-21 | Tulare | 107 | 44 | 2432 | |
896471 | 896471 | 93270 | Terra Bella: 93270 | 2021-01-21 | Tulare | 107 | 600 | 5542 | |
896470 | 896470 | 93267 | Strathmore: 93267 | 2021-01-21 | Tulare | 107 | 554 | 5542 | |
896469 | 896469 | 93265 | Springville: 93265 | 2021-01-21 | Tulare | 107 | 110 | 6347 | |
896468 | 896468 | 93262 | Mountain: 93262 | 2021-01-21 | Tulare | 107 | 35 | 3271 | |
896467 | 896467 | 93257 | Porterville: 93257 | 2021-01-21 | Tulare | 107 | 8405 | 76923 | |
896466 | 896466 | 93256 | Pixley: 93256 | 2021-01-21 | Tulare | 107 | 694 | 5939 | |
896465 | 896465 | 93247 | Lindsay: 93247 | 2021-01-21 | Tulare | 107 | 1599 | 18522 | |
896464 | 896464 | 93235 | Ivanhoe: 93235 | 2021-01-21 | Tulare | 107 | 446 | 4198 | |
896463 | 896463 | 93227 | Goshen: 93227 | 2021-01-21 | Tulare | 107 | 85 | 3425 | |
896462 | 896462 | 93223 | Farmersville: 93223 | 2021-01-21 | Tulare | 107 | 1053 | 10742 | |
896461 | 896461 | 93221 | Exeter: 93221 | 2021-01-21 | Tulare | 107 | 908 | 14328 | |
896460 | 896460 | 93219 | Earlimart: 93219 | 2021-01-21 | Tulare | 107 | 1269 | 10167 | |
896459 | 896459 | 93215 | Richgrove: 93215 | 2021-01-21 | Tulare | 107 | 287 | 55269 | |
896458 | 896458 | 93212 | Corcoran, Angiola: 93212 | 2021-01-21 | Tulare | 107 | 10 | 0 | |
896457 | 896457 | 93201 | Alpaugh: 93201 | 2021-01-21 | Tulare | 107 | 67 | 1431 | |
896456 | 896456 | West County | West County | 2021-01-21 | Trinity | 105 | 25 | 2254 | |
896455 | 896455 | South County | South County | 2021-01-21 | Trinity | 105 | 66 | 4010 | |
896454 | 896454 | North County | North County | 2021-01-21 | Trinity | 105 | 5 | 699 | |
896453 | 896453 | East County | East County | 2021-01-21 | Trinity | 105 | 209 | 6738 | |
896452 | 896452 | Yuba City | Yuba City | 2021-01-21 | Sutter | 101 | 6179 | 66388 | |
896451 | 896451 | Other | Other | 2021-01-21 | Sutter | 101 | 426 | ||
896450 | 896450 | Live Oak | Live Oak | 2021-01-21 | Sutter | 101 | 879 | 8622 | |
896449 | 896449 | Waterford | Waterford | 2021-01-21 | Stanislaus | 99 | 504 | 8823 | |
896448 | 896448 | Unincorporated districts | Other | 2021-01-21 | Stanislaus | 99 | 7431 | ||
896447 | 896447 | Turlock | Turlock | 2021-01-21 | Stanislaus | 99 | 5795 | 72335 | |
896446 | 896446 | Riverbank | Riverbank | 2021-01-21 | Stanislaus | 99 | 1951 | 24237 | |
896445 | 896445 | Patterson | Patterson | 2021-01-21 | Stanislaus | 99 | 2164 | 21783 | |
896444 | 896444 | Oakdale | Oakdale | 2021-01-21 | Stanislaus | 99 | 1357 | 22599 | |
896443 | 896443 | Newman | Newman | 2021-01-21 | Stanislaus | 99 | 991 | 11119 | |
896442 | 896442 | Modesto | Modesto | 2021-01-21 | Stanislaus | 99 | 15813 | 211336 | |
896441 | 896441 | Hughson | Hughson | 2021-01-21 | Stanislaus | 99 | 451 | 7370 | |
896440 | 896440 | Ceres | Ceres | 2021-01-21 | Stanislaus | 99 | 4523 | 47975 | |
896439 | 896439 | 95497 | 95497: The Sea Ranch | 2021-01-21 | Sonoma | 97 | 10 | 10 or fewer | 1161 |
896438 | 896438 | 95492 | 95492: Windsor | 2021-01-21 | Sonoma | 97 | 1320 | 29920 | |
896437 | 896437 | 95476 | 95476: Sonoma | 2021-01-21 | Sonoma | 97 | 1848 | 36792 | |
896436 | 896436 | 95472 | 95472: Sebastopol | 2021-01-21 | Sonoma | 97 | 510 | 30762 | |
896435 | 896435 | 95465 | 95465: Occidental | 2021-01-21 | Sonoma | 97 | 16 | 2104 | |
896434 | 896434 | 95462 | 95462: Monte Rio | 2021-01-21 | Sonoma | 97 | 18 | 1265 | |
896433 | 896433 | 95452 | 95452: Kenwood | 2021-01-21 | Sonoma | 97 | 18 | 970 | |
896432 | 896432 | 95450 | 95450: Jenner | 2021-01-21 | Sonoma | 97 | 10 | 10 or fewer | 298 |
896431 | 896431 | 95448 | 95448: Healdsburg | 2021-01-21 | Sonoma | 97 | 773 | 17482 | |
896430 | 896430 | 95446 | 95446: Guerneville | 2021-01-21 | Sonoma | 97 | 111 | 5100 | |
896429 | 896429 | 95444 | 95444: Graton | 2021-01-21 | Sonoma | 97 | 23 | 715 | |
896428 | 896428 | 95442 | 95442: Glen Ellen | 2021-01-21 | Sonoma | 97 | 116 | 3136 | |
896427 | 896427 | 95441 | 95441: Geyserville | 2021-01-21 | Sonoma | 97 | 77 | 2053 | |
896426 | 896426 | 95439 | 95439: Fulton | 2021-01-21 | Sonoma | 97 | 41 | 774 | |
896425 | 896425 | 95436 | 95436: Forestville | 2021-01-21 | Sonoma | 97 | 126 | 6352 | |
896424 | 896424 | 95425 | 95425: Cloverdale | 2021-01-21 | Sonoma | 97 | 609 | 10586 | |
896423 | 896423 | 95421 | 95421: Cazadero | 2021-01-21 | Sonoma | 97 | 16 | 1681 | |
896422 | 896422 | 95412 | 95412: Annapolis | 2021-01-21 | Sonoma | 97 | 10 | 10 or fewer | 402 |
896421 | 896421 | 95409 | 95409: Santa Rosa | 2021-01-21 | Sonoma | 97 | 735 | 27312 | |
896420 | 896420 | 95407 | 95407: Santa Rosa | 2021-01-21 | Sonoma | 97 | 3962 | 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 );