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 start
This data as json, copyable, CSV (advanced)
Suggested facets: party, 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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
37954 | 37954 | Robert Byrd B001210 | sen | WV | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
33840 | 33840 | Quentin Burdick B001077 | sen | ND | 1960-08-08 | 1965-01-03 | 1 | Democrat | |||||||||||||
38149 | 38149 | Edward Kennedy K000105 | sen | MA | 1962-11-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
27600 | 27600 | Edwin Mechem M000623 | sen | NM | 1962-11-30 | 1965-01-03 | 1 | Republican | appointment | ||||||||||||
27602 | 27602 | Homer Abele A000011 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 10 | |||||||||||||
27607 | 27607 | Bruce Alger A000106 | rep | TX | 1963-01-09 | 1965-01-03 | Republican | 5 | |||||||||||||
27618 | 27618 | James Auchincloss A000227 | rep | NJ | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
27623 | 27623 | William Avery A000228 | rep | KS | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
27630 | 27630 | Howard Baker B000062 | rep | TN | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
27631 | 27631 | Irene Baker B000064 | rep | TN | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
27634 | 27634 | Robert Barry B000190 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 25 | |||||||||||||
27640 | 27640 | Frank Becker B000292 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 5 | |||||||||||||
27642 | 27642 | Ralph Beermann B000310 | rep | NE | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
27652 | 27652 | John Bennett B000377 | rep | MI | 1963-01-09 | 1965-01-03 | Republican | 12 | |||||||||||||
27655 | 27655 | Oliver Bolton B000608 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 11 | |||||||||||||
27660 | 27660 | James Bromwell B000867 | rep | IA | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
27662 | 27662 | Donald Bruce B000969 | rep | IN | 1963-01-09 | 1965-01-03 | Republican | 11 | |||||||||||||
27677 | 27677 | Charles Buckley B001024 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 23 | |||||||||||||
27678 | 27678 | Everett Burkhalter B001104 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 27 | |||||||||||||
27699 | 27699 | Clarence Cannon C000117 | rep | MO | 1963-01-09 | 1965-01-03 | Democrat | 9 | |||||||||||||
27720 | 27720 | John Chenoweth C000346 | rep | CO | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
27735 | 27735 | Clifford Davis D000094 | rep | TN | 1963-01-09 | 1965-01-03 | Democrat | 9 | |||||||||||||
27741 | 27741 | Steven Derounian D000266 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
27761 | 27761 | Clyde Doyle D000481 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 23 | |||||||||||||
27762 | 27762 | James Edmondson E000055 | sen | OK | 1963-01-09 | 1965-01-03 | 2 | Democrat | appointment | ||||||||||||
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 | |||||||||||||
27782 | 27782 | Edward Finnegan F000135 | rep | IL | 1963-01-09 | 1965-01-03 | Democrat | 9 | |||||||||||||
27789 | 27789 | Elijah Forrester F000283 | rep | GA | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
27799 | 27799 | Julian Gary G000091 | rep | VA | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
27810 | 27810 | Leon Gavin G000102 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 23 | |||||||||||||
27811 | 27811 | Thomas Gill G000192 | rep | HI | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
27815 | 27815 | Milton Glenn G000237 | rep | NJ | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
27829 | 27829 | George Grant G000381 | rep | AL | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
27838 | 27838 | William Green G000421 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
27842 | 27842 | Ralph Harding H000191 | rep | ID | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
27862 | 27862 | James Healey H000424 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 21 | |||||||||||||
27866 | 27866 | Robert Hemphill H000471 | rep | SC | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
27895 | 27895 | Charles Hoeven H000678 | rep | IA | 1963-01-09 | 1965-01-03 | Republican | 6 | |||||||||||||
27898 | 27898 | Elmer Hoffman H000684 | rep | IL | 1963-01-09 | 1965-01-03 | Republican | 14 | |||||||||||||
27909 | 27909 | Walter Horan H000786 | rep | WA | 1963-01-09 | 1965-01-03 | Republican | 5 | |||||||||||||
27914 | 27914 | George Huddleston H000904 | rep | AL | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
27927 | 27927 | Benton Jensen J000100 | rep | IA | 1963-01-09 | 1965-01-03 | Republican | 7 | |||||||||||||
27932 | 27932 | August Johansen J000109 | rep | MI | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
27938 | 27938 | Lester Johnson J000158 | rep | WI | 1963-01-09 | 1965-01-03 | Democrat | 9 | |||||||||||||
27949 | 27949 | Maude Kee K000040 | rep | WV | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
27962 | 27962 | Clarence Kilburn K000170 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 31 | |||||||||||||
27967 | 27967 | Joe Kilgore K000177 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 15 | |||||||||||||
27973 | 27973 | Victor Knox K000298 | rep | MI | 1963-01-09 | 1965-01-03 | Republican | 11 | |||||||||||||
27981 | 27981 | Richard Lankford L000081 | rep | MD | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
27990 | 27990 | John Lesinski L000252 | rep | MI | 1963-01-09 | 1965-01-03 | Democrat | 16 | |||||||||||||
27994 | 27994 | Roland Libonati L000299 | rep | IL | 1963-01-09 | 1965-01-03 | Democrat | 7 | |||||||||||||
27997 | 27997 | Patrick Martin M000197 | rep | CA | 1963-01-09 | 1965-01-03 | Republican | 38 | |||||||||||||
28004 | 28004 | Clifford McIntire M000478 | rep | ME | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
28005 | 28005 | Robert McLoskey M000558 | rep | IL | 1963-01-09 | 1965-01-03 | Republican | 19 | |||||||||||||
28012 | 28012 | George Meader M000620 | rep | MI | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
28019 | 28019 | William Miller M000762 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 40 | |||||||||||||
28022 | 28022 | William Milliken M000770 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 7 | |||||||||||||
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 | |||||||||||||
28066 | 28066 | Thomas O’Brien O000016 | rep | IL | 1963-01-09 | 1965-01-03 | Democrat | 6 | |||||||||||||
28075 | 28075 | Frank Osmers O000120 | rep | NJ | 1963-01-09 | 1965-01-03 | Republican | 9 | |||||||||||||
28082 | 28082 | Harold Ostertag O000121 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 37 | |||||||||||||
28088 | 28088 | John Pilcher P000349 | rep | GA | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
28094 | 28094 | John Pillion P000352 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 39 | |||||||||||||
28104 | 28104 | Albert Rains R000018 | rep | AL | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
28105 | 28105 | Carl Rich R000206 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
28114 | 28114 | Roy Riehlman R000250 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 34 | |||||||||||||
28121 | 28121 | Kenneth Roberts R000314 | rep | AL | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
28123 | 28123 | Harold Ryan R000556 | rep | MI | 1963-01-09 | 1965-01-03 | Democrat | 14 | |||||||||||||
28130 | 28130 | Paul Schenck S000117 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 3 |
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);