ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Smith" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2111739 | 2111739 | 2022-01-13 | Smith | Tennessee | 47159 | 4686 | 66 |
2108487 | 2108487 | 2022-01-12 | Smith | Tennessee | 47159 | 4686 | 66 |
2105236 | 2105236 | 2022-01-11 | Smith | Tennessee | 47159 | 4512 | 65 |
2101985 | 2101985 | 2022-01-10 | Smith | Tennessee | 47159 | 4512 | 65 |
2098734 | 2098734 | 2022-01-09 | Smith | Tennessee | 47159 | 4512 | 65 |
2095482 | 2095482 | 2022-01-08 | Smith | Tennessee | 47159 | 4512 | 65 |
2092230 | 2092230 | 2022-01-07 | Smith | Tennessee | 47159 | 4512 | 65 |
2088978 | 2088978 | 2022-01-06 | Smith | Tennessee | 47159 | 4512 | 65 |
2085727 | 2085727 | 2022-01-05 | Smith | Tennessee | 47159 | 4512 | 65 |
2082475 | 2082475 | 2022-01-04 | Smith | Tennessee | 47159 | 4512 | 65 |
2079223 | 2079223 | 2022-01-03 | Smith | Tennessee | 47159 | 4500 | 65 |
2075972 | 2075972 | 2022-01-02 | Smith | Tennessee | 47159 | 4431 | 64 |
2072721 | 2072721 | 2022-01-01 | Smith | Tennessee | 47159 | 4431 | 64 |
2069470 | 2069470 | 2021-12-31 | Smith | Tennessee | 47159 | 4431 | 64 |
2066219 | 2066219 | 2021-12-30 | Smith | Tennessee | 47159 | 4431 | 64 |
2062969 | 2062969 | 2021-12-29 | Smith | Tennessee | 47159 | 4413 | 64 |
2059719 | 2059719 | 2021-12-28 | Smith | Tennessee | 47159 | 4386 | 64 |
2056470 | 2056470 | 2021-12-27 | Smith | Tennessee | 47159 | 4375 | 64 |
2053221 | 2053221 | 2021-12-26 | Smith | Tennessee | 47159 | 4356 | 63 |
2049971 | 2049971 | 2021-12-25 | Smith | Tennessee | 47159 | 4356 | 63 |
2046721 | 2046721 | 2021-12-24 | Smith | Tennessee | 47159 | 4356 | 63 |
2043471 | 2043471 | 2021-12-23 | Smith | Tennessee | 47159 | 4356 | 63 |
2040222 | 2040222 | 2021-12-22 | Smith | Tennessee | 47159 | 4349 | 55 |
2036972 | 2036972 | 2021-12-21 | Smith | Tennessee | 47159 | 4341 | 55 |
2033722 | 2033722 | 2021-12-20 | Smith | Tennessee | 47159 | 4333 | 55 |
2030472 | 2030472 | 2021-12-19 | Smith | Tennessee | 47159 | 4321 | 55 |
2027221 | 2027221 | 2021-12-18 | Smith | Tennessee | 47159 | 4321 | 55 |
2023970 | 2023970 | 2021-12-17 | Smith | Tennessee | 47159 | 4321 | 55 |
2020719 | 2020719 | 2021-12-16 | Smith | Tennessee | 47159 | 4315 | 55 |
2017468 | 2017468 | 2021-12-15 | Smith | Tennessee | 47159 | 4314 | 55 |
2014218 | 2014218 | 2021-12-14 | Smith | Tennessee | 47159 | 4301 | 55 |
2010967 | 2010967 | 2021-12-13 | Smith | Tennessee | 47159 | 4299 | 55 |
2007716 | 2007716 | 2021-12-12 | Smith | Tennessee | 47159 | 4293 | 55 |
2004465 | 2004465 | 2021-12-11 | Smith | Tennessee | 47159 | 4293 | 55 |
2001214 | 2001214 | 2021-12-10 | Smith | Tennessee | 47159 | 4293 | 55 |
1997964 | 1997964 | 2021-12-09 | Smith | Tennessee | 47159 | 4288 | 55 |
1994713 | 1994713 | 2021-12-08 | Smith | Tennessee | 47159 | 4288 | 55 |
1991462 | 1991462 | 2021-12-07 | Smith | Tennessee | 47159 | 4287 | 55 |
1988211 | 1988211 | 2021-12-06 | Smith | Tennessee | 47159 | 4282 | 53 |
1984961 | 1984961 | 2021-12-05 | Smith | Tennessee | 47159 | 4270 | 53 |
1981711 | 1981711 | 2021-12-04 | Smith | Tennessee | 47159 | 4270 | 53 |
1978461 | 1978461 | 2021-12-03 | Smith | Tennessee | 47159 | 4270 | 53 |
1975211 | 1975211 | 2021-12-02 | Smith | Tennessee | 47159 | 4257 | 53 |
1971962 | 1971962 | 2021-12-01 | Smith | Tennessee | 47159 | 4254 | 53 |
1968712 | 1968712 | 2021-11-30 | Smith | Tennessee | 47159 | 4251 | 53 |
1965461 | 1965461 | 2021-11-29 | Smith | Tennessee | 47159 | 4250 | 53 |
1962209 | 1962209 | 2021-11-28 | Smith | Tennessee | 47159 | 4243 | 53 |
1958958 | 1958958 | 2021-11-27 | Smith | Tennessee | 47159 | 4243 | 53 |
1955707 | 1955707 | 2021-11-26 | Smith | Tennessee | 47159 | 4243 | 53 |
1952456 | 1952456 | 2021-11-25 | Smith | Tennessee | 47159 | 4243 | 53 |
1949205 | 1949205 | 2021-11-24 | Smith | Tennessee | 47159 | 4243 | 53 |
1945954 | 1945954 | 2021-11-23 | Smith | Tennessee | 47159 | 4240 | 53 |
1942703 | 1942703 | 2021-11-22 | Smith | Tennessee | 47159 | 4240 | 53 |
1939453 | 1939453 | 2021-11-21 | Smith | Tennessee | 47159 | 4230 | 53 |
1936203 | 1936203 | 2021-11-20 | Smith | Tennessee | 47159 | 4230 | 53 |
1932953 | 1932953 | 2021-11-19 | Smith | Tennessee | 47159 | 4230 | 53 |
1929702 | 1929702 | 2021-11-18 | Smith | Tennessee | 47159 | 4224 | 53 |
1926452 | 1926452 | 2021-11-17 | Smith | Tennessee | 47159 | 4217 | 53 |
1923202 | 1923202 | 2021-11-16 | Smith | Tennessee | 47159 | 4211 | 53 |
1919953 | 1919953 | 2021-11-15 | Smith | Tennessee | 47159 | 4200 | 53 |
1916703 | 1916703 | 2021-11-14 | Smith | Tennessee | 47159 | 4199 | 53 |
1913453 | 1913453 | 2021-11-13 | Smith | Tennessee | 47159 | 4199 | 53 |
1910203 | 1910203 | 2021-11-12 | Smith | Tennessee | 47159 | 4199 | 53 |
1906954 | 1906954 | 2021-11-11 | Smith | Tennessee | 47159 | 4195 | 53 |
1903705 | 1903705 | 2021-11-10 | Smith | Tennessee | 47159 | 4195 | 53 |
1900455 | 1900455 | 2021-11-09 | Smith | Tennessee | 47159 | 4187 | 53 |
1897205 | 1897205 | 2021-11-08 | Smith | Tennessee | 47159 | 4182 | 53 |
1893955 | 1893955 | 2021-11-07 | Smith | Tennessee | 47159 | 4182 | 53 |
1890705 | 1890705 | 2021-11-06 | Smith | Tennessee | 47159 | 4182 | 53 |
1887455 | 1887455 | 2021-11-05 | Smith | Tennessee | 47159 | 4182 | 53 |
1884205 | 1884205 | 2021-11-04 | Smith | Tennessee | 47159 | 4182 | 53 |
1880956 | 1880956 | 2021-11-03 | Smith | Tennessee | 47159 | 4180 | 52 |
1877707 | 1877707 | 2021-11-02 | Smith | Tennessee | 47159 | 4176 | 52 |
1874458 | 1874458 | 2021-11-01 | Smith | Tennessee | 47159 | 4175 | 52 |
1871209 | 1871209 | 2021-10-31 | Smith | Tennessee | 47159 | 4175 | 52 |
1867960 | 1867960 | 2021-10-30 | Smith | Tennessee | 47159 | 4175 | 52 |
1864711 | 1864711 | 2021-10-29 | Smith | Tennessee | 47159 | 4175 | 52 |
1861462 | 1861462 | 2021-10-28 | Smith | Tennessee | 47159 | 4174 | 52 |
1858213 | 1858213 | 2021-10-27 | Smith | Tennessee | 47159 | 4166 | 52 |
1854964 | 1854964 | 2021-10-26 | Smith | Tennessee | 47159 | 4161 | 52 |
1851715 | 1851715 | 2021-10-25 | Smith | Tennessee | 47159 | 4156 | 52 |
1848465 | 1848465 | 2021-10-24 | Smith | Tennessee | 47159 | 4156 | 52 |
1845215 | 1845215 | 2021-10-23 | Smith | Tennessee | 47159 | 4156 | 52 |
1841965 | 1841965 | 2021-10-22 | Smith | Tennessee | 47159 | 4156 | 52 |
1838716 | 1838716 | 2021-10-21 | Smith | Tennessee | 47159 | 4154 | 52 |
1835467 | 1835467 | 2021-10-20 | Smith | Tennessee | 47159 | 4148 | 52 |
1832218 | 1832218 | 2021-10-19 | Smith | Tennessee | 47159 | 4144 | 52 |
1828969 | 1828969 | 2021-10-18 | Smith | Tennessee | 47159 | 4142 | 50 |
1825720 | 1825720 | 2021-10-17 | Smith | Tennessee | 47159 | 4139 | 50 |
1822471 | 1822471 | 2021-10-16 | Smith | Tennessee | 47159 | 4139 | 50 |
1819222 | 1819222 | 2021-10-15 | Smith | Tennessee | 47159 | 4139 | 50 |
1815973 | 1815973 | 2021-10-14 | Smith | Tennessee | 47159 | 4136 | 50 |
1812725 | 1812725 | 2021-10-13 | Smith | Tennessee | 47159 | 4131 | 50 |
1809476 | 1809476 | 2021-10-12 | Smith | Tennessee | 47159 | 4127 | 50 |
1806226 | 1806226 | 2021-10-11 | Smith | Tennessee | 47159 | 4123 | 48 |
1802976 | 1802976 | 2021-10-10 | Smith | Tennessee | 47159 | 4105 | 48 |
1799727 | 1799727 | 2021-10-09 | Smith | Tennessee | 47159 | 4105 | 48 |
1796478 | 1796478 | 2021-10-08 | Smith | Tennessee | 47159 | 4105 | 48 |
1793229 | 1793229 | 2021-10-07 | Smith | Tennessee | 47159 | 4094 | 48 |
1789980 | 1789980 | 2021-10-06 | Smith | Tennessee | 47159 | 4083 | 48 |
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);