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 party
This data as json, copyable, CSV (advanced)
Suggested facets: class, 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 | ||||||||||||||
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 | ||||||||||||||
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 | ||||||||||||||
1768 | 1768 | Jonathan Williams W000523 | rep | PA | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
2232 | 2232 | James Duncan D000531 | rep | PA | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
2381 | 2381 | Samuel Breck B000783 | rep | PA | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
2383 | 2383 | John Brown B000926 | rep | PA | 1823-12-01 | 1825-03-03 | 12 | ||||||||||||||
2409 | 2409 | William Ellis E000137 | rep | PA | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
2410 | 2410 | William Ellis E000137 | rep | PA | 1823-12-01 | 1825-03-03 | 9 | ||||||||||||||
2413 | 2413 | Walter Forward F000291 | rep | PA | 1823-12-01 | 1825-03-03 | 16 | ||||||||||||||
2528 | 2528 | Isaac Wayne W000217 | rep | PA | 1823-12-01 | 1825-03-03 | 4 | ||||||||||||||
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 | ||||||||||||||
2588 | 2588 | Samuel Edwards E000080 | rep | PA | 1823-12-01 | 1825-03-03 | 4 | ||||||||||||||
2598 | 2598 | Patrick Farrelly F000032 | rep | PA | 1823-12-01 | 1825-03-03 | 18 | ||||||||||||||
2601 | 2601 | John Findlay F000120 | rep | PA | 1823-12-01 | 1825-03-03 | 11 | ||||||||||||||
2622 | 2622 | Robert Harris H000250 | rep | PA | 1823-12-01 | 1825-03-03 | 6 | ||||||||||||||
2680 | 2680 | Philip Markley M000135 | rep | PA | 1823-12-01 | 1825-03-03 | 5 | ||||||||||||||
2692 | 2692 | James Mitchell M000816 | rep | PA | 1823-12-01 | 1825-03-03 | 10 | ||||||||||||||
2698 | 2698 | George Plumer P000392 | rep | PA | 1823-12-01 | 1825-03-03 | 17 | ||||||||||||||
2727 | 2727 | Alexander Thomson T000227 | rep | PA | 1823-12-01 | 1825-03-03 | 13 | ||||||||||||||
2737 | 2737 | Henry Wilson W000584 | rep | PA | 1823-12-01 | 1825-03-03 | 7 | ||||||||||||||
2866 | 2866 | George Kremer K000329 | rep | PA | 1823-12-01 | 1825-03-03 | 9 | ||||||||||||||
2995 | 2995 | James Wilson W000588 | rep | PA | 1823-12-01 | 1825-03-03 | 11 | ||||||||||||||
3205 | 3205 | Thomas Sill S000410 | rep | PA | 1829-12-07 | 1831-03-03 | 18 | ||||||||||||||
3271 | 3271 | George Wolf W000673 | rep | PA | 1823-12-01 | 1825-03-03 | 8 | ||||||||||||||
3630 | 3630 | George Burd B001073 | rep | PA | 1831-12-05 | 1833-03-03 | 13 | ||||||||||||||
3631 | 3631 | George Burd B001073 | rep | PA | 1833-12-02 | 1835-03-03 | 18 | ||||||||||||||
2649 | 2649 | Thomas Kittera K000254 | rep | PA | 1825-12-05 | 1827-03-03 | Adams | 2 | |||||||||||||
2681 | 2681 | Philip Markley M000135 | rep | PA | 1825-12-05 | 1827-03-03 | Adams | 5 | |||||||||||||
2682 | 2682 | William Marks M000137 | sen | PA | 1825-12-05 | 1831-03-03 | 3 | Adams | |||||||||||||
2770 | 2770 | Samuel Anderson A000231 | rep | PA | 1827-12-03 | 1829-03-03 | Adams | 4 | |||||||||||||
2905 | 2905 | Charles Miner M000791 | rep | PA | 1825-12-05 | 1827-03-03 | Adams | 4 | |||||||||||||
2906 | 2906 | Charles Miner M000791 | rep | PA | 1827-12-03 | 1829-03-03 | Adams | 4 | |||||||||||||
2996 | 2996 | James Wilson W000588 | rep | PA | 1825-12-05 | 1827-03-03 | Adams | 11 | |||||||||||||
2997 | 2997 | James Wilson W000588 | rep | PA | 1827-12-03 | 1829-03-03 | Adams | 11 | |||||||||||||
3204 | 3204 | Thomas Sill S000410 | rep | PA | 1825-12-05 | 1827-03-03 | Adams | 18 | |||||||||||||
4855 | 4855 | Joseph Lawrence L000137 | rep | PA | 1825-12-05 | 1827-03-03 | Adams | 15 | |||||||||||||
4856 | 4856 | Joseph Lawrence L000137 | rep | PA | 1827-12-03 | 1829-03-03 | Adams | 15 | |||||||||||||
4993 | 4993 | John Sergeant S000246 | rep | PA | 1827-12-03 | 1829-03-03 | Adams | 2 | |||||||||||||
5831 | 5831 | Andrew Stewart S000899 | rep | PA | 1827-12-03 | 1829-03-03 | Adams | 14 | |||||||||||||
5372 | 5372 | John Campbell C000093 | rep | PA | 1845-12-01 | 1847-03-03 | American | 3 | |||||||||||||
6043 | 6043 | Lewis Levin L000262 | rep | PA | 1845-12-01 | 1847-03-03 | American | 1 | |||||||||||||
6044 | 6044 | Lewis Levin L000262 | rep | PA | 1847-12-06 | 1849-03-03 | American | 1 | |||||||||||||
6045 | 6045 | Lewis Levin L000262 | rep | PA | 1849-12-03 | 1851-03-03 | American | 1 | |||||||||||||
6779 | 6779 | Jacob Broom B000887 | rep | PA | 1855-12-03 | 1857-03-03 | American | 4 | |||||||||||||
3614 | 3614 | Horace Binney B000475 | rep | PA | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 2 | |||||||||||||
3814 | 3814 | John Watmough W000195 | rep | PA | 1831-12-05 | 1833-03-03 | Anti Jacksonian | 3 | |||||||||||||
3815 | 3815 | John Watmough W000195 | rep | PA | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 3 | |||||||||||||
5829 | 5829 | Andrew Stewart S000899 | rep | PA | 1823-12-01 | 1825-03-03 | Anti Mason | 14 | |||||||||||||
3296 | 3296 | Robert Allison A000159 | rep | PA | 1831-12-05 | 1833-03-03 | Anti Masonic | 12 | |||||||||||||
3602 | 3602 | Charles Barnitz B000165 | rep | PA | 1833-12-02 | 1835-03-03 | Anti Masonic | 11 | |||||||||||||
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 | |||||||||||||
3864 | 3864 | George Chambers C000283 | rep | PA | 1833-12-02 | 1835-03-03 | Anti Masonic | 12 | |||||||||||||
3865 | 3865 | George Chambers C000283 | rep | PA | 1835-12-07 | 1837-03-03 | Anti Masonic | 12 | |||||||||||||
3874 | 3874 | William Clark C000453 | rep | PA | 1833-12-02 | 1835-03-03 | Anti Masonic | 10 | |||||||||||||
3875 | 3875 | William Clark C000453 | rep | PA | 1835-12-07 | 1837-03-03 | Anti Masonic | 10 | |||||||||||||
3889 | 3889 | Harmar Denny D000248 | rep | PA | 1829-12-07 | 1831-03-03 | Anti Masonic | 16 | |||||||||||||
3890 | 3890 | Harmar Denny D000248 | rep | PA | 1831-12-05 | 1833-03-03 | Anti Masonic | 16 | |||||||||||||
3891 | 3891 | Harmar Denny D000248 | rep | PA | 1833-12-02 | 1835-03-03 | Anti Masonic | 22 | |||||||||||||
3892 | 3892 | Harmar Denny D000248 | rep | PA | 1835-12-07 | 1837-03-03 | Anti Masonic | 22 | |||||||||||||
3935 | 3935 | William Hiester H000575 | rep | PA | 1831-12-05 | 1833-03-03 | Anti Masonic | 4 | |||||||||||||
3936 | 3936 | William Hiester H000575 | rep | PA | 1833-12-02 | 1835-03-03 | Anti Masonic | 4 | |||||||||||||
3937 | 3937 | William Hiester H000575 | rep | PA | 1835-12-07 | 1837-03-03 | Anti Masonic | 4 | |||||||||||||
4191 | 4191 | Edward Darlington D000056 | rep | PA | 1833-12-02 | 1835-03-03 | Anti Masonic | 4 | |||||||||||||
4192 | 4192 | Edward Darlington D000056 | rep | PA | 1835-12-07 | 1837-03-03 | Anti Masonic | 4 | |||||||||||||
4193 | 4193 | Edward Darlington D000056 | rep | PA | 1837-09-04 | 1839-03-03 | Anti Masonic | 4 | |||||||||||||
4322 | 4322 | David, Potts P000472 | rep | PA | 1831-12-05 | 1833-03-03 | Anti Masonic | 4 | |||||||||||||
4323 | 4323 | David, Potts P000472 | rep | PA | 1833-12-02 | 1835-03-03 | Anti Masonic | 4 | |||||||||||||
4324 | 4324 | David, Potts P000472 | rep | PA | 1835-12-07 | 1837-03-03 | Anti Masonic | 4 | |||||||||||||
4325 | 4325 | David, Potts P000472 | rep | PA | 1837-09-04 | 1839-03-03 | Anti Masonic | 4 | |||||||||||||
4403 | 4403 | Richard Biddle B000443 | rep | PA | 1837-09-04 | 1839-03-03 | Anti Masonic | 22 | |||||||||||||
4404 | 4404 | Richard Biddle B000443 | rep | PA | 1839-12-02 | 1841-03-03 | Anti Masonic | 22 | |||||||||||||
4452 | 4452 | Edward Davies D000088 | rep | PA | 1837-09-04 | 1839-03-03 | Anti Masonic | 4 | |||||||||||||
4453 | 4453 | Edward Davies D000088 | rep | PA | 1839-12-02 | 1841-03-03 | Anti Masonic | 4 | |||||||||||||
4769 | 4769 | John Edwards E000074 | rep | PA | 1839-12-02 | 1841-03-03 | Anti Masonic | 4 | |||||||||||||
4830 | 4830 | Thomas Henry H000518 | rep | PA | 1837-09-04 | 1839-03-03 | Anti Masonic | 24 | |||||||||||||
4831 | 4831 | Thomas Henry H000518 | rep | PA | 1839-12-02 | 1841-03-03 | Anti Masonic | 24 | |||||||||||||
4841 | 4841 | Francis James J000049 | rep | PA | 1839-12-02 | 1841-03-03 | Anti Masonic | 4 | |||||||||||||
4891 | 4891 | Thomas McKennan M000501 | rep | PA | 1831-12-05 | 1833-03-03 | Anti Masonic | 15 | |||||||||||||
4892 | 4892 | Thomas McKennan M000501 | rep | PA | 1833-12-02 | 1835-03-03 | Anti Masonic | 21 | |||||||||||||
4893 | 4893 | Thomas McKennan M000501 | rep | PA | 1835-12-07 | 1837-03-03 | Anti Masonic | 21 | |||||||||||||
4894 | 4894 | Thomas McKennan M000501 | rep | PA | 1837-09-04 | 1839-03-03 | Anti Masonic | 21 | |||||||||||||
4924 | 4924 | Charles Ogle O000047 | rep | PA | 1837-09-04 | 1839-03-03 | Anti Masonic | 18 | |||||||||||||
4925 | 4925 | Charles Ogle O000047 | rep | PA | 1839-12-02 | 1841-03-03 | Anti Masonic | 18 | |||||||||||||
5832 | 5832 | Andrew Stewart S000899 | rep | PA | 1831-12-05 | 1833-03-03 | Anti Masonic | 14 | |||||||||||||
5833 | 5833 | Andrew Stewart S000899 | rep | PA | 1833-12-02 | 1835-03-03 | Anti Masonic | 20 | |||||||||||||
20 | 20 | William Maclay M000031 | sen | PA | 1789-03-04 | 1791-03-03 | 1 | Anti-Administration |
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);