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 rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13972 | 13972 | Galusha Grow G000507 | rep | PA | 1851-12-01 | 1853-03-03 | Democrat | 12 | |||||||||||||
13022 | 13022 | Isham Harris H000243 | rep | TN | 1851-12-01 | 1853-03-03 | Democrat | 9 | |||||||||||||
11203 | 11203 | Louis St. Martin S000768 | rep | LA | 1851-12-01 | 1853-03-03 | Democrat | 1 | |||||||||||||
10553 | 10553 | Alexander Stephens S000854 | rep | GA | 1851-12-01 | 1853-03-03 | Unionist | 7 | |||||||||||||
10111 | 10111 | George Houston H000822 | rep | AL | 1851-12-01 | 1853-03-03 | Democrat | 5 | |||||||||||||
9620 | 9620 | John Robbins R000301 | rep | PA | 1851-12-01 | 1853-03-03 | Democrat | 4 | |||||||||||||
9544 | 9544 | Andrew Johnson J000116 | rep | TN | 1851-12-01 | 1853-03-03 | Democrat | 1 | |||||||||||||
9502 | 9502 | Charles Faulkner F000044 | rep | VA | 1851-12-01 | 1853-03-03 | Whig | 10 | |||||||||||||
9406 | 9406 | Alexander White W000353 | rep | AL | 1851-12-01 | 1853-03-03 | Whig | 7 | |||||||||||||
9144 | 9144 | Carlton Curtis C001007 | rep | PA | 1851-12-01 | 1853-03-03 | Democrat | 23 | |||||||||||||
9101 | 9101 | James Brooks B000881 | rep | NY | 1851-12-01 | 1853-03-03 | Whig | 6 | |||||||||||||
8849 | 8849 | Lewis Campbell C000096 | rep | OH | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
8617 | 8617 | William Hamilton H000118 | rep | MD | 1851-12-01 | 1853-03-03 | Democrat | 2 | |||||||||||||
8449 | 8449 | Thaddeus Stevens S000887 | rep | PA | 1851-12-01 | 1853-03-03 | Whig | 8 | |||||||||||||
8240 | 8240 | Richard Yates Y000012 | rep | IL | 1851-12-01 | 1853-03-03 | Whig | 7 | |||||||||||||
8102 | 8102 | John Dawson D000153 | rep | PA | 1851-12-01 | 1853-03-03 | Democrat | 18 | |||||||||||||
8071 | 8071 | George Riddle R000239 | rep | DE | 1851-12-01 | 1853-03-03 | Democrat | 0 | |||||||||||||
8024 | 8024 | William Richardson R000228 | rep | IL | 1851-12-01 | 1853-03-03 | Democrat | 5 | |||||||||||||
7967 | 7967 | Thomas Hendricks H000493 | rep | IN | 1851-12-01 | 1853-03-03 | Democrat | 5 | |||||||||||||
7830 | 7830 | John Phelps P000296 | rep | MO | 1851-12-01 | 1853-03-03 | Democrat | 5 | |||||||||||||
7671 | 7671 | John Breckinridge B000789 | rep | KY | 1851-12-01 | 1853-03-03 | Democrat | 8 | |||||||||||||
7661 | 7661 | John Bernhisel B000412 | rep | UT | 1851-12-01 | 1853-03-03 | Whig | -1 | |||||||||||||
7654 | 7654 | William Appleton A000270 | rep | MA | 1851-12-01 | 1853-03-03 | Whig | 1 | |||||||||||||
7620 | 7620 | Israel Washburn W000173 | rep | ME | 1851-12-01 | 1853-03-03 | Whig | 6 | |||||||||||||
7612 | 7612 | Robert Toombs T000313 | rep | GA | 1851-12-01 | 1853-03-03 | Whig | 8 | |||||||||||||
7582 | 7582 | Benjamin Stanton S000801 | rep | OH | 1851-12-01 | 1853-03-03 | Whig | 4 | |||||||||||||
7564 | 7564 | William Sebastian S000216 | sen | AR | 1848-01-01 | 1853-03-03 | 2 | Democrat | |||||||||||||
7509 | 7509 | John Millson M000780 | rep | VA | 1851-12-01 | 1853-03-03 | Democrat | 1 | |||||||||||||
7503 | 7503 | John McRae M000596 | sen | MS | 1851-12-01 | 1853-03-03 | 1 | Democrat | |||||||||||||
7498 | 7498 | John McQueen M000595 | rep | SC | 1851-12-01 | 1853-03-03 | Democrat | 4 | |||||||||||||
7475 | 7475 | Joseph Lane L000062 | rep | OR | 1851-12-01 | 1853-03-03 | Democrat | -1 | |||||||||||||
7455 | 7455 | Robert Hunter H000988 | sen | VA | 1847-12-06 | 1853-03-03 | 2 | Democrat | |||||||||||||
7427 | 7427 | John Hale H000034 | sen | NH | 1847-12-06 | 1853-03-03 | 2 | Free Soil | |||||||||||||
7405 | 7405 | Thomas Florence F000214 | rep | PA | 1851-12-01 | 1853-03-03 | Democrat | 1 | |||||||||||||
7392 | 7392 | Henry Edmundson E000058 | rep | VA | 1851-12-01 | 1853-03-03 | Democrat | 12 | |||||||||||||
7388 | 7388 | Stephen Douglas D000457 | sen | IL | 1847-12-06 | 1853-03-03 | 2 | Democrat | |||||||||||||
7374 | 7374 | John Davis D000118 | rep | IN | 1851-12-01 | 1853-03-03 | Democrat | 7 | |||||||||||||
7349 | 7349 | Williamson Cobb C000554 | rep | AL | 1851-12-01 | 1853-03-03 | Democrat | 6 | |||||||||||||
7343 | 7343 | Sherrard Clemens C000502 | rep | VA | 1851-12-01 | 1853-03-03 | Democrat | 15 | |||||||||||||
7325 | 7325 | Albert Brown B000900 | rep | MS | 1851-12-01 | 1853-03-03 | States Rights | 4 | |||||||||||||
7318 | 7318 | George Briggs B000829 | rep | NY | 1851-12-01 | 1853-03-03 | Whig | 5 | |||||||||||||
7297 | 7297 | Thomas Bocock B000582 | rep | VA | 1851-12-01 | 1853-03-03 | Democrat | 4 | |||||||||||||
7263 | 7263 | Thomas Clingman C000524 | rep | NC | 1851-12-01 | 1853-03-03 | Whig | 1 | |||||||||||||
7247 | 7247 | Albert Watkins W000189 | rep | TN | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
7211 | 7211 | John Savage S000083 | rep | TN | 1851-12-01 | 1853-03-03 | Democrat | 4 | |||||||||||||
7186 | 7186 | Paulus Powell P000483 | rep | VA | 1851-12-01 | 1853-03-03 | Democrat | 5 | |||||||||||||
7174 | 7174 | James Orr O000104 | rep | SC | 1851-12-01 | 1853-03-03 | Democrat | 2 | |||||||||||||
7150 | 7150 | John Mason M000218 | rep | KY | 1851-12-01 | 1853-03-03 | Democrat | 9 | |||||||||||||
7142 | 7142 | Humphrey Marshall M000154 | rep | KY | 1851-12-01 | 1853-03-03 | Whig | 7 | |||||||||||||
7137 | 7137 | James Lockhart L000390 | rep | IN | 1851-12-01 | 1853-03-03 | Democrat | 1 | |||||||||||||
7133 | 7133 | John Letcher L000256 | rep | VA | 1851-12-01 | 1853-03-03 | Democrat | 11 | |||||||||||||
7121 | 7121 | Preston King K000211 | rep | NY | 1851-12-01 | 1853-03-03 | Democrat | 18 | |||||||||||||
7109 | 7109 | Jehu Jones J000234 | rep | PA | 1851-12-01 | 1853-03-03 | Democrat | 9 | |||||||||||||
7105 | 7105 | George Jones J000222 | rep | TN | 1851-12-01 | 1853-03-03 | Democrat | 5 | |||||||||||||
7055 | 7055 | Joshua Giddings G000167 | rep | OH | 1851-12-01 | 1853-03-03 | Free Soil | 20 | |||||||||||||
7045 | 7045 | Graham Fitch F000158 | rep | IN | 1851-12-01 | 1853-03-03 | Democrat | 9 | |||||||||||||
7003 | 7003 | John Caskie C000231 | rep | VA | 1851-12-01 | 1853-03-03 | Democrat | 6 | |||||||||||||
6988 | 6988 | Samuel Brenton B000805 | rep | IN | 1851-12-01 | 1853-03-03 | Whig | 10 | |||||||||||||
6977 | 6977 | Henry Bennett B000376 | rep | NY | 1851-12-01 | 1853-03-03 | Whig | 22 | |||||||||||||
6932 | 6932 | Benjamin Thurston T000255 | rep | RI | 1851-12-01 | 1853-03-03 | Democrat | 2 | |||||||||||||
6924 | 6924 | William Smith S000637 | rep | AL | 1851-12-01 | 1853-03-03 | Democrat | 4 | |||||||||||||
6899 | 6899 | Gilchrist Porter P000440 | rep | MO | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
6880 | 6880 | John Miller M000741 | rep | MO | 1851-12-01 | 1853-03-03 | Whig | 3 | |||||||||||||
6877 | 6877 | James Meacham M000613 | rep | VT | 1851-12-01 | 1853-03-03 | Whig | 3 | |||||||||||||
6873 | 6873 | Fayette McMullen M000578 | rep | VA | 1851-12-01 | 1853-03-03 | Democrat | 13 | |||||||||||||
6865 | 6865 | Daniel Mace M000008 | rep | IN | 1851-12-01 | 1853-03-03 | Democrat | 8 | |||||||||||||
6847 | 6847 | Robert Johnson J000172 | rep | AR | 1851-12-01 | 1853-03-03 | Democrat | 1 | |||||||||||||
6834 | 6834 | Solomon Haven H000355 | rep | NY | 1851-12-01 | 1853-03-03 | Whig | 32 | |||||||||||||
6829 | 6829 | Sampson Harris H000252 | rep | AL | 1851-12-01 | 1853-03-03 | Democrat | 3 | |||||||||||||
6821 | 6821 | Thomas Fuller F000412 | rep | ME | 1851-12-01 | 1853-03-03 | Democrat | 7 | |||||||||||||
6818 | 6818 | Henry Fuller F000410 | rep | PA | 1851-12-01 | 1853-03-03 | Whig | 11 | |||||||||||||
6807 | 6807 | Charles Durkee D000573 | rep | WI | 1851-12-01 | 1853-03-03 | Free Soil | 1 | |||||||||||||
6766 | 6766 | Thomas Bayly B000259 | rep | VA | 1851-12-01 | 1853-03-03 | Democrat | 7 | |||||||||||||
6755 | 6755 | John Allison A000158 | rep | PA | 1851-12-01 | 1853-03-03 | Whig | 20 | |||||||||||||
6750 | 6750 | William Aiken A000063 | rep | SC | 1851-12-01 | 1853-03-03 | Democrat | 6 | |||||||||||||
6717 | 6717 | John Taylor T000089 | rep | OH | 1851-12-01 | 1853-03-03 | Whig | 8 | |||||||||||||
6711 | 6711 | Charles Stuart S001033 | rep | MI | 1851-12-01 | 1853-03-03 | Democrat | 2 | |||||||||||||
6706 | 6706 | Nathan Stratton S000996 | rep | NJ | 1851-12-01 | 1853-03-03 | Democrat | 1 | |||||||||||||
6703 | 6703 | Richard Stanton S000806 | rep | KY | 1851-12-01 | 1853-03-03 | Democrat | 10 | |||||||||||||
6700 | 6700 | Frederick Stanton S000802 | rep | TN | 1851-12-01 | 1853-03-03 | Democrat | 10 | |||||||||||||
6690 | 6690 | Charles Skelton S000464 | rep | NJ | 1851-12-01 | 1853-03-03 | Democrat | 2 | |||||||||||||
6686 | 6686 | Origen Seymour S000270 | rep | CT | 1851-12-01 | 1853-03-03 | Democrat | 4 | |||||||||||||
6684 | 6684 | Zeno Scudder S000204 | rep | MA | 1851-12-01 | 1853-03-03 | Whig | 10 | |||||||||||||
6677 | 6677 | William Preston P000517 | rep | KY | 1851-12-01 | 1853-03-03 | Whig | 7 | |||||||||||||
6662 | 6662 | Samuel Parker P000071 | rep | IN | 1851-12-01 | 1853-03-03 | Whig | 4 | |||||||||||||
6660 | 6660 | Edson Olds O000063 | rep | OH | 1851-12-01 | 1853-03-03 | Democrat | 9 | |||||||||||||
6656 | 6656 | William Murray M001116 | rep | NY | 1851-12-01 | 1853-03-03 | Democrat | 9 | |||||||||||||
6650 | 6650 | John McNair M000581 | rep | PA | 1851-12-01 | 1853-03-03 | Democrat | 5 | |||||||||||||
6644 | 6644 | Moses Macdonald M000004 | rep | ME | 1851-12-01 | 1853-03-03 | Democrat | 1 | |||||||||||||
6636 | 6636 | William Kurtz K000345 | rep | PA | 1851-12-01 | 1853-03-03 | Democrat | 15 | |||||||||||||
6631 | 6631 | George Jones J000221 | sen | IA | 1848-01-01 | 1853-03-03 | 2 | Democrat | |||||||||||||
6627 | 6627 | Daniel Jones J000215 | rep | NY | 1851-12-01 | 1853-03-03 | Democrat | 24 | |||||||||||||
6624 | 6624 | Colin Ingersoll I000016 | rep | CT | 1851-12-01 | 1853-03-03 | Democrat | 2 | |||||||||||||
6620 | 6620 | Thomas Howe H000854 | rep | PA | 1851-12-01 | 1853-03-03 | Whig | 21 | |||||||||||||
6618 | 6618 | Samuel Houston H000827 | sen | TX | 1847-12-06 | 1853-03-03 | 2 | Democrat | |||||||||||||
6613 | 6613 | Junius Hillyer H000625 | rep | GA | 1851-12-01 | 1853-03-03 | Democrat | 6 | |||||||||||||
6609 | 6609 | Harry Hibbard H000557 | rep | NH | 1851-12-01 | 1853-03-03 | Democrat | 4 | |||||||||||||
6606 | 6606 | Bernhart Henn H000500 | rep | IA | 1851-12-01 | 1853-03-03 | Democrat | 1 | |||||||||||||
6600 | 6600 | Benjamin Grey G000453 | rep | KY | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
6598 | 6598 | Frederick Green G000409 | rep | OH | 1851-12-01 | 1853-03-03 | Democrat | 6 |
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);