ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
252 rows where deaths = 60 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2222878 | 2222878 | 2022-02-16 | Taylor | West Virginia | 54091 | 4192 | 60 |
2219627 | 2219627 | 2022-02-15 | Taylor | West Virginia | 54091 | 4183 | 60 |
2216358 | 2216358 | 2022-02-14 | McDowell | West Virginia | 54047 | 5090 | 60 |
2216377 | 2216377 | 2022-02-14 | Taylor | West Virginia | 54091 | 4180 | 60 |
2213107 | 2213107 | 2022-02-13 | McDowell | West Virginia | 54047 | 5075 | 60 |
2209854 | 2209854 | 2022-02-12 | McDowell | West Virginia | 54047 | 5043 | 60 |
2206601 | 2206601 | 2022-02-11 | McDowell | West Virginia | 54047 | 5000 | 60 |
2203348 | 2203348 | 2022-02-10 | McDowell | West Virginia | 54047 | 4966 | 60 |
2200094 | 2200094 | 2022-02-09 | McDowell | West Virginia | 54047 | 4914 | 60 |
2200100 | 2200100 | 2022-02-09 | Morgan | West Virginia | 54065 | 4102 | 60 |
2196840 | 2196840 | 2022-02-08 | McDowell | West Virginia | 54047 | 4859 | 60 |
2196846 | 2196846 | 2022-02-08 | Morgan | West Virginia | 54065 | 4094 | 60 |
2193585 | 2193585 | 2022-02-07 | McDowell | West Virginia | 54047 | 4842 | 60 |
2193591 | 2193591 | 2022-02-07 | Morgan | West Virginia | 54065 | 4082 | 60 |
2121999 | 2121999 | 2022-01-16 | Hampshire | West Virginia | 54027 | 4733 | 60 |
2118747 | 2118747 | 2022-01-15 | Hampshire | West Virginia | 54027 | 4703 | 60 |
2115495 | 2115495 | 2022-01-14 | Hampshire | West Virginia | 54027 | 4665 | 60 |
2112243 | 2112243 | 2022-01-13 | Hampshire | West Virginia | 54027 | 4607 | 60 |
2108991 | 2108991 | 2022-01-12 | Hampshire | West Virginia | 54027 | 4549 | 60 |
2105740 | 2105740 | 2022-01-11 | Hampshire | West Virginia | 54027 | 4520 | 60 |
2102489 | 2102489 | 2022-01-10 | Hampshire | West Virginia | 54027 | 4492 | 60 |
2031004 | 2031004 | 2021-12-19 | Randolph | West Virginia | 54083 | 5741 | 60 |
2027753 | 2027753 | 2021-12-18 | Randolph | West Virginia | 54083 | 5729 | 60 |
2024502 | 2024502 | 2021-12-17 | Randolph | West Virginia | 54083 | 5707 | 60 |
2021230 | 2021230 | 2021-12-16 | Lewis | West Virginia | 54041 | 3529 | 60 |
2017979 | 2017979 | 2021-12-15 | Lewis | West Virginia | 54041 | 3517 | 60 |
2014729 | 2014729 | 2021-12-14 | Lewis | West Virginia | 54041 | 3504 | 60 |
2011478 | 2011478 | 2021-12-13 | Lewis | West Virginia | 54041 | 3495 | 60 |
2008227 | 2008227 | 2021-12-12 | Lewis | West Virginia | 54041 | 3481 | 60 |
2004976 | 2004976 | 2021-12-11 | Lewis | West Virginia | 54041 | 3474 | 60 |
2001725 | 2001725 | 2021-12-10 | Lewis | West Virginia | 54041 | 3464 | 60 |
1998475 | 1998475 | 2021-12-09 | Lewis | West Virginia | 54041 | 3452 | 60 |
1995224 | 1995224 | 2021-12-08 | Lewis | West Virginia | 54041 | 3432 | 60 |
1991973 | 1991973 | 2021-12-07 | Lewis | West Virginia | 54041 | 3429 | 60 |
1965955 | 1965955 | 2021-11-29 | Boone | West Virginia | 54005 | 3958 | 60 |
1946448 | 1946448 | 2021-11-23 | Boone | West Virginia | 54005 | 3911 | 60 |
1939947 | 1939947 | 2021-11-21 | Boone | West Virginia | 54005 | 3902 | 60 |
1936697 | 1936697 | 2021-11-20 | Boone | West Virginia | 54005 | 3893 | 60 |
1933447 | 1933447 | 2021-11-19 | Boone | West Virginia | 54005 | 3875 | 60 |
1930195 | 1930195 | 2021-11-18 | Boone | West Virginia | 54005 | 3859 | 60 |
1926945 | 1926945 | 2021-11-17 | Boone | West Virginia | 54005 | 3842 | 60 |
1923718 | 1923718 | 2021-11-16 | Mason | West Virginia | 54053 | 3774 | 60 |
1917196 | 1917196 | 2021-11-14 | Boone | West Virginia | 54005 | 3815 | 60 |
1913946 | 1913946 | 2021-11-13 | Boone | West Virginia | 54005 | 3809 | 60 |
1910696 | 1910696 | 2021-11-12 | Boone | West Virginia | 54005 | 3799 | 60 |
1907447 | 1907447 | 2021-11-11 | Boone | West Virginia | 54005 | 3778 | 60 |
1904198 | 1904198 | 2021-11-10 | Boone | West Virginia | 54005 | 3761 | 60 |
1852260 | 1852260 | 2021-10-25 | Wyoming | West Virginia | 54109 | 3613 | 60 |
1780763 | 1780763 | 2021-10-03 | Preston | West Virginia | 54077 | 4504 | 60 |
1780774 | 1780774 | 2021-10-03 | Wayne | West Virginia | 54099 | 5174 | 60 |
1777513 | 1777513 | 2021-10-02 | Preston | West Virginia | 54077 | 4478 | 60 |
1777524 | 1777524 | 2021-10-02 | Wayne | West Virginia | 54099 | 5157 | 60 |
1774263 | 1774263 | 2021-10-01 | Preston | West Virginia | 54077 | 4454 | 60 |
1774274 | 1774274 | 2021-10-01 | Wayne | West Virginia | 54099 | 5102 | 60 |
1771013 | 1771013 | 2021-09-30 | Preston | West Virginia | 54077 | 4381 | 60 |
1771024 | 1771024 | 2021-09-30 | Wayne | West Virginia | 54099 | 5077 | 60 |
1767764 | 1767764 | 2021-09-29 | Preston | West Virginia | 54077 | 4319 | 60 |
1699527 | 1699527 | 2021-09-08 | Marion | West Virginia | 54049 | 5649 | 60 |
1696279 | 1696279 | 2021-09-07 | Marion | West Virginia | 54049 | 5615 | 60 |
1693031 | 1693031 | 2021-09-06 | Marion | West Virginia | 54049 | 5586 | 60 |
1689782 | 1689782 | 2021-09-05 | Marion | West Virginia | 54049 | 5547 | 60 |
1686532 | 1686532 | 2021-09-04 | Marion | West Virginia | 54049 | 5499 | 60 |
1683281 | 1683281 | 2021-09-03 | Marion | West Virginia | 54049 | 5452 | 60 |
1680031 | 1680031 | 2021-09-02 | Marion | West Virginia | 54049 | 5415 | 60 |
1676783 | 1676783 | 2021-09-01 | Marion | West Virginia | 54049 | 5384 | 60 |
1634550 | 1634550 | 2021-08-19 | Jefferson | West Virginia | 54037 | 5072 | 60 |
1631302 | 1631302 | 2021-08-18 | Jefferson | West Virginia | 54037 | 5054 | 60 |
1628055 | 1628055 | 2021-08-17 | Jefferson | West Virginia | 54037 | 5042 | 60 |
1624808 | 1624808 | 2021-08-16 | Jefferson | West Virginia | 54037 | 5007 | 60 |
1621561 | 1621561 | 2021-08-15 | Jefferson | West Virginia | 54037 | 4969 | 60 |
1618313 | 1618313 | 2021-08-14 | Jefferson | West Virginia | 54037 | 4969 | 60 |
1615065 | 1615065 | 2021-08-13 | Jefferson | West Virginia | 54037 | 4969 | 60 |
1611816 | 1611816 | 2021-08-12 | Jefferson | West Virginia | 54037 | 4963 | 60 |
1608569 | 1608569 | 2021-08-11 | Jefferson | West Virginia | 54037 | 4954 | 60 |
1605320 | 1605320 | 2021-08-10 | Jefferson | West Virginia | 54037 | 4933 | 60 |
1602070 | 1602070 | 2021-08-09 | Jefferson | West Virginia | 54037 | 4924 | 60 |
1598822 | 1598822 | 2021-08-08 | Jefferson | West Virginia | 54037 | 4903 | 60 |
1595573 | 1595573 | 2021-08-07 | Jefferson | West Virginia | 54037 | 4903 | 60 |
1592324 | 1592324 | 2021-08-06 | Jefferson | West Virginia | 54037 | 4903 | 60 |
1589075 | 1589075 | 2021-08-05 | Jefferson | West Virginia | 54037 | 4899 | 60 |
1585826 | 1585826 | 2021-08-04 | Jefferson | West Virginia | 54037 | 4888 | 60 |
1582576 | 1582576 | 2021-08-03 | Jefferson | West Virginia | 54037 | 4883 | 60 |
1579326 | 1579326 | 2021-08-02 | Jefferson | West Virginia | 54037 | 4877 | 60 |
1576078 | 1576078 | 2021-08-01 | Jefferson | West Virginia | 54037 | 4868 | 60 |
1572830 | 1572830 | 2021-07-31 | Jefferson | West Virginia | 54037 | 4868 | 60 |
1569582 | 1569582 | 2021-07-30 | Jefferson | West Virginia | 54037 | 4868 | 60 |
1566320 | 1566320 | 2021-07-29 | Brooke | West Virginia | 54009 | 2269 | 60 |
1566334 | 1566334 | 2021-07-29 | Jefferson | West Virginia | 54037 | 4863 | 60 |
1563072 | 1563072 | 2021-07-28 | Brooke | West Virginia | 54009 | 2269 | 60 |
1563086 | 1563086 | 2021-07-28 | Jefferson | West Virginia | 54037 | 4855 | 60 |
1559824 | 1559824 | 2021-07-27 | Brooke | West Virginia | 54009 | 2266 | 60 |
1559838 | 1559838 | 2021-07-27 | Jefferson | West Virginia | 54037 | 4849 | 60 |
1556577 | 1556577 | 2021-07-26 | Brooke | West Virginia | 54009 | 2264 | 60 |
1556591 | 1556591 | 2021-07-26 | Jefferson | West Virginia | 54037 | 4841 | 60 |
1553330 | 1553330 | 2021-07-25 | Brooke | West Virginia | 54009 | 2257 | 60 |
1553344 | 1553344 | 2021-07-25 | Jefferson | West Virginia | 54037 | 4829 | 60 |
1550083 | 1550083 | 2021-07-24 | Brooke | West Virginia | 54009 | 2257 | 60 |
1550097 | 1550097 | 2021-07-24 | Jefferson | West Virginia | 54037 | 4829 | 60 |
1546836 | 1546836 | 2021-07-23 | Brooke | West Virginia | 54009 | 2257 | 60 |
1546850 | 1546850 | 2021-07-23 | Jefferson | West Virginia | 54037 | 4829 | 60 |
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);