legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
474 rows where "end" is on date 1969-01-03 sorted by how
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27658 | 27658 | Daniel Brewster B000813 | sen | MD | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
27709 | 27709 | Frank Carlson C000154 | sen | KS | 1963-01-09 | 1969-01-03 | 3 | Republican | |||||||||||||
27722 | 27722 | Joseph Clark C000444 | sen | PA | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
27752 | 27752 | Everett Dirksen D000360 | sen | IL | 1963-01-09 | 1969-01-03 | 3 | Republican | |||||||||||||
27840 | 27840 | Ernest Gruening G000508 | sen | AK | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
27857 | 27857 | Carl Hayden H000385 | sen | AZ | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
27870 | 27870 | Bourke Hickenlooper H000559 | sen | IA | 1963-01-09 | 1969-01-03 | 3 | Republican | |||||||||||||
27976 | 27976 | Thomas Kuchel K000335 | sen | CA | 1963-01-09 | 1969-01-03 | 3 | Republican | |||||||||||||
27983 | 27983 | Frank Lausche L000122 | sen | OH | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
28031 | 28031 | Almer Monroney M000859 | sen | OK | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
28035 | 28035 | Wayne Morse M001014 | sen | OR | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
28167 | 28167 | George Smathers S000505 | sen | FL | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
28492 | 28492 | Robert Kennedy K000114 | sen | NY | 1965-01-04 | 1969-01-03 | 1 | Democrat | |||||||||||||
28771 | 28771 | Robert Ashmore A000223 | rep | SC | 1967-01-10 | 1969-01-03 | Democrat | 4 | |||||||||||||
28801 | 28801 | Frances Bolton B000607 | rep | OH | 1967-01-10 | 1969-01-03 | Republican | 22 | |||||||||||||
28815 | 28815 | Thomas Curtis C001014 | rep | MO | 1967-01-10 | 1969-01-03 | Republican | 2 | |||||||||||||
28829 | 28829 | Paul Fino F000137 | rep | NY | 1967-01-10 | 1969-01-03 | Republican | 24 | |||||||||||||
28843 | 28843 | John Fogarty F000233 | rep | RI | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
28844 | 28844 | James Gardner G000055 | rep | NC | 1967-01-10 | 1969-01-03 | Republican | 4 | |||||||||||||
28859 | 28859 | Ezekiel Gathings G000098 | rep | AR | 1967-01-10 | 1969-01-03 | Democrat | 1 | |||||||||||||
28876 | 28876 | Charles Halleck H000081 | rep | IN | 1967-01-10 | 1969-01-03 | Republican | 2 | |||||||||||||
28887 | 28887 | Porter Hardy H000197 | rep | VA | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
28894 | 28894 | William Harrison H000278 | rep | WY | 1967-01-10 | 1969-01-03 | Republican | 0 | |||||||||||||
28904 | 28904 | Albert Herlong H000530 | rep | FL | 1967-01-10 | 1969-01-03 | Democrat | 4 | |||||||||||||
28912 | 28912 | Elmer Holland H000717 | rep | PA | 1967-01-10 | 1969-01-03 | Democrat | 20 | |||||||||||||
28915 | 28915 | Donald Irwin I000039 | rep | CT | 1967-01-10 | 1969-01-03 | Democrat | 4 | |||||||||||||
28931 | 28931 | Frank Karsten K000013 | rep | MO | 1967-01-10 | 1969-01-03 | Democrat | 1 | |||||||||||||
28941 | 28941 | Edna Kelly K000070 | rep | NY | 1967-01-10 | 1969-01-03 | Democrat | 12 | |||||||||||||
28955 | 28955 | Cecil King K000196 | rep | CA | 1967-01-10 | 1969-01-03 | Democrat | 17 | |||||||||||||
28959 | 28959 | Horace Kornegay K000318 | rep | NC | 1967-01-10 | 1969-01-03 | Democrat | 6 | |||||||||||||
28961 | 28961 | Theodore Kupferman K000343 | rep | NY | 1967-01-10 | 1969-01-03 | Republican | 17 | |||||||||||||
28963 | 28963 | Hervey Machen M000011 | rep | MD | 1967-01-10 | 1969-01-03 | Democrat | 5 | |||||||||||||
28971 | 28971 | Arch Moore M000892 | rep | WV | 1967-01-10 | 1969-01-03 | Republican | 1 | |||||||||||||
28976 | 28976 | Thomas Morris M000990 | rep | NM | 1967-01-10 | 1969-01-03 | Democrat | 0 | |||||||||||||
28987 | 28987 | Abraham Multer M001074 | rep | NY | 1967-01-10 | 1969-01-03 | Democrat | 13 | |||||||||||||
29006 | 29006 | Barratt O’Hara O000053 | rep | IL | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
29008 | 29008 | Santiago Polanco-Abreu P000405 | rep | PR | 1967-01-10 | 1969-01-03 | Popular Democrat | 0 | |||||||||||||
29011 | 29011 | Joe Pool P000426 | rep | TX | 1967-01-10 | 1969-01-03 | Democrat | 3 | |||||||||||||
29013 | 29013 | Joseph Resnick R000164 | rep | NY | 1967-01-10 | 1969-01-03 | Democrat | 28 | |||||||||||||
29023 | 29023 | George Rhodes R000187 | rep | PA | 1967-01-10 | 1969-01-03 | Democrat | 6 | |||||||||||||
29038 | 29038 | Armistead Selden S000232 | rep | AL | 1967-01-10 | 1969-01-03 | Democrat | 5 | |||||||||||||
29039 | 29039 | James Smith S000560 | rep | OK | 1967-01-10 | 1969-01-03 | Republican | 6 | |||||||||||||
29050 | 29050 | Herbert Tenzer T000128 | rep | NY | 1967-01-10 | 1969-01-03 | Democrat | 5 | |||||||||||||
29058 | 29058 | William Tuck T000395 | rep | VA | 1967-01-10 | 1969-01-03 | Democrat | 5 | |||||||||||||
29060 | 29060 | E. Walker W000049 | rep | NM | 1967-01-10 | 1969-01-03 | Democrat | 0 | |||||||||||||
29066 | 29066 | Basil Whitener W000410 | rep | NC | 1967-01-10 | 1969-01-03 | Democrat | 10 | |||||||||||||
29077 | 29077 | John Williams W000517 | rep | MS | 1967-01-10 | 1969-01-03 | Democrat | 3 | |||||||||||||
29087 | 29087 | Edwin Willis W000559 | rep | LA | 1967-01-10 | 1969-01-03 | Democrat | 3 | |||||||||||||
29095 | 29095 | Jesse Younger Y000060 | rep | CA | 1967-01-10 | 1969-01-03 | Republican | 11 | |||||||||||||
29096 | 29096 | Marlow Cook C000721 | sen | KY | 1968-12-17 | 1969-01-03 | 3 | Republican | |||||||||||||
29111 | 29111 | Edwin Adair A000024 | rep | IN | 1967-01-10 | 1969-01-03 | Republican | 4 | |||||||||||||
29117 | 29117 | George Aiken A000062 | sen | VT | 1963-01-09 | 1969-01-03 | 3 | Republican | |||||||||||||
29127 | 29127 | William Ayres A000229 | rep | OH | 1967-01-10 | 1969-01-03 | Republican | 14 | |||||||||||||
29138 | 29138 | William Bates B000239 | rep | MA | 1967-01-10 | 1969-01-03 | Republican | 6 | |||||||||||||
29143 | 29143 | James Battin B000241 | rep | MT | 1967-01-10 | 1969-01-03 | Republican | 2 | |||||||||||||
29147 | 29147 | Wallace Bennett B000384 | sen | UT | 1963-01-09 | 1969-01-03 | 3 | Republican | |||||||||||||
29157 | 29157 | Ellis Berry B000416 | rep | SD | 1967-01-10 | 1969-01-03 | Republican | 2 | |||||||||||||
29161 | 29161 | Alan Bible B000436 | sen | NV | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
29165 | 29165 | Laurence Burton B001155 | rep | UT | 1967-01-10 | 1969-01-03 | Republican | 1 | |||||||||||||
29167 | 29167 | Daniel Button B001201 | rep | NY | 1967-01-10 | 1969-01-03 | Republican | 29 | |||||||||||||
29173 | 29173 | William Cahill C000019 | rep | NJ | 1967-01-10 | 1969-01-03 | Republican | 6 | |||||||||||||
29179 | 29179 | Jeffery Cohelan C000596 | rep | CA | 1967-01-10 | 1969-01-03 | Democrat | 7 | |||||||||||||
29181 | 29181 | William Cowger C000823 | rep | KY | 1967-01-10 | 1969-01-03 | Republican | 3 | |||||||||||||
29189 | 29189 | William Cramer C000869 | rep | FL | 1967-01-10 | 1969-01-03 | Republican | 8 | |||||||||||||
29196 | 29196 | Glenn Cunningham C000991 | rep | NE | 1967-01-10 | 1969-01-03 | Republican | 2 | |||||||||||||
29202 | 29202 | Emilio Daddario D000001 | rep | CT | 1967-01-10 | 1969-01-03 | Democrat | 1 | |||||||||||||
29216 | 29216 | William Dawson D000158 | rep | IL | 1967-01-10 | 1969-01-03 | Democrat | 1 | |||||||||||||
29218 | 29218 | Robert Denney D000239 | rep | NE | 1967-01-10 | 1969-01-03 | Republican | 1 | |||||||||||||
29221 | 29221 | Peter Dominick D000409 | sen | CO | 1963-01-09 | 1969-01-03 | 3 | Republican | |||||||||||||
29226 | 29226 | Samuel Ervin E000211 | sen | NC | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
29233 | 29233 | Robert Everett E000266 | rep | TN | 1967-01-10 | 1969-01-03 | Democrat | 8 | |||||||||||||
29246 | 29246 | George Fallon F000012 | rep | MD | 1967-01-10 | 1969-01-03 | Democrat | 4 | |||||||||||||
29253 | 29253 | Leonard Farbstein F000015 | rep | NY | 1967-01-10 | 1969-01-03 | Democrat | 19 | |||||||||||||
29267 | 29267 | Michael Feighan F000060 | rep | OH | 1967-01-10 | 1969-01-03 | Democrat | 20 | |||||||||||||
29278 | 29278 | Samuel Friedel F000384 | rep | MD | 1967-01-10 | 1969-01-03 | Democrat | 7 | |||||||||||||
29284 | 29284 | James Fulbright F000401 | sen | AR | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
29290 | 29290 | Jacob Gilbert G000175 | rep | NY | 1967-01-10 | 1969-01-03 | Democrat | 22 | |||||||||||||
29294 | 29294 | Edward Gurney G000531 | rep | FL | 1967-01-10 | 1969-01-03 | Republican | 5 | |||||||||||||
29300 | 29300 | Charles Joelson J000108 | rep | NJ | 1967-01-10 | 1969-01-03 | Democrat | 8 | |||||||||||||
29317 | 29317 | Michael Kirwan K000244 | rep | OH | 1967-01-10 | 1969-01-03 | Democrat | 19 | |||||||||||||
29319 | 29319 | Thomas Kleppe K000264 | rep | ND | 1967-01-10 | 1969-01-03 | Republican | 2 | |||||||||||||
29328 | 29328 | Melvin Laird L000024 | rep | WI | 1967-01-10 | 1969-01-03 | Republican | 7 | |||||||||||||
29334 | 29334 | Odin Langen L000069 | rep | MN | 1967-01-10 | 1969-01-03 | Republican | 7 | |||||||||||||
29343 | 29343 | Glenard Lipscomb L000344 | rep | CA | 1967-01-10 | 1969-01-03 | Republican | 24 | |||||||||||||
29349 | 29349 | Clark MacGregor M000010 | rep | MN | 1967-01-10 | 1969-01-03 | Republican | 3 | |||||||||||||
29353 | 29353 | John Marsh M000148 | rep | VA | 1967-01-10 | 1969-01-03 | Democrat | 7 | |||||||||||||
29359 | 29359 | Catherine May M000273 | rep | WA | 1967-01-10 | 1969-01-03 | Republican | 4 | |||||||||||||
29362 | 29362 | Richard McCarthy M000318 | rep | NY | 1967-01-10 | 1969-01-03 | Democrat | 39 | |||||||||||||
29384 | 29384 | John McCormack M000364 | rep | MA | 1967-01-10 | 1969-01-03 | Democrat | 9 | |||||||||||||
29387 | 29387 | Thomas Meskill M000667 | rep | CT | 1967-01-10 | 1969-01-03 | Republican | 6 | |||||||||||||
29390 | 29390 | Chester Mize M000832 | rep | KS | 1967-01-10 | 1969-01-03 | Republican | 2 | |||||||||||||
29396 | 29396 | William Murphy M001104 | rep | IL | 1967-01-10 | 1969-01-03 | Democrat | 3 | |||||||||||||
29399 | 29399 | Maston O’Neal O000090 | rep | GA | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
29404 | 29404 | Arnold Olsen O000083 | rep | MT | 1967-01-10 | 1969-01-03 | Democrat | 1 | |||||||||||||
29418 | 29418 | Philip Philbin P000303 | rep | MA | 1967-01-10 | 1969-01-03 | Democrat | 3 | |||||||||||||
29420 | 29420 | Howard Pollock P000415 | rep | AK | 1967-01-10 | 1969-01-03 | Republican | 0 | |||||||||||||
29433 | 29433 | Adam Powell P000477 | rep | NY | 1967-01-10 | 1969-01-03 | Democrat | 18 | |||||||||||||
29438 | 29438 | Benjamin Reifel R000152 | rep | SD | 1967-01-10 | 1969-01-03 | Republican | 1 | |||||||||||||
29441 | 29441 | Edwin Reinecke R000159 | rep | CA | 1967-01-10 | 1969-01-03 | Republican | 27 | |||||||||||||
29456 | 29456 | Lucius Rivers R000280 | rep | SC | 1967-01-10 | 1969-01-03 | Democrat | 1 |
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);