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 1965-01-03 sorted by district
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, start (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26732 | 26732 | James Beall B000271 | sen | MD | 1959-01-07 | 1965-01-03 | 1 | Republican | |||||||||||||
26780 | 26780 | Harry Byrd B001208 | sen | VA | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
26846 | 26846 | Clair Engle E000181 | sen | CA | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
26901 | 26901 | Kenneth Keating K000036 | sen | NY | 1959-01-07 | 1965-01-03 | 1 | Republican | |||||||||||||
27600 | 27600 | Edwin Mechem M000623 | sen | NM | 1962-11-30 | 1965-01-03 | 1 | Republican | appointment | ||||||||||||
27762 | 27762 | James Edmondson E000055 | sen | OK | 1963-01-09 | 1965-01-03 | 2 | Democrat | appointment | ||||||||||||
28248 | 28248 | Herbert Walters W000110 | sen | TN | 1963-08-20 | 1965-01-03 | 2 | Democrat | appointment | ||||||||||||
28308 | 28308 | Pierre Salinger S000016 | sen | CA | 1964-08-04 | 1965-01-03 | 1 | Democrat | appointment | ||||||||||||
28416 | 28416 | Thomas Dodd D000390 | sen | CT | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
28433 | 28433 | Albert Gore G000320 | sen | TN | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
28472 | 28472 | Spessard Holland H000720 | sen | FL | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
28562 | 28562 | Eugene McCarthy M000311 | sen | MN | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
28613 | 28613 | Winston Prouty P000552 | sen | VT | 1959-01-07 | 1965-01-03 | 1 | Republican | |||||||||||||
28741 | 28741 | John Williams W000518 | sen | DE | 1959-01-07 | 1965-01-03 | 1 | Republican | |||||||||||||
28744 | 28744 | Ralph Yarborough Y000006 | sen | TX | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
28750 | 28750 | Stephen Young Y000053 | sen | OH | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
29773 | 29773 | Hiram Fong F000245 | sen | HI | 1959-01-07 | 1965-01-03 | 1 | Republican | |||||||||||||
29836 | 29836 | Philip Hart H000291 | sen | MI | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
29839 | 29839 | Rupert Hartke H000297 | sen | IN | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
29845 | 29845 | Roman Hruska H000875 | sen | NE | 1959-01-07 | 1965-01-03 | 1 | Republican | |||||||||||||
29908 | 29908 | Michael Mansfield M000113 | sen | MT | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
29927 | 29927 | Gale McGee M000445 | sen | WY | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
29973 | 29973 | Joseph Montoya M000876 | sen | NM | 1964-11-04 | 1965-01-03 | 1 | Democrat | |||||||||||||
29987 | 29987 | Frank Moss M001033 | sen | UT | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
30007 | 30007 | John Pastore P000100 | sen | RI | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
30079 | 30079 | Hugh Scott S000174 | sen | PA | 1959-01-07 | 1965-01-03 | 1 | Republican | |||||||||||||
30102 | 30102 | William Symington S001136 | sen | MO | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
31476 | 31476 | Howard Cannon C000120 | sen | NV | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
31688 | 31688 | Edmund Muskie M001121 | sen | ME | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
31895 | 31895 | Harrison Williams W000502 | sen | NJ | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
32679 | 32679 | Barry Goldwater G000267 | sen | AZ | 1959-01-07 | 1965-01-03 | 1 | Republican | |||||||||||||
33006 | 33006 | Henry Jackson J000013 | sen | WA | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
33112 | 33112 | William Proxmire P000553 | sen | WI | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
33157 | 33157 | John Stennis S000852 | sen | MS | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
33840 | 33840 | Quentin Burdick B001077 | sen | ND | 1960-08-08 | 1965-01-03 | 1 | Democrat | |||||||||||||
37954 | 37954 | Robert Byrd B001210 | sen | WV | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
38149 | 38149 | Edward Kennedy K000105 | sen | MA | 1962-11-07 | 1965-01-03 | 1 | 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 | |||||||||||||
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 |
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);