latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
33,120 rows where fips = 97 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
562100 | 562100 | 94931 | 94931: Cotati | 2021-10-10 | Sonoma | 97 | 590 | 8601 | |
562101 | 562101 | 94951 | 94951: Penngrove | 2021-10-10 | Sonoma | 97 | 246 | 4571 | |
562102 | 562102 | 94952 | 94952: Petaluma | 2021-10-10 | Sonoma | 97 | 1958 | 36184 | |
562103 | 562103 | 94954 | 94954: Petaluma | 2021-10-10 | Sonoma | 97 | 2814 | 38414 | |
562104 | 562104 | 95401 | 95401: Santa Rosa | 2021-10-10 | Sonoma | 97 | 3672 | 38986 | |
562105 | 562105 | 95403 | 95403: Santa Rosa | 2021-10-10 | Sonoma | 97 | 4229 | 45355 | |
562106 | 562106 | 95404 | 95404: Santa Rosa | 2021-10-10 | Sonoma | 97 | 2952 | 40474 | |
562107 | 562107 | 95405 | 95405: Santa Rosa | 2021-10-10 | Sonoma | 97 | 1476 | 21448 | |
562108 | 562108 | 95407 | 95407: Santa Rosa | 2021-10-10 | Sonoma | 97 | 6028 | 42483 | |
562109 | 562109 | 95409 | 95409: Santa Rosa | 2021-10-10 | Sonoma | 97 | 1387 | 27312 | |
562110 | 562110 | 95412 | 95412: Annapolis | 2021-10-10 | Sonoma | 97 | 11 | 402 | |
562111 | 562111 | 95421 | 95421: Cazadero | 2021-10-10 | Sonoma | 97 | 50 | 1681 | |
562112 | 562112 | 95425 | 95425: Cloverdale | 2021-10-10 | Sonoma | 97 | 1063 | 10586 | |
562113 | 562113 | 95436 | 95436: Forestville | 2021-10-10 | Sonoma | 97 | 262 | 6352 | |
562114 | 562114 | 95439 | 95439: Fulton | 2021-10-10 | Sonoma | 97 | 63 | 774 | |
562115 | 562115 | 95441 | 95441: Geyserville | 2021-10-10 | Sonoma | 97 | 142 | 2053 | |
562116 | 562116 | 95442 | 95442: Glen Ellen | 2021-10-10 | Sonoma | 97 | 181 | 3136 | |
562117 | 562117 | 95444 | 95444: Graton | 2021-10-10 | Sonoma | 97 | 52 | 715 | |
562118 | 562118 | 95446 | 95446: Guerneville | 2021-10-10 | Sonoma | 97 | 271 | 5100 | |
562119 | 562119 | 95448 | 95448: Healdsburg | 2021-10-10 | Sonoma | 97 | 1232 | 17482 | |
562120 | 562120 | 95450 | 95450: Jenner | 2021-10-10 | Sonoma | 97 | 11 | 298 | |
562121 | 562121 | 95452 | 95452: Kenwood | 2021-10-10 | Sonoma | 97 | 37 | 970 | |
562122 | 562122 | 95462 | 95462: Monte Rio | 2021-10-10 | Sonoma | 97 | 52 | 1265 | |
562123 | 562123 | 95465 | 95465: Occidental | 2021-10-10 | Sonoma | 97 | 48 | 2104 | |
562124 | 562124 | 95472 | 95472: Sebastopol | 2021-10-10 | Sonoma | 97 | 1100 | 30762 | |
562125 | 562125 | 95476 | 95476: Sonoma | 2021-10-10 | Sonoma | 97 | 2838 | 36792 | |
562126 | 562126 | 95492 | 95492: Windsor | 2021-10-10 | Sonoma | 97 | 2361 | 29920 | |
562127 | 562127 | 95497 | 95497: The Sea Ranch | 2021-10-10 | Sonoma | 97 | 11 | 1161 | |
563372 | 563372 | 94515 | 94515: Calistoga | 2021-10-09 | Sonoma | 97 | 19 | 7436 | |
563373 | 563373 | 94922 | 94922: Bodega | 2021-10-09 | Sonoma | 97 | 29 | 603 | |
563374 | 563374 | 94923 | 94923: Bodega Bay | 2021-10-09 | Sonoma | 97 | 61 | 846 | |
563375 | 563375 | 94928 | 94928: Rohnert Park | 2021-10-09 | Sonoma | 97 | 3622 | 44103 | |
563376 | 563376 | 94931 | 94931: Cotati | 2021-10-09 | Sonoma | 97 | 590 | 8601 | |
563377 | 563377 | 94951 | 94951: Penngrove | 2021-10-09 | Sonoma | 97 | 246 | 4571 | |
563378 | 563378 | 94952 | 94952: Petaluma | 2021-10-09 | Sonoma | 97 | 1958 | 36184 | |
563379 | 563379 | 94954 | 94954: Petaluma | 2021-10-09 | Sonoma | 97 | 2814 | 38414 | |
563380 | 563380 | 95401 | 95401: Santa Rosa | 2021-10-09 | Sonoma | 97 | 3672 | 38986 | |
563381 | 563381 | 95403 | 95403: Santa Rosa | 2021-10-09 | Sonoma | 97 | 4229 | 45355 | |
563382 | 563382 | 95404 | 95404: Santa Rosa | 2021-10-09 | Sonoma | 97 | 2952 | 40474 | |
563383 | 563383 | 95405 | 95405: Santa Rosa | 2021-10-09 | Sonoma | 97 | 1476 | 21448 | |
563384 | 563384 | 95407 | 95407: Santa Rosa | 2021-10-09 | Sonoma | 97 | 6028 | 42483 | |
563385 | 563385 | 95409 | 95409: Santa Rosa | 2021-10-09 | Sonoma | 97 | 1387 | 27312 | |
563386 | 563386 | 95412 | 95412: Annapolis | 2021-10-09 | Sonoma | 97 | 11 | 402 | |
563387 | 563387 | 95421 | 95421: Cazadero | 2021-10-09 | Sonoma | 97 | 50 | 1681 | |
563388 | 563388 | 95425 | 95425: Cloverdale | 2021-10-09 | Sonoma | 97 | 1063 | 10586 | |
563389 | 563389 | 95436 | 95436: Forestville | 2021-10-09 | Sonoma | 97 | 262 | 6352 | |
563390 | 563390 | 95439 | 95439: Fulton | 2021-10-09 | Sonoma | 97 | 63 | 774 | |
563391 | 563391 | 95441 | 95441: Geyserville | 2021-10-09 | Sonoma | 97 | 142 | 2053 | |
563392 | 563392 | 95442 | 95442: Glen Ellen | 2021-10-09 | Sonoma | 97 | 181 | 3136 | |
563393 | 563393 | 95444 | 95444: Graton | 2021-10-09 | Sonoma | 97 | 52 | 715 | |
563394 | 563394 | 95446 | 95446: Guerneville | 2021-10-09 | Sonoma | 97 | 271 | 5100 | |
563395 | 563395 | 95448 | 95448: Healdsburg | 2021-10-09 | Sonoma | 97 | 1232 | 17482 | |
563396 | 563396 | 95450 | 95450: Jenner | 2021-10-09 | Sonoma | 97 | 11 | 298 | |
563397 | 563397 | 95452 | 95452: Kenwood | 2021-10-09 | Sonoma | 97 | 37 | 970 | |
563398 | 563398 | 95462 | 95462: Monte Rio | 2021-10-09 | Sonoma | 97 | 52 | 1265 | |
563399 | 563399 | 95465 | 95465: Occidental | 2021-10-09 | Sonoma | 97 | 48 | 2104 | |
563400 | 563400 | 95472 | 95472: Sebastopol | 2021-10-09 | Sonoma | 97 | 1100 | 30762 | |
563401 | 563401 | 95476 | 95476: Sonoma | 2021-10-09 | Sonoma | 97 | 2838 | 36792 | |
563402 | 563402 | 95492 | 95492: Windsor | 2021-10-09 | Sonoma | 97 | 2361 | 29920 | |
563403 | 563403 | 95497 | 95497: The Sea Ranch | 2021-10-09 | Sonoma | 97 | 11 | 1161 | |
564648 | 564648 | 94515 | 94515: Calistoga | 2021-10-08 | Sonoma | 97 | 19 | 7436 | |
564649 | 564649 | 94922 | 94922: Bodega | 2021-10-08 | Sonoma | 97 | 29 | 603 | |
564650 | 564650 | 94923 | 94923: Bodega Bay | 2021-10-08 | Sonoma | 97 | 61 | 846 | |
564651 | 564651 | 94928 | 94928: Rohnert Park | 2021-10-08 | Sonoma | 97 | 3617 | 44103 | |
564652 | 564652 | 94931 | 94931: Cotati | 2021-10-08 | Sonoma | 97 | 588 | 8601 | |
564653 | 564653 | 94951 | 94951: Penngrove | 2021-10-08 | Sonoma | 97 | 245 | 4571 | |
564654 | 564654 | 94952 | 94952: Petaluma | 2021-10-08 | Sonoma | 97 | 1956 | 36184 | |
564655 | 564655 | 94954 | 94954: Petaluma | 2021-10-08 | Sonoma | 97 | 2809 | 38414 | |
564656 | 564656 | 95401 | 95401: Santa Rosa | 2021-10-08 | Sonoma | 97 | 3668 | 38986 | |
564657 | 564657 | 95403 | 95403: Santa Rosa | 2021-10-08 | Sonoma | 97 | 4224 | 45355 | |
564658 | 564658 | 95404 | 95404: Santa Rosa | 2021-10-08 | Sonoma | 97 | 2949 | 40474 | |
564659 | 564659 | 95405 | 95405: Santa Rosa | 2021-10-08 | Sonoma | 97 | 1475 | 21448 | |
564660 | 564660 | 95407 | 95407: Santa Rosa | 2021-10-08 | Sonoma | 97 | 6018 | 42483 | |
564661 | 564661 | 95409 | 95409: Santa Rosa | 2021-10-08 | Sonoma | 97 | 1385 | 27312 | |
564662 | 564662 | 95412 | 95412: Annapolis | 2021-10-08 | Sonoma | 97 | 11 | 402 | |
564663 | 564663 | 95421 | 95421: Cazadero | 2021-10-08 | Sonoma | 97 | 50 | 1681 | |
564664 | 564664 | 95425 | 95425: Cloverdale | 2021-10-08 | Sonoma | 97 | 1061 | 10586 | |
564665 | 564665 | 95436 | 95436: Forestville | 2021-10-08 | Sonoma | 97 | 261 | 6352 | |
564666 | 564666 | 95439 | 95439: Fulton | 2021-10-08 | Sonoma | 97 | 63 | 774 | |
564667 | 564667 | 95441 | 95441: Geyserville | 2021-10-08 | Sonoma | 97 | 141 | 2053 | |
564668 | 564668 | 95442 | 95442: Glen Ellen | 2021-10-08 | Sonoma | 97 | 181 | 3136 | |
564669 | 564669 | 95444 | 95444: Graton | 2021-10-08 | Sonoma | 97 | 52 | 715 | |
564670 | 564670 | 95446 | 95446: Guerneville | 2021-10-08 | Sonoma | 97 | 271 | 5100 | |
564671 | 564671 | 95448 | 95448: Healdsburg | 2021-10-08 | Sonoma | 97 | 1229 | 17482 | |
564672 | 564672 | 95450 | 95450: Jenner | 2021-10-08 | Sonoma | 97 | 11 | 298 | |
564673 | 564673 | 95452 | 95452: Kenwood | 2021-10-08 | Sonoma | 97 | 37 | 970 | |
564674 | 564674 | 95462 | 95462: Monte Rio | 2021-10-08 | Sonoma | 97 | 52 | 1265 | |
564675 | 564675 | 95465 | 95465: Occidental | 2021-10-08 | Sonoma | 97 | 48 | 2104 | |
564676 | 564676 | 95472 | 95472: Sebastopol | 2021-10-08 | Sonoma | 97 | 1098 | 30762 | |
564677 | 564677 | 95476 | 95476: Sonoma | 2021-10-08 | Sonoma | 97 | 2834 | 36792 | |
564678 | 564678 | 95492 | 95492: Windsor | 2021-10-08 | Sonoma | 97 | 2356 | 29920 | |
564679 | 564679 | 95497 | 95497: The Sea Ranch | 2021-10-08 | Sonoma | 97 | 11 | 1161 | |
565924 | 565924 | 94515 | 94515: Calistoga | 2021-10-07 | Sonoma | 97 | 19 | 7436 | |
565925 | 565925 | 94922 | 94922: Bodega | 2021-10-07 | Sonoma | 97 | 29 | 603 | |
565926 | 565926 | 94923 | 94923: Bodega Bay | 2021-10-07 | Sonoma | 97 | 61 | 846 | |
565927 | 565927 | 94928 | 94928: Rohnert Park | 2021-10-07 | Sonoma | 97 | 3612 | 44103 | |
565928 | 565928 | 94931 | 94931: Cotati | 2021-10-07 | Sonoma | 97 | 588 | 8601 | |
565929 | 565929 | 94951 | 94951: Penngrove | 2021-10-07 | Sonoma | 97 | 245 | 4571 | |
565930 | 565930 | 94952 | 94952: Petaluma | 2021-10-07 | Sonoma | 97 | 1955 | 36184 | |
565931 | 565931 | 94954 | 94954: Petaluma | 2021-10-07 | Sonoma | 97 | 2809 | 38414 |
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] TEXT );