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,060 rows where is_current = 0 and state = "PA" sorted by full_name

✎ View and edit SQL

This data as json, CSV (advanced)

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

chamber 2

state 1

  • PA · 1,060 ✖

is_current 1

  • - · 1,060 ✖
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
K000327 Aaron Kreider Aaron Kreider   Republican PA House 18 1913-04-07 1923-03-03 0 []     1863-06-26 M 6 1923-03-03 0 0 0 0 0 0 0
L000524 Aaron Lyle Aaron Lyle   Republican PA House 12 1809-05-22 1817-03-03 0 []     1759-11-17 M 5 1817-03-03 0 0 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 0 0
B000142 Abraham Barker Abraham Barker   Republican PA House 17 1865-12-04 1867-03-03 0 []     1816-03-30 M 2 1867-03-03 0 0 0 0 0 0 0
K000052 Abraham Keister Abraham Keister   Republican PA House 22 1913-04-07 1917-03-03 0 []     1852-09-10 M 3 1917-03-03 0 0 0 0 0 0 0
M000474 Abraham McIlvaine Abraham McIlvaine   Whig PA House 7 1843-12-04 1849-03-03 0 []     1804-08-14 M 4 1849-03-03 0 0 0 0 0 0 0
S000509 Abraham Smith Abraham Smith   Republican PA House 9 1873-12-01 1885-03-03 0 []     1815-03-07 M 7 1885-03-03 0 0 0 0 0 0 0
G000242 Adam Glossbrenner Adam Glossbrenner   Democrat PA House 15 1865-12-04 1869-03-03 0 []     1810-08-31 M 3 1869-03-03 0 0 0 0 0 0 0
K000192 Adam King Adam King   Jackson PA House 10 1827-12-03 1833-03-03 0 []     1783-01-20 M 4 1833-03-03 0 0 0 0 0 0 0
S000264 Adam Seybert Adam Seybert   Republican PA House 1 1809-05-22 1819-03-03 0 []     1773-05-16 M 6 1819-03-03 0 0 0 0 0 0 0
W000776 Adam Wyant Adam Wyant   Republican PA House 31 1921-04-11 1933-03-03 0 []     1869-09-15 M 7 1933-03-03 0 0 0 0 0 0 0
T000036 Adamson Tannehill Adamson Tannehill   Republican PA House 14 1813-05-24 1815-03-03 0 []     1750-05-23 M 2 1815-03-03 0 0 0 0 0 0 0
W000688 Alan Wood Alan Wood   Republican PA House 7 1875-12-06 1877-03-03 0 []     1834-07-06 M 2 1877-03-03 0 0 0 0 0 0 0
E000087 Albert Egbert Albert Egbert   Democrat PA House 27 1875-12-06 1877-03-03 0 []     1828-04-13 M 2 1877-03-03 0 0 0 0 0 0 0
G000020 Albert Gallatin Albert Gallatin   Republican PA House 12 1795-12-07 1801-03-03 0 []     1761-01-29 M 4 1801-03-03 0 0 0 0 0 0 0
H000769 Albert Hopkins Albert Hopkins   Republican PA House 16 1891-12-07 1895-03-03 0 []     1837-09-15 M 3 1895-03-03 0 0 0 0 0 0 0
J000115 Albert Johnson Albert Johnson   Republican PA House 23 1963-01-09 1977-01-03 0 [] 00597   1906-04-17 M 8 1977-01-03 0 0 86 0 0 0 0
M000123 Albert Marchand Albert Marchand   Democrat PA House 19 1839-12-02 1843-03-03 0 []     1811-02-27 M 3 1843-03-03 0 0 0 0 0 0 0
R000546 Albert Rutherford Albert Rutherford   Republican PA House 15 1937-01-05 1943-01-03 0 []     1879-01-03 M 4 1943-01-03 0 0 0 0 0 0 0
V000077 Albert Vaughn Albert Vaughn   Republican PA House 8 1951-01-03 1953-01-03 0 []     1894-10-09 M 2 1953-01-03 0 0 0 0 0 0 0
M000141 Alem Marr Alem Marr   Jackson PA House 9 1829-12-07 1831-03-03 0 []     1787-06-18 M 2 1831-03-03 0 0 0 0 0 0 0
B000465 Alexander Billmeyer Alexander Billmeyer   Democrat PA House 17 1901-12-02 1903-03-03 0 []     1841-01-07 M 2 1903-03-03 0 0 0 0 0 0 0
C000561 Alexander Cochran Alexander Cochran   Democrat PA House 23 1875-12-06 1877-03-03 0 []     1846-03-20 M 2 1877-03-03 0 0 0 0 0 0 0
C000593 Alexander Coffroth Alexander Coffroth   Democrat PA House 17 1863-12-07 1881-03-03 0 []     1828-05-18 M 10 1881-03-03 0 0 0 0 0 0 0
C000854 Alexander Craig Alexander Craig   Democrat PA House 24 1891-12-07 1893-03-03 0 []     1828-02-21 M 2 1893-03-03 0 0 0 0 0 0 0
I000032 Alexander Irvin Alexander Irvin   Whig PA House 24 1847-12-06 1849-03-03 0 []     1800-01-18 M 2 1849-03-03 0 0 0 0 0 0 0
M000417 Alexander McDowell Alexander McDowell   Republican PA House -1 1893-08-07 1895-03-03 0 []     1845-03-04 M 2 1895-03-03 0 0 0 0 0 0 0
O000045 Alexander Ogle Alexander Ogle   Republican PA House 8 1817-12-01 1819-03-03 0 []     1766-08-10 M 2 1819-03-03 0 0 0 0 0 0 0
P000035 Alexander Palmer Alexander Palmer   Democrat PA House 26 1909-03-15 1915-03-03 0 []     1872-05-04 M 4 1915-03-03 0 0 0 0 0 0 0
T000063 Alexander Taylor Alexander Taylor   Republican PA House 21 1873-12-01 1875-03-03 0 []     1815-03-22 M 2 1875-03-03 0 0 0 0 0 0 0
T000227 Alexander Thomson Alexander Thomson   Jackson PA House 13 1823-12-01 1827-03-03 0 []     1788-01-12 M 3 1827-03-03 0 0 0 0 0 0 0
W000354 Alexander White Alexander White   Republican PA House 25 1885-12-07 1887-03-03 0 []     1833-12-12 M 2 1887-03-03 0 0 0 0 0 0 0
G000073 Alfred Garner Alfred Garner   Republican PA House 12 1909-03-15 1911-03-03 0 []     1873-03-04 M 2 1911-03-03 0 0 0 0 0 0 0
G000220 Alfred Gilmore Alfred Gilmore   Democrat PA House 24 1849-12-03 1853-03-03 0 []     1812-06-09 M 3 1853-03-03 0 0 0 0 0 0 0
H000215 Alfred Harmer Alfred Harmer   Republican PA House 5 1871-03-04 1901-03-03 0 []     1825-08-08 M 16 1901-03-03 0 0 0 0 0 0 0
W000040 Alfred Waldron Alfred Waldron   Republican PA House 3 1933-03-09 1935-01-03 0 []     1865-09-21 M 2 1935-01-03 0 0 0 0 0 0 0
C000745 Allen Cooper Allen Cooper   Republican PA House 23 1903-11-09 1911-03-03 0 []     1862-06-16 M 5 1911-03-03 0 0 0 0 0 0 0
E000208 Allen Ertel Allen Ertel   Democrat PA House 17 1977-01-04 1983-01-03 0 [] 00352   1937-11-07 M 4 1983-01-03 0 0 57 0 0 0 0
W000355 Allison White Allison White   Democrat PA House 15 1857-12-07 1859-03-03 0 []     1816-12-21 M 2 1859-03-03 0 0 0 0 0 0 0
S001162 Allyson Schwartz Allyson Y. Schwartz   Democrat PA House 13 2005-01-04 2015-01-03 0 ["H4PA13124", "S8PA00163"] 01798   1948-10-03 F 6 2015-01-03 0 381 75 7473 2600319 330 0
R000090 Almon Read Almon Read   Democrat PA House 12 1841-05-31 1845-03-03 0 []     1790-06-12 M 3 1845-03-03 0 0 0 0 0 0 0
B001165 Alvin Bush Alvin Bush   Republican PA House 17 1951-01-03 1961-01-03 0 []     1893-06-04 M 6 1961-01-03 0 0 0 0 0 0 0
E000232 Alvin Evans Alvin Evans   Republican PA House 19 1901-12-02 1905-03-03 0 []     1845-10-04 M 3 1905-03-03 0 0 0 0 0 0 0
G000533 Amos Gustine Amos Gustine   Democrat PA House 13 1841-05-31 1843-03-03 0 []       M 2 1843-03-03 0 0 0 0 0 0 0
M001126 Amos Myers Amos Myers   Republican PA House 20 1863-12-07 1865-03-03 0 []     1824-04-23 M 2 1865-03-03 0 0 0 0 0 0 0
S000483 Amos Slaymaker Amos Slaymaker   Federalist PA House 3 1813-05-24 1815-03-03 0 []     1755-03-11 M 2 1815-03-03 0 0 0 0 0 0 0
W000109 Anderson Walters Anderson Walters   Republican PA House 20 1913-04-07 1927-03-04 0 []     1862-05-18 M 8 1927-03-04 0 0 0 0 0 0 0
B000133 Andrew Barchfeld Andrew Barchfeld   Republican PA House 32 1905-12-04 1917-03-03 0 []     1863-05-18 M 7 1917-03-03 0 0 0 0 0 0 0
B000286 Andrew Beaumont Andrew Beaumont   Jackson PA House 15 1833-12-02 1837-03-03 0 []     1790-01-24 M 3 1837-03-03 0 0 0 0 0 0 0
B000583 Andrew Boden Andrew Boden   Republican PA House 5 1817-12-01 1821-03-03 0 []       M 3 1821-03-03 0 0 0 0 0 0 0
B000855 Andrew Brodbeck Andrew Brodbeck   Democrat PA House 20 1913-04-07 1919-03-03 0 []     1860-04-11 M 4 1919-03-03 0 0 0 0 0 0 0
B001000 Andrew Buchanan Andrew Buchanan   Democrat PA House 20 1835-12-07 1839-03-03 0 []     1780-04-08 M 3 1839-03-03 0 0 0 0 0 0 0
C001004 Andrew Curtin Andrew Curtin   Democrat PA House 20 1881-12-05 1887-03-03 0 []     1817-04-22 M 4 1887-03-03 0 0 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 0 0
O000046 Andrew Ogle Andrew Ogle   Whig PA House 18 1849-12-03 1851-03-03 0 []     1822-03-25 M 2 1851-03-03 0 0 0 0 0 0 0
P000055 Andrew Parker Andrew Parker   Democrat PA House 17 1851-12-01 1853-03-03 0 []     1805-05-21 M 2 1853-03-03 0 0 0 0 0 0 0
S000899 Andrew Stewart Andrew Stewart   Whig PA House 18 1821-12-03 1849-03-03 0 []     1791-06-11 M 15 1849-03-03 0 0 0 0 0 0 0
S000900 Andrew Stewart Andrew Stewart   Republican PA House 24 1891-12-07 1893-03-03 0 []     1836-04-06 M 2 1893-03-03 0 0 0 0 0 0 0
C000259 Anthony Cavalcante Anthony Cavalcante   Democrat PA House 23 1949-01-03 1951-01-03 0 []     1897-02-06 M 2 1951-01-03 0 0 0 0 0 0 0
R000304 Anthony Roberts Anthony Roberts   Republican PA House 9 1855-12-03 1859-03-03 0 []     1803-10-29 M 3 1859-03-03 0 0 0 0 0 0 0
M000295 Archibald McAllister Archibald McAllister   Democrat PA House 17 1863-12-07 1865-03-03 0 []     1813-10-12 M 2 1865-03-03 0 0 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 859182 46205 25960
P000391 Arnold Plumer Arnold Plumer   Democrat PA House 25 1837-09-04 1843-03-03 0 []     1801-06-06 M 4 1843-03-03 0 0 0 0 0 0 0
B000230 Arthur Bates Arthur Bates   Republican PA House 25 1901-12-02 1913-03-03 0 []     1859-06-06 M 7 1913-03-03 0 0 0 0 0 0 0
D000288 Arthur Dewalt Arthur Dewalt   Democrat PA House 13 1915-12-06 1921-03-03 0 []     1854-10-11 M 4 1921-03-03 0 0 0 0 0 0 0
R000511 Arthur Rupley Arthur Rupley   Republican PA House -1 1913-04-07 1915-03-03 0 []     1868-11-13 M 2 1915-03-03 0 0 0 0 0 0 0
P000006 Asa Packer Asa Packer   Democrat PA House 13 1853-12-05 1857-03-03 0 []     1805-12-29 M 3 1857-03-03 0 0 0 0 0 0 0
G000095 Athelston Gaston Athelston Gaston   Democrat PA House 26 1899-12-04 1901-03-03 0 []     1838-04-24 M 2 1901-03-03 0 0 0 0 0 0 0
K000058 Augustine Kelley Augustine Kelley   Democrat PA House 21 1941-01-03 1959-01-03 0 []     1883-07-09 M 10 1959-01-03 0 0 0 0 0 0 0
D000506 Augustus Drum Augustus Drum   Democrat PA House 19 1853-12-05 1855-03-03 0 []     1815-11-26 M 2 1855-03-03 0 0 0 0 0 0 0
M001088 Austin Murphy Austin Murphy   Democrat PA House 20 1977-01-04 1995-01-03 0 [] 00841   1927-06-17 M 10 1995-01-03 0 4 142 0 0 0 0
B000445 Benjamin Bidlack Benjamin Bidlack   Democrat PA House 11 1841-05-31 1845-03-03 0 []     1804-09-08 M 3 1845-03-03 0 0 0 0 0 0 0
B000723 Benjamin Boyer Benjamin Boyer   Democrat PA House 6 1865-12-04 1869-03-03 0 []     1823-01-22 M 3 1869-03-03 0 0 0 0 0 0 0
F000230 Benjamin Focht Benjamin Focht   Republican PA House 18 1907-12-02 1939-01-03 0 []     1863-03-12 M 17 1939-01-03 0 0 0 0 0 0 0
G000259 Benjamin Golder Benjamin Golder   Republican PA House 4 1925-12-07 1933-03-03 0 []     1891-12-23 M 5 1933-03-03 0 0 0 0 0 0 0
J000045 Benjamin James Benjamin James   Republican PA House 7 1949-01-03 1959-01-03 0 []     1885-08-01 M 6 1959-01-03 0 0 0 0 0 0 0
J000060 Benjamin Jarrett Benjamin Jarrett   Republican PA House 20 1937-01-05 1943-01-03 0 []     1881-07-18 M 4 1943-01-03 0 0 0 0 0 0 0
J000281 Benjamin Junkin Benjamin Junkin   Republican PA House 16 1859-12-05 1861-03-03 0 []     1822-11-12 M 2 1861-03-03 0 0 0 0 0 0 0
M000683 Benjamin Meyers Benjamin Meyers   Democrat PA House 16 1871-03-04 1873-03-03 0 []     1833-07-06 M 2 1873-03-03 0 0 0 0 0 0 0
S000098 Benjamin Say Benjamin Say   Republican PA House 1 1807-10-26 1811-03-03 0 []     1755-08-28 M 3 1811-03-03 0 0 0 0 0 0 0
S001154 Bill Shuster Bill Shuster   Republican PA House 9 2001-05-17 2019-01-03 0 ["H2PA09035"] 01681   1961-01-10 M 10 2019-01-03 0 727 93 11227 6844251 349266 10861
M000336 Blair McClenachan Blair McClenachan   Republican PA House 2 1797-05-15 1799-03-03 0 []       M 2 1799-03-03 0 0 0 0 0 0 0
P000217 Boies Penrose Boies Penrose   Republican PA Senate   1897-03-15 1921-03-03 0 []     1860-11-01 M 5 1921-03-03 0 0 0 0 0 0 0
S000869 Bruce Sterling Bruce Sterling   Democrat PA House 23 1917-04-02 1919-03-03 0 []     1870-09-28 M 2 1919-03-03 0 0 0 0 0 0 0
T000068 Caleb Taylor Caleb Taylor   Republican PA House 5 1867-03-04 1871-03-03 0 []     1813-07-27 M 3 1871-03-03 0 0 0 0 0 0 0
G000185 Calvin Gilfillan Calvin Gilfillan   Republican PA House 20 1869-03-04 1871-03-03 0 []     1832-02-20 M 2 1871-03-03 0 0 0 0 0 0 0
H000682 Carl Hoffman Carl Hoffman   Republican PA House 23 1945-01-03 1947-01-03 0 []     1896-08-12 M 2 1947-01-03 0 0 0 0 0 0 0
C001007 Carlton Curtis Carlton Curtis   Republican PA House 19 1851-12-01 1875-03-03 0 []     1811-12-17 M 13 1875-03-03 0 0 0 0 0 0 0
K000032 Carroll Kearns Carroll Kearns   Republican PA House 24 1947-01-03 1963-01-03 0 []     1900-05-07 M 9 1963-01-03 0 0 0 0 0 0 0
F000043 Chaka Fattah Chaka Fattah   Democrat PA House 2 1995-01-04 2016-06-23 0 ["H2PA02055"] 00371   1956-11-21 M 11 2016-06-23 0 435 128 9738 1119219 490 0
H000046 Chapin Hall Chapin Hall   Republican PA House 24 1859-12-05 1861-03-03 0 []     1816-07-12 M 2 1861-03-03 0 0 0 0 0 0 0
F000361 Chapman Freeman Chapman Freeman   Republican PA House 1 1875-12-06 1879-03-03 0 []     1832-10-08 M 3 1879-03-03 0 0 0 0 0 0 0
A000077 Charles Albright Charles Albright   Republican PA House -1 1873-12-01 1875-03-03 0 []     1830-12-13 M 2 1875-03-03 0 0 0 0 0 0 0
B000135 Charles Barclay Charles Barclay   Republican PA House 21 1907-12-02 1911-03-03 0 []     1844-05-09 M 3 1911-03-03 0 0 0 0 0 0 0
B000165 Charles Barnitz Charles Barnitz   Anti Masonic PA House 11 1833-12-02 1835-03-03 0 []     1780-09-11 M 2 1835-03-03 0 0 0 0 0 0 0
B000439 Charles Biddle Charles Biddle   Democrat PA House 2 1861-07-04 1863-03-03 0 []     1819-04-30 M 2 1863-03-03 0 0 0 0 0 0 0
B000703 Charles Bowman Charles Bowman   Republican PA House 11 1911-04-04 1913-03-03 0 []     1852-11-14 M 2 1913-03-03 0 0 0 0 0 0 0
B000728 Charles Boyle Charles Boyle   Democrat PA House 21 1883-12-03 1887-03-03 0 []     1836-02-04 M 3 1887-03-03 0 0 0 0 0 0 0
B000906 Charles Brown Charles Brown   Democrat PA House 3 1841-05-31 1849-03-03 0 []     1797-09-23 M 5 1849-03-03 0 0 0 0 0 0 0
B000977 Charles Brumm Charles Brumm   Republican PA House 12 1881-12-05 1909-03-03 0 []     1838-06-09 M 15 1909-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);