legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
495 rows where "start" is on date 1931-12-07 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20443 | 20443 | George Graham G000354 | rep | PA | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
20453 | 20453 | Lindley Hadley H000008 | rep | WA | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
20467 | 20467 | Thomas Hall H000071 | rep | ND | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
20555 | 20555 | Morton Hull H000944 | rep | IL | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
20583 | 20583 | Royal Johnson J000173 | rep | SD | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
20590 | 20590 | Charles Kading K000001 | rep | WI | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
20628 | 20628 | Menalcus Lankford L000080 | rep | VA | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
20648 | 20648 | Scott Leavitt L000184 | rep | MT | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
20679 | 20679 | Frederick Loofbourow L000435 | rep | UT | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
20768 | 20768 | Donald Partridge P000090 | rep | ME | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
20867 | 20867 | Addison Smith S000511 | rep | ID | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
20951 | 20951 | Charles Timberlake T000281 | rep | CO | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
20993 | 20993 | Edward Wason W000185 | rep | NH | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
21131 | 21131 | Frank Bowman B000704 | rep | WV | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
21313 | 21313 | William Hastings H000333 | rep | OK | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
21388 | 21388 | Ralph Lozier L000489 | rep | MO | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
21559 | 21559 | Edward Stokes S000946 | rep | PA | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
21637 | 21637 | Isaac Bacharach B000009 | rep | NJ | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
21658 | 21658 | William Brunner B000981 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
21691 | 21691 | Glover Cary C000214 | rep | KY | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
21770 | 21770 | William Granfield G000372 | rep | MA | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
21830 | 21830 | Bernhard Jacobsen J000038 | rep | IA | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
22198 | 22198 | Arthur Greenwood G000437 | rep | IN | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
22308 | 22308 | John Miller M000738 | rep | AR | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
22610 | 22610 | Ernest Gibson G000158 | rep | VT | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
22811 | 22811 | James Taylor T000083 | rep | TN | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
22925 | 22925 | William Cole C000616 | rep | MD | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
22964 | 22964 | Wall Doxey D000480 | rep | MS | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
23444 | 23444 | Harry Englebright E000182 | rep | CA | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
23529 | 23529 | Robert Green G000415 | rep | FL | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
23539 | 23539 | Ulysses Guyer G000538 | rep | KS | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
23868 | 23868 | Butler Hare H000200 | rep | SC | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
23967 | 23967 | Paul Maloney M000091 | rep | LA | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
24939 | 24939 | Earl Michener M000693 | rep | MI | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
25192 | 25192 | Edward Cox C000831 | rep | GA | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
25352 | 25352 | John Kerr K000138 | rep | NC | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
26300 | 26300 | Martin Dies D000338 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
26868 | 26868 | William Hess H000550 | rep | OH | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
27875 | 27875 | Joseph Hill H000598 | rep | AL | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
20270 | 20270 | Charles Crisp C000909 | rep | GA | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
20271 | 20271 | Charles Curry C001001 | rep | CA | 1931-12-07 | 1933-03-03 | Republican | 3 | |||||||||||||
20307 | 20307 | Frederick Dominick D000408 | rep | SC | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
20474 | 20474 | Guy Hardy H000195 | rep | CO | 1931-12-07 | 1933-03-03 | Republican | 3 | |||||||||||||
20573 | 20573 | Albert Johnson J000114 | rep | WA | 1931-12-07 | 1933-03-03 | Republican | 3 | |||||||||||||
20730 | 20730 | John Moore M000905 | rep | KY | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
20745 | 20745 | John Nelson N000038 | rep | ME | 1931-12-07 | 1933-03-03 | Republican | 3 | |||||||||||||
20758 | 20758 | John Nelson N000039 | rep | WI | 1931-12-07 | 1933-03-03 | Republican | 3 | |||||||||||||
20820 | 20820 | Thomas Robinson R000352 | rep | IA | 1931-12-07 | 1933-03-03 | Republican | 3 | |||||||||||||
20942 | 20942 | John Tilson T000279 | rep | CT | 1931-12-07 | 1933-03-03 | Republican | 3 | |||||||||||||
21019 | 21019 | William Williamson W000553 | rep | SD | 1931-12-07 | 1933-03-03 | Republican | 3 | |||||||||||||
21060 | 21060 | Thomas Yon Y000021 | rep | FL | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
21071 | 21071 | Charles Abernethy A000015 | rep | NC | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
21267 | 21267 | Frank Foss F000294 | rep | MA | 1931-12-07 | 1933-03-03 | Republican | 3 | |||||||||||||
21320 | 21320 | Joseph Hooper H000764 | rep | MI | 1931-12-07 | 1933-03-03 | Republican | 3 | |||||||||||||
21322 | 21322 | Lynn Hornor H000792 | rep | WV | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
21328 | 21328 | Edgar Howard H000836 | rep | NE | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
21377 | 21377 | George Lindsay L000325 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
21395 | 21395 | Charles Martin M000173 | rep | OR | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
21421 | 21421 | Harold McGugin M000463 | rep | KS | 1931-12-07 | 1933-03-03 | Republican | 3 | |||||||||||||
21436 | 21436 | Jacob Milligan M000766 | rep | MO | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
21549 | 21549 | James Sinclair S000442 | rep | ND | 1931-12-07 | 1933-03-03 | Republican | 3 | |||||||||||||
21694 | 21694 | Bryant Castellow C000240 | rep | GA | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
21707 | 21707 | Francis Condon C000673 | rep | RI | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
21893 | 21893 | Numa Montet M000862 | rep | LA | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
21938 | 21938 | Harry Ransley R000061 | rep | PA | 1931-12-07 | 1933-03-03 | Republican | 3 | |||||||||||||
22157 | 22157 | Claude Fuller F000408 | rep | AR | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
22214 | 22214 | Byron Harlan H000209 | rep | OH | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
22325 | 22325 | Andrew Montague M000861 | rep | VA | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
22358 | 22358 | Vincent Palmisano P000046 | rep | MD | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
22390 | 22390 | Morgan Sanders S000037 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
22533 | 22533 | Eugene Crowe C000940 | rep | IN | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
22727 | 22727 | Samuel McReynolds M000598 | rep | TN | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
22904 | 22904 | Wilburn Cartwright C000207 | rep | OK | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
23258 | 23258 | William Sutphin S001086 | rep | NJ | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
23695 | 23695 | Henry Steagall S000820 | rep | AL | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
23923 | 23923 | Edward Kelly K000071 | rep | IL | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
25088 | 25088 | William Whittington W000430 | rep | MS | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
26165 | 26165 | August Andresen A000239 | rep | MN | 1931-12-07 | 1933-03-03 | Republican | 3 | |||||||||||||
20156 | 20156 | John Cable C000007 | rep | OH | 1931-12-07 | 1933-03-03 | Republican | 4 | |||||||||||||
20171 | 20171 | Harry Canfield C000114 | rep | IN | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
20425 | 20425 | Benjamin Golder G000259 | rep | PA | 1931-12-07 | 1933-03-03 | Republican | 4 | |||||||||||||
20496 | 20496 | Gilbert Haugen H000350 | rep | IA | 1931-12-07 | 1933-03-03 | Republican | 4 | |||||||||||||
20516 | 20516 | Homer Hoch H000669 | rep | KS | 1931-12-07 | 1933-03-03 | Republican | 4 | |||||||||||||
20522 | 20522 | Robert Hogg H000704 | rep | WV | 1931-12-07 | 1933-03-03 | Republican | 4 | |||||||||||||
20530 | 20530 | David Hopkins H000772 | rep | MO | 1931-12-07 | 1933-03-03 | Republican | 4 | |||||||||||||
20604 | 20604 | John Ketcham K000151 | rep | MI | 1931-12-07 | 1933-03-03 | Republican | 4 | |||||||||||||
20663 | 20663 | John Linthicum L000340 | rep | MD | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
20765 | 20765 | John Norton N000152 | rep | NE | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
20767 | 20767 | Ruth Owen O000154 | rep | FL | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
20869 | 20869 | Donald Snow S000659 | rep | ME | 1931-12-07 | 1933-03-03 | Republican | 4 | |||||||||||||
20907 | 20907 | John Summers S001067 | rep | WA | 1931-12-07 | 1933-03-03 | Republican | 4 | |||||||||||||
20931 | 20931 | William Tierney T000267 | rep | CT | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
21021 | 21021 | Effiegene Wingo W000634 | rep | AR | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
21038 | 21038 | William Wright W000773 | rep | GA | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
21183 | 21183 | Thomas Busby B001163 | rep | MS | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
21346 | 21346 | Lamar Jeffers J000068 | rep | AL | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
21429 | 21429 | Thomas McKeown M000511 | rep | OK | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
21497 | 21497 | Edward Pou P000474 | rep | NC | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
21684 | 21684 | Cap Carden C000140 | rep | KY | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
21836 | 21836 | Florence Kahn K000002 | rep | CA | 1931-12-07 | 1933-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);