legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
480 rows where "start" is on date 1935-01-03 sorted by rowid descending
This data as json, copyable, CSV (advanced)
end (date) 8 ✖
- 1937-01-03 446
- 1941-01-03 27
- 1939-01-03 2
- 1935-05-06 1
- 1935-08-09 1
- 1936-05-08 1
- 1936-11-18 1
- 1940-12-16 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32242 | 32242 | Jennings Randolph R000046 | rep | WV | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
31621 | 31621 | George Mahon M000065 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 19 | |||||||||||||
31255 | 31255 | John Patman P000103 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
30563 | 30563 | John McClellan M000332 | rep | AR | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
30138 | 30138 | Leslie Arends A000216 | rep | IL | 1935-01-03 | 1937-01-03 | Republican | 17 | |||||||||||||
29697 | 29697 | William Colmer C000645 | rep | MS | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
29677 | 29677 | Emanuel Celler C000264 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 10 | |||||||||||||
29368 | 29368 | John McCormack M000364 | rep | MA | 1935-01-03 | 1937-01-03 | Democrat | 12 | |||||||||||||
28860 | 28860 | Charles Halleck H000081 | rep | IN | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
28747 | 28747 | Stephen Young Y000053 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 0 | |||||||||||||
28659 | 28659 | Howard Smith S000554 | rep | VA | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
28644 | 28644 | Robert Secrest S000219 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 15 | |||||||||||||
28534 | 28534 | Joseph Martin M000191 | rep | MA | 1935-01-03 | 1937-01-03 | Republican | 14 | |||||||||||||
28374 | 28374 | Harold Cooley C000736 | rep | NC | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
28233 | 28233 | Francis Walter W000108 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 21 | |||||||||||||
28214 | 28214 | Carl Vinson V000105 | rep | GA | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
28054 | 28054 | Thomas O’Brien O000016 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
27877 | 27877 | Joseph Hill H000598 | rep | AL | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
27743 | 27743 | Everett Dirksen D000360 | rep | IL | 1935-01-03 | 1937-01-03 | Republican | 16 | |||||||||||||
27700 | 27700 | Frank Carlson C000154 | rep | KS | 1935-01-03 | 1937-01-03 | Republican | 6 | |||||||||||||
27685 | 27685 | Clarence Cannon C000117 | rep | MO | 1935-01-03 | 1937-01-03 | Democrat | 9 | |||||||||||||
27663 | 27663 | Charles Buckley B001024 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 23 | |||||||||||||
27555 | 27555 | John Taber T000001 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 36 | |||||||||||||
27535 | 27535 | Brent Spence S000717 | rep | KY | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
27488 | 27488 | Absalom Robertson R000317 | rep | VA | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
27465 | 27465 | Brazilla Reece R000108 | rep | TN | 1935-01-03 | 1937-01-03 | Republican | 1 | |||||||||||||
27445 | 27445 | Samuel Rayburn R000082 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
27416 | 27416 | Louis Rabaut R000001 | rep | MI | 1935-01-03 | 1937-01-03 | Democrat | 14 | |||||||||||||
27231 | 27231 | Clare Hoffman H000683 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 4 | |||||||||||||
27110 | 27110 | Frank Boykin B000725 | rep | AL | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
27048 | 27048 | Gardner Withrow W000663 | rep | WI | 1935-01-03 | 1937-01-03 | Progressive | 3 | |||||||||||||
26988 | 26988 | Edith Rogers R000392 | rep | MA | 1935-01-03 | 1937-01-03 | Republican | 5 | |||||||||||||
26958 | 26958 | Daniel Reed R000113 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 43 | |||||||||||||
26929 | 26929 | James Polk P000408 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
26870 | 26870 | William Hess H000550 | rep | OH | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
26776 | 26776 | Harry Byrd B001208 | sen | VA | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
26749 | 26749 | Paul Brown B000940 | rep | GA | 1935-01-03 | 1937-01-03 | Democrat | 10 | |||||||||||||
26708 | 26708 | Graham Barden B000139 | rep | NC | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
26693 | 26693 | Leo Allen A000138 | rep | IL | 1935-01-03 | 1937-01-03 | Republican | 13 | |||||||||||||
26679 | 26679 | Charles Wolverton W000683 | rep | NJ | 1935-01-03 | 1937-01-03 | Republican | 1 | |||||||||||||
26655 | 26655 | Richard Wigglesworth W000450 | rep | MA | 1935-01-03 | 1937-01-03 | Republican | 13 | |||||||||||||
26424 | 26424 | Thomas Jenkins J000088 | rep | OH | 1935-01-03 | 1937-01-03 | Republican | 10 | |||||||||||||
26378 | 26378 | Thomas Hennings H000502 | rep | MO | 1935-01-03 | 1937-01-03 | Democrat | 11 | |||||||||||||
26302 | 26302 | Martin Dies D000338 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
26288 | 26288 | John Dempsey D000228 | rep | NM | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
26253 | 26253 | Jere Cooper C000755 | rep | TN | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
26238 | 26238 | William Cole C000617 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 37 | |||||||||||||
26189 | 26189 | Usher Burdick B001079 | rep | ND | 1935-01-03 | 1937-01-03 | Republican | 0 | |||||||||||||
26166 | 26166 | August Andresen A000239 | rep | MN | 1935-01-03 | 1937-01-03 | Republican | 1 | |||||||||||||
26138 | 26138 | Jesse Wolcott W000668 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 7 | |||||||||||||
26117 | 26117 | Dewey Short S000377 | rep | MO | 1935-01-03 | 1937-01-03 | Republican | 7 | |||||||||||||
26105 | 26105 | James Richards R000214 | rep | SC | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
26093 | 26093 | Chauncey Reed R000111 | rep | IL | 1935-01-03 | 1937-01-03 | Republican | 11 | |||||||||||||
26011 | 26011 | Clifford Hope H000768 | rep | KS | 1935-01-03 | 1937-01-03 | Republican | 7 | |||||||||||||
25930 | 25930 | George Dondero D000411 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 17 | |||||||||||||
25912 | 25912 | John Dingell D000354 | rep | MI | 1935-01-03 | 1937-01-03 | Democrat | 15 | |||||||||||||
25859 | 25859 | Joseph O’Mahoney O000088 | sen | WY | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
25714 | 25714 | Merlin Hull H000943 | rep | WI | 1935-01-03 | 1937-01-03 | Progressive | 9 | |||||||||||||
25696 | 25696 | Edward Hart H000284 | rep | NJ | 1935-01-03 | 1937-01-03 | Democrat | 14 | |||||||||||||
25648 | 25648 | Robert Crosser C000932 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 21 | |||||||||||||
25560 | 25560 | Roy Woodruff W000718 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 10 | |||||||||||||
25521 | 25521 | Charles Tobey T000289 | rep | NH | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
25492 | 25492 | Karl Stefan S000845 | rep | NE | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
25468 | 25468 | Adolph Sabath S000001 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
25440 | 25440 | John Rankin R000056 | rep | MS | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
25428 | 25428 | Robert Ramsay R000025 | rep | WV | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
25354 | 25354 | John Kerr K000138 | rep | NC | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
25339 | 25339 | John Kee K000039 | rep | WV | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
25240 | 25240 | Charles Eaton E000023 | rep | NJ | 1935-01-03 | 1937-01-03 | Republican | 5 | |||||||||||||
25225 | 25225 | Robert Doughton D000448 | rep | NC | 1935-01-03 | 1937-01-03 | Democrat | 9 | |||||||||||||
25203 | 25203 | Fred Crawford C000889 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 8 | |||||||||||||
25194 | 25194 | Edward Cox C000831 | rep | GA | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
25138 | 25138 | William Blackney B000515 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 6 | |||||||||||||
25090 | 25090 | William Whittington W000430 | rep | MS | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
25078 | 25078 | Compton White W000361 | rep | ID | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
25066 | 25066 | Richard Welch W000265 | rep | CA | 1935-01-03 | 1937-01-03 | Republican | 5 | |||||||||||||
25051 | 25051 | James Wadsworth W000012 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 39 | |||||||||||||
25032 | 25032 | Andrew Somers S000676 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
25012 | 25012 | George Sadowski S000011 | rep | MI | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
25004 | 25004 | Robert Rich R000209 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 16 | |||||||||||||
24993 | 24993 | Charles Plumley P000395 | rep | VT | 1935-01-03 | 1937-01-03 | Republican | 0 | |||||||||||||
24981 | 24981 | Joseph Pfeifer P000285 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
24973 | 24973 | James Peterson P000261 | rep | FL | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
24956 | 24956 | Mary Norton N000153 | rep | NJ | 1935-01-03 | 1937-01-03 | Democrat | 13 | |||||||||||||
24940 | 24940 | Earl Michener M000693 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
24911 | 24911 | Vito Marcantonio M000122 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 20 | |||||||||||||
24890 | 24890 | John Lesinski L000251 | rep | MI | 1935-01-03 | 1937-01-03 | Democrat | 16 | |||||||||||||
24882 | 24882 | William Lemke L000238 | rep | ND | 1935-01-03 | 1937-01-03 | Republican | 0 | |||||||||||||
24846 | 24846 | Samuel Hobbs H000663 | rep | AL | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
24822 | 24822 | Albert Engel E000178 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 9 | |||||||||||||
24804 | 24804 | Ralph Church C000390 | rep | IL | 1935-01-03 | 1937-01-03 | Republican | 10 | |||||||||||||
24795 | 24795 | Virgil Chapman C000317 | rep | KY | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
24781 | 24781 | Alfred Bulwinkle B001056 | rep | NC | 1935-01-03 | 1937-01-03 | Democrat | 10 | |||||||||||||
24765 | 24765 | Sol Bloom B000565 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 19 | |||||||||||||
24751 | 24751 | Schuyler Bland B000545 | rep | VA | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
24721 | 24721 | Orville Zimmerman Z000009 | rep | MO | 1935-01-03 | 1937-01-03 | Democrat | 10 | |||||||||||||
24713 | 24713 | Milton West W000304 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 15 | |||||||||||||
24709 | 24709 | Arthur Vandenberg V000025 | sen | MI | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
24694 | 24694 | Robert Thomason T000189 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 16 | |||||||||||||
24657 | 24657 | John Robsion R000358 | rep | KY | 1935-01-03 | 1937-01-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);