legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
486 rows where "end" is on date 1953-01-03 sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28851 | 28851 | Ezekiel Gathings G000098 | rep | AR | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
28835 | 28835 | John Fogarty F000233 | rep | RI | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
28807 | 28807 | Thomas Curtis C001014 | rep | MO | 1951-01-03 | 1953-01-03 | Republican | 12 | |||||||||||||
28793 | 28793 | Frances Bolton B000607 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 22 | |||||||||||||
28784 | 28784 | James Boggs B000593 | rep | DE | 1951-01-03 | 1953-01-03 | Republican | 0 | |||||||||||||
28775 | 28775 | Edward Bartlett B000201 | rep | AK | 1951-01-03 | 1953-01-03 | Democrat | 0 | |||||||||||||
28739 | 28739 | John Williams W000518 | sen | DE | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
28719 | 28719 | James Trimble T000373 | rep | AR | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
28696 | 28696 | Clark Thompson T000198 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 9 | |||||||||||||
28684 | 28684 | Albert Thomas T000156 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
28667 | 28667 | Howard Smith S000554 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
28649 | 28649 | Robert Secrest S000219 | rep | OH | 1951-01-03 | 1953-01-03 | Democrat | 15 | |||||||||||||
28621 | 28621 | Walter Rogers R000404 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 18 | |||||||||||||
28609 | 28609 | Winston Prouty P000552 | rep | VT | 1951-01-03 | 1953-01-03 | Republican | 0 | |||||||||||||
28599 | 28599 | Leo O’Brien O000015 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 32 | |||||||||||||
28591 | 28591 | Thomas Murray M001114 | rep | TN | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
28578 | 28578 | James Morrison M000995 | rep | LA | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
28558 | 28558 | Eugene McCarthy M000311 | rep | MN | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
28542 | 28542 | Joseph Martin M000191 | rep | MA | 1951-01-03 | 1953-01-03 | Republican | 14 | |||||||||||||
28500 | 28500 | Eugene Keogh K000130 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 9 | |||||||||||||
28484 | 28484 | Paul Jones J000246 | rep | MO | 1951-01-03 | 1953-01-03 | Democrat | 10 | |||||||||||||
28470 | 28470 | Spessard Holland H000720 | sen | FL | 1947-01-03 | 1953-01-03 | 1 | Democrat | |||||||||||||
28462 | 28462 | Ralph Harvey H000310 | rep | IN | 1951-01-03 | 1953-01-03 | Republican | 10 | |||||||||||||
28452 | 28452 | Oren Harris H000249 | rep | AR | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
28431 | 28431 | Albert Gore G000320 | rep | TN | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
28407 | 28407 | Winfield Denton D000260 | rep | IN | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
28398 | 28398 | Paul Dague D000004 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 9 | |||||||||||||
28382 | 28382 | Harold Cooley C000736 | rep | NC | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
28364 | 28364 | Frank Chelf C000342 | rep | KY | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
28349 | 28349 | Clarence Brown B000909 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 7 | |||||||||||||
28335 | 28335 | Herbert Bonner B000621 | rep | NC | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
28323 | 28323 | Lindley Beckworth B000296 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
28287 | 28287 | William Winstead W000641 | rep | MS | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
28277 | 28277 | Earl Wilson W000572 | rep | IN | 1951-01-03 | 1953-01-03 | Republican | 9 | |||||||||||||
28267 | 28267 | Victor Wickersham W000439 | rep | OK | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
28256 | 28256 | James Wharton W000323 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 30 | |||||||||||||
28241 | 28241 | Francis Walter W000108 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 20 | |||||||||||||
28222 | 28222 | Carl Vinson V000105 | rep | GA | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
28196 | 28196 | William Van Pelt V000051 | rep | WI | 1951-01-03 | 1953-01-03 | Republican | 6 | |||||||||||||
28189 | 28189 | Thor Tollefson T000298 | rep | WA | 1951-01-03 | 1953-01-03 | Republican | 6 | |||||||||||||
28180 | 28180 | William Thornberry T000237 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 10 | |||||||||||||
28170 | 28170 | Katharine St. George S000764 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 29 | |||||||||||||
28146 | 28146 | Harry Sheppard S000335 | rep | CA | 1951-01-03 | 1953-01-03 | Democrat | 21 | |||||||||||||
28132 | 28132 | John Shelley S000327 | rep | CA | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
28124 | 28124 | Paul Schenck S000117 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
28115 | 28115 | Kenneth Roberts R000314 | rep | AL | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
28108 | 28108 | Roy Riehlman R000250 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 36 | |||||||||||||
28098 | 28098 | Albert Rains R000018 | rep | AL | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
28076 | 28076 | Harold Ostertag O000121 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 41 | |||||||||||||
28069 | 28069 | Frank Osmers O000120 | rep | NJ | 1951-01-03 | 1953-01-03 | Republican | 9 | |||||||||||||
28060 | 28060 | Thomas O’Brien O000016 | rep | IL | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
28044 | 28044 | Albin Norblad N000133 | rep | OR | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
28038 | 28038 | Thruston Morton M001022 | rep | KY | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
28013 | 28013 | William Miller M000762 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 42 | |||||||||||||
28006 | 28006 | George Meader M000620 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
27998 | 27998 | Clifford McIntire M000478 | rep | ME | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
27984 | 27984 | John Lesinski L000252 | rep | MI | 1951-01-03 | 1953-01-03 | Democrat | 16 | |||||||||||||
27956 | 27956 | Clarence Kilburn K000170 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 34 | |||||||||||||
27943 | 27943 | Maude Kee K000040 | rep | WV | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
27921 | 27921 | Benton Jensen J000100 | rep | IA | 1951-01-03 | 1953-01-03 | Republican | 7 | |||||||||||||
27903 | 27903 | Walter Horan H000786 | rep | WA | 1951-01-03 | 1953-01-03 | Republican | 5 | |||||||||||||
27889 | 27889 | Charles Hoeven H000678 | rep | IA | 1951-01-03 | 1953-01-03 | Republican | 8 | |||||||||||||
27832 | 27832 | William Green G000421 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
27823 | 27823 | George Grant G000381 | rep | AL | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
27804 | 27804 | Leon Gavin G000102 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 19 | |||||||||||||
27793 | 27793 | Julian Gary G000091 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
27783 | 27783 | Elijah Forrester F000283 | rep | GA | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
27774 | 27774 | Antonio Fernós-Isern F000087 | rep | PR | 1951-01-03 | 1953-01-03 | Popular Democrat | 0 | |||||||||||||
27764 | 27764 | Carl Elliott E000120 | rep | AL | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
27755 | 27755 | Clyde Doyle D000481 | rep | CA | 1951-01-03 | 1953-01-03 | Democrat | 18 | |||||||||||||
27729 | 27729 | Clifford Davis D000094 | rep | TN | 1951-01-03 | 1953-01-03 | Democrat | 10 | |||||||||||||
27714 | 27714 | John Chenoweth C000346 | rep | CO | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
27693 | 27693 | Clarence Cannon C000117 | rep | MO | 1951-01-03 | 1953-01-03 | Democrat | 9 | |||||||||||||
27671 | 27671 | Charles Buckley B001024 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 25 | |||||||||||||
27646 | 27646 | John Bennett B000377 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 12 | |||||||||||||
27624 | 27624 | Howard Baker B000062 | rep | TN | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
27612 | 27612 | James Auchincloss A000227 | rep | NJ | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
27596 | 27596 | John Kennedy K000107 | rep | MA | 1951-01-03 | 1953-01-03 | Democrat | 11 | |||||||||||||
27578 | 27578 | James Van Zandt V000069 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 22 | |||||||||||||
27563 | 27563 | John Taber T000001 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 38 | |||||||||||||
27543 | 27543 | Brent Spence S000717 | rep | KY | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
27527 | 27527 | Frank Smith S000533 | rep | MS | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
27522 | 27522 | Horace Seely-Brown S000224 | rep | CT | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
27481 | 27481 | John Riley R000260 | rep | SC | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
27471 | 27471 | Brazilla Reece R000108 | rep | TN | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
27453 | 27453 | Samuel Rayburn R000082 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
27423 | 27423 | Louis Rabaut R000001 | rep | MI | 1951-01-03 | 1953-01-03 | Democrat | 14 | |||||||||||||
27404 | 27404 | William Norrell N000137 | rep | AR | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
27390 | 27390 | Walter Mumma M001077 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 18 | |||||||||||||
27384 | 27384 | Morgan Moulder M001045 | rep | MO | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
27374 | 27374 | Chester Merrow M000664 | rep | NH | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
27359 | 27359 | Gordon McDonough M000414 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 15 | |||||||||||||
27350 | 27350 | Noah Mason M000224 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 15 | |||||||||||||
27337 | 27337 | Fred Marshall M000152 | rep | MN | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
27325 | 27325 | Peter Mack M000020 | rep | IL | 1951-01-03 | 1953-01-03 | Democrat | 21 | |||||||||||||
27318 | 27318 | Thaddeus Machrowicz M000014 | rep | MI | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
27309 | 27309 | Thomas Lane L000065 | rep | MA | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
27293 | 27293 | Paul Kilday K000171 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 20 | |||||||||||||
27270 | 27270 | Carroll Kearns K000032 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 28 | |||||||||||||
27262 | 27262 | Walter Judd J000278 | rep | MN | 1951-01-03 | 1953-01-03 | Republican | 5 |
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);