legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
371 rows where "end" is on date 1887-03-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11556 | 11556 | George Adams A000034 | rep | IL | 1885-12-07 | 1887-03-03 | Republican | 4 | |||||||||||||
10952 | 10952 | John Adams A000040 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 7 | |||||||||||||
10957 | 10957 | David Aiken A000061 | rep | SC | 1885-12-07 | 1887-03-03 | Democrat | 3 | |||||||||||||
14557 | 14557 | Nelson Aldrich A000083 | sen | RI | 1881-10-05 | 1887-03-03 | 1 | Republican | |||||||||||||
11283 | 11283 | Charles Allen A000116 | rep | MA | 1885-12-07 | 1887-03-03 | Republican | 8 | |||||||||||||
13548 | 13548 | John Allen A000134 | rep | MS | 1885-12-07 | 1887-03-03 | Democrat | 1 | |||||||||||||
10958 | 10958 | Charles Anderson A000185 | rep | OH | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
11568 | 11568 | John Anderson A000194 | rep | KS | 1885-12-07 | 1887-03-03 | Republican | 5 | |||||||||||||
10960 | 10960 | John Arnot A000301 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 28 | |||||||||||||
12071 | 12071 | Louis Atkinson A000331 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 18 | |||||||||||||
12076 | 12076 | Henry Bacon B000016 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 15 | |||||||||||||
11572 | 11572 | Charles Baker B000057 | rep | NY | 1885-12-07 | 1887-03-03 | Republican | 30 | |||||||||||||
10962 | 10962 | John Ballentine B000105 | rep | TN | 1885-12-07 | 1887-03-03 | Democrat | 7 | |||||||||||||
11587 | 11587 | John Barbour B000129 | rep | VA | 1885-12-07 | 1887-03-03 | Democrat | 8 | |||||||||||||
10964 | 10964 | Ethelbert Barksdale B000146 | rep | MS | 1885-12-07 | 1887-03-03 | Democrat | 7 | |||||||||||||
11589 | 11589 | George Barnes B000157 | rep | GA | 1885-12-07 | 1887-03-03 | Democrat | 10 | |||||||||||||
11287 | 11287 | Frederick Barry B000188 | rep | MS | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
11596 | 11596 | Thomas Bayne B000261 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 23 | |||||||||||||
10967 | 10967 | Lewis Beach B000263 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 15 | |||||||||||||
10968 | 10968 | Curtis Bean B000278 | rep | AZ | 1885-12-07 | 1887-03-03 | Republican | 0 | |||||||||||||
11291 | 11291 | Perry Belmont B000353 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 1 | |||||||||||||
10970 | 10970 | Risden Bennett B000381 | rep | NC | 1885-12-07 | 1887-03-03 | Democrat | 6 | |||||||||||||
15857 | 15857 | Henry Bingham B000469 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 1 | |||||||||||||
12878 | 12878 | Newton Blanchard B000541 | rep | LA | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
13582 | 13582 | Richard Bland B000544 | rep | MO | 1885-12-07 | 1887-03-03 | Democrat | 11 | |||||||||||||
11297 | 11297 | Archibald Bliss B000558 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
12093 | 12093 | James Blount B000568 | rep | GA | 1885-12-07 | 1887-03-03 | Democrat | 6 | |||||||||||||
11300 | 11300 | Franklin Bound B000667 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 14 | |||||||||||||
13872 | 13872 | Charles Boutelle B000673 | rep | ME | 1885-12-07 | 1887-03-03 | Republican | 4 | |||||||||||||
10972 | 10972 | Charles Boyle B000728 | rep | PA | 1885-12-07 | 1887-03-03 | Democrat | 21 | |||||||||||||
10973 | 10973 | James Brady B000752 | rep | VA | 1885-12-07 | 1887-03-03 | Republican | 4 | |||||||||||||
10977 | 10977 | Edward Bragg B000757 | rep | WI | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
12426 | 12426 | Clifton Breckinridge B000784 | rep | AR | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
12431 | 12431 | William Breckinridge B000790 | rep | KY | 1885-12-07 | 1887-03-03 | Democrat | 7 | |||||||||||||
11304 | 11304 | Charles Brown B000907 | rep | OH | 1885-12-07 | 1887-03-03 | Republican | 2 | |||||||||||||
10981 | 10981 | William Brown B000952 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 16 | |||||||||||||
11626 | 11626 | Thomas Browne B000958 | rep | IN | 1885-12-07 | 1887-03-03 | Republican | 6 | |||||||||||||
15000 | 15000 | Charles Brumm B000977 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 13 | |||||||||||||
12103 | 12103 | James Buchanan B001004 | rep | NJ | 1885-12-07 | 1887-03-03 | Republican | 2 | |||||||||||||
10983 | 10983 | John Buck B001018 | rep | CT | 1885-12-07 | 1887-03-03 | Republican | 1 | |||||||||||||
11309 | 11309 | Frank Bunnell B001064 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 15 | |||||||||||||
10985 | 10985 | Henry Burleigh B001106 | rep | NY | 1885-12-07 | 1887-03-03 | Republican | 18 | |||||||||||||
11633 | 11633 | James Burnes B001116 | rep | MO | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
14606 | 14606 | Julius Burrows B001142 | rep | MI | 1885-12-07 | 1887-03-03 | Republican | 4 | |||||||||||||
11641 | 11641 | Benjamin Butterworth B001200 | rep | OH | 1885-12-07 | 1887-03-03 | Republican | 1 | |||||||||||||
12456 | 12456 | William Bynum B001205 | rep | IN | 1885-12-07 | 1887-03-03 | Democrat | 7 | |||||||||||||
10991 | 10991 | George Cabell C000004 | rep | VA | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
12119 | 12119 | John Caine C000023 | rep | UT | 1885-12-07 | 1887-03-03 | Democrat | -1 | |||||||||||||
10993 | 10993 | Andrew Caldwell C000028 | rep | TN | 1885-12-07 | 1887-03-03 | Democrat | 6 | |||||||||||||
12467 | 12467 | Johnson Camden C000062 | sen | WV | 1881-12-05 | 1887-03-03 | 1 | Democrat | |||||||||||||
11645 | 11645 | Felix Campbell C000082 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
10997 | 10997 | Jacob Campbell C000086 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 17 | |||||||||||||
11318 | 11318 | James Campbell C000087 | rep | OH | 1885-12-07 | 1887-03-03 | Democrat | 3 | |||||||||||||
12471 | 12471 | Timothy Campbell C000103 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 8 | |||||||||||||
11649 | 11649 | Allen Candler C000109 | rep | GA | 1885-12-07 | 1887-03-03 | Democrat | 9 | |||||||||||||
18099 | 18099 | Joseph Cannon C000121 | rep | IL | 1885-12-07 | 1887-03-03 | Republican | 15 | |||||||||||||
12052 | 12052 | Joseph Carey C000145 | rep | WY | 1885-12-07 | 1887-03-03 | Republican | 0 | |||||||||||||
10999 | 10999 | Ezra Carleton C000147 | rep | MI | 1885-12-07 | 1887-03-03 | Democrat | 7 | |||||||||||||
12060 | 12060 | John Carlisle C000152 | rep | KY | 1885-12-07 | 1887-03-03 | Democrat | 6 | |||||||||||||
11661 | 11661 | Lucien Caswell C000245 | rep | WI | 1885-12-07 | 1887-03-03 | Republican | 1 | |||||||||||||
13598 | 13598 | Thomas Catchings C000247 | rep | MS | 1885-12-07 | 1887-03-03 | Democrat | 3 | |||||||||||||
11323 | 11323 | Martin Clardy C000417 | rep | MO | 1885-12-07 | 1887-03-03 | Democrat | 10 | |||||||||||||
11670 | 11670 | Judson Clements C000508 | rep | GA | 1885-12-07 | 1887-03-03 | Democrat | 7 | |||||||||||||
11007 | 11007 | Thomas Cobb C000552 | rep | IN | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
13617 | 13617 | Francis Cockrell C000576 | sen | MO | 1881-12-05 | 1887-03-03 | 1 | Democrat | |||||||||||||
11008 | 11008 | William Cole C000615 | rep | MD | 1885-12-07 | 1887-03-03 | Democrat | 3 | |||||||||||||
11326 | 11326 | Patrick Collins C000641 | rep | MA | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
12493 | 12493 | Barnes Compton C000660 | rep | MD | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
11009 | 11009 | Charles Comstock C000662 | rep | MI | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
11682 | 11682 | Edwin Conger C000675 | rep | IA | 1885-12-07 | 1887-03-03 | Republican | 7 | |||||||||||||
10305 | 10305 | Omar Conger C000678 | sen | MI | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
11686 | 11686 | William Cooper C000765 | rep | OH | 1885-12-07 | 1887-03-03 | Republican | 9 | |||||||||||||
12139 | 12139 | William Cowles C000829 | rep | NC | 1885-12-07 | 1887-03-03 | Democrat | 8 | |||||||||||||
11703 | 11703 | Samuel Cox C000839 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 9 | |||||||||||||
11012 | 11012 | William Cox C000841 | rep | NC | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
12965 | 12965 | William Crain C000865 | rep | TX | 1885-12-07 | 1887-03-03 | Democrat | 7 | |||||||||||||
12972 | 12972 | Charles Crisp C000908 | rep | GA | 1885-12-07 | 1887-03-03 | Democrat | 3 | |||||||||||||
11013 | 11013 | Thomas Croxton C000950 | rep | VA | 1885-12-07 | 1887-03-03 | Democrat | 1 | |||||||||||||
12985 | 12985 | David Culberson C000964 | rep | TX | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
11016 | 11016 | Andrew Curtin C001004 | rep | PA | 1885-12-07 | 1887-03-03 | Democrat | 20 | |||||||||||||
11709 | 11709 | Byron Cutcheon C001022 | rep | MI | 1885-12-07 | 1887-03-03 | Republican | 9 | |||||||||||||
14626 | 14626 | John Daniel D000035 | rep | VA | 1885-12-07 | 1887-03-03 | Democrat | 6 | |||||||||||||
11713 | 11713 | George Dargan D000053 | rep | SC | 1885-12-07 | 1887-03-03 | Democrat | 6 | |||||||||||||
11329 | 11329 | Ira Davenport D000072 | rep | NY | 1885-12-07 | 1887-03-03 | Republican | 29 | |||||||||||||
11331 | 11331 | Alexander Davidson D000082 | rep | AL | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
11722 | 11722 | Robert Davidson D000085 | rep | FL | 1885-12-07 | 1887-03-03 | Democrat | 1 | |||||||||||||
11334 | 11334 | Robert Davis D000130 | rep | MA | 1885-12-07 | 1887-03-03 | Republican | 1 | |||||||||||||
11346 | 11346 | Henry Dawes D000148 | sen | MA | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
11017 | 11017 | William Dawson D000154 | rep | MO | 1885-12-07 | 1887-03-03 | Democrat | 14 | |||||||||||||
11730 | 11730 | Samuel Dibble D000300 | rep | SC | 1885-12-07 | 1887-03-03 | Democrat | 1 | |||||||||||||
13644 | 13644 | Nelson Dingley D000356 | rep | ME | 1885-12-07 | 1887-03-03 | Republican | 2 | |||||||||||||
13291 | 13291 | Alexander Dockery D000384 | rep | MO | 1885-12-07 | 1887-03-03 | Democrat | 3 | |||||||||||||
11737 | 11737 | George Dorsey D000439 | rep | NE | 1885-12-07 | 1887-03-03 | Republican | 3 | |||||||||||||
11348 | 11348 | Charles Dougherty D000445 | rep | FL | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
11018 | 11018 | Abraham Dowdney D000465 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 12 | |||||||||||||
11351 | 11351 | Ransom Dunham D000541 | rep | IL | 1885-12-07 | 1887-03-03 | Republican | 1 | |||||||||||||
11356 | 11356 | Poindexter Dunn D000552 | rep | AR | 1885-12-07 | 1887-03-03 | Democrat | 1 | |||||||||||||
11023 | 11023 | John Eden E000042 | rep | IL | 1885-12-07 | 1887-03-03 | Democrat | 17 | |||||||||||||
11361 | 11361 | George Edmunds E000056 | sen | VT | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
11025 | 11025 | Nathaniel Eldredge E000104 | rep | MI | 1885-12-07 | 1887-03-03 | Democrat | 2 |
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);