ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where county = "Davidson" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176745 | 2176745 | 2022-02-02 | Davidson | Tennessee | 47037 | 197612 | 1485 |
2173491 | 2173491 | 2022-02-01 | Davidson | Tennessee | 47037 | 196376 | 1458 |
2170239 | 2170239 | 2022-01-31 | Davidson | Tennessee | 47037 | 196376 | 1458 |
2166985 | 2166985 | 2022-01-30 | Davidson | Tennessee | 47037 | 193686 | 1452 |
2163730 | 2163730 | 2022-01-29 | Davidson | Tennessee | 47037 | 193686 | 1452 |
2160475 | 2160475 | 2022-01-28 | Davidson | Tennessee | 47037 | 193686 | 1452 |
2157219 | 2157219 | 2022-01-27 | Davidson | Tennessee | 47037 | 191254 | 1452 |
2153966 | 2153966 | 2022-01-26 | Davidson | Tennessee | 47037 | 191254 | 1452 |
2150714 | 2150714 | 2022-01-25 | Davidson | Tennessee | 47037 | 188886 | 1426 |
2147462 | 2147462 | 2022-01-24 | Davidson | Tennessee | 47037 | 188886 | 1426 |
2144208 | 2144208 | 2022-01-23 | Davidson | Tennessee | 47037 | 185079 | 1425 |
2140953 | 2140953 | 2022-01-22 | Davidson | Tennessee | 47037 | 185079 | 1425 |
2137697 | 2137697 | 2022-01-21 | Davidson | Tennessee | 47037 | 185079 | 1425 |
2134443 | 2134443 | 2022-01-20 | Davidson | Tennessee | 47037 | 181067 | 1425 |
2131191 | 2131191 | 2022-01-19 | Davidson | Tennessee | 47037 | 181067 | 1425 |
2127937 | 2127937 | 2022-01-18 | Davidson | Tennessee | 47037 | 179427 | 1401 |
2124685 | 2124685 | 2022-01-17 | Davidson | Tennessee | 47037 | 179427 | 1401 |
2121433 | 2121433 | 2022-01-16 | Davidson | Tennessee | 47037 | 173956 | 1393 |
2118181 | 2118181 | 2022-01-15 | Davidson | Tennessee | 47037 | 173956 | 1393 |
2114930 | 2114930 | 2022-01-14 | Davidson | Tennessee | 47037 | 173956 | 1393 |
2111678 | 2111678 | 2022-01-13 | Davidson | Tennessee | 47037 | 170069 | 1393 |
2108426 | 2108426 | 2022-01-12 | Davidson | Tennessee | 47037 | 170069 | 1393 |
2105175 | 2105175 | 2022-01-11 | Davidson | Tennessee | 47037 | 167346 | 1386 |
2101924 | 2101924 | 2022-01-10 | Davidson | Tennessee | 47037 | 167346 | 1386 |
2098673 | 2098673 | 2022-01-09 | Davidson | Tennessee | 47037 | 162661 | 1386 |
2095421 | 2095421 | 2022-01-08 | Davidson | Tennessee | 47037 | 162661 | 1386 |
2092169 | 2092169 | 2022-01-07 | Davidson | Tennessee | 47037 | 162661 | 1386 |
2088917 | 2088917 | 2022-01-06 | Davidson | Tennessee | 47037 | 157311 | 1386 |
2085666 | 2085666 | 2022-01-05 | Davidson | Tennessee | 47037 | 157311 | 1386 |
2082414 | 2082414 | 2022-01-04 | Davidson | Tennessee | 47037 | 154851 | 1386 |
2079162 | 2079162 | 2022-01-03 | Davidson | Tennessee | 47037 | 154851 | 1384 |
2075911 | 2075911 | 2022-01-02 | Davidson | Tennessee | 47037 | 149462 | 1384 |
2072660 | 2072660 | 2022-01-01 | Davidson | Tennessee | 47037 | 149462 | 1384 |
2069409 | 2069409 | 2021-12-31 | Davidson | Tennessee | 47037 | 149462 | 1384 |
2066158 | 2066158 | 2021-12-30 | Davidson | Tennessee | 47037 | 145386 | 1384 |
2062908 | 2062908 | 2021-12-29 | Davidson | Tennessee | 47037 | 145386 | 1382 |
2059658 | 2059658 | 2021-12-28 | Davidson | Tennessee | 47037 | 140061 | 1377 |
2056409 | 2056409 | 2021-12-27 | Davidson | Tennessee | 47037 | 140061 | 1369 |
2053160 | 2053160 | 2021-12-26 | Davidson | Tennessee | 47037 | 140061 | 1355 |
2049910 | 2049910 | 2021-12-25 | Davidson | Tennessee | 47037 | 140061 | 1355 |
2046660 | 2046660 | 2021-12-24 | Davidson | Tennessee | 47037 | 140061 | 1355 |
2043410 | 2043410 | 2021-12-23 | Davidson | Tennessee | 47037 | 140061 | 1355 |
2040161 | 2040161 | 2021-12-22 | Davidson | Tennessee | 47037 | 140061 | 1250 |
2036911 | 2036911 | 2021-12-21 | Davidson | Tennessee | 47037 | 138460 | 1248 |
2033661 | 2033661 | 2021-12-20 | Davidson | Tennessee | 47037 | 138460 | 1245 |
2030411 | 2030411 | 2021-12-19 | Davidson | Tennessee | 47037 | 138460 | 1236 |
2027160 | 2027160 | 2021-12-18 | Davidson | Tennessee | 47037 | 138460 | 1236 |
2023909 | 2023909 | 2021-12-17 | Davidson | Tennessee | 47037 | 138460 | 1236 |
2020658 | 2020658 | 2021-12-16 | Davidson | Tennessee | 47037 | 137964 | 1236 |
2017407 | 2017407 | 2021-12-15 | Davidson | Tennessee | 47037 | 137964 | 1235 |
2014157 | 2014157 | 2021-12-14 | Davidson | Tennessee | 47037 | 137754 | 1230 |
2010906 | 2010906 | 2021-12-13 | Davidson | Tennessee | 47037 | 137754 | 1230 |
2007655 | 2007655 | 2021-12-12 | Davidson | Tennessee | 47037 | 137371 | 1226 |
2004404 | 2004404 | 2021-12-11 | Davidson | Tennessee | 47037 | 137371 | 1226 |
2001153 | 2001153 | 2021-12-10 | Davidson | Tennessee | 47037 | 137371 | 1226 |
1997903 | 1997903 | 2021-12-09 | Davidson | Tennessee | 47037 | 136986 | 1225 |
1994652 | 1994652 | 2021-12-08 | Davidson | Tennessee | 47037 | 136986 | 1225 |
1991401 | 1991401 | 2021-12-07 | Davidson | Tennessee | 47037 | 136773 | 1223 |
1988150 | 1988150 | 2021-12-06 | Davidson | Tennessee | 47037 | 136773 | 1220 |
1984900 | 1984900 | 2021-12-05 | Davidson | Tennessee | 47037 | 136279 | 1210 |
1981650 | 1981650 | 2021-12-04 | Davidson | Tennessee | 47037 | 136279 | 1210 |
1978400 | 1978400 | 2021-12-03 | Davidson | Tennessee | 47037 | 136279 | 1210 |
1975150 | 1975150 | 2021-12-02 | Davidson | Tennessee | 47037 | 135846 | 1205 |
1971901 | 1971901 | 2021-12-01 | Davidson | Tennessee | 47037 | 135846 | 1205 |
1968651 | 1968651 | 2021-11-30 | Davidson | Tennessee | 47037 | 135626 | 1200 |
1965400 | 1965400 | 2021-11-29 | Davidson | Tennessee | 47037 | 135626 | 1198 |
1962148 | 1962148 | 2021-11-28 | Davidson | Tennessee | 47037 | 135188 | 1196 |
1958897 | 1958897 | 2021-11-27 | Davidson | Tennessee | 47037 | 135188 | 1196 |
1955646 | 1955646 | 2021-11-26 | Davidson | Tennessee | 47037 | 135188 | 1196 |
1952395 | 1952395 | 2021-11-25 | Davidson | Tennessee | 47037 | 135188 | 1196 |
1949144 | 1949144 | 2021-11-24 | Davidson | Tennessee | 47037 | 135188 | 1196 |
1945893 | 1945893 | 2021-11-23 | Davidson | Tennessee | 47037 | 135017 | 1192 |
1942642 | 1942642 | 2021-11-22 | Davidson | Tennessee | 47037 | 135017 | 1191 |
1939392 | 1939392 | 2021-11-21 | Davidson | Tennessee | 47037 | 134682 | 1192 |
1936142 | 1936142 | 2021-11-20 | Davidson | Tennessee | 47037 | 134682 | 1192 |
1932892 | 1932892 | 2021-11-19 | Davidson | Tennessee | 47037 | 134682 | 1192 |
1929641 | 1929641 | 2021-11-18 | Davidson | Tennessee | 47037 | 134428 | 1186 |
1926391 | 1926391 | 2021-11-17 | Davidson | Tennessee | 47037 | 134428 | 1186 |
1923141 | 1923141 | 2021-11-16 | Davidson | Tennessee | 47037 | 134237 | 1185 |
1919892 | 1919892 | 2021-11-15 | Davidson | Tennessee | 47037 | 134237 | 1181 |
1916642 | 1916642 | 2021-11-14 | Davidson | Tennessee | 47037 | 133942 | 1178 |
1913392 | 1913392 | 2021-11-13 | Davidson | Tennessee | 47037 | 133942 | 1178 |
1910142 | 1910142 | 2021-11-12 | Davidson | Tennessee | 47037 | 133942 | 1178 |
1906893 | 1906893 | 2021-11-11 | Davidson | Tennessee | 47037 | 133659 | 1177 |
1903644 | 1903644 | 2021-11-10 | Davidson | Tennessee | 47037 | 133659 | 1177 |
1900394 | 1900394 | 2021-11-09 | Davidson | Tennessee | 47037 | 133486 | 1177 |
1897144 | 1897144 | 2021-11-08 | Davidson | Tennessee | 47037 | 133486 | 1170 |
1893894 | 1893894 | 2021-11-07 | Davidson | Tennessee | 47037 | 133249 | 1170 |
1890644 | 1890644 | 2021-11-06 | Davidson | Tennessee | 47037 | 133249 | 1170 |
1887394 | 1887394 | 2021-11-05 | Davidson | Tennessee | 47037 | 133249 | 1170 |
1884144 | 1884144 | 2021-11-04 | Davidson | Tennessee | 47037 | 133086 | 1170 |
1880895 | 1880895 | 2021-11-03 | Davidson | Tennessee | 47037 | 133086 | 1169 |
1877646 | 1877646 | 2021-11-02 | Davidson | Tennessee | 47037 | 132939 | 1167 |
1874397 | 1874397 | 2021-11-01 | Davidson | Tennessee | 47037 | 132939 | 1164 |
1871148 | 1871148 | 2021-10-31 | Davidson | Tennessee | 47037 | 132647 | 1164 |
1867899 | 1867899 | 2021-10-30 | Davidson | Tennessee | 47037 | 132647 | 1164 |
1864650 | 1864650 | 2021-10-29 | Davidson | Tennessee | 47037 | 132647 | 1164 |
1861401 | 1861401 | 2021-10-28 | Davidson | Tennessee | 47037 | 132423 | 1161 |
1858152 | 1858152 | 2021-10-27 | Davidson | Tennessee | 47037 | 132423 | 1160 |
1854903 | 1854903 | 2021-10-26 | Davidson | Tennessee | 47037 | 132249 | 1158 |
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);