ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Franklin" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
869549 | 869549 | 2020-12-27 | Franklin | Kentucky | 21073 | 2077 | 19 |
866304 | 866304 | 2020-12-26 | Franklin | Kentucky | 21073 | 2059 | 19 |
863059 | 863059 | 2020-12-25 | Franklin | Kentucky | 21073 | 2018 | 17 |
859814 | 859814 | 2020-12-24 | Franklin | Kentucky | 21073 | 2018 | 17 |
856569 | 856569 | 2020-12-23 | Franklin | Kentucky | 21073 | 2018 | 17 |
853324 | 853324 | 2020-12-22 | Franklin | Kentucky | 21073 | 1997 | 17 |
850079 | 850079 | 2020-12-21 | Franklin | Kentucky | 21073 | 1982 | 17 |
846834 | 846834 | 2020-12-20 | Franklin | Kentucky | 21073 | 1957 | 17 |
843588 | 843588 | 2020-12-19 | Franklin | Kentucky | 21073 | 1939 | 17 |
840343 | 840343 | 2020-12-18 | Franklin | Kentucky | 21073 | 1921 | 17 |
837098 | 837098 | 2020-12-17 | Franklin | Kentucky | 21073 | 1887 | 17 |
833852 | 833852 | 2020-12-16 | Franklin | Kentucky | 21073 | 1872 | 17 |
830605 | 830605 | 2020-12-15 | Franklin | Kentucky | 21073 | 1849 | 17 |
827359 | 827359 | 2020-12-14 | Franklin | Kentucky | 21073 | 1831 | 17 |
824112 | 824112 | 2020-12-13 | Franklin | Kentucky | 21073 | 1809 | 17 |
820866 | 820866 | 2020-12-12 | Franklin | Kentucky | 21073 | 1785 | 17 |
817620 | 817620 | 2020-12-11 | Franklin | Kentucky | 21073 | 1753 | 17 |
814374 | 814374 | 2020-12-10 | Franklin | Kentucky | 21073 | 1737 | 17 |
811129 | 811129 | 2020-12-09 | Franklin | Kentucky | 21073 | 1691 | 17 |
807884 | 807884 | 2020-12-08 | Franklin | Kentucky | 21073 | 1666 | 17 |
804639 | 804639 | 2020-12-07 | Franklin | Kentucky | 21073 | 1648 | 17 |
801394 | 801394 | 2020-12-06 | Franklin | Kentucky | 21073 | 1632 | 17 |
798149 | 798149 | 2020-12-05 | Franklin | Kentucky | 21073 | 1593 | 17 |
794904 | 794904 | 2020-12-04 | Franklin | Kentucky | 21073 | 1554 | 17 |
791659 | 791659 | 2020-12-03 | Franklin | Kentucky | 21073 | 1512 | 16 |
788414 | 788414 | 2020-12-02 | Franklin | Kentucky | 21073 | 1479 | 14 |
785170 | 785170 | 2020-12-01 | Franklin | Kentucky | 21073 | 1442 | 14 |
781925 | 781925 | 2020-11-30 | Franklin | Kentucky | 21073 | 1419 | 14 |
778679 | 778679 | 2020-11-29 | Franklin | Kentucky | 21073 | 1407 | 14 |
775434 | 775434 | 2020-11-28 | Franklin | Kentucky | 21073 | 1394 | 14 |
772189 | 772189 | 2020-11-27 | Franklin | Kentucky | 21073 | 1375 | 14 |
768944 | 768944 | 2020-11-26 | Franklin | Kentucky | 21073 | 1334 | 14 |
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);