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 1961-01-03 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
39801 | 39801 | John Dingell D000355 | rep | MI | 1959-01-07 | 1961-01-03 | Democrat | 15 | |||||||||||||
39019 | 39019 | Daniel Inouye I000025 | rep | HI | 1959-01-07 | 1961-01-03 | Democrat | 0 | |||||||||||||
36453 | 36453 | Sidney Yates Y000013 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 9 | |||||||||||||
36420 | 36420 | J. Thurmond T000254 | sen | SC | 1956-11-07 | 1961-01-03 | 2 | Democrat | |||||||||||||
35651 | 35651 | Jamie Whitten W000428 | rep | MS | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
35582 | 35582 | Neal Smith S000596 | rep | IA | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
35534 | 35534 | Daniel Rostenkowski R000458 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 8 | |||||||||||||
35460 | 35460 | William Natcher N000009 | rep | KY | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
35429 | 35429 | Robert Michel M000692 | rep | IL | 1959-01-07 | 1961-01-03 | Republican | 18 | |||||||||||||
35138 | 35138 | Jack Brooks B000880 | rep | TX | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
34444 | 34444 | Dante Fascell F000041 | rep | FL | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
34325 | 34325 | Silvio Conte C000709 | rep | MA | 1959-01-07 | 1961-01-03 | Republican | 1 | |||||||||||||
34266 | 34266 | William Broomfield B000890 | rep | MI | 1959-01-07 | 1961-01-03 | Republican | 18 | |||||||||||||
34238 | 34238 | Charles Bennett B000371 | rep | FL | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
34144 | 34144 | James Wright W000763 | rep | TX | 1959-01-07 | 1961-01-03 | Democrat | 12 | |||||||||||||
33958 | 33958 | Robert Kastenmeier K000020 | rep | WI | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
33762 | 33762 | Samuel Stratton S000997 | rep | NY | 1959-01-07 | 1961-01-03 | Democrat | 32 | |||||||||||||
33726 | 33726 | Peter Rodino R000374 | rep | NJ | 1959-01-07 | 1961-01-03 | Democrat | 10 | |||||||||||||
33702 | 33702 | Charles Price P000522 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 24 | |||||||||||||
33637 | 33637 | Delbert Latta L000116 | rep | OH | 1959-01-07 | 1961-01-03 | Republican | 5 | |||||||||||||
33590 | 33590 | Kenneth Gray G000400 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 25 | |||||||||||||
33497 | 33497 | Edward Boland B000600 | rep | MA | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
33385 | 33385 | Thomas O’Neill O000098 | rep | MA | 1959-01-07 | 1961-01-03 | Democrat | 11 | |||||||||||||
33196 | 33196 | Clement Zablocki Z000001 | rep | WI | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
33092 | 33092 | Carl Perkins P000230 | rep | KY | 1959-01-07 | 1961-01-03 | Democrat | 7 | |||||||||||||
32826 | 32826 | John Rhodes R000188 | rep | AZ | 1959-01-07 | 1961-01-03 | Republican | 1 | |||||||||||||
32811 | 32811 | Henry Reuss R000165 | rep | WI | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
32661 | 32661 | Lawrence Fountain F000319 | rep | NC | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
32596 | 32596 | Edward Derwinski D000269 | rep | IL | 1959-01-07 | 1961-01-03 | Republican | 4 | |||||||||||||
32494 | 32494 | Richard Bolling B000605 | rep | MO | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
32401 | 32401 | Robert Wilson W000610 | rep | CA | 1959-01-07 | 1961-01-03 | Republican | 30 | |||||||||||||
32378 | 32378 | Charles Vanik V000047 | rep | OH | 1959-01-07 | 1961-01-03 | Democrat | 21 | |||||||||||||
32356 | 32356 | Albert Ullman U000004 | rep | OR | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
32333 | 32333 | Frank Thompson T000200 | rep | NJ | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
32319 | 32319 | Thomas Steed S000829 | rep | OK | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
32303 | 32303 | Harley Staggers S000778 | rep | WV | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
32283 | 32283 | John Slack S000473 | rep | WV | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
32248 | 32248 | Jennings Randolph R000046 | sen | WV | 1958-11-05 | 1961-01-03 | 2 | Democrat | |||||||||||||
32184 | 32184 | William Moorhead M000930 | rep | PA | 1959-01-07 | 1961-01-03 | Democrat | 28 | |||||||||||||
32131 | 32131 | Harold Johnson J000135 | rep | CA | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
32076 | 32076 | Robert Giaimo G000151 | rep | CT | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
32065 | 32065 | Daniel Flood F000209 | rep | PA | 1959-01-07 | 1961-01-03 | Democrat | 11 | |||||||||||||
32028 | 32028 | Charles Diggs D000344 | rep | MI | 1959-01-07 | 1961-01-03 | Democrat | 13 | |||||||||||||
32015 | 32015 | Samuel Devine D000279 | rep | OH | 1959-01-07 | 1961-01-03 | Republican | 12 | |||||||||||||
31956 | 31956 | John Brademas B000736 | rep | IN | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
31932 | 31932 | Thomas Ashley A000222 | rep | OH | 1959-01-07 | 1961-01-03 | Democrat | 9 | |||||||||||||
31903 | 31903 | John Young Y000043 | rep | TX | 1959-01-07 | 1961-01-03 | Democrat | 14 | |||||||||||||
31853 | 31853 | Olin Teague T000110 | rep | TX | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
31821 | 31821 | Bernice Sisk S000454 | rep | CA | 1959-01-07 | 1961-01-03 | Democrat | 12 | |||||||||||||
31809 | 31809 | Robert Sikes S000406 | rep | FL | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
31790 | 31790 | George Shipley S000367 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 23 | |||||||||||||
31754 | 31754 | Paul Rogers R000401 | rep | FL | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
31740 | 31740 | Albert Quie Q000010 | rep | MN | 1959-01-07 | 1961-01-03 | Republican | 1 | |||||||||||||
31729 | 31729 | William Poage P000398 | rep | TX | 1959-01-07 | 1961-01-03 | Democrat | 11 | |||||||||||||
31695 | 31695 | Robert Nix N000113 | rep | PA | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
31678 | 31678 | John Moss M001035 | rep | CA | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
31649 | 31649 | John McFall M000436 | rep | CA | 1959-01-07 | 1961-01-03 | Democrat | 11 | |||||||||||||
31633 | 31633 | George Mahon M000065 | rep | TX | 1959-01-07 | 1961-01-03 | Democrat | 19 | |||||||||||||
31593 | 31593 | Hubert Humphrey H000953 | sen | MN | 1955-01-05 | 1961-01-03 | 2 | Democrat | |||||||||||||
31559 | 31559 | John Flynt F000229 | rep | GA | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
31528 | 31528 | John Dent D000255 | rep | PA | 1959-01-07 | 1961-01-03 | Democrat | 21 | |||||||||||||
31517 | 31517 | James Delaney D000211 | rep | NY | 1959-01-07 | 1961-01-03 | Democrat | 7 | |||||||||||||
31489 | 31489 | Elford Cederberg C000263 | rep | MI | 1959-01-07 | 1961-01-03 | Republican | 10 | |||||||||||||
31459 | 31459 | Omar Burleson B001111 | rep | TX | 1959-01-07 | 1961-01-03 | Democrat | 17 | |||||||||||||
31440 | 31440 | James Burke B001092 | rep | MA | 1959-01-07 | 1961-01-03 | Democrat | 13 | |||||||||||||
31385 | 31385 | Roy Taylor T000099 | rep | NC | 1959-01-07 | 1961-01-03 | Democrat | 12 | |||||||||||||
31361 | 31361 | Leonor Sullivan S001057 | rep | MO | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
31309 | 31309 | Herman Schneebeli S000135 | rep | PA | 1959-01-07 | 1961-01-03 | Republican | 17 | |||||||||||||
31301 | 31301 | John Roush R000467 | rep | IN | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
31281 | 31281 | William Randall R000041 | rep | MO | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
31267 | 31267 | John Patman P000103 | rep | TX | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
31243 | 31243 | Otto Passman P000098 | rep | LA | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
31228 | 31228 | James O’Hara O000055 | rep | MI | 1959-01-07 | 1961-01-03 | Democrat | 7 | |||||||||||||
31208 | 31208 | Thomas Morgan M000958 | rep | PA | 1959-01-07 | 1961-01-03 | Democrat | 26 | |||||||||||||
31191 | 31191 | Wilbur Mills M000778 | rep | AR | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
31175 | 31175 | George McGovern M000452 | rep | SD | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
31151 | 31151 | Ray Madden M000039 | rep | IN | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
31134 | 31134 | Torbert Macdonald M000005 | rep | MA | 1959-01-07 | 1961-01-03 | Democrat | 8 | |||||||||||||
31121 | 31121 | Phillip Landrum L000054 | rep | GA | 1959-01-07 | 1961-01-03 | Democrat | 9 | |||||||||||||
31109 | 31109 | John Kluczynski K000273 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
31096 | 31096 | Joseph Karth K000014 | rep | MN | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
31087 | 31087 | Robert Jones J000248 | rep | AL | 1959-01-07 | 1961-01-03 | Democrat | 8 | |||||||||||||
31057 | 31057 | John Jarman J000057 | rep | OK | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
31044 | 31044 | Felix Hébert H000437 | rep | LA | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
30989 | 30989 | Kenneth Hechler H000438 | rep | WV | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
30980 | 30980 | Wayne Hays H000408 | rep | OH | 1959-01-07 | 1961-01-03 | Democrat | 18 | |||||||||||||
30960 | 30960 | James Haley H000041 | rep | FL | 1959-01-07 | 1961-01-03 | Democrat | 7 | |||||||||||||
30927 | 30927 | Joseph Evins E000273 | rep | TN | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
30901 | 30901 | Thomas Downing D000474 | rep | VA | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
30892 | 30892 | Dominick Daniels D000041 | rep | NJ | 1959-01-07 | 1961-01-03 | Democrat | 14 | |||||||||||||
30855 | 30855 | Robert Casey C000228 | rep | TX | 1959-01-07 | 1961-01-03 | Democrat | 22 | |||||||||||||
30826 | 30826 | William Barrett B000178 | rep | PA | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
30809 | 30809 | Carl Albert A000073 | rep | OK | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
30792 | 30792 | Gerald Ford F000260 | rep | MI | 1959-01-07 | 1961-01-03 | Republican | 5 | |||||||||||||
30753 | 30753 | William Widnall W000445 | rep | NJ | 1959-01-07 | 1961-01-03 | Republican | 7 | |||||||||||||
30718 | 30718 | Charles Teague T000109 | rep | CA | 1959-01-07 | 1961-01-03 | Republican | 13 | |||||||||||||
30708 | 30708 | Frank Stubblefield S001037 | rep | KY | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
30701 | 30701 | John Sparkman S000701 | sen | AL | 1955-01-05 | 1961-01-03 | 2 | Democrat | |||||||||||||
30671 | 30671 | John Saylor S000102 | rep | PA | 1959-01-07 | 1961-01-03 | Republican | 22 | |||||||||||||
30649 | 30649 | John Rooney R000424 | rep | NY | 1959-01-07 | 1961-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);