legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
480 rows where "start" is on date 1957-01-03
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27721 | 27721 | Joseph Clark C000444 | sen | PA | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
27732 | 27732 | Clifford Davis D000094 | rep | TN | 1957-01-03 | 1959-01-03 | Democrat | 9 | |||||||||||||
27738 | 27738 | Steven Derounian D000266 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
27751 | 27751 | Everett Dirksen D000360 | sen | IL | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
27758 | 27758 | Clyde Doyle D000481 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 23 | |||||||||||||
27767 | 27767 | Carl Elliott E000120 | rep | AL | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
27777 | 27777 | Antonio Fernós-Isern F000087 | rep | PR | 1957-01-03 | 1959-01-03 | Popular Democrat | 0 | |||||||||||||
27786 | 27786 | Elijah Forrester F000283 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
27796 | 27796 | Julian Gary G000091 | rep | VA | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
27807 | 27807 | Leon Gavin G000102 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 23 | |||||||||||||
27812 | 27812 | Milton Glenn G000237 | rep | NJ | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
27826 | 27826 | George Grant G000381 | rep | AL | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
27835 | 27835 | William Green G000421 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
27856 | 27856 | Carl Hayden H000385 | sen | AZ | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
27859 | 27859 | James Healey H000424 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 22 | |||||||||||||
27863 | 27863 | Robert Hemphill H000471 | rep | SC | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
27869 | 27869 | Bourke Hickenlooper H000559 | sen | IA | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
27883 | 27883 | Joseph Hill H000598 | sen | AL | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
27892 | 27892 | Charles Hoeven H000678 | rep | IA | 1957-01-03 | 1959-01-03 | Republican | 8 | |||||||||||||
27906 | 27906 | Walter Horan H000786 | rep | WA | 1957-01-03 | 1959-01-03 | Republican | 5 | |||||||||||||
27911 | 27911 | George Huddleston H000904 | rep | AL | 1957-01-03 | 1959-01-03 | Democrat | 9 | |||||||||||||
27924 | 27924 | Benton Jensen J000100 | rep | IA | 1957-01-03 | 1959-01-03 | Republican | 7 | |||||||||||||
27929 | 27929 | August Johansen J000109 | rep | MI | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
27935 | 27935 | Lester Johnson J000158 | rep | WI | 1957-01-03 | 1959-01-03 | Democrat | 9 | |||||||||||||
27941 | 27941 | Olin Johnston J000195 | sen | SC | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
27946 | 27946 | Maude Kee K000040 | rep | WV | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
27959 | 27959 | Clarence Kilburn K000170 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 33 | |||||||||||||
27964 | 27964 | Joe Kilgore K000177 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 15 | |||||||||||||
27970 | 27970 | Victor Knox K000298 | rep | MI | 1957-01-03 | 1959-01-03 | Republican | 11 | |||||||||||||
27975 | 27975 | Thomas Kuchel K000335 | sen | CA | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
27978 | 27978 | Richard Lankford L000081 | rep | MD | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
27982 | 27982 | Frank Lausche L000122 | sen | OH | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
27987 | 27987 | John Lesinski L000252 | rep | MI | 1957-01-03 | 1959-01-03 | Democrat | 16 | |||||||||||||
27991 | 27991 | Roland Libonati L000299 | rep | IL | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
28001 | 28001 | Clifford McIntire M000478 | rep | ME | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
28009 | 28009 | George Meader M000620 | rep | MI | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
28016 | 28016 | William Miller M000762 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 40 | |||||||||||||
28030 | 28030 | Almer Monroney M000859 | sen | OK | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
28034 | 28034 | Wayne Morse M001014 | sen | OR | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
28039 | 28039 | Thruston Morton M001022 | sen | KY | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
28047 | 28047 | Albin Norblad N000133 | rep | OR | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
28063 | 28063 | Thomas O’Brien O000016 | rep | IL | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
28072 | 28072 | Frank Osmers O000120 | rep | NJ | 1957-01-03 | 1959-01-03 | Republican | 9 | |||||||||||||
28079 | 28079 | Harold Ostertag O000121 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 39 | |||||||||||||
28085 | 28085 | John Pilcher P000349 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
28091 | 28091 | John Pillion P000352 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 42 | |||||||||||||
28101 | 28101 | Albert Rains R000018 | rep | AL | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
28111 | 28111 | Roy Riehlman R000250 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 35 | |||||||||||||
28118 | 28118 | Kenneth Roberts R000314 | rep | AL | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
28127 | 28127 | Paul Schenck S000117 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
28135 | 28135 | John Shelley S000327 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
28149 | 28149 | Harry Sheppard S000335 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 27 | |||||||||||||
28159 | 28159 | Eugene Siler S000408 | rep | KY | 1957-01-03 | 1959-01-03 | Republican | 8 | |||||||||||||
28166 | 28166 | George Smathers S000505 | sen | FL | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
28173 | 28173 | Katharine St. George S000764 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 28 | |||||||||||||
28183 | 28183 | William Thornberry T000237 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 10 | |||||||||||||
28192 | 28192 | Thor Tollefson T000298 | rep | WA | 1957-01-03 | 1959-01-03 | Republican | 6 | |||||||||||||
28199 | 28199 | William Van Pelt V000051 | rep | WI | 1957-01-03 | 1959-01-03 | Republican | 6 | |||||||||||||
28225 | 28225 | Carl Vinson V000105 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
28244 | 28244 | Francis Walter W000108 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 15 | |||||||||||||
28252 | 28252 | Alfred Westland W000310 | rep | WA | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
28259 | 28259 | James Wharton W000323 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 29 | |||||||||||||
28280 | 28280 | Earl Wilson W000572 | rep | IN | 1957-01-03 | 1959-01-03 | Republican | 9 | |||||||||||||
28290 | 28290 | William Winstead W000641 | rep | MS | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
28303 | 28303 | Ross Bass B000223 | rep | TN | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
28311 | 28311 | John Baldwin B000092 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 6 | |||||||||||||
28324 | 28324 | Lindley Beckworth B000296 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
28338 | 28338 | Herbert Bonner B000621 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
28352 | 28352 | Clarence Brown B000909 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 7 | |||||||||||||
28367 | 28367 | Frank Chelf C000342 | rep | KY | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
28385 | 28385 | Harold Cooley C000736 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
28391 | 28391 | Willard Curtin C001005 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 8 | |||||||||||||
28401 | 28401 | Paul Dague D000004 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 9 | |||||||||||||
28409 | 28409 | Winfield Denton D000260 | rep | IN | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
28441 | 28441 | Harlan Hagen H000013 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 14 | |||||||||||||
28455 | 28455 | Oren Harris H000249 | rep | AR | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
28465 | 28465 | Ralph Harvey H000310 | rep | IN | 1957-01-03 | 1959-01-03 | Republican | 10 | |||||||||||||
28476 | 28476 | William Jennings J000098 | rep | VA | 1957-01-03 | 1959-01-03 | Democrat | 9 | |||||||||||||
28487 | 28487 | Paul Jones J000246 | rep | MO | 1957-01-03 | 1959-01-03 | Democrat | 10 | |||||||||||||
28503 | 28503 | Eugene Keogh K000130 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 9 | |||||||||||||
28545 | 28545 | Joseph Martin M000191 | rep | MA | 1957-01-03 | 1959-01-03 | Republican | 14 | |||||||||||||
28552 | 28552 | Donald Matthews M000253 | rep | FL | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
28561 | 28561 | Eugene McCarthy M000311 | rep | MN | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
28581 | 28581 | James Morrison M000995 | rep | LA | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
28594 | 28594 | Thomas Murray M001114 | rep | TN | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
28602 | 28602 | Leo O’Brien O000015 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 30 | |||||||||||||
28612 | 28612 | Winston Prouty P000552 | rep | VT | 1957-01-03 | 1959-01-03 | Republican | 0 | |||||||||||||
28624 | 28624 | Walter Rogers R000404 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 18 | |||||||||||||
28630 | 28630 | James Roosevelt R000426 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 26 | |||||||||||||
28638 | 28638 | Ralph Scott S000184 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
28670 | 28670 | Howard Smith S000554 | rep | VA | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
28687 | 28687 | Albert Thomas T000156 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
28699 | 28699 | Clark Thompson T000198 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 9 | |||||||||||||
28706 | 28706 | Theo Thompson T000218 | rep | LA | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
28722 | 28722 | James Trimble T000373 | rep | AR | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
28743 | 28743 | Ralph Yarborough Y000006 | sen | TX | 1957-01-03 | 1959-01-03 | 1 | Democrat | |||||||||||||
28766 | 28766 | Robert Ashmore A000223 | rep | SC | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
28778 | 28778 | Edward Bartlett B000201 | rep | AK | 1957-01-03 | 1959-01-03 | Democrat | 0 | |||||||||||||
28796 | 28796 | Frances Bolton B000607 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 22 | |||||||||||||
28810 | 28810 | Thomas Curtis C001014 | rep | MO | 1957-01-03 | 1959-01-03 | Republican | 2 |
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);