ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 54107 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 |
---|---|---|---|---|---|---|---|
1949750 | 1949750 | 2021-11-24 | Wood | West Virginia | 54107 | 13906 | 264 |
1946499 | 1946499 | 2021-11-23 | Wood | West Virginia | 54107 | 13862 | 262 |
1943248 | 1943248 | 2021-11-22 | Wood | West Virginia | 54107 | 13821 | 262 |
1939998 | 1939998 | 2021-11-21 | Wood | West Virginia | 54107 | 13800 | 259 |
1936748 | 1936748 | 2021-11-20 | Wood | West Virginia | 54107 | 13776 | 259 |
1933498 | 1933498 | 2021-11-19 | Wood | West Virginia | 54107 | 13745 | 259 |
1930246 | 1930246 | 2021-11-18 | Wood | West Virginia | 54107 | 13691 | 258 |
1926996 | 1926996 | 2021-11-17 | Wood | West Virginia | 54107 | 13647 | 256 |
1923746 | 1923746 | 2021-11-16 | Wood | West Virginia | 54107 | 13600 | 255 |
1920497 | 1920497 | 2021-11-15 | Wood | West Virginia | 54107 | 13576 | 254 |
1917247 | 1917247 | 2021-11-14 | Wood | West Virginia | 54107 | 13552 | 254 |
1913997 | 1913997 | 2021-11-13 | Wood | West Virginia | 54107 | 13538 | 254 |
1910747 | 1910747 | 2021-11-12 | Wood | West Virginia | 54107 | 13517 | 254 |
1907498 | 1907498 | 2021-11-11 | Wood | West Virginia | 54107 | 13483 | 254 |
1904249 | 1904249 | 2021-11-10 | Wood | West Virginia | 54107 | 13454 | 254 |
1900999 | 1900999 | 2021-11-09 | Wood | West Virginia | 54107 | 13415 | 254 |
1897749 | 1897749 | 2021-11-08 | Wood | West Virginia | 54107 | 13397 | 254 |
1894499 | 1894499 | 2021-11-07 | Wood | West Virginia | 54107 | 13382 | 251 |
1891249 | 1891249 | 2021-11-06 | Wood | West Virginia | 54107 | 13353 | 251 |
1887999 | 1887999 | 2021-11-05 | Wood | West Virginia | 54107 | 13324 | 251 |
1884749 | 1884749 | 2021-11-04 | Wood | West Virginia | 54107 | 13303 | 250 |
1881500 | 1881500 | 2021-11-03 | Wood | West Virginia | 54107 | 13278 | 250 |
1878251 | 1878251 | 2021-11-02 | Wood | West Virginia | 54107 | 13242 | 249 |
1875002 | 1875002 | 2021-11-01 | Wood | West Virginia | 54107 | 13217 | 249 |
1871753 | 1871753 | 2021-10-31 | Wood | West Virginia | 54107 | 13185 | 246 |
1868504 | 1868504 | 2021-10-30 | Wood | West Virginia | 54107 | 13152 | 246 |
1865255 | 1865255 | 2021-10-29 | Wood | West Virginia | 54107 | 13119 | 246 |
1862006 | 1862006 | 2021-10-28 | Wood | West Virginia | 54107 | 13088 | 246 |
1858757 | 1858757 | 2021-10-27 | Wood | West Virginia | 54107 | 13070 | 245 |
1855508 | 1855508 | 2021-10-26 | Wood | West Virginia | 54107 | 13037 | 243 |
1852259 | 1852259 | 2021-10-25 | Wood | West Virginia | 54107 | 12995 | 242 |
1849009 | 1849009 | 2021-10-24 | Wood | West Virginia | 54107 | 12961 | 240 |
1845759 | 1845759 | 2021-10-23 | Wood | West Virginia | 54107 | 12935 | 240 |
1842509 | 1842509 | 2021-10-22 | Wood | West Virginia | 54107 | 12881 | 240 |
1839260 | 1839260 | 2021-10-21 | Wood | West Virginia | 54107 | 12833 | 238 |
1836011 | 1836011 | 2021-10-20 | Wood | West Virginia | 54107 | 12800 | 237 |
1832762 | 1832762 | 2021-10-19 | Wood | West Virginia | 54107 | 12752 | 232 |
1829513 | 1829513 | 2021-10-18 | Wood | West Virginia | 54107 | 12730 | 231 |
1826264 | 1826264 | 2021-10-17 | Wood | West Virginia | 54107 | 12702 | 228 |
1823015 | 1823015 | 2021-10-16 | Wood | West Virginia | 54107 | 12658 | 228 |
1819766 | 1819766 | 2021-10-15 | Wood | West Virginia | 54107 | 12610 | 228 |
1816517 | 1816517 | 2021-10-14 | Wood | West Virginia | 54107 | 12560 | 226 |
1813269 | 1813269 | 2021-10-13 | Wood | West Virginia | 54107 | 12499 | 226 |
1810020 | 1810020 | 2021-10-12 | Wood | West Virginia | 54107 | 12440 | 225 |
1806771 | 1806771 | 2021-10-11 | Wood | West Virginia | 54107 | 12406 | 224 |
1803520 | 1803520 | 2021-10-10 | Wood | West Virginia | 54107 | 12367 | 224 |
1800271 | 1800271 | 2021-10-09 | Wood | West Virginia | 54107 | 12316 | 224 |
1797022 | 1797022 | 2021-10-08 | Wood | West Virginia | 54107 | 12264 | 224 |
1793773 | 1793773 | 2021-10-07 | Wood | West Virginia | 54107 | 12188 | 222 |
1790524 | 1790524 | 2021-10-06 | Wood | West Virginia | 54107 | 12125 | 220 |
1787276 | 1787276 | 2021-10-05 | Wood | West Virginia | 54107 | 12044 | 212 |
1784027 | 1784027 | 2021-10-04 | Wood | West Virginia | 54107 | 11994 | 212 |
1780778 | 1780778 | 2021-10-03 | Wood | West Virginia | 54107 | 11958 | 209 |
1777528 | 1777528 | 2021-10-02 | Wood | West Virginia | 54107 | 11893 | 209 |
1774278 | 1774278 | 2021-10-01 | Wood | West Virginia | 54107 | 11824 | 209 |
1771028 | 1771028 | 2021-09-30 | Wood | West Virginia | 54107 | 11735 | 207 |
1767779 | 1767779 | 2021-09-29 | Wood | West Virginia | 54107 | 11619 | 206 |
1764530 | 1764530 | 2021-09-28 | Wood | West Virginia | 54107 | 11549 | 205 |
1761281 | 1761281 | 2021-09-27 | Wood | West Virginia | 54107 | 11485 | 204 |
1758033 | 1758033 | 2021-09-26 | Wood | West Virginia | 54107 | 11430 | 203 |
1754785 | 1754785 | 2021-09-25 | Wood | West Virginia | 54107 | 11331 | 203 |
1751537 | 1751537 | 2021-09-24 | Wood | West Virginia | 54107 | 11243 | 203 |
1748288 | 1748288 | 2021-09-23 | Wood | West Virginia | 54107 | 11124 | 203 |
1745038 | 1745038 | 2021-09-22 | Wood | West Virginia | 54107 | 11052 | 202 |
1741789 | 1741789 | 2021-09-21 | Wood | West Virginia | 54107 | 10959 | 200 |
1738540 | 1738540 | 2021-09-20 | Wood | West Virginia | 54107 | 10904 | 199 |
1735291 | 1735291 | 2021-09-19 | Wood | West Virginia | 54107 | 10847 | 195 |
1732041 | 1732041 | 2021-09-18 | Wood | West Virginia | 54107 | 10761 | 195 |
1728791 | 1728791 | 2021-09-17 | Wood | West Virginia | 54107 | 10672 | 195 |
1725541 | 1725541 | 2021-09-16 | Wood | West Virginia | 54107 | 10556 | 192 |
1722292 | 1722292 | 2021-09-15 | Wood | West Virginia | 54107 | 10468 | 190 |
1719044 | 1719044 | 2021-09-14 | Wood | West Virginia | 54107 | 10355 | 190 |
1715796 | 1715796 | 2021-09-13 | Wood | West Virginia | 54107 | 10262 | 189 |
1712550 | 1712550 | 2021-09-12 | Wood | West Virginia | 54107 | 10196 | 186 |
1709303 | 1709303 | 2021-09-11 | Wood | West Virginia | 54107 | 10113 | 186 |
1706056 | 1706056 | 2021-09-10 | Wood | West Virginia | 54107 | 9977 | 186 |
1702807 | 1702807 | 2021-09-09 | Wood | West Virginia | 54107 | 9882 | 185 |
1699557 | 1699557 | 2021-09-08 | Wood | West Virginia | 54107 | 9786 | 184 |
1696309 | 1696309 | 2021-09-07 | Wood | West Virginia | 54107 | 9710 | 184 |
1693061 | 1693061 | 2021-09-06 | Wood | West Virginia | 54107 | 9647 | 184 |
1689812 | 1689812 | 2021-09-05 | Wood | West Virginia | 54107 | 9600 | 184 |
1686562 | 1686562 | 2021-09-04 | Wood | West Virginia | 54107 | 9477 | 184 |
1683312 | 1683312 | 2021-09-03 | Wood | West Virginia | 54107 | 9362 | 183 |
1680061 | 1680061 | 2021-09-02 | Wood | West Virginia | 54107 | 9269 | 184 |
1676813 | 1676813 | 2021-09-01 | Wood | West Virginia | 54107 | 9171 | 183 |
1673566 | 1673566 | 2021-08-31 | Wood | West Virginia | 54107 | 9086 | 182 |
1670318 | 1670318 | 2021-08-30 | Wood | West Virginia | 54107 | 9043 | 182 |
1667071 | 1667071 | 2021-08-29 | Wood | West Virginia | 54107 | 8980 | 181 |
1663823 | 1663823 | 2021-08-28 | Wood | West Virginia | 54107 | 8900 | 180 |
1660575 | 1660575 | 2021-08-27 | Wood | West Virginia | 54107 | 8900 | 180 |
1657327 | 1657327 | 2021-08-26 | Wood | West Virginia | 54107 | 8825 | 180 |
1654079 | 1654079 | 2021-08-25 | Wood | West Virginia | 54107 | 8781 | 180 |
1650833 | 1650833 | 2021-08-24 | Wood | West Virginia | 54107 | 8736 | 180 |
1647584 | 1647584 | 2021-08-23 | Wood | West Virginia | 54107 | 8690 | 180 |
1644335 | 1644335 | 2021-08-22 | Wood | West Virginia | 54107 | 8600 | 180 |
1641085 | 1641085 | 2021-08-21 | Wood | West Virginia | 54107 | 8600 | 180 |
1637835 | 1637835 | 2021-08-20 | Wood | West Virginia | 54107 | 8600 | 180 |
1634585 | 1634585 | 2021-08-19 | Wood | West Virginia | 54107 | 8539 | 178 |
1631337 | 1631337 | 2021-08-18 | Wood | West Virginia | 54107 | 8483 | 177 |
1628090 | 1628090 | 2021-08-17 | Wood | West Virginia | 54107 | 8432 | 177 |
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);