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 district
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13861 | 13861 | James Berry B000418 | sen | AR | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
13870 | 13870 | Joseph Blackburn B000508 | sen | KY | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
13901 | 13901 | Joseph Burton B001154 | sen | KS | 1901-12-02 | 1907-03-03 | 2 | Republican | |||||||||||||
13904 | 13904 | Edward Carmack C000157 | sen | TN | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
13906 | 13906 | William Clark C000454 | sen | MT | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
13939 | 13939 | Fred Dubois D000509 | sen | ID | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
14080 | 14080 | Joseph Millard M000710 | sen | NE | 1901-12-02 | 1907-03-03 | 2 | Republican | |||||||||||||
14096 | 14096 | John Morgan M000954 | sen | AL | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
14122 | 14122 | Thomas Patterson P000130 | sen | CO | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
14224 | 14224 | Russell Alger A000107 | sen | MI | 1902-01-01 | 1907-03-03 | 2 | Republican | |||||||||||||
14225 | 14225 | John Dryden D000507 | sen | NJ | 1902-01-01 | 1907-03-03 | 2 | Republican | |||||||||||||
14226 | 14226 | James Allee A000110 | sen | DE | 1903-11-09 | 1907-03-03 | 2 | Republican | |||||||||||||
14336 | 14336 | Arthur Gorman G000326 | sen | MD | 1903-11-09 | 1907-03-03 | 3 | Democrat | |||||||||||||
14667 | 14667 | John Gearin G000112 | sen | OR | 1905-12-04 | 1907-03-03 | 2 | Democrat | |||||||||||||
14958 | 14958 | Alfred Benson B000386 | sen | KS | 1906-01-01 | 1907-03-03 | 2 | Republican | |||||||||||||
14974 | 14974 | Joseph Bailey B000044 | sen | TX | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
15013 | 15013 | Henry Burnham B001125 | sen | NH | 1901-12-02 | 1907-03-03 | 2 | Republican | |||||||||||||
15050 | 15050 | Winthrop Crane C000875 | sen | MA | 1904-01-01 | 1907-03-03 | 2 | Republican | |||||||||||||
15062 | 15062 | Shelby Cullom C000973 | sen | IL | 1901-12-02 | 1907-03-03 | 2 | Republican | |||||||||||||
15088 | 15088 | Jonathan Dolliver D000404 | sen | IA | 1901-03-04 | 1907-03-03 | 2 | Republican | |||||||||||||
15096 | 15096 | Stephen Elkins E000110 | sen | WV | 1901-12-02 | 1907-03-03 | 2 | Republican | |||||||||||||
15100 | 15100 | Murphy Foster F000310 | sen | LA | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
15111 | 15111 | William Frye F000398 | sen | ME | 1901-12-02 | 1907-03-03 | 2 | Republican | |||||||||||||
15122 | 15122 | Robert Gamble G000032 | sen | SD | 1901-12-02 | 1907-03-03 | 2 | Republican | |||||||||||||
15222 | 15222 | Anselm McLaurin M000542 | sen | MS | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
15321 | 15321 | George Wetmore W000312 | sen | RI | 1901-12-02 | 1907-03-03 | 2 | Republican | |||||||||||||
16257 | 16257 | Augustus Bacon B000014 | sen | GA | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
16472 | 16472 | Thomas Martin M000200 | sen | VA | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
16616 | 16616 | Benjamin Tillman T000274 | sen | SC | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
17864 | 17864 | Knute Nelson N000040 | sen | MN | 1901-12-02 | 1907-03-03 | 2 | Republican | |||||||||||||
19104 | 19104 | Furnifold Simmons S000415 | sen | NC | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
19152 | 19152 | Francis Warren W000164 | sen | WY | 1901-12-02 | 1907-03-03 | 2 | Republican | |||||||||||||
14592 | 14592 | Franklin Brooks B000878 | rep | CO | 1905-12-04 | 1907-03-03 | Republican | -1 | |||||||||||||
15202 | 15202 | George Lilley L000308 | rep | CT | 1905-12-04 | 1907-03-03 | Republican | -1 | |||||||||||||
15211 | 15211 | Thomas Marshall M000163 | rep | ND | 1905-12-04 | 1907-03-03 | Republican | -1 | |||||||||||||
15413 | 15413 | Francis Cushman C001018 | rep | WA | 1905-12-04 | 1907-03-03 | Republican | -1 | |||||||||||||
15731 | 15731 | Charles Scott S000166 | rep | KS | 1905-12-04 | 1907-03-03 | Republican | -1 | |||||||||||||
15839 | 15839 | William Andrews A000252 | rep | NM | 1905-12-04 | 1907-03-03 | Republican | -1 | |||||||||||||
16300 | 16300 | Charles Burke B001087 | rep | SD | 1905-12-04 | 1907-03-03 | Republican | -1 | |||||||||||||
16465 | 16465 | Eben Martin M000176 | rep | SD | 1905-12-04 | 1907-03-03 | Republican | -1 | |||||||||||||
16480 | 16480 | Bird McGuire M000464 | rep | OK | 1905-12-04 | 1907-03-03 | Republican | -1 | |||||||||||||
16769 | 16769 | Asle Gronna G000491 | rep | ND | 1905-12-04 | 1907-03-03 | Republican | -1 | |||||||||||||
16817 | 16817 | William Humphrey H000958 | rep | WA | 1905-12-04 | 1907-03-03 | Republican | -1 | |||||||||||||
18258 | 18258 | Jonah Kalanianaole K000004 | rep | HI | 1905-12-04 | 1907-03-03 | Republican | -1 | |||||||||||||
19365 | 19365 | Wesley Jones J000257 | rep | WA | 1905-12-04 | 1907-03-03 | Republican | -1 | |||||||||||||
14926 | 14926 | Clarence Van Duzer V000033 | rep | NV | 1905-12-04 | 1907-03-03 | Democrat | 0 | |||||||||||||
14945 | 14945 | Frank Waskey W000184 | rep | AK | 1905-12-04 | 1907-03-03 | Democrat | 0 | |||||||||||||
15015 | 15015 | Hiram Burton B001151 | rep | DE | 1905-12-04 | 1907-03-03 | Republican | 0 | |||||||||||||
15589 | 15589 | Tulio Larrinaga L000102 | rep | PR | 1905-12-04 | 1907-03-03 | Unionist | 0 | |||||||||||||
16976 | 16976 | Marcus Smith S000589 | rep | AZ | 1905-12-04 | 1907-03-03 | Democrat | 0 | |||||||||||||
18363 | 18363 | Franklin Mondell M000852 | rep | WY | 1905-12-04 | 1907-03-03 | Republican | 0 | |||||||||||||
14649 | 14649 | Blackburn Dovener D000461 | rep | WV | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
14674 | 14674 | James Gillett G000202 | rep | CA | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
14700 | 14700 | Thomas Hedge H000441 | rep | IA | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
14714 | 14714 | Binger Hermann H000531 | rep | OR | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
14779 | 14779 | Rufus Lester L000255 | rep | GA | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
14901 | 14901 | Thomas Smith S000618 | rep | MD | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
14986 | 14986 | Robert Bonynge B000623 | rep | CO | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
15079 | 15079 | Joseph Dixon D000372 | rep | MT | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
15098 | 15098 | John Foster F000307 | rep | IN | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
15127 | 15127 | Daniel Granger G000375 | rep | RI | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
15232 | 15232 | Adolph Meyer M000679 | rep | LA | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
15249 | 15249 | Ernest Pollard P000413 | rep | NE | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
15333 | 15333 | Amos Allen A000112 | rep | ME | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
15361 | 15361 | Walter Brownlow B000962 | rep | TN | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
15389 | 15389 | William Cocks C000578 | rep | NY | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
15429 | 15429 | Edwin Denby D000232 | rep | MI | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
15447 | 15447 | William Englebright E000183 | rep | CA | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
15776 | 15776 | James Tawney T000060 | rep | MN | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
15867 | 15867 | Henry Bingham B000469 | rep | PA | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
15968 | 15968 | David Foster F000300 | rep | VT | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
16002 | 16002 | Edward Henry H000505 | rep | CT | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
16040 | 16040 | George Lawrence L000133 | rep | MA | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
16062 | 16062 | Henry Loudenslager L000450 | rep | NJ | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
16067 | 16067 | Robert Macon M000035 | rep | AR | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
16411 | 16411 | Ollie James J000051 | rep | KY | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
16446 | 16446 | George Legaré L000219 | rep | SC | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
16607 | 16607 | George Taylor T000078 | rep | AL | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
16806 | 16806 | Joseph Howell H000866 | rep | UT | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
16859 | 16859 | James Lloyd L000380 | rep | MO | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
16992 | 16992 | Stephen Sparkman S000702 | rep | FL | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
17316 | 17316 | William Jones J000259 | rep | VA | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
17462 | 17462 | Cyrus Sulloway S001063 | rep | NH | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
17596 | 17596 | Ezekiel Candler C000110 | rep | MS | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
17948 | 17948 | John Small S000500 | rep | NC | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
18386 | 18386 | James Overstreet O000143 | rep | GA | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
19275 | 19275 | Charles Curtis C001008 | rep | KS | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
19406 | 19406 | Martin Madden M000038 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
20237 | 20237 | Henry Cooper C000752 | rep | WI | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
20388 | 20388 | Burton French F000375 | rep | ID | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
20665 | 20665 | Nicholas Longworth L000433 | rep | OH | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
22405 | 22405 | Morris Sheppard S000337 | rep | TX | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
14586 | 14586 | Justin Bowersock B000693 | rep | KS | 1905-12-04 | 1907-03-03 | Republican | 2 | |||||||||||||
14590 | 14590 | Moses Broocks B000870 | rep | TX | 1905-12-04 | 1907-03-03 | Democrat | 2 | |||||||||||||
14631 | 14631 | Thomas Davis D000137 | rep | WV | 1905-12-04 | 1907-03-03 | Democrat | 2 | |||||||||||||
14637 | 14637 | Alston Dayton D000163 | rep | WV | 1905-12-04 | 1907-03-03 | Republican | 2 | |||||||||||||
14730 | 14730 | Herschel Hogg H000703 | rep | CO | 1905-12-04 | 1907-03-03 | Republican | 2 | |||||||||||||
14739 | 14739 | John Kennedy K000108 | rep | NE | 1905-12-04 | 1907-03-03 | Republican | 2 |
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);