ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
410 rows where deaths = 22 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Summers 119
- McDowell 47
- Lewis 39
- Lincoln 35
- Pendleton 23
- Nicholas 15
- Pocahontas 15
- Ritchie 13
- Boone 9
- Grant 9
- Taylor 8
- Braxton 7
- Morgan 7
- Brooke 6
- Clay 6
- Jackson 5
- Jefferson 5
- Roane 5
- Wayne 5
- Wyoming 5
- Kanawha 4
- Berkeley 3
- Greenbrier 3
- Mason 3
- Mercer 3
- Putnam 3
- Hampshire 2
- Pleasants 2
- Tucker 2
- Mineral 1
- …
state 1
- West Virginia · 410 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502718 | 2502718 | 2022-05-13 | Pendleton | West Virginia | 54071 | 2001 | 22 |
2499460 | 2499460 | 2022-05-12 | Pendleton | West Virginia | 54071 | 1998 | 22 |
2496202 | 2496202 | 2022-05-11 | Pendleton | West Virginia | 54071 | 1992 | 22 |
2492944 | 2492944 | 2022-05-10 | Pendleton | West Virginia | 54071 | 1987 | 22 |
2489686 | 2489686 | 2022-05-09 | Pendleton | West Virginia | 54071 | 1987 | 22 |
2486429 | 2486429 | 2022-05-08 | Pendleton | West Virginia | 54071 | 1979 | 22 |
2483171 | 2483171 | 2022-05-07 | Pendleton | West Virginia | 54071 | 1979 | 22 |
2479913 | 2479913 | 2022-05-06 | Pendleton | West Virginia | 54071 | 1979 | 22 |
2476655 | 2476655 | 2022-05-05 | Pendleton | West Virginia | 54071 | 1977 | 22 |
2473397 | 2473397 | 2022-05-04 | Pendleton | West Virginia | 54071 | 1977 | 22 |
2470140 | 2470140 | 2022-05-03 | Pendleton | West Virginia | 54071 | 1976 | 22 |
2466884 | 2466884 | 2022-05-02 | Pendleton | West Virginia | 54071 | 1974 | 22 |
2463629 | 2463629 | 2022-05-01 | Pendleton | West Virginia | 54071 | 1972 | 22 |
2460373 | 2460373 | 2022-04-30 | Pendleton | West Virginia | 54071 | 1972 | 22 |
2457117 | 2457117 | 2022-04-29 | Pendleton | West Virginia | 54071 | 1972 | 22 |
2453861 | 2453861 | 2022-04-28 | Pendleton | West Virginia | 54071 | 1971 | 22 |
2450605 | 2450605 | 2022-04-27 | Pendleton | West Virginia | 54071 | 1968 | 22 |
2447349 | 2447349 | 2022-04-26 | Pendleton | West Virginia | 54071 | 1968 | 22 |
2444093 | 2444093 | 2022-04-25 | Pendleton | West Virginia | 54071 | 1967 | 22 |
2440837 | 2440837 | 2022-04-24 | Pendleton | West Virginia | 54071 | 1966 | 22 |
2437581 | 2437581 | 2022-04-23 | Pendleton | West Virginia | 54071 | 1966 | 22 |
2434325 | 2434325 | 2022-04-22 | Pendleton | West Virginia | 54071 | 1966 | 22 |
2431069 | 2431069 | 2022-04-21 | Pendleton | West Virginia | 54071 | 1962 | 22 |
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 |
1998497 | 1998497 | 2021-12-09 | Ritchie | West Virginia | 54085 | 1603 | 22 |
1995246 | 1995246 | 2021-12-08 | Ritchie | West Virginia | 54085 | 1598 | 22 |
1991995 | 1991995 | 2021-12-07 | Ritchie | West Virginia | 54085 | 1592 | 22 |
1988744 | 1988744 | 2021-12-06 | Ritchie | West Virginia | 54085 | 1586 | 22 |
1985494 | 1985494 | 2021-12-05 | Ritchie | West Virginia | 54085 | 1582 | 22 |
1982244 | 1982244 | 2021-12-04 | Ritchie | West Virginia | 54085 | 1579 | 22 |
1978994 | 1978994 | 2021-12-03 | Ritchie | West Virginia | 54085 | 1577 | 22 |
1975744 | 1975744 | 2021-12-02 | Ritchie | West Virginia | 54085 | 1568 | 22 |
1969210 | 1969210 | 2021-11-30 | Clay | West Virginia | 54015 | 1390 | 22 |
1962708 | 1962708 | 2021-11-28 | Clay | West Virginia | 54015 | 1368 | 22 |
1962743 | 1962743 | 2021-11-28 | Ritchie | West Virginia | 54085 | 1536 | 22 |
1959457 | 1959457 | 2021-11-27 | Clay | West Virginia | 54015 | 1368 | 22 |
1959492 | 1959492 | 2021-11-27 | Ritchie | West Virginia | 54085 | 1536 | 22 |
1956206 | 1956206 | 2021-11-26 | Clay | West Virginia | 54015 | 1368 | 22 |
1956241 | 1956241 | 2021-11-26 | Ritchie | West Virginia | 54085 | 1536 | 22 |
1952955 | 1952955 | 2021-11-25 | Clay | West Virginia | 54015 | 1368 | 22 |
1952990 | 1952990 | 2021-11-25 | Ritchie | West Virginia | 54085 | 1536 | 22 |
1949704 | 1949704 | 2021-11-24 | Clay | West Virginia | 54015 | 1368 | 22 |
1949739 | 1949739 | 2021-11-24 | Ritchie | West Virginia | 54085 | 1536 | 22 |
1920447 | 1920447 | 2021-11-15 | Braxton | West Virginia | 54007 | 2280 | 22 |
1917197 | 1917197 | 2021-11-14 | Braxton | West Virginia | 54007 | 2277 | 22 |
1913947 | 1913947 | 2021-11-13 | Braxton | West Virginia | 54007 | 2274 | 22 |
1910697 | 1910697 | 2021-11-12 | Braxton | West Virginia | 54007 | 2262 | 22 |
1907448 | 1907448 | 2021-11-11 | Braxton | West Virginia | 54007 | 2250 | 22 |
1904199 | 1904199 | 2021-11-10 | Braxton | West Virginia | 54007 | 2236 | 22 |
1900949 | 1900949 | 2021-11-09 | Braxton | West Virginia | 54007 | 2233 | 22 |
1897739 | 1897739 | 2021-11-08 | Roane | West Virginia | 54087 | 1633 | 22 |
1894489 | 1894489 | 2021-11-07 | Roane | West Virginia | 54087 | 1620 | 22 |
1891239 | 1891239 | 2021-11-06 | Roane | West Virginia | 54087 | 1615 | 22 |
1887989 | 1887989 | 2021-11-05 | Roane | West Virginia | 54087 | 1598 | 22 |
1884739 | 1884739 | 2021-11-04 | Roane | West Virginia | 54087 | 1582 | 22 |
1832755 | 1832755 | 2021-10-19 | Tucker | West Virginia | 54093 | 1060 | 22 |
1829506 | 1829506 | 2021-10-18 | Tucker | West Virginia | 54093 | 1055 | 22 |
1771011 | 1771011 | 2021-09-30 | Pleasants | West Virginia | 54073 | 1317 | 22 |
1767762 | 1767762 | 2021-09-29 | Pleasants | West Virginia | 54073 | 1308 | 22 |
1624834 | 1624834 | 2021-08-16 | Summers | West Virginia | 54089 | 896 | 22 |
1621587 | 1621587 | 2021-08-15 | Summers | West Virginia | 54089 | 888 | 22 |
1618339 | 1618339 | 2021-08-14 | Summers | West Virginia | 54089 | 888 | 22 |
1615091 | 1615091 | 2021-08-13 | Summers | West Virginia | 54089 | 888 | 22 |
1611842 | 1611842 | 2021-08-12 | Summers | West Virginia | 54089 | 888 | 22 |
1608595 | 1608595 | 2021-08-11 | Summers | West Virginia | 54089 | 881 | 22 |
1605346 | 1605346 | 2021-08-10 | Summers | West Virginia | 54089 | 879 | 22 |
1602096 | 1602096 | 2021-08-09 | Summers | West Virginia | 54089 | 878 | 22 |
1598848 | 1598848 | 2021-08-08 | Summers | West Virginia | 54089 | 876 | 22 |
1595599 | 1595599 | 2021-08-07 | Summers | West Virginia | 54089 | 876 | 22 |
1592350 | 1592350 | 2021-08-06 | Summers | West Virginia | 54089 | 876 | 22 |
1589101 | 1589101 | 2021-08-05 | Summers | West Virginia | 54089 | 875 | 22 |
1585852 | 1585852 | 2021-08-04 | Summers | West Virginia | 54089 | 875 | 22 |
1582602 | 1582602 | 2021-08-03 | Summers | West Virginia | 54089 | 874 | 22 |
1579352 | 1579352 | 2021-08-02 | Summers | West Virginia | 54089 | 873 | 22 |
1576080 | 1576080 | 2021-08-01 | Lewis | West Virginia | 54041 | 1355 | 22 |
1576104 | 1576104 | 2021-08-01 | Summers | West Virginia | 54089 | 871 | 22 |
1572832 | 1572832 | 2021-07-31 | Lewis | West Virginia | 54041 | 1355 | 22 |
1572856 | 1572856 | 2021-07-31 | Summers | West Virginia | 54089 | 871 | 22 |
1569584 | 1569584 | 2021-07-30 | Lewis | West Virginia | 54041 | 1355 | 22 |
1569608 | 1569608 | 2021-07-30 | Summers | West Virginia | 54089 | 871 | 22 |
1566336 | 1566336 | 2021-07-29 | Lewis | West Virginia | 54041 | 1354 | 22 |
1566360 | 1566360 | 2021-07-29 | Summers | West Virginia | 54089 | 870 | 22 |
1563088 | 1563088 | 2021-07-28 | Lewis | West Virginia | 54041 | 1346 | 22 |
1563112 | 1563112 | 2021-07-28 | Summers | West Virginia | 54089 | 870 | 22 |
1559840 | 1559840 | 2021-07-27 | Lewis | West Virginia | 54041 | 1344 | 22 |
1559864 | 1559864 | 2021-07-27 | Summers | West Virginia | 54089 | 870 | 22 |
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);