legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
495 rows where "start" is on date 1931-12-07 sorted by state 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20069 | 20069 | Robert Carey C000146 | sen | WY | 1931-12-07 | 1937-01-03 | 2 | Republican | |||||||||||||
21192 | 21192 | Vincent Carter C000203 | rep | WY | 1931-12-07 | 1933-03-03 | Republican | 0 | |||||||||||||
20111 | 20111 | Carl Bachmann B000012 | rep | WV | 1931-12-07 | 1933-03-03 | Republican | 1 | |||||||||||||
20522 | 20522 | Robert Hogg H000704 | rep | WV | 1931-12-07 | 1933-03-03 | Republican | 4 | |||||||||||||
21131 | 21131 | Frank Bowman B000704 | rep | WV | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
21322 | 21322 | Lynn Hornor H000792 | rep | WV | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
23339 | 23339 | Hugh Shott S000381 | rep | WV | 1931-12-07 | 1933-03-03 | Republican | 5 | |||||||||||||
23674 | 23674 | Joseph Smith S000580 | rep | WV | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
26068 | 26068 | Matthew Neely N000023 | sen | WV | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
20249 | 20249 | Henry Cooper C000752 | rep | WI | 1931-12-07 | 1933-03-03 | Republican | -1 | |||||||||||||
20590 | 20590 | Charles Kading K000001 | rep | WI | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
20758 | 20758 | John Nelson N000039 | rep | WI | 1931-12-07 | 1933-03-03 | Republican | 3 | |||||||||||||
20881 | 20881 | William Stafford S000777 | rep | WI | 1931-12-07 | 1933-03-03 | Republican | 5 | |||||||||||||
21279 | 21279 | James Frear F000355 | rep | WI | 1931-12-07 | 1933-03-03 | Republican | 10 | |||||||||||||
21479 | 21479 | Hubert Peavey P000174 | rep | WI | 1931-12-07 | 1933-03-03 | Republican | 11 | |||||||||||||
22023 | 22023 | Thomas Amlie A000176 | rep | WI | 1931-12-07 | 1933-03-03 | Republican | 1 | |||||||||||||
22043 | 22043 | Gerald Boileau B000598 | rep | WI | 1931-12-07 | 1933-03-03 | Republican | 8 | |||||||||||||
22379 | 22379 | Michael Reilly R000155 | rep | WI | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
22398 | 22398 | George Schneider S000137 | rep | WI | 1931-12-07 | 1933-03-03 | Republican | 9 | |||||||||||||
22763 | 22763 | John Schafer S000111 | rep | WI | 1931-12-07 | 1933-03-03 | Republican | 4 | |||||||||||||
27046 | 27046 | Gardner Withrow W000663 | rep | WI | 1931-12-07 | 1933-03-03 | Republican | 7 | |||||||||||||
20453 | 20453 | Lindley Hadley H000008 | rep | WA | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
20531 | 20531 | Ralph Horr H000793 | rep | WA | 1931-12-07 | 1933-03-03 | Republican | 1 | |||||||||||||
20573 | 20573 | Albert Johnson J000114 | rep | WA | 1931-12-07 | 1933-03-03 | Republican | 3 | |||||||||||||
20907 | 20907 | John Summers S001067 | rep | WA | 1931-12-07 | 1933-03-03 | Republican | 4 | |||||||||||||
21809 | 21809 | Samuel Hill H000607 | rep | WA | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
20994 | 20994 | John Weeks W000244 | rep | VT | 1931-12-07 | 1933-03-03 | Republican | 1 | |||||||||||||
22610 | 22610 | Ernest Gibson G000158 | rep | VT | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
22852 | 22852 | Warren Austin A000342 | sen | VT | 1931-12-07 | 1935-01-03 | 1 | Republican | |||||||||||||
20370 | 20370 | John Fishburne F000143 | rep | VA | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
20371 | 20371 | Joel Flood F000211 | rep | VA | 1931-12-07 | 1933-03-03 | Democrat | 10 | |||||||||||||
20628 | 20628 | Menalcus Lankford L000080 | rep | VA | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
20961 | 20961 | Henry Tucker T000399 | rep | VA | 1931-12-07 | 1933-03-03 | Democrat | 10 | |||||||||||||
22325 | 22325 | Andrew Montague M000861 | rep | VA | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
23523 | 23523 | Carter Glass G000232 | sen | VA | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
24221 | 24221 | Clifton Woodrum W000720 | rep | VA | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
24233 | 24233 | Thomas Burch B001069 | rep | VA | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
24360 | 24360 | Patrick Drewry D000496 | rep | VA | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
24381 | 24381 | John Flannagan F000191 | rep | VA | 1931-12-07 | 1933-03-03 | Democrat | 9 | |||||||||||||
24749 | 24749 | Schuyler Bland B000545 | rep | VA | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
28657 | 28657 | Howard Smith S000554 | rep | VA | 1931-12-07 | 1933-03-03 | Democrat | 8 | |||||||||||||
20227 | 20227 | Don Colton C000652 | rep | UT | 1931-12-07 | 1933-03-03 | Republican | 1 | |||||||||||||
20679 | 20679 | Frederick Loofbourow L000435 | rep | UT | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
20415 | 20415 | Daniel Garrett G000081 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 8 | |||||||||||||
21013 | 21013 | Guinn Williams W000501 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 13 | |||||||||||||
21044 | 21044 | Harry Wurzbach W000775 | rep | TX | 1931-12-07 | 1933-03-03 | Republican | 14 | |||||||||||||
21148 | 21148 | Clay Briggs B000826 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
21295 | 21295 | John Garner G000074 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 15 | |||||||||||||
21650 | 21650 | Thomas Blanton B000549 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 17 | |||||||||||||
21732 | 21732 | Oliver Cross C000931 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 11 | |||||||||||||
21756 | 21756 | Joe Eagle E000003 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 8 | |||||||||||||
22071 | 22071 | James Buchanan B001006 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 10 | |||||||||||||
22390 | 22390 | Morgan Sanders S000037 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
22412 | 22412 | Morris Sheppard S000337 | sen | TX | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
22644 | 22644 | John Jones J000236 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 18 | |||||||||||||
23564 | 23564 | Richard Kleberg K000257 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 14 | |||||||||||||
23915 | 23915 | Luther Johnson J000159 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
23952 | 23952 | Fritz Lanham L000076 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 12 | |||||||||||||
24122 | 24122 | Hatton Sumners S001072 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
24584 | 24584 | Joseph Mansfield M000112 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 9 | |||||||||||||
24692 | 24692 | Robert Thomason T000189 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 16 | |||||||||||||
26300 | 26300 | Martin Dies D000338 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
27443 | 27443 | Samuel Rayburn R000082 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
31253 | 31253 | John Patman P000103 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
20291 | 20291 | Ewin Davis D000098 | rep | TN | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
20354 | 20354 | Edward Eslick E000216 | rep | TN | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
20355 | 20355 | Willa Eslick E000217 | rep | TN | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
20550 | 20550 | Cordell Hull H000940 | sen | TN | 1931-12-07 | 1933-12-31 | 2 | Democrat | |||||||||||||
20680 | 20680 | Oscar Lovette L000467 | rep | TN | 1931-12-07 | 1933-03-03 | Republican | 1 | |||||||||||||
21167 | 21167 | Gordon Browning B000959 | rep | TN | 1931-12-07 | 1933-03-03 | Democrat | 8 | |||||||||||||
21218 | 21218 | Edward Crump C000955 | rep | TN | 1931-12-07 | 1933-03-03 | Democrat | 10 | |||||||||||||
21681 | 21681 | Joseph Byrns B001217 | rep | TN | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
22312 | 22312 | John Mitchell M000823 | rep | TN | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
22727 | 22727 | Samuel McReynolds M000598 | rep | TN | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
22811 | 22811 | James Taylor T000083 | rep | TN | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
26251 | 26251 | Jere Cooper C000755 | rep | TN | 1931-12-07 | 1933-03-03 | Democrat | 9 | |||||||||||||
20193 | 20193 | Charles Christopherson C000384 | rep | SD | 1931-12-07 | 1933-03-03 | Republican | 1 | |||||||||||||
20583 | 20583 | Royal Johnson J000173 | rep | SD | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
21019 | 21019 | William Williamson W000553 | rep | SD | 1931-12-07 | 1933-03-03 | Republican | 3 | |||||||||||||
22075 | 22075 | William Bulow B001055 | sen | SD | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
20307 | 20307 | Frederick Dominick D000408 | rep | SC | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
20889 | 20889 | William Stevenson S000895 | rep | SC | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
21877 | 21877 | John McSwain M000604 | rep | SC | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
22084 | 22084 | James Byrnes B001215 | sen | SC | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
22173 | 22173 | Allard Gasque G000092 | rep | SC | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
22718 | 22718 | Thomas McMillan M000572 | rep | SC | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
23486 | 23486 | Hampton Fulmer F000417 | rep | SC | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
23868 | 23868 | Butler Hare H000200 | rep | SC | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
20088 | 20088 | Richard Aldrich A000084 | rep | RI | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
20143 | 20143 | Clark Burdick B001075 | rep | RI | 1931-12-07 | 1933-03-03 | Republican | 1 | |||||||||||||
20712 | 20712 | Jesse Metcalf M000670 | sen | RI | 1931-12-07 | 1937-01-03 | 2 | Republican | |||||||||||||
21707 | 21707 | Francis Condon C000673 | rep | RI | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
20337 | 20337 | Félix Dávila D000090 | rep | PR | 1931-12-07 | 1933-03-03 | Unionist | 0 | |||||||||||||
20773 | 20773 | José Pesquera P000249 | rep | PR | 1931-12-07 | 1933-03-03 | Nonpartisan | 0 | |||||||||||||
21460 | 21460 | Camilo Osias O000118 | rep | PI | 1931-12-07 | 1933-03-03 | 0 | ||||||||||||||
21794 | 21794 | Pedro Guevara G000518 | rep | PI | 1931-12-07 | 1933-03-03 | 0 | ||||||||||||||
20125 | 20125 | Edward Beers B000312 | rep | PA | 1931-12-07 | 1933-03-03 | Republican | 18 | |||||||||||||
20126 | 20126 | Joseph Biddle B000442 | rep | PA | 1931-12-07 | 1933-03-03 | Republican | 18 | |||||||||||||
20166 | 20166 | Guy Campbell C000084 | rep | PA | 1931-12-07 | 1933-03-03 | Republican | 36 | |||||||||||||
20174 | 20174 | James Chase C000328 | rep | PA | 1931-12-07 | 1933-03-03 | Republican | 23 |
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);