ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 47093 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2111706 | 2111706 | 2022-01-13 | Knox | Tennessee | 47093 | 92864 | 1079 |
2108454 | 2108454 | 2022-01-12 | Knox | Tennessee | 47093 | 92864 | 1079 |
2105203 | 2105203 | 2022-01-11 | Knox | Tennessee | 47093 | 90723 | 1076 |
2101952 | 2101952 | 2022-01-10 | Knox | Tennessee | 47093 | 87981 | 1076 |
2098701 | 2098701 | 2022-01-09 | Knox | Tennessee | 47093 | 87981 | 1076 |
2095449 | 2095449 | 2022-01-08 | Knox | Tennessee | 47093 | 87981 | 1076 |
2092197 | 2092197 | 2022-01-07 | Knox | Tennessee | 47093 | 87981 | 1076 |
2088945 | 2088945 | 2022-01-06 | Knox | Tennessee | 47093 | 87981 | 1076 |
2085694 | 2085694 | 2022-01-05 | Knox | Tennessee | 47093 | 87981 | 1076 |
2082442 | 2082442 | 2022-01-04 | Knox | Tennessee | 47093 | 87981 | 1076 |
2079190 | 2079190 | 2022-01-03 | Knox | Tennessee | 47093 | 87277 | 1070 |
2075939 | 2075939 | 2022-01-02 | Knox | Tennessee | 47093 | 85554 | 1065 |
2072688 | 2072688 | 2022-01-01 | Knox | Tennessee | 47093 | 85554 | 1065 |
2069437 | 2069437 | 2021-12-31 | Knox | Tennessee | 47093 | 85554 | 1065 |
2066186 | 2066186 | 2021-12-30 | Knox | Tennessee | 47093 | 85554 | 1065 |
2062936 | 2062936 | 2021-12-29 | Knox | Tennessee | 47093 | 84850 | 1064 |
2059686 | 2059686 | 2021-12-28 | Knox | Tennessee | 47093 | 84498 | 1063 |
2056437 | 2056437 | 2021-12-27 | Knox | Tennessee | 47093 | 84190 | 1061 |
2053188 | 2053188 | 2021-12-26 | Knox | Tennessee | 47093 | 83647 | 1049 |
2049938 | 2049938 | 2021-12-25 | Knox | Tennessee | 47093 | 83647 | 1049 |
2046688 | 2046688 | 2021-12-24 | Knox | Tennessee | 47093 | 83647 | 1049 |
2043438 | 2043438 | 2021-12-23 | Knox | Tennessee | 47093 | 83647 | 1049 |
2040189 | 2040189 | 2021-12-22 | Knox | Tennessee | 47093 | 83465 | 1001 |
2036939 | 2036939 | 2021-12-21 | Knox | Tennessee | 47093 | 83291 | 998 |
2033689 | 2033689 | 2021-12-20 | Knox | Tennessee | 47093 | 83187 | 997 |
2030439 | 2030439 | 2021-12-19 | Knox | Tennessee | 47093 | 82906 | 993 |
2027188 | 2027188 | 2021-12-18 | Knox | Tennessee | 47093 | 82906 | 993 |
2023937 | 2023937 | 2021-12-17 | Knox | Tennessee | 47093 | 82906 | 993 |
2020686 | 2020686 | 2021-12-16 | Knox | Tennessee | 47093 | 82766 | 991 |
2017435 | 2017435 | 2021-12-15 | Knox | Tennessee | 47093 | 82609 | 990 |
2014185 | 2014185 | 2021-12-14 | Knox | Tennessee | 47093 | 82502 | 987 |
2010934 | 2010934 | 2021-12-13 | Knox | Tennessee | 47093 | 82393 | 983 |
2007683 | 2007683 | 2021-12-12 | Knox | Tennessee | 47093 | 82191 | 977 |
2004432 | 2004432 | 2021-12-11 | Knox | Tennessee | 47093 | 82191 | 977 |
2001181 | 2001181 | 2021-12-10 | Knox | Tennessee | 47093 | 82191 | 977 |
1997931 | 1997931 | 2021-12-09 | Knox | Tennessee | 47093 | 81902 | 973 |
1994680 | 1994680 | 2021-12-08 | Knox | Tennessee | 47093 | 81902 | 973 |
1991429 | 1991429 | 2021-12-07 | Knox | Tennessee | 47093 | 81776 | 971 |
1988178 | 1988178 | 2021-12-06 | Knox | Tennessee | 47093 | 81633 | 963 |
1984928 | 1984928 | 2021-12-05 | Knox | Tennessee | 47093 | 81372 | 958 |
1981678 | 1981678 | 2021-12-04 | Knox | Tennessee | 47093 | 81372 | 958 |
1978428 | 1978428 | 2021-12-03 | Knox | Tennessee | 47093 | 81372 | 958 |
1975178 | 1975178 | 2021-12-02 | Knox | Tennessee | 47093 | 81236 | 958 |
1971929 | 1971929 | 2021-12-01 | Knox | Tennessee | 47093 | 81052 | 954 |
1968679 | 1968679 | 2021-11-30 | Knox | Tennessee | 47093 | 80929 | 951 |
1965428 | 1965428 | 2021-11-29 | Knox | Tennessee | 47093 | 80776 | 949 |
1962176 | 1962176 | 2021-11-28 | Knox | Tennessee | 47093 | 80429 | 946 |
1958925 | 1958925 | 2021-11-27 | Knox | Tennessee | 47093 | 80429 | 946 |
1955674 | 1955674 | 2021-11-26 | Knox | Tennessee | 47093 | 80429 | 946 |
1952423 | 1952423 | 2021-11-25 | Knox | Tennessee | 47093 | 80429 | 946 |
1949172 | 1949172 | 2021-11-24 | Knox | Tennessee | 47093 | 80429 | 946 |
1945921 | 1945921 | 2021-11-23 | Knox | Tennessee | 47093 | 80394 | 946 |
1942670 | 1942670 | 2021-11-22 | Knox | Tennessee | 47093 | 80290 | 946 |
1939420 | 1939420 | 2021-11-21 | Knox | Tennessee | 47093 | 80093 | 946 |
1936170 | 1936170 | 2021-11-20 | Knox | Tennessee | 47093 | 80093 | 946 |
1932920 | 1932920 | 2021-11-19 | Knox | Tennessee | 47093 | 80093 | 946 |
1929669 | 1929669 | 2021-11-18 | Knox | Tennessee | 47093 | 80009 | 943 |
1926419 | 1926419 | 2021-11-17 | Knox | Tennessee | 47093 | 79912 | 943 |
1923169 | 1923169 | 2021-11-16 | Knox | Tennessee | 47093 | 79838 | 943 |
1919920 | 1919920 | 2021-11-15 | Knox | Tennessee | 47093 | 79748 | 940 |
1916670 | 1916670 | 2021-11-14 | Knox | Tennessee | 47093 | 79582 | 940 |
1913420 | 1913420 | 2021-11-13 | Knox | Tennessee | 47093 | 79582 | 940 |
1910170 | 1910170 | 2021-11-12 | Knox | Tennessee | 47093 | 79582 | 940 |
1906921 | 1906921 | 2021-11-11 | Knox | Tennessee | 47093 | 79439 | 939 |
1903672 | 1903672 | 2021-11-10 | Knox | Tennessee | 47093 | 79439 | 939 |
1900422 | 1900422 | 2021-11-09 | Knox | Tennessee | 47093 | 79328 | 938 |
1897172 | 1897172 | 2021-11-08 | Knox | Tennessee | 47093 | 79125 | 932 |
1893922 | 1893922 | 2021-11-07 | Knox | Tennessee | 47093 | 79125 | 932 |
1890672 | 1890672 | 2021-11-06 | Knox | Tennessee | 47093 | 79125 | 932 |
1887422 | 1887422 | 2021-11-05 | Knox | Tennessee | 47093 | 79125 | 932 |
1884172 | 1884172 | 2021-11-04 | Knox | Tennessee | 47093 | 79059 | 932 |
1880923 | 1880923 | 2021-11-03 | Knox | Tennessee | 47093 | 78979 | 932 |
1877674 | 1877674 | 2021-11-02 | Knox | Tennessee | 47093 | 78940 | 928 |
1874425 | 1874425 | 2021-11-01 | Knox | Tennessee | 47093 | 78694 | 926 |
1871176 | 1871176 | 2021-10-31 | Knox | Tennessee | 47093 | 78694 | 926 |
1867927 | 1867927 | 2021-10-30 | Knox | Tennessee | 47093 | 78694 | 926 |
1864678 | 1864678 | 2021-10-29 | Knox | Tennessee | 47093 | 78694 | 926 |
1861429 | 1861429 | 2021-10-28 | Knox | Tennessee | 47093 | 78642 | 922 |
1858180 | 1858180 | 2021-10-27 | Knox | Tennessee | 47093 | 78531 | 921 |
1854931 | 1854931 | 2021-10-26 | Knox | Tennessee | 47093 | 78435 | 921 |
1851682 | 1851682 | 2021-10-25 | Knox | Tennessee | 47093 | 78177 | 914 |
1848432 | 1848432 | 2021-10-24 | Knox | Tennessee | 47093 | 78177 | 914 |
1845182 | 1845182 | 2021-10-23 | Knox | Tennessee | 47093 | 78177 | 914 |
1841932 | 1841932 | 2021-10-22 | Knox | Tennessee | 47093 | 78177 | 914 |
1838683 | 1838683 | 2021-10-21 | Knox | Tennessee | 47093 | 78054 | 911 |
1835434 | 1835434 | 2021-10-20 | Knox | Tennessee | 47093 | 77902 | 908 |
1832185 | 1832185 | 2021-10-19 | Knox | Tennessee | 47093 | 77772 | 903 |
1828936 | 1828936 | 2021-10-18 | Knox | Tennessee | 47093 | 77662 | 895 |
1825687 | 1825687 | 2021-10-17 | Knox | Tennessee | 47093 | 77415 | 885 |
1822438 | 1822438 | 2021-10-16 | Knox | Tennessee | 47093 | 77415 | 885 |
1819189 | 1819189 | 2021-10-15 | Knox | Tennessee | 47093 | 77415 | 885 |
1815940 | 1815940 | 2021-10-14 | Knox | Tennessee | 47093 | 77226 | 885 |
1812692 | 1812692 | 2021-10-13 | Knox | Tennessee | 47093 | 77105 | 878 |
1809443 | 1809443 | 2021-10-12 | Knox | Tennessee | 47093 | 76953 | 874 |
1806193 | 1806193 | 2021-10-11 | Knox | Tennessee | 47093 | 76787 | 871 |
1802943 | 1802943 | 2021-10-10 | Knox | Tennessee | 47093 | 76338 | 872 |
1799694 | 1799694 | 2021-10-09 | Knox | Tennessee | 47093 | 76338 | 872 |
1796445 | 1796445 | 2021-10-08 | Knox | Tennessee | 47093 | 76338 | 872 |
1793196 | 1793196 | 2021-10-07 | Knox | Tennessee | 47093 | 75956 | 866 |
1789947 | 1789947 | 2021-10-06 | Knox | Tennessee | 47093 | 75817 | 865 |
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);