ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
195 rows where deaths = 42 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 |
---|---|---|---|---|---|---|---|
2424525 | 2424525 | 2022-04-19 | Braxton | West Virginia | 54007 | 3902 | 42 |
2421269 | 2421269 | 2022-04-18 | Braxton | West Virginia | 54007 | 3901 | 42 |
2418013 | 2418013 | 2022-04-17 | Braxton | West Virginia | 54007 | 3899 | 42 |
2414757 | 2414757 | 2022-04-16 | Braxton | West Virginia | 54007 | 3899 | 42 |
2411501 | 2411501 | 2022-04-15 | Braxton | West Virginia | 54007 | 3899 | 42 |
2408245 | 2408245 | 2022-04-14 | Braxton | West Virginia | 54007 | 3897 | 42 |
2404989 | 2404989 | 2022-04-13 | Braxton | West Virginia | 54007 | 3898 | 42 |
2401734 | 2401734 | 2022-04-12 | Braxton | West Virginia | 54007 | 3898 | 42 |
2398479 | 2398479 | 2022-04-11 | Braxton | West Virginia | 54007 | 3898 | 42 |
2395224 | 2395224 | 2022-04-10 | Braxton | West Virginia | 54007 | 3901 | 42 |
2391968 | 2391968 | 2022-04-09 | Braxton | West Virginia | 54007 | 3901 | 42 |
2388712 | 2388712 | 2022-04-08 | Braxton | West Virginia | 54007 | 3901 | 42 |
2385457 | 2385457 | 2022-04-07 | Braxton | West Virginia | 54007 | 3902 | 42 |
2382202 | 2382202 | 2022-04-06 | Braxton | West Virginia | 54007 | 3902 | 42 |
2378947 | 2378947 | 2022-04-05 | Braxton | West Virginia | 54007 | 3903 | 42 |
2375693 | 2375693 | 2022-04-04 | Braxton | West Virginia | 54007 | 3903 | 42 |
2372441 | 2372441 | 2022-04-03 | Braxton | West Virginia | 54007 | 3902 | 42 |
2369188 | 2369188 | 2022-04-02 | Braxton | West Virginia | 54007 | 3902 | 42 |
2365935 | 2365935 | 2022-04-01 | Braxton | West Virginia | 54007 | 3902 | 42 |
2362682 | 2362682 | 2022-03-31 | Braxton | West Virginia | 54007 | 3902 | 42 |
2359428 | 2359428 | 2022-03-30 | Braxton | West Virginia | 54007 | 3900 | 42 |
2356174 | 2356174 | 2022-03-29 | Braxton | West Virginia | 54007 | 3900 | 42 |
2352921 | 2352921 | 2022-03-28 | Braxton | West Virginia | 54007 | 3899 | 42 |
2349669 | 2349669 | 2022-03-27 | Braxton | West Virginia | 54007 | 3894 | 42 |
2346416 | 2346416 | 2022-03-26 | Braxton | West Virginia | 54007 | 3894 | 42 |
2343163 | 2343163 | 2022-03-25 | Braxton | West Virginia | 54007 | 3894 | 42 |
2339910 | 2339910 | 2022-03-24 | Braxton | West Virginia | 54007 | 3893 | 42 |
2336657 | 2336657 | 2022-03-23 | Braxton | West Virginia | 54007 | 3892 | 42 |
2333403 | 2333403 | 2022-03-22 | Braxton | West Virginia | 54007 | 3889 | 42 |
2333431 | 2333431 | 2022-03-22 | Monroe | West Virginia | 54063 | 4173 | 42 |
2330149 | 2330149 | 2022-03-21 | Braxton | West Virginia | 54007 | 3888 | 42 |
2330177 | 2330177 | 2022-03-21 | Monroe | West Virginia | 54063 | 4173 | 42 |
2326897 | 2326897 | 2022-03-20 | Braxton | West Virginia | 54007 | 3880 | 42 |
2326925 | 2326925 | 2022-03-20 | Monroe | West Virginia | 54063 | 4173 | 42 |
2323644 | 2323644 | 2022-03-19 | Braxton | West Virginia | 54007 | 3880 | 42 |
2323672 | 2323672 | 2022-03-19 | Monroe | West Virginia | 54063 | 4173 | 42 |
2320390 | 2320390 | 2022-03-18 | Braxton | West Virginia | 54007 | 3880 | 42 |
2320418 | 2320418 | 2022-03-18 | Monroe | West Virginia | 54063 | 4173 | 42 |
2317136 | 2317136 | 2022-03-17 | Braxton | West Virginia | 54007 | 3870 | 42 |
2317164 | 2317164 | 2022-03-17 | Monroe | West Virginia | 54063 | 4171 | 42 |
2313883 | 2313883 | 2022-03-16 | Braxton | West Virginia | 54007 | 3863 | 42 |
2313911 | 2313911 | 2022-03-16 | Monroe | West Virginia | 54063 | 4170 | 42 |
2310630 | 2310630 | 2022-03-15 | Braxton | West Virginia | 54007 | 3863 | 42 |
2310658 | 2310658 | 2022-03-15 | Monroe | West Virginia | 54063 | 4170 | 42 |
2307377 | 2307377 | 2022-03-14 | Braxton | West Virginia | 54007 | 3851 | 42 |
2304126 | 2304126 | 2022-03-13 | Braxton | West Virginia | 54007 | 3844 | 42 |
2300874 | 2300874 | 2022-03-12 | Braxton | West Virginia | 54007 | 3844 | 42 |
2297622 | 2297622 | 2022-03-11 | Braxton | West Virginia | 54007 | 3844 | 42 |
2294370 | 2294370 | 2022-03-10 | Braxton | West Virginia | 54007 | 3839 | 42 |
2291118 | 2291118 | 2022-03-09 | Braxton | West Virginia | 54007 | 3836 | 42 |
2287866 | 2287866 | 2022-03-08 | Braxton | West Virginia | 54007 | 3832 | 42 |
2284614 | 2284614 | 2022-03-07 | Braxton | West Virginia | 54007 | 3829 | 42 |
2281362 | 2281362 | 2022-03-06 | Braxton | West Virginia | 54007 | 3812 | 42 |
2278109 | 2278109 | 2022-03-05 | Braxton | West Virginia | 54007 | 3812 | 42 |
2274856 | 2274856 | 2022-03-04 | Braxton | West Virginia | 54007 | 3812 | 42 |
2271603 | 2271603 | 2022-03-03 | Braxton | West Virginia | 54007 | 3787 | 42 |
2268351 | 2268351 | 2022-03-02 | Braxton | West Virginia | 54007 | 3781 | 42 |
2125282 | 2125282 | 2022-01-17 | Summers | West Virginia | 54089 | 2005 | 42 |
2122030 | 2122030 | 2022-01-16 | Summers | West Virginia | 54089 | 1984 | 42 |
2118778 | 2118778 | 2022-01-15 | Summers | West Virginia | 54089 | 1963 | 42 |
2115526 | 2115526 | 2022-01-14 | Summers | West Virginia | 54089 | 1929 | 42 |
2112274 | 2112274 | 2022-01-13 | Summers | West Virginia | 54089 | 1908 | 42 |
2109022 | 2109022 | 2022-01-12 | Summers | West Virginia | 54089 | 1889 | 42 |
2034224 | 2034224 | 2021-12-20 | Grant | West Virginia | 54023 | 2642 | 42 |
2030974 | 2030974 | 2021-12-19 | Grant | West Virginia | 54023 | 2639 | 42 |
2027723 | 2027723 | 2021-12-18 | Grant | West Virginia | 54023 | 2636 | 42 |
2024472 | 2024472 | 2021-12-17 | Grant | West Virginia | 54023 | 2627 | 42 |
2021221 | 2021221 | 2021-12-16 | Grant | West Virginia | 54023 | 2616 | 42 |
2017970 | 2017970 | 2021-12-15 | Grant | West Virginia | 54023 | 2603 | 42 |
2014720 | 2014720 | 2021-12-14 | Grant | West Virginia | 54023 | 2592 | 42 |
2011469 | 2011469 | 2021-12-13 | Grant | West Virginia | 54023 | 2591 | 42 |
2008218 | 2008218 | 2021-12-12 | Grant | West Virginia | 54023 | 2582 | 42 |
2004967 | 2004967 | 2021-12-11 | Grant | West Virginia | 54023 | 2566 | 42 |
2001716 | 2001716 | 2021-12-10 | Grant | West Virginia | 54023 | 2554 | 42 |
1998466 | 1998466 | 2021-12-09 | Grant | West Virginia | 54023 | 2540 | 42 |
1995215 | 1995215 | 2021-12-08 | Grant | West Virginia | 54023 | 2521 | 42 |
1946491 | 1946491 | 2021-11-23 | Taylor | West Virginia | 54091 | 2546 | 42 |
1943240 | 1943240 | 2021-11-22 | Taylor | West Virginia | 54091 | 2541 | 42 |
1861985 | 1861985 | 2021-10-28 | Morgan | West Virginia | 54065 | 2108 | 42 |
1852227 | 1852227 | 2021-10-25 | Lincoln | West Virginia | 54043 | 2769 | 42 |
1848977 | 1848977 | 2021-10-24 | Lincoln | West Virginia | 54043 | 2759 | 42 |
1845727 | 1845727 | 2021-10-23 | Lincoln | West Virginia | 54043 | 2751 | 42 |
1842477 | 1842477 | 2021-10-22 | Lincoln | West Virginia | 54043 | 2734 | 42 |
1839228 | 1839228 | 2021-10-21 | Lincoln | West Virginia | 54043 | 2709 | 42 |
1835979 | 1835979 | 2021-10-20 | Lincoln | West Virginia | 54043 | 2702 | 42 |
1835991 | 1835991 | 2021-10-20 | Nicholas | West Virginia | 54067 | 3540 | 42 |
1832730 | 1832730 | 2021-10-19 | Lincoln | West Virginia | 54043 | 2693 | 42 |
1829481 | 1829481 | 2021-10-18 | Lincoln | West Virginia | 54043 | 2688 | 42 |
1826232 | 1826232 | 2021-10-17 | Lincoln | West Virginia | 54043 | 2678 | 42 |
1822983 | 1822983 | 2021-10-16 | Lincoln | West Virginia | 54043 | 2668 | 42 |
1819734 | 1819734 | 2021-10-15 | Lincoln | West Virginia | 54043 | 2660 | 42 |
1806738 | 1806738 | 2021-10-11 | Lewis | West Virginia | 54041 | 2844 | 42 |
1803487 | 1803487 | 2021-10-10 | Lewis | West Virginia | 54041 | 2827 | 42 |
1803493 | 1803493 | 2021-10-10 | McDowell | West Virginia | 54047 | 2777 | 42 |
1800238 | 1800238 | 2021-10-09 | Lewis | West Virginia | 54041 | 2810 | 42 |
1796989 | 1796989 | 2021-10-08 | Lewis | West Virginia | 54041 | 2785 | 42 |
1793746 | 1793746 | 2021-10-07 | McDowell | West Virginia | 54047 | 2728 | 42 |
1787223 | 1787223 | 2021-10-05 | Barbour | West Virginia | 54001 | 2463 | 42 |
1787225 | 1787225 | 2021-10-05 | Boone | West Virginia | 54005 | 3225 | 42 |
1783974 | 1783974 | 2021-10-04 | Barbour | West Virginia | 54001 | 2457 | 42 |
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);