ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 47011 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2111665 | 2111665 | 2022-01-13 | Bradley | Tennessee | 47011 | 25292 | 323 |
2108413 | 2108413 | 2022-01-12 | Bradley | Tennessee | 47011 | 25292 | 323 |
2105162 | 2105162 | 2022-01-11 | Bradley | Tennessee | 47011 | 24247 | 321 |
2101911 | 2101911 | 2022-01-10 | Bradley | Tennessee | 47011 | 24247 | 321 |
2098660 | 2098660 | 2022-01-09 | Bradley | Tennessee | 47011 | 24247 | 321 |
2095408 | 2095408 | 2022-01-08 | Bradley | Tennessee | 47011 | 24247 | 321 |
2092156 | 2092156 | 2022-01-07 | Bradley | Tennessee | 47011 | 24247 | 321 |
2088904 | 2088904 | 2022-01-06 | Bradley | Tennessee | 47011 | 24247 | 321 |
2085653 | 2085653 | 2022-01-05 | Bradley | Tennessee | 47011 | 24247 | 321 |
2082401 | 2082401 | 2022-01-04 | Bradley | Tennessee | 47011 | 24247 | 321 |
2079149 | 2079149 | 2022-01-03 | Bradley | Tennessee | 47011 | 24082 | 320 |
2075898 | 2075898 | 2022-01-02 | Bradley | Tennessee | 47011 | 23701 | 320 |
2072647 | 2072647 | 2022-01-01 | Bradley | Tennessee | 47011 | 23701 | 320 |
2069396 | 2069396 | 2021-12-31 | Bradley | Tennessee | 47011 | 23701 | 320 |
2066145 | 2066145 | 2021-12-30 | Bradley | Tennessee | 47011 | 23701 | 320 |
2062895 | 2062895 | 2021-12-29 | Bradley | Tennessee | 47011 | 23552 | 319 |
2059645 | 2059645 | 2021-12-28 | Bradley | Tennessee | 47011 | 23492 | 318 |
2056396 | 2056396 | 2021-12-27 | Bradley | Tennessee | 47011 | 23403 | 316 |
2053147 | 2053147 | 2021-12-26 | Bradley | Tennessee | 47011 | 23303 | 309 |
2049897 | 2049897 | 2021-12-25 | Bradley | Tennessee | 47011 | 23303 | 309 |
2046647 | 2046647 | 2021-12-24 | Bradley | Tennessee | 47011 | 23303 | 309 |
2043397 | 2043397 | 2021-12-23 | Bradley | Tennessee | 47011 | 23303 | 309 |
2040148 | 2040148 | 2021-12-22 | Bradley | Tennessee | 47011 | 23253 | 255 |
2036898 | 2036898 | 2021-12-21 | Bradley | Tennessee | 47011 | 23218 | 252 |
2033648 | 2033648 | 2021-12-20 | Bradley | Tennessee | 47011 | 23188 | 249 |
2030398 | 2030398 | 2021-12-19 | Bradley | Tennessee | 47011 | 23108 | 249 |
2027147 | 2027147 | 2021-12-18 | Bradley | Tennessee | 47011 | 23108 | 249 |
2023896 | 2023896 | 2021-12-17 | Bradley | Tennessee | 47011 | 23108 | 249 |
2020645 | 2020645 | 2021-12-16 | Bradley | Tennessee | 47011 | 23073 | 248 |
2017394 | 2017394 | 2021-12-15 | Bradley | Tennessee | 47011 | 23031 | 248 |
2014144 | 2014144 | 2021-12-14 | Bradley | Tennessee | 47011 | 23000 | 247 |
2010893 | 2010893 | 2021-12-13 | Bradley | Tennessee | 47011 | 22966 | 242 |
2007642 | 2007642 | 2021-12-12 | Bradley | Tennessee | 47011 | 22927 | 242 |
2004391 | 2004391 | 2021-12-11 | Bradley | Tennessee | 47011 | 22927 | 242 |
2001140 | 2001140 | 2021-12-10 | Bradley | Tennessee | 47011 | 22927 | 242 |
1997890 | 1997890 | 2021-12-09 | Bradley | Tennessee | 47011 | 22856 | 240 |
1994639 | 1994639 | 2021-12-08 | Bradley | Tennessee | 47011 | 22856 | 240 |
1991388 | 1991388 | 2021-12-07 | Bradley | Tennessee | 47011 | 22824 | 238 |
1988137 | 1988137 | 2021-12-06 | Bradley | Tennessee | 47011 | 22784 | 235 |
1984887 | 1984887 | 2021-12-05 | Bradley | Tennessee | 47011 | 22730 | 233 |
1981637 | 1981637 | 2021-12-04 | Bradley | Tennessee | 47011 | 22730 | 233 |
1978387 | 1978387 | 2021-12-03 | Bradley | Tennessee | 47011 | 22730 | 233 |
1975137 | 1975137 | 2021-12-02 | Bradley | Tennessee | 47011 | 22708 | 229 |
1971888 | 1971888 | 2021-12-01 | Bradley | Tennessee | 47011 | 22679 | 224 |
1968638 | 1968638 | 2021-11-30 | Bradley | Tennessee | 47011 | 22659 | 221 |
1965387 | 1965387 | 2021-11-29 | Bradley | Tennessee | 47011 | 22607 | 218 |
1962135 | 1962135 | 2021-11-28 | Bradley | Tennessee | 47011 | 22549 | 217 |
1958884 | 1958884 | 2021-11-27 | Bradley | Tennessee | 47011 | 22549 | 217 |
1955633 | 1955633 | 2021-11-26 | Bradley | Tennessee | 47011 | 22549 | 217 |
1952382 | 1952382 | 2021-11-25 | Bradley | Tennessee | 47011 | 22549 | 217 |
1949131 | 1949131 | 2021-11-24 | Bradley | Tennessee | 47011 | 22549 | 217 |
1945880 | 1945880 | 2021-11-23 | Bradley | Tennessee | 47011 | 22536 | 215 |
1942629 | 1942629 | 2021-11-22 | Bradley | Tennessee | 47011 | 22520 | 212 |
1939379 | 1939379 | 2021-11-21 | Bradley | Tennessee | 47011 | 22475 | 212 |
1936129 | 1936129 | 2021-11-20 | Bradley | Tennessee | 47011 | 22475 | 212 |
1932879 | 1932879 | 2021-11-19 | Bradley | Tennessee | 47011 | 22475 | 212 |
1929628 | 1929628 | 2021-11-18 | Bradley | Tennessee | 47011 | 22463 | 212 |
1926378 | 1926378 | 2021-11-17 | Bradley | Tennessee | 47011 | 22439 | 212 |
1923128 | 1923128 | 2021-11-16 | Bradley | Tennessee | 47011 | 22428 | 206 |
1919879 | 1919879 | 2021-11-15 | Bradley | Tennessee | 47011 | 22413 | 203 |
1916629 | 1916629 | 2021-11-14 | Bradley | Tennessee | 47011 | 22370 | 203 |
1913379 | 1913379 | 2021-11-13 | Bradley | Tennessee | 47011 | 22370 | 203 |
1910129 | 1910129 | 2021-11-12 | Bradley | Tennessee | 47011 | 22370 | 203 |
1906880 | 1906880 | 2021-11-11 | Bradley | Tennessee | 47011 | 22334 | 203 |
1903631 | 1903631 | 2021-11-10 | Bradley | Tennessee | 47011 | 22334 | 203 |
1900381 | 1900381 | 2021-11-09 | Bradley | Tennessee | 47011 | 22319 | 203 |
1897131 | 1897131 | 2021-11-08 | Bradley | Tennessee | 47011 | 22276 | 202 |
1893881 | 1893881 | 2021-11-07 | Bradley | Tennessee | 47011 | 22276 | 202 |
1890631 | 1890631 | 2021-11-06 | Bradley | Tennessee | 47011 | 22276 | 202 |
1887381 | 1887381 | 2021-11-05 | Bradley | Tennessee | 47011 | 22276 | 202 |
1884131 | 1884131 | 2021-11-04 | Bradley | Tennessee | 47011 | 22261 | 201 |
1880882 | 1880882 | 2021-11-03 | Bradley | Tennessee | 47011 | 22235 | 201 |
1877633 | 1877633 | 2021-11-02 | Bradley | Tennessee | 47011 | 22221 | 199 |
1874384 | 1874384 | 2021-11-01 | Bradley | Tennessee | 47011 | 22157 | 197 |
1871135 | 1871135 | 2021-10-31 | Bradley | Tennessee | 47011 | 22157 | 197 |
1867886 | 1867886 | 2021-10-30 | Bradley | Tennessee | 47011 | 22157 | 197 |
1864637 | 1864637 | 2021-10-29 | Bradley | Tennessee | 47011 | 22157 | 197 |
1861388 | 1861388 | 2021-10-28 | Bradley | Tennessee | 47011 | 22131 | 196 |
1858139 | 1858139 | 2021-10-27 | Bradley | Tennessee | 47011 | 22113 | 195 |
1854890 | 1854890 | 2021-10-26 | Bradley | Tennessee | 47011 | 22086 | 195 |
1851641 | 1851641 | 2021-10-25 | Bradley | Tennessee | 47011 | 22034 | 193 |
1848391 | 1848391 | 2021-10-24 | Bradley | Tennessee | 47011 | 22034 | 193 |
1845141 | 1845141 | 2021-10-23 | Bradley | Tennessee | 47011 | 22034 | 193 |
1841891 | 1841891 | 2021-10-22 | Bradley | Tennessee | 47011 | 22034 | 193 |
1838642 | 1838642 | 2021-10-21 | Bradley | Tennessee | 47011 | 22008 | 191 |
1835393 | 1835393 | 2021-10-20 | Bradley | Tennessee | 47011 | 21975 | 190 |
1832144 | 1832144 | 2021-10-19 | Bradley | Tennessee | 47011 | 21943 | 189 |
1828895 | 1828895 | 2021-10-18 | Bradley | Tennessee | 47011 | 21914 | 187 |
1825646 | 1825646 | 2021-10-17 | Bradley | Tennessee | 47011 | 21875 | 187 |
1822397 | 1822397 | 2021-10-16 | Bradley | Tennessee | 47011 | 21875 | 187 |
1819148 | 1819148 | 2021-10-15 | Bradley | Tennessee | 47011 | 21875 | 187 |
1815899 | 1815899 | 2021-10-14 | Bradley | Tennessee | 47011 | 21837 | 187 |
1812651 | 1812651 | 2021-10-13 | Bradley | Tennessee | 47011 | 21790 | 187 |
1809402 | 1809402 | 2021-10-12 | Bradley | Tennessee | 47011 | 21755 | 187 |
1806152 | 1806152 | 2021-10-11 | Bradley | Tennessee | 47011 | 21719 | 176 |
1802902 | 1802902 | 2021-10-10 | Bradley | Tennessee | 47011 | 21673 | 174 |
1799653 | 1799653 | 2021-10-09 | Bradley | Tennessee | 47011 | 21673 | 174 |
1796404 | 1796404 | 2021-10-08 | Bradley | Tennessee | 47011 | 21673 | 174 |
1793155 | 1793155 | 2021-10-07 | Bradley | Tennessee | 47011 | 21630 | 174 |
1789906 | 1789906 | 2021-10-06 | Bradley | Tennessee | 47011 | 21605 | 172 |
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);