ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 54051 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 |
---|---|---|---|---|---|---|---|
1949721 | 1949721 | 2021-11-24 | Marshall | West Virginia | 54051 | 5642 | 119 |
1946470 | 1946470 | 2021-11-23 | Marshall | West Virginia | 54051 | 5617 | 118 |
1943219 | 1943219 | 2021-11-22 | Marshall | West Virginia | 54051 | 5603 | 117 |
1939969 | 1939969 | 2021-11-21 | Marshall | West Virginia | 54051 | 5592 | 117 |
1936719 | 1936719 | 2021-11-20 | Marshall | West Virginia | 54051 | 5572 | 117 |
1933469 | 1933469 | 2021-11-19 | Marshall | West Virginia | 54051 | 5563 | 117 |
1930217 | 1930217 | 2021-11-18 | Marshall | West Virginia | 54051 | 5541 | 117 |
1926967 | 1926967 | 2021-11-17 | Marshall | West Virginia | 54051 | 5514 | 117 |
1923717 | 1923717 | 2021-11-16 | Marshall | West Virginia | 54051 | 5492 | 117 |
1920468 | 1920468 | 2021-11-15 | Marshall | West Virginia | 54051 | 5479 | 116 |
1917218 | 1917218 | 2021-11-14 | Marshall | West Virginia | 54051 | 5470 | 116 |
1913968 | 1913968 | 2021-11-13 | Marshall | West Virginia | 54051 | 5455 | 116 |
1910718 | 1910718 | 2021-11-12 | Marshall | West Virginia | 54051 | 5439 | 116 |
1907469 | 1907469 | 2021-11-11 | Marshall | West Virginia | 54051 | 5426 | 116 |
1904220 | 1904220 | 2021-11-10 | Marshall | West Virginia | 54051 | 5414 | 116 |
1900970 | 1900970 | 2021-11-09 | Marshall | West Virginia | 54051 | 5403 | 116 |
1897720 | 1897720 | 2021-11-08 | Marshall | West Virginia | 54051 | 5395 | 116 |
1894470 | 1894470 | 2021-11-07 | Marshall | West Virginia | 54051 | 5389 | 116 |
1891220 | 1891220 | 2021-11-06 | Marshall | West Virginia | 54051 | 5375 | 116 |
1887970 | 1887970 | 2021-11-05 | Marshall | West Virginia | 54051 | 5367 | 116 |
1884720 | 1884720 | 2021-11-04 | Marshall | West Virginia | 54051 | 5359 | 116 |
1881471 | 1881471 | 2021-11-03 | Marshall | West Virginia | 54051 | 5353 | 116 |
1878222 | 1878222 | 2021-11-02 | Marshall | West Virginia | 54051 | 5341 | 116 |
1874973 | 1874973 | 2021-11-01 | Marshall | West Virginia | 54051 | 5332 | 115 |
1871724 | 1871724 | 2021-10-31 | Marshall | West Virginia | 54051 | 5329 | 114 |
1868475 | 1868475 | 2021-10-30 | Marshall | West Virginia | 54051 | 5319 | 114 |
1865226 | 1865226 | 2021-10-29 | Marshall | West Virginia | 54051 | 5301 | 114 |
1861977 | 1861977 | 2021-10-28 | Marshall | West Virginia | 54051 | 5297 | 114 |
1858728 | 1858728 | 2021-10-27 | Marshall | West Virginia | 54051 | 5281 | 110 |
1855479 | 1855479 | 2021-10-26 | Marshall | West Virginia | 54051 | 5273 | 110 |
1852230 | 1852230 | 2021-10-25 | Marshall | West Virginia | 54051 | 5264 | 110 |
1848980 | 1848980 | 2021-10-24 | Marshall | West Virginia | 54051 | 5258 | 110 |
1845730 | 1845730 | 2021-10-23 | Marshall | West Virginia | 54051 | 5249 | 110 |
1842480 | 1842480 | 2021-10-22 | Marshall | West Virginia | 54051 | 5237 | 110 |
1839231 | 1839231 | 2021-10-21 | Marshall | West Virginia | 54051 | 5227 | 110 |
1835982 | 1835982 | 2021-10-20 | Marshall | West Virginia | 54051 | 5219 | 110 |
1832733 | 1832733 | 2021-10-19 | Marshall | West Virginia | 54051 | 5212 | 106 |
1829484 | 1829484 | 2021-10-18 | Marshall | West Virginia | 54051 | 5202 | 106 |
1826235 | 1826235 | 2021-10-17 | Marshall | West Virginia | 54051 | 5192 | 106 |
1822986 | 1822986 | 2021-10-16 | Marshall | West Virginia | 54051 | 5181 | 106 |
1819737 | 1819737 | 2021-10-15 | Marshall | West Virginia | 54051 | 5167 | 106 |
1816488 | 1816488 | 2021-10-14 | Marshall | West Virginia | 54051 | 5154 | 106 |
1813240 | 1813240 | 2021-10-13 | Marshall | West Virginia | 54051 | 5134 | 106 |
1809991 | 1809991 | 2021-10-12 | Marshall | West Virginia | 54051 | 5117 | 106 |
1806742 | 1806742 | 2021-10-11 | Marshall | West Virginia | 54051 | 5109 | 106 |
1803491 | 1803491 | 2021-10-10 | Marshall | West Virginia | 54051 | 5101 | 104 |
1800242 | 1800242 | 2021-10-09 | Marshall | West Virginia | 54051 | 5088 | 104 |
1796993 | 1796993 | 2021-10-08 | Marshall | West Virginia | 54051 | 5066 | 104 |
1793744 | 1793744 | 2021-10-07 | Marshall | West Virginia | 54051 | 5051 | 102 |
1790495 | 1790495 | 2021-10-06 | Marshall | West Virginia | 54051 | 5036 | 102 |
1787247 | 1787247 | 2021-10-05 | Marshall | West Virginia | 54051 | 4987 | 99 |
1783998 | 1783998 | 2021-10-04 | Marshall | West Virginia | 54051 | 4965 | 99 |
1780749 | 1780749 | 2021-10-03 | Marshall | West Virginia | 54051 | 4960 | 99 |
1777499 | 1777499 | 2021-10-02 | Marshall | West Virginia | 54051 | 4943 | 99 |
1774249 | 1774249 | 2021-10-01 | Marshall | West Virginia | 54051 | 4929 | 99 |
1770999 | 1770999 | 2021-09-30 | Marshall | West Virginia | 54051 | 4899 | 98 |
1767750 | 1767750 | 2021-09-29 | Marshall | West Virginia | 54051 | 4878 | 98 |
1764501 | 1764501 | 2021-09-28 | Marshall | West Virginia | 54051 | 4855 | 96 |
1761252 | 1761252 | 2021-09-27 | Marshall | West Virginia | 54051 | 4838 | 96 |
1758004 | 1758004 | 2021-09-26 | Marshall | West Virginia | 54051 | 4830 | 96 |
1754756 | 1754756 | 2021-09-25 | Marshall | West Virginia | 54051 | 4799 | 96 |
1751508 | 1751508 | 2021-09-24 | Marshall | West Virginia | 54051 | 4776 | 96 |
1748259 | 1748259 | 2021-09-23 | Marshall | West Virginia | 54051 | 4739 | 95 |
1745009 | 1745009 | 2021-09-22 | Marshall | West Virginia | 54051 | 4699 | 92 |
1741760 | 1741760 | 2021-09-21 | Marshall | West Virginia | 54051 | 4684 | 92 |
1738511 | 1738511 | 2021-09-20 | Marshall | West Virginia | 54051 | 4659 | 92 |
1735262 | 1735262 | 2021-09-19 | Marshall | West Virginia | 54051 | 4636 | 92 |
1732012 | 1732012 | 2021-09-18 | Marshall | West Virginia | 54051 | 4599 | 92 |
1728762 | 1728762 | 2021-09-17 | Marshall | West Virginia | 54051 | 4559 | 92 |
1725512 | 1725512 | 2021-09-16 | Marshall | West Virginia | 54051 | 4528 | 92 |
1722263 | 1722263 | 2021-09-15 | Marshall | West Virginia | 54051 | 4473 | 92 |
1719015 | 1719015 | 2021-09-14 | Marshall | West Virginia | 54051 | 4437 | 92 |
1715767 | 1715767 | 2021-09-13 | Marshall | West Virginia | 54051 | 4416 | 92 |
1712521 | 1712521 | 2021-09-12 | Marshall | West Virginia | 54051 | 4382 | 91 |
1709274 | 1709274 | 2021-09-11 | Marshall | West Virginia | 54051 | 4346 | 91 |
1706027 | 1706027 | 2021-09-10 | Marshall | West Virginia | 54051 | 4309 | 91 |
1702777 | 1702777 | 2021-09-09 | Marshall | West Virginia | 54051 | 4265 | 91 |
1699528 | 1699528 | 2021-09-08 | Marshall | West Virginia | 54051 | 4233 | 90 |
1696280 | 1696280 | 2021-09-07 | Marshall | West Virginia | 54051 | 4219 | 90 |
1693032 | 1693032 | 2021-09-06 | Marshall | West Virginia | 54051 | 4205 | 90 |
1689783 | 1689783 | 2021-09-05 | Marshall | West Virginia | 54051 | 4186 | 87 |
1686533 | 1686533 | 2021-09-04 | Marshall | West Virginia | 54051 | 4165 | 87 |
1683282 | 1683282 | 2021-09-03 | Marshall | West Virginia | 54051 | 4128 | 86 |
1680032 | 1680032 | 2021-09-02 | Marshall | West Virginia | 54051 | 4107 | 86 |
1676784 | 1676784 | 2021-09-01 | Marshall | West Virginia | 54051 | 4096 | 86 |
1673537 | 1673537 | 2021-08-31 | Marshall | West Virginia | 54051 | 4083 | 85 |
1670289 | 1670289 | 2021-08-30 | Marshall | West Virginia | 54051 | 4068 | 85 |
1667042 | 1667042 | 2021-08-29 | Marshall | West Virginia | 54051 | 4048 | 85 |
1663794 | 1663794 | 2021-08-28 | Marshall | West Virginia | 54051 | 3998 | 84 |
1660546 | 1660546 | 2021-08-27 | Marshall | West Virginia | 54051 | 3998 | 84 |
1657298 | 1657298 | 2021-08-26 | Marshall | West Virginia | 54051 | 3978 | 84 |
1654050 | 1654050 | 2021-08-25 | Marshall | West Virginia | 54051 | 3957 | 83 |
1650804 | 1650804 | 2021-08-24 | Marshall | West Virginia | 54051 | 3940 | 81 |
1647555 | 1647555 | 2021-08-23 | Marshall | West Virginia | 54051 | 3928 | 81 |
1644306 | 1644306 | 2021-08-22 | Marshall | West Virginia | 54051 | 3885 | 81 |
1641056 | 1641056 | 2021-08-21 | Marshall | West Virginia | 54051 | 3885 | 81 |
1637806 | 1637806 | 2021-08-20 | Marshall | West Virginia | 54051 | 3885 | 81 |
1634556 | 1634556 | 2021-08-19 | Marshall | West Virginia | 54051 | 3867 | 81 |
1631308 | 1631308 | 2021-08-18 | Marshall | West Virginia | 54051 | 3854 | 81 |
1628061 | 1628061 | 2021-08-17 | Marshall | West Virginia | 54051 | 3829 | 81 |
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);