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 party
This data as json, copyable, CSV (advanced)
Suggested facets: state, class, district, 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 | |||||||||||||
27722 | 27722 | Joseph Clark C000444 | sen | PA | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
28843 | 28843 | John Fogarty F000233 | rep | RI | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
28859 | 28859 | Ezekiel Gathings G000098 | rep | AR | 1967-01-10 | 1969-01-03 | Democrat | 1 | |||||||||||||
28887 | 28887 | Porter Hardy H000197 | rep | VA | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
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 | |||||||||||||
28963 | 28963 | Hervey Machen M000011 | rep | MD | 1967-01-10 | 1969-01-03 | Democrat | 5 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
29161 | 29161 | Alan Bible B000436 | sen | NV | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
29179 | 29179 | Jeffery Cohelan C000596 | rep | CA | 1967-01-10 | 1969-01-03 | Democrat | 7 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
29353 | 29353 | John Marsh M000148 | rep | VA | 1967-01-10 | 1969-01-03 | Democrat | 7 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
29433 | 29433 | Adam Powell P000477 | rep | NY | 1967-01-10 | 1969-01-03 | Democrat | 18 | |||||||||||||
29456 | 29456 | Lucius Rivers R000280 | rep | SC | 1967-01-10 | 1969-01-03 | Democrat | 1 | |||||||||||||
29466 | 29466 | Byron Rogers R000389 | rep | CO | 1967-01-10 | 1969-01-03 | Democrat | 1 | |||||||||||||
29469 | 29469 | Daniel Ronan R000420 | rep | IL | 1967-01-10 | 1969-01-03 | Democrat | 6 | |||||||||||||
29488 | 29488 | William St. Onge S000769 | rep | CT | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
29521 | 29521 | Watkins Abbitt A000002 | rep | VA | 1967-01-10 | 1969-01-03 | Democrat | 4 | |||||||||||||
29536 | 29536 | Thomas Abernethy A000016 | rep | MS | 1967-01-10 | 1969-01-03 | Democrat | 1 | |||||||||||||
29540 | 29540 | William Anderson A000203 | rep | TN | 1967-01-10 | 1969-01-03 | Democrat | 6 | |||||||||||||
29556 | 29556 | George Andrews A000206 | rep | AL | 1967-01-10 | 1969-01-03 | Democrat | 3 | |||||||||||||
29568 | 29568 | Wayne Aspinall A000225 | rep | CO | 1967-01-10 | 1969-01-03 | Democrat | 4 | |||||||||||||
29578 | 29578 | Walter Baring B000141 | rep | NV | 1967-01-10 | 1969-01-03 | Democrat | 0 | |||||||||||||
29606 | 29606 | Leonard Blanton B000548 | rep | TN | 1967-01-10 | 1969-01-03 | Democrat | 7 | |||||||||||||
29620 | 29620 | Thomas Boggs B000594 | rep | LA | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
29647 | 29647 | James Byrne B001212 | rep | PA | 1967-01-10 | 1969-01-03 | Democrat | 3 | |||||||||||||
29665 | 29665 | Earle Cabell C000002 | rep | TX | 1967-01-10 | 1969-01-03 | Democrat | 5 | |||||||||||||
29693 | 29693 | Emanuel Celler C000264 | rep | NY | 1967-01-10 | 1969-01-03 | Democrat | 10 | |||||||||||||
29713 | 29713 | William Colmer C000645 | rep | MS | 1967-01-10 | 1969-01-03 | Democrat | 5 | |||||||||||||
29736 | 29736 | John Dow D000462 | rep | NY | 1967-01-10 | 1969-01-03 | Democrat | 27 | |||||||||||||
29746 | 29746 | John Dowdy D000467 | rep | TX | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
29764 | 29764 | Edmond Edmondson E000054 | rep | OK | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
29768 | 29768 | Edwin Edwards E000067 | rep | LA | 1967-01-10 | 1969-01-03 | Democrat | 7 | |||||||||||||
29790 | 29790 | Nick Galifianakis G000015 | rep | NC | 1967-01-10 | 1969-01-03 | Democrat | 5 | |||||||||||||
29797 | 29797 | Cornelius Gallagher G000016 | rep | NJ | 1967-01-10 | 1969-01-03 | Democrat | 13 | |||||||||||||
29811 | 29811 | Edward Garmatz G000071 | rep | MD | 1967-01-10 | 1969-01-03 | Democrat | 3 | |||||||||||||
29814 | 29814 | Charles Griffin G000458 | rep | MS | 1967-01-10 | 1969-01-03 | Democrat | 3 | |||||||||||||
29820 | 29820 | George Hagan H000010 | rep | GA | 1967-01-10 | 1969-01-03 | Democrat | 1 | |||||||||||||
29854 | 29854 | William Hull H000947 | rep | MO | 1967-01-10 | 1969-01-03 | Democrat | 6 | |||||||||||||
29868 | 29868 | James Kee K000038 | rep | WV | 1967-01-10 | 1969-01-03 | Democrat | 5 | |||||||||||||
29890 | 29890 | Alton Lennon L000240 | rep | NC | 1967-01-10 | 1969-01-03 | Democrat | 7 | |||||||||||||
29899 | 29899 | Speedy Long L000429 | rep | LA | 1967-01-10 | 1969-01-03 | Democrat | 8 | |||||||||||||
29945 | 29945 | John McMillan M000568 | rep | SC | 1967-01-10 | 1969-01-03 | Democrat | 6 | |||||||||||||
29959 | 29959 | George Miller M000727 | rep | CA | 1967-01-10 | 1969-01-03 | Democrat | 8 | |||||||||||||
29966 | 29966 | John Monagan M000847 | rep | CT | 1967-01-10 | 1969-01-03 | Democrat | 5 | |||||||||||||
30041 | 30041 | Roman Pucinski P000559 | rep | IL | 1967-01-10 | 1969-01-03 | Democrat | 11 | |||||||||||||
30047 | 30047 | Graham Purcell P000569 | rep | TX | 1967-01-10 | 1969-01-03 | Democrat | 13 | |||||||||||||
30058 | 30058 | William Ryan R000562 | rep | NY | 1967-01-10 | 1969-01-03 | Democrat | 20 | |||||||||||||
30114 | 30114 | John Tunney T000410 | rep | CA | 1967-01-10 | 1969-01-03 | Democrat | 38 | |||||||||||||
30125 | 30125 | John Watts W000212 | rep | KY | 1967-01-10 | 1969-01-03 | Democrat | 6 | |||||||||||||
30175 | 30175 | John Blatnik B000550 | rep | MN | 1967-01-10 | 1969-01-03 | Democrat | 8 | |||||||||||||
30179 | 30179 | Frank Brasco B000771 | rep | NY | 1967-01-10 | 1969-01-03 | Democrat | 11 | |||||||||||||
30219 | 30219 | Hugh Carey C000143 | rep | NY | 1967-01-10 | 1969-01-03 | Democrat | 15 | |||||||||||||
30247 | 30247 | Frank Clark C000431 | rep | PA | 1967-01-10 | 1969-01-03 | Democrat | 25 | |||||||||||||
30289 | 30289 | John Davis D000122 | rep | GA | 1967-01-10 | 1969-01-03 | Democrat | 7 | |||||||||||||
30312 | 30312 | Harold Donohue D000419 | rep | MA | 1967-01-10 | 1969-01-03 | Democrat | 4 | |||||||||||||
30325 | 30325 | William Dorn D000434 | rep | SC | 1967-01-10 | 1969-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);