legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
481 rows where "start" is on date 1963-01-09 sorted by district
This data as json, copyable, CSV (advanced)
Suggested facets: end
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27658 | 27658 | Daniel Brewster B000813 | sen | MD | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
27709 | 27709 | Frank Carlson C000154 | sen | KS | 1963-01-09 | 1969-01-03 | 3 | Republican | |||||||||||||
27722 | 27722 | Joseph Clark C000444 | sen | PA | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
27752 | 27752 | Everett Dirksen D000360 | sen | IL | 1963-01-09 | 1969-01-03 | 3 | Republican | |||||||||||||
27762 | 27762 | James Edmondson E000055 | sen | OK | 1963-01-09 | 1965-01-03 | 2 | Democrat | appointment | ||||||||||||
27840 | 27840 | Ernest Gruening G000508 | sen | AK | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
27857 | 27857 | Carl Hayden H000385 | sen | AZ | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
27870 | 27870 | Bourke Hickenlooper H000559 | sen | IA | 1963-01-09 | 1969-01-03 | 3 | Republican | |||||||||||||
27884 | 27884 | Joseph Hill H000598 | sen | AL | 1963-01-09 | 1969-01-02 | 3 | Democrat | |||||||||||||
27942 | 27942 | Olin Johnston J000195 | sen | SC | 1963-01-09 | 1965-12-31 | 3 | Democrat | |||||||||||||
27976 | 27976 | Thomas Kuchel K000335 | sen | CA | 1963-01-09 | 1969-01-03 | 3 | Republican | |||||||||||||
27983 | 27983 | Frank Lausche L000122 | sen | OH | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
27996 | 27996 | Edward Long L000415 | sen | MO | 1963-01-09 | 1968-12-27 | 3 | Democrat | |||||||||||||
28031 | 28031 | Almer Monroney M000859 | sen | OK | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
28035 | 28035 | Wayne Morse M001014 | sen | OR | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
28040 | 28040 | Thruston Morton M001022 | sen | KY | 1963-01-09 | 1968-12-16 | 3 | Republican | |||||||||||||
28167 | 28167 | George Smathers S000505 | sen | FL | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
29117 | 29117 | George Aiken A000062 | sen | VT | 1963-01-09 | 1969-01-03 | 3 | Republican | |||||||||||||
29147 | 29147 | Wallace Bennett B000384 | sen | UT | 1963-01-09 | 1969-01-03 | 3 | Republican | |||||||||||||
29161 | 29161 | Alan Bible B000436 | sen | NV | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
29221 | 29221 | Peter Dominick D000409 | sen | CO | 1963-01-09 | 1969-01-03 | 3 | Republican | |||||||||||||
29226 | 29226 | Samuel Ervin E000211 | sen | NC | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
29284 | 29284 | James Fulbright F000401 | sen | AR | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
30835 | 30835 | Birch Bayh B000254 | sen | IN | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
30865 | 30865 | Frank Church C000388 | sen | ID | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
30883 | 30883 | Norris Cotton C000802 | sen | NH | 1963-01-09 | 1969-01-03 | 3 | Republican | |||||||||||||
31071 | 31071 | Jacob Javits J000064 | sen | NY | 1963-01-09 | 1969-01-03 | 3 | Republican | |||||||||||||
31168 | 31168 | Warren Magnuson M000053 | sen | WA | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
31176 | 31176 | George McGovern M000452 | sen | SD | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
31225 | 31225 | Gaylord Nelson N000033 | sen | WI | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
31298 | 31298 | Abraham Ribicoff R000191 | sen | CT | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
31382 | 31382 | Herman Talmadge T000035 | sen | GA | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
31405 | 31405 | Milton Young Y000047 | sen | ND | 1963-01-09 | 1969-01-03 | 3 | Republican | |||||||||||||
32736 | 32736 | Russell Long L000428 | sen | LA | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
39021 | 39021 | Daniel Inouye I000025 | sen | HI | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
27770 | 27770 | Carl Elliott E000120 | rep | AL | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
27780 | 27780 | Antonio Fernós-Isern F000087 | rep | PR | 1963-01-09 | 1965-01-03 | Popular Democrat | 0 | |||||||||||||
27829 | 27829 | George Grant G000381 | rep | AL | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
27914 | 27914 | George Huddleston H000904 | rep | AL | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
28104 | 28104 | Albert Rains R000018 | rep | AL | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
28121 | 28121 | Kenneth Roberts R000314 | rep | AL | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
28177 | 28177 | Neil Staebler S000775 | rep | MI | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
28435 | 28435 | Bernard Grabowski G000348 | rep | CT | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
28567 | 28567 | Harris McDowell M000418 | rep | DE | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
28619 | 28619 | Ralph Rivers R000282 | rep | AK | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
28655 | 28655 | Carlton Sickles S000401 | rep | MD | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
28893 | 28893 | William Harrison H000278 | rep | WY | 1963-01-09 | 1965-01-03 | Republican | 0 | |||||||||||||
28974 | 28974 | Thomas Morris M000990 | rep | NM | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
29009 | 29009 | Joe Pool P000426 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
29036 | 29036 | Armistead Selden S000232 | rep | AL | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
29554 | 29554 | George Andrews A000206 | rep | AL | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
29576 | 29576 | Walter Baring B000141 | rep | NV | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
29972 | 29972 | Joseph Montoya M000876 | rep | NM | 1963-01-09 | 1964-11-03 | Democrat | 0 | |||||||||||||
30105 | 30105 | Robert Taft T000010 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 0 | |||||||||||||
31089 | 31089 | Robert Jones J000248 | rep | AL | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
33147 | 33147 | Robert Stafford S000776 | rep | VT | 1963-01-09 | 1965-01-03 | Republican | 0 | |||||||||||||
27642 | 27642 | Ralph Beermann B000310 | rep | NE | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
27811 | 27811 | Thomas Gill G000192 | rep | HI | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
28050 | 28050 | Albin Norblad N000133 | rep | OR | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
28052 | 28052 | Hjalmar Nygaard N000178 | rep | ND | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
28105 | 28105 | Carl Rich R000206 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
28341 | 28341 | Herbert Bonner B000621 | rep | NC | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
28728 | 28728 | Stanley Tupper T000411 | rep | ME | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
28737 | 28737 | Compton White W000362 | rep | ID | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
28857 | 28857 | Ezekiel Gathings G000098 | rep | AR | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
28929 | 28929 | Frank Karsten K000013 | rep | MO | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
28969 | 28969 | Arch Moore M000892 | rep | WV | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
29163 | 29163 | Laurence Burton B001155 | rep | UT | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
29171 | 29171 | William Cahill C000019 | rep | NJ | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
29200 | 29200 | Emilio Daddario D000001 | rep | CT | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
29214 | 29214 | William Dawson D000158 | rep | IL | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
29402 | 29402 | Arnold Olsen O000083 | rep | MT | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
29436 | 29436 | Benjamin Reifel R000152 | rep | SD | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
29454 | 29454 | Lucius Rivers R000280 | rep | SC | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
29464 | 29464 | Byron Rogers R000389 | rep | CO | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
29482 | 29482 | Henry Schadeberg S000108 | rep | WI | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
29534 | 29534 | Thomas Abernethy A000016 | rep | MS | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
29590 | 29590 | Page Belcher B000323 | rep | OK | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
29818 | 29818 | George Hagan H000010 | rep | GA | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
29982 | 29982 | Rogers Morton M001021 | rep | MD | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
30015 | 30015 | Thomas Pelly P000196 | rep | WA | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
30067 | 30067 | Frederick Schwengel S000161 | rep | IA | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
30710 | 30710 | Frank Stubblefield S001037 | rep | KY | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
30765 | 30765 | Wendell Wyatt W000778 | rep | OR | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
30781 | 30781 | Louis Wyman W000782 | rep | NH | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
30828 | 30828 | William Barrett B000178 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
30903 | 30903 | Thomas Downing D000474 | rep | VA | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
31046 | 31046 | Felix Hébert H000437 | rep | LA | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
31153 | 31153 | Ray Madden M000039 | rep | IN | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
31269 | 31269 | John Patman P000103 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
31710 | 31710 | Otis Pike P000348 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
31742 | 31742 | Albert Quie Q000010 | rep | MN | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
31811 | 31811 | Robert Sikes S000406 | rep | FL | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
32214 | 32214 | Lucien Nedzi N000019 | rep | MI | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
32435 | 32435 | Mark Andrews A000208 | rep | ND | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
32556 | 32556 | Donald Clausen C000475 | rep | CA | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
32828 | 32828 | John Rhodes R000188 | rep | AZ | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
33749 | 33749 | Fernand St. Germain S000762 | rep | RI | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
34327 | 34327 | Silvio Conte C000709 | rep | MA | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
35191 | 35191 | Robert Dole D000401 | rep | KS | 1963-01-09 | 1965-01-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);