ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Jackson" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1947535 | 1947535 | 2021-11-24 | Jackson | Kansas | 20085 | 2305 | 20 |
1944284 | 1944284 | 2021-11-23 | Jackson | Kansas | 20085 | 2283 | 20 |
1941034 | 1941034 | 2021-11-22 | Jackson | Kansas | 20085 | 2283 | 20 |
1937784 | 1937784 | 2021-11-21 | Jackson | Kansas | 20085 | 2266 | 20 |
1934534 | 1934534 | 2021-11-20 | Jackson | Kansas | 20085 | 2266 | 20 |
1931283 | 1931283 | 2021-11-19 | Jackson | Kansas | 20085 | 2266 | 20 |
1928032 | 1928032 | 2021-11-18 | Jackson | Kansas | 20085 | 2245 | 20 |
1924782 | 1924782 | 2021-11-17 | Jackson | Kansas | 20085 | 2245 | 20 |
1921533 | 1921533 | 2021-11-16 | Jackson | Kansas | 20085 | 2220 | 20 |
1918283 | 1918283 | 2021-11-15 | Jackson | Kansas | 20085 | 2220 | 20 |
1915033 | 1915033 | 2021-11-14 | Jackson | Kansas | 20085 | 2198 | 20 |
1911783 | 1911783 | 2021-11-13 | Jackson | Kansas | 20085 | 2198 | 20 |
1908534 | 1908534 | 2021-11-12 | Jackson | Kansas | 20085 | 2198 | 20 |
1905285 | 1905285 | 2021-11-11 | Jackson | Kansas | 20085 | 2181 | 20 |
1902035 | 1902035 | 2021-11-10 | Jackson | Kansas | 20085 | 2181 | 20 |
1898785 | 1898785 | 2021-11-09 | Jackson | Kansas | 20085 | 2151 | 19 |
1895535 | 1895535 | 2021-11-08 | Jackson | Kansas | 20085 | 2151 | 19 |
1892285 | 1892285 | 2021-11-07 | Jackson | Kansas | 20085 | 2129 | 19 |
1889035 | 1889035 | 2021-11-06 | Jackson | Kansas | 20085 | 2129 | 19 |
1885785 | 1885785 | 2021-11-05 | Jackson | Kansas | 20085 | 2129 | 19 |
1882536 | 1882536 | 2021-11-04 | Jackson | Kansas | 20085 | 2098 | 19 |
1879287 | 1879287 | 2021-11-03 | Jackson | Kansas | 20085 | 2098 | 19 |
1876038 | 1876038 | 2021-11-02 | Jackson | Kansas | 20085 | 2068 | 19 |
1872789 | 1872789 | 2021-11-01 | Jackson | Kansas | 20085 | 2068 | 19 |
1869540 | 1869540 | 2021-10-31 | Jackson | Kansas | 20085 | 2051 | 19 |
1866291 | 1866291 | 2021-10-30 | Jackson | Kansas | 20085 | 2051 | 19 |
1863042 | 1863042 | 2021-10-29 | Jackson | Kansas | 20085 | 2051 | 19 |
1859793 | 1859793 | 2021-10-28 | Jackson | Kansas | 20085 | 2029 | 19 |
1856544 | 1856544 | 2021-10-27 | Jackson | Kansas | 20085 | 2029 | 19 |
1853295 | 1853295 | 2021-10-26 | Jackson | Kansas | 20085 | 1987 | 19 |
1850046 | 1850046 | 2021-10-25 | Jackson | Kansas | 20085 | 1987 | 19 |
1846796 | 1846796 | 2021-10-24 | Jackson | Kansas | 20085 | 1970 | 19 |
1843546 | 1843546 | 2021-10-23 | Jackson | Kansas | 20085 | 1970 | 19 |
1840296 | 1840296 | 2021-10-22 | Jackson | Kansas | 20085 | 1970 | 19 |
1837047 | 1837047 | 2021-10-21 | Jackson | Kansas | 20085 | 1959 | 19 |
1833798 | 1833798 | 2021-10-20 | Jackson | Kansas | 20085 | 1959 | 19 |
1830549 | 1830549 | 2021-10-19 | Jackson | Kansas | 20085 | 1941 | 19 |
1827300 | 1827300 | 2021-10-18 | Jackson | Kansas | 20085 | 1941 | 19 |
1824051 | 1824051 | 2021-10-17 | Jackson | Kansas | 20085 | 1936 | 19 |
1820802 | 1820802 | 2021-10-16 | Jackson | Kansas | 20085 | 1936 | 19 |
1817553 | 1817553 | 2021-10-15 | Jackson | Kansas | 20085 | 1936 | 19 |
1814305 | 1814305 | 2021-10-14 | Jackson | Kansas | 20085 | 1926 | 19 |
1811056 | 1811056 | 2021-10-13 | Jackson | Kansas | 20085 | 1926 | 19 |
1807807 | 1807807 | 2021-10-12 | Jackson | Kansas | 20085 | 1918 | 19 |
1804556 | 1804556 | 2021-10-11 | Jackson | Kansas | 20085 | 1918 | 19 |
1801307 | 1801307 | 2021-10-10 | Jackson | Kansas | 20085 | 1911 | 19 |
1798058 | 1798058 | 2021-10-09 | Jackson | Kansas | 20085 | 1911 | 19 |
1794809 | 1794809 | 2021-10-08 | Jackson | Kansas | 20085 | 1911 | 19 |
1791561 | 1791561 | 2021-10-07 | Jackson | Kansas | 20085 | 1903 | 19 |
1788312 | 1788312 | 2021-10-06 | Jackson | Kansas | 20085 | 1903 | 19 |
1785063 | 1785063 | 2021-10-05 | Jackson | Kansas | 20085 | 1897 | 19 |
1781814 | 1781814 | 2021-10-04 | Jackson | Kansas | 20085 | 1897 | 19 |
1778564 | 1778564 | 2021-10-03 | Jackson | Kansas | 20085 | 1891 | 19 |
1775314 | 1775314 | 2021-10-02 | Jackson | Kansas | 20085 | 1891 | 19 |
1772064 | 1772064 | 2021-10-01 | Jackson | Kansas | 20085 | 1891 | 19 |
1768815 | 1768815 | 2021-09-30 | Jackson | Kansas | 20085 | 1877 | 19 |
1765566 | 1765566 | 2021-09-29 | Jackson | Kansas | 20085 | 1877 | 19 |
1762317 | 1762317 | 2021-09-28 | Jackson | Kansas | 20085 | 1867 | 19 |
1759069 | 1759069 | 2021-09-27 | Jackson | Kansas | 20085 | 1867 | 19 |
1755821 | 1755821 | 2021-09-26 | Jackson | Kansas | 20085 | 1864 | 18 |
1752573 | 1752573 | 2021-09-25 | Jackson | Kansas | 20085 | 1864 | 18 |
1749324 | 1749324 | 2021-09-24 | Jackson | Kansas | 20085 | 1864 | 18 |
1746074 | 1746074 | 2021-09-23 | Jackson | Kansas | 20085 | 1863 | 18 |
1742825 | 1742825 | 2021-09-22 | Jackson | Kansas | 20085 | 1863 | 18 |
1739576 | 1739576 | 2021-09-21 | Jackson | Kansas | 20085 | 1847 | 19 |
1736327 | 1736327 | 2021-09-20 | Jackson | Kansas | 20085 | 1847 | 19 |
1733077 | 1733077 | 2021-09-19 | Jackson | Kansas | 20085 | 1843 | 19 |
1729827 | 1729827 | 2021-09-18 | Jackson | Kansas | 20085 | 1843 | 19 |
1726577 | 1726577 | 2021-09-17 | Jackson | Kansas | 20085 | 1843 | 19 |
1723328 | 1723328 | 2021-09-16 | Jackson | Kansas | 20085 | 1836 | 19 |
1720079 | 1720079 | 2021-09-15 | Jackson | Kansas | 20085 | 1836 | 19 |
1716831 | 1716831 | 2021-09-14 | Jackson | Kansas | 20085 | 1821 | 19 |
1713585 | 1713585 | 2021-09-13 | Jackson | Kansas | 20085 | 1821 | 19 |
1710338 | 1710338 | 2021-09-12 | Jackson | Kansas | 20085 | 1817 | 19 |
1707091 | 1707091 | 2021-09-11 | Jackson | Kansas | 20085 | 1817 | 19 |
1703843 | 1703843 | 2021-09-10 | Jackson | Kansas | 20085 | 1817 | 19 |
1700593 | 1700593 | 2021-09-09 | Jackson | Kansas | 20085 | 1797 | 18 |
1697344 | 1697344 | 2021-09-08 | Jackson | Kansas | 20085 | 1797 | 18 |
1694096 | 1694096 | 2021-09-07 | Jackson | Kansas | 20085 | 1764 | 18 |
1690847 | 1690847 | 2021-09-06 | Jackson | Kansas | 20085 | 1764 | 18 |
1687597 | 1687597 | 2021-09-05 | Jackson | Kansas | 20085 | 1764 | 18 |
1684347 | 1684347 | 2021-09-04 | Jackson | Kansas | 20085 | 1764 | 18 |
1681096 | 1681096 | 2021-09-03 | Jackson | Kansas | 20085 | 1764 | 18 |
1677848 | 1677848 | 2021-09-02 | Jackson | Kansas | 20085 | 1743 | 18 |
1674601 | 1674601 | 2021-09-01 | Jackson | Kansas | 20085 | 1743 | 18 |
1671352 | 1671352 | 2021-08-31 | Jackson | Kansas | 20085 | 1709 | 18 |
1668105 | 1668105 | 2021-08-30 | Jackson | Kansas | 20085 | 1709 | 18 |
1664858 | 1664858 | 2021-08-29 | Jackson | Kansas | 20085 | 1680 | 18 |
1661610 | 1661610 | 2021-08-28 | Jackson | Kansas | 20085 | 1680 | 18 |
1658362 | 1658362 | 2021-08-27 | Jackson | Kansas | 20085 | 1680 | 18 |
1655114 | 1655114 | 2021-08-26 | Jackson | Kansas | 20085 | 1654 | 18 |
1651867 | 1651867 | 2021-08-25 | Jackson | Kansas | 20085 | 1654 | 18 |
1648618 | 1648618 | 2021-08-24 | Jackson | Kansas | 20085 | 1612 | 18 |
1645370 | 1645370 | 2021-08-23 | Jackson | Kansas | 20085 | 1612 | 18 |
1642121 | 1642121 | 2021-08-22 | Jackson | Kansas | 20085 | 1593 | 18 |
1638871 | 1638871 | 2021-08-21 | Jackson | Kansas | 20085 | 1593 | 18 |
1635621 | 1635621 | 2021-08-20 | Jackson | Kansas | 20085 | 1593 | 18 |
1632371 | 1632371 | 2021-08-19 | Jackson | Kansas | 20085 | 1582 | 17 |
1629124 | 1629124 | 2021-08-18 | Jackson | Kansas | 20085 | 1582 | 17 |
1625877 | 1625877 | 2021-08-17 | Jackson | Kansas | 20085 | 1560 | 17 |
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);