ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where county = "Warren" and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812115 | 1812115 | 2021-10-13 | Warren | North Carolina | 37185 | 2314 | 28 |
1808866 | 1808866 | 2021-10-12 | Warren | North Carolina | 37185 | 2311 | 28 |
1805615 | 1805615 | 2021-10-11 | Warren | North Carolina | 37185 | 2310 | 27 |
1802366 | 1802366 | 2021-10-10 | Warren | North Carolina | 37185 | 2292 | 27 |
1799117 | 1799117 | 2021-10-09 | Warren | North Carolina | 37185 | 2292 | 27 |
1795868 | 1795868 | 2021-10-08 | Warren | North Carolina | 37185 | 2292 | 27 |
1792619 | 1792619 | 2021-10-07 | Warren | North Carolina | 37185 | 2285 | 27 |
1789370 | 1789370 | 2021-10-06 | Warren | North Carolina | 37185 | 2277 | 27 |
1786122 | 1786122 | 2021-10-05 | Warren | North Carolina | 37185 | 2274 | 27 |
1782873 | 1782873 | 2021-10-04 | Warren | North Carolina | 37185 | 2272 | 27 |
1779624 | 1779624 | 2021-10-03 | Warren | North Carolina | 37185 | 2255 | 27 |
1776374 | 1776374 | 2021-10-02 | Warren | North Carolina | 37185 | 2255 | 27 |
1773124 | 1773124 | 2021-10-01 | Warren | North Carolina | 37185 | 2255 | 27 |
1769874 | 1769874 | 2021-09-30 | Warren | North Carolina | 37185 | 2250 | 27 |
1766625 | 1766625 | 2021-09-29 | Warren | North Carolina | 37185 | 2242 | 27 |
1763376 | 1763376 | 2021-09-28 | Warren | North Carolina | 37185 | 2229 | 27 |
1760127 | 1760127 | 2021-09-27 | Warren | North Carolina | 37185 | 2227 | 26 |
1756879 | 1756879 | 2021-09-26 | Warren | North Carolina | 37185 | 2212 | 26 |
1753631 | 1753631 | 2021-09-25 | Warren | North Carolina | 37185 | 2212 | 26 |
1750383 | 1750383 | 2021-09-24 | Warren | North Carolina | 37185 | 2212 | 26 |
1747133 | 1747133 | 2021-09-23 | Warren | North Carolina | 37185 | 2198 | 23 |
1743884 | 1743884 | 2021-09-22 | Warren | North Carolina | 37185 | 2191 | 23 |
1740635 | 1740635 | 2021-09-21 | Warren | North Carolina | 37185 | 2185 | 24 |
1737386 | 1737386 | 2021-09-20 | Warren | North Carolina | 37185 | 2181 | 24 |
1734136 | 1734136 | 2021-09-19 | Warren | North Carolina | 37185 | 2121 | 20 |
1730886 | 1730886 | 2021-09-18 | Warren | North Carolina | 37185 | 2121 | 20 |
1727636 | 1727636 | 2021-09-17 | Warren | North Carolina | 37185 | 2121 | 20 |
1724387 | 1724387 | 2021-09-16 | Warren | North Carolina | 37185 | 2109 | 20 |
1721138 | 1721138 | 2021-09-15 | Warren | North Carolina | 37185 | 2096 | 20 |
1717890 | 1717890 | 2021-09-14 | Warren | North Carolina | 37185 | 2085 | 20 |
1714642 | 1714642 | 2021-09-13 | Warren | North Carolina | 37185 | 2082 | 20 |
1711396 | 1711396 | 2021-09-12 | Warren | North Carolina | 37185 | 2042 | 20 |
1708149 | 1708149 | 2021-09-11 | Warren | North Carolina | 37185 | 2042 | 20 |
1704902 | 1704902 | 2021-09-10 | Warren | North Carolina | 37185 | 2042 | 20 |
1701652 | 1701652 | 2021-09-09 | Warren | North Carolina | 37185 | 2037 | 20 |
1698403 | 1698403 | 2021-09-08 | Warren | North Carolina | 37185 | 2029 | 20 |
1695155 | 1695155 | 2021-09-07 | Warren | North Carolina | 37185 | 2029 | 20 |
1691907 | 1691907 | 2021-09-06 | Warren | North Carolina | 37185 | 2004 | 20 |
1688657 | 1688657 | 2021-09-05 | Warren | North Carolina | 37185 | 2004 | 20 |
1685407 | 1685407 | 2021-09-04 | Warren | North Carolina | 37185 | 2004 | 20 |
1682156 | 1682156 | 2021-09-03 | Warren | North Carolina | 37185 | 2004 | 20 |
1678907 | 1678907 | 2021-09-02 | Warren | North Carolina | 37185 | 1997 | 20 |
1675659 | 1675659 | 2021-09-01 | Warren | North Carolina | 37185 | 1987 | 20 |
1672412 | 1672412 | 2021-08-31 | Warren | North Carolina | 37185 | 1975 | 20 |
1669164 | 1669164 | 2021-08-30 | Warren | North Carolina | 37185 | 1969 | 20 |
1665917 | 1665917 | 2021-08-29 | Warren | North Carolina | 37185 | 1946 | 20 |
1662669 | 1662669 | 2021-08-28 | Warren | North Carolina | 37185 | 1946 | 20 |
1659421 | 1659421 | 2021-08-27 | Warren | North Carolina | 37185 | 1946 | 20 |
1656172 | 1656172 | 2021-08-26 | Warren | North Carolina | 37185 | 1940 | 20 |
1652925 | 1652925 | 2021-08-25 | Warren | North Carolina | 37185 | 1934 | 20 |
1649677 | 1649677 | 2021-08-24 | Warren | North Carolina | 37185 | 1928 | 20 |
1646428 | 1646428 | 2021-08-23 | Warren | North Carolina | 37185 | 1915 | 20 |
1643179 | 1643179 | 2021-08-22 | Warren | North Carolina | 37185 | 1901 | 20 |
1639929 | 1639929 | 2021-08-21 | Warren | North Carolina | 37185 | 1901 | 20 |
1636679 | 1636679 | 2021-08-20 | Warren | North Carolina | 37185 | 1901 | 20 |
1633429 | 1633429 | 2021-08-19 | Warren | North Carolina | 37185 | 1897 | 20 |
1630182 | 1630182 | 2021-08-18 | Warren | North Carolina | 37185 | 1892 | 20 |
1626935 | 1626935 | 2021-08-17 | Warren | North Carolina | 37185 | 1885 | 20 |
1623688 | 1623688 | 2021-08-16 | Warren | North Carolina | 37185 | 1885 | 20 |
1620441 | 1620441 | 2021-08-15 | Warren | North Carolina | 37185 | 1874 | 20 |
1617193 | 1617193 | 2021-08-14 | Warren | North Carolina | 37185 | 1874 | 20 |
1613945 | 1613945 | 2021-08-13 | Warren | North Carolina | 37185 | 1874 | 20 |
1610696 | 1610696 | 2021-08-12 | Warren | North Carolina | 37185 | 1869 | 20 |
1607448 | 1607448 | 2021-08-11 | Warren | North Carolina | 37185 | 1866 | 20 |
1604199 | 1604199 | 2021-08-10 | Warren | North Carolina | 37185 | 1859 | 20 |
1600950 | 1600950 | 2021-08-09 | Warren | North Carolina | 37185 | 1858 | 20 |
1597702 | 1597702 | 2021-08-08 | Warren | North Carolina | 37185 | 1851 | 20 |
1594453 | 1594453 | 2021-08-07 | Warren | North Carolina | 37185 | 1851 | 20 |
1591204 | 1591204 | 2021-08-06 | Warren | North Carolina | 37185 | 1851 | 20 |
1587955 | 1587955 | 2021-08-05 | Warren | North Carolina | 37185 | 1846 | 20 |
1584705 | 1584705 | 2021-08-04 | Warren | North Carolina | 37185 | 1841 | 20 |
1581455 | 1581455 | 2021-08-03 | Warren | North Carolina | 37185 | 1838 | 20 |
1578206 | 1578206 | 2021-08-02 | Warren | North Carolina | 37185 | 1838 | 20 |
1574958 | 1574958 | 2021-08-01 | Warren | North Carolina | 37185 | 1836 | 20 |
1571710 | 1571710 | 2021-07-31 | Warren | North Carolina | 37185 | 1836 | 20 |
1568462 | 1568462 | 2021-07-30 | Warren | North Carolina | 37185 | 1836 | 20 |
1565214 | 1565214 | 2021-07-29 | Warren | North Carolina | 37185 | 1837 | 20 |
1561966 | 1561966 | 2021-07-28 | Warren | North Carolina | 37185 | 1834 | 20 |
1558718 | 1558718 | 2021-07-27 | Warren | North Carolina | 37185 | 1829 | 20 |
1555471 | 1555471 | 2021-07-26 | Warren | North Carolina | 37185 | 1829 | 20 |
1552224 | 1552224 | 2021-07-25 | Warren | North Carolina | 37185 | 1824 | 20 |
1548977 | 1548977 | 2021-07-24 | Warren | North Carolina | 37185 | 1824 | 20 |
1545730 | 1545730 | 2021-07-23 | Warren | North Carolina | 37185 | 1824 | 20 |
1542483 | 1542483 | 2021-07-22 | Warren | North Carolina | 37185 | 1823 | 20 |
1539235 | 1539235 | 2021-07-21 | Warren | North Carolina | 37185 | 1822 | 20 |
1535988 | 1535988 | 2021-07-20 | Warren | North Carolina | 37185 | 1821 | 20 |
1532740 | 1532740 | 2021-07-19 | Warren | North Carolina | 37185 | 1820 | 20 |
1529493 | 1529493 | 2021-07-18 | Warren | North Carolina | 37185 | 1820 | 20 |
1526246 | 1526246 | 2021-07-17 | Warren | North Carolina | 37185 | 1820 | 20 |
1522999 | 1522999 | 2021-07-16 | Warren | North Carolina | 37185 | 1820 | 20 |
1519751 | 1519751 | 2021-07-15 | Warren | North Carolina | 37185 | 1819 | 20 |
1516503 | 1516503 | 2021-07-14 | Warren | North Carolina | 37185 | 1819 | 20 |
1513256 | 1513256 | 2021-07-13 | Warren | North Carolina | 37185 | 1819 | 20 |
1510010 | 1510010 | 2021-07-12 | Warren | North Carolina | 37185 | 1820 | 20 |
1506763 | 1506763 | 2021-07-11 | Warren | North Carolina | 37185 | 1819 | 20 |
1503517 | 1503517 | 2021-07-10 | Warren | North Carolina | 37185 | 1819 | 20 |
1500271 | 1500271 | 2021-07-09 | Warren | North Carolina | 37185 | 1819 | 20 |
1497025 | 1497025 | 2021-07-08 | Warren | North Carolina | 37185 | 1819 | 20 |
1493778 | 1493778 | 2021-07-07 | Warren | North Carolina | 37185 | 1819 | 20 |
1490531 | 1490531 | 2021-07-06 | Warren | North Carolina | 37185 | 1817 | 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);