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 sorted by end
This data as json, copyable, CSV (advanced)
Suggested facets: state, class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13227 | 13227 | Frank Cannon C000118 | rep | UT | 1895-12-02 | 1896-01-04 | Republican | -1 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
13092 | 13092 | Joshua Miles M000706 | rep | MD | 1895-12-02 | 1897-03-03 | Democrat | 1 | |||||||||||||
13093 | 13093 | Orrin Miller M000749 | rep | KS | 1895-12-02 | 1897-03-03 | Republican | 2 | |||||||||||||
13094 | 13094 | Alfred Milnes M000783 | rep | MI | 1895-12-02 | 1897-03-03 | Republican | 3 | |||||||||||||
13095 | 13095 | Henry Miner M000792 | rep | NY | 1895-12-02 | 1897-03-03 | Democrat | 9 | |||||||||||||
13099 | 13099 | Elijah Morse M001007 | rep | MA | 1895-12-02 | 1897-03-03 | Republican | 12 | |||||||||||||
13102 | 13102 | Charles Moses M001027 | rep | GA | 1895-12-02 | 1897-03-03 | Democrat | 4 | |||||||||||||
13103 | 13103 | Norman Mozley M001056 | rep | MO | 1895-12-02 | 1897-03-03 | Republican | 14 | |||||||||||||
13104 | 13104 | Everett Murphy M001091 | rep | IL | 1895-12-02 | 1897-03-03 | Republican | 21 | |||||||||||||
13105 | 13105 | Nathan Murphy M001102 | rep | AZ | 1895-12-02 | 1897-03-03 | Republican | 0 |
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);