ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 21117 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1090266 | 1090266 | 2021-03-05 | Kenton | Kentucky | 21117 | 15594 | 133 |
1087021 | 1087021 | 2021-03-04 | Kenton | Kentucky | 21117 | 15555 | 133 |
1083775 | 1083775 | 2021-03-03 | Kenton | Kentucky | 21117 | 15523 | 130 |
1080529 | 1080529 | 2021-03-02 | Kenton | Kentucky | 21117 | 15470 | 130 |
1077284 | 1077284 | 2021-03-01 | Kenton | Kentucky | 21117 | 15447 | 130 |
1074038 | 1074038 | 2021-02-28 | Kenton | Kentucky | 21117 | 15437 | 130 |
1070792 | 1070792 | 2021-02-27 | Kenton | Kentucky | 21117 | 15409 | 130 |
1067547 | 1067547 | 2021-02-26 | Kenton | Kentucky | 21117 | 15353 | 128 |
1064302 | 1064302 | 2021-02-25 | Kenton | Kentucky | 21117 | 15293 | 128 |
1061057 | 1061057 | 2021-02-24 | Kenton | Kentucky | 21117 | 15259 | 126 |
1057811 | 1057811 | 2021-02-23 | Kenton | Kentucky | 21117 | 15201 | 126 |
1054565 | 1054565 | 2021-02-22 | Kenton | Kentucky | 21117 | 15174 | 125 |
1051318 | 1051318 | 2021-02-21 | Kenton | Kentucky | 21117 | 15158 | 125 |
1048071 | 1048071 | 2021-02-20 | Kenton | Kentucky | 21117 | 15106 | 125 |
1044826 | 1044826 | 2021-02-19 | Kenton | Kentucky | 21117 | 15006 | 123 |
1041581 | 1041581 | 2021-02-18 | Kenton | Kentucky | 21117 | 14929 | 122 |
1038336 | 1038336 | 2021-02-17 | Kenton | Kentucky | 21117 | 14885 | 122 |
1035091 | 1035091 | 2021-02-16 | Kenton | Kentucky | 21117 | 14840 | 121 |
1031845 | 1031845 | 2021-02-15 | Kenton | Kentucky | 21117 | 14783 | 118 |
1028598 | 1028598 | 2021-02-14 | Kenton | Kentucky | 21117 | 14757 | 118 |
1025353 | 1025353 | 2021-02-13 | Kenton | Kentucky | 21117 | 14673 | 118 |
1022108 | 1022108 | 2021-02-12 | Kenton | Kentucky | 21117 | 14598 | 118 |
1018863 | 1018863 | 2021-02-11 | Kenton | Kentucky | 21117 | 14456 | 118 |
1015618 | 1015618 | 2021-02-10 | Kenton | Kentucky | 21117 | 14354 | 119 |
1012373 | 1012373 | 2021-02-09 | Kenton | Kentucky | 21117 | 14236 | 118 |
1009127 | 1009127 | 2021-02-08 | Kenton | Kentucky | 21117 | 14169 | 115 |
1005881 | 1005881 | 2021-02-07 | Kenton | Kentucky | 21117 | 14075 | 114 |
1002635 | 1002635 | 2021-02-06 | Kenton | Kentucky | 21117 | 14058 | 114 |
999389 | 999389 | 2021-02-05 | Kenton | Kentucky | 21117 | 13950 | 113 |
996143 | 996143 | 2021-02-04 | Kenton | Kentucky | 21117 | 13837 | 113 |
992897 | 992897 | 2021-02-03 | Kenton | Kentucky | 21117 | 13592 | 112 |
989651 | 989651 | 2021-02-02 | Kenton | Kentucky | 21117 | 13592 | 112 |
986404 | 986404 | 2021-02-01 | Kenton | Kentucky | 21117 | 13526 | 107 |
983157 | 983157 | 2021-01-31 | Kenton | Kentucky | 21117 | 13454 | 107 |
979911 | 979911 | 2021-01-30 | Kenton | Kentucky | 21117 | 13348 | 107 |
976665 | 976665 | 2021-01-29 | Kenton | Kentucky | 21117 | 13164 | 101 |
973420 | 973420 | 2021-01-28 | Kenton | Kentucky | 21117 | 13107 | 99 |
970175 | 970175 | 2021-01-27 | Kenton | Kentucky | 21117 | 12882 | 99 |
966931 | 966931 | 2021-01-26 | Kenton | Kentucky | 21117 | 12764 | 99 |
963686 | 963686 | 2021-01-25 | Kenton | Kentucky | 21117 | 12680 | 99 |
960441 | 960441 | 2021-01-24 | Kenton | Kentucky | 21117 | 12580 | 97 |
957195 | 957195 | 2021-01-23 | Kenton | Kentucky | 21117 | 12517 | 93 |
953950 | 953950 | 2021-01-22 | Kenton | Kentucky | 21117 | 12412 | 91 |
950705 | 950705 | 2021-01-21 | Kenton | Kentucky | 21117 | 12256 | 91 |
947459 | 947459 | 2021-01-20 | Kenton | Kentucky | 21117 | 12093 | 91 |
944212 | 944212 | 2021-01-19 | Kenton | Kentucky | 21117 | 11902 | 91 |
940967 | 940967 | 2021-01-18 | Kenton | Kentucky | 21117 | 11838 | 91 |
937722 | 937722 | 2021-01-17 | Kenton | Kentucky | 21117 | 11767 | 91 |
934477 | 934477 | 2021-01-16 | Kenton | Kentucky | 21117 | 11654 | 91 |
931232 | 931232 | 2021-01-15 | Kenton | Kentucky | 21117 | 11471 | 90 |
927987 | 927987 | 2021-01-14 | Kenton | Kentucky | 21117 | 11232 | 90 |
924741 | 924741 | 2021-01-13 | Kenton | Kentucky | 21117 | 11047 | 90 |
921496 | 921496 | 2021-01-12 | Kenton | Kentucky | 21117 | 10811 | 90 |
918251 | 918251 | 2021-01-11 | Kenton | Kentucky | 21117 | 10663 | 84 |
915006 | 915006 | 2021-01-10 | Kenton | Kentucky | 21117 | 10553 | 84 |
911761 | 911761 | 2021-01-09 | Kenton | Kentucky | 21117 | 10433 | 84 |
908516 | 908516 | 2021-01-08 | Kenton | Kentucky | 21117 | 10227 | 84 |
905270 | 905270 | 2021-01-07 | Kenton | Kentucky | 21117 | 10086 | 81 |
902025 | 902025 | 2021-01-06 | Kenton | Kentucky | 21117 | 9900 | 81 |
898780 | 898780 | 2021-01-05 | Kenton | Kentucky | 21117 | 9697 | 81 |
895535 | 895535 | 2021-01-04 | Kenton | Kentucky | 21117 | 9602 | 81 |
892288 | 892288 | 2021-01-03 | Kenton | Kentucky | 21117 | 9185 | 79 |
889042 | 889042 | 2021-01-02 | Kenton | Kentucky | 21117 | 9053 | 79 |
885796 | 885796 | 2021-01-01 | Kenton | Kentucky | 21117 | 8997 | 79 |
882551 | 882551 | 2020-12-31 | Kenton | Kentucky | 21117 | 8997 | 79 |
879306 | 879306 | 2020-12-30 | Kenton | Kentucky | 21117 | 8997 | 79 |
876061 | 876061 | 2020-12-29 | Kenton | Kentucky | 21117 | 8843 | 79 |
872816 | 872816 | 2020-12-28 | Kenton | Kentucky | 21117 | 8748 | 79 |
869571 | 869571 | 2020-12-27 | Kenton | Kentucky | 21117 | 8406 | 79 |
866326 | 866326 | 2020-12-26 | Kenton | Kentucky | 21117 | 8406 | 79 |
863081 | 863081 | 2020-12-25 | Kenton | Kentucky | 21117 | 8406 | 79 |
859836 | 859836 | 2020-12-24 | Kenton | Kentucky | 21117 | 8406 | 79 |
856591 | 856591 | 2020-12-23 | Kenton | Kentucky | 21117 | 8406 | 79 |
853346 | 853346 | 2020-12-22 | Kenton | Kentucky | 21117 | 8308 | 77 |
850101 | 850101 | 2020-12-21 | Kenton | Kentucky | 21117 | 8230 | 77 |
846856 | 846856 | 2020-12-20 | Kenton | Kentucky | 21117 | 8093 | 71 |
843610 | 843610 | 2020-12-19 | Kenton | Kentucky | 21117 | 7986 | 67 |
840365 | 840365 | 2020-12-18 | Kenton | Kentucky | 21117 | 7847 | 67 |
837120 | 837120 | 2020-12-17 | Kenton | Kentucky | 21117 | 7604 | 67 |
833874 | 833874 | 2020-12-16 | Kenton | Kentucky | 21117 | 7493 | 65 |
830627 | 830627 | 2020-12-15 | Kenton | Kentucky | 21117 | 7405 | 65 |
827381 | 827381 | 2020-12-14 | Kenton | Kentucky | 21117 | 7342 | 65 |
824134 | 824134 | 2020-12-13 | Kenton | Kentucky | 21117 | 7277 | 65 |
820888 | 820888 | 2020-12-12 | Kenton | Kentucky | 21117 | 7135 | 65 |
817642 | 817642 | 2020-12-11 | Kenton | Kentucky | 21117 | 7023 | 65 |
814396 | 814396 | 2020-12-10 | Kenton | Kentucky | 21117 | 6809 | 65 |
811151 | 811151 | 2020-12-09 | Kenton | Kentucky | 21117 | 6708 | 65 |
807906 | 807906 | 2020-12-08 | Kenton | Kentucky | 21117 | 6595 | 65 |
804661 | 804661 | 2020-12-07 | Kenton | Kentucky | 21117 | 6511 | 64 |
801416 | 801416 | 2020-12-06 | Kenton | Kentucky | 21117 | 6461 | 64 |
798171 | 798171 | 2020-12-05 | Kenton | Kentucky | 21117 | 6298 | 64 |
794926 | 794926 | 2020-12-04 | Kenton | Kentucky | 21117 | 6165 | 64 |
791681 | 791681 | 2020-12-03 | Kenton | Kentucky | 21117 | 6024 | 64 |
788436 | 788436 | 2020-12-02 | Kenton | Kentucky | 21117 | 5918 | 64 |
785192 | 785192 | 2020-12-01 | Kenton | Kentucky | 21117 | 5798 | 63 |
781947 | 781947 | 2020-11-30 | Kenton | Kentucky | 21117 | 5673 | 64 |
778701 | 778701 | 2020-11-29 | Kenton | Kentucky | 21117 | 5364 | 63 |
775456 | 775456 | 2020-11-28 | Kenton | Kentucky | 21117 | 5294 | 63 |
772211 | 772211 | 2020-11-27 | Kenton | Kentucky | 21117 | 5213 | 63 |
768966 | 768966 | 2020-11-26 | Kenton | Kentucky | 21117 | 5017 | 63 |
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);