ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
210 rows where deaths = 34 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 |
---|---|---|---|---|---|---|---|
2187766 | 2187766 | 2022-02-06 | Benewah | Idaho | 16009 | 1911 | 34 |
2184513 | 2184513 | 2022-02-05 | Benewah | Idaho | 16009 | 1911 | 34 |
2181261 | 2181261 | 2022-02-04 | Benewah | Idaho | 16009 | 1906 | 34 |
2178010 | 2178010 | 2022-02-03 | Benewah | Idaho | 16009 | 1897 | 34 |
1859440 | 1859440 | 2021-10-28 | Latah | Idaho | 16057 | 4540 | 34 |
1856187 | 1856187 | 2021-10-27 | Idaho | Idaho | 16049 | 2113 | 34 |
1856191 | 1856191 | 2021-10-27 | Latah | Idaho | 16057 | 4531 | 34 |
1852938 | 1852938 | 2021-10-26 | Idaho | Idaho | 16049 | 2102 | 34 |
1833432 | 1833432 | 2021-10-20 | Cassia | Idaho | 16031 | 3770 | 34 |
1830183 | 1830183 | 2021-10-19 | Cassia | Idaho | 16031 | 3746 | 34 |
1826934 | 1826934 | 2021-10-18 | Cassia | Idaho | 16031 | 3735 | 34 |
1823685 | 1823685 | 2021-10-17 | Cassia | Idaho | 16031 | 3720 | 34 |
1820436 | 1820436 | 2021-10-16 | Cassia | Idaho | 16031 | 3720 | 34 |
1817187 | 1817187 | 2021-10-15 | Cassia | Idaho | 16031 | 3700 | 34 |
1813939 | 1813939 | 2021-10-14 | Cassia | Idaho | 16031 | 3681 | 34 |
1810690 | 1810690 | 2021-10-13 | Cassia | Idaho | 16031 | 3671 | 34 |
1807441 | 1807441 | 2021-10-12 | Cassia | Idaho | 16031 | 3654 | 34 |
1804190 | 1804190 | 2021-10-11 | Cassia | Idaho | 16031 | 3649 | 34 |
1800941 | 1800941 | 2021-10-10 | Cassia | Idaho | 16031 | 3649 | 34 |
1797692 | 1797692 | 2021-10-09 | Cassia | Idaho | 16031 | 3645 | 34 |
1794443 | 1794443 | 2021-10-08 | Cassia | Idaho | 16031 | 3634 | 34 |
1784705 | 1784705 | 2021-10-05 | Gooding | Idaho | 16047 | 2103 | 34 |
1784714 | 1784714 | 2021-10-05 | Madison | Idaho | 16065 | 8233 | 34 |
1781456 | 1781456 | 2021-10-04 | Gooding | Idaho | 16047 | 2096 | 34 |
1781465 | 1781465 | 2021-10-04 | Madison | Idaho | 16065 | 8193 | 34 |
1778215 | 1778215 | 2021-10-03 | Madison | Idaho | 16065 | 8166 | 34 |
1774965 | 1774965 | 2021-10-02 | Madison | Idaho | 16065 | 8166 | 34 |
1771715 | 1771715 | 2021-10-01 | Madison | Idaho | 16065 | 8160 | 34 |
1768453 | 1768453 | 2021-09-30 | Elmore | Idaho | 16039 | 3546 | 34 |
1768466 | 1768466 | 2021-09-30 | Madison | Idaho | 16065 | 8138 | 34 |
1765217 | 1765217 | 2021-09-29 | Madison | Idaho | 16065 | 8129 | 34 |
1761968 | 1761968 | 2021-09-28 | Madison | Idaho | 16065 | 8116 | 34 |
1761979 | 1761979 | 2021-09-28 | Washington | Idaho | 16087 | 1655 | 34 |
1758720 | 1758720 | 2021-09-27 | Madison | Idaho | 16065 | 8092 | 34 |
1758724 | 1758724 | 2021-09-27 | Owyhee | Idaho | 16073 | 1385 | 34 |
1758731 | 1758731 | 2021-09-27 | Washington | Idaho | 16087 | 1646 | 34 |
1755476 | 1755476 | 2021-09-26 | Owyhee | Idaho | 16073 | 1377 | 34 |
1752228 | 1752228 | 2021-09-25 | Owyhee | Idaho | 16073 | 1377 | 34 |
1748979 | 1748979 | 2021-09-24 | Owyhee | Idaho | 16073 | 1374 | 34 |
1745729 | 1745729 | 2021-09-23 | Owyhee | Idaho | 16073 | 1366 | 34 |
1742480 | 1742480 | 2021-09-22 | Owyhee | Idaho | 16073 | 1359 | 34 |
1739231 | 1739231 | 2021-09-21 | Owyhee | Idaho | 16073 | 1353 | 34 |
1735971 | 1735971 | 2021-09-20 | Jefferson | Idaho | 16051 | 3493 | 34 |
1732721 | 1732721 | 2021-09-19 | Jefferson | Idaho | 16051 | 3467 | 34 |
1729471 | 1729471 | 2021-09-18 | Jefferson | Idaho | 16051 | 3467 | 34 |
1726221 | 1726221 | 2021-09-17 | Jefferson | Idaho | 16051 | 3467 | 34 |
1722972 | 1722972 | 2021-09-16 | Jefferson | Idaho | 16051 | 3446 | 34 |
1693748 | 1693748 | 2021-09-07 | Minidoka | Idaho | 16067 | 2627 | 34 |
1690499 | 1690499 | 2021-09-06 | Minidoka | Idaho | 16067 | 2611 | 34 |
1687249 | 1687249 | 2021-09-05 | Minidoka | Idaho | 16067 | 2611 | 34 |
1683999 | 1683999 | 2021-09-04 | Minidoka | Idaho | 16067 | 2611 | 34 |
1680748 | 1680748 | 2021-09-03 | Minidoka | Idaho | 16067 | 2611 | 34 |
1677500 | 1677500 | 2021-09-02 | Minidoka | Idaho | 16067 | 2597 | 34 |
1674253 | 1674253 | 2021-09-01 | Minidoka | Idaho | 16067 | 2586 | 34 |
1671004 | 1671004 | 2021-08-31 | Minidoka | Idaho | 16067 | 2576 | 34 |
1667757 | 1667757 | 2021-08-30 | Minidoka | Idaho | 16067 | 2555 | 34 |
1664510 | 1664510 | 2021-08-29 | Minidoka | Idaho | 16067 | 2547 | 34 |
1661262 | 1661262 | 2021-08-28 | Minidoka | Idaho | 16067 | 2547 | 34 |
1658014 | 1658014 | 2021-08-27 | Minidoka | Idaho | 16067 | 2547 | 34 |
1654766 | 1654766 | 2021-08-26 | Minidoka | Idaho | 16067 | 2529 | 34 |
1651519 | 1651519 | 2021-08-25 | Minidoka | Idaho | 16067 | 2522 | 34 |
1648270 | 1648270 | 2021-08-24 | Minidoka | Idaho | 16067 | 2507 | 34 |
1645022 | 1645022 | 2021-08-23 | Minidoka | Idaho | 16067 | 2499 | 34 |
1641773 | 1641773 | 2021-08-22 | Minidoka | Idaho | 16067 | 2491 | 34 |
1638523 | 1638523 | 2021-08-21 | Minidoka | Idaho | 16067 | 2491 | 34 |
1635273 | 1635273 | 2021-08-20 | Minidoka | Idaho | 16067 | 2491 | 34 |
1632023 | 1632023 | 2021-08-19 | Minidoka | Idaho | 16067 | 2484 | 34 |
1628776 | 1628776 | 2021-08-18 | Minidoka | Idaho | 16067 | 2479 | 34 |
1625529 | 1625529 | 2021-08-17 | Minidoka | Idaho | 16067 | 2474 | 34 |
1622282 | 1622282 | 2021-08-16 | Minidoka | Idaho | 16067 | 2470 | 34 |
1619035 | 1619035 | 2021-08-15 | Minidoka | Idaho | 16067 | 2454 | 34 |
1615787 | 1615787 | 2021-08-14 | Minidoka | Idaho | 16067 | 2454 | 34 |
1612538 | 1612538 | 2021-08-13 | Minidoka | Idaho | 16067 | 2454 | 34 |
1609290 | 1609290 | 2021-08-12 | Minidoka | Idaho | 16067 | 2445 | 34 |
1606041 | 1606041 | 2021-08-11 | Minidoka | Idaho | 16067 | 2443 | 34 |
1602792 | 1602792 | 2021-08-10 | Minidoka | Idaho | 16067 | 2435 | 34 |
1599543 | 1599543 | 2021-08-09 | Minidoka | Idaho | 16067 | 2432 | 34 |
1596295 | 1596295 | 2021-08-08 | Minidoka | Idaho | 16067 | 2421 | 34 |
1593046 | 1593046 | 2021-08-07 | Minidoka | Idaho | 16067 | 2421 | 34 |
1589797 | 1589797 | 2021-08-06 | Minidoka | Idaho | 16067 | 2421 | 34 |
1586548 | 1586548 | 2021-08-05 | Minidoka | Idaho | 16067 | 2418 | 34 |
1583298 | 1583298 | 2021-08-04 | Minidoka | Idaho | 16067 | 2414 | 34 |
1580048 | 1580048 | 2021-08-03 | Minidoka | Idaho | 16067 | 2413 | 34 |
1576799 | 1576799 | 2021-08-02 | Minidoka | Idaho | 16067 | 2409 | 34 |
1573551 | 1573551 | 2021-08-01 | Minidoka | Idaho | 16067 | 2405 | 34 |
1570303 | 1570303 | 2021-07-31 | Minidoka | Idaho | 16067 | 2405 | 34 |
1567055 | 1567055 | 2021-07-30 | Minidoka | Idaho | 16067 | 2405 | 34 |
1563807 | 1563807 | 2021-07-29 | Minidoka | Idaho | 16067 | 2401 | 34 |
1560559 | 1560559 | 2021-07-28 | Minidoka | Idaho | 16067 | 2397 | 34 |
1437201 | 1437201 | 2021-06-20 | Shoshone | Idaho | 16079 | 1183 | 34 |
1433954 | 1433954 | 2021-06-19 | Shoshone | Idaho | 16079 | 1183 | 34 |
1430708 | 1430708 | 2021-06-18 | Shoshone | Idaho | 16079 | 1183 | 34 |
1427463 | 1427463 | 2021-06-17 | Shoshone | Idaho | 16079 | 1183 | 34 |
1424218 | 1424218 | 2021-06-16 | Shoshone | Idaho | 16079 | 1181 | 34 |
1420970 | 1420970 | 2021-06-15 | Shoshone | Idaho | 16079 | 1178 | 34 |
1417725 | 1417725 | 2021-06-14 | Shoshone | Idaho | 16079 | 1177 | 34 |
1414479 | 1414479 | 2021-06-13 | Shoshone | Idaho | 16079 | 1173 | 34 |
1411234 | 1411234 | 2021-06-12 | Shoshone | Idaho | 16079 | 1173 | 34 |
1407989 | 1407989 | 2021-06-11 | Shoshone | Idaho | 16079 | 1173 | 34 |
1404743 | 1404743 | 2021-06-10 | Shoshone | Idaho | 16079 | 1169 | 34 |
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);