ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Fayette" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176750 | 2176750 | 2022-02-02 | Fayette | Tennessee | 47047 | 10727 | 149 |
2173496 | 2173496 | 2022-02-01 | Fayette | Tennessee | 47047 | 10366 | 142 |
2170244 | 2170244 | 2022-01-31 | Fayette | Tennessee | 47047 | 10366 | 142 |
2166990 | 2166990 | 2022-01-30 | Fayette | Tennessee | 47047 | 10366 | 142 |
2163735 | 2163735 | 2022-01-29 | Fayette | Tennessee | 47047 | 10366 | 142 |
2160480 | 2160480 | 2022-01-28 | Fayette | Tennessee | 47047 | 10366 | 142 |
2157224 | 2157224 | 2022-01-27 | Fayette | Tennessee | 47047 | 10366 | 142 |
2153971 | 2153971 | 2022-01-26 | Fayette | Tennessee | 47047 | 10366 | 142 |
2150719 | 2150719 | 2022-01-25 | Fayette | Tennessee | 47047 | 9900 | 141 |
2147467 | 2147467 | 2022-01-24 | Fayette | Tennessee | 47047 | 9900 | 141 |
2144213 | 2144213 | 2022-01-23 | Fayette | Tennessee | 47047 | 9900 | 141 |
2140958 | 2140958 | 2022-01-22 | Fayette | Tennessee | 47047 | 9900 | 141 |
2137702 | 2137702 | 2022-01-21 | Fayette | Tennessee | 47047 | 9900 | 141 |
2134448 | 2134448 | 2022-01-20 | Fayette | Tennessee | 47047 | 9900 | 141 |
2131196 | 2131196 | 2022-01-19 | Fayette | Tennessee | 47047 | 9900 | 141 |
2127942 | 2127942 | 2022-01-18 | Fayette | Tennessee | 47047 | 9303 | 135 |
2124690 | 2124690 | 2022-01-17 | Fayette | Tennessee | 47047 | 9303 | 135 |
2121438 | 2121438 | 2022-01-16 | Fayette | Tennessee | 47047 | 9303 | 135 |
2118186 | 2118186 | 2022-01-15 | Fayette | Tennessee | 47047 | 9303 | 135 |
2114935 | 2114935 | 2022-01-14 | Fayette | Tennessee | 47047 | 9303 | 135 |
2111683 | 2111683 | 2022-01-13 | Fayette | Tennessee | 47047 | 9303 | 135 |
2108431 | 2108431 | 2022-01-12 | Fayette | Tennessee | 47047 | 9303 | 135 |
2105180 | 2105180 | 2022-01-11 | Fayette | Tennessee | 47047 | 8742 | 135 |
2101929 | 2101929 | 2022-01-10 | Fayette | Tennessee | 47047 | 8742 | 135 |
2098678 | 2098678 | 2022-01-09 | Fayette | Tennessee | 47047 | 8742 | 135 |
2095426 | 2095426 | 2022-01-08 | Fayette | Tennessee | 47047 | 8742 | 135 |
2092174 | 2092174 | 2022-01-07 | Fayette | Tennessee | 47047 | 8742 | 135 |
2088922 | 2088922 | 2022-01-06 | Fayette | Tennessee | 47047 | 8742 | 135 |
2085671 | 2085671 | 2022-01-05 | Fayette | Tennessee | 47047 | 8742 | 135 |
2082419 | 2082419 | 2022-01-04 | Fayette | Tennessee | 47047 | 8742 | 135 |
2079167 | 2079167 | 2022-01-03 | Fayette | Tennessee | 47047 | 8695 | 134 |
2075916 | 2075916 | 2022-01-02 | Fayette | Tennessee | 47047 | 8248 | 133 |
2072665 | 2072665 | 2022-01-01 | Fayette | Tennessee | 47047 | 8248 | 133 |
2069414 | 2069414 | 2021-12-31 | Fayette | Tennessee | 47047 | 8248 | 133 |
2066163 | 2066163 | 2021-12-30 | Fayette | Tennessee | 47047 | 8248 | 133 |
2062913 | 2062913 | 2021-12-29 | Fayette | Tennessee | 47047 | 8100 | 131 |
2059663 | 2059663 | 2021-12-28 | Fayette | Tennessee | 47047 | 7979 | 131 |
2056414 | 2056414 | 2021-12-27 | Fayette | Tennessee | 47047 | 7932 | 131 |
2053165 | 2053165 | 2021-12-26 | Fayette | Tennessee | 47047 | 7778 | 130 |
2049915 | 2049915 | 2021-12-25 | Fayette | Tennessee | 47047 | 7778 | 130 |
2046665 | 2046665 | 2021-12-24 | Fayette | Tennessee | 47047 | 7778 | 130 |
2043415 | 2043415 | 2021-12-23 | Fayette | Tennessee | 47047 | 7778 | 130 |
2040166 | 2040166 | 2021-12-22 | Fayette | Tennessee | 47047 | 7727 | 116 |
2036916 | 2036916 | 2021-12-21 | Fayette | Tennessee | 47047 | 7695 | 116 |
2033666 | 2033666 | 2021-12-20 | Fayette | Tennessee | 47047 | 7676 | 112 |
2030416 | 2030416 | 2021-12-19 | Fayette | Tennessee | 47047 | 7642 | 110 |
2027165 | 2027165 | 2021-12-18 | Fayette | Tennessee | 47047 | 7642 | 110 |
2023914 | 2023914 | 2021-12-17 | Fayette | Tennessee | 47047 | 7642 | 110 |
2020663 | 2020663 | 2021-12-16 | Fayette | Tennessee | 47047 | 7629 | 110 |
2017412 | 2017412 | 2021-12-15 | Fayette | Tennessee | 47047 | 7604 | 110 |
2014162 | 2014162 | 2021-12-14 | Fayette | Tennessee | 47047 | 7592 | 110 |
2010911 | 2010911 | 2021-12-13 | Fayette | Tennessee | 47047 | 7588 | 110 |
2007660 | 2007660 | 2021-12-12 | Fayette | Tennessee | 47047 | 7569 | 110 |
2004409 | 2004409 | 2021-12-11 | Fayette | Tennessee | 47047 | 7569 | 110 |
2001158 | 2001158 | 2021-12-10 | Fayette | Tennessee | 47047 | 7569 | 110 |
1997908 | 1997908 | 2021-12-09 | Fayette | Tennessee | 47047 | 7551 | 112 |
1994657 | 1994657 | 2021-12-08 | Fayette | Tennessee | 47047 | 7551 | 112 |
1991406 | 1991406 | 2021-12-07 | Fayette | Tennessee | 47047 | 7533 | 112 |
1988155 | 1988155 | 2021-12-06 | Fayette | Tennessee | 47047 | 7520 | 112 |
1984905 | 1984905 | 2021-12-05 | Fayette | Tennessee | 47047 | 7501 | 112 |
1981655 | 1981655 | 2021-12-04 | Fayette | Tennessee | 47047 | 7501 | 112 |
1978405 | 1978405 | 2021-12-03 | Fayette | Tennessee | 47047 | 7501 | 112 |
1975155 | 1975155 | 2021-12-02 | Fayette | Tennessee | 47047 | 7483 | 111 |
1971906 | 1971906 | 2021-12-01 | Fayette | Tennessee | 47047 | 7470 | 111 |
1968656 | 1968656 | 2021-11-30 | Fayette | Tennessee | 47047 | 7460 | 110 |
1965405 | 1965405 | 2021-11-29 | Fayette | Tennessee | 47047 | 7455 | 109 |
1962153 | 1962153 | 2021-11-28 | Fayette | Tennessee | 47047 | 7432 | 108 |
1958902 | 1958902 | 2021-11-27 | Fayette | Tennessee | 47047 | 7432 | 108 |
1955651 | 1955651 | 2021-11-26 | Fayette | Tennessee | 47047 | 7432 | 108 |
1952400 | 1952400 | 2021-11-25 | Fayette | Tennessee | 47047 | 7432 | 108 |
1949149 | 1949149 | 2021-11-24 | Fayette | Tennessee | 47047 | 7432 | 108 |
1945898 | 1945898 | 2021-11-23 | Fayette | Tennessee | 47047 | 7432 | 108 |
1942647 | 1942647 | 2021-11-22 | Fayette | Tennessee | 47047 | 7428 | 108 |
1939397 | 1939397 | 2021-11-21 | Fayette | Tennessee | 47047 | 7414 | 108 |
1936147 | 1936147 | 2021-11-20 | Fayette | Tennessee | 47047 | 7414 | 108 |
1932897 | 1932897 | 2021-11-19 | Fayette | Tennessee | 47047 | 7414 | 108 |
1929646 | 1929646 | 2021-11-18 | Fayette | Tennessee | 47047 | 7401 | 108 |
1926396 | 1926396 | 2021-11-17 | Fayette | Tennessee | 47047 | 7390 | 108 |
1923146 | 1923146 | 2021-11-16 | Fayette | Tennessee | 47047 | 7380 | 108 |
1919897 | 1919897 | 2021-11-15 | Fayette | Tennessee | 47047 | 7376 | 108 |
1916647 | 1916647 | 2021-11-14 | Fayette | Tennessee | 47047 | 7371 | 108 |
1913397 | 1913397 | 2021-11-13 | Fayette | Tennessee | 47047 | 7371 | 108 |
1910147 | 1910147 | 2021-11-12 | Fayette | Tennessee | 47047 | 7371 | 108 |
1906898 | 1906898 | 2021-11-11 | Fayette | Tennessee | 47047 | 7361 | 108 |
1903649 | 1903649 | 2021-11-10 | Fayette | Tennessee | 47047 | 7361 | 108 |
1900399 | 1900399 | 2021-11-09 | Fayette | Tennessee | 47047 | 7350 | 108 |
1897149 | 1897149 | 2021-11-08 | Fayette | Tennessee | 47047 | 7335 | 108 |
1893899 | 1893899 | 2021-11-07 | Fayette | Tennessee | 47047 | 7335 | 108 |
1890649 | 1890649 | 2021-11-06 | Fayette | Tennessee | 47047 | 7335 | 108 |
1887399 | 1887399 | 2021-11-05 | Fayette | Tennessee | 47047 | 7335 | 108 |
1884149 | 1884149 | 2021-11-04 | Fayette | Tennessee | 47047 | 7331 | 108 |
1880900 | 1880900 | 2021-11-03 | Fayette | Tennessee | 47047 | 7327 | 106 |
1877651 | 1877651 | 2021-11-02 | Fayette | Tennessee | 47047 | 7319 | 106 |
1874402 | 1874402 | 2021-11-01 | Fayette | Tennessee | 47047 | 7308 | 106 |
1871153 | 1871153 | 2021-10-31 | Fayette | Tennessee | 47047 | 7308 | 106 |
1867904 | 1867904 | 2021-10-30 | Fayette | Tennessee | 47047 | 7308 | 106 |
1864655 | 1864655 | 2021-10-29 | Fayette | Tennessee | 47047 | 7308 | 106 |
1861406 | 1861406 | 2021-10-28 | Fayette | Tennessee | 47047 | 7300 | 106 |
1858157 | 1858157 | 2021-10-27 | Fayette | Tennessee | 47047 | 7296 | 106 |
1854908 | 1854908 | 2021-10-26 | Fayette | Tennessee | 47047 | 7287 | 106 |
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);