ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 30043 and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175831 | 2175831 | 2022-02-02 | Jefferson | Montana | 30043 | 2369 | 23 |
2172578 | 2172578 | 2022-02-01 | Jefferson | Montana | 30043 | 2354 | 23 |
2169325 | 2169325 | 2022-01-31 | Jefferson | Montana | 30043 | 2349 | 23 |
2166070 | 2166070 | 2022-01-30 | Jefferson | Montana | 30043 | 2319 | 23 |
2162815 | 2162815 | 2022-01-29 | Jefferson | Montana | 30043 | 2319 | 23 |
2159560 | 2159560 | 2022-01-28 | Jefferson | Montana | 30043 | 2319 | 23 |
2156306 | 2156306 | 2022-01-27 | Jefferson | Montana | 30043 | 2305 | 22 |
2153053 | 2153053 | 2022-01-26 | Jefferson | Montana | 30043 | 2278 | 22 |
2149801 | 2149801 | 2022-01-25 | Jefferson | Montana | 30043 | 2247 | 22 |
2146549 | 2146549 | 2022-01-24 | Jefferson | Montana | 30043 | 2222 | 22 |
2143294 | 2143294 | 2022-01-23 | Jefferson | Montana | 30043 | 2180 | 22 |
2140039 | 2140039 | 2022-01-22 | Jefferson | Montana | 30043 | 2180 | 22 |
2136783 | 2136783 | 2022-01-21 | Jefferson | Montana | 30043 | 2180 | 22 |
2133531 | 2133531 | 2022-01-20 | Jefferson | Montana | 30043 | 2152 | 22 |
2130278 | 2130278 | 2022-01-19 | Jefferson | Montana | 30043 | 2117 | 22 |
2127024 | 2127024 | 2022-01-18 | Jefferson | Montana | 30043 | 2091 | 22 |
2123772 | 2123772 | 2022-01-17 | Jefferson | Montana | 30043 | 2062 | 22 |
2120520 | 2120520 | 2022-01-16 | Jefferson | Montana | 30043 | 2062 | 22 |
2117268 | 2117268 | 2022-01-15 | Jefferson | Montana | 30043 | 2062 | 22 |
2114017 | 2114017 | 2022-01-14 | Jefferson | Montana | 30043 | 2062 | 22 |
2110765 | 2110765 | 2022-01-13 | Jefferson | Montana | 30043 | 2045 | 22 |
2107514 | 2107514 | 2022-01-12 | Jefferson | Montana | 30043 | 2022 | 22 |
2104263 | 2104263 | 2022-01-11 | Jefferson | Montana | 30043 | 2006 | 22 |
2101012 | 2101012 | 2022-01-10 | Jefferson | Montana | 30043 | 1996 | 22 |
2097761 | 2097761 | 2022-01-09 | Jefferson | Montana | 30043 | 1984 | 22 |
2094509 | 2094509 | 2022-01-08 | Jefferson | Montana | 30043 | 1984 | 22 |
2091257 | 2091257 | 2022-01-07 | Jefferson | Montana | 30043 | 1984 | 22 |
2088006 | 2088006 | 2022-01-06 | Jefferson | Montana | 30043 | 1977 | 22 |
2084754 | 2084754 | 2022-01-05 | Jefferson | Montana | 30043 | 1967 | 22 |
2081502 | 2081502 | 2022-01-04 | Jefferson | Montana | 30043 | 1963 | 21 |
2078250 | 2078250 | 2022-01-03 | Jefferson | Montana | 30043 | 1961 | 21 |
2074999 | 2074999 | 2022-01-02 | Jefferson | Montana | 30043 | 1954 | 21 |
2071748 | 2071748 | 2022-01-01 | Jefferson | Montana | 30043 | 1954 | 21 |
2068497 | 2068497 | 2021-12-31 | Jefferson | Montana | 30043 | 1954 | 21 |
2065246 | 2065246 | 2021-12-30 | Jefferson | Montana | 30043 | 1954 | 21 |
2061996 | 2061996 | 2021-12-29 | Jefferson | Montana | 30043 | 1947 | 21 |
2058747 | 2058747 | 2021-12-28 | Jefferson | Montana | 30043 | 1943 | 21 |
2055498 | 2055498 | 2021-12-27 | Jefferson | Montana | 30043 | 1944 | 21 |
2052248 | 2052248 | 2021-12-26 | Jefferson | Montana | 30043 | 1938 | 21 |
2048998 | 2048998 | 2021-12-25 | Jefferson | Montana | 30043 | 1938 | 21 |
2045748 | 2045748 | 2021-12-24 | Jefferson | Montana | 30043 | 1938 | 21 |
2042498 | 2042498 | 2021-12-23 | Jefferson | Montana | 30043 | 1938 | 21 |
2039249 | 2039249 | 2021-12-22 | Jefferson | Montana | 30043 | 1938 | 21 |
2035999 | 2035999 | 2021-12-21 | Jefferson | Montana | 30043 | 1937 | 21 |
2032749 | 2032749 | 2021-12-20 | Jefferson | Montana | 30043 | 1934 | 21 |
2029498 | 2029498 | 2021-12-19 | Jefferson | Montana | 30043 | 1934 | 21 |
2026247 | 2026247 | 2021-12-18 | Jefferson | Montana | 30043 | 1934 | 21 |
2022996 | 2022996 | 2021-12-17 | Jefferson | Montana | 30043 | 1934 | 21 |
2019745 | 2019745 | 2021-12-16 | Jefferson | Montana | 30043 | 1932 | 21 |
2016495 | 2016495 | 2021-12-15 | Jefferson | Montana | 30043 | 1930 | 21 |
2013244 | 2013244 | 2021-12-14 | Jefferson | Montana | 30043 | 1926 | 20 |
2009993 | 2009993 | 2021-12-13 | Jefferson | Montana | 30043 | 1926 | 20 |
2006742 | 2006742 | 2021-12-12 | Jefferson | Montana | 30043 | 1919 | 20 |
2003491 | 2003491 | 2021-12-11 | Jefferson | Montana | 30043 | 1919 | 20 |
2000241 | 2000241 | 2021-12-10 | Jefferson | Montana | 30043 | 1919 | 20 |
1996990 | 1996990 | 2021-12-09 | Jefferson | Montana | 30043 | 1917 | 19 |
1993739 | 1993739 | 2021-12-08 | Jefferson | Montana | 30043 | 1916 | 19 |
1990488 | 1990488 | 2021-12-07 | Jefferson | Montana | 30043 | 1914 | 18 |
1987238 | 1987238 | 2021-12-06 | Jefferson | Montana | 30043 | 1914 | 17 |
1983988 | 1983988 | 2021-12-05 | Jefferson | Montana | 30043 | 1909 | 15 |
1980738 | 1980738 | 2021-12-04 | Jefferson | Montana | 30043 | 1909 | 15 |
1977488 | 1977488 | 2021-12-03 | Jefferson | Montana | 30043 | 1909 | 15 |
1974238 | 1974238 | 2021-12-02 | Jefferson | Montana | 30043 | 1904 | 15 |
1970989 | 1970989 | 2021-12-01 | Jefferson | Montana | 30043 | 1897 | 14 |
1967739 | 1967739 | 2021-11-30 | Jefferson | Montana | 30043 | 1890 | 14 |
1964487 | 1964487 | 2021-11-29 | Jefferson | Montana | 30043 | 1882 | 14 |
1961236 | 1961236 | 2021-11-28 | Jefferson | Montana | 30043 | 1864 | 14 |
1957985 | 1957985 | 2021-11-27 | Jefferson | Montana | 30043 | 1864 | 14 |
1954734 | 1954734 | 2021-11-26 | Jefferson | Montana | 30043 | 1864 | 14 |
1951483 | 1951483 | 2021-11-25 | Jefferson | Montana | 30043 | 1861 | 14 |
1948232 | 1948232 | 2021-11-24 | Jefferson | Montana | 30043 | 1861 | 14 |
1944981 | 1944981 | 2021-11-23 | Jefferson | Montana | 30043 | 1849 | 14 |
1941730 | 1941730 | 2021-11-22 | Jefferson | Montana | 30043 | 1836 | 14 |
1938480 | 1938480 | 2021-11-21 | Jefferson | Montana | 30043 | 1821 | 14 |
1935230 | 1935230 | 2021-11-20 | Jefferson | Montana | 30043 | 1821 | 14 |
1931980 | 1931980 | 2021-11-19 | Jefferson | Montana | 30043 | 1821 | 14 |
1928729 | 1928729 | 2021-11-18 | Jefferson | Montana | 30043 | 1819 | 13 |
1925479 | 1925479 | 2021-11-17 | Jefferson | Montana | 30043 | 1816 | 13 |
1922230 | 1922230 | 2021-11-16 | Jefferson | Montana | 30043 | 1810 | 13 |
1918980 | 1918980 | 2021-11-15 | Jefferson | Montana | 30043 | 1795 | 13 |
1915730 | 1915730 | 2021-11-14 | Jefferson | Montana | 30043 | 1787 | 13 |
1912480 | 1912480 | 2021-11-13 | Jefferson | Montana | 30043 | 1787 | 13 |
1909230 | 1909230 | 2021-11-12 | Jefferson | Montana | 30043 | 1787 | 13 |
1905981 | 1905981 | 2021-11-11 | Jefferson | Montana | 30043 | 1779 | 13 |
1902732 | 1902732 | 2021-11-10 | Jefferson | Montana | 30043 | 1779 | 13 |
1899482 | 1899482 | 2021-11-09 | Jefferson | Montana | 30043 | 1771 | 13 |
1896232 | 1896232 | 2021-11-08 | Jefferson | Montana | 30043 | 1767 | 13 |
1892982 | 1892982 | 2021-11-07 | Jefferson | Montana | 30043 | 1762 | 13 |
1889732 | 1889732 | 2021-11-06 | Jefferson | Montana | 30043 | 1762 | 13 |
1886482 | 1886482 | 2021-11-05 | Jefferson | Montana | 30043 | 1762 | 13 |
1883233 | 1883233 | 2021-11-04 | Jefferson | Montana | 30043 | 1751 | 12 |
1879984 | 1879984 | 2021-11-03 | Jefferson | Montana | 30043 | 1735 | 12 |
1876735 | 1876735 | 2021-11-02 | Jefferson | Montana | 30043 | 1727 | 12 |
1873486 | 1873486 | 2021-11-01 | Jefferson | Montana | 30043 | 1722 | 11 |
1870237 | 1870237 | 2021-10-31 | Jefferson | Montana | 30043 | 1716 | 11 |
1866988 | 1866988 | 2021-10-30 | Jefferson | Montana | 30043 | 1716 | 11 |
1863739 | 1863739 | 2021-10-29 | Jefferson | Montana | 30043 | 1716 | 11 |
1860490 | 1860490 | 2021-10-28 | Jefferson | Montana | 30043 | 1708 | 11 |
1857241 | 1857241 | 2021-10-27 | Jefferson | Montana | 30043 | 1695 | 11 |
1853992 | 1853992 | 2021-10-26 | Jefferson | Montana | 30043 | 1692 | 11 |
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);