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

263 rows where place = "95492: Windsor" sorted by date descending

View and edit SQL

Suggested facets: note, date (date)

place

  • 95492: Windsor · 263

fips

county

Link rowid date ▲ county fips place confirmed_cases note x y population
2319 2020-12-03 Sonoma 97 95492: Windsor 635   -122.812089 38.535639 29920
4691 2020-12-01 Sonoma 97 95492: Windsor 603   -122.812089 38.535639 29920
11826 2020-11-24 Sonoma 97 95492: Windsor 555   -122.812089 38.535639 29920
12854 2020-11-23 Sonoma 97 95492: Windsor 555   -122.812089 38.535639 29920
17919 2020-11-18 Sonoma 97 95492: Windsor 555   -122.812089 38.535639 29920
20263 2020-11-16 Sonoma 97 95492: Windsor 550   -122.812089 38.535639 29920
20982 2020-11-15 Sonoma 97 95492: Windsor 550   -122.812089 38.535639 29920
21867 2020-11-14 Sonoma 97 95492: Windsor 550   -122.812089 38.535639 29920
22941 2020-11-13 Sonoma 97 95492: Windsor 550   -122.812089 38.535639 29920
24103 2020-11-12 Sonoma 97 95492: Windsor 548   -122.812089 38.535639 29920
25018 2020-11-11 Sonoma 97 95492: Windsor 546   -122.812089 38.535639 29920
26172 2020-11-10 Sonoma 97 95492: Windsor 544   -122.812089 38.535639 29920
27275 2020-11-09 Sonoma 97 95492: Windsor 541   -122.812089 38.535639 29920
28146 2020-11-08 Sonoma 97 95492: Windsor 534   -122.812089 38.535639 29920
28957 2020-11-07 Sonoma 97 95492: Windsor 534   -122.812089 38.535639 29920
30121 2020-11-06 Sonoma 97 95492: Windsor 533   -122.812089 38.535639 29920
31267 2020-11-05 Sonoma 97 95492: Windsor 527   -122.812089 38.535639 29920
32410 2020-11-04 Sonoma 97 95492: Windsor 518   -122.812089 38.535639 29920
33585 2020-11-03 Sonoma 97 95492: Windsor 516   -122.812089 38.535639 29920
34671 2020-11-02 Sonoma 97 95492: Windsor 508   -122.812089 38.535639 29920
35525 2020-11-01 Sonoma 97 95492: Windsor 498   -122.812089 38.535639 29920
36334 2020-10-31 Sonoma 97 95492: Windsor 497   -122.812089 38.535639 29920
37437 2020-10-30 Sonoma 97 95492: Windsor 493   -122.812089 38.535639 29920
38603 2020-10-29 Sonoma 97 95492: Windsor 489   -122.812089 38.535639 29920
39704 2020-10-28 Sonoma 97 95492: Windsor 482   -122.812089 38.535639 29920
40827 2020-10-27 Sonoma 97 95492: Windsor 475   -122.812089 38.535639 29920
41932 2020-10-26 Sonoma 97 95492: Windsor 471   -122.812089 38.535639 29920
42783 2020-10-25 Sonoma 97 95492: Windsor 465   -122.812089 38.535639 29920
43587 2020-10-24 Sonoma 97 95492: Windsor 461   -122.812089 38.535639 29920
44738 2020-10-23 Sonoma 97 95492: Windsor 461   -122.812089 38.535639 29920
45841 2020-10-22 Sonoma 97 95492: Windsor 460   -122.812089 38.535639 29920
46959 2020-10-21 Sonoma 97 95492: Windsor 457   -122.812089 38.535639 29920
48129 2020-10-20 Sonoma 97 95492: Windsor 451   -122.812089 38.535639 29920
49252 2020-10-19 Sonoma 97 95492: Windsor 446   -122.812089 38.535639 29920
50086 2020-10-18 Sonoma 97 95492: Windsor 444   -122.812089 38.535639 29920
50971 2020-10-17 Sonoma 97 95492: Windsor 444   -122.812089 38.535639 29920
52101 2020-10-16 Sonoma 97 95492: Windsor 439   -122.812089 38.535639 29920
53226 2020-10-15 Sonoma 97 95492: Windsor 436   -122.812089 38.535639 29920
54347 2020-10-14 Sonoma 97 95492: Windsor 433   -122.812089 38.535639 29920
55413 2020-10-13 Sonoma 97 95492: Windsor 433   -122.812089 38.535639 29920
56453 2020-10-12 Sonoma 97 95492: Windsor 429   -122.812089 38.535639 29920
57284 2020-10-11 Sonoma 97 95492: Windsor 427   -122.812089 38.535639 29920
58151 2020-10-10 Sonoma 97 95492: Windsor 426   -122.812089 38.535639 29920
59278 2020-10-09 Sonoma 97 95492: Windsor 424   -122.812089 38.535639 29920
60387 2020-10-08 Sonoma 97 95492: Windsor 420   -122.812089 38.535639 29920
61500 2020-10-07 Sonoma 97 95492: Windsor 417   -122.812089 38.535639 29920
62603 2020-10-06 Sonoma 97 95492: Windsor 417   -122.812089 38.535639 29920
63676 2020-10-05 Sonoma 97 95492: Windsor 413   -122.812089 38.535639 29920
64523 2020-10-04 Sonoma 97 95492: Windsor 409   -122.812089 38.535639 29920
65371 2020-10-03 Sonoma 97 95492: Windsor 408   -122.812089 38.535639 29920
66513 2020-10-02 Sonoma 97 95492: Windsor 406   -122.812089 38.535639 29920
67596 2020-10-01 Sonoma 97 95492: Windsor 403   -122.812089 38.535639 29920
68688 2020-09-30 Sonoma 97 95492: Windsor 401   -122.812089 38.535639 29920
69810 2020-09-29 Sonoma 97 95492: Windsor 398   -122.812089 38.535639 29920
70929 2020-09-28 Sonoma 97 95492: Windsor 396   -122.812089 38.535639 29920
71753 2020-09-27 Sonoma 97 95492: Windsor 392   -122.812089 38.535639 29920
72616 2020-09-26 Sonoma 97 95492: Windsor 392   -122.812089 38.535639 29920
73757 2020-09-25 Sonoma 97 95492: Windsor 390   -122.812089 38.535639 29920
74871 2020-09-24 Sonoma 97 95492: Windsor 381   -122.812089 38.535639 29920
75969 2020-09-23 Sonoma 97 95492: Windsor 373   -122.812089 38.535639 29920
77020 2020-09-22 Sonoma 97 95492: Windsor 366   -122.812089 38.535639 29920
78068 2020-09-21 Sonoma 97 95492: Windsor 361   -122.812089 38.535639 29920
78914 2020-09-20 Sonoma 97 95492: Windsor 353   -122.812089 38.535639 29920
79778 2020-09-19 Sonoma 97 95492: Windsor 351   -122.812089 38.535639 29920
80899 2020-09-18 Sonoma 97 95492: Windsor 350   -122.812089 38.535639 29920
82009 2020-09-17 Sonoma 97 95492: Windsor 345   -122.812089 38.535639 29920
83048 2020-09-16 Sonoma 97 95492: Windsor 345   -122.812089 38.535639 29920
84194 2020-09-15 Sonoma 97 95492: Windsor 345   -122.812089 38.535639 29920
85307 2020-09-14 Sonoma 97 95492: Windsor 340   -122.812089 38.535639 29920
86176 2020-09-13 Sonoma 97 95492: Windsor 336   -122.812089 38.535639 29920
87039 2020-09-12 Sonoma 97 95492: Windsor 335   -122.812089 38.535639 29920
88185 2020-09-11 Sonoma 97 95492: Windsor 335   -122.812089 38.535639 29920
89249 2020-09-10 Sonoma 97 95492: Windsor 333   -122.812089 38.535639 29920
90373 2020-09-09 Sonoma 97 95492: Windsor 329   -122.812089 38.535639 29920
91486 2020-09-08 Sonoma 97 95492: Windsor 327   -122.812089 38.535639 29920
92331 2020-09-07 Sonoma 97 95492: Windsor 320   -122.812089 38.535639 29920
93141 2020-09-06 Sonoma 97 95492: Windsor 320   -122.812089 38.535639 29920
93968 2020-09-05 Sonoma 97 95492: Windsor 318   -122.812089 38.535639 29920
95119 2020-09-04 Sonoma 97 95492: Windsor 317   -122.812089 38.535639 29920
96182 2020-09-03 Sonoma 97 95492: Windsor 312   -122.812089 38.535639 29920
97274 2020-09-02 Sonoma 97 95492: Windsor 309   -122.812089 38.535639 29920
98420 2020-09-01 Sonoma 97 95492: Windsor 303   -122.812089 38.535639 29920
99489 2020-08-31 Sonoma 97 95492: Windsor 296   -122.812089 38.535639 29920
100364 2020-08-30 Sonoma 97 95492: Windsor 293   -122.812089 38.535639 29920
101465 2020-08-29 Sonoma 97 95492: Windsor 292   -122.812089 38.535639 29920
102146 2020-08-28 Sonoma 97 95492: Windsor 292   -122.812089 38.535639 29920
103172 2020-08-27 Sonoma 97 95492: Windsor 291   -122.812089 38.535639 29920
104245 2020-08-26 Sonoma 97 95492: Windsor 289   -122.812089 38.535639 29920
105303 2020-08-25 Sonoma 97 95492: Windsor 285   -122.812089 38.535639 29920
106402 2020-08-24 Sonoma 97 95492: Windsor 274   -122.812089 38.535639 29920
107164 2020-08-23 Sonoma 97 95492: Windsor 272   -122.812089 38.535639 29920
108139 2020-08-22 Sonoma 97 95492: Windsor 271   -122.812089 38.535639 29920
109215 2020-08-21 Sonoma 97 95492: Windsor 267   -122.812089 38.535639 29920
110305 2020-08-20 Sonoma 97 95492: Windsor 266   -122.812089 38.535639 29920
111397 2020-08-19 Sonoma 97 95492: Windsor 261   -122.812089 38.535639 29920
112528 2020-08-18 Sonoma 97 95492: Windsor 256   -122.812089 38.535639 29920
113601 2020-08-17 Sonoma 97 95492: Windsor 252   -122.812089 38.535639 29920
114525 2020-08-16 Sonoma 97 95492: Windsor 244   -122.812089 38.535639 29920
115339 2020-08-15 Sonoma 97 95492: Windsor 239   -122.812089 38.535639 29920
116449 2020-08-14 Sonoma 97 95492: Windsor 236   -122.812089 38.535639 29920

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
);