ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 21059 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386962 | 386962 | 2020-07-31 | Daviess | Kentucky | 21059 | 689 | 7 |
383744 | 383744 | 2020-07-30 | Daviess | Kentucky | 21059 | 685 | 7 |
380527 | 380527 | 2020-07-29 | Daviess | Kentucky | 21059 | 671 | 7 |
377310 | 377310 | 2020-07-28 | Daviess | Kentucky | 21059 | 661 | 7 |
374095 | 374095 | 2020-07-27 | Daviess | Kentucky | 21059 | 655 | 7 |
370883 | 370883 | 2020-07-26 | Daviess | Kentucky | 21059 | 633 | 7 |
367673 | 367673 | 2020-07-25 | Daviess | Kentucky | 21059 | 633 | 7 |
364466 | 364466 | 2020-07-24 | Daviess | Kentucky | 21059 | 613 | 7 |
361259 | 361259 | 2020-07-23 | Daviess | Kentucky | 21059 | 608 | 7 |
358054 | 358054 | 2020-07-22 | Daviess | Kentucky | 21059 | 595 | 7 |
354851 | 354851 | 2020-07-21 | Daviess | Kentucky | 21059 | 586 | 7 |
351649 | 351649 | 2020-07-20 | Daviess | Kentucky | 21059 | 575 | 8 |
348449 | 348449 | 2020-07-19 | Daviess | Kentucky | 21059 | 570 | 8 |
345248 | 345248 | 2020-07-18 | Daviess | Kentucky | 21059 | 562 | 8 |
342048 | 342048 | 2020-07-17 | Daviess | Kentucky | 21059 | 553 | 8 |
338852 | 338852 | 2020-07-16 | Daviess | Kentucky | 21059 | 539 | 8 |
335656 | 335656 | 2020-07-15 | Daviess | Kentucky | 21059 | 534 | 8 |
332463 | 332463 | 2020-07-14 | Daviess | Kentucky | 21059 | 518 | 8 |
329276 | 329276 | 2020-07-13 | Daviess | Kentucky | 21059 | 511 | 8 |
326090 | 326090 | 2020-07-12 | Daviess | Kentucky | 21059 | 499 | 8 |
322907 | 322907 | 2020-07-11 | Daviess | Kentucky | 21059 | 499 | 8 |
319728 | 319728 | 2020-07-10 | Daviess | Kentucky | 21059 | 493 | 8 |
316553 | 316553 | 2020-07-09 | Daviess | Kentucky | 21059 | 483 | 8 |
313379 | 313379 | 2020-07-08 | Daviess | Kentucky | 21059 | 469 | 8 |
310209 | 310209 | 2020-07-07 | Daviess | Kentucky | 21059 | 467 | 8 |
307041 | 307041 | 2020-07-06 | Daviess | Kentucky | 21059 | 458 | 8 |
303874 | 303874 | 2020-07-05 | Daviess | Kentucky | 21059 | 452 | 8 |
300710 | 300710 | 2020-07-04 | Daviess | Kentucky | 21059 | 452 | 8 |
297548 | 297548 | 2020-07-03 | Daviess | Kentucky | 21059 | 452 | 8 |
294390 | 294390 | 2020-07-02 | Daviess | Kentucky | 21059 | 440 | 8 |
291236 | 291236 | 2020-07-01 | Daviess | Kentucky | 21059 | 435 | 8 |
288086 | 288086 | 2020-06-30 | Daviess | Kentucky | 21059 | 433 | 8 |
284937 | 284937 | 2020-06-29 | Daviess | Kentucky | 21059 | 431 | 8 |
281791 | 281791 | 2020-06-28 | Daviess | Kentucky | 21059 | 428 | 8 |
278643 | 278643 | 2020-06-27 | Daviess | Kentucky | 21059 | 428 | 8 |
275495 | 275495 | 2020-06-26 | Daviess | Kentucky | 21059 | 421 | 8 |
272352 | 272352 | 2020-06-25 | Daviess | Kentucky | 21059 | 414 | 8 |
269216 | 269216 | 2020-06-24 | Daviess | Kentucky | 21059 | 407 | 8 |
266083 | 266083 | 2020-06-23 | Daviess | Kentucky | 21059 | 404 | 8 |
262956 | 262956 | 2020-06-22 | Daviess | Kentucky | 21059 | 386 | 8 |
259827 | 259827 | 2020-06-21 | Daviess | Kentucky | 21059 | 382 | 8 |
256701 | 256701 | 2020-06-20 | Daviess | Kentucky | 21059 | 376 | 8 |
253581 | 253581 | 2020-06-19 | Daviess | Kentucky | 21059 | 376 | 8 |
250466 | 250466 | 2020-06-18 | Daviess | Kentucky | 21059 | 370 | 8 |
247354 | 247354 | 2020-06-17 | Daviess | Kentucky | 21059 | 368 | 8 |
244241 | 244241 | 2020-06-16 | Daviess | Kentucky | 21059 | 360 | 8 |
241130 | 241130 | 2020-06-15 | Daviess | Kentucky | 21059 | 360 | 8 |
238021 | 238021 | 2020-06-14 | Daviess | Kentucky | 21059 | 353 | 8 |
234914 | 234914 | 2020-06-13 | Daviess | Kentucky | 21059 | 353 | 8 |
231809 | 231809 | 2020-06-12 | Daviess | Kentucky | 21059 | 350 | 8 |
228705 | 228705 | 2020-06-11 | Daviess | Kentucky | 21059 | 347 | 8 |
225603 | 225603 | 2020-06-10 | Daviess | Kentucky | 21059 | 344 | 8 |
222507 | 222507 | 2020-06-09 | Daviess | Kentucky | 21059 | 341 | 8 |
219412 | 219412 | 2020-06-08 | Daviess | Kentucky | 21059 | 342 | 8 |
216320 | 216320 | 2020-06-07 | Daviess | Kentucky | 21059 | 340 | 7 |
213233 | 213233 | 2020-06-06 | Daviess | Kentucky | 21059 | 340 | 7 |
210148 | 210148 | 2020-06-05 | Daviess | Kentucky | 21059 | 339 | 7 |
207067 | 207067 | 2020-06-04 | Daviess | Kentucky | 21059 | 337 | 6 |
203986 | 203986 | 2020-06-03 | Daviess | Kentucky | 21059 | 330 | 6 |
200909 | 200909 | 2020-06-02 | Daviess | Kentucky | 21059 | 325 | 6 |
197838 | 197838 | 2020-06-01 | Daviess | Kentucky | 21059 | 324 | 6 |
194767 | 194767 | 2020-05-31 | Daviess | Kentucky | 21059 | 317 | 6 |
191699 | 191699 | 2020-05-30 | Daviess | Kentucky | 21059 | 317 | 6 |
188635 | 188635 | 2020-05-29 | Daviess | Kentucky | 21059 | 316 | 6 |
185577 | 185577 | 2020-05-28 | Daviess | Kentucky | 21059 | 313 | 6 |
182523 | 182523 | 2020-05-27 | Daviess | Kentucky | 21059 | 312 | 6 |
179478 | 179478 | 2020-05-26 | Daviess | Kentucky | 21059 | 308 | 6 |
176434 | 176434 | 2020-05-25 | Daviess | Kentucky | 21059 | 305 | 6 |
173390 | 173390 | 2020-05-24 | Daviess | Kentucky | 21059 | 305 | 6 |
170349 | 170349 | 2020-05-23 | Daviess | Kentucky | 21059 | 305 | 6 |
167311 | 167311 | 2020-05-22 | Daviess | Kentucky | 21059 | 300 | 6 |
164275 | 164275 | 2020-05-21 | Daviess | Kentucky | 21059 | 299 | 6 |
161246 | 161246 | 2020-05-20 | Daviess | Kentucky | 21059 | 296 | 6 |
158221 | 158221 | 2020-05-19 | Daviess | Kentucky | 21059 | 296 | 6 |
155204 | 155204 | 2020-05-18 | Daviess | Kentucky | 21059 | 293 | 4 |
152190 | 152190 | 2020-05-17 | Daviess | Kentucky | 21059 | 287 | 4 |
149179 | 149179 | 2020-05-16 | Daviess | Kentucky | 21059 | 287 | 4 |
146175 | 146175 | 2020-05-15 | Daviess | Kentucky | 21059 | 287 | 4 |
143175 | 143175 | 2020-05-14 | Daviess | Kentucky | 21059 | 277 | 4 |
140179 | 140179 | 2020-05-13 | Daviess | Kentucky | 21059 | 274 | 4 |
137186 | 137186 | 2020-05-12 | Daviess | Kentucky | 21059 | 274 | 4 |
134196 | 134196 | 2020-05-11 | Daviess | Kentucky | 21059 | 270 | 4 |
131205 | 131205 | 2020-05-10 | Daviess | Kentucky | 21059 | 266 | 4 |
128215 | 128215 | 2020-05-09 | Daviess | Kentucky | 21059 | 265 | 4 |
125227 | 125227 | 2020-05-08 | Daviess | Kentucky | 21059 | 260 | 4 |
122245 | 122245 | 2020-05-07 | Daviess | Kentucky | 21059 | 258 | 4 |
119275 | 119275 | 2020-05-06 | Daviess | Kentucky | 21059 | 248 | 4 |
116314 | 116314 | 2020-05-05 | Daviess | Kentucky | 21059 | 242 | 4 |
113432 | 113432 | 2020-05-04 | Daviess | Kentucky | 21059 | 228 | 4 |
110555 | 110555 | 2020-05-03 | Daviess | Kentucky | 21059 | 228 | 4 |
107684 | 107684 | 2020-05-02 | Daviess | Kentucky | 21059 | 194 | 4 |
104819 | 104819 | 2020-05-01 | Daviess | Kentucky | 21059 | 194 | 4 |
101958 | 101958 | 2020-04-30 | Daviess | Kentucky | 21059 | 188 | 4 |
99106 | 99106 | 2020-04-29 | Daviess | Kentucky | 21059 | 182 | 3 |
96260 | 96260 | 2020-04-28 | Daviess | Kentucky | 21059 | 169 | 6 |
93427 | 93427 | 2020-04-27 | Daviess | Kentucky | 21059 | 161 | 6 |
90606 | 90606 | 2020-04-26 | Daviess | Kentucky | 21059 | 161 | 6 |
87790 | 87790 | 2020-04-25 | Daviess | Kentucky | 21059 | 147 | 6 |
84981 | 84981 | 2020-04-24 | Daviess | Kentucky | 21059 | 146 | 6 |
82178 | 82178 | 2020-04-23 | Daviess | Kentucky | 21059 | 146 | 6 |
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);