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 descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
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 | |||||||||||||
28356 | 28356 | Clarence Brown B000909 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 7 | |||||||||||||
28358 | 28358 | Howard Callaway C000055 | rep | GA | 1965-01-04 | 1967-01-03 | Republican | 3 | |||||||||||||
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 | |||||||||||||
28421 | 28421 | Robert Ellsworth E000148 | rep | KS | 1965-01-04 | 1967-01-03 | Republican | 3 | |||||||||||||
28468 | 28468 | Ralph Harvey H000310 | rep | IN | 1965-01-04 | 1967-01-03 | Republican | 10 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
28729 | 28729 | Stanley Tupper T000411 | rep | ME | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
28734 | 28734 | Prentiss Walker W000065 | rep | MS | 1965-01-04 | 1967-01-03 | Republican | 4 | |||||||||||||
28755 | 28755 | Gordon Allott A000161 | sen | CO | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
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 | |||||||||||||
28828 | 28828 | Paul Fino F000137 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 24 | |||||||||||||
28875 | 28875 | Charles Halleck H000081 | rep | IN | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
28919 | 28919 | Leonard Jordan J000269 | sen | ID | 1962-08-06 | 1967-01-03 | 2 | Republican | appointment | ||||||||||||
28960 | 28960 | Theodore Kupferman K000343 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 17 | |||||||||||||
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 | |||||||||||||
28996 | 28996 | Karl Mundt M001078 | sen | SD | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
29047 | 29047 | Margaret Smith S000590 | sen | ME | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
29293 | 29293 | Edward Gurney G000531 | rep | FL | 1965-01-04 | 1967-01-03 | Republican | 11 | |||||||||||||
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 | |||||||||||||
29358 | 29358 | Catherine May M000273 | rep | WA | 1965-01-04 | 1967-01-03 | Republican | 4 | |||||||||||||
29389 | 29389 | Chester Mize M000832 | rep | KS | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
29660 | 29660 | John Byrnes B001216 | rep | WI | 1965-01-04 | 1967-01-03 | Republican | 8 | |||||||||||||
29728 | 29728 | Robert Corbett C000772 | rep | PA | 1965-01-04 | 1967-01-03 | Republican | 18 | |||||||||||||
29753 | 29753 | Florence Dwyer D000587 | rep | NJ | 1965-01-04 | 1967-01-03 | Republican | 6 | |||||||||||||
29786 | 29786 | James Fulton F000422 | rep | PA | 1965-01-04 | 1967-01-03 | Republican | 27 | |||||||||||||
29825 | 29825 | Durward Hall H000049 | rep | MO | 1965-01-04 | 1967-01-03 | Republican | 7 | |||||||||||||
29832 | 29832 | Seymour Halpern H000085 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 6 | |||||||||||||
29863 | 29863 | Charles Jonas J000206 | rep | NC | 1965-01-04 | 1967-01-03 | Republican | 8 | |||||||||||||
29874 | 29874 | Hastings Keith K000053 | rep | MA | 1965-01-04 | 1967-01-03 | Republican | 12 | |||||||||||||
29920 | 29920 | William McCulloch M000393 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 4 | |||||||||||||
29978 | 29978 | Frank Morse M001009 | rep | MA | 1965-01-04 | 1967-01-03 | Republican | 5 | |||||||||||||
29983 | 29983 | Rogers Morton M001021 | rep | MD | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
30001 | 30001 | Alvin O’Konski O000058 | rep | WI | 1965-01-04 | 1967-01-03 | Republican | 10 | |||||||||||||
30016 | 30016 | Thomas Pelly P000196 | rep | WA | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
30023 | 30023 | Alexander Pirnie P000366 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 32 | |||||||||||||
30033 | 30033 | Richard Poff P000401 | rep | VA | 1965-01-04 | 1967-01-03 | Republican | 6 | |||||||||||||
30051 | 30051 | Charlotte Reid R000143 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 15 | |||||||||||||
30086 | 30086 | H. Smith S000545 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 20 | |||||||||||||
30097 | 30097 | William Springer S000756 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 22 | |||||||||||||
30131 | 30131 | John Whalley W000320 | rep | PA | 1965-01-04 | 1967-01-03 | Republican | 12 | |||||||||||||
30153 | 30153 | Leslie Arends A000216 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 17 | |||||||||||||
30190 | 30190 | William Bray B000778 | rep | IN | 1965-01-04 | 1967-01-03 | Republican | 7 | |||||||||||||
30208 | 30208 | Joel Broyhill B000967 | rep | VA | 1965-01-04 | 1967-01-03 | Republican | 10 | |||||||||||||
30229 | 30229 | Clifford Case C000220 | sen | NJ | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
30236 | 30236 | Charles Chamberlain C000275 | rep | MI | 1965-01-04 | 1967-01-03 | Republican | 6 | |||||||||||||
30256 | 30256 | Harold Collier C000629 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 10 | |||||||||||||
30273 | 30273 | Carl Curtis C001006 | sen | NE | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
30281 | 30281 | Glenn Davis D000102 | rep | WI | 1965-01-04 | 1967-01-03 | Republican | 9 | |||||||||||||
30366 | 30366 | Peter Frelinghuysen F000371 | rep | NJ | 1965-01-04 | 1967-01-03 | Republican | 5 | |||||||||||||
30401 | 30401 | Robert Griffin G000465 | sen | MI | 1966-05-11 | 1967-01-03 | 2 | Republican | appointment | ||||||||||||
30422 | 30422 | Harold Gross G000495 | rep | IA | 1965-01-04 | 1967-01-03 | Republican | 3 | |||||||||||||
30428 | 30428 | James Grover G000504 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
30439 | 30439 | Charles Gubser G000512 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 10 | |||||||||||||
30467 | 30467 | James Harvey H000306 | rep | MI | 1965-01-04 | 1967-01-03 | Republican | 8 | |||||||||||||
30503 | 30503 | Craig Hosmer H000802 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 32 | |||||||||||||
30518 | 30518 | Carleton King K000195 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 30 | |||||||||||||
30540 | 30540 | William Mailliard M000070 | rep | CA | 1965-01-04 | 1967-01-03 | Republican | 6 | |||||||||||||
30550 | 30550 | David Martin M000175 | rep | NE | 1965-01-04 | 1967-01-03 | Republican | 3 | |||||||||||||
30589 | 30589 | William Minshall M000799 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 23 | |||||||||||||
30603 | 30603 | Ancher Nelsen N000028 | rep | MN | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
30608 | 30608 | James Pearson P000166 | sen | KS | 1962-01-31 | 1967-01-03 | 2 | Republican | appointment | ||||||||||||
30626 | 30626 | Ogden Reid R000150 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 26 | |||||||||||||
30635 | 30635 | Howard Robison R000357 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 33 | |||||||||||||
30674 | 30674 | John Saylor S000102 | rep | PA | 1965-01-04 | 1967-01-03 | Republican | 22 |
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);