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 end
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5086 | 5086 | William Woodbridge W000709 | rep | MI | 1819-12-06 | 1821-03-03 | Whig | -1 | |||||||||||||
2507 | 2507 | Albert Tracy T000343 | rep | NY | 1823-12-01 | 1825-03-03 | Whig | 30 | |||||||||||||
4375 | 4375 | Elisha Whittlesey W000431 | rep | OH | 1823-12-01 | 1825-03-03 | Whig | 13 | |||||||||||||
4549 | 4549 | Charles Mercer M000642 | rep | VA | 1823-12-01 | 1825-03-03 | Whig | 14 | |||||||||||||
4587 | 4587 | John Reed R000121 | rep | MA | 1823-12-01 | 1825-03-03 | Whig | 13 | |||||||||||||
4669 | 4669 | William Archer A000275 | rep | VA | 1823-12-01 | 1825-03-03 | Whig | 3 | |||||||||||||
5074 | 5074 | Lewis Williams W000527 | rep | NC | 1823-12-01 | 1825-03-03 | Whig | 13 | |||||||||||||
5774 | 5774 | Dudley Marvin M000208 | rep | NY | 1823-12-01 | 1825-03-03 | Whig | 26 | |||||||||||||
5882 | 5882 | Thomas Metcalfe M000676 | rep | KY | 1823-12-01 | 1825-03-03 | Whig | 2 | |||||||||||||
6155 | 6155 | Samuel Vinton V000107 | rep | OH | 1823-12-01 | 1825-03-03 | Whig | 7 | |||||||||||||
3805 | 3805 | Benjamin Swift S001116 | rep | VT | 1829-12-07 | 1831-03-03 | Whig | 4 | |||||||||||||
3880 | 3880 | Joseph Crane C000872 | rep | OH | 1829-12-07 | 1831-03-03 | Whig | 3 | |||||||||||||
4058 | 4058 | William Shepard S000331 | rep | NC | 1829-12-07 | 1831-03-03 | Whig | 1 | |||||||||||||
4214 | 4214 | George Grennell G000451 | rep | MA | 1829-12-07 | 1831-03-03 | Whig | 7 | |||||||||||||
4378 | 4378 | Elisha Whittlesey W000431 | rep | OH | 1829-12-07 | 1831-03-03 | Whig | 13 | |||||||||||||
4552 | 4552 | Charles Mercer M000642 | rep | VA | 1829-12-07 | 1831-03-03 | Whig | 14 | |||||||||||||
4590 | 4590 | John Reed R000121 | rep | MA | 1829-12-07 | 1831-03-03 | Whig | 13 | |||||||||||||
4616 | 4616 | William Storrs S000977 | rep | CT | 1829-12-07 | 1831-03-03 | Whig | -1 | |||||||||||||
4688 | 4688 | Isaac Bates B000233 | rep | MA | 1829-12-07 | 1831-03-03 | Whig | 8 | |||||||||||||
4773 | 4773 | George Evans E000241 | rep | ME | 1829-12-07 | 1831-03-03 | Whig | 4 | |||||||||||||
4780 | 4780 | Horace Everett E000265 | rep | VT | 1829-12-07 | 1831-03-03 | Whig | 3 | |||||||||||||
5060 | 5060 | Edward White W000365 | rep | LA | 1829-12-07 | 1831-03-03 | Whig | 1 | |||||||||||||
5077 | 5077 | Lewis Williams W000527 | rep | NC | 1829-12-07 | 1831-03-03 | Whig | 13 | |||||||||||||
5449 | 5449 | Jabez Huntington H000997 | rep | CT | 1829-12-07 | 1831-03-03 | Whig | -1 | |||||||||||||
5665 | 5665 | John Davis D000117 | rep | MA | 1829-12-07 | 1831-03-03 | Whig | 5 | |||||||||||||
6158 | 6158 | Samuel Vinton V000107 | rep | OH | 1829-12-07 | 1831-03-03 | Whig | 7 | |||||||||||||
6584 | 6584 | Edward Everett E000264 | rep | MA | 1829-12-07 | 1831-03-03 | Whig | 4 | |||||||||||||
3831 | 3831 | Chilton Allan A000108 | rep | KY | 1831-12-05 | 1833-03-03 | Whig | 3 | |||||||||||||
3881 | 3881 | Joseph Crane C000872 | rep | OH | 1831-12-05 | 1833-03-03 | Whig | 3 | |||||||||||||
4059 | 4059 | William Shepard S000331 | rep | NC | 1831-12-05 | 1833-03-03 | Whig | 1 | |||||||||||||
4126 | 4126 | Heman Allen A000123 | rep | VT | 1831-12-05 | 1833-03-03 | Whig | 4 | |||||||||||||
4215 | 4215 | George Grennell G000451 | rep | MA | 1831-12-05 | 1833-03-03 | Whig | 7 | |||||||||||||
4286 | 4286 | John Milligan M000767 | rep | DE | 1831-12-05 | 1833-03-03 | Whig | 0 | |||||||||||||
4379 | 4379 | Elisha Whittlesey W000431 | rep | OH | 1831-12-05 | 1833-03-03 | Whig | 13 | |||||||||||||
4553 | 4553 | Charles Mercer M000642 | rep | VA | 1831-12-05 | 1833-03-03 | Whig | 14 | |||||||||||||
4591 | 4591 | John Reed R000121 | rep | MA | 1831-12-05 | 1833-03-03 | Whig | 13 | |||||||||||||
4617 | 4617 | William Storrs S000977 | rep | CT | 1831-12-05 | 1833-03-03 | Whig | -1 | |||||||||||||
4689 | 4689 | Isaac Bates B000233 | rep | MA | 1831-12-05 | 1833-03-03 | Whig | 8 | |||||||||||||
4707 | 4707 | George Briggs B000830 | rep | MA | 1831-12-05 | 1833-03-03 | Whig | 9 | |||||||||||||
4741 | 4741 | Rufus Choate C000375 | rep | MA | 1831-12-05 | 1833-03-03 | Whig | 2 | |||||||||||||
4774 | 4774 | George Evans E000241 | rep | ME | 1831-12-05 | 1833-03-03 | Whig | 4 | |||||||||||||
4781 | 4781 | Horace Everett E000265 | rep | VT | 1831-12-05 | 1833-03-03 | Whig | 3 | |||||||||||||
4853 | 4853 | John Kerr K000139 | rep | MD | 1831-12-05 | 1833-03-03 | Whig | 7 | |||||||||||||
5061 | 5061 | Edward White W000365 | rep | LA | 1831-12-05 | 1833-03-03 | Whig | 1 | |||||||||||||
5078 | 5078 | Lewis Williams W000527 | rep | NC | 1831-12-05 | 1833-03-03 | Whig | 13 | |||||||||||||
5450 | 5450 | Jabez Huntington H000997 | rep | CT | 1831-12-05 | 1833-03-03 | Whig | -1 | |||||||||||||
5592 | 5592 | John Adams A000041 | rep | MA | 1831-12-05 | 1833-03-03 | Whig | 11 | |||||||||||||
5666 | 5666 | John Davis D000117 | rep | MA | 1831-12-05 | 1833-03-03 | Whig | 5 | |||||||||||||
6159 | 6159 | Samuel Vinton V000107 | rep | OH | 1831-12-05 | 1833-03-03 | Whig | 7 | |||||||||||||
6585 | 6585 | Edward Everett E000264 | rep | MA | 1831-12-05 | 1833-03-03 | Whig | 4 | |||||||||||||
7710 | 7710 | Thomas Corwin C000791 | rep | OH | 1831-12-05 | 1833-03-03 | Whig | 2 | |||||||||||||
3832 | 3832 | Chilton Allan A000108 | rep | KY | 1833-12-02 | 1835-03-03 | Whig | 10 | |||||||||||||
3882 | 3882 | Joseph Crane C000872 | rep | OH | 1833-12-02 | 1835-03-03 | Whig | 3 | |||||||||||||
3922 | 3922 | Benjamin Hardin H000184 | rep | KY | 1833-12-02 | 1835-03-03 | Whig | 7 | |||||||||||||
3924 | 3924 | James Harper H000221 | rep | PA | 1833-12-02 | 1835-03-03 | Whig | 2 | |||||||||||||
3979 | 3979 | Nehemiah Knight K000287 | sen | RI | 1829-12-07 | 1835-03-03 | 2 | Whig | |||||||||||||
4060 | 4060 | William Shepard S000331 | rep | NC | 1833-12-02 | 1835-03-03 | Whig | 1 | |||||||||||||
4067 | 4067 | David Spangler S000699 | rep | OH | 1833-12-02 | 1835-03-03 | Whig | 13 | |||||||||||||
4127 | 4127 | Heman Allen A000123 | rep | VT | 1833-12-02 | 1835-03-03 | Whig | 4 | |||||||||||||
4198 | 4198 | John Ewing E000277 | rep | IN | 1833-12-02 | 1835-03-03 | Whig | 2 | |||||||||||||
4216 | 4216 | George Grennell G000451 | rep | MA | 1833-12-02 | 1835-03-03 | Whig | 6 | |||||||||||||
4287 | 4287 | John Milligan M000767 | rep | DE | 1833-12-02 | 1835-03-03 | Whig | 0 | |||||||||||||
4319 | 4319 | Stephen Phillips P000312 | rep | MA | 1833-12-02 | 1835-03-03 | Whig | 2 | |||||||||||||
4336 | 4336 | John Robertson R000323 | rep | VA | 1833-12-02 | 1835-03-03 | Whig | 11 | |||||||||||||
4554 | 4554 | Charles Mercer M000642 | rep | VA | 1833-12-02 | 1835-03-03 | Whig | 14 | |||||||||||||
4592 | 4592 | John Reed R000121 | rep | MA | 1833-12-02 | 1835-03-03 | Whig | 11 | |||||||||||||
4690 | 4690 | Isaac Bates B000233 | rep | MA | 1833-12-02 | 1835-03-03 | Whig | 8 | |||||||||||||
4708 | 4708 | George Briggs B000830 | rep | MA | 1833-12-02 | 1835-03-03 | Whig | 7 | |||||||||||||
4742 | 4742 | Rufus Choate C000375 | rep | MA | 1833-12-02 | 1835-03-03 | Whig | 2 | |||||||||||||
4775 | 4775 | George Evans E000241 | rep | ME | 1833-12-02 | 1835-03-03 | Whig | 4 | |||||||||||||
4782 | 4782 | Horace Everett E000265 | rep | VT | 1833-12-02 | 1835-03-03 | Whig | 3 | |||||||||||||
4816 | 4816 | Hiland Hall H000052 | rep | VT | 1833-12-02 | 1835-03-03 | Whig | 1 | |||||||||||||
4957 | 4957 | Abraham Rencher R000162 | rep | NC | 1833-12-02 | 1835-03-03 | Whig | 10 | |||||||||||||
5040 | 5040 | Joseph Trumbull T000391 | rep | CT | 1833-12-02 | 1835-03-03 | Whig | -1 | |||||||||||||
5062 | 5062 | Edward White W000365 | rep | LA | 1833-12-02 | 1835-03-03 | Whig | 1 | |||||||||||||
5079 | 5079 | Lewis Williams W000527 | rep | NC | 1833-12-02 | 1835-03-03 | Whig | 13 | |||||||||||||
5344 | 5344 | Henry Johnson J000137 | rep | LA | 1833-12-02 | 1835-03-03 | Whig | 1 | |||||||||||||
5428 | 5428 | James Graham G000355 | rep | NC | 1833-12-02 | 1835-03-03 | Whig | 12 | |||||||||||||
5451 | 5451 | Jabez Huntington H000997 | rep | CT | 1833-12-02 | 1835-03-03 | Whig | -1 | |||||||||||||
5667 | 5667 | John Davis D000117 | rep | MA | 1833-12-02 | 1835-03-03 | Whig | 5 | |||||||||||||
5958 | 5958 | Edmund Deberry D000181 | rep | NC | 1833-12-02 | 1835-03-03 | Whig | 7 | |||||||||||||
6117 | 6117 | Augustine Shepperd S000338 | rep | NC | 1833-12-02 | 1835-03-03 | Whig | 9 | |||||||||||||
6160 | 6160 | Samuel Vinton V000107 | rep | OH | 1833-12-02 | 1835-03-03 | Whig | 6 | |||||||||||||
6204 | 6204 | Millard Fillmore F000115 | rep | NY | 1833-12-02 | 1835-03-03 | Whig | 32 | |||||||||||||
6586 | 6586 | Edward Everett E000264 | rep | MA | 1833-12-02 | 1835-03-03 | Whig | 4 | |||||||||||||
7711 | 7711 | Thomas Corwin C000791 | rep | OH | 1833-12-02 | 1835-03-03 | Whig | 4 | |||||||||||||
3833 | 3833 | Chilton Allan A000108 | rep | KY | 1835-12-07 | 1837-03-03 | Whig | 10 | |||||||||||||
3840 | 3840 | Jeremiah Bailey B000040 | rep | ME | 1835-12-07 | 1837-03-03 | Whig | 3 | |||||||||||||
3867 | 3867 | William Chetwood C000349 | rep | NJ | 1835-12-07 | 1837-03-03 | Whig | -1 | |||||||||||||
3883 | 3883 | Joseph Crane C000872 | rep | OH | 1835-12-07 | 1837-03-03 | Whig | 3 | |||||||||||||
3906 | 3906 | Philo Fuller F000411 | rep | NY | 1835-12-07 | 1837-03-03 | Whig | 30 | |||||||||||||
3912 | 3912 | Robert Goldsborough G000264 | sen | MD | 1835-12-07 | 1837-03-03 | 3 | Whig | |||||||||||||
3918 | 3918 | Gideon Hard H000180 | rep | NY | 1835-12-07 | 1837-03-03 | Whig | 33 | |||||||||||||
3923 | 3923 | Benjamin Hardin H000184 | rep | KY | 1835-12-07 | 1837-03-03 | Whig | 7 | |||||||||||||
3925 | 3925 | James Harper H000221 | rep | PA | 1835-12-07 | 1837-03-03 | Whig | 2 | |||||||||||||
3932 | 3932 | Abner Hazeltine H000416 | rep | NY | 1835-12-07 | 1837-03-03 | Whig | 31 | |||||||||||||
3938 | 3938 | Samuel Hoar H000656 | rep | MA | 1835-12-07 | 1837-03-03 | Whig | 4 | |||||||||||||
3939 | 3939 | Elias Howell H000861 | rep | OH | 1835-12-07 | 1837-03-03 | Whig | 12 | |||||||||||||
3989 | 3989 | George Lay L000150 | rep | NY | 1835-12-07 | 1837-03-03 | Whig | 29 | |||||||||||||
3996 | 3996 | Thomas Love L000459 | rep | NY | 1835-12-07 | 1837-03-03 | Whig | 32 |
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);