legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
269 rows where "end" is on date 1853-03-03 sorted by state
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5940 | 5940 | Jeremiah Clemens C000501 | sen | AL | 1849-12-03 | 1853-03-03 | 2 | Democrat | |||||||||||||
6227 | 6227 | John Bragg B000758 | rep | AL | 1851-12-01 | 1853-03-03 | Democrat | 1 | |||||||||||||
6486 | 6486 | James Abercrombie A000012 | rep | AL | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
6829 | 6829 | Sampson Harris H000252 | rep | AL | 1851-12-01 | 1853-03-03 | Democrat | 3 | |||||||||||||
6924 | 6924 | William Smith S000637 | rep | AL | 1851-12-01 | 1853-03-03 | Democrat | 4 | |||||||||||||
7349 | 7349 | Williamson Cobb C000554 | rep | AL | 1851-12-01 | 1853-03-03 | Democrat | 6 | |||||||||||||
9406 | 9406 | Alexander White W000353 | rep | AL | 1851-12-01 | 1853-03-03 | Whig | 7 | |||||||||||||
10111 | 10111 | George Houston H000822 | rep | AL | 1851-12-01 | 1853-03-03 | Democrat | 5 | |||||||||||||
6847 | 6847 | Robert Johnson J000172 | rep | AR | 1851-12-01 | 1853-03-03 | Democrat | 1 | |||||||||||||
7564 | 7564 | William Sebastian S000216 | sen | AR | 1848-01-01 | 1853-03-03 | 2 | Democrat | |||||||||||||
6357 | 6357 | Edward Marshall M000151 | rep | CA | 1851-12-01 | 1853-03-03 | Democrat | -1 | |||||||||||||
6359 | 6359 | Joseph McCorkle M000362 | rep | CA | 1851-12-01 | 1853-03-03 | Democrat | -1 | |||||||||||||
6256 | 6256 | Charles Chapman C000310 | rep | CT | 1851-12-01 | 1853-03-03 | Whig | 1 | |||||||||||||
6259 | 6259 | Chauncey Cleveland C000511 | rep | CT | 1851-12-01 | 1853-03-03 | Democrat | 3 | |||||||||||||
6624 | 6624 | Colin Ingersoll I000016 | rep | CT | 1851-12-01 | 1853-03-03 | Democrat | 2 | |||||||||||||
6686 | 6686 | Origen Seymour S000270 | rep | CT | 1851-12-01 | 1853-03-03 | Democrat | 4 | |||||||||||||
5825 | 5825 | Presley Spruance S000760 | sen | DE | 1847-12-06 | 1853-03-03 | 2 | Whig | |||||||||||||
8071 | 8071 | George Riddle R000239 | rep | DE | 1851-12-01 | 1853-03-03 | Democrat | 0 | |||||||||||||
6245 | 6245 | Edward Cabell C000003 | rep | FL | 1851-12-01 | 1853-03-03 | Whig | 1 | |||||||||||||
5616 | 5616 | John Berrien B000413 | sen | GA | 1847-12-06 | 1853-03-03 | 2 | Whig | |||||||||||||
6341 | 6341 | Joseph Jackson J000023 | rep | GA | 1851-12-01 | 1853-03-03 | States Rights | 1 | |||||||||||||
6346 | 6346 | James Johnson J000144 | rep | GA | 1851-12-01 | 1853-03-03 | Unionist | 2 | |||||||||||||
6374 | 6374 | Charles Murphey M001086 | rep | GA | 1851-12-01 | 1853-03-03 | Unionist | 4 | |||||||||||||
6472 | 6472 | Robert Charlton C000324 | sen | GA | 1852-01-01 | 1853-03-03 | 2 | Democrat | |||||||||||||
6499 | 6499 | David Bailey B000036 | rep | GA | 1851-12-01 | 1853-03-03 | States Rights | 3 | |||||||||||||
6542 | 6542 | Elijah Chastain C000335 | rep | GA | 1851-12-01 | 1853-03-03 | Democrat | 5 | |||||||||||||
6613 | 6613 | Junius Hillyer H000625 | rep | GA | 1851-12-01 | 1853-03-03 | Democrat | 6 | |||||||||||||
7612 | 7612 | Robert Toombs T000313 | rep | GA | 1851-12-01 | 1853-03-03 | Whig | 8 | |||||||||||||
10553 | 10553 | Alexander Stephens S000854 | rep | GA | 1851-12-01 | 1853-03-03 | Unionist | 7 | |||||||||||||
6257 | 6257 | Lincoln Clark C000445 | rep | IA | 1851-12-01 | 1853-03-03 | Democrat | 2 | |||||||||||||
6606 | 6606 | Bernhart Henn H000500 | rep | IA | 1851-12-01 | 1853-03-03 | Democrat | 1 | |||||||||||||
6631 | 6631 | George Jones J000221 | sen | IA | 1848-01-01 | 1853-03-03 | 2 | Democrat | |||||||||||||
6250 | 6250 | Thompson Campbell C000102 | rep | IL | 1851-12-01 | 1853-03-03 | Democrat | 6 | |||||||||||||
6293 | 6293 | Orlando Ficklin F000101 | rep | IL | 1851-12-01 | 1853-03-03 | Democrat | 3 | |||||||||||||
6366 | 6366 | Richard Molony M000846 | rep | IL | 1851-12-01 | 1853-03-03 | Democrat | 4 | |||||||||||||
6489 | 6489 | Willis Allen A000154 | rep | IL | 1851-12-01 | 1853-03-03 | Democrat | 2 | |||||||||||||
6519 | 6519 | William Bissell B000492 | rep | IL | 1851-12-01 | 1853-03-03 | Democrat | 1 | |||||||||||||
7388 | 7388 | Stephen Douglas D000457 | sen | IL | 1847-12-06 | 1853-03-03 | 2 | Democrat | |||||||||||||
8024 | 8024 | William Richardson R000228 | rep | IL | 1851-12-01 | 1853-03-03 | Democrat | 5 | |||||||||||||
8240 | 8240 | Richard Yates Y000012 | rep | IL | 1851-12-01 | 1853-03-03 | Whig | 7 | |||||||||||||
6170 | 6170 | James Whitcomb W000349 | sen | IN | 1849-12-03 | 1853-03-03 | 3 | Democrat | |||||||||||||
6314 | 6314 | Willis Gorman G000330 | rep | IN | 1851-12-01 | 1853-03-03 | Democrat | 6 | |||||||||||||
6396 | 6396 | John Robinson R000343 | rep | IN | 1851-12-01 | 1853-03-03 | Democrat | 3 | |||||||||||||
6572 | 6572 | Cyrus Dunham D000540 | rep | IN | 1851-12-01 | 1853-03-03 | Democrat | 2 | |||||||||||||
6662 | 6662 | Samuel Parker P000071 | rep | IN | 1851-12-01 | 1853-03-03 | Whig | 4 | |||||||||||||
6865 | 6865 | Daniel Mace M000008 | rep | IN | 1851-12-01 | 1853-03-03 | Democrat | 8 | |||||||||||||
6988 | 6988 | Samuel Brenton B000805 | rep | IN | 1851-12-01 | 1853-03-03 | Whig | 10 | |||||||||||||
7045 | 7045 | Graham Fitch F000158 | rep | IN | 1851-12-01 | 1853-03-03 | Democrat | 9 | |||||||||||||
7137 | 7137 | James Lockhart L000390 | rep | IN | 1851-12-01 | 1853-03-03 | Democrat | 1 | |||||||||||||
7374 | 7374 | John Davis D000118 | rep | IN | 1851-12-01 | 1853-03-03 | Democrat | 7 | |||||||||||||
7967 | 7967 | Thomas Hendricks H000493 | rep | IN | 1851-12-01 | 1853-03-03 | Democrat | 5 | |||||||||||||
5852 | 5852 | Joseph Underwood U000011 | sen | KY | 1847-12-06 | 1853-03-03 | 2 | Whig | |||||||||||||
5939 | 5939 | Henry Clay C000482 | sen | KY | 1849-12-03 | 1853-03-03 | 3 | Whig | |||||||||||||
6428 | 6428 | James Stone S000958 | rep | KY | 1851-12-01 | 1853-03-03 | Democrat | 5 | |||||||||||||
6448 | 6448 | William Ward W000145 | rep | KY | 1851-12-01 | 1853-03-03 | Whig | 4 | |||||||||||||
6452 | 6452 | Addison White W000350 | rep | KY | 1851-12-01 | 1853-03-03 | Whig | 6 | |||||||||||||
6475 | 6475 | David Meriwether M000650 | sen | KY | 1852-01-01 | 1853-03-03 | 3 | Democrat | |||||||||||||
6529 | 6529 | Linn Boyd B000719 | rep | KY | 1851-12-01 | 1853-03-03 | Democrat | 1 | |||||||||||||
6589 | 6589 | Presley Ewing E000279 | rep | KY | 1851-12-01 | 1853-03-03 | Whig | 3 | |||||||||||||
6600 | 6600 | Benjamin Grey G000453 | rep | KY | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
6677 | 6677 | William Preston P000517 | rep | KY | 1851-12-01 | 1853-03-03 | Whig | 7 | |||||||||||||
6703 | 6703 | Richard Stanton S000806 | rep | KY | 1851-12-01 | 1853-03-03 | Democrat | 10 | |||||||||||||
7142 | 7142 | Humphrey Marshall M000154 | rep | KY | 1851-12-01 | 1853-03-03 | Whig | 7 | |||||||||||||
7150 | 7150 | John Mason M000218 | rep | KY | 1851-12-01 | 1853-03-03 | Democrat | 9 | |||||||||||||
7671 | 7671 | John Breckinridge B000789 | rep | KY | 1851-12-01 | 1853-03-03 | Democrat | 8 | |||||||||||||
5674 | 5674 | Solomon Downs D000476 | sen | LA | 1847-12-06 | 1853-03-03 | 2 | Democrat | |||||||||||||
6352 | 6352 | Joseph Landry L000055 | rep | LA | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
6371 | 6371 | John Moore M000903 | rep | LA | 1851-12-01 | 1853-03-03 | Whig | 4 | |||||||||||||
6385 | 6385 | Alexander Penn P000210 | rep | LA | 1851-12-01 | 1853-03-03 | Democrat | 3 | |||||||||||||
11203 | 11203 | Louis St. Martin S000768 | rep | LA | 1851-12-01 | 1853-03-03 | Democrat | 1 | |||||||||||||
5670 | 5670 | John Davis D000117 | sen | MA | 1847-12-06 | 1853-03-03 | 2 | Whig | |||||||||||||
6209 | 6209 | Charles Allen A000115 | rep | MA | 1851-12-01 | 1853-03-03 | Free Soil | 5 | |||||||||||||
6271 | 6271 | George Davis D000101 | rep | MA | 1851-12-01 | 1853-03-03 | Whig | 6 | |||||||||||||
6285 | 6285 | James Duncan D000532 | rep | MA | 1851-12-01 | 1853-03-03 | Whig | 3 | |||||||||||||
6289 | 6289 | Francis Fay F000050 | rep | MA | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
6300 | 6300 | Orin Fowler F000325 | rep | MA | 1851-12-01 | 1853-03-03 | Whig | 9 | |||||||||||||
6353 | 6353 | Edward Little L000350 | rep | MA | 1851-12-01 | 1853-03-03 | Democrat | 9 | |||||||||||||
6356 | 6356 | Horace Mann M000102 | rep | MA | 1851-12-01 | 1853-03-03 | Free Soil | 8 | |||||||||||||
6403 | 6403 | Lorenzo Sabine S000004 | rep | MA | 1851-12-01 | 1853-03-03 | Whig | 4 | |||||||||||||
6434 | 6434 | Benjamin Thompson T000192 | rep | MA | 1851-12-01 | 1853-03-03 | Whig | 4 | |||||||||||||
6596 | 6596 | John Goodrich G000295 | rep | MA | 1851-12-01 | 1853-03-03 | Whig | 7 | |||||||||||||
6684 | 6684 | Zeno Scudder S000204 | rep | MA | 1851-12-01 | 1853-03-03 | Whig | 10 | |||||||||||||
7654 | 7654 | William Appleton A000270 | rep | MA | 1851-12-01 | 1853-03-03 | Whig | 1 | |||||||||||||
6224 | 6224 | Richard Bowie B000694 | rep | MD | 1851-12-01 | 1853-03-03 | Whig | 1 | |||||||||||||
6263 | 6263 | Joseph Cottman C000800 | rep | MD | 1851-12-01 | 1853-03-03 | Ind. Whig | 6 | |||||||||||||
6288 | 6288 | Alexander Evans E000231 | rep | MD | 1851-12-01 | 1853-03-03 | Whig | 5 | |||||||||||||
6319 | 6319 | Edward Hammond H000126 | rep | MD | 1851-12-01 | 1853-03-03 | Democrat | 3 | |||||||||||||
6447 | 6447 | Thomas Walsh W000105 | rep | MD | 1851-12-01 | 1853-03-03 | Whig | 4 | |||||||||||||
8617 | 8617 | William Hamilton H000118 | rep | MD | 1851-12-01 | 1853-03-03 | Democrat | 2 | |||||||||||||
5627 | 5627 | James Bradbury B000734 | sen | ME | 1847-12-06 | 1853-03-03 | 2 | Democrat | |||||||||||||
6210 | 6210 | Charles Andrews A000243 | rep | ME | 1851-12-01 | 1853-03-03 | Democrat | 4 | |||||||||||||
6211 | 6211 | John Appleton A000268 | rep | ME | 1851-12-01 | 1853-03-03 | Democrat | 2 | |||||||||||||
6312 | 6312 | Robert Goodenow G000284 | rep | ME | 1851-12-01 | 1853-03-03 | Whig | 3 | |||||||||||||
6392 | 6392 | Isaac Reed R000117 | rep | ME | 1851-12-01 | 1853-03-03 | Whig | 4 | |||||||||||||
6418 | 6418 | Ephraim Smart S000503 | rep | ME | 1851-12-01 | 1853-03-03 | Democrat | 5 | |||||||||||||
6644 | 6644 | Moses Macdonald M000004 | rep | ME | 1851-12-01 | 1853-03-03 | Democrat | 1 | |||||||||||||
6821 | 6821 | Thomas Fuller F000412 | rep | ME | 1851-12-01 | 1853-03-03 | Democrat | 7 | |||||||||||||
7620 | 7620 | Israel Washburn W000173 | rep | ME | 1851-12-01 | 1853-03-03 | Whig | 6 | |||||||||||||
5691 | 5691 | Alpheus Felch F000063 | sen | MI | 1847-12-06 | 1853-03-03 | 2 | Democrat | |||||||||||||
6262 | 6262 | James Conger C000677 | rep | MI | 1851-12-01 | 1853-03-03 | Whig | 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);