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 state
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27001 | 27001 | Edna Simpson S000430 | rep | IL | 1959-01-07 | 1961-01-03 | Republican | 20 | |||||||||||||
27152 | 27152 | Robert Chiperfield C000365 | rep | IL | 1959-01-07 | 1961-01-03 | Republican | 19 | |||||||||||||
27158 | 27158 | Marguerite Church C000389 | rep | IL | 1959-01-07 | 1961-01-03 | Republican | 13 | |||||||||||||
27182 | 27182 | Paul Douglas D000456 | sen | IL | 1955-01-05 | 1961-01-03 | 2 | Democrat | |||||||||||||
27329 | 27329 | Peter Mack M000020 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 21 | |||||||||||||
27354 | 27354 | Noah Mason M000224 | rep | IL | 1959-01-07 | 1961-01-03 | Republican | 15 | |||||||||||||
27896 | 27896 | Elmer Hoffman H000684 | rep | IL | 1959-01-07 | 1961-01-03 | Republican | 14 | |||||||||||||
27992 | 27992 | Roland Libonati L000299 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 7 | |||||||||||||
28064 | 28064 | Thomas O’Brien O000016 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
29002 | 29002 | Barratt O’Hara O000053 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
29212 | 29212 | William Dawson D000158 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
29392 | 29392 | William Murphy M001104 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
30037 | 30037 | Roman Pucinski P000559 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 11 | |||||||||||||
30094 | 30094 | William Springer S000756 | rep | IL | 1959-01-07 | 1961-01-03 | Republican | 22 | |||||||||||||
30150 | 30150 | Leslie Arends A000216 | rep | IL | 1959-01-07 | 1961-01-03 | Republican | 17 | |||||||||||||
30253 | 30253 | Harold Collier C000629 | rep | IL | 1959-01-07 | 1961-01-03 | Republican | 10 | |||||||||||||
31109 | 31109 | John Kluczynski K000273 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
31790 | 31790 | George Shipley S000367 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 23 | |||||||||||||
32596 | 32596 | Edward Derwinski D000269 | rep | IL | 1959-01-07 | 1961-01-03 | Republican | 4 | |||||||||||||
33590 | 33590 | Kenneth Gray G000400 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 25 | |||||||||||||
33702 | 33702 | Charles Price P000522 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 24 | |||||||||||||
35429 | 35429 | Robert Michel M000692 | rep | IL | 1959-01-07 | 1961-01-03 | Republican | 18 | |||||||||||||
35534 | 35534 | Daniel Rostenkowski R000458 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 8 | |||||||||||||
36453 | 36453 | Sidney Yates Y000013 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 9 | |||||||||||||
26721 | 26721 | Joseph Barr B000170 | rep | IN | 1959-01-07 | 1961-01-03 | Democrat | 11 | |||||||||||||
26863 | 26863 | Randall Harmon H000216 | rep | IN | 1959-01-07 | 1961-01-03 | Democrat | 10 | |||||||||||||
26881 | 26881 | Earl Hogan H000690 | rep | IN | 1959-01-07 | 1961-01-03 | Democrat | 9 | |||||||||||||
27039 | 27039 | Fred Wampler W000120 | rep | IN | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
28410 | 28410 | Winfield Denton D000260 | rep | IN | 1959-01-07 | 1961-01-03 | Democrat | 8 | |||||||||||||
28872 | 28872 | Charles Halleck H000081 | rep | IN | 1959-01-07 | 1961-01-03 | Republican | 2 | |||||||||||||
29107 | 29107 | Edwin Adair A000024 | rep | IN | 1959-01-07 | 1961-01-03 | Republican | 4 | |||||||||||||
30187 | 30187 | William Bray B000778 | rep | IN | 1959-01-07 | 1961-01-03 | Republican | 7 | |||||||||||||
31151 | 31151 | Ray Madden M000039 | rep | IN | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
31301 | 31301 | John Roush R000467 | rep | IN | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
31956 | 31956 | John Brademas B000736 | rep | IN | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
26860 | 26860 | Newell George G000130 | rep | KS | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
26862 | 26862 | Denver Hargis H000204 | rep | KS | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
26982 | 26982 | Edward Rees R000132 | rep | KS | 1959-01-07 | 1961-01-03 | Republican | 4 | |||||||||||||
27020 | 27020 | Wint Smith S000640 | rep | KS | 1959-01-07 | 1961-01-03 | Republican | 6 | |||||||||||||
27125 | 27125 | James Breeding B000791 | rep | KS | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
27518 | 27518 | Andrew Schoeppel S000138 | sen | KS | 1955-01-05 | 1961-01-03 | 2 | Republican | |||||||||||||
27621 | 27621 | William Avery A000228 | rep | KS | 1959-01-07 | 1961-01-03 | Republican | 1 | |||||||||||||
27140 | 27140 | Frank Burke B001090 | rep | KY | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
27547 | 27547 | Brent Spence S000717 | rep | KY | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
28160 | 28160 | Eugene Siler S000408 | rep | KY | 1959-01-07 | 1961-01-03 | Republican | 8 | |||||||||||||
28368 | 28368 | Frank Chelf C000342 | rep | KY | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
28804 | 28804 | John Cooper C000758 | sen | KY | 1956-01-01 | 1961-01-03 | 2 | Republican | |||||||||||||
30121 | 30121 | John Watts W000212 | rep | KY | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
30708 | 30708 | Frank Stubblefield S001037 | rep | KY | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
33092 | 33092 | Carl Perkins P000230 | rep | KY | 1959-01-07 | 1961-01-03 | Democrat | 7 | |||||||||||||
35460 | 35460 | William Natcher N000009 | rep | KY | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
27138 | 27138 | Overton Brooks B000884 | rep | LA | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
27367 | 27367 | Harold McSween M000605 | rep | LA | 1959-01-07 | 1961-01-03 | Democrat | 8 | |||||||||||||
28582 | 28582 | James Morrison M000995 | rep | LA | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
28707 | 28707 | Theo Thompson T000218 | rep | LA | 1959-01-07 | 1961-01-03 | Democrat | 7 | |||||||||||||
28819 | 28819 | Allen Ellender E000112 | sen | LA | 1955-01-05 | 1961-01-03 | 2 | Democrat | |||||||||||||
29083 | 29083 | Edwin Willis W000559 | rep | LA | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
29616 | 29616 | Thomas Boggs B000594 | rep | LA | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
31044 | 31044 | Felix Hébert H000437 | rep | LA | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
31243 | 31243 | Otto Passman P000098 | rep | LA | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
27000 | 27000 | Edith Rogers R000392 | rep | MA | 1959-01-07 | 1961-01-03 | Republican | 5 | |||||||||||||
27168 | 27168 | Laurence Curtis C001011 | rep | MA | 1959-01-07 | 1961-01-03 | Republican | 10 | |||||||||||||
27313 | 27313 | Thomas Lane L000065 | rep | MA | 1959-01-07 | 1961-01-03 | Democrat | 7 | |||||||||||||
27504 | 27504 | Leverett Saltonstall S000021 | sen | MA | 1955-01-05 | 1961-01-03 | 2 | Republican | |||||||||||||
28546 | 28546 | Joseph Martin M000191 | rep | MA | 1959-01-07 | 1961-01-03 | Republican | 14 | |||||||||||||
29134 | 29134 | William Bates B000239 | rep | MA | 1959-01-07 | 1961-01-03 | Republican | 6 | |||||||||||||
29380 | 29380 | John McCormack M000364 | rep | MA | 1959-01-07 | 1961-01-03 | Democrat | 12 | |||||||||||||
29414 | 29414 | Philip Philbin P000303 | rep | MA | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
29871 | 29871 | Hastings Keith K000053 | rep | MA | 1959-01-07 | 1961-01-03 | Republican | 9 | |||||||||||||
30308 | 30308 | Harold Donohue D000419 | rep | MA | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
31134 | 31134 | Torbert Macdonald M000005 | rep | MA | 1959-01-07 | 1961-01-03 | Democrat | 8 | |||||||||||||
31440 | 31440 | James Burke B001092 | rep | MA | 1959-01-07 | 1961-01-03 | Democrat | 13 | |||||||||||||
33385 | 33385 | Thomas O’Neill O000098 | rep | MA | 1959-01-07 | 1961-01-03 | Democrat | 11 | |||||||||||||
33497 | 33497 | Edward Boland B000600 | rep | MA | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
34325 | 34325 | Silvio Conte C000709 | rep | MA | 1959-01-07 | 1961-01-03 | Republican | 1 | |||||||||||||
26848 | 26848 | John Foley F000237 | rep | MD | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
27256 | 27256 | Thomas Johnson J000176 | rep | MD | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
27656 | 27656 | Daniel Brewster B000813 | rep | MD | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
27979 | 27979 | Richard Lankford L000081 | rep | MD | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
29242 | 29242 | George Fallon F000012 | rep | MD | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
29274 | 29274 | Samuel Friedel F000384 | rep | MD | 1959-01-07 | 1961-01-03 | Democrat | 7 | |||||||||||||
29807 | 29807 | Edward Garmatz G000071 | rep | MD | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
26812 | 26812 | Frank Coffin C000589 | rep | ME | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
26926 | 26926 | James Oliver O000074 | rep | ME | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
28002 | 28002 | Clifford McIntire M000478 | rep | ME | 1959-01-07 | 1961-01-03 | Republican | 3 | |||||||||||||
29046 | 29046 | Margaret Smith S000590 | sen | ME | 1955-01-05 | 1961-01-03 | 2 | Republican | |||||||||||||
26736 | 26736 | Alvin Bentley B000391 | rep | MI | 1959-01-07 | 1961-01-03 | Republican | 8 | |||||||||||||
27243 | 27243 | Clare Hoffman H000683 | rep | MI | 1959-01-07 | 1961-01-03 | Republican | 4 | |||||||||||||
27322 | 27322 | Thaddeus Machrowicz M000014 | rep | MI | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
27365 | 27365 | Patrick McNamara M000582 | sen | MI | 1955-01-05 | 1961-01-03 | 2 | Democrat | |||||||||||||
27427 | 27427 | Louis Rabaut R000001 | rep | MI | 1959-01-07 | 1961-01-03 | Democrat | 14 | |||||||||||||
27650 | 27650 | John Bennett B000377 | rep | MI | 1959-01-07 | 1961-01-03 | Republican | 12 | |||||||||||||
27930 | 27930 | August Johansen J000109 | rep | MI | 1959-01-07 | 1961-01-03 | Republican | 3 | |||||||||||||
27971 | 27971 | Victor Knox K000298 | rep | MI | 1959-01-07 | 1961-01-03 | Republican | 11 | |||||||||||||
27988 | 27988 | John Lesinski L000252 | rep | MI | 1959-01-07 | 1961-01-03 | Democrat | 16 | |||||||||||||
28010 | 28010 | George Meader M000620 | rep | MI | 1959-01-07 | 1961-01-03 | Republican | 2 | |||||||||||||
30233 | 30233 | Charles Chamberlain C000275 | rep | MI | 1959-01-07 | 1961-01-03 | Republican | 6 | |||||||||||||
30397 | 30397 | Robert Griffin G000465 | rep | MI | 1959-01-07 | 1961-01-03 | Republican | 9 | |||||||||||||
30406 | 30406 | Martha Griffiths G000471 | rep | MI | 1959-01-07 | 1961-01-03 | Democrat | 17 | |||||||||||||
30792 | 30792 | Gerald Ford F000260 | rep | MI | 1959-01-07 | 1961-01-03 | Republican | 5 |
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);