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 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14216 | 14216 | Robert Wilcox W000459 | rep | HI | 1899-12-04 | 1901-03-03 | -1 | ||||||||||||||
12933 | 12933 | Donelson Caffery C000016 | sen | LA | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
12938 | 12938 | Horace Chilton C000357 | sen | TX | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
13068 | 13068 | William Lindsay L000327 | sen | KY | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
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 | |||||||||||||
13555 | 13555 | John Allen A000134 | rep | MS | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
13561 | 13561 | Samuel Baird B000055 | rep | LA | 1899-12-04 | 1901-03-03 | Democrat | 5 | |||||||||||||
13565 | 13565 | Laird Barber B000123 | rep | PA | 1899-12-04 | 1901-03-03 | Democrat | 8 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
13613 | 13613 | Bertram Clayton C000492 | rep | NY | 1899-12-04 | 1901-03-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
13636 | 13636 | Stanley Davenport D000078 | rep | PA | 1899-12-04 | 1901-03-03 | Democrat | 12 | |||||||||||||
13641 | 13641 | Marion De Vries D000277 | rep | CA | 1899-12-04 | 1901-03-03 | Democrat | 2 | |||||||||||||
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 | |||||||||||||
13666 | 13666 | Thomas Fitzpatrick F000177 | rep | KY | 1899-12-04 | 1901-03-03 | Democrat | 10 | |||||||||||||
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 | |||||||||||||
13710 | 13710 | Patrick Henry H000512 | rep | MS | 1899-12-04 | 1901-03-03 | Democrat | 7 | |||||||||||||
13718 | 13718 | David Johnston J000186 | rep | WV | 1899-12-04 | 1901-03-03 | Democrat | 3 | |||||||||||||
13725 | 13725 | John Lentz L000244 | rep | OH | 1899-12-04 | 1901-03-03 | Democrat | 12 | |||||||||||||
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 | |||||||||||||
13745 | 13745 | David Meekison M000630 | rep | OH | 1899-12-04 | 1901-03-03 | Democrat | 5 | |||||||||||||
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 | |||||||||||||
13770 | 13770 | Julian Quarles Q000004 | rep | VA | 1899-12-04 | 1901-03-03 | Democrat | 10 | |||||||||||||
13787 | 13787 | Gaston Robbins R000299 | rep | AL | 1899-12-04 | 1901-03-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
13797 | 13797 | Jesse Stallings S000784 | rep | AL | 1899-12-04 | 1901-03-03 | Democrat | 2 | |||||||||||||
13812 | 13812 | William Terry T000137 | rep | AR | 1899-12-04 | 1901-03-03 | Democrat | 4 | |||||||||||||
13814 | 13814 | Oscar Turner T000426 | rep | KY | 1899-12-04 | 1901-03-03 | Democrat | 5 | |||||||||||||
13815 | 13815 | John Underhill U000008 | rep | NY | 1899-12-04 | 1901-03-03 | Democrat | 16 | |||||||||||||
13829 | 13829 | Joseph Wheeler W000338 | rep | AL | 1899-12-04 | 1901-03-03 | Democrat | 8 | |||||||||||||
13836 | 13836 | Stanyarne Wilson W000612 | rep | SC | 1899-12-04 | 1901-03-03 | Democrat | 4 | |||||||||||||
13840 | 13840 | William Young Y000056 | rep | VA | 1899-12-04 | 1901-03-03 | Democrat | 2 | |||||||||||||
13841 | 13841 | Edward Ziegler Z000006 | rep | PA | 1899-12-04 | 1901-03-03 | Democrat | 19 | |||||||||||||
13843 | 13843 | Henry Allen A000125 | rep | KY | 1899-12-04 | 1901-03-03 | Democrat | 2 | |||||||||||||
13855 | 13855 | John Bellamy B000349 | rep | NC | 1899-12-04 | 1901-03-03 | Democrat | 6 | |||||||||||||
13860 | 13860 | James Berry B000418 | sen | AR | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
13899 | 13899 | Robert Burke B001097 | rep | TX | 1899-12-04 | 1901-03-03 | Democrat | 6 | |||||||||||||
13903 | 13903 | Edward Carmack C000157 | rep | TN | 1899-12-04 | 1901-03-03 | Democrat | 10 | |||||||||||||
13905 | 13905 | William Clark C000454 | sen | MT | 1899-12-04 | 1901-03-03 | 1 | Democrat | |||||||||||||
13910 | 13910 | James Cooney C000744 | rep | MO | 1899-12-04 | 1901-03-03 | Democrat | 7 | |||||||||||||
13928 | 13928 | Amos Cummings C000983 | rep | NY | 1899-12-04 | 1901-03-03 | Democrat | 10 | |||||||||||||
13933 | 13933 | Reese De Graffenreid D000194 | rep | TX | 1899-12-04 | 1901-03-03 | Democrat | 3 | |||||||||||||
13950 | 13950 | William Elliott E000129 | rep | SC | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
13957 | 13957 | William Fleming F000198 | rep | GA | 1899-12-04 | 1901-03-03 | Democrat | 10 | |||||||||||||
13964 | 13964 | Andrew Fox F000330 | rep | MS | 1899-12-04 | 1901-03-03 | Democrat | 4 | |||||||||||||
13968 | 13968 | Robert Gordon G000314 | rep | OH | 1899-12-04 | 1901-03-03 | Democrat | 4 | |||||||||||||
13970 | 13970 | Henry Green G000411 | rep | PA | 1899-12-04 | 1901-03-03 | Democrat | 9 | |||||||||||||
13983 | 13983 | James Hall H000054 | rep | PA | 1899-12-04 | 1901-03-03 | Democrat | 28 | |||||||||||||
14024 | 14024 | Thomas Jett J000102 | rep | IL | 1899-12-04 | 1901-03-03 | Democrat | 18 | |||||||||||||
14035 | 14035 | Rudolph Kleberg K000258 | rep | TX | 1899-12-04 | 1901-03-03 | Democrat | 11 | |||||||||||||
14047 | 14047 | Samuel Lanham L000078 | rep | TX | 1899-12-04 | 1901-03-03 | Democrat | 8 | |||||||||||||
14060 | 14060 | Philip McCulloch M000391 | rep | AR | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
14072 | 14072 | Thomas McRae M000597 | rep | AR | 1899-12-04 | 1901-03-03 | Democrat | 3 | |||||||||||||
14095 | 14095 | John Morgan M000954 | sen | AL | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
14105 | 14105 | Nicholas Muller M001071 | rep | NY | 1899-12-04 | 1901-03-03 | Democrat | 7 | |||||||||||||
14109 | 14109 | Henry Naphen N000004 | rep | MA | 1899-12-04 | 1901-03-03 | Democrat | 10 | |||||||||||||
14114 | 14114 | James Norton N000150 | rep | OH | 1899-12-04 | 1901-03-03 | Democrat | 13 | |||||||||||||
14118 | 14118 | Peter Otey O000126 | rep | VA | 1899-12-04 | 1901-03-03 | Democrat | 6 | |||||||||||||
14123 | 14123 | Rufus Polk P000410 | rep | PA | 1899-12-04 | 1901-03-03 | Democrat | 17 | |||||||||||||
14140 | 14140 | William Rhea R000183 | rep | VA | 1899-12-04 | 1901-03-03 | Democrat | 9 | |||||||||||||
14142 | 14142 | John Robinson R000345 | rep | NE | 1899-12-04 | 1901-03-03 | Democrat | 3 | |||||||||||||
14153 | 14153 | Joshua Salmon S000017 | rep | NJ | 1899-12-04 | 1901-03-03 | Democrat | 4 | |||||||||||||
14165 | 14165 | John Sheppard S000336 | rep | TX | 1899-12-04 | 1901-03-03 | Democrat | 4 | |||||||||||||
14172 | 14172 | Charles Snodgrass S000654 | rep | TN | 1899-12-04 | 1901-03-03 | Democrat | 4 | |||||||||||||
14193 | 14193 | James Stokes S000947 | rep | SC | 1899-12-04 | 1901-03-03 | Democrat | 7 | |||||||||||||
14200 | 14200 | William Talbert T000016 | rep | SC | 1899-12-04 | 1901-03-03 | Democrat | 2 | |||||||||||||
14213 | 14213 | Charles Wheeler W000331 | rep | KY | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
14241 | 14241 | Thomas Ball B000101 | rep | TX | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
14248 | 14248 | Maecenas Benton B000397 | rep | MO | 1899-12-04 | 1901-03-03 | Democrat | 15 | |||||||||||||
14254 | 14254 | Phanor Breazeale B000781 | rep | LA | 1899-12-04 | 1901-03-03 | Democrat | 4 | |||||||||||||
14265 | 14265 | Charles Cochran C000562 | rep | MO | 1899-12-04 | 1901-03-03 | Democrat | 4 | |||||||||||||
14273 | 14273 | William Cowherd C000825 | rep | MO | 1899-12-04 | 1901-03-03 | Democrat | 5 | |||||||||||||
14278 | 14278 | Joseph Crowley C000943 | rep | IL | 1899-12-04 | 1901-03-03 | Democrat | 19 | |||||||||||||
14283 | 14283 | Robert Davis D000132 | rep | FL | 1899-12-04 | 1901-03-03 | Democrat | 2 | |||||||||||||
14289 | 14289 | James Denny D000250 | rep | MD | 1899-12-04 | 1901-03-03 | Democrat | 4 | |||||||||||||
14295 | 14295 | Hugh Dinsmore D000358 | rep | AR | 1899-12-04 | 1901-03-03 | Democrat | 5 | |||||||||||||
14298 | 14298 | John Dougherty D000447 | rep | MO | 1899-12-04 | 1901-03-03 | Democrat | 3 | |||||||||||||
14313 | 14313 | George Foster F000303 | rep | IL | 1899-12-04 | 1901-03-03 | Democrat | 3 | |||||||||||||
14338 | 14338 | Francis Griffith G000468 | rep | IN | 1899-12-04 | 1901-03-03 | Democrat | 4 | |||||||||||||
14367 | 14367 | Theodore Kluttz K000275 | rep | NC | 1899-12-04 | 1901-03-03 | Democrat | 7 | |||||||||||||
14376 | 14376 | Asbury Latimer L000114 | rep | SC | 1899-12-04 | 1901-03-03 | Democrat | 3 |
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);