legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
411 rows where "start" is on date 1895-12-02 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: state, end, class, party, end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20955 | 20955 | Henry Tucker T000399 | rep | VA | 1895-12-02 | 1897-03-03 | Democrat | 10 | |||||||||||||
20260 | 20260 | Charles Crisp C000909 | rep | GA | 1895-12-02 | 1897-03-03 | Democrat | 3 | |||||||||||||
20232 | 20232 | Henry Cooper C000752 | rep | WI | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
20008 | 20008 | Claude Swanson S001094 | rep | VA | 1895-12-02 | 1897-03-03 | Democrat | 5 | |||||||||||||
19556 | 19556 | Theodore Burton B001159 | rep | OH | 1895-12-02 | 1897-03-03 | Republican | 21 | |||||||||||||
19530 | 19530 | James Watson W000203 | rep | IN | 1895-12-02 | 1897-03-03 | Republican | 4 | |||||||||||||
19270 | 19270 | Charles Curtis C001008 | rep | KS | 1895-12-02 | 1897-03-03 | Republican | 4 | |||||||||||||
19151 | 19151 | Francis Warren W000164 | sen | WY | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
18960 | 18960 | Frederick Gillett G000201 | rep | MA | 1895-12-02 | 1897-03-03 | Republican | 2 | |||||||||||||
18934 | 18934 | Benjamin Fairchild F000004 | rep | NY | 1895-12-02 | 1897-03-03 | Republican | 16 | |||||||||||||
18524 | 18524 | Oscar Underwood U000013 | rep | AL | 1895-12-02 | 1897-03-03 | Democrat | 9 | |||||||||||||
18401 | 18401 | Richard Parker P000070 | rep | NJ | 1895-12-02 | 1897-03-03 | Republican | 6 | |||||||||||||
18359 | 18359 | Franklin Mondell M000852 | rep | WY | 1895-12-02 | 1897-03-03 | Republican | 0 | |||||||||||||
18103 | 18103 | Joseph Cannon C000121 | rep | IL | 1895-12-02 | 1897-03-03 | Republican | 12 | |||||||||||||
18033 | 18033 | William Andrews A000251 | rep | NE | 1895-12-02 | 1897-03-03 | Republican | 5 | |||||||||||||
17863 | 17863 | Knute Nelson N000040 | sen | MN | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
17698 | 17698 | John Fitzgerald F000164 | rep | MA | 1895-12-02 | 1897-03-03 | Democrat | 9 | |||||||||||||
17550 | 17550 | John Bankhead B000110 | rep | AL | 1895-12-02 | 1897-03-03 | Democrat | 6 | |||||||||||||
17505 | 17505 | John Williams W000521 | rep | MS | 1895-12-02 | 1897-03-03 | Democrat | 5 | |||||||||||||
17457 | 17457 | Cyrus Sulloway S001063 | rep | NH | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
17311 | 17311 | William Jones J000259 | rep | VA | 1895-12-02 | 1897-03-03 | Democrat | 1 | |||||||||||||
17273 | 17273 | Ebenezer Hill H000591 | rep | CT | 1895-12-02 | 1897-03-03 | Republican | 4 | |||||||||||||
17195 | 17195 | George Foss F000295 | rep | IL | 1895-12-02 | 1897-03-03 | Republican | 7 | |||||||||||||
16987 | 16987 | Stephen Sparkman S000702 | rep | FL | 1895-12-02 | 1897-03-03 | Democrat | 1 | |||||||||||||
16905 | 16905 | Francis Newlands N000069 | rep | NV | 1895-12-02 | 1897-03-03 | Democrat | 0 | |||||||||||||
16615 | 16615 | Benjamin Tillman T000274 | sen | SC | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
16578 | 16578 | William Smith S000629 | rep | MI | 1895-12-02 | 1897-03-03 | Republican | 5 | |||||||||||||
16559 | 16559 | John Shafroth S000279 | rep | CO | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
16514 | 16514 | Sereno Payne P000153 | rep | NY | 1895-12-02 | 1897-03-03 | Republican | 28 | |||||||||||||
16471 | 16471 | Thomas Martin M000200 | sen | VA | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
16273 | 16273 | Charles Bartlett B000199 | rep | GA | 1895-12-02 | 1897-03-03 | Democrat | 6 | |||||||||||||
16263 | 16263 | Richard Bartholdt B000196 | rep | MO | 1895-12-02 | 1897-03-03 | Republican | 10 | |||||||||||||
16256 | 16256 | Augustus Bacon B000014 | sen | GA | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
16243 | 16243 | Thomas Catron C000253 | rep | NM | 1895-12-02 | 1897-03-03 | Republican | -1 | |||||||||||||
16195 | 16195 | William Sulzer S001065 | rep | NY | 1895-12-02 | 1897-03-03 | Democrat | 11 | |||||||||||||
16150 | 16150 | George Prince P000538 | rep | IL | 1895-12-02 | 1897-03-03 | Republican | 10 | |||||||||||||
16082 | 16082 | Samuel McCall M000305 | rep | MA | 1895-12-02 | 1897-03-03 | Republican | 8 | |||||||||||||
16057 | 16057 | Henry Loudenslager L000450 | rep | NJ | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
15997 | 15997 | Edward Henry H000505 | rep | CT | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
15973 | 15973 | John Gardner G000057 | rep | NJ | 1895-12-02 | 1897-03-03 | Republican | 2 | |||||||||||||
15921 | 15921 | John Dalzell D000016 | rep | PA | 1895-12-02 | 1897-03-03 | Republican | 22 | |||||||||||||
15895 | 15895 | Clarence Clark C000425 | sen | WY | 1895-12-02 | 1899-03-03 | 1 | Republican | |||||||||||||
15862 | 15862 | Henry Bingham B000469 | rep | PA | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
15803 | 15803 | Irving Wanger W000122 | rep | PA | 1895-12-02 | 1897-03-03 | Republican | 7 | |||||||||||||
15771 | 15771 | James Tawney T000060 | rep | MN | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
15746 | 15746 | Nehemiah Sperry S000733 | rep | CT | 1895-12-02 | 1897-03-03 | Republican | 2 | |||||||||||||
15739 | 15739 | George Southwick S000691 | rep | NY | 1895-12-02 | 1897-03-03 | Republican | 20 | |||||||||||||
15641 | 15641 | James McLachlan M000532 | rep | CA | 1895-12-02 | 1897-03-03 | Republican | 6 | |||||||||||||
15610 | 15610 | William Lorimer L000444 | rep | IL | 1895-12-02 | 1897-03-03 | Republican | 2 | |||||||||||||
15602 | 15602 | Leonidas Livingston L000368 | rep | GA | 1895-12-02 | 1897-03-03 | Democrat | 5 | |||||||||||||
15560 | 15560 | Martin Johnson J000162 | rep | ND | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
15548 | 15548 | John Hull H000942 | rep | IA | 1895-12-02 | 1897-03-03 | Republican | 7 | |||||||||||||
15540 | 15540 | George Huff H000911 | rep | PA | 1895-12-02 | 1897-03-03 | Republican | -1 | |||||||||||||
15529 | 15529 | Benjamin Howell H000857 | rep | NJ | 1895-12-02 | 1897-03-03 | Republican | 3 | |||||||||||||
15492 | 15492 | Joseph Graff G000351 | rep | IL | 1895-12-02 | 1897-03-03 | Republican | 14 | |||||||||||||
15459 | 15459 | Charles Fowler F000320 | rep | NJ | 1895-12-02 | 1897-03-03 | Republican | 8 | |||||||||||||
15442 | 15442 | William Ellis E000138 | rep | OR | 1895-12-02 | 1897-03-03 | Republican | 2 | |||||||||||||
15421 | 15421 | David De Armond D000167 | rep | MO | 1895-12-02 | 1897-03-03 | Democrat | 6 | |||||||||||||
15368 | 15368 | William Calderhead C000026 | rep | KS | 1895-12-02 | 1897-03-03 | Republican | 5 | |||||||||||||
15320 | 15320 | George Wetmore W000312 | sen | RI | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
15292 | 15292 | George Smith S000541 | rep | IL | 1895-12-02 | 1897-03-03 | Republican | 22 | |||||||||||||
15279 | 15279 | James Sherman S000345 | rep | NY | 1895-12-02 | 1897-03-03 | Republican | 25 | |||||||||||||
15261 | 15261 | John Reyburn R000168 | rep | PA | 1895-12-02 | 1897-03-03 | Republican | 4 | |||||||||||||
15237 | 15237 | Jesse Overstreet O000144 | rep | IN | 1895-12-02 | 1897-03-03 | Republican | 5 | |||||||||||||
15227 | 15227 | Adolph Meyer M000679 | rep | LA | 1895-12-02 | 1897-03-03 | Democrat | 1 | |||||||||||||
15164 | 15164 | John Jenkins J000084 | rep | WI | 1895-12-02 | 1897-03-03 | Republican | 10 | |||||||||||||
15146 | 15146 | William Hepburn H000523 | rep | IA | 1895-12-02 | 1897-03-03 | Republican | 8 | |||||||||||||
15120 | 15120 | Robert Gamble G000032 | rep | SD | 1895-12-02 | 1897-03-03 | Republican | -1 | |||||||||||||
15110 | 15110 | William Frye F000398 | sen | ME | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
15095 | 15095 | Stephen Elkins E000110 | sen | WV | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
15084 | 15084 | Jonathan Dolliver D000404 | rep | IA | 1895-12-02 | 1897-03-03 | Republican | 10 | |||||||||||||
15061 | 15061 | Shelby Cullom C000973 | sen | IL | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
15043 | 15043 | Robert Cousins C000811 | rep | IA | 1895-12-02 | 1897-03-03 | Republican | 5 | |||||||||||||
15036 | 15036 | Samuel Cooper C000761 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 2 | |||||||||||||
15002 | 15002 | Charles Brumm B000977 | rep | PA | 1895-12-02 | 1897-03-03 | Republican | 13 | |||||||||||||
14971 | 14971 | Joseph Bailey B000044 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 5 | |||||||||||||
14962 | 14962 | Ernest Acheson A000019 | rep | PA | 1895-12-02 | 1897-03-03 | Republican | 24 | |||||||||||||
14936 | 14936 | James Wadsworth W000011 | rep | NY | 1895-12-02 | 1897-03-03 | Republican | 30 | |||||||||||||
14918 | 14918 | Charles Towne T000324 | rep | NY | 1895-12-02 | 1897-03-03 | Republican | -1 | |||||||||||||
14908 | 14908 | James Southard S000687 | rep | OH | 1895-12-02 | 1897-03-03 | Republican | 9 | |||||||||||||
14875 | 14875 | Samuel Robertson R000324 | rep | LA | 1895-12-02 | 1897-03-03 | Democrat | 6 | |||||||||||||
14848 | 14848 | Theobald Otjen O000132 | rep | WI | 1895-12-02 | 1897-03-03 | Republican | 4 | |||||||||||||
14837 | 14837 | Hernando Money M000854 | rep | MS | 1895-12-02 | 1897-03-03 | Democrat | 4 | |||||||||||||
14825 | 14825 | Edward Minor M000798 | rep | WI | 1895-12-02 | 1897-03-03 | Republican | 8 | |||||||||||||
14812 | 14812 | James McCleary M000326 | rep | MN | 1895-12-02 | 1897-03-03 | Republican | 2 | |||||||||||||
14804 | 14804 | Benjamin Marsh M000145 | rep | IL | 1895-12-02 | 1897-03-03 | Republican | 15 | |||||||||||||
14794 | 14794 | Thaddeus Mahon M000066 | rep | PA | 1895-12-02 | 1897-03-03 | Republican | 18 | |||||||||||||
14787 | 14787 | John Little L000352 | rep | AR | 1895-12-02 | 1897-03-03 | Democrat | 2 | |||||||||||||
14774 | 14774 | Rufus Lester L000255 | rep | GA | 1895-12-02 | 1897-03-03 | Democrat | 1 | |||||||||||||
14762 | 14762 | John Lacey L000010 | rep | IA | 1895-12-02 | 1897-03-03 | Republican | 6 | |||||||||||||
14722 | 14722 | Robert Hitt H000649 | rep | IL | 1895-12-02 | 1897-03-03 | Republican | 9 | |||||||||||||
14712 | 14712 | Binger Hermann H000531 | rep | OR | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
14701 | 14701 | James Hemenway H000467 | rep | IN | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
14679 | 14679 | Charles Grosvenor G000497 | rep | OH | 1895-12-02 | 1897-03-03 | Republican | 11 | |||||||||||||
14657 | 14657 | Loren Fletcher F000202 | rep | MN | 1895-12-02 | 1897-03-03 | Republican | 5 | |||||||||||||
14644 | 14644 | Blackburn Dovener D000461 | rep | WV | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
14632 | 14632 | Alston Dayton D000163 | rep | WV | 1895-12-02 | 1897-03-03 | Republican | 2 | |||||||||||||
14617 | 14617 | Thomas Carter C000200 | sen | MT | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
14611 | 14611 | Julius Burrows B001142 | sen | MI | 1895-12-02 | 1899-03-03 | 1 | Republican | |||||||||||||
14575 | 14575 | Roswell Bishop B000489 | rep | MI | 1895-12-02 | 1897-03-03 | Republican | 9 |
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);