ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 47021 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176737 | 2176737 | 2022-02-02 | Cheatham | Tennessee | 47021 | 10182 | 106 |
2173483 | 2173483 | 2022-02-01 | Cheatham | Tennessee | 47021 | 9678 | 104 |
2170231 | 2170231 | 2022-01-31 | Cheatham | Tennessee | 47021 | 9678 | 104 |
2166977 | 2166977 | 2022-01-30 | Cheatham | Tennessee | 47021 | 9678 | 104 |
2163722 | 2163722 | 2022-01-29 | Cheatham | Tennessee | 47021 | 9678 | 104 |
2160467 | 2160467 | 2022-01-28 | Cheatham | Tennessee | 47021 | 9678 | 104 |
2157211 | 2157211 | 2022-01-27 | Cheatham | Tennessee | 47021 | 9678 | 104 |
2153958 | 2153958 | 2022-01-26 | Cheatham | Tennessee | 47021 | 9678 | 104 |
2150706 | 2150706 | 2022-01-25 | Cheatham | Tennessee | 47021 | 9118 | 100 |
2147454 | 2147454 | 2022-01-24 | Cheatham | Tennessee | 47021 | 9118 | 100 |
2144200 | 2144200 | 2022-01-23 | Cheatham | Tennessee | 47021 | 9118 | 100 |
2140945 | 2140945 | 2022-01-22 | Cheatham | Tennessee | 47021 | 9118 | 100 |
2137689 | 2137689 | 2022-01-21 | Cheatham | Tennessee | 47021 | 9118 | 100 |
2134435 | 2134435 | 2022-01-20 | Cheatham | Tennessee | 47021 | 9118 | 100 |
2131183 | 2131183 | 2022-01-19 | Cheatham | Tennessee | 47021 | 9118 | 100 |
2127929 | 2127929 | 2022-01-18 | Cheatham | Tennessee | 47021 | 8399 | 93 |
2124677 | 2124677 | 2022-01-17 | Cheatham | Tennessee | 47021 | 8399 | 93 |
2121425 | 2121425 | 2022-01-16 | Cheatham | Tennessee | 47021 | 8399 | 93 |
2118173 | 2118173 | 2022-01-15 | Cheatham | Tennessee | 47021 | 8399 | 93 |
2114922 | 2114922 | 2022-01-14 | Cheatham | Tennessee | 47021 | 8399 | 93 |
2111670 | 2111670 | 2022-01-13 | Cheatham | Tennessee | 47021 | 8399 | 93 |
2108418 | 2108418 | 2022-01-12 | Cheatham | Tennessee | 47021 | 8399 | 93 |
2105167 | 2105167 | 2022-01-11 | Cheatham | Tennessee | 47021 | 7957 | 92 |
2101916 | 2101916 | 2022-01-10 | Cheatham | Tennessee | 47021 | 7957 | 92 |
2098665 | 2098665 | 2022-01-09 | Cheatham | Tennessee | 47021 | 7957 | 92 |
2095413 | 2095413 | 2022-01-08 | Cheatham | Tennessee | 47021 | 7957 | 92 |
2092161 | 2092161 | 2022-01-07 | Cheatham | Tennessee | 47021 | 7957 | 92 |
2088909 | 2088909 | 2022-01-06 | Cheatham | Tennessee | 47021 | 7957 | 92 |
2085658 | 2085658 | 2022-01-05 | Cheatham | Tennessee | 47021 | 7957 | 92 |
2082406 | 2082406 | 2022-01-04 | Cheatham | Tennessee | 47021 | 7957 | 92 |
2079154 | 2079154 | 2022-01-03 | Cheatham | Tennessee | 47021 | 7917 | 92 |
2075903 | 2075903 | 2022-01-02 | Cheatham | Tennessee | 47021 | 7700 | 90 |
2072652 | 2072652 | 2022-01-01 | Cheatham | Tennessee | 47021 | 7700 | 90 |
2069401 | 2069401 | 2021-12-31 | Cheatham | Tennessee | 47021 | 7700 | 90 |
2066150 | 2066150 | 2021-12-30 | Cheatham | Tennessee | 47021 | 7700 | 90 |
2062900 | 2062900 | 2021-12-29 | Cheatham | Tennessee | 47021 | 7614 | 90 |
2059650 | 2059650 | 2021-12-28 | Cheatham | Tennessee | 47021 | 7535 | 90 |
2056401 | 2056401 | 2021-12-27 | Cheatham | Tennessee | 47021 | 7517 | 90 |
2053152 | 2053152 | 2021-12-26 | Cheatham | Tennessee | 47021 | 7455 | 88 |
2049902 | 2049902 | 2021-12-25 | Cheatham | Tennessee | 47021 | 7455 | 88 |
2046652 | 2046652 | 2021-12-24 | Cheatham | Tennessee | 47021 | 7455 | 88 |
2043402 | 2043402 | 2021-12-23 | Cheatham | Tennessee | 47021 | 7455 | 88 |
2040153 | 2040153 | 2021-12-22 | Cheatham | Tennessee | 47021 | 7430 | 80 |
2036903 | 2036903 | 2021-12-21 | Cheatham | Tennessee | 47021 | 7416 | 80 |
2033653 | 2033653 | 2021-12-20 | Cheatham | Tennessee | 47021 | 7405 | 80 |
2030403 | 2030403 | 2021-12-19 | Cheatham | Tennessee | 47021 | 7375 | 79 |
2027152 | 2027152 | 2021-12-18 | Cheatham | Tennessee | 47021 | 7375 | 79 |
2023901 | 2023901 | 2021-12-17 | Cheatham | Tennessee | 47021 | 7375 | 79 |
2020650 | 2020650 | 2021-12-16 | Cheatham | Tennessee | 47021 | 7364 | 79 |
2017399 | 2017399 | 2021-12-15 | Cheatham | Tennessee | 47021 | 7351 | 79 |
2014149 | 2014149 | 2021-12-14 | Cheatham | Tennessee | 47021 | 7348 | 77 |
2010898 | 2010898 | 2021-12-13 | Cheatham | Tennessee | 47021 | 7333 | 77 |
2007647 | 2007647 | 2021-12-12 | Cheatham | Tennessee | 47021 | 7313 | 77 |
2004396 | 2004396 | 2021-12-11 | Cheatham | Tennessee | 47021 | 7313 | 77 |
2001145 | 2001145 | 2021-12-10 | Cheatham | Tennessee | 47021 | 7313 | 77 |
1997895 | 1997895 | 2021-12-09 | Cheatham | Tennessee | 47021 | 7293 | 77 |
1994644 | 1994644 | 2021-12-08 | Cheatham | Tennessee | 47021 | 7293 | 77 |
1991393 | 1991393 | 2021-12-07 | Cheatham | Tennessee | 47021 | 7278 | 77 |
1988142 | 1988142 | 2021-12-06 | Cheatham | Tennessee | 47021 | 7274 | 77 |
1984892 | 1984892 | 2021-12-05 | Cheatham | Tennessee | 47021 | 7251 | 77 |
1981642 | 1981642 | 2021-12-04 | Cheatham | Tennessee | 47021 | 7251 | 77 |
1978392 | 1978392 | 2021-12-03 | Cheatham | Tennessee | 47021 | 7251 | 77 |
1975142 | 1975142 | 2021-12-02 | Cheatham | Tennessee | 47021 | 7231 | 77 |
1971893 | 1971893 | 2021-12-01 | Cheatham | Tennessee | 47021 | 7207 | 77 |
1968643 | 1968643 | 2021-11-30 | Cheatham | Tennessee | 47021 | 7190 | 77 |
1965392 | 1965392 | 2021-11-29 | Cheatham | Tennessee | 47021 | 7173 | 77 |
1962140 | 1962140 | 2021-11-28 | Cheatham | Tennessee | 47021 | 7135 | 77 |
1958889 | 1958889 | 2021-11-27 | Cheatham | Tennessee | 47021 | 7135 | 77 |
1955638 | 1955638 | 2021-11-26 | Cheatham | Tennessee | 47021 | 7135 | 77 |
1952387 | 1952387 | 2021-11-25 | Cheatham | Tennessee | 47021 | 7135 | 77 |
1949136 | 1949136 | 2021-11-24 | Cheatham | Tennessee | 47021 | 7135 | 77 |
1945885 | 1945885 | 2021-11-23 | Cheatham | Tennessee | 47021 | 7131 | 76 |
1942634 | 1942634 | 2021-11-22 | Cheatham | Tennessee | 47021 | 7120 | 76 |
1939384 | 1939384 | 2021-11-21 | Cheatham | Tennessee | 47021 | 7096 | 76 |
1936134 | 1936134 | 2021-11-20 | Cheatham | Tennessee | 47021 | 7096 | 76 |
1932884 | 1932884 | 2021-11-19 | Cheatham | Tennessee | 47021 | 7096 | 76 |
1929633 | 1929633 | 2021-11-18 | Cheatham | Tennessee | 47021 | 7096 | 76 |
1926383 | 1926383 | 2021-11-17 | Cheatham | Tennessee | 47021 | 7092 | 76 |
1923133 | 1923133 | 2021-11-16 | Cheatham | Tennessee | 47021 | 7090 | 76 |
1919884 | 1919884 | 2021-11-15 | Cheatham | Tennessee | 47021 | 7083 | 75 |
1916634 | 1916634 | 2021-11-14 | Cheatham | Tennessee | 47021 | 7072 | 75 |
1913384 | 1913384 | 2021-11-13 | Cheatham | Tennessee | 47021 | 7072 | 75 |
1910134 | 1910134 | 2021-11-12 | Cheatham | Tennessee | 47021 | 7072 | 75 |
1906885 | 1906885 | 2021-11-11 | Cheatham | Tennessee | 47021 | 7065 | 75 |
1903636 | 1903636 | 2021-11-10 | Cheatham | Tennessee | 47021 | 7065 | 75 |
1900386 | 1900386 | 2021-11-09 | Cheatham | Tennessee | 47021 | 7051 | 75 |
1897136 | 1897136 | 2021-11-08 | Cheatham | Tennessee | 47021 | 7036 | 71 |
1893886 | 1893886 | 2021-11-07 | Cheatham | Tennessee | 47021 | 7036 | 71 |
1890636 | 1890636 | 2021-11-06 | Cheatham | Tennessee | 47021 | 7036 | 71 |
1887386 | 1887386 | 2021-11-05 | Cheatham | Tennessee | 47021 | 7036 | 71 |
1884136 | 1884136 | 2021-11-04 | Cheatham | Tennessee | 47021 | 7034 | 71 |
1880887 | 1880887 | 2021-11-03 | Cheatham | Tennessee | 47021 | 7025 | 71 |
1877638 | 1877638 | 2021-11-02 | Cheatham | Tennessee | 47021 | 7021 | 70 |
1874389 | 1874389 | 2021-11-01 | Cheatham | Tennessee | 47021 | 7015 | 70 |
1871140 | 1871140 | 2021-10-31 | Cheatham | Tennessee | 47021 | 7015 | 70 |
1867891 | 1867891 | 2021-10-30 | Cheatham | Tennessee | 47021 | 7015 | 70 |
1864642 | 1864642 | 2021-10-29 | Cheatham | Tennessee | 47021 | 7015 | 70 |
1861393 | 1861393 | 2021-10-28 | Cheatham | Tennessee | 47021 | 7010 | 70 |
1858144 | 1858144 | 2021-10-27 | Cheatham | Tennessee | 47021 | 6999 | 70 |
1854895 | 1854895 | 2021-10-26 | Cheatham | Tennessee | 47021 | 6994 | 70 |
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);