legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
280 rows where "end" is on date 1859-03-03 sorted by legislator_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6971 | 6971 | Nehemiah Abbott A000008 | rep | ME | 1857-12-07 | 1859-03-03 | Republican | 3 | |||||||||||||
7274 | 7274 | Garnett Adrain A000058 | rep | NJ | 1857-12-07 | 1859-03-03 | Democrat | 3 | |||||||||||||
6972 | 6972 | John Ahl A000060 | rep | PA | 1857-12-07 | 1859-03-03 | Democrat | 16 | |||||||||||||
6488 | 6488 | Philip Allen A000141 | sen | RI | 1853-12-05 | 1859-03-03 | 2 | Democrat | |||||||||||||
7276 | 7276 | Thomas Anderson A000234 | rep | MO | 1857-12-07 | 1859-03-03 | American | 2 | |||||||||||||
6973 | 6973 | Samuel Andrews A000248 | rep | NY | 1857-12-07 | 1859-03-03 | Republican | 29 | |||||||||||||
6974 | 6974 | Samuel Arnold A000294 | rep | CT | 1857-12-07 | 1859-03-03 | Democrat | 2 | |||||||||||||
10258 | 10258 | John Atkins A000327 | rep | TN | 1857-12-07 | 1859-03-03 | Democrat | 9 | |||||||||||||
7280 | 7280 | William Avery A000347 | rep | TN | 1857-12-07 | 1859-03-03 | Democrat | 10 | |||||||||||||
11577 | 11577 | Nathaniel Banks B000116 | rep | MA | 1857-12-07 | 1859-03-03 | Republican | 7 | |||||||||||||
7284 | 7284 | William Barksdale B000147 | rep | MS | 1857-12-07 | 1859-03-03 | Democrat | 3 | |||||||||||||
7286 | 7286 | Thomas Barr B000172 | rep | NY | 1857-12-07 | 1859-03-03 | Ind. Democrat | 4 | |||||||||||||
6975 | 6975 | Martin Bates B000238 | sen | DE | 1857-12-07 | 1859-03-03 | 2 | Democrat | |||||||||||||
6511 | 6511 | John Bell B000340 | sen | TN | 1853-12-05 | 1859-03-03 | 2 | American | |||||||||||||
7290 | 7290 | Judah Benjamin B000365 | sen | LA | 1853-12-05 | 1859-03-03 | 2 | Democrat | |||||||||||||
6980 | 6980 | Henry Bennett B000376 | rep | NY | 1857-12-07 | 1859-03-03 | Republican | 21 | |||||||||||||
7664 | 7664 | John Bernhisel B000412 | rep | UT | 1857-12-07 | 1859-03-03 | Whig | -1 | |||||||||||||
6776 | 6776 | Asa Biggs B000456 | sen | NC | 1855-12-03 | 1859-03-03 | 3 | Democrat | |||||||||||||
6982 | 6982 | Charles Billinghurst B000464 | rep | WI | 1857-12-07 | 1859-03-03 | Republican | 3 | |||||||||||||
8816 | 8816 | John Bingham B000471 | rep | OH | 1857-12-07 | 1859-03-03 | Republican | 21 | |||||||||||||
6983 | 6983 | William Bishop B000491 | rep | CT | 1857-12-07 | 1859-03-03 | Democrat | 4 | |||||||||||||
8828 | 8828 | Francis Blair B000523 | rep | MO | 1857-12-07 | 1859-03-03 | Ind. Democrat | 1 | |||||||||||||
6985 | 6985 | Philemon Bliss B000560 | rep | OH | 1857-12-07 | 1859-03-03 | Republican | 14 | |||||||||||||
7300 | 7300 | Thomas Bocock B000582 | rep | VA | 1857-12-07 | 1859-03-03 | Democrat | 5 | |||||||||||||
7302 | 7302 | Milledge Bonham B000616 | rep | SC | 1857-12-07 | 1859-03-03 | Democrat | 4 | |||||||||||||
6987 | 6987 | Thomas Bowie B000696 | rep | MD | 1857-12-07 | 1859-03-03 | Democrat | 6 | |||||||||||||
7308 | 7308 | William Boyce B000713 | rep | SC | 1857-12-07 | 1859-03-03 | Democrat | 6 | |||||||||||||
7313 | 7313 | Lawrence Branch B000764 | rep | NC | 1857-12-07 | 1859-03-03 | Democrat | 4 | |||||||||||||
7315 | 7315 | William Brayton B000779 | rep | RI | 1857-12-07 | 1859-03-03 | Republican | 2 | |||||||||||||
6990 | 6990 | Samuel Brenton B000805 | rep | IN | 1857-12-07 | 1859-03-03 | Republican | 10 | |||||||||||||
6997 | 6997 | Preston Brooks B000885 | rep | SC | 1857-12-07 | 1859-03-03 | Democrat | -1 | |||||||||||||
7326 | 7326 | Albert Brown B000900 | sen | MS | 1854-01-01 | 1859-03-03 | 2 | Democrat | |||||||||||||
6998 | 6998 | Guy Bryan B000985 | rep | TX | 1857-12-07 | 1859-03-03 | Democrat | 2 | |||||||||||||
9463 | 9463 | James Buffinton B001040 | rep | MA | 1857-12-07 | 1859-03-03 | Republican | 2 | |||||||||||||
7330 | 7330 | Anson Burlingame B001112 | rep | MA | 1857-12-07 | 1859-03-03 | Republican | 5 | |||||||||||||
7678 | 7678 | Henry Burnett B001120 | rep | KY | 1857-12-07 | 1859-03-03 | Democrat | 1 | |||||||||||||
6999 | 6999 | Joseph Burns B001128 | rep | OH | 1857-12-07 | 1859-03-03 | Democrat | 15 | |||||||||||||
7332 | 7332 | Silas Burroughs B001139 | rep | NY | 1857-12-07 | 1859-03-03 | Republican | 31 | |||||||||||||
8852 | 8852 | Lewis Campbell C000096 | rep | OH | 1857-12-07 | 1859-03-03 | Republican | 3 | |||||||||||||
7002 | 7002 | Samuel Caruthers C000210 | rep | MO | 1857-12-07 | 1859-03-03 | Democrat | 7 | |||||||||||||
7337 | 7337 | Charles Case C000219 | rep | IN | 1857-12-07 | 1859-03-03 | Republican | 10 | |||||||||||||
7006 | 7006 | John Caskie C000231 | rep | VA | 1857-12-07 | 1859-03-03 | Democrat | 3 | |||||||||||||
8543 | 8543 | James Cavanaugh C000260 | rep | MN | 1857-12-07 | 1859-03-03 | Democrat | -1 | |||||||||||||
7008 | 7008 | Calvin Chaffee C000270 | rep | MA | 1857-12-07 | 1859-03-03 | Republican | 10 | |||||||||||||
7009 | 7009 | Henry Chapman C000311 | rep | PA | 1857-12-07 | 1859-03-03 | Democrat | 7 | |||||||||||||
7258 | 7258 | James Chesnut C000348 | sen | SC | 1858-12-03 | 1859-03-03 | 2 | Democrat | |||||||||||||
7011 | 7011 | Ezra Clark C000429 | rep | CT | 1857-12-07 | 1859-03-03 | Republican | 1 | |||||||||||||
7339 | 7339 | Horace Clark C000435 | rep | NY | 1857-12-07 | 1859-03-03 | Democrat | 8 | |||||||||||||
7696 | 7696 | John Clark C000441 | rep | MO | 1857-12-07 | 1859-03-03 | Democrat | 3 | |||||||||||||
7013 | 7013 | Isaiah Clawson C000477 | rep | NJ | 1857-12-07 | 1859-03-03 | Republican | 1 | |||||||||||||
7341 | 7341 | Clement Clay C000480 | sen | AL | 1853-12-05 | 1859-03-03 | 2 | Democrat | |||||||||||||
7014 | 7014 | James Clay C000483 | rep | KY | 1857-12-07 | 1859-03-03 | Democrat | 8 | |||||||||||||
7344 | 7344 | Sherrard Clemens C000502 | rep | VA | 1857-12-07 | 1859-03-03 | Democrat | 10 | |||||||||||||
7352 | 7352 | Williamson Cobb C000554 | rep | AL | 1857-12-07 | 1859-03-03 | Democrat | 6 | |||||||||||||
7355 | 7355 | Clark Cochrane C000569 | rep | NY | 1857-12-07 | 1859-03-03 | Republican | 18 | |||||||||||||
7357 | 7357 | John Cochrane C000570 | rep | NY | 1857-12-07 | 1859-03-03 | Democrat | 6 | |||||||||||||
7015 | 7015 | Joseph Cockerill C000574 | rep | OH | 1857-12-07 | 1859-03-03 | Democrat | 6 | |||||||||||||
8291 | 8291 | Schuyler Colfax C000626 | rep | IN | 1857-12-07 | 1859-03-03 | Republican | 9 | |||||||||||||
7017 | 7017 | Linus Comins C000659 | rep | MA | 1857-12-07 | 1859-03-03 | Republican | 4 | |||||||||||||
7932 | 7932 | Erastus Corning C000784 | rep | NY | 1857-12-07 | 1859-03-03 | Democrat | 14 | |||||||||||||
8563 | 8563 | John Covode C000818 | rep | PA | 1857-12-07 | 1859-03-03 | Republican | 19 | |||||||||||||
11691 | 11691 | Samuel Cox C000839 | rep | OH | 1857-12-07 | 1859-03-03 | Democrat | 12 | |||||||||||||
8868 | 8868 | Aaron Cragin C000852 | rep | NH | 1857-12-07 | 1859-03-03 | Republican | 3 | |||||||||||||
7360 | 7360 | James Craig C000857 | rep | MO | 1857-12-07 | 1859-03-03 | Democrat | 4 | |||||||||||||
7364 | 7364 | Francis Craige C000862 | rep | NC | 1857-12-07 | 1859-03-03 | Democrat | 7 | |||||||||||||
7367 | 7367 | Martin Crawford C000892 | rep | GA | 1857-12-07 | 1859-03-03 | Democrat | 2 | |||||||||||||
7369 | 7369 | Jabez Curry C001003 | rep | AL | 1857-12-07 | 1859-03-03 | Democrat | 7 | |||||||||||||
7728 | 7728 | Samuel Curtis C001013 | rep | IA | 1857-12-07 | 1859-03-03 | Republican | 1 | |||||||||||||
7019 | 7019 | William Damrell D000019 | rep | MA | 1857-12-07 | 1859-03-03 | Republican | 3 | |||||||||||||
7372 | 7372 | Thomas Davidson D000086 | rep | LA | 1857-12-07 | 1859-03-03 | Democrat | 3 | |||||||||||||
7941 | 7941 | Henry Davis D000104 | rep | MD | 1857-12-07 | 1859-03-03 | American | 4 | |||||||||||||
7376 | 7376 | John Davis D000118 | rep | IN | 1857-12-07 | 1859-03-03 | Democrat | 7 | |||||||||||||
7378 | 7378 | Reuben Davis D000127 | rep | MS | 1857-12-07 | 1859-03-03 | Democrat | 2 | |||||||||||||
7023 | 7023 | Timothy Davis D000140 | rep | IA | 1857-12-07 | 1859-03-03 | Republican | 2 | |||||||||||||
7025 | 7025 | Timothy Davis D000141 | rep | MA | 1857-12-07 | 1859-03-03 | Republican | 6 | |||||||||||||
11336 | 11336 | Henry Dawes D000148 | rep | MA | 1857-12-07 | 1859-03-03 | Republican | 11 | |||||||||||||
7027 | 7027 | Sidney Dean D000174 | rep | CT | 1857-12-07 | 1859-03-03 | Republican | 3 | |||||||||||||
7028 | 7028 | William Dewart D000290 | rep | PA | 1857-12-07 | 1859-03-03 | Democrat | 11 | |||||||||||||
7382 | 7382 | John Dick D000303 | rep | PA | 1857-12-07 | 1859-03-03 | Republican | 25 | |||||||||||||
7384 | 7384 | William Dimmick D000351 | rep | PA | 1857-12-07 | 1859-03-03 | Democrat | 13 | |||||||||||||
7030 | 7030 | Edward Dodd D000389 | rep | NY | 1857-12-07 | 1859-03-03 | Republican | 15 | |||||||||||||
7389 | 7389 | Stephen Douglas D000457 | sen | IL | 1853-12-05 | 1859-03-03 | 2 | Democrat | |||||||||||||
7033 | 7033 | James Dowdell D000464 | rep | AL | 1857-12-07 | 1859-03-03 | Democrat | 3 | |||||||||||||
7035 | 7035 | Nathaniel Durfee D000569 | rep | RI | 1857-12-07 | 1859-03-03 | Republican | 1 | |||||||||||||
7037 | 7037 | John Edie E000049 | rep | PA | 1857-12-07 | 1859-03-03 | Republican | 18 | |||||||||||||
7395 | 7395 | Henry Edmundson E000058 | rep | VA | 1857-12-07 | 1859-03-03 | Democrat | 12 | |||||||||||||
7040 | 7040 | John Elliott E000125 | rep | KY | 1857-12-07 | 1859-03-03 | Democrat | 6 | |||||||||||||
7399 | 7399 | William English E000191 | rep | IN | 1857-12-07 | 1859-03-03 | Democrat | 2 | |||||||||||||
7042 | 7042 | George Eustis E000228 | rep | LA | 1857-12-07 | 1859-03-03 | American | 1 | |||||||||||||
6581 | 6581 | Josiah Evans E000249 | sen | SC | 1853-12-05 | 1859-03-03 | 2 | Democrat | |||||||||||||
8887 | 8887 | John Farnsworth F000024 | rep | IL | 1857-12-07 | 1859-03-03 | Republican | 2 | |||||||||||||
9505 | 9505 | Charles Faulkner F000044 | rep | VA | 1857-12-07 | 1859-03-03 | Democrat | 8 | |||||||||||||
8590 | 8590 | Reuben Fenton F000077 | rep | NY | 1857-12-07 | 1859-03-03 | Republican | 33 | |||||||||||||
7043 | 7043 | Fenner Ferguson F000080 | rep | NE | 1857-12-07 | 1859-03-03 | Democrat | -1 | |||||||||||||
8115 | 8115 | William Fessenden F000099 | sen | ME | 1854-01-01 | 1859-03-03 | 2 | Republican | |||||||||||||
7408 | 7408 | Thomas Florence F000214 | rep | PA | 1857-12-07 | 1859-03-03 | Democrat | 1 | |||||||||||||
7047 | 7047 | James Foley F000236 | rep | IN | 1857-12-07 | 1859-03-03 | Democrat | 4 | |||||||||||||
7410 | 7410 | Stephen Foster F000312 | rep | ME | 1857-12-07 | 1859-03-03 | Republican | 6 | |||||||||||||
7414 | 7414 | Muscoe Garnett G000076 | rep | VA | 1857-12-07 | 1859-03-03 | Democrat | 1 | |||||||||||||
7416 | 7416 | Lucius Gartrell G000088 | rep | GA | 1857-12-07 | 1859-03-03 | Democrat | 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);