legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
273 rows where "end" is on date 1851-03-03 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: state, class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6415 | 6415 | Henry Sibley S000396 | rep | MN | 1849-12-03 | 1851-03-03 | -1 | ||||||||||||||
6045 | 6045 | Lewis Levin L000262 | rep | PA | 1849-12-03 | 1851-03-03 | American | 1 | |||||||||||||
5338 | 5338 | Daniel Dickinson D000317 | sen | NY | 1845-03-04 | 1851-03-03 | 1 | Democrat | |||||||||||||
5535 | 5535 | Daniel Sturgeon S001046 | sen | PA | 1845-12-01 | 1851-03-03 | 1 | Democrat | |||||||||||||
5554 | 5554 | Hopkins Turney T000430 | sen | TN | 1845-12-01 | 1851-03-03 | 1 | Democrat | |||||||||||||
5641 | 5641 | John Calhoun C000044 | sen | SC | 1847-12-06 | 1851-03-03 | 2 | Democrat | |||||||||||||
5889 | 5889 | Nathaniel Albertson A000075 | rep | IN | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
5901 | 5901 | William Bay B000247 | rep | MO | 1849-12-03 | 1851-03-03 | Democrat | 2 | |||||||||||||
5907 | 5907 | Franklin Bowdon B000680 | rep | AL | 1849-12-03 | 1851-03-03 | Democrat | 7 | |||||||||||||
5911 | 5911 | James Bowlin B000701 | rep | MO | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
5913 | 5913 | John Brisbin B000841 | rep | PA | 1849-12-03 | 1851-03-03 | Democrat | 11 | |||||||||||||
5915 | 5915 | William Brown B000950 | rep | IN | 1849-12-03 | 1851-03-03 | Democrat | 5 | |||||||||||||
5916 | 5916 | Alexander Buel B001037 | rep | MI | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
5924 | 5924 | George Caldwell C000031 | rep | KY | 1849-12-03 | 1851-03-03 | Democrat | 4 | |||||||||||||
5951 | 5951 | Joel Danner D000045 | rep | PA | 1849-12-03 | 1851-03-03 | Democrat | 15 | |||||||||||||
5967 | 5967 | Rodolphus Dickinson D000325 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 6 | |||||||||||||
5973 | 5973 | Andrew Ewing E000275 | rep | TN | 1849-12-03 | 1851-03-03 | Democrat | 8 | |||||||||||||
5975 | 5975 | Winfield Featherston F000055 | rep | MS | 1849-12-03 | 1851-03-03 | Democrat | 2 | |||||||||||||
5978 | 5978 | Elbridge Gerry G000138 | rep | ME | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
5979 | 5979 | Edward Gilbert G000172 | rep | CA | 1849-12-03 | 1851-03-03 | Democrat | -1 | |||||||||||||
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 | |||||||||||||
5998 | 5998 | John Harmanson H000214 | rep | LA | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
6006 | 6006 | Moses Hoagland H000651 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 16 | |||||||||||||
6012 | 6012 | Isaac Holmes H000738 | rep | SC | 1849-12-03 | 1851-03-03 | Democrat | 6 | |||||||||||||
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 | |||||||||||||
6024 | 6024 | David Kaufman K000021 | rep | TX | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
6039 | 6039 | Emile La Sére L000008 | rep | LA | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
6042 | 6042 | Shepherd Leffler L000215 | rep | IA | 1849-12-03 | 1851-03-03 | Democrat | 2 | |||||||||||||
6047 | 6047 | Nathaniel Littlefield L000356 | rep | ME | 1849-12-03 | 1851-03-03 | Democrat | 2 | |||||||||||||
6050 | 6050 | Job Mann M000106 | rep | PA | 1849-12-03 | 1851-03-03 | Democrat | 19 | |||||||||||||
6057 | 6057 | James McDowell M000419 | rep | VA | 1849-12-03 | 1851-03-03 | Democrat | 11 | |||||||||||||
6062 | 6062 | William McWillie M000612 | rep | MS | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
6065 | 6065 | John Miller M000742 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 11 | |||||||||||||
6069 | 6069 | Jonathan Morris M000979 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 7 | |||||||||||||
6073 | 6073 | Isaac Morse M001011 | rep | LA | 1849-12-03 | 1851-03-03 | Democrat | 4 | |||||||||||||
6081 | 6081 | Alexander Newman N000070 | rep | VA | 1849-12-03 | 1851-03-03 | Democrat | 15 | |||||||||||||
6088 | 6088 | Richard Parker P000068 | rep | VA | 1849-12-03 | 1851-03-03 | Democrat | 10 | |||||||||||||
6090 | 6090 | Lucius Peck P000178 | rep | VT | 1849-12-03 | 1851-03-03 | Democrat | 4 | |||||||||||||
6095 | 6095 | Emery Potter P000464 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 5 | |||||||||||||
6111 | 6111 | Cullen Sawtelle S000085 | rep | ME | 1849-12-03 | 1851-03-03 | Democrat | 5 | |||||||||||||
6113 | 6113 | James Seddon S000220 | rep | VA | 1849-12-03 | 1851-03-03 | Democrat | 6 | |||||||||||||
6133 | 6133 | Charles Stetson S000873 | rep | ME | 1849-12-03 | 1851-03-03 | Democrat | 6 | |||||||||||||
6136 | 6136 | William Strong S001021 | rep | PA | 1849-12-03 | 1851-03-03 | Democrat | 9 | |||||||||||||
6142 | 6142 | Jacob Thompson T000203 | rep | MS | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
6145 | 6145 | James Thompson T000204 | rep | PA | 1849-12-03 | 1851-03-03 | Democrat | 23 | |||||||||||||
6147 | 6147 | William Thompson T000223 | rep | IA | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
6149 | 6149 | Samuel Thurston T000258 | rep | OR | 1849-12-03 | 1851-03-03 | Democrat | -1 | |||||||||||||
6166 | 6166 | Hiram Walden W000033 | rep | NY | 1849-12-03 | 1851-03-03 | Democrat | 21 | |||||||||||||
6167 | 6167 | Loren Waldo W000037 | rep | CT | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
6169 | 6169 | Marshall Wellborn W000271 | rep | GA | 1849-12-03 | 1851-03-03 | Democrat | 2 | |||||||||||||
6174 | 6174 | William Whittlesey W000434 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 13 | |||||||||||||
6177 | 6177 | Amos Wood W000689 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 6 | |||||||||||||
6179 | 6179 | Timothy Young Y000055 | rep | IL | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
6182 | 6182 | Robert Barnwell B000168 | sen | SC | 1850-01-01 | 1851-03-03 | 2 | Democrat | |||||||||||||
6185 | 6185 | Franklin Elmore E000158 | sen | SC | 1850-01-01 | 1851-03-03 | 2 | Democrat | |||||||||||||
6188 | 6188 | John Frémont F000374 | sen | CA | 1850-01-01 | 1851-03-03 | 1 | Democrat | |||||||||||||
6212 | 6212 | Thomas Averett A000343 | rep | VA | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
6219 | 6219 | James Beale B000266 | rep | VA | 1849-12-03 | 1851-03-03 | Democrat | 14 | |||||||||||||
6239 | 6239 | Armistead Burt B001145 | rep | SC | 1849-12-03 | 1851-03-03 | Democrat | 5 | |||||||||||||
6246 | 6246 | Joseph Cable C000008 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 17 | |||||||||||||
6251 | 6251 | David Cartter C000206 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 18 | |||||||||||||
6254 | 6254 | Lewis Cass C000233 | sen | MI | 1849-12-03 | 1851-03-03 | 1 | Democrat | |||||||||||||
6258 | 6258 | Chauncey Cleveland C000511 | rep | CT | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
6260 | 6260 | William Colcock C000603 | rep | SC | 1849-12-03 | 1851-03-03 | Democrat | 7 | |||||||||||||
6268 | 6268 | John Daniel D000034 | rep | NC | 1849-12-03 | 1851-03-03 | Democrat | 6 | |||||||||||||
6272 | 6272 | Milo Dimmick D000350 | rep | PA | 1849-12-03 | 1851-03-03 | Democrat | 10 | |||||||||||||
6278 | 6278 | Henry Dodge D000396 | sen | WI | 1848-01-01 | 1851-03-03 | 1 | Democrat | |||||||||||||
6282 | 6282 | James Doty D000443 | rep | WI | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
6310 | 6310 | Alfred Gilmore G000220 | rep | PA | 1849-12-03 | 1851-03-03 | Democrat | 24 | |||||||||||||
6313 | 6313 | Willis Gorman G000330 | rep | IN | 1849-12-03 | 1851-03-03 | Democrat | 6 | |||||||||||||
6316 | 6316 | Willard Hall H000077 | rep | MO | 1849-12-03 | 1851-03-03 | Democrat | 4 | |||||||||||||
6318 | 6318 | Edward Hammond H000126 | rep | MD | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
6329 | 6329 | Alexander Holladay H000714 | rep | VA | 1849-12-03 | 1851-03-03 | Democrat | 8 | |||||||||||||
6332 | 6332 | Volney Howard H000845 | rep | TX | 1849-12-03 | 1851-03-03 | Democrat | 2 | |||||||||||||
6340 | 6340 | Joseph Jackson J000023 | rep | GA | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
6360 | 6360 | James McLanahan M000534 | rep | PA | 1849-12-03 | 1851-03-03 | Democrat | 16 | |||||||||||||
6363 | 6363 | Richard Meade M000618 | rep | VA | 1849-12-03 | 1851-03-03 | Democrat | 2 | |||||||||||||
6382 | 6382 | Charles Peaslee P000173 | rep | NH | 1849-12-03 | 1851-03-03 | Democrat | 2 | |||||||||||||
6384 | 6384 | Alexander Penn P000210 | rep | LA | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
6390 | 6390 | Robert Rantoul R000063 | sen | MA | 1851-02-01 | 1851-03-03 | 1 | Democrat | |||||||||||||
6395 | 6395 | John Robinson R000343 | rep | IN | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
6397 | 6397 | Thomas Ross R000455 | rep | PA | 1849-12-03 | 1851-03-03 | Democrat | 6 | |||||||||||||
6399 | 6399 | Thomas Rusk R000518 | sen | TX | 1846-01-01 | 1851-03-03 | 1 | Democrat | |||||||||||||
6431 | 6431 | Charles Sweetser S001111 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 10 | |||||||||||||
6441 | 6441 | Abraham Venable V000084 | rep | NC | 1849-12-03 | 1851-03-03 | Democrat | 5 | |||||||||||||
6445 | 6445 | Daniel Wallace W000075 | rep | SC | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
6454 | 6454 | Isaac Wildrick W000464 | rep | NJ | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
6464 | 6464 | Joseph Woodward W000732 | rep | SC | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
6491 | 6491 | William Ashe A000310 | rep | NC | 1849-12-03 | 1851-03-03 | Democrat | 7 | |||||||||||||
6516 | 6516 | Thomas Benton B000398 | sen | MO | 1845-12-01 | 1851-03-03 | 1 | Democrat | |||||||||||||
6518 | 6518 | William Bissell B000492 | rep | IL | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
6528 | 6528 | Linn Boyd B000719 | rep | KY | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
6566 | 6566 | David Disney D000361 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
6608 | 6608 | Harry Hibbard H000557 | rep | NH | 1849-12-03 | 1851-03-03 | Democrat | 4 | |||||||||||||
6653 | 6653 | George Morrison M000994 | rep | NH | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
6659 | 6659 | Edson Olds O000063 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 9 |
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);