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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19453 | 19453 | William Oldfield O000062 | rep | AR | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
19486 | 19486 | Nicholas Sinnott S000450 | rep | OR | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
19496 | 19496 | Ambrose Stephens S000855 | rep | OH | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
19591 | 19591 | John Box B000710 | rep | TX | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
19830 | 19830 | David Kincheloe K000187 | rep | KY | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
19850 | 19850 | Elmer Leatherwood L000181 | rep | UT | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
19854 | 19854 | Fred Letts L000258 | rep | IA | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
19950 | 19950 | Willis Sears S000212 | rep | NE | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
19966 | 19966 | James Spearing S000708 | rep | LA | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
20085 | 20085 | Richard Aldrich A000084 | rep | RI | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20196 | 20196 | Frank Clague C000401 | rep | MN | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20383 | 20383 | Richard Freeman F000366 | rep | CT | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20440 | 20440 | George Graham G000354 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20450 | 20450 | Lindley Hadley H000008 | rep | WA | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20464 | 20464 | Thomas Hall H000071 | rep | ND | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20552 | 20552 | Morton Hull H000944 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20580 | 20580 | Royal Johnson J000173 | rep | SD | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20645 | 20645 | Scott Leavitt L000184 | rep | MT | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20864 | 20864 | Addison Smith S000511 | rep | ID | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20948 | 20948 | Charles Timberlake T000281 | rep | CO | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20990 | 20990 | Edward Wason W000185 | rep | NH | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
21128 | 21128 | Frank Bowman B000704 | rep | WV | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
21310 | 21310 | William Hastings H000333 | rep | OK | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
21385 | 21385 | Ralph Lozier L000489 | rep | MO | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
21634 | 21634 | Isaac Bacharach B000009 | rep | NJ | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
22195 | 22195 | Arthur Greenwood G000437 | rep | IN | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
22607 | 22607 | Ernest Gibson G000158 | rep | VT | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
22808 | 22808 | James Taylor T000083 | rep | TN | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
23441 | 23441 | Harry Englebright E000182 | rep | CA | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
23526 | 23526 | Robert Green G000415 | rep | FL | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
23751 | 23751 | Wallace White W000396 | rep | ME | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
23865 | 23865 | Butler Hare H000200 | rep | SC | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
24169 | 24169 | Millard Tydings T000446 | rep | MD | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
24936 | 24936 | Earl Michener M000693 | rep | MI | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
25189 | 25189 | Edward Cox C000831 | rep | GA | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
25349 | 25349 | John Kerr K000138 | rep | NC | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
27872 | 27872 | Joseph Hill H000598 | rep | AL | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
18909 | 18909 | Stewart Appleby A000266 | rep | NJ | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
18925 | 18925 | Charles Carter C000196 | rep | OK | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
18992 | 18992 | John Hill H000597 | rep | MD | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
19112 | 19112 | John Smithwick S000643 | rep | FL | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
19130 | 19130 | Robert Thomas T000185 | rep | KY | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
19165 | 19165 | Arthur Williams W000490 | rep | MI | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
19267 | 19267 | Maurice Crumpacker C000959 | rep | OR | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
19317 | 19317 | Frank Gardner G000053 | rep | IN | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
19509 | 19509 | John Tillman T000276 | rep | AR | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
19643 | 19643 | Charles Curry C001000 | rep | CA | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
19712 | 19712 | Roy Fitzgerald F000166 | rep | OH | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
19862 | 19862 | Whitmell Martin M000201 | rep | LA | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
19910 | 19910 | Jeremiah O’Connell O000023 | rep | RI | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
19971 | 19971 | Elliott Sproul S000758 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
19975 | 19975 | William Sproul S000759 | rep | KS | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
20059 | 20059 | John Wolverton W000684 | rep | WV | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
20267 | 20267 | Charles Crisp C000909 | rep | GA | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
20304 | 20304 | Frederick Dominick D000408 | rep | SC | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
20471 | 20471 | Guy Hardy H000195 | rep | CO | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
20570 | 20570 | Albert Johnson J000114 | rep | WA | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
20727 | 20727 | John Moore M000905 | rep | KY | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
20742 | 20742 | John Nelson N000038 | rep | ME | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
20755 | 20755 | John Nelson N000039 | rep | WI | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
20817 | 20817 | Thomas Robinson R000352 | rep | IA | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
20939 | 20939 | John Tilson T000279 | rep | CT | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
21016 | 21016 | William Williamson W000553 | rep | SD | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
21068 | 21068 | Charles Abernethy A000015 | rep | NC | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
21264 | 21264 | Frank Foss F000294 | rep | MA | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
21317 | 21317 | Joseph Hooper H000764 | rep | MI | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
21325 | 21325 | Edgar Howard H000836 | rep | NE | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
21374 | 21374 | George Lindsay L000325 | rep | NY | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
21433 | 21433 | Jacob Milligan M000766 | rep | MO | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
21546 | 21546 | James Sinclair S000442 | rep | ND | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
21935 | 21935 | Harry Ransley R000061 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
22322 | 22322 | Andrew Montague M000861 | rep | VA | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
22387 | 22387 | Morgan Sanders S000037 | rep | TX | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
22724 | 22724 | Samuel McReynolds M000598 | rep | TN | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
23692 | 23692 | Henry Steagall S000820 | rep | AL | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
25085 | 25085 | William Whittington W000430 | rep | MS | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
26162 | 26162 | August Andresen A000239 | rep | MN | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
19004 | 19004 | Ben Johnson J000118 | rep | KY | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
19008 | 19008 | Oscar Keller K000057 | rep | MN | 1925-12-07 | 1927-03-04 | Republican | 4 | |||||||||||||
19040 | 19040 | Melvin McLaughlin M000541 | rep | NE | 1925-12-07 | 1927-03-04 | Republican | 4 | |||||||||||||
19175 | 19175 | Harry Woodyard W000737 | rep | WV | 1925-12-07 | 1927-03-04 | Republican | 4 | |||||||||||||
19298 | 19298 | Charles Faust F000047 | rep | MO | 1925-12-07 | 1927-03-04 | Republican | 4 | |||||||||||||
19300 | 19300 | William Fitzgerald F000170 | rep | OH | 1925-12-07 | 1927-03-04 | Republican | 4 | |||||||||||||
19354 | 19354 | Ira Hersey H000544 | rep | ME | 1925-12-07 | 1927-03-04 | Republican | 4 | |||||||||||||
19671 | 19671 | Thomas Doyle D000483 | rep | IL | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
19997 | 19997 | George Stobbs S000931 | rep | MA | 1925-12-07 | 1927-03-04 | Republican | 4 | |||||||||||||
20056 | 20056 | Otis Wingo W000635 | rep | AR | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
20168 | 20168 | Harry Canfield C000114 | rep | IN | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
20422 | 20422 | Benjamin Golder G000259 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 4 | |||||||||||||
20493 | 20493 | Gilbert Haugen H000350 | rep | IA | 1925-12-07 | 1927-03-04 | Republican | 4 | |||||||||||||
20513 | 20513 | Homer Hoch H000669 | rep | KS | 1925-12-07 | 1927-03-04 | Republican | 4 | |||||||||||||
20547 | 20547 | Cordell Hull H000940 | rep | TN | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
20601 | 20601 | John Ketcham K000151 | rep | MI | 1925-12-07 | 1927-03-04 | Republican | 4 | |||||||||||||
20660 | 20660 | John Linthicum L000340 | rep | MD | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
20904 | 20904 | John Summers S001067 | rep | WA | 1925-12-07 | 1927-03-04 | Republican | 4 | |||||||||||||
21035 | 21035 | William Wright W000773 | rep | GA | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
21180 | 21180 | Thomas Busby B001163 | rep | MS | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
21343 | 21343 | Lamar Jeffers J000068 | rep | AL | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
21426 | 21426 | Thomas McKeown M000511 | rep | OK | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
21494 | 21494 | Edward Pou P000474 | rep | NC | 1925-12-07 | 1927-03-04 | 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);