ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 21101 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921488 | 921488 | 2021-01-12 | Henderson | Kentucky | 21101 | 3439 | 52 |
918243 | 918243 | 2021-01-11 | Henderson | Kentucky | 21101 | 3401 | 52 |
914998 | 914998 | 2021-01-10 | Henderson | Kentucky | 21101 | 3343 | 52 |
911753 | 911753 | 2021-01-09 | Henderson | Kentucky | 21101 | 3319 | 52 |
908508 | 908508 | 2021-01-08 | Henderson | Kentucky | 21101 | 3223 | 52 |
905262 | 905262 | 2021-01-07 | Henderson | Kentucky | 21101 | 3181 | 51 |
902017 | 902017 | 2021-01-06 | Henderson | Kentucky | 21101 | 3153 | 51 |
898772 | 898772 | 2021-01-05 | Henderson | Kentucky | 21101 | 3096 | 50 |
895527 | 895527 | 2021-01-04 | Henderson | Kentucky | 21101 | 3086 | 50 |
892280 | 892280 | 2021-01-03 | Henderson | Kentucky | 21101 | 3026 | 49 |
889034 | 889034 | 2021-01-02 | Henderson | Kentucky | 21101 | 2984 | 49 |
885788 | 885788 | 2021-01-01 | Henderson | Kentucky | 21101 | 2939 | 49 |
882543 | 882543 | 2020-12-31 | Henderson | Kentucky | 21101 | 2939 | 49 |
879298 | 879298 | 2020-12-30 | Henderson | Kentucky | 21101 | 2939 | 48 |
876053 | 876053 | 2020-12-29 | Henderson | Kentucky | 21101 | 2914 | 48 |
872808 | 872808 | 2020-12-28 | Henderson | Kentucky | 21101 | 2899 | 48 |
869563 | 869563 | 2020-12-27 | Henderson | Kentucky | 21101 | 2860 | 48 |
866318 | 866318 | 2020-12-26 | Henderson | Kentucky | 21101 | 2796 | 48 |
863073 | 863073 | 2020-12-25 | Henderson | Kentucky | 21101 | 2765 | 48 |
859828 | 859828 | 2020-12-24 | Henderson | Kentucky | 21101 | 2765 | 48 |
856583 | 856583 | 2020-12-23 | Henderson | Kentucky | 21101 | 2765 | 48 |
853338 | 853338 | 2020-12-22 | Henderson | Kentucky | 21101 | 2734 | 47 |
850093 | 850093 | 2020-12-21 | Henderson | Kentucky | 21101 | 2689 | 47 |
846848 | 846848 | 2020-12-20 | Henderson | Kentucky | 21101 | 2669 | 47 |
843602 | 843602 | 2020-12-19 | Henderson | Kentucky | 21101 | 2654 | 47 |
840357 | 840357 | 2020-12-18 | Henderson | Kentucky | 21101 | 2613 | 47 |
837112 | 837112 | 2020-12-17 | Henderson | Kentucky | 21101 | 2568 | 47 |
833866 | 833866 | 2020-12-16 | Henderson | Kentucky | 21101 | 2538 | 47 |
830619 | 830619 | 2020-12-15 | Henderson | Kentucky | 21101 | 2527 | 47 |
827373 | 827373 | 2020-12-14 | Henderson | Kentucky | 21101 | 2494 | 47 |
824126 | 824126 | 2020-12-13 | Henderson | Kentucky | 21101 | 2491 | 47 |
820880 | 820880 | 2020-12-12 | Henderson | Kentucky | 21101 | 2472 | 47 |
817634 | 817634 | 2020-12-11 | Henderson | Kentucky | 21101 | 2442 | 43 |
814388 | 814388 | 2020-12-10 | Henderson | Kentucky | 21101 | 2416 | 43 |
811143 | 811143 | 2020-12-09 | Henderson | Kentucky | 21101 | 2383 | 43 |
807898 | 807898 | 2020-12-08 | Henderson | Kentucky | 21101 | 2360 | 42 |
804653 | 804653 | 2020-12-07 | Henderson | Kentucky | 21101 | 2345 | 42 |
801408 | 801408 | 2020-12-06 | Henderson | Kentucky | 21101 | 2319 | 41 |
798163 | 798163 | 2020-12-05 | Henderson | Kentucky | 21101 | 2277 | 41 |
794918 | 794918 | 2020-12-04 | Henderson | Kentucky | 21101 | 2242 | 41 |
791673 | 791673 | 2020-12-03 | Henderson | Kentucky | 21101 | 2197 | 41 |
788428 | 788428 | 2020-12-02 | Henderson | Kentucky | 21101 | 2167 | 41 |
785184 | 785184 | 2020-12-01 | Henderson | Kentucky | 21101 | 2127 | 40 |
781939 | 781939 | 2020-11-30 | Henderson | Kentucky | 21101 | 2098 | 39 |
778693 | 778693 | 2020-11-29 | Henderson | Kentucky | 21101 | 2067 | 39 |
775448 | 775448 | 2020-11-28 | Henderson | Kentucky | 21101 | 2007 | 39 |
772203 | 772203 | 2020-11-27 | Henderson | Kentucky | 21101 | 2006 | 39 |
768958 | 768958 | 2020-11-26 | Henderson | Kentucky | 21101 | 1952 | 39 |
765712 | 765712 | 2020-11-25 | Henderson | Kentucky | 21101 | 1952 | 39 |
762467 | 762467 | 2020-11-24 | Henderson | Kentucky | 21101 | 1923 | 36 |
759222 | 759222 | 2020-11-23 | Henderson | Kentucky | 21101 | 1891 | 36 |
755975 | 755975 | 2020-11-22 | Henderson | Kentucky | 21101 | 1872 | 36 |
752729 | 752729 | 2020-11-21 | Henderson | Kentucky | 21101 | 1864 | 37 |
749483 | 749483 | 2020-11-20 | Henderson | Kentucky | 21101 | 1829 | 37 |
746237 | 746237 | 2020-11-19 | Henderson | Kentucky | 21101 | 1806 | 37 |
742990 | 742990 | 2020-11-18 | Henderson | Kentucky | 21101 | 1782 | 37 |
739743 | 739743 | 2020-11-17 | Henderson | Kentucky | 21101 | 1735 | 37 |
736499 | 736499 | 2020-11-16 | Henderson | Kentucky | 21101 | 1713 | 36 |
733253 | 733253 | 2020-11-15 | Henderson | Kentucky | 21101 | 1709 | 36 |
730008 | 730008 | 2020-11-14 | Henderson | Kentucky | 21101 | 1699 | 36 |
726765 | 726765 | 2020-11-13 | Henderson | Kentucky | 21101 | 1678 | 36 |
723522 | 723522 | 2020-11-12 | Henderson | Kentucky | 21101 | 1640 | 36 |
720279 | 720279 | 2020-11-11 | Henderson | Kentucky | 21101 | 1617 | 36 |
717036 | 717036 | 2020-11-10 | Henderson | Kentucky | 21101 | 1588 | 36 |
713792 | 713792 | 2020-11-09 | Henderson | Kentucky | 21101 | 1550 | 36 |
710548 | 710548 | 2020-11-08 | Henderson | Kentucky | 21101 | 1542 | 36 |
707304 | 707304 | 2020-11-07 | Henderson | Kentucky | 21101 | 1529 | 36 |
704061 | 704061 | 2020-11-06 | Henderson | Kentucky | 21101 | 1500 | 36 |
700819 | 700819 | 2020-11-05 | Henderson | Kentucky | 21101 | 1477 | 36 |
697575 | 697575 | 2020-11-04 | Henderson | Kentucky | 21101 | 1456 | 36 |
694332 | 694332 | 2020-11-03 | Henderson | Kentucky | 21101 | 1431 | 36 |
691090 | 691090 | 2020-11-02 | Henderson | Kentucky | 21101 | 1409 | 36 |
687845 | 687845 | 2020-11-01 | Henderson | Kentucky | 21101 | 1405 | 36 |
684601 | 684601 | 2020-10-31 | Henderson | Kentucky | 21101 | 1379 | 36 |
681358 | 681358 | 2020-10-30 | Henderson | Kentucky | 21101 | 1364 | 36 |
678114 | 678114 | 2020-10-29 | Henderson | Kentucky | 21101 | 1343 | 34 |
674872 | 674872 | 2020-10-28 | Henderson | Kentucky | 21101 | 1327 | 34 |
671629 | 671629 | 2020-10-27 | Henderson | Kentucky | 21101 | 1307 | 31 |
668387 | 668387 | 2020-10-26 | Henderson | Kentucky | 21101 | 1295 | 31 |
665143 | 665143 | 2020-10-25 | Henderson | Kentucky | 21101 | 1293 | 31 |
661898 | 661898 | 2020-10-24 | Henderson | Kentucky | 21101 | 1280 | 30 |
658654 | 658654 | 2020-10-23 | Henderson | Kentucky | 21101 | 1265 | 30 |
655409 | 655409 | 2020-10-22 | Henderson | Kentucky | 21101 | 1248 | 29 |
652164 | 652164 | 2020-10-21 | Henderson | Kentucky | 21101 | 1229 | 28 |
648919 | 648919 | 2020-10-20 | Henderson | Kentucky | 21101 | 1222 | 24 |
645675 | 645675 | 2020-10-19 | Henderson | Kentucky | 21101 | 1207 | 24 |
642428 | 642428 | 2020-10-18 | Henderson | Kentucky | 21101 | 1192 | 24 |
639181 | 639181 | 2020-10-17 | Henderson | Kentucky | 21101 | 1187 | 22 |
635935 | 635935 | 2020-10-16 | Henderson | Kentucky | 21101 | 1171 | 22 |
632689 | 632689 | 2020-10-15 | Henderson | Kentucky | 21101 | 1143 | 22 |
629445 | 629445 | 2020-10-14 | Henderson | Kentucky | 21101 | 1126 | 22 |
626201 | 626201 | 2020-10-13 | Henderson | Kentucky | 21101 | 1100 | 21 |
622959 | 622959 | 2020-10-12 | Henderson | Kentucky | 21101 | 1089 | 15 |
619715 | 619715 | 2020-10-11 | Henderson | Kentucky | 21101 | 1073 | 15 |
616473 | 616473 | 2020-10-10 | Henderson | Kentucky | 21101 | 1061 | 15 |
613232 | 613232 | 2020-10-09 | Henderson | Kentucky | 21101 | 1022 | 14 |
609990 | 609990 | 2020-10-08 | Henderson | Kentucky | 21101 | 1005 | 11 |
606748 | 606748 | 2020-10-07 | Henderson | Kentucky | 21101 | 974 | 11 |
603506 | 603506 | 2020-10-06 | Henderson | Kentucky | 21101 | 954 | 10 |
600263 | 600263 | 2020-10-05 | Henderson | Kentucky | 21101 | 932 | 5 |
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);