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 sorted by state
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20561 | 20561 | James Igoe I000003 | rep | IL | 1927-12-05 | 1929-03-03 | Democrat | 6 | |||||||||||||
20585 | 20585 | William Johnson J000181 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 13 | |||||||||||||
20617 | 20617 | Stanley Kunz K000342 | rep | IL | 1927-12-05 | 1929-03-03 | Democrat | 8 | |||||||||||||
21055 | 21055 | Richard Yates Y000011 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | -1 | |||||||||||||
21157 | 21157 | Frederick Britten B000847 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 9 | |||||||||||||
21391 | 21391 | James Major M000073 | rep | IL | 1927-12-05 | 1929-03-03 | Democrat | 21 | |||||||||||||
21522 | 21522 | Henry Rainey R000014 | rep | IL | 1927-12-05 | 1929-03-03 | Democrat | 20 | |||||||||||||
21528 | 21528 | Frank Reid R000145 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 11 | |||||||||||||
21617 | 21617 | William Arnold A000300 | rep | IL | 1927-12-05 | 1929-03-03 | Democrat | 23 | |||||||||||||
21661 | 21661 | John Buckbee B001020 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 12 | |||||||||||||
25464 | 25464 | Adolph Sabath S000001 | rep | IL | 1927-12-05 | 1929-03-03 | Democrat | 5 | |||||||||||||
19318 | 19318 | Frank Gardner G000053 | rep | IN | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
19512 | 19512 | Ralph Updike U000020 | rep | IN | 1927-12-05 | 1929-03-03 | Republican | 7 | |||||||||||||
19538 | 19538 | James Watson W000203 | sen | IN | 1927-12-05 | 1933-03-03 | 3 | Republican | |||||||||||||
19682 | 19682 | Richard Elliott E000127 | rep | IN | 1927-12-05 | 1929-03-03 | Republican | 6 | |||||||||||||
19754 | 19754 | Albert Hall H000042 | rep | IN | 1927-12-05 | 1929-03-03 | Republican | 11 | |||||||||||||
19768 | 19768 | Andrew Hickey H000560 | rep | IN | 1927-12-05 | 1929-03-03 | Republican | 13 | |||||||||||||
19947 | 19947 | Harry Rowbottom R000474 | rep | IN | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
20169 | 20169 | Harry Canfield C000114 | rep | IN | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
20518 | 20518 | David Hogg H000702 | rep | IN | 1927-12-05 | 1929-03-03 | Republican | 12 | |||||||||||||
20785 | 20785 | Fred Purnell P000573 | rep | IN | 1927-12-05 | 1929-03-03 | Republican | 9 | |||||||||||||
20973 | 20973 | Albert Vestal V000092 | rep | IN | 1927-12-05 | 1929-03-03 | Republican | 8 | |||||||||||||
21028 | 21028 | William Wood W000706 | rep | IN | 1927-12-05 | 1929-03-03 | Republican | 10 | |||||||||||||
22196 | 22196 | Arthur Greenwood G000437 | rep | IN | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
24495 | 24495 | Noble Johnson J000165 | rep | IN | 1927-12-05 | 1929-03-03 | Republican | 5 | |||||||||||||
19197 | 19197 | Daniel Anthony A000261 | rep | KS | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
19279 | 19279 | Charles Curtis C001008 | sen | KS | 1927-12-05 | 1929-12-31 | 3 | Republican | |||||||||||||
19543 | 19543 | Hays White W000374 | rep | KS | 1927-12-05 | 1929-03-03 | Republican | 6 | |||||||||||||
19976 | 19976 | William Sproul S000759 | rep | KS | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
20514 | 20514 | Homer Hoch H000669 | rep | KS | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
20895 | 20895 | James Strong S001011 | rep | KS | 1927-12-05 | 1929-03-03 | Republican | 5 | |||||||||||||
21101 | 21101 | William Ayres A000354 | rep | KS | 1927-12-05 | 1929-03-03 | Democrat | 8 | |||||||||||||
23537 | 23537 | Ulysses Guyer G000538 | rep | KS | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
26007 | 26007 | Clifford Hope H000768 | rep | KS | 1927-12-05 | 1929-03-03 | Republican | 7 | |||||||||||||
19427 | 19427 | Henry Moorman M000931 | rep | KY | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
19528 | 19528 | Orie Ware W000149 | rep | KY | 1927-12-05 | 1929-03-03 | Democrat | 6 | |||||||||||||
19831 | 19831 | David Kincheloe K000187 | rep | KY | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
19846 | 19846 | Katherine Langley L000073 | rep | KY | 1927-12-05 | 1929-03-03 | Republican | 10 | |||||||||||||
20419 | 20419 | Ralph Gilbert G000177 | rep | KY | 1927-12-05 | 1929-03-03 | Democrat | 8 | |||||||||||||
20728 | 20728 | John Moore M000905 | rep | KY | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
20928 | 20928 | Maurice Thatcher T000142 | rep | KY | 1927-12-05 | 1929-03-03 | Republican | 5 | |||||||||||||
21775 | 21775 | William Gregory G000448 | rep | KY | 1927-12-05 | 1929-03-03 | Democrat | 1 | |||||||||||||
22452 | 22452 | Frederick Vinson V000106 | rep | KY | 1927-12-05 | 1929-03-03 | Democrat | 9 | |||||||||||||
24654 | 24654 | John Robsion R000358 | rep | KY | 1927-12-05 | 1929-03-03 | Republican | 11 | |||||||||||||
24792 | 24792 | Virgil Chapman C000317 | rep | KY | 1927-12-05 | 1929-03-03 | Democrat | 7 | |||||||||||||
25874 | 25874 | Alben Barkley B000145 | sen | KY | 1927-12-05 | 1933-03-03 | 3 | Democrat | |||||||||||||
19238 | 19238 | Edwin Broussard B000895 | sen | LA | 1927-12-05 | 1933-03-03 | 3 | Democrat | |||||||||||||
19392 | 19392 | Ladislas Lazaro L000153 | rep | LA | 1927-12-05 | 1929-03-03 | Democrat | -1 | |||||||||||||
19863 | 19863 | Whitmell Martin M000201 | rep | LA | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
19917 | 19917 | James O’Connor O000028 | rep | LA | 1927-12-05 | 1929-03-03 | Democrat | 1 | |||||||||||||
19967 | 19967 | James Spearing S000708 | rep | LA | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
20105 | 20105 | James Aswell A000321 | rep | LA | 1927-12-05 | 1929-03-03 | Democrat | 8 | |||||||||||||
21361 | 21361 | Bolivar Kemp K000085 | rep | LA | 1927-12-05 | 1929-03-03 | Democrat | 6 | |||||||||||||
21954 | 21954 | John Sandlin S000043 | rep | LA | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
22003 | 22003 | Riley Wilson W000608 | rep | LA | 1927-12-05 | 1929-03-03 | Democrat | 5 | |||||||||||||
22564 | 22564 | René De Rouen D000265 | rep | LA | 1927-12-05 | 1929-03-03 | Democrat | 7 | |||||||||||||
19228 | 19228 | Henry Bowles B000700 | rep | MA | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
19305 | 19305 | Louis Frothingham F000395 | rep | MA | 1927-12-05 | 1929-03-03 | Republican | 14 | |||||||||||||
19315 | 19315 | James Gallivan G000024 | rep | MA | 1927-12-05 | 1929-03-03 | Democrat | 12 | |||||||||||||
19998 | 19998 | George Stobbs S000931 | rep | MA | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
20278 | 20278 | Frederick Dallinger D000012 | rep | MA | 1927-12-05 | 1929-03-03 | Republican | 8 | |||||||||||||
20965 | 20965 | Charles Underhill U000006 | rep | MA | 1927-12-05 | 1929-03-03 | Republican | 9 | |||||||||||||
21237 | 21237 | John Douglass D000459 | rep | MA | 1927-12-05 | 1929-03-03 | Democrat | 10 | |||||||||||||
21265 | 21265 | Frank Foss F000294 | rep | MA | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
21610 | 21610 | Abram Andrew A000240 | rep | MA | 1927-12-05 | 1929-03-03 | Republican | 6 | |||||||||||||
22097 | 22097 | William Connery C000694 | rep | MA | 1927-12-05 | 1929-03-03 | Democrat | 7 | |||||||||||||
22668 | 22668 | Robert Luce L000498 | rep | MA | 1927-12-05 | 1929-03-03 | Republican | 13 | |||||||||||||
23302 | 23302 | George Tinkham T000283 | rep | MA | 1927-12-05 | 1929-03-03 | Republican | 11 | |||||||||||||
23718 | 23718 | Allen Treadway T000358 | rep | MA | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
24416 | 24416 | Charles Gifford G000169 | rep | MA | 1927-12-05 | 1929-03-03 | Republican | 16 | |||||||||||||
26651 | 26651 | Richard Wigglesworth W000450 | rep | MA | 1927-12-05 | 1929-03-03 | Republican | 14 | |||||||||||||
26984 | 26984 | Edith Rogers R000392 | rep | MA | 1927-12-05 | 1929-03-03 | Republican | 5 | |||||||||||||
28530 | 28530 | Joseph Martin M000191 | rep | MA | 1927-12-05 | 1929-03-03 | Republican | 15 | |||||||||||||
29364 | 29364 | John McCormack M000364 | rep | MA | 1927-12-05 | 1929-03-03 | Democrat | 12 | |||||||||||||
20066 | 20066 | Frederick Zihlman Z000007 | rep | MD | 1927-12-05 | 1929-03-03 | Republican | 6 | |||||||||||||
20661 | 20661 | John Linthicum L000340 | rep | MD | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
22163 | 22163 | Stephen Gambrill G000035 | rep | MD | 1927-12-05 | 1929-03-03 | Democrat | 5 | |||||||||||||
22356 | 22356 | Vincent Palmisano P000046 | rep | MD | 1927-12-05 | 1929-03-03 | Democrat | 3 | |||||||||||||
22616 | 22616 | Thomas Goldsborough G000265 | rep | MD | 1927-12-05 | 1929-03-03 | Democrat | 1 | |||||||||||||
22924 | 22924 | William Cole C000616 | rep | MD | 1927-12-05 | 1929-03-03 | Democrat | 2 | |||||||||||||
24170 | 24170 | Millard Tydings T000446 | sen | MD | 1927-12-05 | 1933-03-03 | 3 | Democrat | |||||||||||||
19355 | 19355 | Ira Hersey H000544 | rep | ME | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
20743 | 20743 | John Nelson N000038 | rep | ME | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
21115 | 21115 | Carroll Beedy B000307 | rep | ME | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
23752 | 23752 | Wallace White W000396 | rep | ME | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
19635 | 19635 | Louis Cramton C000870 | rep | MI | 1927-12-05 | 1929-03-03 | Republican | 7 | |||||||||||||
19776 | 19776 | Grant Hudson H000908 | rep | MI | 1927-12-05 | 1929-03-03 | Republican | 6 | |||||||||||||
20127 | 20127 | Frank Bohn B000596 | rep | MI | 1927-12-05 | 1929-03-03 | Republican | 11 | |||||||||||||
20201 | 20201 | Robert Clancy C000412 | rep | MI | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
20602 | 20602 | John Ketcham K000151 | rep | MI | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
20707 | 20707 | James McLaughlin M000539 | rep | MI | 1927-12-05 | 1929-03-03 | Republican | 9 | |||||||||||||
20978 | 20978 | Bird Vincent V000101 | rep | MI | 1927-12-05 | 1929-03-03 | Republican | 8 | |||||||||||||
21318 | 21318 | Joseph Hooper H000764 | rep | MI | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
21337 | 21337 | William James J000053 | rep | MI | 1927-12-05 | 1929-03-03 | Republican | 12 | |||||||||||||
22681 | 22681 | Carl Mapes M000119 | rep | MI | 1927-12-05 | 1929-03-03 | Republican | 5 | |||||||||||||
22708 | 22708 | Clarence McLeod M000557 | rep | MI | 1927-12-05 | 1929-03-03 | Republican | 13 | |||||||||||||
24937 | 24937 | Earl Michener M000693 | rep | MI | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
25556 | 25556 | Roy Woodruff W000718 | rep | MI | 1927-12-05 | 1929-03-03 | Republican | 10 | |||||||||||||
19264 | 19264 | William Carss C000194 | rep | MN | 1927-12-05 | 1929-03-03 | Farmer-Labor | 8 | |||||||||||||
19307 | 19307 | Allen Furlow F000433 | rep | MN | 1927-12-05 | 1929-03-03 | Republican | 1 |
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);