ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Dickson" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176748 | 2176748 | 2022-02-02 | Dickson | Tennessee | 47043 | 14412 | 219 |
2173494 | 2173494 | 2022-02-01 | Dickson | Tennessee | 47043 | 13642 | 217 |
2170242 | 2170242 | 2022-01-31 | Dickson | Tennessee | 47043 | 13642 | 217 |
2166988 | 2166988 | 2022-01-30 | Dickson | Tennessee | 47043 | 13642 | 217 |
2163733 | 2163733 | 2022-01-29 | Dickson | Tennessee | 47043 | 13642 | 217 |
2160478 | 2160478 | 2022-01-28 | Dickson | Tennessee | 47043 | 13642 | 217 |
2157222 | 2157222 | 2022-01-27 | Dickson | Tennessee | 47043 | 13642 | 217 |
2153969 | 2153969 | 2022-01-26 | Dickson | Tennessee | 47043 | 13642 | 217 |
2150717 | 2150717 | 2022-01-25 | Dickson | Tennessee | 47043 | 12813 | 212 |
2147465 | 2147465 | 2022-01-24 | Dickson | Tennessee | 47043 | 12813 | 212 |
2144211 | 2144211 | 2022-01-23 | Dickson | Tennessee | 47043 | 12813 | 212 |
2140956 | 2140956 | 2022-01-22 | Dickson | Tennessee | 47043 | 12813 | 212 |
2137700 | 2137700 | 2022-01-21 | Dickson | Tennessee | 47043 | 12813 | 212 |
2134446 | 2134446 | 2022-01-20 | Dickson | Tennessee | 47043 | 12813 | 212 |
2131194 | 2131194 | 2022-01-19 | Dickson | Tennessee | 47043 | 12813 | 212 |
2127940 | 2127940 | 2022-01-18 | Dickson | Tennessee | 47043 | 11992 | 208 |
2124688 | 2124688 | 2022-01-17 | Dickson | Tennessee | 47043 | 11992 | 208 |
2121436 | 2121436 | 2022-01-16 | Dickson | Tennessee | 47043 | 11992 | 208 |
2118184 | 2118184 | 2022-01-15 | Dickson | Tennessee | 47043 | 11992 | 208 |
2114933 | 2114933 | 2022-01-14 | Dickson | Tennessee | 47043 | 11992 | 208 |
2111681 | 2111681 | 2022-01-13 | Dickson | Tennessee | 47043 | 11992 | 208 |
2108429 | 2108429 | 2022-01-12 | Dickson | Tennessee | 47043 | 11992 | 208 |
2105178 | 2105178 | 2022-01-11 | Dickson | Tennessee | 47043 | 11598 | 208 |
2101927 | 2101927 | 2022-01-10 | Dickson | Tennessee | 47043 | 11598 | 208 |
2098676 | 2098676 | 2022-01-09 | Dickson | Tennessee | 47043 | 11598 | 208 |
2095424 | 2095424 | 2022-01-08 | Dickson | Tennessee | 47043 | 11598 | 208 |
2092172 | 2092172 | 2022-01-07 | Dickson | Tennessee | 47043 | 11598 | 208 |
2088920 | 2088920 | 2022-01-06 | Dickson | Tennessee | 47043 | 11598 | 208 |
2085669 | 2085669 | 2022-01-05 | Dickson | Tennessee | 47043 | 11598 | 208 |
2082417 | 2082417 | 2022-01-04 | Dickson | Tennessee | 47043 | 11598 | 208 |
2079165 | 2079165 | 2022-01-03 | Dickson | Tennessee | 47043 | 11542 | 208 |
2075914 | 2075914 | 2022-01-02 | Dickson | Tennessee | 47043 | 11314 | 207 |
2072663 | 2072663 | 2022-01-01 | Dickson | Tennessee | 47043 | 11314 | 207 |
2069412 | 2069412 | 2021-12-31 | Dickson | Tennessee | 47043 | 11314 | 207 |
2066161 | 2066161 | 2021-12-30 | Dickson | Tennessee | 47043 | 11314 | 207 |
2062911 | 2062911 | 2021-12-29 | Dickson | Tennessee | 47043 | 11207 | 206 |
2059661 | 2059661 | 2021-12-28 | Dickson | Tennessee | 47043 | 11086 | 205 |
2056412 | 2056412 | 2021-12-27 | Dickson | Tennessee | 47043 | 11062 | 204 |
2053163 | 2053163 | 2021-12-26 | Dickson | Tennessee | 47043 | 11010 | 200 |
2049913 | 2049913 | 2021-12-25 | Dickson | Tennessee | 47043 | 11010 | 200 |
2046663 | 2046663 | 2021-12-24 | Dickson | Tennessee | 47043 | 11010 | 200 |
2043413 | 2043413 | 2021-12-23 | Dickson | Tennessee | 47043 | 11010 | 200 |
2040164 | 2040164 | 2021-12-22 | Dickson | Tennessee | 47043 | 10999 | 176 |
2036914 | 2036914 | 2021-12-21 | Dickson | Tennessee | 47043 | 10985 | 176 |
2033664 | 2033664 | 2021-12-20 | Dickson | Tennessee | 47043 | 10973 | 174 |
2030414 | 2030414 | 2021-12-19 | Dickson | Tennessee | 47043 | 10960 | 173 |
2027163 | 2027163 | 2021-12-18 | Dickson | Tennessee | 47043 | 10960 | 173 |
2023912 | 2023912 | 2021-12-17 | Dickson | Tennessee | 47043 | 10960 | 173 |
2020661 | 2020661 | 2021-12-16 | Dickson | Tennessee | 47043 | 10943 | 173 |
2017410 | 2017410 | 2021-12-15 | Dickson | Tennessee | 47043 | 10922 | 173 |
2014160 | 2014160 | 2021-12-14 | Dickson | Tennessee | 47043 | 10907 | 173 |
2010909 | 2010909 | 2021-12-13 | Dickson | Tennessee | 47043 | 10900 | 173 |
2007658 | 2007658 | 2021-12-12 | Dickson | Tennessee | 47043 | 10884 | 173 |
2004407 | 2004407 | 2021-12-11 | Dickson | Tennessee | 47043 | 10884 | 173 |
2001156 | 2001156 | 2021-12-10 | Dickson | Tennessee | 47043 | 10884 | 173 |
1997906 | 1997906 | 2021-12-09 | Dickson | Tennessee | 47043 | 10854 | 172 |
1994655 | 1994655 | 2021-12-08 | Dickson | Tennessee | 47043 | 10854 | 172 |
1991404 | 1991404 | 2021-12-07 | Dickson | Tennessee | 47043 | 10824 | 172 |
1988153 | 1988153 | 2021-12-06 | Dickson | Tennessee | 47043 | 10811 | 172 |
1984903 | 1984903 | 2021-12-05 | Dickson | Tennessee | 47043 | 10789 | 172 |
1981653 | 1981653 | 2021-12-04 | Dickson | Tennessee | 47043 | 10789 | 172 |
1978403 | 1978403 | 2021-12-03 | Dickson | Tennessee | 47043 | 10789 | 172 |
1975153 | 1975153 | 2021-12-02 | Dickson | Tennessee | 47043 | 10769 | 171 |
1971904 | 1971904 | 2021-12-01 | Dickson | Tennessee | 47043 | 10760 | 171 |
1968654 | 1968654 | 2021-11-30 | Dickson | Tennessee | 47043 | 10751 | 170 |
1965403 | 1965403 | 2021-11-29 | Dickson | Tennessee | 47043 | 10741 | 170 |
1962151 | 1962151 | 2021-11-28 | Dickson | Tennessee | 47043 | 10701 | 169 |
1958900 | 1958900 | 2021-11-27 | Dickson | Tennessee | 47043 | 10701 | 169 |
1955649 | 1955649 | 2021-11-26 | Dickson | Tennessee | 47043 | 10701 | 169 |
1952398 | 1952398 | 2021-11-25 | Dickson | Tennessee | 47043 | 10701 | 169 |
1949147 | 1949147 | 2021-11-24 | Dickson | Tennessee | 47043 | 10701 | 169 |
1945896 | 1945896 | 2021-11-23 | Dickson | Tennessee | 47043 | 10700 | 169 |
1942645 | 1942645 | 2021-11-22 | Dickson | Tennessee | 47043 | 10683 | 169 |
1939395 | 1939395 | 2021-11-21 | Dickson | Tennessee | 47043 | 10659 | 169 |
1936145 | 1936145 | 2021-11-20 | Dickson | Tennessee | 47043 | 10659 | 169 |
1932895 | 1932895 | 2021-11-19 | Dickson | Tennessee | 47043 | 10659 | 169 |
1929644 | 1929644 | 2021-11-18 | Dickson | Tennessee | 47043 | 10641 | 169 |
1926394 | 1926394 | 2021-11-17 | Dickson | Tennessee | 47043 | 10621 | 169 |
1923144 | 1923144 | 2021-11-16 | Dickson | Tennessee | 47043 | 10613 | 168 |
1919895 | 1919895 | 2021-11-15 | Dickson | Tennessee | 47043 | 10594 | 167 |
1916645 | 1916645 | 2021-11-14 | Dickson | Tennessee | 47043 | 10580 | 167 |
1913395 | 1913395 | 2021-11-13 | Dickson | Tennessee | 47043 | 10580 | 167 |
1910145 | 1910145 | 2021-11-12 | Dickson | Tennessee | 47043 | 10580 | 167 |
1906896 | 1906896 | 2021-11-11 | Dickson | Tennessee | 47043 | 10541 | 167 |
1903647 | 1903647 | 2021-11-10 | Dickson | Tennessee | 47043 | 10541 | 167 |
1900397 | 1900397 | 2021-11-09 | Dickson | Tennessee | 47043 | 10541 | 167 |
1897147 | 1897147 | 2021-11-08 | Dickson | Tennessee | 47043 | 10495 | 166 |
1893897 | 1893897 | 2021-11-07 | Dickson | Tennessee | 47043 | 10495 | 166 |
1890647 | 1890647 | 2021-11-06 | Dickson | Tennessee | 47043 | 10495 | 166 |
1887397 | 1887397 | 2021-11-05 | Dickson | Tennessee | 47043 | 10495 | 166 |
1884147 | 1884147 | 2021-11-04 | Dickson | Tennessee | 47043 | 10489 | 165 |
1880898 | 1880898 | 2021-11-03 | Dickson | Tennessee | 47043 | 10479 | 165 |
1877649 | 1877649 | 2021-11-02 | Dickson | Tennessee | 47043 | 10467 | 165 |
1874400 | 1874400 | 2021-11-01 | Dickson | Tennessee | 47043 | 10435 | 165 |
1871151 | 1871151 | 2021-10-31 | Dickson | Tennessee | 47043 | 10435 | 165 |
1867902 | 1867902 | 2021-10-30 | Dickson | Tennessee | 47043 | 10435 | 165 |
1864653 | 1864653 | 2021-10-29 | Dickson | Tennessee | 47043 | 10435 | 165 |
1861404 | 1861404 | 2021-10-28 | Dickson | Tennessee | 47043 | 10415 | 165 |
1858155 | 1858155 | 2021-10-27 | Dickson | Tennessee | 47043 | 10392 | 165 |
1854906 | 1854906 | 2021-10-26 | Dickson | Tennessee | 47043 | 10380 | 164 |
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);