legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
275 rows where "start" is on date 1839-12-02 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9653 | 9653 | Phillip Thomas T000182 | rep | MD | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
8464 | 8464 | Francis Thomas T000166 | rep | MD | 1839-12-02 | 1841-03-03 | Democrat | 6 | |||||||||||||
8299 | 8299 | Garrett Davis D000099 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 12 | |||||||||||||
8092 | 8092 | William Campbell C000104 | rep | TN | 1839-12-02 | 1841-03-03 | Whig | 6 | |||||||||||||
8041 | 8041 | John Stuart S001035 | rep | IL | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
7880 | 7880 | Albert White W000351 | sen | IN | 1839-12-02 | 1845-03-03 | 1 | Whig | |||||||||||||
7779 | 7779 | Henry Lane L000060 | rep | IN | 1839-12-02 | 1841-03-03 | Whig | 7 | |||||||||||||
7714 | 7714 | Thomas Corwin C000791 | rep | OH | 1839-12-02 | 1841-03-03 | Whig | 4 | |||||||||||||
7452 | 7452 | Robert Hunter H000988 | rep | VA | 1839-12-02 | 1841-03-03 | Whig | 9 | |||||||||||||
7322 | 7322 | Albert Brown B000900 | rep | MS | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
7092 | 7092 | George Hopkins H000774 | rep | VA | 1839-12-02 | 1841-03-03 | Conservative | 18 | |||||||||||||
7049 | 7049 | Joshua Giddings G000167 | rep | OH | 1839-12-02 | 1841-03-03 | Whig | 16 | |||||||||||||
6737 | 6737 | Jared Williams W000511 | rep | NH | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
6720 | 6720 | John Thompson T000208 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 5 | |||||||||||||
6672 | 6672 | Samuel Phelps P000299 | sen | VT | 1839-12-02 | 1845-03-03 | 1 | Whig | |||||||||||||
6523 | 6523 | Linn Boyd B000719 | rep | KY | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
6515 | 6515 | Thomas Benton B000398 | sen | MO | 1839-12-02 | 1845-03-03 | 1 | Democrat | |||||||||||||
6509 | 6509 | John Bell B000340 | rep | TN | 1839-12-02 | 1841-03-03 | Whig | 7 | |||||||||||||
6495 | 6495 | Charles Atherton A000323 | rep | NH | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
6479 | 6479 | John Weller W000274 | rep | OH | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
6457 | 6457 | Christopher Williams W000493 | rep | TN | 1839-12-02 | 1841-03-03 | Whig | 13 | |||||||||||||
6421 | 6421 | Edward Stanly S000799 | rep | NC | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
6369 | 6369 | John Moore M000903 | rep | LA | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
6303 | 6303 | Meredith Gentry G000125 | rep | TN | 1839-12-02 | 1841-03-03 | Whig | 8 | |||||||||||||
6296 | 6296 | John Floyd F000223 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 17 | |||||||||||||
6281 | 6281 | James Doty D000443 | rep | WI | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
6206 | 6206 | Millard Fillmore F000115 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 32 | |||||||||||||
6198 | 6198 | Robert Winthrop W000646 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
6192 | 6192 | Robert Rhett R000184 | rep | SC | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
6137 | 6137 | Jacob Thompson T000203 | rep | MS | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
6125 | 6125 | Truman Smith S000621 | rep | CT | 1839-12-02 | 1841-03-03 | Whig | 5 | |||||||||||||
6032 | 6032 | Thomas King K000215 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
6016 | 6016 | David Hubbard H000880 | rep | AL | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
6007 | 6007 | Isaac Holmes H000738 | rep | SC | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
5961 | 5961 | Edmund Deberry D000181 | rep | NC | 1839-12-02 | 1841-03-03 | Whig | 7 | |||||||||||||
5954 | 5954 | William Dawson D000156 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
5946 | 5946 | James Cooper C000753 | rep | PA | 1839-12-02 | 1841-03-03 | Whig | 12 | |||||||||||||
5854 | 5854 | William Wick W000436 | rep | IN | 1839-12-02 | 1841-03-03 | Democrat | 6 | |||||||||||||
5850 | 5850 | Joseph Underwood U000011 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
5788 | 5788 | James McKay M000489 | rep | NC | 1839-12-02 | 1841-03-03 | Democrat | 5 | |||||||||||||
5760 | 5760 | Dixon Lewis L000278 | rep | AL | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
5745 | 5745 | John Jameson J000054 | rep | MO | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
5703 | 5703 | William Goggin G000256 | rep | VA | 1839-12-02 | 1841-03-03 | Whig | 7 | |||||||||||||
5677 | 5677 | George Dromgoole D000504 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
5655 | 5655 | Robert Cranston C000879 | rep | RI | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
5624 | 5624 | John Botts B000655 | rep | VA | 1839-12-02 | 1841-03-03 | Whig | 11 | |||||||||||||
5596 | 5596 | John Adams A000041 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 12 | |||||||||||||
5570 | 5570 | Daniel Webster W000238 | sen | MA | 1839-12-02 | 1841-02-22 | 1 | Whig | |||||||||||||
5552 | 5552 | Hopkins Turney T000430 | rep | TN | 1839-12-02 | 1841-03-03 | Democrat | 5 | |||||||||||||
5531 | 5531 | David Starkweather S000813 | rep | OH | 1839-12-02 | 1841-03-03 | Democrat | 18 | |||||||||||||
5521 | 5521 | Thomas Smith S000615 | rep | IN | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
5492 | 5492 | Isaac Parrish P000082 | rep | OH | 1839-12-02 | 1841-03-03 | Democrat | 11 | |||||||||||||
5460 | 5460 | Joseph Johnson J000155 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 20 | |||||||||||||
5431 | 5431 | James Graham G000355 | rep | NC | 1839-12-02 | 1841-03-03 | Whig | 12 | |||||||||||||
5400 | 5400 | John Davis D000120 | rep | IN | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
5381 | 5381 | Reuben Chapman C000316 | rep | AL | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
5329 | 5329 | Henry Wise W000649 | rep | VA | 1839-12-02 | 1841-03-03 | Whig | 8 | |||||||||||||
5324 | 5324 | Henry Williams W000503 | rep | MA | 1839-12-02 | 1841-03-03 | Democrat | 10 | |||||||||||||
5318 | 5318 | John White W000380 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 9 | |||||||||||||
5301 | 5301 | Lewis Steenrod S000843 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 21 | |||||||||||||
5268 | 5268 | Kenneth Rayner R000087 | rep | NC | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
5259 | 5259 | William Parmenter P000076 | rep | MA | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
5245 | 5245 | William Lucas L000494 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 15 | |||||||||||||
5235 | 5235 | John Jones J000240 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 3 | |||||||||||||
5229 | 5229 | Cave Johnson J000122 | rep | TN | 1839-12-02 | 1841-03-03 | Democrat | 11 | |||||||||||||
5207 | 5207 | Willis Green G000423 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 6 | |||||||||||||
5194 | 5194 | Alexander Duncan D000528 | rep | OH | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
5189 | 5189 | James Dellet D000221 | rep | AL | 1839-12-02 | 1841-03-03 | Whig | 5 | |||||||||||||
5183 | 5183 | Amasa Dana D000020 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 22 | |||||||||||||
5180 | 5180 | Edward Cross C000930 | rep | AR | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
5177 | 5177 | Mark Cooper C000759 | 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 | |||||||||||||
5171 | 5171 | Walter Coles C000625 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 6 | |||||||||||||
5156 | 5156 | John Campbell C000090 | rep | SC | 1839-12-02 | 1841-03-03 | Democrat | 3 | |||||||||||||
5149 | 5149 | Edmund Burke B001088 | rep | NH | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
5144 | 5144 | Aaron Brown B000899 | rep | TN | 1839-12-02 | 1841-03-03 | Democrat | 10 | |||||||||||||
5137 | 5137 | Julius Blackwell B000516 | rep | TN | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
5134 | 5134 | Edward Black B000494 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
5124 | 5124 | Daniel Barnard B000152 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 10 | |||||||||||||
5120 | 5120 | Osmyn Baker B000071 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 6 | |||||||||||||
5084 | 5084 | Thomas Williams W000543 | rep | CT | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
5082 | 5082 | Lewis Williams W000527 | rep | NC | 1839-12-02 | 1841-03-03 | Whig | 13 | |||||||||||||
5068 | 5068 | Joseph Williams W000524 | rep | TN | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
5063 | 5063 | Edward White W000365 | rep | LA | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
5057 | 5057 | Harvey Watterson W000208 | rep | TN | 1839-12-02 | 1841-03-03 | Democrat | 9 | |||||||||||||
5054 | 5054 | Lott Warren W000167 | rep | GA | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
5041 | 5041 | Joseph Trumbull T000391 | rep | CT | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
5037 | 5037 | Philip Triplett T000378 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 2 | |||||||||||||
5034 | 5034 | George Toland T000296 | rep | PA | 1839-12-02 | 1841-03-03 | Whig | 2 | |||||||||||||
5031 | 5031 | Joseph Tillinghast T000272 | rep | RI | 1839-12-02 | 1841-03-03 | Whig | -1 | |||||||||||||
5028 | 5028 | John Taliaferro T000027 | rep | VA | 1839-12-02 | 1841-03-03 | Whig | 10 | |||||||||||||
5018 | 5018 | George Sweeny S001105 | rep | OH | 1839-12-02 | 1841-03-03 | Democrat | 14 | |||||||||||||
5016 | 5016 | Thomas Sumter S001074 | rep | SC | 1839-12-02 | 1841-03-03 | Democrat | 8 | |||||||||||||
5008 | 5008 | William Slade S000475 | rep | VT | 1839-12-02 | 1841-03-03 | Whig | 2 | |||||||||||||
5002 | 5002 | William Simonton S000427 | rep | PA | 1839-12-02 | 1841-03-03 | Whig | 10 | |||||||||||||
4999 | 4999 | Tristram Shaw S000311 | rep | NH | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
4995 | 4995 | John Sergeant S000246 | rep | PA | 1839-12-02 | 1841-03-03 | Whig | 2 | |||||||||||||
4986 | 4986 | Leverett Saltonstall S000020 | rep | MA | 1839-12-02 | 1841-03-03 | Whig | 2 | |||||||||||||
4977 | 4977 | James Rogers R000396 | rep | SC | 1839-12-02 | 1841-03-03 | Democrat | 7 | |||||||||||||
4966 | 4966 | Joseph Ridgway R000247 | rep | OH | 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);