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 party_affiliations
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14236 | 14236 | William Allison A000160 | sen | IA | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
14237 | 14237 | Levi Ankeny A000258 | sen | WA | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
14312 | 14312 | Joseph Foraker F000253 | sen | OH | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
14316 | 14316 | Charles Fulton F000420 | sen | OR | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
14344 | 14344 | Henry Hansbrough H000169 | sen | ND | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
14356 | 14356 | Albert Hopkins H000770 | sen | IL | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
14366 | 14366 | Alfred Kittredge K000255 | sen | SD | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
14378 | 14378 | Asbury Latimer L000114 | sen | SC | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
14387 | 14387 | Chester Long L000412 | sen | KS | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
14412 | 14412 | James McCreary M000382 | sen | KY | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
14442 | 14442 | Thomas Platt P000383 | sen | NY | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
14497 | 14497 | Henry Teller T000116 | sen | CO | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
14706 | 14706 | James Hemenway H000467 | sen | IN | 1905-12-04 | 1909-03-03 | 3 | Republican | |||||||||||||
14868 | 14868 | Redfield Proctor P000547 | sen | VT | 1905-12-04 | 1909-03-03 | 1 | Republican | |||||||||||||
14961 | 14961 | William Whyte W000435 | sen | MD | 1906-01-01 | 1909-03-03 | 3 | Democrat | |||||||||||||
14968 | 14968 | Ernest Acheson A000019 | rep | PA | 1907-12-02 | 1909-03-03 | Republican | 24 | |||||||||||||
14977 | 14977 | Henry Bannon B000118 | rep | OH | 1907-12-02 | 1909-03-03 | Republican | 10 | |||||||||||||
14978 | 14978 | Joseph Beale B000267 | rep | PA | 1907-12-02 | 1909-03-03 | Republican | 27 | |||||||||||||
14981 | 14981 | James Bede B000297 | rep | MN | 1907-12-02 | 1909-03-03 | Republican | 8 | |||||||||||||
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 | |||||||||||||
14989 | 14989 | John Boyd B000717 | rep | NE | 1907-12-02 | 1909-03-03 | Republican | 3 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
15016 | 15016 | Hiram Burton B001151 | rep | DE | 1907-12-02 | 1909-03-03 | Republican | 0 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
15041 | 15041 | Samuel Cooper C000761 | rep | TX | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
15049 | 15049 | Robert Cousins C000811 | rep | IA | 1907-12-02 | 1909-03-03 | Republican | 5 | |||||||||||||
15055 | 15055 | William Crawford C000896 | rep | NC | 1907-12-02 | 1909-03-03 | Democrat | 10 | |||||||||||||
15067 | 15067 | Archibald Darragh D000060 | rep | MI | 1907-12-02 | 1909-03-03 | Republican | 11 | |||||||||||||
15074 | 15074 | Robert Davey D000081 | rep | LA | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
15077 | 15077 | Beman Dawes D000146 | rep | OH | 1907-12-02 | 1909-03-03 | Republican | 15 | |||||||||||||
15092 | 15092 | Charles Dunwell D000557 | rep | NY | 1907-12-02 | 1909-03-03 | Republican | 3 | |||||||||||||
15099 | 15099 | John Foster F000307 | rep | IN | 1907-12-02 | 1909-03-03 | Republican | 1 | |||||||||||||
15113 | 15113 | Elmer Fulton F000421 | rep | OK | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
15119 | 15119 | John Gaines G000007 | rep | TN | 1907-12-02 | 1909-03-03 | Democrat | 6 | |||||||||||||
15125 | 15125 | Clarence Gilhams G000187 | rep | IN | 1907-12-02 | 1909-03-03 | Republican | 12 | |||||||||||||
15128 | 15128 | Daniel Granger G000375 | rep | RI | 1907-12-02 | 1909-03-03 | Democrat | 1 | |||||||||||||
15130 | 15130 | Richard Hackett H000004 | rep | NC | 1907-12-02 | 1909-03-03 | Democrat | 8 | |||||||||||||
15131 | 15131 | Thomas Hackney H000007 | rep | MO | 1907-12-02 | 1909-03-03 | Democrat | 15 | |||||||||||||
15132 | 15132 | Warren Haggott H000017 | rep | CO | 1907-12-02 | 1909-03-03 | Republican | 2 | |||||||||||||
15134 | 15134 | Nathan Hale H000035 | rep | TN | 1907-12-02 | 1909-03-03 | Republican | 2 | |||||||||||||
15135 | 15135 | Philo Hall H000066 | rep | SD | 1907-12-02 | 1909-03-03 | Republican | -1 | |||||||||||||
15136 | 15136 | Daniel Hamilton H000107 | rep | IA | 1907-12-02 | 1909-03-03 | Democrat | 6 | |||||||||||||
15137 | 15137 | John Harding H000190 | rep | OH | 1907-12-02 | 1909-03-03 | Republican | 3 | |||||||||||||
15141 | 15141 | Kittredge Haskins H000322 | rep | VT | 1907-12-02 | 1909-03-03 | Republican | 2 | |||||||||||||
15152 | 15152 | William Hepburn H000523 | rep | IA | 1907-12-02 | 1909-03-03 | Republican | 8 | |||||||||||||
15155 | 15155 | Wilson Hill H000614 | rep | MS | 1907-12-02 | 1909-03-03 | Democrat | 4 | |||||||||||||
15159 | 15159 | Elias Holliday H000724 | rep | IN | 1907-12-02 | 1909-03-03 | Republican | 5 | |||||||||||||
15162 | 15162 | William Jackson J000029 | rep | MD | 1907-12-02 | 1909-03-03 | Republican | 1 | |||||||||||||
15163 | 15163 | Addison James J000043 | rep | KY | 1907-12-02 | 1909-03-03 | Republican | 3 | |||||||||||||
15170 | 15170 | John Jenkins J000084 | rep | WI | 1907-12-02 | 1909-03-03 | Republican | 11 | |||||||||||||
15171 | 15171 | William Kimball K000184 | rep | KY | 1907-12-02 | 1909-03-03 | Democrat | 7 | |||||||||||||
15177 | 15177 | William Kitchin K000252 | rep | NC | 1907-12-02 | 1909-03-03 | Democrat | 5 | |||||||||||||
15180 | 15180 | Philip Knopf K000289 | rep | IL | 1907-12-02 | 1909-03-03 | Republican | 7 | |||||||||||||
15182 | 15182 | James Lamar L000028 | rep | MO | 1907-12-02 | 1909-03-03 | Democrat | 16 | |||||||||||||
15185 | 15185 | William Lamar L000031 | rep | FL | 1907-12-02 | 1909-03-03 | Democrat | 3 | |||||||||||||
15191 | 15191 | Charles Landis L000050 | rep | IN | 1907-12-02 | 1909-03-03 | Republican | 9 | |||||||||||||
15192 | 15192 | Jay Laning L000079 | rep | OH | 1907-12-02 | 1909-03-03 | Republican | 14 | |||||||||||||
15193 | 15193 | Eugene Leake L000175 | rep | NJ | 1907-12-02 | 1909-03-03 | Democrat | 9 | |||||||||||||
15194 | 15194 | John Lenahan L000239 | rep | PA | 1907-12-02 | 1909-03-03 | Democrat | 11 | |||||||||||||
15200 | 15200 | Elijah Lewis L000281 | rep | GA | 1907-12-02 | 1909-03-03 | Democrat | 3 | |||||||||||||
15203 | 15203 | George Lilley L000308 | rep | CT | 1907-12-02 | 1909-03-03 | Republican | -1 | |||||||||||||
15208 | 15208 | Charles Littlefield L000355 | rep | ME | 1907-12-02 | 1909-03-03 | Republican | 2 | |||||||||||||
15212 | 15212 | Thomas Marshall M000163 | rep | ND | 1907-12-02 | 1909-03-03 | Republican | -1 | |||||||||||||
15214 | 15214 | Charles McGavin M000444 | rep | IL | 1907-12-02 | 1909-03-03 | Republican | 8 | |||||||||||||
15220 | 15220 | Frank McLain M000533 | rep | MS | 1907-12-02 | 1909-03-03 | Democrat | 7 | |||||||||||||
15224 | 15224 | Samuel McMillan M000569 | rep | NY | 1907-12-02 | 1909-03-03 | Republican | 21 | |||||||||||||
15233 | 15233 | Adolph Meyer M000679 | rep | LA | 1907-12-02 | 1909-03-03 | Democrat | 1 | |||||||||||||
15235 | 15235 | Grant Mouser M001048 | rep | OH | 1907-12-02 | 1909-03-03 | Republican | 13 | |||||||||||||
15236 | 15236 | James Murphy M001095 | rep | WI | 1907-12-02 | 1909-03-03 | Democrat | 3 | |||||||||||||
15243 | 15243 | Jesse Overstreet O000144 | rep | IN | 1907-12-02 | 1909-03-03 | Republican | 7 | |||||||||||||
15244 | 15244 | William Parker P000073 | rep | SD | 1907-12-02 | 1909-03-03 | Republican | -1 | |||||||||||||
15250 | 15250 | Ernest Pollard P000413 | rep | NE | 1907-12-02 | 1909-03-03 | Republican | 1 | |||||||||||||
15251 | 15251 | Peter Porter P000445 | rep | NY | 1907-12-02 | 1909-03-03 | Ind. Republican | 34 | |||||||||||||
15256 | 15256 | Llewellyn Powers P000491 | rep | ME | 1907-12-02 | 1909-03-03 | Republican | 4 | |||||||||||||
15257 | 15257 | Le Pratt P000504 | rep | NJ | 1907-12-02 | 1909-03-03 | Democrat | 8 | |||||||||||||
15263 | 15263 | John Reyburn R000168 | rep | PA | 1907-12-02 | 1909-03-03 | Republican | 2 | |||||||||||||
15270 | 15270 | John Rixey R000287 | rep | VA | 1907-12-02 | 1909-03-03 | Democrat | -1 | |||||||||||||
15275 | 15275 | William Ryan R000563 | rep | NY | 1907-12-02 | 1909-03-03 | Democrat | 35 | |||||||||||||
15285 | 15285 | James Sherman S000345 | rep | NY | 1907-12-02 | 1909-03-03 | Republican | 27 | |||||||||||||
15288 | 15288 | Campbell Slemp S000485 | rep | VA | 1907-12-02 | 1909-03-03 | Republican | 9 | |||||||||||||
15298 | 15298 | George Smith S000541 | rep | IL | 1907-12-02 | 1909-03-03 | Republican | 25 | |||||||||||||
15299 | 15299 | Madison Smith S000588 | rep | MO | 1907-12-02 | 1909-03-03 | Democrat | 13 | |||||||||||||
15303 | 15303 | George Waldo W000036 | rep | NY | 1907-12-02 | 1909-03-03 | Republican | 5 | |||||||||||||
15306 | 15306 | Capell Weems W000249 | rep | OH | 1907-12-02 | 1909-03-03 | Republican | 16 | |||||||||||||
15310 | 15310 | Ariosto Wiley W000466 | rep | AL | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
15311 | 15311 | Oliver Wiley W000469 | rep | AL | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
15312 | 15312 | Harry Wolf W000674 | rep | MD | 1907-12-02 | 1909-03-03 | Democrat | 3 | |||||||||||||
15313 | 15313 | Frank Gary G000090 | sen | SC | 1908-01-01 | 1909-03-03 | 3 | Democrat | |||||||||||||
15314 | 15314 | William Milton M000788 | sen | FL | 1908-01-01 | 1909-03-03 | 3 | Democrat |
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);