ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where fips = 38105 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 |
---|---|---|---|---|---|---|---|
1948655 | 1948655 | 2021-11-24 | Williams | North Dakota | 38105 | 7504 | 54 |
1945404 | 1945404 | 2021-11-23 | Williams | North Dakota | 38105 | 7490 | 54 |
1942153 | 1942153 | 2021-11-22 | Williams | North Dakota | 38105 | 7459 | 54 |
1938903 | 1938903 | 2021-11-21 | Williams | North Dakota | 38105 | 7449 | 54 |
1935653 | 1935653 | 2021-11-20 | Williams | North Dakota | 38105 | 7428 | 54 |
1932403 | 1932403 | 2021-11-19 | Williams | North Dakota | 38105 | 7399 | 54 |
1929152 | 1929152 | 2021-11-18 | Williams | North Dakota | 38105 | 7376 | 54 |
1925902 | 1925902 | 2021-11-17 | Williams | North Dakota | 38105 | 7322 | 54 |
1922653 | 1922653 | 2021-11-16 | Williams | North Dakota | 38105 | 7286 | 54 |
1919403 | 1919403 | 2021-11-15 | Williams | North Dakota | 38105 | 7255 | 54 |
1916153 | 1916153 | 2021-11-14 | Williams | North Dakota | 38105 | 7253 | 54 |
1912903 | 1912903 | 2021-11-13 | Williams | North Dakota | 38105 | 7247 | 54 |
1909653 | 1909653 | 2021-11-12 | Williams | North Dakota | 38105 | 7205 | 54 |
1906404 | 1906404 | 2021-11-11 | Williams | North Dakota | 38105 | 7185 | 54 |
1903155 | 1903155 | 2021-11-10 | Williams | North Dakota | 38105 | 7141 | 53 |
1899905 | 1899905 | 2021-11-09 | Williams | North Dakota | 38105 | 7103 | 52 |
1896655 | 1896655 | 2021-11-08 | Williams | North Dakota | 38105 | 7074 | 52 |
1893405 | 1893405 | 2021-11-07 | Williams | North Dakota | 38105 | 7066 | 52 |
1890155 | 1890155 | 2021-11-06 | Williams | North Dakota | 38105 | 7053 | 52 |
1886905 | 1886905 | 2021-11-05 | Williams | North Dakota | 38105 | 7034 | 52 |
1883656 | 1883656 | 2021-11-04 | Williams | North Dakota | 38105 | 7008 | 51 |
1880407 | 1880407 | 2021-11-03 | Williams | North Dakota | 38105 | 6980 | 51 |
1877158 | 1877158 | 2021-11-02 | Williams | North Dakota | 38105 | 6957 | 51 |
1873909 | 1873909 | 2021-11-01 | Williams | North Dakota | 38105 | 6930 | 51 |
1870660 | 1870660 | 2021-10-31 | Williams | North Dakota | 38105 | 6926 | 51 |
1867411 | 1867411 | 2021-10-30 | Williams | North Dakota | 38105 | 6910 | 51 |
1864162 | 1864162 | 2021-10-29 | Williams | North Dakota | 38105 | 6874 | 51 |
1860913 | 1860913 | 2021-10-28 | Williams | North Dakota | 38105 | 6853 | 51 |
1857664 | 1857664 | 2021-10-27 | Williams | North Dakota | 38105 | 6817 | 51 |
1854415 | 1854415 | 2021-10-26 | Williams | North Dakota | 38105 | 6788 | 51 |
1851166 | 1851166 | 2021-10-25 | Williams | North Dakota | 38105 | 6758 | 49 |
1847916 | 1847916 | 2021-10-24 | Williams | North Dakota | 38105 | 6746 | 49 |
1844666 | 1844666 | 2021-10-23 | Williams | North Dakota | 38105 | 6742 | 49 |
1841416 | 1841416 | 2021-10-22 | Williams | North Dakota | 38105 | 6730 | 49 |
1838167 | 1838167 | 2021-10-21 | Williams | North Dakota | 38105 | 6704 | 49 |
1834918 | 1834918 | 2021-10-20 | Williams | North Dakota | 38105 | 6680 | 49 |
1831669 | 1831669 | 2021-10-19 | Williams | North Dakota | 38105 | 6647 | 48 |
1828420 | 1828420 | 2021-10-18 | Williams | North Dakota | 38105 | 6618 | 48 |
1825171 | 1825171 | 2021-10-17 | Williams | North Dakota | 38105 | 6607 | 48 |
1821922 | 1821922 | 2021-10-16 | Williams | North Dakota | 38105 | 6587 | 48 |
1818673 | 1818673 | 2021-10-15 | Williams | North Dakota | 38105 | 6564 | 48 |
1815424 | 1815424 | 2021-10-14 | Williams | North Dakota | 38105 | 6525 | 48 |
1812176 | 1812176 | 2021-10-13 | Williams | North Dakota | 38105 | 6485 | 48 |
1808927 | 1808927 | 2021-10-12 | Williams | North Dakota | 38105 | 6448 | 47 |
1805676 | 1805676 | 2021-10-11 | Williams | North Dakota | 38105 | 6410 | 46 |
1802427 | 1802427 | 2021-10-10 | Williams | North Dakota | 38105 | 6394 | 46 |
1799178 | 1799178 | 2021-10-09 | Williams | North Dakota | 38105 | 6376 | 46 |
1795929 | 1795929 | 2021-10-08 | Williams | North Dakota | 38105 | 6363 | 46 |
1792680 | 1792680 | 2021-10-07 | Williams | North Dakota | 38105 | 6317 | 46 |
1789431 | 1789431 | 2021-10-06 | Williams | North Dakota | 38105 | 6265 | 45 |
1786183 | 1786183 | 2021-10-05 | Williams | North Dakota | 38105 | 6224 | 44 |
1782934 | 1782934 | 2021-10-04 | Williams | North Dakota | 38105 | 6181 | 43 |
1779685 | 1779685 | 2021-10-03 | Williams | North Dakota | 38105 | 6171 | 43 |
1776435 | 1776435 | 2021-10-02 | Williams | North Dakota | 38105 | 6159 | 43 |
1773185 | 1773185 | 2021-10-01 | Williams | North Dakota | 38105 | 6138 | 43 |
1769935 | 1769935 | 2021-09-30 | Williams | North Dakota | 38105 | 6106 | 43 |
1766686 | 1766686 | 2021-09-29 | Williams | North Dakota | 38105 | 6076 | 43 |
1763437 | 1763437 | 2021-09-28 | Williams | North Dakota | 38105 | 6046 | 43 |
1760188 | 1760188 | 2021-09-27 | Williams | North Dakota | 38105 | 6000 | 43 |
1756940 | 1756940 | 2021-09-26 | Williams | North Dakota | 38105 | 5991 | 43 |
1753692 | 1753692 | 2021-09-25 | Williams | North Dakota | 38105 | 5972 | 43 |
1750444 | 1750444 | 2021-09-24 | Williams | North Dakota | 38105 | 5931 | 43 |
1747194 | 1747194 | 2021-09-23 | Williams | North Dakota | 38105 | 5905 | 43 |
1743945 | 1743945 | 2021-09-22 | Williams | North Dakota | 38105 | 5869 | 43 |
1740696 | 1740696 | 2021-09-21 | Williams | North Dakota | 38105 | 5846 | 43 |
1737447 | 1737447 | 2021-09-20 | Williams | North Dakota | 38105 | 5830 | 43 |
1734197 | 1734197 | 2021-09-19 | Williams | North Dakota | 38105 | 5825 | 43 |
1730947 | 1730947 | 2021-09-18 | Williams | North Dakota | 38105 | 5810 | 43 |
1727697 | 1727697 | 2021-09-17 | Williams | North Dakota | 38105 | 5776 | 42 |
1724448 | 1724448 | 2021-09-16 | Williams | North Dakota | 38105 | 5764 | 42 |
1721199 | 1721199 | 2021-09-15 | Williams | North Dakota | 38105 | 5730 | 42 |
1717951 | 1717951 | 2021-09-14 | Williams | North Dakota | 38105 | 5691 | 42 |
1714703 | 1714703 | 2021-09-13 | Williams | North Dakota | 38105 | 5681 | 42 |
1711457 | 1711457 | 2021-09-12 | Williams | North Dakota | 38105 | 5678 | 42 |
1708210 | 1708210 | 2021-09-11 | Williams | North Dakota | 38105 | 5667 | 42 |
1704963 | 1704963 | 2021-09-10 | Williams | North Dakota | 38105 | 5646 | 42 |
1701713 | 1701713 | 2021-09-09 | Williams | North Dakota | 38105 | 5605 | 42 |
1698464 | 1698464 | 2021-09-08 | Williams | North Dakota | 38105 | 5572 | 42 |
1695216 | 1695216 | 2021-09-07 | Williams | North Dakota | 38105 | 5558 | 42 |
1691968 | 1691968 | 2021-09-06 | Williams | North Dakota | 38105 | 5545 | 42 |
1688718 | 1688718 | 2021-09-05 | Williams | North Dakota | 38105 | 5541 | 42 |
1685468 | 1685468 | 2021-09-04 | Williams | North Dakota | 38105 | 5530 | 42 |
1682217 | 1682217 | 2021-09-03 | Williams | North Dakota | 38105 | 5494 | 42 |
1678968 | 1678968 | 2021-09-02 | Williams | North Dakota | 38105 | 5468 | 42 |
1675720 | 1675720 | 2021-09-01 | Williams | North Dakota | 38105 | 5423 | 42 |
1672473 | 1672473 | 2021-08-31 | Williams | North Dakota | 38105 | 5392 | 42 |
1669225 | 1669225 | 2021-08-30 | Williams | North Dakota | 38105 | 5379 | 42 |
1665978 | 1665978 | 2021-08-29 | Williams | North Dakota | 38105 | 5373 | 42 |
1662730 | 1662730 | 2021-08-28 | Williams | North Dakota | 38105 | 5362 | 42 |
1659482 | 1659482 | 2021-08-27 | Williams | North Dakota | 38105 | 5328 | 42 |
1656233 | 1656233 | 2021-08-26 | Williams | North Dakota | 38105 | 5309 | 42 |
1652986 | 1652986 | 2021-08-25 | Williams | North Dakota | 38105 | 5275 | 42 |
1649738 | 1649738 | 2021-08-24 | Williams | North Dakota | 38105 | 5253 | 42 |
1646489 | 1646489 | 2021-08-23 | Williams | North Dakota | 38105 | 5229 | 41 |
1643240 | 1643240 | 2021-08-22 | Williams | North Dakota | 38105 | 5222 | 41 |
1639990 | 1639990 | 2021-08-21 | Williams | North Dakota | 38105 | 5217 | 41 |
1636740 | 1636740 | 2021-08-20 | Williams | North Dakota | 38105 | 5200 | 41 |
1633490 | 1633490 | 2021-08-19 | Williams | North Dakota | 38105 | 5191 | 40 |
1630243 | 1630243 | 2021-08-18 | Williams | North Dakota | 38105 | 5177 | 40 |
1626996 | 1626996 | 2021-08-17 | Williams | North Dakota | 38105 | 5161 | 40 |
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);