ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Jefferson" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176771 | 2176771 | 2022-02-02 | Jefferson | Tennessee | 47089 | 14227 | 232 |
2173517 | 2173517 | 2022-02-01 | Jefferson | Tennessee | 47089 | 13394 | 229 |
2170265 | 2170265 | 2022-01-31 | Jefferson | Tennessee | 47089 | 13394 | 229 |
2167011 | 2167011 | 2022-01-30 | Jefferson | Tennessee | 47089 | 13394 | 229 |
2163756 | 2163756 | 2022-01-29 | Jefferson | Tennessee | 47089 | 13394 | 229 |
2160501 | 2160501 | 2022-01-28 | Jefferson | Tennessee | 47089 | 13394 | 229 |
2157245 | 2157245 | 2022-01-27 | Jefferson | Tennessee | 47089 | 13394 | 229 |
2153992 | 2153992 | 2022-01-26 | Jefferson | Tennessee | 47089 | 13394 | 229 |
2150740 | 2150740 | 2022-01-25 | Jefferson | Tennessee | 47089 | 12371 | 225 |
2147488 | 2147488 | 2022-01-24 | Jefferson | Tennessee | 47089 | 12371 | 225 |
2144234 | 2144234 | 2022-01-23 | Jefferson | Tennessee | 47089 | 12371 | 225 |
2140979 | 2140979 | 2022-01-22 | Jefferson | Tennessee | 47089 | 12371 | 225 |
2137723 | 2137723 | 2022-01-21 | Jefferson | Tennessee | 47089 | 12371 | 225 |
2134469 | 2134469 | 2022-01-20 | Jefferson | Tennessee | 47089 | 12371 | 225 |
2131217 | 2131217 | 2022-01-19 | Jefferson | Tennessee | 47089 | 12371 | 225 |
2127963 | 2127963 | 2022-01-18 | Jefferson | Tennessee | 47089 | 11510 | 217 |
2124711 | 2124711 | 2022-01-17 | Jefferson | Tennessee | 47089 | 11510 | 217 |
2121459 | 2121459 | 2022-01-16 | Jefferson | Tennessee | 47089 | 11510 | 217 |
2118207 | 2118207 | 2022-01-15 | Jefferson | Tennessee | 47089 | 11510 | 217 |
2114956 | 2114956 | 2022-01-14 | Jefferson | Tennessee | 47089 | 11510 | 217 |
2111704 | 2111704 | 2022-01-13 | Jefferson | Tennessee | 47089 | 11510 | 217 |
2108452 | 2108452 | 2022-01-12 | Jefferson | Tennessee | 47089 | 11510 | 217 |
2105201 | 2105201 | 2022-01-11 | Jefferson | Tennessee | 47089 | 11078 | 216 |
2101950 | 2101950 | 2022-01-10 | Jefferson | Tennessee | 47089 | 11078 | 216 |
2098699 | 2098699 | 2022-01-09 | Jefferson | Tennessee | 47089 | 11078 | 216 |
2095447 | 2095447 | 2022-01-08 | Jefferson | Tennessee | 47089 | 11078 | 216 |
2092195 | 2092195 | 2022-01-07 | Jefferson | Tennessee | 47089 | 11078 | 216 |
2088943 | 2088943 | 2022-01-06 | Jefferson | Tennessee | 47089 | 11078 | 216 |
2085692 | 2085692 | 2022-01-05 | Jefferson | Tennessee | 47089 | 11078 | 216 |
2082440 | 2082440 | 2022-01-04 | Jefferson | Tennessee | 47089 | 11078 | 216 |
2079188 | 2079188 | 2022-01-03 | Jefferson | Tennessee | 47089 | 11032 | 216 |
2075937 | 2075937 | 2022-01-02 | Jefferson | Tennessee | 47089 | 10836 | 215 |
2072686 | 2072686 | 2022-01-01 | Jefferson | Tennessee | 47089 | 10836 | 215 |
2069435 | 2069435 | 2021-12-31 | Jefferson | Tennessee | 47089 | 10836 | 215 |
2066184 | 2066184 | 2021-12-30 | Jefferson | Tennessee | 47089 | 10836 | 215 |
2062934 | 2062934 | 2021-12-29 | Jefferson | Tennessee | 47089 | 10776 | 213 |
2059684 | 2059684 | 2021-12-28 | Jefferson | Tennessee | 47089 | 10741 | 213 |
2056435 | 2056435 | 2021-12-27 | Jefferson | Tennessee | 47089 | 10696 | 210 |
2053186 | 2053186 | 2021-12-26 | Jefferson | Tennessee | 47089 | 10621 | 207 |
2049936 | 2049936 | 2021-12-25 | Jefferson | Tennessee | 47089 | 10621 | 207 |
2046686 | 2046686 | 2021-12-24 | Jefferson | Tennessee | 47089 | 10621 | 207 |
2043436 | 2043436 | 2021-12-23 | Jefferson | Tennessee | 47089 | 10621 | 207 |
2040187 | 2040187 | 2021-12-22 | Jefferson | Tennessee | 47089 | 10585 | 170 |
2036937 | 2036937 | 2021-12-21 | Jefferson | Tennessee | 47089 | 10557 | 170 |
2033687 | 2033687 | 2021-12-20 | Jefferson | Tennessee | 47089 | 10543 | 169 |
2030437 | 2030437 | 2021-12-19 | Jefferson | Tennessee | 47089 | 10493 | 167 |
2027186 | 2027186 | 2021-12-18 | Jefferson | Tennessee | 47089 | 10493 | 167 |
2023935 | 2023935 | 2021-12-17 | Jefferson | Tennessee | 47089 | 10493 | 167 |
2020684 | 2020684 | 2021-12-16 | Jefferson | Tennessee | 47089 | 10478 | 167 |
2017433 | 2017433 | 2021-12-15 | Jefferson | Tennessee | 47089 | 10456 | 167 |
2014183 | 2014183 | 2021-12-14 | Jefferson | Tennessee | 47089 | 10440 | 166 |
2010932 | 2010932 | 2021-12-13 | Jefferson | Tennessee | 47089 | 10420 | 165 |
2007681 | 2007681 | 2021-12-12 | Jefferson | Tennessee | 47089 | 10369 | 165 |
2004430 | 2004430 | 2021-12-11 | Jefferson | Tennessee | 47089 | 10369 | 165 |
2001179 | 2001179 | 2021-12-10 | Jefferson | Tennessee | 47089 | 10369 | 165 |
1997929 | 1997929 | 2021-12-09 | Jefferson | Tennessee | 47089 | 10337 | 164 |
1994678 | 1994678 | 2021-12-08 | Jefferson | Tennessee | 47089 | 10337 | 164 |
1991427 | 1991427 | 2021-12-07 | Jefferson | Tennessee | 47089 | 10320 | 164 |
1988176 | 1988176 | 2021-12-06 | Jefferson | Tennessee | 47089 | 10300 | 162 |
1984926 | 1984926 | 2021-12-05 | Jefferson | Tennessee | 47089 | 10260 | 159 |
1981676 | 1981676 | 2021-12-04 | Jefferson | Tennessee | 47089 | 10260 | 159 |
1978426 | 1978426 | 2021-12-03 | Jefferson | Tennessee | 47089 | 10260 | 159 |
1975176 | 1975176 | 2021-12-02 | Jefferson | Tennessee | 47089 | 10234 | 157 |
1971927 | 1971927 | 2021-12-01 | Jefferson | Tennessee | 47089 | 10216 | 157 |
1968677 | 1968677 | 2021-11-30 | Jefferson | Tennessee | 47089 | 10187 | 153 |
1965426 | 1965426 | 2021-11-29 | Jefferson | Tennessee | 47089 | 10166 | 152 |
1962174 | 1962174 | 2021-11-28 | Jefferson | Tennessee | 47089 | 10121 | 151 |
1958923 | 1958923 | 2021-11-27 | Jefferson | Tennessee | 47089 | 10121 | 151 |
1955672 | 1955672 | 2021-11-26 | Jefferson | Tennessee | 47089 | 10121 | 151 |
1952421 | 1952421 | 2021-11-25 | Jefferson | Tennessee | 47089 | 10121 | 151 |
1949170 | 1949170 | 2021-11-24 | Jefferson | Tennessee | 47089 | 10121 | 151 |
1945919 | 1945919 | 2021-11-23 | Jefferson | Tennessee | 47089 | 10113 | 150 |
1942668 | 1942668 | 2021-11-22 | Jefferson | Tennessee | 47089 | 10108 | 149 |
1939418 | 1939418 | 2021-11-21 | Jefferson | Tennessee | 47089 | 10088 | 149 |
1936168 | 1936168 | 2021-11-20 | Jefferson | Tennessee | 47089 | 10088 | 149 |
1932918 | 1932918 | 2021-11-19 | Jefferson | Tennessee | 47089 | 10088 | 149 |
1929667 | 1929667 | 2021-11-18 | Jefferson | Tennessee | 47089 | 10075 | 149 |
1926417 | 1926417 | 2021-11-17 | Jefferson | Tennessee | 47089 | 10058 | 149 |
1923167 | 1923167 | 2021-11-16 | Jefferson | Tennessee | 47089 | 10043 | 149 |
1919918 | 1919918 | 2021-11-15 | Jefferson | Tennessee | 47089 | 10034 | 149 |
1916668 | 1916668 | 2021-11-14 | Jefferson | Tennessee | 47089 | 10032 | 149 |
1913418 | 1913418 | 2021-11-13 | Jefferson | Tennessee | 47089 | 10032 | 149 |
1910168 | 1910168 | 2021-11-12 | Jefferson | Tennessee | 47089 | 10032 | 149 |
1906919 | 1906919 | 2021-11-11 | Jefferson | Tennessee | 47089 | 10020 | 149 |
1903670 | 1903670 | 2021-11-10 | Jefferson | Tennessee | 47089 | 10020 | 149 |
1900420 | 1900420 | 2021-11-09 | Jefferson | Tennessee | 47089 | 10009 | 148 |
1897170 | 1897170 | 2021-11-08 | Jefferson | Tennessee | 47089 | 9984 | 147 |
1893920 | 1893920 | 2021-11-07 | Jefferson | Tennessee | 47089 | 9984 | 147 |
1890670 | 1890670 | 2021-11-06 | Jefferson | Tennessee | 47089 | 9984 | 147 |
1887420 | 1887420 | 2021-11-05 | Jefferson | Tennessee | 47089 | 9984 | 147 |
1884170 | 1884170 | 2021-11-04 | Jefferson | Tennessee | 47089 | 9980 | 147 |
1880921 | 1880921 | 2021-11-03 | Jefferson | Tennessee | 47089 | 9974 | 147 |
1877672 | 1877672 | 2021-11-02 | Jefferson | Tennessee | 47089 | 9968 | 145 |
1874423 | 1874423 | 2021-11-01 | Jefferson | Tennessee | 47089 | 9952 | 145 |
1871174 | 1871174 | 2021-10-31 | Jefferson | Tennessee | 47089 | 9952 | 145 |
1867925 | 1867925 | 2021-10-30 | Jefferson | Tennessee | 47089 | 9952 | 145 |
1864676 | 1864676 | 2021-10-29 | Jefferson | Tennessee | 47089 | 9952 | 145 |
1861427 | 1861427 | 2021-10-28 | Jefferson | Tennessee | 47089 | 9943 | 145 |
1858178 | 1858178 | 2021-10-27 | Jefferson | Tennessee | 47089 | 9924 | 144 |
1854929 | 1854929 | 2021-10-26 | Jefferson | Tennessee | 47089 | 9919 | 144 |
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);