legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
481 rows where "start" is on date 1963-01-09 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
35975 | 35975 | James Quillen Q000013 | rep | TN | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
27623 | 27623 | William Avery A000228 | rep | KS | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
27660 | 27660 | James Bromwell B000867 | rep | IA | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
27815 | 27815 | Milton Glenn G000237 | rep | NJ | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
27842 | 27842 | Ralph Harding H000191 | rep | ID | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
28004 | 28004 | Clifford McIntire M000478 | rep | ME | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
28012 | 28012 | George Meader M000620 | rep | MI | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
28088 | 28088 | John Pilcher P000349 | rep | GA | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
28155 | 28155 | Don Short S000378 | rep | ND | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
28255 | 28255 | Alfred Westland W000310 | rep | WA | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
28813 | 28813 | Thomas Curtis C001014 | rep | MO | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
28841 | 28841 | John Fogarty F000233 | rep | RI | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
28874 | 28874 | Charles Halleck H000081 | rep | IN | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
28885 | 28885 | Porter Hardy H000197 | rep | VA | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
29004 | 29004 | Barratt O’Hara O000053 | rep | IL | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
29141 | 29141 | James Battin B000241 | rep | MT | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
29155 | 29155 | Ellis Berry B000416 | rep | SD | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
29194 | 29194 | Glenn Cunningham C000991 | rep | NE | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
29486 | 29486 | William St. Onge S000769 | rep | CT | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
29502 | 29502 | Albert Watson W000197 | rep | SC | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
29618 | 29618 | Thomas Boggs B000594 | rep | LA | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
29762 | 29762 | Edmond Edmondson E000054 | rep | OK | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
29894 | 29894 | Sherman Lloyd L000382 | rep | UT | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
30197 | 30197 | Donald Brotzman B000893 | rep | CO | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
30427 | 30427 | James Grover G000504 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
30602 | 30602 | Ancher Nelsen N000028 | rep | MN | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
30869 | 30869 | Donald Clancy C000409 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
31193 | 31193 | Wilbur Mills M000778 | rep | AR | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
31697 | 31697 | Robert Nix N000113 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
31991 | 31991 | James Cleveland C000512 | rep | NH | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
32133 | 32133 | Harold Johnson J000135 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
32305 | 32305 | Harley Staggers S000778 | rep | WV | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
32358 | 32358 | Albert Ullman U000004 | rep | OR | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
32663 | 32663 | Lawrence Fountain F000319 | rep | NC | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
33028 | 33028 | Clarence Long L000413 | rep | MD | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
33499 | 33499 | Edward Boland B000600 | rep | MA | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
33960 | 33960 | Robert Kastenmeier K000020 | rep | WI | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
34003 | 34003 | Spark Matsunaga M000250 | rep | HI | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
34240 | 34240 | Charles Bennett B000371 | rep | FL | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
35014 | 35014 | Morris Udall U000001 | rep | AZ | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
35140 | 35140 | Jack Brooks B000880 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
35462 | 35462 | William Natcher N000009 | rep | KY | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
35653 | 35653 | Jamie Whitten W000428 | rep | MS | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
27618 | 27618 | James Auchincloss A000227 | rep | NJ | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
27720 | 27720 | John Chenoweth C000346 | rep | CO | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
27741 | 27741 | Steven Derounian D000266 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
27789 | 27789 | Elijah Forrester F000283 | rep | GA | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
27799 | 27799 | Julian Gary G000091 | rep | VA | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
27932 | 27932 | August Johansen J000109 | rep | MI | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
28130 | 28130 | Paul Schenck S000117 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
28327 | 28327 | Lindley Beckworth B000296 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
28420 | 28420 | Robert Ellsworth E000148 | rep | KS | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
28653 | 28653 | George Senner S000243 | rep | AZ | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
28725 | 28725 | James Trimble T000373 | rep | AR | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
29075 | 29075 | John Williams W000517 | rep | MS | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
29085 | 29085 | Edwin Willis W000559 | rep | LA | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
29347 | 29347 | Clark MacGregor M000010 | rep | MN | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
29394 | 29394 | William Murphy M001104 | rep | IL | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
29416 | 29416 | Philip Philbin P000303 | rep | MA | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
29634 | 29634 | William Brock B000851 | rep | TN | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
29645 | 29645 | James Byrne B001212 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
29809 | 29809 | Edward Garmatz G000071 | rep | MD | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
30323 | 30323 | William Dorn D000434 | rep | SC | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
30390 | 30390 | Edith Green G000407 | rep | OR | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
30421 | 30421 | Harold Gross G000495 | rep | IA | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
30456 | 30456 | Julia Hansen H000174 | rep | WA | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
30549 | 30549 | David Martin M000175 | rep | NE | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
30727 | 30727 | Vernon Thomson T000233 | rep | WI | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
30811 | 30811 | Carl Albert A000073 | rep | OK | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
31005 | 31005 | David Henderson H000479 | rep | NC | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
31363 | 31363 | Leonor Sullivan S001057 | rep | MO | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
31680 | 31680 | John Moss M001035 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
31958 | 31958 | John Brademas B000736 | rep | IN | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
32078 | 32078 | Robert Giaimo G000151 | rep | CT | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
32285 | 32285 | John Slack S000473 | rep | WV | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
33415 | 33415 | Marion Snyder S000669 | rep | KY | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
34049 | 34049 | Claude Pepper P000218 | rep | FL | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
28157 | 28157 | Abner Sibal S000395 | rep | CT | 1963-01-09 | 1965-01-03 | Republican | 4 | |||||||||||||
28293 | 28293 | William Winstead W000641 | rep | MS | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
28370 | 28370 | Frank Chelf C000342 | rep | KY | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
28388 | 28388 | Harold Cooley C000736 | rep | NC | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
28458 | 28458 | Oren Harris H000249 | rep | AR | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
28714 | 28714 | Herman Toll T000297 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
28769 | 28769 | Robert Ashmore A000223 | rep | SC | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
29109 | 29109 | Edwin Adair A000024 | rep | IN | 1963-01-09 | 1965-01-03 | Republican | 4 | |||||||||||||
29244 | 29244 | George Fallon F000012 | rep | MD | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
29357 | 29357 | Catherine May M000273 | rep | WA | 1963-01-09 | 1965-01-03 | Republican | 4 | |||||||||||||
29519 | 29519 | Watkins Abbitt A000002 | rep | VA | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
29566 | 29566 | Wayne Aspinall A000225 | rep | CO | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
29880 | 29880 | John Kyl K000351 | rep | IA | 1963-01-09 | 1965-01-03 | Republican | 4 | |||||||||||||
29919 | 29919 | William McCulloch M000393 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 4 | |||||||||||||
30310 | 30310 | Harold Donohue D000419 | rep | MA | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
30929 | 30929 | Joseph Evins E000273 | rep | TN | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
30991 | 30991 | Kenneth Hechler H000438 | rep | WV | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
31028 | 31028 | J. Hutchinson H001011 | rep | MI | 1963-01-09 | 1965-01-03 | Republican | 4 | |||||||||||||
31098 | 31098 | Joseph Karth K000014 | rep | MN | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
31283 | 31283 | William Randall R000041 | rep | MO | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
31325 | 31325 | Garner Shriver S000388 | rep | KS | 1963-01-09 | 1965-01-03 | Republican | 4 |
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);