ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Overton" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2111726 | 2111726 | 2022-01-13 | Overton | Tennessee | 47133 | 5465 | 110 |
2108474 | 2108474 | 2022-01-12 | Overton | Tennessee | 47133 | 5465 | 110 |
2105223 | 2105223 | 2022-01-11 | Overton | Tennessee | 47133 | 5320 | 107 |
2101972 | 2101972 | 2022-01-10 | Overton | Tennessee | 47133 | 5320 | 107 |
2098721 | 2098721 | 2022-01-09 | Overton | Tennessee | 47133 | 5320 | 107 |
2095469 | 2095469 | 2022-01-08 | Overton | Tennessee | 47133 | 5320 | 107 |
2092217 | 2092217 | 2022-01-07 | Overton | Tennessee | 47133 | 5320 | 107 |
2088965 | 2088965 | 2022-01-06 | Overton | Tennessee | 47133 | 5320 | 107 |
2085714 | 2085714 | 2022-01-05 | Overton | Tennessee | 47133 | 5320 | 107 |
2082462 | 2082462 | 2022-01-04 | Overton | Tennessee | 47133 | 5320 | 107 |
2079210 | 2079210 | 2022-01-03 | Overton | Tennessee | 47133 | 5297 | 107 |
2075959 | 2075959 | 2022-01-02 | Overton | Tennessee | 47133 | 5213 | 106 |
2072708 | 2072708 | 2022-01-01 | Overton | Tennessee | 47133 | 5213 | 106 |
2069457 | 2069457 | 2021-12-31 | Overton | Tennessee | 47133 | 5213 | 106 |
2066206 | 2066206 | 2021-12-30 | Overton | Tennessee | 47133 | 5213 | 106 |
2062956 | 2062956 | 2021-12-29 | Overton | Tennessee | 47133 | 5189 | 105 |
2059706 | 2059706 | 2021-12-28 | Overton | Tennessee | 47133 | 5166 | 105 |
2056457 | 2056457 | 2021-12-27 | Overton | Tennessee | 47133 | 5134 | 104 |
2053208 | 2053208 | 2021-12-26 | Overton | Tennessee | 47133 | 5092 | 101 |
2049958 | 2049958 | 2021-12-25 | Overton | Tennessee | 47133 | 5092 | 101 |
2046708 | 2046708 | 2021-12-24 | Overton | Tennessee | 47133 | 5092 | 101 |
2043458 | 2043458 | 2021-12-23 | Overton | Tennessee | 47133 | 5092 | 101 |
2040209 | 2040209 | 2021-12-22 | Overton | Tennessee | 47133 | 5072 | 90 |
2036959 | 2036959 | 2021-12-21 | Overton | Tennessee | 47133 | 5057 | 90 |
2033709 | 2033709 | 2021-12-20 | Overton | Tennessee | 47133 | 5046 | 89 |
2030459 | 2030459 | 2021-12-19 | Overton | Tennessee | 47133 | 5025 | 89 |
2027208 | 2027208 | 2021-12-18 | Overton | Tennessee | 47133 | 5025 | 89 |
2023957 | 2023957 | 2021-12-17 | Overton | Tennessee | 47133 | 5025 | 89 |
2020706 | 2020706 | 2021-12-16 | Overton | Tennessee | 47133 | 5018 | 89 |
2017455 | 2017455 | 2021-12-15 | Overton | Tennessee | 47133 | 5015 | 89 |
2014205 | 2014205 | 2021-12-14 | Overton | Tennessee | 47133 | 4999 | 86 |
2010954 | 2010954 | 2021-12-13 | Overton | Tennessee | 47133 | 4994 | 86 |
2007703 | 2007703 | 2021-12-12 | Overton | Tennessee | 47133 | 4973 | 86 |
2004452 | 2004452 | 2021-12-11 | Overton | Tennessee | 47133 | 4973 | 86 |
2001201 | 2001201 | 2021-12-10 | Overton | Tennessee | 47133 | 4973 | 86 |
1997951 | 1997951 | 2021-12-09 | Overton | Tennessee | 47133 | 4967 | 86 |
1994700 | 1994700 | 2021-12-08 | Overton | Tennessee | 47133 | 4967 | 86 |
1991449 | 1991449 | 2021-12-07 | Overton | Tennessee | 47133 | 4962 | 86 |
1988198 | 1988198 | 2021-12-06 | Overton | Tennessee | 47133 | 4957 | 85 |
1984948 | 1984948 | 2021-12-05 | Overton | Tennessee | 47133 | 4937 | 85 |
1981698 | 1981698 | 2021-12-04 | Overton | Tennessee | 47133 | 4937 | 85 |
1978448 | 1978448 | 2021-12-03 | Overton | Tennessee | 47133 | 4937 | 85 |
1975198 | 1975198 | 2021-12-02 | Overton | Tennessee | 47133 | 4932 | 84 |
1971949 | 1971949 | 2021-12-01 | Overton | Tennessee | 47133 | 4922 | 84 |
1968699 | 1968699 | 2021-11-30 | Overton | Tennessee | 47133 | 4912 | 84 |
1965448 | 1965448 | 2021-11-29 | Overton | Tennessee | 47133 | 4908 | 83 |
1962196 | 1962196 | 2021-11-28 | Overton | Tennessee | 47133 | 4892 | 83 |
1958945 | 1958945 | 2021-11-27 | Overton | Tennessee | 47133 | 4892 | 83 |
1955694 | 1955694 | 2021-11-26 | Overton | Tennessee | 47133 | 4892 | 83 |
1952443 | 1952443 | 2021-11-25 | Overton | Tennessee | 47133 | 4892 | 83 |
1949192 | 1949192 | 2021-11-24 | Overton | Tennessee | 47133 | 4892 | 83 |
1945941 | 1945941 | 2021-11-23 | Overton | Tennessee | 47133 | 4890 | 83 |
1942690 | 1942690 | 2021-11-22 | Overton | Tennessee | 47133 | 4888 | 83 |
1939440 | 1939440 | 2021-11-21 | Overton | Tennessee | 47133 | 4880 | 83 |
1936190 | 1936190 | 2021-11-20 | Overton | Tennessee | 47133 | 4880 | 83 |
1932940 | 1932940 | 2021-11-19 | Overton | Tennessee | 47133 | 4880 | 83 |
1929689 | 1929689 | 2021-11-18 | Overton | Tennessee | 47133 | 4881 | 83 |
1926439 | 1926439 | 2021-11-17 | Overton | Tennessee | 47133 | 4878 | 83 |
1923189 | 1923189 | 2021-11-16 | Overton | Tennessee | 47133 | 4872 | 83 |
1919940 | 1919940 | 2021-11-15 | Overton | Tennessee | 47133 | 4858 | 83 |
1916690 | 1916690 | 2021-11-14 | Overton | Tennessee | 47133 | 4851 | 83 |
1913440 | 1913440 | 2021-11-13 | Overton | Tennessee | 47133 | 4851 | 83 |
1910190 | 1910190 | 2021-11-12 | Overton | Tennessee | 47133 | 4851 | 83 |
1906941 | 1906941 | 2021-11-11 | Overton | Tennessee | 47133 | 4845 | 83 |
1903692 | 1903692 | 2021-11-10 | Overton | Tennessee | 47133 | 4845 | 83 |
1900442 | 1900442 | 2021-11-09 | Overton | Tennessee | 47133 | 4824 | 83 |
1897192 | 1897192 | 2021-11-08 | Overton | Tennessee | 47133 | 4804 | 83 |
1893942 | 1893942 | 2021-11-07 | Overton | Tennessee | 47133 | 4804 | 83 |
1890692 | 1890692 | 2021-11-06 | Overton | Tennessee | 47133 | 4804 | 83 |
1887442 | 1887442 | 2021-11-05 | Overton | Tennessee | 47133 | 4804 | 83 |
1884192 | 1884192 | 2021-11-04 | Overton | Tennessee | 47133 | 4803 | 82 |
1880943 | 1880943 | 2021-11-03 | Overton | Tennessee | 47133 | 4802 | 82 |
1877694 | 1877694 | 2021-11-02 | Overton | Tennessee | 47133 | 4797 | 82 |
1874445 | 1874445 | 2021-11-01 | Overton | Tennessee | 47133 | 4791 | 82 |
1871196 | 1871196 | 2021-10-31 | Overton | Tennessee | 47133 | 4791 | 82 |
1867947 | 1867947 | 2021-10-30 | Overton | Tennessee | 47133 | 4791 | 82 |
1864698 | 1864698 | 2021-10-29 | Overton | Tennessee | 47133 | 4791 | 82 |
1861449 | 1861449 | 2021-10-28 | Overton | Tennessee | 47133 | 4786 | 82 |
1858200 | 1858200 | 2021-10-27 | Overton | Tennessee | 47133 | 4782 | 82 |
1854951 | 1854951 | 2021-10-26 | Overton | Tennessee | 47133 | 4781 | 82 |
1851702 | 1851702 | 2021-10-25 | Overton | Tennessee | 47133 | 4769 | 81 |
1848452 | 1848452 | 2021-10-24 | Overton | Tennessee | 47133 | 4769 | 81 |
1845202 | 1845202 | 2021-10-23 | Overton | Tennessee | 47133 | 4769 | 81 |
1841952 | 1841952 | 2021-10-22 | Overton | Tennessee | 47133 | 4769 | 81 |
1838703 | 1838703 | 2021-10-21 | Overton | Tennessee | 47133 | 4768 | 80 |
1835454 | 1835454 | 2021-10-20 | Overton | Tennessee | 47133 | 4763 | 79 |
1832205 | 1832205 | 2021-10-19 | Overton | Tennessee | 47133 | 4753 | 79 |
1828956 | 1828956 | 2021-10-18 | Overton | Tennessee | 47133 | 4748 | 79 |
1825707 | 1825707 | 2021-10-17 | Overton | Tennessee | 47133 | 4730 | 79 |
1822458 | 1822458 | 2021-10-16 | Overton | Tennessee | 47133 | 4730 | 79 |
1819209 | 1819209 | 2021-10-15 | Overton | Tennessee | 47133 | 4730 | 79 |
1815960 | 1815960 | 2021-10-14 | Overton | Tennessee | 47133 | 4723 | 78 |
1812712 | 1812712 | 2021-10-13 | Overton | Tennessee | 47133 | 4715 | 78 |
1809463 | 1809463 | 2021-10-12 | Overton | Tennessee | 47133 | 4709 | 78 |
1806213 | 1806213 | 2021-10-11 | Overton | Tennessee | 47133 | 4693 | 78 |
1802963 | 1802963 | 2021-10-10 | Overton | Tennessee | 47133 | 4664 | 78 |
1799714 | 1799714 | 2021-10-09 | Overton | Tennessee | 47133 | 4664 | 78 |
1796465 | 1796465 | 2021-10-08 | Overton | Tennessee | 47133 | 4664 | 78 |
1793216 | 1793216 | 2021-10-07 | Overton | Tennessee | 47133 | 4655 | 78 |
1789967 | 1789967 | 2021-10-06 | Overton | Tennessee | 47133 | 4645 | 78 |
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);