ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where deaths = 109 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 |
---|---|---|---|---|---|---|---|
2352972 | 2352972 | 2022-03-28 | Wyoming | West Virginia | 54109 | 6969 | 109 |
2349720 | 2349720 | 2022-03-27 | Wyoming | West Virginia | 54109 | 6963 | 109 |
2346467 | 2346467 | 2022-03-26 | Wyoming | West Virginia | 54109 | 6963 | 109 |
2343214 | 2343214 | 2022-03-25 | Wyoming | West Virginia | 54109 | 6963 | 109 |
2219611 | 2219611 | 2022-02-15 | Mingo | West Virginia | 54059 | 7567 | 109 |
2128509 | 2128509 | 2022-01-18 | Jefferson | West Virginia | 54037 | 12372 | 109 |
2076480 | 2076480 | 2022-01-02 | Jackson | West Virginia | 54035 | 4584 | 109 |
2073229 | 2073229 | 2022-01-01 | Jackson | West Virginia | 54035 | 4584 | 109 |
2069978 | 2069978 | 2021-12-31 | Jackson | West Virginia | 54035 | 4584 | 109 |
2066727 | 2066727 | 2021-12-30 | Jackson | West Virginia | 54035 | 4584 | 109 |
2031001 | 2031001 | 2021-12-19 | Preston | West Virginia | 54077 | 6195 | 109 |
2027750 | 2027750 | 2021-12-18 | Preston | West Virginia | 54077 | 6181 | 109 |
2024499 | 2024499 | 2021-12-17 | Preston | West Virginia | 54077 | 6163 | 109 |
2021248 | 2021248 | 2021-12-16 | Preston | West Virginia | 54077 | 6151 | 109 |
2017997 | 2017997 | 2021-12-15 | Preston | West Virginia | 54077 | 6133 | 109 |
2014747 | 2014747 | 2021-12-14 | Preston | West Virginia | 54077 | 6119 | 109 |
2011496 | 2011496 | 2021-12-13 | Preston | West Virginia | 54077 | 6109 | 109 |
1988714 | 1988714 | 2021-12-06 | Greenbrier | West Virginia | 54025 | 5328 | 109 |
1985464 | 1985464 | 2021-12-05 | Greenbrier | West Virginia | 54025 | 5315 | 109 |
1982214 | 1982214 | 2021-12-04 | Greenbrier | West Virginia | 54025 | 5304 | 109 |
1978964 | 1978964 | 2021-12-03 | Greenbrier | West Virginia | 54025 | 5286 | 109 |
1975714 | 1975714 | 2021-12-02 | Greenbrier | West Virginia | 54025 | 5278 | 109 |
1904219 | 1904219 | 2021-11-10 | Marion | West Virginia | 54049 | 8504 | 109 |
1839235 | 1839235 | 2021-10-21 | Mineral | West Virginia | 54057 | 4542 | 109 |
1835986 | 1835986 | 2021-10-20 | Mineral | West Virginia | 54057 | 4530 | 109 |
1829474 | 1829474 | 2021-10-18 | Hancock | West Virginia | 54029 | 4062 | 109 |
1793729 | 1793729 | 2021-10-07 | Fayette | West Virginia | 54019 | 5672 | 109 |
1790480 | 1790480 | 2021-10-06 | Fayette | West Virginia | 54019 | 5633 | 109 |
1780764 | 1780764 | 2021-10-03 | Putnam | West Virginia | 54079 | 7995 | 109 |
1777514 | 1777514 | 2021-10-02 | Putnam | West Virginia | 54079 | 7975 | 109 |
1774264 | 1774264 | 2021-10-01 | Putnam | West Virginia | 54079 | 7891 | 109 |
1771014 | 1771014 | 2021-09-30 | Putnam | West Virginia | 54079 | 7825 | 109 |
1767765 | 1767765 | 2021-09-29 | Putnam | West Virginia | 54079 | 7757 | 109 |
1764516 | 1764516 | 2021-09-28 | Putnam | West Virginia | 54079 | 7710 | 109 |
1761267 | 1761267 | 2021-09-27 | Putnam | West Virginia | 54079 | 7685 | 109 |
1758019 | 1758019 | 2021-09-26 | Putnam | West Virginia | 54079 | 7666 | 109 |
1754771 | 1754771 | 2021-09-25 | Putnam | West Virginia | 54079 | 7628 | 109 |
1751523 | 1751523 | 2021-09-24 | Putnam | West Virginia | 54079 | 7558 | 109 |
1719013 | 1719013 | 2021-09-14 | Logan | West Virginia | 54045 | 4335 | 109 |
1715765 | 1715765 | 2021-09-13 | Logan | West Virginia | 54045 | 4293 | 109 |
1712519 | 1712519 | 2021-09-12 | Logan | West Virginia | 54045 | 4243 | 109 |
1709272 | 1709272 | 2021-09-11 | Logan | West Virginia | 54045 | 4199 | 109 |
1706025 | 1706025 | 2021-09-10 | Logan | West Virginia | 54045 | 4161 | 109 |
985248 | 985248 | 2021-01-31 | Wood | West Virginia | 54107 | 6530 | 109 |
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);