legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
404 rows where "end" is on date 1899-03-03 sorted by district
This data as json, copyable, CSV (advanced)
Suggested facets: state, class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12388 | 12388 | Roger Mills M000777 | sen | TX | 1893-03-04 | 1899-03-03 | 1 | Democrat | |||||||||||||
12542 | 12542 | Charles Faulkner F000045 | sen | WV | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
12586 | 12586 | George Gray G000396 | sen | DE | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
12691 | 12691 | John Mitchell M000821 | sen | WI | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
12698 | 12698 | Edward Murphy M001090 | sen | NY | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
12751 | 12751 | Samuel Pasco P000095 | sen | FL | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
12770 | 12770 | William Roach R000290 | sen | ND | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
12790 | 12790 | James Smith S000561 | sen | NJ | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
12835 | 12835 | David Turpie T000432 | sen | IN | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
12852 | 12852 | Stephen White W000394 | sen | CA | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
13072 | 13072 | Lee Mantle M000116 | sen | MT | 1895-12-02 | 1899-03-03 | 1 | Silver Republican | |||||||||||||
13203 | 13203 | Edward Walthall W000111 | sen | MS | 1895-12-02 | 1899-03-03 | 2 | Democrat | |||||||||||||
13216 | 13216 | John Wilson W000602 | sen | WA | 1895-12-02 | 1899-03-03 | 1 | Republican | |||||||||||||
13228 | 13228 | Frank Cannon C000118 | sen | UT | 1896-01-22 | 1899-03-03 | 1 | Silver Republican | |||||||||||||
13436 | 13436 | Justin Morrill M000969 | sen | VT | 1897-03-15 | 1899-03-03 | 3 | Republican | |||||||||||||
13556 | 13556 | William Allen A000153 | sen | NE | 1893-08-07 | 1899-03-03 | 1 | Populist | |||||||||||||
13570 | 13570 | William Bate B000227 | sen | TN | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
13619 | 13619 | Francis Cockrell C000576 | sen | MO | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
13638 | 13638 | Cushman Davis D000095 | sen | MN | 1893-08-07 | 1899-03-03 | 1 | Republican | |||||||||||||
13683 | 13683 | Marcus Hanna H000163 | sen | OH | 1897-03-15 | 1899-03-03 | 1 | Republican | |||||||||||||
13704 | 13704 | Joseph Hawley H000377 | sen | CT | 1893-08-07 | 1899-03-03 | 1 | Republican | |||||||||||||
13804 | 13804 | William Stewart S000922 | sen | NV | 1893-08-07 | 1899-03-03 | 1 | Silver | |||||||||||||
14127 | 14127 | Matthew Quay Q000006 | sen | PA | 1893-03-04 | 1899-03-03 | 1 | Republican | |||||||||||||
14335 | 14335 | Arthur Gorman G000326 | sen | MD | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
14559 | 14559 | Nelson Aldrich A000083 | sen | RI | 1893-08-07 | 1899-03-03 | 1 | Republican | |||||||||||||
14611 | 14611 | Julius Burrows B001142 | sen | MI | 1895-12-02 | 1899-03-03 | 1 | Republican | |||||||||||||
14628 | 14628 | John Daniel D000035 | sen | VA | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
14692 | 14692 | Eugene Hale H000029 | sen | ME | 1893-08-07 | 1899-03-03 | 1 | Republican | |||||||||||||
14838 | 14838 | Hernando Money M000854 | sen | MS | 1897-03-15 | 1899-03-03 | 1 | Democrat | |||||||||||||
14866 | 14866 | Redfield Proctor P000547 | sen | VT | 1893-08-07 | 1899-03-03 | 1 | Republican | |||||||||||||
15895 | 15895 | Clarence Clark C000425 | sen | WY | 1895-12-02 | 1899-03-03 | 1 | Republican | |||||||||||||
18738 | 18738 | Henry Lodge L000393 | sen | MA | 1893-03-04 | 1899-03-03 | 1 | Republican | |||||||||||||
13262 | 13262 | Jeremiah Botkin B000654 | rep | KS | 1897-03-15 | 1899-03-03 | Populist | -1 | |||||||||||||
13270 | 13270 | James Callahan C000053 | rep | OK | 1897-03-15 | 1899-03-03 | Free Silver | -1 | |||||||||||||
13372 | 13372 | William Jones J000260 | rep | WA | 1897-03-15 | 1899-03-03 | Silver Republican | -1 | |||||||||||||
13373 | 13373 | John Kelley K000060 | rep | SD | 1897-03-15 | 1899-03-03 | Populist | -1 | |||||||||||||
13376 | 13376 | Freeman Knowles K000293 | rep | SD | 1897-03-15 | 1899-03-03 | Populist | -1 | |||||||||||||
13634 | 13634 | Samuel Davenport D000077 | rep | PA | 1897-03-15 | 1899-03-03 | Republican | -1 | |||||||||||||
13980 | 13980 | Galusha Grow G000507 | rep | PA | 1897-03-15 | 1899-03-03 | Republican | -1 | |||||||||||||
16354 | 16354 | Harvey Fergusson F000083 | rep | NM | 1897-03-15 | 1899-03-03 | Democrat | -1 | |||||||||||||
22275 | 22275 | James Lewis L000284 | rep | WA | 1897-03-15 | 1899-03-03 | Democrat | -1 | |||||||||||||
13316 | 13316 | Levin Handy H000156 | rep | DE | 1897-03-15 | 1899-03-03 | Democrat | 0 | |||||||||||||
13445 | 13445 | John Osborne O000113 | rep | WY | 1897-03-15 | 1899-03-03 | Democrat | 0 | |||||||||||||
16906 | 16906 | Francis Newlands N000069 | rep | NV | 1897-03-15 | 1899-03-03 | Democrat | 0 | |||||||||||||
16974 | 16974 | Marcus Smith S000589 | rep | AZ | 1897-03-15 | 1899-03-03 | Democrat | 0 | |||||||||||||
13242 | 13242 | Isaac Barber B000121 | rep | MD | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
13254 | 13254 | Joseph Belford B000327 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
13268 | 13268 | Case Broderick B000856 | rep | KS | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
13276 | 13276 | Samuel Clark C000452 | rep | IA | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
13312 | 13312 | James Gunn G000525 | rep | ID | 1897-03-15 | 1899-03-03 | Populist | 1 | |||||||||||||
13321 | 13321 | Charles Hartman H000300 | rep | MT | 1897-03-15 | 1899-03-03 | Silver Republican | 1 | |||||||||||||
13482 | 13482 | Harry Skinner S000468 | rep | NC | 1897-03-15 | 1899-03-03 | Populist | 1 | |||||||||||||
13500 | 13500 | Jesse Strode S001007 | rep | NE | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
13539 | 13539 | Ashley Wright W000754 | rep | MA | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
13554 | 13554 | John Allen A000134 | rep | MS | 1897-03-15 | 1899-03-03 | Democrat | 1 | |||||||||||||
13567 | 13567 | John Barham B000140 | rep | CA | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
13764 | 13764 | Horace Powers P000490 | rep | VT | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
13781 | 13781 | Thomas Reed R000128 | rep | ME | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
13895 | 13895 | Melville Bull B001048 | rep | RI | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
13913 | 13913 | John Corliss C000779 | rep | MI | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
13949 | 13949 | William Elliott E000129 | rep | SC | 1897-03-15 | 1899-03-03 | Democrat | 1 | |||||||||||||
14059 | 14059 | Philip McCulloch M000391 | rep | AR | 1897-03-15 | 1899-03-03 | Democrat | 1 | |||||||||||||
14157 | 14157 | William Shattuc S000300 | rep | OH | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
14212 | 14212 | Charles Wheeler W000331 | rep | KY | 1897-03-15 | 1899-03-03 | Democrat | 1 | |||||||||||||
14240 | 14240 | Thomas Ball B000101 | rep | TX | 1897-03-15 | 1899-03-03 | Democrat | 1 | |||||||||||||
14506 | 14506 | Thomas Tongue T000309 | rep | OR | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
14645 | 14645 | Blackburn Dovener D000461 | rep | WV | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
14702 | 14702 | James Hemenway H000467 | rep | IN | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
14775 | 14775 | Rufus Lester L000255 | rep | GA | 1897-03-15 | 1899-03-03 | Democrat | 1 | |||||||||||||
15228 | 15228 | Adolph Meyer M000679 | rep | LA | 1897-03-15 | 1899-03-03 | Democrat | 1 | |||||||||||||
15357 | 15357 | Walter Brownlow B000962 | rep | TN | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
15561 | 15561 | Martin Johnson J000162 | rep | ND | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
15772 | 15772 | James Tawney T000060 | rep | MN | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
15863 | 15863 | Henry Bingham B000469 | rep | PA | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
15998 | 15998 | Edward Henry H000505 | rep | CT | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
16036 | 16036 | George Lawrence L000133 | rep | MA | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
16058 | 16058 | Henry Loudenslager L000450 | rep | NJ | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
16560 | 16560 | John Shafroth S000279 | rep | CO | 1897-03-15 | 1899-03-03 | Silver Republican | 1 | |||||||||||||
16603 | 16603 | George Taylor T000078 | rep | AL | 1897-03-15 | 1899-03-03 | Democrat | 1 | |||||||||||||
16855 | 16855 | James Lloyd L000380 | rep | MO | 1897-03-15 | 1899-03-03 | Democrat | 1 | |||||||||||||
16988 | 16988 | Stephen Sparkman S000702 | rep | FL | 1897-03-15 | 1899-03-03 | Democrat | 1 | |||||||||||||
17312 | 17312 | William Jones J000259 | rep | VA | 1897-03-15 | 1899-03-03 | Democrat | 1 | |||||||||||||
17458 | 17458 | Cyrus Sulloway S001063 | rep | NH | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
18322 | 18322 | James Mann M000104 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
20233 | 20233 | Henry Cooper C000752 | rep | WI | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
21840 | 21840 | William King K000216 | rep | UT | 1897-03-15 | 1899-03-03 | Democrat | 1 | |||||||||||||
13260 | 13260 | Robert Bodine B000584 | rep | MO | 1897-03-15 | 1899-03-03 | Democrat | 2 | |||||||||||||
13274 | 13274 | John Clardy C000415 | rep | KY | 1897-03-15 | 1899-03-03 | Democrat | 2 | |||||||||||||
13287 | 13287 | George Curtis C001010 | rep | IA | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
13357 | 13357 | Denis Hurley H001004 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
13450 | 13450 | Mason Peters P000254 | rep | KS | 1897-03-15 | 1899-03-03 | Populist | 2 | |||||||||||||
13464 | 13464 | Edward Sauerhering S000071 | rep | WI | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
13486 | 13486 | George Spalding S000696 | rep | MI | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
13563 | 13563 | William Baker B000076 | rep | MD | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
13611 | 13611 | Frank Clarke C000460 | rep | NH | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
13640 | 13640 | Marion De Vries D000277 | rep | CA | 1897-03-15 | 1899-03-03 | Democrat | 2 | |||||||||||||
13650 | 13650 | Nelson Dingley D000356 | rep | ME | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
13681 | 13681 | William Grout G000501 | rep | VT | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
13796 | 13796 | Jesse Stallings S000784 | rep | AL | 1897-03-15 | 1899-03-03 | Democrat | 2 | |||||||||||||
13830 | 13830 | George White W000372 | rep | NC | 1897-03-15 | 1899-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);