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

438 rows where state = "MA" sorted by full_name

✎ View and edit SQL

This data as json, CSV (advanced)

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

is_current 2

  • 0 427
  • 1 11

chamber 2

state 1

  • MA · 438 ✖
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
H000659 Aaron Hobart Aaron Hobart   Adams MA House 11 1819-12-06 1827-03-03 0 []     1787-06-26 M 5 1827-03-03 0 0 0 0 0 0 0
L000130 Abbott Lawrence Abbott Lawrence   Whig MA House 1 1835-12-07 1841-03-03 0 []     1792-12-16 M 4 1841-03-03 0 0 0 0 0 0 0
W000687 Abiel Wood Abiel Wood   Republican MA House 17 1813-05-24 1815-03-03 0 []     1772-07-22 M 2 1815-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
A000240 Abram Andrew Abram Andrew   Republican MA House 6 1921-04-11 1937-01-03 0 []     1873-02-12 M 9 1937-01-03 0 0 0 0 0 0 0
D000282 Alexander De Witt Alexander De Witt   American MA House 9 1853-12-05 1857-03-03 0 []     1798-04-02 M 3 1857-03-03 0 0 0 0 0 0 0
R000193 Alexander Rice Alexander Rice   Republican MA House 3 1859-12-05 1867-03-03 0 []     1818-08-30 M 5 1867-03-03 0 0 0 0 0 0 0
T000358 Allen Treadway Allen Treadway   Republican MA House 1 1913-04-07 1945-01-03 0 []     1867-09-16 M 17 1945-01-03 0 0 0 0 0 0 0
C000916 Alvah Crocker Alvah Crocker   Republican MA House 10 1871-03-04 1875-03-03 0 []     1801-10-14 M 3 1875-03-03 0 0 0 0 0 0 0
F000405 Alvan Fuller Alvan Fuller   Republican MA House 9 1917-04-02 1921-03-03 0 []     1878-02-27 M 3 1921-03-03 0 0 0 0 0 0 0
N000134 Amasa Norcross Amasa Norcross   Republican MA House 10 1877-10-15 1883-03-03 0 []     1824-01-26 M 4 1883-03-03 0 0 0 0 0 0 0
W000045 Amasa Walker Amasa Walker   Republican MA House 9 1861-07-04 1863-03-03 0 []     1799-05-04 M 2 1863-03-03 0 0 0 0 0 0 0
R000058 Ambrose Ranney Ambrose Ranney   Republican MA House 3 1881-12-05 1887-03-03 0 []     1821-04-17 M 4 1887-03-03 0 0 0 0 0 0 0
A000004 Amos Abbott Amos Abbott   Whig MA House 3 1843-12-04 1849-03-03 0 []     1786-09-10 M 4 1849-03-03 0 0 0 0 0 0 0
P000251 Andrew Peters Andrew Peters   Democrat MA House 11 1907-12-02 1915-03-03 0 []     1872-04-03 M 5 1915-03-03 0 0 0 0 0 0 0
G000297 Angier Goodwin Angier Goodwin   Republican MA House 8 1943-01-06 1955-01-03 0 []     1881-01-30 M 7 1955-01-03 0 0 0 0 0 0 0
B001112 Anson Burlingame Anson Burlingame   Republican MA House 5 1855-12-03 1861-03-03 0 []     1820-11-14 M 4 1861-03-03 0 0 0 0 0 0 0
H000028 Artemas Hale Artemas Hale   Whig MA House 9 1845-12-01 1849-03-03 0 []     1783-10-20 M 3 1849-03-03 0 0 0 0 0 0 0
W000127 Artemas Ward Artemas Ward     MA House 2 1791-10-24 1795-03-03 0 []     1727-11-26 M 3 1795-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
H000423 Arthur Healey Arthur Healey   Democrat MA House 8 1933-03-09 1943-01-03 0 []     1889-12-29 M 6 1943-01-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
W000754 Ashley Wright Ashley Wright   Republican MA House 1 1893-08-07 1899-03-03 0 []     1841-05-25 M 4 1899-03-03 0 0 0 0 0 0 0
G000050 Augustus Gardner Augustus Gardner   Republican MA House 6 1901-12-02 1919-03-03 0 []     1865-11-05 M 10 1919-03-03 0 0 0 0 0 0 0
P000617 Ayanna Pressley Ayanna Pressley   Democrat MA House 7 2019-01-03 2027-01-03 1 ["H8MA07032"]     1974-02-03 F 5   0 166 141 3226 529302 143113 143639
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
B001114 Barker Burnell Barker Burnell   Whig MA House 10 1841-05-31 1845-03-03 0 []     1798-01-30 M 3 1845-03-03 0 0 0 0 0 0 0
B000446 Barnabas Bidwell Barnabas Bidwell   Republican MA House -1 1805-12-02 1809-03-03 0 []     1763-08-23 M 3 1809-03-03 0 0 0 0 0 0 0
F000339 Barney Frank Barney Frank   Democrat MA House 4 1981-01-05 2013-01-03 0 ["H0MA04036"] 00407   1940-03-31 M 17 2013-01-03 0 1395 692 7489 1231684 5086 188984
G000039 Barzillai Gannett Barzillai Gannett   Republican MA House -1 1809-05-22 1813-03-03 0 []     1764-06-17 M 3 1813-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
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
B001174 Benjamin Butler Benjamin Butler   Republican MA House 7 1867-03-04 1879-03-03 0 []     1818-11-05 M 7 1879-03-03 0 0 0 0 0 0 0
C000946 Benjamin Crowninshield Benjamin Crowninshield     MA House 2 1823-12-01 1831-03-03 0 []     1772-12-27 M 5 1831-03-03 0 0 0 0 0 0 0
D000170 Benjamin Dean Benjamin Dean   Democrat MA House 3 1877-10-15 1879-03-03 0 []     1824-08-14 M 2 1879-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
G000324 Benjamin Gorham Benjamin Gorham   Anti Jacksonian MA House 1 1819-12-06 1835-03-03 0 []     1775-02-13 M 9 1835-03-03 0 0 0 0 0 0 0
H000233 Benjamin Harris Benjamin Harris   Republican MA House 2 1873-12-01 1883-03-03 0 []     1823-11-10 M 6 1883-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
S000517 Benjamin Smith Benjamin Smith   Democrat MA Senate   1960-12-27 1962-11-06 0 []     1916-03-26 M 1 1962-11-06 0 0 0 0 0 0 0
T000157 Benjamin Thomas Benjamin Thomas   Unionist MA House 3 1861-07-04 1863-03-03 0 []     1813-02-12 M 2 1863-03-03 0 0 0 0 0 0 0
T000192 Benjamin Thompson Benjamin Thompson   Whig MA House 4 1845-12-01 1853-03-03 0 []     1798-08-05 M 5 1853-03-03 0 0 0 0 0 0 0
D000416 Brian Donnelly Brian Donnelly   Democrat MA House 11 1979-01-15 1993-01-03 0 [] 00304   1946-03-02 M 8 1993-01-03 0 0 202 0 0 0 0
A000173 Butler Ames Butler Ames   Republican MA House 5 1903-11-09 1913-03-03 0 []     1871-08-22 M 6 1913-03-03 0 0 0 0 0 0 0
C001016 Caleb Cushing Caleb Cushing   Whig MA House 3 1835-12-07 1843-03-03 0 []     1800-01-17 M 5 1843-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
C000270 Calvin Chaffee Calvin Chaffee   Republican MA House 10 1855-12-03 1859-03-03 0 []     1811-08-28 M 3 1859-03-03 0 0 0 0 0 0 0
P000024 Calvin Paige Calvin Paige   Republican MA House 3 1913-04-07 1925-03-03 0 []     1848-05-20 M 7 1925-03-03 0 0 0 0 0 0 0
A000032 Charles Adams Charles Adams   Republican MA House 3 1859-12-05 1863-03-03 0 []     1807-08-18 M 3 1863-03-03 0 0 0 0 0 0 0
A000115 Charles Allen Charles Allen   Free Soil MA House 5 1849-12-03 1853-03-03 0 []     1797-08-09 M 3 1853-03-03 0 0 0 0 0 0 0
A000116 Charles Allen Charles Allen   Republican MA House 8 1885-12-07 1889-03-03 0 []     1848-04-15 M 3 1889-03-03 0 0 0 0 0 0 0
C000473 Charles Clason Charles Clason   Republican MA House 2 1937-01-05 1949-01-03 0 []     1890-09-03 M 7 1949-01-03 0 0 0 0 0 0 0
D000213 Charles Delano Charles Delano   Republican MA House 10 1859-12-05 1863-03-03 0 []     1820-06-24 M 3 1863-03-03 0 0 0 0 0 0 0
G000169 Charles Gifford Charles Gifford   Republican MA House 9 1921-04-11 1949-01-03 0 []     1871-03-15 M 15 1949-01-03 0 0 0 0 0 0 0
H000907 Charles Hudson Charles Hudson   Whig MA House 5 1841-05-31 1849-03-03 0 []     1795-11-14 M 5 1849-03-03 0 0 0 0 0 0 0
R000037 Charles Randall Charles Randall   Republican MA House 13 1889-12-02 1895-03-03 0 []     1824-02-20 M 4 1895-03-03 0 0 0 0 0 0 0
S000742 Charles Sprague Charles Sprague   Republican MA House 11 1897-03-15 1901-03-03 0 []     1857-06-10 M 3 1901-03-03 0 0 0 0 0 0 0
S000877 Charles Stevens Charles Stevens   Republican MA House 10 1873-12-01 1875-03-03 0 []     1816-08-09 M 2 1875-03-03 0 0 0 0 0 0 0
S001068 Charles Sumner Charles Sumner   Liberal Republican MA Senate   1851-12-01 1875-03-03 0 []     1811-01-06 M 5 1875-03-03 0 0 0 0 0 0 0
T000195 Charles Thompson Charles Thompson   Democrat MA House 6 1875-12-06 1877-03-03 0 []     1827-07-30 M 2 1877-03-03 0 0 0 0 0 0 0
T000287 Charles Tirrell Charles Tirrell   Republican MA House 4 1901-12-02 1911-03-03 0 []     1844-12-10 M 6 1911-03-03 0 0 0 0 0 0 0
T000352 Charles Train Charles Train   Republican MA House 8 1859-12-05 1863-03-03 0 []     1817-10-18 M 3 1863-03-03 0 0 0 0 0 0 0
T000416 Charles Turner Charles Turner   Republican MA House 7 1809-05-22 1813-03-03 0 []     1760-06-20 M 3 1813-03-03 0 0 0 0 0 0 0
U000006 Charles Underhill Charles Underhill   Republican MA House 9 1921-04-11 1933-03-03 0 []     1867-07-20 M 7 1933-03-03 0 0 0 0 0 0 0
U000021 Charles Upham Charles Upham   Whig MA House 6 1853-12-05 1855-03-03 0 []     1802-05-04 M 2 1855-03-03 0 0 0 0 0 0 0
W000171 Charles Washburn Charles Washburn   Republican MA House 3 1905-12-04 1911-03-03 0 []     1857-01-28 M 4 1911-03-03 0 0 0 0 0 0 0
K000280 Chauncey Knapp Chauncey Knapp   Republican MA House 8 1855-12-03 1859-03-03 0 []     1809-02-26 M 3 1859-03-03 0 0 0 0 0 0 0
A000226 Chester Atkins Chester Atkins   Democrat MA House 5 1985-01-03 1993-01-03 0 [] 00034   1948-04-14 M 5 1993-01-03 0 0 38 0 0 0 0
C000305 Chester Chapin Chester Chapin   Democrat MA House 11 1875-12-06 1877-03-03 0 []     1798-12-16 M 2 1877-03-03 0 0 0 0 0 0 0
H000548 Christian Herter Christian Herter   Republican MA House 10 1943-01-06 1953-01-03 0 []     1895-03-28 M 6 1953-01-03 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
E000225 Constantine Esty Constantine Esty   Republican MA House 7 1871-03-04 1873-03-03 0 []     1824-12-26 M 2 1873-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
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
G000274 Daniel Gooch Daniel Gooch   Republican MA House 5 1857-12-07 1875-03-03 0 []     1820-01-08 M 10 1875-03-03 0 0 0 0 0 0 0
I000009 Daniel Ilsley Daniel Ilsley   Republican MA House 15 1807-10-26 1809-03-03 0 []     1740-05-30 M 2 1809-03-03 0 0 0 0 0 0 0
K000198 Daniel King Daniel King   Whig MA House 2 1843-12-04 1851-03-03 0 []     1801-01-08 M 5 1851-03-03 0 0 0 0 0 0 0
W000238 Daniel Webster Daniel Webster   Whig MA Senate   1813-05-24 1850-07-22 0 []     1782-01-18 M 7 1850-07-22 4 0 0 0 0 0 0
C000545 David Cobb David Cobb     MA House -1 1793-12-02 1795-03-03 0 []     1748-09-14 M 2 1795-03-03 0 0 0 0 0 0 0
W000097 David Walsh David Walsh   Democrat MA Senate   1919-05-19 1947-01-03 0 []     1872-11-11 M 5 1947-01-03 0 0 0 0 0 0 0
N000097 Donald Nicholson Donald Nicholson   Republican MA House 9 1947-01-03 1959-01-03 0 []     1888-08-11 M 7 1959-01-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
S000956 Eben Stone Eben Stone   Republican MA House 7 1881-12-05 1887-03-03 0 []     1822-08-03 M 4 1887-03-03 0 0 0 0 0 0 0
H000653 Ebenezer Hoar Ebenezer Hoar   Republican MA House 7 1873-12-01 1875-03-03 0 []     1816-02-21 M 2 1875-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
S000215 Ebenezer Seaver Ebenezer Seaver   Republican MA House 13 1803-10-17 1813-03-03 0 []     1763-07-05 M 6 1813-03-03 0 0 0 0 0 0 0
R000392 Edith Rogers Edith Rogers   Republican MA House 5 1925-12-07 1961-01-03 0 []     1881-03-19 F 19 1961-01-03 0 0 0 0 0 0 0
B000600 Edward Boland Edward Boland   Democrat MA House 2 1953-01-03 1989-01-03 0 [] 00104   1911-10-01 M 19 1989-01-03 0 0 178 0 0 0 0
B000871 Edward Brooke Edward Brooke   Republican MA Senate   1967-01-10 1979-01-03 0 [] 01292   1919-10-26 M 3 1979-01-03 0 0 120 0 0 0 0
B001119 Edward Burnett Edward Burnett   Democrat MA House 9 1887-12-05 1889-03-03 0 []     1849-03-16 M 2 1889-03-03 0 0 0 0 0 0 0
D000319 Edward Dickinson Edward Dickinson   Whig MA House 10 1853-12-05 1855-03-03 0 []     1803-01-01 M 2 1855-03-03 0 0 0 0 0 0 0
D000477 Edward Dowse Edward Dowse   Republican MA House 13 1819-12-06 1821-03-03 0 []     1756-10-22 M 2 1821-03-03 0 0 0 0 0 0 0
E000264 Edward Everett Edward Everett   Whig MA Senate   1825-12-05 1855-03-03 0 []     1794-04-11 M 6 1855-03-03 0 0 0 0 0 0 0
G000221 Edward Gilmore Edward Gilmore   Democrat MA House 14 1913-04-07 1915-03-03 0 []     1867-01-04 M 2 1915-03-03 0 0 0 0 0 0 0
H000386 Edward Hayden Edward Hayden   Republican MA House 5 1885-12-07 1889-03-03 0 []     1833-12-27 M 3 1889-03-03 0 0 0 0 0 0 0
M000133 Edward Markey Edward J. Markey Ed Democrat MA Senate   1975-01-14 2027-01-03 1 ["H6MA07101", "S4MA00028"] 00735 S369 1946-07-11 M 9   0 1900 1253 12619 4777645 6694335 1874519
K000105 Edward Kennedy Edward Kennedy Ted Democrat MA Senate   1962-11-07 2009-08-25 0 ["S6MA00015"] 01377 S055 1932-02-22 M 8 2009-08-25 0 3973 1200 3552 4500 0 0
L000350 Edward Little Edward Little   Democrat MA House 9 1851-12-01 1853-03-03 0 []     1791-11-07 M 2 1853-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

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