legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
339 rows where "start" is on date 1879-03-18 sorted by district
This data as json, copyable, CSV (advanced)
Suggested facets: party, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10000 | 10000 | Henry Baldwin B000089 | sen | MI | 1879-03-18 | 1881-03-03 | 1 | Republican | |||||||||||||
10009 | 10009 | Charles Bell B000331 | sen | NH | 1879-03-18 | 1879-12-31 | 3 | Republican | |||||||||||||
10026 | 10026 | Matthew Carpenter C000171 | sen | WI | 1879-03-18 | 1881-12-31 | 3 | Republican | |||||||||||||
10030 | 10030 | Zachariah Chandler C000299 | sen | MI | 1879-03-18 | 1879-12-31 | 1 | Republican | |||||||||||||
10054 | 10054 | Roscoe Conkling C000681 | sen | NY | 1879-03-18 | 1881-12-31 | 3 | Republican | |||||||||||||
10072 | 10072 | James Farley F000020 | sen | CA | 1879-03-18 | 1885-03-03 | 3 | Democrat | |||||||||||||
10091 | 10091 | James Groome G000492 | sen | MD | 1879-03-18 | 1885-03-03 | 3 | Democrat | |||||||||||||
10105 | 10105 | Nathaniel Hill H000603 | sen | CO | 1879-03-18 | 1885-03-03 | 3 | Republican | |||||||||||||
10116 | 10116 | George Houston H000822 | sen | AL | 1879-03-18 | 1879-12-31 | 3 | Democrat | |||||||||||||
10121 | 10121 | Benjamin Jonas J000204 | sen | LA | 1879-03-18 | 1885-03-03 | 3 | Democrat | |||||||||||||
10166 | 10166 | George Pendleton P000203 | sen | OH | 1879-03-18 | 1885-03-03 | 3 | Democrat | |||||||||||||
10192 | 10192 | James Slater S000476 | sen | OR | 1879-03-18 | 1885-03-03 | 3 | Democrat | |||||||||||||
10212 | 10212 | James Walker W000057 | sen | AR | 1879-03-18 | 1885-03-03 | 3 | Democrat | |||||||||||||
10221 | 10221 | John Williams W000522 | sen | KY | 1879-03-18 | 1885-03-03 | 3 | Democrat | |||||||||||||
11066 | 11066 | Wade Hampton H000141 | sen | SC | 1879-03-18 | 1885-03-03 | 3 | Democrat | |||||||||||||
11087 | 11087 | John Ingalls I000012 | sen | KS | 1879-03-18 | 1885-03-03 | 3 | Republican | |||||||||||||
11115 | 11115 | John Logan L000403 | sen | IL | 1879-03-18 | 1885-03-03 | 3 | Republican | |||||||||||||
12123 | 12123 | Wilkinson Call C000051 | sen | FL | 1879-03-18 | 1885-03-03 | 3 | Democrat | |||||||||||||
12127 | 12127 | James Cameron C000065 | sen | PA | 1879-03-18 | 1885-03-03 | 3 | Republican | |||||||||||||
12183 | 12183 | John Gordon G000313 | sen | GA | 1879-03-18 | 1881-03-03 | 3 | Democrat | |||||||||||||
12341 | 12341 | Zebulon Vance V000021 | sen | NC | 1879-03-18 | 1885-03-03 | 3 | Democrat | |||||||||||||
12351 | 12351 | Daniel Voorhees V000116 | sen | IN | 1879-03-18 | 1885-03-03 | 3 | Democrat | |||||||||||||
12415 | 12415 | Henry Blair B000524 | sen | NH | 1879-03-18 | 1885-03-03 | 3 | Republican | |||||||||||||
13368 | 13368 | John Jones J000237 | sen | NV | 1879-03-18 | 1885-03-03 | 3 | Republican | |||||||||||||
13433 | 13433 | Justin Morrill M000969 | sen | VT | 1879-03-18 | 1885-03-03 | 3 | Republican | |||||||||||||
13515 | 13515 | George Vest V000091 | sen | MO | 1879-03-18 | 1885-03-03 | 3 | Democrat | |||||||||||||
14232 | 14232 | William Allison A000160 | sen | IA | 1879-03-18 | 1885-03-03 | 3 | Republican | |||||||||||||
14433 | 14433 | Orville Platt P000382 | sen | CT | 1879-03-18 | 1885-03-03 | 3 | Republican | |||||||||||||
10010 | 10010 | Granville Bennett B000374 | rep | DK | 1879-03-18 | 1881-03-03 | Republican | -1 | |||||||||||||
10138 | 10138 | Thomas Majors M000075 | rep | NE | 1879-03-18 | 1881-03-03 | Republican | -1 | |||||||||||||
10159 | 10159 | Mariano Otero O000124 | rep | NM | 1879-03-18 | 1881-03-03 | Republican | -1 | |||||||||||||
10187 | 10187 | Gustave Schleicher S000129 | rep | TX | 1879-03-18 | 1881-03-03 | Democrat | -1 | |||||||||||||
10248 | 10248 | George Ainslie A000066 | rep | ID | 1879-03-18 | 1881-03-03 | Democrat | -1 | |||||||||||||
10287 | 10287 | George Cannon C000119 | rep | UT | 1879-03-18 | 1881-03-03 | Republican | -1 | |||||||||||||
10646 | 10646 | Thomas Brents B000806 | rep | WA | 1879-03-18 | 1881-03-03 | Republican | -1 | |||||||||||||
10804 | 10804 | Martin Maginnis M000050 | rep | MT | 1879-03-18 | 1881-03-03 | Democrat | -1 | |||||||||||||
10024 | 10024 | John Campbell C000092 | rep | AZ | 1879-03-18 | 1881-03-03 | Democrat | 0 | |||||||||||||
10056 | 10056 | Rollin Daggett D000003 | rep | NV | 1879-03-18 | 1881-03-03 | Republican | 0 | |||||||||||||
10066 | 10066 | Stephen Downey D000470 | rep | WY | 1879-03-18 | 1881-03-03 | Republican | 0 | |||||||||||||
10442 | 10442 | Edward Martin M000178 | rep | DE | 1879-03-18 | 1881-03-03 | Democrat | 0 | |||||||||||||
10008 | 10008 | Richard Beale B000268 | rep | VA | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
10058 | 10058 | Horace Davis D000105 | rep | CA | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10104 | 10104 | Daniel Henry H000504 | rep | MD | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
10141 | 10141 | Joseph Martin M000190 | rep | NC | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10155 | 10155 | John Newberry N000061 | rep | MI | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10220 | 10220 | John Whiteaker W000399 | rep | OR | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
10228 | 10228 | Jesse Yeates Y000016 | rep | NC | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
10251 | 10251 | William Aldrich A000086 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10315 | 10315 | William Crapo C000881 | rep | MA | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10362 | 10362 | Joshua Hall H000057 | rep | NH | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10381 | 10381 | William Heilman H000451 | rep | IN | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10414 | 10414 | Charles Joyce J000275 | rep | VT | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10517 | 10517 | John Richardson R000225 | rep | SC | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
10520 | 10520 | George Robeson R000330 | rep | NJ | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10592 | 10592 | Charles Williams W000492 | rep | WI | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10599 | 10599 | Benjamin Wilson W000569 | rep | WV | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
10635 | 10635 | James Belford B000326 | rep | CO | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10745 | 10745 | Thomas Herndon H000534 | rep | AL | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
10813 | 10813 | Moses McCoid M000348 | rep | IA | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10821 | 10821 | Henry Muldrow M001068 | rep | MS | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
10825 | 10825 | John Nicholls N000087 | rep | GA | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
10912 | 10912 | Oscar Turner T000425 | rep | KY | 1879-03-18 | 1881-03-03 | Ind. Democrat | 1 | |||||||||||||
10915 | 10915 | Edward Valentine V000005 | rep | NE | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
11320 | 11320 | Martin Clardy C000417 | rep | MO | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
11353 | 11353 | Poindexter Dunn D000552 | rep | AR | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
11485 | 11485 | John Reagan R000098 | rep | TX | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
11565 | 11565 | John Anderson A000194 | rep | KS | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
11639 | 11639 | Benjamin Butterworth B001200 | rep | OH | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
11719 | 11719 | Robert Davidson D000085 | rep | FL | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
11744 | 11744 | Mark Dunnell D000555 | rep | MN | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
11766 | 11766 | Randall Gibson G000165 | rep | LA | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
12506 | 12506 | James Covert C000814 | rep | NY | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
13701 | 13701 | Joseph Hawley H000377 | rep | CT | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
13772 | 13772 | Thomas Reed R000128 | rep | ME | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
14555 | 14555 | Nelson Aldrich A000083 | rep | RI | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
15300 | 15300 | Robert Taylor T000098 | rep | TN | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
15854 | 15854 | Henry Bingham B000469 | rep | PA | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10003 | 10003 | Latimer Ballou B000106 | rep | RI | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
10090 | 10090 | John Goode G000277 | rep | VA | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10117 | 10117 | Noble Hull H000945 | rep | FL | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10130 | 10130 | William Kitchin K000251 | rep | NC | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10140 | 10140 | Benjamin Martin M000169 | rep | WV | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10157 | 10157 | Daniel O’Reilly O000099 | rep | NY | 1879-03-18 | 1881-03-03 | Ind. Democrat | 2 | |||||||||||||
10171 | 10171 | Henry Poehler P000400 | rep | MN | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10176 | 10176 | Hiram Price P000525 | rep | IA | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
10195 | 10195 | William Slemons S000484 | rep | AR | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10196 | 10196 | Hezekiah Smith S000549 | rep | NJ | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10199 | 10199 | William Smith S000631 | rep | GA | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10217 | 10217 | Erastus Wells W000282 | rep | MO | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10273 | 10273 | James Briggs B000831 | rep | NH | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
10372 | 10372 | Benjamin Harris H000233 | rep | MA | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
10455 | 10455 | James McKenzie M000505 | rep | KY | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10483 | 10483 | Michael O’Connor O000031 | rep | SC | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10498 | 10498 | Horace Page P000017 | rep | CA | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
10503 | 10503 | James Phelps P000295 | rep | CT | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10567 | 10567 | James Tyler T000449 | rep | VT | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
10595 | 10595 | Edwin Willits W000564 | rep | MI | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
10618 | 10618 | Thomas Young Y000054 | rep | OH | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
10639 | 10639 | Horatio Bisbee B000485 | rep | FL | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
10688 | 10688 | George Davis D000100 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 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);