legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
479 rows where "end" is on date 1967-01-03
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28888 | 28888 | Fred Harris H000237 | sen | OK | 1964-01-01 | 1967-01-03 | 2 | Democrat | |||||||||||||
28903 | 28903 | Albert Herlong H000530 | rep | FL | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
28911 | 28911 | Elmer Holland H000717 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 20 | |||||||||||||
28914 | 28914 | Donald Irwin I000039 | rep | CT | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
28917 | 28917 | Benjamin Jordan J000267 | sen | NC | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
28919 | 28919 | Leonard Jordan J000269 | sen | ID | 1962-08-06 | 1967-01-03 | 2 | Republican | appointment | ||||||||||||
28930 | 28930 | Frank Karsten K000013 | rep | MO | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
28940 | 28940 | Edna Kelly K000070 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 12 | |||||||||||||
28954 | 28954 | Cecil King K000196 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 17 | |||||||||||||
28958 | 28958 | Horace Kornegay K000318 | rep | NC | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
28960 | 28960 | Theodore Kupferman K000343 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 17 | |||||||||||||
28962 | 28962 | Hervey Machen M000011 | rep | MD | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
28964 | 28964 | Jack Miller M000730 | sen | IA | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
28970 | 28970 | Arch Moore M000892 | rep | WV | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
28975 | 28975 | Thomas Morris M000990 | rep | NM | 1965-01-04 | 1967-01-03 | Democrat | 0 | |||||||||||||
28986 | 28986 | Abraham Multer M001074 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 13 | |||||||||||||
28996 | 28996 | Karl Mundt M001078 | sen | SD | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
29005 | 29005 | Barratt O’Hara O000053 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
29007 | 29007 | Santiago Polanco-Abreu P000405 | rep | PR | 1965-01-04 | 1967-01-03 | Popular Democrat | 0 | |||||||||||||
29010 | 29010 | Joe Pool P000426 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 0 | |||||||||||||
29012 | 29012 | Joseph Resnick R000164 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 28 | |||||||||||||
29022 | 29022 | George Rhodes R000187 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
29029 | 29029 | Richard Russell R000536 | sen | GA | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
29037 | 29037 | Armistead Selden S000232 | rep | AL | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
29047 | 29047 | Margaret Smith S000590 | sen | ME | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
29049 | 29049 | Herbert Tenzer T000128 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
29057 | 29057 | William Tuck T000395 | rep | VA | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
29059 | 29059 | E. Walker W000049 | rep | NM | 1965-01-04 | 1967-01-03 | Democrat | 0 | |||||||||||||
29065 | 29065 | Basil Whitener W000410 | rep | NC | 1965-01-04 | 1967-01-03 | Democrat | 10 | |||||||||||||
29076 | 29076 | John Williams W000517 | rep | MS | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
29086 | 29086 | Edwin Willis W000559 | rep | LA | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
29094 | 29094 | Jesse Younger Y000060 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 11 | |||||||||||||
29101 | 29101 | Charles Goodell G000282 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 38 | |||||||||||||
29110 | 29110 | Edwin Adair A000024 | rep | IN | 1965-01-04 | 1967-01-03 | Republican | 4 | |||||||||||||
29126 | 29126 | William Ayres A000229 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 14 | |||||||||||||
29137 | 29137 | William Bates B000239 | rep | MA | 1965-01-04 | 1967-01-03 | Republican | 6 | |||||||||||||
29142 | 29142 | James Battin B000241 | rep | MT | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
29156 | 29156 | Ellis Berry B000416 | rep | SD | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
29164 | 29164 | Laurence Burton B001155 | rep | UT | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
29172 | 29172 | William Cahill C000019 | rep | NJ | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
29178 | 29178 | Jeffery Cohelan C000596 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
29188 | 29188 | William Cramer C000869 | rep | FL | 1965-01-04 | 1967-01-03 | Republican | 12 | |||||||||||||
29195 | 29195 | Glenn Cunningham C000991 | rep | NE | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
29201 | 29201 | Emilio Daddario D000001 | rep | CT | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
29215 | 29215 | William Dawson D000158 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
29232 | 29232 | Robert Everett E000266 | rep | TN | 1965-01-04 | 1967-01-03 | Democrat | 8 | |||||||||||||
29245 | 29245 | George Fallon F000012 | rep | MD | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
29252 | 29252 | Leonard Farbstein F000015 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 19 | |||||||||||||
29266 | 29266 | Michael Feighan F000060 | rep | OH | 1965-01-04 | 1967-01-03 | Democrat | 20 | |||||||||||||
29277 | 29277 | Samuel Friedel F000384 | rep | MD | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
29289 | 29289 | Jacob Gilbert G000175 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 22 | |||||||||||||
29293 | 29293 | Edward Gurney G000531 | rep | FL | 1965-01-04 | 1967-01-03 | Republican | 11 | |||||||||||||
29299 | 29299 | Charles Joelson J000108 | rep | NJ | 1965-01-04 | 1967-01-03 | Democrat | 8 | |||||||||||||
29316 | 29316 | Michael Kirwan K000244 | rep | OH | 1965-01-04 | 1967-01-03 | Democrat | 19 | |||||||||||||
29327 | 29327 | Melvin Laird L000024 | rep | WI | 1965-01-04 | 1967-01-03 | Republican | 7 | |||||||||||||
29333 | 29333 | Odin Langen L000069 | rep | MN | 1965-01-04 | 1967-01-03 | Republican | 7 | |||||||||||||
29342 | 29342 | Glenard Lipscomb L000344 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 24 | |||||||||||||
29348 | 29348 | Clark MacGregor M000010 | rep | MN | 1965-01-04 | 1967-01-03 | Republican | 3 | |||||||||||||
29352 | 29352 | John Marsh M000148 | rep | VA | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
29358 | 29358 | Catherine May M000273 | rep | WA | 1965-01-04 | 1967-01-03 | Republican | 4 | |||||||||||||
29361 | 29361 | Richard McCarthy M000318 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 39 | |||||||||||||
29383 | 29383 | John McCormack M000364 | rep | MA | 1965-01-04 | 1967-01-03 | Democrat | 9 | |||||||||||||
29389 | 29389 | Chester Mize M000832 | rep | KS | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
29395 | 29395 | William Murphy M001104 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
29398 | 29398 | Maston O’Neal O000090 | rep | GA | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
29403 | 29403 | Arnold Olsen O000083 | rep | MT | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
29417 | 29417 | Philip Philbin P000303 | rep | MA | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
29432 | 29432 | Adam Powell P000477 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 18 | |||||||||||||
29437 | 29437 | Benjamin Reifel R000152 | rep | SD | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
29440 | 29440 | Edwin Reinecke R000159 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 27 | |||||||||||||
29455 | 29455 | Lucius Rivers R000280 | rep | SC | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
29465 | 29465 | Byron Rogers R000389 | rep | CO | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
29468 | 29468 | Daniel Ronan R000420 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
29473 | 29473 | Richard Roudebush R000464 | rep | IN | 1965-01-04 | 1967-01-03 | Republican | 6 | |||||||||||||
29477 | 29477 | Donald Rumsfeld R000508 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 13 | |||||||||||||
29487 | 29487 | William St. Onge S000769 | rep | CT | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
29496 | 29496 | James Utt U000034 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 35 | |||||||||||||
29499 | 29499 | George Watkins W000192 | rep | PA | 1965-01-04 | 1967-01-03 | Republican | 7 | |||||||||||||
29503 | 29503 | Albert Watson W000197 | rep | SC | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
29520 | 29520 | Watkins Abbitt A000002 | rep | VA | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
29535 | 29535 | Thomas Abernethy A000016 | rep | MS | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
29539 | 29539 | William Anderson A000203 | rep | TN | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
29555 | 29555 | George Andrews A000206 | rep | AL | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
29567 | 29567 | Wayne Aspinall A000225 | rep | CO | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
29577 | 29577 | Walter Baring B000141 | rep | NV | 1965-01-04 | 1967-01-03 | Democrat | 0 | |||||||||||||
29591 | 29591 | Page Belcher B000323 | rep | OK | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
29602 | 29602 | Jackson Betts B000426 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 8 | |||||||||||||
29619 | 29619 | Thomas Boggs B000594 | rep | LA | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
29630 | 29630 | Frank Bow B000676 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 16 | |||||||||||||
29635 | 29635 | William Brock B000851 | rep | TN | 1965-01-04 | 1967-01-03 | Republican | 3 | |||||||||||||
29646 | 29646 | James Byrne B001212 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
29660 | 29660 | John Byrnes B001216 | rep | WI | 1965-01-04 | 1967-01-03 | Republican | 8 | |||||||||||||
29664 | 29664 | Earle Cabell C000002 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
29692 | 29692 | Emanuel Celler C000264 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 10 | |||||||||||||
29712 | 29712 | William Colmer C000645 | rep | MS | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
29728 | 29728 | Robert Corbett C000772 | rep | PA | 1965-01-04 | 1967-01-03 | Republican | 18 | |||||||||||||
29735 | 29735 | John Dow D000462 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 27 | |||||||||||||
29745 | 29745 | John Dowdy D000467 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
29753 | 29753 | Florence Dwyer D000587 | rep | NJ | 1965-01-04 | 1967-01-03 | Republican | 6 | |||||||||||||
29763 | 29763 | Edmond Edmondson E000054 | rep | OK | 1965-01-04 | 1967-01-03 | Democrat | 2 |
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);