legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
438 rows where "end" is on date 1905-03-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: type, state, start, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14966 | 14966 | Ernest Acheson A000019 | rep | PA | 1903-11-09 | 1905-03-03 | Republican | 24 | |||||||||||||
14546 | 14546 | Henry Adams A000037 | rep | WI | 1903-11-09 | 1905-03-03 | Republican | 2 | |||||||||||||
14553 | 14553 | Robert Adams A000044 | rep | PA | 1903-11-09 | 1905-03-03 | Republican | 2 | |||||||||||||
17047 | 17047 | William Adamson A000051 | rep | GA | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
16669 | 16669 | Wyatt Aiken A000064 | rep | SC | 1903-11-09 | 1905-03-03 | Democrat | 3 | |||||||||||||
14560 | 14560 | Nelson Aldrich A000083 | sen | RI | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
15326 | 15326 | De Alexander A000091 | rep | NY | 1903-11-09 | 1905-03-03 | Republican | 36 | |||||||||||||
15332 | 15332 | Amos Allen A000112 | rep | ME | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
15832 | 15832 | Butler Ames A000173 | rep | MA | 1903-11-09 | 1905-03-03 | Republican | 5 | |||||||||||||
14568 | 14568 | Joseph Babcock B000004 | rep | WI | 1903-11-09 | 1905-03-03 | Republican | 3 | |||||||||||||
14238 | 14238 | De Badger B000021 | rep | OH | 1903-11-09 | 1905-03-03 | Democrat | 12 | |||||||||||||
14239 | 14239 | Robert Baker B000073 | rep | NY | 1903-11-09 | 1905-03-03 | Democrat | 6 | |||||||||||||
17544 | 17544 | Lewis Ball B000100 | sen | DE | 1903-11-09 | 1905-03-03 | 1 | Republican | |||||||||||||
14243 | 14243 | Thomas Ball B000101 | rep | TX | 1903-11-09 | 1905-03-03 | Democrat | 8 | |||||||||||||
17554 | 17554 | John Bankhead B000110 | rep | AL | 1903-11-09 | 1905-03-03 | Democrat | 6 | |||||||||||||
13842 | 13842 | Thomas Bard B000138 | sen | CA | 1900-01-01 | 1905-03-03 | 1 | Republican | |||||||||||||
16267 | 16267 | Richard Bartholdt B000196 | rep | MO | 1903-11-09 | 1905-03-03 | Republican | 10 | |||||||||||||
16277 | 16277 | Charles Bartlett B000199 | rep | GA | 1903-11-09 | 1905-03-03 | Democrat | 6 | |||||||||||||
14244 | 14244 | Edward Bassett B000225 | rep | NY | 1903-11-09 | 1905-03-03 | Democrat | 5 | |||||||||||||
13571 | 13571 | William Bate B000227 | sen | TN | 1899-12-04 | 1905-03-03 | 1 | Democrat | |||||||||||||
15849 | 15849 | Arthur Bates B000230 | rep | PA | 1903-11-09 | 1905-03-03 | Republican | 25 | |||||||||||||
16284 | 16284 | James Beall B000270 | rep | TX | 1903-11-09 | 1905-03-03 | Democrat | 5 | |||||||||||||
14979 | 14979 | James Bede B000297 | rep | MN | 1903-11-09 | 1905-03-03 | Republican | 8 | |||||||||||||
14571 | 14571 | Jacob Beidler B000317 | rep | OH | 1903-11-09 | 1905-03-03 | Republican | 20 | |||||||||||||
14245 | 14245 | Theodore Bell B000347 | rep | CA | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
14246 | 14246 | Allan Benny B000385 | rep | NJ | 1903-11-09 | 1905-03-03 | Democrat | 9 | |||||||||||||
14250 | 14250 | Maecenas Benton B000397 | rep | MO | 1903-11-09 | 1905-03-03 | Democrat | 15 | |||||||||||||
14573 | 14573 | Albert Beveridge B000429 | sen | IN | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
15866 | 15866 | Henry Bingham B000469 | rep | PA | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
14982 | 14982 | Benjamin Birdsall B000481 | rep | IA | 1903-11-09 | 1905-03-03 | Republican | 3 | |||||||||||||
14579 | 14579 | Roswell Bishop B000489 | rep | MI | 1903-11-09 | 1905-03-03 | Republican | 9 | |||||||||||||
14985 | 14985 | Robert Bonynge B000623 | rep | CO | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
14253 | 14253 | Vincent Boreing B000637 | rep | KY | 1903-11-09 | 1905-03-03 | Republican | 11 | |||||||||||||
15347 | 15347 | Henry Boutell B000672 | rep | IL | 1903-11-09 | 1905-03-03 | Republican | 9 | |||||||||||||
15351 | 15351 | Eaton Bowers B000689 | rep | MS | 1903-11-09 | 1905-03-03 | Democrat | 6 | |||||||||||||
14585 | 14585 | Justin Bowersock B000693 | rep | KS | 1903-11-09 | 1905-03-03 | Republican | 2 | |||||||||||||
14588 | 14588 | Sydney Bowie B000695 | rep | AL | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
15874 | 15874 | Thomas Bradley B000747 | rep | NY | 1903-11-09 | 1905-03-03 | Republican | 20 | |||||||||||||
18060 | 18060 | Frank Brandegee B000769 | rep | CT | 1903-11-09 | 1905-03-03 | Republican | 3 | |||||||||||||
15882 | 15882 | William Brantley B000770 | rep | GA | 1903-11-09 | 1905-03-03 | Democrat | 11 | |||||||||||||
14256 | 14256 | Phanor Breazeale B000781 | rep | LA | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
14992 | 14992 | Abraham Brick B000819 | rep | IN | 1903-11-09 | 1905-03-03 | Republican | 13 | |||||||||||||
14591 | 14591 | Franklin Brooks B000878 | rep | CO | 1903-11-09 | 1905-03-03 | Republican | -1 | |||||||||||||
16699 | 16699 | Robert Broussard B000896 | rep | LA | 1903-11-09 | 1905-03-03 | Democrat | 3 | |||||||||||||
14257 | 14257 | James Brown B000923 | rep | PA | 1903-11-09 | 1905-03-03 | Ind. Republican | 32 | |||||||||||||
14594 | 14594 | Webster Brown B000946 | rep | WI | 1903-11-09 | 1905-03-03 | Republican | 10 | |||||||||||||
15360 | 15360 | Walter Brownlow B000962 | rep | TN | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
15009 | 15009 | Stephen Brundidge B000979 | rep | AR | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
14596 | 14596 | Clarence Buckman B001029 | rep | MN | 1903-11-09 | 1905-03-03 | Republican | 6 | |||||||||||||
16713 | 16713 | George Burgess B001083 | rep | TX | 1903-11-09 | 1905-03-03 | Democrat | 9 | |||||||||||||
14259 | 14259 | Henry Burk B001085 | rep | PA | 1903-11-09 | 1905-03-03 | Republican | 3 | |||||||||||||
16299 | 16299 | Charles Burke B001087 | rep | SD | 1903-11-09 | 1905-03-03 | Republican | -1 | |||||||||||||
14601 | 14601 | Elmer Burkett B001103 | rep | NE | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
16312 | 16312 | Edwin Burleigh B001105 | rep | ME | 1903-11-09 | 1905-03-03 | Republican | 3 | |||||||||||||
16319 | 16319 | Albert Burleson B001110 | rep | TX | 1903-11-09 | 1905-03-03 | Democrat | 10 | |||||||||||||
17582 | 17582 | John Burnett B001121 | rep | AL | 1903-11-09 | 1905-03-03 | Democrat | 7 | |||||||||||||
14612 | 14612 | Julius Burrows B001142 | sen | MI | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
19560 | 19560 | Theodore Burton B001159 | rep | OH | 1903-11-09 | 1905-03-03 | Republican | 21 | |||||||||||||
14261 | 14261 | James Butler B001178 | rep | MO | 1903-11-09 | 1905-03-03 | Democrat | 12 | |||||||||||||
19243 | 19243 | Thomas Butler B001192 | rep | PA | 1903-11-09 | 1905-03-03 | Republican | 7 | |||||||||||||
15364 | 15364 | Adam Byrd B001207 | rep | MS | 1903-11-09 | 1905-03-03 | Democrat | 5 | |||||||||||||
15371 | 15371 | William Calderhead C000026 | rep | KS | 1903-11-09 | 1905-03-03 | Republican | 5 | |||||||||||||
15019 | 15019 | Ben Caldwell C000029 | rep | IL | 1903-11-09 | 1905-03-03 | Democrat | 21 | |||||||||||||
18083 | 18083 | Philip Campbell C000097 | rep | KS | 1903-11-09 | 1905-03-03 | Republican | 3 | |||||||||||||
17595 | 17595 | Ezekiel Candler C000110 | rep | MS | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
18107 | 18107 | Joseph Cannon C000121 | rep | IL | 1903-11-09 | 1905-03-03 | Republican | 18 | |||||||||||||
15378 | 15378 | Adin Capron C000135 | rep | RI | 1903-11-09 | 1905-03-03 | Republican | 2 | |||||||||||||
15023 | 15023 | Henry Cassel C000235 | rep | PA | 1903-11-09 | 1905-03-03 | Republican | 9 | |||||||||||||
14263 | 14263 | John Cassingham C000239 | rep | OH | 1903-11-09 | 1905-03-03 | Democrat | 17 | |||||||||||||
14619 | 14619 | George Castor C000244 | rep | PA | 1903-11-09 | 1905-03-03 | Republican | 3 | |||||||||||||
15890 | 15890 | Moses Clapp C000414 | sen | MN | 1901-12-02 | 1905-03-03 | 1 | Republican | |||||||||||||
15896 | 15896 | Clarence Clark C000425 | sen | WY | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
17615 | 17615 | James Clark C000437 | rep | MO | 1903-11-09 | 1905-03-03 | Democrat | 9 | |||||||||||||
16331 | 16331 | Henry Clayton C000495 | rep | AL | 1903-11-09 | 1905-03-03 | Democrat | 3 | |||||||||||||
14267 | 14267 | Charles Cochran C000562 | rep | MO | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
18596 | 18596 | William Cockran C000575 | rep | NY | 1903-11-09 | 1905-03-03 | Democrat | 12 | |||||||||||||
13620 | 13620 | Francis Cockrell C000576 | sen | MO | 1899-12-04 | 1905-03-03 | 1 | Democrat | |||||||||||||
14271 | 14271 | William Connell C000687 | rep | PA | 1903-11-09 | 1905-03-03 | Republican | 10 | |||||||||||||
15031 | 15031 | James Conner C000690 | rep | IA | 1903-11-09 | 1905-03-03 | Republican | 10 | |||||||||||||
15397 | 15397 | Allen Cooper C000745 | rep | PA | 1903-11-09 | 1905-03-03 | Republican | 23 | |||||||||||||
20236 | 20236 | Henry Cooper C000752 | rep | WI | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
15040 | 15040 | Samuel Cooper C000761 | rep | TX | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
15047 | 15047 | Robert Cousins C000811 | rep | IA | 1903-11-09 | 1905-03-03 | Republican | 5 | |||||||||||||
14275 | 14275 | William Cowherd C000825 | rep | MO | 1903-11-09 | 1905-03-03 | Democrat | 5 | |||||||||||||
14276 | 14276 | George Croft C000921 | rep | SC | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
14277 | 14277 | Theodore Croft C000922 | rep | SC | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
14623 | 14623 | George Cromer C000924 | rep | IN | 1903-11-09 | 1905-03-03 | Republican | 8 | |||||||||||||
14280 | 14280 | Joseph Crowley C000943 | rep | IL | 1903-11-09 | 1905-03-03 | Democrat | 23 | |||||||||||||
15905 | 15905 | Edgar Crumpacker C000958 | rep | IN | 1903-11-09 | 1905-03-03 | Republican | 10 | |||||||||||||
17125 | 17125 | Charles Culberson C000963 | sen | TX | 1899-12-04 | 1905-03-03 | 1 | Democrat | |||||||||||||
15911 | 15911 | Frank Currier C000999 | rep | NH | 1903-11-09 | 1905-03-03 | Republican | 2 | |||||||||||||
19274 | 19274 | Charles Curtis C001008 | rep | KS | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
15412 | 15412 | Francis Cushman C001018 | rep | WA | 1903-11-09 | 1905-03-03 | Republican | -1 | |||||||||||||
15925 | 15925 | John Dalzell D000016 | rep | PA | 1903-11-09 | 1905-03-03 | Republican | 30 | |||||||||||||
14629 | 14629 | John Daniel D000035 | sen | VA | 1899-12-04 | 1905-03-03 | 1 | Democrat | |||||||||||||
14281 | 14281 | Milton Daniels D000042 | rep | CA | 1903-11-09 | 1905-03-03 | Republican | 8 | |||||||||||||
15065 | 15065 | Archibald Darragh D000060 | rep | MI | 1903-11-09 | 1905-03-03 | Republican | 11 | |||||||||||||
15072 | 15072 | Robert Davey D000081 | rep | LA | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
17135 | 17135 | James Davidson D000084 | rep | WI | 1903-11-09 | 1905-03-03 | Republican | 8 | |||||||||||||
18607 | 18607 | Charles Davis D000093 | rep | MN | 1903-11-09 | 1905-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);