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 state
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23961 | 23961 | Scott Lucas L000493 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 20 | |||||||||||||
24804 | 24804 | Ralph Church C000390 | rep | IL | 1935-01-03 | 1937-01-03 | Republican | 10 | |||||||||||||
25468 | 25468 | Adolph Sabath S000001 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
26093 | 26093 | Chauncey Reed R000111 | rep | IL | 1935-01-03 | 1937-01-03 | Republican | 11 | |||||||||||||
26693 | 26693 | Leo Allen A000138 | rep | IL | 1935-01-03 | 1937-01-03 | Republican | 13 | |||||||||||||
27743 | 27743 | Everett Dirksen D000360 | rep | IL | 1935-01-03 | 1937-01-03 | Republican | 16 | |||||||||||||
28054 | 28054 | Thomas O’Brien O000016 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
30138 | 30138 | Leslie Arends A000216 | rep | IL | 1935-01-03 | 1937-01-03 | Republican | 17 | |||||||||||||
21889 | 21889 | Sherman Minton M000800 | sen | IN | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
22135 | 22135 | James Farley F000019 | rep | IN | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22190 | 22190 | Finly Gray G000395 | rep | IN | 1935-01-03 | 1937-01-03 | Democrat | 10 | |||||||||||||
22200 | 22200 | Arthur Greenwood G000437 | rep | IN | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
22206 | 22206 | Glenn Griswold G000483 | rep | IN | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
22237 | 22237 | Virginia Jenckes J000077 | rep | IN | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
22368 | 22368 | Samuel Pettengill P000268 | rep | IN | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22535 | 22535 | Eugene Crowe C000940 | rep | IN | 1935-01-03 | 1937-01-03 | Democrat | 9 | |||||||||||||
22876 | 22876 | John Boehne B000588 | rep | IN | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
23099 | 23099 | William Larrabee L000100 | rep | IN | 1935-01-03 | 1937-01-03 | Democrat | 11 | |||||||||||||
23222 | 23222 | William Schulte S000145 | rep | IN | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
24563 | 24563 | Louis Ludlow L000501 | rep | IN | 1935-01-03 | 1937-01-03 | Democrat | 12 | |||||||||||||
28860 | 28860 | Charles Halleck H000081 | rep | IN | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
21690 | 21690 | William Carpenter C000173 | rep | KS | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22364 | 22364 | Edward Patterson P000111 | rep | KS | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
23044 | 23044 | John Houston H000824 | rep | KS | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
23541 | 23541 | Ulysses Guyer G000538 | rep | KS | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
23574 | 23574 | William Lambertson L000037 | rep | KS | 1935-01-03 | 1937-01-03 | Republican | 1 | |||||||||||||
26011 | 26011 | Clifford Hope H000768 | rep | KS | 1935-01-03 | 1937-01-03 | Republican | 7 | |||||||||||||
27700 | 27700 | Frank Carlson C000154 | rep | KS | 1935-01-03 | 1937-01-03 | Republican | 6 | |||||||||||||
21686 | 21686 | Cap Carden C000140 | rep | KY | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
21693 | 21693 | Glover Cary C000214 | rep | KY | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
21779 | 21779 | William Gregory G000448 | rep | KY | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
22455 | 22455 | Frederick Vinson V000106 | rep | KY | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
23380 | 23380 | Edward Creal C000898 | rep | KY | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
23977 | 23977 | Andrew May M000272 | rep | KY | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
24011 | 24011 | Emmet O’Neal O000089 | rep | KY | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
24657 | 24657 | John Robsion R000358 | rep | KY | 1935-01-03 | 1937-01-03 | Republican | 9 | |||||||||||||
24795 | 24795 | Virgil Chapman C000317 | rep | KY | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
27535 | 27535 | Brent Spence S000717 | rep | KY | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
21736 | 21736 | Cleveland Dear D000177 | rep | LA | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
21895 | 21895 | Numa Montet M000862 | rep | LA | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
21958 | 21958 | John Sandlin S000043 | rep | LA | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22007 | 22007 | Riley Wilson W000608 | rep | LA | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
22568 | 22568 | René De Rouen D000265 | rep | LA | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
22596 | 22596 | Joachim Fernández F000086 | rep | LA | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
23214 | 23214 | Jared Sanders S000036 | rep | LA | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
23969 | 23969 | Paul Maloney M000091 | rep | LA | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
21614 | 21614 | Abram Andrew A000240 | rep | MA | 1935-01-03 | 1937-01-03 | Republican | 6 | |||||||||||||
21772 | 21772 | William Granfield G000372 | rep | MA | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
21950 | 21950 | Richard Russell R000537 | rep | MA | 1935-01-03 | 1937-01-03 | Democrat | 9 | |||||||||||||
22101 | 22101 | William Connery C000694 | rep | MA | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
22227 | 22227 | John Higgins H000579 | rep | MA | 1935-01-03 | 1937-01-03 | Democrat | 11 | |||||||||||||
22910 | 22910 | Joseph Casey C000225 | rep | MA | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
23033 | 23033 | Arthur Healey H000423 | rep | MA | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
23306 | 23306 | George Tinkham T000283 | rep | MA | 1935-01-03 | 1937-01-03 | Republican | 10 | |||||||||||||
23316 | 23316 | David Walsh W000097 | sen | MA | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
23722 | 23722 | Allen Treadway T000358 | rep | MA | 1935-01-03 | 1937-01-03 | Republican | 1 | |||||||||||||
23884 | 23884 | Pehr Holmes H000741 | rep | MA | 1935-01-03 | 1937-01-03 | Republican | 4 | |||||||||||||
24420 | 24420 | Charles Gifford G000169 | rep | MA | 1935-01-03 | 1937-01-03 | Republican | 15 | |||||||||||||
26655 | 26655 | Richard Wigglesworth W000450 | rep | MA | 1935-01-03 | 1937-01-03 | Republican | 13 | |||||||||||||
26988 | 26988 | Edith Rogers R000392 | rep | MA | 1935-01-03 | 1937-01-03 | Republican | 5 | |||||||||||||
28534 | 28534 | Joseph Martin M000191 | rep | MA | 1935-01-03 | 1937-01-03 | Republican | 14 | |||||||||||||
29368 | 29368 | John McCormack M000364 | rep | MA | 1935-01-03 | 1937-01-03 | Democrat | 12 | |||||||||||||
22167 | 22167 | Stephen Gambrill G000035 | rep | MD | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
22273 | 22273 | David Lewis L000277 | rep | MD | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
22360 | 22360 | Vincent Palmisano P000046 | rep | MD | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22620 | 22620 | Thomas Goldsborough G000265 | rep | MD | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
22656 | 22656 | Ambrose Kennedy K000101 | rep | MD | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22927 | 22927 | William Cole C000616 | rep | MD | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
23182 | 23182 | George Radcliffe R000006 | sen | MD | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
21800 | 21800 | Frederick Hale H000031 | sen | ME | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
21801 | 21801 | Simon Hamlin H000122 | rep | ME | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
21898 | 21898 | Edward Moran M000932 | rep | ME | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
24281 | 24281 | Ralph Brewster B000816 | rep | ME | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
21839 | 21839 | Henry Kimball K000183 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
21859 | 21859 | Verner Main M000071 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
22012 | 22012 | Prentiss Brown B000941 | rep | MI | 1935-01-03 | 1936-11-18 | Democrat | 11 | |||||||||||||
22685 | 22685 | Carl Mapes M000119 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 5 | |||||||||||||
22712 | 22712 | Clarence McLeod M000557 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 13 | |||||||||||||
23890 | 23890 | Frank Hook H000757 | rep | MI | 1935-01-03 | 1937-01-03 | Democrat | 12 | |||||||||||||
24709 | 24709 | Arthur Vandenberg V000025 | sen | MI | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
24822 | 24822 | Albert Engel E000178 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 9 | |||||||||||||
24890 | 24890 | John Lesinski L000251 | rep | MI | 1935-01-03 | 1937-01-03 | Democrat | 16 | |||||||||||||
24940 | 24940 | Earl Michener M000693 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
25012 | 25012 | George Sadowski S000011 | rep | MI | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
25138 | 25138 | William Blackney B000515 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 6 | |||||||||||||
25203 | 25203 | Fred Crawford C000889 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 8 | |||||||||||||
25560 | 25560 | Roy Woodruff W000718 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 10 | |||||||||||||
25912 | 25912 | John Dingell D000354 | rep | MI | 1935-01-03 | 1937-01-03 | Democrat | 15 | |||||||||||||
25930 | 25930 | George Dondero D000411 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 17 | |||||||||||||
26138 | 26138 | Jesse Wolcott W000668 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 7 | |||||||||||||
27231 | 27231 | Clare Hoffman H000683 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 4 | |||||||||||||
27416 | 27416 | Louis Rabaut R000001 | rep | MI | 1935-01-03 | 1937-01-03 | Democrat | 14 | |||||||||||||
21701 | 21701 | Theodore Christianson C000381 | rep | MN | 1935-01-03 | 1937-01-03 | Republican | 5 | |||||||||||||
22254 | 22254 | Paul Kvale K000350 | rep | MN | 1935-01-03 | 1937-01-03 | Farmer-Labor | 7 | |||||||||||||
22287 | 22287 | Ernest Lundeen L000514 | rep | MN | 1935-01-03 | 1937-01-03 | Farmer-Labor | 3 | |||||||||||||
22755 | 22755 | Elmer Ryan R000555 | rep | MN | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22894 | 22894 | Richard Buckler B001023 | rep | MN | 1935-01-03 | 1937-01-03 | Farmer-Labor | 9 | |||||||||||||
23240 | 23240 | Henrik Shipstead S000369 | sen | MN | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
23588 | 23588 | Melvin Maas M000001 | rep | MN | 1935-01-03 | 1937-01-03 | Republican | 4 | |||||||||||||
24036 | 24036 | William Pittenger P000371 | rep | MN | 1935-01-03 | 1937-01-03 | Republican | 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);