legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
266 rows where "start" is on date 1845-12-01 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: state, end, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5384 | 5384 | Reuben Chapman C000316 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 6 | |||||||||||||
5389 | 5389 | James Cottrell C000803 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 3 | |||||||||||||
5396 | 5396 | Edmund Dargan D000052 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5476 | 5476 | Felix McConnell M000356 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 7 | |||||||||||||
5496 | 5496 | William Payne P000154 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 4 | |||||||||||||
5580 | 5580 | William Yancey Y000003 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 3 | |||||||||||||
5905 | 5905 | Franklin Bowdon B000680 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 7 | |||||||||||||
6003 | 6003 | Henry Hilliard H000622 | rep | AL | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
10109 | 10109 | George Houston H000822 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 5 | |||||||||||||
5488 | 5488 | Thomas Newton N000077 | rep | AR | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
5583 | 5583 | Archibald Yell Y000017 | rep | AR | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5453 | 5453 | Jabez Huntington H000997 | sen | CT | 1845-12-01 | 1847-12-31 | 1 | Whig | |||||||||||||
5724 | 5724 | Samuel Hubbard H000889 | rep | CT | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
5810 | 5810 | John Rockwell R000367 | rep | CT | 1845-12-01 | 1847-03-03 | Whig | 3 | |||||||||||||
6127 | 6127 | Truman Smith S000621 | rep | CT | 1845-12-01 | 1847-03-03 | Whig | 4 | |||||||||||||
7944 | 7944 | James Dixon D000369 | rep | CT | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
6013 | 6013 | John Houston H000825 | rep | DE | 1845-12-01 | 1847-03-03 | Whig | 0 | |||||||||||||
6551 | 6551 | John Clayton C000496 | sen | DE | 1845-12-01 | 1849-12-31 | 1 | Whig | |||||||||||||
5366 | 5366 | William Brockenbrough B000852 | rep | FL | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5572 | 5572 | James Westcott W000308 | sen | FL | 1845-12-01 | 1849-03-03 | 3 | Democrat | |||||||||||||
6242 | 6242 | Edward Cabell C000003 | rep | FL | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
6959 | 6959 | David Yulee Y000061 | sen | FL | 1845-12-01 | 1851-03-03 | 1 | Democrat | |||||||||||||
5463 | 5463 | Seaborn Jones J000252 | rep | GA | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5548 | 5548 | George Towns T000327 | rep | GA | 1845-12-01 | 1847-03-03 | Democrat | 3 | |||||||||||||
5993 | 5993 | Hugh Haralson H000178 | rep | GA | 1845-12-01 | 1847-03-03 | Democrat | 4 | |||||||||||||
6034 | 6034 | Thomas King K000215 | rep | GA | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
6789 | 6789 | Howell Cobb C000548 | rep | GA | 1845-12-01 | 1847-03-03 | Democrat | 6 | |||||||||||||
6862 | 6862 | John Lumpkin L000511 | rep | GA | 1845-12-01 | 1847-03-03 | Democrat | 5 | |||||||||||||
7609 | 7609 | Robert Toombs T000313 | rep | GA | 1845-12-01 | 1847-03-03 | Whig | 8 | |||||||||||||
10550 | 10550 | Alexander Stephens S000854 | rep | GA | 1845-12-01 | 1847-03-03 | Whig | 7 | |||||||||||||
5436 | 5436 | Serranus Hastings H000330 | rep | IA | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5865 | 5865 | Augustus Dodge D000394 | rep | IA | 1845-12-01 | 1846-12-28 | Democrat | 0 | |||||||||||||
6040 | 6040 | Shepherd Leffler L000215 | rep | IA | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5437 | 5437 | John Henry H000507 | rep | IL | 1845-12-01 | 1847-03-03 | Whig | 7 | |||||||||||||
5440 | 5440 | Joseph Hoge H000697 | rep | IL | 1845-12-01 | 1847-03-03 | Democrat | 6 | |||||||||||||
6291 | 6291 | Orlando Ficklin F000101 | rep | IL | 1845-12-01 | 1847-03-03 | Democrat | 3 | |||||||||||||
7226 | 7226 | Robert Smith S000604 | rep | IL | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
7387 | 7387 | Stephen Douglas D000457 | rep | IL | 1845-12-01 | 1847-03-03 | Democrat | 5 | |||||||||||||
7642 | 7642 | Edward Baker B000059 | rep | IL | 1845-12-01 | 1847-03-03 | Whig | 7 | |||||||||||||
7790 | 7790 | John McClernand M000337 | rep | IL | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
8225 | 8225 | John Wentworth W000295 | rep | IL | 1845-12-01 | 1847-03-03 | Democrat | 4 | |||||||||||||
5402 | 5402 | John Davis D000120 | rep | IN | 1845-12-01 | 1847-03-03 | Democrat | 6 | |||||||||||||
5466 | 5466 | Andrew Kennedy K000102 | rep | IN | 1845-12-01 | 1847-03-03 | Democrat | 10 | |||||||||||||
5491 | 5491 | Robert Owen O000152 | rep | IN | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5523 | 5523 | Thomas Smith S000615 | rep | IN | 1845-12-01 | 1847-03-03 | Democrat | 3 | |||||||||||||
5717 | 5717 | Thomas Henley H000499 | rep | IN | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5823 | 5823 | Caleb Smith S000519 | rep | IN | 1845-12-01 | 1847-03-03 | Whig | 4 | |||||||||||||
5855 | 5855 | William Wick W000436 | rep | IN | 1845-12-01 | 1847-03-03 | Democrat | 5 | |||||||||||||
6058 | 6058 | Edward McGaughey M000443 | rep | IN | 1845-12-01 | 1847-03-03 | Whig | 7 | |||||||||||||
6469 | 6469 | Charles Cathcart C000250 | rep | IN | 1845-12-01 | 1847-03-03 | Democrat | 9 | |||||||||||||
6669 | 6669 | John Pettit P000277 | rep | IN | 1845-12-01 | 1847-03-03 | Democrat | 8 | |||||||||||||
6991 | 6991 | Jesse Bright B000835 | sen | IN | 1845-12-01 | 1851-03-03 | 1 | Democrat | |||||||||||||
5358 | 5358 | Joshua Bell B000343 | rep | KY | 1845-12-01 | 1847-03-03 | Whig | 4 | |||||||||||||
5472 | 5472 | John Martin M000189 | rep | KY | 1845-12-01 | 1847-03-03 | Democrat | 6 | |||||||||||||
5481 | 5481 | John McHenry M000471 | rep | KY | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
5541 | 5541 | William Thomasson T000190 | rep | KY | 1845-12-01 | 1847-03-03 | Whig | 7 | |||||||||||||
5543 | 5543 | John Tibbatts T000261 | rep | KY | 1845-12-01 | 1847-03-03 | Democrat | 10 | |||||||||||||
5550 | 5550 | Andrew Trumbo T000388 | rep | KY | 1845-12-01 | 1847-03-03 | Whig | 9 | |||||||||||||
5586 | 5586 | Bryan Young Y000030 | rep | KY | 1845-12-01 | 1847-03-03 | Whig | 5 | |||||||||||||
6526 | 6526 | Linn Boyd B000719 | rep | KY | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
8123 | 8123 | Henry Grider G000455 | rep | KY | 1845-12-01 | 1847-03-03 | Whig | 3 | |||||||||||||
8302 | 8302 | Garrett Davis D000099 | rep | KY | 1845-12-01 | 1847-03-03 | Whig | 8 | |||||||||||||
5405 | 5405 | John Dawson D000152 | rep | LA | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5840 | 5840 | Bannon Thibodeaux T000152 | rep | LA | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
5996 | 5996 | John Harmanson H000214 | rep | LA | 1845-12-01 | 1847-03-03 | Democrat | 3 | |||||||||||||
6037 | 6037 | Emile La Sére L000008 | rep | LA | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
6071 | 6071 | Isaac Morse M001011 | rep | LA | 1845-12-01 | 1847-03-03 | Democrat | 4 | |||||||||||||
6921 | 6921 | John Slidell S000487 | rep | LA | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5571 | 5571 | Daniel Webster W000238 | sen | MA | 1845-12-01 | 1850-07-22 | 1 | Whig | |||||||||||||
5589 | 5589 | Amos Abbott A000004 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 3 | |||||||||||||
5599 | 5599 | John Adams A000041 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 8 | |||||||||||||
5669 | 5669 | John Davis D000117 | sen | MA | 1845-12-01 | 1847-03-03 | 2 | Whig | |||||||||||||
5709 | 5709 | Artemas Hale H000028 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 9 | |||||||||||||
5728 | 5728 | Charles Hudson H000907 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 5 | |||||||||||||
5894 | 5894 | George Ashmun A000318 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 6 | |||||||||||||
5985 | 5985 | Joseph Grinnell G000477 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 10 | |||||||||||||
6027 | 6027 | Daniel King K000198 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
6201 | 6201 | Robert Winthrop W000646 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
6433 | 6433 | Benjamin Thompson T000192 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 4 | |||||||||||||
6746 | 6746 | Julius Rockwell R000368 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 7 | |||||||||||||
5388 | 5388 | Albert Constable C000708 | rep | MD | 1845-12-01 | 1847-03-03 | Democrat | 5 | |||||||||||||
5425 | 5425 | William Giles G000184 | rep | MD | 1845-12-01 | 1847-03-03 | Democrat | 4 | |||||||||||||
5470 | 5470 | Edward Long L000414 | rep | MD | 1845-12-01 | 1847-03-03 | Whig | 6 | |||||||||||||
5500 | 5500 | Thomas Perry P000245 | rep | MD | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5643 | 5643 | John Chapman C000314 | rep | MD | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
5765 | 5765 | Thomas Ligon L000307 | rep | MD | 1845-12-01 | 1847-03-03 | Democrat | 3 | |||||||||||||
7973 | 7973 | Reverdy Johnson J000169 | sen | MD | 1845-12-01 | 1849-12-31 | 1 | Whig | |||||||||||||
5414 | 5414 | Robert Dunlap D000543 | rep | ME | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5423 | 5423 | John Fairfield F000006 | sen | ME | 1845-12-01 | 1847-12-31 | 1 | Democrat | |||||||||||||
5477 | 5477 | John McCrate M000380 | rep | ME | 1845-12-01 | 1847-03-03 | Democrat | 4 | |||||||||||||
5514 | 5514 | John Scamman S000104 | rep | ME | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5517 | 5517 | Luther Severance S000255 | rep | ME | 1845-12-01 | 1847-03-03 | Whig | 3 | |||||||||||||
5858 | 5858 | Hezekiah Williams W000504 | rep | ME | 1845-12-01 | 1847-03-03 | Democrat | 7 | |||||||||||||
6110 | 6110 | Cullen Sawtelle S000085 | rep | ME | 1845-12-01 | 1847-03-03 | Democrat | 5 | |||||||||||||
9515 | 9515 | Hannibal Hamlin H000121 | rep | ME | 1845-12-01 | 1847-03-03 | Democrat | 6 | |||||||||||||
5385 | 5385 | John Chipman C000368 | rep | MI | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5448 | 5448 | James Hunt H000971 | rep | MI | 1845-12-01 | 1847-03-03 | Democrat | 3 | |||||||||||||
5779 | 5779 | Robert McClelland M000334 | rep | MI | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
6253 | 6253 | Lewis Cass C000233 | sen | MI | 1845-12-01 | 1849-03-03 | 1 | Democrat | |||||||||||||
5478 | 5478 | William McDaniel M000400 | rep | MO | 1845-12-01 | 1847-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);