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
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
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 | |||||||||||||
10844 | 10844 | Luke Poland P000406 | rep | VT | 1883-12-03 | 1885-03-03 | Republican | 2 | |||||||||||||
10845 | 10845 | Walter Pool P000428 | rep | NC | 1883-12-03 | 1885-03-03 | Republican | 1 | |||||||||||||
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 | |||||||||||||
10855 | 10855 | Ossian Ray R000079 | rep | NH | 1883-12-03 | 1885-03-03 | Republican | 2 | |||||||||||||
10856 | 10856 | John Raymond R000085 | rep | DK | 1883-12-03 | 1885-03-03 | Republican | -1 | |||||||||||||
10861 | 10861 | George Robinson R000335 | rep | MA | 1883-12-03 | 1885-03-03 | Republican | 12 | |||||||||||||
10863 | 10863 | James Robinson R000339 | rep | OH | 1883-12-03 | 1885-03-03 | Republican | 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 | |||||||||||||
10872 | 10872 | William Russell R000541 | rep | MA | 1883-12-03 | 1885-03-03 | Republican | 8 | |||||||||||||
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 | |||||||||||||
10889 | 10889 | Theodore Singiser S000443 | rep | ID | 1883-12-03 | 1885-03-03 | Republican | -1 | |||||||||||||
10891 | 10891 | Charles Skinner S000467 | rep | NY | 1883-12-03 | 1885-03-03 | Republican | 22 | |||||||||||||
10894 | 10894 | Henry Slocum S000496 | rep | NY | 1883-12-03 | 1885-03-03 | Democrat | -1 | |||||||||||||
10900 | 10900 | Abraham Smith S000509 | rep | PA | 1883-12-03 | 1885-03-03 | Republican | 9 | |||||||||||||
10901 | 10901 | Hiram Smith S000550 | rep | IA | 1883-12-03 | 1885-03-03 | Republican | 7 | |||||||||||||
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 | |||||||||||||
10914 | 10914 | Oscar Turner T000425 | rep | KY | 1883-12-03 | 1885-03-03 | Ind. Democrat | 1 | |||||||||||||
10917 | 10917 | Edward Valentine V000005 | rep | NE | 1883-12-03 | 1885-03-03 | Republican | 3 | |||||||||||||
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 | |||||||||||||
10928 | 10928 | Luman Weller W000275 | rep | IA | 1883-12-03 | 1885-03-03 | National Greenbacker | 4 | |||||||||||||
10929 | 10929 | Edward Wemple W000292 | rep | NY | 1883-12-03 | 1885-03-03 | Democrat | 20 | |||||||||||||
10932 | 10932 | John White W000381 | rep | KY | 1883-12-03 | 1885-03-03 | Republican | 10 | |||||||||||||
10935 | 10935 | Thomas Williams W000537 | rep | AL | 1883-12-03 | 1885-03-03 | Democrat | 5 | |||||||||||||
10938 | 10938 | James Wilson W000590 | rep | IA | 1883-12-03 | 1885-03-03 | Republican | 5 | |||||||||||||
10939 | 10939 | John Winans W000627 | rep | WI | 1883-12-03 | 1885-03-03 | Democrat | 1 | |||||||||||||
10940 | 10940 | John Wise W000651 | rep | VA | 1883-12-03 | 1885-03-03 | Readjuster | -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 | |||||||||||||
10944 | 10944 | Tyre York Y000022 | rep | NC | 1883-12-03 | 1885-03-03 | Ind. Democrat | 7 | |||||||||||||
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 | |||||||||||||
10978 | 10978 | Joseph Brown B000936 | sen | GA | 1880-01-01 | 1885-03-03 | 3 | Democrat | |||||||||||||
10980 | 10980 | William Brown B000952 | rep | PA | 1883-12-03 | 1885-03-03 | Republican | 16 | |||||||||||||
10984 | 10984 | Henry Burleigh B001106 | rep | NY | 1883-12-03 | 1885-03-03 | Republican | 17 | |||||||||||||
10990 | 10990 | George Cabell C000004 | rep | VA | 1883-12-03 | 1885-03-03 | Democrat | 5 | |||||||||||||
10992 | 10992 | Andrew Caldwell C000028 | rep | TN | 1883-12-03 | 1885-03-03 | Democrat | 6 | |||||||||||||
10996 | 10996 | Jacob Campbell C000086 | rep | PA | 1883-12-03 | 1885-03-03 | Republican | 17 | |||||||||||||
10998 | 10998 | Ezra Carleton C000147 | rep | MI | 1883-12-03 | 1885-03-03 | Democrat | 7 | |||||||||||||
11001 | 11001 | Jonathan Chace C000267 | rep | RI | 1883-12-03 | 1885-03-03 | Republican | 2 | |||||||||||||
11006 | 11006 | Thomas Cobb C000552 | rep | IN | 1883-12-03 | 1885-03-03 | Democrat | 2 | |||||||||||||
11011 | 11011 | William Cox C000841 | rep | NC | 1883-12-03 | 1885-03-03 | Democrat | 4 | |||||||||||||
11015 | 11015 | Andrew Curtin C001004 | rep | PA | 1883-12-03 | 1885-03-03 | Democrat | 20 | |||||||||||||
11024 | 11024 | Nathaniel Eldredge E000104 | rep | MI | 1883-12-03 | 1885-03-03 | Democrat | 2 | |||||||||||||
11027 | 11027 | Reuben Ellwood E000151 | rep | IL | 1883-12-03 | 1885-03-03 | Republican | 5 | |||||||||||||
11033 | 11033 | Isaac Evans E000244 | rep | PA | 1883-12-03 | 1885-03-03 | Republican | 7 | |||||||||||||
11036 | 11036 | James Everhart E000270 | rep | PA | 1883-12-03 | 1885-03-03 | Republican | 6 | |||||||||||||
11038 | 11038 | John Findlay F000121 | rep | MD | 1883-12-03 | 1885-03-03 | Democrat | 4 | |||||||||||||
11042 | 11042 | Benjamin Frederick F000357 | rep | IA | 1883-12-03 | 1885-03-03 | Democrat | 5 | |||||||||||||
11046 | 11046 | George Geddes G000115 | rep | OH | 1883-12-03 | 1885-03-03 | Democrat | 14 | |||||||||||||
11048 | 11048 | Eustace Gibson G000160 | rep | WV | 1883-12-03 | 1885-03-03 | Democrat | 4 | |||||||||||||
11052 | 11052 | Wharton Green G000419 | rep | NC | 1883-12-03 | 1885-03-03 | Democrat | 3 | |||||||||||||
11060 | 11060 | John Halsell H000086 | rep | KY | 1883-12-03 | 1885-03-03 | Democrat | 3 | |||||||||||||
11064 | 11064 | Nathaniel Hammond H000130 | rep | GA | 1883-12-03 | 1885-03-03 | Democrat | 5 | |||||||||||||
11066 | 11066 | Wade Hampton H000141 | sen | SC | 1879-03-18 | 1885-03-03 | 3 | Democrat | |||||||||||||
11068 | 11068 | Lewis Hanback H000142 | rep | KS | 1883-12-03 | 1885-03-03 | Republican | -1 | |||||||||||||
11074 | 11074 | Martin Haynes H000400 | rep | NH | 1883-12-03 | 1885-03-03 | Republican | 1 | |||||||||||||
11076 | 11076 | Barclay Henley H000498 | rep | CA | 1883-12-03 | 1885-03-03 | Democrat | 3 | |||||||||||||
11081 | 11081 | Abram Hewitt H000552 | rep | NY | 1883-12-03 | 1885-03-03 | Democrat | 10 | |||||||||||||
11084 | 11084 | William Hill H000609 | rep | OH | 1883-12-03 | 1885-03-03 | Democrat | 6 | |||||||||||||
11087 | 11087 | John Ingalls I000012 | sen | KS | 1879-03-18 | 1885-03-03 | 3 | Republican | |||||||||||||
11090 | 11090 | Darwin James J000048 | rep | NY | 1883-12-03 | 1885-03-03 | Republican | 3 | |||||||||||||
11092 | 11092 | Frederick Johnson J000131 | rep | NY | 1883-12-03 | 1885-03-03 | Republican | 18 | |||||||||||||
11094 | 11094 | James Jones J000230 | rep | TX | 1883-12-03 | 1885-03-03 | Democrat | 3 | |||||||||||||
11098 | 11098 | John King K000206 | rep | LA | 1883-12-03 | 1885-03-03 | Democrat | 5 | |||||||||||||
11100 | 11100 | John Kleiner K000263 | rep | IN | 1883-12-03 | 1885-03-03 | Democrat | 1 | |||||||||||||
11104 | 11104 | Benjamin Le Fevre L000159 | rep | OH | 1883-12-03 | 1885-03-03 | Democrat | 4 | |||||||||||||
11106 | 11106 | Harry Libbey L000298 | rep | VA | 1883-12-03 | 1885-03-03 | Readjuster | 2 | |||||||||||||
11115 | 11115 | John Logan L000403 | sen | IL | 1879-03-18 | 1885-03-03 | 3 | Republican | |||||||||||||
11117 | 11117 | Charles Lore L000443 | rep | DE | 1883-12-03 | 1885-03-03 | Democrat | 0 | |||||||||||||
11120 | 11120 | Henry Lovering L000464 | rep | MA | 1883-12-03 | 1885-03-03 | Democrat | 6 | |||||||||||||
11122 | 11122 | Robert Lowry L000487 | rep | IN | 1883-12-03 | 1885-03-03 | Democrat | 12 |
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);