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 |
---|---|---|---|---|---|---|---|
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 |
1623666 | 1623666 | 2021-08-16 | Pender | North Carolina | 37141 | 6388 | 72 |
1620419 | 1620419 | 2021-08-15 | Pender | North Carolina | 37141 | 6232 | 72 |
1617171 | 1617171 | 2021-08-14 | Pender | North Carolina | 37141 | 6232 | 72 |
1613923 | 1613923 | 2021-08-13 | Pender | North Carolina | 37141 | 6232 | 72 |
1610674 | 1610674 | 2021-08-12 | Pender | North Carolina | 37141 | 6181 | 71 |
1607426 | 1607426 | 2021-08-11 | Pender | North Carolina | 37141 | 6150 | 71 |
1604177 | 1604177 | 2021-08-10 | Pender | North Carolina | 37141 | 6136 | 70 |
1600928 | 1600928 | 2021-08-09 | Pender | North Carolina | 37141 | 6112 | 70 |
1597680 | 1597680 | 2021-08-08 | Pender | North Carolina | 37141 | 5991 | 70 |
1594431 | 1594431 | 2021-08-07 | Pender | North Carolina | 37141 | 5991 | 70 |
1591182 | 1591182 | 2021-08-06 | Pender | North Carolina | 37141 | 5991 | 70 |
1587933 | 1587933 | 2021-08-05 | Pender | North Carolina | 37141 | 5971 | 69 |
1584683 | 1584683 | 2021-08-04 | Pender | North Carolina | 37141 | 5947 | 69 |
1581433 | 1581433 | 2021-08-03 | Pender | North Carolina | 37141 | 5938 | 69 |
1578184 | 1578184 | 2021-08-02 | Pender | North Carolina | 37141 | 5906 | 69 |
1574936 | 1574936 | 2021-08-01 | Pender | North Carolina | 37141 | 5827 | 69 |
1571688 | 1571688 | 2021-07-31 | Pender | North Carolina | 37141 | 5827 | 69 |
1568440 | 1568440 | 2021-07-30 | Pender | North Carolina | 37141 | 5827 | 69 |
1565192 | 1565192 | 2021-07-29 | Pender | North Carolina | 37141 | 5797 | 69 |
1561944 | 1561944 | 2021-07-28 | Pender | North Carolina | 37141 | 5772 | 69 |
1558696 | 1558696 | 2021-07-27 | Pender | North Carolina | 37141 | 5760 | 69 |
1555449 | 1555449 | 2021-07-26 | Pender | North Carolina | 37141 | 5752 | 69 |
1552202 | 1552202 | 2021-07-25 | Pender | North Carolina | 37141 | 5703 | 69 |
1548955 | 1548955 | 2021-07-24 | Pender | North Carolina | 37141 | 5703 | 69 |
1545708 | 1545708 | 2021-07-23 | Pender | North Carolina | 37141 | 5703 | 69 |
1542461 | 1542461 | 2021-07-22 | Pender | North Carolina | 37141 | 5681 | 69 |
1539213 | 1539213 | 2021-07-21 | Pender | North Carolina | 37141 | 5657 | 69 |
1535966 | 1535966 | 2021-07-20 | Pender | North Carolina | 37141 | 5647 | 69 |
1532718 | 1532718 | 2021-07-19 | Pender | North Carolina | 37141 | 5639 | 69 |
1529471 | 1529471 | 2021-07-18 | Pender | North Carolina | 37141 | 5619 | 69 |
1526224 | 1526224 | 2021-07-17 | Pender | North Carolina | 37141 | 5619 | 69 |
1522977 | 1522977 | 2021-07-16 | Pender | North Carolina | 37141 | 5619 | 69 |
1519729 | 1519729 | 2021-07-15 | Pender | North Carolina | 37141 | 5608 | 69 |
1516481 | 1516481 | 2021-07-14 | Pender | North Carolina | 37141 | 5597 | 69 |
1513234 | 1513234 | 2021-07-13 | Pender | North Carolina | 37141 | 5590 | 69 |
1509988 | 1509988 | 2021-07-12 | Pender | North Carolina | 37141 | 5587 | 69 |
1506741 | 1506741 | 2021-07-11 | Pender | North Carolina | 37141 | 5579 | 69 |
1503495 | 1503495 | 2021-07-10 | Pender | North Carolina | 37141 | 5579 | 69 |
1500249 | 1500249 | 2021-07-09 | Pender | North Carolina | 37141 | 5579 | 69 |
1497003 | 1497003 | 2021-07-08 | Pender | North Carolina | 37141 | 5574 | 69 |
1493756 | 1493756 | 2021-07-07 | Pender | North Carolina | 37141 | 5572 | 69 |
1490509 | 1490509 | 2021-07-06 | Pender | North Carolina | 37141 | 5563 | 69 |
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);