legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
482 rows where "end" is on date 1951-01-03 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25598 | 25598 | Cecil Bishop B000486 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 26 | |||||||||||||
25731 | 25731 | Edgar Jonas J000207 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 12 | |||||||||||||
26003 | 26003 | Richard Hoffman H000689 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 10 | |||||||||||||
26100 | 26100 | Chauncey Reed R000111 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 14 | |||||||||||||
26132 | 26132 | Harold Velde V000082 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 18 | |||||||||||||
26329 | 26329 | Thomas Gordon G000316 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
26606 | 26606 | Sidney Simpson S000437 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 20 | |||||||||||||
26646 | 26646 | Charles Vursell V000125 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 24 | |||||||||||||
26700 | 26700 | Leo Allen A000138 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 16 | |||||||||||||
27147 | 27147 | Robert Chiperfield C000365 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 19 | |||||||||||||
27324 | 27324 | Peter Mack M000020 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 21 | |||||||||||||
27349 | 27349 | Noah Mason M000224 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 15 | |||||||||||||
28059 | 28059 | Thomas O’Brien O000016 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
28998 | 28998 | Barratt O’Hara O000053 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
29207 | 29207 | William Dawson D000158 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
30145 | 30145 | Leslie Arends A000216 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 17 | |||||||||||||
33697 | 33697 | Charles Price P000522 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 25 | |||||||||||||
36448 | 36448 | Sidney Yates Y000013 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 9 | |||||||||||||
24814 | 24814 | Thurman Crook C000926 | rep | IN | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
24858 | 24858 | Andrew Jacobs J000034 | rep | IN | 1949-01-03 | 1951-01-03 | Democrat | 11 | |||||||||||||
24875 | 24875 | Edward Kruse K000334 | rep | IN | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
24950 | 24950 | James Noland N000129 | rep | IN | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
25060 | 25060 | John Walsh W000100 | rep | IN | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
26204 | 26204 | Homer Capehart C000128 | sen | IN | 1945-01-03 | 1951-01-03 | 3 | Republican | |||||||||||||
26360 | 26360 | Cecil Harden H000182 | rep | IN | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
28276 | 28276 | Earl Wilson W000572 | rep | IN | 1949-01-03 | 1951-01-03 | Republican | 9 | |||||||||||||
28406 | 28406 | Winfield Denton D000260 | rep | IN | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
28461 | 28461 | Ralph Harvey H000310 | rep | IN | 1949-01-03 | 1951-01-03 | Republican | 10 | |||||||||||||
28867 | 28867 | Charles Halleck H000081 | rep | IN | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
31146 | 31146 | Ray Madden M000039 | rep | IN | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
24815 | 24815 | Harry Darby D000048 | sen | KS | 1949-12-02 | 1951-01-03 | 3 | Republican | appointment | ||||||||||||
24932 | 24932 | Herbert Meyer M000680 | rep | KS | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
25183 | 25183 | Albert Cole C000606 | rep | KS | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
26018 | 26018 | Clifford Hope H000768 | rep | KS | 1949-01-03 | 1951-01-03 | Republican | 5 | |||||||||||||
26321 | 26321 | Myron George G000129 | rep | KS | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
26582 | 26582 | Errett Scrivner S000194 | rep | KS | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
26977 | 26977 | Edward Rees R000132 | rep | KS | 1949-01-03 | 1951-01-03 | Republican | 4 | |||||||||||||
27015 | 27015 | Wint Smith S000640 | rep | KS | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
27706 | 27706 | Frank Carlson C000154 | sen | KS | 1950-11-29 | 1951-01-03 | 3 | Republican | |||||||||||||
25108 | 25108 | Earle Clements C000506 | sen | KY | 1950-11-27 | 1951-01-03 | 3 | Democrat | |||||||||||||
25136 | 25136 | Joseph Bates B000237 | rep | KY | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
25531 | 25531 | Thomas Underwood U000015 | rep | KY | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
25543 | 25543 | John Whitaker W000348 | rep | KY | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25673 | 25673 | James Golden G000258 | rep | KY | 1949-01-03 | 1951-01-03 | Republican | 9 | |||||||||||||
26340 | 26340 | Noble Gregory G000447 | rep | KY | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
27542 | 27542 | Brent Spence S000717 | rep | KY | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
28037 | 28037 | Thruston Morton M001022 | rep | KY | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
28363 | 28363 | Frank Chelf C000342 | rep | KY | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
33087 | 33087 | Carl Perkins P000230 | rep | KY | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
25118 | 25118 | Asa Allen A000114 | rep | LA | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
25366 | 25366 | Henry Larcade L000095 | rep | LA | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
27133 | 27133 | Overton Brooks B000884 | rep | LA | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
28577 | 28577 | James Morrison M000995 | rep | LA | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
29078 | 29078 | Edwin Willis W000559 | rep | LA | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
29611 | 29611 | Thomas Boggs B000594 | rep | LA | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
31039 | 31039 | Felix Hébert H000437 | rep | LA | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
31238 | 31238 | Otto Passman P000098 | rep | LA | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
32733 | 32733 | Russell Long L000428 | sen | LA | 1948-01-01 | 1951-01-03 | 3 | Democrat | |||||||||||||
24738 | 24738 | George Bates B000232 | rep | MA | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
25264 | 25264 | John Furcolo F000431 | rep | MA | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25325 | 25325 | Christian Herter H000548 | rep | MA | 1949-01-03 | 1951-01-03 | Republican | 10 | |||||||||||||
25679 | 25679 | Angier Goodwin G000297 | rep | MA | 1949-01-03 | 1951-01-03 | Republican | 8 | |||||||||||||
26385 | 26385 | John Heselton H000549 | rep | MA | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
26540 | 26540 | Donald Nicholson N000097 | rep | MA | 1949-01-03 | 1951-01-03 | Republican | 9 | |||||||||||||
26662 | 26662 | Richard Wigglesworth W000450 | rep | MA | 1949-01-03 | 1951-01-03 | Republican | 13 | |||||||||||||
26995 | 26995 | Edith Rogers R000392 | rep | MA | 1949-01-03 | 1951-01-03 | Republican | 5 | |||||||||||||
27308 | 27308 | Thomas Lane L000065 | rep | MA | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
27595 | 27595 | John Kennedy K000107 | rep | MA | 1949-01-03 | 1951-01-03 | Democrat | 11 | |||||||||||||
28541 | 28541 | Joseph Martin M000191 | rep | MA | 1949-01-03 | 1951-01-03 | Republican | 14 | |||||||||||||
29129 | 29129 | William Bates B000239 | rep | MA | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
29375 | 29375 | John McCormack M000364 | rep | MA | 1949-01-03 | 1951-01-03 | Democrat | 12 | |||||||||||||
29409 | 29409 | Philip Philbin P000303 | rep | MA | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
30303 | 30303 | Harold Donohue D000419 | rep | MA | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
24173 | 24173 | Millard Tydings T000446 | sen | MD | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
24773 | 24773 | William Bolton B000609 | rep | MD | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25482 | 25482 | Lansdale Sasscer S000067 | rep | MD | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
26528 | 26528 | Edward Miller M000724 | rep | MD | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
26729 | 26729 | James Beall B000271 | rep | MD | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
29237 | 29237 | George Fallon F000012 | rep | MD | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
29802 | 29802 | Edward Garmatz G000071 | rep | MD | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
25260 | 25260 | Frank Fellows F000066 | rep | ME | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
26073 | 26073 | Charles Nelson N000031 | rep | ME | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
26355 | 26355 | Robert Hale H000036 | rep | ME | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
24829 | 24829 | Albert Engel E000178 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 9 | |||||||||||||
24897 | 24897 | John Lesinski L000251 | rep | MI | 1949-01-03 | 1951-01-03 | Democrat | 16 | |||||||||||||
24947 | 24947 | Earl Michener M000693 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
25017 | 25017 | George Sadowski S000011 | rep | MI | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
25144 | 25144 | William Blackney B000515 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
25210 | 25210 | Fred Crawford C000889 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 8 | |||||||||||||
25567 | 25567 | Roy Woodruff W000718 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 10 | |||||||||||||
25573 | 25573 | Charles Potter P000460 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 11 | |||||||||||||
25770 | 25770 | George O’Brien O000009 | rep | MI | 1949-01-03 | 1951-01-03 | Democrat | 13 | |||||||||||||
25805 | 25805 | Paul Shafer S000277 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
25919 | 25919 | John Dingell D000354 | rep | MI | 1949-01-03 | 1951-01-03 | Democrat | 15 | |||||||||||||
25937 | 25937 | George Dondero D000411 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 17 | |||||||||||||
26145 | 26145 | Jesse Wolcott W000668 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 7 | |||||||||||||
27238 | 27238 | Clare Hoffman H000683 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 4 | |||||||||||||
27422 | 27422 | Louis Rabaut R000001 | rep | MI | 1949-01-03 | 1951-01-03 | Democrat | 14 | |||||||||||||
27645 | 27645 | John Bennett B000377 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 12 | |||||||||||||
30787 | 30787 | Gerald Ford F000260 | rep | MI | 1949-01-03 | 1951-01-03 | 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);