legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
415 rows where "end" is on date 1901-03-03
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12908 | 12908 | Lucien Baker B000070 | sen | KS | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
12931 | 12931 | Marion Butler B001183 | sen | NC | 1895-12-02 | 1901-03-03 | 2 | Populist | |||||||||||||
12933 | 12933 | Donelson Caffery C000016 | sen | LA | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
12936 | 12936 | William Chandler C000298 | sen | NH | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
12938 | 12938 | Horace Chilton C000357 | sen | TX | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
13009 | 13009 | John Gear G000110 | sen | IA | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
13068 | 13068 | William Lindsay L000327 | sen | KY | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
13073 | 13073 | George McBride M000300 | sen | OR | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
13119 | 13119 | Richard Pettigrew P000271 | sen | SD | 1895-12-02 | 1901-03-03 | 2 | Silver Republican | |||||||||||||
13158 | 13158 | William Sewell S000262 | sen | NJ | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
13161 | 13161 | George Shoup S000382 | sen | ID | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
13179 | 13179 | John Thurston T000256 | sen | NE | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
13218 | 13218 | Edward Wolcott W000667 | sen | CO | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
13374 | 13374 | Richard Kenney K000121 | sen | DE | 1897-03-15 | 1901-03-03 | 2 | Democrat | |||||||||||||
13507 | 13507 | Thomas Turley T000412 | sen | TN | 1897-03-15 | 1901-03-03 | 2 | Democrat | |||||||||||||
13544 | 13544 | William Sullivan S001062 | sen | MS | 1898-05-31 | 1901-03-03 | 2 | Democrat | |||||||||||||
13547 | 13547 | William Aldrich A000087 | rep | AL | 1899-12-04 | 1901-03-03 | Republican | 4 | |||||||||||||
13555 | 13555 | John Allen A000134 | rep | MS | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
13558 | 13558 | John Atwater A000334 | rep | NC | 1899-12-04 | 1901-03-03 | Populist | 4 | |||||||||||||
13559 | 13559 | Willis Bailey B000051 | rep | KS | 1899-12-04 | 1901-03-03 | Republican | -1 | |||||||||||||
13561 | 13561 | Samuel Baird B000055 | rep | LA | 1899-12-04 | 1901-03-03 | Democrat | 5 | |||||||||||||
13564 | 13564 | William Baker B000076 | rep | MD | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
13565 | 13565 | Laird Barber B000123 | rep | PA | 1899-12-04 | 1901-03-03 | Democrat | 8 | |||||||||||||
13568 | 13568 | John Barham B000140 | rep | CA | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
13575 | 13575 | Albert Berry B000414 | rep | KY | 1899-12-04 | 1901-03-03 | Democrat | 6 | |||||||||||||
13588 | 13588 | Richard Bland B000544 | rep | MO | 1899-12-04 | 1901-03-03 | Democrat | 8 | |||||||||||||
13590 | 13590 | Thomas Bradley B000746 | rep | NY | 1899-12-04 | 1901-03-03 | Democrat | 9 | |||||||||||||
13592 | 13592 | John Brenner B000801 | rep | OH | 1899-12-04 | 1901-03-03 | Democrat | 3 | |||||||||||||
13594 | 13594 | Willis Brewer B000812 | rep | AL | 1899-12-04 | 1901-03-03 | Democrat | 5 | |||||||||||||
13596 | 13596 | Seth Brown B000943 | rep | OH | 1899-12-04 | 1901-03-03 | Republican | 6 | |||||||||||||
13597 | 13597 | Albert Campbell C000074 | rep | MT | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
13605 | 13605 | Thomas Catchings C000247 | rep | MS | 1899-12-04 | 1901-03-03 | Democrat | 3 | |||||||||||||
13606 | 13606 | William Chanler C000303 | rep | NY | 1899-12-04 | 1901-03-03 | Democrat | 14 | |||||||||||||
13610 | 13610 | Charles Chickering C000351 | rep | NY | 1899-12-04 | 1901-03-03 | Republican | 24 | |||||||||||||
13612 | 13612 | Frank Clarke C000460 | rep | NH | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
13613 | 13613 | Bertram Clayton C000492 | rep | NY | 1899-12-04 | 1901-03-03 | Democrat | 4 | |||||||||||||
13615 | 13615 | Aaron Cochrane C000568 | rep | NY | 1899-12-04 | 1901-03-03 | Republican | 19 | |||||||||||||
13625 | 13625 | Nicholas Cox C000838 | rep | TN | 1899-12-04 | 1901-03-03 | Democrat | 7 | |||||||||||||
13626 | 13626 | Thomas Cusack C001015 | rep | IL | 1899-12-04 | 1901-03-03 | Democrat | 4 | |||||||||||||
13627 | 13627 | William Daly D000015 | rep | NJ | 1899-12-04 | 1901-03-03 | Democrat | 7 | |||||||||||||
13633 | 13633 | Lorenzo Danford D000028 | rep | OH | 1899-12-04 | 1901-03-03 | Republican | 16 | |||||||||||||
13635 | 13635 | Samuel Davenport D000077 | rep | PA | 1899-12-04 | 1901-03-03 | Republican | -1 | |||||||||||||
13636 | 13636 | Stanley Davenport D000078 | rep | PA | 1899-12-04 | 1901-03-03 | Democrat | 12 | |||||||||||||
13639 | 13639 | Cushman Davis D000095 | sen | MN | 1899-12-04 | 1901-03-03 | 1 | Republican | |||||||||||||
13641 | 13641 | Marion De Vries D000277 | rep | CA | 1899-12-04 | 1901-03-03 | Democrat | 2 | |||||||||||||
13651 | 13651 | Nelson Dingley D000356 | rep | ME | 1899-12-04 | 1901-03-03 | Republican | -1 | |||||||||||||
13653 | 13653 | Edmund Driggs D000497 | rep | NY | 1899-12-04 | 1901-03-03 | Democrat | 3 | |||||||||||||
13655 | 13655 | Sydney Epes E000196 | rep | VA | 1899-12-04 | 1901-03-03 | Democrat | 4 | |||||||||||||
13661 | 13661 | Daniel Ermentrout E000205 | rep | PA | 1899-12-04 | 1901-03-03 | Democrat | 9 | |||||||||||||
13664 | 13664 | George Faris F000016 | rep | IN | 1899-12-04 | 1901-03-03 | Republican | 5 | |||||||||||||
13666 | 13666 | Thomas Fitzpatrick F000177 | rep | KY | 1899-12-04 | 1901-03-03 | Democrat | 10 | |||||||||||||
13668 | 13668 | Romeo Freer F000367 | rep | WV | 1899-12-04 | 1901-03-03 | Republican | 4 | |||||||||||||
13669 | 13669 | Athelston Gaston G000095 | rep | PA | 1899-12-04 | 1901-03-03 | Democrat | 26 | |||||||||||||
13670 | 13670 | June Gayle G000107 | rep | KY | 1899-12-04 | 1901-03-03 | Democrat | 7 | |||||||||||||
13671 | 13671 | Martin Glynn G000247 | rep | NY | 1899-12-04 | 1901-03-03 | Democrat | 20 | |||||||||||||
13673 | 13673 | William Greene G000429 | rep | NE | 1899-12-04 | 1901-03-03 | Populist | 6 | |||||||||||||
13682 | 13682 | William Grout G000501 | rep | VT | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
13698 | 13698 | Alfred Harmer H000215 | rep | PA | 1899-12-04 | 1901-03-03 | Republican | 5 | |||||||||||||
13707 | 13707 | Robert Hawley H000378 | rep | TX | 1899-12-04 | 1901-03-03 | Republican | 10 | |||||||||||||
13710 | 13710 | Patrick Henry H000512 | rep | MS | 1899-12-04 | 1901-03-03 | Democrat | 7 | |||||||||||||
13711 | 13711 | John Hoffecker H000680 | rep | DE | 1899-12-04 | 1901-03-03 | Republican | 0 | |||||||||||||
13712 | 13712 | Walter Hoffecker H000681 | rep | DE | 1899-12-04 | 1901-03-03 | Republican | 0 | |||||||||||||
13717 | 13717 | Warren Hooker H000760 | rep | NY | 1899-12-04 | 1901-03-03 | Republican | -1 | |||||||||||||
13718 | 13718 | David Johnston J000186 | rep | WV | 1899-12-04 | 1901-03-03 | Democrat | 3 | |||||||||||||
13719 | 13719 | Josiah Kerr K000142 | rep | MD | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
13722 | 13722 | Winfield Kerr K000145 | rep | OH | 1899-12-04 | 1901-03-03 | Republican | 14 | |||||||||||||
13723 | 13723 | Joseph Lane L000063 | rep | IA | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
13725 | 13725 | John Lentz L000244 | rep | OH | 1899-12-04 | 1901-03-03 | Democrat | 12 | |||||||||||||
13728 | 13728 | Romulus Linney L000339 | rep | NC | 1899-12-04 | 1901-03-03 | Republican | 8 | |||||||||||||
13730 | 13730 | Archibald Lybrand L000523 | rep | OH | 1899-12-04 | 1901-03-03 | Republican | 8 | |||||||||||||
13731 | 13731 | Mitchell May M000276 | rep | NY | 1899-12-04 | 1901-03-03 | Democrat | 6 | |||||||||||||
13735 | 13735 | William McAleer M000294 | rep | PA | 1899-12-04 | 1901-03-03 | Democrat | 3 | |||||||||||||
13742 | 13742 | John McDowell M000421 | rep | OH | 1899-12-04 | 1901-03-03 | Democrat | 17 | |||||||||||||
13743 | 13743 | Smith McPherson M000594 | rep | IA | 1899-12-04 | 1901-03-03 | Republican | 9 | |||||||||||||
13745 | 13745 | David Meekison M000630 | rep | OH | 1899-12-04 | 1901-03-03 | Democrat | 5 | |||||||||||||
13747 | 13747 | William Mesick M000666 | rep | MI | 1899-12-04 | 1901-03-03 | Republican | 11 | |||||||||||||
13748 | 13748 | Edward Noonan N000130 | rep | IL | 1899-12-04 | 1901-03-03 | Democrat | 5 | |||||||||||||
13750 | 13750 | James Norton N000149 | rep | SC | 1899-12-04 | 1901-03-03 | Democrat | 6 | |||||||||||||
13751 | 13751 | James O’Grady O000051 | rep | NY | 1899-12-04 | 1901-03-03 | Republican | 31 | |||||||||||||
13753 | 13753 | Horace Packer P000007 | rep | PA | 1899-12-04 | 1901-03-03 | Republican | 16 | |||||||||||||
13755 | 13755 | Charles Pearce P000582 | rep | MO | 1899-12-04 | 1901-03-03 | Republican | 12 | |||||||||||||
13758 | 13758 | Richmond Pearson P000169 | rep | NC | 1899-12-04 | 1901-03-03 | Republican | 9 | |||||||||||||
13759 | 13759 | Pedro Perea P000225 | rep | NM | 1899-12-04 | 1901-03-03 | Republican | -1 | |||||||||||||
13760 | 13760 | Fremont Phillips P000307 | rep | OH | 1899-12-04 | 1901-03-03 | Republican | 20 | |||||||||||||
13765 | 13765 | Horace Powers P000490 | rep | VT | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
13768 | 13768 | Samuel Pugh P000564 | rep | KY | 1899-12-04 | 1901-03-03 | Republican | 9 | |||||||||||||
13770 | 13770 | Julian Quarles Q000004 | rep | VA | 1899-12-04 | 1901-03-03 | Democrat | 10 | |||||||||||||
13782 | 13782 | Thomas Reed R000128 | rep | ME | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
13784 | 13784 | Edwin Ridgely R000244 | rep | KS | 1899-12-04 | 1901-03-03 | Populist | 3 | |||||||||||||
13787 | 13787 | Gaston Robbins R000299 | rep | AL | 1899-12-04 | 1901-03-03 | Democrat | 4 | |||||||||||||
13788 | 13788 | Jonathan Ross R000450 | sen | VT | 1899-12-04 | 1901-03-03 | 3 | Republican | |||||||||||||
13789 | 13789 | James Ryan R000557 | rep | PA | 1899-12-04 | 1901-03-03 | Democrat | 13 | |||||||||||||
13791 | 13791 | Evan Settle S000252 | rep | KY | 1899-12-04 | 1901-03-03 | Democrat | 7 | |||||||||||||
13793 | 13793 | Charles Sprague S000742 | rep | MA | 1899-12-04 | 1901-03-03 | Republican | 11 | |||||||||||||
13797 | 13797 | Jesse Stallings S000784 | rep | AL | 1899-12-04 | 1901-03-03 | Democrat | 2 | |||||||||||||
13800 | 13800 | Alexander Stewart S000898 | rep | WI | 1899-12-04 | 1901-03-03 | Republican | 9 | |||||||||||||
13807 | 13807 | Roderick Sutherland S001085 | rep | NE | 1899-12-04 | 1901-03-03 | Populist | 5 | |||||||||||||
13812 | 13812 | William Terry T000137 | rep | AR | 1899-12-04 | 1901-03-03 | Democrat | 4 | |||||||||||||
13813 | 13813 | Joseph Thropp T000248 | rep | PA | 1899-12-04 | 1901-03-03 | Republican | 20 | |||||||||||||
13814 | 13814 | Oscar Turner T000426 | rep | KY | 1899-12-04 | 1901-03-03 | Democrat | 5 |
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);