legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
262 rows where "end" is on date 1847-03-03 sorted by district
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4675 | 4675 | William Archer A000275 | sen | VA | 1841-05-31 | 1847-03-03 | 2 | Whig | |||||||||||||
4685 | 4685 | Alexander Barrow B000183 | sen | LA | 1841-05-31 | 1847-03-03 | 2 | Whig | |||||||||||||
4752 | 4752 | Thomas Clayton C000499 | sen | DE | 1841-05-31 | 1847-03-03 | 2 | Whig | |||||||||||||
4779 | 4779 | George Evans E000241 | sen | ME | 1841-05-31 | 1847-03-03 | 2 | Whig | |||||||||||||
4906 | 4906 | James Morehead M000938 | sen | KY | 1841-05-31 | 1847-03-03 | 2 | Whig | |||||||||||||
5087 | 5087 | William Woodbridge W000709 | sen | MI | 1841-05-31 | 1847-03-03 | 2 | Whig | |||||||||||||
5216 | 5216 | William Haywood H000411 | sen | NC | 1843-12-04 | 1847-03-03 | 3 | Democrat | |||||||||||||
5223 | 5223 | Spencer Jarnagin J000059 | sen | TN | 1843-12-04 | 1847-03-03 | 2 | Whig | |||||||||||||
5287 | 5287 | James Semple S000239 | sen | IL | 1843-12-04 | 1847-03-03 | 2 | Democrat | |||||||||||||
5376 | 5376 | Joseph Chalmers C000273 | sen | MS | 1845-12-01 | 1847-03-03 | 2 | Democrat | |||||||||||||
5454 | 5454 | Benning Jenness J000094 | sen | NH | 1845-12-01 | 1847-03-03 | 2 | Democrat | |||||||||||||
5587 | 5587 | Joseph Cilley C000396 | sen | NH | 1846-01-01 | 1847-03-03 | 2 | Liberty | |||||||||||||
5601 | 5601 | Chester Ashley A000311 | sen | AR | 1844-01-01 | 1847-03-03 | 2 | Democrat | |||||||||||||
5615 | 5615 | John Berrien B000413 | sen | GA | 1841-05-31 | 1847-03-03 | 2 | Whig | |||||||||||||
5640 | 5640 | John Calhoun C000044 | sen | SC | 1845-12-01 | 1847-03-03 | 2 | Democrat | |||||||||||||
5669 | 5669 | John Davis D000117 | sen | MA | 1845-12-01 | 1847-03-03 | 2 | Whig | |||||||||||||
5763 | 5763 | Dixon Lewis L000278 | sen | AL | 1844-04-22 | 1847-03-03 | 2 | Democrat | |||||||||||||
5772 | 5772 | Willie Mangum M000096 | sen | NC | 1841-03-04 | 1847-03-03 | 2 | Whig | |||||||||||||
5793 | 5793 | Jacob Miller M000731 | sen | NJ | 1841-05-31 | 1847-03-03 | 2 | Whig | |||||||||||||
6617 | 6617 | Samuel Houston H000827 | sen | TX | 1846-02-21 | 1847-03-03 | 2 | Democrat | |||||||||||||
7223 | 7223 | James Simmons S000417 | sen | RI | 1841-05-31 | 1847-03-03 | 2 | Whig | |||||||||||||
5405 | 5405 | John Dawson D000152 | rep | LA | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5415 | 5415 | Henry Ellett E000116 | rep | MS | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5436 | 5436 | Serranus Hastings H000330 | rep | IA | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5473 | 5473 | Morgan Martin M000196 | rep | WI | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5478 | 5478 | William McDaniel M000400 | rep | MO | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5487 | 5487 | Mace Moulton M001046 | rep | NH | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5503 | 5503 | Sterling Price P000531 | rep | MO | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5507 | 5507 | James Relfe R000160 | rep | MO | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5512 | 5512 | Robert Roberts R000315 | rep | MS | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5518 | 5518 | Leonard Sims S000440 | rep | MO | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5748 | 5748 | James Johnson J000146 | rep | NH | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5909 | 5909 | James Bowlin B000701 | rep | MO | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
6040 | 6040 | Shepherd Leffler L000215 | rep | IA | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
6083 | 6083 | Moses Norris N000140 | rep | NH | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
6140 | 6140 | Jacob Thompson T000203 | rep | MS | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
6466 | 6466 | Stephen Adams A000048 | rep | MS | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
7020 | 7020 | Jefferson Davis D000113 | rep | MS | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
7827 | 7827 | John Phelps P000296 | rep | MO | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
6013 | 6013 | John Houston H000825 | rep | DE | 1845-12-01 | 1847-03-03 | Whig | 0 | |||||||||||||
5366 | 5366 | William Brockenbrough B000852 | rep | FL | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5391 | 5391 | Henry Cranston C000878 | rep | RI | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
5396 | 5396 | Edmund Dargan D000052 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5433 | 5433 | James Graham G000355 | rep | NC | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
5467 | 5467 | John Lawrence L000136 | rep | NY | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5488 | 5488 | Thomas Newton N000077 | rep | AR | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
5491 | 5491 | Robert Owen O000152 | rep | IN | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5514 | 5514 | John Scamman S000104 | rep | ME | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5583 | 5583 | Archibald Yell Y000017 | rep | AR | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5604 | 5604 | Archibald Atkinson A000328 | rep | VA | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5619 | 5619 | James Black B000501 | rep | SC | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5643 | 5643 | John Chapman C000314 | rep | MD | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
5688 | 5688 | James Faran F000014 | rep | OH | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5713 | 5713 | James Hampton H000138 | rep | NJ | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
5779 | 5779 | Robert McClelland M000334 | rep | MI | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
6022 | 6022 | David Kaufman K000021 | rep | TX | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
6034 | 6034 | Thomas King K000215 | rep | GA | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
6037 | 6037 | Emile La Sére L000008 | rep | LA | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
6043 | 6043 | Lewis Levin L000262 | rep | PA | 1845-12-01 | 1847-03-03 | American | 1 | |||||||||||||
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 | |||||||||||||
6526 | 6526 | Linn Boyd B000719 | rep | KY | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
6921 | 6921 | John Slidell S000487 | rep | LA | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
7226 | 7226 | Robert Smith S000604 | rep | IL | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
9541 | 9541 | Andrew Johnson J000116 | rep | TN | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5357 | 5357 | Lemuel Arnold A000291 | rep | RI | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
5385 | 5385 | John Chipman C000368 | rep | MI | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5395 | 5395 | Francis Cunningham C000990 | rep | OH | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5414 | 5414 | Robert Dunlap D000543 | rep | ME | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5463 | 5463 | Seaborn Jones J000252 | rep | GA | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5481 | 5481 | John McHenry M000471 | rep | KY | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
5500 | 5500 | Thomas Perry P000245 | rep | MD | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5515 | 5515 | Henry Seaman S000208 | rep | NY | 1845-12-01 | 1847-03-03 | American | 2 | |||||||||||||
5537 | 5537 | George Sykes S001131 | rep | NJ | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5578 | 5578 | Samuel Wright W000769 | rep | NJ | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
5608 | 5608 | Daniel Barringer B000182 | rep | NC | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
5651 | 5651 | William Cocke C000573 | rep | TN | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
5679 | 5679 | George Dromgoole D000504 | rep | VA | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5717 | 5717 | Thomas Henley H000499 | rep | IN | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5724 | 5724 | Samuel Hubbard H000889 | rep | CT | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
5741 | 5741 | Joseph Ingersoll I000019 | rep | PA | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
5803 | 5803 | Timothy Pilsbury P000353 | rep | TX | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5817 | 5817 | Richard Simpson S000435 | rep | SC | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5840 | 5840 | Bannon Thibodeaux T000152 | rep | LA | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
6003 | 6003 | Henry Hilliard H000622 | rep | AL | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
6027 | 6027 | Daniel King K000198 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
7702 | 7702 | Jacob Collamer C000628 | rep | VT | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
7790 | 7790 | John McClernand M000337 | rep | IL | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5372 | 5372 | John Campbell C000093 | rep | PA | 1845-12-01 | 1847-03-03 | American | 3 | |||||||||||||
5389 | 5389 | James Cottrell C000803 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 3 | |||||||||||||
5448 | 5448 | James Hunt H000971 | rep | MI | 1845-12-01 | 1847-03-03 | Democrat | 3 | |||||||||||||
5482 | 5482 | William Miller M000765 | rep | NY | 1845-12-01 | 1847-03-03 | American | 3 | |||||||||||||
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 | |||||||||||||
5523 | 5523 | Thomas Smith S000615 | rep | IN | 1845-12-01 | 1847-03-03 | Democrat | 3 | |||||||||||||
5548 | 5548 | George Towns T000327 | rep | GA | 1845-12-01 | 1847-03-03 | Democrat | 3 | |||||||||||||
5549 | 5549 | William Tredway T000360 | rep | VA | 1845-12-01 | 1847-03-03 | Democrat | 3 | |||||||||||||
5580 | 5580 | William Yancey Y000003 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 3 |
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);