ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
769 rows where county = "Pender" 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 |
---|---|---|---|---|---|---|---|
1948572 | 1948572 | 2021-11-24 | Pender | North Carolina | 37141 | 9099 | 101 |
1945321 | 1945321 | 2021-11-23 | Pender | North Carolina | 37141 | 9079 | 101 |
1942070 | 1942070 | 2021-11-22 | Pender | North Carolina | 37141 | 9073 | 101 |
1938820 | 1938820 | 2021-11-21 | Pender | North Carolina | 37141 | 9027 | 101 |
1935570 | 1935570 | 2021-11-20 | Pender | North Carolina | 37141 | 9027 | 101 |
1932320 | 1932320 | 2021-11-19 | Pender | North Carolina | 37141 | 9027 | 101 |
1929069 | 1929069 | 2021-11-18 | Pender | North Carolina | 37141 | 9021 | 101 |
1925819 | 1925819 | 2021-11-17 | Pender | North Carolina | 37141 | 9004 | 101 |
1922570 | 1922570 | 2021-11-16 | Pender | North Carolina | 37141 | 8984 | 101 |
1919320 | 1919320 | 2021-11-15 | Pender | North Carolina | 37141 | 8979 | 101 |
1916070 | 1916070 | 2021-11-14 | Pender | North Carolina | 37141 | 8931 | 101 |
1912820 | 1912820 | 2021-11-13 | Pender | North Carolina | 37141 | 8931 | 101 |
1909570 | 1909570 | 2021-11-12 | Pender | North Carolina | 37141 | 8931 | 101 |
1906321 | 1906321 | 2021-11-11 | Pender | North Carolina | 37141 | 8888 | 101 |
1903072 | 1903072 | 2021-11-10 | Pender | North Carolina | 37141 | 8888 | 101 |
1899822 | 1899822 | 2021-11-09 | Pender | North Carolina | 37141 | 8881 | 101 |
1896572 | 1896572 | 2021-11-08 | Pender | North Carolina | 37141 | 8875 | 101 |
1893322 | 1893322 | 2021-11-07 | Pender | North Carolina | 37141 | 8850 | 101 |
1890072 | 1890072 | 2021-11-06 | Pender | North Carolina | 37141 | 8850 | 101 |
1886822 | 1886822 | 2021-11-05 | Pender | North Carolina | 37141 | 8850 | 101 |
1883573 | 1883573 | 2021-11-04 | Pender | North Carolina | 37141 | 8839 | 101 |
1880324 | 1880324 | 2021-11-03 | Pender | North Carolina | 37141 | 8840 | 101 |
1877075 | 1877075 | 2021-11-02 | Pender | North Carolina | 37141 | 8834 | 100 |
1873826 | 1873826 | 2021-11-01 | Pender | North Carolina | 37141 | 8826 | 100 |
1870577 | 1870577 | 2021-10-31 | Pender | North Carolina | 37141 | 8805 | 100 |
1867328 | 1867328 | 2021-10-30 | Pender | North Carolina | 37141 | 8805 | 100 |
1864079 | 1864079 | 2021-10-29 | Pender | North Carolina | 37141 | 8805 | 100 |
1860830 | 1860830 | 2021-10-28 | Pender | North Carolina | 37141 | 8801 | 100 |
1857581 | 1857581 | 2021-10-27 | Pender | North Carolina | 37141 | 8800 | 101 |
1854332 | 1854332 | 2021-10-26 | Pender | North Carolina | 37141 | 8796 | 101 |
1851083 | 1851083 | 2021-10-25 | Pender | North Carolina | 37141 | 8795 | 101 |
1847833 | 1847833 | 2021-10-24 | Pender | North Carolina | 37141 | 8771 | 100 |
1844583 | 1844583 | 2021-10-23 | Pender | North Carolina | 37141 | 8771 | 100 |
1841333 | 1841333 | 2021-10-22 | Pender | North Carolina | 37141 | 8771 | 100 |
1838084 | 1838084 | 2021-10-21 | Pender | North Carolina | 37141 | 8766 | 100 |
1834835 | 1834835 | 2021-10-20 | Pender | North Carolina | 37141 | 8753 | 100 |
1831586 | 1831586 | 2021-10-19 | Pender | North Carolina | 37141 | 8751 | 98 |
1828337 | 1828337 | 2021-10-18 | Pender | North Carolina | 37141 | 8737 | 98 |
1825088 | 1825088 | 2021-10-17 | Pender | North Carolina | 37141 | 8709 | 97 |
1821839 | 1821839 | 2021-10-16 | Pender | North Carolina | 37141 | 8709 | 97 |
1818590 | 1818590 | 2021-10-15 | Pender | North Carolina | 37141 | 8709 | 97 |
1815341 | 1815341 | 2021-10-14 | Pender | North Carolina | 37141 | 8695 | 97 |
1812093 | 1812093 | 2021-10-13 | Pender | North Carolina | 37141 | 8651 | 95 |
1808844 | 1808844 | 2021-10-12 | Pender | North Carolina | 37141 | 8635 | 95 |
1805593 | 1805593 | 2021-10-11 | Pender | North Carolina | 37141 | 8616 | 95 |
1802344 | 1802344 | 2021-10-10 | Pender | North Carolina | 37141 | 8585 | 95 |
1799095 | 1799095 | 2021-10-09 | Pender | North Carolina | 37141 | 8585 | 95 |
1795846 | 1795846 | 2021-10-08 | Pender | North Carolina | 37141 | 8585 | 95 |
1792597 | 1792597 | 2021-10-07 | Pender | North Carolina | 37141 | 8576 | 95 |
1789348 | 1789348 | 2021-10-06 | Pender | North Carolina | 37141 | 8552 | 95 |
1786100 | 1786100 | 2021-10-05 | Pender | North Carolina | 37141 | 8550 | 94 |
1782851 | 1782851 | 2021-10-04 | Pender | North Carolina | 37141 | 8538 | 94 |
1779602 | 1779602 | 2021-10-03 | Pender | North Carolina | 37141 | 8492 | 93 |
1776352 | 1776352 | 2021-10-02 | Pender | North Carolina | 37141 | 8492 | 93 |
1773102 | 1773102 | 2021-10-01 | Pender | North Carolina | 37141 | 8492 | 93 |
1769852 | 1769852 | 2021-09-30 | Pender | North Carolina | 37141 | 8475 | 93 |
1766603 | 1766603 | 2021-09-29 | Pender | North Carolina | 37141 | 8454 | 93 |
1763354 | 1763354 | 2021-09-28 | Pender | North Carolina | 37141 | 8441 | 93 |
1760105 | 1760105 | 2021-09-27 | Pender | North Carolina | 37141 | 8425 | 93 |
1756857 | 1756857 | 2021-09-26 | Pender | North Carolina | 37141 | 8328 | 92 |
1753609 | 1753609 | 2021-09-25 | Pender | North Carolina | 37141 | 8328 | 92 |
1750361 | 1750361 | 2021-09-24 | Pender | North Carolina | 37141 | 8328 | 92 |
1747111 | 1747111 | 2021-09-23 | Pender | North Carolina | 37141 | 8296 | 92 |
1743862 | 1743862 | 2021-09-22 | Pender | North Carolina | 37141 | 8246 | 92 |
1740613 | 1740613 | 2021-09-21 | Pender | North Carolina | 37141 | 8232 | 91 |
1737364 | 1737364 | 2021-09-20 | Pender | North Carolina | 37141 | 8202 | 91 |
1734114 | 1734114 | 2021-09-19 | Pender | North Carolina | 37141 | 8049 | 87 |
1730864 | 1730864 | 2021-09-18 | Pender | North Carolina | 37141 | 8049 | 87 |
1727614 | 1727614 | 2021-09-17 | Pender | North Carolina | 37141 | 8049 | 87 |
1724365 | 1724365 | 2021-09-16 | Pender | North Carolina | 37141 | 7965 | 87 |
1721116 | 1721116 | 2021-09-15 | Pender | North Carolina | 37141 | 7938 | 81 |
1717868 | 1717868 | 2021-09-14 | Pender | North Carolina | 37141 | 7876 | 81 |
1714620 | 1714620 | 2021-09-13 | Pender | North Carolina | 37141 | 7851 | 81 |
1711374 | 1711374 | 2021-09-12 | Pender | North Carolina | 37141 | 7591 | 81 |
1708127 | 1708127 | 2021-09-11 | Pender | North Carolina | 37141 | 7591 | 81 |
1704880 | 1704880 | 2021-09-10 | Pender | North Carolina | 37141 | 7591 | 81 |
1701630 | 1701630 | 2021-09-09 | Pender | North Carolina | 37141 | 7569 | 80 |
1698381 | 1698381 | 2021-09-08 | Pender | North Carolina | 37141 | 7548 | 80 |
1695133 | 1695133 | 2021-09-07 | Pender | North Carolina | 37141 | 7513 | 80 |
1691885 | 1691885 | 2021-09-06 | Pender | North Carolina | 37141 | 7334 | 80 |
1688635 | 1688635 | 2021-09-05 | Pender | North Carolina | 37141 | 7334 | 80 |
1685385 | 1685385 | 2021-09-04 | Pender | North Carolina | 37141 | 7334 | 80 |
1682134 | 1682134 | 2021-09-03 | Pender | North Carolina | 37141 | 7334 | 80 |
1678885 | 1678885 | 2021-09-02 | Pender | North Carolina | 37141 | 7254 | 80 |
1675637 | 1675637 | 2021-09-01 | Pender | North Carolina | 37141 | 7195 | 79 |
1672390 | 1672390 | 2021-08-31 | Pender | North Carolina | 37141 | 7157 | 78 |
1669142 | 1669142 | 2021-08-30 | Pender | North Carolina | 37141 | 7107 | 77 |
1665895 | 1665895 | 2021-08-29 | Pender | North Carolina | 37141 | 6891 | 75 |
1662647 | 1662647 | 2021-08-28 | Pender | North Carolina | 37141 | 6891 | 75 |
1659399 | 1659399 | 2021-08-27 | Pender | North Carolina | 37141 | 6891 | 75 |
1656150 | 1656150 | 2021-08-26 | Pender | North Carolina | 37141 | 6807 | 75 |
1652903 | 1652903 | 2021-08-25 | Pender | North Carolina | 37141 | 6746 | 74 |
1649655 | 1649655 | 2021-08-24 | Pender | North Carolina | 37141 | 6725 | 74 |
1646406 | 1646406 | 2021-08-23 | Pender | North Carolina | 37141 | 6692 | 74 |
1643157 | 1643157 | 2021-08-22 | Pender | North Carolina | 37141 | 6543 | 74 |
1639907 | 1639907 | 2021-08-21 | Pender | North Carolina | 37141 | 6543 | 74 |
1636657 | 1636657 | 2021-08-20 | Pender | North Carolina | 37141 | 6543 | 74 |
1633407 | 1633407 | 2021-08-19 | Pender | North Carolina | 37141 | 6489 | 72 |
1630160 | 1630160 | 2021-08-18 | Pender | North Carolina | 37141 | 6439 | 72 |
1626913 | 1626913 | 2021-08-17 | Pender | North Carolina | 37141 | 6416 | 72 |
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);