congress_members
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
1,025 rows where chamber = "House" and state = "PA" sorted by full_name
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)
party 15
- Republican 489
- Democrat 340
- Whig 60
- Jackson 53
- Federalist 26
- - 18
- Anti Masonic 11
- Ind. Republican-Democrat 7
- Ind. Republican 6
- Adams 5
- American 3
- National Greenbacker 3
- Anti Jacksonian 2
- Anti-Lecompton Democrat 1
- Jacksonian 1
state 1
- PA · 1,025 ✖
chamber 1
- House · 1,025 ✖
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | |||||||
| 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 | ||||||
| B000906 | Charles | Brown | Charles Brown | Democrat | PA | House | 3 | 1841-05-31 | 1849-03-03 | 0 | [] | 401863 | Charles Brown (congressman) | 1797-09-23 | M | 5 | 1849-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B000977 | Charles | Brumm | Charles Brumm | Republican | PA | House | 12 | 1881-12-05 | 1909-03-03 | 0 | [] | 401929 | Charles N. Brumm | 1838-06-09 | M | 15 | 1909-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B001019 | Charles | Buckalew | Charles Buckalew | Democrat | PA | House | 17 | 1863-12-07 | 1891-03-03 | 0 | [] | 401969 | Charles R. Buckalew | 1821-12-28 | M | 15 | 1891-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| C000685 | Charles | Connell | Charles Connell | Republican | PA | House | 10 | 1921-04-11 | 1923-03-03 | 0 | [] | 402811 | Charles R. Connell | 1864-09-22 | M | 2 | 1923-03-03 | 0 | 0 | 0 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);