legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
494 rows where "end" is on date 1915-03-03 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28203 | 28203 | Carl Vinson V000105 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 10 | |||||||||||||
27844 | 27844 | Carl Hayden H000385 | rep | AZ | 1913-04-07 | 1915-03-03 | Democrat | 0 | |||||||||||||
27434 | 27434 | Samuel Rayburn R000082 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
26063 | 26063 | Matthew Neely N000023 | rep | WV | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
25867 | 25867 | Alben Barkley B000145 | rep | KY | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
25639 | 25639 | Robert Crosser C000932 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
25552 | 25552 | Roy Woodruff W000718 | rep | MI | 1913-04-07 | 1915-03-03 | Progressive | 10 | |||||||||||||
25457 | 25457 | Adolph Sabath S000001 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
25214 | 25214 | Robert Doughton D000448 | rep | NC | 1913-04-07 | 1915-03-03 | Democrat | 8 | |||||||||||||
24605 | 24605 | Kenneth McKellar M000499 | rep | TN | 1913-04-07 | 1915-03-03 | Democrat | 10 | |||||||||||||
24113 | 24113 | Hatton Sumners S001072 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
23820 | 23820 | James Curley C000996 | rep | MA | 1913-04-07 | 1915-03-03 | Democrat | 12 | |||||||||||||
23711 | 23711 | Allen Treadway T000358 | rep | MA | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
23518 | 23518 | Carter Glass G000232 | rep | VA | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
23272 | 23272 | Edward Taylor T000072 | rep | CO | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
23010 | 23010 | Peter Gerry G000141 | rep | RI | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
22785 | 22785 | Ellison Smith S000530 | sen | SC | 1909-03-15 | 1915-03-03 | 3 | Democrat | |||||||||||||
22698 | 22698 | James McAndrews M000296 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
22674 | 22674 | Carl Mapes M000119 | rep | MI | 1913-04-07 | 1915-03-03 | Republican | 5 | |||||||||||||
22479 | 22479 | William Ashbrook A000306 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 17 | |||||||||||||
22376 | 22376 | Michael Reilly R000155 | rep | WI | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
22316 | 22316 | Andrew Montague M000861 | rep | VA | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
22269 | 22269 | David Lewis L000277 | rep | MD | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
22232 | 22232 | Robert Hill H000606 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 25 | |||||||||||||
22219 | 22219 | Byron Harrison H000265 | rep | MS | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
22187 | 22187 | Finly Gray G000395 | rep | IN | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
22078 | 22078 | James Byrnes B001215 | rep | SC | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
22062 | 22062 | James Buchanan B001006 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 10 | |||||||||||||
21752 | 21752 | Joe Eagle E000003 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 8 | |||||||||||||
21672 | 21672 | Joseph Byrns B001217 | rep | TN | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
21516 | 21516 | Henry Rainey R000014 | rep | IL | 1913-04-07 | 1915-03-03 | Democrat | 20 | |||||||||||||
21488 | 21488 | Edward Pou P000474 | rep | NC | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
21464 | 21464 | James Parker P000062 | rep | NY | 1913-04-07 | 1915-03-03 | Republican | 29 | |||||||||||||
21379 | 21379 | Augustine Lonergan L000409 | rep | CT | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
21350 | 21350 | Melville Kelly K000076 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 30 | |||||||||||||
21286 | 21286 | John Garner G000074 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | 15 | |||||||||||||
21270 | 21270 | James Frear F000355 | rep | WI | 1913-04-07 | 1915-03-03 | Republican | 10 | |||||||||||||
21259 | 21259 | Duncan Fletcher F000200 | sen | FL | 1909-03-15 | 1915-03-03 | 3 | Democrat | |||||||||||||
21243 | 21243 | George Edmonds E000053 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 4 | |||||||||||||
21225 | 21225 | Clement Dickinson D000316 | rep | MO | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
21195 | 21195 | Denver Church C000387 | rep | CA | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
21175 | 21175 | Robert Bulkley B001045 | rep | OH | 1913-04-07 | 1915-03-03 | Democrat | 21 | |||||||||||||
21150 | 21150 | Frederick Britten B000847 | rep | IL | 1913-04-07 | 1915-03-03 | Republican | 9 | |||||||||||||
21003 | 21003 | James Wickersham W000438 | rep | AK | 1913-04-07 | 1915-03-03 | Republican | 0 | |||||||||||||
20916 | 20916 | Henry Temple T000119 | rep | PA | 1913-04-07 | 1915-03-03 | Progressive | 24 | |||||||||||||
20876 | 20876 | William Stafford S000777 | rep | WI | 1913-04-07 | 1915-03-03 | Republican | 5 | |||||||||||||
20858 | 20858 | Addison Smith S000511 | rep | ID | 1913-04-07 | 1915-03-03 | Republican | -1 | |||||||||||||
20845 | 20845 | Milton Shreve S000387 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 25 | |||||||||||||
20788 | 20788 | Percy Quin Q000014 | rep | MS | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
20750 | 20750 | John Nelson N000039 | rep | WI | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
20700 | 20700 | James McLaughlin M000539 | rep | MI | 1913-04-07 | 1915-03-03 | Republican | 9 | |||||||||||||
20654 | 20654 | John Linthicum L000340 | rep | MD | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
20564 | 20564 | Albert Johnson J000114 | rep | WA | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
20542 | 20542 | Cordell Hull H000940 | rep | TN | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
20500 | 20500 | Willis Hawley H000379 | rep | OR | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
20487 | 20487 | Gilbert Haugen H000350 | rep | IA | 1913-04-07 | 1915-03-03 | Republican | 4 | |||||||||||||
20434 | 20434 | George Graham G000354 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
20431 | 20431 | Thomas Gore G000323 | sen | OK | 1909-03-15 | 1915-03-03 | 3 | Democrat | |||||||||||||
20408 | 20408 | Daniel Garrett G000081 | rep | TX | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
20391 | 20391 | Burton French F000375 | rep | ID | 1913-04-07 | 1915-03-03 | Republican | -1 | |||||||||||||
20359 | 20359 | John Evans E000247 | rep | MT | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
20343 | 20343 | Charles Edwards E000062 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
20320 | 20320 | Leonidas Dyer D000591 | rep | MO | 1913-04-07 | 1915-03-03 | Republican | 12 | |||||||||||||
20261 | 20261 | Charles Crisp C000909 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
20241 | 20241 | Henry Cooper C000752 | rep | WI | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
20212 | 20212 | James Collier C000630 | rep | MS | 1913-04-07 | 1915-03-03 | Democrat | 8 | |||||||||||||
20098 | 20098 | James Aswell A000321 | rep | LA | 1913-04-07 | 1915-03-03 | Democrat | 8 | |||||||||||||
20050 | 20050 | Otis Wingo W000635 | rep | AR | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
19991 | 19991 | Hubert Stephens S000857 | rep | MS | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
19979 | 19979 | Charles Stedman S000827 | rep | NC | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
19956 | 19956 | Charles Sloan S000491 | rep | NE | 1913-04-07 | 1915-03-03 | Republican | 4 | |||||||||||||
19925 | 19925 | Stephen Porter P000447 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 29 | |||||||||||||
19816 | 19816 | Edgar Kiess K000168 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 15 | |||||||||||||
19790 | 19790 | James Hughes H000924 | rep | WV | 1913-04-07 | 1915-03-03 | Republican | 5 | |||||||||||||
19743 | 19743 | William Griest G000456 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 9 | |||||||||||||
19734 | 19734 | Frank Greene G000425 | rep | VT | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
19696 | 19696 | Simeon Fess F000096 | rep | OH | 1913-04-07 | 1915-03-03 | Republican | 6 | |||||||||||||
19637 | 19637 | Charles Curry C001000 | rep | CA | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
19628 | 19628 | Louis Cramton C000870 | rep | MI | 1913-04-07 | 1915-03-03 | Republican | 7 | |||||||||||||
19616 | 19616 | John Casey C000223 | rep | PA | 1913-04-07 | 1915-03-03 | Democrat | 11 | |||||||||||||
19607 | 19607 | John Carew C000142 | rep | NY | 1913-04-07 | 1915-03-03 | Democrat | 17 | |||||||||||||
19598 | 19598 | Edward Browne B000955 | rep | WI | 1913-04-07 | 1915-03-03 | Republican | 8 | |||||||||||||
19578 | 19578 | Thomas Bell B000348 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 9 | |||||||||||||
19563 | 19563 | Theodore Burton B001159 | sen | OH | 1909-03-15 | 1915-03-03 | 3 | Republican | |||||||||||||
19546 | 19546 | Frank Willis W000561 | rep | OH | 1913-04-07 | 1915-03-03 | Republican | 8 | |||||||||||||
19519 | 19519 | William Vare V000071 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
19489 | 19489 | Reed Smoot S000644 | sen | UT | 1909-03-15 | 1915-03-03 | 3 | Republican | |||||||||||||
19480 | 19480 | Nicholas Sinnott S000450 | rep | OR | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
19471 | 19471 | Thomas Rubey R000491 | rep | MO | 1913-04-07 | 1915-03-03 | Democrat | 16 | |||||||||||||
19456 | 19456 | Lee Overman O000140 | sen | NC | 1909-03-15 | 1915-03-03 | 3 | Democrat | |||||||||||||
19447 | 19447 | William Oldfield O000062 | rep | AR | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
19428 | 19428 | John Morin M000961 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | -1 | |||||||||||||
19410 | 19410 | Martin Madden M000038 | rep | IL | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
19385 | 19385 | Ladislas Lazaro L000153 | rep | LA | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
19367 | 19367 | Wesley Jones J000257 | sen | WA | 1909-03-15 | 1915-03-03 | 3 | Republican | |||||||||||||
19334 | 19334 | William Green G000422 | rep | IA | 1913-04-07 | 1915-03-03 | Republican | 9 | |||||||||||||
19323 | 19323 | Finis Garrett G000082 | rep | TN | 1913-04-07 | 1915-03-03 | Democrat | 9 | |||||||||||||
19308 | 19308 | James Gallivan G000024 | rep | MA | 1913-04-07 | 1915-03-03 | Democrat | 12 | |||||||||||||
19256 | 19256 | Thaddeus Caraway C000139 | rep | AR | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
19248 | 19248 | Thomas Butler B001192 | rep | PA | 1913-04-07 | 1915-03-03 | Republican | 7 |
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);