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 rss_url
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5616 | 5616 | John Berrien B000413 | sen | GA | 1847-12-06 | 1853-03-03 | 2 | Whig | |||||||||||||
5627 | 5627 | James Bradbury B000734 | sen | ME | 1847-12-06 | 1853-03-03 | 2 | Democrat | |||||||||||||
5650 | 5650 | John Clarke C000466 | sen | RI | 1847-12-06 | 1853-03-03 | 2 | Whig | |||||||||||||
5670 | 5670 | John Davis D000117 | sen | MA | 1847-12-06 | 1853-03-03 | 2 | Whig | |||||||||||||
5674 | 5674 | Solomon Downs D000476 | sen | LA | 1847-12-06 | 1853-03-03 | 2 | Democrat | |||||||||||||
5691 | 5691 | Alpheus Felch F000063 | sen | MI | 1847-12-06 | 1853-03-03 | 2 | Democrat | |||||||||||||
5694 | 5694 | Henry Foote F000251 | sen | MS | 1847-12-06 | 1853-03-03 | 2 | Democrat | |||||||||||||
5773 | 5773 | Willie Mangum M000096 | sen | NC | 1847-12-06 | 1853-03-03 | 2 | Whig | |||||||||||||
5794 | 5794 | Jacob Miller M000731 | sen | NJ | 1847-12-06 | 1853-03-03 | 2 | Whig | |||||||||||||
5825 | 5825 | Presley Spruance S000760 | sen | DE | 1847-12-06 | 1853-03-03 | 2 | Whig | |||||||||||||
5852 | 5852 | Joseph Underwood U000011 | sen | KY | 1847-12-06 | 1853-03-03 | 2 | Whig | |||||||||||||
5939 | 5939 | Henry Clay C000482 | sen | KY | 1849-12-03 | 1853-03-03 | 3 | Whig | |||||||||||||
5940 | 5940 | Jeremiah Clemens C000501 | sen | AL | 1849-12-03 | 1853-03-03 | 2 | Democrat | |||||||||||||
6170 | 6170 | James Whitcomb W000349 | sen | IN | 1849-12-03 | 1853-03-03 | 3 | Democrat | |||||||||||||
6197 | 6197 | Robert Rhett R000184 | sen | SC | 1850-01-01 | 1853-03-03 | 2 | Democrat | |||||||||||||
6209 | 6209 | Charles Allen A000115 | rep | MA | 1851-12-01 | 1853-03-03 | Free Soil | 5 | |||||||||||||
6210 | 6210 | Charles Andrews A000243 | rep | ME | 1851-12-01 | 1853-03-03 | Democrat | 4 | |||||||||||||
6211 | 6211 | John Appleton A000268 | rep | ME | 1851-12-01 | 1853-03-03 | Democrat | 2 | |||||||||||||
6213 | 6213 | Thomas Averett A000343 | rep | VA | 1851-12-01 | 1853-03-03 | Democrat | 3 | |||||||||||||
6214 | 6214 | Leander Babcock B000005 | rep | NY | 1851-12-01 | 1853-03-03 | Democrat | 23 | |||||||||||||
6215 | 6215 | Nelson Barrere B000174 | rep | OH | 1851-12-01 | 1853-03-03 | Whig | 7 | |||||||||||||
6216 | 6216 | Thomas Bartlett B000209 | rep | VT | 1851-12-01 | 1853-03-03 | Democrat | 4 | |||||||||||||
6220 | 6220 | James Beale B000266 | rep | VA | 1851-12-01 | 1853-03-03 | Democrat | 14 | |||||||||||||
6221 | 6221 | Hiram Bell B000335 | rep | OH | 1851-12-01 | 1853-03-03 | Whig | 3 | |||||||||||||
6222 | 6222 | Thomas Bibighaus B000435 | rep | PA | 1851-12-01 | 1853-03-03 | Whig | 14 | |||||||||||||
6224 | 6224 | Richard Bowie B000694 | rep | MD | 1851-12-01 | 1853-03-03 | Whig | 1 | |||||||||||||
6225 | 6225 | Obadiah Bowne B000707 | rep | NY | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
6226 | 6226 | John Boyd B000718 | rep | NY | 1851-12-01 | 1853-03-03 | Whig | 14 | |||||||||||||
6227 | 6227 | John Bragg B000758 | rep | AL | 1851-12-01 | 1853-03-03 | Democrat | 1 | |||||||||||||
6232 | 6232 | George Brown B000920 | rep | NJ | 1851-12-01 | 1853-03-03 | Whig | 4 | |||||||||||||
6233 | 6233 | Alexander Buell B001038 | rep | NY | 1851-12-01 | 1853-03-03 | Democrat | 17 | |||||||||||||
6235 | 6235 | Lorenzo Burrows B001143 | rep | NY | 1851-12-01 | 1853-03-03 | Whig | 34 | |||||||||||||
6240 | 6240 | Armistead Burt B001145 | rep | SC | 1851-12-01 | 1853-03-03 | Democrat | 5 | |||||||||||||
6241 | 6241 | George Busby B001162 | rep | OH | 1851-12-01 | 1853-03-03 | Democrat | 11 | |||||||||||||
6245 | 6245 | Edward Cabell C000003 | rep | FL | 1851-12-01 | 1853-03-03 | Whig | 1 | |||||||||||||
6247 | 6247 | Joseph Cable C000008 | rep | OH | 1851-12-01 | 1853-03-03 | Democrat | 17 | |||||||||||||
6249 | 6249 | Joseph Caldwell C000037 | rep | NC | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
6250 | 6250 | Thompson Campbell C000102 | rep | IL | 1851-12-01 | 1853-03-03 | Democrat | 6 | |||||||||||||
6252 | 6252 | David Cartter C000206 | rep | OH | 1851-12-01 | 1853-03-03 | Democrat | 18 | |||||||||||||
6256 | 6256 | Charles Chapman C000310 | rep | CT | 1851-12-01 | 1853-03-03 | Whig | 1 | |||||||||||||
6257 | 6257 | Lincoln Clark C000445 | rep | IA | 1851-12-01 | 1853-03-03 | Democrat | 2 | |||||||||||||
6259 | 6259 | Chauncey Cleveland C000511 | rep | CT | 1851-12-01 | 1853-03-03 | Democrat | 3 | |||||||||||||
6261 | 6261 | William Colcock C000603 | rep | SC | 1851-12-01 | 1853-03-03 | Democrat | 7 | |||||||||||||
6262 | 6262 | James Conger C000677 | rep | MI | 1851-12-01 | 1853-03-03 | Whig | 3 | |||||||||||||
6263 | 6263 | Joseph Cottman C000800 | rep | MD | 1851-12-01 | 1853-03-03 | Ind. Whig | 6 | |||||||||||||
6269 | 6269 | John Daniel D000034 | rep | NC | 1851-12-01 | 1853-03-03 | Democrat | 6 | |||||||||||||
6270 | 6270 | John Darby D000049 | rep | MO | 1851-12-01 | 1853-03-03 | Whig | 1 | |||||||||||||
6271 | 6271 | George Davis D000101 | rep | MA | 1851-12-01 | 1853-03-03 | Whig | 6 | |||||||||||||
6273 | 6273 | Milo Dimmick D000350 | rep | PA | 1851-12-01 | 1853-03-03 | Democrat | 10 | |||||||||||||
6275 | 6275 | Alfred Dockery D000385 | rep | NC | 1851-12-01 | 1853-03-03 | Whig | 3 | |||||||||||||
6283 | 6283 | James Doty D000443 | rep | WI | 1851-12-01 | 1853-03-03 | Ind. Democrat | 3 | |||||||||||||
6285 | 6285 | James Duncan D000532 | rep | MA | 1851-12-01 | 1853-03-03 | Whig | 3 | |||||||||||||
6288 | 6288 | Alexander Evans E000231 | rep | MD | 1851-12-01 | 1853-03-03 | Whig | 5 | |||||||||||||
6289 | 6289 | Francis Fay F000050 | rep | MA | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
6293 | 6293 | Orlando Ficklin F000101 | rep | IL | 1851-12-01 | 1853-03-03 | Democrat | 3 | |||||||||||||
6298 | 6298 | John Floyd F000223 | rep | NY | 1851-12-01 | 1853-03-03 | Democrat | 1 | |||||||||||||
6300 | 6300 | Orin Fowler F000325 | rep | MA | 1851-12-01 | 1853-03-03 | Whig | 9 | |||||||||||||
6301 | 6301 | John Freeman F000363 | rep | MS | 1851-12-01 | 1853-03-03 | Unionist | 3 | |||||||||||||
6302 | 6302 | James Gaylord G000108 | rep | OH | 1851-12-01 | 1853-03-03 | Democrat | 13 | |||||||||||||
6308 | 6308 | Meredith Gentry G000125 | rep | TN | 1851-12-01 | 1853-03-03 | Whig | 7 | |||||||||||||
6311 | 6311 | Alfred Gilmore G000220 | rep | PA | 1851-12-01 | 1853-03-03 | Democrat | 24 | |||||||||||||
6312 | 6312 | Robert Goodenow G000284 | rep | ME | 1851-12-01 | 1853-03-03 | Whig | 3 | |||||||||||||
6314 | 6314 | Willis Gorman G000330 | rep | IN | 1851-12-01 | 1853-03-03 | Democrat | 6 | |||||||||||||
6317 | 6317 | Willard Hall H000077 | rep | MO | 1851-12-01 | 1853-03-03 | Democrat | 4 | |||||||||||||
6319 | 6319 | Edward Hammond H000126 | rep | MD | 1851-12-01 | 1853-03-03 | Democrat | 3 | |||||||||||||
6323 | 6323 | Alexander Harper H000219 | rep | OH | 1851-12-01 | 1853-03-03 | Whig | 14 | |||||||||||||
6324 | 6324 | Emanuel Hart H000286 | rep | NY | 1851-12-01 | 1853-03-03 | Democrat | 3 | |||||||||||||
6325 | 6325 | Augustus Hascall H000315 | rep | NY | 1851-12-01 | 1853-03-03 | Whig | 33 | |||||||||||||
6326 | 6326 | John Haws H000380 | rep | NY | 1851-12-01 | 1853-03-03 | Whig | 4 | |||||||||||||
6328 | 6328 | William Hebard H000435 | rep | VT | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
6330 | 6330 | Alexander Holladay H000714 | rep | VA | 1851-12-01 | 1853-03-03 | Democrat | 8 | |||||||||||||
6331 | 6331 | Jerediah Horsford H000796 | rep | NY | 1851-12-01 | 1853-03-03 | Whig | 29 | |||||||||||||
6333 | 6333 | Volney Howard H000845 | rep | TX | 1851-12-01 | 1853-03-03 | Democrat | 2 | |||||||||||||
6335 | 6335 | John Howe H000853 | rep | PA | 1851-12-01 | 1853-03-03 | Whig | 22 | |||||||||||||
6336 | 6336 | Thomas Howe H000855 | rep | NY | 1851-12-01 | 1853-03-03 | Democrat | 25 | |||||||||||||
6338 | 6338 | William Hunter H000992 | rep | OH | 1851-12-01 | 1853-03-03 | Whig | 15 | |||||||||||||
6339 | 6339 | Willard Ives I000051 | rep | NY | 1851-12-01 | 1853-03-03 | Democrat | 19 | |||||||||||||
6341 | 6341 | Joseph Jackson J000023 | rep | GA | 1851-12-01 | 1853-03-03 | States Rights | 1 | |||||||||||||
6345 | 6345 | Timothy Jenkins J000089 | rep | NY | 1851-12-01 | 1853-03-03 | Democrat | 20 | |||||||||||||
6346 | 6346 | James Johnson J000144 | rep | GA | 1851-12-01 | 1853-03-03 | Unionist | 2 | |||||||||||||
6347 | 6347 | John Johnson J000153 | rep | OH | 1851-12-01 | 1853-03-03 | Ind. Democrat | 16 | |||||||||||||
6350 | 6350 | George King K000201 | rep | RI | 1851-12-01 | 1853-03-03 | Whig | 1 | |||||||||||||
6351 | 6351 | Joseph Kuhns K000337 | rep | PA | 1851-12-01 | 1853-03-03 | Whig | 19 | |||||||||||||
6352 | 6352 | Joseph Landry L000055 | rep | LA | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
6353 | 6353 | Edward Little L000350 | rep | MA | 1851-12-01 | 1853-03-03 | Democrat | 9 | |||||||||||||
6356 | 6356 | Horace Mann M000102 | rep | MA | 1851-12-01 | 1853-03-03 | Free Soil | 8 | |||||||||||||
6357 | 6357 | Edward Marshall M000151 | rep | CA | 1851-12-01 | 1853-03-03 | Democrat | -1 | |||||||||||||
6358 | 6358 | Frederick Martin M000180 | rep | NY | 1851-12-01 | 1853-03-03 | Whig | 31 | |||||||||||||
6359 | 6359 | Joseph McCorkle M000362 | rep | CA | 1851-12-01 | 1853-03-03 | Democrat | -1 | |||||||||||||
6361 | 6361 | James McLanahan M000534 | rep | PA | 1851-12-01 | 1853-03-03 | Democrat | 16 | |||||||||||||
6364 | 6364 | Richard Meade M000618 | rep | VA | 1851-12-01 | 1853-03-03 | Democrat | 2 | |||||||||||||
6365 | 6365 | Ahiman Miner M000790 | rep | VT | 1851-12-01 | 1853-03-03 | Whig | 1 | |||||||||||||
6366 | 6366 | Richard Molony M000846 | rep | IL | 1851-12-01 | 1853-03-03 | Democrat | 4 | |||||||||||||
6368 | 6368 | Henry Moore M000900 | rep | PA | 1851-12-01 | 1853-03-03 | Whig | 3 | |||||||||||||
6371 | 6371 | John Moore M000903 | rep | LA | 1851-12-01 | 1853-03-03 | Whig | 4 | |||||||||||||
6372 | 6372 | James Morehead M000937 | rep | NC | 1851-12-01 | 1853-03-03 | Whig | 4 | |||||||||||||
6373 | 6373 | John Morrison M000997 | rep | PA | 1851-12-01 | 1853-03-03 | Democrat | 7 | |||||||||||||
6374 | 6374 | Charles Murphey M001086 | rep | GA | 1851-12-01 | 1853-03-03 | Unionist | 4 | |||||||||||||
6375 | 6375 | Benjamin Nabers N000001 | rep | MS | 1851-12-01 | 1853-03-03 | Unionist | 1 | |||||||||||||
6376 | 6376 | Eben Newton N000076 | rep | OH | 1851-12-01 | 1853-03-03 | Whig | 19 |
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);