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 party
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
10447 | 10447 | Samuel Maxey M000265 | sen | TX | 1881-12-05 | 1887-03-03 | 1 | Democrat | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
10977 | 10977 | Edward Bragg B000757 | rep | WI | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
11039 | 11039 | John Findlay F000121 | rep | MD | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
11073 | 11073 | Henry Harris H000239 | rep | GA | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
11118 | 11118 | Charles Lore L000443 | rep | DE | 1885-12-07 | 1887-03-03 | Democrat | 0 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
11169 | 11169 | Seaborn Reese R000136 | rep | GA | 1885-12-07 | 1887-03-03 | Democrat | 8 | |||||||||||||
11171 | 11171 | James Reid R000148 | rep | NC | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
11178 | 11178 | James Riggs R000253 | rep | IL | 1885-12-07 | 1887-03-03 | Democrat | 12 | |||||||||||||
11180 | 11180 | Thomas Robertson R000325 | rep | KY | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
11181 | 11181 | Thomas Sadler S000010 | rep | AL | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
11186 | 11186 | Edward Seymour S000266 | rep | CT | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
11195 | 11195 | Otho Singleton S000445 | rep | MS | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
11202 | 11202 | John Spriggs S000754 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 23 | |||||||||||||
11206 | 11206 | Louis St. Martin S000768 | rep | LA | 1885-12-07 | 1887-03-03 | Democrat | 1 | |||||||||||||
11213 | 11213 | John Storm S000975 | rep | PA | 1885-12-07 | 1887-03-03 | Democrat | 11 | |||||||||||||
11222 | 11222 | John Swope S001128 | rep | PA | 1885-12-07 | 1887-03-03 | Democrat | 19 | |||||||||||||
11225 | 11225 | John Taylor T000090 | rep | TN | 1885-12-07 | 1887-03-03 | Democrat | 8 | |||||||||||||
11230 | 11230 | James Throckmorton T000246 | rep | TX | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
11231 | 11231 | Connally Trigg T000369 | rep | VA | 1885-12-07 | 1887-03-03 | Democrat | 9 | |||||||||||||
11237 | 11237 | John Tucker T000401 | rep | VA | 1885-12-07 | 1887-03-03 | Democrat | 10 | |||||||||||||
11239 | 11239 | Henry Van Eaton V000038 | rep | MS | 1885-12-07 | 1887-03-03 | Democrat | 6 | |||||||||||||
11240 | 11240 | Egbert Viele V000097 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 13 | |||||||||||||
11252 | 11252 | Nathaniel Wallace W000081 | rep | LA | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
11253 | 11253 | James Ward W000134 | rep | IL | 1885-12-07 | 1887-03-03 | Democrat | 3 | |||||||||||||
11255 | 11255 | Thomas Ward W000142 | rep | IN | 1885-12-07 | 1887-03-03 | Democrat | 9 | |||||||||||||
11258 | 11258 | Adoniram Warner W000151 | rep | OH | 1885-12-07 | 1887-03-03 | Democrat | 17 | |||||||||||||
11264 | 11264 | Olin Wellborn W000272 | rep | TX | 1885-12-07 | 1887-03-03 | Democrat | 6 | |||||||||||||
11272 | 11272 | Albert Willis W000557 | rep | KY | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
11276 | 11276 | Edwin Winans W000625 | rep | MI | 1885-12-07 | 1887-03-03 | Democrat | 6 | |||||||||||||
11278 | 11278 | Frank Wolford W000681 | rep | KY | 1885-12-07 | 1887-03-03 | Democrat | 11 | |||||||||||||
11280 | 11280 | Nicholas Worthington W000749 | rep | IL | 1885-12-07 | 1887-03-03 | Democrat | 10 | |||||||||||||
11287 | 11287 | Frederick Barry B000188 | rep | MS | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
11291 | 11291 | Perry Belmont B000353 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 1 | |||||||||||||
11297 | 11297 | Archibald Bliss B000558 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
11318 | 11318 | James Campbell C000087 | rep | OH | 1885-12-07 | 1887-03-03 | Democrat | 3 | |||||||||||||
11323 | 11323 | Martin Clardy C000417 | rep | MO | 1885-12-07 | 1887-03-03 | Democrat | 10 | |||||||||||||
11326 | 11326 | Patrick Collins C000641 | rep | MA | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
11331 | 11331 | Alexander Davidson D000082 | rep | AL | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
11348 | 11348 | Charles Dougherty D000445 | rep | FL | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
11356 | 11356 | Poindexter Dunn D000552 | rep | AR | 1885-12-07 | 1887-03-03 | Democrat | 1 | |||||||||||||
11368 | 11368 | Spencer Fisher F000153 | rep | MI | 1885-12-07 | 1887-03-03 | Democrat | 10 | |||||||||||||
11371 | 11371 | Martin Foran F000254 | rep | OH | 1885-12-07 | 1887-03-03 | Democrat | 21 | |||||||||||||
11377 | 11377 | Presley Glass G000233 | rep | TN | 1885-12-07 | 1887-03-03 | Democrat | 9 | |||||||||||||
11379 | 11379 | John Glover G000244 | rep | MO | 1885-12-07 | 1887-03-03 | Democrat | 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);