legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
473 rows where "end" is on date 1999-01-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, district
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38398 | 38398 | Neil Abercrombie A000014 | rep | HI | 1997-01-07 | 1999-01-03 | Democrat | 1 | |||||||||||||
39091 | 39091 | Gary Ackerman A000022 | rep | NY | 1997-01-07 | 1999-01-03 | Democrat | 5 | |||||||||||||
41904 | 41904 | Robert Aderholt A000055 | rep | AL | 1997-01-07 | 1999-01-03 | Republican | 4 | |||||||||||||
39670 | 39670 | Robert Andrews A000210 | rep | NJ | 1997-01-07 | 1999-01-03 | Democrat | 1 | |||||||||||||
36485 | 36485 | Bill Archer A000215 | rep | TX | 1997-01-07 | 1999-01-03 | Republican | 7 | |||||||||||||
36787 | 36787 | Richard Armey A000217 | rep | TX | 1997-01-07 | 1999-01-03 | Republican | 26 | |||||||||||||
37933 | 37933 | Thomas Allen A000357 | rep | ME | 1997-01-07 | 1999-01-03 | Democrat | 1 | |||||||||||||
39740 | 39740 | Spencer Bachus B000013 | rep | AL | 1997-01-07 | 1999-01-03 | Republican | 6 | |||||||||||||
36135 | 36135 | Henry Baesler B000028 | rep | KY | 1997-01-07 | 1999-01-03 | Democrat | 6 | |||||||||||||
37944 | 37944 | Richard Baker B000072 | rep | LA | 1997-01-07 | 1999-01-03 | Republican | 6 | |||||||||||||
36791 | 36791 | John Baldacci B000081 | rep | ME | 1997-01-07 | 1999-01-03 | Democrat | 2 | |||||||||||||
37236 | 37236 | Cass Ballenger B000104 | rep | NC | 1997-01-07 | 1999-01-03 | Republican | 10 | |||||||||||||
36796 | 36796 | James Barcia B000134 | rep | MI | 1997-01-07 | 1999-01-03 | Democrat | 5 | |||||||||||||
36800 | 36800 | Bob Barr B000169 | rep | GA | 1997-01-07 | 1999-01-03 | Republican | 7 | |||||||||||||
36805 | 36805 | Thomas Barrett B000177 | rep | WI | 1997-01-07 | 1999-01-03 | Democrat | 5 | |||||||||||||
36490 | 36490 | Bill Barrett B000179 | rep | NE | 1997-01-07 | 1999-01-03 | Republican | 3 | |||||||||||||
39120 | 39120 | Roscoe Bartlett B000208 | rep | MD | 1997-01-07 | 1999-01-03 | Republican | 6 | |||||||||||||
40700 | 40700 | Joe Barton B000213 | rep | TX | 1997-01-07 | 1999-01-03 | Republican | 6 | |||||||||||||
39129 | 39129 | Charles Bass B000220 | rep | NH | 1997-01-07 | 1999-01-03 | Republican | 2 | |||||||||||||
36499 | 36499 | Herbert Bateman B000229 | rep | VA | 1997-01-07 | 1999-01-03 | Republican | 1 | |||||||||||||
40514 | 40514 | Xavier Becerra B000287 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 30 | |||||||||||||
37517 | 37517 | Robert Bennett B000382 | sen | UT | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
36809 | 36809 | Ken Bentsen B000400 | rep | TX | 1997-01-07 | 1999-01-03 | Democrat | 25 | |||||||||||||
37250 | 37250 | Douglas Bereuter B000403 | rep | NE | 1997-01-07 | 1999-01-03 | Republican | 1 | |||||||||||||
39150 | 39150 | Howard Berman B000410 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 26 | |||||||||||||
38421 | 38421 | Robert Berry B000420 | rep | AR | 1997-01-07 | 1999-01-03 | Democrat | 1 | |||||||||||||
39166 | 39166 | Brian Bilbray B000461 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 49 | |||||||||||||
37527 | 37527 | Michael Bilirakis B000463 | rep | FL | 1997-01-07 | 1999-01-03 | Republican | 9 | |||||||||||||
41945 | 41945 | Sanford Bishop B000490 | rep | GA | 1997-01-07 | 1999-01-03 | Democrat | 2 | |||||||||||||
36812 | 36812 | Rod Blagojevich B000518 | rep | IL | 1997-01-07 | 1999-01-03 | Democrat | 5 | |||||||||||||
36509 | 36509 | Tom Bliley B000556 | rep | VA | 1997-01-07 | 1999-01-03 | Republican | 7 | |||||||||||||
41968 | 41968 | Earl Blumenauer B000574 | rep | OR | 1997-01-07 | 1999-01-03 | Democrat | 3 | |||||||||||||
41983 | 41983 | Roy Blunt B000575 | rep | MO | 1997-01-07 | 1999-01-03 | Republican | 7 | |||||||||||||
37539 | 37539 | Sherwood Boehlert B000586 | rep | NY | 1997-01-07 | 1999-01-03 | Republican | 23 | |||||||||||||
40157 | 40157 | John Boehner B000589 | rep | OH | 1997-01-07 | 1999-01-03 | Republican | 8 | |||||||||||||
37545 | 37545 | Christopher Bond B000611 | sen | MO | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
37550 | 37550 | Henry Bonilla B000617 | rep | TX | 1997-01-07 | 1999-01-03 | Republican | 23 | |||||||||||||
36825 | 36825 | David Bonior B000619 | rep | MI | 1997-01-07 | 1999-01-03 | Democrat | 10 | |||||||||||||
36835 | 36835 | Robert Borski B000644 | rep | PA | 1997-01-07 | 1999-01-03 | Democrat | 3 | |||||||||||||
39184 | 39184 | Leonard Boswell B000652 | rep | IA | 1997-01-07 | 1999-01-03 | Democrat | 3 | |||||||||||||
38443 | 38443 | Frederick Boucher B000657 | rep | VA | 1997-01-07 | 1999-01-03 | Democrat | 9 | |||||||||||||
40206 | 40206 | Barbara Boxer B000711 | sen | CA | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
38450 | 38450 | Allen Boyd B000716 | rep | FL | 1997-01-07 | 1999-01-03 | Democrat | 2 | |||||||||||||
41999 | 41999 | Kevin Brady B000755 | rep | TX | 1997-01-07 | 1999-01-03 | Republican | 8 | |||||||||||||
36520 | 36520 | John Breaux B000780 | sen | LA | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
40257 | 40257 | Corrine Brown B000911 | rep | FL | 1997-01-07 | 1999-01-03 | Democrat | 3 | |||||||||||||
36538 | 36538 | George Brown B000918 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 42 | |||||||||||||
41732 | 41732 | Sherrod Brown B000944 | rep | OH | 1997-01-07 | 1999-01-03 | Democrat | 13 | |||||||||||||
37558 | 37558 | Samuel Brownback B000953 | sen | KS | 1996-11-07 | 1999-01-03 | 3 | Republican | |||||||||||||
36839 | 36839 | Ed Bryant B000996 | rep | TN | 1997-01-07 | 1999-01-03 | Republican | 7 | |||||||||||||
35159 | 35159 | Dale Bumpers B001057 | sen | AR | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
37566 | 37566 | Jim Bunning B001066 | rep | KY | 1997-01-07 | 1999-01-03 | Republican | 4 | |||||||||||||
42043 | 42043 | Richard Burr B001135 | rep | NC | 1997-01-07 | 1999-01-03 | Republican | 5 | |||||||||||||
39200 | 39200 | Dan Burton B001149 | rep | IN | 1997-01-07 | 1999-01-03 | Republican | 6 | |||||||||||||
38469 | 38469 | Stephen Buyer B001203 | rep | IN | 1997-01-07 | 1999-01-03 | Republican | 5 | |||||||||||||
40723 | 40723 | Robert Brady B001227 | rep | PA | 1998-05-19 | 1999-01-03 | Democrat | 1 | |||||||||||||
39172 | 39172 | Mary Bono Mack B001228 | rep | CA | 1998-04-07 | 1999-01-03 | Republican | 44 | |||||||||||||
36851 | 36851 | H. Callahan C000052 | rep | AL | 1997-01-07 | 1999-01-03 | Republican | 1 | |||||||||||||
42062 | 42062 | Ken Calvert C000059 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 43 | |||||||||||||
39771 | 39771 | Dave Camp C000071 | rep | MI | 1997-01-07 | 1999-01-03 | Republican | 4 | |||||||||||||
36543 | 36543 | Ben Campbell C000077 | sen | CO | 1993-01-05 | 1999-01-03 | 3 | Republican | [ { "start": "1993-01-05", "end": "1995-03-03", "party": "Democrat" }, { "start": "1995-03-03", "end": "1999-01-03", "party": "Republican" } ] |
||||||||||||
36548 | 36548 | Tom Campbell C000100 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 15 | |||||||||||||
36552 | 36552 | Charles Canady C000107 | rep | FL | 1997-01-07 | 1999-01-03 | Republican | 12 | |||||||||||||
37963 | 37963 | Christopher Cannon C000116 | rep | UT | 1997-01-07 | 1999-01-03 | Republican | 3 | |||||||||||||
41750 | 41750 | Benjamin Cardin C000141 | rep | MD | 1997-01-07 | 1999-01-03 | Democrat | 3 | |||||||||||||
37969 | 37969 | Julia Carson C000191 | rep | IN | 1997-01-07 | 1999-01-03 | Democrat | 10 | |||||||||||||
38481 | 38481 | Michael Castle C000243 | rep | DE | 1997-01-07 | 1999-01-03 | Republican | 0 | |||||||||||||
42116 | 42116 | Steve Chabot C000266 | rep | OH | 1997-01-07 | 1999-01-03 | Republican | 1 | |||||||||||||
39688 | 39688 | Saxby Chambliss C000286 | rep | GA | 1997-01-07 | 1999-01-03 | Republican | 8 | |||||||||||||
36555 | 36555 | Helen Chenoweth-Hage C000345 | rep | ID | 1997-01-07 | 1999-01-03 | Republican | 1 | |||||||||||||
36140 | 36140 | Jon Christensen C000377 | rep | NE | 1997-01-07 | 1999-01-03 | Republican | 2 | |||||||||||||
39785 | 39785 | Donna Christensen C000380 | rep | VI | 1997-01-07 | 1999-01-03 | Democrat | 0 | |||||||||||||
36571 | 36571 | William Clay C000488 | rep | MO | 1997-01-07 | 1999-01-03 | Democrat | 1 | |||||||||||||
36860 | 36860 | Eva Clayton C000494 | rep | NC | 1997-01-07 | 1999-01-03 | Democrat | 1 | |||||||||||||
36868 | 36868 | Robert Clement C000503 | rep | TN | 1997-01-07 | 1999-01-03 | Democrat | 5 | |||||||||||||
42160 | 42160 | James Clyburn C000537 | rep | SC | 1997-01-07 | 1999-01-03 | Democrat | 6 | |||||||||||||
40215 | 40215 | Daniel Coats C000542 | sen | IN | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
40137 | 40137 | Howard Coble C000556 | rep | NC | 1997-01-07 | 1999-01-03 | Republican | 6 | |||||||||||||
39795 | 39795 | Thomas Coburn C000560 | rep | OK | 1997-01-07 | 1999-01-03 | Republican | 2 | |||||||||||||
37260 | 37260 | Michael Collins C000640 | rep | GA | 1997-01-07 | 1999-01-03 | Republican | 3 | |||||||||||||
37270 | 37270 | Larry Combest C000653 | rep | TX | 1997-01-07 | 1999-01-03 | Republican | 19 | |||||||||||||
36875 | 36875 | Gary Condit C000670 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 18 | |||||||||||||
40571 | 40571 | John Conyers C000714 | rep | MI | 1997-01-07 | 1999-01-03 | Democrat | 14 | |||||||||||||
36573 | 36573 | Merrill Cook C000722 | rep | UT | 1997-01-07 | 1999-01-03 | Republican | 2 | |||||||||||||
36878 | 36878 | John Cooksey C000735 | rep | LA | 1997-01-07 | 1999-01-03 | Republican | 5 | |||||||||||||
39224 | 39224 | Jerry Costello C000794 | rep | IL | 1997-01-07 | 1999-01-03 | Democrat | 12 | |||||||||||||
36575 | 36575 | Paul Coverdell C000813 | sen | GA | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
37575 | 37575 | C. Cox C000830 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 47 | |||||||||||||
36890 | 36890 | William Coyne C000846 | rep | PA | 1997-01-07 | 1999-01-03 | Democrat | 14 | |||||||||||||
37980 | 37980 | Robert Cramer C000868 | rep | AL | 1997-01-07 | 1999-01-03 | Democrat | 5 | |||||||||||||
37296 | 37296 | Philip Crane C000873 | rep | IL | 1997-01-07 | 1999-01-03 | Republican | 8 | |||||||||||||
42233 | 42233 | Michael Crapo C000880 | rep | ID | 1997-01-07 | 1999-01-03 | Republican | 2 | |||||||||||||
37987 | 37987 | Barbara Cubin C000962 | rep | WY | 1997-01-07 | 1999-01-03 | Republican | 0 | |||||||||||||
41197 | 41197 | Elijah Cummings C000984 | rep | MD | 1997-01-07 | 1999-01-03 | Democrat | 7 | |||||||||||||
37583 | 37583 | Randall Cunningham C000994 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 51 | |||||||||||||
40267 | 40267 | Lois Capps C001036 | rep | CA | 1998-03-10 | 1999-01-03 | Democrat | 22 | |||||||||||||
35173 | 35173 | Alfonse D’Amato D000018 | sen | NY | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
36579 | 36579 | Pat Danner D000046 | rep | MO | 1997-01-07 | 1999-01-03 | Democrat | 6 | |||||||||||||
36586 | 36586 | Thomas Daschle D000064 | sen | SD | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
42253 | 42253 | Danny Davis D000096 | rep | IL | 1997-01-07 | 1999-01-03 | Democrat | 7 |
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);