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 rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
36448 | 36448 | Sidney Yates Y000013 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 9 | |||||||||||||
35646 | 35646 | Jamie Whitten W000428 | rep | MS | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
34233 | 34233 | Charles Bennett B000371 | rep | FL | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
34048 | 34048 | Claude Pepper P000218 | sen | FL | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
33815 | 33815 | Lloyd Bentsen B000401 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 15 | |||||||||||||
33721 | 33721 | Peter Rodino R000374 | rep | NJ | 1949-01-03 | 1951-01-03 | Democrat | 10 | |||||||||||||
33697 | 33697 | Charles Price P000522 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 25 | |||||||||||||
33191 | 33191 | Clement Zablocki Z000001 | rep | WI | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
33087 | 33087 | Carl Perkins P000230 | rep | KY | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
33003 | 33003 | Henry Jackson J000013 | rep | WA | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
32733 | 32733 | Russell Long L000428 | sen | LA | 1948-01-01 | 1951-01-03 | 3 | Democrat | |||||||||||||
32489 | 32489 | Richard Bolling B000605 | rep | MO | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
32314 | 32314 | Thomas Steed S000829 | rep | OK | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
32298 | 32298 | Harley Staggers S000778 | rep | WV | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
32061 | 32061 | Daniel Flood F000209 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 11 | |||||||||||||
31848 | 31848 | Olin Teague T000110 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
31804 | 31804 | Robert Sikes S000406 | rep | FL | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
31724 | 31724 | William Poage P000398 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 11 | |||||||||||||
31628 | 31628 | George Mahon M000065 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 19 | |||||||||||||
31512 | 31512 | James Delaney D000211 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
31454 | 31454 | Omar Burleson B001111 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 17 | |||||||||||||
31402 | 31402 | Milton Young Y000047 | sen | ND | 1945-03-12 | 1951-01-03 | 3 | Republican | appointment | ||||||||||||
31296 | 31296 | Abraham Ribicoff R000191 | rep | CT | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
31262 | 31262 | John Patman P000103 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
31238 | 31238 | Otto Passman P000098 | rep | LA | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
31203 | 31203 | Thomas Morgan M000958 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 24 | |||||||||||||
31186 | 31186 | Wilbur Mills M000778 | rep | AR | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
31165 | 31165 | Warren Magnuson M000053 | sen | WA | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
31146 | 31146 | Ray Madden M000039 | rep | IN | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
31082 | 31082 | Robert Jones J000248 | rep | AL | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
31067 | 31067 | Jacob Javits J000064 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 21 | |||||||||||||
31039 | 31039 | Felix Hébert H000437 | rep | LA | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
30975 | 30975 | Wayne Hays H000408 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 18 | |||||||||||||
30922 | 30922 | Joseph Evins E000273 | rep | TN | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
30879 | 30879 | Norris Cotton C000802 | rep | NH | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
30821 | 30821 | William Barrett B000178 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
30804 | 30804 | Carl Albert A000073 | rep | OK | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
30787 | 30787 | Gerald Ford F000260 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 5 | |||||||||||||
30748 | 30748 | William Widnall W000445 | rep | NJ | 1949-01-03 | 1951-01-03 | Republican | 7 | |||||||||||||
30666 | 30666 | John Saylor S000102 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 26 | |||||||||||||
30644 | 30644 | John Rooney R000424 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 12 | |||||||||||||
30484 | 30484 | Chester Holifield H000713 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 19 | |||||||||||||
30414 | 30414 | Harold Gross G000495 | rep | IA | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
30347 | 30347 | Ovie Fisher F000152 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 21 | |||||||||||||
30303 | 30303 | Harold Donohue D000419 | rep | MA | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
30277 | 30277 | Glenn Davis D000102 | rep | WI | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
30269 | 30269 | Carl Curtis C001006 | rep | NE | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
30225 | 30225 | Clifford Case C000220 | rep | NJ | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
30166 | 30166 | John Blatnik B000550 | rep | MN | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
30145 | 30145 | Leslie Arends A000216 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 17 | |||||||||||||
30074 | 30074 | Hugh Scott S000174 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
29993 | 29993 | Alvin O’Konski O000058 | rep | WI | 1949-01-03 | 1951-01-03 | Republican | 10 | |||||||||||||
29950 | 29950 | George Miller M000727 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
29936 | 29936 | John McMillan M000568 | rep | SC | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
29912 | 29912 | William McCulloch M000393 | rep | OH | 1949-01-03 | 1951-01-03 | Republican | 4 | |||||||||||||
29905 | 29905 | Michael Mansfield M000113 | rep | MT | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
29802 | 29802 | Edward Garmatz G000071 | rep | MD | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
29778 | 29778 | James Fulton F000422 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 31 | |||||||||||||
29720 | 29720 | Robert Corbett C000772 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 30 | |||||||||||||
29704 | 29704 | William Colmer C000645 | rep | MS | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
29684 | 29684 | Emanuel Celler C000264 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 15 | |||||||||||||
29652 | 29652 | John Byrnes B001216 | rep | WI | 1949-01-03 | 1951-01-03 | Republican | 8 | |||||||||||||
29611 | 29611 | Thomas Boggs B000594 | rep | LA | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
29571 | 29571 | Walter Baring B000141 | rep | NV | 1949-01-03 | 1951-01-03 | Democrat | 0 | |||||||||||||
29559 | 29559 | Wayne Aspinall A000225 | rep | CO | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
29547 | 29547 | George Andrews A000206 | rep | AL | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
29527 | 29527 | Thomas Abernethy A000016 | rep | MS | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
29512 | 29512 | Watkins Abbitt A000002 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
29509 | 29509 | Richard Nixon N000116 | sen | CA | 1950-12-01 | 1951-01-03 | 3 | Republican | |||||||||||||
29447 | 29447 | Lucius Rivers R000280 | rep | SC | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
29424 | 29424 | Adam Powell P000477 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 22 | |||||||||||||
29409 | 29409 | Philip Philbin P000303 | rep | MA | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
29375 | 29375 | John McCormack M000364 | rep | MA | 1949-01-03 | 1951-01-03 | Democrat | 12 | |||||||||||||
29308 | 29308 | Michael Kirwan K000244 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 19 | |||||||||||||
29281 | 29281 | James Fulbright F000401 | sen | AR | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
29258 | 29258 | Michael Feighan F000060 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 20 | |||||||||||||
29237 | 29237 | George Fallon F000012 | rep | MD | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
29207 | 29207 | William Dawson D000158 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
29129 | 29129 | William Bates B000239 | rep | MA | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
29114 | 29114 | George Aiken A000062 | sen | VT | 1945-01-03 | 1951-01-03 | 3 | Republican | |||||||||||||
29078 | 29078 | Edwin Willis W000559 | rep | LA | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
29068 | 29068 | John Williams W000517 | rep | MS | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
29014 | 29014 | George Rhodes R000187 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 13 | |||||||||||||
28998 | 28998 | Barratt O’Hara O000053 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
28978 | 28978 | Abraham Multer M001074 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 14 | |||||||||||||
28946 | 28946 | Cecil King K000196 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 17 | |||||||||||||
28932 | 28932 | Edna Kelly K000070 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 10 | |||||||||||||
28922 | 28922 | Frank Karsten K000013 | rep | MO | 1949-01-03 | 1951-01-03 | Democrat | 13 | |||||||||||||
28895 | 28895 | Albert Herlong H000530 | rep | FL | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
28878 | 28878 | Porter Hardy H000197 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
28867 | 28867 | Charles Halleck H000081 | rep | IN | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
28850 | 28850 | Ezekiel Gathings G000098 | rep | AR | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
28834 | 28834 | John Fogarty F000233 | rep | RI | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
28792 | 28792 | Frances Bolton B000607 | rep | OH | 1949-01-03 | 1951-01-03 | Republican | 22 | |||||||||||||
28783 | 28783 | James Boggs B000593 | rep | DE | 1949-01-03 | 1951-01-03 | Republican | 0 | |||||||||||||
28774 | 28774 | Edward Bartlett B000201 | rep | AK | 1949-01-03 | 1951-01-03 | Democrat | 0 | |||||||||||||
28749 | 28749 | Stephen Young Y000053 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 0 | |||||||||||||
28718 | 28718 | James Trimble T000373 | rep | AR | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
28695 | 28695 | Clark Thompson T000198 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 9 | |||||||||||||
28683 | 28683 | Albert Thomas T000156 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 8 |
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);