ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Nicholas" 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 |
---|---|---|---|---|---|---|---|
1839240 | 1839240 | 2021-10-21 | Nicholas | West Virginia | 54067 | 3564 | 43 |
1835991 | 1835991 | 2021-10-20 | Nicholas | West Virginia | 54067 | 3540 | 42 |
1832742 | 1832742 | 2021-10-19 | Nicholas | West Virginia | 54067 | 3525 | 40 |
1829493 | 1829493 | 2021-10-18 | Nicholas | West Virginia | 54067 | 3511 | 40 |
1826244 | 1826244 | 2021-10-17 | Nicholas | West Virginia | 54067 | 3485 | 39 |
1822995 | 1822995 | 2021-10-16 | Nicholas | West Virginia | 54067 | 3468 | 39 |
1819746 | 1819746 | 2021-10-15 | Nicholas | West Virginia | 54067 | 3433 | 39 |
1816497 | 1816497 | 2021-10-14 | Nicholas | West Virginia | 54067 | 3406 | 38 |
1813249 | 1813249 | 2021-10-13 | Nicholas | West Virginia | 54067 | 3374 | 38 |
1810000 | 1810000 | 2021-10-12 | Nicholas | West Virginia | 54067 | 3350 | 38 |
1806751 | 1806751 | 2021-10-11 | Nicholas | West Virginia | 54067 | 3338 | 38 |
1803500 | 1803500 | 2021-10-10 | Nicholas | West Virginia | 54067 | 3323 | 38 |
1800251 | 1800251 | 2021-10-09 | Nicholas | West Virginia | 54067 | 3300 | 38 |
1797002 | 1797002 | 2021-10-08 | Nicholas | West Virginia | 54067 | 3274 | 38 |
1793753 | 1793753 | 2021-10-07 | Nicholas | West Virginia | 54067 | 3247 | 38 |
1790504 | 1790504 | 2021-10-06 | Nicholas | West Virginia | 54067 | 3222 | 36 |
1787256 | 1787256 | 2021-10-05 | Nicholas | West Virginia | 54067 | 3209 | 35 |
1784007 | 1784007 | 2021-10-04 | Nicholas | West Virginia | 54067 | 3203 | 35 |
1780758 | 1780758 | 2021-10-03 | Nicholas | West Virginia | 54067 | 3186 | 34 |
1777508 | 1777508 | 2021-10-02 | Nicholas | West Virginia | 54067 | 3176 | 34 |
1774258 | 1774258 | 2021-10-01 | Nicholas | West Virginia | 54067 | 3150 | 34 |
1771008 | 1771008 | 2021-09-30 | Nicholas | West Virginia | 54067 | 3128 | 34 |
1767759 | 1767759 | 2021-09-29 | Nicholas | West Virginia | 54067 | 3097 | 33 |
1764510 | 1764510 | 2021-09-28 | Nicholas | West Virginia | 54067 | 3069 | 32 |
1761261 | 1761261 | 2021-09-27 | Nicholas | West Virginia | 54067 | 3045 | 32 |
1758013 | 1758013 | 2021-09-26 | Nicholas | West Virginia | 54067 | 3020 | 32 |
1754765 | 1754765 | 2021-09-25 | Nicholas | West Virginia | 54067 | 3001 | 32 |
1751517 | 1751517 | 2021-09-24 | Nicholas | West Virginia | 54067 | 2983 | 32 |
1748268 | 1748268 | 2021-09-23 | Nicholas | West Virginia | 54067 | 2940 | 32 |
1745018 | 1745018 | 2021-09-22 | Nicholas | West Virginia | 54067 | 2908 | 31 |
1741769 | 1741769 | 2021-09-21 | Nicholas | West Virginia | 54067 | 2882 | 30 |
1738520 | 1738520 | 2021-09-20 | Nicholas | West Virginia | 54067 | 2876 | 30 |
1735271 | 1735271 | 2021-09-19 | Nicholas | West Virginia | 54067 | 2853 | 29 |
1732021 | 1732021 | 2021-09-18 | Nicholas | West Virginia | 54067 | 2825 | 29 |
1728771 | 1728771 | 2021-09-17 | Nicholas | West Virginia | 54067 | 2795 | 29 |
1725521 | 1725521 | 2021-09-16 | Nicholas | West Virginia | 54067 | 2751 | 29 |
1722272 | 1722272 | 2021-09-15 | Nicholas | West Virginia | 54067 | 2721 | 29 |
1719024 | 1719024 | 2021-09-14 | Nicholas | West Virginia | 54067 | 2704 | 29 |
1715776 | 1715776 | 2021-09-13 | Nicholas | West Virginia | 54067 | 2685 | 29 |
1712530 | 1712530 | 2021-09-12 | Nicholas | West Virginia | 54067 | 2657 | 29 |
1709283 | 1709283 | 2021-09-11 | Nicholas | West Virginia | 54067 | 2627 | 29 |
1706036 | 1706036 | 2021-09-10 | Nicholas | West Virginia | 54067 | 2582 | 29 |
1702786 | 1702786 | 2021-09-09 | Nicholas | West Virginia | 54067 | 2531 | 29 |
1699537 | 1699537 | 2021-09-08 | Nicholas | West Virginia | 54067 | 2512 | 29 |
1696289 | 1696289 | 2021-09-07 | Nicholas | West Virginia | 54067 | 2482 | 29 |
1693041 | 1693041 | 2021-09-06 | Nicholas | West Virginia | 54067 | 2467 | 29 |
1689792 | 1689792 | 2021-09-05 | Nicholas | West Virginia | 54067 | 2438 | 29 |
1686542 | 1686542 | 2021-09-04 | Nicholas | West Virginia | 54067 | 2408 | 29 |
1683291 | 1683291 | 2021-09-03 | Nicholas | West Virginia | 54067 | 2380 | 29 |
1680041 | 1680041 | 2021-09-02 | Nicholas | West Virginia | 54067 | 2348 | 29 |
1676793 | 1676793 | 2021-09-01 | Nicholas | West Virginia | 54067 | 2315 | 29 |
1673546 | 1673546 | 2021-08-31 | Nicholas | West Virginia | 54067 | 2303 | 29 |
1670298 | 1670298 | 2021-08-30 | Nicholas | West Virginia | 54067 | 2288 | 29 |
1667051 | 1667051 | 2021-08-29 | Nicholas | West Virginia | 54067 | 2258 | 29 |
1663803 | 1663803 | 2021-08-28 | Nicholas | West Virginia | 54067 | 2197 | 29 |
1660555 | 1660555 | 2021-08-27 | Nicholas | West Virginia | 54067 | 2197 | 29 |
1657307 | 1657307 | 2021-08-26 | Nicholas | West Virginia | 54067 | 2177 | 29 |
1654059 | 1654059 | 2021-08-25 | Nicholas | West Virginia | 54067 | 2151 | 27 |
1650813 | 1650813 | 2021-08-24 | Nicholas | West Virginia | 54067 | 2132 | 26 |
1647564 | 1647564 | 2021-08-23 | Nicholas | West Virginia | 54067 | 2111 | 26 |
1644315 | 1644315 | 2021-08-22 | Nicholas | West Virginia | 54067 | 2077 | 26 |
1641065 | 1641065 | 2021-08-21 | Nicholas | West Virginia | 54067 | 2077 | 26 |
1637815 | 1637815 | 2021-08-20 | Nicholas | West Virginia | 54067 | 2077 | 26 |
1634565 | 1634565 | 2021-08-19 | Nicholas | West Virginia | 54067 | 2062 | 26 |
1631317 | 1631317 | 2021-08-18 | Nicholas | West Virginia | 54067 | 2051 | 26 |
1628070 | 1628070 | 2021-08-17 | Nicholas | West Virginia | 54067 | 2043 | 26 |
1624823 | 1624823 | 2021-08-16 | Nicholas | West Virginia | 54067 | 2029 | 25 |
1621576 | 1621576 | 2021-08-15 | Nicholas | West Virginia | 54067 | 2001 | 25 |
1618328 | 1618328 | 2021-08-14 | Nicholas | West Virginia | 54067 | 2001 | 25 |
1615080 | 1615080 | 2021-08-13 | Nicholas | West Virginia | 54067 | 2001 | 25 |
1611831 | 1611831 | 2021-08-12 | Nicholas | West Virginia | 54067 | 1998 | 25 |
1608584 | 1608584 | 2021-08-11 | Nicholas | West Virginia | 54067 | 1994 | 25 |
1605335 | 1605335 | 2021-08-10 | Nicholas | West Virginia | 54067 | 1990 | 25 |
1602085 | 1602085 | 2021-08-09 | Nicholas | West Virginia | 54067 | 1989 | 25 |
1598837 | 1598837 | 2021-08-08 | Nicholas | West Virginia | 54067 | 1979 | 24 |
1595588 | 1595588 | 2021-08-07 | Nicholas | West Virginia | 54067 | 1979 | 24 |
1592339 | 1592339 | 2021-08-06 | Nicholas | West Virginia | 54067 | 1979 | 24 |
1589090 | 1589090 | 2021-08-05 | Nicholas | West Virginia | 54067 | 1975 | 24 |
1585841 | 1585841 | 2021-08-04 | Nicholas | West Virginia | 54067 | 1970 | 24 |
1582591 | 1582591 | 2021-08-03 | Nicholas | West Virginia | 54067 | 1968 | 24 |
1579341 | 1579341 | 2021-08-02 | Nicholas | West Virginia | 54067 | 1966 | 24 |
1576093 | 1576093 | 2021-08-01 | Nicholas | West Virginia | 54067 | 1955 | 24 |
1572845 | 1572845 | 2021-07-31 | Nicholas | West Virginia | 54067 | 1955 | 24 |
1569597 | 1569597 | 2021-07-30 | Nicholas | West Virginia | 54067 | 1955 | 24 |
1566349 | 1566349 | 2021-07-29 | Nicholas | West Virginia | 54067 | 1953 | 24 |
1563101 | 1563101 | 2021-07-28 | Nicholas | West Virginia | 54067 | 1951 | 24 |
1559853 | 1559853 | 2021-07-27 | Nicholas | West Virginia | 54067 | 1947 | 24 |
1556606 | 1556606 | 2021-07-26 | Nicholas | West Virginia | 54067 | 1943 | 24 |
1553359 | 1553359 | 2021-07-25 | Nicholas | West Virginia | 54067 | 1936 | 24 |
1550112 | 1550112 | 2021-07-24 | Nicholas | West Virginia | 54067 | 1936 | 24 |
1546865 | 1546865 | 2021-07-23 | Nicholas | West Virginia | 54067 | 1936 | 24 |
1543618 | 1543618 | 2021-07-22 | Nicholas | West Virginia | 54067 | 1935 | 24 |
1540370 | 1540370 | 2021-07-21 | Nicholas | West Virginia | 54067 | 1932 | 23 |
1537123 | 1537123 | 2021-07-20 | Nicholas | West Virginia | 54067 | 1927 | 23 |
1533875 | 1533875 | 2021-07-19 | Nicholas | West Virginia | 54067 | 1925 | 23 |
1530628 | 1530628 | 2021-07-18 | Nicholas | West Virginia | 54067 | 1919 | 23 |
1527381 | 1527381 | 2021-07-17 | Nicholas | West Virginia | 54067 | 1919 | 23 |
1524134 | 1524134 | 2021-07-16 | Nicholas | West Virginia | 54067 | 1919 | 23 |
1520886 | 1520886 | 2021-07-15 | Nicholas | West Virginia | 54067 | 1916 | 23 |
1517638 | 1517638 | 2021-07-14 | Nicholas | West Virginia | 54067 | 1914 | 23 |
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);