legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
3,270 rows where state = "PA" sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: class, phone, rss_url, start (date), end (date)
party 25 ✖
- Republican 1,811
- Democrat 1,015
- Jackson 124
- Whig 105
- Federalist 62
- Anti Masonic 39
- Ind. Republican-Democrat 17
- Adams 13
- Ind. Republican 8
- American 5
- National Greenbacker 5
- Democratic Republican 4
- Anti Jacksonian 3
- Anti-Administration 3
- Jacksonian 3
- Progressive 3
- Anti-Lecompton Democrat 2
- Anti-administration 2
- Ind. Democrat 2
- Anti Mason 1
- Free Soil 1
- Independent 1
- Jackson Republican 1
- Pro-Administration 1
- Pro-administration 1
Link | rowid | legislator_id ▼ | type | state | start | end | class | party | district | how | party_affiliations | url | caucus | address | phone | fax | contact_form | office | state_rank | rss_url | end-type |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14962 | 14962 | Ernest Acheson A000019 | rep | PA | 1895-12-02 | 1897-03-03 | Republican | 24 | |||||||||||||
14963 | 14963 | Ernest Acheson A000019 | rep | PA | 1897-03-15 | 1899-03-03 | Republican | 24 | |||||||||||||
14964 | 14964 | Ernest Acheson A000019 | rep | PA | 1899-12-04 | 1901-03-03 | Republican | 24 | |||||||||||||
14965 | 14965 | Ernest Acheson A000019 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 24 | |||||||||||||
14966 | 14966 | Ernest Acheson A000019 | rep | PA | 1903-11-09 | 1905-03-03 | Republican | 24 | |||||||||||||
14967 | 14967 | Ernest Acheson A000019 | rep | PA | 1905-12-04 | 1907-03-03 | Republican | 24 | |||||||||||||
14968 | 14968 | Ernest Acheson A000019 | rep | PA | 1907-12-02 | 1909-03-03 | Republican | 24 | |||||||||||||
8798 | 8798 | Ephraim Acker A000020 | rep | PA | 1871-03-04 | 1873-03-03 | Democrat | 6 | |||||||||||||
14548 | 14548 | Robert Adams A000044 | rep | PA | 1893-08-07 | 1895-03-03 | Republican | 2 | |||||||||||||
14549 | 14549 | Robert Adams A000044 | rep | PA | 1895-12-02 | 1897-03-03 | Republican | 2 | |||||||||||||
14550 | 14550 | Robert Adams A000044 | rep | PA | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
14551 | 14551 | Robert Adams A000044 | rep | PA | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
14552 | 14552 | Robert Adams A000044 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 2 | |||||||||||||
14553 | 14553 | Robert Adams A000044 | rep | PA | 1903-11-09 | 1905-03-03 | Republican | 2 | |||||||||||||
14554 | 14554 | Robert Adams A000044 | rep | PA | 1905-12-04 | 1907-03-03 | Republican | 2 | |||||||||||||
2762 | 2762 | William Addams A000053 | rep | PA | 1825-12-05 | 1827-03-03 | Jackson | 7 | |||||||||||||
2763 | 2763 | William Addams A000053 | rep | PA | 1827-12-03 | 1829-03-03 | Jackson | 7 | |||||||||||||
6972 | 6972 | John Ahl A000060 | rep | PA | 1857-12-07 | 1859-03-03 | Democrat | 16 | |||||||||||||
16249 | 16249 | William Ainey A000065 | rep | PA | 1911-04-04 | 1913-03-03 | Republican | 14 | |||||||||||||
16250 | 16250 | William Ainey A000065 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 14 | |||||||||||||
9072 | 9072 | Charles Albright A000077 | rep | PA | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
22472 | 22472 | Robert Allen A000145 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 28 | |||||||||||||
22473 | 22473 | Robert Allen A000145 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 28 | |||||||||||||
2553 | 2553 | James Allison A000157 | rep | PA | 1823-12-01 | 1825-03-03 | 16 | ||||||||||||||
2554 | 2554 | James Allison A000157 | rep | PA | 1825-12-05 | 1827-03-03 | -1 | ||||||||||||||
6755 | 6755 | John Allison A000158 | rep | PA | 1851-12-01 | 1853-03-03 | Whig | 20 | |||||||||||||
6756 | 6756 | John Allison A000158 | rep | PA | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 23 | |||||||||||||
3296 | 3296 | Robert Allison A000159 | rep | PA | 1831-12-05 | 1833-03-03 | Anti Masonic | 12 | |||||||||||||
12066 | 12066 | Lemuel Amerman A000171 | rep | PA | 1891-12-07 | 1893-03-03 | Democrat | 11 | |||||||||||||
31414 | 31414 | Joseph Ammerman A000177 | rep | PA | 1977-01-04 | 1979-01-03 | Democrat | 23 | |||||||||||||
8078 | 8078 | Sydenham Ancona A000178 | rep | PA | 1861-07-04 | 1863-03-03 | Democrat | 8 | |||||||||||||
8079 | 8079 | Sydenham Ancona A000178 | rep | PA | 1863-12-07 | 1865-03-03 | Democrat | 8 | |||||||||||||
8080 | 8080 | Sydenham Ancona A000178 | rep | PA | 1865-12-04 | 1867-03-03 | Democrat | 8 | |||||||||||||
651 | 651 | Isaac Anderson A000191 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 3 | |||||||||||||
652 | 652 | Isaac Anderson A000191 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 3 | |||||||||||||
2770 | 2770 | Samuel Anderson A000231 | rep | PA | 1827-12-03 | 1829-03-03 | Adams | 4 | |||||||||||||
1794 | 1794 | William Anderson A000235 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 1 | |||||||||||||
1795 | 1795 | William Anderson A000235 | rep | PA | 1811-11-04 | 1813-03-03 | Republican | 1 | |||||||||||||
1796 | 1796 | William Anderson A000235 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 1 | |||||||||||||
1797 | 1797 | William Anderson A000235 | rep | PA | 1817-12-01 | 1819-03-03 | Republican | 1 | |||||||||||||
3834 | 3834 | Joseph Anthony A000263 | rep | PA | 1833-12-02 | 1835-03-03 | Jackson | 16 | |||||||||||||
3835 | 3835 | Joseph Anthony A000263 | rep | PA | 1835-12-07 | 1837-03-03 | Jackson | 16 | |||||||||||||
72 | 72 | James Armstrong A000280 | rep | PA | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
8503 | 8503 | William Armstrong A000285 | rep | PA | 1869-03-04 | 1871-03-03 | Republican | 18 | |||||||||||||
13236 | 13236 | William Arnold A000299 | rep | PA | 1895-12-02 | 1897-03-03 | Republican | 28 | |||||||||||||
13237 | 13237 | William Arnold A000299 | rep | PA | 1897-03-15 | 1899-03-03 | Republican | 28 | |||||||||||||
3836 | 3836 | Michael Ash A000305 | rep | PA | 1835-12-07 | 1837-03-03 | Jackson | 3 | |||||||||||||
32457 | 32457 | Eugene Atkinson A000329 | rep | PA | 1979-01-15 | 1981-01-03 | Democrat | 25 | |||||||||||||
32458 | 32458 | Eugene Atkinson A000329 | rep | PA | 1981-01-05 | 1983-01-03 | Republican | 25 | |||||||||||||
12070 | 12070 | Louis Atkinson A000331 | rep | PA | 1883-12-03 | 1885-03-03 | Republican | 18 | |||||||||||||
12071 | 12071 | Louis Atkinson A000331 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 18 | |||||||||||||
12072 | 12072 | Louis Atkinson A000331 | rep | PA | 1887-12-05 | 1889-03-03 | Republican | 18 | |||||||||||||
12073 | 12073 | Louis Atkinson A000331 | rep | PA | 1889-12-02 | 1891-03-03 | Republican | 18 | |||||||||||||
12074 | 12074 | Louis Atkinson A000331 | rep | PA | 1891-12-07 | 1893-03-03 | Republican | 18 | |||||||||||||
39106 | 39106 | Jason Altmire A000362 | rep | PA | 2007-01-04 | 2009-01-03 | Democrat | 4 | http://altmire.house.gov | ||||||||||||
39107 | 39107 | Jason Altmire A000362 | rep | PA | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://altmire.house.gov | ||||||||||||
39108 | 39108 | Jason Altmire A000362 | rep | PA | 2011-01-05 | 2013-01-03 | Democrat | 4 | http://altmire.house.gov | 332 Cannon HOB; Washington DC 20515-3804 | 202-225-2565 | 202-226-2274 | https://forms.house.gov/altmire/webforms/issue_subscribe.htm | 332 Cannon House Office Building | |||||||
7657 | 7657 | Elijah Babbitt B000002 | rep | PA | 1859-12-05 | 1861-03-03 | Republican | 25 | |||||||||||||
7658 | 7658 | Elijah Babbitt B000002 | rep | PA | 1861-07-04 | 1863-03-03 | Republican | 25 | |||||||||||||
9994 | 9994 | Reuben Bachman B000011 | rep | PA | 1879-03-18 | 1881-03-03 | Democrat | 10 | |||||||||||||
32464 | 32464 | Donald Bailey B000037 | rep | PA | 1979-01-15 | 1981-01-03 | Democrat | 21 | |||||||||||||
32465 | 32465 | Donald Bailey B000037 | rep | PA | 1981-01-05 | 1983-01-03 | Democrat | 21 | |||||||||||||
7911 | 7911 | Joseph Bailey B000043 | rep | PA | 1861-07-04 | 1863-03-03 | Democrat | 16 | |||||||||||||
7912 | 7912 | Joseph Bailey B000043 | rep | PA | 1863-12-07 | 1865-03-03 | Democrat | 15 | |||||||||||||
16679 | 16679 | Warren Bailey B000050 | rep | PA | 1913-04-07 | 1915-03-03 | Democrat | 19 | |||||||||||||
16680 | 16680 | Warren Bailey B000050 | rep | PA | 1915-12-06 | 1917-03-03 | Democrat | 19 | |||||||||||||
2188 | 2188 | Henry Baldwin B000087 | rep | PA | 1817-12-01 | 1819-03-03 | Republican | 14 | |||||||||||||
2189 | 2189 | Henry Baldwin B000087 | rep | PA | 1819-12-06 | 1821-03-03 | Republican | 14 | |||||||||||||
2190 | 2190 | Henry Baldwin B000087 | rep | PA | 1821-12-03 | 1823-03-03 | Republican | 14 | |||||||||||||
3841 | 3841 | John Banks B000114 | rep | PA | 1831-12-05 | 1833-03-03 | Anti Masonic | 18 | |||||||||||||
3842 | 3842 | John Banks B000114 | rep | PA | 1833-12-02 | 1835-03-03 | Anti Masonic | 24 | |||||||||||||
3843 | 3843 | John Banks B000114 | rep | PA | 1835-12-07 | 1837-03-03 | Anti Masonic | 24 | |||||||||||||
13565 | 13565 | Laird Barber B000123 | rep | PA | 1899-12-04 | 1901-03-03 | Democrat | 8 | |||||||||||||
16681 | 16681 | Andrew Barchfeld B000133 | rep | PA | 1905-12-04 | 1907-03-03 | Republican | 32 | |||||||||||||
16682 | 16682 | Andrew Barchfeld B000133 | rep | PA | 1907-12-02 | 1909-03-03 | Republican | 32 | |||||||||||||
16683 | 16683 | Andrew Barchfeld B000133 | rep | PA | 1909-03-15 | 1911-03-03 | Republican | 32 | |||||||||||||
16684 | 16684 | Andrew Barchfeld B000133 | rep | PA | 1911-04-04 | 1913-03-03 | Republican | 32 | |||||||||||||
16685 | 16685 | Andrew Barchfeld B000133 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 32 | |||||||||||||
16686 | 16686 | Andrew Barchfeld B000133 | rep | PA | 1915-12-06 | 1917-03-03 | Republican | 32 | |||||||||||||
15336 | 15336 | Charles Barclay B000135 | rep | PA | 1907-12-02 | 1909-03-03 | Republican | 21 | |||||||||||||
15337 | 15337 | Charles Barclay B000135 | rep | PA | 1909-03-15 | 1911-03-03 | Republican | 21 | |||||||||||||
6761 | 6761 | David Barclay B000136 | rep | PA | 1855-12-03 | 1857-03-03 | Democrat | 24 | |||||||||||||
1458 | 1458 | David Bard B000137 | rep | PA | 1795-12-07 | 1797-03-03 | Republican | 10 | |||||||||||||
1459 | 1459 | David Bard B000137 | rep | PA | 1797-05-15 | 1799-03-03 | Republican | 10 | |||||||||||||
1460 | 1460 | David Bard B000137 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 4 | |||||||||||||
1461 | 1461 | David Bard B000137 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 4 | |||||||||||||
1462 | 1462 | David Bard B000137 | rep | PA | 1807-10-26 | 1809-03-03 | Republican | 4 | |||||||||||||
1463 | 1463 | David Bard B000137 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 4 | |||||||||||||
1464 | 1464 | David Bard B000137 | rep | PA | 1811-11-04 | 1813-03-03 | Republican | 4 | |||||||||||||
1465 | 1465 | David Bard B000137 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 9 | |||||||||||||
1466 | 1466 | David Bard B000137 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
8081 | 8081 | Abraham Barker B000142 | rep | PA | 1865-12-04 | 1867-03-03 | Republican | 17 | |||||||||||||
2774 | 2774 | Stephen Barlow B000150 | rep | PA | 1827-12-03 | 1829-03-03 | Jackson | 18 | |||||||||||||
2775 | 2775 | Isaac Barnard B000154 | sen | PA | 1827-12-03 | 1831-12-31 | 1 | Jackson | |||||||||||||
3602 | 3602 | Charles Barnitz B000165 | rep | PA | 1833-12-02 | 1835-03-03 | Anti Masonic | 11 | |||||||||||||
10631 | 10631 | Samuel Barr B000171 | rep | PA | 1881-12-05 | 1883-03-03 | Republican | 14 | |||||||||||||
10632 | 10632 | Samuel Barr B000171 | rep | PA | 1883-12-03 | 1885-03-03 | Republican | 14 | |||||||||||||
30820 | 30820 | William Barrett B000178 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
30821 | 30821 | William Barrett B000178 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
30822 | 30822 | William Barrett B000178 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 1 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [legislator_terms] ( [legislator_id] TEXT REFERENCES [legislators]([id]), [type] TEXT, [state] TEXT, [start] TEXT, [end] TEXT, [class] INTEGER, [party] TEXT , [district] INTEGER, [how] TEXT, [party_affiliations] TEXT, [url] TEXT, [caucus] TEXT, [address] TEXT, [phone] TEXT, [fax] TEXT, [contact_form] TEXT, [office] TEXT, [state_rank] TEXT, [rss_url] TEXT, [end-type] TEXT);