ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "White" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2111753 | 2111753 | 2022-01-13 | White | Tennessee | 47185 | 6231 | 115 |
2108501 | 2108501 | 2022-01-12 | White | Tennessee | 47185 | 6231 | 115 |
2105250 | 2105250 | 2022-01-11 | White | Tennessee | 47185 | 6071 | 115 |
2101999 | 2101999 | 2022-01-10 | White | Tennessee | 47185 | 6071 | 115 |
2098748 | 2098748 | 2022-01-09 | White | Tennessee | 47185 | 6071 | 115 |
2095496 | 2095496 | 2022-01-08 | White | Tennessee | 47185 | 6071 | 115 |
2092244 | 2092244 | 2022-01-07 | White | Tennessee | 47185 | 6071 | 115 |
2088992 | 2088992 | 2022-01-06 | White | Tennessee | 47185 | 6071 | 115 |
2085741 | 2085741 | 2022-01-05 | White | Tennessee | 47185 | 6071 | 115 |
2082489 | 2082489 | 2022-01-04 | White | Tennessee | 47185 | 6071 | 115 |
2079237 | 2079237 | 2022-01-03 | White | Tennessee | 47185 | 6054 | 115 |
2075986 | 2075986 | 2022-01-02 | White | Tennessee | 47185 | 5978 | 115 |
2072735 | 2072735 | 2022-01-01 | White | Tennessee | 47185 | 5978 | 115 |
2069484 | 2069484 | 2021-12-31 | White | Tennessee | 47185 | 5978 | 115 |
2066233 | 2066233 | 2021-12-30 | White | Tennessee | 47185 | 5978 | 115 |
2062983 | 2062983 | 2021-12-29 | White | Tennessee | 47185 | 5958 | 115 |
2059733 | 2059733 | 2021-12-28 | White | Tennessee | 47185 | 5934 | 115 |
2056484 | 2056484 | 2021-12-27 | White | Tennessee | 47185 | 5922 | 114 |
2053235 | 2053235 | 2021-12-26 | White | Tennessee | 47185 | 5905 | 114 |
2049985 | 2049985 | 2021-12-25 | White | Tennessee | 47185 | 5905 | 114 |
2046735 | 2046735 | 2021-12-24 | White | Tennessee | 47185 | 5905 | 114 |
2043485 | 2043485 | 2021-12-23 | White | Tennessee | 47185 | 5905 | 114 |
2040236 | 2040236 | 2021-12-22 | White | Tennessee | 47185 | 5885 | 104 |
2036986 | 2036986 | 2021-12-21 | White | Tennessee | 47185 | 5878 | 104 |
2033736 | 2033736 | 2021-12-20 | White | Tennessee | 47185 | 5872 | 103 |
2030486 | 2030486 | 2021-12-19 | White | Tennessee | 47185 | 5860 | 103 |
2027235 | 2027235 | 2021-12-18 | White | Tennessee | 47185 | 5860 | 103 |
2023984 | 2023984 | 2021-12-17 | White | Tennessee | 47185 | 5860 | 103 |
2020733 | 2020733 | 2021-12-16 | White | Tennessee | 47185 | 5855 | 103 |
2017482 | 2017482 | 2021-12-15 | White | Tennessee | 47185 | 5846 | 103 |
2014232 | 2014232 | 2021-12-14 | White | Tennessee | 47185 | 5838 | 103 |
2010981 | 2010981 | 2021-12-13 | White | Tennessee | 47185 | 5830 | 102 |
2007730 | 2007730 | 2021-12-12 | White | Tennessee | 47185 | 5825 | 102 |
2004479 | 2004479 | 2021-12-11 | White | Tennessee | 47185 | 5825 | 102 |
2001228 | 2001228 | 2021-12-10 | White | Tennessee | 47185 | 5825 | 102 |
1997978 | 1997978 | 2021-12-09 | White | Tennessee | 47185 | 5817 | 101 |
1994727 | 1994727 | 2021-12-08 | White | Tennessee | 47185 | 5817 | 101 |
1991476 | 1991476 | 2021-12-07 | White | Tennessee | 47185 | 5814 | 100 |
1988225 | 1988225 | 2021-12-06 | White | Tennessee | 47185 | 5809 | 98 |
1984975 | 1984975 | 2021-12-05 | White | Tennessee | 47185 | 5791 | 98 |
1981725 | 1981725 | 2021-12-04 | White | Tennessee | 47185 | 5791 | 98 |
1978475 | 1978475 | 2021-12-03 | White | Tennessee | 47185 | 5791 | 98 |
1975225 | 1975225 | 2021-12-02 | White | Tennessee | 47185 | 5787 | 98 |
1971976 | 1971976 | 2021-12-01 | White | Tennessee | 47185 | 5771 | 98 |
1968726 | 1968726 | 2021-11-30 | White | Tennessee | 47185 | 5758 | 98 |
1965475 | 1965475 | 2021-11-29 | White | Tennessee | 47185 | 5751 | 98 |
1962223 | 1962223 | 2021-11-28 | White | Tennessee | 47185 | 5730 | 98 |
1958972 | 1958972 | 2021-11-27 | White | Tennessee | 47185 | 5730 | 98 |
1955721 | 1955721 | 2021-11-26 | White | Tennessee | 47185 | 5730 | 98 |
1952470 | 1952470 | 2021-11-25 | White | Tennessee | 47185 | 5730 | 98 |
1949219 | 1949219 | 2021-11-24 | White | Tennessee | 47185 | 5730 | 98 |
1945968 | 1945968 | 2021-11-23 | White | Tennessee | 47185 | 5728 | 98 |
1942717 | 1942717 | 2021-11-22 | White | Tennessee | 47185 | 5721 | 98 |
1939467 | 1939467 | 2021-11-21 | White | Tennessee | 47185 | 5709 | 98 |
1936217 | 1936217 | 2021-11-20 | White | Tennessee | 47185 | 5709 | 98 |
1932967 | 1932967 | 2021-11-19 | White | Tennessee | 47185 | 5709 | 98 |
1929716 | 1929716 | 2021-11-18 | White | Tennessee | 47185 | 5703 | 98 |
1926466 | 1926466 | 2021-11-17 | White | Tennessee | 47185 | 5698 | 98 |
1923216 | 1923216 | 2021-11-16 | White | Tennessee | 47185 | 5695 | 98 |
1919967 | 1919967 | 2021-11-15 | White | Tennessee | 47185 | 5692 | 98 |
1916717 | 1916717 | 2021-11-14 | White | Tennessee | 47185 | 5684 | 98 |
1913467 | 1913467 | 2021-11-13 | White | Tennessee | 47185 | 5684 | 98 |
1910217 | 1910217 | 2021-11-12 | White | Tennessee | 47185 | 5684 | 98 |
1906968 | 1906968 | 2021-11-11 | White | Tennessee | 47185 | 5672 | 98 |
1903719 | 1903719 | 2021-11-10 | White | Tennessee | 47185 | 5672 | 98 |
1900469 | 1900469 | 2021-11-09 | White | Tennessee | 47185 | 5669 | 98 |
1897219 | 1897219 | 2021-11-08 | White | Tennessee | 47185 | 5658 | 98 |
1893969 | 1893969 | 2021-11-07 | White | Tennessee | 47185 | 5658 | 98 |
1890719 | 1890719 | 2021-11-06 | White | Tennessee | 47185 | 5658 | 98 |
1887469 | 1887469 | 2021-11-05 | White | Tennessee | 47185 | 5658 | 98 |
1884219 | 1884219 | 2021-11-04 | White | Tennessee | 47185 | 5657 | 98 |
1880970 | 1880970 | 2021-11-03 | White | Tennessee | 47185 | 5648 | 98 |
1877721 | 1877721 | 2021-11-02 | White | Tennessee | 47185 | 5644 | 97 |
1874472 | 1874472 | 2021-11-01 | White | Tennessee | 47185 | 5633 | 97 |
1871223 | 1871223 | 2021-10-31 | White | Tennessee | 47185 | 5633 | 97 |
1867974 | 1867974 | 2021-10-30 | White | Tennessee | 47185 | 5633 | 97 |
1864725 | 1864725 | 2021-10-29 | White | Tennessee | 47185 | 5633 | 97 |
1861476 | 1861476 | 2021-10-28 | White | Tennessee | 47185 | 5631 | 97 |
1858227 | 1858227 | 2021-10-27 | White | Tennessee | 47185 | 5622 | 97 |
1854978 | 1854978 | 2021-10-26 | White | Tennessee | 47185 | 5620 | 97 |
1851729 | 1851729 | 2021-10-25 | White | Tennessee | 47185 | 5604 | 96 |
1848479 | 1848479 | 2021-10-24 | White | Tennessee | 47185 | 5604 | 96 |
1845229 | 1845229 | 2021-10-23 | White | Tennessee | 47185 | 5604 | 96 |
1841979 | 1841979 | 2021-10-22 | White | Tennessee | 47185 | 5604 | 96 |
1838730 | 1838730 | 2021-10-21 | White | Tennessee | 47185 | 5597 | 95 |
1835481 | 1835481 | 2021-10-20 | White | Tennessee | 47185 | 5581 | 95 |
1832232 | 1832232 | 2021-10-19 | White | Tennessee | 47185 | 5571 | 95 |
1828983 | 1828983 | 2021-10-18 | White | Tennessee | 47185 | 5565 | 95 |
1825734 | 1825734 | 2021-10-17 | White | Tennessee | 47185 | 5551 | 95 |
1822485 | 1822485 | 2021-10-16 | White | Tennessee | 47185 | 5551 | 95 |
1819236 | 1819236 | 2021-10-15 | White | Tennessee | 47185 | 5551 | 95 |
1815987 | 1815987 | 2021-10-14 | White | Tennessee | 47185 | 5544 | 95 |
1812739 | 1812739 | 2021-10-13 | White | Tennessee | 47185 | 5528 | 95 |
1809490 | 1809490 | 2021-10-12 | White | Tennessee | 47185 | 5525 | 95 |
1806240 | 1806240 | 2021-10-11 | White | Tennessee | 47185 | 5501 | 92 |
1802990 | 1802990 | 2021-10-10 | White | Tennessee | 47185 | 5451 | 92 |
1799741 | 1799741 | 2021-10-09 | White | Tennessee | 47185 | 5451 | 92 |
1796492 | 1796492 | 2021-10-08 | White | Tennessee | 47185 | 5451 | 92 |
1793243 | 1793243 | 2021-10-07 | White | Tennessee | 47185 | 5428 | 92 |
1789994 | 1789994 | 2021-10-06 | White | Tennessee | 47185 | 5415 | 92 |
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);