ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
740 rows where county = "Ellsworth" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175118 | 2175118 | 2022-02-02 | Ellsworth | Kansas | 20053 | 1962 | 30 |
2171865 | 2171865 | 2022-02-01 | Ellsworth | Kansas | 20053 | 1948 | 30 |
2168612 | 2168612 | 2022-01-31 | Ellsworth | Kansas | 20053 | 1948 | 30 |
2165357 | 2165357 | 2022-01-30 | Ellsworth | Kansas | 20053 | 1926 | 30 |
2162102 | 2162102 | 2022-01-29 | Ellsworth | Kansas | 20053 | 1926 | 30 |
2158847 | 2158847 | 2022-01-28 | Ellsworth | Kansas | 20053 | 1926 | 30 |
2155593 | 2155593 | 2022-01-27 | Ellsworth | Kansas | 20053 | 1897 | 30 |
2152340 | 2152340 | 2022-01-26 | Ellsworth | Kansas | 20053 | 1897 | 30 |
2149088 | 2149088 | 2022-01-25 | Ellsworth | Kansas | 20053 | 1873 | 30 |
2145836 | 2145836 | 2022-01-24 | Ellsworth | Kansas | 20053 | 1873 | 30 |
2142581 | 2142581 | 2022-01-23 | Ellsworth | Kansas | 20053 | 1844 | 30 |
2139326 | 2139326 | 2022-01-22 | Ellsworth | Kansas | 20053 | 1844 | 30 |
2136070 | 2136070 | 2022-01-21 | Ellsworth | Kansas | 20053 | 1844 | 30 |
2132818 | 2132818 | 2022-01-20 | Ellsworth | Kansas | 20053 | 1807 | 30 |
2129565 | 2129565 | 2022-01-19 | Ellsworth | Kansas | 20053 | 1807 | 30 |
2126311 | 2126311 | 2022-01-18 | Ellsworth | Kansas | 20053 | 1740 | 30 |
2123059 | 2123059 | 2022-01-17 | Ellsworth | Kansas | 20053 | 1740 | 30 |
2119807 | 2119807 | 2022-01-16 | Ellsworth | Kansas | 20053 | 1740 | 30 |
2116555 | 2116555 | 2022-01-15 | Ellsworth | Kansas | 20053 | 1740 | 30 |
2113304 | 2113304 | 2022-01-14 | Ellsworth | Kansas | 20053 | 1740 | 30 |
2110052 | 2110052 | 2022-01-13 | Ellsworth | Kansas | 20053 | 1707 | 30 |
2106801 | 2106801 | 2022-01-12 | Ellsworth | Kansas | 20053 | 1707 | 30 |
2103550 | 2103550 | 2022-01-11 | Ellsworth | Kansas | 20053 | 1678 | 30 |
2100299 | 2100299 | 2022-01-10 | Ellsworth | Kansas | 20053 | 1678 | 30 |
2097048 | 2097048 | 2022-01-09 | Ellsworth | Kansas | 20053 | 1660 | 30 |
2093796 | 2093796 | 2022-01-08 | Ellsworth | Kansas | 20053 | 1660 | 30 |
2090544 | 2090544 | 2022-01-07 | Ellsworth | Kansas | 20053 | 1660 | 30 |
2087293 | 2087293 | 2022-01-06 | Ellsworth | Kansas | 20053 | 1639 | 30 |
2084041 | 2084041 | 2022-01-05 | Ellsworth | Kansas | 20053 | 1639 | 30 |
2080789 | 2080789 | 2022-01-04 | Ellsworth | Kansas | 20053 | 1619 | 31 |
2077537 | 2077537 | 2022-01-03 | Ellsworth | Kansas | 20053 | 1619 | 31 |
2074286 | 2074286 | 2022-01-02 | Ellsworth | Kansas | 20053 | 1602 | 31 |
2071035 | 2071035 | 2022-01-01 | Ellsworth | Kansas | 20053 | 1602 | 31 |
2067784 | 2067784 | 2021-12-31 | Ellsworth | Kansas | 20053 | 1602 | 31 |
2064533 | 2064533 | 2021-12-30 | Ellsworth | Kansas | 20053 | 1602 | 31 |
2061283 | 2061283 | 2021-12-29 | Ellsworth | Kansas | 20053 | 1602 | 31 |
2058034 | 2058034 | 2021-12-28 | Ellsworth | Kansas | 20053 | 1591 | 31 |
2054785 | 2054785 | 2021-12-27 | Ellsworth | Kansas | 20053 | 1591 | 31 |
2051535 | 2051535 | 2021-12-26 | Ellsworth | Kansas | 20053 | 1585 | 31 |
2048285 | 2048285 | 2021-12-25 | Ellsworth | Kansas | 20053 | 1585 | 31 |
2045035 | 2045035 | 2021-12-24 | Ellsworth | Kansas | 20053 | 1585 | 31 |
2041786 | 2041786 | 2021-12-23 | Ellsworth | Kansas | 20053 | 1585 | 31 |
2038536 | 2038536 | 2021-12-22 | Ellsworth | Kansas | 20053 | 1585 | 31 |
2035286 | 2035286 | 2021-12-21 | Ellsworth | Kansas | 20053 | 1576 | 31 |
2032036 | 2032036 | 2021-12-20 | Ellsworth | Kansas | 20053 | 1576 | 31 |
2028785 | 2028785 | 2021-12-19 | Ellsworth | Kansas | 20053 | 1568 | 31 |
2025534 | 2025534 | 2021-12-18 | Ellsworth | Kansas | 20053 | 1568 | 31 |
2022283 | 2022283 | 2021-12-17 | Ellsworth | Kansas | 20053 | 1568 | 31 |
2019032 | 2019032 | 2021-12-16 | Ellsworth | Kansas | 20053 | 1561 | 31 |
2015782 | 2015782 | 2021-12-15 | Ellsworth | Kansas | 20053 | 1561 | 31 |
2012531 | 2012531 | 2021-12-14 | Ellsworth | Kansas | 20053 | 1551 | 31 |
2009280 | 2009280 | 2021-12-13 | Ellsworth | Kansas | 20053 | 1551 | 31 |
2006029 | 2006029 | 2021-12-12 | Ellsworth | Kansas | 20053 | 1539 | 31 |
2002778 | 2002778 | 2021-12-11 | Ellsworth | Kansas | 20053 | 1539 | 31 |
1999528 | 1999528 | 2021-12-10 | Ellsworth | Kansas | 20053 | 1539 | 31 |
1996277 | 1996277 | 2021-12-09 | Ellsworth | Kansas | 20053 | 1528 | 31 |
1993026 | 1993026 | 2021-12-08 | Ellsworth | Kansas | 20053 | 1528 | 31 |
1989775 | 1989775 | 2021-12-07 | Ellsworth | Kansas | 20053 | 1521 | 31 |
1986525 | 1986525 | 2021-12-06 | Ellsworth | Kansas | 20053 | 1521 | 31 |
1983275 | 1983275 | 2021-12-05 | Ellsworth | Kansas | 20053 | 1512 | 31 |
1980025 | 1980025 | 2021-12-04 | Ellsworth | Kansas | 20053 | 1512 | 31 |
1976775 | 1976775 | 2021-12-03 | Ellsworth | Kansas | 20053 | 1512 | 31 |
1973526 | 1973526 | 2021-12-02 | Ellsworth | Kansas | 20053 | 1499 | 31 |
1970276 | 1970276 | 2021-12-01 | Ellsworth | Kansas | 20053 | 1499 | 31 |
1967026 | 1967026 | 2021-11-30 | Ellsworth | Kansas | 20053 | 1474 | 31 |
1963774 | 1963774 | 2021-11-29 | Ellsworth | Kansas | 20053 | 1474 | 31 |
1960523 | 1960523 | 2021-11-28 | Ellsworth | Kansas | 20053 | 1460 | 31 |
1957272 | 1957272 | 2021-11-27 | Ellsworth | Kansas | 20053 | 1460 | 31 |
1954021 | 1954021 | 2021-11-26 | Ellsworth | Kansas | 20053 | 1460 | 31 |
1950770 | 1950770 | 2021-11-25 | Ellsworth | Kansas | 20053 | 1460 | 31 |
1947519 | 1947519 | 2021-11-24 | Ellsworth | Kansas | 20053 | 1460 | 31 |
1944268 | 1944268 | 2021-11-23 | Ellsworth | Kansas | 20053 | 1458 | 31 |
1941018 | 1941018 | 2021-11-22 | Ellsworth | Kansas | 20053 | 1458 | 31 |
1937768 | 1937768 | 2021-11-21 | Ellsworth | Kansas | 20053 | 1451 | 31 |
1934518 | 1934518 | 2021-11-20 | Ellsworth | Kansas | 20053 | 1451 | 31 |
1931267 | 1931267 | 2021-11-19 | Ellsworth | Kansas | 20053 | 1451 | 31 |
1928016 | 1928016 | 2021-11-18 | Ellsworth | Kansas | 20053 | 1447 | 31 |
1924766 | 1924766 | 2021-11-17 | Ellsworth | Kansas | 20053 | 1447 | 31 |
1921517 | 1921517 | 2021-11-16 | Ellsworth | Kansas | 20053 | 1439 | 31 |
1918267 | 1918267 | 2021-11-15 | Ellsworth | Kansas | 20053 | 1439 | 31 |
1915017 | 1915017 | 2021-11-14 | Ellsworth | Kansas | 20053 | 1432 | 31 |
1911767 | 1911767 | 2021-11-13 | Ellsworth | Kansas | 20053 | 1432 | 31 |
1908518 | 1908518 | 2021-11-12 | Ellsworth | Kansas | 20053 | 1432 | 31 |
1905269 | 1905269 | 2021-11-11 | Ellsworth | Kansas | 20053 | 1427 | 30 |
1902019 | 1902019 | 2021-11-10 | Ellsworth | Kansas | 20053 | 1427 | 30 |
1898769 | 1898769 | 2021-11-09 | Ellsworth | Kansas | 20053 | 1419 | 29 |
1895519 | 1895519 | 2021-11-08 | Ellsworth | Kansas | 20053 | 1419 | 29 |
1892269 | 1892269 | 2021-11-07 | Ellsworth | Kansas | 20053 | 1412 | 29 |
1889019 | 1889019 | 2021-11-06 | Ellsworth | Kansas | 20053 | 1412 | 29 |
1885769 | 1885769 | 2021-11-05 | Ellsworth | Kansas | 20053 | 1412 | 29 |
1882520 | 1882520 | 2021-11-04 | Ellsworth | Kansas | 20053 | 1410 | 29 |
1879271 | 1879271 | 2021-11-03 | Ellsworth | Kansas | 20053 | 1410 | 29 |
1876022 | 1876022 | 2021-11-02 | Ellsworth | Kansas | 20053 | 1403 | 29 |
1872773 | 1872773 | 2021-11-01 | Ellsworth | Kansas | 20053 | 1403 | 29 |
1869524 | 1869524 | 2021-10-31 | Ellsworth | Kansas | 20053 | 1396 | 29 |
1866275 | 1866275 | 2021-10-30 | Ellsworth | Kansas | 20053 | 1396 | 29 |
1863026 | 1863026 | 2021-10-29 | Ellsworth | Kansas | 20053 | 1396 | 29 |
1859777 | 1859777 | 2021-10-28 | Ellsworth | Kansas | 20053 | 1395 | 29 |
1856528 | 1856528 | 2021-10-27 | Ellsworth | Kansas | 20053 | 1395 | 29 |
1853279 | 1853279 | 2021-10-26 | Ellsworth | Kansas | 20053 | 1391 | 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);