ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Pottawatomie" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175166 | 2175166 | 2022-02-02 | Pottawatomie | Kansas | 20149 | 5420 | 51 |
2171913 | 2171913 | 2022-02-01 | Pottawatomie | Kansas | 20149 | 5334 | 51 |
2168660 | 2168660 | 2022-01-31 | Pottawatomie | Kansas | 20149 | 5334 | 51 |
2165405 | 2165405 | 2022-01-30 | Pottawatomie | Kansas | 20149 | 5271 | 51 |
2162150 | 2162150 | 2022-01-29 | Pottawatomie | Kansas | 20149 | 5271 | 51 |
2158895 | 2158895 | 2022-01-28 | Pottawatomie | Kansas | 20149 | 5271 | 51 |
2155641 | 2155641 | 2022-01-27 | Pottawatomie | Kansas | 20149 | 5164 | 51 |
2152388 | 2152388 | 2022-01-26 | Pottawatomie | Kansas | 20149 | 5164 | 51 |
2149136 | 2149136 | 2022-01-25 | Pottawatomie | Kansas | 20149 | 5033 | 50 |
2145884 | 2145884 | 2022-01-24 | Pottawatomie | Kansas | 20149 | 5033 | 50 |
2142629 | 2142629 | 2022-01-23 | Pottawatomie | Kansas | 20149 | 4949 | 50 |
2139374 | 2139374 | 2022-01-22 | Pottawatomie | Kansas | 20149 | 4949 | 50 |
2136118 | 2136118 | 2022-01-21 | Pottawatomie | Kansas | 20149 | 4949 | 50 |
2132866 | 2132866 | 2022-01-20 | Pottawatomie | Kansas | 20149 | 4801 | 50 |
2129613 | 2129613 | 2022-01-19 | Pottawatomie | Kansas | 20149 | 4801 | 50 |
2126359 | 2126359 | 2022-01-18 | Pottawatomie | Kansas | 20149 | 4451 | 48 |
2123107 | 2123107 | 2022-01-17 | Pottawatomie | Kansas | 20149 | 4451 | 48 |
2119855 | 2119855 | 2022-01-16 | Pottawatomie | Kansas | 20149 | 4451 | 48 |
2116603 | 2116603 | 2022-01-15 | Pottawatomie | Kansas | 20149 | 4451 | 48 |
2113352 | 2113352 | 2022-01-14 | Pottawatomie | Kansas | 20149 | 4451 | 48 |
2110100 | 2110100 | 2022-01-13 | Pottawatomie | Kansas | 20149 | 4228 | 48 |
2106849 | 2106849 | 2022-01-12 | Pottawatomie | Kansas | 20149 | 4228 | 48 |
2103598 | 2103598 | 2022-01-11 | Pottawatomie | Kansas | 20149 | 4022 | 48 |
2100347 | 2100347 | 2022-01-10 | Pottawatomie | Kansas | 20149 | 4022 | 48 |
2097096 | 2097096 | 2022-01-09 | Pottawatomie | Kansas | 20149 | 3942 | 48 |
2093844 | 2093844 | 2022-01-08 | Pottawatomie | Kansas | 20149 | 3942 | 48 |
2090592 | 2090592 | 2022-01-07 | Pottawatomie | Kansas | 20149 | 3942 | 48 |
2087341 | 2087341 | 2022-01-06 | Pottawatomie | Kansas | 20149 | 3839 | 47 |
2084089 | 2084089 | 2022-01-05 | Pottawatomie | Kansas | 20149 | 3839 | 47 |
2080837 | 2080837 | 2022-01-04 | Pottawatomie | Kansas | 20149 | 3739 | 47 |
2077585 | 2077585 | 2022-01-03 | Pottawatomie | Kansas | 20149 | 3739 | 47 |
2074334 | 2074334 | 2022-01-02 | Pottawatomie | Kansas | 20149 | 3644 | 47 |
2071083 | 2071083 | 2022-01-01 | Pottawatomie | Kansas | 20149 | 3644 | 47 |
2067832 | 2067832 | 2021-12-31 | Pottawatomie | Kansas | 20149 | 3644 | 47 |
2064581 | 2064581 | 2021-12-30 | Pottawatomie | Kansas | 20149 | 3644 | 47 |
2061331 | 2061331 | 2021-12-29 | Pottawatomie | Kansas | 20149 | 3644 | 47 |
2058082 | 2058082 | 2021-12-28 | Pottawatomie | Kansas | 20149 | 3589 | 47 |
2054833 | 2054833 | 2021-12-27 | Pottawatomie | Kansas | 20149 | 3589 | 47 |
2051583 | 2051583 | 2021-12-26 | Pottawatomie | Kansas | 20149 | 3539 | 47 |
2048333 | 2048333 | 2021-12-25 | Pottawatomie | Kansas | 20149 | 3539 | 47 |
2045083 | 2045083 | 2021-12-24 | Pottawatomie | Kansas | 20149 | 3539 | 47 |
2041834 | 2041834 | 2021-12-23 | Pottawatomie | Kansas | 20149 | 3539 | 47 |
2038584 | 2038584 | 2021-12-22 | Pottawatomie | Kansas | 20149 | 3539 | 47 |
2035334 | 2035334 | 2021-12-21 | Pottawatomie | Kansas | 20149 | 3487 | 47 |
2032084 | 2032084 | 2021-12-20 | Pottawatomie | Kansas | 20149 | 3487 | 47 |
2028833 | 2028833 | 2021-12-19 | Pottawatomie | Kansas | 20149 | 3464 | 47 |
2025582 | 2025582 | 2021-12-18 | Pottawatomie | Kansas | 20149 | 3464 | 47 |
2022331 | 2022331 | 2021-12-17 | Pottawatomie | Kansas | 20149 | 3464 | 47 |
2019080 | 2019080 | 2021-12-16 | Pottawatomie | Kansas | 20149 | 3412 | 47 |
2015830 | 2015830 | 2021-12-15 | Pottawatomie | Kansas | 20149 | 3412 | 47 |
2012579 | 2012579 | 2021-12-14 | Pottawatomie | Kansas | 20149 | 3375 | 47 |
2009328 | 2009328 | 2021-12-13 | Pottawatomie | Kansas | 20149 | 3375 | 47 |
2006077 | 2006077 | 2021-12-12 | Pottawatomie | Kansas | 20149 | 3337 | 47 |
2002826 | 2002826 | 2021-12-11 | Pottawatomie | Kansas | 20149 | 3337 | 47 |
1999576 | 1999576 | 2021-12-10 | Pottawatomie | Kansas | 20149 | 3337 | 47 |
1996325 | 1996325 | 2021-12-09 | Pottawatomie | Kansas | 20149 | 3276 | 45 |
1993074 | 1993074 | 2021-12-08 | Pottawatomie | Kansas | 20149 | 3276 | 45 |
1989823 | 1989823 | 2021-12-07 | Pottawatomie | Kansas | 20149 | 3236 | 45 |
1986573 | 1986573 | 2021-12-06 | Pottawatomie | Kansas | 20149 | 3236 | 45 |
1983323 | 1983323 | 2021-12-05 | Pottawatomie | Kansas | 20149 | 3208 | 44 |
1980073 | 1980073 | 2021-12-04 | Pottawatomie | Kansas | 20149 | 3208 | 44 |
1976823 | 1976823 | 2021-12-03 | Pottawatomie | Kansas | 20149 | 3208 | 44 |
1973574 | 1973574 | 2021-12-02 | Pottawatomie | Kansas | 20149 | 3178 | 44 |
1970324 | 1970324 | 2021-12-01 | Pottawatomie | Kansas | 20149 | 3178 | 44 |
1967074 | 1967074 | 2021-11-30 | Pottawatomie | Kansas | 20149 | 3155 | 44 |
1963822 | 1963822 | 2021-11-29 | Pottawatomie | Kansas | 20149 | 3155 | 44 |
1960571 | 1960571 | 2021-11-28 | Pottawatomie | Kansas | 20149 | 3120 | 44 |
1957320 | 1957320 | 2021-11-27 | Pottawatomie | Kansas | 20149 | 3120 | 44 |
1954069 | 1954069 | 2021-11-26 | Pottawatomie | Kansas | 20149 | 3120 | 44 |
1950818 | 1950818 | 2021-11-25 | Pottawatomie | Kansas | 20149 | 3120 | 44 |
1947567 | 1947567 | 2021-11-24 | Pottawatomie | Kansas | 20149 | 3120 | 44 |
1944316 | 1944316 | 2021-11-23 | Pottawatomie | Kansas | 20149 | 3084 | 44 |
1941066 | 1941066 | 2021-11-22 | Pottawatomie | Kansas | 20149 | 3084 | 44 |
1937816 | 1937816 | 2021-11-21 | Pottawatomie | Kansas | 20149 | 3056 | 44 |
1934566 | 1934566 | 2021-11-20 | Pottawatomie | Kansas | 20149 | 3056 | 44 |
1931315 | 1931315 | 2021-11-19 | Pottawatomie | Kansas | 20149 | 3056 | 44 |
1928064 | 1928064 | 2021-11-18 | Pottawatomie | Kansas | 20149 | 3034 | 44 |
1924814 | 1924814 | 2021-11-17 | Pottawatomie | Kansas | 20149 | 3034 | 44 |
1921565 | 1921565 | 2021-11-16 | Pottawatomie | Kansas | 20149 | 2979 | 44 |
1918315 | 1918315 | 2021-11-15 | Pottawatomie | Kansas | 20149 | 2979 | 44 |
1915065 | 1915065 | 2021-11-14 | Pottawatomie | Kansas | 20149 | 2964 | 44 |
1911815 | 1911815 | 2021-11-13 | Pottawatomie | Kansas | 20149 | 2964 | 44 |
1908566 | 1908566 | 2021-11-12 | Pottawatomie | Kansas | 20149 | 2964 | 44 |
1905317 | 1905317 | 2021-11-11 | Pottawatomie | Kansas | 20149 | 2935 | 44 |
1902067 | 1902067 | 2021-11-10 | Pottawatomie | Kansas | 20149 | 2935 | 44 |
1898817 | 1898817 | 2021-11-09 | Pottawatomie | Kansas | 20149 | 2889 | 43 |
1895567 | 1895567 | 2021-11-08 | Pottawatomie | Kansas | 20149 | 2889 | 43 |
1892317 | 1892317 | 2021-11-07 | Pottawatomie | Kansas | 20149 | 2869 | 42 |
1889067 | 1889067 | 2021-11-06 | Pottawatomie | Kansas | 20149 | 2869 | 42 |
1885817 | 1885817 | 2021-11-05 | Pottawatomie | Kansas | 20149 | 2869 | 42 |
1882568 | 1882568 | 2021-11-04 | Pottawatomie | Kansas | 20149 | 2849 | 42 |
1879319 | 1879319 | 2021-11-03 | Pottawatomie | Kansas | 20149 | 2849 | 42 |
1876070 | 1876070 | 2021-11-02 | Pottawatomie | Kansas | 20149 | 2830 | 42 |
1872821 | 1872821 | 2021-11-01 | Pottawatomie | Kansas | 20149 | 2830 | 42 |
1869572 | 1869572 | 2021-10-31 | Pottawatomie | Kansas | 20149 | 2827 | 42 |
1866323 | 1866323 | 2021-10-30 | Pottawatomie | Kansas | 20149 | 2827 | 42 |
1863074 | 1863074 | 2021-10-29 | Pottawatomie | Kansas | 20149 | 2827 | 42 |
1859825 | 1859825 | 2021-10-28 | Pottawatomie | Kansas | 20149 | 2809 | 42 |
1856576 | 1856576 | 2021-10-27 | Pottawatomie | Kansas | 20149 | 2809 | 42 |
1853327 | 1853327 | 2021-10-26 | Pottawatomie | Kansas | 20149 | 2791 | 42 |
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);