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,277 rows where "date" is on date 2022-02-22 sorted by rowid descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▲ | id | name | date | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
390610 | 390610 | Wheatland | Wheatland | 2022-02-22 | Yuba | 115 | 960 | 3747 | |
390609 | 390609 | Plumas Lake | Plumas Lake | 2022-02-22 | Yuba | 115 | 2115 | 7367 | |
390608 | 390608 | Other | Other | 2022-02-22 | Yuba | 115 | 1660 | ||
390607 | 390607 | Olivehurst Linda | Olivehurst Linda | 2022-02-22 | Yuba | 115 | 4695 | 32623 | |
390606 | 390606 | Marysville | Marysville | 2022-02-22 | Yuba | 115 | 7744 | 12282 | |
390605 | 390605 | Woodland | Woodland | 2022-02-22 | Yolo | 113 | 11538 | 59044 | |
390604 | 390604 | Winters | Winters | 2022-02-22 | Yolo | 113 | 1172 | 7132 | |
390603 | 390603 | West Sacramento | West Sacramento | 2022-02-22 | Yolo | 113 | 10089 | 52826 | |
390602 | 390602 | Unincorporated | Other | 2022-02-22 | Yolo | 113 | 4395 | ||
390601 | 390601 | Davis | Davis | 2022-02-22 | Yolo | 113 | 7788 | 67988 | |
390600 | 390600 | 93066 | 93066: Somis | 2022-02-22 | Ventura | 111 | 521 | 3481 | |
390599 | 390599 | 93065 | 93065: Simi Valley | 2022-02-22 | Ventura | 111 | 13979 | 74780 | |
390598 | 390598 | 93063 | 93063: Simi Valley (Santa Susana) | 2022-02-22 | Ventura | 111 | 9933 | 56563 | |
390597 | 390597 | 93060 | 93060: Santa Paula | 2022-02-22 | Ventura | 111 | 10072 | 34229 | |
390596 | 390596 | 93041 | 93041: Port Hueneme | 2022-02-22 | Ventura | 111 | 5037 | 24129 | |
390595 | 390595 | 93040 | 93040: Piru | 2022-02-22 | Ventura | 111 | 711 | 1831 | |
390594 | 390594 | 93036 | 93036: Oxnard | 2022-02-22 | Ventura | 111 | 11977 | 48022 | |
390593 | 390593 | 93035 | 93035: Oxnard | 2022-02-22 | Ventura | 111 | 5398 | 28321 | |
390592 | 390592 | 93033 | 93033: Oxnard | 2022-02-22 | Ventura | 111 | 23250 | 83319 | |
390591 | 390591 | 93030 | 93030: Oxnard | 2022-02-22 | Ventura | 111 | 16977 | 62016 | |
390590 | 390590 | 93023 | 93023: Ojai | 2022-02-22 | Ventura | 111 | 2515 | 20656 | |
390589 | 390589 | 93022 | 93022: Oak View | 2022-02-22 | Ventura | 111 | 971 | 5550 | |
390588 | 390588 | 93021 | 93021: Moorpark | 2022-02-22 | Ventura | 111 | 6569 | 38325 | |
390587 | 390587 | 93015 | 93015: Fillmore | 2022-02-22 | Ventura | 111 | 5750 | 18832 | |
390586 | 390586 | 93012 | 93012: Camarillo/Santa Rosa Valley | 2022-02-22 | Ventura | 111 | 4744 | 37622 | |
390585 | 390585 | 93010 | 93010: Camarillo | 2022-02-22 | Ventura | 111 | 7826 | 44240 | |
390584 | 390584 | 93004 | 93004: Ventura | 2022-02-22 | Ventura | 111 | 5370 | 30473 | |
390583 | 390583 | 93003 | 93003: Ventura | 2022-02-22 | Ventura | 111 | 9431 | 51304 | |
390582 | 390582 | 93001 | 93001: Ventura | 2022-02-22 | Ventura | 111 | 6361 | 33139 | |
390581 | 390581 | 91377 | 91377: Oak Park | 2022-02-22 | Ventura | 111 | 1651 | 14226 | |
390580 | 390580 | 91362 | 91362: Thousand Oaks/Westlake | 2022-02-22 | Ventura | 111 | 4883 | 36980 | |
390579 | 390579 | 91361 | 91361: Thousand Oaks/Lake Sherwood/Westlake | 2022-02-22 | Ventura | 111 | 1697 | 20487 | |
390578 | 390578 | 91360 | 91360: Thousand Oaks | 2022-02-22 | Ventura | 111 | 6872 | 42104 | |
390577 | 390577 | 91320 | 91320: Thousand Oaks/Newbury Park | 2022-02-22 | Ventura | 111 | 6994 | 46191 | |
390576 | 390576 | 91307 | 91307: Bell Canyon | 2022-02-22 | Ventura | 111 | 37 | 2391 | |
390575 | 390575 | 93654 | Orosi: 93654 | 2022-02-22 | Tulare | 107 | 200 | 0 | |
390574 | 390574 | 93647 | Orosi: 93647 | 2022-02-22 | Tulare | 107 | 2689 | 10896 | |
390573 | 390573 | 93646 | Traver: 93646 | 2022-02-22 | Tulare | 107 | 57 | 0 | |
390572 | 390572 | 93631 | Traver: 93631 | 2022-02-22 | Tulare | 107 | 510 | 16349 | |
390571 | 390571 | 93618 | Dinuba: 93618 | 2022-02-22 | Tulare | 107 | 7888 | 31230 | |
390570 | 390570 | 93615 | Cutler: 93615 | 2022-02-22 | Tulare | 107 | 1370 | 6513 | |
390569 | 390569 | 93292 | Visalia: 93292 | 2022-02-22 | Tulare | 107 | 7268 | 41031 | |
390568 | 390568 | 93291 | Visalia: 93291 | 2022-02-22 | Tulare | 107 | 11406 | 57968 | |
390567 | 390567 | 93286 | Woodlake: 93286 | 2022-02-22 | Tulare | 107 | 1867 | 9755 | |
390566 | 390566 | 93277 | Visalia: 93277 | 2022-02-22 | Tulare | 107 | 9014 | 53015 | |
390565 | 390565 | 93274 | Tulare: 93274 | 2022-02-22 | Tulare | 107 | 16777 | 73778 | |
390564 | 390564 | 93272 | Tipton: 93272 | 2022-02-22 | Tulare | 107 | 835 | 4454 | |
390563 | 390563 | 93271 | Three Rivers: 93271 | 2022-02-22 | Tulare | 107 | 146 | 2432 | |
390562 | 390562 | 93270 | Terra Bella: 93270 | 2022-02-22 | Tulare | 107 | 1428 | 5542 | |
390561 | 390561 | 93267 | Strathmore: 93267 | 2022-02-22 | Tulare | 107 | 1352 | 5542 | |
390560 | 390560 | 93265 | Springville: 93265 | 2022-02-22 | Tulare | 107 | 480 | 6347 | |
390559 | 390559 | 93262 | Mountain: 93262 | 2022-02-22 | Tulare | 107 | 95 | 3271 | |
390558 | 390558 | 93257 | Porterville: 93257 | 2022-02-22 | Tulare | 107 | 20408 | 76923 | |
390557 | 390557 | 93256 | Pixley: 93256 | 2022-02-22 | Tulare | 107 | 1590 | 5939 | |
390556 | 390556 | 93247 | Lindsay: 93247 | 2022-02-22 | Tulare | 107 | 3747 | 18522 | |
390555 | 390555 | 93235 | Ivanhoe: 93235 | 2022-02-22 | Tulare | 107 | 1035 | 4198 | |
390554 | 390554 | 93227 | Goshen: 93227 | 2022-02-22 | Tulare | 107 | 173 | 3425 | |
390553 | 390553 | 93223 | Farmersville: 93223 | 2022-02-22 | Tulare | 107 | 2292 | 10742 | |
390552 | 390552 | 93221 | Exeter: 93221 | 2022-02-22 | Tulare | 107 | 2134 | 14328 | |
390551 | 390551 | 93219 | Earlimart: 93219 | 2022-02-22 | Tulare | 107 | 2488 | 10167 | |
390550 | 390550 | 93215 | Richgrove: 93215 | 2022-02-22 | Tulare | 107 | 671 | 55269 | |
390549 | 390549 | 93212 | Corcoran, Angiola: 93212 | 2022-02-22 | Tulare | 107 | 25 | 0 | |
390548 | 390548 | 93201 | Alpaugh: 93201 | 2022-02-22 | Tulare | 107 | 244 | 1431 | |
390547 | 390547 | West County | West County | 2022-02-22 | Trinity | 105 | 108 | 2254 | |
390546 | 390546 | South County | South County | 2022-02-22 | Trinity | 105 | 241 | 4010 | |
390545 | 390545 | North County | North County | 2022-02-22 | Trinity | 105 | 42 | 699 | |
390544 | 390544 | East County | East County | 2022-02-22 | Trinity | 105 | 687 | 6738 | |
390543 | 390543 | Yuba City | Yuba City | 2022-02-22 | Sutter | 101 | 18137 | 66388 | |
390542 | 390542 | Other | Other | 2022-02-22 | Sutter | 101 | 1292 | ||
390541 | 390541 | Live Oak | Live Oak | 2022-02-22 | Sutter | 101 | 2410 | 8622 | |
390540 | 390540 | Waterford | Waterford | 2022-02-22 | Stanislaus | 99 | 1604 | 8823 | |
390539 | 390539 | Unincorporated districts | Other | 2022-02-22 | Stanislaus | 99 | 19474 | ||
390538 | 390538 | Turlock | Turlock | 2022-02-22 | Stanislaus | 99 | 15162 | 72335 | |
390537 | 390537 | Riverbank | Riverbank | 2022-02-22 | Stanislaus | 99 | 5381 | 24237 | |
390536 | 390536 | Patterson | Patterson | 2022-02-22 | Stanislaus | 99 | 4749 | 21783 | |
390535 | 390535 | Oakdale | Oakdale | 2022-02-22 | Stanislaus | 99 | 4077 | 22599 | |
390534 | 390534 | Newman | Newman | 2022-02-22 | Stanislaus | 99 | 2159 | 11119 | |
390533 | 390533 | Modesto | Modesto | 2022-02-22 | Stanislaus | 99 | 44389 | 211336 | |
390532 | 390532 | Hughson | Hughson | 2022-02-22 | Stanislaus | 99 | 1239 | 7370 | |
390531 | 390531 | Ceres | Ceres | 2022-02-22 | Stanislaus | 99 | 11409 | 47975 | |
390530 | 390530 | 95497 | 95497: The Sea Ranch | 2022-02-22 | Sonoma | 97 | 30 | 1161 | |
390529 | 390529 | 95492 | 95492: Windsor | 2022-02-22 | Sonoma | 97 | 5019 | 29920 | |
390528 | 390528 | 95476 | 95476: Sonoma | 2022-02-22 | Sonoma | 97 | 5884 | 36792 | |
390527 | 390527 | 95472 | 95472: Sebastopol | 2022-02-22 | Sonoma | 97 | 2639 | 30762 | |
390526 | 390526 | 95465 | 95465: Occidental | 2022-02-22 | Sonoma | 97 | 126 | 2104 | |
390525 | 390525 | 95462 | 95462: Monte Rio | 2022-02-22 | Sonoma | 97 | 109 | 1265 | |
390524 | 390524 | 95452 | 95452: Kenwood | 2022-02-22 | Sonoma | 97 | 87 | 970 | |
390523 | 390523 | 95450 | 95450: Jenner | 2022-02-22 | Sonoma | 97 | 15 | 298 | |
390522 | 390522 | 95448 | 95448: Healdsburg | 2022-02-22 | Sonoma | 97 | 2511 | 17482 | |
390521 | 390521 | 95446 | 95446: Guerneville | 2022-02-22 | Sonoma | 97 | 505 | 5100 | |
390520 | 390520 | 95444 | 95444: Graton | 2022-02-22 | Sonoma | 97 | 115 | 715 | |
390519 | 390519 | 95442 | 95442: Glen Ellen | 2022-02-22 | Sonoma | 97 | 363 | 3136 | |
390518 | 390518 | 95441 | 95441: Geyserville | 2022-02-22 | Sonoma | 97 | 298 | 2053 | |
390517 | 390517 | 95439 | 95439: Fulton | 2022-02-22 | Sonoma | 97 | 148 | 774 | |
390516 | 390516 | 95436 | 95436: Forestville | 2022-02-22 | Sonoma | 97 | 569 | 6352 | |
390515 | 390515 | 95425 | 95425: Cloverdale | 2022-02-22 | Sonoma | 97 | 1797 | 10586 | |
390514 | 390514 | 95421 | 95421: Cazadero | 2022-02-22 | Sonoma | 97 | 99 | 1681 | |
390513 | 390513 | 95412 | 95412: Annapolis | 2022-02-22 | Sonoma | 97 | 18 | 402 | |
390512 | 390512 | 95409 | 95409: Santa Rosa | 2022-02-22 | Sonoma | 97 | 2957 | 27312 | |
390511 | 390511 | 95407 | 95407: Santa Rosa | 2022-02-22 | Sonoma | 97 | 10851 | 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 );