ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Pamlico" 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 |
---|---|---|---|---|---|---|---|
1812091 | 1812091 | 2021-10-13 | Pamlico | North Carolina | 37137 | 1676 | 24 |
1808842 | 1808842 | 2021-10-12 | Pamlico | North Carolina | 37137 | 1662 | 23 |
1805591 | 1805591 | 2021-10-11 | Pamlico | North Carolina | 37137 | 1659 | 23 |
1802342 | 1802342 | 2021-10-10 | Pamlico | North Carolina | 37137 | 1647 | 23 |
1799093 | 1799093 | 2021-10-09 | Pamlico | North Carolina | 37137 | 1647 | 23 |
1795844 | 1795844 | 2021-10-08 | Pamlico | North Carolina | 37137 | 1647 | 23 |
1792595 | 1792595 | 2021-10-07 | Pamlico | North Carolina | 37137 | 1642 | 23 |
1789346 | 1789346 | 2021-10-06 | Pamlico | North Carolina | 37137 | 1639 | 23 |
1786098 | 1786098 | 2021-10-05 | Pamlico | North Carolina | 37137 | 1629 | 20 |
1782849 | 1782849 | 2021-10-04 | Pamlico | North Carolina | 37137 | 1630 | 20 |
1779600 | 1779600 | 2021-10-03 | Pamlico | North Carolina | 37137 | 1607 | 20 |
1776350 | 1776350 | 2021-10-02 | Pamlico | North Carolina | 37137 | 1607 | 20 |
1773100 | 1773100 | 2021-10-01 | Pamlico | North Carolina | 37137 | 1607 | 20 |
1769850 | 1769850 | 2021-09-30 | Pamlico | North Carolina | 37137 | 1599 | 19 |
1766601 | 1766601 | 2021-09-29 | Pamlico | North Carolina | 37137 | 1593 | 19 |
1763352 | 1763352 | 2021-09-28 | Pamlico | North Carolina | 37137 | 1582 | 19 |
1760103 | 1760103 | 2021-09-27 | Pamlico | North Carolina | 37137 | 1585 | 19 |
1756855 | 1756855 | 2021-09-26 | Pamlico | North Carolina | 37137 | 1558 | 19 |
1753607 | 1753607 | 2021-09-25 | Pamlico | North Carolina | 37137 | 1558 | 19 |
1750359 | 1750359 | 2021-09-24 | Pamlico | North Carolina | 37137 | 1558 | 19 |
1747109 | 1747109 | 2021-09-23 | Pamlico | North Carolina | 37137 | 1554 | 19 |
1743860 | 1743860 | 2021-09-22 | Pamlico | North Carolina | 37137 | 1543 | 19 |
1740611 | 1740611 | 2021-09-21 | Pamlico | North Carolina | 37137 | 1529 | 19 |
1737362 | 1737362 | 2021-09-20 | Pamlico | North Carolina | 37137 | 1519 | 19 |
1734112 | 1734112 | 2021-09-19 | Pamlico | North Carolina | 37137 | 1494 | 17 |
1730862 | 1730862 | 2021-09-18 | Pamlico | North Carolina | 37137 | 1494 | 17 |
1727612 | 1727612 | 2021-09-17 | Pamlico | North Carolina | 37137 | 1494 | 17 |
1724363 | 1724363 | 2021-09-16 | Pamlico | North Carolina | 37137 | 1470 | 15 |
1721114 | 1721114 | 2021-09-15 | Pamlico | North Carolina | 37137 | 1465 | 15 |
1717866 | 1717866 | 2021-09-14 | Pamlico | North Carolina | 37137 | 1450 | 15 |
1714618 | 1714618 | 2021-09-13 | Pamlico | North Carolina | 37137 | 1442 | 15 |
1711372 | 1711372 | 2021-09-12 | Pamlico | North Carolina | 37137 | 1381 | 14 |
1708125 | 1708125 | 2021-09-11 | Pamlico | North Carolina | 37137 | 1381 | 14 |
1704878 | 1704878 | 2021-09-10 | Pamlico | North Carolina | 37137 | 1381 | 14 |
1701628 | 1701628 | 2021-09-09 | Pamlico | North Carolina | 37137 | 1369 | 14 |
1698379 | 1698379 | 2021-09-08 | Pamlico | North Carolina | 37137 | 1351 | 14 |
1695131 | 1695131 | 2021-09-07 | Pamlico | North Carolina | 37137 | 1353 | 14 |
1691883 | 1691883 | 2021-09-06 | Pamlico | North Carolina | 37137 | 1318 | 14 |
1688633 | 1688633 | 2021-09-05 | Pamlico | North Carolina | 37137 | 1318 | 14 |
1685383 | 1685383 | 2021-09-04 | Pamlico | North Carolina | 37137 | 1318 | 14 |
1682132 | 1682132 | 2021-09-03 | Pamlico | North Carolina | 37137 | 1318 | 14 |
1678883 | 1678883 | 2021-09-02 | Pamlico | North Carolina | 37137 | 1308 | 14 |
1675635 | 1675635 | 2021-09-01 | Pamlico | North Carolina | 37137 | 1304 | 14 |
1672388 | 1672388 | 2021-08-31 | Pamlico | North Carolina | 37137 | 1297 | 14 |
1669140 | 1669140 | 2021-08-30 | Pamlico | North Carolina | 37137 | 1288 | 14 |
1665893 | 1665893 | 2021-08-29 | Pamlico | North Carolina | 37137 | 1267 | 14 |
1662645 | 1662645 | 2021-08-28 | Pamlico | North Carolina | 37137 | 1267 | 14 |
1659397 | 1659397 | 2021-08-27 | Pamlico | North Carolina | 37137 | 1267 | 14 |
1656148 | 1656148 | 2021-08-26 | Pamlico | North Carolina | 37137 | 1262 | 14 |
1652901 | 1652901 | 2021-08-25 | Pamlico | North Carolina | 37137 | 1252 | 14 |
1649653 | 1649653 | 2021-08-24 | Pamlico | North Carolina | 37137 | 1247 | 14 |
1646404 | 1646404 | 2021-08-23 | Pamlico | North Carolina | 37137 | 1242 | 14 |
1643155 | 1643155 | 2021-08-22 | Pamlico | North Carolina | 37137 | 1230 | 14 |
1639905 | 1639905 | 2021-08-21 | Pamlico | North Carolina | 37137 | 1230 | 14 |
1636655 | 1636655 | 2021-08-20 | Pamlico | North Carolina | 37137 | 1230 | 14 |
1633405 | 1633405 | 2021-08-19 | Pamlico | North Carolina | 37137 | 1224 | 14 |
1630158 | 1630158 | 2021-08-18 | Pamlico | North Carolina | 37137 | 1214 | 14 |
1626911 | 1626911 | 2021-08-17 | Pamlico | North Carolina | 37137 | 1209 | 14 |
1623664 | 1623664 | 2021-08-16 | Pamlico | North Carolina | 37137 | 1208 | 14 |
1620417 | 1620417 | 2021-08-15 | Pamlico | North Carolina | 37137 | 1191 | 14 |
1617169 | 1617169 | 2021-08-14 | Pamlico | North Carolina | 37137 | 1191 | 14 |
1613921 | 1613921 | 2021-08-13 | Pamlico | North Carolina | 37137 | 1191 | 14 |
1610672 | 1610672 | 2021-08-12 | Pamlico | North Carolina | 37137 | 1188 | 14 |
1607424 | 1607424 | 2021-08-11 | Pamlico | North Carolina | 37137 | 1177 | 14 |
1604175 | 1604175 | 2021-08-10 | Pamlico | North Carolina | 37137 | 1173 | 14 |
1600926 | 1600926 | 2021-08-09 | Pamlico | North Carolina | 37137 | 1169 | 14 |
1597678 | 1597678 | 2021-08-08 | Pamlico | North Carolina | 37137 | 1165 | 13 |
1594429 | 1594429 | 2021-08-07 | Pamlico | North Carolina | 37137 | 1165 | 13 |
1591180 | 1591180 | 2021-08-06 | Pamlico | North Carolina | 37137 | 1165 | 13 |
1587931 | 1587931 | 2021-08-05 | Pamlico | North Carolina | 37137 | 1156 | 13 |
1584681 | 1584681 | 2021-08-04 | Pamlico | North Carolina | 37137 | 1156 | 13 |
1581431 | 1581431 | 2021-08-03 | Pamlico | North Carolina | 37137 | 1150 | 13 |
1578182 | 1578182 | 2021-08-02 | Pamlico | North Carolina | 37137 | 1148 | 13 |
1574934 | 1574934 | 2021-08-01 | Pamlico | North Carolina | 37137 | 1143 | 13 |
1571686 | 1571686 | 2021-07-31 | Pamlico | North Carolina | 37137 | 1143 | 13 |
1568438 | 1568438 | 2021-07-30 | Pamlico | North Carolina | 37137 | 1143 | 13 |
1565190 | 1565190 | 2021-07-29 | Pamlico | North Carolina | 37137 | 1140 | 13 |
1561942 | 1561942 | 2021-07-28 | Pamlico | North Carolina | 37137 | 1138 | 13 |
1558694 | 1558694 | 2021-07-27 | Pamlico | North Carolina | 37137 | 1137 | 13 |
1555447 | 1555447 | 2021-07-26 | Pamlico | North Carolina | 37137 | 1138 | 13 |
1552200 | 1552200 | 2021-07-25 | Pamlico | North Carolina | 37137 | 1133 | 13 |
1548953 | 1548953 | 2021-07-24 | Pamlico | North Carolina | 37137 | 1133 | 13 |
1545706 | 1545706 | 2021-07-23 | Pamlico | North Carolina | 37137 | 1133 | 13 |
1542459 | 1542459 | 2021-07-22 | Pamlico | North Carolina | 37137 | 1132 | 13 |
1539211 | 1539211 | 2021-07-21 | Pamlico | North Carolina | 37137 | 1128 | 13 |
1535964 | 1535964 | 2021-07-20 | Pamlico | North Carolina | 37137 | 1129 | 13 |
1532716 | 1532716 | 2021-07-19 | Pamlico | North Carolina | 37137 | 1128 | 13 |
1529469 | 1529469 | 2021-07-18 | Pamlico | North Carolina | 37137 | 1123 | 13 |
1526222 | 1526222 | 2021-07-17 | Pamlico | North Carolina | 37137 | 1123 | 13 |
1522975 | 1522975 | 2021-07-16 | Pamlico | North Carolina | 37137 | 1123 | 13 |
1519727 | 1519727 | 2021-07-15 | Pamlico | North Carolina | 37137 | 1120 | 13 |
1516479 | 1516479 | 2021-07-14 | Pamlico | North Carolina | 37137 | 1120 | 13 |
1513232 | 1513232 | 2021-07-13 | Pamlico | North Carolina | 37137 | 1120 | 13 |
1509986 | 1509986 | 2021-07-12 | Pamlico | North Carolina | 37137 | 1120 | 13 |
1506739 | 1506739 | 2021-07-11 | Pamlico | North Carolina | 37137 | 1120 | 13 |
1503493 | 1503493 | 2021-07-10 | Pamlico | North Carolina | 37137 | 1120 | 13 |
1500247 | 1500247 | 2021-07-09 | Pamlico | North Carolina | 37137 | 1120 | 13 |
1497001 | 1497001 | 2021-07-08 | Pamlico | North Carolina | 37137 | 1120 | 13 |
1493754 | 1493754 | 2021-07-07 | Pamlico | North Carolina | 37137 | 1119 | 13 |
1490507 | 1490507 | 2021-07-06 | Pamlico | North Carolina | 37137 | 1118 | 13 |
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);