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 1907-03-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class, district
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14967 | 14967 | Ernest Acheson A000019 | rep | PA | 1905-12-04 | 1907-03-03 | Republican | 24 | |||||||||||||
14547 | 14547 | Henry Adams A000037 | rep | WI | 1905-12-04 | 1907-03-03 | Republican | 2 | |||||||||||||
14554 | 14554 | Robert Adams A000044 | rep | PA | 1905-12-04 | 1907-03-03 | Republican | 2 | |||||||||||||
17048 | 17048 | William Adamson A000051 | rep | GA | 1905-12-04 | 1907-03-03 | Democrat | 4 | |||||||||||||
16670 | 16670 | Wyatt Aiken A000064 | rep | SC | 1905-12-04 | 1907-03-03 | Democrat | 3 | |||||||||||||
15327 | 15327 | De Alexander A000091 | rep | NY | 1905-12-04 | 1907-03-03 | Republican | 36 | |||||||||||||
14224 | 14224 | Russell Alger A000107 | sen | MI | 1902-01-01 | 1907-03-03 | 2 | Republican | |||||||||||||
14226 | 14226 | James Allee A000110 | sen | DE | 1903-11-09 | 1907-03-03 | 2 | Republican | |||||||||||||
15333 | 15333 | Amos Allen A000112 | rep | ME | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
14562 | 14562 | Henry Allen A000124 | rep | NJ | 1905-12-04 | 1907-03-03 | Republican | 6 | |||||||||||||
15833 | 15833 | Butler Ames A000173 | rep | MA | 1905-12-04 | 1907-03-03 | Republican | 5 | |||||||||||||
15839 | 15839 | William Andrews A000252 | rep | NM | 1905-12-04 | 1907-03-03 | Republican | -1 | |||||||||||||
15843 | 15843 | John Andrus A000254 | rep | NY | 1905-12-04 | 1907-03-03 | Republican | 19 | |||||||||||||
14569 | 14569 | Joseph Babcock B000004 | rep | WI | 1905-12-04 | 1907-03-03 | Republican | 3 | |||||||||||||
16257 | 16257 | Augustus Bacon B000014 | sen | GA | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
14974 | 14974 | Joseph Bailey B000044 | sen | TX | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
17555 | 17555 | John Bankhead B000110 | rep | AL | 1905-12-04 | 1907-03-03 | Democrat | 6 | |||||||||||||
14976 | 14976 | Henry Bannon B000118 | rep | OH | 1905-12-04 | 1907-03-03 | Republican | 10 | |||||||||||||
16681 | 16681 | Andrew Barchfeld B000133 | rep | PA | 1905-12-04 | 1907-03-03 | Republican | 32 | |||||||||||||
16268 | 16268 | Richard Bartholdt B000196 | rep | MO | 1905-12-04 | 1907-03-03 | Republican | 10 | |||||||||||||
16278 | 16278 | Charles Bartlett B000199 | rep | GA | 1905-12-04 | 1907-03-03 | Democrat | 6 | |||||||||||||
15850 | 15850 | Arthur Bates B000230 | rep | PA | 1905-12-04 | 1907-03-03 | Republican | 25 | |||||||||||||
16285 | 16285 | James Beall B000270 | rep | TX | 1905-12-04 | 1907-03-03 | Democrat | 5 | |||||||||||||
14980 | 14980 | James Bede B000297 | rep | MN | 1905-12-04 | 1907-03-03 | Republican | 8 | |||||||||||||
14572 | 14572 | Jacob Beidler B000317 | rep | OH | 1905-12-04 | 1907-03-03 | Republican | 20 | |||||||||||||
19574 | 19574 | Thomas Bell B000348 | rep | GA | 1905-12-04 | 1907-03-03 | Democrat | 9 | |||||||||||||
16690 | 16690 | William Bennet B000370 | rep | NY | 1905-12-04 | 1907-03-03 | Republican | 17 | |||||||||||||
15341 | 15341 | Joseph Bennett B000378 | rep | KY | 1905-12-04 | 1907-03-03 | Republican | 9 | |||||||||||||
14958 | 14958 | Alfred Benson B000386 | sen | KS | 1906-01-01 | 1907-03-03 | 2 | Republican | |||||||||||||
13861 | 13861 | James Berry B000418 | sen | AR | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
15867 | 15867 | Henry Bingham B000469 | rep | PA | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
14983 | 14983 | Benjamin Birdsall B000481 | rep | IA | 1905-12-04 | 1907-03-03 | Republican | 3 | |||||||||||||
14580 | 14580 | Roswell Bishop B000489 | rep | MI | 1905-12-04 | 1907-03-03 | Republican | 9 | |||||||||||||
14582 | 14582 | Edmond Blackburn B000507 | rep | NC | 1905-12-04 | 1907-03-03 | Republican | 8 | |||||||||||||
13870 | 13870 | Joseph Blackburn B000508 | sen | KY | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
14986 | 14986 | Robert Bonynge B000623 | rep | CO | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
15348 | 15348 | Henry Boutell B000672 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 9 | |||||||||||||
15352 | 15352 | Eaton Bowers B000689 | rep | MS | 1905-12-04 | 1907-03-03 | Democrat | 6 | |||||||||||||
14586 | 14586 | Justin Bowersock B000693 | rep | KS | 1905-12-04 | 1907-03-03 | Republican | 2 | |||||||||||||
14589 | 14589 | Sydney Bowie B000695 | rep | AL | 1905-12-04 | 1907-03-03 | Democrat | 4 | |||||||||||||
15875 | 15875 | Thomas Bradley B000747 | rep | NY | 1905-12-04 | 1907-03-03 | Republican | 20 | |||||||||||||
15883 | 15883 | William Brantley B000770 | rep | GA | 1905-12-04 | 1907-03-03 | Democrat | 11 | |||||||||||||
14993 | 14993 | Abraham Brick B000819 | rep | IN | 1905-12-04 | 1907-03-03 | Republican | 13 | |||||||||||||
14590 | 14590 | Moses Broocks B000870 | rep | TX | 1905-12-04 | 1907-03-03 | Democrat | 2 | |||||||||||||
14592 | 14592 | Franklin Brooks B000878 | rep | CO | 1905-12-04 | 1907-03-03 | Republican | -1 | |||||||||||||
16700 | 16700 | Robert Broussard B000896 | rep | LA | 1905-12-04 | 1907-03-03 | Democrat | 3 | |||||||||||||
14595 | 14595 | Webster Brown B000946 | rep | WI | 1905-12-04 | 1907-03-03 | Republican | 10 | |||||||||||||
15361 | 15361 | Walter Brownlow B000962 | rep | TN | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
15004 | 15004 | Charles Brumm B000977 | rep | PA | 1905-12-04 | 1907-03-03 | Republican | 12 | |||||||||||||
15010 | 15010 | Stephen Brundidge B000979 | rep | AR | 1905-12-04 | 1907-03-03 | Democrat | 2 | |||||||||||||
14597 | 14597 | Clarence Buckman B001029 | rep | MN | 1905-12-04 | 1907-03-03 | Republican | 6 | |||||||||||||
16714 | 16714 | George Burgess B001083 | rep | TX | 1905-12-04 | 1907-03-03 | Democrat | 9 | |||||||||||||
16300 | 16300 | Charles Burke B001087 | rep | SD | 1905-12-04 | 1907-03-03 | Republican | -1 | |||||||||||||
16304 | 16304 | James Burke B001093 | rep | PA | 1905-12-04 | 1907-03-03 | Republican | 31 | |||||||||||||
16313 | 16313 | Edwin Burleigh B001105 | rep | ME | 1905-12-04 | 1907-03-03 | Republican | 3 | |||||||||||||
16320 | 16320 | Albert Burleson B001110 | rep | TX | 1905-12-04 | 1907-03-03 | Democrat | 10 | |||||||||||||
17583 | 17583 | John Burnett B001121 | rep | AL | 1905-12-04 | 1907-03-03 | Democrat | 7 | |||||||||||||
15013 | 15013 | Henry Burnham B001125 | sen | NH | 1901-12-02 | 1907-03-03 | 2 | Republican | |||||||||||||
15015 | 15015 | Hiram Burton B001151 | rep | DE | 1905-12-04 | 1907-03-03 | Republican | 0 | |||||||||||||
13901 | 13901 | Joseph Burton B001154 | sen | KS | 1901-12-02 | 1907-03-03 | 2 | Republican | |||||||||||||
19561 | 19561 | Theodore Burton B001159 | rep | OH | 1905-12-04 | 1907-03-03 | Republican | 21 | |||||||||||||
14614 | 14614 | Mounce Butler B001185 | rep | TN | 1905-12-04 | 1907-03-03 | Democrat | 4 | |||||||||||||
19244 | 19244 | Thomas Butler B001192 | rep | PA | 1905-12-04 | 1907-03-03 | Republican | 7 | |||||||||||||
15365 | 15365 | Adam Byrd B001207 | rep | MS | 1905-12-04 | 1907-03-03 | Democrat | 5 | |||||||||||||
17088 | 17088 | William Calder C000025 | rep | NY | 1905-12-04 | 1907-03-03 | Republican | 6 | |||||||||||||
15372 | 15372 | William Calderhead C000026 | rep | KS | 1905-12-04 | 1907-03-03 | Republican | 5 | |||||||||||||
18084 | 18084 | Philip Campbell C000097 | rep | KS | 1905-12-04 | 1907-03-03 | Republican | 3 | |||||||||||||
14615 | 14615 | William Campbell C000106 | rep | OH | 1905-12-04 | 1907-03-03 | Republican | 5 | |||||||||||||
17596 | 17596 | Ezekiel Candler C000110 | rep | MS | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
18108 | 18108 | Joseph Cannon C000121 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 18 | |||||||||||||
15379 | 15379 | Adin Capron C000135 | rep | RI | 1905-12-04 | 1907-03-03 | Republican | 2 | |||||||||||||
13904 | 13904 | Edward Carmack C000157 | sen | TN | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
15024 | 15024 | Henry Cassel C000235 | rep | PA | 1905-12-04 | 1907-03-03 | Republican | 9 | |||||||||||||
14620 | 14620 | George Castor C000244 | rep | PA | 1905-12-04 | 1907-03-03 | Republican | 3 | |||||||||||||
15027 | 15027 | John Chaney C000301 | rep | IN | 1905-12-04 | 1907-03-03 | Republican | 2 | |||||||||||||
15383 | 15383 | Pleasant Chapman C000315 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 24 | |||||||||||||
18583 | 18583 | Frank Clark C000430 | rep | FL | 1905-12-04 | 1907-03-03 | Democrat | 2 | |||||||||||||
17616 | 17616 | James Clark C000437 | rep | MO | 1905-12-04 | 1907-03-03 | Democrat | 9 | |||||||||||||
13906 | 13906 | William Clark C000454 | sen | MT | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
16332 | 16332 | Henry Clayton C000495 | rep | AL | 1905-12-04 | 1907-03-03 | Democrat | 3 | |||||||||||||
18597 | 18597 | William Cockran C000575 | rep | NY | 1905-12-04 | 1907-03-03 | Democrat | 12 | |||||||||||||
15389 | 15389 | William Cocks C000578 | rep | NY | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
15392 | 15392 | Ralph Cole C000612 | rep | OH | 1905-12-04 | 1907-03-03 | Republican | 8 | |||||||||||||
15032 | 15032 | James Conner C000690 | rep | IA | 1905-12-04 | 1907-03-03 | Republican | 10 | |||||||||||||
15398 | 15398 | Allen Cooper C000745 | rep | PA | 1905-12-04 | 1907-03-03 | Republican | 23 | |||||||||||||
20237 | 20237 | Henry Cooper C000752 | rep | WI | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
15401 | 15401 | Harry Coudrey C000805 | rep | MO | 1905-12-04 | 1907-03-03 | Republican | 12 | |||||||||||||
15048 | 15048 | Robert Cousins C000811 | rep | IA | 1905-12-04 | 1907-03-03 | Republican | 5 | |||||||||||||
15050 | 15050 | Winthrop Crane C000875 | sen | MA | 1904-01-01 | 1907-03-03 | 2 | Republican | |||||||||||||
14624 | 14624 | George Cromer C000924 | rep | IN | 1905-12-04 | 1907-03-03 | Republican | 8 | |||||||||||||
15906 | 15906 | Edgar Crumpacker C000958 | rep | IN | 1905-12-04 | 1907-03-03 | Republican | 10 | |||||||||||||
15062 | 15062 | Shelby Cullom C000973 | sen | IL | 1901-12-02 | 1907-03-03 | 2 | Republican | |||||||||||||
15912 | 15912 | Frank Currier C000999 | rep | NH | 1905-12-04 | 1907-03-03 | Republican | 2 | |||||||||||||
19275 | 19275 | Charles Curtis C001008 | rep | KS | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
15413 | 15413 | Francis Cushman C001018 | rep | WA | 1905-12-04 | 1907-03-03 | Republican | -1 | |||||||||||||
14625 | 14625 | Thomas Dale D000010 | rep | PA | 1905-12-04 | 1907-03-03 | Republican | 10 | |||||||||||||
15926 | 15926 | John Dalzell D000016 | rep | PA | 1905-12-04 | 1907-03-03 | Republican | 30 | |||||||||||||
15066 | 15066 | Archibald Darragh D000060 | rep | MI | 1905-12-04 | 1907-03-03 | Republican | 11 | |||||||||||||
15073 | 15073 | Robert Davey D000081 | rep | LA | 1905-12-04 | 1907-03-03 | Democrat | 2 | |||||||||||||
17136 | 17136 | James Davidson D000084 | rep | WI | 1905-12-04 | 1907-03-03 | Republican | 8 |
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);