ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
318 rows where deaths = 21 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2427813 | 2427813 | 2022-04-20 | Pendleton | West Virginia | 54071 | 1962 | 21 |
2424557 | 2424557 | 2022-04-19 | Pendleton | West Virginia | 54071 | 1961 | 21 |
2421301 | 2421301 | 2022-04-18 | Pendleton | West Virginia | 54071 | 1959 | 21 |
2418045 | 2418045 | 2022-04-17 | Pendleton | West Virginia | 54071 | 1959 | 21 |
2414789 | 2414789 | 2022-04-16 | Pendleton | West Virginia | 54071 | 1959 | 21 |
2411533 | 2411533 | 2022-04-15 | Pendleton | West Virginia | 54071 | 1959 | 21 |
2408277 | 2408277 | 2022-04-14 | Pendleton | West Virginia | 54071 | 1959 | 21 |
2405021 | 2405021 | 2022-04-13 | Pendleton | West Virginia | 54071 | 1959 | 21 |
2401766 | 2401766 | 2022-04-12 | Pendleton | West Virginia | 54071 | 1961 | 21 |
2398511 | 2398511 | 2022-04-11 | Pendleton | West Virginia | 54071 | 1956 | 21 |
2395256 | 2395256 | 2022-04-10 | Pendleton | West Virginia | 54071 | 1953 | 21 |
2392000 | 2392000 | 2022-04-09 | Pendleton | West Virginia | 54071 | 1953 | 21 |
2388744 | 2388744 | 2022-04-08 | Pendleton | West Virginia | 54071 | 1953 | 21 |
2385489 | 2385489 | 2022-04-07 | Pendleton | West Virginia | 54071 | 1948 | 21 |
2382234 | 2382234 | 2022-04-06 | Pendleton | West Virginia | 54071 | 1948 | 21 |
2219634 | 2219634 | 2022-02-15 | Wirt | West Virginia | 54105 | 1403 | 21 |
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 |
1972495 | 1972495 | 2021-12-01 | Ritchie | West Virginia | 54085 | 1554 | 21 |
1969240 | 1969240 | 2021-11-30 | Pocahontas | West Virginia | 54075 | 1262 | 21 |
1969245 | 1969245 | 2021-11-30 | Ritchie | West Virginia | 54085 | 1545 | 21 |
1965960 | 1965960 | 2021-11-29 | Clay | West Virginia | 54015 | 1386 | 21 |
1965995 | 1965995 | 2021-11-29 | Ritchie | West Virginia | 54085 | 1545 | 21 |
1946453 | 1946453 | 2021-11-23 | Clay | West Virginia | 54015 | 1368 | 21 |
1946488 | 1946488 | 2021-11-23 | Ritchie | West Virginia | 54085 | 1532 | 21 |
1943202 | 1943202 | 2021-11-22 | Clay | West Virginia | 54015 | 1363 | 21 |
1943237 | 1943237 | 2021-11-22 | Ritchie | West Virginia | 54085 | 1526 | 21 |
1939952 | 1939952 | 2021-11-21 | Clay | West Virginia | 54015 | 1359 | 21 |
1939987 | 1939987 | 2021-11-21 | Ritchie | West Virginia | 54085 | 1527 | 21 |
1936702 | 1936702 | 2021-11-20 | Clay | West Virginia | 54015 | 1358 | 21 |
1936737 | 1936737 | 2021-11-20 | Ritchie | West Virginia | 54085 | 1525 | 21 |
1933452 | 1933452 | 2021-11-19 | Clay | West Virginia | 54015 | 1353 | 21 |
1933487 | 1933487 | 2021-11-19 | Ritchie | West Virginia | 54085 | 1517 | 21 |
1930200 | 1930200 | 2021-11-18 | Clay | West Virginia | 54015 | 1345 | 21 |
1930235 | 1930235 | 2021-11-18 | Ritchie | West Virginia | 54085 | 1518 | 21 |
1926950 | 1926950 | 2021-11-17 | Clay | West Virginia | 54015 | 1332 | 21 |
1926985 | 1926985 | 2021-11-17 | Ritchie | West Virginia | 54085 | 1513 | 21 |
1923735 | 1923735 | 2021-11-16 | Ritchie | West Virginia | 54085 | 1508 | 21 |
1920494 | 1920494 | 2021-11-15 | Webster | West Virginia | 54101 | 1262 | 21 |
1897699 | 1897699 | 2021-11-08 | Braxton | West Virginia | 54007 | 2222 | 21 |
1894449 | 1894449 | 2021-11-07 | Braxton | West Virginia | 54007 | 2216 | 21 |
1891199 | 1891199 | 2021-11-06 | Braxton | West Virginia | 54007 | 2209 | 21 |
1887949 | 1887949 | 2021-11-05 | Braxton | West Virginia | 54007 | 2201 | 21 |
1884699 | 1884699 | 2021-11-04 | Braxton | West Virginia | 54007 | 2191 | 21 |
1881450 | 1881450 | 2021-11-03 | Braxton | West Virginia | 54007 | 2176 | 21 |
1881490 | 1881490 | 2021-11-03 | Roane | West Virginia | 54087 | 1574 | 21 |
1878201 | 1878201 | 2021-11-02 | Braxton | West Virginia | 54007 | 2170 | 21 |
1878241 | 1878241 | 2021-11-02 | Roane | West Virginia | 54087 | 1560 | 21 |
1874952 | 1874952 | 2021-11-01 | Braxton | West Virginia | 54007 | 2164 | 21 |
1874992 | 1874992 | 2021-11-01 | Roane | West Virginia | 54087 | 1554 | 21 |
1871743 | 1871743 | 2021-10-31 | Roane | West Virginia | 54087 | 1543 | 21 |
1868494 | 1868494 | 2021-10-30 | Roane | West Virginia | 54087 | 1529 | 21 |
1865245 | 1865245 | 2021-10-29 | Roane | West Virginia | 54087 | 1518 | 21 |
1861996 | 1861996 | 2021-10-28 | Roane | West Virginia | 54087 | 1506 | 21 |
1858747 | 1858747 | 2021-10-27 | Roane | West Virginia | 54087 | 1490 | 21 |
1758011 | 1758011 | 2021-09-26 | Monroe | West Virginia | 54063 | 1908 | 21 |
1754763 | 1754763 | 2021-09-25 | Monroe | West Virginia | 54063 | 1902 | 21 |
1751515 | 1751515 | 2021-09-24 | Monroe | West Virginia | 54063 | 1894 | 21 |
1748266 | 1748266 | 2021-09-23 | Monroe | West Virginia | 54063 | 1873 | 21 |
1745016 | 1745016 | 2021-09-22 | Monroe | West Virginia | 54063 | 1871 | 21 |
1741767 | 1741767 | 2021-09-21 | Monroe | West Virginia | 54063 | 1865 | 21 |
1673554 | 1673554 | 2021-08-31 | Randolph | West Virginia | 54083 | 3586 | 21 |
1465697 | 1465697 | 2021-06-28 | Nicholas | West Virginia | 54067 | 1905 | 21 |
1462452 | 1462452 | 2021-06-27 | Nicholas | West Virginia | 54067 | 1903 | 21 |
1459207 | 1459207 | 2021-06-26 | Nicholas | West Virginia | 54067 | 1903 | 21 |
1455962 | 1455962 | 2021-06-25 | Nicholas | West Virginia | 54067 | 1903 | 21 |
1452717 | 1452717 | 2021-06-24 | Nicholas | West Virginia | 54067 | 1903 | 21 |
1449458 | 1449458 | 2021-06-23 | Lewis | West Virginia | 54041 | 1280 | 21 |
1449471 | 1449471 | 2021-06-23 | Nicholas | West Virginia | 54067 | 1899 | 21 |
1446213 | 1446213 | 2021-06-22 | Lewis | West Virginia | 54041 | 1280 | 21 |
1446226 | 1446226 | 2021-06-22 | Nicholas | West Virginia | 54067 | 1898 | 21 |
1442968 | 1442968 | 2021-06-21 | Lewis | West Virginia | 54041 | 1279 | 21 |
1442981 | 1442981 | 2021-06-21 | Nicholas | West Virginia | 54067 | 1892 | 21 |
1439723 | 1439723 | 2021-06-20 | Lewis | West Virginia | 54041 | 1279 | 21 |
1439736 | 1439736 | 2021-06-20 | Nicholas | West Virginia | 54067 | 1892 | 21 |
1436476 | 1436476 | 2021-06-19 | Lewis | West Virginia | 54041 | 1279 | 21 |
1436489 | 1436489 | 2021-06-19 | Nicholas | West Virginia | 54067 | 1892 | 21 |
1433229 | 1433229 | 2021-06-18 | Lewis | West Virginia | 54041 | 1279 | 21 |
1433242 | 1433242 | 2021-06-18 | Nicholas | West Virginia | 54067 | 1892 | 21 |
1429983 | 1429983 | 2021-06-17 | Lewis | West Virginia | 54041 | 1279 | 21 |
1429996 | 1429996 | 2021-06-17 | Nicholas | West Virginia | 54067 | 1892 | 21 |
1426738 | 1426738 | 2021-06-16 | Lewis | West Virginia | 54041 | 1280 | 21 |
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);