ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
144 rows where deaths = 57 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 |
---|---|---|---|---|---|---|---|
2157799 | 2157799 | 2022-01-27 | McDowell | West Virginia | 54047 | 4327 | 57 |
2157805 | 2157805 | 2022-01-27 | Morgan | West Virginia | 54065 | 3923 | 57 |
2157818 | 2157818 | 2022-01-27 | Taylor | West Virginia | 54091 | 3776 | 57 |
2154546 | 2154546 | 2022-01-26 | McDowell | West Virginia | 54047 | 4256 | 57 |
2154552 | 2154552 | 2022-01-26 | Morgan | West Virginia | 54065 | 3902 | 57 |
2151293 | 2151293 | 2022-01-25 | McDowell | West Virginia | 54047 | 4203 | 57 |
2151299 | 2151299 | 2022-01-25 | Morgan | West Virginia | 54065 | 3882 | 57 |
2148041 | 2148041 | 2022-01-24 | McDowell | West Virginia | 54047 | 4191 | 57 |
2148047 | 2148047 | 2022-01-24 | Morgan | West Virginia | 54065 | 3870 | 57 |
2144789 | 2144789 | 2022-01-23 | McDowell | West Virginia | 54047 | 4160 | 57 |
2144795 | 2144795 | 2022-01-23 | Morgan | West Virginia | 54065 | 3866 | 57 |
2141534 | 2141534 | 2022-01-22 | McDowell | West Virginia | 54047 | 4109 | 57 |
2141540 | 2141540 | 2022-01-22 | Morgan | West Virginia | 54065 | 3825 | 57 |
2138278 | 2138278 | 2022-01-21 | McDowell | West Virginia | 54047 | 4047 | 57 |
2138284 | 2138284 | 2022-01-21 | Morgan | West Virginia | 54065 | 3763 | 57 |
2135023 | 2135023 | 2022-01-20 | McDowell | West Virginia | 54047 | 3984 | 57 |
2135029 | 2135029 | 2022-01-20 | Morgan | West Virginia | 54065 | 3718 | 57 |
2131771 | 2131771 | 2022-01-19 | McDowell | West Virginia | 54047 | 3938 | 57 |
2131777 | 2131777 | 2022-01-19 | Morgan | West Virginia | 54065 | 3661 | 57 |
2128517 | 2128517 | 2022-01-18 | McDowell | West Virginia | 54047 | 3916 | 57 |
2128523 | 2128523 | 2022-01-18 | Morgan | West Virginia | 54065 | 3627 | 57 |
2125270 | 2125270 | 2022-01-17 | Morgan | West Virginia | 54065 | 3621 | 57 |
2122018 | 2122018 | 2022-01-16 | Morgan | West Virginia | 54065 | 3598 | 57 |
2118766 | 2118766 | 2022-01-15 | Morgan | West Virginia | 54065 | 3543 | 57 |
2115514 | 2115514 | 2022-01-14 | Morgan | West Virginia | 54065 | 3486 | 57 |
2112262 | 2112262 | 2022-01-13 | Morgan | West Virginia | 54065 | 3362 | 57 |
2109010 | 2109010 | 2022-01-12 | Morgan | West Virginia | 54065 | 3330 | 57 |
2105759 | 2105759 | 2022-01-11 | Morgan | West Virginia | 54065 | 3295 | 57 |
2102508 | 2102508 | 2022-01-10 | Morgan | West Virginia | 54065 | 3274 | 57 |
2099257 | 2099257 | 2022-01-09 | Morgan | West Virginia | 54065 | 3240 | 57 |
2096006 | 2096006 | 2022-01-08 | Morgan | West Virginia | 54065 | 3206 | 57 |
2092754 | 2092754 | 2022-01-07 | Morgan | West Virginia | 54065 | 3160 | 57 |
2086240 | 2086240 | 2022-01-05 | Lincoln | West Virginia | 54043 | 3609 | 57 |
2082988 | 2082988 | 2022-01-04 | Lincoln | West Virginia | 54043 | 3590 | 57 |
2079736 | 2079736 | 2022-01-03 | Lincoln | West Virginia | 54043 | 3573 | 57 |
2076484 | 2076484 | 2022-01-02 | Lincoln | West Virginia | 54043 | 3508 | 57 |
2073233 | 2073233 | 2022-01-01 | Lincoln | West Virginia | 54043 | 3508 | 57 |
2069982 | 2069982 | 2021-12-31 | Lincoln | West Virginia | 54043 | 3508 | 57 |
2066731 | 2066731 | 2021-12-30 | Lincoln | West Virginia | 54043 | 3508 | 57 |
1998496 | 1998496 | 2021-12-09 | Randolph | West Virginia | 54083 | 5599 | 57 |
1995245 | 1995245 | 2021-12-08 | Randolph | West Virginia | 54083 | 5580 | 57 |
1991994 | 1991994 | 2021-12-07 | Randolph | West Virginia | 54083 | 5577 | 57 |
1972473 | 1972473 | 2021-12-01 | Lewis | West Virginia | 54041 | 3334 | 57 |
1969223 | 1969223 | 2021-11-30 | Lewis | West Virginia | 54041 | 3298 | 57 |
1965973 | 1965973 | 2021-11-29 | Lewis | West Virginia | 54041 | 3287 | 57 |
1962721 | 1962721 | 2021-11-28 | Lewis | West Virginia | 54041 | 3263 | 57 |
1959470 | 1959470 | 2021-11-27 | Lewis | West Virginia | 54041 | 3263 | 57 |
1956219 | 1956219 | 2021-11-26 | Lewis | West Virginia | 54041 | 3263 | 57 |
1952968 | 1952968 | 2021-11-25 | Lewis | West Virginia | 54041 | 3263 | 57 |
1949717 | 1949717 | 2021-11-24 | Lewis | West Virginia | 54041 | 3263 | 57 |
1946466 | 1946466 | 2021-11-23 | Lewis | West Virginia | 54041 | 3251 | 57 |
1943215 | 1943215 | 2021-11-22 | Lewis | West Virginia | 54041 | 3249 | 57 |
1939965 | 1939965 | 2021-11-21 | Lewis | West Virginia | 54041 | 3229 | 57 |
1939978 | 1939978 | 2021-11-21 | Nicholas | West Virginia | 54067 | 4126 | 57 |
1936715 | 1936715 | 2021-11-20 | Lewis | West Virginia | 54041 | 3217 | 57 |
1936728 | 1936728 | 2021-11-20 | Nicholas | West Virginia | 54067 | 4115 | 57 |
1933465 | 1933465 | 2021-11-19 | Lewis | West Virginia | 54041 | 3203 | 57 |
1933478 | 1933478 | 2021-11-19 | Nicholas | West Virginia | 54067 | 4095 | 57 |
1930213 | 1930213 | 2021-11-18 | Lewis | West Virginia | 54041 | 3187 | 57 |
1930226 | 1930226 | 2021-11-18 | Nicholas | West Virginia | 54067 | 4071 | 57 |
1926963 | 1926963 | 2021-11-17 | Lewis | West Virginia | 54041 | 3171 | 57 |
1923713 | 1923713 | 2021-11-16 | Lewis | West Virginia | 54041 | 3162 | 57 |
1920464 | 1920464 | 2021-11-15 | Lewis | West Virginia | 54041 | 3155 | 57 |
1897721 | 1897721 | 2021-11-08 | Mason | West Virginia | 54053 | 3709 | 57 |
1894471 | 1894471 | 2021-11-07 | Mason | West Virginia | 54053 | 3702 | 57 |
1891221 | 1891221 | 2021-11-06 | Mason | West Virginia | 54053 | 3696 | 57 |
1887971 | 1887971 | 2021-11-05 | Mason | West Virginia | 54053 | 3687 | 57 |
1884721 | 1884721 | 2021-11-04 | Mason | West Virginia | 54053 | 3675 | 57 |
1881472 | 1881472 | 2021-11-03 | Mason | West Virginia | 54053 | 3662 | 57 |
1836012 | 1836012 | 2021-10-20 | Wyoming | West Virginia | 54109 | 3547 | 57 |
1832763 | 1832763 | 2021-10-19 | Wyoming | West Virginia | 54109 | 3529 | 57 |
1829514 | 1829514 | 2021-10-18 | Wyoming | West Virginia | 54109 | 3521 | 57 |
1826265 | 1826265 | 2021-10-17 | Wyoming | West Virginia | 54109 | 3512 | 57 |
1823016 | 1823016 | 2021-10-16 | Wyoming | West Virginia | 54109 | 3498 | 57 |
1816512 | 1816512 | 2021-10-14 | Upshur | West Virginia | 54097 | 3765 | 57 |
1813264 | 1813264 | 2021-10-13 | Upshur | West Virginia | 54097 | 3755 | 57 |
1810015 | 1810015 | 2021-10-12 | Upshur | West Virginia | 54097 | 3749 | 57 |
1806766 | 1806766 | 2021-10-11 | Upshur | West Virginia | 54097 | 3736 | 57 |
1803515 | 1803515 | 2021-10-10 | Upshur | West Virginia | 54097 | 3733 | 57 |
1800266 | 1800266 | 2021-10-09 | Upshur | West Virginia | 54097 | 3724 | 57 |
1797017 | 1797017 | 2021-10-08 | Upshur | West Virginia | 54097 | 3707 | 57 |
1758029 | 1758029 | 2021-09-26 | Wayne | West Virginia | 54099 | 4900 | 57 |
1754781 | 1754781 | 2021-09-25 | Wayne | West Virginia | 54099 | 4851 | 57 |
1751533 | 1751533 | 2021-09-24 | Wayne | West Virginia | 54099 | 4797 | 57 |
1748264 | 1748264 | 2021-09-23 | Mingo | West Virginia | 54059 | 3981 | 57 |
1748273 | 1748273 | 2021-09-23 | Preston | West Virginia | 54077 | 4074 | 57 |
1745014 | 1745014 | 2021-09-22 | Mingo | West Virginia | 54059 | 3926 | 57 |
1745023 | 1745023 | 2021-09-22 | Preston | West Virginia | 54077 | 4013 | 57 |
1741774 | 1741774 | 2021-09-21 | Preston | West Virginia | 54077 | 3986 | 57 |
1738525 | 1738525 | 2021-09-20 | Preston | West Virginia | 54077 | 3972 | 57 |
1735276 | 1735276 | 2021-09-19 | Preston | West Virginia | 54077 | 3932 | 57 |
1732026 | 1732026 | 2021-09-18 | Preston | West Virginia | 54077 | 3899 | 57 |
1728776 | 1728776 | 2021-09-17 | Preston | West Virginia | 54077 | 3849 | 57 |
1654049 | 1654049 | 2021-08-25 | Marion | West Virginia | 54049 | 5107 | 57 |
1462437 | 1462437 | 2021-06-27 | Jefferson | West Virginia | 54037 | 4794 | 57 |
1459192 | 1459192 | 2021-06-26 | Jefferson | West Virginia | 54037 | 4794 | 57 |
1455947 | 1455947 | 2021-06-25 | Jefferson | West Virginia | 54037 | 4794 | 57 |
1452702 | 1452702 | 2021-06-24 | Jefferson | West Virginia | 54037 | 4793 | 57 |
1449456 | 1449456 | 2021-06-23 | Jefferson | West Virginia | 54037 | 4793 | 57 |
1446211 | 1446211 | 2021-06-22 | Jefferson | West Virginia | 54037 | 4790 | 57 |
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);