latimes_place_totals

⚠️ 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

1,120 rows where county = "Sonoma" sorted by date descending

View and edit SQL

Suggested facets: note, x, y, date (date)

fips

  • 97 1,120

county

  • Sonoma · 1,120
Link rowid date ▲ county fips place confirmed_cases note x y
4864 2020-10-26 Sonoma 97 Bodega 1 10 or fewer -122.973889 38.345278
4865 2020-10-26 Sonoma 97 Bodega Bay 11   -123.038611 38.324444
4866 2020-10-26 Sonoma 97 Cazadero 1 10 or fewer -123.085278 38.533333
4867 2020-10-26 Sonoma 97 Cloverdale 280   -123.017222 38.799167
4868 2020-10-26 Sonoma 97 Cotati 118   -122.709167 38.327778
4869 2020-10-26 Sonoma 97 Forestville 57   -122.896111 38.481667
4870 2020-10-26 Sonoma 97 Fulton 14   -122.77 38.496389
4871 2020-10-26 Sonoma 97 Geyserville 40   -122.9025 38.707778
4872 2020-10-26 Sonoma 97 Glen Ellen 50   -122.531111 38.364444
4873 2020-10-26 Sonoma 97 Graton 1 10 or fewer -122.866389 38.4375
4874 2020-10-26 Sonoma 97 Guerneville 30   -122.990833 38.506389
4875 2020-10-26 Sonoma 97 Healdsburg 324   -122.866389 38.6175
4876 2020-10-26 Sonoma 97 Jenner 1 10 or fewer -123.115556 38.449722
4877 2020-10-26 Sonoma 97 Kenwood 1 10 or fewer -122.546111 38.413889
4878 2020-10-26 Sonoma 97 Monte Rio 1 10 or fewer -123.013889 38.470278
4879 2020-10-26 Sonoma 97 Penngrove 43   -122.666667 38.299722
4880 2020-10-26 Sonoma 97 Petaluma 1308   -122.631389 38.245833
4881 2020-10-26 Sonoma 97 Rohnert Park 673   -122.695278 38.347222
4882 2020-10-26 Sonoma 97 Santa Rosa 4372   -122.704722 38.448611
4883 2020-10-26 Sonoma 97 Sebastopol 147   -122.826944 38.399167
4884 2020-10-26 Sonoma 97 Sonoma 598   -122.458889 38.288889
4885 2020-10-26 Sonoma 97 The Sea Ranch 1 10 or fewer -123.454444 38.715278
4886 2020-10-26 Sonoma 97 Windsor 441   -122.816389 38.547222
7175 2020-10-23 Sonoma 97 Bodega 1 10 or fewer -122.973889 38.345278
7176 2020-10-23 Sonoma 97 Bodega Bay 11   -123.038611 38.324444
7177 2020-10-23 Sonoma 97 Cazadero 1 10 or fewer -123.085278 38.533333
7178 2020-10-23 Sonoma 97 Cloverdale 280   -123.017222 38.799167
7179 2020-10-23 Sonoma 97 Cotati 118   -122.709167 38.327778
7180 2020-10-23 Sonoma 97 Forestville 57   -122.896111 38.481667
7181 2020-10-23 Sonoma 97 Fulton 14   -122.77 38.496389
7182 2020-10-23 Sonoma 97 Geyserville 40   -122.9025 38.707778
7183 2020-10-23 Sonoma 97 Glen Ellen 50   -122.531111 38.364444
7184 2020-10-23 Sonoma 97 Graton 1 10 or fewer -122.866389 38.4375
7185 2020-10-23 Sonoma 97 Guerneville 30   -122.990833 38.506389
7186 2020-10-23 Sonoma 97 Healdsburg 324   -122.866389 38.6175
7187 2020-10-23 Sonoma 97 Jenner 1 10 or fewer -123.115556 38.449722
7188 2020-10-23 Sonoma 97 Kenwood 1 10 or fewer -122.546111 38.413889
7189 2020-10-23 Sonoma 97 Monte Rio 1 10 or fewer -123.013889 38.470278
7190 2020-10-23 Sonoma 97 Penngrove 43   -122.666667 38.299722
7191 2020-10-23 Sonoma 97 Petaluma 1308   -122.631389 38.245833
7192 2020-10-23 Sonoma 97 Rohnert Park 673   -122.695278 38.347222
7193 2020-10-23 Sonoma 97 Santa Rosa 4372   -122.704722 38.448611
7194 2020-10-23 Sonoma 97 Sebastopol 147   -122.826944 38.399167
7195 2020-10-23 Sonoma 97 Sonoma 598   -122.458889 38.288889
7196 2020-10-23 Sonoma 97 The Sea Ranch 1 10 or fewer -123.454444 38.715278
7197 2020-10-23 Sonoma 97 Windsor 441   -122.816389 38.547222
9118 2020-10-21 Sonoma 97 Bodega 1 10 or fewer -122.973889 38.345278
9119 2020-10-21 Sonoma 97 Bodega Bay 1 10 or fewer -123.038611 38.324444
9120 2020-10-21 Sonoma 97 Cazadero 1 10 or fewer -123.085278 38.533333
9121 2020-10-21 Sonoma 97 Cloverdale 278   -123.017222 38.799167
9122 2020-10-21 Sonoma 97 Cotati 144   -122.709167 38.327778
9123 2020-10-21 Sonoma 97 Forestville 55   -122.896111 38.481667
9124 2020-10-21 Sonoma 97 Fulton 13   -122.77 38.496389
9125 2020-10-21 Sonoma 97 Geyserville 40   -122.9025 38.707778
9126 2020-10-21 Sonoma 97 Glen Ellen 50   -122.531111 38.364444
9127 2020-10-21 Sonoma 97 Graton 1 10 or fewer -122.866389 38.4375
9128 2020-10-21 Sonoma 97 Guerneville 27   -122.990833 38.506389
9129 2020-10-21 Sonoma 97 Healdsburg 317   -122.866389 38.6175
9130 2020-10-21 Sonoma 97 Jenner 1 10 or fewer -123.115556 38.449722
9131 2020-10-21 Sonoma 97 Kenwood 1 10 or fewer -122.546111 38.413889
9132 2020-10-21 Sonoma 97 Monte Rio 1 10 or fewer -123.013889 38.470278
9133 2020-10-21 Sonoma 97 Penngrove 43   -122.666667 38.299722
9134 2020-10-21 Sonoma 97 Petaluma 1296   -122.631389 38.245833
9135 2020-10-21 Sonoma 97 Rohnert Park 655   -122.695278 38.347222
9136 2020-10-21 Sonoma 97 Santa Rosa 4249   -122.704722 38.448611
9137 2020-10-21 Sonoma 97 Sebastopol 143   -122.826944 38.399167
9138 2020-10-21 Sonoma 97 Sonoma 586   -122.458889 38.288889
9139 2020-10-21 Sonoma 97 The Sea Ranch 1 10 or fewer -123.454444 38.715278
9140 2020-10-21 Sonoma 97 Windsor 432   -122.816389 38.547222
10118 2020-10-20 Sonoma 97 Bodega 1 10 or fewer -122.973889 38.345278
10119 2020-10-20 Sonoma 97 Bodega Bay 1 10 or fewer -123.038611 38.324444
10120 2020-10-20 Sonoma 97 Cazadero 1 10 or fewer -123.085278 38.533333
10121 2020-10-20 Sonoma 97 Cloverdale 272   -123.017222 38.799167
10122 2020-10-20 Sonoma 97 Cotati 107   -122.709167 38.327778
10123 2020-10-20 Sonoma 97 Forestville 53   -122.896111 38.481667
10124 2020-10-20 Sonoma 97 Fulton 13   -122.77 38.496389
10125 2020-10-20 Sonoma 97 Geyserville 41   -122.9025 38.707778
10126 2020-10-20 Sonoma 97 Glen Ellen 47   -122.531111 38.364444
10127 2020-10-20 Sonoma 97 Graton 1 10 or fewer -122.866389 38.4375
10128 2020-10-20 Sonoma 97 Guerneville 24   -122.990833 38.506389
10129 2020-10-20 Sonoma 97 Healdsburg 297   -122.866389 38.6175
10130 2020-10-20 Sonoma 97 Jenner 1 10 or fewer -123.115556 38.449722
10131 2020-10-20 Sonoma 97 Kenwood 1 10 or fewer -122.546111 38.413889
10132 2020-10-20 Sonoma 97 Monte Rio 1 10 or fewer -123.013889 38.470278
10133 2020-10-20 Sonoma 97 Penngrove 39   -122.666667 38.299722
10134 2020-10-20 Sonoma 97 Petaluma 1260   -122.631389 38.245833
10135 2020-10-20 Sonoma 97 Rohnert Park 614   -122.695278 38.347222
10136 2020-10-20 Sonoma 97 Santa Rosa 4012   -122.704722 38.448611
10137 2020-10-20 Sonoma 97 Sebastopol 129   -122.826944 38.399167
10138 2020-10-20 Sonoma 97 Sonoma 563   -122.458889 38.288889
10139 2020-10-20 Sonoma 97 The Sea Ranch 1 10 or fewer -123.454444 38.715278
10140 2020-10-20 Sonoma 97 Windsor 417   -122.816389 38.547222
16065 2020-10-13 Sonoma 97 Annapolis 218      
16066 2020-10-13 Sonoma 97 Bodega 205   -122.973889 38.345278
16067 2020-10-13 Sonoma 97 Bodega Bay 129   -123.038611 38.324444
16068 2020-10-13 Sonoma 97 Calistoga 563      
16069 2020-10-13 Sonoma 97 Cazadero 1 10 or fewer -123.085278 38.533333
16070 2020-10-13 Sonoma 97 Cloverdale 417   -123.017222 38.799167
16071 2020-10-13 Sonoma 97 Cotati 107   -122.709167 38.327778
16072 2020-10-13 Sonoma 97 Forestville 53   -122.896111 38.481667

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [latimes_place_totals] (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [place] TEXT,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [x] TEXT,
   [y] TEXT
);
Powered by Datasette · Query took 796.584ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals