ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Madison" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176781 | 2176781 | 2022-02-02 | Madison | Tennessee | 47113 | 27279 | 380 |
2173527 | 2173527 | 2022-02-01 | Madison | Tennessee | 47113 | 25844 | 374 |
2170275 | 2170275 | 2022-01-31 | Madison | Tennessee | 47113 | 25844 | 374 |
2167021 | 2167021 | 2022-01-30 | Madison | Tennessee | 47113 | 25844 | 374 |
2163766 | 2163766 | 2022-01-29 | Madison | Tennessee | 47113 | 25844 | 374 |
2160511 | 2160511 | 2022-01-28 | Madison | Tennessee | 47113 | 25844 | 374 |
2157255 | 2157255 | 2022-01-27 | Madison | Tennessee | 47113 | 25844 | 374 |
2154002 | 2154002 | 2022-01-26 | Madison | Tennessee | 47113 | 25844 | 374 |
2150750 | 2150750 | 2022-01-25 | Madison | Tennessee | 47113 | 23798 | 374 |
2147498 | 2147498 | 2022-01-24 | Madison | Tennessee | 47113 | 23798 | 374 |
2144244 | 2144244 | 2022-01-23 | Madison | Tennessee | 47113 | 23798 | 374 |
2140989 | 2140989 | 2022-01-22 | Madison | Tennessee | 47113 | 23798 | 374 |
2137733 | 2137733 | 2022-01-21 | Madison | Tennessee | 47113 | 23798 | 374 |
2134479 | 2134479 | 2022-01-20 | Madison | Tennessee | 47113 | 23798 | 374 |
2131227 | 2131227 | 2022-01-19 | Madison | Tennessee | 47113 | 23798 | 374 |
2127973 | 2127973 | 2022-01-18 | Madison | Tennessee | 47113 | 21434 | 363 |
2124721 | 2124721 | 2022-01-17 | Madison | Tennessee | 47113 | 21434 | 363 |
2121469 | 2121469 | 2022-01-16 | Madison | Tennessee | 47113 | 21434 | 363 |
2118217 | 2118217 | 2022-01-15 | Madison | Tennessee | 47113 | 21434 | 363 |
2114966 | 2114966 | 2022-01-14 | Madison | Tennessee | 47113 | 21434 | 363 |
2111714 | 2111714 | 2022-01-13 | Madison | Tennessee | 47113 | 21434 | 363 |
2108462 | 2108462 | 2022-01-12 | Madison | Tennessee | 47113 | 21434 | 363 |
2105211 | 2105211 | 2022-01-11 | Madison | Tennessee | 47113 | 20167 | 361 |
2101960 | 2101960 | 2022-01-10 | Madison | Tennessee | 47113 | 20167 | 361 |
2098709 | 2098709 | 2022-01-09 | Madison | Tennessee | 47113 | 20167 | 361 |
2095457 | 2095457 | 2022-01-08 | Madison | Tennessee | 47113 | 20167 | 361 |
2092205 | 2092205 | 2022-01-07 | Madison | Tennessee | 47113 | 20167 | 361 |
2088953 | 2088953 | 2022-01-06 | Madison | Tennessee | 47113 | 20167 | 361 |
2085702 | 2085702 | 2022-01-05 | Madison | Tennessee | 47113 | 20167 | 361 |
2082450 | 2082450 | 2022-01-04 | Madison | Tennessee | 47113 | 20167 | 361 |
2079198 | 2079198 | 2022-01-03 | Madison | Tennessee | 47113 | 19986 | 361 |
2075947 | 2075947 | 2022-01-02 | Madison | Tennessee | 47113 | 19389 | 362 |
2072696 | 2072696 | 2022-01-01 | Madison | Tennessee | 47113 | 19389 | 362 |
2069445 | 2069445 | 2021-12-31 | Madison | Tennessee | 47113 | 19389 | 362 |
2066194 | 2066194 | 2021-12-30 | Madison | Tennessee | 47113 | 19389 | 362 |
2062944 | 2062944 | 2021-12-29 | Madison | Tennessee | 47113 | 19150 | 361 |
2059694 | 2059694 | 2021-12-28 | Madison | Tennessee | 47113 | 18945 | 360 |
2056445 | 2056445 | 2021-12-27 | Madison | Tennessee | 47113 | 18857 | 359 |
2053196 | 2053196 | 2021-12-26 | Madison | Tennessee | 47113 | 18714 | 357 |
2049946 | 2049946 | 2021-12-25 | Madison | Tennessee | 47113 | 18714 | 357 |
2046696 | 2046696 | 2021-12-24 | Madison | Tennessee | 47113 | 18714 | 357 |
2043446 | 2043446 | 2021-12-23 | Madison | Tennessee | 47113 | 18714 | 357 |
2040197 | 2040197 | 2021-12-22 | Madison | Tennessee | 47113 | 18650 | 334 |
2036947 | 2036947 | 2021-12-21 | Madison | Tennessee | 47113 | 18589 | 332 |
2033697 | 2033697 | 2021-12-20 | Madison | Tennessee | 47113 | 18561 | 332 |
2030447 | 2030447 | 2021-12-19 | Madison | Tennessee | 47113 | 18499 | 333 |
2027196 | 2027196 | 2021-12-18 | Madison | Tennessee | 47113 | 18499 | 333 |
2023945 | 2023945 | 2021-12-17 | Madison | Tennessee | 47113 | 18499 | 333 |
2020694 | 2020694 | 2021-12-16 | Madison | Tennessee | 47113 | 18464 | 331 |
2017443 | 2017443 | 2021-12-15 | Madison | Tennessee | 47113 | 18428 | 331 |
2014193 | 2014193 | 2021-12-14 | Madison | Tennessee | 47113 | 18398 | 331 |
2010942 | 2010942 | 2021-12-13 | Madison | Tennessee | 47113 | 18367 | 331 |
2007691 | 2007691 | 2021-12-12 | Madison | Tennessee | 47113 | 18348 | 330 |
2004440 | 2004440 | 2021-12-11 | Madison | Tennessee | 47113 | 18348 | 330 |
2001189 | 2001189 | 2021-12-10 | Madison | Tennessee | 47113 | 18348 | 330 |
1997939 | 1997939 | 2021-12-09 | Madison | Tennessee | 47113 | 18287 | 330 |
1994688 | 1994688 | 2021-12-08 | Madison | Tennessee | 47113 | 18287 | 330 |
1991437 | 1991437 | 2021-12-07 | Madison | Tennessee | 47113 | 18263 | 330 |
1988186 | 1988186 | 2021-12-06 | Madison | Tennessee | 47113 | 18227 | 329 |
1984936 | 1984936 | 2021-12-05 | Madison | Tennessee | 47113 | 18176 | 328 |
1981686 | 1981686 | 2021-12-04 | Madison | Tennessee | 47113 | 18176 | 328 |
1978436 | 1978436 | 2021-12-03 | Madison | Tennessee | 47113 | 18176 | 328 |
1975186 | 1975186 | 2021-12-02 | Madison | Tennessee | 47113 | 18156 | 326 |
1971937 | 1971937 | 2021-12-01 | Madison | Tennessee | 47113 | 18133 | 325 |
1968687 | 1968687 | 2021-11-30 | Madison | Tennessee | 47113 | 18101 | 324 |
1965436 | 1965436 | 2021-11-29 | Madison | Tennessee | 47113 | 18074 | 324 |
1962184 | 1962184 | 2021-11-28 | Madison | Tennessee | 47113 | 18035 | 324 |
1958933 | 1958933 | 2021-11-27 | Madison | Tennessee | 47113 | 18035 | 324 |
1955682 | 1955682 | 2021-11-26 | Madison | Tennessee | 47113 | 18035 | 324 |
1952431 | 1952431 | 2021-11-25 | Madison | Tennessee | 47113 | 18035 | 324 |
1949180 | 1949180 | 2021-11-24 | Madison | Tennessee | 47113 | 18035 | 324 |
1945929 | 1945929 | 2021-11-23 | Madison | Tennessee | 47113 | 18030 | 324 |
1942678 | 1942678 | 2021-11-22 | Madison | Tennessee | 47113 | 17992 | 324 |
1939428 | 1939428 | 2021-11-21 | Madison | Tennessee | 47113 | 17979 | 323 |
1936178 | 1936178 | 2021-11-20 | Madison | Tennessee | 47113 | 17979 | 323 |
1932928 | 1932928 | 2021-11-19 | Madison | Tennessee | 47113 | 17979 | 323 |
1929677 | 1929677 | 2021-11-18 | Madison | Tennessee | 47113 | 17938 | 322 |
1926427 | 1926427 | 2021-11-17 | Madison | Tennessee | 47113 | 17911 | 322 |
1923177 | 1923177 | 2021-11-16 | Madison | Tennessee | 47113 | 17869 | 321 |
1919928 | 1919928 | 2021-11-15 | Madison | Tennessee | 47113 | 17844 | 321 |
1916678 | 1916678 | 2021-11-14 | Madison | Tennessee | 47113 | 17824 | 321 |
1913428 | 1913428 | 2021-11-13 | Madison | Tennessee | 47113 | 17824 | 321 |
1910178 | 1910178 | 2021-11-12 | Madison | Tennessee | 47113 | 17824 | 321 |
1906929 | 1906929 | 2021-11-11 | Madison | Tennessee | 47113 | 17792 | 318 |
1903680 | 1903680 | 2021-11-10 | Madison | Tennessee | 47113 | 17792 | 318 |
1900430 | 1900430 | 2021-11-09 | Madison | Tennessee | 47113 | 17776 | 318 |
1897180 | 1897180 | 2021-11-08 | Madison | Tennessee | 47113 | 17738 | 316 |
1893930 | 1893930 | 2021-11-07 | Madison | Tennessee | 47113 | 17738 | 316 |
1890680 | 1890680 | 2021-11-06 | Madison | Tennessee | 47113 | 17738 | 316 |
1887430 | 1887430 | 2021-11-05 | Madison | Tennessee | 47113 | 17738 | 316 |
1884180 | 1884180 | 2021-11-04 | Madison | Tennessee | 47113 | 17728 | 315 |
1880931 | 1880931 | 2021-11-03 | Madison | Tennessee | 47113 | 17707 | 315 |
1877682 | 1877682 | 2021-11-02 | Madison | Tennessee | 47113 | 17682 | 314 |
1874433 | 1874433 | 2021-11-01 | Madison | Tennessee | 47113 | 17643 | 314 |
1871184 | 1871184 | 2021-10-31 | Madison | Tennessee | 47113 | 17643 | 314 |
1867935 | 1867935 | 2021-10-30 | Madison | Tennessee | 47113 | 17643 | 314 |
1864686 | 1864686 | 2021-10-29 | Madison | Tennessee | 47113 | 17643 | 314 |
1861437 | 1861437 | 2021-10-28 | Madison | Tennessee | 47113 | 17615 | 314 |
1858188 | 1858188 | 2021-10-27 | Madison | Tennessee | 47113 | 17595 | 314 |
1854939 | 1854939 | 2021-10-26 | Madison | Tennessee | 47113 | 17589 | 310 |
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);