ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
291 rows where county = "Bottineau", deaths = 20, fips = 38009 and state = "North Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1818624 | 1818624 | 2021-10-15 | Bottineau | North Dakota | 38009 | 938 | 20 |
1815375 | 1815375 | 2021-10-14 | Bottineau | North Dakota | 38009 | 934 | 20 |
1812127 | 1812127 | 2021-10-13 | Bottineau | North Dakota | 38009 | 934 | 20 |
1808878 | 1808878 | 2021-10-12 | Bottineau | North Dakota | 38009 | 931 | 20 |
1805627 | 1805627 | 2021-10-11 | Bottineau | North Dakota | 38009 | 928 | 20 |
1802378 | 1802378 | 2021-10-10 | Bottineau | North Dakota | 38009 | 926 | 20 |
1799129 | 1799129 | 2021-10-09 | Bottineau | North Dakota | 38009 | 920 | 20 |
1795880 | 1795880 | 2021-10-08 | Bottineau | North Dakota | 38009 | 916 | 20 |
1792631 | 1792631 | 2021-10-07 | Bottineau | North Dakota | 38009 | 913 | 20 |
1789382 | 1789382 | 2021-10-06 | Bottineau | North Dakota | 38009 | 910 | 20 |
1786134 | 1786134 | 2021-10-05 | Bottineau | North Dakota | 38009 | 906 | 20 |
1782885 | 1782885 | 2021-10-04 | Bottineau | North Dakota | 38009 | 903 | 20 |
1779636 | 1779636 | 2021-10-03 | Bottineau | North Dakota | 38009 | 901 | 20 |
1776386 | 1776386 | 2021-10-02 | Bottineau | North Dakota | 38009 | 900 | 20 |
1773136 | 1773136 | 2021-10-01 | Bottineau | North Dakota | 38009 | 894 | 20 |
1769886 | 1769886 | 2021-09-30 | Bottineau | North Dakota | 38009 | 889 | 20 |
1766637 | 1766637 | 2021-09-29 | Bottineau | North Dakota | 38009 | 882 | 20 |
1763388 | 1763388 | 2021-09-28 | Bottineau | North Dakota | 38009 | 877 | 20 |
1760139 | 1760139 | 2021-09-27 | Bottineau | North Dakota | 38009 | 871 | 20 |
1756891 | 1756891 | 2021-09-26 | Bottineau | North Dakota | 38009 | 871 | 20 |
1753643 | 1753643 | 2021-09-25 | Bottineau | North Dakota | 38009 | 866 | 20 |
1750395 | 1750395 | 2021-09-24 | Bottineau | North Dakota | 38009 | 859 | 20 |
1747145 | 1747145 | 2021-09-23 | Bottineau | North Dakota | 38009 | 846 | 20 |
1743896 | 1743896 | 2021-09-22 | Bottineau | North Dakota | 38009 | 835 | 20 |
1740647 | 1740647 | 2021-09-21 | Bottineau | North Dakota | 38009 | 827 | 20 |
1737398 | 1737398 | 2021-09-20 | Bottineau | North Dakota | 38009 | 817 | 20 |
1734148 | 1734148 | 2021-09-19 | Bottineau | North Dakota | 38009 | 818 | 20 |
1730898 | 1730898 | 2021-09-18 | Bottineau | North Dakota | 38009 | 814 | 20 |
1727648 | 1727648 | 2021-09-17 | Bottineau | North Dakota | 38009 | 810 | 20 |
1724399 | 1724399 | 2021-09-16 | Bottineau | North Dakota | 38009 | 806 | 20 |
1721150 | 1721150 | 2021-09-15 | Bottineau | North Dakota | 38009 | 798 | 20 |
1717902 | 1717902 | 2021-09-14 | Bottineau | North Dakota | 38009 | 790 | 20 |
1714654 | 1714654 | 2021-09-13 | Bottineau | North Dakota | 38009 | 790 | 20 |
1711408 | 1711408 | 2021-09-12 | Bottineau | North Dakota | 38009 | 790 | 20 |
1708161 | 1708161 | 2021-09-11 | Bottineau | North Dakota | 38009 | 790 | 20 |
1704914 | 1704914 | 2021-09-10 | Bottineau | North Dakota | 38009 | 789 | 20 |
1701664 | 1701664 | 2021-09-09 | Bottineau | North Dakota | 38009 | 786 | 20 |
1698415 | 1698415 | 2021-09-08 | Bottineau | North Dakota | 38009 | 781 | 20 |
1695167 | 1695167 | 2021-09-07 | Bottineau | North Dakota | 38009 | 781 | 20 |
1691919 | 1691919 | 2021-09-06 | Bottineau | North Dakota | 38009 | 780 | 20 |
1688669 | 1688669 | 2021-09-05 | Bottineau | North Dakota | 38009 | 780 | 20 |
1685419 | 1685419 | 2021-09-04 | Bottineau | North Dakota | 38009 | 780 | 20 |
1682168 | 1682168 | 2021-09-03 | Bottineau | North Dakota | 38009 | 777 | 20 |
1678919 | 1678919 | 2021-09-02 | Bottineau | North Dakota | 38009 | 777 | 20 |
1675671 | 1675671 | 2021-09-01 | Bottineau | North Dakota | 38009 | 776 | 20 |
1672424 | 1672424 | 2021-08-31 | Bottineau | North Dakota | 38009 | 775 | 20 |
1669176 | 1669176 | 2021-08-30 | Bottineau | North Dakota | 38009 | 772 | 20 |
1665929 | 1665929 | 2021-08-29 | Bottineau | North Dakota | 38009 | 772 | 20 |
1662681 | 1662681 | 2021-08-28 | Bottineau | North Dakota | 38009 | 770 | 20 |
1659433 | 1659433 | 2021-08-27 | Bottineau | North Dakota | 38009 | 768 | 20 |
1656184 | 1656184 | 2021-08-26 | Bottineau | North Dakota | 38009 | 767 | 20 |
1652937 | 1652937 | 2021-08-25 | Bottineau | North Dakota | 38009 | 765 | 20 |
1649689 | 1649689 | 2021-08-24 | Bottineau | North Dakota | 38009 | 765 | 20 |
1646440 | 1646440 | 2021-08-23 | Bottineau | North Dakota | 38009 | 764 | 20 |
1643191 | 1643191 | 2021-08-22 | Bottineau | North Dakota | 38009 | 762 | 20 |
1639941 | 1639941 | 2021-08-21 | Bottineau | North Dakota | 38009 | 762 | 20 |
1636691 | 1636691 | 2021-08-20 | Bottineau | North Dakota | 38009 | 760 | 20 |
1633441 | 1633441 | 2021-08-19 | Bottineau | North Dakota | 38009 | 749 | 20 |
1630194 | 1630194 | 2021-08-18 | Bottineau | North Dakota | 38009 | 749 | 20 |
1626947 | 1626947 | 2021-08-17 | Bottineau | North Dakota | 38009 | 746 | 20 |
1623700 | 1623700 | 2021-08-16 | Bottineau | North Dakota | 38009 | 744 | 20 |
1620453 | 1620453 | 2021-08-15 | Bottineau | North Dakota | 38009 | 744 | 20 |
1617205 | 1617205 | 2021-08-14 | Bottineau | North Dakota | 38009 | 743 | 20 |
1613957 | 1613957 | 2021-08-13 | Bottineau | North Dakota | 38009 | 741 | 20 |
1610708 | 1610708 | 2021-08-12 | Bottineau | North Dakota | 38009 | 741 | 20 |
1607460 | 1607460 | 2021-08-11 | Bottineau | North Dakota | 38009 | 740 | 20 |
1604211 | 1604211 | 2021-08-10 | Bottineau | North Dakota | 38009 | 737 | 20 |
1600962 | 1600962 | 2021-08-09 | Bottineau | North Dakota | 38009 | 737 | 20 |
1597714 | 1597714 | 2021-08-08 | Bottineau | North Dakota | 38009 | 737 | 20 |
1594465 | 1594465 | 2021-08-07 | Bottineau | North Dakota | 38009 | 737 | 20 |
1591216 | 1591216 | 2021-08-06 | Bottineau | North Dakota | 38009 | 736 | 20 |
1587967 | 1587967 | 2021-08-05 | Bottineau | North Dakota | 38009 | 733 | 20 |
1584717 | 1584717 | 2021-08-04 | Bottineau | North Dakota | 38009 | 731 | 20 |
1581467 | 1581467 | 2021-08-03 | Bottineau | North Dakota | 38009 | 729 | 20 |
1578218 | 1578218 | 2021-08-02 | Bottineau | North Dakota | 38009 | 727 | 20 |
1574970 | 1574970 | 2021-08-01 | Bottineau | North Dakota | 38009 | 727 | 20 |
1571722 | 1571722 | 2021-07-31 | Bottineau | North Dakota | 38009 | 727 | 20 |
1568474 | 1568474 | 2021-07-30 | Bottineau | North Dakota | 38009 | 726 | 20 |
1565226 | 1565226 | 2021-07-29 | Bottineau | North Dakota | 38009 | 726 | 20 |
1561978 | 1561978 | 2021-07-28 | Bottineau | North Dakota | 38009 | 725 | 20 |
1558730 | 1558730 | 2021-07-27 | Bottineau | North Dakota | 38009 | 725 | 20 |
1555483 | 1555483 | 2021-07-26 | Bottineau | North Dakota | 38009 | 725 | 20 |
1552236 | 1552236 | 2021-07-25 | Bottineau | North Dakota | 38009 | 725 | 20 |
1548989 | 1548989 | 2021-07-24 | Bottineau | North Dakota | 38009 | 725 | 20 |
1545742 | 1545742 | 2021-07-23 | Bottineau | North Dakota | 38009 | 725 | 20 |
1542495 | 1542495 | 2021-07-22 | Bottineau | North Dakota | 38009 | 725 | 20 |
1539247 | 1539247 | 2021-07-21 | Bottineau | North Dakota | 38009 | 725 | 20 |
1536000 | 1536000 | 2021-07-20 | Bottineau | North Dakota | 38009 | 725 | 20 |
1532752 | 1532752 | 2021-07-19 | Bottineau | North Dakota | 38009 | 725 | 20 |
1529505 | 1529505 | 2021-07-18 | Bottineau | North Dakota | 38009 | 725 | 20 |
1526258 | 1526258 | 2021-07-17 | Bottineau | North Dakota | 38009 | 725 | 20 |
1523011 | 1523011 | 2021-07-16 | Bottineau | North Dakota | 38009 | 724 | 20 |
1519763 | 1519763 | 2021-07-15 | Bottineau | North Dakota | 38009 | 724 | 20 |
1516515 | 1516515 | 2021-07-14 | Bottineau | North Dakota | 38009 | 724 | 20 |
1513268 | 1513268 | 2021-07-13 | Bottineau | North Dakota | 38009 | 724 | 20 |
1510022 | 1510022 | 2021-07-12 | Bottineau | North Dakota | 38009 | 724 | 20 |
1506775 | 1506775 | 2021-07-11 | Bottineau | North Dakota | 38009 | 724 | 20 |
1503529 | 1503529 | 2021-07-10 | Bottineau | North Dakota | 38009 | 724 | 20 |
1500283 | 1500283 | 2021-07-09 | Bottineau | North Dakota | 38009 | 724 | 20 |
1497037 | 1497037 | 2021-07-08 | Bottineau | North Dakota | 38009 | 724 | 20 |
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);