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-24 sorted by rowid descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▲ | id | name | date | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
388056 | 388056 | Wheatland | Wheatland | 2022-02-24 | Yuba | 115 | 965 | 3747 | |
388055 | 388055 | Plumas Lake | Plumas Lake | 2022-02-24 | Yuba | 115 | 2139 | 7367 | |
388054 | 388054 | Other | Other | 2022-02-24 | Yuba | 115 | 1681 | ||
388053 | 388053 | Olivehurst Linda | Olivehurst Linda | 2022-02-24 | Yuba | 115 | 4735 | 32623 | |
388052 | 388052 | Marysville | Marysville | 2022-02-24 | Yuba | 115 | 7826 | 12282 | |
388051 | 388051 | Woodland | Woodland | 2022-02-24 | Yolo | 113 | 11573 | 59044 | |
388050 | 388050 | Winters | Winters | 2022-02-24 | Yolo | 113 | 1176 | 7132 | |
388049 | 388049 | West Sacramento | West Sacramento | 2022-02-24 | Yolo | 113 | 10106 | 52826 | |
388048 | 388048 | Unincorporated | Other | 2022-02-24 | Yolo | 113 | 4212 | ||
388047 | 388047 | Davis | Davis | 2022-02-24 | Yolo | 113 | 7832 | 67988 | |
388046 | 388046 | 93066 | 93066: Somis | 2022-02-24 | Ventura | 111 | 522 | 3481 | |
388045 | 388045 | 93065 | 93065: Simi Valley | 2022-02-24 | Ventura | 111 | 14035 | 74780 | |
388044 | 388044 | 93063 | 93063: Simi Valley (Santa Susana) | 2022-02-24 | Ventura | 111 | 9972 | 56563 | |
388043 | 388043 | 93060 | 93060: Santa Paula | 2022-02-24 | Ventura | 111 | 10131 | 34229 | |
388042 | 388042 | 93041 | 93041: Port Hueneme | 2022-02-24 | Ventura | 111 | 5071 | 24129 | |
388041 | 388041 | 93040 | 93040: Piru | 2022-02-24 | Ventura | 111 | 712 | 1831 | |
388040 | 388040 | 93036 | 93036: Oxnard | 2022-02-24 | Ventura | 111 | 12024 | 48022 | |
388039 | 388039 | 93035 | 93035: Oxnard | 2022-02-24 | Ventura | 111 | 5424 | 28321 | |
388038 | 388038 | 93033 | 93033: Oxnard | 2022-02-24 | Ventura | 111 | 23340 | 83319 | |
388037 | 388037 | 93030 | 93030: Oxnard | 2022-02-24 | Ventura | 111 | 17036 | 62016 | |
388036 | 388036 | 93023 | 93023: Ojai | 2022-02-24 | Ventura | 111 | 2534 | 20656 | |
388035 | 388035 | 93022 | 93022: Oak View | 2022-02-24 | Ventura | 111 | 973 | 5550 | |
388034 | 388034 | 93021 | 93021: Moorpark | 2022-02-24 | Ventura | 111 | 6591 | 38325 | |
388033 | 388033 | 93015 | 93015: Fillmore | 2022-02-24 | Ventura | 111 | 5776 | 18832 | |
388032 | 388032 | 93012 | 93012: Camarillo/Santa Rosa Valley | 2022-02-24 | Ventura | 111 | 4766 | 37622 | |
388031 | 388031 | 93010 | 93010: Camarillo | 2022-02-24 | Ventura | 111 | 7861 | 44240 | |
388030 | 388030 | 93004 | 93004: Ventura | 2022-02-24 | Ventura | 111 | 5400 | 30473 | |
388029 | 388029 | 93003 | 93003: Ventura | 2022-02-24 | Ventura | 111 | 9484 | 51304 | |
388028 | 388028 | 93001 | 93001: Ventura | 2022-02-24 | Ventura | 111 | 6383 | 33139 | |
388027 | 388027 | 91377 | 91377: Oak Park | 2022-02-24 | Ventura | 111 | 1653 | 14226 | |
388026 | 388026 | 91362 | 91362: Thousand Oaks/Westlake | 2022-02-24 | Ventura | 111 | 4903 | 36980 | |
388025 | 388025 | 91361 | 91361: Thousand Oaks/Lake Sherwood/Westlake | 2022-02-24 | Ventura | 111 | 1706 | 20487 | |
388024 | 388024 | 91360 | 91360: Thousand Oaks | 2022-02-24 | Ventura | 111 | 6902 | 42104 | |
388023 | 388023 | 91320 | 91320: Thousand Oaks/Newbury Park | 2022-02-24 | Ventura | 111 | 7030 | 46191 | |
388022 | 388022 | 91307 | 91307: Bell Canyon | 2022-02-24 | Ventura | 111 | 37 | 2391 | |
388021 | 388021 | 93654 | Orosi: 93654 | 2022-02-24 | Tulare | 107 | 206 | 0 | |
388020 | 388020 | 93647 | Orosi: 93647 | 2022-02-24 | Tulare | 107 | 2725 | 10896 | |
388019 | 388019 | 93646 | Traver: 93646 | 2022-02-24 | Tulare | 107 | 57 | 0 | |
388018 | 388018 | 93631 | Traver: 93631 | 2022-02-24 | Tulare | 107 | 515 | 16349 | |
388017 | 388017 | 93618 | Dinuba: 93618 | 2022-02-24 | Tulare | 107 | 7965 | 31230 | |
388016 | 388016 | 93615 | Cutler: 93615 | 2022-02-24 | Tulare | 107 | 1382 | 6513 | |
388015 | 388015 | 93292 | Visalia: 93292 | 2022-02-24 | Tulare | 107 | 7383 | 41031 | |
388014 | 388014 | 93291 | Visalia: 93291 | 2022-02-24 | Tulare | 107 | 11561 | 57968 | |
388013 | 388013 | 93286 | Woodlake: 93286 | 2022-02-24 | Tulare | 107 | 1879 | 9755 | |
388012 | 388012 | 93277 | Visalia: 93277 | 2022-02-24 | Tulare | 107 | 9119 | 53015 | |
388011 | 388011 | 93274 | Tulare: 93274 | 2022-02-24 | Tulare | 107 | 16926 | 73778 | |
388010 | 388010 | 93272 | Tipton: 93272 | 2022-02-24 | Tulare | 107 | 842 | 4454 | |
388009 | 388009 | 93271 | Three Rivers: 93271 | 2022-02-24 | Tulare | 107 | 148 | 2432 | |
388008 | 388008 | 93270 | Terra Bella: 93270 | 2022-02-24 | Tulare | 107 | 1443 | 5542 | |
388007 | 388007 | 93267 | Strathmore: 93267 | 2022-02-24 | Tulare | 107 | 1365 | 5542 | |
388006 | 388006 | 93265 | Springville: 93265 | 2022-02-24 | Tulare | 107 | 483 | 6347 | |
388005 | 388005 | 93262 | Mountain: 93262 | 2022-02-24 | Tulare | 107 | 96 | 3271 | |
388004 | 388004 | 93257 | Porterville: 93257 | 2022-02-24 | Tulare | 107 | 20616 | 76923 | |
388003 | 388003 | 93256 | Pixley: 93256 | 2022-02-24 | Tulare | 107 | 1610 | 5939 | |
388002 | 388002 | 93247 | Lindsay: 93247 | 2022-02-24 | Tulare | 107 | 3808 | 18522 | |
388001 | 388001 | 93235 | Ivanhoe: 93235 | 2022-02-24 | Tulare | 107 | 1043 | 4198 | |
388000 | 388000 | 93227 | Goshen: 93227 | 2022-02-24 | Tulare | 107 | 173 | 3425 | |
387999 | 387999 | 93223 | Farmersville: 93223 | 2022-02-24 | Tulare | 107 | 2306 | 10742 | |
387998 | 387998 | 93221 | Exeter: 93221 | 2022-02-24 | Tulare | 107 | 2154 | 14328 | |
387997 | 387997 | 93219 | Earlimart: 93219 | 2022-02-24 | Tulare | 107 | 2513 | 10167 | |
387996 | 387996 | 93215 | Richgrove: 93215 | 2022-02-24 | Tulare | 107 | 688 | 55269 | |
387995 | 387995 | 93212 | Corcoran, Angiola: 93212 | 2022-02-24 | Tulare | 107 | 25 | 0 | |
387994 | 387994 | 93201 | Alpaugh: 93201 | 2022-02-24 | Tulare | 107 | 249 | 1431 | |
387993 | 387993 | West County | West County | 2022-02-24 | Trinity | 105 | 108 | 2254 | |
387992 | 387992 | South County | South County | 2022-02-24 | Trinity | 105 | 241 | 4010 | |
387991 | 387991 | North County | North County | 2022-02-24 | Trinity | 105 | 42 | 699 | |
387990 | 387990 | East County | East County | 2022-02-24 | Trinity | 105 | 687 | 6738 | |
387989 | 387989 | Yuba City | Yuba City | 2022-02-24 | Sutter | 101 | 18300 | 66388 | |
387988 | 387988 | Other | Other | 2022-02-24 | Sutter | 101 | 1302 | ||
387987 | 387987 | Live Oak | Live Oak | 2022-02-24 | Sutter | 101 | 2435 | 8622 | |
387986 | 387986 | Waterford | Waterford | 2022-02-24 | Stanislaus | 99 | 1609 | 8823 | |
387985 | 387985 | Unincorporated districts | Other | 2022-02-24 | Stanislaus | 99 | 19522 | ||
387984 | 387984 | Turlock | Turlock | 2022-02-24 | Stanislaus | 99 | 15183 | 72335 | |
387983 | 387983 | Riverbank | Riverbank | 2022-02-24 | Stanislaus | 99 | 5392 | 24237 | |
387982 | 387982 | Patterson | Patterson | 2022-02-24 | Stanislaus | 99 | 4753 | 21783 | |
387981 | 387981 | Oakdale | Oakdale | 2022-02-24 | Stanislaus | 99 | 4087 | 22599 | |
387980 | 387980 | Newman | Newman | 2022-02-24 | Stanislaus | 99 | 2162 | 11119 | |
387979 | 387979 | Modesto | Modesto | 2022-02-24 | Stanislaus | 99 | 44458 | 211336 | |
387978 | 387978 | Hughson | Hughson | 2022-02-24 | Stanislaus | 99 | 1240 | 7370 | |
387977 | 387977 | Ceres | Ceres | 2022-02-24 | Stanislaus | 99 | 11434 | 47975 | |
387976 | 387976 | 95497 | 95497: The Sea Ranch | 2022-02-24 | Sonoma | 97 | 30 | 1161 | |
387975 | 387975 | 95492 | 95492: Windsor | 2022-02-24 | Sonoma | 97 | 5036 | 29920 | |
387974 | 387974 | 95476 | 95476: Sonoma | 2022-02-24 | Sonoma | 97 | 5889 | 36792 | |
387973 | 387973 | 95472 | 95472: Sebastopol | 2022-02-24 | Sonoma | 97 | 2648 | 30762 | |
387972 | 387972 | 95465 | 95465: Occidental | 2022-02-24 | Sonoma | 97 | 126 | 2104 | |
387971 | 387971 | 95462 | 95462: Monte Rio | 2022-02-24 | Sonoma | 97 | 109 | 1265 | |
387970 | 387970 | 95452 | 95452: Kenwood | 2022-02-24 | Sonoma | 97 | 87 | 970 | |
387969 | 387969 | 95450 | 95450: Jenner | 2022-02-24 | Sonoma | 97 | 15 | 298 | |
387968 | 387968 | 95448 | 95448: Healdsburg | 2022-02-24 | Sonoma | 97 | 2521 | 17482 | |
387967 | 387967 | 95446 | 95446: Guerneville | 2022-02-24 | Sonoma | 97 | 508 | 5100 | |
387966 | 387966 | 95444 | 95444: Graton | 2022-02-24 | Sonoma | 97 | 115 | 715 | |
387965 | 387965 | 95442 | 95442: Glen Ellen | 2022-02-24 | Sonoma | 97 | 363 | 3136 | |
387964 | 387964 | 95441 | 95441: Geyserville | 2022-02-24 | Sonoma | 97 | 299 | 2053 | |
387963 | 387963 | 95439 | 95439: Fulton | 2022-02-24 | Sonoma | 97 | 148 | 774 | |
387962 | 387962 | 95436 | 95436: Forestville | 2022-02-24 | Sonoma | 97 | 569 | 6352 | |
387961 | 387961 | 95425 | 95425: Cloverdale | 2022-02-24 | Sonoma | 97 | 1800 | 10586 | |
387960 | 387960 | 95421 | 95421: Cazadero | 2022-02-24 | Sonoma | 97 | 101 | 1681 | |
387959 | 387959 | 95412 | 95412: Annapolis | 2022-02-24 | Sonoma | 97 | 18 | 402 | |
387958 | 387958 | 95409 | 95409: Santa Rosa | 2022-02-24 | Sonoma | 97 | 2965 | 27312 | |
387957 | 387957 | 95407 | 95407: Santa Rosa | 2022-02-24 | Sonoma | 97 | 10881 | 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 );