ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
212 rows where deaths = 50 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Brooke 29
- Jackson 21
- McDowell 19
- Hampshire 15
- Summers 15
- Randolph 13
- Jefferson 10
- Taylor 10
- Wetzel 8
- Morgan 7
- Preston 7
- Greenbrier 6
- Lincoln 5
- Marion 5
- Grant 4
- Hardy 4
- Lewis 4
- Mason 4
- Nicholas 4
- Cabell 3
- Harrison 3
- Berkeley 2
- Marshall 2
- Mingo 2
- Ohio 2
- Raleigh 2
- Barbour 1
- Fayette 1
- Logan 1
- Putnam 1
- …
state 1
- West Virginia · 212 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2375705 | 2375705 | 2022-04-04 | Hardy | West Virginia | 54031 | 4177 | 50 |
2372453 | 2372453 | 2022-04-03 | Hardy | West Virginia | 54031 | 4176 | 50 |
2369200 | 2369200 | 2022-04-02 | Hardy | West Virginia | 54031 | 4176 | 50 |
2365947 | 2365947 | 2022-04-01 | Hardy | West Virginia | 54031 | 4176 | 50 |
2339951 | 2339951 | 2022-03-24 | Summers | West Virginia | 54089 | 2798 | 50 |
2336698 | 2336698 | 2022-03-23 | Summers | West Virginia | 54089 | 2801 | 50 |
2333444 | 2333444 | 2022-03-22 | Summers | West Virginia | 54089 | 2799 | 50 |
2330190 | 2330190 | 2022-03-21 | Summers | West Virginia | 54089 | 2799 | 50 |
2326938 | 2326938 | 2022-03-20 | Summers | West Virginia | 54089 | 2791 | 50 |
2323685 | 2323685 | 2022-03-19 | Summers | West Virginia | 54089 | 2791 | 50 |
2320431 | 2320431 | 2022-03-18 | Summers | West Virginia | 54089 | 2791 | 50 |
2317177 | 2317177 | 2022-03-17 | Summers | West Virginia | 54089 | 2789 | 50 |
2313924 | 2313924 | 2022-03-16 | Summers | West Virginia | 54089 | 2788 | 50 |
2310671 | 2310671 | 2022-03-15 | Summers | West Virginia | 54089 | 2787 | 50 |
2307418 | 2307418 | 2022-03-14 | Summers | West Virginia | 54089 | 2786 | 50 |
2304167 | 2304167 | 2022-03-13 | Summers | West Virginia | 54089 | 2777 | 50 |
2300915 | 2300915 | 2022-03-12 | Summers | West Virginia | 54089 | 2777 | 50 |
2297663 | 2297663 | 2022-03-11 | Summers | West Virginia | 54089 | 2777 | 50 |
2294411 | 2294411 | 2022-03-10 | Summers | West Virginia | 54089 | 2775 | 50 |
2144774 | 2144774 | 2022-01-23 | Grant | West Virginia | 54023 | 3268 | 50 |
2141519 | 2141519 | 2022-01-22 | Grant | West Virginia | 54023 | 3234 | 50 |
2138263 | 2138263 | 2022-01-21 | Grant | West Virginia | 54023 | 3199 | 50 |
2135008 | 2135008 | 2022-01-20 | Grant | West Virginia | 54023 | 3154 | 50 |
2063505 | 2063505 | 2021-12-29 | Taylor | West Virginia | 54091 | 2907 | 50 |
2060255 | 2060255 | 2021-12-28 | Taylor | West Virginia | 54091 | 2899 | 50 |
2057006 | 2057006 | 2021-12-27 | Taylor | West Virginia | 54091 | 2893 | 50 |
2053757 | 2053757 | 2021-12-26 | Taylor | West Virginia | 54091 | 2857 | 50 |
2050507 | 2050507 | 2021-12-25 | Taylor | West Virginia | 54091 | 2857 | 50 |
2047257 | 2047257 | 2021-12-24 | Taylor | West Virginia | 54091 | 2857 | 50 |
2044007 | 2044007 | 2021-12-23 | Taylor | West Virginia | 54091 | 2857 | 50 |
2040758 | 2040758 | 2021-12-22 | Taylor | West Virginia | 54091 | 2835 | 50 |
2037508 | 2037508 | 2021-12-21 | Taylor | West Virginia | 54091 | 2819 | 50 |
2034258 | 2034258 | 2021-12-20 | Taylor | West Virginia | 54091 | 2814 | 50 |
1998487 | 1998487 | 2021-12-09 | Morgan | West Virginia | 54065 | 2466 | 50 |
1995236 | 1995236 | 2021-12-08 | Morgan | West Virginia | 54065 | 2448 | 50 |
1991985 | 1991985 | 2021-12-07 | Morgan | West Virginia | 54065 | 2439 | 50 |
1988734 | 1988734 | 2021-12-06 | Morgan | West Virginia | 54065 | 2444 | 50 |
1985484 | 1985484 | 2021-12-05 | Morgan | West Virginia | 54065 | 2435 | 50 |
1982234 | 1982234 | 2021-12-04 | Morgan | West Virginia | 54065 | 2424 | 50 |
1978984 | 1978984 | 2021-12-03 | Morgan | West Virginia | 54065 | 2403 | 50 |
1972466 | 1972466 | 2021-12-01 | Hampshire | West Virginia | 54027 | 3692 | 50 |
1969216 | 1969216 | 2021-11-30 | Hampshire | West Virginia | 54027 | 3661 | 50 |
1965966 | 1965966 | 2021-11-29 | Hampshire | West Virginia | 54027 | 3641 | 50 |
1962714 | 1962714 | 2021-11-28 | Hampshire | West Virginia | 54027 | 3596 | 50 |
1962722 | 1962722 | 2021-11-28 | Lincoln | West Virginia | 54043 | 3185 | 50 |
1959463 | 1959463 | 2021-11-27 | Hampshire | West Virginia | 54027 | 3596 | 50 |
1959471 | 1959471 | 2021-11-27 | Lincoln | West Virginia | 54043 | 3185 | 50 |
1956212 | 1956212 | 2021-11-26 | Hampshire | West Virginia | 54027 | 3596 | 50 |
1956220 | 1956220 | 2021-11-26 | Lincoln | West Virginia | 54043 | 3185 | 50 |
1952961 | 1952961 | 2021-11-25 | Hampshire | West Virginia | 54027 | 3596 | 50 |
1952969 | 1952969 | 2021-11-25 | Lincoln | West Virginia | 54043 | 3185 | 50 |
1949710 | 1949710 | 2021-11-24 | Hampshire | West Virginia | 54027 | 3596 | 50 |
1949718 | 1949718 | 2021-11-24 | Lincoln | West Virginia | 54043 | 3185 | 50 |
1946459 | 1946459 | 2021-11-23 | Hampshire | West Virginia | 54027 | 3577 | 50 |
1943208 | 1943208 | 2021-11-22 | Hampshire | West Virginia | 54027 | 3581 | 50 |
1939958 | 1939958 | 2021-11-21 | Hampshire | West Virginia | 54027 | 3571 | 50 |
1936708 | 1936708 | 2021-11-20 | Hampshire | West Virginia | 54027 | 3554 | 50 |
1933458 | 1933458 | 2021-11-19 | Hampshire | West Virginia | 54027 | 3536 | 50 |
1930206 | 1930206 | 2021-11-18 | Hampshire | West Virginia | 54027 | 3502 | 50 |
1926943 | 1926943 | 2021-11-17 | Barbour | West Virginia | 54001 | 2895 | 50 |
1926956 | 1926956 | 2021-11-17 | Hampshire | West Virginia | 54027 | 3474 | 50 |
1920470 | 1920470 | 2021-11-15 | McDowell | West Virginia | 54047 | 3039 | 50 |
1917220 | 1917220 | 2021-11-14 | McDowell | West Virginia | 54047 | 3034 | 50 |
1913970 | 1913970 | 2021-11-13 | McDowell | West Virginia | 54047 | 3028 | 50 |
1910720 | 1910720 | 2021-11-12 | McDowell | West Virginia | 54047 | 3024 | 50 |
1907471 | 1907471 | 2021-11-11 | McDowell | West Virginia | 54047 | 3016 | 50 |
1904222 | 1904222 | 2021-11-10 | McDowell | West Virginia | 54047 | 3002 | 50 |
1904237 | 1904237 | 2021-11-10 | Randolph | West Virginia | 54083 | 5254 | 50 |
1900972 | 1900972 | 2021-11-09 | McDowell | West Virginia | 54047 | 2996 | 50 |
1900987 | 1900987 | 2021-11-09 | Randolph | West Virginia | 54083 | 5237 | 50 |
1897722 | 1897722 | 2021-11-08 | McDowell | West Virginia | 54047 | 2990 | 50 |
1897737 | 1897737 | 2021-11-08 | Randolph | West Virginia | 54083 | 5221 | 50 |
1894472 | 1894472 | 2021-11-07 | McDowell | West Virginia | 54047 | 2987 | 50 |
1894479 | 1894479 | 2021-11-07 | Nicholas | West Virginia | 54067 | 3896 | 50 |
1894487 | 1894487 | 2021-11-07 | Randolph | West Virginia | 54083 | 5217 | 50 |
1891222 | 1891222 | 2021-11-06 | McDowell | West Virginia | 54047 | 2978 | 50 |
1891229 | 1891229 | 2021-11-06 | Nicholas | West Virginia | 54067 | 3872 | 50 |
1891237 | 1891237 | 2021-11-06 | Randolph | West Virginia | 54083 | 5212 | 50 |
1887972 | 1887972 | 2021-11-05 | McDowell | West Virginia | 54047 | 2971 | 50 |
1887979 | 1887979 | 2021-11-05 | Nicholas | West Virginia | 54067 | 3832 | 50 |
1887987 | 1887987 | 2021-11-05 | Randolph | West Virginia | 54083 | 5202 | 50 |
1884722 | 1884722 | 2021-11-04 | McDowell | West Virginia | 54047 | 2962 | 50 |
1884729 | 1884729 | 2021-11-04 | Nicholas | West Virginia | 54067 | 3812 | 50 |
1884737 | 1884737 | 2021-11-04 | Randolph | West Virginia | 54083 | 5186 | 50 |
1881473 | 1881473 | 2021-11-03 | McDowell | West Virginia | 54047 | 2952 | 50 |
1881488 | 1881488 | 2021-11-03 | Randolph | West Virginia | 54083 | 5176 | 50 |
1878224 | 1878224 | 2021-11-02 | McDowell | West Virginia | 54047 | 2945 | 50 |
1878239 | 1878239 | 2021-11-02 | Randolph | West Virginia | 54083 | 5162 | 50 |
1874975 | 1874975 | 2021-11-01 | McDowell | West Virginia | 54047 | 2945 | 50 |
1874990 | 1874990 | 2021-11-01 | Randolph | West Virginia | 54083 | 5149 | 50 |
1871726 | 1871726 | 2021-10-31 | McDowell | West Virginia | 54047 | 2944 | 50 |
1871741 | 1871741 | 2021-10-31 | Randolph | West Virginia | 54083 | 5144 | 50 |
1868477 | 1868477 | 2021-10-30 | McDowell | West Virginia | 54047 | 2934 | 50 |
1868492 | 1868492 | 2021-10-30 | Randolph | West Virginia | 54083 | 5143 | 50 |
1865228 | 1865228 | 2021-10-29 | McDowell | West Virginia | 54047 | 2930 | 50 |
1865243 | 1865243 | 2021-10-29 | Randolph | West Virginia | 54083 | 5100 | 50 |
1861979 | 1861979 | 2021-10-28 | McDowell | West Virginia | 54047 | 2923 | 50 |
1852257 | 1852257 | 2021-10-25 | Wetzel | West Virginia | 54103 | 2537 | 50 |
1848976 | 1848976 | 2021-10-24 | Lewis | West Virginia | 54041 | 2995 | 50 |
1849007 | 1849007 | 2021-10-24 | Wetzel | West Virginia | 54103 | 2532 | 50 |
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);