legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
446 rows where "end" is on date 1909-03-03 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: state, class, district, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25454 | 25454 | Adolph Sabath S000001 | rep | IL | 1907-12-02 | 1909-03-03 | Democrat | 5 | |||||||||||||
23515 | 23515 | Carter Glass G000232 | rep | VA | 1907-12-02 | 1909-03-03 | Democrat | 6 | |||||||||||||
22526 | 22526 | William Cravens C000886 | rep | AR | 1907-12-02 | 1909-03-03 | Democrat | 4 | |||||||||||||
22476 | 22476 | William Ashbrook A000306 | rep | OH | 1907-12-02 | 1909-03-03 | Democrat | 17 | |||||||||||||
22406 | 22406 | Morris Sheppard S000337 | rep | TX | 1907-12-02 | 1909-03-03 | Democrat | 1 | |||||||||||||
22332 | 22332 | George Norris N000139 | rep | NE | 1907-12-02 | 1909-03-03 | Republican | 5 | |||||||||||||
22143 | 22143 | Benjamin Focht F000230 | rep | PA | 1907-12-02 | 1909-03-03 | Republican | 17 | |||||||||||||
21513 | 21513 | Henry Rainey R000014 | rep | IL | 1907-12-02 | 1909-03-03 | Democrat | 20 | |||||||||||||
21485 | 21485 | Edward Pou P000474 | rep | NC | 1907-12-02 | 1909-03-03 | Democrat | 4 | |||||||||||||
21283 | 21283 | John Garner G000074 | rep | TX | 1907-12-02 | 1909-03-03 | Democrat | 15 | |||||||||||||
20874 | 20874 | William Stafford S000777 | rep | WI | 1907-12-02 | 1909-03-03 | Republican | 5 | |||||||||||||
20809 | 20809 | Joseph Robinson R000347 | rep | AR | 1907-12-02 | 1909-03-03 | Democrat | 6 | |||||||||||||
20747 | 20747 | John Nelson N000039 | rep | WI | 1907-12-02 | 1909-03-03 | Republican | 2 | |||||||||||||
20697 | 20697 | James McLaughlin M000539 | rep | MI | 1907-12-02 | 1909-03-03 | Republican | 9 | |||||||||||||
20666 | 20666 | Nicholas Longworth L000433 | rep | OH | 1907-12-02 | 1909-03-03 | Republican | 1 | |||||||||||||
20539 | 20539 | Cordell Hull H000940 | rep | TN | 1907-12-02 | 1909-03-03 | Democrat | 4 | |||||||||||||
20497 | 20497 | Willis Hawley H000379 | rep | OR | 1907-12-02 | 1909-03-03 | Republican | 1 | |||||||||||||
20484 | 20484 | Gilbert Haugen H000350 | rep | IA | 1907-12-02 | 1909-03-03 | Republican | 4 | |||||||||||||
20430 | 20430 | Thomas Gore G000323 | sen | OK | 1907-12-02 | 1909-03-03 | 3 | Democrat | |||||||||||||
20389 | 20389 | Burton French F000375 | rep | ID | 1907-12-02 | 1909-03-03 | Republican | 1 | |||||||||||||
20340 | 20340 | Charles Edwards E000062 | rep | GA | 1907-12-02 | 1909-03-03 | Democrat | 1 | |||||||||||||
20238 | 20238 | Henry Cooper C000752 | rep | WI | 1907-12-02 | 1909-03-03 | Republican | 1 | |||||||||||||
19787 | 19787 | James Hughes H000924 | rep | WV | 1907-12-02 | 1909-03-03 | Republican | 5 | |||||||||||||
19685 | 19685 | Edgar Ellis E000133 | rep | MO | 1907-12-02 | 1909-03-03 | Republican | 5 | |||||||||||||
19575 | 19575 | Thomas Bell B000348 | rep | GA | 1907-12-02 | 1909-03-03 | Democrat | 9 | |||||||||||||
19562 | 19562 | Theodore Burton B001159 | rep | OH | 1907-12-02 | 1909-03-03 | Republican | 21 | |||||||||||||
19535 | 19535 | James Watson W000203 | rep | IN | 1907-12-02 | 1909-03-03 | Republican | 6 | |||||||||||||
19488 | 19488 | Reed Smoot S000644 | sen | UT | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
19455 | 19455 | Lee Overman O000140 | sen | NC | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
19407 | 19407 | Martin Madden M000038 | rep | IL | 1907-12-02 | 1909-03-03 | Republican | 1 | |||||||||||||
19366 | 19366 | Wesley Jones J000257 | rep | WA | 1907-12-02 | 1909-03-03 | Republican | -1 | |||||||||||||
19320 | 19320 | Finis Garrett G000082 | rep | TN | 1907-12-02 | 1909-03-03 | Democrat | 9 | |||||||||||||
19245 | 19245 | Thomas Butler B001192 | rep | PA | 1907-12-02 | 1909-03-03 | Republican | 7 | |||||||||||||
19187 | 19187 | Daniel Anthony A000261 | rep | KS | 1907-12-02 | 1909-03-03 | Republican | 1 | |||||||||||||
19169 | 19169 | Harry Woodyard W000737 | rep | WV | 1907-12-02 | 1909-03-03 | Republican | 4 | |||||||||||||
19075 | 19075 | Joseph Ransdell R000059 | rep | LA | 1907-12-02 | 1909-03-03 | Democrat | 5 | |||||||||||||
19021 | 19021 | Gordon Lee L000194 | rep | GA | 1907-12-02 | 1909-03-03 | Democrat | 7 | |||||||||||||
19010 | 19010 | John Langley L000072 | rep | KY | 1907-12-02 | 1909-03-03 | Republican | 10 | |||||||||||||
18995 | 18995 | Ben Johnson J000118 | rep | KY | 1907-12-02 | 1909-03-03 | Democrat | 4 | |||||||||||||
18981 | 18981 | James Heflin H000446 | rep | AL | 1907-12-02 | 1909-03-03 | Democrat | 5 | |||||||||||||
18966 | 18966 | Frederick Gillett G000201 | rep | MA | 1907-12-02 | 1909-03-03 | Republican | 2 | |||||||||||||
18947 | 18947 | Charles Fuller F000407 | rep | IL | 1907-12-02 | 1909-03-03 | Republican | 12 | |||||||||||||
18916 | 18916 | Charles Carter C000196 | rep | OK | 1907-12-02 | 1909-03-03 | Democrat | 4 | |||||||||||||
18840 | 18840 | Isaac Sherwood S000355 | rep | OH | 1907-12-02 | 1909-03-03 | Democrat | 9 | |||||||||||||
18820 | 18820 | Daniel Riordan R000264 | rep | NY | 1907-12-02 | 1909-03-03 | Democrat | 8 | |||||||||||||
18711 | 18711 | Claude Kitchin K000250 | rep | NC | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
18699 | 18699 | Julius Kahn K000003 | rep | CA | 1907-12-02 | 1909-03-03 | Republican | 4 | |||||||||||||
18683 | 18683 | Benjamin Humphreys H000960 | rep | MS | 1907-12-02 | 1909-03-03 | Democrat | 3 | |||||||||||||
18665 | 18665 | William Greene G000430 | rep | MA | 1907-12-02 | 1909-03-03 | Republican | 13 | |||||||||||||
18637 | 18637 | George Favrot F000048 | rep | LA | 1907-12-02 | 1909-03-03 | Democrat | 6 | |||||||||||||
18609 | 18609 | Charles Davis D000093 | rep | MN | 1907-12-02 | 1909-03-03 | Republican | 3 | |||||||||||||
18598 | 18598 | William Cockran C000575 | rep | NY | 1907-12-02 | 1909-03-03 | Democrat | 12 | |||||||||||||
18584 | 18584 | Frank Clark C000430 | rep | FL | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
18540 | 18540 | Andrew Volstead V000114 | rep | MN | 1907-12-02 | 1909-03-03 | Republican | 7 | |||||||||||||
18530 | 18530 | Oscar Underwood U000013 | rep | AL | 1907-12-02 | 1909-03-03 | Democrat | 9 | |||||||||||||
18496 | 18496 | Halvor Steenerson S000842 | rep | MN | 1907-12-02 | 1909-03-03 | Republican | 9 | |||||||||||||
18483 | 18483 | Campbell Slemp S000486 | rep | VA | 1907-12-02 | 1909-03-03 | Republican | 9 | |||||||||||||
18460 | 18460 | William Rucker R000494 | rep | MO | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
18445 | 18445 | William Rodenberg R000371 | rep | IL | 1907-12-02 | 1909-03-03 | Republican | 22 | |||||||||||||
18407 | 18407 | Richard Parker P000070 | rep | NJ | 1907-12-02 | 1909-03-03 | Republican | 7 | |||||||||||||
18393 | 18393 | Lemuel Padgett P000012 | rep | TN | 1907-12-02 | 1909-03-03 | Democrat | 7 | |||||||||||||
18364 | 18364 | Franklin Mondell M000852 | rep | WY | 1907-12-02 | 1909-03-03 | Republican | 0 | |||||||||||||
18347 | 18347 | William McKinley M000521 | rep | IL | 1907-12-02 | 1909-03-03 | Republican | 19 | |||||||||||||
18327 | 18327 | James Mann M000104 | rep | IL | 1907-12-02 | 1909-03-03 | Republican | 2 | |||||||||||||
18279 | 18279 | Moses Kinkaid K000221 | rep | NE | 1907-12-02 | 1909-03-03 | Republican | 6 | |||||||||||||
18259 | 18259 | Jonah Kalanianaole K000004 | rep | HI | 1907-12-02 | 1909-03-03 | Republican | -1 | |||||||||||||
18207 | 18207 | Rufus Hardy H000198 | rep | TX | 1907-12-02 | 1909-03-03 | Democrat | 6 | |||||||||||||
18182 | 18182 | Joseph Fordney F000271 | rep | MI | 1907-12-02 | 1909-03-03 | Republican | 8 | |||||||||||||
18170 | 18170 | Henry Flood F000210 | rep | VA | 1907-12-02 | 1909-03-03 | Democrat | 10 | |||||||||||||
18149 | 18149 | William Dillingham D000347 | sen | VT | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
18141 | 18141 | Albert Cummins C000988 | sen | IA | 1908-11-24 | 1909-03-03 | 3 | Republican | |||||||||||||
18109 | 18109 | Joseph Cannon C000121 | rep | IL | 1907-12-02 | 1909-03-03 | Republican | 18 | |||||||||||||
18085 | 18085 | Philip Campbell C000097 | rep | KS | 1907-12-02 | 1909-03-03 | Republican | 3 | |||||||||||||
18062 | 18062 | Frank Brandegee B000769 | sen | CT | 1905-05-10 | 1909-03-03 | 3 | Republican | |||||||||||||
18018 | 18018 | William Wilson W000624 | rep | IL | 1907-12-02 | 1909-03-03 | Republican | 3 | |||||||||||||
17998 | 17998 | Edwin Webb W000231 | rep | NC | 1907-12-02 | 1909-03-03 | Democrat | 9 | |||||||||||||
17985 | 17985 | John Watkins W000193 | rep | LA | 1907-12-02 | 1909-03-03 | Democrat | 4 | |||||||||||||
17960 | 17960 | Augustus Stanley S000796 | rep | KY | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
17949 | 17949 | John Small S000500 | rep | NC | 1907-12-02 | 1909-03-03 | Democrat | 1 | |||||||||||||
17938 | 17938 | Thetus Sims S000441 | rep | TN | 1907-12-02 | 1909-03-03 | Democrat | 8 | |||||||||||||
17914 | 17914 | Edward Saunders S000077 | rep | VA | 1907-12-02 | 1909-03-03 | Democrat | 5 | |||||||||||||
17847 | 17847 | Joseph Moore M000906 | rep | PA | 1907-12-02 | 1909-03-03 | Republican | 3 | |||||||||||||
17839 | 17839 | John Moon M000884 | rep | TN | 1907-12-02 | 1909-03-03 | Democrat | 3 | |||||||||||||
17811 | 17811 | Asbury Lever L000259 | rep | SC | 1907-12-02 | 1909-03-03 | Democrat | 7 | |||||||||||||
17790 | 17790 | Charles Kennedy K000104 | rep | IA | 1907-12-02 | 1909-03-03 | Republican | 1 | |||||||||||||
17765 | 17765 | Harvey Helm H000461 | rep | KY | 1907-12-02 | 1909-03-03 | Democrat | 8 | |||||||||||||
17755 | 17755 | Edward Hamilton H000108 | rep | MI | 1907-12-02 | 1909-03-03 | Republican | 4 | |||||||||||||
17743 | 17743 | James Hamill H000099 | rep | NJ | 1907-12-02 | 1909-03-03 | Democrat | 10 | |||||||||||||
17730 | 17730 | Henry Goldfogle G000260 | rep | NY | 1907-12-02 | 1909-03-03 | Democrat | 9 | |||||||||||||
17720 | 17720 | Hannibal Godwin G000250 | rep | NC | 1907-12-02 | 1909-03-03 | Democrat | 6 | |||||||||||||
17691 | 17691 | Scott Ferris F000091 | rep | OK | 1907-12-02 | 1909-03-03 | Democrat | 5 | |||||||||||||
17675 | 17675 | Albert Estopinal E000224 | rep | LA | 1907-12-02 | 1909-03-03 | Democrat | 1 | |||||||||||||
17668 | 17668 | John Esch E000212 | rep | WI | 1907-12-02 | 1909-03-03 | Republican | 7 | |||||||||||||
17617 | 17617 | James Clark C000437 | rep | MO | 1907-12-02 | 1909-03-03 | Democrat | 9 | |||||||||||||
17604 | 17604 | Charles Carlin C000151 | rep | VA | 1907-12-02 | 1909-03-03 | Democrat | 8 | |||||||||||||
17597 | 17597 | Ezekiel Candler C000110 | rep | MS | 1907-12-02 | 1909-03-03 | Democrat | 1 | |||||||||||||
17584 | 17584 | John Burnett B001121 | rep | AL | 1907-12-02 | 1909-03-03 | Democrat | 7 | |||||||||||||
17564 | 17564 | Charles Booher B000626 | rep | MO | 1907-12-02 | 1909-03-03 | Democrat | 4 | |||||||||||||
17532 | 17532 | Joshua Alexander A000098 | rep | MO | 1907-12-02 | 1909-03-03 | Democrat | 3 | |||||||||||||
17511 | 17511 | John Williams W000521 | rep | MS | 1907-12-02 | 1909-03-03 | Democrat | 8 |
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);