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 1989-01-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: type, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
39086 | 39086 | Gary Ackerman A000022 | rep | NY | 1987-01-06 | 1989-01-03 | Democrat | 7 | |||||||||||||
39035 | 39035 | Daniel Akaka A000069 | rep | HI | 1987-01-06 | 1989-01-03 | Democrat | 2 | |||||||||||||
34171 | 34171 | William Alexander A000103 | rep | AR | 1987-01-06 | 1989-01-03 | Democrat | 1 | |||||||||||||
34183 | 34183 | Glenn Anderson A000189 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 32 | |||||||||||||
35093 | 35093 | Michael Andrews A000209 | rep | TX | 1987-01-06 | 1989-01-03 | Democrat | 25 | |||||||||||||
34197 | 34197 | Frank Annunzio A000212 | rep | IL | 1987-01-06 | 1989-01-03 | Democrat | 11 | |||||||||||||
34204 | 34204 | Beryl Anthony A000213 | rep | AR | 1987-01-06 | 1989-01-03 | Democrat | 4 | |||||||||||||
35104 | 35104 | Douglas Applegate A000214 | rep | OH | 1987-01-06 | 1989-01-03 | Democrat | 18 | |||||||||||||
36480 | 36480 | Bill Archer A000215 | rep | TX | 1987-01-06 | 1989-01-03 | Republican | 7 | |||||||||||||
36782 | 36782 | Richard Armey A000217 | rep | TX | 1987-01-06 | 1989-01-03 | Republican | 26 | |||||||||||||
35116 | 35116 | Leslie Aspin A000224 | rep | WI | 1987-01-06 | 1989-01-03 | Democrat | 1 | |||||||||||||
34208 | 34208 | Chester Atkins A000226 | rep | MA | 1987-01-06 | 1989-01-03 | Democrat | 5 | |||||||||||||
34217 | 34217 | Les AuCoin A000337 | rep | OR | 1987-01-06 | 1989-01-03 | Democrat | 1 | |||||||||||||
33483 | 33483 | Robert Badham B000024 | rep | CA | 1987-01-06 | 1989-01-03 | Republican | 40 | |||||||||||||
37939 | 37939 | Richard Baker B000072 | rep | LA | 1987-01-06 | 1989-01-03 | Republican | 6 | |||||||||||||
37231 | 37231 | Cass Ballenger B000104 | rep | NC | 1987-01-06 | 1989-01-03 | Republican | 10 | |||||||||||||
34225 | 34225 | Druie Barnard B000153 | rep | GA | 1987-01-06 | 1989-01-03 | Democrat | 10 | |||||||||||||
34230 | 34230 | Harry Bartlett B000204 | rep | TX | 1987-01-06 | 1989-01-03 | Republican | 3 | |||||||||||||
40695 | 40695 | Joe Barton B000213 | rep | TX | 1987-01-06 | 1989-01-03 | Republican | 6 | |||||||||||||
36494 | 36494 | Herbert Bateman B000229 | rep | VA | 1987-01-06 | 1989-01-03 | Republican | 1 | |||||||||||||
33812 | 33812 | Jim Bates B000236 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 44 | |||||||||||||
35688 | 35688 | Anthony Beilenson B000318 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 23 | |||||||||||||
34252 | 34252 | Charles Bennett B000371 | rep | FL | 1987-01-06 | 1989-01-03 | Democrat | 3 | |||||||||||||
35125 | 35125 | Helen Bentley B000392 | rep | MD | 1987-01-06 | 1989-01-03 | Republican | 2 | |||||||||||||
33820 | 33820 | Lloyd Bentsen B000401 | sen | TX | 1983-01-03 | 1989-01-03 | 1 | Democrat | |||||||||||||
37245 | 37245 | Douglas Bereuter B000403 | rep | NE | 1987-01-06 | 1989-01-03 | Republican | 1 | |||||||||||||
39145 | 39145 | Howard Berman B000410 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 26 | |||||||||||||
35703 | 35703 | Tom Bevill B000431 | rep | AL | 1987-01-06 | 1989-01-03 | Democrat | 4 | |||||||||||||
33493 | 33493 | Mario Biaggi B000432 | rep | NY | 1987-01-06 | 1989-01-03 | Democrat | 19 | |||||||||||||
35129 | 35129 | James Bilbray B000462 | rep | NV | 1987-01-06 | 1989-01-03 | Democrat | 1 | |||||||||||||
37522 | 37522 | Michael Bilirakis B000463 | rep | FL | 1987-01-06 | 1989-01-03 | Republican | 9 | |||||||||||||
39041 | 39041 | Jeff Bingaman B000468 | sen | NM | 1983-01-03 | 1989-01-03 | 1 | Democrat | |||||||||||||
34256 | 34256 | Ben Blaz B000551 | rep | GU | 1987-01-06 | 1989-01-03 | Republican | 0 | |||||||||||||
36504 | 36504 | Tom Bliley B000556 | rep | VA | 1987-01-06 | 1989-01-03 | Republican | 3 | |||||||||||||
37534 | 37534 | Sherwood Boehlert B000586 | rep | NY | 1987-01-06 | 1989-01-03 | Republican | 25 | |||||||||||||
33829 | 33829 | Corinne Boggs B000592 | rep | LA | 1987-01-06 | 1989-01-03 | Democrat | 2 | |||||||||||||
33511 | 33511 | Edward Boland B000600 | rep | MA | 1987-01-06 | 1989-01-03 | Democrat | 2 | |||||||||||||
36820 | 36820 | David Bonior B000619 | rep | MI | 1987-01-06 | 1989-01-03 | Democrat | 12 | |||||||||||||
33523 | 33523 | Don Bonker B000620 | rep | WA | 1987-01-06 | 1989-01-03 | Democrat | 3 | |||||||||||||
36830 | 36830 | Robert Borski B000644 | rep | PA | 1987-01-06 | 1989-01-03 | Democrat | 3 | |||||||||||||
33833 | 33833 | Douglas Bosco B000648 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 1 | |||||||||||||
38438 | 38438 | Frederick Boucher B000657 | rep | VA | 1987-01-06 | 1989-01-03 | Democrat | 9 | |||||||||||||
33525 | 33525 | Eldon Boulter B000666 | rep | TX | 1987-01-06 | 1989-01-03 | Republican | 13 | |||||||||||||
40203 | 40203 | Barbara Boxer B000711 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 6 | |||||||||||||
33835 | 33835 | Joseph Brennan B000798 | rep | ME | 1987-01-06 | 1989-01-03 | Democrat | 1 | |||||||||||||
35152 | 35152 | Jack Brooks B000880 | rep | TX | 1987-01-06 | 1989-01-03 | Democrat | 9 | |||||||||||||
34280 | 34280 | William Broomfield B000890 | rep | MI | 1987-01-06 | 1989-01-03 | Republican | 18 | |||||||||||||
36533 | 36533 | George Brown B000918 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 36 | |||||||||||||
34286 | 34286 | George Brown B000919 | rep | CO | 1987-01-06 | 1989-01-03 | Republican | 4 | |||||||||||||
34290 | 34290 | Terry Bruce B000971 | rep | IL | 1987-01-06 | 1989-01-03 | Democrat | 19 | |||||||||||||
35721 | 35721 | John Bryant B000997 | rep | TX | 1987-01-06 | 1989-01-03 | Democrat | 5 | |||||||||||||
33837 | 33837 | John Buechner B001036 | rep | MO | 1987-01-06 | 1989-01-03 | Republican | 2 | |||||||||||||
37561 | 37561 | Jim Bunning B001066 | rep | KY | 1987-01-06 | 1989-01-03 | Republican | 4 | |||||||||||||
33844 | 33844 | Quentin Burdick B001077 | sen | ND | 1983-01-03 | 1989-01-03 | 1 | Democrat | |||||||||||||
39195 | 39195 | Dan Burton B001149 | rep | IN | 1987-01-06 | 1989-01-03 | Republican | 6 | |||||||||||||
34294 | 34294 | Albert Bustamante B001172 | rep | TX | 1987-01-06 | 1989-01-03 | Democrat | 23 | |||||||||||||
37958 | 37958 | Robert Byrd B001210 | sen | WV | 1983-01-03 | 1989-01-03 | 1 | Democrat | |||||||||||||
34301 | 34301 | Beverly Byron B001220 | rep | MD | 1987-01-06 | 1989-01-03 | Democrat | 6 | |||||||||||||
36846 | 36846 | H. Callahan C000052 | rep | AL | 1987-01-06 | 1989-01-03 | Republican | 1 | |||||||||||||
36540 | 36540 | Ben Campbell C000077 | rep | CO | 1987-01-06 | 1989-01-03 | Democrat | 3 | |||||||||||||
41745 | 41745 | Benjamin Cardin C000141 | rep | MD | 1987-01-06 | 1989-01-03 | Democrat | 3 | |||||||||||||
41760 | 41760 | Thomas Carper C000174 | rep | DE | 1987-01-06 | 1989-01-03 | Democrat | 0 | |||||||||||||
35166 | 35166 | Milton Carr C000178 | rep | MI | 1987-01-06 | 1989-01-03 | Democrat | 6 | |||||||||||||
35729 | 35729 | John Chafee C000269 | sen | RI | 1983-01-03 | 1989-01-03 | 1 | Republican | |||||||||||||
34306 | 34306 | Rodney Chandler C000293 | rep | WA | 1987-01-06 | 1989-01-03 | Republican | 8 | |||||||||||||
35733 | 35733 | Jim Chapman C000312 | rep | TX | 1987-01-06 | 1989-01-03 | Democrat | 1 | |||||||||||||
33538 | 33538 | William Chappell C000321 | rep | FL | 1987-01-06 | 1989-01-03 | Democrat | 4 | |||||||||||||
33850 | 33850 | Richard Cheney C000344 | rep | WY | 1987-01-06 | 1989-01-03 | Republican | 0 | |||||||||||||
32921 | 32921 | Lawton Chiles C000356 | sen | FL | 1983-01-03 | 1989-01-03 | 1 | Democrat | |||||||||||||
33853 | 33853 | James Clarke C000462 | rep | NC | 1987-01-06 | 1989-01-03 | Democrat | 11 | |||||||||||||
36566 | 36566 | William Clay C000488 | rep | MO | 1987-01-06 | 1989-01-03 | Democrat | 1 | |||||||||||||
36863 | 36863 | Robert Clement C000503 | rep | TN | 1988-01-19 | 1989-01-03 | Democrat | 5 | |||||||||||||
35743 | 35743 | William Clinger C000523 | rep | PA | 1987-01-06 | 1989-01-03 | Republican | 23 | |||||||||||||
40213 | 40213 | Daniel Coats C000542 | rep | IN | 1987-01-06 | 1989-01-03 | Republican | 4 | |||||||||||||
40132 | 40132 | Howard Coble C000556 | rep | NC | 1987-01-06 | 1989-01-03 | Republican | 6 | |||||||||||||
33859 | 33859 | Anthony Coelho C000581 | rep | CA | 1987-01-06 | 1989-01-03 | Democrat | 15 | |||||||||||||
34321 | 34321 | Earl Coleman C000618 | rep | MO | 1987-01-06 | 1989-01-03 | Republican | 6 | |||||||||||||
35750 | 35750 | Ronald Coleman C000621 | rep | TX | 1987-01-06 | 1989-01-03 | Democrat | 16 | |||||||||||||
35765 | 35765 | Cardiss Collins C000634 | rep | IL | 1987-01-06 | 1989-01-03 | Democrat | 7 | |||||||||||||
37265 | 37265 | Larry Combest C000653 | rep | TX | 1987-01-06 | 1989-01-03 | Republican | 19 | |||||||||||||
34339 | 34339 | Silvio Conte C000709 | rep | MA | 1987-01-06 | 1989-01-03 | Republican | 1 | |||||||||||||
40566 | 40566 | John Conyers C000714 | rep | MI | 1987-01-06 | 1989-01-03 | Democrat | 1 | |||||||||||||
42200 | 42200 | Jim Cooper C000754 | rep | TN | 1987-01-06 | 1989-01-03 | Democrat | 4 | |||||||||||||
39219 | 39219 | Jerry Costello C000794 | rep | IL | 1988-08-09 | 1989-01-03 | Democrat | 21 | |||||||||||||
34351 | 34351 | Robert Coughlin C000807 | rep | PA | 1987-01-06 | 1989-01-03 | Republican | 13 | |||||||||||||
33865 | 33865 | James Courter C000809 | rep | NJ | 1987-01-06 | 1989-01-03 | Republican | 12 | |||||||||||||
36885 | 36885 | William Coyne C000846 | rep | PA | 1987-01-06 | 1989-01-03 | Democrat | 14 | |||||||||||||
37277 | 37277 | Larry Craig C000858 | rep | ID | 1987-01-06 | 1989-01-03 | Republican | 1 | |||||||||||||
37291 | 37291 | Philip Crane C000873 | rep | IL | 1987-01-06 | 1989-01-03 | Republican | 12 | |||||||||||||
33871 | 33871 | George Crockett C000919 | rep | MI | 1987-01-06 | 1989-01-03 | Democrat | 13 | |||||||||||||
33875 | 33875 | John Danforth D000030 | sen | MO | 1983-01-03 | 1989-01-03 | 1 | Republican | |||||||||||||
34359 | 34359 | William Dannemeyer D000044 | rep | CA | 1987-01-06 | 1989-01-03 | Republican | 39 | |||||||||||||
35176 | 35176 | George Darden D000051 | rep | GA | 1987-01-06 | 1989-01-03 | Democrat | 7 | |||||||||||||
33556 | 33556 | Harold Daub D000065 | rep | NE | 1987-01-06 | 1989-01-03 | Republican | 2 | |||||||||||||
33557 | 33557 | Jack Davis D000106 | rep | IL | 1987-01-06 | 1989-01-03 | Republican | 4 | |||||||||||||
34366 | 34366 | Robert Davis D000131 | rep | MI | 1987-01-06 | 1989-01-03 | Republican | 11 | |||||||||||||
33878 | 33878 | Dennis DeConcini D000185 | sen | AZ | 1983-01-03 | 1989-01-03 | 1 | Democrat | |||||||||||||
42266 | 42266 | Peter DeFazio D000191 | rep | OR | 1987-01-06 | 1989-01-03 | Democrat | 4 | |||||||||||||
36127 | 36127 | Eligio de la Garza D000203 | rep | TX | 1987-01-06 | 1989-01-03 | Democrat | 15 | |||||||||||||
35675 | 35675 | Ron de Lugo D000209 | rep | VI | 1987-01-06 | 1989-01-03 | Democrat | 0 |
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);