ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 47119 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176784 | 2176784 | 2022-02-02 | Maury | Tennessee | 47119 | 27145 | 289 |
2173530 | 2173530 | 2022-02-01 | Maury | Tennessee | 47119 | 25789 | 287 |
2170278 | 2170278 | 2022-01-31 | Maury | Tennessee | 47119 | 25789 | 287 |
2167024 | 2167024 | 2022-01-30 | Maury | Tennessee | 47119 | 25789 | 287 |
2163769 | 2163769 | 2022-01-29 | Maury | Tennessee | 47119 | 25789 | 287 |
2160514 | 2160514 | 2022-01-28 | Maury | Tennessee | 47119 | 25789 | 287 |
2157258 | 2157258 | 2022-01-27 | Maury | Tennessee | 47119 | 25789 | 287 |
2154005 | 2154005 | 2022-01-26 | Maury | Tennessee | 47119 | 25789 | 287 |
2150753 | 2150753 | 2022-01-25 | Maury | Tennessee | 47119 | 23949 | 279 |
2147501 | 2147501 | 2022-01-24 | Maury | Tennessee | 47119 | 23949 | 279 |
2144247 | 2144247 | 2022-01-23 | Maury | Tennessee | 47119 | 23949 | 279 |
2140992 | 2140992 | 2022-01-22 | Maury | Tennessee | 47119 | 23949 | 279 |
2137736 | 2137736 | 2022-01-21 | Maury | Tennessee | 47119 | 23949 | 279 |
2134482 | 2134482 | 2022-01-20 | Maury | Tennessee | 47119 | 23949 | 279 |
2131230 | 2131230 | 2022-01-19 | Maury | Tennessee | 47119 | 23949 | 279 |
2127976 | 2127976 | 2022-01-18 | Maury | Tennessee | 47119 | 22174 | 273 |
2124724 | 2124724 | 2022-01-17 | Maury | Tennessee | 47119 | 22174 | 273 |
2121472 | 2121472 | 2022-01-16 | Maury | Tennessee | 47119 | 22174 | 273 |
2118220 | 2118220 | 2022-01-15 | Maury | Tennessee | 47119 | 22174 | 273 |
2114969 | 2114969 | 2022-01-14 | Maury | Tennessee | 47119 | 22174 | 273 |
2111717 | 2111717 | 2022-01-13 | Maury | Tennessee | 47119 | 22174 | 273 |
2108465 | 2108465 | 2022-01-12 | Maury | Tennessee | 47119 | 22174 | 273 |
2105214 | 2105214 | 2022-01-11 | Maury | Tennessee | 47119 | 21478 | 272 |
2101963 | 2101963 | 2022-01-10 | Maury | Tennessee | 47119 | 21478 | 272 |
2098712 | 2098712 | 2022-01-09 | Maury | Tennessee | 47119 | 21478 | 272 |
2095460 | 2095460 | 2022-01-08 | Maury | Tennessee | 47119 | 21478 | 272 |
2092208 | 2092208 | 2022-01-07 | Maury | Tennessee | 47119 | 21478 | 272 |
2088956 | 2088956 | 2022-01-06 | Maury | Tennessee | 47119 | 21478 | 272 |
2085705 | 2085705 | 2022-01-05 | Maury | Tennessee | 47119 | 21478 | 272 |
2082453 | 2082453 | 2022-01-04 | Maury | Tennessee | 47119 | 21478 | 272 |
2079201 | 2079201 | 2022-01-03 | Maury | Tennessee | 47119 | 21369 | 272 |
2075950 | 2075950 | 2022-01-02 | Maury | Tennessee | 47119 | 20925 | 272 |
2072699 | 2072699 | 2022-01-01 | Maury | Tennessee | 47119 | 20925 | 272 |
2069448 | 2069448 | 2021-12-31 | Maury | Tennessee | 47119 | 20925 | 272 |
2066197 | 2066197 | 2021-12-30 | Maury | Tennessee | 47119 | 20925 | 272 |
2062947 | 2062947 | 2021-12-29 | Maury | Tennessee | 47119 | 20750 | 271 |
2059697 | 2059697 | 2021-12-28 | Maury | Tennessee | 47119 | 20650 | 271 |
2056448 | 2056448 | 2021-12-27 | Maury | Tennessee | 47119 | 20573 | 271 |
2053199 | 2053199 | 2021-12-26 | Maury | Tennessee | 47119 | 20427 | 268 |
2049949 | 2049949 | 2021-12-25 | Maury | Tennessee | 47119 | 20427 | 268 |
2046699 | 2046699 | 2021-12-24 | Maury | Tennessee | 47119 | 20427 | 268 |
2043449 | 2043449 | 2021-12-23 | Maury | Tennessee | 47119 | 20427 | 268 |
2040200 | 2040200 | 2021-12-22 | Maury | Tennessee | 47119 | 20366 | 248 |
2036950 | 2036950 | 2021-12-21 | Maury | Tennessee | 47119 | 20336 | 248 |
2033700 | 2033700 | 2021-12-20 | Maury | Tennessee | 47119 | 20310 | 248 |
2030450 | 2030450 | 2021-12-19 | Maury | Tennessee | 47119 | 20256 | 248 |
2027199 | 2027199 | 2021-12-18 | Maury | Tennessee | 47119 | 20256 | 248 |
2023948 | 2023948 | 2021-12-17 | Maury | Tennessee | 47119 | 20256 | 248 |
2020697 | 2020697 | 2021-12-16 | Maury | Tennessee | 47119 | 20233 | 248 |
2017446 | 2017446 | 2021-12-15 | Maury | Tennessee | 47119 | 20198 | 248 |
2014196 | 2014196 | 2021-12-14 | Maury | Tennessee | 47119 | 20166 | 247 |
2010945 | 2010945 | 2021-12-13 | Maury | Tennessee | 47119 | 20140 | 247 |
2007694 | 2007694 | 2021-12-12 | Maury | Tennessee | 47119 | 20086 | 247 |
2004443 | 2004443 | 2021-12-11 | Maury | Tennessee | 47119 | 20086 | 247 |
2001192 | 2001192 | 2021-12-10 | Maury | Tennessee | 47119 | 20086 | 247 |
1997942 | 1997942 | 2021-12-09 | Maury | Tennessee | 47119 | 20041 | 246 |
1994691 | 1994691 | 2021-12-08 | Maury | Tennessee | 47119 | 20041 | 246 |
1991440 | 1991440 | 2021-12-07 | Maury | Tennessee | 47119 | 20009 | 246 |
1988189 | 1988189 | 2021-12-06 | Maury | Tennessee | 47119 | 19979 | 244 |
1984939 | 1984939 | 2021-12-05 | Maury | Tennessee | 47119 | 19924 | 243 |
1981689 | 1981689 | 2021-12-04 | Maury | Tennessee | 47119 | 19924 | 243 |
1978439 | 1978439 | 2021-12-03 | Maury | Tennessee | 47119 | 19924 | 243 |
1975189 | 1975189 | 2021-12-02 | Maury | Tennessee | 47119 | 19905 | 242 |
1971940 | 1971940 | 2021-12-01 | Maury | Tennessee | 47119 | 19879 | 241 |
1968690 | 1968690 | 2021-11-30 | Maury | Tennessee | 47119 | 19847 | 240 |
1965439 | 1965439 | 2021-11-29 | Maury | Tennessee | 47119 | 19816 | 238 |
1962187 | 1962187 | 2021-11-28 | Maury | Tennessee | 47119 | 19759 | 238 |
1958936 | 1958936 | 2021-11-27 | Maury | Tennessee | 47119 | 19759 | 238 |
1955685 | 1955685 | 2021-11-26 | Maury | Tennessee | 47119 | 19759 | 238 |
1952434 | 1952434 | 2021-11-25 | Maury | Tennessee | 47119 | 19759 | 238 |
1949183 | 1949183 | 2021-11-24 | Maury | Tennessee | 47119 | 19759 | 238 |
1945932 | 1945932 | 2021-11-23 | Maury | Tennessee | 47119 | 19753 | 238 |
1942681 | 1942681 | 2021-11-22 | Maury | Tennessee | 47119 | 19737 | 238 |
1939431 | 1939431 | 2021-11-21 | Maury | Tennessee | 47119 | 19688 | 238 |
1936181 | 1936181 | 2021-11-20 | Maury | Tennessee | 47119 | 19688 | 238 |
1932931 | 1932931 | 2021-11-19 | Maury | Tennessee | 47119 | 19688 | 238 |
1929680 | 1929680 | 2021-11-18 | Maury | Tennessee | 47119 | 19668 | 238 |
1926430 | 1926430 | 2021-11-17 | Maury | Tennessee | 47119 | 19647 | 238 |
1923180 | 1923180 | 2021-11-16 | Maury | Tennessee | 47119 | 19630 | 237 |
1919931 | 1919931 | 2021-11-15 | Maury | Tennessee | 47119 | 19599 | 237 |
1916681 | 1916681 | 2021-11-14 | Maury | Tennessee | 47119 | 19568 | 237 |
1913431 | 1913431 | 2021-11-13 | Maury | Tennessee | 47119 | 19568 | 237 |
1910181 | 1910181 | 2021-11-12 | Maury | Tennessee | 47119 | 19568 | 237 |
1906932 | 1906932 | 2021-11-11 | Maury | Tennessee | 47119 | 19529 | 235 |
1903683 | 1903683 | 2021-11-10 | Maury | Tennessee | 47119 | 19529 | 235 |
1900433 | 1900433 | 2021-11-09 | Maury | Tennessee | 47119 | 19510 | 235 |
1897183 | 1897183 | 2021-11-08 | Maury | Tennessee | 47119 | 19471 | 235 |
1893933 | 1893933 | 2021-11-07 | Maury | Tennessee | 47119 | 19471 | 235 |
1890683 | 1890683 | 2021-11-06 | Maury | Tennessee | 47119 | 19471 | 235 |
1887433 | 1887433 | 2021-11-05 | Maury | Tennessee | 47119 | 19471 | 235 |
1884183 | 1884183 | 2021-11-04 | Maury | Tennessee | 47119 | 19464 | 235 |
1880934 | 1880934 | 2021-11-03 | Maury | Tennessee | 47119 | 19451 | 236 |
1877685 | 1877685 | 2021-11-02 | Maury | Tennessee | 47119 | 19437 | 235 |
1874436 | 1874436 | 2021-11-01 | Maury | Tennessee | 47119 | 19386 | 230 |
1871187 | 1871187 | 2021-10-31 | Maury | Tennessee | 47119 | 19386 | 230 |
1867938 | 1867938 | 2021-10-30 | Maury | Tennessee | 47119 | 19386 | 230 |
1864689 | 1864689 | 2021-10-29 | Maury | Tennessee | 47119 | 19386 | 230 |
1861440 | 1861440 | 2021-10-28 | Maury | Tennessee | 47119 | 19364 | 230 |
1858191 | 1858191 | 2021-10-27 | Maury | Tennessee | 47119 | 19345 | 230 |
1854942 | 1854942 | 2021-10-26 | Maury | Tennessee | 47119 | 19332 | 229 |
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);