legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
275 rows where "end" is on date 1861-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7648 | 7648 | Charles Adams A000032 | rep | MA | 1859-12-05 | 1861-03-03 | Republican | 3 | |||||||||||||
7273 | 7273 | Green Adams A000036 | rep | KY | 1859-12-05 | 1861-03-03 | Ind. Republican-Democrat | 6 | |||||||||||||
7275 | 7275 | Garnett Adrain A000058 | rep | NJ | 1859-12-05 | 1861-03-03 | Anti-Lecompton Democrat | 3 | |||||||||||||
7650 | 7650 | Cyrus Aldrich A000081 | rep | MN | 1859-12-05 | 1861-03-03 | Republican | -1 | |||||||||||||
7652 | 7652 | William Allen A000149 | rep | OH | 1859-12-05 | 1861-03-03 | Democrat | 4 | |||||||||||||
8074 | 8074 | John Alley A000155 | rep | MA | 1859-12-05 | 1861-03-03 | Republican | 6 | |||||||||||||
7277 | 7277 | Thomas Anderson A000234 | rep | MO | 1859-12-05 | 1861-03-03 | Ind. Democrat | 2 | |||||||||||||
7278 | 7278 | William Anderson A000237 | rep | KY | 1859-12-05 | 1861-03-03 | Ind. Republican-Democrat | 4 | |||||||||||||
8252 | 8252 | James Ashley A000314 | rep | OH | 1859-12-05 | 1861-03-03 | Republican | 5 | |||||||||||||
7279 | 7279 | John Ashmore A000316 | rep | SC | 1859-12-05 | 1861-03-03 | Democrat | 5 | |||||||||||||
7281 | 7281 | William Avery A000347 | rep | TN | 1859-12-05 | 1861-03-03 | Democrat | 10 | |||||||||||||
7657 | 7657 | Elijah Babbitt B000002 | rep | PA | 1859-12-05 | 1861-03-03 | Republican | 25 | |||||||||||||
7285 | 7285 | William Barksdale B000147 | rep | MS | 1859-12-05 | 1861-03-03 | Democrat | 3 | |||||||||||||
7287 | 7287 | Thomas Barr B000172 | rep | NY | 1859-12-05 | 1861-03-03 | Ind. Democrat | 4 | |||||||||||||
7288 | 7288 | John Barret B000175 | rep | MO | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
7289 | 7289 | Charles Beale B000265 | rep | NY | 1859-12-05 | 1861-03-03 | Republican | 12 | |||||||||||||
6961 | 6961 | William Bigler B000459 | sen | PA | 1856-01-01 | 1861-03-03 | 3 | Democrat | |||||||||||||
8817 | 8817 | John Bingham B000471 | rep | OH | 1859-12-05 | 1861-03-03 | Republican | 21 | |||||||||||||
8829 | 8829 | Francis Blair B000523 | rep | MO | 1859-12-05 | 1861-03-03 | Republican | 1 | |||||||||||||
7667 | 7667 | Samuel Blair B000529 | rep | PA | 1859-12-05 | 1861-03-03 | Republican | 18 | |||||||||||||
7669 | 7669 | Harrison Blake B000531 | rep | OH | 1859-12-05 | 1861-03-03 | Republican | 14 | |||||||||||||
7301 | 7301 | Thomas Bocock B000582 | rep | VA | 1859-12-05 | 1861-03-03 | Democrat | 5 | |||||||||||||
7303 | 7303 | Milledge Bonham B000616 | rep | SC | 1859-12-05 | 1861-03-03 | Democrat | 4 | |||||||||||||
7304 | 7304 | Alexander Boteler B000653 | rep | VA | 1859-12-05 | 1861-03-03 | Ind. Republican-Democrat | 8 | |||||||||||||
7305 | 7305 | John Bouligny B000665 | rep | LA | 1859-12-05 | 1861-03-03 | American | 1 | |||||||||||||
7309 | 7309 | William Boyce B000713 | rep | SC | 1859-12-05 | 1861-03-03 | Democrat | 6 | |||||||||||||
7310 | 7310 | Reese Brabson B000730 | rep | TN | 1859-12-05 | 1861-03-03 | Ind. Republican-Democrat | 3 | |||||||||||||
7314 | 7314 | Lawrence Branch B000764 | rep | NC | 1859-12-05 | 1861-03-03 | Democrat | 4 | |||||||||||||
7316 | 7316 | William Brayton B000779 | rep | RI | 1859-12-05 | 1861-03-03 | Republican | 2 | |||||||||||||
7319 | 7319 | George Briggs B000829 | rep | NY | 1859-12-05 | 1861-03-03 | Republican | 7 | |||||||||||||
7321 | 7321 | Francis Bristow B000842 | rep | KY | 1859-12-05 | 1861-03-03 | Ind. Republican-Democrat | 3 | |||||||||||||
9456 | 9456 | John Brown B000933 | rep | KY | 1859-12-05 | 1861-03-03 | Democrat | 5 | |||||||||||||
9464 | 9464 | James Buffinton B001040 | rep | MA | 1859-12-05 | 1861-03-03 | Republican | 2 | |||||||||||||
7328 | 7328 | John Burch B001068 | rep | CA | 1859-12-05 | 1861-03-03 | Democrat | -1 | |||||||||||||
7331 | 7331 | Anson Burlingame B001112 | rep | MA | 1859-12-05 | 1861-03-03 | Republican | 5 | |||||||||||||
7679 | 7679 | Henry Burnett B001120 | rep | KY | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
7681 | 7681 | Alfred Burnham B001123 | rep | CT | 1859-12-05 | 1861-03-03 | Republican | 3 | |||||||||||||
7333 | 7333 | Silas Burroughs B001139 | rep | NY | 1859-12-05 | 1861-03-03 | Republican | 31 | |||||||||||||
7334 | 7334 | Martin Butterfield B001199 | rep | NY | 1859-12-05 | 1861-03-03 | Republican | 25 | |||||||||||||
7685 | 7685 | James Campbell C000088 | rep | PA | 1859-12-05 | 1861-03-03 | Republican | 11 | |||||||||||||
7335 | 7335 | John Carey C000144 | rep | OH | 1859-12-05 | 1861-03-03 | Republican | 9 | |||||||||||||
7336 | 7336 | Luther Carter C000198 | rep | NY | 1859-12-05 | 1861-03-03 | Republican | 1 | |||||||||||||
7338 | 7338 | Charles Case C000219 | rep | IN | 1859-12-05 | 1861-03-03 | Republican | 10 | |||||||||||||
7694 | 7694 | Daniel Clark C000427 | sen | NH | 1857-12-07 | 1861-03-03 | 3 | Republican | |||||||||||||
7340 | 7340 | Horace Clark C000435 | rep | NY | 1859-12-05 | 1861-03-03 | Anti-Lecompton Democrat | 8 | |||||||||||||
7697 | 7697 | John Clark C000441 | rep | MO | 1859-12-05 | 1861-03-03 | Democrat | 3 | |||||||||||||
7345 | 7345 | Sherrard Clemens C000502 | rep | VA | 1859-12-05 | 1861-03-03 | Democrat | 10 | |||||||||||||
7266 | 7266 | Thomas Clingman C000524 | sen | NC | 1858-01-01 | 1861-03-03 | 3 | Democrat | |||||||||||||
7346 | 7346 | David Clopton C000530 | rep | AL | 1859-12-05 | 1861-03-03 | Democrat | 3 | |||||||||||||
7353 | 7353 | Williamson Cobb C000554 | rep | AL | 1859-12-05 | 1861-03-03 | Democrat | 6 | |||||||||||||
7354 | 7354 | Stephen Coburn C000559 | rep | ME | 1859-12-05 | 1861-03-03 | Republican | 5 | |||||||||||||
7356 | 7356 | Clark Cochrane C000569 | rep | NY | 1859-12-05 | 1861-03-03 | Republican | 18 | |||||||||||||
7358 | 7358 | John Cochrane C000570 | rep | NY | 1859-12-05 | 1861-03-03 | Democrat | 6 | |||||||||||||
8292 | 8292 | Schuyler Colfax C000626 | rep | IN | 1859-12-05 | 1861-03-03 | Republican | 9 | |||||||||||||
7704 | 7704 | Jacob Collamer C000628 | sen | VT | 1855-12-03 | 1861-03-03 | 3 | Republican | |||||||||||||
10049 | 10049 | Roscoe Conkling C000681 | rep | NY | 1859-12-05 | 1861-03-03 | Republican | 20 | |||||||||||||
7707 | 7707 | Martin Conway C000713 | rep | KS | 1859-12-05 | 1861-03-03 | Republican | 1 | |||||||||||||
7359 | 7359 | George Cooper C000749 | rep | MI | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
7716 | 7716 | Thomas Corwin C000791 | rep | OH | 1859-12-05 | 1861-03-03 | Republican | 7 | |||||||||||||
8564 | 8564 | John Covode C000818 | rep | PA | 1859-12-05 | 1861-03-03 | Republican | 19 | |||||||||||||
11692 | 11692 | Samuel Cox C000839 | rep | OH | 1859-12-05 | 1861-03-03 | Democrat | 12 | |||||||||||||
7361 | 7361 | James Craig C000857 | rep | MO | 1859-12-05 | 1861-03-03 | Democrat | 4 | |||||||||||||
7365 | 7365 | Francis Craige C000862 | rep | NC | 1859-12-05 | 1861-03-03 | Democrat | 7 | |||||||||||||
7368 | 7368 | Martin Crawford C000892 | rep | GA | 1859-12-05 | 1861-03-03 | Democrat | 2 | |||||||||||||
7726 | 7726 | John Crittenden C000912 | sen | KY | 1855-12-03 | 1861-03-03 | 3 | American | |||||||||||||
7370 | 7370 | Jabez Curry C001003 | rep | AL | 1859-12-05 | 1861-03-03 | Democrat | 7 | |||||||||||||
7729 | 7729 | Samuel Curtis C001013 | rep | IA | 1859-12-05 | 1861-03-03 | Republican | 1 | |||||||||||||
7937 | 7937 | Samuel Daily D000006 | rep | NE | 1859-12-05 | 1861-03-03 | Republican | -1 | |||||||||||||
7373 | 7373 | Thomas Davidson D000086 | rep | LA | 1859-12-05 | 1861-03-03 | Democrat | 3 | |||||||||||||
7942 | 7942 | Henry Davis D000104 | rep | MD | 1859-12-05 | 1861-03-03 | American | 4 | |||||||||||||
7377 | 7377 | John Davis D000118 | rep | IN | 1859-12-05 | 1861-03-03 | Anti-Lecompton Democrat | 7 | |||||||||||||
7379 | 7379 | Reuben Davis D000127 | rep | MS | 1859-12-05 | 1861-03-03 | Democrat | 2 | |||||||||||||
11337 | 11337 | Henry Dawes D000148 | rep | MA | 1859-12-05 | 1861-03-03 | Republican | 11 | |||||||||||||
7733 | 7733 | Daniel De Jarnette D000202 | rep | VA | 1859-12-05 | 1861-03-03 | Ind. Democrat | 3 | |||||||||||||
7735 | 7735 | Charles Delano D000213 | rep | MA | 1859-12-05 | 1861-03-03 | Republican | 10 | |||||||||||||
7383 | 7383 | John Dick D000303 | rep | PA | 1859-12-05 | 1861-03-03 | Whig | -1 | |||||||||||||
7385 | 7385 | William Dimmick D000351 | rep | PA | 1859-12-05 | 1861-03-03 | Democrat | 13 | |||||||||||||
9155 | 9155 | Rodolphus Duell D000513 | rep | NY | 1859-12-05 | 1861-03-03 | Republican | 21 | |||||||||||||
7740 | 7740 | William Dunn D000554 | rep | IN | 1859-12-05 | 1861-03-03 | Republican | 3 | |||||||||||||
6808 | 6808 | Charles Durkee D000573 | sen | WI | 1855-12-03 | 1861-03-03 | 3 | Republican | |||||||||||||
7742 | 7742 | Sidney Edgerton E000048 | rep | OH | 1859-12-05 | 1861-03-03 | Republican | 18 | |||||||||||||
7396 | 7396 | Henry Edmundson E000058 | rep | VA | 1859-12-05 | 1861-03-03 | Democrat | 12 | |||||||||||||
7744 | 7744 | Thomas Edwards E000081 | rep | NH | 1859-12-05 | 1861-03-03 | Republican | 3 | |||||||||||||
8325 | 8325 | Thomas Eliot E000106 | rep | MA | 1859-12-05 | 1861-03-03 | Republican | 1 | |||||||||||||
7746 | 7746 | Alfred Ely E000164 | rep | NY | 1859-12-05 | 1861-03-03 | Republican | 29 | |||||||||||||
7400 | 7400 | William English E000191 | rep | IN | 1859-12-05 | 1861-03-03 | Democrat | 2 | |||||||||||||
7401 | 7401 | Experience Estabrook E000220 | rep | NE | 1859-12-05 | 1861-03-03 | -1 | ||||||||||||||
7404 | 7404 | Emerson Etheridge E000227 | rep | TN | 1859-12-05 | 1861-03-03 | Ind. Republican-Democrat | 9 | |||||||||||||
8888 | 8888 | John Farnsworth F000024 | rep | IL | 1859-12-05 | 1861-03-03 | Republican | 2 | |||||||||||||
8591 | 8591 | Reuben Fenton F000077 | rep | NY | 1859-12-05 | 1861-03-03 | Republican | 33 | |||||||||||||
9167 | 9167 | Orris Ferry F000094 | rep | CT | 1859-12-05 | 1861-03-03 | Republican | 4 | |||||||||||||
7046 | 7046 | Graham Fitch F000158 | sen | IN | 1857-12-07 | 1861-03-03 | 3 | Democrat | |||||||||||||
6814 | 6814 | Benjamin Fitzpatrick F000174 | sen | AL | 1855-12-03 | 1861-03-03 | 3 | Democrat | |||||||||||||
7409 | 7409 | Thomas Florence F000214 | rep | PA | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
7752 | 7752 | Lafayette Foster F000308 | sen | CT | 1855-12-03 | 1861-03-03 | 3 | Republican | |||||||||||||
7411 | 7411 | Stephen Foster F000312 | rep | ME | 1859-12-05 | 1861-03-03 | Republican | 6 | |||||||||||||
7754 | 7754 | Philip Fouke F000316 | rep | IL | 1859-12-05 | 1861-03-03 | Democrat | 8 | |||||||||||||
7956 | 7956 | Augustus Frank F000338 | rep | NY | 1859-12-05 | 1861-03-03 | Republican | 30 | |||||||||||||
7412 | 7412 | Ezra French F000377 | rep | ME | 1859-12-05 | 1861-03-03 | Republican | 3 | |||||||||||||
7415 | 7415 | Muscoe Garnett G000076 | rep | VA | 1859-12-05 | 1861-03-03 | Democrat | 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);