ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Montgomery", fips = 21173 and state = "Kentucky" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1463 | 1463 | 2020-03-12 | Montgomery | Kentucky | 21173 | 1 | 0 |
1736 | 1736 | 2020-03-13 | Montgomery | Kentucky | 21173 | 1 | 0 |
2072 | 2072 | 2020-03-14 | Montgomery | Kentucky | 21173 | 1 | 0 |
2469 | 2469 | 2020-03-15 | Montgomery | Kentucky | 21173 | 1 | 0 |
2914 | 2914 | 2020-03-16 | Montgomery | Kentucky | 21173 | 1 | 0 |
3410 | 3410 | 2020-03-17 | Montgomery | Kentucky | 21173 | 2 | 0 |
3989 | 3989 | 2020-03-18 | Montgomery | Kentucky | 21173 | 2 | 0 |
4677 | 4677 | 2020-03-19 | Montgomery | Kentucky | 21173 | 2 | 0 |
5491 | 5491 | 2020-03-20 | Montgomery | Kentucky | 21173 | 2 | 0 |
6438 | 6438 | 2020-03-21 | Montgomery | Kentucky | 21173 | 2 | 0 |
7511 | 7511 | 2020-03-22 | Montgomery | Kentucky | 21173 | 2 | 0 |
8674 | 8674 | 2020-03-23 | Montgomery | Kentucky | 21173 | 2 | 0 |
9960 | 9960 | 2020-03-24 | Montgomery | Kentucky | 21173 | 2 | 0 |
11363 | 11363 | 2020-03-25 | Montgomery | Kentucky | 21173 | 2 | 0 |
12936 | 12936 | 2020-03-26 | Montgomery | Kentucky | 21173 | 2 | 0 |
14642 | 14642 | 2020-03-27 | Montgomery | Kentucky | 21173 | 2 | 0 |
16457 | 16457 | 2020-03-28 | Montgomery | Kentucky | 21173 | 2 | 0 |
18368 | 18368 | 2020-03-29 | Montgomery | Kentucky | 21173 | 2 | 0 |
20384 | 20384 | 2020-03-30 | Montgomery | Kentucky | 21173 | 2 | 0 |
22489 | 22489 | 2020-03-31 | Montgomery | Kentucky | 21173 | 3 | 0 |
24665 | 24665 | 2020-04-01 | Montgomery | Kentucky | 21173 | 5 | 0 |
26914 | 26914 | 2020-04-02 | Montgomery | Kentucky | 21173 | 6 | 0 |
29230 | 29230 | 2020-04-03 | Montgomery | Kentucky | 21173 | 6 | 0 |
31606 | 31606 | 2020-04-04 | Montgomery | Kentucky | 21173 | 6 | 0 |
34030 | 34030 | 2020-04-05 | Montgomery | Kentucky | 21173 | 7 | 0 |
36488 | 36488 | 2020-04-06 | Montgomery | Kentucky | 21173 | 7 | 0 |
38995 | 38995 | 2020-04-07 | Montgomery | Kentucky | 21173 | 7 | 0 |
41545 | 41545 | 2020-04-08 | Montgomery | Kentucky | 21173 | 7 | 0 |
44121 | 44121 | 2020-04-09 | Montgomery | Kentucky | 21173 | 7 | 0 |
46729 | 46729 | 2020-04-10 | Montgomery | Kentucky | 21173 | 8 | 0 |
49369 | 49369 | 2020-04-11 | Montgomery | Kentucky | 21173 | 8 | 0 |
52035 | 52035 | 2020-04-12 | Montgomery | Kentucky | 21173 | 8 | 0 |
54716 | 54716 | 2020-04-13 | Montgomery | Kentucky | 21173 | 8 | 0 |
57414 | 57414 | 2020-04-14 | Montgomery | Kentucky | 21173 | 8 | 0 |
60123 | 60123 | 2020-04-15 | Montgomery | Kentucky | 21173 | 8 | 0 |
62843 | 62843 | 2020-04-16 | Montgomery | Kentucky | 21173 | 9 | 0 |
65582 | 65582 | 2020-04-17 | Montgomery | Kentucky | 21173 | 9 | 0 |
68331 | 68331 | 2020-04-18 | Montgomery | Kentucky | 21173 | 9 | 0 |
71094 | 71094 | 2020-04-19 | Montgomery | Kentucky | 21173 | 9 | 0 |
73866 | 73866 | 2020-04-20 | Montgomery | Kentucky | 21173 | 9 | 0 |
76647 | 76647 | 2020-04-21 | Montgomery | Kentucky | 21173 | 9 | 0 |
79432 | 79432 | 2020-04-22 | Montgomery | Kentucky | 21173 | 9 | 0 |
82229 | 82229 | 2020-04-23 | Montgomery | Kentucky | 21173 | 9 | 0 |
85032 | 85032 | 2020-04-24 | Montgomery | Kentucky | 21173 | 10 | 0 |
87841 | 87841 | 2020-04-25 | Montgomery | Kentucky | 21173 | 10 | 0 |
90657 | 90657 | 2020-04-26 | Montgomery | Kentucky | 21173 | 10 | 0 |
93478 | 93478 | 2020-04-27 | Montgomery | Kentucky | 21173 | 10 | 0 |
96312 | 96312 | 2020-04-28 | Montgomery | Kentucky | 21173 | 11 | 0 |
99158 | 99158 | 2020-04-29 | Montgomery | Kentucky | 21173 | 11 | 0 |
102010 | 102010 | 2020-04-30 | Montgomery | Kentucky | 21173 | 11 | 0 |
104871 | 104871 | 2020-05-01 | Montgomery | Kentucky | 21173 | 12 | 0 |
107736 | 107736 | 2020-05-02 | Montgomery | Kentucky | 21173 | 12 | 0 |
110607 | 110607 | 2020-05-03 | Montgomery | Kentucky | 21173 | 12 | 0 |
113484 | 113484 | 2020-05-04 | Montgomery | Kentucky | 21173 | 12 | 0 |
116366 | 116366 | 2020-05-05 | Montgomery | Kentucky | 21173 | 12 | 0 |
119327 | 119327 | 2020-05-06 | Montgomery | Kentucky | 21173 | 12 | 0 |
122298 | 122298 | 2020-05-07 | Montgomery | Kentucky | 21173 | 12 | 0 |
125280 | 125280 | 2020-05-08 | Montgomery | Kentucky | 21173 | 11 | 0 |
128268 | 128268 | 2020-05-09 | Montgomery | Kentucky | 21173 | 11 | 0 |
131258 | 131258 | 2020-05-10 | Montgomery | Kentucky | 21173 | 11 | 0 |
134249 | 134249 | 2020-05-11 | Montgomery | Kentucky | 21173 | 11 | 0 |
137239 | 137239 | 2020-05-12 | Montgomery | Kentucky | 21173 | 13 | 0 |
140232 | 140232 | 2020-05-13 | Montgomery | Kentucky | 21173 | 13 | 0 |
143228 | 143228 | 2020-05-14 | Montgomery | Kentucky | 21173 | 16 | 0 |
146228 | 146228 | 2020-05-15 | Montgomery | Kentucky | 21173 | 16 | 0 |
149233 | 149233 | 2020-05-16 | Montgomery | Kentucky | 21173 | 16 | 0 |
152244 | 152244 | 2020-05-17 | Montgomery | Kentucky | 21173 | 16 | 0 |
155258 | 155258 | 2020-05-18 | Montgomery | Kentucky | 21173 | 16 | 0 |
158275 | 158275 | 2020-05-19 | Montgomery | Kentucky | 21173 | 16 | 0 |
161301 | 161301 | 2020-05-20 | Montgomery | Kentucky | 21173 | 17 | 0 |
164330 | 164330 | 2020-05-21 | Montgomery | Kentucky | 21173 | 17 | 0 |
167366 | 167366 | 2020-05-22 | Montgomery | Kentucky | 21173 | 17 | 0 |
170404 | 170404 | 2020-05-23 | Montgomery | Kentucky | 21173 | 21 | 0 |
173445 | 173445 | 2020-05-24 | Montgomery | Kentucky | 21173 | 21 | 0 |
176489 | 176489 | 2020-05-25 | Montgomery | Kentucky | 21173 | 21 | 0 |
179533 | 179533 | 2020-05-26 | Montgomery | Kentucky | 21173 | 22 | 0 |
182578 | 182578 | 2020-05-27 | Montgomery | Kentucky | 21173 | 22 | 0 |
185633 | 185633 | 2020-05-28 | Montgomery | Kentucky | 21173 | 23 | 0 |
188691 | 188691 | 2020-05-29 | Montgomery | Kentucky | 21173 | 23 | 0 |
191755 | 191755 | 2020-05-30 | Montgomery | Kentucky | 21173 | 24 | 0 |
194823 | 194823 | 2020-05-31 | Montgomery | Kentucky | 21173 | 24 | 0 |
197894 | 197894 | 2020-06-01 | Montgomery | Kentucky | 21173 | 25 | 0 |
200966 | 200966 | 2020-06-02 | Montgomery | Kentucky | 21173 | 25 | 0 |
204043 | 204043 | 2020-06-03 | Montgomery | Kentucky | 21173 | 25 | 0 |
207124 | 207124 | 2020-06-04 | Montgomery | Kentucky | 21173 | 25 | 0 |
210205 | 210205 | 2020-06-05 | Montgomery | Kentucky | 21173 | 25 | 0 |
213290 | 213290 | 2020-06-06 | Montgomery | Kentucky | 21173 | 30 | 0 |
216377 | 216377 | 2020-06-07 | Montgomery | Kentucky | 21173 | 30 | 0 |
219469 | 219469 | 2020-06-08 | Montgomery | Kentucky | 21173 | 32 | 0 |
222564 | 222564 | 2020-06-09 | Montgomery | Kentucky | 21173 | 32 | 0 |
225660 | 225660 | 2020-06-10 | Montgomery | Kentucky | 21173 | 32 | 0 |
228762 | 228762 | 2020-06-11 | Montgomery | Kentucky | 21173 | 32 | 0 |
231866 | 231866 | 2020-06-12 | Montgomery | Kentucky | 21173 | 33 | 0 |
234971 | 234971 | 2020-06-13 | Montgomery | Kentucky | 21173 | 37 | 0 |
238078 | 238078 | 2020-06-14 | Montgomery | Kentucky | 21173 | 39 | 0 |
241187 | 241187 | 2020-06-15 | Montgomery | Kentucky | 21173 | 39 | 0 |
244298 | 244298 | 2020-06-16 | Montgomery | Kentucky | 21173 | 39 | 0 |
247411 | 247411 | 2020-06-17 | Montgomery | Kentucky | 21173 | 40 | 0 |
250523 | 250523 | 2020-06-18 | Montgomery | Kentucky | 21173 | 41 | 0 |
253638 | 253638 | 2020-06-19 | Montgomery | Kentucky | 21173 | 41 | 0 |
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);