ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 21047 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635908 | 635908 | 2020-10-16 | Christian | Kentucky | 21047 | 1683 | 28 |
632662 | 632662 | 2020-10-15 | Christian | Kentucky | 21047 | 1659 | 28 |
629418 | 629418 | 2020-10-14 | Christian | Kentucky | 21047 | 1639 | 26 |
626174 | 626174 | 2020-10-13 | Christian | Kentucky | 21047 | 1618 | 26 |
622932 | 622932 | 2020-10-12 | Christian | Kentucky | 21047 | 1579 | 26 |
619688 | 619688 | 2020-10-11 | Christian | Kentucky | 21047 | 1562 | 26 |
616446 | 616446 | 2020-10-10 | Christian | Kentucky | 21047 | 1561 | 26 |
613205 | 613205 | 2020-10-09 | Christian | Kentucky | 21047 | 1548 | 26 |
609963 | 609963 | 2020-10-08 | Christian | Kentucky | 21047 | 1525 | 26 |
606721 | 606721 | 2020-10-07 | Christian | Kentucky | 21047 | 1482 | 26 |
603479 | 603479 | 2020-10-06 | Christian | Kentucky | 21047 | 1473 | 26 |
600236 | 600236 | 2020-10-05 | Christian | Kentucky | 21047 | 1459 | 26 |
596994 | 596994 | 2020-10-04 | Christian | Kentucky | 21047 | 1437 | 25 |
593752 | 593752 | 2020-10-03 | Christian | Kentucky | 21047 | 1432 | 25 |
590511 | 590511 | 2020-10-02 | Christian | Kentucky | 21047 | 1397 | 25 |
587270 | 587270 | 2020-10-01 | Christian | Kentucky | 21047 | 1367 | 23 |
584030 | 584030 | 2020-09-30 | Christian | Kentucky | 21047 | 1355 | 23 |
580790 | 580790 | 2020-09-29 | Christian | Kentucky | 21047 | 1337 | 23 |
577549 | 577549 | 2020-09-28 | Christian | Kentucky | 21047 | 1328 | 22 |
574307 | 574307 | 2020-09-27 | Christian | Kentucky | 21047 | 1303 | 22 |
571064 | 571064 | 2020-09-26 | Christian | Kentucky | 21047 | 1298 | 22 |
567822 | 567822 | 2020-09-25 | Christian | Kentucky | 21047 | 1290 | 22 |
564582 | 564582 | 2020-09-24 | Christian | Kentucky | 21047 | 1261 | 20 |
561342 | 561342 | 2020-09-23 | Christian | Kentucky | 21047 | 1239 | 20 |
558106 | 558106 | 2020-09-22 | Christian | Kentucky | 21047 | 1218 | 19 |
554869 | 554869 | 2020-09-21 | Christian | Kentucky | 21047 | 1207 | 19 |
551630 | 551630 | 2020-09-20 | Christian | Kentucky | 21047 | 1192 | 18 |
548391 | 548391 | 2020-09-19 | Christian | Kentucky | 21047 | 1185 | 18 |
545153 | 545153 | 2020-09-18 | Christian | Kentucky | 21047 | 1167 | 18 |
541917 | 541917 | 2020-09-17 | Christian | Kentucky | 21047 | 1145 | 18 |
538681 | 538681 | 2020-09-16 | Christian | Kentucky | 21047 | 1109 | 17 |
535444 | 535444 | 2020-09-15 | Christian | Kentucky | 21047 | 1095 | 17 |
532209 | 532209 | 2020-09-14 | Christian | Kentucky | 21047 | 1066 | 15 |
528972 | 528972 | 2020-09-13 | Christian | Kentucky | 21047 | 1035 | 15 |
525736 | 525736 | 2020-09-12 | Christian | Kentucky | 21047 | 1035 | 15 |
522500 | 522500 | 2020-09-11 | Christian | Kentucky | 21047 | 1015 | 14 |
519263 | 519263 | 2020-09-10 | Christian | Kentucky | 21047 | 1007 | 14 |
516028 | 516028 | 2020-09-09 | Christian | Kentucky | 21047 | 995 | 14 |
512795 | 512795 | 2020-09-08 | Christian | Kentucky | 21047 | 980 | 14 |
509563 | 509563 | 2020-09-07 | Christian | Kentucky | 21047 | 951 | 14 |
506330 | 506330 | 2020-09-06 | Christian | Kentucky | 21047 | 945 | 14 |
503096 | 503096 | 2020-09-05 | Christian | Kentucky | 21047 | 945 | 14 |
499863 | 499863 | 2020-09-04 | Christian | Kentucky | 21047 | 919 | 14 |
496629 | 496629 | 2020-09-03 | Christian | Kentucky | 21047 | 907 | 14 |
493396 | 493396 | 2020-09-02 | Christian | Kentucky | 21047 | 902 | 14 |
490162 | 490162 | 2020-09-01 | Christian | Kentucky | 21047 | 894 | 14 |
486929 | 486929 | 2020-08-31 | Christian | Kentucky | 21047 | 888 | 14 |
483694 | 483694 | 2020-08-30 | Christian | Kentucky | 21047 | 872 | 13 |
480460 | 480460 | 2020-08-29 | Christian | Kentucky | 21047 | 872 | 13 |
477227 | 477227 | 2020-08-28 | Christian | Kentucky | 21047 | 869 | 13 |
473994 | 473994 | 2020-08-27 | Christian | Kentucky | 21047 | 864 | 13 |
470762 | 470762 | 2020-08-26 | Christian | Kentucky | 21047 | 849 | 11 |
467533 | 467533 | 2020-08-25 | Christian | Kentucky | 21047 | 839 | 11 |
464304 | 464304 | 2020-08-24 | Christian | Kentucky | 21047 | 832 | 11 |
461073 | 461073 | 2020-08-23 | Christian | Kentucky | 21047 | 818 | 11 |
457846 | 457846 | 2020-08-22 | Christian | Kentucky | 21047 | 809 | 11 |
454618 | 454618 | 2020-08-21 | Christian | Kentucky | 21047 | 796 | 11 |
451390 | 451390 | 2020-08-20 | Christian | Kentucky | 21047 | 791 | 11 |
448162 | 448162 | 2020-08-19 | Christian | Kentucky | 21047 | 786 | 11 |
444935 | 444935 | 2020-08-18 | Christian | Kentucky | 21047 | 780 | 11 |
441709 | 441709 | 2020-08-17 | Christian | Kentucky | 21047 | 769 | 11 |
438482 | 438482 | 2020-08-16 | Christian | Kentucky | 21047 | 746 | 11 |
435257 | 435257 | 2020-08-15 | Christian | Kentucky | 21047 | 735 | 11 |
432032 | 432032 | 2020-08-14 | Christian | Kentucky | 21047 | 730 | 11 |
428804 | 428804 | 2020-08-13 | Christian | Kentucky | 21047 | 717 | 11 |
425580 | 425580 | 2020-08-12 | Christian | Kentucky | 21047 | 697 | 10 |
422359 | 422359 | 2020-08-11 | Christian | Kentucky | 21047 | 675 | 9 |
419137 | 419137 | 2020-08-10 | Christian | Kentucky | 21047 | 647 | 8 |
415916 | 415916 | 2020-08-09 | Christian | Kentucky | 21047 | 626 | 8 |
412696 | 412696 | 2020-08-08 | Christian | Kentucky | 21047 | 626 | 8 |
409476 | 409476 | 2020-08-07 | Christian | Kentucky | 21047 | 621 | 8 |
406256 | 406256 | 2020-08-06 | Christian | Kentucky | 21047 | 613 | 7 |
403038 | 403038 | 2020-08-05 | Christian | Kentucky | 21047 | 607 | 6 |
399821 | 399821 | 2020-08-04 | Christian | Kentucky | 21047 | 597 | 6 |
396606 | 396606 | 2020-08-03 | Christian | Kentucky | 21047 | 592 | 6 |
393390 | 393390 | 2020-08-02 | Christian | Kentucky | 21047 | 575 | 6 |
390173 | 390173 | 2020-08-01 | Christian | Kentucky | 21047 | 575 | 6 |
386956 | 386956 | 2020-07-31 | Christian | Kentucky | 21047 | 558 | 6 |
383738 | 383738 | 2020-07-30 | Christian | Kentucky | 21047 | 539 | 6 |
380521 | 380521 | 2020-07-29 | Christian | Kentucky | 21047 | 527 | 5 |
377304 | 377304 | 2020-07-28 | Christian | Kentucky | 21047 | 498 | 5 |
374089 | 374089 | 2020-07-27 | Christian | Kentucky | 21047 | 485 | 5 |
370877 | 370877 | 2020-07-26 | Christian | Kentucky | 21047 | 479 | 5 |
367667 | 367667 | 2020-07-25 | Christian | Kentucky | 21047 | 474 | 5 |
364460 | 364460 | 2020-07-24 | Christian | Kentucky | 21047 | 471 | 5 |
361253 | 361253 | 2020-07-23 | Christian | Kentucky | 21047 | 462 | 4 |
358048 | 358048 | 2020-07-22 | Christian | Kentucky | 21047 | 447 | 4 |
354845 | 354845 | 2020-07-21 | Christian | Kentucky | 21047 | 431 | 4 |
351643 | 351643 | 2020-07-20 | Christian | Kentucky | 21047 | 424 | 4 |
348443 | 348443 | 2020-07-19 | Christian | Kentucky | 21047 | 411 | 4 |
345242 | 345242 | 2020-07-18 | Christian | Kentucky | 21047 | 411 | 4 |
342042 | 342042 | 2020-07-17 | Christian | Kentucky | 21047 | 407 | 4 |
338846 | 338846 | 2020-07-16 | Christian | Kentucky | 21047 | 365 | 4 |
335650 | 335650 | 2020-07-15 | Christian | Kentucky | 21047 | 364 | 4 |
332457 | 332457 | 2020-07-14 | Christian | Kentucky | 21047 | 344 | 4 |
329270 | 329270 | 2020-07-13 | Christian | Kentucky | 21047 | 343 | 4 |
326084 | 326084 | 2020-07-12 | Christian | Kentucky | 21047 | 323 | 4 |
322901 | 322901 | 2020-07-11 | Christian | Kentucky | 21047 | 323 | 4 |
319722 | 319722 | 2020-07-10 | Christian | Kentucky | 21047 | 313 | 4 |
316547 | 316547 | 2020-07-09 | Christian | Kentucky | 21047 | 297 | 4 |
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);