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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28226 | 28226 | Carl Vinson V000105 | rep | GA | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
28229 | 28229 | George Wallhauser W000089 | rep | NJ | 1959-01-07 | 1961-01-03 | Republican | 12 | |||||||||||||
28245 | 28245 | Francis Walter W000108 | rep | PA | 1959-01-07 | 1961-01-03 | Democrat | 15 | |||||||||||||
28253 | 28253 | Alfred Westland W000310 | rep | WA | 1959-01-07 | 1961-01-03 | Republican | 2 | |||||||||||||
28260 | 28260 | James Wharton W000323 | rep | NY | 1959-01-07 | 1961-01-03 | Republican | 29 | |||||||||||||
28291 | 28291 | William Winstead W000641 | rep | MS | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
28304 | 28304 | Ross Bass B000223 | rep | TN | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
28312 | 28312 | John Baldwin B000092 | rep | CA | 1959-01-07 | 1961-01-03 | Republican | 6 | |||||||||||||
28325 | 28325 | Lindley Beckworth B000296 | rep | TX | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
28339 | 28339 | Herbert Bonner B000621 | rep | NC | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
28353 | 28353 | Clarence Brown B000909 | rep | OH | 1959-01-07 | 1961-01-03 | Republican | 7 | |||||||||||||
28368 | 28368 | Frank Chelf C000342 | rep | KY | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
28386 | 28386 | Harold Cooley C000736 | rep | NC | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
28392 | 28392 | Willard Curtin C001005 | rep | PA | 1959-01-07 | 1961-01-03 | Republican | 8 | |||||||||||||
28402 | 28402 | Paul Dague D000004 | rep | PA | 1959-01-07 | 1961-01-03 | Republican | 9 | |||||||||||||
28410 | 28410 | Winfield Denton D000260 | rep | IN | 1959-01-07 | 1961-01-03 | Democrat | 8 | |||||||||||||
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 | |||||||||||||
28442 | 28442 | Harlan Hagen H000013 | rep | CA | 1959-01-07 | 1961-01-03 | Democrat | 14 | |||||||||||||
28456 | 28456 | Oren Harris H000249 | rep | AR | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
28472 | 28472 | Spessard Holland H000720 | sen | FL | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
28477 | 28477 | William Jennings J000098 | rep | VA | 1959-01-07 | 1961-01-03 | Democrat | 9 | |||||||||||||
28488 | 28488 | Paul Jones J000246 | rep | MO | 1959-01-07 | 1961-01-03 | Democrat | 10 | |||||||||||||
28504 | 28504 | Eugene Keogh K000130 | rep | NY | 1959-01-07 | 1961-01-03 | Democrat | 9 | |||||||||||||
28508 | 28508 | David King K000199 | rep | UT | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
28521 | 28521 | John Lindsay L000326 | rep | NY | 1959-01-07 | 1961-01-03 | Republican | 17 | |||||||||||||
28546 | 28546 | Joseph Martin M000191 | rep | MA | 1959-01-07 | 1961-01-03 | Republican | 14 | |||||||||||||
28553 | 28553 | Donald Matthews M000253 | rep | FL | 1959-01-07 | 1961-01-03 | Democrat | 8 | |||||||||||||
28562 | 28562 | Eugene McCarthy M000311 | sen | MN | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
28565 | 28565 | Harris McDowell M000418 | rep | DE | 1959-01-07 | 1961-01-03 | Democrat | 0 | |||||||||||||
28571 | 28571 | Walter Moeller M000836 | rep | OH | 1959-01-07 | 1961-01-03 | Democrat | 10 | |||||||||||||
28582 | 28582 | James Morrison M000995 | rep | LA | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
28595 | 28595 | Thomas Murray M001114 | rep | TN | 1959-01-07 | 1961-01-03 | Democrat | 7 | |||||||||||||
28603 | 28603 | Leo O’Brien O000015 | rep | NY | 1959-01-07 | 1961-01-03 | Democrat | 30 | |||||||||||||
28613 | 28613 | Winston Prouty P000552 | sen | VT | 1959-01-07 | 1965-01-03 | 1 | Republican | |||||||||||||
28617 | 28617 | Ralph Rivers R000282 | rep | AK | 1959-01-07 | 1961-01-03 | Democrat | 0 | |||||||||||||
28625 | 28625 | Walter Rogers R000404 | rep | TX | 1959-01-07 | 1961-01-03 | Democrat | 18 | |||||||||||||
28631 | 28631 | James Roosevelt R000426 | rep | CA | 1959-01-07 | 1961-01-03 | Democrat | 26 | |||||||||||||
28639 | 28639 | Ralph Scott S000184 | rep | NC | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
28671 | 28671 | Howard Smith S000554 | rep | VA | 1959-01-07 | 1961-01-03 | Democrat | 8 | |||||||||||||
28688 | 28688 | Albert Thomas T000156 | rep | TX | 1959-01-07 | 1961-01-03 | Democrat | 8 | |||||||||||||
28700 | 28700 | Clark Thompson T000198 | rep | TX | 1959-01-07 | 1961-01-03 | Democrat | 9 | |||||||||||||
28707 | 28707 | Theo Thompson T000218 | rep | LA | 1959-01-07 | 1961-01-03 | Democrat | 7 | |||||||||||||
28712 | 28712 | Herman Toll T000297 | rep | PA | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
28723 | 28723 | James Trimble T000373 | rep | AR | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
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 | |||||||||||||
28767 | 28767 | Robert Ashmore A000223 | rep | SC | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
28779 | 28779 | Edward Bartlett B000201 | sen | AK | 1959-01-07 | 1961-01-03 | 2 | Democrat | |||||||||||||
28797 | 28797 | Frances Bolton B000607 | rep | OH | 1959-01-07 | 1961-01-03 | Republican | 22 | |||||||||||||
28811 | 28811 | Thomas Curtis C001014 | rep | MO | 1959-01-07 | 1961-01-03 | Republican | 2 | |||||||||||||
28825 | 28825 | Paul Fino F000137 | rep | NY | 1959-01-07 | 1961-01-03 | Republican | 25 | |||||||||||||
28839 | 28839 | John Fogarty F000233 | rep | RI | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
28855 | 28855 | Ezekiel Gathings G000098 | rep | AR | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
28872 | 28872 | Charles Halleck H000081 | rep | IN | 1959-01-07 | 1961-01-03 | Republican | 2 | |||||||||||||
28883 | 28883 | Porter Hardy H000197 | rep | VA | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
28900 | 28900 | Albert Herlong H000530 | rep | FL | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
28908 | 28908 | Elmer Holland H000717 | rep | PA | 1959-01-07 | 1961-01-03 | Democrat | 30 | |||||||||||||
28913 | 28913 | Donald Irwin I000039 | rep | CT | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
28927 | 28927 | Frank Karsten K000013 | rep | MO | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
28937 | 28937 | Edna Kelly K000070 | rep | NY | 1959-01-07 | 1961-01-03 | Democrat | 10 | |||||||||||||
28951 | 28951 | Cecil King K000196 | rep | CA | 1959-01-07 | 1961-01-03 | Democrat | 17 | |||||||||||||
28967 | 28967 | Arch Moore M000892 | rep | WV | 1959-01-07 | 1961-01-03 | Republican | 1 | |||||||||||||
28972 | 28972 | Thomas Morris M000990 | rep | NM | 1959-01-07 | 1961-01-03 | Democrat | 0 | |||||||||||||
28983 | 28983 | Abraham Multer M001074 | rep | NY | 1959-01-07 | 1961-01-03 | Democrat | 13 | |||||||||||||
29002 | 29002 | Barratt O’Hara O000053 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
29019 | 29019 | George Rhodes R000187 | rep | PA | 1959-01-07 | 1961-01-03 | Democrat | 14 | |||||||||||||
29034 | 29034 | Armistead Selden S000232 | rep | AL | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
29054 | 29054 | William Tuck T000395 | rep | VA | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
29062 | 29062 | Basil Whitener W000410 | rep | NC | 1959-01-07 | 1961-01-03 | Democrat | 11 | |||||||||||||
29073 | 29073 | John Williams W000517 | rep | MS | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
29083 | 29083 | Edwin Willis W000559 | rep | LA | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
29091 | 29091 | Jesse Younger Y000060 | rep | CA | 1959-01-07 | 1961-01-03 | Republican | 9 | |||||||||||||
29098 | 29098 | Charles Goodell G000282 | rep | NY | 1959-01-07 | 1961-01-03 | Republican | 43 | |||||||||||||
29107 | 29107 | Edwin Adair A000024 | rep | IN | 1959-01-07 | 1961-01-03 | Republican | 4 | |||||||||||||
29123 | 29123 | William Ayres A000229 | rep | OH | 1959-01-07 | 1961-01-03 | Republican | 14 | |||||||||||||
29134 | 29134 | William Bates B000239 | rep | MA | 1959-01-07 | 1961-01-03 | Republican | 6 | |||||||||||||
29153 | 29153 | Ellis Berry B000416 | rep | SD | 1959-01-07 | 1961-01-03 | Republican | 2 | |||||||||||||
29169 | 29169 | William Cahill C000019 | rep | NJ | 1959-01-07 | 1961-01-03 | Republican | 1 | |||||||||||||
29175 | 29175 | Jeffery Cohelan C000596 | rep | CA | 1959-01-07 | 1961-01-03 | Democrat | 7 | |||||||||||||
29185 | 29185 | William Cramer C000869 | rep | FL | 1959-01-07 | 1961-01-03 | Republican | 1 | |||||||||||||
29192 | 29192 | Glenn Cunningham C000991 | rep | NE | 1959-01-07 | 1961-01-03 | Republican | 2 | |||||||||||||
29198 | 29198 | Emilio Daddario D000001 | rep | CT | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
29212 | 29212 | William Dawson D000158 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
29229 | 29229 | Robert Everett E000266 | rep | TN | 1959-01-07 | 1961-01-03 | Democrat | 8 | |||||||||||||
29242 | 29242 | George Fallon F000012 | rep | MD | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
29249 | 29249 | Leonard Farbstein F000015 | rep | NY | 1959-01-07 | 1961-01-03 | Democrat | 19 | |||||||||||||
29263 | 29263 | Michael Feighan F000060 | rep | OH | 1959-01-07 | 1961-01-03 | Democrat | 20 | |||||||||||||
29274 | 29274 | Samuel Friedel F000384 | rep | MD | 1959-01-07 | 1961-01-03 | Democrat | 7 | |||||||||||||
29286 | 29286 | Jacob Gilbert G000175 | rep | NY | 1959-01-07 | 1961-01-03 | Democrat | 23 | |||||||||||||
29313 | 29313 | Michael Kirwan K000244 | rep | OH | 1959-01-07 | 1961-01-03 | Democrat | 19 | |||||||||||||
29324 | 29324 | Melvin Laird L000024 | rep | WI | 1959-01-07 | 1961-01-03 | Republican | 7 | |||||||||||||
29330 | 29330 | Odin Langen L000069 | rep | MN | 1959-01-07 | 1961-01-03 | Republican | 9 | |||||||||||||
29339 | 29339 | Glenard Lipscomb L000344 | rep | CA | 1959-01-07 | 1961-01-03 | Republican | 24 | |||||||||||||
29355 | 29355 | Catherine May M000273 | rep | WA | 1959-01-07 | 1961-01-03 | Republican | 4 | |||||||||||||
29380 | 29380 | John McCormack M000364 | rep | MA | 1959-01-07 | 1961-01-03 | Democrat | 12 | |||||||||||||
29392 | 29392 | William Murphy M001104 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
29414 | 29414 | Philip Philbin P000303 | rep | MA | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
29429 | 29429 | Adam Powell P000477 | rep | NY | 1959-01-07 | 1961-01-03 | Democrat | 16 |
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);