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 cross-reference IDs for OpenSecrets, FEC, GovTrack, and more.

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

280 rows where chamber = "House", is_current = 0 and party = "Federalist" sorted by full_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: district, first_served, last_served, ballotpedia_id, terms_count, served_until, first_served (date), last_served (date), birthday (date), served_until (date)

state 16

party 1

  • Federalist · 280 ✖

is_current 1

chamber 1

  • House · 280 ✖
bioguide_id first_name last_name full_name ▼ nickname party state chamber district first_served last_served is_current opensecrets_id fec_ids govtrack_id thomas_id votesmart_id lis_id wikipedia_id ballotpedia_id birthday gender terms_count served_until trade_count speech_count bills_sponsored vote_count fec_total_received
F000297 Abiel Foster Abiel Foster   Federalist NH House -1 1789-03-04 1803-03-03 0   [] 404246       Abiel Foster   1735-08-08 M 8 1803-03-03 0 0 0 0 0
B000453 Abijah Bigelow Abijah Bigelow   Federalist MA House 11 1809-05-22 1815-03-03 0   [] 401438       Abijah Bigelow   1775-12-05 M 4 1815-03-03 0 0 0 0 0
N000161 Abraham Nott Abraham Nott   Federalist SC House 6 1799-12-02 1801-03-03 0   [] 408242       Abraham Nott   1768-02-05 M 2 1801-03-03 0 0 0 0 0
B000715 Alexander Boyd Alexander Boyd   Federalist NY House 13 1813-05-24 1815-03-03 0   [] 401676       Alexander Boyd   1764-09-14 M 2 1815-03-03 0 0 0 0 0
S000483 Amos Slaymaker Amos Slaymaker   Federalist PA House 3 1813-05-24 1815-03-03 0   [] 409971       Amos Slaymaker   1755-03-11 M 2 1815-03-03 0 0 0 0 0
H000475 Archibald Henderson Archibald Henderson   Federalist NC House 2 1799-12-02 1803-03-03 0   [] 405338       Archibald Henderson (politician)   1768-08-07 M 3 1803-03-03 0 0 0 0 0
M000302 Archibald McBryde Archibald McBryde   Federalist NC House 7 1809-05-22 1813-03-03 0   [] 407317       Archibald McBryde   1766-09-28 M 3 1813-03-03 0 0 0 0 0
W000128 Artemas Ward Artemas Ward   Federalist MA House 1 1813-05-24 1817-03-03 0   [] 411303       Artemas Ward Jr.   1762-01-09 M 3 1817-03-03 0 0 0 0 0
F000156 Asa Fitch Asa Fitch   Federalist NY House 6 1811-11-04 1813-03-03 0   [] 404111       Asa Fitch (politician)   1765-11-10 M 2 1813-03-03 0 0 0 0 0
L000539 Asa Lyon Asa Lyon   Federalist VT House 0 1815-12-04 1817-03-03 0   [] 407023       Asa Lyon   1763-12-31 M 2 1817-03-03 0 0 0 0 0
S000821 Asahel Stearns Asahel Stearns   Federalist MA House 4 1815-12-04 1817-03-03 0   [] 410286       Asahel Stearns   1774-06-17 M 2 1817-03-03 0 0 0 0 0
B000198 Bailey Bartlett Bailey Bartlett   Federalist MA House 11 1797-05-15 1801-03-03 0   [] 401197       Bailey Bartlett   1750-01-29 M 3 1801-03-03 0 0 0 0 0
G000049 Barent Gardenier Barent Gardenier   Federalist NY House 5 1807-10-26 1811-03-03 0   [] 412042       Barent Gardenier   1776-07-28 M 3 1811-03-03 0 0 0 0 0
A000030 Benjamin Adams Benjamin Adams   Federalist MA House 11 1815-12-04 1821-03-03 0   [] 400691       Benjamin Adams (politician)   1764-12-16 M 4 1821-03-03 0 0 0 0 0
B000669 Benjamin Bourne Benjamin Bourne   Federalist RI House -1 1789-03-04 1797-03-03 0   [] 401631       Benjamin Bourne   1755-09-09 M 5 1797-03-03 0 0 0 0 0
B000904 Benjamin Brown Benjamin Brown   Federalist MA House 16 1815-12-04 1817-03-03 0   [] 401861       Benjamin Brown (politician)   1756-09-23 M 2 1817-03-03 0 0 0 0 0
H000915 Benjamin Huger Benjamin Huger   Federalist SC House 3 1799-12-02 1817-03-03 0   [] 405760       Benjamin Huger (congressman)     M 10 1817-03-03 0 0 0 0 0
O000102 Benjamin Orr Benjamin Orr   Federalist MA House 16 1817-12-01 1819-03-03 0   [] 408359       Benjamin Orr (Massachusetts politician)   1772-12-01 M 2 1819-03-03 0 0 0 0 0
P000330 Benjamin Pickman Benjamin Pickman   Federalist MA House 2 1809-05-22 1811-03-03 0   [] 408727       Benjamin Pickman Jr.   1763-09-30 M 2 1811-03-03 0 0 0 0 0
T000029 Benjamin Tallmadge Benjamin Tallmadge   Federalist CT House -1 1801-12-07 1817-03-03 0   [] 410618       Benjamin Tallmadge   1754-02-25 M 9 1817-03-03 0 0 0 0 0
W000046 Benjamin Walker Benjamin Walker   Federalist NY House 9 1801-12-07 1803-03-03 0   [] 411226       Benjamin Walker (Continental Army officer)     M 2 1803-03-03 0 0 0 0 0
C000394 Bradbury Cilley Bradbury Cilley   Federalist NH House -1 1813-05-24 1817-03-03 0   [] 402533       Bradbury Cilley   1760-02-01 M 3 1817-03-03 0 0 0 0 0
C000604 Cadwallader Colden Cadwallader Colden   Federalist NY House 1 1821-12-03 1823-03-03 0   [] 402733       Cadwallader D. Colden   1769-04-04 M 2 1823-03-03 0 0 0 0 0
E000130 Caleb Ellis Caleb Ellis   Federalist NH House -1 1805-12-02 1807-03-03 0   [] 403821       Caleb Ellis   1767-04-16 M 2 1807-03-03 0 0 0 0 0
G000248 Calvin Goddard Calvin Goddard   Federalist CT House -1 1801-12-07 1807-03-03 0   [] 404610       Calvin Goddard (politician)   1768-07-17 M 4 1807-03-03 0 0 0 0 0
A000324 Charles Atherton Charles Atherton   Federalist NH House -1 1815-12-04 1817-03-03 0   [] 400972       Charles Humphrey Atherton   1773-08-14 M 2 1817-03-03 0 0 0 0 0
G000261 Charles Goldsborough Charles Goldsborough   Federalist MD House 8 1805-12-02 1817-03-03 0   [] 404623       Charles Goldsborough   1765-07-15 M 7 1817-03-03 0 0 0 0 0
M000146 Charles Marsh Charles Marsh   Federalist VT House 0 1815-12-04 1817-03-03 0   [] 407169       Charles Marsh (American politician)   1765-07-10 M 2 1817-03-03 0 0 0 0 0
R000501 Charles Ruggles Charles Ruggles   Federalist NY House 7 1821-12-03 1823-03-03 0   [] 409460       Charles H. Ruggles   1789-02-10 M 2 1823-03-03 0 0 0 0 0
L000066 Chauncey Langdon Chauncey Langdon   Federalist VT House 0 1815-12-04 1817-03-03 0   [] 406575       Chauncey Langdon   1763-11-08 M 2 1817-03-03 0 0 0 0 0
K000197 Cyrus King Cyrus King   Federalist MA House 14 1813-05-24 1817-03-03 0   [] 406358       Cyrus King   1772-09-06 M 3 1817-03-03 0 0 0 0 0
B000530 Daniel Blaisdell Daniel Blaisdell   Federalist NH House -1 1809-05-22 1811-03-03 0   [] 401505       Daniel Blaisdell   1762-01-22 M 2 1811-03-03 0 0 0 0 0
B001014 Daniel Buck Daniel Buck   Federalist VT House 2 1795-12-07 1797-03-03 0   [] 401964       Daniel Buck   1753-11-09 M 2 1797-03-03 0 0 0 0 0
C000014 Daniel Cady Daniel Cady   Federalist NY House 14 1815-12-04 1817-03-03 0   [] 402176       Daniel Cady   1773-04-29 M 2 1817-03-03 0 0 0 0 0
C000366 Daniel Chipman Daniel Chipman   Federalist VT House 0 1815-12-04 1817-03-03 0   [] 402505       Daniel Chipman   1765-10-22 M 2 1817-03-03 0 0 0 0 0
D000293 Daniel Dewey Daniel Dewey   Federalist MA House 12 1813-05-24 1815-03-03 0   [] 403418       Daniel Dewey   1766-01-29 M 2 1815-03-03 0 0 0 0 0
M000946 Daniel Morgan Daniel Morgan   Federalist VA House 1 1797-05-15 1799-03-03 0   [] 407914       Daniel Morgan     M 2 1799-03-03 0 0 0 0 0
S000317 Daniel Sheffey Daniel Sheffey   Federalist VA House 6 1809-05-22 1817-03-03 0   [] 409815       Daniel Sheffey     M 5 1817-03-03 0 0 0 0 0
B000875 David Brooks David Brooks   Federalist NY House 5 1797-05-15 1799-03-03 0   [] 401832       David Brooks (American politician)     M 2 1799-03-03 0 0 0 0 0
H000811 David Hough David Hough   Federalist NH House -1 1803-10-17 1807-03-03 0   [] 405659       David Hough (politician)   1753-03-13 M 3 1807-03-03 0 0 0 0 0
O000043 David Ogden David Ogden   Federalist NY House 18 1817-12-01 1819-03-03 0   [] 408326       David A. Ogden   1770-01-10 M 2 1819-03-03 0 0 0 0 0
H000996 Ebenezer Huntington Ebenezer Huntington   Federalist CT House -1 1809-05-22 1819-03-03 0   [] 405836       Ebenezer Huntington   1754-12-26 M 6 1819-03-03 0 0 0 0 0
M000259 Ebenezer Mattoon Ebenezer Mattoon   Federalist MA House 3 1799-12-02 1803-03-03 0   [] 407277       Ebenezer Mattoon   1755-08-19 M 3 1803-03-03 0 0 0 0 0
C000650 Edward Colston Edward Colston   Federalist VA House 2 1817-12-01 1819-03-03 0   [] 402778       Edward Colston (U.S. Representative)   1786-12-25 M 2 1819-03-03 0 0 0 0 0
L000363 Edward Livermore Edward Livermore   Federalist MA House 3 1807-10-26 1811-03-03 0   [] 406855       Edward St. Loe Livermore   1762-04-05 M 3 1811-03-03 0 0 0 0 0
B000388 Egbert Benson Egbert Benson   Federalist NY House 2 1789-03-04 1815-03-03 0   [] 401379       Egbert Benson   1746-06-21 M 14 1815-03-03 0 0 0 0 0
P000231 Elias Perkins Elias Perkins   Federalist CT House -1 1801-12-07 1803-03-03 0   [] 408634       Elias Perkins   1767-04-05 M 2 1803-03-03 0 0 0 0 0
B000833 Elijah Brigham Elijah Brigham   Federalist MA House 11 1811-11-04 1817-03-03 0   [] 401790       Elijah Brigham   1751-07-07 M 4 1817-03-03 0 0 0 0 0
P000463 Elisha Potter Elisha Potter   Federalist RI House -1 1795-12-07 1815-03-03 0   [] 408849       Elisha Reynolds Potter   1764-11-05 M 11 1815-03-03 0 0 0 0 0
W000644 Elisha Winter Elisha Winter   Federalist NY House 12 1813-05-24 1815-03-03 0   [] 411798       Elisha I. Winter   1781-07-15 M 2 1815-03-03 0 0 0 0 0
G000294 Elizur Goodrich Elizur Goodrich   Federalist CT House -1 1799-12-02 1801-03-03 0   [] 404653       Elizur Goodrich   1761-03-24 M 2 1801-03-03 0 0 0 0 0
C000288 Epaphroditus Champion Epaphroditus Champion   Federalist CT House -1 1807-10-26 1817-03-03 0   [] 402430       Epaphroditus Champion   1756-04-06 M 6 1817-03-03 0 0 0 0 0
G000173 Ezekiel Gilbert Ezekiel Gilbert   Federalist NY House 6 1793-12-02 1797-03-03 0   [] 404539       Ezekiel Gilbert   1756-03-25 M 3 1797-03-03 0 0 0 0 0
W000421 Ezekiel Whitman Ezekiel Whitman   Federalist ME House 2 1809-05-22 1823-03-03 0   [] 411580       Ezekiel Whitman   1776-03-09 M 8 1823-03-03 0 0 0 0 0
A000174 Fisher Ames Fisher Ames   Federalist MA House 8 1789-03-04 1797-03-03 0   [] 400829       Fisher Ames   1758-04-09 M 5 1797-03-03 0 0 0 0 0
W000367 Francis White Francis White   Federalist VA House 2 1813-05-24 1815-03-03 0   [] 412116       Francis White (Virginia politician)     M 2 1815-03-03 0 0 0 0 0
D000069 Franklin Davenport Franklin Davenport   Federalist NJ House 5 1798-12-05 1801-03-03 0   [] 403207       Franklin Davenport     M 2 1801-03-03 0 0 0 0 0
G000482 Gaylord Griswold Gaylord Griswold   Federalist NY House 15 1803-10-17 1805-03-03 0   [] 404827       Gaylord Griswold   1767-12-18 M 2 1805-03-03 0 0 0 0 0
B000026 George Baer George Baer   Federalist MD House 4 1797-05-15 1817-03-03 0   [] 401031       George Baer Jr.     M 11 1817-03-03 0 0 0 0 0
B000733 George Bradbury George Bradbury   Federalist MA House 15 1813-05-24 1817-03-03 0   [] 401693       George Bradbury (American politician)   1770-10-10 M 3 1817-03-03 0 0 0 0 0
D000254 George Dent George Dent   Federalist MD House 1 1793-12-02 1801-03-03 0   [] 403392       George Dent     M 5 1801-03-03 0 0 0 0 0
E000089 George Ege George Ege   Federalist PA House 5 1795-12-07 1799-03-03 0   [] 403782       George Ege   1748-03-09 M 3 1799-03-03 0 0 0 0 0
H000148 George Hancock George Hancock   Federalist VA House 5 1793-12-02 1797-03-03 0   [] 405030       George Hancock (Virginia politician)   1754-06-13 M 3 1797-03-03 0 0 0 0 0
L000246 George Leonard George Leonard   Federalist MA House 7 1789-03-04 1797-03-03 0   [] 406749       George Leonard (congressman)   1729-07-04 M 5 1797-03-03 0 0 0 0 0
S001052 George Sullivan George Sullivan   Federalist NH House -1 1811-11-04 1813-03-03 0   [] 410506       George Sullivan (New Hampshire politician)   1771-08-29 M 2 1813-03-03 0 0 0 0 0
T000141 George Thatcher George Thatcher   Federalist MA House 14 1789-03-04 1801-03-03 0   [] 410723       George Thatcher   1754-04-12 M 7 1801-03-03 0 0 0 0 0
T000262 George Tibbits George Tibbits   Federalist NY House 10 1803-10-17 1805-03-03 0   [] 410836       George Tibbits   1763-01-14 M 2 1805-03-03 0 0 0 0 0
U000022 George Upham George Upham   Federalist NH House -1 1801-12-07 1803-03-03 0   [] 411045       George B. Upham   1768-12-27 M 2 1803-03-03 0 0 0 0 0
B000555 Harmanus Bleecker Harmanus Bleecker   Federalist NY House 7 1811-11-04 1813-03-03 0   [] 401530       Harmanus Bleecker   1779-10-09 M 2 1813-03-03 0 0 0 0 0
G000235 Henry Glen Henry Glen   Federalist NY House 8 1793-12-02 1801-03-03 0   [] 404597       Henry Glen   1739-07-13 M 5 1801-03-03 0 0 0 0 0
L000195 Henry Lee Henry Lee   Federalist VA House 19 1799-12-02 1801-03-03 0   [] 406698       Henry Lee III   1756-01-29 M 2 1801-03-03 0 0 0 0 0
L000367 Henry Livingston Henry Livingston   Federalist NY House 8 1803-10-17 1807-03-03 0   [] 406859       Henry W. Livingston     M 3 1807-03-03 0 0 0 0 0
S000976 Henry Storrs Henry Storrs   Federalist NY House 14 1817-12-01 1831-03-03 0   [] 410435       Henry R. Storrs   1787-09-03 M 8 1831-03-03 0 0 0 0 0
W000722 Henry Woods Henry Woods   Federalist PA House 10 1799-12-02 1803-03-03 0   [] 411874       Henry Woods (Pennsylvania politician)     M 3 1803-03-03 0 0 0 0 0
K000282 Herman Knickerbocker Herman Knickerbocker   Federalist NY House 6 1809-05-22 1811-03-03 0   [] 406439       Herman Knickerbocker   1779-07-27 M 2 1811-03-03 0 0 0 0 0
H000803 Hezekiah Hosmer Hezekiah Hosmer   Federalist NY House 6 1797-05-15 1799-03-03 0   [] 405652       Hezekiah L. Hosmer   1765-06-07 M 2 1799-03-03 0 0 0 0 0
M000840 Hosea Moffitt Hosea Moffitt   Federalist NY House 10 1813-05-24 1817-03-03 0   [] 407814       Hosea Moffitt   1757-11-17 M 3 1817-03-03 0 0 0 0 0
C000131 Hugh Caperton Hugh Caperton   Federalist VA House 7 1813-05-24 1815-03-03 0   [] 402281       Hugh Caperton   1781-04-17 M 2 1815-03-03 0 0 0 0 0
W000551 Hugh Williamson Hugh Williamson   Federalist NC House 4 1789-03-04 1793-03-03 0   [] 411707       Hugh Williamson   1735-12-05 M 3 1793-03-03 0 0 0 0 0
D000057 Isaac Darlington Isaac Darlington   Federalist PA House 2 1817-12-01 1819-03-03 0   [] 403196       Isaac Darlington   1781-12-13 M 2 1819-03-03 0 0 0 0 0
P000058 Isaac Parker Isaac Parker   Federalist MA House 12 1797-05-15 1799-03-03 0   [] 408468       Isaac Parker (Massachusetts judge)   1768-06-17 M 2 1799-03-03 0 0 0 0 0
S000555 Isaac Smith Isaac Smith   Federalist NJ House -1 1795-12-07 1797-03-03 0   [] 410037       Isaac Smith (New Jersey politician)     M 2 1797-03-03 0 0 0 0 0
U000023 Jabez Upham Jabez Upham   Federalist MA House 10 1807-10-26 1811-03-03 0   [] 411046       Jabez Upham   1764-08-23 M 3 1811-03-03 0 0 0 0 0
H000914 Jacob Hufty Jacob Hufty   Federalist NJ House 3 1809-05-22 1814-05-20 0   [] 412053       Jacob Hufty     M 3 1814-05-20 0 0 0 0 0
M000132 Jacob Markell Jacob Markell   Federalist NY House 14 1813-05-24 1815-03-03 0   [] 407156       Jacob Markell   1770-05-08 M 2 1815-03-03 0 0 0 0 0
S001125 Jacob Swoope Jacob Swoope   Federalist VA House 4 1809-05-22 1811-03-03 0   [] 412109       Jacob Swoope     M 2 1811-03-03 0 0 0 0 0
B000785 James Breckinridge James Breckinridge   Federalist VA House 5 1809-05-22 1817-03-03 0   [] 401743       James Breckinridge   1763-03-07 M 5 1817-03-03 0 0 0 0 0
B000888 James Broom James Broom   Federalist DE House 0 1805-12-02 1809-03-03 0   [] 401845       James M. Broom     M 3 1809-03-03 0 0 0 0 0
C000176 James Carr James Carr   Federalist MA House 17 1815-12-04 1817-03-03 0   [] 402323       James Carr (Massachusetts politician)   1777-09-09 M 2 1817-03-03 0 0 0 0 0
C000563 James Cochran James Cochran   Federalist NY House 10 1797-05-15 1799-03-03 0   [] 402694       James Cochran (New York politician)   1769-02-11 M 2 1799-03-03 0 0 0 0 0
D000073 James Davenport James Davenport   Federalist CT House -1 1795-12-07 1799-03-03 0   [] 403211       James Davenport (Connecticut politician)   1758-10-12 M 3 1799-03-03 0 0 0 0 0
E000122 James Elliott James Elliott   Federalist VT House 2 1803-10-17 1809-03-03 0   [] 403813       James Elliot (politician)   1775-08-18 M 4 1809-03-03 0 0 0 0 0
E000176 James Emott James Emott   Federalist NY House 4 1809-05-22 1813-03-03 0   [] 403866       James Emott   1771-03-09 M 3 1813-03-03 0 0 0 0 0
G000116 James Geddes James Geddes   Federalist NY House 19 1813-05-24 1815-03-03 0   [] 404488       James Geddes (engineer)   1763-07-22 M 2 1815-03-03 0 0 0 0 0
I000011 James Imlay James Imlay   Federalist NJ House 4 1797-05-15 1801-03-03 0   [] 405873       James H. Imlay   1764-11-26 M 3 1801-03-03 0 0 0 0 0
J000227 James Jones James Jones   Federalist GA House -1 1799-12-02 1801-03-03 0   [] 412060       James Jones (Georgia politician)     M 2 1801-03-03 0 0 0 0 0
K000073 James Kelly James Kelly   Federalist PA House 6 1805-12-02 1809-03-03 0   [] 406243       James Kelly (U.S. representative)   1760-07-17 M 3 1809-03-03 0 0 0 0 0
M000013 James Machir James Machir   Federalist VA House 3 1797-05-15 1799-03-03 0   [] 412066       James Machir     M 2 1799-03-03 0 0 0 0 0
M000215 James Mason James Mason   Federalist RI House -1 1815-12-04 1819-03-03 0   [] 407233       James Brown Mason     M 3 1819-03-03 0 0 0 0 0
M000602 James McSherry James McSherry   Federalist PA House 5 1821-12-03 1823-03-03 0   [] 407591       James McSherry (Pennsylvania politician)   1776-07-29 M 2 1823-03-03 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,
    opensecrets_id TEXT,
    fec_ids TEXT,
    govtrack_id INTEGER,
    thomas_id TEXT,
    votesmart_id INTEGER,
    lis_id TEXT,
    wikipedia_id TEXT,
    ballotpedia_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);
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);