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
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
36875 | 36875 | Gary Condit C000670 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 18 | |||||||||||||
36878 | 36878 | John Cooksey C000735 | rep | LA | 1997-01-07 | 1999-01-03 | Republican | 5 | |||||||||||||
36890 | 36890 | William Coyne C000846 | rep | PA | 1997-01-07 | 1999-01-03 | Democrat | 14 | |||||||||||||
36901 | 36901 | Robert Ehrlich E000093 | rep | MD | 1997-01-07 | 1999-01-03 | Republican | 2 | |||||||||||||
36907 | 36907 | Greg Ganske G000041 | rep | IA | 1997-01-07 | 1999-01-03 | Republican | 4 | |||||||||||||
36917 | 36917 | George Gekas G000121 | rep | PA | 1997-01-07 | 1999-01-03 | Republican | 17 | |||||||||||||
36932 | 36932 | Benjamin Gilman G000212 | rep | NY | 1997-01-07 | 1999-01-03 | Republican | 20 | |||||||||||||
36945 | 36945 | Tony Hall H000074 | rep | OH | 1997-01-07 | 1999-01-03 | Democrat | 3 | |||||||||||||
36956 | 36956 | James Hansen H000172 | rep | UT | 1997-01-07 | 1999-01-03 | Republican | 1 | |||||||||||||
36960 | 36960 | Van Hilleary H000615 | rep | TN | 1997-01-07 | 1999-01-03 | Republican | 4 | |||||||||||||
36965 | 36965 | Earl Hilliard H000621 | rep | AL | 1997-01-07 | 1999-01-03 | Democrat | 7 | |||||||||||||
36970 | 36970 | Stephen Horn H000789 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 38 | |||||||||||||
36973 | 36973 | Asa Hutchinson H001014 | rep | AR | 1997-01-07 | 1999-01-03 | Republican | 3 | |||||||||||||
36998 | 36998 | John LaFalce L000556 | rep | NY | 1997-01-07 | 1999-01-03 | Democrat | 29 | |||||||||||||
37003 | 37003 | Steve Largent L000096 | rep | OK | 1997-01-07 | 1999-01-03 | Republican | 1 | |||||||||||||
37007 | 37007 | William Luther L000521 | rep | MN | 1997-01-07 | 1999-01-03 | Democrat | 6 | |||||||||||||
37010 | 37010 | James Maloney M000090 | rep | CT | 1997-01-07 | 1999-01-03 | Democrat | 5 | |||||||||||||
37014 | 37014 | Frank Mascara M000212 | rep | PA | 1997-01-07 | 1999-01-03 | Democrat | 20 | |||||||||||||
37019 | 37019 | Carrie Meek M000628 | rep | FL | 1997-01-07 | 1999-01-03 | Democrat | 17 | |||||||||||||
37024 | 37024 | Dan Miller M000720 | rep | FL | 1997-01-07 | 1999-01-03 | Republican | 13 | |||||||||||||
37037 | 37037 | Patsy Mink M000797 | rep | HI | 1997-01-07 | 1999-01-03 | Democrat | 2 | |||||||||||||
37052 | 37052 | John Moakley M000834 | rep | MA | 1997-01-07 | 1999-01-03 | Democrat | 9 | |||||||||||||
37060 | 37060 | Constance Morella M000941 | rep | MD | 1997-01-07 | 1999-01-03 | Republican | 8 | |||||||||||||
37065 | 37065 | Bob Riley R000258 | rep | AL | 1997-01-07 | 1999-01-03 | Republican | 3 | |||||||||||||
37069 | 37069 | Lynn Rivers R000281 | rep | MI | 1997-01-07 | 1999-01-03 | Democrat | 13 | |||||||||||||
37075 | 37075 | Timothy Roemer R000385 | rep | IN | 1997-01-07 | 1999-01-03 | Democrat | 3 | |||||||||||||
37086 | 37086 | Marge Roukema R000465 | rep | NJ | 1997-01-07 | 1999-01-03 | Republican | 5 | |||||||||||||
37106 | 37106 | Thomas Sawyer S000094 | rep | OH | 1997-01-07 | 1999-01-03 | Democrat | 14 | |||||||||||||
37110 | 37110 | Joe Scarborough S000106 | rep | FL | 1997-01-07 | 1999-01-03 | Republican | 1 | |||||||||||||
37113 | 37113 | Bob Schaffer S000112 | rep | CO | 1997-01-07 | 1999-01-03 | Republican | 4 | |||||||||||||
37130 | 37130 | Elmer Shuster S000394 | rep | PA | 1997-01-07 | 1999-01-03 | Republican | 9 | |||||||||||||
37140 | 37140 | Norman Sisisky S000453 | rep | VA | 1997-01-07 | 1999-01-03 | Democrat | 4 | |||||||||||||
37151 | 37151 | Joseph Skeen S000463 | rep | NM | 1997-01-07 | 1999-01-03 | Republican | 2 | |||||||||||||
37167 | 37167 | Floyd Spence S000718 | rep | SC | 1997-01-07 | 1999-01-03 | Republican | 2 | |||||||||||||
37180 | 37180 | Robert Stump S001044 | rep | AZ | 1997-01-07 | 1999-01-03 | Republican | 3 | |||||||||||||
37185 | 37185 | Karen Thurman T000253 | rep | FL | 1997-01-07 | 1999-01-03 | Democrat | 5 | |||||||||||||
37194 | 37194 | James Traficant T000350 | rep | OH | 1997-01-07 | 1999-01-03 | Democrat | 17 | |||||||||||||
37199 | 37199 | Robert Underwood U000014 | rep | GU | 1997-01-07 | 1999-01-03 | Democrat | 0 | |||||||||||||
37209 | 37209 | Wes Watkins W000194 | rep | OK | 1997-01-07 | 1999-01-03 | Republican | 3 | |||||||||||||
37213 | 37213 | J.C. Watts W000210 | rep | OK | 1997-01-07 | 1999-01-03 | Republican | 4 | |||||||||||||
37219 | 37219 | James Talent T000024 | rep | MO | 1997-01-07 | 1999-01-03 | Republican | 2 | |||||||||||||
37236 | 37236 | Cass Ballenger B000104 | rep | NC | 1997-01-07 | 1999-01-03 | Republican | 10 | |||||||||||||
37250 | 37250 | Douglas Bereuter B000403 | rep | NE | 1997-01-07 | 1999-01-03 | Republican | 1 | |||||||||||||
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 | |||||||||||||
37296 | 37296 | Philip Crane C000873 | rep | IL | 1997-01-07 | 1999-01-03 | Republican | 8 | |||||||||||||
37302 | 37302 | Peter Deutsch D000275 | rep | FL | 1997-01-07 | 1999-01-03 | Democrat | 20 | |||||||||||||
37316 | 37316 | Calvin Dooley D000424 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 20 | |||||||||||||
37322 | 37322 | Jennifer Dunn D000549 | rep | WA | 1997-01-07 | 1999-01-03 | Republican | 8 | |||||||||||||
37338 | 37338 | Jonas Frost F000392 | rep | TX | 1997-01-07 | 1999-01-03 | Democrat | 24 | |||||||||||||
37352 | 37352 | Richard Gephardt G000132 | rep | MO | 1997-01-07 | 1999-01-03 | Democrat | 3 | |||||||||||||
37360 | 37360 | Porter Goss G000336 | rep | FL | 1997-01-07 | 1999-01-03 | Republican | 14 | |||||||||||||
37366 | 37366 | James Greenwood G000439 | rep | PA | 1997-01-07 | 1999-01-03 | Republican | 8 | |||||||||||||
37380 | 37380 | Amory Houghton H000814 | rep | NY | 1997-01-07 | 1999-01-03 | Republican | 31 | |||||||||||||
37385 | 37385 | Christopher John J000110 | rep | LA | 1997-01-07 | 1999-01-03 | Democrat | 7 | |||||||||||||
37396 | 37396 | Gerald Kleczka K000259 | rep | WI | 1997-01-07 | 1999-01-03 | Democrat | 4 | |||||||||||||
37407 | 37407 | William Lipinski L000342 | rep | IL | 1997-01-07 | 1999-01-03 | Democrat | 3 | |||||||||||||
37424 | 37424 | Robert Matsui M000249 | rep | CA | 1997-01-07 | 1999-01-03 | Democrat | 5 | |||||||||||||
37429 | 37429 | Karen McCarthy M000316 | rep | MO | 1997-01-07 | 1999-01-03 | Democrat | 5 | |||||||||||||
37435 | 37435 | Scott McInnis M000477 | rep | CO | 1997-01-07 | 1999-01-03 | Republican | 3 | |||||||||||||
37440 | 37440 | George Nethercutt N000051 | rep | WA | 1997-01-07 | 1999-01-03 | Republican | 5 | |||||||||||||
37449 | 37449 | Jack Quinn Q000016 | rep | NY | 1997-01-07 | 1999-01-03 | Republican | 30 | |||||||||||||
37453 | 37453 | Max Sandlin S000044 | rep | TX | 1997-01-07 | 1999-01-03 | Democrat | 1 | |||||||||||||
37463 | 37463 | Nick Smith S000597 | rep | MI | 1997-01-07 | 1999-01-03 | Republican | 7 | |||||||||||||
37476 | 37476 | Charles Stenholm S000851 | rep | TX | 1997-01-07 | 1999-01-03 | Democrat | 17 | |||||||||||||
37487 | 37487 | John Sununu S001078 | rep | NH | 1997-01-07 | 1999-01-03 | Republican | 1 | |||||||||||||
37500 | 37500 | William Tauzin T000058 | rep | LA | 1997-01-07 | 1999-01-03 | Republican | 3 | |||||||||||||
37504 | 37504 | James Turner T000424 | rep | TX | 1997-01-07 | 1999-01-03 | Democrat | 2 | |||||||||||||
37517 | 37517 | Robert Bennett B000382 | sen | UT | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
37527 | 37527 | Michael Bilirakis B000463 | rep | FL | 1997-01-07 | 1999-01-03 | Republican | 9 | |||||||||||||
37539 | 37539 | Sherwood Boehlert B000586 | rep | NY | 1997-01-07 | 1999-01-03 | Republican | 23 | |||||||||||||
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 | |||||||||||||
37558 | 37558 | Samuel Brownback B000953 | sen | KS | 1996-11-07 | 1999-01-03 | 3 | Republican | |||||||||||||
37566 | 37566 | Jim Bunning B001066 | rep | KY | 1997-01-07 | 1999-01-03 | Republican | 4 | |||||||||||||
37575 | 37575 | C. Cox C000830 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 47 | |||||||||||||
37583 | 37583 | Randall Cunningham C000994 | rep | CA | 1997-01-07 | 1999-01-03 | Republican | 51 | |||||||||||||
37588 | 37588 | James Davis D000114 | rep | FL | 1997-01-07 | 1999-01-03 | Democrat | 11 | |||||||||||||
37599 | 37599 | Thomas DeLay D000217 | rep | TX | 1997-01-07 | 1999-01-03 | Republican | 22 | |||||||||||||
37609 | 37609 | Christopher Dodd D000388 | sen | CT | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
37619 | 37619 | Byron Dorgan D000432 | sen | ND | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
37629 | 37629 | Lane Evans E000250 | rep | IL | 1997-01-07 | 1999-01-03 | Democrat | 17 | |||||||||||||
37634 | 37634 | Russell Feingold F000061 | sen | WI | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
37638 | 37638 | Mark Foley F000238 | rep | FL | 1997-01-07 | 1999-01-03 | Republican | 16 | |||||||||||||
37643 | 37643 | Harold Ford F000262 | rep | TN | 1997-01-07 | 1999-01-03 | Democrat | 9 | |||||||||||||
37648 | 37648 | James Gibbons G000152 | rep | NV | 1997-01-07 | 1999-01-03 | Republican | 2 | |||||||||||||
37661 | 37661 | Judd Gregg G000445 | sen | NH | 1993-01-05 | 1999-01-03 | 3 | Republican | |||||||||||||
37665 | 37665 | Gilbert Gutknecht G000536 | rep | MN | 1997-01-07 | 1999-01-03 | Republican | 1 | |||||||||||||
37676 | 37676 | John Hayworth H000413 | rep | AZ | 1997-01-07 | 1999-01-03 | Republican | 6 | |||||||||||||
37686 | 37686 | Joel Hefley H000444 | rep | CO | 1997-01-07 | 1999-01-03 | Republican | 5 | |||||||||||||
37692 | 37692 | John Hostettler H000807 | rep | IN | 1997-01-07 | 1999-01-03 | Republican | 8 | |||||||||||||
37708 | 37708 | Henry Hyde H001022 | rep | IL | 1997-01-07 | 1999-01-03 | Republican | 6 | |||||||||||||
37715 | 37715 | Ernest Istook I000047 | rep | OK | 1997-01-07 | 1999-01-03 | Republican | 5 | |||||||||||||
37720 | 37720 | William Jenkins J000082 | rep | TN | 1997-01-07 | 1999-01-03 | Republican | 1 | |||||||||||||
37732 | 37732 | Nancy Johnson J000163 | rep | CT | 1997-01-07 | 1999-01-03 | Republican | 6 | |||||||||||||
37738 | 37738 | Sue Kelly K000078 | rep | NY | 1997-01-07 | 1999-01-03 | Republican | 19 | |||||||||||||
37752 | 37752 | James Kolbe K000306 | rep | AZ | 1997-01-07 | 1999-01-03 | Republican | 5 | |||||||||||||
37767 | 37767 | James Leach L000169 | rep | IA | 1997-01-07 | 1999-01-03 | Republican | 1 | |||||||||||||
37779 | 37779 | Cynthia McKinney M000523 | rep | GA | 1997-01-07 | 1999-01-03 | Democrat | 4 | |||||||||||||
37784 | 37784 | Robert Ney N000081 | rep | OH | 1997-01-07 | 1999-01-03 | Republican | 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);