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 |
---|---|---|---|---|---|---|---|
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 |
1624812 | 1624812 | 2021-08-16 | Logan | West Virginia | 54045 | 3484 | 98 |
1621565 | 1621565 | 2021-08-15 | Logan | West Virginia | 54045 | 3451 | 98 |
1618317 | 1618317 | 2021-08-14 | Logan | West Virginia | 54045 | 3451 | 98 |
1615069 | 1615069 | 2021-08-13 | Logan | West Virginia | 54045 | 3451 | 98 |
1611820 | 1611820 | 2021-08-12 | Logan | West Virginia | 54045 | 3444 | 98 |
1608573 | 1608573 | 2021-08-11 | Logan | West Virginia | 54045 | 3433 | 98 |
1605324 | 1605324 | 2021-08-10 | Logan | West Virginia | 54045 | 3423 | 98 |
1602074 | 1602074 | 2021-08-09 | Logan | West Virginia | 54045 | 3411 | 98 |
1598826 | 1598826 | 2021-08-08 | Logan | West Virginia | 54045 | 3381 | 98 |
1595577 | 1595577 | 2021-08-07 | Logan | West Virginia | 54045 | 3381 | 98 |
1592328 | 1592328 | 2021-08-06 | Logan | West Virginia | 54045 | 3381 | 98 |
1589079 | 1589079 | 2021-08-05 | Logan | West Virginia | 54045 | 3372 | 98 |
1585830 | 1585830 | 2021-08-04 | Logan | West Virginia | 54045 | 3365 | 98 |
1582580 | 1582580 | 2021-08-03 | Logan | West Virginia | 54045 | 3350 | 98 |
1579330 | 1579330 | 2021-08-02 | Logan | West Virginia | 54045 | 3347 | 98 |
1576082 | 1576082 | 2021-08-01 | Logan | West Virginia | 54045 | 3342 | 97 |
1572834 | 1572834 | 2021-07-31 | Logan | West Virginia | 54045 | 3342 | 97 |
1569586 | 1569586 | 2021-07-30 | Logan | West Virginia | 54045 | 3342 | 97 |
1566338 | 1566338 | 2021-07-29 | Logan | West Virginia | 54045 | 3333 | 97 |
1563090 | 1563090 | 2021-07-28 | Logan | West Virginia | 54045 | 3332 | 97 |
1559842 | 1559842 | 2021-07-27 | Logan | West Virginia | 54045 | 3328 | 96 |
1556595 | 1556595 | 2021-07-26 | Logan | West Virginia | 54045 | 3324 | 96 |
1553348 | 1553348 | 2021-07-25 | Logan | West Virginia | 54045 | 3318 | 96 |
1550101 | 1550101 | 2021-07-24 | Logan | West Virginia | 54045 | 3318 | 96 |
1546854 | 1546854 | 2021-07-23 | Logan | West Virginia | 54045 | 3318 | 96 |
1543607 | 1543607 | 2021-07-22 | Logan | West Virginia | 54045 | 3316 | 96 |
1540359 | 1540359 | 2021-07-21 | Logan | West Virginia | 54045 | 3316 | 96 |
1537112 | 1537112 | 2021-07-20 | Logan | West Virginia | 54045 | 3313 | 96 |
1533864 | 1533864 | 2021-07-19 | Logan | West Virginia | 54045 | 3314 | 96 |
1530617 | 1530617 | 2021-07-18 | Logan | West Virginia | 54045 | 3313 | 96 |
1527370 | 1527370 | 2021-07-17 | Logan | West Virginia | 54045 | 3313 | 96 |
1524123 | 1524123 | 2021-07-16 | Logan | West Virginia | 54045 | 3313 | 96 |
1520875 | 1520875 | 2021-07-15 | Logan | West Virginia | 54045 | 3310 | 96 |
1517627 | 1517627 | 2021-07-14 | Logan | West Virginia | 54045 | 3308 | 96 |
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);