ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 54033 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 |
---|---|---|---|---|---|---|---|
1949713 | 1949713 | 2021-11-24 | Harrison | West Virginia | 54033 | 12053 | 182 |
1946462 | 1946462 | 2021-11-23 | Harrison | West Virginia | 54033 | 12017 | 179 |
1943211 | 1943211 | 2021-11-22 | Harrison | West Virginia | 54033 | 11989 | 178 |
1939961 | 1939961 | 2021-11-21 | Harrison | West Virginia | 54033 | 11964 | 173 |
1936711 | 1936711 | 2021-11-20 | Harrison | West Virginia | 54033 | 11943 | 173 |
1933461 | 1933461 | 2021-11-19 | Harrison | West Virginia | 54033 | 11914 | 173 |
1930209 | 1930209 | 2021-11-18 | Harrison | West Virginia | 54033 | 11859 | 171 |
1926959 | 1926959 | 2021-11-17 | Harrison | West Virginia | 54033 | 11822 | 171 |
1923709 | 1923709 | 2021-11-16 | Harrison | West Virginia | 54033 | 11782 | 170 |
1920460 | 1920460 | 2021-11-15 | Harrison | West Virginia | 54033 | 11752 | 168 |
1917210 | 1917210 | 2021-11-14 | Harrison | West Virginia | 54033 | 11741 | 166 |
1913960 | 1913960 | 2021-11-13 | Harrison | West Virginia | 54033 | 11708 | 166 |
1910710 | 1910710 | 2021-11-12 | Harrison | West Virginia | 54033 | 11669 | 166 |
1907461 | 1907461 | 2021-11-11 | Harrison | West Virginia | 54033 | 11635 | 166 |
1904212 | 1904212 | 2021-11-10 | Harrison | West Virginia | 54033 | 11589 | 165 |
1900962 | 1900962 | 2021-11-09 | Harrison | West Virginia | 54033 | 11552 | 165 |
1897712 | 1897712 | 2021-11-08 | Harrison | West Virginia | 54033 | 11530 | 164 |
1894462 | 1894462 | 2021-11-07 | Harrison | West Virginia | 54033 | 11512 | 162 |
1891212 | 1891212 | 2021-11-06 | Harrison | West Virginia | 54033 | 11481 | 162 |
1887962 | 1887962 | 2021-11-05 | Harrison | West Virginia | 54033 | 11449 | 162 |
1884712 | 1884712 | 2021-11-04 | Harrison | West Virginia | 54033 | 11399 | 160 |
1881463 | 1881463 | 2021-11-03 | Harrison | West Virginia | 54033 | 11365 | 159 |
1878214 | 1878214 | 2021-11-02 | Harrison | West Virginia | 54033 | 11331 | 155 |
1874965 | 1874965 | 2021-11-01 | Harrison | West Virginia | 54033 | 11311 | 153 |
1871716 | 1871716 | 2021-10-31 | Harrison | West Virginia | 54033 | 11290 | 151 |
1868467 | 1868467 | 2021-10-30 | Harrison | West Virginia | 54033 | 11255 | 151 |
1865218 | 1865218 | 2021-10-29 | Harrison | West Virginia | 54033 | 11212 | 151 |
1861969 | 1861969 | 2021-10-28 | Harrison | West Virginia | 54033 | 11169 | 151 |
1858720 | 1858720 | 2021-10-27 | Harrison | West Virginia | 54033 | 11120 | 149 |
1855471 | 1855471 | 2021-10-26 | Harrison | West Virginia | 54033 | 11076 | 144 |
1852222 | 1852222 | 2021-10-25 | Harrison | West Virginia | 54033 | 11046 | 143 |
1848972 | 1848972 | 2021-10-24 | Harrison | West Virginia | 54033 | 11017 | 140 |
1845722 | 1845722 | 2021-10-23 | Harrison | West Virginia | 54033 | 10993 | 140 |
1842472 | 1842472 | 2021-10-22 | Harrison | West Virginia | 54033 | 10939 | 140 |
1839223 | 1839223 | 2021-10-21 | Harrison | West Virginia | 54033 | 10895 | 138 |
1835974 | 1835974 | 2021-10-20 | Harrison | West Virginia | 54033 | 10841 | 138 |
1832725 | 1832725 | 2021-10-19 | Harrison | West Virginia | 54033 | 10787 | 137 |
1829476 | 1829476 | 2021-10-18 | Harrison | West Virginia | 54033 | 10765 | 137 |
1826227 | 1826227 | 2021-10-17 | Harrison | West Virginia | 54033 | 10728 | 136 |
1822978 | 1822978 | 2021-10-16 | Harrison | West Virginia | 54033 | 10668 | 136 |
1819729 | 1819729 | 2021-10-15 | Harrison | West Virginia | 54033 | 10612 | 136 |
1816480 | 1816480 | 2021-10-14 | Harrison | West Virginia | 54033 | 10528 | 135 |
1813232 | 1813232 | 2021-10-13 | Harrison | West Virginia | 54033 | 10438 | 130 |
1809983 | 1809983 | 2021-10-12 | Harrison | West Virginia | 54033 | 10348 | 130 |
1806734 | 1806734 | 2021-10-11 | Harrison | West Virginia | 54033 | 10307 | 130 |
1803483 | 1803483 | 2021-10-10 | Harrison | West Virginia | 54033 | 10266 | 127 |
1800234 | 1800234 | 2021-10-09 | Harrison | West Virginia | 54033 | 10195 | 127 |
1796985 | 1796985 | 2021-10-08 | Harrison | West Virginia | 54033 | 10111 | 127 |
1793736 | 1793736 | 2021-10-07 | Harrison | West Virginia | 54033 | 10014 | 124 |
1790487 | 1790487 | 2021-10-06 | Harrison | West Virginia | 54033 | 9902 | 124 |
1787239 | 1787239 | 2021-10-05 | Harrison | West Virginia | 54033 | 9810 | 122 |
1783990 | 1783990 | 2021-10-04 | Harrison | West Virginia | 54033 | 9775 | 122 |
1780741 | 1780741 | 2021-10-03 | Harrison | West Virginia | 54033 | 9719 | 119 |
1777491 | 1777491 | 2021-10-02 | Harrison | West Virginia | 54033 | 9650 | 119 |
1774241 | 1774241 | 2021-10-01 | Harrison | West Virginia | 54033 | 9534 | 118 |
1770991 | 1770991 | 2021-09-30 | Harrison | West Virginia | 54033 | 9425 | 115 |
1767742 | 1767742 | 2021-09-29 | Harrison | West Virginia | 54033 | 9315 | 113 |
1764493 | 1764493 | 2021-09-28 | Harrison | West Virginia | 54033 | 9234 | 106 |
1761244 | 1761244 | 2021-09-27 | Harrison | West Virginia | 54033 | 9186 | 106 |
1757996 | 1757996 | 2021-09-26 | Harrison | West Virginia | 54033 | 9135 | 105 |
1754748 | 1754748 | 2021-09-25 | Harrison | West Virginia | 54033 | 9063 | 105 |
1751500 | 1751500 | 2021-09-24 | Harrison | West Virginia | 54033 | 8954 | 105 |
1748251 | 1748251 | 2021-09-23 | Harrison | West Virginia | 54033 | 8794 | 105 |
1745001 | 1745001 | 2021-09-22 | Harrison | West Virginia | 54033 | 8731 | 103 |
1741752 | 1741752 | 2021-09-21 | Harrison | West Virginia | 54033 | 8622 | 103 |
1738503 | 1738503 | 2021-09-20 | Harrison | West Virginia | 54033 | 8539 | 102 |
1735254 | 1735254 | 2021-09-19 | Harrison | West Virginia | 54033 | 8487 | 101 |
1732004 | 1732004 | 2021-09-18 | Harrison | West Virginia | 54033 | 8389 | 101 |
1728754 | 1728754 | 2021-09-17 | Harrison | West Virginia | 54033 | 8315 | 101 |
1725504 | 1725504 | 2021-09-16 | Harrison | West Virginia | 54033 | 8205 | 100 |
1722255 | 1722255 | 2021-09-15 | Harrison | West Virginia | 54033 | 8097 | 99 |
1719007 | 1719007 | 2021-09-14 | Harrison | West Virginia | 54033 | 7979 | 95 |
1715759 | 1715759 | 2021-09-13 | Harrison | West Virginia | 54033 | 7926 | 95 |
1712513 | 1712513 | 2021-09-12 | Harrison | West Virginia | 54033 | 7879 | 91 |
1709266 | 1709266 | 2021-09-11 | Harrison | West Virginia | 54033 | 7807 | 91 |
1706019 | 1706019 | 2021-09-10 | Harrison | West Virginia | 54033 | 7723 | 91 |
1702769 | 1702769 | 2021-09-09 | Harrison | West Virginia | 54033 | 7629 | 91 |
1699520 | 1699520 | 2021-09-08 | Harrison | West Virginia | 54033 | 7529 | 88 |
1696272 | 1696272 | 2021-09-07 | Harrison | West Virginia | 54033 | 7488 | 87 |
1693024 | 1693024 | 2021-09-06 | Harrison | West Virginia | 54033 | 7448 | 86 |
1689775 | 1689775 | 2021-09-05 | Harrison | West Virginia | 54033 | 7412 | 85 |
1686525 | 1686525 | 2021-09-04 | Harrison | West Virginia | 54033 | 7366 | 85 |
1683274 | 1683274 | 2021-09-03 | Harrison | West Virginia | 54033 | 7300 | 85 |
1680024 | 1680024 | 2021-09-02 | Harrison | West Virginia | 54033 | 7245 | 83 |
1676776 | 1676776 | 2021-09-01 | Harrison | West Virginia | 54033 | 7181 | 83 |
1673529 | 1673529 | 2021-08-31 | Harrison | West Virginia | 54033 | 7121 | 83 |
1670281 | 1670281 | 2021-08-30 | Harrison | West Virginia | 54033 | 7094 | 83 |
1667034 | 1667034 | 2021-08-29 | Harrison | West Virginia | 54033 | 7051 | 83 |
1663786 | 1663786 | 2021-08-28 | Harrison | West Virginia | 54033 | 6940 | 83 |
1660538 | 1660538 | 2021-08-27 | Harrison | West Virginia | 54033 | 6940 | 83 |
1657290 | 1657290 | 2021-08-26 | Harrison | West Virginia | 54033 | 6879 | 83 |
1654042 | 1654042 | 2021-08-25 | Harrison | West Virginia | 54033 | 6833 | 83 |
1650796 | 1650796 | 2021-08-24 | Harrison | West Virginia | 54033 | 6787 | 83 |
1647547 | 1647547 | 2021-08-23 | Harrison | West Virginia | 54033 | 6756 | 83 |
1644298 | 1644298 | 2021-08-22 | Harrison | West Virginia | 54033 | 6673 | 83 |
1641048 | 1641048 | 2021-08-21 | Harrison | West Virginia | 54033 | 6673 | 83 |
1637798 | 1637798 | 2021-08-20 | Harrison | West Virginia | 54033 | 6673 | 83 |
1634548 | 1634548 | 2021-08-19 | Harrison | West Virginia | 54033 | 6640 | 82 |
1631300 | 1631300 | 2021-08-18 | Harrison | West Virginia | 54033 | 6611 | 82 |
1628053 | 1628053 | 2021-08-17 | Harrison | West Virginia | 54033 | 6580 | 82 |
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);