ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Spencer" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1093561 | 1093561 | 2021-03-06 | Spencer | Kentucky | 21215 | 1519 | 13 |
1090315 | 1090315 | 2021-03-05 | Spencer | Kentucky | 21215 | 1516 | 13 |
1087070 | 1087070 | 2021-03-04 | Spencer | Kentucky | 21215 | 1509 | 13 |
1083824 | 1083824 | 2021-03-03 | Spencer | Kentucky | 21215 | 1512 | 13 |
1080578 | 1080578 | 2021-03-02 | Spencer | Kentucky | 21215 | 1504 | 13 |
1077333 | 1077333 | 2021-03-01 | Spencer | Kentucky | 21215 | 1504 | 13 |
1074087 | 1074087 | 2021-02-28 | Spencer | Kentucky | 21215 | 1503 | 13 |
1070841 | 1070841 | 2021-02-27 | Spencer | Kentucky | 21215 | 1499 | 13 |
1067596 | 1067596 | 2021-02-26 | Spencer | Kentucky | 21215 | 1497 | 13 |
1064351 | 1064351 | 2021-02-25 | Spencer | Kentucky | 21215 | 1494 | 13 |
1061106 | 1061106 | 2021-02-24 | Spencer | Kentucky | 21215 | 1490 | 12 |
1057860 | 1057860 | 2021-02-23 | Spencer | Kentucky | 21215 | 1483 | 12 |
1054614 | 1054614 | 2021-02-22 | Spencer | Kentucky | 21215 | 1477 | 11 |
1051367 | 1051367 | 2021-02-21 | Spencer | Kentucky | 21215 | 1472 | 11 |
1048120 | 1048120 | 2021-02-20 | Spencer | Kentucky | 21215 | 1466 | 11 |
1044875 | 1044875 | 2021-02-19 | Spencer | Kentucky | 21215 | 1462 | 11 |
1041630 | 1041630 | 2021-02-18 | Spencer | Kentucky | 21215 | 1454 | 11 |
1038385 | 1038385 | 2021-02-17 | Spencer | Kentucky | 21215 | 1440 | 9 |
1035140 | 1035140 | 2021-02-16 | Spencer | Kentucky | 21215 | 1434 | 9 |
1031894 | 1031894 | 2021-02-15 | Spencer | Kentucky | 21215 | 1427 | 9 |
1028647 | 1028647 | 2021-02-14 | Spencer | Kentucky | 21215 | 1422 | 5 |
1025402 | 1025402 | 2021-02-13 | Spencer | Kentucky | 21215 | 1413 | 5 |
1022157 | 1022157 | 2021-02-12 | Spencer | Kentucky | 21215 | 1412 | 5 |
1018912 | 1018912 | 2021-02-11 | Spencer | Kentucky | 21215 | 1402 | 5 |
1015667 | 1015667 | 2021-02-10 | Spencer | Kentucky | 21215 | 1389 | 5 |
1012422 | 1012422 | 2021-02-09 | Spencer | Kentucky | 21215 | 1380 | 5 |
1009176 | 1009176 | 2021-02-08 | Spencer | Kentucky | 21215 | 1377 | 5 |
1005930 | 1005930 | 2021-02-07 | Spencer | Kentucky | 21215 | 1373 | 5 |
1002684 | 1002684 | 2021-02-06 | Spencer | Kentucky | 21215 | 1366 | 5 |
999438 | 999438 | 2021-02-05 | Spencer | Kentucky | 21215 | 1360 | 5 |
996192 | 996192 | 2021-02-04 | Spencer | Kentucky | 21215 | 1350 | 5 |
992946 | 992946 | 2021-02-03 | Spencer | Kentucky | 21215 | 1334 | 5 |
989700 | 989700 | 2021-02-02 | Spencer | Kentucky | 21215 | 1330 | 5 |
986453 | 986453 | 2021-02-01 | Spencer | Kentucky | 21215 | 1326 | 5 |
983206 | 983206 | 2021-01-31 | Spencer | Kentucky | 21215 | 1314 | 5 |
979960 | 979960 | 2021-01-30 | Spencer | Kentucky | 21215 | 1308 | 5 |
976714 | 976714 | 2021-01-29 | Spencer | Kentucky | 21215 | 1291 | 5 |
973469 | 973469 | 2021-01-28 | Spencer | Kentucky | 21215 | 1289 | 5 |
970224 | 970224 | 2021-01-27 | Spencer | Kentucky | 21215 | 1276 | 5 |
966980 | 966980 | 2021-01-26 | Spencer | Kentucky | 21215 | 1267 | 5 |
963735 | 963735 | 2021-01-25 | Spencer | Kentucky | 21215 | 1257 | 5 |
960490 | 960490 | 2021-01-24 | Spencer | Kentucky | 21215 | 1250 | 5 |
957244 | 957244 | 2021-01-23 | Spencer | Kentucky | 21215 | 1245 | 5 |
953999 | 953999 | 2021-01-22 | Spencer | Kentucky | 21215 | 1230 | 5 |
950754 | 950754 | 2021-01-21 | Spencer | Kentucky | 21215 | 1213 | 5 |
947508 | 947508 | 2021-01-20 | Spencer | Kentucky | 21215 | 1200 | 5 |
944261 | 944261 | 2021-01-19 | Spencer | Kentucky | 21215 | 1192 | 5 |
941016 | 941016 | 2021-01-18 | Spencer | Kentucky | 21215 | 1182 | 5 |
937771 | 937771 | 2021-01-17 | Spencer | Kentucky | 21215 | 1176 | 5 |
934526 | 934526 | 2021-01-16 | Spencer | Kentucky | 21215 | 1163 | 5 |
931281 | 931281 | 2021-01-15 | Spencer | Kentucky | 21215 | 1155 | 5 |
928036 | 928036 | 2021-01-14 | Spencer | Kentucky | 21215 | 1142 | 5 |
924790 | 924790 | 2021-01-13 | Spencer | Kentucky | 21215 | 1134 | 5 |
921545 | 921545 | 2021-01-12 | Spencer | Kentucky | 21215 | 1126 | 5 |
918300 | 918300 | 2021-01-11 | Spencer | Kentucky | 21215 | 1121 | 5 |
915055 | 915055 | 2021-01-10 | Spencer | Kentucky | 21215 | 1111 | 5 |
911810 | 911810 | 2021-01-09 | Spencer | Kentucky | 21215 | 1097 | 5 |
908565 | 908565 | 2021-01-08 | Spencer | Kentucky | 21215 | 1085 | 5 |
905319 | 905319 | 2021-01-07 | Spencer | Kentucky | 21215 | 1072 | 5 |
902074 | 902074 | 2021-01-06 | Spencer | Kentucky | 21215 | 1046 | 5 |
898829 | 898829 | 2021-01-05 | Spencer | Kentucky | 21215 | 1025 | 5 |
895584 | 895584 | 2021-01-04 | Spencer | Kentucky | 21215 | 1019 | 5 |
892337 | 892337 | 2021-01-03 | Spencer | Kentucky | 21215 | 1012 | 5 |
889091 | 889091 | 2021-01-02 | Spencer | Kentucky | 21215 | 1010 | 5 |
885845 | 885845 | 2021-01-01 | Spencer | Kentucky | 21215 | 987 | 5 |
882600 | 882600 | 2020-12-31 | Spencer | Kentucky | 21215 | 987 | 5 |
879355 | 879355 | 2020-12-30 | Spencer | Kentucky | 21215 | 987 | 5 |
876110 | 876110 | 2020-12-29 | Spencer | Kentucky | 21215 | 974 | 5 |
872865 | 872865 | 2020-12-28 | Spencer | Kentucky | 21215 | 965 | 5 |
869620 | 869620 | 2020-12-27 | Spencer | Kentucky | 21215 | 963 | 5 |
866375 | 866375 | 2020-12-26 | Spencer | Kentucky | 21215 | 955 | 5 |
863130 | 863130 | 2020-12-25 | Spencer | Kentucky | 21215 | 947 | 5 |
859885 | 859885 | 2020-12-24 | Spencer | Kentucky | 21215 | 947 | 5 |
856640 | 856640 | 2020-12-23 | Spencer | Kentucky | 21215 | 947 | 5 |
853395 | 853395 | 2020-12-22 | Spencer | Kentucky | 21215 | 937 | 5 |
850150 | 850150 | 2020-12-21 | Spencer | Kentucky | 21215 | 937 | 5 |
846905 | 846905 | 2020-12-20 | Spencer | Kentucky | 21215 | 934 | 5 |
843659 | 843659 | 2020-12-19 | Spencer | Kentucky | 21215 | 924 | 4 |
840414 | 840414 | 2020-12-18 | Spencer | Kentucky | 21215 | 906 | 3 |
837169 | 837169 | 2020-12-17 | Spencer | Kentucky | 21215 | 901 | 3 |
833923 | 833923 | 2020-12-16 | Spencer | Kentucky | 21215 | 876 | 2 |
830676 | 830676 | 2020-12-15 | Spencer | Kentucky | 21215 | 869 | 2 |
827430 | 827430 | 2020-12-14 | Spencer | Kentucky | 21215 | 859 | 2 |
824183 | 824183 | 2020-12-13 | Spencer | Kentucky | 21215 | 854 | 2 |
820937 | 820937 | 2020-12-12 | Spencer | Kentucky | 21215 | 836 | 2 |
817691 | 817691 | 2020-12-11 | Spencer | Kentucky | 21215 | 812 | 2 |
814445 | 814445 | 2020-12-10 | Spencer | Kentucky | 21215 | 772 | 2 |
811200 | 811200 | 2020-12-09 | Spencer | Kentucky | 21215 | 739 | 2 |
807955 | 807955 | 2020-12-08 | Spencer | Kentucky | 21215 | 722 | 2 |
804710 | 804710 | 2020-12-07 | Spencer | Kentucky | 21215 | 721 | 2 |
801465 | 801465 | 2020-12-06 | Spencer | Kentucky | 21215 | 719 | 2 |
798220 | 798220 | 2020-12-05 | Spencer | Kentucky | 21215 | 699 | 2 |
794975 | 794975 | 2020-12-04 | Spencer | Kentucky | 21215 | 688 | 2 |
791730 | 791730 | 2020-12-03 | Spencer | Kentucky | 21215 | 674 | 2 |
788485 | 788485 | 2020-12-02 | Spencer | Kentucky | 21215 | 660 | 2 |
785241 | 785241 | 2020-12-01 | Spencer | Kentucky | 21215 | 651 | 2 |
781996 | 781996 | 2020-11-30 | Spencer | Kentucky | 21215 | 643 | 2 |
778750 | 778750 | 2020-11-29 | Spencer | Kentucky | 21215 | 636 | 2 |
775505 | 775505 | 2020-11-28 | Spencer | Kentucky | 21215 | 634 | 2 |
772260 | 772260 | 2020-11-27 | Spencer | Kentucky | 21215 | 623 | 2 |
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);