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

564 rows where party = "Whig" sorted by full_name

✎ View and edit SQL

This data as json, CSV (advanced)

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

state 30

chamber 2

party 1

  • Whig · 564 ✖

is_current 1

  • 0 564
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
F000296 A. Foster A. Foster   Whig NY House 23 1841-05-31 1843-03-03 0   [] 412038       A. Lawrence Foster   1802-09-17 M 2 1843-03-03 0 0 0 0 0
L000130 Abbott Lawrence Abbott Lawrence   Whig MA House 1 1835-12-07 1841-03-03 0   [] 406635       Abbott Lawrence   1792-12-16 M 4 1841-03-03 0 0 0 0 0
H000416 Abner Hazeltine Abner Hazeltine   Whig NY House 31 1833-12-02 1837-03-03 0   [] 405282       Abner Hazeltine   1793-06-10 M 3 1837-03-03 0 0 0 0 0
L000270 Abner Lewis Abner Lewis   Whig NY House 31 1845-12-01 1847-03-03 0   [] 412063       Abner Lewis   1801-08-17 M 2 1847-03-03 0 0 0 0 0
L000313 Abraham Lincoln Abraham Lincoln   Whig IL House 7 1847-12-06 1849-03-03 0   [] 406807       Abraham Lincoln Abraham Lincoln 1809-02-12 M 2 1849-03-03 0 0 0 0 0
M000474 Abraham McIlvaine Abraham McIlvaine   Whig PA House 7 1843-12-04 1849-03-03 0   [] 407472       Abraham Robinson McIlvaine   1804-08-14 M 4 1849-03-03 0 0 0 0 0
R000162 Abraham Rencher Abraham Rencher   Whig NC House 10 1829-12-07 1843-03-03 0   [] 409139       Abraham Rencher   1798-08-12 M 8 1843-03-03 0 0 0 0 0
S000122 Abraham Schermerhorn Abraham Schermerhorn   Whig NY House 28 1849-12-03 1853-03-03 0   [] 409630       Abraham M. Schermerhorn   1791-12-11 M 3 1853-03-03 0 0 0 0 0
M000262 Abram Maury Abram Maury   Whig TN House 8 1835-12-07 1839-03-03 0   [] 407280       Abram Poindexter Maury   1801-12-26 M 3 1839-03-03 0 0 0 0 0
C000319 Absalom Chappell Absalom Chappell   Whig GA House -1 1843-12-04 1845-03-03 0   [] 402461       Absalom H. Chappell   1801-12-18 M 2 1845-03-03 0 0 0 0 0
W000350 Addison White Addison White   Whig KY House 6 1851-12-01 1853-03-03 0   [] 411512       Addison White   1824-05-01 M 2 1853-03-03 0 0 0 0 0
M000790 Ahiman Miner Ahiman Miner   Whig VT House 1 1851-12-01 1853-03-03 0   [] 407768       Ahiman Louis Miner   1804-09-23 M 2 1853-03-03 0 0 0 0 0
G000424 Albert Greene Albert Greene   Whig RI Senate   1845-12-01 1851-03-03 0   [] 404771       Albert C. Greene   1792-04-15 M 2 1851-03-03 0 0 0 0 0
S000512 Albert Smith Albert Smith   Whig NY House 33 1843-12-04 1847-03-03 0   [] 409998       Albert Smith (New York politician)   1805-06-22 M 3 1847-03-03 0 0 0 0 0
T000343 Albert Tracy Albert Tracy   Whig NY House 30 1819-12-06 1825-03-03 0   [] 410914       Albert H. Tracy   1793-06-17 M 4 1825-03-03 0 0 0 0 0
B000183 Alexander Barrow Alexander Barrow   Whig LA Senate   1841-05-31 1847-03-03 0   [] 401182       Alexander Barrow   1801-03-27 M 2 1847-03-03 0 0 0 0 0
E000231 Alexander Evans Alexander Evans   Whig MD House 5 1847-12-06 1853-03-03 0   [] 403916       Alexander Evans (American politician)   1818-09-13 M 4 1853-03-03 0 0 0 0 0
H000219 Alexander Harper Alexander Harper   Whig OH House 14 1837-09-04 1853-03-03 0   [] 405097       Alexander Harper (Ohio politician)   1786-02-05 M 9 1853-03-03 0 0 0 0 0
I000032 Alexander Irvin Alexander Irvin   Whig PA House 24 1847-12-06 1849-03-03 0   [] 405890       Alexander Irvin   1800-01-18 M 2 1849-03-03 0 0 0 0 0
R000034 Alexander Randall Alexander Randall   Whig MD House 4 1841-05-31 1843-03-03 0   [] 409015       Alexander Randall (Maryland politician)   1803-01-03 M 2 1843-03-03 0 0 0 0 0
S001030 Alexander Stuart Alexander Stuart   Whig VA House 17 1841-05-31 1843-03-03 0   [] 410486       Alexander Hugh Holmes Stuart   1807-04-02 M 2 1843-03-03 0 0 0 0 0
B000003 Alfred Babcock Alfred Babcock   Whig NY House 33 1841-05-31 1843-03-03 0   [] 401009       Alfred Babcock   1805-04-15 M 2 1843-03-03 0 0 0 0 0
D000385 Alfred Dockery Alfred Dockery   Whig NC House 3 1845-12-01 1853-03-03 0   [] 403501       Alfred Dockery   1797-12-11 M 5 1853-03-03 0 0 0 0 0
O000148 Allen Owen Allen Owen   Whig GA House 3 1849-12-03 1851-03-03 0   [] 408399       Allen F. Owen   1816-10-09 M 2 1851-03-03 0 0 0 0 0
A000004 Amos Abbott Amos Abbott   Whig MA House 3 1843-12-04 1849-03-03 0   [] 400666       Amos Abbott   1786-09-10 M 4 1849-03-03 0 0 0 0 0
T000394 Amos Tuck Amos Tuck   Whig NH House 1 1847-12-06 1853-03-03 0   [] 410963       Amos Tuck   1810-08-02 M 4 1853-03-03 0 0 0 0 0
M000804 Anderson Mitchell Anderson Mitchell   Whig NC House 13 1841-05-31 1843-03-03 0   [] 407780       Anderson Mitchell   1800-06-13 M 2 1843-03-03 0 0 0 0 0
F000419 Andrew Fulton Andrew Fulton   Whig VA House 13 1847-12-06 1849-03-03 0   [] 404361       Andrew S. Fulton   1800-09-29 M 2 1849-03-03 0 0 0 0 0
H000381 Andrew Hay Andrew Hay   Whig NJ House 1 1849-12-03 1851-03-03 0   [] 405249       Andrew K. Hay   1809-01-19 M 2 1851-03-03 0 0 0 0 0
L000436 Andrew Loomis Andrew Loomis   Whig OH House 17 1837-09-04 1839-03-03 0   [] 406927       Andrew W. Loomis   1797-06-27 M 2 1839-03-03 0 0 0 0 0
O000046 Andrew Ogle Andrew Ogle   Whig PA House 18 1849-12-03 1851-03-03 0   [] 408329       Andrew J. Ogle   1822-03-25 M 2 1851-03-03 0 0 0 0 0
S000899 Andrew Stewart Andrew Stewart   Whig PA House 18 1821-12-03 1849-03-03 0   [] 410360       Andrew Stewart (American politician, died 1872)   1791-06-11 M 15 1849-03-03 0 0 0 0 0
T000344 Andrew Tracy Andrew Tracy   Whig VT House 2 1853-12-05 1855-03-03 0   [] 410915       Andrew Tracy   1797-12-15 M 2 1855-03-03 0 0 0 0 0
T000388 Andrew Trumbo Andrew Trumbo   Whig KY House 9 1845-12-01 1847-03-03 0   [] 410957       Andrew Trumbo   1797-09-15 M 2 1847-03-03 0 0 0 0 0
B000901 Anson Brown Anson Brown   Whig NY House 11 1839-12-02 1841-03-03 0   [] 401858       Anson Brown     M 2 1841-03-03 0 0 0 0 0
D000367 Archibald Dixon Archibald Dixon   Whig KY Senate   1852-01-01 1855-03-03 0   [] 403484       Archibald Dixon   1802-04-02 M 1 1855-03-03 0 0 0 0 0
L000335 Archibald Linn Archibald Linn   Whig NY House 11 1841-05-31 1843-03-03 0   [] 406828       Archibald L. Linn   1802-10-15 M 2 1843-03-03 0 0 0 0 0
H000028 Artemas Hale Artemas Hale   Whig MA House 9 1845-12-01 1849-03-03 0   [] 404913       Artemas Hale   1783-10-20 M 3 1849-03-03 0 0 0 0 0
R000297 Asher Robbins Asher Robbins   Whig RI Senate   1825-12-05 1839-03-03 0   [] 409269       Asher Robbins   1761-10-26 M 3 1839-03-03 0 0 0 0 0
T000447 Asher Tyler Asher Tyler   Whig NY House 31 1843-12-04 1845-03-03 0   [] 411015       Asher Tyler   1798-05-10 M 2 1845-03-03 0 0 0 0 0
S000338 Augustine Shepperd Augustine Shepperd   Whig NC House 4 1827-12-03 1851-03-03 0   [] 409835       Augustine Henry Shepperd   1792-02-24 M 13 1851-03-03 0 0 0 0 0
H000315 Augustus Hascall Augustus Hascall   Whig NY House 33 1851-12-01 1853-03-03 0   [] 405188       Augustus P. Hascall   1800-06-24 M 2 1853-03-03 0 0 0 0 0
P000437 Augustus Porter Augustus Porter   Whig MI Senate   1840-01-01 1845-03-03 0   [] 408828       Augustus Seymour Porter   1798-01-18 M 1 1845-03-03 0 0 0 0 0
S000674 Augustus Sollers Augustus Sollers   Whig MD House 6 1841-05-31 1855-03-03 0   [] 410146       Augustus Rhodes Sollers   1814-05-01 M 8 1855-03-03 0 0 0 0 0
Y000029 Augustus Young Augustus Young   Whig VT House 4 1841-05-31 1843-03-03 0   [] 411963       Augustus Young (representative)   1784-03-20 M 2 1843-03-03 0 0 0 0 0
B001032 Aylette Buckner Aylette Buckner   Whig KY House 4 1847-12-06 1849-03-03 0   [] 401982       Aylette Buckner   1806-07-21 M 2 1849-03-03 0 0 0 0 0
B000624 Azariah Boody Azariah Boody   Whig NY House 29 1853-12-05 1855-03-03 0   [] 401589       Azariah Boody   1815-04-21 M 2 1855-03-03 0 0 0 0 0
T000152 Bannon Thibodeaux Bannon Thibodeaux   Whig LA House 2 1845-12-01 1849-03-03 0   [] 410734       Bannon G. Thibodeaux   1812-12-22 M 3 1849-03-03 1 0 0 0 0
B001114 Barker Burnell Barker Burnell   Whig MA House 10 1841-05-31 1845-03-03 0   [] 402059       Barker Burnell   1798-01-30 M 3 1845-03-03 0 0 0 0 0
S000971 Bellamy Storer Bellamy Storer   Whig OH House 1 1835-12-07 1837-03-03 0   [] 410429       Bellamy Storer (Ohio politician)   1796-03-26 M 2 1837-03-03 0 0 0 0 0
C000821 Benjamin Cowen Benjamin Cowen   Whig OH House 11 1841-05-31 1843-03-03 0   [] 402939       Benjamin S. Cowen   1793-09-27 M 2 1843-03-03 0 0 0 0 0
G000453 Benjamin Grey Benjamin Grey   Whig KY House 2 1851-12-01 1855-03-03 0   [] 412046       Benjamin E. Grey     M 3 1855-03-03 0 0 0 0 0
H000184 Benjamin Hardin Benjamin Hardin   Whig KY House 7 1815-12-04 1837-03-03 0   [] 405065       Benjamin Hardin   1784-02-29 M 12 1837-03-03 0 0 0 0 0
R000035 Benjamin Randall Benjamin Randall   Whig ME House 3 1839-12-02 1843-03-03 0   [] 409016       Benjamin Randall (Maine politician)   1789-11-14 M 3 1843-03-03 0 0 0 0 0
S001116 Benjamin Swift Benjamin Swift   Whig VT Senate   1827-12-03 1839-03-03 0   [] 410568       Benjamin Swift   1781-04-03 M 3 1839-03-03 0 0 0 0 0
T000192 Benjamin Thompson Benjamin Thompson   Whig MA House 4 1845-12-01 1853-03-03 0   [] 410772       Benjamin Thompson (politician)   1798-08-05 M 5 1853-03-03 0 0 0 0 0
B000522 Bernard Blair Bernard Blair   Whig NY House 12 1841-05-31 1843-03-03 0   [] 401498       Bernard Blair   1801-05-24 M 2 1843-03-03 0 0 0 0 0
O000162 Bryan Owsley Bryan Owsley   Whig KY House 4 1841-05-31 1843-03-03 0   [] 408412       Bryan Owsley   1798-08-19 M 2 1843-03-03 0 0 0 0 0
Y000030 Bryan Young Bryan Young   Whig KY House 5 1845-12-01 1847-03-03 0   [] 411964       Bryan Young (politician)   1800-01-14 M 2 1847-03-03 0 0 0 0 0
C001016 Caleb Cushing Caleb Cushing   Whig MA House 3 1835-12-07 1843-03-03 0   [] 403123       Caleb Cushing   1800-01-17 M 5 1843-03-03 0 0 0 0 0
S000519 Caleb Smith Caleb Smith   Whig IN House 4 1843-12-04 1849-03-03 0   [] 410003       Caleb B. Smith   1808-04-16 M 4 1849-03-03 0 0 0 0 0
M000973 Calvary Morris Calvary Morris   Whig OH House 6 1837-09-04 1843-03-03 0   [] 407941       Calvary Morris   1798-01-15 M 4 1843-03-03 0 0 0 0 0
C000186 Charles Carroll Charles Carroll   Whig NY House 29 1843-12-04 1847-03-03 0   [] 402333       Charles H. Carroll   1794-05-04 M 3 1847-03-03 0 0 0 0 0
C000310 Charles Chapman Charles Chapman   Whig CT House 1 1851-12-01 1853-03-03 0   [] 402452       Charles Chapman (Connecticut politician)   1799-06-21 M 2 1853-03-03 0 0 0 0 0
C000459 Charles Clarke Charles Clarke   Whig NY House 19 1849-12-03 1851-03-03 0   [] 402597       Charles E. Clarke   1790-04-08 M 2 1851-03-03 0 0 0 0 0
C000587 Charles Coffin Charles Coffin   Whig OH House 17 1837-09-04 1839-03-03 0   [] 402716       Charles D. Coffin   1804-09-10 M 2 1839-03-03 0 0 0 0 0
C000703 Charles Conrad Charles Conrad   Whig LA House 2 1842-01-01 1851-03-03 0   [] 402828       Charles Magill Conrad   1804-12-24 M 5 1851-03-03 0 0 0 0 0
H000907 Charles Hudson Charles Hudson   Whig MA House 5 1841-05-31 1849-03-03 0   [] 405753       Charles Hudson (American politician)   1795-11-14 M 5 1849-03-03 0 0 0 0 0
J000184 Charles Johnston Charles Johnston   Whig NY House 5 1839-12-02 1841-03-03 0   [] 406079       Charles Johnston (representative)   1793-02-14 M 2 1841-03-03 0 0 0 0 0
M000642 Charles Mercer Charles Mercer   Whig VA House 14 1817-12-01 1841-03-03 0   [] 407628       Charles F. Mercer   1778-06-16 M 13 1841-03-03 0 0 0 0 0
M000806 Charles Mitchell Charles Mitchell   Whig NY House 33 1837-09-04 1841-03-03 0   [] 412169       Charles F. Mitchell   1806-02-18 M 3 1841-03-03 0 0 0 0 0
M000936 Charles Morehead Charles Morehead   Whig KY House 8 1847-12-06 1851-03-03 0   [] 407905       Charles S. Morehead   1802-07-07 M 3 1851-03-03 0 0 0 0 0
N000011 Charles Naylor Charles Naylor   Whig PA House 3 1837-09-04 1841-03-03 0   [] 408105       Charles Naylor   1806-10-06 M 3 1841-03-03 0 0 0 0 0
O000047 Charles Ogle Charles Ogle   Whig PA House 18 1837-09-04 1843-03-03 0   [] 408330       Charles Ogle (politician)     M 4 1843-03-03 0 0 0 0 0
P000369 Charles Pitman Charles Pitman   Whig PA House 14 1849-12-03 1851-03-03 0   [] 412087       Charles W. Pitman     M 2 1851-03-03 0 0 0 0 0
R000110 Charles Reed Charles Reed   Whig PA House 23 1843-12-04 1845-03-03 0   [] 409090       Charles Manning Reed   1803-04-03 M 2 1845-03-03 0 0 0 0 0
R000390 Charles Rogers Charles Rogers   Whig NY House 14 1843-12-04 1845-03-03 0   [] 409358       Charles Rogers (New York politician)   1800-04-30 M 2 1845-03-03 0 0 0 0 0
S000993 Charles Stratton Charles Stratton   Whig NJ House -1 1837-09-04 1843-03-03 0   [] 410451       Charles C. Stratton   1796-03-06 M 4 1843-03-03 0 0 0 0 0
U000021 Charles Upham Charles Upham   Whig MA House 6 1853-12-05 1855-03-03 0   [] 411044       Charles W. Upham   1802-05-04 M 2 1855-03-03 0 0 0 0 0
B001175 Chester Butler Chester Butler   Whig PA House 11 1847-12-06 1851-03-03 0   [] 402117       Chester P. Butler   1798-03-21 M 3 1851-03-03 0 0 0 0 0
A000108 Chilton Allan Chilton Allan   Whig KY House 10 1831-12-05 1837-03-03 0   [] 400766       Chilton Allan   1786-04-06 M 4 1837-03-03 2 0 0 0 0
M000945 Christopher Morgan Christopher Morgan   Whig NY House 24 1839-12-02 1843-03-03 0   [] 407913       Christopher Morgan (politician)   1808-06-04 M 3 1843-03-03 0 0 0 0 0
W000493 Christopher Williams Christopher Williams   Whig TN House 11 1837-09-04 1853-03-03 0   [] 411650       Christopher Harris Williams   1798-12-18 M 9 1853-03-03 0 0 0 0 0
H000589 Clement Hill Clement Hill   Whig KY House 5 1853-12-05 1855-03-03 0   [] 405451       Clement S. Hill   1813-02-13 M 2 1855-03-03 0 0 0 0 0
D000061 Cornelius Darragh Cornelius Darragh   Whig PA House 21 1843-12-04 1847-03-03 0   [] 403200       Cornelius Darragh     M 3 1847-03-03 0 0 0 0 0
W000162 Cornelius Warren Cornelius Warren   Whig NY House 8 1847-12-06 1849-03-03 0   [] 411335       Cornelius Warren   1790-03-15 M 2 1849-03-03 0 0 0 0 0
P000479 Cuthbert Powell Cuthbert Powell   Whig VA House 14 1841-05-31 1843-03-03 0   [] 408864       Cuthbert Powell   1775-03-04 M 2 1843-03-03 0 0 0 0 0
B000152 Daniel Barnard Daniel Barnard   Whig NY House 13 1827-12-03 1845-03-03 0   [] 401154       Daniel D. Barnard   1797-07-16 M 10 1845-03-03 0 0 0 0 0
B000182 Daniel Barringer Daniel Barringer   Whig NC House 3 1843-12-04 1849-03-03 0   [] 401181       Daniel Moreau Barringer   1806-07-30 M 4 1849-03-03 0 0 0 0 0
B000782 Daniel Breck Daniel Breck   Whig KY House 6 1849-12-03 1851-03-03 0   [] 401740       Daniel Breck   1788-02-12 M 2 1851-03-03 0 0 0 0 0
D000529 Daniel Duncan Daniel Duncan   Whig OH House 10 1847-12-06 1849-03-03 0   [] 403638       Daniel Duncan (Ohio politician)   1806-07-22 M 2 1849-03-03 0 0 0 0 0
G000339 Daniel Gott Daniel Gott   Whig NY House 24 1847-12-06 1851-03-03 0   [] 404695       Daniel Gott   1794-07-10 M 3 1851-03-03 0 0 0 0 0
J000078 Daniel Jenifer Daniel Jenifer   Whig MD House 7 1831-12-05 1841-03-03 0   [] 405981       Daniel Jenifer   1791-04-15 M 6 1841-03-03 0 0 0 0 0
K000198 Daniel King Daniel King   Whig MA House 2 1843-12-04 1851-03-03 0   [] 406359       Daniel P. King   1801-01-08 M 5 1851-03-03 0 0 0 0 0
M000721 Daniel Miller Daniel Miller   Whig IA House 1 1849-12-03 1851-03-03 0   [] 407702       Daniel F. Miller   1814-10-04 M 2 1851-03-03 1 0 0 0 0
S000766 Daniel St. John Daniel St. John   Whig NY House 9 1847-12-06 1849-03-03 0   [] 410233       Daniel B. St. John   1808-10-08 M 2 1849-03-03 0 0 0 0 0
T000270 Daniel Tilden Daniel Tilden   Whig OH House 19 1843-12-04 1847-03-03 0   [] 410843       Daniel R. Tilden   1804-11-05 M 3 1847-03-03 0 0 0 0 0
W000238 Daniel Webster Daniel Webster   Whig MA Senate   1813-05-24 1850-07-22 0   [] 411406       Daniel Webster   1782-01-18 M 7 1850-07-22 24 0 0 0 0
B000599 David Bokee David Bokee   Whig NY House 2 1849-12-03 1851-03-03 0   [] 401567       David A. Bokee   1805-10-06 M 2 1851-03-03 0 0 0 0 0
B000868 David Bronson David Bronson   Whig ME House 4 1841-05-31 1843-03-03 0   [] 401825       David Bronson   1800-02-08 M 2 1843-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);