ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
152 rows where deaths = 48 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 |
---|---|---|---|---|---|---|---|
2291130 | 2291130 | 2022-03-09 | Hardy | West Virginia | 54031 | 4164 | 48 |
2287878 | 2287878 | 2022-03-08 | Hardy | West Virginia | 54031 | 4161 | 48 |
2284626 | 2284626 | 2022-03-07 | Hardy | West Virginia | 54031 | 4160 | 48 |
2281374 | 2281374 | 2022-03-06 | Hardy | West Virginia | 54031 | 4154 | 48 |
2278121 | 2278121 | 2022-03-05 | Hardy | West Virginia | 54031 | 4154 | 48 |
2274868 | 2274868 | 2022-03-04 | Hardy | West Virginia | 54031 | 4154 | 48 |
2271615 | 2271615 | 2022-03-03 | Hardy | West Virginia | 54031 | 4153 | 48 |
2268363 | 2268363 | 2022-03-02 | Hardy | West Virginia | 54031 | 4151 | 48 |
2268392 | 2268392 | 2022-03-02 | Summers | West Virginia | 54089 | 2749 | 48 |
2265110 | 2265110 | 2022-03-01 | Hardy | West Virginia | 54031 | 4148 | 48 |
2261860 | 2261860 | 2022-02-28 | Hardy | West Virginia | 54031 | 4141 | 48 |
2258609 | 2258609 | 2022-02-27 | Hardy | West Virginia | 54031 | 4137 | 48 |
2255358 | 2255358 | 2022-02-26 | Hardy | West Virginia | 54031 | 4137 | 48 |
2252107 | 2252107 | 2022-02-25 | Hardy | West Virginia | 54031 | 4137 | 48 |
2248856 | 2248856 | 2022-02-24 | Hardy | West Virginia | 54031 | 4140 | 48 |
2245605 | 2245605 | 2022-02-23 | Hardy | West Virginia | 54031 | 4134 | 48 |
2242354 | 2242354 | 2022-02-22 | Hardy | West Virginia | 54031 | 4134 | 48 |
2089481 | 2089481 | 2022-01-06 | Grant | West Virginia | 54023 | 2832 | 48 |
2014754 | 2014754 | 2021-12-14 | Taylor | West Virginia | 54091 | 2755 | 48 |
2011503 | 2011503 | 2021-12-13 | Taylor | West Virginia | 54091 | 2748 | 48 |
1975734 | 1975734 | 2021-12-02 | Morgan | West Virginia | 54065 | 2387 | 48 |
1972485 | 1972485 | 2021-12-01 | Morgan | West Virginia | 54065 | 2363 | 48 |
1969235 | 1969235 | 2021-11-30 | Morgan | West Virginia | 54065 | 2347 | 48 |
1965985 | 1965985 | 2021-11-29 | Morgan | West Virginia | 54065 | 2348 | 48 |
1962733 | 1962733 | 2021-11-28 | Morgan | West Virginia | 54065 | 2293 | 48 |
1959482 | 1959482 | 2021-11-27 | Morgan | West Virginia | 54065 | 2293 | 48 |
1956231 | 1956231 | 2021-11-26 | Morgan | West Virginia | 54065 | 2293 | 48 |
1952980 | 1952980 | 2021-11-25 | Morgan | West Virginia | 54065 | 2293 | 48 |
1949729 | 1949729 | 2021-11-24 | Morgan | West Virginia | 54065 | 2293 | 48 |
1946478 | 1946478 | 2021-11-23 | Morgan | West Virginia | 54065 | 2281 | 48 |
1943227 | 1943227 | 2021-11-22 | Morgan | West Virginia | 54065 | 2274 | 48 |
1939977 | 1939977 | 2021-11-21 | Morgan | West Virginia | 54065 | 2270 | 48 |
1936727 | 1936727 | 2021-11-20 | Morgan | West Virginia | 54065 | 2263 | 48 |
1933477 | 1933477 | 2021-11-19 | Morgan | West Virginia | 54065 | 2251 | 48 |
1930225 | 1930225 | 2021-11-18 | Morgan | West Virginia | 54065 | 2238 | 48 |
1926975 | 1926975 | 2021-11-17 | Morgan | West Virginia | 54065 | 2226 | 48 |
1923714 | 1923714 | 2021-11-16 | Lincoln | West Virginia | 54043 | 3126 | 48 |
1923725 | 1923725 | 2021-11-16 | Morgan | West Virginia | 54065 | 2214 | 48 |
1920476 | 1920476 | 2021-11-15 | Morgan | West Virginia | 54065 | 2209 | 48 |
1871733 | 1871733 | 2021-10-31 | Nicholas | West Virginia | 54067 | 3735 | 48 |
1868484 | 1868484 | 2021-10-30 | Nicholas | West Virginia | 54067 | 3724 | 48 |
1865235 | 1865235 | 2021-10-29 | Nicholas | West Virginia | 54067 | 3703 | 48 |
1861986 | 1861986 | 2021-10-28 | Nicholas | West Virginia | 54067 | 3673 | 48 |
1858717 | 1858717 | 2021-10-27 | Hampshire | West Virginia | 54027 | 3200 | 48 |
1858745 | 1858745 | 2021-10-27 | Randolph | West Virginia | 54083 | 5077 | 48 |
1855468 | 1855468 | 2021-10-26 | Hampshire | West Virginia | 54027 | 3180 | 48 |
1852219 | 1852219 | 2021-10-25 | Hampshire | West Virginia | 54027 | 3159 | 48 |
1771000 | 1771000 | 2021-09-30 | Mason | West Virginia | 54053 | 3271 | 48 |
1767780 | 1767780 | 2021-09-29 | Wyoming | West Virginia | 54109 | 3228 | 48 |
1764531 | 1764531 | 2021-09-28 | Wyoming | West Virginia | 54109 | 3219 | 48 |
1761282 | 1761282 | 2021-09-27 | Wyoming | West Virginia | 54109 | 3213 | 48 |
1719020 | 1719020 | 2021-09-14 | Mingo | West Virginia | 54059 | 3662 | 48 |
1715772 | 1715772 | 2021-09-13 | Mingo | West Virginia | 54059 | 3623 | 48 |
1689808 | 1689808 | 2021-09-05 | Wayne | West Virginia | 54099 | 3956 | 48 |
1686558 | 1686558 | 2021-09-04 | Wayne | West Virginia | 54099 | 3923 | 48 |
1683308 | 1683308 | 2021-09-03 | Wayne | West Virginia | 54099 | 3872 | 48 |
1680057 | 1680057 | 2021-09-02 | Wayne | West Virginia | 54099 | 3827 | 48 |
1676809 | 1676809 | 2021-09-01 | Wayne | West Virginia | 54099 | 3797 | 48 |
1673562 | 1673562 | 2021-08-31 | Wayne | West Virginia | 54099 | 3760 | 48 |
1670303 | 1670303 | 2021-08-30 | Preston | West Virginia | 54077 | 3242 | 48 |
1670314 | 1670314 | 2021-08-30 | Wayne | West Virginia | 54099 | 3731 | 48 |
1667056 | 1667056 | 2021-08-29 | Preston | West Virginia | 54077 | 3227 | 48 |
1667067 | 1667067 | 2021-08-29 | Wayne | West Virginia | 54099 | 3722 | 48 |
1663808 | 1663808 | 2021-08-28 | Preston | West Virginia | 54077 | 3177 | 48 |
1663819 | 1663819 | 2021-08-28 | Wayne | West Virginia | 54099 | 3668 | 48 |
1660560 | 1660560 | 2021-08-27 | Preston | West Virginia | 54077 | 3177 | 48 |
1660571 | 1660571 | 2021-08-27 | Wayne | West Virginia | 54099 | 3668 | 48 |
1657312 | 1657312 | 2021-08-26 | Preston | West Virginia | 54077 | 3161 | 48 |
1657323 | 1657323 | 2021-08-26 | Wayne | West Virginia | 54099 | 3649 | 48 |
1654064 | 1654064 | 2021-08-25 | Preston | West Virginia | 54077 | 3137 | 48 |
1654075 | 1654075 | 2021-08-25 | Wayne | West Virginia | 54099 | 3620 | 48 |
1650818 | 1650818 | 2021-08-24 | Preston | West Virginia | 54077 | 3114 | 48 |
1650829 | 1650829 | 2021-08-24 | Wayne | West Virginia | 54099 | 3602 | 48 |
1647569 | 1647569 | 2021-08-23 | Preston | West Virginia | 54077 | 3100 | 48 |
1647580 | 1647580 | 2021-08-23 | Wayne | West Virginia | 54099 | 3589 | 48 |
1309881 | 1309881 | 2021-05-11 | Marion | West Virginia | 54049 | 4433 | 48 |
1306635 | 1306635 | 2021-05-10 | Marion | West Virginia | 54049 | 4421 | 48 |
1303389 | 1303389 | 2021-05-09 | Marion | West Virginia | 54049 | 4416 | 48 |
1300142 | 1300142 | 2021-05-08 | Marion | West Virginia | 54049 | 4399 | 48 |
1296895 | 1296895 | 2021-05-07 | Marion | West Virginia | 54049 | 4383 | 48 |
1293649 | 1293649 | 2021-05-06 | Marion | West Virginia | 54049 | 4368 | 48 |
1283906 | 1283906 | 2021-05-03 | Jefferson | West Virginia | 54037 | 4531 | 48 |
1280659 | 1280659 | 2021-05-02 | Jefferson | West Virginia | 54037 | 4526 | 48 |
1277412 | 1277412 | 2021-05-01 | Jefferson | West Virginia | 54037 | 4513 | 48 |
1274165 | 1274165 | 2021-04-30 | Jefferson | West Virginia | 54037 | 4507 | 48 |
1270918 | 1270918 | 2021-04-29 | Jefferson | West Virginia | 54037 | 4496 | 48 |
1267671 | 1267671 | 2021-04-28 | Jefferson | West Virginia | 54037 | 4477 | 48 |
1264424 | 1264424 | 2021-04-27 | Jefferson | West Virginia | 54037 | 4464 | 48 |
1222210 | 1222210 | 2021-04-14 | Jefferson | West Virginia | 54037 | 4281 | 48 |
1222215 | 1222215 | 2021-04-14 | Marion | West Virginia | 54049 | 4091 | 48 |
1218962 | 1218962 | 2021-04-13 | Jefferson | West Virginia | 54037 | 4262 | 48 |
1218967 | 1218967 | 2021-04-13 | Marion | West Virginia | 54049 | 4076 | 48 |
1215714 | 1215714 | 2021-04-12 | Jefferson | West Virginia | 54037 | 4242 | 48 |
1215719 | 1215719 | 2021-04-12 | Marion | West Virginia | 54049 | 4067 | 48 |
1212467 | 1212467 | 2021-04-11 | Jefferson | West Virginia | 54037 | 4226 | 48 |
1212472 | 1212472 | 2021-04-11 | Marion | West Virginia | 54049 | 4054 | 48 |
1209218 | 1209218 | 2021-04-10 | Jefferson | West Virginia | 54037 | 4208 | 48 |
1209223 | 1209223 | 2021-04-10 | Marion | West Virginia | 54049 | 4038 | 48 |
1205970 | 1205970 | 2021-04-09 | Jefferson | West Virginia | 54037 | 4198 | 48 |
1205975 | 1205975 | 2021-04-09 | Marion | West Virginia | 54049 | 4025 | 48 |
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);