ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
748 rows where county = "Calhoun" 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 |
---|---|---|---|---|---|---|---|
1949703 | 1949703 | 2021-11-24 | Calhoun | West Virginia | 54013 | 1050 | 6 |
1946452 | 1946452 | 2021-11-23 | Calhoun | West Virginia | 54013 | 1047 | 6 |
1943201 | 1943201 | 2021-11-22 | Calhoun | West Virginia | 54013 | 1046 | 5 |
1939951 | 1939951 | 2021-11-21 | Calhoun | West Virginia | 54013 | 1046 | 5 |
1936701 | 1936701 | 2021-11-20 | Calhoun | West Virginia | 54013 | 1043 | 5 |
1933451 | 1933451 | 2021-11-19 | Calhoun | West Virginia | 54013 | 1038 | 5 |
1930199 | 1930199 | 2021-11-18 | Calhoun | West Virginia | 54013 | 1031 | 5 |
1926949 | 1926949 | 2021-11-17 | Calhoun | West Virginia | 54013 | 1016 | 5 |
1923699 | 1923699 | 2021-11-16 | Calhoun | West Virginia | 54013 | 1011 | 5 |
1920450 | 1920450 | 2021-11-15 | Calhoun | West Virginia | 54013 | 1008 | 5 |
1917200 | 1917200 | 2021-11-14 | Calhoun | West Virginia | 54013 | 1003 | 5 |
1913950 | 1913950 | 2021-11-13 | Calhoun | West Virginia | 54013 | 1002 | 5 |
1910700 | 1910700 | 2021-11-12 | Calhoun | West Virginia | 54013 | 998 | 5 |
1907451 | 1907451 | 2021-11-11 | Calhoun | West Virginia | 54013 | 991 | 5 |
1904202 | 1904202 | 2021-11-10 | Calhoun | West Virginia | 54013 | 988 | 5 |
1900952 | 1900952 | 2021-11-09 | Calhoun | West Virginia | 54013 | 982 | 5 |
1897702 | 1897702 | 2021-11-08 | Calhoun | West Virginia | 54013 | 979 | 5 |
1894452 | 1894452 | 2021-11-07 | Calhoun | West Virginia | 54013 | 978 | 5 |
1891202 | 1891202 | 2021-11-06 | Calhoun | West Virginia | 54013 | 978 | 5 |
1887952 | 1887952 | 2021-11-05 | Calhoun | West Virginia | 54013 | 972 | 5 |
1884702 | 1884702 | 2021-11-04 | Calhoun | West Virginia | 54013 | 968 | 5 |
1881453 | 1881453 | 2021-11-03 | Calhoun | West Virginia | 54013 | 963 | 5 |
1878204 | 1878204 | 2021-11-02 | Calhoun | West Virginia | 54013 | 959 | 5 |
1874955 | 1874955 | 2021-11-01 | Calhoun | West Virginia | 54013 | 960 | 5 |
1871706 | 1871706 | 2021-10-31 | Calhoun | West Virginia | 54013 | 959 | 4 |
1868457 | 1868457 | 2021-10-30 | Calhoun | West Virginia | 54013 | 956 | 4 |
1865208 | 1865208 | 2021-10-29 | Calhoun | West Virginia | 54013 | 949 | 4 |
1861959 | 1861959 | 2021-10-28 | Calhoun | West Virginia | 54013 | 940 | 4 |
1858710 | 1858710 | 2021-10-27 | Calhoun | West Virginia | 54013 | 927 | 4 |
1855461 | 1855461 | 2021-10-26 | Calhoun | West Virginia | 54013 | 922 | 4 |
1852212 | 1852212 | 2021-10-25 | Calhoun | West Virginia | 54013 | 918 | 4 |
1848962 | 1848962 | 2021-10-24 | Calhoun | West Virginia | 54013 | 915 | 4 |
1845712 | 1845712 | 2021-10-23 | Calhoun | West Virginia | 54013 | 916 | 4 |
1842462 | 1842462 | 2021-10-22 | Calhoun | West Virginia | 54013 | 908 | 4 |
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 |
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);