legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
266 rows where "start" is on date 1849-12-03 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: state, end, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5891 | 5891 | William Alston A000166 | rep | AL | 1849-12-03 | 1851-03-03 | Whig | 1 | |||||||||||||
5907 | 5907 | Franklin Bowdon B000680 | rep | AL | 1849-12-03 | 1851-03-03 | Democrat | 7 | |||||||||||||
5940 | 5940 | Jeremiah Clemens C000501 | sen | AL | 1849-12-03 | 1853-03-03 | 2 | Democrat | |||||||||||||
6005 | 6005 | Henry Hilliard H000622 | rep | AL | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
6017 | 6017 | David Hubbard H000880 | rep | AL | 1849-12-03 | 1851-03-03 | Democrat | 5 | |||||||||||||
6019 | 6019 | Samuel Inge I000013 | rep | AL | 1849-12-03 | 1851-03-03 | Democrat | 4 | |||||||||||||
6828 | 6828 | Sampson Harris H000252 | rep | AL | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
7348 | 7348 | Williamson Cobb C000554 | rep | AL | 1849-12-03 | 1851-03-03 | Democrat | 6 | |||||||||||||
6846 | 6846 | Robert Johnson J000172 | rep | AR | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
5979 | 5979 | Edward Gilbert G000172 | rep | CA | 1849-12-03 | 1851-03-03 | Democrat | -1 | |||||||||||||
6178 | 6178 | George Wright W000760 | rep | CA | 1849-12-03 | 1851-03-03 | Independent | -1 | |||||||||||||
8602 | 8602 | Abijah Gilbert G000171 | rep | CA | 1849-12-03 | 1851-03-03 | Democrat | -1 | |||||||||||||
5904 | 5904 | Walter Booth B000631 | rep | CT | 1849-12-03 | 1851-03-03 | Free Soil | 2 | |||||||||||||
5922 | 5922 | Thomas Butler B001191 | rep | CT | 1849-12-03 | 1851-03-03 | Whig | 4 | |||||||||||||
6129 | 6129 | Truman Smith S000621 | sen | CT | 1849-12-03 | 1855-03-03 | 3 | Whig | |||||||||||||
6167 | 6167 | Loren Waldo W000037 | rep | CT | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
6258 | 6258 | Chauncey Cleveland C000511 | rep | CT | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
6015 | 6015 | John Houston H000825 | rep | DE | 1849-12-03 | 1851-03-03 | Whig | 0 | |||||||||||||
6168 | 6168 | John Wales W000043 | sen | DE | 1849-12-03 | 1851-03-03 | 1 | Whig | |||||||||||||
6074 | 6074 | Jackson Morton M001015 | sen | FL | 1849-12-03 | 1855-03-03 | 3 | Whig | |||||||||||||
6244 | 6244 | Edward Cabell C000003 | rep | FL | 1849-12-03 | 1851-03-03 | Whig | 1 | |||||||||||||
5956 | 5956 | William Dawson D000156 | sen | GA | 1849-12-03 | 1855-03-03 | 3 | Whig | |||||||||||||
5988 | 5988 | Thomas Hackett H000005 | rep | GA | 1849-12-03 | 1851-03-03 | Democrat | 5 | |||||||||||||
5995 | 5995 | Hugh Haralson H000178 | rep | GA | 1849-12-03 | 1851-03-03 | Democrat | 4 | |||||||||||||
6036 | 6036 | Thomas King K000215 | rep | GA | 1849-12-03 | 1851-03-03 | Whig | 1 | |||||||||||||
6087 | 6087 | Allen Owen O000148 | rep | GA | 1849-12-03 | 1851-03-03 | Whig | 3 | |||||||||||||
6169 | 6169 | Marshall Wellborn W000271 | rep | GA | 1849-12-03 | 1851-03-03 | Democrat | 2 | |||||||||||||
6340 | 6340 | Joseph Jackson J000023 | rep | GA | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
6791 | 6791 | Howell Cobb C000548 | rep | GA | 1849-12-03 | 1851-03-03 | Democrat | 6 | |||||||||||||
7611 | 7611 | Robert Toombs T000313 | rep | GA | 1849-12-03 | 1851-03-03 | Whig | 8 | |||||||||||||
10552 | 10552 | Alexander Stephens S000854 | rep | GA | 1849-12-03 | 1851-03-03 | Whig | 7 | |||||||||||||
6042 | 6042 | Shepherd Leffler L000215 | rep | IA | 1849-12-03 | 1851-03-03 | Democrat | 2 | |||||||||||||
6063 | 6063 | Daniel Miller M000721 | rep | IA | 1849-12-03 | 1851-03-03 | Whig | 1 | |||||||||||||
6147 | 6147 | William Thompson T000223 | rep | IA | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
6179 | 6179 | Timothy Young Y000055 | rep | IL | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
6518 | 6518 | William Bissell B000492 | rep | IL | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
7084 | 7084 | Thomas Harris H000255 | rep | IL | 1849-12-03 | 1851-03-03 | Democrat | 7 | |||||||||||||
7643 | 7643 | Edward Baker B000059 | rep | IL | 1849-12-03 | 1851-03-03 | Whig | 6 | |||||||||||||
7792 | 7792 | John McClernand M000337 | rep | IL | 1849-12-03 | 1851-03-03 | Democrat | 2 | |||||||||||||
8023 | 8023 | William Richardson R000228 | rep | IL | 1849-12-03 | 1851-03-03 | Democrat | 5 | |||||||||||||
8227 | 8227 | John Wentworth W000295 | rep | IL | 1849-12-03 | 1851-03-03 | Democrat | 4 | |||||||||||||
10188 | 10188 | James Shields S000362 | sen | IL | 1849-12-03 | 1855-03-03 | 3 | Democrat | |||||||||||||
5889 | 5889 | Nathaniel Albertson A000075 | rep | IN | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
5915 | 5915 | William Brown B000950 | rep | IN | 1849-12-03 | 1851-03-03 | Democrat | 5 | |||||||||||||
6059 | 6059 | Edward McGaughey M000443 | rep | IN | 1849-12-03 | 1851-03-03 | Whig | 7 | |||||||||||||
6170 | 6170 | James Whitcomb W000349 | sen | IN | 1849-12-03 | 1853-03-03 | 3 | Democrat | |||||||||||||
6313 | 6313 | Willis Gorman G000330 | rep | IN | 1849-12-03 | 1851-03-03 | Democrat | 6 | |||||||||||||
6395 | 6395 | John Robinson R000343 | rep | IN | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
6571 | 6571 | Cyrus Dunham D000540 | rep | IN | 1849-12-03 | 1851-03-03 | Democrat | 2 | |||||||||||||
6602 | 6602 | Andrew Harlan H000208 | rep | IN | 1849-12-03 | 1851-03-03 | Democrat | 10 | |||||||||||||
7044 | 7044 | Graham Fitch F000158 | rep | IN | 1849-12-03 | 1851-03-03 | Democrat | 9 | |||||||||||||
8648 | 8648 | George Julian J000280 | rep | IN | 1849-12-03 | 1851-03-03 | Free Soil | 4 | |||||||||||||
9581 | 9581 | Joseph McDonald M000412 | rep | IN | 1849-12-03 | 1851-03-03 | Democrat | 8 | |||||||||||||
5912 | 5912 | Daniel Breck B000782 | rep | KY | 1849-12-03 | 1851-03-03 | Whig | 6 | |||||||||||||
5924 | 5924 | George Caldwell C000031 | rep | KY | 1849-12-03 | 1851-03-03 | Democrat | 4 | |||||||||||||
5939 | 5939 | Henry Clay C000482 | sen | KY | 1849-12-03 | 1853-03-03 | 3 | Whig | |||||||||||||
6021 | 6021 | James Johnson J000147 | rep | KY | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
6061 | 6061 | Finis McLean M000546 | rep | KY | 1849-12-03 | 1851-03-03 | Whig | 3 | |||||||||||||
6067 | 6067 | Charles Morehead M000936 | rep | KY | 1849-12-03 | 1851-03-03 | Whig | 8 | |||||||||||||
6528 | 6528 | Linn Boyd B000719 | rep | KY | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
6702 | 6702 | Richard Stanton S000806 | rep | KY | 1849-12-03 | 1851-03-03 | Democrat | 10 | |||||||||||||
6723 | 6723 | John Thompson T000208 | rep | KY | 1849-12-03 | 1851-03-03 | Whig | 5 | |||||||||||||
7141 | 7141 | Humphrey Marshall M000154 | rep | KY | 1849-12-03 | 1851-03-03 | Whig | 7 | |||||||||||||
7149 | 7149 | John Mason M000218 | rep | KY | 1849-12-03 | 1851-03-03 | Democrat | 9 | |||||||||||||
5919 | 5919 | Henry Bullard B001049 | rep | LA | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
5945 | 5945 | Charles Conrad C000703 | rep | LA | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
5998 | 5998 | John Harmanson H000214 | rep | LA | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
6039 | 6039 | Emile La Sére L000008 | rep | LA | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
6073 | 6073 | Isaac Morse M001011 | rep | LA | 1849-12-03 | 1851-03-03 | Democrat | 4 | |||||||||||||
6131 | 6131 | Pierre Soulé S000682 | sen | LA | 1849-12-03 | 1853-12-31 | 3 | Democrat | |||||||||||||
6384 | 6384 | Alexander Penn P000210 | rep | LA | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
5896 | 5896 | George Ashmun A000318 | rep | MA | 1849-12-03 | 1851-03-03 | Whig | 6 | |||||||||||||
5970 | 5970 | Samuel Eliot E000105 | rep | MA | 1849-12-03 | 1851-03-03 | Whig | 1 | |||||||||||||
5987 | 5987 | Joseph Grinnell G000477 | rep | MA | 1849-12-03 | 1851-03-03 | Whig | 10 | |||||||||||||
6029 | 6029 | Daniel King K000198 | rep | MA | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
6208 | 6208 | Charles Allen A000115 | rep | MA | 1849-12-03 | 1851-03-03 | Free Soil | 5 | |||||||||||||
6284 | 6284 | James Duncan D000532 | rep | MA | 1849-12-03 | 1851-03-03 | Whig | 3 | |||||||||||||
6299 | 6299 | Orin Fowler F000325 | rep | MA | 1849-12-03 | 1851-03-03 | Whig | 9 | |||||||||||||
6355 | 6355 | Horace Mann M000102 | rep | MA | 1849-12-03 | 1851-03-03 | Whig | 8 | |||||||||||||
6748 | 6748 | Julius Rockwell R000368 | rep | MA | 1849-12-03 | 1851-03-03 | Whig | 7 | |||||||||||||
6025 | 6025 | John Kerr K000137 | rep | MD | 1849-12-03 | 1851-03-03 | Whig | 6 | |||||||||||||
6134 | 6134 | David Stewart S000905 | sen | MD | 1849-12-03 | 1851-03-03 | 1 | Whig | |||||||||||||
6223 | 6223 | Richard Bowie B000694 | rep | MD | 1849-12-03 | 1851-03-03 | Whig | 1 | |||||||||||||
6287 | 6287 | Alexander Evans E000231 | rep | MD | 1849-12-03 | 1851-03-03 | Whig | 5 | |||||||||||||
6318 | 6318 | Edward Hammond H000126 | rep | MD | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
7824 | 7824 | James Pearce P000161 | sen | MD | 1849-12-03 | 1855-03-03 | 3 | Whig | |||||||||||||
8616 | 8616 | William Hamilton H000118 | rep | MD | 1849-12-03 | 1851-03-03 | Democrat | 2 | |||||||||||||
10458 | 10458 | Robert McLane M000537 | rep | MD | 1849-12-03 | 1851-03-03 | Democrat | 4 | |||||||||||||
5978 | 5978 | Elbridge Gerry G000138 | rep | ME | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
5980 | 5980 | Rufus Goodenow G000285 | rep | ME | 1849-12-03 | 1851-03-03 | Whig | 4 | |||||||||||||
6047 | 6047 | Nathaniel Littlefield L000356 | rep | ME | 1849-12-03 | 1851-03-03 | Democrat | 2 | |||||||||||||
6086 | 6086 | John Otis O000128 | rep | ME | 1849-12-03 | 1851-03-03 | Whig | 3 | |||||||||||||
6111 | 6111 | Cullen Sawtelle S000085 | rep | ME | 1849-12-03 | 1851-03-03 | Democrat | 5 | |||||||||||||
6133 | 6133 | Charles Stetson S000873 | rep | ME | 1849-12-03 | 1851-03-03 | Democrat | 6 | |||||||||||||
6820 | 6820 | Thomas Fuller F000412 | rep | ME | 1849-12-03 | 1851-03-03 | Democrat | 7 | |||||||||||||
5916 | 5916 | Alexander Buel B001037 | rep | MI | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
6132 | 6132 | William Sprague S000745 | rep | MI | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
6254 | 6254 | Lewis Cass C000233 | sen | MI | 1849-12-03 | 1851-03-03 | 1 | Democrat | |||||||||||||
7293 | 7293 | Kinsley Bingham B000473 | rep | MI | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
6415 | 6415 | Henry Sibley S000396 | rep | MN | 1849-12-03 | 1851-03-03 | -1 |
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);