legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
489 rows where "end" is on date 1929-03-03 sorted by party descending
This data as json, copyable, CSV (advanced)
Suggested facets: party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20335 | 20335 | Félix Dávila D000090 | rep | PR | 1927-12-05 | 1929-03-03 | Unionist | 0 | |||||||||||||
19211 | 19211 | Victor Berger B000407 | rep | WI | 1927-12-05 | 1929-03-03 | Socialist | 5 | |||||||||||||
18758 | 18758 | George McLean M000547 | sen | CT | 1923-12-03 | 1929-03-03 | 1 | Republican | |||||||||||||
19177 | 19177 | Thomas du Pont D000560 | sen | DE | 1925-12-07 | 1929-03-03 | 2 | Republican | |||||||||||||
19197 | 19197 | Daniel Anthony A000261 | rep | KS | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
19201 | 19201 | Joseph Beck B000291 | rep | WI | 1927-12-05 | 1929-03-03 | Republican | 7 | |||||||||||||
19206 | 19206 | James Begg B000314 | rep | OH | 1927-12-05 | 1929-03-03 | Republican | 13 | |||||||||||||
19226 | 19226 | William Boies B000597 | rep | IA | 1927-12-05 | 1929-03-03 | Republican | 11 | |||||||||||||
19228 | 19228 | Henry Bowles B000700 | rep | MA | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
19268 | 19268 | Maurice Crumpacker C000959 | rep | OR | 1927-12-05 | 1929-03-03 | Republican | -1 | |||||||||||||
19295 | 19295 | Edward England E000180 | rep | WV | 1927-12-05 | 1929-03-03 | Republican | 6 | |||||||||||||
19299 | 19299 | Charles Faust F000047 | rep | MO | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
19301 | 19301 | William Fitzgerald F000170 | rep | OH | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
19305 | 19305 | Louis Frothingham F000395 | rep | MA | 1927-12-05 | 1929-03-03 | Republican | 14 | |||||||||||||
19307 | 19307 | Allen Furlow F000433 | rep | MN | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
19332 | 19332 | Frank Gooding G000288 | sen | ID | 1927-12-05 | 1929-03-03 | 3 | Republican | |||||||||||||
19341 | 19341 | William Green G000422 | rep | IA | 1927-12-05 | 1929-03-03 | Republican | 9 | |||||||||||||
19349 | 19349 | James Hazlett H000421 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | -1 | |||||||||||||
19355 | 19355 | Ira Hersey H000544 | rep | ME | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
19384 | 19384 | Edward King K000200 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 15 | |||||||||||||
19405 | 19405 | Clarence MacGregor M000009 | rep | NY | 1927-12-05 | 1929-03-03 | Republican | 41 | |||||||||||||
19417 | 19417 | Martin Madden M000038 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
19424 | 19424 | Walter Magee M000049 | rep | NY | 1927-12-05 | 1929-03-03 | Republican | -1 | |||||||||||||
19425 | 19425 | Louis Monast M000850 | rep | RI | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
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 | |||||||||||||
19466 | 19466 | Henry Rathbone R000068 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | -1 | |||||||||||||
19487 | 19487 | Nicholas Sinnott S000450 | rep | OR | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
19497 | 19497 | Ambrose Stephens S000855 | rep | OH | 1927-12-05 | 1929-03-03 | Republican | -1 | |||||||||||||
19499 | 19499 | James Strother S001024 | rep | WV | 1927-12-05 | 1929-03-03 | Republican | 5 | |||||||||||||
19502 | 19502 | Thaddeus Sweet S001109 | rep | NY | 1927-12-05 | 1929-03-03 | Republican | 32 | |||||||||||||
19503 | 19503 | Charles Tatgenhorst T000049 | rep | OH | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
19512 | 19512 | Ralph Updike U000020 | rep | IN | 1927-12-05 | 1929-03-03 | Republican | 7 | |||||||||||||
19517 | 19517 | William Vaile V000004 | rep | CO | 1927-12-05 | 1929-03-03 | Republican | -1 | |||||||||||||
19527 | 19527 | Earl Vincent V000102 | rep | IA | 1927-12-05 | 1929-03-03 | Republican | 9 | |||||||||||||
19543 | 19543 | Hays White W000374 | rep | KS | 1927-12-05 | 1929-03-03 | Republican | 6 | |||||||||||||
19548 | 19548 | Frank Willis W000561 | sen | OH | 1927-12-05 | 1929-03-03 | 3 | Republican | |||||||||||||
19554 | 19554 | Charles Winter W000643 | rep | WY | 1927-12-05 | 1929-03-03 | Republican | 0 | |||||||||||||
19569 | 19569 | Octaviano Larrazolo L000101 | sen | NM | 1928-12-07 | 1929-03-03 | 1 | Republican | |||||||||||||
19595 | 19595 | Elbert Brigham B000832 | rep | VT | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
19605 | 19605 | Edward Browne B000955 | rep | WI | 1927-12-05 | 1929-03-03 | Republican | 8 | |||||||||||||
19624 | 19624 | William Chalmers C000274 | rep | OH | 1927-12-05 | 1929-03-03 | Republican | 9 | |||||||||||||
19635 | 19635 | Louis Cramton C000870 | rep | MI | 1927-12-05 | 1929-03-03 | Republican | 7 | |||||||||||||
19644 | 19644 | Charles Curry C001000 | rep | CA | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
19655 | 19655 | Stephen Dempsey D000229 | rep | NY | 1927-12-05 | 1929-03-03 | Republican | 40 | |||||||||||||
19663 | 19663 | Edward Denison D000237 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 25 | |||||||||||||
19682 | 19682 | Richard Elliott E000127 | rep | IN | 1927-12-05 | 1929-03-03 | Republican | 6 | |||||||||||||
19694 | 19694 | Edward Fenn F000072 | rep | CT | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
19701 | 19701 | Simeon Fess F000096 | sen | OH | 1923-12-03 | 1929-03-03 | 1 | Republican | |||||||||||||
19713 | 19713 | Roy Fitzgerald F000166 | rep | OH | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
19716 | 19716 | Franklin Fort F000287 | rep | NJ | 1927-12-05 | 1929-03-03 | Republican | 9 | |||||||||||||
19730 | 19730 | James Glynn G000246 | rep | CT | 1927-12-05 | 1929-03-03 | Republican | 5 | |||||||||||||
19739 | 19739 | Frank Greene G000425 | sen | VT | 1923-12-03 | 1929-03-03 | 1 | Republican | |||||||||||||
19750 | 19750 | William Griest G000456 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 10 | |||||||||||||
19754 | 19754 | Albert Hall H000042 | rep | IN | 1927-12-05 | 1929-03-03 | Republican | 11 | |||||||||||||
19768 | 19768 | Andrew Hickey H000560 | rep | IN | 1927-12-05 | 1929-03-03 | Republican | 13 | |||||||||||||
19770 | 19770 | Harold Hoffman H000685 | rep | NJ | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
19772 | 19772 | Robert Howell H000868 | sen | NE | 1923-12-03 | 1929-03-03 | 1 | Republican | |||||||||||||
19776 | 19776 | Grant Hudson H000908 | rep | MI | 1927-12-05 | 1929-03-03 | Republican | 6 | |||||||||||||
19791 | 19791 | James Hughes H000924 | rep | WV | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
19794 | 19794 | Edward Irwin I000040 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 22 | |||||||||||||
19808 | 19808 | Charles Kearns K000033 | rep | OH | 1927-12-05 | 1929-03-03 | Republican | 6 | |||||||||||||
19823 | 19823 | Edgar Kiess K000168 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 16 | |||||||||||||
19833 | 19833 | Franklin Korell K000317 | rep | OR | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
19844 | 19844 | Florian Lampert L000041 | rep | WI | 1927-12-05 | 1929-03-03 | Republican | 6 | |||||||||||||
19846 | 19846 | Katherine Langley L000073 | rep | KY | 1927-12-05 | 1929-03-03 | Republican | 10 | |||||||||||||
19851 | 19851 | Elmer Leatherwood L000181 | rep | UT | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
19855 | 19855 | Fred Letts L000258 | rep | IA | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
19872 | 19872 | Franklin Menges M000640 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 22 | |||||||||||||
19877 | 19877 | Magne Michaelson M000690 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 7 | |||||||||||||
19884 | 19884 | John Miller M000739 | rep | WA | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
19895 | 19895 | William Morgan M000959 | rep | OH | 1927-12-05 | 1929-03-03 | Republican | 17 | |||||||||||||
19902 | 19902 | Walter Newton N000079 | rep | MN | 1927-12-05 | 1929-03-03 | Republican | 5 | |||||||||||||
19932 | 19932 | Stephen Porter P000447 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 32 | |||||||||||||
19941 | 19941 | David Reed R000114 | sen | PA | 1923-12-03 | 1929-03-03 | 1 | Republican | |||||||||||||
19944 | 19944 | Arthur Robinson R000332 | sen | IN | 1925-12-07 | 1929-03-03 | 1 | Republican | appointment | ||||||||||||
19947 | 19947 | Harry Rowbottom R000474 | rep | IN | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
19951 | 19951 | Willis Sears S000212 | rep | NE | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
19963 | 19963 | John Speaks S000707 | rep | OH | 1927-12-05 | 1929-03-03 | Republican | 12 | |||||||||||||
19972 | 19972 | Elliott Sproul S000758 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
19976 | 19976 | William Sproul S000759 | rep | KS | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
19998 | 19998 | George Stobbs S000931 | rep | MA | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
20005 | 20005 | Daniel Sutherland S001079 | rep | AK | 1927-12-05 | 1929-03-03 | Republican | 0 | |||||||||||||
20023 | 20023 | Charles Thompson T000194 | rep | OH | 1927-12-05 | 1929-03-03 | Republican | 5 | |||||||||||||
20027 | 20027 | Jonathan Wainwright W000023 | rep | NY | 1927-12-05 | 1929-03-03 | Republican | 25 | |||||||||||||
20033 | 20033 | Laurence Watres W000196 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 11 | |||||||||||||
20048 | 20048 | Thomas Williams W000542 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 24 | |||||||||||||
20066 | 20066 | Frederick Zihlman Z000007 | rep | MD | 1927-12-05 | 1929-03-03 | Republican | 6 | |||||||||||||
20077 | 20077 | Ernest Ackerman A000021 | rep | NJ | 1927-12-05 | 1929-03-03 | Republican | 5 | |||||||||||||
20081 | 20081 | Charles Adkins A000057 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 19 | |||||||||||||
20086 | 20086 | Richard Aldrich A000084 | rep | RI | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20090 | 20090 | John Allen A000131 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 14 | |||||||||||||
20095 | 20095 | Samuel Arentz A000277 | rep | NV | 1927-12-05 | 1929-03-03 | Republican | 0 | |||||||||||||
20109 | 20109 | Carl Bachmann B000012 | rep | WV | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
20117 | 20117 | Henry Barbour B000126 | rep | CA | 1927-12-05 | 1929-03-03 | Republican | 7 | |||||||||||||
20123 | 20123 | Edward Beers B000312 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 18 | |||||||||||||
20127 | 20127 | Frank Bohn B000596 | rep | MI | 1927-12-05 | 1929-03-03 | Republican | 11 | |||||||||||||
20132 | 20132 | Charles Brand B000766 | rep | OH | 1927-12-05 | 1929-03-03 | Republican | 7 |
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);