ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
127 rows where deaths = 81 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 |
---|---|---|---|---|---|---|---|
2466870 | 2466870 | 2022-05-02 | Lincoln | West Virginia | 54043 | 5559 | 81 |
2463615 | 2463615 | 2022-05-01 | Lincoln | West Virginia | 54043 | 5554 | 81 |
2460359 | 2460359 | 2022-04-30 | Lincoln | West Virginia | 54043 | 5554 | 81 |
2457103 | 2457103 | 2022-04-29 | Lincoln | West Virginia | 54043 | 5554 | 81 |
2453847 | 2453847 | 2022-04-28 | Lincoln | West Virginia | 54043 | 5549 | 81 |
2450591 | 2450591 | 2022-04-27 | Lincoln | West Virginia | 54043 | 5547 | 81 |
2447335 | 2447335 | 2022-04-26 | Lincoln | West Virginia | 54043 | 5542 | 81 |
2444079 | 2444079 | 2022-04-25 | Lincoln | West Virginia | 54043 | 5536 | 81 |
2440823 | 2440823 | 2022-04-24 | Lincoln | West Virginia | 54043 | 5532 | 81 |
2437567 | 2437567 | 2022-04-23 | Lincoln | West Virginia | 54043 | 5532 | 81 |
2434311 | 2434311 | 2022-04-22 | Lincoln | West Virginia | 54043 | 5532 | 81 |
2431055 | 2431055 | 2022-04-21 | Lincoln | West Virginia | 54043 | 5531 | 81 |
2427799 | 2427799 | 2022-04-20 | Lincoln | West Virginia | 54043 | 5530 | 81 |
2424543 | 2424543 | 2022-04-19 | Lincoln | West Virginia | 54043 | 5526 | 81 |
2421287 | 2421287 | 2022-04-18 | Lincoln | West Virginia | 54043 | 5525 | 81 |
2418031 | 2418031 | 2022-04-17 | Lincoln | West Virginia | 54043 | 5524 | 81 |
2414775 | 2414775 | 2022-04-16 | Lincoln | West Virginia | 54043 | 5524 | 81 |
2411519 | 2411519 | 2022-04-15 | Lincoln | West Virginia | 54043 | 5524 | 81 |
2408263 | 2408263 | 2022-04-14 | Lincoln | West Virginia | 54043 | 5523 | 81 |
2339958 | 2339958 | 2022-03-24 | Wetzel | West Virginia | 54103 | 4313 | 81 |
2336705 | 2336705 | 2022-03-23 | Wetzel | West Virginia | 54103 | 4313 | 81 |
2333441 | 2333441 | 2022-03-22 | Randolph | West Virginia | 54083 | 9350 | 81 |
2333451 | 2333451 | 2022-03-22 | Wetzel | West Virginia | 54103 | 4315 | 81 |
2330187 | 2330187 | 2022-03-21 | Randolph | West Virginia | 54083 | 9349 | 81 |
2330197 | 2330197 | 2022-03-21 | Wetzel | West Virginia | 54103 | 4315 | 81 |
2326935 | 2326935 | 2022-03-20 | Randolph | West Virginia | 54083 | 9344 | 81 |
2326945 | 2326945 | 2022-03-20 | Wetzel | West Virginia | 54103 | 4313 | 81 |
2323682 | 2323682 | 2022-03-19 | Randolph | West Virginia | 54083 | 9344 | 81 |
2323692 | 2323692 | 2022-03-19 | Wetzel | West Virginia | 54103 | 4313 | 81 |
2320428 | 2320428 | 2022-03-18 | Randolph | West Virginia | 54083 | 9344 | 81 |
2320438 | 2320438 | 2022-03-18 | Wetzel | West Virginia | 54103 | 4313 | 81 |
2317174 | 2317174 | 2022-03-17 | Randolph | West Virginia | 54083 | 9340 | 81 |
2317184 | 2317184 | 2022-03-17 | Wetzel | West Virginia | 54103 | 4308 | 81 |
2313931 | 2313931 | 2022-03-16 | Wetzel | West Virginia | 54103 | 4304 | 81 |
2310678 | 2310678 | 2022-03-15 | Wetzel | West Virginia | 54103 | 4300 | 81 |
2307425 | 2307425 | 2022-03-14 | Wetzel | West Virginia | 54103 | 4297 | 81 |
2304143 | 2304143 | 2022-03-13 | Lewis | West Virginia | 54041 | 5273 | 81 |
2304174 | 2304174 | 2022-03-13 | Wetzel | West Virginia | 54103 | 4287 | 81 |
2300891 | 2300891 | 2022-03-12 | Lewis | West Virginia | 54041 | 5273 | 81 |
2300922 | 2300922 | 2022-03-12 | Wetzel | West Virginia | 54103 | 4287 | 81 |
2297639 | 2297639 | 2022-03-11 | Lewis | West Virginia | 54041 | 5273 | 81 |
2297670 | 2297670 | 2022-03-11 | Wetzel | West Virginia | 54103 | 4287 | 81 |
2294418 | 2294418 | 2022-03-10 | Wetzel | West Virginia | 54103 | 4282 | 81 |
2271648 | 2271648 | 2022-03-03 | Upshur | West Virginia | 54097 | 6733 | 81 |
2268396 | 2268396 | 2022-03-02 | Upshur | West Virginia | 54097 | 6723 | 81 |
2265143 | 2265143 | 2022-03-01 | Upshur | West Virginia | 54097 | 6677 | 81 |
2190339 | 2190339 | 2022-02-06 | Nicholas | West Virginia | 54067 | 6623 | 81 |
2187086 | 2187086 | 2022-02-05 | Nicholas | West Virginia | 54067 | 6600 | 81 |
2183833 | 2183833 | 2022-02-04 | Nicholas | West Virginia | 54067 | 6540 | 81 |
2157827 | 2157827 | 2022-01-27 | Wyoming | West Virginia | 54109 | 5864 | 81 |
2014713 | 2014713 | 2021-12-14 | Brooke | West Virginia | 54009 | 3514 | 81 |
2011462 | 2011462 | 2021-12-13 | Brooke | West Virginia | 54009 | 3506 | 81 |
2008211 | 2008211 | 2021-12-12 | Brooke | West Virginia | 54009 | 3503 | 81 |
2004960 | 2004960 | 2021-12-11 | Brooke | West Virginia | 54009 | 3499 | 81 |
2001709 | 2001709 | 2021-12-10 | Brooke | West Virginia | 54009 | 3477 | 81 |
1878227 | 1878227 | 2021-11-02 | Mingo | West Virginia | 54059 | 4652 | 81 |
1874978 | 1874978 | 2021-11-01 | Mingo | West Virginia | 54059 | 4640 | 81 |
1871729 | 1871729 | 2021-10-31 | Mingo | West Virginia | 54059 | 4637 | 81 |
1868480 | 1868480 | 2021-10-30 | Mingo | West Virginia | 54059 | 4636 | 81 |
1865231 | 1865231 | 2021-10-29 | Mingo | West Virginia | 54059 | 4623 | 81 |
1861982 | 1861982 | 2021-10-28 | Mingo | West Virginia | 54059 | 4609 | 81 |
1858733 | 1858733 | 2021-10-27 | Mingo | West Virginia | 54059 | 4596 | 81 |
1835996 | 1835996 | 2021-10-20 | Preston | West Virginia | 54077 | 5005 | 81 |
1650804 | 1650804 | 2021-08-24 | Marshall | West Virginia | 54051 | 3940 | 81 |
1647555 | 1647555 | 2021-08-23 | Marshall | West Virginia | 54051 | 3928 | 81 |
1644306 | 1644306 | 2021-08-22 | Marshall | West Virginia | 54051 | 3885 | 81 |
1641056 | 1641056 | 2021-08-21 | Marshall | West Virginia | 54051 | 3885 | 81 |
1637806 | 1637806 | 2021-08-20 | Marshall | West Virginia | 54051 | 3885 | 81 |
1634556 | 1634556 | 2021-08-19 | Marshall | West Virginia | 54051 | 3867 | 81 |
1631308 | 1631308 | 2021-08-18 | Marshall | West Virginia | 54051 | 3854 | 81 |
1628061 | 1628061 | 2021-08-17 | Marshall | West Virginia | 54051 | 3829 | 81 |
1494896 | 1494896 | 2021-07-07 | Harrison | West Virginia | 54033 | 6211 | 81 |
1491649 | 1491649 | 2021-07-06 | Harrison | West Virginia | 54033 | 6209 | 81 |
1488402 | 1488402 | 2021-07-05 | Harrison | West Virginia | 54033 | 6198 | 81 |
1485155 | 1485155 | 2021-07-04 | Harrison | West Virginia | 54033 | 6198 | 81 |
1481909 | 1481909 | 2021-07-03 | Harrison | West Virginia | 54033 | 6198 | 81 |
1478662 | 1478662 | 2021-07-02 | Harrison | West Virginia | 54033 | 6198 | 81 |
1475416 | 1475416 | 2021-07-01 | Harrison | West Virginia | 54033 | 6193 | 81 |
1472170 | 1472170 | 2021-06-30 | Harrison | West Virginia | 54033 | 6193 | 81 |
1468925 | 1468925 | 2021-06-29 | Harrison | West Virginia | 54033 | 6192 | 81 |
1465680 | 1465680 | 2021-06-28 | Harrison | West Virginia | 54033 | 6191 | 81 |
1462435 | 1462435 | 2021-06-27 | Harrison | West Virginia | 54033 | 6183 | 81 |
1459190 | 1459190 | 2021-06-26 | Harrison | West Virginia | 54033 | 6183 | 81 |
1455945 | 1455945 | 2021-06-25 | Harrison | West Virginia | 54033 | 6183 | 81 |
1452700 | 1452700 | 2021-06-24 | Harrison | West Virginia | 54033 | 6181 | 81 |
1449454 | 1449454 | 2021-06-23 | Harrison | West Virginia | 54033 | 6177 | 81 |
1446209 | 1446209 | 2021-06-22 | Harrison | West Virginia | 54033 | 6170 | 81 |
1283922 | 1283922 | 2021-05-03 | Ohio | West Virginia | 54069 | 4150 | 81 |
1280675 | 1280675 | 2021-05-02 | Ohio | West Virginia | 54069 | 4141 | 81 |
1277428 | 1277428 | 2021-05-01 | Ohio | West Virginia | 54069 | 4134 | 81 |
1274181 | 1274181 | 2021-04-30 | Ohio | West Virginia | 54069 | 4128 | 81 |
1267693 | 1267693 | 2021-04-28 | Raleigh | West Virginia | 54081 | 6477 | 81 |
1231963 | 1231963 | 2021-04-17 | Mineral | West Virginia | 54057 | 2760 | 81 |
1228715 | 1228715 | 2021-04-16 | Mineral | West Virginia | 54057 | 2751 | 81 |
1225467 | 1225467 | 2021-04-15 | Mineral | West Virginia | 54057 | 2743 | 81 |
1222220 | 1222220 | 2021-04-14 | Mineral | West Virginia | 54057 | 2742 | 81 |
1218972 | 1218972 | 2021-04-13 | Mineral | West Virginia | 54057 | 2728 | 81 |
1215724 | 1215724 | 2021-04-12 | Mineral | West Virginia | 54057 | 2720 | 81 |
1212477 | 1212477 | 2021-04-11 | Mineral | West Virginia | 54057 | 2714 | 81 |
1209228 | 1209228 | 2021-04-10 | Mineral | West Virginia | 54057 | 2711 | 81 |
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);