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 state descending
This data as json, copyable, CSV (advanced)
Suggested facets: party, start (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28893 | 28893 | William Harrison H000278 | rep | WY | 1963-01-09 | 1965-01-03 | Republican | 0 | |||||||||||||
29927 | 29927 | Gale McGee M000445 | sen | WY | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
27949 | 27949 | Maude Kee K000040 | rep | WV | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
28969 | 28969 | Arch Moore M000892 | rep | WV | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
30991 | 30991 | Kenneth Hechler H000438 | rep | WV | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
32285 | 32285 | John Slack S000473 | rep | WV | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
32305 | 32305 | Harley Staggers S000778 | rep | WV | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
37954 | 37954 | Robert Byrd B001210 | sen | WV | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
27938 | 27938 | Lester Johnson J000158 | rep | WI | 1963-01-09 | 1965-01-03 | Democrat | 9 | |||||||||||||
28202 | 28202 | William Van Pelt V000051 | rep | WI | 1963-01-09 | 1965-01-03 | Republican | 6 | |||||||||||||
29326 | 29326 | Melvin Laird L000024 | rep | WI | 1963-01-09 | 1965-01-03 | Republican | 7 | |||||||||||||
29482 | 29482 | Henry Schadeberg S000108 | rep | WI | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
29659 | 29659 | John Byrnes B001216 | rep | WI | 1963-01-09 | 1965-01-03 | Republican | 8 | |||||||||||||
30000 | 30000 | Alvin O’Konski O000058 | rep | WI | 1963-01-09 | 1965-01-03 | Republican | 10 | |||||||||||||
30727 | 30727 | Vernon Thomson T000233 | rep | WI | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
32813 | 32813 | Henry Reuss R000165 | rep | WI | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
33112 | 33112 | William Proxmire P000553 | sen | WI | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
33198 | 33198 | Clement Zablocki Z000001 | rep | WI | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
33960 | 33960 | Robert Kastenmeier K000020 | rep | WI | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
27909 | 27909 | Walter Horan H000786 | rep | WA | 1963-01-09 | 1965-01-03 | Republican | 5 | |||||||||||||
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 | |||||||||||||
28255 | 28255 | Alfred Westland W000310 | rep | WA | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
29357 | 29357 | Catherine May M000273 | rep | WA | 1963-01-09 | 1965-01-03 | Republican | 4 | |||||||||||||
30015 | 30015 | Thomas Pelly P000196 | rep | WA | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
30456 | 30456 | Julia Hansen H000174 | rep | WA | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
33006 | 33006 | Henry Jackson J000013 | sen | WA | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
28613 | 28613 | Winston Prouty P000552 | sen | VT | 1959-01-07 | 1965-01-03 | 1 | Republican | |||||||||||||
33147 | 33147 | Robert Stafford S000776 | rep | VT | 1963-01-09 | 1965-01-03 | Republican | 0 | |||||||||||||
26780 | 26780 | Harry Byrd B001208 | sen | VA | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
27799 | 27799 | Julian Gary G000091 | rep | VA | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
28479 | 28479 | William Jennings J000098 | rep | VA | 1963-01-09 | 1965-01-03 | Democrat | 9 | |||||||||||||
28673 | 28673 | Howard Smith S000554 | rep | VA | 1963-01-09 | 1965-01-03 | Democrat | 8 | |||||||||||||
28885 | 28885 | Porter Hardy H000197 | rep | VA | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
29056 | 29056 | William Tuck T000395 | rep | VA | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
29351 | 29351 | John Marsh M000148 | rep | VA | 1963-01-09 | 1965-01-03 | Democrat | 7 | |||||||||||||
29519 | 29519 | Watkins Abbitt A000002 | rep | VA | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
30032 | 30032 | Richard Poff P000401 | rep | VA | 1963-01-09 | 1965-01-03 | Republican | 6 | |||||||||||||
30207 | 30207 | Joel Broyhill B000967 | rep | VA | 1963-01-09 | 1965-01-03 | Republican | 10 | |||||||||||||
30903 | 30903 | Thomas Downing D000474 | rep | VA | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
29163 | 29163 | Laurence Burton B001155 | rep | UT | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
29894 | 29894 | Sherman Lloyd L000382 | rep | UT | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
29987 | 29987 | Frank Moss M001033 | sen | UT | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
27607 | 27607 | Bruce Alger A000106 | rep | TX | 1963-01-09 | 1965-01-03 | Republican | 5 | |||||||||||||
27967 | 27967 | Joe Kilgore K000177 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 15 | |||||||||||||
28186 | 28186 | William Thornberry T000237 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 10 | |||||||||||||
28327 | 28327 | Lindley Beckworth B000296 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
28627 | 28627 | Walter Rogers R000404 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 18 | |||||||||||||
28690 | 28690 | Albert Thomas T000156 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 8 | |||||||||||||
28702 | 28702 | Clark Thompson T000198 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 9 | |||||||||||||
28744 | 28744 | Ralph Yarborough Y000006 | sen | TX | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
29009 | 29009 | Joe Pool P000426 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
29269 | 29269 | Edgar Foreman F000272 | rep | TX | 1963-01-09 | 1965-01-03 | Republican | 16 | |||||||||||||
29744 | 29744 | John Dowdy D000467 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 7 | |||||||||||||
30045 | 30045 | Graham Purcell P000569 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 13 | |||||||||||||
30354 | 30354 | Ovie Fisher F000152 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 21 | |||||||||||||
30857 | 30857 | Robert Casey C000228 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 22 | |||||||||||||
31269 | 31269 | John Patman P000103 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
31461 | 31461 | Omar Burleson B001111 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 17 | |||||||||||||
31635 | 31635 | George Mahon M000065 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 19 | |||||||||||||
31731 | 31731 | William Poage P000398 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 11 | |||||||||||||
31855 | 31855 | Olin Teague T000110 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 6 | |||||||||||||
31905 | 31905 | John Young Y000043 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 14 | |||||||||||||
32254 | 32254 | Herbert Roberts R000312 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
34146 | 34146 | James Wright W000763 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 12 | |||||||||||||
35140 | 35140 | Jack Brooks B000880 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
35508 | 35508 | James Pickle P000328 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 10 | |||||||||||||
36204 | 36204 | Henry González G000272 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 20 | |||||||||||||
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 | |||||||||||||
27735 | 27735 | Clifford Davis D000094 | rep | TN | 1963-01-09 | 1965-01-03 | Democrat | 9 | |||||||||||||
28248 | 28248 | Herbert Walters W000110 | sen | TN | 1963-08-20 | 1965-01-03 | 2 | Democrat | appointment | ||||||||||||
28433 | 28433 | Albert Gore G000320 | sen | TN | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
28597 | 28597 | Thomas Murray M001114 | rep | TN | 1963-01-09 | 1965-01-03 | Democrat | 7 | |||||||||||||
29231 | 29231 | Robert Everett E000266 | rep | TN | 1963-01-09 | 1965-01-03 | Democrat | 8 | |||||||||||||
29634 | 29634 | William Brock B000851 | rep | TN | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
30929 | 30929 | Joseph Evins E000273 | rep | TN | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
30936 | 30936 | Richard Fulton F000424 | rep | TN | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
35975 | 35975 | James Quillen Q000013 | rep | TN | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
29155 | 29155 | Ellis Berry B000416 | rep | SD | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
29436 | 29436 | Benjamin Reifel R000152 | rep | SD | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
27866 | 27866 | Robert Hemphill H000471 | rep | SC | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
28769 | 28769 | Robert Ashmore A000223 | rep | SC | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
29454 | 29454 | Lucius Rivers R000280 | rep | SC | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
29502 | 29502 | Albert Watson W000197 | rep | SC | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
29943 | 29943 | John McMillan M000568 | rep | SC | 1963-01-09 | 1965-01-03 | Democrat | 6 | |||||||||||||
30323 | 30323 | William Dorn D000434 | rep | SC | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
30372 | 30372 | Thomas Gettys G000144 | rep | SC | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
28841 | 28841 | John Fogarty F000233 | rep | RI | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
30007 | 30007 | John Pastore P000100 | sen | RI | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
33749 | 33749 | Fernand St. Germain S000762 | rep | RI | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
27780 | 27780 | Antonio Fernós-Isern F000087 | rep | PR | 1963-01-09 | 1965-01-03 | Popular Democrat | 0 | |||||||||||||
27810 | 27810 | Leon Gavin G000102 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 23 | |||||||||||||
27838 | 27838 | William Green G000421 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
28022 | 28022 | William Milliken M000770 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 7 | |||||||||||||
28247 | 28247 | Francis Walter W000108 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 15 | |||||||||||||
28249 | 28249 | James Weaver W000226 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 24 | |||||||||||||
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 | |||||||||||||
28519 | 28519 | John Kunkel K000341 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 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);