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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19831 | 19831 | David Kincheloe K000187 | rep | KY | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
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 | |||||||||||||
19919 | 19919 | Pearl Oldfield O000061 | rep | AR | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
19951 | 19951 | Willis Sears S000212 | rep | NE | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
19967 | 19967 | James Spearing S000708 | rep | LA | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
20086 | 20086 | Richard Aldrich A000084 | rep | RI | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20150 | 20150 | Robert Butler B001187 | rep | OR | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20197 | 20197 | Frank Clague C000401 | rep | MN | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20384 | 20384 | Richard Freeman F000366 | rep | CT | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20441 | 20441 | George Graham G000354 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20451 | 20451 | Lindley Hadley H000008 | rep | WA | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20465 | 20465 | Thomas Hall H000071 | rep | ND | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20553 | 20553 | Morton Hull H000944 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20581 | 20581 | Royal Johnson J000173 | rep | SD | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20588 | 20588 | Charles Kading K000001 | rep | WI | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20646 | 20646 | Scott Leavitt L000184 | rep | MT | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20865 | 20865 | Addison Smith S000511 | rep | ID | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20949 | 20949 | Charles Timberlake T000281 | rep | CO | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20991 | 20991 | Edward Wason W000185 | rep | NH | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
21129 | 21129 | Frank Bowman B000704 | rep | WV | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
21311 | 21311 | William Hastings H000333 | rep | OK | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
21386 | 21386 | Ralph Lozier L000489 | rep | MO | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
21635 | 21635 | Isaac Bacharach B000009 | rep | NJ | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
22196 | 22196 | Arthur Greenwood G000437 | rep | IN | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
22608 | 22608 | Ernest Gibson G000158 | rep | VT | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
22809 | 22809 | James Taylor T000083 | rep | TN | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
22924 | 22924 | William Cole C000616 | rep | MD | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
23442 | 23442 | Harry Englebright E000182 | rep | CA | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
23527 | 23527 | Robert Green G000415 | rep | FL | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
23537 | 23537 | Ulysses Guyer G000538 | rep | KS | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
23752 | 23752 | Wallace White W000396 | rep | ME | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
23866 | 23866 | Butler Hare H000200 | rep | SC | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
24937 | 24937 | Earl Michener M000693 | rep | MI | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
25190 | 25190 | Edward Cox C000831 | rep | GA | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
25350 | 25350 | John Kerr K000138 | rep | NC | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
27873 | 27873 | Joseph Hill H000598 | rep | AL | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
19318 | 19318 | Frank Gardner G000053 | rep | IN | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
19425 | 19425 | Louis Monast M000850 | rep | RI | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
19442 | 19442 | William O’Brien O000018 | rep | WV | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
19510 | 19510 | John Tillman T000276 | rep | AR | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
19644 | 19644 | Charles Curry C001000 | rep | CA | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
19713 | 19713 | Roy Fitzgerald F000166 | rep | OH | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
19770 | 19770 | Harold Hoffman H000685 | rep | NJ | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
19833 | 19833 | Franklin Korell K000317 | rep | OR | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
19863 | 19863 | Whitmell Martin M000201 | rep | LA | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
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 | |||||||||||||
20268 | 20268 | Charles Crisp C000909 | rep | GA | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
20305 | 20305 | Frederick Dominick D000408 | rep | SC | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
20472 | 20472 | Guy Hardy H000195 | rep | CO | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
20571 | 20571 | Albert Johnson J000114 | rep | WA | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
20728 | 20728 | John Moore M000905 | rep | KY | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
20743 | 20743 | John Nelson N000038 | rep | ME | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
20756 | 20756 | John Nelson N000039 | rep | WI | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
20818 | 20818 | Thomas Robinson R000352 | rep | IA | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
20940 | 20940 | John Tilson T000279 | rep | CT | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
21017 | 21017 | William Williamson W000553 | rep | SD | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
21058 | 21058 | Thomas Yon Y000021 | rep | FL | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
21069 | 21069 | Charles Abernethy A000015 | rep | NC | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
21265 | 21265 | Frank Foss F000294 | rep | MA | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
21318 | 21318 | Joseph Hooper H000764 | rep | MI | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
21326 | 21326 | Edgar Howard H000836 | rep | NE | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
21375 | 21375 | George Lindsay L000325 | rep | NY | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
21434 | 21434 | Jacob Milligan M000766 | rep | MO | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
21547 | 21547 | James Sinclair S000442 | rep | ND | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
21936 | 21936 | Harry Ransley R000061 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
22323 | 22323 | Andrew Montague M000861 | rep | VA | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
22356 | 22356 | Vincent Palmisano P000046 | rep | MD | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
22388 | 22388 | Morgan Sanders S000037 | rep | TX | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
22725 | 22725 | Samuel McReynolds M000598 | rep | TN | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
22902 | 22902 | Wilburn Cartwright C000207 | rep | OK | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
23693 | 23693 | Henry Steagall S000820 | rep | AL | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
25086 | 25086 | William Whittington W000430 | rep | MS | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
26163 | 26163 | August Andresen A000239 | rep | MN | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
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 | |||||||||||||
19355 | 19355 | Ira Hersey H000544 | rep | ME | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
19427 | 19427 | Henry Moorman M000931 | rep | KY | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
19672 | 19672 | Thomas Doyle D000483 | rep | IL | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
19791 | 19791 | James Hughes H000924 | rep | WV | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
19998 | 19998 | George Stobbs S000931 | rep | MA | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
20057 | 20057 | Otis Wingo W000635 | rep | AR | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
20169 | 20169 | Harry Canfield C000114 | rep | IN | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
20423 | 20423 | Benjamin Golder G000259 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
20494 | 20494 | Gilbert Haugen H000350 | rep | IA | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
20514 | 20514 | Homer Hoch H000669 | rep | KS | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
20528 | 20528 | David Hopkins H000772 | rep | MO | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
20548 | 20548 | Cordell Hull H000940 | rep | TN | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
20602 | 20602 | John Ketcham K000151 | rep | MI | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
20661 | 20661 | John Linthicum L000340 | rep | MD | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
20764 | 20764 | John Norton N000152 | rep | NE | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
20905 | 20905 | John Summers S001067 | rep | WA | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
21036 | 21036 | William Wright W000773 | rep | GA | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
21181 | 21181 | Thomas Busby B001163 | rep | MS | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
21344 | 21344 | Lamar Jeffers J000068 | rep | AL | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
21427 | 21427 | Thomas McKeown M000511 | rep | OK | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
21495 | 21495 | Edward Pou P000474 | rep | NC | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
21834 | 21834 | Florence Kahn K000002 | rep | CA | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
21875 | 21875 | John McSwain M000604 | rep | SC | 1927-12-05 | 1929-03-03 | Democrat | 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);