legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
285 rows where "end" is on date 1841-03-03 sorted by district
This data as json, copyable, CSV (advanced)
Suggested facets: type, party, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3854 | 3854 | Bedford Brown B000903 | sen | NC | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
3943 | 3943 | Henry Hubbard H000883 | sen | NH | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
3980 | 3980 | Nehemiah Knight K000287 | sen | RI | 1835-12-07 | 1841-03-03 | 2 | Whig | |||||||||||||
4050 | 4050 | John Robinson R000344 | sen | IL | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
4051 | 4051 | John Ruggles R000502 | sen | ME | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
4087 | 4087 | Garret Wall W000071 | sen | NJ | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
4105 | 4105 | Hugh White W000376 | sen | TN | 1835-12-07 | 1841-03-03 | 2 | Whig | |||||||||||||
4114 | 4114 | Robert Nicholas N000085 | sen | LA | 1836-01-01 | 1841-03-03 | 2 | Democrat | |||||||||||||
4267 | 4267 | Wilson Lumpkin L000512 | sen | GA | 1837-09-04 | 1841-03-03 | 2 | Democrat | |||||||||||||
4304 | 4304 | John Norvell N000158 | sen | MI | 1837-09-04 | 1841-03-03 | 2 | Democrat | |||||||||||||
4335 | 4335 | William Roane R000293 | sen | VA | 1837-09-04 | 1841-03-03 | 2 | Democrat | |||||||||||||
4402 | 4402 | Thaddeus Betts B000428 | sen | CT | 1839-12-02 | 1841-03-03 | 1 | Whig | |||||||||||||
4496 | 4496 | Felix Grundy G000509 | sen | TN | 1839-12-02 | 1841-03-03 | 1 | Democrat | |||||||||||||
4646 | 4646 | Alexander Anderson A000181 | sen | TN | 1840-01-01 | 1841-03-03 | 2 | Democrat | |||||||||||||
4751 | 4751 | Thomas Clayton C000499 | sen | DE | 1837-09-04 | 1841-03-03 | 2 | Whig | |||||||||||||
4797 | 4797 | William Fulton F000425 | sen | AR | 1836-01-01 | 1841-03-03 | 2 | Democrat | |||||||||||||
5045 | 5045 | Robert Walker W000067 | sen | MS | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
5638 | 5638 | John Calhoun C000044 | sen | SC | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
5668 | 5668 | John Davis D000117 | sen | MA | 1835-12-07 | 1841-03-03 | 2 | Whig | |||||||||||||
5771 | 5771 | Willie Mangum M000096 | sen | NC | 1840-11-25 | 1841-03-03 | 2 | Whig | |||||||||||||
5876 | 5876 | William King K000217 | sen | AL | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
7723 | 7723 | John Crittenden C000912 | sen | KY | 1835-12-07 | 1841-03-03 | 2 | Whig | |||||||||||||
4423 | 4423 | William Chapman C000318 | rep | IA | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4435 | 4435 | William Cooper C000766 | rep | NJ | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4460 | 4460 | Philemon Dickerson D000309 | rep | NJ | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4464 | 4464 | Charles Downing D000472 | rep | FL | 1839-12-02 | 1841-03-03 | -1 | ||||||||||||||
4502 | 4502 | Albert Harrison H000261 | rep | MO | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4517 | 4517 | Hines Holt H000745 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
4531 | 4531 | Joseph Kille K000178 | rep | NJ | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4598 | 4598 | Eleazar Ripley R000265 | rep | LA | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4606 | 4606 | Daniel Ryall R000554 | rep | NJ | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4632 | 4632 | Peter Vroom V000123 | rep | NJ | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4659 | 4659 | Julius Alford A000104 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
4679 | 4679 | John Aycrigg A000350 | rep | NJ | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
4767 | 4767 | Ira Eastman E000020 | rep | NH | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4813 | 4813 | Richard Habersham H000003 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
4903 | 4903 | John Miller M000735 | rep | MO | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4922 | 4922 | Eugenius Nisbet N000111 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
4953 | 4953 | Joseph Randolph R000048 | rep | NJ | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
4999 | 4999 | Tristram Shaw S000311 | rep | NH | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
5031 | 5031 | Joseph Tillinghast T000272 | rep | RI | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
5054 | 5054 | Lott Warren W000167 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
5134 | 5134 | Edward Black B000494 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
5149 | 5149 | Edmund Burke B001088 | rep | NH | 1839-12-02 | 1841-03-03 | Democrat | -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 | |||||||||||||
5655 | 5655 | Robert Cranston C000879 | rep | RI | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
5745 | 5745 | John Jameson J000054 | rep | MO | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
5954 | 5954 | William Dawson D000156 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
6032 | 6032 | Thomas King K000215 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
6137 | 6137 | Jacob Thompson T000203 | rep | MS | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
6281 | 6281 | James Doty D000443 | rep | WI | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
6495 | 6495 | Charles Atherton A000323 | rep | NH | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
6737 | 6737 | Jared Williams W000511 | rep | NH | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
7322 | 7322 | Albert Brown B000900 | rep | MS | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4601 | 4601 | Thomas Robinson R000353 | rep | DE | 1839-12-02 | 1841-03-03 | Democrat | 0 | |||||||||||||
5862 | 5862 | Augustus Dodge D000394 | rep | IA | 1840-12-28 | 1841-03-03 | Democrat | 0 | |||||||||||||
4421 | 4421 | William Carter C000204 | rep | TN | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
4445 | 4445 | Isaac Crary C000882 | rep | MI | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
4457 | 4457 | John Dennis D000244 | rep | MD | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
4516 | 4516 | Joel Holleman H000721 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
4520 | 4520 | Thomas Jackson J000027 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
4533 | 4533 | Abbott Lawrence L000130 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
4572 | 4572 | Lemuel Paynter P000155 | rep | PA | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
4753 | 4753 | Nathan Clifford C000518 | rep | ME | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
4819 | 4819 | Hiland Hall H000052 | rep | VT | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
4867 | 4867 | Francis Mallory M000080 | rep | VA | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
4945 | 4945 | George Proffit P000548 | rep | IN | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
4963 | 4963 | John Reynolds R000174 | rep | IL | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
5041 | 5041 | Joseph Trumbull T000391 | rep | CT | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
5063 | 5063 | Edward White W000365 | rep | LA | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
5180 | 5180 | Edward Cross C000930 | rep | AR | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
5194 | 5194 | Alexander Duncan D000528 | rep | OH | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
5268 | 5268 | Kenneth Rayner R000087 | rep | NC | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
5381 | 5381 | Reuben Chapman C000316 | rep | AL | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
6007 | 6007 | Isaac Holmes H000738 | rep | SC | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
6198 | 6198 | Robert Winthrop W000646 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
6523 | 6523 | Linn Boyd B000719 | rep | KY | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
4413 | 4413 | Jesse Bynum B001204 | rep | NC | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
4424 | 4424 | Thomas Chinn C000363 | rep | LA | 1839-12-02 | 1841-03-03 | Whig | 2 | |||||||||||||
4455 | 4455 | James De La Montanya D000205 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
4600 | 4600 | Francis Rives R000284 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
4610 | 4610 | Albert Smith S000513 | rep | ME | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
4618 | 4618 | William Storrs S000977 | rep | CT | 1839-12-02 | 1841-03-03 | Whig | 2 | |||||||||||||
4699 | 4699 | William Boardman B000578 | rep | CT | 1839-12-02 | 1841-03-03 | Whig | 2 | |||||||||||||
4733 | 4733 | Zadok Casey C000230 | rep | IL | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
4887 | 4887 | Abraham McClellan M000328 | rep | TN | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
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 | |||||||||||||
5008 | 5008 | William Slade S000475 | rep | VT | 1839-12-02 | 1841-03-03 | Whig | 2 | |||||||||||||
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 | |||||||||||||
5400 | 5400 | John Davis D000120 | rep | IN | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
6016 | 6016 | David Hubbard H000880 | rep | AL | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
6192 | 6192 | Robert Rhett R000184 | rep | SC | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
6479 | 6479 | John Weller W000274 | rep | OH | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
9653 | 9653 | Phillip Thomas T000182 | rep | MD | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
4417 | 4417 | John Carr C000177 | rep | IN | 1839-12-02 | 1841-03-03 | Democrat | 3 | |||||||||||||
4437 | 4437 | George Crabb C000847 | rep | AL | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
4449 | 4449 | Edward Curtis C001009 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 3 |
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);