ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where county = "Jefferson" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947456 | 947456 | 2021-01-20 | Jefferson | Kentucky | 21111 | 62534 | 752 |
944209 | 944209 | 2021-01-19 | Jefferson | Kentucky | 21111 | 62115 | 747 |
940964 | 940964 | 2021-01-18 | Jefferson | Kentucky | 21111 | 61778 | 746 |
937719 | 937719 | 2021-01-17 | Jefferson | Kentucky | 21111 | 61424 | 746 |
934474 | 934474 | 2021-01-16 | Jefferson | Kentucky | 21111 | 61065 | 745 |
931229 | 931229 | 2021-01-15 | Jefferson | Kentucky | 21111 | 60457 | 740 |
927984 | 927984 | 2021-01-14 | Jefferson | Kentucky | 21111 | 59780 | 732 |
924738 | 924738 | 2021-01-13 | Jefferson | Kentucky | 21111 | 59234 | 729 |
921493 | 921493 | 2021-01-12 | Jefferson | Kentucky | 21111 | 58666 | 726 |
918248 | 918248 | 2021-01-11 | Jefferson | Kentucky | 21111 | 58281 | 719 |
915003 | 915003 | 2021-01-10 | Jefferson | Kentucky | 21111 | 57745 | 715 |
911758 | 911758 | 2021-01-09 | Jefferson | Kentucky | 21111 | 57201 | 715 |
908513 | 908513 | 2021-01-08 | Jefferson | Kentucky | 21111 | 56422 | 702 |
905267 | 905267 | 2021-01-07 | Jefferson | Kentucky | 21111 | 55958 | 694 |
902022 | 902022 | 2021-01-06 | Jefferson | Kentucky | 21111 | 55135 | 690 |
898777 | 898777 | 2021-01-05 | Jefferson | Kentucky | 21111 | 54541 | 679 |
895532 | 895532 | 2021-01-04 | Jefferson | Kentucky | 21111 | 54121 | 670 |
892285 | 892285 | 2021-01-03 | Jefferson | Kentucky | 21111 | 53647 | 658 |
889039 | 889039 | 2021-01-02 | Jefferson | Kentucky | 21111 | 53247 | 658 |
885793 | 885793 | 2021-01-01 | Jefferson | Kentucky | 21111 | 52883 | 658 |
882548 | 882548 | 2020-12-31 | Jefferson | Kentucky | 21111 | 52277 | 658 |
879303 | 879303 | 2020-12-30 | Jefferson | Kentucky | 21111 | 51652 | 649 |
876058 | 876058 | 2020-12-29 | Jefferson | Kentucky | 21111 | 51221 | 639 |
872813 | 872813 | 2020-12-28 | Jefferson | Kentucky | 21111 | 50823 | 635 |
869568 | 869568 | 2020-12-27 | Jefferson | Kentucky | 21111 | 50679 | 630 |
866323 | 866323 | 2020-12-26 | Jefferson | Kentucky | 21111 | 50460 | 630 |
863078 | 863078 | 2020-12-25 | Jefferson | Kentucky | 21111 | 50283 | 630 |
859833 | 859833 | 2020-12-24 | Jefferson | Kentucky | 21111 | 49900 | 628 |
856588 | 856588 | 2020-12-23 | Jefferson | Kentucky | 21111 | 49514 | 622 |
853343 | 853343 | 2020-12-22 | Jefferson | Kentucky | 21111 | 49153 | 617 |
850098 | 850098 | 2020-12-21 | Jefferson | Kentucky | 21111 | 48689 | 612 |
846853 | 846853 | 2020-12-20 | Jefferson | Kentucky | 21111 | 48228 | 612 |
843607 | 843607 | 2020-12-19 | Jefferson | Kentucky | 21111 | 47935 | 612 |
840362 | 840362 | 2020-12-18 | Jefferson | Kentucky | 21111 | 47639 | 610 |
837117 | 837117 | 2020-12-17 | Jefferson | Kentucky | 21111 | 47086 | 597 |
833871 | 833871 | 2020-12-16 | Jefferson | Kentucky | 21111 | 46791 | 593 |
830624 | 830624 | 2020-12-15 | Jefferson | Kentucky | 21111 | 46440 | 582 |
827378 | 827378 | 2020-12-14 | Jefferson | Kentucky | 21111 | 45974 | 578 |
824131 | 824131 | 2020-12-13 | Jefferson | Kentucky | 21111 | 45564 | 578 |
820885 | 820885 | 2020-12-12 | Jefferson | Kentucky | 21111 | 45006 | 578 |
817639 | 817639 | 2020-12-11 | Jefferson | Kentucky | 21111 | 44421 | 564 |
814393 | 814393 | 2020-12-10 | Jefferson | Kentucky | 21111 | 43771 | 553 |
811148 | 811148 | 2020-12-09 | Jefferson | Kentucky | 21111 | 42993 | 548 |
807903 | 807903 | 2020-12-08 | Jefferson | Kentucky | 21111 | 42795 | 539 |
804658 | 804658 | 2020-12-07 | Jefferson | Kentucky | 21111 | 42296 | 530 |
801413 | 801413 | 2020-12-06 | Jefferson | Kentucky | 21111 | 41964 | 530 |
798168 | 798168 | 2020-12-05 | Jefferson | Kentucky | 21111 | 41452 | 529 |
794923 | 794923 | 2020-12-04 | Jefferson | Kentucky | 21111 | 40908 | 524 |
791678 | 791678 | 2020-12-03 | Jefferson | Kentucky | 21111 | 40295 | 523 |
788433 | 788433 | 2020-12-02 | Jefferson | Kentucky | 21111 | 39683 | 511 |
785189 | 785189 | 2020-12-01 | Jefferson | Kentucky | 21111 | 39014 | 505 |
781944 | 781944 | 2020-11-30 | Jefferson | Kentucky | 21111 | 38452 | 500 |
778698 | 778698 | 2020-11-29 | Jefferson | Kentucky | 21111 | 38030 | 500 |
775453 | 775453 | 2020-11-28 | Jefferson | Kentucky | 21111 | 37614 | 499 |
772208 | 772208 | 2020-11-27 | Jefferson | Kentucky | 21111 | 36666 | 499 |
768963 | 768963 | 2020-11-26 | Jefferson | Kentucky | 21111 | 36218 | 499 |
765717 | 765717 | 2020-11-25 | Jefferson | Kentucky | 21111 | 35986 | 491 |
762472 | 762472 | 2020-11-24 | Jefferson | Kentucky | 21111 | 35396 | 485 |
759227 | 759227 | 2020-11-23 | Jefferson | Kentucky | 21111 | 34987 | 473 |
755980 | 755980 | 2020-11-22 | Jefferson | Kentucky | 21111 | 34505 | 470 |
752734 | 752734 | 2020-11-21 | Jefferson | Kentucky | 21111 | 33989 | 470 |
749488 | 749488 | 2020-11-20 | Jefferson | Kentucky | 21111 | 33391 | 467 |
746242 | 746242 | 2020-11-19 | Jefferson | Kentucky | 21111 | 32721 | 460 |
742995 | 742995 | 2020-11-18 | Jefferson | Kentucky | 21111 | 32058 | 454 |
739748 | 739748 | 2020-11-17 | Jefferson | Kentucky | 21111 | 31534 | 449 |
736504 | 736504 | 2020-11-16 | Jefferson | Kentucky | 21111 | 31225 | 442 |
733258 | 733258 | 2020-11-15 | Jefferson | Kentucky | 21111 | 30953 | 441 |
730013 | 730013 | 2020-11-14 | Jefferson | Kentucky | 21111 | 30598 | 440 |
726770 | 726770 | 2020-11-13 | Jefferson | Kentucky | 21111 | 29971 | 439 |
723527 | 723527 | 2020-11-12 | Jefferson | Kentucky | 21111 | 29344 | 437 |
720284 | 720284 | 2020-11-11 | Jefferson | Kentucky | 21111 | 28938 | 437 |
717041 | 717041 | 2020-11-10 | Jefferson | Kentucky | 21111 | 28336 | 430 |
713797 | 713797 | 2020-11-09 | Jefferson | Kentucky | 21111 | 27971 | 427 |
710553 | 710553 | 2020-11-08 | Jefferson | Kentucky | 21111 | 27568 | 427 |
707309 | 707309 | 2020-11-07 | Jefferson | Kentucky | 21111 | 27338 | 426 |
704066 | 704066 | 2020-11-06 | Jefferson | Kentucky | 21111 | 26987 | 421 |
700824 | 700824 | 2020-11-05 | Jefferson | Kentucky | 21111 | 26497 | 421 |
697580 | 697580 | 2020-11-04 | Jefferson | Kentucky | 21111 | 26131 | 416 |
694337 | 694337 | 2020-11-03 | Jefferson | Kentucky | 21111 | 25813 | 410 |
691095 | 691095 | 2020-11-02 | Jefferson | Kentucky | 21111 | 25473 | 402 |
687850 | 687850 | 2020-11-01 | Jefferson | Kentucky | 21111 | 25285 | 402 |
684606 | 684606 | 2020-10-31 | Jefferson | Kentucky | 21111 | 24988 | 402 |
681363 | 681363 | 2020-10-30 | Jefferson | Kentucky | 21111 | 24761 | 402 |
678119 | 678119 | 2020-10-29 | Jefferson | Kentucky | 21111 | 24134 | 398 |
674877 | 674877 | 2020-10-28 | Jefferson | Kentucky | 21111 | 23803 | 394 |
671634 | 671634 | 2020-10-27 | Jefferson | Kentucky | 21111 | 23459 | 389 |
668392 | 668392 | 2020-10-26 | Jefferson | Kentucky | 21111 | 23101 | 384 |
665148 | 665148 | 2020-10-25 | Jefferson | Kentucky | 21111 | 22911 | 384 |
661903 | 661903 | 2020-10-24 | Jefferson | Kentucky | 21111 | 22652 | 384 |
658659 | 658659 | 2020-10-23 | Jefferson | Kentucky | 21111 | 22377 | 383 |
655414 | 655414 | 2020-10-22 | Jefferson | Kentucky | 21111 | 22090 | 370 |
652169 | 652169 | 2020-10-21 | Jefferson | Kentucky | 21111 | 21803 | 370 |
648924 | 648924 | 2020-10-20 | Jefferson | Kentucky | 21111 | 21513 | 361 |
645680 | 645680 | 2020-10-19 | Jefferson | Kentucky | 21111 | 21234 | 352 |
642433 | 642433 | 2020-10-18 | Jefferson | Kentucky | 21111 | 21063 | 351 |
639186 | 639186 | 2020-10-17 | Jefferson | Kentucky | 21111 | 20851 | 350 |
635940 | 635940 | 2020-10-16 | Jefferson | Kentucky | 21111 | 20559 | 344 |
632694 | 632694 | 2020-10-15 | Jefferson | Kentucky | 21111 | 20303 | 342 |
629450 | 629450 | 2020-10-14 | Jefferson | Kentucky | 21111 | 20044 | 339 |
626206 | 626206 | 2020-10-13 | Jefferson | Kentucky | 21111 | 19795 | 338 |
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);