ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
258 rows where deaths = 41 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 |
---|---|---|---|---|---|---|---|
2502690 | 2502690 | 2022-05-13 | Clay | West Virginia | 54015 | 2351 | 41 |
2499432 | 2499432 | 2022-05-12 | Clay | West Virginia | 54015 | 2348 | 41 |
2496174 | 2496174 | 2022-05-11 | Clay | West Virginia | 54015 | 2348 | 41 |
2492916 | 2492916 | 2022-05-10 | Clay | West Virginia | 54015 | 2345 | 41 |
2489658 | 2489658 | 2022-05-09 | Clay | West Virginia | 54015 | 2345 | 41 |
2486401 | 2486401 | 2022-05-08 | Clay | West Virginia | 54015 | 2343 | 41 |
2483143 | 2483143 | 2022-05-07 | Clay | West Virginia | 54015 | 2343 | 41 |
2479885 | 2479885 | 2022-05-06 | Clay | West Virginia | 54015 | 2343 | 41 |
2476627 | 2476627 | 2022-05-05 | Clay | West Virginia | 54015 | 2343 | 41 |
2473369 | 2473369 | 2022-05-04 | Clay | West Virginia | 54015 | 2343 | 41 |
2470112 | 2470112 | 2022-05-03 | Clay | West Virginia | 54015 | 2343 | 41 |
2466856 | 2466856 | 2022-05-02 | Clay | West Virginia | 54015 | 2343 | 41 |
2463601 | 2463601 | 2022-05-01 | Clay | West Virginia | 54015 | 2343 | 41 |
2460345 | 2460345 | 2022-04-30 | Clay | West Virginia | 54015 | 2343 | 41 |
2457089 | 2457089 | 2022-04-29 | Clay | West Virginia | 54015 | 2343 | 41 |
2453833 | 2453833 | 2022-04-28 | Clay | West Virginia | 54015 | 2343 | 41 |
2450577 | 2450577 | 2022-04-27 | Clay | West Virginia | 54015 | 2343 | 41 |
2447321 | 2447321 | 2022-04-26 | Clay | West Virginia | 54015 | 2343 | 41 |
2444065 | 2444065 | 2022-04-25 | Clay | West Virginia | 54015 | 2343 | 41 |
2440809 | 2440809 | 2022-04-24 | Clay | West Virginia | 54015 | 2340 | 41 |
2437553 | 2437553 | 2022-04-23 | Clay | West Virginia | 54015 | 2340 | 41 |
2434297 | 2434297 | 2022-04-22 | Clay | West Virginia | 54015 | 2340 | 41 |
2431041 | 2431041 | 2022-04-21 | Clay | West Virginia | 54015 | 2340 | 41 |
2427785 | 2427785 | 2022-04-20 | Clay | West Virginia | 54015 | 2340 | 41 |
2424529 | 2424529 | 2022-04-19 | Clay | West Virginia | 54015 | 2340 | 41 |
2375697 | 2375697 | 2022-04-04 | Clay | West Virginia | 54015 | 2341 | 41 |
2372445 | 2372445 | 2022-04-03 | Clay | West Virginia | 54015 | 2339 | 41 |
2369192 | 2369192 | 2022-04-02 | Clay | West Virginia | 54015 | 2339 | 41 |
2365939 | 2365939 | 2022-04-01 | Clay | West Virginia | 54015 | 2339 | 41 |
2362686 | 2362686 | 2022-03-31 | Clay | West Virginia | 54015 | 2339 | 41 |
2307405 | 2307405 | 2022-03-14 | Monroe | West Virginia | 54063 | 4167 | 41 |
2304154 | 2304154 | 2022-03-13 | Monroe | West Virginia | 54063 | 4166 | 41 |
2300902 | 2300902 | 2022-03-12 | Monroe | West Virginia | 54063 | 4166 | 41 |
2297650 | 2297650 | 2022-03-11 | Monroe | West Virginia | 54063 | 4166 | 41 |
2294398 | 2294398 | 2022-03-10 | Monroe | West Virginia | 54063 | 4164 | 41 |
2291146 | 2291146 | 2022-03-09 | Monroe | West Virginia | 54063 | 4160 | 41 |
2265098 | 2265098 | 2022-03-01 | Braxton | West Virginia | 54007 | 3769 | 41 |
2261848 | 2261848 | 2022-02-28 | Braxton | West Virginia | 54007 | 3717 | 41 |
2258597 | 2258597 | 2022-02-27 | Braxton | West Virginia | 54007 | 3699 | 41 |
2255346 | 2255346 | 2022-02-26 | Braxton | West Virginia | 54007 | 3699 | 41 |
2252095 | 2252095 | 2022-02-25 | Braxton | West Virginia | 54007 | 3699 | 41 |
2122001 | 2122001 | 2022-01-16 | Hardy | West Virginia | 54031 | 3507 | 41 |
2118749 | 2118749 | 2022-01-15 | Hardy | West Virginia | 54031 | 3478 | 41 |
2115497 | 2115497 | 2022-01-14 | Hardy | West Virginia | 54031 | 3439 | 41 |
2112245 | 2112245 | 2022-01-13 | Hardy | West Virginia | 54031 | 3406 | 41 |
2108993 | 2108993 | 2022-01-12 | Hardy | West Virginia | 54031 | 3363 | 41 |
2105742 | 2105742 | 2022-01-11 | Hardy | West Virginia | 54031 | 3305 | 41 |
2105771 | 2105771 | 2022-01-11 | Summers | West Virginia | 54089 | 1862 | 41 |
2102491 | 2102491 | 2022-01-10 | Hardy | West Virginia | 54031 | 3293 | 41 |
2102520 | 2102520 | 2022-01-10 | Summers | West Virginia | 54089 | 1850 | 41 |
2099240 | 2099240 | 2022-01-09 | Hardy | West Virginia | 54031 | 3284 | 41 |
2095989 | 2095989 | 2022-01-08 | Hardy | West Virginia | 54031 | 3274 | 41 |
2092737 | 2092737 | 2022-01-07 | Hardy | West Virginia | 54031 | 3246 | 41 |
2089485 | 2089485 | 2022-01-06 | Hardy | West Virginia | 54031 | 3179 | 41 |
2086234 | 2086234 | 2022-01-05 | Hardy | West Virginia | 54031 | 3126 | 41 |
2082982 | 2082982 | 2022-01-04 | Hardy | West Virginia | 54031 | 3078 | 41 |
2079730 | 2079730 | 2022-01-03 | Hardy | West Virginia | 54031 | 3061 | 41 |
1991964 | 1991964 | 2021-12-07 | Grant | West Virginia | 54023 | 2516 | 41 |
1939990 | 1939990 | 2021-11-21 | Taylor | West Virginia | 54091 | 2532 | 41 |
1936740 | 1936740 | 2021-11-20 | Taylor | West Virginia | 54091 | 2523 | 41 |
1933490 | 1933490 | 2021-11-19 | Taylor | West Virginia | 54091 | 2510 | 41 |
1930238 | 1930238 | 2021-11-18 | Taylor | West Virginia | 54091 | 2501 | 41 |
1926988 | 1926988 | 2021-11-17 | Taylor | West Virginia | 54091 | 2493 | 41 |
1858736 | 1858736 | 2021-10-27 | Morgan | West Virginia | 54065 | 2094 | 41 |
1855487 | 1855487 | 2021-10-26 | Morgan | West Virginia | 54065 | 2089 | 41 |
1852238 | 1852238 | 2021-10-25 | Morgan | West Virginia | 54065 | 2085 | 41 |
1848988 | 1848988 | 2021-10-24 | Morgan | West Virginia | 54065 | 2083 | 41 |
1845738 | 1845738 | 2021-10-23 | Morgan | West Virginia | 54065 | 2075 | 41 |
1842488 | 1842488 | 2021-10-22 | Morgan | West Virginia | 54065 | 2073 | 41 |
1839239 | 1839239 | 2021-10-21 | Morgan | West Virginia | 54065 | 2064 | 41 |
1816485 | 1816485 | 2021-10-14 | Lincoln | West Virginia | 54043 | 2642 | 41 |
1813237 | 1813237 | 2021-10-13 | Lincoln | West Virginia | 54043 | 2623 | 41 |
1813257 | 1813257 | 2021-10-13 | Randolph | West Virginia | 54083 | 4905 | 41 |
1809988 | 1809988 | 2021-10-12 | Lincoln | West Virginia | 54043 | 2612 | 41 |
1810008 | 1810008 | 2021-10-12 | Randolph | West Virginia | 54083 | 4894 | 41 |
1806739 | 1806739 | 2021-10-11 | Lincoln | West Virginia | 54043 | 2608 | 41 |
1803488 | 1803488 | 2021-10-10 | Lincoln | West Virginia | 54043 | 2590 | 41 |
1800239 | 1800239 | 2021-10-09 | Lincoln | West Virginia | 54043 | 2577 | 41 |
1796990 | 1796990 | 2021-10-08 | Lincoln | West Virginia | 54043 | 2563 | 41 |
1793740 | 1793740 | 2021-10-07 | Lewis | West Virginia | 54041 | 2760 | 41 |
1780725 | 1780725 | 2021-10-03 | Barbour | West Virginia | 54001 | 2452 | 41 |
1777475 | 1777475 | 2021-10-02 | Barbour | West Virginia | 54001 | 2448 | 41 |
1774225 | 1774225 | 2021-10-01 | Barbour | West Virginia | 54001 | 2439 | 41 |
1770977 | 1770977 | 2021-09-30 | Boone | West Virginia | 54005 | 3147 | 41 |
1767728 | 1767728 | 2021-09-29 | Boone | West Virginia | 54005 | 3118 | 41 |
1767777 | 1767777 | 2021-09-29 | Wetzel | West Virginia | 54103 | 2267 | 41 |
1761241 | 1761241 | 2021-09-27 | Hampshire | West Virginia | 54027 | 2742 | 41 |
1757993 | 1757993 | 2021-09-26 | Hampshire | West Virginia | 54027 | 2727 | 41 |
1754745 | 1754745 | 2021-09-25 | Hampshire | West Virginia | 54027 | 2713 | 41 |
1751497 | 1751497 | 2021-09-24 | Hampshire | West Virginia | 54027 | 2695 | 41 |
1712522 | 1712522 | 2021-09-12 | Mason | West Virginia | 54053 | 2841 | 41 |
1709275 | 1709275 | 2021-09-11 | Mason | West Virginia | 54053 | 2807 | 41 |
1706028 | 1706028 | 2021-09-10 | Mason | West Virginia | 54053 | 2760 | 41 |
1702778 | 1702778 | 2021-09-09 | Mason | West Virginia | 54053 | 2715 | 41 |
1699529 | 1699529 | 2021-09-08 | Mason | West Virginia | 54053 | 2691 | 41 |
1696281 | 1696281 | 2021-09-07 | Mason | West Virginia | 54053 | 2664 | 41 |
1693033 | 1693033 | 2021-09-06 | Mason | West Virginia | 54053 | 2642 | 41 |
1689813 | 1689813 | 2021-09-05 | Wyoming | West Virginia | 54109 | 2602 | 41 |
1686563 | 1686563 | 2021-09-04 | Wyoming | West Virginia | 54109 | 2580 | 41 |
1683313 | 1683313 | 2021-09-03 | Wyoming | West Virginia | 54109 | 2556 | 41 |
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);