ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where deaths = 140 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 |
---|---|---|---|---|---|---|---|
2356185 | 2356185 | 2022-03-29 | Hancock | West Virginia | 54029 | 6689 | 140 |
2352932 | 2352932 | 2022-03-28 | Hancock | West Virginia | 54029 | 6687 | 140 |
2349680 | 2349680 | 2022-03-27 | Hancock | West Virginia | 54029 | 6683 | 140 |
2346427 | 2346427 | 2022-03-26 | Hancock | West Virginia | 54029 | 6683 | 140 |
2343174 | 2343174 | 2022-03-25 | Hancock | West Virginia | 54029 | 6683 | 140 |
2339921 | 2339921 | 2022-03-24 | Hancock | West Virginia | 54029 | 6681 | 140 |
2336668 | 2336668 | 2022-03-23 | Hancock | West Virginia | 54029 | 6680 | 140 |
2333414 | 2333414 | 2022-03-22 | Hancock | West Virginia | 54029 | 6676 | 140 |
2330160 | 2330160 | 2022-03-21 | Hancock | West Virginia | 54029 | 6676 | 140 |
2326908 | 2326908 | 2022-03-20 | Hancock | West Virginia | 54029 | 6674 | 140 |
2323655 | 2323655 | 2022-03-19 | Hancock | West Virginia | 54029 | 6674 | 140 |
2320401 | 2320401 | 2022-03-18 | Hancock | West Virginia | 54029 | 6674 | 140 |
2317147 | 2317147 | 2022-03-17 | Hancock | West Virginia | 54029 | 6671 | 140 |
2313894 | 2313894 | 2022-03-16 | Hancock | West Virginia | 54029 | 6669 | 140 |
2310641 | 2310641 | 2022-03-15 | Hancock | West Virginia | 54029 | 6666 | 140 |
2307388 | 2307388 | 2022-03-14 | Hancock | West Virginia | 54029 | 6664 | 140 |
2304137 | 2304137 | 2022-03-13 | Hancock | West Virginia | 54029 | 6660 | 140 |
2300885 | 2300885 | 2022-03-12 | Hancock | West Virginia | 54029 | 6660 | 140 |
2297633 | 2297633 | 2022-03-11 | Hancock | West Virginia | 54029 | 6660 | 140 |
2294381 | 2294381 | 2022-03-10 | Hancock | West Virginia | 54029 | 6657 | 140 |
2291129 | 2291129 | 2022-03-09 | Hancock | West Virginia | 54029 | 6656 | 140 |
2287877 | 2287877 | 2022-03-08 | Hancock | West Virginia | 54029 | 6649 | 140 |
2265107 | 2265107 | 2022-03-01 | Greenbrier | West Virginia | 54025 | 9285 | 140 |
2261857 | 2261857 | 2022-02-28 | Greenbrier | West Virginia | 54025 | 9273 | 140 |
2258606 | 2258606 | 2022-02-27 | Greenbrier | West Virginia | 54025 | 9214 | 140 |
2255355 | 2255355 | 2022-02-26 | Greenbrier | West Virginia | 54025 | 9214 | 140 |
2252104 | 2252104 | 2022-02-25 | Greenbrier | West Virginia | 54025 | 9214 | 140 |
2248853 | 2248853 | 2022-02-24 | Greenbrier | West Virginia | 54025 | 9191 | 140 |
2154554 | 2154554 | 2022-01-26 | Ohio | West Virginia | 54069 | 10016 | 140 |
2144791 | 2144791 | 2022-01-23 | Mineral | West Virginia | 54057 | 6893 | 140 |
2141536 | 2141536 | 2022-01-22 | Mineral | West Virginia | 54057 | 6791 | 140 |
2138280 | 2138280 | 2022-01-21 | Mineral | West Virginia | 54057 | 6726 | 140 |
2135025 | 2135025 | 2022-01-20 | Mineral | West Virginia | 54057 | 6675 | 140 |
2105750 | 2105750 | 2022-01-11 | Marion | West Virginia | 54049 | 10789 | 140 |
2102499 | 2102499 | 2022-01-10 | Marion | West Virginia | 54049 | 10718 | 140 |
2099248 | 2099248 | 2022-01-09 | Marion | West Virginia | 54049 | 10649 | 140 |
2095997 | 2095997 | 2022-01-08 | Marion | West Virginia | 54049 | 10591 | 140 |
2092745 | 2092745 | 2022-01-07 | Marion | West Virginia | 54049 | 10471 | 140 |
2089493 | 2089493 | 2022-01-06 | Marion | West Virginia | 54049 | 10345 | 140 |
2086242 | 2086242 | 2022-01-05 | Marion | West Virginia | 54049 | 10225 | 140 |
2082990 | 2082990 | 2022-01-04 | Marion | West Virginia | 54049 | 10140 | 140 |
2079738 | 2079738 | 2022-01-03 | Marion | West Virginia | 54049 | 10105 | 140 |
2076486 | 2076486 | 2022-01-02 | Marion | West Virginia | 54049 | 9876 | 140 |
2073235 | 2073235 | 2022-01-01 | Marion | West Virginia | 54049 | 9876 | 140 |
2069984 | 2069984 | 2021-12-31 | Marion | West Virginia | 54049 | 9876 | 140 |
2066733 | 2066733 | 2021-12-30 | Marion | West Virginia | 54049 | 9876 | 140 |
2063483 | 2063483 | 2021-12-29 | Marion | West Virginia | 54049 | 9812 | 140 |
2056984 | 2056984 | 2021-12-27 | Marion | West Virginia | 54049 | 9729 | 140 |
2053735 | 2053735 | 2021-12-26 | Marion | West Virginia | 54049 | 9623 | 140 |
2050485 | 2050485 | 2021-12-25 | Marion | West Virginia | 54049 | 9623 | 140 |
2047235 | 2047235 | 2021-12-24 | Marion | West Virginia | 54049 | 9623 | 140 |
2043985 | 2043985 | 2021-12-23 | Marion | West Virginia | 54049 | 9623 | 140 |
2040736 | 2040736 | 2021-12-22 | Marion | West Virginia | 54049 | 9584 | 140 |
1998464 | 1998464 | 2021-12-09 | Fayette | West Virginia | 54019 | 7017 | 140 |
1995213 | 1995213 | 2021-12-08 | Fayette | West Virginia | 54019 | 6985 | 140 |
1991962 | 1991962 | 2021-12-07 | Fayette | West Virginia | 54019 | 6973 | 140 |
1972492 | 1972492 | 2021-12-01 | Putnam | West Virginia | 54079 | 9755 | 140 |
1939967 | 1939967 | 2021-11-21 | Logan | West Virginia | 54045 | 5607 | 140 |
1936717 | 1936717 | 2021-11-20 | Logan | West Virginia | 54045 | 5599 | 140 |
1933467 | 1933467 | 2021-11-19 | Logan | West Virginia | 54045 | 5594 | 140 |
1930215 | 1930215 | 2021-11-18 | Logan | West Virginia | 54045 | 5572 | 140 |
1926965 | 1926965 | 2021-11-17 | Logan | West Virginia | 54045 | 5558 | 140 |
1923715 | 1923715 | 2021-11-16 | Logan | West Virginia | 54045 | 5544 | 140 |
1920466 | 1920466 | 2021-11-15 | Logan | West Virginia | 54045 | 5532 | 140 |
1917216 | 1917216 | 2021-11-14 | Logan | West Virginia | 54045 | 5525 | 140 |
1913966 | 1913966 | 2021-11-13 | Logan | West Virginia | 54045 | 5519 | 140 |
1910716 | 1910716 | 2021-11-12 | Logan | West Virginia | 54045 | 5502 | 140 |
1907467 | 1907467 | 2021-11-11 | Logan | West Virginia | 54045 | 5482 | 140 |
1904218 | 1904218 | 2021-11-10 | Logan | West Virginia | 54045 | 5467 | 140 |
1878228 | 1878228 | 2021-11-02 | Monongalia | West Virginia | 54061 | 13539 | 140 |
1874979 | 1874979 | 2021-11-01 | Monongalia | West Virginia | 54061 | 13521 | 140 |
1848972 | 1848972 | 2021-10-24 | Harrison | West Virginia | 54033 | 11017 | 140 |
1845722 | 1845722 | 2021-10-23 | Harrison | West Virginia | 54033 | 10993 | 140 |
1842472 | 1842472 | 2021-10-22 | Harrison | West Virginia | 54033 | 10939 | 140 |
1634533 | 1634533 | 2021-08-19 | Berkeley | West Virginia | 54003 | 13794 | 140 |
1631285 | 1631285 | 2021-08-18 | Berkeley | West Virginia | 54003 | 13702 | 140 |
1628038 | 1628038 | 2021-08-17 | Berkeley | West Virginia | 54003 | 13645 | 140 |
774268 | 774268 | 2020-11-27 | Kanawha | West Virginia | 54039 | 5531 | 140 |
771023 | 771023 | 2020-11-26 | Kanawha | West Virginia | 54039 | 5480 | 140 |
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);