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 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

343 rows where 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, trade_count, first_served (date), last_served (date), birthday (date), served_until (date)

state 17

  • MA 64
  • NY 63
  • CT 32
  • NH 29
  • PA 28
  • VA 26
  • MD 22
  • VT 15
  • NC 14
  • NJ 14
  • RI 12
  • DE 9
  • SC 7
  • GA 3
  • KY 2
  • ME 2
  • OH 1

chamber 2

  • House 280
  • Senate 63

party 1

  • Federalist · 343 ✖

is_current 1

  • 0 343
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
O000041 Aaron Ogden Aaron Ogden   Federalist NJ Senate   1801-12-07 1803-03-03 0   [] 408324       Aaron Ogden   1756-12-03 M 1 1803-03-03 0 0 0 0 0
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
H000176 Alexander Hanson Alexander Hanson   Federalist MD Senate   1813-05-24 1819-04-23 0   [] 405057       Alexander C. Hanson   1786-02-27 M 2 1819-04-23 16 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
G000286 Benjamin Goodhue Benjamin Goodhue   Federalist MA Senate   1789-03-04 1800-11-08 0   [] 404647       Benjamin Goodhue   1748-09-20 M 2 1800-11-08 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
S001009 Caleb Strong Caleb Strong   Federalist MA Senate   1789-03-04 1797-03-03 0   [] 410466       Caleb Strong   1745-01-09 M 2 1797-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
G000293 Chauncey Goodrich Chauncey Goodrich   Federalist CT Senate   1795-12-07 1813-03-03 0   [] 404652       Chauncey Goodrich   1759-10-20 M 4 1813-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
C000289 Christopher Champlin Christopher Champlin   Federalist RI Senate   1797-05-15 1811-12-31 0   [] 402431       Christopher G. Champlin   1768-04-12 M 3 1811-12-31 0 0 0 0 0
G000322 Christopher Gore Christopher Gore   Federalist MA Senate   1813-05-24 1817-03-03 0   [] 404680       Christopher Gore   1758-09-21 M 1 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 1 0 0 0 0
D000002 David Daggett David Daggett   Federalist CT Senate   1813-05-24 1819-03-03 0   [] 403146       David Daggett   1764-12-31 M 2 1819-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
F000301 Dwight Foster Dwight Foster   Federalist MA Senate   1793-12-02 1803-12-31 0   [] 404250       Dwight Foster (politician, born 1757)   1757-12-07 M 2 1803-12-31 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
A000317 Eli Ashmun Eli Ashmun   Federalist MA Senate   1816-01-01 1819-03-03 0   [] 400963       Eli P. Ashmun   1770-06-24 M 1 1819-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
P000026 Elijah Paine Elijah Paine   Federalist VT Senate   1795-12-07 1801-03-03 0   [] 408437       Elijah Paine   1757-01-21 M 2 1801-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
M000076 Francis Malbone Francis Malbone   Federalist RI Senate   1793-12-02 1809-12-31 0   [] 407104       Francis Malbone   1759-03-20 M 3 1809-12-31 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
F000368 Frederick Frelinghuysen Frederick Frelinghuysen   Federalist NJ Senate   1793-12-02 1797-03-03 0   [] 404314       Frederick Frelinghuysen (general)   1753-04-13 M 1 1797-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
C000009 George Cabot George Cabot   Federalist MA Senate   1791-10-24 1797-03-03 0   [] 402171       George Cabot   1752-12-03 M 2 1797-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
W000114 George Walton George Walton   Federalist GA Senate   1795-11-16 1796-02-20 0   [] 412123       George Walton     M 1 1796-02-20 0 0 0 0 0
M000976 Gouverneur Morris Gouverneur Morris   Federalist NY Senate   1800-01-01 1803-03-03 0   [] 407944       Gouverneur Morris   1752-01-31 M 1 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
O000127 Harrison Otis Harrison Otis   Federalist MA Senate   1797-05-15 1823-03-03 0   [] 408380       Harrison Gray Otis (politician)   1765-10-08 M 5 1823-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
L000115 Henry Latimer Henry Latimer   Federalist DE Senate   1793-12-02 1801-12-31 0   [] 406621       Henry Latimer (politician)   1752-04-24 M 2 1801-12-31 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
M000155 Humphrey Marshall Humphrey Marshall   Federalist KY Senate   1795-12-07 1801-03-03 0   [] 407176       Humphrey Marshall (politician)     M 2 1801-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

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);
Powered by Datasette · Queries took 8009.179ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API