legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
484 rows where "end" is on date 1927-03-04 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20524 | 20524 | William Holaday H000708 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 18 | |||||||||||||
20552 | 20552 | Morton Hull H000944 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20557 | 20557 | William Hull H000946 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 16 | |||||||||||||
20584 | 20584 | William Johnson J000181 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 13 | |||||||||||||
20616 | 20616 | Stanley Kunz K000342 | rep | IL | 1925-12-07 | 1927-03-04 | Democrat | 8 | |||||||||||||
21054 | 21054 | Richard Yates Y000011 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | -1 | |||||||||||||
21156 | 21156 | Frederick Britten B000847 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 9 | |||||||||||||
21521 | 21521 | Henry Rainey R000014 | rep | IL | 1925-12-07 | 1927-03-04 | Democrat | 20 | |||||||||||||
21527 | 21527 | Frank Reid R000145 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 11 | |||||||||||||
21616 | 21616 | William Arnold A000300 | rep | IL | 1925-12-07 | 1927-03-04 | Democrat | 23 | |||||||||||||
25463 | 25463 | Adolph Sabath S000001 | rep | IL | 1925-12-07 | 1927-03-04 | Democrat | 5 | |||||||||||||
19317 | 19317 | Frank Gardner G000053 | rep | IN | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
19511 | 19511 | Ralph Updike U000020 | rep | IN | 1925-12-07 | 1927-03-04 | Republican | 7 | |||||||||||||
19537 | 19537 | James Watson W000203 | sen | IN | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
19681 | 19681 | Richard Elliott E000127 | rep | IN | 1925-12-07 | 1927-03-04 | Republican | 6 | |||||||||||||
19753 | 19753 | Albert Hall H000042 | rep | IN | 1925-12-07 | 1927-03-04 | Republican | 11 | |||||||||||||
19767 | 19767 | Andrew Hickey H000560 | rep | IN | 1925-12-07 | 1927-03-04 | Republican | 13 | |||||||||||||
19946 | 19946 | Harry Rowbottom R000474 | rep | IN | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
20168 | 20168 | Harry Canfield C000114 | rep | IN | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
20517 | 20517 | David Hogg H000702 | rep | IN | 1925-12-07 | 1927-03-04 | Republican | 12 | |||||||||||||
20784 | 20784 | Fred Purnell P000573 | rep | IN | 1925-12-07 | 1927-03-04 | Republican | 9 | |||||||||||||
20972 | 20972 | Albert Vestal V000092 | rep | IN | 1925-12-07 | 1927-03-04 | Republican | 8 | |||||||||||||
21027 | 21027 | William Wood W000706 | rep | IN | 1925-12-07 | 1927-03-04 | Republican | 10 | |||||||||||||
22195 | 22195 | Arthur Greenwood G000437 | rep | IN | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
24494 | 24494 | Noble Johnson J000165 | rep | IN | 1925-12-07 | 1927-03-04 | Republican | 5 | |||||||||||||
19034 | 19034 | Chauncey Little L000348 | rep | KS | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
19134 | 19134 | Jasper Tincher T000282 | rep | KS | 1925-12-07 | 1927-03-04 | Republican | 7 | |||||||||||||
19196 | 19196 | Daniel Anthony A000261 | rep | KS | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
19278 | 19278 | Charles Curtis C001008 | sen | KS | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
19542 | 19542 | Hays White W000374 | rep | KS | 1925-12-07 | 1927-03-04 | Republican | 6 | |||||||||||||
19975 | 19975 | William Sproul S000759 | rep | KS | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
20513 | 20513 | Homer Hoch H000669 | rep | KS | 1925-12-07 | 1927-03-04 | Republican | 4 | |||||||||||||
20894 | 20894 | James Strong S001011 | rep | KS | 1925-12-07 | 1927-03-04 | Republican | 5 | |||||||||||||
21100 | 21100 | William Ayres A000354 | rep | KS | 1925-12-07 | 1927-03-04 | Democrat | 8 | |||||||||||||
18164 | 18164 | Richard Ernst E000206 | sen | KY | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
19004 | 19004 | Ben Johnson J000118 | rep | KY | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
19009 | 19009 | Andrew Kirk K000234 | rep | KY | 1925-12-07 | 1927-03-04 | Republican | 10 | |||||||||||||
19019 | 19019 | John Langley L000072 | rep | KY | 1925-12-07 | 1927-03-04 | Republican | -1 | |||||||||||||
19095 | 19095 | Arthur Rouse R000466 | rep | KY | 1925-12-07 | 1927-03-04 | Democrat | 6 | |||||||||||||
19130 | 19130 | Robert Thomas T000185 | rep | KY | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
19830 | 19830 | David Kincheloe K000187 | rep | KY | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
20418 | 20418 | Ralph Gilbert G000177 | rep | KY | 1925-12-07 | 1927-03-04 | Democrat | 8 | |||||||||||||
20727 | 20727 | John Moore M000905 | rep | KY | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
20927 | 20927 | Maurice Thatcher T000142 | rep | KY | 1925-12-07 | 1927-03-04 | Republican | 5 | |||||||||||||
22451 | 22451 | Frederick Vinson V000106 | rep | KY | 1925-12-07 | 1927-03-04 | Democrat | 9 | |||||||||||||
24653 | 24653 | John Robsion R000358 | rep | KY | 1925-12-07 | 1927-03-04 | Republican | 11 | |||||||||||||
24791 | 24791 | Virgil Chapman C000317 | rep | KY | 1925-12-07 | 1927-03-04 | Democrat | 7 | |||||||||||||
25873 | 25873 | Alben Barkley B000145 | rep | KY | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
19237 | 19237 | Edwin Broussard B000895 | sen | LA | 1921-04-11 | 1927-03-04 | 3 | Democrat | |||||||||||||
19391 | 19391 | Ladislas Lazaro L000153 | rep | LA | 1925-12-07 | 1927-03-04 | Democrat | 7 | |||||||||||||
19862 | 19862 | Whitmell Martin M000201 | rep | LA | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
19916 | 19916 | James O’Connor O000028 | rep | LA | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
19966 | 19966 | James Spearing S000708 | rep | LA | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
20104 | 20104 | James Aswell A000321 | rep | LA | 1925-12-07 | 1927-03-04 | Democrat | 8 | |||||||||||||
21360 | 21360 | Bolivar Kemp K000085 | rep | LA | 1925-12-07 | 1927-03-04 | Democrat | 6 | |||||||||||||
21953 | 21953 | John Sandlin S000043 | rep | LA | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
22002 | 22002 | Riley Wilson W000608 | rep | LA | 1925-12-07 | 1927-03-04 | Democrat | 5 | |||||||||||||
18907 | 18907 | William Butler B001196 | sen | MA | 1924-11-13 | 1927-03-04 | 1 | Republican | appointment | ||||||||||||
18926 | 18926 | George Churchill C000391 | rep | MA | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
19087 | 19087 | John Rogers R000400 | rep | MA | 1925-12-07 | 1927-03-04 | Republican | 5 | |||||||||||||
19121 | 19121 | Harry Thayer T000146 | rep | MA | 1925-12-07 | 1927-03-04 | Republican | 8 | |||||||||||||
19227 | 19227 | Henry Bowles B000700 | rep | MA | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
19304 | 19304 | Louis Frothingham F000395 | rep | MA | 1925-12-07 | 1927-03-04 | Republican | 14 | |||||||||||||
19314 | 19314 | James Gallivan G000024 | rep | MA | 1925-12-07 | 1927-03-04 | Democrat | 12 | |||||||||||||
19997 | 19997 | George Stobbs S000931 | rep | MA | 1925-12-07 | 1927-03-04 | Republican | 4 | |||||||||||||
20277 | 20277 | Frederick Dallinger D000012 | rep | MA | 1925-12-07 | 1927-03-04 | Republican | 8 | |||||||||||||
20964 | 20964 | Charles Underhill U000006 | rep | MA | 1925-12-07 | 1927-03-04 | Republican | 9 | |||||||||||||
21236 | 21236 | John Douglass D000459 | rep | MA | 1925-12-07 | 1927-03-04 | Democrat | 10 | |||||||||||||
21264 | 21264 | Frank Foss F000294 | rep | MA | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
21609 | 21609 | Abram Andrew A000240 | rep | MA | 1925-12-07 | 1927-03-04 | Republican | 6 | |||||||||||||
22096 | 22096 | William Connery C000694 | rep | MA | 1925-12-07 | 1927-03-04 | Democrat | 7 | |||||||||||||
22667 | 22667 | Robert Luce L000498 | rep | MA | 1925-12-07 | 1927-03-04 | Republican | 13 | |||||||||||||
23301 | 23301 | George Tinkham T000283 | rep | MA | 1925-12-07 | 1927-03-04 | Republican | 11 | |||||||||||||
23717 | 23717 | Allen Treadway T000358 | rep | MA | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
24415 | 24415 | Charles Gifford G000169 | rep | MA | 1925-12-07 | 1927-03-04 | Republican | 16 | |||||||||||||
26983 | 26983 | Edith Rogers R000392 | rep | MA | 1925-12-07 | 1927-03-04 | Republican | 5 | |||||||||||||
28529 | 28529 | Joseph Martin M000191 | rep | MA | 1925-12-07 | 1927-03-04 | Republican | 15 | |||||||||||||
18554 | 18554 | Ovington Weller W000276 | sen | MD | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
18992 | 18992 | John Hill H000597 | rep | MD | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
20065 | 20065 | Frederick Zihlman Z000007 | rep | MD | 1925-12-07 | 1927-03-04 | Republican | 6 | |||||||||||||
20660 | 20660 | John Linthicum L000340 | rep | MD | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
22162 | 22162 | Stephen Gambrill G000035 | rep | MD | 1925-12-07 | 1927-03-04 | Democrat | 5 | |||||||||||||
22615 | 22615 | Thomas Goldsborough G000265 | rep | MD | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
24169 | 24169 | Millard Tydings T000446 | rep | MD | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
18941 | 18941 | Bert Fernald F000084 | sen | ME | 1925-12-07 | 1927-03-04 | 2 | Republican | |||||||||||||
19354 | 19354 | Ira Hersey H000544 | rep | ME | 1925-12-07 | 1927-03-04 | Republican | 4 | |||||||||||||
20742 | 20742 | John Nelson N000038 | rep | ME | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
21114 | 21114 | Carroll Beedy B000307 | rep | ME | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
23751 | 23751 | Wallace White W000396 | rep | ME | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
19102 | 19102 | Frank Scott S000169 | rep | MI | 1925-12-07 | 1927-03-04 | Republican | 11 | |||||||||||||
19113 | 19113 | John Sosnowski S000680 | rep | MI | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
19165 | 19165 | Arthur Williams W000490 | rep | MI | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
19634 | 19634 | Louis Cramton C000870 | rep | MI | 1925-12-07 | 1927-03-04 | Republican | 7 | |||||||||||||
19775 | 19775 | Grant Hudson H000908 | rep | MI | 1925-12-07 | 1927-03-04 | Republican | 6 | |||||||||||||
20601 | 20601 | John Ketcham K000151 | rep | MI | 1925-12-07 | 1927-03-04 | Republican | 4 | |||||||||||||
20706 | 20706 | James McLaughlin M000539 | rep | MI | 1925-12-07 | 1927-03-04 | Republican | 9 | |||||||||||||
20977 | 20977 | Bird Vincent V000101 | rep | MI | 1925-12-07 | 1927-03-04 | Republican | 8 | |||||||||||||
21317 | 21317 | Joseph Hooper H000764 | rep | MI | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
21336 | 21336 | William James J000053 | rep | MI | 1925-12-07 | 1927-03-04 | Republican | 12 | |||||||||||||
22680 | 22680 | Carl Mapes M000119 | rep | MI | 1925-12-07 | 1927-03-04 | Republican | 5 |
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);