ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 21215 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535528 | 535528 | 2020-09-15 | Spencer | Kentucky | 21215 | 189 | 0 |
532293 | 532293 | 2020-09-14 | Spencer | Kentucky | 21215 | 188 | 0 |
529056 | 529056 | 2020-09-13 | Spencer | Kentucky | 21215 | 188 | 0 |
525820 | 525820 | 2020-09-12 | Spencer | Kentucky | 21215 | 188 | 0 |
522584 | 522584 | 2020-09-11 | Spencer | Kentucky | 21215 | 184 | 0 |
519347 | 519347 | 2020-09-10 | Spencer | Kentucky | 21215 | 183 | 0 |
516112 | 516112 | 2020-09-09 | Spencer | Kentucky | 21215 | 177 | 0 |
512879 | 512879 | 2020-09-08 | Spencer | Kentucky | 21215 | 174 | 0 |
509647 | 509647 | 2020-09-07 | Spencer | Kentucky | 21215 | 174 | 0 |
506414 | 506414 | 2020-09-06 | Spencer | Kentucky | 21215 | 174 | 0 |
503180 | 503180 | 2020-09-05 | Spencer | Kentucky | 21215 | 173 | 0 |
499947 | 499947 | 2020-09-04 | Spencer | Kentucky | 21215 | 173 | 0 |
496713 | 496713 | 2020-09-03 | Spencer | Kentucky | 21215 | 168 | 0 |
493480 | 493480 | 2020-09-02 | Spencer | Kentucky | 21215 | 171 | 0 |
490246 | 490246 | 2020-09-01 | Spencer | Kentucky | 21215 | 169 | 0 |
487013 | 487013 | 2020-08-31 | Spencer | Kentucky | 21215 | 169 | 0 |
483778 | 483778 | 2020-08-30 | Spencer | Kentucky | 21215 | 169 | 0 |
480544 | 480544 | 2020-08-29 | Spencer | Kentucky | 21215 | 166 | 0 |
477311 | 477311 | 2020-08-28 | Spencer | Kentucky | 21215 | 163 | 0 |
474078 | 474078 | 2020-08-27 | Spencer | Kentucky | 21215 | 163 | 0 |
470846 | 470846 | 2020-08-26 | Spencer | Kentucky | 21215 | 162 | 0 |
467617 | 467617 | 2020-08-25 | Spencer | Kentucky | 21215 | 161 | 0 |
464388 | 464388 | 2020-08-24 | Spencer | Kentucky | 21215 | 160 | 0 |
461157 | 461157 | 2020-08-23 | Spencer | Kentucky | 21215 | 152 | 0 |
457930 | 457930 | 2020-08-22 | Spencer | Kentucky | 21215 | 152 | 0 |
454702 | 454702 | 2020-08-21 | Spencer | Kentucky | 21215 | 149 | 0 |
451474 | 451474 | 2020-08-20 | Spencer | Kentucky | 21215 | 146 | 0 |
448246 | 448246 | 2020-08-19 | Spencer | Kentucky | 21215 | 145 | 0 |
445019 | 445019 | 2020-08-18 | Spencer | Kentucky | 21215 | 142 | 0 |
441793 | 441793 | 2020-08-17 | Spencer | Kentucky | 21215 | 141 | 0 |
438566 | 438566 | 2020-08-16 | Spencer | Kentucky | 21215 | 138 | 0 |
435341 | 435341 | 2020-08-15 | Spencer | Kentucky | 21215 | 138 | 0 |
432116 | 432116 | 2020-08-14 | Spencer | Kentucky | 21215 | 138 | 0 |
428888 | 428888 | 2020-08-13 | Spencer | Kentucky | 21215 | 136 | 0 |
425664 | 425664 | 2020-08-12 | Spencer | Kentucky | 21215 | 128 | 0 |
422443 | 422443 | 2020-08-11 | Spencer | Kentucky | 21215 | 123 | 0 |
419221 | 419221 | 2020-08-10 | Spencer | Kentucky | 21215 | 121 | 0 |
416000 | 416000 | 2020-08-09 | Spencer | Kentucky | 21215 | 120 | 0 |
412780 | 412780 | 2020-08-08 | Spencer | Kentucky | 21215 | 113 | 0 |
409560 | 409560 | 2020-08-07 | Spencer | Kentucky | 21215 | 111 | 0 |
406340 | 406340 | 2020-08-06 | Spencer | Kentucky | 21215 | 112 | 0 |
403122 | 403122 | 2020-08-05 | Spencer | Kentucky | 21215 | 110 | 0 |
399905 | 399905 | 2020-08-04 | Spencer | Kentucky | 21215 | 107 | 0 |
396690 | 396690 | 2020-08-03 | Spencer | Kentucky | 21215 | 102 | 0 |
393474 | 393474 | 2020-08-02 | Spencer | Kentucky | 21215 | 97 | 0 |
390257 | 390257 | 2020-08-01 | Spencer | Kentucky | 21215 | 96 | 0 |
387040 | 387040 | 2020-07-31 | Spencer | Kentucky | 21215 | 94 | 0 |
383822 | 383822 | 2020-07-30 | Spencer | Kentucky | 21215 | 87 | 0 |
380605 | 380605 | 2020-07-29 | Spencer | Kentucky | 21215 | 84 | 0 |
377388 | 377388 | 2020-07-28 | Spencer | Kentucky | 21215 | 82 | 0 |
374173 | 374173 | 2020-07-27 | Spencer | Kentucky | 21215 | 77 | 0 |
370961 | 370961 | 2020-07-26 | Spencer | Kentucky | 21215 | 77 | 0 |
367751 | 367751 | 2020-07-25 | Spencer | Kentucky | 21215 | 74 | 0 |
364544 | 364544 | 2020-07-24 | Spencer | Kentucky | 21215 | 71 | 0 |
361337 | 361337 | 2020-07-23 | Spencer | Kentucky | 21215 | 65 | 0 |
358132 | 358132 | 2020-07-22 | Spencer | Kentucky | 21215 | 63 | 0 |
354929 | 354929 | 2020-07-21 | Spencer | Kentucky | 21215 | 63 | 0 |
351727 | 351727 | 2020-07-20 | Spencer | Kentucky | 21215 | 62 | 0 |
348527 | 348527 | 2020-07-19 | Spencer | Kentucky | 21215 | 62 | 0 |
345326 | 345326 | 2020-07-18 | Spencer | Kentucky | 21215 | 59 | 0 |
342126 | 342126 | 2020-07-17 | Spencer | Kentucky | 21215 | 58 | 0 |
338930 | 338930 | 2020-07-16 | Spencer | Kentucky | 21215 | 57 | 0 |
335734 | 335734 | 2020-07-15 | Spencer | Kentucky | 21215 | 53 | 0 |
332541 | 332541 | 2020-07-14 | Spencer | Kentucky | 21215 | 52 | 0 |
329354 | 329354 | 2020-07-13 | Spencer | Kentucky | 21215 | 49 | 0 |
326168 | 326168 | 2020-07-12 | Spencer | Kentucky | 21215 | 48 | 0 |
322985 | 322985 | 2020-07-11 | Spencer | Kentucky | 21215 | 48 | 0 |
319806 | 319806 | 2020-07-10 | Spencer | Kentucky | 21215 | 43 | 0 |
316631 | 316631 | 2020-07-09 | Spencer | Kentucky | 21215 | 41 | 0 |
313457 | 313457 | 2020-07-08 | Spencer | Kentucky | 21215 | 41 | 0 |
310287 | 310287 | 2020-07-07 | Spencer | Kentucky | 21215 | 40 | 0 |
307119 | 307119 | 2020-07-06 | Spencer | Kentucky | 21215 | 40 | 0 |
303952 | 303952 | 2020-07-05 | Spencer | Kentucky | 21215 | 38 | 0 |
300788 | 300788 | 2020-07-04 | Spencer | Kentucky | 21215 | 38 | 0 |
297626 | 297626 | 2020-07-03 | Spencer | Kentucky | 21215 | 38 | 0 |
294468 | 294468 | 2020-07-02 | Spencer | Kentucky | 21215 | 37 | 0 |
291314 | 291314 | 2020-07-01 | Spencer | Kentucky | 21215 | 37 | 0 |
288163 | 288163 | 2020-06-30 | Spencer | Kentucky | 21215 | 36 | 0 |
285014 | 285014 | 2020-06-29 | Spencer | Kentucky | 21215 | 36 | 0 |
281868 | 281868 | 2020-06-28 | Spencer | Kentucky | 21215 | 36 | 0 |
278720 | 278720 | 2020-06-27 | Spencer | Kentucky | 21215 | 36 | 0 |
275572 | 275572 | 2020-06-26 | Spencer | Kentucky | 21215 | 33 | 0 |
272429 | 272429 | 2020-06-25 | Spencer | Kentucky | 21215 | 33 | 0 |
269293 | 269293 | 2020-06-24 | Spencer | Kentucky | 21215 | 33 | 0 |
266160 | 266160 | 2020-06-23 | Spencer | Kentucky | 21215 | 31 | 0 |
263033 | 263033 | 2020-06-22 | Spencer | Kentucky | 21215 | 29 | 0 |
259904 | 259904 | 2020-06-21 | Spencer | Kentucky | 21215 | 29 | 0 |
256778 | 256778 | 2020-06-20 | Spencer | Kentucky | 21215 | 29 | 0 |
253658 | 253658 | 2020-06-19 | Spencer | Kentucky | 21215 | 28 | 0 |
250543 | 250543 | 2020-06-18 | Spencer | Kentucky | 21215 | 28 | 0 |
247431 | 247431 | 2020-06-17 | Spencer | Kentucky | 21215 | 26 | 0 |
244318 | 244318 | 2020-06-16 | Spencer | Kentucky | 21215 | 26 | 0 |
241207 | 241207 | 2020-06-15 | Spencer | Kentucky | 21215 | 26 | 0 |
238098 | 238098 | 2020-06-14 | Spencer | Kentucky | 21215 | 26 | 0 |
234991 | 234991 | 2020-06-13 | Spencer | Kentucky | 21215 | 26 | 0 |
231886 | 231886 | 2020-06-12 | Spencer | Kentucky | 21215 | 25 | 0 |
228782 | 228782 | 2020-06-11 | Spencer | Kentucky | 21215 | 25 | 0 |
225680 | 225680 | 2020-06-10 | Spencer | Kentucky | 21215 | 25 | 0 |
222584 | 222584 | 2020-06-09 | Spencer | Kentucky | 21215 | 25 | 0 |
219489 | 219489 | 2020-06-08 | Spencer | Kentucky | 21215 | 25 | 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);