legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
404 rows where "end" is on date 1899-03-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14963 | 14963 | Ernest Acheson A000019 | rep | PA | 1897-03-15 | 1899-03-03 | Republican | 24 | |||||||||||||
14550 | 14550 | Robert Adams A000044 | rep | PA | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
17044 | 17044 | William Adamson A000051 | rep | GA | 1897-03-15 | 1899-03-03 | Democrat | 4 | |||||||||||||
14559 | 14559 | Nelson Aldrich A000083 | sen | RI | 1893-08-07 | 1899-03-03 | 1 | Republican | |||||||||||||
13546 | 13546 | William Aldrich A000087 | rep | AL | 1897-03-15 | 1899-03-03 | Republican | 4 | |||||||||||||
15323 | 15323 | De Alexander A000091 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 33 | |||||||||||||
13554 | 13554 | John Allen A000134 | rep | MS | 1897-03-15 | 1899-03-03 | Democrat | 1 | |||||||||||||
13556 | 13556 | William Allen A000153 | sen | NE | 1893-08-07 | 1899-03-03 | 1 | Populist | |||||||||||||
13237 | 13237 | William Arnold A000299 | rep | PA | 1897-03-15 | 1899-03-03 | Republican | 28 | |||||||||||||
14565 | 14565 | Joseph Babcock B000004 | rep | WI | 1897-03-15 | 1899-03-03 | Republican | 3 | |||||||||||||
14972 | 14972 | Joseph Bailey B000044 | rep | TX | 1897-03-15 | 1899-03-03 | Democrat | 5 | |||||||||||||
13560 | 13560 | Samuel Baird B000055 | rep | LA | 1897-03-15 | 1899-03-03 | Democrat | 5 | |||||||||||||
13241 | 13241 | Jehu Baker B000066 | rep | IL | 1897-03-15 | 1899-03-03 | Democrat | 21 | |||||||||||||
13563 | 13563 | William Baker B000076 | rep | MD | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
14240 | 14240 | Thomas Ball B000101 | rep | TX | 1897-03-15 | 1899-03-03 | Democrat | 1 | |||||||||||||
17551 | 17551 | John Bankhead B000110 | rep | AL | 1897-03-15 | 1899-03-03 | Democrat | 6 | |||||||||||||
13242 | 13242 | Isaac Barber B000121 | rep | MD | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
13567 | 13567 | John Barham B000140 | rep | CA | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
13243 | 13243 | Charles Barlow B000149 | rep | CA | 1897-03-15 | 1899-03-03 | Populist | 6 | |||||||||||||
13847 | 13847 | Samuel Barney B000163 | rep | WI | 1897-03-15 | 1899-03-03 | Republican | 5 | |||||||||||||
13245 | 13245 | William Barrett B000180 | rep | MA | 1897-03-15 | 1899-03-03 | Republican | 7 | |||||||||||||
13246 | 13246 | Samuel Barrows B000186 | rep | MA | 1897-03-15 | 1899-03-03 | Republican | 10 | |||||||||||||
16264 | 16264 | Richard Bartholdt B000196 | rep | MO | 1897-03-15 | 1899-03-03 | Republican | 10 | |||||||||||||
16274 | 16274 | Charles Bartlett B000199 | rep | GA | 1897-03-15 | 1899-03-03 | Democrat | 6 | |||||||||||||
13570 | 13570 | William Bate B000227 | sen | TN | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
13248 | 13248 | Clifton Beach B000262 | rep | OH | 1897-03-15 | 1899-03-03 | Republican | 20 | |||||||||||||
13253 | 13253 | James Belden B000325 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 27 | |||||||||||||
13254 | 13254 | Joseph Belford B000327 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
13256 | 13256 | Hugh Belknap B000329 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 3 | |||||||||||||
13852 | 13852 | John Bell B000341 | rep | CO | 1897-03-15 | 1899-03-03 | Populist | 2 | |||||||||||||
13257 | 13257 | George Benner B000366 | rep | PA | 1897-03-15 | 1899-03-03 | Democrat | 19 | |||||||||||||
13259 | 13259 | Charles Bennett B000372 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 5 | |||||||||||||
14247 | 14247 | Maecenas Benton B000397 | rep | MO | 1897-03-15 | 1899-03-03 | Democrat | 15 | |||||||||||||
13574 | 13574 | Albert Berry B000414 | rep | KY | 1897-03-15 | 1899-03-03 | Democrat | 6 | |||||||||||||
15863 | 15863 | Henry Bingham B000469 | rep | PA | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
14576 | 14576 | Roswell Bishop B000489 | rep | MI | 1897-03-15 | 1899-03-03 | Republican | 9 | |||||||||||||
13587 | 13587 | Richard Bland B000544 | rep | MO | 1897-03-15 | 1899-03-03 | Democrat | 8 | |||||||||||||
13260 | 13260 | Robert Bodine B000584 | rep | MO | 1897-03-15 | 1899-03-03 | Democrat | 2 | |||||||||||||
13261 | 13261 | William Booze B000633 | rep | MD | 1897-03-15 | 1899-03-03 | Republican | 3 | |||||||||||||
13262 | 13262 | Jeremiah Botkin B000654 | rep | KS | 1897-03-15 | 1899-03-03 | Populist | -1 | |||||||||||||
15344 | 15344 | Henry Boutell B000672 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 6 | |||||||||||||
13878 | 13878 | Charles Boutelle B000673 | rep | ME | 1897-03-15 | 1899-03-03 | Republican | 4 | |||||||||||||
13589 | 13589 | Thomas Bradley B000746 | rep | NY | 1897-03-15 | 1899-03-03 | Democrat | 9 | |||||||||||||
15879 | 15879 | William Brantley B000770 | rep | GA | 1897-03-15 | 1899-03-03 | Democrat | 11 | |||||||||||||
13591 | 13591 | John Brenner B000801 | rep | OH | 1897-03-15 | 1899-03-03 | Democrat | 3 | |||||||||||||
13593 | 13593 | Willis Brewer B000812 | rep | AL | 1897-03-15 | 1899-03-03 | Democrat | 5 | |||||||||||||
13264 | 13264 | Henry Brewster B000815 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 31 | |||||||||||||
13268 | 13268 | Case Broderick B000856 | rep | KS | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
13884 | 13884 | Jacob Bromwell B000866 | rep | OH | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
13891 | 13891 | Marriott Brosius B000892 | rep | PA | 1897-03-15 | 1899-03-03 | Republican | 10 | |||||||||||||
16696 | 16696 | Robert Broussard B000896 | rep | LA | 1897-03-15 | 1899-03-03 | Democrat | 3 | |||||||||||||
13595 | 13595 | Seth Brown B000943 | rep | OH | 1897-03-15 | 1899-03-03 | Republican | 6 | |||||||||||||
15357 | 15357 | Walter Brownlow B000962 | rep | TN | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
13269 | 13269 | Ferdinand Brucker B000973 | rep | MI | 1897-03-15 | 1899-03-03 | Democrat | 8 | |||||||||||||
15003 | 15003 | Charles Brumm B000977 | rep | PA | 1897-03-15 | 1899-03-03 | Republican | 13 | |||||||||||||
15006 | 15006 | Stephen Brundidge B000979 | rep | AR | 1897-03-15 | 1899-03-03 | Democrat | 6 | |||||||||||||
13895 | 13895 | Melville Bull B001048 | rep | RI | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
13898 | 13898 | Robert Burke B001097 | rep | TX | 1897-03-15 | 1899-03-03 | Democrat | 6 | |||||||||||||
16309 | 16309 | Edwin Burleigh B001105 | rep | ME | 1897-03-15 | 1899-03-03 | Republican | 3 | |||||||||||||
14611 | 14611 | Julius Burrows B001142 | sen | MI | 1895-12-02 | 1899-03-03 | 1 | Republican | |||||||||||||
19557 | 19557 | Theodore Burton B001159 | rep | OH | 1897-03-15 | 1899-03-03 | Republican | 21 | |||||||||||||
19240 | 19240 | Thomas Butler B001192 | rep | PA | 1897-03-15 | 1899-03-03 | Ind. Republican | 6 | |||||||||||||
13270 | 13270 | James Callahan C000053 | rep | OK | 1897-03-15 | 1899-03-03 | Free Silver | -1 | |||||||||||||
13271 | 13271 | James Campbell C000089 | rep | IL | 1897-03-15 | 1899-03-03 | Democrat | 20 | |||||||||||||
13228 | 13228 | Frank Cannon C000118 | sen | UT | 1896-01-22 | 1899-03-03 | 1 | Silver Republican | |||||||||||||
18104 | 18104 | Joseph Cannon C000121 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 12 | |||||||||||||
15375 | 15375 | Adin Capron C000135 | rep | RI | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
13902 | 13902 | Edward Carmack C000157 | rep | TN | 1897-03-15 | 1899-03-03 | Democrat | 10 | |||||||||||||
13272 | 13272 | Curtis Castle C000241 | rep | CA | 1897-03-15 | 1899-03-03 | Populist | 7 | |||||||||||||
13604 | 13604 | Thomas Catchings C000247 | rep | MS | 1897-03-15 | 1899-03-03 | Democrat | 3 | |||||||||||||
13609 | 13609 | Charles Chickering C000351 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 24 | |||||||||||||
13274 | 13274 | John Clardy C000415 | rep | KY | 1897-03-15 | 1899-03-03 | Democrat | 2 | |||||||||||||
15895 | 15895 | Clarence Clark C000425 | sen | WY | 1895-12-02 | 1899-03-03 | 1 | Republican | |||||||||||||
17612 | 17612 | James Clark C000437 | rep | MO | 1897-03-15 | 1899-03-03 | Democrat | 9 | |||||||||||||
13276 | 13276 | Samuel Clark C000452 | rep | IA | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
13611 | 13611 | Frank Clarke C000460 | rep | NH | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
16328 | 16328 | Henry Clayton C000495 | rep | AL | 1897-03-15 | 1899-03-03 | Democrat | 3 | |||||||||||||
14264 | 14264 | Charles Cochran C000562 | rep | MO | 1897-03-15 | 1899-03-03 | Democrat | 4 | |||||||||||||
13614 | 13614 | Aaron Cochrane C000568 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 19 | |||||||||||||
13619 | 13619 | Francis Cockrell C000576 | sen | MO | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
13278 | 13278 | James Codding C000580 | rep | PA | 1897-03-15 | 1899-03-03 | Republican | 15 | |||||||||||||
13280 | 13280 | David Colson C000649 | rep | KY | 1897-03-15 | 1899-03-03 | Republican | 11 | |||||||||||||
14268 | 14268 | William Connell C000687 | rep | PA | 1897-03-15 | 1899-03-03 | Republican | 11 | |||||||||||||
13282 | 13282 | James Connolly C000697 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 17 | |||||||||||||
13284 | 13284 | Edward Cooke C000731 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 6 | |||||||||||||
13909 | 13909 | James Cooney C000744 | rep | MO | 1897-03-15 | 1899-03-03 | Democrat | 7 | |||||||||||||
20233 | 20233 | Henry Cooper C000752 | rep | WI | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
15037 | 15037 | Samuel Cooper C000761 | rep | TX | 1897-03-15 | 1899-03-03 | Democrat | 2 | |||||||||||||
13913 | 13913 | John Corliss C000779 | rep | MI | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
15044 | 15044 | Robert Cousins C000811 | rep | IA | 1897-03-15 | 1899-03-03 | Republican | 5 | |||||||||||||
14272 | 14272 | William Cowherd C000825 | rep | MO | 1897-03-15 | 1899-03-03 | Democrat | 5 | |||||||||||||
13624 | 13624 | Nicholas Cox C000838 | rep | TN | 1897-03-15 | 1899-03-03 | Democrat | 7 | |||||||||||||
13285 | 13285 | John Cranford C000876 | rep | TX | 1897-03-15 | 1899-03-03 | Democrat | 4 | |||||||||||||
13919 | 13919 | Rousseau Crump C000957 | rep | MI | 1897-03-15 | 1899-03-03 | Republican | 10 | |||||||||||||
15902 | 15902 | Edgar Crumpacker C000958 | rep | IN | 1897-03-15 | 1899-03-03 | Republican | 10 | |||||||||||||
13927 | 13927 | Amos Cummings C000983 | rep | NY | 1897-03-15 | 1899-03-03 | Democrat | 10 | |||||||||||||
19271 | 19271 | Charles Curtis C001008 | rep | KS | 1897-03-15 | 1899-03-03 | Republican | 4 | |||||||||||||
13287 | 13287 | George Curtis C001010 | rep | IA | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
15922 | 15922 | John Dalzell D000016 | rep | PA | 1897-03-15 | 1899-03-03 | Republican | 22 | |||||||||||||
13632 | 13632 | Lorenzo Danford D000028 | rep | OH | 1897-03-15 | 1899-03-03 | Republican | 16 |
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);