ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
763 rows where fips = 21069 and state = "Kentucky" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
49325 | 49325 | 2020-04-11 | Fleming | Kentucky | 21069 | 1 | 0 |
51991 | 51991 | 2020-04-12 | Fleming | Kentucky | 21069 | 2 | 0 |
54672 | 54672 | 2020-04-13 | Fleming | Kentucky | 21069 | 2 | 0 |
57368 | 57368 | 2020-04-14 | Fleming | Kentucky | 21069 | 2 | 0 |
60077 | 60077 | 2020-04-15 | Fleming | Kentucky | 21069 | 2 | 0 |
62797 | 62797 | 2020-04-16 | Fleming | Kentucky | 21069 | 2 | 0 |
65536 | 65536 | 2020-04-17 | Fleming | Kentucky | 21069 | 2 | 0 |
68285 | 68285 | 2020-04-18 | Fleming | Kentucky | 21069 | 2 | 0 |
71047 | 71047 | 2020-04-19 | Fleming | Kentucky | 21069 | 2 | 0 |
73819 | 73819 | 2020-04-20 | Fleming | Kentucky | 21069 | 2 | 0 |
76599 | 76599 | 2020-04-21 | Fleming | Kentucky | 21069 | 2 | 0 |
79384 | 79384 | 2020-04-22 | Fleming | Kentucky | 21069 | 2 | 0 |
82181 | 82181 | 2020-04-23 | Fleming | Kentucky | 21069 | 2 | 0 |
84984 | 84984 | 2020-04-24 | Fleming | Kentucky | 21069 | 2 | 0 |
87793 | 87793 | 2020-04-25 | Fleming | Kentucky | 21069 | 2 | 0 |
90609 | 90609 | 2020-04-26 | Fleming | Kentucky | 21069 | 2 | 0 |
93430 | 93430 | 2020-04-27 | Fleming | Kentucky | 21069 | 2 | 0 |
96263 | 96263 | 2020-04-28 | Fleming | Kentucky | 21069 | 2 | 0 |
99109 | 99109 | 2020-04-29 | Fleming | Kentucky | 21069 | 2 | 0 |
101961 | 101961 | 2020-04-30 | Fleming | Kentucky | 21069 | 2 | 0 |
104822 | 104822 | 2020-05-01 | Fleming | Kentucky | 21069 | 2 | 0 |
107687 | 107687 | 2020-05-02 | Fleming | Kentucky | 21069 | 2 | 0 |
110558 | 110558 | 2020-05-03 | Fleming | Kentucky | 21069 | 2 | 0 |
113435 | 113435 | 2020-05-04 | Fleming | Kentucky | 21069 | 2 | 0 |
116317 | 116317 | 2020-05-05 | Fleming | Kentucky | 21069 | 2 | 0 |
119278 | 119278 | 2020-05-06 | Fleming | Kentucky | 21069 | 2 | 0 |
122248 | 122248 | 2020-05-07 | Fleming | Kentucky | 21069 | 2 | 0 |
125230 | 125230 | 2020-05-08 | Fleming | Kentucky | 21069 | 2 | 0 |
128218 | 128218 | 2020-05-09 | Fleming | Kentucky | 21069 | 1 | 0 |
131208 | 131208 | 2020-05-10 | Fleming | Kentucky | 21069 | 1 | 0 |
134199 | 134199 | 2020-05-11 | Fleming | Kentucky | 21069 | 1 | 0 |
137189 | 137189 | 2020-05-12 | Fleming | Kentucky | 21069 | 1 | 0 |
140182 | 140182 | 2020-05-13 | Fleming | Kentucky | 21069 | 1 | 0 |
143178 | 143178 | 2020-05-14 | Fleming | Kentucky | 21069 | 2 | 0 |
146178 | 146178 | 2020-05-15 | Fleming | Kentucky | 21069 | 2 | 0 |
149182 | 149182 | 2020-05-16 | Fleming | Kentucky | 21069 | 2 | 0 |
152193 | 152193 | 2020-05-17 | Fleming | Kentucky | 21069 | 2 | 0 |
155207 | 155207 | 2020-05-18 | Fleming | Kentucky | 21069 | 3 | 0 |
158224 | 158224 | 2020-05-19 | Fleming | Kentucky | 21069 | 3 | 0 |
161250 | 161250 | 2020-05-20 | Fleming | Kentucky | 21069 | 2 | 0 |
164279 | 164279 | 2020-05-21 | Fleming | Kentucky | 21069 | 2 | 0 |
167315 | 167315 | 2020-05-22 | Fleming | Kentucky | 21069 | 2 | 0 |
170353 | 170353 | 2020-05-23 | Fleming | Kentucky | 21069 | 2 | 0 |
173394 | 173394 | 2020-05-24 | Fleming | Kentucky | 21069 | 2 | 0 |
176438 | 176438 | 2020-05-25 | Fleming | Kentucky | 21069 | 2 | 0 |
179482 | 179482 | 2020-05-26 | Fleming | Kentucky | 21069 | 3 | 0 |
182527 | 182527 | 2020-05-27 | Fleming | Kentucky | 21069 | 3 | 0 |
185581 | 185581 | 2020-05-28 | Fleming | Kentucky | 21069 | 3 | 0 |
188639 | 188639 | 2020-05-29 | Fleming | Kentucky | 21069 | 3 | 0 |
191703 | 191703 | 2020-05-30 | Fleming | Kentucky | 21069 | 3 | 0 |
194771 | 194771 | 2020-05-31 | Fleming | Kentucky | 21069 | 3 | 0 |
197842 | 197842 | 2020-06-01 | Fleming | Kentucky | 21069 | 3 | 0 |
200914 | 200914 | 2020-06-02 | Fleming | Kentucky | 21069 | 3 | 0 |
203991 | 203991 | 2020-06-03 | Fleming | Kentucky | 21069 | 2 | 0 |
207072 | 207072 | 2020-06-04 | Fleming | Kentucky | 21069 | 2 | 0 |
210153 | 210153 | 2020-06-05 | Fleming | Kentucky | 21069 | 2 | 0 |
213238 | 213238 | 2020-06-06 | Fleming | Kentucky | 21069 | 2 | 0 |
216325 | 216325 | 2020-06-07 | Fleming | Kentucky | 21069 | 2 | 0 |
219417 | 219417 | 2020-06-08 | Fleming | Kentucky | 21069 | 2 | 0 |
222512 | 222512 | 2020-06-09 | Fleming | Kentucky | 21069 | 2 | 0 |
225608 | 225608 | 2020-06-10 | Fleming | Kentucky | 21069 | 2 | 0 |
228710 | 228710 | 2020-06-11 | Fleming | Kentucky | 21069 | 2 | 0 |
231814 | 231814 | 2020-06-12 | Fleming | Kentucky | 21069 | 4 | 0 |
234919 | 234919 | 2020-06-13 | Fleming | Kentucky | 21069 | 4 | 0 |
238026 | 238026 | 2020-06-14 | Fleming | Kentucky | 21069 | 4 | 0 |
241135 | 241135 | 2020-06-15 | Fleming | Kentucky | 21069 | 6 | 0 |
244246 | 244246 | 2020-06-16 | Fleming | Kentucky | 21069 | 6 | 0 |
247359 | 247359 | 2020-06-17 | Fleming | Kentucky | 21069 | 9 | 0 |
250471 | 250471 | 2020-06-18 | Fleming | Kentucky | 21069 | 10 | 0 |
253586 | 253586 | 2020-06-19 | Fleming | Kentucky | 21069 | 12 | 0 |
256706 | 256706 | 2020-06-20 | Fleming | Kentucky | 21069 | 12 | 0 |
259832 | 259832 | 2020-06-21 | Fleming | Kentucky | 21069 | 12 | 0 |
262961 | 262961 | 2020-06-22 | Fleming | Kentucky | 21069 | 12 | 0 |
266088 | 266088 | 2020-06-23 | Fleming | Kentucky | 21069 | 13 | 0 |
269221 | 269221 | 2020-06-24 | Fleming | Kentucky | 21069 | 14 | 0 |
272357 | 272357 | 2020-06-25 | Fleming | Kentucky | 21069 | 14 | 0 |
275500 | 275500 | 2020-06-26 | Fleming | Kentucky | 21069 | 15 | 0 |
278648 | 278648 | 2020-06-27 | Fleming | Kentucky | 21069 | 17 | 0 |
281796 | 281796 | 2020-06-28 | Fleming | Kentucky | 21069 | 18 | 0 |
284942 | 284942 | 2020-06-29 | Fleming | Kentucky | 21069 | 18 | 0 |
288091 | 288091 | 2020-06-30 | Fleming | Kentucky | 21069 | 20 | 0 |
291241 | 291241 | 2020-07-01 | Fleming | Kentucky | 21069 | 21 | 0 |
294395 | 294395 | 2020-07-02 | Fleming | Kentucky | 21069 | 21 | 0 |
297553 | 297553 | 2020-07-03 | Fleming | Kentucky | 21069 | 21 | 0 |
300715 | 300715 | 2020-07-04 | Fleming | Kentucky | 21069 | 21 | 0 |
303879 | 303879 | 2020-07-05 | Fleming | Kentucky | 21069 | 21 | 0 |
307046 | 307046 | 2020-07-06 | Fleming | Kentucky | 21069 | 25 | 0 |
310214 | 310214 | 2020-07-07 | Fleming | Kentucky | 21069 | 25 | 0 |
313384 | 313384 | 2020-07-08 | Fleming | Kentucky | 21069 | 25 | 0 |
316558 | 316558 | 2020-07-09 | Fleming | Kentucky | 21069 | 25 | 0 |
319733 | 319733 | 2020-07-10 | Fleming | Kentucky | 21069 | 26 | 0 |
322912 | 322912 | 2020-07-11 | Fleming | Kentucky | 21069 | 27 | 0 |
326095 | 326095 | 2020-07-12 | Fleming | Kentucky | 21069 | 30 | 0 |
329281 | 329281 | 2020-07-13 | Fleming | Kentucky | 21069 | 31 | 0 |
332468 | 332468 | 2020-07-14 | Fleming | Kentucky | 21069 | 31 | 0 |
335661 | 335661 | 2020-07-15 | Fleming | Kentucky | 21069 | 31 | 0 |
338857 | 338857 | 2020-07-16 | Fleming | Kentucky | 21069 | 33 | 0 |
342053 | 342053 | 2020-07-17 | Fleming | Kentucky | 21069 | 36 | 0 |
345253 | 345253 | 2020-07-18 | Fleming | Kentucky | 21069 | 38 | 0 |
348454 | 348454 | 2020-07-19 | Fleming | Kentucky | 21069 | 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);