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 state
This data as json, copyable, CSV (advanced)
Suggested facets: type, state, class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4437 | 4437 | George Crabb C000847 | rep | AL | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
5189 | 5189 | James Dellet D000221 | rep | AL | 1839-12-02 | 1841-03-03 | Whig | 5 | |||||||||||||
5381 | 5381 | Reuben Chapman C000316 | rep | AL | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
5760 | 5760 | Dixon Lewis L000278 | rep | AL | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
5876 | 5876 | William King K000217 | sen | AL | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
6016 | 6016 | David Hubbard H000880 | rep | AL | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
4797 | 4797 | William Fulton F000425 | sen | AR | 1836-01-01 | 1841-03-03 | 2 | Democrat | |||||||||||||
5180 | 5180 | Edward Cross C000930 | rep | AR | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
4402 | 4402 | Thaddeus Betts B000428 | sen | CT | 1839-12-02 | 1841-03-03 | 1 | Whig | |||||||||||||
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 | |||||||||||||
4713 | 4713 | John Brockway B000854 | rep | CT | 1839-12-02 | 1841-03-03 | Whig | 6 | |||||||||||||
4928 | 4928 | Thomas Osborne O000114 | rep | CT | 1839-12-02 | 1841-03-03 | Whig | 4 | |||||||||||||
5041 | 5041 | Joseph Trumbull T000391 | rep | CT | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
5084 | 5084 | Thomas Williams W000543 | rep | CT | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
6125 | 6125 | Truman Smith S000621 | rep | CT | 1839-12-02 | 1841-03-03 | Whig | 5 | |||||||||||||
4601 | 4601 | Thomas Robinson R000353 | rep | DE | 1839-12-02 | 1841-03-03 | Democrat | 0 | |||||||||||||
4751 | 4751 | Thomas Clayton C000499 | sen | DE | 1837-09-04 | 1841-03-03 | 2 | Whig | |||||||||||||
4464 | 4464 | Charles Downing D000472 | rep | FL | 1839-12-02 | 1841-03-03 | -1 | ||||||||||||||
4267 | 4267 | Wilson Lumpkin L000512 | sen | GA | 1837-09-04 | 1841-03-03 | 2 | Democrat | |||||||||||||
4517 | 4517 | Hines Holt H000745 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
4659 | 4659 | Julius Alford A000104 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
4813 | 4813 | Richard Habersham H000003 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
4922 | 4922 | Eugenius Nisbet N000111 | rep | GA | 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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
4423 | 4423 | William Chapman C000318 | rep | IA | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
5862 | 5862 | Augustus Dodge D000394 | rep | IA | 1840-12-28 | 1841-03-03 | Democrat | 0 | |||||||||||||
4050 | 4050 | John Robinson R000344 | sen | IL | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
4733 | 4733 | Zadok Casey C000230 | rep | IL | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
4963 | 4963 | John Reynolds R000174 | rep | IL | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
8041 | 8041 | John Stuart S001035 | rep | IL | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
4417 | 4417 | John Carr C000177 | rep | IN | 1839-12-02 | 1841-03-03 | Democrat | 3 | |||||||||||||
4518 | 4518 | Tilghman Howard H000844 | rep | IN | 1839-12-02 | 1841-03-03 | Democrat | 7 | |||||||||||||
4583 | 4583 | James Rariden R000066 | rep | IN | 1839-12-02 | 1841-03-03 | Whig | 5 | |||||||||||||
4945 | 4945 | George Proffit P000548 | rep | IN | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
5400 | 5400 | John Davis D000120 | rep | IN | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
5521 | 5521 | Thomas Smith S000615 | rep | IN | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
5854 | 5854 | William Wick W000436 | rep | IN | 1839-12-02 | 1841-03-03 | Democrat | 6 | |||||||||||||
7779 | 7779 | Henry Lane L000060 | rep | IN | 1839-12-02 | 1841-03-03 | Whig | 7 | |||||||||||||
4397 | 4397 | Simeon Anderson A000232 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 5 | |||||||||||||
4485 | 4485 | William Graves G000392 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 8 | |||||||||||||
4504 | 4504 | Richard Hawes H000363 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 10 | |||||||||||||
4642 | 4642 | Sherrod Williams W000536 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 4 | |||||||||||||
4662 | 4662 | Landaff Andrews A000247 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 11 | |||||||||||||
4719 | 4719 | William Butler B001197 | rep | KY | 1839-12-02 | 1841-03-03 | Democrat | 13 | |||||||||||||
4942 | 4942 | John Pope P000431 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 7 | |||||||||||||
5037 | 5037 | Philip Triplett T000378 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 2 | |||||||||||||
5207 | 5207 | Willis Green G000423 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 6 | |||||||||||||
5318 | 5318 | John White W000380 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 9 | |||||||||||||
5850 | 5850 | Joseph Underwood U000011 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
6523 | 6523 | Linn Boyd B000719 | rep | KY | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
6720 | 6720 | John Thompson T000208 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 5 | |||||||||||||
7723 | 7723 | John Crittenden C000912 | sen | KY | 1835-12-07 | 1841-03-03 | 2 | Whig | |||||||||||||
8299 | 8299 | Garrett Davis D000099 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 12 | |||||||||||||
4114 | 4114 | Robert Nicholas N000085 | sen | LA | 1836-01-01 | 1841-03-03 | 2 | Democrat | |||||||||||||
4424 | 4424 | Thomas Chinn C000363 | rep | LA | 1839-12-02 | 1841-03-03 | Whig | 2 | |||||||||||||
4482 | 4482 | Rice Garland G000070 | rep | LA | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
4598 | 4598 | Eleazar Ripley R000265 | rep | LA | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
5063 | 5063 | Edward White W000365 | rep | LA | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
6369 | 6369 | John Moore M000903 | rep | LA | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
4394 | 4394 | James Alvord A000168 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 6 | |||||||||||||
4533 | 4533 | Abbott Lawrence L000130 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
4595 | 4595 | John Reed R000121 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 11 | |||||||||||||
4711 | 4711 | George Briggs B000830 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 7 | |||||||||||||
4725 | 4725 | William Calhoun C000046 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 8 | |||||||||||||
4760 | 4760 | Caleb Cushing C001016 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
4827 | 4827 | William Hastings H000332 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 9 | |||||||||||||
4861 | 4861 | Levi Lincoln L000315 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 5 | |||||||||||||
4986 | 4986 | Leverett Saltonstall S000020 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 2 | |||||||||||||
5120 | 5120 | Osmyn Baker B000071 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 6 | |||||||||||||
5259 | 5259 | William Parmenter P000076 | rep | MA | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
5324 | 5324 | Henry Williams W000503 | rep | MA | 1839-12-02 | 1841-03-03 | Democrat | 10 | |||||||||||||
5596 | 5596 | John Adams A000041 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 12 | |||||||||||||
5668 | 5668 | John Davis D000117 | sen | MA | 1835-12-07 | 1841-03-03 | 2 | Whig | |||||||||||||
6198 | 6198 | Robert Winthrop W000646 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
4418 | 4418 | James Carroll C000188 | rep | MD | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
4457 | 4457 | John Dennis D000244 | rep | MD | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
4513 | 4513 | Solomon Hillen Solomon H000617 | rep | MD | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
4524 | 4524 | Daniel Jenifer J000078 | rep | MD | 1839-12-02 | 1841-03-03 | Whig | 7 | |||||||||||||
4645 | 4645 | John Worthington W000748 | rep | MD | 1839-12-02 | 1841-03-03 | Democrat | 3 | |||||||||||||
4845 | 4845 | William Johnson J000180 | rep | MD | 1839-12-02 | 1841-03-03 | Whig | 5 | |||||||||||||
8464 | 8464 | Francis Thomas T000166 | rep | MD | 1839-12-02 | 1841-03-03 | Democrat | 6 | |||||||||||||
9653 | 9653 | Phillip Thomas T000182 | rep | MD | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
4051 | 4051 | John Ruggles R000502 | sen | ME | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
4396 | 4396 | Hugh Anderson A000190 | rep | ME | 1839-12-02 | 1841-03-03 | Democrat | 6 | |||||||||||||
4451 | 4451 | Thomas Davee D000068 | rep | ME | 1839-12-02 | 1841-03-03 | Democrat | 8 | |||||||||||||
4570 | 4570 | Virgil Parris P000081 | rep | ME | 1839-12-02 | 1841-03-03 | Democrat | 5 | |||||||||||||
4610 | 4610 | Albert Smith S000513 | rep | ME | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
4753 | 4753 | Nathan Clifford C000518 | rep | ME | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
4778 | 4778 | George Evans E000241 | rep | ME | 1839-12-02 | 1841-03-03 | Whig | 4 | |||||||||||||
4864 | 4864 | Joshua Lowell L000476 | rep | ME | 1839-12-02 | 1841-03-03 | Democrat | 7 | |||||||||||||
4950 | 4950 | Benjamin Randall R000035 | rep | ME | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
4304 | 4304 | John Norvell N000158 | sen | MI | 1837-09-04 | 1841-03-03 | 2 | Democrat | |||||||||||||
4445 | 4445 | Isaac Crary C000882 | rep | MI | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
4502 | 4502 | Albert Harrison H000261 | rep | MO | 1839-12-02 | 1841-03-03 | Democrat | -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);