ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Montgomery" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1090294 | 1090294 | 2021-03-05 | Montgomery | Kentucky | 21173 | 2320 | 24 |
1087049 | 1087049 | 2021-03-04 | Montgomery | Kentucky | 21173 | 2317 | 24 |
1083803 | 1083803 | 2021-03-03 | Montgomery | Kentucky | 21173 | 2311 | 24 |
1080557 | 1080557 | 2021-03-02 | Montgomery | Kentucky | 21173 | 2307 | 24 |
1077312 | 1077312 | 2021-03-01 | Montgomery | Kentucky | 21173 | 2307 | 24 |
1074066 | 1074066 | 2021-02-28 | Montgomery | Kentucky | 21173 | 2306 | 24 |
1070820 | 1070820 | 2021-02-27 | Montgomery | Kentucky | 21173 | 2306 | 24 |
1067575 | 1067575 | 2021-02-26 | Montgomery | Kentucky | 21173 | 2300 | 24 |
1064330 | 1064330 | 2021-02-25 | Montgomery | Kentucky | 21173 | 2299 | 24 |
1061085 | 1061085 | 2021-02-24 | Montgomery | Kentucky | 21173 | 2281 | 24 |
1057839 | 1057839 | 2021-02-23 | Montgomery | Kentucky | 21173 | 2277 | 23 |
1054593 | 1054593 | 2021-02-22 | Montgomery | Kentucky | 21173 | 2273 | 23 |
1051346 | 1051346 | 2021-02-21 | Montgomery | Kentucky | 21173 | 2272 | 23 |
1048099 | 1048099 | 2021-02-20 | Montgomery | Kentucky | 21173 | 2271 | 23 |
1044854 | 1044854 | 2021-02-19 | Montgomery | Kentucky | 21173 | 2270 | 23 |
1041609 | 1041609 | 2021-02-18 | Montgomery | Kentucky | 21173 | 2245 | 23 |
1038364 | 1038364 | 2021-02-17 | Montgomery | Kentucky | 21173 | 2215 | 23 |
1035119 | 1035119 | 2021-02-16 | Montgomery | Kentucky | 21173 | 2203 | 23 |
1031873 | 1031873 | 2021-02-15 | Montgomery | Kentucky | 21173 | 2180 | 23 |
1028626 | 1028626 | 2021-02-14 | Montgomery | Kentucky | 21173 | 2177 | 23 |
1025381 | 1025381 | 2021-02-13 | Montgomery | Kentucky | 21173 | 2155 | 23 |
1022136 | 1022136 | 2021-02-12 | Montgomery | Kentucky | 21173 | 2138 | 23 |
1018891 | 1018891 | 2021-02-11 | Montgomery | Kentucky | 21173 | 2132 | 23 |
1015646 | 1015646 | 2021-02-10 | Montgomery | Kentucky | 21173 | 2102 | 23 |
1012401 | 1012401 | 2021-02-09 | Montgomery | Kentucky | 21173 | 2061 | 23 |
1009155 | 1009155 | 2021-02-08 | Montgomery | Kentucky | 21173 | 2054 | 23 |
1005909 | 1005909 | 2021-02-07 | Montgomery | Kentucky | 21173 | 2053 | 23 |
1002663 | 1002663 | 2021-02-06 | Montgomery | Kentucky | 21173 | 2050 | 23 |
999417 | 999417 | 2021-02-05 | Montgomery | Kentucky | 21173 | 2032 | 23 |
996171 | 996171 | 2021-02-04 | Montgomery | Kentucky | 21173 | 2018 | 23 |
992925 | 992925 | 2021-02-03 | Montgomery | Kentucky | 21173 | 1999 | 22 |
989679 | 989679 | 2021-02-02 | Montgomery | Kentucky | 21173 | 1992 | 21 |
986432 | 986432 | 2021-02-01 | Montgomery | Kentucky | 21173 | 1969 | 21 |
983185 | 983185 | 2021-01-31 | Montgomery | Kentucky | 21173 | 1967 | 21 |
979939 | 979939 | 2021-01-30 | Montgomery | Kentucky | 21173 | 1963 | 21 |
976693 | 976693 | 2021-01-29 | Montgomery | Kentucky | 21173 | 1940 | 21 |
973448 | 973448 | 2021-01-28 | Montgomery | Kentucky | 21173 | 1937 | 21 |
970203 | 970203 | 2021-01-27 | Montgomery | Kentucky | 21173 | 1926 | 21 |
966959 | 966959 | 2021-01-26 | Montgomery | Kentucky | 21173 | 1906 | 21 |
963714 | 963714 | 2021-01-25 | Montgomery | Kentucky | 21173 | 1894 | 20 |
960469 | 960469 | 2021-01-24 | Montgomery | Kentucky | 21173 | 1892 | 20 |
957223 | 957223 | 2021-01-23 | Montgomery | Kentucky | 21173 | 1891 | 20 |
953978 | 953978 | 2021-01-22 | Montgomery | Kentucky | 21173 | 1874 | 16 |
950733 | 950733 | 2021-01-21 | Montgomery | Kentucky | 21173 | 1851 | 16 |
947487 | 947487 | 2021-01-20 | Montgomery | Kentucky | 21173 | 1816 | 16 |
944240 | 944240 | 2021-01-19 | Montgomery | Kentucky | 21173 | 1807 | 16 |
940995 | 940995 | 2021-01-18 | Montgomery | Kentucky | 21173 | 1788 | 16 |
937750 | 937750 | 2021-01-17 | Montgomery | Kentucky | 21173 | 1779 | 15 |
934505 | 934505 | 2021-01-16 | Montgomery | Kentucky | 21173 | 1773 | 15 |
931260 | 931260 | 2021-01-15 | Montgomery | Kentucky | 21173 | 1748 | 15 |
928015 | 928015 | 2021-01-14 | Montgomery | Kentucky | 21173 | 1722 | 15 |
924769 | 924769 | 2021-01-13 | Montgomery | Kentucky | 21173 | 1691 | 12 |
921524 | 921524 | 2021-01-12 | Montgomery | Kentucky | 21173 | 1661 | 12 |
918279 | 918279 | 2021-01-11 | Montgomery | Kentucky | 21173 | 1626 | 12 |
915034 | 915034 | 2021-01-10 | Montgomery | Kentucky | 21173 | 1614 | 12 |
911789 | 911789 | 2021-01-09 | Montgomery | Kentucky | 21173 | 1601 | 12 |
908544 | 908544 | 2021-01-08 | Montgomery | Kentucky | 21173 | 1569 | 12 |
905298 | 905298 | 2021-01-07 | Montgomery | Kentucky | 21173 | 1525 | 12 |
902053 | 902053 | 2021-01-06 | Montgomery | Kentucky | 21173 | 1489 | 12 |
898808 | 898808 | 2021-01-05 | Montgomery | Kentucky | 21173 | 1472 | 12 |
895563 | 895563 | 2021-01-04 | Montgomery | Kentucky | 21173 | 1467 | 12 |
892316 | 892316 | 2021-01-03 | Montgomery | Kentucky | 21173 | 1459 | 12 |
889070 | 889070 | 2021-01-02 | Montgomery | Kentucky | 21173 | 1439 | 12 |
885824 | 885824 | 2021-01-01 | Montgomery | Kentucky | 21173 | 1378 | 12 |
882579 | 882579 | 2020-12-31 | Montgomery | Kentucky | 21173 | 1378 | 12 |
879334 | 879334 | 2020-12-30 | Montgomery | Kentucky | 21173 | 1378 | 12 |
876089 | 876089 | 2020-12-29 | Montgomery | Kentucky | 21173 | 1350 | 12 |
872844 | 872844 | 2020-12-28 | Montgomery | Kentucky | 21173 | 1337 | 12 |
869599 | 869599 | 2020-12-27 | Montgomery | Kentucky | 21173 | 1335 | 12 |
866354 | 866354 | 2020-12-26 | Montgomery | Kentucky | 21173 | 1328 | 12 |
863109 | 863109 | 2020-12-25 | Montgomery | Kentucky | 21173 | 1303 | 12 |
859864 | 859864 | 2020-12-24 | Montgomery | Kentucky | 21173 | 1303 | 12 |
856619 | 856619 | 2020-12-23 | Montgomery | Kentucky | 21173 | 1303 | 12 |
853374 | 853374 | 2020-12-22 | Montgomery | Kentucky | 21173 | 1295 | 12 |
850129 | 850129 | 2020-12-21 | Montgomery | Kentucky | 21173 | 1281 | 12 |
846884 | 846884 | 2020-12-20 | Montgomery | Kentucky | 21173 | 1274 | 12 |
843638 | 843638 | 2020-12-19 | Montgomery | Kentucky | 21173 | 1272 | 12 |
840393 | 840393 | 2020-12-18 | Montgomery | Kentucky | 21173 | 1256 | 12 |
837148 | 837148 | 2020-12-17 | Montgomery | Kentucky | 21173 | 1237 | 12 |
833902 | 833902 | 2020-12-16 | Montgomery | Kentucky | 21173 | 1213 | 12 |
830655 | 830655 | 2020-12-15 | Montgomery | Kentucky | 21173 | 1205 | 12 |
827409 | 827409 | 2020-12-14 | Montgomery | Kentucky | 21173 | 1187 | 12 |
824162 | 824162 | 2020-12-13 | Montgomery | Kentucky | 21173 | 1185 | 12 |
820916 | 820916 | 2020-12-12 | Montgomery | Kentucky | 21173 | 1182 | 12 |
817670 | 817670 | 2020-12-11 | Montgomery | Kentucky | 21173 | 1168 | 12 |
814424 | 814424 | 2020-12-10 | Montgomery | Kentucky | 21173 | 1138 | 12 |
811179 | 811179 | 2020-12-09 | Montgomery | Kentucky | 21173 | 1115 | 11 |
807934 | 807934 | 2020-12-08 | Montgomery | Kentucky | 21173 | 1100 | 11 |
804689 | 804689 | 2020-12-07 | Montgomery | Kentucky | 21173 | 1063 | 11 |
801444 | 801444 | 2020-12-06 | Montgomery | Kentucky | 21173 | 1058 | 11 |
798199 | 798199 | 2020-12-05 | Montgomery | Kentucky | 21173 | 1049 | 11 |
794954 | 794954 | 2020-12-04 | Montgomery | Kentucky | 21173 | 1018 | 11 |
791709 | 791709 | 2020-12-03 | Montgomery | Kentucky | 21173 | 1005 | 11 |
788464 | 788464 | 2020-12-02 | Montgomery | Kentucky | 21173 | 985 | 10 |
785220 | 785220 | 2020-12-01 | Montgomery | Kentucky | 21173 | 961 | 10 |
781975 | 781975 | 2020-11-30 | Montgomery | Kentucky | 21173 | 911 | 9 |
778729 | 778729 | 2020-11-29 | Montgomery | Kentucky | 21173 | 898 | 9 |
775484 | 775484 | 2020-11-28 | Montgomery | Kentucky | 21173 | 887 | 9 |
772239 | 772239 | 2020-11-27 | Montgomery | Kentucky | 21173 | 880 | 9 |
768994 | 768994 | 2020-11-26 | Montgomery | Kentucky | 21173 | 871 | 8 |
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);