ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
303 rows where deaths = 29 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 |
---|---|---|---|---|---|---|---|
2444095 | 2444095 | 2022-04-25 | Pocahontas | West Virginia | 54075 | 2018 | 29 |
2440839 | 2440839 | 2022-04-24 | Pocahontas | West Virginia | 54075 | 2015 | 29 |
2437583 | 2437583 | 2022-04-23 | Pocahontas | West Virginia | 54075 | 2015 | 29 |
2434327 | 2434327 | 2022-04-22 | Pocahontas | West Virginia | 54075 | 2015 | 29 |
2431071 | 2431071 | 2022-04-21 | Pocahontas | West Virginia | 54075 | 2014 | 29 |
2427815 | 2427815 | 2022-04-20 | Pocahontas | West Virginia | 54075 | 2014 | 29 |
2424559 | 2424559 | 2022-04-19 | Pocahontas | West Virginia | 54075 | 2014 | 29 |
2421303 | 2421303 | 2022-04-18 | Pocahontas | West Virginia | 54075 | 2014 | 29 |
2418047 | 2418047 | 2022-04-17 | Pocahontas | West Virginia | 54075 | 2014 | 29 |
2414791 | 2414791 | 2022-04-16 | Pocahontas | West Virginia | 54075 | 2014 | 29 |
2411535 | 2411535 | 2022-04-15 | Pocahontas | West Virginia | 54075 | 2014 | 29 |
2339957 | 2339957 | 2022-03-24 | Webster | West Virginia | 54101 | 2250 | 29 |
2336704 | 2336704 | 2022-03-23 | Webster | West Virginia | 54101 | 2250 | 29 |
2333450 | 2333450 | 2022-03-22 | Webster | West Virginia | 54101 | 2250 | 29 |
2330196 | 2330196 | 2022-03-21 | Webster | West Virginia | 54101 | 2249 | 29 |
2326944 | 2326944 | 2022-03-20 | Webster | West Virginia | 54101 | 2247 | 29 |
2323691 | 2323691 | 2022-03-19 | Webster | West Virginia | 54101 | 2247 | 29 |
2320437 | 2320437 | 2022-03-18 | Webster | West Virginia | 54101 | 2247 | 29 |
2317183 | 2317183 | 2022-03-17 | Webster | West Virginia | 54101 | 2239 | 29 |
2313930 | 2313930 | 2022-03-16 | Webster | West Virginia | 54101 | 2237 | 29 |
2310677 | 2310677 | 2022-03-15 | Webster | West Virginia | 54101 | 2238 | 29 |
2307424 | 2307424 | 2022-03-14 | Webster | West Virginia | 54101 | 2235 | 29 |
2304173 | 2304173 | 2022-03-13 | Webster | West Virginia | 54101 | 2233 | 29 |
2300921 | 2300921 | 2022-03-12 | Webster | West Virginia | 54101 | 2233 | 29 |
2297669 | 2297669 | 2022-03-11 | Webster | West Virginia | 54101 | 2233 | 29 |
2294417 | 2294417 | 2022-03-10 | Webster | West Virginia | 54101 | 2219 | 29 |
2291165 | 2291165 | 2022-03-09 | Webster | West Virginia | 54101 | 2208 | 29 |
2265142 | 2265142 | 2022-03-01 | Tyler | West Virginia | 54095 | 2160 | 29 |
2261892 | 2261892 | 2022-02-28 | Tyler | West Virginia | 54095 | 2159 | 29 |
2258641 | 2258641 | 2022-02-27 | Tyler | West Virginia | 54095 | 2153 | 29 |
2255390 | 2255390 | 2022-02-26 | Tyler | West Virginia | 54095 | 2153 | 29 |
2252139 | 2252139 | 2022-02-25 | Tyler | West Virginia | 54095 | 2153 | 29 |
2248888 | 2248888 | 2022-02-24 | Tyler | West Virginia | 54095 | 2152 | 29 |
2245637 | 2245637 | 2022-02-23 | Tyler | West Virginia | 54095 | 2148 | 29 |
2239130 | 2239130 | 2022-02-21 | Ritchie | West Virginia | 54085 | 2337 | 29 |
2235879 | 2235879 | 2022-02-20 | Ritchie | West Virginia | 54085 | 2315 | 29 |
2232628 | 2232628 | 2022-02-19 | Ritchie | West Virginia | 54085 | 2315 | 29 |
2229377 | 2229377 | 2022-02-18 | Ritchie | West Virginia | 54085 | 2315 | 29 |
2125245 | 2125245 | 2022-01-17 | Clay | West Virginia | 54015 | 1870 | 29 |
2125281 | 2125281 | 2022-01-17 | Roane | West Virginia | 54087 | 2431 | 29 |
2121993 | 2121993 | 2022-01-16 | Clay | West Virginia | 54015 | 1857 | 29 |
2122029 | 2122029 | 2022-01-16 | Roane | West Virginia | 54087 | 2394 | 29 |
2118741 | 2118741 | 2022-01-15 | Clay | West Virginia | 54015 | 1837 | 29 |
2118777 | 2118777 | 2022-01-15 | Roane | West Virginia | 54087 | 2373 | 29 |
2115489 | 2115489 | 2022-01-14 | Clay | West Virginia | 54015 | 1811 | 29 |
2115525 | 2115525 | 2022-01-14 | Roane | West Virginia | 54087 | 2335 | 29 |
2112237 | 2112237 | 2022-01-13 | Clay | West Virginia | 54015 | 1798 | 29 |
2112273 | 2112273 | 2022-01-13 | Roane | West Virginia | 54087 | 2281 | 29 |
2109021 | 2109021 | 2022-01-12 | Roane | West Virginia | 54087 | 2231 | 29 |
2105770 | 2105770 | 2022-01-11 | Roane | West Virginia | 54087 | 2209 | 29 |
2102519 | 2102519 | 2022-01-10 | Roane | West Virginia | 54087 | 2195 | 29 |
2099268 | 2099268 | 2022-01-09 | Roane | West Virginia | 54087 | 2177 | 29 |
2096017 | 2096017 | 2022-01-08 | Roane | West Virginia | 54087 | 2169 | 29 |
2092765 | 2092765 | 2022-01-07 | Roane | West Virginia | 54087 | 2155 | 29 |
2089513 | 2089513 | 2022-01-06 | Roane | West Virginia | 54087 | 2132 | 29 |
2053715 | 2053715 | 2021-12-26 | Braxton | West Virginia | 54007 | 2613 | 29 |
2050465 | 2050465 | 2021-12-25 | Braxton | West Virginia | 54007 | 2613 | 29 |
2047215 | 2047215 | 2021-12-24 | Braxton | West Virginia | 54007 | 2613 | 29 |
2043965 | 2043965 | 2021-12-23 | Braxton | West Virginia | 54007 | 2613 | 29 |
2040716 | 2040716 | 2021-12-22 | Braxton | West Virginia | 54007 | 2603 | 29 |
2037466 | 2037466 | 2021-12-21 | Braxton | West Virginia | 54007 | 2593 | 29 |
2034216 | 2034216 | 2021-12-20 | Braxton | West Virginia | 54007 | 2571 | 29 |
2030994 | 2030994 | 2021-12-19 | Monroe | West Virginia | 54063 | 2475 | 29 |
2027743 | 2027743 | 2021-12-18 | Monroe | West Virginia | 54063 | 2460 | 29 |
2024492 | 2024492 | 2021-12-17 | Monroe | West Virginia | 54063 | 2440 | 29 |
1894492 | 1894492 | 2021-11-07 | Tucker | West Virginia | 54093 | 1160 | 29 |
1891242 | 1891242 | 2021-11-06 | Tucker | West Virginia | 54093 | 1160 | 29 |
1887992 | 1887992 | 2021-11-05 | Tucker | West Virginia | 54093 | 1160 | 29 |
1884742 | 1884742 | 2021-11-04 | Tucker | West Virginia | 54093 | 1151 | 29 |
1881493 | 1881493 | 2021-11-03 | Tucker | West Virginia | 54093 | 1145 | 29 |
1878244 | 1878244 | 2021-11-02 | Tucker | West Virginia | 54093 | 1135 | 29 |
1874995 | 1874995 | 2021-11-01 | Tucker | West Virginia | 54093 | 1125 | 29 |
1871746 | 1871746 | 2021-10-31 | Tucker | West Virginia | 54093 | 1124 | 29 |
1868497 | 1868497 | 2021-10-30 | Tucker | West Virginia | 54093 | 1122 | 29 |
1865248 | 1865248 | 2021-10-29 | Tucker | West Virginia | 54093 | 1113 | 29 |
1861999 | 1861999 | 2021-10-28 | Tucker | West Virginia | 54093 | 1105 | 29 |
1848971 | 1848971 | 2021-10-24 | Hardy | West Virginia | 54031 | 2384 | 29 |
1845721 | 1845721 | 2021-10-23 | Hardy | West Virginia | 54031 | 2377 | 29 |
1842471 | 1842471 | 2021-10-22 | Hardy | West Virginia | 54031 | 2370 | 29 |
1839222 | 1839222 | 2021-10-21 | Hardy | West Virginia | 54031 | 2364 | 29 |
1835973 | 1835973 | 2021-10-20 | Hardy | West Virginia | 54031 | 2353 | 29 |
1816500 | 1816500 | 2021-10-14 | Pleasants | West Virginia | 54073 | 1367 | 29 |
1813260 | 1813260 | 2021-10-13 | Summers | West Virginia | 54089 | 1359 | 29 |
1810011 | 1810011 | 2021-10-12 | Summers | West Virginia | 54089 | 1357 | 29 |
1806762 | 1806762 | 2021-10-11 | Summers | West Virginia | 54089 | 1355 | 29 |
1803511 | 1803511 | 2021-10-10 | Summers | West Virginia | 54089 | 1351 | 29 |
1800262 | 1800262 | 2021-10-09 | Summers | West Virginia | 54089 | 1351 | 29 |
1797013 | 1797013 | 2021-10-08 | Summers | West Virginia | 54089 | 1348 | 29 |
1793764 | 1793764 | 2021-10-07 | Summers | West Virginia | 54089 | 1345 | 29 |
1764518 | 1764518 | 2021-09-28 | Randolph | West Virginia | 54083 | 4593 | 29 |
1761269 | 1761269 | 2021-09-27 | Randolph | West Virginia | 54083 | 4578 | 29 |
1745030 | 1745030 | 2021-09-22 | Taylor | West Virginia | 54091 | 1841 | 29 |
1741768 | 1741768 | 2021-09-21 | Morgan | West Virginia | 54065 | 1732 | 29 |
1741781 | 1741781 | 2021-09-21 | Taylor | West Virginia | 54091 | 1823 | 29 |
1738519 | 1738519 | 2021-09-20 | Morgan | West Virginia | 54065 | 1717 | 29 |
1738532 | 1738532 | 2021-09-20 | Taylor | West Virginia | 54091 | 1814 | 29 |
1735271 | 1735271 | 2021-09-19 | Nicholas | West Virginia | 54067 | 2853 | 29 |
1732021 | 1732021 | 2021-09-18 | Nicholas | West Virginia | 54067 | 2825 | 29 |
1728771 | 1728771 | 2021-09-17 | Nicholas | West Virginia | 54067 | 2795 | 29 |
1725521 | 1725521 | 2021-09-16 | Nicholas | West Virginia | 54067 | 2751 | 29 |
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);