ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 47063 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176758 | 2176758 | 2022-02-02 | Hamblen | Tennessee | 47063 | 18184 | 311 |
2173504 | 2173504 | 2022-02-01 | Hamblen | Tennessee | 47063 | 17330 | 306 |
2170252 | 2170252 | 2022-01-31 | Hamblen | Tennessee | 47063 | 17330 | 306 |
2166998 | 2166998 | 2022-01-30 | Hamblen | Tennessee | 47063 | 17330 | 306 |
2163743 | 2163743 | 2022-01-29 | Hamblen | Tennessee | 47063 | 17330 | 306 |
2160488 | 2160488 | 2022-01-28 | Hamblen | Tennessee | 47063 | 17330 | 306 |
2157232 | 2157232 | 2022-01-27 | Hamblen | Tennessee | 47063 | 17330 | 306 |
2153979 | 2153979 | 2022-01-26 | Hamblen | Tennessee | 47063 | 17330 | 306 |
2150727 | 2150727 | 2022-01-25 | Hamblen | Tennessee | 47063 | 16152 | 300 |
2147475 | 2147475 | 2022-01-24 | Hamblen | Tennessee | 47063 | 16152 | 300 |
2144221 | 2144221 | 2022-01-23 | Hamblen | Tennessee | 47063 | 16152 | 300 |
2140966 | 2140966 | 2022-01-22 | Hamblen | Tennessee | 47063 | 16152 | 300 |
2137710 | 2137710 | 2022-01-21 | Hamblen | Tennessee | 47063 | 16152 | 300 |
2134456 | 2134456 | 2022-01-20 | Hamblen | Tennessee | 47063 | 16152 | 300 |
2131204 | 2131204 | 2022-01-19 | Hamblen | Tennessee | 47063 | 16152 | 300 |
2127950 | 2127950 | 2022-01-18 | Hamblen | Tennessee | 47063 | 14888 | 292 |
2124698 | 2124698 | 2022-01-17 | Hamblen | Tennessee | 47063 | 14888 | 292 |
2121446 | 2121446 | 2022-01-16 | Hamblen | Tennessee | 47063 | 14888 | 292 |
2118194 | 2118194 | 2022-01-15 | Hamblen | Tennessee | 47063 | 14888 | 292 |
2114943 | 2114943 | 2022-01-14 | Hamblen | Tennessee | 47063 | 14888 | 292 |
2111691 | 2111691 | 2022-01-13 | Hamblen | Tennessee | 47063 | 14888 | 292 |
2108439 | 2108439 | 2022-01-12 | Hamblen | Tennessee | 47063 | 14888 | 292 |
2105188 | 2105188 | 2022-01-11 | Hamblen | Tennessee | 47063 | 14315 | 290 |
2101937 | 2101937 | 2022-01-10 | Hamblen | Tennessee | 47063 | 14315 | 290 |
2098686 | 2098686 | 2022-01-09 | Hamblen | Tennessee | 47063 | 14315 | 290 |
2095434 | 2095434 | 2022-01-08 | Hamblen | Tennessee | 47063 | 14315 | 290 |
2092182 | 2092182 | 2022-01-07 | Hamblen | Tennessee | 47063 | 14315 | 290 |
2088930 | 2088930 | 2022-01-06 | Hamblen | Tennessee | 47063 | 14315 | 290 |
2085679 | 2085679 | 2022-01-05 | Hamblen | Tennessee | 47063 | 14315 | 290 |
2082427 | 2082427 | 2022-01-04 | Hamblen | Tennessee | 47063 | 14315 | 290 |
2079175 | 2079175 | 2022-01-03 | Hamblen | Tennessee | 47063 | 14250 | 288 |
2075924 | 2075924 | 2022-01-02 | Hamblen | Tennessee | 47063 | 14070 | 288 |
2072673 | 2072673 | 2022-01-01 | Hamblen | Tennessee | 47063 | 14070 | 288 |
2069422 | 2069422 | 2021-12-31 | Hamblen | Tennessee | 47063 | 14070 | 288 |
2066171 | 2066171 | 2021-12-30 | Hamblen | Tennessee | 47063 | 14070 | 288 |
2062921 | 2062921 | 2021-12-29 | Hamblen | Tennessee | 47063 | 13963 | 288 |
2059671 | 2059671 | 2021-12-28 | Hamblen | Tennessee | 47063 | 13910 | 288 |
2056422 | 2056422 | 2021-12-27 | Hamblen | Tennessee | 47063 | 13867 | 286 |
2053173 | 2053173 | 2021-12-26 | Hamblen | Tennessee | 47063 | 13789 | 284 |
2049923 | 2049923 | 2021-12-25 | Hamblen | Tennessee | 47063 | 13789 | 284 |
2046673 | 2046673 | 2021-12-24 | Hamblen | Tennessee | 47063 | 13789 | 284 |
2043423 | 2043423 | 2021-12-23 | Hamblen | Tennessee | 47063 | 13789 | 284 |
2040174 | 2040174 | 2021-12-22 | Hamblen | Tennessee | 47063 | 13756 | 234 |
2036924 | 2036924 | 2021-12-21 | Hamblen | Tennessee | 47063 | 13736 | 234 |
2033674 | 2033674 | 2021-12-20 | Hamblen | Tennessee | 47063 | 13707 | 232 |
2030424 | 2030424 | 2021-12-19 | Hamblen | Tennessee | 47063 | 13660 | 231 |
2027173 | 2027173 | 2021-12-18 | Hamblen | Tennessee | 47063 | 13660 | 231 |
2023922 | 2023922 | 2021-12-17 | Hamblen | Tennessee | 47063 | 13660 | 231 |
2020671 | 2020671 | 2021-12-16 | Hamblen | Tennessee | 47063 | 13644 | 230 |
2017420 | 2017420 | 2021-12-15 | Hamblen | Tennessee | 47063 | 13612 | 229 |
2014170 | 2014170 | 2021-12-14 | Hamblen | Tennessee | 47063 | 13598 | 226 |
2010919 | 2010919 | 2021-12-13 | Hamblen | Tennessee | 47063 | 13574 | 224 |
2007668 | 2007668 | 2021-12-12 | Hamblen | Tennessee | 47063 | 13537 | 223 |
2004417 | 2004417 | 2021-12-11 | Hamblen | Tennessee | 47063 | 13537 | 223 |
2001166 | 2001166 | 2021-12-10 | Hamblen | Tennessee | 47063 | 13537 | 223 |
1997916 | 1997916 | 2021-12-09 | Hamblen | Tennessee | 47063 | 13488 | 223 |
1994665 | 1994665 | 2021-12-08 | Hamblen | Tennessee | 47063 | 13488 | 223 |
1991414 | 1991414 | 2021-12-07 | Hamblen | Tennessee | 47063 | 13473 | 223 |
1988163 | 1988163 | 2021-12-06 | Hamblen | Tennessee | 47063 | 13452 | 221 |
1984913 | 1984913 | 2021-12-05 | Hamblen | Tennessee | 47063 | 13401 | 219 |
1981663 | 1981663 | 2021-12-04 | Hamblen | Tennessee | 47063 | 13401 | 219 |
1978413 | 1978413 | 2021-12-03 | Hamblen | Tennessee | 47063 | 13401 | 219 |
1975163 | 1975163 | 2021-12-02 | Hamblen | Tennessee | 47063 | 13386 | 218 |
1971914 | 1971914 | 2021-12-01 | Hamblen | Tennessee | 47063 | 13357 | 217 |
1968664 | 1968664 | 2021-11-30 | Hamblen | Tennessee | 47063 | 13339 | 208 |
1965413 | 1965413 | 2021-11-29 | Hamblen | Tennessee | 47063 | 13319 | 207 |
1962161 | 1962161 | 2021-11-28 | Hamblen | Tennessee | 47063 | 13263 | 207 |
1958910 | 1958910 | 2021-11-27 | Hamblen | Tennessee | 47063 | 13263 | 207 |
1955659 | 1955659 | 2021-11-26 | Hamblen | Tennessee | 47063 | 13263 | 207 |
1952408 | 1952408 | 2021-11-25 | Hamblen | Tennessee | 47063 | 13263 | 207 |
1949157 | 1949157 | 2021-11-24 | Hamblen | Tennessee | 47063 | 13263 | 207 |
1945906 | 1945906 | 2021-11-23 | Hamblen | Tennessee | 47063 | 13257 | 206 |
1942655 | 1942655 | 2021-11-22 | Hamblen | Tennessee | 47063 | 13238 | 206 |
1939405 | 1939405 | 2021-11-21 | Hamblen | Tennessee | 47063 | 13211 | 206 |
1936155 | 1936155 | 2021-11-20 | Hamblen | Tennessee | 47063 | 13211 | 206 |
1932905 | 1932905 | 2021-11-19 | Hamblen | Tennessee | 47063 | 13211 | 206 |
1929654 | 1929654 | 2021-11-18 | Hamblen | Tennessee | 47063 | 13197 | 205 |
1926404 | 1926404 | 2021-11-17 | Hamblen | Tennessee | 47063 | 13183 | 205 |
1923154 | 1923154 | 2021-11-16 | Hamblen | Tennessee | 47063 | 13175 | 204 |
1919905 | 1919905 | 2021-11-15 | Hamblen | Tennessee | 47063 | 13165 | 203 |
1916655 | 1916655 | 2021-11-14 | Hamblen | Tennessee | 47063 | 13151 | 202 |
1913405 | 1913405 | 2021-11-13 | Hamblen | Tennessee | 47063 | 13151 | 202 |
1910155 | 1910155 | 2021-11-12 | Hamblen | Tennessee | 47063 | 13151 | 202 |
1906906 | 1906906 | 2021-11-11 | Hamblen | Tennessee | 47063 | 13125 | 202 |
1903657 | 1903657 | 2021-11-10 | Hamblen | Tennessee | 47063 | 13125 | 202 |
1900407 | 1900407 | 2021-11-09 | Hamblen | Tennessee | 47063 | 13113 | 202 |
1897157 | 1897157 | 2021-11-08 | Hamblen | Tennessee | 47063 | 13094 | 202 |
1893907 | 1893907 | 2021-11-07 | Hamblen | Tennessee | 47063 | 13094 | 202 |
1890657 | 1890657 | 2021-11-06 | Hamblen | Tennessee | 47063 | 13094 | 202 |
1887407 | 1887407 | 2021-11-05 | Hamblen | Tennessee | 47063 | 13094 | 202 |
1884157 | 1884157 | 2021-11-04 | Hamblen | Tennessee | 47063 | 13088 | 202 |
1880908 | 1880908 | 2021-11-03 | Hamblen | Tennessee | 47063 | 13076 | 202 |
1877659 | 1877659 | 2021-11-02 | Hamblen | Tennessee | 47063 | 13065 | 202 |
1874410 | 1874410 | 2021-11-01 | Hamblen | Tennessee | 47063 | 13023 | 202 |
1871161 | 1871161 | 2021-10-31 | Hamblen | Tennessee | 47063 | 13023 | 202 |
1867912 | 1867912 | 2021-10-30 | Hamblen | Tennessee | 47063 | 13023 | 202 |
1864663 | 1864663 | 2021-10-29 | Hamblen | Tennessee | 47063 | 13023 | 202 |
1861414 | 1861414 | 2021-10-28 | Hamblen | Tennessee | 47063 | 13014 | 202 |
1858165 | 1858165 | 2021-10-27 | Hamblen | Tennessee | 47063 | 12996 | 201 |
1854916 | 1854916 | 2021-10-26 | Hamblen | Tennessee | 47063 | 12988 | 201 |
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);