legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
262 rows where "end" is on date 1847-03-03
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5523 | 5523 | Thomas Smith S000615 | rep | IN | 1845-12-01 | 1847-03-03 | Democrat | 3 | |||||||||||||
5530 | 5530 | Henry St. John S000767 | rep | OH | 1845-12-01 | 1847-03-03 | Democrat | 6 | |||||||||||||
5532 | 5532 | David Starkweather S000813 | rep | OH | 1845-12-01 | 1847-03-03 | Democrat | 18 | |||||||||||||
5533 | 5533 | Stephen Strong S001018 | rep | NY | 1845-12-01 | 1847-03-03 | Democrat | 22 | |||||||||||||
5537 | 5537 | George Sykes S001131 | rep | NJ | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5539 | 5539 | William Taylor T000104 | rep | VA | 1845-12-01 | 1847-03-03 | Democrat | 11 | |||||||||||||
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 | |||||||||||||
5545 | 5545 | Daniel Tilden T000270 | rep | OH | 1845-12-01 | 1847-03-03 | Whig | 19 | |||||||||||||
5548 | 5548 | George Towns T000327 | rep | GA | 1845-12-01 | 1847-03-03 | Democrat | 3 | |||||||||||||
5549 | 5549 | William Tredway T000360 | rep | VA | 1845-12-01 | 1847-03-03 | Democrat | 3 | |||||||||||||
5550 | 5550 | Andrew Trumbo T000388 | rep | KY | 1845-12-01 | 1847-03-03 | Whig | 9 | |||||||||||||
5563 | 5563 | Joseph Vance V000017 | rep | OH | 1845-12-01 | 1847-03-03 | Whig | 4 | |||||||||||||
5574 | 5574 | Horace Wheaton W000328 | rep | NY | 1845-12-01 | 1847-03-03 | Democrat | 24 | |||||||||||||
5575 | 5575 | Bradford Wood W000692 | rep | NY | 1845-12-01 | 1847-03-03 | Democrat | 13 | |||||||||||||
5576 | 5576 | Thomas Woodruff W000719 | rep | NY | 1845-12-01 | 1847-03-03 | American | 5 | |||||||||||||
5577 | 5577 | William Woodworth W000736 | rep | NY | 1845-12-01 | 1847-03-03 | Democrat | 8 | |||||||||||||
5578 | 5578 | Samuel Wright W000769 | rep | NJ | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
5580 | 5580 | William Yancey Y000003 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 3 | |||||||||||||
5583 | 5583 | Archibald Yell Y000017 | rep | AR | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5585 | 5585 | Jacob Yost Y000026 | rep | PA | 1845-12-01 | 1847-03-03 | Democrat | 5 | |||||||||||||
5586 | 5586 | Bryan Young Y000030 | rep | KY | 1845-12-01 | 1847-03-03 | Whig | 5 | |||||||||||||
5587 | 5587 | Joseph Cilley C000396 | sen | NH | 1846-01-01 | 1847-03-03 | 2 | Liberty | |||||||||||||
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 | |||||||||||||
5601 | 5601 | Chester Ashley A000311 | sen | AR | 1844-01-01 | 1847-03-03 | 2 | Democrat | |||||||||||||
5604 | 5604 | Archibald Atkinson A000328 | rep | VA | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5608 | 5608 | Daniel Barringer B000182 | rep | NC | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
5611 | 5611 | Henry Bedinger B000302 | rep | VA | 1845-12-01 | 1847-03-03 | Democrat | 10 | |||||||||||||
5615 | 5615 | John Berrien B000413 | sen | GA | 1841-05-31 | 1847-03-03 | 2 | Whig | |||||||||||||
5619 | 5619 | James Black B000501 | rep | SC | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5622 | 5622 | John Blanchard B000539 | rep | PA | 1845-12-01 | 1847-03-03 | Whig | 17 | |||||||||||||
5640 | 5640 | John Calhoun C000044 | sen | SC | 1845-12-01 | 1847-03-03 | 2 | Democrat | |||||||||||||
5643 | 5643 | John Chapman C000314 | rep | MD | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
5645 | 5645 | Lucien Chase C000330 | rep | TN | 1845-12-01 | 1847-03-03 | Democrat | 9 | |||||||||||||
5651 | 5651 | William Cocke C000573 | rep | TN | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
5658 | 5658 | John Crozier C000951 | rep | TN | 1845-12-01 | 1847-03-03 | Whig | 3 | |||||||||||||
5660 | 5660 | John Cummins C000989 | rep | OH | 1845-12-01 | 1847-03-03 | Democrat | 16 | |||||||||||||
5669 | 5669 | John Davis D000117 | sen | MA | 1845-12-01 | 1847-03-03 | 2 | Whig | |||||||||||||
5679 | 5679 | George Dromgoole D000504 | rep | VA | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5684 | 5684 | Joseph Edsall E000059 | rep | NJ | 1845-12-01 | 1847-03-03 | Democrat | 4 | |||||||||||||
5688 | 5688 | James Faran F000014 | rep | OH | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5698 | 5698 | George Fries F000386 | rep | OH | 1845-12-01 | 1847-03-03 | Democrat | 17 | |||||||||||||
5709 | 5709 | Artemas Hale H000028 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 9 | |||||||||||||
5713 | 5713 | James Hampton H000138 | rep | NJ | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
5717 | 5717 | Thomas Henley H000499 | rep | IN | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5721 | 5721 | Elias Holmes H000736 | rep | NY | 1845-12-01 | 1847-03-03 | Whig | 28 | |||||||||||||
5724 | 5724 | Samuel Hubbard H000889 | rep | CT | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
5728 | 5728 | Charles Hudson H000907 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 5 | |||||||||||||
5731 | 5731 | Washington Hunt H000978 | rep | NY | 1845-12-01 | 1847-03-03 | Whig | 34 | |||||||||||||
5736 | 5736 | Charles Ingersoll I000015 | rep | PA | 1845-12-01 | 1847-03-03 | Democrat | 4 | |||||||||||||
5741 | 5741 | Joseph Ingersoll I000019 | rep | PA | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
5748 | 5748 | James Johnson J000146 | rep | NH | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5763 | 5763 | Dixon Lewis L000278 | sen | AL | 1844-04-22 | 1847-03-03 | 2 | Democrat | |||||||||||||
5765 | 5765 | Thomas Ligon L000307 | rep | MD | 1845-12-01 | 1847-03-03 | Democrat | 3 | |||||||||||||
5772 | 5772 | Willie Mangum M000096 | sen | NC | 1841-03-04 | 1847-03-03 | 2 | Whig | |||||||||||||
5779 | 5779 | Robert McClelland M000334 | rep | MI | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5782 | 5782 | Abraham McIlvaine M000474 | rep | PA | 1845-12-01 | 1847-03-03 | Whig | 7 | |||||||||||||
5791 | 5791 | James McKay M000489 | rep | NC | 1845-12-01 | 1847-03-03 | Democrat | 6 | |||||||||||||
5793 | 5793 | Jacob Miller M000731 | sen | NJ | 1841-05-31 | 1847-03-03 | 2 | Whig | |||||||||||||
5800 | 5800 | John Pendleton P000206 | rep | VA | 1845-12-01 | 1847-03-03 | Whig | 9 | |||||||||||||
5803 | 5803 | Timothy Pilsbury P000353 | rep | TX | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5806 | 5806 | James Pollock P000416 | rep | PA | 1845-12-01 | 1847-03-03 | Whig | 13 | |||||||||||||
5810 | 5810 | John Rockwell R000367 | rep | CT | 1845-12-01 | 1847-03-03 | Whig | 3 | |||||||||||||
5813 | 5813 | William Sawyer S000095 | rep | OH | 1845-12-01 | 1847-03-03 | Democrat | 5 | |||||||||||||
5817 | 5817 | Richard Simpson S000435 | rep | SC | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5819 | 5819 | Alexander Sims S000438 | rep | SC | 1845-12-01 | 1847-03-03 | Democrat | 4 | |||||||||||||
5823 | 5823 | Caleb Smith S000519 | rep | IN | 1845-12-01 | 1847-03-03 | Whig | 4 | |||||||||||||
5835 | 5835 | Andrew Stewart S000899 | rep | PA | 1845-12-01 | 1847-03-03 | Whig | 18 | |||||||||||||
5837 | 5837 | John Strohm S001008 | rep | PA | 1845-12-01 | 1847-03-03 | Whig | 8 | |||||||||||||
5840 | 5840 | Bannon Thibodeaux T000152 | rep | LA | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
5855 | 5855 | William Wick W000436 | rep | IN | 1845-12-01 | 1847-03-03 | Democrat | 5 | |||||||||||||
5858 | 5858 | Hezekiah Williams W000504 | rep | ME | 1845-12-01 | 1847-03-03 | Democrat | 7 | |||||||||||||
5894 | 5894 | George Ashmun A000318 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 6 | |||||||||||||
5905 | 5905 | Franklin Bowdon B000680 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 7 | |||||||||||||
5909 | 5909 | James Bowlin B000701 | rep | MO | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5985 | 5985 | Joseph Grinnell G000477 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 10 | |||||||||||||
5993 | 5993 | Hugh Haralson H000178 | rep | GA | 1845-12-01 | 1847-03-03 | Democrat | 4 | |||||||||||||
5996 | 5996 | John Harmanson H000214 | rep | LA | 1845-12-01 | 1847-03-03 | Democrat | 3 | |||||||||||||
6003 | 6003 | Henry Hilliard H000622 | rep | AL | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
6010 | 6010 | Isaac Holmes H000738 | rep | SC | 1845-12-01 | 1847-03-03 | Democrat | 6 | |||||||||||||
6013 | 6013 | John Houston H000825 | rep | DE | 1845-12-01 | 1847-03-03 | Whig | 0 | |||||||||||||
6022 | 6022 | David Kaufman K000021 | rep | TX | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
6027 | 6027 | Daniel King K000198 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
6034 | 6034 | Thomas King K000215 | rep | GA | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
6037 | 6037 | Emile La Sére L000008 | rep | LA | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
6040 | 6040 | Shepherd Leffler L000215 | rep | IA | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
6043 | 6043 | Lewis Levin L000262 | rep | PA | 1845-12-01 | 1847-03-03 | American | 1 | |||||||||||||
6052 | 6052 | George Marsh M000147 | rep | VT | 1845-12-01 | 1847-03-03 | Whig | 3 | |||||||||||||
6055 | 6055 | James McDowell M000419 | rep | VA | 1845-12-01 | 1847-03-03 | Democrat | 11 | |||||||||||||
6058 | 6058 | Edward McGaughey M000443 | rep | IN | 1845-12-01 | 1847-03-03 | Whig | 7 | |||||||||||||
6071 | 6071 | Isaac Morse M001011 | rep | LA | 1845-12-01 | 1847-03-03 | Democrat | 4 | |||||||||||||
6083 | 6083 | Moses Norris N000140 | rep | NH | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
6103 | 6103 | Joseph Root R000433 | rep | OH | 1845-12-01 | 1847-03-03 | Whig | 21 | |||||||||||||
6110 | 6110 | Cullen Sawtelle S000085 | rep | ME | 1845-12-01 | 1847-03-03 | Democrat | 5 | |||||||||||||
6112 | 6112 | James Seddon S000220 | rep | VA | 1845-12-01 | 1847-03-03 | Democrat | 6 | |||||||||||||
6127 | 6127 | Truman Smith S000621 | rep | CT | 1845-12-01 | 1847-03-03 | Whig | 4 | |||||||||||||
6140 | 6140 | Jacob Thompson T000203 | rep | MS | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
6143 | 6143 | James Thompson T000204 | rep | PA | 1845-12-01 | 1847-03-03 | Democrat | 23 | |||||||||||||
6163 | 6163 | Samuel Vinton V000107 | rep | OH | 1845-12-01 | 1847-03-03 | Whig | 12 |
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);