ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Stanly" 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 |
---|---|---|---|---|---|---|---|
1812106 | 1812106 | 2021-10-13 | Stanly | North Carolina | 37167 | 11375 | 179 |
1808857 | 1808857 | 2021-10-12 | Stanly | North Carolina | 37167 | 11356 | 173 |
1805606 | 1805606 | 2021-10-11 | Stanly | North Carolina | 37167 | 11346 | 173 |
1802357 | 1802357 | 2021-10-10 | Stanly | North Carolina | 37167 | 11276 | 173 |
1799108 | 1799108 | 2021-10-09 | Stanly | North Carolina | 37167 | 11276 | 173 |
1795859 | 1795859 | 2021-10-08 | Stanly | North Carolina | 37167 | 11276 | 173 |
1792610 | 1792610 | 2021-10-07 | Stanly | North Carolina | 37167 | 11229 | 173 |
1789361 | 1789361 | 2021-10-06 | Stanly | North Carolina | 37167 | 11194 | 173 |
1786113 | 1786113 | 2021-10-05 | Stanly | North Carolina | 37167 | 11163 | 164 |
1782864 | 1782864 | 2021-10-04 | Stanly | North Carolina | 37167 | 11141 | 164 |
1779615 | 1779615 | 2021-10-03 | Stanly | North Carolina | 37167 | 11041 | 164 |
1776365 | 1776365 | 2021-10-02 | Stanly | North Carolina | 37167 | 11041 | 164 |
1773115 | 1773115 | 2021-10-01 | Stanly | North Carolina | 37167 | 11041 | 164 |
1769865 | 1769865 | 2021-09-30 | Stanly | North Carolina | 37167 | 11012 | 164 |
1766616 | 1766616 | 2021-09-29 | Stanly | North Carolina | 37167 | 10987 | 164 |
1763367 | 1763367 | 2021-09-28 | Stanly | North Carolina | 37167 | 10951 | 164 |
1760118 | 1760118 | 2021-09-27 | Stanly | North Carolina | 37167 | 10913 | 164 |
1756870 | 1756870 | 2021-09-26 | Stanly | North Carolina | 37167 | 10812 | 163 |
1753622 | 1753622 | 2021-09-25 | Stanly | North Carolina | 37167 | 10812 | 163 |
1750374 | 1750374 | 2021-09-24 | Stanly | North Carolina | 37167 | 10812 | 163 |
1747124 | 1747124 | 2021-09-23 | Stanly | North Carolina | 37167 | 10740 | 163 |
1743875 | 1743875 | 2021-09-22 | Stanly | North Carolina | 37167 | 10692 | 163 |
1740626 | 1740626 | 2021-09-21 | Stanly | North Carolina | 37167 | 10631 | 163 |
1737377 | 1737377 | 2021-09-20 | Stanly | North Carolina | 37167 | 10574 | 162 |
1734127 | 1734127 | 2021-09-19 | Stanly | North Carolina | 37167 | 10437 | 152 |
1730877 | 1730877 | 2021-09-18 | Stanly | North Carolina | 37167 | 10437 | 152 |
1727627 | 1727627 | 2021-09-17 | Stanly | North Carolina | 37167 | 10437 | 152 |
1724378 | 1724378 | 2021-09-16 | Stanly | North Carolina | 37167 | 10371 | 152 |
1721129 | 1721129 | 2021-09-15 | Stanly | North Carolina | 37167 | 10296 | 153 |
1717881 | 1717881 | 2021-09-14 | Stanly | North Carolina | 37167 | 10251 | 153 |
1714633 | 1714633 | 2021-09-13 | Stanly | North Carolina | 37167 | 10202 | 153 |
1711387 | 1711387 | 2021-09-12 | Stanly | North Carolina | 37167 | 9953 | 152 |
1708140 | 1708140 | 2021-09-11 | Stanly | North Carolina | 37167 | 9953 | 152 |
1704893 | 1704893 | 2021-09-10 | Stanly | North Carolina | 37167 | 9953 | 152 |
1701643 | 1701643 | 2021-09-09 | Stanly | North Carolina | 37167 | 9921 | 152 |
1698394 | 1698394 | 2021-09-08 | Stanly | North Carolina | 37167 | 9871 | 152 |
1695146 | 1695146 | 2021-09-07 | Stanly | North Carolina | 37167 | 9835 | 152 |
1691898 | 1691898 | 2021-09-06 | Stanly | North Carolina | 37167 | 9621 | 152 |
1688648 | 1688648 | 2021-09-05 | Stanly | North Carolina | 37167 | 9621 | 152 |
1685398 | 1685398 | 2021-09-04 | Stanly | North Carolina | 37167 | 9621 | 152 |
1682147 | 1682147 | 2021-09-03 | Stanly | North Carolina | 37167 | 9621 | 152 |
1678898 | 1678898 | 2021-09-02 | Stanly | North Carolina | 37167 | 9556 | 152 |
1675650 | 1675650 | 2021-09-01 | Stanly | North Carolina | 37167 | 9505 | 150 |
1672403 | 1672403 | 2021-08-31 | Stanly | North Carolina | 37167 | 9450 | 150 |
1669155 | 1669155 | 2021-08-30 | Stanly | North Carolina | 37167 | 9421 | 150 |
1665908 | 1665908 | 2021-08-29 | Stanly | North Carolina | 37167 | 9231 | 147 |
1662660 | 1662660 | 2021-08-28 | Stanly | North Carolina | 37167 | 9231 | 147 |
1659412 | 1659412 | 2021-08-27 | Stanly | North Carolina | 37167 | 9231 | 147 |
1656163 | 1656163 | 2021-08-26 | Stanly | North Carolina | 37167 | 9178 | 147 |
1652916 | 1652916 | 2021-08-25 | Stanly | North Carolina | 37167 | 9107 | 147 |
1649668 | 1649668 | 2021-08-24 | Stanly | North Carolina | 37167 | 9051 | 147 |
1646419 | 1646419 | 2021-08-23 | Stanly | North Carolina | 37167 | 9004 | 147 |
1643170 | 1643170 | 2021-08-22 | Stanly | North Carolina | 37167 | 8868 | 142 |
1639920 | 1639920 | 2021-08-21 | Stanly | North Carolina | 37167 | 8868 | 142 |
1636670 | 1636670 | 2021-08-20 | Stanly | North Carolina | 37167 | 8868 | 142 |
1633420 | 1633420 | 2021-08-19 | Stanly | North Carolina | 37167 | 8810 | 142 |
1630173 | 1630173 | 2021-08-18 | Stanly | North Carolina | 37167 | 8777 | 142 |
1626926 | 1626926 | 2021-08-17 | Stanly | North Carolina | 37167 | 8738 | 142 |
1623679 | 1623679 | 2021-08-16 | Stanly | North Carolina | 37167 | 8716 | 142 |
1620432 | 1620432 | 2021-08-15 | Stanly | North Carolina | 37167 | 8579 | 141 |
1617184 | 1617184 | 2021-08-14 | Stanly | North Carolina | 37167 | 8579 | 141 |
1613936 | 1613936 | 2021-08-13 | Stanly | North Carolina | 37167 | 8579 | 141 |
1610687 | 1610687 | 2021-08-12 | Stanly | North Carolina | 37167 | 8529 | 141 |
1607439 | 1607439 | 2021-08-11 | Stanly | North Carolina | 37167 | 8492 | 141 |
1604190 | 1604190 | 2021-08-10 | Stanly | North Carolina | 37167 | 8454 | 141 |
1600941 | 1600941 | 2021-08-09 | Stanly | North Carolina | 37167 | 8437 | 141 |
1597693 | 1597693 | 2021-08-08 | Stanly | North Carolina | 37167 | 8337 | 138 |
1594444 | 1594444 | 2021-08-07 | Stanly | North Carolina | 37167 | 8337 | 138 |
1591195 | 1591195 | 2021-08-06 | Stanly | North Carolina | 37167 | 8337 | 138 |
1587946 | 1587946 | 2021-08-05 | Stanly | North Carolina | 37167 | 8307 | 138 |
1584696 | 1584696 | 2021-08-04 | Stanly | North Carolina | 37167 | 8271 | 138 |
1581446 | 1581446 | 2021-08-03 | Stanly | North Carolina | 37167 | 8233 | 138 |
1578197 | 1578197 | 2021-08-02 | Stanly | North Carolina | 37167 | 8206 | 138 |
1574949 | 1574949 | 2021-08-01 | Stanly | North Carolina | 37167 | 8147 | 138 |
1571701 | 1571701 | 2021-07-31 | Stanly | North Carolina | 37167 | 8147 | 138 |
1568453 | 1568453 | 2021-07-30 | Stanly | North Carolina | 37167 | 8147 | 138 |
1565205 | 1565205 | 2021-07-29 | Stanly | North Carolina | 37167 | 8126 | 138 |
1561957 | 1561957 | 2021-07-28 | Stanly | North Carolina | 37167 | 8102 | 138 |
1558709 | 1558709 | 2021-07-27 | Stanly | North Carolina | 37167 | 8085 | 138 |
1555462 | 1555462 | 2021-07-26 | Stanly | North Carolina | 37167 | 8072 | 138 |
1552215 | 1552215 | 2021-07-25 | Stanly | North Carolina | 37167 | 8032 | 138 |
1548968 | 1548968 | 2021-07-24 | Stanly | North Carolina | 37167 | 8032 | 138 |
1545721 | 1545721 | 2021-07-23 | Stanly | North Carolina | 37167 | 8032 | 138 |
1542474 | 1542474 | 2021-07-22 | Stanly | North Carolina | 37167 | 8010 | 138 |
1539226 | 1539226 | 2021-07-21 | Stanly | North Carolina | 37167 | 8002 | 138 |
1535979 | 1535979 | 2021-07-20 | Stanly | North Carolina | 37167 | 8000 | 138 |
1532731 | 1532731 | 2021-07-19 | Stanly | North Carolina | 37167 | 7994 | 138 |
1529484 | 1529484 | 2021-07-18 | Stanly | North Carolina | 37167 | 7976 | 138 |
1526237 | 1526237 | 2021-07-17 | Stanly | North Carolina | 37167 | 7976 | 138 |
1522990 | 1522990 | 2021-07-16 | Stanly | North Carolina | 37167 | 7976 | 138 |
1519742 | 1519742 | 2021-07-15 | Stanly | North Carolina | 37167 | 7972 | 138 |
1516494 | 1516494 | 2021-07-14 | Stanly | North Carolina | 37167 | 7965 | 138 |
1513247 | 1513247 | 2021-07-13 | Stanly | North Carolina | 37167 | 7961 | 138 |
1510001 | 1510001 | 2021-07-12 | Stanly | North Carolina | 37167 | 7957 | 138 |
1506754 | 1506754 | 2021-07-11 | Stanly | North Carolina | 37167 | 7947 | 138 |
1503508 | 1503508 | 2021-07-10 | Stanly | North Carolina | 37167 | 7947 | 138 |
1500262 | 1500262 | 2021-07-09 | Stanly | North Carolina | 37167 | 7947 | 138 |
1497016 | 1497016 | 2021-07-08 | Stanly | North Carolina | 37167 | 7947 | 138 |
1493769 | 1493769 | 2021-07-07 | Stanly | North Carolina | 37167 | 7947 | 138 |
1490522 | 1490522 | 2021-07-06 | Stanly | North Carolina | 37167 | 7946 | 138 |
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);