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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10305 | 10305 | Omar Conger C000678 | sen | MI | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
10343 | 10343 | James Fair F000002 | sen | NV | 1881-12-05 | 1887-03-03 | 1 | Democrat | |||||||||||||
10401 | 10401 | Howell Jackson J000014 | sen | TN | 1881-12-05 | 1887-03-03 | 1 | Democrat | |||||||||||||
10405 | 10405 | Charles Jones J000214 | sen | FL | 1881-12-05 | 1887-03-03 | 1 | Democrat | |||||||||||||
10441 | 10441 | William Mahone M000067 | sen | VA | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
10447 | 10447 | Samuel Maxey M000265 | sen | TX | 1881-12-05 | 1887-03-03 | 1 | Democrat | |||||||||||||
10463 | 10463 | Samuel McMillan M000570 | sen | MN | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
10464 | 10464 | John Miller M000740 | sen | CA | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
10466 | 10466 | Warner Miller M000760 | sen | NY | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
10469 | 10469 | John Mitchell M000819 | sen | PA | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
10583 | 10583 | Charles Van Wyck V000067 | sen | NE | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
10838 | 10838 | Austin Pike P000345 | sen | NH | 1883-12-03 | 1887-03-03 | 2 | Republican | |||||||||||||
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 | |||||||||||||
10958 | 10958 | Charles Anderson A000185 | rep | OH | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
10960 | 10960 | John Arnot A000301 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 28 | |||||||||||||
10962 | 10962 | John Ballentine B000105 | rep | TN | 1885-12-07 | 1887-03-03 | Democrat | 7 | |||||||||||||
10964 | 10964 | Ethelbert Barksdale B000146 | rep | MS | 1885-12-07 | 1887-03-03 | Democrat | 7 | |||||||||||||
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 | |||||||||||||
10970 | 10970 | Risden Bennett B000381 | rep | NC | 1885-12-07 | 1887-03-03 | Democrat | 6 | |||||||||||||
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 | |||||||||||||
10981 | 10981 | William Brown B000952 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 16 | |||||||||||||
10983 | 10983 | John Buck B001018 | rep | CT | 1885-12-07 | 1887-03-03 | Republican | 1 | |||||||||||||
10985 | 10985 | Henry Burleigh B001106 | rep | NY | 1885-12-07 | 1887-03-03 | Republican | 18 | |||||||||||||
10991 | 10991 | George Cabell C000004 | rep | VA | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
10993 | 10993 | Andrew Caldwell C000028 | rep | TN | 1885-12-07 | 1887-03-03 | Democrat | 6 | |||||||||||||
10997 | 10997 | Jacob Campbell C000086 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 17 | |||||||||||||
10999 | 10999 | Ezra Carleton C000147 | rep | MI | 1885-12-07 | 1887-03-03 | Democrat | 7 | |||||||||||||
11007 | 11007 | Thomas Cobb C000552 | rep | IN | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
11008 | 11008 | William Cole C000615 | rep | MD | 1885-12-07 | 1887-03-03 | Democrat | 3 | |||||||||||||
11009 | 11009 | Charles Comstock C000662 | rep | MI | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
11012 | 11012 | William Cox C000841 | rep | NC | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
11013 | 11013 | Thomas Croxton C000950 | rep | VA | 1885-12-07 | 1887-03-03 | Democrat | 1 | |||||||||||||
11016 | 11016 | Andrew Curtin C001004 | rep | PA | 1885-12-07 | 1887-03-03 | Democrat | 20 | |||||||||||||
11017 | 11017 | William Dawson D000154 | rep | MO | 1885-12-07 | 1887-03-03 | Democrat | 14 | |||||||||||||
11018 | 11018 | Abraham Dowdney D000465 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 12 | |||||||||||||
11023 | 11023 | John Eden E000042 | rep | IL | 1885-12-07 | 1887-03-03 | Democrat | 17 | |||||||||||||
11025 | 11025 | Nathaniel Eldredge E000104 | rep | MI | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
11026 | 11026 | William Ellsberry E000143 | rep | OH | 1885-12-07 | 1887-03-03 | Democrat | 11 | |||||||||||||
11028 | 11028 | Reuben Ellwood E000151 | rep | IL | 1885-12-07 | 1887-03-03 | Republican | 5 | |||||||||||||
11029 | 11029 | Frederick Ely E000165 | rep | MA | 1885-12-07 | 1887-03-03 | Republican | 9 | |||||||||||||
11034 | 11034 | Isaac Evans E000244 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 7 | |||||||||||||
11037 | 11037 | James Everhart E000270 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 6 | |||||||||||||
11039 | 11039 | John Findlay F000121 | rep | MD | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
11040 | 11040 | George Fleeger F000193 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 26 | |||||||||||||
11041 | 11041 | George Ford F000259 | rep | IN | 1885-12-07 | 1887-03-03 | Democrat | 13 | |||||||||||||
11043 | 11043 | Benjamin Frederick F000357 | rep | IA | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
11047 | 11047 | George Geddes G000115 | rep | OH | 1885-12-07 | 1887-03-03 | Democrat | 16 | |||||||||||||
11049 | 11049 | Eustace Gibson G000160 | rep | WV | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
11050 | 11050 | John Gilfillan G000186 | rep | MN | 1885-12-07 | 1887-03-03 | Republican | 4 | |||||||||||||
11051 | 11051 | Robert Green G000416 | rep | NJ | 1885-12-07 | 1887-03-03 | Democrat | 3 | |||||||||||||
11053 | 11053 | Wharton Green G000419 | rep | NC | 1885-12-07 | 1887-03-03 | Democrat | 3 | |||||||||||||
11055 | 11055 | Michael Hahn H000019 | rep | LA | 1885-12-07 | 1887-03-03 | Republican | 2 | |||||||||||||
11057 | 11057 | John Hailey H000023 | rep | ID | 1885-12-07 | 1887-03-03 | Democrat | -1 | |||||||||||||
11058 | 11058 | John Hale H000033 | rep | MO | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
11059 | 11059 | Benton Hall H000044 | rep | IA | 1885-12-07 | 1887-03-03 | Democrat | 1 | |||||||||||||
11061 | 11061 | John Halsell H000086 | rep | KY | 1885-12-07 | 1887-03-03 | Democrat | 3 | |||||||||||||
11065 | 11065 | Nathaniel Hammond H000130 | rep | GA | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
11069 | 11069 | Lewis Hanback H000142 | rep | KS | 1885-12-07 | 1887-03-03 | Republican | 6 | |||||||||||||
11073 | 11073 | Henry Harris H000239 | rep | GA | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
11075 | 11075 | Martin Haynes H000400 | rep | NH | 1885-12-07 | 1887-03-03 | Republican | 1 | |||||||||||||
11077 | 11077 | Barclay Henley H000498 | rep | CA | 1885-12-07 | 1887-03-03 | Democrat | 1 | |||||||||||||
11082 | 11082 | Abram Hewitt H000552 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 10 | |||||||||||||
11085 | 11085 | William Hill H000609 | rep | OH | 1885-12-07 | 1887-03-03 | Democrat | 6 | |||||||||||||
11089 | 11089 | Alfred Irion I000031 | rep | LA | 1885-12-07 | 1887-03-03 | Democrat | 6 | |||||||||||||
11091 | 11091 | Darwin James J000048 | rep | NY | 1885-12-07 | 1887-03-03 | Republican | 3 | |||||||||||||
11093 | 11093 | Frederick Johnson J000131 | rep | NY | 1885-12-07 | 1887-03-03 | Republican | 21 | |||||||||||||
11095 | 11095 | James Jones J000230 | rep | TX | 1885-12-07 | 1887-03-03 | Democrat | 3 | |||||||||||||
11099 | 11099 | John King K000206 | rep | LA | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
11101 | 11101 | John Kleiner K000263 | rep | IN | 1885-12-07 | 1887-03-03 | Democrat | 1 | |||||||||||||
11105 | 11105 | Benjamin Le Fevre L000159 | rep | OH | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
11107 | 11107 | Harry Libbey L000298 | rep | VA | 1885-12-07 | 1887-03-03 | Republican | 2 | |||||||||||||
11108 | 11108 | James Lindsley L000329 | rep | NY | 1885-12-07 | 1887-03-03 | Republican | 17 | |||||||||||||
11109 | 11109 | John Little L000351 | rep | OH | 1885-12-07 | 1887-03-03 | Republican | 8 | |||||||||||||
11116 | 11116 | John Logan L000403 | sen | IL | 1885-12-07 | 1887-03-03 | 3 | Republican | |||||||||||||
11118 | 11118 | Charles Lore L000443 | rep | DE | 1885-12-07 | 1887-03-03 | Democrat | 0 | |||||||||||||
11119 | 11119 | James Louttit L000453 | rep | CA | 1885-12-07 | 1887-03-03 | Republican | 2 | |||||||||||||
11121 | 11121 | Henry Lovering L000464 | rep | MA | 1885-12-07 | 1887-03-03 | Democrat | 6 | |||||||||||||
11123 | 11123 | Robert Lowry L000487 | rep | IN | 1885-12-07 | 1887-03-03 | Democrat | 12 | |||||||||||||
11124 | 11124 | Henry Markham M000134 | rep | CA | 1885-12-07 | 1887-03-03 | Republican | 6 | |||||||||||||
11125 | 11125 | John Martin M000188 | rep | AL | 1885-12-07 | 1887-03-03 | Democrat | 6 | |||||||||||||
11127 | 11127 | William Maybury M000280 | rep | MI | 1885-12-07 | 1887-03-03 | Democrat | 1 | |||||||||||||
11129 | 11129 | Stephen Millard M000711 | rep | NY | 1885-12-07 | 1887-03-03 | Republican | 26 | |||||||||||||
11131 | 11131 | James Miller M000732 | rep | TX | 1885-12-07 | 1887-03-03 | Democrat | 8 | |||||||||||||
11133 | 11133 | Charles Mitchell M000807 | rep | CT | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
11141 | 11141 | William Morrison M001000 | rep | IL | 1885-12-07 | 1887-03-03 | Democrat | 18 | |||||||||||||
11143 | 11143 | Jeremiah Murphy M001096 | rep | IA | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
11145 | 11145 | William Neece N000020 | rep | IL | 1885-12-07 | 1887-03-03 | Democrat | 11 | |||||||||||||
11149 | 11149 | James Negley N000024 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 22 | |||||||||||||
11151 | 11151 | James O’Hara O000054 | rep | NC | 1885-12-07 | 1887-03-03 | Republican | 2 | |||||||||||||
11156 | 11156 | Augustus Pettibone P000269 | rep | TN | 1885-12-07 | 1887-03-03 | Republican | 1 | |||||||||||||
11157 | 11157 | William Pirce P000365 | rep | RI | 1885-12-07 | 1887-03-03 | Republican | 2 | |||||||||||||
11158 | 11158 | Hugh Price P000526 | rep | WI | 1885-12-07 | 1887-03-03 | Republican | 8 | |||||||||||||
11160 | 11160 | William Price P000534 | rep | WI | 1885-12-07 | 1887-03-03 | Republican | 8 | |||||||||||||
11161 | 11161 | Joseph Pulitzer P000568 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 9 | |||||||||||||
11163 | 11163 | Joseph Rankin R000057 | rep | WI | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
11166 | 11166 | Ambrose Ranney R000058 | rep | MA | 1885-12-07 | 1887-03-03 | Republican | 3 |
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);