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

255 rows where place = "95442: Glen Ellen" sorted by date descending

View and edit SQL

Suggested facets: note, date (date)

place

  • 95442: Glen Ellen · 255

fips

county

Link rowid date ▲ county fips place confirmed_cases note x y population
2291 2020-12-01 Sonoma 97 95442: Glen Ellen 68   -122.515868 38.374225 3136
9426 2020-11-24 Sonoma 97 95442: Glen Ellen 63   -122.515868 38.374225 3136
10454 2020-11-23 Sonoma 97 95442: Glen Ellen 63   -122.515868 38.374225 3136
15519 2020-11-18 Sonoma 97 95442: Glen Ellen 63   -122.515868 38.374225 3136
17863 2020-11-16 Sonoma 97 95442: Glen Ellen 63   -122.515868 38.374225 3136
18582 2020-11-15 Sonoma 97 95442: Glen Ellen 63   -122.515868 38.374225 3136
19467 2020-11-14 Sonoma 97 95442: Glen Ellen 63   -122.515868 38.374225 3136
20541 2020-11-13 Sonoma 97 95442: Glen Ellen 63   -122.515868 38.374225 3136
21703 2020-11-12 Sonoma 97 95442: Glen Ellen 62   -122.515868 38.374225 3136
22618 2020-11-11 Sonoma 97 95442: Glen Ellen 61   -122.515868 38.374225 3136
23772 2020-11-10 Sonoma 97 95442: Glen Ellen 61   -122.515868 38.374225 3136
24876 2020-11-09 Sonoma 97 95442: Glen Ellen 61   -122.515868 38.374225 3136
25747 2020-11-08 Sonoma 97 95442: Glen Ellen 61   -122.515868 38.374225 3136
26558 2020-11-07 Sonoma 97 95442: Glen Ellen 61   -122.515868 38.374225 3136
27722 2020-11-06 Sonoma 97 95442: Glen Ellen 60   -122.515868 38.374225 3136
28868 2020-11-05 Sonoma 97 95442: Glen Ellen 58   -122.515868 38.374225 3136
30011 2020-11-04 Sonoma 97 95442: Glen Ellen 57   -122.515868 38.374225 3136
31186 2020-11-03 Sonoma 97 95442: Glen Ellen 57   -122.515868 38.374225 3136
32272 2020-11-02 Sonoma 97 95442: Glen Ellen 55   -122.515868 38.374225 3136
33126 2020-11-01 Sonoma 97 95442: Glen Ellen 55   -122.515868 38.374225 3136
33935 2020-10-31 Sonoma 97 95442: Glen Ellen 55   -122.515868 38.374225 3136
35038 2020-10-30 Sonoma 97 95442: Glen Ellen 55   -122.515868 38.374225 3136
36204 2020-10-29 Sonoma 97 95442: Glen Ellen 55   -122.515868 38.374225 3136
37305 2020-10-28 Sonoma 97 95442: Glen Ellen 55   -122.515868 38.374225 3136
38428 2020-10-27 Sonoma 97 95442: Glen Ellen 55   -122.515868 38.374225 3136
39533 2020-10-26 Sonoma 97 95442: Glen Ellen 55   -122.515868 38.374225 3136
40384 2020-10-25 Sonoma 97 95442: Glen Ellen 54   -122.515868 38.374225 3136
41188 2020-10-24 Sonoma 97 95442: Glen Ellen 54   -122.515868 38.374225 3136
42339 2020-10-23 Sonoma 97 95442: Glen Ellen 54   -122.515868 38.374225 3136
43442 2020-10-22 Sonoma 97 95442: Glen Ellen 53   -122.515868 38.374225 3136
44560 2020-10-21 Sonoma 97 95442: Glen Ellen 53   -122.515868 38.374225 3136
45730 2020-10-20 Sonoma 97 95442: Glen Ellen 52   -122.515868 38.374225 3136
46853 2020-10-19 Sonoma 97 95442: Glen Ellen 52   -122.515868 38.374225 3136
47687 2020-10-18 Sonoma 97 95442: Glen Ellen 52   -122.515868 38.374225 3136
48572 2020-10-17 Sonoma 97 95442: Glen Ellen 50   -122.515868 38.374225 3136
49702 2020-10-16 Sonoma 97 95442: Glen Ellen 50   -122.515868 38.374225 3136
50827 2020-10-15 Sonoma 97 95442: Glen Ellen 50   -122.515868 38.374225 3136
51948 2020-10-14 Sonoma 97 95442: Glen Ellen 50   -122.515868 38.374225 3136
53014 2020-10-13 Sonoma 97 95442: Glen Ellen 49   -122.515868 38.374225 3136
54054 2020-10-12 Sonoma 97 95442: Glen Ellen 49   -122.515868 38.374225 3136
54885 2020-10-11 Sonoma 97 95442: Glen Ellen 49   -122.515868 38.374225 3136
55752 2020-10-10 Sonoma 97 95442: Glen Ellen 49   -122.515868 38.374225 3136
56879 2020-10-09 Sonoma 97 95442: Glen Ellen 49   -122.515868 38.374225 3136
57988 2020-10-08 Sonoma 97 95442: Glen Ellen 49   -122.515868 38.374225 3136
59101 2020-10-07 Sonoma 97 95442: Glen Ellen 49   -122.515868 38.374225 3136
60204 2020-10-06 Sonoma 97 95442: Glen Ellen 48   -122.515868 38.374225 3136
61277 2020-10-05 Sonoma 97 95442: Glen Ellen 48   -122.515868 38.374225 3136
62124 2020-10-04 Sonoma 97 95442: Glen Ellen 47   -122.515868 38.374225 3136
62972 2020-10-03 Sonoma 97 95442: Glen Ellen 47   -122.515868 38.374225 3136
64114 2020-10-02 Sonoma 97 95442: Glen Ellen 47   -122.515868 38.374225 3136
65197 2020-10-01 Sonoma 97 95442: Glen Ellen 46   -122.515868 38.374225 3136
66289 2020-09-30 Sonoma 97 95442: Glen Ellen 45   -122.515868 38.374225 3136
67411 2020-09-29 Sonoma 97 95442: Glen Ellen 45   -122.515868 38.374225 3136
68530 2020-09-28 Sonoma 97 95442: Glen Ellen 45   -122.515868 38.374225 3136
69354 2020-09-27 Sonoma 97 95442: Glen Ellen 41   -122.515868 38.374225 3136
70217 2020-09-26 Sonoma 97 95442: Glen Ellen 41   -122.515868 38.374225 3136
71358 2020-09-25 Sonoma 97 95442: Glen Ellen 41   -122.515868 38.374225 3136
72472 2020-09-24 Sonoma 97 95442: Glen Ellen 41   -122.515868 38.374225 3136
73570 2020-09-23 Sonoma 97 95442: Glen Ellen 41   -122.515868 38.374225 3136
74621 2020-09-22 Sonoma 97 95442: Glen Ellen 41   -122.515868 38.374225 3136
75669 2020-09-21 Sonoma 97 95442: Glen Ellen 41   -122.515868 38.374225 3136
76515 2020-09-20 Sonoma 97 95442: Glen Ellen 39   -122.515868 38.374225 3136
77379 2020-09-19 Sonoma 97 95442: Glen Ellen 39   -122.515868 38.374225 3136
78500 2020-09-18 Sonoma 97 95442: Glen Ellen 39   -122.515868 38.374225 3136
79610 2020-09-17 Sonoma 97 95442: Glen Ellen 39   -122.515868 38.374225 3136
80649 2020-09-16 Sonoma 97 95442: Glen Ellen 39   -122.515868 38.374225 3136
81795 2020-09-15 Sonoma 97 95442: Glen Ellen 39   -122.515868 38.374225 3136
82908 2020-09-14 Sonoma 97 95442: Glen Ellen 39   -122.515868 38.374225 3136
83777 2020-09-13 Sonoma 97 95442: Glen Ellen 38   -122.515868 38.374225 3136
84640 2020-09-12 Sonoma 97 95442: Glen Ellen 37   -122.515868 38.374225 3136
85786 2020-09-11 Sonoma 97 95442: Glen Ellen 36   -122.515868 38.374225 3136
86850 2020-09-10 Sonoma 97 95442: Glen Ellen 36   -122.515868 38.374225 3136
87974 2020-09-09 Sonoma 97 95442: Glen Ellen 35   -122.515868 38.374225 3136
89087 2020-09-08 Sonoma 97 95442: Glen Ellen 35   -122.515868 38.374225 3136
89932 2020-09-07 Sonoma 97 95442: Glen Ellen 35   -122.515868 38.374225 3136
90743 2020-09-06 Sonoma 97 95442: Glen Ellen 35   -122.515868 38.374225 3136
91570 2020-09-05 Sonoma 97 95442: Glen Ellen 35   -122.515868 38.374225 3136
92721 2020-09-04 Sonoma 97 95442: Glen Ellen 34   -122.515868 38.374225 3136
93784 2020-09-03 Sonoma 97 95442: Glen Ellen 34   -122.515868 38.374225 3136
94876 2020-09-02 Sonoma 97 95442: Glen Ellen 34   -122.515868 38.374225 3136
96022 2020-09-01 Sonoma 97 95442: Glen Ellen 34   -122.515868 38.374225 3136
97091 2020-08-31 Sonoma 97 95442: Glen Ellen 33   -122.515868 38.374225 3136
97966 2020-08-30 Sonoma 97 95442: Glen Ellen 33   -122.515868 38.374225 3136
99067 2020-08-29 Sonoma 97 95442: Glen Ellen 33   -122.515868 38.374225 3136
99748 2020-08-28 Sonoma 97 95442: Glen Ellen 33   -122.515868 38.374225 3136
100774 2020-08-27 Sonoma 97 95442: Glen Ellen 33   -122.515868 38.374225 3136
101847 2020-08-26 Sonoma 97 95442: Glen Ellen 33   -122.515868 38.374225 3136
102905 2020-08-25 Sonoma 97 95442: Glen Ellen 33   -122.515868 38.374225 3136
104004 2020-08-24 Sonoma 97 95442: Glen Ellen 32   -122.515868 38.374225 3136
104766 2020-08-23 Sonoma 97 95442: Glen Ellen 32   -122.515868 38.374225 3136
105741 2020-08-22 Sonoma 97 95442: Glen Ellen 32   -122.515868 38.374225 3136
106817 2020-08-21 Sonoma 97 95442: Glen Ellen 31   -122.515868 38.374225 3136
107907 2020-08-20 Sonoma 97 95442: Glen Ellen 31   -122.515868 38.374225 3136
108999 2020-08-19 Sonoma 97 95442: Glen Ellen 31   -122.515868 38.374225 3136
110130 2020-08-18 Sonoma 97 95442: Glen Ellen 31   -122.515868 38.374225 3136
111203 2020-08-17 Sonoma 97 95442: Glen Ellen 31   -122.515868 38.374225 3136
112127 2020-08-16 Sonoma 97 95442: Glen Ellen 31   -122.515868 38.374225 3136
112941 2020-08-15 Sonoma 97 95442: Glen Ellen 30   -122.515868 38.374225 3136
114051 2020-08-14 Sonoma 97 95442: Glen Ellen 29   -122.515868 38.374225 3136
115052 2020-08-13 Sonoma 97 95442: Glen Ellen 29   -122.515868 38.374225 3136

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,
   [population] TEXT
);