ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Sedgwick" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175178 | 2175178 | 2022-02-02 | Sedgwick | Kansas | 20173 | 140691 | 1179 |
2171925 | 2171925 | 2022-02-01 | Sedgwick | Kansas | 20173 | 138916 | 1175 |
2168672 | 2168672 | 2022-01-31 | Sedgwick | Kansas | 20173 | 138916 | 1175 |
2165417 | 2165417 | 2022-01-30 | Sedgwick | Kansas | 20173 | 137653 | 1175 |
2162162 | 2162162 | 2022-01-29 | Sedgwick | Kansas | 20173 | 137653 | 1175 |
2158907 | 2158907 | 2022-01-28 | Sedgwick | Kansas | 20173 | 137653 | 1175 |
2155653 | 2155653 | 2022-01-27 | Sedgwick | Kansas | 20173 | 134671 | 1144 |
2152400 | 2152400 | 2022-01-26 | Sedgwick | Kansas | 20173 | 134671 | 1144 |
2149148 | 2149148 | 2022-01-25 | Sedgwick | Kansas | 20173 | 131614 | 1135 |
2145896 | 2145896 | 2022-01-24 | Sedgwick | Kansas | 20173 | 131614 | 1135 |
2142641 | 2142641 | 2022-01-23 | Sedgwick | Kansas | 20173 | 128867 | 1135 |
2139386 | 2139386 | 2022-01-22 | Sedgwick | Kansas | 20173 | 128867 | 1135 |
2136130 | 2136130 | 2022-01-21 | Sedgwick | Kansas | 20173 | 128867 | 1135 |
2132878 | 2132878 | 2022-01-20 | Sedgwick | Kansas | 20173 | 125073 | 1133 |
2129625 | 2129625 | 2022-01-19 | Sedgwick | Kansas | 20173 | 125073 | 1133 |
2126371 | 2126371 | 2022-01-18 | Sedgwick | Kansas | 20173 | 118097 | 1110 |
2123119 | 2123119 | 2022-01-17 | Sedgwick | Kansas | 20173 | 118097 | 1110 |
2119867 | 2119867 | 2022-01-16 | Sedgwick | Kansas | 20173 | 118097 | 1110 |
2116615 | 2116615 | 2022-01-15 | Sedgwick | Kansas | 20173 | 118097 | 1110 |
2113364 | 2113364 | 2022-01-14 | Sedgwick | Kansas | 20173 | 118097 | 1110 |
2110112 | 2110112 | 2022-01-13 | Sedgwick | Kansas | 20173 | 114007 | 1109 |
2106861 | 2106861 | 2022-01-12 | Sedgwick | Kansas | 20173 | 114007 | 1109 |
2103610 | 2103610 | 2022-01-11 | Sedgwick | Kansas | 20173 | 109368 | 1107 |
2100359 | 2100359 | 2022-01-10 | Sedgwick | Kansas | 20173 | 109368 | 1107 |
2097108 | 2097108 | 2022-01-09 | Sedgwick | Kansas | 20173 | 106588 | 1107 |
2093856 | 2093856 | 2022-01-08 | Sedgwick | Kansas | 20173 | 106588 | 1107 |
2090604 | 2090604 | 2022-01-07 | Sedgwick | Kansas | 20173 | 106588 | 1107 |
2087353 | 2087353 | 2022-01-06 | Sedgwick | Kansas | 20173 | 102956 | 1107 |
2084101 | 2084101 | 2022-01-05 | Sedgwick | Kansas | 20173 | 102956 | 1107 |
2080849 | 2080849 | 2022-01-04 | Sedgwick | Kansas | 20173 | 99282 | 1107 |
2077597 | 2077597 | 2022-01-03 | Sedgwick | Kansas | 20173 | 99282 | 1107 |
2074346 | 2074346 | 2022-01-02 | Sedgwick | Kansas | 20173 | 96411 | 1103 |
2071095 | 2071095 | 2022-01-01 | Sedgwick | Kansas | 20173 | 96411 | 1103 |
2067844 | 2067844 | 2021-12-31 | Sedgwick | Kansas | 20173 | 96411 | 1103 |
2064593 | 2064593 | 2021-12-30 | Sedgwick | Kansas | 20173 | 96411 | 1103 |
2061343 | 2061343 | 2021-12-29 | Sedgwick | Kansas | 20173 | 96411 | 1103 |
2058094 | 2058094 | 2021-12-28 | Sedgwick | Kansas | 20173 | 94917 | 1100 |
2054845 | 2054845 | 2021-12-27 | Sedgwick | Kansas | 20173 | 94917 | 1100 |
2051595 | 2051595 | 2021-12-26 | Sedgwick | Kansas | 20173 | 93644 | 1100 |
2048345 | 2048345 | 2021-12-25 | Sedgwick | Kansas | 20173 | 93644 | 1100 |
2045095 | 2045095 | 2021-12-24 | Sedgwick | Kansas | 20173 | 93644 | 1100 |
2041846 | 2041846 | 2021-12-23 | Sedgwick | Kansas | 20173 | 93644 | 1100 |
2038596 | 2038596 | 2021-12-22 | Sedgwick | Kansas | 20173 | 93644 | 1100 |
2035346 | 2035346 | 2021-12-21 | Sedgwick | Kansas | 20173 | 92575 | 1097 |
2032096 | 2032096 | 2021-12-20 | Sedgwick | Kansas | 20173 | 92575 | 1097 |
2028845 | 2028845 | 2021-12-19 | Sedgwick | Kansas | 20173 | 92138 | 1097 |
2025594 | 2025594 | 2021-12-18 | Sedgwick | Kansas | 20173 | 92138 | 1097 |
2022343 | 2022343 | 2021-12-17 | Sedgwick | Kansas | 20173 | 92138 | 1097 |
2019092 | 2019092 | 2021-12-16 | Sedgwick | Kansas | 20173 | 91349 | 1095 |
2015842 | 2015842 | 2021-12-15 | Sedgwick | Kansas | 20173 | 91349 | 1095 |
2012591 | 2012591 | 2021-12-14 | Sedgwick | Kansas | 20173 | 90651 | 1094 |
2009340 | 2009340 | 2021-12-13 | Sedgwick | Kansas | 20173 | 90651 | 1094 |
2006089 | 2006089 | 2021-12-12 | Sedgwick | Kansas | 20173 | 90060 | 1087 |
2002838 | 2002838 | 2021-12-11 | Sedgwick | Kansas | 20173 | 90060 | 1087 |
1999588 | 1999588 | 2021-12-10 | Sedgwick | Kansas | 20173 | 90060 | 1087 |
1996337 | 1996337 | 2021-12-09 | Sedgwick | Kansas | 20173 | 89469 | 1075 |
1993086 | 1993086 | 2021-12-08 | Sedgwick | Kansas | 20173 | 89469 | 1075 |
1989835 | 1989835 | 2021-12-07 | Sedgwick | Kansas | 20173 | 88738 | 1075 |
1986585 | 1986585 | 2021-12-06 | Sedgwick | Kansas | 20173 | 88738 | 1075 |
1983335 | 1983335 | 2021-12-05 | Sedgwick | Kansas | 20173 | 88125 | 1075 |
1980085 | 1980085 | 2021-12-04 | Sedgwick | Kansas | 20173 | 88125 | 1075 |
1976835 | 1976835 | 2021-12-03 | Sedgwick | Kansas | 20173 | 88125 | 1075 |
1973586 | 1973586 | 2021-12-02 | Sedgwick | Kansas | 20173 | 87331 | 1074 |
1970336 | 1970336 | 2021-12-01 | Sedgwick | Kansas | 20173 | 87331 | 1074 |
1967086 | 1967086 | 2021-11-30 | Sedgwick | Kansas | 20173 | 86516 | 1073 |
1963834 | 1963834 | 2021-11-29 | Sedgwick | Kansas | 20173 | 86516 | 1073 |
1960583 | 1960583 | 2021-11-28 | Sedgwick | Kansas | 20173 | 85808 | 1073 |
1957332 | 1957332 | 2021-11-27 | Sedgwick | Kansas | 20173 | 85808 | 1073 |
1954081 | 1954081 | 2021-11-26 | Sedgwick | Kansas | 20173 | 85808 | 1073 |
1950830 | 1950830 | 2021-11-25 | Sedgwick | Kansas | 20173 | 85808 | 1073 |
1947579 | 1947579 | 2021-11-24 | Sedgwick | Kansas | 20173 | 85808 | 1073 |
1944328 | 1944328 | 2021-11-23 | Sedgwick | Kansas | 20173 | 85316 | 1063 |
1941078 | 1941078 | 2021-11-22 | Sedgwick | Kansas | 20173 | 85316 | 1063 |
1937828 | 1937828 | 2021-11-21 | Sedgwick | Kansas | 20173 | 84930 | 1063 |
1934578 | 1934578 | 2021-11-20 | Sedgwick | Kansas | 20173 | 84930 | 1063 |
1931327 | 1931327 | 2021-11-19 | Sedgwick | Kansas | 20173 | 84930 | 1063 |
1928076 | 1928076 | 2021-11-18 | Sedgwick | Kansas | 20173 | 84417 | 1063 |
1924826 | 1924826 | 2021-11-17 | Sedgwick | Kansas | 20173 | 84417 | 1063 |
1921577 | 1921577 | 2021-11-16 | Sedgwick | Kansas | 20173 | 83930 | 1063 |
1918327 | 1918327 | 2021-11-15 | Sedgwick | Kansas | 20173 | 83930 | 1063 |
1915077 | 1915077 | 2021-11-14 | Sedgwick | Kansas | 20173 | 83621 | 1063 |
1911827 | 1911827 | 2021-11-13 | Sedgwick | Kansas | 20173 | 83621 | 1063 |
1908578 | 1908578 | 2021-11-12 | Sedgwick | Kansas | 20173 | 83621 | 1063 |
1905329 | 1905329 | 2021-11-11 | Sedgwick | Kansas | 20173 | 83089 | 1063 |
1902079 | 1902079 | 2021-11-10 | Sedgwick | Kansas | 20173 | 83089 | 1063 |
1898829 | 1898829 | 2021-11-09 | Sedgwick | Kansas | 20173 | 82724 | 1043 |
1895579 | 1895579 | 2021-11-08 | Sedgwick | Kansas | 20173 | 82724 | 1043 |
1892329 | 1892329 | 2021-11-07 | Sedgwick | Kansas | 20173 | 82446 | 1032 |
1889079 | 1889079 | 2021-11-06 | Sedgwick | Kansas | 20173 | 82446 | 1032 |
1885829 | 1885829 | 2021-11-05 | Sedgwick | Kansas | 20173 | 82446 | 1032 |
1882580 | 1882580 | 2021-11-04 | Sedgwick | Kansas | 20173 | 82122 | 1020 |
1879331 | 1879331 | 2021-11-03 | Sedgwick | Kansas | 20173 | 82122 | 1020 |
1876082 | 1876082 | 2021-11-02 | Sedgwick | Kansas | 20173 | 81797 | 1018 |
1872833 | 1872833 | 2021-11-01 | Sedgwick | Kansas | 20173 | 81797 | 1018 |
1869584 | 1869584 | 2021-10-31 | Sedgwick | Kansas | 20173 | 81588 | 1017 |
1866335 | 1866335 | 2021-10-30 | Sedgwick | Kansas | 20173 | 81588 | 1017 |
1863086 | 1863086 | 2021-10-29 | Sedgwick | Kansas | 20173 | 81588 | 1017 |
1859837 | 1859837 | 2021-10-28 | Sedgwick | Kansas | 20173 | 81267 | 994 |
1856588 | 1856588 | 2021-10-27 | Sedgwick | Kansas | 20173 | 81267 | 994 |
1853339 | 1853339 | 2021-10-26 | Sedgwick | Kansas | 20173 | 80808 | 968 |
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);