ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
628 rows where fips = 20199 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175191 | 2175191 | 2022-02-02 | Wallace | Kansas | 20199 | 407 | 5 |
2171938 | 2171938 | 2022-02-01 | Wallace | Kansas | 20199 | 405 | 5 |
2168685 | 2168685 | 2022-01-31 | Wallace | Kansas | 20199 | 405 | 5 |
2165430 | 2165430 | 2022-01-30 | Wallace | Kansas | 20199 | 401 | 5 |
2162175 | 2162175 | 2022-01-29 | Wallace | Kansas | 20199 | 401 | 5 |
2158920 | 2158920 | 2022-01-28 | Wallace | Kansas | 20199 | 401 | 5 |
2155666 | 2155666 | 2022-01-27 | Wallace | Kansas | 20199 | 400 | 5 |
2152413 | 2152413 | 2022-01-26 | Wallace | Kansas | 20199 | 400 | 5 |
2149161 | 2149161 | 2022-01-25 | Wallace | Kansas | 20199 | 390 | 5 |
2145909 | 2145909 | 2022-01-24 | Wallace | Kansas | 20199 | 390 | 5 |
2142654 | 2142654 | 2022-01-23 | Wallace | Kansas | 20199 | 388 | 5 |
2139399 | 2139399 | 2022-01-22 | Wallace | Kansas | 20199 | 388 | 5 |
2136143 | 2136143 | 2022-01-21 | Wallace | Kansas | 20199 | 388 | 5 |
2132891 | 2132891 | 2022-01-20 | Wallace | Kansas | 20199 | 379 | 5 |
2129638 | 2129638 | 2022-01-19 | Wallace | Kansas | 20199 | 379 | 5 |
2126384 | 2126384 | 2022-01-18 | Wallace | Kansas | 20199 | 373 | 5 |
2123132 | 2123132 | 2022-01-17 | Wallace | Kansas | 20199 | 373 | 5 |
2119880 | 2119880 | 2022-01-16 | Wallace | Kansas | 20199 | 373 | 5 |
2116628 | 2116628 | 2022-01-15 | Wallace | Kansas | 20199 | 373 | 5 |
2113377 | 2113377 | 2022-01-14 | Wallace | Kansas | 20199 | 373 | 5 |
2110125 | 2110125 | 2022-01-13 | Wallace | Kansas | 20199 | 366 | 5 |
2106874 | 2106874 | 2022-01-12 | Wallace | Kansas | 20199 | 366 | 5 |
2103623 | 2103623 | 2022-01-11 | Wallace | Kansas | 20199 | 361 | 5 |
2100372 | 2100372 | 2022-01-10 | Wallace | Kansas | 20199 | 361 | 5 |
2097121 | 2097121 | 2022-01-09 | Wallace | Kansas | 20199 | 359 | 5 |
2093869 | 2093869 | 2022-01-08 | Wallace | Kansas | 20199 | 359 | 5 |
2090617 | 2090617 | 2022-01-07 | Wallace | Kansas | 20199 | 359 | 5 |
2087366 | 2087366 | 2022-01-06 | Wallace | Kansas | 20199 | 354 | 5 |
2084114 | 2084114 | 2022-01-05 | Wallace | Kansas | 20199 | 354 | 5 |
2080862 | 2080862 | 2022-01-04 | Wallace | Kansas | 20199 | 350 | 5 |
2077610 | 2077610 | 2022-01-03 | Wallace | Kansas | 20199 | 350 | 5 |
2074359 | 2074359 | 2022-01-02 | Wallace | Kansas | 20199 | 346 | 5 |
2071108 | 2071108 | 2022-01-01 | Wallace | Kansas | 20199 | 346 | 5 |
2067857 | 2067857 | 2021-12-31 | Wallace | Kansas | 20199 | 346 | 5 |
2064606 | 2064606 | 2021-12-30 | Wallace | Kansas | 20199 | 346 | 5 |
2061356 | 2061356 | 2021-12-29 | Wallace | Kansas | 20199 | 346 | 5 |
2058107 | 2058107 | 2021-12-28 | Wallace | Kansas | 20199 | 344 | 5 |
2054858 | 2054858 | 2021-12-27 | Wallace | Kansas | 20199 | 344 | 5 |
2051608 | 2051608 | 2021-12-26 | Wallace | Kansas | 20199 | 340 | 5 |
2048358 | 2048358 | 2021-12-25 | Wallace | Kansas | 20199 | 340 | 5 |
2045108 | 2045108 | 2021-12-24 | Wallace | Kansas | 20199 | 340 | 5 |
2041859 | 2041859 | 2021-12-23 | Wallace | Kansas | 20199 | 340 | 5 |
2038609 | 2038609 | 2021-12-22 | Wallace | Kansas | 20199 | 340 | 5 |
2035359 | 2035359 | 2021-12-21 | Wallace | Kansas | 20199 | 339 | 5 |
2032109 | 2032109 | 2021-12-20 | Wallace | Kansas | 20199 | 339 | 5 |
2028858 | 2028858 | 2021-12-19 | Wallace | Kansas | 20199 | 336 | 5 |
2025607 | 2025607 | 2021-12-18 | Wallace | Kansas | 20199 | 336 | 5 |
2022356 | 2022356 | 2021-12-17 | Wallace | Kansas | 20199 | 336 | 5 |
2019105 | 2019105 | 2021-12-16 | Wallace | Kansas | 20199 | 335 | 5 |
2015855 | 2015855 | 2021-12-15 | Wallace | Kansas | 20199 | 335 | 5 |
2012604 | 2012604 | 2021-12-14 | Wallace | Kansas | 20199 | 333 | 5 |
2009353 | 2009353 | 2021-12-13 | Wallace | Kansas | 20199 | 333 | 5 |
2006102 | 2006102 | 2021-12-12 | Wallace | Kansas | 20199 | 332 | 5 |
2002851 | 2002851 | 2021-12-11 | Wallace | Kansas | 20199 | 332 | 5 |
1999601 | 1999601 | 2021-12-10 | Wallace | Kansas | 20199 | 332 | 5 |
1996350 | 1996350 | 2021-12-09 | Wallace | Kansas | 20199 | 331 | 5 |
1993099 | 1993099 | 2021-12-08 | Wallace | Kansas | 20199 | 331 | 5 |
1989848 | 1989848 | 2021-12-07 | Wallace | Kansas | 20199 | 327 | 5 |
1986598 | 1986598 | 2021-12-06 | Wallace | Kansas | 20199 | 327 | 5 |
1983348 | 1983348 | 2021-12-05 | Wallace | Kansas | 20199 | 325 | 5 |
1980098 | 1980098 | 2021-12-04 | Wallace | Kansas | 20199 | 325 | 5 |
1976848 | 1976848 | 2021-12-03 | Wallace | Kansas | 20199 | 325 | 5 |
1973599 | 1973599 | 2021-12-02 | Wallace | Kansas | 20199 | 324 | 5 |
1970349 | 1970349 | 2021-12-01 | Wallace | Kansas | 20199 | 324 | 5 |
1967099 | 1967099 | 2021-11-30 | Wallace | Kansas | 20199 | 313 | 5 |
1963847 | 1963847 | 2021-11-29 | Wallace | Kansas | 20199 | 313 | 5 |
1960596 | 1960596 | 2021-11-28 | Wallace | Kansas | 20199 | 309 | 5 |
1957345 | 1957345 | 2021-11-27 | Wallace | Kansas | 20199 | 309 | 5 |
1954094 | 1954094 | 2021-11-26 | Wallace | Kansas | 20199 | 309 | 5 |
1950843 | 1950843 | 2021-11-25 | Wallace | Kansas | 20199 | 309 | 5 |
1947592 | 1947592 | 2021-11-24 | Wallace | Kansas | 20199 | 309 | 5 |
1944341 | 1944341 | 2021-11-23 | Wallace | Kansas | 20199 | 299 | 4 |
1941091 | 1941091 | 2021-11-22 | Wallace | Kansas | 20199 | 299 | 4 |
1937841 | 1937841 | 2021-11-21 | Wallace | Kansas | 20199 | 293 | 4 |
1934591 | 1934591 | 2021-11-20 | Wallace | Kansas | 20199 | 293 | 4 |
1931340 | 1931340 | 2021-11-19 | Wallace | Kansas | 20199 | 293 | 4 |
1928089 | 1928089 | 2021-11-18 | Wallace | Kansas | 20199 | 288 | 4 |
1924839 | 1924839 | 2021-11-17 | Wallace | Kansas | 20199 | 288 | 4 |
1921590 | 1921590 | 2021-11-16 | Wallace | Kansas | 20199 | 279 | 4 |
1918340 | 1918340 | 2021-11-15 | Wallace | Kansas | 20199 | 279 | 4 |
1915090 | 1915090 | 2021-11-14 | Wallace | Kansas | 20199 | 278 | 4 |
1911840 | 1911840 | 2021-11-13 | Wallace | Kansas | 20199 | 278 | 4 |
1908591 | 1908591 | 2021-11-12 | Wallace | Kansas | 20199 | 278 | 4 |
1905342 | 1905342 | 2021-11-11 | Wallace | Kansas | 20199 | 270 | 4 |
1902092 | 1902092 | 2021-11-10 | Wallace | Kansas | 20199 | 270 | 4 |
1898842 | 1898842 | 2021-11-09 | Wallace | Kansas | 20199 | 266 | 4 |
1895592 | 1895592 | 2021-11-08 | Wallace | Kansas | 20199 | 266 | 4 |
1892342 | 1892342 | 2021-11-07 | Wallace | Kansas | 20199 | 261 | 4 |
1889092 | 1889092 | 2021-11-06 | Wallace | Kansas | 20199 | 261 | 4 |
1885842 | 1885842 | 2021-11-05 | Wallace | Kansas | 20199 | 261 | 4 |
1882593 | 1882593 | 2021-11-04 | Wallace | Kansas | 20199 | 252 | 4 |
1879344 | 1879344 | 2021-11-03 | Wallace | Kansas | 20199 | 252 | 4 |
1876095 | 1876095 | 2021-11-02 | Wallace | Kansas | 20199 | 244 | 4 |
1872846 | 1872846 | 2021-11-01 | Wallace | Kansas | 20199 | 244 | 4 |
1869597 | 1869597 | 2021-10-31 | Wallace | Kansas | 20199 | 242 | 4 |
1866348 | 1866348 | 2021-10-30 | Wallace | Kansas | 20199 | 242 | 4 |
1863099 | 1863099 | 2021-10-29 | Wallace | Kansas | 20199 | 242 | 4 |
1859850 | 1859850 | 2021-10-28 | Wallace | Kansas | 20199 | 238 | 4 |
1856601 | 1856601 | 2021-10-27 | Wallace | Kansas | 20199 | 238 | 4 |
1853352 | 1853352 | 2021-10-26 | Wallace | Kansas | 20199 | 238 | 4 |
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);