legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
411 rows where "start" is on date 1899-12-04 sorted by end
This data as json, copyable, CSV (advanced)
Suggested facets: state, end, district, end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13708 | 13708 | Monroe Hayward H000409 | sen | NE | 1899-12-04 | 1899-12-31 | 1 | Republican | |||||||||||||
16966 | 16966 | John Smith S000577 | rep | MD | 1899-12-04 | 1900-01-12 | Democrat | 1 | |||||||||||||
15086 | 15086 | Jonathan Dolliver D000404 | rep | IA | 1899-12-04 | 1900-08-22 | Republican | 10 | |||||||||||||
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 | |||||||||||||
13815 | 13815 | John Underhill U000008 | rep | NY | 1899-12-04 | 1901-03-03 | Democrat | 16 | |||||||||||||
13816 | 13816 | Russell Waters W000188 | rep | CA | 1899-12-04 | 1901-03-03 | Republican | 6 | |||||||||||||
13818 | 13818 | Walter Weaver W000229 | rep | OH | 1899-12-04 | 1901-03-03 | Republican | 7 | |||||||||||||
13820 | 13820 | George Weymouth W000316 | rep | MA | 1899-12-04 | 1901-03-03 | Republican | 4 | |||||||||||||
13829 | 13829 | Joseph Wheeler W000338 | rep | AL | 1899-12-04 | 1901-03-03 | Democrat | 8 | |||||||||||||
13831 | 13831 | George White W000372 | rep | NC | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
13833 | 13833 | Edgar Wilson W000573 | rep | ID | 1899-12-04 | 1901-03-03 | Silver Republican | 1 | |||||||||||||
13836 | 13836 | Stanyarne Wilson W000612 | rep | SC | 1899-12-04 | 1901-03-03 | Democrat | 4 | |||||||||||||
13838 | 13838 | Richard Wise W000653 | rep | VA | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
13848 | 13848 | Samuel Barney B000163 | rep | WI | 1899-12-04 | 1901-03-03 | Republican | 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);