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)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30632 | 30632 | Howard Robison R000357 | rep | NY | 1959-01-07 | 1961-01-03 | Republican | 37 | |||||||||||||
30600 | 30600 | Ancher Nelsen N000028 | rep | MN | 1959-01-07 | 1961-01-03 | Republican | 2 | |||||||||||||
30586 | 30586 | William Minshall M000799 | rep | OH | 1959-01-07 | 1961-01-03 | Republican | 23 | |||||||||||||
30578 | 30578 | Lee Metcalf M000671 | rep | MT | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
30567 | 30567 | John McClellan M000332 | sen | AR | 1955-01-05 | 1961-01-03 | 2 | Democrat | |||||||||||||
30537 | 30537 | William Mailliard M000070 | rep | CA | 1959-01-07 | 1961-01-03 | Republican | 4 | |||||||||||||
30500 | 30500 | Craig Hosmer H000802 | rep | CA | 1959-01-07 | 1961-01-03 | Republican | 18 | |||||||||||||
30489 | 30489 | Chester Holifield H000713 | rep | CA | 1959-01-07 | 1961-01-03 | Democrat | 19 | |||||||||||||
30454 | 30454 | Julia Hansen H000174 | rep | WA | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
30436 | 30436 | Charles Gubser G000512 | rep | CA | 1959-01-07 | 1961-01-03 | Republican | 10 | |||||||||||||
30419 | 30419 | Harold Gross G000495 | rep | IA | 1959-01-07 | 1961-01-03 | Republican | 3 | |||||||||||||
30406 | 30406 | Martha Griffiths G000471 | rep | MI | 1959-01-07 | 1961-01-03 | Democrat | 17 | |||||||||||||
30397 | 30397 | Robert Griffin G000465 | rep | MI | 1959-01-07 | 1961-01-03 | Republican | 9 | |||||||||||||
30388 | 30388 | Edith Green G000407 | rep | OR | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
30363 | 30363 | Peter Frelinghuysen F000371 | rep | NJ | 1959-01-07 | 1961-01-03 | Republican | 5 | |||||||||||||
30352 | 30352 | Ovie Fisher F000152 | rep | TX | 1959-01-07 | 1961-01-03 | Democrat | 21 | |||||||||||||
30340 | 30340 | James Eastland E000018 | sen | MS | 1955-01-05 | 1961-01-03 | 2 | Democrat | |||||||||||||
30329 | 30329 | Thaddeus Dulski D000523 | rep | NY | 1959-01-07 | 1961-01-03 | Democrat | 41 | |||||||||||||
30321 | 30321 | William Dorn D000434 | rep | SC | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
30308 | 30308 | Harold Donohue D000419 | rep | MA | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
30272 | 30272 | Carl Curtis C001006 | sen | NE | 1955-01-05 | 1961-01-03 | 2 | Republican | |||||||||||||
30253 | 30253 | Harold Collier C000629 | rep | IL | 1959-01-07 | 1961-01-03 | Republican | 10 | |||||||||||||
30243 | 30243 | Frank Clark C000431 | rep | PA | 1959-01-07 | 1961-01-03 | Democrat | 25 | |||||||||||||
30233 | 30233 | Charles Chamberlain C000275 | rep | MI | 1959-01-07 | 1961-01-03 | Republican | 6 | |||||||||||||
30228 | 30228 | Clifford Case C000220 | sen | NJ | 1955-01-05 | 1961-01-03 | 2 | Republican | |||||||||||||
30205 | 30205 | Joel Broyhill B000967 | rep | VA | 1959-01-07 | 1961-01-03 | Republican | 10 | |||||||||||||
30187 | 30187 | William Bray B000778 | rep | IN | 1959-01-07 | 1961-01-03 | Republican | 7 | |||||||||||||
30171 | 30171 | John Blatnik B000550 | rep | MN | 1959-01-07 | 1961-01-03 | Democrat | 8 | |||||||||||||
30150 | 30150 | Leslie Arends A000216 | rep | IL | 1959-01-07 | 1961-01-03 | Republican | 17 | |||||||||||||
30128 | 30128 | John Whalley W000320 | rep | PA | 1959-01-07 | 1961-01-03 | Republican | 18 | |||||||||||||
30121 | 30121 | John Watts W000212 | rep | KY | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
30094 | 30094 | William Springer S000756 | rep | IL | 1959-01-07 | 1961-01-03 | Republican | 22 | |||||||||||||
30083 | 30083 | H. Smith S000545 | rep | CA | 1959-01-07 | 1961-01-03 | Republican | 20 | |||||||||||||
30065 | 30065 | Frederick Schwengel S000161 | rep | IA | 1959-01-07 | 1961-01-03 | Republican | 1 | |||||||||||||
30037 | 30037 | Roman Pucinski P000559 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 11 | |||||||||||||
30030 | 30030 | Richard Poff P000401 | rep | VA | 1959-01-07 | 1961-01-03 | Republican | 6 | |||||||||||||
30020 | 30020 | Alexander Pirnie P000366 | rep | NY | 1959-01-07 | 1961-01-03 | Republican | 34 | |||||||||||||
30013 | 30013 | Thomas Pelly P000196 | rep | WA | 1959-01-07 | 1961-01-03 | Republican | 1 | |||||||||||||
29998 | 29998 | Alvin O’Konski O000058 | rep | WI | 1959-01-07 | 1961-01-03 | Republican | 10 | |||||||||||||
29970 | 29970 | Joseph Montoya M000876 | rep | NM | 1959-01-07 | 1961-01-03 | Democrat | 0 | |||||||||||||
29962 | 29962 | John Monagan M000847 | rep | CT | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
29955 | 29955 | George Miller M000727 | rep | CA | 1959-01-07 | 1961-01-03 | Democrat | 8 | |||||||||||||
29941 | 29941 | John McMillan M000568 | rep | SC | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
29917 | 29917 | William McCulloch M000393 | rep | OH | 1959-01-07 | 1961-01-03 | Republican | 4 | |||||||||||||
29886 | 29886 | Alton Lennon L000240 | rep | NC | 1959-01-07 | 1961-01-03 | Democrat | 7 | |||||||||||||
29878 | 29878 | John Kyl K000351 | rep | IA | 1959-01-07 | 1961-01-03 | Republican | 4 | |||||||||||||
29871 | 29871 | Hastings Keith K000053 | rep | MA | 1959-01-07 | 1961-01-03 | Republican | 9 | |||||||||||||
29860 | 29860 | Charles Jonas J000206 | rep | NC | 1959-01-07 | 1961-01-03 | Republican | 10 | |||||||||||||
29850 | 29850 | William Hull H000947 | rep | MO | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
29829 | 29829 | Seymour Halpern H000085 | rep | NY | 1959-01-07 | 1961-01-03 | Republican | 4 | |||||||||||||
29807 | 29807 | Edward Garmatz G000071 | rep | MD | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
29793 | 29793 | Cornelius Gallagher G000016 | rep | NJ | 1959-01-07 | 1961-01-03 | Democrat | 13 | |||||||||||||
29783 | 29783 | James Fulton F000422 | rep | PA | 1959-01-07 | 1961-01-03 | Republican | 27 | |||||||||||||
29760 | 29760 | Edmond Edmondson E000054 | rep | OK | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
29750 | 29750 | Florence Dwyer D000587 | rep | NJ | 1959-01-07 | 1961-01-03 | Republican | 6 | |||||||||||||
29742 | 29742 | John Dowdy D000467 | rep | TX | 1959-01-07 | 1961-01-03 | Democrat | 7 | |||||||||||||
29725 | 29725 | Robert Corbett C000772 | rep | PA | 1959-01-07 | 1961-01-03 | Republican | 29 | |||||||||||||
29709 | 29709 | William Colmer C000645 | rep | MS | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
29689 | 29689 | Emanuel Celler C000264 | rep | NY | 1959-01-07 | 1961-01-03 | Democrat | 11 | |||||||||||||
29657 | 29657 | John Byrnes B001216 | rep | WI | 1959-01-07 | 1961-01-03 | Republican | 8 | |||||||||||||
29643 | 29643 | James Byrne B001212 | rep | PA | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
29627 | 29627 | Frank Bow B000676 | rep | OH | 1959-01-07 | 1961-01-03 | Republican | 16 | |||||||||||||
29616 | 29616 | Thomas Boggs B000594 | rep | LA | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
29599 | 29599 | Jackson Betts B000426 | rep | OH | 1959-01-07 | 1961-01-03 | Republican | 8 | |||||||||||||
29588 | 29588 | Page Belcher B000323 | rep | OK | 1959-01-07 | 1961-01-03 | Republican | 1 | |||||||||||||
29574 | 29574 | Walter Baring B000141 | rep | NV | 1959-01-07 | 1961-01-03 | Democrat | 0 | |||||||||||||
29564 | 29564 | Wayne Aspinall A000225 | rep | CO | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
29552 | 29552 | George Andrews A000206 | rep | AL | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
29532 | 29532 | Thomas Abernethy A000016 | rep | MS | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
29517 | 29517 | Watkins Abbitt A000002 | rep | VA | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
29493 | 29493 | James Utt U000034 | rep | CA | 1959-01-07 | 1961-01-03 | Republican | 28 | |||||||||||||
29462 | 29462 | Byron Rogers R000389 | rep | CO | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
29452 | 29452 | Lucius Rivers R000280 | rep | SC | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
29429 | 29429 | Adam Powell P000477 | rep | NY | 1959-01-07 | 1961-01-03 | Democrat | 16 | |||||||||||||
29414 | 29414 | Philip Philbin P000303 | rep | MA | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
29392 | 29392 | William Murphy M001104 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
29380 | 29380 | John McCormack M000364 | rep | MA | 1959-01-07 | 1961-01-03 | Democrat | 12 | |||||||||||||
29355 | 29355 | Catherine May M000273 | rep | WA | 1959-01-07 | 1961-01-03 | Republican | 4 | |||||||||||||
29339 | 29339 | Glenard Lipscomb L000344 | rep | CA | 1959-01-07 | 1961-01-03 | Republican | 24 | |||||||||||||
29330 | 29330 | Odin Langen L000069 | rep | MN | 1959-01-07 | 1961-01-03 | Republican | 9 | |||||||||||||
29324 | 29324 | Melvin Laird L000024 | rep | WI | 1959-01-07 | 1961-01-03 | Republican | 7 | |||||||||||||
29313 | 29313 | Michael Kirwan K000244 | rep | OH | 1959-01-07 | 1961-01-03 | Democrat | 19 | |||||||||||||
29286 | 29286 | Jacob Gilbert G000175 | rep | NY | 1959-01-07 | 1961-01-03 | Democrat | 23 | |||||||||||||
29274 | 29274 | Samuel Friedel F000384 | rep | MD | 1959-01-07 | 1961-01-03 | Democrat | 7 | |||||||||||||
29263 | 29263 | Michael Feighan F000060 | rep | OH | 1959-01-07 | 1961-01-03 | Democrat | 20 | |||||||||||||
29249 | 29249 | Leonard Farbstein F000015 | rep | NY | 1959-01-07 | 1961-01-03 | Democrat | 19 | |||||||||||||
29242 | 29242 | George Fallon F000012 | rep | MD | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
29229 | 29229 | Robert Everett E000266 | rep | TN | 1959-01-07 | 1961-01-03 | Democrat | 8 | |||||||||||||
29212 | 29212 | William Dawson D000158 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
29198 | 29198 | Emilio Daddario D000001 | rep | CT | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
29192 | 29192 | Glenn Cunningham C000991 | rep | NE | 1959-01-07 | 1961-01-03 | Republican | 2 | |||||||||||||
29185 | 29185 | William Cramer C000869 | rep | FL | 1959-01-07 | 1961-01-03 | Republican | 1 | |||||||||||||
29175 | 29175 | Jeffery Cohelan C000596 | rep | CA | 1959-01-07 | 1961-01-03 | Democrat | 7 | |||||||||||||
29169 | 29169 | William Cahill C000019 | rep | NJ | 1959-01-07 | 1961-01-03 | Republican | 1 | |||||||||||||
29153 | 29153 | Ellis Berry B000416 | rep | SD | 1959-01-07 | 1961-01-03 | Republican | 2 | |||||||||||||
29134 | 29134 | William Bates B000239 | rep | MA | 1959-01-07 | 1961-01-03 | Republican | 6 | |||||||||||||
29123 | 29123 | William Ayres A000229 | rep | OH | 1959-01-07 | 1961-01-03 | Republican | 14 | |||||||||||||
29107 | 29107 | Edwin Adair A000024 | rep | IN | 1959-01-07 | 1961-01-03 | Republican | 4 | |||||||||||||
29098 | 29098 | Charles Goodell G000282 | rep | NY | 1959-01-07 | 1961-01-03 | Republican | 43 | |||||||||||||
29091 | 29091 | Jesse Younger Y000060 | rep | CA | 1959-01-07 | 1961-01-03 | Republican | 9 |
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);