legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
121 rows where "end" is on date 1851-03-03 and party = "Whig"
This data as json, copyable, CSV (advanced)
Suggested facets: state, start (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
5606 | 5606 | Roger Baldwin B000096 | sen | CT | 1847-12-06 | 1851-03-03 | 1 | Whig | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
5912 | 5912 | Daniel Breck B000782 | rep | KY | 1849-12-03 | 1851-03-03 | Whig | 6 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
5977 | 5977 | John Freedley F000360 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 5 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
6015 | 6015 | John Houston H000825 | rep | DE | 1849-12-03 | 1851-03-03 | Whig | 0 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
6054 | 6054 | George Marsh M000147 | rep | VT | 1849-12-03 | 1851-03-03 | Whig | 3 | |||||||||||||
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 | |||||||||||||
6063 | 6063 | Daniel Miller M000721 | rep | IA | 1849-12-03 | 1851-03-03 | Whig | 1 | |||||||||||||
6067 | 6067 | Charles Morehead M000936 | rep | KY | 1849-12-03 | 1851-03-03 | Whig | 8 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
6098 | 6098 | Harvey Putnam P000580 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 33 | |||||||||||||
6099 | 6099 | Robert Reed R000126 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 20 | |||||||||||||
6101 | 6101 | Gideon Reynolds R000172 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 12 | |||||||||||||
6102 | 6102 | Elijah Risley R000270 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 31 | |||||||||||||
6107 | 6107 | Robert Rose R000438 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 29 | |||||||||||||
6109 | 6109 | David Rumsey R000506 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 30 | |||||||||||||
6122 | 6122 | Augustine Shepperd S000338 | rep | NC | 1849-12-03 | 1851-03-03 | Whig | 4 | |||||||||||||
6124 | 6124 | Peter Silvester S000413 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 11 | |||||||||||||
6132 | 6132 | William Sprague S000745 | rep | MI | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
6134 | 6134 | David Stewart S000905 | sen | MD | 1849-12-03 | 1851-03-03 | 1 | Whig | |||||||||||||
6148 | 6148 | John Thurman T000252 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 15 | |||||||||||||
6150 | 6150 | Walter Underhill U000009 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 4 | |||||||||||||
6154 | 6154 | John Van Dyke V000035 | rep | NJ | 1849-12-03 | 1851-03-03 | Whig | 4 | |||||||||||||
6165 | 6165 | Samuel Vinton V000107 | rep | OH | 1849-12-03 | 1851-03-03 | Whig | 12 | |||||||||||||
6168 | 6168 | John Wales W000043 | sen | DE | 1849-12-03 | 1851-03-03 | 1 | Whig | |||||||||||||
6173 | 6173 | Hugh White W000375 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 16 | |||||||||||||
6176 | 6176 | James Wilson W000587 | rep | NH | 1849-12-03 | 1851-03-03 | Whig | 3 | |||||||||||||
6187 | 6187 | Thomas Ewing E000281 | sen | OH | 1850-01-01 | 1851-03-03 | 1 | Whig | |||||||||||||
6203 | 6203 | Robert Winthrop W000646 | sen | MA | 1850-01-01 | 1851-03-03 | 1 | Whig | |||||||||||||
6223 | 6223 | Richard Bowie B000694 | rep | MD | 1849-12-03 | 1851-03-03 | Whig | 1 | |||||||||||||
6234 | 6234 | Lorenzo Burrows B001143 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 34 | |||||||||||||
6244 | 6244 | Edward Cabell C000003 | rep | FL | 1849-12-03 | 1851-03-03 | Whig | 1 | |||||||||||||
6248 | 6248 | Joseph Caldwell C000037 | rep | NC | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
6284 | 6284 | James Duncan D000532 | rep | MA | 1849-12-03 | 1851-03-03 | Whig | 3 | |||||||||||||
6287 | 6287 | Alexander Evans E000231 | rep | MD | 1849-12-03 | 1851-03-03 | Whig | 5 | |||||||||||||
6299 | 6299 | Orin Fowler F000325 | rep | MA | 1849-12-03 | 1851-03-03 | Whig | 9 | |||||||||||||
6307 | 6307 | Meredith Gentry G000125 | rep | TN | 1849-12-03 | 1851-03-03 | Whig | 7 | |||||||||||||
6327 | 6327 | William Hebard H000435 | rep | VT | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
6337 | 6337 | William Hunter H000992 | rep | OH | 1849-12-03 | 1851-03-03 | Whig | 15 | |||||||||||||
6349 | 6349 | George King K000201 | rep | RI | 1849-12-03 | 1851-03-03 | Whig | 1 | |||||||||||||
6355 | 6355 | Horace Mann M000102 | rep | MA | 1849-12-03 | 1851-03-03 | Whig | 8 | |||||||||||||
6367 | 6367 | Henry Moore M000900 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 3 | |||||||||||||
6378 | 6378 | David Outlaw O000138 | rep | NC | 1849-12-03 | 1851-03-03 | Whig | 9 | |||||||||||||
6404 | 6404 | William Sackett S000007 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 27 | |||||||||||||
6406 | 6406 | Abraham Schermerhorn S000122 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 28 | |||||||||||||
6408 | 6408 | John Schoolcraft S000139 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 13 | |||||||||||||
6423 | 6423 | Edward Stanly S000799 | rep | NC | 1849-12-03 | 1851-03-03 | Whig | 8 | |||||||||||||
6459 | 6459 | Christopher Williams W000493 | rep | TN | 1849-12-03 | 1851-03-03 | Whig | 11 | |||||||||||||
6535 | 6535 | Joseph Chandler C000292 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
6554 | 6554 | Moses Corwin C000790 | rep | OH | 1849-12-03 | 1851-03-03 | Whig | 4 | |||||||||||||
6673 | 6673 | Samuel Phelps P000299 | sen | VT | 1845-12-01 | 1851-03-03 | 1 | Whig |
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);