ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
754 rows where fips = 20081 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175132 | 2175132 | 2022-02-02 | Haskell | Kansas | 20081 | 941 | 11 |
2171879 | 2171879 | 2022-02-01 | Haskell | Kansas | 20081 | 932 | 11 |
2168626 | 2168626 | 2022-01-31 | Haskell | Kansas | 20081 | 932 | 11 |
2165371 | 2165371 | 2022-01-30 | Haskell | Kansas | 20081 | 920 | 11 |
2162116 | 2162116 | 2022-01-29 | Haskell | Kansas | 20081 | 920 | 11 |
2158861 | 2158861 | 2022-01-28 | Haskell | Kansas | 20081 | 920 | 11 |
2155607 | 2155607 | 2022-01-27 | Haskell | Kansas | 20081 | 905 | 10 |
2152354 | 2152354 | 2022-01-26 | Haskell | Kansas | 20081 | 905 | 10 |
2149102 | 2149102 | 2022-01-25 | Haskell | Kansas | 20081 | 882 | 10 |
2145850 | 2145850 | 2022-01-24 | Haskell | Kansas | 20081 | 882 | 10 |
2142595 | 2142595 | 2022-01-23 | Haskell | Kansas | 20081 | 868 | 10 |
2139340 | 2139340 | 2022-01-22 | Haskell | Kansas | 20081 | 868 | 10 |
2136084 | 2136084 | 2022-01-21 | Haskell | Kansas | 20081 | 868 | 10 |
2132832 | 2132832 | 2022-01-20 | Haskell | Kansas | 20081 | 853 | 10 |
2129579 | 2129579 | 2022-01-19 | Haskell | Kansas | 20081 | 853 | 10 |
2126325 | 2126325 | 2022-01-18 | Haskell | Kansas | 20081 | 796 | 9 |
2123073 | 2123073 | 2022-01-17 | Haskell | Kansas | 20081 | 796 | 9 |
2119821 | 2119821 | 2022-01-16 | Haskell | Kansas | 20081 | 796 | 9 |
2116569 | 2116569 | 2022-01-15 | Haskell | Kansas | 20081 | 796 | 9 |
2113318 | 2113318 | 2022-01-14 | Haskell | Kansas | 20081 | 796 | 9 |
2110066 | 2110066 | 2022-01-13 | Haskell | Kansas | 20081 | 786 | 9 |
2106815 | 2106815 | 2022-01-12 | Haskell | Kansas | 20081 | 786 | 9 |
2103564 | 2103564 | 2022-01-11 | Haskell | Kansas | 20081 | 761 | 9 |
2100313 | 2100313 | 2022-01-10 | Haskell | Kansas | 20081 | 761 | 9 |
2097062 | 2097062 | 2022-01-09 | Haskell | Kansas | 20081 | 755 | 9 |
2093810 | 2093810 | 2022-01-08 | Haskell | Kansas | 20081 | 755 | 9 |
2090558 | 2090558 | 2022-01-07 | Haskell | Kansas | 20081 | 755 | 9 |
2087307 | 2087307 | 2022-01-06 | Haskell | Kansas | 20081 | 741 | 9 |
2084055 | 2084055 | 2022-01-05 | Haskell | Kansas | 20081 | 741 | 9 |
2080803 | 2080803 | 2022-01-04 | Haskell | Kansas | 20081 | 723 | 9 |
2077551 | 2077551 | 2022-01-03 | Haskell | Kansas | 20081 | 723 | 9 |
2074300 | 2074300 | 2022-01-02 | Haskell | Kansas | 20081 | 715 | 9 |
2071049 | 2071049 | 2022-01-01 | Haskell | Kansas | 20081 | 715 | 9 |
2067798 | 2067798 | 2021-12-31 | Haskell | Kansas | 20081 | 715 | 9 |
2064547 | 2064547 | 2021-12-30 | Haskell | Kansas | 20081 | 715 | 9 |
2061297 | 2061297 | 2021-12-29 | Haskell | Kansas | 20081 | 715 | 9 |
2058048 | 2058048 | 2021-12-28 | Haskell | Kansas | 20081 | 713 | 9 |
2054799 | 2054799 | 2021-12-27 | Haskell | Kansas | 20081 | 713 | 9 |
2051549 | 2051549 | 2021-12-26 | Haskell | Kansas | 20081 | 709 | 9 |
2048299 | 2048299 | 2021-12-25 | Haskell | Kansas | 20081 | 709 | 9 |
2045049 | 2045049 | 2021-12-24 | Haskell | Kansas | 20081 | 709 | 9 |
2041800 | 2041800 | 2021-12-23 | Haskell | Kansas | 20081 | 709 | 9 |
2038550 | 2038550 | 2021-12-22 | Haskell | Kansas | 20081 | 709 | 9 |
2035300 | 2035300 | 2021-12-21 | Haskell | Kansas | 20081 | 703 | 9 |
2032050 | 2032050 | 2021-12-20 | Haskell | Kansas | 20081 | 703 | 9 |
2028799 | 2028799 | 2021-12-19 | Haskell | Kansas | 20081 | 701 | 9 |
2025548 | 2025548 | 2021-12-18 | Haskell | Kansas | 20081 | 701 | 9 |
2022297 | 2022297 | 2021-12-17 | Haskell | Kansas | 20081 | 701 | 9 |
2019046 | 2019046 | 2021-12-16 | Haskell | Kansas | 20081 | 700 | 9 |
2015796 | 2015796 | 2021-12-15 | Haskell | Kansas | 20081 | 700 | 9 |
2012545 | 2012545 | 2021-12-14 | Haskell | Kansas | 20081 | 693 | 9 |
2009294 | 2009294 | 2021-12-13 | Haskell | Kansas | 20081 | 693 | 9 |
2006043 | 2006043 | 2021-12-12 | Haskell | Kansas | 20081 | 689 | 9 |
2002792 | 2002792 | 2021-12-11 | Haskell | Kansas | 20081 | 689 | 9 |
1999542 | 1999542 | 2021-12-10 | Haskell | Kansas | 20081 | 689 | 9 |
1996291 | 1996291 | 2021-12-09 | Haskell | Kansas | 20081 | 682 | 9 |
1993040 | 1993040 | 2021-12-08 | Haskell | Kansas | 20081 | 682 | 9 |
1989789 | 1989789 | 2021-12-07 | Haskell | Kansas | 20081 | 675 | 9 |
1986539 | 1986539 | 2021-12-06 | Haskell | Kansas | 20081 | 675 | 9 |
1983289 | 1983289 | 2021-12-05 | Haskell | Kansas | 20081 | 671 | 9 |
1980039 | 1980039 | 2021-12-04 | Haskell | Kansas | 20081 | 671 | 9 |
1976789 | 1976789 | 2021-12-03 | Haskell | Kansas | 20081 | 671 | 9 |
1973540 | 1973540 | 2021-12-02 | Haskell | Kansas | 20081 | 658 | 9 |
1970290 | 1970290 | 2021-12-01 | Haskell | Kansas | 20081 | 658 | 9 |
1967040 | 1967040 | 2021-11-30 | Haskell | Kansas | 20081 | 636 | 9 |
1963788 | 1963788 | 2021-11-29 | Haskell | Kansas | 20081 | 636 | 9 |
1960537 | 1960537 | 2021-11-28 | Haskell | Kansas | 20081 | 628 | 9 |
1957286 | 1957286 | 2021-11-27 | Haskell | Kansas | 20081 | 628 | 9 |
1954035 | 1954035 | 2021-11-26 | Haskell | Kansas | 20081 | 628 | 9 |
1950784 | 1950784 | 2021-11-25 | Haskell | Kansas | 20081 | 628 | 9 |
1947533 | 1947533 | 2021-11-24 | Haskell | Kansas | 20081 | 628 | 9 |
1944282 | 1944282 | 2021-11-23 | Haskell | Kansas | 20081 | 621 | 9 |
1941032 | 1941032 | 2021-11-22 | Haskell | Kansas | 20081 | 621 | 9 |
1937782 | 1937782 | 2021-11-21 | Haskell | Kansas | 20081 | 619 | 9 |
1934532 | 1934532 | 2021-11-20 | Haskell | Kansas | 20081 | 619 | 9 |
1931281 | 1931281 | 2021-11-19 | Haskell | Kansas | 20081 | 619 | 9 |
1928030 | 1928030 | 2021-11-18 | Haskell | Kansas | 20081 | 611 | 9 |
1924780 | 1924780 | 2021-11-17 | Haskell | Kansas | 20081 | 611 | 9 |
1921531 | 1921531 | 2021-11-16 | Haskell | Kansas | 20081 | 600 | 9 |
1918281 | 1918281 | 2021-11-15 | Haskell | Kansas | 20081 | 600 | 9 |
1915031 | 1915031 | 2021-11-14 | Haskell | Kansas | 20081 | 600 | 9 |
1911781 | 1911781 | 2021-11-13 | Haskell | Kansas | 20081 | 600 | 9 |
1908532 | 1908532 | 2021-11-12 | Haskell | Kansas | 20081 | 600 | 9 |
1905283 | 1905283 | 2021-11-11 | Haskell | Kansas | 20081 | 591 | 9 |
1902033 | 1902033 | 2021-11-10 | Haskell | Kansas | 20081 | 591 | 9 |
1898783 | 1898783 | 2021-11-09 | Haskell | Kansas | 20081 | 588 | 9 |
1895533 | 1895533 | 2021-11-08 | Haskell | Kansas | 20081 | 588 | 9 |
1892283 | 1892283 | 2021-11-07 | Haskell | Kansas | 20081 | 586 | 9 |
1889033 | 1889033 | 2021-11-06 | Haskell | Kansas | 20081 | 586 | 9 |
1885783 | 1885783 | 2021-11-05 | Haskell | Kansas | 20081 | 586 | 9 |
1882534 | 1882534 | 2021-11-04 | Haskell | Kansas | 20081 | 581 | 9 |
1879285 | 1879285 | 2021-11-03 | Haskell | Kansas | 20081 | 581 | 9 |
1876036 | 1876036 | 2021-11-02 | Haskell | Kansas | 20081 | 575 | 8 |
1872787 | 1872787 | 2021-11-01 | Haskell | Kansas | 20081 | 575 | 8 |
1869538 | 1869538 | 2021-10-31 | Haskell | Kansas | 20081 | 572 | 8 |
1866289 | 1866289 | 2021-10-30 | Haskell | Kansas | 20081 | 572 | 8 |
1863040 | 1863040 | 2021-10-29 | Haskell | Kansas | 20081 | 572 | 8 |
1859791 | 1859791 | 2021-10-28 | Haskell | Kansas | 20081 | 564 | 8 |
1856542 | 1856542 | 2021-10-27 | Haskell | Kansas | 20081 | 564 | 8 |
1853293 | 1853293 | 2021-10-26 | Haskell | Kansas | 20081 | 556 | 8 |
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);