ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
757 rows where fips = 20205 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175194 | 2175194 | 2022-02-02 | Wilson | Kansas | 20205 | 2681 | 35 |
2171941 | 2171941 | 2022-02-01 | Wilson | Kansas | 20205 | 2632 | 35 |
2168688 | 2168688 | 2022-01-31 | Wilson | Kansas | 20205 | 2632 | 35 |
2165433 | 2165433 | 2022-01-30 | Wilson | Kansas | 20205 | 2601 | 35 |
2162178 | 2162178 | 2022-01-29 | Wilson | Kansas | 20205 | 2601 | 35 |
2158923 | 2158923 | 2022-01-28 | Wilson | Kansas | 20205 | 2601 | 35 |
2155669 | 2155669 | 2022-01-27 | Wilson | Kansas | 20205 | 2558 | 35 |
2152416 | 2152416 | 2022-01-26 | Wilson | Kansas | 20205 | 2558 | 35 |
2149164 | 2149164 | 2022-01-25 | Wilson | Kansas | 20205 | 2487 | 35 |
2145912 | 2145912 | 2022-01-24 | Wilson | Kansas | 20205 | 2487 | 35 |
2142657 | 2142657 | 2022-01-23 | Wilson | Kansas | 20205 | 2436 | 35 |
2139402 | 2139402 | 2022-01-22 | Wilson | Kansas | 20205 | 2436 | 35 |
2136146 | 2136146 | 2022-01-21 | Wilson | Kansas | 20205 | 2436 | 35 |
2132894 | 2132894 | 2022-01-20 | Wilson | Kansas | 20205 | 2358 | 35 |
2129641 | 2129641 | 2022-01-19 | Wilson | Kansas | 20205 | 2358 | 35 |
2126387 | 2126387 | 2022-01-18 | Wilson | Kansas | 20205 | 2173 | 35 |
2123135 | 2123135 | 2022-01-17 | Wilson | Kansas | 20205 | 2173 | 35 |
2119883 | 2119883 | 2022-01-16 | Wilson | Kansas | 20205 | 2173 | 35 |
2116631 | 2116631 | 2022-01-15 | Wilson | Kansas | 20205 | 2173 | 35 |
2113380 | 2113380 | 2022-01-14 | Wilson | Kansas | 20205 | 2173 | 35 |
2110128 | 2110128 | 2022-01-13 | Wilson | Kansas | 20205 | 2119 | 35 |
2106877 | 2106877 | 2022-01-12 | Wilson | Kansas | 20205 | 2119 | 35 |
2103626 | 2103626 | 2022-01-11 | Wilson | Kansas | 20205 | 2056 | 35 |
2100375 | 2100375 | 2022-01-10 | Wilson | Kansas | 20205 | 2056 | 35 |
2097124 | 2097124 | 2022-01-09 | Wilson | Kansas | 20205 | 2036 | 35 |
2093872 | 2093872 | 2022-01-08 | Wilson | Kansas | 20205 | 2036 | 35 |
2090620 | 2090620 | 2022-01-07 | Wilson | Kansas | 20205 | 2036 | 35 |
2087369 | 2087369 | 2022-01-06 | Wilson | Kansas | 20205 | 1984 | 35 |
2084117 | 2084117 | 2022-01-05 | Wilson | Kansas | 20205 | 1984 | 35 |
2080865 | 2080865 | 2022-01-04 | Wilson | Kansas | 20205 | 1936 | 35 |
2077613 | 2077613 | 2022-01-03 | Wilson | Kansas | 20205 | 1936 | 35 |
2074362 | 2074362 | 2022-01-02 | Wilson | Kansas | 20205 | 1900 | 35 |
2071111 | 2071111 | 2022-01-01 | Wilson | Kansas | 20205 | 1900 | 35 |
2067860 | 2067860 | 2021-12-31 | Wilson | Kansas | 20205 | 1900 | 35 |
2064609 | 2064609 | 2021-12-30 | Wilson | Kansas | 20205 | 1900 | 35 |
2061359 | 2061359 | 2021-12-29 | Wilson | Kansas | 20205 | 1900 | 35 |
2058110 | 2058110 | 2021-12-28 | Wilson | Kansas | 20205 | 1861 | 34 |
2054861 | 2054861 | 2021-12-27 | Wilson | Kansas | 20205 | 1861 | 34 |
2051611 | 2051611 | 2021-12-26 | Wilson | Kansas | 20205 | 1834 | 34 |
2048361 | 2048361 | 2021-12-25 | Wilson | Kansas | 20205 | 1834 | 34 |
2045111 | 2045111 | 2021-12-24 | Wilson | Kansas | 20205 | 1834 | 34 |
2041862 | 2041862 | 2021-12-23 | Wilson | Kansas | 20205 | 1834 | 34 |
2038612 | 2038612 | 2021-12-22 | Wilson | Kansas | 20205 | 1834 | 34 |
2035362 | 2035362 | 2021-12-21 | Wilson | Kansas | 20205 | 1813 | 34 |
2032112 | 2032112 | 2021-12-20 | Wilson | Kansas | 20205 | 1813 | 34 |
2028861 | 2028861 | 2021-12-19 | Wilson | Kansas | 20205 | 1801 | 34 |
2025610 | 2025610 | 2021-12-18 | Wilson | Kansas | 20205 | 1801 | 34 |
2022359 | 2022359 | 2021-12-17 | Wilson | Kansas | 20205 | 1801 | 34 |
2019108 | 2019108 | 2021-12-16 | Wilson | Kansas | 20205 | 1773 | 34 |
2015858 | 2015858 | 2021-12-15 | Wilson | Kansas | 20205 | 1773 | 34 |
2012607 | 2012607 | 2021-12-14 | Wilson | Kansas | 20205 | 1746 | 34 |
2009356 | 2009356 | 2021-12-13 | Wilson | Kansas | 20205 | 1746 | 34 |
2006105 | 2006105 | 2021-12-12 | Wilson | Kansas | 20205 | 1732 | 34 |
2002854 | 2002854 | 2021-12-11 | Wilson | Kansas | 20205 | 1732 | 34 |
1999604 | 1999604 | 2021-12-10 | Wilson | Kansas | 20205 | 1732 | 34 |
1996353 | 1996353 | 2021-12-09 | Wilson | Kansas | 20205 | 1709 | 34 |
1993102 | 1993102 | 2021-12-08 | Wilson | Kansas | 20205 | 1709 | 34 |
1989851 | 1989851 | 2021-12-07 | Wilson | Kansas | 20205 | 1697 | 34 |
1986601 | 1986601 | 2021-12-06 | Wilson | Kansas | 20205 | 1697 | 34 |
1983351 | 1983351 | 2021-12-05 | Wilson | Kansas | 20205 | 1692 | 34 |
1980101 | 1980101 | 2021-12-04 | Wilson | Kansas | 20205 | 1692 | 34 |
1976851 | 1976851 | 2021-12-03 | Wilson | Kansas | 20205 | 1692 | 34 |
1973602 | 1973602 | 2021-12-02 | Wilson | Kansas | 20205 | 1679 | 34 |
1970352 | 1970352 | 2021-12-01 | Wilson | Kansas | 20205 | 1679 | 34 |
1967102 | 1967102 | 2021-11-30 | Wilson | Kansas | 20205 | 1656 | 34 |
1963850 | 1963850 | 2021-11-29 | Wilson | Kansas | 20205 | 1656 | 34 |
1960599 | 1960599 | 2021-11-28 | Wilson | Kansas | 20205 | 1638 | 34 |
1957348 | 1957348 | 2021-11-27 | Wilson | Kansas | 20205 | 1638 | 34 |
1954097 | 1954097 | 2021-11-26 | Wilson | Kansas | 20205 | 1638 | 34 |
1950846 | 1950846 | 2021-11-25 | Wilson | Kansas | 20205 | 1638 | 34 |
1947595 | 1947595 | 2021-11-24 | Wilson | Kansas | 20205 | 1638 | 34 |
1944344 | 1944344 | 2021-11-23 | Wilson | Kansas | 20205 | 1632 | 34 |
1941094 | 1941094 | 2021-11-22 | Wilson | Kansas | 20205 | 1632 | 34 |
1937844 | 1937844 | 2021-11-21 | Wilson | Kansas | 20205 | 1625 | 34 |
1934594 | 1934594 | 2021-11-20 | Wilson | Kansas | 20205 | 1625 | 34 |
1931343 | 1931343 | 2021-11-19 | Wilson | Kansas | 20205 | 1625 | 34 |
1928092 | 1928092 | 2021-11-18 | Wilson | Kansas | 20205 | 1608 | 34 |
1924842 | 1924842 | 2021-11-17 | Wilson | Kansas | 20205 | 1608 | 34 |
1921593 | 1921593 | 2021-11-16 | Wilson | Kansas | 20205 | 1604 | 34 |
1918343 | 1918343 | 2021-11-15 | Wilson | Kansas | 20205 | 1604 | 34 |
1915093 | 1915093 | 2021-11-14 | Wilson | Kansas | 20205 | 1600 | 34 |
1911843 | 1911843 | 2021-11-13 | Wilson | Kansas | 20205 | 1600 | 34 |
1908594 | 1908594 | 2021-11-12 | Wilson | Kansas | 20205 | 1600 | 34 |
1905345 | 1905345 | 2021-11-11 | Wilson | Kansas | 20205 | 1587 | 34 |
1902095 | 1902095 | 2021-11-10 | Wilson | Kansas | 20205 | 1587 | 34 |
1898845 | 1898845 | 2021-11-09 | Wilson | Kansas | 20205 | 1579 | 33 |
1895595 | 1895595 | 2021-11-08 | Wilson | Kansas | 20205 | 1579 | 33 |
1892345 | 1892345 | 2021-11-07 | Wilson | Kansas | 20205 | 1571 | 33 |
1889095 | 1889095 | 2021-11-06 | Wilson | Kansas | 20205 | 1571 | 33 |
1885845 | 1885845 | 2021-11-05 | Wilson | Kansas | 20205 | 1571 | 33 |
1882596 | 1882596 | 2021-11-04 | Wilson | Kansas | 20205 | 1568 | 33 |
1879347 | 1879347 | 2021-11-03 | Wilson | Kansas | 20205 | 1568 | 33 |
1876098 | 1876098 | 2021-11-02 | Wilson | Kansas | 20205 | 1559 | 33 |
1872849 | 1872849 | 2021-11-01 | Wilson | Kansas | 20205 | 1559 | 33 |
1869600 | 1869600 | 2021-10-31 | Wilson | Kansas | 20205 | 1553 | 33 |
1866351 | 1866351 | 2021-10-30 | Wilson | Kansas | 20205 | 1553 | 33 |
1863102 | 1863102 | 2021-10-29 | Wilson | Kansas | 20205 | 1553 | 33 |
1859853 | 1859853 | 2021-10-28 | Wilson | Kansas | 20205 | 1546 | 33 |
1856604 | 1856604 | 2021-10-27 | Wilson | Kansas | 20205 | 1546 | 33 |
1853355 | 1853355 | 2021-10-26 | Wilson | Kansas | 20205 | 1530 | 33 |
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);