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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22650 | 22650 | Kent Keller K000056 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 25 | |||||||||||||
22744 | 22744 | Claude Parsons P000086 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 24 | |||||||||||||
22862 | 22862 | Harry Beam B000274 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
23083 | 23083 | Leo Kocialkowski K000303 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
23216 | 23216 | Edwin Schaefer S000110 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 22 | |||||||||||||
23667 | 23667 | Leonard Schuetz S000144 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
23924 | 23924 | Edward Kelly K000071 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
25467 | 25467 | Adolph Sabath S000001 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
26692 | 26692 | Leo Allen A000138 | rep | IL | 1933-03-09 | 1935-01-03 | Republican | 13 | |||||||||||||
27742 | 27742 | Everett Dirksen D000360 | rep | IL | 1933-03-09 | 1935-01-03 | Republican | 16 | |||||||||||||
28053 | 28053 | Thomas O’Brien O000016 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
19945 | 19945 | Arthur Robinson R000332 | sen | IN | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
21242 | 21242 | George Durgan D000570 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
22134 | 22134 | James Farley F000019 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
22189 | 22189 | Finly Gray G000395 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 10 | |||||||||||||
22199 | 22199 | Arthur Greenwood G000437 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
22205 | 22205 | Glenn Griswold G000483 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
22236 | 22236 | Virginia Jenckes J000077 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
22367 | 22367 | Samuel Pettengill P000268 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
22534 | 22534 | Eugene Crowe C000940 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 9 | |||||||||||||
22875 | 22875 | John Boehne B000588 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
23098 | 23098 | William Larrabee L000100 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 11 | |||||||||||||
23221 | 23221 | William Schulte S000145 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
24562 | 24562 | Louis Ludlow L000501 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 12 | |||||||||||||
21104 | 21104 | William Ayres A000354 | rep | KS | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
21422 | 21422 | Harold McGugin M000463 | rep | KS | 1933-03-09 | 1935-01-03 | Republican | 3 | |||||||||||||
21452 | 21452 | Kathryn O’Loughlin McCarthy O000081 | rep | KS | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
21689 | 21689 | William Carpenter C000173 | rep | KS | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
23540 | 23540 | Ulysses Guyer G000538 | rep | KS | 1933-03-09 | 1935-01-03 | Republican | 2 | |||||||||||||
23573 | 23573 | William Lambertson L000037 | rep | KS | 1933-03-09 | 1935-01-03 | Republican | 1 | |||||||||||||
26010 | 26010 | Clifford Hope H000768 | rep | KS | 1933-03-09 | 1935-01-03 | Republican | 7 | |||||||||||||
21162 | 21162 | John Brown B000934 | rep | KY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21304 | 21304 | Finley Hamilton H000109 | rep | KY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21685 | 21685 | Cap Carden C000140 | rep | KY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21692 | 21692 | Glover Cary C000214 | rep | KY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21778 | 21778 | William Gregory G000448 | rep | KY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
22454 | 22454 | Frederick Vinson V000106 | rep | KY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
23976 | 23976 | Andrew May M000272 | rep | KY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
24794 | 24794 | Virgil Chapman C000317 | rep | KY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
27534 | 27534 | Brent Spence S000717 | rep | KY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21364 | 21364 | Bolivar Kemp K000085 | rep | LA | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
21735 | 21735 | Cleveland Dear D000177 | rep | LA | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
21894 | 21894 | Numa Montet M000862 | rep | LA | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
21957 | 21957 | John Sandlin S000043 | rep | LA | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
22006 | 22006 | Riley Wilson W000608 | rep | LA | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
22567 | 22567 | René De Rouen D000265 | rep | LA | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
22595 | 22595 | Joachim Fernández F000086 | rep | LA | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
23213 | 23213 | Jared Sanders S000036 | rep | LA | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
23968 | 23968 | Paul Maloney M000091 | rep | LA | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
21240 | 21240 | John Douglass D000459 | rep | MA | 1933-03-09 | 1935-01-03 | Democrat | 11 | |||||||||||||
21268 | 21268 | Frank Foss F000294 | rep | MA | 1933-03-09 | 1935-01-03 | Republican | 3 | |||||||||||||
21613 | 21613 | Abram Andrew A000240 | rep | MA | 1933-03-09 | 1935-01-03 | Republican | 6 | |||||||||||||
21771 | 21771 | William Granfield G000372 | rep | MA | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
22100 | 22100 | William Connery C000694 | rep | MA | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
22671 | 22671 | Robert Luce L000498 | rep | MA | 1933-03-09 | 1935-01-03 | Republican | 9 | |||||||||||||
23032 | 23032 | Arthur Healey H000423 | rep | MA | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
23305 | 23305 | George Tinkham T000283 | rep | MA | 1933-03-09 | 1935-01-03 | Republican | 10 | |||||||||||||
23315 | 23315 | David Walsh W000097 | sen | MA | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
23721 | 23721 | Allen Treadway T000358 | rep | MA | 1933-03-09 | 1935-01-03 | Republican | 1 | |||||||||||||
23883 | 23883 | Pehr Holmes H000741 | rep | MA | 1933-03-09 | 1935-01-03 | Republican | 4 | |||||||||||||
24419 | 24419 | Charles Gifford G000169 | rep | MA | 1933-03-09 | 1935-01-03 | Republican | 15 | |||||||||||||
26654 | 26654 | Richard Wigglesworth W000450 | rep | MA | 1933-03-09 | 1935-01-03 | Republican | 13 | |||||||||||||
26987 | 26987 | Edith Rogers R000392 | rep | MA | 1933-03-09 | 1935-01-03 | Republican | 5 | |||||||||||||
28533 | 28533 | Joseph Martin M000191 | rep | MA | 1933-03-09 | 1935-01-03 | Republican | 14 | |||||||||||||
29367 | 29367 | John McCormack M000364 | rep | MA | 1933-03-09 | 1935-01-03 | Democrat | 12 | |||||||||||||
19732 | 19732 | Phillips Goldsborough G000262 | sen | MD | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
22166 | 22166 | Stephen Gambrill G000035 | rep | MD | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
22272 | 22272 | David Lewis L000277 | rep | MD | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
22359 | 22359 | Vincent Palmisano P000046 | rep | MD | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
22619 | 22619 | Thomas Goldsborough G000265 | rep | MD | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
22655 | 22655 | Ambrose Kennedy K000101 | rep | MD | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
22926 | 22926 | William Cole C000616 | rep | MD | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
21118 | 21118 | Carroll Beedy B000307 | rep | ME | 1933-03-09 | 1935-01-03 | Republican | 1 | |||||||||||||
21585 | 21585 | John Utterback U000037 | rep | ME | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
21799 | 21799 | Frederick Hale H000031 | sen | ME | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
21897 | 21897 | Edward Moran M000932 | rep | ME | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
21185 | 21185 | Claude Cady C000013 | rep | MI | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
21269 | 21269 | George Foulkes F000317 | rep | MI | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
21305 | 21305 | Michael Hart H000290 | rep | MI | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
21321 | 21321 | Joseph Hooper H000764 | rep | MI | 1933-03-09 | 1935-01-03 | Republican | 3 | |||||||||||||
21340 | 21340 | William James J000053 | rep | MI | 1933-03-09 | 1935-01-03 | Republican | 12 | |||||||||||||
21372 | 21372 | John Lehr L000228 | rep | MI | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
21447 | 21447 | Harry Musselwhite M001122 | rep | MI | 1933-03-09 | 1935-01-03 | Democrat | 9 | |||||||||||||
21597 | 21597 | Carl Weideman W000254 | rep | MI | 1933-03-09 | 1935-01-03 | Democrat | 14 | |||||||||||||
22011 | 22011 | Prentiss Brown B000941 | rep | MI | 1933-03-09 | 1935-01-03 | Democrat | 11 | |||||||||||||
22684 | 22684 | Carl Mapes M000119 | rep | MI | 1933-03-09 | 1935-01-03 | Republican | 5 | |||||||||||||
22711 | 22711 | Clarence McLeod M000557 | rep | MI | 1933-03-09 | 1935-01-03 | Republican | 13 | |||||||||||||
24708 | 24708 | Arthur Vandenberg V000025 | sen | MI | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
24889 | 24889 | John Lesinski L000251 | rep | MI | 1933-03-09 | 1935-01-03 | Democrat | 16 | |||||||||||||
25011 | 25011 | George Sadowski S000011 | rep | MI | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
25559 | 25559 | Roy Woodruff W000718 | rep | MI | 1933-03-09 | 1935-01-03 | Republican | 10 | |||||||||||||
25911 | 25911 | John Dingell D000354 | rep | MI | 1933-03-09 | 1935-01-03 | Democrat | 15 | |||||||||||||
25929 | 25929 | George Dondero D000411 | rep | MI | 1933-03-09 | 1935-01-03 | Republican | 17 | |||||||||||||
26137 | 26137 | Jesse Wolcott W000668 | rep | MI | 1933-03-09 | 1935-01-03 | Republican | 7 | |||||||||||||
21090 | 21090 | Henry Arens A000276 | rep | MN | 1933-03-09 | 1935-01-03 | Farmer-Labor | 0 | |||||||||||||
21194 | 21194 | Ray Chase C000331 | rep | MN | 1933-03-09 | 1935-01-03 | Republican | 0 | |||||||||||||
21316 | 21316 | Einar Hoidale H000706 | rep | MN | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21349 | 21349 | Magnus Johnson J000161 | rep | MN | 1933-03-09 | 1935-01-03 | Farmer-Labor | 0 | |||||||||||||
21541 | 21541 | Francis Shoemaker S000374 | rep | MN | 1933-03-09 | 1935-01-03 | Farmer-Labor | 0 | |||||||||||||
21700 | 21700 | Theodore Christianson C000381 | rep | MN | 1933-03-09 | 1935-01-03 | Republican | 0 |
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);