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

64 rows where chamber = "Senate" and party = "Whig" sorted by full_name

✎ View and edit SQL

This data as json, CSV (advanced)

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

state 22

party 1

  • Whig · 64 ✖

is_current 1

  • 0 64

chamber 1

  • Senate · 64 ✖
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
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
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
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
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
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
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
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 3 0 0 0 0
S000905 David Stewart David Stewart   Whig MD Senate   1849-12-03 1851-03-03 0   [] 410366       David Stewart (Maryland politician)   1800-09-13 M 1 1851-03-03 0 0 0 0 0
E000264 Edward Everett Edward Everett   Whig MA Senate   1825-12-05 1855-03-03 0   [] 403944       Edward Everett   1794-04-11 M 6 1855-03-03 0 0 0 0 0
F000302 Ephraim Foster Ephraim Foster   Whig TN Senate   1838-01-01 1845-03-03 0   [] 404251       Ephraim H. Foster   1794-09-17 M 2 1845-03-03 0 0 0 0 0
B000022 George Badger George Badger   Whig NC Senate   1846-01-01 1855-03-03 0   [] 401027       George Edmund Badger   1795-04-17 M 2 1855-03-03 0 0 0 0 0
E000241 George Evans George Evans   Whig ME Senate   1829-12-07 1847-03-03 0   [] 403925       George Evans (American politician)   1797-01-12 M 4 1847-03-03 0 0 0 0 0
C000482 Henry Clay Henry Clay   Whig KY Senate   1806-01-01 1853-03-03 0   [] 402620       Henry Clay   1777-04-12 M 8 1853-03-03 0 0 0 0 0
J000137 Henry Johnson Henry Johnson   Whig LA Senate   1818-01-01 1849-03-03 0   [] 406036       Henry Johnson (Louisiana politician)   1783-09-14 M 6 1849-03-03 0 0 0 0 0
W000376 Hugh White Hugh White   Whig TN Senate   1825-12-05 1841-03-03 0   [] 411537       Hugh Lawson White   1773-10-30 M 3 1841-03-03 0 0 0 0 0
B000233 Isaac Bates Isaac Bates   Whig MA Senate   1827-12-03 1845-12-31 0   [] 401228       Isaac C. Bates   1779-01-23 M 4 1845-12-31 0 0 0 0 0
H000997 Jabez Huntington Jabez Huntington   Whig CT Senate   1829-12-07 1847-12-31 0   [] 405837       Jabez W. Huntington   1788-11-08 M 4 1847-12-31 0 0 0 0 0
M001015 Jackson Morton Jackson Morton   Whig FL Senate   1849-12-03 1855-03-03 0   [] 407982       Jackson Morton   1794-08-10 M 2 1855-03-03 0 0 0 0 0
M000731 Jacob Miller Jacob Miller   Whig NJ Senate   1841-05-31 1853-03-03 0   [] 407710       Jacob W. Miller   1800-08-29 M 3 1853-03-03 0 0 0 0 0
C000753 James Cooper James Cooper   Whig PA Senate   1839-12-02 1855-03-03 0   [] 402874       James Cooper (Pennsylvania politician)   1810-05-08 M 3 1855-03-03 0 0 0 0 0
M000938 James Morehead James Morehead   Whig KY Senate   1841-05-31 1847-03-03 0   [] 407906       James T. Morehead (Kentucky politician)   1797-05-24 M 2 1847-03-03 0 0 0 0 0
B000413 John Berrien John Berrien   Whig GA Senate   1825-12-05 1853-03-03 0   [] 401400       John M. Berrien   1781-08-23 M 5 1853-03-03 0 0 0 0 0
B000503 John Black John Black   Whig MS Senate   1832-11-12 1838-01-22 0   [] 412016       John Black (Mississippi politician)   1800-08-11 M 2 1838-01-22 0 0 0 0 0
C000466 John Clarke John Clarke   Whig RI Senate   1847-12-06 1853-03-03 0   [] 402604       John Hopkins Clarke   1789-04-01 M 2 1853-03-03 0 0 0 0 0
D000117 John Davis John Davis   Whig MA Senate   1825-12-05 1853-03-03 0   [] 403250       John Davis (Massachusetts governor)   1787-01-13 M 5 1853-03-03 0 0 0 0 0
H000482 John Henderson John Henderson   Whig MS Senate   1839-12-02 1845-03-03 0   [] 405345       John Henderson (Mississippi politician)   1797-02-28 M 2 1845-03-03 0 0 0 0 0
K000139 John Kerr John Kerr   Whig MD Senate   1825-12-05 1843-03-03 0   [] 406305       John Leeds Kerr   1780-01-15 M 4 1843-03-03 0 0 0 0 0
S000719 John Spence John Spence   Whig MD Senate   1823-12-01 1840-10-24 0   [] 410188       John S. Spence   1788-02-29 M 3 1840-10-24 0 0 0 0 0
W000043 John Wales John Wales   Whig DE Senate   1849-12-03 1851-03-03 0   [] 411223       John Wales   1783-07-31 M 1 1851-03-03 0 0 0 0 0
K000125 Joseph Kent Joseph Kent   Whig MD Senate   1811-11-04 1837-12-31 0   [] 406291       Joseph Kent   1779-01-14 M 5 1837-12-31 0 0 0 0 0
U000011 Joseph Underwood Joseph Underwood   Whig KY Senate   1835-12-07 1853-03-03 0   [] 411035       Joseph R. Underwood   1791-10-24 M 4 1853-03-03 0 0 0 0 0
R000368 Julius Rockwell Julius Rockwell   Whig MA Senate   1843-12-04 1855-12-31 0   [] 409338       Julius Rockwell   1805-04-26 M 3 1855-12-31 0 0 0 0 0
D000376 Nathan Dixon Nathan Dixon   Whig RI Senate   1839-12-02 1843-03-03 0   [] 403491       Nathan F. Dixon I   1774-12-13 M 1 1843-03-03 0 0 0 0 0
T000032 Nathaniel Tallmadge Nathaniel Tallmadge   Whig NY Senate   1833-12-02 1845-03-03 0   [] 410621       Nathaniel P. Tallmadge   1795-02-08 M 3 1845-03-03 0 0 0 0 0
K000287 Nehemiah Knight Nehemiah Knight   Whig RI Senate   1821-12-03 1841-03-03 0   [] 406444       Nehemiah R. Knight   1780-12-31 M 4 1841-03-03 0 0 0 0 0
S000599 Oliver Smith Oliver Smith   Whig IN Senate   1827-12-03 1843-03-03 0   [] 410077       Oliver H. Smith   1794-10-23 M 3 1843-03-03 0 0 0 0 0
S000760 Presley Spruance Presley Spruance   Whig DE Senate   1847-12-06 1853-03-03 0   [] 410227       Presley Spruance   1785-09-11 M 2 1853-03-03 0 0 0 0 0
B000251 Richard Bayard Richard Bayard   Whig DE Senate   1836-06-17 1845-03-03 0   [] 401245       Richard H. Bayard   1796-09-26 M 2 1845-03-03 0 0 0 0 0
G000264 Robert Goldsborough Robert Goldsborough   Whig MD Senate   1813-05-24 1837-03-03 0   [] 404626       Robert Henry Goldsborough   1779-01-04 M 5 1837-03-03 0 0 0 0 0
W000646 Robert Winthrop Robert Winthrop   Whig MA Senate   1839-12-02 1851-03-03 0   [] 411800       Robert C. Winthrop   1809-05-12 M 3 1851-03-03 0 0 0 0 0
B000096 Roger Baldwin Roger Baldwin   Whig CT Senate   1847-12-06 1851-03-03 0   [] 401098       Roger Sherman Baldwin   1793-01-04 M 1 1851-03-03 0 0 0 0 0
C000375 Rufus Choate Rufus Choate   Whig MA Senate   1831-12-05 1845-03-03 0   [] 402514       Rufus Choate   1799-10-01 M 3 1845-03-03 0 0 0 0 0
C000851 Samuel Crafts Samuel Crafts   Whig VT Senate   1817-12-01 1843-03-03 0   [] 402967       Samuel C. Crafts   1768-10-06 M 5 1843-03-03 0 0 0 0 0
P000299 Samuel Phelps Samuel Phelps   Whig VT Senate   1839-12-02 1855-03-03 0   [] 408699       Samuel S. Phelps   1793-05-13 M 3 1855-03-03 0 0 0 0 0
P000510 Samuel Prentiss Samuel Prentiss   Whig VT Senate   1831-12-05 1843-03-03 0   [] 408895       Samuel Prentiss   1782-03-31 M 3 1843-03-03 0 0 0 0 0
S000689 Samuel Southard Samuel Southard   Whig NJ Senate   1821-01-26 1842-06-26 0   [] 410160       Samuel L. Southard   1787-06-09 M 4 1842-06-26 0 0 0 0 0
J000059 Spencer Jarnagin Spencer Jarnagin   Whig TN Senate   1843-12-04 1847-03-03 0   [] 405964       Spencer Jarnagin     M 1 1847-03-03 0 0 0 0 0
B000428 Thaddeus Betts Thaddeus Betts   Whig CT Senate   1839-12-02 1841-03-03 0   [] 401414       Thaddeus Betts   1789-02-04 M 1 1841-03-03 0 0 0 0 0
C000499 Thomas Clayton Thomas Clayton   Whig DE Senate   1815-12-04 1847-03-03 0   [] 402636       Thomas Clayton     M 6 1847-03-03 0 0 0 0 0
E000281 Thomas Ewing Thomas Ewing   Whig OH Senate   1831-12-05 1851-03-03 0   [] 403959       Thomas Ewing   1789-12-28 M 4 1851-03-03 0 0 0 0 0
M000676 Thomas Metcalfe Thomas Metcalfe   Whig KY Senate   1819-12-06 1849-03-03 0   [] 407661       Thomas Metcalfe (Kentucky politician)   1780-03-20 M 6 1849-03-03 0 0 0 0 0
S000621 Truman Smith Truman Smith   Whig CT Senate   1839-12-02 1855-03-03 0   [] 410096       Truman Smith   1791-11-27 M 3 1855-03-03 0 0 0 0 0
B000872 Walker Brooke Walker Brooke   Whig MS Senate   1852-01-01 1853-03-03 0   [] 401829       Walker Brooke   1813-12-25 M 1 1853-03-03 0 0 0 0 0
A000275 William Archer William Archer   Whig VA Senate   1819-12-06 1847-03-03 0   [] 400914       William S. Archer   1789-03-05 M 5 1847-03-03 0 0 0 0 0
D000156 William Dawson William Dawson   Whig GA Senate   1835-12-07 1855-03-03 0   [] 403289       William C. Dawson   1798-01-04 M 4 1855-03-03 0 0 0 0 0
D000166 William Dayton William Dayton   Whig NJ Senate   1842-01-01 1851-03-03 0   [] 403298       William L. Dayton   1807-02-17 M 2 1851-03-03 0 0 0 0 0
G000362 William Graham William Graham   Whig NC Senate   1840-01-01 1843-03-03 0   [] 404716       William Alexander Graham   1804-09-05 M 1 1843-03-03 0 0 0 0 0
M000654 William Merrick William Merrick   Whig MD Senate   1838-01-04 1845-03-03 0   [] 407640       William Duhurst Merrick   1793-10-25 M 2 1845-03-03 0 0 0 0 0
P000519 William Preston William Preston   Whig SC Senate   1833-12-02 1843-03-03 0   [] 408904       William C. Preston   1794-12-27 M 2 1843-03-03 0 0 0 0 0
R000285 William Rives William Rives   Whig VA Senate   1823-12-01 1845-03-03 0   [] 409258       William Cabell Rives   1793-05-04 M 4 1845-03-03 0 0 0 0 0
S000746 William Sprague William Sprague   Whig RI Senate   1835-12-07 1845-03-03 0   [] 410214       William Sprague III   1799-11-03 M 2 1845-03-03 0 0 0 0 0
U000025 William Upham William Upham   Whig VT Senate   1843-12-04 1853-12-31 0   [] 411048       William Upham   1792-08-05 M 2 1853-12-31 0 0 0 0 0
W000709 William Woodbridge William Woodbridge   Whig MI Senate   1819-12-06 1847-03-03 0   [] 411861       William Woodbridge   1780-08-20 M 5 1847-03-03 0 0 0 0 0
M000096 Willie Mangum Willie Mangum   Whig NC Senate   1823-12-01 1853-03-03 0   [] 407120       Willie P. Mangum   1792-05-10 M 6 1853-03-03 0 0 0 0 0

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