legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
452 rows where "end" is on date 1927-03-04 and start = "1925-12-07" sorted by district
This data as json, copyable, CSV (advanced)
Suggested facets: party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18941 | 18941 | Bert Fernald F000084 | sen | ME | 1925-12-07 | 1927-03-04 | 2 | Republican | |||||||||||||
19166 | 19166 | George Williams W000499 | sen | MO | 1925-12-07 | 1927-03-04 | 3 | Republican | appointment | ||||||||||||
19235 | 19235 | Smith Brookhart B000873 | sen | IA | 1925-12-07 | 1927-03-04 | 2 | Republican | |||||||||||||
22734 | 22734 | Gerald Nye N000176 | sen | ND | 1925-12-07 | 1927-03-04 | 3 | Republican | appointment | ||||||||||||
18994 | 18994 | William Jarrett J000061 | rep | HI | 1925-12-07 | 1927-03-04 | Democrat | -1 | |||||||||||||
19019 | 19019 | John Langley L000072 | rep | KY | 1925-12-07 | 1927-03-04 | Republican | -1 | |||||||||||||
19465 | 19465 | Henry Rathbone R000068 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | -1 | |||||||||||||
21054 | 21054 | Richard Yates Y000011 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | -1 | |||||||||||||
19553 | 19553 | Charles Winter W000643 | rep | WY | 1925-12-07 | 1927-03-04 | Republican | 0 | |||||||||||||
19721 | 19721 | Isauro Gabaldon G000001 | rep | PI | 1925-12-07 | 1927-03-04 | 0 | ||||||||||||||
20004 | 20004 | Daniel Sutherland S001079 | rep | AK | 1925-12-07 | 1927-03-04 | Republican | 0 | |||||||||||||
20094 | 20094 | Samuel Arentz A000277 | rep | NV | 1925-12-07 | 1927-03-04 | Republican | 0 | |||||||||||||
20334 | 20334 | Félix Dávila D000090 | rep | PR | 1925-12-07 | 1927-03-04 | Unionist | 0 | |||||||||||||
20532 | 20532 | Robert Houston H000826 | rep | DE | 1925-12-07 | 1927-03-04 | Republican | 0 | |||||||||||||
21791 | 21791 | Pedro Guevara G000518 | rep | PI | 1925-12-07 | 1927-03-04 | 0 | ||||||||||||||
27850 | 27850 | Carl Hayden H000385 | rep | AZ | 1925-12-07 | 1927-03-04 | Democrat | 0 | |||||||||||||
19045 | 19045 | Samuel Montgomery M000870 | rep | OK | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
19053 | 19053 | Francis Patterson P000114 | rep | NJ | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
19113 | 19113 | John Sosnowski S000680 | rep | MI | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
19196 | 19196 | Daniel Anthony A000261 | rep | KS | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
19219 | 19219 | Eugene Black B000495 | rep | TX | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
19306 | 19306 | Allen Furlow F000433 | rep | MN | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
19416 | 19416 | Martin Madden M000038 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
19437 | 19437 | John Morrow M001004 | rep | NM | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
19516 | 19516 | William Vaile V000004 | rep | CO | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
19525 | 19525 | William Vare V000071 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
19594 | 19594 | Elbert Brigham B000832 | rep | VT | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
19693 | 19693 | Edward Fenn F000072 | rep | CT | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
19883 | 19883 | John Miller M000739 | rep | WA | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
19916 | 19916 | James O’Connor O000028 | rep | LA | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
19946 | 19946 | Harry Rowbottom R000474 | rep | IN | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
20108 | 20108 | Carl Bachmann B000012 | rep | WV | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
20140 | 20140 | Clark Burdick B001075 | rep | RI | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
20146 | 20146 | Olger Burtness B001146 | rep | ND | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
20190 | 20190 | Charles Christopherson C000384 | rep | SD | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
20224 | 20224 | Don Colton C000652 | rep | UT | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
20246 | 20246 | Henry Cooper C000752 | rep | WI | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
20315 | 20315 | Herbert Drane D000486 | rep | FL | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
20345 | 20345 | Charles Edwards E000062 | rep | GA | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
20364 | 20364 | John Evans E000247 | rep | MT | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
20396 | 20396 | Burton French F000375 | rep | ID | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
20454 | 20454 | Fletcher Hale H000030 | rep | NH | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
20506 | 20506 | Willis Hawley H000379 | rep | OR | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
20610 | 20610 | William Kopp K000314 | rep | IA | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
20674 | 20674 | Nicholas Longworth L000433 | rep | OH | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
21114 | 21114 | Carroll Beedy B000307 | rep | ME | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
21439 | 21439 | John Morehead M000939 | rep | NE | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
21866 | 21866 | John McDuffie M000427 | rep | AL | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
22028 | 22028 | Robert Bacon B000019 | rep | NY | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
22119 | 22119 | William Driver D000503 | rep | AR | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
22615 | 22615 | Thomas Goldsborough G000265 | rep | MD | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
22715 | 22715 | Thomas McMillan M000572 | rep | SC | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
22824 | 22824 | Lindsay Warren W000166 | rep | NC | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
23197 | 23197 | Milton Romjue R000418 | rep | MO | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
23717 | 23717 | Allen Treadway T000358 | rep | MA | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
24539 | 24539 | Clarence Lea L000163 | rep | CA | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
24746 | 24746 | Schuyler Bland B000545 | rep | VA | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
25435 | 25435 | John Rankin R000056 | rep | MS | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
25873 | 25873 | Alben Barkley B000145 | rep | KY | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
27461 | 27461 | Brazilla Reece R000108 | rep | TN | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
18926 | 18926 | George Churchill C000391 | rep | MA | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
19034 | 19034 | Chauncey Little L000348 | rep | KS | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
19070 | 19070 | John Raker R000019 | rep | CA | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
19145 | 19145 | Edward Voigt V000110 | rep | WI | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
19227 | 19227 | Henry Bowles B000700 | rep | MA | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
19293 | 19293 | Joseph Deal D000169 | rep | VA | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
19376 | 19376 | John Kindred K000191 | rep | NY | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
19395 | 19395 | Bill Lowrey L000484 | rep | MS | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
19453 | 19453 | William Oldfield O000062 | rep | AR | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
19486 | 19486 | Nicholas Sinnott S000450 | rep | OR | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
19496 | 19496 | Ambrose Stephens S000855 | rep | OH | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
19591 | 19591 | John Box B000710 | rep | TX | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
19830 | 19830 | David Kincheloe K000187 | rep | KY | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
19850 | 19850 | Elmer Leatherwood L000181 | rep | UT | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
19854 | 19854 | Fred Letts L000258 | rep | IA | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
19950 | 19950 | Willis Sears S000212 | rep | NE | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
19966 | 19966 | James Spearing S000708 | rep | LA | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
20085 | 20085 | Richard Aldrich A000084 | rep | RI | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20196 | 20196 | Frank Clague C000401 | rep | MN | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20383 | 20383 | Richard Freeman F000366 | rep | CT | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20440 | 20440 | George Graham G000354 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20450 | 20450 | Lindley Hadley H000008 | rep | WA | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20464 | 20464 | Thomas Hall H000071 | rep | ND | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20552 | 20552 | Morton Hull H000944 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20580 | 20580 | Royal Johnson J000173 | rep | SD | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20645 | 20645 | Scott Leavitt L000184 | rep | MT | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20864 | 20864 | Addison Smith S000511 | rep | ID | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20948 | 20948 | Charles Timberlake T000281 | rep | CO | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20990 | 20990 | Edward Wason W000185 | rep | NH | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
21128 | 21128 | Frank Bowman B000704 | rep | WV | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
21310 | 21310 | William Hastings H000333 | rep | OK | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
21385 | 21385 | Ralph Lozier L000489 | rep | MO | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
21634 | 21634 | Isaac Bacharach B000009 | rep | NJ | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
22195 | 22195 | Arthur Greenwood G000437 | rep | IN | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
22607 | 22607 | Ernest Gibson G000158 | rep | VT | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
22808 | 22808 | James Taylor T000083 | rep | TN | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
23441 | 23441 | Harry Englebright E000182 | rep | CA | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
23526 | 23526 | Robert Green G000415 | rep | FL | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
23751 | 23751 | Wallace White W000396 | rep | ME | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
23865 | 23865 | Butler Hare H000200 | rep | SC | 1925-12-07 | 1927-03-04 | Democrat | 2 |
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);