legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
337 rows where "end" is on date 1879-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9919 | 9919 | William Robbins R000302 | rep | NC | 1877-10-15 | 1879-03-03 | Democrat | 7 | |||||||||||||
9921 | 9921 | Charles Roberts R000306 | rep | MD | 1877-10-15 | 1879-03-03 | Democrat | 2 | |||||||||||||
9923 | 9923 | Milton Robinson R000349 | rep | IN | 1877-10-15 | 1879-03-03 | Republican | 6 | |||||||||||||
9928 | 9928 | Trinidad Romero R000416 | rep | NM | 1877-10-15 | 1879-03-03 | Republican | -1 | |||||||||||||
9930 | 9930 | Ezekiel Sampson S000025 | rep | IA | 1877-10-15 | 1879-03-03 | Republican | 6 | |||||||||||||
9934 | 9934 | Milton Sayler S000101 | rep | OH | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
9935 | 9935 | Leonidas Sexton S000263 | rep | IN | 1877-10-15 | 1879-03-03 | Republican | 4 | |||||||||||||
9937 | 9937 | Clement Sinnickson S000447 | rep | NJ | 1877-10-15 | 1879-03-03 | Republican | 1 | |||||||||||||
9940 | 9940 | Milton Southard S000688 | rep | OH | 1877-10-15 | 1879-03-03 | Democrat | 13 | |||||||||||||
9942 | 9942 | William Stenger S000849 | rep | PA | 1877-10-15 | 1879-03-03 | Democrat | 18 | |||||||||||||
9944 | 9944 | Hiram Stevens S000880 | rep | AZ | 1877-10-15 | 1879-03-03 | Democrat | 0 | |||||||||||||
9945 | 9945 | Jacob Stewart S000908 | rep | MN | 1877-10-15 | 1879-03-03 | Republican | 3 | |||||||||||||
9946 | 9946 | Joseph Stone S000960 | rep | IA | 1877-10-15 | 1879-03-03 | Republican | 1 | |||||||||||||
9951 | 9951 | Thomas Swann S001092 | rep | MD | 1877-10-15 | 1879-03-03 | Democrat | 4 | |||||||||||||
9953 | 9953 | John Thompson T000209 | rep | PA | 1877-10-15 | 1879-03-03 | Republican | 26 | |||||||||||||
9956 | 9956 | Jacob Thornburgh T000239 | rep | TN | 1877-10-15 | 1879-03-03 | Republican | 2 | |||||||||||||
9957 | 9957 | Thomas Tipton T000285 | rep | IL | 1877-10-15 | 1879-03-03 | Republican | 13 | |||||||||||||
9959 | 9959 | Martin Townsend T000336 | rep | NY | 1877-10-15 | 1879-03-03 | Republican | 17 | |||||||||||||
9961 | 9961 | Jacob Turney T000431 | rep | PA | 1877-10-15 | 1879-03-03 | Democrat | 21 | |||||||||||||
9963 | 9963 | Nelson Van Vorhes V000064 | rep | OH | 1877-10-15 | 1879-03-03 | Republican | 15 | |||||||||||||
9964 | 9964 | William Veeder V000079 | rep | NY | 1877-10-15 | 1879-03-03 | Democrat | 2 | |||||||||||||
9968 | 9968 | Alfred Waddell W000002 | rep | NC | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
9970 | 9970 | Gilbert Walker W000054 | rep | VA | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
9972 | 9972 | William Walsh W000106 | rep | MD | 1877-10-15 | 1879-03-03 | Democrat | 6 | |||||||||||||
9974 | 9974 | Levi Warner W000155 | rep | CT | 1877-10-15 | 1879-03-03 | Democrat | 4 | |||||||||||||
9975 | 9975 | Frank Welch W000262 | rep | NE | 1877-10-15 | 1879-03-03 | Republican | 1 | |||||||||||||
9976 | 9976 | Michael White W000386 | rep | IN | 1877-10-15 | 1879-03-03 | Republican | 9 | |||||||||||||
9978 | 9978 | Peter Wigginton W000449 | rep | CA | 1877-10-15 | 1879-03-03 | Democrat | 4 | |||||||||||||
9980 | 9980 | Alpheus Williams W000487 | rep | MI | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
9982 | 9982 | Andrew Williams W000488 | rep | NY | 1877-10-15 | 1879-03-03 | Republican | 18 | |||||||||||||
9984 | 9984 | James Williams W000506 | rep | DE | 1877-10-15 | 1879-03-03 | Democrat | 0 | |||||||||||||
9986 | 9986 | Jeremiah Williams W000512 | rep | AL | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
9987 | 9987 | Richard Williams W000533 | rep | OR | 1877-10-15 | 1879-03-03 | Republican | 1 | |||||||||||||
9989 | 9989 | Benjamin Willis W000558 | rep | NY | 1877-10-15 | 1879-03-03 | Democrat | 11 | |||||||||||||
9990 | 9990 | Thomas Wren W000753 | rep | NV | 1877-10-15 | 1879-03-03 | Republican | 0 | |||||||||||||
9991 | 9991 | John Young Y000045 | rep | LA | 1877-10-15 | 1879-03-03 | Democrat | 5 | |||||||||||||
9992 | 9992 | Joseph Acklen A000023 | rep | LA | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
9995 | 9995 | John Bailey B000042 | rep | NY | 1877-10-15 | 1879-03-03 | Republican | 16 | |||||||||||||
9998 | 9998 | John Baker B000068 | rep | IN | 1877-10-15 | 1879-03-03 | Republican | 13 | |||||||||||||
10002 | 10002 | Latimer Ballou B000106 | rep | RI | 1877-10-15 | 1879-03-03 | Republican | 2 | |||||||||||||
10007 | 10007 | Richard Beale B000268 | rep | VA | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
10011 | 10011 | George Bicknell B000438 | rep | IN | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
10014 | 10014 | Gabriel Bouck B000658 | rep | WI | 1877-10-15 | 1879-03-03 | Democrat | 6 | |||||||||||||
10016 | 10016 | Thomas Boyd B000721 | rep | IL | 1877-10-15 | 1879-03-03 | Republican | 9 | |||||||||||||
10022 | 10022 | John Bright B000836 | rep | TN | 1877-10-15 | 1879-03-03 | Democrat | 5 | |||||||||||||
10033 | 10033 | Simeon Chittenden C000373 | rep | NY | 1877-10-15 | 1879-03-03 | Republican | 3 | |||||||||||||
10035 | 10035 | William Claflin C000398 | rep | MA | 1877-10-15 | 1879-03-03 | Republican | 8 | |||||||||||||
10037 | 10037 | Alvah Clark C000419 | rep | NJ | 1877-10-15 | 1879-03-03 | Democrat | 4 | |||||||||||||
10039 | 10039 | Rush Clark C000450 | rep | IA | 1877-10-15 | 1879-03-03 | Republican | 5 | |||||||||||||
10044 | 10044 | Hiester Clymer C000539 | rep | PA | 1877-10-15 | 1879-03-03 | Democrat | 8 | |||||||||||||
10053 | 10053 | Roscoe Conkling C000681 | sen | NY | 1873-12-01 | 1879-03-03 | 3 | Republican | |||||||||||||
10057 | 10057 | Horace Davis D000105 | rep | CA | 1877-10-15 | 1879-03-03 | Republican | 1 | |||||||||||||
10060 | 10060 | Joseph Davis D000123 | rep | NC | 1877-10-15 | 1879-03-03 | Democrat | 4 | |||||||||||||
10064 | 10064 | Henry Dickey D000311 | rep | OH | 1877-10-15 | 1879-03-03 | Democrat | 7 | |||||||||||||
10068 | 10068 | Joseph Elam E000100 | rep | LA | 1877-10-15 | 1879-03-03 | Democrat | 4 | |||||||||||||
10070 | 10070 | Thomas Ewing E000280 | rep | OH | 1877-10-15 | 1879-03-03 | Democrat | 12 | |||||||||||||
10075 | 10075 | William Felton F000070 | rep | GA | 1877-10-15 | 1879-03-03 | Ind. Democrat | 7 | |||||||||||||
10078 | 10078 | Walbridge Field F000108 | rep | MA | 1877-10-15 | 1879-03-03 | Republican | 3 | |||||||||||||
10080 | 10080 | Ebenezer Finley F000132 | rep | OH | 1877-10-15 | 1879-03-03 | Democrat | 14 | |||||||||||||
10085 | 10085 | Greenbury Fort F000288 | rep | IL | 1877-10-15 | 1879-03-03 | Republican | 8 | |||||||||||||
10089 | 10089 | John Goode G000277 | rep | VA | 1877-10-15 | 1879-03-03 | Democrat | 2 | |||||||||||||
10096 | 10096 | John Harris H000247 | rep | VA | 1877-10-15 | 1879-03-03 | Democrat | 7 | |||||||||||||
10098 | 10098 | Philip Hayes H000391 | rep | IL | 1877-10-15 | 1879-03-03 | Republican | 7 | |||||||||||||
10101 | 10101 | Eli Henkle H000497 | rep | MD | 1877-10-15 | 1879-03-03 | Democrat | 5 | |||||||||||||
10103 | 10103 | Daniel Henry H000504 | rep | MD | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
10118 | 10118 | Amaziah James J000044 | rep | NY | 1877-10-15 | 1879-03-03 | Republican | 19 | |||||||||||||
10126 | 10126 | John Killinger K000179 | rep | PA | 1877-10-15 | 1879-03-03 | Republican | 14 | |||||||||||||
10128 | 10128 | William Kimmel K000185 | rep | MD | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
10134 | 10134 | George Loring L000445 | rep | MA | 1877-10-15 | 1879-03-03 | Republican | 6 | |||||||||||||
10137 | 10137 | Thomas Majors M000075 | rep | NE | 1877-10-15 | 1879-03-03 | Republican | 1 | |||||||||||||
10139 | 10139 | Benjamin Martin M000169 | rep | WV | 1877-10-15 | 1879-03-03 | Democrat | 2 | |||||||||||||
10142 | 10142 | Jonas McGowan M000453 | rep | MI | 1877-10-15 | 1879-03-03 | Republican | 3 | |||||||||||||
10145 | 10145 | John McMahon M000561 | rep | OH | 1877-10-15 | 1879-03-03 | Democrat | 4 | |||||||||||||
10150 | 10150 | James Monroe M000857 | rep | OH | 1877-10-15 | 1879-03-03 | Republican | 18 | |||||||||||||
10160 | 10160 | Edward Overton O000145 | rep | PA | 1877-10-15 | 1879-03-03 | Republican | 15 | |||||||||||||
10175 | 10175 | Hiram Price P000525 | rep | IA | 1877-10-15 | 1879-03-03 | Republican | 2 | |||||||||||||
10182 | 10182 | William Sapp S000060 | rep | IA | 1877-10-15 | 1879-03-03 | Republican | 8 | |||||||||||||
10186 | 10186 | Gustave Schleicher S000129 | rep | TX | 1877-10-15 | 1879-03-03 | Democrat | 6 | |||||||||||||
10190 | 10190 | James Shields S000362 | sen | MO | 1879-01-27 | 1879-03-03 | 3 | Democrat | |||||||||||||
10194 | 10194 | William Slemons S000484 | rep | AR | 1877-10-15 | 1879-03-03 | Democrat | 2 | |||||||||||||
10198 | 10198 | William Smith S000631 | rep | GA | 1877-10-15 | 1879-03-03 | Democrat | 2 | |||||||||||||
10200 | 10200 | John Starin S000808 | rep | NY | 1877-10-15 | 1879-03-03 | Republican | 20 | |||||||||||||
10202 | 10202 | Walter Steele S000838 | rep | NC | 1877-10-15 | 1879-03-03 | Democrat | 6 | |||||||||||||
10206 | 10206 | John Stone S000959 | rep | MI | 1877-10-15 | 1879-03-03 | Republican | 5 | |||||||||||||
10208 | 10208 | Thomas Turner T000428 | rep | KY | 1877-10-15 | 1879-03-03 | Democrat | 9 | |||||||||||||
10218 | 10218 | Harry White W000373 | rep | PA | 1877-10-15 | 1879-03-03 | Republican | 25 | |||||||||||||
10224 | 10224 | Hendrick Wright W000761 | rep | PA | 1877-10-15 | 1879-03-03 | Democrat | 12 | |||||||||||||
10227 | 10227 | Jesse Yeates Y000016 | rep | NC | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
10237 | 10237 | James Garfield G000063 | rep | OH | 1877-10-15 | 1879-03-03 | Republican | 19 | |||||||||||||
10250 | 10250 | William Aldrich A000086 | rep | IL | 1877-10-15 | 1879-03-03 | Republican | 1 | |||||||||||||
10261 | 10261 | John Atkins A000327 | rep | TN | 1877-10-15 | 1879-03-03 | Democrat | 8 | |||||||||||||
10272 | 10272 | James Briggs B000831 | rep | NH | 1877-10-15 | 1879-03-03 | Republican | 2 | |||||||||||||
10276 | 10276 | John Caldwell C000036 | rep | KY | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
10281 | 10281 | John Camp C000072 | rep | NY | 1877-10-15 | 1879-03-03 | Republican | 26 | |||||||||||||
10286 | 10286 | George Cannon C000119 | rep | UT | 1877-10-15 | 1879-03-03 | Republican | -1 | |||||||||||||
10294 | 10294 | John Clark C000442 | rep | MO | 1877-10-15 | 1879-03-03 | Democrat | 11 | |||||||||||||
10303 | 10303 | Omar Conger C000678 | rep | MI | 1877-10-15 | 1879-03-03 | Republican | 7 | |||||||||||||
10308 | 10308 | Philip Cook C000724 | rep | GA | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
10314 | 10314 | William Crapo C000881 | rep | MA | 1877-10-15 | 1879-03-03 | Republican | 1 | |||||||||||||
10317 | 10317 | Jordan Cravens C000885 | rep | AR | 1877-10-15 | 1879-03-03 | Ind. 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);