ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
416 rows where deaths = 23 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 |
---|---|---|---|---|---|---|---|
2326946 | 2326946 | 2022-03-20 | Wirt | West Virginia | 54105 | 1434 | 23 |
2323693 | 2323693 | 2022-03-19 | Wirt | West Virginia | 54105 | 1434 | 23 |
2320439 | 2320439 | 2022-03-18 | Wirt | West Virginia | 54105 | 1434 | 23 |
2317185 | 2317185 | 2022-03-17 | Wirt | West Virginia | 54105 | 1434 | 23 |
2313932 | 2313932 | 2022-03-16 | Wirt | West Virginia | 54105 | 1434 | 23 |
2310679 | 2310679 | 2022-03-15 | Wirt | West Virginia | 54105 | 1434 | 23 |
2307426 | 2307426 | 2022-03-14 | Wirt | West Virginia | 54105 | 1434 | 23 |
2304175 | 2304175 | 2022-03-13 | Wirt | West Virginia | 54105 | 1434 | 23 |
2300923 | 2300923 | 2022-03-12 | Wirt | West Virginia | 54105 | 1434 | 23 |
2297671 | 2297671 | 2022-03-11 | Wirt | West Virginia | 54105 | 1434 | 23 |
2294419 | 2294419 | 2022-03-10 | Wirt | West Virginia | 54105 | 1434 | 23 |
2291167 | 2291167 | 2022-03-09 | Wirt | West Virginia | 54105 | 1433 | 23 |
2287915 | 2287915 | 2022-03-08 | Wirt | West Virginia | 54105 | 1432 | 23 |
2284663 | 2284663 | 2022-03-07 | Wirt | West Virginia | 54105 | 1429 | 23 |
2281411 | 2281411 | 2022-03-06 | Wirt | West Virginia | 54105 | 1427 | 23 |
2278158 | 2278158 | 2022-03-05 | Wirt | West Virginia | 54105 | 1427 | 23 |
2274905 | 2274905 | 2022-03-04 | Wirt | West Virginia | 54105 | 1427 | 23 |
2271652 | 2271652 | 2022-03-03 | Wirt | West Virginia | 54105 | 1426 | 23 |
2268400 | 2268400 | 2022-03-02 | Wirt | West Virginia | 54105 | 1424 | 23 |
2265147 | 2265147 | 2022-03-01 | Wirt | West Virginia | 54105 | 1425 | 23 |
2261897 | 2261897 | 2022-02-28 | Wirt | West Virginia | 54105 | 1425 | 23 |
2258646 | 2258646 | 2022-02-27 | Wirt | West Virginia | 54105 | 1420 | 23 |
2255395 | 2255395 | 2022-02-26 | Wirt | West Virginia | 54105 | 1420 | 23 |
2252144 | 2252144 | 2022-02-25 | Wirt | West Virginia | 54105 | 1420 | 23 |
2248893 | 2248893 | 2022-02-24 | Wirt | West Virginia | 54105 | 1420 | 23 |
2245642 | 2245642 | 2022-02-23 | Wirt | West Virginia | 54105 | 1420 | 23 |
2242391 | 2242391 | 2022-02-22 | Wirt | West Virginia | 54105 | 1420 | 23 |
2239140 | 2239140 | 2022-02-21 | Wirt | West Virginia | 54105 | 1419 | 23 |
2235889 | 2235889 | 2022-02-20 | Wirt | West Virginia | 54105 | 1409 | 23 |
2232638 | 2232638 | 2022-02-19 | Wirt | West Virginia | 54105 | 1409 | 23 |
2229387 | 2229387 | 2022-02-18 | Wirt | West Virginia | 54105 | 1409 | 23 |
2226136 | 2226136 | 2022-02-17 | Wirt | West Virginia | 54105 | 1408 | 23 |
2222885 | 2222885 | 2022-02-16 | Wirt | West Virginia | 54105 | 1408 | 23 |
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 |
2008249 | 2008249 | 2021-12-12 | Ritchie | West Virginia | 54085 | 1619 | 23 |
2004998 | 2004998 | 2021-12-11 | Ritchie | West Virginia | 54085 | 1618 | 23 |
2001747 | 2001747 | 2021-12-10 | Ritchie | West Virginia | 54085 | 1610 | 23 |
1988709 | 1988709 | 2021-12-06 | Clay | West Virginia | 54015 | 1427 | 23 |
1985459 | 1985459 | 2021-12-05 | Clay | West Virginia | 54015 | 1422 | 23 |
1982209 | 1982209 | 2021-12-04 | Clay | West Virginia | 54015 | 1419 | 23 |
1978959 | 1978959 | 2021-12-03 | Clay | West Virginia | 54015 | 1413 | 23 |
1975709 | 1975709 | 2021-12-02 | Clay | West Virginia | 54015 | 1404 | 23 |
1972460 | 1972460 | 2021-12-01 | Clay | West Virginia | 54015 | 1393 | 23 |
1965956 | 1965956 | 2021-11-29 | Braxton | West Virginia | 54007 | 2387 | 23 |
1946449 | 1946449 | 2021-11-23 | Braxton | West Virginia | 54007 | 2342 | 23 |
1943198 | 1943198 | 2021-11-22 | Braxton | West Virginia | 54007 | 2335 | 23 |
1939948 | 1939948 | 2021-11-21 | Braxton | West Virginia | 54007 | 2332 | 23 |
1936698 | 1936698 | 2021-11-20 | Braxton | West Virginia | 54007 | 2325 | 23 |
1933448 | 1933448 | 2021-11-19 | Braxton | West Virginia | 54007 | 2313 | 23 |
1930196 | 1930196 | 2021-11-18 | Braxton | West Virginia | 54007 | 2305 | 23 |
1926946 | 1926946 | 2021-11-17 | Braxton | West Virginia | 54007 | 2286 | 23 |
1926993 | 1926993 | 2021-11-17 | Webster | West Virginia | 54101 | 1287 | 23 |
1923696 | 1923696 | 2021-11-16 | Braxton | West Virginia | 54007 | 2281 | 23 |
1923743 | 1923743 | 2021-11-16 | Webster | West Virginia | 54101 | 1271 | 23 |
1904239 | 1904239 | 2021-11-10 | Roane | West Virginia | 54087 | 1654 | 23 |
1900989 | 1900989 | 2021-11-09 | Roane | West Virginia | 54087 | 1642 | 23 |
1897743 | 1897743 | 2021-11-08 | Tyler | West Virginia | 54095 | 1379 | 23 |
1894493 | 1894493 | 2021-11-07 | Tyler | West Virginia | 54095 | 1379 | 23 |
1891243 | 1891243 | 2021-11-06 | Tyler | West Virginia | 54095 | 1374 | 23 |
1887993 | 1887993 | 2021-11-05 | Tyler | West Virginia | 54095 | 1372 | 23 |
1884743 | 1884743 | 2021-11-04 | Tyler | West Virginia | 54095 | 1367 | 23 |
1780761 | 1780761 | 2021-10-03 | Pleasants | West Virginia | 54073 | 1335 | 23 |
1777511 | 1777511 | 2021-10-02 | Pleasants | West Virginia | 54073 | 1333 | 23 |
1774261 | 1774261 | 2021-10-01 | Pleasants | West Virginia | 54073 | 1326 | 23 |
1767757 | 1767757 | 2021-09-29 | Monroe | West Virginia | 54063 | 1927 | 23 |
1764508 | 1764508 | 2021-09-28 | Monroe | West Virginia | 54063 | 1918 | 23 |
1761259 | 1761259 | 2021-09-27 | Monroe | West Virginia | 54063 | 1911 | 23 |
1696300 | 1696300 | 2021-09-07 | Summers | West Virginia | 54089 | 1040 | 23 |
1693052 | 1693052 | 2021-09-06 | Summers | West Virginia | 54089 | 1039 | 23 |
1689803 | 1689803 | 2021-09-05 | Summers | West Virginia | 54089 | 1032 | 23 |
1686553 | 1686553 | 2021-09-04 | Summers | West Virginia | 54089 | 1025 | 23 |
1683302 | 1683302 | 2021-09-03 | Summers | West Virginia | 54089 | 1016 | 23 |
1680052 | 1680052 | 2021-09-02 | Summers | West Virginia | 54089 | 1007 | 23 |
1676801 | 1676801 | 2021-09-01 | Randolph | West Virginia | 54083 | 3629 | 23 |
1676804 | 1676804 | 2021-09-01 | Summers | West Virginia | 54089 | 991 | 23 |
1673557 | 1673557 | 2021-08-31 | Summers | West Virginia | 54089 | 991 | 23 |
1670309 | 1670309 | 2021-08-30 | Summers | West Virginia | 54089 | 980 | 23 |
1667062 | 1667062 | 2021-08-29 | Summers | West Virginia | 54089 | 974 | 23 |
1663814 | 1663814 | 2021-08-28 | Summers | West Virginia | 54089 | 963 | 23 |
1660566 | 1660566 | 2021-08-27 | Summers | West Virginia | 54089 | 963 | 23 |
1657318 | 1657318 | 2021-08-26 | Summers | West Virginia | 54089 | 950 | 23 |
1654070 | 1654070 | 2021-08-25 | Summers | West Virginia | 54089 | 940 | 23 |
1650824 | 1650824 | 2021-08-24 | Summers | West Virginia | 54089 | 929 | 23 |
1647575 | 1647575 | 2021-08-23 | Summers | West Virginia | 54089 | 924 | 23 |
1644326 | 1644326 | 2021-08-22 | Summers | West Virginia | 54089 | 914 | 23 |
1641076 | 1641076 | 2021-08-21 | Summers | West Virginia | 54089 | 914 | 23 |
1637826 | 1637826 | 2021-08-20 | Summers | West Virginia | 54089 | 914 | 23 |
1634576 | 1634576 | 2021-08-19 | Summers | West Virginia | 54089 | 907 | 23 |
1631328 | 1631328 | 2021-08-18 | Summers | West Virginia | 54089 | 903 | 23 |
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);