ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
766 rows where county = "Jackson" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054561 | 1054561 | 2021-02-22 | Jackson | Kentucky | 21109 | 1187 | 29 |
1051314 | 1051314 | 2021-02-21 | Jackson | Kentucky | 21109 | 1186 | 29 |
1048067 | 1048067 | 2021-02-20 | Jackson | Kentucky | 21109 | 1186 | 29 |
1044822 | 1044822 | 2021-02-19 | Jackson | Kentucky | 21109 | 1181 | 29 |
1041577 | 1041577 | 2021-02-18 | Jackson | Kentucky | 21109 | 1175 | 29 |
1038332 | 1038332 | 2021-02-17 | Jackson | Kentucky | 21109 | 1175 | 29 |
1035087 | 1035087 | 2021-02-16 | Jackson | Kentucky | 21109 | 1174 | 29 |
1031841 | 1031841 | 2021-02-15 | Jackson | Kentucky | 21109 | 1173 | 29 |
1028594 | 1028594 | 2021-02-14 | Jackson | Kentucky | 21109 | 1173 | 29 |
1025349 | 1025349 | 2021-02-13 | Jackson | Kentucky | 21109 | 1173 | 29 |
1022104 | 1022104 | 2021-02-12 | Jackson | Kentucky | 21109 | 1171 | 28 |
1018859 | 1018859 | 2021-02-11 | Jackson | Kentucky | 21109 | 1170 | 27 |
1015614 | 1015614 | 2021-02-10 | Jackson | Kentucky | 21109 | 1167 | 27 |
1012369 | 1012369 | 2021-02-09 | Jackson | Kentucky | 21109 | 1165 | 27 |
1009123 | 1009123 | 2021-02-08 | Jackson | Kentucky | 21109 | 1146 | 27 |
1005877 | 1005877 | 2021-02-07 | Jackson | Kentucky | 21109 | 1140 | 27 |
1002631 | 1002631 | 2021-02-06 | Jackson | Kentucky | 21109 | 1135 | 27 |
999385 | 999385 | 2021-02-05 | Jackson | Kentucky | 21109 | 1126 | 27 |
996139 | 996139 | 2021-02-04 | Jackson | Kentucky | 21109 | 1122 | 27 |
992893 | 992893 | 2021-02-03 | Jackson | Kentucky | 21109 | 1117 | 27 |
989647 | 989647 | 2021-02-02 | Jackson | Kentucky | 21109 | 1114 | 27 |
986400 | 986400 | 2021-02-01 | Jackson | Kentucky | 21109 | 1107 | 27 |
983153 | 983153 | 2021-01-31 | Jackson | Kentucky | 21109 | 1107 | 27 |
979907 | 979907 | 2021-01-30 | Jackson | Kentucky | 21109 | 1106 | 27 |
976661 | 976661 | 2021-01-29 | Jackson | Kentucky | 21109 | 1101 | 27 |
973416 | 973416 | 2021-01-28 | Jackson | Kentucky | 21109 | 1096 | 25 |
970171 | 970171 | 2021-01-27 | Jackson | Kentucky | 21109 | 1090 | 24 |
966927 | 966927 | 2021-01-26 | Jackson | Kentucky | 21109 | 1088 | 24 |
963682 | 963682 | 2021-01-25 | Jackson | Kentucky | 21109 | 1083 | 24 |
960437 | 960437 | 2021-01-24 | Jackson | Kentucky | 21109 | 1082 | 24 |
957191 | 957191 | 2021-01-23 | Jackson | Kentucky | 21109 | 1080 | 23 |
953946 | 953946 | 2021-01-22 | Jackson | Kentucky | 21109 | 1074 | 23 |
950701 | 950701 | 2021-01-21 | Jackson | Kentucky | 21109 | 1069 | 23 |
947455 | 947455 | 2021-01-20 | Jackson | Kentucky | 21109 | 1061 | 23 |
944208 | 944208 | 2021-01-19 | Jackson | Kentucky | 21109 | 1058 | 23 |
940963 | 940963 | 2021-01-18 | Jackson | Kentucky | 21109 | 1057 | 23 |
937718 | 937718 | 2021-01-17 | Jackson | Kentucky | 21109 | 1049 | 22 |
934473 | 934473 | 2021-01-16 | Jackson | Kentucky | 21109 | 1042 | 22 |
931228 | 931228 | 2021-01-15 | Jackson | Kentucky | 21109 | 1033 | 22 |
927983 | 927983 | 2021-01-14 | Jackson | Kentucky | 21109 | 1021 | 22 |
924737 | 924737 | 2021-01-13 | Jackson | Kentucky | 21109 | 1012 | 22 |
921492 | 921492 | 2021-01-12 | Jackson | Kentucky | 21109 | 1005 | 21 |
918247 | 918247 | 2021-01-11 | Jackson | Kentucky | 21109 | 992 | 21 |
915002 | 915002 | 2021-01-10 | Jackson | Kentucky | 21109 | 986 | 21 |
911757 | 911757 | 2021-01-09 | Jackson | Kentucky | 21109 | 984 | 21 |
908512 | 908512 | 2021-01-08 | Jackson | Kentucky | 21109 | 954 | 21 |
905266 | 905266 | 2021-01-07 | Jackson | Kentucky | 21109 | 940 | 21 |
902021 | 902021 | 2021-01-06 | Jackson | Kentucky | 21109 | 922 | 21 |
898776 | 898776 | 2021-01-05 | Jackson | Kentucky | 21109 | 896 | 21 |
895531 | 895531 | 2021-01-04 | Jackson | Kentucky | 21109 | 878 | 21 |
892284 | 892284 | 2021-01-03 | Jackson | Kentucky | 21109 | 876 | 21 |
889038 | 889038 | 2021-01-02 | Jackson | Kentucky | 21109 | 870 | 21 |
885792 | 885792 | 2021-01-01 | Jackson | Kentucky | 21109 | 846 | 19 |
882547 | 882547 | 2020-12-31 | Jackson | Kentucky | 21109 | 846 | 19 |
879302 | 879302 | 2020-12-30 | Jackson | Kentucky | 21109 | 846 | 19 |
876057 | 876057 | 2020-12-29 | Jackson | Kentucky | 21109 | 834 | 19 |
872812 | 872812 | 2020-12-28 | Jackson | Kentucky | 21109 | 823 | 19 |
869567 | 869567 | 2020-12-27 | Jackson | Kentucky | 21109 | 822 | 19 |
866322 | 866322 | 2020-12-26 | Jackson | Kentucky | 21109 | 820 | 19 |
863077 | 863077 | 2020-12-25 | Jackson | Kentucky | 21109 | 802 | 19 |
859832 | 859832 | 2020-12-24 | Jackson | Kentucky | 21109 | 802 | 19 |
856587 | 856587 | 2020-12-23 | Jackson | Kentucky | 21109 | 802 | 19 |
853342 | 853342 | 2020-12-22 | Jackson | Kentucky | 21109 | 794 | 19 |
850097 | 850097 | 2020-12-21 | Jackson | Kentucky | 21109 | 783 | 18 |
846852 | 846852 | 2020-12-20 | Jackson | Kentucky | 21109 | 779 | 18 |
843606 | 843606 | 2020-12-19 | Jackson | Kentucky | 21109 | 779 | 18 |
840361 | 840361 | 2020-12-18 | Jackson | Kentucky | 21109 | 771 | 18 |
837116 | 837116 | 2020-12-17 | Jackson | Kentucky | 21109 | 767 | 18 |
833870 | 833870 | 2020-12-16 | Jackson | Kentucky | 21109 | 759 | 18 |
830623 | 830623 | 2020-12-15 | Jackson | Kentucky | 21109 | 744 | 18 |
827377 | 827377 | 2020-12-14 | Jackson | Kentucky | 21109 | 737 | 18 |
824130 | 824130 | 2020-12-13 | Jackson | Kentucky | 21109 | 735 | 18 |
820884 | 820884 | 2020-12-12 | Jackson | Kentucky | 21109 | 728 | 18 |
817638 | 817638 | 2020-12-11 | Jackson | Kentucky | 21109 | 726 | 18 |
814392 | 814392 | 2020-12-10 | Jackson | Kentucky | 21109 | 715 | 17 |
811147 | 811147 | 2020-12-09 | Jackson | Kentucky | 21109 | 706 | 17 |
807902 | 807902 | 2020-12-08 | Jackson | Kentucky | 21109 | 703 | 17 |
804657 | 804657 | 2020-12-07 | Jackson | Kentucky | 21109 | 693 | 17 |
801412 | 801412 | 2020-12-06 | Jackson | Kentucky | 21109 | 693 | 17 |
798167 | 798167 | 2020-12-05 | Jackson | Kentucky | 21109 | 690 | 17 |
794922 | 794922 | 2020-12-04 | Jackson | Kentucky | 21109 | 687 | 17 |
791677 | 791677 | 2020-12-03 | Jackson | Kentucky | 21109 | 677 | 17 |
788432 | 788432 | 2020-12-02 | Jackson | Kentucky | 21109 | 670 | 17 |
785188 | 785188 | 2020-12-01 | Jackson | Kentucky | 21109 | 667 | 17 |
781943 | 781943 | 2020-11-30 | Jackson | Kentucky | 21109 | 652 | 17 |
778697 | 778697 | 2020-11-29 | Jackson | Kentucky | 21109 | 648 | 17 |
775452 | 775452 | 2020-11-28 | Jackson | Kentucky | 21109 | 646 | 17 |
772207 | 772207 | 2020-11-27 | Jackson | Kentucky | 21109 | 645 | 17 |
768962 | 768962 | 2020-11-26 | Jackson | Kentucky | 21109 | 637 | 17 |
765716 | 765716 | 2020-11-25 | Jackson | Kentucky | 21109 | 637 | 17 |
762471 | 762471 | 2020-11-24 | Jackson | Kentucky | 21109 | 630 | 17 |
759226 | 759226 | 2020-11-23 | Jackson | Kentucky | 21109 | 626 | 17 |
755979 | 755979 | 2020-11-22 | Jackson | Kentucky | 21109 | 622 | 17 |
752733 | 752733 | 2020-11-21 | Jackson | Kentucky | 21109 | 621 | 18 |
749487 | 749487 | 2020-11-20 | Jackson | Kentucky | 21109 | 611 | 17 |
746241 | 746241 | 2020-11-19 | Jackson | Kentucky | 21109 | 601 | 17 |
742994 | 742994 | 2020-11-18 | Jackson | Kentucky | 21109 | 594 | 17 |
739747 | 739747 | 2020-11-17 | Jackson | Kentucky | 21109 | 581 | 17 |
736503 | 736503 | 2020-11-16 | Jackson | Kentucky | 21109 | 571 | 17 |
733257 | 733257 | 2020-11-15 | Jackson | Kentucky | 21109 | 570 | 17 |
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);