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 legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
6466 | 6466 | Stephen Adams A000048 | rep | MS | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5356 | 5356 | Joseph Anderson A000198 | rep | NY | 1845-12-01 | 1847-03-03 | Democrat | 7 | |||||||||||||
4675 | 4675 | William Archer A000275 | sen | VA | 1841-05-31 | 1847-03-03 | 2 | Whig | |||||||||||||
5357 | 5357 | Lemuel Arnold A000291 | rep | RI | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
5601 | 5601 | Chester Ashley A000311 | sen | AR | 1844-01-01 | 1847-03-03 | 2 | Democrat | |||||||||||||
5894 | 5894 | George Ashmun A000318 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 6 | |||||||||||||
5604 | 5604 | Archibald Atkinson A000328 | rep | VA | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
7642 | 7642 | Edward Baker B000059 | rep | IL | 1845-12-01 | 1847-03-03 | Whig | 7 | |||||||||||||
5608 | 5608 | Daniel Barringer B000182 | rep | NC | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
4685 | 4685 | Alexander Barrow B000183 | sen | LA | 1841-05-31 | 1847-03-03 | 2 | Whig | |||||||||||||
6763 | 6763 | Thomas Bayly B000259 | rep | VA | 1845-12-01 | 1847-03-03 | Democrat | 7 | |||||||||||||
5611 | 5611 | Henry Bedinger B000302 | rep | VA | 1845-12-01 | 1847-03-03 | Democrat | 10 | |||||||||||||
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 | |||||||||||||
5615 | 5615 | John Berrien B000413 | sen | GA | 1841-05-31 | 1847-03-03 | 2 | Whig | |||||||||||||
6775 | 6775 | Asa Biggs B000456 | rep | NC | 1845-12-01 | 1847-03-03 | Democrat | 9 | |||||||||||||
5363 | 5363 | James Black B000500 | rep | PA | 1845-12-01 | 1847-03-03 | Democrat | 16 | |||||||||||||
5619 | 5619 | James Black B000501 | rep | SC | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5622 | 5622 | John Blanchard B000539 | rep | PA | 1845-12-01 | 1847-03-03 | Whig | 17 | |||||||||||||
5905 | 5905 | Franklin Bowdon B000680 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 7 | |||||||||||||
5909 | 5909 | James Bowlin B000701 | rep | MO | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
6526 | 6526 | Linn Boyd B000719 | rep | KY | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
6229 | 6229 | Richard Brodhead B000861 | rep | PA | 1845-12-01 | 1847-03-03 | Democrat | 10 | |||||||||||||
5369 | 5369 | Milton Brown B000938 | rep | TN | 1845-12-01 | 1847-03-03 | Whig | 11 | |||||||||||||
7923 | 7923 | William Brown B000948 | rep | VA | 1845-12-01 | 1847-03-03 | Democrat | 15 | |||||||||||||
5371 | 5371 | Joseph Buffington B001041 | rep | PA | 1845-12-01 | 1847-03-03 | Whig | 24 | |||||||||||||
6237 | 6237 | Armistead Burt B001145 | rep | SC | 1845-12-01 | 1847-03-03 | Democrat | 5 | |||||||||||||
6242 | 6242 | Edward Cabell C000003 | rep | FL | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
5640 | 5640 | John Calhoun C000044 | sen | SC | 1845-12-01 | 1847-03-03 | 2 | Democrat | |||||||||||||
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 | |||||||||||||
6469 | 6469 | Charles Cathcart C000250 | rep | IN | 1845-12-01 | 1847-03-03 | Democrat | 9 | |||||||||||||
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 | |||||||||||||
5643 | 5643 | John Chapman C000314 | rep | MD | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
5384 | 5384 | Reuben Chapman C000316 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 6 | |||||||||||||
5645 | 5645 | Lucien Chase C000330 | rep | TN | 1845-12-01 | 1847-03-03 | Democrat | 9 | |||||||||||||
5385 | 5385 | John Chipman C000368 | rep | MI | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5587 | 5587 | Joseph Cilley C000396 | sen | NH | 1846-01-01 | 1847-03-03 | 2 | Liberty | |||||||||||||
5386 | 5386 | Henry Clark C000434 | rep | NC | 1845-12-01 | 1847-03-03 | Democrat | 8 | |||||||||||||
4752 | 4752 | Thomas Clayton C000499 | sen | DE | 1841-05-31 | 1847-03-03 | 2 | Whig | |||||||||||||
6789 | 6789 | Howell Cobb C000548 | rep | GA | 1845-12-01 | 1847-03-03 | Democrat | 6 | |||||||||||||
5651 | 5651 | William Cocke C000573 | rep | TN | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
7702 | 7702 | Jacob Collamer C000628 | rep | VT | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
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 | |||||||||||||
5658 | 5658 | John Crozier C000951 | rep | TN | 1845-12-01 | 1847-03-03 | Whig | 3 | |||||||||||||
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 | |||||||||||||
5660 | 5660 | John Cummins C000989 | rep | OH | 1845-12-01 | 1847-03-03 | Democrat | 16 | |||||||||||||
5395 | 5395 | Francis Cunningham C000990 | rep | OH | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
6266 | 6266 | John Daniel D000034 | rep | NC | 1845-12-01 | 1847-03-03 | Democrat | 7 | |||||||||||||
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 | |||||||||||||
8302 | 8302 | Garrett Davis D000099 | rep | KY | 1845-12-01 | 1847-03-03 | Whig | 8 | |||||||||||||
7020 | 7020 | Jefferson Davis D000113 | rep | MS | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5669 | 5669 | John Davis D000117 | sen | MA | 1845-12-01 | 1847-03-03 | 2 | Whig | |||||||||||||
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 | |||||||||||||
8305 | 8305 | Columbus Delano D000214 | rep | OH | 1845-12-01 | 1847-03-03 | Whig | 10 | |||||||||||||
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 | |||||||||||||
7944 | 7944 | James Dixon D000369 | rep | CT | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
5412 | 5412 | James Dobbin D000381 | rep | NC | 1845-12-01 | 1847-03-03 | Democrat | 5 | |||||||||||||
6274 | 6274 | Alfred Dockery D000385 | rep | NC | 1845-12-01 | 1847-03-03 | Whig | 4 | |||||||||||||
7387 | 7387 | Stephen Douglas D000457 | rep | IL | 1845-12-01 | 1847-03-03 | Democrat | 5 | |||||||||||||
5679 | 5679 | George Dromgoole D000504 | rep | VA | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5414 | 5414 | Robert Dunlap D000543 | rep | ME | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5684 | 5684 | Joseph Edsall E000059 | rep | NJ | 1845-12-01 | 1847-03-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
4779 | 4779 | George Evans E000241 | sen | ME | 1841-05-31 | 1847-03-03 | 2 | 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 | |||||||||||||
5688 | 5688 | James Faran F000014 | rep | OH | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
6291 | 6291 | Orlando Ficklin F000101 | rep | IL | 1845-12-01 | 1847-03-03 | Democrat | 3 | |||||||||||||
7952 | 7952 | Solomon Foot F000248 | rep | VT | 1845-12-01 | 1847-03-03 | Whig | 1 | |||||||||||||
8898 | 8898 | Henry Foster F000305 | rep | PA | 1845-12-01 | 1847-03-03 | Democrat | 19 | |||||||||||||
5698 | 5698 | George Fries F000386 | rep | OH | 1845-12-01 | 1847-03-03 | Democrat | 17 | |||||||||||||
5424 | 5424 | William Garvin G000089 | rep | PA | 1845-12-01 | 1847-03-03 | Democrat | 22 | |||||||||||||
6305 | 6305 | Meredith Gentry G000125 | rep | TN | 1845-12-01 | 1847-03-03 | Whig | 7 | |||||||||||||
7052 | 7052 | Joshua Giddings G000167 | rep | OH | 1845-12-01 | 1847-03-03 | Whig | 20 | |||||||||||||
5425 | 5425 | William Giles G000184 | rep | MD | 1845-12-01 | 1847-03-03 | Democrat | 4 | |||||||||||||
8120 | 8120 | Charles Goodyear G000307 | rep | NY | 1845-12-01 | 1847-03-03 | Democrat | 21 | |||||||||||||
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 | |||||||||||||
8123 | 8123 | Henry Grider G000455 | rep | KY | 1845-12-01 | 1847-03-03 | Whig | 3 | |||||||||||||
5985 | 5985 | Joseph Grinnell G000477 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 10 | |||||||||||||
5435 | 5435 | Martin Grover G000506 | rep | NY | 1845-12-01 | 1847-03-03 | Democrat | 30 | |||||||||||||
5709 | 5709 | Artemas Hale H000028 | rep | MA | 1845-12-01 | 1847-03-03 | Whig | 9 | |||||||||||||
9515 | 9515 | Hannibal Hamlin H000121 | rep | ME | 1845-12-01 | 1847-03-03 | Democrat | 6 | |||||||||||||
5713 | 5713 | James Hampton H000138 | rep | NJ | 1845-12-01 | 1847-03-03 | Whig | 1 |
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);