ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
102 rows where deaths = 129 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 |
---|---|---|---|---|---|---|---|
2378962 | 2378962 | 2022-04-05 | Jefferson | West Virginia | 54037 | 14187 | 129 |
2291153 | 2291153 | 2022-03-09 | Preston | West Virginia | 54077 | 9154 | 129 |
2268365 | 2268365 | 2022-03-02 | Jackson | West Virginia | 54035 | 6796 | 129 |
2268366 | 2268366 | 2022-03-02 | Jefferson | West Virginia | 54037 | 14070 | 129 |
2265112 | 2265112 | 2022-03-01 | Jackson | West Virginia | 54035 | 6783 | 129 |
2265113 | 2265113 | 2022-03-01 | Jefferson | West Virginia | 54037 | 14058 | 129 |
2261862 | 2261862 | 2022-02-28 | Jackson | West Virginia | 54035 | 6780 | 129 |
2261863 | 2261863 | 2022-02-28 | Jefferson | West Virginia | 54037 | 14049 | 129 |
2258611 | 2258611 | 2022-02-27 | Jackson | West Virginia | 54035 | 6763 | 129 |
2258612 | 2258612 | 2022-02-27 | Jefferson | West Virginia | 54037 | 14022 | 129 |
2255360 | 2255360 | 2022-02-26 | Jackson | West Virginia | 54035 | 6763 | 129 |
2255361 | 2255361 | 2022-02-26 | Jefferson | West Virginia | 54037 | 14022 | 129 |
2252109 | 2252109 | 2022-02-25 | Jackson | West Virginia | 54035 | 6763 | 129 |
2252110 | 2252110 | 2022-02-25 | Jefferson | West Virginia | 54037 | 14022 | 129 |
2248858 | 2248858 | 2022-02-24 | Jackson | West Virginia | 54035 | 6754 | 129 |
2135011 | 2135011 | 2022-01-20 | Hancock | West Virginia | 54029 | 5947 | 129 |
2131759 | 2131759 | 2022-01-19 | Hancock | West Virginia | 54029 | 5905 | 129 |
2128505 | 2128505 | 2022-01-18 | Hancock | West Virginia | 54029 | 5884 | 129 |
2076497 | 2076497 | 2022-01-02 | Ohio | West Virginia | 54069 | 7425 | 129 |
2073246 | 2073246 | 2022-01-01 | Ohio | West Virginia | 54069 | 7425 | 129 |
2069995 | 2069995 | 2021-12-31 | Ohio | West Virginia | 54069 | 7425 | 129 |
2066744 | 2066744 | 2021-12-30 | Ohio | West Virginia | 54069 | 7425 | 129 |
2063494 | 2063494 | 2021-12-29 | Ohio | West Virginia | 54069 | 7377 | 129 |
2060244 | 2060244 | 2021-12-28 | Ohio | West Virginia | 54069 | 7331 | 129 |
2014733 | 2014733 | 2021-12-14 | Marshall | West Virginia | 54051 | 5893 | 129 |
2011482 | 2011482 | 2021-12-13 | Marshall | West Virginia | 54051 | 5876 | 129 |
2011486 | 2011486 | 2021-12-13 | Mineral | West Virginia | 54057 | 5142 | 129 |
2008235 | 2008235 | 2021-12-12 | Mineral | West Virginia | 54057 | 5134 | 129 |
2004984 | 2004984 | 2021-12-11 | Mineral | West Virginia | 54057 | 5124 | 129 |
2001733 | 2001733 | 2021-12-10 | Mineral | West Virginia | 54057 | 5108 | 129 |
1985475 | 1985475 | 2021-12-05 | Marion | West Virginia | 54049 | 9155 | 129 |
1982225 | 1982225 | 2021-12-04 | Marion | West Virginia | 54049 | 9131 | 129 |
1978975 | 1978975 | 2021-12-03 | Marion | West Virginia | 54049 | 9092 | 129 |
1975725 | 1975725 | 2021-12-02 | Marion | West Virginia | 54049 | 9048 | 129 |
1926982 | 1926982 | 2021-11-17 | Putnam | West Virginia | 54079 | 9395 | 129 |
1832739 | 1832739 | 2021-10-19 | Monongalia | West Virginia | 54061 | 12669 | 129 |
1829490 | 1829490 | 2021-10-18 | Monongalia | West Virginia | 54061 | 12612 | 129 |
1826241 | 1826241 | 2021-10-17 | Monongalia | West Virginia | 54061 | 12521 | 129 |
1822992 | 1822992 | 2021-10-16 | Monongalia | West Virginia | 54061 | 12476 | 129 |
1819743 | 1819743 | 2021-10-15 | Monongalia | West Virginia | 54061 | 12405 | 129 |
1800240 | 1800240 | 2021-10-09 | Logan | West Virginia | 54045 | 5053 | 129 |
1673540 | 1673540 | 2021-08-31 | Mercer | West Virginia | 54055 | 6080 | 129 |
1670292 | 1670292 | 2021-08-30 | Mercer | West Virginia | 54055 | 6041 | 129 |
1667045 | 1667045 | 2021-08-29 | Mercer | West Virginia | 54055 | 5994 | 129 |
1663797 | 1663797 | 2021-08-28 | Mercer | West Virginia | 54055 | 5873 | 129 |
1660549 | 1660549 | 2021-08-27 | Mercer | West Virginia | 54055 | 5873 | 129 |
1657301 | 1657301 | 2021-08-26 | Mercer | West Virginia | 54055 | 5824 | 129 |
1654053 | 1654053 | 2021-08-25 | Mercer | West Virginia | 54055 | 5779 | 129 |
1650807 | 1650807 | 2021-08-24 | Mercer | West Virginia | 54055 | 5751 | 129 |
1647558 | 1647558 | 2021-08-23 | Mercer | West Virginia | 54055 | 5727 | 129 |
1644309 | 1644309 | 2021-08-22 | Mercer | West Virginia | 54055 | 5632 | 129 |
1641059 | 1641059 | 2021-08-21 | Mercer | West Virginia | 54055 | 5632 | 129 |
1637809 | 1637809 | 2021-08-20 | Mercer | West Virginia | 54055 | 5632 | 129 |
1634559 | 1634559 | 2021-08-19 | Mercer | West Virginia | 54055 | 5601 | 129 |
1631311 | 1631311 | 2021-08-18 | Mercer | West Virginia | 54055 | 5568 | 129 |
1628064 | 1628064 | 2021-08-17 | Mercer | West Virginia | 54055 | 5534 | 129 |
1624817 | 1624817 | 2021-08-16 | Mercer | West Virginia | 54055 | 5494 | 129 |
1621570 | 1621570 | 2021-08-15 | Mercer | West Virginia | 54055 | 5437 | 129 |
1618322 | 1618322 | 2021-08-14 | Mercer | West Virginia | 54055 | 5437 | 129 |
1615074 | 1615074 | 2021-08-13 | Mercer | West Virginia | 54055 | 5437 | 129 |
1611825 | 1611825 | 2021-08-12 | Mercer | West Virginia | 54055 | 5433 | 129 |
1608578 | 1608578 | 2021-08-11 | Mercer | West Virginia | 54055 | 5416 | 129 |
1605329 | 1605329 | 2021-08-10 | Mercer | West Virginia | 54055 | 5398 | 129 |
1602079 | 1602079 | 2021-08-09 | Mercer | West Virginia | 54055 | 5383 | 129 |
1598831 | 1598831 | 2021-08-08 | Mercer | West Virginia | 54055 | 5348 | 129 |
1595582 | 1595582 | 2021-08-07 | Mercer | West Virginia | 54055 | 5348 | 129 |
1592333 | 1592333 | 2021-08-06 | Mercer | West Virginia | 54055 | 5348 | 129 |
1589084 | 1589084 | 2021-08-05 | Mercer | West Virginia | 54055 | 5338 | 129 |
1585835 | 1585835 | 2021-08-04 | Mercer | West Virginia | 54055 | 5325 | 129 |
1582585 | 1582585 | 2021-08-03 | Mercer | West Virginia | 54055 | 5318 | 129 |
1579335 | 1579335 | 2021-08-02 | Mercer | West Virginia | 54055 | 5310 | 129 |
1576087 | 1576087 | 2021-08-01 | Mercer | West Virginia | 54055 | 5286 | 129 |
1572839 | 1572839 | 2021-07-31 | Mercer | West Virginia | 54055 | 5286 | 129 |
1569591 | 1569591 | 2021-07-30 | Mercer | West Virginia | 54055 | 5286 | 129 |
1566343 | 1566343 | 2021-07-29 | Mercer | West Virginia | 54055 | 5282 | 129 |
1563095 | 1563095 | 2021-07-28 | Mercer | West Virginia | 54055 | 5273 | 129 |
1559847 | 1559847 | 2021-07-27 | Mercer | West Virginia | 54055 | 5269 | 129 |
1556600 | 1556600 | 2021-07-26 | Mercer | West Virginia | 54055 | 5267 | 129 |
1553353 | 1553353 | 2021-07-25 | Mercer | West Virginia | 54055 | 5248 | 129 |
1550106 | 1550106 | 2021-07-24 | Mercer | West Virginia | 54055 | 5248 | 129 |
1546859 | 1546859 | 2021-07-23 | Mercer | West Virginia | 54055 | 5248 | 129 |
1543612 | 1543612 | 2021-07-22 | Mercer | West Virginia | 54055 | 5238 | 129 |
1540364 | 1540364 | 2021-07-21 | Mercer | West Virginia | 54055 | 5236 | 129 |
1537117 | 1537117 | 2021-07-20 | Mercer | West Virginia | 54055 | 5232 | 129 |
1533869 | 1533869 | 2021-07-19 | Mercer | West Virginia | 54055 | 5230 | 129 |
1530622 | 1530622 | 2021-07-18 | Mercer | West Virginia | 54055 | 5228 | 129 |
1527375 | 1527375 | 2021-07-17 | Mercer | West Virginia | 54055 | 5228 | 129 |
1524128 | 1524128 | 2021-07-16 | Mercer | West Virginia | 54055 | 5228 | 129 |
1520880 | 1520880 | 2021-07-15 | Mercer | West Virginia | 54055 | 5223 | 129 |
1517632 | 1517632 | 2021-07-14 | Mercer | West Virginia | 54055 | 5219 | 129 |
1420226 | 1420226 | 2021-06-14 | Berkeley | West Virginia | 54003 | 12786 | 129 |
1416981 | 1416981 | 2021-06-13 | Berkeley | West Virginia | 54003 | 12775 | 129 |
1413735 | 1413735 | 2021-06-12 | Berkeley | West Virginia | 54003 | 12775 | 129 |
1410490 | 1410490 | 2021-06-11 | Berkeley | West Virginia | 54003 | 12775 | 129 |
1407245 | 1407245 | 2021-06-10 | Berkeley | West Virginia | 54003 | 12768 | 129 |
1403999 | 1403999 | 2021-06-09 | Berkeley | West Virginia | 54003 | 12763 | 129 |
1059901 | 1059901 | 2021-02-23 | Wood | West Virginia | 54107 | 6978 | 129 |
1056655 | 1056655 | 2021-02-22 | Wood | West Virginia | 54107 | 6966 | 129 |
1053409 | 1053409 | 2021-02-21 | Wood | West Virginia | 54107 | 6944 | 129 |
1050162 | 1050162 | 2021-02-20 | Wood | West Virginia | 54107 | 6925 | 129 |
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);