legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
391 rows where "end" is on date 1891-03-03 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20952 | 20952 | Henry Tucker T000399 | rep | VA | 1889-12-02 | 1891-03-03 | Democrat | 10 | |||||||||||||
19555 | 19555 | Theodore Burton B001159 | rep | OH | 1889-12-02 | 1891-03-03 | Republican | 21 | |||||||||||||
18736 | 18736 | Henry Lodge L000393 | rep | MA | 1889-12-02 | 1891-03-03 | Republican | 6 | |||||||||||||
18722 | 18722 | Robert La Follette L000004 | rep | WI | 1889-12-02 | 1891-03-03 | Republican | 3 | |||||||||||||
18336 | 18336 | William Mason M000228 | rep | IL | 1889-12-02 | 1891-03-03 | Republican | 3 | |||||||||||||
18101 | 18101 | Joseph Cannon C000121 | rep | IL | 1889-12-02 | 1891-03-03 | Republican | 15 | |||||||||||||
17547 | 17547 | John Bankhead B000110 | rep | AL | 1889-12-02 | 1891-03-03 | Democrat | 6 | |||||||||||||
17017 | 17017 | William Stone S000968 | rep | MO | 1889-12-02 | 1891-03-03 | Democrat | 12 | |||||||||||||
16971 | 16971 | Marcus Smith S000589 | rep | AZ | 1889-12-02 | 1891-03-03 | Democrat | 0 | |||||||||||||
16958 | 16958 | Benjamin Shively S000371 | rep | IN | 1889-12-02 | 1891-03-03 | Democrat | 13 | |||||||||||||
16511 | 16511 | Sereno Payne P000153 | rep | NY | 1889-12-02 | 1891-03-03 | Republican | 27 | |||||||||||||
15918 | 15918 | John Dalzell D000016 | rep | PA | 1889-12-02 | 1891-03-03 | Republican | 22 | |||||||||||||
15893 | 15893 | Clarence Clark C000425 | rep | WY | 1889-12-02 | 1891-03-03 | Republican | 0 | |||||||||||||
15859 | 15859 | Henry Bingham B000469 | rep | PA | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
15661 | 15661 | Sydney Mudd M001059 | rep | MD | 1889-12-02 | 1891-03-03 | Republican | 5 | |||||||||||||
15318 | 15318 | John Stewart S000917 | rep | VT | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
15289 | 15289 | George Smith S000541 | rep | IL | 1889-12-02 | 1891-03-03 | Republican | 20 | |||||||||||||
15277 | 15277 | James Sherman S000345 | rep | NY | 1889-12-02 | 1891-03-03 | Republican | 23 | |||||||||||||
15258 | 15258 | John Reyburn R000168 | rep | PA | 1889-12-02 | 1891-03-03 | Republican | 4 | |||||||||||||
15245 | 15245 | Thomas Paynter P000156 | rep | KY | 1889-12-02 | 1891-03-03 | Democrat | 9 | |||||||||||||
15081 | 15081 | Jonathan Dolliver D000404 | rep | IA | 1889-12-02 | 1891-03-03 | Republican | 10 | |||||||||||||
14904 | 14904 | Martin Smyser S000645 | rep | OH | 1889-12-02 | 1891-03-03 | Republican | 20 | |||||||||||||
14872 | 14872 | Samuel Robertson R000324 | rep | LA | 1889-12-02 | 1891-03-03 | Democrat | 6 | |||||||||||||
14771 | 14771 | Rufus Lester L000255 | rep | GA | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
14760 | 14760 | John Lacey L000010 | rep | IA | 1889-12-02 | 1891-03-03 | Republican | 6 | |||||||||||||
14750 | 14750 | John Ketcham K000152 | rep | NY | 1889-12-02 | 1891-03-03 | Republican | 16 | |||||||||||||
14719 | 14719 | Robert Hitt H000649 | rep | IL | 1889-12-02 | 1891-03-03 | Republican | 6 | |||||||||||||
14709 | 14709 | Binger Hermann H000531 | rep | OR | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
14677 | 14677 | Charles Grosvenor G000497 | rep | OH | 1889-12-02 | 1891-03-03 | Republican | 15 | |||||||||||||
14616 | 14616 | Thomas Carter C000200 | rep | MT | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
14608 | 14608 | Julius Burrows B001142 | rep | MI | 1889-12-02 | 1891-03-03 | Republican | 4 | |||||||||||||
14528 | 14528 | James Williams W000508 | rep | IL | 1889-12-02 | 1891-03-03 | Democrat | 19 | |||||||||||||
14494 | 14494 | Henry Teller T000116 | sen | CO | 1885-12-07 | 1891-03-03 | 3 | Republican | |||||||||||||
14483 | 14483 | John Spooner S000741 | sen | WI | 1885-12-07 | 1891-03-03 | 3 | Republican | |||||||||||||
14452 | 14452 | James Richardson R000222 | rep | TN | 1889-12-02 | 1891-03-03 | Democrat | 5 | |||||||||||||
14434 | 14434 | Orville Platt P000382 | sen | CT | 1885-12-07 | 1891-03-03 | 3 | Republican | |||||||||||||
14427 | 14427 | Rice Pierce P000337 | rep | TN | 1889-12-02 | 1891-03-03 | Democrat | 9 | |||||||||||||
14408 | 14408 | James McCreary M000382 | rep | KY | 1889-12-02 | 1891-03-03 | Democrat | 8 | |||||||||||||
14380 | 14380 | John Lind L000319 | rep | MN | 1889-12-02 | 1891-03-03 | Republican | 2 | |||||||||||||
14349 | 14349 | Albert Hopkins H000770 | rep | IL | 1889-12-02 | 1891-03-03 | Republican | 5 | |||||||||||||
14341 | 14341 | Henry Hansbrough H000169 | rep | ND | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
14233 | 14233 | William Allison A000160 | sen | IA | 1885-12-07 | 1891-03-03 | 3 | Republican | |||||||||||||
14146 | 14146 | Charles Russell R000521 | rep | CT | 1889-12-02 | 1891-03-03 | Republican | 3 | |||||||||||||
14082 | 14082 | John Mitchell M000818 | sen | OR | 1885-12-07 | 1891-03-03 | 3 | Republican | |||||||||||||
14067 | 14067 | Thomas McRae M000597 | rep | AR | 1889-12-02 | 1891-03-03 | Democrat | 3 | |||||||||||||
14044 | 14044 | Samuel Lanham L000078 | rep | TX | 1889-12-02 | 1891-03-03 | Democrat | 11 | |||||||||||||
14015 | 14015 | Charles Hooker H000758 | rep | MS | 1889-12-02 | 1891-03-03 | Democrat | 7 | |||||||||||||
13993 | 13993 | David Henderson H000478 | rep | IA | 1889-12-02 | 1891-03-03 | Republican | 3 | |||||||||||||
13946 | 13946 | William Elliott E000129 | rep | SC | 1889-12-02 | 1891-03-03 | Democrat | 7 | |||||||||||||
13937 | 13937 | Fred Dubois D000509 | rep | ID | 1889-12-02 | 1891-03-03 | Republican | -1 | |||||||||||||
13923 | 13923 | Amos Cummings C000983 | rep | NY | 1889-12-02 | 1891-03-03 | Democrat | 9 | |||||||||||||
13887 | 13887 | Marriott Brosius B000892 | rep | PA | 1889-12-02 | 1891-03-03 | Republican | 10 | |||||||||||||
13874 | 13874 | Charles Boutelle B000673 | rep | ME | 1889-12-02 | 1891-03-03 | Republican | 4 | |||||||||||||
13868 | 13868 | Joseph Blackburn B000508 | sen | KY | 1885-12-07 | 1891-03-03 | 3 | Democrat | |||||||||||||
13824 | 13824 | Joseph Wheeler W000338 | rep | AL | 1889-12-02 | 1891-03-03 | Democrat | 8 | |||||||||||||
13777 | 13777 | Thomas Reed R000128 | rep | ME | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
13739 | 13739 | Louis McComas M000351 | rep | MD | 1889-12-02 | 1891-03-03 | Republican | 6 | |||||||||||||
13693 | 13693 | Alfred Harmer H000215 | rep | PA | 1889-12-02 | 1891-03-03 | Republican | 5 | |||||||||||||
13677 | 13677 | William Grout G000501 | rep | VT | 1889-12-02 | 1891-03-03 | Republican | 2 | |||||||||||||
13646 | 13646 | Nelson Dingley D000356 | rep | ME | 1889-12-02 | 1891-03-03 | Republican | 2 | |||||||||||||
13600 | 13600 | Thomas Catchings C000247 | rep | MS | 1889-12-02 | 1891-03-03 | Democrat | 3 | |||||||||||||
13584 | 13584 | Richard Bland B000544 | rep | MO | 1889-12-02 | 1891-03-03 | Democrat | 11 | |||||||||||||
13550 | 13550 | John Allen A000134 | rep | MS | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
13522 | 13522 | Joseph Walker W000062 | rep | MA | 1889-12-02 | 1891-03-03 | Republican | 10 | |||||||||||||
13516 | 13516 | George Vest V000091 | sen | MO | 1885-12-07 | 1891-03-03 | 3 | Democrat | |||||||||||||
13487 | 13487 | Charles Stone S000953 | rep | PA | 1889-12-02 | 1891-03-03 | Republican | 27 | |||||||||||||
13467 | 13467 | Joseph Sayers S000099 | rep | TX | 1889-12-02 | 1891-03-03 | Democrat | 10 | |||||||||||||
13434 | 13434 | Justin Morrill M000969 | sen | VT | 1885-12-07 | 1891-03-03 | 3 | Republican | |||||||||||||
13417 | 13417 | Seth Milliken M000769 | rep | ME | 1889-12-02 | 1891-03-03 | Republican | 3 | |||||||||||||
13407 | 13407 | Benton McMillin M000575 | rep | TN | 1889-12-02 | 1891-03-03 | Democrat | 4 | |||||||||||||
13369 | 13369 | John Jones J000237 | sen | NV | 1885-12-07 | 1891-03-03 | 3 | Republican | |||||||||||||
13364 | 13364 | James Jones J000231 | sen | AR | 1885-12-07 | 1891-03-03 | 3 | Democrat | |||||||||||||
13346 | 13346 | William Holman H000732 | rep | IN | 1889-12-02 | 1891-03-03 | Democrat | 4 | |||||||||||||
13293 | 13293 | Alexander Dockery D000384 | rep | MO | 1889-12-02 | 1891-03-03 | Democrat | 3 | |||||||||||||
13250 | 13250 | James Belden B000325 | rep | NY | 1889-12-02 | 1891-03-03 | Republican | 25 | |||||||||||||
13235 | 13235 | William McKinley M000522 | rep | OH | 1889-12-02 | 1891-03-03 | Republican | 18 | |||||||||||||
13213 | 13213 | John Wilson W000602 | rep | WA | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
13205 | 13205 | Joseph Washington W000181 | rep | TN | 1889-12-02 | 1891-03-03 | Democrat | 6 | |||||||||||||
13187 | 13187 | Henry Turner T000421 | rep | GA | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
13173 | 13173 | John Tarsney T000043 | rep | MO | 1889-12-02 | 1891-03-03 | Democrat | 5 | |||||||||||||
13166 | 13166 | Samuel Stephenson S000865 | rep | MI | 1889-12-02 | 1891-03-03 | Republican | 11 | |||||||||||||
13152 | 13152 | Joseph Scranton S000192 | rep | PA | 1889-12-02 | 1891-03-03 | Republican | 11 | |||||||||||||
13144 | 13144 | Harry Rusk R000516 | rep | MD | 1889-12-02 | 1891-03-03 | Democrat | 3 | |||||||||||||
13132 | 13132 | Andrew Price P000521 | rep | LA | 1889-12-02 | 1891-03-03 | Democrat | 3 | |||||||||||||
13128 | 13128 | Philip Post P000457 | rep | IL | 1889-12-02 | 1891-03-03 | Republican | 10 | |||||||||||||
13122 | 13122 | John Pickler P000329 | rep | SD | 1889-12-02 | 1891-03-03 | Republican | -1 | |||||||||||||
13096 | 13096 | Elijah Morse M001007 | rep | MA | 1889-12-02 | 1891-03-03 | Republican | 2 | |||||||||||||
13007 | 13007 | John Gear G000110 | rep | IA | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
12987 | 12987 | David Culberson C000964 | rep | TX | 1889-12-02 | 1891-03-03 | Democrat | 4 | |||||||||||||
12974 | 12974 | Charles Crisp C000908 | rep | GA | 1889-12-02 | 1891-03-03 | Democrat | 3 | |||||||||||||
12967 | 12967 | William Crain C000865 | rep | TX | 1889-12-02 | 1891-03-03 | Democrat | 7 | |||||||||||||
12957 | 12957 | William Cogswell C000595 | rep | MA | 1889-12-02 | 1891-03-03 | Republican | 7 | |||||||||||||
12945 | 12945 | James Cobb C000549 | rep | AL | 1889-12-02 | 1891-03-03 | Democrat | 5 | |||||||||||||
12940 | 12940 | Richard Clarke C000469 | rep | AL | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
12920 | 12920 | Charles Boatner B000580 | rep | LA | 1889-12-02 | 1891-03-03 | Democrat | 5 | |||||||||||||
12901 | 12901 | Warren Arnold A000298 | rep | RI | 1889-12-02 | 1891-03-03 | Republican | 2 | |||||||||||||
12887 | 12887 | Jo Abbott A000005 | rep | TX | 1889-12-02 | 1891-03-03 | Democrat | 6 | |||||||||||||
12880 | 12880 | Newton Blanchard B000541 | rep | LA | 1889-12-02 | 1891-03-03 | Democrat | 4 | |||||||||||||
12873 | 12873 | Myron Wright W000767 | rep | PA | 1889-12-02 | 1891-03-03 | Republican | 15 | |||||||||||||
12868 | 12868 | George Wise W000648 | rep | VA | 1889-12-02 | 1891-03-03 | Democrat | 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);