ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
195 rows where deaths = 87 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 |
---|---|---|---|---|---|---|---|
2427819 | 2427819 | 2022-04-20 | Randolph | West Virginia | 54083 | 9424 | 87 |
2424563 | 2424563 | 2022-04-19 | Randolph | West Virginia | 54083 | 9418 | 87 |
2421307 | 2421307 | 2022-04-18 | Randolph | West Virginia | 54083 | 9412 | 87 |
2418051 | 2418051 | 2022-04-17 | Randolph | West Virginia | 54083 | 9403 | 87 |
2414795 | 2414795 | 2022-04-16 | Randolph | West Virginia | 54083 | 9403 | 87 |
2411539 | 2411539 | 2022-04-15 | Randolph | West Virginia | 54083 | 9403 | 87 |
2375710 | 2375710 | 2022-04-04 | Lewis | West Virginia | 54041 | 5311 | 87 |
2372458 | 2372458 | 2022-04-03 | Lewis | West Virginia | 54041 | 5312 | 87 |
2369205 | 2369205 | 2022-04-02 | Lewis | West Virginia | 54041 | 5312 | 87 |
2365952 | 2365952 | 2022-04-01 | Lewis | West Virginia | 54041 | 5312 | 87 |
2362699 | 2362699 | 2022-03-31 | Lewis | West Virginia | 54041 | 5307 | 87 |
2359445 | 2359445 | 2022-03-30 | Lewis | West Virginia | 54041 | 5308 | 87 |
2356191 | 2356191 | 2022-03-29 | Lewis | West Virginia | 54041 | 5306 | 87 |
2352938 | 2352938 | 2022-03-28 | Lewis | West Virginia | 54041 | 5303 | 87 |
2349686 | 2349686 | 2022-03-27 | Lewis | West Virginia | 54041 | 5302 | 87 |
2346433 | 2346433 | 2022-03-26 | Lewis | West Virginia | 54041 | 5302 | 87 |
2343180 | 2343180 | 2022-03-25 | Lewis | West Virginia | 54041 | 5302 | 87 |
2339927 | 2339927 | 2022-03-24 | Lewis | West Virginia | 54041 | 5299 | 87 |
2336674 | 2336674 | 2022-03-23 | Lewis | West Virginia | 54041 | 5298 | 87 |
2333420 | 2333420 | 2022-03-22 | Lewis | West Virginia | 54041 | 5298 | 87 |
2330166 | 2330166 | 2022-03-21 | Lewis | West Virginia | 54041 | 5297 | 87 |
2326914 | 2326914 | 2022-03-20 | Lewis | West Virginia | 54041 | 5293 | 87 |
2323661 | 2323661 | 2022-03-19 | Lewis | West Virginia | 54041 | 5293 | 87 |
2320407 | 2320407 | 2022-03-18 | Lewis | West Virginia | 54041 | 5293 | 87 |
2268373 | 2268373 | 2022-03-02 | Mason | West Virginia | 54053 | 6544 | 87 |
2265120 | 2265120 | 2022-03-01 | Mason | West Virginia | 54053 | 6532 | 87 |
2261870 | 2261870 | 2022-02-28 | Mason | West Virginia | 54053 | 6520 | 87 |
2258619 | 2258619 | 2022-02-27 | Mason | West Virginia | 54053 | 6493 | 87 |
2255368 | 2255368 | 2022-02-26 | Mason | West Virginia | 54053 | 6493 | 87 |
2252117 | 2252117 | 2022-02-25 | Mason | West Virginia | 54053 | 6493 | 87 |
2248866 | 2248866 | 2022-02-24 | Mason | West Virginia | 54053 | 6470 | 87 |
2245615 | 2245615 | 2022-02-23 | Mason | West Virginia | 54053 | 6450 | 87 |
2242364 | 2242364 | 2022-02-22 | Mason | West Virginia | 54053 | 6442 | 87 |
2239113 | 2239113 | 2022-02-21 | Mason | West Virginia | 54053 | 6430 | 87 |
2239121 | 2239121 | 2022-02-21 | Nicholas | West Virginia | 54067 | 7008 | 87 |
2235862 | 2235862 | 2022-02-20 | Mason | West Virginia | 54053 | 6374 | 87 |
2235870 | 2235870 | 2022-02-20 | Nicholas | West Virginia | 54067 | 6958 | 87 |
2232611 | 2232611 | 2022-02-19 | Mason | West Virginia | 54053 | 6374 | 87 |
2232619 | 2232619 | 2022-02-19 | Nicholas | West Virginia | 54067 | 6958 | 87 |
2229360 | 2229360 | 2022-02-18 | Mason | West Virginia | 54053 | 6374 | 87 |
2229368 | 2229368 | 2022-02-18 | Nicholas | West Virginia | 54067 | 6958 | 87 |
2226117 | 2226117 | 2022-02-17 | Nicholas | West Virginia | 54067 | 6940 | 87 |
2216386 | 2216386 | 2022-02-14 | Wyoming | West Virginia | 54109 | 6593 | 87 |
2213135 | 2213135 | 2022-02-13 | Wyoming | West Virginia | 54109 | 6576 | 87 |
2209882 | 2209882 | 2022-02-12 | Wyoming | West Virginia | 54109 | 6535 | 87 |
2206629 | 2206629 | 2022-02-11 | Wyoming | West Virginia | 54109 | 6499 | 87 |
2203376 | 2203376 | 2022-02-10 | Wyoming | West Virginia | 54109 | 6456 | 87 |
2200122 | 2200122 | 2022-02-09 | Wyoming | West Virginia | 54109 | 6413 | 87 |
2196868 | 2196868 | 2022-02-08 | Wyoming | West Virginia | 54109 | 6353 | 87 |
2125242 | 2125242 | 2022-01-17 | Brooke | West Virginia | 54009 | 4259 | 87 |
2121990 | 2121990 | 2022-01-16 | Brooke | West Virginia | 54009 | 4204 | 87 |
2118738 | 2118738 | 2022-01-15 | Brooke | West Virginia | 54009 | 4184 | 87 |
2115486 | 2115486 | 2022-01-14 | Brooke | West Virginia | 54009 | 4158 | 87 |
2112234 | 2112234 | 2022-01-13 | Brooke | West Virginia | 54009 | 4116 | 87 |
2108982 | 2108982 | 2022-01-12 | Brooke | West Virginia | 54009 | 4074 | 87 |
2105731 | 2105731 | 2022-01-11 | Brooke | West Virginia | 54009 | 4040 | 87 |
2102480 | 2102480 | 2022-01-10 | Brooke | West Virginia | 54009 | 3989 | 87 |
2099229 | 2099229 | 2022-01-09 | Brooke | West Virginia | 54009 | 3962 | 87 |
2095978 | 2095978 | 2022-01-08 | Brooke | West Virginia | 54009 | 3943 | 87 |
2092726 | 2092726 | 2022-01-07 | Brooke | West Virginia | 54009 | 3916 | 87 |
1917211 | 1917211 | 2021-11-14 | Jackson | West Virginia | 54035 | 4121 | 87 |
1913961 | 1913961 | 2021-11-13 | Jackson | West Virginia | 54035 | 4111 | 87 |
1910711 | 1910711 | 2021-11-12 | Jackson | West Virginia | 54035 | 4098 | 87 |
1907462 | 1907462 | 2021-11-11 | Jackson | West Virginia | 54035 | 4090 | 87 |
1904213 | 1904213 | 2021-11-10 | Jackson | West Virginia | 54035 | 4075 | 87 |
1900963 | 1900963 | 2021-11-09 | Jackson | West Virginia | 54035 | 4059 | 87 |
1897713 | 1897713 | 2021-11-08 | Jackson | West Virginia | 54035 | 4054 | 87 |
1894463 | 1894463 | 2021-11-07 | Jackson | West Virginia | 54035 | 4050 | 87 |
1894484 | 1894484 | 2021-11-07 | Preston | West Virginia | 54077 | 5386 | 87 |
1891213 | 1891213 | 2021-11-06 | Jackson | West Virginia | 54035 | 4043 | 87 |
1891234 | 1891234 | 2021-11-06 | Preston | West Virginia | 54077 | 5379 | 87 |
1887963 | 1887963 | 2021-11-05 | Jackson | West Virginia | 54035 | 4033 | 87 |
1887984 | 1887984 | 2021-11-05 | Preston | West Virginia | 54077 | 5343 | 87 |
1884713 | 1884713 | 2021-11-04 | Jackson | West Virginia | 54035 | 4016 | 87 |
1881464 | 1881464 | 2021-11-03 | Jackson | West Virginia | 54035 | 4006 | 87 |
1878215 | 1878215 | 2021-11-02 | Jackson | West Virginia | 54035 | 3999 | 87 |
1874966 | 1874966 | 2021-11-01 | Jackson | West Virginia | 54035 | 3988 | 87 |
1874967 | 1874967 | 2021-11-01 | Jefferson | West Virginia | 54037 | 6829 | 87 |
1816476 | 1816476 | 2021-10-14 | Greenbrier | West Virginia | 54025 | 4713 | 87 |
1696272 | 1696272 | 2021-09-07 | Harrison | West Virginia | 54033 | 7488 | 87 |
1689783 | 1689783 | 2021-09-05 | Marshall | West Virginia | 54051 | 4186 | 87 |
1686533 | 1686533 | 2021-09-04 | Marshall | West Virginia | 54051 | 4165 | 87 |
1634566 | 1634566 | 2021-08-19 | Ohio | West Virginia | 54069 | 4626 | 87 |
1631318 | 1631318 | 2021-08-18 | Ohio | West Virginia | 54069 | 4607 | 87 |
1628071 | 1628071 | 2021-08-17 | Ohio | West Virginia | 54069 | 4584 | 87 |
1624824 | 1624824 | 2021-08-16 | Ohio | West Virginia | 54069 | 4539 | 87 |
1621577 | 1621577 | 2021-08-15 | Ohio | West Virginia | 54069 | 4512 | 87 |
1618329 | 1618329 | 2021-08-14 | Ohio | West Virginia | 54069 | 4512 | 87 |
1615081 | 1615081 | 2021-08-13 | Ohio | West Virginia | 54069 | 4512 | 87 |
1611832 | 1611832 | 2021-08-12 | Ohio | West Virginia | 54069 | 4508 | 87 |
1608585 | 1608585 | 2021-08-11 | Ohio | West Virginia | 54069 | 4487 | 87 |
1605336 | 1605336 | 2021-08-10 | Ohio | West Virginia | 54069 | 4473 | 87 |
1602086 | 1602086 | 2021-08-09 | Ohio | West Virginia | 54069 | 4462 | 87 |
1598838 | 1598838 | 2021-08-08 | Ohio | West Virginia | 54069 | 4441 | 87 |
1595589 | 1595589 | 2021-08-07 | Ohio | West Virginia | 54069 | 4441 | 87 |
1592340 | 1592340 | 2021-08-06 | Ohio | West Virginia | 54069 | 4441 | 87 |
1589091 | 1589091 | 2021-08-05 | Ohio | West Virginia | 54069 | 4432 | 87 |
1585842 | 1585842 | 2021-08-04 | Ohio | West Virginia | 54069 | 4420 | 87 |
1582592 | 1582592 | 2021-08-03 | Ohio | West Virginia | 54069 | 4409 | 87 |
1579342 | 1579342 | 2021-08-02 | Ohio | West Virginia | 54069 | 4403 | 87 |
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);