legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
483 rows where "end" is on date 1971-01-03 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28417 | 28417 | Thomas Dodd D000390 | sen | CT | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
28434 | 28434 | Albert Gore G000320 | sen | TN | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
28473 | 28473 | Spessard Holland H000720 | sen | FL | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
28563 | 28563 | Eugene McCarthy M000311 | sen | MN | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
28732 | 28732 | Joseph Tydings T000445 | sen | MD | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
28745 | 28745 | Ralph Yarborough Y000006 | sen | TX | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
28751 | 28751 | Stephen Young Y000053 | sen | OH | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
29180 | 29180 | Jeffery Cohelan C000596 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
29203 | 29203 | Emilio Daddario D000001 | rep | CT | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
29217 | 29217 | William Dawson D000158 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
29234 | 29234 | Robert Everett E000266 | rep | TN | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
29247 | 29247 | George Fallon F000012 | rep | MD | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
29254 | 29254 | Leonard Farbstein F000015 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 19 | |||||||||||||
29268 | 29268 | Michael Feighan F000060 | rep | OH | 1969-01-03 | 1971-01-03 | Democrat | 20 | |||||||||||||
29279 | 29279 | Samuel Friedel F000384 | rep | MD | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
29291 | 29291 | Jacob Gilbert G000175 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 22 | |||||||||||||
29301 | 29301 | Charles Joelson J000108 | rep | NJ | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
29318 | 29318 | Michael Kirwan K000244 | rep | OH | 1969-01-03 | 1971-01-03 | Democrat | 19 | |||||||||||||
29345 | 29345 | Allard Lowenstein L000477 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
29354 | 29354 | John Marsh M000148 | rep | VA | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
29363 | 29363 | Richard McCarthy M000318 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 39 | |||||||||||||
29385 | 29385 | John McCormack M000364 | rep | MA | 1969-01-03 | 1971-01-03 | Democrat | 9 | |||||||||||||
29397 | 29397 | William Murphy M001104 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
29400 | 29400 | Maston O’Neal O000090 | rep | GA | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
29405 | 29405 | Arnold Olsen O000083 | rep | MT | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
29419 | 29419 | Philip Philbin P000303 | rep | MA | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
29434 | 29434 | Adam Powell P000477 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 18 | |||||||||||||
29457 | 29457 | Lucius Rivers R000280 | rep | SC | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
29467 | 29467 | Byron Rogers R000389 | rep | CO | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
29489 | 29489 | William St. Onge S000769 | rep | CT | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
29522 | 29522 | Watkins Abbitt A000002 | rep | VA | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
29537 | 29537 | Thomas Abernethy A000016 | rep | MS | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
29541 | 29541 | William Anderson A000203 | rep | TN | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
29557 | 29557 | George Andrews A000206 | rep | AL | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
29569 | 29569 | Wayne Aspinall A000225 | rep | CO | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
29579 | 29579 | Walter Baring B000141 | rep | NV | 1969-01-03 | 1971-01-03 | Democrat | 0 | |||||||||||||
29607 | 29607 | Leonard Blanton B000548 | rep | TN | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
29621 | 29621 | Thomas Boggs B000594 | rep | LA | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
29648 | 29648 | James Byrne B001212 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
29666 | 29666 | Earle Cabell C000002 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
29668 | 29668 | Patrick Caffery C000017 | rep | LA | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
29694 | 29694 | Emanuel Celler C000264 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 10 | |||||||||||||
29714 | 29714 | William Colmer C000645 | rep | MS | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
29747 | 29747 | John Dowdy D000467 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
29765 | 29765 | Edmond Edmondson E000054 | rep | OK | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
29769 | 29769 | Edwin Edwards E000067 | rep | LA | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
29791 | 29791 | Nick Galifianakis G000015 | rep | NC | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
29798 | 29798 | Cornelius Gallagher G000016 | rep | NJ | 1969-01-03 | 1971-01-03 | Democrat | 13 | |||||||||||||
29812 | 29812 | Edward Garmatz G000071 | rep | MD | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
29815 | 29815 | Charles Griffin G000458 | rep | MS | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
29821 | 29821 | George Hagan H000010 | rep | GA | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
29837 | 29837 | Philip Hart H000291 | sen | MI | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
29840 | 29840 | Rupert Hartke H000297 | sen | IN | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
29855 | 29855 | William Hull H000947 | rep | MO | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
29869 | 29869 | James Kee K000038 | rep | WV | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
29891 | 29891 | Alton Lennon L000240 | rep | NC | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
29900 | 29900 | Speedy Long L000429 | rep | LA | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
29909 | 29909 | Michael Mansfield M000113 | sen | MT | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
29928 | 29928 | Gale McGee M000445 | sen | WY | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
29946 | 29946 | John McMillan M000568 | rep | SC | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
29960 | 29960 | George Miller M000727 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
29967 | 29967 | John Monagan M000847 | rep | CT | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
29974 | 29974 | Joseph Montoya M000876 | sen | NM | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
29988 | 29988 | Frank Moss M001033 | sen | UT | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
30008 | 30008 | John Pastore P000100 | sen | RI | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
30042 | 30042 | Roman Pucinski P000559 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 11 | |||||||||||||
30048 | 30048 | Graham Purcell P000569 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 13 | |||||||||||||
30059 | 30059 | William Ryan R000562 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 20 | |||||||||||||
30103 | 30103 | William Symington S001136 | sen | MO | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
30115 | 30115 | John Tunney T000410 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 38 | |||||||||||||
30126 | 30126 | John Watts W000212 | rep | KY | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
30176 | 30176 | John Blatnik B000550 | rep | MN | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
30180 | 30180 | Frank Brasco B000771 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 11 | |||||||||||||
30220 | 30220 | Hugh Carey C000143 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 15 | |||||||||||||
30248 | 30248 | Frank Clark C000431 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 25 | |||||||||||||
30261 | 30261 | George Collins C000637 | rep | IL | 1970-11-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
30290 | 30290 | John Davis D000122 | rep | GA | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
30313 | 30313 | Harold Donohue D000419 | rep | MA | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
30326 | 30326 | William Dorn D000434 | rep | SC | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
30334 | 30334 | Thaddeus Dulski D000523 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 41 | |||||||||||||
30357 | 30357 | Ovie Fisher F000152 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 21 | |||||||||||||
30375 | 30375 | Thomas Gettys G000144 | rep | SC | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
30393 | 30393 | Edith Green G000407 | rep | OR | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
30411 | 30411 | Martha Griffiths G000471 | rep | MI | 1969-01-03 | 1971-01-03 | Democrat | 17 | |||||||||||||
30448 | 30448 | Richard Hanna H000164 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 34 | |||||||||||||
30459 | 30459 | Julia Hansen H000174 | rep | WA | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
30475 | 30475 | William Hathaway H000346 | rep | ME | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
30494 | 30494 | Chester Holifield H000713 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 19 | |||||||||||||
30528 | 30528 | Peter Kyros K000356 | rep | ME | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
30612 | 30612 | Bertram Podell P000399 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 13 | |||||||||||||
30622 | 30622 | John Rarick R000065 | rep | LA | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
30654 | 30654 | John Rooney R000424 | rep | NY | 1969-01-03 | 1971-01-03 | Democrat | 14 | |||||||||||||
30713 | 30713 | Frank Stubblefield S001037 | rep | KY | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
30734 | 30734 | Robert Tiernan T000265 | rep | RI | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
30742 | 30742 | Jerome Waldie W000035 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 14 | |||||||||||||
30814 | 30814 | Carl Albert A000073 | rep | OK | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
30831 | 30831 | William Barrett B000178 | rep | PA | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
30860 | 30860 | Robert Casey C000228 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 22 | |||||||||||||
30888 | 30888 | John Culver C000979 | rep | IA | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
30897 | 30897 | Dominick Daniels D000041 | rep | NJ | 1969-01-03 | 1971-01-03 | Democrat | 14 |
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);