ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
173 rows where deaths = 51 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 |
---|---|---|---|---|---|---|---|
2352962 | 2352962 | 2022-03-28 | Summers | West Virginia | 54089 | 2802 | 51 |
2349710 | 2349710 | 2022-03-27 | Summers | West Virginia | 54089 | 2799 | 51 |
2346457 | 2346457 | 2022-03-26 | Summers | West Virginia | 54089 | 2799 | 51 |
2343204 | 2343204 | 2022-03-25 | Summers | West Virginia | 54089 | 2799 | 51 |
2190317 | 2190317 | 2022-02-06 | Grant | West Virginia | 54023 | 3596 | 51 |
2187064 | 2187064 | 2022-02-05 | Grant | West Virginia | 54023 | 3588 | 51 |
2183811 | 2183811 | 2022-02-04 | Grant | West Virginia | 54023 | 3566 | 51 |
2180559 | 2180559 | 2022-02-03 | Grant | West Virginia | 54023 | 3551 | 51 |
2177308 | 2177308 | 2022-02-02 | Grant | West Virginia | 54023 | 3524 | 51 |
2174055 | 2174055 | 2022-02-01 | Grant | West Virginia | 54023 | 3506 | 51 |
2170803 | 2170803 | 2022-01-31 | Grant | West Virginia | 54023 | 3495 | 51 |
2167550 | 2167550 | 2022-01-30 | Grant | West Virginia | 54023 | 3481 | 51 |
2164295 | 2164295 | 2022-01-29 | Grant | West Virginia | 54023 | 3477 | 51 |
2161040 | 2161040 | 2022-01-28 | Grant | West Virginia | 54023 | 3442 | 51 |
2157784 | 2157784 | 2022-01-27 | Grant | West Virginia | 54023 | 3383 | 51 |
2154531 | 2154531 | 2022-01-26 | Grant | West Virginia | 54023 | 3359 | 51 |
2151278 | 2151278 | 2022-01-25 | Grant | West Virginia | 54023 | 3322 | 51 |
2148026 | 2148026 | 2022-01-24 | Grant | West Virginia | 54023 | 3297 | 51 |
2089515 | 2089515 | 2022-01-06 | Taylor | West Virginia | 54091 | 3084 | 51 |
2086264 | 2086264 | 2022-01-05 | Taylor | West Virginia | 54091 | 3034 | 51 |
2083012 | 2083012 | 2022-01-04 | Taylor | West Virginia | 54091 | 3008 | 51 |
2079760 | 2079760 | 2022-01-03 | Taylor | West Virginia | 54091 | 2996 | 51 |
2076508 | 2076508 | 2022-01-02 | Taylor | West Virginia | 54091 | 2934 | 51 |
2073257 | 2073257 | 2022-01-01 | Taylor | West Virginia | 54091 | 2934 | 51 |
2070006 | 2070006 | 2021-12-31 | Taylor | West Virginia | 54091 | 2934 | 51 |
2066755 | 2066755 | 2021-12-30 | Taylor | West Virginia | 54091 | 2934 | 51 |
2034245 | 2034245 | 2021-12-20 | Morgan | West Virginia | 54065 | 2661 | 51 |
2030995 | 2030995 | 2021-12-19 | Morgan | West Virginia | 54065 | 2648 | 51 |
2027744 | 2027744 | 2021-12-18 | Morgan | West Virginia | 54065 | 2636 | 51 |
2024493 | 2024493 | 2021-12-17 | Morgan | West Virginia | 54065 | 2612 | 51 |
2021242 | 2021242 | 2021-12-16 | Morgan | West Virginia | 54065 | 2586 | 51 |
2017991 | 2017991 | 2021-12-15 | Morgan | West Virginia | 54065 | 2552 | 51 |
2014741 | 2014741 | 2021-12-14 | Morgan | West Virginia | 54065 | 2536 | 51 |
2011490 | 2011490 | 2021-12-13 | Morgan | West Virginia | 54065 | 2530 | 51 |
2008239 | 2008239 | 2021-12-12 | Morgan | West Virginia | 54065 | 2515 | 51 |
2004988 | 2004988 | 2021-12-11 | Morgan | West Virginia | 54065 | 2501 | 51 |
2001737 | 2001737 | 2021-12-10 | Morgan | West Virginia | 54065 | 2481 | 51 |
1985465 | 1985465 | 2021-12-05 | Hampshire | West Virginia | 54027 | 3773 | 51 |
1982215 | 1982215 | 2021-12-04 | Hampshire | West Virginia | 54027 | 3763 | 51 |
1978965 | 1978965 | 2021-12-03 | Hampshire | West Virginia | 54027 | 3753 | 51 |
1975715 | 1975715 | 2021-12-02 | Hampshire | West Virginia | 54027 | 3728 | 51 |
1969224 | 1969224 | 2021-11-30 | Lincoln | West Virginia | 54043 | 3223 | 51 |
1965974 | 1965974 | 2021-11-29 | Lincoln | West Virginia | 54043 | 3215 | 51 |
1946472 | 1946472 | 2021-11-23 | McDowell | West Virginia | 54047 | 3111 | 51 |
1939945 | 1939945 | 2021-11-21 | Barbour | West Virginia | 54001 | 2922 | 51 |
1936695 | 1936695 | 2021-11-20 | Barbour | West Virginia | 54001 | 2916 | 51 |
1933445 | 1933445 | 2021-11-19 | Barbour | West Virginia | 54001 | 2912 | 51 |
1930193 | 1930193 | 2021-11-18 | Barbour | West Virginia | 54001 | 2902 | 51 |
1930219 | 1930219 | 2021-11-18 | McDowell | West Virginia | 54047 | 3066 | 51 |
1926969 | 1926969 | 2021-11-17 | McDowell | West Virginia | 54047 | 3052 | 51 |
1923719 | 1923719 | 2021-11-16 | McDowell | West Virginia | 54047 | 3040 | 51 |
1920485 | 1920485 | 2021-11-15 | Randolph | West Virginia | 54083 | 5309 | 51 |
1917235 | 1917235 | 2021-11-14 | Randolph | West Virginia | 54083 | 5303 | 51 |
1913985 | 1913985 | 2021-11-13 | Randolph | West Virginia | 54083 | 5294 | 51 |
1910735 | 1910735 | 2021-11-12 | Randolph | West Virginia | 54083 | 5283 | 51 |
1907486 | 1907486 | 2021-11-11 | Randolph | West Virginia | 54083 | 5266 | 51 |
1900979 | 1900979 | 2021-11-09 | Nicholas | West Virginia | 54067 | 3914 | 51 |
1897729 | 1897729 | 2021-11-08 | Nicholas | West Virginia | 54067 | 3902 | 51 |
1858755 | 1858755 | 2021-10-27 | Wetzel | West Virginia | 54103 | 2546 | 51 |
1855506 | 1855506 | 2021-10-26 | Wetzel | West Virginia | 54103 | 2539 | 51 |
1852226 | 1852226 | 2021-10-25 | Lewis | West Virginia | 54041 | 3003 | 51 |
1832711 | 1832711 | 2021-10-19 | Boone | West Virginia | 54005 | 3441 | 51 |
1832734 | 1832734 | 2021-10-19 | Mason | West Virginia | 54053 | 3548 | 51 |
1829462 | 1829462 | 2021-10-18 | Boone | West Virginia | 54005 | 3425 | 51 |
1829485 | 1829485 | 2021-10-18 | Mason | West Virginia | 54053 | 3537 | 51 |
1826213 | 1826213 | 2021-10-17 | Boone | West Virginia | 54005 | 3416 | 51 |
1826236 | 1826236 | 2021-10-17 | Mason | West Virginia | 54053 | 3535 | 51 |
1822964 | 1822964 | 2021-10-16 | Boone | West Virginia | 54005 | 3408 | 51 |
1822987 | 1822987 | 2021-10-16 | Mason | West Virginia | 54053 | 3528 | 51 |
1819715 | 1819715 | 2021-10-15 | Boone | West Virginia | 54005 | 3392 | 51 |
1819738 | 1819738 | 2021-10-15 | Mason | West Virginia | 54053 | 3518 | 51 |
1787277 | 1787277 | 2021-10-05 | Wyoming | West Virginia | 54109 | 3317 | 51 |
1784028 | 1784028 | 2021-10-04 | Wyoming | West Virginia | 54109 | 3311 | 51 |
1780779 | 1780779 | 2021-10-03 | Wyoming | West Virginia | 54109 | 3300 | 51 |
1777529 | 1777529 | 2021-10-02 | Wyoming | West Virginia | 54109 | 3288 | 51 |
1774279 | 1774279 | 2021-10-01 | Wyoming | West Virginia | 54109 | 3275 | 51 |
1725537 | 1725537 | 2021-09-16 | Wayne | West Virginia | 54099 | 4404 | 51 |
1722288 | 1722288 | 2021-09-15 | Wayne | West Virginia | 54099 | 4359 | 51 |
1719040 | 1719040 | 2021-09-14 | Wayne | West Virginia | 54099 | 4315 | 51 |
1449461 | 1449461 | 2021-06-23 | Marion | West Virginia | 54049 | 4641 | 51 |
1446216 | 1446216 | 2021-06-22 | Marion | West Virginia | 54049 | 4634 | 51 |
1442971 | 1442971 | 2021-06-21 | Marion | West Virginia | 54049 | 4627 | 51 |
1439726 | 1439726 | 2021-06-20 | Marion | West Virginia | 54049 | 4627 | 51 |
1436479 | 1436479 | 2021-06-19 | Marion | West Virginia | 54049 | 4627 | 51 |
1433232 | 1433232 | 2021-06-18 | Marion | West Virginia | 54049 | 4627 | 51 |
1429986 | 1429986 | 2021-06-17 | Marion | West Virginia | 54049 | 4627 | 51 |
1426741 | 1426741 | 2021-06-16 | Marion | West Virginia | 54049 | 4626 | 51 |
1423495 | 1423495 | 2021-06-15 | Marion | West Virginia | 54049 | 4623 | 51 |
1420248 | 1420248 | 2021-06-14 | Marion | West Virginia | 54049 | 4621 | 51 |
1417003 | 1417003 | 2021-06-13 | Marion | West Virginia | 54049 | 4618 | 51 |
1413757 | 1413757 | 2021-06-12 | Marion | West Virginia | 54049 | 4618 | 51 |
1410512 | 1410512 | 2021-06-11 | Marion | West Virginia | 54049 | 4618 | 51 |
1407267 | 1407267 | 2021-06-10 | Marion | West Virginia | 54049 | 4614 | 51 |
1404021 | 1404021 | 2021-06-09 | Marion | West Virginia | 54049 | 4610 | 51 |
1400776 | 1400776 | 2021-06-08 | Marion | West Virginia | 54049 | 4604 | 51 |
1397531 | 1397531 | 2021-06-07 | Marion | West Virginia | 54049 | 4599 | 51 |
1394284 | 1394284 | 2021-06-06 | Marion | West Virginia | 54049 | 4579 | 51 |
1391039 | 1391039 | 2021-06-05 | Marion | West Virginia | 54049 | 4579 | 51 |
1387794 | 1387794 | 2021-06-04 | Marion | West Virginia | 54049 | 4579 | 51 |
1384549 | 1384549 | 2021-06-03 | Marion | West Virginia | 54049 | 4577 | 51 |
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);