ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where county = "Marion" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2155623 | 2155623 | 2022-01-27 | Marion | Kansas | 20115 | 3088 | 38 |
2152370 | 2152370 | 2022-01-26 | Marion | Kansas | 20115 | 3088 | 38 |
2149118 | 2149118 | 2022-01-25 | Marion | Kansas | 20115 | 3017 | 38 |
2145866 | 2145866 | 2022-01-24 | Marion | Kansas | 20115 | 3017 | 38 |
2142611 | 2142611 | 2022-01-23 | Marion | Kansas | 20115 | 2964 | 38 |
2139356 | 2139356 | 2022-01-22 | Marion | Kansas | 20115 | 2964 | 38 |
2136100 | 2136100 | 2022-01-21 | Marion | Kansas | 20115 | 2964 | 38 |
2132848 | 2132848 | 2022-01-20 | Marion | Kansas | 20115 | 2845 | 38 |
2129595 | 2129595 | 2022-01-19 | Marion | Kansas | 20115 | 2845 | 38 |
2126341 | 2126341 | 2022-01-18 | Marion | Kansas | 20115 | 2624 | 36 |
2123089 | 2123089 | 2022-01-17 | Marion | Kansas | 20115 | 2624 | 36 |
2119837 | 2119837 | 2022-01-16 | Marion | Kansas | 20115 | 2624 | 36 |
2116585 | 2116585 | 2022-01-15 | Marion | Kansas | 20115 | 2624 | 36 |
2113334 | 2113334 | 2022-01-14 | Marion | Kansas | 20115 | 2624 | 36 |
2110082 | 2110082 | 2022-01-13 | Marion | Kansas | 20115 | 2536 | 36 |
2106831 | 2106831 | 2022-01-12 | Marion | Kansas | 20115 | 2536 | 36 |
2103580 | 2103580 | 2022-01-11 | Marion | Kansas | 20115 | 2419 | 36 |
2100329 | 2100329 | 2022-01-10 | Marion | Kansas | 20115 | 2419 | 36 |
2097078 | 2097078 | 2022-01-09 | Marion | Kansas | 20115 | 2389 | 36 |
2093826 | 2093826 | 2022-01-08 | Marion | Kansas | 20115 | 2389 | 36 |
2090574 | 2090574 | 2022-01-07 | Marion | Kansas | 20115 | 2389 | 36 |
2087323 | 2087323 | 2022-01-06 | Marion | Kansas | 20115 | 2350 | 35 |
2084071 | 2084071 | 2022-01-05 | Marion | Kansas | 20115 | 2350 | 35 |
2080819 | 2080819 | 2022-01-04 | Marion | Kansas | 20115 | 2277 | 35 |
2077567 | 2077567 | 2022-01-03 | Marion | Kansas | 20115 | 2277 | 35 |
2074316 | 2074316 | 2022-01-02 | Marion | Kansas | 20115 | 2226 | 35 |
2071065 | 2071065 | 2022-01-01 | Marion | Kansas | 20115 | 2226 | 35 |
2067814 | 2067814 | 2021-12-31 | Marion | Kansas | 20115 | 2226 | 35 |
2064563 | 2064563 | 2021-12-30 | Marion | Kansas | 20115 | 2226 | 35 |
2061313 | 2061313 | 2021-12-29 | Marion | Kansas | 20115 | 2226 | 35 |
2058064 | 2058064 | 2021-12-28 | Marion | Kansas | 20115 | 2198 | 35 |
2054815 | 2054815 | 2021-12-27 | Marion | Kansas | 20115 | 2198 | 35 |
2051565 | 2051565 | 2021-12-26 | Marion | Kansas | 20115 | 2152 | 35 |
2048315 | 2048315 | 2021-12-25 | Marion | Kansas | 20115 | 2152 | 35 |
2045065 | 2045065 | 2021-12-24 | Marion | Kansas | 20115 | 2152 | 35 |
2041816 | 2041816 | 2021-12-23 | Marion | Kansas | 20115 | 2152 | 35 |
2038566 | 2038566 | 2021-12-22 | Marion | Kansas | 20115 | 2152 | 35 |
2035316 | 2035316 | 2021-12-21 | Marion | Kansas | 20115 | 2118 | 35 |
2032066 | 2032066 | 2021-12-20 | Marion | Kansas | 20115 | 2118 | 35 |
2028815 | 2028815 | 2021-12-19 | Marion | Kansas | 20115 | 2095 | 35 |
2025564 | 2025564 | 2021-12-18 | Marion | Kansas | 20115 | 2095 | 35 |
2022313 | 2022313 | 2021-12-17 | Marion | Kansas | 20115 | 2095 | 35 |
2019062 | 2019062 | 2021-12-16 | Marion | Kansas | 20115 | 2072 | 35 |
2015812 | 2015812 | 2021-12-15 | Marion | Kansas | 20115 | 2072 | 35 |
2012561 | 2012561 | 2021-12-14 | Marion | Kansas | 20115 | 2048 | 35 |
2009310 | 2009310 | 2021-12-13 | Marion | Kansas | 20115 | 2048 | 35 |
2006059 | 2006059 | 2021-12-12 | Marion | Kansas | 20115 | 2025 | 35 |
2002808 | 2002808 | 2021-12-11 | Marion | Kansas | 20115 | 2025 | 35 |
1999558 | 1999558 | 2021-12-10 | Marion | Kansas | 20115 | 2025 | 35 |
1996307 | 1996307 | 2021-12-09 | Marion | Kansas | 20115 | 1997 | 35 |
1993056 | 1993056 | 2021-12-08 | Marion | Kansas | 20115 | 1997 | 35 |
1989805 | 1989805 | 2021-12-07 | Marion | Kansas | 20115 | 1976 | 35 |
1986555 | 1986555 | 2021-12-06 | Marion | Kansas | 20115 | 1976 | 35 |
1983305 | 1983305 | 2021-12-05 | Marion | Kansas | 20115 | 1963 | 35 |
1980055 | 1980055 | 2021-12-04 | Marion | Kansas | 20115 | 1963 | 35 |
1976805 | 1976805 | 2021-12-03 | Marion | Kansas | 20115 | 1963 | 35 |
1973556 | 1973556 | 2021-12-02 | Marion | Kansas | 20115 | 1939 | 35 |
1970306 | 1970306 | 2021-12-01 | Marion | Kansas | 20115 | 1939 | 35 |
1967056 | 1967056 | 2021-11-30 | Marion | Kansas | 20115 | 1897 | 35 |
1963804 | 1963804 | 2021-11-29 | Marion | Kansas | 20115 | 1897 | 35 |
1960553 | 1960553 | 2021-11-28 | Marion | Kansas | 20115 | 1875 | 35 |
1957302 | 1957302 | 2021-11-27 | Marion | Kansas | 20115 | 1875 | 35 |
1954051 | 1954051 | 2021-11-26 | Marion | Kansas | 20115 | 1875 | 35 |
1950800 | 1950800 | 2021-11-25 | Marion | Kansas | 20115 | 1875 | 35 |
1947549 | 1947549 | 2021-11-24 | Marion | Kansas | 20115 | 1875 | 35 |
1944298 | 1944298 | 2021-11-23 | Marion | Kansas | 20115 | 1863 | 35 |
1941048 | 1941048 | 2021-11-22 | Marion | Kansas | 20115 | 1863 | 35 |
1937798 | 1937798 | 2021-11-21 | Marion | Kansas | 20115 | 1855 | 35 |
1934548 | 1934548 | 2021-11-20 | Marion | Kansas | 20115 | 1855 | 35 |
1931297 | 1931297 | 2021-11-19 | Marion | Kansas | 20115 | 1855 | 35 |
1928046 | 1928046 | 2021-11-18 | Marion | Kansas | 20115 | 1832 | 35 |
1924796 | 1924796 | 2021-11-17 | Marion | Kansas | 20115 | 1832 | 35 |
1921547 | 1921547 | 2021-11-16 | Marion | Kansas | 20115 | 1817 | 35 |
1918297 | 1918297 | 2021-11-15 | Marion | Kansas | 20115 | 1817 | 35 |
1915047 | 1915047 | 2021-11-14 | Marion | Kansas | 20115 | 1802 | 35 |
1911797 | 1911797 | 2021-11-13 | Marion | Kansas | 20115 | 1802 | 35 |
1908548 | 1908548 | 2021-11-12 | Marion | Kansas | 20115 | 1802 | 35 |
1905299 | 1905299 | 2021-11-11 | Marion | Kansas | 20115 | 1766 | 35 |
1902049 | 1902049 | 2021-11-10 | Marion | Kansas | 20115 | 1766 | 35 |
1898799 | 1898799 | 2021-11-09 | Marion | Kansas | 20115 | 1734 | 34 |
1895549 | 1895549 | 2021-11-08 | Marion | Kansas | 20115 | 1734 | 34 |
1892299 | 1892299 | 2021-11-07 | Marion | Kansas | 20115 | 1715 | 33 |
1889049 | 1889049 | 2021-11-06 | Marion | Kansas | 20115 | 1715 | 33 |
1885799 | 1885799 | 2021-11-05 | Marion | Kansas | 20115 | 1715 | 33 |
1882550 | 1882550 | 2021-11-04 | Marion | Kansas | 20115 | 1688 | 31 |
1879301 | 1879301 | 2021-11-03 | Marion | Kansas | 20115 | 1688 | 31 |
1876052 | 1876052 | 2021-11-02 | Marion | Kansas | 20115 | 1661 | 30 |
1872803 | 1872803 | 2021-11-01 | Marion | Kansas | 20115 | 1661 | 30 |
1869554 | 1869554 | 2021-10-31 | Marion | Kansas | 20115 | 1653 | 30 |
1866305 | 1866305 | 2021-10-30 | Marion | Kansas | 20115 | 1653 | 30 |
1863056 | 1863056 | 2021-10-29 | Marion | Kansas | 20115 | 1653 | 30 |
1859807 | 1859807 | 2021-10-28 | Marion | Kansas | 20115 | 1635 | 29 |
1856558 | 1856558 | 2021-10-27 | Marion | Kansas | 20115 | 1635 | 29 |
1853309 | 1853309 | 2021-10-26 | Marion | Kansas | 20115 | 1617 | 30 |
1850060 | 1850060 | 2021-10-25 | Marion | Kansas | 20115 | 1617 | 30 |
1846810 | 1846810 | 2021-10-24 | Marion | Kansas | 20115 | 1600 | 29 |
1843560 | 1843560 | 2021-10-23 | Marion | Kansas | 20115 | 1600 | 29 |
1840310 | 1840310 | 2021-10-22 | Marion | Kansas | 20115 | 1600 | 29 |
1837061 | 1837061 | 2021-10-21 | Marion | Kansas | 20115 | 1582 | 27 |
1833812 | 1833812 | 2021-10-20 | Marion | Kansas | 20115 | 1582 | 27 |
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);