ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where fips = 54001 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 |
---|---|---|---|---|---|---|---|
1813216 | 1813216 | 2021-10-13 | Barbour | West Virginia | 54001 | 2547 | 43 |
1809967 | 1809967 | 2021-10-12 | Barbour | West Virginia | 54001 | 2531 | 43 |
1806718 | 1806718 | 2021-10-11 | Barbour | West Virginia | 54001 | 2526 | 43 |
1803467 | 1803467 | 2021-10-10 | Barbour | West Virginia | 54001 | 2511 | 43 |
1800218 | 1800218 | 2021-10-09 | Barbour | West Virginia | 54001 | 2502 | 43 |
1796969 | 1796969 | 2021-10-08 | Barbour | West Virginia | 54001 | 2492 | 43 |
1793720 | 1793720 | 2021-10-07 | Barbour | West Virginia | 54001 | 2478 | 43 |
1790471 | 1790471 | 2021-10-06 | Barbour | West Virginia | 54001 | 2469 | 43 |
1787223 | 1787223 | 2021-10-05 | Barbour | West Virginia | 54001 | 2463 | 42 |
1783974 | 1783974 | 2021-10-04 | Barbour | West Virginia | 54001 | 2457 | 42 |
1780725 | 1780725 | 2021-10-03 | Barbour | West Virginia | 54001 | 2452 | 41 |
1777475 | 1777475 | 2021-10-02 | Barbour | West Virginia | 54001 | 2448 | 41 |
1774225 | 1774225 | 2021-10-01 | Barbour | West Virginia | 54001 | 2439 | 41 |
1770975 | 1770975 | 2021-09-30 | Barbour | West Virginia | 54001 | 2417 | 40 |
1767726 | 1767726 | 2021-09-29 | Barbour | West Virginia | 54001 | 2397 | 40 |
1764477 | 1764477 | 2021-09-28 | Barbour | West Virginia | 54001 | 2384 | 40 |
1761228 | 1761228 | 2021-09-27 | Barbour | West Virginia | 54001 | 2379 | 40 |
1757980 | 1757980 | 2021-09-26 | Barbour | West Virginia | 54001 | 2368 | 40 |
1754732 | 1754732 | 2021-09-25 | Barbour | West Virginia | 54001 | 2361 | 40 |
1751484 | 1751484 | 2021-09-24 | Barbour | West Virginia | 54001 | 2352 | 40 |
1748235 | 1748235 | 2021-09-23 | Barbour | West Virginia | 54001 | 2323 | 40 |
1744985 | 1744985 | 2021-09-22 | Barbour | West Virginia | 54001 | 2310 | 40 |
1741736 | 1741736 | 2021-09-21 | Barbour | West Virginia | 54001 | 2296 | 40 |
1738487 | 1738487 | 2021-09-20 | Barbour | West Virginia | 54001 | 2281 | 40 |
1735238 | 1735238 | 2021-09-19 | Barbour | West Virginia | 54001 | 2275 | 39 |
1731988 | 1731988 | 2021-09-18 | Barbour | West Virginia | 54001 | 2268 | 39 |
1728738 | 1728738 | 2021-09-17 | Barbour | West Virginia | 54001 | 2249 | 39 |
1725488 | 1725488 | 2021-09-16 | Barbour | West Virginia | 54001 | 2217 | 37 |
1722239 | 1722239 | 2021-09-15 | Barbour | West Virginia | 54001 | 2207 | 37 |
1718991 | 1718991 | 2021-09-14 | Barbour | West Virginia | 54001 | 2175 | 37 |
1715743 | 1715743 | 2021-09-13 | Barbour | West Virginia | 54001 | 2162 | 37 |
1712497 | 1712497 | 2021-09-12 | Barbour | West Virginia | 54001 | 2156 | 37 |
1709250 | 1709250 | 2021-09-11 | Barbour | West Virginia | 54001 | 2152 | 37 |
1706003 | 1706003 | 2021-09-10 | Barbour | West Virginia | 54001 | 2133 | 37 |
1702753 | 1702753 | 2021-09-09 | Barbour | West Virginia | 54001 | 2115 | 35 |
1699504 | 1699504 | 2021-09-08 | Barbour | West Virginia | 54001 | 2096 | 35 |
1696256 | 1696256 | 2021-09-07 | Barbour | West Virginia | 54001 | 2080 | 35 |
1693008 | 1693008 | 2021-09-06 | Barbour | West Virginia | 54001 | 2070 | 35 |
1689759 | 1689759 | 2021-09-05 | Barbour | West Virginia | 54001 | 2055 | 35 |
1686509 | 1686509 | 2021-09-04 | Barbour | West Virginia | 54001 | 2042 | 35 |
1683258 | 1683258 | 2021-09-03 | Barbour | West Virginia | 54001 | 2018 | 35 |
1680008 | 1680008 | 2021-09-02 | Barbour | West Virginia | 54001 | 2016 | 35 |
1676760 | 1676760 | 2021-09-01 | Barbour | West Virginia | 54001 | 1994 | 35 |
1673513 | 1673513 | 2021-08-31 | Barbour | West Virginia | 54001 | 1966 | 34 |
1670265 | 1670265 | 2021-08-30 | Barbour | West Virginia | 54001 | 1947 | 34 |
1667018 | 1667018 | 2021-08-29 | Barbour | West Virginia | 54001 | 1937 | 34 |
1663770 | 1663770 | 2021-08-28 | Barbour | West Virginia | 54001 | 1873 | 34 |
1660522 | 1660522 | 2021-08-27 | Barbour | West Virginia | 54001 | 1873 | 34 |
1657274 | 1657274 | 2021-08-26 | Barbour | West Virginia | 54001 | 1839 | 34 |
1654026 | 1654026 | 2021-08-25 | Barbour | West Virginia | 54001 | 1808 | 34 |
1650780 | 1650780 | 2021-08-24 | Barbour | West Virginia | 54001 | 1789 | 34 |
1647531 | 1647531 | 2021-08-23 | Barbour | West Virginia | 54001 | 1783 | 34 |
1644282 | 1644282 | 2021-08-22 | Barbour | West Virginia | 54001 | 1727 | 34 |
1641032 | 1641032 | 2021-08-21 | Barbour | West Virginia | 54001 | 1727 | 34 |
1637782 | 1637782 | 2021-08-20 | Barbour | West Virginia | 54001 | 1727 | 34 |
1634532 | 1634532 | 2021-08-19 | Barbour | West Virginia | 54001 | 1707 | 34 |
1631284 | 1631284 | 2021-08-18 | Barbour | West Virginia | 54001 | 1672 | 34 |
1628037 | 1628037 | 2021-08-17 | Barbour | West Virginia | 54001 | 1648 | 34 |
1624790 | 1624790 | 2021-08-16 | Barbour | West Virginia | 54001 | 1631 | 34 |
1621543 | 1621543 | 2021-08-15 | Barbour | West Virginia | 54001 | 1603 | 34 |
1618295 | 1618295 | 2021-08-14 | Barbour | West Virginia | 54001 | 1603 | 34 |
1615047 | 1615047 | 2021-08-13 | Barbour | West Virginia | 54001 | 1603 | 34 |
1611798 | 1611798 | 2021-08-12 | Barbour | West Virginia | 54001 | 1594 | 34 |
1608551 | 1608551 | 2021-08-11 | Barbour | West Virginia | 54001 | 1587 | 34 |
1605302 | 1605302 | 2021-08-10 | Barbour | West Virginia | 54001 | 1579 | 34 |
1602052 | 1602052 | 2021-08-09 | Barbour | West Virginia | 54001 | 1571 | 34 |
1598804 | 1598804 | 2021-08-08 | Barbour | West Virginia | 54001 | 1563 | 34 |
1595555 | 1595555 | 2021-08-07 | Barbour | West Virginia | 54001 | 1563 | 34 |
1592306 | 1592306 | 2021-08-06 | Barbour | West Virginia | 54001 | 1563 | 34 |
1589057 | 1589057 | 2021-08-05 | Barbour | West Virginia | 54001 | 1557 | 34 |
1585808 | 1585808 | 2021-08-04 | Barbour | West Virginia | 54001 | 1556 | 34 |
1582558 | 1582558 | 2021-08-03 | Barbour | West Virginia | 54001 | 1548 | 34 |
1579308 | 1579308 | 2021-08-02 | Barbour | West Virginia | 54001 | 1544 | 34 |
1576060 | 1576060 | 2021-08-01 | Barbour | West Virginia | 54001 | 1542 | 34 |
1572812 | 1572812 | 2021-07-31 | Barbour | West Virginia | 54001 | 1542 | 34 |
1569564 | 1569564 | 2021-07-30 | Barbour | West Virginia | 54001 | 1542 | 34 |
1566316 | 1566316 | 2021-07-29 | Barbour | West Virginia | 54001 | 1540 | 34 |
1563068 | 1563068 | 2021-07-28 | Barbour | West Virginia | 54001 | 1536 | 34 |
1559820 | 1559820 | 2021-07-27 | Barbour | West Virginia | 54001 | 1534 | 34 |
1556573 | 1556573 | 2021-07-26 | Barbour | West Virginia | 54001 | 1526 | 34 |
1553326 | 1553326 | 2021-07-25 | Barbour | West Virginia | 54001 | 1522 | 34 |
1550079 | 1550079 | 2021-07-24 | Barbour | West Virginia | 54001 | 1522 | 34 |
1546832 | 1546832 | 2021-07-23 | Barbour | West Virginia | 54001 | 1522 | 34 |
1543585 | 1543585 | 2021-07-22 | Barbour | West Virginia | 54001 | 1522 | 34 |
1540337 | 1540337 | 2021-07-21 | Barbour | West Virginia | 54001 | 1521 | 34 |
1537090 | 1537090 | 2021-07-20 | Barbour | West Virginia | 54001 | 1521 | 34 |
1533842 | 1533842 | 2021-07-19 | Barbour | West Virginia | 54001 | 1519 | 34 |
1530595 | 1530595 | 2021-07-18 | Barbour | West Virginia | 54001 | 1515 | 34 |
1527348 | 1527348 | 2021-07-17 | Barbour | West Virginia | 54001 | 1515 | 34 |
1524101 | 1524101 | 2021-07-16 | Barbour | West Virginia | 54001 | 1515 | 34 |
1520853 | 1520853 | 2021-07-15 | Barbour | West Virginia | 54001 | 1517 | 33 |
1517605 | 1517605 | 2021-07-14 | Barbour | West Virginia | 54001 | 1517 | 33 |
1514358 | 1514358 | 2021-07-13 | Barbour | West Virginia | 54001 | 1518 | 32 |
1511112 | 1511112 | 2021-07-12 | Barbour | West Virginia | 54001 | 1516 | 32 |
1507865 | 1507865 | 2021-07-11 | Barbour | West Virginia | 54001 | 1516 | 32 |
1504619 | 1504619 | 2021-07-10 | Barbour | West Virginia | 54001 | 1516 | 32 |
1501373 | 1501373 | 2021-07-09 | Barbour | West Virginia | 54001 | 1516 | 32 |
1498127 | 1498127 | 2021-07-08 | Barbour | West Virginia | 54001 | 1516 | 32 |
1494880 | 1494880 | 2021-07-07 | Barbour | West Virginia | 54001 | 1515 | 32 |
1491633 | 1491633 | 2021-07-06 | Barbour | West Virginia | 54001 | 1515 | 32 |
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);