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 |
---|---|---|---|---|---|---|---|
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 |
1785042 | 1785042 | 2021-10-05 | Doniphan | Kansas | 20043 | 1334 | 27 |
1781793 | 1781793 | 2021-10-04 | Doniphan | Kansas | 20043 | 1334 | 27 |
1778543 | 1778543 | 2021-10-03 | Doniphan | Kansas | 20043 | 1333 | 27 |
1775293 | 1775293 | 2021-10-02 | Doniphan | Kansas | 20043 | 1333 | 27 |
1772043 | 1772043 | 2021-10-01 | Doniphan | Kansas | 20043 | 1333 | 27 |
1768794 | 1768794 | 2021-09-30 | Doniphan | Kansas | 20043 | 1328 | 27 |
1765545 | 1765545 | 2021-09-29 | Doniphan | Kansas | 20043 | 1328 | 27 |
1762296 | 1762296 | 2021-09-28 | Doniphan | Kansas | 20043 | 1325 | 27 |
1759048 | 1759048 | 2021-09-27 | Doniphan | Kansas | 20043 | 1325 | 27 |
1755800 | 1755800 | 2021-09-26 | Doniphan | Kansas | 20043 | 1323 | 27 |
1752552 | 1752552 | 2021-09-25 | Doniphan | Kansas | 20043 | 1323 | 27 |
1749303 | 1749303 | 2021-09-24 | Doniphan | Kansas | 20043 | 1323 | 27 |
1746053 | 1746053 | 2021-09-23 | Doniphan | Kansas | 20043 | 1320 | 27 |
1742804 | 1742804 | 2021-09-22 | Doniphan | Kansas | 20043 | 1320 | 27 |
1739555 | 1739555 | 2021-09-21 | Doniphan | Kansas | 20043 | 1317 | 27 |
1736306 | 1736306 | 2021-09-20 | Doniphan | Kansas | 20043 | 1317 | 27 |
1733056 | 1733056 | 2021-09-19 | Doniphan | Kansas | 20043 | 1314 | 27 |
1729806 | 1729806 | 2021-09-18 | Doniphan | Kansas | 20043 | 1314 | 27 |
1726556 | 1726556 | 2021-09-17 | Doniphan | Kansas | 20043 | 1314 | 27 |
1723307 | 1723307 | 2021-09-16 | Doniphan | Kansas | 20043 | 1310 | 27 |
1720058 | 1720058 | 2021-09-15 | Doniphan | Kansas | 20043 | 1310 | 27 |
1716810 | 1716810 | 2021-09-14 | Doniphan | Kansas | 20043 | 1303 | 27 |
1713564 | 1713564 | 2021-09-13 | Doniphan | Kansas | 20043 | 1303 | 27 |
1710317 | 1710317 | 2021-09-12 | Doniphan | Kansas | 20043 | 1300 | 27 |
1707070 | 1707070 | 2021-09-11 | Doniphan | Kansas | 20043 | 1300 | 27 |
1703822 | 1703822 | 2021-09-10 | Doniphan | Kansas | 20043 | 1300 | 27 |
1700572 | 1700572 | 2021-09-09 | Doniphan | Kansas | 20043 | 1287 | 27 |
1697323 | 1697323 | 2021-09-08 | Doniphan | Kansas | 20043 | 1287 | 27 |
1694075 | 1694075 | 2021-09-07 | Doniphan | Kansas | 20043 | 1281 | 26 |
1690826 | 1690826 | 2021-09-06 | Doniphan | Kansas | 20043 | 1281 | 26 |
1687576 | 1687576 | 2021-09-05 | Doniphan | Kansas | 20043 | 1281 | 26 |
1684326 | 1684326 | 2021-09-04 | Doniphan | Kansas | 20043 | 1281 | 26 |
1681075 | 1681075 | 2021-09-03 | Doniphan | Kansas | 20043 | 1281 | 26 |
1677827 | 1677827 | 2021-09-02 | Doniphan | Kansas | 20043 | 1262 | 26 |
1674580 | 1674580 | 2021-09-01 | Doniphan | Kansas | 20043 | 1262 | 26 |
1671331 | 1671331 | 2021-08-31 | Doniphan | Kansas | 20043 | 1256 | 26 |
1668084 | 1668084 | 2021-08-30 | Doniphan | Kansas | 20043 | 1256 | 26 |
1664837 | 1664837 | 2021-08-29 | Doniphan | Kansas | 20043 | 1246 | 26 |
1661589 | 1661589 | 2021-08-28 | Doniphan | Kansas | 20043 | 1246 | 26 |
1658341 | 1658341 | 2021-08-27 | Doniphan | Kansas | 20043 | 1246 | 26 |
1655093 | 1655093 | 2021-08-26 | Doniphan | Kansas | 20043 | 1235 | 26 |
1651846 | 1651846 | 2021-08-25 | Doniphan | Kansas | 20043 | 1235 | 26 |
1648597 | 1648597 | 2021-08-24 | Doniphan | Kansas | 20043 | 1224 | 25 |
1645349 | 1645349 | 2021-08-23 | Doniphan | Kansas | 20043 | 1224 | 25 |
1642100 | 1642100 | 2021-08-22 | Doniphan | Kansas | 20043 | 1217 | 25 |
1638850 | 1638850 | 2021-08-21 | Doniphan | Kansas | 20043 | 1217 | 25 |
1635600 | 1635600 | 2021-08-20 | Doniphan | Kansas | 20043 | 1217 | 25 |
1632350 | 1632350 | 2021-08-19 | Doniphan | Kansas | 20043 | 1207 | 24 |
1629103 | 1629103 | 2021-08-18 | Doniphan | Kansas | 20043 | 1207 | 24 |
1625856 | 1625856 | 2021-08-17 | Doniphan | Kansas | 20043 | 1198 | 24 |
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);