ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 21227 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1093567 | 1093567 | 2021-03-06 | Warren | Kentucky | 21227 | 14660 | 139 |
1090321 | 1090321 | 2021-03-05 | Warren | Kentucky | 21227 | 14651 | 139 |
1087076 | 1087076 | 2021-03-04 | Warren | Kentucky | 21227 | 14626 | 139 |
1083830 | 1083830 | 2021-03-03 | Warren | Kentucky | 21227 | 14606 | 138 |
1080584 | 1080584 | 2021-03-02 | Warren | Kentucky | 21227 | 14587 | 136 |
1077339 | 1077339 | 2021-03-01 | Warren | Kentucky | 21227 | 14561 | 136 |
1074093 | 1074093 | 2021-02-28 | Warren | Kentucky | 21227 | 14544 | 136 |
1070847 | 1070847 | 2021-02-27 | Warren | Kentucky | 21227 | 14536 | 136 |
1067602 | 1067602 | 2021-02-26 | Warren | Kentucky | 21227 | 14515 | 135 |
1064357 | 1064357 | 2021-02-25 | Warren | Kentucky | 21227 | 14476 | 134 |
1061112 | 1061112 | 2021-02-24 | Warren | Kentucky | 21227 | 14441 | 134 |
1057866 | 1057866 | 2021-02-23 | Warren | Kentucky | 21227 | 14402 | 130 |
1054620 | 1054620 | 2021-02-22 | Warren | Kentucky | 21227 | 14356 | 130 |
1051373 | 1051373 | 2021-02-21 | Warren | Kentucky | 21227 | 14339 | 130 |
1048126 | 1048126 | 2021-02-20 | Warren | Kentucky | 21227 | 14310 | 130 |
1044881 | 1044881 | 2021-02-19 | Warren | Kentucky | 21227 | 14269 | 130 |
1041636 | 1041636 | 2021-02-18 | Warren | Kentucky | 21227 | 14228 | 129 |
1038391 | 1038391 | 2021-02-17 | Warren | Kentucky | 21227 | 14202 | 128 |
1035146 | 1035146 | 2021-02-16 | Warren | Kentucky | 21227 | 14179 | 128 |
1031900 | 1031900 | 2021-02-15 | Warren | Kentucky | 21227 | 14137 | 127 |
1028653 | 1028653 | 2021-02-14 | Warren | Kentucky | 21227 | 14113 | 127 |
1025408 | 1025408 | 2021-02-13 | Warren | Kentucky | 21227 | 14063 | 127 |
1022163 | 1022163 | 2021-02-12 | Warren | Kentucky | 21227 | 14029 | 127 |
1018918 | 1018918 | 2021-02-11 | Warren | Kentucky | 21227 | 13962 | 123 |
1015673 | 1015673 | 2021-02-10 | Warren | Kentucky | 21227 | 13913 | 123 |
1012428 | 1012428 | 2021-02-09 | Warren | Kentucky | 21227 | 13860 | 118 |
1009182 | 1009182 | 2021-02-08 | Warren | Kentucky | 21227 | 13788 | 117 |
1005936 | 1005936 | 2021-02-07 | Warren | Kentucky | 21227 | 13751 | 114 |
1002690 | 1002690 | 2021-02-06 | Warren | Kentucky | 21227 | 13715 | 112 |
999444 | 999444 | 2021-02-05 | Warren | Kentucky | 21227 | 13657 | 107 |
996198 | 996198 | 2021-02-04 | Warren | Kentucky | 21227 | 13597 | 107 |
992952 | 992952 | 2021-02-03 | Warren | Kentucky | 21227 | 13519 | 107 |
989706 | 989706 | 2021-02-02 | Warren | Kentucky | 21227 | 13438 | 107 |
986459 | 986459 | 2021-02-01 | Warren | Kentucky | 21227 | 13367 | 107 |
983212 | 983212 | 2021-01-31 | Warren | Kentucky | 21227 | 13311 | 106 |
979966 | 979966 | 2021-01-30 | Warren | Kentucky | 21227 | 13238 | 106 |
976720 | 976720 | 2021-01-29 | Warren | Kentucky | 21227 | 13173 | 104 |
973475 | 973475 | 2021-01-28 | Warren | Kentucky | 21227 | 13119 | 101 |
970230 | 970230 | 2021-01-27 | Warren | Kentucky | 21227 | 13079 | 101 |
966986 | 966986 | 2021-01-26 | Warren | Kentucky | 21227 | 13041 | 97 |
963741 | 963741 | 2021-01-25 | Warren | Kentucky | 21227 | 12940 | 97 |
960496 | 960496 | 2021-01-24 | Warren | Kentucky | 21227 | 12852 | 95 |
957250 | 957250 | 2021-01-23 | Warren | Kentucky | 21227 | 12784 | 95 |
954005 | 954005 | 2021-01-22 | Warren | Kentucky | 21227 | 12750 | 95 |
950760 | 950760 | 2021-01-21 | Warren | Kentucky | 21227 | 12561 | 93 |
947514 | 947514 | 2021-01-20 | Warren | Kentucky | 21227 | 12515 | 93 |
944267 | 944267 | 2021-01-19 | Warren | Kentucky | 21227 | 12385 | 93 |
941022 | 941022 | 2021-01-18 | Warren | Kentucky | 21227 | 12255 | 91 |
937777 | 937777 | 2021-01-17 | Warren | Kentucky | 21227 | 12138 | 90 |
934532 | 934532 | 2021-01-16 | Warren | Kentucky | 21227 | 12114 | 90 |
931287 | 931287 | 2021-01-15 | Warren | Kentucky | 21227 | 12066 | 90 |
928042 | 928042 | 2021-01-14 | Warren | Kentucky | 21227 | 11929 | 88 |
924796 | 924796 | 2021-01-13 | Warren | Kentucky | 21227 | 11800 | 88 |
921551 | 921551 | 2021-01-12 | Warren | Kentucky | 21227 | 11665 | 88 |
918306 | 918306 | 2021-01-11 | Warren | Kentucky | 21227 | 11599 | 88 |
915061 | 915061 | 2021-01-10 | Warren | Kentucky | 21227 | 11473 | 88 |
911816 | 911816 | 2021-01-09 | Warren | Kentucky | 21227 | 11375 | 88 |
908571 | 908571 | 2021-01-08 | Warren | Kentucky | 21227 | 11283 | 88 |
905325 | 905325 | 2021-01-07 | Warren | Kentucky | 21227 | 11122 | 88 |
902080 | 902080 | 2021-01-06 | Warren | Kentucky | 21227 | 10949 | 88 |
898835 | 898835 | 2021-01-05 | Warren | Kentucky | 21227 | 10690 | 87 |
895590 | 895590 | 2021-01-04 | Warren | Kentucky | 21227 | 10530 | 87 |
892343 | 892343 | 2021-01-03 | Warren | Kentucky | 21227 | 10409 | 84 |
889097 | 889097 | 2021-01-02 | Warren | Kentucky | 21227 | 10294 | 84 |
885851 | 885851 | 2021-01-01 | Warren | Kentucky | 21227 | 10194 | 84 |
882606 | 882606 | 2020-12-31 | Warren | Kentucky | 21227 | 10194 | 84 |
879361 | 879361 | 2020-12-30 | Warren | Kentucky | 21227 | 10194 | 84 |
876116 | 876116 | 2020-12-29 | Warren | Kentucky | 21227 | 10049 | 84 |
872871 | 872871 | 2020-12-28 | Warren | Kentucky | 21227 | 9804 | 84 |
869626 | 869626 | 2020-12-27 | Warren | Kentucky | 21227 | 9750 | 84 |
866381 | 866381 | 2020-12-26 | Warren | Kentucky | 21227 | 9716 | 84 |
863136 | 863136 | 2020-12-25 | Warren | Kentucky | 21227 | 9583 | 83 |
859891 | 859891 | 2020-12-24 | Warren | Kentucky | 21227 | 9583 | 83 |
856646 | 856646 | 2020-12-23 | Warren | Kentucky | 21227 | 9583 | 83 |
853401 | 853401 | 2020-12-22 | Warren | Kentucky | 21227 | 9480 | 83 |
850156 | 850156 | 2020-12-21 | Warren | Kentucky | 21227 | 9379 | 83 |
846911 | 846911 | 2020-12-20 | Warren | Kentucky | 21227 | 9218 | 83 |
843665 | 843665 | 2020-12-19 | Warren | Kentucky | 21227 | 9105 | 83 |
840420 | 840420 | 2020-12-18 | Warren | Kentucky | 21227 | 9054 | 83 |
837175 | 837175 | 2020-12-17 | Warren | Kentucky | 21227 | 8958 | 83 |
833929 | 833929 | 2020-12-16 | Warren | Kentucky | 21227 | 8891 | 83 |
830682 | 830682 | 2020-12-15 | Warren | Kentucky | 21227 | 8740 | 83 |
827436 | 827436 | 2020-12-14 | Warren | Kentucky | 21227 | 8653 | 83 |
824189 | 824189 | 2020-12-13 | Warren | Kentucky | 21227 | 8562 | 83 |
820943 | 820943 | 2020-12-12 | Warren | Kentucky | 21227 | 8520 | 83 |
817697 | 817697 | 2020-12-11 | Warren | Kentucky | 21227 | 8440 | 81 |
814451 | 814451 | 2020-12-10 | Warren | Kentucky | 21227 | 8339 | 81 |
811206 | 811206 | 2020-12-09 | Warren | Kentucky | 21227 | 8231 | 81 |
807961 | 807961 | 2020-12-08 | Warren | Kentucky | 21227 | 8174 | 81 |
804716 | 804716 | 2020-12-07 | Warren | Kentucky | 21227 | 8070 | 81 |
801471 | 801471 | 2020-12-06 | Warren | Kentucky | 21227 | 7915 | 81 |
798226 | 798226 | 2020-12-05 | Warren | Kentucky | 21227 | 7842 | 81 |
794981 | 794981 | 2020-12-04 | Warren | Kentucky | 21227 | 7816 | 78 |
791736 | 791736 | 2020-12-03 | Warren | Kentucky | 21227 | 7733 | 78 |
788491 | 788491 | 2020-12-02 | Warren | Kentucky | 21227 | 7648 | 73 |
785247 | 785247 | 2020-12-01 | Warren | Kentucky | 21227 | 7531 | 73 |
782002 | 782002 | 2020-11-30 | Warren | Kentucky | 21227 | 7360 | 73 |
778756 | 778756 | 2020-11-29 | Warren | Kentucky | 21227 | 7211 | 73 |
775511 | 775511 | 2020-11-28 | Warren | Kentucky | 21227 | 7176 | 69 |
772266 | 772266 | 2020-11-27 | Warren | Kentucky | 21227 | 7094 | 65 |
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);