ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 21035 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1090225 | 1090225 | 2021-03-05 | Calloway | Kentucky | 21035 | 3405 | 38 |
1086980 | 1086980 | 2021-03-04 | Calloway | Kentucky | 21035 | 3399 | 38 |
1083734 | 1083734 | 2021-03-03 | Calloway | Kentucky | 21035 | 3397 | 38 |
1080488 | 1080488 | 2021-03-02 | Calloway | Kentucky | 21035 | 3396 | 38 |
1077243 | 1077243 | 2021-03-01 | Calloway | Kentucky | 21035 | 3378 | 38 |
1073997 | 1073997 | 2021-02-28 | Calloway | Kentucky | 21035 | 3377 | 38 |
1070751 | 1070751 | 2021-02-27 | Calloway | Kentucky | 21035 | 3368 | 38 |
1067506 | 1067506 | 2021-02-26 | Calloway | Kentucky | 21035 | 3357 | 38 |
1064261 | 1064261 | 2021-02-25 | Calloway | Kentucky | 21035 | 3355 | 38 |
1061016 | 1061016 | 2021-02-24 | Calloway | Kentucky | 21035 | 3356 | 38 |
1057770 | 1057770 | 2021-02-23 | Calloway | Kentucky | 21035 | 3351 | 38 |
1054524 | 1054524 | 2021-02-22 | Calloway | Kentucky | 21035 | 3350 | 38 |
1051277 | 1051277 | 2021-02-21 | Calloway | Kentucky | 21035 | 3348 | 38 |
1048030 | 1048030 | 2021-02-20 | Calloway | Kentucky | 21035 | 3345 | 38 |
1044785 | 1044785 | 2021-02-19 | Calloway | Kentucky | 21035 | 3335 | 38 |
1041540 | 1041540 | 2021-02-18 | Calloway | Kentucky | 21035 | 3332 | 38 |
1038295 | 1038295 | 2021-02-17 | Calloway | Kentucky | 21035 | 3331 | 38 |
1035050 | 1035050 | 2021-02-16 | Calloway | Kentucky | 21035 | 3329 | 38 |
1031804 | 1031804 | 2021-02-15 | Calloway | Kentucky | 21035 | 3328 | 38 |
1028557 | 1028557 | 2021-02-14 | Calloway | Kentucky | 21035 | 3328 | 38 |
1025312 | 1025312 | 2021-02-13 | Calloway | Kentucky | 21035 | 3324 | 38 |
1022067 | 1022067 | 2021-02-12 | Calloway | Kentucky | 21035 | 3321 | 38 |
1018822 | 1018822 | 2021-02-11 | Calloway | Kentucky | 21035 | 3320 | 38 |
1015577 | 1015577 | 2021-02-10 | Calloway | Kentucky | 21035 | 3314 | 36 |
1012332 | 1012332 | 2021-02-09 | Calloway | Kentucky | 21035 | 3309 | 36 |
1009086 | 1009086 | 2021-02-08 | Calloway | Kentucky | 21035 | 3303 | 36 |
1005840 | 1005840 | 2021-02-07 | Calloway | Kentucky | 21035 | 3289 | 36 |
1002594 | 1002594 | 2021-02-06 | Calloway | Kentucky | 21035 | 3286 | 36 |
999348 | 999348 | 2021-02-05 | Calloway | Kentucky | 21035 | 3281 | 36 |
996102 | 996102 | 2021-02-04 | Calloway | Kentucky | 21035 | 3271 | 36 |
992856 | 992856 | 2021-02-03 | Calloway | Kentucky | 21035 | 3261 | 36 |
989610 | 989610 | 2021-02-02 | Calloway | Kentucky | 21035 | 3245 | 34 |
986363 | 986363 | 2021-02-01 | Calloway | Kentucky | 21035 | 3232 | 34 |
983116 | 983116 | 2021-01-31 | Calloway | Kentucky | 21035 | 3220 | 33 |
979870 | 979870 | 2021-01-30 | Calloway | Kentucky | 21035 | 3177 | 32 |
976624 | 976624 | 2021-01-29 | Calloway | Kentucky | 21035 | 3161 | 32 |
973379 | 973379 | 2021-01-28 | Calloway | Kentucky | 21035 | 3152 | 32 |
970134 | 970134 | 2021-01-27 | Calloway | Kentucky | 21035 | 3113 | 32 |
966890 | 966890 | 2021-01-26 | Calloway | Kentucky | 21035 | 3075 | 32 |
963645 | 963645 | 2021-01-25 | Calloway | Kentucky | 21035 | 3071 | 32 |
960400 | 960400 | 2021-01-24 | Calloway | Kentucky | 21035 | 3018 | 31 |
957154 | 957154 | 2021-01-23 | Calloway | Kentucky | 21035 | 3005 | 31 |
953909 | 953909 | 2021-01-22 | Calloway | Kentucky | 21035 | 2996 | 31 |
950664 | 950664 | 2021-01-21 | Calloway | Kentucky | 21035 | 2974 | 31 |
947418 | 947418 | 2021-01-20 | Calloway | Kentucky | 21035 | 2941 | 31 |
944171 | 944171 | 2021-01-19 | Calloway | Kentucky | 21035 | 2911 | 30 |
940926 | 940926 | 2021-01-18 | Calloway | Kentucky | 21035 | 2863 | 30 |
937681 | 937681 | 2021-01-17 | Calloway | Kentucky | 21035 | 2851 | 30 |
934436 | 934436 | 2021-01-16 | Calloway | Kentucky | 21035 | 2816 | 29 |
931191 | 931191 | 2021-01-15 | Calloway | Kentucky | 21035 | 2799 | 29 |
927946 | 927946 | 2021-01-14 | Calloway | Kentucky | 21035 | 2773 | 29 |
924700 | 924700 | 2021-01-13 | Calloway | Kentucky | 21035 | 2723 | 29 |
921455 | 921455 | 2021-01-12 | Calloway | Kentucky | 21035 | 2682 | 29 |
918210 | 918210 | 2021-01-11 | Calloway | Kentucky | 21035 | 2654 | 29 |
914965 | 914965 | 2021-01-10 | Calloway | Kentucky | 21035 | 2644 | 29 |
911720 | 911720 | 2021-01-09 | Calloway | Kentucky | 21035 | 2609 | 29 |
908475 | 908475 | 2021-01-08 | Calloway | Kentucky | 21035 | 2581 | 27 |
905229 | 905229 | 2021-01-07 | Calloway | Kentucky | 21035 | 2550 | 27 |
901984 | 901984 | 2021-01-06 | Calloway | Kentucky | 21035 | 2479 | 27 |
898739 | 898739 | 2021-01-05 | Calloway | Kentucky | 21035 | 2465 | 25 |
895494 | 895494 | 2021-01-04 | Calloway | Kentucky | 21035 | 2438 | 25 |
892247 | 892247 | 2021-01-03 | Calloway | Kentucky | 21035 | 2436 | 25 |
889001 | 889001 | 2021-01-02 | Calloway | Kentucky | 21035 | 2400 | 25 |
885755 | 885755 | 2021-01-01 | Calloway | Kentucky | 21035 | 2344 | 25 |
882510 | 882510 | 2020-12-31 | Calloway | Kentucky | 21035 | 2344 | 25 |
879265 | 879265 | 2020-12-30 | Calloway | Kentucky | 21035 | 2344 | 25 |
876020 | 876020 | 2020-12-29 | Calloway | Kentucky | 21035 | 2319 | 25 |
872775 | 872775 | 2020-12-28 | Calloway | Kentucky | 21035 | 2316 | 25 |
869530 | 869530 | 2020-12-27 | Calloway | Kentucky | 21035 | 2296 | 25 |
866285 | 866285 | 2020-12-26 | Calloway | Kentucky | 21035 | 2257 | 23 |
863040 | 863040 | 2020-12-25 | Calloway | Kentucky | 21035 | 2217 | 23 |
859795 | 859795 | 2020-12-24 | Calloway | Kentucky | 21035 | 2217 | 23 |
856550 | 856550 | 2020-12-23 | Calloway | Kentucky | 21035 | 2217 | 23 |
853305 | 853305 | 2020-12-22 | Calloway | Kentucky | 21035 | 2194 | 23 |
850060 | 850060 | 2020-12-21 | Calloway | Kentucky | 21035 | 2177 | 20 |
846815 | 846815 | 2020-12-20 | Calloway | Kentucky | 21035 | 2160 | 20 |
843569 | 843569 | 2020-12-19 | Calloway | Kentucky | 21035 | 2140 | 19 |
840324 | 840324 | 2020-12-18 | Calloway | Kentucky | 21035 | 2111 | 19 |
837079 | 837079 | 2020-12-17 | Calloway | Kentucky | 21035 | 2105 | 19 |
833833 | 833833 | 2020-12-16 | Calloway | Kentucky | 21035 | 2091 | 18 |
830586 | 830586 | 2020-12-15 | Calloway | Kentucky | 21035 | 2079 | 18 |
827340 | 827340 | 2020-12-14 | Calloway | Kentucky | 21035 | 2079 | 18 |
824093 | 824093 | 2020-12-13 | Calloway | Kentucky | 21035 | 2069 | 17 |
820847 | 820847 | 2020-12-12 | Calloway | Kentucky | 21035 | 2052 | 17 |
817601 | 817601 | 2020-12-11 | Calloway | Kentucky | 21035 | 2034 | 17 |
814355 | 814355 | 2020-12-10 | Calloway | Kentucky | 21035 | 2002 | 17 |
811110 | 811110 | 2020-12-09 | Calloway | Kentucky | 21035 | 1961 | 17 |
807865 | 807865 | 2020-12-08 | Calloway | Kentucky | 21035 | 1953 | 17 |
804620 | 804620 | 2020-12-07 | Calloway | Kentucky | 21035 | 1939 | 17 |
801375 | 801375 | 2020-12-06 | Calloway | Kentucky | 21035 | 1929 | 17 |
798130 | 798130 | 2020-12-05 | Calloway | Kentucky | 21035 | 1911 | 17 |
794885 | 794885 | 2020-12-04 | Calloway | Kentucky | 21035 | 1876 | 17 |
791640 | 791640 | 2020-12-03 | Calloway | Kentucky | 21035 | 1848 | 17 |
788395 | 788395 | 2020-12-02 | Calloway | Kentucky | 21035 | 1803 | 17 |
785151 | 785151 | 2020-12-01 | Calloway | Kentucky | 21035 | 1776 | 17 |
781906 | 781906 | 2020-11-30 | Calloway | Kentucky | 21035 | 1758 | 16 |
778660 | 778660 | 2020-11-29 | Calloway | Kentucky | 21035 | 1742 | 16 |
775415 | 775415 | 2020-11-28 | Calloway | Kentucky | 21035 | 1721 | 16 |
772170 | 772170 | 2020-11-27 | Calloway | Kentucky | 21035 | 1706 | 16 |
768925 | 768925 | 2020-11-26 | Calloway | Kentucky | 21035 | 1615 | 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);