legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
380 rows where "end" is on date 1885-03-03 sorted by party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10072 | 10072 | James Farley F000020 | sen | CA | 1879-03-18 | 1885-03-03 | 3 | Democrat | |||||||||||||
10091 | 10091 | James Groome G000492 | sen | MD | 1879-03-18 | 1885-03-03 | 3 | Democrat | |||||||||||||
10121 | 10121 | Benjamin Jonas J000204 | sen | LA | 1879-03-18 | 1885-03-03 | 3 | Democrat | |||||||||||||
10166 | 10166 | George Pendleton P000203 | sen | OH | 1879-03-18 | 1885-03-03 | 3 | Democrat | |||||||||||||
10192 | 10192 | James Slater S000476 | sen | OR | 1879-03-18 | 1885-03-03 | 3 | Democrat | |||||||||||||
10212 | 10212 | James Walker W000057 | sen | AR | 1879-03-18 | 1885-03-03 | 3 | Democrat | |||||||||||||
10221 | 10221 | John Williams W000522 | sen | KY | 1879-03-18 | 1885-03-03 | 3 | Democrat | |||||||||||||
10623 | 10623 | Armstead Alexander A000090 | rep | MO | 1883-12-03 | 1885-03-03 | Democrat | 2 | |||||||||||||
10630 | 10630 | John Bagley B000033 | rep | NY | 1883-12-03 | 1885-03-03 | Democrat | 15 | |||||||||||||
10644 | 10644 | John Bratton B000772 | rep | SC | 1883-12-03 | 1885-03-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
10667 | 10667 | George Cassidy C000237 | rep | NV | 1883-12-03 | 1885-03-03 | Democrat | 0 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
10722 | 10722 | John Follett F000243 | rep | OH | 1883-12-03 | 1885-03-03 | Democrat | 1 | |||||||||||||
10726 | 10726 | George Garrison G000084 | rep | VA | 1883-12-03 | 1885-03-03 | Democrat | 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 | |||||||||||||
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 | |||||||||||||
10757 | 10757 | James Hopkins H000775 | rep | PA | 1883-12-03 | 1885-03-03 | Democrat | 22 | |||||||||||||
10761 | 10761 | Julius Houseman H000820 | rep | MI | 1883-12-03 | 1885-03-03 | Democrat | 5 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
10790 | 10790 | John Lamb L000034 | rep | IN | 1883-12-03 | 1885-03-03 | Democrat | 8 | |||||||||||||
10794 | 10794 | Edward Lewis L000280 | rep | LA | 1883-12-03 | 1885-03-03 | Democrat | 6 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
10832 | 10832 | John Patton P000139 | rep | PA | 1883-12-03 | 1885-03-03 | Democrat | 25 | |||||||||||||
10846 | 10846 | George Post P000453 | rep | PA | 1883-12-03 | 1885-03-03 | Democrat | 15 | |||||||||||||
10848 | 10848 | Morton Post P000456 | rep | WY | 1883-12-03 | 1885-03-03 | Democrat | 0 | |||||||||||||
10849 | 10849 | Orlando Potter P000466 | rep | NY | 1883-12-03 | 1885-03-03 | Democrat | 11 | |||||||||||||
10851 | 10851 | Luke Pryor P000557 | rep | AL | 1883-12-03 | 1885-03-03 | Democrat | 8 | |||||||||||||
10852 | 10852 | William Pusey P000579 | rep | IA | 1883-12-03 | 1885-03-03 | Democrat | 9 | |||||||||||||
10866 | 10866 | William Robinson R000355 | rep | NY | 1883-12-03 | 1885-03-03 | Democrat | 2 | |||||||||||||
10867 | 10867 | William Rogers R000407 | rep | NY | 1883-12-03 | 1885-03-03 | Democrat | 32 | |||||||||||||
10869 | 10869 | William Rosecrans R000440 | rep | CA | 1883-12-03 | 1885-03-03 | Democrat | 1 | |||||||||||||
10882 | 10882 | Alfred Scales S000103 | rep | NC | 1883-12-03 | 1885-03-03 | Democrat | 5 | |||||||||||||
10884 | 10884 | Aaron Shaw S000301 | rep | IL | 1883-12-03 | 1885-03-03 | Democrat | 16 | |||||||||||||
10888 | 10888 | Charles Shelley S000326 | rep | AL | 1883-12-03 | 1885-03-03 | Democrat | 4 | |||||||||||||
10894 | 10894 | Henry Slocum S000496 | rep | NY | 1883-12-03 | 1885-03-03 | Democrat | -1 | |||||||||||||
10902 | 10902 | Robert Stevens S000886 | rep | NY | 1883-12-03 | 1885-03-03 | Democrat | 31 | |||||||||||||
10904 | 10904 | Strother Stockslager S000938 | rep | IN | 1883-12-03 | 1885-03-03 | Democrat | 3 | |||||||||||||
10905 | 10905 | Charles Sumner S001069 | rep | CA | 1883-12-03 | 1885-03-03 | Democrat | -1 | |||||||||||||
10906 | 10906 | Daniel Sumner S001070 | rep | WI | 1883-12-03 | 1885-03-03 | Democrat | 2 | |||||||||||||
10910 | 10910 | Philip Thompson T000212 | rep | KY | 1883-12-03 | 1885-03-03 | Democrat | 8 | |||||||||||||
10911 | 10911 | Pleasant Tully T000407 | rep | CA | 1883-12-03 | 1885-03-03 | Democrat | 4 | |||||||||||||
10918 | 10918 | Thomas Van Alstyne V000013 | rep | NY | 1883-12-03 | 1885-03-03 | Democrat | 16 | |||||||||||||
10924 | 10924 | Robert Vance V000019 | rep | NC | 1883-12-03 | 1885-03-03 | Democrat | 8 | |||||||||||||
10925 | 10925 | Jonathan Wallace W000080 | rep | OH | 1883-12-03 | 1885-03-03 | Democrat | 18 | |||||||||||||
10927 | 10927 | Richard Warner W000156 | rep | TN | 1883-12-03 | 1885-03-03 | Democrat | 5 | |||||||||||||
10929 | 10929 | Edward Wemple W000292 | rep | NY | 1883-12-03 | 1885-03-03 | Democrat | 20 | |||||||||||||
10935 | 10935 | Thomas Williams W000537 | rep | AL | 1883-12-03 | 1885-03-03 | Democrat | 5 | |||||||||||||
10939 | 10939 | John Winans W000627 | rep | WI | 1883-12-03 | 1885-03-03 | Democrat | 1 | |||||||||||||
10941 | 10941 | Thomas Wood W000704 | rep | IN | 1883-12-03 | 1885-03-03 | Democrat | 10 | |||||||||||||
10942 | 10942 | Gilbert Woodward W000731 | rep | WI | 1883-12-03 | 1885-03-03 | Democrat | 7 | |||||||||||||
10943 | 10943 | George Yaple Y000005 | rep | MI | 1883-12-03 | 1885-03-03 | Democrat | 4 | |||||||||||||
10948 | 10948 | Hiram Young Y000037 | rep | TN | 1883-12-03 | 1885-03-03 | Democrat | 10 | |||||||||||||
10951 | 10951 | John Adams A000040 | rep | NY | 1883-12-03 | 1885-03-03 | Democrat | 8 | |||||||||||||
10956 | 10956 | David Aiken A000061 | rep | SC | 1883-12-03 | 1885-03-03 | Democrat | 3 | |||||||||||||
10959 | 10959 | John Arnot A000301 | rep | NY | 1883-12-03 | 1885-03-03 | Democrat | 29 | |||||||||||||
10961 | 10961 | John Ballentine B000105 | rep | TN | 1883-12-03 | 1885-03-03 | Democrat | 7 | |||||||||||||
10963 | 10963 | Ethelbert Barksdale B000146 | rep | MS | 1883-12-03 | 1885-03-03 | Democrat | 7 | |||||||||||||
10966 | 10966 | Lewis Beach B000263 | rep | NY | 1883-12-03 | 1885-03-03 | Democrat | 14 | |||||||||||||
10969 | 10969 | Risden Bennett B000381 | rep | NC | 1883-12-03 | 1885-03-03 | Democrat | -1 | |||||||||||||
10971 | 10971 | Charles Boyle B000728 | rep | PA | 1883-12-03 | 1885-03-03 | Democrat | 21 |
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);