ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
343 rows where deaths = 15 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Randolph 49
- Pendleton 36
- Pocahontas 22
- Nicholas 18
- Gilmer 17
- Braxton 16
- Raleigh 15
- Calhoun 11
- Pleasants 11
- Wirt 11
- Jackson 10
- Doddridge 9
- Mingo 9
- Monroe 9
- Jefferson 8
- Wayne 8
- Ritchie 7
- Taylor 7
- Barbour 6
- Summers 6
- Boone 5
- Morgan 5
- Tyler 5
- Fayette 4
- Preston 4
- Brooke 3
- Harrison 3
- Kanawha 3
- Marion 3
- Mason 3
- …
state 1
- West Virginia · 343 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502689 | 2502689 | 2022-05-13 | Calhoun | West Virginia | 54013 | 1887 | 15 |
2499431 | 2499431 | 2022-05-12 | Calhoun | West Virginia | 54013 | 1885 | 15 |
2496173 | 2496173 | 2022-05-11 | Calhoun | West Virginia | 54013 | 1884 | 15 |
2492915 | 2492915 | 2022-05-10 | Calhoun | West Virginia | 54013 | 1884 | 15 |
2489657 | 2489657 | 2022-05-09 | Calhoun | West Virginia | 54013 | 1884 | 15 |
2486400 | 2486400 | 2022-05-08 | Calhoun | West Virginia | 54013 | 1882 | 15 |
2483142 | 2483142 | 2022-05-07 | Calhoun | West Virginia | 54013 | 1882 | 15 |
2479884 | 2479884 | 2022-05-06 | Calhoun | West Virginia | 54013 | 1882 | 15 |
2476626 | 2476626 | 2022-05-05 | Calhoun | West Virginia | 54013 | 1879 | 15 |
2473368 | 2473368 | 2022-05-04 | Calhoun | West Virginia | 54013 | 1879 | 15 |
2470111 | 2470111 | 2022-05-03 | Calhoun | West Virginia | 54013 | 1879 | 15 |
2112238 | 2112238 | 2022-01-13 | Doddridge | West Virginia | 54017 | 1625 | 15 |
2108986 | 2108986 | 2022-01-12 | Doddridge | West Virginia | 54017 | 1619 | 15 |
2105735 | 2105735 | 2022-01-11 | Doddridge | West Virginia | 54017 | 1608 | 15 |
2102484 | 2102484 | 2022-01-10 | Doddridge | West Virginia | 54017 | 1606 | 15 |
2099233 | 2099233 | 2022-01-09 | Doddridge | West Virginia | 54017 | 1599 | 15 |
2095982 | 2095982 | 2022-01-08 | Doddridge | West Virginia | 54017 | 1592 | 15 |
2092730 | 2092730 | 2022-01-07 | Doddridge | West Virginia | 54017 | 1587 | 15 |
2089478 | 2089478 | 2022-01-06 | Doddridge | West Virginia | 54017 | 1583 | 15 |
2089480 | 2089480 | 2022-01-06 | Gilmer | West Virginia | 54021 | 1622 | 15 |
2086227 | 2086227 | 2022-01-05 | Doddridge | West Virginia | 54017 | 1576 | 15 |
2086229 | 2086229 | 2022-01-05 | Gilmer | West Virginia | 54021 | 1617 | 15 |
2082977 | 2082977 | 2022-01-04 | Gilmer | West Virginia | 54021 | 1613 | 15 |
2079725 | 2079725 | 2022-01-03 | Gilmer | West Virginia | 54021 | 1612 | 15 |
2076473 | 2076473 | 2022-01-02 | Gilmer | West Virginia | 54021 | 1601 | 15 |
2073222 | 2073222 | 2022-01-01 | Gilmer | West Virginia | 54021 | 1601 | 15 |
2069971 | 2069971 | 2021-12-31 | Gilmer | West Virginia | 54021 | 1601 | 15 |
2066720 | 2066720 | 2021-12-30 | Gilmer | West Virginia | 54021 | 1601 | 15 |
2063470 | 2063470 | 2021-12-29 | Gilmer | West Virginia | 54021 | 1588 | 15 |
2060220 | 2060220 | 2021-12-28 | Gilmer | West Virginia | 54021 | 1582 | 15 |
2056971 | 2056971 | 2021-12-27 | Gilmer | West Virginia | 54021 | 1582 | 15 |
2053722 | 2053722 | 2021-12-26 | Gilmer | West Virginia | 54021 | 1562 | 15 |
2050472 | 2050472 | 2021-12-25 | Gilmer | West Virginia | 54021 | 1562 | 15 |
2047222 | 2047222 | 2021-12-24 | Gilmer | West Virginia | 54021 | 1562 | 15 |
2043972 | 2043972 | 2021-12-23 | Gilmer | West Virginia | 54021 | 1562 | 15 |
2040723 | 2040723 | 2021-12-22 | Gilmer | West Virginia | 54021 | 1558 | 15 |
2037473 | 2037473 | 2021-12-21 | Gilmer | West Virginia | 54021 | 1550 | 15 |
1975737 | 1975737 | 2021-12-02 | Pendleton | West Virginia | 54071 | 1243 | 15 |
1972488 | 1972488 | 2021-12-01 | Pendleton | West Virginia | 54071 | 1237 | 15 |
1969238 | 1969238 | 2021-11-30 | Pendleton | West Virginia | 54071 | 1231 | 15 |
1965988 | 1965988 | 2021-11-29 | Pendleton | West Virginia | 54071 | 1221 | 15 |
1962736 | 1962736 | 2021-11-28 | Pendleton | West Virginia | 54071 | 1208 | 15 |
1962753 | 1962753 | 2021-11-28 | Wirt | West Virginia | 54105 | 902 | 15 |
1959485 | 1959485 | 2021-11-27 | Pendleton | West Virginia | 54071 | 1208 | 15 |
1959502 | 1959502 | 2021-11-27 | Wirt | West Virginia | 54105 | 902 | 15 |
1956234 | 1956234 | 2021-11-26 | Pendleton | West Virginia | 54071 | 1208 | 15 |
1956251 | 1956251 | 2021-11-26 | Wirt | West Virginia | 54105 | 902 | 15 |
1952983 | 1952983 | 2021-11-25 | Pendleton | West Virginia | 54071 | 1208 | 15 |
1953000 | 1953000 | 2021-11-25 | Wirt | West Virginia | 54105 | 902 | 15 |
1949732 | 1949732 | 2021-11-24 | Pendleton | West Virginia | 54071 | 1208 | 15 |
1949749 | 1949749 | 2021-11-24 | Wirt | West Virginia | 54105 | 902 | 15 |
1946481 | 1946481 | 2021-11-23 | Pendleton | West Virginia | 54071 | 1206 | 15 |
1946498 | 1946498 | 2021-11-23 | Wirt | West Virginia | 54105 | 899 | 15 |
1943230 | 1943230 | 2021-11-22 | Pendleton | West Virginia | 54071 | 1203 | 15 |
1943247 | 1943247 | 2021-11-22 | Wirt | West Virginia | 54105 | 896 | 15 |
1939980 | 1939980 | 2021-11-21 | Pendleton | West Virginia | 54071 | 1201 | 15 |
1939997 | 1939997 | 2021-11-21 | Wirt | West Virginia | 54105 | 895 | 15 |
1936730 | 1936730 | 2021-11-20 | Pendleton | West Virginia | 54071 | 1191 | 15 |
1936747 | 1936747 | 2021-11-20 | Wirt | West Virginia | 54105 | 891 | 15 |
1933480 | 1933480 | 2021-11-19 | Pendleton | West Virginia | 54071 | 1181 | 15 |
1933497 | 1933497 | 2021-11-19 | Wirt | West Virginia | 54105 | 890 | 15 |
1930228 | 1930228 | 2021-11-18 | Pendleton | West Virginia | 54071 | 1171 | 15 |
1930245 | 1930245 | 2021-11-18 | Wirt | West Virginia | 54105 | 885 | 15 |
1926978 | 1926978 | 2021-11-17 | Pendleton | West Virginia | 54071 | 1157 | 15 |
1923728 | 1923728 | 2021-11-16 | Pendleton | West Virginia | 54071 | 1151 | 15 |
1920479 | 1920479 | 2021-11-15 | Pendleton | West Virginia | 54071 | 1143 | 15 |
1917229 | 1917229 | 2021-11-14 | Pendleton | West Virginia | 54071 | 1141 | 15 |
1913979 | 1913979 | 2021-11-13 | Pendleton | West Virginia | 54071 | 1136 | 15 |
1910729 | 1910729 | 2021-11-12 | Pendleton | West Virginia | 54071 | 1129 | 15 |
1907480 | 1907480 | 2021-11-11 | Pendleton | West Virginia | 54071 | 1126 | 15 |
1904231 | 1904231 | 2021-11-10 | Pendleton | West Virginia | 54071 | 1124 | 15 |
1900981 | 1900981 | 2021-11-09 | Pendleton | West Virginia | 54071 | 1120 | 15 |
1897731 | 1897731 | 2021-11-08 | Pendleton | West Virginia | 54071 | 1120 | 15 |
1894481 | 1894481 | 2021-11-07 | Pendleton | West Virginia | 54071 | 1121 | 15 |
1891231 | 1891231 | 2021-11-06 | Pendleton | West Virginia | 54071 | 1118 | 15 |
1887981 | 1887981 | 2021-11-05 | Pendleton | West Virginia | 54071 | 1114 | 15 |
1884731 | 1884731 | 2021-11-04 | Pendleton | West Virginia | 54071 | 1116 | 15 |
1881482 | 1881482 | 2021-11-03 | Pendleton | West Virginia | 54071 | 1114 | 15 |
1878233 | 1878233 | 2021-11-02 | Pendleton | West Virginia | 54071 | 1112 | 15 |
1874984 | 1874984 | 2021-11-01 | Pendleton | West Virginia | 54071 | 1111 | 15 |
1871735 | 1871735 | 2021-10-31 | Pendleton | West Virginia | 54071 | 1107 | 15 |
1868486 | 1868486 | 2021-10-30 | Pendleton | West Virginia | 54071 | 1106 | 15 |
1865237 | 1865237 | 2021-10-29 | Pendleton | West Virginia | 54071 | 1104 | 15 |
1861988 | 1861988 | 2021-10-28 | Pendleton | West Virginia | 54071 | 1100 | 15 |
1832712 | 1832712 | 2021-10-19 | Braxton | West Virginia | 54007 | 2078 | 15 |
1829463 | 1829463 | 2021-10-18 | Braxton | West Virginia | 54007 | 2072 | 15 |
1826214 | 1826214 | 2021-10-17 | Braxton | West Virginia | 54007 | 2063 | 15 |
1822965 | 1822965 | 2021-10-16 | Braxton | West Virginia | 54007 | 2055 | 15 |
1819716 | 1819716 | 2021-10-15 | Braxton | West Virginia | 54007 | 2050 | 15 |
1816467 | 1816467 | 2021-10-14 | Braxton | West Virginia | 54007 | 2037 | 15 |
1813219 | 1813219 | 2021-10-13 | Braxton | West Virginia | 54007 | 2029 | 15 |
1809970 | 1809970 | 2021-10-12 | Braxton | West Virginia | 54007 | 2016 | 15 |
1806721 | 1806721 | 2021-10-11 | Braxton | West Virginia | 54007 | 2014 | 15 |
1803470 | 1803470 | 2021-10-10 | Braxton | West Virginia | 54007 | 2009 | 15 |
1800221 | 1800221 | 2021-10-09 | Braxton | West Virginia | 54007 | 2000 | 15 |
1796972 | 1796972 | 2021-10-08 | Braxton | West Virginia | 54007 | 1986 | 15 |
1793723 | 1793723 | 2021-10-07 | Braxton | West Virginia | 54007 | 1985 | 15 |
1790474 | 1790474 | 2021-10-06 | Braxton | West Virginia | 54007 | 1971 | 15 |
1787226 | 1787226 | 2021-10-05 | Braxton | West Virginia | 54007 | 1953 | 15 |
1783977 | 1783977 | 2021-10-04 | Braxton | West Virginia | 54007 | 1943 | 15 |
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);