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-27 sorted by rowid descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▲ | id | name | date | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
888863 | 888863 | Wheatland | Wheatland | 2021-01-27 | Yuba | 115 | 284 | 3747 | |
888862 | 888862 | Plumas Lake | Plumas Lake | 2021-01-27 | Yuba | 115 | 543 | 7367 | |
888861 | 888861 | Other | Other | 2021-01-27 | Yuba | 115 | 306 | ||
888860 | 888860 | Olivehurst Linda | Olivehurst Linda | 2021-01-27 | Yuba | 115 | 1465 | 32623 | |
888859 | 888859 | Marysville | Marysville | 2021-01-27 | Yuba | 115 | 2451 | 12282 | |
888858 | 888858 | Woodland | Woodland | 2021-01-27 | Yolo | 113 | 4706 | 59044 | |
888857 | 888857 | Winters | Winters | 2021-01-27 | Yolo | 113 | 486 | 7132 | |
888856 | 888856 | West Sacramento | West Sacramento | 2021-01-27 | Yolo | 113 | 3172 | 52826 | |
888855 | 888855 | Unincorporated | Other | 2021-01-27 | Yolo | 113 | 1215 | ||
888854 | 888854 | Davis | Davis | 2021-01-27 | Yolo | 113 | 1667 | 67988 | |
888853 | 888853 | 93066 | 93066: Somis | 2021-01-27 | Ventura | 111 | 201 | 3481 | |
888852 | 888852 | 93065 | 93065: Simi Valley | 2021-01-27 | Ventura | 111 | 5352 | 74780 | |
888851 | 888851 | 93063 | 93063: Simi Valley (Santa Susana) | 2021-01-27 | Ventura | 111 | 3730 | 56563 | |
888850 | 888850 | 93060 | 93060: Santa Paula | 2021-01-27 | Ventura | 111 | 4567 | 34229 | |
888849 | 888849 | 93041 | 93041: Port Hueneme | 2021-01-27 | Ventura | 111 | 2005 | 24129 | |
888848 | 888848 | 93040 | 93040: Piru | 2021-01-27 | Ventura | 111 | 304 | 1831 | |
888847 | 888847 | 93036 | 93036: Oxnard | 2021-01-27 | Ventura | 111 | 5236 | 48022 | |
888846 | 888846 | 93035 | 93035: Oxnard | 2021-01-27 | Ventura | 111 | 1978 | 28321 | |
888845 | 888845 | 93033 | 93033: Oxnard | 2021-01-27 | Ventura | 111 | 11703 | 83319 | |
888844 | 888844 | 93030 | 93030: Oxnard | 2021-01-27 | Ventura | 111 | 8283 | 62016 | |
888843 | 888843 | 93023 | 93023: Ojai | 2021-01-27 | Ventura | 111 | 850 | 20656 | |
888842 | 888842 | 93022 | 93022: Oak View | 2021-01-27 | Ventura | 111 | 298 | 5550 | |
888841 | 888841 | 93021 | 93021: Moorpark | 2021-01-27 | Ventura | 111 | 2343 | 38325 | |
888840 | 888840 | 93015 | 93015: Fillmore | 2021-01-27 | Ventura | 111 | 2236 | 18832 | |
888839 | 888839 | 93012 | 93012: Camarillo/Santa Rosa Valley | 2021-01-27 | Ventura | 111 | 1430 | 37622 | |
888838 | 888838 | 93010 | 93010: Camarillo | 2021-01-27 | Ventura | 111 | 2638 | 44240 | |
888837 | 888837 | 93004 | 93004: Ventura | 2021-01-27 | Ventura | 111 | 1947 | 30473 | |
888836 | 888836 | 93003 | 93003: Ventura | 2021-01-27 | Ventura | 111 | 3416 | 51304 | |
888835 | 888835 | 93001 | 93001: Ventura | 2021-01-27 | Ventura | 111 | 2371 | 33139 | |
888834 | 888834 | 91377 | 91377: Oak Park | 2021-01-27 | Ventura | 111 | 338 | 14226 | |
888833 | 888833 | 91362 | 91362: Thousand Oaks/Westlake | 2021-01-27 | Ventura | 111 | 1368 | 36980 | |
888832 | 888832 | 91361 | 91361: Thousand Oaks/Lake Sherwood/Westlake | 2021-01-27 | Ventura | 111 | 500 | 20487 | |
888831 | 888831 | 91360 | 91360: Thousand Oaks | 2021-01-27 | Ventura | 111 | 2169 | 42104 | |
888830 | 888830 | 91320 | 91320: Thousand Oaks/Newbury Park | 2021-01-27 | Ventura | 111 | 2263 | 46191 | |
888829 | 888829 | 91307 | 91307: Bell Canyon | 2021-01-27 | Ventura | 111 | 7 | 2391 | |
888828 | 888828 | 93654 | Orosi: 93654 | 2021-01-27 | Tulare | 107 | 50 | 0 | |
888827 | 888827 | 93647 | Orosi: 93647 | 2021-01-27 | Tulare | 107 | 1290 | 10896 | |
888826 | 888826 | 93646 | Traver: 93646 | 2021-01-27 | Tulare | 107 | 18 | 0 | |
888825 | 888825 | 93631 | Traver: 93631 | 2021-01-27 | Tulare | 107 | 224 | 16349 | |
888824 | 888824 | 93618 | Dinuba: 93618 | 2021-01-27 | Tulare | 107 | 3807 | 31230 | |
888823 | 888823 | 93615 | Cutler: 93615 | 2021-01-27 | Tulare | 107 | 685 | 6513 | |
888822 | 888822 | 93292 | Visalia: 93292 | 2021-01-27 | Tulare | 107 | 3157 | 41031 | |
888821 | 888821 | 93291 | Visalia: 93291 | 2021-01-27 | Tulare | 107 | 4856 | 57968 | |
888820 | 888820 | 93286 | Woodlake: 93286 | 2021-01-27 | Tulare | 107 | 818 | 9755 | |
888819 | 888819 | 93277 | Visalia: 93277 | 2021-01-27 | Tulare | 107 | 3826 | 53015 | |
888818 | 888818 | 93274 | Tulare: 93274 | 2021-01-27 | Tulare | 107 | 7769 | 73778 | |
888817 | 888817 | 93272 | Tipton: 93272 | 2021-01-27 | Tulare | 107 | 325 | 4454 | |
888816 | 888816 | 93271 | Three Rivers: 93271 | 2021-01-27 | Tulare | 107 | 47 | 2432 | |
888815 | 888815 | 93270 | Terra Bella: 93270 | 2021-01-27 | Tulare | 107 | 628 | 5542 | |
888814 | 888814 | 93267 | Strathmore: 93267 | 2021-01-27 | Tulare | 107 | 578 | 5542 | |
888813 | 888813 | 93265 | Springville: 93265 | 2021-01-27 | Tulare | 107 | 119 | 6347 | |
888812 | 888812 | 93262 | Mountain: 93262 | 2021-01-27 | Tulare | 107 | 38 | 3271 | |
888811 | 888811 | 93257 | Porterville: 93257 | 2021-01-27 | Tulare | 107 | 8763 | 76923 | |
888810 | 888810 | 93256 | Pixley: 93256 | 2021-01-27 | Tulare | 107 | 714 | 5939 | |
888809 | 888809 | 93247 | Lindsay: 93247 | 2021-01-27 | Tulare | 107 | 1664 | 18522 | |
888808 | 888808 | 93235 | Ivanhoe: 93235 | 2021-01-27 | Tulare | 107 | 459 | 4198 | |
888807 | 888807 | 93227 | Goshen: 93227 | 2021-01-27 | Tulare | 107 | 85 | 3425 | |
888806 | 888806 | 93223 | Farmersville: 93223 | 2021-01-27 | Tulare | 107 | 1084 | 10742 | |
888805 | 888805 | 93221 | Exeter: 93221 | 2021-01-27 | Tulare | 107 | 936 | 14328 | |
888804 | 888804 | 93219 | Earlimart: 93219 | 2021-01-27 | Tulare | 107 | 1306 | 10167 | |
888803 | 888803 | 93215 | Richgrove: 93215 | 2021-01-27 | Tulare | 107 | 299 | 55269 | |
888802 | 888802 | 93212 | Corcoran, Angiola: 93212 | 2021-01-27 | Tulare | 107 | 10 | 0 | |
888801 | 888801 | 93201 | Alpaugh: 93201 | 2021-01-27 | Tulare | 107 | 71 | 1431 | |
888800 | 888800 | West County | West County | 2021-01-27 | Trinity | 105 | 25 | 2254 | |
888799 | 888799 | South County | South County | 2021-01-27 | Trinity | 105 | 66 | 4010 | |
888798 | 888798 | North County | North County | 2021-01-27 | Trinity | 105 | 5 | 699 | |
888797 | 888797 | East County | East County | 2021-01-27 | Trinity | 105 | 211 | 6738 | |
888796 | 888796 | Yuba City | Yuba City | 2021-01-27 | Sutter | 101 | 6535 | 66388 | |
888795 | 888795 | Other | Other | 2021-01-27 | Sutter | 101 | 464 | ||
888794 | 888794 | Live Oak | Live Oak | 2021-01-27 | Sutter | 101 | 928 | 8622 | |
888793 | 888793 | Waterford | Waterford | 2021-01-27 | Stanislaus | 99 | 531 | 8823 | |
888792 | 888792 | Unincorporated districts | Other | 2021-01-27 | Stanislaus | 99 | 7749 | ||
888791 | 888791 | Turlock | Turlock | 2021-01-27 | Stanislaus | 99 | 5996 | 72335 | |
888790 | 888790 | Riverbank | Riverbank | 2021-01-27 | Stanislaus | 99 | 2034 | 24237 | |
888789 | 888789 | Patterson | Patterson | 2021-01-27 | Stanislaus | 99 | 2245 | 21783 | |
888788 | 888788 | Oakdale | Oakdale | 2021-01-27 | Stanislaus | 99 | 1408 | 22599 | |
888787 | 888787 | Newman | Newman | 2021-01-27 | Stanislaus | 99 | 1025 | 11119 | |
888786 | 888786 | Modesto | Modesto | 2021-01-27 | Stanislaus | 99 | 16516 | 211336 | |
888785 | 888785 | Hughson | Hughson | 2021-01-27 | Stanislaus | 99 | 480 | 7370 | |
888784 | 888784 | Ceres | Ceres | 2021-01-27 | Stanislaus | 99 | 4693 | 47975 | |
888783 | 888783 | 95497 | 95497: The Sea Ranch | 2021-01-27 | Sonoma | 97 | 10 | 10 or fewer | 1161 |
888782 | 888782 | 95492 | 95492: Windsor | 2021-01-27 | Sonoma | 97 | 1358 | 29920 | |
888781 | 888781 | 95476 | 95476: Sonoma | 2021-01-27 | Sonoma | 97 | 1919 | 36792 | |
888780 | 888780 | 95472 | 95472: Sebastopol | 2021-01-27 | Sonoma | 97 | 528 | 30762 | |
888779 | 888779 | 95465 | 95465: Occidental | 2021-01-27 | Sonoma | 97 | 16 | 2104 | |
888778 | 888778 | 95462 | 95462: Monte Rio | 2021-01-27 | Sonoma | 97 | 18 | 1265 | |
888777 | 888777 | 95452 | 95452: Kenwood | 2021-01-27 | Sonoma | 97 | 17 | 970 | |
888776 | 888776 | 95450 | 95450: Jenner | 2021-01-27 | Sonoma | 97 | 10 | 10 or fewer | 298 |
888775 | 888775 | 95448 | 95448: Healdsburg | 2021-01-27 | Sonoma | 97 | 792 | 17482 | |
888774 | 888774 | 95446 | 95446: Guerneville | 2021-01-27 | Sonoma | 97 | 111 | 5100 | |
888773 | 888773 | 95444 | 95444: Graton | 2021-01-27 | Sonoma | 97 | 23 | 715 | |
888772 | 888772 | 95442 | 95442: Glen Ellen | 2021-01-27 | Sonoma | 97 | 120 | 3136 | |
888771 | 888771 | 95441 | 95441: Geyserville | 2021-01-27 | Sonoma | 97 | 78 | 2053 | |
888770 | 888770 | 95439 | 95439: Fulton | 2021-01-27 | Sonoma | 97 | 43 | 774 | |
888769 | 888769 | 95436 | 95436: Forestville | 2021-01-27 | Sonoma | 97 | 131 | 6352 | |
888768 | 888768 | 95425 | 95425: Cloverdale | 2021-01-27 | Sonoma | 97 | 629 | 10586 | |
888767 | 888767 | 95421 | 95421: Cazadero | 2021-01-27 | Sonoma | 97 | 17 | 1681 | |
888766 | 888766 | 95412 | 95412: Annapolis | 2021-01-27 | Sonoma | 97 | 10 | 10 or fewer | 402 |
888765 | 888765 | 95409 | 95409: Santa Rosa | 2021-01-27 | Sonoma | 97 | 759 | 27312 | |
888764 | 888764 | 95407 | 95407: Santa Rosa | 2021-01-27 | Sonoma | 97 | 4052 | 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 );