ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Windsor" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2267 | 2267 | 2020-03-14 | Windsor | Vermont | 50027 | 2 | 0 |
2694 | 2694 | 2020-03-15 | Windsor | Vermont | 50027 | 3 | 0 |
3166 | 3166 | 2020-03-16 | Windsor | Vermont | 50027 | 3 | 0 |
3702 | 3702 | 2020-03-17 | Windsor | Vermont | 50027 | 3 | 0 |
4334 | 4334 | 2020-03-18 | Windsor | Vermont | 50027 | 3 | 0 |
5090 | 5090 | 2020-03-19 | Windsor | Vermont | 50027 | 3 | 1 |
5986 | 5986 | 2020-03-20 | Windsor | Vermont | 50027 | 6 | 1 |
7011 | 7011 | 2020-03-21 | Windsor | Vermont | 50027 | 8 | 1 |
8141 | 8141 | 2020-03-22 | Windsor | Vermont | 50027 | 8 | 1 |
9362 | 9362 | 2020-03-23 | Windsor | Vermont | 50027 | 8 | 1 |
10708 | 10708 | 2020-03-24 | Windsor | Vermont | 50027 | 15 | 1 |
12220 | 12220 | 2020-03-25 | Windsor | Vermont | 50027 | 17 | 1 |
13856 | 13856 | 2020-03-26 | Windsor | Vermont | 50027 | 17 | 1 |
15622 | 15622 | 2020-03-27 | Windsor | Vermont | 50027 | 18 | 1 |
17496 | 17496 | 2020-03-28 | Windsor | Vermont | 50027 | 18 | 1 |
19455 | 19455 | 2020-03-29 | Windsor | Vermont | 50027 | 18 | 1 |
21518 | 21518 | 2020-03-30 | Windsor | Vermont | 50027 | 18 | 1 |
23657 | 23657 | 2020-03-31 | Windsor | Vermont | 50027 | 18 | 1 |
25872 | 25872 | 2020-04-01 | Windsor | Vermont | 50027 | 18 | 1 |
28161 | 28161 | 2020-04-02 | Windsor | Vermont | 50027 | 20 | 1 |
30504 | 30504 | 2020-04-03 | Windsor | Vermont | 50027 | 20 | 1 |
32902 | 32902 | 2020-04-04 | Windsor | Vermont | 50027 | 24 | 1 |
35340 | 35340 | 2020-04-05 | Windsor | Vermont | 50027 | 22 | 1 |
37818 | 37818 | 2020-04-06 | Windsor | Vermont | 50027 | 22 | 1 |
40348 | 40348 | 2020-04-07 | Windsor | Vermont | 50027 | 24 | 1 |
42917 | 42917 | 2020-04-08 | Windsor | Vermont | 50027 | 24 | 2 |
45511 | 45511 | 2020-04-09 | Windsor | Vermont | 50027 | 24 | 2 |
48135 | 48135 | 2020-04-10 | Windsor | Vermont | 50027 | 24 | 2 |
50793 | 50793 | 2020-04-11 | Windsor | Vermont | 50027 | 25 | 2 |
53468 | 53468 | 2020-04-12 | Windsor | Vermont | 50027 | 25 | 2 |
56157 | 56157 | 2020-04-13 | Windsor | Vermont | 50027 | 27 | 2 |
58863 | 58863 | 2020-04-14 | Windsor | Vermont | 50027 | 27 | 2 |
61582 | 61582 | 2020-04-15 | Windsor | Vermont | 50027 | 29 | 2 |
64314 | 64314 | 2020-04-16 | Windsor | Vermont | 50027 | 31 | 2 |
67062 | 67062 | 2020-04-17 | Windsor | Vermont | 50027 | 33 | 2 |
69824 | 69824 | 2020-04-18 | Windsor | Vermont | 50027 | 34 | 2 |
72594 | 72594 | 2020-04-19 | Windsor | Vermont | 50027 | 37 | 2 |
75370 | 75370 | 2020-04-20 | Windsor | Vermont | 50027 | 37 | 2 |
78152 | 78152 | 2020-04-21 | Windsor | Vermont | 50027 | 38 | 2 |
80944 | 80944 | 2020-04-22 | Windsor | Vermont | 50027 | 38 | 2 |
83745 | 83745 | 2020-04-23 | Windsor | Vermont | 50027 | 38 | 2 |
86552 | 86552 | 2020-04-24 | Windsor | Vermont | 50027 | 38 | 2 |
89367 | 89367 | 2020-04-25 | Windsor | Vermont | 50027 | 39 | 2 |
92184 | 92184 | 2020-04-26 | Windsor | Vermont | 50027 | 39 | 2 |
95013 | 95013 | 2020-04-27 | Windsor | Vermont | 50027 | 40 | 2 |
97855 | 97855 | 2020-04-28 | Windsor | Vermont | 50027 | 40 | 2 |
100705 | 100705 | 2020-04-29 | Windsor | Vermont | 50027 | 40 | 2 |
103560 | 103560 | 2020-04-30 | Windsor | Vermont | 50027 | 40 | 2 |
106424 | 106424 | 2020-05-01 | Windsor | Vermont | 50027 | 40 | 2 |
109293 | 109293 | 2020-05-02 | Windsor | Vermont | 50027 | 41 | 2 |
112167 | 112167 | 2020-05-03 | Windsor | Vermont | 50027 | 42 | 2 |
115050 | 115050 | 2020-05-04 | Windsor | Vermont | 50027 | 43 | 2 |
118009 | 118009 | 2020-05-05 | Windsor | Vermont | 50027 | 43 | 2 |
120973 | 120973 | 2020-05-06 | Windsor | Vermont | 50027 | 44 | 2 |
123954 | 123954 | 2020-05-07 | Windsor | Vermont | 50027 | 46 | 2 |
126939 | 126939 | 2020-05-08 | Windsor | Vermont | 50027 | 46 | 2 |
129928 | 129928 | 2020-05-09 | Windsor | Vermont | 50027 | 46 | 2 |
132918 | 132918 | 2020-05-10 | Windsor | Vermont | 50027 | 45 | 2 |
135908 | 135908 | 2020-05-11 | Windsor | Vermont | 50027 | 45 | 2 |
138899 | 138899 | 2020-05-12 | Windsor | Vermont | 50027 | 45 | 2 |
141895 | 141895 | 2020-05-13 | Windsor | Vermont | 50027 | 46 | 2 |
144892 | 144892 | 2020-05-14 | Windsor | Vermont | 50027 | 47 | 2 |
147895 | 147895 | 2020-05-15 | Windsor | Vermont | 50027 | 47 | 2 |
150904 | 150904 | 2020-05-16 | Windsor | Vermont | 50027 | 47 | 2 |
153915 | 153915 | 2020-05-17 | Windsor | Vermont | 50027 | 47 | 2 |
156932 | 156932 | 2020-05-18 | Windsor | Vermont | 50027 | 47 | 2 |
159956 | 159956 | 2020-05-19 | Windsor | Vermont | 50027 | 48 | 2 |
162984 | 162984 | 2020-05-20 | Windsor | Vermont | 50027 | 48 | 2 |
166013 | 166013 | 2020-05-21 | Windsor | Vermont | 50027 | 49 | 2 |
169049 | 169049 | 2020-05-22 | Windsor | Vermont | 50027 | 49 | 2 |
172090 | 172090 | 2020-05-23 | Windsor | Vermont | 50027 | 49 | 2 |
175133 | 175133 | 2020-05-24 | Windsor | Vermont | 50027 | 49 | 2 |
178178 | 178178 | 2020-05-25 | Windsor | Vermont | 50027 | 50 | 2 |
181222 | 181222 | 2020-05-26 | Windsor | Vermont | 50027 | 51 | 2 |
184273 | 184273 | 2020-05-27 | Windsor | Vermont | 50027 | 51 | 2 |
187330 | 187330 | 2020-05-28 | Windsor | Vermont | 50027 | 51 | 2 |
190394 | 190394 | 2020-05-29 | Windsor | Vermont | 50027 | 51 | 2 |
193460 | 193460 | 2020-05-30 | Windsor | Vermont | 50027 | 51 | 2 |
196530 | 196530 | 2020-05-31 | Windsor | Vermont | 50027 | 51 | 2 |
199603 | 199603 | 2020-06-01 | Windsor | Vermont | 50027 | 51 | 2 |
202679 | 202679 | 2020-06-02 | Windsor | Vermont | 50027 | 51 | 2 |
205758 | 205758 | 2020-06-03 | Windsor | Vermont | 50027 | 52 | 2 |
208840 | 208840 | 2020-06-04 | Windsor | Vermont | 50027 | 52 | 2 |
211925 | 211925 | 2020-06-05 | Windsor | Vermont | 50027 | 52 | 2 |
215012 | 215012 | 2020-06-06 | Windsor | Vermont | 50027 | 55 | 2 |
218102 | 218102 | 2020-06-07 | Windsor | Vermont | 50027 | 55 | 2 |
221194 | 221194 | 2020-06-08 | Windsor | Vermont | 50027 | 55 | 2 |
224290 | 224290 | 2020-06-09 | Windsor | Vermont | 50027 | 56 | 2 |
227390 | 227390 | 2020-06-10 | Windsor | Vermont | 50027 | 56 | 2 |
230494 | 230494 | 2020-06-11 | Windsor | Vermont | 50027 | 55 | 2 |
233599 | 233599 | 2020-06-12 | Windsor | Vermont | 50027 | 55 | 2 |
236706 | 236706 | 2020-06-13 | Windsor | Vermont | 50027 | 55 | 2 |
239814 | 239814 | 2020-06-14 | Windsor | Vermont | 50027 | 55 | 2 |
242925 | 242925 | 2020-06-15 | Windsor | Vermont | 50027 | 55 | 2 |
246037 | 246037 | 2020-06-16 | Windsor | Vermont | 50027 | 55 | 2 |
249149 | 249149 | 2020-06-17 | Windsor | Vermont | 50027 | 55 | 2 |
252264 | 252264 | 2020-06-18 | Windsor | Vermont | 50027 | 55 | 2 |
255382 | 255382 | 2020-06-19 | Windsor | Vermont | 50027 | 55 | 2 |
258509 | 258509 | 2020-06-20 | Windsor | Vermont | 50027 | 55 | 2 |
261636 | 261636 | 2020-06-21 | Windsor | Vermont | 50027 | 55 | 2 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);