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-15 sorted by rowid descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▲ | id | name | date | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
904175 | 904175 | Wheatland | Wheatland | 2021-01-15 | Yuba | 115 | 278 | 3747 | |
904174 | 904174 | Plumas Lake | Plumas Lake | 2021-01-15 | Yuba | 115 | 515 | 7367 | |
904173 | 904173 | Other | Other | 2021-01-15 | Yuba | 115 | 288 | ||
904172 | 904172 | Olivehurst Linda | Olivehurst Linda | 2021-01-15 | Yuba | 115 | 1409 | 32623 | |
904171 | 904171 | Marysville | Marysville | 2021-01-15 | Yuba | 115 | 2328 | 12282 | |
904170 | 904170 | Woodland | Woodland | 2021-01-15 | Yolo | 113 | 4064 | 59044 | |
904169 | 904169 | Winters | Winters | 2021-01-15 | Yolo | 113 | 444 | 7132 | |
904168 | 904168 | West Sacramento | West Sacramento | 2021-01-15 | Yolo | 113 | 2802 | 52826 | |
904167 | 904167 | Unincorporated | Other | 2021-01-15 | Yolo | 113 | 1001 | ||
904166 | 904166 | Davis | Davis | 2021-01-15 | Yolo | 113 | 1436 | 67988 | |
904165 | 904165 | 93066 | 93066: Somis | 2021-01-15 | Ventura | 111 | 185 | 3481 | |
904164 | 904164 | 93065 | 93065: Simi Valley | 2021-01-15 | Ventura | 111 | 4680 | 74780 | |
904163 | 904163 | 93063 | 93063: Simi Valley (Santa Susana) | 2021-01-15 | Ventura | 111 | 3326 | 56563 | |
904162 | 904162 | 93060 | 93060: Santa Paula | 2021-01-15 | Ventura | 111 | 3878 | 34229 | |
904161 | 904161 | 93041 | 93041: Port Hueneme | 2021-01-15 | Ventura | 111 | 1715 | 24129 | |
904160 | 904160 | 93040 | 93040: Piru | 2021-01-15 | Ventura | 111 | 262 | 1831 | |
904159 | 904159 | 93036 | 93036: Oxnard | 2021-01-15 | Ventura | 111 | 4447 | 48022 | |
904158 | 904158 | 93035 | 93035: Oxnard | 2021-01-15 | Ventura | 111 | 1690 | 28321 | |
904157 | 904157 | 93033 | 93033: Oxnard | 2021-01-15 | Ventura | 111 | 9849 | 83319 | |
904156 | 904156 | 93030 | 93030: Oxnard | 2021-01-15 | Ventura | 111 | 7130 | 62016 | |
904155 | 904155 | 93023 | 93023: Ojai | 2021-01-15 | Ventura | 111 | 690 | 20656 | |
904154 | 904154 | 93022 | 93022: Oak View | 2021-01-15 | Ventura | 111 | 239 | 5550 | |
904153 | 904153 | 93021 | 93021: Moorpark | 2021-01-15 | Ventura | 111 | 2011 | 38325 | |
904152 | 904152 | 93015 | 93015: Fillmore | 2021-01-15 | Ventura | 111 | 1893 | 18832 | |
904151 | 904151 | 93012 | 93012: Camarillo/Santa Rosa Valley | 2021-01-15 | Ventura | 111 | 1257 | 37622 | |
904150 | 904150 | 93010 | 93010: Camarillo | 2021-01-15 | Ventura | 111 | 2200 | 44240 | |
904149 | 904149 | 93004 | 93004: Ventura | 2021-01-15 | Ventura | 111 | 1593 | 30473 | |
904148 | 904148 | 93003 | 93003: Ventura | 2021-01-15 | Ventura | 111 | 2861 | 51304 | |
904147 | 904147 | 93001 | 93001: Ventura | 2021-01-15 | Ventura | 111 | 1930 | 33139 | |
904146 | 904146 | 91377 | 91377: Oak Park | 2021-01-15 | Ventura | 111 | 298 | 14226 | |
904145 | 904145 | 91362 | 91362: Thousand Oaks/Westlake | 2021-01-15 | Ventura | 111 | 1187 | 36980 | |
904144 | 904144 | 91361 | 91361: Thousand Oaks/Lake Sherwood/Westlake | 2021-01-15 | Ventura | 111 | 447 | 20487 | |
904143 | 904143 | 91360 | 91360: Thousand Oaks | 2021-01-15 | Ventura | 111 | 1877 | 42104 | |
904142 | 904142 | 91320 | 91320: Thousand Oaks/Newbury Park | 2021-01-15 | Ventura | 111 | 1959 | 46191 | |
904141 | 904141 | 91307 | 91307: Bell Canyon | 2021-01-15 | Ventura | 111 | 7 | 2391 | |
904140 | 904140 | 93654 | Orosi: 93654 | 2021-01-15 | Tulare | 107 | 48 | 0 | |
904139 | 904139 | 93647 | Orosi: 93647 | 2021-01-15 | Tulare | 107 | 1200 | 10896 | |
904138 | 904138 | 93646 | Traver: 93646 | 2021-01-15 | Tulare | 107 | 17 | 0 | |
904137 | 904137 | 93631 | Traver: 93631 | 2021-01-15 | Tulare | 107 | 203 | 16349 | |
904136 | 904136 | 93618 | Dinuba: 93618 | 2021-01-15 | Tulare | 107 | 3531 | 31230 | |
904135 | 904135 | 93615 | Cutler: 93615 | 2021-01-15 | Tulare | 107 | 635 | 6513 | |
904134 | 904134 | 93292 | Visalia: 93292 | 2021-01-15 | Tulare | 107 | 2900 | 41031 | |
904133 | 904133 | 93291 | Visalia: 93291 | 2021-01-15 | Tulare | 107 | 4444 | 57968 | |
904132 | 904132 | 93286 | Woodlake: 93286 | 2021-01-15 | Tulare | 107 | 735 | 9755 | |
904131 | 904131 | 93277 | Visalia: 93277 | 2021-01-15 | Tulare | 107 | 3497 | 53015 | |
904130 | 904130 | 93274 | Tulare: 93274 | 2021-01-15 | Tulare | 107 | 7117 | 73778 | |
904129 | 904129 | 93272 | Tipton: 93272 | 2021-01-15 | Tulare | 107 | 292 | 4454 | |
904128 | 904128 | 93271 | Three Rivers: 93271 | 2021-01-15 | Tulare | 107 | 42 | 2432 | |
904127 | 904127 | 93270 | Terra Bella: 93270 | 2021-01-15 | Tulare | 107 | 548 | 5542 | |
904126 | 904126 | 93267 | Strathmore: 93267 | 2021-01-15 | Tulare | 107 | 527 | 5542 | |
904125 | 904125 | 93265 | Springville: 93265 | 2021-01-15 | Tulare | 107 | 99 | 6347 | |
904124 | 904124 | 93262 | Mountain: 93262 | 2021-01-15 | Tulare | 107 | 35 | 3271 | |
904123 | 904123 | 93257 | Porterville: 93257 | 2021-01-15 | Tulare | 107 | 7865 | 76923 | |
904122 | 904122 | 93256 | Pixley: 93256 | 2021-01-15 | Tulare | 107 | 657 | 5939 | |
904121 | 904121 | 93247 | Lindsay: 93247 | 2021-01-15 | Tulare | 107 | 1499 | 18522 | |
904120 | 904120 | 93235 | Ivanhoe: 93235 | 2021-01-15 | Tulare | 107 | 418 | 4198 | |
904119 | 904119 | 93227 | Goshen: 93227 | 2021-01-15 | Tulare | 107 | 79 | 3425 | |
904118 | 904118 | 93223 | Farmersville: 93223 | 2021-01-15 | Tulare | 107 | 995 | 10742 | |
904117 | 904117 | 93221 | Exeter: 93221 | 2021-01-15 | Tulare | 107 | 867 | 14328 | |
904116 | 904116 | 93219 | Earlimart: 93219 | 2021-01-15 | Tulare | 107 | 1224 | 10167 | |
904115 | 904115 | 93215 | Richgrove: 93215 | 2021-01-15 | Tulare | 107 | 258 | 55269 | |
904114 | 904114 | 93212 | Corcoran, Angiola: 93212 | 2021-01-15 | Tulare | 107 | 9 | 0 | |
904113 | 904113 | 93201 | Alpaugh: 93201 | 2021-01-15 | Tulare | 107 | 64 | 1431 | |
904112 | 904112 | West County | West County | 2021-01-15 | Trinity | 105 | 25 | 2254 | |
904111 | 904111 | South County | South County | 2021-01-15 | Trinity | 105 | 65 | 4010 | |
904110 | 904110 | North County | North County | 2021-01-15 | Trinity | 105 | 5 | 699 | |
904109 | 904109 | East County | East County | 2021-01-15 | Trinity | 105 | 207 | 6738 | |
904108 | 904108 | Yuba City | Yuba City | 2021-01-15 | Sutter | 101 | 6179 | 66388 | |
904107 | 904107 | Other | Other | 2021-01-15 | Sutter | 101 | 426 | ||
904106 | 904106 | Live Oak | Live Oak | 2021-01-15 | Sutter | 101 | 879 | 8622 | |
904105 | 904105 | Waterford | Waterford | 2021-01-15 | Stanislaus | 99 | 486 | 8823 | |
904104 | 904104 | Unincorporated districts | Other | 2021-01-15 | Stanislaus | 99 | 7037 | ||
904103 | 904103 | Turlock | Turlock | 2021-01-15 | Stanislaus | 99 | 5525 | 72335 | |
904102 | 904102 | Riverbank | Riverbank | 2021-01-15 | Stanislaus | 99 | 1860 | 24237 | |
904101 | 904101 | Patterson | Patterson | 2021-01-15 | Stanislaus | 99 | 2057 | 21783 | |
904100 | 904100 | Oakdale | Oakdale | 2021-01-15 | Stanislaus | 99 | 1268 | 22599 | |
904099 | 904099 | Newman | Newman | 2021-01-15 | Stanislaus | 99 | 929 | 11119 | |
904098 | 904098 | Modesto | Modesto | 2021-01-15 | Stanislaus | 99 | 14962 | 211336 | |
904097 | 904097 | Hughson | Hughson | 2021-01-15 | Stanislaus | 99 | 426 | 7370 | |
904096 | 904096 | Ceres | Ceres | 2021-01-15 | Stanislaus | 99 | 4316 | 47975 | |
904095 | 904095 | 95497 | 95497: The Sea Ranch | 2021-01-15 | Sonoma | 97 | 10 | 10 or fewer | 1161 |
904094 | 904094 | 95492 | 95492: Windsor | 2021-01-15 | Sonoma | 97 | 1247 | 29920 | |
904093 | 904093 | 95476 | 95476: Sonoma | 2021-01-15 | Sonoma | 97 | 1724 | 36792 | |
904092 | 904092 | 95472 | 95472: Sebastopol | 2021-01-15 | Sonoma | 97 | 465 | 30762 | |
904091 | 904091 | 95465 | 95465: Occidental | 2021-01-15 | Sonoma | 97 | 14 | 2104 | |
904090 | 904090 | 95462 | 95462: Monte Rio | 2021-01-15 | Sonoma | 97 | 18 | 1265 | |
904089 | 904089 | 95452 | 95452: Kenwood | 2021-01-15 | Sonoma | 97 | 16 | 970 | |
904088 | 904088 | 95450 | 95450: Jenner | 2021-01-15 | Sonoma | 97 | 10 | 10 or fewer | 298 |
904087 | 904087 | 95448 | 95448: Healdsburg | 2021-01-15 | Sonoma | 97 | 738 | 17482 | |
904086 | 904086 | 95446 | 95446: Guerneville | 2021-01-15 | Sonoma | 97 | 103 | 5100 | |
904085 | 904085 | 95444 | 95444: Graton | 2021-01-15 | Sonoma | 97 | 20 | 715 | |
904084 | 904084 | 95442 | 95442: Glen Ellen | 2021-01-15 | Sonoma | 97 | 113 | 3136 | |
904083 | 904083 | 95441 | 95441: Geyserville | 2021-01-15 | Sonoma | 97 | 70 | 2053 | |
904082 | 904082 | 95439 | 95439: Fulton | 2021-01-15 | Sonoma | 97 | 37 | 774 | |
904081 | 904081 | 95436 | 95436: Forestville | 2021-01-15 | Sonoma | 97 | 121 | 6352 | |
904080 | 904080 | 95425 | 95425: Cloverdale | 2021-01-15 | Sonoma | 97 | 581 | 10586 | |
904079 | 904079 | 95421 | 95421: Cazadero | 2021-01-15 | Sonoma | 97 | 15 | 1681 | |
904078 | 904078 | 95412 | 95412: Annapolis | 2021-01-15 | Sonoma | 97 | 10 | 10 or fewer | 402 |
904077 | 904077 | 95409 | 95409: Santa Rosa | 2021-01-15 | Sonoma | 97 | 686 | 27312 | |
904076 | 904076 | 95407 | 95407: Santa Rosa | 2021-01-15 | Sonoma | 97 | 3753 | 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 );