legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
92 rows where party = "Whig" and "start" is on date 1845-12-01
This data as json, copyable, CSV (advanced)
Suggested facets: type, state, end, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5357 | 5357 | Lemuel Arnold A000291 | rep | RI | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
5358 | 5358 | Joshua Bell B000343 | rep | KY | 1845-12-01 | 1847-03-03 | Whig | 4 | |||||||||||||
5369 | 5369 | Milton Brown B000938 | rep | TN | 1845-12-01 | 1847-03-03 | Whig | 11 | |||||||||||||
5371 | 5371 | Joseph Buffington B001041 | rep | PA | 1845-12-01 | 1847-03-03 | Whig | 24 | |||||||||||||
5375 | 5375 | Charles Carroll C000186 | rep | NY | 1845-12-01 | 1847-03-03 | Whig | 29 | |||||||||||||
5391 | 5391 | Henry Cranston C000878 | rep | RI | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
5394 | 5394 | Erastus Culver C000978 | rep | NY | 1845-12-01 | 1847-03-03 | Whig | 14 | |||||||||||||
5398 | 5398 | Cornelius Darragh D000061 | rep | PA | 1845-12-01 | 1847-03-03 | Whig | 21 | |||||||||||||
5407 | 5407 | William Dayton D000166 | sen | NJ | 1845-12-01 | 1851-03-03 | 1 | Whig | |||||||||||||
5418 | 5418 | Edwin Ewing E000276 | rep | TN | 1845-12-01 | 1847-03-03 | Whig | 8 | |||||||||||||
5419 | 5419 | John Ewing E000278 | rep | PA | 1845-12-01 | 1847-03-03 | Whig | 20 | |||||||||||||
5433 | 5433 | James Graham G000355 | rep | NC | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
5434 | 5434 | Albert Greene G000424 | sen | RI | 1845-12-01 | 1851-03-03 | 1 | Whig | |||||||||||||
5437 | 5437 | John Henry H000507 | rep | IL | 1845-12-01 | 1847-03-03 | Whig | 7 | |||||||||||||
5438 | 5438 | Richard Herrick H000541 | rep | NY | 1845-12-01 | 1847-03-03 | Whig | 12 | |||||||||||||
5453 | 5453 | Jabez Huntington H000997 | sen | CT | 1845-12-01 | 1847-12-31 | 1 | Whig | |||||||||||||
5469 | 5469 | Abner Lewis L000270 | rep | NY | 1845-12-01 | 1847-03-03 | Whig | 31 | |||||||||||||
5470 | 5470 | Edward Long L000414 | rep | MD | 1845-12-01 | 1847-03-03 | Whig | 6 | |||||||||||||
5481 | 5481 | John McHenry M000471 | rep | KY | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
5486 | 5486 | William Moseley M001024 | rep | NY | 1845-12-01 | 1847-03-03 | Whig | 32 | |||||||||||||
5488 | 5488 | Thomas Newton N000077 | rep | AR | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
5502 | 5502 | Joseph Peyton P000283 | rep | TN | 1845-12-01 | 1847-03-03 | Whig | 8 | |||||||||||||
5508 | 5508 | Thomas Ripley R000267 | rep | NY | 1845-12-01 | 1847-03-03 | Whig | 12 | |||||||||||||
5513 | 5513 | John Runk R000509 | rep | NJ | 1845-12-01 | 1847-03-03 | Whig | 3 | |||||||||||||
5517 | 5517 | Luther Severance S000255 | rep | ME | 1845-12-01 | 1847-03-03 | Whig | 3 | |||||||||||||
5520 | 5520 | Albert Smith S000512 | rep | NY | 1845-12-01 | 1847-03-03 | Whig | 33 | |||||||||||||
5541 | 5541 | William Thomasson T000190 | rep | KY | 1845-12-01 | 1847-03-03 | Whig | 7 | |||||||||||||
5545 | 5545 | Daniel Tilden T000270 | rep | OH | 1845-12-01 | 1847-03-03 | Whig | 19 | |||||||||||||
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 | |||||||||||||
5571 | 5571 | Daniel Webster W000238 | sen | MA | 1845-12-01 | 1850-07-22 | 1 | Whig | |||||||||||||
5578 | 5578 | Samuel Wright W000769 | rep | NJ | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
5586 | 5586 | Bryan Young Y000030 | rep | KY | 1845-12-01 | 1847-03-03 | Whig | 5 | |||||||||||||
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 | |||||||||||||
5608 | 5608 | Daniel Barringer B000182 | rep | NC | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
5622 | 5622 | John Blanchard B000539 | rep | PA | 1845-12-01 | 1847-03-03 | Whig | 17 | |||||||||||||
5643 | 5643 | John Chapman C000314 | rep | MD | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
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 | |||||||||||||
5669 | 5669 | John Davis D000117 | sen | MA | 1845-12-01 | 1847-03-03 | 2 | Whig | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
5741 | 5741 | Joseph Ingersoll I000019 | rep | PA | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
5782 | 5782 | Abraham McIlvaine M000474 | rep | PA | 1845-12-01 | 1847-03-03 | Whig | 7 | |||||||||||||
5800 | 5800 | John Pendleton P000206 | rep | VA | 1845-12-01 | 1847-03-03 | Whig | 9 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
5894 | 5894 | George Ashmun A000318 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 6 | |||||||||||||
5985 | 5985 | Joseph Grinnell G000477 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 10 | |||||||||||||
6003 | 6003 | Henry Hilliard H000622 | rep | AL | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
6013 | 6013 | John Houston H000825 | rep | DE | 1845-12-01 | 1847-03-03 | Whig | 0 | |||||||||||||
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 | |||||||||||||
6052 | 6052 | George Marsh M000147 | rep | VT | 1845-12-01 | 1847-03-03 | Whig | 3 | |||||||||||||
6058 | 6058 | Edward McGaughey M000443 | rep | IN | 1845-12-01 | 1847-03-03 | Whig | 7 | |||||||||||||
6103 | 6103 | Joseph Root R000433 | rep | OH | 1845-12-01 | 1847-03-03 | Whig | 21 | |||||||||||||
6127 | 6127 | Truman Smith S000621 | rep | CT | 1845-12-01 | 1847-03-03 | Whig | 4 | |||||||||||||
6163 | 6163 | Samuel Vinton V000107 | rep | OH | 1845-12-01 | 1847-03-03 | Whig | 12 | |||||||||||||
6171 | 6171 | Hugh White W000375 | rep | NY | 1845-12-01 | 1847-03-03 | Whig | 16 | |||||||||||||
6201 | 6201 | Robert Winthrop W000646 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
6242 | 6242 | Edward Cabell C000003 | rep | FL | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
6274 | 6274 | Alfred Dockery D000385 | rep | NC | 1845-12-01 | 1847-03-03 | Whig | 4 | |||||||||||||
6305 | 6305 | Meredith Gentry G000125 | rep | TN | 1845-12-01 | 1847-03-03 | Whig | 7 | |||||||||||||
6322 | 6322 | Alexander Harper H000219 | rep | OH | 1845-12-01 | 1847-03-03 | Whig | 14 | |||||||||||||
6433 | 6433 | Benjamin Thompson T000192 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 4 | |||||||||||||
6551 | 6551 | John Clayton C000496 | sen | DE | 1845-12-01 | 1849-12-31 | 1 | Whig | |||||||||||||
6673 | 6673 | Samuel Phelps P000299 | sen | VT | 1845-12-01 | 1851-03-03 | 1 | Whig | |||||||||||||
6746 | 6746 | Julius Rockwell R000368 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 7 | |||||||||||||
7052 | 7052 | Joshua Giddings G000167 | rep | OH | 1845-12-01 | 1847-03-03 | Whig | 20 | |||||||||||||
7609 | 7609 | Robert Toombs T000313 | rep | GA | 1845-12-01 | 1847-03-03 | Whig | 8 | |||||||||||||
7642 | 7642 | Edward Baker B000059 | rep | IL | 1845-12-01 | 1847-03-03 | Whig | 7 | |||||||||||||
7702 | 7702 | Jacob Collamer C000628 | rep | VT | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
7715 | 7715 | Thomas Corwin C000791 | sen | OH | 1845-12-01 | 1851-03-03 | 1 | Whig | |||||||||||||
7944 | 7944 | James Dixon D000369 | rep | CT | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
7952 | 7952 | Solomon Foot F000248 | rep | VT | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
7973 | 7973 | Reverdy Johnson J000169 | sen | MD | 1845-12-01 | 1849-12-31 | 1 | Whig | |||||||||||||
8065 | 8065 | William Wright W000772 | rep | NJ | 1845-12-01 | 1847-03-03 | Whig | 5 | |||||||||||||
8123 | 8123 | Henry Grider G000455 | rep | KY | 1845-12-01 | 1847-03-03 | Whig | 3 | |||||||||||||
8302 | 8302 | Garrett Davis D000099 | rep | KY | 1845-12-01 | 1847-03-03 | Whig | 8 | |||||||||||||
8305 | 8305 | Columbus Delano D000214 | rep | OH | 1845-12-01 | 1847-03-03 | Whig | 10 | |||||||||||||
8696 | 8696 | Alexander Ramsey R000026 | rep | PA | 1845-12-01 | 1847-03-03 | Whig | 14 | |||||||||||||
8708 | 8708 | Robert Schenck S000118 | rep | OH | 1845-12-01 | 1847-03-03 | Whig | 3 | |||||||||||||
10550 | 10550 | Alexander Stephens S000854 | rep | GA | 1845-12-01 | 1847-03-03 | Whig | 7 |
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);