ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
432 rows where deaths = 27 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
- Grant 69
- McDowell 41
- Webster 41
- Tyler 34
- Pocahontas 21
- Monroe 20
- Roane 20
- Jackson 19
- Hampshire 18
- Ritchie 15
- Summers 15
- Hardy 14
- Braxton 13
- Barbour 9
- Lincoln 9
- Jefferson 8
- Kanawha 7
- Pleasants 6
- Ohio 5
- Taylor 5
- Wyoming 4
- Greenbrier 3
- Logan 3
- Mercer 3
- Preston 3
- Upshur 3
- Wetzel 3
- Berkeley 2
- Brooke 2
- Lewis 2
- …
state 1
- West Virginia · 432 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2313917 | 2313917 | 2022-03-16 | Pocahontas | West Virginia | 54075 | 2003 | 27 |
2310664 | 2310664 | 2022-03-15 | Pocahontas | West Virginia | 54075 | 2003 | 27 |
2307411 | 2307411 | 2022-03-14 | Pocahontas | West Virginia | 54075 | 2002 | 27 |
2304160 | 2304160 | 2022-03-13 | Pocahontas | West Virginia | 54075 | 2000 | 27 |
2300908 | 2300908 | 2022-03-12 | Pocahontas | West Virginia | 54075 | 2000 | 27 |
2297656 | 2297656 | 2022-03-11 | Pocahontas | West Virginia | 54075 | 2000 | 27 |
2294404 | 2294404 | 2022-03-10 | Pocahontas | West Virginia | 54075 | 1999 | 27 |
2291152 | 2291152 | 2022-03-09 | Pocahontas | West Virginia | 54075 | 1998 | 27 |
2287900 | 2287900 | 2022-03-08 | Pocahontas | West Virginia | 54075 | 1998 | 27 |
2284648 | 2284648 | 2022-03-07 | Pocahontas | West Virginia | 54075 | 1996 | 27 |
2281396 | 2281396 | 2022-03-06 | Pocahontas | West Virginia | 54075 | 1991 | 27 |
2278143 | 2278143 | 2022-03-05 | Pocahontas | West Virginia | 54075 | 1991 | 27 |
2274890 | 2274890 | 2022-03-04 | Pocahontas | West Virginia | 54075 | 1991 | 27 |
2271637 | 2271637 | 2022-03-03 | Pocahontas | West Virginia | 54075 | 1983 | 27 |
2268385 | 2268385 | 2022-03-02 | Pocahontas | West Virginia | 54075 | 1980 | 27 |
2265132 | 2265132 | 2022-03-01 | Pocahontas | West Virginia | 54075 | 1980 | 27 |
2261882 | 2261882 | 2022-02-28 | Pocahontas | West Virginia | 54075 | 1979 | 27 |
2258631 | 2258631 | 2022-02-27 | Pocahontas | West Virginia | 54075 | 1978 | 27 |
2255380 | 2255380 | 2022-02-26 | Pocahontas | West Virginia | 54075 | 1978 | 27 |
2252129 | 2252129 | 2022-02-25 | Pocahontas | West Virginia | 54075 | 1978 | 27 |
2248878 | 2248878 | 2022-02-24 | Pocahontas | West Virginia | 54075 | 1975 | 27 |
2219629 | 2219629 | 2022-02-15 | Tyler | West Virginia | 54095 | 2115 | 27 |
2216379 | 2216379 | 2022-02-14 | Tyler | West Virginia | 54095 | 2110 | 27 |
2213128 | 2213128 | 2022-02-13 | Tyler | West Virginia | 54095 | 2108 | 27 |
2209875 | 2209875 | 2022-02-12 | Tyler | West Virginia | 54095 | 2102 | 27 |
2206622 | 2206622 | 2022-02-11 | Tyler | West Virginia | 54095 | 2098 | 27 |
2203369 | 2203369 | 2022-02-10 | Tyler | West Virginia | 54095 | 2086 | 27 |
2200110 | 2200110 | 2022-02-09 | Ritchie | West Virginia | 54085 | 2243 | 27 |
2200115 | 2200115 | 2022-02-09 | Tyler | West Virginia | 54095 | 2077 | 27 |
2196856 | 2196856 | 2022-02-08 | Ritchie | West Virginia | 54085 | 2240 | 27 |
2196861 | 2196861 | 2022-02-08 | Tyler | West Virginia | 54095 | 2071 | 27 |
2193601 | 2193601 | 2022-02-07 | Ritchie | West Virginia | 54085 | 2230 | 27 |
2193606 | 2193606 | 2022-02-07 | Tyler | West Virginia | 54095 | 2066 | 27 |
2190348 | 2190348 | 2022-02-06 | Ritchie | West Virginia | 54085 | 2225 | 27 |
2190353 | 2190353 | 2022-02-06 | Tyler | West Virginia | 54095 | 2060 | 27 |
2190356 | 2190356 | 2022-02-06 | Webster | West Virginia | 54101 | 1965 | 27 |
2187095 | 2187095 | 2022-02-05 | Ritchie | West Virginia | 54085 | 2225 | 27 |
2187100 | 2187100 | 2022-02-05 | Tyler | West Virginia | 54095 | 2054 | 27 |
2187103 | 2187103 | 2022-02-05 | Webster | West Virginia | 54101 | 1961 | 27 |
2183842 | 2183842 | 2022-02-04 | Ritchie | West Virginia | 54085 | 2208 | 27 |
2183847 | 2183847 | 2022-02-04 | Tyler | West Virginia | 54095 | 2039 | 27 |
2183850 | 2183850 | 2022-02-04 | Webster | West Virginia | 54101 | 1950 | 27 |
2180590 | 2180590 | 2022-02-03 | Ritchie | West Virginia | 54085 | 2186 | 27 |
2180595 | 2180595 | 2022-02-03 | Tyler | West Virginia | 54095 | 2028 | 27 |
2180598 | 2180598 | 2022-02-03 | Webster | West Virginia | 54101 | 1935 | 27 |
2177339 | 2177339 | 2022-02-02 | Ritchie | West Virginia | 54085 | 2160 | 27 |
2177344 | 2177344 | 2022-02-02 | Tyler | West Virginia | 54095 | 2019 | 27 |
2177347 | 2177347 | 2022-02-02 | Webster | West Virginia | 54101 | 1920 | 27 |
2174086 | 2174086 | 2022-02-01 | Ritchie | West Virginia | 54085 | 2148 | 27 |
2174091 | 2174091 | 2022-02-01 | Tyler | West Virginia | 54095 | 2009 | 27 |
2174094 | 2174094 | 2022-02-01 | Webster | West Virginia | 54101 | 1908 | 27 |
2170834 | 2170834 | 2022-01-31 | Ritchie | West Virginia | 54085 | 2137 | 27 |
2170839 | 2170839 | 2022-01-31 | Tyler | West Virginia | 54095 | 1996 | 27 |
2170842 | 2170842 | 2022-01-31 | Webster | West Virginia | 54101 | 1887 | 27 |
2167581 | 2167581 | 2022-01-30 | Ritchie | West Virginia | 54085 | 2126 | 27 |
2167586 | 2167586 | 2022-01-30 | Tyler | West Virginia | 54095 | 1991 | 27 |
2167589 | 2167589 | 2022-01-30 | Webster | West Virginia | 54101 | 1881 | 27 |
2164326 | 2164326 | 2022-01-29 | Ritchie | West Virginia | 54085 | 2116 | 27 |
2164331 | 2164331 | 2022-01-29 | Tyler | West Virginia | 54095 | 1981 | 27 |
2164334 | 2164334 | 2022-01-29 | Webster | West Virginia | 54101 | 1872 | 27 |
2161071 | 2161071 | 2022-01-28 | Ritchie | West Virginia | 54085 | 2088 | 27 |
2161076 | 2161076 | 2022-01-28 | Tyler | West Virginia | 54095 | 1980 | 27 |
2161079 | 2161079 | 2022-01-28 | Webster | West Virginia | 54101 | 1860 | 27 |
2157815 | 2157815 | 2022-01-27 | Ritchie | West Virginia | 54085 | 2078 | 27 |
2157820 | 2157820 | 2022-01-27 | Tyler | West Virginia | 54095 | 1957 | 27 |
2157823 | 2157823 | 2022-01-27 | Webster | West Virginia | 54101 | 1843 | 27 |
2154562 | 2154562 | 2022-01-26 | Ritchie | West Virginia | 54085 | 2048 | 27 |
2154567 | 2154567 | 2022-01-26 | Tyler | West Virginia | 54095 | 1916 | 27 |
2154570 | 2154570 | 2022-01-26 | Webster | West Virginia | 54101 | 1821 | 27 |
2151314 | 2151314 | 2022-01-25 | Tyler | West Virginia | 54095 | 1891 | 27 |
2151317 | 2151317 | 2022-01-25 | Webster | West Virginia | 54101 | 1807 | 27 |
2148062 | 2148062 | 2022-01-24 | Tyler | West Virginia | 54095 | 1880 | 27 |
2148065 | 2148065 | 2022-01-24 | Webster | West Virginia | 54101 | 1801 | 27 |
2144810 | 2144810 | 2022-01-23 | Tyler | West Virginia | 54095 | 1868 | 27 |
2144813 | 2144813 | 2022-01-23 | Webster | West Virginia | 54101 | 1786 | 27 |
2141555 | 2141555 | 2022-01-22 | Tyler | West Virginia | 54095 | 1830 | 27 |
2141558 | 2141558 | 2022-01-22 | Webster | West Virginia | 54101 | 1761 | 27 |
2138299 | 2138299 | 2022-01-21 | Tyler | West Virginia | 54095 | 1805 | 27 |
2138302 | 2138302 | 2022-01-21 | Webster | West Virginia | 54101 | 1736 | 27 |
2135044 | 2135044 | 2022-01-20 | Tyler | West Virginia | 54095 | 1767 | 27 |
2135047 | 2135047 | 2022-01-20 | Webster | West Virginia | 54101 | 1709 | 27 |
2131792 | 2131792 | 2022-01-19 | Tyler | West Virginia | 54095 | 1737 | 27 |
2131795 | 2131795 | 2022-01-19 | Webster | West Virginia | 54101 | 1700 | 27 |
2128538 | 2128538 | 2022-01-18 | Tyler | West Virginia | 54095 | 1729 | 27 |
2128541 | 2128541 | 2022-01-18 | Webster | West Virginia | 54101 | 1695 | 27 |
2125285 | 2125285 | 2022-01-17 | Tyler | West Virginia | 54095 | 1718 | 27 |
2125288 | 2125288 | 2022-01-17 | Webster | West Virginia | 54101 | 1687 | 27 |
2122033 | 2122033 | 2022-01-16 | Tyler | West Virginia | 54095 | 1679 | 27 |
2122036 | 2122036 | 2022-01-16 | Webster | West Virginia | 54101 | 1674 | 27 |
2118781 | 2118781 | 2022-01-15 | Tyler | West Virginia | 54095 | 1665 | 27 |
2118784 | 2118784 | 2022-01-15 | Webster | West Virginia | 54101 | 1667 | 27 |
2115529 | 2115529 | 2022-01-14 | Tyler | West Virginia | 54095 | 1642 | 27 |
2115532 | 2115532 | 2022-01-14 | Webster | West Virginia | 54101 | 1639 | 27 |
2112277 | 2112277 | 2022-01-13 | Tyler | West Virginia | 54095 | 1632 | 27 |
2112280 | 2112280 | 2022-01-13 | Webster | West Virginia | 54101 | 1617 | 27 |
2109028 | 2109028 | 2022-01-12 | Webster | West Virginia | 54101 | 1605 | 27 |
2105777 | 2105777 | 2022-01-11 | Webster | West Virginia | 54101 | 1592 | 27 |
2102526 | 2102526 | 2022-01-10 | Webster | West Virginia | 54101 | 1587 | 27 |
2099275 | 2099275 | 2022-01-09 | Webster | West Virginia | 54101 | 1585 | 27 |
2096024 | 2096024 | 2022-01-08 | Webster | West Virginia | 54101 | 1580 | 27 |
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);