ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where fips = 30001 and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175810 | 2175810 | 2022-02-02 | Beaverhead | Montana | 30001 | 1982 | 24 |
2172557 | 2172557 | 2022-02-01 | Beaverhead | Montana | 30001 | 1977 | 24 |
2169304 | 2169304 | 2022-01-31 | Beaverhead | Montana | 30001 | 1974 | 24 |
2166049 | 2166049 | 2022-01-30 | Beaverhead | Montana | 30001 | 1953 | 24 |
2162794 | 2162794 | 2022-01-29 | Beaverhead | Montana | 30001 | 1953 | 24 |
2159539 | 2159539 | 2022-01-28 | Beaverhead | Montana | 30001 | 1953 | 24 |
2156285 | 2156285 | 2022-01-27 | Beaverhead | Montana | 30001 | 1938 | 24 |
2153032 | 2153032 | 2022-01-26 | Beaverhead | Montana | 30001 | 1889 | 24 |
2149780 | 2149780 | 2022-01-25 | Beaverhead | Montana | 30001 | 1855 | 24 |
2146528 | 2146528 | 2022-01-24 | Beaverhead | Montana | 30001 | 1834 | 24 |
2143273 | 2143273 | 2022-01-23 | Beaverhead | Montana | 30001 | 1809 | 24 |
2140018 | 2140018 | 2022-01-22 | Beaverhead | Montana | 30001 | 1809 | 24 |
2136762 | 2136762 | 2022-01-21 | Beaverhead | Montana | 30001 | 1809 | 24 |
2133510 | 2133510 | 2022-01-20 | Beaverhead | Montana | 30001 | 1778 | 24 |
2130257 | 2130257 | 2022-01-19 | Beaverhead | Montana | 30001 | 1745 | 24 |
2127003 | 2127003 | 2022-01-18 | Beaverhead | Montana | 30001 | 1706 | 24 |
2123751 | 2123751 | 2022-01-17 | Beaverhead | Montana | 30001 | 1699 | 24 |
2120499 | 2120499 | 2022-01-16 | Beaverhead | Montana | 30001 | 1699 | 24 |
2117247 | 2117247 | 2022-01-15 | Beaverhead | Montana | 30001 | 1699 | 24 |
2113996 | 2113996 | 2022-01-14 | Beaverhead | Montana | 30001 | 1699 | 24 |
2110744 | 2110744 | 2022-01-13 | Beaverhead | Montana | 30001 | 1688 | 24 |
2107493 | 2107493 | 2022-01-12 | Beaverhead | Montana | 30001 | 1677 | 24 |
2104242 | 2104242 | 2022-01-11 | Beaverhead | Montana | 30001 | 1670 | 23 |
2100991 | 2100991 | 2022-01-10 | Beaverhead | Montana | 30001 | 1652 | 23 |
2097740 | 2097740 | 2022-01-09 | Beaverhead | Montana | 30001 | 1647 | 23 |
2094488 | 2094488 | 2022-01-08 | Beaverhead | Montana | 30001 | 1647 | 23 |
2091236 | 2091236 | 2022-01-07 | Beaverhead | Montana | 30001 | 1647 | 23 |
2087985 | 2087985 | 2022-01-06 | Beaverhead | Montana | 30001 | 1642 | 23 |
2084733 | 2084733 | 2022-01-05 | Beaverhead | Montana | 30001 | 1630 | 23 |
2081481 | 2081481 | 2022-01-04 | Beaverhead | Montana | 30001 | 1624 | 23 |
2078229 | 2078229 | 2022-01-03 | Beaverhead | Montana | 30001 | 1615 | 23 |
2074978 | 2074978 | 2022-01-02 | Beaverhead | Montana | 30001 | 1611 | 23 |
2071727 | 2071727 | 2022-01-01 | Beaverhead | Montana | 30001 | 1611 | 23 |
2068476 | 2068476 | 2021-12-31 | Beaverhead | Montana | 30001 | 1611 | 23 |
2065225 | 2065225 | 2021-12-30 | Beaverhead | Montana | 30001 | 1611 | 23 |
2061975 | 2061975 | 2021-12-29 | Beaverhead | Montana | 30001 | 1609 | 23 |
2058726 | 2058726 | 2021-12-28 | Beaverhead | Montana | 30001 | 1601 | 23 |
2055477 | 2055477 | 2021-12-27 | Beaverhead | Montana | 30001 | 1601 | 23 |
2052227 | 2052227 | 2021-12-26 | Beaverhead | Montana | 30001 | 1600 | 23 |
2048977 | 2048977 | 2021-12-25 | Beaverhead | Montana | 30001 | 1600 | 23 |
2045727 | 2045727 | 2021-12-24 | Beaverhead | Montana | 30001 | 1600 | 23 |
2042477 | 2042477 | 2021-12-23 | Beaverhead | Montana | 30001 | 1600 | 23 |
2039228 | 2039228 | 2021-12-22 | Beaverhead | Montana | 30001 | 1601 | 23 |
2035978 | 2035978 | 2021-12-21 | Beaverhead | Montana | 30001 | 1595 | 23 |
2032728 | 2032728 | 2021-12-20 | Beaverhead | Montana | 30001 | 1595 | 23 |
2029477 | 2029477 | 2021-12-19 | Beaverhead | Montana | 30001 | 1594 | 23 |
2026226 | 2026226 | 2021-12-18 | Beaverhead | Montana | 30001 | 1594 | 23 |
2022975 | 2022975 | 2021-12-17 | Beaverhead | Montana | 30001 | 1594 | 23 |
2019724 | 2019724 | 2021-12-16 | Beaverhead | Montana | 30001 | 1593 | 23 |
2016474 | 2016474 | 2021-12-15 | Beaverhead | Montana | 30001 | 1591 | 23 |
2013223 | 2013223 | 2021-12-14 | Beaverhead | Montana | 30001 | 1592 | 22 |
2009972 | 2009972 | 2021-12-13 | Beaverhead | Montana | 30001 | 1592 | 22 |
2006721 | 2006721 | 2021-12-12 | Beaverhead | Montana | 30001 | 1592 | 22 |
2003470 | 2003470 | 2021-12-11 | Beaverhead | Montana | 30001 | 1592 | 22 |
2000220 | 2000220 | 2021-12-10 | Beaverhead | Montana | 30001 | 1592 | 22 |
1996969 | 1996969 | 2021-12-09 | Beaverhead | Montana | 30001 | 1591 | 22 |
1993718 | 1993718 | 2021-12-08 | Beaverhead | Montana | 30001 | 1592 | 22 |
1990467 | 1990467 | 2021-12-07 | Beaverhead | Montana | 30001 | 1590 | 22 |
1987217 | 1987217 | 2021-12-06 | Beaverhead | Montana | 30001 | 1582 | 22 |
1983967 | 1983967 | 2021-12-05 | Beaverhead | Montana | 30001 | 1582 | 22 |
1980717 | 1980717 | 2021-12-04 | Beaverhead | Montana | 30001 | 1582 | 22 |
1977467 | 1977467 | 2021-12-03 | Beaverhead | Montana | 30001 | 1582 | 22 |
1974217 | 1974217 | 2021-12-02 | Beaverhead | Montana | 30001 | 1581 | 22 |
1970968 | 1970968 | 2021-12-01 | Beaverhead | Montana | 30001 | 1579 | 22 |
1967718 | 1967718 | 2021-11-30 | Beaverhead | Montana | 30001 | 1574 | 22 |
1964466 | 1964466 | 2021-11-29 | Beaverhead | Montana | 30001 | 1570 | 22 |
1961215 | 1961215 | 2021-11-28 | Beaverhead | Montana | 30001 | 1567 | 22 |
1957964 | 1957964 | 2021-11-27 | Beaverhead | Montana | 30001 | 1567 | 22 |
1954713 | 1954713 | 2021-11-26 | Beaverhead | Montana | 30001 | 1567 | 22 |
1951462 | 1951462 | 2021-11-25 | Beaverhead | Montana | 30001 | 1560 | 22 |
1948211 | 1948211 | 2021-11-24 | Beaverhead | Montana | 30001 | 1560 | 22 |
1944960 | 1944960 | 2021-11-23 | Beaverhead | Montana | 30001 | 1557 | 22 |
1941709 | 1941709 | 2021-11-22 | Beaverhead | Montana | 30001 | 1554 | 22 |
1938459 | 1938459 | 2021-11-21 | Beaverhead | Montana | 30001 | 1549 | 22 |
1935209 | 1935209 | 2021-11-20 | Beaverhead | Montana | 30001 | 1549 | 22 |
1931959 | 1931959 | 2021-11-19 | Beaverhead | Montana | 30001 | 1549 | 22 |
1928708 | 1928708 | 2021-11-18 | Beaverhead | Montana | 30001 | 1543 | 22 |
1925458 | 1925458 | 2021-11-17 | Beaverhead | Montana | 30001 | 1535 | 22 |
1922209 | 1922209 | 2021-11-16 | Beaverhead | Montana | 30001 | 1520 | 22 |
1918959 | 1918959 | 2021-11-15 | Beaverhead | Montana | 30001 | 1519 | 22 |
1915709 | 1915709 | 2021-11-14 | Beaverhead | Montana | 30001 | 1518 | 20 |
1912459 | 1912459 | 2021-11-13 | Beaverhead | Montana | 30001 | 1518 | 20 |
1909209 | 1909209 | 2021-11-12 | Beaverhead | Montana | 30001 | 1518 | 20 |
1905960 | 1905960 | 2021-11-11 | Beaverhead | Montana | 30001 | 1509 | 20 |
1902711 | 1902711 | 2021-11-10 | Beaverhead | Montana | 30001 | 1509 | 20 |
1899461 | 1899461 | 2021-11-09 | Beaverhead | Montana | 30001 | 1503 | 17 |
1896211 | 1896211 | 2021-11-08 | Beaverhead | Montana | 30001 | 1498 | 18 |
1892961 | 1892961 | 2021-11-07 | Beaverhead | Montana | 30001 | 1498 | 18 |
1889711 | 1889711 | 2021-11-06 | Beaverhead | Montana | 30001 | 1498 | 18 |
1886461 | 1886461 | 2021-11-05 | Beaverhead | Montana | 30001 | 1498 | 18 |
1883212 | 1883212 | 2021-11-04 | Beaverhead | Montana | 30001 | 1496 | 18 |
1879963 | 1879963 | 2021-11-03 | Beaverhead | Montana | 30001 | 1491 | 17 |
1876714 | 1876714 | 2021-11-02 | Beaverhead | Montana | 30001 | 1489 | 17 |
1873465 | 1873465 | 2021-11-01 | Beaverhead | Montana | 30001 | 1486 | 17 |
1870216 | 1870216 | 2021-10-31 | Beaverhead | Montana | 30001 | 1477 | 17 |
1866967 | 1866967 | 2021-10-30 | Beaverhead | Montana | 30001 | 1477 | 17 |
1863718 | 1863718 | 2021-10-29 | Beaverhead | Montana | 30001 | 1477 | 17 |
1860469 | 1860469 | 2021-10-28 | Beaverhead | Montana | 30001 | 1473 | 17 |
1857220 | 1857220 | 2021-10-27 | Beaverhead | Montana | 30001 | 1464 | 15 |
1853971 | 1853971 | 2021-10-26 | Beaverhead | Montana | 30001 | 1452 | 15 |
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);