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,097 rows where fips = 97 sorted by date descending

View and edit SQL

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

fips

  • 97 · 1,097

county

Link rowid date ▲ county fips place confirmed_cases note x y
909 2020-10-23 Sonoma 97 Bodega 1 10 or fewer -122.973889 38.345278
910 2020-10-23 Sonoma 97 Bodega Bay 1 10 or fewer -123.038611 38.324444
911 2020-10-23 Sonoma 97 Cazadero 1 10 or fewer -123.085278 38.533333
912 2020-10-23 Sonoma 97 Cloverdale 280   -123.017222 38.799167
913 2020-10-23 Sonoma 97 Cotati 118   -122.709167 38.327778
914 2020-10-23 Sonoma 97 Forestville 57   -122.896111 38.481667
915 2020-10-23 Sonoma 97 Fulton 14   -122.77 38.496389
916 2020-10-23 Sonoma 97 Geyserville 40   -122.9025 38.707778
917 2020-10-23 Sonoma 97 Glen Ellen 50   -122.531111 38.364444
918 2020-10-23 Sonoma 97 Graton 1 10 or fewer -122.866389 38.4375
919 2020-10-23 Sonoma 97 Guerneville 30   -122.990833 38.506389
920 2020-10-23 Sonoma 97 Healdsburg 324   -122.866389 38.6175
921 2020-10-23 Sonoma 97 Jenner 1 10 or fewer -123.115556 38.449722
922 2020-10-23 Sonoma 97 Kenwood 1 10 or fewer -122.546111 38.413889
923 2020-10-23 Sonoma 97 Monte Rio 1 10 or fewer -123.013889 38.470278
924 2020-10-23 Sonoma 97 Penngrove 43   -122.666667 38.299722
925 2020-10-23 Sonoma 97 Petaluma 1308   -122.631389 38.245833
926 2020-10-23 Sonoma 97 Rohnert Park 673   -122.695278 38.347222
927 2020-10-23 Sonoma 97 Santa Rosa 4372   -122.704722 38.448611
928 2020-10-23 Sonoma 97 Sebastopol 147   -122.826944 38.399167
929 2020-10-23 Sonoma 97 Sonoma 598   -122.458889 38.288889
930 2020-10-23 Sonoma 97 The Sea Ranch 1 10 or fewer -123.454444 38.715278
931 2020-10-23 Sonoma 97 Windsor 441   -122.816389 38.547222
2852 2020-10-21 Sonoma 97 Bodega 1 10 or fewer -122.973889 38.345278
2853 2020-10-21 Sonoma 97 Bodega Bay 1 10 or fewer -123.038611 38.324444
2854 2020-10-21 Sonoma 97 Cazadero 1 10 or fewer -123.085278 38.533333
2855 2020-10-21 Sonoma 97 Cloverdale 278   -123.017222 38.799167
2856 2020-10-21 Sonoma 97 Cotati 144   -122.709167 38.327778
2857 2020-10-21 Sonoma 97 Forestville 55   -122.896111 38.481667
2858 2020-10-21 Sonoma 97 Fulton 13   -122.77 38.496389
2859 2020-10-21 Sonoma 97 Geyserville 40   -122.9025 38.707778
2860 2020-10-21 Sonoma 97 Glen Ellen 50   -122.531111 38.364444
2861 2020-10-21 Sonoma 97 Graton 1 10 or fewer -122.866389 38.4375
2862 2020-10-21 Sonoma 97 Guerneville 27   -122.990833 38.506389
2863 2020-10-21 Sonoma 97 Healdsburg 317   -122.866389 38.6175
2864 2020-10-21 Sonoma 97 Jenner 1 10 or fewer -123.115556 38.449722
2865 2020-10-21 Sonoma 97 Kenwood 1 10 or fewer -122.546111 38.413889
2866 2020-10-21 Sonoma 97 Monte Rio 1 10 or fewer -123.013889 38.470278
2867 2020-10-21 Sonoma 97 Penngrove 43   -122.666667 38.299722
2868 2020-10-21 Sonoma 97 Petaluma 1296   -122.631389 38.245833
2869 2020-10-21 Sonoma 97 Rohnert Park 655   -122.695278 38.347222
2870 2020-10-21 Sonoma 97 Santa Rosa 4249   -122.704722 38.448611
2871 2020-10-21 Sonoma 97 Sebastopol 143   -122.826944 38.399167
2872 2020-10-21 Sonoma 97 Sonoma 586   -122.458889 38.288889
2873 2020-10-21 Sonoma 97 The Sea Ranch 1 10 or fewer -123.454444 38.715278
2874 2020-10-21 Sonoma 97 Windsor 432   -122.816389 38.547222
3852 2020-10-20 Sonoma 97 Bodega 1 10 or fewer -122.973889 38.345278
3853 2020-10-20 Sonoma 97 Bodega Bay 1 10 or fewer -123.038611 38.324444
3854 2020-10-20 Sonoma 97 Cazadero 1 10 or fewer -123.085278 38.533333
3855 2020-10-20 Sonoma 97 Cloverdale 272   -123.017222 38.799167
3856 2020-10-20 Sonoma 97 Cotati 107   -122.709167 38.327778
3857 2020-10-20 Sonoma 97 Forestville 53   -122.896111 38.481667
3858 2020-10-20 Sonoma 97 Fulton 13   -122.77 38.496389
3859 2020-10-20 Sonoma 97 Geyserville 41   -122.9025 38.707778
3860 2020-10-20 Sonoma 97 Glen Ellen 47   -122.531111 38.364444
3861 2020-10-20 Sonoma 97 Graton 1 10 or fewer -122.866389 38.4375
3862 2020-10-20 Sonoma 97 Guerneville 24   -122.990833 38.506389
3863 2020-10-20 Sonoma 97 Healdsburg 297   -122.866389 38.6175
3864 2020-10-20 Sonoma 97 Jenner 1 10 or fewer -123.115556 38.449722
3865 2020-10-20 Sonoma 97 Kenwood 1 10 or fewer -122.546111 38.413889
3866 2020-10-20 Sonoma 97 Monte Rio 1 10 or fewer -123.013889 38.470278
3867 2020-10-20 Sonoma 97 Penngrove 39   -122.666667 38.299722
3868 2020-10-20 Sonoma 97 Petaluma 1260   -122.631389 38.245833
3869 2020-10-20 Sonoma 97 Rohnert Park 614   -122.695278 38.347222
3870 2020-10-20 Sonoma 97 Santa Rosa 4012   -122.704722 38.448611
3871 2020-10-20 Sonoma 97 Sebastopol 129   -122.826944 38.399167
3872 2020-10-20 Sonoma 97 Sonoma 563   -122.458889 38.288889
3873 2020-10-20 Sonoma 97 The Sea Ranch 1 10 or fewer -123.454444 38.715278
3874 2020-10-20 Sonoma 97 Windsor 417   -122.816389 38.547222
9799 2020-10-13 Sonoma 97 Annapolis 218      
9800 2020-10-13 Sonoma 97 Bodega 205   -122.973889 38.345278
9801 2020-10-13 Sonoma 97 Bodega Bay 129   -123.038611 38.324444
9802 2020-10-13 Sonoma 97 Calistoga 563      
9803 2020-10-13 Sonoma 97 Cazadero 1 10 or fewer -123.085278 38.533333
9804 2020-10-13 Sonoma 97 Cloverdale 417   -123.017222 38.799167
9805 2020-10-13 Sonoma 97 Cotati 107   -122.709167 38.327778
9806 2020-10-13 Sonoma 97 Forestville 53   -122.896111 38.481667
9807 2020-10-13 Sonoma 97 Fulton 13   -122.77 38.496389
9808 2020-10-13 Sonoma 97 Geyserville 41   -122.9025 38.707778
9809 2020-10-13 Sonoma 97 Glen Ellen 47   -122.531111 38.364444
9810 2020-10-13 Sonoma 97 Graton 1 10 or fewer -122.866389 38.4375
9811 2020-10-13 Sonoma 97 Guerneville 24   -122.990833 38.506389
9812 2020-10-13 Sonoma 97 Healdsburg 297   -122.866389 38.6175
9813 2020-10-13 Sonoma 97 Jenner 1 10 or fewer -123.115556 38.449722
9814 2020-10-13 Sonoma 97 Kenwood 1 10 or fewer -122.546111 38.413889
9815 2020-10-13 Sonoma 97 Monte Rio 1 10 or fewer -123.013889 38.470278
9816 2020-10-13 Sonoma 97 Penngrove 39   -122.666667 38.299722
9817 2020-10-13 Sonoma 97 Petaluma 1260   -122.631389 38.245833
9818 2020-10-13 Sonoma 97 Rohnert Park 614   -122.695278 38.347222
9819 2020-10-13 Sonoma 97 Santa Rosa 4012   -122.704722 38.448611
9820 2020-10-13 Sonoma 97 Sebastopol 129   -122.826944 38.399167
9821 2020-10-13 Sonoma 97 Sonoma 563   -122.458889 38.288889
9822 2020-10-13 Sonoma 97 The Sea Ranch 1 10 or fewer -123.454444 38.715278
9823 2020-10-13 Sonoma 97 Windsor 417   -122.816389 38.547222
12092 2020-10-10 Sonoma 97 Bodega 1 10 or fewer -122.973889 38.345278
12093 2020-10-10 Sonoma 97 Bodega Bay 1 10 or fewer -123.038611 38.324444
12094 2020-10-10 Sonoma 97 Cazadero 1 10 or fewer -123.085278 38.533333
12095 2020-10-10 Sonoma 97 Cloverdale 266   -123.017222 38.799167
12096 2020-10-10 Sonoma 97 Cotati 95   -122.709167 38.327778
12097 2020-10-10 Sonoma 97 Forestville 50   -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 831.9ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals