legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
492 rows where "end" is on date 1939-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34046 | 34046 | Claude Pepper P000218 | sen | FL | 1936-01-01 | 1939-01-03 | 3 | Democrat | |||||||||||||
32243 | 32243 | Jennings Randolph R000046 | rep | WV | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
31718 | 31718 | William Poage P000398 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 11 | |||||||||||||
31622 | 31622 | George Mahon M000065 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 19 | |||||||||||||
31256 | 31256 | John Patman P000103 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
31160 | 31160 | Warren Magnuson M000053 | rep | WA | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
30694 | 30694 | John Sparkman S000701 | rep | AL | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
30564 | 30564 | John McClellan M000332 | rep | AR | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
30139 | 30139 | Leslie Arends A000216 | rep | IL | 1937-01-05 | 1939-01-03 | Republican | 17 | |||||||||||||
29698 | 29698 | William Colmer C000645 | rep | MS | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
29678 | 29678 | Emanuel Celler C000264 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 10 | |||||||||||||
29369 | 29369 | John McCormack M000364 | rep | MA | 1937-01-05 | 1939-01-03 | Democrat | 12 | |||||||||||||
29302 | 29302 | Michael Kirwan K000244 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 19 | |||||||||||||
28861 | 28861 | Charles Halleck H000081 | rep | IN | 1937-01-05 | 1939-01-03 | Republican | 2 | |||||||||||||
28677 | 28677 | Albert Thomas T000156 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
28660 | 28660 | Howard Smith S000554 | rep | VA | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
28645 | 28645 | Robert Secrest S000219 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 15 | |||||||||||||
28535 | 28535 | Joseph Martin M000191 | rep | MA | 1937-01-05 | 1939-01-03 | Republican | 14 | |||||||||||||
28493 | 28493 | Eugene Keogh K000130 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 9 | |||||||||||||
28375 | 28375 | Harold Cooley C000736 | rep | NC | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
28294 | 28294 | Lyndon Johnson J000160 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 10 | |||||||||||||
28234 | 28234 | Francis Walter W000108 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 21 | |||||||||||||
28215 | 28215 | Carl Vinson V000105 | rep | GA | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
28139 | 28139 | Harry Sheppard S000335 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 19 | |||||||||||||
28055 | 28055 | Thomas O’Brien O000016 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
27879 | 27879 | Joseph Hill H000598 | sen | AL | 1938-01-11 | 1939-01-03 | 3 | Democrat | appointment | ||||||||||||
27852 | 27852 | Carl Hayden H000385 | sen | AZ | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
27816 | 27816 | George Grant G000381 | rep | AL | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
27744 | 27744 | Everett Dirksen D000360 | rep | IL | 1937-01-05 | 1939-01-03 | Republican | 16 | |||||||||||||
27701 | 27701 | Frank Carlson C000154 | rep | KS | 1937-01-05 | 1939-01-03 | Republican | 6 | |||||||||||||
27686 | 27686 | Clarence Cannon C000117 | rep | MO | 1937-01-05 | 1939-01-03 | Democrat | 9 | |||||||||||||
27664 | 27664 | Charles Buckley B001024 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 23 | |||||||||||||
27556 | 27556 | John Taber T000001 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 36 | |||||||||||||
27536 | 27536 | Brent Spence S000717 | rep | KY | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
27489 | 27489 | Absalom Robertson R000317 | rep | VA | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
27466 | 27466 | Brazilla Reece R000108 | rep | TN | 1937-01-05 | 1939-01-03 | Republican | 1 | |||||||||||||
27446 | 27446 | Samuel Rayburn R000082 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
27417 | 27417 | Louis Rabaut R000001 | rep | MI | 1937-01-05 | 1939-01-03 | Democrat | 14 | |||||||||||||
27343 | 27343 | Noah Mason M000224 | rep | IL | 1937-01-05 | 1939-01-03 | Republican | 12 | |||||||||||||
27232 | 27232 | Clare Hoffman H000683 | rep | MI | 1937-01-05 | 1939-01-03 | Republican | 4 | |||||||||||||
27127 | 27127 | Overton Brooks B000884 | rep | LA | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
27111 | 27111 | Frank Boykin B000725 | rep | AL | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
27049 | 27049 | Gardner Withrow W000663 | rep | WI | 1937-01-05 | 1939-01-03 | Progressive | 3 | |||||||||||||
27002 | 27002 | Richard Simpson S000436 | rep | PA | 1937-01-05 | 1939-01-03 | Republican | 18 | |||||||||||||
26989 | 26989 | Edith Rogers R000392 | rep | MA | 1937-01-05 | 1939-01-03 | Republican | 5 | |||||||||||||
26971 | 26971 | Edward Rees R000132 | rep | KS | 1937-01-05 | 1939-01-03 | Republican | 4 | |||||||||||||
26959 | 26959 | Daniel Reed R000113 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 43 | |||||||||||||
26930 | 26930 | James Polk P000408 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
26923 | 26923 | James Oliver O000074 | rep | ME | 1937-01-05 | 1939-01-03 | Republican | 1 | |||||||||||||
26849 | 26849 | Aime Forand F000255 | rep | RI | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
26750 | 26750 | Paul Brown B000940 | rep | GA | 1937-01-05 | 1939-01-03 | Democrat | 10 | |||||||||||||
26709 | 26709 | Graham Barden B000139 | rep | NC | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
26694 | 26694 | Leo Allen A000138 | rep | IL | 1937-01-05 | 1939-01-03 | Republican | 13 | |||||||||||||
26680 | 26680 | Charles Wolverton W000683 | rep | NJ | 1937-01-05 | 1939-01-03 | Republican | 1 | |||||||||||||
26656 | 26656 | Richard Wigglesworth W000450 | rep | MA | 1937-01-05 | 1939-01-03 | Republican | 13 | |||||||||||||
26425 | 26425 | Thomas Jenkins J000088 | rep | OH | 1937-01-05 | 1939-01-03 | Republican | 10 | |||||||||||||
26379 | 26379 | Thomas Hennings H000502 | rep | MO | 1937-01-05 | 1939-01-03 | Democrat | 11 | |||||||||||||
26334 | 26334 | Noble Gregory G000447 | rep | KY | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
26310 | 26310 | Herman Eberharter E000029 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 32 | |||||||||||||
26303 | 26303 | Martin Dies D000338 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
26289 | 26289 | John Dempsey D000228 | rep | NM | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
26254 | 26254 | Jere Cooper C000755 | rep | TN | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
26239 | 26239 | William Cole C000617 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 37 | |||||||||||||
26214 | 26214 | Francis Case C000221 | rep | SD | 1937-01-05 | 1939-01-03 | Republican | 2 | |||||||||||||
26190 | 26190 | Usher Burdick B001079 | rep | ND | 1937-01-05 | 1939-01-03 | Republican | 0 | |||||||||||||
26167 | 26167 | August Andresen A000239 | rep | MN | 1937-01-05 | 1939-01-03 | Republican | 1 | |||||||||||||
26139 | 26139 | Jesse Wolcott W000668 | rep | MI | 1937-01-05 | 1939-01-03 | Republican | 7 | |||||||||||||
26118 | 26118 | Dewey Short S000377 | rep | MO | 1937-01-05 | 1939-01-03 | Republican | 7 | |||||||||||||
26106 | 26106 | James Richards R000214 | rep | SC | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
26094 | 26094 | Chauncey Reed R000111 | rep | IL | 1937-01-05 | 1939-01-03 | Republican | 11 | |||||||||||||
26012 | 26012 | Clifford Hope H000768 | rep | KS | 1937-01-05 | 1939-01-03 | Republican | 7 | |||||||||||||
25966 | 25966 | Ralph Gamble G000031 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 25 | |||||||||||||
25931 | 25931 | George Dondero D000411 | rep | MI | 1937-01-05 | 1939-01-03 | Republican | 17 | |||||||||||||
25913 | 25913 | John Dingell D000354 | rep | MI | 1937-01-05 | 1939-01-03 | Democrat | 15 | |||||||||||||
25875 | 25875 | Alben Barkley B000145 | sen | KY | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
25799 | 25799 | Paul Shafer S000277 | rep | MI | 1937-01-05 | 1939-01-03 | Republican | 3 | |||||||||||||
25766 | 25766 | George O’Brien O000009 | rep | MI | 1937-01-05 | 1939-01-03 | Democrat | 13 | |||||||||||||
25715 | 25715 | Merlin Hull H000943 | rep | WI | 1937-01-05 | 1939-01-03 | Progressive | 9 | |||||||||||||
25697 | 25697 | Edward Hart H000284 | rep | NJ | 1937-01-05 | 1939-01-03 | Democrat | 14 | |||||||||||||
25649 | 25649 | Robert Crosser C000932 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 21 | |||||||||||||
25561 | 25561 | Roy Woodruff W000718 | rep | MI | 1937-01-05 | 1939-01-03 | Republican | 10 | |||||||||||||
25522 | 25522 | Charles Tobey T000289 | rep | NH | 1937-01-05 | 1939-01-03 | Republican | 2 | |||||||||||||
25493 | 25493 | Karl Stefan S000845 | rep | NE | 1937-01-05 | 1939-01-03 | Republican | 3 | |||||||||||||
25469 | 25469 | Adolph Sabath S000001 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
25441 | 25441 | John Rankin R000056 | rep | MS | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
25429 | 25429 | Robert Ramsay R000025 | rep | WV | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
25413 | 25413 | Donald O’Toole O000133 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
25394 | 25394 | John Murdock M001081 | rep | AZ | 1937-01-05 | 1939-01-03 | Democrat | 0 | |||||||||||||
25374 | 25374 | Patrick McCarran M000308 | sen | NV | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
25355 | 25355 | John Kerr K000138 | rep | NC | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
25340 | 25340 | John Kee K000039 | rep | WV | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
25306 | 25306 | Franck Havenner H000356 | rep | CA | 1937-01-05 | 1939-01-03 | Progressive | 4 | |||||||||||||
25268 | 25268 | Walter George G000131 | sen | GA | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
25241 | 25241 | Charles Eaton E000023 | rep | NJ | 1937-01-05 | 1939-01-03 | Republican | 5 | |||||||||||||
25226 | 25226 | Robert Doughton D000448 | rep | NC | 1937-01-05 | 1939-01-03 | Democrat | 9 | |||||||||||||
25204 | 25204 | Fred Crawford C000889 | rep | MI | 1937-01-05 | 1939-01-03 | Republican | 8 | |||||||||||||
25195 | 25195 | Edward Cox C000831 | rep | GA | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
25171 | 25171 | William Byrne B001214 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 28 | |||||||||||||
25130 | 25130 | Joseph Bates B000237 | rep | KY | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
25112 | 25112 | Asa Allen A000114 | rep | LA | 1937-01-05 | 1939-01-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);