legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
485 rows where "start" is on date 1927-12-05 sorted by state descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, party, end (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19554 | 19554 | Charles Winter W000643 | rep | WY | 1927-12-05 | 1929-03-03 | Republican | 0 | |||||||||||||
19295 | 19295 | Edward England E000180 | rep | WV | 1927-12-05 | 1929-03-03 | Republican | 6 | |||||||||||||
19442 | 19442 | William O’Brien O000018 | rep | WV | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
19499 | 19499 | James Strother S001024 | rep | WV | 1927-12-05 | 1929-03-03 | Republican | 5 | |||||||||||||
19791 | 19791 | James Hughes H000924 | rep | WV | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
20109 | 20109 | Carl Bachmann B000012 | rep | WV | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
21129 | 21129 | Frank Bowman B000704 | rep | WV | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
19201 | 19201 | Joseph Beck B000291 | rep | WI | 1927-12-05 | 1929-03-03 | Republican | 7 | |||||||||||||
19211 | 19211 | Victor Berger B000407 | rep | WI | 1927-12-05 | 1929-03-03 | Socialist | 5 | |||||||||||||
19221 | 19221 | John Blaine B000520 | sen | WI | 1927-12-05 | 1933-03-03 | 3 | Republican | |||||||||||||
19605 | 19605 | Edward Browne B000955 | rep | WI | 1927-12-05 | 1929-03-03 | Republican | 8 | |||||||||||||
19844 | 19844 | Florian Lampert L000041 | rep | WI | 1927-12-05 | 1929-03-03 | Republican | 6 | |||||||||||||
20247 | 20247 | Henry Cooper C000752 | rep | WI | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
20588 | 20588 | Charles Kading K000001 | rep | WI | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20756 | 20756 | John Nelson N000039 | rep | WI | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
21277 | 21277 | James Frear F000355 | rep | WI | 1927-12-05 | 1929-03-03 | Republican | 10 | |||||||||||||
21477 | 21477 | Hubert Peavey P000174 | rep | WI | 1927-12-05 | 1929-03-03 | Republican | 11 | |||||||||||||
22396 | 22396 | George Schneider S000137 | rep | WI | 1927-12-05 | 1929-03-03 | Republican | 9 | |||||||||||||
22761 | 22761 | John Schafer S000111 | rep | WI | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
19370 | 19370 | Wesley Jones J000257 | sen | WA | 1927-12-05 | 1933-03-03 | 3 | Republican | |||||||||||||
19884 | 19884 | John Miller M000739 | rep | WA | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
20451 | 20451 | Lindley Hadley H000008 | rep | WA | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20571 | 20571 | Albert Johnson J000114 | rep | WA | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
20905 | 20905 | John Summers S001067 | rep | WA | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
21807 | 21807 | Samuel Hill H000607 | rep | WA | 1927-12-05 | 1929-03-03 | Democrat | 5 | |||||||||||||
19285 | 19285 | Porter Dale D000009 | sen | VT | 1927-12-05 | 1933-03-03 | 3 | Republican | |||||||||||||
19595 | 19595 | Elbert Brigham B000832 | rep | VT | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
22608 | 22608 | Ernest Gibson G000158 | rep | VT | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
19294 | 19294 | Joseph Deal D000169 | rep | VA | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
19348 | 19348 | Thomas Harrison H000277 | rep | VA | 1927-12-05 | 1929-03-03 | Democrat | 7 | |||||||||||||
19463 | 19463 | George Peery P000186 | rep | VA | 1927-12-05 | 1929-03-03 | Democrat | 9 | |||||||||||||
19890 | 19890 | Robert Moore M000915 | rep | VA | 1927-12-05 | 1929-03-03 | Democrat | 8 | |||||||||||||
20040 | 20040 | Joseph Whitehead W000400 | rep | VA | 1927-12-05 | 1929-03-03 | Democrat | 5 | |||||||||||||
20959 | 20959 | Henry Tucker T000399 | rep | VA | 1927-12-05 | 1929-03-03 | Democrat | 10 | |||||||||||||
22323 | 22323 | Andrew Montague M000861 | rep | VA | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
24219 | 24219 | Clifton Woodrum W000720 | rep | VA | 1927-12-05 | 1929-03-03 | Democrat | 6 | |||||||||||||
24358 | 24358 | Patrick Drewry D000496 | rep | VA | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
24747 | 24747 | Schuyler Bland B000545 | rep | VA | 1927-12-05 | 1929-03-03 | Democrat | 1 | |||||||||||||
19492 | 19492 | Reed Smoot S000644 | sen | UT | 1927-12-05 | 1933-03-03 | 3 | Republican | |||||||||||||
19851 | 19851 | Elmer Leatherwood L000181 | rep | UT | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20225 | 20225 | Don Colton C000652 | rep | UT | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
19220 | 19220 | Eugene Black B000495 | rep | TX | 1927-12-05 | 1929-03-03 | Democrat | 1 | |||||||||||||
19592 | 19592 | John Box B000710 | rep | TX | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
19782 | 19782 | Claude Hudspeth H000910 | rep | TX | 1927-12-05 | 1929-03-03 | Democrat | 16 | |||||||||||||
20413 | 20413 | Daniel Garrett G000081 | rep | TX | 1927-12-05 | 1929-03-03 | Democrat | 8 | |||||||||||||
21011 | 21011 | Guinn Williams W000501 | rep | TX | 1927-12-05 | 1929-03-03 | Democrat | 13 | |||||||||||||
21042 | 21042 | Harry Wurzbach W000775 | rep | TX | 1927-12-05 | 1929-03-03 | Republican | 14 | |||||||||||||
21146 | 21146 | Clay Briggs B000826 | rep | TX | 1927-12-05 | 1929-03-03 | Democrat | 7 | |||||||||||||
21293 | 21293 | John Garner G000074 | rep | TX | 1927-12-05 | 1929-03-03 | Democrat | 15 | |||||||||||||
21648 | 21648 | Thomas Blanton B000549 | rep | TX | 1927-12-05 | 1929-03-03 | Democrat | 17 | |||||||||||||
22069 | 22069 | James Buchanan B001006 | rep | TX | 1927-12-05 | 1929-03-03 | Democrat | 10 | |||||||||||||
22388 | 22388 | Morgan Sanders S000037 | rep | TX | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
22642 | 22642 | John Jones J000236 | rep | TX | 1927-12-05 | 1929-03-03 | Democrat | 18 | |||||||||||||
23913 | 23913 | Luther Johnson J000159 | rep | TX | 1927-12-05 | 1929-03-03 | Democrat | 6 | |||||||||||||
23950 | 23950 | Fritz Lanham L000076 | rep | TX | 1927-12-05 | 1929-03-03 | Democrat | 12 | |||||||||||||
24120 | 24120 | Hatton Sumners S001072 | rep | TX | 1927-12-05 | 1929-03-03 | Democrat | 5 | |||||||||||||
24318 | 24318 | Thomas Connally C000684 | rep | TX | 1927-12-05 | 1929-03-03 | Democrat | 11 | |||||||||||||
24582 | 24582 | Joseph Mansfield M000112 | rep | TX | 1927-12-05 | 1929-03-03 | Democrat | 9 | |||||||||||||
27441 | 27441 | Samuel Rayburn R000082 | rep | TX | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
19330 | 19330 | Finis Garrett G000082 | rep | TN | 1927-12-05 | 1929-03-03 | Democrat | 9 | |||||||||||||
19708 | 19708 | Hubert Fisher F000149 | rep | TN | 1927-12-05 | 1929-03-03 | Democrat | 10 | |||||||||||||
20289 | 20289 | Ewin Davis D000098 | rep | TN | 1927-12-05 | 1929-03-03 | Democrat | 5 | |||||||||||||
20352 | 20352 | Edward Eslick E000216 | rep | TN | 1927-12-05 | 1929-03-03 | Democrat | 7 | |||||||||||||
20548 | 20548 | Cordell Hull H000940 | rep | TN | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
21165 | 21165 | Gordon Browning B000959 | rep | TN | 1927-12-05 | 1929-03-03 | Democrat | 8 | |||||||||||||
21679 | 21679 | Joseph Byrns B001217 | rep | TN | 1927-12-05 | 1929-03-03 | Democrat | 6 | |||||||||||||
22725 | 22725 | Samuel McReynolds M000598 | rep | TN | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
22809 | 22809 | James Taylor T000083 | rep | TN | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
27462 | 27462 | Brazilla Reece R000108 | rep | TN | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
20191 | 20191 | Charles Christopherson C000384 | rep | SD | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
20581 | 20581 | Royal Johnson J000173 | rep | SD | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
21017 | 21017 | William Williamson W000553 | rep | SD | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
21450 | 21450 | Peter Norbeck N000132 | sen | SD | 1927-12-05 | 1933-03-03 | 3 | Republican | |||||||||||||
20305 | 20305 | Frederick Dominick D000408 | rep | SC | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
20887 | 20887 | William Stevenson S000895 | rep | SC | 1927-12-05 | 1929-03-03 | Democrat | 5 | |||||||||||||
21875 | 21875 | John McSwain M000604 | rep | SC | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
22171 | 22171 | Allard Gasque G000092 | rep | SC | 1927-12-05 | 1929-03-03 | Democrat | 6 | |||||||||||||
22716 | 22716 | Thomas McMillan M000572 | rep | SC | 1927-12-05 | 1929-03-03 | Democrat | 1 | |||||||||||||
22788 | 22788 | Ellison Smith S000530 | sen | SC | 1927-12-05 | 1933-03-03 | 3 | Democrat | |||||||||||||
23484 | 23484 | Hampton Fulmer F000417 | rep | SC | 1927-12-05 | 1929-03-03 | Democrat | 7 | |||||||||||||
23866 | 23866 | Butler Hare H000200 | rep | SC | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
19425 | 19425 | Louis Monast M000850 | rep | RI | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
20086 | 20086 | Richard Aldrich A000084 | rep | RI | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20141 | 20141 | Clark Burdick B001075 | rep | RI | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
20335 | 20335 | Félix Dávila D000090 | rep | PR | 1927-12-05 | 1929-03-03 | Unionist | 0 | |||||||||||||
19722 | 19722 | Isauro Gabaldon G000001 | rep | PI | 1927-12-05 | 1929-03-03 | 0 | ||||||||||||||
21792 | 21792 | Pedro Guevara G000518 | rep | PI | 1927-12-05 | 1929-03-03 | 0 | ||||||||||||||
19239 | 19239 | Robert Bushong B001171 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 14 | |||||||||||||
19255 | 19255 | Thomas Butler B001192 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 8 | |||||||||||||
19349 | 19349 | James Hazlett H000421 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | -1 | |||||||||||||
19372 | 19372 | Everett Kent K000124 | rep | PA | 1927-12-05 | 1929-03-03 | Democrat | 30 | |||||||||||||
19435 | 19435 | John Morin M000961 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 34 | |||||||||||||
19460 | 19460 | Cyrus Palmer P000037 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 13 | |||||||||||||
19526 | 19526 | William Vare V000071 | sen | PA | 1927-12-05 | 1929-12-31 | 3 | Republican | |||||||||||||
19620 | 19620 | John Casey C000223 | rep | PA | 1927-12-05 | 1929-03-03 | Democrat | 12 | |||||||||||||
19750 | 19750 | William Griest G000456 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 10 | |||||||||||||
19823 | 19823 | Edgar Kiess K000168 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 16 | |||||||||||||
19872 | 19872 | Franklin Menges M000640 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 22 | |||||||||||||
19932 | 19932 | Stephen Porter P000447 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 32 | |||||||||||||
20033 | 20033 | Laurence Watres W000196 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 11 |
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);