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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6098 | 6098 | Harvey Putnam P000580 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 33 | |||||||||||||
6099 | 6099 | Robert Reed R000126 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 20 | |||||||||||||
6101 | 6101 | Gideon Reynolds R000172 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 12 | |||||||||||||
6102 | 6102 | Elijah Risley R000270 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 31 | |||||||||||||
6105 | 6105 | Joseph Root R000433 | rep | OH | 1849-12-03 | 1851-03-03 | Free Soil | 21 | |||||||||||||
6107 | 6107 | Robert Rose R000438 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 29 | |||||||||||||
6109 | 6109 | David Rumsey R000506 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 30 | |||||||||||||
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 | |||||||||||||
6122 | 6122 | Augustine Shepperd S000338 | rep | NC | 1849-12-03 | 1851-03-03 | Whig | 4 | |||||||||||||
6124 | 6124 | Peter Silvester S000413 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 11 | |||||||||||||
6132 | 6132 | William Sprague S000745 | rep | MI | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
6133 | 6133 | Charles Stetson S000873 | rep | ME | 1849-12-03 | 1851-03-03 | Democrat | 6 | |||||||||||||
6134 | 6134 | David Stewart S000905 | sen | MD | 1849-12-03 | 1851-03-03 | 1 | Whig | |||||||||||||
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 | |||||||||||||
6148 | 6148 | John Thurman T000252 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 15 | |||||||||||||
6149 | 6149 | Samuel Thurston T000258 | rep | OR | 1849-12-03 | 1851-03-03 | Democrat | -1 | |||||||||||||
6150 | 6150 | Walter Underhill U000009 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 4 | |||||||||||||
6154 | 6154 | John Van Dyke V000035 | rep | NJ | 1849-12-03 | 1851-03-03 | Whig | 4 | |||||||||||||
6165 | 6165 | Samuel Vinton V000107 | rep | OH | 1849-12-03 | 1851-03-03 | Whig | 12 | |||||||||||||
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 | |||||||||||||
6168 | 6168 | John Wales W000043 | sen | DE | 1849-12-03 | 1851-03-03 | 1 | Whig | |||||||||||||
6169 | 6169 | Marshall Wellborn W000271 | rep | GA | 1849-12-03 | 1851-03-03 | Democrat | 2 | |||||||||||||
6173 | 6173 | Hugh White W000375 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 16 | |||||||||||||
6174 | 6174 | William Whittlesey W000434 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 13 | |||||||||||||
6176 | 6176 | James Wilson W000587 | rep | NH | 1849-12-03 | 1851-03-03 | Whig | 3 | |||||||||||||
6177 | 6177 | Amos Wood W000689 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 6 | |||||||||||||
6178 | 6178 | George Wright W000760 | rep | CA | 1849-12-03 | 1851-03-03 | Independent | -1 | |||||||||||||
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 | |||||||||||||
6187 | 6187 | Thomas Ewing E000281 | sen | OH | 1850-01-01 | 1851-03-03 | 1 | Whig | |||||||||||||
6188 | 6188 | John Frémont F000374 | sen | CA | 1850-01-01 | 1851-03-03 | 1 | Democrat | |||||||||||||
6189 | 6189 | Thomas Pratt P000506 | sen | MD | 1850-01-12 | 1851-03-03 | 1 | Ind. Republican-Democrat | |||||||||||||
6203 | 6203 | Robert Winthrop W000646 | sen | MA | 1850-01-01 | 1851-03-03 | 1 | Whig | |||||||||||||
6208 | 6208 | Charles Allen A000115 | rep | MA | 1849-12-03 | 1851-03-03 | Free Soil | 5 | |||||||||||||
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 | |||||||||||||
6223 | 6223 | Richard Bowie B000694 | rep | MD | 1849-12-03 | 1851-03-03 | Whig | 1 | |||||||||||||
6234 | 6234 | Lorenzo Burrows B001143 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 34 | |||||||||||||
6239 | 6239 | Armistead Burt B001145 | rep | SC | 1849-12-03 | 1851-03-03 | Democrat | 5 | |||||||||||||
6244 | 6244 | Edward Cabell C000003 | rep | FL | 1849-12-03 | 1851-03-03 | Whig | 1 | |||||||||||||
6246 | 6246 | Joseph Cable C000008 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 17 | |||||||||||||
6248 | 6248 | Joseph Caldwell C000037 | rep | NC | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
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 | |||||||||||||
6284 | 6284 | James Duncan D000532 | rep | MA | 1849-12-03 | 1851-03-03 | Whig | 3 | |||||||||||||
6287 | 6287 | Alexander Evans E000231 | rep | MD | 1849-12-03 | 1851-03-03 | Whig | 5 | |||||||||||||
6299 | 6299 | Orin Fowler F000325 | rep | MA | 1849-12-03 | 1851-03-03 | Whig | 9 | |||||||||||||
6307 | 6307 | Meredith Gentry G000125 | rep | TN | 1849-12-03 | 1851-03-03 | Whig | 7 | |||||||||||||
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 | |||||||||||||
6327 | 6327 | William Hebard H000435 | rep | VT | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
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 | |||||||||||||
6334 | 6334 | John Howe H000853 | rep | PA | 1849-12-03 | 1851-03-03 | Free Soil | 22 | |||||||||||||
6337 | 6337 | William Hunter H000992 | rep | OH | 1849-12-03 | 1851-03-03 | Whig | 15 | |||||||||||||
6340 | 6340 | Joseph Jackson J000023 | rep | GA | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
6349 | 6349 | George King K000201 | rep | RI | 1849-12-03 | 1851-03-03 | Whig | 1 | |||||||||||||
6355 | 6355 | Horace Mann M000102 | rep | MA | 1849-12-03 | 1851-03-03 | Whig | 8 | |||||||||||||
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 | |||||||||||||
6367 | 6367 | Henry Moore M000900 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 3 | |||||||||||||
6378 | 6378 | David Outlaw O000138 | rep | NC | 1849-12-03 | 1851-03-03 | Whig | 9 | |||||||||||||
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 | |||||||||||||
6404 | 6404 | William Sackett S000007 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 27 | |||||||||||||
6406 | 6406 | Abraham Schermerhorn S000122 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 28 | |||||||||||||
6408 | 6408 | John Schoolcraft S000139 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 13 | |||||||||||||
6415 | 6415 | Henry Sibley S000396 | rep | MN | 1849-12-03 | 1851-03-03 | -1 | ||||||||||||||
6423 | 6423 | Edward Stanly S000799 | rep | NC | 1849-12-03 | 1851-03-03 | Whig | 8 | |||||||||||||
6431 | 6431 | Charles Sweetser S001111 | rep | OH | 1849-12-03 | 1851-03-03 | Democrat | 10 | |||||||||||||
6438 | 6438 | Amos Tuck T000394 | rep | NH | 1849-12-03 | 1851-03-03 | Free Soil | 1 | |||||||||||||
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 | |||||||||||||
6459 | 6459 | Christopher Williams W000493 | rep | TN | 1849-12-03 | 1851-03-03 | Whig | 11 | |||||||||||||
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 | |||||||||||||
6535 | 6535 | Joseph Chandler C000292 | rep | PA | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
6554 | 6554 | Moses Corwin C000790 | rep | OH | 1849-12-03 | 1851-03-03 | Whig | 4 |
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);