ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 20177 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175180 | 2175180 | 2022-02-02 | Shawnee | Kansas | 20177 | 46023 | 526 |
2171927 | 2171927 | 2022-02-01 | Shawnee | Kansas | 20177 | 45505 | 524 |
2168674 | 2168674 | 2022-01-31 | Shawnee | Kansas | 20177 | 45505 | 524 |
2165419 | 2165419 | 2022-01-30 | Shawnee | Kansas | 20177 | 44978 | 522 |
2162164 | 2162164 | 2022-01-29 | Shawnee | Kansas | 20177 | 44978 | 522 |
2158909 | 2158909 | 2022-01-28 | Shawnee | Kansas | 20177 | 44978 | 522 |
2155655 | 2155655 | 2022-01-27 | Shawnee | Kansas | 20177 | 44064 | 508 |
2152402 | 2152402 | 2022-01-26 | Shawnee | Kansas | 20177 | 44064 | 508 |
2149150 | 2149150 | 2022-01-25 | Shawnee | Kansas | 20177 | 43161 | 506 |
2145898 | 2145898 | 2022-01-24 | Shawnee | Kansas | 20177 | 43161 | 506 |
2142643 | 2142643 | 2022-01-23 | Shawnee | Kansas | 20177 | 42041 | 506 |
2139388 | 2139388 | 2022-01-22 | Shawnee | Kansas | 20177 | 42041 | 506 |
2136132 | 2136132 | 2022-01-21 | Shawnee | Kansas | 20177 | 42041 | 506 |
2132880 | 2132880 | 2022-01-20 | Shawnee | Kansas | 20177 | 40558 | 506 |
2129627 | 2129627 | 2022-01-19 | Shawnee | Kansas | 20177 | 40558 | 506 |
2126373 | 2126373 | 2022-01-18 | Shawnee | Kansas | 20177 | 37597 | 494 |
2123121 | 2123121 | 2022-01-17 | Shawnee | Kansas | 20177 | 37597 | 494 |
2119869 | 2119869 | 2022-01-16 | Shawnee | Kansas | 20177 | 37597 | 494 |
2116617 | 2116617 | 2022-01-15 | Shawnee | Kansas | 20177 | 37597 | 494 |
2113366 | 2113366 | 2022-01-14 | Shawnee | Kansas | 20177 | 37597 | 494 |
2110114 | 2110114 | 2022-01-13 | Shawnee | Kansas | 20177 | 36233 | 494 |
2106863 | 2106863 | 2022-01-12 | Shawnee | Kansas | 20177 | 36233 | 494 |
2103612 | 2103612 | 2022-01-11 | Shawnee | Kansas | 20177 | 34988 | 494 |
2100361 | 2100361 | 2022-01-10 | Shawnee | Kansas | 20177 | 34988 | 494 |
2097110 | 2097110 | 2022-01-09 | Shawnee | Kansas | 20177 | 34063 | 494 |
2093858 | 2093858 | 2022-01-08 | Shawnee | Kansas | 20177 | 34063 | 494 |
2090606 | 2090606 | 2022-01-07 | Shawnee | Kansas | 20177 | 34063 | 494 |
2087355 | 2087355 | 2022-01-06 | Shawnee | Kansas | 20177 | 33002 | 492 |
2084103 | 2084103 | 2022-01-05 | Shawnee | Kansas | 20177 | 33002 | 492 |
2080851 | 2080851 | 2022-01-04 | Shawnee | Kansas | 20177 | 32163 | 492 |
2077599 | 2077599 | 2022-01-03 | Shawnee | Kansas | 20177 | 32163 | 492 |
2074348 | 2074348 | 2022-01-02 | Shawnee | Kansas | 20177 | 31041 | 491 |
2071097 | 2071097 | 2022-01-01 | Shawnee | Kansas | 20177 | 31041 | 491 |
2067846 | 2067846 | 2021-12-31 | Shawnee | Kansas | 20177 | 31041 | 491 |
2064595 | 2064595 | 2021-12-30 | Shawnee | Kansas | 20177 | 31041 | 491 |
2061345 | 2061345 | 2021-12-29 | Shawnee | Kansas | 20177 | 31041 | 491 |
2058096 | 2058096 | 2021-12-28 | Shawnee | Kansas | 20177 | 30555 | 488 |
2054847 | 2054847 | 2021-12-27 | Shawnee | Kansas | 20177 | 30555 | 488 |
2051597 | 2051597 | 2021-12-26 | Shawnee | Kansas | 20177 | 30083 | 488 |
2048347 | 2048347 | 2021-12-25 | Shawnee | Kansas | 20177 | 30083 | 488 |
2045097 | 2045097 | 2021-12-24 | Shawnee | Kansas | 20177 | 30083 | 488 |
2041848 | 2041848 | 2021-12-23 | Shawnee | Kansas | 20177 | 30083 | 488 |
2038598 | 2038598 | 2021-12-22 | Shawnee | Kansas | 20177 | 30083 | 488 |
2035348 | 2035348 | 2021-12-21 | Shawnee | Kansas | 20177 | 29755 | 487 |
2032098 | 2032098 | 2021-12-20 | Shawnee | Kansas | 20177 | 29755 | 487 |
2028847 | 2028847 | 2021-12-19 | Shawnee | Kansas | 20177 | 29524 | 487 |
2025596 | 2025596 | 2021-12-18 | Shawnee | Kansas | 20177 | 29524 | 487 |
2022345 | 2022345 | 2021-12-17 | Shawnee | Kansas | 20177 | 29524 | 487 |
2019094 | 2019094 | 2021-12-16 | Shawnee | Kansas | 20177 | 29217 | 487 |
2015844 | 2015844 | 2021-12-15 | Shawnee | Kansas | 20177 | 29217 | 487 |
2012593 | 2012593 | 2021-12-14 | Shawnee | Kansas | 20177 | 28969 | 486 |
2009342 | 2009342 | 2021-12-13 | Shawnee | Kansas | 20177 | 28969 | 486 |
2006091 | 2006091 | 2021-12-12 | Shawnee | Kansas | 20177 | 28694 | 485 |
2002840 | 2002840 | 2021-12-11 | Shawnee | Kansas | 20177 | 28694 | 485 |
1999590 | 1999590 | 2021-12-10 | Shawnee | Kansas | 20177 | 28694 | 485 |
1996339 | 1996339 | 2021-12-09 | Shawnee | Kansas | 20177 | 28427 | 482 |
1993088 | 1993088 | 2021-12-08 | Shawnee | Kansas | 20177 | 28427 | 482 |
1989837 | 1989837 | 2021-12-07 | Shawnee | Kansas | 20177 | 28102 | 481 |
1986587 | 1986587 | 2021-12-06 | Shawnee | Kansas | 20177 | 28102 | 481 |
1983337 | 1983337 | 2021-12-05 | Shawnee | Kansas | 20177 | 27851 | 480 |
1980087 | 1980087 | 2021-12-04 | Shawnee | Kansas | 20177 | 27851 | 480 |
1976837 | 1976837 | 2021-12-03 | Shawnee | Kansas | 20177 | 27851 | 480 |
1973588 | 1973588 | 2021-12-02 | Shawnee | Kansas | 20177 | 27574 | 478 |
1970338 | 1970338 | 2021-12-01 | Shawnee | Kansas | 20177 | 27574 | 478 |
1967088 | 1967088 | 2021-11-30 | Shawnee | Kansas | 20177 | 27318 | 476 |
1963836 | 1963836 | 2021-11-29 | Shawnee | Kansas | 20177 | 27318 | 476 |
1960585 | 1960585 | 2021-11-28 | Shawnee | Kansas | 20177 | 27061 | 476 |
1957334 | 1957334 | 2021-11-27 | Shawnee | Kansas | 20177 | 27061 | 476 |
1954083 | 1954083 | 2021-11-26 | Shawnee | Kansas | 20177 | 27061 | 476 |
1950832 | 1950832 | 2021-11-25 | Shawnee | Kansas | 20177 | 27061 | 476 |
1947581 | 1947581 | 2021-11-24 | Shawnee | Kansas | 20177 | 27061 | 476 |
1944330 | 1944330 | 2021-11-23 | Shawnee | Kansas | 20177 | 26885 | 473 |
1941080 | 1941080 | 2021-11-22 | Shawnee | Kansas | 20177 | 26885 | 473 |
1937830 | 1937830 | 2021-11-21 | Shawnee | Kansas | 20177 | 26716 | 473 |
1934580 | 1934580 | 2021-11-20 | Shawnee | Kansas | 20177 | 26716 | 473 |
1931329 | 1931329 | 2021-11-19 | Shawnee | Kansas | 20177 | 26716 | 473 |
1928078 | 1928078 | 2021-11-18 | Shawnee | Kansas | 20177 | 26588 | 473 |
1924828 | 1924828 | 2021-11-17 | Shawnee | Kansas | 20177 | 26588 | 473 |
1921579 | 1921579 | 2021-11-16 | Shawnee | Kansas | 20177 | 26439 | 473 |
1918329 | 1918329 | 2021-11-15 | Shawnee | Kansas | 20177 | 26439 | 473 |
1915079 | 1915079 | 2021-11-14 | Shawnee | Kansas | 20177 | 26305 | 473 |
1911829 | 1911829 | 2021-11-13 | Shawnee | Kansas | 20177 | 26305 | 473 |
1908580 | 1908580 | 2021-11-12 | Shawnee | Kansas | 20177 | 26305 | 473 |
1905331 | 1905331 | 2021-11-11 | Shawnee | Kansas | 20177 | 26177 | 472 |
1902081 | 1902081 | 2021-11-10 | Shawnee | Kansas | 20177 | 26177 | 472 |
1898831 | 1898831 | 2021-11-09 | Shawnee | Kansas | 20177 | 26058 | 472 |
1895581 | 1895581 | 2021-11-08 | Shawnee | Kansas | 20177 | 26058 | 472 |
1892331 | 1892331 | 2021-11-07 | Shawnee | Kansas | 20177 | 25961 | 472 |
1889081 | 1889081 | 2021-11-06 | Shawnee | Kansas | 20177 | 25961 | 472 |
1885831 | 1885831 | 2021-11-05 | Shawnee | Kansas | 20177 | 25961 | 472 |
1882582 | 1882582 | 2021-11-04 | Shawnee | Kansas | 20177 | 25853 | 469 |
1879333 | 1879333 | 2021-11-03 | Shawnee | Kansas | 20177 | 25853 | 469 |
1876084 | 1876084 | 2021-11-02 | Shawnee | Kansas | 20177 | 25750 | 466 |
1872835 | 1872835 | 2021-11-01 | Shawnee | Kansas | 20177 | 25750 | 466 |
1869586 | 1869586 | 2021-10-31 | Shawnee | Kansas | 20177 | 25698 | 466 |
1866337 | 1866337 | 2021-10-30 | Shawnee | Kansas | 20177 | 25698 | 466 |
1863088 | 1863088 | 2021-10-29 | Shawnee | Kansas | 20177 | 25698 | 466 |
1859839 | 1859839 | 2021-10-28 | Shawnee | Kansas | 20177 | 25605 | 456 |
1856590 | 1856590 | 2021-10-27 | Shawnee | Kansas | 20177 | 25605 | 456 |
1853341 | 1853341 | 2021-10-26 | Shawnee | Kansas | 20177 | 25505 | 449 |
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);