legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
484 rows where "end" is on date 1927-03-04 sorted by state descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19553 | 19553 | Charles Winter W000643 | rep | WY | 1925-12-07 | 1927-03-04 | Republican | 0 | |||||||||||||
19120 | 19120 | James Taylor T000082 | rep | WV | 1925-12-07 | 1927-03-04 | Democrat | 6 | |||||||||||||
19175 | 19175 | Harry Woodyard W000737 | rep | WV | 1925-12-07 | 1927-03-04 | Republican | 4 | |||||||||||||
19498 | 19498 | James Strother S001024 | rep | WV | 1925-12-07 | 1927-03-04 | Republican | 5 | |||||||||||||
20059 | 20059 | John Wolverton W000684 | rep | WV | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
20108 | 20108 | Carl Bachmann B000012 | rep | WV | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
21128 | 21128 | Frank Bowman B000704 | rep | WV | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
18312 | 18312 | Irvine Lenroot L000241 | sen | WI | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
19145 | 19145 | Edward Voigt V000110 | rep | WI | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
19200 | 19200 | Joseph Beck B000291 | rep | WI | 1925-12-07 | 1927-03-04 | Republican | 7 | |||||||||||||
19210 | 19210 | Victor Berger B000407 | rep | WI | 1925-12-07 | 1927-03-04 | Socialist | 5 | |||||||||||||
19604 | 19604 | Edward Browne B000955 | rep | WI | 1925-12-07 | 1927-03-04 | Republican | 8 | |||||||||||||
19843 | 19843 | Florian Lampert L000041 | rep | WI | 1925-12-07 | 1927-03-04 | Republican | 6 | |||||||||||||
20246 | 20246 | Henry Cooper C000752 | rep | WI | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
20755 | 20755 | John Nelson N000039 | rep | WI | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
21276 | 21276 | James Frear F000355 | rep | WI | 1925-12-07 | 1927-03-04 | Republican | 10 | |||||||||||||
21476 | 21476 | Hubert Peavey P000174 | rep | WI | 1925-12-07 | 1927-03-04 | Republican | 11 | |||||||||||||
22395 | 22395 | George Schneider S000137 | rep | WI | 1925-12-07 | 1927-03-04 | Republican | 9 | |||||||||||||
22760 | 22760 | John Schafer S000111 | rep | WI | 1925-12-07 | 1927-03-04 | Republican | 4 | |||||||||||||
19369 | 19369 | Wesley Jones J000257 | sen | WA | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
19883 | 19883 | John Miller M000739 | rep | WA | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
20450 | 20450 | Lindley Hadley H000008 | rep | WA | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20570 | 20570 | Albert Johnson J000114 | rep | WA | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
20904 | 20904 | John Summers S001067 | rep | WA | 1925-12-07 | 1927-03-04 | Republican | 4 | |||||||||||||
21806 | 21806 | Samuel Hill H000607 | rep | WA | 1925-12-07 | 1927-03-04 | Democrat | 5 | |||||||||||||
19284 | 19284 | Porter Dale D000009 | sen | VT | 1923-12-03 | 1927-03-04 | 3 | Republican | |||||||||||||
19594 | 19594 | Elbert Brigham B000832 | rep | VT | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
22607 | 22607 | Ernest Gibson G000158 | rep | VT | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
19293 | 19293 | Joseph Deal D000169 | rep | VA | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
19347 | 19347 | Thomas Harrison H000277 | rep | VA | 1925-12-07 | 1927-03-04 | Democrat | 7 | |||||||||||||
19462 | 19462 | George Peery P000186 | rep | VA | 1925-12-07 | 1927-03-04 | Democrat | 9 | |||||||||||||
19889 | 19889 | Robert Moore M000915 | rep | VA | 1925-12-07 | 1927-03-04 | Democrat | 8 | |||||||||||||
20039 | 20039 | Joseph Whitehead W000400 | rep | VA | 1925-12-07 | 1927-03-04 | Democrat | 5 | |||||||||||||
20958 | 20958 | Henry Tucker T000399 | rep | VA | 1925-12-07 | 1927-03-04 | Democrat | 10 | |||||||||||||
22322 | 22322 | Andrew Montague M000861 | rep | VA | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
24218 | 24218 | Clifton Woodrum W000720 | rep | VA | 1925-12-07 | 1927-03-04 | Democrat | 6 | |||||||||||||
24357 | 24357 | Patrick Drewry D000496 | rep | VA | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
24746 | 24746 | Schuyler Bland B000545 | rep | VA | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
19491 | 19491 | Reed Smoot S000644 | sen | UT | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
19850 | 19850 | Elmer Leatherwood L000181 | rep | UT | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20224 | 20224 | Don Colton C000652 | rep | UT | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
19219 | 19219 | Eugene Black B000495 | rep | TX | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
19591 | 19591 | John Box B000710 | rep | TX | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
19781 | 19781 | Claude Hudspeth H000910 | rep | TX | 1925-12-07 | 1927-03-04 | Democrat | 16 | |||||||||||||
20412 | 20412 | Daniel Garrett G000081 | rep | TX | 1925-12-07 | 1927-03-04 | Democrat | 8 | |||||||||||||
21010 | 21010 | Guinn Williams W000501 | rep | TX | 1925-12-07 | 1927-03-04 | Democrat | 13 | |||||||||||||
21041 | 21041 | Harry Wurzbach W000775 | rep | TX | 1925-12-07 | 1927-03-04 | Republican | 14 | |||||||||||||
21145 | 21145 | Clay Briggs B000826 | rep | TX | 1925-12-07 | 1927-03-04 | Democrat | 7 | |||||||||||||
21292 | 21292 | John Garner G000074 | rep | TX | 1925-12-07 | 1927-03-04 | Democrat | 15 | |||||||||||||
21647 | 21647 | Thomas Blanton B000549 | rep | TX | 1925-12-07 | 1927-03-04 | Democrat | 17 | |||||||||||||
22068 | 22068 | James Buchanan B001006 | rep | TX | 1925-12-07 | 1927-03-04 | Democrat | 10 | |||||||||||||
22387 | 22387 | Morgan Sanders S000037 | rep | TX | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
22641 | 22641 | John Jones J000236 | rep | TX | 1925-12-07 | 1927-03-04 | Democrat | 18 | |||||||||||||
23912 | 23912 | Luther Johnson J000159 | rep | TX | 1925-12-07 | 1927-03-04 | Democrat | 6 | |||||||||||||
23949 | 23949 | Fritz Lanham L000076 | rep | TX | 1925-12-07 | 1927-03-04 | Democrat | 12 | |||||||||||||
24119 | 24119 | Hatton Sumners S001072 | rep | TX | 1925-12-07 | 1927-03-04 | Democrat | 5 | |||||||||||||
24317 | 24317 | Thomas Connally C000684 | rep | TX | 1925-12-07 | 1927-03-04 | Democrat | 11 | |||||||||||||
24581 | 24581 | Joseph Mansfield M000112 | rep | TX | 1925-12-07 | 1927-03-04 | Democrat | 9 | |||||||||||||
27440 | 27440 | Samuel Rayburn R000082 | rep | TX | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
19329 | 19329 | Finis Garrett G000082 | rep | TN | 1925-12-07 | 1927-03-04 | Democrat | 9 | |||||||||||||
19707 | 19707 | Hubert Fisher F000149 | rep | TN | 1925-12-07 | 1927-03-04 | Democrat | 10 | |||||||||||||
20288 | 20288 | Ewin Davis D000098 | rep | TN | 1925-12-07 | 1927-03-04 | Democrat | 5 | |||||||||||||
20351 | 20351 | Edward Eslick E000216 | rep | TN | 1925-12-07 | 1927-03-04 | Democrat | 7 | |||||||||||||
20547 | 20547 | Cordell Hull H000940 | rep | TN | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
21164 | 21164 | Gordon Browning B000959 | rep | TN | 1925-12-07 | 1927-03-04 | Democrat | 8 | |||||||||||||
21678 | 21678 | Joseph Byrns B001217 | rep | TN | 1925-12-07 | 1927-03-04 | Democrat | 6 | |||||||||||||
22724 | 22724 | Samuel McReynolds M000598 | rep | TN | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
22808 | 22808 | James Taylor T000083 | rep | TN | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
27461 | 27461 | Brazilla Reece R000108 | rep | TN | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
20190 | 20190 | Charles Christopherson C000384 | rep | SD | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
20580 | 20580 | Royal Johnson J000173 | rep | SD | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
21016 | 21016 | William Williamson W000553 | rep | SD | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
21449 | 21449 | Peter Norbeck N000132 | sen | SD | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
20304 | 20304 | Frederick Dominick D000408 | rep | SC | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
20886 | 20886 | William Stevenson S000895 | rep | SC | 1925-12-07 | 1927-03-04 | Democrat | 5 | |||||||||||||
21874 | 21874 | John McSwain M000604 | rep | SC | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
22170 | 22170 | Allard Gasque G000092 | rep | SC | 1925-12-07 | 1927-03-04 | Democrat | 6 | |||||||||||||
22715 | 22715 | Thomas McMillan M000572 | rep | SC | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
22787 | 22787 | Ellison Smith S000530 | sen | SC | 1921-04-11 | 1927-03-04 | 3 | Democrat | |||||||||||||
23483 | 23483 | Hampton Fulmer F000417 | rep | SC | 1925-12-07 | 1927-03-04 | Democrat | 7 | |||||||||||||
23865 | 23865 | Butler Hare H000200 | rep | SC | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
19910 | 19910 | Jeremiah O’Connell O000023 | rep | RI | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
20085 | 20085 | Richard Aldrich A000084 | rep | RI | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20140 | 20140 | Clark Burdick B001075 | rep | RI | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
20334 | 20334 | Félix Dávila D000090 | rep | PR | 1925-12-07 | 1927-03-04 | Unionist | 0 | |||||||||||||
19721 | 19721 | Isauro Gabaldon G000001 | rep | PI | 1925-12-07 | 1927-03-04 | 0 | ||||||||||||||
21791 | 21791 | Pedro Guevara G000518 | rep | PI | 1925-12-07 | 1927-03-04 | 0 | ||||||||||||||
18561 | 18561 | George Pepper P000219 | sen | PA | 1922-01-09 | 1927-03-04 | 3 | Republican | appointment | ||||||||||||
18913 | 18913 | Harris Bixler B000493 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 28 | |||||||||||||
18915 | 18915 | Edmund Carpenter C000168 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 12 | |||||||||||||
19036 | 19036 | James Magee M000046 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 35 | |||||||||||||
19059 | 19059 | Thomas Phillips P000314 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 26 | |||||||||||||
19114 | 19114 | Joshua Swartz S001097 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 19 | |||||||||||||
19116 | 19116 | William Swoope S001126 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 23 | |||||||||||||
19149 | 19149 | Anderson Walters W000109 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 20 | |||||||||||||
19254 | 19254 | Thomas Butler B001192 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 8 | |||||||||||||
19434 | 19434 | John Morin M000961 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 34 | |||||||||||||
19525 | 19525 | William Vare V000071 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
19689 | 19689 | Charles Esterly E000222 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 14 | |||||||||||||
19749 | 19749 | William Griest G000456 | rep | PA | 1925-12-07 | 1927-03-04 | 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);