ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
747 rows where deaths = 39 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Decatur 132
- Johnson 108
- Morgan 87
- Wayne 50
- Benton 46
- Smith 35
- Moore 21
- Robertson 16
- Stewart 15
- Grundy 12
- Cannon 11
- Hickman 11
- Jackson 11
- Bledsoe 9
- Chester 9
- Overton 9
- White 9
- Campbell 8
- Cocke 8
- Crockett 8
- Maury 8
- Tipton 8
- Giles 7
- Sequatchie 7
- Clay 6
- Rutherford 6
- Fentress 5
- Scott 5
- Dyer 4
- Lincoln 4
- …
state 1
- Tennessee · 747 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2401224 | 2401224 | 2022-04-12 | Moore | Tennessee | 47127 | 2238 | 39 |
2397969 | 2397969 | 2022-04-11 | Moore | Tennessee | 47127 | 2238 | 39 |
2394714 | 2394714 | 2022-04-10 | Moore | Tennessee | 47127 | 2238 | 39 |
2391458 | 2391458 | 2022-04-09 | Moore | Tennessee | 47127 | 2238 | 39 |
2388202 | 2388202 | 2022-04-08 | Moore | Tennessee | 47127 | 2238 | 39 |
2384947 | 2384947 | 2022-04-07 | Moore | Tennessee | 47127 | 2238 | 39 |
2381692 | 2381692 | 2022-04-06 | Moore | Tennessee | 47127 | 2238 | 39 |
2378437 | 2378437 | 2022-04-05 | Moore | Tennessee | 47127 | 2237 | 39 |
2375183 | 2375183 | 2022-04-04 | Moore | Tennessee | 47127 | 2237 | 39 |
2371931 | 2371931 | 2022-04-03 | Moore | Tennessee | 47127 | 2237 | 39 |
2368678 | 2368678 | 2022-04-02 | Moore | Tennessee | 47127 | 2237 | 39 |
2365425 | 2365425 | 2022-04-01 | Moore | Tennessee | 47127 | 2237 | 39 |
2362172 | 2362172 | 2022-03-31 | Moore | Tennessee | 47127 | 2237 | 39 |
2358918 | 2358918 | 2022-03-30 | Moore | Tennessee | 47127 | 2237 | 39 |
2310120 | 2310120 | 2022-03-15 | Moore | Tennessee | 47127 | 2235 | 39 |
2306867 | 2306867 | 2022-03-14 | Moore | Tennessee | 47127 | 2235 | 39 |
2303616 | 2303616 | 2022-03-13 | Moore | Tennessee | 47127 | 2235 | 39 |
2300364 | 2300364 | 2022-03-12 | Moore | Tennessee | 47127 | 2235 | 39 |
2297112 | 2297112 | 2022-03-11 | Moore | Tennessee | 47127 | 2235 | 39 |
2293860 | 2293860 | 2022-03-10 | Moore | Tennessee | 47127 | 2235 | 39 |
2290608 | 2290608 | 2022-03-09 | Moore | Tennessee | 47127 | 2235 | 39 |
2105160 | 2105160 | 2022-01-11 | Bledsoe | Tennessee | 47007 | 3687 | 39 |
2101909 | 2101909 | 2022-01-10 | Bledsoe | Tennessee | 47007 | 3687 | 39 |
2098658 | 2098658 | 2022-01-09 | Bledsoe | Tennessee | 47007 | 3687 | 39 |
2095406 | 2095406 | 2022-01-08 | Bledsoe | Tennessee | 47007 | 3687 | 39 |
2092154 | 2092154 | 2022-01-07 | Bledsoe | Tennessee | 47007 | 3687 | 39 |
2088902 | 2088902 | 2022-01-06 | Bledsoe | Tennessee | 47007 | 3687 | 39 |
2085651 | 2085651 | 2022-01-05 | Bledsoe | Tennessee | 47007 | 3687 | 39 |
2082399 | 2082399 | 2022-01-04 | Bledsoe | Tennessee | 47007 | 3687 | 39 |
2079147 | 2079147 | 2022-01-03 | Bledsoe | Tennessee | 47007 | 3678 | 39 |
2059653 | 2059653 | 2021-12-28 | Clay | Tennessee | 47027 | 1635 | 39 |
2056404 | 2056404 | 2021-12-27 | Clay | Tennessee | 47027 | 1629 | 39 |
2053155 | 2053155 | 2021-12-26 | Clay | Tennessee | 47027 | 1627 | 39 |
2049905 | 2049905 | 2021-12-25 | Clay | Tennessee | 47027 | 1627 | 39 |
2046655 | 2046655 | 2021-12-24 | Clay | Tennessee | 47027 | 1627 | 39 |
2043405 | 2043405 | 2021-12-23 | Clay | Tennessee | 47027 | 1627 | 39 |
2040212 | 2040212 | 2021-12-22 | Polk | Tennessee | 47139 | 3336 | 39 |
2040223 | 2040223 | 2021-12-22 | Stewart | Tennessee | 47161 | 2284 | 39 |
2036973 | 2036973 | 2021-12-21 | Stewart | Tennessee | 47161 | 2279 | 39 |
2033723 | 2033723 | 2021-12-20 | Stewart | Tennessee | 47161 | 2277 | 39 |
2030473 | 2030473 | 2021-12-19 | Stewart | Tennessee | 47161 | 2259 | 39 |
2027222 | 2027222 | 2021-12-18 | Stewart | Tennessee | 47161 | 2259 | 39 |
2023971 | 2023971 | 2021-12-17 | Stewart | Tennessee | 47161 | 2259 | 39 |
2020720 | 2020720 | 2021-12-16 | Stewart | Tennessee | 47161 | 2257 | 39 |
2017469 | 2017469 | 2021-12-15 | Stewart | Tennessee | 47161 | 2252 | 39 |
2014219 | 2014219 | 2021-12-14 | Stewart | Tennessee | 47161 | 2245 | 39 |
2010968 | 2010968 | 2021-12-13 | Stewart | Tennessee | 47161 | 2242 | 39 |
2007713 | 2007713 | 2021-12-12 | Sequatchie | Tennessee | 47153 | 3089 | 39 |
2007717 | 2007717 | 2021-12-12 | Stewart | Tennessee | 47161 | 2225 | 39 |
2004462 | 2004462 | 2021-12-11 | Sequatchie | Tennessee | 47153 | 3089 | 39 |
2004466 | 2004466 | 2021-12-11 | Stewart | Tennessee | 47161 | 2225 | 39 |
2001211 | 2001211 | 2021-12-10 | Sequatchie | Tennessee | 47153 | 3089 | 39 |
2001215 | 2001215 | 2021-12-10 | Stewart | Tennessee | 47161 | 2225 | 39 |
1997965 | 1997965 | 2021-12-09 | Stewart | Tennessee | 47161 | 2213 | 39 |
1994714 | 1994714 | 2021-12-08 | Stewart | Tennessee | 47161 | 2213 | 39 |
1988208 | 1988208 | 2021-12-06 | Sequatchie | Tennessee | 47153 | 3082 | 39 |
1984958 | 1984958 | 2021-12-05 | Sequatchie | Tennessee | 47153 | 3073 | 39 |
1981708 | 1981708 | 2021-12-04 | Sequatchie | Tennessee | 47153 | 3073 | 39 |
1978458 | 1978458 | 2021-12-03 | Sequatchie | Tennessee | 47153 | 3073 | 39 |
1942715 | 1942715 | 2021-11-22 | Wayne | Tennessee | 47181 | 4142 | 39 |
1939465 | 1939465 | 2021-11-21 | Wayne | Tennessee | 47181 | 4133 | 39 |
1936215 | 1936215 | 2021-11-20 | Wayne | Tennessee | 47181 | 4133 | 39 |
1932965 | 1932965 | 2021-11-19 | Wayne | Tennessee | 47181 | 4133 | 39 |
1929714 | 1929714 | 2021-11-18 | Wayne | Tennessee | 47181 | 4131 | 39 |
1926464 | 1926464 | 2021-11-17 | Wayne | Tennessee | 47181 | 4127 | 39 |
1923214 | 1923214 | 2021-11-16 | Wayne | Tennessee | 47181 | 4117 | 39 |
1919904 | 1919904 | 2021-11-15 | Grundy | Tennessee | 47061 | 2906 | 39 |
1919965 | 1919965 | 2021-11-15 | Wayne | Tennessee | 47181 | 4111 | 39 |
1916654 | 1916654 | 2021-11-14 | Grundy | Tennessee | 47061 | 2901 | 39 |
1916715 | 1916715 | 2021-11-14 | Wayne | Tennessee | 47181 | 4097 | 39 |
1913404 | 1913404 | 2021-11-13 | Grundy | Tennessee | 47061 | 2901 | 39 |
1913465 | 1913465 | 2021-11-13 | Wayne | Tennessee | 47181 | 4097 | 39 |
1910154 | 1910154 | 2021-11-12 | Grundy | Tennessee | 47061 | 2901 | 39 |
1910215 | 1910215 | 2021-11-12 | Wayne | Tennessee | 47181 | 4097 | 39 |
1906905 | 1906905 | 2021-11-11 | Grundy | Tennessee | 47061 | 2891 | 39 |
1906966 | 1906966 | 2021-11-11 | Wayne | Tennessee | 47181 | 4083 | 39 |
1903656 | 1903656 | 2021-11-10 | Grundy | Tennessee | 47061 | 2891 | 39 |
1903717 | 1903717 | 2021-11-10 | Wayne | Tennessee | 47181 | 4083 | 39 |
1900406 | 1900406 | 2021-11-09 | Grundy | Tennessee | 47061 | 2883 | 39 |
1900467 | 1900467 | 2021-11-09 | Wayne | Tennessee | 47181 | 4082 | 39 |
1897156 | 1897156 | 2021-11-08 | Grundy | Tennessee | 47061 | 2868 | 39 |
1897217 | 1897217 | 2021-11-08 | Wayne | Tennessee | 47181 | 4066 | 39 |
1893906 | 1893906 | 2021-11-07 | Grundy | Tennessee | 47061 | 2868 | 39 |
1893967 | 1893967 | 2021-11-07 | Wayne | Tennessee | 47181 | 4066 | 39 |
1890656 | 1890656 | 2021-11-06 | Grundy | Tennessee | 47061 | 2868 | 39 |
1890717 | 1890717 | 2021-11-06 | Wayne | Tennessee | 47181 | 4066 | 39 |
1887406 | 1887406 | 2021-11-05 | Grundy | Tennessee | 47061 | 2868 | 39 |
1887467 | 1887467 | 2021-11-05 | Wayne | Tennessee | 47181 | 4066 | 39 |
1884156 | 1884156 | 2021-11-04 | Grundy | Tennessee | 47061 | 2864 | 39 |
1884176 | 1884176 | 2021-11-04 | Lewis | Tennessee | 47101 | 2534 | 39 |
1884217 | 1884217 | 2021-11-04 | Wayne | Tennessee | 47181 | 4065 | 39 |
1880927 | 1880927 | 2021-11-03 | Lewis | Tennessee | 47101 | 2533 | 39 |
1880968 | 1880968 | 2021-11-03 | Wayne | Tennessee | 47181 | 4060 | 39 |
1877678 | 1877678 | 2021-11-02 | Lewis | Tennessee | 47101 | 2531 | 39 |
1877719 | 1877719 | 2021-11-02 | Wayne | Tennessee | 47181 | 4056 | 39 |
1874470 | 1874470 | 2021-11-01 | Wayne | Tennessee | 47181 | 4052 | 39 |
1871221 | 1871221 | 2021-10-31 | Wayne | Tennessee | 47181 | 4052 | 39 |
1867972 | 1867972 | 2021-10-30 | Wayne | Tennessee | 47181 | 4052 | 39 |
1864723 | 1864723 | 2021-10-29 | Wayne | Tennessee | 47181 | 4052 | 39 |
1861474 | 1861474 | 2021-10-28 | Wayne | Tennessee | 47181 | 4051 | 39 |
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);