ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
703 rows where county = "Washington" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175192 | 2175192 | 2022-02-02 | Washington | Kansas | 20201 | 1328 | 20 |
2171939 | 2171939 | 2022-02-01 | Washington | Kansas | 20201 | 1306 | 20 |
2168686 | 2168686 | 2022-01-31 | Washington | Kansas | 20201 | 1306 | 20 |
2165431 | 2165431 | 2022-01-30 | Washington | Kansas | 20201 | 1286 | 20 |
2162176 | 2162176 | 2022-01-29 | Washington | Kansas | 20201 | 1286 | 20 |
2158921 | 2158921 | 2022-01-28 | Washington | Kansas | 20201 | 1286 | 20 |
2155667 | 2155667 | 2022-01-27 | Washington | Kansas | 20201 | 1267 | 20 |
2152414 | 2152414 | 2022-01-26 | Washington | Kansas | 20201 | 1267 | 20 |
2149162 | 2149162 | 2022-01-25 | Washington | Kansas | 20201 | 1240 | 20 |
2145910 | 2145910 | 2022-01-24 | Washington | Kansas | 20201 | 1240 | 20 |
2142655 | 2142655 | 2022-01-23 | Washington | Kansas | 20201 | 1234 | 20 |
2139400 | 2139400 | 2022-01-22 | Washington | Kansas | 20201 | 1234 | 20 |
2136144 | 2136144 | 2022-01-21 | Washington | Kansas | 20201 | 1234 | 20 |
2132892 | 2132892 | 2022-01-20 | Washington | Kansas | 20201 | 1186 | 20 |
2129639 | 2129639 | 2022-01-19 | Washington | Kansas | 20201 | 1186 | 20 |
2126385 | 2126385 | 2022-01-18 | Washington | Kansas | 20201 | 1136 | 17 |
2123133 | 2123133 | 2022-01-17 | Washington | Kansas | 20201 | 1136 | 17 |
2119881 | 2119881 | 2022-01-16 | Washington | Kansas | 20201 | 1136 | 17 |
2116629 | 2116629 | 2022-01-15 | Washington | Kansas | 20201 | 1136 | 17 |
2113378 | 2113378 | 2022-01-14 | Washington | Kansas | 20201 | 1136 | 17 |
2110126 | 2110126 | 2022-01-13 | Washington | Kansas | 20201 | 1108 | 17 |
2106875 | 2106875 | 2022-01-12 | Washington | Kansas | 20201 | 1108 | 17 |
2103624 | 2103624 | 2022-01-11 | Washington | Kansas | 20201 | 1077 | 17 |
2100373 | 2100373 | 2022-01-10 | Washington | Kansas | 20201 | 1077 | 17 |
2097122 | 2097122 | 2022-01-09 | Washington | Kansas | 20201 | 1067 | 17 |
2093870 | 2093870 | 2022-01-08 | Washington | Kansas | 20201 | 1067 | 17 |
2090618 | 2090618 | 2022-01-07 | Washington | Kansas | 20201 | 1067 | 17 |
2087367 | 2087367 | 2022-01-06 | Washington | Kansas | 20201 | 1052 | 17 |
2084115 | 2084115 | 2022-01-05 | Washington | Kansas | 20201 | 1052 | 17 |
2080863 | 2080863 | 2022-01-04 | Washington | Kansas | 20201 | 1033 | 18 |
2077611 | 2077611 | 2022-01-03 | Washington | Kansas | 20201 | 1033 | 18 |
2074360 | 2074360 | 2022-01-02 | Washington | Kansas | 20201 | 1016 | 18 |
2071109 | 2071109 | 2022-01-01 | Washington | Kansas | 20201 | 1016 | 18 |
2067858 | 2067858 | 2021-12-31 | Washington | Kansas | 20201 | 1016 | 18 |
2064607 | 2064607 | 2021-12-30 | Washington | Kansas | 20201 | 1016 | 18 |
2061357 | 2061357 | 2021-12-29 | Washington | Kansas | 20201 | 1016 | 18 |
2058108 | 2058108 | 2021-12-28 | Washington | Kansas | 20201 | 1010 | 17 |
2054859 | 2054859 | 2021-12-27 | Washington | Kansas | 20201 | 1010 | 17 |
2051609 | 2051609 | 2021-12-26 | Washington | Kansas | 20201 | 996 | 17 |
2048359 | 2048359 | 2021-12-25 | Washington | Kansas | 20201 | 996 | 17 |
2045109 | 2045109 | 2021-12-24 | Washington | Kansas | 20201 | 996 | 17 |
2041860 | 2041860 | 2021-12-23 | Washington | Kansas | 20201 | 996 | 17 |
2038610 | 2038610 | 2021-12-22 | Washington | Kansas | 20201 | 996 | 17 |
2035360 | 2035360 | 2021-12-21 | Washington | Kansas | 20201 | 977 | 17 |
2032110 | 2032110 | 2021-12-20 | Washington | Kansas | 20201 | 977 | 17 |
2028859 | 2028859 | 2021-12-19 | Washington | Kansas | 20201 | 967 | 17 |
2025608 | 2025608 | 2021-12-18 | Washington | Kansas | 20201 | 967 | 17 |
2022357 | 2022357 | 2021-12-17 | Washington | Kansas | 20201 | 967 | 17 |
2019106 | 2019106 | 2021-12-16 | Washington | Kansas | 20201 | 960 | 17 |
2015856 | 2015856 | 2021-12-15 | Washington | Kansas | 20201 | 960 | 17 |
2012605 | 2012605 | 2021-12-14 | Washington | Kansas | 20201 | 949 | 17 |
2009354 | 2009354 | 2021-12-13 | Washington | Kansas | 20201 | 949 | 17 |
2006103 | 2006103 | 2021-12-12 | Washington | Kansas | 20201 | 942 | 17 |
2002852 | 2002852 | 2021-12-11 | Washington | Kansas | 20201 | 942 | 17 |
1999602 | 1999602 | 2021-12-10 | Washington | Kansas | 20201 | 942 | 17 |
1996351 | 1996351 | 2021-12-09 | Washington | Kansas | 20201 | 934 | 17 |
1993100 | 1993100 | 2021-12-08 | Washington | Kansas | 20201 | 934 | 17 |
1989849 | 1989849 | 2021-12-07 | Washington | Kansas | 20201 | 926 | 17 |
1986599 | 1986599 | 2021-12-06 | Washington | Kansas | 20201 | 926 | 17 |
1983349 | 1983349 | 2021-12-05 | Washington | Kansas | 20201 | 919 | 17 |
1980099 | 1980099 | 2021-12-04 | Washington | Kansas | 20201 | 919 | 17 |
1976849 | 1976849 | 2021-12-03 | Washington | Kansas | 20201 | 919 | 17 |
1973600 | 1973600 | 2021-12-02 | Washington | Kansas | 20201 | 913 | 17 |
1970350 | 1970350 | 2021-12-01 | Washington | Kansas | 20201 | 913 | 17 |
1967100 | 1967100 | 2021-11-30 | Washington | Kansas | 20201 | 901 | 17 |
1963848 | 1963848 | 2021-11-29 | Washington | Kansas | 20201 | 901 | 17 |
1960597 | 1960597 | 2021-11-28 | Washington | Kansas | 20201 | 893 | 17 |
1957346 | 1957346 | 2021-11-27 | Washington | Kansas | 20201 | 893 | 17 |
1954095 | 1954095 | 2021-11-26 | Washington | Kansas | 20201 | 893 | 17 |
1950844 | 1950844 | 2021-11-25 | Washington | Kansas | 20201 | 893 | 17 |
1947593 | 1947593 | 2021-11-24 | Washington | Kansas | 20201 | 893 | 17 |
1944342 | 1944342 | 2021-11-23 | Washington | Kansas | 20201 | 882 | 17 |
1941092 | 1941092 | 2021-11-22 | Washington | Kansas | 20201 | 882 | 17 |
1937842 | 1937842 | 2021-11-21 | Washington | Kansas | 20201 | 875 | 17 |
1934592 | 1934592 | 2021-11-20 | Washington | Kansas | 20201 | 875 | 17 |
1931341 | 1931341 | 2021-11-19 | Washington | Kansas | 20201 | 875 | 17 |
1928090 | 1928090 | 2021-11-18 | Washington | Kansas | 20201 | 867 | 17 |
1924840 | 1924840 | 2021-11-17 | Washington | Kansas | 20201 | 867 | 17 |
1921591 | 1921591 | 2021-11-16 | Washington | Kansas | 20201 | 860 | 17 |
1918341 | 1918341 | 2021-11-15 | Washington | Kansas | 20201 | 860 | 17 |
1915091 | 1915091 | 2021-11-14 | Washington | Kansas | 20201 | 859 | 17 |
1911841 | 1911841 | 2021-11-13 | Washington | Kansas | 20201 | 859 | 17 |
1908592 | 1908592 | 2021-11-12 | Washington | Kansas | 20201 | 859 | 17 |
1905343 | 1905343 | 2021-11-11 | Washington | Kansas | 20201 | 851 | 17 |
1902093 | 1902093 | 2021-11-10 | Washington | Kansas | 20201 | 851 | 17 |
1898843 | 1898843 | 2021-11-09 | Washington | Kansas | 20201 | 846 | 17 |
1895593 | 1895593 | 2021-11-08 | Washington | Kansas | 20201 | 846 | 17 |
1892343 | 1892343 | 2021-11-07 | Washington | Kansas | 20201 | 840 | 17 |
1889093 | 1889093 | 2021-11-06 | Washington | Kansas | 20201 | 840 | 17 |
1885843 | 1885843 | 2021-11-05 | Washington | Kansas | 20201 | 840 | 17 |
1882594 | 1882594 | 2021-11-04 | Washington | Kansas | 20201 | 834 | 17 |
1879345 | 1879345 | 2021-11-03 | Washington | Kansas | 20201 | 834 | 17 |
1876096 | 1876096 | 2021-11-02 | Washington | Kansas | 20201 | 818 | 17 |
1872847 | 1872847 | 2021-11-01 | Washington | Kansas | 20201 | 818 | 17 |
1869598 | 1869598 | 2021-10-31 | Washington | Kansas | 20201 | 814 | 17 |
1866349 | 1866349 | 2021-10-30 | Washington | Kansas | 20201 | 814 | 17 |
1863100 | 1863100 | 2021-10-29 | Washington | Kansas | 20201 | 814 | 17 |
1859851 | 1859851 | 2021-10-28 | Washington | Kansas | 20201 | 806 | 17 |
1856602 | 1856602 | 2021-10-27 | Washington | Kansas | 20201 | 806 | 17 |
1853353 | 1853353 | 2021-10-26 | Washington | Kansas | 20201 | 795 | 16 |
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);