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 how
This data as json, copyable, CSV (advanced)
Suggested facets: class, state_rank, start (date), end (date)
party >10 ✖
- 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
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5 | 5 | George Clymer C000538 | rep | PA | 1789-03-04 | 1791-03-03 | -1 | ||||||||||||||
20 | 20 | William Maclay M000031 | sen | PA | 1789-03-04 | 1791-03-03 | 1 | Anti-Administration | |||||||||||||
22 | 22 | Robert Morris M000985 | sen | PA | 1789-03-04 | 1795-03-03 | 3 | Pro-Administration | |||||||||||||
28 | 28 | Henry Wynkoop W000783 | rep | PA | 1789-03-04 | 1791-03-03 | -1 | ||||||||||||||
44 | 44 | Israel Jacobs J000036 | rep | PA | 1791-10-24 | 1793-03-03 | 3 | ||||||||||||||
72 | 72 | James Armstrong A000280 | rep | PA | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
89 | 89 | Thomas Fitzsimons F000178 | rep | PA | 1789-03-04 | 1791-03-03 | -1 | ||||||||||||||
90 | 90 | Thomas Fitzsimons F000178 | rep | PA | 1791-10-24 | 1793-03-03 | 1 | ||||||||||||||
91 | 91 | Thomas Fitzsimons F000178 | rep | PA | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
101 | 101 | William Irvine I000035 | rep | PA | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
113 | 113 | William Montgomery M000873 | rep | PA | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
118 | 118 | Thomas Scott S000186 | rep | PA | 1789-03-04 | 1791-03-03 | -1 | ||||||||||||||
119 | 119 | Thomas Scott S000186 | rep | PA | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
145 | 145 | William Bingham B000474 | sen | PA | 1795-12-07 | 1801-03-03 | 3 | Federalist | |||||||||||||
186 | 186 | Frederick Muhlenberg M001063 | rep | PA | 1789-03-04 | 1791-03-03 | Pro-administration | -1 | |||||||||||||
187 | 187 | Frederick Muhlenberg M001063 | rep | PA | 1791-10-24 | 1793-03-03 | Anti-administration | 2 | |||||||||||||
188 | 188 | Frederick Muhlenberg M001063 | rep | PA | 1793-12-02 | 1795-03-03 | Anti-administration | -1 | |||||||||||||
189 | 189 | Frederick Muhlenberg M001063 | rep | PA | 1795-12-07 | 1797-03-03 | Republican | 2 | |||||||||||||
206 | 206 | John Richards R000215 | rep | PA | 1795-12-07 | 1797-03-03 | Republican | 4 | |||||||||||||
251 | 251 | John Chapman C000313 | rep | PA | 1797-05-15 | 1799-03-03 | Federalist | 4 | |||||||||||||
259 | 259 | George Ege E000089 | rep | PA | 1795-12-07 | 1797-03-03 | Federalist | 5 | |||||||||||||
260 | 260 | George Ege E000089 | rep | PA | 1797-05-15 | 1799-03-03 | Federalist | 5 | |||||||||||||
281 | 281 | Blair McClenachan M000336 | rep | PA | 1797-05-15 | 1799-03-03 | Republican | 2 | |||||||||||||
285 | 285 | James Ross R000448 | sen | PA | 1794-01-01 | 1797-03-03 | 1 | Federalist | |||||||||||||
286 | 286 | James Ross R000448 | sen | PA | 1797-05-15 | 1803-03-03 | 1 | Federalist | |||||||||||||
293 | 293 | Samuel Sitgreaves S000460 | rep | PA | 1795-12-07 | 1797-03-03 | Federalist | 4 | |||||||||||||
294 | 294 | Samuel Sitgreaves S000460 | rep | PA | 1797-05-15 | 1799-03-03 | Federalist | 4 | |||||||||||||
308 | 308 | John Swanwick S001095 | rep | PA | 1795-12-07 | 1797-03-03 | Republican | 1 | |||||||||||||
309 | 309 | John Swanwick S001095 | rep | PA | 1797-05-15 | 1799-03-03 | Republican | 1 | |||||||||||||
363 | 363 | Albert Gallatin G000020 | rep | PA | 1795-12-07 | 1797-03-03 | Republican | 12 | |||||||||||||
364 | 364 | Albert Gallatin G000020 | rep | PA | 1797-05-15 | 1799-03-03 | Republican | 12 | |||||||||||||
365 | 365 | Albert Gallatin G000020 | rep | PA | 1799-12-02 | 1801-03-03 | Republican | 12 | |||||||||||||
376 | 376 | Thomas Hartley H000299 | rep | PA | 1789-03-04 | 1791-03-03 | Federalist | -1 | |||||||||||||
377 | 377 | Thomas Hartley H000299 | rep | PA | 1791-10-24 | 1793-03-03 | Federalist | 7 | |||||||||||||
378 | 378 | Thomas Hartley H000299 | rep | PA | 1793-12-02 | 1795-03-03 | Federalist | -1 | |||||||||||||
379 | 379 | Thomas Hartley H000299 | rep | PA | 1795-12-07 | 1797-03-03 | Federalist | 8 | |||||||||||||
380 | 380 | Thomas Hartley H000299 | rep | PA | 1797-05-15 | 1799-03-03 | Federalist | 8 | |||||||||||||
381 | 381 | Thomas Hartley H000299 | rep | PA | 1799-12-02 | 1801-03-03 | Federalist | 8 | |||||||||||||
388 | 388 | John Kittera K000253 | rep | PA | 1791-10-24 | 1793-03-03 | Federalist | 5 | |||||||||||||
389 | 389 | John Kittera K000253 | rep | PA | 1793-12-02 | 1795-03-03 | Federalist | -1 | |||||||||||||
390 | 390 | John Kittera K000253 | rep | PA | 1795-12-07 | 1797-03-03 | Federalist | 7 | |||||||||||||
391 | 391 | John Kittera K000253 | rep | PA | 1797-05-15 | 1799-03-03 | Federalist | 7 | |||||||||||||
392 | 392 | John Kittera K000253 | rep | PA | 1799-12-02 | 1801-03-03 | Federalist | 7 | |||||||||||||
440 | 440 | Richard Thomas T000183 | rep | PA | 1795-12-07 | 1797-03-03 | Federalist | 3 | |||||||||||||
441 | 441 | Richard Thomas T000183 | rep | PA | 1797-05-15 | 1799-03-03 | Federalist | 3 | |||||||||||||
442 | 442 | Richard Thomas T000183 | rep | PA | 1799-12-02 | 1801-03-03 | Federalist | 3 | |||||||||||||
443 | 443 | Robert Waln W000094 | rep | PA | 1797-05-15 | 1799-03-03 | Federalist | 1 | |||||||||||||
444 | 444 | Robert Waln W000094 | rep | PA | 1799-12-02 | 1801-03-03 | Federalist | 1 | |||||||||||||
458 | 458 | Thomas Boude B000660 | rep | PA | 1801-12-07 | 1803-03-03 | Federalist | 7 | |||||||||||||
497 | 497 | William Jones J000258 | rep | PA | 1801-12-07 | 1803-03-03 | Republican | 1 | |||||||||||||
502 | 502 | George Logan L000401 | sen | PA | 1801-12-07 | 1807-03-03 | 3 | Republican | |||||||||||||
509 | 509 | John Muhlenberg M001066 | rep | PA | 1789-03-04 | 1791-03-03 | -1 | ||||||||||||||
510 | 510 | John Muhlenberg M001066 | rep | PA | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
511 | 511 | John Muhlenberg M001066 | rep | PA | 1799-12-02 | 1801-03-03 | Republican | 4 | |||||||||||||
512 | 512 | John Muhlenberg M001066 | sen | PA | 1801-12-07 | 1801-12-31 | 3 | Democratic Republican | |||||||||||||
546 | 546 | Henry Woods W000722 | rep | PA | 1799-12-02 | 1801-03-03 | Federalist | 10 | |||||||||||||
547 | 547 | Henry Woods W000722 | rep | PA | 1801-12-07 | 1803-03-03 | Federalist | 10 | |||||||||||||
584 | 584 | Daniel Hiester H000570 | rep | PA | 1789-03-04 | 1791-03-03 | Republican | -1 | |||||||||||||
585 | 585 | Daniel Hiester H000570 | rep | PA | 1791-10-24 | 1793-03-03 | Republican | 4 | |||||||||||||
586 | 586 | Daniel Hiester H000570 | rep | PA | 1793-12-02 | 1795-03-03 | Republican | -1 | |||||||||||||
587 | 587 | Daniel Hiester H000570 | rep | PA | 1795-12-07 | 1797-03-03 | Republican | 5 | |||||||||||||
590 | 590 | John Hoge H000695 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 10 | |||||||||||||
597 | 597 | Samuel Maclay M000029 | rep | PA | 1795-12-07 | 1797-03-03 | Republican | 6 | |||||||||||||
598 | 598 | Samuel Maclay M000029 | sen | PA | 1803-10-17 | 1809-03-03 | 1 | Republican | |||||||||||||
619 | 619 | John Stewart S000912 | rep | PA | 1799-12-02 | 1801-03-03 | Republican | 8 | |||||||||||||
620 | 620 | John Stewart S000912 | rep | PA | 1801-12-07 | 1803-03-03 | Republican | 8 | |||||||||||||
621 | 621 | John Stewart S000912 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 6 | |||||||||||||
629 | 629 | Isaac Van Horne V000045 | rep | PA | 1801-12-07 | 1803-03-03 | Republican | 4 | |||||||||||||
630 | 630 | Isaac Van Horne V000045 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
677 | 677 | Frederick Conrad C000704 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 2 | |||||||||||||
678 | 678 | Frederick Conrad C000704 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
707 | 707 | John Hamilton H000111 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 10 | |||||||||||||
708 | 708 | John Hanna H000161 | rep | PA | 1797-05-15 | 1799-03-03 | Republican | 6 | |||||||||||||
709 | 709 | John Hanna H000161 | rep | PA | 1799-12-02 | 1801-03-03 | Republican | 6 | |||||||||||||
710 | 710 | John Hanna H000161 | rep | PA | 1801-12-07 | 1803-03-03 | Republican | 6 | |||||||||||||
711 | 711 | John Hanna H000161 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 4 | |||||||||||||
712 | 712 | John Hanna H000161 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
725 | 725 | Christian Lower L000478 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 3 | |||||||||||||
726 | 726 | John Lucas L000492 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 11 | |||||||||||||
727 | 727 | John Lucas L000492 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | -1 | |||||||||||||
782 | 782 | John Whitehill W000403 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 3 | |||||||||||||
783 | 783 | John Whitehill W000403 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 3 | |||||||||||||
819 | 819 | Joseph Clay C000486 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 1 | |||||||||||||
820 | 820 | Joseph Clay C000486 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 1 | |||||||||||||
821 | 821 | Joseph Clay C000486 | rep | PA | 1807-10-26 | 1809-03-03 | Republican | 1 | |||||||||||||
845 | 845 | Andrew Gregg G000442 | rep | PA | 1791-10-24 | 1793-03-03 | Democratic Republican | 6 | |||||||||||||
846 | 846 | Andrew Gregg G000442 | rep | PA | 1793-12-02 | 1795-03-03 | Democratic Republican | -1 | |||||||||||||
847 | 847 | Andrew Gregg G000442 | rep | PA | 1795-12-07 | 1797-03-03 | Republican | 9 | |||||||||||||
848 | 848 | Andrew Gregg G000442 | rep | PA | 1797-05-15 | 1799-03-03 | Republican | 9 | |||||||||||||
849 | 849 | Andrew Gregg G000442 | rep | PA | 1799-12-02 | 1801-03-03 | Republican | 9 | |||||||||||||
850 | 850 | Andrew Gregg G000442 | rep | PA | 1801-12-07 | 1803-03-03 | Republican | 9 | |||||||||||||
851 | 851 | Andrew Gregg G000442 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 5 | |||||||||||||
852 | 852 | Andrew Gregg G000442 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 5 | |||||||||||||
853 | 853 | Andrew Gregg G000442 | sen | PA | 1807-10-26 | 1813-03-03 | 3 | Republican | |||||||||||||
855 | 855 | John Hiester H000573 | rep | PA | 1807-10-26 | 1809-03-03 | Republican | 3 | |||||||||||||
856 | 856 | William Hoge H000699 | rep | PA | 1801-12-07 | 1803-03-03 | Republican | 12 | |||||||||||||
857 | 857 | William Hoge H000699 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 10 | |||||||||||||
858 | 858 | William Hoge H000699 | rep | PA | 1807-10-26 | 1809-03-03 | Republican | 10 |
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);