ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Sampson" 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 |
---|---|---|---|---|---|---|---|
1948583 | 1948583 | 2021-11-24 | Sampson | North Carolina | 37163 | 11520 | 140 |
1945332 | 1945332 | 2021-11-23 | Sampson | North Carolina | 37163 | 11506 | 140 |
1942081 | 1942081 | 2021-11-22 | Sampson | North Carolina | 37163 | 11497 | 140 |
1938831 | 1938831 | 2021-11-21 | Sampson | North Carolina | 37163 | 11479 | 140 |
1935581 | 1935581 | 2021-11-20 | Sampson | North Carolina | 37163 | 11479 | 140 |
1932331 | 1932331 | 2021-11-19 | Sampson | North Carolina | 37163 | 11479 | 140 |
1929080 | 1929080 | 2021-11-18 | Sampson | North Carolina | 37163 | 11464 | 139 |
1925830 | 1925830 | 2021-11-17 | Sampson | North Carolina | 37163 | 11451 | 139 |
1922581 | 1922581 | 2021-11-16 | Sampson | North Carolina | 37163 | 11440 | 138 |
1919331 | 1919331 | 2021-11-15 | Sampson | North Carolina | 37163 | 11439 | 137 |
1916081 | 1916081 | 2021-11-14 | Sampson | North Carolina | 37163 | 11424 | 137 |
1912831 | 1912831 | 2021-11-13 | Sampson | North Carolina | 37163 | 11424 | 137 |
1909581 | 1909581 | 2021-11-12 | Sampson | North Carolina | 37163 | 11424 | 137 |
1906332 | 1906332 | 2021-11-11 | Sampson | North Carolina | 37163 | 11411 | 137 |
1903083 | 1903083 | 2021-11-10 | Sampson | North Carolina | 37163 | 11411 | 137 |
1899833 | 1899833 | 2021-11-09 | Sampson | North Carolina | 37163 | 11404 | 137 |
1896583 | 1896583 | 2021-11-08 | Sampson | North Carolina | 37163 | 11400 | 137 |
1893333 | 1893333 | 2021-11-07 | Sampson | North Carolina | 37163 | 11378 | 137 |
1890083 | 1890083 | 2021-11-06 | Sampson | North Carolina | 37163 | 11378 | 137 |
1886833 | 1886833 | 2021-11-05 | Sampson | North Carolina | 37163 | 11378 | 137 |
1883584 | 1883584 | 2021-11-04 | Sampson | North Carolina | 37163 | 11361 | 137 |
1880335 | 1880335 | 2021-11-03 | Sampson | North Carolina | 37163 | 11337 | 136 |
1877086 | 1877086 | 2021-11-02 | Sampson | North Carolina | 37163 | 11329 | 136 |
1873837 | 1873837 | 2021-11-01 | Sampson | North Carolina | 37163 | 11320 | 136 |
1870588 | 1870588 | 2021-10-31 | Sampson | North Carolina | 37163 | 11296 | 136 |
1867339 | 1867339 | 2021-10-30 | Sampson | North Carolina | 37163 | 11296 | 136 |
1864090 | 1864090 | 2021-10-29 | Sampson | North Carolina | 37163 | 11296 | 136 |
1860841 | 1860841 | 2021-10-28 | Sampson | North Carolina | 37163 | 11277 | 135 |
1857592 | 1857592 | 2021-10-27 | Sampson | North Carolina | 37163 | 11259 | 135 |
1854343 | 1854343 | 2021-10-26 | Sampson | North Carolina | 37163 | 11242 | 135 |
1851094 | 1851094 | 2021-10-25 | Sampson | North Carolina | 37163 | 11241 | 135 |
1847844 | 1847844 | 2021-10-24 | Sampson | North Carolina | 37163 | 11215 | 135 |
1844594 | 1844594 | 2021-10-23 | Sampson | North Carolina | 37163 | 11215 | 135 |
1841344 | 1841344 | 2021-10-22 | Sampson | North Carolina | 37163 | 11215 | 135 |
1838095 | 1838095 | 2021-10-21 | Sampson | North Carolina | 37163 | 11190 | 133 |
1834846 | 1834846 | 2021-10-20 | Sampson | North Carolina | 37163 | 11159 | 133 |
1831597 | 1831597 | 2021-10-19 | Sampson | North Carolina | 37163 | 11134 | 131 |
1828348 | 1828348 | 2021-10-18 | Sampson | North Carolina | 37163 | 11132 | 131 |
1825099 | 1825099 | 2021-10-17 | Sampson | North Carolina | 37163 | 11069 | 130 |
1821850 | 1821850 | 2021-10-16 | Sampson | North Carolina | 37163 | 11069 | 130 |
1818601 | 1818601 | 2021-10-15 | Sampson | North Carolina | 37163 | 11069 | 130 |
1815352 | 1815352 | 2021-10-14 | Sampson | North Carolina | 37163 | 11040 | 129 |
1812104 | 1812104 | 2021-10-13 | Sampson | North Carolina | 37163 | 11003 | 129 |
1808855 | 1808855 | 2021-10-12 | Sampson | North Carolina | 37163 | 10976 | 129 |
1805604 | 1805604 | 2021-10-11 | Sampson | North Carolina | 37163 | 10967 | 129 |
1802355 | 1802355 | 2021-10-10 | Sampson | North Carolina | 37163 | 10910 | 128 |
1799106 | 1799106 | 2021-10-09 | Sampson | North Carolina | 37163 | 10910 | 128 |
1795857 | 1795857 | 2021-10-08 | Sampson | North Carolina | 37163 | 10910 | 128 |
1792608 | 1792608 | 2021-10-07 | Sampson | North Carolina | 37163 | 10887 | 127 |
1789359 | 1789359 | 2021-10-06 | Sampson | North Carolina | 37163 | 10857 | 127 |
1786111 | 1786111 | 2021-10-05 | Sampson | North Carolina | 37163 | 10817 | 127 |
1782862 | 1782862 | 2021-10-04 | Sampson | North Carolina | 37163 | 10807 | 127 |
1779613 | 1779613 | 2021-10-03 | Sampson | North Carolina | 37163 | 10730 | 127 |
1776363 | 1776363 | 2021-10-02 | Sampson | North Carolina | 37163 | 10730 | 127 |
1773113 | 1773113 | 2021-10-01 | Sampson | North Carolina | 37163 | 10730 | 127 |
1769863 | 1769863 | 2021-09-30 | Sampson | North Carolina | 37163 | 10707 | 127 |
1766614 | 1766614 | 2021-09-29 | Sampson | North Carolina | 37163 | 10671 | 127 |
1763365 | 1763365 | 2021-09-28 | Sampson | North Carolina | 37163 | 10635 | 127 |
1760116 | 1760116 | 2021-09-27 | Sampson | North Carolina | 37163 | 10620 | 126 |
1756868 | 1756868 | 2021-09-26 | Sampson | North Carolina | 37163 | 10564 | 125 |
1753620 | 1753620 | 2021-09-25 | Sampson | North Carolina | 37163 | 10564 | 125 |
1750372 | 1750372 | 2021-09-24 | Sampson | North Carolina | 37163 | 10564 | 125 |
1747122 | 1747122 | 2021-09-23 | Sampson | North Carolina | 37163 | 10533 | 125 |
1743873 | 1743873 | 2021-09-22 | Sampson | North Carolina | 37163 | 10492 | 124 |
1740624 | 1740624 | 2021-09-21 | Sampson | North Carolina | 37163 | 10447 | 124 |
1737375 | 1737375 | 2021-09-20 | Sampson | North Carolina | 37163 | 10430 | 124 |
1734125 | 1734125 | 2021-09-19 | Sampson | North Carolina | 37163 | 10320 | 124 |
1730875 | 1730875 | 2021-09-18 | Sampson | North Carolina | 37163 | 10320 | 124 |
1727625 | 1727625 | 2021-09-17 | Sampson | North Carolina | 37163 | 10320 | 124 |
1724376 | 1724376 | 2021-09-16 | Sampson | North Carolina | 37163 | 10293 | 124 |
1721127 | 1721127 | 2021-09-15 | Sampson | North Carolina | 37163 | 10253 | 124 |
1717879 | 1717879 | 2021-09-14 | Sampson | North Carolina | 37163 | 10194 | 124 |
1714631 | 1714631 | 2021-09-13 | Sampson | North Carolina | 37163 | 10179 | 124 |
1711385 | 1711385 | 2021-09-12 | Sampson | North Carolina | 37163 | 10071 | 124 |
1708138 | 1708138 | 2021-09-11 | Sampson | North Carolina | 37163 | 10071 | 124 |
1704891 | 1704891 | 2021-09-10 | Sampson | North Carolina | 37163 | 10071 | 124 |
1701641 | 1701641 | 2021-09-09 | Sampson | North Carolina | 37163 | 10030 | 124 |
1698392 | 1698392 | 2021-09-08 | Sampson | North Carolina | 37163 | 9986 | 122 |
1695144 | 1695144 | 2021-09-07 | Sampson | North Carolina | 37163 | 9977 | 120 |
1691896 | 1691896 | 2021-09-06 | Sampson | North Carolina | 37163 | 9872 | 120 |
1688646 | 1688646 | 2021-09-05 | Sampson | North Carolina | 37163 | 9872 | 120 |
1685396 | 1685396 | 2021-09-04 | Sampson | North Carolina | 37163 | 9872 | 120 |
1682145 | 1682145 | 2021-09-03 | Sampson | North Carolina | 37163 | 9872 | 120 |
1678896 | 1678896 | 2021-09-02 | Sampson | North Carolina | 37163 | 9723 | 118 |
1675648 | 1675648 | 2021-09-01 | Sampson | North Carolina | 37163 | 9682 | 117 |
1672401 | 1672401 | 2021-08-31 | Sampson | North Carolina | 37163 | 9649 | 117 |
1669153 | 1669153 | 2021-08-30 | Sampson | North Carolina | 37163 | 9624 | 116 |
1665906 | 1665906 | 2021-08-29 | Sampson | North Carolina | 37163 | 9470 | 115 |
1662658 | 1662658 | 2021-08-28 | Sampson | North Carolina | 37163 | 9470 | 115 |
1659410 | 1659410 | 2021-08-27 | Sampson | North Carolina | 37163 | 9470 | 115 |
1656161 | 1656161 | 2021-08-26 | Sampson | North Carolina | 37163 | 9403 | 115 |
1652914 | 1652914 | 2021-08-25 | Sampson | North Carolina | 37163 | 9310 | 115 |
1649666 | 1649666 | 2021-08-24 | Sampson | North Carolina | 37163 | 9238 | 115 |
1646417 | 1646417 | 2021-08-23 | Sampson | North Carolina | 37163 | 9212 | 115 |
1643168 | 1643168 | 2021-08-22 | Sampson | North Carolina | 37163 | 9109 | 115 |
1639918 | 1639918 | 2021-08-21 | Sampson | North Carolina | 37163 | 9109 | 115 |
1636668 | 1636668 | 2021-08-20 | Sampson | North Carolina | 37163 | 9109 | 115 |
1633418 | 1633418 | 2021-08-19 | Sampson | North Carolina | 37163 | 9067 | 115 |
1630171 | 1630171 | 2021-08-18 | Sampson | North Carolina | 37163 | 9009 | 115 |
1626924 | 1626924 | 2021-08-17 | Sampson | North Carolina | 37163 | 8978 | 115 |
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);