ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 54033 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 |
---|---|---|---|---|---|---|---|
1839223 | 1839223 | 2021-10-21 | Harrison | West Virginia | 54033 | 10895 | 138 |
1835974 | 1835974 | 2021-10-20 | Harrison | West Virginia | 54033 | 10841 | 138 |
1832725 | 1832725 | 2021-10-19 | Harrison | West Virginia | 54033 | 10787 | 137 |
1829476 | 1829476 | 2021-10-18 | Harrison | West Virginia | 54033 | 10765 | 137 |
1826227 | 1826227 | 2021-10-17 | Harrison | West Virginia | 54033 | 10728 | 136 |
1822978 | 1822978 | 2021-10-16 | Harrison | West Virginia | 54033 | 10668 | 136 |
1819729 | 1819729 | 2021-10-15 | Harrison | West Virginia | 54033 | 10612 | 136 |
1816480 | 1816480 | 2021-10-14 | Harrison | West Virginia | 54033 | 10528 | 135 |
1813232 | 1813232 | 2021-10-13 | Harrison | West Virginia | 54033 | 10438 | 130 |
1809983 | 1809983 | 2021-10-12 | Harrison | West Virginia | 54033 | 10348 | 130 |
1806734 | 1806734 | 2021-10-11 | Harrison | West Virginia | 54033 | 10307 | 130 |
1803483 | 1803483 | 2021-10-10 | Harrison | West Virginia | 54033 | 10266 | 127 |
1800234 | 1800234 | 2021-10-09 | Harrison | West Virginia | 54033 | 10195 | 127 |
1796985 | 1796985 | 2021-10-08 | Harrison | West Virginia | 54033 | 10111 | 127 |
1793736 | 1793736 | 2021-10-07 | Harrison | West Virginia | 54033 | 10014 | 124 |
1790487 | 1790487 | 2021-10-06 | Harrison | West Virginia | 54033 | 9902 | 124 |
1787239 | 1787239 | 2021-10-05 | Harrison | West Virginia | 54033 | 9810 | 122 |
1783990 | 1783990 | 2021-10-04 | Harrison | West Virginia | 54033 | 9775 | 122 |
1780741 | 1780741 | 2021-10-03 | Harrison | West Virginia | 54033 | 9719 | 119 |
1777491 | 1777491 | 2021-10-02 | Harrison | West Virginia | 54033 | 9650 | 119 |
1774241 | 1774241 | 2021-10-01 | Harrison | West Virginia | 54033 | 9534 | 118 |
1770991 | 1770991 | 2021-09-30 | Harrison | West Virginia | 54033 | 9425 | 115 |
1767742 | 1767742 | 2021-09-29 | Harrison | West Virginia | 54033 | 9315 | 113 |
1764493 | 1764493 | 2021-09-28 | Harrison | West Virginia | 54033 | 9234 | 106 |
1761244 | 1761244 | 2021-09-27 | Harrison | West Virginia | 54033 | 9186 | 106 |
1757996 | 1757996 | 2021-09-26 | Harrison | West Virginia | 54033 | 9135 | 105 |
1754748 | 1754748 | 2021-09-25 | Harrison | West Virginia | 54033 | 9063 | 105 |
1751500 | 1751500 | 2021-09-24 | Harrison | West Virginia | 54033 | 8954 | 105 |
1748251 | 1748251 | 2021-09-23 | Harrison | West Virginia | 54033 | 8794 | 105 |
1745001 | 1745001 | 2021-09-22 | Harrison | West Virginia | 54033 | 8731 | 103 |
1741752 | 1741752 | 2021-09-21 | Harrison | West Virginia | 54033 | 8622 | 103 |
1738503 | 1738503 | 2021-09-20 | Harrison | West Virginia | 54033 | 8539 | 102 |
1735254 | 1735254 | 2021-09-19 | Harrison | West Virginia | 54033 | 8487 | 101 |
1732004 | 1732004 | 2021-09-18 | Harrison | West Virginia | 54033 | 8389 | 101 |
1728754 | 1728754 | 2021-09-17 | Harrison | West Virginia | 54033 | 8315 | 101 |
1725504 | 1725504 | 2021-09-16 | Harrison | West Virginia | 54033 | 8205 | 100 |
1722255 | 1722255 | 2021-09-15 | Harrison | West Virginia | 54033 | 8097 | 99 |
1719007 | 1719007 | 2021-09-14 | Harrison | West Virginia | 54033 | 7979 | 95 |
1715759 | 1715759 | 2021-09-13 | Harrison | West Virginia | 54033 | 7926 | 95 |
1712513 | 1712513 | 2021-09-12 | Harrison | West Virginia | 54033 | 7879 | 91 |
1709266 | 1709266 | 2021-09-11 | Harrison | West Virginia | 54033 | 7807 | 91 |
1706019 | 1706019 | 2021-09-10 | Harrison | West Virginia | 54033 | 7723 | 91 |
1702769 | 1702769 | 2021-09-09 | Harrison | West Virginia | 54033 | 7629 | 91 |
1699520 | 1699520 | 2021-09-08 | Harrison | West Virginia | 54033 | 7529 | 88 |
1696272 | 1696272 | 2021-09-07 | Harrison | West Virginia | 54033 | 7488 | 87 |
1693024 | 1693024 | 2021-09-06 | Harrison | West Virginia | 54033 | 7448 | 86 |
1689775 | 1689775 | 2021-09-05 | Harrison | West Virginia | 54033 | 7412 | 85 |
1686525 | 1686525 | 2021-09-04 | Harrison | West Virginia | 54033 | 7366 | 85 |
1683274 | 1683274 | 2021-09-03 | Harrison | West Virginia | 54033 | 7300 | 85 |
1680024 | 1680024 | 2021-09-02 | Harrison | West Virginia | 54033 | 7245 | 83 |
1676776 | 1676776 | 2021-09-01 | Harrison | West Virginia | 54033 | 7181 | 83 |
1673529 | 1673529 | 2021-08-31 | Harrison | West Virginia | 54033 | 7121 | 83 |
1670281 | 1670281 | 2021-08-30 | Harrison | West Virginia | 54033 | 7094 | 83 |
1667034 | 1667034 | 2021-08-29 | Harrison | West Virginia | 54033 | 7051 | 83 |
1663786 | 1663786 | 2021-08-28 | Harrison | West Virginia | 54033 | 6940 | 83 |
1660538 | 1660538 | 2021-08-27 | Harrison | West Virginia | 54033 | 6940 | 83 |
1657290 | 1657290 | 2021-08-26 | Harrison | West Virginia | 54033 | 6879 | 83 |
1654042 | 1654042 | 2021-08-25 | Harrison | West Virginia | 54033 | 6833 | 83 |
1650796 | 1650796 | 2021-08-24 | Harrison | West Virginia | 54033 | 6787 | 83 |
1647547 | 1647547 | 2021-08-23 | Harrison | West Virginia | 54033 | 6756 | 83 |
1644298 | 1644298 | 2021-08-22 | Harrison | West Virginia | 54033 | 6673 | 83 |
1641048 | 1641048 | 2021-08-21 | Harrison | West Virginia | 54033 | 6673 | 83 |
1637798 | 1637798 | 2021-08-20 | Harrison | West Virginia | 54033 | 6673 | 83 |
1634548 | 1634548 | 2021-08-19 | Harrison | West Virginia | 54033 | 6640 | 82 |
1631300 | 1631300 | 2021-08-18 | Harrison | West Virginia | 54033 | 6611 | 82 |
1628053 | 1628053 | 2021-08-17 | Harrison | West Virginia | 54033 | 6580 | 82 |
1624806 | 1624806 | 2021-08-16 | Harrison | West Virginia | 54033 | 6537 | 82 |
1621559 | 1621559 | 2021-08-15 | Harrison | West Virginia | 54033 | 6506 | 82 |
1618311 | 1618311 | 2021-08-14 | Harrison | West Virginia | 54033 | 6506 | 82 |
1615063 | 1615063 | 2021-08-13 | Harrison | West Virginia | 54033 | 6506 | 82 |
1611814 | 1611814 | 2021-08-12 | Harrison | West Virginia | 54033 | 6497 | 82 |
1608567 | 1608567 | 2021-08-11 | Harrison | West Virginia | 54033 | 6486 | 82 |
1605318 | 1605318 | 2021-08-10 | Harrison | West Virginia | 54033 | 6464 | 82 |
1602068 | 1602068 | 2021-08-09 | Harrison | West Virginia | 54033 | 6454 | 82 |
1598820 | 1598820 | 2021-08-08 | Harrison | West Virginia | 54033 | 6429 | 83 |
1595571 | 1595571 | 2021-08-07 | Harrison | West Virginia | 54033 | 6429 | 83 |
1592322 | 1592322 | 2021-08-06 | Harrison | West Virginia | 54033 | 6429 | 83 |
1589073 | 1589073 | 2021-08-05 | Harrison | West Virginia | 54033 | 6414 | 83 |
1585824 | 1585824 | 2021-08-04 | Harrison | West Virginia | 54033 | 6404 | 82 |
1582574 | 1582574 | 2021-08-03 | Harrison | West Virginia | 54033 | 6385 | 82 |
1579324 | 1579324 | 2021-08-02 | Harrison | West Virginia | 54033 | 6374 | 82 |
1576076 | 1576076 | 2021-08-01 | Harrison | West Virginia | 54033 | 6354 | 82 |
1572828 | 1572828 | 2021-07-31 | Harrison | West Virginia | 54033 | 6354 | 82 |
1569580 | 1569580 | 2021-07-30 | Harrison | West Virginia | 54033 | 6354 | 82 |
1566332 | 1566332 | 2021-07-29 | Harrison | West Virginia | 54033 | 6341 | 82 |
1563084 | 1563084 | 2021-07-28 | Harrison | West Virginia | 54033 | 6321 | 82 |
1559836 | 1559836 | 2021-07-27 | Harrison | West Virginia | 54033 | 6315 | 82 |
1556589 | 1556589 | 2021-07-26 | Harrison | West Virginia | 54033 | 6300 | 82 |
1553342 | 1553342 | 2021-07-25 | Harrison | West Virginia | 54033 | 6281 | 82 |
1550095 | 1550095 | 2021-07-24 | Harrison | West Virginia | 54033 | 6281 | 82 |
1546848 | 1546848 | 2021-07-23 | Harrison | West Virginia | 54033 | 6281 | 82 |
1543601 | 1543601 | 2021-07-22 | Harrison | West Virginia | 54033 | 6270 | 82 |
1540353 | 1540353 | 2021-07-21 | Harrison | West Virginia | 54033 | 6255 | 82 |
1537106 | 1537106 | 2021-07-20 | Harrison | West Virginia | 54033 | 6252 | 82 |
1533858 | 1533858 | 2021-07-19 | Harrison | West Virginia | 54033 | 6250 | 82 |
1530611 | 1530611 | 2021-07-18 | Harrison | West Virginia | 54033 | 6239 | 82 |
1527364 | 1527364 | 2021-07-17 | Harrison | West Virginia | 54033 | 6239 | 82 |
1524117 | 1524117 | 2021-07-16 | Harrison | West Virginia | 54033 | 6239 | 82 |
1520869 | 1520869 | 2021-07-15 | Harrison | West Virginia | 54033 | 6232 | 82 |
1517621 | 1517621 | 2021-07-14 | Harrison | West Virginia | 54033 | 6226 | 82 |
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);