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,211 rows where "date" is on date 2020-11-28 sorted by rowid descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▲ | id | name | date | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
963342 | 963342 | Wheatland | Wheatland | 2020-11-28 | Yuba | 115 | 107 | 3747 | |
963341 | 963341 | Plumas Lake | Plumas Lake | 2020-11-28 | Yuba | 115 | 203 | 7367 | |
963340 | 963340 | Other | Other | 2020-11-28 | Yuba | 115 | 133 | ||
963339 | 963339 | Olivehurst Linda | Olivehurst Linda | 2020-11-28 | Yuba | 115 | 666 | 32623 | |
963338 | 963338 | Marysville | Marysville | 2020-11-28 | Yuba | 115 | 882 | 12282 | |
963337 | 963337 | Woodland | Woodland | 2020-11-28 | Yolo | 113 | 1928 | 59044 | |
963336 | 963336 | Winters | Winters | 2020-11-28 | Yolo | 113 | 202 | 7132 | |
963335 | 963335 | West Sacramento | West Sacramento | 2020-11-28 | Yolo | 113 | 1385 | 52826 | |
963334 | 963334 | Unincorporated | Other | 2020-11-28 | Yolo | 113 | 537 | ||
963333 | 963333 | Davis | Davis | 2020-11-28 | Yolo | 113 | 574 | 67988 | |
963332 | 963332 | 93066 | 93066: Somis | 2020-11-28 | Ventura | 111 | 69 | 3481 | |
963331 | 963331 | 93065 | 93065: Simi Valley | 2020-11-28 | Ventura | 111 | 1546 | 74780 | |
963330 | 963330 | 93063 | 93063: Simi Valley (Santa Susana) | 2020-11-28 | Ventura | 111 | 1140 | 56563 | |
963329 | 963329 | 93060 | 93060: Santa Paula | 2020-11-28 | Ventura | 111 | 1212 | 34229 | |
963328 | 963328 | 93041 | 93041: Port Hueneme | 2020-11-28 | Ventura | 111 | 539 | 24129 | |
963327 | 963327 | 93040 | 93040: Piru | 2020-11-28 | Ventura | 111 | 114 | 1831 | |
963326 | 963326 | 93036 | 93036: Oxnard | 2020-11-28 | Ventura | 111 | 1199 | 48022 | |
963325 | 963325 | 93035 | 93035: Oxnard | 2020-11-28 | Ventura | 111 | 571 | 28321 | |
963324 | 963324 | 93033 | 93033: Oxnard | 2020-11-28 | Ventura | 111 | 3013 | 83319 | |
963323 | 963323 | 93030 | 93030: Oxnard | 2020-11-28 | Ventura | 111 | 2362 | 62016 | |
963322 | 963322 | 93023 | 93023: Ojai | 2020-11-28 | Ventura | 111 | 190 | 20656 | |
963321 | 963321 | 93022 | 93022: Oak View | 2020-11-28 | Ventura | 111 | 96 | 5550 | |
963320 | 963320 | 93021 | 93021: Moorpark | 2020-11-28 | Ventura | 111 | 711 | 38325 | |
963319 | 963319 | 93015 | 93015: Fillmore | 2020-11-28 | Ventura | 111 | 675 | 18832 | |
963318 | 963318 | 93012 | 93012: Camarillo/Santa Rosa Valley | 2020-11-28 | Ventura | 111 | 348 | 37622 | |
963317 | 963317 | 93010 | 93010: Camarillo | 2020-11-28 | Ventura | 111 | 635 | 44240 | |
963316 | 963316 | 93004 | 93004: Ventura | 2020-11-28 | Ventura | 111 | 420 | 30473 | |
963315 | 963315 | 93003 | 93003: Ventura | 2020-11-28 | Ventura | 111 | 941 | 51304 | |
963314 | 963314 | 93001 | 93001: Ventura | 2020-11-28 | Ventura | 111 | 606 | 33139 | |
963313 | 963313 | 91377 | 91377: Oak Park | 2020-11-28 | Ventura | 111 | 121 | 14226 | |
963312 | 963312 | 91362 | 91362: Thousand Oaks/Westlake | 2020-11-28 | Ventura | 111 | 427 | 36980 | |
963311 | 963311 | 91361 | 91361: Thousand Oaks/Lake Sherwood/Westlake | 2020-11-28 | Ventura | 111 | 204 | 20487 | |
963310 | 963310 | 91360 | 91360: Thousand Oaks | 2020-11-28 | Ventura | 111 | 639 | 42104 | |
963309 | 963309 | 91320 | 91320: Thousand Oaks/Newbury Park | 2020-11-28 | Ventura | 111 | 606 | 46191 | |
963308 | 963308 | 91307 | 91307: Bell Canyon | 2020-11-28 | Ventura | 111 | 6 | 2391 | |
963307 | 963307 | 93654 | Orosi: 93654 | 2020-11-28 | Tulare | 107 | 16 | 0 | |
963306 | 963306 | 93647 | Orosi: 93647 | 2020-11-28 | Tulare | 107 | 734 | 10896 | |
963305 | 963305 | 93646 | Traver: 93646 | 2020-11-28 | Tulare | 107 | 4 | 0 | |
963304 | 963304 | 93631 | Traver: 93631 | 2020-11-28 | Tulare | 107 | 107 | 16349 | |
963303 | 963303 | 93618 | Dinuba: 93618 | 2020-11-28 | Tulare | 107 | 2140 | 31230 | |
963302 | 963302 | 93615 | Cutler: 93615 | 2020-11-28 | Tulare | 107 | 415 | 6513 | |
963301 | 963301 | 93292 | Visalia: 93292 | 2020-11-28 | Tulare | 107 | 1415 | 41031 | |
963300 | 963300 | 93291 | Visalia: 93291 | 2020-11-28 | Tulare | 107 | 2432 | 57968 | |
963299 | 963299 | 93286 | Woodlake: 93286 | 2020-11-28 | Tulare | 107 | 351 | 9755 | |
963298 | 963298 | 93277 | Visalia: 93277 | 2020-11-28 | Tulare | 107 | 1737 | 53015 | |
963297 | 963297 | 93274 | Tulare: 93274 | 2020-11-28 | Tulare | 107 | 3371 | 73778 | |
963296 | 963296 | 93272 | Tipton: 93272 | 2020-11-28 | Tulare | 107 | 136 | 4454 | |
963295 | 963295 | 93271 | Three Rivers: 93271 | 2020-11-28 | Tulare | 107 | 0 | 2432 | |
963294 | 963294 | 93270 | Terra Bella: 93270 | 2020-11-28 | Tulare | 107 | 230 | 5542 | |
963293 | 963293 | 93267 | Strathmore: 93267 | 2020-11-28 | Tulare | 107 | 302 | 5542 | |
963292 | 963292 | 93265 | Springville: 93265 | 2020-11-28 | Tulare | 107 | 0 | 6347 | |
963291 | 963291 | 93262 | Mountain: 93262 | 2020-11-28 | Tulare | 107 | 0 | 3271 | |
963290 | 963290 | 93257 | Porterville: 93257 | 2020-11-28 | Tulare | 107 | 3664 | 76923 | |
963289 | 963289 | 93256 | Pixley: 93256 | 2020-11-28 | Tulare | 107 | 365 | 5939 | |
963288 | 963288 | 93247 | Lindsay: 93247 | 2020-11-28 | Tulare | 107 | 761 | 18522 | |
963287 | 963287 | 93235 | Ivanhoe: 93235 | 2020-11-28 | Tulare | 107 | 217 | 4198 | |
963286 | 963286 | 93227 | Goshen: 93227 | 2020-11-28 | Tulare | 107 | 47 | 3425 | |
963285 | 963285 | 93223 | Farmersville: 93223 | 2020-11-28 | Tulare | 107 | 611 | 10742 | |
963284 | 963284 | 93221 | Exeter: 93221 | 2020-11-28 | Tulare | 107 | 456 | 14328 | |
963283 | 963283 | 93219 | Earlimart: 93219 | 2020-11-28 | Tulare | 107 | 846 | 10167 | |
963282 | 963282 | 93215 | Richgrove: 93215 | 2020-11-28 | Tulare | 107 | 156 | 55269 | |
963281 | 963281 | 93212 | Corcoran, Angiola: 93212 | 2020-11-28 | Tulare | 107 | 7 | 0 | |
963280 | 963280 | 93201 | Alpaugh: 93201 | 2020-11-28 | Tulare | 107 | 28 | 1431 | |
963279 | 963279 | West County | West County | 2020-11-28 | Trinity | 105 | 10 | 2254 | |
963278 | 963278 | South County | South County | 2020-11-28 | Trinity | 105 | 44 | 4010 | |
963277 | 963277 | North County | North County | 2020-11-28 | Trinity | 105 | 1 | 699 | |
963276 | 963276 | East County | East County | 2020-11-28 | Trinity | 105 | 103 | 6738 | |
963275 | 963275 | Yuba City | Yuba City | 2020-11-28 | Sutter | 101 | 2687 | 66388 | |
963274 | 963274 | Other | Other | 2020-11-28 | Sutter | 101 | 199 | ||
963273 | 963273 | Live Oak | Live Oak | 2020-11-28 | Sutter | 101 | 334 | 8622 | |
963272 | 963272 | Waterford | Waterford | 2020-11-28 | Stanislaus | 99 | 282 | 8823 | |
963271 | 963271 | Unincorporated districts | Other | 2020-11-28 | Stanislaus | 99 | 3908 | ||
963270 | 963270 | Turlock | Turlock | 2020-11-28 | Stanislaus | 99 | 2939 | 72335 | |
963269 | 963269 | Riverbank | Riverbank | 2020-11-28 | Stanislaus | 99 | 997 | 24237 | |
963268 | 963268 | Patterson | Patterson | 2020-11-28 | Stanislaus | 99 | 1103 | 21783 | |
963267 | 963267 | Oakdale | Oakdale | 2020-11-28 | Stanislaus | 99 | 513 | 22599 | |
963266 | 963266 | Newman | Newman | 2020-11-28 | Stanislaus | 99 | 419 | 11119 | |
963265 | 963265 | Modesto | Modesto | 2020-11-28 | Stanislaus | 99 | 7703 | 211336 | |
963264 | 963264 | Hughson | Hughson | 2020-11-28 | Stanislaus | 99 | 202 | 7370 | |
963263 | 963263 | Ceres | Ceres | 2020-11-28 | Stanislaus | 99 | 2379 | 47975 | |
963262 | 963262 | 95497 | 95497: The Sea Ranch | 2020-11-28 | Sonoma | 97 | 10 | 10 or fewer | 1161 |
963261 | 963261 | 95492 | 95492: Windsor | 2020-11-28 | Sonoma | 97 | 555 | 29920 | |
963260 | 963260 | 95476 | 95476: Sonoma | 2020-11-28 | Sonoma | 97 | 802 | 36792 | |
963259 | 963259 | 95472 | 95472: Sebastopol | 2020-11-28 | Sonoma | 97 | 179 | 30762 | |
963258 | 963258 | 95465 | 95465: Occidental | 2020-11-28 | Sonoma | 97 | 10 | 10 or fewer | 2104 |
963257 | 963257 | 95462 | 95462: Monte Rio | 2020-11-28 | Sonoma | 97 | 10 | 10 or fewer | 1265 |
963256 | 963256 | 95452 | 95452: Kenwood | 2020-11-28 | Sonoma | 97 | 10 | 10 or fewer | 970 |
963255 | 963255 | 95450 | 95450: Jenner | 2020-11-28 | Sonoma | 97 | 10 | 10 or fewer | 298 |
963254 | 963254 | 95448 | 95448: Healdsburg | 2020-11-28 | Sonoma | 97 | 382 | 17482 | |
963253 | 963253 | 95446 | 95446: Guerneville | 2020-11-28 | Sonoma | 97 | 48 | 5100 | |
963252 | 963252 | 95444 | 95444: Graton | 2020-11-28 | Sonoma | 97 | 10 | 10 or fewer | 715 |
963251 | 963251 | 95442 | 95442: Glen Ellen | 2020-11-28 | Sonoma | 97 | 63 | 3136 | |
963250 | 963250 | 95441 | 95441: Geyserville | 2020-11-28 | Sonoma | 97 | 41 | 2053 | |
963249 | 963249 | 95439 | 95439: Fulton | 2020-11-28 | Sonoma | 97 | 20 | 774 | |
963248 | 963248 | 95436 | 95436: Forestville | 2020-11-28 | Sonoma | 97 | 69 | 6352 | |
963247 | 963247 | 95425 | 95425: Cloverdale | 2020-11-28 | Sonoma | 97 | 327 | 10586 | |
963246 | 963246 | 95421 | 95421: Cazadero | 2020-11-28 | Sonoma | 97 | 10 | 10 or fewer | 1681 |
963245 | 963245 | 95412 | 95412: Annapolis | 2020-11-28 | Sonoma | 97 | 0 | 402 | |
963244 | 963244 | 95409 | 95409: Santa Rosa | 2020-11-28 | Sonoma | 97 | 295 | 27312 | |
963243 | 963243 | 95407 | 95407: Santa Rosa | 2020-11-28 | Sonoma | 97 | 1959 | 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 );