legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
446 rows where "end" is on date 1909-03-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: state, party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14968 | 14968 | Ernest Acheson A000019 | rep | PA | 1907-12-02 | 1909-03-03 | Republican | 24 | |||||||||||||
16664 | 16664 | John Adair A000027 | rep | IN | 1907-12-02 | 1909-03-03 | Democrat | 8 | |||||||||||||
17049 | 17049 | William Adamson A000051 | rep | GA | 1907-12-02 | 1909-03-03 | Democrat | 4 | |||||||||||||
16671 | 16671 | Wyatt Aiken A000064 | rep | SC | 1907-12-02 | 1909-03-03 | Democrat | 3 | |||||||||||||
15328 | 15328 | De Alexander A000091 | rep | NY | 1907-12-02 | 1909-03-03 | Republican | 36 | |||||||||||||
17532 | 17532 | Joshua Alexander A000098 | rep | MO | 1907-12-02 | 1909-03-03 | Democrat | 3 | |||||||||||||
15334 | 15334 | Amos Allen A000112 | rep | ME | 1907-12-02 | 1909-03-03 | Republican | 1 | |||||||||||||
14236 | 14236 | William Allison A000160 | sen | IA | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
15834 | 15834 | Butler Ames A000173 | rep | MA | 1907-12-02 | 1909-03-03 | Republican | 5 | |||||||||||||
15840 | 15840 | William Andrews A000252 | rep | NM | 1907-12-02 | 1909-03-03 | Republican | -1 | |||||||||||||
15844 | 15844 | John Andrus A000254 | rep | NY | 1907-12-02 | 1909-03-03 | Republican | 19 | |||||||||||||
14237 | 14237 | Levi Ankeny A000258 | sen | WA | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
16251 | 16251 | Timothy Ansberry A000259 | rep | OH | 1907-12-02 | 1909-03-03 | Democrat | 5 | |||||||||||||
19187 | 19187 | Daniel Anthony A000261 | rep | KS | 1907-12-02 | 1909-03-03 | Republican | 1 | |||||||||||||
22476 | 22476 | William Ashbrook A000306 | rep | OH | 1907-12-02 | 1909-03-03 | Democrat | 17 | |||||||||||||
14977 | 14977 | Henry Bannon B000118 | rep | OH | 1907-12-02 | 1909-03-03 | Republican | 10 | |||||||||||||
16682 | 16682 | Andrew Barchfeld B000133 | rep | PA | 1907-12-02 | 1909-03-03 | Republican | 32 | |||||||||||||
15336 | 15336 | Charles Barclay B000135 | rep | PA | 1907-12-02 | 1909-03-03 | Republican | 21 | |||||||||||||
17061 | 17061 | Henry Barnhart B000164 | rep | IN | 1907-12-02 | 1909-03-03 | Democrat | 13 | |||||||||||||
16269 | 16269 | Richard Bartholdt B000196 | rep | MO | 1907-12-02 | 1909-03-03 | Republican | 10 | |||||||||||||
16279 | 16279 | Charles Bartlett B000199 | rep | GA | 1907-12-02 | 1909-03-03 | Democrat | 6 | |||||||||||||
15339 | 15339 | George Bartlett B000203 | rep | NV | 1907-12-02 | 1909-03-03 | Democrat | 0 | |||||||||||||
15851 | 15851 | Arthur Bates B000230 | rep | PA | 1907-12-02 | 1909-03-03 | Republican | 25 | |||||||||||||
14978 | 14978 | Joseph Beale B000267 | rep | PA | 1907-12-02 | 1909-03-03 | Republican | 27 | |||||||||||||
16286 | 16286 | James Beall B000270 | rep | TX | 1907-12-02 | 1909-03-03 | Democrat | 5 | |||||||||||||
14981 | 14981 | James Bede B000297 | rep | MN | 1907-12-02 | 1909-03-03 | Republican | 8 | |||||||||||||
19575 | 19575 | Thomas Bell B000348 | rep | GA | 1907-12-02 | 1909-03-03 | Democrat | 9 | |||||||||||||
16691 | 16691 | William Bennet B000370 | rep | NY | 1907-12-02 | 1909-03-03 | Republican | 17 | |||||||||||||
15342 | 15342 | Joseph Bennett B000378 | rep | KY | 1907-12-02 | 1909-03-03 | Republican | 9 | |||||||||||||
15868 | 15868 | Henry Bingham B000469 | rep | PA | 1907-12-02 | 1909-03-03 | Republican | 1 | |||||||||||||
14984 | 14984 | Benjamin Birdsall B000481 | rep | IA | 1907-12-02 | 1909-03-03 | Republican | 3 | |||||||||||||
14987 | 14987 | Robert Bonynge B000623 | rep | CO | 1907-12-02 | 1909-03-03 | Republican | 1 | |||||||||||||
17564 | 17564 | Charles Booher B000626 | rep | MO | 1907-12-02 | 1909-03-03 | Democrat | 4 | |||||||||||||
15349 | 15349 | Henry Boutell B000672 | rep | IL | 1907-12-02 | 1909-03-03 | Republican | 9 | |||||||||||||
15353 | 15353 | Eaton Bowers B000689 | rep | MS | 1907-12-02 | 1909-03-03 | Democrat | 6 | |||||||||||||
14989 | 14989 | John Boyd B000717 | rep | NE | 1907-12-02 | 1909-03-03 | Republican | 3 | |||||||||||||
15876 | 15876 | Thomas Bradley B000747 | rep | NY | 1907-12-02 | 1909-03-03 | Republican | 20 | |||||||||||||
18062 | 18062 | Frank Brandegee B000769 | sen | CT | 1905-05-10 | 1909-03-03 | 3 | Republican | |||||||||||||
15884 | 15884 | William Brantley B000770 | rep | GA | 1907-12-02 | 1909-03-03 | Democrat | 11 | |||||||||||||
14994 | 14994 | Abraham Brick B000819 | rep | IN | 1907-12-02 | 1909-03-03 | Republican | 13 | |||||||||||||
14996 | 14996 | Joseph Brodhead B000860 | rep | PA | 1907-12-02 | 1909-03-03 | Democrat | 26 | |||||||||||||
16701 | 16701 | Robert Broussard B000896 | rep | LA | 1907-12-02 | 1909-03-03 | Democrat | 3 | |||||||||||||
15362 | 15362 | Walter Brownlow B000962 | rep | TN | 1907-12-02 | 1909-03-03 | Republican | 1 | |||||||||||||
15005 | 15005 | Charles Brumm B000977 | rep | PA | 1907-12-02 | 1909-03-03 | Republican | 12 | |||||||||||||
15011 | 15011 | Stephen Brundidge B000979 | rep | AR | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
15012 | 15012 | William Bryan B000994 | sen | FL | 1907-12-02 | 1909-03-03 | 3 | Democrat | |||||||||||||
16715 | 16715 | George Burgess B001083 | rep | TX | 1907-12-02 | 1909-03-03 | Democrat | 9 | |||||||||||||
16305 | 16305 | James Burke B001093 | rep | PA | 1907-12-02 | 1909-03-03 | Republican | 31 | |||||||||||||
16314 | 16314 | Edwin Burleigh B001105 | rep | ME | 1907-12-02 | 1909-03-03 | Republican | 3 | |||||||||||||
16321 | 16321 | Albert Burleson B001110 | rep | TX | 1907-12-02 | 1909-03-03 | Democrat | 10 | |||||||||||||
17584 | 17584 | John Burnett B001121 | rep | AL | 1907-12-02 | 1909-03-03 | Democrat | 7 | |||||||||||||
15016 | 15016 | Hiram Burton B001151 | rep | DE | 1907-12-02 | 1909-03-03 | Republican | 0 | |||||||||||||
19562 | 19562 | Theodore Burton B001159 | rep | OH | 1907-12-02 | 1909-03-03 | Republican | 21 | |||||||||||||
19245 | 19245 | Thomas Butler B001192 | rep | PA | 1907-12-02 | 1909-03-03 | Republican | 7 | |||||||||||||
15366 | 15366 | Adam Byrd B001207 | rep | MS | 1907-12-02 | 1909-03-03 | Democrat | 5 | |||||||||||||
17089 | 17089 | William Calder C000025 | rep | NY | 1907-12-02 | 1909-03-03 | Republican | 6 | |||||||||||||
15373 | 15373 | William Calderhead C000026 | rep | KS | 1907-12-02 | 1909-03-03 | Republican | 5 | |||||||||||||
15020 | 15020 | Ben Caldwell C000029 | rep | IL | 1907-12-02 | 1909-03-03 | Democrat | 21 | |||||||||||||
15021 | 15021 | Thomas Cale C000042 | rep | AK | 1907-12-02 | 1909-03-03 | Independent | 0 | |||||||||||||
18085 | 18085 | Philip Campbell C000097 | rep | KS | 1907-12-02 | 1909-03-03 | Republican | 3 | |||||||||||||
17597 | 17597 | Ezekiel Candler C000110 | rep | MS | 1907-12-02 | 1909-03-03 | Democrat | 1 | |||||||||||||
18109 | 18109 | Joseph Cannon C000121 | rep | IL | 1907-12-02 | 1909-03-03 | Republican | 18 | |||||||||||||
15380 | 15380 | Adin Capron C000135 | rep | RI | 1907-12-02 | 1909-03-03 | Republican | 2 | |||||||||||||
17604 | 17604 | Charles Carlin C000151 | rep | VA | 1907-12-02 | 1909-03-03 | Democrat | 8 | |||||||||||||
18916 | 18916 | Charles Carter C000196 | rep | OK | 1907-12-02 | 1909-03-03 | Democrat | 4 | |||||||||||||
17098 | 17098 | William Cary C000218 | rep | WI | 1907-12-02 | 1909-03-03 | Republican | 4 | |||||||||||||
15025 | 15025 | Henry Cassel C000235 | rep | PA | 1907-12-02 | 1909-03-03 | Republican | 9 | |||||||||||||
15026 | 15026 | Henry Caulfield C000256 | rep | MO | 1907-12-02 | 1909-03-03 | Republican | 11 | |||||||||||||
15028 | 15028 | John Chaney C000301 | rep | IN | 1907-12-02 | 1909-03-03 | Republican | 2 | |||||||||||||
15384 | 15384 | Pleasant Chapman C000315 | rep | IL | 1907-12-02 | 1909-03-03 | Republican | 24 | |||||||||||||
18584 | 18584 | Frank Clark C000430 | rep | FL | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
17617 | 17617 | James Clark C000437 | rep | MO | 1907-12-02 | 1909-03-03 | Democrat | 9 | |||||||||||||
16729 | 16729 | James Clarke C000463 | sen | AR | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
15387 | 15387 | Alexander Clay C000478 | sen | GA | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
16333 | 16333 | Henry Clayton C000495 | rep | AL | 1907-12-02 | 1909-03-03 | Democrat | 3 | |||||||||||||
18598 | 18598 | William Cockran C000575 | rep | NY | 1907-12-02 | 1909-03-03 | Democrat | 12 | |||||||||||||
15390 | 15390 | William Cocks C000578 | rep | NY | 1907-12-02 | 1909-03-03 | Republican | 1 | |||||||||||||
15393 | 15393 | Ralph Cole C000612 | rep | OH | 1907-12-02 | 1909-03-03 | Republican | 8 | |||||||||||||
15033 | 15033 | James Conner C000690 | rep | IA | 1907-12-02 | 1909-03-03 | Republican | 10 | |||||||||||||
15034 | 15034 | George Cook C000717 | rep | CO | 1907-12-02 | 1909-03-03 | Republican | -1 | |||||||||||||
15395 | 15395 | Joel Cook C000718 | rep | PA | 1907-12-02 | 1909-03-03 | Republican | 2 | |||||||||||||
15399 | 15399 | Allen Cooper C000745 | rep | PA | 1907-12-02 | 1909-03-03 | Republican | 23 | |||||||||||||
20238 | 20238 | Henry Cooper C000752 | rep | WI | 1907-12-02 | 1909-03-03 | Republican | 1 | |||||||||||||
15041 | 15041 | Samuel Cooper C000761 | rep | TX | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
15402 | 15402 | Harry Coudrey C000805 | rep | MO | 1907-12-02 | 1909-03-03 | Republican | 12 | |||||||||||||
15049 | 15049 | Robert Cousins C000811 | rep | IA | 1907-12-02 | 1909-03-03 | Republican | 5 | |||||||||||||
17119 | 17119 | William Cox C000840 | rep | IN | 1907-12-02 | 1909-03-03 | Democrat | 3 | |||||||||||||
15405 | 15405 | William Craig C000861 | rep | AL | 1907-12-02 | 1909-03-03 | Democrat | 4 | |||||||||||||
22526 | 22526 | William Cravens C000886 | rep | AR | 1907-12-02 | 1909-03-03 | Democrat | 4 | |||||||||||||
15055 | 15055 | William Crawford C000896 | rep | NC | 1907-12-02 | 1909-03-03 | Democrat | 10 | |||||||||||||
15907 | 15907 | Edgar Crumpacker C000958 | rep | IN | 1907-12-02 | 1909-03-03 | Republican | 10 | |||||||||||||
18141 | 18141 | Albert Cummins C000988 | sen | IA | 1908-11-24 | 1909-03-03 | 3 | Republican | |||||||||||||
15913 | 15913 | Frank Currier C000999 | rep | NH | 1907-12-02 | 1909-03-03 | Republican | 2 | |||||||||||||
15414 | 15414 | Francis Cushman C001018 | rep | WA | 1907-12-02 | 1909-03-03 | Republican | -1 | |||||||||||||
15927 | 15927 | John Dalzell D000016 | rep | PA | 1907-12-02 | 1909-03-03 | Republican | 30 | |||||||||||||
15067 | 15067 | Archibald Darragh D000060 | rep | MI | 1907-12-02 | 1909-03-03 | Republican | 11 | |||||||||||||
16744 | 16744 | James Davenport D000074 | rep | OK | 1907-12-02 | 1909-03-03 | Democrat | 3 | |||||||||||||
15074 | 15074 | Robert Davey D000081 | rep | LA | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
17137 | 17137 | James Davidson D000084 | rep | WI | 1907-12-02 | 1909-03-03 | Republican | 8 | |||||||||||||
18609 | 18609 | Charles Davis D000093 | rep | MN | 1907-12-02 | 1909-03-03 | Republican | 3 |
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);