ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Meigs" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2111720 | 2111720 | 2022-01-13 | Meigs | Tennessee | 47121 | 2492 | 47 |
2108468 | 2108468 | 2022-01-12 | Meigs | Tennessee | 47121 | 2492 | 47 |
2105217 | 2105217 | 2022-01-11 | Meigs | Tennessee | 47121 | 2410 | 46 |
2101966 | 2101966 | 2022-01-10 | Meigs | Tennessee | 47121 | 2410 | 46 |
2098715 | 2098715 | 2022-01-09 | Meigs | Tennessee | 47121 | 2410 | 46 |
2095463 | 2095463 | 2022-01-08 | Meigs | Tennessee | 47121 | 2410 | 46 |
2092211 | 2092211 | 2022-01-07 | Meigs | Tennessee | 47121 | 2410 | 46 |
2088959 | 2088959 | 2022-01-06 | Meigs | Tennessee | 47121 | 2410 | 46 |
2085708 | 2085708 | 2022-01-05 | Meigs | Tennessee | 47121 | 2410 | 46 |
2082456 | 2082456 | 2022-01-04 | Meigs | Tennessee | 47121 | 2410 | 46 |
2079204 | 2079204 | 2022-01-03 | Meigs | Tennessee | 47121 | 2399 | 46 |
2075953 | 2075953 | 2022-01-02 | Meigs | Tennessee | 47121 | 2365 | 46 |
2072702 | 2072702 | 2022-01-01 | Meigs | Tennessee | 47121 | 2365 | 46 |
2069451 | 2069451 | 2021-12-31 | Meigs | Tennessee | 47121 | 2365 | 46 |
2066200 | 2066200 | 2021-12-30 | Meigs | Tennessee | 47121 | 2365 | 46 |
2062950 | 2062950 | 2021-12-29 | Meigs | Tennessee | 47121 | 2344 | 46 |
2059700 | 2059700 | 2021-12-28 | Meigs | Tennessee | 47121 | 2343 | 46 |
2056451 | 2056451 | 2021-12-27 | Meigs | Tennessee | 47121 | 2333 | 45 |
2053202 | 2053202 | 2021-12-26 | Meigs | Tennessee | 47121 | 2328 | 43 |
2049952 | 2049952 | 2021-12-25 | Meigs | Tennessee | 47121 | 2328 | 43 |
2046702 | 2046702 | 2021-12-24 | Meigs | Tennessee | 47121 | 2328 | 43 |
2043452 | 2043452 | 2021-12-23 | Meigs | Tennessee | 47121 | 2328 | 43 |
2040203 | 2040203 | 2021-12-22 | Meigs | Tennessee | 47121 | 2318 | 34 |
2036953 | 2036953 | 2021-12-21 | Meigs | Tennessee | 47121 | 2312 | 34 |
2033703 | 2033703 | 2021-12-20 | Meigs | Tennessee | 47121 | 2311 | 33 |
2030453 | 2030453 | 2021-12-19 | Meigs | Tennessee | 47121 | 2299 | 33 |
2027202 | 2027202 | 2021-12-18 | Meigs | Tennessee | 47121 | 2299 | 33 |
2023951 | 2023951 | 2021-12-17 | Meigs | Tennessee | 47121 | 2299 | 33 |
2020700 | 2020700 | 2021-12-16 | Meigs | Tennessee | 47121 | 2299 | 33 |
2017449 | 2017449 | 2021-12-15 | Meigs | Tennessee | 47121 | 2288 | 33 |
2014199 | 2014199 | 2021-12-14 | Meigs | Tennessee | 47121 | 2282 | 33 |
2010948 | 2010948 | 2021-12-13 | Meigs | Tennessee | 47121 | 2274 | 33 |
2007697 | 2007697 | 2021-12-12 | Meigs | Tennessee | 47121 | 2265 | 33 |
2004446 | 2004446 | 2021-12-11 | Meigs | Tennessee | 47121 | 2265 | 33 |
2001195 | 2001195 | 2021-12-10 | Meigs | Tennessee | 47121 | 2265 | 33 |
1997945 | 1997945 | 2021-12-09 | Meigs | Tennessee | 47121 | 2257 | 33 |
1994694 | 1994694 | 2021-12-08 | Meigs | Tennessee | 47121 | 2257 | 33 |
1991443 | 1991443 | 2021-12-07 | Meigs | Tennessee | 47121 | 2252 | 33 |
1988192 | 1988192 | 2021-12-06 | Meigs | Tennessee | 47121 | 2247 | 33 |
1984942 | 1984942 | 2021-12-05 | Meigs | Tennessee | 47121 | 2239 | 32 |
1981692 | 1981692 | 2021-12-04 | Meigs | Tennessee | 47121 | 2239 | 32 |
1978442 | 1978442 | 2021-12-03 | Meigs | Tennessee | 47121 | 2239 | 32 |
1975192 | 1975192 | 2021-12-02 | Meigs | Tennessee | 47121 | 2238 | 32 |
1971943 | 1971943 | 2021-12-01 | Meigs | Tennessee | 47121 | 2236 | 31 |
1968693 | 1968693 | 2021-11-30 | Meigs | Tennessee | 47121 | 2235 | 31 |
1965442 | 1965442 | 2021-11-29 | Meigs | Tennessee | 47121 | 2232 | 31 |
1962190 | 1962190 | 2021-11-28 | Meigs | Tennessee | 47121 | 2223 | 31 |
1958939 | 1958939 | 2021-11-27 | Meigs | Tennessee | 47121 | 2223 | 31 |
1955688 | 1955688 | 2021-11-26 | Meigs | Tennessee | 47121 | 2223 | 31 |
1952437 | 1952437 | 2021-11-25 | Meigs | Tennessee | 47121 | 2223 | 31 |
1949186 | 1949186 | 2021-11-24 | Meigs | Tennessee | 47121 | 2223 | 31 |
1945935 | 1945935 | 2021-11-23 | Meigs | Tennessee | 47121 | 2223 | 31 |
1942684 | 1942684 | 2021-11-22 | Meigs | Tennessee | 47121 | 2222 | 30 |
1939434 | 1939434 | 2021-11-21 | Meigs | Tennessee | 47121 | 2215 | 30 |
1936184 | 1936184 | 2021-11-20 | Meigs | Tennessee | 47121 | 2215 | 30 |
1932934 | 1932934 | 2021-11-19 | Meigs | Tennessee | 47121 | 2215 | 30 |
1929683 | 1929683 | 2021-11-18 | Meigs | Tennessee | 47121 | 2215 | 30 |
1926433 | 1926433 | 2021-11-17 | Meigs | Tennessee | 47121 | 2213 | 30 |
1923183 | 1923183 | 2021-11-16 | Meigs | Tennessee | 47121 | 2212 | 30 |
1919934 | 1919934 | 2021-11-15 | Meigs | Tennessee | 47121 | 2211 | 29 |
1916684 | 1916684 | 2021-11-14 | Meigs | Tennessee | 47121 | 2205 | 29 |
1913434 | 1913434 | 2021-11-13 | Meigs | Tennessee | 47121 | 2205 | 29 |
1910184 | 1910184 | 2021-11-12 | Meigs | Tennessee | 47121 | 2205 | 29 |
1906935 | 1906935 | 2021-11-11 | Meigs | Tennessee | 47121 | 2201 | 29 |
1903686 | 1903686 | 2021-11-10 | Meigs | Tennessee | 47121 | 2201 | 29 |
1900436 | 1900436 | 2021-11-09 | Meigs | Tennessee | 47121 | 2200 | 29 |
1897186 | 1897186 | 2021-11-08 | Meigs | Tennessee | 47121 | 2197 | 28 |
1893936 | 1893936 | 2021-11-07 | Meigs | Tennessee | 47121 | 2197 | 28 |
1890686 | 1890686 | 2021-11-06 | Meigs | Tennessee | 47121 | 2197 | 28 |
1887436 | 1887436 | 2021-11-05 | Meigs | Tennessee | 47121 | 2197 | 28 |
1884186 | 1884186 | 2021-11-04 | Meigs | Tennessee | 47121 | 2198 | 28 |
1880937 | 1880937 | 2021-11-03 | Meigs | Tennessee | 47121 | 2192 | 28 |
1877688 | 1877688 | 2021-11-02 | Meigs | Tennessee | 47121 | 2187 | 28 |
1874439 | 1874439 | 2021-11-01 | Meigs | Tennessee | 47121 | 2181 | 28 |
1871190 | 1871190 | 2021-10-31 | Meigs | Tennessee | 47121 | 2181 | 28 |
1867941 | 1867941 | 2021-10-30 | Meigs | Tennessee | 47121 | 2181 | 28 |
1864692 | 1864692 | 2021-10-29 | Meigs | Tennessee | 47121 | 2181 | 28 |
1861443 | 1861443 | 2021-10-28 | Meigs | Tennessee | 47121 | 2179 | 28 |
1858194 | 1858194 | 2021-10-27 | Meigs | Tennessee | 47121 | 2173 | 28 |
1854945 | 1854945 | 2021-10-26 | Meigs | Tennessee | 47121 | 2169 | 28 |
1851696 | 1851696 | 2021-10-25 | Meigs | Tennessee | 47121 | 2161 | 28 |
1848446 | 1848446 | 2021-10-24 | Meigs | Tennessee | 47121 | 2161 | 28 |
1845196 | 1845196 | 2021-10-23 | Meigs | Tennessee | 47121 | 2161 | 28 |
1841946 | 1841946 | 2021-10-22 | Meigs | Tennessee | 47121 | 2161 | 28 |
1838697 | 1838697 | 2021-10-21 | Meigs | Tennessee | 47121 | 2163 | 28 |
1835448 | 1835448 | 2021-10-20 | Meigs | Tennessee | 47121 | 2163 | 28 |
1832199 | 1832199 | 2021-10-19 | Meigs | Tennessee | 47121 | 2158 | 28 |
1828950 | 1828950 | 2021-10-18 | Meigs | Tennessee | 47121 | 2153 | 28 |
1825701 | 1825701 | 2021-10-17 | Meigs | Tennessee | 47121 | 2147 | 28 |
1822452 | 1822452 | 2021-10-16 | Meigs | Tennessee | 47121 | 2147 | 28 |
1819203 | 1819203 | 2021-10-15 | Meigs | Tennessee | 47121 | 2147 | 28 |
1815954 | 1815954 | 2021-10-14 | Meigs | Tennessee | 47121 | 2145 | 28 |
1812706 | 1812706 | 2021-10-13 | Meigs | Tennessee | 47121 | 2138 | 28 |
1809457 | 1809457 | 2021-10-12 | Meigs | Tennessee | 47121 | 2135 | 28 |
1806207 | 1806207 | 2021-10-11 | Meigs | Tennessee | 47121 | 2128 | 27 |
1802957 | 1802957 | 2021-10-10 | Meigs | Tennessee | 47121 | 2125 | 27 |
1799708 | 1799708 | 2021-10-09 | Meigs | Tennessee | 47121 | 2125 | 27 |
1796459 | 1796459 | 2021-10-08 | Meigs | Tennessee | 47121 | 2125 | 27 |
1793210 | 1793210 | 2021-10-07 | Meigs | Tennessee | 47121 | 2121 | 27 |
1789961 | 1789961 | 2021-10-06 | Meigs | Tennessee | 47121 | 2117 | 27 |
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);