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
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, district, start (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5888 | 5888 | Isaac Walker W000055 | sen | WI | 1849-03-05 | 1855-03-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
5948 | 5948 | James Cooper C000753 | sen | PA | 1849-12-03 | 1855-03-03 | 3 | Whig | |||||||||||||
5956 | 5956 | William Dawson D000156 | sen | GA | 1849-12-03 | 1855-03-03 | 3 | Whig | |||||||||||||
6074 | 6074 | Jackson Morton M001015 | sen | FL | 1849-12-03 | 1855-03-03 | 3 | Whig | |||||||||||||
6084 | 6084 | Moses Norris N000140 | sen | NH | 1849-12-03 | 1855-03-03 | 3 | Democrat | |||||||||||||
6129 | 6129 | Truman Smith S000621 | sen | CT | 1849-12-03 | 1855-03-03 | 3 | Whig | |||||||||||||
6474 | 6474 | Archibald Dixon D000367 | sen | KY | 1852-01-01 | 1855-03-03 | 3 | Whig | |||||||||||||
6487 | 6487 | James Abercrombie A000012 | rep | AL | 1853-12-05 | 1855-03-03 | Whig | 2 | |||||||||||||
6490 | 6490 | Willis Allen A000154 | rep | IL | 1853-12-05 | 1855-03-03 | Democrat | 9 | |||||||||||||
6493 | 6493 | William Ashe A000310 | rep | NC | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
6500 | 6500 | David Bailey B000036 | rep | GA | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
6501 | 6501 | William Barry B000193 | rep | MS | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
6502 | 6502 | Nathan Belcher B000322 | rep | CT | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
6517 | 6517 | Thomas Benton B000398 | rep | MO | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6520 | 6520 | William Bissell B000492 | rep | IL | 1853-12-05 | 1855-03-03 | Ind. Democrat | 8 | |||||||||||||
6521 | 6521 | Azariah Boody B000624 | rep | NY | 1853-12-05 | 1855-03-03 | Whig | 29 | |||||||||||||
6530 | 6530 | Linn Boyd B000719 | rep | KY | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6531 | 6531 | Robert Bugg B001043 | rep | TN | 1853-12-05 | 1855-03-03 | Whig | 7 | |||||||||||||
6532 | 6532 | Brookins Campbell C000078 | rep | TN | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6533 | 6533 | Davis Carpenter C000167 | rep | NY | 1853-12-05 | 1855-03-03 | Whig | 29 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
6553 | 6553 | John Cook C000720 | rep | IA | 1853-12-05 | 1855-03-03 | Whig | 2 | |||||||||||||
6555 | 6555 | Moses Corwin C000790 | rep | OH | 1853-12-05 | 1855-03-03 | Whig | 8 | |||||||||||||
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 | |||||||||||||
6559 | 6559 | Thomas Cumming C000981 | rep | NY | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
6560 | 6560 | Francis Cutting C001029 | rep | NY | 1853-12-05 | 1855-03-03 | Democrat | 8 | |||||||||||||
6561 | 6561 | Thomas Davis D000135 | rep | RI | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
6580 | 6580 | Andrew Ellison E000140 | rep | OH | 1853-12-05 | 1855-03-03 | Democrat | 6 | |||||||||||||
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 | |||||||||||||
6592 | 6592 | John Franklin F000345 | rep | MD | 1853-12-05 | 1855-03-03 | Whig | 1 | |||||||||||||
6594 | 6594 | James Gamble G000029 | rep | PA | 1853-12-05 | 1855-03-03 | Democrat | 15 | |||||||||||||
6595 | 6595 | Napoleon Giddings G000168 | rep | NE | 1853-12-05 | 1855-03-03 | Democrat | -1 | |||||||||||||
6597 | 6597 | John Goodrich G000295 | rep | MA | 1853-12-05 | 1855-03-03 | Whig | 11 | |||||||||||||
6599 | 6599 | Frederick Green G000409 | rep | OH | 1853-12-05 | 1855-03-03 | Democrat | 9 | |||||||||||||
6601 | 6601 | Benjamin Grey G000453 | rep | KY | 1853-12-05 | 1855-03-03 | Whig | 2 | |||||||||||||
6603 | 6603 | Andrew Harlan H000208 | rep | IN | 1853-12-05 | 1855-03-03 | Democrat | 11 | |||||||||||||
6604 | 6604 | Wiley Harris H000256 | rep | MS | 1853-12-05 | 1855-03-03 | Democrat | 4 | |||||||||||||
6605 | 6605 | George Hastings H000326 | rep | NY | 1853-12-05 | 1855-03-03 | Democrat | 28 | |||||||||||||
6607 | 6607 | Bernhart Henn H000500 | rep | IA | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6610 | 6610 | Harry Hibbard H000557 | rep | NH | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
6611 | 6611 | Isaac Hiester H000572 | rep | PA | 1853-12-05 | 1855-03-03 | Whig | 9 | |||||||||||||
6612 | 6612 | Clement Hill H000589 | rep | KY | 1853-12-05 | 1855-03-03 | Whig | 5 | |||||||||||||
6614 | 6614 | Junius Hillyer H000625 | rep | GA | 1853-12-05 | 1855-03-03 | Democrat | 6 | |||||||||||||
6621 | 6621 | Thomas Howe H000854 | rep | PA | 1853-12-05 | 1855-03-03 | Whig | 22 | |||||||||||||
6622 | 6622 | Charles Hughes H000918 | rep | NY | 1853-12-05 | 1855-03-03 | Democrat | 15 | |||||||||||||
6623 | 6623 | Theodore Hunt H000977 | rep | LA | 1853-12-05 | 1855-03-03 | Whig | 2 | |||||||||||||
6625 | 6625 | Colin Ingersoll I000016 | rep | CT | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
6626 | 6626 | Harvey Johnson J000136 | rep | OH | 1853-12-05 | 1855-03-03 | Democrat | 14 | |||||||||||||
6628 | 6628 | Daniel Jones J000215 | rep | NY | 1853-12-05 | 1855-03-03 | Democrat | 24 | |||||||||||||
6633 | 6633 | Roland Jones J000250 | rep | LA | 1853-12-05 | 1855-03-03 | Democrat | 4 | |||||||||||||
6634 | 6634 | John Kerr K000140 | rep | NC | 1853-12-05 | 1855-03-03 | Whig | 5 | |||||||||||||
6635 | 6635 | George Kittredge K000256 | rep | NH | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6637 | 6637 | William Kurtz K000345 | rep | PA | 1853-12-05 | 1855-03-03 | Democrat | 16 | |||||||||||||
6638 | 6638 | Alfred Lamb L000032 | rep | MO | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
6639 | 6639 | Columbia Lancaster L000044 | rep | WA | 1853-12-05 | 1855-03-03 | Democrat | -1 | |||||||||||||
6640 | 6640 | Charles Lewis L000275 | rep | VA | 1853-12-05 | 1855-03-03 | Democrat | 11 | |||||||||||||
6641 | 6641 | Samuel Lilly L000310 | rep | NJ | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
6642 | 6642 | William Lindsley L000330 | rep | OH | 1853-12-05 | 1855-03-03 | Democrat | 13 | |||||||||||||
6643 | 6643 | Caleb Lyon L000540 | rep | NY | 1853-12-05 | 1855-03-03 | Independent | 23 | |||||||||||||
6645 | 6645 | Moses Macdonald M000004 | rep | ME | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6646 | 6646 | John Macy M000036 | rep | WI | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
6647 | 6647 | James Maurice M000261 | rep | NY | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6648 | 6648 | Samuel Mayall M000278 | rep | ME | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
6649 | 6649 | John McCulloch M000390 | rep | PA | 1853-12-05 | 1855-03-03 | Whig | 18 | |||||||||||||
6651 | 6651 | John McNair M000581 | rep | PA | 1853-12-05 | 1855-03-03 | Democrat | 5 | |||||||||||||
6652 | 6652 | Ner Middleswarth M000695 | rep | PA | 1853-12-05 | 1855-03-03 | Whig | 10 | |||||||||||||
6654 | 6654 | George Morrison M000994 | rep | NH | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
6655 | 6655 | Henry Muhlenberg M001064 | rep | PA | 1853-12-05 | 1855-03-03 | Democrat | 8 | |||||||||||||
6657 | 6657 | William Murray M001116 | rep | NY | 1853-12-05 | 1855-03-03 | Democrat | 10 | |||||||||||||
6658 | 6658 | David Noble N000117 | rep | MI | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
6661 | 6661 | Edson Olds O000063 | rep | OH | 1853-12-05 | 1855-03-03 | Democrat | 12 | |||||||||||||
6663 | 6663 | Samuel Parker P000071 | rep | IN | 1853-12-05 | 1855-03-03 | Whig | 5 | |||||||||||||
6664 | 6664 | Jared Peck P000177 | rep | NY | 1853-12-05 | 1855-03-03 | Democrat | 9 | |||||||||||||
6665 | 6665 | Rufus Peckham P000180 | rep | NY | 1853-12-05 | 1855-03-03 | Democrat | 14 | |||||||||||||
6666 | 6666 | Bishop Perkins P000227 | rep | NY | 1853-12-05 | 1855-03-03 | Democrat | 17 | |||||||||||||
6667 | 6667 | John Perkins P000236 | rep | LA | 1853-12-05 | 1855-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);