legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
483 rows where "end" is on date 1971-01-03 sorted by district
This data as json, copyable, CSV (advanced)
Suggested facets: class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28417 | 28417 | Thomas Dodd D000390 | sen | CT | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
28434 | 28434 | Albert Gore G000320 | sen | TN | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
28473 | 28473 | Spessard Holland H000720 | sen | FL | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
28563 | 28563 | Eugene McCarthy M000311 | sen | MN | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
28586 | 28586 | George Murphy M001092 | sen | CA | 1965-01-04 | 1971-01-03 | 1 | Republican | |||||||||||||
28614 | 28614 | Winston Prouty P000552 | sen | VT | 1965-01-04 | 1971-01-03 | 1 | Republican | |||||||||||||
28732 | 28732 | Joseph Tydings T000445 | sen | MD | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
28742 | 28742 | John Williams W000518 | sen | DE | 1965-01-04 | 1971-01-03 | 1 | Republican | |||||||||||||
28745 | 28745 | Ralph Yarborough Y000006 | sen | TX | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
28751 | 28751 | Stephen Young Y000053 | sen | OH | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
29102 | 29102 | Charles Goodell G000282 | sen | NY | 1968-09-10 | 1971-01-03 | 1 | Republican | appointment | ||||||||||||
29485 | 29485 | Ralph Smith S000602 | sen | IL | 1969-09-17 | 1971-01-03 | 3 | Republican | appointment | ||||||||||||
29771 | 29771 | Paul Fannin F000013 | sen | AZ | 1965-01-04 | 1971-01-03 | 1 | Republican | |||||||||||||
29774 | 29774 | Hiram Fong F000245 | sen | HI | 1965-01-04 | 1971-01-03 | 1 | Republican | |||||||||||||
29837 | 29837 | Philip Hart H000291 | sen | MI | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
29840 | 29840 | Rupert Hartke H000297 | sen | IN | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
29846 | 29846 | Roman Hruska H000875 | sen | NE | 1965-01-04 | 1971-01-03 | 1 | Republican | |||||||||||||
29909 | 29909 | Michael Mansfield M000113 | sen | MT | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
29928 | 29928 | Gale McGee M000445 | sen | WY | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
29974 | 29974 | Joseph Montoya M000876 | sen | NM | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
29988 | 29988 | Frank Moss M001033 | sen | UT | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
30008 | 30008 | John Pastore P000100 | sen | RI | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
30080 | 30080 | Hugh Scott S000174 | sen | PA | 1965-01-04 | 1971-01-03 | 1 | Republican | |||||||||||||
30103 | 30103 | William Symington S001136 | sen | MO | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
31469 | 31469 | Harry Byrd B001209 | sen | VA | 1965-11-12 | 1971-01-03 | 1 | Democrat | appointment | ||||||||||||
31477 | 31477 | Howard Cannon C000120 | sen | NV | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
31689 | 31689 | Edmund Muskie M001121 | sen | ME | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
31896 | 31896 | Harrison Williams W000502 | sen | NJ | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
33007 | 33007 | Henry Jackson J000013 | sen | WA | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
33113 | 33113 | William Proxmire P000553 | sen | WI | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
33158 | 33158 | John Stennis S000852 | sen | MS | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
33841 | 33841 | Quentin Burdick B001077 | sen | ND | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
37955 | 37955 | Robert Byrd B001210 | sen | WV | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
38150 | 38150 | Edward Kennedy K000105 | sen | MA | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
29421 | 29421 | Howard Pollock P000415 | rep | AK | 1969-01-03 | 1971-01-03 | Republican | 0 | |||||||||||||
29506 | 29506 | John Wold W000671 | rep | WY | 1969-01-03 | 1971-01-03 | Republican | 0 | |||||||||||||
29579 | 29579 | Walter Baring B000141 | rep | NV | 1969-01-03 | 1971-01-03 | Democrat | 0 | |||||||||||||
29733 | 29733 | Jorge Córdova Díaz C000775 | rep | PR | 1969-01-03 | 1971-01-03 | New Progressive | 0 | |||||||||||||
33150 | 33150 | Robert Stafford S000776 | rep | VT | 1969-01-03 | 1971-01-03 | Republican | 0 | |||||||||||||
36018 | 36018 | William Roth R000460 | rep | DE | 1969-01-03 | 1971-01-03 | Republican | 0 | |||||||||||||
29166 | 29166 | Laurence Burton B001155 | rep | UT | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
29203 | 29203 | Emilio Daddario D000001 | rep | CT | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
29217 | 29217 | William Dawson D000158 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
29219 | 29219 | Robert Denney D000239 | rep | NE | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
29405 | 29405 | Arnold Olsen O000083 | rep | MT | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
29439 | 29439 | Benjamin Reifel R000152 | rep | SD | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
29457 | 29457 | Lucius Rivers R000280 | rep | SC | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
29467 | 29467 | Byron Rogers R000389 | rep | CO | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
29484 | 29484 | Henry Schadeberg S000108 | rep | WI | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
29537 | 29537 | Thomas Abernethy A000016 | rep | MS | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
29593 | 29593 | Page Belcher B000323 | rep | OK | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
29821 | 29821 | George Hagan H000010 | rep | GA | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
29985 | 29985 | Rogers Morton M001021 | rep | MD | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
30018 | 30018 | Thomas Pelly P000196 | rep | WA | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
30069 | 30069 | Frederick Schwengel S000161 | rep | IA | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
30107 | 30107 | Robert Taft T000010 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
30511 | 30511 | John Hunt H000972 | rep | NJ | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
30528 | 30528 | Peter Kyros K000356 | rep | ME | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
30713 | 30713 | Frank Stubblefield S001037 | rep | KY | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
30768 | 30768 | Wendell Wyatt W000778 | rep | OR | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
30783 | 30783 | Louis Wyman W000782 | rep | NH | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
30831 | 30831 | William Barrett B000178 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
30906 | 30906 | Thomas Downing D000474 | rep | VA | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
31049 | 31049 | Felix Hébert H000437 | rep | LA | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
31156 | 31156 | Ray Madden M000039 | rep | IN | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
31272 | 31272 | John Patman P000103 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
31713 | 31713 | Otis Pike P000348 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
31745 | 31745 | Albert Quie Q000010 | rep | MN | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
31814 | 31814 | Robert Sikes S000406 | rep | FL | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
32277 | 32277 | Keith Sebelius S000217 | rep | KS | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
32438 | 32438 | Mark Andrews A000208 | rep | ND | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
32559 | 32559 | Donald Clausen C000475 | rep | CA | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
32783 | 32783 | Robert Mollohan M000845 | rep | WV | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
32831 | 32831 | John Rhodes R000188 | rep | AZ | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
32950 | 32950 | William Edwards E000084 | rep | AL | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
33353 | 33353 | James McClure M000346 | rep | ID | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
33657 | 33657 | Manuel Luján L000506 | rep | NM | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
33752 | 33752 | Fernand St. Germain S000762 | rep | RI | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
34162 | 34162 | William Alexander A000103 | rep | AR | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
34330 | 34330 | Silvio Conte C000709 | rep | MA | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
34622 | 34622 | Walter Jones J000256 | rep | NC | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
35978 | 35978 | James Quillen Q000013 | rep | TN | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
36557 | 36557 | William Clay C000488 | rep | MO | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
37029 | 37029 | Patsy Mink M000797 | rep | HI | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
40557 | 40557 | John Conyers C000714 | rep | MI | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
29144 | 29144 | James Battin B000241 | rep | MT | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
29158 | 29158 | Ellis Berry B000416 | rep | SD | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
29197 | 29197 | Glenn Cunningham C000991 | rep | NE | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
29270 | 29270 | Edgar Foreman F000272 | rep | NM | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
29320 | 29320 | Thomas Kleppe K000264 | rep | ND | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
29391 | 29391 | Chester Mize M000832 | rep | KS | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
29400 | 29400 | Maston O’Neal O000090 | rep | GA | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
29489 | 29489 | William St. Onge S000769 | rep | CT | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
29505 | 29505 | Albert Watson W000197 | rep | SC | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
29621 | 29621 | Thomas Boggs B000594 | rep | LA | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
29747 | 29747 | John Dowdy D000467 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
29765 | 29765 | Edmond Edmondson E000054 | rep | OK | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
29896 | 29896 | Sherman Lloyd L000382 | rep | UT | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
30199 | 30199 | Donald Brotzman B000893 | rep | CO | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
30430 | 30430 | James Grover G000504 | rep | NY | 1969-01-03 | 1971-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);