legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
286 rows where "end" is on date 1843-03-03
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4883 | 4883 | John Maxwell M000268 | rep | NJ | 1841-05-31 | 1843-03-03 | Whig | -1 | |||||||||||||
4885 | 4885 | John Maynard M000285 | rep | NY | 1841-05-31 | 1843-03-03 | Whig | 25 | |||||||||||||
4888 | 4888 | Abraham McClellan M000328 | rep | TN | 1841-05-31 | 1843-03-03 | Democrat | 2 | |||||||||||||
4890 | 4890 | Robert McClellan M000333 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 8 | |||||||||||||
4895 | 4895 | Thomas McKennan M000501 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 21 | |||||||||||||
4897 | 4897 | John McKeon M000509 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 3 | |||||||||||||
4900 | 4900 | William Medill M000624 | rep | OH | 1841-05-31 | 1843-03-03 | Democrat | 9 | |||||||||||||
4901 | 4901 | James Meriwether M000652 | rep | GA | 1841-05-31 | 1843-03-03 | Whig | -1 | |||||||||||||
4904 | 4904 | John Miller M000735 | rep | MO | 1841-05-31 | 1843-03-03 | Democrat | -1 | |||||||||||||
4905 | 4905 | Anderson Mitchell M000804 | rep | NC | 1841-05-31 | 1843-03-03 | Whig | 13 | |||||||||||||
4908 | 4908 | Christopher Morgan M000945 | rep | NY | 1841-05-31 | 1843-03-03 | Whig | 24 | |||||||||||||
4911 | 4911 | Calvary Morris M000973 | rep | OH | 1841-05-31 | 1843-03-03 | Whig | 6 | |||||||||||||
4919 | 4919 | Jeremiah Morrow M001003 | rep | OH | 1841-05-31 | 1843-03-03 | Whig | 4 | |||||||||||||
4921 | 4921 | Peter Newhard N000068 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 8 | |||||||||||||
4923 | 4923 | Eugenius Nisbet N000111 | rep | GA | 1841-05-31 | 1843-03-03 | Whig | -1 | |||||||||||||
4926 | 4926 | Charles Ogle O000047 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 18 | |||||||||||||
4927 | 4927 | William Oliver O000078 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 27 | |||||||||||||
4929 | 4929 | Thomas Osborne O000114 | rep | CT | 1841-05-31 | 1843-03-03 | Whig | 4 | |||||||||||||
4930 | 4930 | Bryan Owsley O000162 | rep | KY | 1841-05-31 | 1843-03-03 | Whig | 4 | |||||||||||||
4931 | 4931 | Samuel Partridge P000093 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 22 | |||||||||||||
4932 | 4932 | Nathanael Pendleton P000208 | rep | OH | 1841-05-31 | 1843-03-03 | Whig | 1 | |||||||||||||
4937 | 4937 | Francis Pickens P000321 | rep | SC | 1841-05-31 | 1843-03-03 | Democrat | 5 | |||||||||||||
4939 | 4939 | Arnold Plumer P000391 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 25 | |||||||||||||
4943 | 4943 | John Pope P000431 | rep | KY | 1841-05-31 | 1843-03-03 | Whig | 7 | |||||||||||||
4944 | 4944 | Cuthbert Powell P000479 | rep | VA | 1841-05-31 | 1843-03-03 | Whig | 14 | |||||||||||||
4946 | 4946 | George Proffit P000548 | rep | IN | 1841-05-31 | 1843-03-03 | Whig | 1 | |||||||||||||
4948 | 4948 | Robert Ramsey R000028 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 6 | |||||||||||||
4949 | 4949 | Alexander Randall R000034 | rep | MD | 1841-05-31 | 1843-03-03 | Whig | 4 | |||||||||||||
4951 | 4951 | Benjamin Randall R000035 | rep | ME | 1841-05-31 | 1843-03-03 | Whig | 3 | |||||||||||||
4954 | 4954 | Joseph Randolph R000048 | rep | NJ | 1841-05-31 | 1843-03-03 | Whig | -1 | |||||||||||||
4960 | 4960 | Abraham Rencher R000162 | rep | NC | 1841-05-31 | 1843-03-03 | Whig | 10 | |||||||||||||
4964 | 4964 | John Reynolds R000174 | rep | IL | 1841-05-31 | 1843-03-03 | Democrat | 1 | |||||||||||||
4967 | 4967 | Joseph Ridgway R000247 | rep | OH | 1841-05-31 | 1843-03-03 | Whig | 8 | |||||||||||||
4968 | 4968 | Lewis Riggs R000255 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 22 | |||||||||||||
4978 | 4978 | James Rogers R000396 | rep | SC | 1841-05-31 | 1843-03-03 | Democrat | 7 | |||||||||||||
4979 | 4979 | James Roosevelt R000427 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 3 | |||||||||||||
4980 | 4980 | James Russell R000527 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 18 | |||||||||||||
4984 | 4984 | William Russell R000540 | rep | OH | 1841-05-31 | 1843-03-03 | Whig | 7 | |||||||||||||
4987 | 4987 | Leverett Saltonstall S000020 | rep | MA | 1841-05-31 | 1843-03-03 | Whig | 2 | |||||||||||||
4988 | 4988 | John Sanford S000048 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 15 | |||||||||||||
4996 | 4996 | John Sergeant S000246 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 2 | |||||||||||||
4998 | 4998 | Charles Sewall S000258 | rep | MD | 1841-05-31 | 1843-03-03 | Democrat | 3 | |||||||||||||
5000 | 5000 | Tristram Shaw S000311 | rep | NH | 1841-05-31 | 1843-03-03 | Democrat | -1 | |||||||||||||
5001 | 5001 | Benjamin Shields S000359 | rep | AL | 1841-05-31 | 1843-03-03 | Democrat | 0 | |||||||||||||
5003 | 5003 | William Simonton S000427 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 10 | |||||||||||||
5009 | 5009 | William Slade S000475 | rep | VT | 1841-05-31 | 1843-03-03 | Whig | 2 | |||||||||||||
5010 | 5010 | John Snyder S000667 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 16 | |||||||||||||
5011 | 5011 | James Sprigg S000750 | rep | KY | 1841-05-31 | 1843-03-03 | Whig | 8 | |||||||||||||
5012 | 5012 | Samuel Stokely S000945 | rep | OH | 1841-05-31 | 1843-03-03 | Whig | 19 | |||||||||||||
5014 | 5014 | Charles Stratton S000993 | rep | NJ | 1841-05-31 | 1843-03-03 | Whig | -1 | |||||||||||||
5015 | 5015 | Alexander Stuart S001030 | rep | VA | 1841-05-31 | 1843-03-03 | Whig | 17 | |||||||||||||
5017 | 5017 | Thomas Sumter S001074 | rep | SC | 1841-05-31 | 1843-03-03 | Democrat | 8 | |||||||||||||
5019 | 5019 | George Sweeny S001105 | rep | OH | 1841-05-31 | 1843-03-03 | Democrat | 14 | |||||||||||||
5029 | 5029 | John Taliaferro T000027 | rep | VA | 1841-05-31 | 1843-03-03 | Whig | 10 | |||||||||||||
5032 | 5032 | Joseph Tillinghast T000272 | rep | RI | 1841-05-31 | 1843-03-03 | Whig | -1 | |||||||||||||
5035 | 5035 | George Toland T000296 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 2 | |||||||||||||
5036 | 5036 | Thomas Tomlinson T000301 | rep | NY | 1841-05-31 | 1843-03-03 | Whig | 13 | |||||||||||||
5038 | 5038 | Philip Triplett T000378 | rep | KY | 1841-05-31 | 1843-03-03 | Whig | 2 | |||||||||||||
5039 | 5039 | Samuel Trotti T000381 | rep | SC | 1841-05-31 | 1843-03-03 | Democrat | 4 | |||||||||||||
5042 | 5042 | Joseph Trumbull T000391 | rep | CT | 1841-05-31 | 1843-03-03 | Whig | 1 | |||||||||||||
5043 | 5043 | John Van Buren V000015 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 7 | |||||||||||||
5044 | 5044 | Henry Van Rensselaer V000052 | rep | NY | 1841-05-31 | 1843-03-03 | Whig | 14 | |||||||||||||
5047 | 5047 | David Wallace W000076 | rep | IN | 1841-05-31 | 1843-03-03 | Whig | 6 | |||||||||||||
5053 | 5053 | Aaron Ward W000125 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 4 | |||||||||||||
5055 | 5055 | Lott Warren W000167 | rep | GA | 1841-05-31 | 1843-03-03 | Whig | -1 | |||||||||||||
5056 | 5056 | William Washington W000182 | rep | NC | 1841-05-31 | 1843-03-03 | Whig | 4 | |||||||||||||
5058 | 5058 | Harvey Watterson W000208 | rep | TN | 1841-05-31 | 1843-03-03 | Democrat | 9 | |||||||||||||
5059 | 5059 | John Westbrook W000306 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 7 | |||||||||||||
5064 | 5064 | Edward White W000365 | rep | LA | 1841-05-31 | 1843-03-03 | Whig | 1 | |||||||||||||
5065 | 5065 | Joseph White W000382 | rep | IN | 1841-05-31 | 1843-03-03 | Whig | 3 | |||||||||||||
5066 | 5066 | James Williams W000509 | rep | MD | 1841-05-31 | 1843-03-03 | Democrat | 3 | |||||||||||||
5069 | 5069 | Joseph Williams W000524 | rep | TN | 1841-05-31 | 1843-03-03 | Whig | 3 | |||||||||||||
5083 | 5083 | Lewis Williams W000527 | rep | NC | 1841-05-31 | 1843-03-03 | Whig | 13 | |||||||||||||
5085 | 5085 | Thomas Williams W000543 | rep | CT | 1841-05-31 | 1843-03-03 | Whig | 3 | |||||||||||||
5091 | 5091 | Thomas Yorke Y000023 | rep | NJ | 1841-05-31 | 1843-03-03 | Whig | -1 | |||||||||||||
5092 | 5092 | Augustus Young Y000029 | rep | VT | 1841-05-31 | 1843-03-03 | Whig | 4 | |||||||||||||
5094 | 5094 | John Young Y000042 | rep | NY | 1841-05-31 | 1843-03-03 | Whig | 30 | |||||||||||||
5099 | 5099 | Samuel Crafts C000851 | sen | VT | 1842-01-01 | 1843-03-03 | 3 | Whig | |||||||||||||
5107 | 5107 | George McDuffie M000426 | sen | SC | 1842-12-23 | 1843-03-03 | 3 | Democrat | |||||||||||||
5111 | 5111 | Leonard Wilcox W000458 | sen | NH | 1842-01-01 | 1843-03-03 | 3 | Democrat | |||||||||||||
5113 | 5113 | William Allen A000150 | sen | OH | 1837-09-04 | 1843-03-03 | 3 | Democrat | |||||||||||||
5115 | 5115 | Archibald Arrington A000302 | rep | NC | 1841-05-31 | 1843-03-03 | Democrat | 6 | |||||||||||||
5118 | 5118 | Arthur Bagby B000030 | sen | AL | 1841-05-31 | 1843-03-03 | 3 | Democrat | |||||||||||||
5121 | 5121 | Osmyn Baker B000071 | rep | MA | 1841-05-31 | 1843-03-03 | Whig | 6 | |||||||||||||
5125 | 5125 | Daniel Barnard B000152 | rep | NY | 1841-05-31 | 1843-03-03 | Whig | 10 | |||||||||||||
5132 | 5132 | Benjamin Bidlack B000445 | rep | PA | 1841-05-31 | 1843-03-03 | Democrat | 15 | |||||||||||||
5135 | 5135 | Edward Black B000494 | rep | GA | 1841-05-31 | 1843-03-03 | Democrat | -1 | |||||||||||||
5145 | 5145 | Aaron Brown B000899 | rep | TN | 1841-05-31 | 1843-03-03 | Democrat | 10 | |||||||||||||
5147 | 5147 | Jeremiah Brown B000925 | rep | PA | 1841-05-31 | 1843-03-03 | Whig | 4 | |||||||||||||
5150 | 5150 | Edmund Burke B001088 | rep | NH | 1841-05-31 | 1843-03-03 | Democrat | -1 | |||||||||||||
5152 | 5152 | Barker Burnell B001114 | rep | MA | 1841-05-31 | 1843-03-03 | Whig | 11 | |||||||||||||
5157 | 5157 | John Campbell C000090 | rep | SC | 1841-05-31 | 1843-03-03 | Democrat | 3 | |||||||||||||
5167 | 5167 | James Clinton C000528 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 6 | |||||||||||||
5172 | 5172 | Walter Coles C000625 | rep | VA | 1841-05-31 | 1843-03-03 | Democrat | 6 | |||||||||||||
5175 | 5175 | Walter Colquitt C000648 | rep | GA | 1841-05-31 | 1843-03-03 | Democrat | -1 | |||||||||||||
5178 | 5178 | Mark Cooper C000759 | rep | GA | 1841-05-31 | 1843-03-03 | Democrat | -1 | |||||||||||||
5181 | 5181 | Edward Cross C000930 | rep | AR | 1841-05-31 | 1843-03-03 | Democrat | 1 | |||||||||||||
5185 | 5185 | Richard Davis D000128 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 5 | |||||||||||||
5187 | 5187 | Ezra Dean D000171 | rep | OH | 1841-05-31 | 1843-03-03 | Democrat | 18 | |||||||||||||
5204 | 5204 | Thomas Gilmer G000218 | rep | VA | 1841-05-31 | 1843-03-03 | Whig | 12 |
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);