legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
381 rows where "start" is on date 1883-12-03 sorted by how
This data as json, copyable, CSV (advanced)
Suggested facets: state, end, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10623 | 10623 | Armstead Alexander A000090 | rep | MO | 1883-12-03 | 1885-03-03 | Democrat | 2 | |||||||||||||
10628 | 10628 | Henry Anthony A000262 | sen | RI | 1883-12-03 | 1885-03-03 | 2 | Republican | |||||||||||||
10630 | 10630 | John Bagley B000033 | rep | NY | 1883-12-03 | 1885-03-03 | Democrat | 15 | |||||||||||||
10632 | 10632 | Samuel Barr B000171 | rep | PA | 1883-12-03 | 1885-03-03 | Republican | 14 | |||||||||||||
10637 | 10637 | James Belford B000326 | rep | CO | 1883-12-03 | 1885-03-03 | Republican | 1 | |||||||||||||
10641 | 10641 | Horatio Bisbee B000485 | rep | FL | 1883-12-03 | 1885-03-03 | Republican | 2 | |||||||||||||
10642 | 10642 | Thomas Bowen B000686 | sen | CO | 1883-12-03 | 1889-03-03 | 2 | Republican | |||||||||||||
10643 | 10643 | Samuel Brainerd B000761 | rep | PA | 1883-12-03 | 1885-03-03 | Republican | 27 | |||||||||||||
10644 | 10644 | John Bratton B000772 | rep | SC | 1883-12-03 | 1885-03-03 | Democrat | 4 | |||||||||||||
10645 | 10645 | Edward Breitung B000795 | rep | MI | 1883-12-03 | 1885-03-03 | Republican | 11 | |||||||||||||
10648 | 10648 | Thomas Brents B000806 | rep | WA | 1883-12-03 | 1885-03-03 | Republican | -1 | |||||||||||||
10649 | 10649 | Francis Brewer B000809 | rep | NY | 1883-12-03 | 1885-03-03 | Republican | 33 | |||||||||||||
10651 | 10651 | John Brewer B000810 | rep | NJ | 1883-12-03 | 1885-03-03 | Republican | 2 | |||||||||||||
10652 | 10652 | James Broadhead B000848 | rep | MO | 1883-12-03 | 1885-03-03 | Democrat | 9 | |||||||||||||
10654 | 10654 | Hugh Buchanan B001003 | rep | GA | 1883-12-03 | 1885-03-03 | Democrat | 4 | |||||||||||||
10660 | 10660 | Aylett Buckner B001031 | rep | MO | 1883-12-03 | 1885-03-03 | Democrat | 7 | |||||||||||||
10661 | 10661 | James Budd B001034 | rep | CA | 1883-12-03 | 1885-03-03 | Democrat | 2 | |||||||||||||
10665 | 10665 | William Calkins C000048 | rep | IN | 1883-12-03 | 1885-03-03 | Republican | 13 | |||||||||||||
10667 | 10667 | George Cassidy C000237 | rep | NV | 1883-12-03 | 1885-03-03 | Democrat | 0 | |||||||||||||
10671 | 10671 | James Chalmers C000272 | rep | MS | 1883-12-03 | 1885-03-03 | Independent | 2 | |||||||||||||
10672 | 10672 | James Clay C000484 | rep | KY | 1883-12-03 | 1885-03-03 | Democrat | 2 | |||||||||||||
10673 | 10673 | Daniel Connolly C000696 | rep | PA | 1883-12-03 | 1885-03-03 | Democrat | 12 | |||||||||||||
10676 | 10676 | George Converse C000711 | rep | OH | 1883-12-03 | 1885-03-03 | Democrat | 13 | |||||||||||||
10678 | 10678 | John Cook C000719 | rep | IA | 1883-12-03 | 1885-03-03 | Democrat | 6 | |||||||||||||
10679 | 10679 | John Cosgrove C000793 | rep | MO | 1883-12-03 | 1885-03-03 | Democrat | 6 | |||||||||||||
10681 | 10681 | George Covington C000815 | rep | MD | 1883-12-03 | 1885-03-03 | Democrat | 1 | |||||||||||||
10682 | 10682 | George Craig C000855 | rep | AL | 1883-12-03 | 1885-03-03 | Republican | 4 | |||||||||||||
10683 | 10683 | William Culbertson C000966 | rep | KY | 1883-12-03 | 1885-03-03 | Republican | 9 | |||||||||||||
10685 | 10685 | William Cullen C000971 | rep | IL | 1883-12-03 | 1885-03-03 | Republican | 8 | |||||||||||||
10687 | 10687 | Marsena Cutts C001032 | rep | IA | 1883-12-03 | 1885-03-03 | Republican | 6 | |||||||||||||
10690 | 10690 | George Davis D000100 | rep | IL | 1883-12-03 | 1885-03-03 | Republican | 3 | |||||||||||||
10693 | 10693 | Lowndes Davis D000124 | rep | MO | 1883-12-03 | 1885-03-03 | Democrat | 14 | |||||||||||||
10696 | 10696 | Peter Deuster D000274 | rep | WI | 1883-12-03 | 1885-03-03 | Democrat | 4 | |||||||||||||
10701 | 10701 | George Dibrell D000301 | rep | TN | 1883-12-03 | 1885-03-03 | Democrat | 3 | |||||||||||||
10702 | 10702 | William Dorsheimer D000442 | rep | NY | 1883-12-03 | 1885-03-03 | Democrat | 7 | |||||||||||||
10704 | 10704 | Clement Dowd D000463 | rep | NC | 1883-12-03 | 1885-03-03 | Democrat | 6 | |||||||||||||
10705 | 10705 | William Duncan D000538 | rep | PA | 1883-12-03 | 1885-03-03 | Democrat | 19 | |||||||||||||
10707 | 10707 | William Eaton E000028 | rep | CT | 1883-12-03 | 1885-03-03 | Democrat | 1 | |||||||||||||
10708 | 10708 | Mortimer Elliott E000126 | rep | PA | 1883-12-03 | 1885-03-03 | Democrat | -1 | |||||||||||||
10713 | 10713 | Ezekiel Ellis E000134 | rep | LA | 1883-12-03 | 1885-03-03 | Democrat | 2 | |||||||||||||
10714 | 10714 | William English E000190 | rep | IN | 1883-12-03 | 1885-03-03 | Democrat | 7 | |||||||||||||
10718 | 10718 | John Evins E000272 | rep | SC | 1883-12-03 | 1885-03-03 | Democrat | 4 | |||||||||||||
10719 | 10719 | Thomas Ferrell F000089 | rep | NJ | 1883-12-03 | 1885-03-03 | Democrat | 1 | |||||||||||||
10720 | 10720 | William Fiedler F000103 | rep | NJ | 1883-12-03 | 1885-03-03 | Democrat | 6 | |||||||||||||
10721 | 10721 | John Finerty F000127 | rep | IL | 1883-12-03 | 1885-03-03 | Ind. Democrat | 2 | |||||||||||||
10722 | 10722 | John Follett F000243 | rep | OH | 1883-12-03 | 1885-03-03 | Democrat | 1 | |||||||||||||
10724 | 10724 | Augustus Garland G000065 | sen | AR | 1883-12-03 | 1885-12-31 | 2 | Democrat | |||||||||||||
10726 | 10726 | George Garrison G000084 | rep | VA | 1883-12-03 | 1885-03-03 | Democrat | 1 | |||||||||||||
10728 | 10728 | Melvin George G000128 | rep | OR | 1883-12-03 | 1885-03-03 | Republican | 1 | |||||||||||||
10729 | 10729 | John Glascock G000229 | rep | CA | 1883-12-03 | 1885-03-03 | Democrat | -1 | |||||||||||||
10730 | 10730 | Alexander Graves G000390 | rep | MO | 1883-12-03 | 1885-03-03 | Democrat | 5 | |||||||||||||
10734 | 10734 | John Hancock H000150 | rep | TX | 1883-12-03 | 1885-03-03 | Democrat | 10 | |||||||||||||
10736 | 10736 | Thomas Hardeman H000181 | rep | GA | 1883-12-03 | 1885-03-03 | Democrat | 0 | |||||||||||||
10738 | 10738 | John Hardy H000196 | rep | NY | 1883-12-03 | 1885-03-03 | Democrat | 9 | |||||||||||||
10739 | 10739 | Alphonso Hart H000282 | rep | OH | 1883-12-03 | 1885-03-03 | Republican | 12 | |||||||||||||
10743 | 10743 | Dudley Haskell H000316 | rep | KS | 1883-12-03 | 1885-03-03 | Republican | 2 | |||||||||||||
10744 | 10744 | Herschel Hatch H000335 | rep | MI | 1883-12-03 | 1885-03-03 | Republican | 10 | |||||||||||||
10747 | 10747 | Thomas Herndon H000534 | rep | AL | 1883-12-03 | 1885-03-03 | Democrat | 1 | |||||||||||||
10751 | 10751 | Goldsmith Hewitt H000553 | rep | AL | 1883-12-03 | 1885-03-03 | Democrat | 6 | |||||||||||||
10753 | 10753 | Fetter Hoblitzell H000664 | rep | MD | 1883-12-03 | 1885-03-03 | Democrat | 3 | |||||||||||||
10754 | 10754 | Hart Holton H000751 | rep | MD | 1883-12-03 | 1885-03-03 | Republican | 5 | |||||||||||||
10755 | 10755 | Benjamin Hooper H000763 | rep | VA | 1883-12-03 | 1885-03-03 | Readjuster | 4 | |||||||||||||
10757 | 10757 | James Hopkins H000775 | rep | PA | 1883-12-03 | 1885-03-03 | Democrat | 22 | |||||||||||||
10760 | 10760 | Roswell Horr H000794 | rep | MI | 1883-12-03 | 1885-03-03 | Republican | 8 | |||||||||||||
10761 | 10761 | Julius Houseman H000820 | rep | MI | 1883-12-03 | 1885-03-03 | Democrat | 5 | |||||||||||||
10762 | 10762 | Benjamin Howey H000869 | rep | NJ | 1883-12-03 | 1885-03-03 | Republican | 4 | |||||||||||||
10763 | 10763 | Carleton Hunt H000969 | rep | LA | 1883-12-03 | 1885-03-03 | Democrat | 1 | |||||||||||||
10766 | 10766 | Frank Hurd H001002 | rep | OH | 1883-12-03 | 1885-03-03 | Democrat | 10 | |||||||||||||
10769 | 10769 | Waldo Hutchins H001009 | rep | NY | 1883-12-03 | 1885-03-03 | Democrat | 12 | |||||||||||||
10770 | 10770 | Elza Jeffords J000071 | rep | MS | 1883-12-03 | 1885-03-03 | Republican | 3 | |||||||||||||
10771 | 10771 | Burr Jones J000213 | rep | WI | 1883-12-03 | 1885-03-03 | Democrat | 3 | |||||||||||||
10772 | 10772 | Isaac Jordan J000268 | rep | OH | 1883-12-03 | 1885-03-03 | Democrat | 2 | |||||||||||||
10778 | 10778 | John Kasson K000018 | rep | IA | 1883-12-03 | 1885-03-03 | Republican | 7 | |||||||||||||
10781 | 10781 | William Kellogg K000069 | rep | LA | 1883-12-03 | 1885-03-03 | Republican | 3 | |||||||||||||
10783 | 10783 | Edward Lacey L000009 | rep | MI | 1883-12-03 | 1885-03-03 | Republican | 3 | |||||||||||||
10789 | 10789 | Lucius Lamar L000030 | sen | MS | 1883-12-03 | 1885-12-31 | 2 | Democrat | |||||||||||||
10790 | 10790 | John Lamb L000034 | rep | IN | 1883-12-03 | 1885-03-03 | Democrat | 8 | |||||||||||||
10793 | 10793 | George Lawrence L000134 | rep | PA | 1883-12-03 | 1885-03-03 | Republican | 24 | |||||||||||||
10794 | 10794 | Edward Lewis L000280 | rep | LA | 1883-12-03 | 1885-03-03 | Democrat | 6 | |||||||||||||
10796 | 10796 | Tranquilino Luna L000513 | rep | NM | 1883-12-03 | 1885-03-03 | Republican | -1 | |||||||||||||
10797 | 10797 | Theodore Lyman L000529 | rep | MA | 1883-12-03 | 1885-03-03 | Ind. Republican | 9 | |||||||||||||
10800 | 10800 | Edmund Mackey M000024 | rep | SC | 1883-12-03 | 1885-03-03 | Republican | 7 | |||||||||||||
10806 | 10806 | Martin Maginnis M000050 | rep | MT | 1883-12-03 | 1885-03-03 | Democrat | -1 | |||||||||||||
10810 | 10810 | Vannoy Manning M000111 | rep | MS | 1883-12-03 | 1885-03-03 | Democrat | -1 | |||||||||||||
10811 | 10811 | Francisco Manzanares M000118 | rep | NM | 1883-12-03 | 1885-03-03 | Democrat | -1 | |||||||||||||
10812 | 10812 | Robert Mayo M000287 | rep | VA | 1883-12-03 | 1885-03-03 | Readjuster | 1 | |||||||||||||
10815 | 10815 | Moses McCoid M000348 | rep | IA | 1883-12-03 | 1885-03-03 | Republican | 1 | |||||||||||||
10816 | 10816 | John McCormick M000368 | rep | OH | 1883-12-03 | 1885-03-03 | Republican | 11 | |||||||||||||
10819 | 10819 | Samuel Moulton M001047 | rep | IL | 1883-12-03 | 1885-03-03 | Democrat | 17 | |||||||||||||
10823 | 10823 | Henry Muldrow M001068 | rep | MS | 1883-12-03 | 1885-03-03 | Democrat | 1 | |||||||||||||
10824 | 10824 | Robert Murray M001113 | rep | OH | 1883-12-03 | 1885-03-03 | Democrat | 3 | |||||||||||||
10826 | 10826 | John Nicholls N000087 | rep | GA | 1883-12-03 | 1885-03-03 | Democrat | 1 | |||||||||||||
10827 | 10827 | Thomas Ochiltree O000021 | rep | TX | 1883-12-03 | 1885-03-03 | Independent | 7 | |||||||||||||
10829 | 10829 | Granville Oury O000135 | rep | AZ | 1883-12-03 | 1885-03-03 | Democrat | 0 | |||||||||||||
10830 | 10830 | David Paige P000025 | rep | OH | 1883-12-03 | 1885-03-03 | Democrat | 20 | |||||||||||||
10831 | 10831 | Thomas Palmer P000044 | sen | MI | 1883-12-03 | 1889-03-03 | 2 | Republican | |||||||||||||
10832 | 10832 | John Patton P000139 | rep | PA | 1883-12-03 | 1885-03-03 | Democrat | 25 | |||||||||||||
10834 | 10834 | John Paul P000144 | rep | VA | 1883-12-03 | 1885-03-03 | Readjuster | 7 | |||||||||||||
10836 | 10836 | Stanton Peelle P000185 | rep | IN | 1883-12-03 | 1885-03-03 | Republican | 7 | |||||||||||||
10838 | 10838 | Austin Pike P000345 | sen | NH | 1883-12-03 | 1887-03-03 | 2 | Republican |
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);