ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 21229 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1093568 | 1093568 | 2021-03-06 | Washington | Kentucky | 21229 | 1354 | 30 |
1090322 | 1090322 | 2021-03-05 | Washington | Kentucky | 21229 | 1350 | 30 |
1087077 | 1087077 | 2021-03-04 | Washington | Kentucky | 21229 | 1343 | 30 |
1083831 | 1083831 | 2021-03-03 | Washington | Kentucky | 21229 | 1340 | 30 |
1080585 | 1080585 | 2021-03-02 | Washington | Kentucky | 21229 | 1337 | 30 |
1077340 | 1077340 | 2021-03-01 | Washington | Kentucky | 21229 | 1331 | 30 |
1074094 | 1074094 | 2021-02-28 | Washington | Kentucky | 21229 | 1330 | 30 |
1070848 | 1070848 | 2021-02-27 | Washington | Kentucky | 21229 | 1330 | 29 |
1067603 | 1067603 | 2021-02-26 | Washington | Kentucky | 21229 | 1327 | 29 |
1064358 | 1064358 | 2021-02-25 | Washington | Kentucky | 21229 | 1324 | 29 |
1061113 | 1061113 | 2021-02-24 | Washington | Kentucky | 21229 | 1320 | 29 |
1057867 | 1057867 | 2021-02-23 | Washington | Kentucky | 21229 | 1317 | 29 |
1054621 | 1054621 | 2021-02-22 | Washington | Kentucky | 21229 | 1308 | 29 |
1051374 | 1051374 | 2021-02-21 | Washington | Kentucky | 21229 | 1305 | 29 |
1048127 | 1048127 | 2021-02-20 | Washington | Kentucky | 21229 | 1299 | 29 |
1044882 | 1044882 | 2021-02-19 | Washington | Kentucky | 21229 | 1295 | 29 |
1041637 | 1041637 | 2021-02-18 | Washington | Kentucky | 21229 | 1288 | 28 |
1038392 | 1038392 | 2021-02-17 | Washington | Kentucky | 21229 | 1284 | 28 |
1035147 | 1035147 | 2021-02-16 | Washington | Kentucky | 21229 | 1282 | 28 |
1031901 | 1031901 | 2021-02-15 | Washington | Kentucky | 21229 | 1280 | 28 |
1028654 | 1028654 | 2021-02-14 | Washington | Kentucky | 21229 | 1279 | 28 |
1025409 | 1025409 | 2021-02-13 | Washington | Kentucky | 21229 | 1272 | 28 |
1022164 | 1022164 | 2021-02-12 | Washington | Kentucky | 21229 | 1266 | 28 |
1018919 | 1018919 | 2021-02-11 | Washington | Kentucky | 21229 | 1260 | 27 |
1015674 | 1015674 | 2021-02-10 | Washington | Kentucky | 21229 | 1248 | 27 |
1012429 | 1012429 | 2021-02-09 | Washington | Kentucky | 21229 | 1243 | 27 |
1009183 | 1009183 | 2021-02-08 | Washington | Kentucky | 21229 | 1234 | 25 |
1005937 | 1005937 | 2021-02-07 | Washington | Kentucky | 21229 | 1230 | 24 |
1002691 | 1002691 | 2021-02-06 | Washington | Kentucky | 21229 | 1228 | 24 |
999445 | 999445 | 2021-02-05 | Washington | Kentucky | 21229 | 1221 | 24 |
996199 | 996199 | 2021-02-04 | Washington | Kentucky | 21229 | 1213 | 24 |
992953 | 992953 | 2021-02-03 | Washington | Kentucky | 21229 | 1187 | 24 |
989707 | 989707 | 2021-02-02 | Washington | Kentucky | 21229 | 1182 | 23 |
986460 | 986460 | 2021-02-01 | Washington | Kentucky | 21229 | 1173 | 23 |
983213 | 983213 | 2021-01-31 | Washington | Kentucky | 21229 | 1167 | 23 |
979967 | 979967 | 2021-01-30 | Washington | Kentucky | 21229 | 1165 | 22 |
976721 | 976721 | 2021-01-29 | Washington | Kentucky | 21229 | 1153 | 22 |
973476 | 973476 | 2021-01-28 | Washington | Kentucky | 21229 | 1142 | 22 |
970231 | 970231 | 2021-01-27 | Washington | Kentucky | 21229 | 1130 | 18 |
966987 | 966987 | 2021-01-26 | Washington | Kentucky | 21229 | 1118 | 18 |
963742 | 963742 | 2021-01-25 | Washington | Kentucky | 21229 | 1110 | 18 |
960497 | 960497 | 2021-01-24 | Washington | Kentucky | 21229 | 1108 | 17 |
957251 | 957251 | 2021-01-23 | Washington | Kentucky | 21229 | 1099 | 16 |
954006 | 954006 | 2021-01-22 | Washington | Kentucky | 21229 | 1079 | 16 |
950761 | 950761 | 2021-01-21 | Washington | Kentucky | 21229 | 1076 | 16 |
947515 | 947515 | 2021-01-20 | Washington | Kentucky | 21229 | 1050 | 16 |
944268 | 944268 | 2021-01-19 | Washington | Kentucky | 21229 | 1039 | 16 |
941023 | 941023 | 2021-01-18 | Washington | Kentucky | 21229 | 1038 | 16 |
937778 | 937778 | 2021-01-17 | Washington | Kentucky | 21229 | 1034 | 16 |
934533 | 934533 | 2021-01-16 | Washington | Kentucky | 21229 | 1024 | 16 |
931288 | 931288 | 2021-01-15 | Washington | Kentucky | 21229 | 1014 | 16 |
928043 | 928043 | 2021-01-14 | Washington | Kentucky | 21229 | 1002 | 14 |
924797 | 924797 | 2021-01-13 | Washington | Kentucky | 21229 | 991 | 14 |
921552 | 921552 | 2021-01-12 | Washington | Kentucky | 21229 | 971 | 12 |
918307 | 918307 | 2021-01-11 | Washington | Kentucky | 21229 | 962 | 12 |
915062 | 915062 | 2021-01-10 | Washington | Kentucky | 21229 | 959 | 12 |
911817 | 911817 | 2021-01-09 | Washington | Kentucky | 21229 | 953 | 12 |
908572 | 908572 | 2021-01-08 | Washington | Kentucky | 21229 | 939 | 12 |
905326 | 905326 | 2021-01-07 | Washington | Kentucky | 21229 | 931 | 12 |
902081 | 902081 | 2021-01-06 | Washington | Kentucky | 21229 | 920 | 12 |
898836 | 898836 | 2021-01-05 | Washington | Kentucky | 21229 | 899 | 11 |
895591 | 895591 | 2021-01-04 | Washington | Kentucky | 21229 | 892 | 11 |
892344 | 892344 | 2021-01-03 | Washington | Kentucky | 21229 | 889 | 11 |
889098 | 889098 | 2021-01-02 | Washington | Kentucky | 21229 | 886 | 11 |
885852 | 885852 | 2021-01-01 | Washington | Kentucky | 21229 | 869 | 9 |
882607 | 882607 | 2020-12-31 | Washington | Kentucky | 21229 | 869 | 9 |
879362 | 879362 | 2020-12-30 | Washington | Kentucky | 21229 | 869 | 9 |
876117 | 876117 | 2020-12-29 | Washington | Kentucky | 21229 | 860 | 9 |
872872 | 872872 | 2020-12-28 | Washington | Kentucky | 21229 | 850 | 9 |
869627 | 869627 | 2020-12-27 | Washington | Kentucky | 21229 | 847 | 9 |
866382 | 866382 | 2020-12-26 | Washington | Kentucky | 21229 | 846 | 9 |
863137 | 863137 | 2020-12-25 | Washington | Kentucky | 21229 | 826 | 9 |
859892 | 859892 | 2020-12-24 | Washington | Kentucky | 21229 | 826 | 9 |
856647 | 856647 | 2020-12-23 | Washington | Kentucky | 21229 | 826 | 9 |
853402 | 853402 | 2020-12-22 | Washington | Kentucky | 21229 | 821 | 9 |
850157 | 850157 | 2020-12-21 | Washington | Kentucky | 21229 | 809 | 9 |
846912 | 846912 | 2020-12-20 | Washington | Kentucky | 21229 | 808 | 9 |
843666 | 843666 | 2020-12-19 | Washington | Kentucky | 21229 | 806 | 8 |
840421 | 840421 | 2020-12-18 | Washington | Kentucky | 21229 | 791 | 8 |
837176 | 837176 | 2020-12-17 | Washington | Kentucky | 21229 | 781 | 8 |
833930 | 833930 | 2020-12-16 | Washington | Kentucky | 21229 | 775 | 7 |
830683 | 830683 | 2020-12-15 | Washington | Kentucky | 21229 | 760 | 7 |
827437 | 827437 | 2020-12-14 | Washington | Kentucky | 21229 | 746 | 7 |
824190 | 824190 | 2020-12-13 | Washington | Kentucky | 21229 | 745 | 4 |
820944 | 820944 | 2020-12-12 | Washington | Kentucky | 21229 | 742 | 4 |
817698 | 817698 | 2020-12-11 | Washington | Kentucky | 21229 | 726 | 4 |
814452 | 814452 | 2020-12-10 | Washington | Kentucky | 21229 | 713 | 4 |
811207 | 811207 | 2020-12-09 | Washington | Kentucky | 21229 | 699 | 4 |
807962 | 807962 | 2020-12-08 | Washington | Kentucky | 21229 | 687 | 4 |
804717 | 804717 | 2020-12-07 | Washington | Kentucky | 21229 | 670 | 4 |
801472 | 801472 | 2020-12-06 | Washington | Kentucky | 21229 | 666 | 4 |
798227 | 798227 | 2020-12-05 | Washington | Kentucky | 21229 | 658 | 4 |
794982 | 794982 | 2020-12-04 | Washington | Kentucky | 21229 | 629 | 4 |
791737 | 791737 | 2020-12-03 | Washington | Kentucky | 21229 | 592 | 4 |
788492 | 788492 | 2020-12-02 | Washington | Kentucky | 21229 | 581 | 4 |
785248 | 785248 | 2020-12-01 | Washington | Kentucky | 21229 | 560 | 4 |
782003 | 782003 | 2020-11-30 | Washington | Kentucky | 21229 | 541 | 4 |
778757 | 778757 | 2020-11-29 | Washington | Kentucky | 21229 | 530 | 4 |
775512 | 775512 | 2020-11-28 | Washington | Kentucky | 21229 | 515 | 4 |
772267 | 772267 | 2020-11-27 | Washington | Kentucky | 21229 | 515 | 4 |
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);