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

343 rows where party = "Federalist" sorted by full_name

✎ View and edit SQL

This data as json, CSV (advanced)

state 17

chamber 2

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 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
O000041 Aaron Ogden Aaron Ogden   Federalist NJ Senate   1801-12-07 1803-03-03 0 []     1756-12-03 M 1 1803-03-03 0 0 0 0 0 0 0
F000297 Abiel Foster Abiel Foster   Federalist NH House -1 1789-03-04 1803-03-03 0 []     1735-08-08 M 8 1803-03-03 0 0 0 0 0 0 0
B000453 Abijah Bigelow Abijah Bigelow   Federalist MA House 11 1809-05-22 1815-03-03 0 []     1775-12-05 M 4 1815-03-03 0 0 0 0 0 0 0
N000161 Abraham Nott Abraham Nott   Federalist SC House 6 1799-12-02 1801-03-03 0 []     1768-02-05 M 2 1801-03-03 0 0 0 0 0 0 0
B000715 Alexander Boyd Alexander Boyd   Federalist NY House 13 1813-05-24 1815-03-03 0 []     1764-09-14 M 2 1815-03-03 0 0 0 0 0 0 0
H000176 Alexander Hanson Alexander Hanson   Federalist MD Senate   1813-05-24 1819-04-23 0 []     1786-02-27 M 2 1819-04-23 0 0 0 0 0 0 0
S000483 Amos Slaymaker Amos Slaymaker   Federalist PA House 3 1813-05-24 1815-03-03 0 []     1755-03-11 M 2 1815-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
W000128 Artemas Ward Artemas Ward   Federalist MA House 1 1813-05-24 1817-03-03 0 []     1762-01-09 M 3 1817-03-03 0 0 0 0 0 0 0
F000156 Asa Fitch Asa Fitch   Federalist NY House 6 1811-11-04 1813-03-03 0 []     1765-11-10 M 2 1813-03-03 0 0 0 0 0 0 0
L000539 Asa Lyon Asa Lyon   Federalist VT House 0 1815-12-04 1817-03-03 0 []     1763-12-31 M 2 1817-03-03 0 0 0 0 0 0 0
S000821 Asahel Stearns Asahel Stearns   Federalist MA House 4 1815-12-04 1817-03-03 0 []     1774-06-17 M 2 1817-03-03 0 0 0 0 0 0 0
B000198 Bailey Bartlett Bailey Bartlett   Federalist MA House 11 1797-05-15 1801-03-03 0 []     1750-01-29 M 3 1801-03-03 0 0 0 0 0 0 0
G000049 Barent Gardenier Barent Gardenier   Federalist NY House 5 1807-10-26 1811-03-03 0 []     1776-07-28 M 3 1811-03-03 0 0 0 0 0 0 0
A000030 Benjamin Adams Benjamin Adams   Federalist MA House 11 1815-12-04 1821-03-03 0 []     1764-12-16 M 4 1821-03-03 0 0 0 0 0 0 0
B000669 Benjamin Bourne Benjamin Bourne   Federalist RI House -1 1789-03-04 1797-03-03 0 []     1755-09-09 M 5 1797-03-03 0 0 0 0 0 0 0
B000904 Benjamin Brown Benjamin Brown   Federalist MA House 16 1815-12-04 1817-03-03 0 []     1756-09-23 M 2 1817-03-03 0 0 0 0 0 0 0
G000286 Benjamin Goodhue Benjamin Goodhue   Federalist MA Senate   1789-03-04 1800-11-08 0 []     1748-09-20 M 2 1800-11-08 0 0 0 0 0 0 0
H000915 Benjamin Huger Benjamin Huger   Federalist SC House 3 1799-12-02 1817-03-03 0 []       M 10 1817-03-03 0 0 0 0 0 0 0
O000102 Benjamin Orr Benjamin Orr   Federalist MA House 16 1817-12-01 1819-03-03 0 []     1772-12-01 M 2 1819-03-03 0 0 0 0 0 0 0
P000330 Benjamin Pickman Benjamin Pickman   Federalist MA House 2 1809-05-22 1811-03-03 0 []     1763-09-30 M 2 1811-03-03 0 0 0 0 0 0 0
T000029 Benjamin Tallmadge Benjamin Tallmadge   Federalist CT House -1 1801-12-07 1817-03-03 0 []     1754-02-25 M 9 1817-03-03 0 0 0 0 0 0 0
W000046 Benjamin Walker Benjamin Walker   Federalist NY House 9 1801-12-07 1803-03-03 0 []       M 2 1803-03-03 0 0 0 0 0 0 0
C000394 Bradbury Cilley Bradbury Cilley   Federalist NH House -1 1813-05-24 1817-03-03 0 []     1760-02-01 M 3 1817-03-03 0 0 0 0 0 0 0
C000604 Cadwallader Colden Cadwallader Colden   Federalist NY House 1 1821-12-03 1823-03-03 0 []     1769-04-04 M 2 1823-03-03 0 0 0 0 0 0 0
E000130 Caleb Ellis Caleb Ellis   Federalist NH House -1 1805-12-02 1807-03-03 0 []     1767-04-16 M 2 1807-03-03 0 0 0 0 0 0 0
S001009 Caleb Strong Caleb Strong   Federalist MA Senate   1789-03-04 1797-03-03 0 []     1745-01-09 M 2 1797-03-03 0 0 0 0 0 0 0
G000248 Calvin Goddard Calvin Goddard   Federalist CT House -1 1801-12-07 1807-03-03 0 []     1768-07-17 M 4 1807-03-03 0 0 0 0 0 0 0
A000324 Charles Atherton Charles Atherton   Federalist NH House -1 1815-12-04 1817-03-03 0 []     1773-08-14 M 2 1817-03-03 0 0 0 0 0 0 0
G000261 Charles Goldsborough Charles Goldsborough   Federalist MD House 8 1805-12-02 1817-03-03 0 []     1765-07-15 M 7 1817-03-03 0 0 0 0 0 0 0
M000146 Charles Marsh Charles Marsh   Federalist VT House 0 1815-12-04 1817-03-03 0 []     1765-07-10 M 2 1817-03-03 0 0 0 0 0 0 0
R000501 Charles Ruggles Charles Ruggles   Federalist NY House 7 1821-12-03 1823-03-03 0 []     1789-02-10 M 2 1823-03-03 0 0 0 0 0 0 0
G000293 Chauncey Goodrich Chauncey Goodrich   Federalist CT Senate   1795-12-07 1813-03-03 0 []     1759-10-20 M 4 1813-03-03 0 0 0 0 0 0 0
L000066 Chauncey Langdon Chauncey Langdon   Federalist VT House 0 1815-12-04 1817-03-03 0 []     1763-11-08 M 2 1817-03-03 0 0 0 0 0 0 0
C000289 Christopher Champlin Christopher Champlin   Federalist RI Senate   1797-05-15 1811-12-31 0 []     1768-04-12 M 3 1811-12-31 0 0 0 0 0 0 0
G000322 Christopher Gore Christopher Gore   Federalist MA Senate   1813-05-24 1817-03-03 0 []     1758-09-21 M 1 1817-03-03 0 0 0 0 0 0 0
K000197 Cyrus King Cyrus King   Federalist MA House 14 1813-05-24 1817-03-03 0 []     1772-09-06 M 3 1817-03-03 0 0 0 0 0 0 0
B000530 Daniel Blaisdell Daniel Blaisdell   Federalist NH House -1 1809-05-22 1811-03-03 0 []     1762-01-22 M 2 1811-03-03 0 0 0 0 0 0 0
B001014 Daniel Buck Daniel Buck   Federalist VT House 2 1795-12-07 1797-03-03 0 []     1753-11-09 M 2 1797-03-03 0 0 0 0 0 0 0
C000014 Daniel Cady Daniel Cady   Federalist NY House 14 1815-12-04 1817-03-03 0 []     1773-04-29 M 2 1817-03-03 0 0 0 0 0 0 0
C000366 Daniel Chipman Daniel Chipman   Federalist VT House 0 1815-12-04 1817-03-03 0 []     1765-10-22 M 2 1817-03-03 0 0 0 0 0 0 0
D000293 Daniel Dewey Daniel Dewey   Federalist MA House 12 1813-05-24 1815-03-03 0 []     1766-01-29 M 2 1815-03-03 0 0 0 0 0 0 0
M000946 Daniel Morgan Daniel Morgan   Federalist VA House 1 1797-05-15 1799-03-03 0 []       M 2 1799-03-03 0 0 0 0 0 0 0
S000317 Daniel Sheffey Daniel Sheffey   Federalist VA House 6 1809-05-22 1817-03-03 0 []       M 5 1817-03-03 0 0 0 0 0 0 0
B000875 David Brooks David Brooks   Federalist NY House 5 1797-05-15 1799-03-03 0 []       M 2 1799-03-03 0 0 0 0 0 0 0
D000002 David Daggett David Daggett   Federalist CT Senate   1813-05-24 1819-03-03 0 []     1764-12-31 M 2 1819-03-03 0 0 0 0 0 0 0
H000811 David Hough David Hough   Federalist NH House -1 1803-10-17 1807-03-03 0 []     1753-03-13 M 3 1807-03-03 0 0 0 0 0 0 0
O000043 David Ogden David Ogden   Federalist NY House 18 1817-12-01 1819-03-03 0 []     1770-01-10 M 2 1819-03-03 0 0 0 0 0 0 0
F000301 Dwight Foster Dwight Foster   Federalist MA Senate   1793-12-02 1803-12-31 0 []     1757-12-07 M 2 1803-12-31 0 0 0 0 0 0 0
H000996 Ebenezer Huntington Ebenezer Huntington   Federalist CT House -1 1809-05-22 1819-03-03 0 []     1754-12-26 M 6 1819-03-03 0 0 0 0 0 0 0
M000259 Ebenezer Mattoon Ebenezer Mattoon   Federalist MA House 3 1799-12-02 1803-03-03 0 []     1755-08-19 M 3 1803-03-03 0 0 0 0 0 0 0
C000650 Edward Colston Edward Colston   Federalist VA House 2 1817-12-01 1819-03-03 0 []     1786-12-25 M 2 1819-03-03 0 0 0 0 0 0 0
L000363 Edward Livermore Edward Livermore   Federalist MA House 3 1807-10-26 1811-03-03 0 []     1762-04-05 M 3 1811-03-03 0 0 0 0 0 0 0
B000388 Egbert Benson Egbert Benson   Federalist NY House 2 1789-03-04 1815-03-03 0 []     1746-06-21 M 14 1815-03-03 0 0 0 0 0 0 0
A000317 Eli Ashmun Eli Ashmun   Federalist MA Senate   1816-01-01 1819-03-03 0 []     1770-06-24 M 1 1819-03-03 0 0 0 0 0 0 0
P000231 Elias Perkins Elias Perkins   Federalist CT House -1 1801-12-07 1803-03-03 0 []     1767-04-05 M 2 1803-03-03 0 0 0 0 0 0 0
B000833 Elijah Brigham Elijah Brigham   Federalist MA House 11 1811-11-04 1817-03-03 0 []     1751-07-07 M 4 1817-03-03 0 0 0 0 0 0 0
P000026 Elijah Paine Elijah Paine   Federalist VT Senate   1795-12-07 1801-03-03 0 []     1757-01-21 M 2 1801-03-03 0 0 0 0 0 0 0
P000463 Elisha Potter Elisha Potter   Federalist RI House -1 1795-12-07 1815-03-03 0 []     1764-11-05 M 11 1815-03-03 0 0 0 0 0 0 0
W000644 Elisha Winter Elisha Winter   Federalist NY House 12 1813-05-24 1815-03-03 0 []     1781-07-15 M 2 1815-03-03 0 0 0 0 0 0 0
G000294 Elizur Goodrich Elizur Goodrich   Federalist CT House -1 1799-12-02 1801-03-03 0 []     1761-03-24 M 2 1801-03-03 0 0 0 0 0 0 0
C000288 Epaphroditus Champion Epaphroditus Champion   Federalist CT House -1 1807-10-26 1817-03-03 0 []     1756-04-06 M 6 1817-03-03 0 0 0 0 0 0 0
G000173 Ezekiel Gilbert Ezekiel Gilbert   Federalist NY House 6 1793-12-02 1797-03-03 0 []     1756-03-25 M 3 1797-03-03 0 0 0 0 0 0 0
W000421 Ezekiel Whitman Ezekiel Whitman   Federalist ME House 2 1809-05-22 1823-03-03 0 []     1776-03-09 M 8 1823-03-03 0 0 0 0 0 0 0
A000174 Fisher Ames Fisher Ames   Federalist MA House 8 1789-03-04 1797-03-03 0 []     1758-04-09 M 5 1797-03-03 0 0 0 0 0 0 0
M000076 Francis Malbone Francis Malbone   Federalist RI Senate   1793-12-02 1809-12-31 0 []     1759-03-20 M 3 1809-12-31 0 0 0 0 0 0 0
W000367 Francis White Francis White   Federalist VA House 2 1813-05-24 1815-03-03 0 []       M 2 1815-03-03 0 0 0 0 0 0 0
D000069 Franklin Davenport Franklin Davenport   Federalist NJ House 5 1798-12-05 1801-03-03 0 []       M 2 1801-03-03 0 0 0 0 0 0 0
F000368 Frederick Frelinghuysen Frederick Frelinghuysen   Federalist NJ Senate   1793-12-02 1797-03-03 0 []     1753-04-13 M 1 1797-03-03 0 0 0 0 0 0 0
G000482 Gaylord Griswold Gaylord Griswold   Federalist NY House 15 1803-10-17 1805-03-03 0 []     1767-12-18 M 2 1805-03-03 0 0 0 0 0 0 0
B000026 George Baer George Baer   Federalist MD House 4 1797-05-15 1817-03-03 0 []       M 11 1817-03-03 0 0 0 0 0 0 0
B000733 George Bradbury George Bradbury   Federalist MA House 15 1813-05-24 1817-03-03 0 []     1770-10-10 M 3 1817-03-03 0 0 0 0 0 0 0
C000009 George Cabot George Cabot   Federalist MA Senate   1791-10-24 1797-03-03 0 []     1752-12-03 M 2 1797-03-03 0 0 0 0 0 0 0
D000254 George Dent George Dent   Federalist MD House 1 1793-12-02 1801-03-03 0 []       M 5 1801-03-03 0 0 0 0 0 0 0
E000089 George Ege George Ege   Federalist PA House 5 1795-12-07 1799-03-03 0 []     1748-03-09 M 3 1799-03-03 0 0 0 0 0 0 0
H000148 George Hancock George Hancock   Federalist VA House 5 1793-12-02 1797-03-03 0 []     1754-06-13 M 3 1797-03-03 0 0 0 0 0 0 0
L000246 George Leonard George Leonard   Federalist MA House 7 1789-03-04 1797-03-03 0 []     1729-07-04 M 5 1797-03-03 0 0 0 0 0 0 0
S001052 George Sullivan George Sullivan   Federalist NH House -1 1811-11-04 1813-03-03 0 []     1771-08-29 M 2 1813-03-03 0 0 0 0 0 0 0
T000141 George Thatcher George Thatcher   Federalist MA House 14 1789-03-04 1801-03-03 0 []     1754-04-12 M 7 1801-03-03 0 0 0 0 0 0 0
T000262 George Tibbits George Tibbits   Federalist NY House 10 1803-10-17 1805-03-03 0 []     1763-01-14 M 2 1805-03-03 0 0 0 0 0 0 0
U000022 George Upham George Upham   Federalist NH House -1 1801-12-07 1803-03-03 0 []     1768-12-27 M 2 1803-03-03 0 0 0 0 0 0 0
W000114 George Walton George Walton   Federalist GA Senate   1795-11-16 1796-02-20 0 []       M 1 1796-02-20 0 0 0 0 0 0 0
M000976 Gouverneur Morris Gouverneur Morris   Federalist NY Senate   1800-01-01 1803-03-03 0 []     1752-01-31 M 1 1803-03-03 0 0 0 0 0 0 0
B000555 Harmanus Bleecker Harmanus Bleecker   Federalist NY House 7 1811-11-04 1813-03-03 0 []     1779-10-09 M 2 1813-03-03 0 0 0 0 0 0 0
O000127 Harrison Otis Harrison Otis   Federalist MA Senate   1797-05-15 1823-03-03 0 []     1765-10-08 M 5 1823-03-03 0 0 0 0 0 0 0
G000235 Henry Glen Henry Glen   Federalist NY House 8 1793-12-02 1801-03-03 0 []     1739-07-13 M 5 1801-03-03 0 0 0 0 0 0 0
L000115 Henry Latimer Henry Latimer   Federalist DE Senate   1793-12-02 1801-12-31 0 []     1752-04-24 M 2 1801-12-31 0 0 0 0 0 0 0
L000195 Henry Lee Henry Lee   Federalist VA House 19 1799-12-02 1801-03-03 0 []     1756-01-29 M 2 1801-03-03 0 0 0 0 0 0 0
L000367 Henry Livingston Henry Livingston   Federalist NY House 8 1803-10-17 1807-03-03 0 []       M 3 1807-03-03 0 0 0 0 0 0 0
S000976 Henry Storrs Henry Storrs   Federalist NY House 14 1817-12-01 1831-03-03 0 []     1787-09-03 M 8 1831-03-03 0 0 0 0 0 0 0
W000722 Henry Woods Henry Woods   Federalist PA House 10 1799-12-02 1803-03-03 0 []       M 3 1803-03-03 0 0 0 0 0 0 0
K000282 Herman Knickerbocker Herman Knickerbocker   Federalist NY House 6 1809-05-22 1811-03-03 0 []     1779-07-27 M 2 1811-03-03 0 0 0 0 0 0 0
H000803 Hezekiah Hosmer Hezekiah Hosmer   Federalist NY House 6 1797-05-15 1799-03-03 0 []     1765-06-07 M 2 1799-03-03 0 0 0 0 0 0 0
M000840 Hosea Moffitt Hosea Moffitt   Federalist NY House 10 1813-05-24 1817-03-03 0 []     1757-11-17 M 3 1817-03-03 0 0 0 0 0 0 0
C000131 Hugh Caperton Hugh Caperton   Federalist VA House 7 1813-05-24 1815-03-03 0 []     1781-04-17 M 2 1815-03-03 0 0 0 0 0 0 0
W000551 Hugh Williamson Hugh Williamson   Federalist NC House 4 1789-03-04 1793-03-03 0 []     1735-12-05 M 3 1793-03-03 0 0 0 0 0 0 0
M000155 Humphrey Marshall Humphrey Marshall   Federalist KY Senate   1795-12-07 1801-03-03 0 []       M 2 1801-03-03 0 0 0 0 0 0 0
D000057 Isaac Darlington Isaac Darlington   Federalist PA House 2 1817-12-01 1819-03-03 0 []     1781-12-13 M 2 1819-03-03 0 0 0 0 0 0 0
P000058 Isaac Parker Isaac Parker   Federalist MA House 12 1797-05-15 1799-03-03 0 []     1768-06-17 M 2 1799-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);