legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
489 rows where "end" is on date 1963-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27572 | 27572 | Stewart Udall U000002 | rep | AZ | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
27629 | 27629 | Howard Baker B000062 | rep | TN | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
27657 | 27657 | Daniel Brewster B000813 | rep | MD | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
27659 | 27659 | James Bromwell B000867 | rep | IA | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
27740 | 27740 | Steven Derounian D000266 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
27814 | 27814 | Milton Glenn G000237 | rep | NJ | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
27828 | 27828 | George Grant G000381 | rep | AL | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
27841 | 27841 | Ralph Harding H000191 | rep | ID | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
28011 | 28011 | George Meader M000620 | rep | MI | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
28087 | 28087 | John Pilcher P000349 | rep | GA | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
28254 | 28254 | Alfred Westland W000310 | rep | WA | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
28419 | 28419 | Robert Ellsworth E000148 | rep | KS | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
28509 | 28509 | David King K000199 | rep | UT | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
28727 | 28727 | Stanley Tupper T000411 | rep | ME | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
28812 | 28812 | Thomas Curtis C001014 | rep | MO | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
28840 | 28840 | John Fogarty F000233 | rep | RI | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
28873 | 28873 | Charles Halleck H000081 | rep | IN | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
28884 | 28884 | Porter Hardy H000197 | rep | VA | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
29003 | 29003 | Barratt O’Hara O000053 | rep | IL | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
29140 | 29140 | James Battin B000241 | rep | MT | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
29154 | 29154 | Ellis Berry B000416 | rep | SD | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
29193 | 29193 | Glenn Cunningham C000991 | rep | NE | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
29220 | 29220 | Peter Dominick D000409 | rep | CO | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
29617 | 29617 | Thomas Boggs B000594 | rep | LA | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
29761 | 29761 | Edmond Edmondson E000054 | rep | OK | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
30601 | 30601 | Ancher Nelsen N000028 | rep | MN | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
30868 | 30868 | Donald Clancy C000409 | rep | OH | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
31192 | 31192 | Wilbur Mills M000778 | rep | AR | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
32132 | 32132 | Harold Johnson J000135 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
32304 | 32304 | Harley Staggers S000778 | rep | WV | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
32357 | 32357 | Albert Ullman U000004 | rep | OR | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
32662 | 32662 | Lawrence Fountain F000319 | rep | NC | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
33498 | 33498 | Edward Boland B000600 | rep | MA | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
33959 | 33959 | Robert Kastenmeier K000020 | rep | WI | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
34239 | 34239 | Charles Bennett B000371 | rep | FL | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
35013 | 35013 | Morris Udall U000001 | rep | AZ | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
35139 | 35139 | Jack Brooks B000880 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
35461 | 35461 | William Natcher N000009 | rep | KY | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
35652 | 35652 | Jamie Whitten W000428 | rep | MS | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
27099 | 27099 | Cleveland Bailey B000035 | rep | WV | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
27141 | 27141 | Frank Burke B001090 | rep | KY | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
27210 | 27210 | James Frazier F000353 | rep | TN | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
27369 | 27369 | Walter McVey M000608 | rep | KS | 1961-01-03 | 1963-01-03 | Republican | 3 | |||||||||||||
27532 | 27532 | Frank Smith S000533 | rep | MS | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
27617 | 27617 | James Auchincloss A000227 | rep | NJ | 1961-01-03 | 1963-01-03 | Republican | 3 | |||||||||||||
27639 | 27639 | Frank Becker B000292 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 3 | |||||||||||||
27641 | 27641 | Ralph Beermann B000310 | rep | NE | 1961-01-03 | 1963-01-03 | Republican | 3 | |||||||||||||
27719 | 27719 | John Chenoweth C000346 | rep | CO | 1961-01-03 | 1963-01-03 | Republican | 3 | |||||||||||||
27788 | 27788 | Elijah Forrester F000283 | rep | GA | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
27798 | 27798 | Julian Gary G000091 | rep | VA | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
27931 | 27931 | August Johansen J000109 | rep | MI | 1961-01-03 | 1963-01-03 | Republican | 3 | |||||||||||||
28003 | 28003 | Clifford McIntire M000478 | rep | ME | 1961-01-03 | 1963-01-03 | Republican | 3 | |||||||||||||
28129 | 28129 | Paul Schenck S000117 | rep | OH | 1961-01-03 | 1963-01-03 | Republican | 3 | |||||||||||||
28326 | 28326 | Lindley Beckworth B000296 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
28724 | 28724 | James Trimble T000373 | rep | AR | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
29084 | 29084 | Edwin Willis W000559 | rep | LA | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
29346 | 29346 | Clark MacGregor M000010 | rep | MN | 1961-01-03 | 1963-01-03 | Republican | 3 | |||||||||||||
29393 | 29393 | William Murphy M001104 | rep | IL | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
29415 | 29415 | Philip Philbin P000303 | rep | MA | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
29553 | 29553 | George Andrews A000206 | rep | AL | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
29644 | 29644 | James Byrne B001212 | rep | PA | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
29808 | 29808 | Edward Garmatz G000071 | rep | MD | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
30322 | 30322 | William Dorn D000434 | rep | SC | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
30389 | 30389 | Edith Green G000407 | rep | OR | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
30420 | 30420 | Harold Gross G000495 | rep | IA | 1961-01-03 | 1963-01-03 | Republican | 3 | |||||||||||||
30455 | 30455 | Julia Hansen H000174 | rep | WA | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
30726 | 30726 | Vernon Thomson T000233 | rep | WI | 1961-01-03 | 1963-01-03 | Republican | 3 | |||||||||||||
30810 | 30810 | Carl Albert A000073 | rep | OK | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
31004 | 31004 | David Henderson H000479 | rep | NC | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
31362 | 31362 | Leonor Sullivan S001057 | rep | MO | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
31679 | 31679 | John Moss M001035 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
31810 | 31810 | Robert Sikes S000406 | rep | FL | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
31957 | 31957 | John Brademas B000736 | rep | IN | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
32077 | 32077 | Robert Giaimo G000151 | rep | CT | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
27139 | 27139 | Overton Brooks B000884 | rep | LA | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
27184 | 27184 | Edwin Durno D000575 | rep | OR | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
27244 | 27244 | Clare Hoffman H000683 | rep | MI | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
27458 | 27458 | Samuel Rayburn R000082 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
28120 | 28120 | Kenneth Roberts R000314 | rep | AL | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
28156 | 28156 | Abner Sibal S000395 | rep | CT | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
28369 | 28369 | Frank Chelf C000342 | rep | KY | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
28387 | 28387 | Harold Cooley C000736 | rep | NC | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
28457 | 28457 | Oren Harris H000249 | rep | AR | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
28768 | 28768 | Robert Ashmore A000223 | rep | SC | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
29074 | 29074 | John Williams W000517 | rep | MS | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
29108 | 29108 | Edwin Adair A000024 | rep | IN | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
29243 | 29243 | George Fallon F000012 | rep | MD | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
29356 | 29356 | Catherine May M000273 | rep | WA | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
29518 | 29518 | Watkins Abbitt A000002 | rep | VA | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
29565 | 29565 | Wayne Aspinall A000225 | rep | CO | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
29830 | 29830 | Seymour Halpern H000085 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
29879 | 29879 | John Kyl K000351 | rep | IA | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
29918 | 29918 | William McCulloch M000393 | rep | OH | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
30309 | 30309 | Harold Donohue D000419 | rep | MA | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
30538 | 30538 | William Mailliard M000070 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
30548 | 30548 | David Martin M000175 | rep | NE | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
30928 | 30928 | Joseph Evins E000273 | rep | TN | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
30990 | 30990 | Kenneth Hechler H000438 | rep | WV | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
31097 | 31097 | Joseph Karth K000014 | rep | MN | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
31282 | 31282 | William Randall R000041 | rep | MO | 1961-01-03 | 1963-01-03 | Democrat | 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);