legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,811 rows where party = "Republican" and state = "PA"
This data as json, copyable, CSV (advanced)
Suggested facets: class, start (date), end (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
281 | 281 | Blair McClenachan M000336 | rep | PA | 1797-05-15 | 1799-03-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
511 | 511 | John Muhlenberg M001066 | rep | PA | 1799-12-02 | 1801-03-03 | Republican | 4 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
874 | 874 | Daniel Montgomery M000864 | rep | PA | 1807-10-26 | 1809-03-03 | Republican | 5 | |||||||||||||
880 | 880 | John Pugh P000562 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
881 | 881 | John Pugh P000562 | rep | PA | 1807-10-26 | 1809-03-03 | Republican | 2 | |||||||||||||
882 | 882 | Jacob Richards R000212 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 1 | |||||||||||||
883 | 883 | Jacob Richards R000212 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 1 | |||||||||||||
884 | 884 | Jacob Richards R000212 | rep | PA | 1807-10-26 | 1809-03-03 | Republican | 1 | |||||||||||||
982 | 982 | Daniel Hiester H000571 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 3 | |||||||||||||
1013 | 1013 | Michael Leib L000229 | rep | PA | 1799-12-02 | 1801-03-03 | Republican | 2 | |||||||||||||
1014 | 1014 | Michael Leib L000229 | rep | PA | 1801-12-07 | 1803-03-03 | Republican | 2 | |||||||||||||
1015 | 1015 | Michael Leib L000229 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 1 | |||||||||||||
1016 | 1016 | Michael Leib L000229 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 1 | |||||||||||||
1017 | 1017 | Michael Leib L000229 | sen | PA | 1809-05-22 | 1815-03-03 | 1 | Republican | |||||||||||||
1049 | 1049 | John Porter P000443 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 1 | |||||||||||||
1050 | 1050 | John Porter P000443 | rep | PA | 1807-10-26 | 1809-03-03 | Republican | 1 | |||||||||||||
1051 | 1051 | John Porter P000443 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 1 | |||||||||||||
1053 | 1053 | Matthias Richards R000218 | rep | PA | 1807-10-26 | 1809-03-03 | Republican | 3 | |||||||||||||
1054 | 1054 | Matthias Richards R000218 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 3 | |||||||||||||
1057 | 1057 | Benjamin Say S000098 | rep | PA | 1807-10-26 | 1809-03-03 | Republican | 1 | |||||||||||||
1058 | 1058 | Benjamin Say S000098 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 1 | |||||||||||||
1063 | 1063 | Samuel Smith S000610 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 11 | |||||||||||||
1064 | 1064 | Samuel Smith S000610 | rep | PA | 1807-10-26 | 1809-03-03 | Republican | 11 | |||||||||||||
1065 | 1065 | Samuel Smith S000610 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 11 | |||||||||||||
1186 | 1186 | Joseph Lefever L000212 | rep | PA | 1811-11-04 | 1813-03-03 | Republican | 3 | |||||||||||||
1212 | 1212 | William Rodman R000375 | rep | PA | 1811-11-04 | 1813-03-03 | Republican | 2 | |||||||||||||
1225 | 1225 | John Smilie S000508 | rep | PA | 1793-12-02 | 1795-03-03 | Republican | -1 | |||||||||||||
1226 | 1226 | John Smilie S000508 | rep | PA | 1799-12-02 | 1801-03-03 | Republican | 11 | |||||||||||||
1227 | 1227 | John Smilie S000508 | rep | PA | 1801-12-07 | 1803-03-03 | Republican | 11 | |||||||||||||
1228 | 1228 | John Smilie S000508 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 9 | |||||||||||||
1229 | 1229 | John Smilie S000508 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 9 | |||||||||||||
1230 | 1230 | John Smilie S000508 | rep | PA | 1807-10-26 | 1809-03-03 | Republican | 9 | |||||||||||||
1231 | 1231 | John Smilie S000508 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 9 | |||||||||||||
1232 | 1232 | John Smilie S000508 | rep | PA | 1811-11-04 | 1813-03-03 | Republican | 9 | |||||||||||||
1233 | 1233 | George Smith S000537 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 5 | |||||||||||||
1234 | 1234 | George Smith S000537 | rep | PA | 1811-11-04 | 1813-03-03 | Republican | 5 | |||||||||||||
1295 | 1295 | Robert Brown B000942 | rep | PA | 1797-05-15 | 1799-03-03 | Republican | 4 | |||||||||||||
1296 | 1296 | Robert Brown B000942 | rep | PA | 1799-12-02 | 1801-03-03 | Republican | 4 | |||||||||||||
1297 | 1297 | Robert Brown B000942 | rep | PA | 1801-12-07 | 1803-03-03 | Republican | 4 | |||||||||||||
1298 | 1298 | Robert Brown B000942 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 2 | |||||||||||||
1299 | 1299 | Robert Brown B000942 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
1300 | 1300 | Robert Brown B000942 | rep | PA | 1807-10-26 | 1809-03-03 | Republican | 2 | |||||||||||||
1301 | 1301 | Robert Brown B000942 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 2 | |||||||||||||
1302 | 1302 | Robert Brown B000942 | rep | PA | 1811-11-04 | 1813-03-03 | Republican | 2 | |||||||||||||
1303 | 1303 | Robert Brown B000942 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 6 | |||||||||||||
1310 | 1310 | John Conard C000667 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 1 | |||||||||||||
1312 | 1312 | Edward Crouch C000934 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 3 | |||||||||||||
1315 | 1315 | Roger Davis D000133 | rep | PA | 1811-11-04 | 1813-03-03 | Republican | 3 | |||||||||||||
1316 | 1316 | Roger Davis D000133 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 2 | |||||||||||||
1360 | 1360 | John Hyneman H001026 | rep | PA | 1811-11-04 | 1813-03-03 | Republican | 3 |
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);