legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
481 rows where "start" is on date 1989-01-03 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: class
end (date) 17 ✖
- 1991-01-03 437
- 1995-01-03 28
- 1991-12-31 2
- 1989-05-30 1
- 1989-06-15 1
- 1989-06-30 1
- 1989-08-07 1
- 1989-08-13 1
- 1989-12-31 1
- 1990-01-07 1
- 1990-01-16 1
- 1990-03-17 1
- 1990-05-15 1
- 1990-12-07 1
- 1992-09-08 1
- 1993-01-03 1
- 1993-12-31 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
33813 | 33813 | Jim Bates B000236 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 44 | |||||||||||||
33821 | 33821 | Lloyd Bentsen B000401 | sen | TX | 1989-01-03 | 1993-12-31 | 1 | Democrat | |||||||||||||
33830 | 33830 | Corinne Boggs B000592 | rep | LA | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
33834 | 33834 | Douglas Bosco B000648 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
33836 | 33836 | Joseph Brennan B000798 | rep | ME | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
33845 | 33845 | Quentin Burdick B001077 | sen | ND | 1989-01-03 | 1992-09-08 | 1 | Democrat | |||||||||||||
33854 | 33854 | James Clarke C000462 | rep | NC | 1989-01-03 | 1991-01-03 | Democrat | 11 | |||||||||||||
33860 | 33860 | Anthony Coelho C000581 | rep | CA | 1989-01-03 | 1989-06-15 | Democrat | 15 | |||||||||||||
33872 | 33872 | George Crockett C000919 | rep | MI | 1989-01-03 | 1991-01-03 | Democrat | 13 | |||||||||||||
33879 | 33879 | Dennis DeConcini D000185 | sen | AZ | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
33888 | 33888 | Royden Dyson D000593 | rep | MD | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
33898 | 33898 | Walter Fauntroy F000046 | rep | DC | 1989-01-03 | 1991-01-03 | Democrat | 0 | |||||||||||||
33905 | 33905 | Ronnie Flippo F000208 | rep | AL | 1989-01-03 | 1991-01-03 | Democrat | 5 | |||||||||||||
33913 | 33913 | James Florio F000215 | rep | NJ | 1989-01-03 | 1990-01-16 | Democrat | 1 | |||||||||||||
33930 | 33930 | Robert Garcia G000047 | rep | NY | 1989-01-03 | 1990-01-07 | Democrat | 18 | |||||||||||||
33946 | 33946 | Augustus Hawkins H000367 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 29 | |||||||||||||
33973 | 33973 | Robert Kastenmeier K000020 | rep | WI | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
33979 | 33979 | James Leath L000180 | rep | TX | 1989-01-03 | 1991-01-03 | Democrat | 11 | |||||||||||||
33985 | 33985 | George Leland L000237 | rep | TX | 1989-01-03 | 1989-08-07 | Democrat | 18 | |||||||||||||
33993 | 33993 | Thomas Luken L000508 | rep | OH | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
34012 | 34012 | Spark Matsunaga M000250 | sen | HI | 1989-01-03 | 1991-01-03 | 1 | Democrat | |||||||||||||
34017 | 34017 | Howard Metzenbaum M000678 | sen | OH | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
34020 | 34020 | George Mitchell M000811 | sen | ME | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
34029 | 34029 | Bruce Morrison M000992 | rep | CT | 1989-01-03 | 1991-01-03 | Democrat | 3 | |||||||||||||
34062 | 34062 | Claude Pepper P000218 | rep | FL | 1989-01-03 | 1989-05-30 | Democrat | 18 | |||||||||||||
34070 | 34070 | Donald Riegle R000249 | sen | MI | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
34081 | 34081 | James Sasser S000068 | sen | TN | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
34130 | 34130 | Douglas Walgren W000044 | rep | PA | 1989-01-03 | 1991-01-03 | Democrat | 18 | |||||||||||||
34159 | 34159 | James Wright W000763 | rep | TX | 1989-01-03 | 1989-06-30 | Democrat | 12 | |||||||||||||
34172 | 34172 | William Alexander A000103 | rep | AR | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
34184 | 34184 | Glenn Anderson A000189 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 32 | |||||||||||||
34198 | 34198 | Frank Annunzio A000212 | rep | IL | 1989-01-03 | 1991-01-03 | Democrat | 11 | |||||||||||||
34205 | 34205 | Beryl Anthony A000213 | rep | AR | 1989-01-03 | 1991-01-03 | Democrat | 4 | |||||||||||||
34209 | 34209 | Chester Atkins A000226 | rep | MA | 1989-01-03 | 1991-01-03 | Democrat | 5 | |||||||||||||
34218 | 34218 | Les AuCoin A000337 | rep | OR | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
34226 | 34226 | Druie Barnard B000153 | rep | GA | 1989-01-03 | 1991-01-03 | Democrat | 10 | |||||||||||||
34253 | 34253 | Charles Bennett B000371 | rep | FL | 1989-01-03 | 1991-01-03 | Democrat | 3 | |||||||||||||
34291 | 34291 | Terry Bruce B000971 | rep | IL | 1989-01-03 | 1991-01-03 | Democrat | 19 | |||||||||||||
34295 | 34295 | Albert Bustamante B001172 | rep | TX | 1989-01-03 | 1991-01-03 | Democrat | 23 | |||||||||||||
34302 | 34302 | Beverly Byron B001220 | rep | MD | 1989-01-03 | 1991-01-03 | Democrat | 6 | |||||||||||||
34388 | 34388 | Brian Donnelly D000416 | rep | MA | 1989-01-03 | 1991-01-03 | Democrat | 11 | |||||||||||||
34397 | 34397 | Thomas Downey D000471 | rep | NY | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
34403 | 34403 | Bernard Dwyer D000586 | rep | NJ | 1989-01-03 | 1991-01-03 | Democrat | 6 | |||||||||||||
34409 | 34409 | Mervyn Dymally D000592 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 31 | |||||||||||||
34418 | 34418 | Joseph Early E000013 | rep | MA | 1989-01-03 | 1991-01-03 | Democrat | 3 | |||||||||||||
34424 | 34424 | Dennis Eckart E000031 | rep | OH | 1989-01-03 | 1991-01-03 | Democrat | 11 | |||||||||||||
34437 | 34437 | Ben Erdreich E000201 | rep | AL | 1989-01-03 | 1991-01-03 | Democrat | 6 | |||||||||||||
34459 | 34459 | Dante Fascell F000041 | rep | FL | 1989-01-03 | 1991-01-03 | Democrat | 19 | |||||||||||||
34464 | 34464 | Edward Feighan F000059 | rep | OH | 1989-01-03 | 1991-01-03 | Democrat | 19 | |||||||||||||
34468 | 34468 | Jaime Fuster F000435 | rep | PR | 1989-01-03 | 1991-01-03 | Democrat | 0 | |||||||||||||
34481 | 34481 | Joseph Gaydos G000105 | rep | PA | 1989-01-03 | 1991-01-03 | Democrat | 20 | |||||||||||||
34494 | 34494 | William Gray G000402 | rep | PA | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
34509 | 34509 | Frank Guarini G000511 | rep | NJ | 1989-01-03 | 1991-01-03 | Democrat | 14 | |||||||||||||
34525 | 34525 | Claude Harris H000236 | rep | AL | 1989-01-03 | 1991-01-03 | Democrat | 7 | |||||||||||||
34531 | 34531 | Charles Hatcher H000340 | rep | GA | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
34541 | 34541 | Charles Hayes H000388 | rep | IL | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
34550 | 34550 | Dennis Hertel H000547 | rep | MI | 1989-01-03 | 1991-01-03 | Democrat | 14 | |||||||||||||
34585 | 34585 | Carroll Hubbard H000878 | rep | KY | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
34593 | 34593 | Thomas Huckaby H000901 | rep | LA | 1989-01-03 | 1991-01-03 | Democrat | 5 | |||||||||||||
34611 | 34611 | Edgar Jenkins J000083 | rep | GA | 1989-01-03 | 1991-01-03 | Democrat | 9 | |||||||||||||
34618 | 34618 | Ben Jones J000211 | rep | GA | 1989-01-03 | 1991-01-03 | Democrat | 4 | |||||||||||||
34632 | 34632 | Walter Jones J000256 | rep | NC | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
34635 | 34635 | James Jontz J000265 | rep | IN | 1989-01-03 | 1991-01-03 | Democrat | 5 | |||||||||||||
34644 | 34644 | Joseph Kolter K000307 | rep | PA | 1989-01-03 | 1991-01-03 | Democrat | 4 | |||||||||||||
34651 | 34651 | Peter Kostmayer K000319 | rep | PA | 1989-01-03 | 1991-01-03 | Democrat | 8 | |||||||||||||
34671 | 34671 | William Lehman L000226 | rep | FL | 1989-01-03 | 1991-01-03 | Democrat | 17 | |||||||||||||
34687 | 34687 | Meldon Levine L000264 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 27 | |||||||||||||
34725 | 34725 | Nicholas Mavroules M000264 | rep | MA | 1989-01-03 | 1991-01-03 | Democrat | 6 | |||||||||||||
34746 | 34746 | Matthew McHugh M000473 | rep | NY | 1989-01-03 | 1991-01-03 | Democrat | 28 | |||||||||||||
34749 | 34749 | Charles McMillen M000573 | rep | MD | 1989-01-03 | 1991-01-03 | Democrat | 4 | |||||||||||||
34771 | 34771 | Jim Moody M000881 | rep | WI | 1989-01-03 | 1991-01-03 | Democrat | 5 | |||||||||||||
34782 | 34782 | Robert Mrazek M001057 | rep | NY | 1989-01-03 | 1991-01-03 | Democrat | 3 | |||||||||||||
34785 | 34785 | David Nagle N000003 | rep | IA | 1989-01-03 | 1991-01-03 | Democrat | 3 | |||||||||||||
34795 | 34795 | Henry Nowak N000163 | rep | NY | 1989-01-03 | 1991-01-03 | Democrat | 33 | |||||||||||||
34808 | 34808 | Mary Oakar O000001 | rep | OH | 1989-01-03 | 1991-01-03 | Democrat | 20 | |||||||||||||
34813 | 34813 | James Olin O000069 | rep | VA | 1989-01-03 | 1991-01-03 | Democrat | 6 | |||||||||||||
34817 | 34817 | Douglas Owens O000156 | rep | UT | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
34820 | 34820 | Elizabeth Patterson P000112 | rep | SC | 1989-01-03 | 1991-01-03 | Democrat | 4 | |||||||||||||
34828 | 34828 | Donald Pease P000170 | rep | OH | 1989-01-03 | 1991-01-03 | Democrat | 13 | |||||||||||||
34839 | 34839 | Carl Perkins P000229 | rep | KY | 1989-01-03 | 1991-01-03 | Democrat | 7 | |||||||||||||
34864 | 34864 | Richard Ray R000080 | rep | GA | 1989-01-03 | 1991-01-03 | Democrat | 3 | |||||||||||||
34896 | 34896 | Robert Roe R000383 | rep | NJ | 1989-01-03 | 1991-01-03 | Democrat | 8 | |||||||||||||
34911 | 34911 | Edward Roybal R000485 | rep | CA | 1989-01-03 | 1991-01-03 | Democrat | 25 | |||||||||||||
34920 | 34920 | Martin Russo R000543 | rep | IL | 1989-01-03 | 1991-01-03 | Democrat | 3 | |||||||||||||
34926 | 34926 | Gus Savage S000081 | rep | IL | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
34939 | 34939 | James Scheuer S000124 | rep | NY | 1989-01-03 | 1991-01-03 | Democrat | 8 | |||||||||||||
34954 | 34954 | Gerald Sikorski S000407 | rep | MN | 1989-01-03 | 1991-01-03 | Democrat | 6 | |||||||||||||
34973 | 34973 | Lawrence Smith S000586 | rep | FL | 1989-01-03 | 1991-01-03 | Democrat | 16 | |||||||||||||
34982 | 34982 | Stephen Solarz S000673 | rep | NY | 1989-01-03 | 1991-01-03 | Democrat | 13 | |||||||||||||
34987 | 34987 | Harley Staggers S000779 | rep | WV | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
34991 | 34991 | Richard Stallings S000785 | rep | ID | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
34996 | 34996 | Robert Tallon T000034 | rep | SC | 1989-01-03 | 1991-01-03 | Democrat | 6 | |||||||||||||
35001 | 35001 | Robert Thomas T000184 | rep | GA | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
35011 | 35011 | Jerome Traxler T000356 | rep | MI | 1989-01-03 | 1991-01-03 | Democrat | 8 | |||||||||||||
35027 | 35027 | Morris Udall U000001 | rep | AZ | 1989-01-03 | 1991-01-03 | Democrat | 2 | |||||||||||||
35055 | 35055 | Theodore Weiss W000258 | rep | NY | 1989-01-03 | 1991-01-03 | Democrat | 17 | |||||||||||||
35063 | 35063 | Howard Wolpe W000682 | rep | MI | 1989-01-03 | 1991-01-03 | Democrat | 3 | |||||||||||||
35088 | 35088 | Gus Yatron Y000014 | rep | PA | 1989-01-03 | 1991-01-03 | Democrat | 6 | |||||||||||||
35094 | 35094 | Michael Andrews A000209 | rep | TX | 1989-01-03 | 1991-01-03 | Democrat | 25 | |||||||||||||
35105 | 35105 | Douglas Applegate A000214 | rep | OH | 1989-01-03 | 1991-01-03 | Democrat | 18 |
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);