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 district
This data as json, copyable, CSV (advanced)
Suggested facets: type, state, party, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13571 | 13571 | William Bate B000227 | sen | TN | 1899-12-04 | 1905-03-03 | 1 | Democrat | |||||||||||||
13620 | 13620 | Francis Cockrell C000576 | sen | MO | 1899-12-04 | 1905-03-03 | 1 | Democrat | |||||||||||||
13667 | 13667 | Addison Foster F000298 | sen | WA | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
13684 | 13684 | Marcus Hanna H000163 | sen | OH | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
13705 | 13705 | Joseph Hawley H000377 | sen | CT | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
13740 | 13740 | Louis McComas M000351 | sen | MD | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
13769 | 13769 | Joseph Quarles Q000003 | sen | WI | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
13805 | 13805 | William Stewart S000922 | sen | NV | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
13842 | 13842 | Thomas Bard B000138 | sen | CA | 1900-01-01 | 1905-03-03 | 1 | Republican | |||||||||||||
13935 | 13935 | Charles Dietrich D000341 | sen | NE | 1901-12-02 | 1905-03-03 | 1 | Republican | |||||||||||||
13966 | 13966 | Paris Gibson G000164 | sen | MT | 1901-12-02 | 1905-03-03 | 1 | Democrat | |||||||||||||
14009 | 14009 | George Hoar H000654 | sen | MA | 1901-12-02 | 1905-03-03 | 2 | Republican | |||||||||||||
14031 | 14031 | Thomas Kearns K000034 | sen | UT | 1901-12-02 | 1905-03-03 | 1 | Republican | |||||||||||||
14544 | 14544 | Charles Dick D000302 | sen | OH | 1904-03-24 | 1905-03-03 | 1 | Republican | |||||||||||||
14560 | 14560 | Nelson Aldrich A000083 | sen | RI | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
14573 | 14573 | Albert Beveridge B000429 | sen | IN | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
14612 | 14612 | Julius Burrows B001142 | sen | MI | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
14629 | 14629 | John Daniel D000035 | sen | VA | 1899-12-04 | 1905-03-03 | 1 | Democrat | |||||||||||||
14641 | 14641 | Chauncey Depew D000264 | sen | NY | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
14693 | 14693 | Eugene Hale H000029 | sen | ME | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
14737 | 14737 | John Kean K000028 | sen | NJ | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
14839 | 14839 | Hernando Money M000854 | sen | MS | 1899-12-04 | 1905-03-03 | 1 | Democrat | |||||||||||||
14867 | 14867 | Redfield Proctor P000547 | sen | VT | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
14887 | 14887 | Nathan Scott S000182 | sen | WV | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
14916 | 14916 | James Taliaferro T000026 | sen | FL | 1899-12-04 | 1905-03-03 | 1 | Democrat | |||||||||||||
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 | |||||||||||||
17125 | 17125 | Charles Culberson C000963 | sen | TX | 1899-12-04 | 1905-03-03 | 1 | Democrat | |||||||||||||
17331 | 17331 | Philander Knox K000296 | sen | PA | 1904-06-10 | 1905-03-03 | 1 | Republican | |||||||||||||
17347 | 17347 | Porter McCumber M000397 | sen | ND | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
17544 | 17544 | Lewis Ball B000100 | sen | DE | 1903-11-09 | 1905-03-03 | 1 | Republican | |||||||||||||
18739 | 18739 | Henry Lodge L000393 | sen | MA | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
14286 | 14286 | Edward De Nivernais D000230 | rep | CA | 1903-11-09 | 1905-03-03 | Democratic and Union Labor | -1 | |||||||||||||
14470 | 14470 | Bernard Rodey R000372 | rep | NM | 1903-11-09 | 1905-03-03 | Republican | -1 | |||||||||||||
14482 | 14482 | Burleigh Spalding S000695 | rep | ND | 1903-11-09 | 1905-03-03 | Republican | -1 | |||||||||||||
14509 | 14509 | Thomas Tongue T000309 | rep | OR | 1903-11-09 | 1905-03-03 | Republican | -1 | |||||||||||||
14591 | 14591 | Franklin Brooks B000878 | rep | CO | 1903-11-09 | 1905-03-03 | Republican | -1 | |||||||||||||
15201 | 15201 | George Lilley L000308 | rep | CT | 1903-11-09 | 1905-03-03 | Republican | -1 | |||||||||||||
15210 | 15210 | Thomas Marshall M000163 | rep | ND | 1903-11-09 | 1905-03-03 | Republican | -1 | |||||||||||||
15412 | 15412 | Francis Cushman C001018 | rep | WA | 1903-11-09 | 1905-03-03 | Republican | -1 | |||||||||||||
15730 | 15730 | Charles Scott S000166 | rep | KS | 1903-11-09 | 1905-03-03 | Republican | -1 | |||||||||||||
16299 | 16299 | Charles Burke B001087 | rep | SD | 1903-11-09 | 1905-03-03 | Republican | -1 | |||||||||||||
16464 | 16464 | Eben Martin M000176 | rep | SD | 1903-11-09 | 1905-03-03 | Republican | -1 | |||||||||||||
16479 | 16479 | Bird McGuire M000464 | rep | OK | 1903-11-09 | 1905-03-03 | Republican | -1 | |||||||||||||
16816 | 16816 | William Humphrey H000958 | rep | WA | 1903-11-09 | 1905-03-03 | Republican | -1 | |||||||||||||
18257 | 18257 | Jonah Kalanianaole K000004 | rep | HI | 1903-11-09 | 1905-03-03 | Republican | -1 | |||||||||||||
19364 | 19364 | Wesley Jones J000257 | rep | WA | 1903-11-09 | 1905-03-03 | Republican | -1 | |||||||||||||
14288 | 14288 | Federico Degetau D000196 | rep | PR | 1903-11-09 | 1905-03-03 | Republican | 0 | |||||||||||||
14357 | 14357 | Henry Houston H000823 | rep | DE | 1903-11-09 | 1905-03-03 | Democrat | 0 | |||||||||||||
14535 | 14535 | John Wilson W000599 | rep | AZ | 1903-11-09 | 1905-03-03 | Democrat | 0 | |||||||||||||
14925 | 14925 | Clarence Van Duzer V000033 | rep | NV | 1903-11-09 | 1905-03-03 | Democrat | 0 | |||||||||||||
18362 | 18362 | Franklin Mondell M000852 | rep | WY | 1903-11-09 | 1905-03-03 | Republican | 0 | |||||||||||||
14303 | 14303 | Martin Emerich E000170 | rep | IL | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
14388 | 14388 | Alfred Lucking L000500 | rep | MI | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
14474 | 14474 | Townsend Scudder S000202 | rep | NY | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
14601 | 14601 | Elmer Burkett B001103 | rep | NE | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
14648 | 14648 | Blackburn Dovener D000461 | rep | WV | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
14673 | 14673 | James Gillett G000202 | rep | CA | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
14699 | 14699 | Thomas Hedge H000441 | rep | IA | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
14705 | 14705 | James Hemenway H000467 | rep | IN | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
14713 | 14713 | Binger Hermann H000531 | rep | OR | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
14778 | 14778 | Rufus Lester L000255 | rep | GA | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
14985 | 14985 | Robert Bonynge B000623 | rep | CO | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
15078 | 15078 | Joseph Dixon D000372 | rep | MT | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
15126 | 15126 | Daniel Granger G000375 | rep | RI | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
15161 | 15161 | William Jackson J000029 | rep | MD | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
15231 | 15231 | Adolph Meyer M000679 | rep | LA | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
15332 | 15332 | Amos Allen A000112 | rep | ME | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
15360 | 15360 | Walter Brownlow B000962 | rep | TN | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
15775 | 15775 | James Tawney T000060 | rep | MN | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
15866 | 15866 | Henry Bingham B000469 | rep | PA | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
15967 | 15967 | David Foster F000300 | rep | VT | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
16001 | 16001 | Edward Henry H000505 | rep | CT | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
16039 | 16039 | George Lawrence L000133 | rep | MA | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
16061 | 16061 | Henry Loudenslager L000450 | rep | NJ | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
16066 | 16066 | Robert Macon M000035 | rep | AR | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
16410 | 16410 | Ollie James J000051 | rep | KY | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
16445 | 16445 | George Legaré L000219 | rep | SC | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
16563 | 16563 | John Shafroth S000279 | rep | CO | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
16606 | 16606 | George Taylor T000078 | rep | AL | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
16805 | 16805 | Joseph Howell H000866 | rep | UT | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
16858 | 16858 | James Lloyd L000380 | rep | MO | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
16991 | 16991 | Stephen Sparkman S000702 | rep | FL | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
17315 | 17315 | William Jones J000259 | rep | VA | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
17461 | 17461 | Cyrus Sulloway S001063 | rep | NH | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
17595 | 17595 | Ezekiel Candler C000110 | rep | MS | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
17947 | 17947 | John Small S000500 | rep | NC | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
19274 | 19274 | Charles Curtis C001008 | rep | KS | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
20236 | 20236 | Henry Cooper C000752 | rep | WI | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
20387 | 20387 | Burton French F000375 | rep | ID | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
20664 | 20664 | Nicholas Longworth L000433 | rep | OH | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
22404 | 22404 | Morris Sheppard S000337 | rep | TX | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
14245 | 14245 | Theodore Bell B000347 | rep | CA | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
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 | |||||||||||||
14285 | 14285 | Robert Davis D000132 | rep | FL | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
14321 | 14321 | Henry Gibson G000161 | rep | TN | 1903-11-09 | 1905-03-03 | Republican | 2 | |||||||||||||
14419 | 14419 | Robert Miers M000700 | rep | IN | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
14520 | 14520 | Martin Wade W000007 | rep | IA | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
14546 | 14546 | Henry Adams A000037 | rep | WI | 1903-11-09 | 1905-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);