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

1,079 rows where state = "PA" sorted by full_name

✎ View and edit SQL

This data as json, CSV (advanced)

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

is_current 2

  • 0 1,060
  • 1 19

chamber 2

state 1

  • PA · 1,079 ✖
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
K000327 Aaron Kreider Aaron Kreider   Republican PA House 18 1913-04-07 1923-03-03 0   [] 406481       Aaron S. Kreider   1863-06-26 M 6 1923-03-03 0 0 0 0 0
L000524 Aaron Lyle Aaron Lyle   Republican PA House 12 1809-05-22 1817-03-03 0   [] 407008       Aaron Lyle   1759-11-17 M 5 1817-03-03 0 0 0 0 0
L000011 Abner Lacock Abner Lacock   Republican PA Senate   1811-11-04 1819-03-03 0   [] 406521       Abner Lacock   1770-07-09 M 2 1819-03-03 0 0 0 0 0
B000142 Abraham Barker Abraham Barker   Republican PA House 17 1865-12-04 1867-03-03 0   [] 401143       Abraham Andrews Barker   1816-03-30 M 2 1867-03-03 0 0 0 0 0
K000052 Abraham Keister Abraham Keister   Republican PA House 22 1913-04-07 1917-03-03 0   [] 406222       Abraham Lincoln Keister   1852-09-10 M 3 1917-03-03 0 0 0 0 0
M000474 Abraham McIlvaine Abraham McIlvaine   Whig PA House 7 1843-12-04 1849-03-03 0   [] 407472       Abraham Robinson McIlvaine   1804-08-14 M 4 1849-03-03 0 0 0 0 0
S000509 Abraham Smith Abraham Smith   Republican PA House 9 1873-12-01 1885-03-03 0   [] 409995       A. Herr Smith   1815-03-07 M 7 1885-03-03 0 0 0 0 0
G000242 Adam Glossbrenner Adam Glossbrenner   Democrat PA House 15 1865-12-04 1869-03-03 0   [] 404604       Adam John Glossbrenner   1810-08-31 M 3 1869-03-03 0 0 0 0 0
K000192 Adam King Adam King   Jackson PA House 10 1827-12-03 1833-03-03 0   [] 406353       Adam King (congressman)   1783-01-20 M 4 1833-03-03 1 0 0 0 0
S000264 Adam Seybert Adam Seybert   Republican PA House 1 1809-05-22 1819-03-03 0   [] 409765       Adam Seybert   1773-05-16 M 6 1819-03-03 0 0 0 0 0
W000776 Adam Wyant Adam Wyant   Republican PA House 31 1921-04-11 1933-03-03 0   [] 411925       Adam Wyant   1869-09-15 M 7 1933-03-03 0 0 0 0 0
T000036 Adamson Tannehill Adamson Tannehill   Republican PA House 14 1813-05-24 1815-03-03 0   [] 410625       Adamson Tannehill   1750-05-23 M 2 1815-03-03 0 0 0 0 0
W000688 Alan Wood Alan Wood   Republican PA House 7 1875-12-06 1877-03-03 0   [] 411840       Alan Wood Jr.   1834-07-06 M 2 1877-03-03 0 0 0 0 0
E000087 Albert Egbert Albert Egbert   Democrat PA House 27 1875-12-06 1877-03-03 0   [] 403780       Albert Gallatin Egbert   1828-04-13 M 2 1877-03-03 0 0 0 0 0
G000020 Albert Gallatin Albert Gallatin   Republican PA House 12 1795-12-07 1801-03-03 0   [] 404397       Albert Gallatin   1761-01-29 M 4 1801-03-03 0 0 0 0 0
H000769 Albert Hopkins Albert Hopkins   Republican PA House 16 1891-12-07 1895-03-03 0   [] 405619       Albert C. Hopkins   1837-09-15 M 3 1895-03-03 0 0 0 0 0
J000115 Albert Johnson Albert Johnson   Republican PA House 23 1963-01-09 1977-01-03 0   [] 406016 00597     Albert W. Johnson   1906-04-17 M 8 1977-01-03 0 0 0 0 0
M000123 Albert Marchand Albert Marchand   Democrat PA House 19 1839-12-02 1843-03-03 0   [] 407147       Albert Gallatin Marchand   1811-02-27 M 3 1843-03-03 0 0 0 0 0
R000546 Albert Rutherford Albert Rutherford   Republican PA House 15 1937-01-05 1943-01-03 0   [] 409502       Albert G. Rutherford   1879-01-03 M 4 1943-01-03 0 0 0 0 0
V000077 Albert Vaughn Albert Vaughn   Republican PA House 8 1951-01-03 1953-01-03 0   [] 411134       Albert C. Vaughn   1894-10-09 M 2 1953-01-03 4 0 0 0 0
M000141 Alem Marr Alem Marr   Jackson PA House 9 1829-12-07 1831-03-03 0   [] 407164       Alem Marr   1787-06-18 M 2 1831-03-03 0 0 0 0 0
B000465 Alexander Billmeyer Alexander Billmeyer   Democrat PA House 17 1901-12-02 1903-03-03 0   [] 401448       Alexander Billmeyer   1841-01-07 M 2 1903-03-03 0 0 0 0 0
C000561 Alexander Cochran Alexander Cochran   Democrat PA House 23 1875-12-06 1877-03-03 0   [] 402692       Alexander G. Cochran   1846-03-20 M 2 1877-03-03 0 0 0 0 0
C000593 Alexander Coffroth Alexander Coffroth   Democrat PA House 17 1863-12-07 1881-03-03 0   [] 402722       Alexander H. Coffroth   1828-05-18 M 10 1881-03-03 0 0 0 0 0
C000854 Alexander Craig Alexander Craig   Democrat PA House 24 1891-12-07 1893-03-03 0   [] 402970       Alexander Kerr Craig   1828-02-21 M 2 1893-03-03 0 0 0 0 0
I000032 Alexander Irvin Alexander Irvin   Whig PA House 24 1847-12-06 1849-03-03 0   [] 405890       Alexander Irvin   1800-01-18 M 2 1849-03-03 0 0 0 0 0
M000417 Alexander McDowell Alexander McDowell   Republican PA House -1 1893-08-07 1895-03-03 0   [] 407417       Alexander McDowell   1845-03-04 M 2 1895-03-03 0 0 0 0 0
O000045 Alexander Ogle Alexander Ogle   Republican PA House 8 1817-12-01 1819-03-03 0   [] 408328       Alexander Ogle   1766-08-10 M 2 1819-03-03 0 0 0 0 0
P000035 Alexander Palmer Alexander Palmer   Democrat PA House 26 1909-03-15 1915-03-03 0   [] 408445       A. Mitchell Palmer   1872-05-04 M 4 1915-03-03 0 0 0 0 0
T000063 Alexander Taylor Alexander Taylor   Republican PA House 21 1873-12-01 1875-03-03 0   [] 410649       Alexander W. Taylor   1815-03-22 M 2 1875-03-03 0 0 0 0 0
T000227 Alexander Thomson Alexander Thomson   Jackson PA House 13 1823-12-01 1827-03-03 0   [] 410806       Alexander Thomson (congressman)   1788-01-12 M 3 1827-03-03 0 0 0 0 0
W000354 Alexander White Alexander White   Republican PA House 25 1885-12-07 1887-03-03 0   [] 411516       Alexander Colwell White   1833-12-12 M 2 1887-03-03 0 0 0 0 0
G000073 Alfred Garner Alfred Garner   Republican PA House 12 1909-03-15 1911-03-03 0   [] 404445       Alfred B. Garner   1873-03-04 M 2 1911-03-03 0 0 0 0 0
G000220 Alfred Gilmore Alfred Gilmore   Democrat PA House 24 1849-12-03 1853-03-03 0   [] 404582       Alfred Gilmore   1812-06-09 M 3 1853-03-03 0 0 0 0 0
H000215 Alfred Harmer Alfred Harmer   Republican PA House 5 1871-03-04 1901-03-03 0   [] 405093       Alfred C. Harmer   1825-08-08 M 16 1901-03-03 0 0 0 0 0
W000040 Alfred Waldron Alfred Waldron   Republican PA House 3 1933-03-09 1935-01-03 0   [] 411220       Alfred M. Waldron   1865-09-21 M 2 1935-01-03 0 0 0 0 0
C000745 Allen Cooper Allen Cooper   Republican PA House 23 1903-11-09 1911-03-03 0   [] 402866       Allen F. Cooper   1862-06-16 M 5 1911-03-03 0 0 0 0 0
E000208 Allen Ertel Allen Ertel   Democrat PA House 17 1977-01-04 1983-01-03 0   [] 403895 00352     Allen E. Ertel   1937-11-07 M 4 1983-01-03 0 0 0 0 0
W000355 Allison White Allison White   Democrat PA House 15 1857-12-07 1859-03-03 0   [] 411517       Allison White   1816-12-21 M 2 1859-03-03 0 0 0 0 0
S001162 Allyson Schwartz Allyson Y. Schwartz   Democrat PA House 13 2005-01-04 2015-01-03 0 N00001579 ["H4PA13124", "S8PA00163"] 400647 01798 5239   Allyson Schwartz Allyson Schwartz 1948-10-03 F 6 2015-01-03 11 381 75 7473 2607546
R000090 Almon Read Almon Read   Democrat PA House 12 1841-05-31 1845-03-03 0   [] 409070       Almon Heath Read   1790-06-12 M 3 1845-03-03 0 0 0 0 0
B001165 Alvin Bush Alvin Bush   Republican PA House 17 1951-01-03 1961-01-03 0   [] 402107       Alvin Bush   1893-06-04 M 6 1961-01-03 0 0 0 0 0
E000232 Alvin Evans Alvin Evans   Republican PA House 19 1901-12-02 1905-03-03 0   [] 403917       Alvin Evans   1845-10-04 M 3 1905-03-03 0 0 0 0 0
G000533 Amos Gustine Amos Gustine   Democrat PA House 13 1841-05-31 1843-03-03 0   [] 404878       Amos Gustine     M 2 1843-03-03 0 0 0 0 0
M001126 Amos Myers Amos Myers   Republican PA House 20 1863-12-07 1865-03-03 0   [] 408088       Amos Myers   1824-04-23 M 2 1865-03-03 0 0 0 0 0
S000483 Amos Slaymaker Amos Slaymaker   Federalist PA House 3 1813-05-24 1815-03-03 0   [] 409971       Amos Slaymaker   1755-03-11 M 2 1815-03-03 0 0 0 0 0
W000109 Anderson Walters Anderson Walters   Republican PA House 20 1913-04-07 1927-03-04 0   [] 411287       Anderson H. Walters   1862-05-18 M 8 1927-03-04 0 0 0 0 0
B000133 Andrew Barchfeld Andrew Barchfeld   Republican PA House 32 1905-12-04 1917-03-03 0   [] 401135       Andrew J. Barchfeld   1863-05-18 M 7 1917-03-03 0 0 0 0 0
B000286 Andrew Beaumont Andrew Beaumont   Jackson PA House 15 1833-12-02 1837-03-03 0   [] 401280       Andrew Beaumont   1790-01-24 M 3 1837-03-03 0 0 0 0 0
B000583 Andrew Boden Andrew Boden   Republican PA House 5 1817-12-01 1821-03-03 0   [] 412018       Andrew Boden     M 3 1821-03-03 0 0 0 0 0
B000855 Andrew Brodbeck Andrew Brodbeck   Democrat PA House 20 1913-04-07 1919-03-03 0   [] 401812       Andrew R. Brodbeck   1860-04-11 M 4 1919-03-03 0 0 0 0 0
B001000 Andrew Buchanan Andrew Buchanan   Democrat PA House 20 1835-12-07 1839-03-03 0   [] 401950       Andrew Buchanan (American politician)   1780-04-08 M 3 1839-03-03 0 0 0 0 0
C001004 Andrew Curtin Andrew Curtin   Democrat PA House 20 1881-12-05 1887-03-03 0   [] 403111       Andrew Gregg Curtin   1817-04-22 M 4 1887-03-03 0 0 0 0 0
G000442 Andrew Gregg Andrew Gregg   Republican PA Senate   1791-10-24 1813-03-03 0   [] 404789       Andrew Gregg   1755-06-10 M 4 1813-03-03 0 0 0 0 0
O000046 Andrew Ogle Andrew Ogle   Whig PA House 18 1849-12-03 1851-03-03 0   [] 408329       Andrew J. Ogle   1822-03-25 M 2 1851-03-03 0 0 0 0 0
P000055 Andrew Parker Andrew Parker   Democrat PA House 17 1851-12-01 1853-03-03 0   [] 408465       Andrew Parker (politician)   1805-05-21 M 2 1853-03-03 0 0 0 0 0
S000899 Andrew Stewart Andrew Stewart   Whig PA House 18 1821-12-03 1849-03-03 0   [] 410360       Andrew Stewart (American politician, died 1872)   1791-06-11 M 15 1849-03-03 0 0 0 0 0
S000900 Andrew Stewart Andrew Stewart   Republican PA House 24 1891-12-07 1893-03-03 0   [] 410361       Andrew Stewart (American politician, died 1903)   1836-04-06 M 2 1893-03-03 0 0 0 0 0
C000259 Anthony Cavalcante Anthony Cavalcante   Democrat PA House 23 1949-01-03 1951-01-03 0   [] 402403       Anthony Cavalcante   1897-02-06 M 2 1951-01-03 0 0 0 0 0
R000304 Anthony Roberts Anthony Roberts   Republican PA House 9 1855-12-03 1859-03-03 0   [] 409276       Anthony E. Roberts   1803-10-29 M 3 1859-03-03 0 0 0 0 0
M000295 Archibald McAllister Archibald McAllister   Democrat PA House 17 1863-12-07 1865-03-03 0   [] 407310       Archibald McAllister   1813-10-12 M 2 1865-03-03 0 0 0 0 0
S000709 Arlen Specter Arlen Specter   Democrat PA Senate   1981-01-05 2011-01-03 0 N00001604 ["S6PA00100"] 300092 01437 53340 S161 Arlen Specter   1930-02-12 M 6 2011-01-03 0 2725 323 3978 2492417
P000391 Arnold Plumer Arnold Plumer   Democrat PA House 25 1837-09-04 1843-03-03 0   [] 408785       Arnold Plumer   1801-06-06 M 4 1843-03-03 0 0 0 0 0
B000230 Arthur Bates Arthur Bates   Republican PA House 25 1901-12-02 1913-03-03 0   [] 401225       Arthur L. Bates   1859-06-06 M 7 1913-03-03 0 0 0 0 0
D000288 Arthur Dewalt Arthur Dewalt   Democrat PA House 13 1915-12-06 1921-03-03 0   [] 403413       Arthur G. Dewalt   1854-10-11 M 4 1921-03-03 0 0 0 0 0
R000511 Arthur Rupley Arthur Rupley   Republican PA House -1 1913-04-07 1915-03-03 0   [] 409470       Arthur Ringwalt Rupley   1868-11-13 M 2 1915-03-03 0 0 0 0 0
P000006 Asa Packer Asa Packer   Democrat PA House 13 1853-12-05 1857-03-03 0   [] 408417       Asa Packer   1805-12-29 M 3 1857-03-03 0 0 0 0 0
G000095 Athelston Gaston Athelston Gaston   Democrat PA House 26 1899-12-04 1901-03-03 0   [] 404467       Athelston Gaston   1838-04-24 M 2 1901-03-03 0 0 0 0 0
K000058 Augustine Kelley Augustine Kelley   Democrat PA House 21 1941-01-03 1959-01-03 0   [] 406228       Augustine B. Kelley   1883-07-09 M 10 1959-01-03 0 0 0 0 0
D000506 Augustus Drum Augustus Drum   Democrat PA House 19 1853-12-05 1855-03-03 0   [] 403613       Augustus Drum   1815-11-26 M 2 1855-03-03 0 0 0 0 0
M001088 Austin Murphy Austin Murphy   Democrat PA House 20 1977-01-04 1995-01-03 0   [] 408052 00841     Austin Murphy   1927-06-17 M 10 1995-01-03 0 4 0 0 0
B000445 Benjamin Bidlack Benjamin Bidlack   Democrat PA House 11 1841-05-31 1845-03-03 0   [] 401430       Benjamin A. Bidlack   1804-09-08 M 3 1845-03-03 0 0 0 0 0
B000723 Benjamin Boyer Benjamin Boyer   Democrat PA House 6 1865-12-04 1869-03-03 0   [] 401683       Benjamin Markley Boyer   1823-01-22 M 3 1869-03-03 0 0 0 0 0
F000230 Benjamin Focht Benjamin Focht   Republican PA House 18 1907-12-02 1939-01-03 0   [] 404185       Benjamin K. Focht   1863-03-12 M 17 1939-01-03 2 0 0 0 0
G000259 Benjamin Golder Benjamin Golder   Republican PA House 4 1925-12-07 1933-03-03 0   [] 404621       Benjamin M. Golder   1891-12-23 M 5 1933-03-03 0 0 0 0 0
J000045 Benjamin James Benjamin James   Republican PA House 7 1949-01-03 1959-01-03 0   [] 405950       Benjamin F. James   1885-08-01 M 6 1959-01-03 0 0 0 0 0
J000060 Benjamin Jarrett Benjamin Jarrett   Republican PA House 20 1937-01-05 1943-01-03 0   [] 405965       Benjamin Jarrett   1881-07-18 M 4 1943-01-03 0 0 0 0 0
J000281 Benjamin Junkin Benjamin Junkin   Republican PA House 16 1859-12-05 1861-03-03 0   [] 406173       Benjamin Franklin Junkin   1822-11-12 M 2 1861-03-03 0 0 0 0 0
M000683 Benjamin Meyers Benjamin Meyers   Democrat PA House 16 1871-03-04 1873-03-03 0   [] 407668       Benjamin F. Meyers   1833-07-06 M 2 1873-03-03 0 0 0 0 0
S000098 Benjamin Say Benjamin Say   Republican PA House 1 1807-10-26 1811-03-03 0   [] 409608       Benjamin Say   1755-08-28 M 3 1811-03-03 0 0 0 0 0
S001154 Bill Shuster Bill Shuster   Republican PA House 9 2001-05-17 2019-01-03 0 N00013770 ["H2PA09035"] 409888 01681 55693   Bill Shuster   1961-01-10 M 10 2019-01-03 25 727 89 11227 7243003
M000336 Blair McClenachan Blair McClenachan   Republican PA House 2 1797-05-15 1799-03-03 0   [] 412070       Blair McClenachan     M 2 1799-03-03 0 0 0 0 0
P000217 Boies Penrose Boies Penrose   Republican PA Senate   1897-03-15 1921-03-03 0   [] 408620       Boies Penrose   1860-11-01 M 5 1921-03-03 0 0 0 0 0
B001296 Brendan Boyle Brendan F. Boyle   Democrat PA House 2 2015-01-06 2027-01-03 1 N00035307 ["H4PA13199"] 412652 02267 47357   Brendan Boyle Brendan Boyle 1977-02-06 M 7   24 245 125 5621 6493523
F000466 Brian Fitzpatrick Brian K. Fitzpatrick   Republican PA House 1 2017-01-03 2027-01-03 1 N00038779 ["H6PA08277"] 412721   167708   Brian Fitzpatrick (American politician) Brian Fitzpatrick 1973-12-17 M 6   14 563 234 4296 28363525
S000869 Bruce Sterling Bruce Sterling   Democrat PA House 23 1917-04-02 1919-03-03 0   [] 410331       Bruce F. Sterling   1870-09-28 M 2 1919-03-03 0 0 0 0 0
T000068 Caleb Taylor Caleb Taylor   Republican PA House 5 1867-03-04 1871-03-03 0   [] 410653       Caleb N. Taylor   1813-07-27 M 3 1871-03-03 0 0 0 0 0
G000185 Calvin Gilfillan Calvin Gilfillan   Republican PA House 20 1869-03-04 1871-03-03 0   [] 404550       Calvin Willard Gilfillan   1832-02-20 M 2 1871-03-03 0 0 0 0 0
H000682 Carl Hoffman Carl Hoffman   Republican PA House 23 1945-01-03 1947-01-03 0   [] 405535       Carl Henry Hoffman   1896-08-12 M 2 1947-01-03 0 0 0 0 0
C001007 Carlton Curtis Carlton Curtis   Republican PA House 19 1851-12-01 1875-03-03 0   [] 403114       Carlton B. Curtis   1811-12-17 M 13 1875-03-03 0 0 0 0 0
K000032 Carroll Kearns Carroll Kearns   Republican PA House 24 1947-01-03 1963-01-03 0   [] 406202       Carroll D. Kearns   1900-05-07 M 9 1963-01-03 0 0 0 0 0
F000043 Chaka Fattah Chaka Fattah   Democrat PA House 2 1995-01-04 2016-06-23 0 N00001746 ["H2PA02055"] 400130 00371 21850   Chaka Fattah Chaka Fattah 1956-11-21 M 11 2016-06-23 14 435 93 9738 1129632
H000046 Chapin Hall Chapin Hall   Republican PA House 24 1859-12-05 1861-03-03 0   [] 404931       Chapin Hall   1816-07-12 M 2 1861-03-03 0 0 0 0 0
F000361 Chapman Freeman Chapman Freeman   Republican PA House 1 1875-12-06 1879-03-03 0   [] 404308       Chapman Freeman   1832-10-08 M 3 1879-03-03 0 0 0 0 0
A000077 Charles Albright Charles Albright   Republican PA House -1 1873-12-01 1875-03-03 0   [] 400736       Charles Albright (Pennsylvania politician)   1830-12-13 M 2 1875-03-03 0 0 0 0 0
B000135 Charles Barclay Charles Barclay   Republican PA House 21 1907-12-02 1911-03-03 0   [] 401136       Charles Frederick Barclay   1844-05-09 M 3 1911-03-03 0 0 0 0 0
B000165 Charles Barnitz Charles Barnitz   Anti Masonic PA House 11 1833-12-02 1835-03-03 0   [] 401167       Charles Augustus Barnitz   1780-09-11 M 2 1835-03-03 0 0 0 0 0
B000439 Charles Biddle Charles Biddle   Democrat PA House 2 1861-07-04 1863-03-03 0   [] 401425       Charles John Biddle   1819-04-30 M 2 1863-03-03 0 0 0 0 0
B000703 Charles Bowman Charles Bowman   Republican PA House 11 1911-04-04 1913-03-03 0   [] 401665       Charles Calvin Bowman   1852-11-14 M 2 1913-03-03 0 0 0 0 0
B000728 Charles Boyle Charles Boyle   Democrat PA House 21 1883-12-03 1887-03-03 0   [] 401688       Charles Edmund Boyle   1836-02-04 M 3 1887-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);