ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
461 rows where deaths = 18 and state = "Idaho" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2220328 | 2220328 | 2022-02-16 | Power | Idaho | 16077 | 1471 | 18 |
2217077 | 2217077 | 2022-02-15 | Power | Idaho | 16077 | 1468 | 18 |
2213826 | 2213826 | 2022-02-14 | Power | Idaho | 16077 | 1467 | 18 |
2210574 | 2210574 | 2022-02-13 | Power | Idaho | 16077 | 1464 | 18 |
2207321 | 2207321 | 2022-02-12 | Power | Idaho | 16077 | 1464 | 18 |
2204068 | 2204068 | 2022-02-11 | Power | Idaho | 16077 | 1464 | 18 |
2200815 | 2200815 | 2022-02-10 | Power | Idaho | 16077 | 1464 | 18 |
2197561 | 2197561 | 2022-02-09 | Power | Idaho | 16077 | 1464 | 18 |
2194307 | 2194307 | 2022-02-08 | Power | Idaho | 16077 | 1458 | 18 |
2191053 | 2191053 | 2022-02-07 | Power | Idaho | 16077 | 1453 | 18 |
2187800 | 2187800 | 2022-02-06 | Power | Idaho | 16077 | 1447 | 18 |
2184547 | 2184547 | 2022-02-05 | Power | Idaho | 16077 | 1447 | 18 |
2181295 | 2181295 | 2022-02-04 | Power | Idaho | 16077 | 1447 | 18 |
2178044 | 2178044 | 2022-02-03 | Power | Idaho | 16077 | 1433 | 18 |
2174791 | 2174791 | 2022-02-02 | Power | Idaho | 16077 | 1428 | 18 |
2171538 | 2171538 | 2022-02-01 | Power | Idaho | 16077 | 1422 | 18 |
2168285 | 2168285 | 2022-01-31 | Power | Idaho | 16077 | 1414 | 18 |
2165030 | 2165030 | 2022-01-30 | Power | Idaho | 16077 | 1400 | 18 |
2161775 | 2161775 | 2022-01-29 | Power | Idaho | 16077 | 1400 | 18 |
2158519 | 2158519 | 2022-01-28 | Power | Idaho | 16077 | 1400 | 18 |
2155266 | 2155266 | 2022-01-27 | Power | Idaho | 16077 | 1391 | 18 |
2152013 | 2152013 | 2022-01-26 | Power | Idaho | 16077 | 1359 | 18 |
2148761 | 2148761 | 2022-01-25 | Power | Idaho | 16077 | 1341 | 18 |
2051191 | 2051191 | 2021-12-26 | Fremont | Idaho | 16043 | 1736 | 18 |
2047941 | 2047941 | 2021-12-25 | Fremont | Idaho | 16043 | 1736 | 18 |
2044691 | 2044691 | 2021-12-24 | Fremont | Idaho | 16043 | 1736 | 18 |
2041442 | 2041442 | 2021-12-23 | Fremont | Idaho | 16043 | 1736 | 18 |
2038192 | 2038192 | 2021-12-22 | Fremont | Idaho | 16043 | 1730 | 18 |
2034942 | 2034942 | 2021-12-21 | Fremont | Idaho | 16043 | 1727 | 18 |
2031692 | 2031692 | 2021-12-20 | Fremont | Idaho | 16043 | 1721 | 18 |
2028441 | 2028441 | 2021-12-19 | Fremont | Idaho | 16043 | 1714 | 18 |
2025190 | 2025190 | 2021-12-18 | Fremont | Idaho | 16043 | 1714 | 18 |
2021939 | 2021939 | 2021-12-17 | Fremont | Idaho | 16043 | 1706 | 18 |
2018688 | 2018688 | 2021-12-16 | Fremont | Idaho | 16043 | 1700 | 18 |
2015438 | 2015438 | 2021-12-15 | Fremont | Idaho | 16043 | 1695 | 18 |
2012187 | 2012187 | 2021-12-14 | Fremont | Idaho | 16043 | 1690 | 18 |
2008936 | 2008936 | 2021-12-13 | Fremont | Idaho | 16043 | 1682 | 18 |
2005685 | 2005685 | 2021-12-12 | Fremont | Idaho | 16043 | 1681 | 18 |
2002434 | 2002434 | 2021-12-11 | Fremont | Idaho | 16043 | 1681 | 18 |
1999184 | 1999184 | 2021-12-10 | Fremont | Idaho | 16043 | 1680 | 18 |
1995933 | 1995933 | 2021-12-09 | Fremont | Idaho | 16043 | 1674 | 18 |
1992682 | 1992682 | 2021-12-08 | Fremont | Idaho | 16043 | 1652 | 18 |
1989431 | 1989431 | 2021-12-07 | Fremont | Idaho | 16043 | 1643 | 18 |
1986181 | 1986181 | 2021-12-06 | Fremont | Idaho | 16043 | 1639 | 18 |
1982931 | 1982931 | 2021-12-05 | Fremont | Idaho | 16043 | 1637 | 18 |
1979681 | 1979681 | 2021-12-04 | Fremont | Idaho | 16043 | 1637 | 18 |
1976431 | 1976431 | 2021-12-03 | Fremont | Idaho | 16043 | 1633 | 18 |
1973182 | 1973182 | 2021-12-02 | Fremont | Idaho | 16043 | 1633 | 18 |
1969932 | 1969932 | 2021-12-01 | Fremont | Idaho | 16043 | 1631 | 18 |
1966682 | 1966682 | 2021-11-30 | Fremont | Idaho | 16043 | 1627 | 18 |
1963430 | 1963430 | 2021-11-29 | Fremont | Idaho | 16043 | 1619 | 18 |
1960179 | 1960179 | 2021-11-28 | Fremont | Idaho | 16043 | 1617 | 18 |
1956928 | 1956928 | 2021-11-27 | Fremont | Idaho | 16043 | 1617 | 18 |
1953677 | 1953677 | 2021-11-26 | Fremont | Idaho | 16043 | 1617 | 18 |
1950426 | 1950426 | 2021-11-25 | Fremont | Idaho | 16043 | 1617 | 18 |
1947175 | 1947175 | 2021-11-24 | Fremont | Idaho | 16043 | 1617 | 18 |
1943924 | 1943924 | 2021-11-23 | Fremont | Idaho | 16043 | 1607 | 18 |
1940674 | 1940674 | 2021-11-22 | Fremont | Idaho | 16043 | 1604 | 18 |
1930943 | 1930943 | 2021-11-19 | Unknown | Idaho | 605 | 18 | |
1882184 | 1882184 | 2021-11-04 | Lemhi | Idaho | 16059 | 863 | 18 |
1878935 | 1878935 | 2021-11-03 | Lemhi | Idaho | 16059 | 861 | 18 |
1875686 | 1875686 | 2021-11-02 | Lemhi | Idaho | 16059 | 858 | 18 |
1872437 | 1872437 | 2021-11-01 | Lemhi | Idaho | 16059 | 852 | 18 |
1869188 | 1869188 | 2021-10-31 | Lemhi | Idaho | 16059 | 845 | 18 |
1865939 | 1865939 | 2021-10-30 | Lemhi | Idaho | 16059 | 845 | 18 |
1862690 | 1862690 | 2021-10-29 | Lemhi | Idaho | 16059 | 845 | 18 |
1859441 | 1859441 | 2021-10-28 | Lemhi | Idaho | 16059 | 843 | 18 |
1856192 | 1856192 | 2021-10-27 | Lemhi | Idaho | 16059 | 834 | 18 |
1852943 | 1852943 | 2021-10-26 | Lemhi | Idaho | 16059 | 830 | 18 |
1849694 | 1849694 | 2021-10-25 | Lemhi | Idaho | 16059 | 822 | 18 |
1813954 | 1813954 | 2021-10-14 | Lewis | Idaho | 16061 | 722 | 18 |
1810679 | 1810679 | 2021-10-13 | Benewah | Idaho | 16009 | 1101 | 18 |
1810705 | 1810705 | 2021-10-13 | Lewis | Idaho | 16061 | 720 | 18 |
1807430 | 1807430 | 2021-10-12 | Benewah | Idaho | 16009 | 1093 | 18 |
1807456 | 1807456 | 2021-10-12 | Lewis | Idaho | 16061 | 718 | 18 |
1726206 | 1726206 | 2021-09-17 | Boundary | Idaho | 16021 | 1124 | 18 |
1700240 | 1700240 | 2021-09-09 | Latah | Idaho | 16057 | 3766 | 18 |
1696991 | 1696991 | 2021-09-08 | Latah | Idaho | 16057 | 3737 | 18 |
1693743 | 1693743 | 2021-09-07 | Latah | Idaho | 16057 | 3713 | 18 |
1690490 | 1690490 | 2021-09-06 | Idaho | Idaho | 16049 | 1669 | 18 |
1690494 | 1690494 | 2021-09-06 | Latah | Idaho | 16057 | 3669 | 18 |
1687240 | 1687240 | 2021-09-05 | Idaho | Idaho | 16049 | 1669 | 18 |
1687244 | 1687244 | 2021-09-05 | Latah | Idaho | 16057 | 3669 | 18 |
1683990 | 1683990 | 2021-09-04 | Idaho | Idaho | 16049 | 1669 | 18 |
1683994 | 1683994 | 2021-09-04 | Latah | Idaho | 16057 | 3669 | 18 |
1680739 | 1680739 | 2021-09-03 | Idaho | Idaho | 16049 | 1669 | 18 |
1680743 | 1680743 | 2021-09-03 | Latah | Idaho | 16057 | 3669 | 18 |
1677491 | 1677491 | 2021-09-02 | Idaho | Idaho | 16049 | 1662 | 18 |
1677495 | 1677495 | 2021-09-02 | Latah | Idaho | 16057 | 3644 | 18 |
1674244 | 1674244 | 2021-09-01 | Idaho | Idaho | 16049 | 1648 | 18 |
1674248 | 1674248 | 2021-09-01 | Latah | Idaho | 16057 | 3629 | 18 |
1670995 | 1670995 | 2021-08-31 | Idaho | Idaho | 16049 | 1643 | 18 |
1670999 | 1670999 | 2021-08-31 | Latah | Idaho | 16057 | 3615 | 18 |
1667748 | 1667748 | 2021-08-30 | Idaho | Idaho | 16049 | 1634 | 18 |
1664501 | 1664501 | 2021-08-29 | Idaho | Idaho | 16049 | 1617 | 18 |
1661253 | 1661253 | 2021-08-28 | Idaho | Idaho | 16049 | 1617 | 18 |
1658005 | 1658005 | 2021-08-27 | Idaho | Idaho | 16049 | 1617 | 18 |
1654757 | 1654757 | 2021-08-26 | Idaho | Idaho | 16049 | 1609 | 18 |
1651510 | 1651510 | 2021-08-25 | Idaho | Idaho | 16049 | 1595 | 18 |
1648261 | 1648261 | 2021-08-24 | Idaho | Idaho | 16049 | 1585 | 18 |
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);