legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
482 rows where "start" is on date 1969-01-03 sorted by district
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29097 | 29097 | Marlow Cook C000721 | sen | KY | 1969-01-03 | 1974-12-27 | 3 | Republican | |||||||||||||
29118 | 29118 | George Aiken A000062 | sen | VT | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
29148 | 29148 | Wallace Bennett B000384 | sen | UT | 1969-01-03 | 1974-12-20 | 3 | Republican | |||||||||||||
29162 | 29162 | Alan Bible B000436 | sen | NV | 1969-01-03 | 1974-12-17 | 3 | Democrat | |||||||||||||
29222 | 29222 | Peter Dominick D000409 | sen | CO | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
29227 | 29227 | Samuel Ervin E000211 | sen | NC | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
29285 | 29285 | James Fulbright F000401 | sen | AR | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
29295 | 29295 | Edward Gurney G000531 | sen | FL | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
29296 | 29296 | Harold Hughes H000922 | sen | IA | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
29480 | 29480 | William Saxbe S000096 | sen | OH | 1969-01-03 | 1974-01-03 | 3 | Republican | |||||||||||||
30818 | 30818 | James Allen A000127 | sen | AL | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
30836 | 30836 | Birch Bayh B000254 | sen | IN | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
30846 | 30846 | Henry Bellmon B000351 | sen | OK | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
30866 | 30866 | Frank Church C000388 | sen | ID | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
30884 | 30884 | Norris Cotton C000802 | sen | NH | 1969-01-03 | 1974-12-31 | 3 | Republican | |||||||||||||
30943 | 30943 | Maurice Gravel G000388 | sen | AK | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
31072 | 31072 | Jacob Javits J000064 | sen | NY | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
31169 | 31169 | Warren Magnuson M000053 | sen | WA | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
31177 | 31177 | George McGovern M000452 | sen | SD | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
31226 | 31226 | Gaylord Nelson N000033 | sen | WI | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
31299 | 31299 | Abraham Ribicoff R000191 | sen | CT | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
31322 | 31322 | Richard Schweiker S000159 | sen | PA | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
31383 | 31383 | Herman Talmadge T000035 | sen | GA | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
31406 | 31406 | Milton Young Y000047 | sen | ND | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
32612 | 32612 | Thomas Eagleton E000004 | sen | MO | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
32680 | 32680 | Barry Goldwater G000267 | sen | AZ | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
32737 | 32737 | Russell Long L000428 | sen | LA | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
32747 | 32747 | Charles Mathias M000241 | sen | MD | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
33539 | 33539 | Alan Cranston C000877 | sen | CA | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
35194 | 35194 | Robert Dole D000401 | sen | KS | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
35488 | 35488 | Robert Packwood P000009 | sen | OR | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
36650 | 36650 | Ernest Hollings H000725 | sen | SC | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
39022 | 39022 | Daniel Inouye I000025 | sen | HI | 1969-01-03 | 1975-01-03 | 3 | 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 | |||||||||||||
30462 | 30462 | Orval Hansen H000175 | rep | ID | 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);