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-12-03 sorted by rowid descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▲ | id | name | date | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
493303 | 493303 | Wheatland | Wheatland | 2021-12-03 | Yuba | 115 | 630 | 3747 | |
493302 | 493302 | Plumas Lake | Plumas Lake | 2021-12-03 | Yuba | 115 | 1305 | 7367 | |
493301 | 493301 | Other | Other | 2021-12-03 | Yuba | 115 | 953 | ||
493300 | 493300 | Olivehurst Linda | Olivehurst Linda | 2021-12-03 | Yuba | 115 | 3176 | 32623 | |
493299 | 493299 | Marysville | Marysville | 2021-12-03 | Yuba | 115 | 5150 | 12282 | |
493298 | 493298 | Woodland | Woodland | 2021-12-03 | Yolo | 113 | 7741 | 59044 | |
493297 | 493297 | Winters | Winters | 2021-12-03 | Yolo | 113 | 747 | 7132 | |
493296 | 493296 | West Sacramento | West Sacramento | 2021-12-03 | Yolo | 113 | 6170 | 52826 | |
493295 | 493295 | Unincorporated | Other | 2021-12-03 | Yolo | 113 | 2391 | ||
493294 | 493294 | Davis | Davis | 2021-12-03 | Yolo | 113 | 3195 | 67988 | |
493293 | 493293 | 93066 | 93066: Somis | 2021-12-03 | Ventura | 111 | 315 | 3481 | |
493292 | 493292 | 93065 | 93065: Simi Valley | 2021-12-03 | Ventura | 111 | 8182 | 74780 | |
493291 | 493291 | 93063 | 93063: Simi Valley (Santa Susana) | 2021-12-03 | Ventura | 111 | 5923 | 56563 | |
493290 | 493290 | 93060 | 93060: Santa Paula | 2021-12-03 | Ventura | 111 | 6331 | 34229 | |
493289 | 493289 | 93041 | 93041: Port Hueneme | 2021-12-03 | Ventura | 111 | 2958 | 24129 | |
493288 | 493288 | 93040 | 93040: Piru | 2021-12-03 | Ventura | 111 | 435 | 1831 | |
493287 | 493287 | 93036 | 93036: Oxnard | 2021-12-03 | Ventura | 111 | 7314 | 48022 | |
493286 | 493286 | 93035 | 93035: Oxnard | 2021-12-03 | Ventura | 111 | 3097 | 28321 | |
493285 | 493285 | 93033 | 93033: Oxnard | 2021-12-03 | Ventura | 111 | 15535 | 83319 | |
493284 | 493284 | 93030 | 93030: Oxnard | 2021-12-03 | Ventura | 111 | 11175 | 62016 | |
493283 | 493283 | 93023 | 93023: Ojai | 2021-12-03 | Ventura | 111 | 1321 | 20656 | |
493282 | 493282 | 93022 | 93022: Oak View | 2021-12-03 | Ventura | 111 | 495 | 5550 | |
493281 | 493281 | 93021 | 93021: Moorpark | 2021-12-03 | Ventura | 111 | 3620 | 38325 | |
493280 | 493280 | 93015 | 93015: Fillmore | 2021-12-03 | Ventura | 111 | 3274 | 18832 | |
493279 | 493279 | 93012 | 93012: Camarillo/Santa Rosa Valley | 2021-12-03 | Ventura | 111 | 2345 | 37622 | |
493278 | 493278 | 93010 | 93010: Camarillo | 2021-12-03 | Ventura | 111 | 4198 | 44240 | |
493277 | 493277 | 93004 | 93004: Ventura | 2021-12-03 | Ventura | 111 | 3028 | 30473 | |
493276 | 493276 | 93003 | 93003: Ventura | 2021-12-03 | Ventura | 111 | 5216 | 51304 | |
493275 | 493275 | 93001 | 93001: Ventura | 2021-12-03 | Ventura | 111 | 3738 | 33139 | |
493274 | 493274 | 91377 | 91377: Oak Park | 2021-12-03 | Ventura | 111 | 668 | 14226 | |
493273 | 493273 | 91362 | 91362: Thousand Oaks/Westlake | 2021-12-03 | Ventura | 111 | 2400 | 36980 | |
493272 | 493272 | 91361 | 91361: Thousand Oaks/Lake Sherwood/Westlake | 2021-12-03 | Ventura | 111 | 891 | 20487 | |
493271 | 493271 | 91360 | 91360: Thousand Oaks | 2021-12-03 | Ventura | 111 | 3667 | 42104 | |
493270 | 493270 | 91320 | 91320: Thousand Oaks/Newbury Park | 2021-12-03 | Ventura | 111 | 3621 | 46191 | |
493269 | 493269 | 91307 | 91307: Bell Canyon | 2021-12-03 | Ventura | 111 | 33 | 2391 | |
493268 | 493268 | 93654 | Orosi: 93654 | 2021-12-03 | Tulare | 107 | 124 | 0 | |
493267 | 493267 | 93647 | Orosi: 93647 | 2021-12-03 | Tulare | 107 | 1965 | 10896 | |
493266 | 493266 | 93646 | Traver: 93646 | 2021-12-03 | Tulare | 107 | 40 | 0 | |
493265 | 493265 | 93631 | Traver: 93631 | 2021-12-03 | Tulare | 107 | 375 | 16349 | |
493264 | 493264 | 93618 | Dinuba: 93618 | 2021-12-03 | Tulare | 107 | 5920 | 31230 | |
493263 | 493263 | 93615 | Cutler: 93615 | 2021-12-03 | Tulare | 107 | 1004 | 6513 | |
493262 | 493262 | 93292 | Visalia: 93292 | 2021-12-03 | Tulare | 107 | 4910 | 41031 | |
493261 | 493261 | 93291 | Visalia: 93291 | 2021-12-03 | Tulare | 107 | 7572 | 57968 | |
493260 | 493260 | 93286 | Woodlake: 93286 | 2021-12-03 | Tulare | 107 | 1272 | 9755 | |
493259 | 493259 | 93277 | Visalia: 93277 | 2021-12-03 | Tulare | 107 | 6049 | 53015 | |
493258 | 493258 | 93274 | Tulare: 93274 | 2021-12-03 | Tulare | 107 | 12323 | 73778 | |
493257 | 493257 | 93272 | Tipton: 93272 | 2021-12-03 | Tulare | 107 | 557 | 4454 | |
493256 | 493256 | 93271 | Three Rivers: 93271 | 2021-12-03 | Tulare | 107 | 97 | 2432 | |
493255 | 493255 | 93270 | Terra Bella: 93270 | 2021-12-03 | Tulare | 107 | 1046 | 5542 | |
493254 | 493254 | 93267 | Strathmore: 93267 | 2021-12-03 | Tulare | 107 | 939 | 5542 | |
493253 | 493253 | 93265 | Springville: 93265 | 2021-12-03 | Tulare | 107 | 338 | 6347 | |
493252 | 493252 | 93262 | Mountain: 93262 | 2021-12-03 | Tulare | 107 | 65 | 3271 | |
493251 | 493251 | 93257 | Porterville: 93257 | 2021-12-03 | Tulare | 107 | 14485 | 76923 | |
493250 | 493250 | 93256 | Pixley: 93256 | 2021-12-03 | Tulare | 107 | 1130 | 5939 | |
493249 | 493249 | 93247 | Lindsay: 93247 | 2021-12-03 | Tulare | 107 | 2549 | 18522 | |
493248 | 493248 | 93235 | Ivanhoe: 93235 | 2021-12-03 | Tulare | 107 | 682 | 4198 | |
493247 | 493247 | 93227 | Goshen: 93227 | 2021-12-03 | Tulare | 107 | 121 | 3425 | |
493246 | 493246 | 93223 | Farmersville: 93223 | 2021-12-03 | Tulare | 107 | 1659 | 10742 | |
493245 | 493245 | 93221 | Exeter: 93221 | 2021-12-03 | Tulare | 107 | 1523 | 14328 | |
493244 | 493244 | 93219 | Earlimart: 93219 | 2021-12-03 | Tulare | 107 | 1776 | 10167 | |
493243 | 493243 | 93215 | Richgrove: 93215 | 2021-12-03 | Tulare | 107 | 477 | 55269 | |
493242 | 493242 | 93212 | Corcoran, Angiola: 93212 | 2021-12-03 | Tulare | 107 | 21 | 0 | |
493241 | 493241 | 93201 | Alpaugh: 93201 | 2021-12-03 | Tulare | 107 | 178 | 1431 | |
493240 | 493240 | West County | West County | 2021-12-03 | Trinity | 105 | 72 | 2254 | |
493239 | 493239 | South County | South County | 2021-12-03 | Trinity | 105 | 199 | 4010 | |
493238 | 493238 | North County | North County | 2021-12-03 | Trinity | 105 | 27 | 699 | |
493237 | 493237 | East County | East County | 2021-12-03 | Trinity | 105 | 505 | 6738 | |
493236 | 493236 | Yuba City | Yuba City | 2021-12-03 | Sutter | 101 | 12048 | 66388 | |
493235 | 493235 | Other | Other | 2021-12-03 | Sutter | 101 | 969 | ||
493234 | 493234 | Live Oak | Live Oak | 2021-12-03 | Sutter | 101 | 1595 | 8622 | |
493233 | 493233 | Waterford | Waterford | 2021-12-03 | Stanislaus | 99 | 1143 | 8823 | |
493232 | 493232 | Unincorporated districts | Other | 2021-12-03 | Stanislaus | 99 | 13970 | ||
493231 | 493231 | Turlock | Turlock | 2021-12-03 | Stanislaus | 99 | 10572 | 72335 | |
493230 | 493230 | Riverbank | Riverbank | 2021-12-03 | Stanislaus | 99 | 3793 | 24237 | |
493229 | 493229 | Patterson | Patterson | 2021-12-03 | Stanislaus | 99 | 3445 | 21783 | |
493228 | 493228 | Oakdale | Oakdale | 2021-12-03 | Stanislaus | 99 | 2899 | 22599 | |
493227 | 493227 | Newman | Newman | 2021-12-03 | Stanislaus | 99 | 1650 | 11119 | |
493226 | 493226 | Modesto | Modesto | 2021-12-03 | Stanislaus | 99 | 30982 | 211336 | |
493225 | 493225 | Hughson | Hughson | 2021-12-03 | Stanislaus | 99 | 936 | 7370 | |
493224 | 493224 | Ceres | Ceres | 2021-12-03 | Stanislaus | 99 | 8220 | 47975 | |
493223 | 493223 | 95497 | 95497: The Sea Ranch | 2021-12-03 | Sonoma | 97 | 15 | 1161 | |
493222 | 493222 | 95492 | 95492: Windsor | 2021-12-03 | Sonoma | 97 | 2553 | 29920 | |
493221 | 493221 | 95476 | 95476: Sonoma | 2021-12-03 | Sonoma | 97 | 3068 | 36792 | |
493220 | 493220 | 95472 | 95472: Sebastopol | 2021-12-03 | Sonoma | 97 | 1266 | 30762 | |
493219 | 493219 | 95465 | 95465: Occidental | 2021-12-03 | Sonoma | 97 | 56 | 2104 | |
493218 | 493218 | 95462 | 95462: Monte Rio | 2021-12-03 | Sonoma | 97 | 58 | 1265 | |
493217 | 493217 | 95452 | 95452: Kenwood | 2021-12-03 | Sonoma | 97 | 42 | 970 | |
493216 | 493216 | 95450 | 95450: Jenner | 2021-12-03 | Sonoma | 97 | 12 | 298 | |
493215 | 493215 | 95448 | 95448: Healdsburg | 2021-12-03 | Sonoma | 97 | 1353 | 17482 | |
493214 | 493214 | 95446 | 95446: Guerneville | 2021-12-03 | Sonoma | 97 | 302 | 5100 | |
493213 | 493213 | 95444 | 95444: Graton | 2021-12-03 | Sonoma | 97 | 54 | 715 | |
493212 | 493212 | 95442 | 95442: Glen Ellen | 2021-12-03 | Sonoma | 97 | 204 | 3136 | |
493211 | 493211 | 95441 | 95441: Geyserville | 2021-12-03 | Sonoma | 97 | 151 | 2053 | |
493210 | 493210 | 95439 | 95439: Fulton | 2021-12-03 | Sonoma | 97 | 73 | 774 | |
493209 | 493209 | 95436 | 95436: Forestville | 2021-12-03 | Sonoma | 97 | 281 | 6352 | |
493208 | 493208 | 95425 | 95425: Cloverdale | 2021-12-03 | Sonoma | 97 | 1119 | 10586 | |
493207 | 493207 | 95421 | 95421: Cazadero | 2021-12-03 | Sonoma | 97 | 62 | 1681 | |
493206 | 493206 | 95412 | 95412: Annapolis | 2021-12-03 | Sonoma | 97 | 11 | 402 | |
493205 | 493205 | 95409 | 95409: Santa Rosa | 2021-12-03 | Sonoma | 97 | 1505 | 27312 | |
493204 | 493204 | 95407 | 95407: Santa Rosa | 2021-12-03 | Sonoma | 97 | 6275 | 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 );