legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
91 rows where party = "Whig" and "start" is on date 1851-12-01
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6215 | 6215 | Nelson Barrere B000174 | rep | OH | 1851-12-01 | 1853-03-03 | Whig | 7 | |||||||||||||
6221 | 6221 | Hiram Bell B000335 | rep | OH | 1851-12-01 | 1853-03-03 | Whig | 3 | |||||||||||||
6222 | 6222 | Thomas Bibighaus B000435 | rep | PA | 1851-12-01 | 1853-03-03 | Whig | 14 | |||||||||||||
6224 | 6224 | Richard Bowie B000694 | rep | MD | 1851-12-01 | 1853-03-03 | Whig | 1 | |||||||||||||
6225 | 6225 | Obadiah Bowne B000707 | rep | NY | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
6226 | 6226 | John Boyd B000718 | rep | NY | 1851-12-01 | 1853-03-03 | Whig | 14 | |||||||||||||
6232 | 6232 | George Brown B000920 | rep | NJ | 1851-12-01 | 1853-03-03 | Whig | 4 | |||||||||||||
6235 | 6235 | Lorenzo Burrows B001143 | rep | NY | 1851-12-01 | 1853-03-03 | Whig | 34 | |||||||||||||
6245 | 6245 | Edward Cabell C000003 | rep | FL | 1851-12-01 | 1853-03-03 | Whig | 1 | |||||||||||||
6249 | 6249 | Joseph Caldwell C000037 | rep | NC | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
6256 | 6256 | Charles Chapman C000310 | rep | CT | 1851-12-01 | 1853-03-03 | Whig | 1 | |||||||||||||
6262 | 6262 | James Conger C000677 | rep | MI | 1851-12-01 | 1853-03-03 | Whig | 3 | |||||||||||||
6270 | 6270 | John Darby D000049 | rep | MO | 1851-12-01 | 1853-03-03 | Whig | 1 | |||||||||||||
6271 | 6271 | George Davis D000101 | rep | MA | 1851-12-01 | 1853-03-03 | Whig | 6 | |||||||||||||
6275 | 6275 | Alfred Dockery D000385 | rep | NC | 1851-12-01 | 1853-03-03 | Whig | 3 | |||||||||||||
6285 | 6285 | James Duncan D000532 | rep | MA | 1851-12-01 | 1853-03-03 | Whig | 3 | |||||||||||||
6288 | 6288 | Alexander Evans E000231 | rep | MD | 1851-12-01 | 1853-03-03 | Whig | 5 | |||||||||||||
6289 | 6289 | Francis Fay F000050 | rep | MA | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
6300 | 6300 | Orin Fowler F000325 | rep | MA | 1851-12-01 | 1853-03-03 | Whig | 9 | |||||||||||||
6308 | 6308 | Meredith Gentry G000125 | rep | TN | 1851-12-01 | 1853-03-03 | Whig | 7 | |||||||||||||
6312 | 6312 | Robert Goodenow G000284 | rep | ME | 1851-12-01 | 1853-03-03 | Whig | 3 | |||||||||||||
6323 | 6323 | Alexander Harper H000219 | rep | OH | 1851-12-01 | 1853-03-03 | Whig | 14 | |||||||||||||
6325 | 6325 | Augustus Hascall H000315 | rep | NY | 1851-12-01 | 1853-03-03 | Whig | 33 | |||||||||||||
6326 | 6326 | John Haws H000380 | rep | NY | 1851-12-01 | 1853-03-03 | Whig | 4 | |||||||||||||
6328 | 6328 | William Hebard H000435 | rep | VT | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
6331 | 6331 | Jerediah Horsford H000796 | rep | NY | 1851-12-01 | 1853-03-03 | Whig | 29 | |||||||||||||
6335 | 6335 | John Howe H000853 | rep | PA | 1851-12-01 | 1853-03-03 | Whig | 22 | |||||||||||||
6338 | 6338 | William Hunter H000992 | rep | OH | 1851-12-01 | 1853-03-03 | Whig | 15 | |||||||||||||
6350 | 6350 | George King K000201 | rep | RI | 1851-12-01 | 1853-03-03 | Whig | 1 | |||||||||||||
6351 | 6351 | Joseph Kuhns K000337 | rep | PA | 1851-12-01 | 1853-03-03 | Whig | 19 | |||||||||||||
6352 | 6352 | Joseph Landry L000055 | rep | LA | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
6358 | 6358 | Frederick Martin M000180 | rep | NY | 1851-12-01 | 1853-03-03 | Whig | 31 | |||||||||||||
6365 | 6365 | Ahiman Miner M000790 | rep | VT | 1851-12-01 | 1853-03-03 | Whig | 1 | |||||||||||||
6368 | 6368 | Henry Moore M000900 | rep | PA | 1851-12-01 | 1853-03-03 | Whig | 3 | |||||||||||||
6371 | 6371 | John Moore M000903 | rep | LA | 1851-12-01 | 1853-03-03 | Whig | 4 | |||||||||||||
6372 | 6372 | James Morehead M000937 | rep | NC | 1851-12-01 | 1853-03-03 | Whig | 4 | |||||||||||||
6376 | 6376 | Eben Newton N000076 | rep | OH | 1851-12-01 | 1853-03-03 | Whig | 19 | |||||||||||||
6379 | 6379 | David Outlaw O000138 | rep | NC | 1851-12-01 | 1853-03-03 | Whig | 9 | |||||||||||||
6386 | 6386 | Ebenezer Penniman P000212 | rep | MI | 1851-12-01 | 1853-03-03 | Whig | 1 | |||||||||||||
6387 | 6387 | Jared Perkins P000235 | rep | NH | 1851-12-01 | 1853-03-03 | Whig | 3 | |||||||||||||
6392 | 6392 | Isaac Reed R000117 | rep | ME | 1851-12-01 | 1853-03-03 | Whig | 4 | |||||||||||||
6403 | 6403 | Lorenzo Sabine S000004 | rep | MA | 1851-12-01 | 1853-03-03 | Whig | 4 | |||||||||||||
6405 | 6405 | William Sackett S000007 | rep | NY | 1851-12-01 | 1853-03-03 | Whig | 27 | |||||||||||||
6407 | 6407 | Abraham Schermerhorn S000122 | rep | NY | 1851-12-01 | 1853-03-03 | Whig | 28 | |||||||||||||
6409 | 6409 | John Schoolcraft S000139 | rep | NY | 1851-12-01 | 1853-03-03 | Whig | 13 | |||||||||||||
6410 | 6410 | Marius Schoonmaker S000141 | rep | NY | 1851-12-01 | 1853-03-03 | Whig | 10 | |||||||||||||
6424 | 6424 | Edward Stanly S000799 | rep | NC | 1851-12-01 | 1853-03-03 | Whig | 8 | |||||||||||||
6429 | 6429 | James Strother S001025 | rep | VA | 1851-12-01 | 1853-03-03 | Whig | 9 | |||||||||||||
6434 | 6434 | Benjamin Thompson T000192 | rep | MA | 1851-12-01 | 1853-03-03 | Whig | 4 | |||||||||||||
6439 | 6439 | Amos Tuck T000394 | rep | NH | 1851-12-01 | 1853-03-03 | Whig | 1 | |||||||||||||
6443 | 6443 | Henry Walbridge W000030 | rep | NY | 1851-12-01 | 1853-03-03 | Whig | 26 | |||||||||||||
6447 | 6447 | Thomas Walsh W000105 | rep | MD | 1851-12-01 | 1853-03-03 | Whig | 4 | |||||||||||||
6448 | 6448 | William Ward W000145 | rep | KY | 1851-12-01 | 1853-03-03 | Whig | 4 | |||||||||||||
6450 | 6450 | John Welch W000263 | rep | OH | 1851-12-01 | 1853-03-03 | Whig | 12 | |||||||||||||
6451 | 6451 | John Wells W000284 | rep | NY | 1851-12-01 | 1853-03-03 | Whig | 16 | |||||||||||||
6452 | 6452 | Addison White W000350 | rep | KY | 1851-12-01 | 1853-03-03 | Whig | 6 | |||||||||||||
6460 | 6460 | Christopher Williams W000493 | rep | TN | 1851-12-01 | 1853-03-03 | Whig | 11 | |||||||||||||
6486 | 6486 | James Abercrombie A000012 | rep | AL | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
6536 | 6536 | Joseph Chandler C000292 | rep | PA | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
6557 | 6557 | William Cullom C000974 | rep | TN | 1851-12-01 | 1853-03-03 | Whig | 8 | |||||||||||||
6589 | 6589 | Presley Ewing E000279 | rep | KY | 1851-12-01 | 1853-03-03 | Whig | 3 | |||||||||||||
6596 | 6596 | John Goodrich G000295 | rep | MA | 1851-12-01 | 1853-03-03 | Whig | 7 | |||||||||||||
6600 | 6600 | Benjamin Grey G000453 | rep | KY | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
6620 | 6620 | Thomas Howe H000854 | rep | PA | 1851-12-01 | 1853-03-03 | Whig | 21 | |||||||||||||
6662 | 6662 | Samuel Parker P000071 | rep | IN | 1851-12-01 | 1853-03-03 | Whig | 4 | |||||||||||||
6677 | 6677 | William Preston P000517 | rep | KY | 1851-12-01 | 1853-03-03 | Whig | 7 | |||||||||||||
6684 | 6684 | Zeno Scudder S000204 | rep | MA | 1851-12-01 | 1853-03-03 | Whig | 10 | |||||||||||||
6717 | 6717 | John Taylor T000089 | rep | OH | 1851-12-01 | 1853-03-03 | Whig | 8 | |||||||||||||
6755 | 6755 | John Allison A000158 | rep | PA | 1851-12-01 | 1853-03-03 | Whig | 20 | |||||||||||||
6818 | 6818 | Henry Fuller F000410 | rep | PA | 1851-12-01 | 1853-03-03 | Whig | 11 | |||||||||||||
6834 | 6834 | Solomon Haven H000355 | rep | NY | 1851-12-01 | 1853-03-03 | Whig | 32 | |||||||||||||
6877 | 6877 | James Meacham M000613 | rep | VT | 1851-12-01 | 1853-03-03 | Whig | 3 | |||||||||||||
6880 | 6880 | John Miller M000741 | rep | MO | 1851-12-01 | 1853-03-03 | Whig | 3 | |||||||||||||
6899 | 6899 | Gilchrist Porter P000440 | rep | MO | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
6977 | 6977 | Henry Bennett B000376 | rep | NY | 1851-12-01 | 1853-03-03 | Whig | 22 | |||||||||||||
6988 | 6988 | Samuel Brenton B000805 | rep | IN | 1851-12-01 | 1853-03-03 | Whig | 10 | |||||||||||||
7142 | 7142 | Humphrey Marshall M000154 | rep | KY | 1851-12-01 | 1853-03-03 | Whig | 7 | |||||||||||||
7247 | 7247 | Albert Watkins W000189 | rep | TN | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
7263 | 7263 | Thomas Clingman C000524 | rep | NC | 1851-12-01 | 1853-03-03 | Whig | 1 | |||||||||||||
7318 | 7318 | George Briggs B000829 | rep | NY | 1851-12-01 | 1853-03-03 | Whig | 5 | |||||||||||||
7582 | 7582 | Benjamin Stanton S000801 | rep | OH | 1851-12-01 | 1853-03-03 | Whig | 4 | |||||||||||||
7612 | 7612 | Robert Toombs T000313 | rep | GA | 1851-12-01 | 1853-03-03 | Whig | 8 | |||||||||||||
7620 | 7620 | Israel Washburn W000173 | rep | ME | 1851-12-01 | 1853-03-03 | Whig | 6 | |||||||||||||
7654 | 7654 | William Appleton A000270 | rep | MA | 1851-12-01 | 1853-03-03 | Whig | 1 | |||||||||||||
7661 | 7661 | John Bernhisel B000412 | rep | UT | 1851-12-01 | 1853-03-03 | Whig | -1 | |||||||||||||
8240 | 8240 | Richard Yates Y000012 | rep | IL | 1851-12-01 | 1853-03-03 | Whig | 7 | |||||||||||||
8449 | 8449 | Thaddeus Stevens S000887 | rep | PA | 1851-12-01 | 1853-03-03 | Whig | 8 | |||||||||||||
8849 | 8849 | Lewis Campbell C000096 | rep | OH | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
9101 | 9101 | James Brooks B000881 | rep | NY | 1851-12-01 | 1853-03-03 | Whig | 6 | |||||||||||||
9406 | 9406 | Alexander White W000353 | rep | AL | 1851-12-01 | 1853-03-03 | Whig | 7 | |||||||||||||
9502 | 9502 | Charles Faulkner F000044 | rep | VA | 1851-12-01 | 1853-03-03 | Whig | 10 |
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);