ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Doniphan" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110047 | 2110047 | 2022-01-13 | Doniphan | Kansas | 20043 | 1899 | 32 |
2106796 | 2106796 | 2022-01-12 | Doniphan | Kansas | 20043 | 1899 | 32 |
2103545 | 2103545 | 2022-01-11 | Doniphan | Kansas | 20043 | 1867 | 32 |
2100294 | 2100294 | 2022-01-10 | Doniphan | Kansas | 20043 | 1867 | 32 |
2097043 | 2097043 | 2022-01-09 | Doniphan | Kansas | 20043 | 1848 | 31 |
2093791 | 2093791 | 2022-01-08 | Doniphan | Kansas | 20043 | 1848 | 31 |
2090539 | 2090539 | 2022-01-07 | Doniphan | Kansas | 20043 | 1848 | 31 |
2087288 | 2087288 | 2022-01-06 | Doniphan | Kansas | 20043 | 1829 | 29 |
2084036 | 2084036 | 2022-01-05 | Doniphan | Kansas | 20043 | 1829 | 29 |
2080784 | 2080784 | 2022-01-04 | Doniphan | Kansas | 20043 | 1810 | 29 |
2077532 | 2077532 | 2022-01-03 | Doniphan | Kansas | 20043 | 1810 | 29 |
2074281 | 2074281 | 2022-01-02 | Doniphan | Kansas | 20043 | 1775 | 29 |
2071030 | 2071030 | 2022-01-01 | Doniphan | Kansas | 20043 | 1775 | 29 |
2067779 | 2067779 | 2021-12-31 | Doniphan | Kansas | 20043 | 1775 | 29 |
2064528 | 2064528 | 2021-12-30 | Doniphan | Kansas | 20043 | 1775 | 29 |
2061278 | 2061278 | 2021-12-29 | Doniphan | Kansas | 20043 | 1775 | 29 |
2058029 | 2058029 | 2021-12-28 | Doniphan | Kansas | 20043 | 1757 | 29 |
2054780 | 2054780 | 2021-12-27 | Doniphan | Kansas | 20043 | 1757 | 29 |
2051530 | 2051530 | 2021-12-26 | Doniphan | Kansas | 20043 | 1730 | 29 |
2048280 | 2048280 | 2021-12-25 | Doniphan | Kansas | 20043 | 1730 | 29 |
2045030 | 2045030 | 2021-12-24 | Doniphan | Kansas | 20043 | 1730 | 29 |
2041781 | 2041781 | 2021-12-23 | Doniphan | Kansas | 20043 | 1730 | 29 |
2038531 | 2038531 | 2021-12-22 | Doniphan | Kansas | 20043 | 1730 | 29 |
2035281 | 2035281 | 2021-12-21 | Doniphan | Kansas | 20043 | 1710 | 29 |
2032031 | 2032031 | 2021-12-20 | Doniphan | Kansas | 20043 | 1710 | 29 |
2028780 | 2028780 | 2021-12-19 | Doniphan | Kansas | 20043 | 1694 | 29 |
2025529 | 2025529 | 2021-12-18 | Doniphan | Kansas | 20043 | 1694 | 29 |
2022278 | 2022278 | 2021-12-17 | Doniphan | Kansas | 20043 | 1694 | 29 |
2019027 | 2019027 | 2021-12-16 | Doniphan | Kansas | 20043 | 1669 | 29 |
2015777 | 2015777 | 2021-12-15 | Doniphan | Kansas | 20043 | 1669 | 29 |
2012526 | 2012526 | 2021-12-14 | Doniphan | Kansas | 20043 | 1643 | 29 |
2009275 | 2009275 | 2021-12-13 | Doniphan | Kansas | 20043 | 1643 | 29 |
2006024 | 2006024 | 2021-12-12 | Doniphan | Kansas | 20043 | 1633 | 29 |
2002773 | 2002773 | 2021-12-11 | Doniphan | Kansas | 20043 | 1633 | 29 |
1999523 | 1999523 | 2021-12-10 | Doniphan | Kansas | 20043 | 1633 | 29 |
1996272 | 1996272 | 2021-12-09 | Doniphan | Kansas | 20043 | 1620 | 29 |
1993021 | 1993021 | 2021-12-08 | Doniphan | Kansas | 20043 | 1620 | 29 |
1989770 | 1989770 | 2021-12-07 | Doniphan | Kansas | 20043 | 1602 | 29 |
1986520 | 1986520 | 2021-12-06 | Doniphan | Kansas | 20043 | 1602 | 29 |
1983270 | 1983270 | 2021-12-05 | Doniphan | Kansas | 20043 | 1584 | 29 |
1980020 | 1980020 | 2021-12-04 | Doniphan | Kansas | 20043 | 1584 | 29 |
1976770 | 1976770 | 2021-12-03 | Doniphan | Kansas | 20043 | 1584 | 29 |
1973521 | 1973521 | 2021-12-02 | Doniphan | Kansas | 20043 | 1550 | 29 |
1970271 | 1970271 | 2021-12-01 | Doniphan | Kansas | 20043 | 1550 | 29 |
1967021 | 1967021 | 2021-11-30 | Doniphan | Kansas | 20043 | 1522 | 29 |
1963769 | 1963769 | 2021-11-29 | Doniphan | Kansas | 20043 | 1522 | 29 |
1960518 | 1960518 | 2021-11-28 | Doniphan | Kansas | 20043 | 1506 | 29 |
1957267 | 1957267 | 2021-11-27 | Doniphan | Kansas | 20043 | 1506 | 29 |
1954016 | 1954016 | 2021-11-26 | Doniphan | Kansas | 20043 | 1506 | 29 |
1950765 | 1950765 | 2021-11-25 | Doniphan | Kansas | 20043 | 1506 | 29 |
1947514 | 1947514 | 2021-11-24 | Doniphan | Kansas | 20043 | 1506 | 29 |
1944263 | 1944263 | 2021-11-23 | Doniphan | Kansas | 20043 | 1493 | 28 |
1941013 | 1941013 | 2021-11-22 | Doniphan | Kansas | 20043 | 1493 | 28 |
1937763 | 1937763 | 2021-11-21 | Doniphan | Kansas | 20043 | 1480 | 28 |
1934513 | 1934513 | 2021-11-20 | Doniphan | Kansas | 20043 | 1480 | 28 |
1931262 | 1931262 | 2021-11-19 | Doniphan | Kansas | 20043 | 1480 | 28 |
1928011 | 1928011 | 2021-11-18 | Doniphan | Kansas | 20043 | 1461 | 28 |
1924761 | 1924761 | 2021-11-17 | Doniphan | Kansas | 20043 | 1461 | 28 |
1921512 | 1921512 | 2021-11-16 | Doniphan | Kansas | 20043 | 1454 | 28 |
1918262 | 1918262 | 2021-11-15 | Doniphan | Kansas | 20043 | 1454 | 28 |
1915012 | 1915012 | 2021-11-14 | Doniphan | Kansas | 20043 | 1447 | 29 |
1911762 | 1911762 | 2021-11-13 | Doniphan | Kansas | 20043 | 1447 | 29 |
1908513 | 1908513 | 2021-11-12 | Doniphan | Kansas | 20043 | 1447 | 29 |
1905264 | 1905264 | 2021-11-11 | Doniphan | Kansas | 20043 | 1437 | 29 |
1902014 | 1902014 | 2021-11-10 | Doniphan | Kansas | 20043 | 1437 | 29 |
1898764 | 1898764 | 2021-11-09 | Doniphan | Kansas | 20043 | 1423 | 29 |
1895514 | 1895514 | 2021-11-08 | Doniphan | Kansas | 20043 | 1423 | 29 |
1892264 | 1892264 | 2021-11-07 | Doniphan | Kansas | 20043 | 1415 | 29 |
1889014 | 1889014 | 2021-11-06 | Doniphan | Kansas | 20043 | 1415 | 29 |
1885764 | 1885764 | 2021-11-05 | Doniphan | Kansas | 20043 | 1415 | 29 |
1882515 | 1882515 | 2021-11-04 | Doniphan | Kansas | 20043 | 1401 | 29 |
1879266 | 1879266 | 2021-11-03 | Doniphan | Kansas | 20043 | 1401 | 29 |
1876017 | 1876017 | 2021-11-02 | Doniphan | Kansas | 20043 | 1383 | 29 |
1872768 | 1872768 | 2021-11-01 | Doniphan | Kansas | 20043 | 1383 | 29 |
1869519 | 1869519 | 2021-10-31 | Doniphan | Kansas | 20043 | 1381 | 29 |
1866270 | 1866270 | 2021-10-30 | Doniphan | Kansas | 20043 | 1381 | 29 |
1863021 | 1863021 | 2021-10-29 | Doniphan | Kansas | 20043 | 1381 | 29 |
1859772 | 1859772 | 2021-10-28 | Doniphan | Kansas | 20043 | 1375 | 28 |
1856523 | 1856523 | 2021-10-27 | Doniphan | Kansas | 20043 | 1375 | 28 |
1853274 | 1853274 | 2021-10-26 | Doniphan | Kansas | 20043 | 1369 | 28 |
1850025 | 1850025 | 2021-10-25 | Doniphan | Kansas | 20043 | 1369 | 28 |
1846775 | 1846775 | 2021-10-24 | Doniphan | Kansas | 20043 | 1362 | 27 |
1843525 | 1843525 | 2021-10-23 | Doniphan | Kansas | 20043 | 1362 | 27 |
1840275 | 1840275 | 2021-10-22 | Doniphan | Kansas | 20043 | 1362 | 27 |
1837026 | 1837026 | 2021-10-21 | Doniphan | Kansas | 20043 | 1357 | 27 |
1833777 | 1833777 | 2021-10-20 | Doniphan | Kansas | 20043 | 1357 | 27 |
1830528 | 1830528 | 2021-10-19 | Doniphan | Kansas | 20043 | 1354 | 27 |
1827279 | 1827279 | 2021-10-18 | Doniphan | Kansas | 20043 | 1354 | 27 |
1824030 | 1824030 | 2021-10-17 | Doniphan | Kansas | 20043 | 1351 | 27 |
1820781 | 1820781 | 2021-10-16 | Doniphan | Kansas | 20043 | 1351 | 27 |
1817532 | 1817532 | 2021-10-15 | Doniphan | Kansas | 20043 | 1351 | 27 |
1814284 | 1814284 | 2021-10-14 | Doniphan | Kansas | 20043 | 1348 | 27 |
1811035 | 1811035 | 2021-10-13 | Doniphan | Kansas | 20043 | 1348 | 27 |
1807786 | 1807786 | 2021-10-12 | Doniphan | Kansas | 20043 | 1345 | 27 |
1804535 | 1804535 | 2021-10-11 | Doniphan | Kansas | 20043 | 1345 | 27 |
1801286 | 1801286 | 2021-10-10 | Doniphan | Kansas | 20043 | 1343 | 27 |
1798037 | 1798037 | 2021-10-09 | Doniphan | Kansas | 20043 | 1343 | 27 |
1794788 | 1794788 | 2021-10-08 | Doniphan | Kansas | 20043 | 1343 | 27 |
1791540 | 1791540 | 2021-10-07 | Doniphan | Kansas | 20043 | 1338 | 27 |
1788291 | 1788291 | 2021-10-06 | Doniphan | Kansas | 20043 | 1338 | 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);