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 party
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10979 | 10979 | Joseph Brown B000936 | sen | GA | 1885-12-07 | 1891-03-03 | 3 | Democrat | |||||||||||||
11031 | 11031 | James Eustis E000229 | sen | LA | 1885-12-07 | 1891-03-03 | 3 | Democrat | |||||||||||||
11067 | 11067 | Wade Hampton H000141 | sen | SC | 1885-12-07 | 1891-03-03 | 3 | Democrat | |||||||||||||
11153 | 11153 | Henry Payne P000151 | sen | OH | 1885-12-07 | 1891-03-03 | 3 | Democrat | |||||||||||||
11274 | 11274 | Ephraim Wilson W000577 | sen | MD | 1885-12-07 | 1891-03-03 | 3 | Democrat | |||||||||||||
11564 | 11564 | Chapman Anderson A000183 | rep | MS | 1889-12-02 | 1891-03-03 | Democrat | 5 | |||||||||||||
11591 | 11591 | George Barnes B000157 | rep | GA | 1889-12-02 | 1891-03-03 | Democrat | 10 | |||||||||||||
11605 | 11605 | James Beck B000289 | sen | KY | 1889-12-02 | 1891-03-03 | 2 | Democrat | |||||||||||||
11608 | 11608 | Marion Biggs B000458 | rep | CA | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
11631 | 11631 | Charles Buckalew B001019 | rep | PA | 1889-12-02 | 1891-03-03 | Democrat | 17 | |||||||||||||
11635 | 11635 | James Burnes B001116 | rep | MO | 1889-12-02 | 1891-03-03 | Democrat | -1 | |||||||||||||
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 | |||||||||||||
11655 | 11655 | Henry Carlton C000155 | rep | GA | 1889-12-02 | 1891-03-03 | Democrat | 8 | |||||||||||||
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 | |||||||||||||
11690 | 11690 | James Cothran C000798 | rep | SC | 1889-12-02 | 1891-03-03 | Democrat | 3 | |||||||||||||
11705 | 11705 | Samuel Cox C000839 | rep | NY | 1889-12-02 | 1891-03-03 | Democrat | 9 | |||||||||||||
11715 | 11715 | George Dargan D000053 | rep | SC | 1889-12-02 | 1891-03-03 | Democrat | 6 | |||||||||||||
11724 | 11724 | Robert Davidson D000085 | rep | FL | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
11732 | 11732 | Samuel Dibble D000300 | rep | SC | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
11755 | 11755 | Frank Fitzgerald F000163 | rep | NY | 1889-12-02 | 1891-03-03 | Democrat | 6 | |||||||||||||
11761 | 11761 | Edward Gay G000103 | rep | LA | 1889-12-02 | 1891-03-03 | Democrat | 3 | |||||||||||||
11775 | 11775 | Thomas Grimes G000476 | rep | GA | 1889-12-02 | 1891-03-03 | Democrat | 4 | |||||||||||||
11778 | 11778 | Silas Hare H000203 | rep | TX | 1889-12-02 | 1891-03-03 | Democrat | 5 | |||||||||||||
11782 | 11782 | James Jackson J000018 | rep | WV | 1889-12-02 | 1891-03-03 | Democrat | 4 | |||||||||||||
11808 | 11808 | James Kerr K000135 | rep | PA | 1889-12-02 | 1891-03-03 | Democrat | 28 | |||||||||||||
11821 | 11821 | Frank Lawler L000128 | rep | IL | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
11829 | 11829 | Levi Maish M000072 | rep | PA | 1889-12-02 | 1891-03-03 | Democrat | 19 | |||||||||||||
11837 | 11837 | William Martin M000203 | rep | TX | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
11842 | 11842 | William McAdoo M000292 | rep | NJ | 1889-12-02 | 1891-03-03 | Democrat | 7 | |||||||||||||
11843 | 11843 | John McCarthy M000313 | rep | NY | 1889-12-02 | 1891-03-03 | Democrat | 8 | |||||||||||||
11845 | 11845 | Charles McClammy M000324 | rep | NC | 1889-12-02 | 1891-03-03 | Democrat | 3 | |||||||||||||
11866 | 11866 | James Morgan M000952 | rep | MS | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
11880 | 11880 | John O’Neall O000091 | rep | IN | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
11893 | 11893 | John Penington P000209 | rep | DE | 1889-12-02 | 1891-03-03 | Democrat | 0 | |||||||||||||
11896 | 11896 | William Perry P000246 | rep | SC | 1889-12-02 | 1891-03-03 | Democrat | 4 | |||||||||||||
11902 | 11902 | James Phelan P000289 | rep | TN | 1889-12-02 | 1891-03-03 | Democrat | 10 | |||||||||||||
11905 | 11905 | John Pindar P000359 | rep | NY | 1889-12-02 | 1891-03-03 | Democrat | 24 | |||||||||||||
11911 | 11911 | John Quinn Q000018 | rep | NY | 1889-12-02 | 1891-03-03 | Democrat | 11 | |||||||||||||
11925 | 11925 | Samuel Randall R000039 | rep | PA | 1889-12-02 | 1891-03-03 | Democrat | 3 | |||||||||||||
11939 | 11939 | John Rogers R000399 | rep | AR | 1889-12-02 | 1891-03-03 | Democrat | 4 | |||||||||||||
11945 | 11945 | Alfred Rowland R000479 | rep | NC | 1889-12-02 | 1891-03-03 | Democrat | 6 | |||||||||||||
11959 | 11959 | George Seney S000241 | rep | OH | 1889-12-02 | 1891-03-03 | Democrat | 5 | |||||||||||||
11963 | 11963 | Thomas Skinner S000470 | rep | NC | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
11972 | 11972 | John Stewart S000914 | rep | GA | 1889-12-02 | 1891-03-03 | Democrat | 5 | |||||||||||||
11993 | 11993 | Richard Townshend T000339 | rep | IL | 1889-12-02 | 1891-03-03 | Democrat | 19 | |||||||||||||
11994 | 11994 | Charles Turner T000415 | rep | NY | 1889-12-02 | 1891-03-03 | Democrat | 6 | |||||||||||||
12003 | 12003 | Richard Vaux V000078 | rep | PA | 1889-12-02 | 1891-03-03 | Democrat | 3 | |||||||||||||
12004 | 12004 | Edward Venable V000085 | rep | VA | 1889-12-02 | 1891-03-03 | Democrat | 4 | |||||||||||||
12010 | 12010 | James Walker W000058 | rep | MO | 1889-12-02 | 1891-03-03 | Democrat | 14 | |||||||||||||
12021 | 12021 | Robert Whitelaw W000407 | rep | MO | 1889-12-02 | 1891-03-03 | Democrat | 14 | |||||||||||||
12030 | 12030 | Washington Whitthorne W000429 | rep | TN | 1889-12-02 | 1891-03-03 | Democrat | 7 | |||||||||||||
12037 | 12037 | John Wiley W000468 | rep | NY | 1889-12-02 | 1891-03-03 | Democrat | 33 | |||||||||||||
12039 | 12039 | Theodore Wilkinson W000477 | rep | LA | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
12051 | 12051 | Samuel Yoder Y000020 | rep | OH | 1889-12-02 | 1891-03-03 | Democrat | 4 | |||||||||||||
12067 | 12067 | John Andrew A000242 | rep | MA | 1889-12-02 | 1891-03-03 | Democrat | 3 | |||||||||||||
12095 | 12095 | James Blount B000568 | rep | GA | 1889-12-02 | 1891-03-03 | Democrat | 6 | |||||||||||||
12101 | 12101 | David Brunner B000980 | rep | PA | 1889-12-02 | 1891-03-03 | Democrat | 9 | |||||||||||||
12107 | 12107 | John Buchanan B001007 | rep | VA | 1889-12-02 | 1891-03-03 | Democrat | 9 | |||||||||||||
12109 | 12109 | Robert Bullock B001052 | rep | FL | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
12121 | 12121 | John Caine C000023 | rep | UT | 1889-12-02 | 1891-03-03 | Democrat | -1 | |||||||||||||
12124 | 12124 | Wilkinson Call C000051 | sen | FL | 1885-12-07 | 1891-03-03 | 3 | Democrat | |||||||||||||
12131 | 12131 | William Cate C000249 | rep | AR | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
12141 | 12141 | William Cowles C000829 | rep | NC | 1889-12-02 | 1891-03-03 | Democrat | 8 | |||||||||||||
12148 | 12148 | W. Dickerson D000310 | rep | KY | 1889-12-02 | 1891-03-03 | Democrat | 6 | |||||||||||||
12160 | 12160 | Roswell Flower F000217 | rep | NY | 1889-12-02 | 1891-03-03 | Democrat | 12 | |||||||||||||
12171 | 12171 | William Forney F000280 | rep | AL | 1889-12-02 | 1891-03-03 | Democrat | 7 | |||||||||||||
12173 | 12173 | Samuel Fowler F000326 | rep | NJ | 1889-12-02 | 1891-03-03 | Democrat | 4 | |||||||||||||
12179 | 12179 | Charles Gibson G000157 | rep | MD | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
12193 | 12193 | William Haynes H000401 | rep | OH | 1889-12-02 | 1891-03-03 | Democrat | 10 | |||||||||||||
12198 | 12198 | John Hemphill H000469 | rep | SC | 1889-12-02 | 1891-03-03 | Democrat | 5 | |||||||||||||
12206 | 12206 | Hilary Herbert H000524 | rep | AL | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
12224 | 12224 | William Lee L000208 | rep | VA | 1889-12-02 | 1891-03-03 | Democrat | 8 | |||||||||||||
12226 | 12226 | Posey Lester L000254 | rep | VA | 1889-12-02 | 1891-03-03 | Democrat | 5 | |||||||||||||
12228 | 12228 | Clarke Lewis L000276 | rep | MS | 1889-12-02 | 1891-03-03 | Democrat | 4 | |||||||||||||
12233 | 12233 | Charles Mansur M000115 | rep | MO | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
12235 | 12235 | Charles McClellan M000329 | rep | IN | 1889-12-02 | 1891-03-03 | Democrat | 12 | |||||||||||||
12246 | 12246 | Littleton Moore M000908 | rep | TX | 1889-12-02 | 1891-03-03 | Democrat | 8 | |||||||||||||
12249 | 12249 | Richard Norton N000157 | rep | MO | 1889-12-02 | 1891-03-03 | Democrat | 7 | |||||||||||||
12257 | 12257 | James Owens O000158 | rep | OH | 1889-12-02 | 1891-03-03 | Democrat | 16 | |||||||||||||
12261 | 12261 | William Parrett P000078 | rep | IN | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
12268 | 12268 | Samuel Peel P000184 | rep | AR | 1889-12-02 | 1891-03-03 | Democrat | 5 | |||||||||||||
12273 | 12273 | James Pugh P000561 | sen | AL | 1885-12-07 | 1891-03-03 | 3 | Democrat | |||||||||||||
12293 | 12293 | Francis Spinola S000738 | rep | NY | 1889-12-02 | 1891-03-03 | Democrat | 10 | |||||||||||||
12300 | 12300 | William Stahlnecker S000781 | rep | NY | 1889-12-02 | 1891-03-03 | Democrat | 14 | |||||||||||||
12309 | 12309 | Charles Stewart S000904 | rep | TX | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
12312 | 12312 | Herman Stump S001043 | rep | MD | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
12334 | 12334 | George Tillman T000275 | rep | SC | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
12342 | 12342 | Zebulon Vance V000021 | sen | NC | 1885-12-07 | 1891-03-03 | 3 | Democrat | |||||||||||||
12352 | 12352 | Daniel Voorhees V000116 | sen | IN | 1885-12-07 | 1891-03-03 | 3 | Democrat | |||||||||||||
12359 | 12359 | Scott Wike W000451 | rep | IL | 1889-12-02 | 1891-03-03 | Democrat | 12 | |||||||||||||
12361 | 12361 | Washington Willcox W000480 | rep | CT | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
12367 | 12367 | Robert Wilson W000611 | rep | MO | 1889-12-02 | 1891-03-03 | Democrat | 4 | |||||||||||||
12385 | 12385 | Roger Mills M000777 | rep | TX | 1889-12-02 | 1891-03-03 | Democrat | 9 | |||||||||||||
12395 | 12395 | John Alderson A000080 | rep | WV | 1889-12-02 | 1891-03-03 | Democrat | 3 | |||||||||||||
12404 | 12404 | Charles Barwig B000218 | rep | WI | 1889-12-02 | 1891-03-03 | Democrat | 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 | |||||||||||||
12438 | 12438 | George Brickner B000821 | rep | WI | 1889-12-02 | 1891-03-03 | Democrat | 5 |
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);