ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
658 rows where county = "Doddridge" 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 |
---|---|---|---|---|---|---|---|
1949705 | 1949705 | 2021-11-24 | Doddridge | West Virginia | 54017 | 1415 | 11 |
1946454 | 1946454 | 2021-11-23 | Doddridge | West Virginia | 54017 | 1410 | 11 |
1943203 | 1943203 | 2021-11-22 | Doddridge | West Virginia | 54017 | 1402 | 11 |
1939953 | 1939953 | 2021-11-21 | Doddridge | West Virginia | 54017 | 1399 | 11 |
1936703 | 1936703 | 2021-11-20 | Doddridge | West Virginia | 54017 | 1397 | 11 |
1933453 | 1933453 | 2021-11-19 | Doddridge | West Virginia | 54017 | 1396 | 11 |
1930201 | 1930201 | 2021-11-18 | Doddridge | West Virginia | 54017 | 1394 | 11 |
1926951 | 1926951 | 2021-11-17 | Doddridge | West Virginia | 54017 | 1393 | 11 |
1923701 | 1923701 | 2021-11-16 | Doddridge | West Virginia | 54017 | 1386 | 11 |
1920452 | 1920452 | 2021-11-15 | Doddridge | West Virginia | 54017 | 1386 | 11 |
1917202 | 1917202 | 2021-11-14 | Doddridge | West Virginia | 54017 | 1385 | 11 |
1913952 | 1913952 | 2021-11-13 | Doddridge | West Virginia | 54017 | 1384 | 11 |
1910702 | 1910702 | 2021-11-12 | Doddridge | West Virginia | 54017 | 1381 | 11 |
1907453 | 1907453 | 2021-11-11 | Doddridge | West Virginia | 54017 | 1381 | 11 |
1904204 | 1904204 | 2021-11-10 | Doddridge | West Virginia | 54017 | 1378 | 11 |
1900954 | 1900954 | 2021-11-09 | Doddridge | West Virginia | 54017 | 1376 | 11 |
1897704 | 1897704 | 2021-11-08 | Doddridge | West Virginia | 54017 | 1376 | 11 |
1894454 | 1894454 | 2021-11-07 | Doddridge | West Virginia | 54017 | 1377 | 10 |
1891204 | 1891204 | 2021-11-06 | Doddridge | West Virginia | 54017 | 1377 | 10 |
1887954 | 1887954 | 2021-11-05 | Doddridge | West Virginia | 54017 | 1377 | 10 |
1884704 | 1884704 | 2021-11-04 | Doddridge | West Virginia | 54017 | 1375 | 10 |
1881455 | 1881455 | 2021-11-03 | Doddridge | West Virginia | 54017 | 1372 | 10 |
1878206 | 1878206 | 2021-11-02 | Doddridge | West Virginia | 54017 | 1370 | 10 |
1874957 | 1874957 | 2021-11-01 | Doddridge | West Virginia | 54017 | 1366 | 10 |
1871708 | 1871708 | 2021-10-31 | Doddridge | West Virginia | 54017 | 1362 | 10 |
1868459 | 1868459 | 2021-10-30 | Doddridge | West Virginia | 54017 | 1363 | 10 |
1865210 | 1865210 | 2021-10-29 | Doddridge | West Virginia | 54017 | 1360 | 10 |
1861961 | 1861961 | 2021-10-28 | Doddridge | West Virginia | 54017 | 1358 | 10 |
1858712 | 1858712 | 2021-10-27 | Doddridge | West Virginia | 54017 | 1354 | 10 |
1855463 | 1855463 | 2021-10-26 | Doddridge | West Virginia | 54017 | 1207 | 10 |
1852214 | 1852214 | 2021-10-25 | Doddridge | West Virginia | 54017 | 1202 | 10 |
1848964 | 1848964 | 2021-10-24 | Doddridge | West Virginia | 54017 | 1202 | 10 |
1845714 | 1845714 | 2021-10-23 | Doddridge | West Virginia | 54017 | 1201 | 10 |
1842464 | 1842464 | 2021-10-22 | Doddridge | West Virginia | 54017 | 1200 | 10 |
1839215 | 1839215 | 2021-10-21 | Doddridge | West Virginia | 54017 | 1197 | 10 |
1835966 | 1835966 | 2021-10-20 | Doddridge | West Virginia | 54017 | 1188 | 10 |
1832717 | 1832717 | 2021-10-19 | Doddridge | West Virginia | 54017 | 1181 | 10 |
1829468 | 1829468 | 2021-10-18 | Doddridge | West Virginia | 54017 | 1179 | 10 |
1826219 | 1826219 | 2021-10-17 | Doddridge | West Virginia | 54017 | 1176 | 10 |
1822970 | 1822970 | 2021-10-16 | Doddridge | West Virginia | 54017 | 1174 | 10 |
1819721 | 1819721 | 2021-10-15 | Doddridge | West Virginia | 54017 | 1171 | 10 |
1816472 | 1816472 | 2021-10-14 | Doddridge | West Virginia | 54017 | 1164 | 10 |
1813224 | 1813224 | 2021-10-13 | Doddridge | West Virginia | 54017 | 1158 | 10 |
1809975 | 1809975 | 2021-10-12 | Doddridge | West Virginia | 54017 | 1155 | 10 |
1806726 | 1806726 | 2021-10-11 | Doddridge | West Virginia | 54017 | 1148 | 9 |
1803475 | 1803475 | 2021-10-10 | Doddridge | West Virginia | 54017 | 1147 | 9 |
1800226 | 1800226 | 2021-10-09 | Doddridge | West Virginia | 54017 | 1143 | 9 |
1796977 | 1796977 | 2021-10-08 | Doddridge | West Virginia | 54017 | 1137 | 9 |
1793728 | 1793728 | 2021-10-07 | Doddridge | West Virginia | 54017 | 1129 | 8 |
1790479 | 1790479 | 2021-10-06 | Doddridge | West Virginia | 54017 | 1118 | 8 |
1787231 | 1787231 | 2021-10-05 | Doddridge | West Virginia | 54017 | 1083 | 8 |
1783982 | 1783982 | 2021-10-04 | Doddridge | West Virginia | 54017 | 1078 | 8 |
1780733 | 1780733 | 2021-10-03 | Doddridge | West Virginia | 54017 | 1076 | 8 |
1777483 | 1777483 | 2021-10-02 | Doddridge | West Virginia | 54017 | 1047 | 8 |
1774233 | 1774233 | 2021-10-01 | Doddridge | West Virginia | 54017 | 1047 | 8 |
1770983 | 1770983 | 2021-09-30 | Doddridge | West Virginia | 54017 | 1044 | 8 |
1767734 | 1767734 | 2021-09-29 | Doddridge | West Virginia | 54017 | 1036 | 8 |
1764485 | 1764485 | 2021-09-28 | Doddridge | West Virginia | 54017 | 1025 | 6 |
1761236 | 1761236 | 2021-09-27 | Doddridge | West Virginia | 54017 | 1017 | 6 |
1757988 | 1757988 | 2021-09-26 | Doddridge | West Virginia | 54017 | 1009 | 6 |
1754740 | 1754740 | 2021-09-25 | Doddridge | West Virginia | 54017 | 1003 | 6 |
1751492 | 1751492 | 2021-09-24 | Doddridge | West Virginia | 54017 | 1005 | 6 |
1748243 | 1748243 | 2021-09-23 | Doddridge | West Virginia | 54017 | 968 | 6 |
1744993 | 1744993 | 2021-09-22 | Doddridge | West Virginia | 54017 | 965 | 6 |
1741744 | 1741744 | 2021-09-21 | Doddridge | West Virginia | 54017 | 957 | 6 |
1738495 | 1738495 | 2021-09-20 | Doddridge | West Virginia | 54017 | 954 | 6 |
1735246 | 1735246 | 2021-09-19 | Doddridge | West Virginia | 54017 | 951 | 6 |
1731996 | 1731996 | 2021-09-18 | Doddridge | West Virginia | 54017 | 941 | 6 |
1728746 | 1728746 | 2021-09-17 | Doddridge | West Virginia | 54017 | 934 | 6 |
1725496 | 1725496 | 2021-09-16 | Doddridge | West Virginia | 54017 | 918 | 6 |
1722247 | 1722247 | 2021-09-15 | Doddridge | West Virginia | 54017 | 910 | 6 |
1718999 | 1718999 | 2021-09-14 | Doddridge | West Virginia | 54017 | 902 | 6 |
1715751 | 1715751 | 2021-09-13 | Doddridge | West Virginia | 54017 | 887 | 6 |
1712505 | 1712505 | 2021-09-12 | Doddridge | West Virginia | 54017 | 880 | 6 |
1709258 | 1709258 | 2021-09-11 | Doddridge | West Virginia | 54017 | 869 | 6 |
1706011 | 1706011 | 2021-09-10 | Doddridge | West Virginia | 54017 | 857 | 6 |
1702761 | 1702761 | 2021-09-09 | Doddridge | West Virginia | 54017 | 839 | 6 |
1699512 | 1699512 | 2021-09-08 | Doddridge | West Virginia | 54017 | 822 | 6 |
1696264 | 1696264 | 2021-09-07 | Doddridge | West Virginia | 54017 | 801 | 7 |
1693016 | 1693016 | 2021-09-06 | Doddridge | West Virginia | 54017 | 796 | 7 |
1689767 | 1689767 | 2021-09-05 | Doddridge | West Virginia | 54017 | 784 | 6 |
1686517 | 1686517 | 2021-09-04 | Doddridge | West Virginia | 54017 | 774 | 6 |
1683266 | 1683266 | 2021-09-03 | Doddridge | West Virginia | 54017 | 758 | 6 |
1680016 | 1680016 | 2021-09-02 | Doddridge | West Virginia | 54017 | 727 | 6 |
1676768 | 1676768 | 2021-09-01 | Doddridge | West Virginia | 54017 | 719 | 6 |
1673521 | 1673521 | 2021-08-31 | Doddridge | West Virginia | 54017 | 710 | 6 |
1670273 | 1670273 | 2021-08-30 | Doddridge | West Virginia | 54017 | 710 | 6 |
1667026 | 1667026 | 2021-08-29 | Doddridge | West Virginia | 54017 | 705 | 6 |
1663778 | 1663778 | 2021-08-28 | Doddridge | West Virginia | 54017 | 701 | 6 |
1660530 | 1660530 | 2021-08-27 | Doddridge | West Virginia | 54017 | 701 | 6 |
1657282 | 1657282 | 2021-08-26 | Doddridge | West Virginia | 54017 | 693 | 6 |
1654034 | 1654034 | 2021-08-25 | Doddridge | West Virginia | 54017 | 688 | 6 |
1650788 | 1650788 | 2021-08-24 | Doddridge | West Virginia | 54017 | 684 | 6 |
1647539 | 1647539 | 2021-08-23 | Doddridge | West Virginia | 54017 | 685 | 6 |
1644290 | 1644290 | 2021-08-22 | Doddridge | West Virginia | 54017 | 677 | 6 |
1641040 | 1641040 | 2021-08-21 | Doddridge | West Virginia | 54017 | 677 | 6 |
1637790 | 1637790 | 2021-08-20 | Doddridge | West Virginia | 54017 | 677 | 6 |
1634540 | 1634540 | 2021-08-19 | Doddridge | West Virginia | 54017 | 677 | 6 |
1631292 | 1631292 | 2021-08-18 | Doddridge | West Virginia | 54017 | 675 | 6 |
1628045 | 1628045 | 2021-08-17 | Doddridge | West Virginia | 54017 | 673 | 6 |
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);