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 1853-12-05
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6675 | 6675 | Philip Phillips P000311 | rep | AL | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6676 | 6676 | James Pratt P000502 | rep | CT | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6678 | 6678 | William Preston P000517 | rep | KY | 1853-12-05 | 1855-03-03 | Whig | 7 | |||||||||||||
6679 | 6679 | David Reese R000135 | rep | GA | 1853-12-05 | 1855-03-03 | Whig | 7 | |||||||||||||
6681 | 6681 | Thomas Ritchey R000271 | rep | OH | 1853-12-05 | 1855-03-03 | Democrat | 11 | |||||||||||||
6682 | 6682 | Peter Rowe R000477 | rep | NY | 1853-12-05 | 1855-03-03 | Democrat | 18 | |||||||||||||
6683 | 6683 | Samuel Russell R000539 | rep | PA | 1853-12-05 | 1855-03-03 | Whig | 17 | |||||||||||||
6685 | 6685 | Zeno Scudder S000204 | rep | MA | 1853-12-05 | 1855-03-03 | Whig | 1 | |||||||||||||
6687 | 6687 | Origen Seymour S000270 | rep | CT | 1853-12-05 | 1855-03-03 | Democrat | 4 | |||||||||||||
6688 | 6688 | Wilson Shannon S000291 | rep | OH | 1853-12-05 | 1855-03-03 | Democrat | 17 | |||||||||||||
6689 | 6689 | Jacob Shower S000386 | rep | MD | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
6691 | 6691 | Charles Skelton S000464 | rep | NJ | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
6692 | 6692 | Gerrit Smith S000542 | rep | NY | 1853-12-05 | 1855-03-03 | Free Soil | 22 | |||||||||||||
6693 | 6693 | George Smyth S000647 | rep | TX | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6694 | 6694 | John Snodgrass S000656 | rep | VA | 1853-12-05 | 1855-03-03 | Democrat | 11 | |||||||||||||
6696 | 6696 | Augustus Sollers S000674 | rep | MD | 1853-12-05 | 1855-03-03 | Whig | 6 | |||||||||||||
6701 | 6701 | Frederick Stanton S000802 | rep | TN | 1853-12-05 | 1855-03-03 | Democrat | 10 | |||||||||||||
6704 | 6704 | Richard Stanton S000806 | rep | KY | 1853-12-05 | 1855-03-03 | Democrat | 10 | |||||||||||||
6705 | 6705 | Hestor Stevens S000879 | rep | MI | 1853-12-05 | 1855-03-03 | Democrat | 4 | |||||||||||||
6707 | 6707 | Nathan Stratton S000996 | rep | NJ | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6708 | 6708 | Christian Straub S000999 | rep | PA | 1853-12-05 | 1855-03-03 | Democrat | 11 | |||||||||||||
6709 | 6709 | Andrew Stuart S001031 | rep | OH | 1853-12-05 | 1855-03-03 | Democrat | 21 | |||||||||||||
6712 | 6712 | Charles Stuart S001033 | sen | MI | 1853-12-05 | 1859-03-03 | 2 | Democrat | |||||||||||||
6713 | 6713 | David Stuart S001034 | rep | MI | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6714 | 6714 | John Taylor T000088 | rep | NY | 1853-12-05 | 1855-03-03 | Democrat | 27 | |||||||||||||
6718 | 6718 | John Taylor T000089 | rep | OH | 1853-12-05 | 1855-03-03 | Whig | 10 | |||||||||||||
6719 | 6719 | Isaac Teller T000117 | rep | NY | 1853-12-05 | 1855-03-03 | Whig | 12 | |||||||||||||
6724 | 6724 | John Thompson T000208 | sen | KY | 1853-12-05 | 1859-03-03 | 2 | American | |||||||||||||
6725 | 6725 | Andrew Tracy T000344 | rep | VT | 1853-12-05 | 1855-03-03 | Whig | 2 | |||||||||||||
6726 | 6726 | Michael Trout T000383 | rep | PA | 1853-12-05 | 1855-03-03 | Democrat | 23 | |||||||||||||
6727 | 6727 | William Tweed T000440 | rep | NY | 1853-12-05 | 1855-03-03 | Democrat | 5 | |||||||||||||
6728 | 6728 | Charles Upham U000021 | rep | MA | 1853-12-05 | 1855-03-03 | Whig | 6 | |||||||||||||
6729 | 6729 | Joshua Van Sant V000057 | rep | MD | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
6730 | 6730 | Hiram Walbridge W000031 | rep | NY | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
6731 | 6731 | William Walker W000070 | rep | NY | 1853-12-05 | 1855-03-03 | Democrat | 7 | |||||||||||||
6732 | 6732 | Samuel Walley W000087 | rep | MA | 1853-12-05 | 1855-03-03 | Whig | 4 | |||||||||||||
6733 | 6733 | Michael Walsh W000102 | rep | NY | 1853-12-05 | 1855-03-03 | Democrat | 4 | |||||||||||||
6734 | 6734 | Tappan Wentworth W000297 | rep | MA | 1853-12-05 | 1855-03-03 | Whig | 8 | |||||||||||||
6735 | 6735 | Theodoric Westbrook W000307 | rep | NY | 1853-12-05 | 1855-03-03 | Democrat | 11 | |||||||||||||
6738 | 6738 | Jared Williams W000511 | sen | NH | 1853-12-05 | 1855-03-03 | 2 | Democrat | |||||||||||||
6739 | 6739 | William Witte W000664 | rep | PA | 1853-12-05 | 1855-03-03 | Democrat | 4 | |||||||||||||
6751 | 6751 | William Aiken A000063 | rep | SC | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
6758 | 6758 | Edward Ball B000098 | rep | OH | 1853-12-05 | 1855-03-03 | Whig | 16 | |||||||||||||
6767 | 6767 | Thomas Bayly B000259 | rep | VA | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6770 | 6770 | Peter Bell B000344 | rep | TX | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
6773 | 6773 | Samuel Benson B000390 | rep | ME | 1853-12-05 | 1855-03-03 | Whig | 4 | |||||||||||||
6793 | 6793 | Leander Cox C000837 | rep | KY | 1853-12-05 | 1855-03-03 | Whig | 9 | |||||||||||||
6796 | 6796 | William Cumback C000980 | rep | NY | 1853-12-05 | 1855-03-03 | Democrat | -1 | |||||||||||||
6800 | 6800 | Alexander De Witt D000282 | rep | MA | 1853-12-05 | 1855-03-03 | Free Soil | 9 | |||||||||||||
6813 | 6813 | Benjamin Fitzpatrick F000174 | sen | AL | 1853-12-05 | 1855-03-03 | 3 | Democrat | |||||||||||||
6815 | 6815 | Thomas Flagler F000181 | rep | NY | 1853-12-05 | 1855-03-03 | Whig | 31 | |||||||||||||
6822 | 6822 | Thomas Fuller F000412 | rep | ME | 1853-12-05 | 1855-03-03 | Democrat | 6 | |||||||||||||
6830 | 6830 | Sampson Harris H000252 | rep | AL | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
6832 | 6832 | John Harrison H000272 | rep | OH | 1853-12-05 | 1855-03-03 | Whig | 2 | |||||||||||||
6835 | 6835 | Solomon Haven H000355 | rep | NY | 1853-12-05 | 1855-03-03 | Whig | 32 | |||||||||||||
6848 | 6848 | Robert Johnson J000172 | sen | AR | 1853-12-05 | 1855-03-03 | 3 | Democrat | |||||||||||||
6851 | 6851 | Zedekiah Kidwell K000165 | rep | VA | 1853-12-05 | 1855-03-03 | Democrat | 10 | |||||||||||||
6856 | 6856 | James Knox K000295 | rep | IL | 1853-12-05 | 1855-03-03 | Whig | 4 | |||||||||||||
6859 | 6859 | James Lindley L000322 | rep | MO | 1853-12-05 | 1855-03-03 | Whig | 3 | |||||||||||||
6866 | 6866 | Daniel Mace M000008 | rep | IN | 1853-12-05 | 1855-03-03 | Democrat | 8 | |||||||||||||
6869 | 6869 | Augustus Maxwell M000266 | rep | FL | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6874 | 6874 | Fayette McMullen M000578 | rep | VA | 1853-12-05 | 1855-03-03 | Democrat | 13 | |||||||||||||
6878 | 6878 | James Meacham M000613 | rep | VT | 1853-12-05 | 1855-03-03 | Whig | 1 | |||||||||||||
6881 | 6881 | John Miller M000741 | rep | MO | 1853-12-05 | 1855-03-03 | Whig | 5 | |||||||||||||
6884 | 6884 | Smith Miller M000754 | rep | IN | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6887 | 6887 | Andrew Oliver O000070 | rep | NY | 1853-12-05 | 1855-03-03 | Democrat | 26 | |||||||||||||
6889 | 6889 | Mordecai Oliver O000075 | rep | MO | 1853-12-05 | 1855-03-03 | Whig | 4 | |||||||||||||
6891 | 6891 | Asa Packer P000006 | rep | PA | 1853-12-05 | 1855-03-03 | Democrat | 13 | |||||||||||||
6897 | 6897 | Alexander Pennington P000213 | rep | NJ | 1853-12-05 | 1855-03-03 | Whig | 5 | |||||||||||||
6901 | 6901 | Benjamin Pringle P000543 | rep | NY | 1853-12-05 | 1855-03-03 | Whig | 30 | |||||||||||||
6904 | 6904 | Richard Puryear P000578 | rep | NC | 1853-12-05 | 1855-03-03 | Whig | 6 | |||||||||||||
6909 | 6909 | Alvah Sabin S000002 | rep | VT | 1853-12-05 | 1855-03-03 | Whig | 3 | |||||||||||||
6911 | 6911 | Russell Sage S000013 | rep | NY | 1853-12-05 | 1855-03-03 | Whig | 13 | |||||||||||||
6913 | 6913 | William Sapp S000061 | rep | OH | 1853-12-05 | 1855-03-03 | Whig | 15 | |||||||||||||
6918 | 6918 | George Simmons S000416 | rep | NY | 1853-12-05 | 1855-03-03 | Whig | 16 | |||||||||||||
6922 | 6922 | John Slidell S000487 | sen | LA | 1853-12-05 | 1855-03-03 | 3 | Democrat | |||||||||||||
6925 | 6925 | William Smith S000637 | rep | AL | 1853-12-05 | 1855-03-03 | Democrat | 4 | |||||||||||||
6933 | 6933 | Benjamin Thurston T000255 | rep | RI | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
6937 | 6937 | George Vail V000001 | rep | NJ | 1853-12-05 | 1855-03-03 | Democrat | 4 | |||||||||||||
6945 | 6945 | Daniel Wells W000281 | rep | WI | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6948 | 6948 | John Wheeler W000337 | rep | NY | 1853-12-05 | 1855-03-03 | Democrat | 6 | |||||||||||||
6950 | 6950 | John Whitfield W000414 | rep | KS | 1853-12-05 | 1855-03-03 | Democrat | -1 | |||||||||||||
6955 | 6955 | Daniel Wright W000757 | rep | MS | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6978 | 6978 | Henry Bennett B000376 | rep | NY | 1853-12-05 | 1855-03-03 | Whig | 21 | |||||||||||||
6995 | 6995 | Preston Brooks B000885 | rep | SC | 1853-12-05 | 1855-03-03 | Democrat | 4 | |||||||||||||
7000 | 7000 | Samuel Caruthers C000210 | rep | MO | 1853-12-05 | 1855-03-03 | Whig | 7 | |||||||||||||
7004 | 7004 | John Caskie C000231 | rep | VA | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
7031 | 7031 | James Dowdell D000464 | rep | AL | 1853-12-05 | 1855-03-03 | Democrat | 7 | |||||||||||||
7038 | 7038 | John Elliott E000125 | rep | KY | 1853-12-05 | 1855-03-03 | Democrat | 6 | |||||||||||||
7056 | 7056 | Joshua Giddings G000167 | rep | OH | 1853-12-05 | 1855-03-03 | Free Soil | 20 | |||||||||||||
7061 | 7061 | Henry Goodwin G000300 | rep | NY | 1853-12-05 | 1855-03-03 | Whig | 22 | |||||||||||||
7068 | 7068 | Alfred Greenwood G000436 | rep | AR | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
7081 | 7081 | Aaron Harlan H000207 | rep | OH | 1853-12-05 | 1855-03-03 | Whig | 7 | |||||||||||||
7106 | 7106 | George Jones J000222 | rep | TN | 1853-12-05 | 1855-03-03 | Democrat | 6 | |||||||||||||
7110 | 7110 | Jehu Jones J000234 | rep | PA | 1853-12-05 | 1855-03-03 | Democrat | 8 | |||||||||||||
7134 | 7134 | John Letcher L000256 | rep | VA | 1853-12-05 | 1855-03-03 | Democrat | 9 | |||||||||||||
7153 | 7153 | Orsamus Matteson M000251 | rep | NY | 1853-12-05 | 1855-03-03 | Whig | 20 | |||||||||||||
7159 | 7159 | Edwin Morgan M000948 | rep | NY | 1853-12-05 | 1855-03-03 | Whig | 25 | |||||||||||||
7169 | 7169 | Matthias Nichols N000093 | rep | OH | 1853-12-05 | 1855-03-03 | Democrat | 4 | |||||||||||||
7175 | 7175 | James Orr O000104 | rep | SC | 1853-12-05 | 1855-03-03 | Democrat | 5 |
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);