ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 20059 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1947522 | 1947522 | 2021-11-24 | Franklin | Kansas | 20059 | 4032 | 61 |
1944271 | 1944271 | 2021-11-23 | Franklin | Kansas | 20059 | 4009 | 60 |
1941021 | 1941021 | 2021-11-22 | Franklin | Kansas | 20059 | 4009 | 60 |
1937771 | 1937771 | 2021-11-21 | Franklin | Kansas | 20059 | 3989 | 60 |
1934521 | 1934521 | 2021-11-20 | Franklin | Kansas | 20059 | 3989 | 60 |
1931270 | 1931270 | 2021-11-19 | Franklin | Kansas | 20059 | 3989 | 60 |
1928019 | 1928019 | 2021-11-18 | Franklin | Kansas | 20059 | 3967 | 60 |
1924769 | 1924769 | 2021-11-17 | Franklin | Kansas | 20059 | 3967 | 60 |
1921520 | 1921520 | 2021-11-16 | Franklin | Kansas | 20059 | 3937 | 60 |
1918270 | 1918270 | 2021-11-15 | Franklin | Kansas | 20059 | 3937 | 60 |
1915020 | 1915020 | 2021-11-14 | Franklin | Kansas | 20059 | 3923 | 60 |
1911770 | 1911770 | 2021-11-13 | Franklin | Kansas | 20059 | 3923 | 60 |
1908521 | 1908521 | 2021-11-12 | Franklin | Kansas | 20059 | 3923 | 60 |
1905272 | 1905272 | 2021-11-11 | Franklin | Kansas | 20059 | 3909 | 60 |
1902022 | 1902022 | 2021-11-10 | Franklin | Kansas | 20059 | 3909 | 60 |
1898772 | 1898772 | 2021-11-09 | Franklin | Kansas | 20059 | 3885 | 60 |
1895522 | 1895522 | 2021-11-08 | Franklin | Kansas | 20059 | 3885 | 60 |
1892272 | 1892272 | 2021-11-07 | Franklin | Kansas | 20059 | 3864 | 60 |
1889022 | 1889022 | 2021-11-06 | Franklin | Kansas | 20059 | 3864 | 60 |
1885772 | 1885772 | 2021-11-05 | Franklin | Kansas | 20059 | 3864 | 60 |
1882523 | 1882523 | 2021-11-04 | Franklin | Kansas | 20059 | 3839 | 59 |
1879274 | 1879274 | 2021-11-03 | Franklin | Kansas | 20059 | 3839 | 59 |
1876025 | 1876025 | 2021-11-02 | Franklin | Kansas | 20059 | 3806 | 59 |
1872776 | 1872776 | 2021-11-01 | Franklin | Kansas | 20059 | 3806 | 59 |
1869527 | 1869527 | 2021-10-31 | Franklin | Kansas | 20059 | 3798 | 59 |
1866278 | 1866278 | 2021-10-30 | Franklin | Kansas | 20059 | 3798 | 59 |
1863029 | 1863029 | 2021-10-29 | Franklin | Kansas | 20059 | 3798 | 59 |
1859780 | 1859780 | 2021-10-28 | Franklin | Kansas | 20059 | 3773 | 58 |
1856531 | 1856531 | 2021-10-27 | Franklin | Kansas | 20059 | 3773 | 58 |
1853282 | 1853282 | 2021-10-26 | Franklin | Kansas | 20059 | 3755 | 58 |
1850033 | 1850033 | 2021-10-25 | Franklin | Kansas | 20059 | 3755 | 58 |
1846783 | 1846783 | 2021-10-24 | Franklin | Kansas | 20059 | 3754 | 58 |
1843533 | 1843533 | 2021-10-23 | Franklin | Kansas | 20059 | 3754 | 58 |
1840283 | 1840283 | 2021-10-22 | Franklin | Kansas | 20059 | 3754 | 58 |
1837034 | 1837034 | 2021-10-21 | Franklin | Kansas | 20059 | 3745 | 58 |
1833785 | 1833785 | 2021-10-20 | Franklin | Kansas | 20059 | 3745 | 58 |
1830536 | 1830536 | 2021-10-19 | Franklin | Kansas | 20059 | 3732 | 55 |
1827287 | 1827287 | 2021-10-18 | Franklin | Kansas | 20059 | 3732 | 55 |
1824038 | 1824038 | 2021-10-17 | Franklin | Kansas | 20059 | 3724 | 55 |
1820789 | 1820789 | 2021-10-16 | Franklin | Kansas | 20059 | 3724 | 55 |
1817540 | 1817540 | 2021-10-15 | Franklin | Kansas | 20059 | 3724 | 55 |
1814292 | 1814292 | 2021-10-14 | Franklin | Kansas | 20059 | 3713 | 55 |
1811043 | 1811043 | 2021-10-13 | Franklin | Kansas | 20059 | 3713 | 55 |
1807794 | 1807794 | 2021-10-12 | Franklin | Kansas | 20059 | 3699 | 54 |
1804543 | 1804543 | 2021-10-11 | Franklin | Kansas | 20059 | 3699 | 54 |
1801294 | 1801294 | 2021-10-10 | Franklin | Kansas | 20059 | 3692 | 55 |
1798045 | 1798045 | 2021-10-09 | Franklin | Kansas | 20059 | 3692 | 55 |
1794796 | 1794796 | 2021-10-08 | Franklin | Kansas | 20059 | 3692 | 55 |
1791548 | 1791548 | 2021-10-07 | Franklin | Kansas | 20059 | 3674 | 55 |
1788299 | 1788299 | 2021-10-06 | Franklin | Kansas | 20059 | 3674 | 55 |
1785050 | 1785050 | 2021-10-05 | Franklin | Kansas | 20059 | 3656 | 55 |
1781801 | 1781801 | 2021-10-04 | Franklin | Kansas | 20059 | 3656 | 55 |
1778551 | 1778551 | 2021-10-03 | Franklin | Kansas | 20059 | 3634 | 55 |
1775301 | 1775301 | 2021-10-02 | Franklin | Kansas | 20059 | 3634 | 55 |
1772051 | 1772051 | 2021-10-01 | Franklin | Kansas | 20059 | 3634 | 55 |
1768802 | 1768802 | 2021-09-30 | Franklin | Kansas | 20059 | 3614 | 54 |
1765553 | 1765553 | 2021-09-29 | Franklin | Kansas | 20059 | 3614 | 54 |
1762304 | 1762304 | 2021-09-28 | Franklin | Kansas | 20059 | 3568 | 54 |
1759056 | 1759056 | 2021-09-27 | Franklin | Kansas | 20059 | 3568 | 54 |
1755808 | 1755808 | 2021-09-26 | Franklin | Kansas | 20059 | 3544 | 53 |
1752560 | 1752560 | 2021-09-25 | Franklin | Kansas | 20059 | 3544 | 53 |
1749311 | 1749311 | 2021-09-24 | Franklin | Kansas | 20059 | 3544 | 53 |
1746061 | 1746061 | 2021-09-23 | Franklin | Kansas | 20059 | 3493 | 52 |
1742812 | 1742812 | 2021-09-22 | Franklin | Kansas | 20059 | 3493 | 52 |
1739563 | 1739563 | 2021-09-21 | Franklin | Kansas | 20059 | 3459 | 52 |
1736314 | 1736314 | 2021-09-20 | Franklin | Kansas | 20059 | 3459 | 52 |
1733064 | 1733064 | 2021-09-19 | Franklin | Kansas | 20059 | 3427 | 52 |
1729814 | 1729814 | 2021-09-18 | Franklin | Kansas | 20059 | 3427 | 52 |
1726564 | 1726564 | 2021-09-17 | Franklin | Kansas | 20059 | 3427 | 52 |
1723315 | 1723315 | 2021-09-16 | Franklin | Kansas | 20059 | 3405 | 52 |
1720066 | 1720066 | 2021-09-15 | Franklin | Kansas | 20059 | 3405 | 52 |
1716818 | 1716818 | 2021-09-14 | Franklin | Kansas | 20059 | 3350 | 52 |
1713572 | 1713572 | 2021-09-13 | Franklin | Kansas | 20059 | 3350 | 52 |
1710325 | 1710325 | 2021-09-12 | Franklin | Kansas | 20059 | 3324 | 52 |
1707078 | 1707078 | 2021-09-11 | Franklin | Kansas | 20059 | 3324 | 52 |
1703830 | 1703830 | 2021-09-10 | Franklin | Kansas | 20059 | 3324 | 52 |
1700580 | 1700580 | 2021-09-09 | Franklin | Kansas | 20059 | 3280 | 52 |
1697331 | 1697331 | 2021-09-08 | Franklin | Kansas | 20059 | 3280 | 52 |
1694083 | 1694083 | 2021-09-07 | Franklin | Kansas | 20059 | 3212 | 50 |
1690834 | 1690834 | 2021-09-06 | Franklin | Kansas | 20059 | 3212 | 50 |
1687584 | 1687584 | 2021-09-05 | Franklin | Kansas | 20059 | 3212 | 50 |
1684334 | 1684334 | 2021-09-04 | Franklin | Kansas | 20059 | 3212 | 50 |
1681083 | 1681083 | 2021-09-03 | Franklin | Kansas | 20059 | 3212 | 50 |
1677835 | 1677835 | 2021-09-02 | Franklin | Kansas | 20059 | 3176 | 50 |
1674588 | 1674588 | 2021-09-01 | Franklin | Kansas | 20059 | 3176 | 50 |
1671339 | 1671339 | 2021-08-31 | Franklin | Kansas | 20059 | 3124 | 50 |
1668092 | 1668092 | 2021-08-30 | Franklin | Kansas | 20059 | 3124 | 50 |
1664845 | 1664845 | 2021-08-29 | Franklin | Kansas | 20059 | 3089 | 50 |
1661597 | 1661597 | 2021-08-28 | Franklin | Kansas | 20059 | 3089 | 50 |
1658349 | 1658349 | 2021-08-27 | Franklin | Kansas | 20059 | 3089 | 50 |
1655101 | 1655101 | 2021-08-26 | Franklin | Kansas | 20059 | 3078 | 50 |
1651854 | 1651854 | 2021-08-25 | Franklin | Kansas | 20059 | 3078 | 50 |
1648605 | 1648605 | 2021-08-24 | Franklin | Kansas | 20059 | 3069 | 49 |
1645357 | 1645357 | 2021-08-23 | Franklin | Kansas | 20059 | 3069 | 49 |
1642108 | 1642108 | 2021-08-22 | Franklin | Kansas | 20059 | 3032 | 49 |
1638858 | 1638858 | 2021-08-21 | Franklin | Kansas | 20059 | 3032 | 49 |
1635608 | 1635608 | 2021-08-20 | Franklin | Kansas | 20059 | 3032 | 49 |
1632358 | 1632358 | 2021-08-19 | Franklin | Kansas | 20059 | 3021 | 47 |
1629111 | 1629111 | 2021-08-18 | Franklin | Kansas | 20059 | 3021 | 47 |
1625864 | 1625864 | 2021-08-17 | Franklin | Kansas | 20059 | 2991 | 47 |
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);