ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
77 rows where deaths = 117 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 |
---|---|---|---|---|---|---|---|
2339956 | 2339956 | 2022-03-24 | Wayne | West Virginia | 54099 | 9802 | 117 |
2336703 | 2336703 | 2022-03-23 | Wayne | West Virginia | 54099 | 9798 | 117 |
2333449 | 2333449 | 2022-03-22 | Wayne | West Virginia | 54099 | 9797 | 117 |
2330195 | 2330195 | 2022-03-21 | Wayne | West Virginia | 54099 | 9794 | 117 |
2326943 | 2326943 | 2022-03-20 | Wayne | West Virginia | 54099 | 9789 | 117 |
2323690 | 2323690 | 2022-03-19 | Wayne | West Virginia | 54099 | 9789 | 117 |
2320436 | 2320436 | 2022-03-18 | Wayne | West Virginia | 54099 | 9789 | 117 |
2317182 | 2317182 | 2022-03-17 | Wayne | West Virginia | 54099 | 9783 | 117 |
2261874 | 2261874 | 2022-02-28 | Mingo | West Virginia | 54059 | 7774 | 117 |
2200085 | 2200085 | 2022-02-09 | Jackson | West Virginia | 54035 | 6513 | 117 |
2196831 | 2196831 | 2022-02-08 | Jackson | West Virginia | 54035 | 6478 | 117 |
2193576 | 2193576 | 2022-02-07 | Jackson | West Virginia | 54035 | 6469 | 117 |
2190323 | 2190323 | 2022-02-06 | Jackson | West Virginia | 54035 | 6450 | 117 |
2190324 | 2190324 | 2022-02-06 | Jefferson | West Virginia | 54037 | 13711 | 117 |
2187070 | 2187070 | 2022-02-05 | Jackson | West Virginia | 54035 | 6438 | 117 |
2187071 | 2187071 | 2022-02-05 | Jefferson | West Virginia | 54037 | 13691 | 117 |
2183817 | 2183817 | 2022-02-04 | Jackson | West Virginia | 54035 | 6393 | 117 |
2183818 | 2183818 | 2022-02-04 | Jefferson | West Virginia | 54037 | 13651 | 117 |
2180566 | 2180566 | 2022-02-03 | Jefferson | West Virginia | 54037 | 13607 | 117 |
2177315 | 2177315 | 2022-02-02 | Jefferson | West Virginia | 54037 | 13536 | 117 |
2174062 | 2174062 | 2022-02-01 | Jefferson | West Virginia | 54037 | 13508 | 117 |
2174082 | 2174082 | 2022-02-01 | Preston | West Virginia | 54077 | 8225 | 117 |
2170830 | 2170830 | 2022-01-31 | Preston | West Virginia | 54077 | 8198 | 117 |
2167577 | 2167577 | 2022-01-30 | Preston | West Virginia | 54077 | 8183 | 117 |
2164322 | 2164322 | 2022-01-29 | Preston | West Virginia | 54077 | 8144 | 117 |
2161067 | 2161067 | 2022-01-28 | Preston | West Virginia | 54077 | 8083 | 117 |
2157811 | 2157811 | 2022-01-27 | Preston | West Virginia | 54077 | 8038 | 117 |
2056973 | 2056973 | 2021-12-27 | Greenbrier | West Virginia | 54025 | 5746 | 117 |
1946474 | 1946474 | 2021-11-23 | Mineral | West Virginia | 54057 | 4865 | 117 |
1943209 | 1943209 | 2021-11-22 | Hancock | West Virginia | 54029 | 4514 | 117 |
1943219 | 1943219 | 2021-11-22 | Marshall | West Virginia | 54051 | 5603 | 117 |
1939968 | 1939968 | 2021-11-21 | Marion | West Virginia | 54049 | 8826 | 117 |
1939969 | 1939969 | 2021-11-21 | Marshall | West Virginia | 54051 | 5592 | 117 |
1936718 | 1936718 | 2021-11-20 | Marion | West Virginia | 54049 | 8802 | 117 |
1936719 | 1936719 | 2021-11-20 | Marshall | West Virginia | 54051 | 5572 | 117 |
1933468 | 1933468 | 2021-11-19 | Marion | West Virginia | 54049 | 8784 | 117 |
1933469 | 1933469 | 2021-11-19 | Marshall | West Virginia | 54051 | 5563 | 117 |
1930217 | 1930217 | 2021-11-18 | Marshall | West Virginia | 54051 | 5541 | 117 |
1930221 | 1930221 | 2021-11-18 | Mineral | West Virginia | 54057 | 4857 | 117 |
1926967 | 1926967 | 2021-11-17 | Marshall | West Virginia | 54051 | 5514 | 117 |
1926971 | 1926971 | 2021-11-17 | Mineral | West Virginia | 54057 | 4845 | 117 |
1923707 | 1923707 | 2021-11-16 | Hancock | West Virginia | 54029 | 4418 | 117 |
1923717 | 1923717 | 2021-11-16 | Marshall | West Virginia | 54051 | 5492 | 117 |
1923721 | 1923721 | 2021-11-16 | Mineral | West Virginia | 54057 | 4831 | 117 |
1920458 | 1920458 | 2021-11-15 | Hancock | West Virginia | 54029 | 4408 | 117 |
1920472 | 1920472 | 2021-11-15 | Mineral | West Virginia | 54057 | 4824 | 117 |
1917208 | 1917208 | 2021-11-14 | Hancock | West Virginia | 54029 | 4399 | 117 |
1917222 | 1917222 | 2021-11-14 | Mineral | West Virginia | 54057 | 4816 | 117 |
1913958 | 1913958 | 2021-11-13 | Hancock | West Virginia | 54029 | 4395 | 117 |
1913972 | 1913972 | 2021-11-13 | Mineral | West Virginia | 54057 | 4812 | 117 |
1910708 | 1910708 | 2021-11-12 | Hancock | West Virginia | 54029 | 4392 | 117 |
1910722 | 1910722 | 2021-11-12 | Mineral | West Virginia | 54057 | 4790 | 117 |
1907459 | 1907459 | 2021-11-11 | Hancock | West Virginia | 54029 | 4384 | 117 |
1907473 | 1907473 | 2021-11-11 | Mineral | West Virginia | 54057 | 4785 | 117 |
1904210 | 1904210 | 2021-11-10 | Hancock | West Virginia | 54029 | 4371 | 117 |
1904224 | 1904224 | 2021-11-10 | Mineral | West Virginia | 54057 | 4764 | 117 |
1900960 | 1900960 | 2021-11-09 | Hancock | West Virginia | 54029 | 4362 | 117 |
1897710 | 1897710 | 2021-11-08 | Hancock | West Virginia | 54029 | 4352 | 117 |
1829499 | 1829499 | 2021-10-18 | Putnam | West Virginia | 54079 | 8519 | 117 |
1764499 | 1764499 | 2021-09-28 | Logan | West Virginia | 54045 | 4817 | 117 |
1761250 | 1761250 | 2021-09-27 | Logan | West Virginia | 54045 | 4785 | 117 |
1758002 | 1758002 | 2021-09-26 | Logan | West Virginia | 54045 | 4753 | 117 |
1754754 | 1754754 | 2021-09-25 | Logan | West Virginia | 54045 | 4729 | 117 |
1751506 | 1751506 | 2021-09-24 | Logan | West Virginia | 54045 | 4707 | 117 |
1712537 | 1712537 | 2021-09-12 | Raleigh | West Virginia | 54081 | 9121 | 117 |
1709290 | 1709290 | 2021-09-11 | Raleigh | West Virginia | 54081 | 9036 | 117 |
1706043 | 1706043 | 2021-09-10 | Raleigh | West Virginia | 54081 | 8919 | 117 |
1355341 | 1355341 | 2021-05-25 | Mercer | West Virginia | 54055 | 5015 | 117 |
1352095 | 1352095 | 2021-05-24 | Mercer | West Virginia | 54055 | 4999 | 117 |
1348849 | 1348849 | 2021-05-23 | Mercer | West Virginia | 54055 | 4962 | 117 |
1345601 | 1345601 | 2021-05-22 | Mercer | West Virginia | 54055 | 4962 | 117 |
1342353 | 1342353 | 2021-05-21 | Mercer | West Virginia | 54055 | 4962 | 117 |
1339105 | 1339105 | 2021-05-20 | Mercer | West Virginia | 54055 | 4943 | 117 |
1118301 | 1118301 | 2021-03-13 | Mercer | West Virginia | 54055 | 4282 | 117 |
1115054 | 1115054 | 2021-03-12 | Mercer | West Virginia | 54055 | 4276 | 117 |
917048 | 917048 | 2021-01-10 | Cabell | West Virginia | 54011 | 6025 | 117 |
913803 | 913803 | 2021-01-09 | Cabell | West Virginia | 54011 | 5976 | 117 |
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);