ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Roane" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2111732 | 2111732 | 2022-01-13 | Roane | Tennessee | 47145 | 11378 | 184 |
2108480 | 2108480 | 2022-01-12 | Roane | Tennessee | 47145 | 11378 | 184 |
2105229 | 2105229 | 2022-01-11 | Roane | Tennessee | 47145 | 10965 | 184 |
2101978 | 2101978 | 2022-01-10 | Roane | Tennessee | 47145 | 10965 | 184 |
2098727 | 2098727 | 2022-01-09 | Roane | Tennessee | 47145 | 10965 | 184 |
2095475 | 2095475 | 2022-01-08 | Roane | Tennessee | 47145 | 10965 | 184 |
2092223 | 2092223 | 2022-01-07 | Roane | Tennessee | 47145 | 10965 | 184 |
2088971 | 2088971 | 2022-01-06 | Roane | Tennessee | 47145 | 10965 | 184 |
2085720 | 2085720 | 2022-01-05 | Roane | Tennessee | 47145 | 10965 | 184 |
2082468 | 2082468 | 2022-01-04 | Roane | Tennessee | 47145 | 10965 | 184 |
2079216 | 2079216 | 2022-01-03 | Roane | Tennessee | 47145 | 10921 | 184 |
2075965 | 2075965 | 2022-01-02 | Roane | Tennessee | 47145 | 10791 | 184 |
2072714 | 2072714 | 2022-01-01 | Roane | Tennessee | 47145 | 10791 | 184 |
2069463 | 2069463 | 2021-12-31 | Roane | Tennessee | 47145 | 10791 | 184 |
2066212 | 2066212 | 2021-12-30 | Roane | Tennessee | 47145 | 10791 | 184 |
2062962 | 2062962 | 2021-12-29 | Roane | Tennessee | 47145 | 10717 | 183 |
2059712 | 2059712 | 2021-12-28 | Roane | Tennessee | 47145 | 10670 | 183 |
2056463 | 2056463 | 2021-12-27 | Roane | Tennessee | 47145 | 10646 | 181 |
2053214 | 2053214 | 2021-12-26 | Roane | Tennessee | 47145 | 10614 | 180 |
2049964 | 2049964 | 2021-12-25 | Roane | Tennessee | 47145 | 10614 | 180 |
2046714 | 2046714 | 2021-12-24 | Roane | Tennessee | 47145 | 10614 | 180 |
2043464 | 2043464 | 2021-12-23 | Roane | Tennessee | 47145 | 10614 | 180 |
2040215 | 2040215 | 2021-12-22 | Roane | Tennessee | 47145 | 10595 | 172 |
2036965 | 2036965 | 2021-12-21 | Roane | Tennessee | 47145 | 10585 | 172 |
2033715 | 2033715 | 2021-12-20 | Roane | Tennessee | 47145 | 10571 | 171 |
2030465 | 2030465 | 2021-12-19 | Roane | Tennessee | 47145 | 10545 | 171 |
2027214 | 2027214 | 2021-12-18 | Roane | Tennessee | 47145 | 10545 | 171 |
2023963 | 2023963 | 2021-12-17 | Roane | Tennessee | 47145 | 10545 | 171 |
2020712 | 2020712 | 2021-12-16 | Roane | Tennessee | 47145 | 10537 | 170 |
2017461 | 2017461 | 2021-12-15 | Roane | Tennessee | 47145 | 10526 | 169 |
2014211 | 2014211 | 2021-12-14 | Roane | Tennessee | 47145 | 10513 | 168 |
2010960 | 2010960 | 2021-12-13 | Roane | Tennessee | 47145 | 10500 | 168 |
2007709 | 2007709 | 2021-12-12 | Roane | Tennessee | 47145 | 10483 | 168 |
2004458 | 2004458 | 2021-12-11 | Roane | Tennessee | 47145 | 10483 | 168 |
2001207 | 2001207 | 2021-12-10 | Roane | Tennessee | 47145 | 10483 | 168 |
1997957 | 1997957 | 2021-12-09 | Roane | Tennessee | 47145 | 10456 | 168 |
1994706 | 1994706 | 2021-12-08 | Roane | Tennessee | 47145 | 10456 | 168 |
1991455 | 1991455 | 2021-12-07 | Roane | Tennessee | 47145 | 10442 | 167 |
1988204 | 1988204 | 2021-12-06 | Roane | Tennessee | 47145 | 10429 | 165 |
1984954 | 1984954 | 2021-12-05 | Roane | Tennessee | 47145 | 10410 | 163 |
1981704 | 1981704 | 2021-12-04 | Roane | Tennessee | 47145 | 10410 | 163 |
1978454 | 1978454 | 2021-12-03 | Roane | Tennessee | 47145 | 10410 | 163 |
1975204 | 1975204 | 2021-12-02 | Roane | Tennessee | 47145 | 10393 | 163 |
1971955 | 1971955 | 2021-12-01 | Roane | Tennessee | 47145 | 10372 | 162 |
1968705 | 1968705 | 2021-11-30 | Roane | Tennessee | 47145 | 10357 | 160 |
1965454 | 1965454 | 2021-11-29 | Roane | Tennessee | 47145 | 10339 | 160 |
1962202 | 1962202 | 2021-11-28 | Roane | Tennessee | 47145 | 10295 | 159 |
1958951 | 1958951 | 2021-11-27 | Roane | Tennessee | 47145 | 10295 | 159 |
1955700 | 1955700 | 2021-11-26 | Roane | Tennessee | 47145 | 10295 | 159 |
1952449 | 1952449 | 2021-11-25 | Roane | Tennessee | 47145 | 10295 | 159 |
1949198 | 1949198 | 2021-11-24 | Roane | Tennessee | 47145 | 10295 | 159 |
1945947 | 1945947 | 2021-11-23 | Roane | Tennessee | 47145 | 10290 | 159 |
1942696 | 1942696 | 2021-11-22 | Roane | Tennessee | 47145 | 10263 | 159 |
1939446 | 1939446 | 2021-11-21 | Roane | Tennessee | 47145 | 10248 | 159 |
1936196 | 1936196 | 2021-11-20 | Roane | Tennessee | 47145 | 10248 | 159 |
1932946 | 1932946 | 2021-11-19 | Roane | Tennessee | 47145 | 10248 | 159 |
1929695 | 1929695 | 2021-11-18 | Roane | Tennessee | 47145 | 10230 | 159 |
1926445 | 1926445 | 2021-11-17 | Roane | Tennessee | 47145 | 10208 | 159 |
1923195 | 1923195 | 2021-11-16 | Roane | Tennessee | 47145 | 10196 | 159 |
1919946 | 1919946 | 2021-11-15 | Roane | Tennessee | 47145 | 10183 | 155 |
1916696 | 1916696 | 2021-11-14 | Roane | Tennessee | 47145 | 10161 | 155 |
1913446 | 1913446 | 2021-11-13 | Roane | Tennessee | 47145 | 10161 | 155 |
1910196 | 1910196 | 2021-11-12 | Roane | Tennessee | 47145 | 10161 | 155 |
1906947 | 1906947 | 2021-11-11 | Roane | Tennessee | 47145 | 10141 | 154 |
1903698 | 1903698 | 2021-11-10 | Roane | Tennessee | 47145 | 10141 | 154 |
1900448 | 1900448 | 2021-11-09 | Roane | Tennessee | 47145 | 10118 | 154 |
1897198 | 1897198 | 2021-11-08 | Roane | Tennessee | 47145 | 10089 | 154 |
1893948 | 1893948 | 2021-11-07 | Roane | Tennessee | 47145 | 10089 | 154 |
1890698 | 1890698 | 2021-11-06 | Roane | Tennessee | 47145 | 10089 | 154 |
1887448 | 1887448 | 2021-11-05 | Roane | Tennessee | 47145 | 10089 | 154 |
1884198 | 1884198 | 2021-11-04 | Roane | Tennessee | 47145 | 10086 | 154 |
1880949 | 1880949 | 2021-11-03 | Roane | Tennessee | 47145 | 10070 | 154 |
1877700 | 1877700 | 2021-11-02 | Roane | Tennessee | 47145 | 10060 | 154 |
1874451 | 1874451 | 2021-11-01 | Roane | Tennessee | 47145 | 10026 | 153 |
1871202 | 1871202 | 2021-10-31 | Roane | Tennessee | 47145 | 10026 | 153 |
1867953 | 1867953 | 2021-10-30 | Roane | Tennessee | 47145 | 10026 | 153 |
1864704 | 1864704 | 2021-10-29 | Roane | Tennessee | 47145 | 10026 | 153 |
1861455 | 1861455 | 2021-10-28 | Roane | Tennessee | 47145 | 10021 | 153 |
1858206 | 1858206 | 2021-10-27 | Roane | Tennessee | 47145 | 10004 | 152 |
1854957 | 1854957 | 2021-10-26 | Roane | Tennessee | 47145 | 9994 | 150 |
1851708 | 1851708 | 2021-10-25 | Roane | Tennessee | 47145 | 9950 | 150 |
1848458 | 1848458 | 2021-10-24 | Roane | Tennessee | 47145 | 9950 | 150 |
1845208 | 1845208 | 2021-10-23 | Roane | Tennessee | 47145 | 9950 | 150 |
1841958 | 1841958 | 2021-10-22 | Roane | Tennessee | 47145 | 9950 | 150 |
1838709 | 1838709 | 2021-10-21 | Roane | Tennessee | 47145 | 9926 | 149 |
1835460 | 1835460 | 2021-10-20 | Roane | Tennessee | 47145 | 9908 | 149 |
1832211 | 1832211 | 2021-10-19 | Roane | Tennessee | 47145 | 9878 | 149 |
1828962 | 1828962 | 2021-10-18 | Roane | Tennessee | 47145 | 9863 | 148 |
1825713 | 1825713 | 2021-10-17 | Roane | Tennessee | 47145 | 9828 | 147 |
1822464 | 1822464 | 2021-10-16 | Roane | Tennessee | 47145 | 9828 | 147 |
1819215 | 1819215 | 2021-10-15 | Roane | Tennessee | 47145 | 9828 | 147 |
1815966 | 1815966 | 2021-10-14 | Roane | Tennessee | 47145 | 9810 | 147 |
1812718 | 1812718 | 2021-10-13 | Roane | Tennessee | 47145 | 9786 | 147 |
1809469 | 1809469 | 2021-10-12 | Roane | Tennessee | 47145 | 9756 | 147 |
1806219 | 1806219 | 2021-10-11 | Roane | Tennessee | 47145 | 9715 | 147 |
1802969 | 1802969 | 2021-10-10 | Roane | Tennessee | 47145 | 9660 | 147 |
1799720 | 1799720 | 2021-10-09 | Roane | Tennessee | 47145 | 9660 | 147 |
1796471 | 1796471 | 2021-10-08 | Roane | Tennessee | 47145 | 9660 | 147 |
1793222 | 1793222 | 2021-10-07 | Roane | Tennessee | 47145 | 9621 | 145 |
1789973 | 1789973 | 2021-10-06 | Roane | Tennessee | 47145 | 9606 | 145 |
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);