legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
499 rows where "end" is on date 1933-03-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21057 | 21057 | Richard Yates Y000011 | rep | IL | 1931-12-07 | 1933-03-03 | Republican | -1 | |||||||||||||
21159 | 21159 | Frederick Britten B000847 | rep | IL | 1931-12-07 | 1933-03-03 | Republican | 9 | |||||||||||||
21221 | 21221 | Oscar De Priest D000263 | rep | IL | 1931-12-07 | 1933-03-03 | Republican | 1 | |||||||||||||
21234 | 21234 | William Dieterich D000339 | rep | IL | 1931-12-07 | 1933-03-03 | Democrat | -1 | |||||||||||||
21392 | 21392 | James Major M000073 | rep | IL | 1931-12-07 | 1933-03-03 | Democrat | 21 | |||||||||||||
21524 | 21524 | Henry Rainey R000014 | rep | IL | 1931-12-07 | 1933-03-03 | Democrat | 20 | |||||||||||||
21530 | 21530 | Frank Reid R000145 | rep | IL | 1931-12-07 | 1933-03-03 | Republican | 11 | |||||||||||||
21619 | 21619 | William Arnold A000300 | rep | IL | 1931-12-07 | 1933-03-03 | Democrat | 23 | |||||||||||||
21663 | 21663 | John Buckbee B001020 | rep | IL | 1931-12-07 | 1933-03-03 | Republican | 12 | |||||||||||||
22649 | 22649 | Kent Keller K000056 | rep | IL | 1931-12-07 | 1933-03-03 | Democrat | 25 | |||||||||||||
22743 | 22743 | Claude Parsons P000086 | rep | IL | 1931-12-07 | 1933-03-03 | Democrat | 24 | |||||||||||||
22861 | 22861 | Harry Beam B000274 | rep | IL | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
23666 | 23666 | Leonard Schuetz S000144 | rep | IL | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
23923 | 23923 | Edward Kelly K000071 | rep | IL | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
25466 | 25466 | Adolph Sabath S000001 | rep | IL | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
19538 | 19538 | James Watson W000203 | sen | IN | 1927-12-05 | 1933-03-03 | 3 | Republican | |||||||||||||
20171 | 20171 | Harry Canfield C000114 | rep | IN | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
20421 | 20421 | Courtland Gillen G000193 | rep | IN | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
20520 | 20520 | David Hogg H000702 | rep | IN | 1931-12-07 | 1933-03-03 | Republican | 12 | |||||||||||||
20787 | 20787 | Fred Purnell P000573 | rep | IN | 1931-12-07 | 1933-03-03 | Republican | 9 | |||||||||||||
20975 | 20975 | Albert Vestal V000092 | rep | IN | 1931-12-07 | 1933-03-03 | Republican | 8 | |||||||||||||
21030 | 21030 | William Wood W000706 | rep | IN | 1931-12-07 | 1933-03-03 | Republican | 10 | |||||||||||||
22198 | 22198 | Arthur Greenwood G000437 | rep | IN | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
22204 | 22204 | Glenn Griswold G000483 | rep | IN | 1931-12-07 | 1933-03-03 | Democrat | 11 | |||||||||||||
22366 | 22366 | Samuel Pettengill P000268 | rep | IN | 1931-12-07 | 1933-03-03 | Democrat | 13 | |||||||||||||
22533 | 22533 | Eugene Crowe C000940 | rep | IN | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
22874 | 22874 | John Boehne B000588 | rep | IN | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
23097 | 23097 | William Larrabee L000100 | rep | IN | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
24561 | 24561 | Louis Ludlow L000501 | rep | IN | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
20516 | 20516 | Homer Hoch H000669 | rep | KS | 1931-12-07 | 1933-03-03 | Republican | 4 | |||||||||||||
20871 | 20871 | Charles Sparks S000703 | rep | KS | 1931-12-07 | 1933-03-03 | Republican | 6 | |||||||||||||
20897 | 20897 | James Strong S001011 | rep | KS | 1931-12-07 | 1933-03-03 | Republican | 5 | |||||||||||||
21103 | 21103 | William Ayres A000354 | rep | KS | 1931-12-07 | 1933-03-03 | Democrat | 8 | |||||||||||||
21419 | 21419 | George McGill M000447 | sen | KS | 1930-01-01 | 1933-03-03 | 3 | Democrat | |||||||||||||
21421 | 21421 | Harold McGugin M000463 | rep | KS | 1931-12-07 | 1933-03-03 | Republican | 3 | |||||||||||||
23539 | 23539 | Ulysses Guyer G000538 | rep | KS | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
23572 | 23572 | William Lambertson L000037 | rep | KS | 1931-12-07 | 1933-03-03 | Republican | 1 | |||||||||||||
26009 | 26009 | Clifford Hope H000768 | rep | KS | 1931-12-07 | 1933-03-03 | Republican | 7 | |||||||||||||
20369 | 20369 | Charles Finley F000130 | rep | KY | 1931-12-07 | 1933-03-03 | Republican | 11 | |||||||||||||
20420 | 20420 | Ralph Gilbert G000177 | rep | KY | 1931-12-07 | 1933-03-03 | Democrat | 8 | |||||||||||||
20730 | 20730 | John Moore M000905 | rep | KY | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
20930 | 20930 | Maurice Thatcher T000142 | rep | KY | 1931-12-07 | 1933-03-03 | Republican | 5 | |||||||||||||
21684 | 21684 | Cap Carden C000140 | rep | KY | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
21691 | 21691 | Glover Cary C000214 | rep | KY | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
21777 | 21777 | William Gregory G000448 | rep | KY | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
22453 | 22453 | Frederick Vinson V000106 | rep | KY | 1931-12-07 | 1933-03-03 | Democrat | 9 | |||||||||||||
23975 | 23975 | Andrew May M000272 | rep | KY | 1931-12-07 | 1933-03-03 | Democrat | 10 | |||||||||||||
24793 | 24793 | Virgil Chapman C000317 | rep | KY | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
25874 | 25874 | Alben Barkley B000145 | sen | KY | 1927-12-05 | 1933-03-03 | 3 | Democrat | |||||||||||||
27533 | 27533 | Brent Spence S000717 | rep | KY | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
19238 | 19238 | Edwin Broussard B000895 | sen | LA | 1927-12-05 | 1933-03-03 | 3 | Democrat | |||||||||||||
20107 | 20107 | James Aswell A000321 | rep | LA | 1931-12-07 | 1933-03-03 | Democrat | 8 | |||||||||||||
21363 | 21363 | Bolivar Kemp K000085 | rep | LA | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
21893 | 21893 | Numa Montet M000862 | rep | LA | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
21956 | 21956 | John Sandlin S000043 | rep | LA | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
22005 | 22005 | Riley Wilson W000608 | rep | LA | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
22566 | 22566 | René De Rouen D000265 | rep | LA | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
22594 | 22594 | Joachim Fernández F000086 | rep | LA | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
23967 | 23967 | Paul Maloney M000091 | rep | LA | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
24019 | 24019 | John Overton O000146 | rep | LA | 1931-12-07 | 1933-03-03 | Democrat | 8 | |||||||||||||
20280 | 20280 | Frederick Dallinger D000012 | rep | MA | 1931-12-07 | 1933-03-03 | Republican | 8 | |||||||||||||
20967 | 20967 | Charles Underhill U000006 | rep | MA | 1931-12-07 | 1933-03-03 | Republican | 9 | |||||||||||||
21239 | 21239 | John Douglass D000459 | rep | MA | 1931-12-07 | 1933-03-03 | Democrat | 10 | |||||||||||||
21267 | 21267 | Frank Foss F000294 | rep | MA | 1931-12-07 | 1933-03-03 | Republican | 3 | |||||||||||||
21612 | 21612 | Abram Andrew A000240 | rep | MA | 1931-12-07 | 1933-03-03 | Republican | 6 | |||||||||||||
21770 | 21770 | William Granfield G000372 | rep | MA | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
22099 | 22099 | William Connery C000694 | rep | MA | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
22670 | 22670 | Robert Luce L000498 | rep | MA | 1931-12-07 | 1933-03-03 | Republican | 13 | |||||||||||||
23304 | 23304 | George Tinkham T000283 | rep | MA | 1931-12-07 | 1933-03-03 | Republican | 11 | |||||||||||||
23720 | 23720 | Allen Treadway T000358 | rep | MA | 1931-12-07 | 1933-03-03 | Republican | 1 | |||||||||||||
23882 | 23882 | Pehr Holmes H000741 | rep | MA | 1931-12-07 | 1933-03-03 | Republican | 4 | |||||||||||||
24418 | 24418 | Charles Gifford G000169 | rep | MA | 1931-12-07 | 1933-03-03 | Republican | 16 | |||||||||||||
26653 | 26653 | Richard Wigglesworth W000450 | rep | MA | 1931-12-07 | 1933-03-03 | Republican | 14 | |||||||||||||
26986 | 26986 | Edith Rogers R000392 | rep | MA | 1931-12-07 | 1933-03-03 | Republican | 5 | |||||||||||||
28532 | 28532 | Joseph Martin M000191 | rep | MA | 1931-12-07 | 1933-03-03 | Republican | 15 | |||||||||||||
29366 | 29366 | John McCormack M000364 | rep | MA | 1931-12-07 | 1933-03-03 | Democrat | 12 | |||||||||||||
20663 | 20663 | John Linthicum L000340 | rep | MD | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
22165 | 22165 | Stephen Gambrill G000035 | rep | MD | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
22271 | 22271 | David Lewis L000277 | rep | MD | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
22358 | 22358 | Vincent Palmisano P000046 | rep | MD | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
22618 | 22618 | Thomas Goldsborough G000265 | rep | MD | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
22654 | 22654 | Ambrose Kennedy K000101 | rep | MD | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
22925 | 22925 | William Cole C000616 | rep | MD | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
24170 | 24170 | Millard Tydings T000446 | sen | MD | 1927-12-05 | 1933-03-03 | 3 | Democrat | |||||||||||||
20745 | 20745 | John Nelson N000038 | rep | ME | 1931-12-07 | 1933-03-03 | Republican | 3 | |||||||||||||
20768 | 20768 | Donald Partridge P000090 | rep | ME | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
20869 | 20869 | Donald Snow S000659 | rep | ME | 1931-12-07 | 1933-03-03 | Republican | 4 | |||||||||||||
21117 | 21117 | Carroll Beedy B000307 | rep | ME | 1931-12-07 | 1933-03-03 | Republican | 1 | |||||||||||||
20129 | 20129 | Frank Bohn B000596 | rep | MI | 1931-12-07 | 1933-03-03 | Republican | 11 | |||||||||||||
20203 | 20203 | Robert Clancy C000412 | rep | MI | 1931-12-07 | 1933-03-03 | Republican | 1 | |||||||||||||
20604 | 20604 | John Ketcham K000151 | rep | MI | 1931-12-07 | 1933-03-03 | Republican | 4 | |||||||||||||
20709 | 20709 | James McLaughlin M000539 | rep | MI | 1931-12-07 | 1933-03-03 | Republican | 9 | |||||||||||||
20772 | 20772 | Seymour Person P000247 | rep | MI | 1931-12-07 | 1933-03-03 | Republican | 6 | |||||||||||||
20980 | 20980 | Bird Vincent V000101 | rep | MI | 1931-12-07 | 1933-03-03 | Republican | -1 | |||||||||||||
21320 | 21320 | Joseph Hooper H000764 | rep | MI | 1931-12-07 | 1933-03-03 | Republican | 3 | |||||||||||||
21339 | 21339 | William James J000053 | rep | MI | 1931-12-07 | 1933-03-03 | Republican | 12 | |||||||||||||
22683 | 22683 | Carl Mapes M000119 | rep | MI | 1931-12-07 | 1933-03-03 | Republican | 5 | |||||||||||||
22710 | 22710 | Clarence McLeod M000557 | rep | MI | 1931-12-07 | 1933-03-03 | Republican | 13 | |||||||||||||
24939 | 24939 | Earl Michener M000693 | rep | MI | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
25558 | 25558 | Roy Woodruff W000718 | rep | MI | 1931-12-07 | 1933-03-03 | Republican | 10 |
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);