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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28446 | 28446 | John Hansen H000173 | rep | IA | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
28637 | 28637 | John Schmidhauser S000131 | rep | IA | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
28964 | 28964 | Jack Miller M000730 | sen | IA | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
30422 | 30422 | Harold Gross G000495 | rep | IA | 1965-01-04 | 1967-01-03 | Republican | 3 | |||||||||||||
30886 | 30886 | John Culver C000979 | rep | IA | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
35585 | 35585 | Neal Smith S000596 | rep | IA | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
28738 | 28738 | Compton White W000362 | rep | ID | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
28919 | 28919 | Leonard Jordan J000269 | sen | ID | 1962-08-06 | 1967-01-03 | 2 | Republican | appointment | ||||||||||||
32985 | 32985 | George Hansen H000171 | rep | ID | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
27183 | 27183 | Paul Douglas D000456 | sen | IL | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
28636 | 28636 | Darwin Schisler S000128 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 19 | |||||||||||||
29005 | 29005 | Barratt O’Hara O000053 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
29215 | 29215 | William Dawson D000158 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
29395 | 29395 | William Murphy M001104 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
29468 | 29468 | Daniel Ronan R000420 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
29477 | 29477 | Donald Rumsfeld R000508 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 13 | |||||||||||||
30040 | 30040 | Roman Pucinski P000559 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 11 | |||||||||||||
30051 | 30051 | Charlotte Reid R000143 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 15 | |||||||||||||
30097 | 30097 | William Springer S000756 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 22 | |||||||||||||
30153 | 30153 | Leslie Arends A000216 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 17 | |||||||||||||
30256 | 30256 | Harold Collier C000629 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 10 | |||||||||||||
31112 | 31112 | John Kluczynski K000273 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
31793 | 31793 | George Shipley S000367 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 23 | |||||||||||||
31922 | 31922 | John Anderson A000195 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 16 | |||||||||||||
32599 | 32599 | Edward Derwinski D000269 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 4 | |||||||||||||
32645 | 32645 | Paul Findley F000123 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 20 | |||||||||||||
32755 | 32755 | Robert McClory M000340 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 12 | |||||||||||||
32958 | 32958 | John Erlenborn E000204 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 14 | |||||||||||||
33593 | 33593 | Kenneth Gray G000400 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 21 | |||||||||||||
33705 | 33705 | Charles Price P000522 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 24 | |||||||||||||
34186 | 34186 | Frank Annunzio A000212 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
35432 | 35432 | Robert Michel M000692 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 18 | |||||||||||||
35537 | 35537 | Daniel Rostenkowski R000458 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 8 | |||||||||||||
36455 | 36455 | Sidney Yates Y000013 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 9 | |||||||||||||
28413 | 28413 | Winfield Denton D000260 | rep | IN | 1965-01-04 | 1967-01-03 | Democrat | 8 | |||||||||||||
28468 | 28468 | Ralph Harvey H000310 | rep | IN | 1965-01-04 | 1967-01-03 | Republican | 10 | |||||||||||||
28875 | 28875 | Charles Halleck H000081 | rep | IN | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
29110 | 29110 | Edwin Adair A000024 | rep | IN | 1965-01-04 | 1967-01-03 | Republican | 4 | |||||||||||||
29473 | 29473 | Richard Roudebush R000464 | rep | IN | 1965-01-04 | 1967-01-03 | Republican | 6 | |||||||||||||
30190 | 30190 | William Bray B000778 | rep | IN | 1965-01-04 | 1967-01-03 | Republican | 7 | |||||||||||||
31154 | 31154 | Ray Madden M000039 | rep | IN | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
31304 | 31304 | John Roush R000467 | rep | IN | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
31959 | 31959 | John Brademas B000736 | rep | IN | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
35863 | 35863 | Andrew Jacobs J000033 | rep | IN | 1965-01-04 | 1967-01-03 | Democrat | 11 | |||||||||||||
36228 | 36228 | Lee Hamilton H000114 | rep | IN | 1965-01-04 | 1967-01-03 | Democrat | 9 | |||||||||||||
28421 | 28421 | Robert Ellsworth E000148 | rep | KS | 1965-01-04 | 1967-01-03 | Republican | 3 | |||||||||||||
29389 | 29389 | Chester Mize M000832 | rep | KS | 1965-01-04 | 1967-01-03 | Republican | 2 | |||||||||||||
30608 | 30608 | James Pearson P000166 | sen | KS | 1962-01-31 | 1967-01-03 | 2 | Republican | appointment | ||||||||||||
31326 | 31326 | Garner Shriver S000388 | rep | KS | 1965-01-04 | 1967-01-03 | Republican | 4 | |||||||||||||
31832 | 31832 | Joe Skubitz S000472 | rep | KS | 1965-01-04 | 1967-01-03 | Republican | 5 | |||||||||||||
35192 | 35192 | Robert Dole D000401 | rep | KS | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
28371 | 28371 | Frank Chelf C000342 | rep | KY | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
28422 | 28422 | Charles Farnsley F000023 | rep | KY | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
28805 | 28805 | John Cooper C000758 | sen | KY | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
30124 | 30124 | John Watts W000212 | rep | KY | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
30711 | 30711 | Frank Stubblefield S001037 | rep | KY | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
31981 | 31981 | Tim Carter C000201 | rep | KY | 1965-01-04 | 1967-01-03 | Republican | 5 | |||||||||||||
33095 | 33095 | Carl Perkins P000230 | rep | KY | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
35463 | 35463 | William Natcher N000009 | rep | KY | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
28585 | 28585 | James Morrison M000995 | rep | LA | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
28710 | 28710 | Theo Thompson T000218 | rep | LA | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
28820 | 28820 | Allen Ellender E000112 | sen | LA | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
29086 | 29086 | Edwin Willis W000559 | rep | LA | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
29619 | 29619 | Thomas Boggs B000594 | rep | LA | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
29767 | 29767 | Edwin Edwards E000067 | rep | LA | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
29898 | 29898 | Speedy Long L000429 | rep | LA | 1965-01-04 | 1967-01-03 | Democrat | 8 | |||||||||||||
31047 | 31047 | Felix Hébert H000437 | rep | LA | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
31246 | 31246 | Otto Passman P000098 | rep | LA | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
31871 | 31871 | Joseph Waggonner W000018 | rep | LA | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
27505 | 27505 | Leverett Saltonstall S000021 | sen | MA | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
28549 | 28549 | Joseph Martin M000191 | rep | MA | 1965-01-04 | 1967-01-03 | Republican | 10 | |||||||||||||
29137 | 29137 | William Bates B000239 | rep | MA | 1965-01-04 | 1967-01-03 | Republican | 6 | |||||||||||||
29383 | 29383 | John McCormack M000364 | rep | MA | 1965-01-04 | 1967-01-03 | Democrat | 9 | |||||||||||||
29417 | 29417 | Philip Philbin P000303 | rep | MA | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
29874 | 29874 | Hastings Keith K000053 | rep | MA | 1965-01-04 | 1967-01-03 | Republican | 12 | |||||||||||||
29978 | 29978 | Frank Morse M001009 | rep | MA | 1965-01-04 | 1967-01-03 | Republican | 5 | |||||||||||||
30311 | 30311 | Harold Donohue D000419 | rep | MA | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
31137 | 31137 | Torbert Macdonald M000005 | rep | MA | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
31443 | 31443 | James Burke B001092 | rep | MA | 1965-01-04 | 1967-01-03 | Democrat | 11 | |||||||||||||
33388 | 33388 | Thomas O’Neill O000098 | rep | MA | 1965-01-04 | 1967-01-03 | Democrat | 8 | |||||||||||||
33500 | 33500 | Edward Boland B000600 | rep | MA | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
34328 | 34328 | Silvio Conte C000709 | rep | MA | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
28656 | 28656 | Carlton Sickles S000401 | rep | MD | 1965-01-04 | 1967-01-03 | Democrat | 0 | |||||||||||||
28962 | 28962 | Hervey Machen M000011 | rep | MD | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
29245 | 29245 | George Fallon F000012 | rep | MD | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
29277 | 29277 | Samuel Friedel F000384 | rep | MD | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
29810 | 29810 | Edward Garmatz G000071 | rep | MD | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
29983 | 29983 | Rogers Morton M001021 | rep | MD | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
32745 | 32745 | Charles Mathias M000241 | rep | MD | 1965-01-04 | 1967-01-03 | Republican | 6 | |||||||||||||
33029 | 33029 | Clarence Long L000413 | rep | MD | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
28729 | 28729 | Stanley Tupper T000411 | rep | ME | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
29047 | 29047 | Margaret Smith S000590 | sen | ME | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
30473 | 30473 | William Hathaway H000346 | rep | ME | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
28372 | 28372 | Raymond Clevenger C000516 | rep | MI | 1965-01-04 | 1967-01-03 | Democrat | 11 | |||||||||||||
28423 | 28423 | Billie Farnum F000025 | rep | MI | 1965-01-04 | 1967-01-03 | Democrat | 19 | |||||||||||||
28527 | 28527 | John Mackie M000026 | rep | MI | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
28711 | 28711 | Paul Todd T000294 | rep | MI | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
28733 | 28733 | Weston Vivian V000109 | rep | MI | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
30236 | 30236 | Charles Chamberlain C000275 | rep | MI | 1965-01-04 | 1967-01-03 | Republican | 6 | |||||||||||||
30401 | 30401 | Robert Griffin G000465 | sen | MI | 1966-05-11 | 1967-01-03 | 2 | Republican | appointment |
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);