ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 21141 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- 2020-04-19 1
- 2020-04-20 1
- 2020-04-21 1
- …
state 1
- Kentucky · 388 ✖
fips 1
- 21141 · 388 ✖
county 1
- Logan 388
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1220165 | 1220165 | 2021-04-14 | Logan | Kentucky | 21141 | 2742 | 64 |
1216917 | 1216917 | 2021-04-13 | Logan | Kentucky | 21141 | 2732 | 64 |
1213670 | 1213670 | 2021-04-12 | Logan | Kentucky | 21141 | 2724 | 64 |
1210422 | 1210422 | 2021-04-11 | Logan | Kentucky | 21141 | 2720 | 64 |
1207173 | 1207173 | 2021-04-10 | Logan | Kentucky | 21141 | 2716 | 64 |
1203925 | 1203925 | 2021-04-09 | Logan | Kentucky | 21141 | 2712 | 64 |
1200677 | 1200677 | 2021-04-08 | Logan | Kentucky | 21141 | 2703 | 64 |
1197428 | 1197428 | 2021-04-07 | Logan | Kentucky | 21141 | 2692 | 64 |
1194180 | 1194180 | 2021-04-06 | Logan | Kentucky | 21141 | 2676 | 64 |
1190930 | 1190930 | 2021-04-05 | Logan | Kentucky | 21141 | 2675 | 64 |
1187683 | 1187683 | 2021-04-04 | Logan | Kentucky | 21141 | 2669 | 63 |
1184436 | 1184436 | 2021-04-03 | Logan | Kentucky | 21141 | 2669 | 63 |
1181189 | 1181189 | 2021-04-02 | Logan | Kentucky | 21141 | 2661 | 62 |
1177942 | 1177942 | 2021-04-01 | Logan | Kentucky | 21141 | 2658 | 61 |
1174695 | 1174695 | 2021-03-31 | Logan | Kentucky | 21141 | 2644 | 61 |
1171448 | 1171448 | 2021-03-30 | Logan | Kentucky | 21141 | 2644 | 60 |
1168200 | 1168200 | 2021-03-29 | Logan | Kentucky | 21141 | 2643 | 60 |
1164952 | 1164952 | 2021-03-28 | Logan | Kentucky | 21141 | 2643 | 60 |
1161704 | 1161704 | 2021-03-27 | Logan | Kentucky | 21141 | 2636 | 59 |
1158456 | 1158456 | 2021-03-26 | Logan | Kentucky | 21141 | 2632 | 59 |
1155209 | 1155209 | 2021-03-25 | Logan | Kentucky | 21141 | 2627 | 59 |
1151962 | 1151962 | 2021-03-24 | Logan | Kentucky | 21141 | 2623 | 57 |
1148715 | 1148715 | 2021-03-23 | Logan | Kentucky | 21141 | 2613 | 57 |
1145468 | 1145468 | 2021-03-22 | Logan | Kentucky | 21141 | 2604 | 57 |
1142221 | 1142221 | 2021-03-21 | Logan | Kentucky | 21141 | 2604 | 57 |
1138975 | 1138975 | 2021-03-20 | Logan | Kentucky | 21141 | 2603 | 57 |
1135729 | 1135729 | 2021-03-19 | Logan | Kentucky | 21141 | 2599 | 57 |
1132482 | 1132482 | 2021-03-18 | Logan | Kentucky | 21141 | 2595 | 56 |
1129234 | 1129234 | 2021-03-17 | Logan | Kentucky | 21141 | 2590 | 55 |
1125988 | 1125988 | 2021-03-16 | Logan | Kentucky | 21141 | 2570 | 55 |
1122742 | 1122742 | 2021-03-15 | Logan | Kentucky | 21141 | 2566 | 55 |
1119495 | 1119495 | 2021-03-14 | Logan | Kentucky | 21141 | 2565 | 53 |
1116248 | 1116248 | 2021-03-13 | Logan | Kentucky | 21141 | 2561 | 53 |
1113002 | 1113002 | 2021-03-12 | Logan | Kentucky | 21141 | 2556 | 53 |
1109756 | 1109756 | 2021-03-11 | Logan | Kentucky | 21141 | 2553 | 53 |
1106510 | 1106510 | 2021-03-10 | Logan | Kentucky | 21141 | 2553 | 53 |
1103264 | 1103264 | 2021-03-09 | Logan | Kentucky | 21141 | 2546 | 53 |
1100018 | 1100018 | 2021-03-08 | Logan | Kentucky | 21141 | 2542 | 53 |
1096770 | 1096770 | 2021-03-07 | Logan | Kentucky | 21141 | 2541 | 52 |
1093524 | 1093524 | 2021-03-06 | Logan | Kentucky | 21141 | 2535 | 52 |
1090278 | 1090278 | 2021-03-05 | Logan | Kentucky | 21141 | 2523 | 52 |
1087033 | 1087033 | 2021-03-04 | Logan | Kentucky | 21141 | 2516 | 51 |
1083787 | 1083787 | 2021-03-03 | Logan | Kentucky | 21141 | 2509 | 51 |
1080541 | 1080541 | 2021-03-02 | Logan | Kentucky | 21141 | 2498 | 51 |
1077296 | 1077296 | 2021-03-01 | Logan | Kentucky | 21141 | 2491 | 51 |
1074050 | 1074050 | 2021-02-28 | Logan | Kentucky | 21141 | 2486 | 51 |
1070804 | 1070804 | 2021-02-27 | Logan | Kentucky | 21141 | 2483 | 51 |
1067559 | 1067559 | 2021-02-26 | Logan | Kentucky | 21141 | 2476 | 51 |
1064314 | 1064314 | 2021-02-25 | Logan | Kentucky | 21141 | 2466 | 51 |
1061069 | 1061069 | 2021-02-24 | Logan | Kentucky | 21141 | 2463 | 51 |
1057823 | 1057823 | 2021-02-23 | Logan | Kentucky | 21141 | 2455 | 51 |
1054577 | 1054577 | 2021-02-22 | Logan | Kentucky | 21141 | 2442 | 51 |
1051330 | 1051330 | 2021-02-21 | Logan | Kentucky | 21141 | 2437 | 51 |
1048083 | 1048083 | 2021-02-20 | Logan | Kentucky | 21141 | 2430 | 51 |
1044838 | 1044838 | 2021-02-19 | Logan | Kentucky | 21141 | 2418 | 51 |
1041593 | 1041593 | 2021-02-18 | Logan | Kentucky | 21141 | 2413 | 51 |
1038348 | 1038348 | 2021-02-17 | Logan | Kentucky | 21141 | 2404 | 50 |
1035103 | 1035103 | 2021-02-16 | Logan | Kentucky | 21141 | 2402 | 50 |
1031857 | 1031857 | 2021-02-15 | Logan | Kentucky | 21141 | 2388 | 50 |
1028610 | 1028610 | 2021-02-14 | Logan | Kentucky | 21141 | 2380 | 50 |
1025365 | 1025365 | 2021-02-13 | Logan | Kentucky | 21141 | 2373 | 50 |
1022120 | 1022120 | 2021-02-12 | Logan | Kentucky | 21141 | 2372 | 50 |
1018875 | 1018875 | 2021-02-11 | Logan | Kentucky | 21141 | 2362 | 49 |
1015630 | 1015630 | 2021-02-10 | Logan | Kentucky | 21141 | 2346 | 49 |
1012385 | 1012385 | 2021-02-09 | Logan | Kentucky | 21141 | 2336 | 49 |
1009139 | 1009139 | 2021-02-08 | Logan | Kentucky | 21141 | 2327 | 49 |
1005893 | 1005893 | 2021-02-07 | Logan | Kentucky | 21141 | 2318 | 48 |
1002647 | 1002647 | 2021-02-06 | Logan | Kentucky | 21141 | 2298 | 46 |
999401 | 999401 | 2021-02-05 | Logan | Kentucky | 21141 | 2293 | 46 |
996155 | 996155 | 2021-02-04 | Logan | Kentucky | 21141 | 2273 | 46 |
992909 | 992909 | 2021-02-03 | Logan | Kentucky | 21141 | 2257 | 46 |
989663 | 989663 | 2021-02-02 | Logan | Kentucky | 21141 | 2230 | 46 |
986416 | 986416 | 2021-02-01 | Logan | Kentucky | 21141 | 2213 | 46 |
983169 | 983169 | 2021-01-31 | Logan | Kentucky | 21141 | 2207 | 46 |
979923 | 979923 | 2021-01-30 | Logan | Kentucky | 21141 | 2198 | 46 |
976677 | 976677 | 2021-01-29 | Logan | Kentucky | 21141 | 2180 | 46 |
973432 | 973432 | 2021-01-28 | Logan | Kentucky | 21141 | 2166 | 45 |
970187 | 970187 | 2021-01-27 | Logan | Kentucky | 21141 | 2149 | 45 |
966943 | 966943 | 2021-01-26 | Logan | Kentucky | 21141 | 2139 | 45 |
963698 | 963698 | 2021-01-25 | Logan | Kentucky | 21141 | 2120 | 45 |
960453 | 960453 | 2021-01-24 | Logan | Kentucky | 21141 | 2110 | 45 |
957207 | 957207 | 2021-01-23 | Logan | Kentucky | 21141 | 2096 | 45 |
953962 | 953962 | 2021-01-22 | Logan | Kentucky | 21141 | 2077 | 44 |
950717 | 950717 | 2021-01-21 | Logan | Kentucky | 21141 | 2057 | 44 |
947471 | 947471 | 2021-01-20 | Logan | Kentucky | 21141 | 2033 | 43 |
944224 | 944224 | 2021-01-19 | Logan | Kentucky | 21141 | 2013 | 43 |
940979 | 940979 | 2021-01-18 | Logan | Kentucky | 21141 | 2005 | 43 |
937734 | 937734 | 2021-01-17 | Logan | Kentucky | 21141 | 1997 | 43 |
934489 | 934489 | 2021-01-16 | Logan | Kentucky | 21141 | 1979 | 43 |
931244 | 931244 | 2021-01-15 | Logan | Kentucky | 21141 | 1962 | 42 |
927999 | 927999 | 2021-01-14 | Logan | Kentucky | 21141 | 1948 | 42 |
924753 | 924753 | 2021-01-13 | Logan | Kentucky | 21141 | 1933 | 40 |
921508 | 921508 | 2021-01-12 | Logan | Kentucky | 21141 | 1917 | 40 |
918263 | 918263 | 2021-01-11 | Logan | Kentucky | 21141 | 1902 | 40 |
915018 | 915018 | 2021-01-10 | Logan | Kentucky | 21141 | 1892 | 40 |
911773 | 911773 | 2021-01-09 | Logan | Kentucky | 21141 | 1886 | 40 |
908528 | 908528 | 2021-01-08 | Logan | Kentucky | 21141 | 1868 | 40 |
905282 | 905282 | 2021-01-07 | Logan | Kentucky | 21141 | 1838 | 40 |
902037 | 902037 | 2021-01-06 | Logan | Kentucky | 21141 | 1815 | 40 |
898792 | 898792 | 2021-01-05 | Logan | Kentucky | 21141 | 1810 | 40 |
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);