ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
747 rows where fips = 54075 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 |
---|---|---|---|---|---|---|---|
2177334 | 2177334 | 2022-02-02 | Pocahontas | West Virginia | 54075 | 1810 | 25 |
2174081 | 2174081 | 2022-02-01 | Pocahontas | West Virginia | 54075 | 1796 | 25 |
2170829 | 2170829 | 2022-01-31 | Pocahontas | West Virginia | 54075 | 1776 | 25 |
2167576 | 2167576 | 2022-01-30 | Pocahontas | West Virginia | 54075 | 1770 | 25 |
2164321 | 2164321 | 2022-01-29 | Pocahontas | West Virginia | 54075 | 1766 | 25 |
2161066 | 2161066 | 2022-01-28 | Pocahontas | West Virginia | 54075 | 1751 | 25 |
2157810 | 2157810 | 2022-01-27 | Pocahontas | West Virginia | 54075 | 1740 | 25 |
2154557 | 2154557 | 2022-01-26 | Pocahontas | West Virginia | 54075 | 1717 | 25 |
2151304 | 2151304 | 2022-01-25 | Pocahontas | West Virginia | 54075 | 1675 | 25 |
2148052 | 2148052 | 2022-01-24 | Pocahontas | West Virginia | 54075 | 1663 | 25 |
2144800 | 2144800 | 2022-01-23 | Pocahontas | West Virginia | 54075 | 1634 | 25 |
2141545 | 2141545 | 2022-01-22 | Pocahontas | West Virginia | 54075 | 1623 | 25 |
2138289 | 2138289 | 2022-01-21 | Pocahontas | West Virginia | 54075 | 1604 | 25 |
2135034 | 2135034 | 2022-01-20 | Pocahontas | West Virginia | 54075 | 1591 | 25 |
2131782 | 2131782 | 2022-01-19 | Pocahontas | West Virginia | 54075 | 1577 | 25 |
2128528 | 2128528 | 2022-01-18 | Pocahontas | West Virginia | 54075 | 1560 | 25 |
2125275 | 2125275 | 2022-01-17 | Pocahontas | West Virginia | 54075 | 1546 | 24 |
2122023 | 2122023 | 2022-01-16 | Pocahontas | West Virginia | 54075 | 1540 | 23 |
2118771 | 2118771 | 2022-01-15 | Pocahontas | West Virginia | 54075 | 1533 | 23 |
2115519 | 2115519 | 2022-01-14 | Pocahontas | West Virginia | 54075 | 1522 | 23 |
2112267 | 2112267 | 2022-01-13 | Pocahontas | West Virginia | 54075 | 1509 | 23 |
2109015 | 2109015 | 2022-01-12 | Pocahontas | West Virginia | 54075 | 1488 | 23 |
2105764 | 2105764 | 2022-01-11 | Pocahontas | West Virginia | 54075 | 1477 | 23 |
2102513 | 2102513 | 2022-01-10 | Pocahontas | West Virginia | 54075 | 1464 | 23 |
2099262 | 2099262 | 2022-01-09 | Pocahontas | West Virginia | 54075 | 1460 | 23 |
2096011 | 2096011 | 2022-01-08 | Pocahontas | West Virginia | 54075 | 1458 | 23 |
2092759 | 2092759 | 2022-01-07 | Pocahontas | West Virginia | 54075 | 1448 | 23 |
2089507 | 2089507 | 2022-01-06 | Pocahontas | West Virginia | 54075 | 1436 | 23 |
2086256 | 2086256 | 2022-01-05 | Pocahontas | West Virginia | 54075 | 1423 | 23 |
2083004 | 2083004 | 2022-01-04 | Pocahontas | West Virginia | 54075 | 1416 | 22 |
2079752 | 2079752 | 2022-01-03 | Pocahontas | West Virginia | 54075 | 1397 | 22 |
2076500 | 2076500 | 2022-01-02 | Pocahontas | West Virginia | 54075 | 1364 | 22 |
2073249 | 2073249 | 2022-01-01 | Pocahontas | West Virginia | 54075 | 1364 | 22 |
2069998 | 2069998 | 2021-12-31 | Pocahontas | West Virginia | 54075 | 1364 | 22 |
2066747 | 2066747 | 2021-12-30 | Pocahontas | West Virginia | 54075 | 1364 | 22 |
2063497 | 2063497 | 2021-12-29 | Pocahontas | West Virginia | 54075 | 1355 | 22 |
2060247 | 2060247 | 2021-12-28 | Pocahontas | West Virginia | 54075 | 1347 | 22 |
2056998 | 2056998 | 2021-12-27 | Pocahontas | West Virginia | 54075 | 1344 | 22 |
2053749 | 2053749 | 2021-12-26 | Pocahontas | West Virginia | 54075 | 1329 | 22 |
2050499 | 2050499 | 2021-12-25 | Pocahontas | West Virginia | 54075 | 1329 | 22 |
2047249 | 2047249 | 2021-12-24 | Pocahontas | West Virginia | 54075 | 1329 | 22 |
2043999 | 2043999 | 2021-12-23 | Pocahontas | West Virginia | 54075 | 1329 | 22 |
2040750 | 2040750 | 2021-12-22 | Pocahontas | West Virginia | 54075 | 1325 | 22 |
2037500 | 2037500 | 2021-12-21 | Pocahontas | West Virginia | 54075 | 1324 | 22 |
2034250 | 2034250 | 2021-12-20 | Pocahontas | West Virginia | 54075 | 1321 | 21 |
2031000 | 2031000 | 2021-12-19 | Pocahontas | West Virginia | 54075 | 1321 | 21 |
2027749 | 2027749 | 2021-12-18 | Pocahontas | West Virginia | 54075 | 1319 | 21 |
2024498 | 2024498 | 2021-12-17 | Pocahontas | West Virginia | 54075 | 1314 | 21 |
2021247 | 2021247 | 2021-12-16 | Pocahontas | West Virginia | 54075 | 1308 | 21 |
2017996 | 2017996 | 2021-12-15 | Pocahontas | West Virginia | 54075 | 1305 | 21 |
2014746 | 2014746 | 2021-12-14 | Pocahontas | West Virginia | 54075 | 1299 | 21 |
2011495 | 2011495 | 2021-12-13 | Pocahontas | West Virginia | 54075 | 1292 | 21 |
2008244 | 2008244 | 2021-12-12 | Pocahontas | West Virginia | 54075 | 1291 | 21 |
2004993 | 2004993 | 2021-12-11 | Pocahontas | West Virginia | 54075 | 1289 | 21 |
2001742 | 2001742 | 2021-12-10 | Pocahontas | West Virginia | 54075 | 1288 | 21 |
1998492 | 1998492 | 2021-12-09 | Pocahontas | West Virginia | 54075 | 1285 | 21 |
1995241 | 1995241 | 2021-12-08 | Pocahontas | West Virginia | 54075 | 1284 | 21 |
1991990 | 1991990 | 2021-12-07 | Pocahontas | West Virginia | 54075 | 1283 | 21 |
1988739 | 1988739 | 2021-12-06 | Pocahontas | West Virginia | 54075 | 1282 | 21 |
1985489 | 1985489 | 2021-12-05 | Pocahontas | West Virginia | 54075 | 1281 | 21 |
1982239 | 1982239 | 2021-12-04 | Pocahontas | West Virginia | 54075 | 1279 | 21 |
1978989 | 1978989 | 2021-12-03 | Pocahontas | West Virginia | 54075 | 1276 | 21 |
1975739 | 1975739 | 2021-12-02 | Pocahontas | West Virginia | 54075 | 1274 | 21 |
1972490 | 1972490 | 2021-12-01 | Pocahontas | West Virginia | 54075 | 1270 | 21 |
1969240 | 1969240 | 2021-11-30 | Pocahontas | West Virginia | 54075 | 1262 | 21 |
1965990 | 1965990 | 2021-11-29 | Pocahontas | West Virginia | 54075 | 1257 | 19 |
1962738 | 1962738 | 2021-11-28 | Pocahontas | West Virginia | 54075 | 1238 | 19 |
1959487 | 1959487 | 2021-11-27 | Pocahontas | West Virginia | 54075 | 1238 | 19 |
1956236 | 1956236 | 2021-11-26 | Pocahontas | West Virginia | 54075 | 1238 | 19 |
1952985 | 1952985 | 2021-11-25 | Pocahontas | West Virginia | 54075 | 1238 | 19 |
1949734 | 1949734 | 2021-11-24 | Pocahontas | West Virginia | 54075 | 1238 | 19 |
1946483 | 1946483 | 2021-11-23 | Pocahontas | West Virginia | 54075 | 1236 | 18 |
1943232 | 1943232 | 2021-11-22 | Pocahontas | West Virginia | 54075 | 1230 | 18 |
1939982 | 1939982 | 2021-11-21 | Pocahontas | West Virginia | 54075 | 1230 | 18 |
1936732 | 1936732 | 2021-11-20 | Pocahontas | West Virginia | 54075 | 1231 | 18 |
1933482 | 1933482 | 2021-11-19 | Pocahontas | West Virginia | 54075 | 1228 | 18 |
1930230 | 1930230 | 2021-11-18 | Pocahontas | West Virginia | 54075 | 1222 | 18 |
1926980 | 1926980 | 2021-11-17 | Pocahontas | West Virginia | 54075 | 1216 | 18 |
1923730 | 1923730 | 2021-11-16 | Pocahontas | West Virginia | 54075 | 1209 | 18 |
1920481 | 1920481 | 2021-11-15 | Pocahontas | West Virginia | 54075 | 1200 | 18 |
1917231 | 1917231 | 2021-11-14 | Pocahontas | West Virginia | 54075 | 1199 | 18 |
1913981 | 1913981 | 2021-11-13 | Pocahontas | West Virginia | 54075 | 1197 | 18 |
1910731 | 1910731 | 2021-11-12 | Pocahontas | West Virginia | 54075 | 1190 | 18 |
1907482 | 1907482 | 2021-11-11 | Pocahontas | West Virginia | 54075 | 1189 | 18 |
1904233 | 1904233 | 2021-11-10 | Pocahontas | West Virginia | 54075 | 1188 | 18 |
1900983 | 1900983 | 2021-11-09 | Pocahontas | West Virginia | 54075 | 1186 | 18 |
1897733 | 1897733 | 2021-11-08 | Pocahontas | West Virginia | 54075 | 1184 | 18 |
1894483 | 1894483 | 2021-11-07 | Pocahontas | West Virginia | 54075 | 1183 | 18 |
1891233 | 1891233 | 2021-11-06 | Pocahontas | West Virginia | 54075 | 1183 | 18 |
1887983 | 1887983 | 2021-11-05 | Pocahontas | West Virginia | 54075 | 1178 | 18 |
1884733 | 1884733 | 2021-11-04 | Pocahontas | West Virginia | 54075 | 1173 | 18 |
1881484 | 1881484 | 2021-11-03 | Pocahontas | West Virginia | 54075 | 1175 | 18 |
1878235 | 1878235 | 2021-11-02 | Pocahontas | West Virginia | 54075 | 1167 | 18 |
1874986 | 1874986 | 2021-11-01 | Pocahontas | West Virginia | 54075 | 1161 | 18 |
1871737 | 1871737 | 2021-10-31 | Pocahontas | West Virginia | 54075 | 1160 | 18 |
1868488 | 1868488 | 2021-10-30 | Pocahontas | West Virginia | 54075 | 1158 | 18 |
1865239 | 1865239 | 2021-10-29 | Pocahontas | West Virginia | 54075 | 1157 | 18 |
1861990 | 1861990 | 2021-10-28 | Pocahontas | West Virginia | 54075 | 1153 | 18 |
1858741 | 1858741 | 2021-10-27 | Pocahontas | West Virginia | 54075 | 1150 | 18 |
1855492 | 1855492 | 2021-10-26 | Pocahontas | West Virginia | 54075 | 1145 | 18 |
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);