legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,365 rows where state = "NC"
This data as json, copyable, CSV (advanced)
party >10 ✖
- Democrat 745
- Republican 329
- Whig 74
- Jackson 59
- Federalist 14
- Populist 11
- Adams 6
- American 5
- Ind. Republican-Democrat 4
- Democratic Republican 2
- …
Link | rowid ▼ | legislator_id | type | state | start | end | class | party | district | how | party_affiliations | url | caucus | address | phone | fax | contact_form | office | state_rank | rss_url | end-type |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1381 | 1381 | Joseph Pearson P000168 | rep | NC | 1813-05-24 | 1815-03-03 | Federalist | 10 | |||||||||||||
1416 | 1416 | David Stone S000955 | rep | NC | 1799-12-02 | 1801-03-03 | Republican | 8 | |||||||||||||
1417 | 1417 | David Stone S000955 | sen | NC | 1801-12-07 | 1807-03-03 | 3 | Republican | |||||||||||||
1418 | 1418 | David Stone S000955 | sen | NC | 1813-05-24 | 1815-03-03 | 3 | Republican | |||||||||||||
1437 | 1437 | Francis Locke L000387 | sen | NC | 1814-01-01 | 1815-12-31 | 3 | Unknown | |||||||||||||
1500 | 1500 | James Clark C000438 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 3 | |||||||||||||
1550 | 1550 | Samuel Dickens D000306 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 8 | |||||||||||||
1568 | 1568 | William Gaston G000096 | rep | NC | 1813-05-24 | 1815-03-03 | Federalist | 4 | |||||||||||||
1569 | 1569 | William Gaston G000096 | rep | NC | 1815-12-04 | 1817-03-03 | Federalist | 4 | |||||||||||||
1650 | 1650 | William Love L000460 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 10 | |||||||||||||
1681 | 1681 | William Murfree M001084 | rep | NC | 1813-05-24 | 1815-03-03 | Republican | 1 | |||||||||||||
1682 | 1682 | William Murfree M001084 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
1699 | 1699 | John Sevier S000257 | rep | NC | 1789-03-04 | 1791-03-03 | Republican | 5 | |||||||||||||
1712 | 1712 | Richard Stanford S000794 | rep | NC | 1797-05-15 | 1799-03-03 | Republican | 4 | |||||||||||||
1713 | 1713 | Richard Stanford S000794 | rep | NC | 1799-12-02 | 1801-03-03 | Republican | 4 | |||||||||||||
1714 | 1714 | Richard Stanford S000794 | rep | NC | 1801-12-07 | 1803-03-03 | Republican | 4 | |||||||||||||
1715 | 1715 | Richard Stanford S000794 | rep | NC | 1803-10-17 | 1805-03-03 | Republican | 8 | |||||||||||||
1716 | 1716 | Richard Stanford S000794 | rep | NC | 1805-12-02 | 1807-03-03 | Republican | 8 | |||||||||||||
1717 | 1717 | Richard Stanford S000794 | rep | NC | 1807-10-26 | 1809-03-03 | Republican | 8 | |||||||||||||
1718 | 1718 | Richard Stanford S000794 | rep | NC | 1809-05-22 | 1811-03-03 | Republican | 8 | |||||||||||||
1719 | 1719 | Richard Stanford S000794 | rep | NC | 1811-11-04 | 1813-03-03 | Republican | 8 | |||||||||||||
1720 | 1720 | Richard Stanford S000794 | rep | NC | 1813-05-24 | 1815-03-03 | Republican | 8 | |||||||||||||
1721 | 1721 | Richard Stanford S000794 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 8 | |||||||||||||
1775 | 1775 | Bartlett Yancey Y000001 | rep | NC | 1813-05-24 | 1815-03-03 | Republican | 9 | |||||||||||||
1776 | 1776 | Bartlett Yancey Y000001 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 9 | |||||||||||||
1789 | 1789 | Montfort Stokes S000949 | sen | NC | 1816-12-04 | 1817-03-03 | 2 | Republican | |||||||||||||
1790 | 1790 | Montfort Stokes S000949 | sen | NC | 1817-03-04 | 1823-03-03 | 2 | Republican | |||||||||||||
1806 | 1806 | Joseph Bryan B000990 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 2 | |||||||||||||
1807 | 1807 | Joseph Bryan B000990 | rep | NC | 1817-12-01 | 1819-03-03 | Republican | 2 | |||||||||||||
1841 | 1841 | Daniel Forney F000278 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 11 | |||||||||||||
1842 | 1842 | Daniel Forney F000278 | rep | NC | 1817-12-01 | 1819-03-03 | Republican | 11 | |||||||||||||
1881 | 1881 | George Mumford M001075 | rep | NC | 1817-12-01 | 1819-03-03 | Republican | 10 | |||||||||||||
1891 | 1891 | James Owen O000151 | rep | NC | 1817-12-01 | 1819-03-03 | Republican | 5 | |||||||||||||
1928 | 1928 | James Stewart S000909 | rep | NC | 1817-12-01 | 1819-03-03 | Federalist | 7 | |||||||||||||
2009 | 2009 | William Davidson D000087 | rep | NC | 1817-12-01 | 1819-03-03 | Federalist | 11 | |||||||||||||
2010 | 2010 | William Davidson D000087 | rep | NC | 1819-12-06 | 1821-03-03 | Federalist | 11 | |||||||||||||
2126 | 2126 | Thomas Settle S000254 | rep | NC | 1817-12-01 | 1819-03-03 | Republican | 9 | |||||||||||||
2127 | 2127 | Thomas Settle S000254 | rep | NC | 1819-12-06 | 1821-03-03 | Republican | 9 | |||||||||||||
2132 | 2132 | Jesse Slocumb S000497 | rep | NC | 1817-12-01 | 1819-03-03 | Federalist | 4 | |||||||||||||
2133 | 2133 | Jesse Slocumb S000497 | rep | NC | 1819-12-06 | 1821-03-03 | Federalist | 4 | |||||||||||||
2138 | 2138 | James Smith S000559 | rep | NC | 1817-12-01 | 1819-03-03 | Republican | 8 | |||||||||||||
2139 | 2139 | James Smith S000559 | rep | NC | 1819-12-06 | 1821-03-03 | Republican | 8 | |||||||||||||
2202 | 2202 | William Blackledge B000512 | rep | NC | 1819-12-06 | 1821-03-03 | Republican | 4 | |||||||||||||
2203 | 2203 | William Blackledge B000512 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 4 | |||||||||||||
2223 | 2223 | Josiah Crudup C000953 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 8 | |||||||||||||
2341 | 2341 | Felix Walker W000050 | rep | NC | 1817-12-01 | 1819-03-03 | Republican | 12 | |||||||||||||
2342 | 2342 | Felix Walker W000050 | rep | NC | 1819-12-06 | 1821-03-03 | Republican | 12 | |||||||||||||
2343 | 2343 | Felix Walker W000050 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 12 | |||||||||||||
2384 | 2384 | Hutchins Burton B001152 | rep | NC | 1819-12-06 | 1821-03-03 | Republican | 2 | |||||||||||||
2385 | 2385 | Hutchins Burton B001152 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2386 | 2386 | Hutchins Burton B001152 | rep | NC | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2419 | 2419 | Alfred Gatlin G000099 | rep | NC | 1823-12-01 | 1825-03-03 | Crawford Republican | 1 | |||||||||||||
2427 | 2427 | Charles Hooks H000761 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 5 | |||||||||||||
2428 | 2428 | Charles Hooks H000761 | rep | NC | 1819-12-06 | 1821-03-03 | Republican | 5 | |||||||||||||
2429 | 2429 | Charles Hooks H000761 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 5 | |||||||||||||
2430 | 2430 | Charles Hooks H000761 | rep | NC | 1823-12-01 | 1825-03-03 | Republican | 5 | |||||||||||||
2455 | 2455 | George Outlaw O000139 | rep | NC | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2490 | 2490 | Richard Spaight S000694 | rep | NC | 1823-12-01 | 1825-03-03 | 4 | ||||||||||||||
2522 | 2522 | Robert Vance V000018 | rep | NC | 1823-12-01 | 1825-03-03 | 12 | ||||||||||||||
2590 | 2590 | Weldon Edwards E000083 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 6 | |||||||||||||
2591 | 2591 | Weldon Edwards E000083 | rep | NC | 1817-12-01 | 1819-03-03 | Republican | 6 | |||||||||||||
2592 | 2592 | Weldon Edwards E000083 | rep | NC | 1819-12-06 | 1821-03-03 | Republican | 6 | |||||||||||||
2593 | 2593 | Weldon Edwards E000083 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 6 | |||||||||||||
2594 | 2594 | Weldon Edwards E000083 | rep | NC | 1823-12-01 | 1825-03-03 | Republican | 6 | |||||||||||||
2595 | 2595 | Weldon Edwards E000083 | rep | NC | 1825-12-05 | 1827-03-03 | Jackson | 6 | |||||||||||||
2633 | 2633 | Richard Hines H000634 | rep | NC | 1825-12-05 | 1827-03-03 | Jackson | 3 | |||||||||||||
2664 | 2664 | Nathaniel Macon M000034 | rep | NC | 1791-10-24 | 1793-03-03 | Democratic Republican | 2 | |||||||||||||
2665 | 2665 | Nathaniel Macon M000034 | rep | NC | 1793-12-02 | 1795-03-03 | Democratic Republican | 5 | |||||||||||||
2666 | 2666 | Nathaniel Macon M000034 | rep | NC | 1795-12-07 | 1797-03-03 | Republican | 5 | |||||||||||||
2667 | 2667 | Nathaniel Macon M000034 | rep | NC | 1797-05-15 | 1799-03-03 | Republican | 5 | |||||||||||||
2668 | 2668 | Nathaniel Macon M000034 | rep | NC | 1799-12-02 | 1801-03-03 | Republican | 5 | |||||||||||||
2669 | 2669 | Nathaniel Macon M000034 | rep | NC | 1801-12-07 | 1803-03-03 | Republican | 5 | |||||||||||||
2670 | 2670 | Nathaniel Macon M000034 | rep | NC | 1803-10-17 | 1805-03-03 | Republican | 6 | |||||||||||||
2671 | 2671 | Nathaniel Macon M000034 | rep | NC | 1805-12-02 | 1807-03-03 | Republican | 6 | |||||||||||||
2672 | 2672 | Nathaniel Macon M000034 | rep | NC | 1807-10-26 | 1809-03-03 | Republican | 6 | |||||||||||||
2673 | 2673 | Nathaniel Macon M000034 | rep | NC | 1809-05-22 | 1811-03-03 | Republican | 6 | |||||||||||||
2674 | 2674 | Nathaniel Macon M000034 | rep | NC | 1811-11-04 | 1813-03-03 | Republican | 6 | |||||||||||||
2675 | 2675 | Nathaniel Macon M000034 | rep | NC | 1813-05-24 | 1815-03-03 | Republican | 6 | |||||||||||||
2676 | 2676 | Nathaniel Macon M000034 | rep | NC | 1815-12-04 | 1815-12-13 | Republican | 6 | |||||||||||||
2677 | 2677 | Nathaniel Macon M000034 | sen | NC | 1815-12-13 | 1819-03-03 | 3 | Republican | |||||||||||||
2678 | 2678 | Nathaniel Macon M000034 | sen | NC | 1819-12-06 | 1825-03-03 | 3 | Republican | |||||||||||||
2679 | 2679 | Nathaniel Macon M000034 | sen | NC | 1825-12-05 | 1828-11-14 | 3 | Jackson | |||||||||||||
2685 | 2685 | Archibald McNeill M000586 | rep | NC | 1821-12-03 | 1823-03-03 | Federalist | 7 | |||||||||||||
2686 | 2686 | Archibald McNeill M000586 | rep | NC | 1825-12-05 | 1827-03-03 | Jackson | 7 | |||||||||||||
2751 | 2751 | Israel Pickens P000322 | rep | NC | 1811-11-04 | 1813-03-03 | Republican | 11 | |||||||||||||
2752 | 2752 | Israel Pickens P000322 | rep | NC | 1813-05-24 | 1815-03-03 | Republican | 12 | |||||||||||||
2753 | 2753 | Israel Pickens P000322 | rep | NC | 1815-12-04 | 1817-03-03 | Republican | 12 | |||||||||||||
2804 | 2804 | John Bryan B000988 | rep | NC | 1825-12-05 | 1827-03-03 | Jackson | 4 | |||||||||||||
2805 | 2805 | John Bryan B000988 | rep | NC | 1827-12-03 | 1829-03-03 | Adams | 4 | |||||||||||||
2823 | 2823 | John Culpepper C000976 | rep | NC | 1807-10-26 | 1809-03-03 | Federalist | 7 | |||||||||||||
2824 | 2824 | John Culpepper C000976 | rep | NC | 1813-05-24 | 1815-03-03 | Federalist | 7 | |||||||||||||
2825 | 2825 | John Culpepper C000976 | rep | NC | 1815-12-04 | 1817-03-03 | Federalist | 7 | |||||||||||||
2826 | 2826 | John Culpepper C000976 | rep | NC | 1819-12-06 | 1821-03-03 | Federalist | 7 | |||||||||||||
2827 | 2827 | John Culpepper C000976 | rep | NC | 1823-12-01 | 1825-03-03 | Federalist | 7 | |||||||||||||
2828 | 2828 | John Culpepper C000976 | rep | NC | 1827-12-03 | 1829-03-03 | Adams | 7 | |||||||||||||
2881 | 2881 | John Long L000421 | rep | NC | 1821-12-03 | 1823-03-03 | Republican | 10 | |||||||||||||
2882 | 2882 | John Long L000421 | rep | NC | 1823-12-01 | 1825-03-03 | 10 | ||||||||||||||
2883 | 2883 | John Long L000421 | rep | NC | 1825-12-05 | 1827-03-03 | Adams | 10 | |||||||||||||
2884 | 2884 | John Long L000421 | rep | NC | 1827-12-03 | 1829-03-03 | Adams | 10 | |||||||||||||
2941 | 2941 | Lemuel Sawyer S000089 | rep | NC | 1807-10-26 | 1809-03-03 | Republican | 1 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [legislator_terms] ( [legislator_id] TEXT REFERENCES [legislators]([id]), [type] TEXT, [state] TEXT, [start] TEXT, [end] TEXT, [class] INTEGER, [party] TEXT , [district] INTEGER, [how] TEXT, [party_affiliations] TEXT, [url] TEXT, [caucus] TEXT, [address] TEXT, [phone] TEXT, [fax] TEXT, [contact_form] TEXT, [office] TEXT, [state_rank] TEXT, [rss_url] TEXT, [end-type] TEXT);