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

427 rows where is_current = 0 and state = "MA" sorted by full_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: nickname, district, opensecrets_id, fec_ids, ballotpedia_id, gender, terms_count, trade_count, speech_count, bills_sponsored, vote_count, fec_total_received, first_served (date), last_served (date), birthday (date), served_until (date), fec_ids (array)

chamber 2

state 1

  • MA · 427 ✖

is_current 1

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
H000659 Aaron Hobart Aaron Hobart   Adams MA House 11 1819-12-06 1827-03-03 0   [] 405514       Aaron Hobart   1787-06-26 M 5 1827-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
W000687 Abiel Wood Abiel Wood   Republican MA House 17 1813-05-24 1815-03-03 0   [] 411839       Abiel Wood   1772-07-22 M 2 1815-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
A000240 Abram Andrew Abram Andrew   Republican MA House 6 1921-04-11 1937-01-03 0   [] 400869       A. Piatt Andrew   1873-02-12 M 9 1937-01-03 0 0 0 0 0
D000282 Alexander De Witt Alexander De Witt   American MA House 9 1853-12-05 1857-03-03 0   [] 403324       Alexander De Witt   1798-04-02 M 3 1857-03-03 0 0 0 0 0
R000193 Alexander Rice Alexander Rice   Republican MA House 3 1859-12-05 1867-03-03 0   [] 409169       Alexander H. Rice   1818-08-30 M 5 1867-03-03 0 0 0 0 0
T000358 Allen Treadway Allen Treadway   Republican MA House 1 1913-04-07 1945-01-03 0   [] 410928       Allen T. Treadway   1867-09-16 M 17 1945-01-03 0 0 0 0 0
C000916 Alvah Crocker Alvah Crocker   Republican MA House 10 1871-03-04 1875-03-03 0   [] 403028       Alvah Crocker   1801-10-14 M 3 1875-03-03 0 0 0 0 0
F000405 Alvan Fuller Alvan Fuller   Republican MA House 9 1917-04-02 1921-03-03 0   [] 404346       Alvan T. Fuller   1878-02-27 M 3 1921-03-03 0 0 0 0 0
N000134 Amasa Norcross Amasa Norcross   Republican MA House 10 1877-10-15 1883-03-03 0   [] 408218       Amasa Norcross   1824-01-26 M 4 1883-03-03 0 0 0 0 0
W000045 Amasa Walker Amasa Walker   Republican MA House 9 1861-07-04 1863-03-03 0   [] 411225       Amasa Walker   1799-05-04 M 2 1863-03-03 0 0 0 0 0
R000058 Ambrose Ranney Ambrose Ranney   Republican MA House 3 1881-12-05 1887-03-03 0   [] 409038       Ambrose Ranney   1821-04-17 M 4 1887-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
P000251 Andrew Peters Andrew Peters   Democrat MA House 11 1907-12-02 1915-03-03 0   [] 408654       Andrew J. Peters   1872-04-03 M 5 1915-03-03 0 0 0 0 0
G000297 Angier Goodwin Angier Goodwin   Republican MA House 8 1943-01-06 1955-01-03 0   [] 404656       Angier Goodwin   1881-01-30 M 7 1955-01-03 0 0 0 0 0
B001112 Anson Burlingame Anson Burlingame   Republican MA House 5 1855-12-03 1861-03-03 0   [] 402057       Anson Burlingame   1820-11-14 M 4 1861-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
W000127 Artemas Ward Artemas Ward     MA House 2 1791-10-24 1795-03-03 0   [] 411302       Artemas Ward   1727-11-26 M 3 1795-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
H000423 Arthur Healey Arthur Healey   Democrat MA House 8 1933-03-09 1943-01-03 0   [] 405289       Arthur Daniel Healey   1889-12-29 M 6 1943-01-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
W000754 Ashley Wright Ashley Wright   Republican MA House 1 1893-08-07 1899-03-03 0   [] 411903       Ashley B. Wright   1841-05-25 M 4 1899-03-03 0 0 0 0 0
G000050 Augustus Gardner Augustus Gardner   Republican MA House 6 1901-12-02 1919-03-03 0   [] 404424       Augustus P. Gardner   1865-11-05 M 10 1919-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
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
B000446 Barnabas Bidwell Barnabas Bidwell   Republican MA House -1 1805-12-02 1809-03-03 0   [] 401431       Barnabas Bidwell   1763-08-23 M 3 1809-03-03 0 0 0 0 0
F000339 Barney Frank Barney Frank   Democrat MA House 4 1981-01-05 2013-01-03 0 N00000275 ["H0MA04036"] 400140 00407 26897   Barney Frank   1940-03-31 M 17 2013-01-03 0 1395 182 7489 1448100
G000039 Barzillai Gannett Barzillai Gannett   Republican MA House -1 1809-05-22 1813-03-03 0   [] 404415       Barzillai Gannett   1764-06-17 M 3 1813-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
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
B001174 Benjamin Butler Benjamin Butler   Republican MA House 7 1867-03-04 1879-03-03 0   [] 402116       Benjamin Butler   1818-11-05 M 7 1879-03-03 0 0 0 0 0
C000946 Benjamin Crowninshield Benjamin Crowninshield     MA House 2 1823-12-01 1831-03-03 0   [] 403058       Benjamin Williams Crowninshield   1772-12-27 M 5 1831-03-03 0 0 0 0 0
D000170 Benjamin Dean Benjamin Dean   Democrat MA House 3 1877-10-15 1879-03-03 0   [] 403332       Benjamin Dean   1824-08-14 M 2 1879-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
G000324 Benjamin Gorham Benjamin Gorham   Anti Jacksonian MA House 1 1819-12-06 1835-03-03 0   [] 404682       Benjamin Gorham   1775-02-13 M 9 1835-03-03 0 0 0 0 0
H000233 Benjamin Harris Benjamin Harris   Republican MA House 2 1873-12-01 1883-03-03 0   [] 405111       Benjamin W. Harris   1823-11-10 M 6 1883-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
S000517 Benjamin Smith Benjamin Smith   Democrat MA Senate   1960-12-27 1963-01-03 0   [] 410001       Benjamin A. Smith II   1916-03-26 M 1 1963-01-03 0 0 0 0 0
T000157 Benjamin Thomas Benjamin Thomas   Unionist MA House 3 1861-07-04 1863-03-03 0   [] 410739       Benjamin Thomas (politician)   1813-02-12 M 2 1863-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
D000416 Brian Donnelly Brian Donnelly   Democrat MA House 11 1979-01-15 1993-01-03 0   [] 403529 00304     Brian J. Donnelly   1946-03-02 M 8 1993-01-03 0 0 0 0 0
A000173 Butler Ames Butler Ames   Republican MA House 5 1903-11-09 1913-03-03 0   [] 400828       Butler Ames   1871-08-22 M 6 1913-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
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
C000270 Calvin Chaffee Calvin Chaffee   Republican MA House 10 1855-12-03 1859-03-03 0   [] 402413       Calvin C. Chaffee   1811-08-28 M 3 1859-03-03 0 0 0 0 0
P000024 Calvin Paige Calvin Paige   Republican MA House 3 1913-04-07 1925-03-03 0   [] 408435       Calvin Paige   1848-05-20 M 7 1925-03-03 0 0 0 0 0
A000032 Charles Adams Charles Adams   Republican MA House 3 1859-12-05 1863-03-03 0   [] 400693       Charles Francis Adams Sr.   1807-08-18 M 3 1863-03-03 0 0 0 0 0
A000115 Charles Allen Charles Allen   Free Soil MA House 5 1849-12-03 1853-03-03 0   [] 400772       Charles Allen (Massachusetts politician)   1797-08-09 M 3 1853-03-03 0 0 0 0 0
A000116 Charles Allen Charles Allen   Republican MA House 8 1885-12-07 1889-03-03 0   [] 400773       Charles H. Allen   1848-04-15 M 3 1889-03-03 0 0 0 0 0
C000473 Charles Clason Charles Clason   Republican MA House 2 1937-01-05 1949-01-03 0   [] 402611       Charles R. Clason   1890-09-03 M 7 1949-01-03 0 0 0 0 0
D000213 Charles Delano Charles Delano   Republican MA House 10 1859-12-05 1863-03-03 0   [] 403357       Charles Delano   1820-06-24 M 3 1863-03-03 0 0 0 0 0
G000169 Charles Gifford Charles Gifford   Republican MA House 9 1921-04-11 1949-01-03 0   [] 404536       Charles L. Gifford   1871-03-15 M 15 1949-01-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
R000037 Charles Randall Charles Randall   Republican MA House 13 1889-12-02 1895-03-03 0   [] 409018       Charles S. Randall   1824-02-20 M 4 1895-03-03 0 0 0 0 0
S000742 Charles Sprague Charles Sprague   Republican MA House 11 1897-03-15 1901-03-03 0   [] 410211       Charles F. Sprague   1857-06-10 M 3 1901-03-03 0 0 0 0 0
S000877 Charles Stevens Charles Stevens   Republican MA House 10 1873-12-01 1875-03-03 0   [] 410339       Charles A. Stevens   1816-08-09 M 2 1875-03-03 0 0 0 0 0
S001068 Charles Sumner Charles Sumner   Liberal Republican MA Senate   1851-12-01 1875-03-03 0   [] 410522       Charles Sumner   1811-01-06 M 5 1875-03-03 0 0 0 0 0
T000195 Charles Thompson Charles Thompson   Democrat MA House 6 1875-12-06 1877-03-03 0   [] 410774       Charles Perkins Thompson   1827-07-30 M 2 1877-03-03 0 0 0 0 0
T000287 Charles Tirrell Charles Tirrell   Republican MA House 4 1901-12-02 1911-03-03 0   [] 410860       Charles Q. Tirrell   1844-12-10 M 6 1911-03-03 0 0 0 0 0
T000352 Charles Train Charles Train   Republican MA House 8 1859-12-05 1863-03-03 0   [] 410922       Charles R. Train   1817-10-18 M 3 1863-03-03 0 0 0 0 0
T000416 Charles Turner Charles Turner   Republican MA House 7 1809-05-22 1813-03-03 0   [] 410985       Charles Turner Jr.   1760-06-20 M 3 1813-03-03 0 0 0 0 0
U000006 Charles Underhill Charles Underhill   Republican MA House 9 1921-04-11 1933-03-03 0   [] 411030       Charles L. Underhill   1867-07-20 M 7 1933-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
W000171 Charles Washburn Charles Washburn   Republican MA House 3 1905-12-04 1911-03-03 0   [] 411344       Charles G. Washburn   1857-01-28 M 4 1911-03-03 0 0 0 0 0
K000280 Chauncey Knapp Chauncey Knapp   Republican MA House 8 1855-12-03 1859-03-03 0   [] 406437       Chauncey L. Knapp   1809-02-26 M 3 1859-03-03 0 0 0 0 0
A000226 Chester Atkins Chester Atkins   Democrat MA House 5 1985-01-03 1993-01-03 0   [] 400975 00034     Chester G. Atkins   1948-04-14 M 5 1993-01-03 0 0 0 0 0
C000305 Chester Chapin Chester Chapin   Democrat MA House 11 1875-12-06 1877-03-03 0   [] 402447       Chester W. Chapin   1798-12-16 M 2 1877-03-03 0 0 0 0 0
H000548 Christian Herter Christian Herter   Republican MA House 10 1943-01-06 1953-01-03 0   [] 405410       Christian Herter   1895-03-28 M 6 1953-01-03 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
E000225 Constantine Esty Constantine Esty   Republican MA House 7 1871-03-04 1873-03-03 0   [] 403911       Constantine C. Esty   1824-12-26 M 2 1873-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
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
G000274 Daniel Gooch Daniel Gooch   Republican MA House 5 1857-12-07 1875-03-03 0   [] 404636       Daniel W. Gooch   1820-01-08 M 10 1875-03-03 0 0 0 0 0
I000009 Daniel Ilsley Daniel Ilsley   Republican MA House 15 1807-10-26 1809-03-03 0   [] 405871       Daniel Ilsley   1740-05-30 M 2 1809-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
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
C000545 David Cobb David Cobb     MA House -1 1793-12-02 1795-03-03 0   [] 402678       David Cobb (Massachusetts politician)   1748-09-14 M 2 1795-03-03 0 0 0 0 0
W000097 David Walsh David Walsh   Democrat MA Senate   1919-05-19 1947-01-03 0   [] 411276       David I. Walsh   1872-11-11 M 5 1947-01-03 0 0 0 0 0
N000097 Donald Nicholson Donald Nicholson   Republican MA House 9 1947-01-03 1959-01-03 0   [] 408182       Donald W. Nicholson   1888-08-11 M 7 1959-01-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
S000956 Eben Stone Eben Stone   Republican MA House 7 1881-12-05 1887-03-03 0   [] 410415       Eben F. Stone   1822-08-03 M 4 1887-03-03 0 0 0 0 0
H000653 Ebenezer Hoar Ebenezer Hoar   Republican MA House 7 1873-12-01 1875-03-03 0   [] 405508       Ebenezer R. Hoar   1816-02-21 M 2 1875-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
S000215 Ebenezer Seaver Ebenezer Seaver   Republican MA House 13 1803-10-17 1813-03-03 0   [] 409720       Ebenezer Seaver   1763-07-05 M 6 1813-03-03 0 0 0 0 0
R000392 Edith Rogers Edith Rogers   Republican MA House 5 1925-12-07 1961-01-03 0   [] 409360       Edith Nourse Rogers   1881-03-19 F 19 1961-01-03 0 0 0 0 0
B000600 Edward Boland Edward Boland   Democrat MA House 2 1953-01-03 1989-01-03 0   [] 401568 00104     Edward Boland   1911-10-01 M 19 1989-01-03 0 0 0 0 0
B000871 Edward Brooke Edward Brooke   Republican MA Senate   1967-01-10 1979-01-03 0   [] 401828 01292     Edward Brooke   1919-10-26 M 3 1979-01-03 0 0 0 0 0
B001119 Edward Burnett Edward Burnett   Democrat MA House 9 1887-12-05 1889-03-03 0   [] 402064       Edward Burnett   1849-03-16 M 2 1889-03-03 0 0 0 0 0
D000319 Edward Dickinson Edward Dickinson   Whig MA House 10 1853-12-05 1855-03-03 0   [] 403439       Edward Dickinson   1803-01-01 M 2 1855-03-03 0 0 0 0 0
D000477 Edward Dowse Edward Dowse   Republican MA House 13 1819-12-06 1821-03-03 0   [] 403586       Edward Dowse   1756-10-22 M 2 1821-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
G000221 Edward Gilmore Edward Gilmore   Democrat MA House 14 1913-04-07 1915-03-03 0   [] 404583       Edward Gilmore   1867-01-04 M 2 1915-03-03 0 0 0 0 0
H000386 Edward Hayden Edward Hayden   Republican MA House 5 1885-12-07 1889-03-03 0   [] 405254       Edward D. Hayden   1833-12-27 M 3 1889-03-03 0 0 0 0 0
K000105 Edward Kennedy Edward Kennedy Ted Democrat MA Senate   1962-11-07 2009-08-25 0 N00000308 ["S6MA00015"] 300059 01377 53305 S055 Ted Kennedy   1932-02-22 M 8 2009-08-25 0 3973 237 3552 4500
L000350 Edward Little Edward Little   Democrat MA House 9 1851-12-01 1853-03-03 0   [] 406842       Edward P. Little   1791-11-07 M 2 1853-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
G000139 Elbridge Gerry Elbridge Gerry     MA House 3 1789-03-04 1793-03-03 0   [] 404507       Elbridge Gerry   1744-07-17 M 3 1793-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

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