ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Anderson" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1090210 | 1090210 | 2021-03-05 | Anderson | Kentucky | 21005 | 1636 | 16 |
1086965 | 1086965 | 2021-03-04 | Anderson | Kentucky | 21005 | 1630 | 16 |
1083719 | 1083719 | 2021-03-03 | Anderson | Kentucky | 21005 | 1627 | 16 |
1080473 | 1080473 | 2021-03-02 | Anderson | Kentucky | 21005 | 1624 | 16 |
1077228 | 1077228 | 2021-03-01 | Anderson | Kentucky | 21005 | 1619 | 16 |
1073982 | 1073982 | 2021-02-28 | Anderson | Kentucky | 21005 | 1618 | 16 |
1070736 | 1070736 | 2021-02-27 | Anderson | Kentucky | 21005 | 1617 | 16 |
1067491 | 1067491 | 2021-02-26 | Anderson | Kentucky | 21005 | 1613 | 16 |
1064246 | 1064246 | 2021-02-25 | Anderson | Kentucky | 21005 | 1607 | 16 |
1061001 | 1061001 | 2021-02-24 | Anderson | Kentucky | 21005 | 1604 | 16 |
1057755 | 1057755 | 2021-02-23 | Anderson | Kentucky | 21005 | 1600 | 16 |
1054509 | 1054509 | 2021-02-22 | Anderson | Kentucky | 21005 | 1596 | 16 |
1051262 | 1051262 | 2021-02-21 | Anderson | Kentucky | 21005 | 1595 | 16 |
1048015 | 1048015 | 2021-02-20 | Anderson | Kentucky | 21005 | 1593 | 16 |
1044770 | 1044770 | 2021-02-19 | Anderson | Kentucky | 21005 | 1589 | 16 |
1041525 | 1041525 | 2021-02-18 | Anderson | Kentucky | 21005 | 1586 | 15 |
1038280 | 1038280 | 2021-02-17 | Anderson | Kentucky | 21005 | 1582 | 15 |
1035035 | 1035035 | 2021-02-16 | Anderson | Kentucky | 21005 | 1581 | 15 |
1031789 | 1031789 | 2021-02-15 | Anderson | Kentucky | 21005 | 1577 | 15 |
1028542 | 1028542 | 2021-02-14 | Anderson | Kentucky | 21005 | 1575 | 15 |
1025297 | 1025297 | 2021-02-13 | Anderson | Kentucky | 21005 | 1567 | 15 |
1022052 | 1022052 | 2021-02-12 | Anderson | Kentucky | 21005 | 1567 | 15 |
1018807 | 1018807 | 2021-02-11 | Anderson | Kentucky | 21005 | 1565 | 15 |
1015562 | 1015562 | 2021-02-10 | Anderson | Kentucky | 21005 | 1563 | 15 |
1012317 | 1012317 | 2021-02-09 | Anderson | Kentucky | 21005 | 1557 | 14 |
1009071 | 1009071 | 2021-02-08 | Anderson | Kentucky | 21005 | 1543 | 14 |
1005825 | 1005825 | 2021-02-07 | Anderson | Kentucky | 21005 | 1540 | 14 |
1002579 | 1002579 | 2021-02-06 | Anderson | Kentucky | 21005 | 1538 | 13 |
999333 | 999333 | 2021-02-05 | Anderson | Kentucky | 21005 | 1522 | 13 |
996087 | 996087 | 2021-02-04 | Anderson | Kentucky | 21005 | 1501 | 12 |
992841 | 992841 | 2021-02-03 | Anderson | Kentucky | 21005 | 1488 | 12 |
989595 | 989595 | 2021-02-02 | Anderson | Kentucky | 21005 | 1476 | 12 |
986348 | 986348 | 2021-02-01 | Anderson | Kentucky | 21005 | 1449 | 12 |
983101 | 983101 | 2021-01-31 | Anderson | Kentucky | 21005 | 1447 | 12 |
979855 | 979855 | 2021-01-30 | Anderson | Kentucky | 21005 | 1437 | 12 |
976609 | 976609 | 2021-01-29 | Anderson | Kentucky | 21005 | 1417 | 12 |
973364 | 973364 | 2021-01-28 | Anderson | Kentucky | 21005 | 1412 | 12 |
970119 | 970119 | 2021-01-27 | Anderson | Kentucky | 21005 | 1392 | 11 |
966875 | 966875 | 2021-01-26 | Anderson | Kentucky | 21005 | 1367 | 11 |
963630 | 963630 | 2021-01-25 | Anderson | Kentucky | 21005 | 1355 | 11 |
960385 | 960385 | 2021-01-24 | Anderson | Kentucky | 21005 | 1351 | 11 |
957139 | 957139 | 2021-01-23 | Anderson | Kentucky | 21005 | 1347 | 11 |
953894 | 953894 | 2021-01-22 | Anderson | Kentucky | 21005 | 1333 | 11 |
950649 | 950649 | 2021-01-21 | Anderson | Kentucky | 21005 | 1310 | 8 |
947403 | 947403 | 2021-01-20 | Anderson | Kentucky | 21005 | 1295 | 8 |
944156 | 944156 | 2021-01-19 | Anderson | Kentucky | 21005 | 1278 | 5 |
940911 | 940911 | 2021-01-18 | Anderson | Kentucky | 21005 | 1268 | 4 |
937666 | 937666 | 2021-01-17 | Anderson | Kentucky | 21005 | 1261 | 4 |
934421 | 934421 | 2021-01-16 | Anderson | Kentucky | 21005 | 1251 | 4 |
931176 | 931176 | 2021-01-15 | Anderson | Kentucky | 21005 | 1232 | 4 |
927931 | 927931 | 2021-01-14 | Anderson | Kentucky | 21005 | 1221 | 4 |
924685 | 924685 | 2021-01-13 | Anderson | Kentucky | 21005 | 1212 | 4 |
921440 | 921440 | 2021-01-12 | Anderson | Kentucky | 21005 | 1196 | 4 |
918195 | 918195 | 2021-01-11 | Anderson | Kentucky | 21005 | 1176 | 4 |
914950 | 914950 | 2021-01-10 | Anderson | Kentucky | 21005 | 1173 | 4 |
911705 | 911705 | 2021-01-09 | Anderson | Kentucky | 21005 | 1158 | 4 |
908460 | 908460 | 2021-01-08 | Anderson | Kentucky | 21005 | 1146 | 3 |
905214 | 905214 | 2021-01-07 | Anderson | Kentucky | 21005 | 1126 | 3 |
901969 | 901969 | 2021-01-06 | Anderson | Kentucky | 21005 | 1111 | 3 |
898724 | 898724 | 2021-01-05 | Anderson | Kentucky | 21005 | 1062 | 3 |
895479 | 895479 | 2021-01-04 | Anderson | Kentucky | 21005 | 1044 | 3 |
892232 | 892232 | 2021-01-03 | Anderson | Kentucky | 21005 | 1025 | 3 |
888986 | 888986 | 2021-01-02 | Anderson | Kentucky | 21005 | 1005 | 3 |
885740 | 885740 | 2021-01-01 | Anderson | Kentucky | 21005 | 971 | 2 |
882495 | 882495 | 2020-12-31 | Anderson | Kentucky | 21005 | 971 | 2 |
879250 | 879250 | 2020-12-30 | Anderson | Kentucky | 21005 | 971 | 2 |
876005 | 876005 | 2020-12-29 | Anderson | Kentucky | 21005 | 946 | 2 |
872760 | 872760 | 2020-12-28 | Anderson | Kentucky | 21005 | 923 | 2 |
869515 | 869515 | 2020-12-27 | Anderson | Kentucky | 21005 | 925 | 2 |
866270 | 866270 | 2020-12-26 | Anderson | Kentucky | 21005 | 925 | 2 |
863025 | 863025 | 2020-12-25 | Anderson | Kentucky | 21005 | 874 | 1 |
859780 | 859780 | 2020-12-24 | Anderson | Kentucky | 21005 | 874 | 1 |
856535 | 856535 | 2020-12-23 | Anderson | Kentucky | 21005 | 874 | 1 |
853290 | 853290 | 2020-12-22 | Anderson | Kentucky | 21005 | 843 | 1 |
850045 | 850045 | 2020-12-21 | Anderson | Kentucky | 21005 | 824 | 1 |
846800 | 846800 | 2020-12-20 | Anderson | Kentucky | 21005 | 815 | 1 |
843554 | 843554 | 2020-12-19 | Anderson | Kentucky | 21005 | 813 | 1 |
840309 | 840309 | 2020-12-18 | Anderson | Kentucky | 21005 | 790 | 1 |
837064 | 837064 | 2020-12-17 | Anderson | Kentucky | 21005 | 778 | 1 |
833818 | 833818 | 2020-12-16 | Anderson | Kentucky | 21005 | 746 | 1 |
830571 | 830571 | 2020-12-15 | Anderson | Kentucky | 21005 | 734 | 1 |
827325 | 827325 | 2020-12-14 | Anderson | Kentucky | 21005 | 717 | 1 |
824078 | 824078 | 2020-12-13 | Anderson | Kentucky | 21005 | 712 | 1 |
820832 | 820832 | 2020-12-12 | Anderson | Kentucky | 21005 | 706 | 1 |
817586 | 817586 | 2020-12-11 | Anderson | Kentucky | 21005 | 690 | 1 |
814340 | 814340 | 2020-12-10 | Anderson | Kentucky | 21005 | 658 | 1 |
811095 | 811095 | 2020-12-09 | Anderson | Kentucky | 21005 | 649 | 1 |
807850 | 807850 | 2020-12-08 | Anderson | Kentucky | 21005 | 632 | 1 |
804605 | 804605 | 2020-12-07 | Anderson | Kentucky | 21005 | 606 | 1 |
801360 | 801360 | 2020-12-06 | Anderson | Kentucky | 21005 | 592 | 1 |
798115 | 798115 | 2020-12-05 | Anderson | Kentucky | 21005 | 589 | 1 |
794870 | 794870 | 2020-12-04 | Anderson | Kentucky | 21005 | 580 | 1 |
791625 | 791625 | 2020-12-03 | Anderson | Kentucky | 21005 | 561 | 1 |
788380 | 788380 | 2020-12-02 | Anderson | Kentucky | 21005 | 549 | 1 |
785136 | 785136 | 2020-12-01 | Anderson | Kentucky | 21005 | 529 | 1 |
781891 | 781891 | 2020-11-30 | Anderson | Kentucky | 21005 | 506 | 1 |
778645 | 778645 | 2020-11-29 | Anderson | Kentucky | 21005 | 505 | 1 |
775400 | 775400 | 2020-11-28 | Anderson | Kentucky | 21005 | 503 | 1 |
772155 | 772155 | 2020-11-27 | Anderson | Kentucky | 21005 | 495 | 1 |
768910 | 768910 | 2020-11-26 | Anderson | Kentucky | 21005 | 478 | 1 |
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);