ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Putnam" 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 |
---|---|---|---|---|---|---|---|
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 |
1787262 | 1787262 | 2021-10-05 | Putnam | West Virginia | 54079 | 8056 | 110 |
1784013 | 1784013 | 2021-10-04 | Putnam | West Virginia | 54079 | 8022 | 110 |
1780764 | 1780764 | 2021-10-03 | Putnam | West Virginia | 54079 | 7995 | 109 |
1777514 | 1777514 | 2021-10-02 | Putnam | West Virginia | 54079 | 7975 | 109 |
1774264 | 1774264 | 2021-10-01 | Putnam | West Virginia | 54079 | 7891 | 109 |
1771014 | 1771014 | 2021-09-30 | Putnam | West Virginia | 54079 | 7825 | 109 |
1767765 | 1767765 | 2021-09-29 | Putnam | West Virginia | 54079 | 7757 | 109 |
1764516 | 1764516 | 2021-09-28 | Putnam | West Virginia | 54079 | 7710 | 109 |
1761267 | 1761267 | 2021-09-27 | Putnam | West Virginia | 54079 | 7685 | 109 |
1758019 | 1758019 | 2021-09-26 | Putnam | West Virginia | 54079 | 7666 | 109 |
1754771 | 1754771 | 2021-09-25 | Putnam | West Virginia | 54079 | 7628 | 109 |
1751523 | 1751523 | 2021-09-24 | Putnam | West Virginia | 54079 | 7558 | 109 |
1748274 | 1748274 | 2021-09-23 | Putnam | West Virginia | 54079 | 7477 | 108 |
1745024 | 1745024 | 2021-09-22 | Putnam | West Virginia | 54079 | 7435 | 108 |
1741775 | 1741775 | 2021-09-21 | Putnam | West Virginia | 54079 | 7362 | 108 |
1738526 | 1738526 | 2021-09-20 | Putnam | West Virginia | 54079 | 7334 | 108 |
1735277 | 1735277 | 2021-09-19 | Putnam | West Virginia | 54079 | 7282 | 107 |
1732027 | 1732027 | 2021-09-18 | Putnam | West Virginia | 54079 | 7237 | 107 |
1728777 | 1728777 | 2021-09-17 | Putnam | West Virginia | 54079 | 7148 | 107 |
1725527 | 1725527 | 2021-09-16 | Putnam | West Virginia | 54079 | 7062 | 107 |
1722278 | 1722278 | 2021-09-15 | Putnam | West Virginia | 54079 | 6996 | 107 |
1719030 | 1719030 | 2021-09-14 | Putnam | West Virginia | 54079 | 6938 | 107 |
1715782 | 1715782 | 2021-09-13 | Putnam | West Virginia | 54079 | 6910 | 106 |
1712536 | 1712536 | 2021-09-12 | Putnam | West Virginia | 54079 | 6850 | 105 |
1709289 | 1709289 | 2021-09-11 | Putnam | West Virginia | 54079 | 6762 | 105 |
1706042 | 1706042 | 2021-09-10 | Putnam | West Virginia | 54079 | 6685 | 105 |
1702792 | 1702792 | 2021-09-09 | Putnam | West Virginia | 54079 | 6584 | 105 |
1699543 | 1699543 | 2021-09-08 | Putnam | West Virginia | 54079 | 6546 | 105 |
1696295 | 1696295 | 2021-09-07 | Putnam | West Virginia | 54079 | 6497 | 104 |
1693047 | 1693047 | 2021-09-06 | Putnam | West Virginia | 54079 | 6476 | 104 |
1689798 | 1689798 | 2021-09-05 | Putnam | West Virginia | 54079 | 6409 | 104 |
1686548 | 1686548 | 2021-09-04 | Putnam | West Virginia | 54079 | 6363 | 104 |
1683297 | 1683297 | 2021-09-03 | Putnam | West Virginia | 54079 | 6292 | 104 |
1680047 | 1680047 | 2021-09-02 | Putnam | West Virginia | 54079 | 6218 | 104 |
1676799 | 1676799 | 2021-09-01 | Putnam | West Virginia | 54079 | 6179 | 102 |
1673552 | 1673552 | 2021-08-31 | Putnam | West Virginia | 54079 | 6132 | 100 |
1670304 | 1670304 | 2021-08-30 | Putnam | West Virginia | 54079 | 6105 | 99 |
1667057 | 1667057 | 2021-08-29 | Putnam | West Virginia | 54079 | 6073 | 99 |
1663809 | 1663809 | 2021-08-28 | Putnam | West Virginia | 54079 | 6004 | 99 |
1660561 | 1660561 | 2021-08-27 | Putnam | West Virginia | 54079 | 6004 | 99 |
1657313 | 1657313 | 2021-08-26 | Putnam | West Virginia | 54079 | 5974 | 99 |
1654065 | 1654065 | 2021-08-25 | Putnam | West Virginia | 54079 | 5936 | 99 |
1650819 | 1650819 | 2021-08-24 | Putnam | West Virginia | 54079 | 5911 | 99 |
1647570 | 1647570 | 2021-08-23 | Putnam | West Virginia | 54079 | 5888 | 99 |
1644321 | 1644321 | 2021-08-22 | Putnam | West Virginia | 54079 | 5821 | 98 |
1641071 | 1641071 | 2021-08-21 | Putnam | West Virginia | 54079 | 5821 | 98 |
1637821 | 1637821 | 2021-08-20 | Putnam | West Virginia | 54079 | 5821 | 98 |
1634571 | 1634571 | 2021-08-19 | Putnam | West Virginia | 54079 | 5800 | 98 |
1631323 | 1631323 | 2021-08-18 | Putnam | West Virginia | 54079 | 5774 | 98 |
1628076 | 1628076 | 2021-08-17 | Putnam | West Virginia | 54079 | 5748 | 97 |
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);