ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
140 rows where deaths = 65 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 |
---|---|---|---|---|---|---|---|
2310653 | 2310653 | 2022-03-15 | McDowell | West Virginia | 54047 | 5553 | 65 |
2287908 | 2287908 | 2022-03-08 | Taylor | West Virginia | 54091 | 4456 | 65 |
2284656 | 2284656 | 2022-03-07 | Taylor | West Virginia | 54091 | 4450 | 65 |
2248854 | 2248854 | 2022-02-24 | Hampshire | West Virginia | 54027 | 5732 | 65 |
2242371 | 2242371 | 2022-02-22 | Morgan | West Virginia | 54065 | 4172 | 65 |
2219584 | 2219584 | 2022-02-15 | Boone | West Virginia | 54005 | 6354 | 65 |
2216353 | 2216353 | 2022-02-14 | Lincoln | West Virginia | 54043 | 5221 | 65 |
2167580 | 2167580 | 2022-01-30 | Randolph | West Virginia | 54083 | 8064 | 65 |
2164325 | 2164325 | 2022-01-29 | Randolph | West Virginia | 54083 | 7991 | 65 |
2161070 | 2161070 | 2022-01-28 | Randolph | West Virginia | 54083 | 7870 | 65 |
2157814 | 2157814 | 2022-01-27 | Randolph | West Virginia | 54083 | 7790 | 65 |
2154561 | 2154561 | 2022-01-26 | Randolph | West Virginia | 54083 | 7689 | 65 |
2151308 | 2151308 | 2022-01-25 | Randolph | West Virginia | 54083 | 7626 | 65 |
2148056 | 2148056 | 2022-01-24 | Randolph | West Virginia | 54083 | 7536 | 65 |
2144804 | 2144804 | 2022-01-23 | Randolph | West Virginia | 54083 | 7470 | 65 |
2141549 | 2141549 | 2022-01-22 | Randolph | West Virginia | 54083 | 7414 | 65 |
2138293 | 2138293 | 2022-01-21 | Randolph | West Virginia | 54083 | 7305 | 65 |
2135038 | 2135038 | 2022-01-20 | Randolph | West Virginia | 54083 | 7195 | 65 |
2131786 | 2131786 | 2022-01-19 | Randolph | West Virginia | 54083 | 7070 | 65 |
2128532 | 2128532 | 2022-01-18 | Randolph | West Virginia | 54083 | 6967 | 65 |
2125279 | 2125279 | 2022-01-17 | Randolph | West Virginia | 54083 | 6896 | 65 |
2122027 | 2122027 | 2022-01-16 | Randolph | West Virginia | 54083 | 6858 | 65 |
2118775 | 2118775 | 2022-01-15 | Randolph | West Virginia | 54083 | 6795 | 65 |
2115523 | 2115523 | 2022-01-14 | Randolph | West Virginia | 54083 | 6710 | 65 |
2112271 | 2112271 | 2022-01-13 | Randolph | West Virginia | 54083 | 6598 | 65 |
2076483 | 2076483 | 2022-01-02 | Lewis | West Virginia | 54041 | 3646 | 65 |
2073232 | 2073232 | 2022-01-01 | Lewis | West Virginia | 54041 | 3646 | 65 |
2069981 | 2069981 | 2021-12-31 | Lewis | West Virginia | 54041 | 3646 | 65 |
2066730 | 2066730 | 2021-12-30 | Lewis | West Virginia | 54041 | 3646 | 65 |
2063480 | 2063480 | 2021-12-29 | Lewis | West Virginia | 54041 | 3635 | 65 |
2060230 | 2060230 | 2021-12-28 | Lewis | West Virginia | 54041 | 3617 | 65 |
2056986 | 2056986 | 2021-12-27 | Mason | West Virginia | 54053 | 4277 | 65 |
2053737 | 2053737 | 2021-12-26 | Mason | West Virginia | 54053 | 4256 | 65 |
2050487 | 2050487 | 2021-12-25 | Mason | West Virginia | 54053 | 4256 | 65 |
2047237 | 2047237 | 2021-12-24 | Mason | West Virginia | 54053 | 4256 | 65 |
2043987 | 2043987 | 2021-12-23 | Mason | West Virginia | 54053 | 4256 | 65 |
2040738 | 2040738 | 2021-12-22 | Mason | West Virginia | 54053 | 4242 | 65 |
2008258 | 2008258 | 2021-12-12 | Wetzel | West Virginia | 54103 | 2880 | 65 |
2005007 | 2005007 | 2021-12-11 | Wetzel | West Virginia | 54103 | 2878 | 65 |
2001756 | 2001756 | 2021-12-10 | Wetzel | West Virginia | 54103 | 2876 | 65 |
1998506 | 1998506 | 2021-12-09 | Wetzel | West Virginia | 54103 | 2870 | 65 |
1995255 | 1995255 | 2021-12-08 | Wetzel | West Virginia | 54103 | 2864 | 65 |
1965986 | 1965986 | 2021-11-29 | Nicholas | West Virginia | 54067 | 4261 | 65 |
1897750 | 1897750 | 2021-11-08 | Wyoming | West Virginia | 54109 | 3763 | 65 |
1894494 | 1894494 | 2021-11-07 | Upshur | West Virginia | 54097 | 4135 | 65 |
1894500 | 1894500 | 2021-11-07 | Wyoming | West Virginia | 54109 | 3758 | 65 |
1891244 | 1891244 | 2021-11-06 | Upshur | West Virginia | 54097 | 4120 | 65 |
1891250 | 1891250 | 2021-11-06 | Wyoming | West Virginia | 54109 | 3748 | 65 |
1887994 | 1887994 | 2021-11-05 | Upshur | West Virginia | 54097 | 4101 | 65 |
1888000 | 1888000 | 2021-11-05 | Wyoming | West Virginia | 54109 | 3738 | 65 |
1884744 | 1884744 | 2021-11-04 | Upshur | West Virginia | 54097 | 4088 | 65 |
1884750 | 1884750 | 2021-11-04 | Wyoming | West Virginia | 54109 | 3728 | 65 |
1881495 | 1881495 | 2021-11-03 | Upshur | West Virginia | 54097 | 4056 | 65 |
1881501 | 1881501 | 2021-11-03 | Wyoming | West Virginia | 54109 | 3718 | 65 |
1878246 | 1878246 | 2021-11-02 | Upshur | West Virginia | 54097 | 4039 | 65 |
1878252 | 1878252 | 2021-11-02 | Wyoming | West Virginia | 54109 | 3705 | 65 |
1874997 | 1874997 | 2021-11-01 | Upshur | West Virginia | 54097 | 4024 | 65 |
1871748 | 1871748 | 2021-10-31 | Upshur | West Virginia | 54097 | 4014 | 65 |
1868499 | 1868499 | 2021-10-30 | Upshur | West Virginia | 54097 | 4006 | 65 |
1865250 | 1865250 | 2021-10-29 | Upshur | West Virginia | 54097 | 3995 | 65 |
1793749 | 1793749 | 2021-10-07 | Mingo | West Virginia | 54059 | 4285 | 65 |
1793758 | 1793758 | 2021-10-07 | Preston | West Virginia | 54077 | 4620 | 65 |
1790500 | 1790500 | 2021-10-06 | Mingo | West Virginia | 54059 | 4278 | 65 |
1787252 | 1787252 | 2021-10-05 | Mingo | West Virginia | 54059 | 4260 | 65 |
1784003 | 1784003 | 2021-10-04 | Mingo | West Virginia | 54059 | 4245 | 65 |
1780754 | 1780754 | 2021-10-03 | Mingo | West Virginia | 54059 | 4236 | 65 |
1777504 | 1777504 | 2021-10-02 | Mingo | West Virginia | 54059 | 4222 | 65 |
1774254 | 1774254 | 2021-10-01 | Mingo | West Virginia | 54059 | 4207 | 65 |
1735255 | 1735255 | 2021-09-19 | Jackson | West Virginia | 54035 | 3068 | 65 |
1735261 | 1735261 | 2021-09-19 | Marion | West Virginia | 54049 | 6253 | 65 |
1732005 | 1732005 | 2021-09-18 | Jackson | West Virginia | 54035 | 3042 | 65 |
1732011 | 1732011 | 2021-09-18 | Marion | West Virginia | 54049 | 6168 | 65 |
1728755 | 1728755 | 2021-09-17 | Jackson | West Virginia | 54035 | 2992 | 65 |
1728761 | 1728761 | 2021-09-17 | Marion | West Virginia | 54049 | 6098 | 65 |
1725505 | 1725505 | 2021-09-16 | Jackson | West Virginia | 54035 | 2961 | 65 |
1722256 | 1722256 | 2021-09-15 | Jackson | West Virginia | 54035 | 2932 | 65 |
1719008 | 1719008 | 2021-09-14 | Jackson | West Virginia | 54035 | 2912 | 65 |
1715760 | 1715760 | 2021-09-13 | Jackson | West Virginia | 54035 | 2893 | 65 |
1712515 | 1712515 | 2021-09-12 | Jefferson | West Virginia | 54037 | 5648 | 65 |
1709268 | 1709268 | 2021-09-11 | Jefferson | West Virginia | 54037 | 5624 | 65 |
1706021 | 1706021 | 2021-09-10 | Jefferson | West Virginia | 54037 | 5582 | 65 |
1702771 | 1702771 | 2021-09-09 | Jefferson | West Virginia | 54037 | 5543 | 65 |
1699522 | 1699522 | 2021-09-08 | Jefferson | West Virginia | 54037 | 5499 | 65 |
1696274 | 1696274 | 2021-09-07 | Jefferson | West Virginia | 54037 | 5478 | 65 |
1693026 | 1693026 | 2021-09-06 | Jefferson | West Virginia | 54037 | 5452 | 65 |
1598816 | 1598816 | 2021-08-08 | Greenbrier | West Virginia | 54025 | 2941 | 65 |
1595567 | 1595567 | 2021-08-07 | Greenbrier | West Virginia | 54025 | 2941 | 65 |
1592318 | 1592318 | 2021-08-06 | Greenbrier | West Virginia | 54025 | 2941 | 65 |
1589069 | 1589069 | 2021-08-05 | Greenbrier | West Virginia | 54025 | 2940 | 65 |
1585820 | 1585820 | 2021-08-04 | Greenbrier | West Virginia | 54025 | 2938 | 65 |
1582570 | 1582570 | 2021-08-03 | Greenbrier | West Virginia | 54025 | 2932 | 65 |
1579320 | 1579320 | 2021-08-02 | Greenbrier | West Virginia | 54025 | 2930 | 65 |
1576072 | 1576072 | 2021-08-01 | Greenbrier | West Virginia | 54025 | 2922 | 65 |
1572824 | 1572824 | 2021-07-31 | Greenbrier | West Virginia | 54025 | 2922 | 65 |
1569576 | 1569576 | 2021-07-30 | Greenbrier | West Virginia | 54025 | 2922 | 65 |
1566328 | 1566328 | 2021-07-29 | Greenbrier | West Virginia | 54025 | 2922 | 65 |
1563080 | 1563080 | 2021-07-28 | Greenbrier | West Virginia | 54025 | 2921 | 65 |
1559832 | 1559832 | 2021-07-27 | Greenbrier | West Virginia | 54025 | 2921 | 65 |
1556585 | 1556585 | 2021-07-26 | Greenbrier | West Virginia | 54025 | 2920 | 65 |
1553338 | 1553338 | 2021-07-25 | Greenbrier | West Virginia | 54025 | 2919 | 65 |
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);