ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
769 rows where fips = 20157 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175170 | 2175170 | 2022-02-02 | Republic | Kansas | 20157 | 1291 | 14 |
2171917 | 2171917 | 2022-02-01 | Republic | Kansas | 20157 | 1282 | 14 |
2168664 | 2168664 | 2022-01-31 | Republic | Kansas | 20157 | 1282 | 14 |
2165409 | 2165409 | 2022-01-30 | Republic | Kansas | 20157 | 1272 | 14 |
2162154 | 2162154 | 2022-01-29 | Republic | Kansas | 20157 | 1272 | 14 |
2158899 | 2158899 | 2022-01-28 | Republic | Kansas | 20157 | 1272 | 14 |
2155645 | 2155645 | 2022-01-27 | Republic | Kansas | 20157 | 1256 | 14 |
2152392 | 2152392 | 2022-01-26 | Republic | Kansas | 20157 | 1256 | 14 |
2149140 | 2149140 | 2022-01-25 | Republic | Kansas | 20157 | 1235 | 14 |
2145888 | 2145888 | 2022-01-24 | Republic | Kansas | 20157 | 1235 | 14 |
2142633 | 2142633 | 2022-01-23 | Republic | Kansas | 20157 | 1221 | 14 |
2139378 | 2139378 | 2022-01-22 | Republic | Kansas | 20157 | 1221 | 14 |
2136122 | 2136122 | 2022-01-21 | Republic | Kansas | 20157 | 1221 | 14 |
2132870 | 2132870 | 2022-01-20 | Republic | Kansas | 20157 | 1191 | 14 |
2129617 | 2129617 | 2022-01-19 | Republic | Kansas | 20157 | 1191 | 14 |
2126363 | 2126363 | 2022-01-18 | Republic | Kansas | 20157 | 1129 | 14 |
2123111 | 2123111 | 2022-01-17 | Republic | Kansas | 20157 | 1129 | 14 |
2119859 | 2119859 | 2022-01-16 | Republic | Kansas | 20157 | 1129 | 14 |
2116607 | 2116607 | 2022-01-15 | Republic | Kansas | 20157 | 1129 | 14 |
2113356 | 2113356 | 2022-01-14 | Republic | Kansas | 20157 | 1129 | 14 |
2110104 | 2110104 | 2022-01-13 | Republic | Kansas | 20157 | 1097 | 14 |
2106853 | 2106853 | 2022-01-12 | Republic | Kansas | 20157 | 1097 | 14 |
2103602 | 2103602 | 2022-01-11 | Republic | Kansas | 20157 | 1065 | 14 |
2100351 | 2100351 | 2022-01-10 | Republic | Kansas | 20157 | 1065 | 14 |
2097100 | 2097100 | 2022-01-09 | Republic | Kansas | 20157 | 1056 | 14 |
2093848 | 2093848 | 2022-01-08 | Republic | Kansas | 20157 | 1056 | 14 |
2090596 | 2090596 | 2022-01-07 | Republic | Kansas | 20157 | 1056 | 14 |
2087345 | 2087345 | 2022-01-06 | Republic | Kansas | 20157 | 1046 | 14 |
2084093 | 2084093 | 2022-01-05 | Republic | Kansas | 20157 | 1046 | 14 |
2080841 | 2080841 | 2022-01-04 | Republic | Kansas | 20157 | 1033 | 14 |
2077589 | 2077589 | 2022-01-03 | Republic | Kansas | 20157 | 1033 | 14 |
2074338 | 2074338 | 2022-01-02 | Republic | Kansas | 20157 | 1014 | 14 |
2071087 | 2071087 | 2022-01-01 | Republic | Kansas | 20157 | 1014 | 14 |
2067836 | 2067836 | 2021-12-31 | Republic | Kansas | 20157 | 1014 | 14 |
2064585 | 2064585 | 2021-12-30 | Republic | Kansas | 20157 | 1014 | 14 |
2061335 | 2061335 | 2021-12-29 | Republic | Kansas | 20157 | 1014 | 14 |
2058086 | 2058086 | 2021-12-28 | Republic | Kansas | 20157 | 999 | 14 |
2054837 | 2054837 | 2021-12-27 | Republic | Kansas | 20157 | 999 | 14 |
2051587 | 2051587 | 2021-12-26 | Republic | Kansas | 20157 | 994 | 14 |
2048337 | 2048337 | 2021-12-25 | Republic | Kansas | 20157 | 994 | 14 |
2045087 | 2045087 | 2021-12-24 | Republic | Kansas | 20157 | 994 | 14 |
2041838 | 2041838 | 2021-12-23 | Republic | Kansas | 20157 | 994 | 14 |
2038588 | 2038588 | 2021-12-22 | Republic | Kansas | 20157 | 994 | 14 |
2035338 | 2035338 | 2021-12-21 | Republic | Kansas | 20157 | 984 | 14 |
2032088 | 2032088 | 2021-12-20 | Republic | Kansas | 20157 | 984 | 14 |
2028837 | 2028837 | 2021-12-19 | Republic | Kansas | 20157 | 976 | 14 |
2025586 | 2025586 | 2021-12-18 | Republic | Kansas | 20157 | 976 | 14 |
2022335 | 2022335 | 2021-12-17 | Republic | Kansas | 20157 | 976 | 14 |
2019084 | 2019084 | 2021-12-16 | Republic | Kansas | 20157 | 969 | 14 |
2015834 | 2015834 | 2021-12-15 | Republic | Kansas | 20157 | 969 | 14 |
2012583 | 2012583 | 2021-12-14 | Republic | Kansas | 20157 | 966 | 14 |
2009332 | 2009332 | 2021-12-13 | Republic | Kansas | 20157 | 966 | 14 |
2006081 | 2006081 | 2021-12-12 | Republic | Kansas | 20157 | 963 | 14 |
2002830 | 2002830 | 2021-12-11 | Republic | Kansas | 20157 | 963 | 14 |
1999580 | 1999580 | 2021-12-10 | Republic | Kansas | 20157 | 963 | 14 |
1996329 | 1996329 | 2021-12-09 | Republic | Kansas | 20157 | 955 | 14 |
1993078 | 1993078 | 2021-12-08 | Republic | Kansas | 20157 | 955 | 14 |
1989827 | 1989827 | 2021-12-07 | Republic | Kansas | 20157 | 952 | 14 |
1986577 | 1986577 | 2021-12-06 | Republic | Kansas | 20157 | 952 | 14 |
1983327 | 1983327 | 2021-12-05 | Republic | Kansas | 20157 | 949 | 14 |
1980077 | 1980077 | 2021-12-04 | Republic | Kansas | 20157 | 949 | 14 |
1976827 | 1976827 | 2021-12-03 | Republic | Kansas | 20157 | 949 | 14 |
1973578 | 1973578 | 2021-12-02 | Republic | Kansas | 20157 | 947 | 14 |
1970328 | 1970328 | 2021-12-01 | Republic | Kansas | 20157 | 947 | 14 |
1967078 | 1967078 | 2021-11-30 | Republic | Kansas | 20157 | 942 | 14 |
1963826 | 1963826 | 2021-11-29 | Republic | Kansas | 20157 | 942 | 14 |
1960575 | 1960575 | 2021-11-28 | Republic | Kansas | 20157 | 938 | 14 |
1957324 | 1957324 | 2021-11-27 | Republic | Kansas | 20157 | 938 | 14 |
1954073 | 1954073 | 2021-11-26 | Republic | Kansas | 20157 | 938 | 14 |
1950822 | 1950822 | 2021-11-25 | Republic | Kansas | 20157 | 938 | 14 |
1947571 | 1947571 | 2021-11-24 | Republic | Kansas | 20157 | 938 | 14 |
1944320 | 1944320 | 2021-11-23 | Republic | Kansas | 20157 | 927 | 14 |
1941070 | 1941070 | 2021-11-22 | Republic | Kansas | 20157 | 927 | 14 |
1937820 | 1937820 | 2021-11-21 | Republic | Kansas | 20157 | 924 | 14 |
1934570 | 1934570 | 2021-11-20 | Republic | Kansas | 20157 | 924 | 14 |
1931319 | 1931319 | 2021-11-19 | Republic | Kansas | 20157 | 924 | 14 |
1928068 | 1928068 | 2021-11-18 | Republic | Kansas | 20157 | 924 | 14 |
1924818 | 1924818 | 2021-11-17 | Republic | Kansas | 20157 | 924 | 14 |
1921569 | 1921569 | 2021-11-16 | Republic | Kansas | 20157 | 922 | 14 |
1918319 | 1918319 | 2021-11-15 | Republic | Kansas | 20157 | 922 | 14 |
1915069 | 1915069 | 2021-11-14 | Republic | Kansas | 20157 | 913 | 15 |
1911819 | 1911819 | 2021-11-13 | Republic | Kansas | 20157 | 913 | 15 |
1908570 | 1908570 | 2021-11-12 | Republic | Kansas | 20157 | 913 | 15 |
1905321 | 1905321 | 2021-11-11 | Republic | Kansas | 20157 | 910 | 15 |
1902071 | 1902071 | 2021-11-10 | Republic | Kansas | 20157 | 910 | 15 |
1898821 | 1898821 | 2021-11-09 | Republic | Kansas | 20157 | 901 | 15 |
1895571 | 1895571 | 2021-11-08 | Republic | Kansas | 20157 | 901 | 15 |
1892321 | 1892321 | 2021-11-07 | Republic | Kansas | 20157 | 896 | 15 |
1889071 | 1889071 | 2021-11-06 | Republic | Kansas | 20157 | 896 | 15 |
1885821 | 1885821 | 2021-11-05 | Republic | Kansas | 20157 | 896 | 15 |
1882572 | 1882572 | 2021-11-04 | Republic | Kansas | 20157 | 890 | 15 |
1879323 | 1879323 | 2021-11-03 | Republic | Kansas | 20157 | 890 | 15 |
1876074 | 1876074 | 2021-11-02 | Republic | Kansas | 20157 | 888 | 15 |
1872825 | 1872825 | 2021-11-01 | Republic | Kansas | 20157 | 888 | 15 |
1869576 | 1869576 | 2021-10-31 | Republic | Kansas | 20157 | 888 | 15 |
1866327 | 1866327 | 2021-10-30 | Republic | Kansas | 20157 | 888 | 15 |
1863078 | 1863078 | 2021-10-29 | Republic | Kansas | 20157 | 888 | 15 |
1859829 | 1859829 | 2021-10-28 | Republic | Kansas | 20157 | 887 | 15 |
1856580 | 1856580 | 2021-10-27 | Republic | Kansas | 20157 | 887 | 15 |
1853331 | 1853331 | 2021-10-26 | Republic | Kansas | 20157 | 885 | 15 |
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);