ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "McLean" 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 |
---|---|---|---|---|---|---|---|
1948629 | 1948629 | 2021-11-24 | McLean | North Dakota | 38055 | 2040 | 44 |
1945378 | 1945378 | 2021-11-23 | McLean | North Dakota | 38055 | 2031 | 43 |
1942127 | 1942127 | 2021-11-22 | McLean | North Dakota | 38055 | 2013 | 43 |
1938877 | 1938877 | 2021-11-21 | McLean | North Dakota | 38055 | 2009 | 43 |
1935627 | 1935627 | 2021-11-20 | McLean | North Dakota | 38055 | 2009 | 43 |
1932377 | 1932377 | 2021-11-19 | McLean | North Dakota | 38055 | 1999 | 43 |
1929126 | 1929126 | 2021-11-18 | McLean | North Dakota | 38055 | 1988 | 42 |
1925876 | 1925876 | 2021-11-17 | McLean | North Dakota | 38055 | 1978 | 42 |
1922627 | 1922627 | 2021-11-16 | McLean | North Dakota | 38055 | 1966 | 42 |
1919377 | 1919377 | 2021-11-15 | McLean | North Dakota | 38055 | 1955 | 41 |
1916127 | 1916127 | 2021-11-14 | McLean | North Dakota | 38055 | 1951 | 41 |
1912877 | 1912877 | 2021-11-13 | McLean | North Dakota | 38055 | 1949 | 41 |
1909627 | 1909627 | 2021-11-12 | McLean | North Dakota | 38055 | 1934 | 41 |
1906378 | 1906378 | 2021-11-11 | McLean | North Dakota | 38055 | 1931 | 41 |
1903129 | 1903129 | 2021-11-10 | McLean | North Dakota | 38055 | 1914 | 41 |
1899879 | 1899879 | 2021-11-09 | McLean | North Dakota | 38055 | 1912 | 40 |
1896629 | 1896629 | 2021-11-08 | McLean | North Dakota | 38055 | 1901 | 40 |
1893379 | 1893379 | 2021-11-07 | McLean | North Dakota | 38055 | 1900 | 40 |
1890129 | 1890129 | 2021-11-06 | McLean | North Dakota | 38055 | 1897 | 40 |
1886879 | 1886879 | 2021-11-05 | McLean | North Dakota | 38055 | 1890 | 40 |
1883630 | 1883630 | 2021-11-04 | McLean | North Dakota | 38055 | 1881 | 40 |
1880381 | 1880381 | 2021-11-03 | McLean | North Dakota | 38055 | 1874 | 40 |
1877132 | 1877132 | 2021-11-02 | McLean | North Dakota | 38055 | 1863 | 40 |
1873883 | 1873883 | 2021-11-01 | McLean | North Dakota | 38055 | 1853 | 40 |
1870634 | 1870634 | 2021-10-31 | McLean | North Dakota | 38055 | 1848 | 40 |
1867385 | 1867385 | 2021-10-30 | McLean | North Dakota | 38055 | 1842 | 40 |
1864136 | 1864136 | 2021-10-29 | McLean | North Dakota | 38055 | 1832 | 40 |
1860887 | 1860887 | 2021-10-28 | McLean | North Dakota | 38055 | 1821 | 40 |
1857638 | 1857638 | 2021-10-27 | McLean | North Dakota | 38055 | 1813 | 39 |
1854389 | 1854389 | 2021-10-26 | McLean | North Dakota | 38055 | 1799 | 39 |
1851140 | 1851140 | 2021-10-25 | McLean | North Dakota | 38055 | 1789 | 37 |
1847890 | 1847890 | 2021-10-24 | McLean | North Dakota | 38055 | 1784 | 37 |
1844640 | 1844640 | 2021-10-23 | McLean | North Dakota | 38055 | 1783 | 37 |
1841390 | 1841390 | 2021-10-22 | McLean | North Dakota | 38055 | 1775 | 36 |
1838141 | 1838141 | 2021-10-21 | McLean | North Dakota | 38055 | 1755 | 35 |
1834892 | 1834892 | 2021-10-20 | McLean | North Dakota | 38055 | 1748 | 34 |
1831643 | 1831643 | 2021-10-19 | McLean | North Dakota | 38055 | 1741 | 34 |
1828394 | 1828394 | 2021-10-18 | McLean | North Dakota | 38055 | 1727 | 33 |
1825145 | 1825145 | 2021-10-17 | McLean | North Dakota | 38055 | 1721 | 33 |
1821896 | 1821896 | 2021-10-16 | McLean | North Dakota | 38055 | 1717 | 33 |
1818647 | 1818647 | 2021-10-15 | McLean | North Dakota | 38055 | 1709 | 33 |
1815398 | 1815398 | 2021-10-14 | McLean | North Dakota | 38055 | 1704 | 33 |
1812150 | 1812150 | 2021-10-13 | McLean | North Dakota | 38055 | 1698 | 33 |
1808901 | 1808901 | 2021-10-12 | McLean | North Dakota | 38055 | 1681 | 33 |
1805650 | 1805650 | 2021-10-11 | McLean | North Dakota | 38055 | 1665 | 33 |
1802401 | 1802401 | 2021-10-10 | McLean | North Dakota | 38055 | 1657 | 33 |
1799152 | 1799152 | 2021-10-09 | McLean | North Dakota | 38055 | 1650 | 33 |
1795903 | 1795903 | 2021-10-08 | McLean | North Dakota | 38055 | 1643 | 33 |
1792654 | 1792654 | 2021-10-07 | McLean | North Dakota | 38055 | 1625 | 33 |
1789405 | 1789405 | 2021-10-06 | McLean | North Dakota | 38055 | 1615 | 33 |
1786157 | 1786157 | 2021-10-05 | McLean | North Dakota | 38055 | 1603 | 33 |
1782908 | 1782908 | 2021-10-04 | McLean | North Dakota | 38055 | 1589 | 33 |
1779659 | 1779659 | 2021-10-03 | McLean | North Dakota | 38055 | 1586 | 33 |
1776409 | 1776409 | 2021-10-02 | McLean | North Dakota | 38055 | 1586 | 33 |
1773159 | 1773159 | 2021-10-01 | McLean | North Dakota | 38055 | 1579 | 33 |
1769909 | 1769909 | 2021-09-30 | McLean | North Dakota | 38055 | 1574 | 33 |
1766660 | 1766660 | 2021-09-29 | McLean | North Dakota | 38055 | 1570 | 33 |
1763411 | 1763411 | 2021-09-28 | McLean | North Dakota | 38055 | 1563 | 33 |
1760162 | 1760162 | 2021-09-27 | McLean | North Dakota | 38055 | 1555 | 33 |
1756914 | 1756914 | 2021-09-26 | McLean | North Dakota | 38055 | 1552 | 33 |
1753666 | 1753666 | 2021-09-25 | McLean | North Dakota | 38055 | 1550 | 33 |
1750418 | 1750418 | 2021-09-24 | McLean | North Dakota | 38055 | 1542 | 32 |
1747168 | 1747168 | 2021-09-23 | McLean | North Dakota | 38055 | 1534 | 32 |
1743919 | 1743919 | 2021-09-22 | McLean | North Dakota | 38055 | 1524 | 32 |
1740670 | 1740670 | 2021-09-21 | McLean | North Dakota | 38055 | 1521 | 32 |
1737421 | 1737421 | 2021-09-20 | McLean | North Dakota | 38055 | 1510 | 32 |
1734171 | 1734171 | 2021-09-19 | McLean | North Dakota | 38055 | 1507 | 32 |
1730921 | 1730921 | 2021-09-18 | McLean | North Dakota | 38055 | 1501 | 32 |
1727671 | 1727671 | 2021-09-17 | McLean | North Dakota | 38055 | 1495 | 32 |
1724422 | 1724422 | 2021-09-16 | McLean | North Dakota | 38055 | 1493 | 32 |
1721173 | 1721173 | 2021-09-15 | McLean | North Dakota | 38055 | 1487 | 32 |
1717925 | 1717925 | 2021-09-14 | McLean | North Dakota | 38055 | 1478 | 32 |
1714677 | 1714677 | 2021-09-13 | McLean | North Dakota | 38055 | 1472 | 32 |
1711431 | 1711431 | 2021-09-12 | McLean | North Dakota | 38055 | 1471 | 32 |
1708184 | 1708184 | 2021-09-11 | McLean | North Dakota | 38055 | 1467 | 32 |
1704937 | 1704937 | 2021-09-10 | McLean | North Dakota | 38055 | 1460 | 32 |
1701687 | 1701687 | 2021-09-09 | McLean | North Dakota | 38055 | 1442 | 32 |
1698438 | 1698438 | 2021-09-08 | McLean | North Dakota | 38055 | 1437 | 32 |
1695190 | 1695190 | 2021-09-07 | McLean | North Dakota | 38055 | 1424 | 32 |
1691942 | 1691942 | 2021-09-06 | McLean | North Dakota | 38055 | 1419 | 32 |
1688692 | 1688692 | 2021-09-05 | McLean | North Dakota | 38055 | 1418 | 32 |
1685442 | 1685442 | 2021-09-04 | McLean | North Dakota | 38055 | 1417 | 32 |
1682191 | 1682191 | 2021-09-03 | McLean | North Dakota | 38055 | 1410 | 32 |
1678942 | 1678942 | 2021-09-02 | McLean | North Dakota | 38055 | 1405 | 32 |
1675694 | 1675694 | 2021-09-01 | McLean | North Dakota | 38055 | 1398 | 32 |
1672447 | 1672447 | 2021-08-31 | McLean | North Dakota | 38055 | 1392 | 32 |
1669199 | 1669199 | 2021-08-30 | McLean | North Dakota | 38055 | 1384 | 32 |
1665952 | 1665952 | 2021-08-29 | McLean | North Dakota | 38055 | 1381 | 32 |
1662704 | 1662704 | 2021-08-28 | McLean | North Dakota | 38055 | 1375 | 32 |
1659456 | 1659456 | 2021-08-27 | McLean | North Dakota | 38055 | 1372 | 32 |
1656207 | 1656207 | 2021-08-26 | McLean | North Dakota | 38055 | 1369 | 32 |
1652960 | 1652960 | 2021-08-25 | McLean | North Dakota | 38055 | 1363 | 32 |
1649712 | 1649712 | 2021-08-24 | McLean | North Dakota | 38055 | 1360 | 32 |
1646463 | 1646463 | 2021-08-23 | McLean | North Dakota | 38055 | 1358 | 32 |
1643214 | 1643214 | 2021-08-22 | McLean | North Dakota | 38055 | 1358 | 32 |
1639964 | 1639964 | 2021-08-21 | McLean | North Dakota | 38055 | 1357 | 32 |
1636714 | 1636714 | 2021-08-20 | McLean | North Dakota | 38055 | 1351 | 32 |
1633464 | 1633464 | 2021-08-19 | McLean | North Dakota | 38055 | 1350 | 32 |
1630217 | 1630217 | 2021-08-18 | McLean | North Dakota | 38055 | 1347 | 32 |
1626970 | 1626970 | 2021-08-17 | McLean | North Dakota | 38055 | 1344 | 32 |
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);