legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
275 rows where "end" is on date 1855-03-03 sorted by legislator_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6487 | 6487 | James Abercrombie A000012 | rep | AL | 1853-12-05 | 1855-03-03 | Whig | 2 | |||||||||||||
6751 | 6751 | William Aiken A000063 | rep | SC | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
7903 | 7903 | James Allen A000128 | rep | IL | 1853-12-05 | 1855-03-03 | Democrat | 7 | |||||||||||||
6490 | 6490 | Willis Allen A000154 | rep | IL | 1853-12-05 | 1855-03-03 | Democrat | 9 | |||||||||||||
7655 | 7655 | William Appleton A000270 | rep | MA | 1853-12-05 | 1855-03-03 | Whig | 5 | |||||||||||||
6493 | 6493 | William Ashe A000310 | rep | NC | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
5898 | 5898 | David Atchison A000322 | sen | MO | 1849-12-03 | 1855-03-03 | 3 | Democrat | |||||||||||||
5900 | 5900 | George Badger B000022 | sen | NC | 1849-12-03 | 1855-03-03 | 3 | Whig | |||||||||||||
6500 | 6500 | David Bailey B000036 | rep | GA | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
6758 | 6758 | Edward Ball B000098 | rep | OH | 1853-12-05 | 1855-03-03 | Whig | 16 | |||||||||||||
11575 | 11575 | Nathaniel Banks B000116 | rep | MA | 1853-12-05 | 1855-03-03 | Democrat | 7 | |||||||||||||
7282 | 7282 | William Barksdale B000147 | rep | MS | 1853-12-05 | 1855-03-03 | Democrat | -1 | |||||||||||||
6501 | 6501 | William Barry B000193 | rep | MS | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
6767 | 6767 | Thomas Bayly B000259 | rep | VA | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6502 | 6502 | Nathan Belcher B000322 | rep | CT | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
6770 | 6770 | Peter Bell B000344 | rep | TX | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
6978 | 6978 | Henry Bennett B000376 | rep | NY | 1853-12-05 | 1855-03-03 | Whig | 21 | |||||||||||||
6773 | 6773 | Samuel Benson B000390 | rep | ME | 1853-12-05 | 1855-03-03 | Whig | 4 | |||||||||||||
6517 | 6517 | Thomas Benton B000398 | rep | MO | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
7662 | 7662 | John Bernhisel B000412 | rep | UT | 1853-12-05 | 1855-03-03 | Whig | -1 | |||||||||||||
6520 | 6520 | William Bissell B000492 | rep | IL | 1853-12-05 | 1855-03-03 | Ind. Democrat | 8 | |||||||||||||
7918 | 7918 | George Bliss B000559 | rep | OH | 1853-12-05 | 1855-03-03 | Democrat | 18 | |||||||||||||
7298 | 7298 | Thomas Bocock B000582 | rep | VA | 1853-12-05 | 1855-03-03 | Democrat | 5 | |||||||||||||
6521 | 6521 | Azariah Boody B000624 | rep | NY | 1853-12-05 | 1855-03-03 | Whig | 29 | |||||||||||||
7306 | 7306 | William Boyce B000713 | rep | SC | 1853-12-05 | 1855-03-03 | Democrat | 6 | |||||||||||||
6530 | 6530 | Linn Boyd B000719 | rep | KY | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6740 | 6740 | Lawrence Brainerd B000760 | sen | VT | 1854-01-01 | 1855-03-03 | 3 | Free Soil | |||||||||||||
7672 | 7672 | John Breckinridge B000789 | rep | KY | 1853-12-05 | 1855-03-03 | Democrat | 8 | |||||||||||||
9748 | 9748 | Samuel Bridges B000824 | rep | PA | 1853-12-05 | 1855-03-03 | Democrat | 7 | |||||||||||||
7320 | 7320 | Francis Bristow B000842 | rep | KY | 1853-12-05 | 1855-03-03 | Whig | 3 | |||||||||||||
6995 | 6995 | Preston Brooks B000885 | rep | SC | 1853-12-05 | 1855-03-03 | Democrat | 4 | |||||||||||||
6531 | 6531 | Robert Bugg B001043 | rep | TN | 1853-12-05 | 1855-03-03 | Whig | 7 | |||||||||||||
6781 | 6781 | Andrew Butler B001173 | sen | SC | 1849-12-03 | 1855-03-03 | 3 | Democrat | |||||||||||||
6532 | 6532 | Brookins Campbell C000078 | rep | TN | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
8850 | 8850 | Lewis Campbell C000096 | rep | OH | 1853-12-05 | 1855-03-03 | Whig | 3 | |||||||||||||
6533 | 6533 | Davis Carpenter C000167 | rep | NY | 1853-12-05 | 1855-03-03 | Whig | 29 | |||||||||||||
7000 | 7000 | Samuel Caruthers C000210 | rep | MO | 1853-12-05 | 1855-03-03 | Whig | 7 | |||||||||||||
7004 | 7004 | John Caskie C000231 | rep | VA | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
6534 | 6534 | Ebenezer Chamberlain C000276 | rep | IN | 1853-12-05 | 1855-03-03 | Democrat | 10 | |||||||||||||
6537 | 6537 | Joseph Chandler C000292 | rep | PA | 1853-12-05 | 1855-03-03 | Whig | 2 | |||||||||||||
6540 | 6540 | Dudley Chase C000325 | rep | NY | 1853-12-05 | 1855-03-03 | Whig | -1 | |||||||||||||
6541 | 6541 | George Chase C000326 | rep | NY | 1853-12-05 | 1855-03-03 | Whig | 19 | |||||||||||||
7692 | 7692 | Salmon Chase C000332 | sen | OH | 1849-12-03 | 1855-03-03 | 3 | Free Soil | |||||||||||||
6543 | 6543 | Elijah Chastain C000335 | rep | GA | 1853-12-05 | 1855-03-03 | Democrat | 5 | |||||||||||||
6544 | 6544 | James Chrisman C000376 | rep | KY | 1853-12-05 | 1855-03-03 | Democrat | 4 | |||||||||||||
6546 | 6546 | William Churchwell C000393 | rep | TN | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
6548 | 6548 | Samuel Clark C000451 | rep | MI | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
7264 | 7264 | Thomas Clingman C000524 | rep | NC | 1853-12-05 | 1855-03-03 | Democrat | 8 | |||||||||||||
7350 | 7350 | Williamson Cobb C000554 | rep | AL | 1853-12-05 | 1855-03-03 | Democrat | 6 | |||||||||||||
11678 | 11678 | Alfred Colquitt C000647 | rep | GA | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
6553 | 6553 | John Cook C000720 | rep | IA | 1853-12-05 | 1855-03-03 | Whig | 2 | |||||||||||||
5948 | 5948 | James Cooper C000753 | sen | PA | 1849-12-03 | 1855-03-03 | 3 | Whig | |||||||||||||
6555 | 6555 | Moses Corwin C000790 | rep | OH | 1853-12-05 | 1855-03-03 | Whig | 8 | |||||||||||||
6793 | 6793 | Leander Cox C000837 | rep | KY | 1853-12-05 | 1855-03-03 | Whig | 9 | |||||||||||||
7362 | 7362 | Francis Craige C000862 | rep | NC | 1853-12-05 | 1855-03-03 | Democrat | 7 | |||||||||||||
6556 | 6556 | Samuel Crocker C000917 | rep | MA | 1853-12-05 | 1855-03-03 | Whig | 2 | |||||||||||||
6558 | 6558 | William Cullom C000974 | rep | TN | 1853-12-05 | 1855-03-03 | Whig | 4 | |||||||||||||
6796 | 6796 | William Cumback C000980 | rep | NY | 1853-12-05 | 1855-03-03 | Democrat | -1 | |||||||||||||
6559 | 6559 | Thomas Cumming C000981 | rep | NY | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
9145 | 9145 | Carlton Curtis C001007 | rep | PA | 1853-12-05 | 1855-03-03 | Democrat | 24 | |||||||||||||
6560 | 6560 | Francis Cutting C001029 | rep | NY | 1853-12-05 | 1855-03-03 | Democrat | 8 | |||||||||||||
7375 | 7375 | John Davis D000118 | rep | IN | 1853-12-05 | 1855-03-03 | Democrat | 7 | |||||||||||||
6561 | 6561 | Thomas Davis D000135 | rep | RI | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
8103 | 8103 | John Dawson D000153 | rep | PA | 1853-12-05 | 1855-03-03 | Democrat | 20 | |||||||||||||
5956 | 5956 | William Dawson D000156 | sen | GA | 1849-12-03 | 1855-03-03 | 3 | Whig | |||||||||||||
6563 | 6563 | Gilbert Dean D000172 | rep | NY | 1853-12-05 | 1855-03-03 | Democrat | 12 | |||||||||||||
6564 | 6564 | William Dent D000257 | rep | GA | 1853-12-05 | 1855-03-03 | Democrat | 4 | |||||||||||||
6800 | 6800 | Alexander De Witt D000282 | rep | MA | 1853-12-05 | 1855-03-03 | Free Soil | 9 | |||||||||||||
7380 | 7380 | John Dick D000303 | rep | PA | 1853-12-05 | 1855-03-03 | Whig | 25 | |||||||||||||
6565 | 6565 | Edward Dickinson D000319 | rep | MA | 1853-12-05 | 1855-03-03 | Whig | 10 | |||||||||||||
6568 | 6568 | David Disney D000361 | rep | OH | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6474 | 6474 | Archibald Dixon D000367 | sen | KY | 1852-01-01 | 1855-03-03 | 3 | Whig | |||||||||||||
7031 | 7031 | James Dowdell D000464 | rep | AL | 1853-12-05 | 1855-03-03 | Democrat | 7 | |||||||||||||
6569 | 6569 | Augustus Drum D000506 | rep | PA | 1853-12-05 | 1855-03-03 | Democrat | 19 | |||||||||||||
6570 | 6570 | William Dunbar D000526 | rep | LA | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6573 | 6573 | Cyrus Dunham D000540 | rep | IN | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
6575 | 6575 | Ben Eastman E000019 | rep | WI | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
6576 | 6576 | Norman Eddy E000039 | rep | IN | 1853-12-05 | 1855-03-03 | Democrat | 9 | |||||||||||||
6578 | 6578 | Alfred Edgerton E000045 | rep | OH | 1853-12-05 | 1855-03-03 | Democrat | 5 | |||||||||||||
6579 | 6579 | John Edmands E000050 | rep | MA | 1853-12-05 | 1855-03-03 | Whig | 3 | |||||||||||||
7393 | 7393 | Henry Edmundson E000058 | rep | VA | 1853-12-05 | 1855-03-03 | Democrat | 12 | |||||||||||||
8324 | 8324 | Thomas Eliot E000106 | rep | MA | 1853-12-05 | 1855-03-03 | Whig | 1 | |||||||||||||
7038 | 7038 | John Elliott E000125 | rep | KY | 1853-12-05 | 1855-03-03 | Democrat | 6 | |||||||||||||
6580 | 6580 | Andrew Ellison E000140 | rep | OH | 1853-12-05 | 1855-03-03 | Democrat | 6 | |||||||||||||
7397 | 7397 | William English E000191 | rep | IN | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
7402 | 7402 | Emerson Etheridge E000227 | rep | TN | 1853-12-05 | 1855-03-03 | Whig | 9 | |||||||||||||
6587 | 6587 | Edward Everett E000264 | sen | MA | 1853-12-05 | 1855-03-03 | 2 | Whig | |||||||||||||
6588 | 6588 | William Everhart E000271 | rep | PA | 1853-12-05 | 1855-03-03 | Whig | 6 | |||||||||||||
6590 | 6590 | Presley Ewing E000279 | rep | KY | 1853-12-05 | 1855-03-03 | Whig | 3 | |||||||||||||
6591 | 6591 | Ephraim Farley F000018 | rep | ME | 1853-12-05 | 1855-03-03 | Whig | 3 | |||||||||||||
9503 | 9503 | Charles Faulkner F000044 | rep | VA | 1853-12-05 | 1855-03-03 | Democrat | 8 | |||||||||||||
8589 | 8589 | Reuben Fenton F000077 | rep | NY | 1853-12-05 | 1855-03-03 | Democrat | 33 | |||||||||||||
6813 | 6813 | Benjamin Fitzpatrick F000174 | sen | AL | 1853-12-05 | 1855-03-03 | 3 | Democrat | |||||||||||||
6815 | 6815 | Thomas Flagler F000181 | rep | NY | 1853-12-05 | 1855-03-03 | Whig | 31 | |||||||||||||
7406 | 7406 | Thomas Florence F000214 | rep | PA | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6592 | 6592 | John Franklin F000345 | rep | MD | 1853-12-05 | 1855-03-03 | Whig | 1 | |||||||||||||
6822 | 6822 | Thomas Fuller F000412 | rep | ME | 1853-12-05 | 1855-03-03 | Democrat | 6 | |||||||||||||
8902 | 8902 | José Gallegos G000022 | rep | NM | 1853-12-05 | 1855-03-03 | Democrat | -1 | |||||||||||||
6594 | 6594 | James Gamble G000029 | rep | PA | 1853-12-05 | 1855-03-03 | Democrat | 15 | |||||||||||||
7056 | 7056 | Joshua Giddings G000167 | rep | OH | 1853-12-05 | 1855-03-03 | Free Soil | 20 |
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);