ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Yadkin" 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 |
---|---|---|---|---|---|---|---|
1948600 | 1948600 | 2021-11-24 | Yadkin | North Carolina | 37197 | 6248 | 76 |
1945349 | 1945349 | 2021-11-23 | Yadkin | North Carolina | 37197 | 6231 | 76 |
1942098 | 1942098 | 2021-11-22 | Yadkin | North Carolina | 37197 | 6225 | 76 |
1938848 | 1938848 | 2021-11-21 | Yadkin | North Carolina | 37197 | 6193 | 76 |
1935598 | 1935598 | 2021-11-20 | Yadkin | North Carolina | 37197 | 6193 | 76 |
1932348 | 1932348 | 2021-11-19 | Yadkin | North Carolina | 37197 | 6193 | 76 |
1929097 | 1929097 | 2021-11-18 | Yadkin | North Carolina | 37197 | 6174 | 76 |
1925847 | 1925847 | 2021-11-17 | Yadkin | North Carolina | 37197 | 6165 | 76 |
1922598 | 1922598 | 2021-11-16 | Yadkin | North Carolina | 37197 | 6161 | 75 |
1919348 | 1919348 | 2021-11-15 | Yadkin | North Carolina | 37197 | 6156 | 75 |
1916098 | 1916098 | 2021-11-14 | Yadkin | North Carolina | 37197 | 6124 | 75 |
1912848 | 1912848 | 2021-11-13 | Yadkin | North Carolina | 37197 | 6124 | 75 |
1909598 | 1909598 | 2021-11-12 | Yadkin | North Carolina | 37197 | 6124 | 75 |
1906349 | 1906349 | 2021-11-11 | Yadkin | North Carolina | 37197 | 6098 | 75 |
1903100 | 1903100 | 2021-11-10 | Yadkin | North Carolina | 37197 | 6098 | 75 |
1899850 | 1899850 | 2021-11-09 | Yadkin | North Carolina | 37197 | 6084 | 75 |
1896600 | 1896600 | 2021-11-08 | Yadkin | North Carolina | 37197 | 6077 | 75 |
1893350 | 1893350 | 2021-11-07 | Yadkin | North Carolina | 37197 | 6052 | 74 |
1890100 | 1890100 | 2021-11-06 | Yadkin | North Carolina | 37197 | 6052 | 74 |
1886850 | 1886850 | 2021-11-05 | Yadkin | North Carolina | 37197 | 6052 | 74 |
1883601 | 1883601 | 2021-11-04 | Yadkin | North Carolina | 37197 | 6043 | 74 |
1880352 | 1880352 | 2021-11-03 | Yadkin | North Carolina | 37197 | 6031 | 74 |
1877103 | 1877103 | 2021-11-02 | Yadkin | North Carolina | 37197 | 6022 | 73 |
1873854 | 1873854 | 2021-11-01 | Yadkin | North Carolina | 37197 | 6019 | 73 |
1870605 | 1870605 | 2021-10-31 | Yadkin | North Carolina | 37197 | 6005 | 73 |
1867356 | 1867356 | 2021-10-30 | Yadkin | North Carolina | 37197 | 6005 | 73 |
1864107 | 1864107 | 2021-10-29 | Yadkin | North Carolina | 37197 | 6005 | 73 |
1860858 | 1860858 | 2021-10-28 | Yadkin | North Carolina | 37197 | 5995 | 73 |
1857609 | 1857609 | 2021-10-27 | Yadkin | North Carolina | 37197 | 5984 | 73 |
1854360 | 1854360 | 2021-10-26 | Yadkin | North Carolina | 37197 | 5974 | 73 |
1851111 | 1851111 | 2021-10-25 | Yadkin | North Carolina | 37197 | 5973 | 73 |
1847861 | 1847861 | 2021-10-24 | Yadkin | North Carolina | 37197 | 5944 | 73 |
1844611 | 1844611 | 2021-10-23 | Yadkin | North Carolina | 37197 | 5944 | 73 |
1841361 | 1841361 | 2021-10-22 | Yadkin | North Carolina | 37197 | 5944 | 73 |
1838112 | 1838112 | 2021-10-21 | Yadkin | North Carolina | 37197 | 5935 | 73 |
1834863 | 1834863 | 2021-10-20 | Yadkin | North Carolina | 37197 | 5924 | 73 |
1831614 | 1831614 | 2021-10-19 | Yadkin | North Carolina | 37197 | 5917 | 73 |
1828365 | 1828365 | 2021-10-18 | Yadkin | North Carolina | 37197 | 5909 | 73 |
1825116 | 1825116 | 2021-10-17 | Yadkin | North Carolina | 37197 | 5890 | 70 |
1821867 | 1821867 | 2021-10-16 | Yadkin | North Carolina | 37197 | 5890 | 70 |
1818618 | 1818618 | 2021-10-15 | Yadkin | North Carolina | 37197 | 5890 | 70 |
1815369 | 1815369 | 2021-10-14 | Yadkin | North Carolina | 37197 | 5874 | 70 |
1812121 | 1812121 | 2021-10-13 | Yadkin | North Carolina | 37197 | 5858 | 70 |
1808872 | 1808872 | 2021-10-12 | Yadkin | North Carolina | 37197 | 5840 | 70 |
1805621 | 1805621 | 2021-10-11 | Yadkin | North Carolina | 37197 | 5828 | 70 |
1802372 | 1802372 | 2021-10-10 | Yadkin | North Carolina | 37197 | 5795 | 70 |
1799123 | 1799123 | 2021-10-09 | Yadkin | North Carolina | 37197 | 5795 | 70 |
1795874 | 1795874 | 2021-10-08 | Yadkin | North Carolina | 37197 | 5795 | 70 |
1792625 | 1792625 | 2021-10-07 | Yadkin | North Carolina | 37197 | 5782 | 70 |
1789376 | 1789376 | 2021-10-06 | Yadkin | North Carolina | 37197 | 5761 | 70 |
1786128 | 1786128 | 2021-10-05 | Yadkin | North Carolina | 37197 | 5750 | 70 |
1782879 | 1782879 | 2021-10-04 | Yadkin | North Carolina | 37197 | 5736 | 69 |
1779630 | 1779630 | 2021-10-03 | Yadkin | North Carolina | 37197 | 5692 | 69 |
1776380 | 1776380 | 2021-10-02 | Yadkin | North Carolina | 37197 | 5692 | 69 |
1773130 | 1773130 | 2021-10-01 | Yadkin | North Carolina | 37197 | 5692 | 69 |
1769880 | 1769880 | 2021-09-30 | Yadkin | North Carolina | 37197 | 5676 | 69 |
1766631 | 1766631 | 2021-09-29 | Yadkin | North Carolina | 37197 | 5655 | 67 |
1763382 | 1763382 | 2021-09-28 | Yadkin | North Carolina | 37197 | 5634 | 67 |
1760133 | 1760133 | 2021-09-27 | Yadkin | North Carolina | 37197 | 5619 | 67 |
1756885 | 1756885 | 2021-09-26 | Yadkin | North Carolina | 37197 | 5569 | 65 |
1753637 | 1753637 | 2021-09-25 | Yadkin | North Carolina | 37197 | 5569 | 65 |
1750389 | 1750389 | 2021-09-24 | Yadkin | North Carolina | 37197 | 5569 | 65 |
1747139 | 1747139 | 2021-09-23 | Yadkin | North Carolina | 37197 | 5544 | 65 |
1743890 | 1743890 | 2021-09-22 | Yadkin | North Carolina | 37197 | 5519 | 65 |
1740641 | 1740641 | 2021-09-21 | Yadkin | North Carolina | 37197 | 5496 | 65 |
1737392 | 1737392 | 2021-09-20 | Yadkin | North Carolina | 37197 | 5471 | 65 |
1734142 | 1734142 | 2021-09-19 | Yadkin | North Carolina | 37197 | 5383 | 65 |
1730892 | 1730892 | 2021-09-18 | Yadkin | North Carolina | 37197 | 5383 | 65 |
1727642 | 1727642 | 2021-09-17 | Yadkin | North Carolina | 37197 | 5383 | 65 |
1724393 | 1724393 | 2021-09-16 | Yadkin | North Carolina | 37197 | 5346 | 63 |
1721144 | 1721144 | 2021-09-15 | Yadkin | North Carolina | 37197 | 5327 | 63 |
1717896 | 1717896 | 2021-09-14 | Yadkin | North Carolina | 37197 | 5301 | 58 |
1714648 | 1714648 | 2021-09-13 | Yadkin | North Carolina | 37197 | 5273 | 58 |
1711402 | 1711402 | 2021-09-12 | Yadkin | North Carolina | 37197 | 5188 | 58 |
1708155 | 1708155 | 2021-09-11 | Yadkin | North Carolina | 37197 | 5188 | 58 |
1704908 | 1704908 | 2021-09-10 | Yadkin | North Carolina | 37197 | 5188 | 58 |
1701658 | 1701658 | 2021-09-09 | Yadkin | North Carolina | 37197 | 5169 | 58 |
1698409 | 1698409 | 2021-09-08 | Yadkin | North Carolina | 37197 | 5146 | 58 |
1695161 | 1695161 | 2021-09-07 | Yadkin | North Carolina | 37197 | 5123 | 58 |
1691913 | 1691913 | 2021-09-06 | Yadkin | North Carolina | 37197 | 4992 | 57 |
1688663 | 1688663 | 2021-09-05 | Yadkin | North Carolina | 37197 | 4992 | 57 |
1685413 | 1685413 | 2021-09-04 | Yadkin | North Carolina | 37197 | 4992 | 57 |
1682162 | 1682162 | 2021-09-03 | Yadkin | North Carolina | 37197 | 4992 | 57 |
1678913 | 1678913 | 2021-09-02 | Yadkin | North Carolina | 37197 | 4954 | 57 |
1675665 | 1675665 | 2021-09-01 | Yadkin | North Carolina | 37197 | 4931 | 57 |
1672418 | 1672418 | 2021-08-31 | Yadkin | North Carolina | 37197 | 4886 | 57 |
1669170 | 1669170 | 2021-08-30 | Yadkin | North Carolina | 37197 | 4858 | 57 |
1665923 | 1665923 | 2021-08-29 | Yadkin | North Carolina | 37197 | 4798 | 57 |
1662675 | 1662675 | 2021-08-28 | Yadkin | North Carolina | 37197 | 4798 | 57 |
1659427 | 1659427 | 2021-08-27 | Yadkin | North Carolina | 37197 | 4798 | 57 |
1656178 | 1656178 | 2021-08-26 | Yadkin | North Carolina | 37197 | 4765 | 57 |
1652931 | 1652931 | 2021-08-25 | Yadkin | North Carolina | 37197 | 4739 | 57 |
1649683 | 1649683 | 2021-08-24 | Yadkin | North Carolina | 37197 | 4710 | 57 |
1646434 | 1646434 | 2021-08-23 | Yadkin | North Carolina | 37197 | 4685 | 57 |
1643185 | 1643185 | 2021-08-22 | Yadkin | North Carolina | 37197 | 4616 | 57 |
1639935 | 1639935 | 2021-08-21 | Yadkin | North Carolina | 37197 | 4616 | 57 |
1636685 | 1636685 | 2021-08-20 | Yadkin | North Carolina | 37197 | 4616 | 57 |
1633435 | 1633435 | 2021-08-19 | Yadkin | North Carolina | 37197 | 4596 | 57 |
1630188 | 1630188 | 2021-08-18 | Yadkin | North Carolina | 37197 | 4580 | 57 |
1626941 | 1626941 | 2021-08-17 | Yadkin | North Carolina | 37197 | 4556 | 57 |
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);