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 |
---|---|---|---|---|---|---|---|
1948585 | 1948585 | 2021-11-24 | Stanly | North Carolina | 37167 | 12088 | 198 |
1945334 | 1945334 | 2021-11-23 | Stanly | North Carolina | 37167 | 12074 | 198 |
1942083 | 1942083 | 2021-11-22 | Stanly | North Carolina | 37167 | 12068 | 198 |
1938833 | 1938833 | 2021-11-21 | Stanly | North Carolina | 37167 | 12011 | 198 |
1935583 | 1935583 | 2021-11-20 | Stanly | North Carolina | 37167 | 12011 | 198 |
1932333 | 1932333 | 2021-11-19 | Stanly | North Carolina | 37167 | 12011 | 198 |
1929082 | 1929082 | 2021-11-18 | Stanly | North Carolina | 37167 | 11992 | 198 |
1925832 | 1925832 | 2021-11-17 | Stanly | North Carolina | 37167 | 11956 | 191 |
1922583 | 1922583 | 2021-11-16 | Stanly | North Carolina | 37167 | 11932 | 191 |
1919333 | 1919333 | 2021-11-15 | Stanly | North Carolina | 37167 | 11918 | 191 |
1916083 | 1916083 | 2021-11-14 | Stanly | North Carolina | 37167 | 11875 | 191 |
1912833 | 1912833 | 2021-11-13 | Stanly | North Carolina | 37167 | 11875 | 191 |
1909583 | 1909583 | 2021-11-12 | Stanly | North Carolina | 37167 | 11875 | 191 |
1906334 | 1906334 | 2021-11-11 | Stanly | North Carolina | 37167 | 11832 | 191 |
1903085 | 1903085 | 2021-11-10 | Stanly | North Carolina | 37167 | 11832 | 191 |
1899835 | 1899835 | 2021-11-09 | Stanly | North Carolina | 37167 | 11818 | 191 |
1896585 | 1896585 | 2021-11-08 | Stanly | North Carolina | 37167 | 11797 | 191 |
1893335 | 1893335 | 2021-11-07 | Stanly | North Carolina | 37167 | 11752 | 191 |
1890085 | 1890085 | 2021-11-06 | Stanly | North Carolina | 37167 | 11752 | 191 |
1886835 | 1886835 | 2021-11-05 | Stanly | North Carolina | 37167 | 11752 | 191 |
1883586 | 1883586 | 2021-11-04 | Stanly | North Carolina | 37167 | 11742 | 191 |
1880337 | 1880337 | 2021-11-03 | Stanly | North Carolina | 37167 | 11728 | 191 |
1877088 | 1877088 | 2021-11-02 | Stanly | North Carolina | 37167 | 11706 | 191 |
1873839 | 1873839 | 2021-11-01 | Stanly | North Carolina | 37167 | 11689 | 191 |
1870590 | 1870590 | 2021-10-31 | Stanly | North Carolina | 37167 | 11652 | 191 |
1867341 | 1867341 | 2021-10-30 | Stanly | North Carolina | 37167 | 11652 | 191 |
1864092 | 1864092 | 2021-10-29 | Stanly | North Carolina | 37167 | 11652 | 191 |
1860843 | 1860843 | 2021-10-28 | Stanly | North Carolina | 37167 | 11623 | 191 |
1857594 | 1857594 | 2021-10-27 | Stanly | North Carolina | 37167 | 11601 | 191 |
1854345 | 1854345 | 2021-10-26 | Stanly | North Carolina | 37167 | 11594 | 191 |
1851096 | 1851096 | 2021-10-25 | Stanly | North Carolina | 37167 | 11586 | 189 |
1847846 | 1847846 | 2021-10-24 | Stanly | North Carolina | 37167 | 11546 | 184 |
1844596 | 1844596 | 2021-10-23 | Stanly | North Carolina | 37167 | 11546 | 184 |
1841346 | 1841346 | 2021-10-22 | Stanly | North Carolina | 37167 | 11546 | 184 |
1838097 | 1838097 | 2021-10-21 | Stanly | North Carolina | 37167 | 11531 | 180 |
1834848 | 1834848 | 2021-10-20 | Stanly | North Carolina | 37167 | 11498 | 180 |
1831599 | 1831599 | 2021-10-19 | Stanly | North Carolina | 37167 | 11488 | 179 |
1828350 | 1828350 | 2021-10-18 | Stanly | North Carolina | 37167 | 11476 | 179 |
1825101 | 1825101 | 2021-10-17 | Stanly | North Carolina | 37167 | 11421 | 179 |
1821852 | 1821852 | 2021-10-16 | Stanly | North Carolina | 37167 | 11421 | 179 |
1818603 | 1818603 | 2021-10-15 | Stanly | North Carolina | 37167 | 11421 | 179 |
1815354 | 1815354 | 2021-10-14 | Stanly | North Carolina | 37167 | 11393 | 179 |
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 |
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);