ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 20063 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175123 | 2175123 | 2022-02-02 | Gove | Kansas | 20063 | 758 | 23 |
2171870 | 2171870 | 2022-02-01 | Gove | Kansas | 20063 | 749 | 23 |
2168617 | 2168617 | 2022-01-31 | Gove | Kansas | 20063 | 749 | 23 |
2165362 | 2165362 | 2022-01-30 | Gove | Kansas | 20063 | 747 | 23 |
2162107 | 2162107 | 2022-01-29 | Gove | Kansas | 20063 | 747 | 23 |
2158852 | 2158852 | 2022-01-28 | Gove | Kansas | 20063 | 747 | 23 |
2155598 | 2155598 | 2022-01-27 | Gove | Kansas | 20063 | 732 | 23 |
2152345 | 2152345 | 2022-01-26 | Gove | Kansas | 20063 | 732 | 23 |
2149093 | 2149093 | 2022-01-25 | Gove | Kansas | 20063 | 722 | 23 |
2145841 | 2145841 | 2022-01-24 | Gove | Kansas | 20063 | 722 | 23 |
2142586 | 2142586 | 2022-01-23 | Gove | Kansas | 20063 | 717 | 23 |
2139331 | 2139331 | 2022-01-22 | Gove | Kansas | 20063 | 717 | 23 |
2136075 | 2136075 | 2022-01-21 | Gove | Kansas | 20063 | 717 | 23 |
2132823 | 2132823 | 2022-01-20 | Gove | Kansas | 20063 | 698 | 23 |
2129570 | 2129570 | 2022-01-19 | Gove | Kansas | 20063 | 698 | 23 |
2126316 | 2126316 | 2022-01-18 | Gove | Kansas | 20063 | 664 | 23 |
2123064 | 2123064 | 2022-01-17 | Gove | Kansas | 20063 | 664 | 23 |
2119812 | 2119812 | 2022-01-16 | Gove | Kansas | 20063 | 664 | 23 |
2116560 | 2116560 | 2022-01-15 | Gove | Kansas | 20063 | 664 | 23 |
2113309 | 2113309 | 2022-01-14 | Gove | Kansas | 20063 | 664 | 23 |
2110057 | 2110057 | 2022-01-13 | Gove | Kansas | 20063 | 655 | 23 |
2106806 | 2106806 | 2022-01-12 | Gove | Kansas | 20063 | 655 | 23 |
2103555 | 2103555 | 2022-01-11 | Gove | Kansas | 20063 | 644 | 23 |
2100304 | 2100304 | 2022-01-10 | Gove | Kansas | 20063 | 644 | 23 |
2097053 | 2097053 | 2022-01-09 | Gove | Kansas | 20063 | 642 | 23 |
2093801 | 2093801 | 2022-01-08 | Gove | Kansas | 20063 | 642 | 23 |
2090549 | 2090549 | 2022-01-07 | Gove | Kansas | 20063 | 642 | 23 |
2087298 | 2087298 | 2022-01-06 | Gove | Kansas | 20063 | 640 | 23 |
2084046 | 2084046 | 2022-01-05 | Gove | Kansas | 20063 | 640 | 23 |
2080794 | 2080794 | 2022-01-04 | Gove | Kansas | 20063 | 635 | 23 |
2077542 | 2077542 | 2022-01-03 | Gove | Kansas | 20063 | 635 | 23 |
2074291 | 2074291 | 2022-01-02 | Gove | Kansas | 20063 | 625 | 23 |
2071040 | 2071040 | 2022-01-01 | Gove | Kansas | 20063 | 625 | 23 |
2067789 | 2067789 | 2021-12-31 | Gove | Kansas | 20063 | 625 | 23 |
2064538 | 2064538 | 2021-12-30 | Gove | Kansas | 20063 | 625 | 23 |
2061288 | 2061288 | 2021-12-29 | Gove | Kansas | 20063 | 625 | 23 |
2058039 | 2058039 | 2021-12-28 | Gove | Kansas | 20063 | 622 | 23 |
2054790 | 2054790 | 2021-12-27 | Gove | Kansas | 20063 | 622 | 23 |
2051540 | 2051540 | 2021-12-26 | Gove | Kansas | 20063 | 616 | 23 |
2048290 | 2048290 | 2021-12-25 | Gove | Kansas | 20063 | 616 | 23 |
2045040 | 2045040 | 2021-12-24 | Gove | Kansas | 20063 | 616 | 23 |
2041791 | 2041791 | 2021-12-23 | Gove | Kansas | 20063 | 616 | 23 |
2038541 | 2038541 | 2021-12-22 | Gove | Kansas | 20063 | 616 | 23 |
2035291 | 2035291 | 2021-12-21 | Gove | Kansas | 20063 | 613 | 23 |
2032041 | 2032041 | 2021-12-20 | Gove | Kansas | 20063 | 613 | 23 |
2028790 | 2028790 | 2021-12-19 | Gove | Kansas | 20063 | 611 | 23 |
2025539 | 2025539 | 2021-12-18 | Gove | Kansas | 20063 | 611 | 23 |
2022288 | 2022288 | 2021-12-17 | Gove | Kansas | 20063 | 611 | 23 |
2019037 | 2019037 | 2021-12-16 | Gove | Kansas | 20063 | 602 | 23 |
2015787 | 2015787 | 2021-12-15 | Gove | Kansas | 20063 | 602 | 23 |
2012536 | 2012536 | 2021-12-14 | Gove | Kansas | 20063 | 595 | 23 |
2009285 | 2009285 | 2021-12-13 | Gove | Kansas | 20063 | 595 | 23 |
2006034 | 2006034 | 2021-12-12 | Gove | Kansas | 20063 | 594 | 22 |
2002783 | 2002783 | 2021-12-11 | Gove | Kansas | 20063 | 594 | 22 |
1999533 | 1999533 | 2021-12-10 | Gove | Kansas | 20063 | 594 | 22 |
1996282 | 1996282 | 2021-12-09 | Gove | Kansas | 20063 | 585 | 22 |
1993031 | 1993031 | 2021-12-08 | Gove | Kansas | 20063 | 585 | 22 |
1989780 | 1989780 | 2021-12-07 | Gove | Kansas | 20063 | 580 | 22 |
1986530 | 1986530 | 2021-12-06 | Gove | Kansas | 20063 | 580 | 22 |
1983280 | 1983280 | 2021-12-05 | Gove | Kansas | 20063 | 574 | 22 |
1980030 | 1980030 | 2021-12-04 | Gove | Kansas | 20063 | 574 | 22 |
1976780 | 1976780 | 2021-12-03 | Gove | Kansas | 20063 | 574 | 22 |
1973531 | 1973531 | 2021-12-02 | Gove | Kansas | 20063 | 562 | 22 |
1970281 | 1970281 | 2021-12-01 | Gove | Kansas | 20063 | 562 | 22 |
1967031 | 1967031 | 2021-11-30 | Gove | Kansas | 20063 | 553 | 22 |
1963779 | 1963779 | 2021-11-29 | Gove | Kansas | 20063 | 553 | 22 |
1960528 | 1960528 | 2021-11-28 | Gove | Kansas | 20063 | 548 | 22 |
1957277 | 1957277 | 2021-11-27 | Gove | Kansas | 20063 | 548 | 22 |
1954026 | 1954026 | 2021-11-26 | Gove | Kansas | 20063 | 548 | 22 |
1950775 | 1950775 | 2021-11-25 | Gove | Kansas | 20063 | 548 | 22 |
1947524 | 1947524 | 2021-11-24 | Gove | Kansas | 20063 | 548 | 22 |
1944273 | 1944273 | 2021-11-23 | Gove | Kansas | 20063 | 539 | 22 |
1941023 | 1941023 | 2021-11-22 | Gove | Kansas | 20063 | 539 | 22 |
1937773 | 1937773 | 2021-11-21 | Gove | Kansas | 20063 | 526 | 22 |
1934523 | 1934523 | 2021-11-20 | Gove | Kansas | 20063 | 526 | 22 |
1931272 | 1931272 | 2021-11-19 | Gove | Kansas | 20063 | 526 | 22 |
1928021 | 1928021 | 2021-11-18 | Gove | Kansas | 20063 | 511 | 22 |
1924771 | 1924771 | 2021-11-17 | Gove | Kansas | 20063 | 511 | 22 |
1921522 | 1921522 | 2021-11-16 | Gove | Kansas | 20063 | 507 | 22 |
1918272 | 1918272 | 2021-11-15 | Gove | Kansas | 20063 | 507 | 22 |
1915022 | 1915022 | 2021-11-14 | Gove | Kansas | 20063 | 504 | 22 |
1911772 | 1911772 | 2021-11-13 | Gove | Kansas | 20063 | 504 | 22 |
1908523 | 1908523 | 2021-11-12 | Gove | Kansas | 20063 | 504 | 22 |
1905274 | 1905274 | 2021-11-11 | Gove | Kansas | 20063 | 498 | 22 |
1902024 | 1902024 | 2021-11-10 | Gove | Kansas | 20063 | 498 | 22 |
1898774 | 1898774 | 2021-11-09 | Gove | Kansas | 20063 | 491 | 22 |
1895524 | 1895524 | 2021-11-08 | Gove | Kansas | 20063 | 491 | 22 |
1892274 | 1892274 | 2021-11-07 | Gove | Kansas | 20063 | 488 | 22 |
1889024 | 1889024 | 2021-11-06 | Gove | Kansas | 20063 | 488 | 22 |
1885774 | 1885774 | 2021-11-05 | Gove | Kansas | 20063 | 488 | 22 |
1882525 | 1882525 | 2021-11-04 | Gove | Kansas | 20063 | 482 | 22 |
1879276 | 1879276 | 2021-11-03 | Gove | Kansas | 20063 | 482 | 22 |
1876027 | 1876027 | 2021-11-02 | Gove | Kansas | 20063 | 477 | 22 |
1872778 | 1872778 | 2021-11-01 | Gove | Kansas | 20063 | 477 | 22 |
1869529 | 1869529 | 2021-10-31 | Gove | Kansas | 20063 | 477 | 22 |
1866280 | 1866280 | 2021-10-30 | Gove | Kansas | 20063 | 477 | 22 |
1863031 | 1863031 | 2021-10-29 | Gove | Kansas | 20063 | 477 | 22 |
1859782 | 1859782 | 2021-10-28 | Gove | Kansas | 20063 | 474 | 22 |
1856533 | 1856533 | 2021-10-27 | Gove | Kansas | 20063 | 474 | 22 |
1853284 | 1853284 | 2021-10-26 | Gove | Kansas | 20063 | 472 | 22 |
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);