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 state
This data as json, copyable, CSV (advanced)
Suggested facets: type, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6487 | 6487 | James Abercrombie A000012 | rep | AL | 1853-12-05 | 1855-03-03 | Whig | 2 | |||||||||||||
6675 | 6675 | Philip Phillips P000311 | rep | AL | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6813 | 6813 | Benjamin Fitzpatrick F000174 | sen | AL | 1853-12-05 | 1855-03-03 | 3 | Democrat | |||||||||||||
6830 | 6830 | Sampson Harris H000252 | rep | AL | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
6925 | 6925 | William Smith S000637 | rep | AL | 1853-12-05 | 1855-03-03 | Democrat | 4 | |||||||||||||
7031 | 7031 | James Dowdell D000464 | rep | AL | 1853-12-05 | 1855-03-03 | Democrat | 7 | |||||||||||||
7350 | 7350 | Williamson Cobb C000554 | rep | AL | 1853-12-05 | 1855-03-03 | Democrat | 6 | |||||||||||||
10112 | 10112 | George Houston H000822 | rep | AL | 1853-12-05 | 1855-03-03 | Democrat | 5 | |||||||||||||
6848 | 6848 | Robert Johnson J000172 | sen | AR | 1853-12-05 | 1855-03-03 | 3 | Democrat | |||||||||||||
7068 | 7068 | Alfred Greenwood G000436 | rep | AR | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
7244 | 7244 | Edward Warren W000163 | rep | AR | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
7074 | 7074 | William Gwin G000540 | sen | CA | 1850-09-10 | 1855-03-03 | 3 | Democrat | |||||||||||||
7645 | 7645 | Milton Latham L000110 | rep | CA | 1853-12-05 | 1855-03-03 | Democrat | -1 | |||||||||||||
7795 | 7795 | James McDougall M000416 | rep | CA | 1853-12-05 | 1855-03-03 | Democrat | -1 | |||||||||||||
6129 | 6129 | Truman Smith S000621 | sen | CT | 1849-12-03 | 1855-03-03 | 3 | Whig | |||||||||||||
6502 | 6502 | Nathan Belcher B000322 | rep | CT | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
6625 | 6625 | Colin Ingersoll I000016 | rep | CT | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
6676 | 6676 | James Pratt P000502 | rep | CT | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6687 | 6687 | Origen Seymour S000270 | rep | CT | 1853-12-05 | 1855-03-03 | Democrat | 4 | |||||||||||||
6741 | 6741 | Francis Gillette G000204 | sen | CT | 1854-01-01 | 1855-03-03 | 3 | Free Soil | |||||||||||||
8072 | 8072 | George Riddle R000239 | rep | DE | 1853-12-05 | 1855-03-03 | Democrat | 0 | |||||||||||||
6074 | 6074 | Jackson Morton M001015 | sen | FL | 1849-12-03 | 1855-03-03 | 3 | Whig | |||||||||||||
6869 | 6869 | Augustus Maxwell M000266 | rep | FL | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
5956 | 5956 | William Dawson D000156 | sen | GA | 1849-12-03 | 1855-03-03 | 3 | Whig | |||||||||||||
6500 | 6500 | David Bailey B000036 | rep | GA | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
6543 | 6543 | Elijah Chastain C000335 | rep | GA | 1853-12-05 | 1855-03-03 | Democrat | 5 | |||||||||||||
6564 | 6564 | William Dent D000257 | rep | GA | 1853-12-05 | 1855-03-03 | Democrat | 4 | |||||||||||||
6614 | 6614 | Junius Hillyer H000625 | rep | GA | 1853-12-05 | 1855-03-03 | Democrat | 6 | |||||||||||||
6679 | 6679 | David Reese R000135 | rep | GA | 1853-12-05 | 1855-03-03 | Whig | 7 | |||||||||||||
7215 | 7215 | James Seward S000260 | rep | GA | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
10554 | 10554 | Alexander Stephens S000854 | rep | GA | 1853-12-05 | 1855-03-03 | Whig | 8 | |||||||||||||
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 | |||||||||||||
6607 | 6607 | Bernhart Henn H000500 | rep | IA | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6490 | 6490 | Willis Allen A000154 | rep | IL | 1853-12-05 | 1855-03-03 | Democrat | 9 | |||||||||||||
6520 | 6520 | William Bissell B000492 | rep | IL | 1853-12-05 | 1855-03-03 | Ind. Democrat | 8 | |||||||||||||
6856 | 6856 | James Knox K000295 | rep | IL | 1853-12-05 | 1855-03-03 | Whig | 4 | |||||||||||||
7903 | 7903 | James Allen A000128 | rep | IL | 1853-12-05 | 1855-03-03 | Democrat | 7 | |||||||||||||
8012 | 8012 | Jesse Norton N000151 | rep | IL | 1853-12-05 | 1855-03-03 | Whig | 3 | |||||||||||||
8025 | 8025 | William Richardson R000228 | rep | IL | 1853-12-05 | 1855-03-03 | Democrat | 5 | |||||||||||||
8228 | 8228 | John Wentworth W000295 | rep | IL | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
8241 | 8241 | Richard Yates Y000012 | rep | IL | 1853-12-05 | 1855-03-03 | Whig | 6 | |||||||||||||
8767 | 8767 | Elihu Washburne W000176 | rep | IL | 1853-12-05 | 1855-03-03 | Whig | 1 | |||||||||||||
10188 | 10188 | James Shields S000362 | sen | IL | 1849-12-03 | 1855-03-03 | 3 | Democrat | |||||||||||||
6534 | 6534 | Ebenezer Chamberlain C000276 | rep | IN | 1853-12-05 | 1855-03-03 | Democrat | 10 | |||||||||||||
6573 | 6573 | Cyrus Dunham D000540 | rep | IN | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
6576 | 6576 | Norman Eddy E000039 | rep | IN | 1853-12-05 | 1855-03-03 | Democrat | 9 | |||||||||||||
6603 | 6603 | Andrew Harlan H000208 | rep | IN | 1853-12-05 | 1855-03-03 | Democrat | 11 | |||||||||||||
6663 | 6663 | Samuel Parker P000071 | rep | IN | 1853-12-05 | 1855-03-03 | Whig | 5 | |||||||||||||
6671 | 6671 | John Pettit P000277 | sen | IN | 1853-12-05 | 1855-03-03 | 3 | Democrat | |||||||||||||
6866 | 6866 | Daniel Mace M000008 | rep | IN | 1853-12-05 | 1855-03-03 | Democrat | 8 | |||||||||||||
6884 | 6884 | Smith Miller M000754 | rep | IN | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
7375 | 7375 | John Davis D000118 | rep | IN | 1853-12-05 | 1855-03-03 | Democrat | 7 | |||||||||||||
7397 | 7397 | William English E000191 | rep | IN | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
7968 | 7968 | Thomas Hendricks H000493 | rep | IN | 1853-12-05 | 1855-03-03 | Democrat | 6 | |||||||||||||
8162 | 8162 | James Lane L000061 | rep | IN | 1853-12-05 | 1855-03-03 | Democrat | 4 | |||||||||||||
6950 | 6950 | John Whitfield W000414 | rep | KS | 1853-12-05 | 1855-03-03 | Democrat | -1 | |||||||||||||
6474 | 6474 | Archibald Dixon D000367 | sen | KY | 1852-01-01 | 1855-03-03 | 3 | Whig | |||||||||||||
6530 | 6530 | Linn Boyd B000719 | rep | KY | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6544 | 6544 | James Chrisman C000376 | rep | KY | 1853-12-05 | 1855-03-03 | Democrat | 4 | |||||||||||||
6590 | 6590 | Presley Ewing E000279 | rep | KY | 1853-12-05 | 1855-03-03 | Whig | 3 | |||||||||||||
6601 | 6601 | Benjamin Grey G000453 | rep | KY | 1853-12-05 | 1855-03-03 | Whig | 2 | |||||||||||||
6612 | 6612 | Clement Hill H000589 | rep | KY | 1853-12-05 | 1855-03-03 | Whig | 5 | |||||||||||||
6678 | 6678 | William Preston P000517 | rep | KY | 1853-12-05 | 1855-03-03 | Whig | 7 | |||||||||||||
6704 | 6704 | Richard Stanton S000806 | rep | KY | 1853-12-05 | 1855-03-03 | Democrat | 10 | |||||||||||||
6793 | 6793 | Leander Cox C000837 | rep | KY | 1853-12-05 | 1855-03-03 | Whig | 9 | |||||||||||||
7038 | 7038 | John Elliott E000125 | rep | KY | 1853-12-05 | 1855-03-03 | Democrat | 6 | |||||||||||||
7320 | 7320 | Francis Bristow B000842 | rep | KY | 1853-12-05 | 1855-03-03 | Whig | 3 | |||||||||||||
7672 | 7672 | John Breckinridge B000789 | rep | KY | 1853-12-05 | 1855-03-03 | Democrat | 8 | |||||||||||||
6570 | 6570 | William Dunbar D000526 | rep | LA | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6623 | 6623 | Theodore Hunt H000977 | rep | LA | 1853-12-05 | 1855-03-03 | Whig | 2 | |||||||||||||
6633 | 6633 | Roland Jones J000250 | rep | LA | 1853-12-05 | 1855-03-03 | Democrat | 4 | |||||||||||||
6667 | 6667 | John Perkins P000236 | rep | LA | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
6922 | 6922 | John Slidell S000487 | sen | LA | 1853-12-05 | 1855-03-03 | 3 | Democrat | |||||||||||||
6556 | 6556 | Samuel Crocker C000917 | rep | MA | 1853-12-05 | 1855-03-03 | Whig | 2 | |||||||||||||
6565 | 6565 | Edward Dickinson D000319 | rep | MA | 1853-12-05 | 1855-03-03 | Whig | 10 | |||||||||||||
6579 | 6579 | John Edmands E000050 | rep | MA | 1853-12-05 | 1855-03-03 | Whig | 3 | |||||||||||||
6587 | 6587 | Edward Everett E000264 | sen | MA | 1853-12-05 | 1855-03-03 | 2 | Whig | |||||||||||||
6597 | 6597 | John Goodrich G000295 | rep | MA | 1853-12-05 | 1855-03-03 | Whig | 11 | |||||||||||||
6685 | 6685 | Zeno Scudder S000204 | rep | MA | 1853-12-05 | 1855-03-03 | Whig | 1 | |||||||||||||
6728 | 6728 | Charles Upham U000021 | rep | MA | 1853-12-05 | 1855-03-03 | Whig | 6 | |||||||||||||
6732 | 6732 | Samuel Walley W000087 | rep | MA | 1853-12-05 | 1855-03-03 | Whig | 4 | |||||||||||||
6734 | 6734 | Tappan Wentworth W000297 | rep | MA | 1853-12-05 | 1855-03-03 | Whig | 8 | |||||||||||||
6800 | 6800 | Alexander De Witt D000282 | rep | MA | 1853-12-05 | 1855-03-03 | Free Soil | 9 | |||||||||||||
7655 | 7655 | William Appleton A000270 | rep | MA | 1853-12-05 | 1855-03-03 | Whig | 5 | |||||||||||||
8324 | 8324 | Thomas Eliot E000106 | rep | MA | 1853-12-05 | 1855-03-03 | Whig | 1 | |||||||||||||
11575 | 11575 | Nathaniel Banks B000116 | rep | MA | 1853-12-05 | 1855-03-03 | Democrat | 7 | |||||||||||||
6592 | 6592 | John Franklin F000345 | rep | MD | 1853-12-05 | 1855-03-03 | Whig | 1 | |||||||||||||
6689 | 6689 | Jacob Shower S000386 | rep | MD | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
6696 | 6696 | Augustus Sollers S000674 | rep | MD | 1853-12-05 | 1855-03-03 | Whig | 6 | |||||||||||||
6729 | 6729 | Joshua Van Sant V000057 | rep | MD | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
7787 | 7787 | Henry May M000275 | rep | MD | 1853-12-05 | 1855-03-03 | Democrat | 4 | |||||||||||||
7824 | 7824 | James Pearce P000161 | sen | MD | 1849-12-03 | 1855-03-03 | 3 | Whig | |||||||||||||
8618 | 8618 | William Hamilton H000118 | rep | MD | 1853-12-05 | 1855-03-03 | Democrat | 5 | |||||||||||||
6591 | 6591 | Ephraim Farley F000018 | rep | ME | 1853-12-05 | 1855-03-03 | Whig | 3 | |||||||||||||
6645 | 6645 | Moses Macdonald M000004 | rep | ME | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6648 | 6648 | Samuel Mayall M000278 | rep | ME | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
6773 | 6773 | Samuel Benson B000390 | rep | ME | 1853-12-05 | 1855-03-03 | Whig | 4 | |||||||||||||
6822 | 6822 | Thomas Fuller F000412 | rep | ME | 1853-12-05 | 1855-03-03 | Democrat | 6 | |||||||||||||
7621 | 7621 | Israel Washburn W000173 | rep | ME | 1853-12-05 | 1855-03-03 | Whig | 5 |
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);