ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 21151 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194182 | 1194182 | 2021-04-06 | Madison | Kentucky | 21151 | 9045 | 108 |
1190932 | 1190932 | 2021-04-05 | Madison | Kentucky | 21151 | 9045 | 108 |
1187685 | 1187685 | 2021-04-04 | Madison | Kentucky | 21151 | 9036 | 108 |
1184438 | 1184438 | 2021-04-03 | Madison | Kentucky | 21151 | 9036 | 108 |
1181191 | 1181191 | 2021-04-02 | Madison | Kentucky | 21151 | 9029 | 108 |
1177944 | 1177944 | 2021-04-01 | Madison | Kentucky | 21151 | 9021 | 107 |
1174697 | 1174697 | 2021-03-31 | Madison | Kentucky | 21151 | 9003 | 107 |
1171450 | 1171450 | 2021-03-30 | Madison | Kentucky | 21151 | 8994 | 107 |
1168202 | 1168202 | 2021-03-29 | Madison | Kentucky | 21151 | 8984 | 107 |
1164954 | 1164954 | 2021-03-28 | Madison | Kentucky | 21151 | 8975 | 107 |
1161706 | 1161706 | 2021-03-27 | Madison | Kentucky | 21151 | 8966 | 107 |
1158458 | 1158458 | 2021-03-26 | Madison | Kentucky | 21151 | 8958 | 107 |
1155211 | 1155211 | 2021-03-25 | Madison | Kentucky | 21151 | 8939 | 106 |
1151964 | 1151964 | 2021-03-24 | Madison | Kentucky | 21151 | 8932 | 105 |
1148717 | 1148717 | 2021-03-23 | Madison | Kentucky | 21151 | 8926 | 103 |
1145470 | 1145470 | 2021-03-22 | Madison | Kentucky | 21151 | 8902 | 103 |
1142223 | 1142223 | 2021-03-21 | Madison | Kentucky | 21151 | 8891 | 103 |
1138977 | 1138977 | 2021-03-20 | Madison | Kentucky | 21151 | 8884 | 103 |
1135731 | 1135731 | 2021-03-19 | Madison | Kentucky | 21151 | 8882 | 103 |
1132484 | 1132484 | 2021-03-18 | Madison | Kentucky | 21151 | 8873 | 99 |
1129236 | 1129236 | 2021-03-17 | Madison | Kentucky | 21151 | 8851 | 90 |
1125990 | 1125990 | 2021-03-16 | Madison | Kentucky | 21151 | 8843 | 90 |
1122744 | 1122744 | 2021-03-15 | Madison | Kentucky | 21151 | 8831 | 90 |
1119497 | 1119497 | 2021-03-14 | Madison | Kentucky | 21151 | 8822 | 90 |
1116250 | 1116250 | 2021-03-13 | Madison | Kentucky | 21151 | 8820 | 90 |
1113004 | 1113004 | 2021-03-12 | Madison | Kentucky | 21151 | 8808 | 90 |
1109758 | 1109758 | 2021-03-11 | Madison | Kentucky | 21151 | 8799 | 90 |
1106512 | 1106512 | 2021-03-10 | Madison | Kentucky | 21151 | 8784 | 90 |
1103266 | 1103266 | 2021-03-09 | Madison | Kentucky | 21151 | 8771 | 90 |
1100020 | 1100020 | 2021-03-08 | Madison | Kentucky | 21151 | 8746 | 90 |
1096772 | 1096772 | 2021-03-07 | Madison | Kentucky | 21151 | 8745 | 90 |
1093526 | 1093526 | 2021-03-06 | Madison | Kentucky | 21151 | 8740 | 90 |
1090280 | 1090280 | 2021-03-05 | Madison | Kentucky | 21151 | 8724 | 90 |
1087035 | 1087035 | 2021-03-04 | Madison | Kentucky | 21151 | 8708 | 90 |
1083789 | 1083789 | 2021-03-03 | Madison | Kentucky | 21151 | 8695 | 89 |
1080543 | 1080543 | 2021-03-02 | Madison | Kentucky | 21151 | 8671 | 89 |
1077298 | 1077298 | 2021-03-01 | Madison | Kentucky | 21151 | 8644 | 86 |
1074052 | 1074052 | 2021-02-28 | Madison | Kentucky | 21151 | 8638 | 86 |
1070806 | 1070806 | 2021-02-27 | Madison | Kentucky | 21151 | 8623 | 86 |
1067561 | 1067561 | 2021-02-26 | Madison | Kentucky | 21151 | 8606 | 86 |
1064316 | 1064316 | 2021-02-25 | Madison | Kentucky | 21151 | 8587 | 86 |
1061071 | 1061071 | 2021-02-24 | Madison | Kentucky | 21151 | 8559 | 84 |
1057825 | 1057825 | 2021-02-23 | Madison | Kentucky | 21151 | 8537 | 79 |
1054579 | 1054579 | 2021-02-22 | Madison | Kentucky | 21151 | 8510 | 79 |
1051332 | 1051332 | 2021-02-21 | Madison | Kentucky | 21151 | 8501 | 79 |
1048085 | 1048085 | 2021-02-20 | Madison | Kentucky | 21151 | 8486 | 79 |
1044840 | 1044840 | 2021-02-19 | Madison | Kentucky | 21151 | 8473 | 79 |
1041595 | 1041595 | 2021-02-18 | Madison | Kentucky | 21151 | 8418 | 79 |
1038350 | 1038350 | 2021-02-17 | Madison | Kentucky | 21151 | 8395 | 79 |
1035105 | 1035105 | 2021-02-16 | Madison | Kentucky | 21151 | 8363 | 78 |
1031859 | 1031859 | 2021-02-15 | Madison | Kentucky | 21151 | 8342 | 77 |
1028612 | 1028612 | 2021-02-14 | Madison | Kentucky | 21151 | 8306 | 77 |
1025367 | 1025367 | 2021-02-13 | Madison | Kentucky | 21151 | 8290 | 77 |
1022122 | 1022122 | 2021-02-12 | Madison | Kentucky | 21151 | 8278 | 77 |
1018877 | 1018877 | 2021-02-11 | Madison | Kentucky | 21151 | 8234 | 73 |
1015632 | 1015632 | 2021-02-10 | Madison | Kentucky | 21151 | 8205 | 66 |
1012387 | 1012387 | 2021-02-09 | Madison | Kentucky | 21151 | 8145 | 65 |
1009141 | 1009141 | 2021-02-08 | Madison | Kentucky | 21151 | 8063 | 65 |
1005895 | 1005895 | 2021-02-07 | Madison | Kentucky | 21151 | 8036 | 65 |
1002649 | 1002649 | 2021-02-06 | Madison | Kentucky | 21151 | 8003 | 63 |
999403 | 999403 | 2021-02-05 | Madison | Kentucky | 21151 | 7972 | 57 |
996157 | 996157 | 2021-02-04 | Madison | Kentucky | 21151 | 7942 | 57 |
992911 | 992911 | 2021-02-03 | Madison | Kentucky | 21151 | 7831 | 57 |
989665 | 989665 | 2021-02-02 | Madison | Kentucky | 21151 | 7774 | 57 |
986418 | 986418 | 2021-02-01 | Madison | Kentucky | 21151 | 7696 | 57 |
983171 | 983171 | 2021-01-31 | Madison | Kentucky | 21151 | 7585 | 56 |
979925 | 979925 | 2021-01-30 | Madison | Kentucky | 21151 | 7536 | 56 |
976679 | 976679 | 2021-01-29 | Madison | Kentucky | 21151 | 7494 | 53 |
973434 | 973434 | 2021-01-28 | Madison | Kentucky | 21151 | 7480 | 50 |
970189 | 970189 | 2021-01-27 | Madison | Kentucky | 21151 | 7418 | 49 |
966945 | 966945 | 2021-01-26 | Madison | Kentucky | 21151 | 7349 | 49 |
963700 | 963700 | 2021-01-25 | Madison | Kentucky | 21151 | 7285 | 49 |
960455 | 960455 | 2021-01-24 | Madison | Kentucky | 21151 | 7254 | 47 |
957209 | 957209 | 2021-01-23 | Madison | Kentucky | 21151 | 7224 | 47 |
953964 | 953964 | 2021-01-22 | Madison | Kentucky | 21151 | 7183 | 48 |
950719 | 950719 | 2021-01-21 | Madison | Kentucky | 21151 | 7142 | 48 |
947473 | 947473 | 2021-01-20 | Madison | Kentucky | 21151 | 7030 | 48 |
944226 | 944226 | 2021-01-19 | Madison | Kentucky | 21151 | 6930 | 46 |
940981 | 940981 | 2021-01-18 | Madison | Kentucky | 21151 | 6883 | 45 |
937736 | 937736 | 2021-01-17 | Madison | Kentucky | 21151 | 6819 | 45 |
934491 | 934491 | 2021-01-16 | Madison | Kentucky | 21151 | 6786 | 45 |
931246 | 931246 | 2021-01-15 | Madison | Kentucky | 21151 | 6743 | 43 |
928001 | 928001 | 2021-01-14 | Madison | Kentucky | 21151 | 6674 | 43 |
924755 | 924755 | 2021-01-13 | Madison | Kentucky | 21151 | 6594 | 43 |
921510 | 921510 | 2021-01-12 | Madison | Kentucky | 21151 | 6531 | 42 |
918265 | 918265 | 2021-01-11 | Madison | Kentucky | 21151 | 6385 | 40 |
915020 | 915020 | 2021-01-10 | Madison | Kentucky | 21151 | 6320 | 42 |
911775 | 911775 | 2021-01-09 | Madison | Kentucky | 21151 | 6246 | 40 |
908530 | 908530 | 2021-01-08 | Madison | Kentucky | 21151 | 6197 | 39 |
905284 | 905284 | 2021-01-07 | Madison | Kentucky | 21151 | 6124 | 38 |
902039 | 902039 | 2021-01-06 | Madison | Kentucky | 21151 | 6037 | 38 |
898794 | 898794 | 2021-01-05 | Madison | Kentucky | 21151 | 5927 | 39 |
895549 | 895549 | 2021-01-04 | Madison | Kentucky | 21151 | 5901 | 39 |
892302 | 892302 | 2021-01-03 | Madison | Kentucky | 21151 | 5861 | 39 |
889056 | 889056 | 2021-01-02 | Madison | Kentucky | 21151 | 5830 | 39 |
885810 | 885810 | 2021-01-01 | Madison | Kentucky | 21151 | 5706 | 35 |
882565 | 882565 | 2020-12-31 | Madison | Kentucky | 21151 | 5706 | 35 |
879320 | 879320 | 2020-12-30 | Madison | Kentucky | 21151 | 5706 | 35 |
876075 | 876075 | 2020-12-29 | Madison | Kentucky | 21151 | 5673 | 36 |
872830 | 872830 | 2020-12-28 | Madison | Kentucky | 21151 | 5638 | 36 |
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);