ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
748 rows where fips = 54013 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 |
---|---|---|---|---|---|---|---|
1839213 | 1839213 | 2021-10-21 | Calhoun | West Virginia | 54013 | 903 | 4 |
1835964 | 1835964 | 2021-10-20 | Calhoun | West Virginia | 54013 | 894 | 4 |
1832715 | 1832715 | 2021-10-19 | Calhoun | West Virginia | 54013 | 886 | 4 |
1829466 | 1829466 | 2021-10-18 | Calhoun | West Virginia | 54013 | 881 | 4 |
1826217 | 1826217 | 2021-10-17 | Calhoun | West Virginia | 54013 | 879 | 4 |
1822968 | 1822968 | 2021-10-16 | Calhoun | West Virginia | 54013 | 872 | 4 |
1819719 | 1819719 | 2021-10-15 | Calhoun | West Virginia | 54013 | 872 | 4 |
1816470 | 1816470 | 2021-10-14 | Calhoun | West Virginia | 54013 | 866 | 4 |
1813222 | 1813222 | 2021-10-13 | Calhoun | West Virginia | 54013 | 856 | 4 |
1809973 | 1809973 | 2021-10-12 | Calhoun | West Virginia | 54013 | 848 | 4 |
1806724 | 1806724 | 2021-10-11 | Calhoun | West Virginia | 54013 | 847 | 4 |
1803473 | 1803473 | 2021-10-10 | Calhoun | West Virginia | 54013 | 846 | 4 |
1800224 | 1800224 | 2021-10-09 | Calhoun | West Virginia | 54013 | 836 | 4 |
1796975 | 1796975 | 2021-10-08 | Calhoun | West Virginia | 54013 | 834 | 4 |
1793726 | 1793726 | 2021-10-07 | Calhoun | West Virginia | 54013 | 834 | 4 |
1790477 | 1790477 | 2021-10-06 | Calhoun | West Virginia | 54013 | 830 | 4 |
1787229 | 1787229 | 2021-10-05 | Calhoun | West Virginia | 54013 | 822 | 4 |
1783980 | 1783980 | 2021-10-04 | Calhoun | West Virginia | 54013 | 822 | 4 |
1780731 | 1780731 | 2021-10-03 | Calhoun | West Virginia | 54013 | 821 | 4 |
1777481 | 1777481 | 2021-10-02 | Calhoun | West Virginia | 54013 | 818 | 4 |
1774231 | 1774231 | 2021-10-01 | Calhoun | West Virginia | 54013 | 820 | 4 |
1770981 | 1770981 | 2021-09-30 | Calhoun | West Virginia | 54013 | 812 | 4 |
1767732 | 1767732 | 2021-09-29 | Calhoun | West Virginia | 54013 | 808 | 3 |
1764483 | 1764483 | 2021-09-28 | Calhoun | West Virginia | 54013 | 805 | 2 |
1761234 | 1761234 | 2021-09-27 | Calhoun | West Virginia | 54013 | 805 | 2 |
1757986 | 1757986 | 2021-09-26 | Calhoun | West Virginia | 54013 | 803 | 2 |
1754738 | 1754738 | 2021-09-25 | Calhoun | West Virginia | 54013 | 798 | 2 |
1751490 | 1751490 | 2021-09-24 | Calhoun | West Virginia | 54013 | 798 | 2 |
1748241 | 1748241 | 2021-09-23 | Calhoun | West Virginia | 54013 | 790 | 2 |
1744991 | 1744991 | 2021-09-22 | Calhoun | West Virginia | 54013 | 788 | 2 |
1741742 | 1741742 | 2021-09-21 | Calhoun | West Virginia | 54013 | 777 | 2 |
1738493 | 1738493 | 2021-09-20 | Calhoun | West Virginia | 54013 | 773 | 2 |
1735244 | 1735244 | 2021-09-19 | Calhoun | West Virginia | 54013 | 770 | 2 |
1731994 | 1731994 | 2021-09-18 | Calhoun | West Virginia | 54013 | 769 | 2 |
1728744 | 1728744 | 2021-09-17 | Calhoun | West Virginia | 54013 | 753 | 2 |
1725494 | 1725494 | 2021-09-16 | Calhoun | West Virginia | 54013 | 741 | 2 |
1722245 | 1722245 | 2021-09-15 | Calhoun | West Virginia | 54013 | 730 | 2 |
1718997 | 1718997 | 2021-09-14 | Calhoun | West Virginia | 54013 | 725 | 1 |
1715749 | 1715749 | 2021-09-13 | Calhoun | West Virginia | 54013 | 722 | 1 |
1712503 | 1712503 | 2021-09-12 | Calhoun | West Virginia | 54013 | 717 | 1 |
1709256 | 1709256 | 2021-09-11 | Calhoun | West Virginia | 54013 | 713 | 1 |
1706009 | 1706009 | 2021-09-10 | Calhoun | West Virginia | 54013 | 696 | 1 |
1702759 | 1702759 | 2021-09-09 | Calhoun | West Virginia | 54013 | 659 | 1 |
1699510 | 1699510 | 2021-09-08 | Calhoun | West Virginia | 54013 | 640 | 1 |
1696262 | 1696262 | 2021-09-07 | Calhoun | West Virginia | 54013 | 639 | 1 |
1693014 | 1693014 | 2021-09-06 | Calhoun | West Virginia | 54013 | 611 | 1 |
1689765 | 1689765 | 2021-09-05 | Calhoun | West Virginia | 54013 | 607 | 1 |
1686515 | 1686515 | 2021-09-04 | Calhoun | West Virginia | 54013 | 603 | 1 |
1683264 | 1683264 | 2021-09-03 | Calhoun | West Virginia | 54013 | 580 | 1 |
1680014 | 1680014 | 2021-09-02 | Calhoun | West Virginia | 54013 | 549 | 1 |
1676766 | 1676766 | 2021-09-01 | Calhoun | West Virginia | 54013 | 523 | 1 |
1673519 | 1673519 | 2021-08-31 | Calhoun | West Virginia | 54013 | 499 | 1 |
1670271 | 1670271 | 2021-08-30 | Calhoun | West Virginia | 54013 | 476 | 1 |
1667024 | 1667024 | 2021-08-29 | Calhoun | West Virginia | 54013 | 472 | 1 |
1663776 | 1663776 | 2021-08-28 | Calhoun | West Virginia | 54013 | 462 | 1 |
1660528 | 1660528 | 2021-08-27 | Calhoun | West Virginia | 54013 | 462 | 1 |
1657280 | 1657280 | 2021-08-26 | Calhoun | West Virginia | 54013 | 450 | 1 |
1654032 | 1654032 | 2021-08-25 | Calhoun | West Virginia | 54013 | 442 | 1 |
1650786 | 1650786 | 2021-08-24 | Calhoun | West Virginia | 54013 | 436 | 1 |
1647537 | 1647537 | 2021-08-23 | Calhoun | West Virginia | 54013 | 430 | 1 |
1644288 | 1644288 | 2021-08-22 | Calhoun | West Virginia | 54013 | 424 | 1 |
1641038 | 1641038 | 2021-08-21 | Calhoun | West Virginia | 54013 | 424 | 1 |
1637788 | 1637788 | 2021-08-20 | Calhoun | West Virginia | 54013 | 424 | 1 |
1634538 | 1634538 | 2021-08-19 | Calhoun | West Virginia | 54013 | 424 | 1 |
1631290 | 1631290 | 2021-08-18 | Calhoun | West Virginia | 54013 | 423 | 1 |
1628043 | 1628043 | 2021-08-17 | Calhoun | West Virginia | 54013 | 422 | 1 |
1624796 | 1624796 | 2021-08-16 | Calhoun | West Virginia | 54013 | 419 | 1 |
1621549 | 1621549 | 2021-08-15 | Calhoun | West Virginia | 54013 | 415 | 1 |
1618301 | 1618301 | 2021-08-14 | Calhoun | West Virginia | 54013 | 415 | 1 |
1615053 | 1615053 | 2021-08-13 | Calhoun | West Virginia | 54013 | 415 | 1 |
1611804 | 1611804 | 2021-08-12 | Calhoun | West Virginia | 54013 | 415 | 1 |
1608557 | 1608557 | 2021-08-11 | Calhoun | West Virginia | 54013 | 419 | 1 |
1605308 | 1605308 | 2021-08-10 | Calhoun | West Virginia | 54013 | 417 | 1 |
1602058 | 1602058 | 2021-08-09 | Calhoun | West Virginia | 54013 | 411 | 1 |
1598810 | 1598810 | 2021-08-08 | Calhoun | West Virginia | 54013 | 410 | 1 |
1595561 | 1595561 | 2021-08-07 | Calhoun | West Virginia | 54013 | 410 | 1 |
1592312 | 1592312 | 2021-08-06 | Calhoun | West Virginia | 54013 | 410 | 1 |
1589063 | 1589063 | 2021-08-05 | Calhoun | West Virginia | 54013 | 407 | 1 |
1585814 | 1585814 | 2021-08-04 | Calhoun | West Virginia | 54013 | 406 | 1 |
1582564 | 1582564 | 2021-08-03 | Calhoun | West Virginia | 54013 | 405 | 1 |
1579314 | 1579314 | 2021-08-02 | Calhoun | West Virginia | 54013 | 404 | 1 |
1576066 | 1576066 | 2021-08-01 | Calhoun | West Virginia | 54013 | 403 | 1 |
1572818 | 1572818 | 2021-07-31 | Calhoun | West Virginia | 54013 | 403 | 1 |
1569570 | 1569570 | 2021-07-30 | Calhoun | West Virginia | 54013 | 403 | 1 |
1566322 | 1566322 | 2021-07-29 | Calhoun | West Virginia | 54013 | 403 | 1 |
1563074 | 1563074 | 2021-07-28 | Calhoun | West Virginia | 54013 | 403 | 1 |
1559826 | 1559826 | 2021-07-27 | Calhoun | West Virginia | 54013 | 404 | 1 |
1556579 | 1556579 | 2021-07-26 | Calhoun | West Virginia | 54013 | 400 | 1 |
1553332 | 1553332 | 2021-07-25 | Calhoun | West Virginia | 54013 | 400 | 1 |
1550085 | 1550085 | 2021-07-24 | Calhoun | West Virginia | 54013 | 400 | 1 |
1546838 | 1546838 | 2021-07-23 | Calhoun | West Virginia | 54013 | 400 | 1 |
1543591 | 1543591 | 2021-07-22 | Calhoun | West Virginia | 54013 | 399 | 1 |
1540343 | 1540343 | 2021-07-21 | Calhoun | West Virginia | 54013 | 399 | 1 |
1537096 | 1537096 | 2021-07-20 | Calhoun | West Virginia | 54013 | 399 | 1 |
1533848 | 1533848 | 2021-07-19 | Calhoun | West Virginia | 54013 | 399 | 1 |
1530601 | 1530601 | 2021-07-18 | Calhoun | West Virginia | 54013 | 399 | 1 |
1527354 | 1527354 | 2021-07-17 | Calhoun | West Virginia | 54013 | 399 | 1 |
1524107 | 1524107 | 2021-07-16 | Calhoun | West Virginia | 54013 | 399 | 1 |
1520859 | 1520859 | 2021-07-15 | Calhoun | West Virginia | 54013 | 399 | 1 |
1517611 | 1517611 | 2021-07-14 | Calhoun | West Virginia | 54013 | 398 | 1 |
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);