ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
717 rows where deaths = 6 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Doddridge 229
- Gilmer 68
- Mason 59
- Wood 48
- Roane 38
- Ohio 29
- Taylor 26
- Berkeley 21
- Randolph 19
- Grant 16
- Preston 14
- Greenbrier 13
- Hardy 13
- Nicholas 12
- McDowell 11
- Ritchie 9
- Calhoun 8
- Hampshire 8
- Pleasants 8
- Wyoming 7
- Wayne 6
- Clay 5
- Webster 5
- Wirt 5
- Brooke 4
- Lincoln 4
- Marion 4
- Raleigh 4
- Cabell 3
- Monroe 3
- …
state 1
- West Virginia · 717 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1969209 | 1969209 | 2021-11-30 | Calhoun | West Virginia | 54013 | 1073 | 6 |
1965959 | 1965959 | 2021-11-29 | Calhoun | West Virginia | 54013 | 1070 | 6 |
1962707 | 1962707 | 2021-11-28 | Calhoun | West Virginia | 54013 | 1050 | 6 |
1959456 | 1959456 | 2021-11-27 | Calhoun | West Virginia | 54013 | 1050 | 6 |
1956205 | 1956205 | 2021-11-26 | Calhoun | West Virginia | 54013 | 1050 | 6 |
1952954 | 1952954 | 2021-11-25 | Calhoun | West Virginia | 54013 | 1050 | 6 |
1949703 | 1949703 | 2021-11-24 | Calhoun | West Virginia | 54013 | 1050 | 6 |
1946452 | 1946452 | 2021-11-23 | Calhoun | West Virginia | 54013 | 1047 | 6 |
1764485 | 1764485 | 2021-09-28 | Doddridge | West Virginia | 54017 | 1025 | 6 |
1761236 | 1761236 | 2021-09-27 | Doddridge | West Virginia | 54017 | 1017 | 6 |
1757988 | 1757988 | 2021-09-26 | Doddridge | West Virginia | 54017 | 1009 | 6 |
1754740 | 1754740 | 2021-09-25 | Doddridge | West Virginia | 54017 | 1003 | 6 |
1751492 | 1751492 | 2021-09-24 | Doddridge | West Virginia | 54017 | 1005 | 6 |
1748243 | 1748243 | 2021-09-23 | Doddridge | West Virginia | 54017 | 968 | 6 |
1744993 | 1744993 | 2021-09-22 | Doddridge | West Virginia | 54017 | 965 | 6 |
1741744 | 1741744 | 2021-09-21 | Doddridge | West Virginia | 54017 | 957 | 6 |
1741788 | 1741788 | 2021-09-21 | Wirt | West Virginia | 54105 | 674 | 6 |
1738495 | 1738495 | 2021-09-20 | Doddridge | West Virginia | 54017 | 954 | 6 |
1738539 | 1738539 | 2021-09-20 | Wirt | West Virginia | 54105 | 664 | 6 |
1735246 | 1735246 | 2021-09-19 | Doddridge | West Virginia | 54017 | 951 | 6 |
1735290 | 1735290 | 2021-09-19 | Wirt | West Virginia | 54105 | 663 | 6 |
1731996 | 1731996 | 2021-09-18 | Doddridge | West Virginia | 54017 | 941 | 6 |
1732040 | 1732040 | 2021-09-18 | Wirt | West Virginia | 54105 | 653 | 6 |
1728746 | 1728746 | 2021-09-17 | Doddridge | West Virginia | 54017 | 934 | 6 |
1728790 | 1728790 | 2021-09-17 | Wirt | West Virginia | 54105 | 648 | 6 |
1725496 | 1725496 | 2021-09-16 | Doddridge | West Virginia | 54017 | 918 | 6 |
1722247 | 1722247 | 2021-09-15 | Doddridge | West Virginia | 54017 | 910 | 6 |
1718999 | 1718999 | 2021-09-14 | Doddridge | West Virginia | 54017 | 902 | 6 |
1715751 | 1715751 | 2021-09-13 | Doddridge | West Virginia | 54017 | 887 | 6 |
1712505 | 1712505 | 2021-09-12 | Doddridge | West Virginia | 54017 | 880 | 6 |
1709258 | 1709258 | 2021-09-11 | Doddridge | West Virginia | 54017 | 869 | 6 |
1706011 | 1706011 | 2021-09-10 | Doddridge | West Virginia | 54017 | 857 | 6 |
1702761 | 1702761 | 2021-09-09 | Doddridge | West Virginia | 54017 | 839 | 6 |
1699512 | 1699512 | 2021-09-08 | Doddridge | West Virginia | 54017 | 822 | 6 |
1689767 | 1689767 | 2021-09-05 | Doddridge | West Virginia | 54017 | 784 | 6 |
1686517 | 1686517 | 2021-09-04 | Doddridge | West Virginia | 54017 | 774 | 6 |
1683266 | 1683266 | 2021-09-03 | Doddridge | West Virginia | 54017 | 758 | 6 |
1680011 | 1680011 | 2021-09-02 | Braxton | West Virginia | 54007 | 1277 | 6 |
1680016 | 1680016 | 2021-09-02 | Doddridge | West Virginia | 54017 | 727 | 6 |
1676768 | 1676768 | 2021-09-01 | Doddridge | West Virginia | 54017 | 719 | 6 |
1673521 | 1673521 | 2021-08-31 | Doddridge | West Virginia | 54017 | 710 | 6 |
1670273 | 1670273 | 2021-08-30 | Doddridge | West Virginia | 54017 | 710 | 6 |
1667026 | 1667026 | 2021-08-29 | Doddridge | West Virginia | 54017 | 705 | 6 |
1663778 | 1663778 | 2021-08-28 | Doddridge | West Virginia | 54017 | 701 | 6 |
1660530 | 1660530 | 2021-08-27 | Doddridge | West Virginia | 54017 | 701 | 6 |
1657282 | 1657282 | 2021-08-26 | Doddridge | West Virginia | 54017 | 693 | 6 |
1654034 | 1654034 | 2021-08-25 | Doddridge | West Virginia | 54017 | 688 | 6 |
1650788 | 1650788 | 2021-08-24 | Doddridge | West Virginia | 54017 | 684 | 6 |
1647539 | 1647539 | 2021-08-23 | Doddridge | West Virginia | 54017 | 685 | 6 |
1644290 | 1644290 | 2021-08-22 | Doddridge | West Virginia | 54017 | 677 | 6 |
1641040 | 1641040 | 2021-08-21 | Doddridge | West Virginia | 54017 | 677 | 6 |
1637790 | 1637790 | 2021-08-20 | Doddridge | West Virginia | 54017 | 677 | 6 |
1634540 | 1634540 | 2021-08-19 | Doddridge | West Virginia | 54017 | 677 | 6 |
1631292 | 1631292 | 2021-08-18 | Doddridge | West Virginia | 54017 | 675 | 6 |
1628045 | 1628045 | 2021-08-17 | Doddridge | West Virginia | 54017 | 673 | 6 |
1624798 | 1624798 | 2021-08-16 | Doddridge | West Virginia | 54017 | 668 | 6 |
1621551 | 1621551 | 2021-08-15 | Doddridge | West Virginia | 54017 | 665 | 6 |
1618303 | 1618303 | 2021-08-14 | Doddridge | West Virginia | 54017 | 665 | 6 |
1615055 | 1615055 | 2021-08-13 | Doddridge | West Virginia | 54017 | 665 | 6 |
1611806 | 1611806 | 2021-08-12 | Doddridge | West Virginia | 54017 | 665 | 6 |
1608559 | 1608559 | 2021-08-11 | Doddridge | West Virginia | 54017 | 663 | 6 |
1605310 | 1605310 | 2021-08-10 | Doddridge | West Virginia | 54017 | 661 | 6 |
1602060 | 1602060 | 2021-08-09 | Doddridge | West Virginia | 54017 | 658 | 6 |
1598812 | 1598812 | 2021-08-08 | Doddridge | West Virginia | 54017 | 657 | 6 |
1595563 | 1595563 | 2021-08-07 | Doddridge | West Virginia | 54017 | 657 | 6 |
1592314 | 1592314 | 2021-08-06 | Doddridge | West Virginia | 54017 | 657 | 6 |
1589065 | 1589065 | 2021-08-05 | Doddridge | West Virginia | 54017 | 654 | 6 |
1585816 | 1585816 | 2021-08-04 | Doddridge | West Virginia | 54017 | 653 | 6 |
1582566 | 1582566 | 2021-08-03 | Doddridge | West Virginia | 54017 | 653 | 6 |
1579316 | 1579316 | 2021-08-02 | Doddridge | West Virginia | 54017 | 653 | 6 |
1576068 | 1576068 | 2021-08-01 | Doddridge | West Virginia | 54017 | 653 | 6 |
1572820 | 1572820 | 2021-07-31 | Doddridge | West Virginia | 54017 | 653 | 6 |
1569572 | 1569572 | 2021-07-30 | Doddridge | West Virginia | 54017 | 653 | 6 |
1566324 | 1566324 | 2021-07-29 | Doddridge | West Virginia | 54017 | 653 | 6 |
1563076 | 1563076 | 2021-07-28 | Doddridge | West Virginia | 54017 | 653 | 6 |
1559828 | 1559828 | 2021-07-27 | Doddridge | West Virginia | 54017 | 652 | 6 |
1556581 | 1556581 | 2021-07-26 | Doddridge | West Virginia | 54017 | 652 | 6 |
1553334 | 1553334 | 2021-07-25 | Doddridge | West Virginia | 54017 | 649 | 6 |
1550087 | 1550087 | 2021-07-24 | Doddridge | West Virginia | 54017 | 649 | 6 |
1546840 | 1546840 | 2021-07-23 | Doddridge | West Virginia | 54017 | 649 | 6 |
1543593 | 1543593 | 2021-07-22 | Doddridge | West Virginia | 54017 | 648 | 6 |
1540345 | 1540345 | 2021-07-21 | Doddridge | West Virginia | 54017 | 648 | 6 |
1537098 | 1537098 | 2021-07-20 | Doddridge | West Virginia | 54017 | 648 | 6 |
1533850 | 1533850 | 2021-07-19 | Doddridge | West Virginia | 54017 | 648 | 6 |
1530603 | 1530603 | 2021-07-18 | Doddridge | West Virginia | 54017 | 647 | 6 |
1527356 | 1527356 | 2021-07-17 | Doddridge | West Virginia | 54017 | 647 | 6 |
1524109 | 1524109 | 2021-07-16 | Doddridge | West Virginia | 54017 | 647 | 6 |
1520861 | 1520861 | 2021-07-15 | Doddridge | West Virginia | 54017 | 647 | 6 |
1517613 | 1517613 | 2021-07-14 | Doddridge | West Virginia | 54017 | 647 | 6 |
1514366 | 1514366 | 2021-07-13 | Doddridge | West Virginia | 54017 | 647 | 6 |
1511120 | 1511120 | 2021-07-12 | Doddridge | West Virginia | 54017 | 647 | 6 |
1507873 | 1507873 | 2021-07-11 | Doddridge | West Virginia | 54017 | 647 | 6 |
1504627 | 1504627 | 2021-07-10 | Doddridge | West Virginia | 54017 | 647 | 6 |
1501381 | 1501381 | 2021-07-09 | Doddridge | West Virginia | 54017 | 647 | 6 |
1498135 | 1498135 | 2021-07-08 | Doddridge | West Virginia | 54017 | 647 | 6 |
1494888 | 1494888 | 2021-07-07 | Doddridge | West Virginia | 54017 | 646 | 6 |
1491641 | 1491641 | 2021-07-06 | Doddridge | West Virginia | 54017 | 646 | 6 |
1488394 | 1488394 | 2021-07-05 | Doddridge | West Virginia | 54017 | 644 | 6 |
1488396 | 1488396 | 2021-07-05 | Gilmer | West Virginia | 54021 | 885 | 6 |
1485147 | 1485147 | 2021-07-04 | Doddridge | West Virginia | 54017 | 644 | 6 |
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);