legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
394 rows where "start" is on date 1889-12-02 sorted by district
This data as json, copyable, CSV (advanced)
Suggested facets: state, end, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11588 | 11588 | John Barbour B000129 | sen | VA | 1889-12-02 | 1893-03-03 | 2 | Democrat | |||||||||||||
11605 | 11605 | James Beck B000289 | sen | KY | 1889-12-02 | 1891-03-03 | 2 | Democrat | |||||||||||||
11638 | 11638 | Matthew Butler B001184 | sen | SC | 1889-12-02 | 1895-03-03 | 2 | Democrat | |||||||||||||
11656 | 11656 | Lyman Casey C000227 | sen | ND | 1889-12-02 | 1893-03-03 | 1 | Republican | |||||||||||||
11676 | 11676 | Richard Coke C000601 | sen | TX | 1889-12-02 | 1895-03-03 | 2 | Democrat | |||||||||||||
11680 | 11680 | Alfred Colquitt C000647 | sen | GA | 1889-12-02 | 1895-03-03 | 2 | Democrat | |||||||||||||
11734 | 11734 | Nathan Dixon D000377 | sen | RI | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
11736 | 11736 | Joseph Dolph D000405 | sen | OR | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
11769 | 11769 | Randall Gibson G000165 | sen | LA | 1889-12-02 | 1893-03-03 | 2 | Democrat | |||||||||||||
11780 | 11780 | Anthony Higgins H000577 | sen | DE | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
11803 | 11803 | John Kenna K000099 | sen | WV | 1889-12-02 | 1893-12-31 | 2 | Democrat | |||||||||||||
11831 | 11831 | Charles Manderson M000095 | sen | NE | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
11835 | 11835 | Gilman Marston M000165 | sen | NH | 1889-12-02 | 1889-12-31 | 2 | Republican | |||||||||||||
11852 | 11852 | John McPherson M000593 | sen | NJ | 1889-12-02 | 1895-03-03 | 2 | Democrat | |||||||||||||
11859 | 11859 | Gideon Moody M000879 | sen | SD | 1889-12-02 | 1891-03-03 | 3 | Republican | |||||||||||||
11903 | 11903 | Gilbert Pierce P000334 | sen | ND | 1889-12-02 | 1891-03-03 | 3 | Republican | |||||||||||||
11908 | 11908 | Preston Plumb P000389 | sen | KS | 1889-12-02 | 1891-12-31 | 2 | Republican | |||||||||||||
11929 | 11929 | Matt Ransom R000062 | sen | NC | 1889-12-02 | 1895-03-03 | 2 | Democrat | |||||||||||||
12016 | 12016 | William Washburn W000175 | sen | MN | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
12047 | 12047 | James Wilson W000594 | sen | IA | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
12295 | 12295 | Watson Squire S000761 | sen | WA | 1889-12-02 | 1891-03-03 | 3 | Republican | |||||||||||||
12935 | 12935 | William Chandler C000298 | sen | NH | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
13025 | 13025 | Isham Harris H000243 | sen | TN | 1889-12-02 | 1895-03-03 | 2 | Democrat | |||||||||||||
13118 | 13118 | Richard Pettigrew P000271 | sen | SD | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
13202 | 13202 | Edward Walthall W000111 | sen | MS | 1889-12-02 | 1895-03-03 | 2 | Democrat | |||||||||||||
13217 | 13217 | Edward Wolcott W000667 | sen | CO | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
13859 | 13859 | James Berry B000418 | sen | AR | 1889-12-02 | 1895-03-03 | 2 | Democrat | |||||||||||||
14007 | 14007 | George Hoar H000654 | sen | MA | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
14062 | 14062 | James McMillan M000567 | sen | MI | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
14094 | 14094 | John Morgan M000954 | sen | AL | 1889-12-02 | 1895-03-03 | 2 | Democrat | |||||||||||||
15060 | 15060 | Shelby Cullom C000973 | sen | IL | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
15109 | 15109 | William Frye F000398 | sen | ME | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
11635 | 11635 | James Burnes B001116 | rep | MO | 1889-12-02 | 1891-03-03 | Democrat | -1 | |||||||||||||
11772 | 11772 | Oscar Gifford G000170 | rep | SD | 1889-12-02 | 1891-03-03 | Republican | -1 | |||||||||||||
11838 | 11838 | George Mathews M000235 | rep | DK | 1889-12-02 | 1891-03-03 | Republican | -1 | |||||||||||||
12121 | 12121 | John Caine C000023 | rep | UT | 1889-12-02 | 1891-03-03 | Democrat | -1 | |||||||||||||
12191 | 12191 | David Harvey H000305 | rep | OK | 1889-12-02 | 1891-03-03 | Republican | -1 | |||||||||||||
12650 | 12650 | Antonio Joseph J000272 | rep | NM | 1889-12-02 | 1891-03-03 | Democrat | -1 | |||||||||||||
13122 | 13122 | John Pickler P000329 | rep | SD | 1889-12-02 | 1891-03-03 | Republican | -1 | |||||||||||||
13937 | 13937 | Fred Dubois D000509 | rep | ID | 1889-12-02 | 1891-03-03 | Republican | -1 | |||||||||||||
11893 | 11893 | John Penington P000209 | rep | DE | 1889-12-02 | 1891-03-03 | Democrat | 0 | |||||||||||||
12054 | 12054 | Joseph Carey C000145 | rep | WY | 1889-12-02 | 1890-07-10 | Republican | 0 | |||||||||||||
12079 | 12079 | Horace Bartine B000197 | rep | NV | 1889-12-02 | 1891-03-03 | Republican | 0 | |||||||||||||
15893 | 15893 | Clarence Clark C000425 | rep | WY | 1889-12-02 | 1891-03-03 | Republican | 0 | |||||||||||||
16971 | 16971 | Marcus Smith S000589 | rep | AZ | 1889-12-02 | 1891-03-03 | Democrat | 0 | |||||||||||||
11571 | 11571 | George Atkinson A000330 | rep | WV | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
11621 | 11621 | Thomas Browne B000957 | rep | VA | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
11643 | 11643 | Benjamin Butterworth B001200 | rep | OH | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
11663 | 11663 | Lucien Caswell C000245 | rep | WI | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
11685 | 11685 | William Connell C000688 | rep | NE | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
11724 | 11724 | Robert Davidson D000085 | rep | FL | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
11725 | 11725 | John De Haven D000200 | rep | CA | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
11732 | 11732 | Samuel Dibble D000300 | rep | SC | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
11746 | 11746 | Mark Dunnell D000555 | rep | MN | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
11752 | 11752 | Lewis Featherstone F000056 | rep | AR | 1889-12-02 | 1891-03-03 | Union Labor | 1 | |||||||||||||
11870 | 11870 | Edmund Morrill M000968 | rep | KS | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
11875 | 11875 | Alonzo Nute N000173 | rep | NH | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
11960 | 11960 | William Simonds S000424 | rep | CT | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
11963 | 11963 | Thomas Skinner S000470 | rep | NC | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
11970 | 11970 | Henry Spooner S000740 | rep | RI | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
12039 | 12039 | Theodore Wilkinson W000477 | rep | LA | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
12085 | 12085 | Christopher Bergen B000404 | rep | NJ | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
12131 | 12131 | William Cate C000249 | rep | AR | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
12179 | 12179 | Charles Gibson G000157 | rep | MD | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
12261 | 12261 | William Parrett P000078 | rep | IN | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
12309 | 12309 | Charles Stewart S000904 | rep | TX | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
12314 | 12314 | Abner Taylor T000062 | rep | IL | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
12336 | 12336 | Hosea Townsend T000334 | rep | CO | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
12486 | 12486 | John Chipman C000367 | rep | MI | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
12507 | 12507 | James Covert C000814 | rep | NY | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
12566 | 12566 | Thomas Geary G000113 | rep | CA | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
12602 | 12602 | William Hatch H000339 | rep | MO | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
12755 | 12755 | John Pendleton P000205 | rep | WV | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
12759 | 12759 | Charles Randall R000037 | rep | MA | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
12816 | 12816 | William Stone S000969 | rep | KY | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
12822 | 12822 | Willis Sweet S001110 | rep | ID | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
12825 | 12825 | Alfred Taylor T000064 | rep | TN | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
12940 | 12940 | Richard Clarke C000469 | rep | AL | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
13007 | 13007 | John Gear G000110 | rep | IA | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
13213 | 13213 | John Wilson W000602 | rep | WA | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
13550 | 13550 | John Allen A000134 | rep | MS | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
13777 | 13777 | Thomas Reed R000128 | rep | ME | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
14341 | 14341 | Henry Hansbrough H000169 | rep | ND | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
14616 | 14616 | Thomas Carter C000200 | rep | MT | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
14709 | 14709 | Binger Hermann H000531 | rep | OR | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
14771 | 14771 | Rufus Lester L000255 | rep | GA | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
15318 | 15318 | John Stewart S000917 | rep | VT | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
15859 | 15859 | Henry Bingham B000469 | rep | PA | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
11560 | 11560 | Edward Allen A000119 | rep | MI | 1889-12-02 | 1891-03-03 | Republican | 2 | |||||||||||||
11608 | 11608 | Marion Biggs B000458 | rep | CA | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
11613 | 11613 | George Bowden B000677 | rep | VA | 1889-12-02 | 1891-03-03 | Republican | 2 | |||||||||||||
11647 | 11647 | Felix Campbell C000082 | rep | NY | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
11677 | 11677 | Hamilton Coleman C000619 | rep | LA | 1889-12-02 | 1891-03-03 | Republican | 2 | |||||||||||||
11816 | 11816 | James Laird L000023 | rep | NE | 1889-12-02 | 1891-03-03 | Republican | 2 | |||||||||||||
11821 | 11821 | Frank Lawler L000128 | rep | IL | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
11822 | 11822 | Gilbert Laws L000143 | rep | NE | 1889-12-02 | 1891-03-03 | Republican | 2 | |||||||||||||
11837 | 11837 | William Martin M000203 | rep | TX | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
11860 | 11860 | Orren Moore M000910 | rep | NH | 1889-12-02 | 1891-03-03 | Republican | 2 | |||||||||||||
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 |
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);