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 legislator_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12887 | 12887 | Jo Abbott A000005 | rep | TX | 1889-12-02 | 1891-03-03 | Democrat | 6 | |||||||||||||
11558 | 11558 | George Adams A000034 | rep | IL | 1889-12-02 | 1891-03-03 | Republican | 4 | |||||||||||||
12395 | 12395 | John Alderson A000080 | rep | WV | 1889-12-02 | 1891-03-03 | Democrat | 3 | |||||||||||||
11560 | 11560 | Edward Allen A000119 | rep | MI | 1889-12-02 | 1891-03-03 | Republican | 2 | |||||||||||||
13550 | 13550 | John Allen A000134 | rep | MS | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
14233 | 14233 | William Allison A000160 | sen | IA | 1885-12-07 | 1891-03-03 | 3 | Republican | |||||||||||||
11564 | 11564 | Chapman Anderson A000183 | rep | MS | 1889-12-02 | 1891-03-03 | Democrat | 5 | |||||||||||||
11570 | 11570 | John Anderson A000194 | rep | KS | 1889-12-02 | 1891-03-03 | Republican | 5 | |||||||||||||
12067 | 12067 | John Andrew A000242 | rep | MA | 1889-12-02 | 1891-03-03 | Democrat | 3 | |||||||||||||
12901 | 12901 | Warren Arnold A000298 | rep | RI | 1889-12-02 | 1891-03-03 | Republican | 2 | |||||||||||||
11571 | 11571 | George Atkinson A000330 | rep | WV | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
12073 | 12073 | Louis Atkinson A000331 | rep | PA | 1889-12-02 | 1891-03-03 | Republican | 18 | |||||||||||||
11574 | 11574 | Charles Baker B000057 | rep | NY | 1889-12-02 | 1891-03-03 | Republican | 30 | |||||||||||||
17547 | 17547 | John Bankhead B000110 | rep | AL | 1889-12-02 | 1891-03-03 | Democrat | 6 | |||||||||||||
11584 | 11584 | Nathaniel Banks B000116 | rep | MA | 1889-12-02 | 1891-03-03 | Republican | 5 | |||||||||||||
11591 | 11591 | George Barnes B000157 | rep | GA | 1889-12-02 | 1891-03-03 | Democrat | 10 | |||||||||||||
12079 | 12079 | Horace Bartine B000197 | rep | NV | 1889-12-02 | 1891-03-03 | Republican | 0 | |||||||||||||
12404 | 12404 | Charles Barwig B000218 | rep | WI | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
11598 | 11598 | Thomas Bayne B000261 | rep | PA | 1889-12-02 | 1891-03-03 | Republican | 23 | |||||||||||||
11605 | 11605 | James Beck B000289 | sen | KY | 1889-12-02 | 1891-03-03 | 2 | Democrat | |||||||||||||
11606 | 11606 | Charles Beckwith B000295 | rep | NJ | 1889-12-02 | 1891-03-03 | Republican | 5 | |||||||||||||
13250 | 13250 | James Belden B000325 | rep | NY | 1889-12-02 | 1891-03-03 | Republican | 25 | |||||||||||||
12082 | 12082 | Charles Belknap B000328 | rep | MI | 1889-12-02 | 1891-03-03 | Republican | 5 | |||||||||||||
12085 | 12085 | Christopher Bergen B000404 | rep | NJ | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
11608 | 11608 | Marion Biggs B000458 | rep | CA | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
15859 | 15859 | Henry Bingham B000469 | rep | PA | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
13868 | 13868 | Joseph Blackburn B000508 | sen | KY | 1885-12-07 | 1891-03-03 | 3 | Democrat | |||||||||||||
12416 | 12416 | Henry Blair B000524 | sen | NH | 1885-12-07 | 1891-03-03 | 3 | Republican | |||||||||||||
12880 | 12880 | Newton Blanchard B000541 | rep | LA | 1889-12-02 | 1891-03-03 | Democrat | 4 | |||||||||||||
13584 | 13584 | Richard Bland B000544 | rep | MO | 1889-12-02 | 1891-03-03 | Democrat | 11 | |||||||||||||
11609 | 11609 | Aaron Bliss B000557 | rep | MI | 1889-12-02 | 1891-03-03 | Republican | 8 | |||||||||||||
12095 | 12095 | James Blount B000568 | rep | GA | 1889-12-02 | 1891-03-03 | Democrat | 6 | |||||||||||||
12920 | 12920 | Charles Boatner B000580 | rep | LA | 1889-12-02 | 1891-03-03 | Democrat | 5 | |||||||||||||
11611 | 11611 | Melvin Boothman B000632 | rep | OH | 1889-12-02 | 1891-03-03 | Republican | 6 | |||||||||||||
13874 | 13874 | Charles Boutelle B000673 | rep | ME | 1889-12-02 | 1891-03-03 | Republican | 4 | |||||||||||||
11613 | 11613 | George Bowden B000677 | rep | VA | 1889-12-02 | 1891-03-03 | Republican | 2 | |||||||||||||
12428 | 12428 | Clifton Breckinridge B000784 | rep | AR | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
12433 | 12433 | William Breckinridge B000790 | rep | KY | 1889-12-02 | 1891-03-03 | Democrat | 7 | |||||||||||||
11617 | 11617 | Mark Brewer B000811 | rep | MI | 1889-12-02 | 1891-03-03 | Republican | 6 | |||||||||||||
12438 | 12438 | George Brickner B000821 | rep | WI | 1889-12-02 | 1891-03-03 | Democrat | 5 | |||||||||||||
12441 | 12441 | Elijah Brookshire B000886 | rep | IN | 1889-12-02 | 1891-03-03 | Democrat | 8 | |||||||||||||
13887 | 13887 | Marriott Brosius B000892 | rep | PA | 1889-12-02 | 1891-03-03 | Republican | 10 | |||||||||||||
11619 | 11619 | John Brower B000898 | rep | NC | 1889-12-02 | 1891-03-03 | Republican | 5 | |||||||||||||
12444 | 12444 | Jason Brown B000924 | rep | IN | 1889-12-02 | 1891-03-03 | Democrat | 3 | |||||||||||||
10979 | 10979 | Joseph Brown B000936 | sen | GA | 1885-12-07 | 1891-03-03 | 3 | Democrat | |||||||||||||
11621 | 11621 | Thomas Browne B000957 | rep | VA | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
11628 | 11628 | Thomas Browne B000958 | rep | IN | 1889-12-02 | 1891-03-03 | Republican | 6 | |||||||||||||
12101 | 12101 | David Brunner B000980 | rep | PA | 1889-12-02 | 1891-03-03 | Democrat | 9 | |||||||||||||
12105 | 12105 | James Buchanan B001004 | rep | NJ | 1889-12-02 | 1891-03-03 | Republican | 2 | |||||||||||||
12107 | 12107 | John Buchanan B001007 | rep | VA | 1889-12-02 | 1891-03-03 | Democrat | 9 | |||||||||||||
11631 | 11631 | Charles Buckalew B001019 | rep | PA | 1889-12-02 | 1891-03-03 | Democrat | 17 | |||||||||||||
12109 | 12109 | Robert Bullock B001052 | rep | FL | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
12452 | 12452 | Benjamin Bunn B001062 | rep | NC | 1889-12-02 | 1891-03-03 | Democrat | 4 | |||||||||||||
11635 | 11635 | James Burnes B001116 | rep | MO | 1889-12-02 | 1891-03-03 | Democrat | -1 | |||||||||||||
14608 | 14608 | Julius Burrows B001142 | rep | MI | 1889-12-02 | 1891-03-03 | Republican | 4 | |||||||||||||
19555 | 19555 | Theodore Burton B001159 | rep | OH | 1889-12-02 | 1891-03-03 | Republican | 21 | |||||||||||||
11643 | 11643 | Benjamin Butterworth B001200 | rep | OH | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
12458 | 12458 | William Bynum B001205 | rep | IN | 1889-12-02 | 1891-03-03 | Democrat | 7 | |||||||||||||
12121 | 12121 | John Caine C000023 | rep | UT | 1889-12-02 | 1891-03-03 | Democrat | -1 | |||||||||||||
12464 | 12464 | John Caldwell C000034 | rep | OH | 1889-12-02 | 1891-03-03 | Republican | 2 | |||||||||||||
12124 | 12124 | Wilkinson Call C000051 | sen | FL | 1885-12-07 | 1891-03-03 | 3 | Democrat | |||||||||||||
12128 | 12128 | James Cameron C000065 | sen | PA | 1885-12-07 | 1891-03-03 | 3 | Republican | |||||||||||||
11647 | 11647 | Felix Campbell C000082 | rep | NY | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
11651 | 11651 | Allen Candler C000109 | rep | GA | 1889-12-02 | 1891-03-03 | Democrat | 9 | |||||||||||||
11653 | 11653 | John Candler C000111 | rep | MA | 1889-12-02 | 1891-03-03 | Republican | 9 | |||||||||||||
18101 | 18101 | Joseph Cannon C000121 | rep | IL | 1889-12-02 | 1891-03-03 | Republican | 15 | |||||||||||||
11655 | 11655 | Henry Carlton C000155 | rep | GA | 1889-12-02 | 1891-03-03 | Democrat | 8 | |||||||||||||
14616 | 14616 | Thomas Carter C000200 | rep | MT | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
12479 | 12479 | Asher Caruth C000208 | rep | KY | 1889-12-02 | 1891-03-03 | Democrat | 5 | |||||||||||||
11663 | 11663 | Lucien Caswell C000245 | rep | WI | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
13600 | 13600 | Thomas Catchings C000247 | rep | MS | 1889-12-02 | 1891-03-03 | Democrat | 3 | |||||||||||||
12131 | 12131 | William Cate C000249 | rep | AR | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
11665 | 11665 | Joseph Cheadle C000339 | rep | IN | 1889-12-02 | 1891-03-03 | Republican | 9 | |||||||||||||
12134 | 12134 | Henry Cheatham C000340 | rep | NC | 1889-12-02 | 1891-03-03 | Republican | 2 | |||||||||||||
12486 | 12486 | John Chipman C000367 | rep | MI | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
12489 | 12489 | John Clancy C000410 | rep | NY | 1889-12-02 | 1891-03-03 | Democrat | 4 | |||||||||||||
11667 | 11667 | Charles Clark C000422 | rep | WI | 1889-12-02 | 1891-03-03 | Republican | 6 | |||||||||||||
15893 | 15893 | Clarence Clark C000425 | rep | WY | 1889-12-02 | 1891-03-03 | Republican | 0 | |||||||||||||
12940 | 12940 | Richard Clarke C000469 | rep | AL | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
11672 | 11672 | Judson Clements C000508 | rep | GA | 1889-12-02 | 1891-03-03 | Democrat | 7 | |||||||||||||
11673 | 11673 | Thomas Clunie C000536 | rep | CA | 1889-12-02 | 1891-03-03 | Democrat | 5 | |||||||||||||
12945 | 12945 | James Cobb C000549 | rep | AL | 1889-12-02 | 1891-03-03 | Democrat | 5 | |||||||||||||
12957 | 12957 | William Cogswell C000595 | rep | MA | 1889-12-02 | 1891-03-03 | Republican | 7 | |||||||||||||
11677 | 11677 | Hamilton Coleman C000619 | rep | LA | 1889-12-02 | 1891-03-03 | Republican | 2 | |||||||||||||
12495 | 12495 | Barnes Compton C000660 | rep | MD | 1889-12-02 | 1891-03-03 | Democrat | 5 | |||||||||||||
11681 | 11681 | Solomon Comstock C000665 | rep | MN | 1889-12-02 | 1891-03-03 | Republican | 5 | |||||||||||||
11684 | 11684 | Edwin Conger C000675 | rep | IA | 1889-12-02 | 1891-03-03 | Republican | 7 | |||||||||||||
11685 | 11685 | William Connell C000688 | rep | NE | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
12501 | 12501 | George Cooper C000750 | rep | IN | 1889-12-02 | 1891-03-03 | Democrat | 5 | |||||||||||||
11688 | 11688 | William Cooper C000765 | rep | OH | 1889-12-02 | 1891-03-03 | Republican | 9 | |||||||||||||
11690 | 11690 | James Cothran C000798 | rep | SC | 1889-12-02 | 1891-03-03 | Democrat | 3 | |||||||||||||
12507 | 12507 | James Covert C000814 | rep | NY | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
12141 | 12141 | William Cowles C000829 | rep | NC | 1889-12-02 | 1891-03-03 | Democrat | 8 | |||||||||||||
11705 | 11705 | Samuel Cox C000839 | rep | NY | 1889-12-02 | 1891-03-03 | Democrat | 9 | |||||||||||||
11706 | 11706 | Samuel Craig C000860 | rep | PA | 1889-12-02 | 1891-03-03 | Republican | 21 | |||||||||||||
12967 | 12967 | William Crain C000865 | rep | TX | 1889-12-02 | 1891-03-03 | Democrat | 7 | |||||||||||||
12974 | 12974 | Charles Crisp C000908 | rep | GA | 1889-12-02 | 1891-03-03 | Democrat | 3 | |||||||||||||
12987 | 12987 | David Culberson C000964 | rep | TX | 1889-12-02 | 1891-03-03 | Democrat | 4 | |||||||||||||
11707 | 11707 | William Culbertson C000965 | rep | PA | 1889-12-02 | 1891-03-03 | Republican | 26 | |||||||||||||
13923 | 13923 | Amos Cummings C000983 | rep | NY | 1889-12-02 | 1891-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);