ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 20021 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175102 | 2175102 | 2022-02-02 | Cherokee | Kansas | 20021 | 5822 | 82 |
2171849 | 2171849 | 2022-02-01 | Cherokee | Kansas | 20021 | 5686 | 82 |
2168596 | 2168596 | 2022-01-31 | Cherokee | Kansas | 20021 | 5686 | 82 |
2165341 | 2165341 | 2022-01-30 | Cherokee | Kansas | 20021 | 5622 | 82 |
2162086 | 2162086 | 2022-01-29 | Cherokee | Kansas | 20021 | 5622 | 82 |
2158831 | 2158831 | 2022-01-28 | Cherokee | Kansas | 20021 | 5622 | 82 |
2155577 | 2155577 | 2022-01-27 | Cherokee | Kansas | 20021 | 5480 | 81 |
2152324 | 2152324 | 2022-01-26 | Cherokee | Kansas | 20021 | 5480 | 81 |
2149072 | 2149072 | 2022-01-25 | Cherokee | Kansas | 20021 | 5347 | 81 |
2145820 | 2145820 | 2022-01-24 | Cherokee | Kansas | 20021 | 5347 | 81 |
2142565 | 2142565 | 2022-01-23 | Cherokee | Kansas | 20021 | 5214 | 81 |
2139310 | 2139310 | 2022-01-22 | Cherokee | Kansas | 20021 | 5214 | 81 |
2136054 | 2136054 | 2022-01-21 | Cherokee | Kansas | 20021 | 5214 | 81 |
2132802 | 2132802 | 2022-01-20 | Cherokee | Kansas | 20021 | 5054 | 80 |
2129549 | 2129549 | 2022-01-19 | Cherokee | Kansas | 20021 | 5054 | 80 |
2126295 | 2126295 | 2022-01-18 | Cherokee | Kansas | 20021 | 4690 | 80 |
2123043 | 2123043 | 2022-01-17 | Cherokee | Kansas | 20021 | 4690 | 80 |
2119791 | 2119791 | 2022-01-16 | Cherokee | Kansas | 20021 | 4690 | 80 |
2116539 | 2116539 | 2022-01-15 | Cherokee | Kansas | 20021 | 4690 | 80 |
2113288 | 2113288 | 2022-01-14 | Cherokee | Kansas | 20021 | 4690 | 80 |
2110036 | 2110036 | 2022-01-13 | Cherokee | Kansas | 20021 | 4523 | 80 |
2106785 | 2106785 | 2022-01-12 | Cherokee | Kansas | 20021 | 4523 | 80 |
2103534 | 2103534 | 2022-01-11 | Cherokee | Kansas | 20021 | 4326 | 79 |
2100283 | 2100283 | 2022-01-10 | Cherokee | Kansas | 20021 | 4326 | 79 |
2097032 | 2097032 | 2022-01-09 | Cherokee | Kansas | 20021 | 4271 | 79 |
2093780 | 2093780 | 2022-01-08 | Cherokee | Kansas | 20021 | 4271 | 79 |
2090528 | 2090528 | 2022-01-07 | Cherokee | Kansas | 20021 | 4271 | 79 |
2087277 | 2087277 | 2022-01-06 | Cherokee | Kansas | 20021 | 4200 | 79 |
2084025 | 2084025 | 2022-01-05 | Cherokee | Kansas | 20021 | 4200 | 79 |
2080773 | 2080773 | 2022-01-04 | Cherokee | Kansas | 20021 | 4134 | 78 |
2077521 | 2077521 | 2022-01-03 | Cherokee | Kansas | 20021 | 4134 | 78 |
2074270 | 2074270 | 2022-01-02 | Cherokee | Kansas | 20021 | 4076 | 78 |
2071019 | 2071019 | 2022-01-01 | Cherokee | Kansas | 20021 | 4076 | 78 |
2067768 | 2067768 | 2021-12-31 | Cherokee | Kansas | 20021 | 4076 | 78 |
2064517 | 2064517 | 2021-12-30 | Cherokee | Kansas | 20021 | 4076 | 78 |
2061267 | 2061267 | 2021-12-29 | Cherokee | Kansas | 20021 | 4076 | 78 |
2058018 | 2058018 | 2021-12-28 | Cherokee | Kansas | 20021 | 4039 | 78 |
2054769 | 2054769 | 2021-12-27 | Cherokee | Kansas | 20021 | 4039 | 78 |
2051519 | 2051519 | 2021-12-26 | Cherokee | Kansas | 20021 | 4001 | 78 |
2048269 | 2048269 | 2021-12-25 | Cherokee | Kansas | 20021 | 4001 | 78 |
2045019 | 2045019 | 2021-12-24 | Cherokee | Kansas | 20021 | 4001 | 78 |
2041770 | 2041770 | 2021-12-23 | Cherokee | Kansas | 20021 | 4001 | 78 |
2038520 | 2038520 | 2021-12-22 | Cherokee | Kansas | 20021 | 4001 | 78 |
2035270 | 2035270 | 2021-12-21 | Cherokee | Kansas | 20021 | 3983 | 78 |
2032020 | 2032020 | 2021-12-20 | Cherokee | Kansas | 20021 | 3983 | 78 |
2028769 | 2028769 | 2021-12-19 | Cherokee | Kansas | 20021 | 3970 | 78 |
2025518 | 2025518 | 2021-12-18 | Cherokee | Kansas | 20021 | 3970 | 78 |
2022267 | 2022267 | 2021-12-17 | Cherokee | Kansas | 20021 | 3970 | 78 |
2019016 | 2019016 | 2021-12-16 | Cherokee | Kansas | 20021 | 3948 | 78 |
2015766 | 2015766 | 2021-12-15 | Cherokee | Kansas | 20021 | 3948 | 78 |
2012515 | 2012515 | 2021-12-14 | Cherokee | Kansas | 20021 | 3932 | 78 |
2009264 | 2009264 | 2021-12-13 | Cherokee | Kansas | 20021 | 3932 | 78 |
2006013 | 2006013 | 2021-12-12 | Cherokee | Kansas | 20021 | 3912 | 78 |
2002762 | 2002762 | 2021-12-11 | Cherokee | Kansas | 20021 | 3912 | 78 |
1999512 | 1999512 | 2021-12-10 | Cherokee | Kansas | 20021 | 3912 | 78 |
1996261 | 1996261 | 2021-12-09 | Cherokee | Kansas | 20021 | 3892 | 78 |
1993010 | 1993010 | 2021-12-08 | Cherokee | Kansas | 20021 | 3892 | 78 |
1989759 | 1989759 | 2021-12-07 | Cherokee | Kansas | 20021 | 3858 | 78 |
1986509 | 1986509 | 2021-12-06 | Cherokee | Kansas | 20021 | 3858 | 78 |
1983259 | 1983259 | 2021-12-05 | Cherokee | Kansas | 20021 | 3850 | 78 |
1980009 | 1980009 | 2021-12-04 | Cherokee | Kansas | 20021 | 3850 | 78 |
1976759 | 1976759 | 2021-12-03 | Cherokee | Kansas | 20021 | 3850 | 78 |
1973510 | 1973510 | 2021-12-02 | Cherokee | Kansas | 20021 | 3837 | 78 |
1970260 | 1970260 | 2021-12-01 | Cherokee | Kansas | 20021 | 3837 | 78 |
1967010 | 1967010 | 2021-11-30 | Cherokee | Kansas | 20021 | 3816 | 78 |
1963758 | 1963758 | 2021-11-29 | Cherokee | Kansas | 20021 | 3816 | 78 |
1960507 | 1960507 | 2021-11-28 | Cherokee | Kansas | 20021 | 3800 | 78 |
1957256 | 1957256 | 2021-11-27 | Cherokee | Kansas | 20021 | 3800 | 78 |
1954005 | 1954005 | 2021-11-26 | Cherokee | Kansas | 20021 | 3800 | 78 |
1950754 | 1950754 | 2021-11-25 | Cherokee | Kansas | 20021 | 3800 | 78 |
1947503 | 1947503 | 2021-11-24 | Cherokee | Kansas | 20021 | 3800 | 78 |
1944252 | 1944252 | 2021-11-23 | Cherokee | Kansas | 20021 | 3796 | 78 |
1941002 | 1941002 | 2021-11-22 | Cherokee | Kansas | 20021 | 3796 | 78 |
1937752 | 1937752 | 2021-11-21 | Cherokee | Kansas | 20021 | 3780 | 78 |
1934502 | 1934502 | 2021-11-20 | Cherokee | Kansas | 20021 | 3780 | 78 |
1931251 | 1931251 | 2021-11-19 | Cherokee | Kansas | 20021 | 3780 | 78 |
1928000 | 1928000 | 2021-11-18 | Cherokee | Kansas | 20021 | 3762 | 78 |
1924750 | 1924750 | 2021-11-17 | Cherokee | Kansas | 20021 | 3762 | 78 |
1921501 | 1921501 | 2021-11-16 | Cherokee | Kansas | 20021 | 3740 | 78 |
1918251 | 1918251 | 2021-11-15 | Cherokee | Kansas | 20021 | 3740 | 78 |
1915001 | 1915001 | 2021-11-14 | Cherokee | Kansas | 20021 | 3736 | 79 |
1911751 | 1911751 | 2021-11-13 | Cherokee | Kansas | 20021 | 3736 | 79 |
1908502 | 1908502 | 2021-11-12 | Cherokee | Kansas | 20021 | 3736 | 79 |
1905253 | 1905253 | 2021-11-11 | Cherokee | Kansas | 20021 | 3723 | 79 |
1902003 | 1902003 | 2021-11-10 | Cherokee | Kansas | 20021 | 3723 | 79 |
1898753 | 1898753 | 2021-11-09 | Cherokee | Kansas | 20021 | 3700 | 79 |
1895503 | 1895503 | 2021-11-08 | Cherokee | Kansas | 20021 | 3700 | 79 |
1892253 | 1892253 | 2021-11-07 | Cherokee | Kansas | 20021 | 3688 | 79 |
1889003 | 1889003 | 2021-11-06 | Cherokee | Kansas | 20021 | 3688 | 79 |
1885753 | 1885753 | 2021-11-05 | Cherokee | Kansas | 20021 | 3688 | 79 |
1882504 | 1882504 | 2021-11-04 | Cherokee | Kansas | 20021 | 3679 | 79 |
1879255 | 1879255 | 2021-11-03 | Cherokee | Kansas | 20021 | 3679 | 79 |
1876006 | 1876006 | 2021-11-02 | Cherokee | Kansas | 20021 | 3665 | 79 |
1872757 | 1872757 | 2021-11-01 | Cherokee | Kansas | 20021 | 3665 | 79 |
1869508 | 1869508 | 2021-10-31 | Cherokee | Kansas | 20021 | 3662 | 79 |
1866259 | 1866259 | 2021-10-30 | Cherokee | Kansas | 20021 | 3662 | 79 |
1863010 | 1863010 | 2021-10-29 | Cherokee | Kansas | 20021 | 3662 | 79 |
1859761 | 1859761 | 2021-10-28 | Cherokee | Kansas | 20021 | 3652 | 77 |
1856512 | 1856512 | 2021-10-27 | Cherokee | Kansas | 20021 | 3652 | 77 |
1853263 | 1853263 | 2021-10-26 | Cherokee | Kansas | 20021 | 3636 | 77 |
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);