ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Logan" 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 |
---|---|---|---|---|---|---|---|
1949719 | 1949719 | 2021-11-24 | Logan | West Virginia | 54045 | 5656 | 144 |
1946468 | 1946468 | 2021-11-23 | Logan | West Virginia | 54045 | 5644 | 143 |
1943217 | 1943217 | 2021-11-22 | Logan | West Virginia | 54045 | 5615 | 141 |
1939967 | 1939967 | 2021-11-21 | Logan | West Virginia | 54045 | 5607 | 140 |
1936717 | 1936717 | 2021-11-20 | Logan | West Virginia | 54045 | 5599 | 140 |
1933467 | 1933467 | 2021-11-19 | Logan | West Virginia | 54045 | 5594 | 140 |
1930215 | 1930215 | 2021-11-18 | Logan | West Virginia | 54045 | 5572 | 140 |
1926965 | 1926965 | 2021-11-17 | Logan | West Virginia | 54045 | 5558 | 140 |
1923715 | 1923715 | 2021-11-16 | Logan | West Virginia | 54045 | 5544 | 140 |
1920466 | 1920466 | 2021-11-15 | Logan | West Virginia | 54045 | 5532 | 140 |
1917216 | 1917216 | 2021-11-14 | Logan | West Virginia | 54045 | 5525 | 140 |
1913966 | 1913966 | 2021-11-13 | Logan | West Virginia | 54045 | 5519 | 140 |
1910716 | 1910716 | 2021-11-12 | Logan | West Virginia | 54045 | 5502 | 140 |
1907467 | 1907467 | 2021-11-11 | Logan | West Virginia | 54045 | 5482 | 140 |
1904218 | 1904218 | 2021-11-10 | Logan | West Virginia | 54045 | 5467 | 140 |
1900968 | 1900968 | 2021-11-09 | Logan | West Virginia | 54045 | 5452 | 139 |
1897718 | 1897718 | 2021-11-08 | Logan | West Virginia | 54045 | 5445 | 139 |
1894468 | 1894468 | 2021-11-07 | Logan | West Virginia | 54045 | 5444 | 138 |
1891218 | 1891218 | 2021-11-06 | Logan | West Virginia | 54045 | 5435 | 138 |
1887968 | 1887968 | 2021-11-05 | Logan | West Virginia | 54045 | 5424 | 138 |
1884718 | 1884718 | 2021-11-04 | Logan | West Virginia | 54045 | 5406 | 138 |
1881469 | 1881469 | 2021-11-03 | Logan | West Virginia | 54045 | 5396 | 138 |
1878220 | 1878220 | 2021-11-02 | Logan | West Virginia | 54045 | 5380 | 138 |
1874971 | 1874971 | 2021-11-01 | Logan | West Virginia | 54045 | 5365 | 136 |
1871722 | 1871722 | 2021-10-31 | Logan | West Virginia | 54045 | 5358 | 136 |
1868473 | 1868473 | 2021-10-30 | Logan | West Virginia | 54045 | 5353 | 136 |
1865224 | 1865224 | 2021-10-29 | Logan | West Virginia | 54045 | 5336 | 136 |
1861975 | 1861975 | 2021-10-28 | Logan | West Virginia | 54045 | 5326 | 136 |
1858726 | 1858726 | 2021-10-27 | Logan | West Virginia | 54045 | 5307 | 135 |
1855477 | 1855477 | 2021-10-26 | Logan | West Virginia | 54045 | 5295 | 135 |
1852228 | 1852228 | 2021-10-25 | Logan | West Virginia | 54045 | 5284 | 135 |
1848978 | 1848978 | 2021-10-24 | Logan | West Virginia | 54045 | 5276 | 134 |
1845728 | 1845728 | 2021-10-23 | Logan | West Virginia | 54045 | 5267 | 134 |
1842478 | 1842478 | 2021-10-22 | Logan | West Virginia | 54045 | 5256 | 134 |
1839229 | 1839229 | 2021-10-21 | Logan | West Virginia | 54045 | 5236 | 134 |
1835980 | 1835980 | 2021-10-20 | Logan | West Virginia | 54045 | 5220 | 134 |
1832731 | 1832731 | 2021-10-19 | Logan | West Virginia | 54045 | 5207 | 133 |
1829482 | 1829482 | 2021-10-18 | Logan | West Virginia | 54045 | 5194 | 133 |
1826233 | 1826233 | 2021-10-17 | Logan | West Virginia | 54045 | 5185 | 130 |
1822984 | 1822984 | 2021-10-16 | Logan | West Virginia | 54045 | 5173 | 130 |
1819735 | 1819735 | 2021-10-15 | Logan | West Virginia | 54045 | 5162 | 130 |
1816486 | 1816486 | 2021-10-14 | Logan | West Virginia | 54045 | 5153 | 131 |
1813238 | 1813238 | 2021-10-13 | Logan | West Virginia | 54045 | 5132 | 130 |
1809989 | 1809989 | 2021-10-12 | Logan | West Virginia | 54045 | 5111 | 130 |
1806740 | 1806740 | 2021-10-11 | Logan | West Virginia | 54045 | 5103 | 130 |
1803489 | 1803489 | 2021-10-10 | Logan | West Virginia | 54045 | 5074 | 130 |
1800240 | 1800240 | 2021-10-09 | Logan | West Virginia | 54045 | 5053 | 129 |
1796991 | 1796991 | 2021-10-08 | Logan | West Virginia | 54045 | 5035 | 128 |
1793742 | 1793742 | 2021-10-07 | Logan | West Virginia | 54045 | 5019 | 126 |
1790493 | 1790493 | 2021-10-06 | Logan | West Virginia | 54045 | 5008 | 126 |
1787245 | 1787245 | 2021-10-05 | Logan | West Virginia | 54045 | 4980 | 126 |
1783996 | 1783996 | 2021-10-04 | Logan | West Virginia | 54045 | 4970 | 126 |
1780747 | 1780747 | 2021-10-03 | Logan | West Virginia | 54045 | 4956 | 123 |
1777497 | 1777497 | 2021-10-02 | Logan | West Virginia | 54045 | 4936 | 123 |
1774247 | 1774247 | 2021-10-01 | Logan | West Virginia | 54045 | 4905 | 122 |
1770997 | 1770997 | 2021-09-30 | Logan | West Virginia | 54045 | 4881 | 121 |
1767748 | 1767748 | 2021-09-29 | Logan | West Virginia | 54045 | 4834 | 118 |
1764499 | 1764499 | 2021-09-28 | Logan | West Virginia | 54045 | 4817 | 117 |
1761250 | 1761250 | 2021-09-27 | Logan | West Virginia | 54045 | 4785 | 117 |
1758002 | 1758002 | 2021-09-26 | Logan | West Virginia | 54045 | 4753 | 117 |
1754754 | 1754754 | 2021-09-25 | Logan | West Virginia | 54045 | 4729 | 117 |
1751506 | 1751506 | 2021-09-24 | Logan | West Virginia | 54045 | 4707 | 117 |
1748257 | 1748257 | 2021-09-23 | Logan | West Virginia | 54045 | 4654 | 114 |
1745007 | 1745007 | 2021-09-22 | Logan | West Virginia | 54045 | 4632 | 114 |
1741758 | 1741758 | 2021-09-21 | Logan | West Virginia | 54045 | 4601 | 114 |
1738509 | 1738509 | 2021-09-20 | Logan | West Virginia | 54045 | 4581 | 112 |
1735260 | 1735260 | 2021-09-19 | Logan | West Virginia | 54045 | 4544 | 112 |
1732010 | 1732010 | 2021-09-18 | Logan | West Virginia | 54045 | 4502 | 112 |
1728760 | 1728760 | 2021-09-17 | Logan | West Virginia | 54045 | 4466 | 112 |
1725510 | 1725510 | 2021-09-16 | Logan | West Virginia | 54045 | 4422 | 111 |
1722261 | 1722261 | 2021-09-15 | Logan | West Virginia | 54045 | 4368 | 111 |
1719013 | 1719013 | 2021-09-14 | Logan | West Virginia | 54045 | 4335 | 109 |
1715765 | 1715765 | 2021-09-13 | Logan | West Virginia | 54045 | 4293 | 109 |
1712519 | 1712519 | 2021-09-12 | Logan | West Virginia | 54045 | 4243 | 109 |
1709272 | 1709272 | 2021-09-11 | Logan | West Virginia | 54045 | 4199 | 109 |
1706025 | 1706025 | 2021-09-10 | Logan | West Virginia | 54045 | 4161 | 109 |
1702775 | 1702775 | 2021-09-09 | Logan | West Virginia | 54045 | 4075 | 108 |
1699526 | 1699526 | 2021-09-08 | Logan | West Virginia | 54045 | 4030 | 108 |
1696278 | 1696278 | 2021-09-07 | Logan | West Virginia | 54045 | 3998 | 107 |
1693030 | 1693030 | 2021-09-06 | Logan | West Virginia | 54045 | 3972 | 106 |
1689781 | 1689781 | 2021-09-05 | Logan | West Virginia | 54045 | 3937 | 106 |
1686531 | 1686531 | 2021-09-04 | Logan | West Virginia | 54045 | 3903 | 106 |
1683280 | 1683280 | 2021-09-03 | Logan | West Virginia | 54045 | 3870 | 106 |
1680030 | 1680030 | 2021-09-02 | Logan | West Virginia | 54045 | 3831 | 105 |
1676782 | 1676782 | 2021-09-01 | Logan | West Virginia | 54045 | 3800 | 105 |
1673535 | 1673535 | 2021-08-31 | Logan | West Virginia | 54045 | 3766 | 105 |
1670287 | 1670287 | 2021-08-30 | Logan | West Virginia | 54045 | 3739 | 102 |
1667040 | 1667040 | 2021-08-29 | Logan | West Virginia | 54045 | 3723 | 102 |
1663792 | 1663792 | 2021-08-28 | Logan | West Virginia | 54045 | 3680 | 100 |
1660544 | 1660544 | 2021-08-27 | Logan | West Virginia | 54045 | 3680 | 100 |
1657296 | 1657296 | 2021-08-26 | Logan | West Virginia | 54045 | 3658 | 101 |
1654048 | 1654048 | 2021-08-25 | Logan | West Virginia | 54045 | 3623 | 101 |
1650802 | 1650802 | 2021-08-24 | Logan | West Virginia | 54045 | 3594 | 101 |
1647553 | 1647553 | 2021-08-23 | Logan | West Virginia | 54045 | 3577 | 101 |
1644304 | 1644304 | 2021-08-22 | Logan | West Virginia | 54045 | 3540 | 99 |
1641054 | 1641054 | 2021-08-21 | Logan | West Virginia | 54045 | 3540 | 99 |
1637804 | 1637804 | 2021-08-20 | Logan | West Virginia | 54045 | 3540 | 99 |
1634554 | 1634554 | 2021-08-19 | Logan | West Virginia | 54045 | 3527 | 99 |
1631306 | 1631306 | 2021-08-18 | Logan | West Virginia | 54045 | 3517 | 99 |
1628059 | 1628059 | 2021-08-17 | Logan | West Virginia | 54045 | 3508 | 99 |
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);