ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Logan" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947471 | 947471 | 2021-01-20 | Logan | Kentucky | 21141 | 2033 | 43 |
944224 | 944224 | 2021-01-19 | Logan | Kentucky | 21141 | 2013 | 43 |
940979 | 940979 | 2021-01-18 | Logan | Kentucky | 21141 | 2005 | 43 |
937734 | 937734 | 2021-01-17 | Logan | Kentucky | 21141 | 1997 | 43 |
934489 | 934489 | 2021-01-16 | Logan | Kentucky | 21141 | 1979 | 43 |
931244 | 931244 | 2021-01-15 | Logan | Kentucky | 21141 | 1962 | 42 |
927999 | 927999 | 2021-01-14 | Logan | Kentucky | 21141 | 1948 | 42 |
924753 | 924753 | 2021-01-13 | Logan | Kentucky | 21141 | 1933 | 40 |
921508 | 921508 | 2021-01-12 | Logan | Kentucky | 21141 | 1917 | 40 |
918263 | 918263 | 2021-01-11 | Logan | Kentucky | 21141 | 1902 | 40 |
915018 | 915018 | 2021-01-10 | Logan | Kentucky | 21141 | 1892 | 40 |
911773 | 911773 | 2021-01-09 | Logan | Kentucky | 21141 | 1886 | 40 |
908528 | 908528 | 2021-01-08 | Logan | Kentucky | 21141 | 1868 | 40 |
905282 | 905282 | 2021-01-07 | Logan | Kentucky | 21141 | 1838 | 40 |
902037 | 902037 | 2021-01-06 | Logan | Kentucky | 21141 | 1815 | 40 |
898792 | 898792 | 2021-01-05 | Logan | Kentucky | 21141 | 1810 | 40 |
895547 | 895547 | 2021-01-04 | Logan | Kentucky | 21141 | 1797 | 39 |
892300 | 892300 | 2021-01-03 | Logan | Kentucky | 21141 | 1745 | 39 |
889054 | 889054 | 2021-01-02 | Logan | Kentucky | 21141 | 1737 | 39 |
885808 | 885808 | 2021-01-01 | Logan | Kentucky | 21141 | 1697 | 39 |
882563 | 882563 | 2020-12-31 | Logan | Kentucky | 21141 | 1697 | 39 |
879318 | 879318 | 2020-12-30 | Logan | Kentucky | 21141 | 1697 | 39 |
876073 | 876073 | 2020-12-29 | Logan | Kentucky | 21141 | 1679 | 39 |
872828 | 872828 | 2020-12-28 | Logan | Kentucky | 21141 | 1653 | 39 |
869583 | 869583 | 2020-12-27 | Logan | Kentucky | 21141 | 1649 | 39 |
866338 | 866338 | 2020-12-26 | Logan | Kentucky | 21141 | 1646 | 39 |
863093 | 863093 | 2020-12-25 | Logan | Kentucky | 21141 | 1613 | 37 |
859848 | 859848 | 2020-12-24 | Logan | Kentucky | 21141 | 1613 | 37 |
856603 | 856603 | 2020-12-23 | Logan | Kentucky | 21141 | 1613 | 37 |
853358 | 853358 | 2020-12-22 | Logan | Kentucky | 21141 | 1602 | 37 |
850113 | 850113 | 2020-12-21 | Logan | Kentucky | 21141 | 1579 | 37 |
846868 | 846868 | 2020-12-20 | Logan | Kentucky | 21141 | 1556 | 37 |
843622 | 843622 | 2020-12-19 | Logan | Kentucky | 21141 | 1551 | 37 |
840377 | 840377 | 2020-12-18 | Logan | Kentucky | 21141 | 1536 | 37 |
837132 | 837132 | 2020-12-17 | Logan | Kentucky | 21141 | 1517 | 37 |
833886 | 833886 | 2020-12-16 | Logan | Kentucky | 21141 | 1505 | 37 |
830639 | 830639 | 2020-12-15 | Logan | Kentucky | 21141 | 1471 | 37 |
827393 | 827393 | 2020-12-14 | Logan | Kentucky | 21141 | 1452 | 37 |
824146 | 824146 | 2020-12-13 | Logan | Kentucky | 21141 | 1425 | 36 |
820900 | 820900 | 2020-12-12 | Logan | Kentucky | 21141 | 1416 | 36 |
817654 | 817654 | 2020-12-11 | Logan | Kentucky | 21141 | 1391 | 36 |
814408 | 814408 | 2020-12-10 | Logan | Kentucky | 21141 | 1377 | 36 |
811163 | 811163 | 2020-12-09 | Logan | Kentucky | 21141 | 1362 | 36 |
807918 | 807918 | 2020-12-08 | Logan | Kentucky | 21141 | 1346 | 36 |
804673 | 804673 | 2020-12-07 | Logan | Kentucky | 21141 | 1343 | 36 |
801428 | 801428 | 2020-12-06 | Logan | Kentucky | 21141 | 1314 | 36 |
798183 | 798183 | 2020-12-05 | Logan | Kentucky | 21141 | 1307 | 36 |
794938 | 794938 | 2020-12-04 | Logan | Kentucky | 21141 | 1302 | 35 |
791693 | 791693 | 2020-12-03 | Logan | Kentucky | 21141 | 1296 | 35 |
788448 | 788448 | 2020-12-02 | Logan | Kentucky | 21141 | 1278 | 35 |
785204 | 785204 | 2020-12-01 | Logan | Kentucky | 21141 | 1268 | 35 |
781959 | 781959 | 2020-11-30 | Logan | Kentucky | 21141 | 1242 | 35 |
778713 | 778713 | 2020-11-29 | Logan | Kentucky | 21141 | 1214 | 35 |
775468 | 775468 | 2020-11-28 | Logan | Kentucky | 21141 | 1208 | 35 |
772223 | 772223 | 2020-11-27 | Logan | Kentucky | 21141 | 1208 | 33 |
768978 | 768978 | 2020-11-26 | Logan | Kentucky | 21141 | 1200 | 33 |
765732 | 765732 | 2020-11-25 | Logan | Kentucky | 21141 | 1200 | 33 |
762487 | 762487 | 2020-11-24 | Logan | Kentucky | 21141 | 1183 | 33 |
759242 | 759242 | 2020-11-23 | Logan | Kentucky | 21141 | 1183 | 33 |
755995 | 755995 | 2020-11-22 | Logan | Kentucky | 21141 | 1135 | 33 |
752749 | 752749 | 2020-11-21 | Logan | Kentucky | 21141 | 1135 | 33 |
749503 | 749503 | 2020-11-20 | Logan | Kentucky | 21141 | 1135 | 33 |
746257 | 746257 | 2020-11-19 | Logan | Kentucky | 21141 | 1088 | 33 |
743010 | 743010 | 2020-11-18 | Logan | Kentucky | 21141 | 1056 | 33 |
739763 | 739763 | 2020-11-17 | Logan | Kentucky | 21141 | 1035 | 33 |
736519 | 736519 | 2020-11-16 | Logan | Kentucky | 21141 | 1020 | 33 |
733273 | 733273 | 2020-11-15 | Logan | Kentucky | 21141 | 984 | 33 |
730028 | 730028 | 2020-11-14 | Logan | Kentucky | 21141 | 984 | 33 |
726785 | 726785 | 2020-11-13 | Logan | Kentucky | 21141 | 984 | 33 |
723542 | 723542 | 2020-11-12 | Logan | Kentucky | 21141 | 972 | 32 |
720299 | 720299 | 2020-11-11 | Logan | Kentucky | 21141 | 954 | 31 |
717056 | 717056 | 2020-11-10 | Logan | Kentucky | 21141 | 945 | 31 |
713812 | 713812 | 2020-11-09 | Logan | Kentucky | 21141 | 929 | 31 |
710568 | 710568 | 2020-11-08 | Logan | Kentucky | 21141 | 907 | 31 |
707324 | 707324 | 2020-11-07 | Logan | Kentucky | 21141 | 907 | 31 |
704081 | 704081 | 2020-11-06 | Logan | Kentucky | 21141 | 899 | 31 |
700839 | 700839 | 2020-11-05 | Logan | Kentucky | 21141 | 899 | 31 |
697595 | 697595 | 2020-11-04 | Logan | Kentucky | 21141 | 888 | 31 |
694352 | 694352 | 2020-11-03 | Logan | Kentucky | 21141 | 852 | 31 |
691110 | 691110 | 2020-11-02 | Logan | Kentucky | 21141 | 852 | 31 |
687865 | 687865 | 2020-11-01 | Logan | Kentucky | 21141 | 852 | 31 |
684621 | 684621 | 2020-10-31 | Logan | Kentucky | 21141 | 852 | 31 |
681378 | 681378 | 2020-10-30 | Logan | Kentucky | 21141 | 852 | 31 |
678134 | 678134 | 2020-10-29 | Logan | Kentucky | 21141 | 830 | 31 |
674892 | 674892 | 2020-10-28 | Logan | Kentucky | 21141 | 814 | 31 |
671649 | 671649 | 2020-10-27 | Logan | Kentucky | 21141 | 798 | 31 |
668407 | 668407 | 2020-10-26 | Logan | Kentucky | 21141 | 787 | 31 |
665163 | 665163 | 2020-10-25 | Logan | Kentucky | 21141 | 757 | 31 |
661918 | 661918 | 2020-10-24 | Logan | Kentucky | 21141 | 757 | 31 |
658674 | 658674 | 2020-10-23 | Logan | Kentucky | 21141 | 757 | 31 |
655429 | 655429 | 2020-10-22 | Logan | Kentucky | 21141 | 739 | 31 |
652184 | 652184 | 2020-10-21 | Logan | Kentucky | 21141 | 728 | 30 |
648939 | 648939 | 2020-10-20 | Logan | Kentucky | 21141 | 728 | 30 |
645695 | 645695 | 2020-10-19 | Logan | Kentucky | 21141 | 713 | 30 |
642448 | 642448 | 2020-10-18 | Logan | Kentucky | 21141 | 692 | 30 |
639201 | 639201 | 2020-10-17 | Logan | Kentucky | 21141 | 692 | 30 |
635955 | 635955 | 2020-10-16 | Logan | Kentucky | 21141 | 692 | 30 |
632709 | 632709 | 2020-10-15 | Logan | Kentucky | 21141 | 683 | 30 |
629465 | 629465 | 2020-10-14 | Logan | Kentucky | 21141 | 675 | 30 |
626221 | 626221 | 2020-10-13 | Logan | Kentucky | 21141 | 663 | 30 |
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);