ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where fips = 21087 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1090251 | 1090251 | 2021-03-05 | Green | Kentucky | 21087 | 1134 | 13 |
1087006 | 1087006 | 2021-03-04 | Green | Kentucky | 21087 | 1133 | 13 |
1083760 | 1083760 | 2021-03-03 | Green | Kentucky | 21087 | 1131 | 13 |
1080514 | 1080514 | 2021-03-02 | Green | Kentucky | 21087 | 1130 | 13 |
1077269 | 1077269 | 2021-03-01 | Green | Kentucky | 21087 | 1125 | 13 |
1074023 | 1074023 | 2021-02-28 | Green | Kentucky | 21087 | 1119 | 13 |
1070777 | 1070777 | 2021-02-27 | Green | Kentucky | 21087 | 1119 | 13 |
1067532 | 1067532 | 2021-02-26 | Green | Kentucky | 21087 | 1118 | 13 |
1064287 | 1064287 | 2021-02-25 | Green | Kentucky | 21087 | 1115 | 13 |
1061042 | 1061042 | 2021-02-24 | Green | Kentucky | 21087 | 1110 | 13 |
1057796 | 1057796 | 2021-02-23 | Green | Kentucky | 21087 | 1104 | 13 |
1054550 | 1054550 | 2021-02-22 | Green | Kentucky | 21087 | 1099 | 13 |
1051303 | 1051303 | 2021-02-21 | Green | Kentucky | 21087 | 1092 | 13 |
1048056 | 1048056 | 2021-02-20 | Green | Kentucky | 21087 | 1092 | 13 |
1044811 | 1044811 | 2021-02-19 | Green | Kentucky | 21087 | 1089 | 13 |
1041566 | 1041566 | 2021-02-18 | Green | Kentucky | 21087 | 1087 | 13 |
1038321 | 1038321 | 2021-02-17 | Green | Kentucky | 21087 | 1083 | 13 |
1035076 | 1035076 | 2021-02-16 | Green | Kentucky | 21087 | 1080 | 13 |
1031830 | 1031830 | 2021-02-15 | Green | Kentucky | 21087 | 1074 | 13 |
1028583 | 1028583 | 2021-02-14 | Green | Kentucky | 21087 | 1070 | 13 |
1025338 | 1025338 | 2021-02-13 | Green | Kentucky | 21087 | 1070 | 13 |
1022093 | 1022093 | 2021-02-12 | Green | Kentucky | 21087 | 1063 | 13 |
1018848 | 1018848 | 2021-02-11 | Green | Kentucky | 21087 | 1055 | 13 |
1015603 | 1015603 | 2021-02-10 | Green | Kentucky | 21087 | 1053 | 13 |
1012358 | 1012358 | 2021-02-09 | Green | Kentucky | 21087 | 1049 | 13 |
1009112 | 1009112 | 2021-02-08 | Green | Kentucky | 21087 | 1046 | 13 |
1005866 | 1005866 | 2021-02-07 | Green | Kentucky | 21087 | 1037 | 13 |
1002620 | 1002620 | 2021-02-06 | Green | Kentucky | 21087 | 1037 | 13 |
999374 | 999374 | 2021-02-05 | Green | Kentucky | 21087 | 1024 | 13 |
996128 | 996128 | 2021-02-04 | Green | Kentucky | 21087 | 1018 | 13 |
992882 | 992882 | 2021-02-03 | Green | Kentucky | 21087 | 1012 | 13 |
989636 | 989636 | 2021-02-02 | Green | Kentucky | 21087 | 1001 | 13 |
986389 | 986389 | 2021-02-01 | Green | Kentucky | 21087 | 995 | 13 |
983142 | 983142 | 2021-01-31 | Green | Kentucky | 21087 | 990 | 13 |
979896 | 979896 | 2021-01-30 | Green | Kentucky | 21087 | 985 | 13 |
976650 | 976650 | 2021-01-29 | Green | Kentucky | 21087 | 982 | 13 |
973405 | 973405 | 2021-01-28 | Green | Kentucky | 21087 | 980 | 13 |
970160 | 970160 | 2021-01-27 | Green | Kentucky | 21087 | 976 | 13 |
966916 | 966916 | 2021-01-26 | Green | Kentucky | 21087 | 971 | 13 |
963671 | 963671 | 2021-01-25 | Green | Kentucky | 21087 | 967 | 13 |
960426 | 960426 | 2021-01-24 | Green | Kentucky | 21087 | 963 | 13 |
957180 | 957180 | 2021-01-23 | Green | Kentucky | 21087 | 958 | 13 |
953935 | 953935 | 2021-01-22 | Green | Kentucky | 21087 | 948 | 13 |
950690 | 950690 | 2021-01-21 | Green | Kentucky | 21087 | 940 | 13 |
947444 | 947444 | 2021-01-20 | Green | Kentucky | 21087 | 932 | 13 |
944197 | 944197 | 2021-01-19 | Green | Kentucky | 21087 | 924 | 12 |
940952 | 940952 | 2021-01-18 | Green | Kentucky | 21087 | 915 | 12 |
937707 | 937707 | 2021-01-17 | Green | Kentucky | 21087 | 912 | 12 |
934462 | 934462 | 2021-01-16 | Green | Kentucky | 21087 | 910 | 12 |
931217 | 931217 | 2021-01-15 | Green | Kentucky | 21087 | 906 | 12 |
927972 | 927972 | 2021-01-14 | Green | Kentucky | 21087 | 897 | 12 |
924726 | 924726 | 2021-01-13 | Green | Kentucky | 21087 | 890 | 12 |
921481 | 921481 | 2021-01-12 | Green | Kentucky | 21087 | 883 | 12 |
918236 | 918236 | 2021-01-11 | Green | Kentucky | 21087 | 873 | 12 |
914991 | 914991 | 2021-01-10 | Green | Kentucky | 21087 | 870 | 12 |
911746 | 911746 | 2021-01-09 | Green | Kentucky | 21087 | 869 | 12 |
908501 | 908501 | 2021-01-08 | Green | Kentucky | 21087 | 858 | 12 |
905255 | 905255 | 2021-01-07 | Green | Kentucky | 21087 | 848 | 12 |
902010 | 902010 | 2021-01-06 | Green | Kentucky | 21087 | 840 | 12 |
898765 | 898765 | 2021-01-05 | Green | Kentucky | 21087 | 834 | 12 |
895520 | 895520 | 2021-01-04 | Green | Kentucky | 21087 | 829 | 12 |
892273 | 892273 | 2021-01-03 | Green | Kentucky | 21087 | 825 | 12 |
889027 | 889027 | 2021-01-02 | Green | Kentucky | 21087 | 821 | 12 |
885781 | 885781 | 2021-01-01 | Green | Kentucky | 21087 | 811 | 12 |
882536 | 882536 | 2020-12-31 | Green | Kentucky | 21087 | 811 | 12 |
879291 | 879291 | 2020-12-30 | Green | Kentucky | 21087 | 811 | 12 |
876046 | 876046 | 2020-12-29 | Green | Kentucky | 21087 | 802 | 12 |
872801 | 872801 | 2020-12-28 | Green | Kentucky | 21087 | 787 | 12 |
869556 | 869556 | 2020-12-27 | Green | Kentucky | 21087 | 784 | 12 |
866311 | 866311 | 2020-12-26 | Green | Kentucky | 21087 | 782 | 12 |
863066 | 863066 | 2020-12-25 | Green | Kentucky | 21087 | 773 | 12 |
859821 | 859821 | 2020-12-24 | Green | Kentucky | 21087 | 773 | 12 |
856576 | 856576 | 2020-12-23 | Green | Kentucky | 21087 | 773 | 12 |
853331 | 853331 | 2020-12-22 | Green | Kentucky | 21087 | 758 | 12 |
850086 | 850086 | 2020-12-21 | Green | Kentucky | 21087 | 749 | 11 |
846841 | 846841 | 2020-12-20 | Green | Kentucky | 21087 | 745 | 11 |
843595 | 843595 | 2020-12-19 | Green | Kentucky | 21087 | 744 | 11 |
840350 | 840350 | 2020-12-18 | Green | Kentucky | 21087 | 735 | 11 |
837105 | 837105 | 2020-12-17 | Green | Kentucky | 21087 | 730 | 11 |
833859 | 833859 | 2020-12-16 | Green | Kentucky | 21087 | 716 | 11 |
830612 | 830612 | 2020-12-15 | Green | Kentucky | 21087 | 706 | 11 |
827366 | 827366 | 2020-12-14 | Green | Kentucky | 21087 | 700 | 11 |
824119 | 824119 | 2020-12-13 | Green | Kentucky | 21087 | 696 | 10 |
820873 | 820873 | 2020-12-12 | Green | Kentucky | 21087 | 687 | 10 |
817627 | 817627 | 2020-12-11 | Green | Kentucky | 21087 | 680 | 10 |
814381 | 814381 | 2020-12-10 | Green | Kentucky | 21087 | 669 | 10 |
811136 | 811136 | 2020-12-09 | Green | Kentucky | 21087 | 660 | 10 |
807891 | 807891 | 2020-12-08 | Green | Kentucky | 21087 | 656 | 10 |
804646 | 804646 | 2020-12-07 | Green | Kentucky | 21087 | 648 | 10 |
801401 | 801401 | 2020-12-06 | Green | Kentucky | 21087 | 642 | 10 |
798156 | 798156 | 2020-12-05 | Green | Kentucky | 21087 | 639 | 10 |
794911 | 794911 | 2020-12-04 | Green | Kentucky | 21087 | 628 | 10 |
791666 | 791666 | 2020-12-03 | Green | Kentucky | 21087 | 620 | 10 |
788421 | 788421 | 2020-12-02 | Green | Kentucky | 21087 | 611 | 10 |
785177 | 785177 | 2020-12-01 | Green | Kentucky | 21087 | 594 | 10 |
781932 | 781932 | 2020-11-30 | Green | Kentucky | 21087 | 583 | 10 |
778686 | 778686 | 2020-11-29 | Green | Kentucky | 21087 | 574 | 10 |
775441 | 775441 | 2020-11-28 | Green | Kentucky | 21087 | 571 | 10 |
772196 | 772196 | 2020-11-27 | Green | Kentucky | 21087 | 571 | 10 |
768951 | 768951 | 2020-11-26 | Green | Kentucky | 21087 | 565 | 10 |
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);