legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
370 rows where "start" is on date 1885-12-07
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11181 | 11181 | Thomas Sadler S000010 | rep | AL | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
11184 | 11184 | Walter Sessions S000251 | rep | NY | 1885-12-07 | 1887-03-03 | Republican | 34 | |||||||||||||
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 | |||||||||||||
11200 | 11200 | Robert Smalls S000502 | rep | SC | 1885-12-07 | 1887-03-03 | Republican | 7 | |||||||||||||
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 | |||||||||||||
11209 | 11209 | Eben Stone S000956 | rep | MA | 1885-12-07 | 1887-03-03 | Republican | 7 | |||||||||||||
11213 | 11213 | John Storm S000975 | rep | PA | 1885-12-07 | 1887-03-03 | Democrat | 11 | |||||||||||||
11219 | 11219 | Horace Strait S000988 | rep | MN | 1885-12-07 | 1887-03-03 | Republican | 3 | |||||||||||||
11220 | 11220 | John Swinburne S001120 | rep | NY | 1885-12-07 | 1887-03-03 | Republican | 19 | |||||||||||||
11222 | 11222 | John Swope S001128 | rep | PA | 1885-12-07 | 1887-03-03 | Democrat | 19 | |||||||||||||
11223 | 11223 | Isaac Taylor T000081 | rep | OH | 1885-12-07 | 1887-03-03 | Republican | 18 | |||||||||||||
11225 | 11225 | John Taylor T000090 | rep | TN | 1885-12-07 | 1887-03-03 | Democrat | 8 | |||||||||||||
11226 | 11226 | Zachary Taylor T000106 | rep | TN | 1885-12-07 | 1887-03-03 | Republican | 10 | |||||||||||||
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 | |||||||||||||
11243 | 11243 | William Wadsworth W000015 | rep | KY | 1885-12-07 | 1887-03-03 | Republican | 9 | |||||||||||||
11249 | 11249 | John Wait W000025 | rep | CT | 1885-12-07 | 1887-03-03 | Republican | 3 | |||||||||||||
11251 | 11251 | James Wakefield W000026 | rep | MN | 1885-12-07 | 1887-03-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
11260 | 11260 | Archibald Weaver W000223 | rep | NE | 1885-12-07 | 1887-03-03 | Republican | 1 | |||||||||||||
11264 | 11264 | Olin Wellborn W000272 | rep | TX | 1885-12-07 | 1887-03-03 | Democrat | 6 | |||||||||||||
11265 | 11265 | Alexander White W000354 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 25 | |||||||||||||
11267 | 11267 | Milo White W000387 | rep | MN | 1885-12-07 | 1887-03-03 | Republican | 1 | |||||||||||||
11272 | 11272 | Albert Willis W000557 | rep | KY | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
11274 | 11274 | Ephraim Wilson W000577 | sen | MD | 1885-12-07 | 1891-03-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
11283 | 11283 | Charles Allen A000116 | rep | MA | 1885-12-07 | 1887-03-03 | Republican | 8 | |||||||||||||
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 | |||||||||||||
11300 | 11300 | Franklin Bound B000667 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 14 | |||||||||||||
11304 | 11304 | Charles Brown B000907 | rep | OH | 1885-12-07 | 1887-03-03 | Republican | 2 | |||||||||||||
11309 | 11309 | Frank Bunnell B001064 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 15 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
11334 | 11334 | Robert Davis D000130 | rep | MA | 1885-12-07 | 1887-03-03 | Republican | 1 | |||||||||||||
11348 | 11348 | Charles Dougherty D000445 | rep | FL | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
11374 | 11374 | William Fuller F000414 | rep | IA | 1885-12-07 | 1887-03-03 | Republican | 4 | |||||||||||||
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 | |||||||||||||
11385 | 11385 | Richard Guenther G000516 | rep | WI | 1885-12-07 | 1887-03-03 | Republican | 6 | |||||||||||||
11388 | 11388 | Edward Hayden H000386 | rep | MA | 1885-12-07 | 1887-03-03 | Republican | 5 | |||||||||||||
11392 | 11392 | John Hiestand H000569 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 9 | |||||||||||||
11394 | 11394 | George Hires H000642 | rep | NJ | 1885-12-07 | 1887-03-03 | Republican | 1 | |||||||||||||
11400 | 11400 | Frank Hiscock H000643 | rep | NY | 1885-12-07 | 1887-03-03 | Republican | 25 | |||||||||||||
11404 | 11404 | Adoniram Holmes H000733 | rep | IA | 1885-12-07 | 1887-03-03 | Republican | 10 | |||||||||||||
11409 | 11409 | Jonas Howard H000842 | rep | IN | 1885-12-07 | 1887-03-03 | Democrat | 3 | |||||||||||||
11411 | 11411 | Thomas Hudd H000902 | rep | WI | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
11413 | 11413 | John Hutton H001019 | rep | MO | 1885-12-07 | 1887-03-03 | Democrat | 7 | |||||||||||||
11415 | 11415 | Oscar Jackson J000024 | rep | PA | 1885-12-07 | 1887-03-03 | Republican | 24 | |||||||||||||
11417 | 11417 | James Johnston J000188 | rep | IN | 1885-12-07 | 1887-03-03 | Republican | 8 | |||||||||||||
11419 | 11419 | Thomas Johnston J000199 | rep | NC | 1885-12-07 | 1887-03-03 | Democrat | 9 | |||||||||||||
11423 | 11423 | James Jones J000233 | rep | AL | 1885-12-07 | 1887-03-03 | Democrat | 1 | |||||||||||||
11426 | 11426 | Polk Laffoon L000016 | rep | KY | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
11428 | 11428 | Silas Landes L000048 | rep | IL | 1885-12-07 | 1887-03-03 | Democrat | 16 | |||||||||||||
11433 | 11433 | John Long L000423 | rep | MA | 1885-12-07 | 1887-03-03 | Republican | 2 | |||||||||||||
11435 | 11435 | Joseph Lyman L000526 | rep | IA | 1885-12-07 | 1887-03-03 | Republican | 9 | |||||||||||||
11440 | 11440 | Peter Mahoney M000068 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
11444 | 11444 | Courtland Matson M000248 | rep | IN | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
11448 | 11448 | Truman Merriman M000658 | rep | NY | 1885-12-07 | 1887-03-03 | Ind. Democrat | 11 | |||||||||||||
11450 | 11450 | Seth Moffatt M000837 | rep | MI | 1885-12-07 | 1887-03-03 | Republican | 11 | |||||||||||||
11457 | 11457 | John Neal N000013 | rep | TN | 1885-12-07 | 1887-03-03 | Democrat | 3 | |||||||||||||
11462 | 11462 | Thomas Norwood N000160 | rep | GA | 1885-12-07 | 1887-03-03 | Democrat | 1 | |||||||||||||
11468 | 11468 | Abraham Parker P000053 | rep | NY | 1885-12-07 | 1887-03-03 | Republican | 22 | |||||||||||||
11474 | 11474 | William Phelps P000302 | rep | NJ | 1885-12-07 | 1887-03-03 | Republican | 5 | |||||||||||||
11476 | 11476 | James Pidcock P000331 | rep | NJ | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
11478 | 11478 | Ralph Plumb P000390 | rep | IL | 1885-12-07 | 1887-03-03 | Republican | 8 | |||||||||||||
11488 | 11488 | John Reagan R000098 | rep | TX | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
11495 | 11495 | Jacob Romeis R000415 | rep | OH | 1885-12-07 | 1887-03-03 | Republican | 10 | |||||||||||||
11505 | 11505 | William Scott S000188 | rep | PA | 1885-12-07 | 1887-03-03 | Democrat | 27 | |||||||||||||
11508 | 11508 | Frank Shaw S000304 | rep | MD | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
11512 | 11512 | Charles Snyder S000665 | rep | WV | 1885-12-07 | 1887-03-03 | Democrat | 3 | |||||||||||||
11514 | 11514 | William Sowden S000692 | rep | PA | 1885-12-07 | 1887-03-03 | Democrat | 10 | |||||||||||||
11516 | 11516 | George Symes S001133 | rep | CO | 1885-12-07 | 1887-03-03 | Republican | 1 | |||||||||||||
11518 | 11518 | Timothy Tarsney T000044 | rep | MI | 1885-12-07 | 1887-03-03 | Democrat | 8 | |||||||||||||
11520 | 11520 | William Taulbee T000055 | rep | KY | 1885-12-07 | 1887-03-03 | Democrat | 10 | |||||||||||||
11526 | 11526 | John Thomas T000176 | rep | IL | 1885-12-07 | 1887-03-03 | Republican | 20 | |||||||||||||
11529 | 11529 | Joseph Toole T000312 | rep | MT | 1885-12-07 | 1887-03-03 | Democrat | -1 | |||||||||||||
11532 | 11532 | Charles Voorhees V000115 | rep | WA | 1885-12-07 | 1887-03-03 | Democrat | -1 | |||||||||||||
11535 | 11535 | James Weaver W000225 | rep | IA | 1885-12-07 | 1887-03-03 | National Greenbacker | 6 | |||||||||||||
11537 | 11537 | John Weber W000236 | rep | NY | 1885-12-07 | 1887-03-03 | Republican | 33 | |||||||||||||
11540 | 11540 | George West W000302 | rep | NY | 1885-12-07 | 1887-03-03 | Republican | 20 | |||||||||||||
11545 | 11545 | William Whiting W000418 | rep | MA | 1885-12-07 | 1887-03-03 | Republican | 11 |
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);