ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 21173 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947487 | 947487 | 2021-01-20 | Montgomery | Kentucky | 21173 | 1816 | 16 |
944240 | 944240 | 2021-01-19 | Montgomery | Kentucky | 21173 | 1807 | 16 |
940995 | 940995 | 2021-01-18 | Montgomery | Kentucky | 21173 | 1788 | 16 |
937750 | 937750 | 2021-01-17 | Montgomery | Kentucky | 21173 | 1779 | 15 |
934505 | 934505 | 2021-01-16 | Montgomery | Kentucky | 21173 | 1773 | 15 |
931260 | 931260 | 2021-01-15 | Montgomery | Kentucky | 21173 | 1748 | 15 |
928015 | 928015 | 2021-01-14 | Montgomery | Kentucky | 21173 | 1722 | 15 |
924769 | 924769 | 2021-01-13 | Montgomery | Kentucky | 21173 | 1691 | 12 |
921524 | 921524 | 2021-01-12 | Montgomery | Kentucky | 21173 | 1661 | 12 |
918279 | 918279 | 2021-01-11 | Montgomery | Kentucky | 21173 | 1626 | 12 |
915034 | 915034 | 2021-01-10 | Montgomery | Kentucky | 21173 | 1614 | 12 |
911789 | 911789 | 2021-01-09 | Montgomery | Kentucky | 21173 | 1601 | 12 |
908544 | 908544 | 2021-01-08 | Montgomery | Kentucky | 21173 | 1569 | 12 |
905298 | 905298 | 2021-01-07 | Montgomery | Kentucky | 21173 | 1525 | 12 |
902053 | 902053 | 2021-01-06 | Montgomery | Kentucky | 21173 | 1489 | 12 |
898808 | 898808 | 2021-01-05 | Montgomery | Kentucky | 21173 | 1472 | 12 |
895563 | 895563 | 2021-01-04 | Montgomery | Kentucky | 21173 | 1467 | 12 |
892316 | 892316 | 2021-01-03 | Montgomery | Kentucky | 21173 | 1459 | 12 |
889070 | 889070 | 2021-01-02 | Montgomery | Kentucky | 21173 | 1439 | 12 |
885824 | 885824 | 2021-01-01 | Montgomery | Kentucky | 21173 | 1378 | 12 |
882579 | 882579 | 2020-12-31 | Montgomery | Kentucky | 21173 | 1378 | 12 |
879334 | 879334 | 2020-12-30 | Montgomery | Kentucky | 21173 | 1378 | 12 |
876089 | 876089 | 2020-12-29 | Montgomery | Kentucky | 21173 | 1350 | 12 |
872844 | 872844 | 2020-12-28 | Montgomery | Kentucky | 21173 | 1337 | 12 |
869599 | 869599 | 2020-12-27 | Montgomery | Kentucky | 21173 | 1335 | 12 |
866354 | 866354 | 2020-12-26 | Montgomery | Kentucky | 21173 | 1328 | 12 |
863109 | 863109 | 2020-12-25 | Montgomery | Kentucky | 21173 | 1303 | 12 |
859864 | 859864 | 2020-12-24 | Montgomery | Kentucky | 21173 | 1303 | 12 |
856619 | 856619 | 2020-12-23 | Montgomery | Kentucky | 21173 | 1303 | 12 |
853374 | 853374 | 2020-12-22 | Montgomery | Kentucky | 21173 | 1295 | 12 |
850129 | 850129 | 2020-12-21 | Montgomery | Kentucky | 21173 | 1281 | 12 |
846884 | 846884 | 2020-12-20 | Montgomery | Kentucky | 21173 | 1274 | 12 |
843638 | 843638 | 2020-12-19 | Montgomery | Kentucky | 21173 | 1272 | 12 |
840393 | 840393 | 2020-12-18 | Montgomery | Kentucky | 21173 | 1256 | 12 |
837148 | 837148 | 2020-12-17 | Montgomery | Kentucky | 21173 | 1237 | 12 |
833902 | 833902 | 2020-12-16 | Montgomery | Kentucky | 21173 | 1213 | 12 |
830655 | 830655 | 2020-12-15 | Montgomery | Kentucky | 21173 | 1205 | 12 |
827409 | 827409 | 2020-12-14 | Montgomery | Kentucky | 21173 | 1187 | 12 |
824162 | 824162 | 2020-12-13 | Montgomery | Kentucky | 21173 | 1185 | 12 |
820916 | 820916 | 2020-12-12 | Montgomery | Kentucky | 21173 | 1182 | 12 |
817670 | 817670 | 2020-12-11 | Montgomery | Kentucky | 21173 | 1168 | 12 |
814424 | 814424 | 2020-12-10 | Montgomery | Kentucky | 21173 | 1138 | 12 |
811179 | 811179 | 2020-12-09 | Montgomery | Kentucky | 21173 | 1115 | 11 |
807934 | 807934 | 2020-12-08 | Montgomery | Kentucky | 21173 | 1100 | 11 |
804689 | 804689 | 2020-12-07 | Montgomery | Kentucky | 21173 | 1063 | 11 |
801444 | 801444 | 2020-12-06 | Montgomery | Kentucky | 21173 | 1058 | 11 |
798199 | 798199 | 2020-12-05 | Montgomery | Kentucky | 21173 | 1049 | 11 |
794954 | 794954 | 2020-12-04 | Montgomery | Kentucky | 21173 | 1018 | 11 |
791709 | 791709 | 2020-12-03 | Montgomery | Kentucky | 21173 | 1005 | 11 |
788464 | 788464 | 2020-12-02 | Montgomery | Kentucky | 21173 | 985 | 10 |
785220 | 785220 | 2020-12-01 | Montgomery | Kentucky | 21173 | 961 | 10 |
781975 | 781975 | 2020-11-30 | Montgomery | Kentucky | 21173 | 911 | 9 |
778729 | 778729 | 2020-11-29 | Montgomery | Kentucky | 21173 | 898 | 9 |
775484 | 775484 | 2020-11-28 | Montgomery | Kentucky | 21173 | 887 | 9 |
772239 | 772239 | 2020-11-27 | Montgomery | Kentucky | 21173 | 880 | 9 |
768994 | 768994 | 2020-11-26 | Montgomery | Kentucky | 21173 | 871 | 8 |
765748 | 765748 | 2020-11-25 | Montgomery | Kentucky | 21173 | 871 | 8 |
762503 | 762503 | 2020-11-24 | Montgomery | Kentucky | 21173 | 871 | 8 |
759258 | 759258 | 2020-11-23 | Montgomery | Kentucky | 21173 | 839 | 8 |
756011 | 756011 | 2020-11-22 | Montgomery | Kentucky | 21173 | 817 | 8 |
752765 | 752765 | 2020-11-21 | Montgomery | Kentucky | 21173 | 805 | 8 |
749519 | 749519 | 2020-11-20 | Montgomery | Kentucky | 21173 | 789 | 8 |
746273 | 746273 | 2020-11-19 | Montgomery | Kentucky | 21173 | 776 | 8 |
743026 | 743026 | 2020-11-18 | Montgomery | Kentucky | 21173 | 747 | 8 |
739779 | 739779 | 2020-11-17 | Montgomery | Kentucky | 21173 | 732 | 8 |
736535 | 736535 | 2020-11-16 | Montgomery | Kentucky | 21173 | 724 | 8 |
733289 | 733289 | 2020-11-15 | Montgomery | Kentucky | 21173 | 722 | 8 |
730044 | 730044 | 2020-11-14 | Montgomery | Kentucky | 21173 | 721 | 8 |
726801 | 726801 | 2020-11-13 | Montgomery | Kentucky | 21173 | 706 | 8 |
723558 | 723558 | 2020-11-12 | Montgomery | Kentucky | 21173 | 704 | 8 |
720315 | 720315 | 2020-11-11 | Montgomery | Kentucky | 21173 | 694 | 8 |
717072 | 717072 | 2020-11-10 | Montgomery | Kentucky | 21173 | 688 | 7 |
713828 | 713828 | 2020-11-09 | Montgomery | Kentucky | 21173 | 674 | 7 |
710584 | 710584 | 2020-11-08 | Montgomery | Kentucky | 21173 | 667 | 7 |
707340 | 707340 | 2020-11-07 | Montgomery | Kentucky | 21173 | 666 | 7 |
704097 | 704097 | 2020-11-06 | Montgomery | Kentucky | 21173 | 655 | 7 |
700855 | 700855 | 2020-11-05 | Montgomery | Kentucky | 21173 | 644 | 7 |
697611 | 697611 | 2020-11-04 | Montgomery | Kentucky | 21173 | 617 | 7 |
694368 | 694368 | 2020-11-03 | Montgomery | Kentucky | 21173 | 595 | 7 |
691126 | 691126 | 2020-11-02 | Montgomery | Kentucky | 21173 | 577 | 6 |
687881 | 687881 | 2020-11-01 | Montgomery | Kentucky | 21173 | 571 | 6 |
684637 | 684637 | 2020-10-31 | Montgomery | Kentucky | 21173 | 562 | 6 |
681394 | 681394 | 2020-10-30 | Montgomery | Kentucky | 21173 | 551 | 5 |
678150 | 678150 | 2020-10-29 | Montgomery | Kentucky | 21173 | 525 | 4 |
674908 | 674908 | 2020-10-28 | Montgomery | Kentucky | 21173 | 498 | 4 |
671665 | 671665 | 2020-10-27 | Montgomery | Kentucky | 21173 | 470 | 4 |
668423 | 668423 | 2020-10-26 | Montgomery | Kentucky | 21173 | 456 | 4 |
665179 | 665179 | 2020-10-25 | Montgomery | Kentucky | 21173 | 455 | 4 |
661934 | 661934 | 2020-10-24 | Montgomery | Kentucky | 21173 | 425 | 4 |
658690 | 658690 | 2020-10-23 | Montgomery | Kentucky | 21173 | 414 | 4 |
655445 | 655445 | 2020-10-22 | Montgomery | Kentucky | 21173 | 397 | 4 |
652200 | 652200 | 2020-10-21 | Montgomery | Kentucky | 21173 | 389 | 4 |
648955 | 648955 | 2020-10-20 | Montgomery | Kentucky | 21173 | 385 | 4 |
645711 | 645711 | 2020-10-19 | Montgomery | Kentucky | 21173 | 375 | 4 |
642464 | 642464 | 2020-10-18 | Montgomery | Kentucky | 21173 | 374 | 4 |
639217 | 639217 | 2020-10-17 | Montgomery | Kentucky | 21173 | 371 | 4 |
635971 | 635971 | 2020-10-16 | Montgomery | Kentucky | 21173 | 364 | 4 |
632725 | 632725 | 2020-10-15 | Montgomery | Kentucky | 21173 | 359 | 4 |
629481 | 629481 | 2020-10-14 | Montgomery | Kentucky | 21173 | 349 | 4 |
626237 | 626237 | 2020-10-13 | Montgomery | Kentucky | 21173 | 343 | 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);