ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 21151 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054579 | 1054579 | 2021-02-22 | Madison | Kentucky | 21151 | 8510 | 79 |
1051332 | 1051332 | 2021-02-21 | Madison | Kentucky | 21151 | 8501 | 79 |
1048085 | 1048085 | 2021-02-20 | Madison | Kentucky | 21151 | 8486 | 79 |
1044840 | 1044840 | 2021-02-19 | Madison | Kentucky | 21151 | 8473 | 79 |
1041595 | 1041595 | 2021-02-18 | Madison | Kentucky | 21151 | 8418 | 79 |
1038350 | 1038350 | 2021-02-17 | Madison | Kentucky | 21151 | 8395 | 79 |
1035105 | 1035105 | 2021-02-16 | Madison | Kentucky | 21151 | 8363 | 78 |
1031859 | 1031859 | 2021-02-15 | Madison | Kentucky | 21151 | 8342 | 77 |
1028612 | 1028612 | 2021-02-14 | Madison | Kentucky | 21151 | 8306 | 77 |
1025367 | 1025367 | 2021-02-13 | Madison | Kentucky | 21151 | 8290 | 77 |
1022122 | 1022122 | 2021-02-12 | Madison | Kentucky | 21151 | 8278 | 77 |
1018877 | 1018877 | 2021-02-11 | Madison | Kentucky | 21151 | 8234 | 73 |
1015632 | 1015632 | 2021-02-10 | Madison | Kentucky | 21151 | 8205 | 66 |
1012387 | 1012387 | 2021-02-09 | Madison | Kentucky | 21151 | 8145 | 65 |
1009141 | 1009141 | 2021-02-08 | Madison | Kentucky | 21151 | 8063 | 65 |
1005895 | 1005895 | 2021-02-07 | Madison | Kentucky | 21151 | 8036 | 65 |
1002649 | 1002649 | 2021-02-06 | Madison | Kentucky | 21151 | 8003 | 63 |
999403 | 999403 | 2021-02-05 | Madison | Kentucky | 21151 | 7972 | 57 |
996157 | 996157 | 2021-02-04 | Madison | Kentucky | 21151 | 7942 | 57 |
992911 | 992911 | 2021-02-03 | Madison | Kentucky | 21151 | 7831 | 57 |
989665 | 989665 | 2021-02-02 | Madison | Kentucky | 21151 | 7774 | 57 |
986418 | 986418 | 2021-02-01 | Madison | Kentucky | 21151 | 7696 | 57 |
983171 | 983171 | 2021-01-31 | Madison | Kentucky | 21151 | 7585 | 56 |
979925 | 979925 | 2021-01-30 | Madison | Kentucky | 21151 | 7536 | 56 |
976679 | 976679 | 2021-01-29 | Madison | Kentucky | 21151 | 7494 | 53 |
973434 | 973434 | 2021-01-28 | Madison | Kentucky | 21151 | 7480 | 50 |
970189 | 970189 | 2021-01-27 | Madison | Kentucky | 21151 | 7418 | 49 |
966945 | 966945 | 2021-01-26 | Madison | Kentucky | 21151 | 7349 | 49 |
963700 | 963700 | 2021-01-25 | Madison | Kentucky | 21151 | 7285 | 49 |
960455 | 960455 | 2021-01-24 | Madison | Kentucky | 21151 | 7254 | 47 |
957209 | 957209 | 2021-01-23 | Madison | Kentucky | 21151 | 7224 | 47 |
953964 | 953964 | 2021-01-22 | Madison | Kentucky | 21151 | 7183 | 48 |
950719 | 950719 | 2021-01-21 | Madison | Kentucky | 21151 | 7142 | 48 |
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 |
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);