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

1,965 rows where chamber = "Senate" sorted by full_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: gender, terms_count, first_served (date), last_served (date), birthday (date), served_until (date), fec_ids (array)

state >30

is_current 2

  • 0 1,865
  • 1 100

chamber 1

  • Senate · 1,965 ✖
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
B001133 Aaron Burr Aaron Burr   Republican NY Senate   1791-10-24 1797-03-03 0 []     1756-02-06 M 2 1797-03-03 0 0 0 0 0
C000852 Aaron Cragin Aaron Cragin   Republican NH Senate   1855-12-03 1877-03-03 0 []     1821-02-03 M 4 1877-03-03 0 0 0 0 0
K000246 Aaron Kitchell Aaron Kitchell   Republican NJ Senate   1791-10-24 1809-12-31 0 []     1744-07-10 M 4 1809-12-31 0 0 0 0 0
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
S000065 Aaron Sargent Aaron Sargent   Republican CA Senate   1861-07-04 1879-03-03 0 []     1827-09-28 M 4 1879-03-03 0 0 0 0 0
G000171 Abijah Gilbert Abijah Gilbert   Republican FL Senate   1849-12-03 1875-03-03 0 []     1806-06-18 M 5 1875-03-03 0 0 0 0 0
L000011 Abner Lacock Abner Lacock   Republican PA Senate   1811-11-04 1819-03-03 0 []     1770-07-09 M 2 1819-03-03 0 0 0 0 0
B000084 Abraham Baldwin Abraham Baldwin   Republican GA Senate   1789-03-04 1807-03-04 0 []     1754-11-22 M 4 1807-03-04 0 0 0 0 0
R000191 Abraham Ribicoff Abraham Ribicoff   Democrat CT Senate   1949-01-03 1981-01-03 0 [] 01422   1910-04-09 M 6 1981-01-03 0 0 233 0 0
V000083 Abraham Venable Abraham Venable   Republican VA Senate   1791-10-24 1805-03-03 0 []     1758-11-20 M 3 1805-03-03 0 0 0 0 0
W000486 Abram Williams Abram Williams   Republican CA Senate   1886-01-01 1887-03-03 0 []     1832-02-03 M 1 1887-03-03 0 0 0 0 0
R000317 Absalom Robertson Absalom Robertson   Democrat VA Senate   1933-03-09 1967-01-03 0 []     1887-05-27 M 6 1967-01-03 0 0 0 0 0
S001150 Adam Schiff Adam B. Schiff   Democrat CA Senate   2001-01-03 2031-01-03 1 ["H0CA27085", "S4CA00555"] 01635 S427 1960-06-22 M 6   3 1550 344 14656 4888475
F000298 Addison Foster Addison Foster   Republican WA Senate   1899-12-04 1905-03-03 0 []     1837-01-28 M 2 1905-03-03 0 0 0 0 0
A000172 Adelbert Ames Adelbert Ames   Republican MS Senate   1870-01-01 1875-03-03 0 []     1835-10-31 M 1 1875-03-03 0 0 0 0 0
S000890 Adlai Stevenson Adlai Stevenson   Democrat IL Senate   1970-01-01 1981-01-03 0 [] 01441   1930-10-10 M 2 1981-01-03 0 0 148 0 0
W000261 Adonijah Welch Adonijah Welch   Republican FL Senate   1868-01-01 1869-03-03 0 []     1821-04-12 M 1 1869-03-03 0 0 0 0 0
F000457 Alan Franken Al Franken Al Democrat MN Senate   2009-07-07 2018-01-02 0 ["S8MN00438"] 01969 S332 1951-05-21 M 2 2018-01-02 0 517 162 2449 3293865
A000383 Alan Armstrong Alan Armstrong   Republican OK Senate   2026-03-24 2027-01-03 1 []     1962-07-11 M 1   0 0 0 0 0
B000436 Alan Bible Alan Bible   Democrat NV Senate   1954-12-02 1974-12-17 0 [] 01283   1909-11-20 M 4 1974-12-17 0 0 33 0 0
C000877 Alan Cranston Alan Cranston   Democrat CA Senate   1969-01-03 1993-01-03 0 [] 01311 S023 1914-06-19 M 5 1993-01-03 0 0 942 0 0
D000366 Alan Dixon Alan Dixon   Democrat IL Senate   1981-01-05 1993-01-03 0 [] 01317 S149 1927-07-07 M 3 1993-01-03 0 0 184 0 0
S000429 Alan Simpson Alan Simpson   Republican WY Senate   1979-01-15 1997-01-03 0 [] 01435 S142 1931-09-02 M 4 1997-01-03 0 374 177 0 0
B000145 Alben Barkley Alben Barkley   Democrat KY Senate   1913-04-07 1956-04-30 0 []     1877-11-24 M 8 1956-04-30 0 0 0 0 0
B000429 Albert Beveridge Albert Beveridge   Republican IN Senate   1899-12-04 1911-03-03 0 []     1862-10-06 M 3 1911-03-03 0 0 0 0 0
B000900 Albert Brown Albert Brown   Democrat MS Senate   1839-12-02 1861-12-31 0 []     1813-05-31 M 4 1861-12-31 0 0 0 0 0
C000290 Albert Chandler Albert Chandler Happy Democrat KY Senate   1939-10-10 1945-12-31 0 []     1898-07-14 M 2 1945-12-31 0 0 0 0 0
C000988 Albert Cummins Albert Cummins   Republican IA Senate   1908-11-24 1926-07-30 0 []     1850-02-15 M 4 1926-07-30 0 0 0 0 0
F000011 Albert Fall Albert Fall   Republican NM Senate   1912-03-27 1921-03-04 0 []     1861-11-26 M 2 1921-03-04 0 0 0 0 0
G000320 Albert Gore Albert Gore   Democrat TN Senate   1939-01-03 1971-01-03 0 []     1907-12-26 M 6 1971-01-03 0 0 0 0 0
G000321 Albert Gore Albert Gore   Democrat TN Senate   1977-01-04 1993-01-02 0 [] 00449 S170 1948-03-31 M 3 1993-01-02 0 0 222 0 0
G000424 Albert Greene Albert Greene   Whig RI Senate   1845-12-01 1851-03-03 0 []     1792-04-15 M 2 1851-03-03 0 0 0 0 0
H000365 Albert Hawkes Albert Hawkes   Republican NJ Senate   1943-01-06 1949-01-03 0 []     1878-11-20 M 2 1949-01-03 0 0 0 0 0
H000770 Albert Hopkins Albert Hopkins   Republican IL Senate   1885-12-07 1909-03-03 0 []     1846-08-15 M 5 1909-03-03 0 0 0 0 0
P000079 Albion Parris Albion Parris   Jackson ME Senate   1815-12-04 1829-03-03 0 []     1788-01-19 M 3 1829-03-03 0 0 0 0 0
P000145 Alejandro Padilla Alex Padilla Alex Democrat CA Senate   2021-01-20 2029-01-03 1 ["S2CA00955"]   S413 1973-03-22 M 2   0 843 260 2427 2811407
A000181 Alexander Anderson Alexander Anderson   Democrat TN Senate   1840-01-01 1841-03-03 0 []     1794-11-10 M 1 1841-03-03 0 0 0 0 0
B000183 Alexander Barrow Alexander Barrow   Whig LA Senate   1841-05-31 1847-03-03 0 []     1801-03-27 M 2 1847-03-03 0 0 0 0 0
B000187 Alexander Barry Alexander Barry   Republican OR Senate   1938-01-01 1939-01-03 0 []     1892-08-23 M 1 1939-01-03 0 0 0 0 0
B001030 Alexander Buckner Alexander Buckner   Jackson MO Senate   1831-12-05 1833-12-31 0 []       M 1 1833-12-31 0 0 0 0 0
C000027 Alexander Caldwell Alexander Caldwell   Republican KS Senate   1871-03-04 1873-12-31 0 []     1830-03-01 M 1 1873-12-31 0 0 0 0 0
C000076 Alexander Campbell Alexander Campbell   Republican OH Senate   1809-05-22 1813-03-03 0 []       M 1 1813-03-03 0 0 0 0 0
C000254 Alexander Cattell Alexander Cattell   Republican NJ Senate   1866-01-01 1871-03-03 0 []     1816-02-12 M 1 1871-03-03 0 0 0 0 0
C000478 Alexander Clay Alexander Clay   Democrat GA Senate   1897-03-15 1911-03-03 0 []     1853-09-25 M 3 1911-03-03 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
M000166 Alexander Martin Alexander Martin   Republican NC Senate   1793-12-02 1799-03-03 0 []       M 2 1799-03-03 0 0 0 0 0
M000408 Alexander McDonald Alexander McDonald   Republican AR Senate   1868-01-01 1871-03-03 0 []     1832-04-10 M 1 1871-03-03 0 0 0 0 0
M001050 Alexander Mouton Alexander Mouton   Democrat LA Senate   1837-09-04 1843-03-03 0 []     1804-11-19 M 2 1843-03-03 0 0 0 0 0
P000436 Alexander Porter Alexander Porter   Anti-Jacksonian LA Senate   1833-12-02 1837-03-03 0 []     1785-06-24 M 1 1837-03-03 0 0 0 0 0
R000026 Alexander Ramsey Alexander Ramsey   Republican MN Senate   1843-12-04 1875-03-03 0 []     1815-09-08 M 6 1875-03-03 0 0 0 0 0
W000465 Alexander Wiley Alexander Wiley   Republican WI Senate   1939-01-03 1963-01-03 0 []     1884-05-26 M 5 1963-01-03 0 0 0 0 0
D000018 Alfonse D’Amato Alfonse D’Amato   Republican NY Senate   1981-01-05 1999-01-03 0 [] 01313 S147 1937-08-01 M 4 1999-01-03 0 777 619 0 0
B000386 Alfred Benson Alfred Benson   Republican KS Senate   1906-06-11 1907-01-23 0 []     1843-07-15 M 1 1907-01-23 0 0 0 0 0
C000647 Alfred Colquitt Alfred Colquitt   Democrat GA Senate   1853-12-05 1895-03-03 0 []     1824-04-20 M 8 1895-03-03 0 0 0 0 0
C001023 Alfred Cuthbert Alfred Cuthbert   Democrat GA Senate   1813-05-24 1843-03-03 0 []     1785-12-23 M 6 1843-03-03 0 0 0 0 0
I000049 Alfred Iverson Alfred Iverson   Democrat GA Senate   1847-12-06 1861-03-03 0 []     1798-12-03 M 3 1861-03-03 0 0 0 0 0
K000255 Alfred Kittredge Alfred Kittredge   Republican SD Senate   1901-12-02 1909-03-03 0 []     1861-03-28 M 2 1909-03-03 0 0 0 0 0
N000096 Alfred Nicholson Alfred Nicholson   Democrat TN Senate   1840-01-01 1861-12-31 0 []     1808-08-31 M 4 1861-12-31 0 0 0 0 0
R000099 Alfred Reames Alfred Reames   Democrat OR Senate   1938-02-01 1939-01-03 0 []     1870-02-05 M 1 1939-01-03 0 0 0 0 0
P000010 Algernon Paddock Algernon Paddock   Republican NE Senate   1875-12-06 1893-03-03 0 []     1830-11-09 M 4 1893-03-03 0 0 0 0 0
M000056 Allan Magruder Allan Magruder   Republican LA Senate   1812-01-01 1813-03-03 0 []       M 1 1813-03-03 0 0 0 0 0
C000130 Allen Caperton Allen Caperton   Democrat WV Senate   1875-12-06 1877-03-03 0 []     1810-11-21 M 1 1877-03-03 0 0 0 0 0
E000112 Allen Ellender Allen Ellender   Democrat LA Senate   1937-01-05 1972-07-27 0 []     1890-09-24 M 6 1972-07-27 0 0 0 0 0
T000251 Allen Thurman Allen Thurman   Democrat OH Senate   1845-12-01 1881-03-03 0 []     1813-11-13 M 7 1881-03-03 0 0 0 0 0
M000859 Almer Monroney Almer Monroney   Democrat OK Senate   1939-01-03 1969-01-03 0 []     1902-03-02 M 6 1969-01-03 0 0 0 0 0
E000046 Alonzo Edgerton Alonzo Edgerton   Republican MN Senate   1881-12-05 1881-12-31 0 []     1827-06-07 M 1 1881-12-31 0 0 0 0 0
F000063 Alpheus Felch Alpheus Felch   Democrat MI Senate   1847-12-06 1853-03-03 0 []     1804-09-28 M 2 1853-03-03 0 0 0 0 0
A000028 Alva Adams Alva Adams   Democrat CO Senate   1923-12-03 1941-12-31 0 []     1875-10-29 M 4 1941-12-31 0 0 0 0 0
L000510 Alva Lumpkin Alva Lumpkin   Democrat SC Senate   1941-07-17 1941-12-31 0 []     1886-11-13 M 1 1941-12-31 0 0 0 0 0
D000410 Alvin Donahey Alvin Donahey   Democrat OH Senate   1935-01-03 1941-01-03 0 []     1873-07-07 M 2 1941-01-03 0 0 0 0 0
S000076 Alvin Saunders Alvin Saunders   Republican NE Senate   1877-10-15 1883-03-03 0 []     1817-07-12 M 2 1883-03-03 0 0 0 0 0
B001130 Ambrose Burnside Ambrose Burnside   Republican RI Senate   1875-12-06 1881-03-03 0 []     1824-05-23 M 2 1881-03-03 0 0 0 0 0
S000256 Ambrose Sevier Ambrose Sevier   Democrat AR Senate   1828-02-23 1848-03-15 0 []     1801-11-04 M 4 1848-03-15 0 0 0 0 0
N000162 Amos Nourse Amos Nourse   Republican ME Senate   1857-12-07 1857-12-31 0 []     1794-12-17 M 1 1857-12-31 0 0 0 0 0
K000367 Amy Klobuchar Amy Klobuchar   Democrat MN Senate   2007-01-04 2031-01-03 1 ["S6MN00267"] 01826 S311 1960-05-25 F 5   0 1574 979 6746 6467562
B001173 Andrew Butler Andrew Butler   Democrat SC Senate   1846-01-01 1857-12-31 0 []     1796-11-18 M 2 1857-12-31 0 0 0 0 0
G000442 Andrew Gregg Andrew Gregg   Republican PA Senate   1791-10-24 1813-03-03 0 []     1755-06-10 M 4 1813-03-03 0 0 0 0 0
H000821 Andrew Houston Andrew Houston   Democrat TX Senate   1941-04-21 1941-12-31 0 []     1854-06-21 M 1 1941-12-31 0 0 0 0 0
J000005 Andrew Jackson Andrew Jackson   Democratic Republican TN Senate   1795-12-07 1825-12-31 0 []     1767-03-15 M 6 1825-12-31 0 0 0 0 0
J000116 Andrew Johnson Andrew Johnson   Democrat TN Senate   1843-12-04 1875-12-31 0 []     1808-12-29 M 6 1875-12-31 0 0 0 0 0
M000891 Andrew Moore Andrew Moore   Republican VA Senate   1789-03-04 1809-03-03 0 []       M 4 1809-03-03 0 0 0 0 0
S000138 Andrew Schoeppel Andrew Schoeppel   Republican KS Senate   1949-01-03 1962-01-21 0 []     1894-11-23 M 3 1962-01-21 0 0 0 0 0
J000210 Andrieus Jones Andrieus Jones   Democrat NM Senate   1917-04-02 1927-12-20 0 []     1862-05-16 M 2 1927-12-20 0 0 0 0 0
K000394 Andy Kim Andy Kim   Democrat NJ Senate   2019-01-03 2031-01-03 1 ["H8NJ03206", "S4NJ00466"]   S426 1982-07-12 M 3   0 218 119 3429 12597254
A000382 Angela Alsobrooks Angela D. Alsobrooks   Democrat MD Senate   2025-01-03 2031-01-03 1 ["S4MD00327"]   S428 1971-02-23 F 2   0 50 29 789 34339278
C000064 Angus Cameron Angus Cameron   Republican WI Senate   1875-12-06 1885-03-03 0 []     1826-07-04 M 2 1885-03-03 0 0 0 0 0
K000383 Angus King Angus S. King, Jr.   Independent ME Senate   2013-01-03 2031-01-03 1 ["S2ME00109"] 02185 S363 1944-03-31 M 4   125 665 233 4907 9000844
M000542 Anselm McLaurin Anselm McLaurin   Democrat MS Senate   1894-01-01 1909-12-22 0 []     1848-03-26 M 3 1909-12-22 0 0 0 0 0
H000577 Anthony Higgins Anthony Higgins   Republican DE Senate   1889-12-02 1895-03-03 0 []     1840-10-01 M 2 1895-03-03 0 0 0 0 0
K000103 Anthony Kennedy Anthony Kennedy   Unionist MD Senate   1857-12-07 1863-03-03 0 []     1810-12-21 M 2 1863-03-03 0 0 0 0 0
D000367 Archibald Dixon Archibald Dixon   Whig KY Senate   1852-01-01 1855-03-03 0 []     1802-04-02 M 1 1855-03-03 0 0 0 0 0
S000709 Arlen Specter Arlen Specter   Democrat PA Senate   1981-01-05 2011-01-03 0 ["S6PA00100"] 01437 S161 1930-02-12 M 6 2011-01-03 0 2725 945 3978 2492417
M000213 Armistead Mason Armistead Mason   Republican VA Senate   1816-01-01 1817-03-03 0 []     1787-08-04 M 1 1817-03-03 0 0 0 0 0
N000010 Arnold Naudain Arnold Naudain     DE Senate   1830-01-01 1837-03-03 0 []     1790-01-06 M 2 1837-03-03 0 0 0 0 0
B000030 Arthur Bagby Arthur Bagby   Democrat AL Senate   1841-05-31 1849-03-03 0 []       M 2 1849-03-03 0 0 0 0 0
B000638 Arthur Boreman Arthur Boreman   Republican WV Senate   1869-03-04 1875-03-03 0 []     1823-07-24 M 2 1875-03-03 0 0 0 0 0
B000902 Arthur Brown Arthur Brown   Republican UT Senate   1896-01-01 1897-03-03 0 []     1843-03-08 M 1 1897-03-03 0 0 0 0 0
C000133 Arthur Capper Arthur Capper   Republican KS Senate   1919-05-19 1949-01-03 0 []     1865-07-14 M 6 1949-01-03 0 0 0 0 0
G000326 Arthur Gorman Arthur Gorman   Democrat MD Senate   1881-12-05 1907-03-03 0 []     1839-03-11 M 5 1907-03-03 0 0 0 0 0
G000340 Arthur Gould Arthur Gould   Republican ME Senate   1926-11-30 1931-03-03 0 []     1857-03-16 M 1 1931-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,
    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);
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);