home / openregs

congress_members

All current and historical members of Congress (12,700+) from the congress-legislators project. Includes bioguide_id (universal key), party, state, chamber, and federal cross-reference IDs (FEC, Library of Congress THOMAS/LIS).

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

381 rows where state = "NC" sorted by full_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: nickname, district, gender, terms_count, trade_count, first_served (date), last_served (date), birthday (date), served_until (date), fec_ids (array)

party 19

  • Democrat 174
  • Republican 122
  • Whig 22
  • Federalist 14
  • Jackson 13
  • - 11
  • Populist 7
  • Adams 3
  • American 3
  • Ind. Republican-Democrat 2
  • Pro-Administration 2
  • Anti-Administration 1
  • Conservative 1
  • Crawford Republican 1
  • Ind. Democrat 1
  • Independent 1
  • Jacksonian 1
  • National Greenbacker 1
  • Unknown 1

is_current 2

  • 0 365
  • 1 16

chamber 2

  • House 328
  • Senate 53

state 1

  • NC · 381 ✖
bioguide_id first_name last_name full_name ▼ nickname party state chamber district first_served last_served is_current fec_ids thomas_id lis_id birthday gender terms_count served_until trade_count speech_count bills_sponsored vote_count fec_total_received fec_ie_for fec_ie_against
R000162 Abraham Rencher Abraham Rencher   Whig NC House 10 1829-12-07 1843-03-03 0 []     1798-08-12 M 8 1843-03-03 0 0 0 0 0 0 0
V000084 Abraham Venable Abraham Venable   Democrat NC House 5 1847-12-06 1853-03-03 0 []     1799-10-17 M 4 1853-03-03 0 0 0 0 0 0 0
T000050 Absalom Tatom Absalom Tatom   Republican NC House 4 1795-12-07 1797-03-03 0 []       M 2 1797-03-03 0 0 0 0 0 0 0
M001240 Addison McDowell Addison P. McDowell   Republican NC House 6 2025-01-03 2027-01-03 1 ["H4NC06177"]     1994-01-21 M 2   0 32 17 645 692551 194137 0
J000208 Alexander Jones Alexander Jones   Republican NC House 7 1865-12-04 1871-03-03 0 []     1822-07-21 M 4 1871-03-03 0 0 0 0 0 0 0
M000166 Alexander Martin Alexander Martin   Republican NC Senate   1793-12-02 1799-03-03 0 []       M 2 1799-03-03 0 0 0 0 0 0 0
M000622 Alexander Mebane Alexander Mebane     NC House 4 1793-12-02 1795-03-03 0 []     1744-11-26 M 2 1795-03-03 0 0 0 0 0 0 0
B001056 Alfred Bulwinkle Alfred Bulwinkle   Democrat NC House 11 1921-04-11 1951-01-03 0 []     1883-04-21 M 16 1951-01-03 0 0 0 0 0 0 0
D000385 Alfred Dockery Alfred Dockery   Whig NC House 3 1845-12-01 1853-03-03 0 []     1797-12-11 M 5 1853-03-03 0 0 0 0 0 0 0
G000099 Alfred Gatlin Alfred Gatlin   Crawford Republican NC House 1 1823-12-01 1825-03-03 0 []     1790-04-20 M 2 1825-03-03 0 0 0 0 0 0 0
R000479 Alfred Rowland Alfred Rowland   Democrat NC House 6 1887-12-05 1891-03-03 0 []     1844-02-09 M 3 1891-03-03 0 0 0 0 0 0 0
S000103 Alfred Scales Alfred Scales   Democrat NC House 5 1857-12-07 1885-03-03 0 []     1827-11-26 M 15 1885-03-03 0 0 0 0 0 0 0
W000002 Alfred Waddell Alfred Waddell   Democrat NC House 3 1871-03-04 1879-03-03 0 []     1834-09-16 M 5 1879-03-03 0 0 0 0 0 0 0
A000370 Alma Adams Alma S. Adams   Democrat NC House 12 2014-11-12 2027-01-03 1 ["H4NC12100"] 02201   1946-05-27 F 7   0 252 177 6421 3389931 254447 50000
F000240 Alonzo Folger Alonzo Folger   Democrat NC House 5 1939-01-03 1943-01-03 0 []     1888-07-09 M 3 1943-01-03 0 0 0 0 0 0 0
S000389 Alonzo Shuford Alonzo Shuford   Populist NC House 7 1895-12-02 1899-03-03 0 []     1858-03-01 M 3 1899-03-03 0 0 0 0 0 0 0
L000240 Alton Lennon Alton Lennon   Democrat NC House 7 1953-07-10 1973-01-03 0 []     1906-08-17 M 11 1973-01-03 0 0 0 0 0 0 0
K000249 Alvin Kitchin Alvin Kitchin   Democrat NC House 8 1957-01-03 1963-01-03 0 []     1908-09-13 M 4 1963-01-03 0 0 0 0 0 0 0
M000804 Anderson Mitchell Anderson Mitchell   Whig NC House 13 1841-05-31 1843-03-03 0 []     1800-06-13 M 2 1843-03-03 0 0 0 0 0 0 0
A000302 Archibald Arrington Archibald Arrington   Democrat NC House 8 1841-05-31 1845-03-03 0 []     1809-11-13 M 3 1845-03-03 0 0 0 0 0 0 0
H000475 Archibald Henderson Archibald Henderson   Federalist NC House 2 1799-12-02 1803-03-03 0 []     1768-08-07 M 3 1803-03-03 0 0 0 0 0 0 0
M000302 Archibald McBryde Archibald McBryde   Federalist NC House 7 1809-05-22 1813-03-03 0 []     1766-09-28 M 3 1813-03-03 0 0 0 0 0 0 0
M000586 Archibald McNeill Archibald McNeill   Jackson NC House 7 1821-12-03 1827-03-03 0 []       M 4 1827-03-03 0 0 0 0 0 0 0
W000489 Archibald Williams Archibald Williams   Democrat NC House 5 1891-12-07 1893-03-03 0 []     1842-10-22 M 2 1893-03-03 0 0 0 0 0 0 0
B000456 Asa Biggs Asa Biggs   Democrat NC Senate   1845-12-01 1859-03-03 0 []     1811-02-04 M 3 1859-03-03 0 0 0 0 0 0 0
S000338 Augustine Shepperd Augustine Shepperd   Whig NC House 4 1827-12-03 1851-03-03 0 []     1792-02-24 M 13 1851-03-03 0 0 0 0 0 0 0
M000659 Augustus Merrimon Augustus Merrimon   Democrat NC Senate   1873-12-01 1879-03-03 0 []     1830-09-15 M 2 1879-03-03 0 0 0 0 0 0 0
Y000001 Bartlett Yancey Bartlett Yancey   Republican NC House 9 1813-05-24 1817-03-03 0 []     1785-02-19 M 3 1817-03-03 0 0 0 0 0 0 0
W000410 Basil Whitener Basil Whitener   Democrat NC House 10 1957-01-03 1969-01-03 0 []     1915-05-14 M 7 1969-01-03 0 0 0 0 0 0 0
B000903 Bedford Brown Bedford Brown   Democrat NC Senate   1829-12-07 1841-03-03 0 []     1795-06-06 M 3 1841-03-03 0 0 0 0 0 0 0
B001062 Benjamin Bunn Benjamin Bunn   Democrat NC House 4 1889-12-02 1895-03-03 0 []     1844-10-19 M 4 1895-03-03 0 0 0 0 0 0 0
G000350 Benjamin Grady Benjamin Grady   Democrat NC House 3 1891-12-07 1895-03-03 0 []     1831-10-10 M 3 1895-03-03 0 0 0 0 0 0 0
H000368 Benjamin Hawkins Benjamin Hawkins   Pro-Administration NC Senate   1789-03-04 1795-03-03 0 []     1754-08-15 M 2 1795-03-03 0 0 0 0 0 0 0
J000267 Benjamin Jordan Benjamin Jordan   Democrat NC Senate   1958-04-19 1973-01-03 0 []     1896-09-08 M 3 1973-01-03 0 0 0 0 0 0 0
W000491 Benjamin Williams Benjamin Williams     NC House 10 1793-12-02 1795-03-03 0 []     1751-01-01 M 2 1795-03-03 0 0 0 0 0 0 0
E000226 Bob Etheridge Bob Etheridge   Democrat NC House 2 1997-01-07 2011-01-03 0 ["H6NC02080"] 01482   1941-08-07 M 8 2011-01-03 0 797 64 5966 806359 280 442769
K000405 Brad Knott Brad Knott   Republican NC House 13 2025-01-03 2027-01-03 1 ["H4NC13116"]     1986-04-17 M 2   3 18 5 645 944985 1540530 365380
M001154 R. Miller Brad Miller Brad Democrat NC House 13 2003-01-07 2013-01-03 0 ["H2NC13029"] 01735   1953-05-19 M 6 2013-01-03 0 121 39 7572 558039 282 0
M000993 Cameron Morrison Cameron Morrison   Democrat NC House 10 1930-12-13 1945-01-03 0 []     1869-10-05 M 8 1945-01-03 0 0 0 0 0 0 0
D000571 Carl Durham Carl Durham   Democrat NC House 6 1939-01-03 1961-01-03 0 []     1892-08-28 M 12 1961-01-03 0 0 0 0 0 0 0
B000104 Cass Ballenger Cass Ballenger   Republican NC House 10 1986-11-04 2005-01-03 0 ["H6NC10117"] 00050   1926-12-06 M 10 2005-01-03 0 537 84 1221 0 0 0
A000015 Charles Abernethy Charles Abernethy   Democrat NC House 3 1921-04-11 1935-01-03 0 []     1872-03-18 M 8 1935-01-03 0 0 0 0 0 0 0
B000845 Charles Britt Charles Britt   Democrat NC House 6 1983-01-03 1985-01-03 0 [] 00125   1942-06-29 M 2 1985-01-03 0 0 2 0 0 0 0
C000826 Charles Cowles Charles Cowles   Republican NC House 8 1909-03-15 1911-03-03 0 []     1875-07-16 M 2 1911-03-03 0 0 0 0 0 0 0
D000175 Charles Deane Charles Deane   Democrat NC House 8 1947-01-03 1957-01-03 0 []     1898-11-01 M 6 1957-01-03 0 0 0 0 0 0 0
F000144 Charles Fisher Charles Fisher   Democrat NC House 10 1817-12-01 1841-03-03 0 []     1789-10-20 M 13 1841-03-03 0 0 0 0 0 0 0
H000761 Charles Hooks Charles Hooks   Republican NC House 5 1816-12-02 1825-03-03 0 []     1768-02-20 M 5 1825-03-03 0 0 0 0 0 0 0
J000123 Charles Johnson Charles Johnson   Republican NC House 8 1801-12-07 1803-03-03 0 []       M 2 1803-03-03 0 0 0 0 0 0 0
J000205 Charles Jonas Charles Jonas   Republican NC House 9 1929-04-15 1931-03-03 0 []     1876-08-14 M 2 1931-03-03 0 0 0 0 0 0 0
J000206 Charles Jonas Charles Jonas   Republican NC House 9 1953-01-03 1973-01-03 0 []     1904-12-09 M 11 1973-01-03 0 0 0 0 0 0 0
M000172 Charles Martin Charles Martin   Populist NC House 6 1895-12-02 1899-03-03 0 []     1848-08-28 M 3 1899-03-03 0 0 0 0 0 0 0
M000324 Charles McClammy Charles McClammy   Democrat NC House 3 1887-12-05 1891-03-03 0 []     1839-05-29 M 3 1891-03-03 0 0 0 0 0 0 0
R000436 Charles Rose Charles Rose   Democrat NC House 7 1973-01-03 1997-01-03 0 [] 00986   1939-08-10 M 13 1997-01-03 0 49 189 0 0 0 0
S000329 Charles Shepard Charles Shepard   Democrat NC House 4 1837-09-04 1841-03-03 0 []     1808-12-05 M 3 1841-03-03 0 0 0 0 0 0 0
S000827 Charles Stedman Charles Stedman   Democrat NC House 5 1911-04-04 1931-03-03 0 []     1841-01-29 M 11 1931-03-03 0 0 0 0 0 0 0
T000067 Charles Taylor Charles Taylor   Republican NC House 11 1991-01-03 2007-01-03 0 ["H8NC11038"] 01141   1941-01-23 M 9 2007-01-03 0 178 49 2435 0 0 0
T000158 Charles Thomas Charles Thomas   Republican NC House 2 1871-03-04 1875-03-03 0 []     1827-02-07 M 3 1875-03-03 0 0 0 0 0 0 0
T000159 Charles Thomas Charles Thomas   Democrat NC House 3 1899-12-04 1911-03-03 0 []     1861-08-21 M 7 1911-03-03 0 0 0 0 0 0 0
W000419 Charles Whitley Charles Whitley   Democrat NC House 3 1977-01-04 1987-01-03 0 [] 01223   1927-01-03 M 6 1987-01-03 0 0 16 0 0 0 0
E000246 Charles (Chuck) Edwards Chuck Edwards   Republican NC House 11 2023-01-03 2027-01-03 1 ["H2NC14050"]     1960-09-13 M 3   0 143 41 1886 1099457 331879 0
K000250 Claude Kitchin Claude Kitchin   Democrat NC House 2 1901-12-02 1925-03-03 0 []     1869-03-24 M 13 1925-03-03 0 0 0 0 0 0 0
D000463 Clement Dowd Clement Dowd   Democrat NC House 6 1881-12-05 1885-03-03 0 []     1832-08-27 M 3 1885-03-03 0 0 0 0 0 0 0
C000544 Clinton Cobb Clinton Cobb   Republican NC House 1 1869-03-04 1875-03-03 0 []     1842-08-25 M 4 1875-03-03 0 0 0 0 0 0 0
H000679 Clyde Hoey Clyde Hoey   Democrat NC Senate   1919-05-19 1954-05-12 0 []     1877-12-11 M 6 1954-05-12 0 0 0 0 0 0 0
B000863 Curtis Brogden Curtis Brogden   Republican NC House 2 1877-10-15 1879-03-03 0 []     1816-11-06 M 2 1879-03-03 0 0 0 0 0 0 0
B001311 Dan Bishop Dan Bishop   Republican NC House 8 2019-09-17 2025-01-03 0 ["H0NC09187"]     1964-07-01 M 4 2025-01-03 15 161 41 2662 986116 1529047 1473323
B000181 Daniel Barringer Daniel Barringer     NC House 8 1826-12-04 1835-03-03 0 []     1788-10-01 M 5 1835-03-03 0 0 0 0 0 0 0
B000182 Daniel Barringer Daniel Barringer   Whig NC House 3 1843-12-04 1849-03-03 0 []     1806-07-30 M 4 1849-03-03 0 0 0 0 0 0 0
F000278 Daniel Forney Daniel Forney   Republican NC House 11 1815-12-04 1819-03-03 0 []       M 3 1819-03-03 0 0 0 0 0 0 0
R000523 Daniel Russell Daniel Russell   National Greenbacker NC House 3 1879-03-18 1881-03-03 0 []     1845-08-07 M 2 1881-03-03 0 0 0 0 0 0 0
T000418 Daniel Turner Daniel Turner   Jackson NC House 6 1827-12-03 1829-03-03 0 []     1796-09-21 M 2 1829-03-03 0 0 0 0 0 0 0
P000523 David Price David E. Price   Democrat NC House 4 1987-01-06 2023-01-03 0 ["H6NC04037"] 00930   1940-08-17 M 19 2023-01-03 81 673 186 13262 3202962 1703 0
F000426 David Funderburk David Funderburk   Republican NC House 2 1995-01-04 1997-01-03 0 [] 00421   1944-04-28 M 2 1997-01-03 0 120 4 0 0 0 0
H000048 David Hall David Hall   Democrat NC House 12 1959-01-07 1961-01-03 0 []     1918-05-16 M 2 1961-01-03 0 0 0 0 0 0 0
H000432 David Heaton David Heaton   Republican NC House 2 1867-03-04 1871-03-03 0 []     1823-03-10 M 3 1871-03-03 0 0 0 0 0 0 0
H000479 David Henderson David Henderson   Democrat NC House 3 1961-01-03 1977-01-03 0 [] 00530   1921-04-16 M 9 1977-01-03 0 0 92 0 0 0 0
O000138 David Outlaw David Outlaw   Whig NC House 9 1847-12-06 1853-03-03 0 []     1806-09-14 M 4 1853-03-03 0 0 0 0 0 0 0
R000144 David Reid David Reid   Democrat NC Senate   1843-12-04 1859-03-03 0 []     1813-04-19 M 3 1859-03-03 0 0 0 0 0 0 0
R000603 David Rouzer David Rouzer   Republican NC House 7 2015-01-06 2027-01-03 1 ["H2NC07096"] 02256   1972-02-16 M 7   18 162 97 6373 6293478 249540 1802907
S000955 David Stone David Stone   Republican NC Senate   1799-12-02 1815-03-03 0 []     1770-02-17 M 3 1815-03-03 0 0 0 0 0 0 0
R000305 Deborah Ross Deborah K. Ross   Democrat NC House 2 2021-01-03 2027-01-03 1 ["H0NC02125"]     1963-06-20 F 4   28 147 82 2884 2286081 18490 0
B001081 Dempsey Burges Dempsey Burges   Republican NC House 8 1795-12-07 1799-03-03 0 []       M 3 1799-03-03 0 0 0 0 0 0 0
D000230 Donald Davis Donald G. Davis   Democrat NC House 1 2023-01-03 2027-01-03 1 ["H2NC02287"]     1971-08-29 M 3   0 345 55 1886 3732534 4528278 16919
F000437 Duncan Faircloth Duncan Faircloth Lauch Republican NC Senate   1993-01-05 1999-01-03 0 [] 01329 S227 1928-01-14 M 2 1999-01-03 0 410 72 0 0 0 0
M000437 Duncan McFarlan Duncan McFarlan   Republican NC House 7 1805-12-02 1807-03-03 0 []       M 2 1807-03-03 0 0 0 0 0 0 0
R000545 Earl Ruth Earl Ruth   Republican NC House 8 1969-01-03 1975-01-03 0 [] 01005   1916-02-07 M 4 1975-01-03 0 0 3 0 0 0 0
P000270 Ebenezer Pettigrew Ebenezer Pettigrew   Whig NC House 3 1835-12-07 1837-03-03 0 []     1783-03-10 M 2 1837-03-03 0 0 0 0 0 0 0
B000507 Edmond Blackburn Edmond Blackburn   Republican NC House 8 1901-12-02 1907-03-03 0 []     1868-09-22 M 4 1907-03-03 0 0 0 0 0 0 0
D000181 Edmund Deberry Edmund Deberry   Whig NC House 3 1829-12-07 1851-03-03 0 []     1787-08-14 M 12 1851-03-03 0 0 0 0 0 0 0
D000512 Edward Dudley Edward Dudley   Jackson NC House 5 1829-12-07 1831-03-03 0 []     1789-12-15 M 2 1831-03-03 0 0 0 0 0 0 0
P000474 Edward Pou Edward Pou   Democrat NC House 4 1901-12-02 1935-01-03 0 []     1863-09-09 M 18 1935-01-03 0 0 0 0 0 0 0
S000799 Edward Stanly Edward Stanly   Whig NC House 8 1837-09-04 1853-03-03 0 []     1810-01-10 M 9 1853-03-03 0 0 0 0 0 0 0
R000095 Edwin Reade Edwin Reade   American NC House 5 1855-12-03 1857-03-03 0 []     1812-11-13 M 2 1857-03-03 0 0 0 0 0 0 0
W000231 Edwin Webb Edwin Webb   Democrat NC House 9 1903-11-09 1921-03-03 0 []     1872-05-23 M 10 1921-03-03 0 0 0 0 0 0 0
P000498 Eliza Pratt Eliza Pratt   Democrat NC House 8 1945-01-03 1947-01-03 0 []     1902-03-05 F 2 1947-01-03 0 0 0 0 0 0 0
D000601 Elizabeth Dole Elizabeth Dole   Republican NC Senate   2003-01-07 2009-01-03 0 ["S2NC00083"] 01698 S292 1936-07-29 F 2 2009-01-03 0 246 74 1977 -6569 12327 0
C000494 Eva Clayton Eva Clayton   Democrat NC House 1 1992-11-03 2003-01-03 0 ["H2NC01065"] 00204   1934-09-16 F 6 2003-01-03 0 668 27 0 0 0 0
A000092 Evan Alexander Evan Alexander   Republican NC House 10 1806-02-24 1809-03-03 0 []       M 2 1809-03-03 0 0 0 0 0 0 0
W000050 Felix Walker Felix Walker   Republican NC House 12 1817-12-01 1823-03-03 0 []     1753-07-19 M 4 1823-03-03 0 0 0 0 0 0 0
C000862 Francis Craige Francis Craige   Democrat NC House 7 1853-12-05 1861-03-03 0 []     1811-03-13 M 5 1861-03-03 0 0 0 0 0 0 0

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE congress_members (
    bioguide_id TEXT PRIMARY KEY,
    first_name TEXT,
    last_name TEXT,
    full_name TEXT,
    nickname TEXT,
    party TEXT,
    state TEXT,
    chamber TEXT,
    district INTEGER,
    first_served TEXT,
    last_served TEXT,
    is_current INTEGER,
    fec_ids TEXT,
    thomas_id TEXT,
    lis_id TEXT,
    birthday TEXT,
    gender TEXT,
    terms_count INTEGER,
    served_until TEXT
, trade_count INTEGER DEFAULT 0, speech_count INTEGER DEFAULT 0, bills_sponsored INTEGER DEFAULT 0, vote_count INTEGER DEFAULT 0, fec_total_received INTEGER DEFAULT 0, fec_ie_for INTEGER DEFAULT 0, fec_ie_against INTEGER DEFAULT 0);
CREATE INDEX idx_cm_name ON congress_members(last_name, first_name);
CREATE INDEX idx_cm_party ON congress_members(party);
CREATE INDEX idx_cm_state ON congress_members(state);
CREATE INDEX idx_cm_chamber ON congress_members(chamber);
CREATE INDEX idx_cm_current ON congress_members(is_current);
CREATE INDEX idx_cm_current_trades ON congress_members(is_current DESC, trade_count DESC);
Powered by Datasette · Queries took 16.43ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API