legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,208 rows where party = "Whig" sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: start (date), end (date)
state 30 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5588 | 5588 | Amos Abbott A000004 | rep | MA | 1843-12-04 | 1845-03-03 | Whig | 3 | |||||||||||||
5589 | 5589 | Amos Abbott A000004 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 3 | |||||||||||||
5590 | 5590 | Amos Abbott A000004 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 3 | |||||||||||||
6486 | 6486 | James Abercrombie A000012 | rep | AL | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
6487 | 6487 | James Abercrombie A000012 | rep | AL | 1853-12-05 | 1855-03-03 | Whig | 2 | |||||||||||||
7272 | 7272 | Green Adams A000036 | rep | KY | 1847-12-06 | 1849-03-03 | Whig | 6 | |||||||||||||
5592 | 5592 | John Adams A000041 | rep | MA | 1831-12-05 | 1833-03-03 | Whig | 11 | |||||||||||||
5595 | 5595 | John Adams A000041 | rep | MA | 1837-09-04 | 1839-03-03 | Whig | 12 | |||||||||||||
5596 | 5596 | John Adams A000041 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 12 | |||||||||||||
5597 | 5597 | John Adams A000041 | rep | MA | 1841-05-31 | 1843-03-03 | Whig | 12 | |||||||||||||
5598 | 5598 | John Adams A000041 | rep | MA | 1843-12-04 | 1845-03-03 | Whig | 8 | |||||||||||||
5599 | 5599 | John Adams A000041 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 8 | |||||||||||||
5600 | 5600 | John Adams A000041 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 8 | |||||||||||||
5890 | 5890 | Henry Alexander A000093 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 17 | |||||||||||||
4125 | 4125 | James Alexander A000095 | rep | OH | 1837-09-04 | 1839-03-03 | Whig | 11 | |||||||||||||
4658 | 4658 | Julius Alford A000104 | rep | GA | 1835-12-07 | 1837-03-03 | Whig | -1 | |||||||||||||
4659 | 4659 | Julius Alford A000104 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
4660 | 4660 | Julius Alford A000104 | rep | GA | 1841-05-31 | 1843-03-03 | Whig | -1 | |||||||||||||
3831 | 3831 | Chilton Allan A000108 | rep | KY | 1831-12-05 | 1833-03-03 | Whig | 3 | |||||||||||||
3832 | 3832 | Chilton Allan A000108 | rep | KY | 1833-12-02 | 1835-03-03 | Whig | 10 | |||||||||||||
3833 | 3833 | Chilton Allan A000108 | rep | KY | 1835-12-07 | 1837-03-03 | Whig | 10 | |||||||||||||
4661 | 4661 | Elisha Allen A000120 | rep | ME | 1841-05-31 | 1843-03-03 | Whig | 8 | |||||||||||||
4126 | 4126 | Heman Allen A000123 | rep | VT | 1831-12-05 | 1833-03-03 | Whig | 4 | |||||||||||||
4127 | 4127 | Heman Allen A000123 | rep | VT | 1833-12-02 | 1835-03-03 | Whig | 4 | |||||||||||||
4128 | 4128 | Heman Allen A000123 | rep | VT | 1835-12-07 | 1837-03-03 | Whig | 4 | |||||||||||||
4129 | 4129 | Heman Allen A000123 | rep | VT | 1837-09-04 | 1839-03-03 | Whig | 4 | |||||||||||||
4391 | 4391 | John Allen A000135 | rep | OH | 1837-09-04 | 1839-03-03 | Whig | 15 | |||||||||||||
4392 | 4392 | John Allen A000135 | rep | OH | 1839-12-02 | 1841-03-03 | Whig | 15 | |||||||||||||
6755 | 6755 | John Allison A000158 | rep | PA | 1851-12-01 | 1853-03-03 | Whig | 20 | |||||||||||||
5891 | 5891 | William Alston A000166 | rep | AL | 1849-12-03 | 1851-03-03 | Whig | 1 | |||||||||||||
4394 | 4394 | James Alvord A000168 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 6 | |||||||||||||
5892 | 5892 | Josiah Anderson A000199 | rep | TN | 1849-12-03 | 1851-03-03 | Whig | 3 | |||||||||||||
4397 | 4397 | Simeon Anderson A000232 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 5 | |||||||||||||
5893 | 5893 | George Andrews A000245 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 14 | |||||||||||||
4662 | 4662 | Landaff Andrews A000247 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 11 | |||||||||||||
4663 | 4663 | Landaff Andrews A000247 | rep | KY | 1841-05-31 | 1843-03-03 | Whig | 11 | |||||||||||||
4664 | 4664 | Sherlock Andrews A000249 | rep | OH | 1841-05-31 | 1843-03-03 | Whig | 15 | |||||||||||||
4666 | 4666 | Nathan Appleton A000269 | rep | MA | 1841-05-31 | 1843-03-03 | Whig | 1 | |||||||||||||
7654 | 7654 | William Appleton A000270 | rep | MA | 1851-12-01 | 1853-03-03 | Whig | 1 | |||||||||||||
7655 | 7655 | William Appleton A000270 | rep | MA | 1853-12-05 | 1855-03-03 | Whig | 5 | |||||||||||||
4669 | 4669 | William Archer A000275 | rep | VA | 1823-12-01 | 1825-03-03 | Whig | 3 | |||||||||||||
4675 | 4675 | William Archer A000275 | sen | VA | 1841-05-31 | 1847-03-03 | 2 | Whig | |||||||||||||
5357 | 5357 | Lemuel Arnold A000291 | rep | RI | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
4677 | 4677 | Thomas Arnold A000297 | rep | TN | 1841-05-31 | 1843-03-03 | Whig | 1 | |||||||||||||
5117 | 5117 | John Ashe A000308 | rep | TN | 1843-12-04 | 1845-03-03 | Whig | 10 | |||||||||||||
5894 | 5894 | George Ashmun A000318 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 6 | |||||||||||||
5895 | 5895 | George Ashmun A000318 | rep | MA | 1847-12-06 | 1849-03-03 | Whig | 6 | |||||||||||||
5896 | 5896 | George Ashmun A000318 | rep | MA | 1849-12-03 | 1851-03-03 | Whig | 6 | |||||||||||||
4678 | 4678 | John Aycrigg A000350 | rep | NJ | 1837-09-04 | 1839-03-03 | Whig | -1 | |||||||||||||
4679 | 4679 | John Aycrigg A000350 | rep | NJ | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
4680 | 4680 | John Aycrigg A000350 | rep | NJ | 1841-05-31 | 1843-03-03 | Whig | -1 | |||||||||||||
4681 | 4681 | Alfred Babcock B000003 | rep | NY | 1841-05-31 | 1843-03-03 | Whig | 33 | |||||||||||||
5899 | 5899 | George Badger B000022 | sen | NC | 1846-01-01 | 1849-03-03 | 3 | Whig | |||||||||||||
5900 | 5900 | George Badger B000022 | sen | NC | 1849-12-03 | 1855-03-03 | 3 | Whig | |||||||||||||
3840 | 3840 | Jeremiah Bailey B000040 | rep | ME | 1835-12-07 | 1837-03-03 | Whig | 3 | |||||||||||||
7642 | 7642 | Edward Baker B000059 | rep | IL | 1845-12-01 | 1847-03-03 | Whig | 7 | |||||||||||||
7643 | 7643 | Edward Baker B000059 | rep | IL | 1849-12-03 | 1851-03-03 | Whig | 6 | |||||||||||||
5120 | 5120 | Osmyn Baker B000071 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 6 | |||||||||||||
5121 | 5121 | Osmyn Baker B000071 | rep | MA | 1841-05-31 | 1843-03-03 | Whig | 6 | |||||||||||||
5122 | 5122 | Osmyn Baker B000071 | rep | MA | 1843-12-04 | 1845-03-03 | Whig | 6 | |||||||||||||
5606 | 5606 | Roger Baldwin B000096 | sen | CT | 1847-12-06 | 1851-03-03 | 1 | Whig | |||||||||||||
6758 | 6758 | Edward Ball B000098 | rep | OH | 1853-12-05 | 1855-03-03 | Whig | 16 | |||||||||||||
5124 | 5124 | Daniel Barnard B000152 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 10 | |||||||||||||
5125 | 5125 | Daniel Barnard B000152 | rep | NY | 1841-05-31 | 1843-03-03 | Whig | 10 | |||||||||||||
5126 | 5126 | Daniel Barnard B000152 | rep | NY | 1843-12-04 | 1845-03-03 | Whig | 13 | |||||||||||||
6215 | 6215 | Nelson Barrere B000174 | rep | OH | 1851-12-01 | 1853-03-03 | Whig | 7 | |||||||||||||
5607 | 5607 | Daniel Barringer B000182 | rep | NC | 1843-12-04 | 1845-03-03 | Whig | 2 | |||||||||||||
5608 | 5608 | Daniel Barringer B000182 | rep | NC | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
5609 | 5609 | Daniel Barringer B000182 | rep | NC | 1847-12-06 | 1849-03-03 | Whig | 3 | |||||||||||||
4685 | 4685 | Alexander Barrow B000183 | sen | LA | 1841-05-31 | 1847-03-03 | 2 | Whig | |||||||||||||
5610 | 5610 | Washington Barrow B000185 | rep | TN | 1847-12-06 | 1849-03-03 | Whig | 8 | |||||||||||||
4686 | 4686 | Richard Barton B000214 | rep | VA | 1841-05-31 | 1843-03-03 | Whig | 15 | |||||||||||||
4688 | 4688 | Isaac Bates B000233 | rep | MA | 1829-12-07 | 1831-03-03 | Whig | 8 | |||||||||||||
4689 | 4689 | Isaac Bates B000233 | rep | MA | 1831-12-05 | 1833-03-03 | Whig | 8 | |||||||||||||
4690 | 4690 | Isaac Bates B000233 | rep | MA | 1833-12-02 | 1835-03-03 | Whig | 8 | |||||||||||||
4691 | 4691 | Isaac Bates B000233 | sen | MA | 1841-05-31 | 1845-12-31 | 2 | Whig | |||||||||||||
4692 | 4692 | Richard Bayard B000251 | sen | DE | 1836-06-17 | 1839-03-03 | 1 | Whig | |||||||||||||
4693 | 4693 | Richard Bayard B000251 | sen | DE | 1841-05-31 | 1845-03-03 | 1 | Whig | |||||||||||||
5613 | 5613 | Hiram Belcher B000321 | rep | ME | 1847-12-06 | 1849-03-03 | Whig | 3 | |||||||||||||
6221 | 6221 | Hiram Bell B000335 | rep | OH | 1851-12-01 | 1853-03-03 | Whig | 3 | |||||||||||||
5902 | 5902 | John Bell B000339 | rep | OH | 1849-12-03 | 1851-03-03 | Whig | 6 | |||||||||||||
6507 | 6507 | John Bell B000340 | rep | TN | 1835-12-07 | 1837-03-03 | Whig | 7 | |||||||||||||
6508 | 6508 | John Bell B000340 | rep | TN | 1837-09-04 | 1839-03-03 | Whig | 7 | |||||||||||||
6509 | 6509 | John Bell B000340 | rep | TN | 1839-12-02 | 1841-03-03 | Whig | 7 | |||||||||||||
6510 | 6510 | John Bell B000340 | sen | TN | 1847-12-06 | 1853-03-03 | 2 | Whig | |||||||||||||
5358 | 5358 | Joshua Bell B000343 | rep | KY | 1845-12-01 | 1847-03-03 | Whig | 4 | |||||||||||||
6976 | 6976 | Henry Bennett B000376 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 22 | |||||||||||||
6977 | 6977 | Henry Bennett B000376 | rep | NY | 1851-12-01 | 1853-03-03 | Whig | 22 | |||||||||||||
6978 | 6978 | Henry Bennett B000376 | rep | NY | 1853-12-05 | 1855-03-03 | Whig | 21 | |||||||||||||
6773 | 6773 | Samuel Benson B000390 | rep | ME | 1853-12-05 | 1855-03-03 | Whig | 4 | |||||||||||||
7661 | 7661 | John Bernhisel B000412 | rep | UT | 1851-12-01 | 1853-03-03 | Whig | -1 | |||||||||||||
7662 | 7662 | John Bernhisel B000412 | rep | UT | 1853-12-05 | 1855-03-03 | Whig | -1 | |||||||||||||
7663 | 7663 | John Bernhisel B000412 | rep | UT | 1855-12-03 | 1857-03-03 | Whig | -1 | |||||||||||||
7664 | 7664 | John Bernhisel B000412 | rep | UT | 1857-12-07 | 1859-03-03 | Whig | -1 | |||||||||||||
7665 | 7665 | John Bernhisel B000412 | rep | UT | 1861-07-04 | 1863-03-03 | Whig | -1 | |||||||||||||
5615 | 5615 | John Berrien B000413 | sen | GA | 1841-05-31 | 1847-03-03 | 2 | Whig | |||||||||||||
5616 | 5616 | John Berrien B000413 | sen | GA | 1847-12-06 | 1853-03-03 | 2 | Whig | |||||||||||||
4402 | 4402 | Thaddeus Betts B000428 | sen | CT | 1839-12-02 | 1841-03-03 | 1 | Whig | |||||||||||||
6222 | 6222 | Thomas Bibighaus B000435 | rep | PA | 1851-12-01 | 1853-03-03 | Whig | 14 | |||||||||||||
4696 | 4696 | Victory Birdseye B000484 | rep | NY | 1841-05-31 | 1843-03-03 | Whig | 23 |
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);