legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
105 rows where party = "Whig" and state = "PA"
This data as json, copyable, CSV (advanced)
Suggested facets: start, end, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3924 | 3924 | James Harper H000221 | rep | PA | 1833-12-02 | 1835-03-03 | Whig | 2 | |||||||||||||
3925 | 3925 | James Harper H000221 | rep | PA | 1835-12-07 | 1837-03-03 | Whig | 2 | |||||||||||||
4036 | 4036 | John Pearson P000167 | rep | PA | 1835-12-07 | 1837-03-03 | Whig | 24 | |||||||||||||
4294 | 4294 | Mathias Morris M000984 | rep | PA | 1835-12-07 | 1837-03-03 | Whig | 6 | |||||||||||||
4295 | 4295 | Mathias Morris M000984 | rep | PA | 1837-09-04 | 1839-03-03 | Whig | 6 | |||||||||||||
4408 | 4408 | Henry Brackenridge B000732 | rep | PA | 1839-12-02 | 1841-03-03 | Whig | 22 | |||||||||||||
4566 | 4566 | Charles Naylor N000011 | rep | PA | 1837-09-04 | 1839-03-03 | Whig | 3 | |||||||||||||
4567 | 4567 | Charles Naylor N000011 | rep | PA | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
4697 | 4697 | Henry Black B000498 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 18 | |||||||||||||
4770 | 4770 | John Edwards E000074 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 4 | |||||||||||||
4832 | 4832 | Thomas Henry H000518 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 24 | |||||||||||||
4839 | 4839 | William Irwin I000044 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 22 | |||||||||||||
4842 | 4842 | Francis James J000049 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 4 | |||||||||||||
4857 | 4857 | Joseph Lawrence L000137 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 21 | |||||||||||||
4895 | 4895 | Thomas McKennan M000501 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 21 | |||||||||||||
4926 | 4926 | Charles Ogle O000047 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 18 | |||||||||||||
4948 | 4948 | Robert Ramsey R000028 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 6 | |||||||||||||
4980 | 4980 | James Russell R000527 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 18 | |||||||||||||
4994 | 4994 | John Sergeant S000246 | rep | PA | 1837-09-04 | 1839-03-03 | Whig | 2 | |||||||||||||
4995 | 4995 | John Sergeant S000246 | rep | PA | 1839-12-02 | 1841-03-03 | Whig | 2 | |||||||||||||
4996 | 4996 | John Sergeant S000246 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 2 | |||||||||||||
5002 | 5002 | William Simonton S000427 | rep | PA | 1839-12-02 | 1841-03-03 | Whig | 10 | |||||||||||||
5003 | 5003 | William Simonton S000427 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 10 | |||||||||||||
5033 | 5033 | George Toland T000296 | rep | PA | 1837-09-04 | 1839-03-03 | Whig | 2 | |||||||||||||
5034 | 5034 | George Toland T000296 | rep | PA | 1839-12-02 | 1841-03-03 | Whig | 2 | |||||||||||||
5035 | 5035 | George Toland T000296 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 2 | |||||||||||||
5147 | 5147 | Jeremiah Brown B000925 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 4 | |||||||||||||
5148 | 5148 | Jeremiah Brown B000925 | rep | PA | 1843-12-04 | 1845-03-03 | Whig | 8 | |||||||||||||
5202 | 5202 | Henry Frick F000383 | rep | PA | 1843-12-04 | 1845-03-03 | Whig | 13 | |||||||||||||
5221 | 5221 | James Irvin I000033 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 14 | |||||||||||||
5222 | 5222 | James Irvin I000033 | rep | PA | 1843-12-04 | 1845-03-03 | Whig | 17 | |||||||||||||
5224 | 5224 | Michael Jenks J000092 | rep | PA | 1843-12-04 | 1845-03-03 | Whig | 6 | |||||||||||||
5275 | 5275 | Charles Reed R000110 | rep | PA | 1843-12-04 | 1845-03-03 | Whig | 23 | |||||||||||||
5370 | 5370 | Joseph Buffington B001041 | rep | PA | 1843-12-04 | 1845-03-03 | Whig | 24 | |||||||||||||
5371 | 5371 | Joseph Buffington B001041 | rep | PA | 1845-12-01 | 1847-03-03 | Whig | 24 | |||||||||||||
5397 | 5397 | Cornelius Darragh D000061 | rep | PA | 1843-12-04 | 1845-03-03 | Whig | 21 | |||||||||||||
5398 | 5398 | Cornelius Darragh D000061 | rep | PA | 1845-12-01 | 1847-03-03 | Whig | 21 | |||||||||||||
5419 | 5419 | John Ewing E000278 | rep | PA | 1845-12-01 | 1847-03-03 | Whig | 20 | |||||||||||||
5622 | 5622 | John Blanchard B000539 | rep | PA | 1845-12-01 | 1847-03-03 | Whig | 17 | |||||||||||||
5623 | 5623 | John Blanchard B000539 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 17 | |||||||||||||
5629 | 5629 | Jasper Brady B000754 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 16 | |||||||||||||
5671 | 5671 | John Dickey D000314 | rep | PA | 1843-12-04 | 1845-03-03 | Whig | 20 | |||||||||||||
5672 | 5672 | John Dickey D000314 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 20 | |||||||||||||
5683 | 5683 | George Eckert E000034 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 14 | |||||||||||||
5690 | 5690 | John Farrelly F000031 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 22 | |||||||||||||
5723 | 5723 | John Hornbeck H000790 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 6 | |||||||||||||
5738 | 5738 | Joseph Ingersoll I000019 | rep | PA | 1835-12-07 | 1837-03-03 | Whig | 2 | |||||||||||||
5739 | 5739 | Joseph Ingersoll I000019 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 2 | |||||||||||||
5740 | 5740 | Joseph Ingersoll I000019 | rep | PA | 1843-12-04 | 1845-03-03 | Whig | 2 | |||||||||||||
5741 | 5741 | Joseph Ingersoll I000019 | rep | PA | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
5742 | 5742 | Joseph Ingersoll I000019 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 2 | |||||||||||||
5743 | 5743 | Alexander Irvin I000032 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 24 | |||||||||||||
5781 | 5781 | Abraham McIlvaine M000474 | rep | PA | 1843-12-04 | 1845-03-03 | Whig | 7 | |||||||||||||
5782 | 5782 | Abraham McIlvaine M000474 | rep | PA | 1845-12-01 | 1847-03-03 | Whig | 7 | |||||||||||||
5783 | 5783 | Abraham McIlvaine M000474 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 7 | |||||||||||||
5805 | 5805 | James Pollock P000416 | rep | PA | 1843-12-04 | 1845-03-03 | Whig | 13 | |||||||||||||
5806 | 5806 | James Pollock P000416 | rep | PA | 1845-12-01 | 1847-03-03 | Whig | 13 | |||||||||||||
5807 | 5807 | James Pollock P000416 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 13 | |||||||||||||
5834 | 5834 | Andrew Stewart S000899 | rep | PA | 1843-12-04 | 1845-03-03 | Whig | 18 | |||||||||||||
5835 | 5835 | Andrew Stewart S000899 | rep | PA | 1845-12-01 | 1847-03-03 | Whig | 18 | |||||||||||||
5836 | 5836 | Andrew Stewart S000899 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 18 | |||||||||||||
5837 | 5837 | John Strohm S001008 | rep | PA | 1845-12-01 | 1847-03-03 | Whig | 8 | |||||||||||||
5838 | 5838 | John Strohm S001008 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 8 | |||||||||||||
5920 | 5920 | Chester Butler B001175 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 11 | |||||||||||||
5921 | 5921 | Chester Butler B001175 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 11 | |||||||||||||
5925 | 5925 | Samuel Calvin C000060 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 17 | |||||||||||||
5926 | 5926 | Joseph Casey C000224 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 13 | |||||||||||||
5946 | 5946 | James Cooper C000753 | rep | PA | 1839-12-02 | 1841-03-03 | Whig | 12 | |||||||||||||
5947 | 5947 | James Cooper C000753 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 12 | |||||||||||||
5948 | 5948 | James Cooper C000753 | sen | PA | 1849-12-03 | 1855-03-03 | 3 | Whig | |||||||||||||
5965 | 5965 | Jesse Dickey D000313 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 7 | |||||||||||||
5976 | 5976 | John Freedley F000360 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 5 | |||||||||||||
5977 | 5977 | John Freedley F000360 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 5 | |||||||||||||
5990 | 5990 | Moses Hampton H000139 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 21 | |||||||||||||
5991 | 5991 | Moses Hampton H000139 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 21 | |||||||||||||
6079 | 6079 | Henry Nes N000047 | rep | PA | 1847-12-06 | 1849-03-03 | Whig | 15 | |||||||||||||
6080 | 6080 | Henry Nes N000047 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 15 | |||||||||||||
6085 | 6085 | Andrew Ogle O000046 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 18 | |||||||||||||
6093 | 6093 | Charles Pitman P000369 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 14 | |||||||||||||
6099 | 6099 | Robert Reed R000126 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 20 | |||||||||||||
6222 | 6222 | Thomas Bibighaus B000435 | rep | PA | 1851-12-01 | 1853-03-03 | Whig | 14 | |||||||||||||
6335 | 6335 | John Howe H000853 | rep | PA | 1851-12-01 | 1853-03-03 | Whig | 22 | |||||||||||||
6351 | 6351 | Joseph Kuhns K000337 | rep | PA | 1851-12-01 | 1853-03-03 | Whig | 19 | |||||||||||||
6367 | 6367 | Henry Moore M000900 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 3 | |||||||||||||
6368 | 6368 | Henry Moore M000900 | rep | PA | 1851-12-01 | 1853-03-03 | Whig | 3 | |||||||||||||
6535 | 6535 | Joseph Chandler C000292 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
6536 | 6536 | Joseph Chandler C000292 | rep | PA | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
6537 | 6537 | Joseph Chandler C000292 | rep | PA | 1853-12-05 | 1855-03-03 | Whig | 2 | |||||||||||||
6588 | 6588 | William Everhart E000271 | rep | PA | 1853-12-05 | 1855-03-03 | Whig | 6 | |||||||||||||
6611 | 6611 | Isaac Hiester H000572 | rep | PA | 1853-12-05 | 1855-03-03 | Whig | 9 | |||||||||||||
6620 | 6620 | Thomas Howe H000854 | rep | PA | 1851-12-01 | 1853-03-03 | Whig | 21 | |||||||||||||
6621 | 6621 | Thomas Howe H000854 | rep | PA | 1853-12-05 | 1855-03-03 | Whig | 22 | |||||||||||||
6649 | 6649 | John McCulloch M000390 | rep | PA | 1853-12-05 | 1855-03-03 | Whig | 18 | |||||||||||||
6652 | 6652 | Ner Middleswarth M000695 | rep | PA | 1853-12-05 | 1855-03-03 | Whig | 10 | |||||||||||||
6683 | 6683 | Samuel Russell R000539 | rep | PA | 1853-12-05 | 1855-03-03 | Whig | 17 | |||||||||||||
6755 | 6755 | John Allison A000158 | rep | PA | 1851-12-01 | 1853-03-03 | Whig | 20 | |||||||||||||
6818 | 6818 | Henry Fuller F000410 | rep | PA | 1851-12-01 | 1853-03-03 | Whig | 11 | |||||||||||||
7200 | 7200 | David Ritchie R000273 | rep | PA | 1853-12-05 | 1855-03-03 | Whig | 21 | |||||||||||||
7380 | 7380 | John Dick D000303 | rep | PA | 1853-12-05 | 1855-03-03 | Whig | 25 | |||||||||||||
7383 | 7383 | John Dick D000303 | rep | PA | 1859-12-05 | 1861-03-03 | Whig | -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);