ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Roane" and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177340 | 2177340 | 2022-02-02 | Roane | West Virginia | 54087 | 2844 | 31 |
2174087 | 2174087 | 2022-02-01 | Roane | West Virginia | 54087 | 2835 | 31 |
2170835 | 2170835 | 2022-01-31 | Roane | West Virginia | 54087 | 2812 | 31 |
2167582 | 2167582 | 2022-01-30 | Roane | West Virginia | 54087 | 2798 | 30 |
2164327 | 2164327 | 2022-01-29 | Roane | West Virginia | 54087 | 2784 | 30 |
2161072 | 2161072 | 2022-01-28 | Roane | West Virginia | 54087 | 2785 | 30 |
2157816 | 2157816 | 2022-01-27 | Roane | West Virginia | 54087 | 2758 | 30 |
2154563 | 2154563 | 2022-01-26 | Roane | West Virginia | 54087 | 2725 | 30 |
2151310 | 2151310 | 2022-01-25 | Roane | West Virginia | 54087 | 2694 | 30 |
2148058 | 2148058 | 2022-01-24 | Roane | West Virginia | 54087 | 2667 | 30 |
2144806 | 2144806 | 2022-01-23 | Roane | West Virginia | 54087 | 2642 | 30 |
2141551 | 2141551 | 2022-01-22 | Roane | West Virginia | 54087 | 2613 | 30 |
2138295 | 2138295 | 2022-01-21 | Roane | West Virginia | 54087 | 2560 | 30 |
2135040 | 2135040 | 2022-01-20 | Roane | West Virginia | 54087 | 2527 | 30 |
2131788 | 2131788 | 2022-01-19 | Roane | West Virginia | 54087 | 2487 | 30 |
2128534 | 2128534 | 2022-01-18 | Roane | West Virginia | 54087 | 2458 | 30 |
2125281 | 2125281 | 2022-01-17 | Roane | West Virginia | 54087 | 2431 | 29 |
2122029 | 2122029 | 2022-01-16 | Roane | West Virginia | 54087 | 2394 | 29 |
2118777 | 2118777 | 2022-01-15 | Roane | West Virginia | 54087 | 2373 | 29 |
2115525 | 2115525 | 2022-01-14 | Roane | West Virginia | 54087 | 2335 | 29 |
2112273 | 2112273 | 2022-01-13 | Roane | West Virginia | 54087 | 2281 | 29 |
2109021 | 2109021 | 2022-01-12 | Roane | West Virginia | 54087 | 2231 | 29 |
2105770 | 2105770 | 2022-01-11 | Roane | West Virginia | 54087 | 2209 | 29 |
2102519 | 2102519 | 2022-01-10 | Roane | West Virginia | 54087 | 2195 | 29 |
2099268 | 2099268 | 2022-01-09 | Roane | West Virginia | 54087 | 2177 | 29 |
2096017 | 2096017 | 2022-01-08 | Roane | West Virginia | 54087 | 2169 | 29 |
2092765 | 2092765 | 2022-01-07 | Roane | West Virginia | 54087 | 2155 | 29 |
2089513 | 2089513 | 2022-01-06 | Roane | West Virginia | 54087 | 2132 | 29 |
2086262 | 2086262 | 2022-01-05 | Roane | West Virginia | 54087 | 2116 | 28 |
2083010 | 2083010 | 2022-01-04 | Roane | West Virginia | 54087 | 2099 | 28 |
2079758 | 2079758 | 2022-01-03 | Roane | West Virginia | 54087 | 2090 | 28 |
2076506 | 2076506 | 2022-01-02 | Roane | West Virginia | 54087 | 2038 | 28 |
2073255 | 2073255 | 2022-01-01 | Roane | West Virginia | 54087 | 2038 | 28 |
2070004 | 2070004 | 2021-12-31 | Roane | West Virginia | 54087 | 2038 | 28 |
2066753 | 2066753 | 2021-12-30 | Roane | West Virginia | 54087 | 2038 | 28 |
2063503 | 2063503 | 2021-12-29 | Roane | West Virginia | 54087 | 2030 | 28 |
2060253 | 2060253 | 2021-12-28 | Roane | West Virginia | 54087 | 2025 | 28 |
2057004 | 2057004 | 2021-12-27 | Roane | West Virginia | 54087 | 2017 | 28 |
2053755 | 2053755 | 2021-12-26 | Roane | West Virginia | 54087 | 1996 | 27 |
2050505 | 2050505 | 2021-12-25 | Roane | West Virginia | 54087 | 1996 | 27 |
2047255 | 2047255 | 2021-12-24 | Roane | West Virginia | 54087 | 1996 | 27 |
2044005 | 2044005 | 2021-12-23 | Roane | West Virginia | 54087 | 1996 | 27 |
2040756 | 2040756 | 2021-12-22 | Roane | West Virginia | 54087 | 1991 | 27 |
2037506 | 2037506 | 2021-12-21 | Roane | West Virginia | 54087 | 1986 | 27 |
2034256 | 2034256 | 2021-12-20 | Roane | West Virginia | 54087 | 1978 | 27 |
2031006 | 2031006 | 2021-12-19 | Roane | West Virginia | 54087 | 1970 | 27 |
2027755 | 2027755 | 2021-12-18 | Roane | West Virginia | 54087 | 1964 | 27 |
2024504 | 2024504 | 2021-12-17 | Roane | West Virginia | 54087 | 1954 | 27 |
2021253 | 2021253 | 2021-12-16 | Roane | West Virginia | 54087 | 1947 | 27 |
2018002 | 2018002 | 2021-12-15 | Roane | West Virginia | 54087 | 1932 | 27 |
2014752 | 2014752 | 2021-12-14 | Roane | West Virginia | 54087 | 1925 | 27 |
2011501 | 2011501 | 2021-12-13 | Roane | West Virginia | 54087 | 1917 | 27 |
2008250 | 2008250 | 2021-12-12 | Roane | West Virginia | 54087 | 1911 | 27 |
2004999 | 2004999 | 2021-12-11 | Roane | West Virginia | 54087 | 1900 | 27 |
2001748 | 2001748 | 2021-12-10 | Roane | West Virginia | 54087 | 1891 | 27 |
1998498 | 1998498 | 2021-12-09 | Roane | West Virginia | 54087 | 1876 | 27 |
1995247 | 1995247 | 2021-12-08 | Roane | West Virginia | 54087 | 1866 | 27 |
1991996 | 1991996 | 2021-12-07 | Roane | West Virginia | 54087 | 1859 | 27 |
1988745 | 1988745 | 2021-12-06 | Roane | West Virginia | 54087 | 1845 | 25 |
1985495 | 1985495 | 2021-12-05 | Roane | West Virginia | 54087 | 1840 | 25 |
1982245 | 1982245 | 2021-12-04 | Roane | West Virginia | 54087 | 1832 | 25 |
1978995 | 1978995 | 2021-12-03 | Roane | West Virginia | 54087 | 1824 | 25 |
1975745 | 1975745 | 2021-12-02 | Roane | West Virginia | 54087 | 1817 | 25 |
1972496 | 1972496 | 2021-12-01 | Roane | West Virginia | 54087 | 1799 | 25 |
1969246 | 1969246 | 2021-11-30 | Roane | West Virginia | 54087 | 1790 | 25 |
1965996 | 1965996 | 2021-11-29 | Roane | West Virginia | 54087 | 1779 | 25 |
1962744 | 1962744 | 2021-11-28 | Roane | West Virginia | 54087 | 1760 | 25 |
1959493 | 1959493 | 2021-11-27 | Roane | West Virginia | 54087 | 1760 | 25 |
1956242 | 1956242 | 2021-11-26 | Roane | West Virginia | 54087 | 1760 | 25 |
1952991 | 1952991 | 2021-11-25 | Roane | West Virginia | 54087 | 1760 | 25 |
1949740 | 1949740 | 2021-11-24 | Roane | West Virginia | 54087 | 1760 | 25 |
1946489 | 1946489 | 2021-11-23 | Roane | West Virginia | 54087 | 1758 | 25 |
1943238 | 1943238 | 2021-11-22 | Roane | West Virginia | 54087 | 1741 | 25 |
1939988 | 1939988 | 2021-11-21 | Roane | West Virginia | 54087 | 1738 | 24 |
1936738 | 1936738 | 2021-11-20 | Roane | West Virginia | 54087 | 1732 | 24 |
1933488 | 1933488 | 2021-11-19 | Roane | West Virginia | 54087 | 1728 | 24 |
1930236 | 1930236 | 2021-11-18 | Roane | West Virginia | 54087 | 1722 | 24 |
1926986 | 1926986 | 2021-11-17 | Roane | West Virginia | 54087 | 1711 | 24 |
1923736 | 1923736 | 2021-11-16 | Roane | West Virginia | 54087 | 1705 | 24 |
1920487 | 1920487 | 2021-11-15 | Roane | West Virginia | 54087 | 1696 | 24 |
1917237 | 1917237 | 2021-11-14 | Roane | West Virginia | 54087 | 1690 | 24 |
1913987 | 1913987 | 2021-11-13 | Roane | West Virginia | 54087 | 1686 | 24 |
1910737 | 1910737 | 2021-11-12 | Roane | West Virginia | 54087 | 1681 | 24 |
1907488 | 1907488 | 2021-11-11 | Roane | West Virginia | 54087 | 1666 | 24 |
1904239 | 1904239 | 2021-11-10 | Roane | West Virginia | 54087 | 1654 | 23 |
1900989 | 1900989 | 2021-11-09 | Roane | West Virginia | 54087 | 1642 | 23 |
1897739 | 1897739 | 2021-11-08 | Roane | West Virginia | 54087 | 1633 | 22 |
1894489 | 1894489 | 2021-11-07 | Roane | West Virginia | 54087 | 1620 | 22 |
1891239 | 1891239 | 2021-11-06 | Roane | West Virginia | 54087 | 1615 | 22 |
1887989 | 1887989 | 2021-11-05 | Roane | West Virginia | 54087 | 1598 | 22 |
1884739 | 1884739 | 2021-11-04 | Roane | West Virginia | 54087 | 1582 | 22 |
1881490 | 1881490 | 2021-11-03 | Roane | West Virginia | 54087 | 1574 | 21 |
1878241 | 1878241 | 2021-11-02 | Roane | West Virginia | 54087 | 1560 | 21 |
1874992 | 1874992 | 2021-11-01 | Roane | West Virginia | 54087 | 1554 | 21 |
1871743 | 1871743 | 2021-10-31 | Roane | West Virginia | 54087 | 1543 | 21 |
1868494 | 1868494 | 2021-10-30 | Roane | West Virginia | 54087 | 1529 | 21 |
1865245 | 1865245 | 2021-10-29 | Roane | West Virginia | 54087 | 1518 | 21 |
1861996 | 1861996 | 2021-10-28 | Roane | West Virginia | 54087 | 1506 | 21 |
1858747 | 1858747 | 2021-10-27 | Roane | West Virginia | 54087 | 1490 | 21 |
1855498 | 1855498 | 2021-10-26 | Roane | West Virginia | 54087 | 1478 | 19 |
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);