legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
475 rows where "end" is on date 1993-01-03 sorted by start
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
33456 | 33456 | James Sanford S000055 | sen | NC | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
33477 | 33477 | Brockman Adams A000031 | sen | WA | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
33542 | 33542 | Alan Cranston C000877 | sen | CA | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
33561 | 33561 | Alan Dixon D000366 | sen | IL | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
33583 | 33583 | Wyche Fowler F000329 | sen | GA | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
33587 | 33587 | Edwin Garn G000072 | sen | UT | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
33626 | 33626 | Robert Kasten K000019 | sen | WI | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
33747 | 33747 | Warren Rudman R000497 | sen | NH | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
33790 | 33790 | Steven Symms S001138 | sen | ID | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
33805 | 33805 | Timothy Wirth W000647 | sen | CO | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
35158 | 35158 | Dale Bumpers B001057 | sen | AR | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
35172 | 35172 | Alfonse D’Amato D000018 | sen | NY | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
35197 | 35197 | Robert Dole D000401 | sen | KS | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
35263 | 35263 | Wendell Ford F000268 | sen | KY | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
35288 | 35288 | John Glenn G000236 | sen | OH | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
35491 | 35491 | Robert Packwood P000009 | sen | OR | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
36519 | 36519 | John Breaux B000780 | sen | LA | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
36585 | 36585 | Thomas Daschle D000064 | sen | SD | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
36644 | 36644 | Bob Graham G000352 | sen | FL | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
36653 | 36653 | Ernest Hollings H000725 | sen | SC | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
36717 | 36717 | Frank Murkowski M001085 | sen | AK | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
36721 | 36721 | Don Nickles N000102 | sen | OK | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
37544 | 37544 | Christopher Bond B000611 | sen | MO | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
37608 | 37608 | Christopher Dodd D000388 | sen | CT | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
37884 | 37884 | Arlen Specter S000709 | sen | PA | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
39025 | 39025 | Daniel Inouye I000025 | sen | HI | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
40229 | 40229 | Barbara Mikulski M000702 | sen | MD | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
40236 | 40236 | Harry Reid R000146 | sen | NV | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
40648 | 40648 | John McCain M000303 | sen | AZ | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
42438 | 42438 | Charles Grassley G000386 | sen | IA | 1987-01-06 | 1993-01-03 | 3 | Republican | |||||||||||||
42719 | 42719 | Patrick Leahy L000174 | sen | VT | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
43350 | 43350 | Richard Shelby S000320 | sen | AL | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
40214 | 40214 | Daniel Coats C000542 | sen | IN | 1989-01-03 | 1993-01-03 | 3 | Republican | appointment | ||||||||||||
34173 | 34173 | William Alexander A000103 | rep | AR | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
34185 | 34185 | Glenn Anderson A000189 | rep | CA | 1991-01-03 | 1993-01-03 | Democrat | 32 | |||||||||||||
34199 | 34199 | Frank Annunzio A000212 | rep | IL | 1991-01-03 | 1993-01-03 | Democrat | 11 | |||||||||||||
34206 | 34206 | Beryl Anthony A000213 | rep | AR | 1991-01-03 | 1993-01-03 | Democrat | 4 | |||||||||||||
34210 | 34210 | Chester Atkins A000226 | rep | MA | 1991-01-03 | 1993-01-03 | Democrat | 5 | |||||||||||||
34219 | 34219 | Les AuCoin A000337 | rep | OR | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
34227 | 34227 | Druie Barnard B000153 | rep | GA | 1991-01-03 | 1993-01-03 | Democrat | 10 | |||||||||||||
34254 | 34254 | Charles Bennett B000371 | rep | FL | 1991-01-03 | 1993-01-03 | Democrat | 3 | |||||||||||||
34258 | 34258 | Ben Blaz B000551 | rep | GU | 1991-01-03 | 1993-01-03 | Republican | 0 | |||||||||||||
34282 | 34282 | William Broomfield B000890 | rep | MI | 1991-01-03 | 1993-01-03 | Republican | 18 | |||||||||||||
34292 | 34292 | Terry Bruce B000971 | rep | IL | 1991-01-03 | 1993-01-03 | Democrat | 19 | |||||||||||||
34296 | 34296 | Albert Bustamante B001172 | rep | TX | 1991-01-03 | 1993-01-03 | Democrat | 23 | |||||||||||||
34303 | 34303 | Beverly Byron B001220 | rep | MD | 1991-01-03 | 1993-01-03 | Democrat | 6 | |||||||||||||
34308 | 34308 | Rodney Chandler C000293 | rep | WA | 1991-01-03 | 1993-01-03 | Republican | 8 | |||||||||||||
34323 | 34323 | Earl Coleman C000618 | rep | MO | 1991-01-03 | 1993-01-03 | Republican | 6 | |||||||||||||
34324 | 34324 | Antonio Colorado C000646 | rep | PR | 1991-01-03 | 1993-01-03 | Democrat | 0 | |||||||||||||
34353 | 34353 | Robert Coughlin C000807 | rep | PA | 1991-01-03 | 1993-01-03 | Republican | 13 | |||||||||||||
34354 | 34354 | John Cox C000836 | rep | IL | 1991-01-03 | 1993-01-03 | Democrat | 16 | |||||||||||||
34361 | 34361 | William Dannemeyer D000044 | rep | CA | 1991-01-03 | 1993-01-03 | Republican | 39 | |||||||||||||
34368 | 34368 | Robert Davis D000131 | rep | MI | 1991-01-03 | 1993-01-03 | Republican | 11 | |||||||||||||
34382 | 34382 | William Dickinson D000326 | rep | AL | 1991-01-03 | 1993-01-03 | Republican | 2 | |||||||||||||
34389 | 34389 | Brian Donnelly D000416 | rep | MA | 1991-01-03 | 1993-01-03 | Democrat | 11 | |||||||||||||
34398 | 34398 | Thomas Downey D000471 | rep | NY | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
34404 | 34404 | Bernard Dwyer D000586 | rep | NJ | 1991-01-03 | 1993-01-03 | Democrat | 6 | |||||||||||||
34410 | 34410 | Mervyn Dymally D000592 | rep | CA | 1991-01-03 | 1993-01-03 | Democrat | 31 | |||||||||||||
34419 | 34419 | Joseph Early E000013 | rep | MA | 1991-01-03 | 1993-01-03 | Democrat | 3 | |||||||||||||
34425 | 34425 | Dennis Eckart E000031 | rep | OH | 1991-01-03 | 1993-01-03 | Democrat | 11 | |||||||||||||
34433 | 34433 | Marvin Edwards E000077 | rep | OK | 1991-01-03 | 1993-01-03 | Republican | 5 | |||||||||||||
34438 | 34438 | Ben Erdreich E000201 | rep | AL | 1991-01-03 | 1993-01-03 | Democrat | 6 | |||||||||||||
34460 | 34460 | Dante Fascell F000041 | rep | FL | 1991-01-03 | 1993-01-03 | Democrat | 19 | |||||||||||||
34465 | 34465 | Edward Feighan F000059 | rep | OH | 1991-01-03 | 1993-01-03 | Democrat | 19 | |||||||||||||
34469 | 34469 | Jaime Fuster F000435 | rep | PR | 1991-01-03 | 1993-01-03 | Democrat | 0 | |||||||||||||
34482 | 34482 | Joseph Gaydos G000105 | rep | PA | 1991-01-03 | 1993-01-03 | Democrat | 20 | |||||||||||||
34503 | 34503 | Sedgwick Green G000417 | rep | NY | 1991-01-03 | 1993-01-03 | Republican | 15 | |||||||||||||
34510 | 34510 | Frank Guarini G000511 | rep | NJ | 1991-01-03 | 1993-01-03 | Democrat | 14 | |||||||||||||
34523 | 34523 | John Hammerschmidt H000124 | rep | AR | 1991-01-03 | 1993-01-03 | Republican | 3 | |||||||||||||
34526 | 34526 | Claude Harris H000236 | rep | AL | 1991-01-03 | 1993-01-03 | Democrat | 7 | |||||||||||||
34532 | 34532 | Charles Hatcher H000340 | rep | GA | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
34542 | 34542 | Charles Hayes H000388 | rep | IL | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
34551 | 34551 | Dennis Hertel H000547 | rep | MI | 1991-01-03 | 1993-01-03 | Democrat | 14 | |||||||||||||
34554 | 34554 | Clyde Holloway H000729 | rep | LA | 1991-01-03 | 1993-01-03 | Republican | 8 | |||||||||||||
34561 | 34561 | Larry Hopkins H000776 | rep | KY | 1991-01-03 | 1993-01-03 | Republican | 6 | |||||||||||||
34562 | 34562 | Joan Horn H000788 | rep | MO | 1991-01-03 | 1993-01-03 | Democrat | 2 | |||||||||||||
34577 | 34577 | Frank Horton H000797 | rep | NY | 1991-01-03 | 1993-01-03 | Republican | 29 | |||||||||||||
34586 | 34586 | Carroll Hubbard H000878 | rep | KY | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
34594 | 34594 | Thomas Huckaby H000901 | rep | LA | 1991-01-03 | 1993-01-03 | Democrat | 5 | |||||||||||||
34602 | 34602 | Andrew Ireland I000029 | rep | FL | 1991-01-03 | 1993-01-03 | Republican | 10 | |||||||||||||
34604 | 34604 | Craig James J000047 | rep | FL | 1991-01-03 | 1993-01-03 | Republican | 4 | |||||||||||||
34612 | 34612 | Edgar Jenkins J000083 | rep | GA | 1991-01-03 | 1993-01-03 | Democrat | 9 | |||||||||||||
34619 | 34619 | Ben Jones J000211 | rep | GA | 1991-01-03 | 1993-01-03 | Democrat | 4 | |||||||||||||
34636 | 34636 | James Jontz J000265 | rep | IN | 1991-01-03 | 1993-01-03 | Democrat | 5 | |||||||||||||
34645 | 34645 | Joseph Kolter K000307 | rep | PA | 1991-01-03 | 1993-01-03 | Democrat | 4 | |||||||||||||
34652 | 34652 | Peter Kostmayer K000319 | rep | PA | 1991-01-03 | 1993-01-03 | Democrat | 8 | |||||||||||||
34662 | 34662 | Robert Lagomarsino L000020 | rep | CA | 1991-01-03 | 1993-01-03 | Republican | 19 | |||||||||||||
34672 | 34672 | William Lehman L000226 | rep | FL | 1991-01-03 | 1993-01-03 | Democrat | 17 | |||||||||||||
34683 | 34683 | Norman Lent L000243 | rep | NY | 1991-01-03 | 1993-01-03 | Republican-Conservative | 4 | |||||||||||||
34688 | 34688 | Meldon Levine L000264 | rep | CA | 1991-01-03 | 1993-01-03 | Democrat | 27 | |||||||||||||
34694 | 34694 | William Lowery L000479 | rep | CA | 1991-01-03 | 1993-01-03 | Republican | 41 | |||||||||||||
34695 | 34695 | Charles Luken L000507 | rep | OH | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
34713 | 34713 | Ronald Marlenee M000139 | rep | MT | 1991-01-03 | 1993-01-03 | Republican | 2 | |||||||||||||
34719 | 34719 | David Martin M000174 | rep | NY | 1991-01-03 | 1993-01-03 | Republican | 26 | |||||||||||||
34726 | 34726 | Nicholas Mavroules M000264 | rep | MA | 1991-01-03 | 1993-01-03 | Democrat | 6 | |||||||||||||
34732 | 34732 | Bob McEwen M000432 | rep | OH | 1991-01-03 | 1993-01-03 | Republican | 6 | |||||||||||||
34738 | 34738 | Raymond McGrath M000458 | rep | NY | 1991-01-03 | 1993-01-03 | Republican | 5 | |||||||||||||
34747 | 34747 | Matthew McHugh M000473 | rep | NY | 1991-01-03 | 1993-01-03 | Democrat | 28 | |||||||||||||
34750 | 34750 | Charles McMillen M000573 | rep | MD | 1991-01-03 | 1993-01-03 | Democrat | 4 | |||||||||||||
34763 | 34763 | Clarence Miller M000718 | rep | OH | 1991-01-03 | 1993-01-03 | Republican | 10 |
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);