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-12 sorted by rowid descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▲ | id | name | date | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
908003 | 908003 | Wheatland | Wheatland | 2021-01-12 | Yuba | 115 | 262 | 3747 | |
908002 | 908002 | Plumas Lake | Plumas Lake | 2021-01-12 | Yuba | 115 | 473 | 7367 | |
908001 | 908001 | Other | Other | 2021-01-12 | Yuba | 115 | 266 | ||
908000 | 908000 | Olivehurst Linda | Olivehurst Linda | 2021-01-12 | Yuba | 115 | 1313 | 32623 | |
907999 | 907999 | Marysville | Marysville | 2021-01-12 | Yuba | 115 | 2126 | 12282 | |
907998 | 907998 | Woodland | Woodland | 2021-01-12 | Yolo | 113 | 3928 | 59044 | |
907997 | 907997 | Winters | Winters | 2021-01-12 | Yolo | 113 | 433 | 7132 | |
907996 | 907996 | West Sacramento | West Sacramento | 2021-01-12 | Yolo | 113 | 2741 | 52826 | |
907995 | 907995 | Unincorporated | Other | 2021-01-12 | Yolo | 113 | 953 | ||
907994 | 907994 | Davis | Davis | 2021-01-12 | Yolo | 113 | 1390 | 67988 | |
907993 | 907993 | 93066 | 93066: Somis | 2021-01-12 | Ventura | 111 | 177 | 3481 | |
907992 | 907992 | 93065 | 93065: Simi Valley | 2021-01-12 | Ventura | 111 | 4326 | 74780 | |
907991 | 907991 | 93063 | 93063: Simi Valley (Santa Susana) | 2021-01-12 | Ventura | 111 | 3104 | 56563 | |
907990 | 907990 | 93060 | 93060: Santa Paula | 2021-01-12 | Ventura | 111 | 3589 | 34229 | |
907989 | 907989 | 93041 | 93041: Port Hueneme | 2021-01-12 | Ventura | 111 | 1553 | 24129 | |
907988 | 907988 | 93040 | 93040: Piru | 2021-01-12 | Ventura | 111 | 245 | 1831 | |
907987 | 907987 | 93036 | 93036: Oxnard | 2021-01-12 | Ventura | 111 | 4036 | 48022 | |
907986 | 907986 | 93035 | 93035: Oxnard | 2021-01-12 | Ventura | 111 | 1563 | 28321 | |
907985 | 907985 | 93033 | 93033: Oxnard | 2021-01-12 | Ventura | 111 | 8945 | 83319 | |
907984 | 907984 | 93030 | 93030: Oxnard | 2021-01-12 | Ventura | 111 | 6549 | 62016 | |
907983 | 907983 | 93023 | 93023: Ojai | 2021-01-12 | Ventura | 111 | 623 | 20656 | |
907982 | 907982 | 93022 | 93022: Oak View | 2021-01-12 | Ventura | 111 | 215 | 5550 | |
907981 | 907981 | 93021 | 93021: Moorpark | 2021-01-12 | Ventura | 111 | 1844 | 38325 | |
907980 | 907980 | 93015 | 93015: Fillmore | 2021-01-12 | Ventura | 111 | 1754 | 18832 | |
907979 | 907979 | 93012 | 93012: Camarillo/Santa Rosa Valley | 2021-01-12 | Ventura | 111 | 1127 | 37622 | |
907978 | 907978 | 93010 | 93010: Camarillo | 2021-01-12 | Ventura | 111 | 2034 | 44240 | |
907977 | 907977 | 93004 | 93004: Ventura | 2021-01-12 | Ventura | 111 | 1441 | 30473 | |
907976 | 907976 | 93003 | 93003: Ventura | 2021-01-12 | Ventura | 111 | 2662 | 51304 | |
907975 | 907975 | 93001 | 93001: Ventura | 2021-01-12 | Ventura | 111 | 1770 | 33139 | |
907974 | 907974 | 91377 | 91377: Oak Park | 2021-01-12 | Ventura | 111 | 259 | 14226 | |
907973 | 907973 | 91362 | 91362: Thousand Oaks/Westlake | 2021-01-12 | Ventura | 111 | 1111 | 36980 | |
907972 | 907972 | 91361 | 91361: Thousand Oaks/Lake Sherwood/Westlake | 2021-01-12 | Ventura | 111 | 418 | 20487 | |
907971 | 907971 | 91360 | 91360: Thousand Oaks | 2021-01-12 | Ventura | 111 | 1725 | 42104 | |
907970 | 907970 | 91320 | 91320: Thousand Oaks/Newbury Park | 2021-01-12 | Ventura | 111 | 1854 | 46191 | |
907969 | 907969 | 91307 | 91307: Bell Canyon | 2021-01-12 | Ventura | 111 | 7 | 2391 | |
907968 | 907968 | 93654 | Orosi: 93654 | 2021-01-12 | Tulare | 107 | 47 | 0 | |
907967 | 907967 | 93647 | Orosi: 93647 | 2021-01-12 | Tulare | 107 | 1148 | 10896 | |
907966 | 907966 | 93646 | Traver: 93646 | 2021-01-12 | Tulare | 107 | 17 | 0 | |
907965 | 907965 | 93631 | Traver: 93631 | 2021-01-12 | Tulare | 107 | 200 | 16349 | |
907964 | 907964 | 93618 | Dinuba: 93618 | 2021-01-12 | Tulare | 107 | 3447 | 31230 | |
907963 | 907963 | 93615 | Cutler: 93615 | 2021-01-12 | Tulare | 107 | 622 | 6513 | |
907962 | 907962 | 93292 | Visalia: 93292 | 2021-01-12 | Tulare | 107 | 2789 | 41031 | |
907961 | 907961 | 93291 | Visalia: 93291 | 2021-01-12 | Tulare | 107 | 4288 | 57968 | |
907960 | 907960 | 93286 | Woodlake: 93286 | 2021-01-12 | Tulare | 107 | 690 | 9755 | |
907959 | 907959 | 93277 | Visalia: 93277 | 2021-01-12 | Tulare | 107 | 3375 | 53015 | |
907958 | 907958 | 93274 | Tulare: 93274 | 2021-01-12 | Tulare | 107 | 6900 | 73778 | |
907957 | 907957 | 93272 | Tipton: 93272 | 2021-01-12 | Tulare | 107 | 281 | 4454 | |
907956 | 907956 | 93271 | Three Rivers: 93271 | 2021-01-12 | Tulare | 107 | 41 | 2432 | |
907955 | 907955 | 93270 | Terra Bella: 93270 | 2021-01-12 | Tulare | 107 | 537 | 5542 | |
907954 | 907954 | 93267 | Strathmore: 93267 | 2021-01-12 | Tulare | 107 | 518 | 5542 | |
907953 | 907953 | 93265 | Springville: 93265 | 2021-01-12 | Tulare | 107 | 96 | 6347 | |
907952 | 907952 | 93262 | Mountain: 93262 | 2021-01-12 | Tulare | 107 | 34 | 3271 | |
907951 | 907951 | 93257 | Porterville: 93257 | 2021-01-12 | Tulare | 107 | 7642 | 76923 | |
907950 | 907950 | 93256 | Pixley: 93256 | 2021-01-12 | Tulare | 107 | 640 | 5939 | |
907949 | 907949 | 93247 | Lindsay: 93247 | 2021-01-12 | Tulare | 107 | 1455 | 18522 | |
907948 | 907948 | 93235 | Ivanhoe: 93235 | 2021-01-12 | Tulare | 107 | 407 | 4198 | |
907947 | 907947 | 93227 | Goshen: 93227 | 2021-01-12 | Tulare | 107 | 77 | 3425 | |
907946 | 907946 | 93223 | Farmersville: 93223 | 2021-01-12 | Tulare | 107 | 957 | 10742 | |
907945 | 907945 | 93221 | Exeter: 93221 | 2021-01-12 | Tulare | 107 | 844 | 14328 | |
907944 | 907944 | 93219 | Earlimart: 93219 | 2021-01-12 | Tulare | 107 | 1190 | 10167 | |
907943 | 907943 | 93215 | Richgrove: 93215 | 2021-01-12 | Tulare | 107 | 241 | 55269 | |
907942 | 907942 | 93212 | Corcoran, Angiola: 93212 | 2021-01-12 | Tulare | 107 | 9 | 0 | |
907941 | 907941 | 93201 | Alpaugh: 93201 | 2021-01-12 | Tulare | 107 | 63 | 1431 | |
907940 | 907940 | West County | West County | 2021-01-12 | Trinity | 105 | 25 | 2254 | |
907939 | 907939 | South County | South County | 2021-01-12 | Trinity | 105 | 64 | 4010 | |
907938 | 907938 | North County | North County | 2021-01-12 | Trinity | 105 | 5 | 699 | |
907937 | 907937 | East County | East County | 2021-01-12 | Trinity | 105 | 204 | 6738 | |
907936 | 907936 | Yuba City | Yuba City | 2021-01-12 | Sutter | 101 | 5817 | 66388 | |
907935 | 907935 | Other | Other | 2021-01-12 | Sutter | 101 | 392 | ||
907934 | 907934 | Live Oak | Live Oak | 2021-01-12 | Sutter | 101 | 809 | 8622 | |
907933 | 907933 | Waterford | Waterford | 2021-01-12 | Stanislaus | 99 | 464 | 8823 | |
907932 | 907932 | Unincorporated districts | Other | 2021-01-12 | Stanislaus | 99 | 6731 | ||
907931 | 907931 | Turlock | Turlock | 2021-01-12 | Stanislaus | 99 | 5308 | 72335 | |
907930 | 907930 | Riverbank | Riverbank | 2021-01-12 | Stanislaus | 99 | 1781 | 24237 | |
907929 | 907929 | Patterson | Patterson | 2021-01-12 | Stanislaus | 99 | 1937 | 21783 | |
907928 | 907928 | Oakdale | Oakdale | 2021-01-12 | Stanislaus | 99 | 1202 | 22599 | |
907927 | 907927 | Newman | Newman | 2021-01-12 | Stanislaus | 99 | 869 | 11119 | |
907926 | 907926 | Modesto | Modesto | 2021-01-12 | Stanislaus | 99 | 14173 | 211336 | |
907925 | 907925 | Hughson | Hughson | 2021-01-12 | Stanislaus | 99 | 404 | 7370 | |
907924 | 907924 | Ceres | Ceres | 2021-01-12 | Stanislaus | 99 | 4134 | 47975 | |
907923 | 907923 | 95497 | 95497: The Sea Ranch | 2021-01-12 | Sonoma | 97 | 10 | 10 or fewer | 1161 |
907922 | 907922 | 95492 | 95492: Windsor | 2021-01-12 | Sonoma | 97 | 1102 | 29920 | |
907921 | 907921 | 95476 | 95476: Sonoma | 2021-01-12 | Sonoma | 97 | 1498 | 36792 | |
907920 | 907920 | 95472 | 95472: Sebastopol | 2021-01-12 | Sonoma | 97 | 389 | 30762 | |
907919 | 907919 | 95465 | 95465: Occidental | 2021-01-12 | Sonoma | 97 | 10 | 10 or fewer | 2104 |
907918 | 907918 | 95462 | 95462: Monte Rio | 2021-01-12 | Sonoma | 97 | 17 | 1265 | |
907917 | 907917 | 95452 | 95452: Kenwood | 2021-01-12 | Sonoma | 97 | 15 | 970 | |
907916 | 907916 | 95450 | 95450: Jenner | 2021-01-12 | Sonoma | 97 | 10 | 10 or fewer | 298 |
907915 | 907915 | 95448 | 95448: Healdsburg | 2021-01-12 | Sonoma | 97 | 654 | 17482 | |
907914 | 907914 | 95446 | 95446: Guerneville | 2021-01-12 | Sonoma | 97 | 92 | 5100 | |
907913 | 907913 | 95444 | 95444: Graton | 2021-01-12 | Sonoma | 97 | 20 | 715 | |
907912 | 907912 | 95442 | 95442: Glen Ellen | 2021-01-12 | Sonoma | 97 | 103 | 3136 | |
907911 | 907911 | 95441 | 95441: Geyserville | 2021-01-12 | Sonoma | 97 | 61 | 2053 | |
907910 | 907910 | 95439 | 95439: Fulton | 2021-01-12 | Sonoma | 97 | 35 | 774 | |
907909 | 907909 | 95436 | 95436: Forestville | 2021-01-12 | Sonoma | 97 | 107 | 6352 | |
907908 | 907908 | 95425 | 95425: Cloverdale | 2021-01-12 | Sonoma | 97 | 514 | 10586 | |
907907 | 907907 | 95421 | 95421: Cazadero | 2021-01-12 | Sonoma | 97 | 12 | 1681 | |
907906 | 907906 | 95412 | 95412: Annapolis | 2021-01-12 | Sonoma | 97 | 0 | 402 | |
907905 | 907905 | 95409 | 95409: Santa Rosa | 2021-01-12 | Sonoma | 97 | 632 | 27312 | |
907904 | 907904 | 95407 | 95407: Santa Rosa | 2021-01-12 | 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 );