ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
715 rows where county = "Franklin" and fips = 16041 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174773 | 2174773 | 2022-02-02 | Franklin | Idaho | 16041 | 2180 | 27 |
2171520 | 2171520 | 2022-02-01 | Franklin | Idaho | 16041 | 2173 | 27 |
2168267 | 2168267 | 2022-01-31 | Franklin | Idaho | 16041 | 2172 | 27 |
2165012 | 2165012 | 2022-01-30 | Franklin | Idaho | 16041 | 2159 | 27 |
2161757 | 2161757 | 2022-01-29 | Franklin | Idaho | 16041 | 2159 | 27 |
2158501 | 2158501 | 2022-01-28 | Franklin | Idaho | 16041 | 2152 | 27 |
2155248 | 2155248 | 2022-01-27 | Franklin | Idaho | 16041 | 2152 | 27 |
2151995 | 2151995 | 2022-01-26 | Franklin | Idaho | 16041 | 2145 | 27 |
2148743 | 2148743 | 2022-01-25 | Franklin | Idaho | 16041 | 2135 | 27 |
2145491 | 2145491 | 2022-01-24 | Franklin | Idaho | 16041 | 2125 | 27 |
2142236 | 2142236 | 2022-01-23 | Franklin | Idaho | 16041 | 2111 | 27 |
2138981 | 2138981 | 2022-01-22 | Franklin | Idaho | 16041 | 2111 | 27 |
2135725 | 2135725 | 2022-01-21 | Franklin | Idaho | 16041 | 2111 | 27 |
2132473 | 2132473 | 2022-01-20 | Franklin | Idaho | 16041 | 2108 | 27 |
2129220 | 2129220 | 2022-01-19 | Franklin | Idaho | 16041 | 2101 | 27 |
2125966 | 2125966 | 2022-01-18 | Franklin | Idaho | 16041 | 2094 | 27 |
2122714 | 2122714 | 2022-01-17 | Franklin | Idaho | 16041 | 2014 | 27 |
2119462 | 2119462 | 2022-01-16 | Franklin | Idaho | 16041 | 2014 | 27 |
2116210 | 2116210 | 2022-01-15 | Franklin | Idaho | 16041 | 2014 | 27 |
2112959 | 2112959 | 2022-01-14 | Franklin | Idaho | 16041 | 2014 | 27 |
2109707 | 2109707 | 2022-01-13 | Franklin | Idaho | 16041 | 1968 | 27 |
2106456 | 2106456 | 2022-01-12 | Franklin | Idaho | 16041 | 1967 | 27 |
2103205 | 2103205 | 2022-01-11 | Franklin | Idaho | 16041 | 1956 | 27 |
2099954 | 2099954 | 2022-01-10 | Franklin | Idaho | 16041 | 1938 | 27 |
2096703 | 2096703 | 2022-01-09 | Franklin | Idaho | 16041 | 1911 | 27 |
2093451 | 2093451 | 2022-01-08 | Franklin | Idaho | 16041 | 1911 | 27 |
2090199 | 2090199 | 2022-01-07 | Franklin | Idaho | 16041 | 1911 | 27 |
2086948 | 2086948 | 2022-01-06 | Franklin | Idaho | 16041 | 1895 | 27 |
2083696 | 2083696 | 2022-01-05 | Franklin | Idaho | 16041 | 1890 | 27 |
2080444 | 2080444 | 2022-01-04 | Franklin | Idaho | 16041 | 1867 | 27 |
2077192 | 2077192 | 2022-01-03 | Franklin | Idaho | 16041 | 1852 | 27 |
2073941 | 2073941 | 2022-01-02 | Franklin | Idaho | 16041 | 1833 | 27 |
2070690 | 2070690 | 2022-01-01 | Franklin | Idaho | 16041 | 1833 | 27 |
2067439 | 2067439 | 2021-12-31 | Franklin | Idaho | 16041 | 1833 | 27 |
2064188 | 2064188 | 2021-12-30 | Franklin | Idaho | 16041 | 1833 | 27 |
2060938 | 2060938 | 2021-12-29 | Franklin | Idaho | 16041 | 1832 | 27 |
2057689 | 2057689 | 2021-12-28 | Franklin | Idaho | 16041 | 1831 | 26 |
2054440 | 2054440 | 2021-12-27 | Franklin | Idaho | 16041 | 1824 | 26 |
2051190 | 2051190 | 2021-12-26 | Franklin | Idaho | 16041 | 1815 | 26 |
2047940 | 2047940 | 2021-12-25 | Franklin | Idaho | 16041 | 1815 | 26 |
2044690 | 2044690 | 2021-12-24 | Franklin | Idaho | 16041 | 1815 | 26 |
2041441 | 2041441 | 2021-12-23 | Franklin | Idaho | 16041 | 1815 | 26 |
2038191 | 2038191 | 2021-12-22 | Franklin | Idaho | 16041 | 1815 | 26 |
2034941 | 2034941 | 2021-12-21 | Franklin | Idaho | 16041 | 1815 | 26 |
2031691 | 2031691 | 2021-12-20 | Franklin | Idaho | 16041 | 1811 | 26 |
2028440 | 2028440 | 2021-12-19 | Franklin | Idaho | 16041 | 1811 | 26 |
2025189 | 2025189 | 2021-12-18 | Franklin | Idaho | 16041 | 1811 | 26 |
2021938 | 2021938 | 2021-12-17 | Franklin | Idaho | 16041 | 1811 | 26 |
2018687 | 2018687 | 2021-12-16 | Franklin | Idaho | 16041 | 1810 | 26 |
2015437 | 2015437 | 2021-12-15 | Franklin | Idaho | 16041 | 1808 | 26 |
2012186 | 2012186 | 2021-12-14 | Franklin | Idaho | 16041 | 1802 | 26 |
2008935 | 2008935 | 2021-12-13 | Franklin | Idaho | 16041 | 1794 | 26 |
2005684 | 2005684 | 2021-12-12 | Franklin | Idaho | 16041 | 1785 | 26 |
2002433 | 2002433 | 2021-12-11 | Franklin | Idaho | 16041 | 1785 | 26 |
1999183 | 1999183 | 2021-12-10 | Franklin | Idaho | 16041 | 1785 | 26 |
1995932 | 1995932 | 2021-12-09 | Franklin | Idaho | 16041 | 1782 | 26 |
1992681 | 1992681 | 2021-12-08 | Franklin | Idaho | 16041 | 1776 | 26 |
1989430 | 1989430 | 2021-12-07 | Franklin | Idaho | 16041 | 1776 | 26 |
1986180 | 1986180 | 2021-12-06 | Franklin | Idaho | 16041 | 1772 | 26 |
1982930 | 1982930 | 2021-12-05 | Franklin | Idaho | 16041 | 1768 | 26 |
1979680 | 1979680 | 2021-12-04 | Franklin | Idaho | 16041 | 1768 | 26 |
1976430 | 1976430 | 2021-12-03 | Franklin | Idaho | 16041 | 1763 | 26 |
1973181 | 1973181 | 2021-12-02 | Franklin | Idaho | 16041 | 1763 | 26 |
1969931 | 1969931 | 2021-12-01 | Franklin | Idaho | 16041 | 1753 | 26 |
1966681 | 1966681 | 2021-11-30 | Franklin | Idaho | 16041 | 1745 | 26 |
1963429 | 1963429 | 2021-11-29 | Franklin | Idaho | 16041 | 1743 | 26 |
1960178 | 1960178 | 2021-11-28 | Franklin | Idaho | 16041 | 1740 | 26 |
1956927 | 1956927 | 2021-11-27 | Franklin | Idaho | 16041 | 1740 | 26 |
1953676 | 1953676 | 2021-11-26 | Franklin | Idaho | 16041 | 1740 | 26 |
1950425 | 1950425 | 2021-11-25 | Franklin | Idaho | 16041 | 1729 | 26 |
1947174 | 1947174 | 2021-11-24 | Franklin | Idaho | 16041 | 1729 | 26 |
1943923 | 1943923 | 2021-11-23 | Franklin | Idaho | 16041 | 1726 | 25 |
1940673 | 1940673 | 2021-11-22 | Franklin | Idaho | 16041 | 1722 | 24 |
1937423 | 1937423 | 2021-11-21 | Franklin | Idaho | 16041 | 1709 | 23 |
1934173 | 1934173 | 2021-11-20 | Franklin | Idaho | 16041 | 1709 | 23 |
1930921 | 1930921 | 2021-11-19 | Franklin | Idaho | 16041 | 1708 | 23 |
1927671 | 1927671 | 2021-11-18 | Franklin | Idaho | 16041 | 1708 | 23 |
1924421 | 1924421 | 2021-11-17 | Franklin | Idaho | 16041 | 1697 | 23 |
1921172 | 1921172 | 2021-11-16 | Franklin | Idaho | 16041 | 1694 | 23 |
1917922 | 1917922 | 2021-11-15 | Franklin | Idaho | 16041 | 1691 | 23 |
1914672 | 1914672 | 2021-11-14 | Franklin | Idaho | 16041 | 1679 | 23 |
1911422 | 1911422 | 2021-11-13 | Franklin | Idaho | 16041 | 1679 | 23 |
1908173 | 1908173 | 2021-11-12 | Franklin | Idaho | 16041 | 1678 | 23 |
1904924 | 1904924 | 2021-11-11 | Franklin | Idaho | 16041 | 1671 | 23 |
1901674 | 1901674 | 2021-11-10 | Franklin | Idaho | 16041 | 1671 | 23 |
1898424 | 1898424 | 2021-11-09 | Franklin | Idaho | 16041 | 1669 | 23 |
1895174 | 1895174 | 2021-11-08 | Franklin | Idaho | 16041 | 1664 | 23 |
1891924 | 1891924 | 2021-11-07 | Franklin | Idaho | 16041 | 1657 | 23 |
1888674 | 1888674 | 2021-11-06 | Franklin | Idaho | 16041 | 1657 | 23 |
1885424 | 1885424 | 2021-11-05 | Franklin | Idaho | 16041 | 1657 | 23 |
1882175 | 1882175 | 2021-11-04 | Franklin | Idaho | 16041 | 1647 | 23 |
1878926 | 1878926 | 2021-11-03 | Franklin | Idaho | 16041 | 1645 | 23 |
1875677 | 1875677 | 2021-11-02 | Franklin | Idaho | 16041 | 1627 | 23 |
1872428 | 1872428 | 2021-11-01 | Franklin | Idaho | 16041 | 1610 | 23 |
1869179 | 1869179 | 2021-10-31 | Franklin | Idaho | 16041 | 1604 | 23 |
1865930 | 1865930 | 2021-10-30 | Franklin | Idaho | 16041 | 1604 | 23 |
1862681 | 1862681 | 2021-10-29 | Franklin | Idaho | 16041 | 1604 | 23 |
1859432 | 1859432 | 2021-10-28 | Franklin | Idaho | 16041 | 1599 | 23 |
1856183 | 1856183 | 2021-10-27 | Franklin | Idaho | 16041 | 1575 | 23 |
1852934 | 1852934 | 2021-10-26 | Franklin | Idaho | 16041 | 1574 | 23 |
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);