ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 38059 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 |
---|---|---|---|---|---|---|---|
1948631 | 1948631 | 2021-11-24 | Morton | North Dakota | 38059 | 7981 | 124 |
1945380 | 1945380 | 2021-11-23 | Morton | North Dakota | 38059 | 7953 | 124 |
1942129 | 1942129 | 2021-11-22 | Morton | North Dakota | 38059 | 7931 | 124 |
1938879 | 1938879 | 2021-11-21 | Morton | North Dakota | 38059 | 7917 | 124 |
1935629 | 1935629 | 2021-11-20 | Morton | North Dakota | 38059 | 7910 | 124 |
1932379 | 1932379 | 2021-11-19 | Morton | North Dakota | 38059 | 7898 | 124 |
1929128 | 1929128 | 2021-11-18 | Morton | North Dakota | 38059 | 7881 | 123 |
1925878 | 1925878 | 2021-11-17 | Morton | North Dakota | 38059 | 7855 | 123 |
1922629 | 1922629 | 2021-11-16 | Morton | North Dakota | 38059 | 7830 | 122 |
1919379 | 1919379 | 2021-11-15 | Morton | North Dakota | 38059 | 7806 | 122 |
1916129 | 1916129 | 2021-11-14 | Morton | North Dakota | 38059 | 7795 | 122 |
1912879 | 1912879 | 2021-11-13 | Morton | North Dakota | 38059 | 7786 | 122 |
1909629 | 1909629 | 2021-11-12 | Morton | North Dakota | 38059 | 7772 | 120 |
1906380 | 1906380 | 2021-11-11 | Morton | North Dakota | 38059 | 7756 | 120 |
1903131 | 1903131 | 2021-11-10 | Morton | North Dakota | 38059 | 7728 | 120 |
1899881 | 1899881 | 2021-11-09 | Morton | North Dakota | 38059 | 7697 | 120 |
1896631 | 1896631 | 2021-11-08 | Morton | North Dakota | 38059 | 7664 | 119 |
1893381 | 1893381 | 2021-11-07 | Morton | North Dakota | 38059 | 7653 | 119 |
1890131 | 1890131 | 2021-11-06 | Morton | North Dakota | 38059 | 7640 | 119 |
1886881 | 1886881 | 2021-11-05 | Morton | North Dakota | 38059 | 7603 | 119 |
1883632 | 1883632 | 2021-11-04 | Morton | North Dakota | 38059 | 7580 | 119 |
1880383 | 1880383 | 2021-11-03 | Morton | North Dakota | 38059 | 7557 | 118 |
1877134 | 1877134 | 2021-11-02 | Morton | North Dakota | 38059 | 7523 | 117 |
1873885 | 1873885 | 2021-11-01 | Morton | North Dakota | 38059 | 7498 | 115 |
1870636 | 1870636 | 2021-10-31 | Morton | North Dakota | 38059 | 7488 | 115 |
1867387 | 1867387 | 2021-10-30 | Morton | North Dakota | 38059 | 7469 | 115 |
1864138 | 1864138 | 2021-10-29 | Morton | North Dakota | 38059 | 7452 | 115 |
1860889 | 1860889 | 2021-10-28 | Morton | North Dakota | 38059 | 7427 | 115 |
1857640 | 1857640 | 2021-10-27 | Morton | North Dakota | 38059 | 7391 | 115 |
1854391 | 1854391 | 2021-10-26 | Morton | North Dakota | 38059 | 7353 | 115 |
1851142 | 1851142 | 2021-10-25 | Morton | North Dakota | 38059 | 7317 | 114 |
1847892 | 1847892 | 2021-10-24 | Morton | North Dakota | 38059 | 7299 | 114 |
1844642 | 1844642 | 2021-10-23 | Morton | North Dakota | 38059 | 7288 | 114 |
1841392 | 1841392 | 2021-10-22 | Morton | North Dakota | 38059 | 7278 | 114 |
1838143 | 1838143 | 2021-10-21 | Morton | North Dakota | 38059 | 7249 | 113 |
1834894 | 1834894 | 2021-10-20 | Morton | North Dakota | 38059 | 7207 | 112 |
1831645 | 1831645 | 2021-10-19 | Morton | North Dakota | 38059 | 7175 | 112 |
1828396 | 1828396 | 2021-10-18 | Morton | North Dakota | 38059 | 7147 | 110 |
1825147 | 1825147 | 2021-10-17 | Morton | North Dakota | 38059 | 7132 | 110 |
1821898 | 1821898 | 2021-10-16 | Morton | North Dakota | 38059 | 7119 | 110 |
1818649 | 1818649 | 2021-10-15 | Morton | North Dakota | 38059 | 7100 | 107 |
1815400 | 1815400 | 2021-10-14 | Morton | North Dakota | 38059 | 7067 | 105 |
1812152 | 1812152 | 2021-10-13 | Morton | North Dakota | 38059 | 7046 | 105 |
1808903 | 1808903 | 2021-10-12 | Morton | North Dakota | 38059 | 7015 | 105 |
1805652 | 1805652 | 2021-10-11 | Morton | North Dakota | 38059 | 6976 | 105 |
1802403 | 1802403 | 2021-10-10 | Morton | North Dakota | 38059 | 6951 | 105 |
1799154 | 1799154 | 2021-10-09 | Morton | North Dakota | 38059 | 6929 | 105 |
1795905 | 1795905 | 2021-10-08 | Morton | North Dakota | 38059 | 6899 | 104 |
1792656 | 1792656 | 2021-10-07 | Morton | North Dakota | 38059 | 6861 | 104 |
1789407 | 1789407 | 2021-10-06 | Morton | North Dakota | 38059 | 6823 | 104 |
1786159 | 1786159 | 2021-10-05 | Morton | North Dakota | 38059 | 6761 | 104 |
1782910 | 1782910 | 2021-10-04 | Morton | North Dakota | 38059 | 6711 | 104 |
1779661 | 1779661 | 2021-10-03 | Morton | North Dakota | 38059 | 6681 | 104 |
1776411 | 1776411 | 2021-10-02 | Morton | North Dakota | 38059 | 6662 | 104 |
1773161 | 1773161 | 2021-10-01 | Morton | North Dakota | 38059 | 6615 | 104 |
1769911 | 1769911 | 2021-09-30 | Morton | North Dakota | 38059 | 6562 | 104 |
1766662 | 1766662 | 2021-09-29 | Morton | North Dakota | 38059 | 6505 | 104 |
1763413 | 1763413 | 2021-09-28 | Morton | North Dakota | 38059 | 6435 | 104 |
1760164 | 1760164 | 2021-09-27 | Morton | North Dakota | 38059 | 6390 | 104 |
1756916 | 1756916 | 2021-09-26 | Morton | North Dakota | 38059 | 6364 | 104 |
1753668 | 1753668 | 2021-09-25 | Morton | North Dakota | 38059 | 6344 | 104 |
1750420 | 1750420 | 2021-09-24 | Morton | North Dakota | 38059 | 6302 | 104 |
1747170 | 1747170 | 2021-09-23 | Morton | North Dakota | 38059 | 6256 | 104 |
1743921 | 1743921 | 2021-09-22 | Morton | North Dakota | 38059 | 6210 | 104 |
1740672 | 1740672 | 2021-09-21 | Morton | North Dakota | 38059 | 6164 | 104 |
1737423 | 1737423 | 2021-09-20 | Morton | North Dakota | 38059 | 6124 | 104 |
1734173 | 1734173 | 2021-09-19 | Morton | North Dakota | 38059 | 6103 | 104 |
1730923 | 1730923 | 2021-09-18 | Morton | North Dakota | 38059 | 6086 | 104 |
1727673 | 1727673 | 2021-09-17 | Morton | North Dakota | 38059 | 6067 | 104 |
1724424 | 1724424 | 2021-09-16 | Morton | North Dakota | 38059 | 6050 | 104 |
1721175 | 1721175 | 2021-09-15 | Morton | North Dakota | 38059 | 6015 | 102 |
1717927 | 1717927 | 2021-09-14 | Morton | North Dakota | 38059 | 5961 | 102 |
1714679 | 1714679 | 2021-09-13 | Morton | North Dakota | 38059 | 5939 | 102 |
1711433 | 1711433 | 2021-09-12 | Morton | North Dakota | 38059 | 5928 | 102 |
1708186 | 1708186 | 2021-09-11 | Morton | North Dakota | 38059 | 5915 | 102 |
1704939 | 1704939 | 2021-09-10 | Morton | North Dakota | 38059 | 5884 | 102 |
1701689 | 1701689 | 2021-09-09 | Morton | North Dakota | 38059 | 5848 | 102 |
1698440 | 1698440 | 2021-09-08 | Morton | North Dakota | 38059 | 5822 | 102 |
1695192 | 1695192 | 2021-09-07 | Morton | North Dakota | 38059 | 5795 | 102 |
1691944 | 1691944 | 2021-09-06 | Morton | North Dakota | 38059 | 5782 | 102 |
1688694 | 1688694 | 2021-09-05 | Morton | North Dakota | 38059 | 5775 | 102 |
1685444 | 1685444 | 2021-09-04 | Morton | North Dakota | 38059 | 5768 | 102 |
1682193 | 1682193 | 2021-09-03 | Morton | North Dakota | 38059 | 5757 | 102 |
1678944 | 1678944 | 2021-09-02 | Morton | North Dakota | 38059 | 5733 | 102 |
1675696 | 1675696 | 2021-09-01 | Morton | North Dakota | 38059 | 5706 | 102 |
1672449 | 1672449 | 2021-08-31 | Morton | North Dakota | 38059 | 5685 | 102 |
1669201 | 1669201 | 2021-08-30 | Morton | North Dakota | 38059 | 5663 | 102 |
1665954 | 1665954 | 2021-08-29 | Morton | North Dakota | 38059 | 5647 | 102 |
1662706 | 1662706 | 2021-08-28 | Morton | North Dakota | 38059 | 5631 | 102 |
1659458 | 1659458 | 2021-08-27 | Morton | North Dakota | 38059 | 5606 | 102 |
1656209 | 1656209 | 2021-08-26 | Morton | North Dakota | 38059 | 5603 | 102 |
1652962 | 1652962 | 2021-08-25 | Morton | North Dakota | 38059 | 5589 | 102 |
1649714 | 1649714 | 2021-08-24 | Morton | North Dakota | 38059 | 5571 | 102 |
1646465 | 1646465 | 2021-08-23 | Morton | North Dakota | 38059 | 5546 | 102 |
1643216 | 1643216 | 2021-08-22 | Morton | North Dakota | 38059 | 5537 | 102 |
1639966 | 1639966 | 2021-08-21 | Morton | North Dakota | 38059 | 5536 | 102 |
1636716 | 1636716 | 2021-08-20 | Morton | North Dakota | 38059 | 5529 | 102 |
1633466 | 1633466 | 2021-08-19 | Morton | North Dakota | 38059 | 5519 | 102 |
1630219 | 1630219 | 2021-08-18 | Morton | North Dakota | 38059 | 5508 | 102 |
1626972 | 1626972 | 2021-08-17 | Morton | North Dakota | 38059 | 5499 | 102 |
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);