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 county = "Sonoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
799432 | 799432 | 94515 | 94515: Calistoga | 2021-04-07 | Sonoma | 97 | 11 | 7436 | |
799433 | 799433 | 94922 | 94922: Bodega | 2021-04-07 | Sonoma | 97 | 15 | 603 | |
799434 | 799434 | 94923 | 94923: Bodega Bay | 2021-04-07 | Sonoma | 97 | 51 | 846 | |
799435 | 799435 | 94928 | 94928: Rohnert Park | 2021-04-07 | Sonoma | 97 | 2586 | 44103 | |
799436 | 799436 | 94931 | 94931: Cotati | 2021-04-07 | Sonoma | 97 | 380 | 8601 | |
799437 | 799437 | 94951 | 94951: Penngrove | 2021-04-07 | Sonoma | 97 | 173 | 4571 | |
799438 | 799438 | 94952 | 94952: Petaluma | 2021-04-07 | Sonoma | 97 | 1463 | 36184 | |
799439 | 799439 | 94954 | 94954: Petaluma | 2021-04-07 | Sonoma | 97 | 2051 | 38414 | |
799440 | 799440 | 95401 | 95401: Santa Rosa | 2021-04-07 | Sonoma | 97 | 2843 | 38986 | |
799441 | 799441 | 95403 | 95403: Santa Rosa | 2021-04-07 | Sonoma | 97 | 3033 | 45355 | |
799442 | 799442 | 95404 | 95404: Santa Rosa | 2021-04-07 | Sonoma | 97 | 2156 | 40474 | |
799443 | 799443 | 95405 | 95405: Santa Rosa | 2021-04-07 | Sonoma | 97 | 1015 | 21448 | |
799444 | 799444 | 95407 | 95407: Santa Rosa | 2021-04-07 | Sonoma | 97 | 4780 | 42483 | |
799445 | 799445 | 95409 | 95409: Santa Rosa | 2021-04-07 | Sonoma | 97 | 956 | 27312 | |
799446 | 799446 | 95412 | 95412: Annapolis | 2021-04-07 | Sonoma | 97 | 10 | 10 or fewer | 402 |
799447 | 799447 | 95421 | 95421: Cazadero | 2021-04-07 | Sonoma | 97 | 34 | 1681 | |
799448 | 799448 | 95425 | 95425: Cloverdale | 2021-04-07 | Sonoma | 97 | 736 | 10586 | |
799449 | 799449 | 95436 | 95436: Forestville | 2021-04-07 | Sonoma | 97 | 166 | 6352 | |
799450 | 799450 | 95439 | 95439: Fulton | 2021-04-07 | Sonoma | 97 | 47 | 774 | |
799451 | 799451 | 95441 | 95441: Geyserville | 2021-04-07 | Sonoma | 97 | 93 | 2053 | |
799452 | 799452 | 95442 | 95442: Glen Ellen | 2021-04-07 | Sonoma | 97 | 137 | 3136 | |
799453 | 799453 | 95444 | 95444: Graton | 2021-04-07 | Sonoma | 97 | 28 | 715 | |
799454 | 799454 | 95446 | 95446: Guerneville | 2021-04-07 | Sonoma | 97 | 137 | 5100 | |
799455 | 799455 | 95448 | 95448: Healdsburg | 2021-04-07 | Sonoma | 97 | 926 | 17482 | |
799456 | 799456 | 95450 | 95450: Jenner | 2021-04-07 | Sonoma | 97 | 10 | 10 or fewer | 298 |
799457 | 799457 | 95452 | 95452: Kenwood | 2021-04-07 | Sonoma | 97 | 19 | 970 | |
799458 | 799458 | 95462 | 95462: Monte Rio | 2021-04-07 | Sonoma | 97 | 21 | 1265 | |
799459 | 799459 | 95465 | 95465: Occidental | 2021-04-07 | Sonoma | 97 | 22 | 2104 | |
799460 | 799460 | 95472 | 95472: Sebastopol | 2021-04-07 | Sonoma | 97 | 643 | 30762 | |
799461 | 799461 | 95476 | 95476: Sonoma | 2021-04-07 | Sonoma | 97 | 2290 | 36792 | |
799462 | 799462 | 95492 | 95492: Windsor | 2021-04-07 | Sonoma | 97 | 1639 | 29920 | |
799463 | 799463 | 95497 | 95497: The Sea Ranch | 2021-04-07 | Sonoma | 97 | 10 | 10 or fewer | 1161 |
800708 | 800708 | 94515 | 94515: Calistoga | 2021-04-06 | Sonoma | 97 | 12 | 7436 | |
800709 | 800709 | 94922 | 94922: Bodega | 2021-04-06 | Sonoma | 97 | 15 | 603 | |
800710 | 800710 | 94923 | 94923: Bodega Bay | 2021-04-06 | Sonoma | 97 | 51 | 846 | |
800711 | 800711 | 94928 | 94928: Rohnert Park | 2021-04-06 | Sonoma | 97 | 2578 | 44103 | |
800712 | 800712 | 94931 | 94931: Cotati | 2021-04-06 | Sonoma | 97 | 379 | 8601 | |
800713 | 800713 | 94951 | 94951: Penngrove | 2021-04-06 | Sonoma | 97 | 171 | 4571 | |
800714 | 800714 | 94952 | 94952: Petaluma | 2021-04-06 | Sonoma | 97 | 1458 | 36184 | |
800715 | 800715 | 94954 | 94954: Petaluma | 2021-04-06 | Sonoma | 97 | 2040 | 38414 | |
800716 | 800716 | 95401 | 95401: Santa Rosa | 2021-04-06 | Sonoma | 97 | 2837 | 38986 | |
800717 | 800717 | 95403 | 95403: Santa Rosa | 2021-04-06 | Sonoma | 97 | 3030 | 45355 | |
800718 | 800718 | 95404 | 95404: Santa Rosa | 2021-04-06 | Sonoma | 97 | 2148 | 40474 | |
800719 | 800719 | 95405 | 95405: Santa Rosa | 2021-04-06 | Sonoma | 97 | 1011 | 21448 | |
800720 | 800720 | 95407 | 95407: Santa Rosa | 2021-04-06 | Sonoma | 97 | 4769 | 42483 | |
800721 | 800721 | 95409 | 95409: Santa Rosa | 2021-04-06 | Sonoma | 97 | 952 | 27312 | |
800722 | 800722 | 95412 | 95412: Annapolis | 2021-04-06 | Sonoma | 97 | 10 | 10 or fewer | 402 |
800723 | 800723 | 95421 | 95421: Cazadero | 2021-04-06 | Sonoma | 97 | 34 | 1681 | |
800724 | 800724 | 95425 | 95425: Cloverdale | 2021-04-06 | Sonoma | 97 | 735 | 10586 | |
800725 | 800725 | 95436 | 95436: Forestville | 2021-04-06 | Sonoma | 97 | 165 | 6352 | |
800726 | 800726 | 95439 | 95439: Fulton | 2021-04-06 | Sonoma | 97 | 47 | 774 | |
800727 | 800727 | 95441 | 95441: Geyserville | 2021-04-06 | Sonoma | 97 | 92 | 2053 | |
800728 | 800728 | 95442 | 95442: Glen Ellen | 2021-04-06 | Sonoma | 97 | 136 | 3136 | |
800729 | 800729 | 95444 | 95444: Graton | 2021-04-06 | Sonoma | 97 | 28 | 715 | |
800730 | 800730 | 95446 | 95446: Guerneville | 2021-04-06 | Sonoma | 97 | 137 | 5100 | |
800731 | 800731 | 95448 | 95448: Healdsburg | 2021-04-06 | Sonoma | 97 | 924 | 17482 | |
800732 | 800732 | 95450 | 95450: Jenner | 2021-04-06 | Sonoma | 97 | 10 | 10 or fewer | 298 |
800733 | 800733 | 95452 | 95452: Kenwood | 2021-04-06 | Sonoma | 97 | 19 | 970 | |
800734 | 800734 | 95462 | 95462: Monte Rio | 2021-04-06 | Sonoma | 97 | 21 | 1265 | |
800735 | 800735 | 95465 | 95465: Occidental | 2021-04-06 | Sonoma | 97 | 22 | 2104 | |
800736 | 800736 | 95472 | 95472: Sebastopol | 2021-04-06 | Sonoma | 97 | 639 | 30762 | |
800737 | 800737 | 95476 | 95476: Sonoma | 2021-04-06 | Sonoma | 97 | 2288 | 36792 | |
800738 | 800738 | 95492 | 95492: Windsor | 2021-04-06 | Sonoma | 97 | 1632 | 29920 | |
800739 | 800739 | 95497 | 95497: The Sea Ranch | 2021-04-06 | Sonoma | 97 | 10 | 10 or fewer | 1161 |
801984 | 801984 | 94515 | 94515: Calistoga | 2021-04-05 | Sonoma | 97 | 12 | 7436 | |
801985 | 801985 | 94922 | 94922: Bodega | 2021-04-05 | Sonoma | 97 | 15 | 603 | |
801986 | 801986 | 94923 | 94923: Bodega Bay | 2021-04-05 | Sonoma | 97 | 51 | 846 | |
801987 | 801987 | 94928 | 94928: Rohnert Park | 2021-04-05 | Sonoma | 97 | 2578 | 44103 | |
801988 | 801988 | 94931 | 94931: Cotati | 2021-04-05 | Sonoma | 97 | 379 | 8601 | |
801989 | 801989 | 94951 | 94951: Penngrove | 2021-04-05 | Sonoma | 97 | 171 | 4571 | |
801990 | 801990 | 94952 | 94952: Petaluma | 2021-04-05 | Sonoma | 97 | 1458 | 36184 | |
801991 | 801991 | 94954 | 94954: Petaluma | 2021-04-05 | Sonoma | 97 | 2040 | 38414 | |
801992 | 801992 | 95401 | 95401: Santa Rosa | 2021-04-05 | Sonoma | 97 | 2837 | 38986 | |
801993 | 801993 | 95403 | 95403: Santa Rosa | 2021-04-05 | Sonoma | 97 | 3030 | 45355 | |
801994 | 801994 | 95404 | 95404: Santa Rosa | 2021-04-05 | Sonoma | 97 | 2148 | 40474 | |
801995 | 801995 | 95405 | 95405: Santa Rosa | 2021-04-05 | Sonoma | 97 | 1011 | 21448 | |
801996 | 801996 | 95407 | 95407: Santa Rosa | 2021-04-05 | Sonoma | 97 | 4769 | 42483 | |
801997 | 801997 | 95409 | 95409: Santa Rosa | 2021-04-05 | Sonoma | 97 | 952 | 27312 | |
801998 | 801998 | 95412 | 95412: Annapolis | 2021-04-05 | Sonoma | 97 | 10 | 10 or fewer | 402 |
801999 | 801999 | 95421 | 95421: Cazadero | 2021-04-05 | Sonoma | 97 | 34 | 1681 | |
802000 | 802000 | 95425 | 95425: Cloverdale | 2021-04-05 | Sonoma | 97 | 735 | 10586 | |
802001 | 802001 | 95436 | 95436: Forestville | 2021-04-05 | Sonoma | 97 | 165 | 6352 | |
802002 | 802002 | 95439 | 95439: Fulton | 2021-04-05 | Sonoma | 97 | 47 | 774 | |
802003 | 802003 | 95441 | 95441: Geyserville | 2021-04-05 | Sonoma | 97 | 92 | 2053 | |
802004 | 802004 | 95442 | 95442: Glen Ellen | 2021-04-05 | Sonoma | 97 | 136 | 3136 | |
802005 | 802005 | 95444 | 95444: Graton | 2021-04-05 | Sonoma | 97 | 28 | 715 | |
802006 | 802006 | 95446 | 95446: Guerneville | 2021-04-05 | Sonoma | 97 | 137 | 5100 | |
802007 | 802007 | 95448 | 95448: Healdsburg | 2021-04-05 | Sonoma | 97 | 924 | 17482 | |
802008 | 802008 | 95450 | 95450: Jenner | 2021-04-05 | Sonoma | 97 | 10 | 10 or fewer | 298 |
802009 | 802009 | 95452 | 95452: Kenwood | 2021-04-05 | Sonoma | 97 | 19 | 970 | |
802010 | 802010 | 95462 | 95462: Monte Rio | 2021-04-05 | Sonoma | 97 | 21 | 1265 | |
802011 | 802011 | 95465 | 95465: Occidental | 2021-04-05 | Sonoma | 97 | 22 | 2104 | |
802012 | 802012 | 95472 | 95472: Sebastopol | 2021-04-05 | Sonoma | 97 | 639 | 30762 | |
802013 | 802013 | 95476 | 95476: Sonoma | 2021-04-05 | Sonoma | 97 | 2288 | 36792 | |
802014 | 802014 | 95492 | 95492: Windsor | 2021-04-05 | Sonoma | 97 | 1632 | 29920 | |
802015 | 802015 | 95497 | 95497: The Sea Ranch | 2021-04-05 | Sonoma | 97 | 10 | 10 or fewer | 1161 |
803260 | 803260 | 94515 | 94515: Calistoga | 2021-04-04 | Sonoma | 97 | 12 | 7436 | |
803261 | 803261 | 94922 | 94922: Bodega | 2021-04-04 | Sonoma | 97 | 15 | 603 | |
803262 | 803262 | 94923 | 94923: Bodega Bay | 2021-04-04 | Sonoma | 97 | 51 | 846 | |
803263 | 803263 | 94928 | 94928: Rohnert Park | 2021-04-04 | Sonoma | 97 | 2578 | 44103 |
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 );