ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 21049 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1090232 | 1090232 | 2021-03-05 | Clark | Kentucky | 21049 | 2441 | 24 |
1086987 | 1086987 | 2021-03-04 | Clark | Kentucky | 21049 | 2434 | 23 |
1083741 | 1083741 | 2021-03-03 | Clark | Kentucky | 21049 | 2429 | 23 |
1080495 | 1080495 | 2021-03-02 | Clark | Kentucky | 21049 | 2417 | 20 |
1077250 | 1077250 | 2021-03-01 | Clark | Kentucky | 21049 | 2409 | 20 |
1074004 | 1074004 | 2021-02-28 | Clark | Kentucky | 21049 | 2409 | 20 |
1070758 | 1070758 | 2021-02-27 | Clark | Kentucky | 21049 | 2409 | 20 |
1067513 | 1067513 | 2021-02-26 | Clark | Kentucky | 21049 | 2409 | 20 |
1064268 | 1064268 | 2021-02-25 | Clark | Kentucky | 21049 | 2407 | 18 |
1061023 | 1061023 | 2021-02-24 | Clark | Kentucky | 21049 | 2394 | 18 |
1057777 | 1057777 | 2021-02-23 | Clark | Kentucky | 21049 | 2384 | 18 |
1054531 | 1054531 | 2021-02-22 | Clark | Kentucky | 21049 | 2372 | 18 |
1051284 | 1051284 | 2021-02-21 | Clark | Kentucky | 21049 | 2371 | 18 |
1048037 | 1048037 | 2021-02-20 | Clark | Kentucky | 21049 | 2370 | 18 |
1044792 | 1044792 | 2021-02-19 | Clark | Kentucky | 21049 | 2369 | 18 |
1041547 | 1041547 | 2021-02-18 | Clark | Kentucky | 21049 | 2346 | 18 |
1038302 | 1038302 | 2021-02-17 | Clark | Kentucky | 21049 | 2341 | 18 |
1035057 | 1035057 | 2021-02-16 | Clark | Kentucky | 21049 | 2336 | 18 |
1031811 | 1031811 | 2021-02-15 | Clark | Kentucky | 21049 | 2311 | 18 |
1028564 | 1028564 | 2021-02-14 | Clark | Kentucky | 21049 | 2309 | 18 |
1025319 | 1025319 | 2021-02-13 | Clark | Kentucky | 21049 | 2312 | 18 |
1022074 | 1022074 | 2021-02-12 | Clark | Kentucky | 21049 | 2311 | 17 |
1018829 | 1018829 | 2021-02-11 | Clark | Kentucky | 21049 | 2303 | 16 |
1015584 | 1015584 | 2021-02-10 | Clark | Kentucky | 21049 | 2301 | 16 |
1012339 | 1012339 | 2021-02-09 | Clark | Kentucky | 21049 | 2284 | 16 |
1009093 | 1009093 | 2021-02-08 | Clark | Kentucky | 21049 | 2277 | 16 |
1005847 | 1005847 | 2021-02-07 | Clark | Kentucky | 21049 | 2274 | 16 |
1002601 | 1002601 | 2021-02-06 | Clark | Kentucky | 21049 | 2270 | 16 |
999355 | 999355 | 2021-02-05 | Clark | Kentucky | 21049 | 2256 | 16 |
996109 | 996109 | 2021-02-04 | Clark | Kentucky | 21049 | 2239 | 16 |
992863 | 992863 | 2021-02-03 | Clark | Kentucky | 21049 | 2200 | 16 |
989617 | 989617 | 2021-02-02 | Clark | Kentucky | 21049 | 2179 | 16 |
986370 | 986370 | 2021-02-01 | Clark | Kentucky | 21049 | 2160 | 16 |
983123 | 983123 | 2021-01-31 | Clark | Kentucky | 21049 | 2152 | 16 |
979877 | 979877 | 2021-01-30 | Clark | Kentucky | 21049 | 2149 | 16 |
976631 | 976631 | 2021-01-29 | Clark | Kentucky | 21049 | 2134 | 16 |
973386 | 973386 | 2021-01-28 | Clark | Kentucky | 21049 | 2119 | 16 |
970141 | 970141 | 2021-01-27 | Clark | Kentucky | 21049 | 2121 | 16 |
966897 | 966897 | 2021-01-26 | Clark | Kentucky | 21049 | 2098 | 16 |
963652 | 963652 | 2021-01-25 | Clark | Kentucky | 21049 | 2093 | 16 |
960407 | 960407 | 2021-01-24 | Clark | Kentucky | 21049 | 2086 | 16 |
957161 | 957161 | 2021-01-23 | Clark | Kentucky | 21049 | 2076 | 16 |
953916 | 953916 | 2021-01-22 | Clark | Kentucky | 21049 | 2041 | 16 |
950671 | 950671 | 2021-01-21 | Clark | Kentucky | 21049 | 1996 | 16 |
947425 | 947425 | 2021-01-20 | Clark | Kentucky | 21049 | 1979 | 16 |
944178 | 944178 | 2021-01-19 | Clark | Kentucky | 21049 | 1944 | 16 |
940933 | 940933 | 2021-01-18 | Clark | Kentucky | 21049 | 1937 | 16 |
937688 | 937688 | 2021-01-17 | Clark | Kentucky | 21049 | 1931 | 16 |
934443 | 934443 | 2021-01-16 | Clark | Kentucky | 21049 | 1923 | 16 |
931198 | 931198 | 2021-01-15 | Clark | Kentucky | 21049 | 1878 | 16 |
927953 | 927953 | 2021-01-14 | Clark | Kentucky | 21049 | 1834 | 16 |
924707 | 924707 | 2021-01-13 | Clark | Kentucky | 21049 | 1785 | 16 |
921462 | 921462 | 2021-01-12 | Clark | Kentucky | 21049 | 1723 | 16 |
918217 | 918217 | 2021-01-11 | Clark | Kentucky | 21049 | 1701 | 16 |
914972 | 914972 | 2021-01-10 | Clark | Kentucky | 21049 | 1693 | 15 |
911727 | 911727 | 2021-01-09 | Clark | Kentucky | 21049 | 1682 | 15 |
908482 | 908482 | 2021-01-08 | Clark | Kentucky | 21049 | 1632 | 15 |
905236 | 905236 | 2021-01-07 | Clark | Kentucky | 21049 | 1607 | 15 |
901991 | 901991 | 2021-01-06 | Clark | Kentucky | 21049 | 1562 | 15 |
898746 | 898746 | 2021-01-05 | Clark | Kentucky | 21049 | 1505 | 15 |
895501 | 895501 | 2021-01-04 | Clark | Kentucky | 21049 | 1497 | 15 |
892254 | 892254 | 2021-01-03 | Clark | Kentucky | 21049 | 1487 | 15 |
889008 | 889008 | 2021-01-02 | Clark | Kentucky | 21049 | 1469 | 15 |
885762 | 885762 | 2021-01-01 | Clark | Kentucky | 21049 | 1452 | 15 |
882517 | 882517 | 2020-12-31 | Clark | Kentucky | 21049 | 1452 | 15 |
879272 | 879272 | 2020-12-30 | Clark | Kentucky | 21049 | 1452 | 15 |
876027 | 876027 | 2020-12-29 | Clark | Kentucky | 21049 | 1427 | 15 |
872782 | 872782 | 2020-12-28 | Clark | Kentucky | 21049 | 1425 | 15 |
869537 | 869537 | 2020-12-27 | Clark | Kentucky | 21049 | 1413 | 15 |
866292 | 866292 | 2020-12-26 | Clark | Kentucky | 21049 | 1403 | 15 |
863047 | 863047 | 2020-12-25 | Clark | Kentucky | 21049 | 1379 | 15 |
859802 | 859802 | 2020-12-24 | Clark | Kentucky | 21049 | 1379 | 15 |
856557 | 856557 | 2020-12-23 | Clark | Kentucky | 21049 | 1379 | 15 |
853312 | 853312 | 2020-12-22 | Clark | Kentucky | 21049 | 1359 | 15 |
850067 | 850067 | 2020-12-21 | Clark | Kentucky | 21049 | 1334 | 15 |
846822 | 846822 | 2020-12-20 | Clark | Kentucky | 21049 | 1328 | 14 |
843576 | 843576 | 2020-12-19 | Clark | Kentucky | 21049 | 1326 | 14 |
840331 | 840331 | 2020-12-18 | Clark | Kentucky | 21049 | 1296 | 14 |
837086 | 837086 | 2020-12-17 | Clark | Kentucky | 21049 | 1266 | 13 |
833840 | 833840 | 2020-12-16 | Clark | Kentucky | 21049 | 1252 | 13 |
830593 | 830593 | 2020-12-15 | Clark | Kentucky | 21049 | 1232 | 13 |
827347 | 827347 | 2020-12-14 | Clark | Kentucky | 21049 | 1214 | 13 |
824100 | 824100 | 2020-12-13 | Clark | Kentucky | 21049 | 1205 | 13 |
820854 | 820854 | 2020-12-12 | Clark | Kentucky | 21049 | 1203 | 13 |
817608 | 817608 | 2020-12-11 | Clark | Kentucky | 21049 | 1191 | 13 |
814362 | 814362 | 2020-12-10 | Clark | Kentucky | 21049 | 1161 | 13 |
811117 | 811117 | 2020-12-09 | Clark | Kentucky | 21049 | 1144 | 13 |
807872 | 807872 | 2020-12-08 | Clark | Kentucky | 21049 | 1125 | 12 |
804627 | 804627 | 2020-12-07 | Clark | Kentucky | 21049 | 1088 | 12 |
801382 | 801382 | 2020-12-06 | Clark | Kentucky | 21049 | 1079 | 12 |
798137 | 798137 | 2020-12-05 | Clark | Kentucky | 21049 | 1071 | 12 |
794892 | 794892 | 2020-12-04 | Clark | Kentucky | 21049 | 1049 | 12 |
791647 | 791647 | 2020-12-03 | Clark | Kentucky | 21049 | 1012 | 12 |
788402 | 788402 | 2020-12-02 | Clark | Kentucky | 21049 | 973 | 12 |
785158 | 785158 | 2020-12-01 | Clark | Kentucky | 21049 | 949 | 12 |
781913 | 781913 | 2020-11-30 | Clark | Kentucky | 21049 | 922 | 12 |
778667 | 778667 | 2020-11-29 | Clark | Kentucky | 21049 | 914 | 12 |
775422 | 775422 | 2020-11-28 | Clark | Kentucky | 21049 | 905 | 12 |
772177 | 772177 | 2020-11-27 | Clark | Kentucky | 21049 | 901 | 12 |
768932 | 768932 | 2020-11-26 | Clark | Kentucky | 21049 | 866 | 12 |
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);