legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
3,270 rows where state = "PA"
This data as json, copyable, CSV (advanced)
party 22 ✖
- Republican 1,759
- Democrat 1,015
- Jackson 124
- Whig 105
- Anti Masonic 39
- Federalist 35
- Ind. Republican-Democrat 17
- Adams 13
- Ind. Republican 8
- American 5
- National Greenbacker 5
- Anti Jacksonian 3
- Jacksonian 3
- Progressive 3
- Anti-Administration 2
- Anti-Lecompton Democrat 2
- Ind. Democrat 2
- Anti Mason 1
- Democratic Republican 1
- Free Soil 1
- Independent 1
- Jackson Republican 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
862 | 862 | James Kelly K000073 | rep | PA | 1805-12-02 | 1807-03-03 | Federalist | 6 | |||||||||||||
863 | 863 | James Kelly K000073 | rep | PA | 1807-10-26 | 1809-03-03 | Federalist | 6 | |||||||||||||
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 | |||||||||||||
999 | 999 | Robert Jenkins J000087 | rep | PA | 1807-10-26 | 1809-03-03 | Federalist | 3 | |||||||||||||
1000 | 1000 | Robert Jenkins J000087 | rep | PA | 1809-05-22 | 1811-03-03 | Federalist | 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 | |||||||||||||
1193 | 1193 | James Milnor M000785 | rep | PA | 1811-11-04 | 1813-03-03 | Federalist | 1 | |||||||||||||
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 | |||||||||||||
1344 | 1344 | John Gloninger G000241 | rep | PA | 1813-05-24 | 1815-03-03 | Federalist | 3 | |||||||||||||
1351 | 1351 | Samuel Henderson H000487 | rep | PA | 1813-05-24 | 1815-03-03 | Federalist | 2 | |||||||||||||
1360 | 1360 | John Hyneman H001026 | rep | PA | 1811-11-04 | 1813-03-03 | Republican | 3 | |||||||||||||
1361 | 1361 | John Hyneman H001026 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 7 | |||||||||||||
1370 | 1370 | Abner Lacock L000011 | rep | PA | 1811-11-04 | 1813-03-03 | Republican | 11 | |||||||||||||
1371 | 1371 | Abner Lacock L000011 | sen | PA | 1813-05-24 | 1819-03-03 | 3 | Republican | |||||||||||||
1388 | 1388 | John Rea R000089 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 7 | |||||||||||||
1389 | 1389 | John Rea R000089 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 7 | |||||||||||||
1390 | 1390 | John Rea R000089 | rep | PA | 1807-10-26 | 1809-03-03 | Republican | 7 | |||||||||||||
1391 | 1391 | John Rea R000089 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 7 | |||||||||||||
1392 | 1392 | John Rea R000089 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 5 | |||||||||||||
1404 | 1404 | Amos Slaymaker S000483 | rep | PA | 1813-05-24 | 1815-03-03 | Federalist | 3 | |||||||||||||
1405 | 1405 | Isaac Smith S000556 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 10 | |||||||||||||
1421 | 1421 | Adamson Tannehill T000036 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 14 | |||||||||||||
1426 | 1426 | James Whitehill W000402 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 3 | |||||||||||||
1427 | 1427 | Robert Whitehill W000404 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 4 | |||||||||||||
1428 | 1428 | Robert Whitehill W000404 | rep | PA | 1807-10-26 | 1809-03-03 | Republican | 4 | |||||||||||||
1429 | 1429 | Robert Whitehill W000404 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 4 | |||||||||||||
1430 | 1430 | Robert Whitehill W000404 | rep | PA | 1811-11-04 | 1813-03-03 | Republican | 4 | |||||||||||||
1431 | 1431 | Robert Whitehill W000404 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | -1 | |||||||||||||
1438 | 1438 | Jonathan Roberts R000313 | rep | PA | 1811-11-04 | 1813-03-03 | Republican | 2 | |||||||||||||
1439 | 1439 | Jonathan Roberts R000313 | rep | PA | 1813-05-24 | 1814-02-24 | Republican | 2 | |||||||||||||
1440 | 1440 | Jonathan Roberts R000313 | sen | PA | 1814-02-24 | 1815-03-03 | 1 | Republican | |||||||||||||
1441 | 1441 | Jonathan Roberts R000313 | sen | PA | 1815-12-04 | 1821-03-03 | 1 | Republican | |||||||||||||
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 | |||||||||||||
1480 | 1480 | Thomas Burnside B001132 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 9 | |||||||||||||
1526 | 1526 | William Crawford C000894 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 6 | |||||||||||||
1527 | 1527 | William Crawford C000894 | rep | PA | 1811-11-04 | 1813-03-03 | Republican | 6 | |||||||||||||
1528 | 1528 | William Crawford C000894 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 5 | |||||||||||||
1529 | 1529 | William Crawford C000894 | rep | PA | 1815-12-04 | 1817-03-03 | Republican | 5 | |||||||||||||
1553 | 1553 | William Findley F000124 | rep | PA | 1791-10-24 | 1793-03-03 | Anti-Administration | 8 | |||||||||||||
1554 | 1554 | William Findley F000124 | rep | PA | 1793-12-02 | 1795-03-03 | Anti-Administration | -1 | |||||||||||||
1555 | 1555 | William Findley F000124 | rep | PA | 1795-12-07 | 1797-03-03 | Republican | 11 | |||||||||||||
1556 | 1556 | William Findley F000124 | rep | PA | 1797-05-15 | 1799-03-03 | Republican | 11 | |||||||||||||
1557 | 1557 | William Findley F000124 | rep | PA | 1803-10-17 | 1805-03-03 | Republican | 8 | |||||||||||||
1558 | 1558 | William Findley F000124 | rep | PA | 1805-12-02 | 1807-03-03 | Republican | 8 | |||||||||||||
1559 | 1559 | William Findley F000124 | rep | PA | 1807-10-26 | 1809-03-03 | Republican | 8 | |||||||||||||
1560 | 1560 | William Findley F000124 | rep | PA | 1809-05-22 | 1811-03-03 | Republican | 8 | |||||||||||||
1561 | 1561 | William Findley F000124 | rep | PA | 1811-11-04 | 1813-03-03 | Republican | 8 | |||||||||||||
1562 | 1562 | William Findley F000124 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 11 |
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);