ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Franklin" and fips = 21073 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194146 | 1194146 | 2021-04-06 | Franklin | Kentucky | 21073 | 3877 | 46 |
1190896 | 1190896 | 2021-04-05 | Franklin | Kentucky | 21073 | 3875 | 46 |
1187649 | 1187649 | 2021-04-04 | Franklin | Kentucky | 21073 | 3883 | 46 |
1184402 | 1184402 | 2021-04-03 | Franklin | Kentucky | 21073 | 3883 | 46 |
1181155 | 1181155 | 2021-04-02 | Franklin | Kentucky | 21073 | 3872 | 45 |
1177908 | 1177908 | 2021-04-01 | Franklin | Kentucky | 21073 | 3868 | 44 |
1174661 | 1174661 | 2021-03-31 | Franklin | Kentucky | 21073 | 3868 | 44 |
1171414 | 1171414 | 2021-03-30 | Franklin | Kentucky | 21073 | 3862 | 44 |
1168166 | 1168166 | 2021-03-29 | Franklin | Kentucky | 21073 | 3857 | 44 |
1164918 | 1164918 | 2021-03-28 | Franklin | Kentucky | 21073 | 3854 | 44 |
1161670 | 1161670 | 2021-03-27 | Franklin | Kentucky | 21073 | 3852 | 44 |
1158422 | 1158422 | 2021-03-26 | Franklin | Kentucky | 21073 | 3852 | 43 |
1155175 | 1155175 | 2021-03-25 | Franklin | Kentucky | 21073 | 3846 | 43 |
1151928 | 1151928 | 2021-03-24 | Franklin | Kentucky | 21073 | 3842 | 43 |
1148681 | 1148681 | 2021-03-23 | Franklin | Kentucky | 21073 | 3836 | 42 |
1145434 | 1145434 | 2021-03-22 | Franklin | Kentucky | 21073 | 3831 | 42 |
1142187 | 1142187 | 2021-03-21 | Franklin | Kentucky | 21073 | 3827 | 40 |
1138941 | 1138941 | 2021-03-20 | Franklin | Kentucky | 21073 | 3826 | 40 |
1135695 | 1135695 | 2021-03-19 | Franklin | Kentucky | 21073 | 3823 | 40 |
1132448 | 1132448 | 2021-03-18 | Franklin | Kentucky | 21073 | 3822 | 38 |
1129200 | 1129200 | 2021-03-17 | Franklin | Kentucky | 21073 | 3818 | 34 |
1125954 | 1125954 | 2021-03-16 | Franklin | Kentucky | 21073 | 3808 | 33 |
1122708 | 1122708 | 2021-03-15 | Franklin | Kentucky | 21073 | 3804 | 33 |
1119461 | 1119461 | 2021-03-14 | Franklin | Kentucky | 21073 | 3798 | 33 |
1116214 | 1116214 | 2021-03-13 | Franklin | Kentucky | 21073 | 3795 | 33 |
1112968 | 1112968 | 2021-03-12 | Franklin | Kentucky | 21073 | 3795 | 33 |
1109722 | 1109722 | 2021-03-11 | Franklin | Kentucky | 21073 | 3792 | 33 |
1106476 | 1106476 | 2021-03-10 | Franklin | Kentucky | 21073 | 3777 | 31 |
1103230 | 1103230 | 2021-03-09 | Franklin | Kentucky | 21073 | 3768 | 31 |
1099984 | 1099984 | 2021-03-08 | Franklin | Kentucky | 21073 | 3749 | 31 |
1096736 | 1096736 | 2021-03-07 | Franklin | Kentucky | 21073 | 3734 | 30 |
1093490 | 1093490 | 2021-03-06 | Franklin | Kentucky | 21073 | 3723 | 30 |
1090244 | 1090244 | 2021-03-05 | Franklin | Kentucky | 21073 | 3716 | 30 |
1086999 | 1086999 | 2021-03-04 | Franklin | Kentucky | 21073 | 3687 | 30 |
1083753 | 1083753 | 2021-03-03 | Franklin | Kentucky | 21073 | 3668 | 29 |
1080507 | 1080507 | 2021-03-02 | Franklin | Kentucky | 21073 | 3646 | 29 |
1077262 | 1077262 | 2021-03-01 | Franklin | Kentucky | 21073 | 3655 | 29 |
1074016 | 1074016 | 2021-02-28 | Franklin | Kentucky | 21073 | 3644 | 29 |
1070770 | 1070770 | 2021-02-27 | Franklin | Kentucky | 21073 | 3638 | 28 |
1067525 | 1067525 | 2021-02-26 | Franklin | Kentucky | 21073 | 3624 | 28 |
1064280 | 1064280 | 2021-02-25 | Franklin | Kentucky | 21073 | 3617 | 28 |
1061035 | 1061035 | 2021-02-24 | Franklin | Kentucky | 21073 | 3612 | 28 |
1057789 | 1057789 | 2021-02-23 | Franklin | Kentucky | 21073 | 3609 | 28 |
1054543 | 1054543 | 2021-02-22 | Franklin | Kentucky | 21073 | 3603 | 28 |
1051296 | 1051296 | 2021-02-21 | Franklin | Kentucky | 21073 | 3593 | 28 |
1048049 | 1048049 | 2021-02-20 | Franklin | Kentucky | 21073 | 3576 | 28 |
1044804 | 1044804 | 2021-02-19 | Franklin | Kentucky | 21073 | 3557 | 28 |
1041559 | 1041559 | 2021-02-18 | Franklin | Kentucky | 21073 | 3534 | 28 |
1038314 | 1038314 | 2021-02-17 | Franklin | Kentucky | 21073 | 3523 | 28 |
1035069 | 1035069 | 2021-02-16 | Franklin | Kentucky | 21073 | 3507 | 28 |
1031823 | 1031823 | 2021-02-15 | Franklin | Kentucky | 21073 | 3493 | 28 |
1028576 | 1028576 | 2021-02-14 | Franklin | Kentucky | 21073 | 3489 | 28 |
1025331 | 1025331 | 2021-02-13 | Franklin | Kentucky | 21073 | 3453 | 28 |
1022086 | 1022086 | 2021-02-12 | Franklin | Kentucky | 21073 | 3440 | 28 |
1018841 | 1018841 | 2021-02-11 | Franklin | Kentucky | 21073 | 3425 | 28 |
1015596 | 1015596 | 2021-02-10 | Franklin | Kentucky | 21073 | 3396 | 28 |
1012351 | 1012351 | 2021-02-09 | Franklin | Kentucky | 21073 | 3379 | 28 |
1009105 | 1009105 | 2021-02-08 | Franklin | Kentucky | 21073 | 3362 | 28 |
1005859 | 1005859 | 2021-02-07 | Franklin | Kentucky | 21073 | 3345 | 28 |
1002613 | 1002613 | 2021-02-06 | Franklin | Kentucky | 21073 | 3341 | 28 |
999367 | 999367 | 2021-02-05 | Franklin | Kentucky | 21073 | 3312 | 28 |
996121 | 996121 | 2021-02-04 | Franklin | Kentucky | 21073 | 3287 | 28 |
992875 | 992875 | 2021-02-03 | Franklin | Kentucky | 21073 | 3269 | 26 |
989629 | 989629 | 2021-02-02 | Franklin | Kentucky | 21073 | 3257 | 24 |
986382 | 986382 | 2021-02-01 | Franklin | Kentucky | 21073 | 3228 | 24 |
983135 | 983135 | 2021-01-31 | Franklin | Kentucky | 21073 | 3191 | 24 |
979889 | 979889 | 2021-01-30 | Franklin | Kentucky | 21073 | 3146 | 24 |
976643 | 976643 | 2021-01-29 | Franklin | Kentucky | 21073 | 3002 | 24 |
973398 | 973398 | 2021-01-28 | Franklin | Kentucky | 21073 | 2927 | 24 |
970153 | 970153 | 2021-01-27 | Franklin | Kentucky | 21073 | 2914 | 24 |
966909 | 966909 | 2021-01-26 | Franklin | Kentucky | 21073 | 2903 | 24 |
963664 | 963664 | 2021-01-25 | Franklin | Kentucky | 21073 | 2882 | 24 |
960419 | 960419 | 2021-01-24 | Franklin | Kentucky | 21073 | 2843 | 24 |
957173 | 957173 | 2021-01-23 | Franklin | Kentucky | 21073 | 2804 | 24 |
953928 | 953928 | 2021-01-22 | Franklin | Kentucky | 21073 | 2745 | 24 |
950683 | 950683 | 2021-01-21 | Franklin | Kentucky | 21073 | 2732 | 24 |
947437 | 947437 | 2021-01-20 | Franklin | Kentucky | 21073 | 2673 | 23 |
944190 | 944190 | 2021-01-19 | Franklin | Kentucky | 21073 | 2643 | 23 |
940945 | 940945 | 2021-01-18 | Franklin | Kentucky | 21073 | 2638 | 23 |
937700 | 937700 | 2021-01-17 | Franklin | Kentucky | 21073 | 2597 | 23 |
934455 | 934455 | 2021-01-16 | Franklin | Kentucky | 21073 | 2575 | 23 |
931210 | 931210 | 2021-01-15 | Franklin | Kentucky | 21073 | 2552 | 22 |
927965 | 927965 | 2021-01-14 | Franklin | Kentucky | 21073 | 2503 | 22 |
924719 | 924719 | 2021-01-13 | Franklin | Kentucky | 21073 | 2471 | 22 |
921474 | 921474 | 2021-01-12 | Franklin | Kentucky | 21073 | 2435 | 22 |
918229 | 918229 | 2021-01-11 | Franklin | Kentucky | 21073 | 2426 | 22 |
914984 | 914984 | 2021-01-10 | Franklin | Kentucky | 21073 | 2413 | 22 |
911739 | 911739 | 2021-01-09 | Franklin | Kentucky | 21073 | 2377 | 21 |
908494 | 908494 | 2021-01-08 | Franklin | Kentucky | 21073 | 2334 | 21 |
905248 | 905248 | 2021-01-07 | Franklin | Kentucky | 21073 | 2292 | 21 |
902003 | 902003 | 2021-01-06 | Franklin | Kentucky | 21073 | 2248 | 21 |
898758 | 898758 | 2021-01-05 | Franklin | Kentucky | 21073 | 2226 | 21 |
895513 | 895513 | 2021-01-04 | Franklin | Kentucky | 21073 | 2219 | 21 |
892266 | 892266 | 2021-01-03 | Franklin | Kentucky | 21073 | 2214 | 20 |
889020 | 889020 | 2021-01-02 | Franklin | Kentucky | 21073 | 2179 | 20 |
885774 | 885774 | 2021-01-01 | Franklin | Kentucky | 21073 | 2132 | 19 |
882529 | 882529 | 2020-12-31 | Franklin | Kentucky | 21073 | 2132 | 19 |
879284 | 879284 | 2020-12-30 | Franklin | Kentucky | 21073 | 2132 | 19 |
876039 | 876039 | 2020-12-29 | Franklin | Kentucky | 21073 | 2103 | 19 |
872794 | 872794 | 2020-12-28 | Franklin | Kentucky | 21073 | 2089 | 19 |
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);