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 |
---|---|---|---|---|---|---|---|
1947596 | 1947596 | 2021-11-24 | Woodson | Kansas | 20207 | 441 | 10 |
1944345 | 1944345 | 2021-11-23 | Woodson | Kansas | 20207 | 438 | 10 |
1941095 | 1941095 | 2021-11-22 | Woodson | Kansas | 20207 | 438 | 10 |
1937845 | 1937845 | 2021-11-21 | Woodson | Kansas | 20207 | 434 | 10 |
1934595 | 1934595 | 2021-11-20 | Woodson | Kansas | 20207 | 434 | 10 |
1931344 | 1931344 | 2021-11-19 | Woodson | Kansas | 20207 | 434 | 10 |
1928093 | 1928093 | 2021-11-18 | Woodson | Kansas | 20207 | 429 | 10 |
1924843 | 1924843 | 2021-11-17 | Woodson | Kansas | 20207 | 429 | 10 |
1921594 | 1921594 | 2021-11-16 | Woodson | Kansas | 20207 | 427 | 10 |
1918344 | 1918344 | 2021-11-15 | Woodson | Kansas | 20207 | 427 | 10 |
1915094 | 1915094 | 2021-11-14 | Woodson | Kansas | 20207 | 425 | 10 |
1911844 | 1911844 | 2021-11-13 | Woodson | Kansas | 20207 | 425 | 10 |
1908595 | 1908595 | 2021-11-12 | Woodson | Kansas | 20207 | 425 | 10 |
1905346 | 1905346 | 2021-11-11 | Woodson | Kansas | 20207 | 424 | 10 |
1902096 | 1902096 | 2021-11-10 | Woodson | Kansas | 20207 | 424 | 10 |
1898846 | 1898846 | 2021-11-09 | Woodson | Kansas | 20207 | 424 | 10 |
1895596 | 1895596 | 2021-11-08 | Woodson | Kansas | 20207 | 424 | 10 |
1892346 | 1892346 | 2021-11-07 | Woodson | Kansas | 20207 | 424 | 10 |
1889096 | 1889096 | 2021-11-06 | Woodson | Kansas | 20207 | 424 | 10 |
1885846 | 1885846 | 2021-11-05 | Woodson | Kansas | 20207 | 424 | 10 |
1882597 | 1882597 | 2021-11-04 | Woodson | Kansas | 20207 | 424 | 10 |
1879348 | 1879348 | 2021-11-03 | Woodson | Kansas | 20207 | 424 | 10 |
1876099 | 1876099 | 2021-11-02 | Woodson | Kansas | 20207 | 415 | 10 |
1872850 | 1872850 | 2021-11-01 | Woodson | Kansas | 20207 | 415 | 10 |
1869601 | 1869601 | 2021-10-31 | Woodson | Kansas | 20207 | 414 | 10 |
1866352 | 1866352 | 2021-10-30 | Woodson | Kansas | 20207 | 414 | 10 |
1863103 | 1863103 | 2021-10-29 | Woodson | Kansas | 20207 | 414 | 10 |
1859854 | 1859854 | 2021-10-28 | Woodson | Kansas | 20207 | 407 | 10 |
1856605 | 1856605 | 2021-10-27 | Woodson | Kansas | 20207 | 407 | 10 |
1853356 | 1853356 | 2021-10-26 | Woodson | Kansas | 20207 | 400 | 9 |
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 |
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);