ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
190 rows where deaths = 39 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 |
---|---|---|---|---|---|---|---|
2313887 | 2313887 | 2022-03-16 | Clay | West Virginia | 54015 | 2333 | 39 |
2310634 | 2310634 | 2022-03-15 | Clay | West Virginia | 54015 | 2333 | 39 |
2265126 | 2265126 | 2022-03-01 | Monroe | West Virginia | 54063 | 4130 | 39 |
2261876 | 2261876 | 2022-02-28 | Monroe | West Virginia | 54063 | 4130 | 39 |
2258625 | 2258625 | 2022-02-27 | Monroe | West Virginia | 54063 | 4120 | 39 |
2255374 | 2255374 | 2022-02-26 | Monroe | West Virginia | 54063 | 4120 | 39 |
2252123 | 2252123 | 2022-02-25 | Monroe | West Virginia | 54063 | 4120 | 39 |
2248872 | 2248872 | 2022-02-24 | Monroe | West Virginia | 54063 | 4104 | 39 |
2245593 | 2245593 | 2022-02-23 | Braxton | West Virginia | 54007 | 3684 | 39 |
2245621 | 2245621 | 2022-02-23 | Monroe | West Virginia | 54063 | 4097 | 39 |
2242342 | 2242342 | 2022-02-22 | Braxton | West Virginia | 54007 | 3659 | 39 |
2242370 | 2242370 | 2022-02-22 | Monroe | West Virginia | 54063 | 4096 | 39 |
2239091 | 2239091 | 2022-02-21 | Braxton | West Virginia | 54007 | 3650 | 39 |
2235840 | 2235840 | 2022-02-20 | Braxton | West Virginia | 54007 | 3633 | 39 |
2232589 | 2232589 | 2022-02-19 | Braxton | West Virginia | 54007 | 3633 | 39 |
2229338 | 2229338 | 2022-02-18 | Braxton | West Virginia | 54007 | 3633 | 39 |
2226087 | 2226087 | 2022-02-17 | Braxton | West Virginia | 54007 | 3636 | 39 |
2222836 | 2222836 | 2022-02-16 | Braxton | West Virginia | 54007 | 3596 | 39 |
2219585 | 2219585 | 2022-02-15 | Braxton | West Virginia | 54007 | 3588 | 39 |
2099269 | 2099269 | 2022-01-09 | Summers | West Virginia | 54089 | 1839 | 39 |
2096018 | 2096018 | 2022-01-08 | Summers | West Virginia | 54089 | 1820 | 39 |
2092766 | 2092766 | 2022-01-07 | Summers | West Virginia | 54089 | 1813 | 39 |
2089514 | 2089514 | 2022-01-06 | Summers | West Virginia | 54089 | 1799 | 39 |
2060225 | 2060225 | 2021-12-28 | Hardy | West Virginia | 54031 | 2923 | 39 |
2056976 | 2056976 | 2021-12-27 | Hardy | West Virginia | 54031 | 2912 | 39 |
2053727 | 2053727 | 2021-12-26 | Hardy | West Virginia | 54031 | 2888 | 39 |
2050477 | 2050477 | 2021-12-25 | Hardy | West Virginia | 54031 | 2888 | 39 |
2047227 | 2047227 | 2021-12-24 | Hardy | West Virginia | 54031 | 2888 | 39 |
2043977 | 2043977 | 2021-12-23 | Hardy | West Virginia | 54031 | 2888 | 39 |
2040728 | 2040728 | 2021-12-22 | Hardy | West Virginia | 54031 | 2874 | 39 |
1917239 | 1917239 | 2021-11-14 | Taylor | West Virginia | 54091 | 2476 | 39 |
1913989 | 1913989 | 2021-11-13 | Taylor | West Virginia | 54091 | 2465 | 39 |
1910739 | 1910739 | 2021-11-12 | Taylor | West Virginia | 54091 | 2455 | 39 |
1907490 | 1907490 | 2021-11-11 | Taylor | West Virginia | 54091 | 2451 | 39 |
1826244 | 1826244 | 2021-10-17 | Nicholas | West Virginia | 54067 | 3485 | 39 |
1822995 | 1822995 | 2021-10-16 | Nicholas | West Virginia | 54067 | 3468 | 39 |
1819746 | 1819746 | 2021-10-15 | Nicholas | West Virginia | 54067 | 3433 | 39 |
1803499 | 1803499 | 2021-10-10 | Morgan | West Virginia | 54065 | 1952 | 39 |
1803508 | 1803508 | 2021-10-10 | Randolph | West Virginia | 54083 | 4869 | 39 |
1800250 | 1800250 | 2021-10-09 | Morgan | West Virginia | 54065 | 1946 | 39 |
1797001 | 1797001 | 2021-10-08 | Morgan | West Virginia | 54065 | 1930 | 39 |
1797010 | 1797010 | 2021-10-08 | Randolph | West Virginia | 54083 | 4849 | 39 |
1793741 | 1793741 | 2021-10-07 | Lincoln | West Virginia | 54043 | 2547 | 39 |
1793752 | 1793752 | 2021-10-07 | Morgan | West Virginia | 54065 | 1909 | 39 |
1790492 | 1790492 | 2021-10-06 | Lincoln | West Virginia | 54043 | 2531 | 39 |
1787243 | 1787243 | 2021-10-05 | Lewis | West Virginia | 54041 | 2703 | 39 |
1787249 | 1787249 | 2021-10-05 | McDowell | West Virginia | 54047 | 2679 | 39 |
1783994 | 1783994 | 2021-10-04 | Lewis | West Virginia | 54041 | 2689 | 39 |
1784000 | 1784000 | 2021-10-04 | McDowell | West Virginia | 54047 | 2667 | 39 |
1780751 | 1780751 | 2021-10-03 | McDowell | West Virginia | 54047 | 2654 | 39 |
1777501 | 1777501 | 2021-10-02 | McDowell | West Virginia | 54047 | 2628 | 39 |
1774251 | 1774251 | 2021-10-01 | McDowell | West Virginia | 54047 | 2607 | 39 |
1771001 | 1771001 | 2021-09-30 | McDowell | West Virginia | 54047 | 2587 | 39 |
1767752 | 1767752 | 2021-09-29 | McDowell | West Virginia | 54047 | 2547 | 39 |
1764479 | 1764479 | 2021-09-28 | Boone | West Virginia | 54005 | 3092 | 39 |
1764503 | 1764503 | 2021-09-28 | McDowell | West Virginia | 54047 | 2528 | 39 |
1761230 | 1761230 | 2021-09-27 | Boone | West Virginia | 54005 | 3078 | 39 |
1761254 | 1761254 | 2021-09-27 | McDowell | West Virginia | 54047 | 2523 | 39 |
1735238 | 1735238 | 2021-09-19 | Barbour | West Virginia | 54001 | 2275 | 39 |
1731988 | 1731988 | 2021-09-18 | Barbour | West Virginia | 54001 | 2268 | 39 |
1728738 | 1728738 | 2021-09-17 | Barbour | West Virginia | 54001 | 2249 | 39 |
1654074 | 1654074 | 2021-08-25 | Upshur | West Virginia | 54097 | 2459 | 39 |
1628062 | 1628062 | 2021-08-17 | Mason | West Virginia | 54053 | 2261 | 39 |
1443002 | 1443002 | 2021-06-21 | Wyoming | West Virginia | 54109 | 2041 | 39 |
1439757 | 1439757 | 2021-06-20 | Wyoming | West Virginia | 54109 | 2041 | 39 |
1436510 | 1436510 | 2021-06-19 | Wyoming | West Virginia | 54109 | 2041 | 39 |
1433263 | 1433263 | 2021-06-18 | Wyoming | West Virginia | 54109 | 2041 | 39 |
1430017 | 1430017 | 2021-06-17 | Wyoming | West Virginia | 54109 | 2041 | 39 |
1426772 | 1426772 | 2021-06-16 | Wyoming | West Virginia | 54109 | 2040 | 39 |
1423526 | 1423526 | 2021-06-15 | Wyoming | West Virginia | 54109 | 2035 | 39 |
1420279 | 1420279 | 2021-06-14 | Wyoming | West Virginia | 54109 | 2034 | 39 |
1417034 | 1417034 | 2021-06-13 | Wyoming | West Virginia | 54109 | 2033 | 39 |
1413788 | 1413788 | 2021-06-12 | Wyoming | West Virginia | 54109 | 2033 | 39 |
1410543 | 1410543 | 2021-06-11 | Wyoming | West Virginia | 54109 | 2033 | 39 |
1407298 | 1407298 | 2021-06-10 | Wyoming | West Virginia | 54109 | 2033 | 39 |
1404052 | 1404052 | 2021-06-09 | Wyoming | West Virginia | 54109 | 2032 | 39 |
1400807 | 1400807 | 2021-06-08 | Wyoming | West Virginia | 54109 | 2032 | 39 |
1397562 | 1397562 | 2021-06-07 | Wyoming | West Virginia | 54109 | 2031 | 39 |
1394315 | 1394315 | 2021-06-06 | Wyoming | West Virginia | 54109 | 2027 | 39 |
1391070 | 1391070 | 2021-06-05 | Wyoming | West Virginia | 54109 | 2027 | 39 |
1387825 | 1387825 | 2021-06-04 | Wyoming | West Virginia | 54109 | 2027 | 39 |
1384580 | 1384580 | 2021-06-03 | Wyoming | West Virginia | 54109 | 2027 | 39 |
1381334 | 1381334 | 2021-06-02 | Wyoming | West Virginia | 54109 | 2027 | 39 |
1378089 | 1378089 | 2021-06-01 | Wyoming | West Virginia | 54109 | 2026 | 39 |
1374843 | 1374843 | 2021-05-31 | Wyoming | West Virginia | 54109 | 2023 | 39 |
1371598 | 1371598 | 2021-05-30 | Wyoming | West Virginia | 54109 | 2023 | 39 |
1368352 | 1368352 | 2021-05-29 | Wyoming | West Virginia | 54109 | 2023 | 39 |
1365106 | 1365106 | 2021-05-28 | Wyoming | West Virginia | 54109 | 2023 | 39 |
1361860 | 1361860 | 2021-05-27 | Wyoming | West Virginia | 54109 | 2020 | 39 |
1358614 | 1358614 | 2021-05-26 | Wyoming | West Virginia | 54109 | 2018 | 39 |
1355368 | 1355368 | 2021-05-25 | Wyoming | West Virginia | 54109 | 2020 | 39 |
1352122 | 1352122 | 2021-05-24 | Wyoming | West Virginia | 54109 | 2019 | 39 |
1348876 | 1348876 | 2021-05-23 | Wyoming | West Virginia | 54109 | 2016 | 39 |
1345628 | 1345628 | 2021-05-22 | Wyoming | West Virginia | 54109 | 2016 | 39 |
1342380 | 1342380 | 2021-05-21 | Wyoming | West Virginia | 54109 | 2016 | 39 |
1339132 | 1339132 | 2021-05-20 | Wyoming | West Virginia | 54109 | 2012 | 39 |
1335885 | 1335885 | 2021-05-19 | Wyoming | West Virginia | 54109 | 2009 | 39 |
1332638 | 1332638 | 2021-05-18 | Wyoming | West Virginia | 54109 | 2010 | 39 |
1329391 | 1329391 | 2021-05-17 | Wyoming | West Virginia | 54109 | 2007 | 39 |
1326145 | 1326145 | 2021-05-16 | Wyoming | West Virginia | 54109 | 2007 | 39 |
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);