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 |
---|---|---|---|---|---|---|---|
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 |
1624829 | 1624829 | 2021-08-16 | Putnam | West Virginia | 54079 | 5716 | 97 |
1621582 | 1621582 | 2021-08-15 | Putnam | West Virginia | 54079 | 5641 | 96 |
1618334 | 1618334 | 2021-08-14 | Putnam | West Virginia | 54079 | 5641 | 96 |
1615086 | 1615086 | 2021-08-13 | Putnam | West Virginia | 54079 | 5641 | 96 |
1611837 | 1611837 | 2021-08-12 | Putnam | West Virginia | 54079 | 5628 | 96 |
1608590 | 1608590 | 2021-08-11 | Putnam | West Virginia | 54079 | 5609 | 96 |
1605341 | 1605341 | 2021-08-10 | Putnam | West Virginia | 54079 | 5590 | 96 |
1602091 | 1602091 | 2021-08-09 | Putnam | West Virginia | 54079 | 5579 | 96 |
1598843 | 1598843 | 2021-08-08 | Putnam | West Virginia | 54079 | 5533 | 94 |
1595594 | 1595594 | 2021-08-07 | Putnam | West Virginia | 54079 | 5533 | 94 |
1592345 | 1592345 | 2021-08-06 | Putnam | West Virginia | 54079 | 5533 | 94 |
1589096 | 1589096 | 2021-08-05 | Putnam | West Virginia | 54079 | 5519 | 93 |
1585847 | 1585847 | 2021-08-04 | Putnam | West Virginia | 54079 | 5506 | 93 |
1582597 | 1582597 | 2021-08-03 | Putnam | West Virginia | 54079 | 5495 | 93 |
1579347 | 1579347 | 2021-08-02 | Putnam | West Virginia | 54079 | 5486 | 93 |
1576099 | 1576099 | 2021-08-01 | Putnam | West Virginia | 54079 | 5470 | 93 |
1572851 | 1572851 | 2021-07-31 | Putnam | West Virginia | 54079 | 5470 | 93 |
1569603 | 1569603 | 2021-07-30 | Putnam | West Virginia | 54079 | 5470 | 93 |
1566355 | 1566355 | 2021-07-29 | Putnam | West Virginia | 54079 | 5457 | 93 |
1563107 | 1563107 | 2021-07-28 | Putnam | West Virginia | 54079 | 5445 | 93 |
1559859 | 1559859 | 2021-07-27 | Putnam | West Virginia | 54079 | 5438 | 93 |
1556612 | 1556612 | 2021-07-26 | Putnam | West Virginia | 54079 | 5432 | 93 |
1553365 | 1553365 | 2021-07-25 | Putnam | West Virginia | 54079 | 5415 | 93 |
1550118 | 1550118 | 2021-07-24 | Putnam | West Virginia | 54079 | 5415 | 93 |
1546871 | 1546871 | 2021-07-23 | Putnam | West Virginia | 54079 | 5415 | 93 |
1543624 | 1543624 | 2021-07-22 | Putnam | West Virginia | 54079 | 5402 | 93 |
1540376 | 1540376 | 2021-07-21 | Putnam | West Virginia | 54079 | 5399 | 93 |
1537129 | 1537129 | 2021-07-20 | Putnam | West Virginia | 54079 | 5394 | 93 |
1533881 | 1533881 | 2021-07-19 | Putnam | West Virginia | 54079 | 5387 | 93 |
1530634 | 1530634 | 2021-07-18 | Putnam | West Virginia | 54079 | 5376 | 93 |
1527387 | 1527387 | 2021-07-17 | Putnam | West Virginia | 54079 | 5376 | 93 |
1524140 | 1524140 | 2021-07-16 | Putnam | West Virginia | 54079 | 5376 | 93 |
1520892 | 1520892 | 2021-07-15 | Putnam | West Virginia | 54079 | 5374 | 93 |
1517644 | 1517644 | 2021-07-14 | Putnam | West Virginia | 54079 | 5366 | 93 |
1514397 | 1514397 | 2021-07-13 | Putnam | West Virginia | 54079 | 5362 | 93 |
1511151 | 1511151 | 2021-07-12 | Putnam | West Virginia | 54079 | 5356 | 94 |
1507904 | 1507904 | 2021-07-11 | Putnam | West Virginia | 54079 | 5346 | 93 |
1504658 | 1504658 | 2021-07-10 | Putnam | West Virginia | 54079 | 5346 | 93 |
1501412 | 1501412 | 2021-07-09 | Putnam | West Virginia | 54079 | 5346 | 93 |
1498166 | 1498166 | 2021-07-08 | Putnam | West Virginia | 54079 | 5341 | 93 |
1494919 | 1494919 | 2021-07-07 | Putnam | West Virginia | 54079 | 5336 | 93 |
1491672 | 1491672 | 2021-07-06 | Putnam | West Virginia | 54079 | 5334 | 93 |
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);