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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29288 | 29288 | Jacob Gilbert G000175 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 22 | |||||||||||||
29292 | 29292 | Edward Gurney G000531 | rep | FL | 1963-01-09 | 1965-01-03 | Republican | 11 | |||||||||||||
29298 | 29298 | Charles Joelson J000108 | rep | NJ | 1963-01-09 | 1965-01-03 | Democrat | 8 | |||||||||||||
29315 | 29315 | Michael Kirwan K000244 | rep | OH | 1963-01-09 | 1965-01-03 | Democrat | 19 | |||||||||||||
29326 | 29326 | Melvin Laird L000024 | rep | WI | 1963-01-09 | 1965-01-03 | Republican | 7 | |||||||||||||
29332 | 29332 | Odin Langen L000069 | rep | MN | 1963-01-09 | 1965-01-03 | Republican | 7 | |||||||||||||
29341 | 29341 | Glenard Lipscomb L000344 | rep | CA | 1963-01-09 | 1965-01-03 | Republican | 24 | |||||||||||||
29347 | 29347 | Clark MacGregor M000010 | rep | MN | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
29351 | 29351 | John Marsh M000148 | rep | VA | 1963-01-09 | 1965-01-03 | Democrat | 7 | |||||||||||||
29357 | 29357 | Catherine May M000273 | rep | WA | 1963-01-09 | 1965-01-03 | Republican | 4 | |||||||||||||
29382 | 29382 | John McCormack M000364 | rep | MA | 1963-01-09 | 1965-01-03 | Democrat | 9 | |||||||||||||
29394 | 29394 | William Murphy M001104 | rep | IL | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
29402 | 29402 | Arnold Olsen O000083 | rep | MT | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
29416 | 29416 | Philip Philbin P000303 | rep | MA | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
29431 | 29431 | Adam Powell P000477 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 18 | |||||||||||||
29436 | 29436 | Benjamin Reifel R000152 | rep | SD | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
29454 | 29454 | Lucius Rivers R000280 | rep | SC | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
29464 | 29464 | Byron Rogers R000389 | rep | CO | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
29472 | 29472 | Richard Roudebush R000464 | rep | IN | 1963-01-09 | 1965-01-03 | Republican | 6 | |||||||||||||
29476 | 29476 | Donald Rumsfeld R000508 | rep | IL | 1963-01-09 | 1965-01-03 | Republican | 13 | |||||||||||||
29482 | 29482 | Henry Schadeberg S000108 | rep | WI | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
29486 | 29486 | William St. Onge S000769 | rep | CT | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
29495 | 29495 | James Utt U000034 | rep | CA | 1963-01-09 | 1965-01-03 | Republican | 35 | |||||||||||||
29502 | 29502 | Albert Watson W000197 | rep | SC | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
29519 | 29519 | Watkins Abbitt A000002 | rep | VA | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
29534 | 29534 | Thomas Abernethy A000016 | rep | MS | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
29554 | 29554 | George Andrews A000206 | rep | AL | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
29566 | 29566 | Wayne Aspinall A000225 | rep | CO | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
29576 | 29576 | Walter Baring B000141 | rep | NV | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
29590 | 29590 | Page Belcher B000323 | rep | OK | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
29601 | 29601 | Jackson Betts B000426 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 8 | |||||||||||||
29618 | 29618 | Thomas Boggs B000594 | rep | LA | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
29629 | 29629 | Frank Bow B000676 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 16 | |||||||||||||
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 | |||||||||||||
29659 | 29659 | John Byrnes B001216 | rep | WI | 1963-01-09 | 1965-01-03 | Republican | 8 | |||||||||||||
29691 | 29691 | Emanuel Celler C000264 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 10 | |||||||||||||
29711 | 29711 | William Colmer C000645 | rep | MS | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
29727 | 29727 | Robert Corbett C000772 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 18 | |||||||||||||
29744 | 29744 | John Dowdy D000467 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 7 | |||||||||||||
29752 | 29752 | Florence Dwyer D000587 | rep | NJ | 1963-01-09 | 1965-01-03 | Republican | 6 | |||||||||||||
29762 | 29762 | Edmond Edmondson E000054 | rep | OK | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
29785 | 29785 | James Fulton F000422 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 27 | |||||||||||||
29795 | 29795 | Cornelius Gallagher G000016 | rep | NJ | 1963-01-09 | 1965-01-03 | Democrat | 13 | |||||||||||||
29809 | 29809 | Edward Garmatz G000071 | rep | MD | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
29818 | 29818 | George Hagan H000010 | rep | GA | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
29824 | 29824 | Durward Hall H000049 | rep | MO | 1963-01-09 | 1965-01-03 | Republican | 7 | |||||||||||||
29831 | 29831 | Seymour Halpern H000085 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 6 | |||||||||||||
29852 | 29852 | William Hull H000947 | rep | MO | 1963-01-09 | 1965-01-03 | Democrat | 6 | |||||||||||||
29862 | 29862 | Charles Jonas J000206 | rep | NC | 1963-01-09 | 1965-01-03 | Republican | 8 | |||||||||||||
29873 | 29873 | Hastings Keith K000053 | rep | MA | 1963-01-09 | 1965-01-03 | Republican | 12 | |||||||||||||
29880 | 29880 | John Kyl K000351 | rep | IA | 1963-01-09 | 1965-01-03 | Republican | 4 | |||||||||||||
29888 | 29888 | Alton Lennon L000240 | rep | NC | 1963-01-09 | 1965-01-03 | Democrat | 7 | |||||||||||||
29894 | 29894 | Sherman Lloyd L000382 | rep | UT | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
29919 | 29919 | William McCulloch M000393 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 4 | |||||||||||||
29943 | 29943 | John McMillan M000568 | rep | SC | 1963-01-09 | 1965-01-03 | Democrat | 6 | |||||||||||||
29957 | 29957 | George Miller M000727 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 8 | |||||||||||||
29964 | 29964 | John Monagan M000847 | rep | CT | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
29972 | 29972 | Joseph Montoya M000876 | rep | NM | 1963-01-09 | 1964-11-03 | Democrat | 0 | |||||||||||||
29977 | 29977 | Frank Morse M001009 | rep | MA | 1963-01-09 | 1965-01-03 | Republican | 5 | |||||||||||||
29982 | 29982 | Rogers Morton M001021 | rep | MD | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
30000 | 30000 | Alvin O’Konski O000058 | rep | WI | 1963-01-09 | 1965-01-03 | Republican | 10 | |||||||||||||
30015 | 30015 | Thomas Pelly P000196 | rep | WA | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
30022 | 30022 | Alexander Pirnie P000366 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 32 | |||||||||||||
30032 | 30032 | Richard Poff P000401 | rep | VA | 1963-01-09 | 1965-01-03 | Republican | 6 | |||||||||||||
30039 | 30039 | Roman Pucinski P000559 | rep | IL | 1963-01-09 | 1965-01-03 | Democrat | 11 | |||||||||||||
30045 | 30045 | Graham Purcell P000569 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 13 | |||||||||||||
30050 | 30050 | Charlotte Reid R000143 | rep | IL | 1963-01-09 | 1965-01-03 | Republican | 15 | |||||||||||||
30056 | 30056 | William Ryan R000562 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 20 | |||||||||||||
30067 | 30067 | Frederick Schwengel S000161 | rep | IA | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
30085 | 30085 | H. Smith S000545 | rep | CA | 1963-01-09 | 1965-01-03 | Republican | 20 | |||||||||||||
30096 | 30096 | William Springer S000756 | rep | IL | 1963-01-09 | 1965-01-03 | Republican | 22 | |||||||||||||
30105 | 30105 | Robert Taft T000010 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 0 | |||||||||||||
30123 | 30123 | John Watts W000212 | rep | KY | 1963-01-09 | 1965-01-03 | Democrat | 6 | |||||||||||||
30130 | 30130 | John Whalley W000320 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 12 | |||||||||||||
30152 | 30152 | Leslie Arends A000216 | rep | IL | 1963-01-09 | 1965-01-03 | Republican | 17 | |||||||||||||
30173 | 30173 | John Blatnik B000550 | rep | MN | 1963-01-09 | 1965-01-03 | Democrat | 8 | |||||||||||||
30189 | 30189 | William Bray B000778 | rep | IN | 1963-01-09 | 1965-01-03 | Republican | 7 | |||||||||||||
30197 | 30197 | Donald Brotzman B000893 | rep | CO | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
30207 | 30207 | Joel Broyhill B000967 | rep | VA | 1963-01-09 | 1965-01-03 | Republican | 10 | |||||||||||||
30217 | 30217 | Hugh Carey C000143 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 15 | |||||||||||||
30235 | 30235 | Charles Chamberlain C000275 | rep | MI | 1963-01-09 | 1965-01-03 | Republican | 6 | |||||||||||||
30245 | 30245 | Frank Clark C000431 | rep | PA | 1963-01-09 | 1965-01-03 | Democrat | 25 | |||||||||||||
30255 | 30255 | Harold Collier C000629 | rep | IL | 1963-01-09 | 1965-01-03 | Republican | 10 | |||||||||||||
30287 | 30287 | John Davis D000122 | rep | GA | 1963-01-09 | 1965-01-03 | Democrat | 7 | |||||||||||||
30310 | 30310 | Harold Donohue D000419 | rep | MA | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
30323 | 30323 | William Dorn D000434 | rep | SC | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
30331 | 30331 | Thaddeus Dulski D000523 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 41 | |||||||||||||
30354 | 30354 | Ovie Fisher F000152 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 21 | |||||||||||||
30365 | 30365 | Peter Frelinghuysen F000371 | rep | NJ | 1963-01-09 | 1965-01-03 | Republican | 5 | |||||||||||||
30372 | 30372 | Thomas Gettys G000144 | rep | SC | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
30379 | 30379 | George Goodling G000290 | rep | PA | 1963-01-09 | 1965-01-03 | Republican | 19 | |||||||||||||
30390 | 30390 | Edith Green G000407 | rep | OR | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
30399 | 30399 | Robert Griffin G000465 | rep | MI | 1963-01-09 | 1965-01-03 | Republican | 9 | |||||||||||||
30408 | 30408 | Martha Griffiths G000471 | rep | MI | 1963-01-09 | 1965-01-03 | Democrat | 17 | |||||||||||||
30421 | 30421 | Harold Gross G000495 | rep | IA | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
30427 | 30427 | James Grover G000504 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
30438 | 30438 | Charles Gubser G000512 | rep | CA | 1963-01-09 | 1965-01-03 | Republican | 10 | |||||||||||||
30445 | 30445 | Richard Hanna H000164 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 34 | |||||||||||||
30456 | 30456 | Julia Hansen H000174 | rep | WA | 1963-01-09 | 1965-01-03 | Democrat | 3 |
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);