ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
763 rows where county = "Knott" and state = "Kentucky" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
49346 | 49346 | 2020-04-11 | Knott | Kentucky | 21119 | 1 | 0 |
52012 | 52012 | 2020-04-12 | Knott | Kentucky | 21119 | 1 | 0 |
54693 | 54693 | 2020-04-13 | Knott | Kentucky | 21119 | 1 | 0 |
57390 | 57390 | 2020-04-14 | Knott | Kentucky | 21119 | 1 | 0 |
60099 | 60099 | 2020-04-15 | Knott | Kentucky | 21119 | 1 | 0 |
62819 | 62819 | 2020-04-16 | Knott | Kentucky | 21119 | 1 | 0 |
65558 | 65558 | 2020-04-17 | Knott | Kentucky | 21119 | 2 | 0 |
68307 | 68307 | 2020-04-18 | Knott | Kentucky | 21119 | 3 | 0 |
71070 | 71070 | 2020-04-19 | Knott | Kentucky | 21119 | 3 | 0 |
73842 | 73842 | 2020-04-20 | Knott | Kentucky | 21119 | 3 | 0 |
76623 | 76623 | 2020-04-21 | Knott | Kentucky | 21119 | 3 | 0 |
79408 | 79408 | 2020-04-22 | Knott | Kentucky | 21119 | 4 | 0 |
82205 | 82205 | 2020-04-23 | Knott | Kentucky | 21119 | 4 | 0 |
85008 | 85008 | 2020-04-24 | Knott | Kentucky | 21119 | 4 | 0 |
87817 | 87817 | 2020-04-25 | Knott | Kentucky | 21119 | 4 | 0 |
90633 | 90633 | 2020-04-26 | Knott | Kentucky | 21119 | 4 | 0 |
93454 | 93454 | 2020-04-27 | Knott | Kentucky | 21119 | 4 | 0 |
96287 | 96287 | 2020-04-28 | Knott | Kentucky | 21119 | 3 | 0 |
99133 | 99133 | 2020-04-29 | Knott | Kentucky | 21119 | 3 | 0 |
101985 | 101985 | 2020-04-30 | Knott | Kentucky | 21119 | 4 | 0 |
104846 | 104846 | 2020-05-01 | Knott | Kentucky | 21119 | 4 | 0 |
107711 | 107711 | 2020-05-02 | Knott | Kentucky | 21119 | 4 | 0 |
110582 | 110582 | 2020-05-03 | Knott | Kentucky | 21119 | 4 | 0 |
113459 | 113459 | 2020-05-04 | Knott | Kentucky | 21119 | 4 | 0 |
116341 | 116341 | 2020-05-05 | Knott | Kentucky | 21119 | 4 | 0 |
119302 | 119302 | 2020-05-06 | Knott | Kentucky | 21119 | 4 | 0 |
122273 | 122273 | 2020-05-07 | Knott | Kentucky | 21119 | 4 | 0 |
125255 | 125255 | 2020-05-08 | Knott | Kentucky | 21119 | 4 | 0 |
128243 | 128243 | 2020-05-09 | Knott | Kentucky | 21119 | 4 | 0 |
131233 | 131233 | 2020-05-10 | Knott | Kentucky | 21119 | 4 | 0 |
134224 | 134224 | 2020-05-11 | Knott | Kentucky | 21119 | 4 | 0 |
137214 | 137214 | 2020-05-12 | Knott | Kentucky | 21119 | 4 | 0 |
140207 | 140207 | 2020-05-13 | Knott | Kentucky | 21119 | 4 | 0 |
143203 | 143203 | 2020-05-14 | Knott | Kentucky | 21119 | 4 | 0 |
146203 | 146203 | 2020-05-15 | Knott | Kentucky | 21119 | 4 | 0 |
149207 | 149207 | 2020-05-16 | Knott | Kentucky | 21119 | 4 | 0 |
152218 | 152218 | 2020-05-17 | Knott | Kentucky | 21119 | 4 | 0 |
155232 | 155232 | 2020-05-18 | Knott | Kentucky | 21119 | 4 | 0 |
158249 | 158249 | 2020-05-19 | Knott | Kentucky | 21119 | 4 | 0 |
161275 | 161275 | 2020-05-20 | Knott | Kentucky | 21119 | 4 | 0 |
164304 | 164304 | 2020-05-21 | Knott | Kentucky | 21119 | 4 | 0 |
167340 | 167340 | 2020-05-22 | Knott | Kentucky | 21119 | 4 | 0 |
170378 | 170378 | 2020-05-23 | Knott | Kentucky | 21119 | 4 | 0 |
173419 | 173419 | 2020-05-24 | Knott | Kentucky | 21119 | 4 | 0 |
176463 | 176463 | 2020-05-25 | Knott | Kentucky | 21119 | 4 | 0 |
179507 | 179507 | 2020-05-26 | Knott | Kentucky | 21119 | 4 | 0 |
182552 | 182552 | 2020-05-27 | Knott | Kentucky | 21119 | 4 | 0 |
185606 | 185606 | 2020-05-28 | Knott | Kentucky | 21119 | 4 | 0 |
188664 | 188664 | 2020-05-29 | Knott | Kentucky | 21119 | 4 | 0 |
191728 | 191728 | 2020-05-30 | Knott | Kentucky | 21119 | 4 | 0 |
194796 | 194796 | 2020-05-31 | Knott | Kentucky | 21119 | 4 | 0 |
197867 | 197867 | 2020-06-01 | Knott | Kentucky | 21119 | 4 | 0 |
200939 | 200939 | 2020-06-02 | Knott | Kentucky | 21119 | 4 | 0 |
204016 | 204016 | 2020-06-03 | Knott | Kentucky | 21119 | 4 | 0 |
207097 | 207097 | 2020-06-04 | Knott | Kentucky | 21119 | 4 | 0 |
210178 | 210178 | 2020-06-05 | Knott | Kentucky | 21119 | 4 | 0 |
213263 | 213263 | 2020-06-06 | Knott | Kentucky | 21119 | 4 | 0 |
216350 | 216350 | 2020-06-07 | Knott | Kentucky | 21119 | 4 | 0 |
219442 | 219442 | 2020-06-08 | Knott | Kentucky | 21119 | 4 | 0 |
222537 | 222537 | 2020-06-09 | Knott | Kentucky | 21119 | 4 | 0 |
225633 | 225633 | 2020-06-10 | Knott | Kentucky | 21119 | 4 | 0 |
228735 | 228735 | 2020-06-11 | Knott | Kentucky | 21119 | 4 | 0 |
231839 | 231839 | 2020-06-12 | Knott | Kentucky | 21119 | 4 | 0 |
234944 | 234944 | 2020-06-13 | Knott | Kentucky | 21119 | 4 | 0 |
238051 | 238051 | 2020-06-14 | Knott | Kentucky | 21119 | 4 | 0 |
241160 | 241160 | 2020-06-15 | Knott | Kentucky | 21119 | 4 | 0 |
244271 | 244271 | 2020-06-16 | Knott | Kentucky | 21119 | 4 | 0 |
247384 | 247384 | 2020-06-17 | Knott | Kentucky | 21119 | 4 | 0 |
250496 | 250496 | 2020-06-18 | Knott | Kentucky | 21119 | 4 | 0 |
253611 | 253611 | 2020-06-19 | Knott | Kentucky | 21119 | 4 | 0 |
256731 | 256731 | 2020-06-20 | Knott | Kentucky | 21119 | 4 | 0 |
259857 | 259857 | 2020-06-21 | Knott | Kentucky | 21119 | 4 | 0 |
262986 | 262986 | 2020-06-22 | Knott | Kentucky | 21119 | 4 | 0 |
266113 | 266113 | 2020-06-23 | Knott | Kentucky | 21119 | 4 | 0 |
269246 | 269246 | 2020-06-24 | Knott | Kentucky | 21119 | 5 | 0 |
272382 | 272382 | 2020-06-25 | Knott | Kentucky | 21119 | 7 | 0 |
275525 | 275525 | 2020-06-26 | Knott | Kentucky | 21119 | 7 | 0 |
278673 | 278673 | 2020-06-27 | Knott | Kentucky | 21119 | 7 | 0 |
281821 | 281821 | 2020-06-28 | Knott | Kentucky | 21119 | 7 | 0 |
284967 | 284967 | 2020-06-29 | Knott | Kentucky | 21119 | 7 | 0 |
288116 | 288116 | 2020-06-30 | Knott | Kentucky | 21119 | 7 | 0 |
291266 | 291266 | 2020-07-01 | Knott | Kentucky | 21119 | 8 | 0 |
294420 | 294420 | 2020-07-02 | Knott | Kentucky | 21119 | 10 | 0 |
297578 | 297578 | 2020-07-03 | Knott | Kentucky | 21119 | 11 | 0 |
300740 | 300740 | 2020-07-04 | Knott | Kentucky | 21119 | 11 | 0 |
303904 | 303904 | 2020-07-05 | Knott | Kentucky | 21119 | 11 | 0 |
307071 | 307071 | 2020-07-06 | Knott | Kentucky | 21119 | 11 | 0 |
310239 | 310239 | 2020-07-07 | Knott | Kentucky | 21119 | 12 | 0 |
313409 | 313409 | 2020-07-08 | Knott | Kentucky | 21119 | 14 | 0 |
316583 | 316583 | 2020-07-09 | Knott | Kentucky | 21119 | 14 | 0 |
319758 | 319758 | 2020-07-10 | Knott | Kentucky | 21119 | 15 | 0 |
322937 | 322937 | 2020-07-11 | Knott | Kentucky | 21119 | 16 | 0 |
326120 | 326120 | 2020-07-12 | Knott | Kentucky | 21119 | 17 | 0 |
329306 | 329306 | 2020-07-13 | Knott | Kentucky | 21119 | 20 | 0 |
332493 | 332493 | 2020-07-14 | Knott | Kentucky | 21119 | 23 | 0 |
335686 | 335686 | 2020-07-15 | Knott | Kentucky | 21119 | 23 | 0 |
338882 | 338882 | 2020-07-16 | Knott | Kentucky | 21119 | 23 | 0 |
342078 | 342078 | 2020-07-17 | Knott | Kentucky | 21119 | 24 | 0 |
345278 | 345278 | 2020-07-18 | Knott | Kentucky | 21119 | 24 | 0 |
348479 | 348479 | 2020-07-19 | Knott | Kentucky | 21119 | 26 | 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);