legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
489 rows where "end" is on date 1963-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27415 | 27415 | Gracie Pfost P000287 | rep | ID | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
27841 | 27841 | Ralph Harding H000191 | rep | ID | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
30864 | 30864 | Frank Church C000388 | sen | ID | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
27153 | 27153 | Robert Chiperfield C000365 | rep | IL | 1961-01-03 | 1963-01-03 | Republican | 19 | |||||||||||||
27159 | 27159 | Marguerite Church C000389 | rep | IL | 1961-01-03 | 1963-01-03 | Republican | 13 | |||||||||||||
27330 | 27330 | Peter Mack M000020 | rep | IL | 1961-01-03 | 1963-01-03 | Democrat | 21 | |||||||||||||
27355 | 27355 | Noah Mason M000224 | rep | IL | 1961-01-03 | 1963-01-03 | Republican | 15 | |||||||||||||
27751 | 27751 | Everett Dirksen D000360 | sen | IL | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
27781 | 27781 | Edward Finnegan F000135 | rep | IL | 1961-01-03 | 1963-01-03 | Democrat | 12 | |||||||||||||
27897 | 27897 | Elmer Hoffman H000684 | rep | IL | 1961-01-03 | 1963-01-03 | Republican | 14 | |||||||||||||
27993 | 27993 | Roland Libonati L000299 | rep | IL | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
28065 | 28065 | Thomas O’Brien O000016 | rep | IL | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
29003 | 29003 | Barratt O’Hara O000053 | rep | IL | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
29213 | 29213 | William Dawson D000158 | rep | IL | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
29393 | 29393 | William Murphy M001104 | rep | IL | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
30038 | 30038 | Roman Pucinski P000559 | rep | IL | 1961-01-03 | 1963-01-03 | Democrat | 11 | |||||||||||||
30095 | 30095 | William Springer S000756 | rep | IL | 1961-01-03 | 1963-01-03 | Republican | 22 | |||||||||||||
30151 | 30151 | Leslie Arends A000216 | rep | IL | 1961-01-03 | 1963-01-03 | Republican | 17 | |||||||||||||
30254 | 30254 | Harold Collier C000629 | rep | IL | 1961-01-03 | 1963-01-03 | Republican | 10 | |||||||||||||
31110 | 31110 | John Kluczynski K000273 | rep | IL | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
31791 | 31791 | George Shipley S000367 | rep | IL | 1961-01-03 | 1963-01-03 | Democrat | 23 | |||||||||||||
31920 | 31920 | John Anderson A000195 | rep | IL | 1961-01-03 | 1963-01-03 | Republican | 16 | |||||||||||||
32597 | 32597 | Edward Derwinski D000269 | rep | IL | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
32643 | 32643 | Paul Findley F000123 | rep | IL | 1961-01-03 | 1963-01-03 | Republican | 20 | |||||||||||||
33591 | 33591 | Kenneth Gray G000400 | rep | IL | 1961-01-03 | 1963-01-03 | Democrat | 25 | |||||||||||||
33703 | 33703 | Charles Price P000522 | rep | IL | 1961-01-03 | 1963-01-03 | Democrat | 24 | |||||||||||||
35430 | 35430 | Robert Michel M000692 | rep | IL | 1961-01-03 | 1963-01-03 | Republican | 18 | |||||||||||||
35535 | 35535 | Daniel Rostenkowski R000458 | rep | IL | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
36454 | 36454 | Sidney Yates Y000013 | rep | IL | 1961-01-03 | 1963-01-03 | Democrat | 9 | |||||||||||||
26206 | 26206 | Homer Capehart C000128 | sen | IN | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
27661 | 27661 | Donald Bruce B000969 | rep | IN | 1961-01-03 | 1963-01-03 | Republican | 11 | |||||||||||||
28281 | 28281 | Earl Wilson W000572 | rep | IN | 1961-01-03 | 1963-01-03 | Republican | 9 | |||||||||||||
28411 | 28411 | Winfield Denton D000260 | rep | IN | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
28466 | 28466 | Ralph Harvey H000310 | rep | IN | 1961-01-03 | 1963-01-03 | Republican | 10 | |||||||||||||
28873 | 28873 | Charles Halleck H000081 | rep | IN | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
29108 | 29108 | Edwin Adair A000024 | rep | IN | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
29471 | 29471 | Richard Roudebush R000464 | rep | IN | 1961-01-03 | 1963-01-03 | Republican | 6 | |||||||||||||
30188 | 30188 | William Bray B000778 | rep | IN | 1961-01-03 | 1963-01-03 | Republican | 7 | |||||||||||||
31152 | 31152 | Ray Madden M000039 | rep | IN | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
31302 | 31302 | John Roush R000467 | rep | IN | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
31957 | 31957 | John Brademas B000736 | rep | IN | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
27126 | 27126 | James Breeding B000791 | rep | KS | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
27369 | 27369 | Walter McVey M000608 | rep | KS | 1961-01-03 | 1963-01-03 | Republican | 3 | |||||||||||||
27622 | 27622 | William Avery A000228 | rep | KS | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
27708 | 27708 | Frank Carlson C000154 | sen | KS | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
28419 | 28419 | Robert Ellsworth E000148 | rep | KS | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
31324 | 31324 | Garner Shriver S000388 | rep | KS | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
35190 | 35190 | Robert Dole D000401 | rep | KS | 1961-01-03 | 1963-01-03 | Republican | 6 | |||||||||||||
27141 | 27141 | Frank Burke B001090 | rep | KY | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
27548 | 27548 | Brent Spence S000717 | rep | KY | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
28039 | 28039 | Thruston Morton M001022 | sen | KY | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
28161 | 28161 | Eugene Siler S000408 | rep | KY | 1961-01-03 | 1963-01-03 | Republican | 8 | |||||||||||||
28369 | 28369 | Frank Chelf C000342 | rep | KY | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
30122 | 30122 | John Watts W000212 | rep | KY | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
30709 | 30709 | Frank Stubblefield S001037 | rep | KY | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
33093 | 33093 | Carl Perkins P000230 | rep | KY | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
35461 | 35461 | William Natcher N000009 | rep | KY | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
27139 | 27139 | Overton Brooks B000884 | rep | LA | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
27368 | 27368 | Harold McSween M000605 | rep | LA | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
28583 | 28583 | James Morrison M000995 | rep | LA | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
28708 | 28708 | Theo Thompson T000218 | rep | LA | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
29084 | 29084 | Edwin Willis W000559 | rep | LA | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
29617 | 29617 | Thomas Boggs B000594 | rep | LA | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
31045 | 31045 | Felix Hébert H000437 | rep | LA | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
31244 | 31244 | Otto Passman P000098 | rep | LA | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
31869 | 31869 | Joseph Waggonner W000018 | rep | LA | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
32735 | 32735 | Russell Long L000428 | sen | LA | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
27060 | 27060 | Benjamin Smith S000517 | sen | MA | 1960-12-27 | 1963-01-03 | 1 | Democrat | appointment | ||||||||||||
27169 | 27169 | Laurence Curtis C001011 | rep | MA | 1961-01-03 | 1963-01-03 | Republican | 10 | |||||||||||||
27314 | 27314 | Thomas Lane L000065 | rep | MA | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
28547 | 28547 | Joseph Martin M000191 | rep | MA | 1961-01-03 | 1963-01-03 | Republican | 14 | |||||||||||||
29135 | 29135 | William Bates B000239 | rep | MA | 1961-01-03 | 1963-01-03 | Republican | 6 | |||||||||||||
29381 | 29381 | John McCormack M000364 | rep | MA | 1961-01-03 | 1963-01-03 | Democrat | 12 | |||||||||||||
29415 | 29415 | Philip Philbin P000303 | rep | MA | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
29872 | 29872 | Hastings Keith K000053 | rep | MA | 1961-01-03 | 1963-01-03 | Republican | 9 | |||||||||||||
29976 | 29976 | Frank Morse M001009 | rep | MA | 1961-01-03 | 1963-01-03 | Republican | 5 | |||||||||||||
30309 | 30309 | Harold Donohue D000419 | rep | MA | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
31135 | 31135 | Torbert Macdonald M000005 | rep | MA | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
31441 | 31441 | James Burke B001092 | rep | MA | 1961-01-03 | 1963-01-03 | Democrat | 13 | |||||||||||||
33386 | 33386 | Thomas O’Neill O000098 | rep | MA | 1961-01-03 | 1963-01-03 | Democrat | 11 | |||||||||||||
33498 | 33498 | Edward Boland B000600 | rep | MA | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
34326 | 34326 | Silvio Conte C000709 | rep | MA | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
26202 | 26202 | John Butler B001180 | sen | MD | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
27257 | 27257 | Thomas Johnson J000176 | rep | MD | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
27657 | 27657 | Daniel Brewster B000813 | rep | MD | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
27980 | 27980 | Richard Lankford L000081 | rep | MD | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
29243 | 29243 | George Fallon F000012 | rep | MD | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
29275 | 29275 | Samuel Friedel F000384 | rep | MD | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
29808 | 29808 | Edward Garmatz G000071 | rep | MD | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
32743 | 32743 | Charles Mathias M000241 | rep | MD | 1961-01-03 | 1963-01-03 | Republican | 6 | |||||||||||||
27211 | 27211 | Peter Garland G000069 | rep | ME | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
28003 | 28003 | Clifford McIntire M000478 | rep | ME | 1961-01-03 | 1963-01-03 | Republican | 3 | |||||||||||||
28727 | 28727 | Stanley Tupper T000411 | rep | ME | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
27244 | 27244 | Clare Hoffman H000683 | rep | MI | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
27323 | 27323 | Thaddeus Machrowicz M000014 | rep | MI | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
27428 | 27428 | Louis Rabaut R000001 | rep | MI | 1961-01-03 | 1963-01-03 | Democrat | 14 | |||||||||||||
27651 | 27651 | John Bennett B000377 | rep | MI | 1961-01-03 | 1963-01-03 | Republican | 12 | |||||||||||||
27931 | 27931 | August Johansen J000109 | rep | MI | 1961-01-03 | 1963-01-03 | Republican | 3 | |||||||||||||
27972 | 27972 | Victor Knox K000298 | rep | MI | 1961-01-03 | 1963-01-03 | Republican | 11 | |||||||||||||
27989 | 27989 | John Lesinski L000252 | rep | MI | 1961-01-03 | 1963-01-03 | Democrat | 16 |
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);