legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
435 rows where "start" is on date 1905-12-04
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14547 | 14547 | Henry Adams A000037 | rep | WI | 1905-12-04 | 1907-03-03 | Republican | 2 | |||||||||||||
14554 | 14554 | Robert Adams A000044 | rep | PA | 1905-12-04 | 1907-03-03 | Republican | 2 | |||||||||||||
14561 | 14561 | Nelson Aldrich A000083 | sen | RI | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14562 | 14562 | Henry Allen A000124 | rep | NJ | 1905-12-04 | 1907-03-03 | Republican | 6 | |||||||||||||
14569 | 14569 | Joseph Babcock B000004 | rep | WI | 1905-12-04 | 1907-03-03 | Republican | 3 | |||||||||||||
14572 | 14572 | Jacob Beidler B000317 | rep | OH | 1905-12-04 | 1907-03-03 | Republican | 20 | |||||||||||||
14574 | 14574 | Albert Beveridge B000429 | sen | IN | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14580 | 14580 | Roswell Bishop B000489 | rep | MI | 1905-12-04 | 1907-03-03 | Republican | 9 | |||||||||||||
14582 | 14582 | Edmond Blackburn B000507 | rep | NC | 1905-12-04 | 1907-03-03 | Republican | 8 | |||||||||||||
14586 | 14586 | Justin Bowersock B000693 | rep | KS | 1905-12-04 | 1907-03-03 | Republican | 2 | |||||||||||||
14589 | 14589 | Sydney Bowie B000695 | rep | AL | 1905-12-04 | 1907-03-03 | Democrat | 4 | |||||||||||||
14590 | 14590 | Moses Broocks B000870 | rep | TX | 1905-12-04 | 1907-03-03 | Democrat | 2 | |||||||||||||
14592 | 14592 | Franklin Brooks B000878 | rep | CO | 1905-12-04 | 1907-03-03 | Republican | -1 | |||||||||||||
14595 | 14595 | Webster Brown B000946 | rep | WI | 1905-12-04 | 1907-03-03 | Republican | 10 | |||||||||||||
14597 | 14597 | Clarence Buckman B001029 | rep | MN | 1905-12-04 | 1907-03-03 | Republican | 6 | |||||||||||||
14598 | 14598 | Morgan Bulkeley B001044 | sen | CT | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14602 | 14602 | Elmer Burkett B001103 | sen | NE | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14613 | 14613 | Julius Burrows B001142 | sen | MI | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14614 | 14614 | Mounce Butler B001185 | rep | TN | 1905-12-04 | 1907-03-03 | Democrat | 4 | |||||||||||||
14615 | 14615 | William Campbell C000106 | rep | OH | 1905-12-04 | 1907-03-03 | Republican | 5 | |||||||||||||
14618 | 14618 | Thomas Carter C000200 | sen | MT | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14620 | 14620 | George Castor C000244 | rep | PA | 1905-12-04 | 1907-03-03 | Republican | 3 | |||||||||||||
14624 | 14624 | George Cromer C000924 | rep | IN | 1905-12-04 | 1907-03-03 | Republican | 8 | |||||||||||||
14625 | 14625 | Thomas Dale D000010 | rep | PA | 1905-12-04 | 1907-03-03 | Republican | 10 | |||||||||||||
14630 | 14630 | John Daniel D000035 | sen | VA | 1905-12-04 | 1911-03-03 | 1 | Democrat | |||||||||||||
14631 | 14631 | Thomas Davis D000137 | rep | WV | 1905-12-04 | 1907-03-03 | Democrat | 2 | |||||||||||||
14637 | 14637 | Alston Dayton D000163 | rep | WV | 1905-12-04 | 1907-03-03 | Republican | 2 | |||||||||||||
14640 | 14640 | Elias Deemer D000186 | rep | PA | 1905-12-04 | 1907-03-03 | Republican | 15 | |||||||||||||
14642 | 14642 | Chauncey Depew D000264 | sen | NY | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14643 | 14643 | Frank Dickson D000329 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 23 | |||||||||||||
14649 | 14649 | Blackburn Dovener D000461 | rep | WV | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
14651 | 14651 | Solomon Dresser D000493 | rep | PA | 1905-12-04 | 1907-03-03 | Republican | 21 | |||||||||||||
14653 | 14653 | Scott Field F000107 | rep | TX | 1905-12-04 | 1907-03-03 | Democrat | 6 | |||||||||||||
14655 | 14655 | William Flack F000180 | rep | NY | 1905-12-04 | 1907-03-03 | Republican | 26 | |||||||||||||
14661 | 14661 | Loren Fletcher F000202 | rep | MN | 1905-12-04 | 1907-03-03 | Republican | 5 | |||||||||||||
14662 | 14662 | Frank Flint F000207 | sen | CA | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14663 | 14663 | James Frazier F000352 | sen | TN | 1905-12-04 | 1911-03-03 | 1 | Democrat | |||||||||||||
14664 | 14664 | Frank Fulkerson F000403 | rep | MO | 1905-12-04 | 1907-03-03 | Republican | 4 | |||||||||||||
14666 | 14666 | Harvey Garber G000044 | rep | OH | 1905-12-04 | 1907-03-03 | Democrat | 4 | |||||||||||||
14667 | 14667 | John Gearin G000112 | sen | OR | 1905-12-04 | 1907-03-03 | 2 | Democrat | |||||||||||||
14671 | 14671 | George Gilbert G000174 | rep | KY | 1905-12-04 | 1907-03-03 | Democrat | 8 | |||||||||||||
14672 | 14672 | Newton Gilbert G000176 | rep | IN | 1905-12-04 | 1907-03-03 | Republican | 12 | |||||||||||||
14674 | 14674 | James Gillett G000202 | rep | CA | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
14684 | 14684 | Charles Grosvenor G000497 | rep | OH | 1905-12-04 | 1907-03-03 | Republican | 11 | |||||||||||||
14694 | 14694 | Eugene Hale H000029 | sen | ME | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14696 | 14696 | William Hearst H000429 | rep | NY | 1905-12-04 | 1907-03-03 | Democrat | 11 | |||||||||||||
14700 | 14700 | Thomas Hedge H000441 | rep | IA | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
14706 | 14706 | James Hemenway H000467 | sen | IN | 1905-12-04 | 1909-03-03 | 3 | Republican | |||||||||||||
14714 | 14714 | Binger Hermann H000531 | rep | OR | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
14727 | 14727 | Robert Hitt H000649 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 13 | |||||||||||||
14728 | 14728 | Rockwood Hoar H000655 | rep | MA | 1905-12-04 | 1907-03-03 | Republican | 3 | |||||||||||||
14730 | 14730 | Herschel Hogg H000703 | rep | CO | 1905-12-04 | 1907-03-03 | Republican | 2 | |||||||||||||
14732 | 14732 | Francis Hopkins H000773 | rep | KY | 1905-12-04 | 1907-03-03 | Democrat | 10 | |||||||||||||
14734 | 14734 | John Hunt H000973 | rep | MO | 1905-12-04 | 1907-03-03 | Democrat | 11 | |||||||||||||
14738 | 14738 | John Kean K000028 | sen | NJ | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14739 | 14739 | John Kennedy K000108 | rep | NE | 1905-12-04 | 1907-03-03 | Republican | 2 | |||||||||||||
14756 | 14756 | John Ketcham K000152 | rep | NY | 1905-12-04 | 1907-03-03 | Republican | 21 | |||||||||||||
14757 | 14757 | Frank Klepper K000265 | rep | MO | 1905-12-04 | 1907-03-03 | Republican | 3 | |||||||||||||
14759 | 14759 | Marcus Kline K000268 | rep | PA | 1905-12-04 | 1907-03-03 | Democrat | 13 | |||||||||||||
14767 | 14767 | John Lacey L000010 | rep | IA | 1905-12-04 | 1907-03-03 | Republican | 6 | |||||||||||||
14769 | 14769 | Frederick Landis L000051 | rep | IN | 1905-12-04 | 1907-03-03 | Republican | 11 | |||||||||||||
14770 | 14770 | Frank Le Fevre L000160 | rep | NY | 1905-12-04 | 1907-03-03 | Republican | 24 | |||||||||||||
14779 | 14779 | Rufus Lester L000255 | rep | GA | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
14780 | 14780 | Mial Lilley L000309 | rep | PA | 1905-12-04 | 1907-03-03 | Republican | 14 | |||||||||||||
14785 | 14785 | Lucius Littauer L000347 | rep | NY | 1905-12-04 | 1907-03-03 | Republican | 25 | |||||||||||||
14792 | 14792 | John Little L000352 | rep | AR | 1905-12-04 | 1907-03-03 | Democrat | 4 | |||||||||||||
14799 | 14799 | Thaddeus Mahon M000066 | rep | PA | 1905-12-04 | 1907-03-03 | Republican | 17 | |||||||||||||
14808 | 14808 | Benjamin Marsh M000145 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 14 | |||||||||||||
14810 | 14810 | John McCarthy M000314 | rep | NE | 1905-12-04 | 1907-03-03 | Republican | 3 | |||||||||||||
14817 | 14817 | James McCleary M000326 | rep | MN | 1905-12-04 | 1907-03-03 | Republican | 2 | |||||||||||||
14821 | 14821 | Allan McDermott M000403 | rep | NJ | 1905-12-04 | 1907-03-03 | Democrat | 10 | |||||||||||||
14823 | 14823 | William McNary M000584 | rep | MA | 1905-12-04 | 1907-03-03 | Democrat | 10 | |||||||||||||
14824 | 14824 | Anthony Michalek M000691 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 5 | |||||||||||||
14830 | 14830 | Edward Minor M000798 | rep | WI | 1905-12-04 | 1907-03-03 | Republican | 9 | |||||||||||||
14840 | 14840 | Hernando Money M000854 | sen | MS | 1905-12-04 | 1911-03-03 | 1 | Democrat | |||||||||||||
14844 | 14844 | Edward Morrell M000965 | rep | PA | 1905-12-04 | 1907-03-03 | Republican | 5 | |||||||||||||
14847 | 14847 | Robert Nevin N000057 | rep | OH | 1905-12-04 | 1907-03-03 | Republican | 3 | |||||||||||||
14853 | 14853 | Theobald Otjen O000132 | rep | WI | 1905-12-04 | 1907-03-03 | Republican | 4 | |||||||||||||
14856 | 14856 | George Patterson P000115 | rep | PA | 1905-12-04 | 1907-03-03 | Republican | 12 | |||||||||||||
14858 | 14858 | Gilbert Patterson P000117 | rep | NC | 1905-12-04 | 1907-03-03 | Democrat | 6 | |||||||||||||
14861 | 14861 | Malcolm Patterson P000126 | rep | TN | 1905-12-04 | 1907-03-03 | Democrat | 10 | |||||||||||||
14862 | 14862 | Samuel Piles P000351 | sen | WA | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14864 | 14864 | John Pinckney P000356 | rep | TX | 1905-12-04 | 1907-03-03 | Democrat | 8 | |||||||||||||
14868 | 14868 | Redfield Proctor P000547 | sen | VT | 1905-12-04 | 1909-03-03 | 1 | Republican | |||||||||||||
14869 | 14869 | James Richardson R000223 | rep | KY | 1905-12-04 | 1907-03-03 | Democrat | 3 | |||||||||||||
14870 | 14870 | Zeno Rives R000286 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 21 | |||||||||||||
14880 | 14880 | Samuel Robertson R000324 | rep | LA | 1905-12-04 | 1907-03-03 | Democrat | 6 | |||||||||||||
14884 | 14884 | Jacob Ruppert R000513 | rep | NY | 1905-12-04 | 1907-03-03 | Democrat | 16 | |||||||||||||
14885 | 14885 | Edmund Samuel S000027 | rep | PA | 1905-12-04 | 1907-03-03 | Republican | 16 | |||||||||||||
14886 | 14886 | Gustav Schneebeli S000134 | rep | PA | 1905-12-04 | 1907-03-03 | Republican | 26 | |||||||||||||
14888 | 14888 | Nathan Scott S000182 | sen | WV | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
14889 | 14889 | Thomas Scroggy S000195 | rep | OH | 1905-12-04 | 1907-03-03 | Republican | 6 | |||||||||||||
14890 | 14890 | Cassius Shartel S000299 | rep | MO | 1905-12-04 | 1907-03-03 | Republican | 15 | |||||||||||||
14895 | 14895 | Joseph Sibley S000398 | rep | PA | 1905-12-04 | 1907-03-03 | Republican | 28 | |||||||||||||
14900 | 14900 | David Smith S000525 | rep | KY | 1905-12-04 | 1907-03-03 | Democrat | 4 | |||||||||||||
14901 | 14901 | Thomas Smith S000618 | rep | MD | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
14903 | 14903 | William Smith S000635 | rep | PA | 1905-12-04 | 1907-03-03 | Republican | 27 | |||||||||||||
14905 | 14905 | Martin Smyser S000645 | rep | OH | 1905-12-04 | 1907-03-03 | Republican | 17 | |||||||||||||
14907 | 14907 | Robert Southall S000684 | rep | VA | 1905-12-04 | 1907-03-03 | Democrat | 4 | |||||||||||||
14913 | 14913 | James Southard S000687 | rep | OH | 1905-12-04 | 1907-03-03 | Republican | 9 |
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);