ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 47001 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176727 | 2176727 | 2022-02-02 | Anderson | Tennessee | 47001 | 19504 | 289 |
2173473 | 2173473 | 2022-02-01 | Anderson | Tennessee | 47001 | 18176 | 284 |
2170221 | 2170221 | 2022-01-31 | Anderson | Tennessee | 47001 | 18176 | 284 |
2166967 | 2166967 | 2022-01-30 | Anderson | Tennessee | 47001 | 18176 | 284 |
2163712 | 2163712 | 2022-01-29 | Anderson | Tennessee | 47001 | 18176 | 284 |
2160457 | 2160457 | 2022-01-28 | Anderson | Tennessee | 47001 | 18176 | 284 |
2157201 | 2157201 | 2022-01-27 | Anderson | Tennessee | 47001 | 18176 | 284 |
2153948 | 2153948 | 2022-01-26 | Anderson | Tennessee | 47001 | 18176 | 284 |
2150696 | 2150696 | 2022-01-25 | Anderson | Tennessee | 47001 | 16649 | 278 |
2147444 | 2147444 | 2022-01-24 | Anderson | Tennessee | 47001 | 16649 | 278 |
2144190 | 2144190 | 2022-01-23 | Anderson | Tennessee | 47001 | 16649 | 278 |
2140935 | 2140935 | 2022-01-22 | Anderson | Tennessee | 47001 | 16649 | 278 |
2137679 | 2137679 | 2022-01-21 | Anderson | Tennessee | 47001 | 16649 | 278 |
2134425 | 2134425 | 2022-01-20 | Anderson | Tennessee | 47001 | 16649 | 278 |
2131173 | 2131173 | 2022-01-19 | Anderson | Tennessee | 47001 | 16649 | 278 |
2127919 | 2127919 | 2022-01-18 | Anderson | Tennessee | 47001 | 15396 | 270 |
2124667 | 2124667 | 2022-01-17 | Anderson | Tennessee | 47001 | 15396 | 270 |
2121415 | 2121415 | 2022-01-16 | Anderson | Tennessee | 47001 | 15396 | 270 |
2118163 | 2118163 | 2022-01-15 | Anderson | Tennessee | 47001 | 15396 | 270 |
2114912 | 2114912 | 2022-01-14 | Anderson | Tennessee | 47001 | 15396 | 270 |
2111660 | 2111660 | 2022-01-13 | Anderson | Tennessee | 47001 | 15396 | 270 |
2108408 | 2108408 | 2022-01-12 | Anderson | Tennessee | 47001 | 15396 | 270 |
2105157 | 2105157 | 2022-01-11 | Anderson | Tennessee | 47001 | 14717 | 267 |
2101906 | 2101906 | 2022-01-10 | Anderson | Tennessee | 47001 | 14717 | 267 |
2098655 | 2098655 | 2022-01-09 | Anderson | Tennessee | 47001 | 14717 | 267 |
2095403 | 2095403 | 2022-01-08 | Anderson | Tennessee | 47001 | 14717 | 267 |
2092151 | 2092151 | 2022-01-07 | Anderson | Tennessee | 47001 | 14717 | 267 |
2088899 | 2088899 | 2022-01-06 | Anderson | Tennessee | 47001 | 14717 | 267 |
2085648 | 2085648 | 2022-01-05 | Anderson | Tennessee | 47001 | 14717 | 267 |
2082396 | 2082396 | 2022-01-04 | Anderson | Tennessee | 47001 | 14717 | 267 |
2079144 | 2079144 | 2022-01-03 | Anderson | Tennessee | 47001 | 14657 | 266 |
2075893 | 2075893 | 2022-01-02 | Anderson | Tennessee | 47001 | 14409 | 265 |
2072642 | 2072642 | 2022-01-01 | Anderson | Tennessee | 47001 | 14409 | 265 |
2069391 | 2069391 | 2021-12-31 | Anderson | Tennessee | 47001 | 14409 | 265 |
2066140 | 2066140 | 2021-12-30 | Anderson | Tennessee | 47001 | 14409 | 265 |
2062890 | 2062890 | 2021-12-29 | Anderson | Tennessee | 47001 | 14321 | 263 |
2059640 | 2059640 | 2021-12-28 | Anderson | Tennessee | 47001 | 14240 | 263 |
2056391 | 2056391 | 2021-12-27 | Anderson | Tennessee | 47001 | 14192 | 262 |
2053142 | 2053142 | 2021-12-26 | Anderson | Tennessee | 47001 | 14113 | 261 |
2049892 | 2049892 | 2021-12-25 | Anderson | Tennessee | 47001 | 14113 | 261 |
2046642 | 2046642 | 2021-12-24 | Anderson | Tennessee | 47001 | 14113 | 261 |
2043392 | 2043392 | 2021-12-23 | Anderson | Tennessee | 47001 | 14113 | 261 |
2040143 | 2040143 | 2021-12-22 | Anderson | Tennessee | 47001 | 14069 | 242 |
2036893 | 2036893 | 2021-12-21 | Anderson | Tennessee | 47001 | 14039 | 242 |
2033643 | 2033643 | 2021-12-20 | Anderson | Tennessee | 47001 | 14018 | 242 |
2030393 | 2030393 | 2021-12-19 | Anderson | Tennessee | 47001 | 13957 | 241 |
2027142 | 2027142 | 2021-12-18 | Anderson | Tennessee | 47001 | 13957 | 241 |
2023891 | 2023891 | 2021-12-17 | Anderson | Tennessee | 47001 | 13957 | 241 |
2020640 | 2020640 | 2021-12-16 | Anderson | Tennessee | 47001 | 13929 | 241 |
2017389 | 2017389 | 2021-12-15 | Anderson | Tennessee | 47001 | 13897 | 241 |
2014139 | 2014139 | 2021-12-14 | Anderson | Tennessee | 47001 | 13891 | 238 |
2010888 | 2010888 | 2021-12-13 | Anderson | Tennessee | 47001 | 13859 | 238 |
2007637 | 2007637 | 2021-12-12 | Anderson | Tennessee | 47001 | 13801 | 238 |
2004386 | 2004386 | 2021-12-11 | Anderson | Tennessee | 47001 | 13801 | 238 |
2001135 | 2001135 | 2021-12-10 | Anderson | Tennessee | 47001 | 13801 | 238 |
1997885 | 1997885 | 2021-12-09 | Anderson | Tennessee | 47001 | 13746 | 238 |
1994634 | 1994634 | 2021-12-08 | Anderson | Tennessee | 47001 | 13746 | 238 |
1991383 | 1991383 | 2021-12-07 | Anderson | Tennessee | 47001 | 13713 | 238 |
1988132 | 1988132 | 2021-12-06 | Anderson | Tennessee | 47001 | 13681 | 236 |
1984882 | 1984882 | 2021-12-05 | Anderson | Tennessee | 47001 | 13619 | 235 |
1981632 | 1981632 | 2021-12-04 | Anderson | Tennessee | 47001 | 13619 | 235 |
1978382 | 1978382 | 2021-12-03 | Anderson | Tennessee | 47001 | 13619 | 235 |
1975132 | 1975132 | 2021-12-02 | Anderson | Tennessee | 47001 | 13578 | 235 |
1971883 | 1971883 | 2021-12-01 | Anderson | Tennessee | 47001 | 13542 | 235 |
1968633 | 1968633 | 2021-11-30 | Anderson | Tennessee | 47001 | 13519 | 235 |
1965382 | 1965382 | 2021-11-29 | Anderson | Tennessee | 47001 | 13489 | 235 |
1962130 | 1962130 | 2021-11-28 | Anderson | Tennessee | 47001 | 13426 | 234 |
1958879 | 1958879 | 2021-11-27 | Anderson | Tennessee | 47001 | 13426 | 234 |
1955628 | 1955628 | 2021-11-26 | Anderson | Tennessee | 47001 | 13426 | 234 |
1952377 | 1952377 | 2021-11-25 | Anderson | Tennessee | 47001 | 13426 | 234 |
1949126 | 1949126 | 2021-11-24 | Anderson | Tennessee | 47001 | 13426 | 234 |
1945875 | 1945875 | 2021-11-23 | Anderson | Tennessee | 47001 | 13418 | 234 |
1942624 | 1942624 | 2021-11-22 | Anderson | Tennessee | 47001 | 13389 | 233 |
1939374 | 1939374 | 2021-11-21 | Anderson | Tennessee | 47001 | 13358 | 232 |
1936124 | 1936124 | 2021-11-20 | Anderson | Tennessee | 47001 | 13358 | 232 |
1932874 | 1932874 | 2021-11-19 | Anderson | Tennessee | 47001 | 13358 | 232 |
1929623 | 1929623 | 2021-11-18 | Anderson | Tennessee | 47001 | 13329 | 228 |
1926373 | 1926373 | 2021-11-17 | Anderson | Tennessee | 47001 | 13319 | 228 |
1923123 | 1923123 | 2021-11-16 | Anderson | Tennessee | 47001 | 13292 | 227 |
1919874 | 1919874 | 2021-11-15 | Anderson | Tennessee | 47001 | 13259 | 227 |
1916624 | 1916624 | 2021-11-14 | Anderson | Tennessee | 47001 | 13235 | 224 |
1913374 | 1913374 | 2021-11-13 | Anderson | Tennessee | 47001 | 13235 | 224 |
1910124 | 1910124 | 2021-11-12 | Anderson | Tennessee | 47001 | 13235 | 224 |
1906875 | 1906875 | 2021-11-11 | Anderson | Tennessee | 47001 | 13198 | 224 |
1903626 | 1903626 | 2021-11-10 | Anderson | Tennessee | 47001 | 13198 | 224 |
1900376 | 1900376 | 2021-11-09 | Anderson | Tennessee | 47001 | 13180 | 223 |
1897126 | 1897126 | 2021-11-08 | Anderson | Tennessee | 47001 | 13128 | 222 |
1893876 | 1893876 | 2021-11-07 | Anderson | Tennessee | 47001 | 13128 | 222 |
1890626 | 1890626 | 2021-11-06 | Anderson | Tennessee | 47001 | 13128 | 222 |
1887376 | 1887376 | 2021-11-05 | Anderson | Tennessee | 47001 | 13128 | 222 |
1884126 | 1884126 | 2021-11-04 | Anderson | Tennessee | 47001 | 13106 | 222 |
1880877 | 1880877 | 2021-11-03 | Anderson | Tennessee | 47001 | 13078 | 221 |
1877628 | 1877628 | 2021-11-02 | Anderson | Tennessee | 47001 | 13056 | 219 |
1874379 | 1874379 | 2021-11-01 | Anderson | Tennessee | 47001 | 13000 | 218 |
1871130 | 1871130 | 2021-10-31 | Anderson | Tennessee | 47001 | 13000 | 218 |
1867881 | 1867881 | 2021-10-30 | Anderson | Tennessee | 47001 | 13000 | 218 |
1864632 | 1864632 | 2021-10-29 | Anderson | Tennessee | 47001 | 13000 | 218 |
1861383 | 1861383 | 2021-10-28 | Anderson | Tennessee | 47001 | 12976 | 217 |
1858134 | 1858134 | 2021-10-27 | Anderson | Tennessee | 47001 | 12951 | 216 |
1854885 | 1854885 | 2021-10-26 | Anderson | Tennessee | 47001 | 12940 | 216 |
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);