ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 54079 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 |
---|---|---|---|---|---|---|---|
2112269 | 2112269 | 2022-01-13 | Putnam | West Virginia | 54079 | 12264 | 148 |
2109017 | 2109017 | 2022-01-12 | Putnam | West Virginia | 54079 | 11943 | 148 |
2105766 | 2105766 | 2022-01-11 | Putnam | West Virginia | 54079 | 11786 | 147 |
2102515 | 2102515 | 2022-01-10 | Putnam | West Virginia | 54079 | 11718 | 147 |
2099264 | 2099264 | 2022-01-09 | Putnam | West Virginia | 54079 | 11654 | 147 |
2096013 | 2096013 | 2022-01-08 | Putnam | West Virginia | 54079 | 11603 | 147 |
2092761 | 2092761 | 2022-01-07 | Putnam | West Virginia | 54079 | 11455 | 147 |
2089509 | 2089509 | 2022-01-06 | Putnam | West Virginia | 54079 | 11264 | 147 |
2086258 | 2086258 | 2022-01-05 | Putnam | West Virginia | 54079 | 11121 | 147 |
2083006 | 2083006 | 2022-01-04 | Putnam | West Virginia | 54079 | 11030 | 147 |
2079754 | 2079754 | 2022-01-03 | Putnam | West Virginia | 54079 | 10972 | 147 |
2076502 | 2076502 | 2022-01-02 | Putnam | West Virginia | 54079 | 10690 | 147 |
2073251 | 2073251 | 2022-01-01 | Putnam | West Virginia | 54079 | 10690 | 147 |
2070000 | 2070000 | 2021-12-31 | Putnam | West Virginia | 54079 | 10690 | 147 |
2066749 | 2066749 | 2021-12-30 | Putnam | West Virginia | 54079 | 10690 | 147 |
2063499 | 2063499 | 2021-12-29 | Putnam | West Virginia | 54079 | 10623 | 146 |
2060249 | 2060249 | 2021-12-28 | Putnam | West Virginia | 54079 | 10549 | 146 |
2057000 | 2057000 | 2021-12-27 | Putnam | West Virginia | 54079 | 10523 | 146 |
2053751 | 2053751 | 2021-12-26 | Putnam | West Virginia | 54079 | 10401 | 146 |
2050501 | 2050501 | 2021-12-25 | Putnam | West Virginia | 54079 | 10401 | 146 |
2047251 | 2047251 | 2021-12-24 | Putnam | West Virginia | 54079 | 10401 | 146 |
2044001 | 2044001 | 2021-12-23 | Putnam | West Virginia | 54079 | 10401 | 146 |
2040752 | 2040752 | 2021-12-22 | Putnam | West Virginia | 54079 | 10338 | 145 |
2037502 | 2037502 | 2021-12-21 | Putnam | West Virginia | 54079 | 10308 | 145 |
2034252 | 2034252 | 2021-12-20 | Putnam | West Virginia | 54079 | 10289 | 144 |
2031002 | 2031002 | 2021-12-19 | Putnam | West Virginia | 54079 | 10263 | 144 |
2027751 | 2027751 | 2021-12-18 | Putnam | West Virginia | 54079 | 10239 | 144 |
2024500 | 2024500 | 2021-12-17 | Putnam | West Virginia | 54079 | 10202 | 144 |
2021249 | 2021249 | 2021-12-16 | Putnam | West Virginia | 54079 | 10172 | 144 |
2017998 | 2017998 | 2021-12-15 | Putnam | West Virginia | 54079 | 10145 | 144 |
2014748 | 2014748 | 2021-12-14 | Putnam | West Virginia | 54079 | 10124 | 144 |
2011497 | 2011497 | 2021-12-13 | Putnam | West Virginia | 54079 | 10094 | 144 |
2008246 | 2008246 | 2021-12-12 | Putnam | West Virginia | 54079 | 10074 | 144 |
2004995 | 2004995 | 2021-12-11 | Putnam | West Virginia | 54079 | 10047 | 144 |
2001744 | 2001744 | 2021-12-10 | Putnam | West Virginia | 54079 | 10005 | 144 |
1998494 | 1998494 | 2021-12-09 | Putnam | West Virginia | 54079 | 9958 | 143 |
1995243 | 1995243 | 2021-12-08 | Putnam | West Virginia | 54079 | 9930 | 143 |
1991992 | 1991992 | 2021-12-07 | Putnam | West Virginia | 54079 | 9903 | 143 |
1988741 | 1988741 | 2021-12-06 | Putnam | West Virginia | 54079 | 9888 | 142 |
1985491 | 1985491 | 2021-12-05 | Putnam | West Virginia | 54079 | 9868 | 141 |
1982241 | 1982241 | 2021-12-04 | Putnam | West Virginia | 54079 | 9837 | 141 |
1978991 | 1978991 | 2021-12-03 | Putnam | West Virginia | 54079 | 9808 | 141 |
1975741 | 1975741 | 2021-12-02 | Putnam | West Virginia | 54079 | 9790 | 141 |
1972492 | 1972492 | 2021-12-01 | Putnam | West Virginia | 54079 | 9755 | 140 |
1969242 | 1969242 | 2021-11-30 | Putnam | West Virginia | 54079 | 9725 | 138 |
1965992 | 1965992 | 2021-11-29 | Putnam | West Virginia | 54079 | 9699 | 136 |
1962740 | 1962740 | 2021-11-28 | Putnam | West Virginia | 54079 | 9613 | 136 |
1959489 | 1959489 | 2021-11-27 | Putnam | West Virginia | 54079 | 9613 | 136 |
1956238 | 1956238 | 2021-11-26 | Putnam | West Virginia | 54079 | 9613 | 136 |
1952987 | 1952987 | 2021-11-25 | Putnam | West Virginia | 54079 | 9613 | 136 |
1949736 | 1949736 | 2021-11-24 | Putnam | West Virginia | 54079 | 9613 | 136 |
1946485 | 1946485 | 2021-11-23 | Putnam | West Virginia | 54079 | 9589 | 134 |
1943234 | 1943234 | 2021-11-22 | Putnam | West Virginia | 54079 | 9537 | 132 |
1939984 | 1939984 | 2021-11-21 | Putnam | West Virginia | 54079 | 9524 | 132 |
1936734 | 1936734 | 2021-11-20 | Putnam | West Virginia | 54079 | 9496 | 132 |
1933484 | 1933484 | 2021-11-19 | Putnam | West Virginia | 54079 | 9463 | 132 |
1930232 | 1930232 | 2021-11-18 | Putnam | West Virginia | 54079 | 9435 | 132 |
1926982 | 1926982 | 2021-11-17 | Putnam | West Virginia | 54079 | 9395 | 129 |
1923732 | 1923732 | 2021-11-16 | Putnam | West Virginia | 54079 | 9352 | 128 |
1920483 | 1920483 | 2021-11-15 | Putnam | West Virginia | 54079 | 9340 | 128 |
1917233 | 1917233 | 2021-11-14 | Putnam | West Virginia | 54079 | 9325 | 125 |
1913983 | 1913983 | 2021-11-13 | Putnam | West Virginia | 54079 | 9309 | 125 |
1910733 | 1910733 | 2021-11-12 | Putnam | West Virginia | 54079 | 9273 | 125 |
1907484 | 1907484 | 2021-11-11 | Putnam | West Virginia | 54079 | 9242 | 125 |
1904235 | 1904235 | 2021-11-10 | Putnam | West Virginia | 54079 | 9191 | 125 |
1900985 | 1900985 | 2021-11-09 | Putnam | West Virginia | 54079 | 9146 | 125 |
1897735 | 1897735 | 2021-11-08 | Putnam | West Virginia | 54079 | 9131 | 125 |
1894485 | 1894485 | 2021-11-07 | Putnam | West Virginia | 54079 | 9113 | 125 |
1891235 | 1891235 | 2021-11-06 | Putnam | West Virginia | 54079 | 9091 | 125 |
1887985 | 1887985 | 2021-11-05 | Putnam | West Virginia | 54079 | 9057 | 125 |
1884735 | 1884735 | 2021-11-04 | Putnam | West Virginia | 54079 | 9028 | 125 |
1881486 | 1881486 | 2021-11-03 | Putnam | West Virginia | 54079 | 9002 | 125 |
1878237 | 1878237 | 2021-11-02 | Putnam | West Virginia | 54079 | 8964 | 125 |
1874988 | 1874988 | 2021-11-01 | Putnam | West Virginia | 54079 | 8941 | 125 |
1871739 | 1871739 | 2021-10-31 | Putnam | West Virginia | 54079 | 8922 | 124 |
1868490 | 1868490 | 2021-10-30 | Putnam | West Virginia | 54079 | 8903 | 124 |
1865241 | 1865241 | 2021-10-29 | Putnam | West Virginia | 54079 | 8862 | 124 |
1861992 | 1861992 | 2021-10-28 | Putnam | West Virginia | 54079 | 8828 | 124 |
1858743 | 1858743 | 2021-10-27 | Putnam | West Virginia | 54079 | 8793 | 123 |
1855494 | 1855494 | 2021-10-26 | Putnam | West Virginia | 54079 | 8747 | 123 |
1852245 | 1852245 | 2021-10-25 | Putnam | West Virginia | 54079 | 8709 | 123 |
1848995 | 1848995 | 2021-10-24 | Putnam | West Virginia | 54079 | 8667 | 121 |
1845745 | 1845745 | 2021-10-23 | Putnam | West Virginia | 54079 | 8651 | 121 |
1842495 | 1842495 | 2021-10-22 | Putnam | West Virginia | 54079 | 8634 | 121 |
1839246 | 1839246 | 2021-10-21 | Putnam | West Virginia | 54079 | 8600 | 119 |
1835997 | 1835997 | 2021-10-20 | Putnam | West Virginia | 54079 | 8568 | 119 |
1832748 | 1832748 | 2021-10-19 | Putnam | West Virginia | 54079 | 8546 | 119 |
1829499 | 1829499 | 2021-10-18 | Putnam | West Virginia | 54079 | 8519 | 117 |
1826250 | 1826250 | 2021-10-17 | Putnam | West Virginia | 54079 | 8492 | 116 |
1823001 | 1823001 | 2021-10-16 | Putnam | West Virginia | 54079 | 8467 | 116 |
1819752 | 1819752 | 2021-10-15 | Putnam | West Virginia | 54079 | 8419 | 116 |
1816503 | 1816503 | 2021-10-14 | Putnam | West Virginia | 54079 | 8388 | 113 |
1813255 | 1813255 | 2021-10-13 | Putnam | West Virginia | 54079 | 8356 | 113 |
1810006 | 1810006 | 2021-10-12 | Putnam | West Virginia | 54079 | 8324 | 113 |
1806757 | 1806757 | 2021-10-11 | Putnam | West Virginia | 54079 | 8298 | 111 |
1803506 | 1803506 | 2021-10-10 | Putnam | West Virginia | 54079 | 8265 | 111 |
1800257 | 1800257 | 2021-10-09 | Putnam | West Virginia | 54079 | 8231 | 111 |
1797008 | 1797008 | 2021-10-08 | Putnam | West Virginia | 54079 | 8185 | 111 |
1793759 | 1793759 | 2021-10-07 | Putnam | West Virginia | 54079 | 8138 | 110 |
1790510 | 1790510 | 2021-10-06 | Putnam | West Virginia | 54079 | 8109 | 110 |
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);