ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 47163 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176808 | 2176808 | 2022-02-02 | Sullivan | Tennessee | 47163 | 40582 | 598 |
2173554 | 2173554 | 2022-02-01 | Sullivan | Tennessee | 47163 | 37990 | 587 |
2170302 | 2170302 | 2022-01-31 | Sullivan | Tennessee | 47163 | 37990 | 587 |
2167048 | 2167048 | 2022-01-30 | Sullivan | Tennessee | 47163 | 37990 | 587 |
2163793 | 2163793 | 2022-01-29 | Sullivan | Tennessee | 47163 | 37990 | 587 |
2160538 | 2160538 | 2022-01-28 | Sullivan | Tennessee | 47163 | 37990 | 587 |
2157282 | 2157282 | 2022-01-27 | Sullivan | Tennessee | 47163 | 37990 | 587 |
2154029 | 2154029 | 2022-01-26 | Sullivan | Tennessee | 47163 | 37990 | 587 |
2150777 | 2150777 | 2022-01-25 | Sullivan | Tennessee | 47163 | 35225 | 574 |
2147525 | 2147525 | 2022-01-24 | Sullivan | Tennessee | 47163 | 35225 | 574 |
2144271 | 2144271 | 2022-01-23 | Sullivan | Tennessee | 47163 | 35225 | 574 |
2141016 | 2141016 | 2022-01-22 | Sullivan | Tennessee | 47163 | 35225 | 574 |
2137760 | 2137760 | 2022-01-21 | Sullivan | Tennessee | 47163 | 35225 | 574 |
2134506 | 2134506 | 2022-01-20 | Sullivan | Tennessee | 47163 | 35225 | 574 |
2131254 | 2131254 | 2022-01-19 | Sullivan | Tennessee | 47163 | 35225 | 574 |
2128000 | 2128000 | 2022-01-18 | Sullivan | Tennessee | 47163 | 32969 | 560 |
2124748 | 2124748 | 2022-01-17 | Sullivan | Tennessee | 47163 | 32969 | 560 |
2121496 | 2121496 | 2022-01-16 | Sullivan | Tennessee | 47163 | 32969 | 560 |
2118244 | 2118244 | 2022-01-15 | Sullivan | Tennessee | 47163 | 32969 | 560 |
2114993 | 2114993 | 2022-01-14 | Sullivan | Tennessee | 47163 | 32969 | 560 |
2111741 | 2111741 | 2022-01-13 | Sullivan | Tennessee | 47163 | 32969 | 560 |
2108489 | 2108489 | 2022-01-12 | Sullivan | Tennessee | 47163 | 32969 | 560 |
2105238 | 2105238 | 2022-01-11 | Sullivan | Tennessee | 47163 | 31623 | 551 |
2101987 | 2101987 | 2022-01-10 | Sullivan | Tennessee | 47163 | 31623 | 551 |
2098736 | 2098736 | 2022-01-09 | Sullivan | Tennessee | 47163 | 31623 | 551 |
2095484 | 2095484 | 2022-01-08 | Sullivan | Tennessee | 47163 | 31623 | 551 |
2092232 | 2092232 | 2022-01-07 | Sullivan | Tennessee | 47163 | 31623 | 551 |
2088980 | 2088980 | 2022-01-06 | Sullivan | Tennessee | 47163 | 31623 | 551 |
2085729 | 2085729 | 2022-01-05 | Sullivan | Tennessee | 47163 | 31623 | 551 |
2082477 | 2082477 | 2022-01-04 | Sullivan | Tennessee | 47163 | 31623 | 551 |
2079225 | 2079225 | 2022-01-03 | Sullivan | Tennessee | 47163 | 31409 | 547 |
2075974 | 2075974 | 2022-01-02 | Sullivan | Tennessee | 47163 | 30945 | 545 |
2072723 | 2072723 | 2022-01-01 | Sullivan | Tennessee | 47163 | 30945 | 545 |
2069472 | 2069472 | 2021-12-31 | Sullivan | Tennessee | 47163 | 30945 | 545 |
2066221 | 2066221 | 2021-12-30 | Sullivan | Tennessee | 47163 | 30945 | 545 |
2062971 | 2062971 | 2021-12-29 | Sullivan | Tennessee | 47163 | 30691 | 539 |
2059721 | 2059721 | 2021-12-28 | Sullivan | Tennessee | 47163 | 30630 | 531 |
2056472 | 2056472 | 2021-12-27 | Sullivan | Tennessee | 47163 | 30525 | 527 |
2053223 | 2053223 | 2021-12-26 | Sullivan | Tennessee | 47163 | 30313 | 525 |
2049973 | 2049973 | 2021-12-25 | Sullivan | Tennessee | 47163 | 30313 | 525 |
2046723 | 2046723 | 2021-12-24 | Sullivan | Tennessee | 47163 | 30313 | 525 |
2043473 | 2043473 | 2021-12-23 | Sullivan | Tennessee | 47163 | 30313 | 525 |
2040224 | 2040224 | 2021-12-22 | Sullivan | Tennessee | 47163 | 30193 | 489 |
2036974 | 2036974 | 2021-12-21 | Sullivan | Tennessee | 47163 | 30123 | 488 |
2033724 | 2033724 | 2021-12-20 | Sullivan | Tennessee | 47163 | 30016 | 485 |
2030474 | 2030474 | 2021-12-19 | Sullivan | Tennessee | 47163 | 29844 | 483 |
2027223 | 2027223 | 2021-12-18 | Sullivan | Tennessee | 47163 | 29844 | 483 |
2023972 | 2023972 | 2021-12-17 | Sullivan | Tennessee | 47163 | 29844 | 483 |
2020721 | 2020721 | 2021-12-16 | Sullivan | Tennessee | 47163 | 29766 | 482 |
2017470 | 2017470 | 2021-12-15 | Sullivan | Tennessee | 47163 | 29707 | 477 |
2014220 | 2014220 | 2021-12-14 | Sullivan | Tennessee | 47163 | 29606 | 474 |
2010969 | 2010969 | 2021-12-13 | Sullivan | Tennessee | 47163 | 29517 | 473 |
2007718 | 2007718 | 2021-12-12 | Sullivan | Tennessee | 47163 | 29321 | 473 |
2004467 | 2004467 | 2021-12-11 | Sullivan | Tennessee | 47163 | 29321 | 473 |
2001216 | 2001216 | 2021-12-10 | Sullivan | Tennessee | 47163 | 29321 | 473 |
1997966 | 1997966 | 2021-12-09 | Sullivan | Tennessee | 47163 | 29125 | 468 |
1994715 | 1994715 | 2021-12-08 | Sullivan | Tennessee | 47163 | 29125 | 468 |
1991464 | 1991464 | 2021-12-07 | Sullivan | Tennessee | 47163 | 29044 | 467 |
1988213 | 1988213 | 2021-12-06 | Sullivan | Tennessee | 47163 | 28941 | 462 |
1984963 | 1984963 | 2021-12-05 | Sullivan | Tennessee | 47163 | 28750 | 459 |
1981713 | 1981713 | 2021-12-04 | Sullivan | Tennessee | 47163 | 28750 | 459 |
1978463 | 1978463 | 2021-12-03 | Sullivan | Tennessee | 47163 | 28750 | 459 |
1975213 | 1975213 | 2021-12-02 | Sullivan | Tennessee | 47163 | 28650 | 457 |
1971964 | 1971964 | 2021-12-01 | Sullivan | Tennessee | 47163 | 28531 | 452 |
1968714 | 1968714 | 2021-11-30 | Sullivan | Tennessee | 47163 | 28437 | 451 |
1965463 | 1965463 | 2021-11-29 | Sullivan | Tennessee | 47163 | 28290 | 449 |
1962211 | 1962211 | 2021-11-28 | Sullivan | Tennessee | 47163 | 28002 | 447 |
1958960 | 1958960 | 2021-11-27 | Sullivan | Tennessee | 47163 | 28002 | 447 |
1955709 | 1955709 | 2021-11-26 | Sullivan | Tennessee | 47163 | 28002 | 447 |
1952458 | 1952458 | 2021-11-25 | Sullivan | Tennessee | 47163 | 28002 | 447 |
1949207 | 1949207 | 2021-11-24 | Sullivan | Tennessee | 47163 | 28002 | 447 |
1945956 | 1945956 | 2021-11-23 | Sullivan | Tennessee | 47163 | 27933 | 443 |
1942705 | 1942705 | 2021-11-22 | Sullivan | Tennessee | 47163 | 27828 | 443 |
1939455 | 1939455 | 2021-11-21 | Sullivan | Tennessee | 47163 | 27710 | 439 |
1936205 | 1936205 | 2021-11-20 | Sullivan | Tennessee | 47163 | 27710 | 439 |
1932955 | 1932955 | 2021-11-19 | Sullivan | Tennessee | 47163 | 27710 | 439 |
1929704 | 1929704 | 2021-11-18 | Sullivan | Tennessee | 47163 | 27641 | 441 |
1926454 | 1926454 | 2021-11-17 | Sullivan | Tennessee | 47163 | 27582 | 439 |
1923204 | 1923204 | 2021-11-16 | Sullivan | Tennessee | 47163 | 27498 | 439 |
1919955 | 1919955 | 2021-11-15 | Sullivan | Tennessee | 47163 | 27450 | 438 |
1916705 | 1916705 | 2021-11-14 | Sullivan | Tennessee | 47163 | 27327 | 438 |
1913455 | 1913455 | 2021-11-13 | Sullivan | Tennessee | 47163 | 27327 | 438 |
1910205 | 1910205 | 2021-11-12 | Sullivan | Tennessee | 47163 | 27327 | 438 |
1906956 | 1906956 | 2021-11-11 | Sullivan | Tennessee | 47163 | 27229 | 436 |
1903707 | 1903707 | 2021-11-10 | Sullivan | Tennessee | 47163 | 27229 | 436 |
1900457 | 1900457 | 2021-11-09 | Sullivan | Tennessee | 47163 | 27201 | 433 |
1897207 | 1897207 | 2021-11-08 | Sullivan | Tennessee | 47163 | 27034 | 430 |
1893957 | 1893957 | 2021-11-07 | Sullivan | Tennessee | 47163 | 27034 | 430 |
1890707 | 1890707 | 2021-11-06 | Sullivan | Tennessee | 47163 | 27034 | 430 |
1887457 | 1887457 | 2021-11-05 | Sullivan | Tennessee | 47163 | 27034 | 430 |
1884207 | 1884207 | 2021-11-04 | Sullivan | Tennessee | 47163 | 27006 | 429 |
1880958 | 1880958 | 2021-11-03 | Sullivan | Tennessee | 47163 | 26961 | 428 |
1877709 | 1877709 | 2021-11-02 | Sullivan | Tennessee | 47163 | 26930 | 428 |
1874460 | 1874460 | 2021-11-01 | Sullivan | Tennessee | 47163 | 26816 | 427 |
1871211 | 1871211 | 2021-10-31 | Sullivan | Tennessee | 47163 | 26816 | 427 |
1867962 | 1867962 | 2021-10-30 | Sullivan | Tennessee | 47163 | 26816 | 427 |
1864713 | 1864713 | 2021-10-29 | Sullivan | Tennessee | 47163 | 26816 | 427 |
1861464 | 1861464 | 2021-10-28 | Sullivan | Tennessee | 47163 | 26786 | 424 |
1858215 | 1858215 | 2021-10-27 | Sullivan | Tennessee | 47163 | 26722 | 424 |
1854966 | 1854966 | 2021-10-26 | Sullivan | Tennessee | 47163 | 26681 | 424 |
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);