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 legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: state, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6486 | 6486 | James Abercrombie A000012 | rep | AL | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
6750 | 6750 | William Aiken A000063 | rep | SC | 1851-12-01 | 1853-03-03 | Democrat | 6 | |||||||||||||
6209 | 6209 | Charles Allen A000115 | rep | MA | 1851-12-01 | 1853-03-03 | Free Soil | 5 | |||||||||||||
6489 | 6489 | Willis Allen A000154 | rep | IL | 1851-12-01 | 1853-03-03 | Democrat | 2 | |||||||||||||
6755 | 6755 | John Allison A000158 | rep | PA | 1851-12-01 | 1853-03-03 | Whig | 20 | |||||||||||||
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 | |||||||||||||
7654 | 7654 | William Appleton A000270 | rep | MA | 1851-12-01 | 1853-03-03 | Whig | 1 | |||||||||||||
6492 | 6492 | William Ashe A000310 | rep | NC | 1851-12-01 | 1853-03-03 | Democrat | 7 | |||||||||||||
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 | |||||||||||||
6499 | 6499 | David Bailey B000036 | rep | GA | 1851-12-01 | 1853-03-03 | States Rights | 3 | |||||||||||||
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 | |||||||||||||
6766 | 6766 | Thomas Bayly B000259 | rep | VA | 1851-12-01 | 1853-03-03 | Democrat | 7 | |||||||||||||
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 | |||||||||||||
6510 | 6510 | John Bell B000340 | sen | TN | 1847-12-06 | 1853-03-03 | 2 | Whig | |||||||||||||
6977 | 6977 | Henry Bennett B000376 | rep | NY | 1851-12-01 | 1853-03-03 | Whig | 22 | |||||||||||||
7661 | 7661 | John Bernhisel B000412 | rep | UT | 1851-12-01 | 1853-03-03 | Whig | -1 | |||||||||||||
5616 | 5616 | John Berrien B000413 | sen | GA | 1847-12-06 | 1853-03-03 | 2 | Whig | |||||||||||||
6222 | 6222 | Thomas Bibighaus B000435 | rep | PA | 1851-12-01 | 1853-03-03 | Whig | 14 | |||||||||||||
6519 | 6519 | William Bissell B000492 | rep | IL | 1851-12-01 | 1853-03-03 | Democrat | 1 | |||||||||||||
7297 | 7297 | Thomas Bocock B000582 | rep | VA | 1851-12-01 | 1853-03-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
6529 | 6529 | Linn Boyd B000719 | rep | KY | 1851-12-01 | 1853-03-03 | Democrat | 1 | |||||||||||||
5627 | 5627 | James Bradbury B000734 | sen | ME | 1847-12-06 | 1853-03-03 | 2 | Democrat | |||||||||||||
6227 | 6227 | John Bragg B000758 | rep | AL | 1851-12-01 | 1853-03-03 | Democrat | 1 | |||||||||||||
7671 | 7671 | John Breckinridge B000789 | rep | KY | 1851-12-01 | 1853-03-03 | Democrat | 8 | |||||||||||||
6988 | 6988 | Samuel Brenton B000805 | rep | IN | 1851-12-01 | 1853-03-03 | Whig | 10 | |||||||||||||
7318 | 7318 | George Briggs B000829 | rep | NY | 1851-12-01 | 1853-03-03 | Whig | 5 | |||||||||||||
6468 | 6468 | Walker Brooke B000872 | sen | MS | 1852-01-01 | 1853-03-03 | 2 | Whig | |||||||||||||
9101 | 9101 | James Brooks B000881 | rep | NY | 1851-12-01 | 1853-03-03 | Whig | 6 | |||||||||||||
7325 | 7325 | Albert Brown B000900 | rep | MS | 1851-12-01 | 1853-03-03 | States Rights | 4 | |||||||||||||
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 | |||||||||||||
8849 | 8849 | Lewis Campbell C000096 | rep | OH | 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 | |||||||||||||
7003 | 7003 | John Caskie C000231 | rep | VA | 1851-12-01 | 1853-03-03 | Democrat | 6 | |||||||||||||
6536 | 6536 | Joseph Chandler C000292 | rep | PA | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
6256 | 6256 | Charles Chapman C000310 | rep | CT | 1851-12-01 | 1853-03-03 | Whig | 1 | |||||||||||||
6472 | 6472 | Robert Charlton C000324 | sen | GA | 1852-01-01 | 1853-03-03 | 2 | Democrat | |||||||||||||
6542 | 6542 | Elijah Chastain C000335 | rep | GA | 1851-12-01 | 1853-03-03 | Democrat | 5 | |||||||||||||
6545 | 6545 | William Churchwell C000393 | rep | TN | 1851-12-01 | 1853-03-03 | Democrat | 3 | |||||||||||||
6257 | 6257 | Lincoln Clark C000445 | rep | IA | 1851-12-01 | 1853-03-03 | Democrat | 2 | |||||||||||||
5650 | 5650 | John Clarke C000466 | sen | RI | 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 | |||||||||||||
7343 | 7343 | Sherrard Clemens C000502 | rep | VA | 1851-12-01 | 1853-03-03 | Democrat | 15 | |||||||||||||
6259 | 6259 | Chauncey Cleveland C000511 | rep | CT | 1851-12-01 | 1853-03-03 | Democrat | 3 | |||||||||||||
7263 | 7263 | Thomas Clingman C000524 | rep | NC | 1851-12-01 | 1853-03-03 | Whig | 1 | |||||||||||||
7349 | 7349 | Williamson Cobb C000554 | rep | AL | 1851-12-01 | 1853-03-03 | Democrat | 6 | |||||||||||||
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 | |||||||||||||
6557 | 6557 | William Cullom C000974 | rep | TN | 1851-12-01 | 1853-03-03 | Whig | 8 | |||||||||||||
9144 | 9144 | Carlton Curtis C001007 | rep | PA | 1851-12-01 | 1853-03-03 | Democrat | 23 | |||||||||||||
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 | |||||||||||||
5670 | 5670 | John Davis D000117 | sen | MA | 1847-12-06 | 1853-03-03 | 2 | Whig | |||||||||||||
7374 | 7374 | John Davis D000118 | rep | IN | 1851-12-01 | 1853-03-03 | Democrat | 7 | |||||||||||||
8102 | 8102 | John Dawson D000153 | rep | PA | 1851-12-01 | 1853-03-03 | Democrat | 18 | |||||||||||||
6562 | 6562 | Gilbert Dean D000172 | rep | NY | 1851-12-01 | 1853-03-03 | Democrat | 8 | |||||||||||||
6473 | 6473 | William De Saussure D000270 | sen | SC | 1852-01-01 | 1853-03-03 | 2 | Democrat | |||||||||||||
6273 | 6273 | Milo Dimmick D000350 | rep | PA | 1851-12-01 | 1853-03-03 | Democrat | 10 | |||||||||||||
6567 | 6567 | David Disney D000361 | rep | OH | 1851-12-01 | 1853-03-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
7388 | 7388 | Stephen Douglas D000457 | sen | IL | 1847-12-06 | 1853-03-03 | 2 | Democrat | |||||||||||||
5674 | 5674 | Solomon Downs D000476 | sen | LA | 1847-12-06 | 1853-03-03 | 2 | Democrat | |||||||||||||
6285 | 6285 | James Duncan D000532 | rep | MA | 1851-12-01 | 1853-03-03 | Whig | 3 | |||||||||||||
6572 | 6572 | Cyrus Dunham D000540 | rep | IN | 1851-12-01 | 1853-03-03 | Democrat | 2 | |||||||||||||
6807 | 6807 | Charles Durkee D000573 | rep | WI | 1851-12-01 | 1853-03-03 | Free Soil | 1 | |||||||||||||
6574 | 6574 | Ben Eastman E000019 | rep | WI | 1851-12-01 | 1853-03-03 | Democrat | 2 | |||||||||||||
6577 | 6577 | Alfred Edgerton E000045 | rep | OH | 1851-12-01 | 1853-03-03 | Democrat | 5 | |||||||||||||
7392 | 7392 | Henry Edmundson E000058 | rep | VA | 1851-12-01 | 1853-03-03 | Democrat | 12 | |||||||||||||
6288 | 6288 | Alexander Evans E000231 | rep | MD | 1851-12-01 | 1853-03-03 | Whig | 5 | |||||||||||||
6589 | 6589 | Presley Ewing E000279 | rep | KY | 1851-12-01 | 1853-03-03 | Whig | 3 | |||||||||||||
9502 | 9502 | Charles Faulkner F000044 | rep | VA | 1851-12-01 | 1853-03-03 | Whig | 10 | |||||||||||||
6289 | 6289 | Francis Fay F000050 | rep | MA | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
5691 | 5691 | Alpheus Felch F000063 | sen | MI | 1847-12-06 | 1853-03-03 | 2 | Democrat | |||||||||||||
6293 | 6293 | Orlando Ficklin F000101 | rep | IL | 1851-12-01 | 1853-03-03 | Democrat | 3 | |||||||||||||
7045 | 7045 | Graham Fitch F000158 | rep | IN | 1851-12-01 | 1853-03-03 | Democrat | 9 | |||||||||||||
7405 | 7405 | Thomas Florence F000214 | rep | PA | 1851-12-01 | 1853-03-03 | Democrat | 1 | |||||||||||||
6298 | 6298 | John Floyd F000223 | rep | NY | 1851-12-01 | 1853-03-03 | Democrat | 1 | |||||||||||||
5694 | 5694 | Henry Foote F000251 | sen | MS | 1847-12-06 | 1853-03-03 | 2 | Democrat | |||||||||||||
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 | |||||||||||||
6818 | 6818 | Henry Fuller F000410 | rep | PA | 1851-12-01 | 1853-03-03 | Whig | 11 | |||||||||||||
6821 | 6821 | Thomas Fuller F000412 | rep | ME | 1851-12-01 | 1853-03-03 | Democrat | 7 |
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);