ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
689 rows where county = "Marshall" and fips = 20117 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175149 | 2175149 | 2022-02-02 | Marshall | Kansas | 20117 | 2479 | 39 |
2171896 | 2171896 | 2022-02-01 | Marshall | Kansas | 20117 | 2448 | 39 |
2168643 | 2168643 | 2022-01-31 | Marshall | Kansas | 20117 | 2448 | 39 |
2165388 | 2165388 | 2022-01-30 | Marshall | Kansas | 20117 | 2432 | 39 |
2162133 | 2162133 | 2022-01-29 | Marshall | Kansas | 20117 | 2432 | 39 |
2158878 | 2158878 | 2022-01-28 | Marshall | Kansas | 20117 | 2432 | 39 |
2155624 | 2155624 | 2022-01-27 | Marshall | Kansas | 20117 | 2409 | 39 |
2152371 | 2152371 | 2022-01-26 | Marshall | Kansas | 20117 | 2409 | 39 |
2149119 | 2149119 | 2022-01-25 | Marshall | Kansas | 20117 | 2369 | 39 |
2145867 | 2145867 | 2022-01-24 | Marshall | Kansas | 20117 | 2369 | 39 |
2142612 | 2142612 | 2022-01-23 | Marshall | Kansas | 20117 | 2342 | 38 |
2139357 | 2139357 | 2022-01-22 | Marshall | Kansas | 20117 | 2342 | 38 |
2136101 | 2136101 | 2022-01-21 | Marshall | Kansas | 20117 | 2342 | 38 |
2132849 | 2132849 | 2022-01-20 | Marshall | Kansas | 20117 | 2294 | 38 |
2129596 | 2129596 | 2022-01-19 | Marshall | Kansas | 20117 | 2294 | 38 |
2126342 | 2126342 | 2022-01-18 | Marshall | Kansas | 20117 | 2188 | 37 |
2123090 | 2123090 | 2022-01-17 | Marshall | Kansas | 20117 | 2188 | 37 |
2119838 | 2119838 | 2022-01-16 | Marshall | Kansas | 20117 | 2188 | 37 |
2116586 | 2116586 | 2022-01-15 | Marshall | Kansas | 20117 | 2188 | 37 |
2113335 | 2113335 | 2022-01-14 | Marshall | Kansas | 20117 | 2188 | 37 |
2110083 | 2110083 | 2022-01-13 | Marshall | Kansas | 20117 | 2140 | 37 |
2106832 | 2106832 | 2022-01-12 | Marshall | Kansas | 20117 | 2140 | 37 |
2103581 | 2103581 | 2022-01-11 | Marshall | Kansas | 20117 | 2089 | 37 |
2100330 | 2100330 | 2022-01-10 | Marshall | Kansas | 20117 | 2089 | 37 |
2097079 | 2097079 | 2022-01-09 | Marshall | Kansas | 20117 | 2059 | 37 |
2093827 | 2093827 | 2022-01-08 | Marshall | Kansas | 20117 | 2059 | 37 |
2090575 | 2090575 | 2022-01-07 | Marshall | Kansas | 20117 | 2059 | 37 |
2087324 | 2087324 | 2022-01-06 | Marshall | Kansas | 20117 | 2026 | 37 |
2084072 | 2084072 | 2022-01-05 | Marshall | Kansas | 20117 | 2026 | 37 |
2080820 | 2080820 | 2022-01-04 | Marshall | Kansas | 20117 | 1998 | 37 |
2077568 | 2077568 | 2022-01-03 | Marshall | Kansas | 20117 | 1998 | 37 |
2074317 | 2074317 | 2022-01-02 | Marshall | Kansas | 20117 | 1972 | 37 |
2071066 | 2071066 | 2022-01-01 | Marshall | Kansas | 20117 | 1972 | 37 |
2067815 | 2067815 | 2021-12-31 | Marshall | Kansas | 20117 | 1972 | 37 |
2064564 | 2064564 | 2021-12-30 | Marshall | Kansas | 20117 | 1972 | 37 |
2061314 | 2061314 | 2021-12-29 | Marshall | Kansas | 20117 | 1972 | 37 |
2058065 | 2058065 | 2021-12-28 | Marshall | Kansas | 20117 | 1957 | 37 |
2054816 | 2054816 | 2021-12-27 | Marshall | Kansas | 20117 | 1957 | 37 |
2051566 | 2051566 | 2021-12-26 | Marshall | Kansas | 20117 | 1951 | 37 |
2048316 | 2048316 | 2021-12-25 | Marshall | Kansas | 20117 | 1951 | 37 |
2045066 | 2045066 | 2021-12-24 | Marshall | Kansas | 20117 | 1951 | 37 |
2041817 | 2041817 | 2021-12-23 | Marshall | Kansas | 20117 | 1951 | 37 |
2038567 | 2038567 | 2021-12-22 | Marshall | Kansas | 20117 | 1951 | 37 |
2035317 | 2035317 | 2021-12-21 | Marshall | Kansas | 20117 | 1934 | 36 |
2032067 | 2032067 | 2021-12-20 | Marshall | Kansas | 20117 | 1934 | 36 |
2028816 | 2028816 | 2021-12-19 | Marshall | Kansas | 20117 | 1931 | 35 |
2025565 | 2025565 | 2021-12-18 | Marshall | Kansas | 20117 | 1931 | 35 |
2022314 | 2022314 | 2021-12-17 | Marshall | Kansas | 20117 | 1931 | 35 |
2019063 | 2019063 | 2021-12-16 | Marshall | Kansas | 20117 | 1912 | 34 |
2015813 | 2015813 | 2021-12-15 | Marshall | Kansas | 20117 | 1912 | 34 |
2012562 | 2012562 | 2021-12-14 | Marshall | Kansas | 20117 | 1898 | 34 |
2009311 | 2009311 | 2021-12-13 | Marshall | Kansas | 20117 | 1898 | 34 |
2006060 | 2006060 | 2021-12-12 | Marshall | Kansas | 20117 | 1889 | 34 |
2002809 | 2002809 | 2021-12-11 | Marshall | Kansas | 20117 | 1889 | 34 |
1999559 | 1999559 | 2021-12-10 | Marshall | Kansas | 20117 | 1889 | 34 |
1996308 | 1996308 | 2021-12-09 | Marshall | Kansas | 20117 | 1877 | 33 |
1993057 | 1993057 | 2021-12-08 | Marshall | Kansas | 20117 | 1877 | 33 |
1989806 | 1989806 | 2021-12-07 | Marshall | Kansas | 20117 | 1843 | 33 |
1986556 | 1986556 | 2021-12-06 | Marshall | Kansas | 20117 | 1843 | 33 |
1983306 | 1983306 | 2021-12-05 | Marshall | Kansas | 20117 | 1834 | 33 |
1980056 | 1980056 | 2021-12-04 | Marshall | Kansas | 20117 | 1834 | 33 |
1976806 | 1976806 | 2021-12-03 | Marshall | Kansas | 20117 | 1834 | 33 |
1973557 | 1973557 | 2021-12-02 | Marshall | Kansas | 20117 | 1781 | 32 |
1970307 | 1970307 | 2021-12-01 | Marshall | Kansas | 20117 | 1781 | 32 |
1967057 | 1967057 | 2021-11-30 | Marshall | Kansas | 20117 | 1728 | 32 |
1963805 | 1963805 | 2021-11-29 | Marshall | Kansas | 20117 | 1728 | 32 |
1960554 | 1960554 | 2021-11-28 | Marshall | Kansas | 20117 | 1690 | 32 |
1957303 | 1957303 | 2021-11-27 | Marshall | Kansas | 20117 | 1690 | 32 |
1954052 | 1954052 | 2021-11-26 | Marshall | Kansas | 20117 | 1690 | 32 |
1950801 | 1950801 | 2021-11-25 | Marshall | Kansas | 20117 | 1690 | 32 |
1947550 | 1947550 | 2021-11-24 | Marshall | Kansas | 20117 | 1690 | 32 |
1944299 | 1944299 | 2021-11-23 | Marshall | Kansas | 20117 | 1654 | 32 |
1941049 | 1941049 | 2021-11-22 | Marshall | Kansas | 20117 | 1654 | 32 |
1937799 | 1937799 | 2021-11-21 | Marshall | Kansas | 20117 | 1636 | 32 |
1934549 | 1934549 | 2021-11-20 | Marshall | Kansas | 20117 | 1636 | 32 |
1931298 | 1931298 | 2021-11-19 | Marshall | Kansas | 20117 | 1636 | 32 |
1928047 | 1928047 | 2021-11-18 | Marshall | Kansas | 20117 | 1621 | 32 |
1924797 | 1924797 | 2021-11-17 | Marshall | Kansas | 20117 | 1621 | 32 |
1921548 | 1921548 | 2021-11-16 | Marshall | Kansas | 20117 | 1592 | 32 |
1918298 | 1918298 | 2021-11-15 | Marshall | Kansas | 20117 | 1592 | 32 |
1915048 | 1915048 | 2021-11-14 | Marshall | Kansas | 20117 | 1574 | 32 |
1911798 | 1911798 | 2021-11-13 | Marshall | Kansas | 20117 | 1574 | 32 |
1908549 | 1908549 | 2021-11-12 | Marshall | Kansas | 20117 | 1574 | 32 |
1905300 | 1905300 | 2021-11-11 | Marshall | Kansas | 20117 | 1557 | 32 |
1902050 | 1902050 | 2021-11-10 | Marshall | Kansas | 20117 | 1557 | 32 |
1898800 | 1898800 | 2021-11-09 | Marshall | Kansas | 20117 | 1529 | 31 |
1895550 | 1895550 | 2021-11-08 | Marshall | Kansas | 20117 | 1529 | 31 |
1892300 | 1892300 | 2021-11-07 | Marshall | Kansas | 20117 | 1517 | 31 |
1889050 | 1889050 | 2021-11-06 | Marshall | Kansas | 20117 | 1517 | 31 |
1885800 | 1885800 | 2021-11-05 | Marshall | Kansas | 20117 | 1517 | 31 |
1882551 | 1882551 | 2021-11-04 | Marshall | Kansas | 20117 | 1495 | 31 |
1879302 | 1879302 | 2021-11-03 | Marshall | Kansas | 20117 | 1495 | 31 |
1876053 | 1876053 | 2021-11-02 | Marshall | Kansas | 20117 | 1466 | 30 |
1872804 | 1872804 | 2021-11-01 | Marshall | Kansas | 20117 | 1466 | 30 |
1869555 | 1869555 | 2021-10-31 | Marshall | Kansas | 20117 | 1463 | 30 |
1866306 | 1866306 | 2021-10-30 | Marshall | Kansas | 20117 | 1463 | 30 |
1863057 | 1863057 | 2021-10-29 | Marshall | Kansas | 20117 | 1463 | 30 |
1859808 | 1859808 | 2021-10-28 | Marshall | Kansas | 20117 | 1453 | 30 |
1856559 | 1856559 | 2021-10-27 | Marshall | Kansas | 20117 | 1453 | 30 |
1853310 | 1853310 | 2021-10-26 | Marshall | Kansas | 20117 | 1451 | 28 |
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);