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 |
---|---|---|---|---|---|---|---|
2175113 | 2175113 | 2022-02-02 | Doniphan | Kansas | 20043 | 2326 | 32 |
2171860 | 2171860 | 2022-02-01 | Doniphan | Kansas | 20043 | 2296 | 32 |
2168607 | 2168607 | 2022-01-31 | Doniphan | Kansas | 20043 | 2296 | 32 |
2165352 | 2165352 | 2022-01-30 | Doniphan | Kansas | 20043 | 2242 | 32 |
2162097 | 2162097 | 2022-01-29 | Doniphan | Kansas | 20043 | 2242 | 32 |
2158842 | 2158842 | 2022-01-28 | Doniphan | Kansas | 20043 | 2242 | 32 |
2155588 | 2155588 | 2022-01-27 | Doniphan | Kansas | 20043 | 2179 | 32 |
2152335 | 2152335 | 2022-01-26 | Doniphan | Kansas | 20043 | 2179 | 32 |
2149083 | 2149083 | 2022-01-25 | Doniphan | Kansas | 20043 | 2141 | 32 |
2145831 | 2145831 | 2022-01-24 | Doniphan | Kansas | 20043 | 2141 | 32 |
2142576 | 2142576 | 2022-01-23 | Doniphan | Kansas | 20043 | 2106 | 32 |
2139321 | 2139321 | 2022-01-22 | Doniphan | Kansas | 20043 | 2106 | 32 |
2136065 | 2136065 | 2022-01-21 | Doniphan | Kansas | 20043 | 2106 | 32 |
2132813 | 2132813 | 2022-01-20 | Doniphan | Kansas | 20043 | 2023 | 32 |
2129560 | 2129560 | 2022-01-19 | Doniphan | Kansas | 20043 | 2023 | 32 |
2126306 | 2126306 | 2022-01-18 | Doniphan | Kansas | 20043 | 1933 | 32 |
2123054 | 2123054 | 2022-01-17 | Doniphan | Kansas | 20043 | 1933 | 32 |
2119802 | 2119802 | 2022-01-16 | Doniphan | Kansas | 20043 | 1933 | 32 |
2116550 | 2116550 | 2022-01-15 | Doniphan | Kansas | 20043 | 1933 | 32 |
2113299 | 2113299 | 2022-01-14 | Doniphan | Kansas | 20043 | 1933 | 32 |
2110047 | 2110047 | 2022-01-13 | Doniphan | Kansas | 20043 | 1899 | 32 |
2106796 | 2106796 | 2022-01-12 | Doniphan | Kansas | 20043 | 1899 | 32 |
2103545 | 2103545 | 2022-01-11 | Doniphan | Kansas | 20043 | 1867 | 32 |
2100294 | 2100294 | 2022-01-10 | Doniphan | Kansas | 20043 | 1867 | 32 |
2097043 | 2097043 | 2022-01-09 | Doniphan | Kansas | 20043 | 1848 | 31 |
2093791 | 2093791 | 2022-01-08 | Doniphan | Kansas | 20043 | 1848 | 31 |
2090539 | 2090539 | 2022-01-07 | Doniphan | Kansas | 20043 | 1848 | 31 |
2087288 | 2087288 | 2022-01-06 | Doniphan | Kansas | 20043 | 1829 | 29 |
2084036 | 2084036 | 2022-01-05 | Doniphan | Kansas | 20043 | 1829 | 29 |
2080784 | 2080784 | 2022-01-04 | Doniphan | Kansas | 20043 | 1810 | 29 |
2077532 | 2077532 | 2022-01-03 | Doniphan | Kansas | 20043 | 1810 | 29 |
2074281 | 2074281 | 2022-01-02 | Doniphan | Kansas | 20043 | 1775 | 29 |
2071030 | 2071030 | 2022-01-01 | Doniphan | Kansas | 20043 | 1775 | 29 |
2067779 | 2067779 | 2021-12-31 | Doniphan | Kansas | 20043 | 1775 | 29 |
2064528 | 2064528 | 2021-12-30 | Doniphan | Kansas | 20043 | 1775 | 29 |
2061278 | 2061278 | 2021-12-29 | Doniphan | Kansas | 20043 | 1775 | 29 |
2058029 | 2058029 | 2021-12-28 | Doniphan | Kansas | 20043 | 1757 | 29 |
2054780 | 2054780 | 2021-12-27 | Doniphan | Kansas | 20043 | 1757 | 29 |
2051530 | 2051530 | 2021-12-26 | Doniphan | Kansas | 20043 | 1730 | 29 |
2048280 | 2048280 | 2021-12-25 | Doniphan | Kansas | 20043 | 1730 | 29 |
2045030 | 2045030 | 2021-12-24 | Doniphan | Kansas | 20043 | 1730 | 29 |
2041781 | 2041781 | 2021-12-23 | Doniphan | Kansas | 20043 | 1730 | 29 |
2038531 | 2038531 | 2021-12-22 | Doniphan | Kansas | 20043 | 1730 | 29 |
2035281 | 2035281 | 2021-12-21 | Doniphan | Kansas | 20043 | 1710 | 29 |
2032031 | 2032031 | 2021-12-20 | Doniphan | Kansas | 20043 | 1710 | 29 |
2028780 | 2028780 | 2021-12-19 | Doniphan | Kansas | 20043 | 1694 | 29 |
2025529 | 2025529 | 2021-12-18 | Doniphan | Kansas | 20043 | 1694 | 29 |
2022278 | 2022278 | 2021-12-17 | Doniphan | Kansas | 20043 | 1694 | 29 |
2019027 | 2019027 | 2021-12-16 | Doniphan | Kansas | 20043 | 1669 | 29 |
2015777 | 2015777 | 2021-12-15 | Doniphan | Kansas | 20043 | 1669 | 29 |
2012526 | 2012526 | 2021-12-14 | Doniphan | Kansas | 20043 | 1643 | 29 |
2009275 | 2009275 | 2021-12-13 | Doniphan | Kansas | 20043 | 1643 | 29 |
2006024 | 2006024 | 2021-12-12 | Doniphan | Kansas | 20043 | 1633 | 29 |
2002773 | 2002773 | 2021-12-11 | Doniphan | Kansas | 20043 | 1633 | 29 |
1999523 | 1999523 | 2021-12-10 | Doniphan | Kansas | 20043 | 1633 | 29 |
1996272 | 1996272 | 2021-12-09 | Doniphan | Kansas | 20043 | 1620 | 29 |
1993021 | 1993021 | 2021-12-08 | Doniphan | Kansas | 20043 | 1620 | 29 |
1989770 | 1989770 | 2021-12-07 | Doniphan | Kansas | 20043 | 1602 | 29 |
1986520 | 1986520 | 2021-12-06 | Doniphan | Kansas | 20043 | 1602 | 29 |
1983270 | 1983270 | 2021-12-05 | Doniphan | Kansas | 20043 | 1584 | 29 |
1980020 | 1980020 | 2021-12-04 | Doniphan | Kansas | 20043 | 1584 | 29 |
1976770 | 1976770 | 2021-12-03 | Doniphan | Kansas | 20043 | 1584 | 29 |
1973521 | 1973521 | 2021-12-02 | Doniphan | Kansas | 20043 | 1550 | 29 |
1970271 | 1970271 | 2021-12-01 | Doniphan | Kansas | 20043 | 1550 | 29 |
1967021 | 1967021 | 2021-11-30 | Doniphan | Kansas | 20043 | 1522 | 29 |
1963769 | 1963769 | 2021-11-29 | Doniphan | Kansas | 20043 | 1522 | 29 |
1960518 | 1960518 | 2021-11-28 | Doniphan | Kansas | 20043 | 1506 | 29 |
1957267 | 1957267 | 2021-11-27 | Doniphan | Kansas | 20043 | 1506 | 29 |
1954016 | 1954016 | 2021-11-26 | Doniphan | Kansas | 20043 | 1506 | 29 |
1950765 | 1950765 | 2021-11-25 | Doniphan | Kansas | 20043 | 1506 | 29 |
1947514 | 1947514 | 2021-11-24 | Doniphan | Kansas | 20043 | 1506 | 29 |
1944263 | 1944263 | 2021-11-23 | Doniphan | Kansas | 20043 | 1493 | 28 |
1941013 | 1941013 | 2021-11-22 | Doniphan | Kansas | 20043 | 1493 | 28 |
1937763 | 1937763 | 2021-11-21 | Doniphan | Kansas | 20043 | 1480 | 28 |
1934513 | 1934513 | 2021-11-20 | Doniphan | Kansas | 20043 | 1480 | 28 |
1931262 | 1931262 | 2021-11-19 | Doniphan | Kansas | 20043 | 1480 | 28 |
1928011 | 1928011 | 2021-11-18 | Doniphan | Kansas | 20043 | 1461 | 28 |
1924761 | 1924761 | 2021-11-17 | Doniphan | Kansas | 20043 | 1461 | 28 |
1921512 | 1921512 | 2021-11-16 | Doniphan | Kansas | 20043 | 1454 | 28 |
1918262 | 1918262 | 2021-11-15 | Doniphan | Kansas | 20043 | 1454 | 28 |
1915012 | 1915012 | 2021-11-14 | Doniphan | Kansas | 20043 | 1447 | 29 |
1911762 | 1911762 | 2021-11-13 | Doniphan | Kansas | 20043 | 1447 | 29 |
1908513 | 1908513 | 2021-11-12 | Doniphan | Kansas | 20043 | 1447 | 29 |
1905264 | 1905264 | 2021-11-11 | Doniphan | Kansas | 20043 | 1437 | 29 |
1902014 | 1902014 | 2021-11-10 | Doniphan | Kansas | 20043 | 1437 | 29 |
1898764 | 1898764 | 2021-11-09 | Doniphan | Kansas | 20043 | 1423 | 29 |
1895514 | 1895514 | 2021-11-08 | Doniphan | Kansas | 20043 | 1423 | 29 |
1892264 | 1892264 | 2021-11-07 | Doniphan | Kansas | 20043 | 1415 | 29 |
1889014 | 1889014 | 2021-11-06 | Doniphan | Kansas | 20043 | 1415 | 29 |
1885764 | 1885764 | 2021-11-05 | Doniphan | Kansas | 20043 | 1415 | 29 |
1882515 | 1882515 | 2021-11-04 | Doniphan | Kansas | 20043 | 1401 | 29 |
1879266 | 1879266 | 2021-11-03 | Doniphan | Kansas | 20043 | 1401 | 29 |
1876017 | 1876017 | 2021-11-02 | Doniphan | Kansas | 20043 | 1383 | 29 |
1872768 | 1872768 | 2021-11-01 | Doniphan | Kansas | 20043 | 1383 | 29 |
1869519 | 1869519 | 2021-10-31 | Doniphan | Kansas | 20043 | 1381 | 29 |
1866270 | 1866270 | 2021-10-30 | Doniphan | Kansas | 20043 | 1381 | 29 |
1863021 | 1863021 | 2021-10-29 | Doniphan | Kansas | 20043 | 1381 | 29 |
1859772 | 1859772 | 2021-10-28 | Doniphan | Kansas | 20043 | 1375 | 28 |
1856523 | 1856523 | 2021-10-27 | Doniphan | Kansas | 20043 | 1375 | 28 |
1853274 | 1853274 | 2021-10-26 | Doniphan | Kansas | 20043 | 1369 | 28 |
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);