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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
20455 | 20455 | Fletcher Hale H000030 | rep | NH | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
20458 | 20458 | Homer Hall H000053 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 17 | |||||||||||||
20465 | 20465 | Thomas Hall H000071 | rep | ND | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20472 | 20472 | Guy Hardy H000195 | rep | CO | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
20494 | 20494 | Gilbert Haugen H000350 | rep | IA | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
20507 | 20507 | Willis Hawley H000379 | rep | OR | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
20514 | 20514 | Homer Hoch H000669 | rep | KS | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
20518 | 20518 | David Hogg H000702 | rep | IN | 1927-12-05 | 1929-03-03 | Republican | 12 | |||||||||||||
20525 | 20525 | William Holaday H000708 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 18 | |||||||||||||
20528 | 20528 | David Hopkins H000772 | rep | MO | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
20533 | 20533 | Robert Houston H000826 | rep | DE | 1927-12-05 | 1929-03-03 | Republican | 0 | |||||||||||||
20536 | 20536 | Victor Houston H000828 | rep | HI | 1927-12-05 | 1929-03-03 | Republican | -1 | |||||||||||||
20548 | 20548 | Cordell Hull H000940 | rep | TN | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
20553 | 20553 | Morton Hull H000944 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20558 | 20558 | William Hull H000946 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 16 | |||||||||||||
20561 | 20561 | James Igoe I000003 | rep | IL | 1927-12-05 | 1929-03-03 | Democrat | 6 | |||||||||||||
20571 | 20571 | Albert Johnson J000114 | rep | WA | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
20581 | 20581 | Royal Johnson J000173 | rep | SD | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20585 | 20585 | William Johnson J000181 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 13 | |||||||||||||
20588 | 20588 | Charles Kading K000001 | rep | WI | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20596 | 20596 | Samuel Kendall K000097 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 24 | |||||||||||||
20602 | 20602 | John Ketcham K000151 | rep | MI | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
20611 | 20611 | William Kopp K000314 | rep | IA | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
20617 | 20617 | Stanley Kunz K000342 | rep | IL | 1927-12-05 | 1929-03-03 | Democrat | 8 | |||||||||||||
20624 | 20624 | Fiorello La Guardia L000007 | rep | NY | 1927-12-05 | 1929-03-03 | Republican | 20 | |||||||||||||
20633 | 20633 | William Lankford L000082 | rep | GA | 1927-12-05 | 1929-03-03 | Democrat | 11 | |||||||||||||
20641 | 20641 | William Larsen L000103 | rep | GA | 1927-12-05 | 1929-03-03 | Democrat | 12 | |||||||||||||
20646 | 20646 | Scott Leavitt L000184 | rep | MT | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20649 | 20649 | James Leech L000209 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 20 | |||||||||||||
20661 | 20661 | John Linthicum L000340 | rep | MD | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
20675 | 20675 | Nicholas Longworth L000433 | rep | OH | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
20682 | 20682 | Frederick Magrady M000055 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 17 | |||||||||||||
20688 | 20688 | Samuel Major M000074 | rep | MO | 1927-12-05 | 1929-03-03 | Democrat | 7 | |||||||||||||
20692 | 20692 | Joe Manlove M000098 | rep | MO | 1927-12-05 | 1929-03-03 | Republican | 15 | |||||||||||||
20707 | 20707 | James McLaughlin M000539 | rep | MI | 1927-12-05 | 1929-03-03 | Republican | 9 | |||||||||||||
20717 | 20717 | Charles Mooney M000887 | rep | OH | 1927-12-05 | 1929-03-03 | Democrat | 20 | |||||||||||||
20724 | 20724 | Charles Moore M000894 | rep | OH | 1927-12-05 | 1929-03-03 | Republican | 15 | |||||||||||||
20728 | 20728 | John Moore M000905 | rep | KY | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
20737 | 20737 | Benjamin Murphy M001089 | rep | OH | 1927-12-05 | 1929-03-03 | Republican | 18 | |||||||||||||
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 | |||||||||||||
20759 | 20759 | Henry Niedringhaus N000105 | rep | MO | 1927-12-05 | 1929-03-03 | Republican | 10 | |||||||||||||
20764 | 20764 | John Norton N000152 | rep | NE | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
20769 | 20769 | LaFayette Patterson P000125 | rep | AL | 1927-12-05 | 1929-03-03 | Democrat | 5 | |||||||||||||
20775 | 20775 | Harcourt Pratt P000499 | rep | NY | 1927-12-05 | 1929-03-03 | Republican | 27 | |||||||||||||
20785 | 20785 | Fred Purnell P000573 | rep | IN | 1927-12-05 | 1929-03-03 | Republican | 9 | |||||||||||||
20795 | 20795 | Percy Quin Q000014 | rep | MS | 1927-12-05 | 1929-03-03 | Democrat | 7 | |||||||||||||
20804 | 20804 | Christian Ramseyer R000031 | rep | IA | 1927-12-05 | 1929-03-03 | Republican | 6 | |||||||||||||
20818 | 20818 | Thomas Robinson R000352 | rep | IA | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
20822 | 20822 | Samuel Rutherford R000549 | rep | GA | 1927-12-05 | 1929-03-03 | Democrat | 6 | |||||||||||||
20830 | 20830 | Archie Sanders S000032 | rep | NY | 1927-12-05 | 1929-03-03 | Republican | 39 | |||||||||||||
20842 | 20842 | Conrad Selvig S000236 | rep | MN | 1927-12-05 | 1929-03-03 | Republican | 9 | |||||||||||||
20850 | 20850 | Milton Shreve S000387 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 29 | |||||||||||||
20855 | 20855 | Robert Simmons S000419 | rep | NE | 1927-12-05 | 1929-03-03 | Republican | 6 | |||||||||||||
20865 | 20865 | Addison Smith S000511 | rep | ID | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20887 | 20887 | William Stevenson S000895 | rep | SC | 1927-12-05 | 1929-03-03 | Democrat | 5 | |||||||||||||
20895 | 20895 | James Strong S001011 | rep | KS | 1927-12-05 | 1929-03-03 | Republican | 5 | |||||||||||||
20905 | 20905 | John Summers S001067 | rep | WA | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
20913 | 20913 | Philip Swing S001123 | rep | CA | 1927-12-05 | 1929-03-03 | Republican | 11 | |||||||||||||
20923 | 20923 | Henry Temple T000119 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 25 | |||||||||||||
20928 | 20928 | Maurice Thatcher T000142 | rep | KY | 1927-12-05 | 1929-03-03 | Republican | 5 | |||||||||||||
20940 | 20940 | John Tilson T000279 | rep | CT | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
20949 | 20949 | Charles Timberlake T000281 | rep | CO | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20959 | 20959 | Henry Tucker T000399 | rep | VA | 1927-12-05 | 1929-03-03 | Democrat | 10 | |||||||||||||
20965 | 20965 | Charles Underhill U000006 | rep | MA | 1927-12-05 | 1929-03-03 | Republican | 9 | |||||||||||||
20973 | 20973 | Albert Vestal V000092 | rep | IN | 1927-12-05 | 1929-03-03 | Republican | 8 | |||||||||||||
20978 | 20978 | Bird Vincent V000101 | rep | MI | 1927-12-05 | 1929-03-03 | Republican | 8 | |||||||||||||
20991 | 20991 | Edward Wason W000185 | rep | NH | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20997 | 20997 | George Welsh W000289 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 6 | |||||||||||||
21011 | 21011 | Guinn Williams W000501 | rep | TX | 1927-12-05 | 1929-03-03 | Democrat | 13 | |||||||||||||
21017 | 21017 | William Williamson W000553 | rep | SD | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
21028 | 21028 | William Wood W000706 | rep | IN | 1927-12-05 | 1929-03-03 | Republican | 10 | |||||||||||||
21036 | 21036 | William Wright W000773 | rep | GA | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
21042 | 21042 | Harry Wurzbach W000775 | rep | TX | 1927-12-05 | 1929-03-03 | Republican | 14 | |||||||||||||
21048 | 21048 | Adam Wyant W000776 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 31 | |||||||||||||
21055 | 21055 | Richard Yates Y000011 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | -1 | |||||||||||||
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 | |||||||||||||
21076 | 21076 | Miles Allgood A000156 | rep | AL | 1927-12-05 | 1929-03-03 | Democrat | 7 | |||||||||||||
21086 | 21086 | Edward Almon A000162 | rep | AL | 1927-12-05 | 1929-03-03 | Democrat | 8 | |||||||||||||
21092 | 21092 | Oscar Auf Der Heide A000338 | rep | NJ | 1927-12-05 | 1929-03-03 | Democrat | 11 | |||||||||||||
21101 | 21101 | William Ayres A000354 | rep | KS | 1927-12-05 | 1929-03-03 | Democrat | 8 | |||||||||||||
21108 | 21108 | James Beck B000290 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
21115 | 21115 | Carroll Beedy B000307 | rep | ME | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
21119 | 21119 | Hugo Black B000499 | sen | AL | 1927-12-05 | 1933-03-03 | 3 | Democrat | |||||||||||||
21123 | 21123 | Loring Black B000505 | rep | NY | 1927-12-05 | 1929-03-03 | Democrat | 5 | |||||||||||||
21129 | 21129 | Frank Bowman B000704 | rep | WV | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
21138 | 21138 | Charles Brand B000767 | rep | GA | 1927-12-05 | 1929-03-03 | Democrat | 8 | |||||||||||||
21146 | 21146 | Clay Briggs B000826 | rep | TX | 1927-12-05 | 1929-03-03 | Democrat | 7 | |||||||||||||
21157 | 21157 | Frederick Britten B000847 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 9 | |||||||||||||
21165 | 21165 | Gordon Browning B000959 | rep | TN | 1927-12-05 | 1929-03-03 | Democrat | 8 | |||||||||||||
21181 | 21181 | Thomas Busby B001163 | rep | MS | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
21186 | 21186 | Patrick Carley C000149 | rep | NY | 1927-12-05 | 1929-03-03 | Democrat | 8 | |||||||||||||
21201 | 21201 | John Clarke C000465 | rep | NY | 1927-12-05 | 1929-03-03 | Republican | 34 | |||||||||||||
21206 | 21206 | Thomas Cochran C000566 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 28 | |||||||||||||
21214 | 21214 | James Connolly C000698 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 5 | |||||||||||||
21231 | 21231 | Clement Dickinson D000316 | rep | MO | 1927-12-05 | 1929-03-03 | Democrat | 6 | |||||||||||||
21237 | 21237 | John Douglass D000459 | rep | MA | 1927-12-05 | 1929-03-03 | Democrat | 10 |
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);