ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 20043 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1622609 | 1622609 | 2021-08-16 | Doniphan | Kansas | 20043 | 1198 | 24 |
1619362 | 1619362 | 2021-08-15 | Doniphan | Kansas | 20043 | 1190 | 24 |
1616114 | 1616114 | 2021-08-14 | Doniphan | Kansas | 20043 | 1190 | 24 |
1612865 | 1612865 | 2021-08-13 | Doniphan | Kansas | 20043 | 1190 | 24 |
1609617 | 1609617 | 2021-08-12 | Doniphan | Kansas | 20043 | 1176 | 24 |
1606368 | 1606368 | 2021-08-11 | Doniphan | Kansas | 20043 | 1176 | 24 |
1603119 | 1603119 | 2021-08-10 | Doniphan | Kansas | 20043 | 1165 | 24 |
1599870 | 1599870 | 2021-08-09 | Doniphan | Kansas | 20043 | 1165 | 24 |
1596622 | 1596622 | 2021-08-08 | Doniphan | Kansas | 20043 | 1158 | 24 |
1593373 | 1593373 | 2021-08-07 | Doniphan | Kansas | 20043 | 1158 | 24 |
1590124 | 1590124 | 2021-08-06 | Doniphan | Kansas | 20043 | 1158 | 24 |
1586875 | 1586875 | 2021-08-05 | Doniphan | Kansas | 20043 | 1154 | 24 |
1583625 | 1583625 | 2021-08-04 | Doniphan | Kansas | 20043 | 1154 | 24 |
1580375 | 1580375 | 2021-08-03 | Doniphan | Kansas | 20043 | 1152 | 24 |
1577126 | 1577126 | 2021-08-02 | Doniphan | Kansas | 20043 | 1152 | 24 |
1573878 | 1573878 | 2021-08-01 | Doniphan | Kansas | 20043 | 1146 | 24 |
1570630 | 1570630 | 2021-07-31 | Doniphan | Kansas | 20043 | 1146 | 24 |
1567382 | 1567382 | 2021-07-30 | Doniphan | Kansas | 20043 | 1146 | 24 |
1564134 | 1564134 | 2021-07-29 | Doniphan | Kansas | 20043 | 1130 | 23 |
1560886 | 1560886 | 2021-07-28 | Doniphan | Kansas | 20043 | 1130 | 23 |
1557639 | 1557639 | 2021-07-27 | Doniphan | Kansas | 20043 | 1123 | 23 |
1554392 | 1554392 | 2021-07-26 | Doniphan | Kansas | 20043 | 1123 | 23 |
1551145 | 1551145 | 2021-07-25 | Doniphan | Kansas | 20043 | 1110 | 23 |
1547898 | 1547898 | 2021-07-24 | Doniphan | Kansas | 20043 | 1110 | 23 |
1544651 | 1544651 | 2021-07-23 | Doniphan | Kansas | 20043 | 1110 | 23 |
1541403 | 1541403 | 2021-07-22 | Doniphan | Kansas | 20043 | 1099 | 23 |
1538156 | 1538156 | 2021-07-21 | Doniphan | Kansas | 20043 | 1099 | 23 |
1534908 | 1534908 | 2021-07-20 | Doniphan | Kansas | 20043 | 1095 | 23 |
1531661 | 1531661 | 2021-07-19 | Doniphan | Kansas | 20043 | 1095 | 23 |
1528414 | 1528414 | 2021-07-18 | Doniphan | Kansas | 20043 | 1090 | 23 |
1525167 | 1525167 | 2021-07-17 | Doniphan | Kansas | 20043 | 1090 | 23 |
1521919 | 1521919 | 2021-07-16 | Doniphan | Kansas | 20043 | 1090 | 23 |
1518671 | 1518671 | 2021-07-15 | Doniphan | Kansas | 20043 | 1077 | 23 |
1515424 | 1515424 | 2021-07-14 | Doniphan | Kansas | 20043 | 1077 | 23 |
1512178 | 1512178 | 2021-07-13 | Doniphan | Kansas | 20043 | 1077 | 23 |
1508931 | 1508931 | 2021-07-12 | Doniphan | Kansas | 20043 | 1077 | 23 |
1505685 | 1505685 | 2021-07-11 | Doniphan | Kansas | 20043 | 1074 | 23 |
1502439 | 1502439 | 2021-07-10 | Doniphan | Kansas | 20043 | 1074 | 23 |
1499193 | 1499193 | 2021-07-09 | Doniphan | Kansas | 20043 | 1074 | 23 |
1495946 | 1495946 | 2021-07-08 | Doniphan | Kansas | 20043 | 1069 | 23 |
1492700 | 1492700 | 2021-07-07 | Doniphan | Kansas | 20043 | 1069 | 23 |
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);