ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Jackson" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175134 | 2175134 | 2022-02-02 | Jackson | Kansas | 20085 | 3749 | 24 |
2171881 | 2171881 | 2022-02-01 | Jackson | Kansas | 20085 | 3723 | 24 |
2168628 | 2168628 | 2022-01-31 | Jackson | Kansas | 20085 | 3723 | 24 |
2165373 | 2165373 | 2022-01-30 | Jackson | Kansas | 20085 | 3692 | 24 |
2162118 | 2162118 | 2022-01-29 | Jackson | Kansas | 20085 | 3692 | 24 |
2158863 | 2158863 | 2022-01-28 | Jackson | Kansas | 20085 | 3692 | 24 |
2155609 | 2155609 | 2022-01-27 | Jackson | Kansas | 20085 | 3644 | 22 |
2152356 | 2152356 | 2022-01-26 | Jackson | Kansas | 20085 | 3644 | 22 |
2149104 | 2149104 | 2022-01-25 | Jackson | Kansas | 20085 | 3547 | 22 |
2145852 | 2145852 | 2022-01-24 | Jackson | Kansas | 20085 | 3547 | 22 |
2142597 | 2142597 | 2022-01-23 | Jackson | Kansas | 20085 | 3486 | 22 |
2139342 | 2139342 | 2022-01-22 | Jackson | Kansas | 20085 | 3486 | 22 |
2136086 | 2136086 | 2022-01-21 | Jackson | Kansas | 20085 | 3486 | 22 |
2132834 | 2132834 | 2022-01-20 | Jackson | Kansas | 20085 | 3389 | 21 |
2129581 | 2129581 | 2022-01-19 | Jackson | Kansas | 20085 | 3389 | 21 |
2126327 | 2126327 | 2022-01-18 | Jackson | Kansas | 20085 | 3178 | 21 |
2123075 | 2123075 | 2022-01-17 | Jackson | Kansas | 20085 | 3178 | 21 |
2119823 | 2119823 | 2022-01-16 | Jackson | Kansas | 20085 | 3178 | 21 |
2116571 | 2116571 | 2022-01-15 | Jackson | Kansas | 20085 | 3178 | 21 |
2113320 | 2113320 | 2022-01-14 | Jackson | Kansas | 20085 | 3178 | 21 |
2110068 | 2110068 | 2022-01-13 | Jackson | Kansas | 20085 | 3060 | 21 |
2106817 | 2106817 | 2022-01-12 | Jackson | Kansas | 20085 | 3060 | 21 |
2103566 | 2103566 | 2022-01-11 | Jackson | Kansas | 20085 | 2950 | 21 |
2100315 | 2100315 | 2022-01-10 | Jackson | Kansas | 20085 | 2950 | 21 |
2097064 | 2097064 | 2022-01-09 | Jackson | Kansas | 20085 | 2892 | 21 |
2093812 | 2093812 | 2022-01-08 | Jackson | Kansas | 20085 | 2892 | 21 |
2090560 | 2090560 | 2022-01-07 | Jackson | Kansas | 20085 | 2892 | 21 |
2087309 | 2087309 | 2022-01-06 | Jackson | Kansas | 20085 | 2816 | 21 |
2084057 | 2084057 | 2022-01-05 | Jackson | Kansas | 20085 | 2816 | 21 |
2080805 | 2080805 | 2022-01-04 | Jackson | Kansas | 20085 | 2731 | 21 |
2077553 | 2077553 | 2022-01-03 | Jackson | Kansas | 20085 | 2731 | 21 |
2074302 | 2074302 | 2022-01-02 | Jackson | Kansas | 20085 | 2672 | 21 |
2071051 | 2071051 | 2022-01-01 | Jackson | Kansas | 20085 | 2672 | 21 |
2067800 | 2067800 | 2021-12-31 | Jackson | Kansas | 20085 | 2672 | 21 |
2064549 | 2064549 | 2021-12-30 | Jackson | Kansas | 20085 | 2672 | 21 |
2061299 | 2061299 | 2021-12-29 | Jackson | Kansas | 20085 | 2672 | 21 |
2058050 | 2058050 | 2021-12-28 | Jackson | Kansas | 20085 | 2632 | 20 |
2054801 | 2054801 | 2021-12-27 | Jackson | Kansas | 20085 | 2632 | 20 |
2051551 | 2051551 | 2021-12-26 | Jackson | Kansas | 20085 | 2603 | 20 |
2048301 | 2048301 | 2021-12-25 | Jackson | Kansas | 20085 | 2603 | 20 |
2045051 | 2045051 | 2021-12-24 | Jackson | Kansas | 20085 | 2603 | 20 |
2041802 | 2041802 | 2021-12-23 | Jackson | Kansas | 20085 | 2603 | 20 |
2038552 | 2038552 | 2021-12-22 | Jackson | Kansas | 20085 | 2603 | 20 |
2035302 | 2035302 | 2021-12-21 | Jackson | Kansas | 20085 | 2575 | 20 |
2032052 | 2032052 | 2021-12-20 | Jackson | Kansas | 20085 | 2575 | 20 |
2028801 | 2028801 | 2021-12-19 | Jackson | Kansas | 20085 | 2564 | 20 |
2025550 | 2025550 | 2021-12-18 | Jackson | Kansas | 20085 | 2564 | 20 |
2022299 | 2022299 | 2021-12-17 | Jackson | Kansas | 20085 | 2564 | 20 |
2019048 | 2019048 | 2021-12-16 | Jackson | Kansas | 20085 | 2538 | 20 |
2015798 | 2015798 | 2021-12-15 | Jackson | Kansas | 20085 | 2538 | 20 |
2012547 | 2012547 | 2021-12-14 | Jackson | Kansas | 20085 | 2508 | 20 |
2009296 | 2009296 | 2021-12-13 | Jackson | Kansas | 20085 | 2508 | 20 |
2006045 | 2006045 | 2021-12-12 | Jackson | Kansas | 20085 | 2495 | 20 |
2002794 | 2002794 | 2021-12-11 | Jackson | Kansas | 20085 | 2495 | 20 |
1999544 | 1999544 | 2021-12-10 | Jackson | Kansas | 20085 | 2495 | 20 |
1996293 | 1996293 | 2021-12-09 | Jackson | Kansas | 20085 | 2468 | 20 |
1993042 | 1993042 | 2021-12-08 | Jackson | Kansas | 20085 | 2468 | 20 |
1989791 | 1989791 | 2021-12-07 | Jackson | Kansas | 20085 | 2429 | 20 |
1986541 | 1986541 | 2021-12-06 | Jackson | Kansas | 20085 | 2429 | 20 |
1983291 | 1983291 | 2021-12-05 | Jackson | Kansas | 20085 | 2410 | 20 |
1980041 | 1980041 | 2021-12-04 | Jackson | Kansas | 20085 | 2410 | 20 |
1976791 | 1976791 | 2021-12-03 | Jackson | Kansas | 20085 | 2410 | 20 |
1973542 | 1973542 | 2021-12-02 | Jackson | Kansas | 20085 | 2361 | 20 |
1970292 | 1970292 | 2021-12-01 | Jackson | Kansas | 20085 | 2361 | 20 |
1967042 | 1967042 | 2021-11-30 | Jackson | Kansas | 20085 | 2331 | 20 |
1963790 | 1963790 | 2021-11-29 | Jackson | Kansas | 20085 | 2331 | 20 |
1960539 | 1960539 | 2021-11-28 | Jackson | Kansas | 20085 | 2305 | 20 |
1957288 | 1957288 | 2021-11-27 | Jackson | Kansas | 20085 | 2305 | 20 |
1954037 | 1954037 | 2021-11-26 | Jackson | Kansas | 20085 | 2305 | 20 |
1950786 | 1950786 | 2021-11-25 | Jackson | Kansas | 20085 | 2305 | 20 |
1947535 | 1947535 | 2021-11-24 | Jackson | Kansas | 20085 | 2305 | 20 |
1944284 | 1944284 | 2021-11-23 | Jackson | Kansas | 20085 | 2283 | 20 |
1941034 | 1941034 | 2021-11-22 | Jackson | Kansas | 20085 | 2283 | 20 |
1937784 | 1937784 | 2021-11-21 | Jackson | Kansas | 20085 | 2266 | 20 |
1934534 | 1934534 | 2021-11-20 | Jackson | Kansas | 20085 | 2266 | 20 |
1931283 | 1931283 | 2021-11-19 | Jackson | Kansas | 20085 | 2266 | 20 |
1928032 | 1928032 | 2021-11-18 | Jackson | Kansas | 20085 | 2245 | 20 |
1924782 | 1924782 | 2021-11-17 | Jackson | Kansas | 20085 | 2245 | 20 |
1921533 | 1921533 | 2021-11-16 | Jackson | Kansas | 20085 | 2220 | 20 |
1918283 | 1918283 | 2021-11-15 | Jackson | Kansas | 20085 | 2220 | 20 |
1915033 | 1915033 | 2021-11-14 | Jackson | Kansas | 20085 | 2198 | 20 |
1911783 | 1911783 | 2021-11-13 | Jackson | Kansas | 20085 | 2198 | 20 |
1908534 | 1908534 | 2021-11-12 | Jackson | Kansas | 20085 | 2198 | 20 |
1905285 | 1905285 | 2021-11-11 | Jackson | Kansas | 20085 | 2181 | 20 |
1902035 | 1902035 | 2021-11-10 | Jackson | Kansas | 20085 | 2181 | 20 |
1898785 | 1898785 | 2021-11-09 | Jackson | Kansas | 20085 | 2151 | 19 |
1895535 | 1895535 | 2021-11-08 | Jackson | Kansas | 20085 | 2151 | 19 |
1892285 | 1892285 | 2021-11-07 | Jackson | Kansas | 20085 | 2129 | 19 |
1889035 | 1889035 | 2021-11-06 | Jackson | Kansas | 20085 | 2129 | 19 |
1885785 | 1885785 | 2021-11-05 | Jackson | Kansas | 20085 | 2129 | 19 |
1882536 | 1882536 | 2021-11-04 | Jackson | Kansas | 20085 | 2098 | 19 |
1879287 | 1879287 | 2021-11-03 | Jackson | Kansas | 20085 | 2098 | 19 |
1876038 | 1876038 | 2021-11-02 | Jackson | Kansas | 20085 | 2068 | 19 |
1872789 | 1872789 | 2021-11-01 | Jackson | Kansas | 20085 | 2068 | 19 |
1869540 | 1869540 | 2021-10-31 | Jackson | Kansas | 20085 | 2051 | 19 |
1866291 | 1866291 | 2021-10-30 | Jackson | Kansas | 20085 | 2051 | 19 |
1863042 | 1863042 | 2021-10-29 | Jackson | Kansas | 20085 | 2051 | 19 |
1859793 | 1859793 | 2021-10-28 | Jackson | Kansas | 20085 | 2029 | 19 |
1856544 | 1856544 | 2021-10-27 | Jackson | Kansas | 20085 | 2029 | 19 |
1853295 | 1853295 | 2021-10-26 | Jackson | Kansas | 20085 | 1987 | 19 |
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);