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 party descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, party
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 | |||||||||||||
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 | ||||||||||||
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 | |||||||||||||
27720 | 27720 | John Chenoweth C000346 | rep | CO | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
27741 | 27741 | Steven Derounian D000266 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
27810 | 27810 | Leon Gavin G000102 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 23 | |||||||||||||
27815 | 27815 | Milton Glenn G000237 | rep | NJ | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
27962 | 27962 | Clarence Kilburn K000170 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 31 | |||||||||||||
27973 | 27973 | Victor Knox K000298 | rep | MI | 1963-01-09 | 1965-01-03 | Republican | 11 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
28094 | 28094 | John Pillion P000352 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 39 | |||||||||||||
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 | |||||||||||||
28130 | 28130 | Paul Schenck S000117 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
28155 | 28155 | Don Short S000378 | rep | ND | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
28157 | 28157 | Abner Sibal S000395 | rep | CT | 1963-01-09 | 1965-01-03 | Republican | 4 | |||||||||||||
28162 | 28162 | Eugene Siler S000408 | rep | KY | 1963-01-09 | 1965-01-03 | Republican | 5 | |||||||||||||
28176 | 28176 | Katharine St. George S000764 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 27 | |||||||||||||
28178 | 28178 | K. Stinson S000928 | rep | WA | 1963-01-09 | 1965-01-03 | Republican | 7 | |||||||||||||
28195 | 28195 | Thor Tollefson T000298 | rep | WA | 1963-01-09 | 1965-01-03 | Republican | 6 | |||||||||||||
28202 | 28202 | William Van Pelt V000051 | rep | WI | 1963-01-09 | 1965-01-03 | Republican | 6 | |||||||||||||
28231 | 28231 | George Wallhauser W000089 | rep | NJ | 1963-01-09 | 1965-01-03 | Republican | 12 | |||||||||||||
28249 | 28249 | James Weaver W000226 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 24 | |||||||||||||
28255 | 28255 | Alfred Westland W000310 | rep | WA | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
28262 | 28262 | James Wharton W000323 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 28 | |||||||||||||
28282 | 28282 | Earl Wilson W000572 | rep | IN | 1963-01-09 | 1965-01-03 | Republican | 9 | |||||||||||||
28314 | 28314 | John Baldwin B000092 | rep | CA | 1963-01-09 | 1965-01-03 | Republican | 14 | |||||||||||||
28355 | 28355 | Clarence Brown B000909 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 7 | |||||||||||||
28394 | 28394 | Willard Curtin C001005 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 8 | |||||||||||||
28404 | 28404 | Paul Dague D000004 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 9 | |||||||||||||
28420 | 28420 | Robert Ellsworth E000148 | rep | KS | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
28467 | 28467 | Ralph Harvey H000310 | rep | IN | 1963-01-09 | 1965-01-03 | Republican | 10 | |||||||||||||
28519 | 28519 | John Kunkel K000341 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 16 | |||||||||||||
28523 | 28523 | John Lindsay L000326 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 17 | |||||||||||||
28548 | 28548 | Joseph Martin M000191 | rep | MA | 1963-01-09 | 1965-01-03 | Republican | 10 | |||||||||||||
28613 | 28613 | Winston Prouty P000552 | sen | VT | 1959-01-07 | 1965-01-03 | 1 | Republican | |||||||||||||
28728 | 28728 | Stanley Tupper T000411 | rep | ME | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
28741 | 28741 | John Williams W000518 | sen | DE | 1959-01-07 | 1965-01-03 | 1 | Republican | |||||||||||||
28799 | 28799 | Frances Bolton B000607 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 22 | |||||||||||||
28813 | 28813 | Thomas Curtis C001014 | rep | MO | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
28827 | 28827 | Paul Fino F000137 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 24 | |||||||||||||
28874 | 28874 | Charles Halleck H000081 | rep | IN | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
28893 | 28893 | William Harrison H000278 | rep | WY | 1963-01-09 | 1965-01-03 | Republican | 0 | |||||||||||||
28969 | 28969 | Arch Moore M000892 | rep | WV | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
29093 | 29093 | Jesse Younger Y000060 | rep | CA | 1963-01-09 | 1965-01-03 | Republican | 11 | |||||||||||||
29100 | 29100 | Charles Goodell G000282 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 38 | |||||||||||||
29109 | 29109 | Edwin Adair A000024 | rep | IN | 1963-01-09 | 1965-01-03 | Republican | 4 | |||||||||||||
29125 | 29125 | William Ayres A000229 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 14 | |||||||||||||
29136 | 29136 | William Bates B000239 | rep | MA | 1963-01-09 | 1965-01-03 | Republican | 6 | |||||||||||||
29141 | 29141 | James Battin B000241 | rep | MT | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
29155 | 29155 | Ellis Berry B000416 | rep | SD | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
29187 | 29187 | William Cramer C000869 | rep | FL | 1963-01-09 | 1965-01-03 | Republican | 12 | |||||||||||||
29194 | 29194 | Glenn Cunningham C000991 | rep | NE | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
29269 | 29269 | Edgar Foreman F000272 | rep | TX | 1963-01-09 | 1965-01-03 | Republican | 16 | |||||||||||||
29292 | 29292 | Edward Gurney G000531 | rep | FL | 1963-01-09 | 1965-01-03 | Republican | 11 | |||||||||||||
29326 | 29326 | Melvin Laird L000024 | rep | WI | 1963-01-09 | 1965-01-03 | Republican | 7 | |||||||||||||
29332 | 29332 | Odin Langen L000069 | rep | MN | 1963-01-09 | 1965-01-03 | Republican | 7 | |||||||||||||
29341 | 29341 | Glenard Lipscomb L000344 | rep | CA | 1963-01-09 | 1965-01-03 | Republican | 24 | |||||||||||||
29347 | 29347 | Clark MacGregor M000010 | rep | MN | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
29357 | 29357 | Catherine May M000273 | rep | WA | 1963-01-09 | 1965-01-03 | Republican | 4 | |||||||||||||
29436 | 29436 | Benjamin Reifel R000152 | rep | SD | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
29472 | 29472 | Richard Roudebush R000464 | rep | IN | 1963-01-09 | 1965-01-03 | Republican | 6 | |||||||||||||
29476 | 29476 | Donald Rumsfeld R000508 | rep | IL | 1963-01-09 | 1965-01-03 | Republican | 13 | |||||||||||||
29482 | 29482 | Henry Schadeberg S000108 | rep | WI | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
29495 | 29495 | James Utt U000034 | rep | CA | 1963-01-09 | 1965-01-03 | Republican | 35 | |||||||||||||
29590 | 29590 | Page Belcher B000323 | rep | OK | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
29601 | 29601 | Jackson Betts B000426 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 8 | |||||||||||||
29629 | 29629 | Frank Bow B000676 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 16 | |||||||||||||
29634 | 29634 | William Brock B000851 | rep | TN | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
29659 | 29659 | John Byrnes B001216 | rep | WI | 1963-01-09 | 1965-01-03 | Republican | 8 | |||||||||||||
29727 | 29727 | Robert Corbett C000772 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 18 |
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);