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)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
895547 | 895547 | 2021-01-04 | Logan | Kentucky | 21141 | 1797 | 39 |
892300 | 892300 | 2021-01-03 | Logan | Kentucky | 21141 | 1745 | 39 |
889054 | 889054 | 2021-01-02 | Logan | Kentucky | 21141 | 1737 | 39 |
885808 | 885808 | 2021-01-01 | Logan | Kentucky | 21141 | 1697 | 39 |
882563 | 882563 | 2020-12-31 | Logan | Kentucky | 21141 | 1697 | 39 |
879318 | 879318 | 2020-12-30 | Logan | Kentucky | 21141 | 1697 | 39 |
876073 | 876073 | 2020-12-29 | Logan | Kentucky | 21141 | 1679 | 39 |
872828 | 872828 | 2020-12-28 | Logan | Kentucky | 21141 | 1653 | 39 |
869583 | 869583 | 2020-12-27 | Logan | Kentucky | 21141 | 1649 | 39 |
866338 | 866338 | 2020-12-26 | Logan | Kentucky | 21141 | 1646 | 39 |
863093 | 863093 | 2020-12-25 | Logan | Kentucky | 21141 | 1613 | 37 |
859848 | 859848 | 2020-12-24 | Logan | Kentucky | 21141 | 1613 | 37 |
856603 | 856603 | 2020-12-23 | Logan | Kentucky | 21141 | 1613 | 37 |
853358 | 853358 | 2020-12-22 | Logan | Kentucky | 21141 | 1602 | 37 |
850113 | 850113 | 2020-12-21 | Logan | Kentucky | 21141 | 1579 | 37 |
846868 | 846868 | 2020-12-20 | Logan | Kentucky | 21141 | 1556 | 37 |
843622 | 843622 | 2020-12-19 | Logan | Kentucky | 21141 | 1551 | 37 |
840377 | 840377 | 2020-12-18 | Logan | Kentucky | 21141 | 1536 | 37 |
837132 | 837132 | 2020-12-17 | Logan | Kentucky | 21141 | 1517 | 37 |
833886 | 833886 | 2020-12-16 | Logan | Kentucky | 21141 | 1505 | 37 |
830639 | 830639 | 2020-12-15 | Logan | Kentucky | 21141 | 1471 | 37 |
827393 | 827393 | 2020-12-14 | Logan | Kentucky | 21141 | 1452 | 37 |
824146 | 824146 | 2020-12-13 | Logan | Kentucky | 21141 | 1425 | 36 |
820900 | 820900 | 2020-12-12 | Logan | Kentucky | 21141 | 1416 | 36 |
817654 | 817654 | 2020-12-11 | Logan | Kentucky | 21141 | 1391 | 36 |
814408 | 814408 | 2020-12-10 | Logan | Kentucky | 21141 | 1377 | 36 |
811163 | 811163 | 2020-12-09 | Logan | Kentucky | 21141 | 1362 | 36 |
807918 | 807918 | 2020-12-08 | Logan | Kentucky | 21141 | 1346 | 36 |
804673 | 804673 | 2020-12-07 | Logan | Kentucky | 21141 | 1343 | 36 |
801428 | 801428 | 2020-12-06 | Logan | Kentucky | 21141 | 1314 | 36 |
798183 | 798183 | 2020-12-05 | Logan | Kentucky | 21141 | 1307 | 36 |
794938 | 794938 | 2020-12-04 | Logan | Kentucky | 21141 | 1302 | 35 |
791693 | 791693 | 2020-12-03 | Logan | Kentucky | 21141 | 1296 | 35 |
788448 | 788448 | 2020-12-02 | Logan | Kentucky | 21141 | 1278 | 35 |
785204 | 785204 | 2020-12-01 | Logan | Kentucky | 21141 | 1268 | 35 |
781959 | 781959 | 2020-11-30 | Logan | Kentucky | 21141 | 1242 | 35 |
778713 | 778713 | 2020-11-29 | Logan | Kentucky | 21141 | 1214 | 35 |
775468 | 775468 | 2020-11-28 | Logan | Kentucky | 21141 | 1208 | 35 |
772223 | 772223 | 2020-11-27 | Logan | Kentucky | 21141 | 1208 | 33 |
768978 | 768978 | 2020-11-26 | Logan | Kentucky | 21141 | 1200 | 33 |
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);