legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
273 rows where "end" is on date 1851-03-03
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5338 | 5338 | Daniel Dickinson D000317 | sen | NY | 1845-03-04 | 1851-03-03 | 1 | Democrat | |||||||||||||
5407 | 5407 | William Dayton D000166 | sen | NJ | 1845-12-01 | 1851-03-03 | 1 | Whig | |||||||||||||
5434 | 5434 | Albert Greene G000424 | sen | RI | 1845-12-01 | 1851-03-03 | 1 | Whig | |||||||||||||
5535 | 5535 | Daniel Sturgeon S001046 | sen | PA | 1845-12-01 | 1851-03-03 | 1 | Democrat | |||||||||||||
5554 | 5554 | Hopkins Turney T000430 | sen | TN | 1845-12-01 | 1851-03-03 | 1 | Democrat | |||||||||||||
5606 | 5606 | Roger Baldwin B000096 | sen | CT | 1847-12-06 | 1851-03-03 | 1 | Whig | |||||||||||||
5641 | 5641 | John Calhoun C000044 | sen | SC | 1847-12-06 | 1851-03-03 | 2 | Democrat | |||||||||||||
5889 | 5889 | Nathaniel Albertson A000075 | rep | IN | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
5890 | 5890 | Henry Alexander A000093 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 17 | |||||||||||||
5891 | 5891 | William Alston A000166 | rep | AL | 1849-12-03 | 1851-03-03 | Whig | 1 | |||||||||||||
5892 | 5892 | Josiah Anderson A000199 | rep | TN | 1849-12-03 | 1851-03-03 | Whig | 3 | |||||||||||||
5893 | 5893 | George Andrews A000245 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 14 | |||||||||||||
5896 | 5896 | George Ashmun A000318 | rep | MA | 1849-12-03 | 1851-03-03 | Whig | 6 | |||||||||||||
5901 | 5901 | William Bay B000247 | rep | MO | 1849-12-03 | 1851-03-03 | Democrat | 2 | |||||||||||||
5902 | 5902 | John Bell B000339 | rep | OH | 1849-12-03 | 1851-03-03 | Whig | 6 | |||||||||||||
5903 | 5903 | David Bokee B000599 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
5904 | 5904 | Walter Booth B000631 | rep | CT | 1849-12-03 | 1851-03-03 | Free Soil | 2 | |||||||||||||
5907 | 5907 | Franklin Bowdon B000680 | rep | AL | 1849-12-03 | 1851-03-03 | Democrat | 7 | |||||||||||||
5911 | 5911 | James Bowlin B000701 | rep | MO | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
5912 | 5912 | Daniel Breck B000782 | rep | KY | 1849-12-03 | 1851-03-03 | Whig | 6 | |||||||||||||
5913 | 5913 | John Brisbin B000841 | rep | PA | 1849-12-03 | 1851-03-03 | Democrat | 11 | |||||||||||||
5915 | 5915 | William Brown B000950 | rep | IN | 1849-12-03 | 1851-03-03 | Democrat | 5 | |||||||||||||
5916 | 5916 | Alexander Buel B001037 | rep | MI | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
5919 | 5919 | Henry Bullard B001049 | rep | LA | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
5921 | 5921 | Chester Butler B001175 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 11 | |||||||||||||
5922 | 5922 | Thomas Butler B001191 | rep | CT | 1849-12-03 | 1851-03-03 | Whig | 4 | |||||||||||||
5924 | 5924 | George Caldwell C000031 | rep | KY | 1849-12-03 | 1851-03-03 | Democrat | 4 | |||||||||||||
5925 | 5925 | Samuel Calvin C000060 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 17 | |||||||||||||
5926 | 5926 | Joseph Casey C000224 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 13 | |||||||||||||
5927 | 5927 | Charles Clarke C000459 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 19 | |||||||||||||
5941 | 5941 | Orsamus Cole C000611 | rep | WI | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
5943 | 5943 | Harmon Conger C000676 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 25 | |||||||||||||
5945 | 5945 | Charles Conrad C000703 | rep | LA | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
5950 | 5950 | John Crowell C000941 | rep | OH | 1849-12-03 | 1851-03-03 | Whig | 19 | |||||||||||||
5951 | 5951 | Joel Danner D000045 | rep | PA | 1849-12-03 | 1851-03-03 | Democrat | 15 | |||||||||||||
5964 | 5964 | Edmund Deberry D000181 | rep | NC | 1849-12-03 | 1851-03-03 | Whig | 3 | |||||||||||||
5965 | 5965 | Jesse Dickey D000313 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 7 | |||||||||||||
5967 | 5967 | Rodolphus Dickinson D000325 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 6 | |||||||||||||
5969 | 5969 | William Duer D000515 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 23 | |||||||||||||
5970 | 5970 | Samuel Eliot E000105 | rep | MA | 1849-12-03 | 1851-03-03 | Whig | 1 | |||||||||||||
5972 | 5972 | Nathan Evans E000255 | rep | OH | 1849-12-03 | 1851-03-03 | Whig | 14 | |||||||||||||
5973 | 5973 | Andrew Ewing E000275 | rep | TN | 1849-12-03 | 1851-03-03 | Democrat | 8 | |||||||||||||
5975 | 5975 | Winfield Featherston F000055 | rep | MS | 1849-12-03 | 1851-03-03 | Democrat | 2 | |||||||||||||
5977 | 5977 | John Freedley F000360 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 5 | |||||||||||||
5978 | 5978 | Elbridge Gerry G000138 | rep | ME | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
5979 | 5979 | Edward Gilbert G000172 | rep | CA | 1849-12-03 | 1851-03-03 | Democrat | -1 | |||||||||||||
5980 | 5980 | Rufus Goodenow G000285 | rep | ME | 1849-12-03 | 1851-03-03 | Whig | 4 | |||||||||||||
5982 | 5982 | Daniel Gott G000339 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 24 | |||||||||||||
5983 | 5983 | Herman Gould G000341 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 10 | |||||||||||||
5987 | 5987 | Joseph Grinnell G000477 | rep | MA | 1849-12-03 | 1851-03-03 | Whig | 10 | |||||||||||||
5988 | 5988 | Thomas Hackett H000005 | rep | GA | 1849-12-03 | 1851-03-03 | Democrat | 5 | |||||||||||||
5989 | 5989 | Ransom Halloway H000083 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 8 | |||||||||||||
5991 | 5991 | Moses Hampton H000139 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 21 | |||||||||||||
5995 | 5995 | Hugh Haralson H000178 | rep | GA | 1849-12-03 | 1851-03-03 | Democrat | 4 | |||||||||||||
5998 | 5998 | John Harmanson H000214 | rep | LA | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
5999 | 5999 | Andrew Hay H000381 | rep | NJ | 1849-12-03 | 1851-03-03 | Whig | 1 | |||||||||||||
6000 | 6000 | Thomas Haymond H000395 | rep | VA | 1849-12-03 | 1851-03-03 | Whig | 15 | |||||||||||||
6002 | 6002 | William Henry H000520 | rep | VT | 1849-12-03 | 1851-03-03 | Whig | 1 | |||||||||||||
6005 | 6005 | Henry Hilliard H000622 | rep | AL | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
6006 | 6006 | Moses Hoagland H000651 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 16 | |||||||||||||
6012 | 6012 | Isaac Holmes H000738 | rep | SC | 1849-12-03 | 1851-03-03 | Democrat | 6 | |||||||||||||
6015 | 6015 | John Houston H000825 | rep | DE | 1849-12-03 | 1851-03-03 | Whig | 0 | |||||||||||||
6017 | 6017 | David Hubbard H000880 | rep | AL | 1849-12-03 | 1851-03-03 | Democrat | 5 | |||||||||||||
6019 | 6019 | Samuel Inge I000013 | rep | AL | 1849-12-03 | 1851-03-03 | Democrat | 4 | |||||||||||||
6020 | 6020 | William Jackson J000031 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 26 | |||||||||||||
6021 | 6021 | James Johnson J000147 | rep | KY | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
6024 | 6024 | David Kaufman K000021 | rep | TX | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
6025 | 6025 | John Kerr K000137 | rep | MD | 1849-12-03 | 1851-03-03 | Whig | 6 | |||||||||||||
6029 | 6029 | Daniel King K000198 | rep | MA | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
6030 | 6030 | James King K000203 | rep | NJ | 1849-12-03 | 1851-03-03 | Whig | 5 | |||||||||||||
6031 | 6031 | John King K000205 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 1 | |||||||||||||
6036 | 6036 | Thomas King K000215 | rep | GA | 1849-12-03 | 1851-03-03 | Whig | 1 | |||||||||||||
6039 | 6039 | Emile La Sére L000008 | rep | LA | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
6042 | 6042 | Shepherd Leffler L000215 | rep | IA | 1849-12-03 | 1851-03-03 | Democrat | 2 | |||||||||||||
6045 | 6045 | Lewis Levin L000262 | rep | PA | 1849-12-03 | 1851-03-03 | American | 1 | |||||||||||||
6047 | 6047 | Nathaniel Littlefield L000356 | rep | ME | 1849-12-03 | 1851-03-03 | Democrat | 2 | |||||||||||||
6050 | 6050 | Job Mann M000106 | rep | PA | 1849-12-03 | 1851-03-03 | Democrat | 19 | |||||||||||||
6054 | 6054 | George Marsh M000147 | rep | VT | 1849-12-03 | 1851-03-03 | Whig | 3 | |||||||||||||
6057 | 6057 | James McDowell M000419 | rep | VA | 1849-12-03 | 1851-03-03 | Democrat | 11 | |||||||||||||
6059 | 6059 | Edward McGaughey M000443 | rep | IN | 1849-12-03 | 1851-03-03 | Whig | 7 | |||||||||||||
6060 | 6060 | Thomas McKissock M000529 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 9 | |||||||||||||
6061 | 6061 | Finis McLean M000546 | rep | KY | 1849-12-03 | 1851-03-03 | Whig | 3 | |||||||||||||
6062 | 6062 | William McWillie M000612 | rep | MS | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
6063 | 6063 | Daniel Miller M000721 | rep | IA | 1849-12-03 | 1851-03-03 | Whig | 1 | |||||||||||||
6065 | 6065 | John Miller M000742 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 11 | |||||||||||||
6067 | 6067 | Charles Morehead M000936 | rep | KY | 1849-12-03 | 1851-03-03 | Whig | 8 | |||||||||||||
6069 | 6069 | Jonathan Morris M000979 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 7 | |||||||||||||
6073 | 6073 | Isaac Morse M001011 | rep | LA | 1849-12-03 | 1851-03-03 | Democrat | 4 | |||||||||||||
6075 | 6075 | Jeremiah Morton M001016 | rep | VA | 1849-12-03 | 1851-03-03 | Whig | 9 | |||||||||||||
6077 | 6077 | William Nelson N000045 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 7 | |||||||||||||
6080 | 6080 | Henry Nes N000047 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 15 | |||||||||||||
6081 | 6081 | Alexander Newman N000070 | rep | VA | 1849-12-03 | 1851-03-03 | Democrat | 15 | |||||||||||||
6085 | 6085 | Andrew Ogle O000046 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 18 | |||||||||||||
6086 | 6086 | John Otis O000128 | rep | ME | 1849-12-03 | 1851-03-03 | Whig | 3 | |||||||||||||
6087 | 6087 | Allen Owen O000148 | rep | GA | 1849-12-03 | 1851-03-03 | Whig | 3 | |||||||||||||
6088 | 6088 | Richard Parker P000068 | rep | VA | 1849-12-03 | 1851-03-03 | Democrat | 10 | |||||||||||||
6090 | 6090 | Lucius Peck P000178 | rep | VT | 1849-12-03 | 1851-03-03 | Democrat | 4 | |||||||||||||
6092 | 6092 | Jonas Phoenix P000319 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 3 | |||||||||||||
6093 | 6093 | Charles Pitman P000369 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 14 | |||||||||||||
6095 | 6095 | Emery Potter P000464 | rep | OH | 1849-12-03 | 1851-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);