ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 47017 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176735 | 2176735 | 2022-02-02 | Carroll | Tennessee | 47017 | 8246 | 137 |
2173481 | 2173481 | 2022-02-01 | Carroll | Tennessee | 47017 | 7712 | 134 |
2170229 | 2170229 | 2022-01-31 | Carroll | Tennessee | 47017 | 7712 | 134 |
2166975 | 2166975 | 2022-01-30 | Carroll | Tennessee | 47017 | 7712 | 134 |
2163720 | 2163720 | 2022-01-29 | Carroll | Tennessee | 47017 | 7712 | 134 |
2160465 | 2160465 | 2022-01-28 | Carroll | Tennessee | 47017 | 7712 | 134 |
2157209 | 2157209 | 2022-01-27 | Carroll | Tennessee | 47017 | 7712 | 134 |
2153956 | 2153956 | 2022-01-26 | Carroll | Tennessee | 47017 | 7712 | 134 |
2150704 | 2150704 | 2022-01-25 | Carroll | Tennessee | 47017 | 7113 | 130 |
2147452 | 2147452 | 2022-01-24 | Carroll | Tennessee | 47017 | 7113 | 130 |
2144198 | 2144198 | 2022-01-23 | Carroll | Tennessee | 47017 | 7113 | 130 |
2140943 | 2140943 | 2022-01-22 | Carroll | Tennessee | 47017 | 7113 | 130 |
2137687 | 2137687 | 2022-01-21 | Carroll | Tennessee | 47017 | 7113 | 130 |
2134433 | 2134433 | 2022-01-20 | Carroll | Tennessee | 47017 | 7113 | 130 |
2131181 | 2131181 | 2022-01-19 | Carroll | Tennessee | 47017 | 7113 | 130 |
2127927 | 2127927 | 2022-01-18 | Carroll | Tennessee | 47017 | 6532 | 130 |
2124675 | 2124675 | 2022-01-17 | Carroll | Tennessee | 47017 | 6532 | 130 |
2121423 | 2121423 | 2022-01-16 | Carroll | Tennessee | 47017 | 6532 | 130 |
2118171 | 2118171 | 2022-01-15 | Carroll | Tennessee | 47017 | 6532 | 130 |
2114920 | 2114920 | 2022-01-14 | Carroll | Tennessee | 47017 | 6532 | 130 |
2111668 | 2111668 | 2022-01-13 | Carroll | Tennessee | 47017 | 6532 | 130 |
2108416 | 2108416 | 2022-01-12 | Carroll | Tennessee | 47017 | 6532 | 130 |
2105165 | 2105165 | 2022-01-11 | Carroll | Tennessee | 47017 | 6248 | 129 |
2101914 | 2101914 | 2022-01-10 | Carroll | Tennessee | 47017 | 6248 | 129 |
2098663 | 2098663 | 2022-01-09 | Carroll | Tennessee | 47017 | 6248 | 129 |
2095411 | 2095411 | 2022-01-08 | Carroll | Tennessee | 47017 | 6248 | 129 |
2092159 | 2092159 | 2022-01-07 | Carroll | Tennessee | 47017 | 6248 | 129 |
2088907 | 2088907 | 2022-01-06 | Carroll | Tennessee | 47017 | 6248 | 129 |
2085656 | 2085656 | 2022-01-05 | Carroll | Tennessee | 47017 | 6248 | 129 |
2082404 | 2082404 | 2022-01-04 | Carroll | Tennessee | 47017 | 6248 | 129 |
2079152 | 2079152 | 2022-01-03 | Carroll | Tennessee | 47017 | 6214 | 129 |
2075901 | 2075901 | 2022-01-02 | Carroll | Tennessee | 47017 | 6129 | 127 |
2072650 | 2072650 | 2022-01-01 | Carroll | Tennessee | 47017 | 6129 | 127 |
2069399 | 2069399 | 2021-12-31 | Carroll | Tennessee | 47017 | 6129 | 127 |
2066148 | 2066148 | 2021-12-30 | Carroll | Tennessee | 47017 | 6129 | 127 |
2062898 | 2062898 | 2021-12-29 | Carroll | Tennessee | 47017 | 6109 | 127 |
2059648 | 2059648 | 2021-12-28 | Carroll | Tennessee | 47017 | 6085 | 127 |
2056399 | 2056399 | 2021-12-27 | Carroll | Tennessee | 47017 | 6067 | 127 |
2053150 | 2053150 | 2021-12-26 | Carroll | Tennessee | 47017 | 6048 | 127 |
2049900 | 2049900 | 2021-12-25 | Carroll | Tennessee | 47017 | 6048 | 127 |
2046650 | 2046650 | 2021-12-24 | Carroll | Tennessee | 47017 | 6048 | 127 |
2043400 | 2043400 | 2021-12-23 | Carroll | Tennessee | 47017 | 6048 | 127 |
2040151 | 2040151 | 2021-12-22 | Carroll | Tennessee | 47017 | 6029 | 116 |
2036901 | 2036901 | 2021-12-21 | Carroll | Tennessee | 47017 | 6022 | 115 |
2033651 | 2033651 | 2021-12-20 | Carroll | Tennessee | 47017 | 6020 | 114 |
2030401 | 2030401 | 2021-12-19 | Carroll | Tennessee | 47017 | 6006 | 114 |
2027150 | 2027150 | 2021-12-18 | Carroll | Tennessee | 47017 | 6006 | 114 |
2023899 | 2023899 | 2021-12-17 | Carroll | Tennessee | 47017 | 6006 | 114 |
2020648 | 2020648 | 2021-12-16 | Carroll | Tennessee | 47017 | 5993 | 114 |
2017397 | 2017397 | 2021-12-15 | Carroll | Tennessee | 47017 | 5983 | 114 |
2014147 | 2014147 | 2021-12-14 | Carroll | Tennessee | 47017 | 5974 | 113 |
2010896 | 2010896 | 2021-12-13 | Carroll | Tennessee | 47017 | 5970 | 113 |
2007645 | 2007645 | 2021-12-12 | Carroll | Tennessee | 47017 | 5952 | 113 |
2004394 | 2004394 | 2021-12-11 | Carroll | Tennessee | 47017 | 5952 | 113 |
2001143 | 2001143 | 2021-12-10 | Carroll | Tennessee | 47017 | 5952 | 113 |
1997893 | 1997893 | 2021-12-09 | Carroll | Tennessee | 47017 | 5936 | 113 |
1994642 | 1994642 | 2021-12-08 | Carroll | Tennessee | 47017 | 5936 | 113 |
1991391 | 1991391 | 2021-12-07 | Carroll | Tennessee | 47017 | 5926 | 113 |
1988140 | 1988140 | 2021-12-06 | Carroll | Tennessee | 47017 | 5911 | 113 |
1984890 | 1984890 | 2021-12-05 | Carroll | Tennessee | 47017 | 5905 | 113 |
1981640 | 1981640 | 2021-12-04 | Carroll | Tennessee | 47017 | 5905 | 113 |
1978390 | 1978390 | 2021-12-03 | Carroll | Tennessee | 47017 | 5905 | 113 |
1975140 | 1975140 | 2021-12-02 | Carroll | Tennessee | 47017 | 5898 | 112 |
1971891 | 1971891 | 2021-12-01 | Carroll | Tennessee | 47017 | 5894 | 112 |
1968641 | 1968641 | 2021-11-30 | Carroll | Tennessee | 47017 | 5884 | 111 |
1965390 | 1965390 | 2021-11-29 | Carroll | Tennessee | 47017 | 5876 | 111 |
1962138 | 1962138 | 2021-11-28 | Carroll | Tennessee | 47017 | 5864 | 111 |
1958887 | 1958887 | 2021-11-27 | Carroll | Tennessee | 47017 | 5864 | 111 |
1955636 | 1955636 | 2021-11-26 | Carroll | Tennessee | 47017 | 5864 | 111 |
1952385 | 1952385 | 2021-11-25 | Carroll | Tennessee | 47017 | 5864 | 111 |
1949134 | 1949134 | 2021-11-24 | Carroll | Tennessee | 47017 | 5864 | 111 |
1945883 | 1945883 | 2021-11-23 | Carroll | Tennessee | 47017 | 5864 | 110 |
1942632 | 1942632 | 2021-11-22 | Carroll | Tennessee | 47017 | 5856 | 107 |
1939382 | 1939382 | 2021-11-21 | Carroll | Tennessee | 47017 | 5849 | 107 |
1936132 | 1936132 | 2021-11-20 | Carroll | Tennessee | 47017 | 5849 | 107 |
1932882 | 1932882 | 2021-11-19 | Carroll | Tennessee | 47017 | 5849 | 107 |
1929631 | 1929631 | 2021-11-18 | Carroll | Tennessee | 47017 | 5842 | 107 |
1926381 | 1926381 | 2021-11-17 | Carroll | Tennessee | 47017 | 5839 | 107 |
1923131 | 1923131 | 2021-11-16 | Carroll | Tennessee | 47017 | 5836 | 107 |
1919882 | 1919882 | 2021-11-15 | Carroll | Tennessee | 47017 | 5832 | 106 |
1916632 | 1916632 | 2021-11-14 | Carroll | Tennessee | 47017 | 5828 | 106 |
1913382 | 1913382 | 2021-11-13 | Carroll | Tennessee | 47017 | 5828 | 106 |
1910132 | 1910132 | 2021-11-12 | Carroll | Tennessee | 47017 | 5828 | 106 |
1906883 | 1906883 | 2021-11-11 | Carroll | Tennessee | 47017 | 5822 | 106 |
1903634 | 1903634 | 2021-11-10 | Carroll | Tennessee | 47017 | 5822 | 106 |
1900384 | 1900384 | 2021-11-09 | Carroll | Tennessee | 47017 | 5811 | 105 |
1897134 | 1897134 | 2021-11-08 | Carroll | Tennessee | 47017 | 5790 | 105 |
1893884 | 1893884 | 2021-11-07 | Carroll | Tennessee | 47017 | 5790 | 105 |
1890634 | 1890634 | 2021-11-06 | Carroll | Tennessee | 47017 | 5790 | 105 |
1887384 | 1887384 | 2021-11-05 | Carroll | Tennessee | 47017 | 5790 | 105 |
1884134 | 1884134 | 2021-11-04 | Carroll | Tennessee | 47017 | 5786 | 105 |
1880885 | 1880885 | 2021-11-03 | Carroll | Tennessee | 47017 | 5777 | 103 |
1877636 | 1877636 | 2021-11-02 | Carroll | Tennessee | 47017 | 5775 | 103 |
1874387 | 1874387 | 2021-11-01 | Carroll | Tennessee | 47017 | 5761 | 103 |
1871138 | 1871138 | 2021-10-31 | Carroll | Tennessee | 47017 | 5761 | 103 |
1867889 | 1867889 | 2021-10-30 | Carroll | Tennessee | 47017 | 5761 | 103 |
1864640 | 1864640 | 2021-10-29 | Carroll | Tennessee | 47017 | 5761 | 103 |
1861391 | 1861391 | 2021-10-28 | Carroll | Tennessee | 47017 | 5751 | 103 |
1858142 | 1858142 | 2021-10-27 | Carroll | Tennessee | 47017 | 5742 | 103 |
1854893 | 1854893 | 2021-10-26 | Carroll | Tennessee | 47017 | 5734 | 102 |
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);