legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
274 rows where "end" is on date 1987-01-03 and party = "Democrat"
This data as json, copyable, CSV (advanced)
Suggested facets: start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32614 | 32614 | Thomas Eagleton E000004 | sen | MO | 1981-01-05 | 1987-01-03 | 3 | Democrat | |||||||||||||
32702 | 32702 | Gary Hart H000287 | sen | CO | 1981-01-05 | 1987-01-03 | 3 | Democrat | |||||||||||||
32739 | 32739 | Russell Long L000428 | sen | LA | 1981-01-05 | 1987-01-03 | 3 | Democrat | |||||||||||||
33224 | 33224 | Joseph Addabbo A000052 | rep | NY | 1985-01-03 | 1987-01-03 | Democrat | 6 | |||||||||||||
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 | |||||||||||||
33261 | 33261 | Robert Edgar E000043 | rep | PA | 1985-01-03 | 1987-01-03 | Democrat | 7 | |||||||||||||
33281 | 33281 | Don Fuqua F000430 | rep | FL | 1985-01-03 | 1987-01-03 | Democrat | 2 | |||||||||||||
33288 | 33288 | Sam Hall H000070 | rep | TX | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
33296 | 33296 | Cecil Heftel H000449 | rep | HI | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
33322 | 33322 | James Jones J000232 | rep | OK | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
33367 | 33367 | Parren Mitchell M000826 | rep | MD | 1985-01-03 | 1987-01-03 | Democrat | 7 | |||||||||||||
33398 | 33398 | Thomas O’Neill O000098 | rep | MA | 1985-01-03 | 1987-01-03 | Democrat | 8 | |||||||||||||
33411 | 33411 | John Seiberling S000230 | rep | OH | 1985-01-03 | 1987-01-03 | Democrat | 14 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
33455 | 33455 | James Sanford S000055 | sen | NC | 1986-11-05 | 1987-01-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
33541 | 33541 | Alan Cranston C000877 | sen | CA | 1981-01-05 | 1987-01-03 | 3 | Democrat | |||||||||||||
33551 | 33551 | Wilbur Daniel D000038 | rep | VA | 1985-01-03 | 1987-01-03 | Democrat | 5 | |||||||||||||
33560 | 33560 | Alan Dixon D000366 | sen | IL | 1981-01-05 | 1987-01-03 | 3 | Democrat | |||||||||||||
33564 | 33564 | Charles Dowdy D000466 | rep | MS | 1985-01-03 | 1987-01-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
33655 | 33655 | Michael Lowry L000486 | rep | WA | 1985-01-03 | 1987-01-03 | Democrat | 7 | |||||||||||||
33668 | 33668 | Kenneth MacKay M000023 | rep | FL | 1985-01-03 | 1987-01-03 | Democrat | 6 | |||||||||||||
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 | |||||||||||||
33804 | 33804 | Timothy Wirth W000647 | rep | CO | 1985-01-03 | 1987-01-03 | Democrat | 2 | |||||||||||||
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 | |||||||||||||
33858 | 33858 | Anthony Coelho C000581 | rep | CA | 1985-01-03 | 1987-01-03 | Democrat | 15 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
33971 | 33971 | Robert Kastenmeier K000020 | rep | WI | 1985-01-03 | 1987-01-03 | Democrat | 2 | |||||||||||||
33977 | 33977 | James Leath L000180 | rep | TX | 1985-01-03 | 1987-01-03 | Democrat | 11 | |||||||||||||
33983 | 33983 | George Leland L000237 | rep | TX | 1985-01-03 | 1987-01-03 | Democrat | 18 | |||||||||||||
33991 | 33991 | Thomas Luken L000508 | rep | OH | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
34027 | 34027 | Bruce Morrison M000992 | rep | CT | 1985-01-03 | 1987-01-03 | Democrat | 3 | |||||||||||||
34060 | 34060 | Claude Pepper P000218 | rep | FL | 1985-01-03 | 1987-01-03 | Democrat | 18 | |||||||||||||
34071 | 34071 | Tommy Robinson R000354 | rep | AR | 1985-01-03 | 1987-01-03 | Democrat | 2 | |||||||||||||
34128 | 34128 | Douglas Walgren W000044 | rep | PA | 1985-01-03 | 1987-01-03 | Democrat | 18 | |||||||||||||
34157 | 34157 | James Wright W000763 | rep | TX | 1985-01-03 | 1987-01-03 | Democrat | 12 | |||||||||||||
34170 | 34170 | William Alexander A000103 | rep | AR | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
34182 | 34182 | Glenn Anderson A000189 | rep | CA | 1985-01-03 | 1987-01-03 | Democrat | 32 | |||||||||||||
34196 | 34196 | Frank Annunzio A000212 | rep | IL | 1985-01-03 | 1987-01-03 | Democrat | 11 | |||||||||||||
34203 | 34203 | Beryl Anthony A000213 | rep | AR | 1985-01-03 | 1987-01-03 | Democrat | 4 | |||||||||||||
34207 | 34207 | Chester Atkins A000226 | rep | MA | 1985-01-03 | 1987-01-03 | Democrat | 5 | |||||||||||||
34216 | 34216 | Les AuCoin A000337 | rep | OR | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
34224 | 34224 | Druie Barnard B000153 | rep | GA | 1985-01-03 | 1987-01-03 | Democrat | 10 | |||||||||||||
34251 | 34251 | Charles Bennett B000371 | rep | FL | 1985-01-03 | 1987-01-03 | Democrat | 3 | |||||||||||||
34289 | 34289 | Terry Bruce B000971 | rep | IL | 1985-01-03 | 1987-01-03 | Democrat | 19 | |||||||||||||
34293 | 34293 | Albert Bustamante B001172 | rep | TX | 1985-01-03 | 1987-01-03 | Democrat | 23 | |||||||||||||
34300 | 34300 | Beverly Byron B001220 | rep | MD | 1985-01-03 | 1987-01-03 | Democrat | 6 | |||||||||||||
34386 | 34386 | Brian Donnelly D000416 | rep | MA | 1985-01-03 | 1987-01-03 | Democrat | 11 | |||||||||||||
34395 | 34395 | Thomas Downey D000471 | rep | NY | 1985-01-03 | 1987-01-03 | Democrat | 2 | |||||||||||||
34401 | 34401 | Bernard Dwyer D000586 | rep | NJ | 1985-01-03 | 1987-01-03 | Democrat | 6 | |||||||||||||
34407 | 34407 | Mervyn Dymally D000592 | rep | CA | 1985-01-03 | 1987-01-03 | Democrat | 31 | |||||||||||||
34416 | 34416 | Joseph Early E000013 | rep | MA | 1985-01-03 | 1987-01-03 | Democrat | 3 | |||||||||||||
34422 | 34422 | Dennis Eckart E000031 | rep | OH | 1985-01-03 | 1987-01-03 | Democrat | 11 | |||||||||||||
34435 | 34435 | Ben Erdreich E000201 | rep | AL | 1985-01-03 | 1987-01-03 | Democrat | 6 | |||||||||||||
34457 | 34457 | Dante Fascell F000041 | rep | FL | 1985-01-03 | 1987-01-03 | Democrat | 19 | |||||||||||||
34462 | 34462 | Edward Feighan F000059 | rep | OH | 1985-01-03 | 1987-01-03 | Democrat | 19 | |||||||||||||
34466 | 34466 | Jaime Fuster F000435 | rep | PR | 1985-01-03 | 1987-01-03 | Democrat | 0 | |||||||||||||
34479 | 34479 | Joseph Gaydos G000105 | rep | PA | 1985-01-03 | 1987-01-03 | Democrat | 20 | |||||||||||||
34492 | 34492 | William Gray G000402 | rep | PA | 1985-01-03 | 1987-01-03 | Democrat | 2 | |||||||||||||
34507 | 34507 | Frank Guarini G000511 | rep | NJ | 1985-01-03 | 1987-01-03 | Democrat | 14 | |||||||||||||
34529 | 34529 | Charles Hatcher H000340 | rep | GA | 1985-01-03 | 1987-01-03 | Democrat | 2 | |||||||||||||
34539 | 34539 | Charles Hayes H000388 | rep | IL | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
34548 | 34548 | Dennis Hertel H000547 | rep | MI | 1985-01-03 | 1987-01-03 | Democrat | 14 | |||||||||||||
34583 | 34583 | Carroll Hubbard H000878 | rep | KY | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
34591 | 34591 | Thomas Huckaby H000901 | rep | LA | 1985-01-03 | 1987-01-03 | Democrat | 5 | |||||||||||||
34609 | 34609 | Edgar Jenkins J000083 | rep | GA | 1985-01-03 | 1987-01-03 | Democrat | 9 | |||||||||||||
34630 | 34630 | Walter Jones J000256 | rep | NC | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
34642 | 34642 | Joseph Kolter K000307 | rep | PA | 1985-01-03 | 1987-01-03 | Democrat | 4 | |||||||||||||
34649 | 34649 | Peter Kostmayer K000319 | rep | PA | 1985-01-03 | 1987-01-03 | Democrat | 8 |
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);