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 start
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class, district
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
28805 | 28805 | John Cooper C000758 | sen | KY | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
28820 | 28820 | Allen Ellender E000112 | sen | LA | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
28917 | 28917 | Benjamin Jordan J000267 | sen | NC | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
28964 | 28964 | Jack Miller M000730 | sen | IA | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
28996 | 28996 | Karl Mundt M001078 | sen | SD | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
29029 | 29029 | Richard Russell R000536 | sen | GA | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
29047 | 29047 | Margaret Smith S000590 | sen | ME | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
30229 | 30229 | Clifford Case C000220 | sen | NJ | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
30273 | 30273 | Carl Curtis C001006 | sen | NE | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
30341 | 30341 | James Eastland E000018 | sen | MS | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
30568 | 30568 | John McClellan M000332 | sen | AR | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
30579 | 30579 | Lee Metcalf M000671 | sen | MT | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
30702 | 30702 | John Sparkman S000701 | sen | AL | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
32249 | 32249 | Jennings Randolph R000046 | sen | WV | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
32344 | 32344 | John Tower T000322 | sen | TX | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
34830 | 34830 | Claiborne Pell P000193 | sen | RI | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
36421 | 36421 | J. Thurmond T000254 | sen | SC | 1961-01-03 | 1967-01-03 | 2 | Republican | [ { "start": "1961-01-03", "end": "1964-09-16", "party": "Democrat" }, { "start": "1964-09-16", "end": "1967-01-03", "party": "Republican" } ] |
||||||||||||
27601 | 27601 | Milward Simpson S000434 | sen | WY | 1962-01-01 | 1967-01-03 | 2 | Republican | |||||||||||||
30571 | 30571 | Thomas McIntyre M000486 | sen | NH | 1962-01-01 | 1967-01-03 | 2 | Democrat | |||||||||||||
30608 | 30608 | James Pearson P000166 | sen | KS | 1962-01-31 | 1967-01-03 | 2 | Republican | appointment | ||||||||||||
28919 | 28919 | Leonard Jordan J000269 | sen | ID | 1962-08-06 | 1967-01-03 | 2 | Republican | appointment | ||||||||||||
28888 | 28888 | Fred Harris H000237 | sen | OK | 1964-01-01 | 1967-01-03 | 2 | Democrat | |||||||||||||
28307 | 28307 | Ross Bass B000223 | sen | TN | 1964-11-04 | 1967-01-03 | 2 | Democrat | |||||||||||||
30597 | 30597 | Walter Mondale M000851 | sen | MN | 1964-12-30 | 1967-01-03 | 2 | Democrat | appointment | ||||||||||||
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 | |||||||||||||
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 |
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);