ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Madison" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947473 | 947473 | 2021-01-20 | Madison | Kentucky | 21151 | 7030 | 48 |
944226 | 944226 | 2021-01-19 | Madison | Kentucky | 21151 | 6930 | 46 |
940981 | 940981 | 2021-01-18 | Madison | Kentucky | 21151 | 6883 | 45 |
937736 | 937736 | 2021-01-17 | Madison | Kentucky | 21151 | 6819 | 45 |
934491 | 934491 | 2021-01-16 | Madison | Kentucky | 21151 | 6786 | 45 |
931246 | 931246 | 2021-01-15 | Madison | Kentucky | 21151 | 6743 | 43 |
928001 | 928001 | 2021-01-14 | Madison | Kentucky | 21151 | 6674 | 43 |
924755 | 924755 | 2021-01-13 | Madison | Kentucky | 21151 | 6594 | 43 |
921510 | 921510 | 2021-01-12 | Madison | Kentucky | 21151 | 6531 | 42 |
918265 | 918265 | 2021-01-11 | Madison | Kentucky | 21151 | 6385 | 40 |
915020 | 915020 | 2021-01-10 | Madison | Kentucky | 21151 | 6320 | 42 |
911775 | 911775 | 2021-01-09 | Madison | Kentucky | 21151 | 6246 | 40 |
908530 | 908530 | 2021-01-08 | Madison | Kentucky | 21151 | 6197 | 39 |
905284 | 905284 | 2021-01-07 | Madison | Kentucky | 21151 | 6124 | 38 |
902039 | 902039 | 2021-01-06 | Madison | Kentucky | 21151 | 6037 | 38 |
898794 | 898794 | 2021-01-05 | Madison | Kentucky | 21151 | 5927 | 39 |
895549 | 895549 | 2021-01-04 | Madison | Kentucky | 21151 | 5901 | 39 |
892302 | 892302 | 2021-01-03 | Madison | Kentucky | 21151 | 5861 | 39 |
889056 | 889056 | 2021-01-02 | Madison | Kentucky | 21151 | 5830 | 39 |
885810 | 885810 | 2021-01-01 | Madison | Kentucky | 21151 | 5706 | 35 |
882565 | 882565 | 2020-12-31 | Madison | Kentucky | 21151 | 5706 | 35 |
879320 | 879320 | 2020-12-30 | Madison | Kentucky | 21151 | 5706 | 35 |
876075 | 876075 | 2020-12-29 | Madison | Kentucky | 21151 | 5673 | 36 |
872830 | 872830 | 2020-12-28 | Madison | Kentucky | 21151 | 5638 | 36 |
869585 | 869585 | 2020-12-27 | Madison | Kentucky | 21151 | 5612 | 34 |
866340 | 866340 | 2020-12-26 | Madison | Kentucky | 21151 | 5597 | 30 |
863095 | 863095 | 2020-12-25 | Madison | Kentucky | 21151 | 5505 | 27 |
859850 | 859850 | 2020-12-24 | Madison | Kentucky | 21151 | 5505 | 27 |
856605 | 856605 | 2020-12-23 | Madison | Kentucky | 21151 | 5505 | 27 |
853360 | 853360 | 2020-12-22 | Madison | Kentucky | 21151 | 5459 | 26 |
850115 | 850115 | 2020-12-21 | Madison | Kentucky | 21151 | 5330 | 26 |
846870 | 846870 | 2020-12-20 | Madison | Kentucky | 21151 | 5290 | 26 |
843624 | 843624 | 2020-12-19 | Madison | Kentucky | 21151 | 5275 | 26 |
840379 | 840379 | 2020-12-18 | Madison | Kentucky | 21151 | 5238 | 26 |
837134 | 837134 | 2020-12-17 | Madison | Kentucky | 21151 | 5206 | 25 |
833888 | 833888 | 2020-12-16 | Madison | Kentucky | 21151 | 5125 | 19 |
830641 | 830641 | 2020-12-15 | Madison | Kentucky | 21151 | 5007 | 20 |
827395 | 827395 | 2020-12-14 | Madison | Kentucky | 21151 | 4882 | 20 |
824148 | 824148 | 2020-12-13 | Madison | Kentucky | 21151 | 4843 | 20 |
820902 | 820902 | 2020-12-12 | Madison | Kentucky | 21151 | 4821 | 20 |
817656 | 817656 | 2020-12-11 | Madison | Kentucky | 21151 | 4767 | 20 |
814410 | 814410 | 2020-12-10 | Madison | Kentucky | 21151 | 4714 | 21 |
811165 | 811165 | 2020-12-09 | Madison | Kentucky | 21151 | 4634 | 20 |
807920 | 807920 | 2020-12-08 | Madison | Kentucky | 21151 | 4527 | 21 |
804675 | 804675 | 2020-12-07 | Madison | Kentucky | 21151 | 4426 | 21 |
801430 | 801430 | 2020-12-06 | Madison | Kentucky | 21151 | 4394 | 20 |
798185 | 798185 | 2020-12-05 | Madison | Kentucky | 21151 | 4326 | 20 |
794940 | 794940 | 2020-12-04 | Madison | Kentucky | 21151 | 4267 | 21 |
791695 | 791695 | 2020-12-03 | Madison | Kentucky | 21151 | 4200 | 19 |
788450 | 788450 | 2020-12-02 | Madison | Kentucky | 21151 | 4120 | 18 |
785206 | 785206 | 2020-12-01 | Madison | Kentucky | 21151 | 4024 | 18 |
781961 | 781961 | 2020-11-30 | Madison | Kentucky | 21151 | 3923 | 19 |
778715 | 778715 | 2020-11-29 | Madison | Kentucky | 21151 | 3899 | 19 |
775470 | 775470 | 2020-11-28 | Madison | Kentucky | 21151 | 3872 | 19 |
772225 | 772225 | 2020-11-27 | Madison | Kentucky | 21151 | 3789 | 18 |
768980 | 768980 | 2020-11-26 | Madison | Kentucky | 21151 | 3674 | 18 |
765734 | 765734 | 2020-11-25 | Madison | Kentucky | 21151 | 3674 | 18 |
762489 | 762489 | 2020-11-24 | Madison | Kentucky | 21151 | 3580 | 18 |
759244 | 759244 | 2020-11-23 | Madison | Kentucky | 21151 | 3497 | 18 |
755997 | 755997 | 2020-11-22 | Madison | Kentucky | 21151 | 3382 | 18 |
752751 | 752751 | 2020-11-21 | Madison | Kentucky | 21151 | 3334 | 18 |
749505 | 749505 | 2020-11-20 | Madison | Kentucky | 21151 | 3281 | 16 |
746259 | 746259 | 2020-11-19 | Madison | Kentucky | 21151 | 3226 | 16 |
743012 | 743012 | 2020-11-18 | Madison | Kentucky | 21151 | 3164 | 16 |
739765 | 739765 | 2020-11-17 | Madison | Kentucky | 21151 | 3087 | 16 |
736521 | 736521 | 2020-11-16 | Madison | Kentucky | 21151 | 2931 | 14 |
733275 | 733275 | 2020-11-15 | Madison | Kentucky | 21151 | 2885 | 14 |
730030 | 730030 | 2020-11-14 | Madison | Kentucky | 21151 | 2883 | 14 |
726787 | 726787 | 2020-11-13 | Madison | Kentucky | 21151 | 2821 | 14 |
723544 | 723544 | 2020-11-12 | Madison | Kentucky | 21151 | 2783 | 14 |
720301 | 720301 | 2020-11-11 | Madison | Kentucky | 21151 | 2759 | 14 |
717058 | 717058 | 2020-11-10 | Madison | Kentucky | 21151 | 2722 | 14 |
713814 | 713814 | 2020-11-09 | Madison | Kentucky | 21151 | 2656 | 14 |
710570 | 710570 | 2020-11-08 | Madison | Kentucky | 21151 | 2640 | 14 |
707326 | 707326 | 2020-11-07 | Madison | Kentucky | 21151 | 2627 | 14 |
704083 | 704083 | 2020-11-06 | Madison | Kentucky | 21151 | 2586 | 14 |
700841 | 700841 | 2020-11-05 | Madison | Kentucky | 21151 | 2556 | 14 |
697597 | 697597 | 2020-11-04 | Madison | Kentucky | 21151 | 2513 | 14 |
694354 | 694354 | 2020-11-03 | Madison | Kentucky | 21151 | 2500 | 14 |
691112 | 691112 | 2020-11-02 | Madison | Kentucky | 21151 | 2462 | 14 |
687867 | 687867 | 2020-11-01 | Madison | Kentucky | 21151 | 2451 | 14 |
684623 | 684623 | 2020-10-31 | Madison | Kentucky | 21151 | 2435 | 13 |
681380 | 681380 | 2020-10-30 | Madison | Kentucky | 21151 | 2408 | 13 |
678136 | 678136 | 2020-10-29 | Madison | Kentucky | 21151 | 2391 | 13 |
674894 | 674894 | 2020-10-28 | Madison | Kentucky | 21151 | 2369 | 13 |
671651 | 671651 | 2020-10-27 | Madison | Kentucky | 21151 | 2343 | 13 |
668409 | 668409 | 2020-10-26 | Madison | Kentucky | 21151 | 2303 | 13 |
665165 | 665165 | 2020-10-25 | Madison | Kentucky | 21151 | 2291 | 13 |
661920 | 661920 | 2020-10-24 | Madison | Kentucky | 21151 | 2278 | 13 |
658676 | 658676 | 2020-10-23 | Madison | Kentucky | 21151 | 2268 | 13 |
655431 | 655431 | 2020-10-22 | Madison | Kentucky | 21151 | 2245 | 13 |
652186 | 652186 | 2020-10-21 | Madison | Kentucky | 21151 | 2217 | 13 |
648941 | 648941 | 2020-10-20 | Madison | Kentucky | 21151 | 2186 | 11 |
645697 | 645697 | 2020-10-19 | Madison | Kentucky | 21151 | 2163 | 11 |
642450 | 642450 | 2020-10-18 | Madison | Kentucky | 21151 | 2158 | 11 |
639203 | 639203 | 2020-10-17 | Madison | Kentucky | 21151 | 2145 | 11 |
635957 | 635957 | 2020-10-16 | Madison | Kentucky | 21151 | 2116 | 11 |
632711 | 632711 | 2020-10-15 | Madison | Kentucky | 21151 | 2105 | 9 |
629467 | 629467 | 2020-10-14 | Madison | Kentucky | 21151 | 2091 | 9 |
626223 | 626223 | 2020-10-13 | Madison | Kentucky | 21151 | 2069 | 9 |
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);