ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Montgomery" and state = "New York" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2573 | 2573 | 2020-03-15 | Montgomery | New York | 36057 | 1 | 0 |
3032 | 3032 | 2020-03-16 | Montgomery | New York | 36057 | 1 | 0 |
3548 | 3548 | 2020-03-17 | Montgomery | New York | 36057 | 1 | 0 |
4149 | 4149 | 2020-03-18 | Montgomery | New York | 36057 | 1 | 0 |
4878 | 4878 | 2020-03-19 | Montgomery | New York | 36057 | 1 | 0 |
5727 | 5727 | 2020-03-20 | Montgomery | New York | 36057 | 2 | 0 |
6721 | 6721 | 2020-03-21 | Montgomery | New York | 36057 | 3 | 0 |
7816 | 7816 | 2020-03-22 | Montgomery | New York | 36057 | 3 | 0 |
9014 | 9014 | 2020-03-23 | Montgomery | New York | 36057 | 3 | 0 |
10321 | 10321 | 2020-03-24 | Montgomery | New York | 36057 | 3 | 0 |
11757 | 11757 | 2020-03-25 | Montgomery | New York | 36057 | 4 | 0 |
13360 | 13360 | 2020-03-26 | Montgomery | New York | 36057 | 5 | 0 |
15094 | 15094 | 2020-03-27 | Montgomery | New York | 36057 | 5 | 0 |
16924 | 16924 | 2020-03-28 | Montgomery | New York | 36057 | 5 | 0 |
18849 | 18849 | 2020-03-29 | Montgomery | New York | 36057 | 6 | 0 |
20888 | 20888 | 2020-03-30 | Montgomery | New York | 36057 | 6 | 0 |
23011 | 23011 | 2020-03-31 | Montgomery | New York | 36057 | 7 | 0 |
25205 | 25205 | 2020-04-01 | Montgomery | New York | 36057 | 7 | 0 |
27465 | 27465 | 2020-04-02 | Montgomery | New York | 36057 | 8 | 0 |
29789 | 29789 | 2020-04-03 | Montgomery | New York | 36057 | 8 | 0 |
32175 | 32175 | 2020-04-04 | Montgomery | New York | 36057 | 13 | 1 |
34606 | 34606 | 2020-04-05 | Montgomery | New York | 36057 | 15 | 1 |
37076 | 37076 | 2020-04-06 | Montgomery | New York | 36057 | 15 | 1 |
39591 | 39591 | 2020-04-07 | Montgomery | New York | 36057 | 18 | 1 |
42148 | 42148 | 2020-04-08 | Montgomery | New York | 36057 | 18 | 1 |
44731 | 44731 | 2020-04-09 | Montgomery | New York | 36057 | 28 | 1 |
47344 | 47344 | 2020-04-10 | Montgomery | New York | 36057 | 29 | 1 |
49999 | 49999 | 2020-04-11 | Montgomery | New York | 36057 | 29 | 1 |
52672 | 52672 | 2020-04-12 | Montgomery | New York | 36057 | 29 | 1 |
55355 | 55355 | 2020-04-13 | Montgomery | New York | 36057 | 29 | 1 |
58055 | 58055 | 2020-04-14 | Montgomery | New York | 36057 | 32 | 1 |
60769 | 60769 | 2020-04-15 | Montgomery | New York | 36057 | 32 | 1 |
63495 | 63495 | 2020-04-16 | Montgomery | New York | 36057 | 32 | 1 |
66237 | 66237 | 2020-04-17 | Montgomery | New York | 36057 | 33 | 1 |
68994 | 68994 | 2020-04-18 | Montgomery | New York | 36057 | 34 | 1 |
71761 | 71761 | 2020-04-19 | Montgomery | New York | 36057 | 35 | 1 |
74536 | 74536 | 2020-04-20 | Montgomery | New York | 36057 | 35 | 1 |
77317 | 77317 | 2020-04-21 | Montgomery | New York | 36057 | 37 | 1 |
80106 | 80106 | 2020-04-22 | Montgomery | New York | 36057 | 38 | 1 |
82905 | 82905 | 2020-04-23 | Montgomery | New York | 36057 | 39 | 1 |
85709 | 85709 | 2020-04-24 | Montgomery | New York | 36057 | 39 | 1 |
88521 | 88521 | 2020-04-25 | Montgomery | New York | 36057 | 46 | 1 |
91336 | 91336 | 2020-04-26 | Montgomery | New York | 36057 | 47 | 1 |
94161 | 94161 | 2020-04-27 | Montgomery | New York | 36057 | 47 | 1 |
96997 | 96997 | 2020-04-28 | Montgomery | New York | 36057 | 49 | 1 |
99844 | 99844 | 2020-04-29 | Montgomery | New York | 36057 | 51 | 1 |
102697 | 102697 | 2020-04-30 | Montgomery | New York | 36057 | 53 | 1 |
105559 | 105559 | 2020-05-01 | Montgomery | New York | 36057 | 54 | 1 |
108426 | 108426 | 2020-05-02 | Montgomery | New York | 36057 | 54 | 1 |
111299 | 111299 | 2020-05-03 | Montgomery | New York | 36057 | 56 | 1 |
114180 | 114180 | 2020-05-04 | Montgomery | New York | 36057 | 56 | 1 |
117060 | 117060 | 2020-05-05 | Montgomery | New York | 36057 | 61 | 1 |
120021 | 120021 | 2020-05-06 | Montgomery | New York | 36057 | 63 | 1 |
122996 | 122996 | 2020-05-07 | Montgomery | New York | 36057 | 63 | 2 |
125979 | 125979 | 2020-05-08 | Montgomery | New York | 36057 | 64 | 2 |
128968 | 128968 | 2020-05-09 | Montgomery | New York | 36057 | 66 | 2 |
131957 | 131957 | 2020-05-10 | Montgomery | New York | 36057 | 67 | 2 |
134948 | 134948 | 2020-05-11 | Montgomery | New York | 36057 | 67 | 3 |
137938 | 137938 | 2020-05-12 | Montgomery | New York | 36057 | 67 | 3 |
140934 | 140934 | 2020-05-13 | Montgomery | New York | 36057 | 68 | 3 |
143929 | 143929 | 2020-05-14 | Montgomery | New York | 36057 | 69 | 3 |
146930 | 146930 | 2020-05-15 | Montgomery | New York | 36057 | 72 | 3 |
149937 | 149937 | 2020-05-16 | Montgomery | New York | 36057 | 75 | 3 |
152947 | 152947 | 2020-05-17 | Montgomery | New York | 36057 | 75 | 3 |
155964 | 155964 | 2020-05-18 | Montgomery | New York | 36057 | 75 | 3 |
158982 | 158982 | 2020-05-19 | Montgomery | New York | 36057 | 75 | 3 |
162009 | 162009 | 2020-05-20 | Montgomery | New York | 36057 | 75 | 3 |
165038 | 165038 | 2020-05-21 | Montgomery | New York | 36057 | 77 | 3 |
168073 | 168073 | 2020-05-22 | Montgomery | New York | 36057 | 77 | 4 |
171112 | 171112 | 2020-05-23 | Montgomery | New York | 36057 | 77 | 4 |
174154 | 174154 | 2020-05-24 | Montgomery | New York | 36057 | 79 | 4 |
177198 | 177198 | 2020-05-25 | Montgomery | New York | 36057 | 79 | 4 |
180241 | 180241 | 2020-05-26 | Montgomery | New York | 36057 | 80 | 4 |
183289 | 183289 | 2020-05-27 | Montgomery | New York | 36057 | 82 | 4 |
186346 | 186346 | 2020-05-28 | Montgomery | New York | 36057 | 82 | 4 |
189406 | 189406 | 2020-05-29 | Montgomery | New York | 36057 | 84 | 4 |
192470 | 192470 | 2020-05-30 | Montgomery | New York | 36057 | 89 | 4 |
195540 | 195540 | 2020-05-31 | Montgomery | New York | 36057 | 91 | 5 |
198613 | 198613 | 2020-06-01 | Montgomery | New York | 36057 | 91 | 5 |
201687 | 201687 | 2020-06-02 | Montgomery | New York | 36057 | 93 | 5 |
204764 | 204764 | 2020-06-03 | Montgomery | New York | 36057 | 94 | 5 |
207845 | 207845 | 2020-06-04 | Montgomery | New York | 36057 | 96 | 5 |
210927 | 210927 | 2020-06-05 | Montgomery | New York | 36057 | 96 | 5 |
214011 | 214011 | 2020-06-06 | Montgomery | New York | 36057 | 98 | 5 |
217101 | 217101 | 2020-06-07 | Montgomery | New York | 36057 | 100 | 5 |
220193 | 220193 | 2020-06-08 | Montgomery | New York | 36057 | 100 | 5 |
223287 | 223287 | 2020-06-09 | Montgomery | New York | 36057 | 100 | 5 |
226387 | 226387 | 2020-06-10 | Montgomery | New York | 36057 | 100 | 5 |
229491 | 229491 | 2020-06-11 | Montgomery | New York | 36057 | 101 | 5 |
232596 | 232596 | 2020-06-12 | Montgomery | New York | 36057 | 103 | 5 |
235701 | 235701 | 2020-06-13 | Montgomery | New York | 36057 | 103 | 5 |
238809 | 238809 | 2020-06-14 | Montgomery | New York | 36057 | 104 | 5 |
241918 | 241918 | 2020-06-15 | Montgomery | New York | 36057 | 104 | 5 |
245030 | 245030 | 2020-06-16 | Montgomery | New York | 36057 | 104 | 5 |
248143 | 248143 | 2020-06-17 | Montgomery | New York | 36057 | 104 | 5 |
251258 | 251258 | 2020-06-18 | Montgomery | New York | 36057 | 105 | 5 |
254373 | 254373 | 2020-06-19 | Montgomery | New York | 36057 | 106 | 5 |
257496 | 257496 | 2020-06-20 | Montgomery | New York | 36057 | 106 | 5 |
260623 | 260623 | 2020-06-21 | Montgomery | New York | 36057 | 106 | 5 |
263751 | 263751 | 2020-06-22 | Montgomery | New York | 36057 | 108 | 5 |
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);