legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
484 rows where "start" is on date 1959-01-07 sorted by end-type
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27256 | 27256 | Thomas Johnson J000176 | rep | MD | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
27266 | 27266 | Walter Judd J000278 | rep | MN | 1959-01-07 | 1961-01-03 | Republican | 5 | |||||||||||||
27274 | 27274 | Carroll Kearns K000032 | rep | PA | 1959-01-07 | 1961-01-03 | Republican | 24 | |||||||||||||
27297 | 27297 | Paul Kilday K000171 | rep | TX | 1959-01-07 | 1961-01-03 | Democrat | 20 | |||||||||||||
27300 | 27300 | Alvin Kitchin K000249 | rep | NC | 1959-01-07 | 1961-01-03 | Democrat | 8 | |||||||||||||
27302 | 27302 | Frank Kowalski K000320 | rep | CT | 1959-01-07 | 1961-01-03 | Democrat | 0 | |||||||||||||
27313 | 27313 | Thomas Lane L000065 | rep | MA | 1959-01-07 | 1961-01-03 | Democrat | 7 | |||||||||||||
27316 | 27316 | Joseph Loser L000446 | rep | TN | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
27322 | 27322 | Thaddeus Machrowicz M000014 | rep | MI | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
27329 | 27329 | Peter Mack M000020 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 21 | |||||||||||||
27334 | 27334 | Donald Magnuson M000052 | rep | WA | 1959-01-07 | 1961-01-03 | Democrat | 7 | |||||||||||||
27341 | 27341 | Fred Marshall M000152 | rep | MN | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
27354 | 27354 | Noah Mason M000224 | rep | IL | 1959-01-07 | 1961-01-03 | Republican | 15 | |||||||||||||
27363 | 27363 | Gordon McDonough M000414 | rep | CA | 1959-01-07 | 1961-01-03 | Republican | 15 | |||||||||||||
27367 | 27367 | Harold McSween M000605 | rep | LA | 1959-01-07 | 1961-01-03 | Democrat | 8 | |||||||||||||
27378 | 27378 | Chester Merrow M000664 | rep | NH | 1959-01-07 | 1961-01-03 | Republican | 1 | |||||||||||||
27380 | 27380 | Clement Miller M000719 | rep | CA | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
27388 | 27388 | Morgan Moulder M001045 | rep | MO | 1959-01-07 | 1961-01-03 | Democrat | 11 | |||||||||||||
27394 | 27394 | Walter Mumma M001077 | rep | PA | 1959-01-07 | 1961-01-03 | Republican | 16 | |||||||||||||
27408 | 27408 | William Norrell N000137 | rep | AR | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
27414 | 27414 | Gracie Pfost P000287 | rep | ID | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
27427 | 27427 | Louis Rabaut R000001 | rep | MI | 1959-01-07 | 1961-01-03 | Democrat | 14 | |||||||||||||
27432 | 27432 | John Ray R000077 | rep | NY | 1959-01-07 | 1961-01-03 | Republican | 15 | |||||||||||||
27457 | 27457 | Samuel Rayburn R000082 | rep | TX | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
27475 | 27475 | Brazilla Reece R000108 | rep | TN | 1959-01-07 | 1961-01-03 | Republican | 1 | |||||||||||||
27485 | 27485 | John Riley R000260 | rep | SC | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
27500 | 27500 | J. Rutherford R000547 | rep | TX | 1959-01-07 | 1961-01-03 | Democrat | 16 | |||||||||||||
27507 | 27507 | Alfred Santangelo S000057 | rep | NY | 1959-01-07 | 1961-01-03 | Democrat | 18 | |||||||||||||
27510 | 27510 | Dalip Saund S000075 | rep | CA | 1959-01-07 | 1961-01-03 | Democrat | 29 | |||||||||||||
27515 | 27515 | Gordon Scherer S000120 | rep | OH | 1959-01-07 | 1961-01-03 | Republican | 1 | |||||||||||||
27531 | 27531 | Frank Smith S000533 | rep | MS | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
27547 | 27547 | Brent Spence S000717 | rep | KY | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
27567 | 27567 | John Taber T000001 | rep | NY | 1959-01-07 | 1961-01-03 | Republican | 36 | |||||||||||||
27571 | 27571 | Stewart Udall U000002 | rep | AZ | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
27582 | 27582 | James Van Zandt V000069 | rep | PA | 1959-01-07 | 1961-01-03 | Republican | 20 | |||||||||||||
27586 | 27586 | Phillip Weaver W000228 | rep | NE | 1959-01-07 | 1961-01-03 | Republican | 1 | |||||||||||||
27588 | 27588 | Jessica Weis W000256 | rep | NY | 1959-01-07 | 1961-01-03 | Republican | 38 | |||||||||||||
27592 | 27592 | Herbert Zelenko Z000003 | rep | NY | 1959-01-07 | 1961-01-03 | Democrat | 21 | |||||||||||||
27598 | 27598 | John Kennedy K000107 | sen | MA | 1959-01-07 | 1960-12-22 | 1 | Democrat | |||||||||||||
27605 | 27605 | Bruce Alger A000106 | rep | TX | 1959-01-07 | 1961-01-03 | Republican | 5 | |||||||||||||
27616 | 27616 | James Auchincloss A000227 | rep | NJ | 1959-01-07 | 1961-01-03 | Republican | 3 | |||||||||||||
27621 | 27621 | William Avery A000228 | rep | KS | 1959-01-07 | 1961-01-03 | Republican | 1 | |||||||||||||
27628 | 27628 | Howard Baker B000062 | rep | TN | 1959-01-07 | 1961-01-03 | Republican | 2 | |||||||||||||
27632 | 27632 | Robert Barry B000190 | rep | NY | 1959-01-07 | 1961-01-03 | Republican | 27 | |||||||||||||
27638 | 27638 | Frank Becker B000292 | rep | NY | 1959-01-07 | 1961-01-03 | Republican | 3 | |||||||||||||
27650 | 27650 | John Bennett B000377 | rep | MI | 1959-01-07 | 1961-01-03 | Republican | 12 | |||||||||||||
27656 | 27656 | Daniel Brewster B000813 | rep | MD | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
27675 | 27675 | Charles Buckley B001024 | rep | NY | 1959-01-07 | 1961-01-03 | Democrat | 24 | |||||||||||||
27697 | 27697 | Clarence Cannon C000117 | rep | MO | 1959-01-07 | 1961-01-03 | Democrat | 9 | |||||||||||||
27718 | 27718 | John Chenoweth C000346 | rep | CO | 1959-01-07 | 1961-01-03 | Republican | 3 | |||||||||||||
27733 | 27733 | Clifford Davis D000094 | rep | TN | 1959-01-07 | 1961-01-03 | Democrat | 9 | |||||||||||||
27739 | 27739 | Steven Derounian D000266 | rep | NY | 1959-01-07 | 1961-01-03 | Republican | 2 | |||||||||||||
27759 | 27759 | Clyde Doyle D000481 | rep | CA | 1959-01-07 | 1961-01-03 | Democrat | 23 | |||||||||||||
27768 | 27768 | Carl Elliott E000120 | rep | AL | 1959-01-07 | 1961-01-03 | Democrat | 7 | |||||||||||||
27778 | 27778 | Antonio Fernós-Isern F000087 | rep | PR | 1959-01-07 | 1961-01-03 | Popular Democrat | 0 | |||||||||||||
27787 | 27787 | Elijah Forrester F000283 | rep | GA | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
27797 | 27797 | Julian Gary G000091 | rep | VA | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
27808 | 27808 | Leon Gavin G000102 | rep | PA | 1959-01-07 | 1961-01-03 | Republican | 23 | |||||||||||||
27813 | 27813 | Milton Glenn G000237 | rep | NJ | 1959-01-07 | 1961-01-03 | Republican | 2 | |||||||||||||
27827 | 27827 | George Grant G000381 | rep | AL | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
27836 | 27836 | William Green G000421 | rep | PA | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
27839 | 27839 | Ernest Gruening G000508 | sen | AK | 1959-01-07 | 1963-01-03 | 3 | Democrat | |||||||||||||
27860 | 27860 | James Healey H000424 | rep | NY | 1959-01-07 | 1961-01-03 | Democrat | 22 | |||||||||||||
27864 | 27864 | Robert Hemphill H000471 | rep | SC | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
27893 | 27893 | Charles Hoeven H000678 | rep | IA | 1959-01-07 | 1961-01-03 | Republican | 8 | |||||||||||||
27896 | 27896 | Elmer Hoffman H000684 | rep | IL | 1959-01-07 | 1961-01-03 | Republican | 14 | |||||||||||||
27907 | 27907 | Walter Horan H000786 | rep | WA | 1959-01-07 | 1961-01-03 | Republican | 5 | |||||||||||||
27912 | 27912 | George Huddleston H000904 | rep | AL | 1959-01-07 | 1961-01-03 | Democrat | 9 | |||||||||||||
27925 | 27925 | Benton Jensen J000100 | rep | IA | 1959-01-07 | 1961-01-03 | Republican | 7 | |||||||||||||
27930 | 27930 | August Johansen J000109 | rep | MI | 1959-01-07 | 1961-01-03 | Republican | 3 | |||||||||||||
27936 | 27936 | Lester Johnson J000158 | rep | WI | 1959-01-07 | 1961-01-03 | Democrat | 9 | |||||||||||||
27947 | 27947 | Maude Kee K000040 | rep | WV | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
27960 | 27960 | Clarence Kilburn K000170 | rep | NY | 1959-01-07 | 1961-01-03 | Republican | 33 | |||||||||||||
27965 | 27965 | Joe Kilgore K000177 | rep | TX | 1959-01-07 | 1961-01-03 | Democrat | 15 | |||||||||||||
27971 | 27971 | Victor Knox K000298 | rep | MI | 1959-01-07 | 1961-01-03 | Republican | 11 | |||||||||||||
27979 | 27979 | Richard Lankford L000081 | rep | MD | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
27988 | 27988 | John Lesinski L000252 | rep | MI | 1959-01-07 | 1961-01-03 | Democrat | 16 | |||||||||||||
27992 | 27992 | Roland Libonati L000299 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 7 | |||||||||||||
28002 | 28002 | Clifford McIntire M000478 | rep | ME | 1959-01-07 | 1961-01-03 | Republican | 3 | |||||||||||||
28010 | 28010 | George Meader M000620 | rep | MI | 1959-01-07 | 1961-01-03 | Republican | 2 | |||||||||||||
28017 | 28017 | William Miller M000762 | rep | NY | 1959-01-07 | 1961-01-03 | Republican | 40 | |||||||||||||
28020 | 28020 | William Milliken M000770 | rep | PA | 1959-01-07 | 1961-01-03 | Republican | 7 | |||||||||||||
28048 | 28048 | Albin Norblad N000133 | rep | OR | 1959-01-07 | 1961-01-03 | Republican | 1 | |||||||||||||
28064 | 28064 | Thomas O’Brien O000016 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
28073 | 28073 | Frank Osmers O000120 | rep | NJ | 1959-01-07 | 1961-01-03 | Republican | 9 | |||||||||||||
28080 | 28080 | Harold Ostertag O000121 | rep | NY | 1959-01-07 | 1961-01-03 | Republican | 39 | |||||||||||||
28086 | 28086 | John Pilcher P000349 | rep | GA | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
28092 | 28092 | John Pillion P000352 | rep | NY | 1959-01-07 | 1961-01-03 | Republican | 42 | |||||||||||||
28102 | 28102 | Albert Rains R000018 | rep | AL | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
28112 | 28112 | Roy Riehlman R000250 | rep | NY | 1959-01-07 | 1961-01-03 | Republican | 35 | |||||||||||||
28119 | 28119 | Kenneth Roberts R000314 | rep | AL | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
28128 | 28128 | Paul Schenck S000117 | rep | OH | 1959-01-07 | 1961-01-03 | Republican | 3 | |||||||||||||
28136 | 28136 | John Shelley S000327 | rep | CA | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
28150 | 28150 | Harry Sheppard S000335 | rep | CA | 1959-01-07 | 1961-01-03 | Democrat | 27 | |||||||||||||
28153 | 28153 | Don Short S000378 | rep | ND | 1959-01-07 | 1961-01-03 | Republican | 0 | |||||||||||||
28160 | 28160 | Eugene Siler S000408 | rep | KY | 1959-01-07 | 1961-01-03 | Republican | 8 | |||||||||||||
28174 | 28174 | Katharine St. George S000764 | rep | NY | 1959-01-07 | 1961-01-03 | Republican | 28 | |||||||||||||
28184 | 28184 | William Thornberry T000237 | rep | TX | 1959-01-07 | 1961-01-03 | Democrat | 10 | |||||||||||||
28193 | 28193 | Thor Tollefson T000298 | rep | WA | 1959-01-07 | 1961-01-03 | Republican | 6 | |||||||||||||
28200 | 28200 | William Van Pelt V000051 | rep | WI | 1959-01-07 | 1961-01-03 | Republican | 6 |
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);