legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
340 rows where "start" is on date 1877-10-15 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: type, class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9729 | 9729 | David Armstrong A000279 | sen | MO | 1877-10-15 | 1879-03-03 | 3 | Democrat | |||||||||||||
9733 | 9733 | James Bailey B000039 | sen | TN | 1877-10-15 | 1881-03-03 | 1 | Democrat | |||||||||||||
9738 | 9738 | Henry Banning B000117 | rep | OH | 1877-10-15 | 1879-03-03 | Democrat | 2 | |||||||||||||
9740 | 9740 | George Beebe B000305 | rep | NY | 1877-10-15 | 1879-03-03 | Democrat | 14 | |||||||||||||
9742 | 9742 | Hiram Bell B000336 | rep | GA | 1877-10-15 | 1879-03-03 | Democrat | 9 | |||||||||||||
9743 | 9743 | Charles Benedict B000357 | rep | NY | 1877-10-15 | 1879-03-03 | Democrat | 31 | |||||||||||||
9745 | 9745 | Andrew Boone B000629 | rep | KY | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
9749 | 9749 | Samuel Bridges B000824 | rep | PA | 1877-10-15 | 1879-03-03 | Democrat | 10 | |||||||||||||
9766 | 9766 | William Caldwell C000041 | rep | TN | 1877-10-15 | 1879-03-03 | Democrat | 9 | |||||||||||||
9768 | 9768 | Milton Candler C000112 | rep | GA | 1877-10-15 | 1879-03-03 | Democrat | 5 | |||||||||||||
9770 | 9770 | John Clarke C000464 | rep | KY | 1877-10-15 | 1879-03-03 | Democrat | 10 | |||||||||||||
9773 | 9773 | Francis Collins C000636 | rep | PA | 1877-10-15 | 1879-03-03 | Democrat | 11 | |||||||||||||
9777 | 9777 | Thomas Crittenden C000913 | rep | MO | 1877-10-15 | 1879-03-03 | Democrat | 7 | |||||||||||||
9780 | 9780 | Augustus Cutler C001025 | rep | NJ | 1877-10-15 | 1879-03-03 | Democrat | 5 | |||||||||||||
9783 | 9783 | Henry Davis D000103 | sen | WV | 1877-10-15 | 1883-03-03 | 2 | Democrat | |||||||||||||
9784 | 9784 | Benjamin Dean D000170 | rep | MA | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
9788 | 9788 | Beverly Douglas D000450 | rep | VA | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
9791 | 9791 | Milton Durham D000572 | rep | KY | 1877-10-15 | 1879-03-03 | Democrat | 8 | |||||||||||||
9796 | 9796 | Anthony Eickhoff E000095 | rep | NY | 1877-10-15 | 1879-03-03 | Democrat | 7 | |||||||||||||
9801 | 9801 | Stephen Fenn F000073 | rep | ID | 1877-10-15 | 1879-03-03 | Democrat | -1 | |||||||||||||
9807 | 9807 | William Fleming F000197 | rep | GA | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
9813 | 9813 | Benjamin Franklin F000343 | rep | MO | 1877-10-15 | 1879-03-03 | Democrat | 8 | |||||||||||||
9817 | 9817 | Benoni Fuller F000406 | rep | IN | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
9819 | 9819 | William Garth G000086 | rep | AL | 1877-10-15 | 1879-03-03 | Democrat | 8 | |||||||||||||
9821 | 9821 | Lucien Gause G000100 | rep | AR | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
9824 | 9824 | De Giddings G000166 | rep | TX | 1877-10-15 | 1879-03-03 | Democrat | 5 | |||||||||||||
9827 | 9827 | John Glover G000245 | rep | MO | 1877-10-15 | 1879-03-03 | Democrat | 12 | |||||||||||||
9829 | 9829 | La Grover G000505 | sen | OR | 1877-10-15 | 1883-03-03 | 2 | Democrat | |||||||||||||
9831 | 9831 | Andrew Hamilton H000102 | rep | IN | 1877-10-15 | 1879-03-03 | Democrat | 12 | |||||||||||||
9834 | 9834 | Carter Harrison H000267 | rep | IL | 1877-10-15 | 1879-03-03 | Democrat | 2 | |||||||||||||
9835 | 9835 | Elizur Hart H000285 | rep | NY | 1877-10-15 | 1879-03-03 | Democrat | 30 | |||||||||||||
9837 | 9837 | Julian Hartridge H000303 | rep | GA | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
9839 | 9839 | William Hartzell H000304 | rep | IL | 1877-10-15 | 1879-03-03 | Democrat | 18 | |||||||||||||
9842 | 9842 | Robert Hatcher H000341 | rep | MO | 1877-10-15 | 1879-03-03 | Democrat | 4 | |||||||||||||
9849 | 9849 | Frank Hereford H000527 | sen | WV | 1877-10-15 | 1881-03-03 | 1 | Democrat | |||||||||||||
9851 | 9851 | Benjamin Hill H000587 | sen | GA | 1877-10-15 | 1883-03-03 | 2 | Democrat | |||||||||||||
9862 | 9862 | John Johnston J000191 | sen | VA | 1877-10-15 | 1883-03-03 | 2 | Democrat | |||||||||||||
9864 | 9864 | Frank Jones J000219 | rep | NH | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
9872 | 9872 | Robert Knapp K000281 | rep | IL | 1877-10-15 | 1879-03-03 | Democrat | 11 | |||||||||||||
9874 | 9874 | George Landers L000047 | rep | CT | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
9877 | 9877 | Robert Ligon L000306 | rep | AL | 1877-10-15 | 1879-03-03 | Democrat | 5 | |||||||||||||
9880 | 9880 | John Luttrell L000522 | rep | CA | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
9883 | 9883 | William Lynde L000538 | rep | WI | 1877-10-15 | 1879-03-03 | Democrat | 4 | |||||||||||||
9885 | 9885 | Levi Mackey M000025 | rep | PA | 1877-10-15 | 1879-03-03 | Democrat | 20 | |||||||||||||
9888 | 9888 | Stephen Mayham M000282 | rep | NY | 1877-10-15 | 1879-03-03 | Democrat | 15 | |||||||||||||
9901 | 9901 | Clarkson Potter P000461 | rep | NY | 1877-10-15 | 1879-03-03 | Democrat | 12 | |||||||||||||
9902 | 9902 | Auburn Pridemore P000535 | rep | VA | 1877-10-15 | 1879-03-03 | Democrat | 9 | |||||||||||||
9904 | 9904 | Terence Quinn Q000020 | rep | NY | 1877-10-15 | 1879-03-03 | Democrat | 16 | |||||||||||||
9912 | 9912 | David Rea R000088 | rep | MO | 1877-10-15 | 1879-03-03 | Democrat | 9 | |||||||||||||
9914 | 9914 | Americus Rice R000194 | rep | OH | 1877-10-15 | 1879-03-03 | Democrat | 5 | |||||||||||||
9916 | 9916 | Haywood Riddle R000240 | rep | TN | 1877-10-15 | 1879-03-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
9934 | 9934 | Milton Sayler S000101 | rep | OH | 1877-10-15 | 1879-03-03 | Democrat | 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 | |||||||||||||
9951 | 9951 | Thomas Swann S001092 | rep | MD | 1877-10-15 | 1879-03-03 | Democrat | 4 | |||||||||||||
9961 | 9961 | Jacob Turney T000431 | rep | PA | 1877-10-15 | 1879-03-03 | Democrat | 21 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
9989 | 9989 | Benjamin Willis W000558 | rep | NY | 1877-10-15 | 1879-03-03 | Democrat | 11 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
10022 | 10022 | John Bright B000836 | rep | TN | 1877-10-15 | 1879-03-03 | Democrat | 5 | |||||||||||||
10037 | 10037 | Alvah Clark C000419 | rep | NJ | 1877-10-15 | 1879-03-03 | Democrat | 4 | |||||||||||||
10044 | 10044 | Hiester Clymer C000539 | rep | PA | 1877-10-15 | 1879-03-03 | Democrat | 8 | |||||||||||||
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 | |||||||||||||
10080 | 10080 | Ebenezer Finley F000132 | rep | OH | 1877-10-15 | 1879-03-03 | Democrat | 14 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
10128 | 10128 | William Kimmel K000185 | rep | MD | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
10139 | 10139 | Benjamin Martin M000169 | rep | WV | 1877-10-15 | 1879-03-03 | Democrat | 2 | |||||||||||||
10145 | 10145 | John McMahon M000561 | rep | OH | 1877-10-15 | 1879-03-03 | Democrat | 4 | |||||||||||||
10186 | 10186 | Gustave Schleicher S000129 | rep | TX | 1877-10-15 | 1879-03-03 | Democrat | 6 | |||||||||||||
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 | |||||||||||||
10202 | 10202 | Walter Steele S000838 | rep | NC | 1877-10-15 | 1879-03-03 | Democrat | 6 | |||||||||||||
10208 | 10208 | Thomas Turner T000428 | rep | KY | 1877-10-15 | 1879-03-03 | Democrat | 9 | |||||||||||||
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 | |||||||||||||
10261 | 10261 | John Atkins A000327 | rep | TN | 1877-10-15 | 1879-03-03 | Democrat | 8 | |||||||||||||
10276 | 10276 | John Caldwell C000036 | rep | KY | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
10294 | 10294 | John Clark C000442 | rep | MO | 1877-10-15 | 1879-03-03 | Democrat | 11 | |||||||||||||
10308 | 10308 | Philip Cook C000724 | rep | GA | 1877-10-15 | 1879-03-03 | 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);