ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 37143 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 |
---|---|---|---|---|---|---|---|
1812094 | 1812094 | 2021-10-13 | Perquimans | North Carolina | 37143 | 1481 | 15 |
1808845 | 1808845 | 2021-10-12 | Perquimans | North Carolina | 37143 | 1475 | 15 |
1805594 | 1805594 | 2021-10-11 | Perquimans | North Carolina | 37143 | 1471 | 15 |
1802345 | 1802345 | 2021-10-10 | Perquimans | North Carolina | 37143 | 1463 | 15 |
1799096 | 1799096 | 2021-10-09 | Perquimans | North Carolina | 37143 | 1463 | 15 |
1795847 | 1795847 | 2021-10-08 | Perquimans | North Carolina | 37143 | 1463 | 15 |
1792598 | 1792598 | 2021-10-07 | Perquimans | North Carolina | 37143 | 1459 | 15 |
1789349 | 1789349 | 2021-10-06 | Perquimans | North Carolina | 37143 | 1457 | 15 |
1786101 | 1786101 | 2021-10-05 | Perquimans | North Carolina | 37143 | 1454 | 15 |
1782852 | 1782852 | 2021-10-04 | Perquimans | North Carolina | 37143 | 1449 | 15 |
1779603 | 1779603 | 2021-10-03 | Perquimans | North Carolina | 37143 | 1436 | 11 |
1776353 | 1776353 | 2021-10-02 | Perquimans | North Carolina | 37143 | 1436 | 11 |
1773103 | 1773103 | 2021-10-01 | Perquimans | North Carolina | 37143 | 1436 | 11 |
1769853 | 1769853 | 2021-09-30 | Perquimans | North Carolina | 37143 | 1431 | 11 |
1766604 | 1766604 | 2021-09-29 | Perquimans | North Carolina | 37143 | 1419 | 11 |
1763355 | 1763355 | 2021-09-28 | Perquimans | North Carolina | 37143 | 1412 | 11 |
1760106 | 1760106 | 2021-09-27 | Perquimans | North Carolina | 37143 | 1410 | 11 |
1756858 | 1756858 | 2021-09-26 | Perquimans | North Carolina | 37143 | 1389 | 11 |
1753610 | 1753610 | 2021-09-25 | Perquimans | North Carolina | 37143 | 1389 | 11 |
1750362 | 1750362 | 2021-09-24 | Perquimans | North Carolina | 37143 | 1389 | 11 |
1747112 | 1747112 | 2021-09-23 | Perquimans | North Carolina | 37143 | 1384 | 11 |
1743863 | 1743863 | 2021-09-22 | Perquimans | North Carolina | 37143 | 1375 | 11 |
1740614 | 1740614 | 2021-09-21 | Perquimans | North Carolina | 37143 | 1368 | 11 |
1737365 | 1737365 | 2021-09-20 | Perquimans | North Carolina | 37143 | 1366 | 11 |
1734115 | 1734115 | 2021-09-19 | Perquimans | North Carolina | 37143 | 1350 | 11 |
1730865 | 1730865 | 2021-09-18 | Perquimans | North Carolina | 37143 | 1350 | 11 |
1727615 | 1727615 | 2021-09-17 | Perquimans | North Carolina | 37143 | 1350 | 11 |
1724366 | 1724366 | 2021-09-16 | Perquimans | North Carolina | 37143 | 1338 | 11 |
1721117 | 1721117 | 2021-09-15 | Perquimans | North Carolina | 37143 | 1333 | 11 |
1717869 | 1717869 | 2021-09-14 | Perquimans | North Carolina | 37143 | 1326 | 11 |
1714621 | 1714621 | 2021-09-13 | Perquimans | North Carolina | 37143 | 1321 | 11 |
1711375 | 1711375 | 2021-09-12 | Perquimans | North Carolina | 37143 | 1281 | 11 |
1708128 | 1708128 | 2021-09-11 | Perquimans | North Carolina | 37143 | 1281 | 11 |
1704881 | 1704881 | 2021-09-10 | Perquimans | North Carolina | 37143 | 1281 | 11 |
1701631 | 1701631 | 2021-09-09 | Perquimans | North Carolina | 37143 | 1276 | 11 |
1698382 | 1698382 | 2021-09-08 | Perquimans | North Carolina | 37143 | 1271 | 11 |
1695134 | 1695134 | 2021-09-07 | Perquimans | North Carolina | 37143 | 1265 | 11 |
1691886 | 1691886 | 2021-09-06 | Perquimans | North Carolina | 37143 | 1218 | 11 |
1688636 | 1688636 | 2021-09-05 | Perquimans | North Carolina | 37143 | 1218 | 11 |
1685386 | 1685386 | 2021-09-04 | Perquimans | North Carolina | 37143 | 1218 | 11 |
1682135 | 1682135 | 2021-09-03 | Perquimans | North Carolina | 37143 | 1218 | 11 |
1678886 | 1678886 | 2021-09-02 | Perquimans | North Carolina | 37143 | 1215 | 11 |
1675638 | 1675638 | 2021-09-01 | Perquimans | North Carolina | 37143 | 1204 | 11 |
1672391 | 1672391 | 2021-08-31 | Perquimans | North Carolina | 37143 | 1201 | 11 |
1669143 | 1669143 | 2021-08-30 | Perquimans | North Carolina | 37143 | 1194 | 11 |
1665896 | 1665896 | 2021-08-29 | Perquimans | North Carolina | 37143 | 1175 | 11 |
1662648 | 1662648 | 2021-08-28 | Perquimans | North Carolina | 37143 | 1175 | 11 |
1659400 | 1659400 | 2021-08-27 | Perquimans | North Carolina | 37143 | 1175 | 11 |
1656151 | 1656151 | 2021-08-26 | Perquimans | North Carolina | 37143 | 1166 | 11 |
1652904 | 1652904 | 2021-08-25 | Perquimans | North Carolina | 37143 | 1154 | 11 |
1649656 | 1649656 | 2021-08-24 | Perquimans | North Carolina | 37143 | 1150 | 11 |
1646407 | 1646407 | 2021-08-23 | Perquimans | North Carolina | 37143 | 1146 | 11 |
1643158 | 1643158 | 2021-08-22 | Perquimans | North Carolina | 37143 | 1128 | 11 |
1639908 | 1639908 | 2021-08-21 | Perquimans | North Carolina | 37143 | 1128 | 11 |
1636658 | 1636658 | 2021-08-20 | Perquimans | North Carolina | 37143 | 1128 | 11 |
1633408 | 1633408 | 2021-08-19 | Perquimans | North Carolina | 37143 | 1123 | 11 |
1630161 | 1630161 | 2021-08-18 | Perquimans | North Carolina | 37143 | 1116 | 11 |
1626914 | 1626914 | 2021-08-17 | Perquimans | North Carolina | 37143 | 1113 | 11 |
1623667 | 1623667 | 2021-08-16 | Perquimans | North Carolina | 37143 | 1111 | 11 |
1620420 | 1620420 | 2021-08-15 | Perquimans | North Carolina | 37143 | 1097 | 11 |
1617172 | 1617172 | 2021-08-14 | Perquimans | North Carolina | 37143 | 1097 | 11 |
1613924 | 1613924 | 2021-08-13 | Perquimans | North Carolina | 37143 | 1097 | 11 |
1610675 | 1610675 | 2021-08-12 | Perquimans | North Carolina | 37143 | 1093 | 11 |
1607427 | 1607427 | 2021-08-11 | Perquimans | North Carolina | 37143 | 1088 | 11 |
1604178 | 1604178 | 2021-08-10 | Perquimans | North Carolina | 37143 | 1083 | 11 |
1600929 | 1600929 | 2021-08-09 | Perquimans | North Carolina | 37143 | 1082 | 11 |
1597681 | 1597681 | 2021-08-08 | Perquimans | North Carolina | 37143 | 1074 | 11 |
1594432 | 1594432 | 2021-08-07 | Perquimans | North Carolina | 37143 | 1074 | 11 |
1591183 | 1591183 | 2021-08-06 | Perquimans | North Carolina | 37143 | 1074 | 11 |
1587934 | 1587934 | 2021-08-05 | Perquimans | North Carolina | 37143 | 1072 | 11 |
1584684 | 1584684 | 2021-08-04 | Perquimans | North Carolina | 37143 | 1067 | 11 |
1581434 | 1581434 | 2021-08-03 | Perquimans | North Carolina | 37143 | 1065 | 11 |
1578185 | 1578185 | 2021-08-02 | Perquimans | North Carolina | 37143 | 1063 | 11 |
1574937 | 1574937 | 2021-08-01 | Perquimans | North Carolina | 37143 | 1055 | 11 |
1571689 | 1571689 | 2021-07-31 | Perquimans | North Carolina | 37143 | 1055 | 11 |
1568441 | 1568441 | 2021-07-30 | Perquimans | North Carolina | 37143 | 1055 | 11 |
1565193 | 1565193 | 2021-07-29 | Perquimans | North Carolina | 37143 | 1054 | 11 |
1561945 | 1561945 | 2021-07-28 | Perquimans | North Carolina | 37143 | 1053 | 11 |
1558697 | 1558697 | 2021-07-27 | Perquimans | North Carolina | 37143 | 1052 | 11 |
1555450 | 1555450 | 2021-07-26 | Perquimans | North Carolina | 37143 | 1052 | 11 |
1552203 | 1552203 | 2021-07-25 | Perquimans | North Carolina | 37143 | 1049 | 11 |
1548956 | 1548956 | 2021-07-24 | Perquimans | North Carolina | 37143 | 1049 | 11 |
1545709 | 1545709 | 2021-07-23 | Perquimans | North Carolina | 37143 | 1049 | 11 |
1542462 | 1542462 | 2021-07-22 | Perquimans | North Carolina | 37143 | 1045 | 11 |
1539214 | 1539214 | 2021-07-21 | Perquimans | North Carolina | 37143 | 1036 | 11 |
1535967 | 1535967 | 2021-07-20 | Perquimans | North Carolina | 37143 | 1035 | 11 |
1532719 | 1532719 | 2021-07-19 | Perquimans | North Carolina | 37143 | 1035 | 11 |
1529472 | 1529472 | 2021-07-18 | Perquimans | North Carolina | 37143 | 1034 | 11 |
1526225 | 1526225 | 2021-07-17 | Perquimans | North Carolina | 37143 | 1034 | 11 |
1522978 | 1522978 | 2021-07-16 | Perquimans | North Carolina | 37143 | 1034 | 11 |
1519730 | 1519730 | 2021-07-15 | Perquimans | North Carolina | 37143 | 1034 | 11 |
1516482 | 1516482 | 2021-07-14 | Perquimans | North Carolina | 37143 | 1034 | 11 |
1513235 | 1513235 | 2021-07-13 | Perquimans | North Carolina | 37143 | 1034 | 11 |
1509989 | 1509989 | 2021-07-12 | Perquimans | North Carolina | 37143 | 1034 | 11 |
1506742 | 1506742 | 2021-07-11 | Perquimans | North Carolina | 37143 | 1033 | 11 |
1503496 | 1503496 | 2021-07-10 | Perquimans | North Carolina | 37143 | 1033 | 11 |
1500250 | 1500250 | 2021-07-09 | Perquimans | North Carolina | 37143 | 1033 | 11 |
1497004 | 1497004 | 2021-07-08 | Perquimans | North Carolina | 37143 | 1034 | 11 |
1493757 | 1493757 | 2021-07-07 | Perquimans | North Carolina | 37143 | 1034 | 11 |
1490510 | 1490510 | 2021-07-06 | Perquimans | North Carolina | 37143 | 1034 | 11 |
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);