legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
260 rows where "end" is on date 1845-03-03 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: start, class, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10549 | 10549 | Alexander Stephens S000854 | rep | GA | 1843-12-04 | 1845-03-03 | Whig | -1 | |||||||||||||
10108 | 10108 | George Houston H000822 | rep | AL | 1843-12-04 | 1845-03-03 | Democrat | 5 | |||||||||||||
9540 | 9540 | Andrew Johnson J000116 | rep | TN | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
9514 | 9514 | Hannibal Hamlin H000121 | rep | ME | 1843-12-04 | 1845-03-03 | Democrat | 6 | |||||||||||||
8897 | 8897 | Henry Foster F000305 | rep | PA | 1843-12-04 | 1845-03-03 | Democrat | 19 | |||||||||||||
8707 | 8707 | Robert Schenck S000118 | rep | OH | 1843-12-04 | 1845-03-03 | Whig | 3 | |||||||||||||
8695 | 8695 | Alexander Ramsey R000026 | rep | PA | 1843-12-04 | 1845-03-03 | Whig | 14 | |||||||||||||
8301 | 8301 | Garrett Davis D000099 | rep | KY | 1843-12-04 | 1845-03-03 | Whig | 8 | |||||||||||||
8224 | 8224 | John Wentworth W000295 | rep | IL | 1843-12-04 | 1845-03-03 | Democrat | 4 | |||||||||||||
8122 | 8122 | Henry Grider G000455 | rep | KY | 1843-12-04 | 1845-03-03 | Whig | 3 | |||||||||||||
8064 | 8064 | William Wright W000772 | rep | NJ | 1843-12-04 | 1845-03-03 | Ind. Whig | 5 | |||||||||||||
7951 | 7951 | Solomon Foot F000248 | rep | VT | 1843-12-04 | 1845-03-03 | Whig | 1 | |||||||||||||
7901 | 7901 | Joseph Wright W000766 | rep | IN | 1843-12-04 | 1845-03-03 | Democrat | 7 | |||||||||||||
7880 | 7880 | Albert White W000351 | sen | IN | 1839-12-02 | 1845-03-03 | 1 | Whig | |||||||||||||
7807 | 7807 | Edward Morris M000975 | rep | PA | 1843-12-04 | 1845-03-03 | Whig | 1 | |||||||||||||
7789 | 7789 | John McClernand M000337 | rep | IL | 1843-12-04 | 1845-03-03 | Democrat | 2 | |||||||||||||
7701 | 7701 | Jacob Collamer C000628 | rep | VT | 1843-12-04 | 1845-03-03 | Whig | 2 | |||||||||||||
7523 | 7523 | Freeman Morse M001010 | rep | ME | 1843-12-04 | 1845-03-03 | Whig | 4 | |||||||||||||
7488 | 7488 | William Maclay M000032 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 4 | |||||||||||||
7426 | 7426 | John Hale H000034 | rep | NH | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
7386 | 7386 | Stephen Douglas D000457 | rep | IL | 1843-12-04 | 1845-03-03 | Democrat | 5 | |||||||||||||
7260 | 7260 | Thomas Clingman C000524 | rep | NC | 1843-12-04 | 1845-03-03 | Whig | 1 | |||||||||||||
7225 | 7225 | Robert Smith S000604 | rep | IL | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
7118 | 7118 | Preston King K000211 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 18 | |||||||||||||
7101 | 7101 | George Jones J000222 | rep | TN | 1843-12-04 | 1845-03-03 | Democrat | 5 | |||||||||||||
7094 | 7094 | George Hopkins H000774 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 13 | |||||||||||||
7051 | 7051 | Joshua Giddings G000167 | rep | OH | 1843-12-04 | 1845-03-03 | Whig | 20 | |||||||||||||
6958 | 6958 | David Yulee Y000061 | rep | FL | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
6920 | 6920 | John Slidell S000487 | rep | LA | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
6861 | 6861 | John Lumpkin L000511 | rep | GA | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
6788 | 6788 | Howell Cobb C000548 | rep | GA | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
6762 | 6762 | Thomas Bayly B000259 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 7 | |||||||||||||
6745 | 6745 | Julius Rockwell R000368 | rep | MA | 1843-12-04 | 1845-03-03 | Whig | 7 | |||||||||||||
6742 | 6742 | David Reid R000144 | rep | NC | 1843-12-04 | 1845-03-03 | Democrat | 3 | |||||||||||||
6672 | 6672 | Samuel Phelps P000299 | sen | VT | 1839-12-02 | 1845-03-03 | 1 | Whig | |||||||||||||
6668 | 6668 | John Pettit P000277 | rep | IN | 1843-12-04 | 1845-03-03 | Democrat | 8 | |||||||||||||
6525 | 6525 | Linn Boyd B000719 | rep | KY | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
6515 | 6515 | Thomas Benton B000398 | sen | MO | 1839-12-02 | 1845-03-03 | 1 | Democrat | |||||||||||||
6481 | 6481 | John Weller W000274 | rep | OH | 1843-12-04 | 1845-03-03 | Democrat | 2 | |||||||||||||
6461 | 6461 | Joseph Woodward W000732 | rep | SC | 1843-12-04 | 1845-03-03 | Democrat | 3 | |||||||||||||
6427 | 6427 | James Stone S000958 | rep | KY | 1843-12-04 | 1845-03-03 | Democrat | 5 | |||||||||||||
6412 | 6412 | David Seymour S000265 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 12 | |||||||||||||
6321 | 6321 | Alexander Harper H000219 | rep | OH | 1843-12-04 | 1845-03-03 | Whig | 14 | |||||||||||||
6294 | 6294 | Hamilton Fish F000140 | rep | NY | 1843-12-04 | 1845-03-03 | Whig | 6 | |||||||||||||
6290 | 6290 | Orlando Ficklin F000101 | rep | IL | 1843-12-04 | 1845-03-03 | Democrat | 3 | |||||||||||||
6277 | 6277 | Henry Dodge D000396 | rep | WI | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
6265 | 6265 | John Daniel D000034 | rep | NC | 1843-12-04 | 1845-03-03 | Democrat | 7 | |||||||||||||
6236 | 6236 | Armistead Burt B001145 | rep | SC | 1843-12-04 | 1845-03-03 | Democrat | 5 | |||||||||||||
6228 | 6228 | Richard Brodhead B000861 | rep | PA | 1843-12-04 | 1845-03-03 | Democrat | 10 | |||||||||||||
6200 | 6200 | Robert Winthrop W000646 | rep | MA | 1843-12-04 | 1845-03-03 | Whig | 1 | |||||||||||||
6194 | 6194 | Robert Rhett R000184 | rep | SC | 1843-12-04 | 1845-03-03 | Democrat | 7 | |||||||||||||
6162 | 6162 | Samuel Vinton V000107 | rep | OH | 1843-12-04 | 1845-03-03 | Whig | 12 | |||||||||||||
6139 | 6139 | Jacob Thompson T000203 | rep | MS | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
6094 | 6094 | Emery Potter P000464 | rep | OH | 1843-12-04 | 1845-03-03 | Democrat | 5 | |||||||||||||
6091 | 6091 | Jonas Phoenix P000319 | rep | NY | 1843-12-04 | 1845-03-03 | Whig | 3 | |||||||||||||
6082 | 6082 | Moses Norris N000140 | rep | NH | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
6078 | 6078 | Henry Nes N000047 | rep | PA | 1843-12-04 | 1845-03-03 | Ind. Democrat | 15 | |||||||||||||
6070 | 6070 | Isaac Morse M001011 | rep | LA | 1843-12-04 | 1845-03-03 | Democrat | 4 | |||||||||||||
6051 | 6051 | George Marsh M000147 | rep | VT | 1843-12-04 | 1845-03-03 | Whig | 3 | |||||||||||||
6026 | 6026 | Daniel King K000198 | rep | MA | 1843-12-04 | 1845-03-03 | Whig | 2 | |||||||||||||
6009 | 6009 | Isaac Holmes H000738 | rep | SC | 1843-12-04 | 1845-03-03 | Democrat | 6 | |||||||||||||
5992 | 5992 | Hugh Haralson H000178 | rep | GA | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5984 | 5984 | Joseph Grinnell G000477 | rep | MA | 1843-12-04 | 1845-03-03 | Whig | 10 | |||||||||||||
5963 | 5963 | Edmund Deberry D000181 | rep | NC | 1843-12-04 | 1845-03-03 | Whig | 4 | |||||||||||||
5923 | 5923 | George Caldwell C000031 | rep | KY | 1843-12-04 | 1845-03-03 | Democrat | 4 | |||||||||||||
5914 | 5914 | William Brown B000950 | rep | IN | 1843-12-04 | 1845-03-03 | Democrat | 5 | |||||||||||||
5908 | 5908 | James Bowlin B000701 | rep | MO | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5864 | 5864 | Augustus Dodge D000394 | rep | IA | 1843-12-04 | 1845-03-03 | Democrat | 0 | |||||||||||||
5834 | 5834 | Andrew Stewart S000899 | rep | PA | 1843-12-04 | 1845-03-03 | Whig | 18 | |||||||||||||
5822 | 5822 | Caleb Smith S000519 | rep | IN | 1843-12-04 | 1845-03-03 | Whig | 4 | |||||||||||||
5816 | 5816 | Richard Simpson S000435 | rep | SC | 1843-12-04 | 1845-03-03 | Democrat | 2 | |||||||||||||
5805 | 5805 | James Pollock P000416 | rep | PA | 1843-12-04 | 1845-03-03 | Whig | 13 | |||||||||||||
5796 | 5796 | Henry Murphy M001093 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 2 | |||||||||||||
5790 | 5790 | James McKay M000489 | rep | NC | 1843-12-04 | 1845-03-03 | Democrat | 6 | |||||||||||||
5781 | 5781 | Abraham McIlvaine M000474 | rep | PA | 1843-12-04 | 1845-03-03 | Whig | 7 | |||||||||||||
5778 | 5778 | Robert McClelland M000334 | rep | MI | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
5746 | 5746 | John Jameson J000054 | rep | MO | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
5740 | 5740 | Joseph Ingersoll I000019 | rep | PA | 1843-12-04 | 1845-03-03 | Whig | 2 | |||||||||||||
5735 | 5735 | Charles Ingersoll I000015 | rep | PA | 1843-12-04 | 1845-03-03 | Democrat | 4 | |||||||||||||
5730 | 5730 | Washington Hunt H000978 | rep | NY | 1843-12-04 | 1845-03-03 | Whig | 34 | |||||||||||||
5727 | 5727 | Charles Hudson H000907 | rep | MA | 1843-12-04 | 1845-03-03 | Whig | 5 | |||||||||||||
5716 | 5716 | Thomas Henley H000499 | rep | IN | 1843-12-04 | 1845-03-03 | Democrat | 2 | |||||||||||||
5705 | 5705 | William Goggin G000256 | rep | VA | 1843-12-04 | 1845-03-03 | Whig | 5 | |||||||||||||
5696 | 5696 | Richard French F000379 | rep | KY | 1843-12-04 | 1845-03-03 | Democrat | 9 | |||||||||||||
5678 | 5678 | George Dromgoole D000504 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 2 | |||||||||||||
5671 | 5671 | John Dickey D000314 | rep | PA | 1843-12-04 | 1845-03-03 | Whig | 20 | |||||||||||||
5618 | 5618 | James Black B000501 | rep | SC | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
5607 | 5607 | Daniel Barringer B000182 | rep | NC | 1843-12-04 | 1845-03-03 | Whig | 2 | |||||||||||||
5603 | 5603 | Archibald Atkinson A000328 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
5598 | 5598 | John Adams A000041 | rep | MA | 1843-12-04 | 1845-03-03 | Whig | 8 | |||||||||||||
5588 | 5588 | Amos Abbott A000004 | rep | MA | 1843-12-04 | 1845-03-03 | Whig | 3 | |||||||||||||
5584 | 5584 | Jacob Yost Y000026 | rep | PA | 1843-12-04 | 1845-03-03 | Democrat | 5 | |||||||||||||
5579 | 5579 | William Yancey Y000003 | rep | AL | 1843-12-04 | 1845-03-03 | Democrat | 3 | |||||||||||||
5573 | 5573 | Horace Wheaton W000328 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 24 | |||||||||||||
5562 | 5562 | Joseph Vance V000017 | rep | OH | 1843-12-04 | 1845-03-03 | Whig | 4 | |||||||||||||
5544 | 5544 | Daniel Tilden T000270 | rep | OH | 1843-12-04 | 1845-03-03 | Whig | 19 | |||||||||||||
5542 | 5542 | John Tibbatts T000261 | rep | KY | 1843-12-04 | 1845-03-03 | Democrat | 10 | |||||||||||||
5540 | 5540 | William Thomasson T000190 | rep | KY | 1843-12-04 | 1845-03-03 | Whig | 7 | |||||||||||||
5538 | 5538 | William Taylor T000104 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 11 | |||||||||||||
5536 | 5536 | George Sykes S001131 | rep | NJ | 1843-12-04 | 1845-03-03 | Democrat | 2 |
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);