legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
486 rows where "end" is on date 1935-01-03 sorted by rowid descending
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23976 | 23976 | Andrew May M000272 | rep | KY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
23968 | 23968 | Paul Maloney M000091 | rep | LA | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
23953 | 23953 | Fritz Lanham L000076 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 12 | |||||||||||||
23939 | 23939 | Herman Kopplemann K000315 | rep | CT | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
23932 | 23932 | John Kinzer K000231 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 10 | |||||||||||||
23924 | 23924 | Edward Kelly K000071 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
23916 | 23916 | Luther Johnson J000159 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
23904 | 23904 | Jed Johnson J000150 | rep | OK | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
23883 | 23883 | Pehr Holmes H000741 | rep | MA | 1933-03-09 | 1935-01-03 | Republican | 4 | |||||||||||||
23858 | 23858 | Clarence Hancock H000146 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 35 | |||||||||||||
23831 | 23831 | Samuel Dickstein D000335 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 12 | |||||||||||||
23807 | 23807 | John Cochran C000565 | rep | MO | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
23721 | 23721 | Allen Treadway T000358 | rep | MA | 1933-03-09 | 1935-01-03 | Republican | 1 | |||||||||||||
23696 | 23696 | Henry Steagall S000820 | rep | AL | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
23675 | 23675 | Joseph Smith S000580 | rep | WV | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
23667 | 23667 | Leonard Schuetz S000144 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
23598 | 23598 | Donald McLean M000545 | rep | NJ | 1933-03-09 | 1935-01-03 | Republican | 6 | |||||||||||||
23579 | 23579 | Lawrence Lewis L000291 | rep | CO | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
23573 | 23573 | William Lambertson L000037 | rep | KS | 1933-03-09 | 1935-01-03 | Republican | 1 | |||||||||||||
23565 | 23565 | Richard Kleberg K000257 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 14 | |||||||||||||
23558 | 23558 | Martin Kennedy K000111 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 18 | |||||||||||||
23540 | 23540 | Ulysses Guyer G000538 | rep | KS | 1933-03-09 | 1935-01-03 | Republican | 2 | |||||||||||||
23530 | 23530 | Robert Green G000415 | rep | FL | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
23506 | 23506 | Fred Gilchrist G000181 | rep | IA | 1933-03-09 | 1935-01-03 | Republican | 8 | |||||||||||||
23499 | 23499 | Joseph Gavagan G000101 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 21 | |||||||||||||
23487 | 23487 | Hampton Fulmer F000417 | rep | SC | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
23475 | 23475 | Thomas Ford F000267 | rep | CA | 1933-03-09 | 1935-01-03 | Democrat | 14 | |||||||||||||
23469 | 23469 | James Fitzpatrick F000175 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 24 | |||||||||||||
23460 | 23460 | Hamilton Fish F000142 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 26 | |||||||||||||
23445 | 23445 | Harry Englebright E000182 | rep | CA | 1933-03-09 | 1935-01-03 | Republican | 2 | |||||||||||||
23425 | 23425 | John Ditter D000363 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 17 | |||||||||||||
23419 | 23419 | Wesley Disney D000362 | rep | OK | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
23412 | 23412 | Anthony Dimond D000353 | rep | AK | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
23401 | 23401 | Thomas Cullen C000970 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
23388 | 23388 | Francis Culkin C000968 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 32 | |||||||||||||
23366 | 23366 | Albert Carter C000195 | rep | CA | 1933-03-09 | 1935-01-03 | Republican | 6 | |||||||||||||
23333 | 23333 | James Scrugham S000196 | rep | NV | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
23324 | 23324 | Clyde Williams W000494 | rep | MO | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
23319 | 23319 | Burton Wheeler W000330 | sen | MT | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
23315 | 23315 | David Walsh W000097 | sen | MA | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
23305 | 23305 | George Tinkham T000283 | rep | MA | 1933-03-09 | 1935-01-03 | Republican | 10 | |||||||||||||
23289 | 23289 | David Terry T000133 | rep | AR | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
23282 | 23282 | Edward Taylor T000072 | rep | CO | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
23265 | 23265 | Martin Sweeney S001102 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 20 | |||||||||||||
23259 | 23259 | William Sutphin S001086 | rep | NJ | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
23248 | 23248 | Martin Smith S000591 | rep | WA | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
23239 | 23239 | Henrik Shipstead S000369 | sen | MN | 1929-04-15 | 1935-01-03 | 1 | Farmer-Labor | |||||||||||||
23233 | 23233 | Joseph Shannon S000287 | rep | MO | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
23221 | 23221 | William Schulte S000145 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
23216 | 23216 | Edwin Schaefer S000110 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 22 | |||||||||||||
23213 | 23213 | Jared Sanders S000036 | rep | LA | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
23201 | 23201 | Milton Romjue R000418 | rep | MO | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
23189 | 23189 | Will Rogers R000405 | rep | OK | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
23176 | 23176 | Walter Pierce P000339 | rep | OR | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
23150 | 23150 | Orrice Murdock M001082 | rep | UT | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
23135 | 23135 | James Mead M000615 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 42 | |||||||||||||
23110 | 23110 | Francis Maloney M000088 | rep | CT | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
23098 | 23098 | William Larrabee L000100 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 11 | |||||||||||||
23094 | 23094 | Robert La Follette L000005 | sen | WI | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
23088 | 23088 | Charles Kramer K000321 | rep | CA | 1933-03-09 | 1935-01-03 | Democrat | 13 | |||||||||||||
23083 | 23083 | Leo Kocialkowski K000303 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
23074 | 23074 | Hiram Johnson J000140 | sen | CA | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
23067 | 23067 | George Johnson J000132 | rep | WV | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
23051 | 23051 | Lawrence Imhoff I000010 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 18 | |||||||||||||
23037 | 23037 | Knute Hill H000600 | rep | WA | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
23032 | 23032 | Arthur Healey H000423 | rep | MA | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
23027 | 23027 | Dow Harter H000294 | rep | OH | 1933-03-09 | 1935-01-03 | Democrat | 14 | |||||||||||||
23020 | 23020 | Harry Haines H000026 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 22 | |||||||||||||
22985 | 22985 | Charles Faddis F000001 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 25 | |||||||||||||
22977 | 22977 | Andrew Edmiston E000051 | rep | WV | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
22970 | 22970 | Richard Duncan D000536 | rep | MO | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
22965 | 22965 | Wall Doxey D000480 | rep | MS | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
22957 | 22957 | Colgate Darden D000050 | rep | VA | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
22952 | 22952 | Frank Crowther C000948 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 30 | |||||||||||||
22937 | 22937 | Ross Collins C000642 | rep | MS | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
22926 | 22926 | William Cole C000616 | rep | MD | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
22905 | 22905 | Wilburn Cartwright C000207 | rep | OK | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
22889 | 22889 | Frank Buck B001017 | rep | CA | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
22881 | 22881 | Patrick Boland B000601 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 11 | |||||||||||||
22875 | 22875 | John Boehne B000588 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
22867 | 22867 | Alfred Beiter B000320 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 41 | |||||||||||||
22862 | 22862 | Harry Beam B000274 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
22852 | 22852 | Warren Austin A000342 | sen | VT | 1931-12-07 | 1935-01-03 | 1 | Republican | |||||||||||||
22841 | 22841 | Monrad Wallgren W000088 | rep | WA | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
22836 | 22836 | Reuben Wood W000702 | rep | MO | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
22828 | 22828 | Lindsay Warren W000166 | rep | NC | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
22818 | 22818 | Clarence Turner T000417 | rep | TN | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
22812 | 22812 | James Taylor T000083 | rep | TN | 1933-03-09 | 1935-01-03 | Republican | 2 | |||||||||||||
22800 | 22800 | Christopher Sullivan S001051 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 13 | |||||||||||||
22778 | 22778 | William Sirovich S000452 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 14 | |||||||||||||
22771 | 22771 | George Seger S000228 | rep | NJ | 1933-03-09 | 1935-01-03 | Republican | 8 | |||||||||||||
22744 | 22744 | Claude Parsons P000086 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 24 | |||||||||||||
22738 | 22738 | Emmett Owen O000149 | rep | GA | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
22728 | 22728 | Samuel McReynolds M000598 | rep | TN | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
22719 | 22719 | Thomas McMillan M000572 | rep | SC | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
22711 | 22711 | Clarence McLeod M000557 | rep | MI | 1933-03-09 | 1935-01-03 | Republican | 13 | |||||||||||||
22691 | 22691 | John Martin M000186 | rep | CO | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
22684 | 22684 | Carl Mapes M000119 | rep | MI | 1933-03-09 | 1935-01-03 | Republican | 5 | |||||||||||||
22671 | 22671 | Robert Luce L000498 | rep | MA | 1933-03-09 | 1935-01-03 | Republican | 9 | |||||||||||||
22655 | 22655 | Ambrose Kennedy K000101 | rep | MD | 1933-03-09 | 1935-01-03 | Democrat | 4 |
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);