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)
Suggested facets: type, start, class, party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27059 | 27059 | Maurine Neuberger N000052 | sen | OR | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
27183 | 27183 | Paul Douglas D000456 | sen | IL | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
27497 | 27497 | Absalom Robertson R000317 | sen | VA | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
27505 | 27505 | Leverett Saltonstall S000021 | sen | MA | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
27601 | 27601 | Milward Simpson S000434 | sen | WY | 1962-01-01 | 1967-01-03 | 2 | Republican | |||||||||||||
28307 | 28307 | Ross Bass B000223 | sen | TN | 1964-11-04 | 1967-01-03 | 2 | Democrat | |||||||||||||
28309 | 28309 | Arthur Andrews A000204 | rep | AL | 1965-01-04 | 1967-01-03 | Republican | 4 | |||||||||||||
28315 | 28315 | John Baldwin B000092 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 14 | |||||||||||||
28316 | 28316 | Bert Bandstra B000108 | rep | IA | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
28328 | 28328 | Lindley Beckworth B000296 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
28342 | 28342 | Herbert Bonner B000621 | rep | NC | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
28356 | 28356 | Clarence Brown B000909 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 7 | |||||||||||||
28357 | 28357 | Clair Callan C000054 | rep | NE | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
28358 | 28358 | Howard Callaway C000055 | rep | GA | 1965-01-04 | 1967-01-03 | Republican | 3 | |||||||||||||
28360 | 28360 | Ronald Cameron C000067 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 25 | |||||||||||||
28371 | 28371 | Frank Chelf C000342 | rep | KY | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
28372 | 28372 | Raymond Clevenger C000516 | rep | MI | 1965-01-04 | 1967-01-03 | Democrat | 11 | |||||||||||||
28389 | 28389 | Harold Cooley C000736 | rep | NC | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
28390 | 28390 | Nathaniel Craley C000866 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 19 | |||||||||||||
28395 | 28395 | Willard Curtin C001005 | rep | PA | 1965-01-04 | 1967-01-03 | Republican | 8 | |||||||||||||
28405 | 28405 | Paul Dague D000004 | rep | PA | 1965-01-04 | 1967-01-03 | Republican | 9 | |||||||||||||
28413 | 28413 | Winfield Denton D000260 | rep | IN | 1965-01-04 | 1967-01-03 | Democrat | 8 | |||||||||||||
28418 | 28418 | Kenneth Dyal D000588 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 33 | |||||||||||||
28421 | 28421 | Robert Ellsworth E000148 | rep | KS | 1965-01-04 | 1967-01-03 | Republican | 3 | |||||||||||||
28422 | 28422 | Charles Farnsley F000023 | rep | KY | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
28423 | 28423 | Billie Farnum F000025 | rep | MI | 1965-01-04 | 1967-01-03 | Democrat | 19 | |||||||||||||
28424 | 28424 | John Gilligan G000208 | rep | OH | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
28436 | 28436 | Bernard Grabowski G000348 | rep | CT | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
28437 | 28437 | Stanley Greigg G000450 | rep | IA | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
28438 | 28438 | George Grider G000454 | rep | TN | 1965-01-04 | 1967-01-03 | Democrat | 9 | |||||||||||||
28445 | 28445 | Harlan Hagen H000013 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 18 | |||||||||||||
28446 | 28446 | John Hansen H000173 | rep | IA | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
28459 | 28459 | Oren Harris H000249 | rep | AR | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
28468 | 28468 | Ralph Harvey H000310 | rep | IN | 1965-01-04 | 1967-01-03 | Republican | 10 | |||||||||||||
28474 | 28474 | Joseph Huot H001001 | rep | NH | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
28480 | 28480 | William Jennings J000098 | rep | VA | 1965-01-04 | 1967-01-03 | Democrat | 9 | |||||||||||||
28481 | 28481 | Jed Johnson J000151 | rep | OK | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
28491 | 28491 | Paul Jones J000246 | rep | MO | 1965-01-04 | 1967-01-03 | Democrat | 10 | |||||||||||||
28507 | 28507 | Eugene Keogh K000130 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 11 | |||||||||||||
28510 | 28510 | David King K000199 | rep | UT | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
28511 | 28511 | Paul Krebs K000326 | rep | NJ | 1965-01-04 | 1967-01-03 | Democrat | 12 | |||||||||||||
28520 | 28520 | John Kunkel K000341 | rep | PA | 1965-01-04 | 1967-01-03 | Republican | 16 | |||||||||||||
28524 | 28524 | John Lindsay L000326 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 17 | |||||||||||||
28525 | 28525 | Rodney Love L000458 | rep | OH | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
28526 | 28526 | James MacKay M000022 | rep | GA | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
28527 | 28527 | John Mackie M000026 | rep | MI | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
28528 | 28528 | James Martin M000182 | rep | AL | 1965-01-04 | 1967-01-03 | Republican | 7 | |||||||||||||
28549 | 28549 | Joseph Martin M000191 | rep | MA | 1965-01-04 | 1967-01-03 | Republican | 10 | |||||||||||||
28556 | 28556 | Donald Matthews M000253 | rep | FL | 1965-01-04 | 1967-01-03 | Democrat | 8 | |||||||||||||
28568 | 28568 | Harris McDowell M000418 | rep | DE | 1965-01-04 | 1967-01-03 | Democrat | 0 | |||||||||||||
28569 | 28569 | Thomas McGrath M000459 | rep | NJ | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
28570 | 28570 | Roy McVicker M000610 | rep | CO | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
28573 | 28573 | Walter Moeller M000836 | rep | OH | 1965-01-04 | 1967-01-03 | Democrat | 10 | |||||||||||||
28585 | 28585 | James Morrison M000995 | rep | LA | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
28598 | 28598 | Thomas Murray M001114 | rep | TN | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
28606 | 28606 | Leo O’Brien O000015 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 29 | |||||||||||||
28608 | 28608 | Alec Olson O000084 | rep | MN | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
28615 | 28615 | John Race R000003 | rep | WI | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
28616 | 28616 | Rolland Redlin R000107 | rep | ND | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
28620 | 28620 | Ralph Rivers R000282 | rep | AK | 1965-01-04 | 1967-01-03 | Democrat | 0 | |||||||||||||
28628 | 28628 | Walter Rogers R000404 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 18 | |||||||||||||
28634 | 28634 | James Roosevelt R000426 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 26 | |||||||||||||
28635 | 28635 | Donald Russell R000525 | sen | SC | 1965-04-22 | 1967-01-03 | 3 | Democrat | appointment | ||||||||||||
28636 | 28636 | Darwin Schisler S000128 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 19 | |||||||||||||
28637 | 28637 | John Schmidhauser S000131 | rep | IA | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
28642 | 28642 | Ralph Scott S000184 | rep | NC | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
28652 | 28652 | Robert Secrest S000219 | rep | OH | 1965-01-04 | 1967-01-03 | Democrat | 15 | |||||||||||||
28654 | 28654 | George Senner S000243 | rep | AZ | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
28656 | 28656 | Carlton Sickles S000401 | rep | MD | 1965-01-04 | 1967-01-03 | Democrat | 0 | |||||||||||||
28674 | 28674 | Howard Smith S000554 | rep | VA | 1965-01-04 | 1967-01-03 | Democrat | 8 | |||||||||||||
28675 | 28675 | Lynn Stalbaum S000782 | rep | WI | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
28676 | 28676 | Robert Sweeney S001103 | rep | OH | 1965-01-04 | 1967-01-03 | Democrat | 0 | |||||||||||||
28691 | 28691 | Albert Thomas T000156 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 8 | |||||||||||||
28692 | 28692 | Lera Thomas T000178 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 8 | |||||||||||||
28703 | 28703 | Clark Thompson T000198 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 9 | |||||||||||||
28710 | 28710 | Theo Thompson T000218 | rep | LA | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
28711 | 28711 | Paul Todd T000294 | rep | MI | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
28715 | 28715 | Herman Toll T000297 | rep | PA | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
28726 | 28726 | James Trimble T000373 | rep | AR | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
28729 | 28729 | Stanley Tupper T000411 | rep | ME | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
28731 | 28731 | James Tuten T000436 | rep | GA | 1965-01-04 | 1967-01-03 | Democrat | 8 | |||||||||||||
28733 | 28733 | Weston Vivian V000109 | rep | MI | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
28734 | 28734 | Prentiss Walker W000065 | rep | MS | 1965-01-04 | 1967-01-03 | Republican | 4 | |||||||||||||
28736 | 28736 | Charles Weltner W000290 | rep | GA | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
28738 | 28738 | Compton White W000362 | rep | ID | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
28752 | 28752 | William Spong S000739 | sen | VA | 1966-12-31 | 1967-01-03 | 2 | Democrat | |||||||||||||
28755 | 28755 | Gordon Allott A000161 | sen | CO | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
28762 | 28762 | Clinton Anderson A000186 | sen | NM | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
28770 | 28770 | Robert Ashmore A000223 | rep | SC | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
28780 | 28780 | Edward Bartlett B000201 | sen | AK | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
28785 | 28785 | James Boggs B000593 | sen | DE | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
28800 | 28800 | Frances Bolton B000607 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 22 | |||||||||||||
28805 | 28805 | John Cooper C000758 | sen | KY | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
28814 | 28814 | Thomas Curtis C001014 | rep | MO | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
28820 | 28820 | Allen Ellender E000112 | sen | LA | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
28828 | 28828 | Paul Fino F000137 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 24 | |||||||||||||
28842 | 28842 | John Fogarty F000233 | rep | RI | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
28858 | 28858 | Ezekiel Gathings G000098 | rep | AR | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
28875 | 28875 | Charles Halleck H000081 | rep | IN | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
28886 | 28886 | Porter Hardy H000197 | rep | VA | 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);