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 end
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 | |||||||||||||
5356 | 5356 | Joseph Anderson A000198 | rep | NY | 1845-12-01 | 1847-03-03 | Democrat | 7 | |||||||||||||
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 | |||||||||||||
5360 | 5360 | Charles Benton B000394 | rep | NY | 1845-12-01 | 1847-03-03 | Democrat | 17 | |||||||||||||
5363 | 5363 | James Black B000500 | rep | PA | 1845-12-01 | 1847-03-03 | Democrat | 16 | |||||||||||||
5365 | 5365 | Jacob Brinkerhoff B000838 | rep | OH | 1845-12-01 | 1847-03-03 | Democrat | 11 | |||||||||||||
5366 | 5366 | William Brockenbrough B000852 | rep | FL | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
5372 | 5372 | John Campbell C000093 | rep | PA | 1845-12-01 | 1847-03-03 | American | 3 | |||||||||||||
5373 | 5373 | William Campbell C000105 | rep | NY | 1845-12-01 | 1847-03-03 | American | 6 | |||||||||||||
5375 | 5375 | Charles Carroll C000186 | rep | NY | 1845-12-01 | 1847-03-03 | Whig | 29 | |||||||||||||
5376 | 5376 | Joseph Chalmers C000273 | sen | MS | 1845-12-01 | 1847-03-03 | 2 | Democrat | |||||||||||||
5378 | 5378 | Augustus Chapman C000308 | rep | VA | 1845-12-01 | 1847-03-03 | Democrat | 12 | |||||||||||||
5384 | 5384 | Reuben Chapman C000316 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 6 | |||||||||||||
5385 | 5385 | John Chipman C000368 | rep | MI | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5386 | 5386 | Henry Clark C000434 | rep | NC | 1845-12-01 | 1847-03-03 | Democrat | 8 | |||||||||||||
5387 | 5387 | John Collin C000632 | rep | NY | 1845-12-01 | 1847-03-03 | Democrat | 11 | |||||||||||||
5388 | 5388 | Albert Constable C000708 | rep | MD | 1845-12-01 | 1847-03-03 | Democrat | 5 | |||||||||||||
5389 | 5389 | James Cottrell C000803 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 3 | |||||||||||||
5391 | 5391 | Henry Cranston C000878 | rep | RI | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
5393 | 5393 | Alvan Cullom C000972 | rep | TN | 1845-12-01 | 1847-03-03 | Democrat | 4 | |||||||||||||
5394 | 5394 | Erastus Culver C000978 | rep | NY | 1845-12-01 | 1847-03-03 | Whig | 14 | |||||||||||||
5395 | 5395 | Francis Cunningham C000990 | rep | OH | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5396 | 5396 | Edmund Dargan D000052 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5398 | 5398 | Cornelius Darragh D000061 | rep | PA | 1845-12-01 | 1847-03-03 | Whig | 21 | |||||||||||||
5402 | 5402 | John Davis D000120 | rep | IN | 1845-12-01 | 1847-03-03 | Democrat | 6 | |||||||||||||
5405 | 5405 | John Dawson D000152 | rep | LA | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5408 | 5408 | John De Mott D000223 | rep | NY | 1845-12-01 | 1847-03-03 | Democrat | 27 | |||||||||||||
5410 | 5410 | Paul Dillingham D000346 | rep | VT | 1845-12-01 | 1847-03-03 | Democrat | 4 | |||||||||||||
5412 | 5412 | James Dobbin D000381 | rep | NC | 1845-12-01 | 1847-03-03 | Democrat | 5 | |||||||||||||
5414 | 5414 | Robert Dunlap D000543 | rep | ME | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5415 | 5415 | Henry Ellett E000116 | rep | MS | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5416 | 5416 | Samuel Ellsworth E000149 | rep | NY | 1845-12-01 | 1847-03-03 | Democrat | 26 | |||||||||||||
5417 | 5417 | Jacob Erdman E000200 | rep | PA | 1845-12-01 | 1847-03-03 | Democrat | 6 | |||||||||||||
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 | |||||||||||||
5424 | 5424 | William Garvin G000089 | rep | PA | 1845-12-01 | 1847-03-03 | Democrat | 22 | |||||||||||||
5425 | 5425 | William Giles G000184 | rep | MD | 1845-12-01 | 1847-03-03 | Democrat | 4 | |||||||||||||
5427 | 5427 | Samuel Gordon G000315 | rep | NY | 1845-12-01 | 1847-03-03 | Democrat | 10 | |||||||||||||
5433 | 5433 | James Graham G000355 | rep | NC | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
5435 | 5435 | Martin Grover G000506 | rep | NY | 1845-12-01 | 1847-03-03 | Democrat | 30 | |||||||||||||
5436 | 5436 | Serranus Hastings H000330 | rep | IA | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
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 | |||||||||||||
5440 | 5440 | Joseph Hoge H000697 | rep | IL | 1845-12-01 | 1847-03-03 | Democrat | 6 | |||||||||||||
5441 | 5441 | William Hough H000812 | rep | NY | 1845-12-01 | 1847-03-03 | Democrat | 23 | |||||||||||||
5444 | 5444 | Edmund Hubard H000876 | rep | VA | 1845-12-01 | 1847-03-03 | Democrat | 4 | |||||||||||||
5446 | 5446 | Orville Hungerford H000968 | rep | NY | 1845-12-01 | 1847-03-03 | Democrat | 19 | |||||||||||||
5448 | 5448 | James Hunt H000971 | rep | MI | 1845-12-01 | 1847-03-03 | Democrat | 3 | |||||||||||||
5454 | 5454 | Benning Jenness J000094 | sen | NH | 1845-12-01 | 1847-03-03 | 2 | Democrat | |||||||||||||
5461 | 5461 | Joseph Johnson J000155 | rep | VA | 1845-12-01 | 1847-03-03 | Democrat | 14 | |||||||||||||
5463 | 5463 | Seaborn Jones J000252 | rep | GA | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5466 | 5466 | Andrew Kennedy K000102 | rep | IN | 1845-12-01 | 1847-03-03 | Democrat | 10 | |||||||||||||
5467 | 5467 | John Lawrence L000136 | rep | NY | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5468 | 5468 | Owen Leib L000230 | rep | PA | 1845-12-01 | 1847-03-03 | Democrat | 11 | |||||||||||||
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 | |||||||||||||
5471 | 5471 | Barclay Martin M000168 | rep | TN | 1845-12-01 | 1847-03-03 | Democrat | 6 | |||||||||||||
5472 | 5472 | John Martin M000189 | rep | KY | 1845-12-01 | 1847-03-03 | Democrat | 6 | |||||||||||||
5473 | 5473 | Morgan Martin M000196 | rep | WI | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5474 | 5474 | Moses McClean M000325 | rep | PA | 1845-12-01 | 1847-03-03 | Democrat | 15 | |||||||||||||
5476 | 5476 | Felix McConnell M000356 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 7 | |||||||||||||
5477 | 5477 | John McCrate M000380 | rep | ME | 1845-12-01 | 1847-03-03 | Democrat | 4 | |||||||||||||
5478 | 5478 | William McDaniel M000400 | rep | MO | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5480 | 5480 | Joseph McDowell M000425 | rep | OH | 1845-12-01 | 1847-03-03 | Democrat | 7 | |||||||||||||
5481 | 5481 | John McHenry M000471 | rep | KY | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
5482 | 5482 | William Miller M000765 | rep | NY | 1845-12-01 | 1847-03-03 | American | 3 | |||||||||||||
5484 | 5484 | Joseph Morris M000980 | rep | OH | 1845-12-01 | 1847-03-03 | Democrat | 15 | |||||||||||||
5486 | 5486 | William Moseley M001024 | rep | NY | 1845-12-01 | 1847-03-03 | Whig | 32 | |||||||||||||
5487 | 5487 | Mace Moulton M001046 | rep | NH | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5488 | 5488 | Thomas Newton N000077 | rep | AR | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
5489 | 5489 | Archibald Niven N000112 | rep | NY | 1845-12-01 | 1847-03-03 | Democrat | 9 | |||||||||||||
5491 | 5491 | Robert Owen O000152 | rep | IN | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5493 | 5493 | Isaac Parrish P000082 | rep | OH | 1845-12-01 | 1847-03-03 | Democrat | 13 | |||||||||||||
5496 | 5496 | William Payne P000154 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 4 | |||||||||||||
5499 | 5499 | Augustus Perrill P000240 | rep | OH | 1845-12-01 | 1847-03-03 | Democrat | 9 | |||||||||||||
5500 | 5500 | Thomas Perry P000245 | rep | MD | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5502 | 5502 | Joseph Peyton P000283 | rep | TN | 1845-12-01 | 1847-03-03 | Whig | 8 | |||||||||||||
5503 | 5503 | Sterling Price P000531 | rep | MO | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5505 | 5505 | George Rathbun R000069 | rep | NY | 1845-12-01 | 1847-03-03 | Democrat | 25 | |||||||||||||
5507 | 5507 | James Relfe R000160 | rep | MO | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5508 | 5508 | Thomas Ripley R000267 | rep | NY | 1845-12-01 | 1847-03-03 | Whig | 12 | |||||||||||||
5510 | 5510 | John Ritter R000278 | rep | PA | 1845-12-01 | 1847-03-03 | Democrat | 9 | |||||||||||||
5512 | 5512 | Robert Roberts R000315 | rep | MS | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5513 | 5513 | John Runk R000509 | rep | NJ | 1845-12-01 | 1847-03-03 | Whig | 3 | |||||||||||||
5514 | 5514 | John Scamman S000104 | rep | ME | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5515 | 5515 | Henry Seaman S000208 | rep | NY | 1845-12-01 | 1847-03-03 | American | 2 | |||||||||||||
5517 | 5517 | Luther Severance S000255 | rep | ME | 1845-12-01 | 1847-03-03 | Whig | 3 | |||||||||||||
5518 | 5518 | Leonard Sims S000440 | rep | MO | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5520 | 5520 | Albert Smith S000512 | rep | NY | 1845-12-01 | 1847-03-03 | Whig | 33 |
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);