ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 20207 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1850107 | 1850107 | 2021-10-25 | Woodson | Kansas | 20207 | 400 | 9 |
1846857 | 1846857 | 2021-10-24 | Woodson | Kansas | 20207 | 398 | 9 |
1843607 | 1843607 | 2021-10-23 | Woodson | Kansas | 20207 | 398 | 9 |
1840357 | 1840357 | 2021-10-22 | Woodson | Kansas | 20207 | 398 | 9 |
1837108 | 1837108 | 2021-10-21 | Woodson | Kansas | 20207 | 393 | 9 |
1833859 | 1833859 | 2021-10-20 | Woodson | Kansas | 20207 | 393 | 9 |
1830610 | 1830610 | 2021-10-19 | Woodson | Kansas | 20207 | 391 | 9 |
1827361 | 1827361 | 2021-10-18 | Woodson | Kansas | 20207 | 391 | 9 |
1824112 | 1824112 | 2021-10-17 | Woodson | Kansas | 20207 | 390 | 9 |
1820863 | 1820863 | 2021-10-16 | Woodson | Kansas | 20207 | 390 | 9 |
1817614 | 1817614 | 2021-10-15 | Woodson | Kansas | 20207 | 390 | 9 |
1814366 | 1814366 | 2021-10-14 | Woodson | Kansas | 20207 | 387 | 9 |
1811117 | 1811117 | 2021-10-13 | Woodson | Kansas | 20207 | 387 | 9 |
1807868 | 1807868 | 2021-10-12 | Woodson | Kansas | 20207 | 378 | 9 |
1804617 | 1804617 | 2021-10-11 | Woodson | Kansas | 20207 | 378 | 9 |
1801368 | 1801368 | 2021-10-10 | Woodson | Kansas | 20207 | 376 | 9 |
1798119 | 1798119 | 2021-10-09 | Woodson | Kansas | 20207 | 376 | 9 |
1794870 | 1794870 | 2021-10-08 | Woodson | Kansas | 20207 | 376 | 9 |
1791622 | 1791622 | 2021-10-07 | Woodson | Kansas | 20207 | 374 | 9 |
1788373 | 1788373 | 2021-10-06 | Woodson | Kansas | 20207 | 374 | 9 |
1785124 | 1785124 | 2021-10-05 | Woodson | Kansas | 20207 | 361 | 9 |
1781875 | 1781875 | 2021-10-04 | Woodson | Kansas | 20207 | 361 | 9 |
1778625 | 1778625 | 2021-10-03 | Woodson | Kansas | 20207 | 359 | 9 |
1775375 | 1775375 | 2021-10-02 | Woodson | Kansas | 20207 | 359 | 9 |
1772125 | 1772125 | 2021-10-01 | Woodson | Kansas | 20207 | 359 | 9 |
1768876 | 1768876 | 2021-09-30 | Woodson | Kansas | 20207 | 358 | 9 |
1765627 | 1765627 | 2021-09-29 | Woodson | Kansas | 20207 | 358 | 9 |
1762378 | 1762378 | 2021-09-28 | Woodson | Kansas | 20207 | 354 | 9 |
1759130 | 1759130 | 2021-09-27 | Woodson | Kansas | 20207 | 354 | 9 |
1755882 | 1755882 | 2021-09-26 | Woodson | Kansas | 20207 | 354 | 9 |
1752634 | 1752634 | 2021-09-25 | Woodson | Kansas | 20207 | 354 | 9 |
1749385 | 1749385 | 2021-09-24 | Woodson | Kansas | 20207 | 354 | 9 |
1746135 | 1746135 | 2021-09-23 | Woodson | Kansas | 20207 | 353 | 9 |
1742886 | 1742886 | 2021-09-22 | Woodson | Kansas | 20207 | 353 | 9 |
1739637 | 1739637 | 2021-09-21 | Woodson | Kansas | 20207 | 347 | 9 |
1736388 | 1736388 | 2021-09-20 | Woodson | Kansas | 20207 | 347 | 9 |
1733138 | 1733138 | 2021-09-19 | Woodson | Kansas | 20207 | 341 | 8 |
1729888 | 1729888 | 2021-09-18 | Woodson | Kansas | 20207 | 341 | 8 |
1726638 | 1726638 | 2021-09-17 | Woodson | Kansas | 20207 | 341 | 8 |
1723389 | 1723389 | 2021-09-16 | Woodson | Kansas | 20207 | 340 | 8 |
1720140 | 1720140 | 2021-09-15 | Woodson | Kansas | 20207 | 340 | 8 |
1716892 | 1716892 | 2021-09-14 | Woodson | Kansas | 20207 | 330 | 8 |
1713646 | 1713646 | 2021-09-13 | Woodson | Kansas | 20207 | 330 | 8 |
1710399 | 1710399 | 2021-09-12 | Woodson | Kansas | 20207 | 322 | 8 |
1707152 | 1707152 | 2021-09-11 | Woodson | Kansas | 20207 | 322 | 8 |
1703904 | 1703904 | 2021-09-10 | Woodson | Kansas | 20207 | 322 | 8 |
1700654 | 1700654 | 2021-09-09 | Woodson | Kansas | 20207 | 315 | 8 |
1697405 | 1697405 | 2021-09-08 | Woodson | Kansas | 20207 | 315 | 8 |
1694157 | 1694157 | 2021-09-07 | Woodson | Kansas | 20207 | 298 | 8 |
1690908 | 1690908 | 2021-09-06 | Woodson | Kansas | 20207 | 298 | 8 |
1687658 | 1687658 | 2021-09-05 | Woodson | Kansas | 20207 | 298 | 8 |
1684408 | 1684408 | 2021-09-04 | Woodson | Kansas | 20207 | 298 | 8 |
1681157 | 1681157 | 2021-09-03 | Woodson | Kansas | 20207 | 298 | 8 |
1677909 | 1677909 | 2021-09-02 | Woodson | Kansas | 20207 | 295 | 8 |
1674662 | 1674662 | 2021-09-01 | Woodson | Kansas | 20207 | 295 | 8 |
1671413 | 1671413 | 2021-08-31 | Woodson | Kansas | 20207 | 286 | 8 |
1668166 | 1668166 | 2021-08-30 | Woodson | Kansas | 20207 | 286 | 8 |
1664919 | 1664919 | 2021-08-29 | Woodson | Kansas | 20207 | 282 | 8 |
1661671 | 1661671 | 2021-08-28 | Woodson | Kansas | 20207 | 282 | 8 |
1658423 | 1658423 | 2021-08-27 | Woodson | Kansas | 20207 | 282 | 8 |
1655175 | 1655175 | 2021-08-26 | Woodson | Kansas | 20207 | 278 | 8 |
1651928 | 1651928 | 2021-08-25 | Woodson | Kansas | 20207 | 278 | 8 |
1648679 | 1648679 | 2021-08-24 | Woodson | Kansas | 20207 | 277 | 8 |
1645431 | 1645431 | 2021-08-23 | Woodson | Kansas | 20207 | 277 | 8 |
1642182 | 1642182 | 2021-08-22 | Woodson | Kansas | 20207 | 275 | 8 |
1638932 | 1638932 | 2021-08-21 | Woodson | Kansas | 20207 | 275 | 8 |
1635682 | 1635682 | 2021-08-20 | Woodson | Kansas | 20207 | 275 | 8 |
1632432 | 1632432 | 2021-08-19 | Woodson | Kansas | 20207 | 264 | 5 |
1629185 | 1629185 | 2021-08-18 | Woodson | Kansas | 20207 | 264 | 5 |
1625938 | 1625938 | 2021-08-17 | Woodson | Kansas | 20207 | 260 | 5 |
1622691 | 1622691 | 2021-08-16 | Woodson | Kansas | 20207 | 260 | 5 |
1619444 | 1619444 | 2021-08-15 | Woodson | Kansas | 20207 | 258 | 5 |
1616196 | 1616196 | 2021-08-14 | Woodson | Kansas | 20207 | 258 | 5 |
1612947 | 1612947 | 2021-08-13 | Woodson | Kansas | 20207 | 258 | 5 |
1609699 | 1609699 | 2021-08-12 | Woodson | Kansas | 20207 | 255 | 5 |
1606450 | 1606450 | 2021-08-11 | Woodson | Kansas | 20207 | 255 | 5 |
1603201 | 1603201 | 2021-08-10 | Woodson | Kansas | 20207 | 253 | 5 |
1599952 | 1599952 | 2021-08-09 | Woodson | Kansas | 20207 | 253 | 5 |
1596704 | 1596704 | 2021-08-08 | Woodson | Kansas | 20207 | 250 | 5 |
1593455 | 1593455 | 2021-08-07 | Woodson | Kansas | 20207 | 250 | 5 |
1590206 | 1590206 | 2021-08-06 | Woodson | Kansas | 20207 | 250 | 5 |
1586957 | 1586957 | 2021-08-05 | Woodson | Kansas | 20207 | 246 | 5 |
1583707 | 1583707 | 2021-08-04 | Woodson | Kansas | 20207 | 246 | 5 |
1580457 | 1580457 | 2021-08-03 | Woodson | Kansas | 20207 | 244 | 5 |
1577208 | 1577208 | 2021-08-02 | Woodson | Kansas | 20207 | 244 | 5 |
1573960 | 1573960 | 2021-08-01 | Woodson | Kansas | 20207 | 244 | 5 |
1570712 | 1570712 | 2021-07-31 | Woodson | Kansas | 20207 | 244 | 5 |
1567464 | 1567464 | 2021-07-30 | Woodson | Kansas | 20207 | 244 | 5 |
1564216 | 1564216 | 2021-07-29 | Woodson | Kansas | 20207 | 241 | 5 |
1560968 | 1560968 | 2021-07-28 | Woodson | Kansas | 20207 | 241 | 5 |
1557721 | 1557721 | 2021-07-27 | Woodson | Kansas | 20207 | 238 | 5 |
1554474 | 1554474 | 2021-07-26 | Woodson | Kansas | 20207 | 238 | 5 |
1551227 | 1551227 | 2021-07-25 | Woodson | Kansas | 20207 | 235 | 5 |
1547980 | 1547980 | 2021-07-24 | Woodson | Kansas | 20207 | 235 | 5 |
1544733 | 1544733 | 2021-07-23 | Woodson | Kansas | 20207 | 235 | 5 |
1541485 | 1541485 | 2021-07-22 | Woodson | Kansas | 20207 | 233 | 5 |
1538238 | 1538238 | 2021-07-21 | Woodson | Kansas | 20207 | 233 | 5 |
1534990 | 1534990 | 2021-07-20 | Woodson | Kansas | 20207 | 228 | 5 |
1531743 | 1531743 | 2021-07-19 | Woodson | Kansas | 20207 | 228 | 5 |
1528496 | 1528496 | 2021-07-18 | Woodson | Kansas | 20207 | 228 | 5 |
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);