legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
406 rows where "end" is on date 1897-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12890 | 12890 | Jo Abbott A000005 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 6 | |||||||||||||
14962 | 14962 | Ernest Acheson A000019 | rep | PA | 1895-12-02 | 1897-03-03 | Republican | 24 | |||||||||||||
14549 | 14549 | Robert Adams A000044 | rep | PA | 1895-12-02 | 1897-03-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
13545 | 13545 | William Aldrich A000087 | rep | AL | 1895-12-02 | 1897-03-03 | Republican | 4 | |||||||||||||
12896 | 12896 | Clarence Allen A000117 | rep | UT | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
13553 | 13553 | John Allen A000134 | rep | MS | 1895-12-02 | 1897-03-03 | Democrat | 1 | |||||||||||||
14234 | 14234 | William Allison A000160 | sen | IA | 1891-12-07 | 1897-03-03 | 3 | Republican | |||||||||||||
12897 | 12897 | William Anderson A000238 | rep | TN | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
18033 | 18033 | William Andrews A000251 | rep | NE | 1895-12-02 | 1897-03-03 | Republican | 5 | |||||||||||||
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 | |||||||||||||
13236 | 13236 | William Arnold A000299 | rep | PA | 1895-12-02 | 1897-03-03 | Republican | 28 | |||||||||||||
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 | |||||||||||||
14564 | 14564 | Joseph Babcock B000004 | rep | WI | 1895-12-02 | 1897-03-03 | Republican | 3 | |||||||||||||
14971 | 14971 | Joseph Bailey B000044 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 5 | |||||||||||||
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 | |||||||||||||
13562 | 13562 | William Baker B000076 | rep | MD | 1895-12-02 | 1897-03-03 | Republican | 2 | |||||||||||||
17550 | 17550 | John Bankhead B000110 | rep | AL | 1895-12-02 | 1897-03-03 | Democrat | 6 | |||||||||||||
13566 | 13566 | John Barham B000140 | rep | CA | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
13846 | 13846 | Samuel Barney B000163 | rep | WI | 1895-12-02 | 1897-03-03 | Republican | 5 | |||||||||||||
13244 | 13244 | William Barrett B000180 | rep | MA | 1895-12-02 | 1897-03-03 | Republican | 7 | |||||||||||||
16263 | 16263 | Richard Bartholdt B000196 | rep | MO | 1895-12-02 | 1897-03-03 | Republican | 10 | |||||||||||||
16273 | 16273 | Charles Bartlett B000199 | rep | GA | 1895-12-02 | 1897-03-03 | Democrat | 6 | |||||||||||||
12913 | 12913 | Franklin Bartlett B000202 | rep | NY | 1895-12-02 | 1897-03-03 | Democrat | 7 | |||||||||||||
13247 | 13247 | Clifton Beach B000262 | rep | OH | 1895-12-02 | 1897-03-03 | Republican | 20 | |||||||||||||
13255 | 13255 | Hugh Belknap B000329 | rep | IL | 1895-12-02 | 1897-03-03 | Republican | 3 | |||||||||||||
12915 | 12915 | Charles Bell B000333 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 8 | |||||||||||||
13851 | 13851 | John Bell B000341 | rep | CO | 1895-12-02 | 1897-03-03 | Populist | 2 | |||||||||||||
13258 | 13258 | Charles Bennett B000372 | rep | NY | 1895-12-02 | 1897-03-03 | Republican | 5 | |||||||||||||
13573 | 13573 | Albert Berry B000414 | rep | KY | 1895-12-02 | 1897-03-03 | Democrat | 6 | |||||||||||||
15862 | 15862 | Henry Bingham B000469 | rep | PA | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
14575 | 14575 | Roswell Bishop B000489 | rep | MI | 1895-12-02 | 1897-03-03 | Republican | 9 | |||||||||||||
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 | |||||||||||||
13869 | 13869 | Joseph Blackburn B000508 | sen | KY | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
12882 | 12882 | Newton Blanchard B000541 | sen | LA | 1894-01-01 | 1897-03-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
13877 | 13877 | Charles Boutelle B000673 | rep | ME | 1895-12-02 | 1897-03-03 | Republican | 4 | |||||||||||||
12926 | 12926 | William Bowers B000692 | rep | CA | 1895-12-02 | 1897-03-03 | Republican | 7 | |||||||||||||
13263 | 13263 | Henry Brewster B000815 | rep | NY | 1895-12-02 | 1897-03-03 | Republican | 31 | |||||||||||||
12099 | 12099 | Calvin Brice B000818 | sen | OH | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
13267 | 13267 | Case Broderick B000856 | rep | KS | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
13883 | 13883 | Jacob Bromwell B000866 | rep | OH | 1895-12-02 | 1897-03-03 | Republican | 2 | |||||||||||||
13890 | 13890 | Marriott Brosius B000892 | rep | PA | 1895-12-02 | 1897-03-03 | Republican | 10 | |||||||||||||
13226 | 13226 | Arthur Brown B000902 | sen | UT | 1896-01-01 | 1897-03-03 | 3 | Republican | |||||||||||||
12927 | 12927 | Foster Brown B000915 | rep | TN | 1895-12-02 | 1897-03-03 | Republican | 3 | |||||||||||||
15002 | 15002 | Charles Brumm B000977 | rep | PA | 1895-12-02 | 1897-03-03 | Republican | 13 | |||||||||||||
12928 | 12928 | Charles Buck B001012 | rep | LA | 1895-12-02 | 1897-03-03 | Democrat | 2 | |||||||||||||
13894 | 13894 | Melville Bull B001048 | rep | RI | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
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 | |||||||||||||
19556 | 19556 | Theodore Burton B001159 | rep | OH | 1895-12-02 | 1897-03-03 | Republican | 21 | |||||||||||||
15368 | 15368 | William Calderhead C000026 | rep | KS | 1895-12-02 | 1897-03-03 | Republican | 5 | |||||||||||||
12125 | 12125 | Wilkinson Call C000051 | sen | FL | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
12129 | 12129 | James Cameron C000065 | sen | PA | 1891-12-07 | 1897-03-03 | 3 | Republican | |||||||||||||
18103 | 18103 | Joseph Cannon C000121 | rep | IL | 1895-12-02 | 1897-03-03 | Republican | 12 | |||||||||||||
13603 | 13603 | Thomas Catchings C000247 | rep | MS | 1895-12-02 | 1897-03-03 | Democrat | 3 | |||||||||||||
16243 | 16243 | Thomas Catron C000253 | rep | NM | 1895-12-02 | 1897-03-03 | Republican | -1 | |||||||||||||
13608 | 13608 | Charles Chickering C000351 | rep | NY | 1895-12-02 | 1897-03-03 | Republican | 24 | |||||||||||||
13273 | 13273 | John Clardy C000415 | rep | KY | 1895-12-02 | 1897-03-03 | Democrat | 2 | |||||||||||||
12939 | 12939 | Charles Clark C000423 | rep | MO | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
13275 | 13275 | Samuel Clark C000452 | rep | IA | 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 | |||||||||||||
13277 | 13277 | James Codding C000580 | rep | PA | 1895-12-02 | 1897-03-03 | Republican | 15 | |||||||||||||
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 | |||||||||||||
13279 | 13279 | David Colson C000649 | rep | KY | 1895-12-02 | 1897-03-03 | Republican | 11 | |||||||||||||
13281 | 13281 | James Connolly C000697 | rep | IL | 1895-12-02 | 1897-03-03 | Republican | 17 | |||||||||||||
12961 | 12961 | Samuel Cook C000726 | rep | WI | 1895-12-02 | 1897-03-03 | Republican | 6 | |||||||||||||
13283 | 13283 | Edward Cooke C000731 | rep | IL | 1895-12-02 | 1897-03-03 | Republican | 6 | |||||||||||||
12963 | 12963 | Charles Cooper C000746 | rep | FL | 1895-12-02 | 1897-03-03 | Democrat | 2 | |||||||||||||
20232 | 20232 | Henry Cooper C000752 | rep | WI | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
15036 | 15036 | Samuel Cooper C000761 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 2 | |||||||||||||
13912 | 13912 | John Corliss C000779 | rep | MI | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
15043 | 15043 | Robert Cousins C000811 | rep | IA | 1895-12-02 | 1897-03-03 | Republican | 5 | |||||||||||||
12964 | 12964 | John Cowen C000822 | rep | MD | 1895-12-02 | 1897-03-03 | Democrat | 4 | |||||||||||||
13623 | 13623 | Nicholas Cox C000838 | rep | TN | 1895-12-02 | 1897-03-03 | Democrat | 7 | |||||||||||||
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 | |||||||||||||
20260 | 20260 | Charles Crisp C000909 | 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 | |||||||||||||
13918 | 13918 | Rousseau Crump C000957 | rep | MI | 1895-12-02 | 1897-03-03 | Republican | 10 | |||||||||||||
12990 | 12990 | David Culberson C000964 | rep | TX | 1895-12-02 | 1897-03-03 | Democrat | 4 | |||||||||||||
13926 | 13926 | Amos Cummings C000983 | rep | NY | 1895-12-02 | 1897-03-03 | Democrat | 10 | |||||||||||||
19270 | 19270 | Charles Curtis C001008 | rep | KS | 1895-12-02 | 1897-03-03 | Republican | 4 | |||||||||||||
13286 | 13286 | George Curtis C001010 | rep | IA | 1895-12-02 | 1897-03-03 | Republican | 2 | |||||||||||||
12993 | 12993 | Newton Curtis C001012 | rep | NY | 1895-12-02 | 1897-03-03 | Republican | 22 | |||||||||||||
15921 | 15921 | John Dalzell D000016 | rep | PA | 1895-12-02 | 1897-03-03 | Republican | 22 | |||||||||||||
13631 | 13631 | Lorenzo Danford D000028 | rep | OH | 1895-12-02 | 1897-03-03 | Republican | 16 | |||||||||||||
12995 | 12995 | Charles Daniels D000040 | rep | NY | 1895-12-02 | 1897-03-03 | Republican | 33 |
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);