ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where fips = 21097 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1090256 | 1090256 | 2021-03-05 | Harrison | Kentucky | 21097 | 1523 | 9 |
1087011 | 1087011 | 2021-03-04 | Harrison | Kentucky | 21097 | 1518 | 9 |
1083765 | 1083765 | 2021-03-03 | Harrison | Kentucky | 21097 | 1514 | 9 |
1080519 | 1080519 | 2021-03-02 | Harrison | Kentucky | 21097 | 1509 | 9 |
1077274 | 1077274 | 2021-03-01 | Harrison | Kentucky | 21097 | 1505 | 9 |
1074028 | 1074028 | 2021-02-28 | Harrison | Kentucky | 21097 | 1504 | 9 |
1070782 | 1070782 | 2021-02-27 | Harrison | Kentucky | 21097 | 1503 | 9 |
1067537 | 1067537 | 2021-02-26 | Harrison | Kentucky | 21097 | 1500 | 9 |
1064292 | 1064292 | 2021-02-25 | Harrison | Kentucky | 21097 | 1495 | 9 |
1061047 | 1061047 | 2021-02-24 | Harrison | Kentucky | 21097 | 1494 | 9 |
1057801 | 1057801 | 2021-02-23 | Harrison | Kentucky | 21097 | 1486 | 9 |
1054555 | 1054555 | 2021-02-22 | Harrison | Kentucky | 21097 | 1481 | 9 |
1051308 | 1051308 | 2021-02-21 | Harrison | Kentucky | 21097 | 1477 | 9 |
1048061 | 1048061 | 2021-02-20 | Harrison | Kentucky | 21097 | 1471 | 9 |
1044816 | 1044816 | 2021-02-19 | Harrison | Kentucky | 21097 | 1465 | 9 |
1041571 | 1041571 | 2021-02-18 | Harrison | Kentucky | 21097 | 1461 | 9 |
1038326 | 1038326 | 2021-02-17 | Harrison | Kentucky | 21097 | 1459 | 9 |
1035081 | 1035081 | 2021-02-16 | Harrison | Kentucky | 21097 | 1452 | 9 |
1031835 | 1031835 | 2021-02-15 | Harrison | Kentucky | 21097 | 1449 | 9 |
1028588 | 1028588 | 2021-02-14 | Harrison | Kentucky | 21097 | 1448 | 9 |
1025343 | 1025343 | 2021-02-13 | Harrison | Kentucky | 21097 | 1438 | 9 |
1022098 | 1022098 | 2021-02-12 | Harrison | Kentucky | 21097 | 1437 | 9 |
1018853 | 1018853 | 2021-02-11 | Harrison | Kentucky | 21097 | 1435 | 9 |
1015608 | 1015608 | 2021-02-10 | Harrison | Kentucky | 21097 | 1430 | 9 |
1012363 | 1012363 | 2021-02-09 | Harrison | Kentucky | 21097 | 1426 | 8 |
1009117 | 1009117 | 2021-02-08 | Harrison | Kentucky | 21097 | 1416 | 8 |
1005871 | 1005871 | 2021-02-07 | Harrison | Kentucky | 21097 | 1414 | 7 |
1002625 | 1002625 | 2021-02-06 | Harrison | Kentucky | 21097 | 1403 | 7 |
999379 | 999379 | 2021-02-05 | Harrison | Kentucky | 21097 | 1401 | 6 |
996133 | 996133 | 2021-02-04 | Harrison | Kentucky | 21097 | 1394 | 6 |
992887 | 992887 | 2021-02-03 | Harrison | Kentucky | 21097 | 1376 | 6 |
989641 | 989641 | 2021-02-02 | Harrison | Kentucky | 21097 | 1367 | 6 |
986394 | 986394 | 2021-02-01 | Harrison | Kentucky | 21097 | 1359 | 6 |
983147 | 983147 | 2021-01-31 | Harrison | Kentucky | 21097 | 1355 | 5 |
979901 | 979901 | 2021-01-30 | Harrison | Kentucky | 21097 | 1349 | 5 |
976655 | 976655 | 2021-01-29 | Harrison | Kentucky | 21097 | 1333 | 4 |
973410 | 973410 | 2021-01-28 | Harrison | Kentucky | 21097 | 1326 | 4 |
970165 | 970165 | 2021-01-27 | Harrison | Kentucky | 21097 | 1310 | 4 |
966921 | 966921 | 2021-01-26 | Harrison | Kentucky | 21097 | 1302 | 3 |
963676 | 963676 | 2021-01-25 | Harrison | Kentucky | 21097 | 1286 | 2 |
960431 | 960431 | 2021-01-24 | Harrison | Kentucky | 21097 | 1276 | 2 |
957185 | 957185 | 2021-01-23 | Harrison | Kentucky | 21097 | 1258 | 2 |
953940 | 953940 | 2021-01-22 | Harrison | Kentucky | 21097 | 1236 | 2 |
950695 | 950695 | 2021-01-21 | Harrison | Kentucky | 21097 | 1210 | 2 |
947449 | 947449 | 2021-01-20 | Harrison | Kentucky | 21097 | 1205 | 2 |
944202 | 944202 | 2021-01-19 | Harrison | Kentucky | 21097 | 1195 | 2 |
940957 | 940957 | 2021-01-18 | Harrison | Kentucky | 21097 | 1182 | 2 |
937712 | 937712 | 2021-01-17 | Harrison | Kentucky | 21097 | 1161 | 2 |
934467 | 934467 | 2021-01-16 | Harrison | Kentucky | 21097 | 1129 | 2 |
931222 | 931222 | 2021-01-15 | Harrison | Kentucky | 21097 | 1119 | 2 |
927977 | 927977 | 2021-01-14 | Harrison | Kentucky | 21097 | 1103 | 2 |
924731 | 924731 | 2021-01-13 | Harrison | Kentucky | 21097 | 1094 | 2 |
921486 | 921486 | 2021-01-12 | Harrison | Kentucky | 21097 | 1044 | 2 |
918241 | 918241 | 2021-01-11 | Harrison | Kentucky | 21097 | 1020 | 1 |
914996 | 914996 | 2021-01-10 | Harrison | Kentucky | 21097 | 1005 | 1 |
911751 | 911751 | 2021-01-09 | Harrison | Kentucky | 21097 | 972 | 1 |
908506 | 908506 | 2021-01-08 | Harrison | Kentucky | 21097 | 939 | 1 |
905260 | 905260 | 2021-01-07 | Harrison | Kentucky | 21097 | 910 | 1 |
902015 | 902015 | 2021-01-06 | Harrison | Kentucky | 21097 | 884 | 1 |
898770 | 898770 | 2021-01-05 | Harrison | Kentucky | 21097 | 849 | 1 |
895525 | 895525 | 2021-01-04 | Harrison | Kentucky | 21097 | 843 | 1 |
892278 | 892278 | 2021-01-03 | Harrison | Kentucky | 21097 | 827 | 1 |
889032 | 889032 | 2021-01-02 | Harrison | Kentucky | 21097 | 789 | 1 |
885786 | 885786 | 2021-01-01 | Harrison | Kentucky | 21097 | 729 | 1 |
882541 | 882541 | 2020-12-31 | Harrison | Kentucky | 21097 | 729 | 1 |
879296 | 879296 | 2020-12-30 | Harrison | Kentucky | 21097 | 729 | 1 |
876051 | 876051 | 2020-12-29 | Harrison | Kentucky | 21097 | 720 | 1 |
872806 | 872806 | 2020-12-28 | Harrison | Kentucky | 21097 | 712 | 1 |
869561 | 869561 | 2020-12-27 | Harrison | Kentucky | 21097 | 704 | 1 |
866316 | 866316 | 2020-12-26 | Harrison | Kentucky | 21097 | 702 | 1 |
863071 | 863071 | 2020-12-25 | Harrison | Kentucky | 21097 | 689 | 1 |
859826 | 859826 | 2020-12-24 | Harrison | Kentucky | 21097 | 689 | 1 |
856581 | 856581 | 2020-12-23 | Harrison | Kentucky | 21097 | 689 | 1 |
853336 | 853336 | 2020-12-22 | Harrison | Kentucky | 21097 | 681 | 1 |
850091 | 850091 | 2020-12-21 | Harrison | Kentucky | 21097 | 667 | 1 |
846846 | 846846 | 2020-12-20 | Harrison | Kentucky | 21097 | 658 | 1 |
843600 | 843600 | 2020-12-19 | Harrison | Kentucky | 21097 | 649 | 1 |
840355 | 840355 | 2020-12-18 | Harrison | Kentucky | 21097 | 638 | 1 |
837110 | 837110 | 2020-12-17 | Harrison | Kentucky | 21097 | 631 | 1 |
833864 | 833864 | 2020-12-16 | Harrison | Kentucky | 21097 | 622 | 1 |
830617 | 830617 | 2020-12-15 | Harrison | Kentucky | 21097 | 613 | 1 |
827371 | 827371 | 2020-12-14 | Harrison | Kentucky | 21097 | 613 | 1 |
824124 | 824124 | 2020-12-13 | Harrison | Kentucky | 21097 | 597 | 1 |
820878 | 820878 | 2020-12-12 | Harrison | Kentucky | 21097 | 583 | 1 |
817632 | 817632 | 2020-12-11 | Harrison | Kentucky | 21097 | 574 | 1 |
814386 | 814386 | 2020-12-10 | Harrison | Kentucky | 21097 | 562 | 1 |
811141 | 811141 | 2020-12-09 | Harrison | Kentucky | 21097 | 555 | 1 |
807896 | 807896 | 2020-12-08 | Harrison | Kentucky | 21097 | 547 | 1 |
804651 | 804651 | 2020-12-07 | Harrison | Kentucky | 21097 | 531 | 1 |
801406 | 801406 | 2020-12-06 | Harrison | Kentucky | 21097 | 523 | 1 |
798161 | 798161 | 2020-12-05 | Harrison | Kentucky | 21097 | 522 | 1 |
794916 | 794916 | 2020-12-04 | Harrison | Kentucky | 21097 | 511 | 1 |
791671 | 791671 | 2020-12-03 | Harrison | Kentucky | 21097 | 508 | 1 |
788426 | 788426 | 2020-12-02 | Harrison | Kentucky | 21097 | 501 | 1 |
785182 | 785182 | 2020-12-01 | Harrison | Kentucky | 21097 | 496 | 1 |
781937 | 781937 | 2020-11-30 | Harrison | Kentucky | 21097 | 483 | 1 |
778691 | 778691 | 2020-11-29 | Harrison | Kentucky | 21097 | 478 | 1 |
775446 | 775446 | 2020-11-28 | Harrison | Kentucky | 21097 | 461 | 1 |
772201 | 772201 | 2020-11-27 | Harrison | Kentucky | 21097 | 460 | 1 |
768956 | 768956 | 2020-11-26 | Harrison | Kentucky | 21097 | 445 | 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);