legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
129 rows where "end" is on date 1841-03-03 and party = "Whig"
This data as json, copyable, CSV (advanced)
Suggested facets: type, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3980 | 3980 | Nehemiah Knight K000287 | sen | RI | 1835-12-07 | 1841-03-03 | 2 | Whig | |||||||||||||
4105 | 4105 | Hugh White W000376 | sen | TN | 1835-12-07 | 1841-03-03 | 2 | Whig | |||||||||||||
4392 | 4392 | John Allen A000135 | rep | OH | 1839-12-02 | 1841-03-03 | Whig | 15 | |||||||||||||
4394 | 4394 | James Alvord A000168 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 6 | |||||||||||||
4397 | 4397 | Simeon Anderson A000232 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 5 | |||||||||||||
4402 | 4402 | Thaddeus Betts B000428 | sen | CT | 1839-12-02 | 1841-03-03 | 1 | Whig | |||||||||||||
4407 | 4407 | William Bond B000613 | rep | OH | 1839-12-02 | 1841-03-03 | Whig | 7 | |||||||||||||
4408 | 4408 | Henry Brackenridge B000732 | rep | PA | 1839-12-02 | 1841-03-03 | Whig | 22 | |||||||||||||
4409 | 4409 | Anson Brown B000901 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 11 | |||||||||||||
4421 | 4421 | William Carter C000204 | rep | TN | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
4424 | 4424 | Thomas Chinn C000363 | rep | LA | 1839-12-02 | 1841-03-03 | Whig | 2 | |||||||||||||
4437 | 4437 | George Crabb C000847 | rep | AL | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
4447 | 4447 | John Crockett C000920 | rep | TN | 1839-12-02 | 1841-03-03 | Whig | 12 | |||||||||||||
4449 | 4449 | Edward Curtis C001009 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
4457 | 4457 | John Dennis D000244 | rep | MD | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
4462 | 4462 | Nicholas Doe D000398 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 11 | |||||||||||||
4482 | 4482 | Rice Garland G000070 | rep | LA | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
4485 | 4485 | William Graves G000392 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 8 | |||||||||||||
4491 | 4491 | Moses Grinnell G000479 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
4504 | 4504 | Richard Hawes H000363 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 10 | |||||||||||||
4512 | 4512 | John Hill H000595 | rep | VA | 1839-12-02 | 1841-03-03 | Whig | 5 | |||||||||||||
4515 | 4515 | Josiah Hoffman H000687 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
4517 | 4517 | Hines Holt H000745 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
4524 | 4524 | Daniel Jenifer J000078 | rep | MD | 1839-12-02 | 1841-03-03 | Whig | 7 | |||||||||||||
4525 | 4525 | Charles Johnston J000184 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 5 | |||||||||||||
4530 | 4530 | Thomas Kempshall K000087 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 28 | |||||||||||||
4533 | 4533 | Abbott Lawrence L000130 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
4541 | 4541 | Richard Marvin M000211 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 31 | |||||||||||||
4542 | 4542 | William McCarty M000322 | rep | VA | 1839-12-02 | 1841-03-03 | Whig | 14 | |||||||||||||
4557 | 4557 | Charles Mercer M000642 | rep | VA | 1839-12-02 | 1841-03-03 | Whig | 14 | |||||||||||||
4559 | 4559 | Charles Mitchell M000806 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 33 | |||||||||||||
4560 | 4560 | James Monroe M000856 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
4567 | 4567 | Charles Naylor N000011 | rep | PA | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
4568 | 4568 | Rufus Palen P000032 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 7 | |||||||||||||
4574 | 4574 | Luther Peck P000179 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 30 | |||||||||||||
4583 | 4583 | James Rariden R000066 | rep | IN | 1839-12-02 | 1841-03-03 | Whig | 5 | |||||||||||||
4595 | 4595 | John Reed R000121 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 11 | |||||||||||||
4605 | 4605 | David Russell R000524 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 12 | |||||||||||||
4618 | 4618 | William Storrs S000977 | rep | CT | 1839-12-02 | 1841-03-03 | Whig | 2 | |||||||||||||
4628 | 4628 | Waddy Thompson T000221 | rep | SC | 1839-12-02 | 1841-03-03 | Whig | 6 | |||||||||||||
4637 | 4637 | Peter Wagner W000020 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 15 | |||||||||||||
4642 | 4642 | Sherrod Williams W000536 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 4 | |||||||||||||
4659 | 4659 | Julius Alford A000104 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
4662 | 4662 | Landaff Andrews A000247 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 11 | |||||||||||||
4679 | 4679 | John Aycrigg A000350 | rep | NJ | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
4699 | 4699 | William Boardman B000578 | rep | CT | 1839-12-02 | 1841-03-03 | Whig | 2 | |||||||||||||
4711 | 4711 | George Briggs B000830 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 7 | |||||||||||||
4713 | 4713 | John Brockway B000854 | rep | CT | 1839-12-02 | 1841-03-03 | Whig | 6 | |||||||||||||
4725 | 4725 | William Calhoun C000046 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 8 | |||||||||||||
4739 | 4739 | Thomas Chittenden C000374 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 18 | |||||||||||||
4746 | 4746 | John Clark C000443 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 21 | |||||||||||||
4751 | 4751 | Thomas Clayton C000499 | sen | DE | 1837-09-04 | 1841-03-03 | 2 | Whig | |||||||||||||
4760 | 4760 | Caleb Cushing C001016 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
4778 | 4778 | George Evans E000241 | rep | ME | 1839-12-02 | 1841-03-03 | Whig | 4 | |||||||||||||
4785 | 4785 | Horace Everett E000265 | rep | VT | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
4801 | 4801 | Seth Gates G000097 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 29 | |||||||||||||
4806 | 4806 | Patrick Goode G000278 | rep | OH | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
4809 | 4809 | Francis Granger G000376 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 26 | |||||||||||||
4813 | 4813 | Richard Habersham H000003 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
4819 | 4819 | Hiland Hall H000052 | rep | VT | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
4827 | 4827 | William Hastings H000332 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 9 | |||||||||||||
4837 | 4837 | Hiram Hunt H000970 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 9 | |||||||||||||
4845 | 4845 | William Johnson J000180 | rep | MD | 1839-12-02 | 1841-03-03 | Whig | 5 | |||||||||||||
4861 | 4861 | Levi Lincoln L000315 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 5 | |||||||||||||
4867 | 4867 | Francis Mallory M000080 | rep | VA | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
4876 | 4876 | Samson Mason M000225 | rep | OH | 1839-12-02 | 1841-03-03 | Whig | 10 | |||||||||||||
4907 | 4907 | Christopher Morgan M000945 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 24 | |||||||||||||
4910 | 4910 | Calvary Morris M000973 | rep | OH | 1839-12-02 | 1841-03-03 | Whig | 6 | |||||||||||||
4918 | 4918 | Jeremiah Morrow M001003 | rep | OH | 1839-12-02 | 1841-03-03 | Whig | 4 | |||||||||||||
4922 | 4922 | Eugenius Nisbet N000111 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
4928 | 4928 | Thomas Osborne O000114 | rep | CT | 1839-12-02 | 1841-03-03 | Whig | 4 | |||||||||||||
4942 | 4942 | John Pope P000431 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 7 | |||||||||||||
4945 | 4945 | George Proffit P000548 | rep | IN | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
4950 | 4950 | Benjamin Randall R000035 | rep | ME | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
4953 | 4953 | Joseph Randolph R000048 | rep | NJ | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
4966 | 4966 | Joseph Ridgway R000247 | rep | OH | 1839-12-02 | 1841-03-03 | Whig | 8 | |||||||||||||
4986 | 4986 | Leverett Saltonstall S000020 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 2 | |||||||||||||
4995 | 4995 | John Sergeant S000246 | rep | PA | 1839-12-02 | 1841-03-03 | Whig | 2 | |||||||||||||
5002 | 5002 | William Simonton S000427 | rep | PA | 1839-12-02 | 1841-03-03 | Whig | 10 | |||||||||||||
5008 | 5008 | William Slade S000475 | rep | VT | 1839-12-02 | 1841-03-03 | Whig | 2 | |||||||||||||
5028 | 5028 | John Taliaferro T000027 | rep | VA | 1839-12-02 | 1841-03-03 | Whig | 10 | |||||||||||||
5031 | 5031 | Joseph Tillinghast T000272 | rep | RI | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
5034 | 5034 | George Toland T000296 | rep | PA | 1839-12-02 | 1841-03-03 | Whig | 2 | |||||||||||||
5037 | 5037 | Philip Triplett T000378 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 2 | |||||||||||||
5041 | 5041 | Joseph Trumbull T000391 | rep | CT | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
5054 | 5054 | Lott Warren W000167 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
5063 | 5063 | Edward White W000365 | rep | LA | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
5068 | 5068 | Joseph Williams W000524 | rep | TN | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
5082 | 5082 | Lewis Williams W000527 | rep | NC | 1839-12-02 | 1841-03-03 | Whig | 13 | |||||||||||||
5084 | 5084 | Thomas Williams W000543 | rep | CT | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
5120 | 5120 | Osmyn Baker B000071 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 6 | |||||||||||||
5124 | 5124 | Daniel Barnard B000152 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 10 | |||||||||||||
5134 | 5134 | Edward Black B000494 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
5174 | 5174 | Walter Colquitt C000648 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
5177 | 5177 | Mark Cooper C000759 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
5189 | 5189 | James Dellet D000221 | rep | AL | 1839-12-02 | 1841-03-03 | Whig | 5 | |||||||||||||
5207 | 5207 | Willis Green G000423 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 6 | |||||||||||||
5268 | 5268 | Kenneth Rayner R000087 | rep | NC | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
5318 | 5318 | John White W000380 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 9 | |||||||||||||
5329 | 5329 | Henry Wise W000649 | rep | VA | 1839-12-02 | 1841-03-03 | Whig | 8 |
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);