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 state_rank
This data as json, copyable, CSV (advanced)
Suggested facets: 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 | |||||||||||||
9730 | 9730 | William Bacon B000020 | rep | NY | 1877-10-15 | 1879-03-03 | Republican | 23 | |||||||||||||
9732 | 9732 | George Bagley B000032 | rep | NY | 1877-10-15 | 1879-03-03 | Republican | 22 | |||||||||||||
9733 | 9733 | James Bailey B000039 | sen | TN | 1877-10-15 | 1881-03-03 | 1 | Democrat | |||||||||||||
9735 | 9735 | William Baker B000077 | rep | NY | 1877-10-15 | 1879-03-03 | Republican | 24 | |||||||||||||
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 | |||||||||||||
9746 | 9746 | Lorenzo Brentano B000804 | rep | IL | 1877-10-15 | 1879-03-03 | Republican | 3 | |||||||||||||
9749 | 9749 | Samuel Bridges B000824 | rep | PA | 1877-10-15 | 1879-03-03 | Democrat | 10 | |||||||||||||
9750 | 9750 | Curtis Brogden B000863 | rep | NC | 1877-10-15 | 1879-03-03 | Republican | 2 | |||||||||||||
9751 | 9751 | Solomon Bundy B001060 | rep | NY | 1877-10-15 | 1879-03-03 | Republican | 21 | |||||||||||||
9756 | 9756 | Horatio Burchard B001070 | rep | IL | 1877-10-15 | 1879-03-03 | Republican | 5 | |||||||||||||
9757 | 9757 | Theodore Burdick B001078 | rep | IA | 1877-10-15 | 1879-03-03 | Republican | 3 | |||||||||||||
9762 | 9762 | Benjamin Butler B001174 | rep | MA | 1877-10-15 | 1879-03-03 | Republican | 7 | |||||||||||||
9764 | 9764 | Richard Cain C000022 | rep | SC | 1877-10-15 | 1879-03-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
9771 | 9771 | Nathan Cole C000610 | rep | MO | 1877-10-15 | 1879-03-03 | Republican | 2 | |||||||||||||
9773 | 9773 | Francis Collins C000636 | rep | PA | 1877-10-15 | 1879-03-03 | Democrat | 11 | |||||||||||||
9774 | 9774 | William Corlett C000777 | rep | WY | 1877-10-15 | 1879-03-03 | Republican | 0 | |||||||||||||
9775 | 9775 | Jacob Cox C000833 | rep | OH | 1877-10-15 | 1879-03-03 | Republican | 6 | |||||||||||||
9777 | 9777 | Thomas Crittenden C000913 | rep | MO | 1877-10-15 | 1879-03-03 | Democrat | 7 | |||||||||||||
9778 | 9778 | Henry Cummings C000986 | rep | IA | 1877-10-15 | 1879-03-03 | Republican | 7 | |||||||||||||
9780 | 9780 | Augustus Cutler C001025 | rep | NJ | 1877-10-15 | 1879-03-03 | Democrat | 5 | |||||||||||||
9781 | 9781 | David Davis D000097 | sen | IL | 1877-10-15 | 1883-03-03 | 2 | Independent | |||||||||||||
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 | |||||||||||||
9786 | 9786 | Dudley Denison D000236 | rep | VT | 1877-10-15 | 1879-03-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
9795 | 9795 | Benjamin Eames E000005 | rep | RI | 1877-10-15 | 1879-03-03 | Republican | 1 | |||||||||||||
9796 | 9796 | Anthony Eickhoff E000095 | rep | NY | 1877-10-15 | 1879-03-03 | Democrat | 7 | |||||||||||||
9797 | 9797 | Charles Ellsworth E000144 | rep | MI | 1877-10-15 | 1879-03-03 | Republican | 8 | |||||||||||||
9799 | 9799 | James Evans E000245 | rep | IN | 1877-10-15 | 1879-03-03 | Republican | 11 | |||||||||||||
9801 | 9801 | Stephen Fenn F000073 | rep | ID | 1877-10-15 | 1879-03-03 | Democrat | -1 | |||||||||||||
9806 | 9806 | Thomas Ferry F000095 | sen | MI | 1877-10-15 | 1883-03-03 | 2 | Republican | |||||||||||||
9807 | 9807 | William Fleming F000197 | rep | GA | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
9811 | 9811 | Charles Foster F000299 | rep | OH | 1877-10-15 | 1879-03-03 | Republican | 10 | |||||||||||||
9813 | 9813 | Benjamin Franklin F000343 | rep | MO | 1877-10-15 | 1879-03-03 | Democrat | 8 | |||||||||||||
9815 | 9815 | Chapman Freeman F000361 | rep | PA | 1877-10-15 | 1879-03-03 | Republican | 1 | |||||||||||||
9817 | 9817 | Benoni Fuller F000406 | rep | IN | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
9818 | 9818 | Mills Gardner G000059 | rep | OH | 1877-10-15 | 1879-03-03 | Republican | 3 | |||||||||||||
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 | |||||||||||||
9832 | 9832 | John Hanna H000160 | rep | IN | 1877-10-15 | 1879-03-03 | Republican | 7 | |||||||||||||
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 | |||||||||||||
9845 | 9845 | George Hendee H000474 | rep | VT | 1877-10-15 | 1879-03-03 | Republican | 3 | |||||||||||||
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 | |||||||||||||
9852 | 9852 | John Hungerford H000966 | rep | NY | 1877-10-15 | 1879-03-03 | Republican | 29 | |||||||||||||
9856 | 9856 | Morton Hunter H000985 | rep | IN | 1877-10-15 | 1879-03-03 | Republican | 8 | |||||||||||||
9857 | 9857 | Anthony Ittner I000048 | rep | MO | 1877-10-15 | 1879-03-03 | Republican | 1 | |||||||||||||
9859 | 9859 | Orange Jacobs J000037 | rep | WA | 1877-10-15 | 1879-03-03 | Republican | -1 | |||||||||||||
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 | |||||||||||||
9865 | 9865 | John Jones J000238 | rep | OH | 1877-10-15 | 1879-03-03 | Republican | 9 | |||||||||||||
9866 | 9866 | Edwin Keightley K000049 | rep | MI | 1877-10-15 | 1879-03-03 | Republican | 4 | |||||||||||||
9868 | 9868 | Jefferson Kidder K000164 | rep | DK | 1877-10-15 | 1879-03-03 | Republican | -1 | |||||||||||||
9870 | 9870 | Samuel Kirkwood K000242 | sen | IA | 1877-10-15 | 1881-12-31 | 2 | Republican | |||||||||||||
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 | |||||||||||||
9875 | 9875 | William Lathrop L000113 | rep | IL | 1877-10-15 | 1879-03-03 | Republican | 4 | |||||||||||||
9876 | 9876 | John Leonard L000247 | rep | LA | 1877-10-15 | 1879-03-03 | Republican | 5 | |||||||||||||
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 | |||||||||||||
9886 | 9886 | Stanley Matthews M000255 | sen | OH | 1877-10-15 | 1879-03-03 | 3 | Republican | |||||||||||||
9888 | 9888 | Stephen Mayham M000282 | rep | NY | 1877-10-15 | 1879-03-03 | Democrat | 15 | |||||||||||||
9889 | 9889 | Lyne Metcalfe M000674 | rep | MO | 1877-10-15 | 1879-03-03 | Republican | 3 | |||||||||||||
9891 | 9891 | Samuel Oliver O000076 | rep | IA | 1877-10-15 | 1879-03-03 | Republican | 9 | |||||||||||||
9892 | 9892 | George Patterson P000116 | rep | NY | 1877-10-15 | 1879-03-03 | Republican | 33 | |||||||||||||
9893 | 9893 | Thomas Peddie P000181 | rep | NJ | 1877-10-15 | 1879-03-03 | Republican | 6 | |||||||||||||
9896 | 9896 | William Phillips P000315 | rep | KS | 1877-10-15 | 1879-03-03 | Republican | 1 | |||||||||||||
9897 | 9897 | Henry Pollard P000414 | rep | MO | 1877-10-15 | 1879-03-03 | Republican | 10 | |||||||||||||
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 | |||||||||||||
9903 | 9903 | John Pugh P000563 | rep | NJ | 1877-10-15 | 1879-03-03 | Republican | 2 | |||||||||||||
9904 | 9904 | Terence Quinn Q000020 | rep | NY | 1877-10-15 | 1879-03-03 | Democrat | 16 | |||||||||||||
9909 | 9909 | Joseph Rainey R000016 | rep | SC | 1877-10-15 | 1879-03-03 | Republican | 1 | |||||||||||||
9910 | 9910 | James Randolph R000045 | rep | TN | 1877-10-15 | 1879-03-03 | Republican | 1 | |||||||||||||
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 | |||||||||||||
9923 | 9923 | Milton Robinson R000349 | rep | IN | 1877-10-15 | 1879-03-03 | Republican | 6 | |||||||||||||
9927 | 9927 | Edward Rollins R000411 | sen | NH | 1877-10-15 | 1883-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);