ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
98 rows where county = "Pocahontas" and deaths = 25 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 |
---|---|---|---|---|---|---|---|
2239125 | 2239125 | 2022-02-21 | Pocahontas | West Virginia | 54075 | 1963 | 25 |
2235874 | 2235874 | 2022-02-20 | Pocahontas | West Virginia | 54075 | 1951 | 25 |
2232623 | 2232623 | 2022-02-19 | Pocahontas | West Virginia | 54075 | 1951 | 25 |
2229372 | 2229372 | 2022-02-18 | Pocahontas | West Virginia | 54075 | 1951 | 25 |
2226121 | 2226121 | 2022-02-17 | Pocahontas | West Virginia | 54075 | 1944 | 25 |
2222870 | 2222870 | 2022-02-16 | Pocahontas | West Virginia | 54075 | 1940 | 25 |
2219619 | 2219619 | 2022-02-15 | Pocahontas | West Virginia | 54075 | 1936 | 25 |
2216369 | 2216369 | 2022-02-14 | Pocahontas | West Virginia | 54075 | 1933 | 25 |
2213118 | 2213118 | 2022-02-13 | Pocahontas | West Virginia | 54075 | 1925 | 25 |
2209865 | 2209865 | 2022-02-12 | Pocahontas | West Virginia | 54075 | 1909 | 25 |
2206612 | 2206612 | 2022-02-11 | Pocahontas | West Virginia | 54075 | 1900 | 25 |
2203359 | 2203359 | 2022-02-10 | Pocahontas | West Virginia | 54075 | 1890 | 25 |
2200105 | 2200105 | 2022-02-09 | Pocahontas | West Virginia | 54075 | 1878 | 25 |
2196851 | 2196851 | 2022-02-08 | Pocahontas | West Virginia | 54075 | 1864 | 25 |
2193596 | 2193596 | 2022-02-07 | Pocahontas | West Virginia | 54075 | 1852 | 25 |
2190343 | 2190343 | 2022-02-06 | Pocahontas | West Virginia | 54075 | 1842 | 25 |
2187090 | 2187090 | 2022-02-05 | Pocahontas | West Virginia | 54075 | 1837 | 25 |
2183837 | 2183837 | 2022-02-04 | Pocahontas | West Virginia | 54075 | 1830 | 25 |
2180585 | 2180585 | 2022-02-03 | Pocahontas | West Virginia | 54075 | 1822 | 25 |
2177334 | 2177334 | 2022-02-02 | Pocahontas | West Virginia | 54075 | 1810 | 25 |
2171814 | 2171814 | 2022-02-01 | Pocahontas | Iowa | 19151 | 1503 | 25 |
2174081 | 2174081 | 2022-02-01 | Pocahontas | West Virginia | 54075 | 1796 | 25 |
2168561 | 2168561 | 2022-01-31 | Pocahontas | Iowa | 19151 | 1503 | 25 |
2170829 | 2170829 | 2022-01-31 | Pocahontas | West Virginia | 54075 | 1776 | 25 |
2165306 | 2165306 | 2022-01-30 | Pocahontas | Iowa | 19151 | 1503 | 25 |
2167576 | 2167576 | 2022-01-30 | Pocahontas | West Virginia | 54075 | 1770 | 25 |
2162051 | 2162051 | 2022-01-29 | Pocahontas | Iowa | 19151 | 1503 | 25 |
2164321 | 2164321 | 2022-01-29 | Pocahontas | West Virginia | 54075 | 1766 | 25 |
2158796 | 2158796 | 2022-01-28 | Pocahontas | Iowa | 19151 | 1503 | 25 |
2161066 | 2161066 | 2022-01-28 | Pocahontas | West Virginia | 54075 | 1751 | 25 |
2155542 | 2155542 | 2022-01-27 | Pocahontas | Iowa | 19151 | 1503 | 25 |
2157810 | 2157810 | 2022-01-27 | Pocahontas | West Virginia | 54075 | 1740 | 25 |
2152289 | 2152289 | 2022-01-26 | Pocahontas | Iowa | 19151 | 1503 | 25 |
2154557 | 2154557 | 2022-01-26 | Pocahontas | West Virginia | 54075 | 1717 | 25 |
2149037 | 2149037 | 2022-01-25 | Pocahontas | Iowa | 19151 | 1447 | 25 |
2151304 | 2151304 | 2022-01-25 | Pocahontas | West Virginia | 54075 | 1675 | 25 |
2145785 | 2145785 | 2022-01-24 | Pocahontas | Iowa | 19151 | 1447 | 25 |
2148052 | 2148052 | 2022-01-24 | Pocahontas | West Virginia | 54075 | 1663 | 25 |
2142530 | 2142530 | 2022-01-23 | Pocahontas | Iowa | 19151 | 1447 | 25 |
2144800 | 2144800 | 2022-01-23 | Pocahontas | West Virginia | 54075 | 1634 | 25 |
2139275 | 2139275 | 2022-01-22 | Pocahontas | Iowa | 19151 | 1447 | 25 |
2141545 | 2141545 | 2022-01-22 | Pocahontas | West Virginia | 54075 | 1623 | 25 |
2136019 | 2136019 | 2022-01-21 | Pocahontas | Iowa | 19151 | 1447 | 25 |
2138289 | 2138289 | 2022-01-21 | Pocahontas | West Virginia | 54075 | 1604 | 25 |
2132767 | 2132767 | 2022-01-20 | Pocahontas | Iowa | 19151 | 1447 | 25 |
2135034 | 2135034 | 2022-01-20 | Pocahontas | West Virginia | 54075 | 1591 | 25 |
2129514 | 2129514 | 2022-01-19 | Pocahontas | Iowa | 19151 | 1447 | 25 |
2131782 | 2131782 | 2022-01-19 | Pocahontas | West Virginia | 54075 | 1577 | 25 |
2126260 | 2126260 | 2022-01-18 | Pocahontas | Iowa | 19151 | 1380 | 25 |
2128528 | 2128528 | 2022-01-18 | Pocahontas | West Virginia | 54075 | 1560 | 25 |
2123008 | 2123008 | 2022-01-17 | Pocahontas | Iowa | 19151 | 1380 | 25 |
2119756 | 2119756 | 2022-01-16 | Pocahontas | Iowa | 19151 | 1380 | 25 |
2116504 | 2116504 | 2022-01-15 | Pocahontas | Iowa | 19151 | 1380 | 25 |
2113253 | 2113253 | 2022-01-14 | Pocahontas | Iowa | 19151 | 1380 | 25 |
2110001 | 2110001 | 2022-01-13 | Pocahontas | Iowa | 19151 | 1380 | 25 |
2106750 | 2106750 | 2022-01-12 | Pocahontas | Iowa | 19151 | 1380 | 25 |
2103499 | 2103499 | 2022-01-11 | Pocahontas | Iowa | 19151 | 1324 | 25 |
2100248 | 2100248 | 2022-01-10 | Pocahontas | Iowa | 19151 | 1324 | 25 |
2096997 | 2096997 | 2022-01-09 | Pocahontas | Iowa | 19151 | 1324 | 25 |
2093745 | 2093745 | 2022-01-08 | Pocahontas | Iowa | 19151 | 1324 | 25 |
2090493 | 2090493 | 2022-01-07 | Pocahontas | Iowa | 19151 | 1324 | 25 |
2087242 | 2087242 | 2022-01-06 | Pocahontas | Iowa | 19151 | 1324 | 25 |
2083990 | 2083990 | 2022-01-05 | Pocahontas | Iowa | 19151 | 1324 | 25 |
2080738 | 2080738 | 2022-01-04 | Pocahontas | Iowa | 19151 | 1294 | 25 |
2077486 | 2077486 | 2022-01-03 | Pocahontas | Iowa | 19151 | 1294 | 25 |
2074235 | 2074235 | 2022-01-02 | Pocahontas | Iowa | 19151 | 1294 | 25 |
2070984 | 2070984 | 2022-01-01 | Pocahontas | Iowa | 19151 | 1294 | 25 |
2067733 | 2067733 | 2021-12-31 | Pocahontas | Iowa | 19151 | 1294 | 25 |
2064482 | 2064482 | 2021-12-30 | Pocahontas | Iowa | 19151 | 1294 | 25 |
2061232 | 2061232 | 2021-12-29 | Pocahontas | Iowa | 19151 | 1294 | 25 |
2057983 | 2057983 | 2021-12-28 | Pocahontas | Iowa | 19151 | 1278 | 25 |
2054734 | 2054734 | 2021-12-27 | Pocahontas | Iowa | 19151 | 1278 | 25 |
2051484 | 2051484 | 2021-12-26 | Pocahontas | Iowa | 19151 | 1278 | 25 |
2048234 | 2048234 | 2021-12-25 | Pocahontas | Iowa | 19151 | 1278 | 25 |
2044984 | 2044984 | 2021-12-24 | Pocahontas | Iowa | 19151 | 1278 | 25 |
2041735 | 2041735 | 2021-12-23 | Pocahontas | Iowa | 19151 | 1278 | 25 |
2038485 | 2038485 | 2021-12-22 | Pocahontas | Iowa | 19151 | 1278 | 25 |
2035235 | 2035235 | 2021-12-21 | Pocahontas | Iowa | 19151 | 1260 | 25 |
2031985 | 2031985 | 2021-12-20 | Pocahontas | Iowa | 19151 | 1260 | 25 |
2028734 | 2028734 | 2021-12-19 | Pocahontas | Iowa | 19151 | 1260 | 25 |
2025483 | 2025483 | 2021-12-18 | Pocahontas | Iowa | 19151 | 1260 | 25 |
2022232 | 2022232 | 2021-12-17 | Pocahontas | Iowa | 19151 | 1260 | 25 |
2018981 | 2018981 | 2021-12-16 | Pocahontas | Iowa | 19151 | 1260 | 25 |
2015731 | 2015731 | 2021-12-15 | Pocahontas | Iowa | 19151 | 1260 | 25 |
2012480 | 2012480 | 2021-12-14 | Pocahontas | Iowa | 19151 | 1233 | 25 |
2009229 | 2009229 | 2021-12-13 | Pocahontas | Iowa | 19151 | 1233 | 25 |
2005978 | 2005978 | 2021-12-12 | Pocahontas | Iowa | 19151 | 1233 | 25 |
2002727 | 2002727 | 2021-12-11 | Pocahontas | Iowa | 19151 | 1233 | 25 |
1999477 | 1999477 | 2021-12-10 | Pocahontas | Iowa | 19151 | 1233 | 25 |
1996226 | 1996226 | 2021-12-09 | Pocahontas | Iowa | 19151 | 1233 | 25 |
1992975 | 1992975 | 2021-12-08 | Pocahontas | Iowa | 19151 | 1233 | 25 |
1989724 | 1989724 | 2021-12-07 | Pocahontas | Iowa | 19151 | 1224 | 25 |
1986474 | 1986474 | 2021-12-06 | Pocahontas | Iowa | 19151 | 1224 | 25 |
1983224 | 1983224 | 2021-12-05 | Pocahontas | Iowa | 19151 | 1224 | 25 |
1979974 | 1979974 | 2021-12-04 | Pocahontas | Iowa | 19151 | 1224 | 25 |
1976724 | 1976724 | 2021-12-03 | Pocahontas | Iowa | 19151 | 1224 | 25 |
1973475 | 1973475 | 2021-12-02 | Pocahontas | Iowa | 19151 | 1224 | 25 |
1970225 | 1970225 | 2021-12-01 | Pocahontas | Iowa | 19151 | 1224 | 25 |
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);