legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
499 rows where "end" is on date 1933-03-03 sorted by party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21684 | 21684 | Cap Carden C000140 | rep | KY | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
21691 | 21691 | Glover Cary C000214 | rep | KY | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
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 | |||||||||||||
21728 | 21728 | Parker Corning C000785 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 28 | |||||||||||||
21732 | 21732 | Oliver Cross C000931 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 11 | |||||||||||||
21756 | 21756 | Joe Eagle E000003 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 8 | |||||||||||||
21762 | 21762 | William Fiesinger F000114 | rep | OH | 1931-12-07 | 1933-03-03 | Democrat | 13 | |||||||||||||
21770 | 21770 | William Granfield G000372 | rep | MA | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
21777 | 21777 | William Gregory G000448 | rep | KY | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
21787 | 21787 | Anthony Griffin G000457 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 22 | |||||||||||||
21809 | 21809 | Samuel Hill H000607 | rep | WA | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
21826 | 21826 | George Huddleston H000903 | rep | AL | 1931-12-07 | 1933-03-03 | Democrat | 9 | |||||||||||||
21830 | 21830 | Bernhard Jacobsen J000038 | rep | IA | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
21869 | 21869 | John McDuffie M000427 | rep | AL | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
21877 | 21877 | John McSwain M000604 | rep | SC | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
21893 | 21893 | Numa Montet M000862 | rep | LA | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
21908 | 21908 | William Oliver O000077 | rep | AL | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
21916 | 21916 | Tilman Parks P000075 | rep | AR | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
21944 | 21944 | William Rogers R000408 | rep | NH | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
21947 | 21947 | Stephen Rudd R000496 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 9 | |||||||||||||
21956 | 21956 | John Sandlin S000043 | rep | LA | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
21991 | 21991 | Mell Underwood U000012 | rep | OH | 1931-12-07 | 1933-03-03 | Democrat | 11 | |||||||||||||
22005 | 22005 | Riley Wilson W000608 | rep | LA | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
22058 | 22058 | John Boylan B000726 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 15 | |||||||||||||
22071 | 22071 | James Buchanan B001006 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 10 | |||||||||||||
22099 | 22099 | William Connery C000694 | rep | MA | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
22122 | 22122 | William Driver D000503 | rep | AR | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
22157 | 22157 | Claude Fuller F000408 | rep | AR | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
22165 | 22165 | Stephen Gambrill G000035 | rep | MD | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
22173 | 22173 | Allard Gasque G000092 | rep | SC | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
22198 | 22198 | Arthur Greenwood G000437 | rep | IN | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
22204 | 22204 | Glenn Griswold G000483 | rep | IN | 1931-12-07 | 1933-03-03 | Democrat | 11 | |||||||||||||
22210 | 22210 | Franklin Hancock H000147 | rep | NC | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
22214 | 22214 | Byron Harlan H000209 | rep | OH | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
22247 | 22247 | Frank Kniffin K000283 | rep | OH | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
22256 | 22256 | John Lambeth L000038 | rep | NC | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
22260 | 22260 | Arthur Lamneck L000040 | rep | OH | 1931-12-07 | 1933-03-03 | Democrat | 12 | |||||||||||||
22271 | 22271 | David Lewis L000277 | rep | MD | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
22308 | 22308 | John Miller M000738 | rep | AR | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
22312 | 22312 | John Mitchell M000823 | rep | TN | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
22325 | 22325 | Andrew Montague M000861 | rep | VA | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
22348 | 22348 | John O’Connor O000030 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 16 | |||||||||||||
22358 | 22358 | Vincent Palmisano P000046 | rep | MD | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
22366 | 22366 | Samuel Pettengill P000268 | rep | IN | 1931-12-07 | 1933-03-03 | Democrat | 13 | |||||||||||||
22379 | 22379 | Michael Reilly R000155 | rep | WI | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
22390 | 22390 | Morgan Sanders S000037 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
22453 | 22453 | Frederick Vinson V000106 | rep | KY | 1931-12-07 | 1933-03-03 | Democrat | 9 | |||||||||||||
22495 | 22495 | William Bankhead B000113 | rep | AL | 1931-12-07 | 1933-03-03 | Democrat | 10 | |||||||||||||
22515 | 22515 | Hattie Caraway C000138 | sen | AR | 1931-12-07 | 1933-03-03 | 3 | Democrat | appointment | ||||||||||||
22533 | 22533 | Eugene Crowe C000940 | rep | IN | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
22566 | 22566 | René De Rouen D000265 | rep | LA | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
22594 | 22594 | Joachim Fernández F000086 | rep | LA | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
22618 | 22618 | Thomas Goldsborough G000265 | rep | MD | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
22644 | 22644 | John Jones J000236 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 18 | |||||||||||||
22649 | 22649 | Kent Keller K000056 | rep | IL | 1931-12-07 | 1933-03-03 | Democrat | 25 | |||||||||||||
22654 | 22654 | Ambrose Kennedy K000101 | rep | MD | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
22718 | 22718 | Thomas McMillan M000572 | rep | SC | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
22727 | 22727 | Samuel McReynolds M000598 | rep | TN | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
22743 | 22743 | Claude Parsons P000086 | rep | IL | 1931-12-07 | 1933-03-03 | Democrat | 24 | |||||||||||||
22749 | 22749 | Robert Reynolds R000179 | sen | NC | 1932-12-05 | 1933-03-03 | 3 | Democrat | |||||||||||||
22777 | 22777 | William Sirovich S000452 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 14 | |||||||||||||
22788 | 22788 | Ellison Smith S000530 | sen | SC | 1927-12-05 | 1933-03-03 | 3 | Democrat | |||||||||||||
22799 | 22799 | Christopher Sullivan S001051 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 13 | |||||||||||||
22827 | 22827 | Lindsay Warren W000166 | rep | NC | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
22861 | 22861 | Harry Beam B000274 | rep | IL | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
22874 | 22874 | John Boehne B000588 | rep | IN | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
22880 | 22880 | Patrick Boland B000601 | rep | PA | 1931-12-07 | 1933-03-03 | Democrat | 11 | |||||||||||||
22904 | 22904 | Wilburn Cartwright C000207 | rep | OK | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
22925 | 22925 | William Cole C000616 | rep | MD | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
22936 | 22936 | Ross Collins C000642 | rep | MS | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
22964 | 22964 | Wall Doxey D000480 | rep | MS | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
23019 | 23019 | Harry Haines H000026 | rep | PA | 1931-12-07 | 1933-03-03 | Democrat | 22 | |||||||||||||
23097 | 23097 | William Larrabee L000100 | rep | IN | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
23134 | 23134 | James Mead M000615 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 42 | |||||||||||||
23160 | 23160 | William Nelson N000046 | rep | MO | 1931-12-07 | 1933-03-03 | Democrat | 8 | |||||||||||||
23200 | 23200 | Milton Romjue R000418 | rep | MO | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
23232 | 23232 | Joseph Shannon S000287 | rep | MO | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
23258 | 23258 | William Sutphin S001086 | rep | NJ | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
23264 | 23264 | Martin Sweeney S001102 | rep | OH | 1931-12-07 | 1933-03-03 | Democrat | 20 | |||||||||||||
23281 | 23281 | Edward Taylor T000072 | rep | CO | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
23323 | 23323 | Clyde Williams W000494 | rep | MO | 1931-12-07 | 1933-03-03 | Democrat | 13 | |||||||||||||
23400 | 23400 | Thomas Cullen C000970 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
23418 | 23418 | Wesley Disney D000362 | rep | OK | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
23468 | 23468 | James Fitzpatrick F000175 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 24 | |||||||||||||
23486 | 23486 | Hampton Fulmer F000417 | rep | SC | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
23498 | 23498 | Joseph Gavagan G000101 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 21 | |||||||||||||
23529 | 23529 | Robert Green G000415 | rep | FL | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
23557 | 23557 | Martin Kennedy K000111 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 18 | |||||||||||||
23564 | 23564 | Richard Kleberg K000257 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 14 | |||||||||||||
23624 | 23624 | Cameron Morrison M000993 | sen | NC | 1930-12-13 | 1933-03-03 | 3 | Democrat | appointment | ||||||||||||
23666 | 23666 | Leonard Schuetz S000144 | rep | IL | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
23674 | 23674 | Joseph Smith S000580 | rep | WV | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
23695 | 23695 | Henry Steagall S000820 | rep | AL | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
23806 | 23806 | John Cochran C000565 | rep | MO | 1931-12-07 | 1933-03-03 | Democrat | 11 | |||||||||||||
23830 | 23830 | Samuel Dickstein D000335 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 12 | |||||||||||||
23868 | 23868 | Butler Hare H000200 | rep | SC | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
23903 | 23903 | Jed Johnson J000150 | rep | OK | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
23915 | 23915 | Luther Johnson J000159 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
23923 | 23923 | Edward Kelly K000071 | rep | IL | 1931-12-07 | 1933-03-03 | Democrat | 3 |
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);