ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
213 rows where deaths = 92 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 |
---|---|---|---|---|---|---|---|
2431059 | 2431059 | 2022-04-21 | Mason | West Virginia | 54053 | 6655 | 92 |
2427803 | 2427803 | 2022-04-20 | Mason | West Virginia | 54053 | 6654 | 92 |
2424547 | 2424547 | 2022-04-19 | Mason | West Virginia | 54053 | 6653 | 92 |
2421291 | 2421291 | 2022-04-18 | Mason | West Virginia | 54053 | 6651 | 92 |
2418035 | 2418035 | 2022-04-17 | Mason | West Virginia | 54053 | 6647 | 92 |
2414779 | 2414779 | 2022-04-16 | Mason | West Virginia | 54053 | 6647 | 92 |
2411523 | 2411523 | 2022-04-15 | Mason | West Virginia | 54053 | 6647 | 92 |
2408267 | 2408267 | 2022-04-14 | Mason | West Virginia | 54053 | 6645 | 92 |
2405011 | 2405011 | 2022-04-13 | Mason | West Virginia | 54053 | 6643 | 92 |
2401756 | 2401756 | 2022-04-12 | Mason | West Virginia | 54053 | 6642 | 92 |
2398501 | 2398501 | 2022-04-11 | Mason | West Virginia | 54053 | 6641 | 92 |
2395246 | 2395246 | 2022-04-10 | Mason | West Virginia | 54053 | 6641 | 92 |
2391990 | 2391990 | 2022-04-09 | Mason | West Virginia | 54053 | 6641 | 92 |
2388734 | 2388734 | 2022-04-08 | Mason | West Virginia | 54053 | 6641 | 92 |
2385479 | 2385479 | 2022-04-07 | Mason | West Virginia | 54053 | 6641 | 92 |
2378992 | 2378992 | 2022-04-05 | Upshur | West Virginia | 54097 | 6816 | 92 |
2375715 | 2375715 | 2022-04-04 | Mason | West Virginia | 54053 | 6638 | 92 |
2375738 | 2375738 | 2022-04-04 | Upshur | West Virginia | 54097 | 6816 | 92 |
2372463 | 2372463 | 2022-04-03 | Mason | West Virginia | 54053 | 6636 | 92 |
2372486 | 2372486 | 2022-04-03 | Upshur | West Virginia | 54097 | 6814 | 92 |
2369210 | 2369210 | 2022-04-02 | Mason | West Virginia | 54053 | 6636 | 92 |
2369233 | 2369233 | 2022-04-02 | Upshur | West Virginia | 54097 | 6814 | 92 |
2365957 | 2365957 | 2022-04-01 | Mason | West Virginia | 54053 | 6636 | 92 |
2365980 | 2365980 | 2022-04-01 | Upshur | West Virginia | 54097 | 6814 | 92 |
2362727 | 2362727 | 2022-03-31 | Upshur | West Virginia | 54097 | 6813 | 92 |
2359458 | 2359458 | 2022-03-30 | Nicholas | West Virginia | 54067 | 7295 | 92 |
2359473 | 2359473 | 2022-03-30 | Upshur | West Virginia | 54097 | 6811 | 92 |
2356204 | 2356204 | 2022-03-29 | Nicholas | West Virginia | 54067 | 7294 | 92 |
2352951 | 2352951 | 2022-03-28 | Nicholas | West Virginia | 54067 | 7290 | 92 |
2349699 | 2349699 | 2022-03-27 | Nicholas | West Virginia | 54067 | 7287 | 92 |
2346446 | 2346446 | 2022-03-26 | Nicholas | West Virginia | 54067 | 7287 | 92 |
2343193 | 2343193 | 2022-03-25 | Nicholas | West Virginia | 54067 | 7287 | 92 |
2339940 | 2339940 | 2022-03-24 | Nicholas | West Virginia | 54067 | 7287 | 92 |
2336687 | 2336687 | 2022-03-23 | Nicholas | West Virginia | 54067 | 7284 | 92 |
2333433 | 2333433 | 2022-03-22 | Nicholas | West Virginia | 54067 | 7281 | 92 |
2330179 | 2330179 | 2022-03-21 | Nicholas | West Virginia | 54067 | 7281 | 92 |
2326927 | 2326927 | 2022-03-20 | Nicholas | West Virginia | 54067 | 7273 | 92 |
2323674 | 2323674 | 2022-03-19 | Nicholas | West Virginia | 54067 | 7273 | 92 |
2320420 | 2320420 | 2022-03-18 | Nicholas | West Virginia | 54067 | 7273 | 92 |
2317166 | 2317166 | 2022-03-17 | Nicholas | West Virginia | 54067 | 7272 | 92 |
2313913 | 2313913 | 2022-03-16 | Nicholas | West Virginia | 54067 | 7268 | 92 |
2310660 | 2310660 | 2022-03-15 | Nicholas | West Virginia | 54067 | 7263 | 92 |
2307407 | 2307407 | 2022-03-14 | Nicholas | West Virginia | 54067 | 7260 | 92 |
2304156 | 2304156 | 2022-03-13 | Nicholas | West Virginia | 54067 | 7248 | 92 |
2300904 | 2300904 | 2022-03-12 | Nicholas | West Virginia | 54067 | 7248 | 92 |
2297652 | 2297652 | 2022-03-11 | Nicholas | West Virginia | 54067 | 7248 | 92 |
2294400 | 2294400 | 2022-03-10 | Nicholas | West Virginia | 54067 | 7239 | 92 |
2031012 | 2031012 | 2021-12-19 | Wayne | West Virginia | 54099 | 6331 | 92 |
2027761 | 2027761 | 2021-12-18 | Wayne | West Virginia | 54099 | 6327 | 92 |
2024510 | 2024510 | 2021-12-17 | Wayne | West Virginia | 54099 | 6306 | 92 |
2021259 | 2021259 | 2021-12-16 | Wayne | West Virginia | 54099 | 6284 | 92 |
2018008 | 2018008 | 2021-12-15 | Wayne | West Virginia | 54099 | 6257 | 92 |
2014758 | 2014758 | 2021-12-14 | Wayne | West Virginia | 54099 | 6251 | 92 |
2011507 | 2011507 | 2021-12-13 | Wayne | West Virginia | 54099 | 6230 | 92 |
2008256 | 2008256 | 2021-12-12 | Wayne | West Virginia | 54099 | 6217 | 92 |
2005005 | 2005005 | 2021-12-11 | Wayne | West Virginia | 54099 | 6209 | 92 |
2001754 | 2001754 | 2021-12-10 | Wayne | West Virginia | 54099 | 6192 | 92 |
1998504 | 1998504 | 2021-12-09 | Wayne | West Virginia | 54099 | 6173 | 92 |
1995233 | 1995233 | 2021-12-08 | Mingo | West Virginia | 54059 | 5085 | 92 |
1988720 | 1988720 | 2021-12-06 | Jefferson | West Virginia | 54037 | 7703 | 92 |
1985470 | 1985470 | 2021-12-05 | Jefferson | West Virginia | 54037 | 7679 | 92 |
1982220 | 1982220 | 2021-12-04 | Jefferson | West Virginia | 54037 | 7653 | 92 |
1978970 | 1978970 | 2021-12-03 | Jefferson | West Virginia | 54037 | 7601 | 92 |
1975720 | 1975720 | 2021-12-02 | Jefferson | West Virginia | 54037 | 7544 | 92 |
1972471 | 1972471 | 2021-12-01 | Jefferson | West Virginia | 54037 | 7485 | 92 |
1969220 | 1969220 | 2021-11-30 | Jackson | West Virginia | 54035 | 4258 | 92 |
1969221 | 1969221 | 2021-11-30 | Jefferson | West Virginia | 54037 | 7438 | 92 |
1965970 | 1965970 | 2021-11-29 | Jackson | West Virginia | 54035 | 4245 | 92 |
1962718 | 1962718 | 2021-11-28 | Jackson | West Virginia | 54035 | 4212 | 92 |
1959467 | 1959467 | 2021-11-27 | Jackson | West Virginia | 54035 | 4212 | 92 |
1956216 | 1956216 | 2021-11-26 | Jackson | West Virginia | 54035 | 4212 | 92 |
1952965 | 1952965 | 2021-11-25 | Jackson | West Virginia | 54035 | 4212 | 92 |
1949714 | 1949714 | 2021-11-24 | Jackson | West Virginia | 54035 | 4212 | 92 |
1920482 | 1920482 | 2021-11-15 | Preston | West Virginia | 54077 | 5555 | 92 |
1745009 | 1745009 | 2021-09-22 | Marshall | West Virginia | 54051 | 4699 | 92 |
1741760 | 1741760 | 2021-09-21 | Marshall | West Virginia | 54051 | 4684 | 92 |
1738511 | 1738511 | 2021-09-20 | Marshall | West Virginia | 54051 | 4659 | 92 |
1735262 | 1735262 | 2021-09-19 | Marshall | West Virginia | 54051 | 4636 | 92 |
1732012 | 1732012 | 2021-09-18 | Marshall | West Virginia | 54051 | 4599 | 92 |
1728762 | 1728762 | 2021-09-17 | Marshall | West Virginia | 54051 | 4559 | 92 |
1725512 | 1725512 | 2021-09-16 | Marshall | West Virginia | 54051 | 4528 | 92 |
1725522 | 1725522 | 2021-09-16 | Ohio | West Virginia | 54069 | 5297 | 92 |
1722263 | 1722263 | 2021-09-15 | Marshall | West Virginia | 54051 | 4473 | 92 |
1722273 | 1722273 | 2021-09-15 | Ohio | West Virginia | 54069 | 5265 | 92 |
1719015 | 1719015 | 2021-09-14 | Marshall | West Virginia | 54051 | 4437 | 92 |
1719025 | 1719025 | 2021-09-14 | Ohio | West Virginia | 54069 | 5221 | 92 |
1715757 | 1715757 | 2021-09-13 | Hancock | West Virginia | 54029 | 3294 | 92 |
1715767 | 1715767 | 2021-09-13 | Marshall | West Virginia | 54051 | 4416 | 92 |
1715777 | 1715777 | 2021-09-13 | Ohio | West Virginia | 54069 | 5201 | 92 |
1712511 | 1712511 | 2021-09-12 | Hancock | West Virginia | 54029 | 3282 | 92 |
1712525 | 1712525 | 2021-09-12 | Mineral | West Virginia | 54057 | 3586 | 92 |
1709264 | 1709264 | 2021-09-11 | Hancock | West Virginia | 54029 | 3244 | 92 |
1709278 | 1709278 | 2021-09-11 | Mineral | West Virginia | 54057 | 3571 | 92 |
1706017 | 1706017 | 2021-09-10 | Hancock | West Virginia | 54029 | 3210 | 92 |
1706031 | 1706031 | 2021-09-10 | Mineral | West Virginia | 54057 | 3549 | 92 |
1702767 | 1702767 | 2021-09-09 | Hancock | West Virginia | 54029 | 3183 | 92 |
1702781 | 1702781 | 2021-09-09 | Mineral | West Virginia | 54057 | 3512 | 92 |
1699518 | 1699518 | 2021-09-08 | Hancock | West Virginia | 54029 | 3167 | 92 |
1699532 | 1699532 | 2021-09-08 | Mineral | West Virginia | 54057 | 3478 | 92 |
1696270 | 1696270 | 2021-09-07 | Hancock | West Virginia | 54029 | 3150 | 92 |
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);