legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
502 rows where "end" is on date 1931-03-03 sorted by district
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19832 | 19832 | David Kincheloe K000187 | rep | KY | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
19852 | 19852 | Elmer Leatherwood L000181 | rep | UT | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
19856 | 19856 | Fred Letts L000258 | rep | IA | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
19920 | 19920 | Pearl Oldfield O000061 | rep | AR | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
19952 | 19952 | Willis Sears S000212 | rep | NE | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
19968 | 19968 | James Spearing S000708 | rep | LA | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
20087 | 20087 | Richard Aldrich A000084 | rep | RI | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20151 | 20151 | Robert Butler B001187 | rep | OR | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20198 | 20198 | Frank Clague C000401 | rep | MN | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20385 | 20385 | Richard Freeman F000366 | rep | CT | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20442 | 20442 | George Graham G000354 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20452 | 20452 | Lindley Hadley H000008 | rep | WA | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20466 | 20466 | Thomas Hall H000071 | rep | ND | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20554 | 20554 | Morton Hull H000944 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20582 | 20582 | Royal Johnson J000173 | rep | SD | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20589 | 20589 | Charles Kading K000001 | rep | WI | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20627 | 20627 | Menalcus Lankford L000080 | rep | VA | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20647 | 20647 | Scott Leavitt L000184 | rep | MT | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20678 | 20678 | Frederick Loofbourow L000435 | rep | UT | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20866 | 20866 | Addison Smith S000511 | rep | ID | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20950 | 20950 | Charles Timberlake T000281 | rep | CO | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20992 | 20992 | Edward Wason W000185 | rep | NH | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
21130 | 21130 | Frank Bowman B000704 | rep | WV | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
21312 | 21312 | William Hastings H000333 | rep | OK | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
21387 | 21387 | Ralph Lozier L000489 | rep | MO | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
21636 | 21636 | Isaac Bacharach B000009 | rep | NJ | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
21657 | 21657 | William Brunner B000981 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
21769 | 21769 | William Granfield G000372 | rep | MA | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
22197 | 22197 | Arthur Greenwood G000437 | rep | IN | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
22609 | 22609 | Ernest Gibson G000158 | rep | VT | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
22810 | 22810 | James Taylor T000083 | rep | TN | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
22963 | 22963 | Wall Doxey D000480 | rep | MS | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
23443 | 23443 | Harry Englebright E000182 | rep | CA | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
23528 | 23528 | Robert Green G000415 | rep | FL | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
23538 | 23538 | Ulysses Guyer G000538 | rep | KS | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
23753 | 23753 | Wallace White W000396 | rep | ME | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
23867 | 23867 | Butler Hare H000200 | rep | SC | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
24938 | 24938 | Earl Michener M000693 | rep | MI | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
25191 | 25191 | Edward Cox C000831 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
25351 | 25351 | John Kerr K000138 | rep | NC | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
26867 | 26867 | William Hess H000550 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
27874 | 27874 | Joseph Hill H000598 | rep | AL | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
19645 | 19645 | Charles Curry C001000 | rep | CA | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
19676 | 19676 | James Dunbar D000525 | rep | IN | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
19714 | 19714 | Roy Fitzgerald F000166 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
19771 | 19771 | Harold Hoffman H000685 | rep | NJ | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
19834 | 19834 | Franklin Korell K000317 | rep | OR | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
19911 | 19911 | Jeremiah O’Connell O000023 | rep | RI | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
19973 | 19973 | Elliott Sproul S000758 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
19977 | 19977 | William Sproul S000759 | rep | KS | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
20060 | 20060 | John Wolverton W000684 | rep | WV | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
20269 | 20269 | Charles Crisp C000909 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
20306 | 20306 | Frederick Dominick D000408 | rep | SC | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
20473 | 20473 | Guy Hardy H000195 | rep | CO | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
20572 | 20572 | Albert Johnson J000114 | rep | WA | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
20729 | 20729 | John Moore M000905 | rep | KY | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
20744 | 20744 | John Nelson N000038 | rep | ME | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
20757 | 20757 | John Nelson N000039 | rep | WI | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
20819 | 20819 | Thomas Robinson R000352 | rep | IA | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
20941 | 20941 | John Tilson T000279 | rep | CT | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
21018 | 21018 | William Williamson W000553 | rep | SD | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
21059 | 21059 | Thomas Yon Y000021 | rep | FL | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
21070 | 21070 | Charles Abernethy A000015 | rep | NC | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
21266 | 21266 | Frank Foss F000294 | rep | MA | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
21319 | 21319 | Joseph Hooper H000764 | rep | MI | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
21327 | 21327 | Edgar Howard H000836 | rep | NE | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
21376 | 21376 | George Lindsay L000325 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
21435 | 21435 | Jacob Milligan M000766 | rep | MO | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
21548 | 21548 | James Sinclair S000442 | rep | ND | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
21706 | 21706 | Francis Condon C000673 | rep | RI | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
21892 | 21892 | Numa Montet M000862 | rep | LA | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
21937 | 21937 | Harry Ransley R000061 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
22156 | 22156 | Claude Fuller F000408 | rep | AR | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
22324 | 22324 | Andrew Montague M000861 | rep | VA | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
22357 | 22357 | Vincent Palmisano P000046 | rep | MD | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
22389 | 22389 | Morgan Sanders S000037 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
22726 | 22726 | Samuel McReynolds M000598 | rep | TN | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
22903 | 22903 | Wilburn Cartwright C000207 | rep | OK | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
23694 | 23694 | Henry Steagall S000820 | rep | AL | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
25087 | 25087 | William Whittington W000430 | rep | MS | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
26164 | 26164 | August Andresen A000239 | rep | MN | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
19627 | 19627 | John Craddock C000849 | rep | KY | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
19673 | 19673 | Thomas Doyle D000483 | rep | IL | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
19792 | 19792 | James Hughes H000924 | rep | WV | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
19959 | 19959 | Charles Sloan S000491 | rep | NE | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
19999 | 19999 | George Stobbs S000931 | rep | MA | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
20058 | 20058 | Otis Wingo W000635 | rep | AR | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
20155 | 20155 | John Cable C000007 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
20170 | 20170 | Harry Canfield C000114 | rep | IN | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
20424 | 20424 | Benjamin Golder G000259 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
20495 | 20495 | Gilbert Haugen H000350 | rep | IA | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
20515 | 20515 | Homer Hoch H000669 | rep | KS | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
20521 | 20521 | Robert Hogg H000704 | rep | WV | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
20529 | 20529 | David Hopkins H000772 | rep | MO | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
20549 | 20549 | Cordell Hull H000940 | rep | TN | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
20603 | 20603 | John Ketcham K000151 | rep | MI | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
20662 | 20662 | John Linthicum L000340 | rep | MD | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
20766 | 20766 | Ruth Owen O000154 | rep | FL | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
20868 | 20868 | Donald Snow S000659 | rep | ME | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
20906 | 20906 | John Summers S001067 | rep | WA | 1929-04-15 | 1931-03-03 | Republican | 4 |
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);