ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Scotland" 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 |
---|---|---|---|---|---|---|---|
1948584 | 1948584 | 2021-11-24 | Scotland | North Carolina | 37165 | 5840 | 109 |
1945333 | 1945333 | 2021-11-23 | Scotland | North Carolina | 37165 | 5836 | 109 |
1942082 | 1942082 | 2021-11-22 | Scotland | North Carolina | 37165 | 5832 | 109 |
1938832 | 1938832 | 2021-11-21 | Scotland | North Carolina | 37165 | 5824 | 109 |
1935582 | 1935582 | 2021-11-20 | Scotland | North Carolina | 37165 | 5824 | 109 |
1932332 | 1932332 | 2021-11-19 | Scotland | North Carolina | 37165 | 5824 | 109 |
1929081 | 1929081 | 2021-11-18 | Scotland | North Carolina | 37165 | 5823 | 109 |
1925831 | 1925831 | 2021-11-17 | Scotland | North Carolina | 37165 | 5818 | 109 |
1922582 | 1922582 | 2021-11-16 | Scotland | North Carolina | 37165 | 5816 | 109 |
1919332 | 1919332 | 2021-11-15 | Scotland | North Carolina | 37165 | 5817 | 108 |
1916082 | 1916082 | 2021-11-14 | Scotland | North Carolina | 37165 | 5806 | 108 |
1912832 | 1912832 | 2021-11-13 | Scotland | North Carolina | 37165 | 5806 | 108 |
1909582 | 1909582 | 2021-11-12 | Scotland | North Carolina | 37165 | 5806 | 108 |
1906333 | 1906333 | 2021-11-11 | Scotland | North Carolina | 37165 | 5796 | 108 |
1903084 | 1903084 | 2021-11-10 | Scotland | North Carolina | 37165 | 5796 | 108 |
1899834 | 1899834 | 2021-11-09 | Scotland | North Carolina | 37165 | 5786 | 108 |
1896584 | 1896584 | 2021-11-08 | Scotland | North Carolina | 37165 | 5781 | 107 |
1893334 | 1893334 | 2021-11-07 | Scotland | North Carolina | 37165 | 5773 | 107 |
1890084 | 1890084 | 2021-11-06 | Scotland | North Carolina | 37165 | 5773 | 107 |
1886834 | 1886834 | 2021-11-05 | Scotland | North Carolina | 37165 | 5773 | 107 |
1883585 | 1883585 | 2021-11-04 | Scotland | North Carolina | 37165 | 5768 | 107 |
1880336 | 1880336 | 2021-11-03 | Scotland | North Carolina | 37165 | 5762 | 107 |
1877087 | 1877087 | 2021-11-02 | Scotland | North Carolina | 37165 | 5757 | 107 |
1873838 | 1873838 | 2021-11-01 | Scotland | North Carolina | 37165 | 5754 | 107 |
1870589 | 1870589 | 2021-10-31 | Scotland | North Carolina | 37165 | 5735 | 107 |
1867340 | 1867340 | 2021-10-30 | Scotland | North Carolina | 37165 | 5735 | 107 |
1864091 | 1864091 | 2021-10-29 | Scotland | North Carolina | 37165 | 5735 | 107 |
1860842 | 1860842 | 2021-10-28 | Scotland | North Carolina | 37165 | 5717 | 107 |
1857593 | 1857593 | 2021-10-27 | Scotland | North Carolina | 37165 | 5712 | 107 |
1854344 | 1854344 | 2021-10-26 | Scotland | North Carolina | 37165 | 5709 | 107 |
1851095 | 1851095 | 2021-10-25 | Scotland | North Carolina | 37165 | 5705 | 107 |
1847845 | 1847845 | 2021-10-24 | Scotland | North Carolina | 37165 | 5686 | 106 |
1844595 | 1844595 | 2021-10-23 | Scotland | North Carolina | 37165 | 5686 | 106 |
1841345 | 1841345 | 2021-10-22 | Scotland | North Carolina | 37165 | 5686 | 106 |
1838096 | 1838096 | 2021-10-21 | Scotland | North Carolina | 37165 | 5674 | 106 |
1834847 | 1834847 | 2021-10-20 | Scotland | North Carolina | 37165 | 5659 | 106 |
1831598 | 1831598 | 2021-10-19 | Scotland | North Carolina | 37165 | 5654 | 106 |
1828349 | 1828349 | 2021-10-18 | Scotland | North Carolina | 37165 | 5651 | 106 |
1825100 | 1825100 | 2021-10-17 | Scotland | North Carolina | 37165 | 5636 | 106 |
1821851 | 1821851 | 2021-10-16 | Scotland | North Carolina | 37165 | 5636 | 106 |
1818602 | 1818602 | 2021-10-15 | Scotland | North Carolina | 37165 | 5636 | 106 |
1815353 | 1815353 | 2021-10-14 | Scotland | North Carolina | 37165 | 5628 | 106 |
1812105 | 1812105 | 2021-10-13 | Scotland | North Carolina | 37165 | 5619 | 105 |
1808856 | 1808856 | 2021-10-12 | Scotland | North Carolina | 37165 | 5610 | 105 |
1805605 | 1805605 | 2021-10-11 | Scotland | North Carolina | 37165 | 5602 | 105 |
1802356 | 1802356 | 2021-10-10 | Scotland | North Carolina | 37165 | 5569 | 104 |
1799107 | 1799107 | 2021-10-09 | Scotland | North Carolina | 37165 | 5569 | 104 |
1795858 | 1795858 | 2021-10-08 | Scotland | North Carolina | 37165 | 5569 | 104 |
1792609 | 1792609 | 2021-10-07 | Scotland | North Carolina | 37165 | 5547 | 104 |
1789360 | 1789360 | 2021-10-06 | Scotland | North Carolina | 37165 | 5534 | 104 |
1786112 | 1786112 | 2021-10-05 | Scotland | North Carolina | 37165 | 5527 | 104 |
1782863 | 1782863 | 2021-10-04 | Scotland | North Carolina | 37165 | 5517 | 103 |
1779614 | 1779614 | 2021-10-03 | Scotland | North Carolina | 37165 | 5479 | 103 |
1776364 | 1776364 | 2021-10-02 | Scotland | North Carolina | 37165 | 5479 | 103 |
1773114 | 1773114 | 2021-10-01 | Scotland | North Carolina | 37165 | 5479 | 103 |
1769864 | 1769864 | 2021-09-30 | Scotland | North Carolina | 37165 | 5462 | 101 |
1766615 | 1766615 | 2021-09-29 | Scotland | North Carolina | 37165 | 5436 | 101 |
1763366 | 1763366 | 2021-09-28 | Scotland | North Carolina | 37165 | 5418 | 101 |
1760117 | 1760117 | 2021-09-27 | Scotland | North Carolina | 37165 | 5397 | 100 |
1756869 | 1756869 | 2021-09-26 | Scotland | North Carolina | 37165 | 5349 | 100 |
1753621 | 1753621 | 2021-09-25 | Scotland | North Carolina | 37165 | 5349 | 100 |
1750373 | 1750373 | 2021-09-24 | Scotland | North Carolina | 37165 | 5349 | 100 |
1747123 | 1747123 | 2021-09-23 | Scotland | North Carolina | 37165 | 5318 | 100 |
1743874 | 1743874 | 2021-09-22 | Scotland | North Carolina | 37165 | 5304 | 100 |
1740625 | 1740625 | 2021-09-21 | Scotland | North Carolina | 37165 | 5271 | 99 |
1737376 | 1737376 | 2021-09-20 | Scotland | North Carolina | 37165 | 5254 | 99 |
1734126 | 1734126 | 2021-09-19 | Scotland | North Carolina | 37165 | 5208 | 99 |
1730876 | 1730876 | 2021-09-18 | Scotland | North Carolina | 37165 | 5208 | 99 |
1727626 | 1727626 | 2021-09-17 | Scotland | North Carolina | 37165 | 5208 | 99 |
1724377 | 1724377 | 2021-09-16 | Scotland | North Carolina | 37165 | 5166 | 98 |
1721128 | 1721128 | 2021-09-15 | Scotland | North Carolina | 37165 | 5137 | 97 |
1717880 | 1717880 | 2021-09-14 | Scotland | North Carolina | 37165 | 5112 | 97 |
1714632 | 1714632 | 2021-09-13 | Scotland | North Carolina | 37165 | 5093 | 97 |
1711386 | 1711386 | 2021-09-12 | Scotland | North Carolina | 37165 | 5008 | 97 |
1708139 | 1708139 | 2021-09-11 | Scotland | North Carolina | 37165 | 5008 | 97 |
1704892 | 1704892 | 2021-09-10 | Scotland | North Carolina | 37165 | 5008 | 97 |
1701642 | 1701642 | 2021-09-09 | Scotland | North Carolina | 37165 | 4966 | 97 |
1698393 | 1698393 | 2021-09-08 | Scotland | North Carolina | 37165 | 4924 | 97 |
1695145 | 1695145 | 2021-09-07 | Scotland | North Carolina | 37165 | 4902 | 97 |
1691897 | 1691897 | 2021-09-06 | Scotland | North Carolina | 37165 | 4810 | 97 |
1688647 | 1688647 | 2021-09-05 | Scotland | North Carolina | 37165 | 4810 | 97 |
1685397 | 1685397 | 2021-09-04 | Scotland | North Carolina | 37165 | 4810 | 97 |
1682146 | 1682146 | 2021-09-03 | Scotland | North Carolina | 37165 | 4810 | 97 |
1678897 | 1678897 | 2021-09-02 | Scotland | North Carolina | 37165 | 4752 | 97 |
1675649 | 1675649 | 2021-09-01 | Scotland | North Carolina | 37165 | 4720 | 97 |
1672402 | 1672402 | 2021-08-31 | Scotland | North Carolina | 37165 | 4710 | 96 |
1669154 | 1669154 | 2021-08-30 | Scotland | North Carolina | 37165 | 4690 | 96 |
1665907 | 1665907 | 2021-08-29 | Scotland | North Carolina | 37165 | 4639 | 96 |
1662659 | 1662659 | 2021-08-28 | Scotland | North Carolina | 37165 | 4639 | 96 |
1659411 | 1659411 | 2021-08-27 | Scotland | North Carolina | 37165 | 4639 | 96 |
1656162 | 1656162 | 2021-08-26 | Scotland | North Carolina | 37165 | 4606 | 96 |
1652915 | 1652915 | 2021-08-25 | Scotland | North Carolina | 37165 | 4575 | 96 |
1649667 | 1649667 | 2021-08-24 | Scotland | North Carolina | 37165 | 4548 | 95 |
1646418 | 1646418 | 2021-08-23 | Scotland | North Carolina | 37165 | 4531 | 95 |
1643169 | 1643169 | 2021-08-22 | Scotland | North Carolina | 37165 | 4466 | 94 |
1639919 | 1639919 | 2021-08-21 | Scotland | North Carolina | 37165 | 4466 | 94 |
1636669 | 1636669 | 2021-08-20 | Scotland | North Carolina | 37165 | 4466 | 94 |
1633419 | 1633419 | 2021-08-19 | Scotland | North Carolina | 37165 | 4430 | 94 |
1630172 | 1630172 | 2021-08-18 | Scotland | North Carolina | 37165 | 4405 | 94 |
1626925 | 1626925 | 2021-08-17 | Scotland | North Carolina | 37165 | 4393 | 93 |
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);