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 sorted by party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29086 | 29086 | Edwin Willis W000559 | rep | LA | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
29178 | 29178 | Jeffery Cohelan C000596 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
29352 | 29352 | John Marsh M000148 | rep | VA | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
29487 | 29487 | William St. Onge S000769 | rep | CT | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
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 | |||||||||||||
29619 | 29619 | Thomas Boggs B000594 | rep | LA | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
29646 | 29646 | James Byrne B001212 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
29763 | 29763 | Edmond Edmondson E000054 | rep | OK | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
29767 | 29767 | Edwin Edwards E000067 | rep | LA | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
29796 | 29796 | Cornelius Gallagher G000016 | rep | NJ | 1965-01-04 | 1967-01-03 | Democrat | 13 | |||||||||||||
29810 | 29810 | Edward Garmatz G000071 | rep | MD | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
29819 | 29819 | George Hagan H000010 | rep | GA | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
29853 | 29853 | William Hull H000947 | rep | MO | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
29867 | 29867 | James Kee K000038 | rep | WV | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
29889 | 29889 | Alton Lennon L000240 | rep | NC | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
29898 | 29898 | Speedy Long L000429 | rep | LA | 1965-01-04 | 1967-01-03 | Democrat | 8 | |||||||||||||
29944 | 29944 | John McMillan M000568 | rep | SC | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
29958 | 29958 | George Miller M000727 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 8 | |||||||||||||
29965 | 29965 | John Monagan M000847 | rep | CT | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
30040 | 30040 | Roman Pucinski P000559 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 11 | |||||||||||||
30046 | 30046 | Graham Purcell P000569 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 13 | |||||||||||||
30057 | 30057 | William Ryan R000562 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 20 | |||||||||||||
30113 | 30113 | John Tunney T000410 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 38 | |||||||||||||
30124 | 30124 | John Watts W000212 | rep | KY | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
30174 | 30174 | John Blatnik B000550 | rep | MN | 1965-01-04 | 1967-01-03 | Democrat | 8 | |||||||||||||
30218 | 30218 | Hugh Carey C000143 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 15 | |||||||||||||
30246 | 30246 | Frank Clark C000431 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 25 | |||||||||||||
30288 | 30288 | John Davis D000122 | rep | GA | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
30311 | 30311 | Harold Donohue D000419 | rep | MA | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
30324 | 30324 | William Dorn D000434 | rep | SC | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
30332 | 30332 | Thaddeus Dulski D000523 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 41 | |||||||||||||
30341 | 30341 | James Eastland E000018 | sen | MS | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
30355 | 30355 | Ovie Fisher F000152 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 21 | |||||||||||||
30373 | 30373 | Thomas Gettys G000144 | rep | SC | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
30391 | 30391 | Edith Green G000407 | rep | OR | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
30409 | 30409 | Martha Griffiths G000471 | rep | MI | 1965-01-04 | 1967-01-03 | Democrat | 17 | |||||||||||||
30446 | 30446 | Richard Hanna H000164 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 34 | |||||||||||||
30457 | 30457 | Julia Hansen H000174 | rep | WA | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
30473 | 30473 | William Hathaway H000346 | rep | ME | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
30492 | 30492 | Chester Holifield H000713 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 19 | |||||||||||||
30568 | 30568 | John McClellan M000332 | sen | AR | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
30571 | 30571 | Thomas McIntyre M000486 | sen | NH | 1962-01-01 | 1967-01-03 | 2 | Democrat | |||||||||||||
30579 | 30579 | Lee Metcalf M000671 | sen | MT | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
30597 | 30597 | Walter Mondale M000851 | sen | MN | 1964-12-30 | 1967-01-03 | 2 | Democrat | appointment | ||||||||||||
30652 | 30652 | John Rooney R000424 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 14 | |||||||||||||
30702 | 30702 | John Sparkman S000701 | sen | AL | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
30711 | 30711 | Frank Stubblefield S001037 | rep | KY | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
30740 | 30740 | Jerome Waldie W000035 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 14 | |||||||||||||
30812 | 30812 | Carl Albert A000073 | rep | OK | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
30829 | 30829 | William Barrett B000178 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
30858 | 30858 | Robert Casey C000228 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 22 | |||||||||||||
30886 | 30886 | John Culver C000979 | rep | IA | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
30895 | 30895 | Dominick Daniels D000041 | rep | NJ | 1965-01-04 | 1967-01-03 | Democrat | 14 | |||||||||||||
30904 | 30904 | Thomas Downing D000474 | rep | VA | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
30930 | 30930 | Joseph Evins E000273 | rep | TN | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
30937 | 30937 | Richard Fulton F000424 | rep | TN | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
30946 | 30946 | William Green G000420 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
30963 | 30963 | James Haley H000041 | rep | FL | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
30983 | 30983 | Wayne Hays H000408 | rep | OH | 1965-01-04 | 1967-01-03 | Democrat | 18 | |||||||||||||
30992 | 30992 | Kenneth Hechler H000438 | rep | WV | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
30998 | 30998 | Henry Helstoski H000465 | rep | NJ | 1965-01-04 | 1967-01-03 | Democrat | 9 | |||||||||||||
31006 | 31006 | David Henderson H000479 | rep | NC | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
31012 | 31012 | Floyd Hicks H000563 | rep | WA | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
31022 | 31022 | William Hungate H000965 | rep | MO | 1965-01-04 | 1967-01-03 | Democrat | 9 | |||||||||||||
31047 | 31047 | Felix Hébert H000437 | rep | LA | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
31060 | 31060 | John Jarman J000057 | rep | OK | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
31090 | 31090 | Robert Jones J000248 | rep | AL | 1965-01-04 | 1967-01-03 | Democrat | 8 | |||||||||||||
31099 | 31099 | Joseph Karth K000014 | rep | MN | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
31112 | 31112 | John Kluczynski K000273 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 5 |
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);