⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals

12,992 rows where county = "Sonoma" sorted by date descending

View and edit SQL

fips

  • 97 12,992

county

  • Sonoma · 12,992
Link rowid id name date ▲ county fips confirmed_cases note population
1256 94515 94515: Calistoga 2021-04-10 Sonoma 97 11   7436
1257 94922 94922: Bodega 2021-04-10 Sonoma 97 15   603
1258 94923 94923: Bodega Bay 2021-04-10 Sonoma 97 51   846
1259 94928 94928: Rohnert Park 2021-04-10 Sonoma 97 2586   44103
1260 94931 94931: Cotati 2021-04-10 Sonoma 97 380   8601
1261 94951 94951: Penngrove 2021-04-10 Sonoma 97 173   4571
1262 94952 94952: Petaluma 2021-04-10 Sonoma 97 1463   36184
1263 94954 94954: Petaluma 2021-04-10 Sonoma 97 2051   38414
1264 95401 95401: Santa Rosa 2021-04-10 Sonoma 97 2843   38986
1265 95403 95403: Santa Rosa 2021-04-10 Sonoma 97 3033   45355
1266 95404 95404: Santa Rosa 2021-04-10 Sonoma 97 2156   40474
1267 95405 95405: Santa Rosa 2021-04-10 Sonoma 97 1015   21448
1268 95407 95407: Santa Rosa 2021-04-10 Sonoma 97 4780   42483
1269 95409 95409: Santa Rosa 2021-04-10 Sonoma 97 956   27312
1270 95412 95412: Annapolis 2021-04-10 Sonoma 97 10 10 or fewer 402
1271 95421 95421: Cazadero 2021-04-10 Sonoma 97 34   1681
1272 95425 95425: Cloverdale 2021-04-10 Sonoma 97 736   10586
1273 95436 95436: Forestville 2021-04-10 Sonoma 97 166   6352
1274 95439 95439: Fulton 2021-04-10 Sonoma 97 47   774
1275 95441 95441: Geyserville 2021-04-10 Sonoma 97 93   2053
1276 95442 95442: Glen Ellen 2021-04-10 Sonoma 97 137   3136
1277 95444 95444: Graton 2021-04-10 Sonoma 97 28   715
1278 95446 95446: Guerneville 2021-04-10 Sonoma 97 137   5100
1279 95448 95448: Healdsburg 2021-04-10 Sonoma 97 926   17482
1280 95450 95450: Jenner 2021-04-10 Sonoma 97 10 10 or fewer 298
1281 95452 95452: Kenwood 2021-04-10 Sonoma 97 19   970
1282 95462 95462: Monte Rio 2021-04-10 Sonoma 97 21   1265
1283 95465 95465: Occidental 2021-04-10 Sonoma 97 22   2104
1284 95472 95472: Sebastopol 2021-04-10 Sonoma 97 643   30762
1285 95476 95476: Sonoma 2021-04-10 Sonoma 97 2290   36792
1286 95492 95492: Windsor 2021-04-10 Sonoma 97 1639   29920
1287 95497 95497: The Sea Ranch 2021-04-10 Sonoma 97 10 10 or fewer 1161
2623 94515 94515: Calistoga 2021-04-09 Sonoma 97 11   7436
2624 94922 94922: Bodega 2021-04-09 Sonoma 97 15   603
2625 94923 94923: Bodega Bay 2021-04-09 Sonoma 97 51   846
2626 94928 94928: Rohnert Park 2021-04-09 Sonoma 97 2586   44103
2627 94931 94931: Cotati 2021-04-09 Sonoma 97 380   8601
2628 94951 94951: Penngrove 2021-04-09 Sonoma 97 173   4571
2629 94952 94952: Petaluma 2021-04-09 Sonoma 97 1463   36184
2630 94954 94954: Petaluma 2021-04-09 Sonoma 97 2051   38414
2631 95401 95401: Santa Rosa 2021-04-09 Sonoma 97 2843   38986
2632 95403 95403: Santa Rosa 2021-04-09 Sonoma 97 3033   45355
2633 95404 95404: Santa Rosa 2021-04-09 Sonoma 97 2156   40474
2634 95405 95405: Santa Rosa 2021-04-09 Sonoma 97 1015   21448
2635 95407 95407: Santa Rosa 2021-04-09 Sonoma 97 4780   42483
2636 95409 95409: Santa Rosa 2021-04-09 Sonoma 97 956   27312
2637 95412 95412: Annapolis 2021-04-09 Sonoma 97 10 10 or fewer 402
2638 95421 95421: Cazadero 2021-04-09 Sonoma 97 34   1681
2639 95425 95425: Cloverdale 2021-04-09 Sonoma 97 736   10586
2640 95436 95436: Forestville 2021-04-09 Sonoma 97 166   6352
2641 95439 95439: Fulton 2021-04-09 Sonoma 97 47   774
2642 95441 95441: Geyserville 2021-04-09 Sonoma 97 93   2053
2643 95442 95442: Glen Ellen 2021-04-09 Sonoma 97 137   3136
2644 95444 95444: Graton 2021-04-09 Sonoma 97 28   715
2645 95446 95446: Guerneville 2021-04-09 Sonoma 97 137   5100
2646 95448 95448: Healdsburg 2021-04-09 Sonoma 97 926   17482
2647 95450 95450: Jenner 2021-04-09 Sonoma 97 10 10 or fewer 298
2648 95452 95452: Kenwood 2021-04-09 Sonoma 97 19   970
2649 95462 95462: Monte Rio 2021-04-09 Sonoma 97 21   1265
2650 95465 95465: Occidental 2021-04-09 Sonoma 97 22   2104
2651 95472 95472: Sebastopol 2021-04-09 Sonoma 97 643   30762
2652 95476 95476: Sonoma 2021-04-09 Sonoma 97 2290   36792
2653 95492 95492: Windsor 2021-04-09 Sonoma 97 1639   29920
2654 95497 95497: The Sea Ranch 2021-04-09 Sonoma 97 10 10 or fewer 1161
3993 94515 94515: Calistoga 2021-04-08 Sonoma 97 11   7436
3994 94922 94922: Bodega 2021-04-08 Sonoma 97 15   603
3995 94923 94923: Bodega Bay 2021-04-08 Sonoma 97 51   846
3996 94928 94928: Rohnert Park 2021-04-08 Sonoma 97 2586   44103
3997 94931 94931: Cotati 2021-04-08 Sonoma 97 380   8601
3998 94951 94951: Penngrove 2021-04-08 Sonoma 97 173   4571
3999 94952 94952: Petaluma 2021-04-08 Sonoma 97 1463   36184
4000 94954 94954: Petaluma 2021-04-08 Sonoma 97 2051   38414
4001 95401 95401: Santa Rosa 2021-04-08 Sonoma 97 2843   38986
4002 95403 95403: Santa Rosa 2021-04-08 Sonoma 97 3033   45355
4003 95404 95404: Santa Rosa 2021-04-08 Sonoma 97 2156   40474
4004 95405 95405: Santa Rosa 2021-04-08 Sonoma 97 1015   21448
4005 95407 95407: Santa Rosa 2021-04-08 Sonoma 97 4780   42483
4006 95409 95409: Santa Rosa 2021-04-08 Sonoma 97 956   27312
4007 95412 95412: Annapolis 2021-04-08 Sonoma 97 10 10 or fewer 402
4008 95421 95421: Cazadero 2021-04-08 Sonoma 97 34   1681
4009 95425 95425: Cloverdale 2021-04-08 Sonoma 97 736   10586
4010 95436 95436: Forestville 2021-04-08 Sonoma 97 166   6352
4011 95439 95439: Fulton 2021-04-08 Sonoma 97 47   774
4012 95441 95441: Geyserville 2021-04-08 Sonoma 97 93   2053
4013 95442 95442: Glen Ellen 2021-04-08 Sonoma 97 137   3136
4014 95444 95444: Graton 2021-04-08 Sonoma 97 28   715
4015 95446 95446: Guerneville 2021-04-08 Sonoma 97 137   5100
4016 95448 95448: Healdsburg 2021-04-08 Sonoma 97 926   17482
4017 95450 95450: Jenner 2021-04-08 Sonoma 97 10 10 or fewer 298
4018 95452 95452: Kenwood 2021-04-08 Sonoma 97 19   970
4019 95462 95462: Monte Rio 2021-04-08 Sonoma 97 21   1265
4020 95465 95465: Occidental 2021-04-08 Sonoma 97 22   2104
4021 95472 95472: Sebastopol 2021-04-08 Sonoma 97 643   30762
4022 95476 95476: Sonoma 2021-04-08 Sonoma 97 2290   36792
4023 95492 95492: Windsor 2021-04-08 Sonoma 97 1639   29920
4024 95497 95497: The Sea Ranch 2021-04-08 Sonoma 97 10 10 or fewer 1161
5365 94515 94515: Calistoga 2021-04-07 Sonoma 97 11   7436
5366 94922 94922: Bodega 2021-04-07 Sonoma 97 15   603
5367 94923 94923: Bodega Bay 2021-04-07 Sonoma 97 51   846
5368 94928 94928: Rohnert Park 2021-04-07 Sonoma 97 2586   44103

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [latimes_place_totals] (
   [id] TEXT,
   [name] TEXT,
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [population] TEXT
);