legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
411 rows where "start" is on date 1895-12-02
This data as json, copyable, CSV (advanced)
Suggested facets: type, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12890 | 12890 | Jo Abbott A000005 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 6 | |||||||||||||
12892 | 12892 | David Aitken A000068 | rep | MI | 1895-12-02 | 1897-03-03 | Republican | 6 | |||||||||||||
12894 | 12894 | James Aldrich A000082 | rep | IL | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
12895 | 12895 | Truman Aldrich A000085 | rep | AL | 1895-12-02 | 1897-03-03 | Republican | 9 | |||||||||||||
12896 | 12896 | Clarence Allen A000117 | rep | UT | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
12897 | 12897 | William Anderson A000238 | rep | TN | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
12899 | 12899 | Lewis Apsley A000271 | rep | MA | 1895-12-02 | 1897-03-03 | Republican | 4 | |||||||||||||
12902 | 12902 | Warren Arnold A000298 | rep | RI | 1895-12-02 | 1897-03-03 | Republican | 2 | |||||||||||||
12903 | 12903 | Harrison Atwood A000336 | rep | MA | 1895-12-02 | 1897-03-03 | Republican | 10 | |||||||||||||
12905 | 12905 | John Avery A000346 | rep | MI | 1895-12-02 | 1897-03-03 | Republican | 11 | |||||||||||||
12907 | 12907 | Henry Baker B000061 | rep | NH | 1895-12-02 | 1897-03-03 | Republican | 2 | |||||||||||||
12908 | 12908 | Lucien Baker B000070 | sen | KS | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
12911 | 12911 | William Baker B000075 | rep | KS | 1895-12-02 | 1897-03-03 | Populist | 6 | |||||||||||||
12913 | 12913 | Franklin Bartlett B000202 | rep | NY | 1895-12-02 | 1897-03-03 | Democrat | 7 | |||||||||||||
12915 | 12915 | Charles Bell B000333 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 8 | |||||||||||||
12916 | 12916 | Frank Black B000496 | rep | NY | 1895-12-02 | 1897-03-03 | Republican | 19 | |||||||||||||
12918 | 12918 | James Black B000502 | rep | GA | 1895-12-02 | 1897-03-03 | Democrat | 10 | |||||||||||||
12919 | 12919 | Richard Blue B000573 | rep | KS | 1895-12-02 | 1897-03-03 | Republican | -1 | |||||||||||||
12923 | 12923 | Charles Boatner B000580 | rep | LA | 1895-12-02 | 1897-03-03 | Democrat | 5 | |||||||||||||
12926 | 12926 | William Bowers B000692 | rep | CA | 1895-12-02 | 1897-03-03 | Republican | 7 | |||||||||||||
12927 | 12927 | Foster Brown B000915 | rep | TN | 1895-12-02 | 1897-03-03 | Republican | 3 | |||||||||||||
12928 | 12928 | Charles Buck B001012 | rep | LA | 1895-12-02 | 1897-03-03 | Democrat | 2 | |||||||||||||
12929 | 12929 | Orlando Burrell B001136 | rep | IL | 1895-12-02 | 1897-03-03 | Republican | 20 | |||||||||||||
12930 | 12930 | Charles Burton B001147 | rep | MO | 1895-12-02 | 1897-03-03 | Republican | 15 | |||||||||||||
12931 | 12931 | Marion Butler B001183 | sen | NC | 1895-12-02 | 1901-03-03 | 2 | Populist | |||||||||||||
12933 | 12933 | Donelson Caffery C000016 | sen | LA | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
12936 | 12936 | William Chandler C000298 | sen | NH | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
12938 | 12938 | Horace Chilton C000357 | sen | TX | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
12939 | 12939 | Charles Clark C000423 | rep | MO | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
12943 | 12943 | Richard Clarke C000469 | rep | AL | 1895-12-02 | 1897-03-03 | Democrat | 1 | |||||||||||||
12948 | 12948 | James Cobb C000549 | rep | AL | 1895-12-02 | 1897-03-03 | Democrat | 5 | |||||||||||||
12951 | 12951 | Seth Cobb C000550 | rep | MO | 1895-12-02 | 1897-03-03 | Democrat | 12 | |||||||||||||
12953 | 12953 | Jeremiah Cockrell C000577 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 13 | |||||||||||||
12955 | 12955 | Charles Coffin C000588 | rep | MD | 1895-12-02 | 1897-03-03 | Republican | 5 | |||||||||||||
12960 | 12960 | William Cogswell C000595 | rep | MA | 1895-12-02 | 1897-03-03 | Republican | 6 | |||||||||||||
12961 | 12961 | Samuel Cook C000726 | rep | WI | 1895-12-02 | 1897-03-03 | Republican | 6 | |||||||||||||
12963 | 12963 | Charles Cooper C000746 | rep | FL | 1895-12-02 | 1897-03-03 | Democrat | 2 | |||||||||||||
12964 | 12964 | John Cowen C000822 | rep | MD | 1895-12-02 | 1897-03-03 | Democrat | 4 | |||||||||||||
12970 | 12970 | William Crain C000865 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 11 | |||||||||||||
12977 | 12977 | Charles Crisp C000908 | rep | GA | 1895-12-02 | 1897-03-03 | Democrat | 3 | |||||||||||||
12978 | 12978 | Miles Crowley C000944 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 10 | |||||||||||||
12979 | 12979 | George Crowther C000949 | rep | MO | 1895-12-02 | 1897-03-03 | Republican | 4 | |||||||||||||
12990 | 12990 | David Culberson C000964 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 4 | |||||||||||||
12993 | 12993 | Newton Curtis C001012 | rep | NY | 1895-12-02 | 1897-03-03 | Republican | 22 | |||||||||||||
12995 | 12995 | Charles Daniels D000040 | rep | NY | 1895-12-02 | 1897-03-03 | Republican | 33 | |||||||||||||
12996 | 12996 | Francis De Witt D000286 | rep | OH | 1895-12-02 | 1897-03-03 | Republican | 5 | |||||||||||||
12997 | 12997 | Walter Denny D000251 | rep | MS | 1895-12-02 | 1897-03-03 | Democrat | 6 | |||||||||||||
12999 | 12999 | William Doolittle D000430 | rep | WA | 1895-12-02 | 1897-03-03 | Republican | -1 | |||||||||||||
13000 | 13000 | Finis Downing D000473 | rep | IL | 1895-12-02 | 1897-03-03 | Democrat | 16 | |||||||||||||
13002 | 13002 | William Draper D000488 | rep | MA | 1895-12-02 | 1897-03-03 | Republican | 11 | |||||||||||||
13003 | 13003 | Tazewell Ellett E000117 | rep | VA | 1895-12-02 | 1897-03-03 | Democrat | 3 | |||||||||||||
13005 | 13005 | Constantine Erdman E000199 | rep | PA | 1895-12-02 | 1897-03-03 | Democrat | 9 | |||||||||||||
13009 | 13009 | John Gear G000110 | sen | IA | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
13010 | 13010 | Albert Goodwyn G000305 | rep | AL | 1895-12-02 | 1897-03-03 | Populist | 5 | |||||||||||||
13012 | 13012 | Matthew Griswold G000487 | rep | PA | 1895-12-02 | 1897-03-03 | Republican | 26 | |||||||||||||
13013 | 13013 | William Hadley H000009 | rep | IL | 1895-12-02 | 1897-03-03 | Republican | 18 | |||||||||||||
13015 | 13015 | Eugene Hainer H000024 | rep | NE | 1895-12-02 | 1897-03-03 | Republican | 4 | |||||||||||||
13017 | 13017 | Uriel Hall H000075 | rep | MO | 1895-12-02 | 1897-03-03 | Democrat | 2 | |||||||||||||
13018 | 13018 | Frederick Halterman H000093 | rep | PA | 1895-12-02 | 1897-03-03 | Republican | 3 | |||||||||||||
13019 | 13019 | James Hanly H000159 | rep | IN | 1895-12-02 | 1897-03-03 | Republican | -1 | |||||||||||||
13020 | 13020 | Alexander Hardy H000194 | rep | IN | 1895-12-02 | 1897-03-03 | Republican | 2 | |||||||||||||
13026 | 13026 | Isham Harris H000243 | sen | TN | 1895-12-02 | 1897-12-31 | 2 | Democrat | |||||||||||||
13027 | 13027 | Stephen Harris H000253 | rep | OH | 1895-12-02 | 1897-03-03 | Republican | 13 | |||||||||||||
13029 | 13029 | George Harrison H000270 | rep | AL | 1895-12-02 | 1897-03-03 | Democrat | 3 | |||||||||||||
13030 | 13030 | Joseph Hart H000289 | rep | PA | 1895-12-02 | 1897-03-03 | Democrat | 8 | |||||||||||||
13031 | 13031 | Jethro Hatch H000337 | rep | IN | 1895-12-02 | 1897-03-03 | Republican | 10 | |||||||||||||
13033 | 13033 | Daniel Heiner H000453 | rep | PA | 1895-12-02 | 1897-03-03 | Republican | 21 | |||||||||||||
13034 | 13034 | John Hendrick H000491 | rep | KY | 1895-12-02 | 1897-03-03 | Democrat | 1 | |||||||||||||
13035 | 13035 | Nathan Hopkins H000777 | rep | KY | 1895-12-02 | 1897-03-03 | Republican | 10 | |||||||||||||
13036 | 13036 | Joel Hubbard H000884 | rep | MO | 1895-12-02 | 1897-03-03 | Republican | 8 | |||||||||||||
13038 | 13038 | George Hulick H000937 | rep | OH | 1895-12-02 | 1897-03-03 | Republican | 6 | |||||||||||||
13039 | 13039 | James Huling H000938 | rep | WV | 1895-12-02 | 1897-03-03 | Republican | 3 | |||||||||||||
13041 | 13041 | Joseph Hutcheson H001007 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 1 | |||||||||||||
13042 | 13042 | Samuel Hyde H001024 | rep | WA | 1895-12-02 | 1897-03-03 | Republican | -1 | |||||||||||||
13043 | 13043 | Grove Johnson J000134 | rep | CA | 1895-12-02 | 1897-03-03 | Republican | 2 | |||||||||||||
13046 | 13046 | Omer Kem K000083 | rep | NE | 1895-12-02 | 1897-03-03 | Populist | 6 | |||||||||||||
13048 | 13048 | Joseph Kendall K000095 | rep | KY | 1895-12-02 | 1897-03-03 | Democrat | 10 | |||||||||||||
13050 | 13050 | Andrew Kiefer K000166 | rep | MN | 1895-12-02 | 1897-03-03 | Republican | 4 | |||||||||||||
13051 | 13051 | Snyder Kirkpatrick K000238 | rep | KS | 1895-12-02 | 1897-03-03 | Republican | 3 | |||||||||||||
13054 | 13054 | John Kyle K000354 | rep | MS | 1895-12-02 | 1897-03-03 | Democrat | 2 | |||||||||||||
13057 | 13057 | Thomas Lawson L000146 | rep | GA | 1895-12-02 | 1897-03-03 | Democrat | 8 | |||||||||||||
13060 | 13060 | Fernando Layton L000152 | rep | OH | 1895-12-02 | 1897-03-03 | Democrat | 4 | |||||||||||||
13062 | 13062 | Jacob Le Fever L000158 | rep | NY | 1895-12-02 | 1897-03-03 | Republican | 18 | |||||||||||||
13063 | 13063 | Jacob Leighty L000233 | rep | IN | 1895-12-02 | 1897-03-03 | Republican | 12 | |||||||||||||
13064 | 13064 | John Leisenring L000235 | rep | PA | 1895-12-02 | 1897-03-03 | Republican | 12 | |||||||||||||
13065 | 13065 | Fred Leonard L000245 | rep | PA | 1895-12-02 | 1897-03-03 | Republican | 16 | |||||||||||||
13066 | 13066 | John Lewis L000288 | rep | KY | 1895-12-02 | 1897-03-03 | Republican | 4 | |||||||||||||
13068 | 13068 | William Lindsay L000327 | sen | KY | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
13070 | 13070 | William Linton L000341 | rep | MI | 1895-12-02 | 1897-03-03 | Republican | 8 | |||||||||||||
13071 | 13071 | James Lockhart L000391 | rep | NC | 1895-12-02 | 1897-03-03 | Democrat | 6 | |||||||||||||
13072 | 13072 | Lee Mantle M000116 | sen | MT | 1895-12-02 | 1899-03-03 | 1 | Silver Republican | |||||||||||||
13073 | 13073 | George McBride M000300 | sen | OR | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
13074 | 13074 | John McCall M000304 | rep | TN | 1895-12-02 | 1897-03-03 | Republican | 8 | |||||||||||||
13076 | 13076 | Addison McClure M000344 | rep | OH | 1895-12-02 | 1897-03-03 | Republican | 17 | |||||||||||||
13080 | 13080 | Richard McCormick M000371 | rep | NY | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
13082 | 13082 | James McDearmon M000402 | rep | TN | 1895-12-02 | 1897-03-03 | Democrat | 9 | |||||||||||||
13085 | 13085 | Lawrence McGann M000441 | rep | IL | 1895-12-02 | 1897-03-03 | Democrat | 3 | |||||||||||||
13086 | 13086 | William McKenney M000502 | rep | VA | 1895-12-02 | 1897-03-03 | Democrat | 4 | |||||||||||||
13088 | 13088 | George Meiklejohn M000634 | rep | NE | 1895-12-02 | 1897-03-03 | Republican | 3 | |||||||||||||
13091 | 13091 | Elisha Meredith M000647 | rep | VA | 1895-12-02 | 1897-03-03 | Democrat | 8 |
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);