ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 20111 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175147 | 2175147 | 2022-02-02 | Lyon | Kansas | 20111 | 9507 | 110 |
2171894 | 2171894 | 2022-02-01 | Lyon | Kansas | 20111 | 9390 | 109 |
2168641 | 2168641 | 2022-01-31 | Lyon | Kansas | 20111 | 9390 | 109 |
2165386 | 2165386 | 2022-01-30 | Lyon | Kansas | 20111 | 9285 | 109 |
2162131 | 2162131 | 2022-01-29 | Lyon | Kansas | 20111 | 9285 | 109 |
2158876 | 2158876 | 2022-01-28 | Lyon | Kansas | 20111 | 9285 | 109 |
2155622 | 2155622 | 2022-01-27 | Lyon | Kansas | 20111 | 9163 | 109 |
2152369 | 2152369 | 2022-01-26 | Lyon | Kansas | 20111 | 9163 | 109 |
2149117 | 2149117 | 2022-01-25 | Lyon | Kansas | 20111 | 8911 | 105 |
2145865 | 2145865 | 2022-01-24 | Lyon | Kansas | 20111 | 8911 | 105 |
2142610 | 2142610 | 2022-01-23 | Lyon | Kansas | 20111 | 8789 | 105 |
2139355 | 2139355 | 2022-01-22 | Lyon | Kansas | 20111 | 8789 | 105 |
2136099 | 2136099 | 2022-01-21 | Lyon | Kansas | 20111 | 8789 | 105 |
2132847 | 2132847 | 2022-01-20 | Lyon | Kansas | 20111 | 8466 | 105 |
2129594 | 2129594 | 2022-01-19 | Lyon | Kansas | 20111 | 8466 | 105 |
2126340 | 2126340 | 2022-01-18 | Lyon | Kansas | 20111 | 7797 | 103 |
2123088 | 2123088 | 2022-01-17 | Lyon | Kansas | 20111 | 7797 | 103 |
2119836 | 2119836 | 2022-01-16 | Lyon | Kansas | 20111 | 7797 | 103 |
2116584 | 2116584 | 2022-01-15 | Lyon | Kansas | 20111 | 7797 | 103 |
2113333 | 2113333 | 2022-01-14 | Lyon | Kansas | 20111 | 7797 | 103 |
2110081 | 2110081 | 2022-01-13 | Lyon | Kansas | 20111 | 7578 | 102 |
2106830 | 2106830 | 2022-01-12 | Lyon | Kansas | 20111 | 7578 | 102 |
2103579 | 2103579 | 2022-01-11 | Lyon | Kansas | 20111 | 7246 | 101 |
2100328 | 2100328 | 2022-01-10 | Lyon | Kansas | 20111 | 7246 | 101 |
2097077 | 2097077 | 2022-01-09 | Lyon | Kansas | 20111 | 7099 | 101 |
2093825 | 2093825 | 2022-01-08 | Lyon | Kansas | 20111 | 7099 | 101 |
2090573 | 2090573 | 2022-01-07 | Lyon | Kansas | 20111 | 7099 | 101 |
2087322 | 2087322 | 2022-01-06 | Lyon | Kansas | 20111 | 6892 | 99 |
2084070 | 2084070 | 2022-01-05 | Lyon | Kansas | 20111 | 6892 | 99 |
2080818 | 2080818 | 2022-01-04 | Lyon | Kansas | 20111 | 6749 | 99 |
2077566 | 2077566 | 2022-01-03 | Lyon | Kansas | 20111 | 6749 | 99 |
2074315 | 2074315 | 2022-01-02 | Lyon | Kansas | 20111 | 6591 | 99 |
2071064 | 2071064 | 2022-01-01 | Lyon | Kansas | 20111 | 6591 | 99 |
2067813 | 2067813 | 2021-12-31 | Lyon | Kansas | 20111 | 6591 | 99 |
2064562 | 2064562 | 2021-12-30 | Lyon | Kansas | 20111 | 6591 | 99 |
2061312 | 2061312 | 2021-12-29 | Lyon | Kansas | 20111 | 6591 | 99 |
2058063 | 2058063 | 2021-12-28 | Lyon | Kansas | 20111 | 6493 | 98 |
2054814 | 2054814 | 2021-12-27 | Lyon | Kansas | 20111 | 6493 | 98 |
2051564 | 2051564 | 2021-12-26 | Lyon | Kansas | 20111 | 6417 | 98 |
2048314 | 2048314 | 2021-12-25 | Lyon | Kansas | 20111 | 6417 | 98 |
2045064 | 2045064 | 2021-12-24 | Lyon | Kansas | 20111 | 6417 | 98 |
2041815 | 2041815 | 2021-12-23 | Lyon | Kansas | 20111 | 6417 | 98 |
2038565 | 2038565 | 2021-12-22 | Lyon | Kansas | 20111 | 6417 | 98 |
2035315 | 2035315 | 2021-12-21 | Lyon | Kansas | 20111 | 6360 | 98 |
2032065 | 2032065 | 2021-12-20 | Lyon | Kansas | 20111 | 6360 | 98 |
2028814 | 2028814 | 2021-12-19 | Lyon | Kansas | 20111 | 6340 | 98 |
2025563 | 2025563 | 2021-12-18 | Lyon | Kansas | 20111 | 6340 | 98 |
2022312 | 2022312 | 2021-12-17 | Lyon | Kansas | 20111 | 6340 | 98 |
2019061 | 2019061 | 2021-12-16 | Lyon | Kansas | 20111 | 6256 | 98 |
2015811 | 2015811 | 2021-12-15 | Lyon | Kansas | 20111 | 6256 | 98 |
2012560 | 2012560 | 2021-12-14 | Lyon | Kansas | 20111 | 6162 | 98 |
2009309 | 2009309 | 2021-12-13 | Lyon | Kansas | 20111 | 6162 | 98 |
2006058 | 2006058 | 2021-12-12 | Lyon | Kansas | 20111 | 6116 | 98 |
2002807 | 2002807 | 2021-12-11 | Lyon | Kansas | 20111 | 6116 | 98 |
1999557 | 1999557 | 2021-12-10 | Lyon | Kansas | 20111 | 6116 | 98 |
1996306 | 1996306 | 2021-12-09 | Lyon | Kansas | 20111 | 6056 | 98 |
1993055 | 1993055 | 2021-12-08 | Lyon | Kansas | 20111 | 6056 | 98 |
1989804 | 1989804 | 2021-12-07 | Lyon | Kansas | 20111 | 5984 | 97 |
1986554 | 1986554 | 2021-12-06 | Lyon | Kansas | 20111 | 5984 | 97 |
1983304 | 1983304 | 2021-12-05 | Lyon | Kansas | 20111 | 5958 | 97 |
1980054 | 1980054 | 2021-12-04 | Lyon | Kansas | 20111 | 5958 | 97 |
1976804 | 1976804 | 2021-12-03 | Lyon | Kansas | 20111 | 5958 | 97 |
1973555 | 1973555 | 2021-12-02 | Lyon | Kansas | 20111 | 5900 | 97 |
1970305 | 1970305 | 2021-12-01 | Lyon | Kansas | 20111 | 5900 | 97 |
1967055 | 1967055 | 2021-11-30 | Lyon | Kansas | 20111 | 5837 | 96 |
1963803 | 1963803 | 2021-11-29 | Lyon | Kansas | 20111 | 5837 | 96 |
1960552 | 1960552 | 2021-11-28 | Lyon | Kansas | 20111 | 5802 | 96 |
1957301 | 1957301 | 2021-11-27 | Lyon | Kansas | 20111 | 5802 | 96 |
1954050 | 1954050 | 2021-11-26 | Lyon | Kansas | 20111 | 5802 | 96 |
1950799 | 1950799 | 2021-11-25 | Lyon | Kansas | 20111 | 5802 | 96 |
1947548 | 1947548 | 2021-11-24 | Lyon | Kansas | 20111 | 5802 | 96 |
1944297 | 1944297 | 2021-11-23 | Lyon | Kansas | 20111 | 5770 | 94 |
1941047 | 1941047 | 2021-11-22 | Lyon | Kansas | 20111 | 5770 | 94 |
1937797 | 1937797 | 2021-11-21 | Lyon | Kansas | 20111 | 5737 | 94 |
1934547 | 1934547 | 2021-11-20 | Lyon | Kansas | 20111 | 5737 | 94 |
1931296 | 1931296 | 2021-11-19 | Lyon | Kansas | 20111 | 5737 | 94 |
1928045 | 1928045 | 2021-11-18 | Lyon | Kansas | 20111 | 5702 | 93 |
1924795 | 1924795 | 2021-11-17 | Lyon | Kansas | 20111 | 5702 | 93 |
1921546 | 1921546 | 2021-11-16 | Lyon | Kansas | 20111 | 5658 | 93 |
1918296 | 1918296 | 2021-11-15 | Lyon | Kansas | 20111 | 5658 | 93 |
1915046 | 1915046 | 2021-11-14 | Lyon | Kansas | 20111 | 5647 | 93 |
1911796 | 1911796 | 2021-11-13 | Lyon | Kansas | 20111 | 5647 | 93 |
1908547 | 1908547 | 2021-11-12 | Lyon | Kansas | 20111 | 5647 | 93 |
1905298 | 1905298 | 2021-11-11 | Lyon | Kansas | 20111 | 5624 | 93 |
1902048 | 1902048 | 2021-11-10 | Lyon | Kansas | 20111 | 5624 | 93 |
1898798 | 1898798 | 2021-11-09 | Lyon | Kansas | 20111 | 5586 | 93 |
1895548 | 1895548 | 2021-11-08 | Lyon | Kansas | 20111 | 5586 | 93 |
1892298 | 1892298 | 2021-11-07 | Lyon | Kansas | 20111 | 5553 | 93 |
1889048 | 1889048 | 2021-11-06 | Lyon | Kansas | 20111 | 5553 | 93 |
1885798 | 1885798 | 2021-11-05 | Lyon | Kansas | 20111 | 5553 | 93 |
1882549 | 1882549 | 2021-11-04 | Lyon | Kansas | 20111 | 5523 | 92 |
1879300 | 1879300 | 2021-11-03 | Lyon | Kansas | 20111 | 5523 | 92 |
1876051 | 1876051 | 2021-11-02 | Lyon | Kansas | 20111 | 5490 | 92 |
1872802 | 1872802 | 2021-11-01 | Lyon | Kansas | 20111 | 5490 | 92 |
1869553 | 1869553 | 2021-10-31 | Lyon | Kansas | 20111 | 5483 | 92 |
1866304 | 1866304 | 2021-10-30 | Lyon | Kansas | 20111 | 5483 | 92 |
1863055 | 1863055 | 2021-10-29 | Lyon | Kansas | 20111 | 5483 | 92 |
1859806 | 1859806 | 2021-10-28 | Lyon | Kansas | 20111 | 5462 | 92 |
1856557 | 1856557 | 2021-10-27 | Lyon | Kansas | 20111 | 5462 | 92 |
1853308 | 1853308 | 2021-10-26 | Lyon | Kansas | 20111 | 5435 | 92 |
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);