legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
477 rows where "start" is on date 1985-01-03
This data as json, copyable, CSV (advanced)
Suggested facets: end (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
33224 | 33224 | Joseph Addabbo A000052 | rep | NY | 1985-01-03 | 1987-01-03 | Democrat | 6 | |||||||||||||
33229 | 33229 | William Armstrong A000219 | sen | CO | 1985-01-03 | 1991-01-03 | 2 | Republican | |||||||||||||
33233 | 33233 | Michael Barnes B000160 | rep | MD | 1985-01-03 | 1987-01-03 | Democrat | 8 | |||||||||||||
33239 | 33239 | Berkley Bedell B000298 | rep | IA | 1985-01-03 | 1987-01-03 | Democrat | 6 | |||||||||||||
33242 | 33242 | Rudolph Boschwitz B000647 | sen | MN | 1985-01-03 | 1991-01-03 | 2 | Republican | |||||||||||||
33246 | 33246 | Carroll Campbell C000079 | rep | SC | 1985-01-03 | 1987-01-03 | Republican | 4 | |||||||||||||
33250 | 33250 | William Carney C000165 | rep | NY | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
33253 | 33253 | Eugene Chappie C000322 | rep | CA | 1985-01-03 | 1987-01-03 | Republican | 2 | |||||||||||||
33254 | 33254 | William Cobey C000555 | rep | NC | 1985-01-03 | 1987-01-03 | Republican | 4 | |||||||||||||
33255 | 33255 | Fred Eckert E000033 | rep | NY | 1985-01-03 | 1987-01-03 | Republican | 30 | |||||||||||||
33261 | 33261 | Robert Edgar E000043 | rep | PA | 1985-01-03 | 1987-01-03 | Democrat | 7 | |||||||||||||
33264 | 33264 | Thomas Evans E000259 | rep | IA | 1985-01-03 | 1987-01-03 | Republican | 3 | |||||||||||||
33267 | 33267 | Bobbi Fiedler F000102 | rep | CA | 1985-01-03 | 1987-01-03 | Republican | 21 | |||||||||||||
33269 | 33269 | William Franklin F000347 | rep | MS | 1985-01-03 | 1987-01-03 | Republican | 2 | |||||||||||||
33281 | 33281 | Don Fuqua F000430 | rep | FL | 1985-01-03 | 1987-01-03 | Democrat | 2 | |||||||||||||
33282 | 33282 | John Grotberg G000499 | rep | IL | 1985-01-03 | 1987-01-03 | Republican | 14 | |||||||||||||
33288 | 33288 | Sam Hall H000070 | rep | TX | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
33291 | 33291 | Thomas Hartnett H000302 | rep | SC | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
33296 | 33296 | Cecil Heftel H000449 | rep | HI | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
33298 | 33298 | William Hendon H000490 | rep | NC | 1985-01-03 | 1987-01-03 | Republican | 11 | |||||||||||||
33306 | 33306 | Elwood Hillis H000624 | rep | IN | 1985-01-03 | 1987-01-03 | Republican | 5 | |||||||||||||
33313 | 33313 | Marjorie Holt H000747 | rep | MD | 1985-01-03 | 1987-01-03 | Republican | 4 | |||||||||||||
33315 | 33315 | Gordon Humphrey H000951 | sen | NH | 1985-01-03 | 1990-12-04 | 2 | Republican | |||||||||||||
33322 | 33322 | James Jones J000232 | rep | OK | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
33328 | 33328 | Thomas Kindness K000190 | rep | OH | 1985-01-03 | 1987-01-03 | Republican | 8 | |||||||||||||
33332 | 33332 | Kenneth Kramer K000322 | rep | CO | 1985-01-03 | 1987-01-03 | Republican | 5 | |||||||||||||
33336 | 33336 | Thomas Loeffler L000396 | rep | TX | 1985-01-03 | 1987-01-03 | Republican | 21 | |||||||||||||
33337 | 33337 | Catherine Long L000411 | rep | LA | 1985-01-03 | 1987-01-03 | Democrat | 8 | |||||||||||||
33345 | 33345 | Gillis Long L000417 | rep | LA | 1985-01-03 | 1987-01-03 | Democrat | 8 | |||||||||||||
33351 | 33351 | Stanley Lundine L000516 | rep | NY | 1985-01-03 | 1987-01-03 | Democrat | 34 | |||||||||||||
33357 | 33357 | James McClure M000346 | sen | ID | 1985-01-03 | 1991-01-03 | 2 | Republican | |||||||||||||
33359 | 33359 | John McKernan M000512 | rep | ME | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
33367 | 33367 | Parren Mitchell M000826 | rep | MD | 1985-01-03 | 1987-01-03 | Democrat | 7 | |||||||||||||
33368 | 33368 | David Monson M000860 | rep | UT | 1985-01-03 | 1987-01-03 | Republican | 2 | |||||||||||||
33374 | 33374 | William Moore M000923 | rep | LA | 1985-01-03 | 1987-01-03 | Republican | 6 | |||||||||||||
33381 | 33381 | George O’Brien O000010 | rep | IL | 1985-01-03 | 1987-01-03 | Republican | 4 | |||||||||||||
33398 | 33398 | Thomas O’Neill O000098 | rep | MA | 1985-01-03 | 1987-01-03 | Democrat | 8 | |||||||||||||
33403 | 33403 | Eldon Rudd R000495 | rep | AZ | 1985-01-03 | 1987-01-03 | Republican | 4 | |||||||||||||
33411 | 33411 | John Seiberling S000230 | rep | OH | 1985-01-03 | 1987-01-03 | Democrat | 14 | |||||||||||||
33414 | 33414 | Mark Siljander S000409 | rep | MI | 1985-01-03 | 1987-01-03 | Republican | 4 | |||||||||||||
33425 | 33425 | Marion Snyder S000669 | rep | KY | 1985-01-03 | 1987-01-03 | Republican | 4 | |||||||||||||
33426 | 33426 | Michael Strang S000991 | rep | CO | 1985-01-03 | 1987-01-03 | Republican | 3 | |||||||||||||
33427 | 33427 | Alton Waldon W000038 | rep | NY | 1985-01-03 | 1987-01-03 | Democrat | 6 | |||||||||||||
33433 | 33433 | James Weaver W000227 | rep | OR | 1985-01-03 | 1987-01-03 | Democrat | 4 | |||||||||||||
33442 | 33442 | George Whitehurst W000406 | rep | VA | 1985-01-03 | 1987-01-03 | Republican | 2 | |||||||||||||
33447 | 33447 | Charles Whitley W000419 | rep | NC | 1985-01-03 | 1987-01-03 | Democrat | 3 | |||||||||||||
33452 | 33452 | Robert Young Y000051 | rep | MO | 1985-01-03 | 1987-01-03 | Democrat | 2 | |||||||||||||
33454 | 33454 | Edwin Zschau Z000014 | rep | CA | 1985-01-03 | 1987-01-03 | Republican | 12 | |||||||||||||
33468 | 33468 | James Broyhill B000966 | rep | NC | 1985-01-03 | 1986-07-14 | Republican | 10 | |||||||||||||
33482 | 33482 | Robert Badham B000024 | rep | CA | 1985-01-03 | 1987-01-03 | Republican | 40 | |||||||||||||
33492 | 33492 | Mario Biaggi B000432 | rep | NY | 1985-01-03 | 1987-01-03 | Democrat | 19 | |||||||||||||
33510 | 33510 | Edward Boland B000600 | rep | MA | 1985-01-03 | 1987-01-03 | Democrat | 2 | |||||||||||||
33515 | 33515 | William Boner B000615 | rep | TN | 1985-01-03 | 1987-01-03 | Democrat | 5 | |||||||||||||
33522 | 33522 | Don Bonker B000620 | rep | WA | 1985-01-03 | 1987-01-03 | Democrat | 3 | |||||||||||||
33524 | 33524 | Eldon Boulter B000666 | rep | TX | 1985-01-03 | 1987-01-03 | Republican | 13 | |||||||||||||
33527 | 33527 | Sala Burton B001158 | rep | CA | 1985-01-03 | 1987-01-03 | Democrat | 5 | |||||||||||||
33537 | 33537 | William Chappell C000321 | rep | FL | 1985-01-03 | 1987-01-03 | Democrat | 4 | |||||||||||||
33551 | 33551 | Wilbur Daniel D000038 | rep | VA | 1985-01-03 | 1987-01-03 | Democrat | 5 | |||||||||||||
33555 | 33555 | Harold Daub D000065 | rep | NE | 1985-01-03 | 1987-01-03 | Republican | 2 | |||||||||||||
33558 | 33558 | Joseph DioGuardi D000359 | rep | NY | 1985-01-03 | 1987-01-03 | Republican | 20 | |||||||||||||
33564 | 33564 | Charles Dowdy D000466 | rep | MS | 1985-01-03 | 1987-01-03 | Democrat | 4 | |||||||||||||
33576 | 33576 | John Duncan D000534 | rep | TN | 1985-01-03 | 1987-01-03 | Republican | 2 | |||||||||||||
33582 | 33582 | Wyche Fowler F000329 | rep | GA | 1985-01-03 | 1987-01-03 | Democrat | 5 | |||||||||||||
33598 | 33598 | Kenneth Gray G000400 | rep | IL | 1985-01-03 | 1987-01-03 | Democrat | 22 | |||||||||||||
33610 | 33610 | James Howard H000840 | rep | NJ | 1985-01-03 | 1987-01-03 | Democrat | 3 | |||||||||||||
33620 | 33620 | Ed Jones J000216 | rep | TN | 1985-01-03 | 1987-01-03 | Democrat | 8 | |||||||||||||
33634 | 33634 | Jack Kemp K000086 | rep | NY | 1985-01-03 | 1987-01-03 | Republican | 31 | |||||||||||||
33650 | 33650 | Delbert Latta L000116 | rep | OH | 1985-01-03 | 1987-01-03 | Republican | 5 | |||||||||||||
33655 | 33655 | Michael Lowry L000486 | rep | WA | 1985-01-03 | 1987-01-03 | Democrat | 7 | |||||||||||||
33665 | 33665 | Manuel Luján L000506 | rep | NM | 1985-01-03 | 1987-01-03 | Republican | 1 | |||||||||||||
33668 | 33668 | Kenneth MacKay M000023 | rep | FL | 1985-01-03 | 1987-01-03 | Democrat | 6 | |||||||||||||
33677 | 33677 | Stewart McKinney M000527 | rep | CT | 1985-01-03 | 1987-01-03 | Republican | 4 | |||||||||||||
33682 | 33682 | Daniel Mica M000688 | rep | FL | 1985-01-03 | 1987-01-03 | Democrat | 14 | |||||||||||||
33693 | 33693 | William Nichols N000095 | rep | AL | 1985-01-03 | 1987-01-03 | Democrat | 3 | |||||||||||||
33715 | 33715 | Charles Price P000522 | rep | IL | 1985-01-03 | 1987-01-03 | Democrat | 21 | |||||||||||||
33739 | 33739 | Peter Rodino R000374 | rep | NJ | 1985-01-03 | 1987-01-03 | Democrat | 10 | |||||||||||||
33743 | 33743 | Charles Roemer R000384 | rep | LA | 1985-01-03 | 1987-01-03 | Democrat | 4 | |||||||||||||
33760 | 33760 | Fernand St. Germain S000762 | rep | RI | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
33775 | 33775 | Samuel Stratton S000997 | rep | NY | 1985-01-03 | 1987-01-03 | Democrat | 23 | |||||||||||||
33779 | 33779 | Fofó Sunia S001077 | rep | AS | 1985-01-03 | 1987-01-03 | Democrat | 0 | |||||||||||||
33781 | 33781 | David Sweeney S001101 | rep | TX | 1985-01-03 | 1987-01-03 | Republican | 14 | |||||||||||||
33783 | 33783 | Patrick Swindall S001122 | rep | GA | 1985-01-03 | 1987-01-03 | Republican | 4 | |||||||||||||
33797 | 33797 | Gene Taylor T000075 | rep | MO | 1985-01-03 | 1987-01-03 | Republican | 7 | |||||||||||||
33804 | 33804 | Timothy Wirth W000647 | rep | CO | 1985-01-03 | 1987-01-03 | Democrat | 2 | |||||||||||||
33808 | 33808 | George Wortley W000752 | rep | NY | 1985-01-03 | 1987-01-03 | Republican | 27 | |||||||||||||
33811 | 33811 | Jim Bates B000236 | rep | CA | 1985-01-03 | 1987-01-03 | Democrat | 44 | |||||||||||||
33828 | 33828 | Corinne Boggs B000592 | rep | LA | 1985-01-03 | 1987-01-03 | Democrat | 2 | |||||||||||||
33832 | 33832 | Douglas Bosco B000648 | rep | CA | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
33849 | 33849 | Richard Cheney C000344 | rep | WY | 1985-01-03 | 1987-01-03 | Republican | 0 | |||||||||||||
33858 | 33858 | Anthony Coelho C000581 | rep | CA | 1985-01-03 | 1987-01-03 | Democrat | 15 | |||||||||||||
33864 | 33864 | James Courter C000809 | rep | NJ | 1985-01-03 | 1987-01-03 | Republican | 12 | |||||||||||||
33870 | 33870 | George Crockett C000919 | rep | MI | 1985-01-03 | 1987-01-03 | Democrat | 13 | |||||||||||||
33886 | 33886 | Royden Dyson D000593 | rep | MD | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
33896 | 33896 | Walter Fauntroy F000046 | rep | DC | 1985-01-03 | 1987-01-03 | Democrat | 0 | |||||||||||||
33903 | 33903 | Ronnie Flippo F000208 | rep | AL | 1985-01-03 | 1987-01-03 | Democrat | 5 | |||||||||||||
33911 | 33911 | James Florio F000215 | rep | NJ | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
33921 | 33921 | William Frenzel F000380 | rep | MN | 1985-01-03 | 1987-01-03 | Republican | 3 | |||||||||||||
33928 | 33928 | Robert Garcia G000047 | rep | NY | 1985-01-03 | 1987-01-03 | Democrat | 18 | |||||||||||||
33944 | 33944 | Augustus Hawkins H000367 | rep | CA | 1985-01-03 | 1987-01-03 | Democrat | 29 | |||||||||||||
33955 | 33955 | John Hiler H000586 | rep | IN | 1985-01-03 | 1987-01-03 | Republican | 3 |
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);