legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
499 rows where "start" is on date 1929-04-15
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20618 | 20618 | Stanley Kunz K000342 | rep | IL | 1929-04-15 | 1931-03-03 | Democrat | 8 | |||||||||||||
20625 | 20625 | Fiorello La Guardia L000007 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 20 | |||||||||||||
20627 | 20627 | Menalcus Lankford L000080 | rep | VA | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20634 | 20634 | William Lankford L000082 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 11 | |||||||||||||
20642 | 20642 | William Larsen L000103 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 12 | |||||||||||||
20647 | 20647 | Scott Leavitt L000184 | rep | MT | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20650 | 20650 | James Leech L000209 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 20 | |||||||||||||
20662 | 20662 | John Linthicum L000340 | rep | MD | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
20676 | 20676 | Nicholas Longworth L000433 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
20678 | 20678 | Frederick Loofbourow L000435 | rep | UT | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20683 | 20683 | Frederick Magrady M000055 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 17 | |||||||||||||
20693 | 20693 | Joe Manlove M000098 | rep | MO | 1929-04-15 | 1931-03-03 | Republican | 15 | |||||||||||||
20695 | 20695 | Charles McClintock M000339 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 16 | |||||||||||||
20708 | 20708 | James McLaughlin M000539 | rep | MI | 1929-04-15 | 1931-03-03 | Republican | 9 | |||||||||||||
20718 | 20718 | Charles Mooney M000887 | rep | OH | 1929-04-15 | 1931-03-03 | Democrat | 20 | |||||||||||||
20725 | 20725 | Charles Moore M000894 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 15 | |||||||||||||
20729 | 20729 | John Moore M000905 | rep | KY | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
20731 | 20731 | Grant Mouser M001049 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 8 | |||||||||||||
20738 | 20738 | Benjamin Murphy M001089 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 18 | |||||||||||||
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 | |||||||||||||
20760 | 20760 | Henry Niedringhaus N000105 | rep | MO | 1929-04-15 | 1931-03-03 | Republican | 10 | |||||||||||||
20762 | 20762 | William Nolan N000128 | rep | MN | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
20766 | 20766 | Ruth Owen O000154 | rep | FL | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
20770 | 20770 | LaFayette Patterson P000125 | rep | AL | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
20776 | 20776 | Harcourt Pratt P000499 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 27 | |||||||||||||
20778 | 20778 | Ruth Pratt P000505 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 17 | |||||||||||||
20786 | 20786 | Fred Purnell P000573 | rep | IN | 1929-04-15 | 1931-03-03 | Republican | 9 | |||||||||||||
20796 | 20796 | Percy Quin Q000014 | rep | MS | 1929-04-15 | 1931-03-03 | Democrat | 7 | |||||||||||||
20805 | 20805 | Christian Ramseyer R000031 | rep | IA | 1929-04-15 | 1931-03-03 | Republican | 6 | |||||||||||||
20819 | 20819 | Thomas Robinson R000352 | rep | IA | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
20823 | 20823 | Samuel Rutherford R000549 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 6 | |||||||||||||
20831 | 20831 | Archie Sanders S000032 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 39 | |||||||||||||
20840 | 20840 | Francis Seiberling S000229 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 14 | |||||||||||||
20843 | 20843 | Conrad Selvig S000236 | rep | MN | 1929-04-15 | 1931-03-03 | Republican | 9 | |||||||||||||
20851 | 20851 | Milton Shreve S000387 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 29 | |||||||||||||
20856 | 20856 | Robert Simmons S000419 | rep | NE | 1929-04-15 | 1931-03-03 | Republican | 6 | |||||||||||||
20866 | 20866 | Addison Smith S000511 | rep | ID | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20868 | 20868 | Donald Snow S000659 | rep | ME | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
20870 | 20870 | Charles Sparks S000703 | rep | KS | 1929-04-15 | 1931-03-03 | Republican | 6 | |||||||||||||
20880 | 20880 | William Stafford S000777 | rep | WI | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
20888 | 20888 | William Stevenson S000895 | rep | SC | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
20896 | 20896 | James Strong S001011 | rep | KS | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
20899 | 20899 | Patrick Sullivan S001059 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 34 | |||||||||||||
20906 | 20906 | John Summers S001067 | rep | WA | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
20908 | 20908 | Charles Swanson S001093 | rep | IA | 1929-04-15 | 1931-03-03 | Republican | 9 | |||||||||||||
20914 | 20914 | Philip Swing S001123 | rep | CA | 1929-04-15 | 1931-03-03 | Republican | 11 | |||||||||||||
20924 | 20924 | Henry Temple T000119 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 25 | |||||||||||||
20929 | 20929 | Maurice Thatcher T000142 | rep | KY | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
20941 | 20941 | John Tilson T000279 | rep | CT | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
20950 | 20950 | Charles Timberlake T000281 | rep | CO | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20960 | 20960 | Henry Tucker T000399 | rep | VA | 1929-04-15 | 1931-03-03 | Democrat | 10 | |||||||||||||
20966 | 20966 | Charles Underhill U000006 | rep | MA | 1929-04-15 | 1931-03-03 | Republican | 9 | |||||||||||||
20974 | 20974 | Albert Vestal V000092 | rep | IN | 1929-04-15 | 1931-03-03 | Republican | 8 | |||||||||||||
20979 | 20979 | Bird Vincent V000101 | rep | MI | 1929-04-15 | 1931-03-03 | Republican | 8 | |||||||||||||
20992 | 20992 | Edward Wason W000185 | rep | NH | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20998 | 20998 | George Welsh W000289 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 6 | |||||||||||||
21012 | 21012 | Guinn Williams W000501 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 13 | |||||||||||||
21018 | 21018 | William Williamson W000553 | rep | SD | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
21020 | 21020 | Effiegene Wingo W000634 | rep | AR | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
21029 | 21029 | William Wood W000706 | rep | IN | 1929-04-15 | 1931-03-03 | Republican | 10 | |||||||||||||
21037 | 21037 | William Wright W000773 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
21043 | 21043 | Harry Wurzbach W000775 | rep | TX | 1929-04-15 | 1931-03-03 | Republican | 14 | |||||||||||||
21049 | 21049 | Adam Wyant W000776 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 31 | |||||||||||||
21056 | 21056 | Richard Yates Y000011 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | -1 | |||||||||||||
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 | |||||||||||||
21077 | 21077 | Miles Allgood A000156 | rep | AL | 1929-04-15 | 1931-03-03 | Democrat | 7 | |||||||||||||
21087 | 21087 | Edward Almon A000162 | rep | AL | 1929-04-15 | 1931-03-03 | Democrat | 8 | |||||||||||||
21093 | 21093 | Oscar Auf Der Heide A000338 | rep | NJ | 1929-04-15 | 1931-03-03 | Democrat | 11 | |||||||||||||
21102 | 21102 | William Ayres A000354 | rep | KS | 1929-04-15 | 1931-03-03 | Democrat | 8 | |||||||||||||
21109 | 21109 | James Beck B000290 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
21116 | 21116 | Carroll Beedy B000307 | rep | ME | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
21124 | 21124 | Loring Black B000505 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
21130 | 21130 | Frank Bowman B000704 | rep | WV | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
21139 | 21139 | Charles Brand B000767 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 8 | |||||||||||||
21147 | 21147 | Clay Briggs B000826 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 7 | |||||||||||||
21158 | 21158 | Frederick Britten B000847 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 9 | |||||||||||||
21166 | 21166 | Gordon Browning B000959 | rep | TN | 1929-04-15 | 1931-03-03 | Democrat | 8 | |||||||||||||
21171 | 21171 | George Brumm B000978 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 13 | |||||||||||||
21182 | 21182 | Thomas Busby B001163 | rep | MS | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
21187 | 21187 | Patrick Carley C000149 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 8 | |||||||||||||
21191 | 21191 | Vincent Carter C000203 | rep | WY | 1929-04-15 | 1931-03-03 | Republican | 0 | |||||||||||||
21202 | 21202 | John Clarke C000465 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 34 | |||||||||||||
21207 | 21207 | Thomas Cochran C000566 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 28 | |||||||||||||
21215 | 21215 | James Connolly C000698 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
21220 | 21220 | Oscar De Priest D000263 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
21238 | 21238 | John Douglass D000459 | rep | MA | 1929-04-15 | 1931-03-03 | Democrat | 10 | |||||||||||||
21255 | 21255 | William Evans E000261 | rep | CA | 1929-04-15 | 1931-03-03 | Republican | 9 | |||||||||||||
21266 | 21266 | Frank Foss F000294 | rep | MA | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
21278 | 21278 | James Frear F000355 | rep | WI | 1929-04-15 | 1931-03-03 | Republican | 10 | |||||||||||||
21294 | 21294 | John Garner G000074 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 15 | |||||||||||||
21298 | 21298 | David Glover G000243 | rep | AR | 1929-04-15 | 1931-03-03 | Democrat | 6 | |||||||||||||
21301 | 21301 | Edward Goss G000334 | rep | CT | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
21312 | 21312 | William Hastings H000333 | rep | OK | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
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 | |||||||||||||
21338 | 21338 | William James J000053 | rep | MI | 1929-04-15 | 1931-03-03 | Republican | 12 | |||||||||||||
21345 | 21345 | Lamar Jeffers J000068 | rep | AL | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
21357 | 21357 | Melville Kelly K000076 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 33 |
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);