ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Lincoln" and fips = 47103 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176778 | 2176778 | 2022-02-02 | Lincoln | Tennessee | 47103 | 9310 | 137 |
2173524 | 2173524 | 2022-02-01 | Lincoln | Tennessee | 47103 | 8724 | 137 |
2170272 | 2170272 | 2022-01-31 | Lincoln | Tennessee | 47103 | 8724 | 137 |
2167018 | 2167018 | 2022-01-30 | Lincoln | Tennessee | 47103 | 8724 | 137 |
2163763 | 2163763 | 2022-01-29 | Lincoln | Tennessee | 47103 | 8724 | 137 |
2160508 | 2160508 | 2022-01-28 | Lincoln | Tennessee | 47103 | 8724 | 137 |
2157252 | 2157252 | 2022-01-27 | Lincoln | Tennessee | 47103 | 8724 | 137 |
2153999 | 2153999 | 2022-01-26 | Lincoln | Tennessee | 47103 | 8724 | 137 |
2150747 | 2150747 | 2022-01-25 | Lincoln | Tennessee | 47103 | 7934 | 136 |
2147495 | 2147495 | 2022-01-24 | Lincoln | Tennessee | 47103 | 7934 | 136 |
2144241 | 2144241 | 2022-01-23 | Lincoln | Tennessee | 47103 | 7934 | 136 |
2140986 | 2140986 | 2022-01-22 | Lincoln | Tennessee | 47103 | 7934 | 136 |
2137730 | 2137730 | 2022-01-21 | Lincoln | Tennessee | 47103 | 7934 | 136 |
2134476 | 2134476 | 2022-01-20 | Lincoln | Tennessee | 47103 | 7934 | 136 |
2131224 | 2131224 | 2022-01-19 | Lincoln | Tennessee | 47103 | 7934 | 136 |
2127970 | 2127970 | 2022-01-18 | Lincoln | Tennessee | 47103 | 7416 | 136 |
2124718 | 2124718 | 2022-01-17 | Lincoln | Tennessee | 47103 | 7416 | 136 |
2121466 | 2121466 | 2022-01-16 | Lincoln | Tennessee | 47103 | 7416 | 136 |
2118214 | 2118214 | 2022-01-15 | Lincoln | Tennessee | 47103 | 7416 | 136 |
2114963 | 2114963 | 2022-01-14 | Lincoln | Tennessee | 47103 | 7416 | 136 |
2111711 | 2111711 | 2022-01-13 | Lincoln | Tennessee | 47103 | 7416 | 136 |
2108459 | 2108459 | 2022-01-12 | Lincoln | Tennessee | 47103 | 7416 | 136 |
2105208 | 2105208 | 2022-01-11 | Lincoln | Tennessee | 47103 | 7171 | 135 |
2101957 | 2101957 | 2022-01-10 | Lincoln | Tennessee | 47103 | 7171 | 135 |
2098706 | 2098706 | 2022-01-09 | Lincoln | Tennessee | 47103 | 7171 | 135 |
2095454 | 2095454 | 2022-01-08 | Lincoln | Tennessee | 47103 | 7171 | 135 |
2092202 | 2092202 | 2022-01-07 | Lincoln | Tennessee | 47103 | 7171 | 135 |
2088950 | 2088950 | 2022-01-06 | Lincoln | Tennessee | 47103 | 7171 | 135 |
2085699 | 2085699 | 2022-01-05 | Lincoln | Tennessee | 47103 | 7171 | 135 |
2082447 | 2082447 | 2022-01-04 | Lincoln | Tennessee | 47103 | 7171 | 135 |
2079195 | 2079195 | 2022-01-03 | Lincoln | Tennessee | 47103 | 7149 | 134 |
2075944 | 2075944 | 2022-01-02 | Lincoln | Tennessee | 47103 | 7038 | 134 |
2072693 | 2072693 | 2022-01-01 | Lincoln | Tennessee | 47103 | 7038 | 134 |
2069442 | 2069442 | 2021-12-31 | Lincoln | Tennessee | 47103 | 7038 | 134 |
2066191 | 2066191 | 2021-12-30 | Lincoln | Tennessee | 47103 | 7038 | 134 |
2062941 | 2062941 | 2021-12-29 | Lincoln | Tennessee | 47103 | 7017 | 134 |
2059691 | 2059691 | 2021-12-28 | Lincoln | Tennessee | 47103 | 6994 | 133 |
2056442 | 2056442 | 2021-12-27 | Lincoln | Tennessee | 47103 | 6981 | 133 |
2053193 | 2053193 | 2021-12-26 | Lincoln | Tennessee | 47103 | 6964 | 129 |
2049943 | 2049943 | 2021-12-25 | Lincoln | Tennessee | 47103 | 6964 | 129 |
2046693 | 2046693 | 2021-12-24 | Lincoln | Tennessee | 47103 | 6964 | 129 |
2043443 | 2043443 | 2021-12-23 | Lincoln | Tennessee | 47103 | 6964 | 129 |
2040194 | 2040194 | 2021-12-22 | Lincoln | Tennessee | 47103 | 6949 | 109 |
2036944 | 2036944 | 2021-12-21 | Lincoln | Tennessee | 47103 | 6938 | 108 |
2033694 | 2033694 | 2021-12-20 | Lincoln | Tennessee | 47103 | 6932 | 105 |
2030444 | 2030444 | 2021-12-19 | Lincoln | Tennessee | 47103 | 6923 | 104 |
2027193 | 2027193 | 2021-12-18 | Lincoln | Tennessee | 47103 | 6923 | 104 |
2023942 | 2023942 | 2021-12-17 | Lincoln | Tennessee | 47103 | 6923 | 104 |
2020691 | 2020691 | 2021-12-16 | Lincoln | Tennessee | 47103 | 6916 | 102 |
2017440 | 2017440 | 2021-12-15 | Lincoln | Tennessee | 47103 | 6907 | 101 |
2014190 | 2014190 | 2021-12-14 | Lincoln | Tennessee | 47103 | 6901 | 100 |
2010939 | 2010939 | 2021-12-13 | Lincoln | Tennessee | 47103 | 6895 | 100 |
2007688 | 2007688 | 2021-12-12 | Lincoln | Tennessee | 47103 | 6887 | 100 |
2004437 | 2004437 | 2021-12-11 | Lincoln | Tennessee | 47103 | 6887 | 100 |
2001186 | 2001186 | 2021-12-10 | Lincoln | Tennessee | 47103 | 6887 | 100 |
1997936 | 1997936 | 2021-12-09 | Lincoln | Tennessee | 47103 | 6879 | 100 |
1994685 | 1994685 | 2021-12-08 | Lincoln | Tennessee | 47103 | 6879 | 100 |
1991434 | 1991434 | 2021-12-07 | Lincoln | Tennessee | 47103 | 6873 | 100 |
1988183 | 1988183 | 2021-12-06 | Lincoln | Tennessee | 47103 | 6866 | 100 |
1984933 | 1984933 | 2021-12-05 | Lincoln | Tennessee | 47103 | 6857 | 98 |
1981683 | 1981683 | 2021-12-04 | Lincoln | Tennessee | 47103 | 6857 | 98 |
1978433 | 1978433 | 2021-12-03 | Lincoln | Tennessee | 47103 | 6857 | 98 |
1975183 | 1975183 | 2021-12-02 | Lincoln | Tennessee | 47103 | 6850 | 97 |
1971934 | 1971934 | 2021-12-01 | Lincoln | Tennessee | 47103 | 6847 | 96 |
1968684 | 1968684 | 2021-11-30 | Lincoln | Tennessee | 47103 | 6840 | 93 |
1965433 | 1965433 | 2021-11-29 | Lincoln | Tennessee | 47103 | 6836 | 92 |
1962181 | 1962181 | 2021-11-28 | Lincoln | Tennessee | 47103 | 6824 | 92 |
1958930 | 1958930 | 2021-11-27 | Lincoln | Tennessee | 47103 | 6824 | 92 |
1955679 | 1955679 | 2021-11-26 | Lincoln | Tennessee | 47103 | 6824 | 92 |
1952428 | 1952428 | 2021-11-25 | Lincoln | Tennessee | 47103 | 6824 | 92 |
1949177 | 1949177 | 2021-11-24 | Lincoln | Tennessee | 47103 | 6824 | 92 |
1945926 | 1945926 | 2021-11-23 | Lincoln | Tennessee | 47103 | 6822 | 90 |
1942675 | 1942675 | 2021-11-22 | Lincoln | Tennessee | 47103 | 6816 | 88 |
1939425 | 1939425 | 2021-11-21 | Lincoln | Tennessee | 47103 | 6800 | 88 |
1936175 | 1936175 | 2021-11-20 | Lincoln | Tennessee | 47103 | 6800 | 88 |
1932925 | 1932925 | 2021-11-19 | Lincoln | Tennessee | 47103 | 6800 | 88 |
1929674 | 1929674 | 2021-11-18 | Lincoln | Tennessee | 47103 | 6794 | 88 |
1926424 | 1926424 | 2021-11-17 | Lincoln | Tennessee | 47103 | 6792 | 88 |
1923174 | 1923174 | 2021-11-16 | Lincoln | Tennessee | 47103 | 6784 | 88 |
1919925 | 1919925 | 2021-11-15 | Lincoln | Tennessee | 47103 | 6779 | 88 |
1916675 | 1916675 | 2021-11-14 | Lincoln | Tennessee | 47103 | 6767 | 88 |
1913425 | 1913425 | 2021-11-13 | Lincoln | Tennessee | 47103 | 6767 | 88 |
1910175 | 1910175 | 2021-11-12 | Lincoln | Tennessee | 47103 | 6767 | 88 |
1906926 | 1906926 | 2021-11-11 | Lincoln | Tennessee | 47103 | 6752 | 88 |
1903677 | 1903677 | 2021-11-10 | Lincoln | Tennessee | 47103 | 6752 | 88 |
1900427 | 1900427 | 2021-11-09 | Lincoln | Tennessee | 47103 | 6739 | 87 |
1897177 | 1897177 | 2021-11-08 | Lincoln | Tennessee | 47103 | 6730 | 86 |
1893927 | 1893927 | 2021-11-07 | Lincoln | Tennessee | 47103 | 6730 | 86 |
1890677 | 1890677 | 2021-11-06 | Lincoln | Tennessee | 47103 | 6730 | 86 |
1887427 | 1887427 | 2021-11-05 | Lincoln | Tennessee | 47103 | 6730 | 86 |
1884177 | 1884177 | 2021-11-04 | Lincoln | Tennessee | 47103 | 6728 | 85 |
1880928 | 1880928 | 2021-11-03 | Lincoln | Tennessee | 47103 | 6721 | 84 |
1877679 | 1877679 | 2021-11-02 | Lincoln | Tennessee | 47103 | 6708 | 84 |
1874430 | 1874430 | 2021-11-01 | Lincoln | Tennessee | 47103 | 6692 | 84 |
1871181 | 1871181 | 2021-10-31 | Lincoln | Tennessee | 47103 | 6692 | 84 |
1867932 | 1867932 | 2021-10-30 | Lincoln | Tennessee | 47103 | 6692 | 84 |
1864683 | 1864683 | 2021-10-29 | Lincoln | Tennessee | 47103 | 6692 | 84 |
1861434 | 1861434 | 2021-10-28 | Lincoln | Tennessee | 47103 | 6685 | 84 |
1858185 | 1858185 | 2021-10-27 | Lincoln | Tennessee | 47103 | 6666 | 84 |
1854936 | 1854936 | 2021-10-26 | Lincoln | Tennessee | 47103 | 6658 | 83 |
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);