ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
749 rows where county = "Madison" 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 |
---|---|---|---|---|---|---|---|
1812079 | 1812079 | 2021-10-13 | Madison | North Carolina | 37115 | 2694 | 56 |
1808830 | 1808830 | 2021-10-12 | Madison | North Carolina | 37115 | 2688 | 56 |
1805579 | 1805579 | 2021-10-11 | Madison | North Carolina | 37115 | 2684 | 56 |
1802330 | 1802330 | 2021-10-10 | Madison | North Carolina | 37115 | 2661 | 55 |
1799081 | 1799081 | 2021-10-09 | Madison | North Carolina | 37115 | 2661 | 55 |
1795832 | 1795832 | 2021-10-08 | Madison | North Carolina | 37115 | 2661 | 55 |
1792583 | 1792583 | 2021-10-07 | Madison | North Carolina | 37115 | 2644 | 55 |
1789334 | 1789334 | 2021-10-06 | Madison | North Carolina | 37115 | 2636 | 55 |
1786086 | 1786086 | 2021-10-05 | Madison | North Carolina | 37115 | 2628 | 55 |
1782837 | 1782837 | 2021-10-04 | Madison | North Carolina | 37115 | 2627 | 55 |
1779588 | 1779588 | 2021-10-03 | Madison | North Carolina | 37115 | 2588 | 55 |
1776338 | 1776338 | 2021-10-02 | Madison | North Carolina | 37115 | 2588 | 55 |
1773088 | 1773088 | 2021-10-01 | Madison | North Carolina | 37115 | 2588 | 55 |
1769838 | 1769838 | 2021-09-30 | Madison | North Carolina | 37115 | 2581 | 55 |
1766589 | 1766589 | 2021-09-29 | Madison | North Carolina | 37115 | 2555 | 54 |
1763340 | 1763340 | 2021-09-28 | Madison | North Carolina | 37115 | 2549 | 53 |
1760091 | 1760091 | 2021-09-27 | Madison | North Carolina | 37115 | 2544 | 53 |
1756843 | 1756843 | 2021-09-26 | Madison | North Carolina | 37115 | 2508 | 53 |
1753595 | 1753595 | 2021-09-25 | Madison | North Carolina | 37115 | 2508 | 53 |
1750347 | 1750347 | 2021-09-24 | Madison | North Carolina | 37115 | 2508 | 53 |
1747097 | 1747097 | 2021-09-23 | Madison | North Carolina | 37115 | 2494 | 52 |
1743848 | 1743848 | 2021-09-22 | Madison | North Carolina | 37115 | 2484 | 52 |
1740599 | 1740599 | 2021-09-21 | Madison | North Carolina | 37115 | 2458 | 52 |
1737350 | 1737350 | 2021-09-20 | Madison | North Carolina | 37115 | 2447 | 52 |
1734100 | 1734100 | 2021-09-19 | Madison | North Carolina | 37115 | 2398 | 52 |
1730850 | 1730850 | 2021-09-18 | Madison | North Carolina | 37115 | 2398 | 52 |
1727600 | 1727600 | 2021-09-17 | Madison | North Carolina | 37115 | 2398 | 52 |
1724351 | 1724351 | 2021-09-16 | Madison | North Carolina | 37115 | 2361 | 52 |
1721102 | 1721102 | 2021-09-15 | Madison | North Carolina | 37115 | 2351 | 52 |
1717854 | 1717854 | 2021-09-14 | Madison | North Carolina | 37115 | 2341 | 51 |
1714606 | 1714606 | 2021-09-13 | Madison | North Carolina | 37115 | 2323 | 50 |
1711360 | 1711360 | 2021-09-12 | Madison | North Carolina | 37115 | 2245 | 49 |
1708113 | 1708113 | 2021-09-11 | Madison | North Carolina | 37115 | 2245 | 49 |
1704866 | 1704866 | 2021-09-10 | Madison | North Carolina | 37115 | 2245 | 49 |
1701616 | 1701616 | 2021-09-09 | Madison | North Carolina | 37115 | 2235 | 49 |
1698367 | 1698367 | 2021-09-08 | Madison | North Carolina | 37115 | 2210 | 46 |
1695119 | 1695119 | 2021-09-07 | Madison | North Carolina | 37115 | 2180 | 45 |
1691871 | 1691871 | 2021-09-06 | Madison | North Carolina | 37115 | 2079 | 44 |
1688621 | 1688621 | 2021-09-05 | Madison | North Carolina | 37115 | 2079 | 44 |
1685371 | 1685371 | 2021-09-04 | Madison | North Carolina | 37115 | 2079 | 44 |
1682120 | 1682120 | 2021-09-03 | Madison | North Carolina | 37115 | 2079 | 44 |
1678871 | 1678871 | 2021-09-02 | Madison | North Carolina | 37115 | 2066 | 44 |
1675623 | 1675623 | 2021-09-01 | Madison | North Carolina | 37115 | 2026 | 44 |
1672376 | 1672376 | 2021-08-31 | Madison | North Carolina | 37115 | 2005 | 43 |
1669128 | 1669128 | 2021-08-30 | Madison | North Carolina | 37115 | 2000 | 43 |
1665881 | 1665881 | 2021-08-29 | Madison | North Carolina | 37115 | 1964 | 43 |
1662633 | 1662633 | 2021-08-28 | Madison | North Carolina | 37115 | 1964 | 43 |
1659385 | 1659385 | 2021-08-27 | Madison | North Carolina | 37115 | 1964 | 43 |
1656136 | 1656136 | 2021-08-26 | Madison | North Carolina | 37115 | 1948 | 43 |
1652889 | 1652889 | 2021-08-25 | Madison | North Carolina | 37115 | 1919 | 43 |
1649641 | 1649641 | 2021-08-24 | Madison | North Carolina | 37115 | 1908 | 43 |
1646392 | 1646392 | 2021-08-23 | Madison | North Carolina | 37115 | 1898 | 43 |
1643143 | 1643143 | 2021-08-22 | Madison | North Carolina | 37115 | 1843 | 43 |
1639893 | 1639893 | 2021-08-21 | Madison | North Carolina | 37115 | 1843 | 43 |
1636643 | 1636643 | 2021-08-20 | Madison | North Carolina | 37115 | 1843 | 43 |
1633393 | 1633393 | 2021-08-19 | Madison | North Carolina | 37115 | 1826 | 43 |
1630146 | 1630146 | 2021-08-18 | Madison | North Carolina | 37115 | 1819 | 43 |
1626899 | 1626899 | 2021-08-17 | Madison | North Carolina | 37115 | 1817 | 43 |
1623652 | 1623652 | 2021-08-16 | Madison | North Carolina | 37115 | 1803 | 43 |
1620405 | 1620405 | 2021-08-15 | Madison | North Carolina | 37115 | 1757 | 43 |
1617157 | 1617157 | 2021-08-14 | Madison | North Carolina | 37115 | 1757 | 43 |
1613909 | 1613909 | 2021-08-13 | Madison | North Carolina | 37115 | 1757 | 43 |
1610660 | 1610660 | 2021-08-12 | Madison | North Carolina | 37115 | 1743 | 43 |
1607412 | 1607412 | 2021-08-11 | Madison | North Carolina | 37115 | 1729 | 43 |
1604163 | 1604163 | 2021-08-10 | Madison | North Carolina | 37115 | 1731 | 43 |
1600914 | 1600914 | 2021-08-09 | Madison | North Carolina | 37115 | 1724 | 43 |
1597666 | 1597666 | 2021-08-08 | Madison | North Carolina | 37115 | 1709 | 43 |
1594417 | 1594417 | 2021-08-07 | Madison | North Carolina | 37115 | 1709 | 43 |
1591168 | 1591168 | 2021-08-06 | Madison | North Carolina | 37115 | 1709 | 43 |
1587919 | 1587919 | 2021-08-05 | Madison | North Carolina | 37115 | 1697 | 43 |
1584669 | 1584669 | 2021-08-04 | Madison | North Carolina | 37115 | 1687 | 43 |
1581419 | 1581419 | 2021-08-03 | Madison | North Carolina | 37115 | 1684 | 43 |
1578170 | 1578170 | 2021-08-02 | Madison | North Carolina | 37115 | 1677 | 43 |
1574922 | 1574922 | 2021-08-01 | Madison | North Carolina | 37115 | 1661 | 43 |
1571674 | 1571674 | 2021-07-31 | Madison | North Carolina | 37115 | 1661 | 43 |
1568426 | 1568426 | 2021-07-30 | Madison | North Carolina | 37115 | 1661 | 43 |
1565178 | 1565178 | 2021-07-29 | Madison | North Carolina | 37115 | 1652 | 43 |
1561930 | 1561930 | 2021-07-28 | Madison | North Carolina | 37115 | 1646 | 43 |
1558682 | 1558682 | 2021-07-27 | Madison | North Carolina | 37115 | 1643 | 43 |
1555435 | 1555435 | 2021-07-26 | Madison | North Carolina | 37115 | 1641 | 43 |
1552188 | 1552188 | 2021-07-25 | Madison | North Carolina | 37115 | 1634 | 43 |
1548941 | 1548941 | 2021-07-24 | Madison | North Carolina | 37115 | 1634 | 43 |
1545694 | 1545694 | 2021-07-23 | Madison | North Carolina | 37115 | 1634 | 43 |
1542447 | 1542447 | 2021-07-22 | Madison | North Carolina | 37115 | 1631 | 43 |
1539199 | 1539199 | 2021-07-21 | Madison | North Carolina | 37115 | 1628 | 43 |
1535952 | 1535952 | 2021-07-20 | Madison | North Carolina | 37115 | 1628 | 43 |
1532704 | 1532704 | 2021-07-19 | Madison | North Carolina | 37115 | 1627 | 43 |
1529457 | 1529457 | 2021-07-18 | Madison | North Carolina | 37115 | 1615 | 43 |
1526210 | 1526210 | 2021-07-17 | Madison | North Carolina | 37115 | 1615 | 43 |
1522963 | 1522963 | 2021-07-16 | Madison | North Carolina | 37115 | 1615 | 43 |
1519715 | 1519715 | 2021-07-15 | Madison | North Carolina | 37115 | 1615 | 43 |
1516467 | 1516467 | 2021-07-14 | Madison | North Carolina | 37115 | 1613 | 43 |
1513220 | 1513220 | 2021-07-13 | Madison | North Carolina | 37115 | 1611 | 43 |
1509974 | 1509974 | 2021-07-12 | Madison | North Carolina | 37115 | 1611 | 43 |
1506727 | 1506727 | 2021-07-11 | Madison | North Carolina | 37115 | 1602 | 43 |
1503481 | 1503481 | 2021-07-10 | Madison | North Carolina | 37115 | 1602 | 43 |
1500235 | 1500235 | 2021-07-09 | Madison | North Carolina | 37115 | 1602 | 43 |
1496989 | 1496989 | 2021-07-08 | Madison | North Carolina | 37115 | 1603 | 43 |
1493742 | 1493742 | 2021-07-07 | Madison | North Carolina | 37115 | 1603 | 43 |
1490495 | 1490495 | 2021-07-06 | Madison | North Carolina | 37115 | 1604 | 43 |
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);