ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
748 rows where deaths = 11 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Ritchie 188
- Pendleton 110
- Clay 72
- Berkeley 51
- Monroe 50
- Pleasants 42
- Wayne 30
- Pocahontas 25
- Doddridge 24
- Calhoun 15
- Morgan 15
- Webster 12
- Wetzel 11
- Tucker 9
- Nicholas 8
- Wyoming 8
- Jefferson 7
- Roane 7
- Summers 7
- Lewis 6
- Hampshire 4
- McDowell 4
- Mingo 4
- Hardy 3
- Logan 3
- Mason 3
- Taylor 3
- Wirt 3
- Barbour 2
- Brooke 2
- …
state 1
- West Virginia · 748 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2245596 | 2245596 | 2022-02-23 | Calhoun | West Virginia | 54013 | 1769 | 11 |
2242345 | 2242345 | 2022-02-22 | Calhoun | West Virginia | 54013 | 1762 | 11 |
2239094 | 2239094 | 2022-02-21 | Calhoun | West Virginia | 54013 | 1761 | 11 |
2235843 | 2235843 | 2022-02-20 | Calhoun | West Virginia | 54013 | 1748 | 11 |
2232592 | 2232592 | 2022-02-19 | Calhoun | West Virginia | 54013 | 1748 | 11 |
2229341 | 2229341 | 2022-02-18 | Calhoun | West Virginia | 54013 | 1748 | 11 |
2226090 | 2226090 | 2022-02-17 | Calhoun | West Virginia | 54013 | 1745 | 11 |
2222839 | 2222839 | 2022-02-16 | Calhoun | West Virginia | 54013 | 1745 | 11 |
2219588 | 2219588 | 2022-02-15 | Calhoun | West Virginia | 54013 | 1737 | 11 |
2216338 | 2216338 | 2022-02-14 | Calhoun | West Virginia | 54013 | 1737 | 11 |
2213087 | 2213087 | 2022-02-13 | Calhoun | West Virginia | 54013 | 1738 | 11 |
2209834 | 2209834 | 2022-02-12 | Calhoun | West Virginia | 54013 | 1730 | 11 |
2206581 | 2206581 | 2022-02-11 | Calhoun | West Virginia | 54013 | 1726 | 11 |
2203328 | 2203328 | 2022-02-10 | Calhoun | West Virginia | 54013 | 1718 | 11 |
2200074 | 2200074 | 2022-02-09 | Calhoun | West Virginia | 54013 | 1696 | 11 |
1972461 | 1972461 | 2021-12-01 | Doddridge | West Virginia | 54017 | 1443 | 11 |
1969211 | 1969211 | 2021-11-30 | Doddridge | West Virginia | 54017 | 1440 | 11 |
1965961 | 1965961 | 2021-11-29 | Doddridge | West Virginia | 54017 | 1436 | 11 |
1962709 | 1962709 | 2021-11-28 | Doddridge | West Virginia | 54017 | 1415 | 11 |
1959458 | 1959458 | 2021-11-27 | Doddridge | West Virginia | 54017 | 1415 | 11 |
1956207 | 1956207 | 2021-11-26 | Doddridge | West Virginia | 54017 | 1415 | 11 |
1952956 | 1952956 | 2021-11-25 | Doddridge | West Virginia | 54017 | 1415 | 11 |
1949705 | 1949705 | 2021-11-24 | Doddridge | West Virginia | 54017 | 1415 | 11 |
1946454 | 1946454 | 2021-11-23 | Doddridge | West Virginia | 54017 | 1410 | 11 |
1943203 | 1943203 | 2021-11-22 | Doddridge | West Virginia | 54017 | 1402 | 11 |
1939953 | 1939953 | 2021-11-21 | Doddridge | West Virginia | 54017 | 1399 | 11 |
1936703 | 1936703 | 2021-11-20 | Doddridge | West Virginia | 54017 | 1397 | 11 |
1933453 | 1933453 | 2021-11-19 | Doddridge | West Virginia | 54017 | 1396 | 11 |
1930201 | 1930201 | 2021-11-18 | Doddridge | West Virginia | 54017 | 1394 | 11 |
1926951 | 1926951 | 2021-11-17 | Doddridge | West Virginia | 54017 | 1393 | 11 |
1923701 | 1923701 | 2021-11-16 | Doddridge | West Virginia | 54017 | 1386 | 11 |
1920452 | 1920452 | 2021-11-15 | Doddridge | West Virginia | 54017 | 1386 | 11 |
1917202 | 1917202 | 2021-11-14 | Doddridge | West Virginia | 54017 | 1385 | 11 |
1913952 | 1913952 | 2021-11-13 | Doddridge | West Virginia | 54017 | 1384 | 11 |
1910702 | 1910702 | 2021-11-12 | Doddridge | West Virginia | 54017 | 1381 | 11 |
1907453 | 1907453 | 2021-11-11 | Doddridge | West Virginia | 54017 | 1381 | 11 |
1904204 | 1904204 | 2021-11-10 | Doddridge | West Virginia | 54017 | 1378 | 11 |
1900954 | 1900954 | 2021-11-09 | Doddridge | West Virginia | 54017 | 1376 | 11 |
1897704 | 1897704 | 2021-11-08 | Doddridge | West Virginia | 54017 | 1376 | 11 |
1803519 | 1803519 | 2021-10-10 | Wirt | West Virginia | 54105 | 776 | 11 |
1800270 | 1800270 | 2021-10-09 | Wirt | West Virginia | 54105 | 766 | 11 |
1797021 | 1797021 | 2021-10-08 | Wirt | West Virginia | 54105 | 765 | 11 |
1748238 | 1748238 | 2021-09-23 | Braxton | West Virginia | 54007 | 1750 | 11 |
1722281 | 1722281 | 2021-09-15 | Ritchie | West Virginia | 54085 | 1077 | 11 |
1719033 | 1719033 | 2021-09-14 | Ritchie | West Virginia | 54085 | 1068 | 11 |
1715785 | 1715785 | 2021-09-13 | Ritchie | West Virginia | 54085 | 1059 | 11 |
1715789 | 1715789 | 2021-09-13 | Tucker | West Virginia | 54093 | 790 | 11 |
1712539 | 1712539 | 2021-09-12 | Ritchie | West Virginia | 54085 | 1042 | 11 |
1712540 | 1712540 | 2021-09-12 | Roane | West Virginia | 54087 | 996 | 11 |
1712543 | 1712543 | 2021-09-12 | Tucker | West Virginia | 54093 | 784 | 11 |
1712547 | 1712547 | 2021-09-12 | Webster | West Virginia | 54101 | 813 | 11 |
1709292 | 1709292 | 2021-09-11 | Ritchie | West Virginia | 54085 | 1023 | 11 |
1709293 | 1709293 | 2021-09-11 | Roane | West Virginia | 54087 | 990 | 11 |
1709296 | 1709296 | 2021-09-11 | Tucker | West Virginia | 54093 | 773 | 11 |
1709300 | 1709300 | 2021-09-11 | Webster | West Virginia | 54101 | 808 | 11 |
1706045 | 1706045 | 2021-09-10 | Ritchie | West Virginia | 54085 | 1007 | 11 |
1706046 | 1706046 | 2021-09-10 | Roane | West Virginia | 54087 | 970 | 11 |
1706049 | 1706049 | 2021-09-10 | Tucker | West Virginia | 54093 | 762 | 11 |
1706053 | 1706053 | 2021-09-10 | Webster | West Virginia | 54101 | 799 | 11 |
1702795 | 1702795 | 2021-09-09 | Ritchie | West Virginia | 54085 | 986 | 11 |
1702796 | 1702796 | 2021-09-09 | Roane | West Virginia | 54087 | 949 | 11 |
1702799 | 1702799 | 2021-09-09 | Tucker | West Virginia | 54093 | 749 | 11 |
1702804 | 1702804 | 2021-09-09 | Webster | West Virginia | 54101 | 795 | 11 |
1699546 | 1699546 | 2021-09-08 | Ritchie | West Virginia | 54085 | 964 | 11 |
1699547 | 1699547 | 2021-09-08 | Roane | West Virginia | 54087 | 928 | 11 |
1699554 | 1699554 | 2021-09-08 | Webster | West Virginia | 54101 | 792 | 11 |
1696263 | 1696263 | 2021-09-07 | Clay | West Virginia | 54015 | 813 | 11 |
1696298 | 1696298 | 2021-09-07 | Ritchie | West Virginia | 54085 | 954 | 11 |
1696299 | 1696299 | 2021-09-07 | Roane | West Virginia | 54087 | 915 | 11 |
1696306 | 1696306 | 2021-09-07 | Webster | West Virginia | 54101 | 781 | 11 |
1693015 | 1693015 | 2021-09-06 | Clay | West Virginia | 54015 | 803 | 11 |
1693050 | 1693050 | 2021-09-06 | Ritchie | West Virginia | 54085 | 937 | 11 |
1693051 | 1693051 | 2021-09-06 | Roane | West Virginia | 54087 | 904 | 11 |
1693058 | 1693058 | 2021-09-06 | Webster | West Virginia | 54101 | 778 | 11 |
1689766 | 1689766 | 2021-09-05 | Clay | West Virginia | 54015 | 792 | 11 |
1689794 | 1689794 | 2021-09-05 | Pendleton | West Virginia | 54071 | 880 | 11 |
1689801 | 1689801 | 2021-09-05 | Ritchie | West Virginia | 54085 | 927 | 11 |
1689809 | 1689809 | 2021-09-05 | Webster | West Virginia | 54101 | 772 | 11 |
1686516 | 1686516 | 2021-09-04 | Clay | West Virginia | 54015 | 774 | 11 |
1686544 | 1686544 | 2021-09-04 | Pendleton | West Virginia | 54071 | 873 | 11 |
1686551 | 1686551 | 2021-09-04 | Ritchie | West Virginia | 54085 | 921 | 11 |
1686559 | 1686559 | 2021-09-04 | Webster | West Virginia | 54101 | 770 | 11 |
1683265 | 1683265 | 2021-09-03 | Clay | West Virginia | 54015 | 763 | 11 |
1683293 | 1683293 | 2021-09-03 | Pendleton | West Virginia | 54071 | 868 | 11 |
1683300 | 1683300 | 2021-09-03 | Ritchie | West Virginia | 54085 | 906 | 11 |
1683309 | 1683309 | 2021-09-03 | Webster | West Virginia | 54101 | 758 | 11 |
1680015 | 1680015 | 2021-09-02 | Clay | West Virginia | 54015 | 737 | 11 |
1680043 | 1680043 | 2021-09-02 | Pendleton | West Virginia | 54071 | 850 | 11 |
1680050 | 1680050 | 2021-09-02 | Ritchie | West Virginia | 54085 | 887 | 11 |
1680058 | 1680058 | 2021-09-02 | Webster | West Virginia | 54101 | 745 | 11 |
1676767 | 1676767 | 2021-09-01 | Clay | West Virginia | 54015 | 714 | 11 |
1676795 | 1676795 | 2021-09-01 | Pendleton | West Virginia | 54071 | 828 | 11 |
1676802 | 1676802 | 2021-09-01 | Ritchie | West Virginia | 54085 | 878 | 11 |
1676810 | 1676810 | 2021-09-01 | Webster | West Virginia | 54101 | 730 | 11 |
1673520 | 1673520 | 2021-08-31 | Clay | West Virginia | 54015 | 702 | 11 |
1673548 | 1673548 | 2021-08-31 | Pendleton | West Virginia | 54071 | 820 | 11 |
1673555 | 1673555 | 2021-08-31 | Ritchie | West Virginia | 54085 | 875 | 11 |
1670272 | 1670272 | 2021-08-30 | Clay | West Virginia | 54015 | 693 | 11 |
1670300 | 1670300 | 2021-08-30 | Pendleton | West Virginia | 54071 | 817 | 11 |
1670307 | 1670307 | 2021-08-30 | Ritchie | West Virginia | 54085 | 871 | 11 |
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);