ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
183 rows where deaths = 38 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 |
---|---|---|---|---|---|---|---|
2502729 | 2502729 | 2022-05-13 | Tucker | West Virginia | 54093 | 2024 | 38 |
2499471 | 2499471 | 2022-05-12 | Tucker | West Virginia | 54093 | 2023 | 38 |
2496213 | 2496213 | 2022-05-11 | Tucker | West Virginia | 54093 | 2022 | 38 |
2492955 | 2492955 | 2022-05-10 | Tucker | West Virginia | 54093 | 2019 | 38 |
2489697 | 2489697 | 2022-05-09 | Tucker | West Virginia | 54093 | 2019 | 38 |
2486440 | 2486440 | 2022-05-08 | Tucker | West Virginia | 54093 | 2017 | 38 |
2483182 | 2483182 | 2022-05-07 | Tucker | West Virginia | 54093 | 2017 | 38 |
2479924 | 2479924 | 2022-05-06 | Tucker | West Virginia | 54093 | 2017 | 38 |
2476666 | 2476666 | 2022-05-05 | Tucker | West Virginia | 54093 | 2017 | 38 |
2473408 | 2473408 | 2022-05-04 | Tucker | West Virginia | 54093 | 2013 | 38 |
2470151 | 2470151 | 2022-05-03 | Tucker | West Virginia | 54093 | 2013 | 38 |
2466895 | 2466895 | 2022-05-02 | Tucker | West Virginia | 54093 | 2012 | 38 |
2463640 | 2463640 | 2022-05-01 | Tucker | West Virginia | 54093 | 2008 | 38 |
2460384 | 2460384 | 2022-04-30 | Tucker | West Virginia | 54093 | 2008 | 38 |
2457128 | 2457128 | 2022-04-29 | Tucker | West Virginia | 54093 | 2008 | 38 |
2453872 | 2453872 | 2022-04-28 | Tucker | West Virginia | 54093 | 2005 | 38 |
2450616 | 2450616 | 2022-04-27 | Tucker | West Virginia | 54093 | 2005 | 38 |
2447360 | 2447360 | 2022-04-26 | Tucker | West Virginia | 54093 | 2005 | 38 |
2375733 | 2375733 | 2022-04-04 | Roane | West Virginia | 54087 | 3151 | 38 |
2372481 | 2372481 | 2022-04-03 | Roane | West Virginia | 54087 | 3147 | 38 |
2369228 | 2369228 | 2022-04-02 | Roane | West Virginia | 54087 | 3147 | 38 |
2365975 | 2365975 | 2022-04-01 | Roane | West Virginia | 54087 | 3147 | 38 |
2362722 | 2362722 | 2022-03-31 | Roane | West Virginia | 54087 | 3146 | 38 |
2359468 | 2359468 | 2022-03-30 | Roane | West Virginia | 54087 | 3146 | 38 |
2356214 | 2356214 | 2022-03-29 | Roane | West Virginia | 54087 | 3145 | 38 |
2307381 | 2307381 | 2022-03-14 | Clay | West Virginia | 54015 | 2334 | 38 |
2304130 | 2304130 | 2022-03-13 | Clay | West Virginia | 54015 | 2333 | 38 |
2300878 | 2300878 | 2022-03-12 | Clay | West Virginia | 54015 | 2333 | 38 |
2297626 | 2297626 | 2022-03-11 | Clay | West Virginia | 54015 | 2333 | 38 |
2294374 | 2294374 | 2022-03-10 | Clay | West Virginia | 54015 | 2333 | 38 |
2216335 | 2216335 | 2022-02-14 | Braxton | West Virginia | 54007 | 3581 | 38 |
2086263 | 2086263 | 2022-01-05 | Summers | West Virginia | 54089 | 1782 | 38 |
2083011 | 2083011 | 2022-01-04 | Summers | West Virginia | 54089 | 1766 | 38 |
2079759 | 2079759 | 2022-01-03 | Summers | West Virginia | 54089 | 1761 | 38 |
2076507 | 2076507 | 2022-01-02 | Summers | West Virginia | 54089 | 1727 | 38 |
2073256 | 2073256 | 2022-01-01 | Summers | West Virginia | 54089 | 1727 | 38 |
2070005 | 2070005 | 2021-12-31 | Summers | West Virginia | 54089 | 1727 | 38 |
2066754 | 2066754 | 2021-12-30 | Summers | West Virginia | 54089 | 1727 | 38 |
2037478 | 2037478 | 2021-12-21 | Hardy | West Virginia | 54031 | 2862 | 38 |
2034228 | 2034228 | 2021-12-20 | Hardy | West Virginia | 54031 | 2858 | 38 |
2030978 | 2030978 | 2021-12-19 | Hardy | West Virginia | 54031 | 2855 | 38 |
2027727 | 2027727 | 2021-12-18 | Hardy | West Virginia | 54031 | 2853 | 38 |
2024476 | 2024476 | 2021-12-17 | Hardy | West Virginia | 54031 | 2840 | 38 |
1985463 | 1985463 | 2021-12-05 | Grant | West Virginia | 54023 | 2498 | 38 |
1982213 | 1982213 | 2021-12-04 | Grant | West Virginia | 54023 | 2480 | 38 |
1978963 | 1978963 | 2021-12-03 | Grant | West Virginia | 54023 | 2464 | 38 |
1975713 | 1975713 | 2021-12-02 | Grant | West Virginia | 54023 | 2453 | 38 |
1972464 | 1972464 | 2021-12-01 | Grant | West Virginia | 54023 | 2444 | 38 |
1904241 | 1904241 | 2021-11-10 | Taylor | West Virginia | 54091 | 2431 | 38 |
1900991 | 1900991 | 2021-11-09 | Taylor | West Virginia | 54091 | 2418 | 38 |
1897741 | 1897741 | 2021-11-08 | Taylor | West Virginia | 54091 | 2414 | 38 |
1894491 | 1894491 | 2021-11-07 | Taylor | West Virginia | 54091 | 2406 | 38 |
1891241 | 1891241 | 2021-11-06 | Taylor | West Virginia | 54091 | 2386 | 38 |
1887991 | 1887991 | 2021-11-05 | Taylor | West Virginia | 54091 | 2370 | 38 |
1884741 | 1884741 | 2021-11-04 | Taylor | West Virginia | 54091 | 2356 | 38 |
1881492 | 1881492 | 2021-11-03 | Taylor | West Virginia | 54091 | 2328 | 38 |
1878243 | 1878243 | 2021-11-02 | Taylor | West Virginia | 54091 | 2320 | 38 |
1874994 | 1874994 | 2021-11-01 | Taylor | West Virginia | 54091 | 2314 | 38 |
1871745 | 1871745 | 2021-10-31 | Taylor | West Virginia | 54091 | 2312 | 38 |
1868496 | 1868496 | 2021-10-30 | Taylor | West Virginia | 54091 | 2287 | 38 |
1865247 | 1865247 | 2021-10-29 | Taylor | West Virginia | 54091 | 2276 | 38 |
1861998 | 1861998 | 2021-10-28 | Taylor | West Virginia | 54091 | 2264 | 38 |
1858749 | 1858749 | 2021-10-27 | Taylor | West Virginia | 54091 | 2241 | 38 |
1855500 | 1855500 | 2021-10-26 | Taylor | West Virginia | 54091 | 2232 | 38 |
1852251 | 1852251 | 2021-10-25 | Taylor | West Virginia | 54091 | 2221 | 38 |
1849001 | 1849001 | 2021-10-24 | Taylor | West Virginia | 54091 | 2203 | 38 |
1845751 | 1845751 | 2021-10-23 | Taylor | West Virginia | 54091 | 2197 | 38 |
1842501 | 1842501 | 2021-10-22 | Taylor | West Virginia | 54091 | 2183 | 38 |
1816497 | 1816497 | 2021-10-14 | Nicholas | West Virginia | 54067 | 3406 | 38 |
1813249 | 1813249 | 2021-10-13 | Nicholas | West Virginia | 54067 | 3374 | 38 |
1810000 | 1810000 | 2021-10-12 | Nicholas | West Virginia | 54067 | 3350 | 38 |
1806751 | 1806751 | 2021-10-11 | Nicholas | West Virginia | 54067 | 3338 | 38 |
1803500 | 1803500 | 2021-10-10 | Nicholas | West Virginia | 54067 | 3323 | 38 |
1800251 | 1800251 | 2021-10-09 | Nicholas | West Virginia | 54067 | 3300 | 38 |
1800259 | 1800259 | 2021-10-09 | Randolph | West Virginia | 54083 | 4864 | 38 |
1797002 | 1797002 | 2021-10-08 | Nicholas | West Virginia | 54067 | 3274 | 38 |
1793753 | 1793753 | 2021-10-07 | Nicholas | West Virginia | 54067 | 3247 | 38 |
1793761 | 1793761 | 2021-10-07 | Randolph | West Virginia | 54083 | 4826 | 38 |
1790503 | 1790503 | 2021-10-06 | Morgan | West Virginia | 54065 | 1894 | 38 |
1757982 | 1757982 | 2021-09-26 | Boone | West Virginia | 54005 | 3058 | 38 |
1754734 | 1754734 | 2021-09-25 | Boone | West Virginia | 54005 | 3042 | 38 |
1751486 | 1751486 | 2021-09-24 | Boone | West Virginia | 54005 | 3016 | 38 |
1748237 | 1748237 | 2021-09-23 | Boone | West Virginia | 54005 | 2982 | 38 |
1748248 | 1748248 | 2021-09-23 | Hampshire | West Virginia | 54027 | 2666 | 38 |
1744987 | 1744987 | 2021-09-22 | Boone | West Virginia | 54005 | 2963 | 38 |
1744998 | 1744998 | 2021-09-22 | Hampshire | West Virginia | 54027 | 2636 | 38 |
1741738 | 1741738 | 2021-09-21 | Boone | West Virginia | 54005 | 2943 | 38 |
1741749 | 1741749 | 2021-09-21 | Hampshire | West Virginia | 54027 | 2610 | 38 |
1738489 | 1738489 | 2021-09-20 | Boone | West Virginia | 54005 | 2929 | 38 |
1738500 | 1738500 | 2021-09-20 | Hampshire | West Virginia | 54027 | 2582 | 38 |
1735240 | 1735240 | 2021-09-19 | Boone | West Virginia | 54005 | 2911 | 38 |
1731990 | 1731990 | 2021-09-18 | Boone | West Virginia | 54005 | 2892 | 38 |
1728740 | 1728740 | 2021-09-17 | Boone | West Virginia | 54005 | 2871 | 38 |
1725490 | 1725490 | 2021-09-16 | Boone | West Virginia | 54005 | 2840 | 38 |
1722241 | 1722241 | 2021-09-15 | Boone | West Virginia | 54005 | 2804 | 38 |
1718993 | 1718993 | 2021-09-14 | Boone | West Virginia | 54005 | 2774 | 38 |
1715745 | 1715745 | 2021-09-13 | Boone | West Virginia | 54005 | 2753 | 38 |
1624815 | 1624815 | 2021-08-16 | Mason | West Virginia | 54053 | 2245 | 38 |
1621568 | 1621568 | 2021-08-15 | Mason | West Virginia | 54053 | 2220 | 38 |
1618320 | 1618320 | 2021-08-14 | Mason | West Virginia | 54053 | 2220 | 38 |
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);